Subversion Repositories computer_asset_manager_v1

Rev

Rev 103 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 103 Rev 106
Line 30... Line 30...
30 
  PRIMARY KEY     (attrib_device_id)
 30 
  PRIMARY KEY     (attrib_device_id)
31 
)  COMMENT='links devices and their attributes together';
 31 
)  COMMENT='links devices and their attributes together';
32 
 
 32 
 
33 
insert into attrib_category values ( 1,'General',now() );
 33 
insert into attrib_category values ( 1,'General',now() );
34 
 
 34 
 
- 
 
 35 
/* add some indicies */
- 
 
 36 
alter table attrib add index (name);
- 
 
 37 
alter table attrib add index (added_date,removed_date);
- 
 
 38 
 
- 
 
 39 
alter table attrib_device add index (device_id);
- 
 
 40 
alter table attrib_device add index (added_date,removed_date);
- 
 
 41 
 
- 
 
 42 
 
- 
 
 43 
 
35 
/* set up the _system table to plug in the module */
 44 
/* set up the _system table to plug in the module */
36 
/* this is required, and officially installs the module */
 45 
/* this is required, and officially installs the module */
37 
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Attributes', 'modules/attributes/', now() );
 46 
insert into _system ( group_name,key_name,theValue,added_date) values ( 'Modules', 'Attributes', 'modules/attributes/', now() );
38 
/* we will provide data to the main screen via a callback routine. In this case, function view is located in callable.php */
 47 
/* we will provide data to the main screen via a callback routine. In this case, function view is located in callable.php */
39 
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Attributes', 'callable.php:attributeView', now() );
 48 
insert into _system( group_name,key_name,theValue,added_date ) values ( 'device view', 'Attributes', 'callable.php:attributeView', now() );