CREATE SEQUENCE mp3data_id start 1 increment 1 maxvalue 2147483647
  minvalue 1 cache 1;
CREATE TABLE mp3data (
	id		int4 DEFAULT nextval ('mp3data_id'),
	tag		bool,
	filename	varchar,
	size		int8,
	artist		varchar,
	title		varchar,
	genre		varchar,
	album		varchar,
	comment		varchar,
	year		int4
);


CREATE SEQUENCE playlist_id start 1 increment 1 maxvalue 2147483647
  minvalue 1 cache 1;
CREATE TABLE playlist (
	id		int4 DEFAULT nextval ('playlist_id'),
	name		varchar,
	owner		varchar
);

CREATE TABLE playlist_data (
	pl_name		varchar,
	filename	varchar,
	http		varchar,
	owner		varchar
);


CREATE TABLE accounts (
        users		varchar,
	password	varchar
);

GRANT ALL ON accounts TO rimps;
GRANT ALL ON mp3data TO rimps;
GRANT ALL ON playlist TO rimps;
GRANT ALL ON playlist_data TO rimps;