db_build.sql

BEGIN ;

DROP TABLE IF EXISTS users CASCADE;
DROP TABLE IF EXISTS posts CASCADE;

CREATE TABLE users (
user_id SERIAL PRIMARY KEY ,
username VARCHAR(100) NOT NULL UNIQUE ,
password VARCHAR(100) NOT NULL ,
email TEXT NOT NULL UNIQUE,
country TEXT NOT NULL,
city TEXT NOT NULL,
added_date DATE DEFAULT now()
);

CREATE TABLE posts(
  post_id SERIAL PRIMARY KEY,
  user_id INTEGER NOT NULL ,
  prefferedpayment VARCHAR(100) NOT NULL,
  country TEXT NOT NULL,
  city TEXT NOT NULL,
  coin TEXT NOT NULL,
  qty INTEGER NOT NULL,
  price INTEGER NOT NULL,
  buyerSeller TEXT NOT NULL,
  added_date DATE DEFAULT now()
);

INSERT INTO users(username , password ,email, country,city) VALUES
('hawk Kayleb' , '123' , 'user@gmail.com' , 'Israel' ,'Haifa' );

INSERT INTO posts(user_id, prefferedpayment, country, city, coin, qty, price, buyerSeller)
 VALUES (1, 'Bank Transfer', 'Israel', 'Tel Aviv', 'Bitcoin', 1, 17000, 'Seller');

COMMIT;