relational-schema: lotb_dml.sql

INSERT INTO Player (Username, Email, Password) VALUES 
('HeroSlayer', 'hero@example.com', 'hashedpassword1'),
('DragonMaster', 'dragon@example.com', 'hashedpassword2');

INSERT INTO Character (PlayerID, Name, Health, EXP, Gold) VALUES 
(1, 'Alek', 100, 10, 500),
(2, 'Mira', 120, 20, 600);

INSERT INTO Faction (Name, Description) VALUES 
('Kingdom of Zeta', 'A mighty kingdom with strong warriors.'),
('The Shadow Order', 'A secretive group of assassins.');

INSERT INTO Reputation (CharacterID, FactionID, ReputationPoints, Rank) VALUES 
(1, 1, 100, 'Knight'),
(2, 2, -50, 'Outlaw');

INSERT INTO Quest (Name, EXP_Required, EXP_Reward, Gold_Reward) VALUES 
('Defeat the Bandits', 0, 50, 100),
('Rescue the Villagers', 30, 100, 200);

INSERT INTO Item (Name, Type, Rarity, Craftable) VALUES 
('Sword of Light', 'Weapon', 'Rare', TRUE),
('Health Potion', 'Consumable', 'Common', TRUE);

INSERT INTO Enemy (Name, Health, Damage, LootDrop) VALUES 
('Goblin', 50, 10, TRUE),
('Orc', 80, 15, TRUE);

INSERT INTO Trader (Name, Type) VALUES 
('Harlan the Merchant', 'General Goods'),
('Mira the Blacksmith', 'Weapons');

INSERT INTO Market (ItemID, SellerID, Price) VALUES 
(1, 1, 500),
(2, 2, 50);

INSERT INTO Guild (Name, LeaderID) VALUES 
('Warriors of Zeta', 1),
('The Shadow Assassins', 2);

INSERT INTO Character_Quest (CharacterID, QuestID) VALUES 
(1, 1),
(2, 2);

INSERT INTO Character_Item (CharacterID, ItemID) VALUES 
(1, 1),
(2, 2);

INSERT INTO Enemy_Item (EnemyID, ItemID) VALUES 
(1, 2),
(2, 1);

INSERT INTO Trader_Item (TraderID, ItemID) VALUES 
(1, 2),
(2, 1);

INSERT INTO Character_Guild (CharacterID, GuildID) VALUES 
(1, 1),
(2, 2);