|
1 | | -QUERY:create table Room ( |
| 1 | +create table Room ( |
2 | 2 | roomnochar(8), |
3 | 3 | commenttext |
4 | 4 | ); |
5 | | -QUERY:create unique index Room_rno on Room using btree (roomno bpchar_ops); |
6 | | -QUERY:create table WSlot ( |
| 5 | +create unique index Room_rno on Room using btree (roomno bpchar_ops); |
| 6 | +create table WSlot ( |
7 | 7 | slotnamechar(20), |
8 | 8 | roomnochar(8), |
9 | 9 | slotlinkchar(20), |
10 | 10 | backlinkchar(20) |
11 | 11 | ); |
12 | | -QUERY:create unique index WSlot_name on WSlot using btree (slotname bpchar_ops); |
13 | | -QUERY:create table PField ( |
| 12 | +create unique index WSlot_name on WSlot using btree (slotname bpchar_ops); |
| 13 | +create table PField ( |
14 | 14 | nametext, |
15 | 15 | commenttext |
16 | 16 | ); |
17 | | -QUERY:create unique index PField_name on PField using btree (name text_ops); |
18 | | -QUERY:create table PSlot ( |
| 17 | +create unique index PField_name on PField using btree (name text_ops); |
| 18 | +create table PSlot ( |
19 | 19 | slotnamechar(20), |
20 | 20 | pfnametext, |
21 | 21 | slotlinkchar(20), |
22 | 22 | backlinkchar(20) |
23 | 23 | ); |
24 | | -QUERY:create unique index PSlot_name on PSlot using btree (slotname bpchar_ops); |
25 | | -QUERY:create table PLine ( |
| 24 | +create unique index PSlot_name on PSlot using btree (slotname bpchar_ops); |
| 25 | +create table PLine ( |
26 | 26 | slotnamechar(20), |
27 | 27 | phonenumberchar(20), |
28 | 28 | commenttext, |
29 | 29 | backlinkchar(20) |
30 | 30 | ); |
31 | | -QUERY:create unique index PLine_name on PLine using btree (slotname bpchar_ops); |
32 | | -QUERY:create table Hub ( |
| 31 | +create unique index PLine_name on PLine using btree (slotname bpchar_ops); |
| 32 | +create table Hub ( |
33 | 33 | namechar(14), |
34 | 34 | commenttext, |
35 | 35 | nslotsinteger |
36 | 36 | ); |
37 | | -QUERY:create unique index Hub_name on Hub using btree (name bpchar_ops); |
38 | | -QUERY:create table HSlot ( |
| 37 | +create unique index Hub_name on Hub using btree (name bpchar_ops); |
| 38 | +create table HSlot ( |
39 | 39 | slotnamechar(20), |
40 | 40 | hubnamechar(14), |
41 | 41 | slotnointeger, |
42 | 42 | slotlinkchar(20) |
43 | 43 | ); |
44 | | -QUERY:create unique index HSlot_name on HSlot using btree (slotname bpchar_ops); |
45 | | -QUERY:create index HSlot_hubname on HSlot using btree (hubname bpchar_ops); |
46 | | -QUERY:create table System ( |
| 44 | +create unique index HSlot_name on HSlot using btree (slotname bpchar_ops); |
| 45 | +create index HSlot_hubname on HSlot using btree (hubname bpchar_ops); |
| 46 | +create table System ( |
47 | 47 | nametext, |
48 | 48 | commenttext |
49 | 49 | ); |
50 | | -QUERY:create unique index System_name on System using btree (name text_ops); |
51 | | -QUERY:create table IFace ( |
| 50 | +create unique index System_name on System using btree (name text_ops); |
| 51 | +create table IFace ( |
52 | 52 | slotnamechar(20), |
53 | 53 | sysnametext, |
54 | 54 | ifnametext, |
55 | 55 | slotlinkchar(20) |
56 | 56 | ); |
57 | | -QUERY:create unique index IFace_name on IFace using btree (slotname bpchar_ops); |
58 | | -QUERY:create table PHone ( |
| 57 | +create unique index IFace_name on IFace using btree (slotname bpchar_ops); |
| 58 | +create table PHone ( |
59 | 59 | slotnamechar(20), |
60 | 60 | commenttext, |
61 | 61 | slotlinkchar(20) |
62 | 62 | ); |
63 | | -QUERY:create unique index PHone_name on PHone using btree (slotname bpchar_ops); |
| 63 | +create unique index PHone_name on PHone using btree (slotname bpchar_ops); |