26 lines
820 B
SQL
26 lines
820 B
SQL
CREATE TABLE animals (
|
|
animalnr INTEGER UNIQUE NOT NULL,
|
|
earmark CHAR (25) NOT NULL,
|
|
rfid INTEGER,
|
|
forbidmilk CHAR (1) default '0',
|
|
tsforbidstart timestamp (14),
|
|
tsforbidend timestamp (14)
|
|
);
|
|
|
|
CREATE TABLE milkdata (
|
|
ts timestamp (14) NOT NULL,
|
|
animalnr INTEGER NOT NULL,
|
|
ammount decimal(10,2) NOT NULL default '0',
|
|
time integer NOT NULL,
|
|
milkplace INTEGER NOT NULL default 1
|
|
);
|
|
|
|
CREATE TABLE milkingtimes (
|
|
milking char (20),
|
|
starttime timestamp (14) NOT NULL,
|
|
endtime timestamp (14) NOT NULL
|
|
);
|
|
INSERT INTO milkingtimes VALUES('morning', '2000-01-01 03:00:00','2000-01-01 09:00:00');
|
|
INSERT INTO milkingtimes VALUES('noon', '2000-01-01 10:00:00','2000-01-01 14:00:00');
|
|
INSERT INTO milkingtimes VALUES('evening', '2000-01-01 18:00:00','2000-01-01 22:00:00');
|