· 5 years ago · Oct 05, 2020, 02:06 AM
1CREATE_TABLE_USER_SENTENCE = '
2CREATE TABLE IF NOT EXISTS `medium_clone`.`user` (
3 `id` INT NOT NULL AUTO_INCREMENT,
4 `create_at` DATETIME NOT NULL,
5 `update_at` DATETIME NULL,
6 `username` VARCHAR(20) NOT NULL,
7 `password` VARCHAR(15) NOT NULL,
8 `email` VARCHAR(255) NOT NULL,
9 `first_name` VARCHAR(45) NOT NULL,
10 `last_name` VARCHAR(45) NOT NULL,
11 `bio` VARCHAR(80) NULL,
12 `user_picture` TEXT NULL,
13 `token` VARCHAR(25) NULL,
14 `toke_at` DATETIME NULL,
15 `slug` VARCHAR(45) NOT NULL,
16 PRIMARY KEY (`id`));
17'