create table data_dsentities(
   id          number(10) NOT NULL, 
   created     number(14) default '0' NOT NULL,
   modified    number(14) default '0' NOT NULL,
   dse_id      number(10) NOT NULL,
   is_local    number(1) default '0' NOT NULL
);
alter table data_dsentities add constraint data_dsentities_pk primary key (id);
alter table data_dsentities add constraint data_dsentities_uk unique (dse_id);
create sequence data_dsentities_seq increment by 1 start with 1 nocache;

create table data_dataset(
   id          number(10) NOT NULL, 
   created     number(14) default '0' NOT NULL,
   modified    number(14) default '0' NOT NULL,
   ds_id       number(10) NOT NULL,
   is_local    number(1) default '0' NOT NULL,
   importdate  number(14) default '0' NOT NULL
);
alter table data_dataset add constraint data_dataset_pk primary key (id);
alter table data_dataset add constraint data_dataset_uk unique (ds_id);
create sequence data_dataset_seq increment by 1 start with 1 nocache;

grant select on data_dsentities to anyuser;
grant select on data_dataset to anyuser;