-- Creates a new database when a new game is created
-- @author Eric Pietrocupo
-- @date March 29th, 2026
-- @license GNU GPL 3.0
--
-- Runs after table creation. prevent putting the queries inside the program
-- for thing easily ran in a script. Also insert constants in the database.

-- Constant Record insertions

INSERT INTO stock ( pk, name, code ) VALUES ( 0, "Grain", "GRAIN");
INSERT INTO stock ( pk, name, code ) VALUES ( 1, "Industrial", "INDUS");
INSERT INTO stock ( pk, name, code ) VALUES ( 2, "Bonds", "BOND");
INSERT INTO stock ( pk, name, code ) VALUES ( 3, "Oil", "OIL");
INSERT INTO stock ( pk, name, code ) VALUES ( 4, "Silver", "SILVR");
INSERT INTO stock ( pk, name, code ) VALUES ( 5, "Gold", "GOLD");

INSERT INTO variant (pk, name) VALUES (0, "Dividend rolls also goes up");
INSERT INTO variant (pk, name) VALUES (2, "Use insider knowledge cards");

-- Insider knowledge events
-- NOTE: Use only 1 event per card roll, else it will cause issues inside the SQL scripts
INSERT INTO event (pk, name, fk_stock, move, number) VALUES
-- GRAIN (0)
(1, "Advance reports suggest improved harvest yields",0,1,5),
(2, "Warehouse expanding grain storage capacity",0,1,10),
(3, "Large buyers preparing to secure grain reserves",0,1,20),

(4, "Early signs of minor crop spoilage emerging",0,-1,5),
(5, "Transport agents warn of shipment delays",0,-1,10),
(6, "Confidential reports of harvest failure spreading",0,-1,20),

(7, "Small coop dividend expected from grain sales",0,0,5),
(8, "Export groups planning good profit distribution",0,0,10),
(9, "Grain syndicate preparing exceptional payout",0,0,20),

-- INDUSTRIAL (1)
(10,"Factories expected to slightly increase output",1,1,5),
(11,"Industrial managers planning production expansion",1,1,10),
(12,"Large-scale contracts about to boost demand",1,1,20),

(13,"Minor equipment issues reported across factories",1,-1,5),
(14,"Labor tensions expected to disrupt production",1,-1,10),
(15,"Insiders warn of widespread factory shutdowns",1,-1,20),

(16,"Routine industrial dividend expected",1,0,5),
(17,"Strong earnings likely to produce solid payout",1,0,10),
(18,"Exceptional profit distribution planned by firms",1,0,20), -- Maybe line max size

-- BONDS (2)
(19,"Bond market confidence quietly improving",2,1,5),
(20,"Large investors shifting funds into bonds",2,1,10),
(21,"Institutions preparing heavy bond accumulation",2,1,20),

(22,"Early concerns about bond issuer reliability",2,-1,5),
(23,"Insiders expect significant bond sell-off",2,-1,10),
(24,"Secret warnings of widespread bond liquidation",2,-1,20),

(25,"Routine coupon payment expected",2,0,5),
(26,"Above-average bond yields anticipated",2,0,10),
(27,"Exceptional payout expected from key issuers",2,0,20),

-- OIL (3)
(28,"New wells expected to slightly increase output",3,1,5),
(29,"Refineries preparing for higher production levels",3,1,10),
(30,"Major fuel demand surge anticipated by insiders",3,1,20),

(31,"Minor disruptions reported in oil transport",3,-1,5),
(32,"Refinery slowdowns expected to impact supply",3,-1,10),
(33,"Production issues likely to halt operations",3,-1,20),

(34,"Routine oil dividend expected",3,0,5),
(35,"Strong refinery profits to be distributed",3,0,10),
(36,"Large profit sharing expected in oil sector",3,0,20),

-- SILVER (4)
(37,"Slight increase in demand for silver anticipated",4,1,5),
(38,"Industrial buyers quietly accumulating silver",4,1,10),
(39,"Speculators preparing large silver purchases",4,1,20),

(40,"Small surplus of silver entering market",4,-1,5),
(41,"Decline in industrial demand expected",4,-1,10),
(42,"Heavy selling pressure expected to hit silver",4,-1,20),

(43,"Minor dividend expected from silver holdings",4,0,5),
(44,"Strong returns anticipated from silver trade",4,0,10),
(45,"Exceptional distribution expected from reserves",4,0,20),

-- GOLD (5)
(46,"Confidence in gold quietly strengthening",5,1,5),
(47,"Wealthy investors increasing gold positions",5,1,10),
(48,"Large-scale accumulation of gold anticipated",5,1,20),

(49,"Some investors preparing to exit gold positions",5,-1,5),
(50,"Growing pressure expected to lower gold prices",5,-1,10),
(51,"Major liquidation of gold holdings anticipated",5,-1,20),

(52,"Routine gold dividend expected",5,0,5),
(53,"Strong bullion returns anticipated",5,0,10),
(54,"Exceptional gold payout expected by insiders",5,0,20);


