data.sql 2.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : localhost
  4. Source Server Type : MySQL
  5. Source Server Version : 50718
  6. Source Host : localhost
  7. Source Database : svm
  8. Target Server Type : MySQL
  9. Target Server Version : 50718
  10. File Encoding : utf-8
  11. Date: 07/14/2017 13:46:45 PM
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for `data`
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `data`;
  19. CREATE TABLE `data` (
  20. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  21. `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '项目id',
  22. `sql` text NOT NULL,
  23. `remark` varchar(20) NOT NULL DEFAULT '',
  24. `time` int(10) unsigned NOT NULL DEFAULT '0',
  25. `eids` varchar(255) NOT NULL DEFAULT '' COMMENT '没有操作的环境id列表',
  26. PRIMARY KEY (`id`)
  27. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='数据';
  28. -- ----------------------------
  29. -- Table structure for `env`
  30. -- ----------------------------
  31. DROP TABLE IF EXISTS `env`;
  32. CREATE TABLE `env` (
  33. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  34. `name` varchar(20) NOT NULL DEFAULT '',
  35. `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '项目id',
  36. `host` varchar(20) NOT NULL DEFAULT '',
  37. `user` varchar(20) NOT NULL DEFAULT '',
  38. `password` varchar(20) NOT NULL DEFAULT '',
  39. `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1.远程模式-执行sql,2.本地模式-手动复杂',
  40. PRIMARY KEY (`id`)
  41. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='环境';
  42. -- ----------------------------
  43. -- Table structure for `project`
  44. -- ----------------------------
  45. DROP TABLE IF EXISTS `project`;
  46. CREATE TABLE `project` (
  47. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  48. `name` varchar(20) NOT NULL DEFAULT '',
  49. `dbname` varchar(20) NOT NULL DEFAULT '' COMMENT '数据库名',
  50. PRIMARY KEY (`id`)
  51. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='项目';
  52. SET FOREIGN_KEY_CHECKS = 1;