Changeset 371
- Timestamp:
- 06/14/09 08:49:31 (14 years ago)
- Location:
- dev/packages/database
- Files:
-
- 6 modified
Legend:
- Unmodified
- Added
- Removed
-
dev/packages/database/contents.xml
r370 r371 6 6 </table> 7 7 <table> 8 <name>kb3_api _log</name>8 <name>kb3_apilog</name> 9 9 <version>1.1</version> 10 10 </table> -
dev/packages/database/kb3_alliances/table.xml
r370 r371 6 6 `all_id` int(11) NOT NULL auto_increment, 7 7 `all_name` char(64) NOT NULL default '', 8 `all_external_id` int(11) unsigned default NULL ;,8 `all_external_id` int(11) unsigned default NULL, 9 9 PRIMARY KEY (`all_id`), 10 10 KEY `all_name` (`all_name`) -
dev/packages/database/kb3_api_cache/table.xml
r370 r371 7 7 `cfg_key` varchar(32) NOT NULL default '', 8 8 `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> 10 11 </kb3> 11 12 -
dev/packages/database/kb3_inv_detail/table.xml
r370 r371 4 4 <rows>0</rows> 5 5 <structure>CREATE TABLE `kb3_inv_detail` ( 6 `ind_kll_id` int(6) NOT NULL default '0',7 `ind_plt_id` int(6) NOT NULL default '0',6 `ind_kll_id` int(6) NOT NULL default 0, 7 `ind_plt_id` int(6) NOT NULL default 0, 8 8 `ind_sec_status` char(15) default NULL, 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',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, 14 14 `ind_dmgdone` int(11) NOT NULL, 15 15 PRIMARY KEY (`ind_kll_id`, `ind_order`), 16 16 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`), 19 19 KEY `ind_all_id` (`ind_all_id`) 20 20 ) Type=InnoDB DEFAULT CHARSET=utf8;</structure> -
dev/packages/database/kb3_kills/table.xml
r370 r371 5 5 <structure>CREATE TABLE `kb3_kills` ( 6 6 `kll_id` int(11) NOT NULL auto_increment, 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',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, 13 13 `kll_fb_all_id` int(3) default NULL, 14 `kll_points` int(11) NOT NULL default '0',14 `kll_points` int(11) NOT NULL default 0, 15 15 `kll_external_id` int(3) default NULL, 16 16 `kll_isk_loss` float NOT NULL default 0, 17 `kll_dmgtaken` int(11) NOT NULL default '0',17 `kll_dmgtaken` int(11) NOT NULL default 0, 18 18 PRIMARY KEY (`kll_timestamp`,`kll_id`), 19 19 UNIQUE KEY `kll_id` (`kll_id`), … … 24 24 KEY `kll_system_id` (`kll_system_id`), 25 25 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`) 27 27 ) Type=InnoDB DEFAULT CHARSET=utf8;</structure> 28 28 </kb3> -
dev/packages/database/kb3_pilots/table.xml
r370 r371 7 7 `plt_name` char(64) NOT NULL, 8 8 `plt_crp_id` int(11) NOT NULL default '0', 9 `plt_external _id` int(11) default NULL,9 `plt_externalid` int(11) default NULL, 10 10 `plt_updated` datetime default NULL, 11 11 PRIMARY KEY (`plt_id`),