[interchange-cvs] interchange - heins modified 2 files

[interchange-cvs at icdevgroup.org]

User:      heins
Date:      2008-05-11 18:27:41 GMT
Modified:  dist/standard/dbconf/mysql userdb.mysql
Modified:  dist/standard/products mv_metadata.asc
Log:
* Make MySQL do right thing with mod_time by setting to PREFER_NULL and
  making the widget in the table editor be 'value'.

Revision  Changes    Path
1.4                  interchange/dist/standard/dbconf/mysql/userdb.mysql


rev 1.4, prev_rev 1.3
Index: userdb.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/standard/dbconf/mysql/userdb.mysql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- userdb.mysql	24 Mar 2008 15:30:10 -0000	1.3
+++ userdb.mysql	11 May 2008 18:27:41 -0000	1.4
@@ -47,3 +47,4 @@
 Database  userdb  COLUMN_DEF   "state=varchar(20)"
 Database  userdb  COLUMN_DEF   "updated=varchar(32)"
 Database  userdb  COLUMN_DEF   "zip=varchar(10)"
+Database  userdb  PREFER_NULL   mod_time



1.17                 interchange/dist/standard/products/mv_metadata.asc


rev 1.17, prev_rev 1.16
Index: mv_metadata.asc
===================================================================
RCS file: /var/cvs/interchange/dist/standard/products/mv_metadata.asc,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -r1.16 -r1.17
--- mv_metadata.asc	10 May 2008 14:07:40 -0000	1.16
+++ mv_metadata.asc	11 May 2008 18:27:41 -0000	1.17
@@ -330,7 +330,7 @@
 userdb::inactive	yesno									Inactive
 userdb::lname	text	30								Last Name
 userdb::mail_list	check_nbsp							offer=Special Offers, newsletter=Newsletter, alert=Alerts and Recalls, upgrade=Upgrades					null_to_space
-userdb::mod_time	text	20
+userdb::mod_time	value	20
 userdb::phone_day	text	30								Daytime Phone
 userdb::phone_night	text	30								Home Phone
 userdb::price_level	select							=Retail,dealer=Dealer,distributor=Distributor		Price level