[Sommaire] [Imprimer]

   1  
   2  #
   3  # Example MM table for database relations
   4  #
   5  
   6  CREATE TABLE example_db_mm (
   7    uid_local int(11) DEFAULT '0' NOT NULL,
   8    uid_foreign int(11) DEFAULT '0' NOT NULL,
   9    tablenames varchar(30) DEFAULT '' NOT NULL,
  10    sorting int(11) DEFAULT '0' NOT NULL,
  11    KEY uid_local (uid_local),
  12    KEY uid_foreign (uid_foreign)
  13  ) TYPE=MyISAM;
  14  
  15  #
  16  # Example MM table for file attachments
  17  #
  18  
  19  CREATE TABLE example_files_mm (
  20    uid_local int(11) DEFAULT '0' NOT NULL,
  21    uid_foreign varchar(60) DEFAULT '' NOT NULL,
  22    sorting int(11) DEFAULT '0' NOT NULL,
  23    KEY uid_local (uid_local),
  24    KEY uid_foreign (uid_foreign)
  25  ) TYPE=MyISAM;
  26