Commit
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
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
Showing
1 changed file
with
13 additions
and
13 deletions.
There are no files selected for viewing
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -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 |