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 |
mssql_schema.sql
001 /*
002
003 mssql_schema.sql for phpBB2 (c) 2001, phpBB Group
004
005 $Id$
006
007 */
008
009 BEGIN TRANSACTION
010 GO
011
012 CREATE TABLE [phpbb_auth_access] (
013 [group_id] [int] NULL ,
014 [forum_id] [int] NULL ,
015 [auth_view] [smallint] NOT NULL ,
016 [auth_read] [smallint] NOT NULL ,
017 [auth_post] [smallint] NOT NULL ,
018 [auth_reply] [smallint] NOT NULL ,
019 [auth_edit] [smallint] NOT NULL ,
020 [auth_delete] [smallint] NOT NULL ,
021 [auth_sticky] [smallint] NOT NULL ,
022 [auth_announce] [smallint] NOT NULL ,
023 [auth_vote] [smallint] NOT NULL ,
024 [auth_pollcreate] [smallint] NOT NULL ,
025 [auth_attachments] [smallint] NOT NULL ,
026 [auth_mod] [smallint] NOT NULL
027 ) ON [PRIMARY]
028 GO
029
030 CREATE TABLE [phpbb_banlist] (
031 [ban_id] [int] IDENTITY (1, 1) NOT NULL ,
032 [ban_userid] [int] NULL ,
033 [ban_ip] [char] (8) NULL ,
034 [ban_email] [varchar] (50) NULL
035 ) ON [PRIMARY]
036 GO
037
038 CREATE TABLE [phpbb_categories] (
039 [cat_id] [int] IDENTITY (1, 1) NOT NULL ,
040 [cat_title] [varchar] (50) NOT NULL ,
041 [cat_order] [int] NOT NULL
042 ) ON [PRIMARY]
043 GO
044
045 CREATE TABLE [phpbb_config] (
046 [config_name] [varchar] (255) NULL ,
047 [config_value] [varchar] (255) NULL
048 ) ON [PRIMARY]
049 GO
050
051
052 CREATE TABLE [phpbb_confirm] (
053 [confirm_id] [char] (32) NOT NULL ,
054 [session_id] [char] (32) NOT NULL ,
055 [code] [char] (6) NOT NULL
056 ) ON [PRIMARY]
057 GO
058
059 CREATE TABLE [phpbb_disallow] (
060 [disallow_id] [int] IDENTITY (1, 1) NOT NULL ,
061 [disallow_username] [varchar] (100) NULL
062 ) ON [PRIMARY]
063 GO
064
065 CREATE TABLE [phpbb_forum_prune] (
066 [prune_id] [int] IDENTITY (1, 1) NOT NULL ,
067 [forum_id] [int] NOT NULL ,
068 [prune_days] [int] NOT NULL ,
069 [prune_freq] [int] NOT NULL
070 ) ON [PRIMARY]
071 GO
072
073 CREATE TABLE [phpbb_forums] (
074 [forum_id] [int] NOT NULL ,
075 [cat_id] [int] NOT NULL ,
076 [forum_name] [varchar] (100) NOT NULL ,
077 [forum_desc] [varchar] (255) NULL ,
078 [forum_status] [smallint] NOT NULL ,
079 [forum_order] [int] NOT NULL ,
080 [forum_posts] [int] NOT NULL ,
081 [forum_topics] [smallint] NOT NULL ,
082 [forum_last_post_id] [int] NOT NULL ,
083 [prune_next] [int] NULL ,
084 [prune_enable] [smallint] NOT NULL ,
085 [auth_view] [smallint] NOT NULL ,
086 [auth_read] [smallint] NOT NULL ,
087 [auth_post] [smallint] NOT NULL ,
088 [auth_reply] [smallint] NOT NULL ,
089 [auth_edit] [smallint] NOT NULL ,
090 [auth_delete] [smallint] NOT NULL ,
091 [auth_sticky] [smallint] NOT NULL ,
092 [auth_announce] [smallint] NOT NULL ,
093 [auth_vote] [smallint] NOT NULL ,
094 [auth_pollcreate] [smallint] NOT NULL ,
095 [auth_attachments] [smallint] NOT NULL
096 ) ON [PRIMARY]
097 GO
098
099 CREATE TABLE [phpbb_groups] (
100 [group_id] [int] IDENTITY (1, 1) NOT NULL ,
101 [group_type] [smallint] NULL ,
102 [group_name] [varchar] (50) NOT NULL ,
103 [group_description] [varchar] (255) NOT NULL ,
104 [group_moderator] [int] NULL ,
105 [group_single_user] [smallint] NOT NULL
106 ) ON [PRIMARY]
107 GO
108
109 CREATE TABLE [phpbb_posts] (
110 [post_id] [int] IDENTITY (1, 1) NOT NULL ,
111 [topic_id] [int] NOT NULL ,
112 [forum_id] [int] NOT NULL ,
113 [poster_id] [int] NOT NULL ,
114 [post_time] [int] NOT NULL ,
115 [poster_ip] [char] (8) NULL ,
116 [post_username] [char] (25) NULL ,
117 [enable_bbcode] [smallint] NULL ,
118 [enable_html] [smallint] NULL ,
119 [enable_smilies] [smallint] NULL ,
120 [enable_sig] [smallint] NULL ,
121 [post_edit_time] [int] NULL ,
122 [post_edit_count] [smallint] NULL
123 ) ON [PRIMARY]
124 GO
125
126 CREATE TABLE [phpbb_posts_text] (
127 [post_id] [int] NOT NULL ,
128 [bbcode_uid] [char] (10) NULL ,
129 [post_subject] [char] (60) NULL ,
130 [post_text] [text] NULL
131 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
132 GO
133
134 CREATE TABLE [phpbb_privmsgs] (
135 [privmsgs_id] [int] IDENTITY (1, 1) NOT NULL ,
136 [privmsgs_type] [smallint] NOT NULL ,
137 [privmsgs_subject] [varchar] (100) NOT NULL ,
138 [privmsgs_from_userid] [int] NOT NULL ,
139 [privmsgs_to_userid] [int] NOT NULL ,
140 [privmsgs_date] [int] NOT NULL ,
141 [privmsgs_ip] [char] (8) NOT NULL ,
142 [privmsgs_enable_bbcode] [smallint] NULL ,
143 [privmsgs_enable_html] [smallint] NULL ,
144 [privmsgs_enable_smilies] [smallint] NULL ,
145 [privmsgs_attach_sig] [smallint] NULL
146 ) ON [PRIMARY]
147 GO
148
149 CREATE TABLE [phpbb_privmsgs_text] (
150 [privmsgs_text_id] [int] NOT NULL ,
151 [privmsgs_bbcode_uid] [char] (10) NULL ,
152 [privmsgs_text] [text] NULL
153 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
154 GO
155
156 CREATE TABLE [phpbb_ranks] (
157 [rank_id] [int] IDENTITY (1, 1) NOT NULL ,
158 [rank_title] [varchar] (50) NOT NULL ,
159 [rank_min] [int] NULL ,
160 [rank_special] [smallint] NULL ,
161 [rank_image] [varchar] (50) NULL
162 ) ON [PRIMARY]
163 GO
164
165 CREATE TABLE [phpbb_search_results] (
166 [search_id] [int] NOT NULL ,
167 [session_id] [char] (32) NOT NULL ,
168 [search_time] [int] NOT NULL ,
169 [search_array] [text] NOT NULL
170 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
171 GO
172
173 CREATE TABLE [phpbb_search_wordlist] (
174 [word_id] [int] IDENTITY (1, 1) NOT NULL ,
175 [word_text] [varchar] (50) NOT NULL ,
176 [word_common] [tinyint] NOT NULL
177 ) ON [PRIMARY]
178 GO
179
180 CREATE TABLE [phpbb_search_wordmatch] (
181 [post_id] [int] NOT NULL ,
182 [word_id] [int] NOT NULL ,
183 [title_match] [smallint] NOT NULL
184 ) ON [PRIMARY]
185 GO
186
187 CREATE TABLE [phpbb_sessions] (
188 [session_id] [char] (32) NOT NULL ,
189 [session_user_id] [int] NOT NULL ,
190 [session_start] [int] NULL ,
191 [session_time] [int] NULL ,
192 [session_ip] [char] (8) NOT NULL ,
193 [session_page] [int] NULL ,
194 [session_logged_in] [smallint] NULL,
195 [session_admin] [smallint] NULL
196 [priv_session_id] [char] (32) NOT NULL ,
197 ) ON [PRIMARY]
198 GO
199
200 CREATE TABLE [phpbb_sessions_keys] (
201 [key_id] [char] (32) NOT NULL ,
202 [user_id] [int] NOT NULL ,
203 [last_ip] [char] (8) NOT NULL ,
204 [last_login] [int] NOT NULL
205 ) ON [PRIMARY]
206 GO
207
208 CREATE TABLE [phpbb_smilies] (
209 [smilies_id] [int] IDENTITY (1, 1) NOT NULL ,
210 [code] [varchar] (10) NOT NULL ,
211 [smile_url] [varchar] (50) NOT NULL ,
212 [emoticon] [varchar] (50) NULL
213 ) ON [PRIMARY]
214 GO
215
216 CREATE TABLE [phpbb_themes] (
217 [themes_id] [int] IDENTITY (1, 1) NOT NULL ,
218 [template_name] [varchar] (30) NOT NULL ,
219 [style_name] [varchar] (50) NOT NULL ,
220 [head_stylesheet] [varchar] (50) NULL ,
221 [body_background] [varchar] (50) NULL ,
222 [body_bgcolor] [char] (6) NULL ,
223 [body_text] [char] (6) NULL ,
224 [body_link] [char] (6) NULL ,
225 [body_vlink] [char] (6) NULL ,
226 [body_alink] [char] (6) NULL ,
227 [body_hlink] [char] (6) NULL ,
228 [tr_color1] [char] (6) NULL ,
229 [tr_color2] [char] (6) NULL ,
230 [tr_color3] [char] (6) NULL ,
231 [tr_class1] [varchar] (25) NULL ,
232 [tr_class2] [varchar] (25) NULL ,
233 [tr_class3] [varchar] (25) NULL ,
234 [th_color1] [char] (6) NULL ,
235 [th_color2] [char] (6) NULL ,
236 [th_color3] [char] (6) NULL ,
237 [th_class1] [varchar] (25) NULL ,
238 [th_class2] [varchar] (25) NULL ,
239 [th_class3] [varchar] (25) NULL ,
240 [td_color1] [char] (6) NULL ,
241 [td_color2] [char] (6) NULL ,
242 [td_color3] [char] (6) NULL ,
243 [td_class1] [varchar] (25) NULL ,
244 [td_class2] [varchar] (25) NULL ,
245 [td_class3] [varchar] (25) NULL ,
246 [fontface1] [varchar] (50) NULL ,
247 [fontface2] [varchar] (50) NULL ,
248 [fontface3] [varchar] (50) NULL ,
249 [fontsize1] [smallint] NULL ,
250 [fontsize2] [smallint] NULL ,
251 [fontsize3] [smallint] NULL ,
252 [fontcolor1] [char] (6) NULL ,
253 [fontcolor2] [char] (6) NULL ,
254 [fontcolor3] [char] (6) NULL ,
255 [span_class1] [varchar] (25) NULL ,
256 [span_class2] [varchar] (25) NULL ,
257 [span_class3] [varchar] (25) NULL ,
258 [img_size_poll] [smallint] NULL ,
259 [img_size_privmsg] [smallint] NULL
260 ) ON [PRIMARY]
261 GO
262
263 CREATE TABLE [phpbb_themes_name] (
264 [themes_id] [int] NOT NULL ,
265 [tr_color1_name] [varchar] (50) NULL ,
266 [tr_color2_name] [varchar] (50) NULL ,
267 [tr_color3_name] [varchar] (50) NULL ,
268 [tr_class1_name] [varchar] (50) NULL ,
269 [tr_class2_name] [varchar] (50) NULL ,
270 [tr_class3_name] [varchar] (50) NULL ,
271 [th_color1_name] [varchar] (50) NULL ,
272 [th_color2_name] [varchar] (50) NULL ,
273 [th_color3_name] [varchar] (50) NULL ,
274 [th_class1_name] [varchar] (50) NULL ,
275 [th_class2_name] [varchar] (50) NULL ,
276 [th_class3_name] [varchar] (50) NULL ,
277 [td_color1_name] [varchar] (50) NULL ,
278 [td_color2_name] [varchar] (50) NULL ,
279 [td_color3_name] [varchar] (50) NULL ,
280 [td_class1_name] [varchar] (50) NULL ,
281 [td_class2_name] [varchar] (50) NULL ,
282 [td_class3_name] [varchar] (50) NULL ,
283 [fontface1_name] [varchar] (50) NULL ,
284 [fontface2_name] [varchar] (50) NULL ,
285 [fontface3_name] [varchar] (50) NULL ,
286 [fontsize1_name] [varchar] (50) NULL ,
287 [fontsize2_name] [varchar] (50) NULL ,
288 [fontsize3_name] [varchar] (50) NULL ,
289 [fontcolor1_name] [varchar] (50) NULL ,
290 [fontcolor2_name] [varchar] (50) NULL ,
291 [fontcolor3_name] [varchar] (50) NULL ,
292 [span_class1_name] [varchar] (50) NULL ,
293 [span_class2_name] [varchar] (50) NULL ,
294 [span_class3_name] [varchar] (50) NULL
295 ) ON [PRIMARY]
296 GO
297
298 CREATE TABLE [phpbb_topics] (
299 [topic_id] [int] IDENTITY (1, 1) NOT NULL ,
300 [forum_id] [int] NOT NULL ,
301 [topic_title] [varchar] (60) NOT NULL ,
302 [topic_poster] [int] NOT NULL ,
303 [topic_time] [int] NOT NULL ,
304 [topic_views] [int] NOT NULL ,
305 [topic_replies] [int] NOT NULL ,
306 [topic_status] [smallint] NOT NULL ,
307 [topic_type] [smallint] NOT NULL ,
308 [topic_vote] [smallint] NOT NULL ,
309 [topic_first_post_id] [int] NULL ,
310 [topic_last_post_id] [int] NULL ,
311 [topic_moved_id] [int] NULL
312 ) ON [PRIMARY]
313 GO
314
315 CREATE TABLE [phpbb_topics_watch] (
316 [topic_id] [int] NOT NULL ,
317 [user_id] [int] NOT NULL ,
318 [notify_status] [smallint] NOT NULL
319 ) ON [PRIMARY]
320 GO
321
322 CREATE TABLE [phpbb_user_group] (
323 [group_id] [int] NOT NULL ,
324 [user_id] [int] NOT NULL ,
325 [user_pending] [smallint] NULL
326 ) ON [PRIMARY]
327 GO
328
329 CREATE TABLE [phpbb_users] (
330 [user_id] [int] NOT NULL ,
331 [user_active] [smallint] NULL ,
332 [username] [varchar] (25) NOT NULL ,
333 [user_password] [varchar] (32) NOT NULL ,
334 [user_session_time] [int] NOT NULL ,
335 [user_session_page] [smallint] NOT NULL ,
336 [user_lastvisit] [int] NOT NULL ,
337 [user_regdate] [int] NOT NULL ,
338 [user_level] [smallint] NOT NULL ,
339 [user_posts] [int] NOT NULL ,
340 [user_timezone] [decimal] (5,2) NOT NULL ,
341 [user_style] [int] NULL ,
342 [user_lang] [varchar] (255) NULL ,
343 [user_dateformat] [varchar] (14) NOT NULL ,
344 [user_new_privmsg] [smallint] NOT NULL ,
345 [user_unread_privmsg] [smallint] NOT NULL ,
346 [user_last_privmsg] [int] NOT NULL ,
347 [user_login_tries] [smallint] NOT NULL ,
348 [user_last_login_try] [int] NOT NULL ,
349 [user_emailtime] [int] NOT NULL ,
350 [user_viewemail] [smallint] NULL ,
351 [user_attachsig] [smallint] NULL ,
352 [user_allowhtml] [smallint] NULL ,
353 [user_allowbbcode] [smallint] NULL ,
354 [user_allowsmile] [smallint] NULL ,
355 [user_allowavatar] [smallint] NULL ,
356 [user_allow_pm] [smallint] NOT NULL ,
357 [user_allow_viewonline] [smallint] NOT NULL ,
358 [user_notify_pm] [smallint] NOT NULL ,
359 [user_popup_pm] [smallint] NULL ,
360 [user_rank] [int] NULL ,
361 [user_avatar_type] [smallint] NULL ,
362 [user_avatar] [varchar] (100) NULL ,
363 [user_email] [varchar] (255) NULL ,
364 [user_icq] [varchar] (15) NULL ,
365 [user_website] [varchar] (100) NULL ,
366 [user_occ] [varchar] (100) NULL ,
367 [user_from] [varchar] (100) NULL ,
368 [user_sig] [text] NULL ,
369 [user_sig_bbcode_uid] [char] (10) NULL ,
370 [user_aim] [varchar] (255) NULL ,
371 [user_yim] [varchar] (255) NULL ,
372 [user_msnm] [varchar] (255) NULL ,
373 [user_interests] [varchar] (255) NULL ,
374 [user_actkey] [varchar] (32) NULL ,
375 [user_newpasswd] [varchar] (32) NULL ,
376 [user_notify] [smallint] NOT NULL
377 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
378 GO
379
380 CREATE TABLE [phpbb_vote_desc] (
381 [vote_id] [int] IDENTITY (1, 1) NOT NULL ,
382 [topic_id] [int] NOT NULL ,
383 [vote_text] [varchar] (255) NOT NULL ,
384 [vote_start] [int] NOT NULL ,
385 [vote_length] [int] NOT NULL
386 ) ON [PRIMARY]
387 GO
388
389 CREATE TABLE [phpbb_vote_results] (
390 [vote_id] [int] NOT NULL ,
391 [vote_option_id] [int] NOT NULL ,
392 [vote_option_text] [varchar] (255) NOT NULL ,
393 [vote_result] [int] NOT NULL
394 ) ON [PRIMARY]
395 GO
396
397 CREATE TABLE [phpbb_vote_voters] (
398 [vote_id] [int] NOT NULL ,
399 [vote_user_id] [int] NOT NULL ,
400 [vote_user_ip] [char] (8) NOT NULL
401 ) ON [PRIMARY]
402 GO
403
404 CREATE TABLE [phpbb_words] (
405 [word_id] [int] IDENTITY (1, 1) NOT NULL ,
406 [word] [varchar] (255) NOT NULL ,
407 [replacement] [varchar] (255) NOT NULL
408 ) ON [PRIMARY]
409 GO
410
411 ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD
412 CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED
413 (
414 [ban_id]
415 ) ON [PRIMARY]
416 GO
417
418 ALTER TABLE [phpbb_categories] WITH NOCHECK ADD
419 CONSTRAINT [PK_phpbb_categories] PRIMARY KEY CLUSTERED
420 (
421 [cat_id]
422 ) ON [PRIMARY]
423 GO
424
425 ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD
426 CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY CLUSTERED
427 (
428 [session_id],[confirm_id]
429 ) ON [PRIMARY]
430 GO
431
432 ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD
433 CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED
434 (
435 [disallow_id]
436 ) ON [PRIMARY]
437 GO
438
439 ALTER TABLE [phpbb_forum_prune] WITH NOCHECK ADD
440 CONSTRAINT [PK_phpbb_forum_prune] PRIMARY KEY CLUSTERED
441 (
442 [prune_id]
443 ) ON [PRIMARY]
444 GO
445
446 ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
447 CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED
448 (
449 [forum_id]
450 ) ON [PRIMARY]
451 GO
452
453 ALTER TABLE [phpbb_groups] WITH NOCHECK ADD
454 CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED
455 (
456 [group_id]
457 ) ON [PRIMARY]
458 GO
459
460 ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
461 CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED
462 (
463 [post_id]
464 ) ON [PRIMARY]
465 GO
466
467 ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD
468 CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED
469 (
470 [privmsgs_id]
471 ) ON [PRIMARY]
472 GO
473
474 ALTER TABLE [phpbb_privmsgs_text] WITH NOCHECK ADD
475 CONSTRAINT [PK_phpbb_privmsgs_text] PRIMARY KEY CLUSTERED
476 (
477 [privmsgs_text_id]
478 ) ON [PRIMARY]
479 GO
480
481 ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD
482 CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED
483 (
484 [rank_id]
485 ) ON [PRIMARY]
486 GO
487
488 ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD
489 CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED
490 (
491 [search_id]
492 ) ON [PRIMARY]
493 GO
494
495 ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD
496 CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED
497 (
498 [word_id]
499 ) ON [PRIMARY]
500 GO
501
502 ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD
503 CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED
504 (
505 [smilies_id]
506 ) ON [PRIMARY]
507 GO
508
509 ALTER TABLE [phpbb_themes] WITH NOCHECK ADD
510 CONSTRAINT [PK_phpbb_themes] PRIMARY KEY CLUSTERED
511 (
512 [themes_id]
513 ) ON [PRIMARY]
514 GO
515
516 ALTER TABLE [phpbb_themes_name] WITH NOCHECK ADD
517 CONSTRAINT [PK_phpbb_themes_name] PRIMARY KEY CLUSTERED
518 (
519 [themes_id]
520 ) ON [PRIMARY]
521 GO
522
523 ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
524 CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED
525 (
526 [topic_id]
527 ) ON [PRIMARY]
528 GO
529
530 ALTER TABLE [phpbb_users] WITH NOCHECK ADD
531 CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED
532 (
533 [user_id]
534 ) ON [PRIMARY]
535 GO
536
537 ALTER TABLE [phpbb_vote_desc] WITH NOCHECK ADD
538 CONSTRAINT [PK_phpbb_vote_desc] PRIMARY KEY CLUSTERED
539 (
540 [vote_id]
541 ) ON [PRIMARY]
542 GO
543
544 ALTER TABLE [phpbb_words] WITH NOCHECK ADD
545 CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED
546 (
547 [word_id]
548 ) ON [PRIMARY]
549 GO
550
551 ALTER TABLE [phpbb_auth_access] WITH NOCHECK ADD
552 CONSTRAINT [DF_phpbb_auth_access_auth_view] DEFAULT (0) FOR [auth_view],
553 CONSTRAINT [DF_phpbb_auth_access_auth_read] DEFAULT (0) FOR [auth_read],
554 CONSTRAINT [DF_phpbb_auth_access_auth_post] DEFAULT (0) FOR [auth_post],
555 CONSTRAINT [DF_phpbb_auth_access_auth_reply] DEFAULT (0) FOR [auth_reply],
556 CONSTRAINT [DF_phpbb_auth_access_auth_edit] DEFAULT (0) FOR [auth_edit],
557 CONSTRAINT [DF_phpbb_auth_access_auth_delete] DEFAULT (0) FOR [auth_delete],
558 CONSTRAINT [DF_phpbb_auth_access_auth_sticky] DEFAULT (0) FOR [auth_sticky],
559 CONSTRAINT [DF_phpbb_auth_access_auth_announce] DEFAULT (0) FOR [auth_announce],
560 CONSTRAINT [DF_phpbb_auth_access_auth_vote] DEFAULT (0) FOR [auth_vote],
561 CONSTRAINT [DF_phpbb_auth_access_auth_pollcreate] DEFAULT (0) FOR [auth_pollcreate],
562 CONSTRAINT [DF_phpbb_auth_access_auth_attachments] DEFAULT (0) FOR [auth_attachments],
563 CONSTRAINT [DF_phpbb_auth_access_auth_mod] DEFAULT (0) FOR [auth_mod]
564 GO
565
566 ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
567 CONSTRAINT [DF_phpbb_forums_forum_posts] DEFAULT (0) FOR [forum_posts],
568 CONSTRAINT [DF_phpbb_forums_forum_topics] DEFAULT (0) FOR [forum_topics],
569 CONSTRAINT [DF_phpbb_forums_forum_last_post_id] DEFAULT (0) FOR [forum_last_post_id],
570 CONSTRAINT [DF_phpbb_forums_prune_enable] DEFAULT (0) FOR [prune_enable],
571 CONSTRAINT [DF_phpbb_forums_auth_view] DEFAULT (0) FOR [auth_view],
572 CONSTRAINT [DF_phpbb_forums_auth_read] DEFAULT (0) FOR [auth_read],
573 CONSTRAINT [DF_phpbb_forums_auth_post] DEFAULT (0) FOR [auth_post],
574 CONSTRAINT [DF_phpbb_forums_auth_reply] DEFAULT (0) FOR [auth_reply],
575 CONSTRAINT [DF_phpbb_forums_auth_edit] DEFAULT (0) FOR [auth_edit],
576 CONSTRAINT [DF_phpbb_forums_auth_delete] DEFAULT (0) FOR [auth_delete],
577 CONSTRAINT [DF_phpbb_forums_auth_sticky] DEFAULT (0) FOR [auth_sticky],
578 CONSTRAINT [DF_phpbb_forums_auth_announce] DEFAULT (0) FOR [auth_announce],
579 CONSTRAINT [DF_phpbb_forums_auth_vote] DEFAULT (0) FOR [auth_vote],
580 CONSTRAINT [DF_phpbb_forums_auth_pollcreate] DEFAULT (0) FOR [auth_pollcreate],
581 CONSTRAINT [DF_phpbb_forums_auth_attachments] DEFAULT (0) FOR [auth_attachments]
582 GO
583
584 ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD
585 CONSTRAINT [DF_phpbb_confirm_confirm_id] DEFAULT ('') FOR [confirm_id],
586 CONSTRAINT [DF_phpbb_confirm_session_id] DEFAULT ('') FOR [session_id],
587 CONSTRAINT [DF_phpbb_confirm_code] DEFAULT ('') FOR [code]
588 GO
589
590 ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
591 CONSTRAINT [DF_phpbb_posts_enable_bbcode] DEFAULT (1) FOR [enable_bbcode],
592 CONSTRAINT [DF_phpbb_posts_enable_html] DEFAULT (0) FOR [enable_html],
593 CONSTRAINT [DF_phpbb_posts_enable_smilies] DEFAULT (1) FOR [enable_smilies],
594 CONSTRAINT [DF_phpbb_posts_enable_sig] DEFAULT (1) FOR [enable_sig],
595 CONSTRAINT [DF_phpbb_posts_post_edit_count] DEFAULT (0) FOR [post_edit_count]
596 GO
597
598 ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD
599 CONSTRAINT [DF_phpbb_search_results_search_time] DEFAULT (0) FOR [search_time]
600 GO
601
602 ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD
603 CONSTRAINT [DF_phpbb_search_wordlist_word_common] DEFAULT (0) FOR [word_common]
604 GO
605
606 ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
607 CONSTRAINT [DF_phpbb_topics_topic_views] DEFAULT (0) FOR [topic_views],
608 CONSTRAINT [DF_phpbb_topics_topic_replies] DEFAULT (0) FOR [topic_replies],
609 CONSTRAINT [DF_phpbb_topics_topic_status] DEFAULT (0) FOR [topic_status],
610 CONSTRAINT [DF_phpbb_topics_topic_type] DEFAULT (0) FOR [topic_type],
611 CONSTRAINT [DF_phpbb_topics_topic_vote] DEFAULT (0) FOR [topic_vote],
612 CONSTRAINT [DF_phpbb_topics_topic_moved_id] DEFAULT (0) FOR topic_moved_id
613 GO
614
615 ALTER TABLE [phpbb_users] WITH NOCHECK ADD
616 CONSTRAINT [DF_phpbb_users_user_level] DEFAULT (0) FOR [user_level],
617 CONSTRAINT [DF_phpbb_users_user_posts] DEFAULT (0) FOR [user_posts],
618 CONSTRAINT [DF_phpbb_users_user_session_time] DEFAULT (0) FOR [user_session_time],
619 CONSTRAINT [DF_phpbb_users_user_session_page] DEFAULT (0) FOR [user_session_page],
620 CONSTRAINT [DF_phpbb_users_user_lastvisit] DEFAULT (0) FOR [user_lastvisit],
621 CONSTRAINT [DF_phpbb_users_user_new_privmsg] DEFAULT (0) FOR [user_new_privmsg],
622 CONSTRAINT [DF_phpbb_users_user_unread_privmsg] DEFAULT (0) FOR [user_unread_privmsg],
623 CONSTRAINT [DF_phpbb_users_user_last_privmsg] DEFAULT (0) FOR [user_last_privmsg],
624 CONSTRAINT [DF_phpbb_users_user_login_tries] DEFAULT (0) FOR [user_login_tries],
625 CONSTRAINT [DF_phpbb_users_user_last_login_try] DEFAULT (0) FOR [user_last_login_try],
626 CONSTRAINT [DF_phpbb_users_user_emailtime] DEFAULT (0) FOR [user_emailtime],
627 CONSTRAINT [DF_phpbb_users_user_viewemail] DEFAULT (1) FOR [user_viewemail],
628 CONSTRAINT [DF_phpbb_users_user_attachsig] DEFAULT (1) FOR [user_attachsig],
629 CONSTRAINT [DF_phpbb_users_user_allowhtml] DEFAULT (0) FOR [user_allowhtml],
630 CONSTRAINT [DF_phpbb_users_user_allowbbcode] DEFAULT (1) FOR [user_allowbbcode],
631 CONSTRAINT [DF_phpbb_users_user_allowsmile] DEFAULT (1) FOR [user_allowsmile],
632 CONSTRAINT [DF_phpbb_users_user_allowavatar] DEFAULT (1) FOR [user_allowavatar],
633 CONSTRAINT [DF_phpbb_users_user_allow_pm] DEFAULT (1) FOR [user_allow_pm],
634 CONSTRAINT [DF_phpbb_users_user_allow_viewonline] DEFAULT (1) FOR [user_allow_viewonline],
635 CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (0) FOR [user_notify_pm],
636 CONSTRAINT [DF_phpbb_users_user_popup_pm] DEFAULT (1) FOR [user_popup_pm],
637 CONSTRAINT [DF_phpbb_users_user_dateformat] DEFAULT('d M Y H:i') FOR [user_dateformat],
638 CONSTRAINT [DF_phpbb_users_user_avatar_type] DEFAULT (0) FOR [user_avatar_type]
639 GO
640
641 CREATE INDEX [IX_phpbb_auth_access] ON [phpbb_auth_access]([group_id], [forum_id]) ON [PRIMARY]
642 GO
643
644 CREATE INDEX [IX_phpbb_banlist] ON [phpbb_banlist]([ban_userid], [ban_ip]) ON [PRIMARY]
645 GO
646
647 CREATE INDEX [IX_phpbb_categories] ON [phpbb_categories]([cat_order]) ON [PRIMARY]
648 GO
649
650 CREATE INDEX [IX_phpbb_forum_prune] ON [phpbb_forum_prune]([forum_id]) ON [PRIMARY]
651 GO
652
653 CREATE INDEX [IX_phpbb_forums] ON [phpbb_forums]([cat_id], [forum_order], [forum_last_post_id]) ON [PRIMARY]
654 GO
655
656 CREATE INDEX [IX_phpbb_groups] ON [phpbb_groups]([group_single_user]) ON [PRIMARY]
657 GO
658
659 CREATE INDEX [IX_phpbb_posts] ON [phpbb_posts]([topic_id], [forum_id], [poster_id]) ON [PRIMARY]
660 GO
661
662 CREATE INDEX [IX_phpbb_posts_text] ON [phpbb_posts_text]([post_id]) ON [PRIMARY]
663 GO
664
665 CREATE INDEX [IX_phpbb_privmsgs] ON [phpbb_privmsgs]([privmsgs_from_userid], [privmsgs_to_userid]) ON [PRIMARY]
666 GO
667
668 CREATE INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_special]) ON [PRIMARY]
669 GO
670
671 CREATE INDEX [IX_phpbb_search_results] ON [phpbb_search_results]([session_id]) ON [PRIMARY]
672 GO
673
674 CREATE UNIQUE INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist]([word_text]) WITH IGNORE_DUP_KEY ON [PRIMARY]
675 GO
676
677 CREATE INDEX [IX_phpbb_search_wordlist_1] ON [phpbb_search_wordlist]([word_common]) ON [PRIMARY]
678 GO
679
680 CREATE INDEX [IX_phpbb_search_wordmatch] ON [phpbb_search_wordmatch]([post_id]) ON [PRIMARY]
681 GO
682
683 CREATE INDEX [IX_phpbb_search_wordmatch_1] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY]
684 GO
685
686 CREATE INDEX [IX_phpbb_sessions] ON [phpbb_sessions]([session_id], [session_user_id], [session_ip], [session_logged_in]) ON [PRIMARY]
687 GO
688
689 CREATE INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([key_id], [user_id]) ON [PRIMARY]
690 GO
691
692 CREATE INDEX [IX_phpbb_sessions_keys_1] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
693 GO
694
695 CREATE INDEX [IX_phpbb_topics] ON [phpbb_topics]([forum_id], [topic_type], [topic_first_post_id], [topic_last_post_id]) ON [PRIMARY]
696 GO
697
698 CREATE INDEX [IX_phpbb_topics_watch] ON [phpbb_topics_watch]([topic_id], [user_id]) ON [PRIMARY]
699 GO
700
701 CREATE INDEX [IX_phpbb_users] ON [phpbb_users]([user_session_time]) ON [PRIMARY]
702 GO
703
704 CREATE INDEX [IX_phpbb_user_group] ON [phpbb_user_group]([group_id], [user_id]) ON [PRIMARY]
705 GO
706
707 CREATE INDEX [IX_phpbb_vote_desc] ON [phpbb_vote_desc]([topic_id]) ON [PRIMARY]
708 GO
709
710 CREATE INDEX [IX_phpbb_vote_results] ON [phpbb_vote_results]([vote_id]) ON [PRIMARY]
711 GO
712
713 CREATE INDEX [IX_phpbb_vote_results_1] ON [phpbb_vote_results]([vote_option_id]) ON [PRIMARY]
714 GO
715
716 CREATE INDEX [IX_phpbb_vote_voters] ON [phpbb_vote_voters]([vote_id]) ON [PRIMARY]
717 GO
718
719 CREATE INDEX [IX_phpbb_vote_voters_1] ON [phpbb_vote_voters]([vote_user_id]) ON [PRIMARY]
720 GO
721
722 COMMIT
723 GO