create database webdrives;
use webdrives;
create table CSD_FILE (
        id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
        path VARCHAR(250) BINARY NOT NULL,
        filename VARCHAR(250) BINARY NOT NULL,
        mode SMALLINT UNSIGNED,
        PRIMARY KEY (id),
        UNIQUE id (id),
        INDEX (path, filename)
);
create table CSD_INFO (
        id BIGINT UNSIGNED NOT NULL,
        type TINYINT UNSIGNED,
        type_data VARCHAR(250) BINARY,
        title VARCHAR(128),
        description VARCHAR(250),
        PRIMARY KEY (id),
        UNIQUE id (id)
);
create table CSD_ACCESS (
        id BIGINT UNSIGNED NOT NULL,
        access_count BIGINT UNSIGNED,
        last_access BIGINT UNSIGNED,
        PRIMARY KEY (id),
        UNIQUE id (id)
);
create table CSD_MD5 (
        id BIGINT UNSIGNED NOT NULL,
        md5sum CHAR(32) BINARY NOT NULL,
        time_taken BIGINT UNSIGNED,
        PRIMARY KEY (id),
        UNIQUE id (id),
        INDEX (md5sum)
);
create table CSD_NOTE (
        id BIGINT UNSIGNED NOT NULL,
        note TEXT NOT NULL,
        user CHAR(32) BINARY NOT NULL,
        time_stamp BIGINT UNSIGNED NOT NULL,
        INDEX (id)
);
create table CSD_USER (
	user CHAR(32) BINARY NOT NULL,
	password CHAR(13) BINARY NOT NULL,
	name CHAR(128) NOT NULL,
	level TINYINT UNSIGNED NOT NULL,
	PRIMARY KEY (user),
	UNIQUE user (user)
);
create table CSD_CONTROL (
	id BIGINT UNSIGNED NOT NULL,
	owner CHAR(32) BINARY NOT NULL,
	level TINYINT NOT NULL,
	PRIMARY KEY (id),
	UNIQUE id (id),
	INDEX (level)
);

use mysql;
INSERT INTO user VALUES(
	'localhost',
	'csd',
	Password('123csd'),
	'Y','Y','Y','Y','Y','Y','Y',
	'Y','Y','Y','Y','Y','Y','Y'
);

FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON webdrives.CSD_ACCESS TO csd@localhost IDENTIFIED BY '123csd';
GRANT ALL PRIVILEGES ON webdrives.CSD_CONTROL TO csd@localhost IDENTIFIED BY '123csd';
GRANT ALL PRIVILEGES ON webdrives.CSD_FILE TO csd@localhost IDENTIFIED BY '123csd';
GRANT ALL PRIVILEGES ON webdrives.CSD_INFO TO csd@localhost IDENTIFIED BY '123csd';
GRANT ALL PRIVILEGES ON webdrives.CSD_MD5 TO csd@localhost IDENTIFIED BY '123csd';
GRANT ALL PRIVILEGES ON webdrives.CSD_NOTE TO csd@localhost IDENTIFIED BY '123csd';
GRANT ALL PRIVILEGES ON webdrives.CSD_USER TO csd@localhost IDENTIFIED BY '123csd';