1/* 2 3 mssql_schema.sql for phpBB2 (c) 2001, phpBB Group 4 5 $Id: mssql_schema.sql 5532 2006-02-06 21:32:42Z grahamje $ 6 7*/ 8 9BEGIN TRANSACTION 10GO 11 12CREATE TABLE [phpbb_auth_access] ( 13 [group_id] [int] NULL , 14 [forum_id] [int] NULL , 15 [auth_view] [smallint] NOT NULL , 16 [auth_read] [smallint] NOT NULL , 17 [auth_post] [smallint] NOT NULL , 18 [auth_reply] [smallint] NOT NULL , 19 [auth_edit] [smallint] NOT NULL , 20 [auth_delete] [smallint] NOT NULL , 21 [auth_sticky] [smallint] NOT NULL , 22 [auth_announce] [smallint] NOT NULL , 23 [auth_vote] [smallint] NOT NULL , 24 [auth_pollcreate] [smallint] NOT NULL , 25 [auth_attachments] [smallint] NOT NULL , 26 [auth_mod] [smallint] NOT NULL 27) ON [PRIMARY] 28GO 29 30CREATE TABLE [phpbb_banlist] ( 31 [ban_id] [int] IDENTITY (1, 1) NOT NULL , 32 [ban_userid] [int] NULL , 33 [ban_ip] [char] (8) NULL , 34 [ban_email] [varchar] (50) NULL 35) ON [PRIMARY] 36GO 37 38CREATE TABLE [phpbb_categories] ( 39 [cat_id] [int] IDENTITY (1, 1) NOT NULL , 40 [cat_title] [varchar] (50) NOT NULL , 41 [cat_order] [int] NOT NULL 42) ON [PRIMARY] 43GO 44 45CREATE TABLE [phpbb_config] ( 46 [config_name] [varchar] (255) NULL , 47 [config_value] [varchar] (255) NULL 48) ON [PRIMARY] 49GO 50 51 52CREATE TABLE [phpbb_confirm] ( 53 [confirm_id] [char] (32) NOT NULL , 54 [session_id] [char] (32) NOT NULL , 55 [code] [char] (6) NOT NULL 56) ON [PRIMARY] 57GO 58 59CREATE TABLE [phpbb_disallow] ( 60 [disallow_id] [int] IDENTITY (1, 1) NOT NULL , 61 [disallow_username] [varchar] (100) NULL 62) ON [PRIMARY] 63GO 64 65CREATE TABLE [phpbb_forum_prune] ( 66 [prune_id] [int] IDENTITY (1, 1) NOT NULL , 67 [forum_id] [int] NOT NULL , 68 [prune_days] [int] NOT NULL , 69 [prune_freq] [int] NOT NULL 70) ON [PRIMARY] 71GO 72 73CREATE TABLE [phpbb_forums] ( 74 [forum_id] [int] NOT NULL , 75 [cat_id] [int] NOT NULL , 76 [forum_name] [varchar] (100) NOT NULL , 77 [forum_desc] [varchar] (255) NULL , 78 [forum_status] [smallint] NOT NULL , 79 [forum_order] [int] NOT NULL , 80 [forum_posts] [int] NOT NULL , 81 [forum_topics] [smallint] NOT NULL , 82 [forum_last_post_id] [int] NOT NULL , 83 [prune_next] [int] NULL , 84 [prune_enable] [smallint] NOT NULL , 85 [auth_view] [smallint] NOT NULL , 86 [auth_read] [smallint] NOT NULL , 87 [auth_post] [smallint] NOT NULL , 88 [auth_reply] [smallint] NOT NULL , 89 [auth_edit] [smallint] NOT NULL , 90 [auth_delete] [smallint] NOT NULL , 91 [auth_sticky] [smallint] NOT NULL , 92 [auth_announce] [smallint] NOT NULL , 93 [auth_vote] [smallint] NOT NULL , 94 [auth_pollcreate] [smallint] NOT NULL , 95 [auth_attachments] [smallint] NOT NULL 96) ON [PRIMARY] 97GO 98 99CREATE 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] 107GO 108 109CREATE 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] 124GO 125 126CREATE 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] 132GO 133 134CREATE 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] 147GO 148 149CREATE 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] 154GO 155 156CREATE 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] 163GO 164 165CREATE 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] 171GO 172 173CREATE 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] 178GO 179 180CREATE 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] 185GO 186 187CREATE 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) ON [PRIMARY] 197GO 198 199CREATE TABLE [phpbb_sessions_keys] ( 200 [key_id] [char] (32) NOT NULL , 201 [user_id] [int] NOT NULL , 202 [last_ip] [char] (8) NOT NULL , 203 [last_login] [int] NOT NULL 204) ON [PRIMARY] 205GO 206 207CREATE TABLE [phpbb_smilies] ( 208 [smilies_id] [int] IDENTITY (1, 1) NOT NULL , 209 [code] [varchar] (10) NOT NULL , 210 [smile_url] [varchar] (50) NOT NULL , 211 [emoticon] [varchar] (50) NULL 212) ON [PRIMARY] 213GO 214 215CREATE TABLE [phpbb_themes] ( 216 [themes_id] [int] IDENTITY (1, 1) NOT NULL , 217 [template_name] [varchar] (30) NOT NULL , 218 [style_name] [varchar] (50) NOT NULL , 219 [head_stylesheet] [varchar] (50) NULL , 220 [body_background] [varchar] (50) NULL , 221 [body_bgcolor] [char] (6) NULL , 222 [body_text] [char] (6) NULL , 223 [body_link] [char] (6) NULL , 224 [body_vlink] [char] (6) NULL , 225 [body_alink] [char] (6) NULL , 226 [body_hlink] [char] (6) NULL , 227 [tr_color1] [char] (6) NULL , 228 [tr_color2] [char] (6) NULL , 229 [tr_color3] [char] (6) NULL , 230 [tr_class1] [varchar] (25) NULL , 231 [tr_class2] [varchar] (25) NULL , 232 [tr_class3] [varchar] (25) NULL , 233 [th_color1] [char] (6) NULL , 234 [th_color2] [char] (6) NULL , 235 [th_color3] [char] (6) NULL , 236 [th_class1] [varchar] (25) NULL , 237 [th_class2] [varchar] (25) NULL , 238 [th_class3] [varchar] (25) NULL , 239 [td_color1] [char] (6) NULL , 240 [td_color2] [char] (6) NULL , 241 [td_color3] [char] (6) NULL , 242 [td_class1] [varchar] (25) NULL , 243 [td_class2] [varchar] (25) NULL , 244 [td_class3] [varchar] (25) NULL , 245 [fontface1] [varchar] (50) NULL , 246 [fontface2] [varchar] (50) NULL , 247 [fontface3] [varchar] (50) NULL , 248 [fontsize1] [smallint] NULL , 249 [fontsize2] [smallint] NULL , 250 [fontsize3] [smallint] NULL , 251 [fontcolor1] [char] (6) NULL , 252 [fontcolor2] [char] (6) NULL , 253 [fontcolor3] [char] (6) NULL , 254 [span_class1] [varchar] (25) NULL , 255 [span_class2] [varchar] (25) NULL , 256 [span_class3] [varchar] (25) NULL , 257 [img_size_poll] [smallint] NULL , 258 [img_size_privmsg] [smallint] NULL 259) ON [PRIMARY] 260GO 261 262CREATE TABLE [phpbb_themes_name] ( 263 [themes_id] [int] NOT NULL , 264 [tr_color1_name] [varchar] (50) NULL , 265 [tr_color2_name] [varchar] (50) NULL , 266 [tr_color3_name] [varchar] (50) NULL , 267 [tr_class1_name] [varchar] (50) NULL , 268 [tr_class2_name] [varchar] (50) NULL , 269 [tr_class3_name] [varchar] (50) NULL , 270 [th_color1_name] [varchar] (50) NULL , 271 [th_color2_name] [varchar] (50) NULL , 272 [th_color3_name] [varchar] (50) NULL , 273 [th_class1_name] [varchar] (50) NULL , 274 [th_class2_name] [varchar] (50) NULL , 275 [th_class3_name] [varchar] (50) NULL , 276 [td_color1_name] [varchar] (50) NULL , 277 [td_color2_name] [varchar] (50) NULL , 278 [td_color3_name] [varchar] (50) NULL , 279 [td_class1_name] [varchar] (50) NULL , 280 [td_class2_name] [varchar] (50) NULL , 281 [td_class3_name] [varchar] (50) NULL , 282 [fontface1_name] [varchar] (50) NULL , 283 [fontface2_name] [varchar] (50) NULL , 284 [fontface3_name] [varchar] (50) NULL , 285 [fontsize1_name] [varchar] (50) NULL , 286 [fontsize2_name] [varchar] (50) NULL , 287 [fontsize3_name] [varchar] (50) NULL , 288 [fontcolor1_name] [varchar] (50) NULL , 289 [fontcolor2_name] [varchar] (50) NULL , 290 [fontcolor3_name] [varchar] (50) NULL , 291 [span_class1_name] [varchar] (50) NULL , 292 [span_class2_name] [varchar] (50) NULL , 293 [span_class3_name] [varchar] (50) NULL 294) ON [PRIMARY] 295GO 296 297CREATE TABLE [phpbb_topics] ( 298 [topic_id] [int] IDENTITY (1, 1) NOT NULL , 299 [forum_id] [int] NOT NULL , 300 [topic_title] [varchar] (60) NOT NULL , 301 [topic_poster] [int] NOT NULL , 302 [topic_time] [int] NOT NULL , 303 [topic_views] [int] NOT NULL , 304 [topic_replies] [int] NOT NULL , 305 [topic_status] [smallint] NOT NULL , 306 [topic_type] [smallint] NOT NULL , 307 [topic_vote] [smallint] NOT NULL , 308 [topic_first_post_id] [int] NULL , 309 [topic_last_post_id] [int] NULL , 310 [topic_moved_id] [int] NULL 311) ON [PRIMARY] 312GO 313 314CREATE TABLE [phpbb_topics_watch] ( 315 [topic_id] [int] NOT NULL , 316 [user_id] [int] NOT NULL , 317 [notify_status] [smallint] NOT NULL 318) ON [PRIMARY] 319GO 320 321CREATE TABLE [phpbb_user_group] ( 322 [group_id] [int] NOT NULL , 323 [user_id] [int] NOT NULL , 324 [user_pending] [smallint] NULL 325) ON [PRIMARY] 326GO 327 328CREATE TABLE [phpbb_users] ( 329 [user_id] [int] NOT NULL , 330 [user_active] [smallint] NULL , 331 [username] [varchar] (25) NOT NULL , 332 [user_password] [varchar] (32) NOT NULL , 333 [user_session_time] [int] NOT NULL , 334 [user_session_page] [smallint] NOT NULL , 335 [user_lastvisit] [int] NOT NULL , 336 [user_regdate] [int] NOT NULL , 337 [user_level] [smallint] NOT NULL , 338 [user_posts] [int] NOT NULL , 339 [user_timezone] [decimal] (5,2) NOT NULL , 340 [user_style] [int] NULL , 341 [user_lang] [varchar] (255) NULL , 342 [user_dateformat] [varchar] (14) NOT NULL , 343 [user_new_privmsg] [smallint] NOT NULL , 344 [user_unread_privmsg] [smallint] NOT NULL , 345 [user_last_privmsg] [int] NOT NULL , 346 [user_login_tries] [smallint] NOT NULL , 347 [user_last_login_try] [int] NOT NULL , 348 [user_emailtime] [int] NOT NULL , 349 [user_viewemail] [smallint] NULL , 350 [user_attachsig] [smallint] NULL , 351 [user_allowhtml] [smallint] NULL , 352 [user_allowbbcode] [smallint] NULL , 353 [user_allowsmile] [smallint] NULL , 354 [user_allowavatar] [smallint] NULL , 355 [user_allow_pm] [smallint] NOT NULL , 356 [user_allow_viewonline] [smallint] NOT NULL , 357 [user_notify_pm] [smallint] NOT NULL , 358 [user_popup_pm] [smallint] NULL , 359 [user_rank] [int] NULL , 360 [user_avatar_type] [smallint] NULL , 361 [user_avatar] [varchar] (100) NULL , 362 [user_email] [varchar] (255) NULL , 363 [user_icq] [varchar] (15) NULL , 364 [user_website] [varchar] (100) NULL , 365 [user_occ] [varchar] (100) NULL , 366 [user_from] [varchar] (100) NULL , 367 [user_sig] [text] NULL , 368 [user_sig_bbcode_uid] [char] (10) NULL , 369 [user_aim] [varchar] (255) NULL , 370 [user_yim] [varchar] (255) NULL , 371 [user_msnm] [varchar] (255) NULL , 372 [user_interests] [varchar] (255) NULL , 373 [user_actkey] [varchar] (32) NULL , 374 [user_newpasswd] [varchar] (32) NULL , 375 [user_notify] [smallint] NOT NULL 376) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 377GO 378 379CREATE TABLE [phpbb_vote_desc] ( 380 [vote_id] [int] IDENTITY (1, 1) NOT NULL , 381 [topic_id] [int] NOT NULL , 382 [vote_text] [varchar] (255) NOT NULL , 383 [vote_start] [int] NOT NULL , 384 [vote_length] [int] NOT NULL 385) ON [PRIMARY] 386GO 387 388CREATE TABLE [phpbb_vote_results] ( 389 [vote_id] [int] NOT NULL , 390 [vote_option_id] [int] NOT NULL , 391 [vote_option_text] [varchar] (255) NOT NULL , 392 [vote_result] [int] NOT NULL 393) ON [PRIMARY] 394GO 395 396CREATE TABLE [phpbb_vote_voters] ( 397 [vote_id] [int] NOT NULL , 398 [vote_user_id] [int] NOT NULL , 399 [vote_user_ip] [char] (8) NOT NULL 400) ON [PRIMARY] 401GO 402 403CREATE TABLE [phpbb_words] ( 404 [word_id] [int] IDENTITY (1, 1) NOT NULL , 405 [word] [varchar] (255) NOT NULL , 406 [replacement] [varchar] (255) NOT NULL 407) ON [PRIMARY] 408GO 409 410ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD 411 CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY CLUSTERED 412 ( 413 [ban_id] 414 ) ON [PRIMARY] 415GO 416 417ALTER TABLE [phpbb_categories] WITH NOCHECK ADD 418 CONSTRAINT [PK_phpbb_categories] PRIMARY KEY CLUSTERED 419 ( 420 [cat_id] 421 ) ON [PRIMARY] 422GO 423 424ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD 425 CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY CLUSTERED 426 ( 427 [session_id],[confirm_id] 428 ) ON [PRIMARY] 429GO 430 431ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD 432 CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY CLUSTERED 433 ( 434 [disallow_id] 435 ) ON [PRIMARY] 436GO 437 438ALTER TABLE [phpbb_forum_prune] WITH NOCHECK ADD 439 CONSTRAINT [PK_phpbb_forum_prune] PRIMARY KEY CLUSTERED 440 ( 441 [prune_id] 442 ) ON [PRIMARY] 443GO 444 445ALTER TABLE [phpbb_forums] WITH NOCHECK ADD 446 CONSTRAINT [PK_phpbb_forums] PRIMARY KEY CLUSTERED 447 ( 448 [forum_id] 449 ) ON [PRIMARY] 450GO 451 452ALTER TABLE [phpbb_groups] WITH NOCHECK ADD 453 CONSTRAINT [PK_phpbb_groups] PRIMARY KEY CLUSTERED 454 ( 455 [group_id] 456 ) ON [PRIMARY] 457GO 458 459ALTER TABLE [phpbb_posts] WITH NOCHECK ADD 460 CONSTRAINT [PK_phpbb_posts] PRIMARY KEY CLUSTERED 461 ( 462 [post_id] 463 ) ON [PRIMARY] 464GO 465 466ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD 467 CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY CLUSTERED 468 ( 469 [privmsgs_id] 470 ) ON [PRIMARY] 471GO 472 473ALTER TABLE [phpbb_privmsgs_text] WITH NOCHECK ADD 474 CONSTRAINT [PK_phpbb_privmsgs_text] PRIMARY KEY CLUSTERED 475 ( 476 [privmsgs_text_id] 477 ) ON [PRIMARY] 478GO 479 480ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD 481 CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY CLUSTERED 482 ( 483 [rank_id] 484 ) ON [PRIMARY] 485GO 486 487ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD 488 CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY CLUSTERED 489 ( 490 [search_id] 491 ) ON [PRIMARY] 492GO 493 494ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD 495 CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY CLUSTERED 496 ( 497 [word_id] 498 ) ON [PRIMARY] 499GO 500 501ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD 502 CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY CLUSTERED 503 ( 504 [smilies_id] 505 ) ON [PRIMARY] 506GO 507 508ALTER TABLE [phpbb_themes] WITH NOCHECK ADD 509 CONSTRAINT [PK_phpbb_themes] PRIMARY KEY CLUSTERED 510 ( 511 [themes_id] 512 ) ON [PRIMARY] 513GO 514 515ALTER TABLE [phpbb_themes_name] WITH NOCHECK ADD 516 CONSTRAINT [PK_phpbb_themes_name] PRIMARY KEY CLUSTERED 517 ( 518 [themes_id] 519 ) ON [PRIMARY] 520GO 521 522ALTER TABLE [phpbb_topics] WITH NOCHECK ADD 523 CONSTRAINT [PK_phpbb_topics] PRIMARY KEY CLUSTERED 524 ( 525 [topic_id] 526 ) ON [PRIMARY] 527GO 528 529ALTER TABLE [phpbb_users] WITH NOCHECK ADD 530 CONSTRAINT [PK_phpbb_users] PRIMARY KEY CLUSTERED 531 ( 532 [user_id] 533 ) ON [PRIMARY] 534GO 535 536ALTER TABLE [phpbb_vote_desc] WITH NOCHECK ADD 537 CONSTRAINT [PK_phpbb_vote_desc] PRIMARY KEY CLUSTERED 538 ( 539 [vote_id] 540 ) ON [PRIMARY] 541GO 542 543ALTER TABLE [phpbb_words] WITH NOCHECK ADD 544 CONSTRAINT [PK_phpbb_words] PRIMARY KEY CLUSTERED 545 ( 546 [word_id] 547 ) ON [PRIMARY] 548GO 549 550ALTER TABLE [phpbb_auth_access] WITH NOCHECK ADD 551 CONSTRAINT [DF_phpbb_auth_access_auth_view] DEFAULT (0) FOR [auth_view], 552 CONSTRAINT [DF_phpbb_auth_access_auth_read] DEFAULT (0) FOR [auth_read], 553 CONSTRAINT [DF_phpbb_auth_access_auth_post] DEFAULT (0) FOR [auth_post], 554 CONSTRAINT [DF_phpbb_auth_access_auth_reply] DEFAULT (0) FOR [auth_reply], 555 CONSTRAINT [DF_phpbb_auth_access_auth_edit] DEFAULT (0) FOR [auth_edit], 556 CONSTRAINT [DF_phpbb_auth_access_auth_delete] DEFAULT (0) FOR [auth_delete], 557 CONSTRAINT [DF_phpbb_auth_access_auth_sticky] DEFAULT (0) FOR [auth_sticky], 558 CONSTRAINT [DF_phpbb_auth_access_auth_announce] DEFAULT (0) FOR [auth_announce], 559 CONSTRAINT [DF_phpbb_auth_access_auth_vote] DEFAULT (0) FOR [auth_vote], 560 CONSTRAINT [DF_phpbb_auth_access_auth_pollcreate] DEFAULT (0) FOR [auth_pollcreate], 561 CONSTRAINT [DF_phpbb_auth_access_auth_attachments] DEFAULT (0) FOR [auth_attachments], 562 CONSTRAINT [DF_phpbb_auth_access_auth_mod] DEFAULT (0) FOR [auth_mod] 563GO 564 565ALTER TABLE [phpbb_forums] WITH NOCHECK ADD 566 CONSTRAINT [DF_phpbb_forums_forum_posts] DEFAULT (0) FOR [forum_posts], 567 CONSTRAINT [DF_phpbb_forums_forum_topics] DEFAULT (0) FOR [forum_topics], 568 CONSTRAINT [DF_phpbb_forums_forum_last_post_id] DEFAULT (0) FOR [forum_last_post_id], 569 CONSTRAINT [DF_phpbb_forums_prune_enable] DEFAULT (0) FOR [prune_enable], 570 CONSTRAINT [DF_phpbb_forums_auth_view] DEFAULT (0) FOR [auth_view], 571 CONSTRAINT [DF_phpbb_forums_auth_read] DEFAULT (0) FOR [auth_read], 572 CONSTRAINT [DF_phpbb_forums_auth_post] DEFAULT (0) FOR [auth_post], 573 CONSTRAINT [DF_phpbb_forums_auth_reply] DEFAULT (0) FOR [auth_reply], 574 CONSTRAINT [DF_phpbb_forums_auth_edit] DEFAULT (0) FOR [auth_edit], 575 CONSTRAINT [DF_phpbb_forums_auth_delete] DEFAULT (0) FOR [auth_delete], 576 CONSTRAINT [DF_phpbb_forums_auth_sticky] DEFAULT (0) FOR [auth_sticky], 577 CONSTRAINT [DF_phpbb_forums_auth_announce] DEFAULT (0) FOR [auth_announce], 578 CONSTRAINT [DF_phpbb_forums_auth_vote] DEFAULT (0) FOR [auth_vote], 579 CONSTRAINT [DF_phpbb_forums_auth_pollcreate] DEFAULT (0) FOR [auth_pollcreate], 580 CONSTRAINT [DF_phpbb_forums_auth_attachments] DEFAULT (0) FOR [auth_attachments] 581GO 582 583ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD 584 CONSTRAINT [DF_phpbb_confirm_confirm_id] DEFAULT ('') FOR [confirm_id], 585 CONSTRAINT [DF_phpbb_confirm_session_id] DEFAULT ('') FOR [session_id], 586 CONSTRAINT [DF_phpbb_confirm_code] DEFAULT ('') FOR [code] 587GO 588 589ALTER TABLE [phpbb_posts] WITH NOCHECK ADD 590 CONSTRAINT [DF_phpbb_posts_enable_bbcode] DEFAULT (1) FOR [enable_bbcode], 591 CONSTRAINT [DF_phpbb_posts_enable_html] DEFAULT (0) FOR [enable_html], 592 CONSTRAINT [DF_phpbb_posts_enable_smilies] DEFAULT (1) FOR [enable_smilies], 593 CONSTRAINT [DF_phpbb_posts_enable_sig] DEFAULT (1) FOR [enable_sig], 594 CONSTRAINT [DF_phpbb_posts_post_edit_count] DEFAULT (0) FOR [post_edit_count] 595GO 596 597ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD 598 CONSTRAINT [DF_phpbb_search_results_search_time] DEFAULT (0) FOR [search_time] 599GO 600 601ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD 602 CONSTRAINT [DF_phpbb_search_wordlist_word_common] DEFAULT (0) FOR [word_common] 603GO 604 605ALTER TABLE [phpbb_topics] WITH NOCHECK ADD 606 CONSTRAINT [DF_phpbb_topics_topic_views] DEFAULT (0) FOR [topic_views], 607 CONSTRAINT [DF_phpbb_topics_topic_replies] DEFAULT (0) FOR [topic_replies], 608 CONSTRAINT [DF_phpbb_topics_topic_status] DEFAULT (0) FOR [topic_status], 609 CONSTRAINT [DF_phpbb_topics_topic_type] DEFAULT (0) FOR [topic_type], 610 CONSTRAINT [DF_phpbb_topics_topic_vote] DEFAULT (0) FOR [topic_vote], 611 CONSTRAINT [DF_phpbb_topics_topic_moved_id] DEFAULT (0) FOR topic_moved_id 612GO 613 614ALTER TABLE [phpbb_users] WITH NOCHECK ADD 615 CONSTRAINT [DF_phpbb_users_user_level] DEFAULT (0) FOR [user_level], 616 CONSTRAINT [DF_phpbb_users_user_posts] DEFAULT (0) FOR [user_posts], 617 CONSTRAINT [DF_phpbb_users_user_session_time] DEFAULT (0) FOR [user_session_time], 618 CONSTRAINT [DF_phpbb_users_user_session_page] DEFAULT (0) FOR [user_session_page], 619 CONSTRAINT [DF_phpbb_users_user_lastvisit] DEFAULT (0) FOR [user_lastvisit], 620 CONSTRAINT [DF_phpbb_users_user_new_privmsg] DEFAULT (0) FOR [user_new_privmsg], 621 CONSTRAINT [DF_phpbb_users_user_unread_privmsg] DEFAULT (0) FOR [user_unread_privmsg], 622 CONSTRAINT [DF_phpbb_users_user_last_privmsg] DEFAULT (0) FOR [user_last_privmsg], 623 CONSTRAINT [DF_phpbb_users_user_login_tries] DEFAULT (0) FOR [user_login_tries], 624 CONSTRAINT [DF_phpbb_users_user_last_login_try] DEFAULT (0) FOR [user_last_login_try], 625 CONSTRAINT [DF_phpbb_users_user_emailtime] DEFAULT (0) FOR [user_emailtime], 626 CONSTRAINT [DF_phpbb_users_user_viewemail] DEFAULT (1) FOR [user_viewemail], 627 CONSTRAINT [DF_phpbb_users_user_attachsig] DEFAULT (1) FOR [user_attachsig], 628 CONSTRAINT [DF_phpbb_users_user_allowhtml] DEFAULT (0) FOR [user_allowhtml], 629 CONSTRAINT [DF_phpbb_users_user_allowbbcode] DEFAULT (1) FOR [user_allowbbcode], 630 CONSTRAINT [DF_phpbb_users_user_allowsmile] DEFAULT (1) FOR [user_allowsmile], 631 CONSTRAINT [DF_phpbb_users_user_allowavatar] DEFAULT (1) FOR [user_allowavatar], 632 CONSTRAINT [DF_phpbb_users_user_allow_pm] DEFAULT (1) FOR [user_allow_pm], 633 CONSTRAINT [DF_phpbb_users_user_allow_viewonline] DEFAULT (1) FOR [user_allow_viewonline], 634 CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (0) FOR [user_notify_pm], 635 CONSTRAINT [DF_phpbb_users_user_popup_pm] DEFAULT (1) FOR [user_popup_pm], 636 CONSTRAINT [DF_phpbb_users_user_dateformat] DEFAULT('d M Y H:i') FOR [user_dateformat], 637 CONSTRAINT [DF_phpbb_users_user_avatar_type] DEFAULT (0) FOR [user_avatar_type] 638GO 639 640 CREATE INDEX [IX_phpbb_auth_access] ON [phpbb_auth_access]([group_id], [forum_id]) ON [PRIMARY] 641GO 642 643 CREATE INDEX [IX_phpbb_banlist] ON [phpbb_banlist]([ban_userid], [ban_ip]) ON [PRIMARY] 644GO 645 646 CREATE INDEX [IX_phpbb_categories] ON [phpbb_categories]([cat_order]) ON [PRIMARY] 647GO 648 649 CREATE INDEX [IX_phpbb_forum_prune] ON [phpbb_forum_prune]([forum_id]) ON [PRIMARY] 650GO 651 652 CREATE INDEX [IX_phpbb_forums] ON [phpbb_forums]([cat_id], [forum_order], [forum_last_post_id]) ON [PRIMARY] 653GO 654 655 CREATE INDEX [IX_phpbb_groups] ON [phpbb_groups]([group_single_user]) ON [PRIMARY] 656GO 657 658 CREATE INDEX [IX_phpbb_posts] ON [phpbb_posts]([topic_id], [forum_id], [poster_id]) ON [PRIMARY] 659GO 660 661 CREATE INDEX [IX_phpbb_posts_text] ON [phpbb_posts_text]([post_id]) ON [PRIMARY] 662GO 663 664 CREATE INDEX [IX_phpbb_privmsgs] ON [phpbb_privmsgs]([privmsgs_from_userid], [privmsgs_to_userid]) ON [PRIMARY] 665GO 666 667 CREATE INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_special]) ON [PRIMARY] 668GO 669 670 CREATE INDEX [IX_phpbb_search_results] ON [phpbb_search_results]([session_id]) ON [PRIMARY] 671GO 672 673 CREATE UNIQUE INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist]([word_text]) WITH IGNORE_DUP_KEY ON [PRIMARY] 674GO 675 676 CREATE INDEX [IX_phpbb_search_wordlist_1] ON [phpbb_search_wordlist]([word_common]) ON [PRIMARY] 677GO 678 679 CREATE INDEX [IX_phpbb_search_wordmatch] ON [phpbb_search_wordmatch]([post_id]) ON [PRIMARY] 680GO 681 682 CREATE INDEX [IX_phpbb_search_wordmatch_1] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY] 683GO 684 685 CREATE INDEX [IX_phpbb_sessions] ON [phpbb_sessions]([session_id], [session_user_id], [session_ip], [session_logged_in]) ON [PRIMARY] 686GO 687 688 CREATE INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([key_id], [user_id]) ON [PRIMARY] 689GO 690 691 CREATE INDEX [IX_phpbb_sessions_keys_1] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY] 692GO 693 694 CREATE INDEX [IX_phpbb_topics] ON [phpbb_topics]([forum_id], [topic_type], [topic_first_post_id], [topic_last_post_id]) ON [PRIMARY] 695GO 696 697 CREATE INDEX [IX_phpbb_topics_watch] ON [phpbb_topics_watch]([topic_id], [user_id]) ON [PRIMARY] 698GO 699 700 CREATE INDEX [IX_phpbb_users] ON [phpbb_users]([user_session_time]) ON [PRIMARY] 701GO 702 703 CREATE INDEX [IX_phpbb_user_group] ON [phpbb_user_group]([group_id], [user_id]) ON [PRIMARY] 704GO 705 706 CREATE INDEX [IX_phpbb_vote_desc] ON [phpbb_vote_desc]([topic_id]) ON [PRIMARY] 707GO 708 709 CREATE INDEX [IX_phpbb_vote_results] ON [phpbb_vote_results]([vote_id]) ON [PRIMARY] 710GO 711 712 CREATE INDEX [IX_phpbb_vote_results_1] ON [phpbb_vote_results]([vote_option_id]) ON [PRIMARY] 713GO 714 715 CREATE INDEX [IX_phpbb_vote_voters] ON [phpbb_vote_voters]([vote_id]) ON [PRIMARY] 716GO 717 718 CREATE INDEX [IX_phpbb_vote_voters_1] ON [phpbb_vote_voters]([vote_user_id]) ON [PRIMARY] 719GO 720 721COMMIT 722GO