RPG Resource 2 AKA RPG Database

Here's a simple RPG Database.

This covers everything from:
Character info
Monster Info
Spells
Special Moves
Class system
Party Formation
Monster Party Formation
and more.
Inspired from RPG Maker Base


Below is a old version of the schema that I'll be upgrading for my class sometime this week.
Schema:

Schema Image: Click image for full view.


Here's the create tables:

CREATE TABLE Arcana(ArcanaID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200));
INSERT INTO "Arcana" VALUES(1,'Fire');
INSERT INTO "Arcana" VALUES(2,'Water');
INSERT INTO "Arcana" VALUES(3,'Thunder');
INSERT INTO "Arcana" VALUES(4,'Earth');
INSERT INTO "Arcana" VALUES(5,'Wind');
INSERT INTO "Arcana" VALUES(6,'Ice');
INSERT INTO "Arcana" VALUES(7,'Light');
INSERT INTO "Arcana" VALUES(8,'Dark');
INSERT INTO "Arcana" VALUES(9,'None');

CREATE TABLE ArmorClass(ArmorID smallint, ClassID smallint);
INSERT INTO "ArmorClass" VALUES(2,1);
INSERT INTO "ArmorClass" VALUES(3,10);


CREATE TABLE ArmorParams(ArmorID smallint, ParamID smallint, ArcanaID smallint,Value smallint);
INSERT INTO "ArmorParams" VALUES(2,1,0,2);
INSERT INTO "ArmorParams" VALUES(2,2,0,'');
INSERT INTO "ArmorParams" VALUES(2,3,0,'');
INSERT INTO "ArmorParams" VALUES(2,4,0,'');
INSERT INTO "ArmorParams" VALUES(2,5,0,1);
INSERT INTO "ArmorParams" VALUES(2,6,0,'');
INSERT INTO "ArmorParams" VALUES(2,7,0,'');
INSERT INTO "ArmorParams" VALUES(2,8,0,'');
INSERT INTO "ArmorParams" VALUES(2,0,1,'');
INSERT INTO "ArmorParams" VALUES(2,0,2,'');
INSERT INTO "ArmorParams" VALUES(2,0,3,'');
INSERT INTO "ArmorParams" VALUES(2,0,4,'');
INSERT INTO "ArmorParams" VALUES(2,0,5,'');
INSERT INTO "ArmorParams" VALUES(2,0,6,'');
INSERT INTO "ArmorParams" VALUES(2,0,7,'');
INSERT INTO "ArmorParams" VALUES(2,0,8,'');
INSERT INTO "ArmorParams" VALUES(3,1,0,1);
INSERT INTO "ArmorParams" VALUES(3,2,0,'');
INSERT INTO "ArmorParams" VALUES(3,3,0,'');
INSERT INTO "ArmorParams" VALUES(3,4,0,'');
INSERT INTO "ArmorParams" VALUES(3,5,0,'');
INSERT INTO "ArmorParams" VALUES(3,6,0,'');
INSERT INTO "ArmorParams" VALUES(3,7,0,2);
INSERT INTO "ArmorParams" VALUES(3,8,0,1);
INSERT INTO "ArmorParams" VALUES(3,0,1,'');
INSERT INTO "ArmorParams" VALUES(3,0,2,'');
INSERT INTO "ArmorParams" VALUES(3,0,3,'');
INSERT INTO "ArmorParams" VALUES(3,0,4,'');
INSERT INTO "ArmorParams" VALUES(3,0,5,'');
INSERT INTO "ArmorParams" VALUES(3,0,6,'');
INSERT INTO "ArmorParams" VALUES(3,0,7,'');
INSERT INTO "ArmorParams" VALUES(3,0,8,'');

CREATE TABLE ArmorTypes(ArmorTypeID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200));
INSERT INTO "ArmorTypes" VALUES(1,'Kouyou');
INSERT INTO "ArmorTypes" VALUES(2,'Suits');
INSERT INTO "ArmorTypes" VALUES(3,'Assessory');
INSERT INTO "ArmorTypes" VALUES(4,'Sub Weapon');

CREATE TABLE Armors(ArmorID INTEGER PRIMARY KEY AUTOINCREMENT, ArmorTypeID smallint, Name varchar(200), Level smallint, Cost smallint, Description varchar(1024), Image varchar(1024), Skin varchar(1024), MaxQuantities smallint);
INSERT INTO "Armors" VALUES(2,1,'Training Guantlets',1,100,'A kouyou given to Tori when he graduated Hunter Acdemy.','data/Images/Icons/A_Armour01.png','data/Armor/Skin/TrainingGuantlets.png',12);
INSERT INTO "Armors" VALUES(3,1,'Training Leg Braces',1,100,'Mikas kouyou given to her after graduating Hunter Academy.','data/Images/Icons/A_Armour01.png','',12);


CREATE TABLE ClassGrades(ClassID smallint, GradeTypeID smallint, GradeID smallint);
INSERT INTO "ClassGrades" VALUES(1,1,2);
INSERT INTO "ClassGrades" VALUES(1,2,2);
INSERT INTO "ClassGrades" VALUES(1,3,6);
INSERT INTO "ClassGrades" VALUES(1,4,6);
INSERT INTO "ClassGrades" VALUES(1,5,2);
INSERT INTO "ClassGrades" VALUES(1,6,6);
INSERT INTO "ClassGrades" VALUES(1,7,4);
INSERT INTO "ClassGrades" VALUES(1,8,2);
INSERT INTO "ClassGrades" VALUES(2,1,1);
INSERT INTO "ClassGrades" VALUES(2,2,3);
INSERT INTO "ClassGrades" VALUES(2,3,6);
INSERT INTO "ClassGrades" VALUES(2,4,4);
INSERT INTO "ClassGrades" VALUES(2,5,3);
INSERT INTO "ClassGrades" VALUES(2,6,6);
INSERT INTO "ClassGrades" VALUES(2,7,3);
INSERT INTO "ClassGrades" VALUES(2,8,2);
INSERT INTO "ClassGrades" VALUES(3,1,1);
INSERT INTO "ClassGrades" VALUES(3,2,3);
INSERT INTO "ClassGrades" VALUES(3,3,6);
INSERT INTO "ClassGrades" VALUES(3,4,3);
INSERT INTO "ClassGrades" VALUES(3,5,3);
INSERT INTO "ClassGrades" VALUES(3,6,6);
INSERT INTO "ClassGrades" VALUES(3,7,2);
INSERT INTO "ClassGrades" VALUES(3,8,2);
INSERT INTO "ClassGrades" VALUES(4,1,1);
INSERT INTO "ClassGrades" VALUES(4,2,4);
INSERT INTO "ClassGrades" VALUES(4,3,6);
INSERT INTO "ClassGrades" VALUES(4,4,3);
INSERT INTO "ClassGrades" VALUES(4,5,4);
INSERT INTO "ClassGrades" VALUES(4,6,6);
INSERT INTO "ClassGrades" VALUES(4,7,1);
INSERT INTO "ClassGrades" VALUES(4,8,3);
INSERT INTO "ClassGrades" VALUES(5,1,4);
INSERT INTO "ClassGrades" VALUES(5,2,3);
INSERT INTO "ClassGrades" VALUES(5,3,3);
INSERT INTO "ClassGrades" VALUES(5,4,2);
INSERT INTO "ClassGrades" VALUES(5,5,4);
INSERT INTO "ClassGrades" VALUES(5,6,2);
INSERT INTO "ClassGrades" VALUES(5,7,1);
INSERT INTO "ClassGrades" VALUES(5,8,3);
INSERT INTO "ClassGrades" VALUES(6,1,5);
INSERT INTO "ClassGrades" VALUES(6,2,4);
INSERT INTO "ClassGrades" VALUES(6,3,1);
INSERT INTO "ClassGrades" VALUES(6,4,1);
INSERT INTO "ClassGrades" VALUES(6,5,3);
INSERT INTO "ClassGrades" VALUES(6,6,1);
INSERT INTO "ClassGrades" VALUES(6,7,5);
INSERT INTO "ClassGrades" VALUES(6,8,3);
INSERT INTO "ClassGrades" VALUES(7,1,4);
INSERT INTO "ClassGrades" VALUES(7,2,4);
INSERT INTO "ClassGrades" VALUES(7,3,1);
INSERT INTO "ClassGrades" VALUES(7,4,3);
INSERT INTO "ClassGrades" VALUES(7,5,3);
INSERT INTO "ClassGrades" VALUES(7,6,1);
INSERT INTO "ClassGrades" VALUES(7,7,2);
INSERT INTO "ClassGrades" VALUES(7,8,3);
INSERT INTO "ClassGrades" VALUES(8,1,3);
INSERT INTO "ClassGrades" VALUES(8,2,3);
INSERT INTO "ClassGrades" VALUES(8,3,2);
INSERT INTO "ClassGrades" VALUES(8,4,3);
INSERT INTO "ClassGrades" VALUES(8,5,3);
INSERT INTO "ClassGrades" VALUES(8,6,3);
INSERT INTO "ClassGrades" VALUES(8,7,1);
INSERT INTO "ClassGrades" VALUES(8,8,1);
INSERT INTO "ClassGrades" VALUES(9,1,1);
INSERT INTO "ClassGrades" VALUES(9,2,2);
INSERT INTO "ClassGrades" VALUES(9,3,4);
INSERT INTO "ClassGrades" VALUES(9,4,3);
INSERT INTO "ClassGrades" VALUES(9,5,2);
INSERT INTO "ClassGrades" VALUES(9,6,3);
INSERT INTO "ClassGrades" VALUES(9,7,6);
INSERT INTO "ClassGrades" VALUES(9,8,3);
INSERT INTO "ClassGrades" VALUES(10,1,3);
INSERT INTO "ClassGrades" VALUES(10,2,2);
INSERT INTO "ClassGrades" VALUES(10,3,6);
INSERT INTO "ClassGrades" VALUES(10,4,3);
INSERT INTO "ClassGrades" VALUES(10,5,2);
INSERT INTO "ClassGrades" VALUES(10,6,6);
INSERT INTO "ClassGrades" VALUES(10,7,1);
INSERT INTO "ClassGrades" VALUES(10,8,1);
INSERT INTO "ClassGrades" VALUES(11,1,2);
INSERT INTO "ClassGrades" VALUES(11,2,2);
INSERT INTO "ClassGrades" VALUES(11,3,1);
INSERT INTO "ClassGrades" VALUES(11,4,1);
INSERT INTO "ClassGrades" VALUES(11,5,2);
INSERT INTO "ClassGrades" VALUES(11,6,1);
INSERT INTO "ClassGrades" VALUES(11,7,3);
INSERT INTO "ClassGrades" VALUES(11,8,1);

CREATE TABLE Classes(ClassID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200), CriticalRate smallint);
INSERT INTO "Classes" VALUES(1,'Iron Fist',5);
INSERT INTO "Classes" VALUES(2,'Richter',4);
INSERT INTO "Classes" VALUES(3,'Heavy Foot',8);
INSERT INTO "Classes" VALUES(4,'Hawk Eye',10);
INSERT INTO "Classes" VALUES(5,'Majestic',10);
INSERT INTO "Classes" VALUES(6,'Divinity',7);
INSERT INTO "Classes" VALUES(7,'Dark Arts',9);
INSERT INTO "Classes" VALUES(8,'Cosmos',3);
INSERT INTO "Classes" VALUES(9,'Ninjetti',2);
INSERT INTO "Classes" VALUES(10,'Mach',8);
INSERT INTO "Classes" VALUES(11,'Soul Merge',10);

CREATE TABLE EquippedArmors(PlayerID smallint, ArmorID smallint, SaveID smallint);

CREATE TABLE EquippedArmorsInit(PlayerID smallint, ArmorID smallint);
INSERT INTO "EquippedArmorsInit" VALUES(3,2);
INSERT INTO "EquippedArmorsInit" VALUES(12,3);

CREATE TABLE EventItems(EventItemID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200));

CREATE TABLE Events(EventID INTEGER PRIMARY KEY AUTOINCREMENT, File varchar(1024), Enable smallint, RequiredEventID smallint, RequiredState smallint);

CREATE TABLE GradeTypes(GradeTypeID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200));
INSERT INTO "GradeTypes" VALUES(1,'Attack');
INSERT INTO "GradeTypes" VALUES(2,'Defence');
INSERT INTO "GradeTypes" VALUES(3,'Magic Attack');
INSERT INTO "GradeTypes" VALUES(4,'Magic Defence');
INSERT INTO "GradeTypes" VALUES(5,'Vitality');
INSERT INTO "GradeTypes" VALUES(6,'Magic');
INSERT INTO "GradeTypes" VALUES(7,'Evasion');
INSERT INTO "GradeTypes" VALUES(8,'Accuracy');

CREATE TABLE Grades(GradeID INTEGER PRIMARY KEY AUTOINCREMENT, GradeLetter varchar(1), GradeMod smallint);
INSERT INTO "Grades" VALUES(1,'A',10);
INSERT INTO "Grades" VALUES(2,'B',8);
INSERT INTO "Grades" VALUES(3,'C',6);
INSERT INTO "Grades" VALUES(4,'D',4);
INSERT INTO "Grades" VALUES(5,'E',2);
INSERT INTO "Grades" VALUES(6,'F',0);

CREATE TABLE HiddenArtClass(HiddenArtID smallint, ClassID smallint);
INSERT INTO "HiddenArtClass" VALUES(2,10);
INSERT INTO "HiddenArtClass" VALUES(1,1);

CREATE TABLE HiddenArts(HiddenArtID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200), StatusID smallint, ParamID smallint, ArcanaID smallint, RangeID smallint, Power mediumint(8), Level smallint, CastUsage smallint, CastTime mediumint(8), Cost smallint, Image varchar(1024), Animation varchar(1024), Description varchar(1024));
INSERT INTO "HiddenArts" VALUES(1,'Soul Charge',1,0,1,6,1000,10,25,10,0,'data/HiddenArts/Image/SoulCharge.png','data/HiddenArts/Animation/SoulCharge','Delivers a charged punch to a single enemy.');
INSERT INTO "HiddenArts" VALUES(2,'Sonic Drop Kick',1,0,5,6,1000,10,25,4,0,'','','Drop kicks the enemy at lighting speed.');

CREATE TABLE Inventory(InventoryID INTEGER PRIMARY KEY AUTOINCREMENT, ItemID mediumint(8) NOT NULL Default(0), ArmorID mediumint(8) NOT NULL Default(0), EventItemID mediumint(8) NOT NULL Default(0), Quantity mediumint(8) NOT NULL Default(0), SaveID smallint NOT NULL Default(0));

CREATE TABLE InventoryInit(InventoryID INTEGER PRIMARY KEY AUTOINCREMENT, ItemID mediumint(8) NOT NULL Default(0), ArmorID mediumint(8) NOT NULL Default(0), EventItemID mediumint(8) NOT NULL Default(0), Quantity mediumint(8) NOT NULL Default(0));
INSERT INTO "InventoryInit" VALUES(1,0,2,0,1);
INSERT INTO "InventoryInit" VALUES(2,0,3,0,1);
INSERT INTO "InventoryInit" VALUES(3,1,0,0,1);
INSERT INTO "InventoryInit" VALUES(4,2,0,0,2);
INSERT INTO "InventoryInit" VALUES(5,3,0,0,2);
INSERT INTO "InventoryInit" VALUES(6,4,0,0,2);
INSERT INTO "InventoryInit" VALUES(7,5,0,0,2);

CREATE TABLE ItemTypes(ItemTypeID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200));
INSERT INTO "ItemTypes" VALUES(1,'HP');
INSERT INTO "ItemTypes" VALUES(2,'MP');
INSERT INTO "ItemTypes" VALUES(3,'KP');
INSERT INTO "ItemTypes" VALUES(4,'Parameters');
INSERT INTO "ItemTypes" VALUES(5,'HPMP');
INSERT INTO "ItemTypes" VALUES(6,'HPMPKP');
INSERT INTO "ItemTypes" VALUES(7,'Life');
INSERT INTO "ItemTypes" VALUES(8,'Dammage');
INSERT INTO "ItemTypes" VALUES(9,'StatusClear');
INSERT INTO "ItemTypes" VALUES(10,'StatusInvoke');

CREATE TABLE Items(ItemID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200),ItemTypeID smallint, Variance smallint, Potency smallint, ArcanaID smallint, StatusID smallint, ParamID smallint, RangeID smallint, Cost smallint, Description varchar(1024), Image varchar(1024), Animation varchar(1024), OutPartyUse smallint, InPartyUse smallint, MaxQuantity smallint, CastTime mediumint(8));
INSERT INTO "Items" VALUES(1,'Hunter Ration',1,100,1,0,0,0,4,25,'Restores 100HP to one party member.','data/Images/Icons/I_C_Egg.png','data/Animations/Healing/LowCure1.png',1,1,99,1000);
INSERT INTO "Items" VALUES(2,'Military Tact',1,300,1,0,0,0,4,75,'Restores 300HP to one party member.','data/Images/Icons/I_C_Bread.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(3,'Protien Shake',2,50,1,0,0,0,4,10,'A healthy drink that replenishes 50MP.','data/Images/Icons/P_Red2.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(4,'Sparkling Rasberry',2,150,1,0,0,0,4,125,'A shinny rasberry that replinishes 150MP.','data/Images/Icons/I_C_Mulberry.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(5,'Ethonoil',3,10,1,0,0,0,1,100,'Restores 10 KP to the user.','data/Images/Icons/P_White01.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(6,'Smoke Salmon',1,700,1,0,0,0,4,200,'Restores 700 HP to a single player.','data/Images/Icons/I_C_Fish.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(7,'Steak Dinner',1,1000,1,0,0,0,4,250,'Restores 1000 HP to a single party member.','data/Images/Icons/I_C_Meat.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(8,'Poo-Poo Plater',1,500,1,0,0,0,5,500,'Restores 500 HP to the entire party.','data/Images/Icons/I_C_RawMeat.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(9,'Creme Brulee',1,3000,1,0,0,0,4,500,'Restores 3000 HP to a single player.','data/Images/Icons/I_C_RawMeat.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(10,'Feast of the Kings',1,5000,1,0,0,0,4,1500,'Restores 5000 HP to a single player.','data/Images/Icons/I_C_RawMeat.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(11,'Last Meal',1,5000,1,0,0,0,5,3000,'Heals 5000 HP to the entire party.','data/Images/Icons/I_C_RawMeat.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(12,'La Fiesta',1,1000,1,0,0,0,5,1000,'Restores 1000 HP to the entire party.','data/Images/Icons/I_C_RawMeat.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(13,'Energy Drink',2,200,1,0,0,0,4,120,'Restores 200 MP to a party member.','data/Images/Icons/P_Yellow02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(14,'Adrenaline Drink',2,500,1,0,0,0,4,300,'Restores 500 MP to a single player.','data/Images/Icons/P_Yellow01.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(15,'Soldier Drink',2,1000,1,0,0,0,4,600,'Restores 1000 MP to a single player.','data/Images/Icons/P_Blue02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(16,'Spiritual Drink',2,3000,1,0,0,0,4,1000,'Restores 3000 MP to a single player.','data/Images/Icons/P_Blue01.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(17,'Goddess Tear',2,5000,1,0,0,0,4,3000,'Restores 5000 MP to a single player.','data/Images/Icons/P_White01.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(18,'Nitro',3,30,1,0,0,0,1,300,'Restores 30 KP to the user.','data/Images/Icons/P_Pink02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(19,'Nova Charge',3,50,1,0,0,0,1,500,'Restores 50 KP to the user.','data/Images/Icons/P_Pink01.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(20,'Plasma',3,100,1,0,0,0,1,1500,'Restores 100 KP to the user.','data/Images/Icons/P_Yellow01.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(21,'Attack Up',4,1,1,0,11,1,1,200,'Increases Attack Power','data/Images/Icons/W_Sword001.png','',0,1,99,1000);
INSERT INTO "Items" VALUES(22,'Defense Up',4,1,1,0,12,2,1,200,'Increases defense.','data/Images/Icons/E_Metal01.png','',0,1,99,1000);
INSERT INTO "Items" VALUES(23,'Magic Attack Up',4,1,1,0,11,3,1,200,'Increases Magic Attack.','data/Images/Icons/W_Book002.png','',0,1,99,1000);
INSERT INTO "Items" VALUES(24,'Magic Defense Up',4,1,1,0,12,4,1,200,'Increase Magic Defense.','data/Images/Icons/W_Book004.png','',0,1,99,1000);
INSERT INTO "Items" VALUES(25,'Accuracy Up',4,1,1,0,14,8,1,200,'Increases Accuracy.','data/Images/Icons/W_Dagger007.png','',0,1,99,1000);
INSERT INTO "Items" VALUES(26,'Evasion Up',4,1,1,0,13,7,1,200,'Increases Evasion.','data/Images/Icons/S_Wind02.png','',0,1,99,1000);
INSERT INTO "Items" VALUES(27,'Angel Feather',7,1,20,0,0,0,4,200,'Revives one fallen character and restores 20% HP and MP.','data/Images/Icons/S_Holy02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(28,'Angel Tear',7,1,40,0,0,0,4,400,'Revives one fallen character and restores 40% HP and MP.','data/Images/Icons/S_Holy02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(29,'Angel Breath',7,1,60,0,0,0,4,600,'Revives one fallen character and restores 60% HP and MP.','data/Images/Icons/S_Holy02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(30,'Angel Sacrifice',7,1,100,0,0,0,4,1500,'Revives one fallen character and restores 100% HP and MP.','data/Images/Icons/S_Holy02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(31,'Shift Gears',4,1,1,0,10,0,4,500,'Increases speedone party member.','data/Images/Icons/S_Light01.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(32,'Remedy',9,1,1,0,15,0,4,150,'Removes Poison.','data/Images/Icons/P_Green02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(33,'Eye Wipes',9,1,1,0,16,0,4,150,'Removes Blind.','data/Images/Icons/I_Mirror.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(34,'Message Oil',9,1,1,0,17,0,4,150,'Removes Paralyse.','data/Images/Icons/I_Ink.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(35,'Firm back hand',9,1,1,0,18,0,4,150,'Removes confusion.','data/Images/Icons/S_Earth02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(36,'Cold water',9,1,1,0,19,0,4,150,'Removes sleep.','data/Images/Icons/S_Water02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(37,'Castor Oil',10,1,1,0,21,0,1,150,'Removes delay.','data/Images/Icons/I_Ink.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(38,'Molasses',8,1,1,0,9,0,6,300,'Inflicts Delay to an enemy.','data/Images/Icons/I_Ink.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(39,'Flim-flam',10,1,1,0,5,0,6,300,'Inflicts Confusion to an enemy.','data/Images/Icons/Ac_Gloves02.png','',1,1,99,1000);
INSERT INTO "Items" VALUES(40,'Corrode',10,1,1,0,2,0,6,300,'Inflict poison to an enemy.','data/Images/Icons/I_Coal.png','',1,1,99,1000);

CREATE TABLE MonsterGrades(MonsterID smallint, GradeTypeID smallint, GradeID smallint);
INSERT INTO "MonsterGrades" VALUES(1,1,2);
INSERT INTO "MonsterGrades" VALUES(1,2,3);
INSERT INTO "MonsterGrades" VALUES(1,3,5);
INSERT INTO "MonsterGrades" VALUES(1,4,2);
INSERT INTO "MonsterGrades" VALUES(1,5,3);
INSERT INTO "MonsterGrades" VALUES(1,6,5);
INSERT INTO "MonsterGrades" VALUES(1,7,2);
INSERT INTO "MonsterGrades" VALUES(1,8,3);


CREATE TABLE MonsterParty(MonsterPartyID INTEGER PRIMARY KEY AUTOINCREMENT, Monster1ID smallint, Monster2ID smallint, Monster3ID smallint, Monster4ID smallint,Monster5ID smallint, Monster6ID smallint, Monster7ID smallint, Name varchar(255), EncounterRate smallint, MapID smallint);
INSERT INTO "MonsterParty" VALUES(1,0,1,0,1,0,0,1,'First Bat Attack',30,0);
INSERT INTO "MonsterParty" VALUES(2,1,1,1,1,1,1,1,'Full Bats',20,0);


CREATE TABLE Monsters(MonsterID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(1024), Level smallint, ItemDropID smallint, Money smallint, Exp smallint, CriticalRate smallint, DropRate smallint, DataBlock varchar(255));
INSERT INTO "Monsters" VALUES(1,'Tiny Bat',2,1,5,25,2,25, 'TinyBatData');

CREATE TABLE Parameters(ParamID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(1024));
INSERT INTO "Parameters" VALUES(1,'Attack');
INSERT INTO "Parameters" VALUES(2,'Defense');
INSERT INTO "Parameters" VALUES(3,'Magic Attack');
INSERT INTO "Parameters" VALUES(4,'Magic Defense');
INSERT INTO "Parameters" VALUES(5,'Vitality');
INSERT INTO "Parameters" VALUES(6,'Magic');
INSERT INTO "Parameters" VALUES(7,'Evasion');
INSERT INTO "Parameters" VALUES(8,'Accuracy');

CREATE TABLE Party(PartyID INTEGER PRIMARY KEY AUTOINCREMENT, PlayerID smallint, Position smallint, StatusID smallint, Inbattle smallint, SaveID smallint);

CREATE TABLE PartyInit(PartyID INTEGER PRIMARY KEY AUTOINCREMENT, PlayerID smallint, Position smallint, StatusID smallint, Inbattle smallint);
INSERT INTO "PartyInit" VALUES(4,3,1,0,1);
INSERT INTO "PartyInit" VALUES(5,12,2,63,1);

CREATE TABLE PlayerParams(PlayerParamID INTEGER PRIMARY KEY AUTOINCREMENT, PlayerID smallint, ParamID smallint, Value smallint);
INSERT INTO "PlayerParams" VALUES(9,3,1,8);
INSERT INTO "PlayerParams" VALUES(10,3,2,7);
INSERT INTO "PlayerParams" VALUES(11,3,3,0);
INSERT INTO "PlayerParams" VALUES(12,3,4,3);
INSERT INTO "PlayerParams" VALUES(13,3,5,8);
INSERT INTO "PlayerParams" VALUES(14,3,6,0);
INSERT INTO "PlayerParams" VALUES(15,3,7,3);
INSERT INTO "PlayerParams" VALUES(16,3,8,7);
INSERT INTO "PlayerParams" VALUES(17,4,1,7);
INSERT INTO "PlayerParams" VALUES(18,4,2,5);
INSERT INTO "PlayerParams" VALUES(19,4,3,0);
INSERT INTO "PlayerParams" VALUES(20,4,4,4);
INSERT INTO "PlayerParams" VALUES(21,4,5,7);
INSERT INTO "PlayerParams" VALUES(22,4,6,0);
INSERT INTO "PlayerParams" VALUES(23,4,7,3);
INSERT INTO "PlayerParams" VALUES(24,4,8,6);
INSERT INTO "PlayerParams" VALUES(25,5,1,6);
INSERT INTO "PlayerParams" VALUES(26,5,2,5);
INSERT INTO "PlayerParams" VALUES(27,5,3,0);
INSERT INTO "PlayerParams" VALUES(28,5,4,4);
INSERT INTO "PlayerParams" VALUES(29,5,5,5);
INSERT INTO "PlayerParams" VALUES(30,5,6,0);
INSERT INTO "PlayerParams" VALUES(31,5,7,7);
INSERT INTO "PlayerParams" VALUES(32,5,8,7);
INSERT INTO "PlayerParams" VALUES(33,6,1,5);
INSERT INTO "PlayerParams" VALUES(34,6,2,4);
INSERT INTO "PlayerParams" VALUES(35,6,3,0);
INSERT INTO "PlayerParams" VALUES(36,6,4,4);
INSERT INTO "PlayerParams" VALUES(37,6,5,6);
INSERT INTO "PlayerParams" VALUES(38,6,6,0);
INSERT INTO "PlayerParams" VALUES(39,6,7,6);
INSERT INTO "PlayerParams" VALUES(40,6,8,10);
INSERT INTO "PlayerParams" VALUES(41,7,1,2);
INSERT INTO "PlayerParams" VALUES(42,7,2,4);
INSERT INTO "PlayerParams" VALUES(43,7,3,6);
INSERT INTO "PlayerParams" VALUES(44,7,4,7);
INSERT INTO "PlayerParams" VALUES(45,7,5,4);
INSERT INTO "PlayerParams" VALUES(46,7,6,6);
INSERT INTO "PlayerParams" VALUES(47,7,7,6);
INSERT INTO "PlayerParams" VALUES(48,7,8,4);
INSERT INTO "PlayerParams" VALUES(49,8,1,3);
INSERT INTO "PlayerParams" VALUES(50,8,2,7);
INSERT INTO "PlayerParams" VALUES(51,8,3,14);
INSERT INTO "PlayerParams" VALUES(52,8,4,16);
INSERT INTO "PlayerParams" VALUES(53,8,5,7);
INSERT INTO "PlayerParams" VALUES(54,8,6,15);
INSERT INTO "PlayerParams" VALUES(55,8,7,13);
INSERT INTO "PlayerParams" VALUES(56,8,8,7);
INSERT INTO "PlayerParams" VALUES(57,9,1,1);
INSERT INTO "PlayerParams" VALUES(58,9,2,3);
INSERT INTO "PlayerParams" VALUES(59,9,3,8);
INSERT INTO "PlayerParams" VALUES(60,9,4,9);
INSERT INTO "PlayerParams" VALUES(61,9,5,3);
INSERT INTO "PlayerParams" VALUES(62,9,6,9);
INSERT INTO "PlayerParams" VALUES(63,9,7,7);
INSERT INTO "PlayerParams" VALUES(64,9,8,3);
INSERT INTO "PlayerParams" VALUES(65,10,1,3);
INSERT INTO "PlayerParams" VALUES(66,10,2,3);
INSERT INTO "PlayerParams" VALUES(67,10,3,7);
INSERT INTO "PlayerParams" VALUES(68,10,4,8);
INSERT INTO "PlayerParams" VALUES(69,10,5,5);
INSERT INTO "PlayerParams" VALUES(70,10,6,8);
INSERT INTO "PlayerParams" VALUES(71,10,7,6);
INSERT INTO "PlayerParams" VALUES(72,10,8,4);
INSERT INTO "PlayerParams" VALUES(73,11,1,6);
INSERT INTO "PlayerParams" VALUES(74,11,2,8);
INSERT INTO "PlayerParams" VALUES(75,11,3,0);
INSERT INTO "PlayerParams" VALUES(76,11,4,3);
INSERT INTO "PlayerParams" VALUES(77,11,5,10);
INSERT INTO "PlayerParams" VALUES(78,11,6,0);
INSERT INTO "PlayerParams" VALUES(79,11,7,5);
INSERT INTO "PlayerParams" VALUES(80,11,8,6);
INSERT INTO "PlayerParams" VALUES(81,12,1,5);
INSERT INTO "PlayerParams" VALUES(82,12,2,5);
INSERT INTO "PlayerParams" VALUES(83,12,3,0);
INSERT INTO "PlayerParams" VALUES(84,12,4,5);
INSERT INTO "PlayerParams" VALUES(85,12,5,4);
INSERT INTO "PlayerParams" VALUES(86,12,6,0);
INSERT INTO "PlayerParams" VALUES(87,12,7,10);
INSERT INTO "PlayerParams" VALUES(88,12,8,10);
INSERT INTO "PlayerParams" VALUES(89,13,1,5);
INSERT INTO "PlayerParams" VALUES(90,13,2,5);
INSERT INTO "PlayerParams" VALUES(91,13,3,11);
INSERT INTO "PlayerParams" VALUES(92,13,4,12);
INSERT INTO "PlayerParams" VALUES(93,13,5,8);
INSERT INTO "PlayerParams" VALUES(94,13,6,12);
INSERT INTO "PlayerParams" VALUES(95,13,7,9);
INSERT INTO "PlayerParams" VALUES(96,13,8,6);

CREATE TABLE PlayersInit(PlayerID INTEGER PRIMARY KEY AUTOINCREMENT , Name varchar(1024), RaceID smallint, ClassID smallint, Biography varchar(1024), Level mediumint(8), DataBlock varchar(255));
INSERT INTO "PlayersInit" VALUES(3,'Tori Miyazaki',2,1,'A young boy raised as a hunter depise the tormiole of his past. He knows the life of a hunter more than anyone, the good, bad, and profitable.',1,'ToriData');
INSERT INTO "PlayersInit" VALUES(4,'Aldine Hass',1,2,'First Lieutenant of the Bio-Human Military her skills learned in the military makes her perfected Kouyou skills profound.',1,'AldineData');
INSERT INTO "PlayersInit" VALUES(5,'Clare Skye',2,3,'A girl with the amitious dream of becoming a hunter just like her brother Timithoy though she maybe young her ambitions lead her to discover her hidden abilities young. ',1, 'ClareData');
INSERT INTO "PlayersInit" VALUES(6,'Molly Magami',2,4,'This firsty girl seeks something every girl seeks, to be the shinning star in her fathers eye, because of that she battles day in and day out in the battle arena of Tray seeking the true feeling of glory her father never gave. ',1, 'MollyData');
INSERT INTO "PlayersInit" VALUES(7,'Judgment',3,5,'A mysterious girl in contact with Tori via dreams. Nothing is known about her only that the military is in dire need of her. ',1, 'JudgmentData');
INSERT INTO "PlayersInit" VALUES(8,'Serenity',3,6,'Judgments final form. A greate power of the past, a weapon on man-kind, this weapon now a saviour. ',1, 'SerenityData');
INSERT INTO "PlayersInit" VALUES(9,'Benediction',3,7,'A manifistation of judgments other persona, though she is  the spawn of such an angelic like being she is the exact opposite with her evil, and short tempered nature. ',1, 'BenedictionData');
INSERT INTO "PlayersInit" VALUES(10,'Jasmine Tea',1,8,'Heir to the amphibian empire, this princess being sheltered and protected all her life, begs for the feel of life and adventer. But being so younge she has mastered a forbiden art to allow her power to multiply in great masses, even if for a short time.',1, 'JasmineData');
INSERT INTO "PlayersInit" VALUES(11,'Jebs Dai',1,9,'Imperial guard whos sole duty is to protect Jasmine from harm, though his exterior is hard and distant, his protective instinct shows the dept of his heart.',1, 'JebsData');
INSERT INTO "PlayersInit" VALUES(12,'Mika Magami',2,10,'A girl with the gusto to be great, but her first goal is to be seen as a equal to her childhood friend Tori, though she is clumbsy she strives for greatness and riches, and maybe something else if things go her way.',1, 'MikaData');
INSERT INTO "PlayersInit" VALUES(13,'Jasmine Powered',1,11,'Jasmines soul merge form. ',1, 'JasminePData');

CREATE TABLE Players(PlayerID INTEGER PRIMARY KEY AUTOINCREMENT , Name varchar(1024), RaceID smallint, ClassID smallint, Biography varchar(1024), Level mediumint(8), DataBlock varchar(255), SaveID smallint);

CREATE TABLE Races(RaceID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200));

INSERT INTO "Races" VALUES(1,'Amphibian');
INSERT INTO "Races" VALUES(2,'Bio-Human');
INSERT INTO "Races" VALUES(3,'Unknown');

CREATE TABLE Ranges(RangeID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200));
INSERT INTO "Ranges" VALUES(1,'Me');
INSERT INTO "Ranges" VALUES(2,'PartyDeadOne');
INSERT INTO "Ranges" VALUES(3,'PartyDeadAll');
INSERT INTO "Ranges" VALUES(4,'PartyOne');
INSERT INTO "Ranges" VALUES(5,'PartyAll');
INSERT INTO "Ranges" VALUES(6,'EnemyOne');
INSERT INTO "Ranges" VALUES(7,'EnemyAll');

CREATE TABLE SaveSlots(SaveID INTEGER PRIMARY KEY AUTOINCREMENT, MapID smallint, Money smallint, PlayTime smallint, Date date, SavePoint varchar(1024));

CREATE TABLE SpellClass(SpellID smallint, ClassID smallint);
INSERT INTO "SpellClass" VALUES(1,5);

CREATE TABLE Spells(SpellID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(200), StatusID smallint, ParamID smallint, ArcanaID smallint, RangeID smallint, Power mediumint(8), Level smallint, CastUsage smallint, CastTime mediumint(8), Cost smallint, Image varchar(1024), Animation varchar(1024), Description varchar(1024));
INSERT INTO "Spells" VALUES(1,'Moon Light',2,0,7,4,100,1,12,2,0,'data/Spells/Images/MoonLight.png','data/Spells/Animation/MoonLight','Heavenly light replenishes the targets HP.');

CREATE TABLE Maps(MapID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(1024), Environment varchar(1024), Music varchar(1024), MapFile varchar(1024));

CREATE TABLE Statuses(StatusID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(1024));
INSERT INTO "Statuses" VALUES(1,'Dammage');
INSERT INTO "Statuses" VALUES(2,'Poison');
INSERT INTO "Statuses" VALUES(3,'Blind');
INSERT INTO "Statuses" VALUES(4,'Paralyse');
INSERT INTO "Statuses" VALUES(5,'Confusion');
INSERT INTO "Statuses" VALUES(6,'Sleep');
INSERT INTO "Statuses" VALUES(7,'Silence');
INSERT INTO "Statuses" VALUES(8,'Death');
INSERT INTO "Statuses" VALUES(9,'Delay');
INSERT INTO "Statuses" VALUES(10,'Speed');
INSERT INTO "Statuses" VALUES(11,'AttackBonus');
INSERT INTO "Statuses" VALUES(12,'DefenceBonus');
INSERT INTO "Statuses" VALUES(13,'EvasionBonus');
INSERT INTO "Statuses" VALUES(14,'AccuracyBonus');
INSERT INTO "Statuses" VALUES(15,'NullPoison');
INSERT INTO "Statuses" VALUES(16,'NullBlind');
INSERT INTO "Statuses" VALUES(17,'NullParalyse');
INSERT INTO "Statuses" VALUES(18,'NullConfusion');
INSERT INTO "Statuses" VALUES(19,'NullSleep');
INSERT INTO "Statuses" VALUES(20,'NullSilence');
INSERT INTO "Statuses" VALUES(21,'NullDelay');

NOTE: you can copy this whole thing and paste it into the sqlite window after opening a database.

IE:
sqlite>


Added Note: No I did not manually type this whole create statement... Well some I did the rest came from my next resource.


Back To Blog:
RPG_Blog AKA New Resources