[phpBT-dev] CVS: phpbt/schemas pgsql.in,1.8,1.9

[Benjamin C. <bc...@us...>]

Update of /cvsroot/phpbt/phpbt/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv4424/schemas

Modified Files:
	pgsql.in 
Log Message:
Avoid space-padded strings

Index: pgsql.in
===================================================================
RCS file: /cvsroot/phpbt/phpbt/schemas/pgsql.in,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- pgsql.in	2001/10/30 04:02:45	1.8
+++ pgsql.in	2001/11/06 04:04:02	1.9
@@ -21,10 +21,10 @@
 CREATE TABLE TBL_ATTACHMENT (
   attachment_id INT4  NOT NULL DEFAULT '0',
   bug_id INT4  NOT NULL DEFAULT '0',
-  file_name char(255) NOT NULL DEFAULT '',
-  description char(255) NOT NULL DEFAULT '',
+  file_name varchar(255) NOT NULL DEFAULT '',
+  description varchar(255) NOT NULL DEFAULT '',
   file_size INT8  NOT NULL DEFAULT '0',
-  mime_type char(30) NOT NULL DEFAULT '',
+  mime_type varchar(30) NOT NULL DEFAULT '',
   created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0',
   PRIMARY KEY  (attachment_id)
@@ -52,13 +52,13 @@
 
 CREATE TABLE TBL_AUTH_USER (
   user_id INT4  NOT NULL DEFAULT '0',
-  login char(40) NOT NULL DEFAULT '',
-  first_name char(40) NOT NULL DEFAULT '',
-  last_name char(40) NOT NULL DEFAULT '',
-  email char(60) NOT NULL DEFAULT '',
-  password char(40) NOT NULL DEFAULT '',
+  login varchar(40) NOT NULL DEFAULT '',
+  first_name varchar(40) NOT NULL DEFAULT '',
+  last_name varchar(40) NOT NULL DEFAULT '',
+  email varchar(60) NOT NULL DEFAULT '',
+  password varchar(40) NOT NULL DEFAULT '',
   active INT2  NOT NULL DEFAULT '1',
-  bug_list_fields char(255) NOT NULL DEFAULT '',
+  bug_list_fields varchar(255) NOT NULL DEFAULT '',
   created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0',
   last_modified_by INT4  NOT NULL DEFAULT '0',
@@ -105,9 +105,9 @@
 
 CREATE TABLE TBL_BUG_HISTORY (
   bug_id INT4  NOT NULL DEFAULT '0',
-  changed_field char(20) NOT NULL DEFAULT '',
-  old_value char(255) NOT NULL DEFAULT '',
-  new_value char(255) NOT NULL DEFAULT '',
+  changed_field varchar(20) NOT NULL DEFAULT '',
+  old_value varchar(255) NOT NULL DEFAULT '',
+  new_value varchar(255) NOT NULL DEFAULT '',
   created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0'
 );
@@ -139,7 +139,7 @@
   varname varchar(40) NOT NULL DEFAULT '',
   varvalue varchar(255) NOT NULL DEFAULT '',
   description varchar(255) NOT NULL DEFAULT '',
-  vartype char(20) NOT NULL DEFAULT '',
+  vartype varchar(20) NOT NULL DEFAULT '',
   PRIMARY KEY  (varname)
 );
 
@@ -157,9 +157,9 @@
 
 CREATE TABLE TBL_OS (
   os_id INT4  NOT NULL DEFAULT '0',
-  os_name char(30) NOT NULL DEFAULT '',
+  os_name varchar(30) NOT NULL DEFAULT '',
   sort_order INT2  NOT NULL DEFAULT '0',
-  regex char(40) NOT NULL DEFAULT '',
+  regex varchar(40) NOT NULL DEFAULT '',
   PRIMARY KEY  (os_id)
 );
 
@@ -228,7 +228,7 @@
 CREATE TABLE TBL_VERSION (
   version_id INT4  NOT NULL DEFAULT '0',
   project_id INT4  NOT NULL DEFAULT '0',
-  version_name char(10) NOT NULL DEFAULT '',
+  version_name varchar(10) NOT NULL DEFAULT '',
   active INT2 NOT NULL DEFAULT '1',
   created_by INT4  NOT NULL DEFAULT '0',
   created_date INT8  NOT NULL DEFAULT '0',