-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathPlaywriteDB.sql
More file actions
46 lines (36 loc) · 972 Bytes
/
Copy pathPlaywriteDB.sql
File metadata and controls
46 lines (36 loc) · 972 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
CREATE DATABASE PlaywriteDB
--Admin and Therapist login details
CREATE TABLE users(
uID INT PRIMARY KEY NOT NULL IDENTITY(1,1),
firstName VARCHAR(50) NOT NULL,
lastName VARCHAR(50) NOT NULL,
email VARCHAR(50) NOT NULL,
uPassword varbinary(MAX) NOT NULL,
uSalt varbinary(MAX) NOT NULL,
uRole BIT NOT NULL
);
--Caretaker newsletter subscriptions (mailing list)
CREATE TABLE subscriptions(
subID INT PRIMARY KEY NOT NULL IDENTITY(1,1),
email VARCHAR(50)
);
--Physical Newsletters storage
CREATE TABLE newsletters(
nID INT PRIMARY KEY NOT NULL IDENTITY(1,1),
publishedDate DateTime,
cloudID VARCHAR(256),
cloudURL VARCHAR(MAX),
);
--Physical Newsletters storage
CREATE TABLE media(
mID INT PRIMARY KEY NOT NULL IDENTITY(1,1),
publishedDate DateTime,
title VARCHAR(256)
cloudID VARCHAR(256),
cloudURL VARCHAR(MAX),
);
INSERT INTO orders VALUES(1,3,'10/06/2021');
SELECT * FROM users;
SELECT * FROM newsletters;
SELECT * FROM subscriptions;
SELECT * FROM media;