util-sql/sample_sql.go at master · zr-hebo/util-sql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
package sqlutil

var testSQLs = []string{
	"show create table student(id int, name varchar(64) comment 'a student name; maybe empty; eg:zhangsan', age int)",
	"INSERT INTO `event_ticket` (`detail`) VALUES (\"*/&lt;/p&gt;\");",
	"/* asdfasfdsdf */delete from abc",
	"-- ----------------------------\n" +
		"-- Table structure for osc" +
		"-- ----------------------------\n",
	"-- ----------------------------\n" +
		"-- Table structure for osc\n" +
		"-- ----------------------------\n" +
		"DROP TABLE IF EXISTS `osc`; " +
		"CREATE TABLE `osc` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id', `appename` varchar(32) NOT NULL COMMENT '应用英文名', `keyspace` varchar(32) DEFAULT NULL COMMENT '逻辑库', `tablename` varchar(128) DEFAULT NULL COMMENT '表名', `shard` varchar(16) DEFAULT NULL COMMENT '分片', `host` varchar(64) DEFAULT NULL COMMENT 'host', `alter` varchar(256) DEFAULT NULL COMMENT 'alter语句', `status` int(11) DEFAULT NULL COMMENT '状态', `message` text COMMENT '信息', `createtime` timestamp NOT NULL DEFAULT '2017-01-01 00:00:00' COMMENT '创建时间', `updatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n-- ----------------------------\n-- Records of osc\n-- ----------------------------\n",
	"begin;delete from messages where 1 =1;INSERT into messages(page, time_created_ns, message) values('10', 1, 1), ('20', 2, 1), ('30', 3, 1), ('40', 4, 1);update messages set message='2' where message='1';select * from messages where 1 =1;commit;",
	"CREATE TABLE if not exists `student` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL DEFAULT '' comment 'haha', `age` int NOT NULL DEFAULT 0 comment 'age for student;', `class` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`id`));select * from student;",
	"-- \n" +
		"-- Dumping data for table `dbsv3_users`\n" +
		"-- LOCK TABLES `dbsv3_users` WRITE;\n" +
		"/*!40000 ALTER TABLE `dbsv3_users` DISABLE KEYS */; \n",
	"/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\n" +
		"/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\n" +
		"/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\n",
	"--\n" +
		"-- Table structure for table `dbsv3_users`; is important\n" +
		"--",
	"show create table student(id int, name varchar(64) comment 'a student name; maybe empty; eg:zhangsan', age int)",
	`set @sharding = 't_news_comments_reply singleShard'
CREATE TABLE t_news_comments_reply (
  ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  PARTENT_ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT '父级标识,如果该条记录是评论，此字段代表新闻id；如果该条记录是回复，此字段代表评论id或上级回复id',
  CONTENT varchar(2000) DEFAULT NULL COMMENT '评论或回复内容',
  IS_ANONYMOUS int(4) DEFAULT 0 comment '是否匿名(特指评论), 1:匿名, 0:非匿名',
  OPERATION_TYPE int(4) DEFAULT 1 comment '操作类型, 1:评论, 2:回复;',
  PUBLISH_TIME timestamp NULL DEFAULT NULL COMMENT '评论或回复时间;',
  DELFLAG tinyint(4) DEFAULT NULL COMMENT '是否删除，1：删除;0：使用',
  CREATOR varchar(256) DEFAULT NULL COMMENT '创建者',
  CREATETIME timestamp NULL DEFAULT NULL COMMENT '创建时间',
  UPDATER varchar(256) DEFAULT NULL COMMENT '最后修改者',
  UPDATETIME timestamp NULL DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='评论-回复表';`,
	`set @sharding = 't_news singleShard'
CREATE TABLE t_news (
  ID bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  TITLE varchar(1000) DEFAULT NULL COMMENT '新闻标题',
  SUB_TITLE varchar(2000) DEFAULT NULL COMMENT '新闻副标题',
  TYPE int(4) DEFAULT 1 comment '新闻类型, 1:文字新闻; 2:图片新闻; 3:重点资讯; 4:平台资讯',
  PUBLISH_STATUS int(4) DEFAULT 0 comment '发布状态, 1:发布, 0:未发布',
  VALIDITY_START timestamp NULL DEFAULT NULL COMMENT '有效期开始时间',
  VALIDITY_END timestamp NULL DEFAULT NULL COMMENT '有效期结束时间',
  IMPORT_LEVEL int(4) DEFAULT 1 comment '重要等级, 1:一般, 2:中等, 3：重要',
  IS_COMMENTS int(4) DEFAULT 0 comment '是否可以被评论, 1:可以, 0:不可以;',
  PUBLISH_TIME timestamp NULL DEFAULT NULL COMMENT '新闻发布时间',
  HITS bigint(20) DEFAULT NULL COMMENT '点击量',
  DELFLAG tinyint(4) DEFAULT NULL COMMENT '是否删除，1：删除，0：使用',
  REMOTEURL varchar(512) DEFAULT NULL COMMENT '云端地址',
  CREATOR varchar(256) DEFAULT NULL COMMENT '创建者',
  CREATETIME timestamp NULL DEFAULT NULL COMMENT '创建时间',
  UPDATER varchar(256) DEFAULT NULL COMMENT '最后修改者',
  UPDATETIME timestamp NULL DEFAULT NULL COMMENT '最后修改时间',
  PRIMARY KEY (ID)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='新闻表';`,
}