values.sql

INSERT INTO params DEFAULT VALUES;

UPDATE params SET days_per_turn=7;
UPDATE params SET starting_coins=10000;
UPDATE params SET myth_powers_start=1;
UPDATE params SET base_office_price=15000;
UPDATE params SET office_multiplier=3;
UPDATE params SET coins_id=1;
UPDATE params SET roma_id=1;

INSERT INTO regions (name) VALUES
    ('Roma'),
    ('Gallia'),
    ('Hispania'),
    ('Germania'),
    ('Britannia'),
    ('Alpes'),
    ('Dalmatia'),
    ('Graeca'),
    ('Asia'),
    ('Arabia'),
    ('Aegyptus'),
    ('Africa');

INSERT INTO items (name, capacity, buyable) VALUES
    ('Coins', 0, 0),
    ('Grain', 1, 1),
    ('Bricks', 1, 1),
    ('Timber', 1, 1),
    ('Slaves', 1, 1),
    ('Pottery', 1, 1),
    ('Iron', 1, 1),
    ('Marble', 1, 1),
    ('Olive Oil', 1, 1),
    ('Wine', 1, 1),
    ('Silk', 1, 1),
    ('Perfume', 1, 1),
    ('Spices', 1, 1),
    ('Gems', 1, 1),
    ('Gold', 1, 1);

INSERT INTO prices (region_id, item_id, sell_price, buy_price) VALUES
    (1, 2, 8, 10),
    (1, 3, 75, 100),
    (1, 4, 80, 100),
    (1, 5, 180, 200),
    (1, 6, 250, 300),
    (1, 7, 400, 500),
    (1, 8, 700, 800),
    (1, 9, 7000, 8000),
    (2, 2, 10, 13),
    (2, 3, 55, 70),
    (2, 4, 55, 60),
    (2, 5, 190, 220),
    (2, 6, 150, 180),
    (2, 7, 350, 450),
    (2, 8, 850, 1000),
    (2, 9, 7200, 8500),
    (3, 2, 10, 15),
    (3, 3, 55, 65),
    (3, 4, 105, 130),
    (3, 5, 120, 160),
    (3, 6, 280, 360),
    (3, 7, 240, 360),
    (3, 8, 850, 1100),
    (3, 9, 5000, 5800),
    (4, 2, 9, 14),
    (4, 3, 105, 130),
    (4, 4, 75, 90),
    (4, 5, 150, 170),
    (4, 6, 200, 280),
    (4, 7, 250, 380),
    (4, 8, 700, 850),
    (4, 9, 8500, 10000),
    (5, 2, 10, 15),
    (5, 3, 110, 140),
    (5, 4, 55, 75),
    (5, 5, 200, 240),
    (5, 6, 290, 340),
    (5, 7, 200, 320),
    (5, 8, 880, 1080),
    (5, 9, 9500, 11500),
    (6, 2, 14, 18),
    (6, 3, 50, 60),
    (6, 4, 50, 70),
    (6, 5, 190, 200),
    (6, 6, 310, 350),
    (6, 7, 200, 300),
    (6, 8, 500, 600),
    (6, 9, 8500, 13000),
    (7, 2, 5, 6),
    (7, 3, 80, 110),
    (7, 4, 80, 110),
    (7, 5, 80, 100),
    (7, 6, 180, 220),
    (7, 7, 260, 370),
    (7, 8, 750, 900),
    (7, 9, 10200, 12000),
    (8, 2, 9, 12),
    (8, 3, 95, 130),
    (8, 4, 85, 120),
    (8, 5, 250, 260),
    (8, 6, 170, 200),
    (8, 7, 500, 550),
    (8, 8, 550, 650),
    (8, 9, 5000, 6000),
    (9, 2, 6, 7),
    (9, 3, 70, 100),
    (9, 4, 58, 65),
    (9, 5, 120, 150),
    (9, 6, 250, 320),
    (9, 7, 400, 480),
    (9, 8, 600, 680),
    (9, 9, 7200, 8200),
    (10, 2, 6, 7),
    (10, 3, 75, 110),
    (10, 4, 55, 75),
    (10, 5, 160, 180),
    (10, 6, 180, 230),
    (10, 7, 550, 600),
    (10, 8, 750, 850),
    (10, 9, 7000, 7800),
    (11, 2, 4, 5),
    (11, 3, 70, 90),
    (11, 4, 85, 120),
    (11, 5, 230, 250),
    (11, 6, 260, 330),
    (11, 7, 560, 620),
    (11, 8, 900, 1100),
    (11, 9, 8200, 9000),
    (12, 2, 5, 7),
    (12, 3, 50, 70),
    (12, 4, 45, 65),
    (12, 5, 60, 80),
    (12, 6, 200, 280),
    (12, 7, 530, 640),
    (12, 8, 1000, 1300),
    (12, 9, 7000, 8500),
    (1, 10, 9000, 10000),
    (1, 11, 30000, 35000),
    (1, 12, 35000, 40000),
    (1, 13, 40000, 45000),
    (1, 14, 65000, 70000),
    (1, 15, 95000, 100000),
    (2, 10, 5000, 7500),
    (2, 11, 38000, 41000),
    (2, 12, 36000, 43000),
    (2, 13, 46000, 51000),
    (2, 14, 63000, 70000),
    (2, 15, 105000, 115000),
    (3, 10, 5500, 8000),
    (3, 11, 39000, 42000),
    (3, 12, 42000, 45000),
    (3, 13, 45500, 50500),
    (3, 14, 69000, 75000),
    (3, 15, 70000, 78000),
    (4, 10, 11500, 13000),
    (4, 11, 33000, 41000),
    (4, 12, 42500, 45500),
    (4, 13, 50000, 55000),
    (4, 14, 45000, 49000),
    (4, 15, 90000, 100000),
    (5, 10, 8500, 10000),
    (5, 11, 35000, 43000),
    (5, 12, 43000, 47000),
    (5, 13, 54000, 57000),
    (5, 14, 78000, 85000),
    (5, 15, 75000, 85000),
    (6, 10, 12000, 13000),
    (6, 11, 35000, 44000),
    (6, 12, 41000, 45000),
    (6, 13, 42000, 46000),
    (6, 14, 55000, 60000),
    (6, 15, 78000, 88000),
    (7, 10, 11000, 13000),
    (7, 11, 30000, 36000),
    (7, 12, 29000, 33000),
    (7, 13, 40000, 46000),
    (7, 14, 64000, 72000),
    (7, 15, 88000, 92000),
    (8, 10, 7500, 9000),
    (8, 11, 31000, 34000),
    (8, 12, 35000, 39000),
    (8, 13, 42000, 46000),
    (8, 14, 73000, 78000),
    (8, 15, 108000, 118000),
    (9, 10, 9000, 11000),
    (9, 11, 20000, 24500),
    (9, 12, 28000, 31000),
    (9, 13, 35000, 38000),
    (9, 14, 48000, 52000),
    (9, 15, 85000, 95000),
    (10, 10, 10500, 12000),
    (10, 11, 22500, 26000),
    (10, 12, 25000, 28000),
    (10, 13, 31000, 34000),
    (10, 14, 54000, 58000),
    (10, 15, 96000, 105000),
    (11, 10, 9500, 10500),
    (11, 11, 25000, 28000),
    (11, 12, 31000, 34000),
    (11, 13, 28000, 31500),
    (11, 14, 54000, 58000),
    (11, 15, 78000, 88000),
    (12, 10, 10500, 13000),
    (12, 11, 25000, 35000),
    (12, 12, 30000, 38000),
    (12, 13, 34000, 37000),
    (12, 14, 65000, 75000),
    (12, 15, 85000, 105000);

INSERT INTO gods (name) VALUES
    ('Jupiter'),
    ('Juno'),
    ('Mars'),
    ('Apollo'),
    ('Minerva'),
    ('Venus'),
    ('Neptunus'),
    ('Pluto'),
    ('Ceres'),
    ('Dionysus'),
    ('Mercurius');

INSERT INTO myth_powers (god_id, name, description, event_id, delay) VALUES
    (1, 'Test 1', 'This is a test power that does nothing', 1, 0),
    (2, 'Test 2', 'This is a test power that does nothing', 1, 0),
    (3, 'Test 3', 'This is a test power that does nothing', 1, 0),
    (4, 'Test 4', 'This is a test power that does nothing', 1, 0),
    (5, 'Test 5', 'This is a test power that does nothing', 1, 0),
    (6, 'Test 6', 'This is a test power that does nothing', 1, 0),
    (7, 'Test 7', 'This is a test power that does nothing', 1, 0),
    (8, 'Test 8', 'This is a test power that does nothing', 1, 0),
    (9, 'Test 9', 'This is a test power that does nothing', 1, 0),
    (10, 'Test 10', 'This is a test power that does nothing', 1, 0),
    (11, 'Test 11', 'This is a test power that does nothing', 1, 0);

INSERT INTO myth_power_prices (myth_power_id, item_id, quantity) VALUES
    (1, 1, 5000),
    (2, 1, 5000),
    (3, 1, 5000),
    (4, 1, 5000),
    (5, 1, 5000),
    (6, 1, 5000),
    (7, 1, 5000),
    (8, 1, 5000),
    (9, 1, 5000),
    (10, 1, 5000),
    (11, 1, 5000);

INSERT INTO "events" (event_type, name) VALUES
    (3, 'Test Event');

INSERT INTO upgrade_prices (level, item_id, quantity) VALUES
    (2, 4, 2),
    (2, 7, 1),
    (3, 4, 4),
    (3, 7, 3),
    (4, 7, 4),
    (4, 8, 4),
    (5, 9, 1),
    (5, 5, 9),
    (6, 11, 1),
    (6, 8, 9);

INSERT INTO office_levels (level, capacity) values
    (1, 10),
    (2, 12),
    (3, 15),
    (4, 19),
    (5, 24),
    (6, 30);