Db9sR8PM

1DROP DATABASE IF EXISTS 12a_17_kristian_radkov;
2CREATE DATABASE 12a_17_kristian_radkov;
3
4USE 12a_17_kristian_radkov;
5
6CREATE TABLE uAccount (
7	id INT AUTO_INCREMENT NOT NULL,
8    userName VARCHAR(64),
9	userPassword VARCHAR(128),
10	email VARCHAR(64),
11    PRIMARY KEY (id)
12);
13
14CREATE TABLE Project (
15	id INT AUTO_INCREMENT NOT NULL,
16    accountId INT,
17    customerId INT,
18    title VARCHAR(64),
19    PRIMARY KEY(id),
20    FOREIGN KEY(accountId) references uAccount(id),
21    FOREIGN KEY(customerId) references Customer(id)
22);
23
24CREATE TABLE Customer (
25	id INT AUTO_INCREMENT NOT NULL,
26	accountId INT,
27    cName VARCHAR(64),
28    logo VARCHAR(64),
29    PRIMARY KEY(id),
30    FOREIGN KEY(accountId) references uAccount(id)
31);
32
33INSERT INTO uAccount(userName, email)