12.18iMobile SQL

##一、新增iMobile列表

#iMobile 运行版
insert into online_timelicenseproduct values(10008001,12,1,500,8,null,'10i','RUNTIME'),(10008002,12,1,500,8,null,'10i','RUNTIME');

#iMobile 开发版
insert into online_timelicenseproduct values(10008003,12,1,500,8,null,'10i','RUNTIME'),(10008004,12,1,500,8,null,'10i','RUNTIME');

##二、新增iMobile扩展模块

###1.运行版模块

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

#iMobile iOS 运行版(三维态势推演组件暂不提供)
use onlinegishost;
insert into online_timelicensemodule values
(10308013,null,null,0,1,1,null,null,null,null,null,500,null,null,10902),
(10308014,null,null,1,1,1,null,null,null,null,null,500,null,null,10904),
(10308015,null,null,1,1,1,null,null,null,null,null,500,null,null,10906),
(10308016,null,null,1,1,1,null,null,null,null,null,1000,null,null,10908),
(10308017,null,null,1,1,1,null,null,null,null,null,500,null,null,10910),
(10308018,null,null,1,1,1,null,null,null,null,null,500,null,null,10912),
(10308019,null,null,1,1,1,null,null,null,null,null,1000,null,null,10914),
(10308020,null,null,1,1,1,null,null,null,null,null,500,null,null,10916),
(10308021,null,null,1,1,1,null,null,null,null,null,500,null,null,10918),
(10308022,null,null,1,1,1,null,null,null,null,null,1500,null,null,10920),
(10308023,null,null,1,1,1,null,null,null,null,null,1500,null,null,10922),
(10308024,null,null,1,1,1,null,null,null,null,null,1000,null,null,10924);

###2.开发板模块

#iMobile Android 开发版(三维态势推演组件暂不提供)
insert into online_timelicensemodule values
(10308025,null,null,0,1,1,null,null,null,null,null,500,null,null,10801),
(10308026,null,null,1,1,1,null,null,null,null,null,500,null,null,10803),
(10308027,null,null,1,1,1,null,null,null,null,null,500,null,null,10805),
(10308028,null,null,1,1,1,null,null,null,null,null,1000,null,null,10807),
(10308029,null,null,1,1,1,null,null,null,null,null,500,null,null,10809),
(10308030,null,null,1,1,1,null,null,null,null,null,500,null,null,10811),
(10308031,null,null,1,1,1,null,null,null,null,null,1000,null,null,10813),
(10308032,null,null,1,1,1,null,null,null,null,null,500,null,null,10815),
(10308033,null,null,1,1,1,null,null,null,null,null,500,null,null,10817),
(10308034,null,null,1,1,1,null,null,null,null,null,1500,null,null,10819),
(10308035,null,null,1,1,1,null,null,null,null,null,1500,null,null,10821),
(10308036,null,null,1,1,1,null,null,null,null,null,1000,null,null,10823);

#iMobile iOS 开发版(三维态势推演组件暂不提供)
insert into online_timelicensemodule values
(10308037,null,null,0,1,1,null,null,null,null,null,500,null,null,10901),
(10308038,null,null,1,1,1,null,null,null,null,null,500,null,null,10903),
(10308039,null,null,1,1,1,null,null,null,null,null,500,null,null,10905),
(10308040,null,null,1,1,1,null,null,null,null,null,1000,null,null,10907),
(10308041,null,null,1,1,1,null,null,null,null,null,500,null,null,10909),
(10308042,null,null,1,1,1,null,null,null,null,null,500,null,null,10911),
(10308043,null,null,1,1,1,null,null,null,null,null,1000,null,null,10913),
(10308044,null,null,1,1,1,null,null,null,null,null,500,null,null,10915),
(10308045,null,null,1,1,1,null,null,null,null,null,500,null,null,10917),
(10308046,null,null,1,1,1,null,null,null,null,null,1500,null,null,10919),
(10308047,null,null,1,1,1,null,null,null,null,null,1500,null,null,10921),
(10308048,null,null,1,1,1,null,null,null,null,null,1000,null,null,10923);

###3.删除模块

delete from online_timelicensemodule where moduleId between 10308001 and 10308048;

##三、关联模块

#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,10008002,10308013),(null,10008002,10308014),(null,10008002,10308015),(null,10008002,10308016),
(null,10008002,10308017),(null,10008002,10308018),(null,10008002,10308019),(null,10008002,10308020),(null,10008002,10308021),(null,10008002,10308022),
(null,10008002,10308023),(null,10008002,10308024);

#iMobile Android 开发版
insert into timelicenseproduct_to_module values(null,10008001,10308025),(null,10008001,10308026),(null,10008001,10308027),(null,10008001,10308028),
(null,10008001,10308029),(null,10008001,10308030),(null,10008001,10308031),(null,10008001,10308032),(null,10008001,10308033),(null,10008001,10308034),
(null,10008001,10308035),(null,10008001,10308036);
#iMobile iOS 开发版
insert into timelicenseproduct_to_module values(null,10008002,10308037),(null,10008002,10308038),(null,10008002,10308039),(null,10008002,10308040),
(null,10008002,10308041),(null,10008002,10308042),(null,10008002,10308043),(null,10008002,10308044),(null,10008002,10308045),(null,10008002,10308046),
(null,10008002,10308047),(null,10008002,10308048);