Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2021
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `indexano` (
  2.  
  3. `ID` SMALLINT( 3 ) NOT NULL ,
  4. `Title` VARCHAR( 32 ) NOT NULL ,
  5. `SecondTitle` VARCHAR( 50 ) NOT NULL ,
  6. `PostedBy` VARCHAR( 24 ) NOT NULL ,
  7. `PostedByID` MEDIUMINT( 6 ) NOT NULL ,
  8. `created_at` TIMESTAMP NOT NULL DEFAULTCURRENT_TIMESTAMP( ) ,
  9. `Text` TEXT CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL ,
  10. `ImgLink` VARCHAR( 128 ) NOT NULL ,
  11. `Skin` SMALLINT( 3 ) NOT NULL ,
  12. `updated_at` TIMESTAMP NOT NULL DEFAULTCURRENT_TIMESTAMP( ) ,
  13. `Views` MEDIUMINT( 6 ) NOT NULL
  14. ) ENGINE = INNODB AUTO_INCREMENT =15 DEFAULT CHARSET = latin1;
  15.  
  16. MySQL zice: Documentație
  17.  
  18. #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