|
From: Paul S. O. <ps...@us...> - 2001-11-20 14:34:08
|
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),
|