forked from AgenturPottkinder/typo3_forum
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ext_tables_static+adt.sql
175 lines (154 loc) · 12.6 KB
/
ext_tables_static+adt.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
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
# TYPO3 Extension Manager dump 1.1
#
# Host: localhost Database: typo3_forum
#--------------------------------------------------------
#
# Table structure for table "tx_typo3forum_domain_model_format_textparser"
#
DROP TABLE IF EXISTS tx_typo3forum_domain_model_format_textparser;
CREATE TABLE tx_typo3forum_domain_model_format_textparser (
uid int(11) NOT NULL auto_increment,
pid int(11) NOT NULL default '0',
type varchar(64) NOT NULL default '\Mittwald\Typo3Forum\Domain\Model\Format\BBCode',
name tinytext,
icon_class tinytext,
bbcode_wrap varchar(64) default '',
regular_expression tinytext,
regular_expression_replacement tinytext,
smiley_shortcut varchar(16) default '',
language varchar(16) default '',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
t3ver_oid int(11) NOT NULL default '0',
t3ver_id int(11) NOT NULL default '0',
t3ver_wsid int(11) NOT NULL default '0',
t3ver_label varchar(30) NOT NULL default '',
t3ver_state tinyint(4) NOT NULL default '0',
t3ver_stage tinyint(4) NOT NULL default '0',
t3ver_count int(11) NOT NULL default '0',
t3ver_tstamp int(11) NOT NULL default '0',
t3ver_move_id int(11) NOT NULL default '0',
t3_origuid int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
l18n_parent int(11) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('1', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\BBCode', 'Bold', 'tx-typo3forum-miu-bold', '[b]|[/b]', '/\\[b\\](.*)\\[\\/b\\]/i', '<b>\\1</b>', NULL, NULL, '1288879482', '1284727514', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:5:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:18:"regular_expression";N;s:30:"regular_expression_replacement";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('2', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\BBCode', 'Italic', 'tx-typo3forum-miu-italic', '[i]|[/i]', '/\\[i\\](.*)\\[\\/i\\]/i', '<i>\\1</i>', NULL, NULL, '1288879482', '1284727514', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:5:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:18:"regular_expression";N;s:30:"regular_expression_replacement";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('3', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\QuoteBBCode', 'Quote', 'tx-typo3forum-miu-quote', '', NULL, NULL, NULL, NULL, '1288180606', '1288180540', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:3:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('4', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\BBCode', 'Image', 'tx-typo3forum-miu-picture', '[img]|[/img]', '/\\[img\\](.*)\\[\\/img\\]/i', '<img src="\\1" />', NULL, NULL, '1288879482', '1288183634', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:6:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:11:"bbcode_wrap";N;s:18:"regular_expression";N;s:30:"regular_expression_replacement";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('5', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\Smiley', 'Smile', 'smile.gif', NULL, NULL, NULL, ':)', NULL, '1288879482', '1288184040', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:15:"smiley_shortcut";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('6', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\Smiley', 'Wink', 'wink.gif', NULL, NULL, NULL, ';)', NULL, '1288879482', '1288188000', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:15:"smiley_shortcut";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('7', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\Smiley', 'Neutral', 'neutral.gif', NULL, NULL, NULL, ':|', NULL, '1288879482', '1288188066', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:15:"smiley_shortcut";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('8', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\Smiley', 'Angry', 'mad.gif', NULL, NULL, NULL, '>:(', NULL, '1288879482', '1288188107', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:15:"smiley_shortcut";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('9', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\Smiley', 'Sad', 'sad.gif', NULL, NULL, NULL, ':(', NULL, '1288879482', '1288188126', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:15:"smiley_shortcut";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('10', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\Smiley', 'Confused', 'confused.gif', NULL, NULL, NULL, ':/', NULL, '1288879482', '1288188156', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:15:"smiley_shortcut";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('11', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\ListBBCode', 'Unordered List', 'tx-typo3forum-miu-olist', NULL, NULL, NULL, NULL, NULL, '1288248587', '1288248572', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:3:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;}');
INSERT INTO tx_typo3forum_domain_model_format_textparser VALUES ('12', '0', '\Mittwald\Typo3Forum\Domain\Model\Format\SyntaxHighlighting', 'PHP', 'software-php.png', NULL, NULL, NULL, NULL, 'php', '1288865100', '1288274212', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:4:"icon";N;s:8:"language";N;}');
# TYPO3 Extension Manager dump 1.1
#
# Host: localhost Database: typo3_forum
#--------------------------------------------------------
#
# Table structure for table "tx_typo3forum_domain_model_moderation_reportworkflowstatus"
#
DROP TABLE IF EXISTS tx_typo3forum_domain_model_moderation_reportworkflowstatus;
CREATE TABLE tx_typo3forum_domain_model_moderation_reportworkflowstatus (
uid int(11) NOT NULL auto_increment,
pid int(11) NOT NULL default '0',
name tinytext,
icon tinytext,
followup_status int(11) unsigned NOT NULL default '0',
initial tinyint(1) NOT NULL default '0',
final tinyint(1) NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
t3ver_oid int(11) NOT NULL default '0',
t3ver_id int(11) NOT NULL default '0',
t3ver_wsid int(11) NOT NULL default '0',
t3ver_label varchar(30) NOT NULL default '',
t3ver_state tinyint(4) NOT NULL default '0',
t3ver_stage tinyint(4) NOT NULL default '0',
t3ver_count int(11) NOT NULL default '0',
t3ver_tstamp int(11) NOT NULL default '0',
t3ver_move_id int(11) NOT NULL default '0',
t3_origuid int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
l18n_parent int(11) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus VALUES ('1', '0', 'New', 'Status-New-16.png', '2', '1', '0', '1288789972', '1285078017', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:2:{s:4:"name";N;s:15:"followup_status";N;}');
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus VALUES ('2', '0', 'On hold', 'Status-OnHold-16.png', '1', '0', '0', '1288789972', '1285078026', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:2:{s:4:"name";N;s:15:"followup_status";N;}');
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus VALUES ('3', '0', 'In progress', 'Status-InProgress-16.png', '2', '0', '0', '1288789972', '1285078034', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:2:{s:4:"name";N;s:15:"followup_status";N;}');
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus VALUES ('4', '0', 'Closed', 'Status-Closed-16.png', '0', '0', '1', '1288789972', '1285078039', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:2:{s:4:"name";N;s:15:"followup_status";N;}');
# TYPO3 Extension Manager dump 1.1
#
# Host: localhost Database: typo3_forum
#--------------------------------------------------------
#
# Table structure for table "tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup"
#
DROP TABLE IF EXISTS tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup;
CREATE TABLE tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup (
uid int(10) NOT NULL auto_increment,
pid int(11) NOT NULL default '0',
uid_local int(11) unsigned NOT NULL default '0',
uid_foreign int(11) unsigned NOT NULL default '0',
sorting int(11) unsigned NOT NULL default '0',
sorting_foreign int(11) unsigned NOT NULL default '0',
tstamp int(10) unsigned NOT NULL default '0',
crdate int(10) unsigned NOT NULL default '0',
hidden tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (uid),
KEY parent (pid),
KEY uid_local (uid_local),
KEY uid_foreign (uid_foreign)
);
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup VALUES ('1', '0', '1', '2', '1', '0', '0', '0', '0');
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup VALUES ('2', '0', '1', '3', '2', '0', '0', '0', '0');
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup VALUES ('3', '0', '2', '3', '1', '0', '0', '0', '0');
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup VALUES ('4', '0', '3', '4', '1', '0', '0', '0', '0');
INSERT INTO tx_typo3forum_domain_model_moderation_reportworkflowstatus_followup VALUES ('5', '0', '3', '2', '2', '0', '0', '0', '0');
#
# Table structure for table "tx_typo3forum_domain_model_user_userfield_userfield"
#
DROP TABLE IF EXISTS tx_typo3forum_domain_model_user_userfield_userfield;
CREATE TABLE tx_typo3forum_domain_model_user_userfield_userfield (
uid int(11) NOT NULL auto_increment,
pid int(11) NOT NULL default '0',
type tinytext,
name tinytext,
typoscript_path tinytext,
map_to_user_object varchar(64) default '',
tstamp int(11) unsigned NOT NULL default '0',
crdate int(11) unsigned NOT NULL default '0',
deleted tinyint(4) unsigned NOT NULL default '0',
hidden tinyint(4) unsigned NOT NULL default '0',
t3ver_oid int(11) NOT NULL default '0',
t3ver_id int(11) NOT NULL default '0',
t3ver_wsid int(11) NOT NULL default '0',
t3ver_label varchar(30) NOT NULL default '',
t3ver_state tinyint(4) NOT NULL default '0',
t3ver_stage tinyint(4) NOT NULL default '0',
t3ver_count int(11) NOT NULL default '0',
t3ver_tstamp int(11) NOT NULL default '0',
t3ver_move_id int(11) NOT NULL default '0',
t3_origuid int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
l18n_parent int(11) NOT NULL default '0',
l18n_diffsource mediumblob NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
INSERT INTO tx_typo3forum_domain_model_user_userfield_userfield VALUES ('2', '0', '\Mittwald\Typo3Forum\Domain\Model\User\Userfield\TextUserfield', 'Telephone', NULL, 'telephone', '1288345900', '1288345828', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:3:{s:4:"type";N;s:4:"name";N;s:18:"map_to_user_object";N;}');
INSERT INTO tx_typo3forum_domain_model_user_userfield_userfield VALUES ('3', '0', '\Mittwald\Typo3Forum\Domain\Model\User\Userfield\TyposcriptUserfield', 'Country', 'plugin.tx_typo3forum.userfields.country', 'staticInfoCountry', '1288692309', '1288691535', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:15:"typoscript_path";N;s:18:"map_to_user_object";N;}');
INSERT INTO tx_typo3forum_domain_model_user_userfield_userfield VALUES ('4', '0', '\Mittwald\Typo3Forum\Domain\Model\User\Userfield\TyposcriptUserfield', 'Gender', 'plugin.tx_typo3forum.userfields.gender', 'gender', '1288694065', '1288694054', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:4:{s:4:"type";N;s:4:"name";N;s:15:"typoscript_path";N;s:18:"map_to_user_object";N;}');
INSERT INTO tx_typo3forum_domain_model_user_userfield_userfield VALUES ('5', '0', '\Mittwald\Typo3Forum\Domain\Model\User\Userfield\TextUserfield', 'City', NULL, 'zip|city', '1288694371', '1288694361', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', 'a:3:{s:4:"type";N;s:4:"name";N;s:18:"map_to_user_object";N;}');