- CREATE TABLE `Users` (
- `id_user` INT PRIMARY KEY AUTO_INCREMENT,
- `name` VARCHAR(50) NOT NULL,
- `email` VARCHAR(50) NOT NULL,
- `dr` DATE,
- `password` VARCHAR(50) NOT NULL,
- `id_role` INT NOT NULL
- );
- CREATE TABLE `Roles` (
- `id_role` INT PRIMARY KEY AUTO_INCREMENT,
- `name` VARCHAR(20) NOT NULL
- );
- CREATE TABLE `Posts` (
- `id_post` INT PRIMARY KEY AUTO_INCREMENT,
- `id_user` INT NOT NULL,
- `id_category` INT NOT NULL,
- `title` VARCHAR(120) NOT NULL,
- `post` TEXT NOT NULL,
- `created_at` TIMESTAMP DEFAULT(now())
- );
- CREATE TABLE `Tags` (
- `id_tag` INT,
- `id_post` INT
- );
- CREATE TABLE `Tag` (
- `id_tag` INT PRIMARY KEY AUTO_INCREMENT,
- `name` VARCHAR(20) NOT NULL
- );
- CREATE TABLE `Category` (
- `id_category` INT PRIMARY KEY AUTO_INCREMENT,
- `name` VARCHAR(20) NOT NULL
- );
- CREATE TABLE `Comments` (
- `id_post` INT NOT NULL,
- `id_comment` INT NOT NULL
- );
- CREATE TABLE `Comment` (
- `id_comment` INT PRIMARY KEY AUTO_INCREMENT,
- `id_user` INT NOT NULL,
- `comment` TEXT NOT NULL
- );
- ALTER TABLE `Users` ADD FOREIGN KEY (`id_role`) REFERENCES `Roles` (`id_role`);
- ALTER TABLE `Posts` ADD FOREIGN KEY (`id_user`) REFERENCES `Users` (`id_user`);
- ALTER TABLE `Comments` ADD FOREIGN KEY (`id_comment`) REFERENCES `Comment` (`id_comment`);
- ALTER TABLE `Comments` ADD FOREIGN KEY (`id_post`) REFERENCES `Posts` (`id_post`);
- ALTER TABLE `Posts` ADD FOREIGN KEY (`id_category`) REFERENCES `Category` (`id_category`);
- ALTER TABLE `Tags` ADD FOREIGN KEY (`id_post`) REFERENCES `Posts` (`id_post`);
- ALTER TABLE `Tags` ADD FOREIGN KEY (`id_tag`) REFERENCES `Tag` (`id_tag`);
[text] Личный блог
Viewer
Editor
You can edit this paste and save as new:
File Description
- Личный блог
- Paste Code
- 21 Jan-2022
- 1.62 Kb
You can Share it:
Latest Code Pastes