* Updated ChangeLog, which I forgot with the last commit.
[Packages/TYPO3.CMS.git] / 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