forked from rupertgermann/tt_news
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables.sql
161 lines (139 loc) · 4.44 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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
#
# Table structure for table 'tt_news'
#
CREATE TABLE tt_news (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
fe_group varchar(100) DEFAULT '0' NOT NULL,
title text,
datetime int(11) unsigned DEFAULT '0' NOT NULL,
image text,
imagecaption text,
imagealttext text,
imagetitletext text,
related int(11) DEFAULT '0' NOT NULL,
short text,
bodytext mediumtext,
author varchar(255) DEFAULT '' NOT NULL,
author_email varchar(255) DEFAULT '' NOT NULL,
category int(11) DEFAULT '0' NOT NULL,
news_files text,
links text,
type tinyint(4) DEFAULT '0' NOT NULL,
page int(11) DEFAULT '0' NOT NULL,
keywords text,
archivedate int(11) DEFAULT '0' NOT NULL,
ext_url varchar(255) DEFAULT '' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
l10n_state text,
no_auto_pb tinyint(4) unsigned DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
t3ver_count int(11) DEFAULT '0' NOT NULL,
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
t3_origuid int(11) DEFAULT '0' NOT NULL,
t3ver_move_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY t3ver_oid (t3ver_oid,t3ver_wsid),
KEY datetime (datetime)
);
#
# Table structure for table 'tt_news_cat'
#
CREATE TABLE tt_news_cat (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
fe_group varchar(100) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
title_lang_ol varchar(255) DEFAULT '' NOT NULL,
image varchar(255) DEFAULT '' NOT NULL,
shortcut int(11) unsigned DEFAULT '0' NOT NULL,
shortcut_target varchar(255) DEFAULT '' NOT NULL,
deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
single_pid int(11) unsigned DEFAULT '0' NOT NULL,
parent_category int(11) unsigned DEFAULT '0' NOT NULL,
description text,
PRIMARY KEY (uid),
KEY parent (pid),
KEY parent_category (parent_category)
);
#
# Table structure for table 'tt_news_related_mm'
#
CREATE TABLE tt_news_related_mm (
uid_local int(11) DEFAULT '0' NOT NULL,
uid_foreign int(11) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
tablenames varchar(255) DEFAULT '' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'tt_news_cat_mm'
#
CREATE TABLE tt_news_cat_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)
);
#
# Table structure for table 'be_groups'
#
CREATE TABLE be_groups (
tt_news_categorymounts varchar(255) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'be_users'
#
CREATE TABLE be_users (
tt_news_categorymounts varchar(255) DEFAULT '' NOT NULL,
);
#
# Table structure for table 'tt_news_cache'
#
CREATE TABLE tt_news_cache (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(32) DEFAULT '' NOT NULL,
content text NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
lifetime int(11) DEFAULT '0' NOT NULL,
tags varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY tags (tags)
) ENGINE=InnoDB;
#
# Table structure for table 'tt_news_cache_tags'
#
CREATE TABLE tt_news_cache_tags (
id int(11) unsigned NOT NULL auto_increment,
identifier varchar(128) DEFAULT '' NOT NULL,
tag varchar(128) DEFAULT '' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY cache_tag (tag)
) ENGINE=InnoDB;