Changeset 45 for trunk/sql/realmd.sql

Timestamp:

11/19/08 13:27:52 (17 years ago)

Author:

yumileroy

Message:

[svn] * SQL cleanup
* Removed unneeded revision SQL, since everyone will be starting off at a single revision.
* Left the characters SQL in case someone needs to convert a MaNGOS characters DB
* Final dumps of realmd / world / and characters DB schemas

Original author: runningnak3d
Date: 2008-10-14 12:30:35-05:00

Files:

• trunk/sql/realmd.sql (modified) (8 diffs)

trunk/sql/realmd.sql

@@ -3 +3 @@
 -- Host: localhost    Database: realmd
 -- ------------------------------------------------------
--- Server version       5.0.45-Debian_1ubuntu3.1-log
+-- Server version       5.0.34-log
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@@ -23 +23 @@
 CREATE TABLE `account` (
   `id` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Identifier',
-  `username`      varchar(32) NOT NULL default '',
+  `username` varchar(32) NOT NULL,
   `sha_pass_hash` varchar(40) NOT NULL default '',
   `gmlevel` tinyint(3) unsigned NOT NULL default '0',
@@ -42 +42 @@
   UNIQUE KEY `idx_username` (`username`),
   KEY `idx_gmlevel` (`gmlevel`)
-) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Account System';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';
 
 --
@@ -50 +50 @@
 LOCK TABLES `account` WRITE;
 /*!40000 ALTER TABLE `account` DISABLE KEYS */;
-INSERT INTO `account` VALUES
-(1,'ADMINISTRATOR','a34b29541b87b7e4823683ce6c7bf6ae68beaaac',3,'','0','0','','2006-04-25 10:18:56','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0),
-(2,'GAMEMASTER','7841e21831d7c6bc0b57fbe7151eb82bd65ea1f9',2,'','0','0','','2006-04-25 10:18:56','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0),
-(3,'MODERATOR','a7f5fbff0b4eec2d6b6e78e38e8312e64d700008',1,'','0','0','','2006-04-25 10:19:35','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0),
-(4,'PLAYER','3ce8a96d17c5ae88a30681024e86279f1a38c041',0,'','0','0','','2006-04-25 10:19:35','127.0.0.1',0,0,'0000-00-00 00:00:00',0,0,0,0);
 /*!40000 ALTER TABLE `account` ENABLE KEYS */;
 UNLOCK TABLES;
@@ -89 +84 @@
 CREATE TABLE `ip_banned` (
   `ip` varchar(32) NOT NULL default '127.0.0.1',
-  `bandate` bigint(40) NOT NULL,
-  `unbandate` bigint(40) NOT NULL,
+  `bandate` int(11) NOT NULL,
+  `unbandate` int(11) NOT NULL,
   `bannedby` varchar(50) NOT NULL default '[Console]',
-  `banreason` varchar(255) NOT NULL default 'no reason',
-  PRIMARY KEY  (`ip`,`bandate`)
+  `banreason` varchar(50) NOT NULL default 'no reason',
+  PRIMARY KEY  (`ip`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Banned IPs';
 
@@ -143 +138 @@
   PRIMARY KEY  (`id`),
   UNIQUE KEY `idx_name` (`name`)
-) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System';
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Realm System';
 
 --
@@ -151 +146 @@
 LOCK TABLES `realmlist` WRITE;
 /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
-INSERT INTO `realmlist` VALUES
-(1,'MaNGOS','127.0.0.1',8085,1,0,1,0,0);
 /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
 UNLOCK TABLES;
@@ -165 +158 @@
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2008-01-10 11:37:06
+-- Dump completed on 2008-10-14 13:28:11