Subversion Repositories computer_asset_manager_v1

Rev

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

Rev 83 Rev 84
Line 22... Line 22...
22 
      client.removed_date is null
 22 
      client.removed_date is null
23 
      and site.removed_date is null
 23 
      and site.removed_date is null
24 
      and device.removed_date is null
 24 
      and device.removed_date is null
25 
      and device_type.show_as_system = 'Y';
 25 
      and device_type.show_as_system = 'Y';
26 
 
 26 
 
- 
 
 27 
drop table  if exists login_menu;
- 
 
 28 
create table login_menu (
- 
 
 29 
   login_menu_id int unsigned not null auto_increment,
- 
 
 30 
   login_id      int unsigned not null references login(login_id),
- 
 
 31 
   menu_id       int unsigned not null references menu(menu_id),
- 
 
 32 
   primary key   (login_menu_id),
- 
 
 33 
   unique key    (login_id,menu_id)
- 
 
 34 
) comment 'allows access to various menu options';
- 
 
 35 
 
- 
 
 36 
insert into login_menu select null,login_id,menu_id from login,menu where login.email != 'jbellah';
- 
 
 37 
insert into login_menu select null,login_id,menu_id from login,menu where login.email = 'jbellah' and menu.menu_id in (1,8,9,10,12,16);
- 
 
 38 
 
- 
 
 39 
 
27 
alter table _system add constraint group_key unique (group_name,key_name);
 40 
alter table _system add constraint group_key unique (group_name,key_name);
28 
 
 41 
 
29 
insert into _system (_system_id, group_name, key_name, theValue, added_date, removed_date ) values (null,'database','version','1.0',now(),null)
 42 
insert into _system (_system_id, group_name, key_name, theValue, added_date, removed_date ) values (null,'database','version','1.0',now(),null)
30 
on duplicate key update theValue = '1.0';
 43 
on duplicate key update theValue = '1.0';