use breakout;
# Order of insertions due to FK constraints
# ( f.e. to create a clan, a faction is needed first [faction <- clan])
# ball , block and pallet <- level
# level <- player <- wallet
# faction <- clan

# Ball (ball_id, ball_size, ball_speed)
insert into ball values(1, 3, 5);

# Block (block_id, block_size, block_healthpoints, block_property)
insert into block values(1, 1, 1, "normal");

# Pallet (pallet_id, pallet_size, pallet_speed)
insert into pallet values(1, 3, 5);

# Level (level_id, ball_id, pallet_id, block_id, target_score, diamonds_prize)
insert into level values (1, 1, 1, 1, 50, 25);

# Player (player_id, player_name, player_level, player_highscore, player_clan)
insert into player values(1,"Domi",1,0,0);
insert into player values(2,"Bert",1,350,0);

# Wallet (player_id, current_amt_of_diamonds, current_monetary_balance)
insert into wallet values (1, 0, 0);

# Faction (faction_id, faction_perk, faction_image)
insert into faction values(1, "1.25x xp", "fac_1_img");

# Clan (clan_id, clan_name, clan_highscore, clan_avatar, clan_active_league, faction_id, clan_leader)
insert into clan values(1, "DevTeam", 0, 1, 0, 1, 1);

# Ability (ability_id, ability_name, ability_affects, ability_effect, ability_droprate)
insert into ability values(1, "WreckingBall", "ball", "bigger_ball", 1.50);

# Store (package_id, package_price, package_diamonds, ability_id)
insert into store values (1, 1.99, 75, 0); # package costs 1.99 for 75 diamonds
insert into store values (2, 4,99, 150, 1); # package cost 4.99 for 150 diamonds and the ability wrecking ball

# Promotion (promotion_id, promotion_cut, promotion_diamonds)
insert into promotion values (1, .15, 0); # promotion on package 1 of 15 %, no extra diamonds
insert into promotion values (2, .25, 50); # promotion on package 1 of 25 %, 50 extra diamonds