101 lines
4.1 KiB
SQL
101 lines
4.1 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 192.168.4.95
|
|
Source Server Type : MySQL
|
|
Source Server Version : 100621 (10.6.21-MariaDB-0ubuntu0.22.04.2)
|
|
Source Host : 192.168.4.95:3306
|
|
Source Schema : WIZARD_DB
|
|
|
|
Target Server Type : MySQL
|
|
Target Server Version : 100621 (10.6.21-MariaDB-0ubuntu0.22.04.2)
|
|
File Encoding : 65001
|
|
|
|
Date: 17/06/2025 17:03:47
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for stepList
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `stepList`;
|
|
CREATE TABLE `stepList` (
|
|
`instance` int NOT NULL AUTO_INCREMENT,
|
|
`step_order` int NOT NULL DEFAULT 0,
|
|
`step_title` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
|
|
`step_desc` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
|
|
`related_system` int NOT NULL DEFAULT 0,
|
|
`related_table` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
|
|
`wizard_instance` int NOT NULL DEFAULT 0,
|
|
UNIQUE INDEX `instance`(`instance`) USING BTREE,
|
|
UNIQUE INDEX `step_title`(`step_title`) USING BTREE
|
|
) ENGINE = MyISAM AUTO_INCREMENT = 144 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of stepList
|
|
-- ----------------------------
|
|
INSERT INTO `stepList` VALUES (142, 0, 'aa', 'aa', 320, '2.3', 12);
|
|
INSERT INTO `stepList` VALUES (143, 1, 'cc', 'cc', 320, '2.4', 12);
|
|
INSERT INTO `stepList` VALUES (133, 0, 'Allowed User Prefix', 'Allowed User Prefix', 355, '2.3', 9);
|
|
INSERT INTO `stepList` VALUES (136, 0, 'ss', 'ss', 375, '2.2', 11);
|
|
INSERT INTO `stepList` VALUES (137, 1, 'bb', 'bb', 375, '2.3', 11);
|
|
|
|
-- ----------------------------
|
|
-- Table structure for stepRecordList
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `stepRecordList`;
|
|
CREATE TABLE `stepRecordList` (
|
|
`instance` int NOT NULL AUTO_INCREMENT,
|
|
`record_instance` int NULL DEFAULT 0,
|
|
`wizard_instance` int NOT NULL DEFAULT 0,
|
|
`step_order` int NOT NULL DEFAULT 0,
|
|
`sys_id` varchar(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
|
|
`table_oid` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
|
|
`instance_no` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
|
|
`operate_type` int NOT NULL DEFAULT 0,
|
|
UNIQUE INDEX `instance`(`instance`) USING BTREE
|
|
) ENGINE = MyISAM AUTO_INCREMENT = 111 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of stepRecordList
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for wizardList
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `wizardList`;
|
|
CREATE TABLE `wizardList` (
|
|
`instance` int NOT NULL AUTO_INCREMENT,
|
|
`func_title` varchar(128) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
|
|
`func_desc` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL,
|
|
UNIQUE INDEX `instance`(`instance`) USING BTREE,
|
|
UNIQUE INDEX `func_title`(`func_title`) USING BTREE
|
|
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of wizardList
|
|
-- ----------------------------
|
|
INSERT INTO `wizardList` VALUES (12, 'msc', 'msc');
|
|
INSERT INTO `wizardList` VALUES (9, 'SMEG Configuration', 'SMEG Configuration');
|
|
INSERT INTO `wizardList` VALUES (11, 'opps', 'opps');
|
|
|
|
-- ----------------------------
|
|
-- Table structure for wizardRecordList
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `wizardRecordList`;
|
|
CREATE TABLE `wizardRecordList` (
|
|
`instance` int NOT NULL AUTO_INCREMENT,
|
|
`wizard_instance` int NOT NULL,
|
|
`title` varchar(256) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
|
|
UNIQUE INDEX `instance`(`instance`, `title`) USING BTREE
|
|
) ENGINE = MyISAM AUTO_INCREMENT = 205 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
|
|
|
|
-- ----------------------------
|
|
-- Records of wizardRecordList
|
|
-- ----------------------------
|
|
INSERT INTO `wizardRecordList` VALUES (204, 12, 'msc [ 2010-01-18 09:03:47 designer ]');
|
|
|
|
SET FOREIGN_KEY_CHECKS = 1;
|