mirror of
https://bitbucket.org/seefoe/dockerized-swg-src.git
synced 2026-07-15 00:08:54 -04:00
14 lines
485 B
SQL
14 lines
485 B
SQL
create table harvester_installation_objects
|
|
(
|
|
object_id number(20), -- BIND_AS(DB::BindableNetworkId)
|
|
installed_efficiency float,
|
|
max_extraction_rate int,
|
|
current_extraction_rate float,
|
|
max_hopper_amount int,
|
|
hopper_resource number(20), -- BIND_AS(DB::BindableNetworkId)
|
|
hopper_amount float,
|
|
resource_type number(20), -- BIND_AS(DB::BindableNetworkId)
|
|
constraint pk_harvester_inst_objects primary key (object_id)
|
|
);
|
|
grant select on harvester_installation_objects to public;
|