Changeset 371

Timestamp:

06/14/09 08:49:31 (11 years ago)

Author:

kovell

Message:

installation xml files corrected.

Location:

dev/packages/database

Files:

• contents.xml (modified) (1 diff)
• kb3_alliances/table.xml (modified) (1 diff)
• kb3_api_cache/table.xml (modified) (1 diff)
• kb3_inv_detail/table.xml (modified) (1 diff)
• kb3_kills/table.xml (modified) (2 diffs)
• kb3_pilots/table.xml (modified) (1 diff)

dev/packages/database/contents.xml

@@ -6 +6 @@
   </table>
   <table>
-    <name>kb3_api_log</name>
+    <name>kb3_apilog</name>
     <version>1.1</version>
   </table>

dev/packages/database/kb3_alliances/table.xml

@@ -6 +6 @@
   `all_id` int(11) NOT NULL auto_increment,
   `all_name` char(64) NOT NULL default '',
-  `all_external_id` int(11) unsigned default NULL;,
+  `all_external_id` int(11) unsigned default NULL,
   PRIMARY KEY  (`all_id`),
   KEY `all_name` (`all_name`)

dev/packages/database/kb3_api_cache/table.xml

@@ -7 +7 @@
                          `cfg_key` varchar(32) NOT NULL default '',
                          `cfg_value` text NOT NULL,
-                         PRIMARY KEY  (`cfg_site`,`cfg_key`) ENGINE = InnoDB  DEFAULT CHARSET=utf8;</structure>
+                         PRIMARY KEY  (`cfg_site`,`cfg_key`))
+                         ENGINE = InnoDB  DEFAULT CHARSET=utf8;</structure>
 </kb3>
  

dev/packages/database/kb3_inv_detail/table.xml

@@ -4 +4 @@
   <rows>0</rows>
   <structure>CREATE TABLE `kb3_inv_detail` (
-  `ind_kll_id` int(6) NOT NULL default &#039;0&#039;,
-  `ind_plt_id` int(6) NOT NULL default &#039;0&#039;,
+  `ind_kll_id` int(6) NOT NULL default 0,
+  `ind_plt_id` int(6) NOT NULL default 0,
   `ind_sec_status` char(15) default NULL,
-  `ind_all_id` int(3) NOT NULL default &#039;0&#039;,
-  `ind_crp_id` int(5) NOT NULL default &#039;0&#039;,
-  `ind_shp_id` int(3) NOT NULL default &#039;0&#039;,
-  `ind_wep_id` int(5) NOT NULL default &#039;0&#039;,
-  `ind_order` int(2) NOT NULL default &#039;0&#039;,
+  `ind_all_id` int(3) NOT NULL default 0,
+  `ind_crp_id` int(5) NOT NULL default 0,
+  `ind_shp_id` int(3) NOT NULL default 0,
+  `ind_wep_id` int(5) NOT NULL default 0,
+  `ind_order` int(2) NOT NULL default 0,
   `ind_dmgdone` int(11) NOT NULL,
   PRIMARY KEY (`ind_kll_id`, `ind_order`),
   KEY `ind_shp_id` (`ind_shp_id`),
-  KEY `ind_plt_id` (`ind_plt_id`)
-  KEY `ind_crp_id` (`ind_crp_id`)
+  KEY `ind_plt_id` (`ind_plt_id`),
+  KEY `ind_crp_id` (`ind_crp_id`),
   KEY `ind_all_id` (`ind_all_id`)
 ) Type=InnoDB  DEFAULT CHARSET=utf8;</structure>

dev/packages/database/kb3_kills/table.xml

@@ -5 +5 @@
   <structure>CREATE TABLE `kb3_kills` (
   `kll_id` int(11) NOT NULL auto_increment,
-  `kll_timestamp` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;,
-  `kll_victim_id` int(6) NOT NULL default &#039;0&#039;,
-  `kll_all_id` int(3) NOT NULL default &#039;0&#039;,
-  `kll_crp_id` int(6) NOT NULL default &#039;0&#039;,
-  `kll_ship_id` int(3) NOT NULL default &#039;0&#039;,
-  `kll_system_id` int(4) NOT NULL default &#039;0&#039;,
+  `kll_timestamp` datetime NOT NULL default "0000-00-00 00:00:00",
+  `kll_victim_id` int(6) NOT NULL default 0,
+  `kll_all_id` int(3) NOT NULL default 0,
+  `kll_crp_id` int(6) NOT NULL default 0,
+  `kll_ship_id` int(3) NOT NULL default 0,
+  `kll_system_id` int(4) NOT NULL default 0,
   `kll_fb_all_id` int(3) default NULL,
-  `kll_points` int(11) NOT NULL default &#039;0&#039;,
+  `kll_points` int(11) NOT NULL default 0,
   `kll_external_id` int(3) default NULL,
   `kll_isk_loss` float NOT NULL default 0,
-  `kll_dmgtaken` int(11) NOT NULL default &#039;0&#039;,
+  `kll_dmgtaken` int(11) NOT NULL default 0,
   PRIMARY KEY  (`kll_timestamp`,`kll_id`),
   UNIQUE KEY `kll_id` (`kll_id`),
@@ -24 +24 @@
   KEY `kll_system_id` (`kll_system_id`),
   KEY `kll_fb_all_id` (`kll_fb_all_id`),
-  UNIQUE KEY `kll_external_id` (`kll_external_id`),
+  UNIQUE KEY `kll_external_id` (`kll_external_id`)
 ) Type=InnoDB  DEFAULT CHARSET=utf8;</structure>
 </kb3>

dev/packages/database/kb3_pilots/table.xml

@@ -7 +7 @@
   `plt_name` char(64) NOT NULL,
   `plt_crp_id` int(11) NOT NULL default '0',
-  `plt_external_id` int(11) default NULL,
+  `plt_externalid` int(11) default NULL,
   `plt_updated` datetime default NULL,
   PRIMARY KEY  (`plt_id`),