All pastes #960390 Raw Edit

Anonymous

public text v1 · immutable
#960390 ·published 2008-03-28 01:54 UTC
rendered paste body
/*Column Information For - evemetrics_production.market_uploads*/
-----------------------------------------------------------------

Field             Type        Collation  Null    Key     Default  Extra           Privileges                       Comment
----------------  ----------  ---------  ------  ------  -------  --------------  -------------------------------  -------
id                int(11)     (NULL)     NO      PRI     (NULL)   auto_increment  select,insert,update,references         
type_id           int(11)     (NULL)     YES     MUL     (NULL)                   select,insert,update,references         
price             float       (NULL)     YES             (NULL)                   select,insert,update,references         
sell_order        tinyint(1)  (NULL)     YES             (NULL)                   select,insert,update,references         
range             int(11)     (NULL)     YES             (NULL)                   select,insert,update,references         
initial_volume    int(11)     (NULL)     YES             (NULL)                   select,insert,update,references         
available_volume  int(11)     (NULL)     YES             (NULL)                   select,insert,update,references         
sale_volume       int(11)     (NULL)     YES             (NULL)                   select,insert,update,references         
station_id        int(11)     (NULL)     YES     MUL     (NULL)                   select,insert,update,references         
system_id         int(11)     (NULL)     YES             (NULL)                   select,insert,update,references         
region_id         int(11)     (NULL)     YES             (NULL)                   select,insert,update,references         
issued_at         datetime    (NULL)     YES             (NULL)                   select,insert,update,references         
expires_at        datetime    (NULL)     YES             (NULL)                   select,insert,update,references         
user_id           int(11)     (NULL)     YES     MUL     (NULL)                   select,insert,update,references         
created_at        datetime    (NULL)     YES             (NULL)                   select,insert,update,references         
updated_at        datetime    (NULL)     YES             (NULL)                   select,insert,update,references         
developer_key_id  int(11)     (NULL)     YES             (NULL)                   select,insert,update,references         

/*Index Information For - evemetrics_production.market_uploads*/
----------------------------------------------------------------

Table           Non_unique  Key_name                            Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  Null    Index_type  Comment
--------------  ----------  ----------------------------------  ------------  -----------  ---------  -----------  --------  ------  ------  ----------  -------
market_uploads           0  PRIMARY                                        1  id           A                 4665    (NULL)  (NULL)          BTREE              
market_uploads           1  index_market_uploads_on_type_id                1  type_id      A                  126    (NULL)  (NULL)  YES     BTREE              
market_uploads           1  index_market_uploads_on_station_id             1  station_id   A                    2    (NULL)  (NULL)  YES     BTREE              
market_uploads           1  index_market_uploads_on_user_id                1  user_id      A                    2    (NULL)  (NULL)  YES     BTREE