-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.53-community


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema starrlilog
--

CREATE DATABASE IF NOT EXISTS starrlilog;
USE starrlilog;

--
-- Definition of table `buffetconfig`
--

DROP TABLE IF EXISTS `buffetconfig`;
CREATE TABLE `buffetconfig` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `configkey` varchar(100) NOT NULL DEFAULT '',
  `configvalue` varchar(100) NOT NULL DEFAULT '',
  `configfunction` varchar(100) NOT NULL DEFAULT '',
  `configgroup` varchar(100) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `custom1` varchar(100) NOT NULL DEFAULT '',
  `custom2` varchar(100) NOT NULL DEFAULT '',
  `custom3` varchar(100) NOT NULL DEFAULT '',
  `changedate` datetime DEFAULT NULL,
  `beforetype` varchar(50) DEFAULT NULL,
  `tag1` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `buffetconfig`
--

/*!40000 ALTER TABLE `buffetconfig` DISABLE KEYS */;
INSERT INTO `buffetconfig` (`id`,`name`,`configkey`,`configvalue`,`configfunction`,`configgroup`,`description`,`custom1`,`custom2`,`custom3`,`changedate`,`beforetype`,`tag1`) VALUES 
 (5,'WS_SN','work','10.0.2.15','0800278A29C1','1','EndTime:2020-9-22 4:35:18','','XHeAIC6Z+8B3EIFQxXWdQSgt8Wv+jJR/BxOyB1467+DzecPSBiizmw==','vsku0jBaeTc=','2020-09-22 04:35:09','g/8Ucb7YTDY=',0);
/*!40000 ALTER TABLE `buffetconfig` ENABLE KEYS */;


--
-- Definition of table `starrlilog`
--

DROP TABLE IF EXISTS `starrlilog`;
CREATE TABLE `starrlilog` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `Thread` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `Level` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `Logger` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
  `Message` varchar(4000) CHARACTER SET latin1 DEFAULT NULL,
  `Exception` varchar(2000) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=123 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `starrlilog`
--

/*!40000 ALTER TABLE `starrlilog` DISABLE KEYS */;
INSERT INTO `starrlilog` (`Id`,`Date`,`Thread`,`Level`,`Logger`,`Message`,`Exception`) VALUES 
 (1,'2020-09-17 22:47:49',NULL,'Warning',NULL,'Unable to open COMcom7',NULL),
 (2,'2020-09-17 22:47:49',NULL,'Warning',NULL,'Unable to open COMcom7',NULL),
 (3,'2020-09-17 22:47:49',NULL,'Warning',NULL,'Unable to open COMcom7',NULL),
 (4,'2020-09-17 22:47:49',NULL,'Warning',NULL,'Unable to open COMcom7',NULL),
 (5,'2020-09-20 03:10:09',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (6,'2020-09-20 03:10:09',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (7,'2020-09-20 03:10:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (8,'2020-09-20 03:10:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (9,'2020-09-20 03:11:15',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (10,'2020-09-20 03:11:15',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (11,'2020-09-20 03:11:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (12,'2020-09-20 03:11:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (13,'2020-09-20 03:12:01',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (14,'2020-09-20 03:12:01',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (15,'2020-09-20 03:13:21',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (16,'2020-09-20 03:13:21',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (17,'2020-09-20 03:15:59',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (18,'2020-09-20 03:15:59',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (19,'2020-09-20 03:18:12',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (20,'2020-09-20 03:18:12',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (21,'2020-09-20 03:26:12',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (22,'2020-09-20 03:26:12',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (23,'2020-09-20 03:31:19',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (24,'2020-09-20 03:31:19',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (25,'2020-09-20 03:33:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (26,'2020-09-20 03:33:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (27,'2020-09-20 03:35:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (28,'2020-09-20 03:35:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (29,'2020-09-20 03:36:08',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (30,'2020-09-20 03:36:08',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (31,'2020-09-20 03:38:01',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (32,'2020-09-20 03:38:01',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (33,'2020-09-20 03:43:57',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (34,'2020-09-20 03:43:57',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (35,'2020-09-20 03:46:47',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (36,'2020-09-20 03:46:47',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (37,'2020-09-20 03:48:29',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (38,'2020-09-20 03:48:29',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (39,'2020-09-20 03:54:45',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (40,'2020-09-20 03:54:45',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (41,'2020-09-20 03:55:23',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (42,'2020-09-20 03:55:23',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (43,'2020-09-20 03:55:43',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (44,'2020-09-20 03:55:43',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (45,'2020-09-20 03:57:11',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (46,'2020-09-20 03:57:11',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (47,'2020-09-20 04:01:03',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (48,'2020-09-20 04:01:03',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (49,'2020-09-20 04:02:09',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (50,'2020-09-20 04:02:09',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (51,'2020-09-20 04:04:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (52,'2020-09-20 04:04:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (53,'2020-09-20 04:13:28',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (54,'2020-09-20 04:13:28',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (55,'2020-09-20 04:17:48',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (56,'2020-09-20 04:17:48',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (57,'2020-09-20 04:18:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (58,'2020-09-20 04:18:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (59,'2020-09-20 04:19:10',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (60,'2020-09-20 04:19:10',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (61,'2020-09-20 04:21:07',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (62,'2020-09-20 04:21:07',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (63,'2020-09-20 04:23:29',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (64,'2020-09-20 04:23:29',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (65,'2020-09-20 04:23:48',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (66,'2020-09-20 04:23:48',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (67,'2020-09-20 04:24:12',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (68,'2020-09-20 04:24:12',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (69,'2020-09-20 04:28:05',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (70,'2020-09-20 04:28:05',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (71,'2020-09-20 04:28:58',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (72,'2020-09-20 04:28:58',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (73,'2020-09-20 04:29:25',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (74,'2020-09-20 04:29:25',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (75,'2020-09-20 04:29:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (76,'2020-09-20 04:29:42',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (77,'2020-09-20 04:29:54',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (78,'2020-09-20 04:29:54',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (79,'2020-09-20 04:31:29',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (80,'2020-09-20 04:31:29',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (81,'2020-09-20 04:37:24',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (82,'2020-09-20 04:37:24',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (83,'2020-09-20 04:40:44',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (84,'2020-09-20 04:40:44',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (85,'2020-09-20 04:42:15',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (86,'2020-09-20 04:42:15',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (87,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (88,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (89,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (90,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (91,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (92,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (93,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (94,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (95,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (96,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (97,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (98,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (99,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (100,'2020-09-20 04:43:36',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (101,'2020-09-20 04:43:58',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (102,'2020-09-20 04:43:58',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (103,'2020-09-20 04:43:59',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (104,'2020-09-20 04:43:59',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (105,'2020-09-20 04:44:00',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (106,'2020-09-20 04:44:00',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (107,'2020-09-20 04:59:01',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (108,'2020-09-20 04:59:01',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (109,'2020-09-20 05:00:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (110,'2020-09-20 05:00:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (111,'2020-09-20 05:09:56',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (112,'2020-09-20 05:09:56',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (113,'2020-09-20 05:14:24',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (114,'2020-09-20 05:14:24',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (115,'2020-09-21 03:38:25','1','INFO','CommonBase.CNN','Application Start',''),
 (116,'2020-09-22 04:35:11',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (117,'2020-09-22 04:35:11',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (118,'2020-09-22 04:35:15',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (119,'2020-09-22 04:35:15',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (120,'2020-09-22 04:35:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (121,'2020-09-22 04:35:16',NULL,'Warning',NULL,'Unable to open COMcom2',NULL),
 (122,'2020-09-24 00:29:42','1','INFO','CommonBase.CNN','Application Start','');
/*!40000 ALTER TABLE `starrlilog` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
