Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `indexano` (
- `ID` SMALLINT( 3 ) NOT NULL ,
- `Title` VARCHAR( 32 ) NOT NULL ,
- `SecondTitle` VARCHAR( 50 ) NOT NULL ,
- `PostedBy` VARCHAR( 24 ) NOT NULL ,
- `PostedByID` MEDIUMINT( 6 ) NOT NULL ,
- `created_at` TIMESTAMP NOT NULL DEFAULTCURRENT_TIMESTAMP( ) ,
- `Text` TEXT CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL ,
- `ImgLink` VARCHAR( 128 ) NOT NULL ,
- `Skin` SMALLINT( 3 ) NOT NULL ,
- `updated_at` TIMESTAMP NOT NULL DEFAULTCURRENT_TIMESTAMP( ) ,
- `Views` MEDIUMINT( 6 ) NOT NULL
- ) ENGINE = INNODB AUTO_INCREMENT =15 DEFAULT CHARSET = latin1;
- MySQL zice: Documentație
- #1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement