File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/css/ratings.sql.tar
Back
home/autoph/public_html/projects/Rating-AutoHub/public/db/ratings.sql 0000644 00000017557 15024770513 0021776 0 ustar 00 -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; -- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema autohub_rating_system -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `autohub_rating_system` DEFAULT CHARACTER SET utf8mb3 ; USE `autohub_rating_system` ; -- ----------------------------------------------------- -- Table `templates` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `templates` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 20 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `answers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `answers` ( `id` INT NOT NULL AUTO_INCREMENT, `user_id` INT NOT NULL, `tmpt_id` INT NOT NULL, `qst_id` VARCHAR(455) NOT NULL, `rating` VARCHAR(455) NOT NULL, `comment` VARCHAR(255) NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `user_id` (`user_id` ASC, `tmpt_id` ASC, `qst_id` ASC) VISIBLE, INDEX `t_id_idx` (`tmpt_id` ASC) VISIBLE, CONSTRAINT `tmpt_id` FOREIGN KEY (`tmpt_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 17 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `failed_jobs` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `uuid` VARCHAR(255) NOT NULL, `connection` TEXT NOT NULL, `queue` TEXT NOT NULL, `payload` LONGTEXT NOT NULL, `exception` LONGTEXT NOT NULL, `failed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE INDEX `failed_jobs_uuid_unique` (`uuid` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `systems` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `systems` ( `id` INT NOT NULL AUTO_INCREMENT, `system_name` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `links` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `links` ( `id` INT NOT NULL AUTO_INCREMENT, `sys_id` INT NOT NULL, `tmp_id` INT NOT NULL, `link` VARCHAR(255) NOT NULL, `created_at` DATETIME NULL DEFAULT NULL, `updated_at` DATETIME NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), INDEX `sys_id_idx` (`sys_id` ASC) VISIBLE, INDEX `tmp_id_idx` (`tmp_id` ASC) VISIBLE, CONSTRAINT `sys_id` FOREIGN KEY (`sys_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmp_id` FOREIGN KEY (`tmp_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 10 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `migrations` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `migrations` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `migration` VARCHAR(255) NOT NULL, `batch` INT NOT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `password_resets` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `password_resets` ( `email` VARCHAR(255) NOT NULL, `token` VARCHAR(255) NOT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`email`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `personal_access_tokens` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` VARCHAR(255) NOT NULL, `tokenable_id` BIGINT UNSIGNED NOT NULL, `name` VARCHAR(255) NOT NULL, `token` VARCHAR(64) NOT NULL, `abilities` TEXT NULL DEFAULT NULL, `last_used_at` TIMESTAMP NULL DEFAULT NULL, `expires_at` TIMESTAMP NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT NULL, `updated_at` TIMESTAMP NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `personal_access_tokens_token_unique` (`token` ASC) VISIBLE, INDEX `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type` ASC, `tokenable_id` ASC) VISIBLE) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; -- ----------------------------------------------------- -- Table `questionnaires` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questionnaires` ( `id` INT NOT NULL AUTO_INCREMENT, `s_id` INT NOT NULL, `t_id` INT NOT NULL, `q_id` VARCHAR(455) NOT NULL, `created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `s_id` (`s_id` ASC, `t_id` ASC, `q_id` ASC) VISIBLE, INDEX `system_id_idx` (`s_id` ASC) VISIBLE, INDEX `t_id_idx` (`t_id` ASC) VISIBLE, CONSTRAINT `s_id` FOREIGN KEY (`s_id`) REFERENCES `systems` (`id`), CONSTRAINT `t_id` FOREIGN KEY (`t_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 21 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `questions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questions` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `status` VARCHAR(45) NULL DEFAULT NULL, `active` VARCHAR(45) NULL DEFAULT NULL, `created_at` DATETIME NOT NULL, `updated_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB AUTO_INCREMENT = 11 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `email` VARCHAR(255) NOT NULL, `email_verified_at` TIMESTAMP NULL DEFAULT NULL, `password` VARCHAR(255) NOT NULL, `remember_token` VARCHAR(100) NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, `type` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`), UNIQUE INDEX `users_email_unique` (`email` ASC) VISIBLE) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings