CREATE TABLE mye_users (
    userID INT UNSIGNED AUTO_INCREMENT NOT NULL,
    nickname VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    password VARCHAR(50) NOT NULL,
    createTSP DATETIME NOT NULL,
    changeTSP TIMESTAMP NOT NULL,
    PRIMARY KEY(userID)
);

CREATE TABLE mye_category (
    categoryID SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL,
    motherID SMALLINT UNSIGNED NOT NULL,
    name VARCHAR(255) NOT NULL,
    description TEXT,
    createTSP DATETIME NOT NULL,
    changeTSP TIMESTAMP NOT NULL,
    PRIMARY KEY(categoryID)
);

CREATE TABLE mye_user_interests (
    userID INT UNSIGNED NOT NULL,
    categoryID SMALLINT UNSIGNED NOT NULL,
    createTSP DATETIME NOT NULL,
    changeTSP TIMESTAMP NOT NULL,
    PRIMARY KEY(userID, categoryID)
);

CREATE TABLE mye_url (
    urlID INT UNSIGNED AUTO_INCREMENT NOT NULL,
    domainID SMALLINT UNSIGNED NOT NULL,
    categoryID SMALLINT UNSIGNED NOT NULL,
    userID INT UNSIGNED NOT NULL,
    url VARCHAR(255) NOT NULL,
    description TEXT,
    createTSP DATETIME NOT NULL,
    changeTSP TIMESTAMP NOT NULL,
    PRIMARY KEY(urlID)
);

CREATE TABLE mye_domain (
    domainID SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL,
    userID INT UNSIGNED NOT NULL,
    ispublic ENUM('Y','N') NOT NULL DEFAULT 'Y',
    name VARCHAR(255) NOT NULL,
    description TEXT,
    createTSP DATETIME NOT NULL,
    changeTSP TIMESTAMP NOT NULL,
    PRIMARY KEY(domainID)
);

CREATE TABLE mye_userdomains (
    userID INT UNSIGNED NOT NULL,
    domainID SMALLINT UNSIGNED NOT NULL,
    PRIMARY KEY(userID, domainID)
);