Trybesmith.sql

-- This code was written and provided by Trybe

DROP SCHEMA IF EXISTS Trybesmith;
CREATE SCHEMA Trybesmith;

CREATE TABLE Trybesmith.Users (
  id INTEGER AUTO_INCREMENT PRIMARY KEY NOT NULL,
  username TEXT NOT NULL,
  classe TEXT NOT NULL,
  level INTEGER NOT NULL,
  password TEXT NOT NULL
);

CREATE TABLE Trybesmith.Orders (
  id INTEGER AUTO_INCREMENT PRIMARY KEY NOT NULL,
  userId INTEGER,
  FOREIGN KEY (userId) REFERENCES Trybesmith.Users (id)
);

CREATE TABLE Trybesmith.Products (
  id INTEGER AUTO_INCREMENT PRIMARY KEY NOT NULL,
  name TEXT NOT NULL,
  amount TEXT NOT NULL,
  orderId INTEGER,
  FOREIGN KEY (orderId) REFERENCES Trybesmith.Orders (id)
);

INSERT INTO Trybesmith.Users (username, classe, level, password) VALUES ("reigal","Guerreiro", 10, "1dragaonoceu");
INSERT INTO Trybesmith.Users (username, classe, level, password) VALUES ("vyrion","Inventor", 8, "pagandodividas");
INSERT INTO Trybesmith.Users (username, classe, level, password) VALUES ("yraa","Ladina", 5, "valarmorg");
  
INSERT INTO Trybesmith.Orders (userId) VALUES (1);
INSERT INTO Trybesmith.Orders (userId) VALUES (3);
INSERT INTO Trybesmith.Orders (userId) VALUES (2);

INSERT INTO Trybesmith.Products (name, amount) VALUES ("Espada curta","10 peças de ouro");
INSERT INTO Trybesmith.Products (name, amount, orderId) VALUES ("Escudo desnecessariamente grande","20 peças de ouro", 1);
INSERT INTO Trybesmith.Products (name, amount, orderId) VALUES ("Adaga de Aço Valírico","1 peça de ouro", 2);
INSERT INTO Trybesmith.Products (name, amount, orderId) VALUES ("Engenhoca aleatória","15 peças de ouro", 3);