Adding SQL scripts

[irc/gameservirc.git] / gameserv-2.0 / sql / level.sql

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