3 # Example MM
table for database relations
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
)
16 # Example MM
table for file attachments
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
)