-- 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'