master

分支 (1)

管理

管理

master

wechat
/
WeChat.sql

create database `wechat` default character set utf8;
use wechat;
create table reading
(
    uniqueID       int auto_increment,
    grainID        varchar(10)   not null,
    createTime     varchar(10)   not null,
    author         varchar(45)   not null,
    coverImg       varchar(200)  not null,
    title          varchar(80)   not null,
    introduce      varchar(180)  null,
    textImg        varchar(200)  null,
    text           varchar(10000) not null,
    otherIntroduce varchar(150)  null,
    constraint UniqueID_UNIQUE
        unique (uniqueID)
);

alter table reading
    add primary key (uniqueID);

create table root
(
    num      int auto_increment
        primary key,
    rootname varchar(20)                 not null,
    rootpwd  varchar(16)                 not null,
    perms    varchar(20) default 'root1' null,
    constraint rootname_UNIQUE
        unique (rootname)
);

create table starTable
(
    tableID  int auto_increment
        primary key,
    userid   int not null,
    starRead int not null
);

create table user
(
    userid     int auto_increment,
    openid     varchar(45)                                   not null,
    corn       smallint(3) unsigned zerofill default 0       null,
    wheat      smallint(3) unsigned zerofill default 0       null,
    soybean    smallint(3) unsigned zerofill default 0       null,
    rice       smallint(3) unsigned zerofill default 0       null,
    buckwheat  smallint(3) unsigned zerofill default 0       null,
    sorghum    smallint(3) unsigned zerofill default 0       null,
    cotton     smallint(3) unsigned zerofill default 0       null,
    vege       smallint(3) unsigned zerofill default 0       null,
    fruit      smallint(3) unsigned zerofill default 0       null,
    saplings   smallint(3) unsigned zerofill default 0       null,
    createtime varchar(20)                                   null,
    username   varchar(20)                   default '会飞的_鱼' not null,
    userimg    varchar(200)                                  null,
    constraint userid_UNIQUE
        unique (userid)
);

alter table user
    add primary key (userid);

create table userland
(
    userid     int               not null,
    landId     varchar(2)        not null,
    crops      varchar(10)       not null,
    sowingtime varchar(20)       not null,
    state      tinyint default 0 null,
    irrigation varchar(2000)     null,
    fertilizer varchar(2000)     null,
    pesticides varchar(2000)     null,
    harvest    varchar(19)       null,
    `describe` varchar(100)      null,
    PictureURL varchar(300)      null,
    number     int auto_increment
        primary key
);

create table usertoken
(
    openid     varchar(50)  not null,
    sessionkey varchar(100) not null,
    token      varchar(500) not null,
    tokenNum   int auto_increment
        primary key
);


INSERT INTO wechat.reading (uniqueID, grainID, createTime, author, coverImg, title, introduce, textImg, text, otherIntroduce) VALUES (1, 'D', '2022-05-18', '莫言', 'http://rb35wnr0a.hn-bkt.clouddn.com/f94e36a7a628367306ac25.jpeg', '天堂蒜薹之歌', '接触着，你许会杀害；远离着，你许会占有', 'http://rb35wnr0a.hn-bkt.clouddn.com/f947d5a841051d8b763ad8.jpg', '蟋蟀的唧唧，夜雨的淅沥，从黑暗中传到我的耳边，好似我已逝的少年时代沙沙地来到我的梦境中。@花朵向星辰落尽了的曙天叫道：“我的露滴全失落了。”', '我爱莫言');
INSERT INTO wechat.reading (uniqueID, grainID, createTime, author, coverImg, title, introduce, textImg, text, otherIntroduce) VALUES (2, 'D', '2022-5-1', '余华', 'https://s2.loli.net/2022/04/17/6V3A9HK5LXI2gPt.png', '兄弟', '或者你在工作，或者你没有。
当你不得不说“让我们做些事吧”时，那么就要开始胡闹了。
', 'https://s2.loli.net/2022/03/27/uQtUXKhpOjwNJIM.png', '太阳以微笑向我问候。雨，他的忧闷的姐姐，向我的心谈话。@或者你在工作，或者你没有。当你不得不说“让我们做些事吧”时，那么就要开始胡闹了。@花朵向星辰落尽了的曙天叫道：“我的露滴全失落了。”', '山花海树');
INSERT INTO wechat.reading (uniqueID, grainID, createTime, author, coverImg, title, introduce, textImg, text, otherIntroduce) VALUES (4, 'H', '2021-12-08', '雨果', 'http://rb35wnr0a.hn-bkt.clouddn.com/a5435d838683e5e3b8e6b7.jpg', '巴黎圣母院', '创作于19世纪,敲钟人卡西莫多', 'http://rb35wnr0a.hn-bkt.clouddn.com/de49f392365f46e2bd4631.jpg', '环绕方圆，无一物、无一树，虚空之下仍是虚空，看似无尽的黑暗，我漫步百米之外不敢轻易进入。前方宛如千年无人之境，是繁华后的落寞，充满了恐怖阴森之气，我不相信哪里能够存在这等铩羽之地，寸草不生，寒冷凄切，可不是难以忍受，有点白，有点耀眼，让人回忆温存时光，却始感孤独。可谁又知道这里曾经的模样呢。
', '这应该是一场梦，印在了我的心膛之上，如此透彻般的刺骨寒冷，以至于给我的人生之路埋下了沉重的一笔。');
INSERT INTO wechat.reading (uniqueID, grainID, createTime, author, coverImg, title, introduce, textImg, text, otherIntroduce) VALUES (5, 'G', '2020-09-10', '高尔基', 'http://rb35wnr0a.hn-bkt.clouddn.com/2e4dfc8fd2cd4d07270656.jpg', '童年', '池塘边的榕树上，知了在声声的叫着夏天', 'http://rb35wnr0a.hn-bkt.clouddn.com/ca4349a72c77a2a6554b58.jpg', '人们追求永恒的瞬间，想与这亘古不绝的天地永久为伴，可归根结底都是于人世间的欲望。始皇帝炼制丹药，可离了臣民还能得到什么呢。人世不长也不短，被鬼迷心窍不可取，可如不彻头彻尾享受一久久的幸福怕是不能瞑目罢。亦或是在追逐中恍然大悟，看到了绝处逢生之妙。嫦娥纵然美丽，可之美若得不到充分的释放，那便是心灵上的磨砺，往往会促使人之欲望的暴增。于此嫦娥之美，后羿心领神会，自己又何尝不想体味这人间之乐。@步入春秋五载，踏得武夷蛮荒，终不能求。一日，月圆之境，月光之下竟有一媛衣女子飘忽空中、独步起舞，后羿恍惚。天微微亮，后羿醒目，明白是大梦一场，可觉手中紧握一物，竟是两锦囊，内裹灵丹，此灵丹通体浑圆通透，不见其色，乃是万千之色。后羿想起小时从祖母那听得，传说月宫之上有一女子，本是平常人家，却是于月盈之夜吞得灵丹就此飞升，但却无人陪伴在月宫中寂寥度日，后觅得一兔，名曰：玉兔，人们广为流传——宁为农家地羊赖，不做玉兔伴仙风。后羿大喜，定是昨晚仙子凌空起舞赋得灵丹，便急忙跪拜叩谢。后羿思念嫦娥，想得在那云梦泽与嫦娥度过的洒脱人间四月，喜悦顷刻间便涌进身心，稍不停息便前往云梦泽奔去。等待他的，将会是什么，说到这点后羿心里也是十分忐忑。
', '根是地下的枝，枝是空中的根');
INSERT INTO wechat.reading (uniqueID, grainID, createTime, author, coverImg, title, introduce, textImg, text, otherIntroduce) VALUES (6, 'E', '2020-09-01', '麦加', 'http://rb35wnr0a.hn-bkt.clouddn.com/7b422b9641639ef181ba97.png', '暗算', '静静的听，我的心呀，听那世界的低语，这是它对你求爱的表示呀。', 'http://rb35wnr0a.hn-bkt.clouddn.com/5d4c11929fea2819d665dd.png', '不要因为峭壁是高的，便让你的爱情坐在峭壁上。@我今晨坐在窗前，世界如一个过路人似的，停留了一会，向我点点头又走过去了。@这些微飔，是绿叶的簌簌之声呀；它们在我的心里欢悦地微语着。', '我不能选择那最好的。是那最好的选择我。');


INSERT INTO wechat.root (num, rootname, rootpwd, perms) VALUES (101, 'qiandao', '1234567890', 'user:root');
INSERT INTO wechat.root (num, rootname, rootpwd, perms) VALUES (102, 'yanxue', '123456789', 'user:primary');
INSERT INTO wechat.root (num, rootname, rootpwd, perms) VALUES (103, 'chenlin', '12345678', 'user:primary');
INSERT INTO wechat.root (num, rootname, rootpwd, perms) VALUES (104, 'linruixing', '1234567', 'user:primary');
INSERT INTO wechat.root (num, rootname, rootpwd, perms) VALUES (105, 'zengzhiquan', '123456', 'user:primary');

INSERT INTO wechat.starTable (tableID, userid, starRead) VALUES (2, 3008, 4);
INSERT INTO wechat.starTable (tableID, userid, starRead) VALUES (3, 3010, 1);
INSERT INTO wechat.starTable (tableID, userid, starRead) VALUES (4, 3008, 5);

INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3001, 'efsefsf', 1, 0, 4, 3, 0, 1, 0, 0, 2, 3, '2022-04-25', '千岛', 'https://s2.loli.net/2022/03/27/XFSi6jnEkJtM4PH.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3002, 'safdsfg——99', 3, 0, 2, 2, 0, 5, 0, 0, 3, 8, '2022-04-27', '小明', 'https://s2.loli.net/2022/03/27/BUC8KV4AY6lc5Nq.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3003, 'wearrw', null, null, null, null, null, null, null, null, null, null, '2022-04-27', '小红你好', null);
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3004, 'fgasghhah-8438', null, null, null, null, null, null, null, null, null, null, '2022-04-27', '小红你好', null);
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3005, 'hhdsfhsf-732947', 0, 0, null, 0, 0, 1, 0, 0, 0, 1, '2022-04-27', '星辰小鸟', 'https://loc');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3006, 'fjesfijewfjw-fajefwf', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-04-28', '泰戈尔', 'https://s2.loli.net/2022/04/17/6TwB38OGrzFpoDW.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3007, 'fadfggahh', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-04-28', '普希金', 'https://s2.loli.net/2022/03/27/hWMkcbumsX19w7L.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3008, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-04-28', '', '');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3009, 'husdhhwdadh214', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-04-30', '莫言', 'https://s2.loli.net/2022/03/27/igbWM91ZskQvJV7.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3010, 'hiufhaehfhwfwf', 5, 2, 0, 1, 0, 0, 1, 0, 0, 1, '2022-05-03', '余华', 'https://s2.loli.net/2022/04/17/m9zTUWuC2sJ8qtA.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3011, 'fesfsf', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-05-03', '红红', '');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3012, 'sdffsfd', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-05-06', 'ppsn', 'https://s2.loli.net/2022/03/27/zghqQX8iArUj4V7.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3013, 'njijijiojijoi-hu9u', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-05-06', 'ppsn', 'https://s2.loli.net/2022/03/27/zghqQX8iArUj4V7.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit, saplings, createtime, username, userimg) VALUES (3014, 'jfesifjsjefisf', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-05-06', 'ppsn', 'https://s2.loli.net/2022/03/27/zghqQX8iArUj4V7.png');
INSERT INTO wechat.user (userid, openid, corn, wheat, soybean, rice, buckwheat, sorghum, cotton, vege, fruit,
                         saplings, createtime, username, userimg) VALUES (3015, 'oJ3WK4ncSBcXiUFMTGg5zJ503gFU', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2022-05-07', 'ppsn', 'https://s2.loli.net/2022/03/27/zghqQX8iArUj4V7.png');´


INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3001, 'C', '玉米', '2022-05-06', 0, null, '|氮磷钾@2022/6/18|有机肥@2019-12-19', '|杀鼠剂@2022-12-19|杀鼠剂@2003-10-30', '', '   为什么我的眼里常含泪水，---艾青  ', 'https://s2.loli.net/2022/03/27/EsJCRUourYiFfKm.png', 1);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3002, 'A', '蔬菜', '2022-06-09', 1, '|滴灌@2022-06-19|大水漫灌@2019-12-19', '|尿素@2021/4/28', '|除虫@2021/5/2|植物生长调节剂@2022-12-18|杀鼠剂@2022-12-19', '', '我很开心终止了这片地！', 'https://s2.loli.net/2022/04/17/TsKPldM27He9yQk.png', 2);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3001, 'D', '小麦', '2021-06-08', 0, '|喷灌@2020/6/5|滴灌@2020/7/18', '|尿素@2020/7/10|氮磷钾@2020/7/29|微量元素@2021/5/19', '|除草@2020/6/10|除虫@2020/8/19', '', '哇哇哇！！', '', 3);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3007, 'E', '大豆', '2022-03-28', 0, '|滴灌@2022-12-19', '', '|杀虫剂@2022-12-19', '', '77', '/Users/ppsn/Documents/SpringBoot/wechat/src/main/resources/static/uploadImg/3.jpg', 4);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3007, 'G', '水稻', '2022-04-20', 0, '', '', '', '', 'efsff', '/Users/ppsn/Documents/SpringBoot/wechat/src/main/resources/static/uploadImg/5.jpg', 5);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3007, 'E', '水稻', '2022-04-25', 1, '', '', '', '', 'dsfdsaf', '/Users/ppsn/Documents/SpringBoot/wechat/src/main/resources/static/uploadImg/备案图标.png', 6);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3002, 'E', '棉花', '2022-04-19', 0, '', '', '', '', '你好', '', 7);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3002, 'F', '蔬菜', '2022-04-05', 0, '', '', '', '', 'haha', '', 8);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3002, 'D', '荞麦', '2022-04-25', 0, '', '', '', '', '解决', '', 9);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3001, 'I', '树苗', '2022-04-26', 1, '|喷灌@2021/4/20', '', '|杀虫剂@2022-12-19', '', '唐亮', '', 10);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3002, 'K', '棉花', '2022-03-29', 0, '', '', '', '', '扽大', '', 11);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3003, 'G', '树苗', '2022-03-14', 0, '', '', '', '', '哇哇哇', '', 12);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3006, 'G', '水果', '2022-04-19', 1, '', '', '', '', '唐亮傻逼', '', 13);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3006, 'H', '蔬菜', '2022-04-18', 0, '', '', '', '', '东安发窘分', '', 14);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3005, 'H', '高粱', '2022-04-19', 0, '', '', '', '', '赛季发酒疯', 'http://rb35wnr0a.hn-bkt.clouddn.com/ff47d0979e7b3a210d4355.jpg', 15);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3005, 'G', '蔬菜', '2021-01-01', 0, '', '', '', '', '唐亮', 'http://rb35wnr0a.hn-bkt.clouddn.com/cb4e8295776842609d7017.jpg', 16);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3007, 'J', '棉花', '2022-04-21', 1, '', '|钾肥@2019-12-19', '', '', '', '', 17);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3002, 'F', '高粱', '2022-04-19', 1, '', '', '', '2022-05-01', '好漂亮！！', 'http://rb35wnr0a.hn-bkt.clouddn.com/794d3fbece26fc7169443c.jpg', 18);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3006, 'E', 'ui', '2022-11-25', 0, '', '', '', '', '', '', 19);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3005, 'E', 'uvdc', '2022-5-19', 0, '', '', '', '', '', '', 20);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3005, 'E', 'I', '2022-5-19', 0, '', '', '', '', '', 'http://rb35wnr0a.hn-bkt.clouddn.com/e74926b33d97fb279e05eb.png', 21);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3005, 'F', '水果', '2022-5-18', 0, '', '', '', '', ' 你是好人吗hello  ', '', 22);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3001, 'F', '玉米', '2008-05-22', 1, '|膜上灌@2008-06-14|涌泉灌@2008-07-27', '|复合肥@2008-07-27', '|除草剂@2008-09-18|除螨剂@2008-10-18', '', '土地肥沃，稻香袅袅，祝愿今年丰收吉祥！', '', 23);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'C', '水稻', '2022-05-11', 0, '', '', '', '', '我是余华，这是我的土地', 'http://rb35wnr0a.hn-bkt.clouddn.com/894a4ba3df3e90b951aa65.jpg', 24);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'C', '蔬菜', '2022-05-19', 0, '', '', '', '', '测试', null, 25);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'A', '小麦', '2022-05-27', 0, '', '', '', '', 'fesf', null, 26);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'C', '小麦', '2022-05-04', 0, '', '', '', '', '', null, 27);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'D', '水稻', '2022-04-25', 1, '', '', '', '2022-05-04', 'sfdafsfe', null, 28);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'A', '玉米', '2022-05-04', 0, '', '', '', '', '', null, 29);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'A', '玉米', '', 0, '', '', '', '', '', null, 30);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'B', '玉米', '', 0, '', '', '', '', '', null, 31);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3001, 'A', '玉米', '', 0, '|涌泉灌@2022-5-30|涌泉灌@2022-5-30', '', '', '', '', null, 32);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'A', '玉米', '', 0, '', '', '', '', '', null, 33);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'A', '玉米', '', 1, '', '', '', '2022-05-04', '', null, 34);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'A', '玉米', '', 0, '', '', '', '', '', null, 35);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3001, 'B', '大豆', '2022-05-19', 0, '', '', '', '', '秸秆', '', 36);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'D', '小麦', '2022-5-3', 0, '', '', '', '', '这世界乃是为美之音乐所驯服了的狂风骤雨的世界。。', '', 37);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'J', '玉米', '2022-05-11', 0, '', '', '', '', 'ceui', 'http://rb35wnr0a.hn-bkt.clouddn.com/f847c9bda4e4f73712397a.jpg', 38);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'J', '棉花', '2022-05-03', 0, '', '', '', '', '黄昏的天空，在我看来，像一扇窗户，一盏灯火，灯火背后的一次等待。', 'http://rb35wnr0a.hn-bkt.clouddn.com/a64b399cb7dfcc2c2f7d79.jpg', 39);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'H', '树苗', '2022-05-26', 1, '', '', '', '2022-05-04', '好好', 'http://rb35wnr0a.hn-bkt.clouddn.com/884eefa42e589e6623ab54.jpg', 40);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'D', '小麦', '2002-8-20', 1, '|大水漫灌@2003-10-30', '', '', '2022-05-04', '', '', 41);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3010, 'D', '水稻', '2022-05-17', 0, '', '', '', '', '七牛云', 'http://rb35wnr0a.hn-bkt.clouddn.com/284e65a2a35912dbd5ba60.jpg', 42);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3005, 'H', '树苗', '2021-07-13', 0, '', '', '', '', '', null, 43);
INSERT INTO wechat.userland (userid, landId, crops, sowingtime, state, irrigation, fertilizer, pesticides, harvest, `describe`, PictureURL, number) VALUES (3005, 'F', '高粱', '2021-10-06', 0, '', '', '', '', '年年有今日，岁岁有今朝', 'http://rb35wnr0a.hn-bkt.clouddn.com/d84b1a8c406612e6ea4a94.jpg', 44);

INSERT INTO wechat.usertoken (openid, sessionkey, token, tokenNum) VALUES ('oJ3WK4ncSBcXiUFMTGg5zJ503gFU',
                                                                           'x9YhmmMkgc/Hpv49SKCJUg==', 'eyJraWQiOiJvSjNXSzRuY1NCY1hpVUZNVEdnNXpKNTAzZ0ZVIiwidHlwIjoiSldUIiwiYWxnIjoiSFMyNTYifQ.eyJvcGVuaWQiOiJvSjNXSzRuY1NCY1hpVUZNVEdnNXpKNTAzZ0ZVIiwiaXNzIjoicWlhbmRhb3NoYW5nemh1emhleWl6aGlodWlmZWlkZXl1IiwiaWF0IjoxNjUxOTIwNDAxfQ.8YFxxnWKSbWX3C-JoKTFulmT6zx0zF7q74Y5vzFBbyQ', 1);
INSERT INTO wechat.usertoken (openid, sessionkey, token, tokenNum) VALUES ('sfaejfegf', 'fsefgasg', 'fsegage', 2);
INSERT INTO wechat.usertoken (openid, sessionkey, token, tokenNum) VALUES ('rwqt3453', '53qtrt', '34q54t', 3);