-- CLEANUP
drop user hajo cascade;
drop tablespace hajo including contents and datafiles;


-- TABLESPACE
create tablespace hajo logging datafile size 50m;


-- USER
create user hajo
identified by hajo
default tablespace hajo
temporary tablespace temp
account unlock;


-- QUOTAS
alter user hajo quota unlimited on hajo;


-- GRANTS
grant resource         to hajo;
grant create session   to hajo;
grant create table     to hajo;


---> CONNECT <---
---> CONNECT <---
---> CONNECT <---
conn hajo/hajo




-- TABLE 01
create table hajo_table01
   (
    ref_01                               VARCHAR2(10),
    number_01                            NUMBER,
    status_01                            VARCHAR2(10),
    group_01                             VARCHAR2(10),
    assignee_01                          VARCHAR2(10)
   );


insert into hajo_table01 values ( '111111', 1, 'STAT-01', 'GROUP-01', 'ASSGN-01' );
insert into hajo_table01 values ( '111112', 2, 'STAT-02', 'GROUP-02', 'ASSGN-02' );
insert into hajo_table01 values ( '111113', 3, 'STAT-03', 'GROUP-03', 'ASSGN-03' );
insert into hajo_table01 values ( '111114', 4, 'STAT-04', 'GROUP-04', 'ASSGN-04' );
insert into hajo_table01 values ( '111115', 5, 'STAT-05', 'GROUP-05', 'ASSGN-05' );


-- TABLE 02
create table hajo_table02
   (
    ref_02                               VARCHAR2(10),
    number_02                            NUMBER,
    status_02                            VARCHAR2(10),
    group_02                             VARCHAR2(10),
    assignee_02                          VARCHAR2(10)
   );


insert into hajo_table02 values ( '111112', 2, 'STAT-02', 'GROUP-02', 'ASSGN-02' );
insert into hajo_table02 values ( '111114', 4, 'STAT-14', 'GROUP-14', 'ASSGN-14' );

commit;