BEGIN TRANSACTION;
CREATE TABLE "_yatel_fields" ("id" INTEGER NOT NULL PRIMARY KEY, "name" VARCHAR(255) NOT NULL, "table_id" INTEGER NOT NULL REFERENCES "_yatel_tables" ("id") , "type" VARCHAR(255) NOT NULL, "reference_to_id" INTEGER REFERENCES "_yatel_tables" ("id") , "is_pk" SMALLINT NOT NULL);
INSERT INTO _yatel_fields VALUES(1,'attr_2',1,'CharField',NULL,0);
INSERT INTO _yatel_fields VALUES(2,'attr_3',1,'BooleanField',NULL,0);
INSERT INTO _yatel_fields VALUES(3,'attr_0',1,'BigIntegerField',NULL,0);
INSERT INTO _yatel_fields VALUES(4,'hap_id',1,'CharField',NULL,1);
INSERT INTO _yatel_fields VALUES(5,'attr_1',1,'DoubleField',NULL,0);
INSERT INTO _yatel_fields VALUES(6,'haplotype',2,'ForeignKeyField',1,0);
INSERT INTO _yatel_fields VALUES(7,'k',2,'BigIntegerField',NULL,0);
INSERT INTO _yatel_fields VALUES(8,'b',2,'BigIntegerField',NULL,0);
INSERT INTO _yatel_fields VALUES(9,'c',2,'BigIntegerField',NULL,0);
INSERT INTO _yatel_fields VALUES(10,'weight',3,'DoubleField',NULL,0);
INSERT INTO _yatel_fields VALUES(11,'haplotype_0',3,'ForeignKeyField',1,0);
INSERT INTO _yatel_fields VALUES(12,'haplotype_1',3,'ForeignKeyField',1,0);
CREATE TABLE "_yatel_tables" ("id" INTEGER NOT NULL PRIMARY KEY, "type" VARCHAR(255) NOT NULL, "name" VARCHAR(255) NOT NULL);
INSERT INTO _yatel_tables VALUES(1,'haplotypes','haplotypes');
INSERT INTO _yatel_tables VALUES(2,'facts','facts');
INSERT INTO _yatel_tables VALUES(3,'edges','edges');
CREATE TABLE "_yatel_versions" ("id" INTEGER NOT NULL PRIMARY KEY, "datetime" DATETIME NOT NULL, "tag" VARCHAR(255) NOT NULL, "data" TEXT NOT NULL, "comment" TEXT NOT NULL);
INSERT INTO _yatel_versions VALUES(1,'2012-10-16 23:28:12.172322','init','eyJoYXBfc3FsIjogIiIsICJ3ZWlnaHRfcmFuZ2UiOiBbbnVsbCwgbnVsbF0sICJlbnZpcm9tZW50
cyI6IFtdLCAidG9wb2xvZ3kiOiB7fX0=
','first save');
INSERT INTO _yatel_versions VALUES(2,'2012-10-16 23:42:22.064629','topology_added','eyJoYXBfc3FsIjogIlNFTEVDVCAqIEZST00gYGhhcGxvdHlwZXNgIiwgIndlaWdodF9yYW5nZSI6
IFs3LCAxMDFdLCAiZW52aXJvbWVudHMiOiBbXSwgInRvcG9sb2d5IjogeyJoYXBsb3R5cGVfMzgi
OiBbMjMxLCAtNjZdLCAiaGFwbG90eXBlXzM5IjogWzM5LCAtMzRdLCAiaGFwbG90eXBlXzM2Ijog
Wy0yNjksIDY5XSwgImhhcGxvdHlwZV8zNyI6IFstMjYxLCAxNDJdLCAiaGFwbG90eXBlXzIxIjog
WzUzLCAtODFdLCAiaGFwbG90eXBlXzIwIjogWy0yLCAxMzNdLCAiaGFwbG90eXBlXzIzIjogWy0y
NSwgLTk4XSwgImhhcGxvdHlwZV8yMiI6IFstMjIzLCAxMDZdLCAiaGFwbG90eXBlXzI1IjogWzE4
NiwgMjVdLCAiaGFwbG90eXBlXzI0IjogWy02MSwgOTVdLCAiaGFwbG90eXBlXzI3IjogWzE0MSwg
NV0sICJoYXBsb3R5cGVfMjYiOiBbMTkyLCAxMzFdLCAiaGFwbG90eXBlXzI5IjogWzU0LCAtMzJd
LCAiaGFwbG90eXBlXzI4IjogWzIyMCwgLTIwXSwgImhhcGxvdHlwZV80NyI6IFsxMTYsIC00Ml0s
ICJoYXBsb3R5cGVfNDYiOiBbLTI3MiwgNTFdLCAiaGFwbG90eXBlXzQ1IjogWzk1LCA2Ml0sICJo
YXBsb3R5cGVfNDQiOiBbODgsIDcyXSwgImhhcGxvdHlwZV80MyI6IFs3NCwgNjldLCAiaGFwbG90
eXBlXzQyIjogWzIxNCwgLTc5XSwgImhhcGxvdHlwZV80MSI6IFstMjM2LCAyOF0sICJoYXBsb3R5
cGVfNDAiOiBbMTk2LCAzNV0sICJoYXBsb3R5cGVfNiI6IFsxNzEsIDU4XSwgImhhcGxvdHlwZV83
IjogWzIwLCAtOTJdLCAiaGFwbG90eXBlXzQiOiBbMjI5LCAtNzRdLCAiaGFwbG90eXBlXzUiOiBb
MjgxLCA5Nl0sICJoYXBsb3R5cGVfMiI6IFsyMzUsIC0xMDhdLCAiaGFwbG90eXBlXzMiOiBbMjA5
LCAxMDFdLCAiaGFwbG90eXBlXzAiOiBbLTE4LCAxMTRdLCAiaGFwbG90eXBlXzEiOiBbMzksIC02
NV0sICJoYXBsb3R5cGVfOCI6IFsxNTMsIDQ0XSwgImhhcGxvdHlwZV85IjogWy03OCwgLTEzXSwg
ImhhcGxvdHlwZV8xOCI6IFs5NCwgNDRdLCAiaGFwbG90eXBlXzE5IjogWzU2LCAtMTQ5XSwgImhh
cGxvdHlwZV8zNCI6IFsxMjMsIDEwN10sICJoYXBsb3R5cGVfMzUiOiBbNDgsIDU2XSwgImhhcGxv
dHlwZV8zMiI6IFstMTg5LCAzXSwgImhhcGxvdHlwZV8zMyI6IFsxNTMsIC00M10sICJoYXBsb3R5
cGVfMzAiOiBbOTcsIC0yN10sICJoYXBsb3R5cGVfMzEiOiBbMjk3LCAtNThdLCAiaGFwbG90eXBl
XzEwIjogWy0yMTksIC0xNDFdLCAiaGFwbG90eXBlXzExIjogWy0yMjksIDI3XSwgImhhcGxvdHlw
ZV8xMiI6IFstMjk5LCAyNV0sICJoYXBsb3R5cGVfMTMiOiBbMTE5LCAtMjJdLCAiaGFwbG90eXBl
XzE0IjogWzI5NiwgMTE3XSwgImhhcGxvdHlwZV8xNSI6IFs1LCAtMTE1XSwgImhhcGxvdHlwZV8x
NiI6IFsxOTcsIC01Ml0sICJoYXBsb3R5cGVfMTciOiBbNTcsIC03NF19fQ==
','added topological info');
INSERT INTO _yatel_versions VALUES(3,'2012-10-16 23:47:13.338201','ddd','eyJoYXBfc3FsIjogIlNFTEVDVCAqIEZST00gYGhhcGxvdHlwZXNgIiwgIndlaWdodF9yYW5nZSI6
IFs3LCA3XSwgImVudmlyb21lbnRzIjogW10sICJ0b3BvbG9neSI6IHsiaGFwbG90eXBlXzM4Ijog
WzIzMSwgLTY2XSwgImhhcGxvdHlwZV8zOSI6IFszOSwgLTM0XSwgImhhcGxvdHlwZV8zNiI6IFst
MjY5LCA2OV0sICJoYXBsb3R5cGVfMzciOiBbLTI2MSwgMTM5LjBdLCAiaGFwbG90eXBlXzIxIjog
WzUzLCAtODFdLCAiaGFwbG90eXBlXzIwIjogWy0yLCAxMzNdLCAiaGFwbG90eXBlXzIzIjogWy0y
NSwgLTk4XSwgImhhcGxvdHlwZV8yMiI6IFstMTI4LjE0NzA1ODgyMzUyOTQsIDIzLjI3OTQxMTc2
NDcwNTg4NF0sICJoYXBsb3R5cGVfMjUiOiBbMTg2LCAyNV0sICJoYXBsb3R5cGVfMjQiOiBbLTYx
LCA5NV0sICJoYXBsb3R5cGVfMjciOiBbMTQxLCA1XSwgImhhcGxvdHlwZV8yNiI6IFsxOTIsIDEz
MV0sICJoYXBsb3R5cGVfMjkiOiBbNTQsIC0zMl0sICJoYXBsb3R5cGVfMjgiOiBbMjIwLCAtMjBd
LCAiaGFwbG90eXBlXzQ3IjogWzExNiwgLTQyXSwgImhhcGxvdHlwZV80NiI6IFstMjcyLCA1MV0s
ICJoYXBsb3R5cGVfNDUiOiBbOTUsIDYyXSwgImhhcGxvdHlwZV80NCI6IFs4OCwgNzJdLCAiaGFw
bG90eXBlXzQzIjogWzc0LCA2OV0sICJoYXBsb3R5cGVfNDIiOiBbMjE0LCAtNzldLCAiaGFwbG90
eXBlXzQxIjogWy0yMzYsIDI4XSwgImhhcGxvdHlwZV80MCI6IFsxOTYsIDM1XSwgImhhcGxvdHlw
ZV82IjogWzE3MSwgNThdLCAiaGFwbG90eXBlXzciOiBbMjAsIC05Ml0sICJoYXBsb3R5cGVfNCI6
IFsyMjksIC03NF0sICJoYXBsb3R5cGVfNSI6IFsyODEsIDk2XSwgImhhcGxvdHlwZV8yIjogWzIz
NSwgLTEwOF0sICJoYXBsb3R5cGVfMyI6IFsyMDksIDEwMV0sICJoYXBsb3R5cGVfMCI6IFstMTgs
IDExNF0sICJoYXBsb3R5cGVfMSI6IFszOSwgLTY1XSwgImhhcGxvdHlwZV84IjogWzE1MywgNDRd
LCAiaGFwbG90eXBlXzkiOiBbLTc4LCAtMTNdLCAiaGFwbG90eXBlXzE4IjogWzk0LCA0NF0sICJo
YXBsb3R5cGVfMTkiOiBbNTYsIC0xMzguMF0sICJoYXBsb3R5cGVfMzQiOiBbMTIzLCAxMDddLCAi
aGFwbG90eXBlXzM1IjogWzQ4LCA1Nl0sICJoYXBsb3R5cGVfMzIiOiBbLTE4OSwgM10sICJoYXBs
b3R5cGVfMzMiOiBbMTUzLCAtNDNdLCAiaGFwbG90eXBlXzMwIjogWzk3LCAtMjddLCAiaGFwbG90
eXBlXzMxIjogWzI4OC4wLCAtNThdLCAiaGFwbG90eXBlXzEwIjogWy0yMTksIC0xMzguMF0sICJo
YXBsb3R5cGVfMTEiOiBbLTIyOSwgMjddLCAiaGFwbG90eXBlXzEyIjogWy0yODkuMCwgMjVdLCAi
aGFwbG90eXBlXzEzIjogWzExOSwgLTIyXSwgImhhcGxvdHlwZV8xNCI6IFsyODguMCwgMTE3XSwg
ImhhcGxvdHlwZV8xNSI6IFs1LCAtMTE1XSwgImhhcGxvdHlwZV8xNiI6IFsxOTcsIC01Ml0sICJo
YXBsb3R5cGVfMTciOiBbNTcsIC03NF19fQ==
','ddd');
INSERT INTO _yatel_versions VALUES(4,'2012-10-19 00:07:02.723837','ddde','eyJoYXBfc3FsIjogIlNFTEVDVCAqIEZST00gYGhhcGxvdHlwZXNgIiwgIndlaWdodF9yYW5nZSI6
IFs3LCAxMV0sICJlbnZpcm9tZW50cyI6IFtdLCAidG9wb2xvZ3kiOiB7ImhhcGxvdHlwZV8zOCI6
IFsyMzEsIC02Nl0sICJoYXBsb3R5cGVfMzkiOiBbMzksIC0zNF0sICJoYXBsb3R5cGVfMzYiOiBb
LTI2OSwgNjldLCAiaGFwbG90eXBlXzM3IjogWy0yNjEsIDEzOS4wXSwgImhhcGxvdHlwZV8yMSI6
IFs1MywgLTgxXSwgImhhcGxvdHlwZV8yMCI6IFstMiwgMTMzXSwgImhhcGxvdHlwZV8yMyI6IFst
MjUsIC05OF0sICJoYXBsb3R5cGVfMjIiOiBbLTEyOC4xNDcwNTg4MjM1Mjk0LCAyMy4yNzk0MTE3
NjQ3MDU4ODRdLCAiaGFwbG90eXBlXzI1IjogWzE4NiwgMjVdLCAiaGFwbG90eXBlXzI0IjogWy02
MSwgOTVdLCAiaGFwbG90eXBlXzI3IjogWzE0MSwgNV0sICJoYXBsb3R5cGVfMjYiOiBbMTkyLCAx
MzFdLCAiaGFwbG90eXBlXzI5IjogWzU0LCAtMzJdLCAiaGFwbG90eXBlXzI4IjogWzIyMCwgLTIw
XSwgImhhcGxvdHlwZV80NyI6IFsxMTYsIC00Ml0sICJoYXBsb3R5cGVfNDYiOiBbLTI3MiwgNTFd
LCAiaGFwbG90eXBlXzQ1IjogWzk1LCA2Ml0sICJoYXBsb3R5cGVfNDQiOiBbODgsIDcyXSwgImhh
cGxvdHlwZV80MyI6IFs3NCwgNjldLCAiaGFwbG90eXBlXzQyIjogWzIxNCwgLTc5XSwgImhhcGxv
dHlwZV80MSI6IFstMjM2LCAyOF0sICJoYXBsb3R5cGVfNDAiOiBbMTk2LCAzNV0sICJoYXBsb3R5
cGVfNiI6IFsxNzEsIDU4XSwgImhhcGxvdHlwZV83IjogWzIwLCAtOTJdLCAiaGFwbG90eXBlXzQi
OiBbMjI5LCAtNzRdLCAiaGFwbG90eXBlXzUiOiBbMjgxLCA5Nl0sICJoYXBsb3R5cGVfMiI6IFsy
MzUsIC0xMDhdLCAiaGFwbG90eXBlXzMiOiBbMjA5LCAxMDFdLCAiaGFwbG90eXBlXzAiOiBbLTE4
LCAxMTRdLCAiaGFwbG90eXBlXzEiOiBbMzksIC02NV0sICJoYXBsb3R5cGVfOCI6IFsxNTMsIDQ0
XSwgImhhcGxvdHlwZV85IjogWy03OCwgLTEzXSwgImhhcGxvdHlwZV8xOCI6IFs5NCwgNDRdLCAi
aGFwbG90eXBlXzE5IjogWzU2LCAtMTM4LjBdLCAiaGFwbG90eXBlXzM0IjogWzEyMywgMTA3XSwg
ImhhcGxvdHlwZV8zNSI6IFs0OCwgNTZdLCAiaGFwbG90eXBlXzMyIjogWy0xODksIDNdLCAiaGFw
bG90eXBlXzMzIjogWzE1MywgLTQzXSwgImhhcGxvdHlwZV8zMCI6IFs5NywgLTI3XSwgImhhcGxv
dHlwZV8zMSI6IFsyODguMCwgLTU4XSwgImhhcGxvdHlwZV8xMCI6IFstMjE5LCAtMTM4LjBdLCAi
aGFwbG90eXBlXzExIjogWy0yMjksIDI3XSwgImhhcGxvdHlwZV8xMiI6IFstMjg5LjAsIDI1XSwg
ImhhcGxvdHlwZV8xMyI6IFsxMTksIC0yMl0sICJoYXBsb3R5cGVfMTQiOiBbMjg4LjAsIDExN10s
ICJoYXBsb3R5cGVfMTUiOiBbNSwgLTExNV0sICJoYXBsb3R5cGVfMTYiOiBbMTk3LCAtNTJdLCAi
aGFwbG90eXBlXzE3IjogWzU3LCAtNzRdfX0=
','eeee');
INSERT INTO _yatel_versions VALUES(5,'2012-10-23 00:37:39.863715','ddddsdsdsd','eyJoYXBfc3FsIjogIlNFTEVDVCAqIEZST00gYGhhcGxvdHlwZXNgIiwgIndlaWdodF9yYW5nZSI6
IFtudWxsLCBudWxsXSwgImVudmlyb21lbnRzIjogW10sICJ0b3BvbG9neSI6IHsiaGFwbG90eXBl
XzM4IjogWzIzMSwgLTY2XSwgImhhcGxvdHlwZV8zOSI6IFszOSwgLTM0XSwgImhhcGxvdHlwZV8z
NiI6IFstMjY5LCA2OV0sICJoYXBsb3R5cGVfMzciOiBbLTI2MSwgMTM5LjBdLCAiaGFwbG90eXBl
XzIxIjogWzUzLCAtODFdLCAiaGFwbG90eXBlXzIwIjogWy0yLCAxMzNdLCAiaGFwbG90eXBlXzIz
IjogWy0yNSwgLTk4XSwgImhhcGxvdHlwZV8yMiI6IFstMTI4LjE0NzA1ODgyMzUyOTQsIDIzLjI3
OTQxMTc2NDcwNTg4NF0sICJoYXBsb3R5cGVfMjUiOiBbMTg2LCAyNV0sICJoYXBsb3R5cGVfMjQi
OiBbLTYxLCA5NV0sICJoYXBsb3R5cGVfMjciOiBbMTQxLCA1XSwgImhhcGxvdHlwZV8yNiI6IFsx
OTIsIDEzMV0sICJoYXBsb3R5cGVfMjkiOiBbNTQsIC0zMl0sICJoYXBsb3R5cGVfMjgiOiBbMjIw
LCAtMjBdLCAiaGFwbG90eXBlXzQ3IjogWzExNiwgLTQyXSwgImhhcGxvdHlwZV80NiI6IFstMjcy
LCA1MV0sICJoYXBsb3R5cGVfNDUiOiBbOTUsIDYyXSwgImhhcGxvdHlwZV80NCI6IFs4OCwgNzJd
LCAiaGFwbG90eXBlXzQzIjogWzc0LCA2OV0sICJoYXBsb3R5cGVfNDIiOiBbMjE0LCAtNzldLCAi
aGFwbG90eXBlXzQxIjogWy0yNzAuMTkxMTc2NDcwNTg4MjMsIC00NC43OTQxMTc2NDcwNTg4MjZd
LCAiaGFwbG90eXBlXzQwIjogWzE5NiwgMzVdLCAiaGFwbG90eXBlXzYiOiBbMTcxLCA1OF0sICJo
YXBsb3R5cGVfNyI6IFsyMCwgLTkyXSwgImhhcGxvdHlwZV80IjogWzIyOSwgLTc0XSwgImhhcGxv
dHlwZV81IjogWzI4MSwgOTZdLCAiaGFwbG90eXBlXzIiOiBbMjM1LCAtMTA4XSwgImhhcGxvdHlw
ZV8zIjogWzIwOSwgMTAxXSwgImhhcGxvdHlwZV8wIjogWy0xOCwgMTE0XSwgImhhcGxvdHlwZV8x
IjogWzM5LCAtNjVdLCAiaGFwbG90eXBlXzgiOiBbMTUzLCA0NF0sICJoYXBsb3R5cGVfOSI6IFst
NzgsIC0xM10sICJoYXBsb3R5cGVfMTgiOiBbOTQsIDQ0XSwgImhhcGxvdHlwZV8xOSI6IFs1Niwg
LTEzOC4wXSwgImhhcGxvdHlwZV8zNCI6IFsxMjMsIDEwN10sICJoYXBsb3R5cGVfMzUiOiBbNDgs
IDU2XSwgImhhcGxvdHlwZV8zMiI6IFstMTg5LCAzXSwgImhhcGxvdHlwZV8zMyI6IFsxNTMsIC00
M10sICJoYXBsb3R5cGVfMzAiOiBbOTcsIC0yN10sICJoYXBsb3R5cGVfMzEiOiBbMjg4LjAsIC01
OF0sICJoYXBsb3R5cGVfMTAiOiBbLTIxOSwgLTEzOC4wXSwgImhhcGxvdHlwZV8xMSI6IFstMjgx
Ljk0MTE3NjQ3MDU4ODIzLCAtMTQuOTExNzY0NzA1ODgyMzYyXSwgImhhcGxvdHlwZV8xMiI6IFst
Mjg5LjAsIDI1XSwgImhhcGxvdHlwZV8xMyI6IFsxMTksIC0yMl0sICJoYXBsb3R5cGVfMTQiOiBb
Mjg4LjAsIDExN10sICJoYXBsb3R5cGVfMTUiOiBbNSwgLTExNV0sICJoYXBsb3R5cGVfMTYiOiBb
MTk3LCAtNTJdLCAiaGFwbG90eXBlXzE3IjogWzU3LCAtNzRdfX0=
','sdsdd');
INSERT INTO _yatel_versions VALUES(6,'2012-10-23 00:44:16.620278','ieiieieie','eyJoYXBfc3FsIjogIlNFTEVDVCAqIEZST00gYGhhcGxvdHlwZXNgIHdoZXJlIGF0dHJfMSA8IDUw
IiwgIndlaWdodF9yYW5nZSI6IFs3LCAzNl0sICJlbnZpcm9tZW50cyI6IFtbdHJ1ZSwgeyJjIjog
Mn1dXSwgInRvcG9sb2d5IjogeyJoYXBsb3R5cGVfMzgiOiBbMjMxLCAtNjZdLCAiaGFwbG90eXBl
XzM5IjogWzM5LCAtMzRdLCAiaGFwbG90eXBlXzM2IjogWy0yNjksIDY5XSwgImhhcGxvdHlwZV8z
NyI6IFstMjYxLCAxMzkuMF0sICJoYXBsb3R5cGVfMjEiOiBbNTMsIC04MV0sICJoYXBsb3R5cGVf
MjAiOiBbLTIsIDEzM10sICJoYXBsb3R5cGVfMjMiOiBbLTI1LCAtOThdLCAiaGFwbG90eXBlXzIy
IjogWy0xMjguMTQ3MDU4ODIzNTI5NCwgMjMuMjc5NDExNzY0NzA1ODg0XSwgImhhcGxvdHlwZV8y
NSI6IFsxODYsIDI1XSwgImhhcGxvdHlwZV8yNCI6IFstNjEsIDk1XSwgImhhcGxvdHlwZV8yNyI6
IFsxNDEsIDVdLCAiaGFwbG90eXBlXzI2IjogWzE5MiwgMTMxXSwgImhhcGxvdHlwZV8yOSI6IFs1
NCwgLTMyXSwgImhhcGxvdHlwZV8yOCI6IFsyMjAsIC0yMF0sICJoYXBsb3R5cGVfNDciOiBbMTE2
LCAtNDJdLCAiaGFwbG90eXBlXzQ2IjogWy0yNzIsIDUxXSwgImhhcGxvdHlwZV80NSI6IFs5NSwg
NjJdLCAiaGFwbG90eXBlXzQ0IjogWzg4LCA3Ml0sICJoYXBsb3R5cGVfNDMiOiBbNzQsIDY5XSwg
ImhhcGxvdHlwZV80MiI6IFsyMTQsIC03OV0sICJoYXBsb3R5cGVfNDEiOiBbLTI3MC4xOTExNzY0
NzA1ODgyMywgLTQ0Ljc5NDExNzY0NzA1ODgyNl0sICJoYXBsb3R5cGVfNDAiOiBbMTk2LCAzNV0s
ICJoYXBsb3R5cGVfNiI6IFsxNzEsIDU4XSwgImhhcGxvdHlwZV83IjogWzIwLCAtOTJdLCAiaGFw
bG90eXBlXzQiOiBbMjI5LCAtNzRdLCAiaGFwbG90eXBlXzUiOiBbMjgxLCA5Nl0sICJoYXBsb3R5
cGVfMiI6IFsyMzUsIC0xMDhdLCAiaGFwbG90eXBlXzMiOiBbMjA5LCAxMDFdLCAiaGFwbG90eXBl
XzAiOiBbLTE4LCAxMTRdLCAiaGFwbG90eXBlXzEiOiBbMzksIC02NV0sICJoYXBsb3R5cGVfOCI6
IFsxNTMsIDQ0XSwgImhhcGxvdHlwZV85IjogWy03OCwgLTEzXSwgImhhcGxvdHlwZV8xOCI6IFs5
NCwgNDRdLCAiaGFwbG90eXBlXzE5IjogWzU2LCAtMTM4LjBdLCAiaGFwbG90eXBlXzM0IjogWzEy
MywgMTA3XSwgImhhcGxvdHlwZV8zNSI6IFs0OCwgNTZdLCAiaGFwbG90eXBlXzMyIjogWy0xODks
IDNdLCAiaGFwbG90eXBlXzMzIjogWzE1MywgLTQzXSwgImhhcGxvdHlwZV8zMCI6IFs5NywgLTI3
XSwgImhhcGxvdHlwZV8zMSI6IFsyODguMCwgLTU4XSwgImhhcGxvdHlwZV8xMCI6IFstMjE5LCAt
MTM4LjBdLCAiaGFwbG90eXBlXzExIjogWy0yODEuOTQxMTc2NDcwNTg4MjMsIC0xNC45MTE3NjQ3
MDU4ODIzNjJdLCAiaGFwbG90eXBlXzEyIjogWy0yODkuMCwgMjVdLCAiaGFwbG90eXBlXzEzIjog
WzExOSwgLTIyXSwgImhhcGxvdHlwZV8xNCI6IFsyODguMCwgMTE3XSwgImhhcGxvdHlwZV8xNSI6
IFs1LCAtMTE1XSwgImhhcGxvdHlwZV8xNiI6IFsxOTcsIC01Ml0sICJoYXBsb3R5cGVfMTciOiBb
NTcsIC03NF19fQ==
','ikdkjñikdñ');
CREATE TABLE "edges" ("id" INTEGER NOT NULL PRIMARY KEY, "weight" REAL NOT NULL, "haplotype_0_id" VARCHAR REFERENCES "haplotypes" ("hap_id") , "haplotype_1_id" VARCHAR REFERENCES "haplotypes" ("hap_id") );
INSERT INTO edges VALUES(1,20.0360800513441,'haplotype_18','haplotype_0');
INSERT INTO edges VALUES(2,54.2802328027871,'haplotype_15','haplotype_41');
INSERT INTO edges VALUES(3,21.9864319739818,'haplotype_22','haplotype_8');
INSERT INTO edges VALUES(4,8.17244803754718,'haplotype_32','haplotype_11');
INSERT INTO edges VALUES(5,85.9032621554584,'haplotype_23','haplotype_33');
INSERT INTO edges VALUES(6,100.733141981151,'haplotype_21','haplotype_12');
INSERT INTO edges VALUES(7,77.0258915820389,'haplotype_29','haplotype_24');
INSERT INTO edges VALUES(8,81.006869591731,'haplotype_23','haplotype_40');
INSERT INTO edges VALUES(9,54.1105501449481,'haplotype_26','haplotype_46');
INSERT INTO edges VALUES(10,69.7803783068988,'haplotype_13','haplotype_33');
CREATE TABLE "facts" ("id" INTEGER NOT NULL PRIMARY KEY, "haplotype_id" VARCHAR NOT NULL REFERENCES "haplotypes" ("hap_id") , "k" INTEGER, "b" INTEGER, "c" INTEGER);
INSERT INTO facts VALUES(1,'haplotype_18',2,1,2);
INSERT INTO facts VALUES(2,'haplotype_4',2,1,2);
INSERT INTO facts VALUES(3,'haplotype_7',2,1,2);
INSERT INTO facts VALUES(4,'haplotype_14',2,1,2);
INSERT INTO facts VALUES(5,'haplotype_14',2,1,2);
INSERT INTO facts VALUES(6,'haplotype_2',2,1,2);
INSERT INTO facts VALUES(7,'haplotype_25',2,1,2);
INSERT INTO facts VALUES(8,'haplotype_1',2,1,2);
INSERT INTO facts VALUES(9,'haplotype_42',2,1,2);
INSERT INTO facts VALUES(10,'haplotype_19',2,1,2);
INSERT INTO facts VALUES(11,'haplotype_13',2,1,2);
INSERT INTO facts VALUES(12,'haplotype_16',2,1,2);
INSERT INTO facts VALUES(13,'haplotype_15',2,1,2);
INSERT INTO facts VALUES(14,'haplotype_10',2,1,2);
INSERT INTO facts VALUES(15,'haplotype_27',2,1,2);
INSERT INTO facts VALUES(16,'haplotype_32',2,1,2);
INSERT INTO facts VALUES(17,'haplotype_29',2,1,2);
INSERT INTO facts VALUES(18,'haplotype_4',2,1,2);
INSERT INTO facts VALUES(19,'haplotype_6',2,1,2);
INSERT INTO facts VALUES(20,'haplotype_27',2,1,2);
INSERT INTO facts VALUES(21,'haplotype_33',2,1,2);
INSERT INTO facts VALUES(22,'haplotype_31',2,1,2);
INSERT INTO facts VALUES(23,'haplotype_0',2,1,2);
INSERT INTO facts VALUES(24,'haplotype_15',2,1,2);
INSERT INTO facts VALUES(25,'haplotype_22',2,1,2);
INSERT INTO facts VALUES(26,'haplotype_23',2,1,2);
INSERT INTO facts VALUES(27,'haplotype_15',2,1,2);
INSERT INTO facts VALUES(28,'haplotype_15',2,1,2);
INSERT INTO facts VALUES(29,'haplotype_9',2,1,2);
INSERT INTO facts VALUES(30,'haplotype_6',2,1,2);
INSERT INTO facts VALUES(31,'haplotype_10',2,1,2);
INSERT INTO facts VALUES(32,'haplotype_29',2,1,2);
INSERT INTO facts VALUES(33,'haplotype_42',2,1,2);
INSERT INTO facts VALUES(34,'haplotype_43',2,1,2);
INSERT INTO facts VALUES(35,'haplotype_25',2,1,2);
INSERT INTO facts VALUES(36,'haplotype_12',2,1,2);
INSERT INTO facts VALUES(37,'haplotype_19',2,1,2);
INSERT INTO facts VALUES(38,'haplotype_18',2,1,2);
CREATE TABLE "haplotypes" ("hap_id" VARCHAR(255) NOT NULL PRIMARY KEY, "attr_2" VARCHAR(255), "attr_3" SMALLINT, "attr_0" INTEGER, "attr_1" REAL);
INSERT INTO haplotypes VALUES('haplotype_0','6e273da938fe5873382f6f6785d7ef6a7995551b',1,65,70.8616281995646);
INSERT INTO haplotypes VALUES('haplotype_1','6e273da938fe5873382f6f6785d7ef6a7995551b',0,62,17.1227493823232);
INSERT INTO haplotypes VALUES('haplotype_2','6e273da938fe5873382f6f6785d7ef6a7995551b',1,48,7.66616334134639);
INSERT INTO haplotypes VALUES('haplotype_3','6e273da938fe5873382f6f6785d7ef6a7995551b',0,59,97.7857459585967);
INSERT INTO haplotypes VALUES('haplotype_4','6e273da938fe5873382f6f6785d7ef6a7995551b',1,100,40.7385104544155);
INSERT INTO haplotypes VALUES('haplotype_5','6e273da938fe5873382f6f6785d7ef6a7995551b',0,41,42.9219843746116);
INSERT INTO haplotypes VALUES('haplotype_6','6e273da938fe5873382f6f6785d7ef6a7995551b',1,60,5.66657908280903);
INSERT INTO haplotypes VALUES('haplotype_7','6e273da938fe5873382f6f6785d7ef6a7995551b',0,68,39.1749704421725);
INSERT INTO haplotypes VALUES('haplotype_8','6e273da938fe5873382f6f6785d7ef6a7995551b',0,33,55.1984502519091);
INSERT INTO haplotypes VALUES('haplotype_9','6e273da938fe5873382f6f6785d7ef6a7995551b',1,42,3.35800916112266);
INSERT INTO haplotypes VALUES('haplotype_10','6e273da938fe5873382f6f6785d7ef6a7995551b',1,76,91.9517633922141);
INSERT INTO haplotypes VALUES('haplotype_11','6e273da938fe5873382f6f6785d7ef6a7995551b',0,46,71.8955951811948);
INSERT INTO haplotypes VALUES('haplotype_12','6e273da938fe5873382f6f6785d7ef6a7995551b',0,86,72.8120530086646);
INSERT INTO haplotypes VALUES('haplotype_13','6e273da938fe5873382f6f6785d7ef6a7995551b',0,99,69.8873024069114);
INSERT INTO haplotypes VALUES('haplotype_14','6e273da938fe5873382f6f6785d7ef6a7995551b',1,37,48.7231345240843);
INSERT INTO haplotypes VALUES('haplotype_15','6e273da938fe5873382f6f6785d7ef6a7995551b',0,43,12.519914750765);
INSERT INTO haplotypes VALUES('haplotype_16','6e273da938fe5873382f6f6785d7ef6a7995551b',1,11,66.0752860192414);
INSERT INTO haplotypes VALUES('haplotype_17','6e273da938fe5873382f6f6785d7ef6a7995551b',0,48,70.5702895764998);
INSERT INTO haplotypes VALUES('haplotype_18','6e273da938fe5873382f6f6785d7ef6a7995551b',1,55,99.0362790227169);
INSERT INTO haplotypes VALUES('haplotype_19','6e273da938fe5873382f6f6785d7ef6a7995551b',1,96,40.6331564730325);
INSERT INTO haplotypes VALUES('haplotype_20','6e273da938fe5873382f6f6785d7ef6a7995551b',1,100,20.1008424915849);
INSERT INTO haplotypes VALUES('haplotype_21','6e273da938fe5873382f6f6785d7ef6a7995551b',1,69,73.2033127783289);
INSERT INTO haplotypes VALUES('haplotype_22','6e273da938fe5873382f6f6785d7ef6a7995551b',1,42,67.6759950237599);
INSERT INTO haplotypes VALUES('haplotype_23','6e273da938fe5873382f6f6785d7ef6a7995551b',1,94,90.1594478162164);
INSERT INTO haplotypes VALUES('haplotype_24','6e273da938fe5873382f6f6785d7ef6a7995551b',1,44,17.2572041994429);
INSERT INTO haplotypes VALUES('haplotype_25','6e273da938fe5873382f6f6785d7ef6a7995551b',1,10,16.2175889318844);
INSERT INTO haplotypes VALUES('haplotype_26','6e273da938fe5873382f6f6785d7ef6a7995551b',1,31,68.4774595286894);
INSERT INTO haplotypes VALUES('haplotype_27','6e273da938fe5873382f6f6785d7ef6a7995551b',0,69,4.38025254364801);
INSERT INTO haplotypes VALUES('haplotype_28','6e273da938fe5873382f6f6785d7ef6a7995551b',0,49,40.3558996621052);
INSERT INTO haplotypes VALUES('haplotype_29','6e273da938fe5873382f6f6785d7ef6a7995551b',1,60,89.9031674429574);
INSERT INTO haplotypes VALUES('haplotype_30','6e273da938fe5873382f6f6785d7ef6a7995551b',0,85,20.3285930396674);
INSERT INTO haplotypes VALUES('haplotype_31','6e273da938fe5873382f6f6785d7ef6a7995551b',1,21,34.4190179418744);
INSERT INTO haplotypes VALUES('haplotype_32','6e273da938fe5873382f6f6785d7ef6a7995551b',1,80,98.9477954782409);
INSERT INTO haplotypes VALUES('haplotype_33','6e273da938fe5873382f6f6785d7ef6a7995551b',1,26,3.22109627157223);
INSERT INTO haplotypes VALUES('haplotype_34','6e273da938fe5873382f6f6785d7ef6a7995551b',0,31,89.0752915378719);
INSERT INTO haplotypes VALUES('haplotype_35','6e273da938fe5873382f6f6785d7ef6a7995551b',1,97,12.0835709138561);
INSERT INTO haplotypes VALUES('haplotype_36','6e273da938fe5873382f6f6785d7ef6a7995551b',0,93,30.4382630643193);
INSERT INTO haplotypes VALUES('haplotype_37','6e273da938fe5873382f6f6785d7ef6a7995551b',0,1,38.9492011282206);
INSERT INTO haplotypes VALUES('haplotype_38','6e273da938fe5873382f6f6785d7ef6a7995551b',1,59,38.4730759541834);
INSERT INTO haplotypes VALUES('haplotype_39','6e273da938fe5873382f6f6785d7ef6a7995551b',1,67,86.9897809779022);
INSERT INTO haplotypes VALUES('haplotype_40','6e273da938fe5873382f6f6785d7ef6a7995551b',1,5,5.318398051649);
INSERT INTO haplotypes VALUES('haplotype_41','6e273da938fe5873382f6f6785d7ef6a7995551b',1,9,94.7811501943213);
INSERT INTO haplotypes VALUES('haplotype_42','6e273da938fe5873382f6f6785d7ef6a7995551b',1,1,80.7493347787912);
INSERT INTO haplotypes VALUES('haplotype_43','6e273da938fe5873382f6f6785d7ef6a7995551b',0,88,98.8606192668762);
INSERT INTO haplotypes VALUES('haplotype_44','6e273da938fe5873382f6f6785d7ef6a7995551b',0,52,4.56567429982995);
INSERT INTO haplotypes VALUES('haplotype_45','6e273da938fe5873382f6f6785d7ef6a7995551b',0,5,93.1490829842749);
INSERT INTO haplotypes VALUES('haplotype_46','6e273da938fe5873382f6f6785d7ef6a7995551b',0,64,42.9434845753427);
INSERT INTO haplotypes VALUES('haplotype_47','6e273da938fe5873382f6f6785d7ef6a7995551b',1,8,23.6894385810923);
CREATE INDEX "_yatel_fields_reference_to_id" ON "_yatel_fields" ("reference_to_id");
CREATE INDEX "_yatel_fields_table_id" ON "_yatel_fields" ("table_id");
CREATE UNIQUE INDEX "_yatel_tables_name" ON "_yatel_tables" ("name");
CREATE UNIQUE INDEX "_yatel_tables_type" ON "_yatel_tables" ("type");
CREATE UNIQUE INDEX "_yatel_versions_tag" ON "_yatel_versions" ("tag");
CREATE INDEX "edges_haplotype_0_id" ON "edges" ("haplotype_0_id");
CREATE INDEX "edges_haplotype_1_id" ON "edges" ("haplotype_1_id");
CREATE INDEX "facts_haplotype_id" ON "facts" ("haplotype_id");
COMMIT;
