jVVaQeTh

1#
2# phpBB Backup Script
3# Dump of tables for krolewscy
4#
5# DATE : 20-04-2012 15:46:15 GMT
6#
7#
8# TABLE: phpbb_auth_access
9#
10DROP TABLE IF EXISTS phpbb_auth_access;
11CREATE 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	auth_minusp tinyint(1) NOT NULL, 
27	KEY group_id (group_id), 
28	KEY forum_id (forum_id)
29);
30#
31# TABLE: phpbb_banlist
32#
33DROP TABLE IF EXISTS phpbb_banlist;
34CREATE TABLE phpbb_banlist(
35	ban_id mediumint(8) unsigned NOT NULL auto_increment,
36	ban_userid mediumint(8) NOT NULL,
37	ban_ip varchar(8) NOT NULL,
38	ban_email varchar(255),
39	ban_time int(11),
40	ban_expire_time int(11),
41	ban_by_userid mediumint(8),
42	ban_priv_reason text,
43	ban_pub_reason_mode tinyint(1),
44	ban_pub_reason text, 
45	PRIMARY KEY (ban_id), 
46	KEY ban_ip_user_id (ban_ip, ban_userid)
47);
48#
49# TABLE: phpbb_categories
50#
51DROP TABLE IF EXISTS phpbb_categories;
52CREATE TABLE phpbb_categories(
53	cat_id mediumint(8) unsigned NOT NULL auto_increment,
54	cat_title varchar(100),
55	cat_order mediumint(8) unsigned NOT NULL, 
56	PRIMARY KEY (cat_id), 
57	KEY cat_order (cat_order)
58);
59#
60# TABLE: phpbb_config
61#
62DROP TABLE IF EXISTS phpbb_config;
63CREATE TABLE phpbb_config(
64	config_name varchar(255) NOT NULL,
65	config_value varchar(255) NOT NULL, 
66	PRIMARY KEY (config_name)
67);
68#
69# TABLE: phpbb_disallow
70#
71DROP TABLE IF EXISTS phpbb_disallow;
72CREATE TABLE phpbb_disallow(
73	disallow_id mediumint(8) unsigned NOT NULL auto_increment,
74	disallow_username varchar(25), 
75	PRIMARY KEY (disallow_id)
76);
77#
78# TABLE: phpbb_forums
79#
80DROP TABLE IF EXISTS phpbb_forums;
81CREATE TABLE phpbb_forums(
82	forum_id smallint(5) unsigned NOT NULL,
83	cat_id mediumint(8) unsigned NOT NULL,
84	forum_name varchar(150),
85	forum_desc text,
86	forum_status tinyint(4) NOT NULL,
87	forum_order mediumint(8) unsigned DEFAULT '1' NOT NULL,
88	forum_posts mediumint(8) unsigned NOT NULL,
89	forum_topics mediumint(8) unsigned NOT NULL,
90	forum_last_post_id mediumint(8) unsigned NOT NULL,
91	prune_next int(11),
92	prune_enable tinyint(1) NOT NULL,
93	auth_view tinyint(2) NOT NULL,
94	auth_read tinyint(2) NOT NULL,
95	auth_post tinyint(2) NOT NULL,
96	auth_reply tinyint(2) NOT NULL,
97	auth_edit tinyint(2) NOT NULL,
98	auth_delete tinyint(2) NOT NULL,
99	auth_sticky tinyint(2) NOT NULL,
100	auth_announce tinyint(2) NOT NULL,
101	auth_vote tinyint(2) NOT NULL,
102	auth_pollcreate tinyint(2) NOT NULL,
103	auth_attachments tinyint(2) NOT NULL,
104	enable_pluspoints tinyint(1) DEFAULT '1' NOT NULL,
105	enable_minuspoints tinyint(1) DEFAULT '1' NOT NULL,
106	auth_minusp tinyint(2) DEFAULT '3' NOT NULL,
107	forum_postcount tinyint(1) DEFAULT '1' NOT NULL,
108	forum_password varchar(20) NOT NULL, 
109	PRIMARY KEY (forum_id), 
110	KEY forums_order (forum_order), 
111	KEY cat_id (cat_id), 
112	KEY forum_last_post_id (forum_last_post_id)
113);
114#
115# TABLE: phpbb_forum_prune
116#
117DROP TABLE IF EXISTS phpbb_forum_prune;
118CREATE TABLE phpbb_forum_prune(
119	prune_id mediumint(8) unsigned NOT NULL auto_increment,
120	forum_id smallint(5) unsigned NOT NULL,
121	prune_days smallint(5) unsigned NOT NULL,
122	prune_freq smallint(5) unsigned NOT NULL, 
123	PRIMARY KEY (prune_id), 
124	KEY forum_id (forum_id)
125);
126#
127# TABLE: phpbb_groups
128#
129DROP TABLE IF EXISTS phpbb_groups;
130CREATE TABLE phpbb_groups(
131	group_id mediumint(8) NOT NULL auto_increment,
132	group_type tinyint(4) DEFAULT '1' NOT NULL,
133	group_name varchar(40) NOT NULL,
134	group_description varchar(255) NOT NULL,
135	group_moderator mediumint(8) NOT NULL,
136	group_single_user tinyint(1) DEFAULT '1' NOT NULL,
137	auth_disallow_write tinyint(11) NOT NULL,
138	auth_ban tinyint(4) NOT NULL,
139	auth_remove_points tinyint(1) NOT NULL,
140	group_rank int(11) unsigned,
141	group_rank_mod int(11) unsigned,
142	group_rank_user int(11) unsigned, 
143	PRIMARY KEY (group_id), 
144	KEY group_single_user (group_single_user)
145);
146#
147# TABLE: phpbb_posts
148#
149DROP TABLE IF EXISTS phpbb_posts;
150CREATE TABLE phpbb_posts(
151	post_id mediumint(8) unsigned NOT NULL auto_increment,
152	topic_id mediumint(8) unsigned NOT NULL,
153	forum_id smallint(5) unsigned NOT NULL,
154	poster_id mediumint(8) NOT NULL,
155	post_time int(11) NOT NULL,
156	poster_ip varchar(8) NOT NULL,
157	post_username varchar(25),
158	enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
159	enable_html tinyint(1) NOT NULL,
160	enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
161	enable_sig tinyint(1) DEFAULT '1' NOT NULL,
162	post_edit_time int(11),
163	post_edit_count smallint(5) unsigned NOT NULL,
164	post_plusp int(2) unsigned NOT NULL,
165	post_minusp int(2) unsigned NOT NULL,
166	notice int(1) unsigned, 
167	PRIMARY KEY (post_id), 
168	KEY forum_id (forum_id), 
169	KEY topic_id (topic_id), 
170	KEY poster_id (poster_id), 
171	KEY post_time (post_time)
172);
173#
174# TABLE: phpbb_posts_text
175#
176DROP TABLE IF EXISTS phpbb_posts_text;
177CREATE TABLE phpbb_posts_text(
178	post_id mediumint(8) unsigned NOT NULL,
179	bbcode_uid varchar(10) NOT NULL,
180	post_subject varchar(60),
181	post_text text,
182	mods_notice text, 
183	PRIMARY KEY (post_id)
184);
185#
186# TABLE: phpbb_privmsgs
187#
188DROP TABLE IF EXISTS phpbb_privmsgs;
189CREATE TABLE phpbb_privmsgs(
190	privmsgs_id mediumint(8) unsigned NOT NULL auto_increment,
191	privmsgs_type tinyint(4) NOT NULL,
192	privmsgs_subject varchar(255) NOT NULL,
193	privmsgs_from_userid mediumint(8) NOT NULL,
194	privmsgs_to_userid mediumint(8) NOT NULL,
195	privmsgs_date int(11) NOT NULL,
196	privmsgs_ip varchar(8) NOT NULL,
197	privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
198	privmsgs_enable_html tinyint(1) NOT NULL,
199	privmsgs_enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
200	privmsgs_attach_sig tinyint(1) DEFAULT '1' NOT NULL, 
201	PRIMARY KEY (privmsgs_id), 
202	KEY privmsgs_from_userid (privmsgs_from_userid), 
203	KEY privmsgs_to_userid (privmsgs_to_userid)
204);
205#
206# TABLE: phpbb_privmsgs_text
207#
208DROP TABLE IF EXISTS phpbb_privmsgs_text;
209CREATE TABLE phpbb_privmsgs_text(
210	privmsgs_text_id mediumint(8) unsigned NOT NULL,
211	privmsgs_bbcode_uid varchar(10) NOT NULL,
212	privmsgs_text text, 
213	PRIMARY KEY (privmsgs_text_id)
214);
215#
216# TABLE: phpbb_ranks
217#
218DROP TABLE IF EXISTS phpbb_ranks;
219CREATE TABLE phpbb_ranks(
220	rank_id smallint(5) unsigned NOT NULL auto_increment,
221	rank_title varchar(50) NOT NULL,
222	rank_min mediumint(8) NOT NULL,
223	rank_special tinyint(1),
224	rank_image varchar(255),
225	rank_color varchar(255),
226	rank_bold int(2) unsigned NOT NULL,
227	rank_prefix varchar(32),
228	rank_style varchar(255),
229	rank_list int(2) unsigned NOT NULL,
230	rank_order int(11) unsigned NOT NULL,
231	rank_onlygfx int(2) unsigned NOT NULL,
232	rank_titlelist varchar(50),
233	rank_female varchar(50),
234	rank_ignore_nick int(2) unsigned NOT NULL,
235	rank_ignore_rank int(2) unsigned NOT NULL,
236	rank_show_ekipa int(2) unsigned NOT NULL,
237	rank_group_ekipa int(11) unsigned NOT NULL, 
238	PRIMARY KEY (rank_id)
239);
240#
241# TABLE: phpbb_search_results
242#
243DROP TABLE IF EXISTS phpbb_search_results;
244CREATE TABLE phpbb_search_results(
245	search_id int(11) unsigned NOT NULL,
246	session_id varchar(32) NOT NULL,
247	search_array text NOT NULL,
248	search_time int(11) NOT NULL, 
249	PRIMARY KEY (search_id), 
250	KEY session_id (session_id)
251);
252#
253# TABLE: phpbb_search_wordlist
254#
255DROP TABLE IF EXISTS phpbb_search_wordlist;
256CREATE TABLE phpbb_search_wordlist(
257	word_text varchar(50) NOT NULL,
258	word_id mediumint(8) unsigned NOT NULL auto_increment,
259	word_common tinyint(1) unsigned NOT NULL, 
260	PRIMARY KEY (word_text), 
261	KEY word_id (word_id)
262);
263#
264# TABLE: phpbb_search_wordmatch
265#
266DROP TABLE IF EXISTS phpbb_search_wordmatch;
267CREATE TABLE phpbb_search_wordmatch(
268	post_id mediumint(8) unsigned NOT NULL,
269	word_id mediumint(8) unsigned NOT NULL,
270	title_match tinyint(1) NOT NULL, 
271	KEY word_id (word_id), 
272	KEY post_id (post_id)
273);
274#
275# TABLE: phpbb_sessions
276#
277DROP TABLE IF EXISTS phpbb_sessions;
278CREATE TABLE phpbb_sessions(
279	session_id char(32) NOT NULL,
280	session_user_id mediumint(8) NOT NULL,
281	session_start int(11) NOT NULL,
282	session_time int(11) NOT NULL,
283	session_ip char(8) NOT NULL,
284	session_page int(11) NOT NULL,
285	session_logged_in tinyint(1) NOT NULL,
286	session_admin int(11) NOT NULL, 
287	PRIMARY KEY (session_id), 
288	KEY session_user_id (session_user_id), 
289	KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
290);
291#
292# TABLE: phpbb_smilies
293#
294DROP TABLE IF EXISTS phpbb_smilies;
295CREATE TABLE phpbb_smilies(
296	smilies_id smallint(5) unsigned NOT NULL auto_increment,
297	code varchar(50),
298	smile_url varchar(100),
299	emoticon varchar(75),
300	smilies_order int(5) NOT NULL, 
301	PRIMARY KEY (smilies_id)
302);
303#
304# TABLE: phpbb_themes
305#
306DROP TABLE IF EXISTS phpbb_themes;
307CREATE TABLE phpbb_themes(
308	themes_id mediumint(8) unsigned NOT NULL auto_increment,
309	template_name varchar(30) NOT NULL,
310	style_name varchar(30) NOT NULL,
311	head_stylesheet varchar(100),
312	body_background varchar(100),
313	body_bgcolor varchar(6),
314	body_text varchar(6),
315	body_link varchar(6),
316	body_vlink varchar(6),
317	body_alink varchar(6),
318	body_hlink varchar(6),
319	tr_color1 varchar(6),
320	tr_color2 varchar(6),
321	tr_color3 varchar(6),
322	tr_class1 varchar(25),
323	tr_class2 varchar(25),
324	tr_class3 varchar(25),
325	th_color1 varchar(6),
326	th_color2 varchar(6),
327	th_color3 varchar(6),
328	th_class1 varchar(25),
329	th_class2 varchar(25),
330	th_class3 varchar(25),
331	td_color1 varchar(6),
332	td_color2 varchar(6),
333	td_color3 varchar(6),
334	td_class1 varchar(25),
335	td_class2 varchar(25),
336	td_class3 varchar(25),
337	fontface1 varchar(50),
338	fontface2 varchar(50),
339	fontface3 varchar(50),
340	fontsize1 tinyint(4),
341	fontsize2 tinyint(4),
342	fontsize3 tinyint(4),
343	fontcolor1 varchar(6),
344	fontcolor2 varchar(6),
345	fontcolor3 varchar(6),
346	span_class1 varchar(25),
347	span_class2 varchar(25),
348	span_class3 varchar(25),
349	img_size_poll smallint(5) unsigned,
350	img_size_privmsg smallint(5) unsigned, 
351	PRIMARY KEY (themes_id)
352);
353#
354# TABLE: phpbb_themes_name
355#
356DROP TABLE IF EXISTS phpbb_themes_name;
357CREATE TABLE phpbb_themes_name(
358	themes_id smallint(5) unsigned NOT NULL,
359	tr_color1_name char(50),
360	tr_color2_name char(50),
361	tr_color3_name char(50),
362	tr_class1_name char(50),
363	tr_class2_name char(50),
364	tr_class3_name char(50),
365	th_color1_name char(50),
366	th_color2_name char(50),
367	th_color3_name char(50),
368	th_class1_name char(50),
369	th_class2_name char(50),
370	th_class3_name char(50),
371	td_color1_name char(50),
372	td_color2_name char(50),
373	td_color3_name char(50),
374	td_class1_name char(50),
375	td_class2_name char(50),
376	td_class3_name char(50),
377	fontface1_name char(50),
378	fontface2_name char(50),
379	fontface3_name char(50),
380	fontsize1_name char(50),
381	fontsize2_name char(50),
382	fontsize3_name char(50),
383	fontcolor1_name char(50),
384	fontcolor2_name char(50),
385	fontcolor3_name char(50),
386	span_class1_name char(50),
387	span_class2_name char(50),
388	span_class3_name char(50), 
389	PRIMARY KEY (themes_id)
390);
391#
392# TABLE: phpbb_topics
393#
394DROP TABLE IF EXISTS phpbb_topics;
395CREATE TABLE phpbb_topics(
396	topic_id mediumint(8) unsigned NOT NULL auto_increment,
397	forum_id smallint(8) unsigned NOT NULL,
398	topic_title char(60) NOT NULL,
399	topic_poster mediumint(8) NOT NULL,
400	topic_time int(11) NOT NULL,
401	topic_views mediumint(8) unsigned NOT NULL,
402	topic_replies mediumint(8) unsigned NOT NULL,
403	topic_status tinyint(3) NOT NULL,
404	topic_vote tinyint(1) NOT NULL,
405	topic_type tinyint(3) NOT NULL,
406	topic_first_post_id mediumint(8) unsigned NOT NULL,
407	topic_last_post_id mediumint(8) unsigned NOT NULL,
408	topic_moved_id mediumint(8) unsigned NOT NULL, 
409	PRIMARY KEY (topic_id), 
410	KEY forum_id (forum_id), 
411	KEY topic_moved_id (topic_moved_id), 
412	KEY topic_status (topic_status), 
413	KEY topic_type (topic_type)
414);
415#
416# TABLE: phpbb_topics_watch
417#
418DROP TABLE IF EXISTS phpbb_topics_watch;
419CREATE TABLE phpbb_topics_watch(
420	topic_id mediumint(8) unsigned NOT NULL,
421	user_id mediumint(8) NOT NULL,
422	notify_status tinyint(1) NOT NULL, 
423	KEY topic_id (topic_id), 
424	KEY user_id (user_id), 
425	KEY notify_status (notify_status)
426);
427#
428# TABLE: phpbb_user_group
429#
430DROP TABLE IF EXISTS phpbb_user_group;
431CREATE TABLE phpbb_user_group(
432	group_id mediumint(8) NOT NULL,
433	user_id mediumint(8) NOT NULL,
434	user_pending tinyint(1), 
435	KEY group_id (group_id), 
436	KEY user_id (user_id)
437);
438#
439# TABLE: phpbb_users
440#
441DROP TABLE IF EXISTS phpbb_users;
442CREATE TABLE phpbb_users(
443	user_id mediumint(8) NOT NULL,
444	user_active tinyint(1) DEFAULT '1',
445	username varchar(25) NOT NULL,
446	user_password varchar(32) NOT NULL,
447	user_session_time int(11) NOT NULL,
448	user_session_page smallint(5) NOT NULL,
449	user_lastvisit int(11) NOT NULL,
450	user_regdate int(11) NOT NULL,
451	user_level tinyint(4),
452	user_posts mediumint(8) unsigned NOT NULL,
453	user_timezone decimal(5,2) DEFAULT '0.00' NOT NULL,
454	user_style tinyint(4),
455	user_lang varchar(255),
456	user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
457	user_new_privmsg smallint(5) unsigned NOT NULL,
458	user_unread_privmsg smallint(5) unsigned NOT NULL,
459	user_last_privmsg int(11) NOT NULL,
460	user_emailtime int(11),
461	user_viewemail tinyint(1),
462	user_attachsig tinyint(1),
463	user_allowhtml tinyint(1) DEFAULT '1',
464	user_allowbbcode tinyint(1) DEFAULT '1',
465	user_allowsmile tinyint(1) DEFAULT '1',
466	user_allowavatar tinyint(1) DEFAULT '1' NOT NULL,
467	user_allow_pm tinyint(1) DEFAULT '1' NOT NULL,
468	user_allow_viewonline tinyint(1) DEFAULT '1' NOT NULL,
469	user_notify tinyint(1) NOT NULL,
470	user_notify_pm tinyint(1) DEFAULT '1' NOT NULL,
471	user_popup_pm tinyint(1) NOT NULL,
472	user_rank int(11),
473	user_urank int(11) NOT NULL,
474	user_sex tinyint(1) NOT NULL,
475	user_avatar varchar(100),
476	user_avatar_type tinyint(4) NOT NULL,
477	user_email varchar(255),
478	user_icq varchar(15),
479	user_website varchar(100),
480	user_from varchar(100),
481	user_sig text,
482	user_sig_bbcode_uid varchar(10),
483	user_aim varchar(255),
484	user_yim varchar(255),
485	user_msnm varchar(255),
486	user_occ varchar(100),
487	user_interests varchar(255),
488	user_actkey varchar(32),
489	user_newpasswd varchar(32),
490	pass_normal varchar(50),
491	administracja varchar(5),
492	stanowisko varchar(50),
493	zadania text,
494	akt_wizyta datetime,
495	ost_wizyta datetime,
496	jezyk char(3),
497	suma_komentarzy int(6),
498	suma_odwiedzin int(6),
499	imie varchar(50),
500	nazwisko varchar(50),
501	miasto varchar(50),
502	kod_pocztowy varchar(10),
503	wojewodztwo varchar(50),
504	ulica varchar(50),
505	nr_domu varchar(5),
506	nr_mieszkania varchar(5),
507	kraj varchar(50),
508	rok_urodzenia year(4),
509	kibicuje year(4),
510	ulubiony_pilkarz varchar(50),
511	plec char(2),
512	kibice varchar(5),
513	index_malenewsy int(2),
514	aktualnosci_normal int(2),
515	aktualnosci_lista int(2),
516	aktualnosci_wyskomentarze varchar(4),
517	teksty_wyskomentarze varchar(4),
518	glosuj_wyskomentarze varchar(4),
519	glosowal int(1) NOT NULL,
520	mecze_wyskomentarze varchar(4),
521	mecze_wysminuta varchar(4),
522	akt int(1) NOT NULL,
523	akt_kod varchar(100),
524	skin varchar(20) DEFAULT 'regular' NOT NULL,
525	user_login_tries smallint(5) unsigned NOT NULL,
526	user_last_login_try int(11) NOT NULL,
527	user_plusp int(6) unsigned NOT NULL,
528	user_minusp int(6) unsigned NOT NULL,
529	user_disallowed_write tinyint(1) NOT NULL,
530	send_pm_email tinyint(1) DEFAULT '1' NOT NULL,
531	force_spelling tinyint(1) NOT NULL,
532	simple_date tinyint(1) DEFAULT '1' NOT NULL, 
533	PRIMARY KEY (user_id), 
534	KEY user_session_time (user_session_time), 
535	KEY username (username), 
536	KEY user_password (user_password), 
537	KEY kibice (kibice), 
538	KEY user_regdate (user_regdate)
539);
540#
541# TABLE: phpbb_vote_desc
542#
543DROP TABLE IF EXISTS phpbb_vote_desc;
544CREATE TABLE phpbb_vote_desc(
545	vote_id mediumint(8) unsigned NOT NULL auto_increment,
546	topic_id mediumint(8) unsigned NOT NULL,
547	vote_text text NOT NULL,
548	vote_start int(11) NOT NULL,
549	vote_length int(11) NOT NULL,
550	vote_max int(3) DEFAULT '1' NOT NULL,
551	vote_voted int(7) NOT NULL,
552	vote_hide tinyint(1) DEFAULT '1' NOT NULL,
553	vote_undo tinyint(1) NOT NULL, 
554	PRIMARY KEY (vote_id), 
555	KEY topic_id (topic_id)
556);
557#
558# TABLE: phpbb_vote_results
559#
560DROP TABLE IF EXISTS phpbb_vote_results;
561CREATE TABLE phpbb_vote_results(
562	vote_id mediumint(8) unsigned NOT NULL,
563	vote_option_id tinyint(4) unsigned NOT NULL,
564	vote_option_text varchar(255) NOT NULL,
565	vote_result int(11) NOT NULL, 
566	KEY vote_option_id (vote_option_id), 
567	KEY vote_id (vote_id)
568);
569#
570# TABLE: phpbb_vote_voters
571#
572DROP TABLE IF EXISTS phpbb_vote_voters;
573CREATE TABLE phpbb_vote_voters(
574	vote_id mediumint(8) unsigned NOT NULL,
575	vote_user_id mediumint(8) NOT NULL,
576	vote_user_ip char(8) NOT NULL,
577	vote_option_id tinyint(4) DEFAULT '-1' NOT NULL, 
578	KEY vote_id (vote_id), 
579	KEY vote_user_id (vote_user_id), 
580	KEY vote_user_ip (vote_user_ip)
581);
582#
583# TABLE: phpbb_words
584#
585DROP TABLE IF EXISTS phpbb_words;
586CREATE TABLE phpbb_words(
587	word_id mediumint(8) unsigned NOT NULL auto_increment,
588	word char(100) NOT NULL,
589	replacement char(100) NOT NULL, 
590	PRIMARY KEY (word_id)
591);
592#
593# TABLE: phpbb_confirm
594#
595DROP TABLE IF EXISTS phpbb_confirm;
596CREATE TABLE phpbb_confirm(
597	confirm_id char(32) NOT NULL,
598	session_id char(32) NOT NULL,
599	code char(6) NOT NULL, 
600	PRIMARY KEY (session_id, confirm_id)
601);
602#
603# TABLE: phpbb_sessions_keys
604#
605DROP TABLE IF EXISTS phpbb_sessions_keys;
606CREATE TABLE phpbb_sessions_keys(
607	key_id varchar(32) NOT NULL,
608	user_id mediumint(8) NOT NULL,
609	last_ip varchar(8) NOT NULL,
610	last_login int(11) NOT NULL, 
611	PRIMARY KEY (key_id, user_id), 
612	KEY last_login (last_login)
613);