Diff of /bnc/src/main/resources/org/wnsql/builder/bnc/test.properties [667a13] .. [5a71fa]  Maximize  Restore

Switch to side-by-side view

--- a/bnc/src/main/resources/org/wnsql/builder/bnc/test.properties
+++ b/bnc/src/main/resources/org/wnsql/builder/bnc/test.properties
@@ -1,39 +1,39 @@
 BNCall.table=bncs
-BNCall.create=CREATE TABLE IF NOT EXISTS %BNCall.table% (wordid INTEGER NOT NULL DEFAULT '0',pos CHARACTER (1) DEFAULT NULL,freq INTEGER DEFAULT NULL,range SMALLINT DEFAULT NULL,disp FLOAT DEFAULT NULL,CONSTRAINT pk_%BNCall.table% PRIMARY KEY (wordid,pos));
+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 CONSTRAINT pk_%BNCall.table% CASCADE;
-BNCall.index=CREATE INDEX k_%BNCall.table%_wordid ON %BNCall.table% (wordid);
-BNCall.no-index=DROP INDEX k_%BNCall.table%_wordid;
-BNCall.fk=ALTER TABLE %BNCall.table% ADD CONSTRAINT fk_%BNCall.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-BNCall.no-fk=ALTER TABLE %BNCall.table% DROP CONSTRAINT fk_%BNCall.table%_wordid CASCADE;
-BNCall.insert=INSERT INTO %BNCall.table% (wordid,pos,freq,range,disp) VALUES (?,?,?,?,?);
+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 NOT NULL DEFAULT '0',pos CHARACTER (1) DEFAULT NULL,freq1 INTEGER DEFAULT NULL,range1 SMALLINT DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 INTEGER DEFAULT NULL,range2 SMALLINT DEFAULT NULL,disp2 FLOAT DEFAULT NULL,ll FLOAT DEFAULT NULL,CONSTRAINT pk_%BNCspwr.table% PRIMARY KEY (wordid,pos));
+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 CONSTRAINT pk_%BNCspwr.table% CASCADE;
-BNCspwr.index=CREATE INDEX k_%BNCspwr.table%_wordid ON %BNCspwr.table% (wordid);
-BNCspwr.no-index=DROP INDEX k_%BNCspwr.table%_wordid;
-BNCspwr.fk=ALTER TABLE %BNCspwr.table% ADD CONSTRAINT fk_%BNCspwr.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-BNCspwr.no-fk=ALTER TABLE %BNCspwr.table% DROP CONSTRAINT fk_%BNCspwr.table%_wordid CASCADE;
+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 NOT NULL DEFAULT '0',pos CHARACTER (1) DEFAULT NULL,freq1 INTEGER DEFAULT NULL,range1 SMALLINT DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 INTEGER DEFAULT NULL,range2 SMALLINT DEFAULT NULL,disp2 FLOAT DEFAULT NULL,ll FLOAT DEFAULT NULL,CONSTRAINT pk_%BNCconvtask.table% PRIMARY KEY (wordid,pos));
+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 CONSTRAINT pk_%BNCconvtask.table% CASCADE;
-BNCconvtask.index=CREATE INDEX k_%BNCconvtask.table%_wordid ON %BNCconvtask.table% (wordid);
-BNCconvtask.no-index=DROP INDEX k_%BNCconvtask.table%_wordid;
-BNCconvtask.fk=ALTER TABLE %BNCconvtask.table% ADD CONSTRAINT fk_%BNCconvtask.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-BNCconvtask.no-fk=ALTER TABLE %BNCconvtask.table% DROP CONSTRAINT fk_%BNCconvtask.table%_wordid CASCADE;
+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 NOT NULL DEFAULT '0',pos CHARACTER (1) DEFAULT NULL,freq1 INTEGER DEFAULT NULL,range1 SMALLINT DEFAULT NULL,disp1 FLOAT DEFAULT NULL,freq2 INTEGER DEFAULT NULL,range2 SMALLINT DEFAULT NULL,disp2 FLOAT DEFAULT NULL,ll FLOAT DEFAULT NULL,CONSTRAINT pk_%BNCimaginf.table% PRIMARY KEY (wordid,pos));
+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 CONSTRAINT pk_%BNCimaginf.table% CASCADE;
-BNCimaginf.index=CREATE INDEX k_%BNCimaginf.table%_wordid ON %BNCimaginf.table% (wordid);
-BNCimaginf.no-index=DROP INDEX k_%BNCimaginf.table%_wordid;
-BNCimaginf.fk=ALTER TABLE %BNCimaginf.table% ADD CONSTRAINT fk_%BNCimaginf.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-BNCimaginf.no-fk=ALTER TABLE %BNCimaginf.table% DROP CONSTRAINT fk_%BNCimaginf.table%_wordid CASCADE;
+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:

JavaScript is required for this form.





No, thanks