-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
136 lines (121 loc) · 4.01 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
#
# Table structure for table 'tx_jvchat_entry'
#
CREATE TABLE tx_jvchat_entry (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted SMALLINT(4) DEFAULT '0' NOT NULL,
hidden SMALLINT(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
entry text DEFAULT '' NOT NULL,
feuser INT(11) NOT NULL,
tofeuser int(11) DEFAULT '0' NOT NULL,
room INT(11) NOT NULL,
style tinyint(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
INDEX room (room, crdate)
);
#
# Table structure for table 'tx_jvchat_room'
#
CREATE TABLE tx_jvchat_room (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted SMALLINT(4) DEFAULT '0' NOT NULL,
hidden SMALLINT(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
name tinytext DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
maxusercount int(11) DEFAULT '0' NOT NULL,
closed SMALLINT(3) DEFAULT '0' NOT NULL,
mode SMALLINT(3) DEFAULT '0' NOT NULL,
showfullnames SMALLINT(3) DEFAULT '0' NOT NULL,
moderators blob NOT NULL,
experts blob NOT NULL,
groupaccess blob NOT NULL,
superusergroup int(11) NOT NULL,
bannedusers blob NOT NULL,
welcomemessage text DEFAULT '' NOT NULL,
showuserinfo_experts blob NOT NULL,
showuserinfo_moderators blob NOT NULL,
showuserinfo_users blob NOT NULL,
showuserinfo_superusers blob NOT NULL,
enable_emoticons SMALLINT(4) DEFAULT '0' NOT NULL,
page int(11) NOT NULL,
image blob NOT NULL,
owner int(11) DEFAULT '0' NOT NULL,
private SMALLINT(4) DEFAULT '0' NOT NULL,
members blob NOT NULL,
notifyme blob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_jvchat_session'
#
CREATE TABLE tx_jvchat_session (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted SMALLINT(4) DEFAULT '0' NOT NULL,
hidden SMALLINT(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
name tinytext DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
startid int(11) DEFAULT '0' NOT NULL,
endid int(11) DEFAULT '0' NOT NULL,
room int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
CREATE TABLE tx_jvchat_room_feusers_mm (
uid_local int(11) unsigned DEFAULT '0' NOT NULL,
uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
tablenames varchar(30) DEFAULT '' NOT NULL,
invisible SMALLINT(4) unsigned DEFAULT '0' NOT NULL,
in_room SMALLINT(4) unsigned DEFAULT '0' NOT NULL,
userlistsnippet text DEFAULT '' NOT NULL,
tooltipsnippet text DEFAULT '' NOT NULL,
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
tx_jvchat_chatstyle tinyint(4) unsigned DEFAULT '0' NOT NULL,
);
CREATE TABLE tx_jvchat_messages (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
deleted SMALLINT(4) DEFAULT '0' NOT NULL,
hidden SMALLINT(4) DEFAULT '0' NOT NULL,
starttime int(11) DEFAULT '0' NOT NULL,
endtime int(11) DEFAULT '0' NOT NULL,
entry text DEFAULT '' NOT NULL,
feuser int(11) NOT NULL,
tofeuser int(11) DEFAULT '0' NOT NULL,
room int(11) NOT NULL,
style SMALLINT(4) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY starttime (starttime)
);