|
From: Bart v. B. <ba...@us...> - 2001-11-24 17:17:35
|
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,
|