code.progysm.com

CREATE TABLE

Syntaxe:
CREATE TABLE [IF NOT EXISTS] `tablename` (
  `nom` typedecl[ NOT NULL][ AUTOINCREMENT][ DEFAULT NULL|'value'],
  ...,
  PRIMARY KEY(`champ1`, `champ2`),
  KEY `nomkey1` (`champ3`, `champ4`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

Note:
	typedecl, voir les types de données