Creating_Tables.sql

DROP table if exists game_users;
CREATE table game_users
(
user_id int
,created date
,country varchar
)
;

COPY game_users FROM 'C:\Program Files\PostgreSQL\17\Datas/game_users.csv' DELIMITER ',' CSV HEADER;

DROP table if exists game_actions;
CREATE table game_actions
(
user_id int
,action varchar
,action_date date
) 
;

COPY game_actions FROM 'C:\Program Files\PostgreSQL\17\Datas/game_actions.csv' DELIMITER ',' CSV HEADER;

DROP table if exists game_purchases;
CREATE table game_purchases
(
user_id int
,purch_date date
,amount decimal
)
;

COPY game_purchases FROM 'C:\Program Files\PostgreSQL\17\Datas/game_purchases.csv' DELIMITER ',' CSV HEADER;

DROP table if exists exp_assignment;
CREATE table exp_assignment
(
exp_name varchar
,user_id int
,exp_date date
,variant varchar
)
;

COPY exp_assignment FROM 'C:\Program Files\PostgreSQL\17\Datas/exp_analysis.csv' DELIMITER ',' CSV HEADER;