File manager

File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/db/rating-systemV4.sql

Back
-- 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'; -- ----------------------------------------------------- -- 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 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `templates` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `templates` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(45) NULL DEFAULT NULL, `q_id` VARCHAR(999) 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 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `questionnaires` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questionnaires` ( `id` INT NOT NULL AUTO_INCREMENT, `s_id` INT NOT NULL, `t_id` INT NOT NULL, `instruction` VARCHAR(499) NULL DEFAULT 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) 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 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `answers` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `answers` ( `id` INT NOT NULL AUTO_INCREMENT, `user_id` INT NOT NULL, `qstnn_id` INT NULL DEFAULT NULL, `tmpt_id` INT NOT NULL, `qst_id` VARCHAR(455) NOT NULL, `syst_id` INT NULL DEFAULT NULL, `rating` VARCHAR(455) NOT NULL, `comment` VARCHAR(255) NULL DEFAULT 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, `qstnn_id` ASC, `tmpt_id` ASC, `syst_id` ASC) VISIBLE, INDEX `qstnn_id` (`qstnn_id` ASC) VISIBLE, INDEX `syst_id` (`syst_id` ASC) VISIBLE, INDEX `tmpt_id` (`tmpt_id` ASC) VISIBLE, CONSTRAINT `qstnn_id` FOREIGN KEY (`qstnn_id`) REFERENCES `questionnaires` (`id`), CONSTRAINT `syst_id` FOREIGN KEY (`syst_id`) REFERENCES `systems` (`id`), CONSTRAINT `tmpt_id` FOREIGN KEY (`tmpt_id`) REFERENCES `templates` (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `device_access` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `device_access` ( `id` INT NOT NULL AUTO_INCREMENT, `tablet` INT NOT NULL DEFAULT '0', `mobile` INT NOT NULL DEFAULT '0', `pc` INT NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE = InnoDB 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 `forget_password` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `forget_password` ( `id` INT NOT NULL AUTO_INCREMENT, `email` VARCHAR(45) NULL DEFAULT NULL, `token` VARCHAR(45) NULL DEFAULT NULL, `link` VARCHAR(255) NULL DEFAULT NULL, `expires_at` DATETIME NULL DEFAULT NULL, `deleted_at` DATETIME NULL DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8mb3 KEY_BLOCK_SIZE = 2; -- ----------------------------------------------------- -- 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 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 `questions` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `questions` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) 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 DEFAULT CHARACTER SET = utf8mb3; -- ----------------------------------------------------- -- Table `users` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `users` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `f_name` VARCHAR(45) NOT NULL, `l_name` VARCHAR(45) NULL DEFAULT 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 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.01 | proxy | phpinfo | Settings