misc/example_MM_relationTables.sql

   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