11 lines
453 B
MySQL
11 lines
453 B
MySQL
|
CREATE TABLE `twitter_content` (
|
||
|
|
`user_id` VARCHAR(50) NOT NULL,
|
||
|
|
`user_name` VARCHAR(100) NOT NULL,
|
||
|
|
`timestamp` BIGINT NOT NULL,
|
||
|
|
`date_time` VARCHAR(50) NOT NULL,
|
||
|
|
`text` TEXT NOT NULL,
|
||
|
|
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
||
|
|
UNIQUE KEY `uk_user_timestamp` (`user_id`, `timestamp`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|