drop table user_data\g
create table user_data (
   id_us	int,
   user		char(32),
   password	char(32),
   name		char(32),
   surname	char(40),
   group	char(32),
   email	char(50),
   phone	char(30),
   datum	int,
   member	char(1)
)\g
CREATE SEQUENCE ON user_data STEP 1 VALUE 1\g

DROP TABLE billing\g
CREATE TABLE billing (
   id_bill	int,
   id_us	int,
   address	char(80),
   city		char(30),
   zip		char(9),
   country	char(20),
   ctype	char(20),
   cnum		char(17),
   cexp		char(8),
   amount	int
)\g
CREATE SEQUENCE ON billing STEP 1 VALUE 1\g

DROP TABLE transaction\g
CREATE TABLE transaction (
   id_trans	int,
   id_bill	int,
   datum	int,
   auth		char(6),
   amount	int,
   status	char(1)
)\g
CREATE SEQUENCE ON transaction STEP 1 VALUE 1\g

DROP TABLE credits\g
CREATE TABLE credits (
   id_us	int,
   user		char(32),
   credit	int,
   datum	int
)\g
CREATE SEQUENCE ON credits STEP 1 VALUE 1\g

DROP TABLE corespondance\g
CREATE TABLE corespondance (
   id_us	int,
   data		char(2500),
   type		char(1)
)\g
CREATE SEQUENCE ON corespondance STEP 1 VALUE 1\g

