| Line 80... |
Line 80... |
| 80 |
insert into camp2._menu select null,_menu_id,'Owners', '/index.php?module=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?module=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?module=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?module=report', 'menu_report' );
|
83 |
insert into camp2._menu values (null,null,'Reports', '/index.php?module=report', 'menu_report' );
|
| 84 |
|
84 |
|
| - |
|
85 |
/*
|
| - |
|
86 |
Modules are allowed to do the same thing for different classes, ie
|
| - |
|
87 |
attribute can have a name for an Owner, and a name for a Location
|
| - |
|
88 |
This table allows us to indicate which base table an entry is for
|
| - |
|
89 |
*/
|
| - |
|
90 |
|
| - |
|
91 |
drop table if exists _base_class;
|
| - |
|
92 |
create table _base_class (
|
| - |
|
93 |
_base_class_id int unsigned not null auto_increment,
|
| - |
|
94 |
name varchar(64) comment 'name for display',
|
| - |
|
95 |
class_name varchar(64) comment 'actual class in program',
|
| - |
|
96 |
base_table varchar(64) comment 'name of table which holds the class data',
|
| - |
|
97 |
primary key (_base_class_id)
|
| - |
|
98 |
) comment 'a list of base classes';
|
| - |
|
99 |
|
| - |
|
100 |
insert into _base_class values (null,'Owner','Owner','owner');
|
| - |
|
101 |
insert into _base_class values (null,'Location','Location','location');
|
| - |
|
102 |
insert into _base_class values (null,'Device','Device','device');
|
| - |
|
103 |
|
| - |
|
104 |
|
| 85 |
/*
|
105 |
/*
|
| 86 |
simple table to hold ownership information
|
106 |
simple table to hold ownership information
|
| 87 |
*/
|
107 |
*/
|
| 88 |
drop table if exists owner;
|
108 |
drop table if exists owner;
|
| 89 |
create table owner (
|
109 |
create table owner (
|