implement verify and pass gen history
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
fs_verify_history
--
-- Indexes for table ALTER TABLE fs_verify_history
ADD PRIMARY KEY (change_id
,fs_id
,date
);
Closes #27 (closed)
Edited by Chris Oelmueller