mirror of
https://github.com/ParadiseSS13/Paradise.git
synced 2026-04-09 05:51:59 +01:00
1395883465
* initial work on migration to DB * another step * update report on submission * syntax corrections * syntax fix * uses 2 bits to record rejections differently and makes the verb only create one bug report datum * uses the correct value for the index this time * fixes reading a specific bug report * updates sql version * oops * changes the update file * Update 71-72.sql * adds detail to the comment in the update file * remakes the bug report table instead of altering it * change time2text for current time to SQL time * selects columns explicitly * change sql version in the code * renamed load_to_db to save_to_db for clarity * schema formatting and rounds can no longer be null * messages all relevant roles when a bug report is made and also * Prevents bug reports from being modified or handled by more than one person at a time * Update tgui.bundle.js * uses span macros in bug_report * replaces usr with client var in bug report view proc * Update debug.dm * bundle rebuild, rest of reviews --------- Co-authored-by: Migratingcocofruit <guycxz@gmail.com>
18 lines
848 B
SQL
18 lines
848 B
SQL
# Updating SQL from 71 to 72 -MigratingCocofruit
|
|
# Change the bug reports table to use an incrementing id as the primary key
|
|
# Also replaces uid with its timestamp form and adds a column that indicates the reports status
|
|
DROP TABLE IF EXISTS `bug_reports`;
|
|
CREATE TABLE `bug_reports` (
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
|
`filetime` DATETIME NOT NULL DEFAULT NOW(),
|
|
`author_ckey` VARCHAR(32) NOT NULL COLLATE 'utf8mb4_general_ci',
|
|
`title` MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
|
|
`round_id` INT(11) NULL DEFAULT NULL,
|
|
`contents_json` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
|
|
`submitted` BIT(2) NOT NULL DEFAULT 0,
|
|
`approver_ckey` VARCHAR(32) NOT NULL COLLATE 'utf8mb4_general_ci',
|
|
PRIMARY KEY (`id`),
|
|
INDEX `submitted` (`submitted`)
|
|
)
|
|
COLLATE='utf8mb4_general_ci' ENGINE=InnoDB;
|