rem ----------------------------------------------------------------------
rem -- 2006 DataPRO Developers - m@urelio
rem ----------------------------------------------------------------------
rem -- Script para criação das tabelas
rem -- Execute como usuário NK
rem -- RDBMS 11g XE express
rem ----------------------------------------------------------------------

drop table nkw_auditab;
create table nkw_auditab(
timestamp		  date		    not null,
audid			  varchar2(8)	    not null,
audsid			  number(12)	    not null,
object_name		  varchar2(30)	    not null,
dml_action		  varchar2(10)	    not null,
user_id 		  number(6)	    not null,
username		  varchar2(30)	    not null,
text			  varchar2(4000)    not null);
create unique index ind_nkw_auditab1 on nkw_auditab(audid) tablespace ind;

drop table nkw_col_cmm;
create table nkw_col_cmm(
object_name		  varchar2(30)	    not null,
column_name		  varchar2(30)	    not null,
comments		  varchar2(4000));
create unique index ind_nkw_col_cmm1 on nkw_col_cmm(object_name, column_name) tablespace ind;

drop table nkw_dnt_ccvies;
create table nkw_dnt_ccvies (
table_name		  varchar2(30)	    not null,
dnt			  varchar2(10)	    not null,
column_id		  number(3)	    not null,
app_message		  varchar2(80)	    not null,
pkg_function		  varchar2(80),
text			  varchar2(4000)   not null);
create unique index ind_nkw_dnt_ccvies1 on nkw_dnt_ccvies(table_name, dnt, column_id) tablespace ind;

drop table nkw_dnt_dtgc;
create table nkw_dnt_dtgc (
table_name		  varchar2(30)	    not null,
logies			  varchar2(1)	    not null,
dvies			  varchar2(1)	    not null,
ccvies			  varchar2(1)	    not null,
eppc			  varchar2(1)	    not null,
eapb			  varchar2(1)	    not null);
create unique index ind_nkw_dnt_dtgc1 on nkw_dnt_dtgc(table_name) tablespace ind;

drop table nkw_dnt_dvies;
create table nkw_dnt_dvies (
table_name		  varchar2(30)	    not null,
dnt			  varchar2(10)	    not null,
column_id		  number(3)	    not null,
insert_flag		  varchar2(1)	    not null,
update_flag		  varchar2(1)	    not null,
anvl			  varchar2(1)	    not null,
pkg_function		  varchar2(80),
text			  varchar2(4000)    not null);
create unique index ind_nkw_dnt_dvies1 on nkw_dnt_dvies(table_name, dnt, column_id) tablespace ind;

drop table nkw_dnt_eapb;
create table nkw_dnt_eapb(
table_name		  varchar2(30)	    not null,
text			  long		    not null);
create unique index ind_nkw_dnt_eapb1 on nkw_dnt_eapb(table_name) tablespace ind;

drop table nkw_dnt_eppc;
create table nkw_dnt_eppc(
table_name		  varchar2(30)	    not null,
pkgid			  number(3)	    not null,
insert_flag		  varchar2(1)	    not null,
update_flag		  varchar2(1)	    not null,
delete_flag		  varchar2(1)	    not null,
runif			  varchar2(4000)    not null,
pkg_procedure		  varchar2(80)	    not null,
pkg_arguments		  varchar2(4000)    not null);
create unique index ind_nkw_dnt_eppc1 on nkw_dnt_eppc(table_name, pkgid) tablespace ind;

drop table nkw_dnt_logies;
create table nkw_dnt_logies (
table_name		  varchar2(30)	    not null,
column_id		  number(3)	    not null,
insert_flag		  varchar2(1)	    not null,
update_flag		  varchar2(1)	    not null,
delete_flag		  varchar2(1)	    not null);
create unique index ind_nkw_dnt_logies1 on nkw_dnt_logies(table_name, column_id) tablespace ind;

drop table nkw_drm;
create table nkw_drm(
dml_table		  varchar2(30)	    not null,
relational_table	  varchar2(30)	    not null,
relid			  number(3)	    not null,
dml_action		  varchar2(10)	    not null,
raise_when		  varchar2(10)	    not null,
assertion_message	  varchar2(80)	    not null,
text			  varchar2(4000)    not null);
create unique index ind_nkw_drm1 on nkw_drm(dml_table, relational_table, relid) tablespace ind;

drop table nkw_frm;
create table nkw_frm(
frm_name		  varchar2(30)	    not null,
frm_version		  varchar2(10)	    not null,
frm_scope		  varchar2(30)	    not null,
frm_comments		  varchar2(4000)    not null);
create unique index ind_nkw_frm1 on nkw_frm(frm_name) tablespace ind;

drop table nkw_frmblk;
create table nkw_frmblk(
frm_sequence		  number(2)	    not null,
frm_name		  varchar2(30)	    not null,
frm_block		  varchar2(30)	    not null,
frm_query_source	  varchar2(30)	    not null,
frm_dml_target		  varchar2(30)	    not null,
select_flag		  varchar2(1)	    not null,
insert_flag		  varchar2(1)	    not null,
update_flag		  varchar2(1)	    not null,
delete_flag		  varchar2(1)	    not null);
create unique index ind_nkw_frmblk1 on nkw_frmblk(frm_name, frm_block) tablespace ind;

drop table nkw_frmsrw;
create table nkw_frmsrw(
frm_name		  varchar2(30)	    not null,
srw_name		  varchar2(30)	    not null);
create unique index ind_nkw_frmsrw1 on nkw_frmsrw(frm_name, srw_name) tablespace ind;

drop table nkw_srw;
create table nkw_srw(
srw_name		  varchar2(30)	    not null,
srw_view		  varchar2(60)	    not null,
srw_file		  varchar2(80)	    not null,
srw_mode		  varchar2(1)	    not null,
srw_comments		  varchar2(4000));
create unique index ind_nkw_srw1 on nkw_srw(srw_name) tablespace ind;

drop table nkw_srwcies;
create table nkw_srwcies(
srw_name		  varchar2(30)	    not null,
srw_item		  number(3)	    not null,
srw_parameter		  varchar2(1)	    not null,
srw_column		  varchar2(30)	    not null,
srw_datatype		  varchar2(30)	    not null,
srw_label		  varchar2(30)	    not null);
create unique index ind_nkw_srwcies1 on nkw_srwcies(srw_name, srw_item) tablespace ind;

drop table nkw_tab_cmm;
create table nkw_tab_cmm(
object_name		  varchar2(30)	    not null,
comments		  varchar2(4000));
create unique index ind_nkw_tab_cmm1 on nkw_tab_cmm(object_name) tablespace ind;

drop table nkw_usr_prefs;
create table nkw_usr_prefs(
username		  varchar2(30)	    not null,
va			  varchar2(30)	    not null,
flag			  varchar2(3));
create unique index ind_nkw_usr_prefs1 on nkw_usr_prefs(username) tablespace ind;

drop table nkw_viw;
create table nkw_viw(
view_name		  varchar2(30)	    not null,
text			  long		    not null);
create unique index ind_nkw_viw1 on nkw_viw(view_name) tablespace ind;