Kezdőlap Felfedezés Súgó
Bejelentkezés
sin
/
flytalk
2
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Fa: 678e456da6
Branch-ok Tag-ek
flytalk
/
config
/
go-fly.sql

go-fly.sql 12 KB
Előzmények Nyers

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133 
  1. DROP TABLE IF EXISTS `user`|
    2. 

  2. CREATE TABLE `user` (
    3. 

  3.  `id` int(11) NOT NULL AUTO_INCREMENT,
    4. 

  4.  `name` varchar(50) NOT NULL DEFAULT '',
    5. 

  5.  `password` varchar(50) NOT NULL DEFAULT '',
    6. 

  6.  `nickname` varchar(50) NOT NULL DEFAULT '',
    7. 

  7.  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    8. 

  8.  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    9. 

  9.  `deleted_at` timestamp NULL DEFAULT NULL,
    10. 

  10.  `avator` varchar(100) NOT NULL DEFAULT '',
    11. 

  11.  `enabled` tinyint(2) not null default 1,
    12. 

  12.  PRIMARY KEY (`id`),
    13. 

  13.  KEY `idx_name` (`name`)
    14. 

  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    15. 

  15. TRUNCATE TABLE `user`|
    16. 

  16. INSERT INTO `user` (`id`, `name`, `password`, `nickname`, `created_at`, `updated_at`, `deleted_at`, `avator`) VALUES
    17. 

  17. (1, 'kefu2', '202cb962ac59075b964b07152d234b70', '阿元', '2020-06-27 19:32:41', '2020-07-04 09:32:20', NULL, '/static/images/4.jpg'),
    18. 

  18. (2, 'kefu', '202cb962ac59075b964b07152d234b70', '宝儿', '2020-07-02 14:36:46', '2020-07-05 08:46:57', NULL, '/static/images/11.jpg')|
    19. 

  19. 

  20. DROP TABLE IF EXISTS `visitor`|
    21. 

  21. CREATE TABLE `visitor` (
    22. 

  22.  `id` int(11) NOT NULL AUTO_INCREMENT,
    23. 

  23.  `name` varchar(50) NOT NULL DEFAULT '',
    24. 

  24.  `avator` varchar(500) NOT NULL DEFAULT '',
    25. 

  25.  `source_ip` varchar(50) NOT NULL DEFAULT '',
    26. 

  26.  `to_id` varchar(50) NOT NULL DEFAULT '',
    27. 

  27.  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    28. 

  28.  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    29. 

  29.  `deleted_at` timestamp NULL DEFAULT NULL,
    30. 

  30.  `visitor_id` varchar(100) NOT NULL DEFAULT '',
    31. 

  31.  `status` tinyint(4) NOT NULL DEFAULT '0',
    32. 

  32.  `refer` varchar(500) NOT NULL DEFAULT '',
    33. 

  33.  `city` varchar(100) NOT NULL DEFAULT '',
    34. 

  34.  `client_ip` varchar(100) NOT NULL,
    35. 

  35.  PRIMARY KEY (`id`),
    36. 

  36.  UNIQUE KEY `visitor_id` (`visitor_id`)
    37. 

  37. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    38. 

  38. 

  39. DROP TABLE IF EXISTS `message`|
    40. 

  40. CREATE TABLE `message` (
    41. 

  41.  `id` int(11) NOT NULL AUTO_INCREMENT,
    42. 

  42.  `kefu_id` varchar(100) NOT NULL DEFAULT '',
    43. 

  43.  `visitor_id` varchar(100) NOT NULL DEFAULT '',
    44. 

  44.  `content` varchar(2048) NOT NULL DEFAULT '',
    45. 

  45.  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    46. 

  46.  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    47. 

  47.  `deleted_at` timestamp NULL DEFAULT NULL,
    48. 

  48.  `mes_type` enum('kefu','visitor') NOT NULL DEFAULT 'visitor',
    49. 

  49.  `status` enum('read','unread') NOT NULL DEFAULT 'unread',
    50. 

  50.  PRIMARY KEY (`id`),
    51. 

  51.  KEY `kefu_id` (`kefu_id`),
    52. 

  52.  KEY `visitor_id` (`visitor_id`),
    53. 

  53.  KEY `visitor_kefu_id` (`kefu_id`,`visitor_id`) USING BTREE
    54. 

  54. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    55. 

  55. 

  56. DROP TABLE IF EXISTS `user_role`|
    57. 

  57. CREATE TABLE `user_role` (
    58. 

  58.  `id` int(11) NOT  NULL AUTO_INCREMENT,
    59. 

  59.  `user_id` int(11) NOT NULL DEFAULT '0',
    60. 

  60.  `role_id` int(11) NOT NULL DEFAULT '0',
    61. 

  61.  PRIMARY KEY (`id`)
    62. 

  62. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8|
    63. 

  63. INSERT INTO `user_role` (`id`, `user_id`, `role_id`) VALUES
    64. 

  64. (1, 1, 1),
    65. 

  65. (2, 2, 2)|
    66. 

  66. 

  67. DROP TABLE IF EXISTS `role`|
    68. 

  68. CREATE TABLE `role` (
    69. 

  69.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    70. 

  70.   `name` varchar(100) NOT NULL DEFAULT '',
    71. 

  71.   `method` varchar(100) NOT NULL DEFAULT '',
    72. 

  72.   `path` varchar(2048) NOT NULL DEFAULT '',
    73. 

  73.    PRIMARY KEY (`id`)
    74. 

  74. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    75. 

  75. INSERT INTO `role` (`id`, `name`, `method`, `path`) VALUES
    76. 

  76. (1, '普通客服', 'GET', '/kefuinfo,/kefulist,/roles'),
    77. 

  77. (2, '管理员', '*', '*')|
    78. 

  78. 

  79. DROP TABLE IF EXISTS `welcome`|
    80. 

  80. CREATE TABLE `welcome` (
    81. 

  81.  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    82. 

  82.  `user_id` varchar(100) NOT NULL DEFAULT '',
    83. 

  83.  `content` varchar(500) NOT NULL DEFAULT '',
    84. 

  84.  `is_default` tinyint(3) unsigned NOT NULL DEFAULT '0',
    85. 

  85.  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    86. 

  86.  PRIMARY KEY (`id`),
    87. 

  87.  KEY `user_id` (`user_id`)
    88. 

  88. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    89. 

  89. INSERT INTO `welcome` (`id`, `user_id`, `content`, `is_default`, `ctime`) VALUES
    90. 

  90. (1, 'kefu2', '您好,在呢!', 1, '2020-08-24 02:57:49')|
    91. 

  91. 

  92. DROP TABLE IF EXISTS `ipblack`|
    93. 

  93. CREATE TABLE `ipblack` (
    94. 

  94.  `id` int(11) NOT NULL AUTO_INCREMENT,
    95. 

  95.  `ip` varchar(100) NOT NULL DEFAULT '',
    96. 

  96.  `create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    97. 

  97.  `kefu_id` varchar(100) NOT NULL DEFAULT '',
    98. 

  98.  PRIMARY KEY (`id`),
    99. 

  99.  UNIQUE KEY `ip` (`ip`)
    100. 

  100. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    101. 

  101. 

  102. DROP TABLE IF EXISTS `config`|
    103. 

  103. CREATE TABLE `config` (
    104. 

  104.  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    105. 

  105.  `conf_name` varchar(255) NOT NULL DEFAULT '',
    106. 

  106.  `conf_key` varchar(255) NOT NULL DEFAULT '',
    107. 

  107.  `conf_value` varchar(255) NOT NULL DEFAULT '',
    108. 

  108.  PRIMARY KEY (`id`),
    109. 

  109.  UNIQUE KEY `conf_key` (`conf_key`)
    110. 

  110. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    111. 

  111. INSERT INTO `config` (`id`, `conf_name`, `conf_key`, `conf_value`) VALUES (NULL, '是否开启Server酱微信提醒', 'NoticeServerJiang', 'false')|
    112. 

  112. INSERT INTO `config` (`id`, `conf_name`, `conf_key`, `conf_value`) VALUES (NULL, 'Server酱API', 'ServerJiangAPI', '')|
    113. 

  113. INSERT INTO `config` (`id`, `conf_name`, `conf_key`, `conf_value`) VALUES (NULL, '微信小程序Token', 'WeixinToken', '')|
    114. 

  114. INSERT INTO `config` (`id`, `conf_name`, `conf_key`, `conf_value`) VALUES (NULL, '首页跳转语言', 'JumpLang', 'cn')|
    115. 

  115. 

  116. DROP TABLE IF EXISTS `about`|
    117. 

  117. CREATE TABLE `about` (
    118. 

  118.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    119. 

  119.   `title_cn` varchar(255) NOT NULL DEFAULT '',
    120. 

  120.   `title_en` varchar(255) NOT NULL DEFAULT '',
    121. 

  121.   `keywords_cn` varchar(255) NOT NULL DEFAULT '',
    122. 

  122.   `keywords_en` varchar(255) NOT NULL DEFAULT '',
    123. 

  123.   `desc_cn` varchar(1024) NOT NULL DEFAULT '',
    124. 

  124.   `desc_en` varchar(1024) NOT NULL DEFAULT '',
    125. 

  125.   `css_js` text NOT NULL,
    126. 

  126.   `html_cn` text NOT NULL,
    127. 

  127.   `html_en` text NOT NULL,
    128. 

  128.   `page` varchar(50) NOT NULL DEFAULT '',
    129. 

  129. PRIMARY KEY (`id`),
    130. 

  130. UNIQUE KEY `page` (`page`)
    131. 

  131. ) ENGINE=InnoDB DEFAULT CHARSET=utf8|
    132. 

  132. INSERT INTO `about` (`id`, `title_cn`, `title_en`, `keywords_cn`, `keywords_en`, `desc_cn`, `desc_en`, `css_js`, `html_cn`, `html_en`, `page`) VALUES
    133. 

  133. (NULL, '在线客服系统', 'Customer service system', '客服,后台', 'twong, customer service', '专注效率,服务客户', 'For effectiveneww,for customers', '    <style>\n        *{\n            margin: 0;padding: 0;\n        }\n        .header{\n            height: 80px;\n            background-color: #fff;\n            color: #fff;\n            top: 0;\n            left: 0;\n            width: 100%;\n            line-height: 80px;\n            z-index: 100;\n            position: relative;\n        }\n        .container{\n            width: 1140px;\n            padding: 0;\n            margin: 0 auto;\n        }\n        .header .container{\n            height: 100%;\n            box-sizing: border-box;\n            border-bottom: 1px solid #dcdfe6;\n        }\n        .header h1{\n            margin: 0;\n            float: left;\n            font-size: 32px;\n            font-weight: 400;\n        }\n        .header a{\n            color: #519eff;\n            font-family: \"Microsoft JhengHei\";\n            text-decoration: none;\n        }\n        .header h1 a{\n            font-size: 30px;\n            font-weight: bold;\n        }\n        .header .navBtn{\n            float: right;\n            margin-left: 20px;\n        }\n        .banner{\n            padding-top: 20px;\n            text-align: center;\n        }\n        .banner h1{\n            font-size: 34px;\n            margin: 0;\n            line-height: 48px;\n            color: #555;\n            font-weight: 500;\n            font-family: Helvetica Neue,Helvetica,PingFang SC,Hiragino Sans GB,Microsoft YaHei,SimSun,sans-serif;\n        }\n        .banner p{\n            font-size: 18px;\n            line-height: 28px;\n            color: #888;\n            margin: 10px 0 5px;\n        }\n        .jumbotron{\n            width: 587px;\n            height: 560px;\n            margin: 30px auto;\n        }\n        .footer {\n            clear: both;\n            background-color: #f7fbfd;\n            width: 100%;\n            padding: 40px 150px;\n            box-sizing: border-box;\n        }\n        .copyright{\n            color: #6c757d;\n            text-align: center;\n            margin: 60px 0;\n        }\n        .mainTechLeft{\n            width: 300px;\n            float: left;\n        }\n        .mainTechLeft h1{\n            font-size: 34px;\n            margin: 0;\n            line-height: 48px;\n            color: #555;\n            font-weight: 500;\n            font-family: Helvetica Neue,Helvetica,PingFang SC,Hiragino Sans GB,Microsoft YaHei,SimSun,sans-serif;\n        }\n        .mainTechLeft p{\n            font-size: 18px;\n            line-height: 28px;\n            color: #888;\n            margin: 10px 0 5px;\n        }\n        .floatRight{\n            width: 700px;\n            border: 1px solid #e1e1e1;\n            padding: 4px;\n            margin-top: 35px;\n            display: block;\n            float: right;\n        }\n    </style>', '<header class=\"header\">\n    <div class=\"container\">\n        <h1><a href=\"/\">GO-FLY</a></h1>\n        <a class=\"navBtn\" href=\"/index_en\">English (United States)</a>\n        <a class=\"navBtn\" href=\"/index_cn\">中文版 (简体)</a>\n        <a class=\"navBtn\" href=\"https://github.com/taoshihan1991/go-fly\" target=\"_blank\">Github</a>\n        <a class=\"navBtn\" href=\"/login\">客服入口</a>\n        <a class=\"navBtn\" href=\"/docs/index.html\" target=\"_blank\">接口文档</a>\n    </div>\n</header>\n<div class=\"banner\">\n    <h1>极简强大的Go语言在线客服系统</h1>\n    <p>GO-FLY，一套为PHP工程师、Golang工程师准备的基于 Vue 2.0的在线客服即时通讯系统</p>\n</div>\n<div class=\"jumbotron\">\n    \n    <img src=\"/static/images/intro1.jpg\"/>\n    \n</div>\n<div class=\"container\">\n    <div class=\"mainTechLeft\">\n        <h1>主要技术架构</h1>\n        <p>github.com/dgrijalva/jwt-go</p>\n        <p>github.com/gin-gonic/gin</p>\n        <p> github.com/go-sql-driver/mysql</p>\n        <p>  github.com/gobuffalo/packr/v2</p>\n        <p>  github.com/gorilla/websocket</p>\n        <p>   github.com/ipipdotnet/ipdb-go</p>\n        <p>    github.com/jinzhu/gorm</p>\n        <p>    github.com/satori/go.uuid</p>\n        <p>   github.com/spf13/cobra</p>\n        <p>   github.com/swaggo/gin-swagger</p>\n        <p>  github.com/swaggo/swag\n        </p>\n    </div>\n    <img src=\"/static/images/admin.png\" class=\"floatRight\"/>\n</div>\n\n\n<footer class=\"footer\">\n    <div class=\"container\">\n\n    </div>\n    <div class=\"copyright\">\n        陶士涵的菜地版权所有&copy; 2020\n    </div>\n</footer>', '<header class=\"header\">\n    <div class=\"container\">\n        <h1><a href=\"/\">GO-FLY</a></h1>\n        <a class=\"navBtn\" href=\"/index_en\">English (United States)</a>\n        <a class=\"navBtn\" href=\"/index_cn\">中文版 (简体)</a>\n        <a class=\"navBtn\" href=\"https://github.com/taoshihan1991/go-fly\" target=\"_blank\">Github</a>\n        <a class=\"navBtn\" href=\"/login\">Agents Here</a>\n        <a class=\"navBtn\" href=\"/docs/index.html\" target=\"_blank\">API Documents</a>\n    </div>\n</header>\n<div class=\"banner\">     <h1>Simple and Powerful Go language online customer chat system</h1>     <p>GO-FLY, a Vue 2.0-based online customer service instant messaging system for PHP engineers and Golang engineers</p> </div> <div class=\"jumbotron\">          <img src=\"/static/images/intro3.png\"/>      </div> <div class=\"container\">     <div class=\"mainTechLeft\">         <h1>Main technical architecture</h1>         <p>github.com/dgrijalva/jwt-go</p>         <p>github.com/gin-gonic/gin</p>         <p> github.com/go-sql-driver/mysql</p>         <p>  github.com/gobuffalo/packr/v2</p>         <p>  github.com/gorilla/websocket</p>         <p>   github.com/ipipdotnet/ipdb-go</p>         <p>    github.com/jinzhu/gorm</p>         <p>    github.com/satori/go.uuid</p>         <p>   github.com/spf13/cobra</p>         <p>   github.com/swaggo/gin-swagger</p>         <p>  github.com/swaggo/swag         </p>     </div>     <img src=\"/static/images/admin.png\" class=\"floatRight\"/> </div>\n\n\n<footer class=\"footer\">\n    <div class=\"container\">\n\n    </div>\n    <div class=\"copyright\">\n        Twong Team&copy; 2020\n    </div>\n</footer>', 'index')|
    134.