-
-
Notifications
You must be signed in to change notification settings - Fork 20
/
ext_tables.sql
125 lines (108 loc) · 3.22 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
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
irre_parentid int(11) DEFAULT '0' NOT NULL,
irre_parenttable varchar(20) DEFAULT '' NOT NULL
);
#
# Table structure for table 'tx_t3blog_post'
#
CREATE TABLE tx_t3blog_post (
title tinytext NOT NULL,
url_segment varchar(255) DEFAULT '' NOT NULL,
author int(11) DEFAULT '0' NOT NULL,
date int(11) DEFAULT '0' NOT NULL,
content text NOT NULL,
allow_comments int(11) DEFAULT '0' NOT NULL,
cat int(11) DEFAULT '0' NOT NULL,
tagClouds text NOT NULL,
trackback text NOT NULL,
trackback_hash varchar(130) DEFAULT '' NOT NULL,
number_views int(11) DEFAULT '0' NOT NULL,
meta_description text,
meta_keywords varchar(255) DEFAULT '',
preview_mode tinyint(4) DEFAULT '0' NOT NULL,
preview_text text,
preview_image int(11) unsigned DEFAULT '0',
mails_sent tinyint(3) DEFAULT NULL
);
#
# Table structure for table 'tx_t3blog_cat'
#
CREATE TABLE tx_t3blog_cat (
parent_id int(11) DEFAULT '0' NOT NULL,
catname tinytext NOT NULL,
url_segment varchar(255) DEFAULT '' NOT NULL,
description tinytext NOT NULL
);
#
# Table structure for table 'tx_t3blog_com'
#
CREATE TABLE tx_t3blog_com (
title tinytext NOT NULL,
author tinytext NOT NULL,
email tinytext NOT NULL,
website tinytext NOT NULL,
date int(11) DEFAULT '0' NOT NULL,
text text NOT NULL,
approved tinyint(3) DEFAULT '0' NOT NULL,
spam tinyint(3) DEFAULT '0' NOT NULL,
fk_post int(11) DEFAULT '0' NOT NULL,
mails_sent tinyint(3) DEFAULT NULL,
privacy_policy_accepted tinyint(4) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_t3blog_com_nl'
#
CREATE TABLE tx_t3blog_com_nl (
email tinytext NOT NULL,
name tinytext NOT NULL,
post_uid int(11) DEFAULT '0' NOT NULL,
lastsent int(11) DEFAULT '0' NOT NULL,
code varchar(32) DEFAULT '' NOT NULL,
privacy_policy_accepted tinyint(4) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_t3blog_blog_nl'
#
CREATE TABLE tx_t3blog_blog_nl (
email tinytext NOT NULL,
lastsent int(11) DEFAULT '0' NOT NULL,
code varchar(32) DEFAULT '' NOT NULL,
privacy_policy_accepted tinyint(4) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_t3blog_pingback'
#
CREATE TABLE tx_t3blog_pingback (
deleted tinyint(1) DEFAULT '0' NOT NULL,
hidden tinyint(1) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
url tinytext NOT NULL,
date int(11) DEFAULT '0' NOT NULL,
text text NOT NULL
);
#
# Table structure for table 'tx_t3blog_trackback'
#
CREATE TABLE tx_t3blog_trackback (
fromurl varchar(100) DEFAULT '' NOT NULL,
text varchar(255) DEFAULT '' NOT NULL,
title varchar(50) DEFAULT '' NOT NULL,
blogname varchar(100) DEFAULT '' NOT NULL,
postid int(11) DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_t3blog_post_cat_mm'
#
CREATE TABLE tx_t3blog_post_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)
);