Adding SQL scripts

git-svn-id: https://svn.code.sf.net/p/gameservirc/code/trunk@546 bc333340-6410-0410-a689-9d09f3c113fa

diff --git a/gameserv-2.0/sql/item.sql b/gameserv-2.0/sql/item.sql
new file mode 100644 (file)
index 0000000..37b5e54
--- /dev/null
+++ b/gameserv-2.0/sql/item.sql
@@ -0,0 +1,26 @@
+DROP TABLE IF EXISTS `gameserv`.`item`;\r
+CREATE TABLE  `gameserv`.`item` (\r
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r
+  `name` varchar(45) NOT NULL,\r
+  `strengthhigh` int(11) NOT NULL DEFAULT '0',\r
+  `strengthlow` int(11) NOT NULL DEFAULT '0',\r
+  `defensehigh` int(11) NOT NULL DEFAULT '0',\r
+  `defenselow` int(11) NOT NULL DEFAULT '0',\r
+  `healthhigh` int(11) NOT NULL DEFAULT '0',\r
+  `healthlow` int(11) NOT NULL DEFAULT '0',\r
+  `goldhigh` int(11) NOT NULL DEFAULT '0',\r
+  `goldlow` int(11) NOT NULL DEFAULT '0',\r
+  `experiencehigh` int(11) NOT NULL DEFAULT '0',\r
+  `experiencelow` int(11) NOT NULL DEFAULT '0',\r
+  `startinguses` int(11) NOT NULL DEFAULT '-1',\r
+  `type` varchar(45) NOT NULL,\r
+  `banklow` int(11) NOT NULL DEFAULT '0',\r
+  `bankhigh` int(11) NOT NULL DEFAULT '0',\r
+  `forestfightshigh` int(11) NOT NULL DEFAULT '0',\r
+  `forestfightslow` int(11) NOT NULL DEFAULT '0',\r
+  `playerfightshigh` int(11) NOT NULL DEFAULT '0',\r
+  `playerfightslow` int(11) NOT NULL DEFAULT '0',\r
+  `maxhealthhigh` int(11) NOT NULL DEFAULT '0',\r
+  `maxhealthlow` int(11) NOT NULL DEFAULT '0',\r
+  PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\ No newline at end of file

diff --git a/gameserv-2.0/sql/level.sql b/gameserv-2.0/sql/level.sql
new file mode 100644 (file)
index 0000000..a484b48
--- /dev/null
+++ b/gameserv-2.0/sql/level.sql
@@ -0,0 +1,15 @@
+DROP TABLE IF EXISTS `gameserv`.`level`;\r
+CREATE TABLE  `gameserv`.`level` (\r
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r
+  `strengthhigh` int(10) NOT NULL DEFAULT '0',\r
+  `strengthlow` int(10) NOT NULL DEFAULT '0',\r
+  `defensehigh` int(10) NOT NULL DEFAULT '0',\r
+  `defenselow` int(10) NOT NULL DEFAULT '0',\r
+  `goldhigh` int(10) NOT NULL DEFAULT '0',\r
+  `goldlow` int(10) NOT NULL DEFAULT '0',\r
+  `experiencehigh` int(10) NOT NULL DEFAULT '0',\r
+  `experiencelow` int(10) NOT NULL DEFAULT '0',\r
+  `healthhigh` int(10) NOT NULL DEFAULT '0',\r
+  `healthlow` int(10) NOT NULL DEFAULT '0',\r
+  PRIMARY KEY (`id`)\r
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\ No newline at end of file

diff --git a/gameserv-2.0/sql/master.sql b/gameserv-2.0/sql/master.sql
new file mode 100644 (file)
index 0000000..c1f7d2e
--- /dev/null
+++ b/gameserv-2.0/sql/master.sql
@@ -0,0 +1,16 @@
+DROP TABLE IF EXISTS `gameserv`.`master`;\r
+CREATE TABLE  `gameserv`.`master` (\r
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r
+  `name` varchar(45) NOT NULL,\r
+  `weaponname` varchar(45) NOT NULL,\r
+  `strength` int(10) NOT NULL,\r
+  `defense` int(10) NOT NULL,\r
+  `gold` int(10) NOT NULL,\r
+  `experience` int(10) NOT NULL,\r
+  `levelId` int(10) unsigned NOT NULL,\r
+  `health` int(10) unsigned NOT NULL,\r
+  `partingwords` varchar(256) NOT NULL,\r
+  PRIMARY KEY (`id`),\r
+  KEY `FK_master_levelId_1` (`levelId`),\r
+  CONSTRAINT `FK_master_levelId_1` FOREIGN KEY (`levelId`) REFERENCES `level` (`id`)\r
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\ No newline at end of file

diff --git a/gameserv-2.0/sql/monster.sql b/gameserv-2.0/sql/monster.sql
new file mode 100644 (file)
index 0000000..c800b90
--- /dev/null
+++ b/gameserv-2.0/sql/monster.sql
@@ -0,0 +1,16 @@
+DROP TABLE IF EXISTS `gameserv`.`monster`;\r
+CREATE TABLE  `gameserv`.`monster` (\r
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r
+  `name` varchar(45) NOT NULL,\r
+  `weaponname` varchar(45) NOT NULL,\r
+  `strength` int(11) NOT NULL DEFAULT '0',\r
+  `defense` int(11) NOT NULL DEFAULT '0',\r
+  `gold` int(11) NOT NULL DEFAULT '0',\r
+  `experience` int(11) NOT NULL DEFAULT '0',\r
+  `health` int(10) unsigned NOT NULL,\r
+  `levelId` int(10) unsigned NOT NULL,\r
+  `deathcry` varchar(256) NOT NULL,\r
+  PRIMARY KEY (`id`),\r
+  KEY `FK_monster_levelId_1` (`levelId`),\r
+  CONSTRAINT `FK_monster_levelId_1` FOREIGN KEY (`levelId`) REFERENCES `level` (`id`)\r
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\ No newline at end of file

diff --git a/gameserv-2.0/sql/player.sql b/gameserv-2.0/sql/player.sql
new file mode 100644 (file)
index 0000000..be3b073
--- /dev/null
+++ b/gameserv-2.0/sql/player.sql
@@ -0,0 +1,27 @@
+DROP TABLE IF EXISTS `gameserv`.`player`;\r
+CREATE TABLE  `gameserv`.`player` (\r
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r
+  `name` varchar(45) NOT NULL,\r
+  `weaponId` int(10) unsigned DEFAULT '0',\r
+  `armorId` int(10) unsigned DEFAULT '0',\r
+  `levelId` int(10) unsigned NOT NULL DEFAULT '1',\r
+  `experience` int(10) unsigned NOT NULL DEFAULT '0',\r
+  `gold` int(10) unsigned NOT NULL DEFAULT '0',\r
+  `bank` int(10) NOT NULL DEFAULT '0',\r
+  `strength` int(10) NOT NULL DEFAULT '1',\r
+  `defense` int(10) NOT NULL DEFAULT '1',\r
+  `health` int(10) unsigned NOT NULL DEFAULT '10',\r
+  `maxhealth` int(10) unsigned NOT NULL DEFAULT '10',\r
+  `forestfights` int(10) unsigned NOT NULL DEFAULT '100',\r
+  `playerfights` int(10) unsigned NOT NULL DEFAULT '3',\r
+  `lastlogin` datetime DEFAULT NULL,\r
+  `alive` tinyint(1) NOT NULL DEFAULT '1',\r
+  `foughtmaster` tinyint(1) NOT NULL DEFAULT '0',\r
+  PRIMARY KEY (`id`),\r
+  KEY `FK_player_weaponId_1` (`weaponId`),\r
+  KEY `FK_player_armorId_2` (`armorId`),\r
+  KEY `FK_player_levelId_3` (`levelId`),\r
+  CONSTRAINT `FK_player_armorId_2` FOREIGN KEY (`armorId`) REFERENCES `item` (`id`),\r
+  CONSTRAINT `FK_player_levelId_3` FOREIGN KEY (`levelId`) REFERENCES `level` (`id`),\r
+  CONSTRAINT `FK_player_weaponId_1` FOREIGN KEY (`weaponId`) REFERENCES `item` (`id`)\r
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\ No newline at end of file

diff --git a/gameserv-2.0/sql/playerinventory.sql b/gameserv-2.0/sql/playerinventory.sql
new file mode 100644 (file)
index 0000000..088f435
--- /dev/null
+++ b/gameserv-2.0/sql/playerinventory.sql
@@ -0,0 +1,10 @@
+DROP TABLE IF EXISTS `gameserv`.`playerinventory`;\r
+CREATE TABLE  `gameserv`.`playerinventory` (\r
+  `playerId` int(10) unsigned NOT NULL,\r
+  `itemId` int(10) unsigned NOT NULL,\r
+  `usesleft` int(10) unsigned NOT NULL,\r
+  KEY `Index_1` (`playerId`,`itemId`),\r
+  KEY `FK_playerinventory_itemId_2` (`itemId`),\r
+  CONSTRAINT `FK_playerinventory_itemId_2` FOREIGN KEY (`itemId`) REFERENCES `item` (`id`),\r
+  CONSTRAINT `FK_playerinventory_playerId_1` FOREIGN KEY (`playerId`) REFERENCES `player` (`id`)\r
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
\ No newline at end of file