[Summary view] [Print] [Text view]

   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  
   9  BEGIN TRANSACTION
  10  GO
  11  
  12  CREATE 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]
  28  GO
  29  
  30  CREATE 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]
  36  GO
  37  
  38  CREATE 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]
  43  GO
  44  
  45  CREATE TABLE [phpbb_config] (
  46      [config_name] [varchar] (255) NULL ,
  47      [config_value] [varchar] (255) NULL
  48  ) ON [PRIMARY]
  49  GO
  50  
  51  
  52  CREATE 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]
  57  GO
  58  
  59  CREATE TABLE [phpbb_disallow] (
  60      [disallow_id] [int] IDENTITY (1, 1) NOT NULL ,
  61      [disallow_username] [varchar] (100) NULL
  62  ) ON [PRIMARY]
  63  GO
  64  
  65  CREATE 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]
  71  GO
  72  
  73  CREATE 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]
  97  GO
  98  
  99  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  ) ON [PRIMARY]
 197  GO
 198  
 199  CREATE 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]
 205  GO
 206  
 207  CREATE 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]
 213  GO
 214  
 215  CREATE 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]
 260  GO
 261  
 262  CREATE 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]
 295  GO
 296  
 297  CREATE 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]
 312  GO
 313  
 314  CREATE 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]
 319  GO
 320  
 321  CREATE TABLE [phpbb_user_group] (
 322      [group_id] [int] NOT NULL ,
 323      [user_id] [int] NOT NULL ,
 324      [user_pending] [smallint] NULL
 325  ) ON [PRIMARY]
 326  GO
 327  
 328  CREATE 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]
 377  GO
 378  
 379  CREATE 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]
 386  GO
 387  
 388  CREATE 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]
 394  GO
 395  
 396  CREATE 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]
 401  GO
 402  
 403  CREATE 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]
 408  GO
 409  
 410  ALTER TABLE [phpbb_banlist] WITH NOCHECK ADD
 411      CONSTRAINT [PK_phpbb_banlist] PRIMARY KEY  CLUSTERED
 412      (
 413          [ban_id]
 414      )  ON [PRIMARY]
 415  GO
 416  
 417  ALTER TABLE [phpbb_categories] WITH NOCHECK ADD
 418      CONSTRAINT [PK_phpbb_categories] PRIMARY KEY  CLUSTERED
 419      (
 420          [cat_id]
 421      )  ON [PRIMARY]
 422  GO
 423  
 424  ALTER TABLE [phpbb_confirm] WITH NOCHECK ADD
 425      CONSTRAINT [PK_phpbb_confirm] PRIMARY KEY  CLUSTERED
 426      (
 427          [session_id],[confirm_id]
 428      )  ON [PRIMARY]
 429  GO
 430  
 431  ALTER TABLE [phpbb_disallow] WITH NOCHECK ADD
 432      CONSTRAINT [PK_phpbb_disallow] PRIMARY KEY  CLUSTERED
 433      (
 434          [disallow_id]
 435      )  ON [PRIMARY]
 436  GO
 437  
 438  ALTER TABLE [phpbb_forum_prune] WITH NOCHECK ADD
 439      CONSTRAINT [PK_phpbb_forum_prune] PRIMARY KEY  CLUSTERED
 440      (
 441          [prune_id]
 442      )  ON [PRIMARY]
 443  GO
 444  
 445  ALTER TABLE [phpbb_forums] WITH NOCHECK ADD
 446      CONSTRAINT [PK_phpbb_forums] PRIMARY KEY  CLUSTERED
 447      (
 448          [forum_id]
 449      )  ON [PRIMARY]
 450  GO
 451  
 452  ALTER TABLE [phpbb_groups] WITH NOCHECK ADD
 453      CONSTRAINT [PK_phpbb_groups] PRIMARY KEY  CLUSTERED
 454      (
 455          [group_id]
 456      )  ON [PRIMARY]
 457  GO
 458  
 459  ALTER TABLE [phpbb_posts] WITH NOCHECK ADD
 460      CONSTRAINT [PK_phpbb_posts] PRIMARY KEY  CLUSTERED
 461      (
 462          [post_id]
 463      )  ON [PRIMARY]
 464  GO
 465  
 466  ALTER TABLE [phpbb_privmsgs] WITH NOCHECK ADD
 467      CONSTRAINT [PK_phpbb_privmsgs] PRIMARY KEY  CLUSTERED
 468      (
 469          [privmsgs_id]
 470      )  ON [PRIMARY]
 471  GO
 472  
 473  ALTER TABLE [phpbb_privmsgs_text] WITH NOCHECK ADD
 474      CONSTRAINT [PK_phpbb_privmsgs_text] PRIMARY KEY  CLUSTERED
 475      (
 476          [privmsgs_text_id]
 477      )  ON [PRIMARY]
 478  GO
 479  
 480  ALTER TABLE [phpbb_ranks] WITH NOCHECK ADD
 481      CONSTRAINT [PK_phpbb_ranks] PRIMARY KEY  CLUSTERED
 482      (
 483          [rank_id]
 484      )  ON [PRIMARY]
 485  GO
 486  
 487  ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD
 488      CONSTRAINT [PK_phpbb_search_results] PRIMARY KEY  CLUSTERED
 489      (
 490          [search_id]
 491      )  ON [PRIMARY]
 492  GO
 493  
 494  ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD
 495      CONSTRAINT [PK_phpbb_search_wordlist] PRIMARY KEY  CLUSTERED
 496      (
 497          [word_id]
 498      )  ON [PRIMARY]
 499  GO
 500  
 501  ALTER TABLE [phpbb_smilies] WITH NOCHECK ADD
 502      CONSTRAINT [PK_phpbb_smilies] PRIMARY KEY  CLUSTERED
 503      (
 504          [smilies_id]
 505      )  ON [PRIMARY]
 506  GO
 507  
 508  ALTER TABLE [phpbb_themes] WITH NOCHECK ADD
 509      CONSTRAINT [PK_phpbb_themes] PRIMARY KEY  CLUSTERED
 510      (
 511          [themes_id]
 512      )  ON [PRIMARY]
 513  GO
 514  
 515  ALTER TABLE [phpbb_themes_name] WITH NOCHECK ADD
 516      CONSTRAINT [PK_phpbb_themes_name] PRIMARY KEY  CLUSTERED
 517      (
 518          [themes_id]
 519      )  ON [PRIMARY]
 520  GO
 521  
 522  ALTER TABLE [phpbb_topics] WITH NOCHECK ADD
 523      CONSTRAINT [PK_phpbb_topics] PRIMARY KEY  CLUSTERED
 524      (
 525          [topic_id]
 526      )  ON [PRIMARY]
 527  GO
 528  
 529  ALTER TABLE [phpbb_users] WITH NOCHECK ADD
 530      CONSTRAINT [PK_phpbb_users] PRIMARY KEY  CLUSTERED
 531      (
 532          [user_id]
 533      )  ON [PRIMARY]
 534  GO
 535  
 536  ALTER TABLE [phpbb_vote_desc] WITH NOCHECK ADD
 537      CONSTRAINT [PK_phpbb_vote_desc] PRIMARY KEY  CLUSTERED
 538      (
 539          [vote_id]
 540      )  ON [PRIMARY]
 541  GO
 542  
 543  ALTER TABLE [phpbb_words] WITH NOCHECK ADD
 544      CONSTRAINT [PK_phpbb_words] PRIMARY KEY  CLUSTERED
 545      (
 546          [word_id]
 547      )  ON [PRIMARY]
 548  GO
 549  
 550  ALTER 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]
 563  GO
 564  
 565  ALTER 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]
 581  GO
 582  
 583  ALTER 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]
 587  GO
 588  
 589  ALTER 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]
 595  GO
 596  
 597  ALTER TABLE [phpbb_search_results] WITH NOCHECK ADD
 598      CONSTRAINT [DF_phpbb_search_results_search_time] DEFAULT (0) FOR [search_time]
 599  GO
 600  
 601  ALTER TABLE [phpbb_search_wordlist] WITH NOCHECK ADD
 602      CONSTRAINT [DF_phpbb_search_wordlist_word_common] DEFAULT (0) FOR [word_common]
 603  GO
 604  
 605  ALTER 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
 612  GO
 613  
 614  ALTER 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]
 638  GO
 639  
 640   CREATE  INDEX [IX_phpbb_auth_access] ON [phpbb_auth_access]([group_id], [forum_id]) ON [PRIMARY]
 641  GO
 642  
 643   CREATE  INDEX [IX_phpbb_banlist] ON [phpbb_banlist]([ban_userid], [ban_ip]) ON [PRIMARY]
 644  GO
 645  
 646   CREATE  INDEX [IX_phpbb_categories] ON [phpbb_categories]([cat_order]) ON [PRIMARY]
 647  GO
 648  
 649   CREATE  INDEX [IX_phpbb_forum_prune] ON [phpbb_forum_prune]([forum_id]) ON [PRIMARY]
 650  GO
 651  
 652   CREATE  INDEX [IX_phpbb_forums] ON [phpbb_forums]([cat_id], [forum_order], [forum_last_post_id]) ON [PRIMARY]
 653  GO
 654  
 655   CREATE  INDEX [IX_phpbb_groups] ON [phpbb_groups]([group_single_user]) ON [PRIMARY]
 656  GO
 657  
 658   CREATE  INDEX [IX_phpbb_posts] ON [phpbb_posts]([topic_id], [forum_id], [poster_id]) ON [PRIMARY]
 659  GO
 660  
 661   CREATE  INDEX [IX_phpbb_posts_text] ON [phpbb_posts_text]([post_id]) ON [PRIMARY]
 662  GO
 663  
 664   CREATE  INDEX [IX_phpbb_privmsgs] ON [phpbb_privmsgs]([privmsgs_from_userid], [privmsgs_to_userid]) ON [PRIMARY]
 665  GO
 666  
 667   CREATE  INDEX [IX_phpbb_ranks] ON [phpbb_ranks]([rank_min], [rank_special]) ON [PRIMARY]
 668  GO
 669  
 670   CREATE  INDEX [IX_phpbb_search_results] ON [phpbb_search_results]([session_id]) ON [PRIMARY]
 671  GO
 672  
 673   CREATE  UNIQUE  INDEX [IX_phpbb_search_wordlist] ON [phpbb_search_wordlist]([word_text]) WITH  IGNORE_DUP_KEY  ON [PRIMARY]
 674  GO
 675  
 676   CREATE  INDEX [IX_phpbb_search_wordlist_1] ON [phpbb_search_wordlist]([word_common]) ON [PRIMARY]
 677  GO
 678  
 679   CREATE  INDEX [IX_phpbb_search_wordmatch] ON [phpbb_search_wordmatch]([post_id]) ON [PRIMARY]
 680  GO
 681  
 682   CREATE  INDEX [IX_phpbb_search_wordmatch_1] ON [phpbb_search_wordmatch]([word_id]) ON [PRIMARY]
 683  GO
 684  
 685   CREATE  INDEX [IX_phpbb_sessions] ON [phpbb_sessions]([session_id], [session_user_id], [session_ip], [session_logged_in]) ON [PRIMARY]
 686  GO
 687  
 688   CREATE  INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([key_id], [user_id]) ON [PRIMARY]
 689  GO
 690  
 691   CREATE  INDEX [IX_phpbb_sessions_keys_1] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY]
 692  GO
 693  
 694   CREATE  INDEX [IX_phpbb_topics] ON [phpbb_topics]([forum_id], [topic_type], [topic_first_post_id], [topic_last_post_id]) ON [PRIMARY]
 695  GO
 696  
 697   CREATE  INDEX [IX_phpbb_topics_watch] ON [phpbb_topics_watch]([topic_id], [user_id]) ON [PRIMARY]
 698  GO
 699  
 700   CREATE  INDEX [IX_phpbb_users] ON [phpbb_users]([user_session_time]) ON [PRIMARY]
 701  GO
 702  
 703   CREATE  INDEX [IX_phpbb_user_group] ON [phpbb_user_group]([group_id], [user_id]) ON [PRIMARY]
 704  GO
 705  
 706   CREATE  INDEX [IX_phpbb_vote_desc] ON [phpbb_vote_desc]([topic_id]) ON [PRIMARY]
 707  GO
 708  
 709   CREATE  INDEX [IX_phpbb_vote_results] ON [phpbb_vote_results]([vote_id]) ON [PRIMARY]
 710  GO
 711  
 712   CREATE  INDEX [IX_phpbb_vote_results_1] ON [phpbb_vote_results]([vote_option_id]) ON [PRIMARY]
 713  GO
 714  
 715   CREATE  INDEX [IX_phpbb_vote_voters] ON [phpbb_vote_voters]([vote_id]) ON [PRIMARY]
 716  GO
 717  
 718   CREATE  INDEX [IX_phpbb_vote_voters_1] ON [phpbb_vote_voters]([vote_user_id]) ON [PRIMARY]
 719  GO
 720  
 721  COMMIT
 722  GO