[Phpbb-checkins] CVS: phpBB2/db mysql_schema.sql,1.90,1.91

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/db
In directory usw-pr-cvs1:/tmp/cvs-serv3235

Modified Files:
	mysql_schema.sql 
Log Message:
Okay, I think that's all folks ... aside from perhaps indexes this is it, da final schema ... keep your eyes on the forums for confirmation

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/mysql_schema.sql,v
retrieving revision 1.90
retrieving revision 1.91
diff -C2 -r1.90 -r1.91
*** mysql_schema.sql	2001/11/18 23:27:22	1.90
--- mysql_schema.sql	2001/11/20 14:34:05	1.91
***************
*** 183,187 ****
     KEY forum_id (forum_id),
     KEY topic_id (topic_id),
!    KEY poster_id (poster_id)
  );
  
--- 183,188 ----
     KEY forum_id (forum_id),
     KEY topic_id (topic_id),
!    KEY poster_id (poster_id), 
!    KEY post_time (post_time)
  );
  
***************
*** 287,291 ****
    post_id mediumint(8) UNSIGNED NOT NULL default '0',
    word_id mediumint(8) UNSIGNED NOT NULL default '0',
-   word_count smallint(5) UNSIGNED NOT NULL default '0',
    title_match tinyint(1) NOT NULL default '0',
    KEY word_id (word_id)
--- 288,291 ----
***************
*** 328,332 ****
  # Table structure for table 'phpbb_smilies'
  #
! DROP TABLE IF EXISTS phpbb_smilies;
  CREATE TABLE phpbb_smilies (
     smilies_id smallint(5) UNSIGNED NOT NULL auto_increment,
--- 328,332 ----
  # Table structure for table 'phpbb_smilies'
  #
! DROP TABLE IF EXISTS phpbb_smilies; 
  CREATE TABLE phpbb_smilies (
     smilies_id smallint(5) UNSIGNED NOT NULL auto_increment,
***************
*** 384,388 ****
     span_class1 varchar(25) default NULL,
     span_class2 varchar(25) default NULL,
!    span_class3 varchar(25) default NULL,
     PRIMARY KEY  (themes_id)
  );
--- 384,390 ----
     span_class1 varchar(25) default NULL,
     span_class2 varchar(25) default NULL,
!    span_class3 varchar(25) default NULL, 
!    img_size_poll smallint(5) UNSIGNED, 
!    img_size_privmsg smallint(5) UNSIGNED, 
     PRIMARY KEY  (themes_id)
  );
***************
*** 449,453 ****
     topic_moved_id mediumint(8) UNSIGNED,
     PRIMARY KEY (topic_id),
!    KEY forum_id (forum_id)
  );
  
--- 451,457 ----
     topic_moved_id mediumint(8) UNSIGNED,
     PRIMARY KEY (topic_id),
!    KEY forum_id (forum_id),
!    KEY topic_moved_id (topic_moved_id),
!    KEY topic_status (topic_status) 
  );
  
***************
*** 482,486 ****
     user_level tinyint(4) DEFAULT '0',
     user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
!    user_timezone tinyint(4) UNSIGNED DEFAULT '0' NOT NULL,
     user_style tinyint(4),
     user_lang varchar(255),
--- 486,490 ----
     user_level tinyint(4) DEFAULT '0',
     user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
!    user_timezone tinyint(4) DEFAULT '0' NOT NULL,
     user_style tinyint(4),
     user_lang varchar(255),
***************
*** 501,504 ****
--- 505,509 ----
     user_notify tinyint(1) DEFAULT '1' NOT NULL,
     user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, 
+    user_popup_pm tinyint(1) DEFAULT '0' NOT NULL, 
     user_rank int(11) DEFAULT '0',
     user_avatar varchar(100),