25 |
Udlånid serial primary key, |
Udlånid serial primary key, |
26 |
Personid int NOT NULL, |
Personid int NOT NULL, |
27 |
Stregkode bigint NOT NULL, |
Stregkode bigint NOT NULL, |
28 |
Startdato date NOT NULL, |
Startdato timestamp NOT NULL, |
29 |
Afleveringsdato date, |
Afleveringsdato timestamp, |
30 |
Antaldage int NOT NULL |
Antaldage int NOT NULL |
31 |
); |
); |
32 |
|
|
34 |
resevationid serial primary key, |
resevationid serial primary key, |
35 |
Personid int NOT NULL, |
Personid int NOT NULL, |
36 |
Stregkode bigint NOT NULL, |
Stregkode bigint NOT NULL, |
37 |
Startdato date NOT NULL |
Startdato timestamp NOT NULL |
38 |
); |
); |
39 |
|
|
40 |
create table Status ( |
create table Status ( |
45 |
-- ----------------------------------------------- |
-- ----------------------------------------------- |
46 |
-- Basic data |
-- Basic data |
47 |
INSERT INTO Person (Initialer,Navn,Pass,Admin) |
INSERT INTO Person (Initialer,Navn,Pass,Admin) |
48 |
VALUES ("ADM", 'Systems administrator', 'Admin', 1); |
VALUES ('ADM', 'Systems administrator', 'Admin', 1); |
49 |
|
|
50 |
INSERT INTO Status (Statusid, Beskrivelse) |
INSERT INTO Status (Statusid, Beskrivelse) |
51 |
VALUES (1,'Udlånt'); |
VALUES (1,'Udlånt'); |
62 |
insert into Person (Initialer, Navn) |
insert into Person (Initialer, Navn) |
63 |
values ('JFRE', 'Jytte Fredriksen'); |
values ('JFRE', 'Jytte Fredriksen'); |
64 |
|
|
65 |
insert into Udstyr (Stregkode, Navn, Beskrivelse, Placering) |
insert into Udstyr (Stregkode, Navn, Beskrivelse, Placering,Status) |
66 |
values (5709068802148, 'Projektor', 'VGA Projektor', 'LM01'); |
values (5709068802148, 'Projektor', 'VGA Projektor', 'LM01',3); |
67 |
|
|