| Line 15... |
Line 15... |
| 15 |
license_product_id int unsigned not null auto_increment,
|
15 |
license_product_id int unsigned not null auto_increment,
|
| 16 |
name text comment 'name of the license',
|
16 |
name text comment 'name of the license',
|
| 17 |
primary key ( license_product_id )
|
17 |
primary key ( license_product_id )
|
| 18 |
) comment 'a list of all products we track license for';
|
18 |
) comment 'a list of all products we track license for';
|
| 19 |
|
19 |
|
| 20 |
delete from _system where key_name = 'Licenses';
|
20 |
delete from _system where key_name = 'license';
|
| 21 |
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Licenses', 'modules/license/', now() );
|
21 |
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'license', 'modules/license/', now() );
|
| 22 |
delete from menu
|
22 |
delete from menu
|
| 23 |
where
|
23 |
where
|
| 24 |
menu.parent_id in
|
24 |
menu.parent_id in
|
| 25 |
( select menu_id
|
25 |
( select menu_id
|
| 26 |
from (
|
26 |
from (
|
| Line 34... |
Line 34... |
| 34 |
insert into menu( url,caption,parent_id) select '/modules/license/bulk_load.html','Bulk Load',menu_id from menu where caption = 'Licenses';
|
34 |
insert into menu( url,caption,parent_id) select '/modules/license/bulk_load.html','Bulk Load',menu_id from menu where caption = 'Licenses';
|
| 35 |
insert into menu( url,caption,parent_id) select '/modules/license/edit_license_product.html','Edit Products',menu_id from menu where caption = 'Licenses';
|
35 |
insert into menu( url,caption,parent_id) select '/modules/license/edit_license_product.html','Edit Products',menu_id from menu where caption = 'Licenses';
|
| 36 |
|
36 |
|
| 37 |
create or replace view view_device_systems as select * from device where device_type_id in (select device_type_id from device_type where show_as_system = 'Y');
|
37 |
create or replace view view_device_systems as select * from device where device_type_id in (select device_type_id from device_type where show_as_system = 'Y');
|
| 38 |
|
38 |
|
| - |
|
39 |
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'license', 'callable.php:view', now() );
|
| - |
|
40 |
|
| - |
|
41 |
|
| - |
|
42 |
|
| 39 |
/* DO NOT RUN BELOW THIS LINE */
|
43 |
/* DO NOT RUN BELOW THIS LINE */
|
| 40 |
|
44 |
|
| 41 |
select
|
45 |
select
|
| 42 |
license_product.name 'Product',
|
46 |
license_product.name 'Product',
|
| 43 |
license.license 'License',
|
47 |
license.license 'License',
|