12.24 iMobile SQL大全

一、新增iMobile列表

use onlinegishost;
#iMobile 运行版
insert into online_timelicenseproduct values(10008001,12,1,null,9,null,'10i','RUNTIME'),(10009001,12,1,null,9,null,'10i','RUNTIME');

##二、新增iMobile扩展模块

#iMobile Android 运行版(三维态势推演组件暂不提供)
use onlinegishost;
insert into online_timelicensemodule values
(10308001,null,null,0,1,1,null,null,null,null,null,null,null,null,10802),
(10308002,null,null,1,1,1,null,null,null,null,null,null,null,null,10804),
(10308003,null,null,1,1,1,null,null,null,null,null,null,null,null,10806),
(10308004,null,null,1,1,1,null,null,null,null,null,null,null,null,10808),
(10308005,null,null,1,1,1,null,null,null,null,null,null,null,null,10810),
(10308006,null,null,1,1,1,null,null,null,null,null,null,null,null,10812),
(10308007,null,null,1,1,1,null,null,null,null,null,null,null,null,10814),
(10308008,null,null,1,1,1,null,null,null,null,null,null,null,null,10816),
(10308009,null,null,1,1,1,null,null,null,null,null,null,null,null,10818),
(10308010,null,null,1,1,1,null,null,null,null,null,null,null,null,10820),
(10308011,null,null,1,1,1,null,null,null,null,null,null,null,null,10822),
(10308012,null,null,1,1,1,null,null,null,null,null,null,null,null,10824);

#iMobile iOS 运行版(三维态势推演组件暂不提供)
insert into online_timelicensemodule values
(10309001,null,null,0,1,1,null,null,null,null,null,null,null,null,10902),
(10309002,null,null,1,1,1,null,null,null,null,null,null,null,null,10904),
(10309003,null,null,1,1,1,null,null,null,null,null,null,null,null,10906),
(10309004,null,null,1,1,1,null,null,null,null,null,null,null,null,10908),
(10309005,null,null,1,1,1,null,null,null,null,null,null,null,null,10910),
(10309006,null,null,1,1,1,null,null,null,null,null,null,null,null,10912),
(10309007,null,null,1,1,1,null,null,null,null,null,null,null,null,10914),
(10309008,null,null,1,1,1,null,null,null,null,null,null,null,null,10916),
(10309009,null,null,1,1,1,null,null,null,null,null,null,null,null,10918),
(10309010,null,null,1,1,1,null,null,null,null,null,null,null,null,10920),
(10309011,null,null,1,1,1,null,null,null,null,null,null,null,null,10922),
(10309012,null,null,1,1,1,null,null,null,null,null,null,null,null,10924);

三、iMobile关联模块

use onlinegishost;
#iMobile Android 运行版
insert into timelicenseproduct_to_module values(null,10008001,10308001),(null,10008001,10308002),(null,10008001,10308003),(null,10008001,10308004),
(null,10008001,10308005),(null,10008001,10308006),(null,10008001,10308007),(null,10008001,10308008),(null,10008001,10308009),(null,10008001,10308010),
(null,10008001,10308011),(null,10008001,10308012);
#iMobile iOS 运行版
insert into timelicenseproduct_to_module values(null,10009001,10309001),(null,10009001,10309002),(null,10009001,10309003),(null,10009001,10309004),
(null,10009001,10309005),(null,10009001,10309006),(null,10009001,10309007),(null,10009001,10309008),(null,10009001,10309009),(null,10009001,10309010),
(null,10009001,10309011),(null,10009001,10309012);

四、ilicense数据库

use ilicense;
#id的长度从7改为8
alter table _product modify column id char(8);
alter table _license modify column productId char(8);

use ilicense;
#iDesktop 10i
insert into _product values
(10001001,'SuperMap iDesktop','标准版','10503',10000,'10i',0),
(10001002,'SuperMap iDesktop','专业版','10502',10000,'10i',0),
(10001003,'SuperMap iDesktop','高级版','10501',10000,'10i',0),
(10001004,'SuperMap iDesktop','基础版','10528',10000,'10i',0);
#iDesktopX 10i
insert into _product values
(10002001,'SuperMap iDesktopX','标准版','10601',80000,'10i',0),
(10002002,'SuperMap iDesktopX','专业版','10602',80000,'10i',0),
(10002003,'SuperMap iDesktopX','高级版','10603',80000,'10i',0),
(10002004,'SuperMap iDesktopX','基础版','10628',80000,'10i',0);
#iServer 10i
insert into _product values
(10003001,'SuperMap iServer','标准版','11000',20000,'10i',0),
(10003002,'SuperMap iServer','专业版','11001',20000,'10i',0),
(10003003,'SuperMap iServer','高级版','11002',20000,'10i',0),
(10003004,'SuperMap iServer','服务节点扩展模块','11008',20000,'10i',0);
#iPortal 10i
insert into _product values
(10004001,'SuperMap iPortal','标准版','11032',50000,'10i',100),
(10004002,'SuperMap iPortal','专业版','11031',50000,'10i',200),
(10004003,'SuperMap iPortal','高级版','11031',50000,'10i',500),
(10004004,'SuperMap iPortal','基础版','11031',50000,'10i',50);
#iManager 10i
insert into _product values
(10005001,'SuperMap iManager','标准版','11041',40000,'10i',0),
(10005002,'SuperMap iManager','专业版','11042',40000,'10i',0),
(10005003,'SuperMap iManager','高级版','11043',40000,'10i',0);
#iEdge 10i
insert into _product values
(10006001,'SuperMap iExpress','','11051',30000,'10i',0);
#iObject 10i
insert into _product values
(10007001,'SuperMap iObject','运行版','10002',60000,'10i',0),
(10007002,'SuperMap iObject','运行版','10002',60000,'10i',0);
#iMobile 10i
insert into _product values
(10008001,'SuperMap iMobile for Android','运行版','10802',70000,'10i',0),
(10009001,'SuperMap iMobile for iOS','运行版','10902',70000,'10i',0);

##五、9D的imobile状态改为0

use onlinegishost;
update online_timelicenseproduct set status = 0 where id = 9006002 ;
update online_timelicenseproduct set status = 0 where id = 9006004 ;

##六、10i列表改正

use onlinegishost;
#iDesktop 高级版 10i 的基础模块
update timelicenseproduct_to_module set moduleId = 9302003 where moduleId = 9302002 and productId = 10001003;