-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.sql
22 lines (22 loc) · 1.11 KB
/
database.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
DROP TABLE IF EXISTS commissions;
DROP TABLE IF EXISTS users;
CREATE TABLE users (
email VARCHAR(255) PRIMARY KEY,
username VARCHAR(255)
);
CREATE TABLE commissions (
id VARCHAR(255) PRIMARY KEY,
name VARCHAR(255) NOT NULL,
pronouns VARCHAR(255) NOT NULL,
description TEXT,
tier VARCHAR(255) NOT NULL,
status VARCHAR(255) DEFAULT 'pending',
price DECIMAL(10, 2) NULL,
paid BOOLEAN DEFAULT FALSE,
email VARCHAR(255),
cardId VARCHAR(255),
date DATE DEFAULT (CURRENT_DATE),
FOREIGN KEY (email) REFERENCES users(email)
);
-- In one line for easy copy-pasting
-- DROP TABLE IF EXISTS commissions; DROP TABLE IF EXISTS users; CREATE TABLE users (email VARCHAR(255) PRIMARY KEY, username VARCHAR(255)); CREATE TABLE commissions (id VARCHAR(255) PRIMARY KEY, name VARCHAR(255) NOT NULL, pronouns VARCHAR(255) NOT NULL, description TEXT, tier VARCHAR(255) NOT NULL, status VARCHAR(255) DEFAULT 'pending', price DECIMAL(10, 2) NULL, paid BOOLEAN DEFAULT FALSE, email VARCHAR(255), cardId VARCHAR(255), date DATE DEFAULT (CURRENT_DATE), FOREIGN KEY (email) REFERENCES users(email));