Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

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

Download this file

test.properties    40 lines (36 with data), 4.6 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 MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq MEDIUMINT 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 MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq1 MEDIUMINT UNSIGNED DEFAULT NULL,range1 SMALLINT UNSIGNED DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 MEDIUMINT 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 MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq1 MEDIUMINT UNSIGNED DEFAULT NULL,range1 SMALLINT UNSIGNED DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 MEDIUMINT 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 MEDIUMINT UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,freq1 MEDIUMINT UNSIGNED DEFAULT NULL,range1 SMALLINT UNSIGNED DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 MEDIUMINT 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 (?,?,?,?,?,?,?,?,?);