· 7 years ago · Mar 02, 2019, 05:50 AM
1DROP TYPE IF EXISTS grocery;
2
3CREATE TYPE grocery AS ENUM(
4 'Main',
5 'Snack',
6 'Lunch',
7 'Breakfast'
8);
9
10CREATE TABLE IF NOT EXISTS shopping_list (
11 id INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
12 name text NOT NULL,
13 price decimal(6,2) NOT NULL,
14 date_added date default now(),
15 checked boolean default false,
16 category grocery NOT NULL
17);