create table _Visit

(

model varchar(15),

id bigint,

operate tinyint,

date datetime

)

create table Access

(

id bigint not null

constraint Access_pk

primary key nonclustered,

debug tinyint not null,

name varchar(50) not null,

alias varchar(20),

get varchar(100),

head varchar(100),

gets varchar(100),

heads varchar(100),

post varchar(100),

put varchar(100),

[delete] varchar(100),

date datetime default getdate() not null

)

exec sp_addextendedproperty 'MS_Description', '权限配置', 'SCHEMA', 'dbo', 'TABLE', 'Access'

exec sp_addextendedproperty 'MS_Description', '唯一标识', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN', 'id'

exec sp_addextendedproperty 'MS_Description', '是否为调试表，只允许在开发环境', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN', 'debug'

exec sp_addextendedproperty 'MS_Description', '外部调用的表别名，例如 User', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN', 'alias'

exec sp_addextendedproperty 'MS_Description', '允许 get 的角色列表，例如 ["LO', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN',

'get'

exec sp_addextendedproperty 'MS_Description', '允许 head 的角色列表，例如 ["L', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN',

'head'

exec sp_addextendedproperty 'MS_Description', '允许 gets 的角色列表，例如 ["L', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN',

'gets'

exec sp_addextendedproperty 'MS_Description', '允许 heads 的角色列表，例如 ["', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN',

'heads'

exec sp_addextendedproperty 'MS_Description', '允许 post 的角色列表，例如 ["L', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN',

'post'

exec sp_addextendedproperty 'MS_Description', '允许 put 的角色列表，例如 ["LO', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN',

'put'

exec sp_addextendedproperty 'MS_Description', '允许 delete 的角色列表，例如 [', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN',

'delete'

exec sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', 'dbo', 'TABLE', 'Access', 'COLUMN', 'date'

create unique index Access_id_uindex

on Access (id)

create unique index Access_name_uindex

on Access (name)

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (1, 0, 'Access', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2019-07-21 20:21:36.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (2, 1, 'Table', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:14.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (3, 1, 'Column', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:14.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (4, 0, 'Function', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:15.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (5, 0, 'Request', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:14.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (6, 0, 'Response', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:15.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (7, 1, 'Document', null, '["LOGIN", "ADMIN"]', '["LOGIN", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["LOGIN", "ADMIN"]', '["OWNER", "ADMIN"]', '2018-11-29 00:38:15.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (8, 1, 'TestRecord', null, '["LOGIN", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '2018-11-29 00:38:15.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (9, 0, 'Test', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:15.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (10, 1, 'PgAttribute', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:14.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (11, 1, 'PgClass', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2018-11-29 00:38:14.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (12, 0, 'Login', null, '[]', '[]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[ "ADMIN"]', '[ "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (13, 0, 'Verify', null, '[]', '[]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[ "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (14, 0, 'apijson_user', 'User', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2018-11-29 00:28:53.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (15, 0, 'apijson_privacy', 'Privacy', '[]', '[]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["UNKNOWN","LOGIN","OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["ADMIN"]', '2018-11-29 00:29:48.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (16, 0, 'Moment', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '2018-11-29 00:29:19.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (17, 0, 'Comment', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '["OWNER", "ADMIN"]', '2018-11-29 00:29:19.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (19, 1, 'SysTable', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2019-10-04 09:01:20.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (20, 1, 'SysColumn', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2019-10-04 09:01:20.000');

INSERT INTO pubs.dbo.Access (id, debug, name, alias, get, head, gets, heads, post, put, [delete], date) VALUES (21, 1, 'ExtendedProperty', null, '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["UNKNOWN", "LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '["LOGIN", "CONTACT", "CIRCLE", "OWNER", "ADMIN"]', '[]', '[]', '[]', '2019-10-04 09:33:45.000');

create table apijson_privacy

(

id bigint,

certified tinyint,

phone bigint,

balance decimal(10, 2),

_password varchar(20),

_payPassword int

)

exec sp_addextendedproperty 'MS_Description', '用户隐私信息表。

对安全要求高', 'SCHEMA', 'dbo', 'TABLE', 'apijson_privacy'

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (38710, 1, 13000038710, 33376.00, 'apijson', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (70793, 0, 13000070793, 56000.00, 'apijson', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82001, 1, 13000082001, 78468.60, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82002, 1, 13000082002, 6817.23, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82003, 1, 13000082003, 2000.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82004, 0, 13000082004, 2000.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82005, 0, 13000082005, 1923.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82006, 0, 13000082006, 2000.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82009, 0, 13000082009, 2000.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82012, 0, 13000082012, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82020, 0, 12345678900, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82021, 0, 12345678901, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82022, 0, 12345678902, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82023, 0, 12345678903, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82024, 0, 12345678904, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82025, 0, 12345678905, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82026, 0, 12345678906, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82027, 0, 12345678907, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82028, 0, 12345678908, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82029, 0, 12345678909, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82030, 0, 12345678910, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82031, 0, 12345678911, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82032, 0, 12345678912, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82033, 0, 12345678913, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82034, 0, 12345678914, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82035, 0, 12345678915, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82036, 0, 12345678916, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82037, 0, 12345678917, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82038, 0, 12345678918, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82039, 0, 12345678919, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82040, 0, 13000082019, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82041, 0, 13000082015, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82042, 0, 13000082016, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82043, 0, 13000082017, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82044, 0, 13000082018, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82045, 0, 13000082020, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82046, 0, 13000082010, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82047, 0, 13000082021, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82048, 0, 13000038711, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82049, 0, 13000038712, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82050, 0, 13000038713, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82051, 0, 13000038714, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82052, 0, 13000038715, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82053, 0, 13000038720, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82054, 0, 13000038721, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82055, 0, 13000082030, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82056, 0, 13000082040, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82057, 0, 13000038730, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82058, 0, 13000038750, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82059, 0, 13000082033, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (82060, 0, 13000082050, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (90814, 1, 13000090814, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (93793, 1, 13000093793, 3000.00, 'apijson', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (93794, 0, 99999999999, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1490109742863, 0, 13000082100, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1490109845208, 0, 13000082101, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1490420651686, 0, 13000038716, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1490427139175, 0, 13000038717, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1490427577823, 0, 13000082102, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1490584952968, 0, 13000038790, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1490973670928, 0, 13000082051, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1492936169722, 0, 13000093794, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493480142628, 0, 13000038888, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493747512860, 0, 13000038777, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493747777770, 0, 13000038778, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493748594003, 0, 13000038779, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493748615711, 0, 13000038780, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493749090643, 0, 13000038781, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493836043151, 0, 13000038999, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493883110132, 0, 13000039999, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493890214167, 0, 13000031000, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493890303473, 0, 13000031001, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1493890303474, 0, 13000088888, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1497792972314, 0, 13000082111, 0.00, '654321', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1499057230629, 0, 13000082011, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1500825221910, 0, 13000099999, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1502639062900, 0, 13000082222, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1502639424119, 0, 13000082333, 0.00, '12345678', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1507220582167, 0, 13000011111, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1508072071492, 0, 13000071492, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1508072105320, 0, 13000082008, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1508072160401, 0, 13000082007, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1508072202871, 0, 13000082031, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1510495628760, 0, 13000082000, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1511407581570, 0, 17610725819, 0.00, '123123', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1511761906715, 0, 13708222312, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1511965911349, 0, 13000083333, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1512387063078, 0, 15858585858, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1512531601485, 0, 18210847727, 0.00, '5816136', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1514623064133, 0, 13000038725, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1514625918255, 0, 13000038726, 255.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1514626163032, 0, 13000038727, 4951.37, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1514858422969, 0, 13000082041, 164.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1515565976140, 0, 15009257563, 0.00, 'qazwsx', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1518218350585, 0, 18663689263, 0.00, 'cherish751220', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1519778917280, 0, 15000536915, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1520242280259, 0, 18917212395, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1521274648008, 0, 18989491914, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1521371722416, 0, 13000088889, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1521374327542, 0, 13000056789, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1523626157302, 0, 15603313259, 0.00, '15603313259', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1523935772553, 0, 15603313258, 0.00, '15603313258', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1524042900591, 0, 15222297100, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1524298730523, 0, 17854217949, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1524878698882, 0, 13917451840, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1525677515673, 0, 13390935538, 10000.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1527495857924, 0, 13142033345, 15.00, 'qweasd', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1527498229991, 0, 13142033342, 0.00, 'qweasd', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1527821445610, 0, 13142033346, 0.00, 'qweasd', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1528250827953, 0, 15122820115, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1528254173621, 0, 15225556855, 200.00, 'lmt970208', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1528255497767, 0, 15822798927, 0.00, '111111', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1528264711016, 0, 15620878773, 0.00, '111111', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1528339692804, 0, 15122541683, 0.00, '568599', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1528344980598, 0, 15188899797, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1528356470041, 0, 15620878772, 0.00, '111111', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1531969715979, 0, 13800138000, 10000.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1532188114543, 0, 13977757845, 20360.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1532439021068, 0, 18779607703, 0.00, '15879684798qq', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1533835176109, 0, 13977757846, 1700.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1534926301956, 0, 17602120205, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1538504264944, 0, 13000087654, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1538504500574, 0, 13000087655, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1538987952996, 0, 18662327672, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1541583762603, 0, 18689846285, 0.00, 'jyt123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1544276209348, 0, 13000087656, 1050.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1544503822963, 0, 13000082968, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1545707526805, 0, 13533039558, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1545895694424, 0, 13533039550, 357.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1547177436600, 0, 18980210241, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1548068043688, 0, 17181595855, 0.00, '0812563993gg', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1553095415917, 0, 13185236871, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1553527700480, 0, 13189758117, 0.00, '3802489', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1559129626356, 0, 13000000000, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1560409157504, 0, 18030546471, 0.00, '123456789', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1561539257158, 0, 15870873323, 0.00, '123qwe', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1563605318975, 0, 13590330481, 0.00, '123456', 123456);

INSERT INTO pubs.dbo.apijson_privacy (id, certified, phone, balance, _password, _payPassword) VALUES (1570529238569, 0, 15669090286, 0.00, 'jiaojun2jj', 123456);

create table apijson_user

(

id bigint,

sex tinyint,

name varchar(20),

tag varchar(45),

head varchar(300),

contactIdList text,

pictureList text,

date datetime

)

exec sp_addextendedproperty 'MS_Description', '用户公开信息表。

对安全要求高', 'SCHEMA', 'dbo', 'TABLE', 'apijson_user'

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1524878698882, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-04-28 09:24:58.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1525677515673, 0, 'APIJSONUser', null, 'http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000', '[82003, 82002, 38710]', null, '2018-05-07 15:18:35.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1527495857924, 0, 'account', null, 'https://ss3.bdstatic.com/70cFv8Sh_Q1YnxGkpoWK1HF6hhy/it/u=2510057322,2452415311&fm=27&gp=0.jpg', '[1527821445610, 82012]', null, '2018-05-28 16:24:17.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1527498229991, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1499057230629]', null, '2018-05-28 17:03:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1527821445610, 0, 'accountt', null, 'http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000', '[1527495857924]', null, '2018-06-01 10:50:45.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1528250827953, 1, 'limengt', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1528264711016]', null, '2018-06-06 10:07:07.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1528254173621, 1, 'A', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82001, 38710]', null, '2018-06-06 11:02:53.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1528255497767, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82002]', null, '2018-06-06 11:24:57.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1528264711016, 0, '梦', null, 'http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000', '[82021, 1528250827953]', null, '2018-06-06 13:58:31.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1528339692804, 1, '568599', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1528250827953, 1528264711016]', null, '2018-06-07 10:48:12.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1528344980598, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-06-07 12:16:20.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1528356470041, 0, 'aaaa', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1528339692804]', null, '2018-06-07 15:27:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1531969715979, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82002, 82003, 82005]', null, '2018-07-19 11:08:35.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1532188114543, 0, '宁旭', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-07-21 23:48:34.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1532439021068, 0, 'huxiaofan', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[38710, 82002, 82003, 82006, 82021]', null, '2018-07-24 21:30:21.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1533835176109, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1532188114543]', null, '2018-08-10 01:19:36.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1534926301956, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82003, 82002, 82025]', null, '2018-08-22 16:25:01.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1538504264944, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-10-03 02:17:44.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1538504500574, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-10-03 02:21:40.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1538987952996, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-10-08 16:39:13.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1541583762603, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-11-07 17:42:42.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1544276209348, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82002, 38710]', null, '2018-12-08 21:36:49.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1544503822963, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[93793, 82003]', null, '2018-12-11 12:50:22.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1545707526805, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-12-25 11:12:06.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1545895694424, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-12-27 15:28:14.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1547177436600, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2019-01-11 11:30:36.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1548068043688, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2019-01-21 18:54:03.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1553095415917, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82001]', null, '2019-03-20 23:23:35.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1553527700480, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2019-03-25 23:28:20.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1559129626356, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1507220582167]', null, '2019-05-29 19:33:46.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1560409157504, 0, '上邪', null, '最好的时光', null, null, '2019-06-13 14:59:17.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1561539257158, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2019-06-26 16:54:17.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1563605318975, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2019-07-20 14:48:38.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1570529238569, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2019-10-08 18:07:18.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (93794, 0, 'Lemon', null, 'http://static.oschina.net/uploads/user/48/97721_50.jpg?t=1451544779000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1490109742863, 1, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-03-21 23:22:22.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1490109845208, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-03-21 23:24:05.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1490420651686, 1, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[70793]', '[]', '2017-03-25 13:44:11.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1490427139175, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[38710, 70793]', '[]', '2017-03-25 15:32:19.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1490427577823, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-03-25 15:39:37.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1490584952968, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-03-27 11:22:32.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1490973670928, 1, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[70793, 93793]', '[]', '2017-03-31 23:21:10.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1492936169722, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-04-23 16:29:29.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493480142628, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-04-29 23:35:42.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493747512860, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-03 01:51:52.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493747777770, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-03 01:56:17.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493748594003, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-03 02:09:54.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493748615711, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-03 02:10:15.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493749090643, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-03 02:18:10.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493836043151, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-04 02:27:23.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493883110132, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-04 15:31:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493890214167, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-04 17:30:14.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493890303473, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-05-04 17:31:43.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1493890303474, 0, 'Test Post', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-06-12 23:50:44.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1497792972314, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-06-18 21:36:12.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1499057230629, 0, '一二三', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-07-03 12:47:10.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1500825221910, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-07-23 23:53:41.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1502639062900, 0, 'TESLA', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-08-13 23:44:22.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1502639424119, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-08-13 23:50:24.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1508072071492, 0, '赵钱孙李', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-10-15 20:54:31.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1508072105320, 1, '周吴郑王', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-10-15 20:55:05.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1508072160401, 0, '四五六', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-10-15 20:56:00.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1508072202871, 0, '七八九十', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-10-15 20:56:42.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1510495628760, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-11-12 22:07:08.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1511407581570, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82002, 82003, 82005, 82006, 82021, 82023, 82036, 82033]', '[]', '2017-11-23 11:26:21.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1511761906715, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-11-27 13:51:46.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1511965911349, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-11-29 22:31:51.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1512387063078, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-12-04 19:31:03.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1512531601485, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82001]', '[]', '2017-12-06 11:40:01.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1514623064133, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2017-12-30 16:37:44.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1514625918255, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82002, 93793]', null, '2017-12-30 17:25:18.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1514626163032, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2017-12-30 17:29:23.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1514858422969, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[93793, 82056]', null, '2018-01-02 10:00:22.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1515565976140, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82003, 82021]', null, '2018-01-10 14:32:56.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1518218350585, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-02-10 07:19:10.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1519778917280, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-02-28 08:48:37.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1520242280259, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82002]', null, '2018-03-05 17:31:20.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1521274648008, 0, 'Kiro', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-03-17 16:17:28.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1521371722416, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-03-18 19:15:22.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1521374327542, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', null, null, '2018-03-18 19:58:47.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1523626157302, 1, 'Charlie_brown', '', 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1523935772553, 93793]', null, '2018-04-13 21:29:17.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1523935772553, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[1523626157302]', null, '2018-04-17 11:29:32.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1524042900591, 1, '哈哈哈', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82002, 82003]', null, '2018-04-18 17:15:00.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (1524298730523, 0, 'APIJSONUser', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', null, '2018-04-21 16:18:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (38710, 0, 'TommyLemon', 'Android&Java', 'http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000', '[82003, 82005, 90814, 82004, 82009, 82002, 82044, 93793, 70793]', '["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (70793, 0, 'Strong', 'djdj', 'http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000', '[38710, 82002]', '["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "https://camo.githubusercontent.com/788c0a7e11a", "https://camo.githubusercontent.com/f513f67"]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82001, 1, '测试账号', 'Dev', 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82006, 38710, 82004, 93794, 82002, 82005]', '["http://common.cnblogs.com/images/icon_weibo_24.png"]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82002, 1, 'Happy~', 'iOS', 'http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000', '[82005, 82001, 38710]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82003, 1, 'Wechat', null, 'http://common.cnblogs.com/images/wechat.png', '[82001, 93793]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82004, 0, 'Tommy', 'fasef', 'http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82005, 1, 'Jan', 'AG', 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82001, 38710, 1532439021068]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82006, 1, 'Meria', null, 'http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82009, 0, 'God', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82012, 0, 'Steve', 'FEWE', 'http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000', '[82004, 82002, 93793]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82020, 0, 'ORANGE', null, 'http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82021, 1, 'Tommy', null, 'http://static.oschina.net/uploads/user/19/39085_50.jpg', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82022, 0, 'Internet', null, 'http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82023, 0, 'No1', null, 'http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82024, 0, 'Lemon', null, 'http://static.oschina.net/uploads/user/427/855532_50.jpg?t=1435030876000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82025, 1, 'Tommy', null, 'http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82026, 0, 'iOS', null, 'http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82027, 0, 'Yong', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82028, 1, 'gaeg', null, 'http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82029, 0, 'GASG', null, 'http://common.cnblogs.com/images/wechat.png', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82030, 1, 'Fun', null, 'http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82031, 0, 'Lemon', null, 'http://static.oschina.net/uploads/user/48/96331_50.jpg', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82032, 0, 'Stack', 'fasdg', 'http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82033, 1, 'GAS', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82034, 1, 'Jump', null, 'http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82035, 1, 'Tab', null, 'http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82036, 0, 'SAG', null, 'http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82037, 0, 'Test', null, 'http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82038, 0, 'Battle', null, 'http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82039, 1, 'Everyday', null, 'http://common.cnblogs.com/images/icon_weibo_24.png', '[]', '[]', '2017-02-19 21:57:56.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82040, 1, 'Dream', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[70793]', '[]', '2017-03-03 00:44:26.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82041, 0, 'Holo', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[38710, 82001]', '[]', '2017-03-04 17:59:34.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82042, 1, 'Why', null, 'http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000', '[]', '[]', '2017-03-04 18:04:33.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82043, 0, 'Holiday', null, 'http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000', '[70793, 82006]', '[]', '2017-03-04 18:05:04.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82044, 1, 'Love', null, 'http://static.oschina.net/uploads/user/1174/2348263_50.png?t=1439773471000', '[82006]', '[]', '2017-03-04 18:20:27.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82045, 0, 'Green', null, 'http://common.cnblogs.com/images/wechat.png', '[82001, 82002, 82003, 1485246481130]', '[]', '2017-03-04 18:22:39.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82046, 0, 'Team', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[38710, 82002, 1485246481130]', '[]', '2017-03-04 23:11:17.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82047, 0, 'Tesla', null, 'http://common.cnblogs.com/images/wechat.png', '[]', '[]', '2017-03-05 00:02:05.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82048, 0, 'Moto', null, 'http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000', '[]', '[]', '2017-03-05 00:04:02.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82049, 0, 'ITMan', null, 'http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000', '[]', '[]', '2017-03-05 17:51:51.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82050, 0, 'Parl', null, 'http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000', '[]', '[]', '2017-03-05 17:52:52.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82051, 0, 'Girl', null, 'http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000', '[]', '[]', '2017-03-05 17:53:37.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82052, 0, 'Unbrella', null, 'http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000', '[]', '[]', '2017-03-05 17:57:54.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82053, 0, 'Alice', null, 'http://common.cnblogs.com/images/wechat.png', '[]', '[]', '2017-03-05 23:25:42.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82054, 0, 'Harvey', null, 'http://static.oschina.net/uploads/user/19/39085_50.jpg', '[]', '[]', '2017-03-06 20:29:03.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82055, 1, 'Solid', null, 'http://static.oschina.net/uploads/user/19/39085_50.jpg', '[38710, 82002]', '[]', '2017-03-11 23:04:00.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82056, 1, 'IronMan', null, 'http://static.oschina.net/uploads/user/48/96289_50.jpg?t=1452751699000', '[]', '[]', '2017-03-11 23:32:25.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82057, 0, 'NullPointerExeption', null, 'http://static.oschina.net/uploads/user/1385/2770216_50.jpg?t=1464405516000', '[]', '[]', '2017-03-12 14:01:23.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82058, 0, 'StupidBird', null, 'https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Logo.png', '[82001, 82002]', '[]', '2017-03-12 19:23:04.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82059, 1, 'He&She', null, 'http://static.oschina.net/uploads/user/585/1170143_50.jpg?t=1390226446000', '[]', '[]', '2017-03-19 22:49:15.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (82060, 1, 'Anyway~', null, 'http://static.oschina.net/uploads/user/1/3064_50.jpg?t=1449566001000', '[]', '[]', '2017-03-21 22:10:18.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (90814, 0, '007', null, 'http://static.oschina.net/uploads/user/51/102723_50.jpg?t=1449212504000', '[]', '[]', '2017-02-01 19:21:50.000');

INSERT INTO pubs.dbo.apijson_user (id, sex, name, tag, head, contactIdList, pictureList, date) VALUES (93793, 0, 'Mike', 'GES', 'http://static.oschina.net/uploads/user/48/96331_50.jpg', '[]', '[]', '2017-02-01 19:21:50.000');

create table Comment

(

id bigint,

toId bigint,

userId bigint,

momentId bigint,

date datetime,

content varchar(1000)

)

exec sp_addextendedproperty 'MS_Description', '评论', 'SCHEMA', 'dbo', 'TABLE', 'Comment'

INSERT INTO pubs.dbo.Comment (id, toId, userId, momentId, date, content) VALUES (4, 0, 38710, 470, '2017-02-01 19:20:50.000', 'This is a Content...-4');

INSERT INTO pubs.dbo.Comment (id, toId, userId, momentId, date, content) VALUES (13, 0, 82005, 58, '2017-02-01 19:20:50.000', 'This is a Content...-13');

INSERT INTO pubs.dbo.Comment (id, toId, userId, momentId, date, content) VALUES (22, 221, 82001, 470, '2017-02-01 19:20:50.000', '测试修改评论');

INSERT INTO pubs.dbo.Comment (id, toId, userId, momentId, date, content) VALUES (44, 0, 82003, 170, '2017-02-01 19:20:50.000', 'This is a Content...-44');