Hello,
I have an installation of OsTicket on Centos and I had a table just go missing in the database. The table is ost_ticket_lock. Is there a way for me to recreate this one table? Why would it be gone? I would think that I could just create this table in mysql but I can not find any data on the structure of this table.
Database Table Corrupt
https://github.com/osTicket/osTicket/blob/develop/setup/inc/streams/core/install-mysql.sql
DROP TABLE IF EXISTS `%TABLE_PREFIX%lock`;
CREATE TABLE `%TABLE_PREFIX%lock` (
`lock_id` int(11) unsigned NOT NULL auto_increment,
`staff_id` int(10) unsigned NOT NULL default '0',
`expire` datetime default NULL,
`code` varchar(20),
`created` datetime NOT NULL,
PRIMARY KEY (`lock_id`),
KEY `staff_id` (`staff_id`)
) DEFAULT CHARSET=utf8;