QtRw2hgU

1CREATE DATABASE IF NOT EXISTS addlister;
2
3-- Users:
4--     [A]id INT UNSIGNED, [B]email varchar(128), [C]password (hash) varchar(256)
5--
6-- Advertizement:
7--     [D]id INT UNSIGNED, [E]title varchar(128), [F]description varchar(1024), [M]creator -> [A] INT UNSIGNED
8--
9-- Categories (join-table):
10--     [G]id INT UNSIGNED, [H]category-id -> [K] INT UNSIGNED, [J]add-id -> [D] INT UNSIGNED
11--
12-- Available-Categories (DISCRETE)
13--     [K]id INT UNSIGNED, [L]category-name varchar(128)
14
15USE addlister;
16
17CREATE TABLE IF NOT EXISTS users (
18  id INT UNSIGNED AUTO_INCREMENT,
19  email varchar(128),
20  password varchar(256),
21  PRIMARY KEY(id)
22);
23
24CREATE TABLE IF NOT EXISTS advertizement (
25  id INT UNSIGNED AUTO_INCREMENT,
26  title varchar(128),
27  description varchar(1024),
28  creator INT UNSIGNED,
29  PRIMARY KEY(id)
30);
31
32CREATE TABLE IF NOT EXISTS categories (
33  id INT UNSIGNED AUTO_INCREMENT,
34  category_id INT UNSIGNED,
35  add_id INT UNSIGNED,
36  PRIMARY KEY(id)
37);
38
39CREATE TABLE IF NOT EXISTS defined_categories (
40  id INT UNSIGNED AUTO_INCREMENT,
41  category_name varchar(128),
42  PRIMARY KEY(id)
43);
44
45INSERT INTO defined_categories (category_name)
46VALUES
47  ('help wanted'),
48  ('furniture'),
49  ('giveaway'),
50  ('software'),
51  ('websites'),
52  ('for rent'),
53  ('for sale')
54;