Posted By

smoover on 03/12/09


Tagged

sql table create minimum


Versions (?)

sql: Create minimum table


 / Published in: SQL
 

  1. CREATE TABLE `ENTERYOURTABLENAMEHERE` (
  2. `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  3. `name` VARCHAR( 200 ) NOT NULL ,
  4. `created` DATETIME NOT NULL ,
  5. `modified` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
  6. UNIQUE (
  7. `name`
  8. )
  9. ) ENGINE = MYISAM

Report this snippet  

You need to login to post a comment.