DROP TABLE acl;

CREATE TABLE `acl` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `acltype` varchar(30) DEFAULT NULL,
  `department` varchar(40) DEFAULT NULL,
  `position` varchar(30) DEFAULT NULL,
  `role` varchar(30) DEFAULT NULL,
  `module` mediumtext,
  `submodule` mediumtext,
  `modprocess` mediumtext,
  `functions` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




DROP TABLE backup_log;

CREATE TABLE `backup_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dbrdate` int(11) DEFAULT NULL,
  `dbname` varchar(50) DEFAULT NULL,
  `dbrstatus` varchar(50) DEFAULT NULL,
  `note` mediumtext,
  `logid` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

INSERT INTO backup_log VALUES("26","1565798400","../DBBkUP/wisi_security_08152019.sql","BACKED UP","NONE","2");




DROP TABLE notifications;

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ndate` int(11) DEFAULT NULL,
  `sender` mediumtext,
  `recvr_id` varchar(25) DEFAULT NULL,
  `message` mediumtext,
  `nstatus` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




DROP TABLE syslogs;

CREATE TABLE `syslogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_date` int(11) DEFAULT NULL,
  `process` mediumtext,
  `issue` mediumtext,
  `note` mediumtext,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




DROP TABLE system_users;

CREATE TABLE `system_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(30) DEFAULT NULL,
  `empid` varchar(30) DEFAULT NULL,
  `fname` varchar(30) DEFAULT NULL,
  `mname` varchar(30) DEFAULT NULL,
  `lastname` varchar(30) DEFAULT NULL,
  `department` varchar(40) DEFAULT NULL,
  `position` varchar(40) DEFAULT NULL,
  `mobileno` varchar(12) DEFAULT NULL,
  `emailno` mediumtext,
  `ustatus` varchar(30) DEFAULT NULL,
  `note` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;




