[Phpbb-checkins] CVS: phpBB2/db/schemas mssql_schema.sql,1.15,1.16 mysql_schema.sql,1.10,1.11 postgres_schema.sql,1.12,1.13

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

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

Modified Files:
	mssql_schema.sql mysql_schema.sql postgres_schema.sql 
Log Message:
Minor updates to post_username, post_subject and topic_title field lengths

Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -r1.15 -r1.16
*** mssql_schema.sql	2001/12/19 23:12:22	1.15
--- mssql_schema.sql	2001/12/20 00:45:41	1.16
***************
*** 106,110 ****
  	[post_time] [int] NOT NULL ,
  	[poster_ip] [char] (8) NULL ,
! 	[post_username] [varchar] (50) NULL ,
  	[enable_bbcode] [smallint] NULL ,
  	[enable_html] [smallint] NULL ,
--- 106,110 ----
  	[post_time] [int] NOT NULL ,
  	[poster_ip] [char] (8) NULL ,
! 	[post_username] [char] (25) NULL ,
  	[enable_bbcode] [smallint] NULL ,
  	[enable_html] [smallint] NULL ,
***************
*** 119,123 ****
  	[post_id] [int] NOT NULL ,
  	[bbcode_uid] [char] (10) NULL ,
! 	[post_subject] [varchar] (100) NULL ,
  	[post_text] [text] NULL 
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
--- 119,123 ----
  	[post_id] [int] NOT NULL ,
  	[bbcode_uid] [char] (10) NULL ,
! 	[post_subject] [char] (60) NULL ,
  	[post_text] [text] NULL 
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
***************
*** 281,285 ****
  	[topic_id] [int] IDENTITY (1, 1) NOT NULL ,
  	[forum_id] [int] NOT NULL ,
! 	[topic_title] [varchar] (100) NOT NULL ,
  	[topic_poster] [int] NOT NULL ,
  	[topic_time] [int] NOT NULL ,
--- 281,285 ----
  	[topic_id] [int] IDENTITY (1, 1) NOT NULL ,
  	[forum_id] [int] NOT NULL ,
! 	[topic_title] [varchar] (60) NOT NULL ,
  	[topic_poster] [int] NOT NULL ,
  	[topic_time] [int] NOT NULL ,

Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -r1.10 -r1.11
*** mysql_schema.sql	2001/12/15 16:40:35	1.10
--- mysql_schema.sql	2001/12/20 00:45:41	1.11
***************
*** 162,166 ****
     post_time int(11) DEFAULT '0' NOT NULL,
     poster_ip char(8) NOT NULL, 
!    post_username varchar(30), 
     enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
     enable_html tinyint(1) DEFAULT '0' NOT NULL,
--- 162,166 ----
     post_time int(11) DEFAULT '0' NOT NULL,
     poster_ip char(8) NOT NULL, 
!    post_username varchar(25), 
     enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
     enable_html tinyint(1) DEFAULT '0' NOT NULL,
***************
*** 184,188 ****
     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)
--- 184,188 ----
     post_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
     bbcode_uid char(10) NOT NULL,
!    post_subject char(60),
     post_text text,
     PRIMARY KEY (post_id)

Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** postgres_schema.sql	2001/12/18 16:38:18	1.12
--- postgres_schema.sql	2001/12/20 00:45:41	1.13
***************
*** 160,164 ****
     poster_id int4 DEFAULT '0' NOT NULL,
     post_time int4 DEFAULT '0' NOT NULL,
!    post_username varchar(30),
     poster_ip char(8) DEFAULT '' NOT NULL,
     enable_bbcode int2 DEFAULT '1' NOT NULL,
--- 160,164 ----
     poster_id int4 DEFAULT '0' NOT NULL,
     post_time int4 DEFAULT '0' NOT NULL,
!    post_username varchar(25),
     poster_ip char(8) DEFAULT '' NOT NULL,
     enable_bbcode int2 DEFAULT '1' NOT NULL,
***************
*** 182,186 ****
     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)
--- 182,186 ----
     post_id int4 DEFAULT '0' NOT NULL,
     bbcode_uid varchar(10) DEFAULT '' NOT NULL,
!    post_subject varchar(60),
     post_text text,
     CONSTRAINT phpbb_posts_text_pkey PRIMARY KEY (post_id)
***************
*** 394,398 ****
     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_poster int4 DEFAULT '0' NOT NULL,
     topic_time int4 DEFAULT '0' NOT NULL,
--- 394,398 ----
     topic_id int4 DEFAULT nextval('phpbb_topics_id_seq'::text) NOT NULL,
     forum_id int4 DEFAULT '0' NOT NULL,
!    topic_title varchar(60) DEFAULT '' NOT NULL,
     topic_poster int4 DEFAULT '0' NOT NULL,
     topic_time int4 DEFAULT '0' NOT NULL,