3 # Dump of tables for adesklets
5 # DATE : 26-02-2005 09:53:17 GMT
8 # TABLE: phpbb_auth_access
10 DROP TABLE IF EXISTS phpbb_auth_access;
11 CREATE TABLE phpbb_auth_access(
12 group_id mediumint(8) NOT NULL,
13 forum_id smallint(5) unsigned NOT NULL,
14 auth_view tinyint(1) NOT NULL,
15 auth_read tinyint(1) NOT NULL,
16 auth_post tinyint(1) NOT NULL,
17 auth_reply tinyint(1) NOT NULL,
18 auth_edit tinyint(1) NOT NULL,
19 auth_delete tinyint(1) NOT NULL,
20 auth_sticky tinyint(1) NOT NULL,
21 auth_announce tinyint(1) NOT NULL,
22 auth_vote tinyint(1) NOT NULL,
23 auth_pollcreate tinyint(1) NOT NULL,
24 auth_attachments tinyint(1) NOT NULL,
25 auth_mod tinyint(1) NOT NULL,
26 KEY group_id (group_id),
27 KEY forum_id (forum_id)
31 # Table Data for phpbb_auth_access
34 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('7', '6', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
35 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('7', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
36 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('8', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
37 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('8', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
38 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('8', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
39 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('8', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
40 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('7', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
41 INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('8', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');
43 # TABLE: phpbb_banlist
45 DROP TABLE IF EXISTS phpbb_banlist;
46 CREATE TABLE phpbb_banlist(
47 ban_id mediumint(8) unsigned NOT NULL auto_increment,
48 ban_userid mediumint(8) NOT NULL,
49 ban_ip varchar(8) NOT NULL,
50 ban_email varchar(255),
52 KEY ban_ip_user_id (ban_ip, ban_userid)
55 # TABLE: phpbb_categories
57 DROP TABLE IF EXISTS phpbb_categories;
58 CREATE TABLE phpbb_categories(
59 cat_id mediumint(8) unsigned NOT NULL auto_increment,
60 cat_title varchar(100),
61 cat_order mediumint(8) unsigned NOT NULL,
63 KEY cat_order (cat_order)
67 # Table Data for phpbb_categories
70 INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('3', 'Configuration/Compilation/Installation problems', '10');
71 INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('4', 'Requests', '20');
72 INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES('7', 'Miccelaneous', '30');
76 DROP TABLE IF EXISTS phpbb_config;
77 CREATE TABLE phpbb_config(
78 config_name varchar(255) NOT NULL,
79 config_value varchar(255) NOT NULL,
80 PRIMARY KEY (config_name)
84 # Table Data for phpbb_config
87 INSERT INTO phpbb_config (config_name, config_value) VALUES('config_id', '1');
88 INSERT INTO phpbb_config (config_name, config_value) VALUES('board_disable', '0');
89 INSERT INTO phpbb_config (config_name, config_value) VALUES('sitename', 'http://adesklets.sf.net/forum');
90 INSERT INTO phpbb_config (config_name, config_value) VALUES('site_desc', 'adesklets community forum');
91 INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_name', 'phpbb2mysql');
92 INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_path', '/');
93 INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_domain', '');
94 INSERT INTO phpbb_config (config_name, config_value) VALUES('cookie_secure', '0');
95 INSERT INTO phpbb_config (config_name, config_value) VALUES('session_length', '3600');
96 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_html', '0');
97 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_html_tags', 'b,i,u,pre');
98 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_bbcode', '1');
99 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_smilies', '1');
100 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_sig', '1');
101 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_namechange', '0');
102 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_theme_create', '0');
103 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_local', '0');
104 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_remote', '0');
105 INSERT INTO phpbb_config (config_name, config_value) VALUES('allow_avatar_upload', '0');
106 INSERT INTO phpbb_config (config_name, config_value) VALUES('enable_confirm', '1');
107 INSERT INTO phpbb_config (config_name, config_value) VALUES('override_user_style', '0');
108 INSERT INTO phpbb_config (config_name, config_value) VALUES('posts_per_page', '15');
109 INSERT INTO phpbb_config (config_name, config_value) VALUES('topics_per_page', '50');
110 INSERT INTO phpbb_config (config_name, config_value) VALUES('hot_threshold', '25');
111 INSERT INTO phpbb_config (config_name, config_value) VALUES('max_poll_options', '10');
112 INSERT INTO phpbb_config (config_name, config_value) VALUES('max_sig_chars', '255');
113 INSERT INTO phpbb_config (config_name, config_value) VALUES('max_inbox_privmsgs', '10');
114 INSERT INTO phpbb_config (config_name, config_value) VALUES('max_sentbox_privmsgs', '5');
115 INSERT INTO phpbb_config (config_name, config_value) VALUES('max_savebox_privmsgs', '5');
116 INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email_sig', 'Sylvain Fourmanoit');
117 INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email', 'syfou@users.sourceforge.net');
118 INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_delivery', '1');
119 INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_host', 'mail.sourceforge.net');
120 INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_username', '');
121 INSERT INTO phpbb_config (config_name, config_value) VALUES('smtp_password', '');
122 INSERT INTO phpbb_config (config_name, config_value) VALUES('sendmail_fix', '0');
123 INSERT INTO phpbb_config (config_name, config_value) VALUES('require_activation', '1');
124 INSERT INTO phpbb_config (config_name, config_value) VALUES('flood_interval', '15');
125 INSERT INTO phpbb_config (config_name, config_value) VALUES('board_email_form', '0');
126 INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_filesize', '6144');
127 INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_max_width', '80');
128 INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_max_height', '80');
129 INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_path', 'images/avatars');
130 INSERT INTO phpbb_config (config_name, config_value) VALUES('avatar_gallery_path', 'images/avatars/gallery');
131 INSERT INTO phpbb_config (config_name, config_value) VALUES('smilies_path', 'images/smiles');
132 INSERT INTO phpbb_config (config_name, config_value) VALUES('default_style', '1');
133 INSERT INTO phpbb_config (config_name, config_value) VALUES('default_dateformat', 'D M d, Y g:i a');
134 INSERT INTO phpbb_config (config_name, config_value) VALUES('board_timezone', '0');
135 INSERT INTO phpbb_config (config_name, config_value) VALUES('prune_enable', '1');
136 INSERT INTO phpbb_config (config_name, config_value) VALUES('privmsg_disable', '0');
137 INSERT INTO phpbb_config (config_name, config_value) VALUES('gzip_compress', '0');
138 INSERT INTO phpbb_config (config_name, config_value) VALUES('coppa_fax', '');
139 INSERT INTO phpbb_config (config_name, config_value) VALUES('coppa_mail', '');
140 INSERT INTO phpbb_config (config_name, config_value) VALUES('record_online_users', '1');
141 INSERT INTO phpbb_config (config_name, config_value) VALUES('record_online_date', '1109384140');
142 INSERT INTO phpbb_config (config_name, config_value) VALUES('server_name', 'adesklets.sourceforge.net');
143 INSERT INTO phpbb_config (config_name, config_value) VALUES('server_port', '80');
144 INSERT INTO phpbb_config (config_name, config_value) VALUES('script_path', '/forum/');
145 INSERT INTO phpbb_config (config_name, config_value) VALUES('version', '.0.12');
146 INSERT INTO phpbb_config (config_name, config_value) VALUES('board_startdate', '1109384077');
147 INSERT INTO phpbb_config (config_name, config_value) VALUES('default_lang', 'english');
149 # TABLE: phpbb_disallow
151 DROP TABLE IF EXISTS phpbb_disallow;
152 CREATE TABLE phpbb_disallow(
153 disallow_id mediumint(8) unsigned NOT NULL auto_increment,
154 disallow_username varchar(25) NOT NULL,
155 PRIMARY KEY (disallow_id)
158 # TABLE: phpbb_forums
160 DROP TABLE IF EXISTS phpbb_forums;
161 CREATE TABLE phpbb_forums(
162 forum_id smallint(5) unsigned NOT NULL,
163 cat_id mediumint(8) unsigned NOT NULL,
164 forum_name varchar(150),
166 forum_status tinyint(4) NOT NULL,
167 forum_order mediumint(8) unsigned DEFAULT '1' NOT NULL,
168 forum_posts mediumint(8) unsigned NOT NULL,
169 forum_topics mediumint(8) unsigned NOT NULL,
170 forum_last_post_id mediumint(8) unsigned NOT NULL,
172 prune_enable tinyint(1) NOT NULL,
173 auth_view tinyint(2) NOT NULL,
174 auth_read tinyint(2) NOT NULL,
175 auth_post tinyint(2) NOT NULL,
176 auth_reply tinyint(2) NOT NULL,
177 auth_edit tinyint(2) NOT NULL,
178 auth_delete tinyint(2) NOT NULL,
179 auth_sticky tinyint(2) NOT NULL,
180 auth_announce tinyint(2) NOT NULL,
181 auth_vote tinyint(2) NOT NULL,
182 auth_pollcreate tinyint(2) NOT NULL,
183 auth_attachments tinyint(2) NOT NULL,
184 PRIMARY KEY (forum_id),
185 KEY forums_order (forum_order),
187 KEY forum_last_post_id (forum_last_post_id)
191 # Table Data for phpbb_forums
194 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('1', '3', 'So it doesn\'t configure right', 'Post here if you have configuration problems.', '0', '10', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
195 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('2', '3', 'So it doesn\'t compile', 'Post here if you get compilation errors.', '0', '20', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
196 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('3', '3', 'So it installs, but there are still issues', 'Post here if install completed, but you cannot use a single deskle anyway, including test/test.py.', '0', '30', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
197 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('4', '4', 'About adesklets (core)', 'Post requests for adesklets core interpreter.', '0', '10', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
198 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('5', '4', 'About existing desklets', 'Post features request (bug fixes or others) concerning already existing desklets.', '0', '20', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
199 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('6', '4', 'About new desklets', 'Post here you ideas of what desklets you think would be nice.', '0', '30', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
200 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('7', '3', 'So there is a problem with a specific desklet', 'Post here your issues with specific desklets.', '0', '40', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
201 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('8', '7', 'Screenshots', 'Post your screenshots here.', '0', '20', '1', '1', '2', NULL, '0', '0', '0', '3', '0', '1', '1', '3', '3', '1', '3', '0');
202 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('9', '7', 'Off the wall', 'Post here everthing you couldn\'t post anywhere else.', '0', '30', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '1', '3', '3', '1', '1', '0');
203 INSERT INTO phpbb_forums (forum_id, cat_id, forum_name, forum_desc, forum_status, forum_order, forum_posts, forum_topics, forum_last_post_id, prune_next, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments) VALUES('10', '7', 'Announcements', 'Special announcements', '0', '10', '0', '0', '0', NULL, '0', '0', '0', '3', '3', '3', '3', '3', '3', '1', '3', '0');
205 # TABLE: phpbb_forum_prune
207 DROP TABLE IF EXISTS phpbb_forum_prune;
208 CREATE TABLE phpbb_forum_prune(
209 prune_id mediumint(8) unsigned NOT NULL auto_increment,
210 forum_id smallint(5) unsigned NOT NULL,
211 prune_days smallint(5) unsigned NOT NULL,
212 prune_freq smallint(5) unsigned NOT NULL,
213 PRIMARY KEY (prune_id),
214 KEY forum_id (forum_id)
217 # TABLE: phpbb_groups
219 DROP TABLE IF EXISTS phpbb_groups;
220 CREATE TABLE phpbb_groups(
221 group_id mediumint(8) NOT NULL auto_increment,
222 group_type tinyint(4) DEFAULT '1' NOT NULL,
223 group_name varchar(40) NOT NULL,
224 group_description varchar(255) NOT NULL,
225 group_moderator mediumint(8) NOT NULL,
226 group_single_user tinyint(1) DEFAULT '1' NOT NULL,
227 PRIMARY KEY (group_id),
228 KEY group_single_user (group_single_user)
232 # Table Data for phpbb_groups
235 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES('1', '1', 'Anonymous', 'Personal User', '0', '1');
236 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES('2', '1', 'Admin', 'Personal User', '0', '1');
237 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES('7', '0', 'Desklet author', 'Anyone who currently supports at least one working desklet', '2', '0');
238 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES('6', '1', '', 'Personal User', '0', '1');
239 INSERT INTO phpbb_groups (group_id, group_type, group_name, group_description, group_moderator, group_single_user) VALUES('8', '0', 'Core developer', 'Anyone who actively works on adesklets core interpreter package', '2', '0');
243 DROP TABLE IF EXISTS phpbb_posts;
244 CREATE TABLE phpbb_posts(
245 post_id mediumint(8) unsigned NOT NULL auto_increment,
246 topic_id mediumint(8) unsigned NOT NULL,
247 forum_id smallint(5) unsigned NOT NULL,
248 poster_id mediumint(8) NOT NULL,
249 post_time int(11) NOT NULL,
250 poster_ip varchar(8) NOT NULL,
251 post_username varchar(25),
252 enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
253 enable_html tinyint(1) NOT NULL,
254 enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
255 enable_sig tinyint(1) DEFAULT '1' NOT NULL,
256 post_edit_time int(11),
257 post_edit_count smallint(5) unsigned NOT NULL,
258 PRIMARY KEY (post_id),
259 KEY forum_id (forum_id),
260 KEY topic_id (topic_id),
261 KEY poster_id (poster_id),
262 KEY post_time (post_time)
266 # Table Data for phpbb_posts
269 INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count) VALUES('2', '2', '8', '2', '1109408814', '45466282', '', '1', '0', '1', '0', NULL, '0');
271 # TABLE: phpbb_posts_text
273 DROP TABLE IF EXISTS phpbb_posts_text;
274 CREATE TABLE phpbb_posts_text(
275 post_id mediumint(8) unsigned NOT NULL,
276 bbcode_uid varchar(10) NOT NULL,
277 post_subject varchar(60),
279 PRIMARY KEY (post_id)
283 # Table Data for phpbb_posts_text
286 INSERT INTO phpbb_posts_text (post_id, bbcode_uid, post_subject, post_text) VALUES('2', '5e25cdd980', 'Screenshots for the user gallery', 'Have any good adesklets screenshots you want to share with the world? Post them here!');
288 # TABLE: phpbb_privmsgs
290 DROP TABLE IF EXISTS phpbb_privmsgs;
291 CREATE TABLE phpbb_privmsgs(
292 privmsgs_id mediumint(8) unsigned NOT NULL auto_increment,
293 privmsgs_type tinyint(4) NOT NULL,
294 privmsgs_subject varchar(255) NOT NULL,
295 privmsgs_from_userid mediumint(8) NOT NULL,
296 privmsgs_to_userid mediumint(8) NOT NULL,
297 privmsgs_date int(11) NOT NULL,
298 privmsgs_ip varchar(8) NOT NULL,
299 privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
300 privmsgs_enable_html tinyint(1) NOT NULL,
301 privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
302 privmsgs_attach_sig tinyint(1) DEFAULT '1' NOT NULL,
303 PRIMARY KEY (privmsgs_id),
304 KEY privmsgs_from_userid (privmsgs_from_userid),
305 KEY privmsgs_to_userid (privmsgs_to_userid)
308 # TABLE: phpbb_privmsgs_text
310 DROP TABLE IF EXISTS phpbb_privmsgs_text;
311 CREATE TABLE phpbb_privmsgs_text(
312 privmsgs_text_id mediumint(8) unsigned NOT NULL,
313 privmsgs_bbcode_uid varchar(10) NOT NULL,
315 PRIMARY KEY (privmsgs_text_id)
320 DROP TABLE IF EXISTS phpbb_ranks;
321 CREATE TABLE phpbb_ranks(
322 rank_id smallint(5) unsigned NOT NULL auto_increment,
323 rank_title varchar(50) NOT NULL,
324 rank_min mediumint(8) NOT NULL,
325 rank_special tinyint(1),
326 rank_image varchar(255),
327 PRIMARY KEY (rank_id)
331 # Table Data for phpbb_ranks
334 INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES('1', 'Site Admin', '-1', '1', NULL);
336 # TABLE: phpbb_search_results
338 DROP TABLE IF EXISTS phpbb_search_results;
339 CREATE TABLE phpbb_search_results(
340 search_id int(11) unsigned NOT NULL,
341 session_id varchar(32) NOT NULL,
342 search_array text NOT NULL,
343 PRIMARY KEY (search_id),
344 KEY session_id (session_id)
348 # Table Data for phpbb_search_results
351 INSERT INTO phpbb_search_results (search_id, session_id, search_array) VALUES('822981272', 'bf2dc97b90e90211e0d4686d2204efc6', 'a:7:{s:14:\"search_results\";s:1:\"2\";s:17:\"total_match_count\";i:1;s:12:\"split_search\";N;s:7:\"sort_by\";i:0;s:8:\"sort_dir\";s:4:\"DESC\";s:12:\"show_results\";s:5:\"posts\";s:12:\"return_chars\";i:200;}');
353 # TABLE: phpbb_search_wordlist
355 DROP TABLE IF EXISTS phpbb_search_wordlist;
356 CREATE TABLE phpbb_search_wordlist(
357 word_text varchar(50) binary NOT NULL,
358 word_id mediumint(8) unsigned NOT NULL auto_increment,
359 word_common tinyint(1) unsigned NOT NULL,
360 PRIMARY KEY (word_text),
361 KEY word_id (word_id)
365 # Table Data for phpbb_search_wordlist
368 INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('phpbb', '3', '0');
369 INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('user', '24', '0');
370 INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('share', '23', '0');
371 INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('screenshots', '16', '0');
372 INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('post', '22', '0');
373 INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('gallery', '21', '0');
374 INSERT INTO phpbb_search_wordlist (word_text, word_id, word_common) VALUES('adesklets', '20', '0');
376 # TABLE: phpbb_search_wordmatch
378 DROP TABLE IF EXISTS phpbb_search_wordmatch;
379 CREATE TABLE phpbb_search_wordmatch(
380 post_id mediumint(8) unsigned NOT NULL,
381 word_id mediumint(8) unsigned NOT NULL,
382 title_match tinyint(1) NOT NULL,
383 KEY post_id (post_id),
384 KEY word_id (word_id)
388 # Table Data for phpbb_search_wordmatch
391 INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('2', '24', '1');
392 INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('2', '16', '1');
393 INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('2', '21', '1');
394 INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('2', '20', '0');
395 INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('2', '22', '0');
396 INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('2', '16', '0');
397 INSERT INTO phpbb_search_wordmatch (post_id, word_id, title_match) VALUES('2', '23', '0');
399 # TABLE: phpbb_sessions
401 DROP TABLE IF EXISTS phpbb_sessions;
402 CREATE TABLE phpbb_sessions(
403 session_id char(32) NOT NULL,
404 session_user_id mediumint(8) NOT NULL,
405 session_start int(11) NOT NULL,
406 session_time int(11) NOT NULL,
407 session_ip char(8) NOT NULL,
408 session_page int(11) NOT NULL,
409 session_logged_in tinyint(1) NOT NULL,
410 PRIMARY KEY (session_id),
411 KEY session_user_id (session_user_id),
412 KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
416 # Table Data for phpbb_sessions
419 INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES('bf2dc97b90e90211e0d4686d2204efc6', '2', '1109409305', '1109411545', '45466282', '0', '1');
421 # TABLE: phpbb_smilies
423 DROP TABLE IF EXISTS phpbb_smilies;
424 CREATE TABLE phpbb_smilies(
425 smilies_id smallint(5) unsigned NOT NULL auto_increment,
427 smile_url varchar(100),
428 emoticon varchar(75),
429 PRIMARY KEY (smilies_id)
433 # Table Data for phpbb_smilies
436 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('1', ':D', 'icon_biggrin.gif', 'Very Happy');
437 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('2', ':-D', 'icon_biggrin.gif', 'Very Happy');
438 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('3', ':grin:', 'icon_biggrin.gif', 'Very Happy');
439 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('4', ':)', 'icon_smile.gif', 'Smile');
440 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('5', ':-)', 'icon_smile.gif', 'Smile');
441 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('6', ':smile:', 'icon_smile.gif', 'Smile');
442 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('7', ':(', 'icon_sad.gif', 'Sad');
443 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('8', ':-(', 'icon_sad.gif', 'Sad');
444 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('9', ':sad:', 'icon_sad.gif', 'Sad');
445 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('10', ':o', 'icon_surprised.gif', 'Surprised');
446 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('11', ':-o', 'icon_surprised.gif', 'Surprised');
447 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('12', ':eek:', 'icon_surprised.gif', 'Surprised');
448 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('13', ':shock:', 'icon_eek.gif', 'Shocked');
449 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('14', ':?', 'icon_confused.gif', 'Confused');
450 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('15', ':-?', 'icon_confused.gif', 'Confused');
451 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('16', ':???:', 'icon_confused.gif', 'Confused');
452 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('17', '8)', 'icon_cool.gif', 'Cool');
453 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('18', '8-)', 'icon_cool.gif', 'Cool');
454 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('19', ':cool:', 'icon_cool.gif', 'Cool');
455 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('20', ':lol:', 'icon_lol.gif', 'Laughing');
456 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('21', ':x', 'icon_mad.gif', 'Mad');
457 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('22', ':-x', 'icon_mad.gif', 'Mad');
458 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('23', ':mad:', 'icon_mad.gif', 'Mad');
459 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('24', ':P', 'icon_razz.gif', 'Razz');
460 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('25', ':-P', 'icon_razz.gif', 'Razz');
461 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('26', ':razz:', 'icon_razz.gif', 'Razz');
462 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('27', ':oops:', 'icon_redface.gif', 'Embarassed');
463 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('28', ':cry:', 'icon_cry.gif', 'Crying or Very sad');
464 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('29', ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
465 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('30', ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
466 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('31', ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
467 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('32', ':wink:', 'icon_wink.gif', 'Wink');
468 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('33', ';)', 'icon_wink.gif', 'Wink');
469 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('34', ';-)', 'icon_wink.gif', 'Wink');
470 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('35', ':!:', 'icon_exclaim.gif', 'Exclamation');
471 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('36', ':?:', 'icon_question.gif', 'Question');
472 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('37', ':idea:', 'icon_idea.gif', 'Idea');
473 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('38', ':arrow:', 'icon_arrow.gif', 'Arrow');
474 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('39', ':|', 'icon_neutral.gif', 'Neutral');
475 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('40', ':-|', 'icon_neutral.gif', 'Neutral');
476 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('41', ':neutral:', 'icon_neutral.gif', 'Neutral');
477 INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES('42', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
479 # TABLE: phpbb_themes
481 DROP TABLE IF EXISTS phpbb_themes;
482 CREATE TABLE phpbb_themes(
483 themes_id mediumint(8) unsigned NOT NULL auto_increment,
484 template_name varchar(30) NOT NULL,
485 style_name varchar(30) NOT NULL,
486 head_stylesheet varchar(100),
487 body_background varchar(100),
488 body_bgcolor varchar(6),
489 body_text varchar(6),
490 body_link varchar(6),
491 body_vlink varchar(6),
492 body_alink varchar(6),
493 body_hlink varchar(6),
494 tr_color1 varchar(6),
495 tr_color2 varchar(6),
496 tr_color3 varchar(6),
497 tr_class1 varchar(25),
498 tr_class2 varchar(25),
499 tr_class3 varchar(25),
500 th_color1 varchar(6),
501 th_color2 varchar(6),
502 th_color3 varchar(6),
503 th_class1 varchar(25),
504 th_class2 varchar(25),
505 th_class3 varchar(25),
506 td_color1 varchar(6),
507 td_color2 varchar(6),
508 td_color3 varchar(6),
509 td_class1 varchar(25),
510 td_class2 varchar(25),
511 td_class3 varchar(25),
512 fontface1 varchar(50),
513 fontface2 varchar(50),
514 fontface3 varchar(50),
515 fontsize1 tinyint(4),
516 fontsize2 tinyint(4),
517 fontsize3 tinyint(4),
518 fontcolor1 varchar(6),
519 fontcolor2 varchar(6),
520 fontcolor3 varchar(6),
521 span_class1 varchar(25),
522 span_class2 varchar(25),
523 span_class3 varchar(25),
524 img_size_poll smallint(5) unsigned,
525 img_size_privmsg smallint(5) unsigned,
526 PRIMARY KEY (themes_id)
530 # Table Data for phpbb_themes
533 INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3, img_size_poll, img_size_privmsg) VALUES('1', 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \'Courier New\', sans-serif', '10', '11', '12', '444444', '006600', 'FFA34F', '', '', '', NULL, NULL);
535 # TABLE: phpbb_themes_name
537 DROP TABLE IF EXISTS phpbb_themes_name;
538 CREATE TABLE phpbb_themes_name(
539 themes_id smallint(5) unsigned NOT NULL,
540 tr_color1_name char(50),
541 tr_color2_name char(50),
542 tr_color3_name char(50),
543 tr_class1_name char(50),
544 tr_class2_name char(50),
545 tr_class3_name char(50),
546 th_color1_name char(50),
547 th_color2_name char(50),
548 th_color3_name char(50),
549 th_class1_name char(50),
550 th_class2_name char(50),
551 th_class3_name char(50),
552 td_color1_name char(50),
553 td_color2_name char(50),
554 td_color3_name char(50),
555 td_class1_name char(50),
556 td_class2_name char(50),
557 td_class3_name char(50),
558 fontface1_name char(50),
559 fontface2_name char(50),
560 fontface3_name char(50),
561 fontsize1_name char(50),
562 fontsize2_name char(50),
563 fontsize3_name char(50),
564 fontcolor1_name char(50),
565 fontcolor2_name char(50),
566 fontcolor3_name char(50),
567 span_class1_name char(50),
568 span_class2_name char(50),
569 span_class3_name char(50),
570 PRIMARY KEY (themes_id)
574 # Table Data for phpbb_themes_name
577 INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES('1', 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
579 # TABLE: phpbb_topics
581 DROP TABLE IF EXISTS phpbb_topics;
582 CREATE TABLE phpbb_topics(
583 topic_id mediumint(8) unsigned NOT NULL auto_increment,
584 forum_id smallint(8) unsigned NOT NULL,
585 topic_title char(60) NOT NULL,
586 topic_poster mediumint(8) NOT NULL,
587 topic_time int(11) NOT NULL,
588 topic_views mediumint(8) unsigned NOT NULL,
589 topic_replies mediumint(8) unsigned NOT NULL,
590 topic_status tinyint(3) NOT NULL,
591 topic_vote tinyint(1) NOT NULL,
592 topic_type tinyint(3) NOT NULL,
593 topic_first_post_id mediumint(8) unsigned NOT NULL,
594 topic_last_post_id mediumint(8) unsigned NOT NULL,
595 topic_moved_id mediumint(8) unsigned NOT NULL,
596 PRIMARY KEY (topic_id),
597 KEY forum_id (forum_id),
598 KEY topic_moved_id (topic_moved_id),
599 KEY topic_status (topic_status),
600 KEY topic_type (topic_type)
604 # Table Data for phpbb_topics
607 INSERT INTO phpbb_topics (topic_id, forum_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, topic_status, topic_vote, topic_type, topic_first_post_id, topic_last_post_id, topic_moved_id) VALUES('2', '8', 'Screenshots for the user gallery', '2', '1109408814', '3', '0', '0', '0', '1', '2', '2', '0');
609 # TABLE: phpbb_topics_watch
611 DROP TABLE IF EXISTS phpbb_topics_watch;
612 CREATE TABLE phpbb_topics_watch(
613 topic_id mediumint(8) unsigned NOT NULL,
614 user_id mediumint(8) NOT NULL,
615 notify_status tinyint(1) NOT NULL,
616 KEY topic_id (topic_id),
617 KEY user_id (user_id),
618 KEY notify_status (notify_status)
621 # TABLE: phpbb_user_group
623 DROP TABLE IF EXISTS phpbb_user_group;
624 CREATE TABLE phpbb_user_group(
625 group_id mediumint(8) NOT NULL,
626 user_id mediumint(8) NOT NULL,
627 user_pending tinyint(1),
628 KEY group_id (group_id),
629 KEY user_id (user_id)
633 # Table Data for phpbb_user_group
636 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES('1', '-1', '0');
637 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES('2', '2', '0');
638 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES('7', '2', '0');
639 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES('8', '2', '0');
640 INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES('6', '3', '0');
644 DROP TABLE IF EXISTS phpbb_users;
645 CREATE TABLE phpbb_users(
646 user_id mediumint(8) NOT NULL,
647 user_active tinyint(1) DEFAULT '1',
648 username varchar(25) NOT NULL,
649 user_password varchar(32) NOT NULL,
650 user_session_time int(11) NOT NULL,
651 user_session_page smallint(5) NOT NULL,
652 user_lastvisit int(11) NOT NULL,
653 user_regdate int(11) NOT NULL,
654 user_level tinyint(4),
655 user_posts mediumint(8) unsigned NOT NULL,
656 user_timezone decimal(5,2) DEFAULT '0.00' NOT NULL,
657 user_style tinyint(4),
658 user_lang varchar(255),
659 user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
660 user_new_privmsg smallint(5) unsigned NOT NULL,
661 user_unread_privmsg smallint(5) unsigned NOT NULL,
662 user_last_privmsg int(11) NOT NULL,
663 user_emailtime int(11),
664 user_viewemail tinyint(1),
665 user_attachsig tinyint(1),
666 user_allowhtml tinyint(1) DEFAULT '1',
667 user_allowbbcode tinyint(1) DEFAULT '1',
668 user_allowsmile tinyint(1) DEFAULT '1',
669 user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
670 user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
671 user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
672 user_notify tinyint(1) DEFAULT '1' NOT NULL,
673 user_notify_pm tinyint(1) NOT NULL,
674 user_popup_pm tinyint(1) NOT NULL,
676 user_avatar varchar(100),
677 user_avatar_type tinyint(4) NOT NULL,
678 user_email varchar(255),
679 user_icq varchar(15),
680 user_website varchar(100),
681 user_from varchar(100),
683 user_sig_bbcode_uid varchar(10),
684 user_aim varchar(255),
685 user_yim varchar(255),
686 user_msnm varchar(255),
687 user_occ varchar(100),
688 user_interests varchar(255),
689 user_actkey varchar(32),
690 user_newpasswd varchar(32),
691 PRIMARY KEY (user_id),
692 KEY user_session_time (user_session_time)
696 # Table Data for phpbb_users
699 INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('-1', '0', 'Anonymous', '', '0', '0', '0', '1109384077', '0', '0', '0.00', NULL, '', '', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '0', '1', '0', '1', '0', NULL, '', '0', '', '', '', '', '', NULL, '', '', '', '', '', '', '');
700 INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('2', '1', 'syfou', 'f4bcc1bebd2aef8d19655376828e01f7', '1109411545', '0', '1109408848', '1109384077', '1', '2', '-5.00', '1', 'english', 'd M Y h:i a', '0', '0', '1109404825', NULL, '1', '1', '0', '1', '0', '1', '1', '0', '0', '1', '0', '1', '', '0', 'syfou@users.sourceforge.net', '', '', 'Montreal, Canada', '--
701 Sylvain', '64bd76ace8', '', '', '', '', '', '', '');
702 INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('3', '1', 'test', 'f4bcc1bebd2aef8d19655376828e01f7', '1109409041', '1', '1109408132', '1109388049', '0', '0', '0.00', '1', 'english', 'D M d, Y g:i a', '0', '0', '0', NULL, '0', '1', '0', '1', '1', '1', '1', '1', '0', '1', '1', '0', '', '0', 'sourceforge@fourmanoit.ca', '', '', '', '', '', '', '', '', '', '', '', NULL);
704 # TABLE: phpbb_vote_desc
706 DROP TABLE IF EXISTS phpbb_vote_desc;
707 CREATE TABLE phpbb_vote_desc(
708 vote_id mediumint(8) unsigned NOT NULL auto_increment,
709 topic_id mediumint(8) unsigned NOT NULL,
710 vote_text text NOT NULL,
711 vote_start int(11) NOT NULL,
712 vote_length int(11) NOT NULL,
713 PRIMARY KEY (vote_id),
714 KEY topic_id (topic_id)
717 # TABLE: phpbb_vote_results
719 DROP TABLE IF EXISTS phpbb_vote_results;
720 CREATE TABLE phpbb_vote_results(
721 vote_id mediumint(8) unsigned NOT NULL,
722 vote_option_id tinyint(4) unsigned NOT NULL,
723 vote_option_text varchar(255) NOT NULL,
724 vote_result int(11) NOT NULL,
725 KEY vote_option_id (vote_option_id),
726 KEY vote_id (vote_id)
729 # TABLE: phpbb_vote_voters
731 DROP TABLE IF EXISTS phpbb_vote_voters;
732 CREATE TABLE phpbb_vote_voters(
733 vote_id mediumint(8) unsigned NOT NULL,
734 vote_user_id mediumint(8) NOT NULL,
735 vote_user_ip char(8) NOT NULL,
736 KEY vote_id (vote_id),
737 KEY vote_user_id (vote_user_id),
738 KEY vote_user_ip (vote_user_ip)
743 DROP TABLE IF EXISTS phpbb_words;
744 CREATE TABLE phpbb_words(
745 word_id mediumint(8) unsigned NOT NULL auto_increment,
746 word char(100) NOT NULL,
747 replacement char(100) NOT NULL,
748 PRIMARY KEY (word_id)
751 # TABLE: phpbb_confirm
753 DROP TABLE IF EXISTS phpbb_confirm;
754 CREATE TABLE phpbb_confirm(
755 confirm_id char(32) NOT NULL,
756 session_id char(32) NOT NULL,
757 code char(6) NOT NULL,
758 PRIMARY KEY (session_id, confirm_id)
762 # Table Data for phpbb_confirm
765 INSERT INTO phpbb_confirm (confirm_id, session_id, code) VALUES('2ca193e71d76aacdf0b6535f7bc65523', '4386de58ac6e2ef562ae0fe1c4f9aa16', 'GXDTEJ');
766 INSERT INTO phpbb_confirm (confirm_id, session_id, code) VALUES('3588976e60618e84bd539ca071707a8d', '4386de58ac6e2ef562ae0fe1c4f9aa16', 'I5Z58B');