diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 20 | ||||
| -rw-r--r-- | sql/updates/7118_characters_addons.sql | 6 |
2 files changed, 26 insertions, 0 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index cbcc9df3ec9..a7ff0ea9604 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -60,6 +60,26 @@ LOCK TABLES `account_data` WRITE; UNLOCK TABLES; -- +-- Table structure for table `addons` +-- + +DROP TABLE IF EXISTS `addons`; +CREATE TABLE `addons` ( + `name` varchar(120) NOT NULL default '', + `crc` mediumint(32) unsigned NOT NULL default '0', + PRIMARY KEY (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Addons'; + +-- +-- Dumping data for table `addons` +-- + +LOCK TABLES `addons` WRITE; +/*!40000 ALTER TABLE `addons` DISABLE KEYS */; +/*!40000 ALTER TABLE `addons` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `arena_team` -- diff --git a/sql/updates/7118_characters_addons.sql b/sql/updates/7118_characters_addons.sql new file mode 100644 index 00000000000..ba857fda6d8 --- /dev/null +++ b/sql/updates/7118_characters_addons.sql @@ -0,0 +1,6 @@ +DROP TABLE IF EXISTS `addons`; +CREATE TABLE `addons` ( + `name` varchar(120) NOT NULL default '', + `crc` mediumint(32) unsigned NOT NULL default '0', + PRIMARY KEY (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Addons'; |