/*
Navicat MySQL Data Transfer

Source Server         : local_centos65
Source Server Version : 50173
Source Host           : 192.168.74.128:3306
Source Database       : nozzledb

Target Server Type    : MYSQL
Target Server Version : 50173
File Encoding         : 65001

Date: 2016-09-18 13:57:36
*/


-- ----------------------------
-- Table structure for `nozzle_action`
-- ----------------------------
CREATE TABLE `nozzle_action` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(255) DEFAULT NULL,
  `main` text,
  `isfilter` tinyint(4) DEFAULT '0',
  `createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `l10n` varchar(255) DEFAULT NULL,
  `locktype` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_action
-- ----------------------------

-- ----------------------------
-- Table structure for `nozzle_appandresource`
-- ----------------------------
CREATE TABLE `nozzle_appandresource` (
  `appid` varchar(50) NOT NULL DEFAULT '',
  `resourceid` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`appid`,`resourceid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_appandresource
-- ----------------------------

-- ----------------------------
-- Table structure for `nozzle_application`
-- ----------------------------
CREATE TABLE `nozzle_application` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `appname` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `isfilter` tinyint(4) DEFAULT '0',
  `authurl` varchar(255) DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `description` varchar(255) DEFAULT NULL,
  `debug` tinyint(4) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `viewport` varchar(255) DEFAULT 'width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no',
  `main_js` text,
  `main_css` text,
  `main_html` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_application
-- ----------------------------

-- ----------------------------
-- Table structure for `nozzle_application_template`
-- ----------------------------
CREATE TABLE `nozzle_application_template` (
  `template_name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `linktype` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `linkid` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  PRIMARY KEY (`template_name`,`linktype`,`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of nozzle_application_template
-- ----------------------------
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', '2b9f34b0-6355-11e6-8deb-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', '4efaccb8-74e3-11e6-a09f-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', '697587c7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', 'b89dcf7f-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', 'bdda1b66-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', 'd75d6667-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', 'dab278b7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', 'de2a5935-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', 'ec689980-54e5-11e6-ae38-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui', 'appandresource', 'fd35ff64-54e5-11e6-ae38-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', '24c1fd72-74de-11e6-a09f-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', '2b9f34b0-6355-11e6-8deb-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', '2eeee94c-74e1-11e6-a09f-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', '62a56396-74e2-11e6-a09f-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', '697587c7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', '6aaae282-74e2-11e6-a09f-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', 'b4c4fd1c-74dd-11e6-a09f-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', 'd75d6667-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', 'dab278b7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('amazeui.react', 'appandresource', 'de2a5935-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', '2b9f34b0-6355-11e6-8deb-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', '59ef392a-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', '697587c7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', '880b45fc-673f-11e6-be54-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', 'aa422964-4346-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', 'afb99cb2-4346-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', 'b89dcf7f-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', 'bdda1b66-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', 'd75d6667-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', 'dab278b7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('bootstrap', 'appandresource', 'de2a5935-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', '2b9f34b0-6355-11e6-8deb-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', '59ef392a-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', '697587c7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', '880b45fc-673f-11e6-be54-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', 'aa422964-4346-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', 'afb99cb2-4346-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', 'b89dcf7f-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', 'bdda1b66-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', 'd75d6667-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', 'dab278b7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('empty', 'appandresource', 'de2a5935-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', '0e8643c6-54e3-11e6-ae38-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', '28cde270-54e3-11e6-ae38-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', '2b9f34b0-6355-11e6-8deb-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', '697587c7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', '9a1641c4-54e4-11e6-ae38-000c29b5bcfb');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', 'b89dcf7f-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', 'bdda1b66-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', 'd75d6667-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', 'dab278b7-4347-11e6-b6a4-000c29a1f80d');
INSERT INTO `nozzle_application_template` VALUES ('lufylegend', 'appandresource', 'de2a5935-4347-11e6-b6a4-000c29a1f80d');

-- ----------------------------
-- Table structure for `nozzle_authorization`
-- ----------------------------
CREATE TABLE `nozzle_authorization` (
  `id` varchar(50) NOT NULL,
  `roleid` varchar(50) DEFAULT '',
  `whattype` varchar(50) DEFAULT NULL,
  `whatid` varchar(50) DEFAULT NULL,
  `authtype` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_authorization
-- ----------------------------

-- ----------------------------
-- Table structure for `nozzle_cron`
-- ----------------------------
CREATE TABLE `nozzle_cron` (
  `id` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `cron_time` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `action_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `cron_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `service_name` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `excute_type` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `excute_params` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `isrun` tinyint(4) DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of nozzle_datasource
-- ----------------------------

-- ----------------------------
-- Table structure for `nozzle_param_valid`
-- ----------------------------
CREATE TABLE `nozzle_param_valid` (
  `paramid` varchar(50) NOT NULL DEFAULT '',
  `validid` varchar(50) NOT NULL DEFAULT '',
  `ordernum` int(11) DEFAULT NULL,
  PRIMARY KEY (`paramid`,`validid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_param_valid
-- ----------------------------

-- ----------------------------
-- Table structure for `nozzle_params`
-- ----------------------------
CREATE TABLE `nozzle_params` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(255) DEFAULT NULL,
  `l10n` varchar(255) DEFAULT NULL,
  `type` varchar(20) DEFAULT 'form',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_params
-- ----------------------------
INSERT INTO `nozzle_params` VALUES ('2eE40925fAD32521885fC610e7Fbec58', 'ip', null, 'request_header');
INSERT INTO `nozzle_params` VALUES ('4BE2D6465a78d545Acb384D46043ece5', 'filename', null, 'form');
INSERT INTO `nozzle_params` VALUES ('5F45cD9AC7e567EDb1F28c176cA119c0', 'sourcename', null, 'form');
INSERT INTO `nozzle_params` VALUES ('6612a74f78041256A7C87BCAf09c951B', 'name', null, 'form');
INSERT INTO `nozzle_params` VALUES ('A8ddEF8323261D15121ca1e6d0d70A82', 'user_agent', null, 'request_header');
INSERT INTO `nozzle_params` VALUES ('Cfa00B5378f78A93FDe45b5944CF5A9d', 'id', null, 'key');
INSERT INTO `nozzle_params` VALUES ('E68006f3cab026BB4FA396E41b92e22C', 'id', null, 'form');

-- ----------------------------
-- Table structure for `nozzle_resource`
-- ----------------------------
CREATE TABLE `nozzle_resource` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `sourcename` varchar(50) DEFAULT NULL,
  `version` varchar(20) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `sourcetype` varchar(50) DEFAULT NULL,
  `createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ordernum` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_resource
-- ----------------------------
INSERT INTO `nozzle_resource` VALUES ('9faa4be2-4346-11e6-b6a4-000c29a1f80d', 'bootstrap', '3.3.6', 'bootstrap.css', 'css', '2016-07-06 14:55:28', '20101');
INSERT INTO `nozzle_resource` VALUES ('aa422964-4346-11e6-b6a4-000c29a1f80d', 'bootstrap', '3.3.6', 'bootstrap.min.css', 'css', '2016-07-06 14:55:46', '20101');
INSERT INTO `nozzle_resource` VALUES ('ae42b236-4346-11e6-b6a4-000c29a1f80d', 'bootstrap', '3.3.6', 'bootstrap-theme.css', 'css', '2016-07-06 14:55:53', '20102');
INSERT INTO `nozzle_resource` VALUES ('afb99cb2-4346-11e6-b6a4-000c29a1f80d', 'bootstrap', '3.3.6', 'bootstrap-theme.min.css', 'css', '2016-07-06 14:55:55', '20102');
INSERT INTO `nozzle_resource` VALUES ('5776484d-4347-11e6-b6a4-000c29a1f80d', 'bootstrap', '3.3.6', 'bootstrap.js', 'js', '2016-07-06 15:00:37', '30501');
INSERT INTO `nozzle_resource` VALUES ('59ef392a-4347-11e6-b6a4-000c29a1f80d', 'bootstrap', '3.3.6', 'bootstrap.min.js', 'js', '2016-07-06 15:00:41', '30501');
INSERT INTO `nozzle_resource` VALUES ('697587c7-4347-11e6-b6a4-000c29a1f80d', 'jquery', '2.2.4', 'jquery.js', 'js', '2016-07-06 15:01:07', '30101');
INSERT INTO `nozzle_resource` VALUES ('6c4bd375-4347-11e6-b6a4-000c29a1f80d', 'jquery', '2.2.4', 'jquery.min.js', 'js', '2016-07-06 15:01:12', '30101');
INSERT INTO `nozzle_resource` VALUES ('b89dcf7f-4347-11e6-b6a4-000c29a1f80d', 'react', '15.2.0', 'react.js', 'js', '2016-07-06 15:03:20', '30201');
INSERT INTO `nozzle_resource` VALUES ('bb2e6ca0-4347-11e6-b6a4-000c29a1f80d', 'react', '15.2.0', 'react.min.js', 'js', '2016-07-06 15:03:24', '30201');
INSERT INTO `nozzle_resource` VALUES ('bdda1b66-4347-11e6-b6a4-000c29a1f80d', 'react', '15.2.0', 'react-dom.js', 'js', '2016-07-06 15:03:28', '30202');
INSERT INTO `nozzle_resource` VALUES ('c048b107-4347-11e6-b6a4-000c29a1f80d', 'react', '15.2.0', 'react-dom.min.js', 'js', '2016-07-06 15:03:32', '30202');
INSERT INTO `nozzle_resource` VALUES ('c706a6d7-4347-11e6-b6a4-000c29a1f80d', 'react', '15.2.0', 'react-with-addons.js', 'js', '2016-07-06 15:03:44', '30203');
INSERT INTO `nozzle_resource` VALUES ('c7e62fce-4347-11e6-b6a4-000c29a1f80d', 'react', '15.2.0', 'react-with-addons.min.js', 'js', '2016-07-06 15:03:45', '30203');
INSERT INTO `nozzle_resource` VALUES ('d75d6667-4347-11e6-b6a4-000c29a1f80d', 'nozzle', '1.0.0', 'app_components.js', 'js', '2016-07-06 15:04:11', '39905');
INSERT INTO `nozzle_resource` VALUES ('dab278b7-4347-11e6-b6a4-000c29a1f80d', 'nozzle', '1.0.0', 'app_server.js', 'js', '2016-07-06 15:04:17', '39903');
INSERT INTO `nozzle_resource` VALUES ('de2a5935-4347-11e6-b6a4-000c29a1f80d', 'nozzle', '1.0.0', 'app_helper.js', 'js', '2016-07-06 15:04:23', '39901');
INSERT INTO `nozzle_resource` VALUES ('0e8643c6-54e3-11e6-ae38-000c29b5bcfb', 'lufylegend', '1.10.1', 'lufylegend.min.js', 'js', '2016-07-29 00:48:05', '31001');
INSERT INTO `nozzle_resource` VALUES ('106f417e-54e3-11e6-ae38-000c29b5bcfb', 'lufylegend', '1.10.1', 'lufylegend.js', 'js', '2016-07-29 00:48:09', '31001');
INSERT INTO `nozzle_resource` VALUES ('28cde270-54e3-11e6-ae38-000c29b5bcfb', 'lufylegend', '1.10.1', 'lufyutil.js', 'js', '2016-07-29 00:48:50', '39910');
INSERT INTO `nozzle_resource` VALUES ('9a1641c4-54e4-11e6-ae38-000c29b5bcfb', 'lufylegend', '1.10.1', 'lufylegend.ui.min.js', 'js', '2016-07-29 00:59:09', '31002');
INSERT INTO `nozzle_resource` VALUES ('ec689980-54e5-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.min.js', 'js', '2016-07-29 01:08:37', '30602');
INSERT INTO `nozzle_resource` VALUES ('ef7b7f20-54e5-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.js', 'js', '2016-07-29 01:08:42', '30602');
INSERT INTO `nozzle_resource` VALUES ('f2250a16-54e5-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.ie8polyfill.min.js', 'js', '2016-07-29 01:08:46', '30601');
INSERT INTO `nozzle_resource` VALUES ('f5586692-54e5-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.ie8polyfill.js', 'js', '2016-07-29 01:08:52', '30601');
INSERT INTO `nozzle_resource` VALUES ('fd35ff64-54e5-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.min.css', 'css', '2016-07-29 01:09:05', '20201');
INSERT INTO `nozzle_resource` VALUES ('ff1249aa-54e5-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.css', 'css', '2016-07-29 01:09:08', '20201');
INSERT INTO `nozzle_resource` VALUES ('068c8948-54e6-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.flat.min.css', 'css', '2016-07-29 01:09:21', '20202');
INSERT INTO `nozzle_resource` VALUES ('07c7c192-54e6-11e6-ae38-000c29b5bcfb', 'amazeui', '2.7.1', 'amazeui.flat.css', 'css', '2016-07-29 01:09:23', '20202');
INSERT INTO `nozzle_resource` VALUES ('2b9f34b0-6355-11e6-8deb-000c29b5bcfb', 'es6-promise', '3.2.2', 'es6-promise.js', 'js', '2016-08-16 10:00:13', '30301');
INSERT INTO `nozzle_resource` VALUES ('2e3ab172-6355-11e6-8deb-000c29b5bcfb', 'es6-promise', '3.2.2', 'es6-promise.min.js', 'js', '2016-08-16 10:00:18', '30301');
INSERT INTO `nozzle_resource` VALUES ('880b45fc-673f-11e6-be54-000c29b5bcfb', 'nozzle', '1.0.0', 'components_bootstrap.js', 'js', '2016-08-21 09:35:24', '39910');
INSERT INTO `nozzle_resource` VALUES ('9d21d498-6c39-11e6-b276-000c29b5bcfb', 'ace', '1.2.3', 'ace.js', 'js', '2016-08-27 17:35:38', '30401');
INSERT INTO `nozzle_resource` VALUES ('a3f1ba0e-6c39-11e6-b276-000c29b5bcfb', 'ace', '1.2.3', 'mode-css.js', 'js', '2016-08-27 17:35:50', '30405');
INSERT INTO `nozzle_resource` VALUES ('a7235e6c-6c39-11e6-b276-000c29b5bcfb', 'ace', '1.2.3', 'mode-javascript.js', 'js', '2016-08-27 17:35:55', '30405');
INSERT INTO `nozzle_resource` VALUES ('a91132d0-6c39-11e6-b276-000c29b5bcfb', 'ace', '1.2.3', 'mode-sql.js', 'js', '2016-08-27 17:35:58', '30405');
INSERT INTO `nozzle_resource` VALUES ('b4c4fd1c-74dd-11e6-a09f-000c29b5bcfb', 'amazeui.react', '1.2.2', 'amazeui.react.js', 'js', '2016-09-07 17:30:25', '30701');
INSERT INTO `nozzle_resource` VALUES ('ba7a4d20-74dd-11e6-a09f-000c29b5bcfb', 'amazeui.react', '1.2.2', 'amazeui.react.min.js', 'js', '2016-09-07 17:30:34', '30701');
INSERT INTO `nozzle_resource` VALUES ('22920d12-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.css', 'css', '2016-09-07 17:33:29', '20201');
INSERT INTO `nozzle_resource` VALUES ('24c1fd72-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.min.css', 'css', '2016-09-07 17:33:32', '20201');
INSERT INTO `nozzle_resource` VALUES ('2b407958-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.flat.css', 'css', '2016-09-07 17:33:43', '20202');
INSERT INTO `nozzle_resource` VALUES ('2d808848-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.flat.min.css', 'css', '2016-09-07 17:33:47', '20202');
INSERT INTO `nozzle_resource` VALUES ('39b2491c-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.ie8polyfill.js', 'js', '2016-09-07 17:34:08', '30601');
INSERT INTO `nozzle_resource` VALUES ('3c227938-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.ie8polyfill.min.js', 'js', '2016-09-07 17:34:12', '30601');
INSERT INTO `nozzle_resource` VALUES ('4196ae8e-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.js', 'js', '2016-09-07 17:34:21', '30602');
INSERT INTO `nozzle_resource` VALUES ('4390df02-74de-11e6-a09f-000c29b5bcfb', 'amazeui', '2.5.0', 'amazeui.min.js', 'js', '2016-09-07 17:34:24', '30602');
INSERT INTO `nozzle_resource` VALUES ('2eeee94c-74e1-11e6-a09f-000c29b5bcfb', 'nozzle', '1.0.0', 'components_amazeui_react.js', 'js', '2016-09-07 17:55:18', '39911');
INSERT INTO `nozzle_resource` VALUES ('62a56396-74e2-11e6-a09f-000c29b5bcfb', 'react', '0.14.3', 'react.js', 'js', '2016-09-07 18:03:54', '30201');
INSERT INTO `nozzle_resource` VALUES ('65002180-74e2-11e6-a09f-000c29b5bcfb', 'react', '0.14.3', 'react.min.js', 'js', '2016-09-07 18:03:58', '30201');
INSERT INTO `nozzle_resource` VALUES ('6aaae282-74e2-11e6-a09f-000c29b5bcfb', 'react', '0.14.3', 'react-dom.js', 'js', '2016-09-07 18:04:08', '30202');
INSERT INTO `nozzle_resource` VALUES ('6f124784-74e2-11e6-a09f-000c29b5bcfb', 'react', '0.14.3', 'react-dom.min.js', 'js', '2016-09-07 18:04:15', '30202');
INSERT INTO `nozzle_resource` VALUES ('75fb023e-74e2-11e6-a09f-000c29b5bcfb', 'react', '0.14.3', 'react-with-addons.js', 'js', '2016-09-07 18:04:27', '30203');
INSERT INTO `nozzle_resource` VALUES ('777c8d3a-74e2-11e6-a09f-000c29b5bcfb', 'react', '0.14.3', 'react-with-addons.min.js', 'js', '2016-09-07 18:04:29', '30203');
INSERT INTO `nozzle_resource` VALUES ('4efaccb8-74e3-11e6-a09f-000c29b5bcfb', 'nozzle', '1.0.0', 'components_amazeui.js', 'js', '2016-09-07 18:10:31', '39912');
INSERT INTO `nozzle_resource` VALUES ('bb3fb3c0-78c1-11e6-9ffd-000c29b5bcfb', 'ace', '1.2.3', 'worker-css.js', 'js', '2016-09-12 16:20:14', '30406');
INSERT INTO `nozzle_resource` VALUES ('bd56a70e-78c1-11e6-9ffd-000c29b5bcfb', 'ace', '1.2.3', 'worker-html.js', 'js', '2016-09-12 16:20:18', '30406');
INSERT INTO `nozzle_resource` VALUES ('c0377e30-78c1-11e6-9ffd-000c29b5bcfb', 'ace', '1.2.3', 'worker-javascript.js', 'js', '2016-09-12 16:20:23', '30406');
INSERT INTO `nozzle_resource` VALUES ('c7757bf2-78c1-11e6-9ffd-000c29b5bcfb', 'ace', '1.2.3', 'mode-html.js', 'js', '2016-09-12 16:20:35', '30405');

-- ----------------------------
-- Table structure for `nozzle_role`
-- ----------------------------
CREATE TABLE `nozzle_role` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(50) DEFAULT NULL,
  `l10n` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_role
-- ----------------------------
INSERT INTO `nozzle_role` VALUES ('218f8fa0-5c22-11e5-ba85-00163e002daa', 'root', '系统管理员');

-- ----------------------------
-- Table structure for `nozzle_service`
-- ----------------------------
CREATE TABLE `nozzle_service` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(255) DEFAULT NULL,
  `main` text,
  `type` int(11) DEFAULT NULL,
  `isfilter` tinyint(4) DEFAULT '0',
  `datasourceid` varchar(50) DEFAULT 'systemdb',
  `createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `l10n` varchar(255) DEFAULT NULL,
  `validparam` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_service
-- ----------------------------

-- ----------------------------
-- Table structure for `nozzle_service_param`
-- ----------------------------
CREATE TABLE `nozzle_service_param` (
  `serviceid` varchar(50) NOT NULL DEFAULT '',
  `paramid` varchar(50) NOT NULL DEFAULT '',
  `ordernum` int(11) DEFAULT NULL,
  PRIMARY KEY (`serviceid`,`paramid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `nozzle_user_role`
-- ----------------------------
CREATE TABLE `nozzle_user_role` (
  `userid` varchar(50) NOT NULL DEFAULT '',
  `roleid` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`userid`,`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_user_role
-- ----------------------------
INSERT INTO `nozzle_user_role` VALUES ('C399C147E57D4eD0b67Cd8fA30a37F6c', '218f8fa0-5c22-11e5-ba85-00163e002daa');

-- ----------------------------
-- Table structure for `nozzle_valid`
-- ----------------------------
CREATE TABLE `nozzle_valid` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `type` varchar(20) DEFAULT NULL,
  `servicename` varchar(50) DEFAULT NULL,
  `regexp` varchar(500) DEFAULT NULL,
  `errormsg` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of nozzle_valid
-- ----------------------------
