Verzeichnisstruktur phpBB-2.0.0
- Veröffentlicht
- 03.04.2002
So funktioniert es
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
postgres_schema.sql
001 /*
002 phpBB2 PostgreSQL DB schema - phpBB group 2001
003
004
005 $Id$
006 */
007
008 CREATE SEQUENCE phpbb_banlist_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
009 CREATE SEQUENCE phpbb_categories_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
010 CREATE SEQUENCE phpbb_disallow_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
011 CREATE SEQUENCE phpbb_posts_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
012 CREATE SEQUENCE phpbb_privmsgs_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
013 CREATE SEQUENCE phpbb_ranks_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
014 CREATE SEQUENCE phpbb_search_wordlist_id_seq start 13 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
015 CREATE SEQUENCE phpbb_smilies_id_seq start 42 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
016 CREATE SEQUENCE phpbb_themes_id_seq start 7 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
017 CREATE SEQUENCE phpbb_topics_id_seq start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
018 CREATE SEQUENCE phpbb_users_id_seq start 3 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
019 CREATE SEQUENCE phpbb_words_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
020 CREATE SEQUENCE phpbb_groups_id_seq start 3 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
021 CREATE SEQUENCE phpbb_forum_prune_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
022 CREATE SEQUENCE phpbb_vote_desc_id_seq start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
023
024 /* --------------------------------------------------------
025 Table structure for table phpbb_auth_access
026 -------------------------------------------------------- */
027 CREATE TABLE phpbb_auth_access (
028 group_id int DEFAULT '0' NOT NULL,
029 forum_id int2 DEFAULT '0' NOT NULL,
030 auth_view int2 DEFAULT '0' NOT NULL,
031 auth_read int2 DEFAULT '0' NOT NULL,
032 auth_post int2 DEFAULT '0' NOT NULL,
033 auth_reply int2 DEFAULT '0' NOT NULL,
034 auth_edit int2 DEFAULT '0' NOT NULL,
035 auth_delete int2 DEFAULT '0' NOT NULL,
036 auth_sticky int2 DEFAULT '0' NOT NULL,
037 auth_announce int2 DEFAULT '0' NOT NULL,
038 auth_vote int2 DEFAULT '0' NOT NULL,
039 auth_pollcreate int2 DEFAULT '0' NOT NULL,
040 auth_attachments int2 DEFAULT '0' NOT NULL,
041 auth_mod int2 DEFAULT '0' NOT NULL,
042 CONSTRAINT phpbb_auth_access_pkey PRIMARY KEY (group_id, forum_id)
043 );
044
045
046 /* --------------------------------------------------------
047 Table structure for table phpbb_confirm
048 -------------------------------------------------------- */
049 CREATE TABLE phpbb_confirm (
050 confirm_id char(32) DEFAULT '' NOT NULL,
051 session_id char(32) DEFAULT '' NOT NULL,
052 code char(6) DEFAULT '' NOT NULL,
053 CONSTRAINT phpbb_confirm_pkey PRIMARY KEY (session_id, confirm_id)
054 );
055
056
057 /* --------------------------------------------------------
058 Table structure for table phpbb_groups
059 -------------------------------------------------------- */
060 CREATE TABLE phpbb_groups (
061 group_id int DEFAULT nextval('phpbb_groups_id_seq'::text) NOT NULL,
062 group_name varchar(40) NOT NULL,
063 group_type int2 DEFAULT '1' NOT NULL,
064 group_description varchar(255) NOT NULL,
065 group_moderator int4 DEFAULT '0' NOT NULL,
066 group_single_user int2 DEFAULT '0' NOT NULL,
067 CONSTRAINT phpbb_groups_pkey PRIMARY KEY (group_id)
068 );
069
070
071 /* --------------------------------------------------------
072 Table structure for table phpbb_banlist
073 -------------------------------------------------------- */
074 CREATE TABLE phpbb_banlist (
075 ban_id int4 DEFAULT nextval('phpbb_banlist_id_seq'::text) NOT NULL,
076 ban_userid int4,
077 ban_ip char(8),
078 ban_email varchar(255),
079 CONSTRAINT phpbb_banlist_pkey PRIMARY KEY (ban_id)
080 );
081 CREATE INDEX ban_userid_phpbb_banlist_index ON phpbb_banlist (ban_userid);
082
083
084 /* --------------------------------------------------------
085 Table structure for table phpbb_categories
086 -------------------------------------------------------- */
087 CREATE TABLE phpbb_categories (
088 cat_id int4 DEFAULT nextval('phpbb_categories_id_seq'::text) NOT NULL,
089 cat_title varchar(100),
090 cat_order int4,
091 CONSTRAINT phpbb_categories_pkey PRIMARY KEY (cat_id)
092 );
093
094
095 /* --------------------------------------------------------
096 Table structure for table phpbb_config
097 -------------------------------------------------------- */
098 CREATE TABLE phpbb_config (
099 config_name varchar(255) NOT NULL,
100 config_value varchar(255) NOT NULL,
101 CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_name)
102 );
103
104
105 /* --------------------------------------------------------
106 Table structure for table phpbb_disallow
107 -------------------------------------------------------- */
108 CREATE TABLE phpbb_disallow (
109 disallow_id int4 DEFAULT nextval('phpbb_disallow_id_seq'::text) NOT NULL,
110 disallow_username varchar(25),
111 CONSTRAINT phpbb_disallow_pkey PRIMARY KEY (disallow_id)
112 );
113
114
115 /* --------------------------------------------------------
116 Table structure for table phpbb_forums
117 -------------------------------------------------------- */
118 CREATE TABLE phpbb_forums (
119 forum_id int4 DEFAULT '0' NOT NULL,
120 cat_id int4,
121 forum_name varchar(150),
122 forum_desc text,
123 forum_status int2 DEFAULT '0' NOT NULL,
124 forum_order int4 DEFAULT '1' NOT NULL,
125 forum_posts int4 DEFAULT '0' NOT NULL,
126 forum_topics int4 DEFAULT '0' NOT NULL,
127 forum_last_post_id int4 DEFAULT '0' NOT NULL,
128 prune_enable int2 DEFAULT '0' NOT NULL,
129 prune_next int,
130 auth_view int2 DEFAULT '0' NOT NULL,
131 auth_read int2 DEFAULT '0' NOT NULL,
132 auth_post int2 DEFAULT '0' NOT NULL,
133 auth_reply int2 DEFAULT '0' NOT NULL,
134 auth_edit int2 DEFAULT '0' NOT NULL,
135 auth_delete int2 DEFAULT '0' NOT NULL,
136 auth_announce int2 DEFAULT '0' NOT NULL,
137 auth_sticky int2 DEFAULT '0' NOT NULL,
138 auth_pollcreate int2 DEFAULT '0' NOT NULL,
139 auth_vote int2 DEFAULT '0' NOT NULL,
140 auth_attachments int2 DEFAULT '0' NOT NULL,
141 CONSTRAINT phpbb_forums_pkey PRIMARY KEY (forum_id)
142 );
143 CREATE INDEX cat_id_phpbb_forums_index ON phpbb_forums (cat_id);
144 CREATE INDEX forum_id_phpbb_forums_index ON phpbb_forums (forum_id);
145 CREATE INDEX forums_order_phpbb_forums_index ON phpbb_forums (forum_order);
146 CREATE INDEX forum_last_post_id_phpbb_forums_index ON phpbb_forums (forum_last_post_id);
147
148
149 /* --------------------------------------------------------
150 Table structure for table phpbb_forum_prune
151 -------------------------------------------------------- */
152 CREATE TABLE phpbb_forum_prune (
153 prune_id int4 DEFAULT nextval('phpbb_forum_prune_id_seq'::text) NOT NULL,
154 forum_id int4 NOT NULL,
155 prune_days int4 NOT NULL,
156 prune_freq int4 NOT NULL,
157 CONSTRAINT phpbb_forum_prune_pkey PRIMARY KEY (prune_id)
158 );
159 CREATE INDEX prune_id_phpbb_forum_prune_index ON phpbb_forum_prune (prune_id);
160 CREATE INDEX forum_id_phpbb_forum_prune_index ON phpbb_forum_prune (forum_id);
161
162
163 /* --------------------------------------------------------
164 Table structure for table phpbb_posts
165 -------------------------------------------------------- */
166 CREATE TABLE phpbb_posts (
167 post_id int4 DEFAULT nextval('phpbb_posts_id_seq'::text) NOT NULL,
168 topic_id int4 DEFAULT '0' NOT NULL,
169 forum_id int4 DEFAULT '0' NOT NULL,
170 poster_id int4 DEFAULT '0' NOT NULL,
171 post_time int4 DEFAULT '0' NOT NULL,
172 post_username varchar(25),
173 poster_ip char(8) DEFAULT '' NOT NULL,
174 enable_bbcode int2 DEFAULT '1' NOT NULL,
175 enable_html int2 DEFAULT '0' NOT NULL,
176 enable_smilies int2 DEFAULT '1' NOT NULL,
177 enable_sig int2 DEFAULT '1' NOT NULL,
178 post_edit_time int4,
179 post_edit_count int2 DEFAULT '0' NOT NULL,
180 CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id)
181 );
182 CREATE INDEX forum_id_phpbb_posts_index ON phpbb_posts (forum_id);
183 CREATE INDEX post_time_phpbb_posts_index ON phpbb_posts (post_time);
184 CREATE INDEX poster_id_phpbb_posts_index ON phpbb_posts (poster_id);
185 CREATE INDEX topic_id_phpbb_posts_index ON phpbb_posts (topic_id);
186
187
188 /* --------------------------------------------------------
189 Table structure for table phpbb_posts_text
190 -------------------------------------------------------- */
191 CREATE TABLE phpbb_posts_text (
192 post_id int4 DEFAULT '0' NOT NULL,
193 bbcode_uid varchar(10) DEFAULT '' NOT NULL,
194 post_subject varchar(60),
195 post_text text,
196 CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id)
197 );
198
199
200 /* --------------------------------------------------------
201 Table structure for table phpbb_privmsgs
202 -------------------------------------------------------- */
203 CREATE TABLE phpbb_privmsgs (
204 privmsgs_id int4 DEFAULT nextval('phpbb_privmsgs_id_seq'::text) NOT NULL,
205 privmsgs_type int2 DEFAULT '0' NOT NULL,
206 privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
207 privmsgs_from_userid int4 DEFAULT '0' NOT NULL,
208 privmsgs_to_userid int4 DEFAULT '0' NOT NULL,
209 privmsgs_date int4 DEFAULT '0' NOT NULL,
210 privmsgs_ip char(8) NOT NULL,
211 privmsgs_enable_bbcode int2 DEFAULT '1' NOT NULL,
212 privmsgs_enable_html int2 DEFAULT '0' NOT NULL,
213 privmsgs_enable_smilies int2 DEFAULT '1' NOT NULL,
214 privmsgs_attach_sig int2 DEFAULT '1' NOT NULL,
215 CONSTRAINT phpbb_privmsgs_pkey PRIMARY KEY (privmsgs_id)
216 );
217 CREATE INDEX privmsgs_from_userid_phpbb_privmsgs_index ON phpbb_privmsgs (privmsgs_from_userid);
218 CREATE INDEX privmsgs_to_userid_phpbb_privmsgs_index ON phpbb_privmsgs (privmsgs_to_userid);
219
220
221 /* --------------------------------------------------------
222 Table structure for table phpbb_privmsgs_text
223 -------------------------------------------------------- */
224 CREATE TABLE phpbb_privmsgs_text (
225 privmsgs_text_id int4 DEFAULT '0' NOT NULL,
226 privmsgs_bbcode_uid char(10) DEFAULT '0' NOT NULL,
227 privmsgs_text text,
228 CONSTRAINT phpbb_privmsgs_text_pkey PRIMARY KEY (privmsgs_text_id)
229 );
230
231
232 /* --------------------------------------------------------
233 Table structure for table phpbb_ranks
234 -------------------------------------------------------- */
235 CREATE TABLE phpbb_ranks (
236 rank_id int4 DEFAULT nextval('phpbb_ranks_id_seq'::text) NOT NULL,
237 rank_title varchar(50) DEFAULT '' NOT NULL,
238 rank_min int4 DEFAULT '0' NOT NULL,
239 rank_special int2 DEFAULT '0',
240 rank_image varchar(255),
241 CONSTRAINT phpbb_ranks_pkey PRIMARY KEY (rank_id)
242 );
243
244
245 /* --------------------------------------------------------
246 Table structure for table phpbb_search_results
247 -------------------------------------------------------- */
248 CREATE TABLE phpbb_search_results (
249 search_id int4 NOT NULL default '0',
250 session_id char(32) NOT NULL default '',
251 search_time int4 DEFAULT '0' NOT NULL,
252 search_array text NOT NULL,
253 CONSTRAINT phpbb_search_results_pkey PRIMARY KEY (search_id)
254 );
255 CREATE INDEX session_id_phpbb_search_results_index ON phpbb_search_results (session_id);
256
257
258 /* --------------------------------------------------------
259 Table structure for table phpbb_search_wordlist
260 -------------------------------------------------------- */
261 CREATE TABLE phpbb_search_wordlist (
262 word_id int4 DEFAULT nextval('phpbb_search_wordlist_id_seq'::text) NOT NULL,
263 word_text varchar(50) NOT NULL DEFAULT '',
264 word_common int2 NOT NULL DEFAULT '0',
265 CONSTRAINT phpbb_search_wordlist_pkey PRIMARY KEY (word_text)
266 );
267 CREATE INDEX word_id_phpbb_search_wordlist_index ON phpbb_search_wordlist (word_id);
268
269
270 /* --------------------------------------------------------
271 Table structure for table phpbb_search_wordmatch
272 -------------------------------------------------------- */
273 CREATE TABLE phpbb_search_wordmatch (
274 post_id int4 NOT NULL default '0',
275 word_id int4 NOT NULL default '0',
276 title_match int2 NOT NULL default '0'
277 );
278 CREATE INDEX word_id_phpbb_search_wordmatch_index ON phpbb_search_wordmatch (word_id);
279 CREATE INDEX post_id_phpbb_search_wordmatch_index ON phpbb_search_wordmatch (post_id);
280
281
282 /* --------------------------------------------------------
283 Table structure for table phpbb_sessions
284 -------------------------------------------------------- */
285 CREATE TABLE phpbb_sessions (
286 session_id char(32) DEFAULT '0' NOT NULL,
287 session_user_id int4 DEFAULT '0' NOT NULL,
288 session_start int4 DEFAULT '0' NOT NULL,
289 session_time int4 DEFAULT '0' NOT NULL,
290 session_ip char(8) DEFAULT '0' NOT NULL,
291 session_page int4 DEFAULT '0' NOT NULL,
292 session_logged_in int2 DEFAULT '0' NOT NULL,
293 session_admin int2 DEFAULT '0' NOT NULL,
294 priv_session_id char(32) DEFAULT '0' NOT NULL,
295 CONSTRAINT phpbb_session_pkey PRIMARY KEY (session_id)
296 );
297 CREATE INDEX session_user_id_phpbb_sessions_index ON phpbb_sessions (session_user_id);
298 CREATE INDEX session_id_ip_user_id_phpbb_sessions_index ON phpbb_sessions (session_id, session_ip, session_user_id);
299
300 /* --------------------------------------------------------
301 Table structure for table phpbb_sessions_keys
302 -------------------------------------------------------- */
303 CREATE TABLE phpbb_sessions_keys (
304 key_id char(32) DEFAULT '0' NOT NULL,
305 user_id int4 DEFAULT '0' NOT NULL,
306 last_ip char(8) DEFAULT '0' NOT NULL,
307 last_login int4 DEFAULT '0' NOT NULL,
308 CONSTRAINT phpbb_sessions_keys_pkey PRIMARY KEY (key_id, user_id)
309 );
310 CREATE INDEX last_login_phpbb_sessions_keys_index ON phpbb_sessions_keys (last_login);
311
312 /* --------------------------------------------------------
313 Table structure for table phpbb_smilies
314 -------------------------------------------------------- */
315 CREATE TABLE phpbb_smilies (
316 smilies_id int4 DEFAULT nextval('phpbb_smilies_id_seq'::text) NOT NULL,
317 code varchar(50),
318 smile_url varchar(100),
319 emoticon varchar(75),
320 CONSTRAINT phpbb_smilies_pkey PRIMARY KEY (smilies_id)
321 );
322
323
324 /* --------------------------------------------------------
325 Table structure for table phpbb_themes
326 -------------------------------------------------------- */
327 CREATE TABLE phpbb_themes (
328 themes_id int4 DEFAULT nextval('phpbb_themes_id_seq'::text) NOT NULL,
329 style_name varchar(30),
330 template_name varchar(30) NOT NULL DEFAULT '',
331 head_stylesheet varchar(100),
332 body_background varchar(100),
333 body_bgcolor char(6),
334 body_text char(6),
335 body_link char(6),
336 body_vlink char(6),
337 body_alink char(6),
338 body_hlink char(6),
339 tr_color1 char(6),
340 tr_color2 char(6),
341 tr_color3 char(6),
342 tr_class1 varchar(25),
343 tr_class2 varchar(25),
344 tr_class3 varchar(25),
345 th_color1 char(6),
346 th_color2 char(6),
347 th_color3 char(6),
348 th_class1 varchar(25),
349 th_class2 varchar(25),
350 th_class3 varchar(25),
351 td_color1 char(6),
352 td_color2 char(6),
353 td_color3 char(6),
354 td_class1 varchar(25),
355 td_class2 varchar(25),
356 td_class3 varchar(25),
357 fontface1 varchar(50),
358 fontface2 varchar(50),
359 fontface3 varchar(50),
360 fontsize1 int2,
361 fontsize2 int2,
362 fontsize3 int2,
363 fontcolor1 char(6),
364 fontcolor2 char(6),
365 fontcolor3 char(6),
366 span_class1 varchar(25),
367 span_class2 varchar(25),
368 span_class3 varchar(25),
369 img_size_poll int2,
370 img_size_privmsg int2,
371 CONSTRAINT phpbb_themes_pkey PRIMARY KEY (themes_id)
372 );
373
374
375 /* --------------------------------------------------------
376 Table structure for table phpbb_themes_name
377 -------------------------------------------------------- */
378 CREATE TABLE phpbb_themes_name (
379 themes_id int4 DEFAULT '0' NOT NULL,
380 tr_color1_name char(50),
381 tr_color2_name char(50),
382 tr_color3_name char(50),
383 tr_class1_name varchar(50),
384 tr_class2_name varchar(50),
385 tr_class3_name varchar(50),
386 th_color1_name char(50),
387 th_color2_name char(50),
388 th_color3_name char(50),
389 th_class1_name varchar(50),
390 th_class2_name varchar(50),
391 th_class3_name varchar(50),
392 td_color1_name char(50),
393 td_color2_name char(50),
394 td_color3_name char(50),
395 td_class1_name varchar(50),
396 td_class2_name varchar(50),
397 td_class3_name varchar(50),
398 fontface1_name varchar(50),
399 fontface2_name varchar(50),
400 fontface3_name varchar(50),
401 fontsize1_name varchar(50),
402 fontsize2_name varchar(50),
403 fontsize3_name varchar(50),
404 fontcolor1_name char(50),
405 fontcolor2_name char(50),
406 fontcolor3_name char(50),
407 span_class1_name varchar(50),
408 span_class2_name varchar(50),
409 span_class3_name varchar(50),
410 CONSTRAINT phpbb_themes_name_pkey PRIMARY KEY (themes_id)
411 );
412
413
414 /* --------------------------------------------------------
415 Table structure for table phpbb_topics
416 -------------------------------------------------------- */
417 CREATE TABLE phpbb_topics (
418 topic_id int4 DEFAULT nextval('phpbb_topics_id_seq'::text) NOT NULL,
419 forum_id int4 DEFAULT '0' NOT NULL,
420 topic_title varchar(60) DEFAULT '' NOT NULL,
421 topic_poster int4 DEFAULT '0' NOT NULL,
422 topic_time int4 DEFAULT '0' NOT NULL,
423 topic_views int4 DEFAULT '0' NOT NULL,
424 topic_replies int4 DEFAULT '0' NOT NULL,
425 topic_status int2 DEFAULT '0' NOT NULL,
426 topic_vote int2 DEFAULT '0' NOT NULL,
427 topic_type int2 DEFAULT '0' NOT NULL,
428 topic_first_post_id int4 DEFAULT '0' NOT NULL,
429 topic_last_post_id int4 DEFAULT '0' NOT NULL,
430 topic_moved_id int4 DEFAULT '0' NOT NULL,
431 CONSTRAINT phpbb_topics_pkey PRIMARY KEY (topic_id)
432 );
433 CREATE INDEX forum_id_phpbb_topics_index ON phpbb_topics (forum_id);
434 CREATE INDEX topic_moved_id_phpbb_topics_index ON phpbb_topics (topic_moved_id);
435 CREATE INDEX topic_first_post_id_phpbb_topics_index ON phpbb_topics (topic_first_post_id);
436 CREATE INDEX topic_last_post_id_phpbb_topics_index ON phpbb_topics (topic_last_post_id);
437 CREATE INDEX topic_status_phpbb_topics_index ON phpbb_topics (topic_status);
438 CREATE INDEX topic_type_phpbb_topics_index ON phpbb_topics (topic_type);
439
440
441 /* --------------------------------------------------------
442 Table structure for table phpbb_topics_watch
443 -------------------------------------------------------- */
444 CREATE TABLE phpbb_topics_watch (
445 topic_id int4,
446 user_id int4,
447 notify_status int2 NOT NULL default '0'
448 );
449 CREATE INDEX topic_id_phpbb_topics_watch_index ON phpbb_topics_watch (topic_id);
450 CREATE INDEX user_id_phpbb_topics_watch_index ON phpbb_topics_watch (user_id);
451
452
453 /* --------------------------------------------------------
454 Table structure for table phpbb_user_group
455 -------------------------------------------------------- */
456 CREATE TABLE phpbb_user_group (
457 group_id int DEFAULT '0' NOT NULL,
458 user_id int DEFAULT '0' NOT NULL,
459 user_pending int2
460 );
461 CREATE INDEX group_id_phpbb_user_group_index ON phpbb_user_group (group_id);
462 CREATE INDEX user_id_phpbb_user_group_index ON phpbb_user_group (user_id);
463
464
465 /* --------------------------------------------------------
466 Table structure for table phpbb_users
467 -------------------------------------------------------- */
468 CREATE TABLE phpbb_users (
469 user_id int4 DEFAULT nextval('phpbb_users_id_seq'::text) NOT NULL,
470 user_active int2,
471 username varchar(25) DEFAULT '' NOT NULL,
472 user_regdate int4 DEFAULT '0' NOT NULL,
473 user_password varchar(32) DEFAULT '' NOT NULL,
474 user_session_time int4 DEFAULT '0' NOT NULL,
475 user_session_page int2 DEFAULT '0' NOT NULL,
476 user_lastvisit int4 DEFAULT '0' NOT NULL,
477 user_email varchar(255),
478 user_icq varchar(15),
479 user_website varchar(100),
480 user_occ varchar(100),
481 user_from varchar(100),
482 user_interests varchar(255),
483 user_sig text,
484 user_sig_bbcode_uid char(10),
485 user_style int4,
486 user_aim varchar(255),
487 user_yim varchar(255),
488 user_msnm varchar(255),
489 user_posts int4 DEFAULT '0' NOT NULL,
490 user_new_privmsg int2 DEFAULT '0' NOT NULL,
491 user_unread_privmsg int2 DEFAULT '0' NOT NULL,
492 user_last_privmsg int4 DEFAULT '0' NOT NULL,
493 user_login_tries int2 DEFAULT '0' NOT NULL,
494 user_last_login_try int4 DEFAULT '0' NOT NULL,
495 user_emailtime int4,
496 user_viewemail int2,
497 user_attachsig int2,
498 user_allowhtml int2 DEFAULT '1',
499 user_allowbbcode int2 DEFAULT '1',
500 user_allowsmile int2 DEFAULT '1',
501 user_allow_pm int2 DEFAULT '1' NOT NULL,
502 user_allowavatar int2 DEFAULT '1' NOT NULL,
503 user_allow_viewonline int2 DEFAULT '1' NOT NULL,
504 user_rank int4 DEFAULT '0',
505 user_avatar varchar(100),
506 user_avatar_type int2 DEFAULT '0' NOT NULL,
507 user_level int4 DEFAULT '0',
508 user_lang varchar(255),
509 user_timezone decimal(5,2) DEFAULT '0.0' NOT NULL,
510 user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
511 user_notify_pm int2 DEFAULT '0' NOT NULL,
512 user_popup_pm int2 DEFAULT '0' NOT NULL,
513 user_notify int2,
514 user_actkey varchar(32),
515 user_newpasswd varchar(32),
516 CONSTRAINT phpbb_users_pkey PRIMARY KEY (user_id)
517 );
518
519 CREATE INDEX user_session_time_phpbb_users_index ON phpbb_users (user_session_time);
520
521 /* --------------------------------------------------------
522 Table structure for table phpbb_vote_desc
523 -------------------------------------------------------- */
524 CREATE TABLE phpbb_vote_desc (
525 vote_id int4 DEFAULT nextval('phpbb_vote_desc_id_seq'::text) NOT NULL ,
526 topic_id int4 NOT NULL DEFAULT '0',
527 vote_text text NOT NULL,
528 vote_start int4 DEFAULT '0' NOT NULL,
529 vote_length int4 DEFAULT '0' NOT NULL,
530 CONSTRAINT phpbb_vote_dsc_pkey PRIMARY KEY (vote_id)
531 );
532 CREATE INDEX topic_id_phpbb_vote_desc_index ON phpbb_vote_desc (topic_id);
533
534 /* --------------------------------------------------------
535 Table structure for table phpbb_vote_results
536 -------------------------------------------------------- */
537 CREATE TABLE phpbb_vote_results (
538 vote_id int4 NOT NULL DEFAULT '0',
539 vote_option_id int4 NOT NULL DEFAULT '0',
540 vote_option_text varchar(255) NOT NULL,
541 vote_result int4 NOT NULL DEFAULT '0'
542 );
543 CREATE INDEX option_id_phpbb_vote_results_index ON phpbb_vote_results (vote_option_id);
544
545 /* --------------------------------------------------------
546 Table structure for table phpbb_vote_voters
547 -------------------------------------------------------- */
548 CREATE TABLE phpbb_vote_voters (
549 vote_id int4 NOT NULL DEFAULT '0',
550 vote_user_id int4 NOT NULL DEFAULT '0',
551 vote_user_ip char(8) NOT NULL
552 );
553 CREATE INDEX vote_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_id);
554 CREATE INDEX vote_user_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_user_id);
555 CREATE INDEX vote_user_ip_phpbb_vote_voters_index ON phpbb_vote_voters (vote_user_ip);
556
557 /* --------------------------------------------------------
558 Table structure for table phpbb_words
559 -------------------------------------------------------- */
560 CREATE TABLE phpbb_words (
561 word_id int4 DEFAULT nextval('phpbb_words_id_seq'::text) NOT NULL,
562 word varchar(100) DEFAULT '' NOT NULL,
563 replacement varchar(100) DEFAULT '' NOT NULL,
564 CONSTRAINT phpbb_words_pkey PRIMARY KEY (word_id)
565 );
566