Cg5RqHHW

1DROP TYPE IF EXISTS grocery;
2CREATE TYPE grocery AS ENUM (
3    'Main',
4    'Snack',
5    'Lunch',
6    'Breakfast'
7);
8
9CREATE TABLE IF NOT EXISTS shopping_list (
10    id INTEGER PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
11    name TEXT NOT NULL,
12    price decimal(12,2) NOT NULL,
13    date_added TIMESTAMP DEFAULT now() NOT NULL,
14    checked BOOLEAN DEFAULT false,
15    category grocery NOT NULL
16)