SGUA1Uee

1DROP USER IF EXISTS rae;
2CREATE USER rae
3    ENCRYPTED PASSWORD 'rae';
4
5DROP TABLE IF EXISTS words CASCADE;
6CREATE TABLE words (
7    word text NOT NULL,
8    title text NOT NULL,
9    etymology text
10);
11ALTER TABLE words OWNER TO rae;
12
13DROP TABLE IF EXISTS expressions CASCADE;
14CREATE TABLE expressions (
15    expressionId serial PRIMARY KEY,
16    expression text
17);
18ALTER TABLE expressions OWNER TO rae;
19
20DROP TABLE IF EXISTS definitions CASCADE;
21CREATE TABLE definitions (
22    word text NOT NULL,
23    expressionId integer,
24    definition text NOT NULL,
25    metadata text[]
26);
27ALTER TABLE definitions OWNER TO rae;