[interchange-cvs] interchange - heins modified 2 files

[interchange-cvs at icdevgroup.org]

User:      heins
Date:      2004-02-23 20:33:25 GMT
Modified:  dist/foundation/dbconf/mysql affiliate.mysql
Modified:  dist/foundation/dbconf/pgsql affiliate.pgsql
Log:
* Use varchar field for key so that space-padded entries will not
  be a problem using the affiliate username field in an external table.

Revision  Changes    Path
2.3       +1 -1      interchange/dist/foundation/dbconf/mysql/affiliate.mysql


rev 2.3, prev_rev 2.2
Index: affiliate.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/mysql/affiliate.mysql,v
retrieving revision 2.2
retrieving revision 2.3
diff -u -r2.2 -r2.3
--- affiliate.mysql	15 Apr 2003 15:55:05 -0000	2.2
+++ affiliate.mysql	23 Feb 2004 20:33:25 -0000	2.3
@@ -1,4 +1,4 @@
 Database  affiliate  affiliate.txt __SQLDSN__
-Database  affiliate  COLUMN_DEF   "code=char(12) NOT NULL PRIMARY KEY"
+Database  affiliate  COLUMN_DEF   "affiliate=varchar(32) NOT NULL PRIMARY KEY"
 Database  affiliate  DEFAULT_TYPE text
 Database  affiliate  AUTO_NUMBER  A00000



2.2       +1 -1      interchange/dist/foundation/dbconf/pgsql/affiliate.pgsql


rev 2.2, prev_rev 2.1
Index: affiliate.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/affiliate.pgsql,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -r2.1 -r2.2
--- affiliate.pgsql	15 Apr 2003 15:55:05 -0000	2.1
+++ affiliate.pgsql	23 Feb 2004 20:33:25 -0000	2.2
@@ -6,5 +6,5 @@
 ifdef SQLPASS
 Database  affiliate  PASS         __SQLPASS__
 endif
-Database  affiliate  COLUMN_DEF   "code=varchar(12) NOT NULL PRIMARY KEY"
+Database  affiliate  COLUMN_DEF   "affiliate=varchar(32) NOT NULL PRIMARY KEY"
 Database  affiliate  DEFAULT_TYPE text