diff options
| author | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-11-24 17:17:32 +0000 |
|---|---|---|
| committer | Bart van Bragt <bartvb@users.sourceforge.net> | 2001-11-24 17:17:32 +0000 |
| commit | 7eee52fff321c1ba06bf321209cd2beb211fd6b3 (patch) | |
| tree | ddaeaa00702130e8d581c8992499ac2e261a5f2a /phpBB/db | |
| parent | 92e5512011789d1ecab92a6f3e8fc4a70e0e4a00 (diff) | |
| download | forums-7eee52fff321c1ba06bf321209cd2beb211fd6b3.tar forums-7eee52fff321c1ba06bf321209cd2beb211fd6b3.tar.gz forums-7eee52fff321c1ba06bf321209cd2beb211fd6b3.tar.bz2 forums-7eee52fff321c1ba06bf321209cd2beb211fd6b3.tar.xz forums-7eee52fff321c1ba06bf321209cd2beb211fd6b3.zip | |
Finally moved the bbcode_uid from posts to posts_text, DON'T FORGET TO RUN THE CONVERT SCRIPT IN /develop/ !!
git-svn-id: file:///svn/phpbb/trunk@1436 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/oracle_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 2 |
4 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index 8cc34abcdb..dc1495dc76 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -235,7 +235,6 @@ CREATE TABLE [phpbb_posts] ( [enable_html] [smallint] NULL , [enable_smilies] [smallint] NULL , [enable_sig] [smallint] NULL , - [bbcode_uid] [char] (10) NULL , [post_edit_time] [int] NULL , [post_edit_count] [smallint] NULL ) ON [PRIMARY] @@ -243,6 +242,7 @@ GO CREATE TABLE [phpbb_posts_text] ( [post_id] [int] NOT NULL , + [bbcode_uid] [char] (10) NULL , [post_subject] [varchar] (100) NULL , [post_text] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index b0dde05c34..83813f1309 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -176,7 +176,6 @@ CREATE TABLE phpbb_posts ( enable_html tinyint(1) DEFAULT '0' NOT NULL, 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, PRIMARY KEY (post_id), @@ -194,6 +193,7 @@ CREATE TABLE phpbb_posts ( DROP TABLE IF EXISTS phpbb_posts_text; 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, PRIMARY KEY (post_id) diff --git a/phpBB/db/schemas/oracle_schema.sql b/phpBB/db/schemas/oracle_schema.sql index cbfc0e3139..99c10e0c37 100644 --- a/phpBB/db/schemas/oracle_schema.sql +++ b/phpBB/db/schemas/oracle_schema.sql @@ -198,7 +198,6 @@ CREATE TABLE phpbb_posts ( enable_html number(4) DEFAULT '0' NOT NULL, 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, CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id) @@ -214,6 +213,7 @@ CREATE INDEX topic_id_phpbb_posts_index ON phpbb_posts (topic_id); -------------------------------------------------------- */ 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), CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id) diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 5c912559e4..a4a2798d08 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -167,7 +167,6 @@ CREATE TABLE phpbb_posts ( enable_html int2 DEFAULT '0' NOT NULL, 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, CONSTRAINT phpbb_posts_pkey PRIMARY KEY (post_id) @@ -183,6 +182,7 @@ CREATE INDEX topic_id_phpbb_posts_index ON phpbb_posts (topic_id); -------------------------------------------------------- */ 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, CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id) |