listelements/ext_tables.sql at master · b13/listelements · GitHub

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
27
28
29
30
31
32
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
	tx_listelements_list int(4) DEFAULT '0' NOT NULL
);

#
# Table structure for table 'tx_listelements_item'
#
CREATE TABLE tx_listelements_item (

# Reference fields (basically same as MM table)
	sorting_foreign int(11) DEFAULT '0' NOT NULL,
	uid_foreign int(11) DEFAULT '0' NOT NULL,

# local usage fields
	tablename varchar(64) DEFAULT 'tt_content' NOT NULL,
	fieldname varchar(64) DEFAULT 'tx_listelements_list' NOT NULL,
	header varchar(255) DEFAULT '' NOT NULL,
	subheader varchar(255) DEFAULT '' NOT NULL,
	layout varchar(255) DEFAULT '' NOT NULL,
	text mediumtext,
	bodytext mediumtext,
	images int(11) unsigned DEFAULT '0' NOT NULL,
	assets int(11) unsigned DEFAULT '0' NOT NULL,
	link varchar(1024) DEFAULT '' NOT NULL,
	linklabel varchar(255) DEFAULT '' NOT NULL,
	linkconfig varchar(255) DEFAULT '' NOT NULL,

    KEY commonqueryindex (tablename, fieldname, uid_foreign)
);