[interchange] Make userdb.mod_time NULL instead of invalid date '0000-00-00 00:00:00'
Jon Jensen <[email protected]> Thu, 02 Nov 2017 05:54:35 +0000
| Newsgroups | gmane.comp.web.interchange.cvs |
|---|---|
| Message-ID | <[email protected]> |
commit 3b689693c94c3553f894ad41e76530f9b0ed5649 Author: Jon Jensen <[email protected]> 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 [email protected] kirk 0000-00-00 00:00:00 Auto Exchange Express Charles Kirk 123 Exchange Dr. Seattle WA 34987 US 360-111-1234 upsg [email protected] 360-111-1239 360-111-1244 alert -jdoe [email protected] 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 [email protected] 703-555-1212 newsletter alert upgrade 99448.07 1 dealer -jking [email protected] king 0000-00-00 00:00:00 Car Parts, Inc. John King 123 Auto Blvd. Miami FL 39807 US 305-111-1234 upsg [email protected] 305-111-1234 305-111-1239 alert upgrade -jrollins [email protected] rollins 0000-00-00 00:00:00 Expert Repair, Inc. Joseph Rollins 123 Area Rd. Richmond VA 22398 US 804-111-1234 upsg [email protected] 804-111-1238 804-111-1243 alert upgrade 1 -ladams [email protected] adams 0000-00-00 00:00:00 Electronics Inc. Louis Adams 123 California Street Los Angeles CA 78902 US 714-111-1234 upsg [email protected] 714-111-1231 714-111-1235 newsletter alert upgrade -lriley [email protected] riley 0000-00-00 00:00:00 Computerz Inc. Larry Riley 123 Monitor Rd. New York NY 46890 US 518-111-1234 upsg [email protected] 518111-1237 518-111-1242 alert 0 -mcarter [email protected] carter 0000-00-00 00:00:00 Spare Parts, Inc. Michele Carter 123 Parts Ctr Blvd. Annapolis MD 32498 US 301-111-1234 upsg [email protected] 703-111-1236 703-111-1241 alert -mkeller [email protected] keller 0000-00-00 00:00:00 InfoMed, Inc. Michael Keller 123 Oak St. Portland OR 45098 US 541-111-1234 upsg [email protected] 541-111-1235 541-111-1240 alert upgrade 1 -mmichaels [email protected] michaels 0000-00-00 00:00:00 Medical Supplies Co. Michael Michaels 123 South Street Austin TX 30987 US 512-111-9876 upsg [email protected] 512-111-1232 512-111-1237 newsletter alert upgrade -ssmith [email protected] smith 0000-00-00 00:00:00 Pharm Supplies, Inc. Steve Smith 456 Hopkins Ave Washington DC 20090 US 202-111-8763 upsg [email protected] 202-111-1233 202-111-1238 1 -test [email protected] test 0000-00-00 00:00:00 Big Porridge, Inc. Milton Bear 123 Any Blvd. Columbus OH 44101 US 555-227-1238 upsg [email protected] 555-908-9999 555-789-3456 newsletter alert upgrade 100000 0 0 distributor -tjones [email protected] jones 0000-00-00 00:00:00 Automotive, Inc. Tammy Jones 123 Virginia Street Arlington VA 22041 US 703-111-1234 upsg [email protected] 703-111-1231 703-111-1236 alert 1 -tlucas [email protected] lucas 0000-00-00 00:00:00 Construct Buildings Inc. Thomas Lucas 123 Building Dr. Phoenix AZ 56987 US 520-111-1234 upsg [email protected] 520-111-1240 520-111-1245 alert +ckirk [email protected] kirk Auto Exchange Express Charles Kirk 123 Exchange Dr. Seattle WA 34987 US 360-111-1234 upsg [email protected] 360-111-1239 360-111-1244 alert +jdoe [email protected] 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 [email protected] 703-555-1212 newsletter alert upgrade 99448.07 1 dealer +jking [email protected] king Car Parts, Inc. John King 123 Auto Blvd. Miami FL 39807 US 305-111-1234 upsg [email protected] 305-111-1234 305-111-1239 alert upgrade +jrollins [email protected] rollins Expert Repair, Inc. Joseph Rollins 123 Area Rd. Richmond VA 22398 US 804-111-1234 upsg [email protected] 804-111-1238 804-111-1243 alert upgrade 1 +ladams [email protected] adams Electronics Inc. Louis Adams 123 California Street Los Angeles CA 78902 US 714-111-1234 upsg [email protected] 714-111-1231 714-111-1235 newsletter alert upgrade +lriley [email protected] riley Computerz Inc. Larry Riley 123 Monitor Rd. New York NY 46890 US 518-111-1234 upsg [email protected] 518111-1237 518-111-1242 alert 0 +mcarter [email protected] carter Spare Parts, Inc. Michele Carter 123 Parts Ctr Blvd. Annapolis MD 32498 US 301-111-1234 upsg [email protected] 703-111-1236 703-111-1241 alert +mkeller [email protected] keller InfoMed, Inc. Michael Keller 123 Oak St. Portland OR 45098 US 541-111-1234 upsg [email protected] 541-111-1235 541-111-1240 alert upgrade 1 +mmichaels [email protected] michaels Medical Supplies Co. Michael Michaels 123 South Street Austin TX 30987 US 512-111-9876 upsg [email protected] 512-111-1232 512-111-1237 newsletter alert upgrade +ssmith [email protected] smith Pharm Supplies, Inc. Steve Smith 456 Hopkins Ave Washington DC 20090 US 202-111-8763 upsg [email protected] 202-111-1233 202-111-1238 1 +test [email protected] test Big Porridge, Inc. Milton Bear 123 Any Blvd. Columbus OH 44101 US 555-227-1238 upsg [email protected] 555-908-9999 555-789-3456 newsletter alert upgrade 100000 0 0 distributor +tjones [email protected] jones Automotive, Inc. Tammy Jones 123 Virginia Street Arlington VA 22041 US 703-111-1234 upsg [email protected] 703-111-1231 703-111-1236 alert 1 +tlucas [email protected] lucas Construct Buildings Inc. Thomas Lucas 123 Building Dr. Phoenix AZ 56987 US 520-111-1234 upsg [email protected] 520-111-1240 520-111-1245 alert