Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
Make userdb.mod_time NULL instead of invalid date '0000-00-00 00:00:00'
PostgreSQL doesn't tolerate the invalid date.
  • Loading branch information
jonjensen committed Nov 2, 2017
1 parent c2c1b53 commit 3b68969
Showing 1 changed file with 13 additions and 13 deletions.
26 changes: 13 additions & 13 deletions 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

0 comments on commit 3b68969

Please sign in to comment.