CONNECT 'jdbc:mysql:PublisherDB;create=true';

-- drop tables (ignore errors if they don't exist)
DROP TABLE Anime;
DROP TABLE Studio;
DROP TABLE Merchandise;

-- create Anime table
CREATE TABLE Anime
(
    Series VARCHAR(40),
    Code VARCHAR(4),
    Primier DATE,
    Episodes DOUBLE,
    Demographic VARCHAR(40)
);

-- insert data into Anime table
INSERT INTO Anime VALUES
('One Punch Man', 'OPMD', '2015-10-05', 12, 'Seinen');

INSERT INTO Anime VALUES
('Code Geass', 'CGCC', '2006-10-05', 50, 'Shounen');

INSERT INTO Anime VALUES
('Cowboy Bebop', 'CBBP', '1998-04-03', 26, 'Seinen');

-- view data in Products table (temporary for viewing purpose)
SELECT * FROM Products;

CREATE TABLE Studio
(
    Studio VARCHAR(40),
    Code VARCHAR(4),
    Debit DOUBLE,
    Credit DOUBLE,
    Billing DATE

);

-- insert data into Studio table
INSERT INTO Studio VALUES
('Madhouse', 'OPMD', 250000, 250000, '2015-09-01');

INSERT INTO Studio VALUES
('Sunrise', 'CGCC', 956720, 956720, '2006-08-15');

INSERT INTO Studio VALUES
('Sunrise', 'CGCC', 956720, 956720, '2006-08-15');