[Phpbb-checkins] CVS: phpBB2/db/schemas mysql_basic.sql,1.19,1.20 mysql_schema.sql,1.23,1.24

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

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

Modified Files:
	mysql_basic.sql mysql_schema.sql 
Log Message:
Few more changes

Index: mysql_basic.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_basic.sql,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -r1.19 -r1.20
*** mysql_basic.sql	21 Jun 2002 20:12:06 -0000	1.19
--- mysql_basic.sql	21 Jun 2002 22:40:29 -0000	1.20
***************
*** 156,159 ****
--- 156,163 ----
  
  
+ # -- Topic icons
+ INSERT INTO phpbb_icons (icons_id, icons_url, icons_width, icons_height) VALUES (0, '', 0, 0);
+ 
+ 
  # -- Smilies
  INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy');

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -r1.23 -r1.24
*** mysql_schema.sql	21 Jun 2002 20:12:08 -0000	1.23
--- mysql_schema.sql	21 Jun 2002 22:40:29 -0000	1.24
***************
*** 54,95 ****
  # --------------------------------------------------------
  #
- # Table structure for table 'phpbb_user_group'
- #
- CREATE TABLE phpbb_user_group (
-    group_id mediumint(8) DEFAULT '0' NOT NULL,
-    user_id mediumint(8) DEFAULT '0' NOT NULL,
-    user_pending tinyint(1), 
-    KEY group_id (group_id),
-    KEY user_id (user_id)
- );
- 
- 
- # --------------------------------------------------------
- #
- # Table structure for table 'phpbb_groups'
- #
- CREATE TABLE phpbb_groups (
-    group_id mediumint(8) NOT NULL auto_increment,
-    group_type tinyint(4) DEFAULT '1' NOT NULL, 
-    group_name varchar(40) NOT NULL,
-    group_avatar varchar(100), 
-    group_avatar_type tinyint(4), 
-    group_description varchar(255) NOT NULL,
-    PRIMARY KEY (group_id)
- );
- 
- 
- # --------------------------------------------------------
- #
- # Table structure for table 'phpbb_groups_moderator'
- #
- CREATE TABLE phpbb_groups_moderator (
-    group_id mediumint(8) NOT NULL, 
-    user_id mediumint(8) NOT NULL 
- );
- 
- 
- # --------------------------------------------------------
- #
  # Table structure for table 'phpbb_banlist'
  #
--- 54,57 ----
***************
*** 130,134 ****
  # --------------------------------------------------------
  #
! # Table structure for table 'phpbb_disallow'
  #
  CREATE TABLE phpbb_disallow (
--- 92,96 ----
  # --------------------------------------------------------
  #
! # Table structure for table 'phpbb_disallow' <- combine with banlist
  #
  CREATE TABLE phpbb_disallow (
***************
*** 187,190 ****
--- 149,178 ----
  # --------------------------------------------------------
  #
+ # Table structure for table 'phpbb_groups'
+ #
+ CREATE TABLE phpbb_groups (
+    group_id mediumint(8) NOT NULL auto_increment,
+    group_type tinyint(4) DEFAULT '1' NOT NULL, 
+    group_name varchar(40) NOT NULL,
+    group_avatar varchar(100), 
+    group_avatar_type tinyint(4), 
+    group_colour varchar(6) DEFAULT '' NOT NULL, 
+    group_description varchar(255) NOT NULL,
+    PRIMARY KEY (group_id)
+ );
+ 
+ 
+ # --------------------------------------------------------
+ #
+ # Table structure for table 'phpbb_groups_moderator'
+ #
+ CREATE TABLE phpbb_groups_moderator (
+    group_id mediumint(8) NOT NULL, 
+    user_id mediumint(8) NOT NULL 
+ );
+ 
+ 
+ # --------------------------------------------------------
+ #
  # Table structure for table 'phpbb_icons'
  #
***************
*** 441,445 ****
     topic_poster mediumint(8) DEFAULT '0' NOT NULL,
     topic_time int(11) DEFAULT '0' NOT NULL,
!    topic_icon tinyint(4) UNSIGNED, 
     topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
     topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
--- 429,433 ----
     topic_poster mediumint(8) DEFAULT '0' NOT NULL,
     topic_time int(11) DEFAULT '0' NOT NULL,
!    topic_icon tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, 
     topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
     topic_replies mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
***************
*** 476,479 ****
--- 464,479 ----
  
  
+ # --------------------------------------------------------
+ #
+ # Table structure for table 'phpbb_user_group'
+ #
+ CREATE TABLE phpbb_user_group (
+    group_id mediumint(8) DEFAULT '0' NOT NULL,
+    user_id mediumint(8) DEFAULT '0' NOT NULL,
+    user_pending tinyint(1), 
+    KEY group_id (group_id),
+    KEY user_id (user_id)
+ );
+ 
  
  # --------------------------------------------------------
***************
*** 491,495 ****
     user_lastvisit int(11) DEFAULT '0' NOT NULL, 
     user_regdate int(11) DEFAULT '0' NOT NULL, 
!    user_level tinyint(4) DEFAULT '0',
     user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
     user_lang varchar(50), 
--- 491,496 ----
     user_lastvisit int(11) DEFAULT '0' NOT NULL, 
     user_regdate int(11) DEFAULT '0' NOT NULL, 
!    user_level tinyint(4) DEFAULT '0', 
!    user_colourise varchar(6) DEFAULT '' NOT NULL, 
     user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
     user_lang varchar(50),