Copy of SHabit.xlsx

CREATE TABLE `users` (
	`user_id`	BIGINT UNSIGNED	NOT NULL,
	`email`	VARCHAR(63)	NULL,
	`nickname`	VARCHAR(15)	NULL,
	`password`	VARCHAR(255)	NULL,
	`theme`	INT	NULL	DEFAULT 0,
	`profile`	VARCHAR(255)	NULL,
	`provider`	VARCHAR(15)	NULL,
	`created_date`	Datetime	NULL,
	`modified_date`	Timestamp	NULL
);

CREATE TABLE `statistics` (
	`statistics_id`	BIGINT UNSIGNED	NOT NULL,
	`user_id`	BIGINT UNSIGNED	NOT NULL,
	`posture_id`	BIGINT UNSIGNED	NOT NULL,
	`time`	INT	NULL,
	`date`	Datetime	NULL
);

CREATE TABLE `vod` (
	`vod_id`	BIGINT UNSIGNED	NOT NULL,
	`category_id`	BIGINT UNSIGNED	NOT NULL	DEFAULT 0,
	`title`	VARCHAR(255)	NULL,
	`video_id`	VARCHAR(255)	NULL,
	`length`	INT	NULL,
	`original_length`	VARCHAR(255)	NULL,
	`thumbnail`	VARCHAR(255)	NULL
);

CREATE TABLE `posture` (
	`posture_id`	BIGINT UNSIGNED	NOT NULL,
	`name`	VARCHAR(15)	NULL
);

CREATE TABLE `daily` (
	`daily_id`	BIGINT UNSIGNED	NOT NULL,
	`user_id`	BIGINT UNSIGNED	NOT NULL,
	`posture_id`	BIGINT UNSIGNED	NOT NULL,
	`start_time`	Datetime	NULL,
	`end_time`	Datetime	NULL
);

CREATE TABLE `users_roles` (
	`users_user_id`	BIGINT UNSIGNED	NOT NULL,
	`roles`	VARCHAR(255)	NULL
);

CREATE TABLE `grass` (
	`grass_id`	BIGINT UNSIGNED	NOT NULL,
	`user_id`	BIGINT UNSIGNED	NOT NULL,
	`percentage`	INT	NULL,
	`date`	Datetime	NULL
);

CREATE TABLE `setting` (
	`setting_id`	BIGINT UNSIGNED	NOT NULL,
	`stretching_time`	INT	NULL,
	`alert_time`	INT	NULL
);

CREATE TABLE `phrases` (
	`phrases_id`	BIGINT UNSIGNED	NOT NULL,
	`content`	VARCHAR(255)	NULL
);

CREATE TABLE `category` (
	`category_id`	BIGINT UNSIGNED	NOT NULL	DEFAULT 0,
	`name`	VARCHAR(15)	NULL
);

ALTER TABLE `users` ADD CONSTRAINT `PK_USERS` PRIMARY KEY (
	`user_id`
);

ALTER TABLE `statistics` ADD CONSTRAINT `PK_STATISTICS` PRIMARY KEY (
	`statistics_id`,
	`user_id`,
	`posture_id`
);

ALTER TABLE `vod` ADD CONSTRAINT `PK_VOD` PRIMARY KEY (
	`vod_id`,
	`category_id`
);

ALTER TABLE `posture` ADD CONSTRAINT `PK_POSTURE` PRIMARY KEY (
	`posture_id`
);

ALTER TABLE `daily` ADD CONSTRAINT `PK_DAILY` PRIMARY KEY (
	`daily_id`,
	`user_id`,
	`posture_id`
);

ALTER TABLE `users_roles` ADD CONSTRAINT `PK_USERS_ROLES` PRIMARY KEY (
	`users_user_id`
);

ALTER TABLE `grass` ADD CONSTRAINT `PK_GRASS` PRIMARY KEY (
	`grass_id`,
	`user_id`
);

ALTER TABLE `setting` ADD CONSTRAINT `PK_SETTING` PRIMARY KEY (
	`setting_id`
);

ALTER TABLE `phrases` ADD CONSTRAINT `PK_PHRASES` PRIMARY KEY (
	`phrases_id`
);

ALTER TABLE `category` ADD CONSTRAINT `PK_CATEGORY` PRIMARY KEY (
	`category_id`
);

ALTER TABLE `statistics` ADD CONSTRAINT `FK_users_TO_statistics_1` FOREIGN KEY (
	`user_id`
)
REFERENCES `users` (
	`user_id`
);

ALTER TABLE `statistics` ADD CONSTRAINT `FK_posture_TO_statistics_1` FOREIGN KEY (
	`posture_id`
)
REFERENCES `posture` (
	`posture_id`
);

ALTER TABLE `vod` ADD CONSTRAINT `FK_category_TO_vod_1` FOREIGN KEY (
	`category_id`
)
REFERENCES `category` (
	`category_id`
);

ALTER TABLE `daily` ADD CONSTRAINT `FK_users_TO_daily_1` FOREIGN KEY (
	`user_id`
)
REFERENCES `users` (
	`user_id`
);

ALTER TABLE `daily` ADD CONSTRAINT `FK_posture_TO_daily_1` FOREIGN KEY (
	`posture_id`
)
REFERENCES `posture` (
	`posture_id`
);

ALTER TABLE `users_roles` ADD CONSTRAINT `FK_users_TO_users_roles_1` FOREIGN KEY (
	`users_user_id`
)
REFERENCES `users` (
	`user_id`
);

ALTER TABLE `grass` ADD CONSTRAINT `FK_users_TO_grass_1` FOREIGN KEY (
	`user_id`
)
REFERENCES `users` (
	`user_id`
);