forked from bimberlabinternal/LabDevKitModules
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathldk-12.36-12.37.sql
More file actions
22 lines (20 loc) · 1003 Bytes
/
ldk-12.36-12.37.sql
File metadata and controls
22 lines (20 loc) · 1003 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
CREATE TABLE ldk.months (
rowid serial,
monthName varchar(100),
monthNum int,
CONSTRAINT PK_months PRIMARY KEY (rowid)
);
-- @SkipOnEmptySchemasBegin
INSERT into ldk.months (monthName, monthNum) VALUES ('January', 1);
INSERT into ldk.months (monthName, monthNum) VALUES ('February', 2);
INSERT into ldk.months (monthName, monthNum) VALUES ('March', 3);
INSERT into ldk.months (monthName, monthNum) VALUES ('April', 4);
INSERT into ldk.months (monthName, monthNum) VALUES ('May', 5);
INSERT into ldk.months (monthName, monthNum) VALUES ('June', 6);
INSERT into ldk.months (monthName, monthNum) VALUES ('July', 7);
INSERT into ldk.months (monthName, monthNum) VALUES ('August', 8);
INSERT into ldk.months (monthName, monthNum) VALUES ('September', 9);
INSERT into ldk.months (monthName, monthNum) VALUES ('October', 10);
INSERT into ldk.months (monthName, monthNum) VALUES ('November', 11);
INSERT into ldk.months (monthName, monthNum) VALUES ('December', 12);
-- @SkipOnEmptySchemasEnd