Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
17 lines (14 sloc) 701 Bytes
DROP TABLE IF EXISTS "bakery_basket";
DROP SEQUENCE IF EXISTS bakery_basket_id_seq;
CREATE SEQUENCE bakery_basket_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;
CREATE TABLE "public"."bakery_basket" (
"id" integer DEFAULT nextval('bakery_basket_id_seq') NOT NULL,
"date" character varying(10) NOT NULL,
"time" character varying(8) NOT NULL,
"transaction" integer NOT NULL,
"item" character varying(50) NOT NULL
) WITH (oids = false);
INSERT INTO "bakery_basket" ("date", "time", "transaction", "item", "id") VALUES
('2016-10-30', '09:58:11', 1, 'Bread', 1),
('2016-10-30', '10:05:34', 2, 'Scandinavian', 2),
('2016-10-30', '10:07:57', 3, 'Hot chocolate', 3);