| |
|
Line 22
|
Parallel
|
Line 22
|
Parallel
|
| 22 |
primary key (filterid), |
22 |
primary key (filterid), |
| 23 |
index filtertypeidindex (filtertypeid), |
23 |
index filtertypeidindex (filtertypeid), |
| 24 |
foreign key (filtertypeid) references FILTERTYPE (filtertypeid) on delete restrict, |
24 |
foreign key (filtertypeid) references FILTERTYPE (filtertypeid) on delete restrict, |
| 25 |
foreign key (userid) references USERDETAILS (userid) on delete restrict |
25 |
foreign key (userid) references USERDETAILS (userid) on delete cascade |
| 26 |
)ENGINE=INNODB; |
26 |
)ENGINE=INNODB; |
| 27 |
|
27 |
|
| 28 |
--This Table holds the Grouping details for filters |
28 |
--This Table holds the Grouping details for filters |
| |