[Phpbb-checkins] CVS: phpBB2/db mysql_schema.sql,1.86,1.87

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

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

Modified Files:
	mysql_schema.sql 
Log Message:
This is an initial 'final' DB schema, effectively complete but may undergo some (hopefully minor) updates

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/mysql_schema.sql,v
retrieving revision 1.86
retrieving revision 1.87
diff -C2 -r1.86 -r1.87
*** mysql_schema.sql	2001/11/15 22:07:29	1.86
--- mysql_schema.sql	2001/11/16 18:00:49	1.87
***************
*** 272,282 ****
  #
  DROP TABLE IF EXISTS phpbb_search_wordlist;
! CREATE TABLE `phpbb_search_wordlist` (
!   `word_text` varchar(50) binary NOT NULL default '',
!   `word_id` int(11) NOT NULL auto_increment,
!   `word_weight` tinyint(4) NOT NULL default '0',
!   `word_common` tinyint(1) unsigned NOT NULL default '0',
!   PRIMARY KEY (`word_text`),
!   KEY `word_id`(`word_id`)
  )
  
--- 272,282 ----
  #
  DROP TABLE IF EXISTS phpbb_search_wordlist;
! CREATE TABLE phpbb_search_wordlist (
!   word_text varchar(50) binary NOT NULL default '',
!   word_id int(11) NOT NULL auto_increment,
!   word_weight tinyint(4) NOT NULL default '0',
!   word_common tinyint(1) unsigned NOT NULL default '0',
!   PRIMARY KEY (word_text),
!   KEY word_id (word_id)
  )
  
***************
*** 481,490 ****
     user_password varchar(32) NOT NULL,
     user_autologin_key varchar(32),
     user_level tinyint(4) DEFAULT '0',
     user_posts int(11) DEFAULT '0' NOT NULL,
     user_timezone int(11) DEFAULT '0' NOT NULL,
-    user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
     user_style int(11),
     user_lang varchar(255),
     user_emailtime int(11), 
     user_viewemail tinyint(1),
--- 481,494 ----
     user_password varchar(32) NOT NULL,
     user_autologin_key varchar(32),
+    user_regdate int(11) DEFAULT '0' NOT NULL, 
     user_level tinyint(4) DEFAULT '0',
     user_posts int(11) DEFAULT '0' NOT NULL,
     user_timezone int(11) DEFAULT '0' NOT NULL,
     user_style int(11),
     user_lang varchar(255),
+    user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
+    user_lastvisit int(11) DEFAULT '0' NOT NULL, 
+    user_new_privmsg smallint(6) DEFAULT '0' NOT NULL, 
+    user_unread_privmsg smallint(6) DEFAULT '0' NOT NULL, 
     user_emailtime int(11), 
     user_viewemail tinyint(1),
***************
*** 498,502 ****
     user_notify tinyint(1) DEFAULT '1' NOT NULL,
     user_notify_pm tinyint(1) DEFAULT '1' NOT NULL, 
-    user_regdate int(11) DEFAULT '0' NOT NULL,
     user_rank int(11) DEFAULT '0',
     user_avatar varchar(100),
--- 502,505 ----