· 8 years ago · Apr 16, 2018, 12:58 AM
1Index: dist/sql/game/custom/custom_armorsets.sql
2===================================================================
3--- dist/sql/game/custom/custom_armorsets.sql (revision 8559)
4+++ dist/sql/game/custom/custom_armorsets.sql (working copy)
5@@ -1,3 +1,4 @@
6+DROP TABLE IF EXISTS `custom_armorsets`;
7 CREATE TABLE IF NOT EXISTS `custom_armorsets` (
8 `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
9 `chest` smallint(5) unsigned NOT NULL DEFAULT '0',
10Index: dist/sql/game/custom/custom_droplist.sql
11===================================================================
12--- dist/sql/game/custom/custom_droplist.sql (revision 8559)
13+++ dist/sql/game/custom/custom_droplist.sql (working copy)
14@@ -34,6 +34,7 @@
15 -- 0+ is defined catagories
16 -- Any other mobs within this range (minions, etc) use the default drop categories (most often 2)
17
18+DROP TABLE IF EXISTS `custom_droplist`;
19 CREATE TABLE IF NOT EXISTS `custom_droplist` (
20 `mobId` smallint(5) unsigned NOT NULL DEFAULT '0',
21 `itemId` smallint(5) unsigned NOT NULL DEFAULT '0',
22Index: dist/sql/game/custom/custom_merchant_buylists.sql
23===================================================================
24--- dist/sql/game/custom/custom_merchant_buylists.sql (revision 8559)
25+++ dist/sql/game/custom/custom_merchant_buylists.sql (working copy)
26@@ -1,3 +1,4 @@
27+DROP TABLE IF EXISTS `custom_merchant_buylists`;
28 CREATE TABLE IF NOT EXISTS `custom_merchant_buylists` (
29 `item_id` smallint(5) unsigned NOT NULL DEFAULT '0',
30 `price` int(10) NOT NULL DEFAULT '0',
31Index: dist/sql/game/custom/custom_merchant_shopids.sql
32===================================================================
33--- dist/sql/game/custom/custom_merchant_shopids.sql (revision 8559)
34+++ dist/sql/game/custom/custom_merchant_shopids.sql (working copy)
35@@ -1,3 +1,4 @@
36+DROP TABLE IF EXISTS `custom_merchant_shopids`;
37 CREATE TABLE IF NOT EXISTS `custom_merchant_shopids` (
38 `shop_id` mediumint(7) unsigned NOT NULL DEFAULT '0',
39 `npc_id` varchar(5) DEFAULT NULL,
40Index: dist/sql/game/custom/custom_npc.sql
41===================================================================
42--- dist/sql/game/custom/custom_npc.sql (revision 8582)
43+++ dist/sql/game/custom/custom_npc.sql (working copy)
44@@ -1,3 +1,4 @@
45+DROP TABLE IF EXISTS `custom_npc`;
46 CREATE TABLE IF NOT EXISTS `custom_npc`(
47 `id` mediumint(7) unsigned NOT NULL DEFAULT '0',
48 `idTemplate` smallint(5) unsigned NOT NULL DEFAULT '0',
49Index: dist/sql/game/custom/custom_npc_buffer.sql
50===================================================================
51--- dist/sql/game/custom/custom_npc_buffer.sql (revision 8559)
52+++ dist/sql/game/custom/custom_npc_buffer.sql (working copy)
53@@ -1,3 +1,4 @@
54+DROP TABLE IF EXISTS `custom_npc_buffer`;
55 CREATE TABLE IF NOT EXISTS `custom_npc_buffer` (
56 `npc_id` int(6) NOT NULL,
57 `skill_id` int(6) NOT NULL,
58Index: dist/sql/game/custom/custom_npc_elementals.sql
59===================================================================
60--- dist/sql/game/custom/custom_npc_elementals.sql (revision 8559)
61+++ dist/sql/game/custom/custom_npc_elementals.sql (working copy)
62@@ -1,3 +1,4 @@
63+DROP TABLE IF EXISTS `custom_npc_elementals`;
64 CREATE TABLE IF NOT EXISTS `custom_npc_elementals` (
65 `npc_id` decimal(11,0) NOT NULL default '0',
66 `elemAtkType` tinyint(1) NOT NULL default -1,
67Index: dist/sql/game/custom/custom_npcaidata.sql
68===================================================================
69--- dist/sql/game/custom/custom_npcaidata.sql (revision 8582)
70+++ dist/sql/game/custom/custom_npcaidata.sql (working copy)
71@@ -1,3 +1,4 @@
72+DROP TABLE IF EXISTS `custom_npcaidata`;
73 CREATE TABLE IF NOT EXISTS `custom_npcaidata` (
74 `npcId` mediumint(7) unsigned NOT NULL,
75 `minSkillChance` tinyint(3) unsigned NOT NULL DEFAULT '7',
76Index: dist/sql/game/custom/custom_npcskills.sql
77===================================================================
78--- dist/sql/game/custom/custom_npcskills.sql (revision 8559)
79+++ dist/sql/game/custom/custom_npcskills.sql (working copy)
80@@ -1,3 +1,4 @@
81+DROP TABLE IF EXISTS `custom_npcskills`;
82 CREATE TABLE IF NOT EXISTS `custom_npcskills` (
83 `npcid` smallint(5) unsigned NOT NULL DEFAULT '0',
84 `skillid` smallint(5) unsigned NOT NULL DEFAULT '0',
85Index: dist/sql/game/custom/custom_spawnlist.sql
86===================================================================
87--- dist/sql/game/custom/custom_spawnlist.sql (revision 8559)
88+++ dist/sql/game/custom/custom_spawnlist.sql (working copy)
89@@ -1,3 +1,4 @@
90+DROP TABLE IF EXISTS `custom_spawnlist`;
91 CREATE TABLE IF NOT EXISTS `custom_spawnlist` (
92 `location` varchar(40) NOT NULL DEFAULT '',
93 `count` tinyint(1) unsigned NOT NULL DEFAULT '0',
94Index: dist/sql/game/custom/custom_teleport.sql
95===================================================================
96--- dist/sql/game/custom/custom_teleport.sql (revision 8559)
97+++ dist/sql/game/custom/custom_teleport.sql (working copy)
98@@ -1,3 +1,4 @@
99+DROP TABLE IF EXISTS `custom_teleport`;
100 CREATE TABLE IF NOT EXISTS `custom_teleport` (
101 `Description` varchar(75) DEFAULT NULL,
102 `id` mediumint(7) unsigned NOT NULL DEFAULT '0',