From d641553a1d729eca65b9e7c31115bf98c9bd2e6b Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Tue, 17 Dec 2013 12:10:53 -0500 Subject: [PATCH] Oh yes, that's how NOT NULL DEFAULT values work, right. Signed-off-by: Dan Scott --- Open-ILS/tests/datasets/sql/libraries.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/tests/datasets/sql/libraries.sql b/Open-ILS/tests/datasets/sql/libraries.sql index ed53cf5fa2..a91a475bb8 100644 --- a/Open-ILS/tests/datasets/sql/libraries.sql +++ b/Open-ILS/tests/datasets/sql/libraries.sql @@ -46,9 +46,9 @@ INSERT INTO actor.hours_of_operation (id, dow_0_open, dow_0_close, dow_1_open, d dow_2_open, dow_2_close, dow_3_open, dow_3_close, dow_4_open, dow_4_close, dow_5_open, dow_5_close, dow_6_open, dow_6_close) VALUES -- BR1 - accept defaults of 09:00 - 17:00 for each day - (4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), + (4, '09:00', '17:00', '09:00', '17:00', '09:00', '17:00', '09:00', '17:00', '09:00', '17:00', '09:00', '17:00', '09:00', '17:00'), -- BR2 - accept defaults of 09:00 - 17:00 for some days - (5, '08:30', '21:30', '09:30', '14:30', '10:00', '21:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL), + (5, '08:30', '21:30', '09:30', '14:30', '10:00', '21:30', , '09:00', '17:00', '09:00', '17:00', '09:00', '17:00'), -- BR3 - accept defaults of 09:00 - 17:00 for some days (6, '08:00', '23:30', '08:00', '23:30', '08:00', '23:30', '08:00', '23:30', '09:00', '23:30', '13:00', '23:30', '09:00', '23:30'), -- BR4 - closed on weekends (convention is 00:00 - 00:00) -- 2.11.0