Jwh5dBYh

1CREATE TABLE IF NOT EXISTS products
2(
3    id    SERIAL PRIMARY KEY AUTO_INCREMENT,
4    name  CHARACTER VARYING(30) NOT NULL,
5    price NUMERIC               NOT NULL,
6    count INTEGER DEFAULT 0
7);
8
9
10CREATE TABLE IF NOT EXISTS orders
11(
12    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
13    user_id    INTEGER REFERENCES users (id) NOT NULL,
14    created_at date                          NOT NULL
15);
16
17
18CREATE TABLE IF NOT EXISTS order_entries
19(
20
21);
22CREATE TABLE IF NOT EXISTS cart
23(
24    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
25    product_id INTEGER REFERENCES products (id) NOT NULL,
26    count      INTEGER DEFAULT 0,
27    amount     NUMERIC                          NOT NULL
28
29);
30CREATE TABLE IF NOT EXISTS categories
31(
32    id         SERIAL PRIMARY KEY KEY AUTO_INCREMENT,
33    name       CHARACTER VARYING(30)            NOT NULL,
34    product_id INTEGER REFERENCES products (id) NOT NULL
35);
36
37CREATE TABLE IF NOT EXISTS users
38(
39    id         SERIAL PRIMARY KEY AUTO_INCREMENT,
40    username   CHARACTER VARYING(30) NOT NULL,
41    first_name CHARACTER VARYING(30) NOT NULL,
42    last_name  CHARACTER VARYING(30) NOT NULL,
43    password   CHARACTER VARYING(50) NOT NULL,
44    email      CHARACTER VARYING(50) NOT NULL,
45    role       CHARACTER VARYING(10) NOT NULL,
46    created_at date                  NOT NULL
47);