sql: Create minimum table


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.