· 7 years ago · Sep 18, 2018, 01:48 PM
1sql code for firebird doesn't compile
2SET SQL DIALECT 3;
3SET NAMES UTF8;
4CREATE DATABASE 'localhost:C:fuzzdb.fdb' user 'SYSDBA' password 'masterkey'
5DEFAULT CHARACTER SET UTF8;
6
7CREATE TABLE RULES (
8RULE_ID INTEGER NOT NULL,
9IF_FUZZY SMALLINT,
10CONSTRAINT PK_RULE_ID
11PRIMARY KEY (RULE_ID),
12);
13
14CREATE TABLE VARS (
15VAR_ID INTEGER NOT NULL,
16VRULE_ID INTEGER,
17INPOUTP SMALLINT,
18RANGE_STRT INTEGER,
19RANGE_END INTEGER,
20VAR_NAME VARCHAR(40),
21FUZ_SET INTEGER,
22CONSTRAINT PK_VAR_ID
23PRIMARY KEY (VAR_ID)
24);
25
26CREATE TABLE FUZZSETS (
27FS_ID INTEGER NOT NULL,
28FS_NAME VARCHAR(40),
29INPOUTP SMALLINT,
30PAR1 FLOAT,
31PAR2 FLOAT,
32PAR3 FLOAT,
33PAR4 FLOAT,
34PAR5_HEDGE INTEGER,
35FUZ_SET INTEGER,
36CONSTRAINT PK_FS_ID
37 PRIMARY KEY (FS_ID)
38);
39
40CREATE TABLE FRULES (
41FRULE_ID INTEGER NOT NULL,
42RULE_ID INTEGER,
43VAR_ID INTEGER,
44FS_ID INTEGER,
45INPOUTP SMALLINT,
46CONSTRAINT PK_FRULE_ID
47PRIMARY KEY (FRULE_ID)
48);
49
50CREATE TABLE LINK_RV (
51LINK_RULES INTEGER,
52LINK_VARS INTEGER,
53CONSTRAINT FK_LINK_RV
54PRIMARY KEY (LINK_RULES, LINK_VARS)
55);
56
57CREATE TABLE LINK_VARFS (
58LINK_VRS INTEGER,
59LINK_FS INTEGER,
60CONSTRAINT FK_LINK_VARFS
61PRIMARY KEY (LINK_VRS, LINK_FS)
62);
63
64CREATE TABLE LINK_RLVR (
65LINK_RULE INTEGER NOT NULL,
66LINK_VR INTEGER NOT NULL,
67CONSTRAINT FK_LINK_RLVR
68PRIMARY KEY (LINK_RULE, LINK_VR)
69);
70
71CREATE TABLE LINK_FRL_RL (
72LINK_FRULE INTEGER NOT NULL,
73LINK_RULE INTEGER NOT NULL,
74CONSTRAINT FK_LINK_FRL_RL
75PRIMARY KEY (LINK_FRULE, LINK_RULE)
76);
77
78CREATE TABLE LINK_FRL_VAR (
79LINK_FRULE INTEGER NOT NULL,
80LINK_VAR INTEGER NOT NULL,
81CONSTRAINT FK_LINK_FRL_VAR
82PRIMARY KEY (LINK_FRULE, LINK_VAR)
83);
84
85CREATE TABLE LINK_FRL_FS (
86LINK_FSRULE INTEGER NOT NULL,
87LINK_FS INTEGER NOT NULL,
88CONSTRAINT FK_LINK_FRL_FS
89PRIMARY KEY (LINK_FRULE, LINK_FS)
90);
91
92ALTER TABLE LINK_FRL_FS
93ADD CONSTRAINT FK_LINK_FSRULE
94FOREIGN KEY(LINK_FSRULE)
95REFERENCES FRULES(FRULE_ID);
96
97ALTER TABLE LINK_FRL_FS
98ADD CONSTRAINT FK_LINK_FS
99FOREIGN KEY(LINK_FS)
100REFERENCES FUZZSETS(FS_ID);
101
102ALTER TABLE LINK_FRL_VAR
103ADD CONSTRAINT FK_LINK_FRULE
104FOREIGN KEY(LINK_FRULE)
105REFERENCES FRULES(FRULE_ID);
106
107ALTER TABLE LINK_FRL_VAR
108ADD CONSTRAINT FK_LINK_VAR
109FOREIGN KEY(LINK_VAR)
110REFERENCES FUZZSETS(VAR_ID);
111
112ALTER TABLE LINK_FRL_RL
113ADD CONSTRAINT FK_LINK_FRULE
114FOREIGN KEY(LINK_FRULE)
115REFERENCES FRULES(FRULE_ID);
116
117ALTER TABLE LINK_FRL_RL
118ADD CONSTRAINT FK_LINK_RULE
119FOREIGN KEY(LINK_RULE)
120REFERENCES RULES(RULE_ID);
121
122CREATE GENERATOR GEN_RULE_ID;
123CREATE GENERATOR GEN_VAR_ID;
124CREATE GENERATOR GEN_FS_ID;
125CREATE GENERATOR GEN_FRULE_ID;
126
127SET TERM ^ ;
128
129CREATE TRIGGER BI_RULES FOR RULES
130ACTIVE BEFORE INSERT POSITION 0
131AS
132BEGIN
133IF (NEW.RULE_ID IS NULL) THEN
134 NEW.RULE_ID = GEN_ID(GEN_RULE_ID, 1);
135END^
136
137CREATE TRIGGER BI_VARS FOR VARS
138ACTIVE BEFORE INSERT POSITION 0
139AS
140BEGIN
141IF (NEW.VAR_ID IS NULL) THEN
142 NEW.VAR_ID = GEN_ID(GEN_VAR_ID, 1);
143END^
144
145CREATE TRIGGER BI_FUZZSETS FOR FUZZSETS
146ACTIVE BEFORE INSERT POSITION 0
147AS
148BEGIN
149IF (NEW.FS_ID IS NULL) THEN
150 NEW.FS_ID = GEN_ID(GEN_FS_ID, 1);
151END^
152
153CREATE TRIGGER BI_FRULES FOR FRULES
154ACTIVE BEFORE INSERT POSITION 0
155AS
156BEGIN
157IF (NEW.FRULE_ID IS NULL) THEN
158 NEW.FRULE_ID = GEN_ID(GEN_FRULE_ID, 1);
159END^
160
161SET TERM ; ^
162COMMIT;
163
164Use CONNECT or CREATE DATABASE to specify a database
165Statement failed, SQLSTATE = 42000
166Dynamic SQL Error
167-SQL error code = -104
168-Token unknown - line 6, column 3
169-)
170At line 10 in file c:fdb.sql
171Statement failed, SQLSTATE = 42000
172unsuccessful metadata update
173-Unknown columns in index FK_LINK_FRL_FS
174After line 82 in file c:fdb.sql
175Statement failed, SQLSTATE = 42S02
176Dynamic SQL Error
177-SQL error code = -204
178-Table unknown
179-LINK_FRL_FS
180-At line 1, column 13.
181After line 89 in file c:fdb.sql
182Statement failed, SQLSTATE = 42S02
183Dynamic SQL Error
184-SQL error code = -204
185-Table unknown
186-LINK_FRL_FS
187-At line 1, column 13.
188After line 94 in file c:fdb.sql
189Statement failed, SQLSTATE = 42000
190unsuccessful metadata update
191-could not find UNIQUE or PRIMARY KEY constraint in table FUZZSETS with specifie
192d columns
193After line 104 in file c:fdb.sql
194Statement failed, SQLSTATE = 42S11
195unsuccessful metadata update
196-Index FK_LINK_FRULE already exists
197After line 109 in file c:fdb.sql
198Statement failed, SQLSTATE = 42000
199unsuccessful metadata update
200-Table RULES not found
201After line 114 in file c:fdb.sql
202Statement failed, SQLSTATE = 42S02
203Dynamic SQL Error
204-SQL error code = -204
205-Table unknown
206-RULES
207-At line 1, column 29
208At line 130 in file c:fdb.sql
209
210CONSTRAINT PK_RULE_ID
211PRIMARY KEY (RULE_ID),