general2.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
DROP TABLE "general_space_type";
CREATE TABLE "general_space_type" ("typ_id" integer NOT NULL PRIMARY KEY REFERENCES "general_type" ("id"));
INSERT INTO "general_space_type" VALUES(7);
INSERT INTO "general_space_type" VALUES(8);
INSERT INTO "general_space_type" VALUES(39);
INSERT INTO "general_space_type" VALUES(40);
INSERT INTO "general_space_type" VALUES(41);
INSERT INTO "general_space_type" VALUES(42);
INSERT INTO "general_space_type" VALUES(43);
INSERT INTO "general_space_type" VALUES(44);
INSERT INTO "general_space_type" VALUES(45);
INSERT INTO "general_space_type" VALUES(46);
INSERT INTO "general_space_type" VALUES(62);
DROP TABLE "general_address_type";
CREATE TABLE "general_address_type" ("space_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_space_type" ("typ_id"));
INSERT INTO "general_address_type" VALUES(44);
INSERT INTO "general_address_type" VALUES(45);
INSERT INTO "general_address_type" VALUES(46);
DROP TABLE "general_region_type";
CREATE TABLE "general_region_type" ("space_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_space_type" ("typ_id"));
INSERT INTO "general_region_type" VALUES(39);
INSERT INTO "general_region_type" VALUES(40);
INSERT INTO "general_region_type" VALUES(41);
INSERT INTO "general_region_type" VALUES(42);
INSERT INTO "general_region_type" VALUES(43);
INSERT INTO "general_region_type" VALUES(62);
DROP TABLE "general_being_type";
CREATE TABLE "general_being_type" ("typ_id" integer NOT NULL PRIMARY KEY REFERENCES "general_type" ("id"));
INSERT INTO "general_being_type" VALUES(4);
INSERT INTO "general_being_type" VALUES(5);
INSERT INTO "general_being_type" VALUES(6);
INSERT INTO "general_being_type" VALUES(13);
INSERT INTO "general_being_type" VALUES(19);
INSERT INTO "general_being_type" VALUES(20);
INSERT INTO "general_being_type" VALUES(21);
INSERT INTO "general_being_type" VALUES(22);
INSERT INTO "general_being_type" VALUES(23);
INSERT INTO "general_being_type" VALUES(24);
INSERT INTO "general_being_type" VALUES(25);
INSERT INTO "general_being_type" VALUES(26);
INSERT INTO "general_being_type" VALUES(27);
INSERT INTO "general_being_type" VALUES(28);
INSERT INTO "general_being_type" VALUES(29);
INSERT INTO "general_being_type" VALUES(31);
INSERT INTO "general_being_type" VALUES(32);
INSERT INTO "general_being_type" VALUES(47);
INSERT INTO "general_being_type" VALUES(63);
INSERT INTO "general_being_type" VALUES(64);
INSERT INTO "general_being_type" VALUES(66);
DROP TABLE "general_project_type";
CREATE TABLE "general_project_type" ("being_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_being_type" ("typ_id"));
INSERT INTO "general_project_type" VALUES(13);
INSERT INTO "general_project_type" VALUES(21);
INSERT INTO "general_project_type" VALUES(22);
INSERT INTO "general_project_type" VALUES(23);
INSERT INTO "general_project_type" VALUES(24);
INSERT INTO "general_project_type" VALUES(25);
INSERT INTO "general_project_type" VALUES(26);
INSERT INTO "general_project_type" VALUES(27);
INSERT INTO "general_project_type" VALUES(28);
INSERT INTO "general_project_type" VALUES(29);
INSERT INTO "general_project_type" VALUES(31);
INSERT INTO "general_project_type" VALUES(32);
INSERT INTO "general_project_type" VALUES(47);
INSERT INTO "general_project_type" VALUES(63);
INSERT INTO "general_project_type" VALUES(66);
DROP TABLE "general_company_type";
CREATE TABLE "general_company_type" ("being_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_being_type" ("typ_id"));
INSERT INTO "general_company_type" VALUES(19);
INSERT INTO "general_company_type" VALUES(20);
INSERT INTO "general_company_type" VALUES(64);
DROP TABLE "general_nonmaterial_type";
CREATE TABLE "general_nonmaterial_type" ("artwork_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_artwork_type" ("typ_id"));
INSERT INTO "general_nonmaterial_type" VALUES(49);
INSERT INTO "general_nonmaterial_type" VALUES(50);
INSERT INTO "general_nonmaterial_type" VALUES(51);
INSERT INTO "general_nonmaterial_type" VALUES(52);
INSERT INTO "general_nonmaterial_type" VALUES(53);
INSERT INTO "general_nonmaterial_type" VALUES(54);
INSERT INTO "general_nonmaterial_type" VALUES(65);
INSERT INTO "general_nonmaterial_type" VALUES(71);
INSERT INTO "general_nonmaterial_type" VALUES(73);
INSERT INTO "general_nonmaterial_type" VALUES(74);
INSERT INTO "general_nonmaterial_type" VALUES(75);
INSERT INTO "general_nonmaterial_type" VALUES(76);
INSERT INTO "general_nonmaterial_type" VALUES(77);
INSERT INTO "general_nonmaterial_type" VALUES(78);
INSERT INTO "general_nonmaterial_type" VALUES(79);
INSERT INTO "general_nonmaterial_type" VALUES(80);
INSERT INTO "general_nonmaterial_type" VALUES(81);
INSERT INTO "general_nonmaterial_type" VALUES(82);
INSERT INTO "general_nonmaterial_type" VALUES(83);
INSERT INTO "general_nonmaterial_type" VALUES(84);
INSERT INTO "general_nonmaterial_type" VALUES(85);
INSERT INTO "general_nonmaterial_type" VALUES(86);
INSERT INTO "general_nonmaterial_type" VALUES(87);
INSERT INTO "general_nonmaterial_type" VALUES(149);
INSERT INTO "general_nonmaterial_type" VALUES(150);
INSERT INTO "general_nonmaterial_type" VALUES(151);
INSERT INTO "general_nonmaterial_type" VALUES(154);
INSERT INTO "general_nonmaterial_type" VALUES(155);
INSERT INTO "general_nonmaterial_type" VALUES(156);
INSERT INTO "general_nonmaterial_type" VALUES(157);
INSERT INTO "general_nonmaterial_type" VALUES(173);
INSERT INTO "general_nonmaterial_type" VALUES(174);
INSERT INTO "general_nonmaterial_type" VALUES(175);
INSERT INTO "general_nonmaterial_type" VALUES(176);
INSERT INTO "general_nonmaterial_type" VALUES(177);
INSERT INTO "general_nonmaterial_type" VALUES(180);
DROP TABLE "general_material_type";
CREATE TABLE "general_material_type" ("artwork_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_artwork_type" ("typ_id"));
INSERT INTO "general_material_type" VALUES(55);
INSERT INTO "general_material_type" VALUES(56);
INSERT INTO "general_material_type" VALUES(57);
INSERT INTO "general_material_type" VALUES(88);
INSERT INTO "general_material_type" VALUES(89);
INSERT INTO "general_material_type" VALUES(90);
INSERT INTO "general_material_type" VALUES(91);
INSERT INTO "general_material_type" VALUES(92);
INSERT INTO "general_material_type" VALUES(93);
INSERT INTO "general_material_type" VALUES(94);
INSERT INTO "general_material_type" VALUES(95);
INSERT INTO "general_material_type" VALUES(96);
INSERT INTO "general_material_type" VALUES(97);
INSERT INTO "general_material_type" VALUES(98);
INSERT INTO "general_material_type" VALUES(152);
INSERT INTO "general_material_type" VALUES(153);
INSERT INTO "general_material_type" VALUES(158);
INSERT INTO "general_material_type" VALUES(159);
INSERT INTO "general_material_type" VALUES(160);
INSERT INTO "general_material_type" VALUES(161);
INSERT INTO "general_material_type" VALUES(162);
INSERT INTO "general_material_type" VALUES(163);
INSERT INTO "general_material_type" VALUES(164);
INSERT INTO "general_material_type" VALUES(165);
INSERT INTO "general_material_type" VALUES(166);
INSERT INTO "general_material_type" VALUES(167);
INSERT INTO "general_material_type" VALUES(168);
INSERT INTO "general_material_type" VALUES(169);
INSERT INTO "general_material_type" VALUES(170);
INSERT INTO "general_material_type" VALUES(179);
DROP TABLE "general_address";
CREATE TABLE "general_address" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL, "p_address" varchar(200) NOT NULL, "postalcode" varchar(5) NULL, "ic_larder" bool NOT NULL, "size" decimal NULL, "longitude" integer NULL, "latitude" integer NULL, "description" text NULL, "address_type_id" integer NULL REFERENCES "general_address_type" ("space_type_id"), "region_id" integer NULL REFERENCES "general_region" ("id"), "size_unit_id" integer NULL REFERENCES "general_unit" ("id"), "town" varchar(150) NOT NULL);
DROP TABLE "general_job";
CREATE TABLE "general_job" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(200) NOT NULL UNIQUE, "gerund" varchar(200) NOT NULL, "description" text NOT NULL, "lft" integer unsigned NOT NULL, "rght" integer unsigned NOT NULL, "tree_id" integer unsigned NOT NULL, "level" integer unsigned NOT NULL, "clas" varchar(50) NOT NULL, "parent_id" integer NULL REFERENCES "general_job" ("id"), "verb" varchar(200) NOT NULL);
INSERT INTO "general_job" VALUES(1,'Selfmanagement','selfmanaging','',9,14,7,2,'',27,'to selfmanage');
INSERT INTO "general_job" VALUES(2,'Coordination','coordinating','',10,11,7,3,'',1,'to coordinate');
INSERT INTO "general_job" VALUES(3,'Development','developing','',3,6,7,2,'',27,'to develop');
INSERT INTO "general_job" VALUES(4,'Transport','transporting','',46,49,7,1,'',25,'to transport');
INSERT INTO "general_job" VALUES(5,'IC Facilitation','facilitating IC','',12,13,7,3,'ic_facilitate',1,'to facilitate IC');
INSERT INTO "general_job" VALUES(6,'Restauration','restaurating','',18,21,7,3,'',8,'to restaurate');
INSERT INTO "general_job" VALUES(7,'Lifecare','lifecareing','',16,35,7,1,'',25,'to care life');
INSERT INTO "general_job" VALUES(8,'Alimentation','alimentating','',17,24,7,2,'',7,'to alimentate');
INSERT INTO "general_job" VALUES(9,'Clothing','making cloths','',25,26,7,2,'',7,'to make cloths');
INSERT INTO "general_job" VALUES(10,'Cleaning','cleaning','',30,31,7,3,'',12,'to clean');
INSERT INTO "general_job" VALUES(11,'Bodycare','bodycaring','',27,28,7,2,'',7,'to bodycare');
INSERT INTO "general_job" VALUES(12,'Shelter/Housing','sheltering/housing','',29,34,7,2,'',7,'to shelter/housing');
INSERT INTO "general_job" VALUES(13,'Building','building','',32,33,7,3,'',12,'to build');
INSERT INTO "general_job" VALUES(14,'Drive','driving','',47,48,7,2,'',4,'to drive');
INSERT INTO "general_job" VALUES(15,'Communication','communicating','',36,45,7,1,'',25,'to communicate');
INSERT INTO "general_job" VALUES(16,'Graphic Design','designing graphically','',37,38,7,2,'',15,'to design graphically');
INSERT INTO "general_job" VALUES(17,'Write','writing','',39,42,7,2,'',15,'to write');
INSERT INTO "general_job" VALUES(18,'Translate','translating','',40,41,7,3,'',17,'to translate');
INSERT INTO "general_job" VALUES(19,'Publish','publishing','',43,44,7,2,'',15,'to publish');
INSERT INTO "general_job" VALUES(20,'Grow Vegetables','growing vegetables','',22,23,7,3,'',8,'to grow vegetables');
INSERT INTO "general_job" VALUES(21,'Programming','programming','',4,5,7,3,'',3,'to program');
INSERT INTO "general_job" VALUES(22,'Cook','cooking','',19,20,7,4,'',6,'to cook');
INSERT INTO "general_job" VALUES(25,'Doing','doing','',1,50,7,0,'',NULL,'to do');
INSERT INTO "general_job" VALUES(26,'Not-doing','not doing','',1,4,8,0,'',NULL,'to not do');
INSERT INTO "general_job" VALUES(27,'Making','making','',2,15,7,1,'',25,'to make');
INSERT INTO "general_job" VALUES(28,'Listening','listening','',2,3,8,1,'',26,'to listen');
INSERT INTO "general_job" VALUES(29,'Transform','transforming','',7,8,7,2,'',27,'to transform');
DROP TABLE "general_record";
CREATE TABLE "general_record" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(200) NULL, "description" text NULL, "record_type_id" integer NULL REFERENCES "general_record_type" ("artwork_type_id"));
INSERT INTO "general_record" VALUES(3,'EcoCoop * 10 = Hour','',58);
INSERT INTO "general_record" VALUES(4,'EcoCoop * 1.000 = Euro','',59);
INSERT INTO "general_record" VALUES(5,'Riu * 1.000 = Euro','',59);
INSERT INTO "general_record" VALUES(6,'Hour * 24 = Day','',61);
INSERT INTO "general_record" VALUES(7,'Day * 28 = Moon cycle','',61);
INSERT INTO "general_record" VALUES(8,'Moon cycle * 13 = Year','',61);
INSERT INTO "general_record" VALUES(9,'FairCoin * 20 = SocialCurrency','',59);
INSERT INTO "general_record" VALUES(10,'Meter * 1000 = Kilometer','',69);
INSERT INTO "general_record" VALUES(11,'Gram * 1000 = Kilogram','',70);
DROP TABLE "general_region";
CREATE TABLE "general_region" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(100) NOT NULL, "description" text NULL, "lft" integer unsigned NOT NULL, "rght" integer unsigned NOT NULL, "tree_id" integer unsigned NOT NULL, "level" integer unsigned NOT NULL, "parent_id" integer NULL REFERENCES "general_region" ("id"), "region_type_id" integer NULL REFERENCES "general_region_type" ("space_type_id"));
INSERT INTO "general_region" VALUES(1,'Catalan Countries','',2,9,2,1,5,41);
INSERT INTO "general_region" VALUES(2,'Catalunya','',3,8,2,2,1,43);
INSERT INTO "general_region" VALUES(3,'Barcelonès','',4,5,2,3,2,43);
INSERT INTO "general_region" VALUES(4,'Anoia','',6,7,2,3,2,43);
INSERT INTO "general_region" VALUES(5,'european continent','',1,10,2,0,NULL,39);
INSERT INTO "general_region" VALUES(6,'planet Earth','',1,2,3,0,NULL,62);
DROP TABLE "general_relation";
CREATE TABLE "general_relation" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(200) NOT NULL UNIQUE, "gerund" varchar(200) NOT NULL, "description" text NOT NULL, "lft" integer unsigned NOT NULL, "rght" integer unsigned NOT NULL, "tree_id" integer unsigned NOT NULL, "level" integer unsigned NOT NULL, "clas" varchar(50) NOT NULL, "parent_id" integer NULL REFERENCES "general_relation" ("id"), "verb" varchar(200) NOT NULL);
INSERT INTO "general_relation" VALUES(1,':Relation Human - Human','','',1,38,1,0,'rel_hum_hum',NULL,'');
INSERT INTO "general_relation" VALUES(2,':Relation Human - Art','','',1,6,2,0,'rel_hum_art',NULL,'');
INSERT INTO "general_relation" VALUES(3,':Relation Human - Space','','',1,20,3,0,'rel_hum_spac',NULL,'');
INSERT INTO "general_relation" VALUES(4,':Relation Human - Artwork','','',1,16,4,0,'',NULL,'');
INSERT INTO "general_relation" VALUES(5,':relation Person - Project','','',18,29,1,1,'rel_pers_proj',1,'');
INSERT INTO "general_relation" VALUES(6,':relation Person - Person','','',36,37,1,1,'rel_pers_pers',1,'');
INSERT INTO "general_relation" VALUES(7,'participation','participating','',7,8,1,2,'',19,'to participate');
INSERT INTO "general_relation" VALUES(8,'help','helping','',5,6,1,2,'',19,'to help');
INSERT INTO "general_relation" VALUES(9,'collaboration','collaborating','',15,16,1,2,'',21,'to collaborate');
INSERT INTO "general_relation" VALUES(10,'contribution/collaboration','contributing/collaborating','',21,28,1,2,'contribute',5,'to contribute/collaborate');
INSERT INTO "general_relation" VALUES(11,'coordination','coordinating','',3,4,1,2,'reference',19,'to coordinate');
INSERT INTO "general_relation" VALUES(12,'contribution in a commission','contributing in a commission','',22,23,1,3,'',10,'to contribute in a commission');
INSERT INTO "general_relation" VALUES(13,'sporadic contribution in tasks','contributing occasionally','',24,25,1,3,'',10,'to contribute occasionally');
INSERT INTO "general_relation" VALUES(14,'economic contribution','contributing economically','',26,27,1,3,'',10,'to contribute economically');
INSERT INTO "general_relation" VALUES(15,':relation Project - Address','','',2,9,3,1,'rel_proj_addr',3,'');
INSERT INTO "general_relation" VALUES(16,'offer of space','offering the space','',4,5,3,3,'',17,'to offer the space');
INSERT INTO "general_relation" VALUES(17,'management of space','managing the space','',3,6,3,2,'',15,'to manage the space');
INSERT INTO "general_relation" VALUES(18,':relation Project - Company','','',10,13,1,1,'rel_proj_empr',1,'');
INSERT INTO "general_relation" VALUES(19,':relation Project - Person','','',2,9,1,1,'rel_proj_pers',1,'');
INSERT INTO "general_relation" VALUES(20,'usage','using','',11,12,1,2,'',18,'to use');
INSERT INTO "general_relation" VALUES(21,':relation Project - Project','','',14,17,1,1,'rel_proj_proj',1,'');
INSERT INTO "general_relation" VALUES(22,':relation Person - Company','','',30,35,1,1,'rel_pers_comp',1,'');
INSERT INTO "general_relation" VALUES(23,'use a space','using the space','',7,8,3,2,'',15,'to use the space');
INSERT INTO "general_relation" VALUES(24,':relation Person - Address','','',10,15,3,1,'rel_pers_addr',3,'');
INSERT INTO "general_relation" VALUES(25,'habitation','habitating in','',11,12,3,2,'',24,'to habitate in');
INSERT INTO "general_relation" VALUES(26,'work in','working in','',13,14,3,2,'',24,'to work in');
INSERT INTO "general_relation" VALUES(27,'follow','following','',19,20,1,2,'',5,'to follow');
INSERT INTO "general_relation" VALUES(28,'learning','learning','',2,3,2,1,'',2,'to learn');
INSERT INTO "general_relation" VALUES(29,'practication','practicating','',4,5,2,1,'',2,'to practicate');
INSERT INTO "general_relation" VALUES(30,':relation Human - Record','','',2,5,4,1,'rel_hum_reco',4,'');
INSERT INTO "general_relation" VALUES(31,'buy to a company','buying to a company','',31,32,1,2,'',22,'to buy to a company');
INSERT INTO "general_relation" VALUES(32,'work for a company','working for a company','',33,34,1,2,'',22,'to work for a company');
INSERT INTO "general_relation" VALUES(33,':relation Human - Region','','',16,19,3,1,'rel_hum_regi',3,'');
INSERT INTO "general_relation" VALUES(34,'living in','living in','',17,18,3,2,'',33,'to live in');
INSERT INTO "general_relation" VALUES(35,':relation Human - Material artwork','','',6,9,4,1,'rel_hum_mate',4,'');
INSERT INTO "general_relation" VALUES(36,'ownership of record','owning the record','',3,4,4,2,'holder',30,'to own the record');
INSERT INTO "general_relation" VALUES(37,'pertenence','pertaining','',7,8,4,2,'',35,'to pertain');
INSERT INTO "general_relation" VALUES(38,':relation Human - Nonmaterial artwork','','',10,15,4,1,'rel_hum_nonm',4,'');
INSERT INTO "general_relation" VALUES(39,'representation','representing','',11,12,4,2,'',38,'to represent');
INSERT INTO "general_relation" VALUES(40,'offer of non-material','offering a non-material','',13,14,4,2,'',38,'to offer a non-material');
INSERT INTO "general_relation" VALUES(41,':relation Material artwork - Address','','',2,5,9,1,'rel_mat_addr',46,'');
INSERT INTO "general_relation" VALUES(42,'parking in','parking in','',3,4,9,2,'',41,'to park in');
INSERT INTO "general_relation" VALUES(43,':relation Material artwork - Record','','',2,3,10,1,'rel_mat_reco',47,'');
INSERT INTO "general_relation" VALUES(44,':relation Material artwork - Non-material artwork','','',6,7,10,1,'rel_mat_nonm',47,'');
INSERT INTO "general_relation" VALUES(45,':relation Material artwork - Material artwork','','',4,5,10,1,'rel_mat_mate',47,'');
INSERT INTO "general_relation" VALUES(46,':Relation Artwork - Space','','',1,8,9,0,'',NULL,'');
INSERT INTO "general_relation" VALUES(47,':Relation Artwork - Artwork','','',1,12,10,0,'',NULL,'');
INSERT INTO "general_relation" VALUES(48,':Relation Artwork - Art','','',1,8,11,0,'',NULL,'');
INSERT INTO "general_relation" VALUES(49,':relation Material artwork - Job','','',2,5,11,1,'rel_mat_jobs',48,'');
INSERT INTO "general_relation" VALUES(50,':relation Non-material artwork - Address','','',6,7,9,1,'rel_non_addr',46,'');
INSERT INTO "general_relation" VALUES(51,':relation Non-material artwork - Record','','',8,9,10,1,'rel_non_reco',47,'');
INSERT INTO "general_relation" VALUES(52,':relation Non-material artwork - Job','','',6,7,11,1,'rel_non_jobs',48,'');
INSERT INTO "general_relation" VALUES(53,':relation Non-material artwork - Non-material artwork','','',10,11,10,1,'rel_non_nonm',47,'');
INSERT INTO "general_relation" VALUES(54,'service for','serving for','',3,4,11,2,'',49,'to service for');
DROP TABLE "general_unitratio";
CREATE TABLE "general_unitratio" ("record_id" integer NOT NULL PRIMARY KEY REFERENCES "general_record" ("id"), "in_unit_id" integer NOT NULL REFERENCES "general_unit" ("id"), "out_unit_id" integer NOT NULL REFERENCES "general_unit" ("id"), "rate" decimal NOT NULL);
INSERT INTO "general_unitratio" VALUES(3,1,5,10);
INSERT INTO "general_unitratio" VALUES(4,1,2,1);
INSERT INTO "general_unitratio" VALUES(5,6,2,1);
INSERT INTO "general_unitratio" VALUES(6,5,8,24);
INSERT INTO "general_unitratio" VALUES(7,8,9,28);
INSERT INTO "general_unitratio" VALUES(8,9,10,13);
INSERT INTO "general_unitratio" VALUES(9,7,11,20);
INSERT INTO "general_unitratio" VALUES(10,12,13,1000);
INSERT INTO "general_unitratio" VALUES(11,15,14,1000);
DROP TABLE "general_address_jobs";
CREATE TABLE "general_address_jobs" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "address_id" integer NOT NULL REFERENCES "general_address" ("id"), "job_id" integer NOT NULL REFERENCES "general_job" ("id"), UNIQUE ("address_id", "job_id"));
DROP TABLE "general_record_type";
CREATE TABLE "general_record_type" ("artwork_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_artwork_type" ("typ_id"));
INSERT INTO "general_record_type" VALUES(14);
INSERT INTO "general_record_type" VALUES(15);
INSERT INTO "general_record_type" VALUES(16);
INSERT INTO "general_record_type" VALUES(17);
INSERT INTO "general_record_type" VALUES(18);
INSERT INTO "general_record_type" VALUES(58);
INSERT INTO "general_record_type" VALUES(59);
INSERT INTO "general_record_type" VALUES(60);
INSERT INTO "general_record_type" VALUES(61);
INSERT INTO "general_record_type" VALUES(69);
INSERT INTO "general_record_type" VALUES(70);
INSERT INTO "general_record_type" VALUES(124);
INSERT INTO "general_record_type" VALUES(125);
INSERT INTO "general_record_type" VALUES(126);
INSERT INTO "general_record_type" VALUES(127);
INSERT INTO "general_record_type" VALUES(128);
INSERT INTO "general_record_type" VALUES(129);
INSERT INTO "general_record_type" VALUES(130);
INSERT INTO "general_record_type" VALUES(131);
INSERT INTO "general_record_type" VALUES(132);
INSERT INTO "general_record_type" VALUES(133);
INSERT INTO "general_record_type" VALUES(134);
INSERT INTO "general_record_type" VALUES(135);
INSERT INTO "general_record_type" VALUES(136);
INSERT INTO "general_record_type" VALUES(137);
INSERT INTO "general_record_type" VALUES(138);
INSERT INTO "general_record_type" VALUES(139);
INSERT INTO "general_record_type" VALUES(140);
INSERT INTO "general_record_type" VALUES(141);
INSERT INTO "general_record_type" VALUES(142);
INSERT INTO "general_record_type" VALUES(143);
INSERT INTO "general_record_type" VALUES(144);
INSERT INTO "general_record_type" VALUES(145);
INSERT INTO "general_record_type" VALUES(146);
INSERT INTO "general_record_type" VALUES(147);
INSERT INTO "general_record_type" VALUES(148);
INSERT INTO "general_record_type" VALUES(181);
INSERT INTO "general_record_type" VALUES(182);
INSERT INTO "general_record_type" VALUES(183);
INSERT INTO "general_record_type" VALUES(184);
INSERT INTO "general_record_type" VALUES(185);
INSERT INTO "general_record_type" VALUES(186);
INSERT INTO "general_record_type" VALUES(187);
INSERT INTO "general_record_type" VALUES(214);
INSERT INTO "general_record_type" VALUES(215);
INSERT INTO "general_record_type" VALUES(217);
INSERT INTO "general_record_type" VALUES(218);
INSERT INTO "general_record_type" VALUES(219);
INSERT INTO "general_record_type" VALUES(220);
INSERT INTO "general_record_type" VALUES(221);
INSERT INTO "general_record_type" VALUES(222);
INSERT INTO "general_record_type" VALUES(223);
INSERT INTO "general_record_type" VALUES(224);
INSERT INTO "general_record_type" VALUES(225);
INSERT INTO "general_record_type" VALUES(226);
INSERT INTO "general_record_type" VALUES(227);
INSERT INTO "general_record_type" VALUES(228);
INSERT INTO "general_record_type" VALUES(229);
INSERT INTO "general_record_type" VALUES(230);
INSERT INTO "general_record_type" VALUES(231);
INSERT INTO "general_record_type" VALUES(251);
INSERT INTO "general_record_type" VALUES(252);
INSERT INTO "general_record_type" VALUES(253);
INSERT INTO "general_record_type" VALUES(254);
INSERT INTO "general_record_type" VALUES(256);
INSERT INTO "general_record_type" VALUES(257);
INSERT INTO "general_record_type" VALUES(258);
INSERT INTO "general_record_type" VALUES(259);
INSERT INTO "general_record_type" VALUES(260);
INSERT INTO "general_record_type" VALUES(263);
INSERT INTO "general_record_type" VALUES(266);
INSERT INTO "general_record_type" VALUES(267);
INSERT INTO "general_record_type" VALUES(269);
INSERT INTO "general_record_type" VALUES(270);
INSERT INTO "general_record_type" VALUES(274);
INSERT INTO "general_record_type" VALUES(275);
INSERT INTO "general_record_type" VALUES(276);
INSERT INTO "general_record_type" VALUES(277);
DROP TABLE "general_type";
CREATE TABLE "general_type" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "description" text NOT NULL, "lft" integer unsigned NOT NULL, "rght" integer unsigned NOT NULL, "tree_id" integer unsigned NOT NULL, "level" integer unsigned NOT NULL, "clas" varchar(200) NOT NULL, "parent_id" integer NULL REFERENCES "general_type" ("id"), "name" varchar(200) NOT NULL UNIQUE);
INSERT INTO "general_type" VALUES(1,'',1,44,1,0,'Being',NULL,'Being');
INSERT INTO "general_type" VALUES(2,'',1,24,2,0,'Space',NULL,'Space');
INSERT INTO "general_type" VALUES(3,'',1,368,3,0,'Artwork',NULL,'Artwork');
INSERT INTO "general_type" VALUES(4,'',2,3,1,1,'Person',1,'Person');
INSERT INTO "general_type" VALUES(5,'',4,35,1,1,'Project',1,'Project');
INSERT INTO "general_type" VALUES(6,'',36,43,1,1,'Company',1,'Company');
INSERT INTO "general_type" VALUES(7,'',2,9,2,1,'Address',2,'Address');
INSERT INTO "general_type" VALUES(8,'',10,23,2,1,'Region',2,'Region');
INSERT INTO "general_type" VALUES(9,'',2,71,3,1,'Material',3,'Material');
INSERT INTO "general_type" VALUES(10,'',72,147,3,1,'Nonmaterial',3,'Non-material');
INSERT INTO "general_type" VALUES(11,'',148,313,3,1,'Record',3,'Record');
INSERT INTO "general_type" VALUES(12,'',314,367,3,1,'Unit',3,'Unit');
INSERT INTO "general_type" VALUES(13,'',5,32,1,2,'ic_project',5,'IC Project');
INSERT INTO "general_type" VALUES(14,'',149,162,3,2,'UnitRatio',11,'Unit Ratio');
INSERT INTO "general_type" VALUES(15,'',163,170,3,2,'',11,'currency Account');
INSERT INTO "general_type" VALUES(16,'',164,165,3,3,'AccountCes',15,'CES account');
INSERT INTO "general_type" VALUES(17,'',166,167,3,3,'AccountCrypto',15,'Crypto account');
INSERT INTO "general_type" VALUES(18,'',168,169,3,3,'AccountBank',15,'Bank account');
INSERT INTO "general_type" VALUES(19,'',37,38,1,2,'cooperative',6,'Cooperative');
INSERT INTO "general_type" VALUES(20,'',39,40,1,2,'bank',6,'Bank');
INSERT INTO "general_type" VALUES(21,'',7,8,1,4,'',23,'Local Selfmanaged Group');
INSERT INTO "general_type" VALUES(22,'',9,10,1,4,'ces',23,'Regional Network ("Ecoxarxa")');
INSERT INTO "general_type" VALUES(23,'',6,19,1,3,'public',13,'Public');
INSERT INTO "general_type" VALUES(24,'',11,12,1,4,'ces',23,'Integral Cooperative');
INSERT INTO "general_type" VALUES(25,'',13,14,1,4,'',23,'Productive Public');
INSERT INTO "general_type" VALUES(26,'',15,16,1,4,'',23,'Common Service');
INSERT INTO "general_type" VALUES(27,'',27,28,1,4,'',63,'Cooperating Collective');
INSERT INTO "general_type" VALUES(28,'',29,30,1,4,'',63,'Consumer Group');
INSERT INTO "general_type" VALUES(29,'',20,21,1,3,'',13,'Services project');
INSERT INTO "general_type" VALUES(31,'',22,25,1,3,'selfemployed',13,'Selfemployed');
INSERT INTO "general_type" VALUES(32,'',23,24,1,4,'',31,'Selfemployed stallholder');
INSERT INTO "general_type" VALUES(34,'',339,352,3,2,'currency',12,'Currency');
INSERT INTO "general_type" VALUES(35,'',340,343,3,3,'social_currency',34,'Social Currency');
INSERT INTO "general_type" VALUES(36,'',344,347,3,3,'crypto_currency',34,'Crypto Currency');
INSERT INTO "general_type" VALUES(37,'',348,351,3,3,'fiat_currency',34,'Fiat Currency');
INSERT INTO "general_type" VALUES(38,'',353,358,3,2,'area',12,'Area');
INSERT INTO "general_type" VALUES(39,'',11,20,2,2,'',8,'Continent');
INSERT INTO "general_type" VALUES(40,'',12,13,2,3,'',39,'Country');
INSERT INTO "general_type" VALUES(41,'',14,19,2,3,'',39,'Cultural Community');
INSERT INTO "general_type" VALUES(42,'',15,16,2,4,'',41,'Bioregion');
INSERT INTO "general_type" VALUES(43,'',17,18,2,4,'region',41,'County');
INSERT INTO "general_type" VALUES(44,'',3,4,2,2,'',7,'Collective Polyvalent Space');
INSERT INTO "general_type" VALUES(45,'',5,6,2,2,'',7,'Workspace');
INSERT INTO "general_type" VALUES(46,'',7,8,2,2,'',7,'Housing');
INSERT INTO "general_type" VALUES(47,'',33,34,1,2,'',5,'Worldwide Network');
INSERT INTO "general_type" VALUES(48,'',317,326,3,2,'time_currency',12,'Time');
INSERT INTO "general_type" VALUES(49,'',99,108,3,4,'',84,'live Formation');
INSERT INTO "general_type" VALUES(50,'',73,110,3,2,'',10,'Cultural artwork');
INSERT INTO "general_type" VALUES(51,'',111,132,3,2,'',10,'Digital artwork');
INSERT INTO "general_type" VALUES(52,'',100,105,3,5,'',49,'IC formation');
INSERT INTO "general_type" VALUES(53,'',101,102,3,6,'',52,'session of Collective formation');
INSERT INTO "general_type" VALUES(54,'',103,104,3,6,'',52,'session of Individual formation');
INSERT INTO "general_type" VALUES(55,'',18,27,3,3,'',89,'Machine');
INSERT INTO "general_type" VALUES(56,'',19,22,3,4,'',55,'Vehicle');
INSERT INTO "general_type" VALUES(57,'',20,21,3,5,'',56,'Car');
INSERT INTO "general_type" VALUES(58,'',150,151,3,3,'',14,'ratio Currency - Time');
INSERT INTO "general_type" VALUES(59,'',152,153,3,3,'',14,'ratio Currency - Currency');
INSERT INTO "general_type" VALUES(60,'',154,155,3,3,'',14,'ratio Area - Area');
INSERT INTO "general_type" VALUES(61,'',156,157,3,3,'',14,'ratio Time - Time');
INSERT INTO "general_type" VALUES(62,'',21,22,2,2,'',8,'Planet');
INSERT INTO "general_type" VALUES(63,'',26,31,1,3,'online',13,'Online');
INSERT INTO "general_type" VALUES(64,'',41,42,1,2,'',6,'Insurance company');
INSERT INTO "general_type" VALUES(65,'',85,92,3,4,'',149,'Image');
INSERT INTO "general_type" VALUES(66,'',17,18,1,4,'ic_larder',23,'Larder');
INSERT INTO "general_type" VALUES(67,'',327,332,3,2,'weight',12,'Weight');
INSERT INTO "general_type" VALUES(68,'',333,338,3,2,'length',12,'Length');
INSERT INTO "general_type" VALUES(69,'',158,159,3,3,'',14,'ratio Length - Length');
INSERT INTO "general_type" VALUES(70,'',160,161,3,3,'',14,'ratio Weight - Weight');
INSERT INTO "general_type" VALUES(71,'',74,83,3,3,'',50,'Text');
INSERT INTO "general_type" VALUES(73,'',75,76,3,4,'',71,'Poem');
INSERT INTO "general_type" VALUES(74,'',77,78,3,4,'',71,'Article');
INSERT INTO "general_type" VALUES(75,'',112,119,3,3,'',51,'Website');
INSERT INTO "general_type" VALUES(76,'',115,116,3,4,'',75,'Database');
INSERT INTO "general_type" VALUES(77,'',86,87,3,5,'',65,'Photo');
INSERT INTO "general_type" VALUES(78,'',88,89,3,5,'',65,'Illustration');
INSERT INTO "general_type" VALUES(79,'',90,91,3,5,'',65,'Graphic/Diagram');
INSERT INTO "general_type" VALUES(80,'',117,118,3,4,'',75,'Hosting Plan');
INSERT INTO "general_type" VALUES(81,'',113,114,3,4,'',75,'Plugin');
INSERT INTO "general_type" VALUES(82,'',95,96,3,4,'',84,'live Music');
INSERT INTO "general_type" VALUES(83,'',97,98,3,4,'',84,'Performance');
INSERT INTO "general_type" VALUES(84,'',94,109,3,3,'',50,'Live Event');
INSERT INTO "general_type" VALUES(85,'',120,125,3,3,'',51,'digital Music');
INSERT INTO "general_type" VALUES(86,'',121,122,3,4,'',85,'Song/Track');
INSERT INTO "general_type" VALUES(87,'',123,124,3,4,'',85,'Album');
INSERT INTO "general_type" VALUES(88,'',3,16,3,2,'',9,'Raw Material');
INSERT INTO "general_type" VALUES(89,'',17,30,3,2,'',9,'Tool');
INSERT INTO "general_type" VALUES(90,'',28,29,3,3,'',89,'Manual Tool');
INSERT INTO "general_type" VALUES(91,'',4,7,3,3,'',88,'raw Vegetal');
INSERT INTO "general_type" VALUES(92,'',8,9,3,3,'',88,'raw Mineral');
INSERT INTO "general_type" VALUES(93,'',10,11,3,3,'',88,'raw Animal');
INSERT INTO "general_type" VALUES(94,'',23,24,3,4,'',55,'Motor Hand Tool');
INSERT INTO "general_type" VALUES(95,'',36,43,3,3,'',160,'Food');
INSERT INTO "general_type" VALUES(96,'',37,40,3,4,'',95,'Artisan Vegetal derivate');
INSERT INTO "general_type" VALUES(97,'',44,45,3,3,'',160,'Drinks');
INSERT INTO "general_type" VALUES(98,'',41,42,3,4,'',95,'Artisan Animal derivate');
INSERT INTO "general_type" VALUES(124,'',171,312,3,2,'ocp_record',11,'OCP Record');
INSERT INTO "general_type" VALUES(125,'',172,311,3,3,'ocp_exchange',124,'OCP ExchangeType');
INSERT INTO "general_type" VALUES(126,'',173,208,3,4,'gift_economy',125,'Gift Economy:');
INSERT INTO "general_type" VALUES(127,'',209,224,3,4,'swap_economy',125,'Swap Economy:');
INSERT INTO "general_type" VALUES(128,'Mutual-credit currency operation',295,302,3,4,'social_economy',125,'Social Currency economy:');
INSERT INTO "general_type" VALUES(129,'Donate or present as a gift',174,189,3,5,'give',126,'Give gift:');
INSERT INTO "general_type" VALUES(130,'',190,207,3,5,'receive',126,'Receive gift:');
INSERT INTO "general_type" VALUES(131,'',175,180,3,6,'',129,'give Material resources');
INSERT INTO "general_type" VALUES(132,'',181,184,3,6,'',129,'give Non-material resources');
INSERT INTO "general_type" VALUES(133,'',185,188,3,6,'',129,'give Service time');
INSERT INTO "general_type" VALUES(134,'',191,196,3,6,'',130,'receive Material resources');
INSERT INTO "general_type" VALUES(135,'',197,200,3,6,'',130,'receive Non-material resources');
INSERT INTO "general_type" VALUES(136,'',201,206,3,6,'',130,'receive Service time');
INSERT INTO "general_type" VALUES(137,'',211,212,3,6,'',185,'swap Material for Material');
INSERT INTO "general_type" VALUES(138,'',213,214,3,6,'',185,'swap Material for Non-material');
INSERT INTO "general_type" VALUES(139,'',215,216,3,6,'',185,'swap Non-material for Material');
INSERT INTO "general_type" VALUES(140,'',217,218,3,6,'',185,'swap Non-material for Non-material');
INSERT INTO "general_type" VALUES(141,'',296,297,3,5,'sell',128,'social Sell:');
INSERT INTO "general_type" VALUES(142,'',298,299,3,5,'buy',128,'social Buy:');
INSERT INTO "general_type" VALUES(143,'',235,242,3,6,'',224,'fair-Sell Material resources');
INSERT INTO "general_type" VALUES(144,'',243,248,3,6,'',224,'fair-Sell Non-material resources');
INSERT INTO "general_type" VALUES(145,'',249,250,3,6,'',224,'fair sell Service-time');
INSERT INTO "general_type" VALUES(146,'',253,254,3,6,'',225,'fair-Buy Material resources');
INSERT INTO "general_type" VALUES(147,'',255,260,3,6,'',225,'fair-Buy Non-material resources');
INSERT INTO "general_type" VALUES(148,'',261,262,3,6,'',225,'fair buy Service time');
INSERT INTO "general_type" VALUES(149,'',84,93,3,3,'',50,'Visual');
INSERT INTO "general_type" VALUES(150,'',133,140,3,2,'',10,'Service');
INSERT INTO "general_type" VALUES(151,'',126,127,3,3,'',51,'digital File');
INSERT INTO "general_type" VALUES(152,'',5,6,3,4,'',91,'Fruit');
INSERT INTO "general_type" VALUES(153,'',25,26,3,4,'',55,'Laptop');
INSERT INTO "general_type" VALUES(155,'',141,146,3,2,'currency',10,'digital Currencies');
INSERT INTO "general_type" VALUES(156,'',142,143,3,3,'',155,'FairCoin');
INSERT INTO "general_type" VALUES(157,'',144,145,3,3,'',155,'Euro digital');
INSERT INTO "general_type" VALUES(158,'',31,34,3,2,'currency',9,'physical Currencies');
INSERT INTO "general_type" VALUES(159,'',32,33,3,3,'',158,'Euro cash');
INSERT INTO "general_type" VALUES(160,'',35,52,3,2,'',9,'Aliments');
INSERT INTO "general_type" VALUES(161,'',53,70,3,2,'',9,'Spaces');
INSERT INTO "general_type" VALUES(162,'',54,55,3,3,'',161,'Co-working space');
INSERT INTO "general_type" VALUES(163,'',56,57,3,3,'',161,'Eating space');
INSERT INTO "general_type" VALUES(164,'',58,59,3,3,'',161,'FabLab');
INSERT INTO "general_type" VALUES(165,'',38,39,3,5,'',96,'Jam');
INSERT INTO "general_type" VALUES(166,'',60,67,3,3,'',161,'Living space');
INSERT INTO "general_type" VALUES(167,'',46,47,3,3,'',160,'Meal');
INSERT INTO "general_type" VALUES(168,'',49,50,3,4,'',169,'Sweets');
INSERT INTO "general_type" VALUES(169,'',48,51,3,3,'',160,'Industrial pseudo-food');
INSERT INTO "general_type" VALUES(170,'',12,15,3,3,'',88,'Recycled materials');
INSERT INTO "general_type" VALUES(173,'',134,135,3,3,'',150,'Cleaning');
INSERT INTO "general_type" VALUES(174,'',136,137,3,3,'',150,'Cooking');
INSERT INTO "general_type" VALUES(175,'',106,107,3,5,'',49,'Course');
INSERT INTO "general_type" VALUES(176,'',138,139,3,3,'',150,'Programming');
INSERT INTO "general_type" VALUES(177,'',79,80,3,4,'',71,'Document');
INSERT INTO "general_type" VALUES(179,'',68,69,3,3,'',161,'Meeting room');
INSERT INTO "general_type" VALUES(180,'',81,82,3,4,'',71,'Translation');
INSERT INTO "general_type" VALUES(181,'',300,301,3,5,'rent',128,'social Rent:');
INSERT INTO "general_type" VALUES(182,'',289,292,3,6,'',220,'fiat-rent-Charge resources');
INSERT INTO "general_type" VALUES(183,'',285,288,3,6,'',220,'fiat-rent-Pay resources');
INSERT INTO "general_type" VALUES(184,'',290,291,3,7,'',182,'fiat-charge Space rental');
INSERT INTO "general_type" VALUES(185,'',210,219,3,5,'',127,'swap Resource for Resource');
INSERT INTO "general_type" VALUES(186,'',220,221,3,5,'',127,'swap Resource for Service Time');
INSERT INTO "general_type" VALUES(187,'',222,223,3,5,'',127,'swap Service Time for Service Time');
INSERT INTO "general_type" VALUES(214,'',227,232,3,4,'currency_exchange',125,'Currency Exchanges:');
INSERT INTO "general_type" VALUES(215,'',228,229,3,5,'',214,'exchange FiatCurrency for FairCoin');
INSERT INTO "general_type" VALUES(217,'',275,294,3,4,'fiat_economy',125,'Fiat-currency Economy:');
INSERT INTO "general_type" VALUES(218,'',276,277,3,5,'sell',217,'fiat Sell');
INSERT INTO "general_type" VALUES(219,'',278,283,3,5,'buy',217,'fiat Buy');
INSERT INTO "general_type" VALUES(220,'',284,293,3,5,'rent',217,'fiat Rent');
INSERT INTO "general_type" VALUES(221,'',225,226,3,4,'money_economy',125,'Monetary Economy:');
INSERT INTO "general_type" VALUES(222,'',233,274,3,4,'fair_economy',125,'Faircoin Economy:');
INSERT INTO "general_type" VALUES(223,'',303,310,3,4,'crypto_economy',125,'Cryptocoins economy');
INSERT INTO "general_type" VALUES(224,'',234,251,3,5,'sell',222,'fair Sell');
INSERT INTO "general_type" VALUES(225,'',252,263,3,5,'buy',222,'fair Buy');
INSERT INTO "general_type" VALUES(226,'',264,273,3,5,'rent',222,'fair Rent');
INSERT INTO "general_type" VALUES(227,'',304,305,3,5,'sell',223,'crypto Sell');
INSERT INTO "general_type" VALUES(228,'',306,307,3,5,'buy',223,'crypto Buy');
INSERT INTO "general_type" VALUES(229,'',308,309,3,5,'rent',223,'crypto Rent');
INSERT INTO "general_type" VALUES(230,'',230,231,3,5,'',214,'exchange SocialCurrency for FairCoin');
INSERT INTO "general_type" VALUES(231,'',286,287,3,7,'',183,'fiat-rent-pay Space');
INSERT INTO "general_type" VALUES(232,'',359,362,3,2,'volume',12,'Volume');
INSERT INTO "general_type" VALUES(233,'',318,319,3,3,'',48,'Hours');
INSERT INTO "general_type" VALUES(234,'',320,321,3,3,'',48,'Days');
INSERT INTO "general_type" VALUES(235,'',322,323,3,3,'',48,'Moons');
INSERT INTO "general_type" VALUES(236,'',363,364,3,2,'each',12,'Each');
INSERT INTO "general_type" VALUES(237,'',345,346,3,4,'faircoin',36,'Faircoins');
INSERT INTO "general_type" VALUES(238,'',328,329,3,3,'',67,'Kilos');
INSERT INTO "general_type" VALUES(240,'',365,366,3,2,'',12,'Percent');
INSERT INTO "general_type" VALUES(241,'',341,342,3,4,'',35,'EcoCoops');
INSERT INTO "general_type" VALUES(242,'',354,355,3,3,'',38,'Square meters');
INSERT INTO "general_type" VALUES(243,'',356,357,3,3,'',38,'Hectares');
INSERT INTO "general_type" VALUES(244,'',360,361,3,3,'',232,'Liters');
INSERT INTO "general_type" VALUES(245,'',330,331,3,3,'',67,'Grams');
INSERT INTO "general_type" VALUES(246,'',324,325,3,3,'',48,'Years');
INSERT INTO "general_type" VALUES(247,'',334,335,3,3,'',68,'Meters');
INSERT INTO "general_type" VALUES(248,'',336,337,3,3,'',68,'Kilometers');
INSERT INTO "general_type" VALUES(249,'',349,350,3,4,'euro',37,'Euros');
INSERT INTO "general_type" VALUES(250,'',128,129,3,3,'',51,'Software');
INSERT INTO "general_type" VALUES(251,'',182,183,3,7,'',132,'give FairCoin donation');
INSERT INTO "general_type" VALUES(252,'',265,268,3,6,'',226,'fair-rent-Pay any resources');
INSERT INTO "general_type" VALUES(253,'',269,272,3,6,'',226,'fair-rent-Charge any resources');
INSERT INTO "general_type" VALUES(254,'',198,199,3,7,'faircoin',135,'receive Faircoin donation');
INSERT INTO "general_type" VALUES(256,'',202,205,3,7,'',136,'receive Translating');
INSERT INTO "general_type" VALUES(257,'',176,177,3,7,'',131,'give Aliments');
INSERT INTO "general_type" VALUES(258,'',186,187,3,7,'',133,'give Communicating');
INSERT INTO "general_type" VALUES(259,'',194,195,3,7,'',134,'receive Tool');
INSERT INTO "general_type" VALUES(260,'',178,179,3,7,'',131,'give Tool');
INSERT INTO "general_type" VALUES(261,'Room rent covers just the base costs of the house, no meals,
but does include tea and coffee.
',61,62,3,4,'',166,'Daily room rent');
INSERT INTO "general_type" VALUES(262,'',63,64,3,4,'',166,'Monthly Living space');
INSERT INTO "general_type" VALUES(263,'',270,271,3,7,'',253,'fair-rent-charge Monthly Living space');
INSERT INTO "general_type" VALUES(264,'',13,14,3,4,'',170,'recicle Plastics');
INSERT INTO "general_type" VALUES(265,'Gives you 250 days per year.',65,66,3,4,'',166,'Yearly Living space <');
INSERT INTO "general_type" VALUES(266,'',279,280,3,6,'',219,'fiat-buy Material resources');
INSERT INTO "general_type" VALUES(267,'',281,282,3,6,'',219,'fiat-buy Non-material resources');
INSERT INTO "general_type" VALUES(269,'',236,237,3,7,'',143,'fair-sell Tool');
INSERT INTO "general_type" VALUES(270,'',244,245,3,7,'',144,'fair-sell Album');
INSERT INTO "general_type" VALUES(271,'',130,131,3,3,'',51,'Internet connection');
INSERT INTO "general_type" VALUES(274,'',238,239,3,7,'',143,'fair-sell Fruit');
INSERT INTO "general_type" VALUES(275,'',256,257,3,7,'',147,'fair-buy Website');
INSERT INTO "general_type" VALUES(276,'',258,259,3,7,'',147,'fair-buy Internet connection');
INSERT INTO "general_type" VALUES(277,'',240,241,3,7,'',143,'fair-Sell Spaces');
DROP TABLE "general_artwork_type";
CREATE TABLE "general_artwork_type" ("typ_id" integer NOT NULL PRIMARY KEY REFERENCES "general_type" ("id"));
INSERT INTO "general_artwork_type" VALUES(9);
INSERT INTO "general_artwork_type" VALUES(10);
INSERT INTO "general_artwork_type" VALUES(11);
INSERT INTO "general_artwork_type" VALUES(12);
INSERT INTO "general_artwork_type" VALUES(14);
INSERT INTO "general_artwork_type" VALUES(15);
INSERT INTO "general_artwork_type" VALUES(16);
INSERT INTO "general_artwork_type" VALUES(17);
INSERT INTO "general_artwork_type" VALUES(18);
INSERT INTO "general_artwork_type" VALUES(34);
INSERT INTO "general_artwork_type" VALUES(35);
INSERT INTO "general_artwork_type" VALUES(36);
INSERT INTO "general_artwork_type" VALUES(37);
INSERT INTO "general_artwork_type" VALUES(38);
INSERT INTO "general_artwork_type" VALUES(48);
INSERT INTO "general_artwork_type" VALUES(49);
INSERT INTO "general_artwork_type" VALUES(50);
INSERT INTO "general_artwork_type" VALUES(51);
INSERT INTO "general_artwork_type" VALUES(52);
INSERT INTO "general_artwork_type" VALUES(53);
INSERT INTO "general_artwork_type" VALUES(54);
INSERT INTO "general_artwork_type" VALUES(55);
INSERT INTO "general_artwork_type" VALUES(56);
INSERT INTO "general_artwork_type" VALUES(57);
INSERT INTO "general_artwork_type" VALUES(58);
INSERT INTO "general_artwork_type" VALUES(59);
INSERT INTO "general_artwork_type" VALUES(60);
INSERT INTO "general_artwork_type" VALUES(61);
INSERT INTO "general_artwork_type" VALUES(65);
INSERT INTO "general_artwork_type" VALUES(67);
INSERT INTO "general_artwork_type" VALUES(68);
INSERT INTO "general_artwork_type" VALUES(69);
INSERT INTO "general_artwork_type" VALUES(70);
INSERT INTO "general_artwork_type" VALUES(71);
INSERT INTO "general_artwork_type" VALUES(73);
INSERT INTO "general_artwork_type" VALUES(74);
INSERT INTO "general_artwork_type" VALUES(75);
INSERT INTO "general_artwork_type" VALUES(76);
INSERT INTO "general_artwork_type" VALUES(77);
INSERT INTO "general_artwork_type" VALUES(78);
INSERT INTO "general_artwork_type" VALUES(79);
INSERT INTO "general_artwork_type" VALUES(80);
INSERT INTO "general_artwork_type" VALUES(81);
INSERT INTO "general_artwork_type" VALUES(82);
INSERT INTO "general_artwork_type" VALUES(83);
INSERT INTO "general_artwork_type" VALUES(84);
INSERT INTO "general_artwork_type" VALUES(85);
INSERT INTO "general_artwork_type" VALUES(86);
INSERT INTO "general_artwork_type" VALUES(87);
INSERT INTO "general_artwork_type" VALUES(88);
INSERT INTO "general_artwork_type" VALUES(89);
INSERT INTO "general_artwork_type" VALUES(90);
INSERT INTO "general_artwork_type" VALUES(91);
INSERT INTO "general_artwork_type" VALUES(92);
INSERT INTO "general_artwork_type" VALUES(93);
INSERT INTO "general_artwork_type" VALUES(94);
INSERT INTO "general_artwork_type" VALUES(95);
INSERT INTO "general_artwork_type" VALUES(96);
INSERT INTO "general_artwork_type" VALUES(97);
INSERT INTO "general_artwork_type" VALUES(98);
INSERT INTO "general_artwork_type" VALUES(124);
INSERT INTO "general_artwork_type" VALUES(125);
INSERT INTO "general_artwork_type" VALUES(126);
INSERT INTO "general_artwork_type" VALUES(127);
INSERT INTO "general_artwork_type" VALUES(128);
INSERT INTO "general_artwork_type" VALUES(129);
INSERT INTO "general_artwork_type" VALUES(130);
INSERT INTO "general_artwork_type" VALUES(131);
INSERT INTO "general_artwork_type" VALUES(132);
INSERT INTO "general_artwork_type" VALUES(133);
INSERT INTO "general_artwork_type" VALUES(134);
INSERT INTO "general_artwork_type" VALUES(135);
INSERT INTO "general_artwork_type" VALUES(136);
INSERT INTO "general_artwork_type" VALUES(137);
INSERT INTO "general_artwork_type" VALUES(138);
INSERT INTO "general_artwork_type" VALUES(139);
INSERT INTO "general_artwork_type" VALUES(140);
INSERT INTO "general_artwork_type" VALUES(141);
INSERT INTO "general_artwork_type" VALUES(142);
INSERT INTO "general_artwork_type" VALUES(143);
INSERT INTO "general_artwork_type" VALUES(144);
INSERT INTO "general_artwork_type" VALUES(145);
INSERT INTO "general_artwork_type" VALUES(146);
INSERT INTO "general_artwork_type" VALUES(147);
INSERT INTO "general_artwork_type" VALUES(148);
INSERT INTO "general_artwork_type" VALUES(149);
INSERT INTO "general_artwork_type" VALUES(150);
INSERT INTO "general_artwork_type" VALUES(151);
INSERT INTO "general_artwork_type" VALUES(152);
INSERT INTO "general_artwork_type" VALUES(153);
INSERT INTO "general_artwork_type" VALUES(155);
INSERT INTO "general_artwork_type" VALUES(156);
INSERT INTO "general_artwork_type" VALUES(157);
INSERT INTO "general_artwork_type" VALUES(158);
INSERT INTO "general_artwork_type" VALUES(159);
INSERT INTO "general_artwork_type" VALUES(160);
INSERT INTO "general_artwork_type" VALUES(161);
INSERT INTO "general_artwork_type" VALUES(162);
INSERT INTO "general_artwork_type" VALUES(163);
INSERT INTO "general_artwork_type" VALUES(164);
INSERT INTO "general_artwork_type" VALUES(165);
INSERT INTO "general_artwork_type" VALUES(166);
INSERT INTO "general_artwork_type" VALUES(167);
INSERT INTO "general_artwork_type" VALUES(168);
INSERT INTO "general_artwork_type" VALUES(169);
INSERT INTO "general_artwork_type" VALUES(170);
INSERT INTO "general_artwork_type" VALUES(173);
INSERT INTO "general_artwork_type" VALUES(174);
INSERT INTO "general_artwork_type" VALUES(175);
INSERT INTO "general_artwork_type" VALUES(176);
INSERT INTO "general_artwork_type" VALUES(177);
INSERT INTO "general_artwork_type" VALUES(179);
INSERT INTO "general_artwork_type" VALUES(180);
INSERT INTO "general_artwork_type" VALUES(181);
INSERT INTO "general_artwork_type" VALUES(182);
INSERT INTO "general_artwork_type" VALUES(183);
INSERT INTO "general_artwork_type" VALUES(184);
INSERT INTO "general_artwork_type" VALUES(185);
INSERT INTO "general_artwork_type" VALUES(186);
INSERT INTO "general_artwork_type" VALUES(187);
INSERT INTO "general_artwork_type" VALUES(214);
INSERT INTO "general_artwork_type" VALUES(215);
INSERT INTO "general_artwork_type" VALUES(217);
INSERT INTO "general_artwork_type" VALUES(218);
INSERT INTO "general_artwork_type" VALUES(219);
INSERT INTO "general_artwork_type" VALUES(220);
INSERT INTO "general_artwork_type" VALUES(221);
INSERT INTO "general_artwork_type" VALUES(222);
INSERT INTO "general_artwork_type" VALUES(223);
INSERT INTO "general_artwork_type" VALUES(224);
INSERT INTO "general_artwork_type" VALUES(225);
INSERT INTO "general_artwork_type" VALUES(226);
INSERT INTO "general_artwork_type" VALUES(227);
INSERT INTO "general_artwork_type" VALUES(228);
INSERT INTO "general_artwork_type" VALUES(229);
INSERT INTO "general_artwork_type" VALUES(230);
INSERT INTO "general_artwork_type" VALUES(231);
INSERT INTO "general_artwork_type" VALUES(232);
INSERT INTO "general_artwork_type" VALUES(233);
INSERT INTO "general_artwork_type" VALUES(234);
INSERT INTO "general_artwork_type" VALUES(235);
INSERT INTO "general_artwork_type" VALUES(236);
INSERT INTO "general_artwork_type" VALUES(237);
INSERT INTO "general_artwork_type" VALUES(238);
INSERT INTO "general_artwork_type" VALUES(240);
INSERT INTO "general_artwork_type" VALUES(241);
INSERT INTO "general_artwork_type" VALUES(242);
INSERT INTO "general_artwork_type" VALUES(243);
INSERT INTO "general_artwork_type" VALUES(244);
INSERT INTO "general_artwork_type" VALUES(245);
INSERT INTO "general_artwork_type" VALUES(246);
INSERT INTO "general_artwork_type" VALUES(247);
INSERT INTO "general_artwork_type" VALUES(248);
INSERT INTO "general_artwork_type" VALUES(249);
INSERT INTO "general_artwork_type" VALUES(250);
INSERT INTO "general_artwork_type" VALUES(251);
INSERT INTO "general_artwork_type" VALUES(252);
INSERT INTO "general_artwork_type" VALUES(253);
INSERT INTO "general_artwork_type" VALUES(254);
INSERT INTO "general_artwork_type" VALUES(256);
INSERT INTO "general_artwork_type" VALUES(257);
INSERT INTO "general_artwork_type" VALUES(258);
INSERT INTO "general_artwork_type" VALUES(259);
INSERT INTO "general_artwork_type" VALUES(260);
INSERT INTO "general_artwork_type" VALUES(261);
INSERT INTO "general_artwork_type" VALUES(262);
INSERT INTO "general_artwork_type" VALUES(263);
INSERT INTO "general_artwork_type" VALUES(264);
INSERT INTO "general_artwork_type" VALUES(265);
INSERT INTO "general_artwork_type" VALUES(266);
INSERT INTO "general_artwork_type" VALUES(267);
INSERT INTO "general_artwork_type" VALUES(269);
INSERT INTO "general_artwork_type" VALUES(270);
INSERT INTO "general_artwork_type" VALUES(271);
INSERT INTO "general_artwork_type" VALUES(274);
INSERT INTO "general_artwork_type" VALUES(275);
INSERT INTO "general_artwork_type" VALUES(276);
INSERT INTO "general_artwork_type" VALUES(277);
DROP TABLE "general_unit_type";
CREATE TABLE "general_unit_type" ("artwork_type_id" integer NOT NULL PRIMARY KEY REFERENCES "general_artwork_type" ("typ_id"));
INSERT INTO "general_unit_type" VALUES(34);
INSERT INTO "general_unit_type" VALUES(35);
INSERT INTO "general_unit_type" VALUES(36);
INSERT INTO "general_unit_type" VALUES(37);
INSERT INTO "general_unit_type" VALUES(38);
INSERT INTO "general_unit_type" VALUES(48);
INSERT INTO "general_unit_type" VALUES(67);
INSERT INTO "general_unit_type" VALUES(68);
INSERT INTO "general_unit_type" VALUES(232);
INSERT INTO "general_unit_type" VALUES(233);
INSERT INTO "general_unit_type" VALUES(234);
INSERT INTO "general_unit_type" VALUES(235);
INSERT INTO "general_unit_type" VALUES(236);
INSERT INTO "general_unit_type" VALUES(237);
INSERT INTO "general_unit_type" VALUES(238);
INSERT INTO "general_unit_type" VALUES(240);
INSERT INTO "general_unit_type" VALUES(241);
INSERT INTO "general_unit_type" VALUES(242);
INSERT INTO "general_unit_type" VALUES(243);
INSERT INTO "general_unit_type" VALUES(244);
INSERT INTO "general_unit_type" VALUES(245);
INSERT INTO "general_unit_type" VALUES(246);
INSERT INTO "general_unit_type" VALUES(247);
INSERT INTO "general_unit_type" VALUES(248);
INSERT INTO "general_unit_type" VALUES(249);
DROP TABLE "general_unit";
CREATE TABLE "general_unit" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "name" varchar(200) NULL, "description" text NULL, "code" varchar(4) NOT NULL, "region_id" integer NULL REFERENCES "general_region" ("id"), "unit_type_id" integer NULL REFERENCES "general_unit_type" ("artwork_type_id"));
INSERT INTO "general_unit" VALUES(1,'EcoCoop','','eco',NULL,35);
INSERT INTO "general_unit" VALUES(2,'Euro','','€',NULL,37);
INSERT INTO "general_unit" VALUES(3,'Square Meter','','m2',NULL,38);
INSERT INTO "general_unit" VALUES(4,'Hectare','','Ha',NULL,38);
INSERT INTO "general_unit" VALUES(5,'Hour','','h',NULL,48);
INSERT INTO "general_unit" VALUES(6,'Riu','','riu',4,35);
INSERT INTO "general_unit" VALUES(7,'FairCoin','','ƒ',6,36);
INSERT INTO "general_unit" VALUES(8,'Day','','dd',NULL,48);
INSERT INTO "general_unit" VALUES(9,'Moon cycle','','moon',NULL,48);
INSERT INTO "general_unit" VALUES(10,'Year','','yy',NULL,48);
INSERT INTO "general_unit" VALUES(11,'SocialCurrency','','SCUR',NULL,35);
INSERT INTO "general_unit" VALUES(12,'Meter','','m',NULL,68);
INSERT INTO "general_unit" VALUES(13,'Kilometer','','Km',NULL,68);
INSERT INTO "general_unit" VALUES(14,'Kilogram','','Kg',NULL,67);
INSERT INTO "general_unit" VALUES(15,'Gram','','gr',NULL,67);
CREATE INDEX "general_address_18232d5b" ON "general_address" ("address_type_id");
CREATE INDEX "general_address_0f442f96" ON "general_address" ("region_id");
CREATE INDEX "general_address_04cd67a5" ON "general_address" ("size_unit_id");
CREATE INDEX "general_job_caf7cc51" ON "general_job" ("lft");
CREATE INDEX "general_job_3cfbd988" ON "general_job" ("rght");
CREATE INDEX "general_job_656442a0" ON "general_job" ("tree_id");
CREATE INDEX "general_job_c9e9a848" ON "general_job" ("level");
CREATE INDEX "general_job_6be37982" ON "general_job" ("parent_id");
CREATE INDEX "general_record_6c31fb9d" ON "general_record" ("record_type_id");
CREATE INDEX "general_region_caf7cc51" ON "general_region" ("lft");
CREATE INDEX "general_region_3cfbd988" ON "general_region" ("rght");
CREATE INDEX "general_region_656442a0" ON "general_region" ("tree_id");
CREATE INDEX "general_region_c9e9a848" ON "general_region" ("level");
CREATE INDEX "general_region_6be37982" ON "general_region" ("parent_id");
CREATE INDEX "general_region_1a6a5d39" ON "general_region" ("region_type_id");
CREATE INDEX "general_relation_caf7cc51" ON "general_relation" ("lft");
CREATE INDEX "general_relation_3cfbd988" ON "general_relation" ("rght");
CREATE INDEX "general_relation_656442a0" ON "general_relation" ("tree_id");
CREATE INDEX "general_relation_c9e9a848" ON "general_relation" ("level");
CREATE INDEX "general_relation_6be37982" ON "general_relation" ("parent_id");
CREATE INDEX "general_unitratio_ceed3714" ON "general_unitratio" ("in_unit_id");
CREATE INDEX "general_unitratio_8fd14cad" ON "general_unitratio" ("out_unit_id");
CREATE INDEX "general_address_jobs_ea8e5d12" ON "general_address_jobs" ("address_id");
CREATE INDEX "general_address_jobs_d697ea38" ON "general_address_jobs" ("job_id");
CREATE INDEX "general_type_caf7cc51" ON "general_type" ("lft");
CREATE INDEX "general_type_3cfbd988" ON "general_type" ("rght");
CREATE INDEX "general_type_656442a0" ON "general_type" ("tree_id");
CREATE INDEX "general_type_c9e9a848" ON "general_type" ("level");
CREATE INDEX "general_type_6be37982" ON "general_type" ("parent_id");
CREATE INDEX "general_unit_0f442f96" ON "general_unit" ("region_id");
CREATE INDEX "general_unit_9f43caa0" ON "general_unit" ("unit_type_id");
COMMIT;