Posted By

smoover on 03/12/09

Tagged

sql
table

Versions (?)

Last Edited at 03/12/09 01:14pm

Statistics

Viewed 731 times

Favorited by 0 user(s)

Related snippets

sql: Create minimum table

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

CREATE TABLE `ENTERYOURTABLENAMEHERE` (
`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 200 ) NOT NULL ,
`created` DATETIME NOT NULL ,
`modified` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
UNIQUE (
`name`
)
) ENGINE = MYISAM