commit 3b689693c94c3553f894ad41e76530f9b0ed5649
Author: Jon Jensen <jon@endpoint.com>
Date: Wed Nov 1 19:42:28 2017 -0600
Make userdb.mod_time NULL instead of invalid date '0000-00-00 00:00:00'
PostgreSQL doesn't tolerate the invalid date.
dist/strap/products/userdb.txt | 26 +++++++++++++-------------
1 files changed, 13 insertions(+), 13 deletions(-)
---
diff --git a/dist/strap/products/userdb.txt b/dist/strap/products/userdb.txt
index 3b32f1d..a81c28f 100644
--- a/dist/strap/products/userdb.txt
+++ b/dist/strap/products/userdb.txt
@@ -1,14 +1,14 @@
username usernick password expiration acl mod_time s_nickname company fname lname address1 address2 address3 city state zip country phone_day mv_shipmode b_nickname b_fname b_lname b_company b_address1 b_address2 b_address3 b_city b_state b_zip b_country b_phone p_nickname email fax phone_night address_book accounts preferences carts owner file_acl db_acl mail_list credit_limit inactive dealer price_level updated created
-ckirk kirk@icdevgroup.net kirk 0000-00-00 00:00:00 Auto Exchange Express Charles Kirk 123 Exchange Dr. Seattle WA 34987 US 360-111-1234 upsg kirk@icdevgroup.net 360-111-1239 360-111-1244 alert
-jdoe devnull@icdevgroup.net test 0000-00-00 00:00:00 John Doe 614 Hamlet Lane Herndon VA 20171 US 703-456-2965 upsg Jerry Balfour Akopia, Inc. 11480 Sunset Hills Rd. Suite 200 East Reston VA 20190 USA devnull@icdevgroup.net 703-555-1212 newsletter alert upgrade 99448.07 1 dealer
-jking king@icdevgroup.net king 0000-00-00 00:00:00 Car Parts, Inc. John King 123 Auto Blvd. Miami FL 39807 US 305-111-1234 upsg king@icdevgroup.net 305-111-1234 305-111-1239 alert upgrade
-jrollins Rollins@icdevgroup.net rollins 0000-00-00 00:00:00 Expert Repair, Inc. Joseph Rollins 123 Area Rd. Richmond VA 22398 US 804-111-1234 upsg Rollins@icdevgroup.net 804-111-1238 804-111-1243 alert upgrade 1
-ladams adams@icdevgroup.net adams 0000-00-00 00:00:00 Electronics Inc. Louis Adams 123 California Street Los Angeles CA 78902 US 714-111-1234 upsg adams@icdevgroup.net 714-111-1231 714-111-1235 newsletter alert upgrade
-lriley riley@icdevgroup.net riley 0000-00-00 00:00:00 Computerz Inc. Larry Riley 123 Monitor Rd. New York NY 46890 US 518-111-1234 upsg riley@icdevgroup.net 518111-1237 518-111-1242 alert 0
-mcarter carter@icdevgroup.net carter 0000-00-00 00:00:00 Spare Parts, Inc. Michele Carter 123 Parts Ctr Blvd. Annapolis MD 32498 US 301-111-1234 upsg carter@icdevgroup.net 703-111-1236 703-111-1241 alert
-mkeller keller@icdevgroup.net keller 0000-00-00 00:00:00 InfoMed, Inc. Michael Keller 123 Oak St. Portland OR 45098 US 541-111-1234 upsg keller@icdevgroup.net 541-111-1235 541-111-1240 alert upgrade 1
-mmichaels michael@icdevgroup.net michaels 0000-00-00 00:00:00 Medical Supplies Co. Michael Michaels 123 South Street Austin TX 30987 US 512-111-9876 upsg michael@icdevgroup.net 512-111-1232 512-111-1237 newsletter alert upgrade
-ssmith smith@icdevgroup.net smith 0000-00-00 00:00:00 Pharm Supplies, Inc. Steve Smith 456 Hopkins Ave Washington DC 20090 US 202-111-8763 upsg smith@icdevgroup.net 202-111-1233 202-111-1238 1
-test milton@icdevgroup.net test 0000-00-00 00:00:00 Big Porridge, Inc. Milton Bear 123 Any Blvd. Columbus OH 44101 US 555-227-1238 upsg milton@icdevgroup.net 555-908-9999 555-789-3456 newsletter alert upgrade 100000 0 0 distributor
-tjones jones@icdevgroup.net jones 0000-00-00 00:00:00 Automotive, Inc. Tammy Jones 123 Virginia Street Arlington VA 22041 US 703-111-1234 upsg jones@icdevgroup.net 703-111-1231 703-111-1236 alert 1
-tlucas lucas@icdevgroup.net lucas 0000-00-00 00:00:00 Construct Buildings Inc. Thomas Lucas 123 Building Dr. Phoenix AZ 56987 US 520-111-1234 upsg lucas@icdevgroup.net 520-111-1240 520-111-1245 alert
+ckirk kirk@icdevgroup.net kirk Auto Exchange Express Charles Kirk 123 Exchange Dr. Seattle WA 34987 US 360-111-1234 upsg kirk@icdevgroup.net 360-111-1239 360-111-1244 alert
+jdoe devnull@icdevgroup.net test John Doe 614 Hamlet Lane Herndon VA 20171 US 703-456-2965 upsg Jerry Balfour Akopia, Inc. 11480 Sunset Hills Rd. Suite 200 East Reston VA 20190 USA devnull@icdevgroup.net 703-555-1212 newsletter alert upgrade 99448.07 1 dealer
+jking king@icdevgroup.net king Car Parts, Inc. John King 123 Auto Blvd. Miami FL 39807 US 305-111-1234 upsg king@icdevgroup.net 305-111-1234 305-111-1239 alert upgrade
+jrollins Rollins@icdevgroup.net rollins Expert Repair, Inc. Joseph Rollins 123 Area Rd. Richmond VA 22398 US 804-111-1234 upsg Rollins@icdevgroup.net 804-111-1238 804-111-1243 alert upgrade 1
+ladams adams@icdevgroup.net adams Electronics Inc. Louis Adams 123 California Street Los Angeles CA 78902 US 714-111-1234 upsg adams@icdevgroup.net 714-111-1231 714-111-1235 newsletter alert upgrade
+lriley riley@icdevgroup.net riley Computerz Inc. Larry Riley 123 Monitor Rd. New York NY 46890 US 518-111-1234 upsg riley@icdevgroup.net 518111-1237 518-111-1242 alert 0
+mcarter carter@icdevgroup.net carter Spare Parts, Inc. Michele Carter 123 Parts Ctr Blvd. Annapolis MD 32498 US 301-111-1234 upsg carter@icdevgroup.net 703-111-1236 703-111-1241 alert
+mkeller keller@icdevgroup.net keller InfoMed, Inc. Michael Keller 123 Oak St. Portland OR 45098 US 541-111-1234 upsg keller@icdevgroup.net 541-111-1235 541-111-1240 alert upgrade 1
+mmichaels michael@icdevgroup.net michaels Medical Supplies Co. Michael Michaels 123 South Street Austin TX 30987 US 512-111-9876 upsg michael@icdevgroup.net 512-111-1232 512-111-1237 newsletter alert upgrade
+ssmith smith@icdevgroup.net smith Pharm Supplies, Inc. Steve Smith 456 Hopkins Ave Washington DC 20090 US 202-111-8763 upsg smith@icdevgroup.net 202-111-1233 202-111-1238 1
+test milton@icdevgroup.net test Big Porridge, Inc. Milton Bear 123 Any Blvd. Columbus OH 44101 US 555-227-1238 upsg milton@icdevgroup.net 555-908-9999 555-789-3456 newsletter alert upgrade 100000 0 0 distributor
+tjones jones@icdevgroup.net jones Automotive, Inc. Tammy Jones 123 Virginia Street Arlington VA 22041 US 703-111-1234 upsg jones@icdevgroup.net 703-111-1231 703-111-1236 alert 1
+tlucas lucas@icdevgroup.net lucas Construct Buildings Inc. Thomas Lucas 123 Building Dr. Phoenix AZ 56987 US 520-111-1234 upsg lucas@icdevgroup.net 520-111-1240 520-111-1245 alert
_______________________________________________
interchange-cvs mailing list
interchange-cvs@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-cvs
Author: Jon Jensen <jon@endpoint.com>
Date: Wed Nov 1 19:42:28 2017 -0600
Make userdb.mod_time NULL instead of invalid date '0000-00-00 00:00:00'
PostgreSQL doesn't tolerate the invalid date.
dist/strap/products/userdb.txt | 26 +++++++++++++-------------
1 files changed, 13 insertions(+), 13 deletions(-)
---
diff --git a/dist/strap/products/userdb.txt b/dist/strap/products/userdb.txt
index 3b32f1d..a81c28f 100644
--- a/dist/strap/products/userdb.txt
+++ b/dist/strap/products/userdb.txt
@@ -1,14 +1,14 @@
username usernick password expiration acl mod_time s_nickname company fname lname address1 address2 address3 city state zip country phone_day mv_shipmode b_nickname b_fname b_lname b_company b_address1 b_address2 b_address3 b_city b_state b_zip b_country b_phone p_nickname email fax phone_night address_book accounts preferences carts owner file_acl db_acl mail_list credit_limit inactive dealer price_level updated created
-ckirk kirk@icdevgroup.net kirk 0000-00-00 00:00:00 Auto Exchange Express Charles Kirk 123 Exchange Dr. Seattle WA 34987 US 360-111-1234 upsg kirk@icdevgroup.net 360-111-1239 360-111-1244 alert
-jdoe devnull@icdevgroup.net test 0000-00-00 00:00:00 John Doe 614 Hamlet Lane Herndon VA 20171 US 703-456-2965 upsg Jerry Balfour Akopia, Inc. 11480 Sunset Hills Rd. Suite 200 East Reston VA 20190 USA devnull@icdevgroup.net 703-555-1212 newsletter alert upgrade 99448.07 1 dealer
-jking king@icdevgroup.net king 0000-00-00 00:00:00 Car Parts, Inc. John King 123 Auto Blvd. Miami FL 39807 US 305-111-1234 upsg king@icdevgroup.net 305-111-1234 305-111-1239 alert upgrade
-jrollins Rollins@icdevgroup.net rollins 0000-00-00 00:00:00 Expert Repair, Inc. Joseph Rollins 123 Area Rd. Richmond VA 22398 US 804-111-1234 upsg Rollins@icdevgroup.net 804-111-1238 804-111-1243 alert upgrade 1
-ladams adams@icdevgroup.net adams 0000-00-00 00:00:00 Electronics Inc. Louis Adams 123 California Street Los Angeles CA 78902 US 714-111-1234 upsg adams@icdevgroup.net 714-111-1231 714-111-1235 newsletter alert upgrade
-lriley riley@icdevgroup.net riley 0000-00-00 00:00:00 Computerz Inc. Larry Riley 123 Monitor Rd. New York NY 46890 US 518-111-1234 upsg riley@icdevgroup.net 518111-1237 518-111-1242 alert 0
-mcarter carter@icdevgroup.net carter 0000-00-00 00:00:00 Spare Parts, Inc. Michele Carter 123 Parts Ctr Blvd. Annapolis MD 32498 US 301-111-1234 upsg carter@icdevgroup.net 703-111-1236 703-111-1241 alert
-mkeller keller@icdevgroup.net keller 0000-00-00 00:00:00 InfoMed, Inc. Michael Keller 123 Oak St. Portland OR 45098 US 541-111-1234 upsg keller@icdevgroup.net 541-111-1235 541-111-1240 alert upgrade 1
-mmichaels michael@icdevgroup.net michaels 0000-00-00 00:00:00 Medical Supplies Co. Michael Michaels 123 South Street Austin TX 30987 US 512-111-9876 upsg michael@icdevgroup.net 512-111-1232 512-111-1237 newsletter alert upgrade
-ssmith smith@icdevgroup.net smith 0000-00-00 00:00:00 Pharm Supplies, Inc. Steve Smith 456 Hopkins Ave Washington DC 20090 US 202-111-8763 upsg smith@icdevgroup.net 202-111-1233 202-111-1238 1
-test milton@icdevgroup.net test 0000-00-00 00:00:00 Big Porridge, Inc. Milton Bear 123 Any Blvd. Columbus OH 44101 US 555-227-1238 upsg milton@icdevgroup.net 555-908-9999 555-789-3456 newsletter alert upgrade 100000 0 0 distributor
-tjones jones@icdevgroup.net jones 0000-00-00 00:00:00 Automotive, Inc. Tammy Jones 123 Virginia Street Arlington VA 22041 US 703-111-1234 upsg jones@icdevgroup.net 703-111-1231 703-111-1236 alert 1
-tlucas lucas@icdevgroup.net lucas 0000-00-00 00:00:00 Construct Buildings Inc. Thomas Lucas 123 Building Dr. Phoenix AZ 56987 US 520-111-1234 upsg lucas@icdevgroup.net 520-111-1240 520-111-1245 alert
+ckirk kirk@icdevgroup.net kirk Auto Exchange Express Charles Kirk 123 Exchange Dr. Seattle WA 34987 US 360-111-1234 upsg kirk@icdevgroup.net 360-111-1239 360-111-1244 alert
+jdoe devnull@icdevgroup.net test John Doe 614 Hamlet Lane Herndon VA 20171 US 703-456-2965 upsg Jerry Balfour Akopia, Inc. 11480 Sunset Hills Rd. Suite 200 East Reston VA 20190 USA devnull@icdevgroup.net 703-555-1212 newsletter alert upgrade 99448.07 1 dealer
+jking king@icdevgroup.net king Car Parts, Inc. John King 123 Auto Blvd. Miami FL 39807 US 305-111-1234 upsg king@icdevgroup.net 305-111-1234 305-111-1239 alert upgrade
+jrollins Rollins@icdevgroup.net rollins Expert Repair, Inc. Joseph Rollins 123 Area Rd. Richmond VA 22398 US 804-111-1234 upsg Rollins@icdevgroup.net 804-111-1238 804-111-1243 alert upgrade 1
+ladams adams@icdevgroup.net adams Electronics Inc. Louis Adams 123 California Street Los Angeles CA 78902 US 714-111-1234 upsg adams@icdevgroup.net 714-111-1231 714-111-1235 newsletter alert upgrade
+lriley riley@icdevgroup.net riley Computerz Inc. Larry Riley 123 Monitor Rd. New York NY 46890 US 518-111-1234 upsg riley@icdevgroup.net 518111-1237 518-111-1242 alert 0
+mcarter carter@icdevgroup.net carter Spare Parts, Inc. Michele Carter 123 Parts Ctr Blvd. Annapolis MD 32498 US 301-111-1234 upsg carter@icdevgroup.net 703-111-1236 703-111-1241 alert
+mkeller keller@icdevgroup.net keller InfoMed, Inc. Michael Keller 123 Oak St. Portland OR 45098 US 541-111-1234 upsg keller@icdevgroup.net 541-111-1235 541-111-1240 alert upgrade 1
+mmichaels michael@icdevgroup.net michaels Medical Supplies Co. Michael Michaels 123 South Street Austin TX 30987 US 512-111-9876 upsg michael@icdevgroup.net 512-111-1232 512-111-1237 newsletter alert upgrade
+ssmith smith@icdevgroup.net smith Pharm Supplies, Inc. Steve Smith 456 Hopkins Ave Washington DC 20090 US 202-111-8763 upsg smith@icdevgroup.net 202-111-1233 202-111-1238 1
+test milton@icdevgroup.net test Big Porridge, Inc. Milton Bear 123 Any Blvd. Columbus OH 44101 US 555-227-1238 upsg milton@icdevgroup.net 555-908-9999 555-789-3456 newsletter alert upgrade 100000 0 0 distributor
+tjones jones@icdevgroup.net jones Automotive, Inc. Tammy Jones 123 Virginia Street Arlington VA 22041 US 703-111-1234 upsg jones@icdevgroup.net 703-111-1231 703-111-1236 alert 1
+tlucas lucas@icdevgroup.net lucas Construct Buildings Inc. Thomas Lucas 123 Building Dr. Phoenix AZ 56987 US 520-111-1234 upsg lucas@icdevgroup.net 520-111-1240 520-111-1245 alert
_______________________________________________
interchange-cvs mailing list
interchange-cvs@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-cvs