GIT.Harvie.CZ / mirrors / Kyberia-bloodline.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
SQL structure fix
[mirrors/Kyberia-bloodline.git] / sql / kyberia_23free_minimal_db_20101019_niekt0.sql
diff --git a/sql/kyberia_2.3_minimal_db_20100221_niekt0.sql b/sql/kyberia_23free_minimal_db_20101019_niekt0.sql
similarity index 99%
rename from sql/kyberia_2.3_minimal_db_20100221_niekt0.sql
rename to sql/kyberia_23free_minimal_db_20101019_niekt0.sql
index a42cc6e21da366713b73113cdc1ff0bc37f9e1b1..899d1e0418019f24da2b9987b887674bb5102da3 100644 (file)
--- a/sql/kyberia_2.3_minimal_db_20100221_niekt0.sql
+++ b/sql/kyberia_23free_minimal_db_20101019_niekt0.sql
@@ -78,7 +78,7 @@ CREATE TABLE `del` (
   `node_vector` varchar(400) NOT NULL,
   PRIMARY KEY  (`node_id`),
   KEY `node_vector` (`node_vector`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -116,15 +116,13 @@ CREATE TABLE `deleted` (
   `external_link` varchar(123) NOT NULL,
   `node_vector` varchar(230) NOT NULL,
   `node_content` text NOT NULL,
-  `node_level3` int(13) NOT NULL,
   `node_destructor` int(13) NOT NULL,
   `node_destructed` datetime NOT NULL,
   PRIMARY KEY  (`node_id`),
   KEY `node_creator` (`node_creator`),
   KEY `node_destructor` (`node_destructor`),
-  KEY `node_level3` (`node_level3`),
   FULLTEXT KEY `node_vector` (`node_vector`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -147,7 +145,7 @@ CREATE TABLE `levenshtein` (
   `user_id` int(11) default NULL,
   `node_id` int(11) default NULL,
   `access_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -175,7 +173,7 @@ CREATE TABLE `logs` (
   `parameter2` varchar(23) default NULL,
   `result` varchar(10) default NULL,
   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -208,7 +206,7 @@ CREATE TABLE `mail` (
   KEY `mail_duplicate_id` (`mail_duplicate_id`),
   KEY `mail_user_from_to` (`mail_user`,`mail_from`,`mail_to`),
   KEY `mail_user_to_read` (`mail_user`,`mail_to`,`mail_read`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -237,7 +235,7 @@ CREATE TABLE `mail_archive` (
   PRIMARY KEY  (`mail_archive_id`),
   KEY `user_id_date_from_to` (`user_id`,`date`,`user_from`,`user_to`),
   KEY `user_id_date_to` (`user_id`,`date`,`user_to`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -262,7 +260,7 @@ CREATE TABLE `n_recount` (
   `descendants` int(11) NOT NULL default '0',
   `k` int(11) NOT NULL default '0',
   PRIMARY KEY  (`node_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -290,13 +288,11 @@ CREATE TABLE `neurons` (
   `synapse_created` datetime default NULL,
   `dst_vector` char(232) default NULL,
   `synapse_creator` int(11) NOT NULL default '0',
-  `dst_level3` int(13) NOT NULL default '0',
   UNIQUE KEY `relation` (`dst`,`src`),
   KEY `central_link` (`dst`,`link`),
   KEY `dst_vector` (`dst_vector`),
-  KEY `src` (`src`),
-  KEY `dst_level3` (`dst_level3`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+  KEY `src` (`src`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -305,7 +301,7 @@ SET character_set_client = @saved_cs_client;
 
 LOCK TABLES `neurons` WRITE;
 /*!40000 ALTER TABLE `neurons` DISABLE KEYS */;
-INSERT INTO `neurons` VALUES (19,12,1,'soft','2009-05-26 23:23:58',NULL,NULL,904,0),(904,19,12,'soft','2010-02-16 22:35:57',NULL,NULL,904,0),(904,904,32,'soft','2010-02-21 17:25:16',NULL,NULL,904,0),(0,904,1,'soft','2009-05-26 23:24:13',NULL,NULL,904,0),(24,904,1,'soft','2009-05-26 23:24:39',NULL,NULL,904,0),(19,24,4,'soft','2010-02-16 22:36:34',NULL,NULL,904,0),(102,19,8,'soft','2010-02-21 17:26:27',NULL,NULL,904,0),(27,23,5,'soft','2010-02-16 22:35:39',NULL,NULL,904,0),(101,27,1,'soft','2009-05-26 23:25:24',NULL,NULL,904,0),(102,101,6,'soft','2010-02-16 23:03:33',NULL,NULL,904,0),(101,102,7,'soft','2010-02-16 22:48:43',NULL,NULL,904,0),(1,101,4,'soft','2010-02-16 22:48:45',NULL,NULL,904,0),(1,1,9,'soft','2010-02-21 17:54:58',NULL,NULL,904,0),(21,27,7,'soft','2010-02-16 18:05:41',NULL,NULL,904,0),(21,21,4,'soft','2010-02-21 17:27:08',NULL,NULL,904,0),(0,548,1,'soft','2009-05-27 21:50:29',NULL,NULL,904,0),(548,548,1,'soft','2009-05-28 11:38:01',NULL,NULL,904,0),(19,19,16,'soft','2009-05-30 08:49:02',NULL,NULL,904,0),(1,19,8,'soft','2010-02-21 17:54:57',NULL,NULL,904,0),(0,1,1,'soft','2009-05-28 14:30:30',NULL,NULL,904,0),(24,102,1,'soft','2009-05-28 14:30:48',NULL,NULL,904,0),(23,24,6,'soft','2010-02-16 18:05:38',NULL,NULL,904,0),(0,23,1,'soft','2009-05-28 14:30:58',NULL,NULL,904,0),(0,27,3,'soft','2009-05-29 22:40:53',NULL,NULL,904,0),(15,27,2,'soft','2009-05-30 11:31:30',NULL,NULL,904,0),(0,15,2,'soft','2009-05-28 14:31:19',NULL,NULL,904,0),(904,15,1,'soft','2009-05-28 14:31:21',NULL,NULL,904,0),(19,904,4,'soft','2009-05-28 21:01:54',NULL,NULL,904,0),(192,192,10,'soft','2009-05-28 19:56:36',NULL,NULL,904,0),(258,192,1,'soft','2009-05-28 19:56:44',NULL,NULL,904,0),(258,258,1,'soft','2009-05-28 19:56:49',NULL,NULL,904,0),(19,258,1,'soft','2009-05-28 19:56:53',NULL,NULL,904,0),(904,1,1,'soft','2009-05-28 20:37:33',NULL,NULL,904,0),(548,1,1,'soft','2009-05-28 20:50:49',NULL,NULL,904,0),(19,1,6,'soft','2010-02-21 17:54:54',NULL,NULL,904,0),(101,19,3,'soft','2010-02-15 23:58:26',NULL,NULL,904,0),(0,102,1,'soft','2009-05-28 21:02:19',NULL,NULL,904,0),(1,102,1,'soft','2009-05-28 21:08:51',NULL,NULL,904,0),(101,1,4,'soft','2010-02-16 23:03:31',NULL,NULL,904,0),(683817,102,6,'soft','2010-02-16 23:03:34',NULL,NULL,904,0),(19,683817,3,'soft','2010-02-15 23:58:19',NULL,NULL,904,0),(24,19,5,'soft','2010-02-16 18:05:36',NULL,NULL,904,0),(1522695,23,5,'soft','2009-05-30 14:11:23',NULL,NULL,904,0),(27,1522695,5,'soft','2009-05-30 14:11:24',NULL,NULL,904,0),(15,21,5,'soft','2010-02-16 18:05:46',NULL,NULL,904,0),(788016,15,7,'soft','2010-02-16 18:05:47',NULL,NULL,904,0),(876611,788016,6,'soft','2010-02-16 18:05:48',NULL,NULL,904,0),(1058182,788016,6,'soft','2010-02-16 18:05:52',NULL,NULL,904,0),(25,1058182,7,'soft','2010-02-16 18:05:54',NULL,NULL,904,0),(904,25,3,'soft','2010-02-16 16:21:57',NULL,NULL,904,0),(19,1017832,2,'soft','2010-02-16 22:49:47',NULL,NULL,904,0),(1017832,19,3,'soft','2010-02-16 23:02:52',NULL,NULL,904,0),(102,24,1,'soft','2009-05-28 21:49:12',NULL,NULL,904,0),(683817,101,1,'soft','2009-05-28 21:49:16',NULL,NULL,904,0),(683817,683817,5,'soft','2010-02-16 22:50:12',NULL,NULL,904,0),(332,683817,2,'soft','2009-05-30 14:34:54',NULL,NULL,904,0),(332,332,19,'soft','2010-02-16 22:45:11',NULL,NULL,904,0),(21,332,1,'soft','2009-05-28 21:50:07',NULL,NULL,904,0),(27,21,4,'soft','2010-02-16 16:22:20',NULL,NULL,904,0),(1522695,27,3,'soft','2010-02-16 22:49:22',NULL,NULL,904,0),(15,1522695,2,'soft','2010-02-16 22:35:41',NULL,NULL,904,0),(1017832,904,2,'soft','2010-02-16 16:22:00',NULL,NULL,904,0),(63556,1017832,1,'soft','2009-05-28 21:50:48',NULL,NULL,904,0),(23,27,3,'soft','2010-02-16 22:36:20',NULL,NULL,904,0),(24,24,2,'soft','2009-05-29 19:52:06',NULL,NULL,332,0),(1058182,19,3,'soft','2010-02-16 22:49:50',NULL,NULL,332,0),(27,27,1,'soft','2009-05-29 19:52:27',NULL,NULL,332,0),(332,102,1,'soft','2009-05-29 19:52:47',NULL,NULL,332,0),(24,1,1,'soft','2009-05-29 22:56:10',NULL,NULL,332,0),(21,15,2,'soft','2010-02-16 13:08:19',NULL,NULL,332,0),(1844482,21,4,'soft','2010-02-16 22:55:22',NULL,NULL,332,0),(1,25,2,'soft','2010-02-16 22:52:04',NULL,NULL,332,0),(21,19,2,'soft','2010-02-15 23:58:10',NULL,NULL,904,0),(1,21,2,'soft','2009-05-30 08:45:52',NULL,NULL,904,0),(332,25,3,'soft','2010-02-16 22:49:35',NULL,NULL,332,0),(1,332,1,'soft','2009-05-30 11:31:40',NULL,NULL,332,0),(1017832,101,1,'soft','2009-05-30 11:31:45',NULL,NULL,332,0),(332,1017832,1,'soft','2009-05-30 11:31:48',NULL,NULL,332,0),(101,332,1,'soft','2009-05-30 11:31:58',NULL,NULL,332,0),(101,101,9,'soft','2010-02-16 22:44:37',NULL,NULL,332,0),(4738019,101,1,'soft','2009-05-30 11:32:20',NULL,NULL,332,0),(332,19,1,'soft','2009-05-30 14:00:53',NULL,NULL,332,0),(102,683817,3,'soft','2010-02-16 22:48:41',NULL,NULL,332,0),(332,904,3,'bookmark','2009-05-30 14:10:11','2009-05-30 16:10:05',NULL,332,0),(23,23,2,'soft','2010-02-16 22:36:21',NULL,NULL,332,0),(1017832,332,2,'soft','2010-02-16 22:49:42',NULL,NULL,332,0),(683817,1017832,2,'soft','2010-02-16 22:48:20',NULL,NULL,332,0),(19,332,1,'soft','2009-05-30 14:35:08',NULL,NULL,904,0),(19,1062076,1,'soft','2010-02-15 23:58:03',NULL,NULL,904,0),(102,788016,1,'soft','2010-02-15 23:58:15',NULL,NULL,904,0),(63539,101,1,'soft','2010-02-15 23:58:30',NULL,NULL,904,0),(25,25,25,'soft','2010-02-17 00:33:53',NULL,NULL,904,0),(27,25,1,'soft','2010-02-16 13:08:13',NULL,NULL,904,0),(788016,27,1,'soft','2010-02-16 13:08:16',NULL,NULL,904,0),(15,788016,1,'soft','2010-02-16 13:08:18',NULL,NULL,904,0),(1522695,21,1,'soft','2010-02-16 13:08:22',NULL,NULL,904,0),(21,1522695,1,'soft','2010-02-16 13:08:23',NULL,NULL,904,0),(25,19,2,'soft','2010-02-16 13:33:43',NULL,NULL,904,0),(19,25,3,'soft','2010-02-16 22:25:04',NULL,NULL,904,0),(2115046,1,1,'soft','2010-02-16 16:21:41',NULL,NULL,904,0),(904,1058182,1,'soft','2010-02-16 16:21:54',NULL,NULL,904,0),(25,1017832,1,'soft','2010-02-16 16:22:16',NULL,NULL,904,0),(21,25,1,'soft','2010-02-16 16:22:18',NULL,NULL,904,0),(24,23,3,'soft','2010-02-16 22:49:28',NULL,NULL,904,0),(683817,19,2,'soft','2010-02-16 22:35:32',NULL,NULL,904,0),(1432305,683817,2,'soft','2010-02-16 22:50:04',NULL,NULL,904,0),(24,683817,1,'soft','2010-02-16 16:23:14',NULL,NULL,904,0),(1,24,1,'soft','2010-02-16 16:23:16',NULL,NULL,904,0),(876611,19,1,'soft','2010-02-16 18:05:10',NULL,NULL,904,0),(2335451,25,1,'soft','2010-02-16 22:25:19',NULL,NULL,904,0),(1844482,25,1,'soft','2010-02-16 22:25:25',NULL,NULL,904,0),(25,1,3,'soft','2010-02-16 23:16:39',NULL,NULL,904,0),(21842,25,2,'soft','2010-02-16 23:03:54',NULL,NULL,904,0),(904,21842,1,'soft','2010-02-16 22:31:50',NULL,NULL,904,0),(23,904,1,'soft','2010-02-16 22:32:35',NULL,NULL,904,0),(19,23,1,'soft','2010-02-16 22:35:30',NULL,NULL,904,0),(23,1,2,'soft','2010-02-16 23:06:53',NULL,NULL,904,0),(2527821,27,3,'soft','2010-02-16 22:49:21',NULL,NULL,904,0),(19,15,1,'soft','2010-02-16 22:35:45',NULL,NULL,904,0),(1522695,19,2,'soft','2010-02-21 17:24:53',NULL,NULL,904,0),(27,904,1,'soft','2010-02-16 22:36:18',NULL,NULL,904,0),(21842,21842,21,'soft','2010-02-21 17:52:44',NULL,NULL,904,0),(1,21842,3,'hard','2010-02-21 17:52:44','2010-02-21 12:52:44','0000000100021842',332,0),(1017832,1,2,'soft','2010-02-16 22:40:17',NULL,NULL,332,0),(102,1017832,1,'soft','2010-02-16 22:43:38',NULL,NULL,332,0),(31,1,1,'soft','2010-02-16 22:48:50',NULL,NULL,332,0),(17,1,1,'soft','2010-02-16 22:49:02',NULL,NULL,332,0),(12,1,1,'soft','2010-02-16 22:49:10',NULL,NULL,332,0),(27,1,1,'soft','2010-02-16 22:49:20',NULL,NULL,332,0),(23,1522695,1,'soft','2010-02-16 22:49:24',NULL,NULL,332,0),(876611,24,1,'soft','2010-02-16 22:49:30',NULL,NULL,332,0),(25,24,1,'soft','2010-02-16 22:49:34',NULL,NULL,332,0),(25,21842,1,'soft','2010-02-16 22:52:02',NULL,NULL,332,0),(3081544,25,2,'soft','2010-02-16 23:16:45',NULL,NULL,332,0),(1227763,1017832,1,'soft','2010-02-16 23:02:57',NULL,NULL,332,0),(1,683817,1,'soft','2010-02-16 23:03:38',NULL,NULL,332,0),(2284387,25,1,'soft','2010-02-16 23:16:46',NULL,NULL,332,0),(1662468,25,1,'soft','2010-02-16 23:16:48',NULL,NULL,332,0),(1870248,25,1,'soft','2010-02-16 23:16:49',NULL,NULL,332,0),(196177,25,1,'soft','2010-02-16 23:16:55',NULL,NULL,332,0),(2284387,2284387,7,'soft','2010-02-16 23:19:27',NULL,NULL,332,0),(1,23,1,'soft','2010-02-16 23:18:07',NULL,NULL,332,0),(3081544,3081544,5,'soft','2010-02-16 23:19:39',NULL,NULL,332,0),(2527821,1,18,'soft','2010-02-21 17:54:59',NULL,NULL,332,0),(2527821,19,3,'soft','2010-02-21 17:54:55',NULL,NULL,904,0),(4738023,904,1,'soft','2010-02-21 17:25:18',NULL,NULL,904,0),(4738023,4738023,6,'soft','2010-02-21 17:31:09',NULL,NULL,904,0),(904,4738023,1,'soft','2010-02-21 17:26:18',NULL,NULL,904,0),(23,4738023,1,'soft','2010-02-21 17:26:53',NULL,NULL,904,0),(21,4738023,1,'soft','2010-02-21 17:27:00',NULL,NULL,904,0),(23,21,1,'soft','2010-02-21 17:27:16',NULL,NULL,904,0),(4738022,4738023,1,'hard','2010-02-21 17:31:35','2010-02-21 12:31:35','000009040473802204738023',904,4738023),(4738025,4738023,1,'soft','2010-02-21 17:31:55',NULL,NULL,904,0),(4738026,4738025,1,'soft','2010-02-21 17:32:08',NULL,NULL,904,0),(4738027,4738026,2,'soft','2010-02-21 17:42:59',NULL,NULL,904,0),(4738028,4738027,1,'soft','2010-02-21 17:43:14',NULL,NULL,904,0),(4738026,4738027,1,'soft','2010-02-21 17:43:23',NULL,NULL,904,0),(4738025,4738028,1,'hard','2010-02-21 17:43:46','2010-02-21 12:43:46','00000101047380230473802504738028',904,4738025),(21842,1,1,'soft','2010-02-21 17:53:38',NULL,NULL,332,0);
+INSERT INTO `neurons` VALUES (19,12,1,'soft','2009-05-26 23:23:58',NULL,NULL,904),(904,19,12,'soft','2010-02-16 22:35:57',NULL,NULL,904),(904,904,32,'soft','2010-02-21 17:25:16',NULL,NULL,904),(0,904,1,'soft','2009-05-26 23:24:13',NULL,NULL,904),(24,904,1,'soft','2009-05-26 23:24:39',NULL,NULL,904),(19,24,4,'soft','2010-02-16 22:36:34',NULL,NULL,904),(102,19,8,'soft','2010-02-21 17:26:27',NULL,NULL,904),(27,23,5,'soft','2010-02-16 22:35:39',NULL,NULL,904),(101,27,1,'soft','2009-05-26 23:25:24',NULL,NULL,904),(102,101,6,'soft','2010-02-16 23:03:33',NULL,NULL,904),(101,102,7,'soft','2010-02-16 22:48:43',NULL,NULL,904),(1,101,4,'soft','2010-02-16 22:48:45',NULL,NULL,904),(1,1,9,'soft','2010-02-21 17:54:58',NULL,NULL,904),(21,27,7,'soft','2010-02-16 18:05:41',NULL,NULL,904),(21,21,4,'soft','2010-02-21 17:27:08',NULL,NULL,904),(0,548,1,'soft','2009-05-27 21:50:29',NULL,NULL,904),(548,548,1,'soft','2009-05-28 11:38:01',NULL,NULL,904),(19,19,16,'soft','2009-05-30 08:49:02',NULL,NULL,904),(1,19,8,'soft','2010-02-21 17:54:57',NULL,NULL,904),(0,1,1,'soft','2009-05-28 14:30:30',NULL,NULL,904),(24,102,1,'soft','2009-05-28 14:30:48',NULL,NULL,904),(23,24,6,'soft','2010-02-16 18:05:38',NULL,NULL,904),(0,23,1,'soft','2009-05-28 14:30:58',NULL,NULL,904),(0,27,3,'soft','2009-05-29 22:40:53',NULL,NULL,904),(15,27,2,'soft','2009-05-30 11:31:30',NULL,NULL,904),(0,15,2,'soft','2009-05-28 14:31:19',NULL,NULL,904),(904,15,1,'soft','2009-05-28 14:31:21',NULL,NULL,904),(19,904,4,'soft','2009-05-28 21:01:54',NULL,NULL,904),(192,192,10,'soft','2009-05-28 19:56:36',NULL,NULL,904),(258,192,1,'soft','2009-05-28 19:56:44',NULL,NULL,904),(258,258,1,'soft','2009-05-28 19:56:49',NULL,NULL,904),(19,258,1,'soft','2009-05-28 19:56:53',NULL,NULL,904),(904,1,1,'soft','2009-05-28 20:37:33',NULL,NULL,904),(548,1,1,'soft','2009-05-28 20:50:49',NULL,NULL,904),(19,1,6,'soft','2010-02-21 17:54:54',NULL,NULL,904),(101,19,3,'soft','2010-02-15 23:58:26',NULL,NULL,904),(0,102,1,'soft','2009-05-28 21:02:19',NULL,NULL,904),(1,102,1,'soft','2009-05-28 21:08:51',NULL,NULL,904),(101,1,4,'soft','2010-02-16 23:03:31',NULL,NULL,904),(683817,102,6,'soft','2010-02-16 23:03:34',NULL,NULL,904),(19,683817,3,'soft','2010-02-15 23:58:19',NULL,NULL,904),(24,19,5,'soft','2010-02-16 18:05:36',NULL,NULL,904),(1522695,23,5,'soft','2009-05-30 14:11:23',NULL,NULL,904),(27,1522695,5,'soft','2009-05-30 14:11:24',NULL,NULL,904),(15,21,5,'soft','2010-02-16 18:05:46',NULL,NULL,904),(788016,15,7,'soft','2010-02-16 18:05:47',NULL,NULL,904),(876611,788016,6,'soft','2010-02-16 18:05:48',NULL,NULL,904),(1058182,788016,6,'soft','2010-02-16 18:05:52',NULL,NULL,904),(25,1058182,7,'soft','2010-02-16 18:05:54',NULL,NULL,904),(904,25,3,'soft','2010-02-16 16:21:57',NULL,NULL,904),(19,1017832,2,'soft','2010-02-16 22:49:47',NULL,NULL,904),(1017832,19,3,'soft','2010-02-16 23:02:52',NULL,NULL,904),(102,24,1,'soft','2009-05-28 21:49:12',NULL,NULL,904),(683817,101,1,'soft','2009-05-28 21:49:16',NULL,NULL,904),(683817,683817,5,'soft','2010-02-16 22:50:12',NULL,NULL,904),(332,683817,2,'soft','2009-05-30 14:34:54',NULL,NULL,904),(332,332,19,'soft','2010-02-16 22:45:11',NULL,NULL,904),(21,332,1,'soft','2009-05-28 21:50:07',NULL,NULL,904),(27,21,4,'soft','2010-02-16 16:22:20',NULL,NULL,904),(1522695,27,3,'soft','2010-02-16 22:49:22',NULL,NULL,904),(15,1522695,2,'soft','2010-02-16 22:35:41',NULL,NULL,904),(1017832,904,2,'soft','2010-02-16 16:22:00',NULL,NULL,904),(63556,1017832,1,'soft','2009-05-28 21:50:48',NULL,NULL,904),(23,27,3,'soft','2010-02-16 22:36:20',NULL,NULL,904),(24,24,2,'soft','2009-05-29 19:52:06',NULL,NULL,332),(1058182,19,3,'soft','2010-02-16 22:49:50',NULL,NULL,332),(27,27,1,'soft','2009-05-29 19:52:27',NULL,NULL,332),(332,102,1,'soft','2009-05-29 19:52:47',NULL,NULL,332),(24,1,1,'soft','2009-05-29 22:56:10',NULL,NULL,332),(21,15,2,'soft','2010-02-16 13:08:19',NULL,NULL,332),(1844482,21,4,'soft','2010-02-16 22:55:22',NULL,NULL,332),(1,25,2,'soft','2010-02-16 22:52:04',NULL,NULL,332),(21,19,2,'soft','2010-02-15 23:58:10',NULL,NULL,904),(1,21,2,'soft','2009-05-30 08:45:52',NULL,NULL,904),(332,25,3,'soft','2010-02-16 22:49:35',NULL,NULL,332),(1,332,1,'soft','2009-05-30 11:31:40',NULL,NULL,332),(1017832,101,1,'soft','2009-05-30 11:31:45',NULL,NULL,332),(332,1017832,1,'soft','2009-05-30 11:31:48',NULL,NULL,332),(101,332,1,'soft','2009-05-30 11:31:58',NULL,NULL,332),(101,101,9,'soft','2010-02-16 22:44:37',NULL,NULL,332),(4738019,101,1,'soft','2009-05-30 11:32:20',NULL,NULL,332),(332,19,1,'soft','2009-05-30 14:00:53',NULL,NULL,332),(102,683817,3,'soft','2010-02-16 22:48:41',NULL,NULL,332),(332,904,3,'bookmark','2009-05-30 14:10:11','2009-05-30 16:10:05',NULL,332),(23,23,2,'soft','2010-02-16 22:36:21',NULL,NULL,332),(1017832,332,2,'soft','2010-02-16 22:49:42',NULL,NULL,332),(683817,1017832,2,'soft','2010-02-16 22:48:20',NULL,NULL,332),(19,332,1,'soft','2009-05-30 14:35:08',NULL,NULL,904),(19,1062076,1,'soft','2010-02-15 23:58:03',NULL,NULL,904),(102,788016,1,'soft','2010-02-15 23:58:15',NULL,NULL,904),(63539,101,1,'soft','2010-02-15 23:58:30',NULL,NULL,904),(25,25,25,'soft','2010-02-17 00:33:53',NULL,NULL,904),(27,25,1,'soft','2010-02-16 13:08:13',NULL,NULL,904),(788016,27,1,'soft','2010-02-16 13:08:16',NULL,NULL,904),(15,788016,1,'soft','2010-02-16 13:08:18',NULL,NULL,904),(1522695,21,1,'soft','2010-02-16 13:08:22',NULL,NULL,904),(21,1522695,1,'soft','2010-02-16 13:08:23',NULL,NULL,904),(25,19,2,'soft','2010-02-16 13:33:43',NULL,NULL,904),(19,25,3,'soft','2010-02-16 22:25:04',NULL,NULL,904),(2115046,1,1,'soft','2010-02-16 16:21:41',NULL,NULL,904),(904,1058182,1,'soft','2010-02-16 16:21:54',NULL,NULL,904),(25,1017832,1,'soft','2010-02-16 16:22:16',NULL,NULL,904),(21,25,1,'soft','2010-02-16 16:22:18',NULL,NULL,904),(24,23,3,'soft','2010-02-16 22:49:28',NULL,NULL,904),(683817,19,2,'soft','2010-02-16 22:35:32',NULL,NULL,904),(1432305,683817,2,'soft','2010-02-16 22:50:04',NULL,NULL,904),(24,683817,1,'soft','2010-02-16 16:23:14',NULL,NULL,904),(1,24,1,'soft','2010-02-16 16:23:16',NULL,NULL,904),(876611,19,1,'soft','2010-02-16 18:05:10',NULL,NULL,904),(2335451,25,1,'soft','2010-02-16 22:25:19',NULL,NULL,904),(1844482,25,1,'soft','2010-02-16 22:25:25',NULL,NULL,904),(25,1,3,'soft','2010-02-16 23:16:39',NULL,NULL,904),(21842,25,2,'soft','2010-02-16 23:03:54',NULL,NULL,904),(904,21842,1,'soft','2010-02-16 22:31:50',NULL,NULL,904),(23,904,1,'soft','2010-02-16 22:32:35',NULL,NULL,904),(19,23,1,'soft','2010-02-16 22:35:30',NULL,NULL,904),(23,1,2,'soft','2010-02-16 23:06:53',NULL,NULL,904),(2527821,27,3,'soft','2010-02-16 22:49:21',NULL,NULL,904),(19,15,1,'soft','2010-02-16 22:35:45',NULL,NULL,904),(1522695,19,2,'soft','2010-02-21 17:24:53',NULL,NULL,904),(27,904,1,'soft','2010-02-16 22:36:18',NULL,NULL,904),(21842,21842,21,'soft','2010-02-21 17:52:44',NULL,NULL,904),(1,21842,3,'hard','2010-02-21 17:52:44','2010-02-21 12:52:44','0000000100021842',332),(1017832,1,2,'soft','2010-02-16 22:40:17',NULL,NULL,332),(102,1017832,1,'soft','2010-02-16 22:43:38',NULL,NULL,332),(31,1,1,'soft','2010-02-16 22:48:50',NULL,NULL,332),(17,1,1,'soft','2010-02-16 22:49:02',NULL,NULL,332),(12,1,1,'soft','2010-02-16 22:49:10',NULL,NULL,332),(27,1,1,'soft','2010-02-16 22:49:20',NULL,NULL,332),(23,1522695,1,'soft','2010-02-16 22:49:24',NULL,NULL,332),(876611,24,1,'soft','2010-02-16 22:49:30',NULL,NULL,332),(25,24,1,'soft','2010-02-16 22:49:34',NULL,NULL,332),(25,21842,1,'soft','2010-02-16 22:52:02',NULL,NULL,332),(3081544,25,2,'soft','2010-02-16 23:16:45',NULL,NULL,332),(1227763,1017832,1,'soft','2010-02-16 23:02:57',NULL,NULL,332),(1,683817,1,'soft','2010-02-16 23:03:38',NULL,NULL,332),(2284387,25,1,'soft','2010-02-16 23:16:46',NULL,NULL,332),(1662468,25,1,'soft','2010-02-16 23:16:48',NULL,NULL,332),(1870248,25,1,'soft','2010-02-16 23:16:49',NULL,NULL,332),(196177,25,1,'soft','2010-02-16 23:16:55',NULL,NULL,332),(2284387,2284387,7,'soft','2010-02-16 23:19:27',NULL,NULL,332),(1,23,1,'soft','2010-02-16 23:18:07',NULL,NULL,332),(3081544,3081544,5,'soft','2010-02-16 23:19:39',NULL,NULL,332),(2527821,1,18,'soft','2010-02-21 17:54:59',NULL,NULL,332),(2527821,19,3,'soft','2010-02-21 17:54:55',NULL,NULL,904),(4738023,904,1,'soft','2010-02-21 17:25:18',NULL,NULL,904),(4738023,4738023,6,'soft','2010-02-21 17:31:09',NULL,NULL,904),(904,4738023,1,'soft','2010-02-21 17:26:18',NULL,NULL,904),(23,4738023,1,'soft','2010-02-21 17:26:53',NULL,NULL,904),(21,4738023,1,'soft','2010-02-21 17:27:00',NULL,NULL,904),(23,21,1,'soft','2010-02-21 17:27:16',NULL,NULL,904),(4738022,4738023,1,'hard','2010-02-21 17:31:35','2010-02-21 12:31:35','000009040473802204738023',904),(4738025,4738023,1,'soft','2010-02-21 17:31:55',NULL,NULL,904),(4738026,4738025,1,'soft','2010-02-21 17:32:08',NULL,NULL,904),(4738027,4738026,2,'soft','2010-02-21 17:42:59',NULL,NULL,904),(4738028,4738027,1,'soft','2010-02-21 17:43:14',NULL,NULL,904),(4738026,4738027,1,'soft','2010-02-21 17:43:23',NULL,NULL,904),(4738025,4738028,1,'hard','2010-02-21 17:43:46','2010-02-21 12:43:46','00000101047380230473802504738028',904),(21842,1,1,'soft','2010-02-21 17:53:38',NULL,NULL,332);
 /*!40000 ALTER TABLE `neurons` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -329,7 +325,7 @@ CREATE TABLE `node_access` (
   UNIQUE KEY `node_access` (`node_id`,`user_id`),
   KEY `user_bookmark` (`user_id`,`node_bookmark`),
   KEY `node_bookmark` (`node_id`,`node_bookmark`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -355,7 +351,7 @@ CREATE TABLE `node_content` (
   `node_content` text NOT NULL,
   UNIQUE KEY `node_id` (`node_id`),
   FULLTEXT KEY `node_content_node_name` (`node_content`,`node_name`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -380,14 +376,12 @@ CREATE TABLE `node_vector` (
   `node_id` int(11) NOT NULL,
   `node_parent` int(11) NOT NULL default '0',
   `node_vector` varchar(400) NOT NULL,
-  `level3` int(11) NOT NULL default '0',
   `is_hl` smallint(6) NOT NULL default '0',
   PRIMARY KEY  (`node_vector_id`),
-  KEY `level3` (`level3`,`node_vector`(255),`is_hl`),
   KEY `node_vector` (`node_vector`(255),`is_hl`),
   KEY `node_parent` (`node_parent`,`is_hl`),
   KEY `node_id` (`node_id`,`is_hl`)
-) ENGINE=InnoDB AUTO_INCREMENT=4514063 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=4514063 DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -396,20 +390,12 @@ SET character_set_client = @saved_cs_client;
 
 LOCK TABLES `node_vector` WRITE;
 /*!40000 ALTER TABLE `node_vector` DISABLE KEYS */;
-INSERT INTO `node_vector` VALUES (1,1,0,'00000001',0,0),(2,2,1,'0000000100000002',0,0),(47,3,1,'0000000100000003',0,0),(1005,4,1,'0000000100000004',0,0),(1011,5,1,'0000000100000005',0,0),(1012,6,1,'0000000100000006',0,0),(1082,8,1,'0000000100000008',0,0),(1083,9,1,'0000000100000009',0,0),(1957,10,1,'0000000100000010',0,0),(1958,11,1,'0000000100000011',0,0),(3643,12,1,'0000000100000012',0,0),(3651,14,1,'0000000100000014',0,0),(3652,15,1,'0000000100000015',0,0),(3658,16,1,'0000000100000016',0,0),(3659,17,1,'0000000100000017',0,0),(3661,18,1,'0000000100000018',0,0),(3662,19,1,'0000000100000019',0,0),(20146,20,1,'0000000100000020',0,0),(20147,22,1,'0000000100000022',0,0),(20185,23,1,'0000000100000023',0,0),(20186,24,1,'0000000100000024',0,0),(20189,25,1,'0000000100000025',0,0),(20191,29,1,'0000000100000029',0,0),(20202,100,1,'0000000100000100',0,0),(20204,102,1,'0000000100000102',0,0),(45341,7,0,'00000007',0,0),(45463,21,0,'00000021',0,0),(162930,27,0,'00000027',0,0),(163052,30,0,'00000030',0,0),(163058,31,0,'00000031',0,0),(163060,32,0,'00000032',0,0),(163065,101,0,'00000101',0,0),(634965,63532,101,'0000010100063532',0,0),(670513,683817,63532,'000001010006353200683817',683817,0),(1088477,332,0,'00000332',0,0),(1094462,548,0,'00000548',0,0),(1103222,904,0,'00000904',0,0),(1619197,788016,0,'00788016',0,0),(1642489,876611,0,'00876611',0,0),(1674186,1058182,0,'01058182',0,0),(2294629,1522695,1478222,'0000010100792011011419590147822201522695',1141959,0),(2728565,63539,101,'0000010100063539',0,0),(2893526,63556,63539,'000001010006353900063556',63556,0),(3135184,1017832,63556,'00000101000635390006355601017832',63556,0),(3847256,3,1058182,'0105818200000003',0,1),(3847257,7,1999688,'00000101007920110199968800000007',1999688,1),(3847258,19,63646,'0000010100063528000635840006364600000019',63584,1),(3847259,19,3766960,'0000010104166671037669470376696000000019',3766947,1),(3847260,21,962161,'0000010100063528000636970096216100000021',63697,1),(3847261,21,962439,'0000010100063528000635510096243900000021',63551,1),(3847262,21,64514,'00000101000635270006451400000021',64514,1),(3847263,21,1197,'0000119700000021',0,1),(3847264,21,965591,'000000210096559100000021',21,1),(3847265,21,667804,'0000010100063537007589480066780400000021',758948,1),(3847266,21,1143346,'000001010006353200063571000641790114334600000021',63571,1),(3847267,21,1070007,'0000010100063532000635710107000700000021',63571,1),(3847268,21,21788,'00000101000217480002178800000021',21788,1),(3847269,21,690922,'0000010100063564000635880069092200000021',63588,1),(3847270,21,1499948,'0149994800000021',0,1),(3847271,21,64393,'00000101000635390006439300000021',64393,1),(3847272,21,63868,'0000010100063537000635680006386800000021',63568,1),(3847273,21,1508656,'00000101000635280150865600000021',1508656,1),(3847274,21,1532090,'0153209000000021',0,1),(3847275,21,65013,'000001030006501300000021',21,1),(3847276,21,1870232,'000000210187023200000021',21,1),(3847277,21,1878809,'001234560187880900000021',21,1),(3847278,21,1665272,'0000144901663286020728670166527200000021',2072867,1),(3847279,21,64106,'0000010100063534000635770006410600000021',63577,1),(3847280,21,1217852,'0000010100063540000635420121785200000021',63542,1),(3847281,21,63682,'0000010100063540000635900006368200000021',63590,1),(3847282,21,912732,'0000010100063536000644480091273200000021',64448,1),(3847283,21,2098795,'000001010006354000063542000638550209879500000021',63542,1),(3847284,21,2626,'0000262600000021',0,1),(3847285,21,64252,'0000010100063539000635560006425200000021',63556,1),(3847286,21,2095367,'0000010100063539000635560209536700000021',63556,1),(3847287,21,2472165,'000001010079201101968274024712450247216500000021',1968274,1),(3847288,21,2202672,'0220267200000021',0,1),(3847289,21,1977992,'0000010100792011028419770197799200000021',2841977,1),(3847290,21,2587666,'0000010100063564000635660258766600000021',63566,1),(3847291,21,2785963,'000000210278596300000021',21,1),(3847292,21,644691,'0064469100000021',0,1),(3847293,21,3044722,'0304472200000021',0,1),(3847294,21,1741456,'0000010100063564000635660174145600000021',63566,1),(3847295,21,2836656,'00000101007920110283665600000021',2836656,1),(3847296,21,2237638,'00000101007920110223763800000021',2237638,1),(3847297,21,1527321,'00000101000635360152732100000021',1527321,1),(3847298,21,2716997,'00000101007920110271699700000021',2716997,1),(3847299,21,3091918,'00000101007920110309191800000021',3091918,1),(3847300,21,2860163,'008090960286016300000021',21,1),(3847301,21,2678826,'00000101000635640267882600000021',2678826,1),(3847302,21,3259183,'00000101007920110325918300000021',3259183,1),(3847303,21,2972154,'0000010100792011033602650297215400000021',3360265,1),(3847304,21,64190,'0000010100063564000635660006419000000021',63566,1),(3847305,21,1291752,'00000101007920110129175200000021',1291752,1),(3847306,21,1295591,'0000010100063564000635660129559100000021',63566,1),(3847307,21,923713,'0000010100063564000635660092371300000021',63566,1),(3847308,21,3105520,'00000101007920110310552000000021',3105520,1),(3847309,21,64348,'0000010100063564000635660006434800000021',63566,1),(3847310,21,2258192,'00000101007920110225819200000021',2258192,1),(3847311,21,3360055,'00000101007920110336005500000021',3360055,1),(3847312,21,2920607,'00000101007920110292060700000021',2920607,1),(3847313,21,64798,'00000101015515750006479800000021',64798,1),(3847314,21,63721,'0000010100063540000635460006372100000021',63546,1),(3847315,21,64506,'00000101000635290006450600000021',64506,1),(3847316,21,2009649,'0000010100063537007589480200964900000021',758948,1),(3847317,21,3861837,'0386183700000021',0,1),(3847318,21,2686250,'0000010100792011025484430268625000000021',2548443,1),(3847319,21,123456,'0012345600000021',0,1),(3847320,21,3966616,'0000010100063564000635660396661600000021',63566,1),(3847321,21,3691334,'00000101007920110369133400000021',3691334,1),(3847322,25,1203863,'0120386300000025',0,1),(3847323,25,3766960,'0000010104166671037669470376696000000025',3766947,1),(3847669,63556,63556,'00000101000635390006355600063556',63556,1),(3847670,63556,5154,'000001430000515400063556',63556,1),(3847671,63556,1197,'0000119700063556',0,1),(3847672,63556,63707,'000635600006370700063556',63556,1),(3847673,63556,1058182,'0105818200063556',0,1),(3852015,683817,1,'0000000100683817',0,1),(3853042,876611,1203863,'0120386300876611',0,1),(3853043,876611,3766960,'0000010104166671037669470376696000876611',3766947,1),(3854396,1017832,1,'0000000101017832',0,1),(3854397,1017832,64514,'00000101000635270006451401017832',64514,1),(3854398,1017832,743506,'00000001000000190074350601017832',743506,1),(3854399,1017832,3403,'000019960000340301017832',1017832,1),(3854400,1017832,2552771,'008020260255144202552728025527620255277101017832',2552728,1),(3950568,33,0,'00000033',0,0),(3988991,21,4126458,'00000101007920110412645800000021',4126458,1),(4187670,21,64915,'00000101013005470006491500000021',64915,1),(4249414,21,1340540,'00000101013005470134054000000021',1340540,1),(4249421,21,63782,'0000010100063537007590160006378200000021',759016,1),(4249422,21,3205556,'0000010100063537007590160320555600000021',759016,1),(4249424,21,63611,'0000010100063537007590160006361100000021',759016,1),(4252680,21,64222,'0006422200000021',0,1),(4444272,21,3470990,'00000101007920110347099000000021',3470990,1),(4514049,4738019,101,'0000010104738019',0,0),(4514050,4738020,101,'0000010104738020',0,0),(4514051,4738021,904,'0000090404738021',0,0),(4514052,4738022,904,'0000090404738022',0,0),(4514053,4738023,101,'0000010104738023',0,0),(4514054,4738023,904,'0000090404738023',0,0),(4514055,4738024,21,'0000002104738024',0,0),(4514056,4738023,4738022,'000009040473802204738023',4738023,1),(4514057,4738025,4738023,'000001010473802304738025',4738025,0),(4514058,4738026,4738025,'00000101047380230473802504738026',4738025,0),(4514059,4738027,4738026,'0000010104738023047380250473802604738027',4738025,0),(4514060,4738028,4738027,'000001010473802304738025047380260473802704738028',4738025,0),(4514061,4738028,4738025,'00000101047380230473802504738028',4738025,1),(4514062,21842,1,'0000000100021842',0,1);
+INSERT INTO `node_vector` VALUES (1,1,0,'00000001',0),(2,2,1,'0000000100000002',0),(47,3,1,'0000000100000003',0),(1005,4,1,'0000000100000004',0),(1011,5,1,'0000000100000005',0),(1012,6,1,'0000000100000006',0),(1082,8,1,'0000000100000008',0),(1083,9,1,'0000000100000009',0),(1957,10,1,'0000000100000010',0),(1958,11,1,'0000000100000011',0),(3643,12,1,'0000000100000012',0),(3651,14,1,'0000000100000014',0),(3652,15,1,'0000000100000015',0),(3658,16,1,'0000000100000016',0),(3659,17,1,'0000000100000017',0),(3661,18,1,'0000000100000018',0),(3662,19,1,'0000000100000019',0),(20146,20,1,'0000000100000020',0),(20147,22,1,'0000000100000022',0),(20185,23,1,'0000000100000023',0),(20186,24,1,'0000000100000024',0),(20189,25,1,'0000000100000025',0),(20191,29,1,'0000000100000029',0),(20202,100,1,'0000000100000100',0),(20204,102,1,'0000000100000102',0),(45341,7,0,'00000007',0),(45463,21,0,'00000021',0),(162930,27,0,'00000027',0),(163052,30,0,'00000030',0),(163058,31,0,'00000031',0),(163060,32,0,'00000032',0),(163065,101,0,'00000101',0),(634965,63532,101,'0000010100063532',0),(670513,683817,63532,'000001010006353200683817',0),(1088477,332,0,'00000332',0),(1094462,548,0,'00000548',0),(1103222,904,0,'00000904',0),(1619197,788016,0,'00788016',0),(1642489,876611,0,'00876611',0),(1674186,1058182,0,'01058182',0),(2294629,1522695,1478222,'0000010100792011011419590147822201522695',0),(2728565,63539,101,'0000010100063539',0),(2893526,63556,63539,'000001010006353900063556',0),(3135184,1017832,63556,'00000101000635390006355601017832',0),(3847256,3,1058182,'0105818200000003',1),(3847257,7,1999688,'00000101007920110199968800000007',1),(3847258,19,63646,'0000010100063528000635840006364600000019',1),(3847259,19,3766960,'0000010104166671037669470376696000000019',1),(3847260,21,962161,'0000010100063528000636970096216100000021',1),(3847261,21,962439,'0000010100063528000635510096243900000021',1),(3847262,21,64514,'00000101000635270006451400000021',1),(3847263,21,1197,'0000119700000021',1),(3847264,21,965591,'000000210096559100000021',1),(3847265,21,667804,'0000010100063537007589480066780400000021',1),(3847266,21,1143346,'000001010006353200063571000641790114334600000021',1),(3847267,21,1070007,'0000010100063532000635710107000700000021',1),(3847268,21,21788,'00000101000217480002178800000021',1),(3847269,21,690922,'0000010100063564000635880069092200000021',1),(3847270,21,1499948,'0149994800000021',1),(3847271,21,64393,'00000101000635390006439300000021',1),(3847272,21,63868,'0000010100063537000635680006386800000021',1),(3847273,21,1508656,'00000101000635280150865600000021',1),(3847274,21,1532090,'0153209000000021',1),(3847275,21,65013,'000001030006501300000021',1),(3847276,21,1870232,'000000210187023200000021',1),(3847277,21,1878809,'001234560187880900000021',1),(3847278,21,1665272,'0000144901663286020728670166527200000021',1),(3847279,21,64106,'0000010100063534000635770006410600000021',1),(3847280,21,1217852,'0000010100063540000635420121785200000021',1),(3847281,21,63682,'0000010100063540000635900006368200000021',1),(3847282,21,912732,'0000010100063536000644480091273200000021',1),(3847283,21,2098795,'000001010006354000063542000638550209879500000021',1),(3847284,21,2626,'0000262600000021',1),(3847285,21,64252,'0000010100063539000635560006425200000021',1),(3847286,21,2095367,'0000010100063539000635560209536700000021',1),(3847287,21,2472165,'000001010079201101968274024712450247216500000021',1),(3847288,21,2202672,'0220267200000021',1),(3847289,21,1977992,'0000010100792011028419770197799200000021',1),(3847290,21,2587666,'0000010100063564000635660258766600000021',1),(3847291,21,2785963,'000000210278596300000021',1),(3847292,21,644691,'0064469100000021',1),(3847293,21,3044722,'0304472200000021',1),(3847294,21,1741456,'0000010100063564000635660174145600000021',1),(3847295,21,2836656,'00000101007920110283665600000021',1),(3847296,21,2237638,'00000101007920110223763800000021',1),(3847297,21,1527321,'00000101000635360152732100000021',1),(3847298,21,2716997,'00000101007920110271699700000021',1),(3847299,21,3091918,'00000101007920110309191800000021',1),(3847300,21,2860163,'008090960286016300000021',1),(3847301,21,2678826,'00000101000635640267882600000021',1),(3847302,21,3259183,'00000101007920110325918300000021',1),(3847303,21,2972154,'0000010100792011033602650297215400000021',1),(3847304,21,64190,'0000010100063564000635660006419000000021',1),(3847305,21,1291752,'00000101007920110129175200000021',1),(3847306,21,1295591,'0000010100063564000635660129559100000021',1),(3847307,21,923713,'0000010100063564000635660092371300000021',1),(3847308,21,3105520,'00000101007920110310552000000021',1),(3847309,21,64348,'0000010100063564000635660006434800000021',1),(3847310,21,2258192,'00000101007920110225819200000021',1),(3847311,21,3360055,'00000101007920110336005500000021',1),(3847312,21,2920607,'00000101007920110292060700000021',1),(3847313,21,64798,'00000101015515750006479800000021',1),(3847314,21,63721,'0000010100063540000635460006372100000021',1),(3847315,21,64506,'00000101000635290006450600000021',1),(3847316,21,2009649,'0000010100063537007589480200964900000021',1),(3847317,21,3861837,'0386183700000021',1),(3847318,21,2686250,'0000010100792011025484430268625000000021',1),(3847319,21,123456,'0012345600000021',1),(3847320,21,3966616,'0000010100063564000635660396661600000021',1),(3847321,21,3691334,'00000101007920110369133400000021',1),(3847322,25,1203863,'0120386300000025',1),(3847323,25,3766960,'0000010104166671037669470376696000000025',1),(3847669,63556,63556,'00000101000635390006355600063556',1),(3847670,63556,5154,'000001430000515400063556',1),(3847671,63556,1197,'0000119700063556',1),(3847672,63556,63707,'000635600006370700063556',1),(3847673,63556,1058182,'0105818200063556',1),(3852015,683817,1,'0000000100683817',1),(3853042,876611,1203863,'0120386300876611',1),(3853043,876611,3766960,'0000010104166671037669470376696000876611',1),(3854396,1017832,1,'0000000101017832',1),(3854397,1017832,64514,'00000101000635270006451401017832',1),(3854398,1017832,743506,'00000001000000190074350601017832',1),(3854399,1017832,3403,'000019960000340301017832',1),(3854400,1017832,2552771,'008020260255144202552728025527620255277101017832',1),(3950568,33,0,'00000033',0),(3988991,21,4126458,'00000101007920110412645800000021',1),(4187670,21,64915,'00000101013005470006491500000021',1),(4249414,21,1340540,'00000101013005470134054000000021',1),(4249421,21,63782,'0000010100063537007590160006378200000021',1),(4249422,21,3205556,'0000010100063537007590160320555600000021',1),(4249424,21,63611,'0000010100063537007590160006361100000021',1),(4252680,21,64222,'0006422200000021',1),(4444272,21,3470990,'00000101007920110347099000000021',1),(4514049,4738019,101,'0000010104738019',0),(4514050,4738020,101,'0000010104738020',0),(4514051,4738021,904,'0000090404738021',0),(4514052,4738022,904,'0000090404738022',0),(4514053,4738023,101,'0000010104738023',0),(4514054,4738023,904,'0000090404738023',0),(4514055,4738024,21,'0000002104738024',0),(4514056,4738023,4738022,'000009040473802204738023',1),(4514057,4738025,4738023,'000001010473802304738025',0),(4514058,4738026,4738025,'00000101047380230473802504738026',0),(4514059,4738027,4738026,'0000010104738023047380250473802604738027',0),(4514060,4738028,4738027,'000001010473802304738025047380260473802704738028',0),(4514061,4738028,4738025,'00000101047380230473802504738028',1),(4514062,21842,1,'0000000100021842',1);
 /*!40000 ALTER TABLE `node_vector` ENABLE KEYS */;
 UNLOCK TABLES;
 
 /*!50003 SET @SAVE_SQL_MODE=@@SQL_MODE*/;
 
-DELIMITER ;;
-/*!50003 SET SESSION SQL_MODE="" */;;
-/*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `tr_node_vector_i` BEFORE INSERT ON `node_vector` FOR EACH ROW begin set new.level3 = case when length(new.node_vector) >= 24 then substring(new.node_vector, 17, 8) end;
-end */;;
-
-/*!50003 SET SESSION SQL_MODE="" */;;
-/*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `tr_node_vector_u` BEFORE UPDATE ON `node_vector` FOR EACH ROW begin set new.level3 = case when length(new.node_vector) >= 24 then substring(new.node_vector, 17, 8) end;  end */;;
-
 DELIMITER ;
 /*!50003 SET SESSION SQL_MODE=@SAVE_SQL_MODE*/;
 
@@ -440,7 +426,7 @@ CREATE TABLE `nodes` (
   `external_link` varchar(123) collate utf8_slovak_ci default NULL,
   `node_vector` varchar(230) collate utf8_slovak_ci default NULL,
   `node_content` text collate utf8_slovak_ci,
-  `node_level3` int(13) NOT NULL default '0',
+  `node_weight` double unsigned default 1,
   `nl2br` tinyint(1) NOT NULL default '1',
   PRIMARY KEY  (`node_id`),
   KEY `node_name` (`node_name`),
@@ -449,8 +435,7 @@ CREATE TABLE `nodes` (
   KEY `node_vector_template_id` (`node_vector`,`template_id`),
   KEY `node_creator_external_link` (`node_creator`,`external_link`),
   KEY `external_link` (`external_link`),
-  KEY `node_parent` (`node_parent`),
-  KEY `node_level3_node_vector` (`node_level3`,`node_vector`)
+  KEY `node_parent` (`node_parent`)
 ) ENGINE=InnoDB AUTO_INCREMENT=4738029 DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci;
 SET character_set_client = @saved_cs_client;
 
@@ -480,7 +465,7 @@ CREATE TABLE `nv_status` (
   PRIMARY KEY  (`node_id`),
   KEY `node_id` (`node_id`,`done`),
   KEY `done` (`done`)
-) ENGINE=InnoDB AUTO_INCREMENT=1522696 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1522696 DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -510,7 +495,7 @@ CREATE TABLE `poll` (
   PRIMARY KEY  (`poll_id`),
   KEY `node_id` (`node_id`),
   KEY `user_id` (`user_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=1052 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=1052 DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -536,7 +521,7 @@ CREATE TABLE `poll_option` (
   `option` varchar(255) NOT NULL,
   PRIMARY KEY  (`poll_option_id`),
   KEY `poll_id` (`poll_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=5041 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=5041 DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -564,7 +549,7 @@ CREATE TABLE `poll_vote` (
   PRIMARY KEY  (`poll_vote_id`),
   UNIQUE KEY `poll_id_user_id` (`poll_id`,`user_id`),
   KEY `user_id` (`user_id`)
-) ENGINE=MyISAM AUTO_INCREMENT=23190 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=23190 DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -589,7 +574,7 @@ CREATE TABLE `registrations` (
   `reg_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `registrators` varchar(230) default NULL,
   PRIMARY KEY  (`user_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -624,7 +609,7 @@ CREATE TABLE `test` (
   KEY `mail_read` (`mail_user`,`mail_to`,`mail_read`),
   KEY `mail_user_id` (`mail_user`,`mail_id`),
   KEY `mail_duplicate_id` (`mail_duplicate_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -663,7 +648,7 @@ CREATE TABLE `tiamat` (
   `template_id` int(11) default NULL,
   `update_performed` timestamp NOT NULL default '0000-00-00 00:00:00',
   `external_link` varchar(123) default NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -750,7 +735,7 @@ CREATE TABLE `users` (
   UNIQUE KEY `ldap_id` (`ldap_id`),
   UNIQUE KEY `session_string` (`session_string`),
   UNIQUE KEY `login` (`login`)
-) ENGINE=InnoDB AUTO_INCREMENT=802 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=802 DEFAULT CHARSET=utf8;
 SET character_set_client = @saved_cs_client;
 
 --
@@ -786,7 +771,7 @@ DROP TABLE IF EXISTS `view_nodes`;
 /*!50001 DROP VIEW IF EXISTS `view_nodes`*/;
 /*!50001 CREATE ALGORITHM=UNDEFINED */
 /*!50013 DEFINER=`kyberia`@`%` SQL SECURITY DEFINER */
-/*!50001 VIEW `view_nodes` AS select `n`.`node_id` AS `node_id`,date_format(`n`.`node_created`,_latin1'%Y%m%d') AS `node_created`,date_format(`n`.`node_updated`,_latin1'%Y%m%d') AS `node_updated`,`n`.`node_creator` AS `node_creator`,if((`n`.`node_system_access` = _utf8'private'),_utf8'',`n`.`node_name`) AS `node_name`,if((`n`.`node_system_access` = _utf8'private'),_utf8'',`n`.`node_content`) AS `node_content` from `nodes` `n` */;
+/*!50001 VIEW `view_nodes` AS select `n`.`node_id` AS `node_id`,date_format(`n`.`node_created`,_utf8'%Y%m%d') AS `node_created`,date_format(`n`.`node_updated`,_utf8'%Y%m%d') AS `node_updated`,`n`.`node_creator` AS `node_creator`,if((`n`.`node_system_access` = _utf8'private'),_utf8'',`n`.`node_name`) AS `node_name`,if((`n`.`node_system_access` = _utf8'private'),_utf8'',`n`.`node_content`) AS `node_content` from `nodes` `n` */;
 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
https://github.com/Kyberia/Kyberia-bloodline.git (mirrored @ Tue, 18 Jun 2024 09:40:10 +0200)
This page took 0.882691 seconds and 4 git commands to generate.