jawara.sql

--
-- File generated with SQLiteStudio v3.2.1 on Fri Dec 2 13:58:45 2022
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: Login
CREATE TABLE Login (
userID VARCHAR(50) PRIMARY KEY NOT NULL,
password  VARCHAR(50) NOT NULL,
jobTitle CHAR(50) NOT NULL
);
INSERT INTO Login (userID, password, jobTitle) VALUES ('director1', 'iamtheboss', 'Director of Production');
INSERT INTO Login (userID, password, jobTitle) VALUES ('plant1', 'sagalapardede', 'plant manager');
INSERT INTO Login (userID, password, jobTitle) VALUES ('plant2', 'sukirnapak', 'plant operator');
INSERT INTO Login (userID, password, jobTitle) VALUES ('plant3', 'password3', 'plant operator');
INSERT INTO Login (userID, password, jobTitle) VALUES ('plant4', 'password4', 'plant operator');
INSERT INTO Login (userID, password, jobTitle) VALUES ('production1', 'prodboss', 'production manager');
INSERT INTO Login (userID, password, jobTitle) VALUES ('production2', 'password5', 'production operative');
INSERT INTO Login (userID, password, jobTitle) VALUES ('production3', 'password6', 'production operative');
INSERT INTO Login (userID, password, jobTitle) VALUES ('engineer1', 'ayumasturoh', 'product engineer');
INSERT INTO Login (userID, password, jobTitle) VALUES ('engineer2', 'password7', 'product engineer');
INSERT INTO Login (userID, password, jobTitle) VALUES ('engineer3', 'password8', 'product engineer');
INSERT INTO Login (userID, password, jobTitle) VALUES ('accessories1', 'miskun', 'accessories production operative');
INSERT INTO Login (userID, password, jobTitle) VALUES ('accessories2', 'password9', 'accessories production operative');
INSERT INTO Login (userID, password, jobTitle) VALUES ('accessories3', 'password10', 'accessories production operative');

-- Table: Manager
CREATE TABLE Manager (
managerID VARCHAR(50) PRIMARY KEY NOT NULL,
managerName CHAR(50) NOT NULL,
jobTitle CHAR(50),
FOREIGN KEY (managerID) 
REFERENCES Login(userID)
);
INSERT INTO Manager (managerID, managerName, jobTitle) VALUES ('director1', 'Pantun Nabanan', 'Director');
INSERT INTO Manager (managerID, managerName, jobTitle) VALUES ('plant1', 'Sagala Pardede', 'Plant Manager');
INSERT INTO Manager (managerID, managerName, jobTitle) VALUES ('production1', 'Brooke Perkins', 'Production Manager');
INSERT INTO Manager (managerID, managerName, jobTitle) VALUES ('engineer1', 'Ayu Masturohj', 'Product Engineer');
INSERT INTO Manager (managerID, managerName, jobTitle) VALUES ('accessories1', 'Suhardi Miskun', 'Accessories Manager');

COMMIT TRANSACTION;
PRAGMA foreign_keys = on;