create user barcode identified by barcode1
/
create user barcode1 identified by tester
/
create user barcode2 identified by tester2
/

grant all privileges to barcode
/
grant dba to barcode
/
grant all privileges to barcode1
/
grant all privileges to barcode2
/
connect barcode/barcode1@ora9web

create table bar2a(
barkey  number(11),
code  varchar2(20) not null,
timein  varchar2(11),
timeout  varchar2(11),
datetime  date,
dateret  date,
name  varchar2(100),
typeset  varchar2(1),
transno  number(14),
transin  number(8),
amount  number(14),
value  number(14,2),
person  varchar2(50),
address  varchar2(50),
station  number(11),
chk  number(11),
discount  number(7,2),
tax  number(7,2),
value2  number(14,2),
timdif number(14,2),
tendertype varchar2(20),
tentday number(14),
rate2 number(14,2),
tenttot number(14,2),
extot number(14,2),
serial1 varchar2(50),
serial2 varchar2(50),
value3  number(14,2),
tenttota  number(14,2),
taxable  varchar2(1))
/

create index bar2_code_idx on bar2a(code)
/
create index bar2_name_idx on bar2a(name)
/
create index bar2_timein_idx on bar2a(timein)
/
create index bar2_timeout_idx on bar2a(timeout)
/
create index bar2_datetime_idx on bar2a(datetime)
/
create index bar2_dateret_idx on bar2a(dateret)
/
create index bar2_transno_idx on bar2a(transno)
/
create index bar2_transin_idx on bar2a(transin)
/
create index bar2_amount_idx on bar2a(amount)
/
create index bar2_value_idx on bar2a(value)
/
create index bar2_person_idx on bar2a(person)
/
create index bar2_station_idx on bar2a(station)
/
create index bar2_discount_idx on bar2a(discount)
/
create index bar2_value2_idx on bar2a(value2)
/


create table bar1a(
ecode  varchar2(20) not null,
code  varchar2(30) not null,
timemin  varchar2(11),
timemax  varchar2(11),
amount  number(14),
value  number(14,2),
station  number(11),
totval  number(14,2),
chk  number(11),
discount  number(7,2),
datetime  date,
descrip  varchar2(250),
name  varchar2(100),
value2 number(14,2),
taxable  varchar2(1),
amtthresh  number(14),
amtflag number(1))
/

create index bar1_code_idx on bar1a(code)
/
create index bar1_ecode_idx on bar1a(ecode)
/
create index bar1_date_idx on bar1a(datetime)
/
create index bar1_name_idx on bar1a(name)
/
create index bar1_value_idx on bar1a(value)
/
create index bar1_totval_idx on bar1a(totval)
/
create index bar1_amount_idx on bar1a(amount)
/

create table bar1_hista(
code  varchar2(20),
timein  varchar2(11),
datetime  date,
name  varchar2(100),
addamount  number(14),
valueadd  number(14,2),
station  number(11),
newamount  number(14),
valuenew  number(14,2),
supplier  varchar2(100),
chk  number(11))
/

create index bar1_hista_code_idx on bar1_hista(code)
/
create index bar1_hista_station_idx on bar1_hista(station)
/
create index bar1_hista_name_idx on bar1_hista(name)
/
create index bar1_hista_datetime_idx on bar1_hista(datetime)
/
create index bar1_hista_timein_idx on bar1_hista(timein)
/
create index bar1_hista_newamount_idx on bar1_hista(newamount)
/
create index bar1_hista_addamount_idx on bar1_hista(addamount)
/
create index bar1_hista_valueadd_idx on bar1_hista(valueadd)
/
create index bar1_hista_valuenew_idx on bar1_hista(valuenew)
/

create table bar1_custa(
id  number(11),
station  number(11),
name varchar2(100),
address  varchar2(100),
tele  varchar2(20),
extra  varchar2(255),
joindate date,
chk number(11),
cust_off number(7,2),
taxable number(1))
/

create index bar1_cust_id_idx on bar1_custa(id)
/
create index bar1_cust_station_idx on bar1_custa(station)
/
create index bar1_cust_name_idx on bar1_custa(name)
/
create index bar1_cust_address_idx on bar1_custa(address)
/
create index bar1_cust_tele_idx on bar1_custa(tele)
/
create index bar1_cust_extra_idx on bar1_custa(extra)
/
create index bar1_cust_joindate_idx on bar1_custa(joindate)
/

---
create table bar1_supa(
id  number(11),
station  number(11),
name varchar2(40),
address  varchar2(100),
tele  varchar2(20),
extra  varchar2(255),
joindate date,
chk number(11),
cust_off number(7,2))
/

create index bar1_sup_id_idx on bar1_supa(id)
/
create index bar1_sup_station_idx on bar1_supa(station)
/
create index bar1_sup_name_idx on bar1_supa(name)
/
create index bar1_sup_address_idx on bar1_supa(address)
/
create index bar1_sup_tele_idx on bar1_supa(tele)
/
create index bar1_sup_extra_idx on bar1_supa(extra)
/
create index bar1_sup_joindate_idx on bar1_supa(joindate)
/


create table bar1_usra(
id  number(11),
station  number(11),
name varchar2(40),
address  varchar2(100),
tele  varchar2(20),
extra  varchar2(255),
joindate date,
chk varchar2(10),
pass varchar2(50),
typer number(1))
/

create index bar1_usr_id_idx on bar1_usra(id)
/
create index bar1_usr_station_idx on bar1_usra(station)
/
create index bar1_usr_name_idx on bar1_usra(name)
/
create index bar1_usr_address_idx on bar1_usra(address)
/
create index bar1_usr_tele_idx on bar1_usra(tele)
/
create index bar1_usr_extra_idx on bar1_usra(extra)
/
create index bar1_usr_joindate_idx on bar1_usra(joindate)
/
create index bar1_usr_pass_idx on bar1_usra(pass)
/
create index bar1_usr_typer_idx on bar1_usra(typer)
/

create table bar1_usr_hista(
id  number(11),
station  number(11),
name varchar2(40),
login_status  varchar2(10),
joindate date,
chk varchar2(10),
typer number(1))
/

create index bar1_usr_hist_id_idx on bar1_usr_hista(id)
/
create index bar1_usr__hist_station_idx on bar1_usr_hista(station)
/
create index bar1_usr_hist_name_idx on bar1_usr_hista(name)
/
create index bar1_usr_hist_login_idx on bar1_usr_hista(login_status)
/
create index bar1_usr_hist_joindate_idx on bar1_usr_hista(joindate)
/
create index bar1_usr_hist_typer_idx on bar1_usr_hista(typer)
/

create table bar1_stacka(
id  number(12),
station number(9),
joindate varchar2(12),
flag1 number(1))
/

create table bar1_idcounta(
id  number(12),-- user id max
station_max number(9))
/

create table bar1_user_queuea(
name varchar2(60),
temp1  number(2),
temp2  number(2),
temp3  number(2),
temp4  number(2),
temp5  number(2),
temp6  number(2),
temp7  number(2),
temp8  number(2),
temp9  number(2),
--id0  number(2),
--id1  number(2),
--id2  number(2),
--id3  number(2),
--id4  number(2),
--user_id number(9),
score1 number(5),
index1 number(5),
startd number(2),
endd number(2),
name varchar2(100),
code1 number(5)
permis varchar2(1))
/

create table bar1_cama(
id  number(12),
date1 varchar2(10),
time1 varchar2(11),
filename varchar2(50),
xcord number(5),
ycord number(5),
quadsize number(5),
ftype number(5),
station number(3))
/

create table bar1_cam_counta(
id_count number(12))
/

CREATE TABLE FINGERPRINTA (
  PERSONID NUMBER(11)  default 0 NOT NULL,
  FINGERPRINTID NUMBER(11)  default 0 NOT NULL,
  FINGERTYPE NUMBER(11) default NULL,
  FINGERFEATURE LONG RAW,
  RESOLUTION NUMBER(20)  default 0 NOT NULL
)
/
--Table structure for table 'PERSON'

/
CREATE TABLE PERSONA (
  PERSONID NUMBER(11)  default 0 NOT NULL,
  REGISTRATIONNO varchar2(100) default NULL,
  TYPEID INT NOT NULL,
  REGISTEREDDATE DATE  default '' NOT NULL,
  STATUS NUMBER(11) default NULL
)
/

--- create synonyms
create public synonym table fingerprint for table fingerprinta
/
create public synonym table person for table persona
/
create public synonym table bar1_cam for table bar1_cama
/
create public synonym bar1_cam_count for bar1_cam_counta
/
create public synonym bar1_user_queue for bar1_user_queuea
/
create public synonym bar1_idcount for bar1_idcounta
/
create public synonym bar1_stack for bar1_stacka
/
create public synonym bar1 for bar1a
/
create public synonym bar2 for bar2a
/
create public synonym bar1_hist for bar1_hista
/
create public synonym bar1_cust for bar1_custa
/
create public synonym bar1_sup for bar1_supa
/
create public synonym bar1_usr for bar1_usra
/
create public synonym bar1_usr_hist for bar1_usr_hista
/
commit
/