Initial revision
[Packages/TYPO3.CMS.git] / misc / example_MM_relationTables.sql
1 # MySQL dump 8.14
2 #
3 # Host: localhost Database: t3_dummy
4 #--------------------------------------------------------
5 # Server version 3.23.40
6
7 #
8 # Table structure for table 'tt_content_records_MM'
9 #
10
11 CREATE TABLE tt_content_records_mm (
12 uid_local int(11) unsigned NOT NULL default '0',
13 uid_foreign int(11) unsigned NOT NULL default '0',
14 tablenames varchar(30) NOT NULL default '',
15 sorting int(11) unsigned NOT NULL default '0',
16 KEY uid_local (uid_local),
17 KEY uid_foreign (uid_foreign)
18 ) TYPE=MyISAM;
19
20 #
21 # Table structure for table 'tt_content_media_MM'
22 #
23
24 CREATE TABLE tt_content_media_mm (
25 uid_local int(11) unsigned NOT NULL default '0',
26 uid_foreign varchar(60) NOT NULL default '',
27 sorting int(11) unsigned NOT NULL default '0',
28 KEY uid_local (uid_local),
29 KEY uid_foreign (uid_foreign)
30 ) TYPE=MyISAM;
31