| Line 32... |
Line 32... |
| 32 |
primary key (login_menu_id),
|
32 |
primary key (login_menu_id),
|
| 33 |
unique key (login_id,menu_id)
|
33 |
unique key (login_id,menu_id)
|
| 34 |
) comment 'allows access to various menu options';
|
34 |
) comment 'allows access to various menu options';
|
| 35 |
|
35 |
|
| 36 |
insert into login_menu select null,login_id,menu_id from login,menu where login.email != 'jbellah';
|
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);
|
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,15,16);
|
| 38 |
|
38 |
|
| 39 |
|
39 |
|
| 40 |
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);
|
| 41 |
|
41 |
|
| 42 |
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)
|