45 lines
914 B
SQL
45 lines
914 B
SQL
|
|
-- TODO update sizes table with a FK to bulk to get the data from the table on
|
|
-- pg 272 CRB
|
|
|
|
PRAGMA foreign_keys = ON; -- database requires foreign key checking to be turned
|
|
-- on PER CONNECTION
|
|
INSERT INTO bulks (
|
|
bulk_id,
|
|
short_name,
|
|
long_name,
|
|
numerical)
|
|
VALUES
|
|
(1, '-', 'Negligible', 0.0),
|
|
(2, 'L', 'Light', 0.1),
|
|
(3, '1', 'One', 1.0),
|
|
(4, '2', 'Two', 2.0),
|
|
(5, '3', 'Three', 3.0),
|
|
(6, '4', 'Four', 4.0),
|
|
(7, '5', 'Five', 5.0);
|
|
|
|
INSERT INTO sourceentries (
|
|
sourceentry_id
|
|
,sources_id
|
|
,page_start
|
|
,page_stop
|
|
)
|
|
VALUES
|
|
-- 800 to 899 is reserved for bulks --
|
|
(800, 1, 271, 272) -- '-', L, 1, 2, 3, 4, 5 --
|
|
;
|
|
|
|
INSERT INTO bulks_sourceentries (
|
|
id
|
|
,bulk_id
|
|
,sourceentry_id
|
|
)
|
|
VALUES
|
|
(1, 1, 800) -- '-' --
|
|
,(2, 2, 800) -- L --
|
|
,(3, 3, 800) -- 1 --
|
|
,(4, 4, 800) -- 2 --
|
|
,(5, 5, 800) -- 3 --
|
|
,(6, 6, 800) -- 4 --
|
|
,(7, 7, 800) -- 5 --
|
|
; |