#打開資料庫
/opt/asmanager/db/bin/mysql -u root -pM8r@WSX --socket=/tmp/asmanagerdb.sock
#使用
use asmanager
#貼上sql碼
DROP TABLE IF EXISTS `alarmforward`;
CREATE TABLE `alarmforward` (
`forID` int(11) NOT NULL AUTO_INCREMENT,
`forName` varchar(255) NOT NULL,
`forUser` varchar(5000) DEFAULT NULL,
`forCategory` varchar(5000) DEFAULT NULL,
`forMethod` varchar(255) DEFAULT NULL,
`forTime` varchar(255) DEFAULT NULL,
`forStatus` varchar(255) DEFAULT NULL,
PRIMARY KEY (`forID`) USING BTREE,
UNIQUE KEY `forName` (`forName`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `alarmlog`;
CREATE TABLE `alarmlog` (
`alarmLogID` bigint(11) NOT NULL AUTO_INCREMENT,
`alarmTime` datetime NOT NULL,
`alarmDevice` varchar(255) NOT NULL,
`alarmType` varchar(255) NOT NULL,
`alarmCategory` varchar(255) NOT NULL,
`alarmLevel` varchar(255) NOT NULL,
`alarmDetail` varchar(255) NOT NULL,
`alarmRecoveryTime` varchar(255) NOT NULL,
`timeInt` bigint(20) NOT NULL,
`alarmConfirmTime` varchar(255) NOT NULL DEFAULT '',
`alarmRepairTime` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`alarmLogID`) USING BTREE,
KEY `timeIntKey` (`timeInt`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `alarmthreshold`;
CREATE TABLE `alarmthreshold` (
`thID` int(11) NOT NULL AUTO_INCREMENT,
`thName` varchar(255) NOT NULL,
`thType` varchar(255) NOT NULL,
`thCategory` varchar(255) NOT NULL,
`thValue` float NOT NULL,
`thCount` int(11) NOT NULL,
`thLevel` varchar(255) NOT NULL,
`operator` char(2) NOT NULL,
`thStatus` char(3) NOT NULL,
PRIMARY KEY (`thID`) USING BTREE,
KEY `thCategoryKey` (`thCategory`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `cluster`;
CREATE TABLE `cluster` (
`clusterID` int(11) NOT NULL AUTO_INCREMENT,
`clusterName` varchar(50) DEFAULT NULL,
`type` enum('ASManager','ASHyperEdge','ASLog') DEFAULT NULL,
`server` varchar(50) DEFAULT NULL,
`configImport` int(11) DEFAULT NULL,
`configExport` int(11) DEFAULT NULL,
`sync` int(11) DEFAULT NULL,
PRIMARY KEY (`clusterID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `forwardlog`;
CREATE TABLE `forwardlog` (
`forwardLogID` bigint(11) NOT NULL AUTO_INCREMENT,
`alarmDevice` varchar(255) NOT NULL,
`alarmType` varchar(255) NOT NULL,
`alarmCategory` varchar(255) NOT NULL,
`alarmLevel` varchar(255) NOT NULL,
`method` varchar(255) NOT NULL,
`user` varchar(255) NOT NULL,
`logTime` varchar(50) NOT NULL DEFAULT '',
`timeInt` bigint(20) NOT NULL,
`forwardDetail` varchar(1000) NOT NULL,
PRIMARY KEY (`forwardLogID`) USING BTREE,
KEY `timeIntKey` (`timeInt`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `lang`;
CREATE TABLE `lang` (
`langID` int(11) NOT NULL AUTO_INCREMENT,
`langcode` varchar(255) NOT NULL,
`langname` varchar(255) NOT NULL,
PRIMARY KEY (`langID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
REPLACE INTO `lang` (`langID`, `langcode`, `langname`) VALUES
(1, 'cht', '繁中'),
(2, 'chs', '简中'),
(3, 'eng', 'English'),
(4, 'cum', 'Customize');
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`rolename` varchar(255) NOT NULL,
`rolerule` varchar(255) NOT NULL,
PRIMARY KEY (`rolename`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
REPLACE INTO `role` (`rolename`, `rolerule`) VALUES
('Admin', '15,15,15'),
('Guest', '0,0,0'),
('idToken', '15,15,15'),
('User', '15,15,15');
DROP TABLE IF EXISTS `system`;
CREATE TABLE `system` (
`itemID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL DEFAULT '',
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`itemID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8;
INSERT INTO `system` VALUES (1, 'item.PWSetting', 'item.PWExpire', '0');
INSERT INTO `system` VALUES (2, 'item.PWSetting', 'item.PWNotify', '0');
INSERT INTO `system` VALUES (3, 'item.PWSetting', 'item.PWHistory', '0');
INSERT INTO `system` VALUES (4, 'item.PWSetting', 'item.PWminlen', '0');
INSERT INTO `system` VALUES (5, 'item.PWSetting', 'item.PWerrcnt', '0');
INSERT INTO `system` VALUES (6, 'item.PWSetting', 'item.PWRule', '1');
INSERT INTO `system` VALUES (7, 'item.PWSetting', 'item.Space', 'Apply');
INSERT INTO `system` VALUES (8, 'item.MailSetting', 'item.MailServer', '');
INSERT INTO `system` VALUES (9, 'item.MailSetting', 'item.MailPort', '25');
INSERT INTO `system` VALUES (10, 'item.MailSetting', 'item.MailUsername', '');
INSERT INTO `system` VALUES (11, 'item.MailSetting', 'item.MailPassword', '');
INSERT INTO `system` VALUES (13, 'item.MailSetting', 'item.MailSender', '');
INSERT INTO `system` VALUES (15, 'item.MailSetting', 'item.MailTest', '');
INSERT INTO `system` VALUES (16, 'item.MailSetting', 'item.Space', 'Apply');
INSERT INTO `system` VALUES (31, 'item.TimeSetting', 'item.NTPServer', '');
INSERT INTO `system` VALUES (32, 'item.TimeSetting', 'item.Space', 'Apply');
INSERT INTO `system` VALUES (33, 'item.SNMPSetting', 'item.SNMPEnable', '0');
INSERT INTO `system` VALUES (34, 'item.SNMPSetting', 'item.SNMPVersion', '2');
INSERT INTO `system` VALUES (35, 'item.SNMPSetting', 'item.SNMPIP', '0.0.0.0');
INSERT INTO `system` VALUES (36, 'item.SNMPSetting', 'item.SNMPPort', '161');
INSERT INTO `system` VALUES (37, 'item.SNMPSetting', 'item.Community', 'public');
INSERT INTO `system` VALUES (38, 'item.SNMPSetting', 'item.TrapIP', '');
INSERT INTO `system` VALUES (39, 'item.SNMPSetting', 'item.TrapPort', '162');
INSERT INTO `system` VALUES (40, 'item.SNMPSetting', 'item.TrapCommunity', 'public');
INSERT INTO `system` VALUES (41, 'item.SNMPSetting', 'item.Space', 'Apply');
INSERT INTO `system` VALUES (51, 'item.SMSSetting', 'item.URL', '');
INSERT INTO `system` VALUES (52, 'item.SMSSetting', 'item.Space', 'Apply');
INSERT INTO `system` VALUES (101, 'item.HASetting', 'item.haEnable', '0');
INSERT INTO `system` VALUES (102, 'item.HASetting', 'item.haStatus', 'OFF');
INSERT INTO `system` VALUES (103, 'item.HASetting', 'item.haInterface', '');
INSERT INTO `system` VALUES (104, 'item.HASetting', 'item.haVirtualID', '');
INSERT INTO `system` VALUES (105, 'item.HASetting', 'item.haPriority', '');
INSERT INTO `system` VALUES (106, 'item.HASetting', 'item.haVIP', '');
INSERT INTO `system` VALUES (107, 'item.HASetting', 'item.haSendMail', '0');
INSERT INTO `system` VALUES (108, 'item.HASetting', 'item.haMailAddress', '');
INSERT INTO `system` VALUES (109, 'item.HASetting', 'item.haPreempt', 'OFF');
INSERT INTO `system` VALUES (110, 'item.HASetting', 'item.Space', 'Apply');
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userName` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`pwtime` bigint(20) DEFAULT NULL,
`pwhistory` varchar(1000) DEFAULT NULL,
`role` varchar(255) NOT NULL,
`lang` varchar(255) NOT NULL,
`errcnt` smallint(6) DEFAULT NULL,
`status` varchar(255) NOT NULL,
`note` varchar(255) DEFAULT '',
`lineID` varchar(255) DEFAULT NULL,
`lineToken` varchar(255) DEFAULT NULL,
PRIMARY KEY (`userName`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
REPLACE INTO `user` (`userName`, `password`, `email`, `phone`, `pwtime`, `pwhistory`, `role`, `lang`, `errcnt`, `status`, `note`, `lineID`, `lineToken`) VALUES
('admin', '477f1f827f5c3e928ecd7a3d51d6f4c55720be967c34b8b5952ae971193874f1', '', '', 1623199162910, '230c78da07ae7a4cae60c2e3ff35122e', 'Admin', 'eng', 0, 'ON', '', ' ', '');
DROP TABLE IF EXISTS `userlog`;
CREATE TABLE `userlog` (
`logID` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(255) NOT NULL DEFAULT '',
`ip` varchar(255) NOT NULL DEFAULT '',
`item` varchar(255) NOT NULL DEFAULT '',
`type` varchar(255) NOT NULL DEFAULT '',
`result` varchar(255) NOT NULL,
`notes` varchar(5000) NOT NULL DEFAULT '0',
`logTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`timeInt` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`logID`) USING BTREE,
KEY `timeIntKey` (`timeInt`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `tenant`;
CREATE TABLE `tenant` (
`tenantID` int(11) NOT NULL AUTO_INCREMENT,
`tenantName` varchar(255) NOT NULL DEFAULT '',
`tenantDomain` varchar(255) NOT NULL,
`tenantStatus` varchar(255) NOT NULL,
`tenantNote` varchar(255) DEFAULT NULL,
PRIMARY KEY (`tenantID`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
DROP TABLE IF EXISTS `server`;
CREATE TABLE `server` (
`serverID` int(8) NOT NULL AUTO_INCREMENT,
`serverName` varchar(50) NOT NULL,
`type` enum('ASManager','ASHyperEdge','ASLog') DEFAULT NULL,
`protocol` enum('HTTP','HTTPS','TCP') DEFAULT NULL,
`ip` varchar(25) DEFAULT NULL,
`path` varchar(100) DEFAULT NULL,
`port` varchar(50) DEFAULT NULL,
`timeout` int(100) DEFAULT NULL,
`checkInterval` int(100) DEFAULT NULL,
`healthyThreshold` int(100) DEFAULT NULL,
`unhealthyThreshold` int(100) DEFAULT NULL,
`configImport` varchar(50) DEFAULT NULL,
`configExport` varchar(50) DEFAULT NULL,
`enable` enum('ON','OFF') DEFAULT NULL,
`status` varchar(4) DEFAULT NULL,
PRIMARY KEY (`serverID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `serverstatus`;
CREATE TABLE `serverstatus` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`serverid` varchar(50) DEFAULT NULL,
`serverName` varchar(50) DEFAULT NULL,
`error` varchar(50) DEFAULT '1',
`cpu` varchar(50) DEFAULT '0',
`memory` varchar(50) DEFAULT '0',
`disk` varchar(50) DEFAULT '0',
`networkIn` varchar(50) DEFAULT '0',
`networkOut` varchar(50) DEFAULT '0',
`time` double DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
#離開
exit;
#暫停資料庫:
service asmanagerdb stop
#壓縮
cd /opt/asmanager/
(將db壓縮名字叫asmanager_db.tar.gz)
#將asmanager_db.tar.gz copy至打包環境的asmanager目錄下
#至ops目錄下刪除舊db
rm -rf db
#解壓新的db
tar zxvf asmanager_db.tar.gz
#刪除db的tar檔
rm -f asmanager_db.tar.gz
留言列表
