diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-20 00:45:41 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-12-20 00:45:41 +0000 |
| commit | cd2135b727664ec7e26653cc291d3bfc599075e7 (patch) | |
| tree | 916cc4f79bc8a1ae980863af64e6a2a3212752c1 /phpBB/db/schemas | |
| parent | 55b0c6eabeddddf68e670572d4379e25804ed622 (diff) | |
| download | forums-cd2135b727664ec7e26653cc291d3bfc599075e7.tar forums-cd2135b727664ec7e26653cc291d3bfc599075e7.tar.gz forums-cd2135b727664ec7e26653cc291d3bfc599075e7.tar.bz2 forums-cd2135b727664ec7e26653cc291d3bfc599075e7.tar.xz forums-cd2135b727664ec7e26653cc291d3bfc599075e7.zip | |
Minor updates to post_username, post_subject and topic_title field lengths
git-svn-id: file:///svn/phpbb/trunk@1642 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/db/schemas')
| -rw-r--r-- | phpBB/db/schemas/mssql_schema.sql | 6 | ||||
| -rw-r--r-- | phpBB/db/schemas/mysql_schema.sql | 4 | ||||
| -rw-r--r-- | phpBB/db/schemas/postgres_schema.sql | 6 |
3 files changed, 8 insertions, 8 deletions
diff --git a/phpBB/db/schemas/mssql_schema.sql b/phpBB/db/schemas/mssql_schema.sql index 323b6865b0..1e278f6cb3 100644 --- a/phpBB/db/schemas/mssql_schema.sql +++ b/phpBB/db/schemas/mssql_schema.sql @@ -105,7 +105,7 @@ CREATE TABLE [phpbb_posts] ( [poster_id] [int] NOT NULL , [post_time] [int] NOT NULL , [poster_ip] [char] (8) NULL , - [post_username] [varchar] (50) NULL , + [post_username] [char] (25) NULL , [enable_bbcode] [smallint] NULL , [enable_html] [smallint] NULL , [enable_smilies] [smallint] NULL , @@ -118,7 +118,7 @@ GO CREATE TABLE [phpbb_posts_text] ( [post_id] [int] NOT NULL , [bbcode_uid] [char] (10) NULL , - [post_subject] [varchar] (100) NULL , + [post_subject] [char] (60) NULL , [post_text] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO @@ -280,7 +280,7 @@ GO CREATE TABLE [phpbb_topics] ( [topic_id] [int] IDENTITY (1, 1) NOT NULL , [forum_id] [int] NOT NULL , - [topic_title] [varchar] (100) NOT NULL , + [topic_title] [varchar] (60) NOT NULL , [topic_poster] [int] NOT NULL , [topic_time] [int] NOT NULL , [topic_views] [int] NOT NULL , diff --git a/phpBB/db/schemas/mysql_schema.sql b/phpBB/db/schemas/mysql_schema.sql index 0b8fdf810c..719f6ce083 100644 --- a/phpBB/db/schemas/mysql_schema.sql +++ b/phpBB/db/schemas/mysql_schema.sql @@ -161,7 +161,7 @@ CREATE TABLE phpbb_posts ( poster_id mediumint(8) DEFAULT '0' NOT NULL, post_time int(11) DEFAULT '0' NOT NULL, poster_ip char(8) NOT NULL, - post_username varchar(30), + post_username varchar(25), enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, enable_html tinyint(1) DEFAULT '0' NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, @@ -183,7 +183,7 @@ CREATE TABLE phpbb_posts ( 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_subject char(60), post_text text, PRIMARY KEY (post_id) ); diff --git a/phpBB/db/schemas/postgres_schema.sql b/phpBB/db/schemas/postgres_schema.sql index 218dff49e4..cea66b3204 100644 --- a/phpBB/db/schemas/postgres_schema.sql +++ b/phpBB/db/schemas/postgres_schema.sql @@ -159,7 +159,7 @@ CREATE TABLE phpbb_posts ( forum_id int4 DEFAULT '0' NOT NULL, poster_id int4 DEFAULT '0' NOT NULL, post_time int4 DEFAULT '0' NOT NULL, - post_username varchar(30), + post_username varchar(25), poster_ip char(8) DEFAULT '' NOT NULL, enable_bbcode int2 DEFAULT '1' NOT NULL, enable_html int2 DEFAULT '0' NOT NULL, @@ -181,7 +181,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_subject varchar(60), post_text text, CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id) ); @@ -393,7 +393,7 @@ CREATE TABLE phpbb_themes_name ( CREATE TABLE phpbb_topics ( topic_id int4 DEFAULT nextval('phpbb_topics_id_seq'::text) NOT NULL, forum_id int4 DEFAULT '0' NOT NULL, - topic_title varchar(100) DEFAULT '' NOT NULL, + topic_title varchar(60) DEFAULT '' NOT NULL, topic_poster int4 DEFAULT '0' NOT NULL, topic_time int4 DEFAULT '0' NOT NULL, topic_views int4 DEFAULT '0' NOT NULL, |