root/dev/install/sql/sql_tblstrct_items.sql @ 98

Revision 98, 509 bytes (checked in by exi, 15 years ago)

Added EVE-Dev logo to about page.
Fix an issue with the error jpg in the siggen.
Made item values align right in the item_values mod.
Adding sqldata for the installer. However, this is not Kali data.

1CREATE TABLE `kb3_items` (
2  `itm_id` int(11) NOT NULL auto_increment,
3  `itm_name` varchar(128) NOT NULL default '',
4  `itm_volume` double NOT NULL default '0',
5  `itm_type` int(11) NOT NULL default '1',
6  `itm_externalid` int(11) NOT NULL default '0',
7  `itm_techlevel` tinyint(4) NOT NULL default '1',
8  `itm_icon` varchar(56) NOT NULL,
9  `itm_value` bigint(4) NOT NULL default '0',
10  PRIMARY KEY  (`itm_id`),
11  UNIQUE KEY `itm_name` (`itm_name`),
12  KEY `itm_type` (`itm_type`)
Note: See TracBrowser for help on using the browser.