· 8 years ago · Apr 09, 2018, 11:22 PM
1mysql> CREATE TABLE IF NOT EXISTS `pictures` (
2 -> `id` INT NOT NULL AUTO_INCREMENT ,
3 -> `picture` VARCHAR(255) NOT NULL ,
4 -> `mimetype` VARCHAR(255) NOT NULL ,
5 -> `filesize` INT(11) NOT NULL ,
6 -> `created` DATETIME NOT NULL ,
7 -> `modified` DATETIME NULL ,
8 -> `user_id` CHAR(36) NOT NULL ,
9 -> `model` VARCHAR(45) NOT NULL ,
10 -> `remote_id` INT NOT NULL ,
11 -> PRIMARY KEY (`id`)
12 -> )
13 -> ENGINE = InnoDB
14 -> ;