| |
|
Line 12
|
Parallel
|
Line 12
|
Parallel
|
| 12 |
version NUMERIC(18) default 1, |
12 |
version NUMERIC(18) default 1, |
| 13 |
primary key (filterid) , |
13 |
primary key (filterid) , |
| 14 |
foreign key (filtertypeid) references FILTERTYPE (filtertypeid), |
14 |
foreign key (filtertypeid) references FILTERTYPE (filtertypeid), |
| 15 |
foreign key (userid) references USERDETAILS (userid) ); |
15 |
foreign key (userid) references USERDETAILS (userid) on delete cascade ); |
| 16 |
|
16 |
|
| 17 |
CREATE table FILTERGROUP ( filtergroupid NUMERIC(15) NOT NULL, |
17 |
CREATE table FILTERGROUP ( filtergroupid NUMERIC(15) NOT NULL, |
| 18 |
filterid NUMERIC(15) NOT NULL, |
18 |
filterid NUMERIC(15) NOT NULL, |
| |