| Line 51... |
Line 51... |
| 51 |
drop table if exists _system;
|
51 |
drop table if exists _system;
|
| 52 |
create table _system (
|
52 |
create table _system (
|
| 53 |
_system_id int unsigned not null auto_increment,
|
53 |
_system_id int unsigned not null auto_increment,
|
| 54 |
group_name varchar(45) not null comment 'Group name for matching',
|
54 |
group_name varchar(45) not null comment 'Group name for matching',
|
| 55 |
key_name varchar(45) not null comment 'key name for matching',
|
55 |
key_name varchar(45) not null comment 'key name for matching',
|
| 56 |
key_value varchar(45) not null comment 'value for key_name',
|
56 |
key_value text not null comment 'value for key_name',
|
| 57 |
unique key unique_group_name( group_name,key_name ),
|
57 |
unique key unique_group_name( group_name,key_name ),
|
| 58 |
primary key (_system_id)
|
58 |
primary key (_system_id)
|
| 59 |
)
|
59 |
)
|
| 60 |
comment = 'Stores internal system information like ini file';
|
60 |
comment = 'Stores internal system information like ini file';
|
| 61 |
|
61 |
|
| Line 75... |
Line 75... |
| 75 |
|
75 |
|
| 76 |
/*
|
76 |
/*
|
| 77 |
insert the menu options for the main program
|
77 |
insert the menu options for the main program
|
| 78 |
*/
|
78 |
*/
|
| 79 |
insert into camp2._menu values (null,null,'Home', '/index.php', 'menu_home' );
|
79 |
insert into camp2._menu values (null,null,'Home', '/index.php', 'menu_home' );
|
| 80 |
insert into camp2._menu select null,_menu_id,'Owners', '/index.php?action=owner', 'menu_owner' from camp2._menu where caption = 'Home';
|
80 |
insert into camp2._menu select null,_menu_id,'Owners', '/index.php?module=owner', 'menu_owner' from camp2._menu where caption = 'Home';
|
| 81 |
insert into camp2._menu select null,_menu_id,'Locations', '/index.php?action=location', 'menu_location' from camp2._menu where caption = 'Home';
|
81 |
insert into camp2._menu select null,_menu_id,'Locations', '/index.php?module=location', 'menu_location' from camp2._menu where caption = 'Home';
|
| 82 |
insert into camp2._menu select null,_menu_id,'Devices', '/index.php?action=device', 'menu_device' from camp2._menu where caption = 'Home';
|
82 |
insert into camp2._menu select null,_menu_id,'Devices', '/index.php?module=device', 'menu_device' from camp2._menu where caption = 'Home';
|
| 83 |
insert into camp2._menu values (null,null,'Reports', '/index.php?action=report', 'menu_report' );
|
83 |
insert into camp2._menu values (null,null,'Reports', '/index.php?module=report', 'menu_report' );
|
| 84 |
|
84 |
|
| 85 |
/*
|
85 |
/*
|
| 86 |
simple table to hold ownership information
|
86 |
simple table to hold ownership information
|
| 87 |
*/
|
87 |
*/
|
| 88 |
drop table if exists owner;
|
88 |
drop table if exists owner;
|