12.6非按核10i扩展插件

##一、SQL

###1.1新增列表

use onlinegishost;
#面向桌面用户：
#iDesktop .NET
insert into online_timelicenseproduct values(10001001,2,1,329,5,null,'10i','STANDARD'),(10001002,2,1,729,5,null,'10i','PROFESSIONAL'),(10001003,2,1,1169,5,null,'10i','ADVANCED'),(10001004,2,1,139,5,null,'10i','BASIC');
#iDesktopX
insert into online_timelicenseproduct values(10002001,20,1,1029,5,null,'10i','STANDARD'),(10002002,20,1,1769,5,null,'10i','PROFESSIONAL'),(10002003,20,1,2219,5,null,'10i','ADVANCED'),(10002004,20,1,289,5,null,'10i','BASIC');

#面向web开发者：
#iServer
insert into online_timelicenseproduct values(10003001,4,1,1399,6,null,'10i','STANDARD'),(10003002,4,1,2139,6,null,'10i','PROFESSIONAL'),(10003003,4,1,3629,6,null,'10i','ADVANCED'),(10003004,4,1,1689,6,null,'10i','EXTEND');
#iPortal
insert into online_timelicenseproduct values(10004001,3,1,3629,6,null,'10i','STANDARD'),(10004002,3,1,7349,6,null,'10i','PROFESSIONAL'),(10004003,3,1,13949,6,null,'10i','ADVANCED'),(10004004,3,1,1839,6,null,'10i','BASIC');
#iManager
insert into online_timelicenseproduct values(10005001,13,1,1239,6,null,'10i','STANDARD'),(10005002,13,1,2209,6,null,'10i','PROFESSIONAL'),(10005003,13,1,3839,6,null,'10i','ADVANCED');
#iEdge
insert into online_timelicenseproduct values(10006001,7,1,729,6,null,'10i','BASIC');

#面向组件开发者
#iObject
insert into online_timelicenseproduct values(10007001,9,1,399,8,null,'10i','RUNTIME'),(10007002,10,1,399,8,null,'10i','RUNTIME');

###1.2删除列表

delete from online_timelicenseproduct where id between 10001001 and 10007002;

2.1新增扩展

#面向桌面用户
#iDesktop .NET 10i 基础版
insert into timelicenseproduct_to_module(productId,moduleId) values(10001004,9302028);
#iDesktop .NET 10i 标准版
insert into timelicenseproduct_to_module(productId,moduleId) values(10001001,9302001),(10001001,9302004),(10001001,9302005),(10001001,9302006),
(10001001,9302007),(10001001,9302008),(10001001,9302010),(10001001,9302012),(10001001,9302014),(10001001,9302015),(10001001,9302016),(10001001,9302017),
(10001001,9302018),(10001001,9302019),(10001001,9302020),(10001001,9302021),(10001001,9302022),(10001001,9302023),(10001001,9302026),(10001001,9302027);
#iDesktop .NET 10i 专业版
insert into timelicenseproduct_to_module(productId,moduleId) values(10001002,9302002),(10001002,9302004),(10001002,9302005),(10001002,9302006),
(10001002,9302007),(10001002,9302008),(10001002,9302010),(10001002,9302012),(10001002,9302014),(10001002,9302015),(10001002,9302016),(10001002,9302017),
(10001002,9302018),(10001002,9302019),(10001002,9302026),(10001002,9302027);
#iDesktop .NET 10i 高级版
insert into timelicenseproduct_to_module(productId,moduleId) values(10001003,9302003),(10001003,9302004),(10001003,9302005),(10001003,9302006),
(10001003,9302007),(10001003,9302008),(10001003,9302010),(10001003,9302012),(10001003,9302014),(10001003,9302015),(10001003,9302016),(10001003,9302017),
(10001003,9302018),(10001003,9302019),(10001003,9302026),(10001003,9302027);

#iDesktop Java 10i 基础版
insert into timelicenseproduct_to_module(productId,moduleId) values(10002004,9310028);
#iDesktop Java 10i 标准版
insert into timelicenseproduct_to_module(productId,moduleId) values(10002001,9310001),(10002001,9310004),(10002001,9310005),(10002001,9310006),(10002001,9310007),(10002001,9310010),(10002001,9310012),(10002001,9310017),(10002001,9310018),(10002001,9310019),(10002001,9310020),
(10002001,9310021),(10002001,9310022),(10002001,9310023),(10002001,9310024),(10002001,9310025),(10002001,9310026),(10002001,9310027);
#iDesktop Java 10i 专业版
insert into timelicenseproduct_to_module(productId,moduleId) values(10002002,9310002),(10002002,9310004),(10002002,9310005),(10002002,9310006),(10002002,9310007),(10002002,9310010),(10002002,9310012),(10002002,9310017),(10002002,9310018),(10002002,9310019),(10002002,9310020),
(10002002,9310021),(10002002,9310026),(10002002,9310027);
#iDesktop Java 10i 高级版
insert into timelicenseproduct_to_module(productId,moduleId) values(10002003,9310003),(10002003,9310004),(10002003,9310005),(10002003,9310006),(10002003,9310007),(10002003,9310010),(10002003,9310012),(10002003,9310017),(10002003,9310018),(10002003,9310019),(10002003,9310020),
(10002003,9310021),(10002003,9310026),(10002003,9310027);

#面向Web开发者
#iServer 10i 标准版
insert into timelicenseproduct_to_module(productId,moduleId) values(10003001,9303001),(10003001,9303007);
#iServer 10i 专业版
insert into timelicenseproduct_to_module(productId,moduleId) values(10003002,9303002),(10003002,9303004),(10003002,9303005),
(10003002,9303006),(10003002,9303007),(10003002,9303009),(10003002,9303011),(10003002,9303012),(10003002,9303013);
#iServer 10i 高级版
insert into timelicenseproduct_to_module(productId,moduleId) values(10003003,9303003),(10003003,9303004),(10003003,9303005),
(10003003,9303006),(10003003,9303007),(10003003,9303008),(10003003,9303009),(10003003,9303011),(10003003,9303012),(10003003,9303013);
#iServer 10i 服务节点扩展模块
insert into timelicenseproduct_to_module(productId,moduleId) values(10003004,9303009);
#iPortal 10i 基础版,(本地数据库没有)
insert into timelicenseproduct_to_module(productId,moduleId) values(10004004,9304004),(10004004,9304005),(10004004,9304006);
#iPortal 10i 标准版
insert into timelicenseproduct_to_module(productId,moduleId) values(10004001,9304001),(10004001,9304004),(10004001,9304005);
#iPortal 10i 专业版
insert into timelicenseproduct_to_module(productId,moduleId) values(10004002,9304002),(10004002,9304004),(10004002,9304005);
#iPortal 10i 高级版
insert into timelicenseproduct_to_module(productId,moduleId) values(10004003,9304003),(10004003,9304004),(10004003,9304005);
#iManager 10i 标准版
insert into timelicenseproduct_to_module(productId,moduleId) values(10005001,9305001);
#iManager 10i 专业版
insert into timelicenseproduct_to_module(productId,moduleId) values(10005002,9305002);
#iManager 10i 高级版
insert into timelicenseproduct_to_module(productId,moduleId) values(10005003,9305003);
#iEdge 10i
insert into timelicenseproduct_to_module(productId,moduleId) values(10006001,9307001);

#面向组件开发者
#iObjects Java 10i 运行版
insert into timelicenseproduct_to_module(productId,moduleId) values(10007001,9301024),(10007001,9301025),(10007001,9301026),(10007001,9301027),
(10007001,9301028),(10007001,9301029),(10007001,9301030),(10007001,9301031),(10007001,9301032),(10007001,9301033),(10007001,9301034),(10007001,9301035),
(10007001,9301036),(10007001,9301037),(10007001,9301038),(10007001,9301039),(10007001,9301040),(10007001,9301041),(10007001,9301042);
#iObjects .NET 9D 运行版
insert into timelicenseproduct_to_module(productId,moduleId) values(10007002,9301024),(10007002,9301025),(10007002,9301026),(10007002,9301027),
(10007002,9301028),(10007002,9301029),(10007002,9301030),(10007002,9301031),(10007002,9301032),(10007002,9301033),(10007002,9301034),(10007002,9301035),
(10007002,9301036),(10007002,9301037),(10007002,9301038),(10007002,9301039),(10007002,9301040),(10007002,9301041),(10007002,9301042);

###2.2删除扩展

delete from timelicenseproduct_to_module where productId between 10001001 and 10007002;

###3.9D修改

###3.1iPortal 9D

#iPortal 标准版，专业版，高级版增加默认用户计数模块
insert into timelicenseproduct_to_module(productId,moduleId) values(9004001,9304004),(9004002,9304004),(9004003,9304004);

#iPortal 基础版 列表一周价格1939 => 1839
update online_timelicenseproduct set startFrom = 1839 where id = 9004004;

###3.2iDesktop 9D

#iDesktop 9D .NET 标准版 删掉 分布式分析模块9302026 空间统计分析模块9302027
delete from timelicenseproduct_to_module where moduleId between 9302026 and 9302027 AND productId = 9002001;

#iDesktop 9D .NET 专业版 删掉 9302020-9302027（6个）
delete from timelicenseproduct_to_module where moduleId between 9302020 and 9302027 AND productId = 9002002;

#iDesktop 9D .NET 高级版 删掉 9302020-9302027（6个）
delete from timelicenseproduct_to_module where moduleId between 9302020 and 9302027 AND productId = 9002003;


#iDesktop 9D Java 标准版 删掉  三维网络分析模块，系统定制，统计图表，增加三维地理设计
delete from timelicenseproduct_to_module where moduleId in(9310016,9310022,9310024) and productId = 9010001;
insert into timelicenseproduct_to_module(productId,moduleId) values(9010001,9310021);

#iDesktop 9D Java 专业版 删掉  三维网络分析模块  增加三维地理设计
delete from timelicenseproduct_to_module where moduleId = 9310016 and productId = 9010002;
insert into timelicenseproduct_to_module(productId,moduleId) values(9010002,9310021);

#iDesktop 9D Java 高级版 删掉  三维网络分析模块  增加三维地理设计
delete from timelicenseproduct_to_module where moduleId = 9310016 and productId = 9010003;
insert into timelicenseproduct_to_module(productId,moduleId) values(9010003,9310021);