-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
53 lines (49 loc) · 1.63 KB
/
ext_tables.sql
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
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
#
# Table structure for table cf_sudhaus7viewhelpers_metatags
CREATE TABLE cf_sudhaus7viewhelpers_metatags (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
expires int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
content mediumblob,
lifetime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier)
);
#
# Table structure for table cf_sudhaus7viewhelpers_metatags_tags
#
CREATE TABLE cf_sudhaus7viewhelpers_metatags_tags (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
tag varchar(250) DEFAULT '' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY cache_tag (tag)
) ;
#
# Table structure for table cf_sudhaus7viewhelpers_cache
CREATE TABLE cf_sudhaus7viewhelpers_cache (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
expires int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
content mediumblob,
lifetime int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier)
) ;
#
# Table structure for table cf_sudhaus7viewhelpers_cache_tags
#
CREATE TABLE cf_sudhaus7viewhelpers_cache_tags (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
tag varchar(250) DEFAULT '' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY cache_tag (tag)
) ;
CREATE TABLE sys_file_reference (
tx_sudhaus7viewhelpers_posterimage varchar(256) DEFAULT '' NOT NULL
);