create table userdata (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	ime CHAR(20) NOT NULL,
	email CHAR(60) NOT NULL,
	geslo CHAR(20) NOT NULL,
	ulica CHAR(60) NOT NULL,
	kraj CHAR(30) NOT NULL,
	state CHAR(30) NOT NULL,
	posta CHAR(30) NOT NULL,
	drzava CHAR(30) NOT NULL,
	tel CHAR(30) NOT NULL,
	url CHAR(50) NOT NULL,
	earned FLOAT(8) NOT NULL,
	referer INT,
	obvestilo INT NOT NULL,
	custom TEXT,
	count INT NOT NULL,
	commission CHAR(5)
);

create table banners (
	id CHAR(30) NOT NULL PRIMARY KEY,
	src CHAR(200) NOT NULL,
	prikazi INT NOT NULL,
	kliki INT NOT NULL,
	width INT NOT NULL,
	height INT NOT NULL,
	alt CHAR(50) NOT NULL,
	denar FLOAT(8) NOT NULL,
	page CHAR(200)
);

create table ads (
	id CHAR(30) NOT NULL PRIMARY KEY,
	text TEXT NOT NULL,
	font CHAR(50) NOT NULL,
	fsize INT NOT NULL,
	prikazi INT NOT NULL,
	kliki INT NOT NULL,
	denar FLOAT(8) NOT NULL,
	page CHAR(200)
);

create table ips (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	ip CHAR(20) NOT NULL
);

create table sales (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	affiliate INT NOT NULL,
	datum DATE NOT NULL,
	value CHAR(10) NOT NULL,
	commission CHAR(5) NOT NULL,
	ip CHAR(20) NOT NULL,
	extra TEXT
);