ibanktables.txt

java voice chat based on java core ,, u need to extract it and run,, it is siimplee

create table accounts 
( acno varchar(10) primary key,
  cname  varchar(30),
  branch   varchar(20),
  city    varchar(20),
  curbal  money,
  dopen   datetime,
  atype   char(1)
);


create table users 
  ( uname  varchar(10)  primary key,
    pwd    varchar(10)  not null,
    tpwd   varchar(10)  not null,
    email  varchar(50)  unique,
    acno   varchar(10)  references accounts(acno)
);

create table mails
(  mid  integer  primary key,
    mailfrom  varchar(10),
    mailto       varchar(10),
    subject  varchar(50),
    text    varchar(1000),
    sd       datetime
);

create table transactions
(  tid   numeric(10)  primary key,
    acno   varchar(10)  references accounts(acno),
    ttype   char(1),
    tamt    money,
    tdate   datetime,
    cno      varchar(8),
    tdesc   varchar(50),
    status  char(1)
);

create table requests
(  acno  varchar(10)  references accounts(acno),
    request  char(1) ,
    cno        varchar(8),
    dr           datetime

);
   
create table payees
( acno  varchar(10) references  accounts(acno),
   payee varchar(10) references accounts(acno),
   nickname  varchar(20),
   addedon    datetime,
    primary key  (acno,payee)
);

create table schdtrans
(  stid  integer  primary key,
    acno   varchar(10)  references  accounts(acno),
     payee   varchar(10) references accounts(acno),
      schddate   datetime,
     amount      money,
     tdesc          varchar(50)
);


insert into accounts values(1000,'Anders','Dwarakanagar','Vizag',34500,'12-3-2001','s');
insert into accounts values(1001,'Jason','Dwarakanagar','Vizag',178500,'1-3-2001','c');
insert into accounts values(1002,'Larry','MVP COlony','Vizag',12000,'4-3-2004','s');




insert into users  values('andy','andy','andy','[e-mail]',1000);
insert into users  values('hunter','hunter','hunter','[e-mail]',1001);
insert into users  values('ellison','larry','larry','[e-mail]',1002);


insert into  transactions
values(1,'1000','d',5000,'2-2-04',null,'Cash',null);

insert into  transactions
values(2,'1000','d',7500,'2-5-04',null,'Cash',null);

insert into  transactions
values(3,'1000','w',3500,'2-10-04','987601','LIC India','p');

insert into  transactions
values(4,'1000','w',1000,'2-12-04',null,'Cash',null);