| 1234567891011121314151617181920212223242526272829303132333435363738394041 |
- -- drop table if exists `notice`.`sys_pasture_url`;
- -- create table notice.sys_pasture_url(
- -- id int(11) not null auto_increment,
- -- sys_name varchar(50) not null,
- -- pasture varchar(50) not null,
- -- url varchar(255) not null,
- -- pasture_name varchar(50) not null,
- -- primary key (id),
- -- unique key (sys_name,pasture,url)
- -- )ENGINE=InnoDB DEFAULT CHARSET=utf8 comment '系统地址表';
- -- delete from notice.sys_pasture_url;
- insert into notice.sys_pasture_url(sys_name,pasture,url,pasture_name)
- values
- ('tmrwatch','1653271339', 'http://bmsm1.kptyun.com/', '1牧'),
- ('tmrwatch','1654779860', 'http://bmsm2.kptyun.com/', '2牧'),
- ('tmrwatch','1652667664', 'http://bmsm3.kptyun.com/', '3牧'),
- ('tmrwatch','1653617396', 'http://bmsm5.kptyun.com/', '5牧'),
- ('tmrwatch','1654571442', 'http://bmsm7.kptyun.com/', '7牧'),
- ('tmrwatch','1648089292', 'http://bmsm8.kptyun.com/', '8牧'),
- ('tmrwatch','1654653702', 'http://bmsm9.kptyun.com/', '9牧'),
- ('tmrwatch','1653548321', 'http://bmsm10.kptyun.com/', '10牧'),
- ('tmrwatch','1652842829', 'http://bmsm11.kptyun.com/', '11牧'),
- ('tmrwatch','1652930544', 'http://bmsm12.kptyun.com/', '12牧'),
- ('tmrwatch','1653188966', 'http://bmsm13.kptyun.com/', '13牧'),
- ('tmrwatch','1653878925', 'http://bmsm15.kptyun.com/', '15牧'),
- ('tmrwatch','1653018665', 'http://bmsm16.kptyun.com/', '16牧'),
- ('tmrwatch','1653705875', 'http://bmsm17.kptyun.com/', '17牧'),
- ('tmrwatch','1654866092', 'http://bmsm18.kptyun.com/', '19牧'),
- ('tmrwatch','1654139897', 'http://bmsm20.kptyun.com/', '20牧'),
- ('tmrwatch','1653965525', 'http://bmsm21.kptyun.com/', '21牧'),
- ('tmrwatch','1647917519', 'http://bmsm23.kptyun.com/', '23牧'),
- ('tmrwatch','1652758908', 'http://bmsm25.kptyun.com/', '25牧'),
- ('tmrwatch','1654506056', 'http://bmsm27.kptyun.com/', '27牧');
- -- ('tmrwatch','shengmu21','http://kpttest.kptyun.com/userwxopenid/binding');
- -- insert into sys_pasture_url (sys_name,pasture,url)
- -- select sys_name,"shengmu1",url from sys_pasture_url where id =1;
- -- update sys_pasture_url set pasture ='1653271339'
|
