lyfz_repos/经典版源码/document/数据库维护脚本/测试儿童企业.sql

use dbmsg
--select * from clientip where name = '20150617162809502788.ly.com' or name = '20140913092332521757.ly.com'
select * from clientip where enterprisename like '%利亚方舟%'

/*
update clientip set ip = '192.168.1.205', branchname = '205店' where name = '20160125113541587674.ly.com'
update clientip set ip = '192.168.1.119', rights = '119店,191店,205店' where name = '20160125113039587445.ly.com'
update clientip set ip = '192.168.1.110', branchname = '总店' where name = '20150708173758521697.ly.com'
*/
/*
INSERT INTO [dbmsg].[dbo].[clientip]
           ([name]
           ,[ip]
           ,[bz]
           ,[datetime]
           ,[applydate]
           ,[branchname]
           ,[enterprisename]
           ,[regcode2]
           ,[bmain]
           ,[modifydate]
           ,[rights]
           ,[log]
           ,[regcode]
           ,[name2])
     VALUES
           ('20160125113541587674.ly.com'	-- 域名;
           ,'192.168.1.205'					-- IP地址;
           ,''								-- 备注;
           ,'2016-04-18'					-- 日期;
           ,'2016-04-18'					-- 使用日期;
           ,'205店'							-- 分店名称;
           ,'利亚方舟IT'					-- 总店名称;
           ,''								-- ;
		   ,'总店'							-- ;
           ,''								-- ;
           ,'119店,191店,205店'				-- 权限;
           ,''								-- 日志;
           ,''								-- ;
           ,''								-- ;
           )
GO



*/