File: example_MM_relationTables.sql

package info (click to toggle)
typo3-src 4.0.2%2Bdebian-9
  • links: PTS
  • area: main
  • in suites: etch
  • size: 29,956 kB
  • ctags: 33,382
  • sloc: php: 134,523; xml: 6,976; sh: 1,698; sql: 1,084; makefile: 45
file content (26 lines) | stat: -rw-r--r-- 609 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 

#
# Example MM table for database relations
#

CREATE TABLE example_db_mm (
  uid_local int(11) DEFAULT '0' NOT NULL,
  uid_foreign int(11) DEFAULT '0' NOT NULL,
  tablenames varchar(30) DEFAULT '' NOT NULL,
  sorting int(11) DEFAULT '0' NOT NULL,
  KEY uid_local (uid_local),
  KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;

#
# Example MM table for file attachments
#

CREATE TABLE example_files_mm (
  uid_local int(11) DEFAULT '0' NOT NULL,
  uid_foreign varchar(60) DEFAULT '' NOT NULL,
  sorting int(11) DEFAULT '0' NOT NULL,
  KEY uid_local (uid_local),
  KEY uid_foreign (uid_foreign)
) TYPE=MyISAM;