[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_schema.sql,1.1,1.2 mysql_schema.sql,1.3,1.4 oracle_schema.sql,1.1,1.2 postgres_schema.sql,1.2,1.3

[Bart v. B. <ba...@us...>]

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

Modified Files:
	mssql_schema.sql mysql_schema.sql oracle_schema.sql 
	postgres_schema.sql 
Log Message:
Finally moved the bbcode_uid from posts to posts_text, DON'T FORGET TO RUN THE CONVERT SCRIPT IN /develop/ !!

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** mssql_schema.sql	2001/11/20 22:28:41	1.1
--- mssql_schema.sql	2001/11/24 17:17:32	1.2
***************
*** 236,240 ****
  	[enable_smilies] [smallint] NULL ,
  	[enable_sig] [smallint] NULL ,
- 	[bbcode_uid] [char] (10) NULL ,
  	[post_edit_time] [int] NULL ,
  	[post_edit_count] [smallint] NULL 
--- 236,239 ----
***************
*** 244,247 ****
--- 243,247 ----
  CREATE TABLE [phpbb_posts_text] (
  	[post_id] [int] NOT NULL ,
+ 	[bbcode_uid] [char] (10) NULL ,
  	[post_subject] [varchar] (100) NULL ,
  	[post_text] [text] NULL 

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** mysql_schema.sql	2001/11/23 18:52:46	1.3
--- mysql_schema.sql	2001/11/24 17:17:32	1.4
***************
*** 177,181 ****
     enable_smilies tinyint(1) DEFAULT '1' NOT NULL,
     enable_sig tinyint(1) DEFAULT '1' NOT NULL, 
-    bbcode_uid char(10) NOT NULL,
     post_edit_time int(11),
     post_edit_count smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
--- 177,180 ----
***************
*** 195,198 ****
--- 194,198 ----
  CREATE TABLE phpbb_posts_text (
     post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
+    bbcode_uid char(10) NOT NULL,
     post_subject varchar(255),
     post_text text,

Index: oracle_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/oracle_schema.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** oracle_schema.sql	2001/11/20 22:28:41	1.1
--- oracle_schema.sql	2001/11/24 17:17:32	1.2
***************
*** 199,203 ****
     enable_smilies number(4) DEFAULT '1' NOT NULL,
     enable_sig number(4) DEFAULT '1' NOT NULL,
-    bbcode_uid varchar(10) DEFAULT '',
     post_edit_time number(11),
     post_edit_count number(4) DEFAULT '0' NOT NULL,
--- 199,202 ----
***************
*** 215,218 ****
--- 214,218 ----
  CREATE TABLE phpbb_posts_text (
     post_id number(4) DEFAULT '0' NOT NULL,
+    bbcode_uid varchar(10) DEFAULT '',
     post_subject varchar(255),
     post_text varchar(2000),

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -r1.2 -r1.3
*** postgres_schema.sql	2001/11/23 00:36:08	1.2
--- postgres_schema.sql	2001/11/24 17:17:32	1.3
***************
*** 168,172 ****
     enable_smilies int2 DEFAULT '1' NOT NULL,
     enable_sig int2 DEFAULT '1' NOT NULL,
-    bbcode_uid varchar(10) DEFAULT '' NOT NULL,
     post_edit_time int4,
     post_edit_count int2 DEFAULT '0' NOT NULL,
--- 168,171 ----
***************
*** 184,187 ****
--- 183,187 ----
  CREATE TABLE phpbb_posts_text (
     post_id int4 DEFAULT '0' NOT NULL,
+    bbcode_uid varchar(10) DEFAULT '' NOT NULL,
     post_subject varchar(255),
     post_text text,