[sql] wq
Viewer
- CREATE TABLE IF NOT EXISTS `category` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `category_name` VARCHAR(255) NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE IF NOT EXISTS`project` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `created_at` datetime DEFAULT NULL,
- `name` VARCHAR(255) DEFAULT NULL,
- `price` FLOAT DEFAULT NULL,
- `quantity` INT(11) DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `category_id` INT(11) NOT NULL,
- PRIMARY KEY (`id`),
- KEY `FK1mtsbur82frn64de7balymq9s` (`category_id`),
- CONSTRAINT `FK1mtsbur82frn64de7balymq9s` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `user` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `email` VARCHAR(255) DEFAULT NULL,
- `username` VARCHAR(255) DEFAULT NULL,
- `password` VARCHAR(255) DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `UKob8kqyqqgmefl0aco34akdtpe` (`email`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `role` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `name` VARCHAR(255) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- CREATE TABLE `users_roles` (
- `user_id` BIGINT(20) NOT NULL,
- `role_id` BIGINT(20) NOT NULL,
- KEY `FKt4v0rrweyk393bdgt107vdx0x` (`role_id`),
- KEY `FKgd3iendaoyh04b95ykqise6qh` (`user_id`),
- CONSTRAINT `FKgd3iendaoyh04b95ykqise6qh` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
- CONSTRAINT `FKt4v0rrweyk393bdgt107vdx0x` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- INSERT INTO `category` VALUES (1,'Technology'),(2,'Toy'),(3,'Book'),(4,'Food'),(5,'Sport'),(6,'Clothing'),(7,'Beauty');
Editor
You can edit this paste and save as new: