Changeset 371

Show
Ignore:
Timestamp:
06/14/09 08:49:31 (11 years ago)
Author:
kovell
Message:

installation xml files corrected.

Location:
dev/packages/database
Files:
6 modified

Legend:

Unmodified
Added
Removed
  • dev/packages/database/contents.xml

    r370 r371  
    66  </table> 
    77  <table> 
    8     <name>kb3_api_log</name> 
     8    <name>kb3_apilog</name> 
    99    <version>1.1</version> 
    1010  </table> 
  • dev/packages/database/kb3_alliances/table.xml

    r370 r371  
    66  `all_id` int(11) NOT NULL auto_increment, 
    77  `all_name` char(64) NOT NULL default &#039;&#039;, 
    8   `all_external_id` int(11) unsigned default NULL;, 
     8  `all_external_id` int(11) unsigned default NULL, 
    99  PRIMARY KEY  (`all_id`), 
    1010  KEY `all_name` (`all_name`) 
  • dev/packages/database/kb3_api_cache/table.xml

    r370 r371  
    77                         `cfg_key` varchar(32) NOT NULL default '', 
    88                         `cfg_value` text NOT NULL, 
    9                          PRIMARY KEY  (`cfg_site`,`cfg_key`) ENGINE = InnoDB  DEFAULT CHARSET=utf8;</structure> 
     9                         PRIMARY KEY  (`cfg_site`,`cfg_key`)) 
     10                         ENGINE = InnoDB  DEFAULT CHARSET=utf8;</structure> 
    1011</kb3> 
    1112  
  • dev/packages/database/kb3_inv_detail/table.xml

    r370 r371  
    44  <rows>0</rows> 
    55  <structure>CREATE TABLE `kb3_inv_detail` ( 
    6   `ind_kll_id` int(6) NOT NULL default &#039;0&#039;, 
    7   `ind_plt_id` int(6) NOT NULL default &#039;0&#039;, 
     6  `ind_kll_id` int(6) NOT NULL default 0, 
     7  `ind_plt_id` int(6) NOT NULL default 0, 
    88  `ind_sec_status` char(15) default NULL, 
    9   `ind_all_id` int(3) NOT NULL default &#039;0&#039;, 
    10   `ind_crp_id` int(5) NOT NULL default &#039;0&#039;, 
    11   `ind_shp_id` int(3) NOT NULL default &#039;0&#039;, 
    12   `ind_wep_id` int(5) NOT NULL default &#039;0&#039;, 
    13   `ind_order` int(2) NOT NULL default &#039;0&#039;, 
     9  `ind_all_id` int(3) NOT NULL default 0, 
     10  `ind_crp_id` int(5) NOT NULL default 0, 
     11  `ind_shp_id` int(3) NOT NULL default 0, 
     12  `ind_wep_id` int(5) NOT NULL default 0, 
     13  `ind_order` int(2) NOT NULL default 0, 
    1414  `ind_dmgdone` int(11) NOT NULL, 
    1515  PRIMARY KEY (`ind_kll_id`, `ind_order`), 
    1616  KEY `ind_shp_id` (`ind_shp_id`), 
    17   KEY `ind_plt_id` (`ind_plt_id`) 
    18   KEY `ind_crp_id` (`ind_crp_id`) 
     17  KEY `ind_plt_id` (`ind_plt_id`), 
     18  KEY `ind_crp_id` (`ind_crp_id`), 
    1919  KEY `ind_all_id` (`ind_all_id`) 
    2020) Type=InnoDB  DEFAULT CHARSET=utf8;</structure> 
  • dev/packages/database/kb3_kills/table.xml

    r370 r371  
    55  <structure>CREATE TABLE `kb3_kills` ( 
    66  `kll_id` int(11) NOT NULL auto_increment, 
    7   `kll_timestamp` datetime NOT NULL default &#039;0000-00-00 00:00:00&#039;, 
    8   `kll_victim_id` int(6) NOT NULL default &#039;0&#039;, 
    9   `kll_all_id` int(3) NOT NULL default &#039;0&#039;, 
    10   `kll_crp_id` int(6) NOT NULL default &#039;0&#039;, 
    11   `kll_ship_id` int(3) NOT NULL default &#039;0&#039;, 
    12   `kll_system_id` int(4) NOT NULL default &#039;0&#039;, 
     7  `kll_timestamp` datetime NOT NULL default "0000-00-00 00:00:00", 
     8  `kll_victim_id` int(6) NOT NULL default 0, 
     9  `kll_all_id` int(3) NOT NULL default 0, 
     10  `kll_crp_id` int(6) NOT NULL default 0, 
     11  `kll_ship_id` int(3) NOT NULL default 0, 
     12  `kll_system_id` int(4) NOT NULL default 0, 
    1313  `kll_fb_all_id` int(3) default NULL, 
    14   `kll_points` int(11) NOT NULL default &#039;0&#039;, 
     14  `kll_points` int(11) NOT NULL default 0, 
    1515  `kll_external_id` int(3) default NULL, 
    1616  `kll_isk_loss` float NOT NULL default 0, 
    17   `kll_dmgtaken` int(11) NOT NULL default &#039;0&#039;, 
     17  `kll_dmgtaken` int(11) NOT NULL default 0, 
    1818  PRIMARY KEY  (`kll_timestamp`,`kll_id`), 
    1919  UNIQUE KEY `kll_id` (`kll_id`), 
     
    2424  KEY `kll_system_id` (`kll_system_id`), 
    2525  KEY `kll_fb_all_id` (`kll_fb_all_id`), 
    26   UNIQUE KEY `kll_external_id` (`kll_external_id`), 
     26  UNIQUE KEY `kll_external_id` (`kll_external_id`) 
    2727) Type=InnoDB  DEFAULT CHARSET=utf8;</structure> 
    2828</kb3> 
  • dev/packages/database/kb3_pilots/table.xml

    r370 r371  
    77  `plt_name` char(64) NOT NULL, 
    88  `plt_crp_id` int(11) NOT NULL default &#039;0&#039;, 
    9   `plt_external_id` int(11) default NULL, 
     9  `plt_externalid` int(11) default NULL, 
    1010  `plt_updated` datetime default NULL, 
    1111  PRIMARY KEY  (`plt_id`),