Skip to content

implement verify and pass gen history

Ghost User requested to merge 27-logging-verifyPassGen into master

To make this update work following sql are required

ALTER TABLE fs_pass_gen ADD bot_id INT(10) NULL AFTER date;

CREATE TABLE fs_verify_history ( change_id int(10) NOT NULL, fs_id int(10) NOT NULL, date datetime NOT NULL, bot_id int(10) NOT NULL COMMENT 'ID from BOT who change the verify status', change_status int(11) NOT NULL COMMENT '0 = person gets unverify 1= person get verified' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- -- Indexes for dumped tables

-- -- Indexes for table fs_verify_history

ALTER TABLE fs_verify_history ADD PRIMARY KEY (change_id,fs_id,date); Closes #27 (closed)

Edited by Chris Oelmueller

Merge request reports