[19e22f]: bnc / src / main / resources / org / wnsql / builder / bnc / test.properties  Maximize  Restore  History

Download this file

40 lines (36 with data), 4.5 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
BNCall.table=bncs
BNCall.create=CREATE TABLE IF NOT EXISTS %BNCall.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq INTEGER UNSIGNED DEFAULT NULL,`range` SMALLINT UNSIGNED DEFAULT NULL,disp FLOAT DEFAULT NULL,PRIMARY KEY (wordid,pos)) DEFAULT CHARSET=utf8;
BNCall.pk=ALTER TABLE %BNCall.table% ADD CONSTRAINT pk_%BNCall.table% PRIMARY KEY (wordid,pos);
BNCall.no-pk=ALTER TABLE %BNCall.table% DROP PRIMARY KEY;
BNCall.index=ALTER TABLE %BNCall.table% ADD INDEX k_%BNCall.table%_wordid (wordid);
BNCall.no-index=ALTER TABLE %BNCall.table% DROP INDEX k_%BNCall.table%_wordid;
BNCall.fk=ALTER TABLE %BNCall.table% ADD CONSTRAINT fk_%BNCall.table%_wordid FOREIGN KEY k_%BNCall.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
BNCall.no-fk=ALTER TABLE %BNCall.table% DROP FOREIGN KEY fk_%BNCall.table%_wordid;
BNCall.insert=INSERT INTO %BNCall.table% (wordid,pos,freq,`range`,disp) VALUES (?,?,?,?,?);
BNCspwr.table=bncspwrs
BNCspwr.create=CREATE TABLE IF NOT EXISTS %BNCspwr.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq1 INTEGER UNSIGNED DEFAULT NULL,range1 SMALLINT UNSIGNED DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 INTEGER UNSIGNED DEFAULT NULL,range2 SMALLINT UNSIGNED DEFAULT NULL,disp2 FLOAT DEFAULT NULL,ll FLOAT DEFAULT NULL,PRIMARY KEY (wordid,pos)) DEFAULT CHARSET=utf8;
BNCspwr.pk=ALTER TABLE %BNCspwr.table% ADD CONSTRAINT pk_%BNCspwr.table% PRIMARY KEY (wordid,pos);
BNCspwr.no-pk=ALTER TABLE %BNCspwr.table% DROP PRIMARY KEY;
BNCspwr.index=ALTER TABLE %BNCspwr.table% ADD INDEX k_%BNCspwr.table%_wordid (wordid);
BNCspwr.no-index=ALTER TABLE %BNCspwr.table% DROP INDEX k_%BNCspwr.table%_wordid;
BNCspwr.fk=ALTER TABLE %BNCspwr.table% ADD CONSTRAINT fk_%BNCspwr.table%_wordid FOREIGN KEY k_%BNCspwr.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
BNCspwr.no-fk=ALTER TABLE %BNCspwr.table% DROP FOREIGN KEY fk_%BNCspwr.table%_wordid;
BNCspwr.insert=INSERT INTO %BNCspwr.table% (wordid,pos,freq1,range1,disp1,freq2,range2,disp2,ll) VALUES (?,?,?,?,?,?,?,?,?);
BNCconvtask.table=bncconvtasks
BNCconvtask.create=CREATE TABLE IF NOT EXISTS %BNCconvtask.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq1 INTEGER UNSIGNED DEFAULT NULL,range1 SMALLINT UNSIGNED DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 INTEGER UNSIGNED DEFAULT NULL,range2 SMALLINT UNSIGNED DEFAULT NULL,disp2 FLOAT DEFAULT NULL,ll FLOAT DEFAULT NULL,PRIMARY KEY (wordid,pos)) DEFAULT CHARSET=utf8;
BNCconvtask.pk=ALTER TABLE %BNCconvtask.table% ADD CONSTRAINT pk_%BNCconvtask.table% PRIMARY KEY (wordid,pos);
BNCconvtask.no-pk=ALTER TABLE %BNCconvtask.table% DROP PRIMARY KEY;
BNCconvtask.index=ALTER TABLE %BNCconvtask.table% ADD INDEX k_%BNCconvtask.table%_wordid (wordid);
BNCconvtask.no-index=ALTER TABLE %BNCconvtask.table% DROP INDEX k_%BNCconvtask.table%_wordid;
BNCconvtask.fk=ALTER TABLE %BNCconvtask.table% ADD CONSTRAINT fk_%BNCconvtask.table%_wordid FOREIGN KEY k_%BNCconvtask.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
BNCconvtask.no-fk=ALTER TABLE %BNCconvtask.table% DROP FOREIGN KEY fk_%BNCconvtask.table%_wordid;
BNCconvtask.insert=INSERT INTO %BNCconvtask.table% (wordid,pos,freq1,range1,disp1,freq2,range2,disp2,ll) VALUES (?,?,?,?,?,?,?,?,?);
BNCimaginf.table=bncimaginfs
BNCimaginf.create=CREATE TABLE IF NOT EXISTS %BNCimaginf.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq1 INTEGER UNSIGNED DEFAULT NULL,range1 SMALLINT UNSIGNED DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 INTEGER UNSIGNED DEFAULT NULL,range2 SMALLINT UNSIGNED DEFAULT NULL,disp2 FLOAT DEFAULT NULL,ll FLOAT DEFAULT NULL,PRIMARY KEY (wordid,pos)) DEFAULT CHARSET=utf8;
BNCimaginf.pk=ALTER TABLE %BNCimaginf.table% ADD CONSTRAINT pk_%BNCimaginf.table% PRIMARY KEY (wordid,pos);
BNCimaginf.no-pk=ALTER TABLE %BNCimaginf.table% DROP PRIMARY KEY;
BNCimaginf.index=ALTER TABLE %BNCimaginf.table% ADD INDEX k_%BNCimaginf.table%_wordid (wordid);
BNCimaginf.no-index=ALTER TABLE %BNCimaginf.table% DROP INDEX k_%BNCimaginf.table%_wordid;
BNCimaginf.fk=ALTER TABLE %BNCimaginf.table% ADD CONSTRAINT fk_%BNCimaginf.table%_wordid FOREIGN KEY k_%BNCimaginf.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
BNCimaginf.no-fk=ALTER TABLE %BNCimaginf.table% DROP FOREIGN KEY fk_%BNCimaginf.table%_wordid;
BNCimaginf.insert=INSERT INTO %BNCimaginf.table% (wordid,pos,freq1,range1,disp1,freq2,range2,disp2,ll) VALUES (?,?,?,?,?,?,?,?,?);

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks