mirror of
https://bitbucket.org/theswgsource/src-1.2.git
synced 2026-07-14 00:01:30 -04:00
19 lines
536 B
SQL
19 lines
536 B
SQL
create table waypoints -- NO_IMPORT
|
|
(
|
|
object_id number(20), -- BIND_AS(DB::BindableNetworkId)
|
|
waypoint_id number(20), -- BIND_AS(DB::BindableNetworkId)
|
|
appearance_name_crc int,
|
|
location_x float,
|
|
location_y float,
|
|
location_z float,
|
|
location_cell number(20), -- BIND_AS(DB::BindableNetworkId)
|
|
location_scene int,
|
|
name varchar2(512),
|
|
color int,
|
|
active char(1),
|
|
constraint pk_waypoints primary key (waypoint_id)
|
|
);
|
|
grant select on waypoints to public;
|
|
|
|
create index waypoint_load_idx on waypoints (object_id) ;
|