20161208211542-add-session-number.up.sql

BEGIN TRANSACTION;
--;;
ALTER TABLE food
ADD COLUMN session BIGINT NOT NULL;
--;;
ALTER TABLE food
DROP CONSTRAINT pk;
--;;
ALTER TABLE food
ADD CONSTRAINT pk PRIMARY KEY(session, food_name, comment, customer);
--;;
ALTER TABLE prices
ADD COLUMN session BIGINT NOT NULL;
--;;
ALTER TABLE prices
DROP CONSTRAINT pk;
--;;
ALTER TABLE prices
ADD CONSTRAINT pk PRIMARY KEY(session, id);
--;;
COMMIT;