[Sommaire] [Imprimer]

   1  Create database sampledb;
   2  use sampledb;
   3  CREATE TABLE Tree (
   4    item_id INT UNSIGNED not null AUTO_INCREMENT,
   5    item_nm VARCHAR (200) DEFAULT '0',
   6    item_order INT  UNSIGNED DEFAULT '0',
   7    item_desc TEXT ,
   8    item_parent_id INT UNSIGNED DEFAULT '0',
   9    PRIMARY KEY ( item_id )
  10    )