DROP TABLE IF EXISTS rooms;
CREATE TABLE rooms (
	id int(11) NOT NULL AUTO_INCREMENT,
	name varchar(100) NOT NULL,
	credit int(11) NOT NULL DEFAULT 0,
	spent int(11) NOT NULL DEFAULT 0,
	primary key (id)
);

DROP TABLE IF EXISTS payments;
CREATE TABLE payments (
	id int(11) NOT NULL AUTO_INCREMENT,
	room_id int(11) NOT NULL,
	username varchar(100) NOT NULL,
	first_name varchar(100) NOT NULL,
	last_name varchar(100) NOT NULL,
	email_address varchar(500) NOT NULL,
	address_country varchar(500) NOT NULL,
	address_city varchar(500) NOT NULL,
	amount int(11) NOT NULL,
	currency varchar(10) NOT NULL,
	txn_id char(100) NOT NULL,
	primary key(id)
);