kyber2.sql

   1 -- This program is free software. It comes without any warranty, to
   2 -- the extent permitted by applicable law. You can redistribute it
   3 -- and/or modify it under the terms of the Do What The Fuck You Want
   4 -- To Public License, Version 2, as published by Sam Hocevar. See
   5 -- http://sam.zoy.org/wtfpl/COPYING for more details.
   6
   7 -- MySQL dump 10.9
   8 --
   9 -- Host: localhost    Database: kyberia2
  10 -- ------------------------------------------------------
  11 -- Server version       4.1.10-log
  12
  13 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16 /*!40101 SET NAMES utf8 */;
  17 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  18 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  19 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  20
  21 --
  22 -- Table structure for table `logs`
  23 --
  24
  25 DROP TABLE IF EXISTS `logs`;
  26 CREATE TABLE `logs` (
  27   `node_id` int(11) default NULL,
  28   `user_id` int(11) default NULL,
  29   `event` varchar(23) default NULL,
  30   `parameter1` varchar(23) default NULL,
  31   `parameter2` varchar(23) default NULL,
  32   `result` varchar(10) default NULL,
  33   `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
  34 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  35
  36 --
  37 -- Table structure for table `mail`
  38 --
  39
  40 DROP TABLE IF EXISTS `mail`;
  41 CREATE TABLE `mail` (
  42   `mail_id` int(11) NOT NULL auto_increment,
  43   `mail_user` int(11) NOT NULL default '0',
  44   `mail_from` int(11) NOT NULL default '0',
  45   `mail_to` int(11) NOT NULL default '0',
  46   `mail_text` text,
  47   `mail_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  48   `mail_read` enum('yes','no') default 'no',
  49   `mail_duplicate_id` int(11) default NULL,
  50   `mail_user_new` enum('yes','no') default NULL,
  51   `mail_from_new` enum('yes','no') default NULL,
  52   `mail_to_new` enum('yes','no') default NULL,
  53   KEY `mf` (`mail_from`,`mail_from_new`),
  54   KEY `mt` (`mail_to`,`mail_to_new`),
  55   KEY `mail_id` (`mail_id`),
  56   KEY `mail` (`mail_user`,`mail_timestamp`),
  57   KEY `mail_read` (`mail_user`,`mail_to`,`mail_read`),
  58   KEY `mail_user_id` (`mail_user`,`mail_id`)
  59 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  60
  61 --
  62 -- Table structure for table `neurons`
  63 --
  64
  65 DROP TABLE IF EXISTS `neurons`;
  66 CREATE TABLE `neurons` (
  67   `dst` int(11) default NULL,
  68   `src` int(11) default NULL,
  69   `synapse` int(11) NOT NULL default '0',
  70   `link` enum('hard','soft','bookmark') default 'soft',
  71   `last_impulse` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  72   `synapse_created` datetime default NULL,
  73   `dst_vector` char(232) default NULL,
  74   `synapse_creator` int(11) NOT NULL default '0',
  75   UNIQUE KEY `relation` (`dst`,`src`),
  76   KEY `central_link` (`dst`,`link`),
  77   KEY `dst_vector` (`dst_vector`)
  78 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  79
  80 --
  81 -- Table structure for table `node_access`
  82 --
  83
  84 DROP TABLE IF EXISTS `node_access`;
  85 CREATE TABLE `node_access` (
  86   `node_id` int(13) NOT NULL default '0',
  87   `user_id` int(13) NOT NULL default '0',
  88   `node_bookmark` enum('yes','no') default 'no',
  89   `node_permission` enum('master','op','access','silence','ban','execute') default NULL,
  90   `node_user_subchild_count` int(13) default NULL,
  91   `last_visit` datetime default NULL,
  92   `visits` int(6) default '0',
  93   `bookmark_category` int(11) default NULL,
  94   `given_k` enum('yes','no') default 'no',
  95   UNIQUE KEY `node_access` (`node_id`,`user_id`),
  96   KEY `user_bookmark` (`user_id`,`node_bookmark`),
  97   KEY `node_bookmark` (`node_id`,`node_bookmark`),
  98   KEY `node_user` (`node_id`,`user_id`)
  99 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 100
 101 --
 102 -- Table structure for table `node_content`
 103 --
 104
 105 DROP TABLE IF EXISTS `node_content`;
 106 CREATE TABLE `node_content` (
 107   `node_id` int(13) NOT NULL default '0',
 108   `node_content` mediumtext,
 109   UNIQUE KEY `id` (`node_id`),
 110   FULLTEXT KEY `node_content` (`node_content`)
 111 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 112
 113 --
 114 -- Table structure for table `nodes`
 115 --
 116
 117 DROP TABLE IF EXISTS `nodes`;
 118 CREATE TABLE `nodes` (
 119   `node_id` int(13) NOT NULL auto_increment,
 120   `node_name` varchar(132) default NULL,
 121   `node_parent` int(13) NOT NULL default '0',
 122   `node_type` int(2) default '1',
 123   `node_external_access` enum('yes','no') default 'no',
 124   `node_system_access` enum('public','moderated','private','cube','crypto') default 'public',
 125   `node_children_count` int(11) default '0',
 126   `node_creator` int(13) default NULL,
 127   `node_created` datetime default NULL,
 128   `lastchild_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 129   `k` int(5) default '0',
 130   `node_views` int(8) default NULL,
 131   `node_descendant_count` int(11) default NULL,
 132   `lastdescendant_created` datetime default NULL,
 133   `template_id` int(11) default NULL,
 134   `node_updated` datetime default NULL,
 135   `external_link` varchar(123) default NULL,
 136   `node_vector` varchar(230) default NULL,
 137   PRIMARY KEY  (`node_id`),
 138   KEY `node_name` (`node_name`),
 139   KEY `type_id` (`node_type`,`node_id`),
 140   KEY `created_vector_k` (`node_created`,`node_vector`,`k`),
 141   KEY `vector` (`node_vector`),
 142   KEY `template_id` (`template_id`,`node_creator`),
 143   KEY `vector_templateid` (`node_vector`,`template_id`),
 144   KEY `creator_external_link` (`node_creator`,`external_link`),
 145   KEY `parent` (`node_parent`)
 146 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 147
 148 --
 149 -- Table structure for table `tiamat`
 150 --
 151
 152 DROP TABLE IF EXISTS `tiamat`;
 153 CREATE TABLE `tiamat` (
 154   `node_id` int(13) NOT NULL default '0',
 155   `node_name` varchar(132) default NULL,
 156   `node_parent` int(13) NOT NULL default '0',
 157   `node_vector` varchar(232) default NULL,
 158   `node_external_access` enum('yes','no') default 'no',
 159   `node_system_access` enum('public','moderated','private','personal','crypto') default 'public',
 160   `node_children_count` int(11) default '0',
 161   `node_creator` int(13) default NULL,
 162   `node_created` datetime default NULL,
 163   `lastchild_created` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 164   `k` int(5) default '0',
 165   `node_views` int(8) default NULL,
 166   `node_destructor` int(11) default NULL,
 167   `node_content` text,
 168   `node_descendant_count` int(11) default NULL,
 169   `lastdescendant_created` datetime default NULL,
 170   `template_id` int(11) default NULL,
 171   `update_performed` timestamp NOT NULL default '0000-00-00 00:00:00',
 172   `external_link` varchar(123) default NULL
 173 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 174
 175 --
 176 -- Table structure for table `users`
 177 --
 178
 179 DROP TABLE IF EXISTS `users`;
 180 CREATE TABLE `users` (
 181   `user_id` int(13) NOT NULL default '0',
 182   `login` char(66) default NULL,
 183   `password` char(32) default NULL,
 184   `icq` char(10) default NULL,
 185   `email` char(50) default NULL,
 186   `last_action` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 187   `user_action` char(75) default NULL,
 188   `www` char(50) default NULL,
 189   `user_mail` int(11) default NULL,
 190   `user_mail_name` char(40) default NULL,
 191   `listing_amount` int(8) default '32',
 192   `session_string` char(64) default NULL,
 193   `user_action_id` int(11) default NULL,
 194   `user_k` tinyint(4) default '23',
 195   `user_location_vector` char(123) default NULL,
 196   `ldap_id` int(11) NOT NULL auto_increment,
 197   `listing_order` enum('asc','desc') default 'desc',
 198   `header_id` int(11) default NULL,
 199   `cube_vector` char(23) default NULL,
 200   `k_wallet` int(8) default '0',
 201   PRIMARY KEY  (`user_id`),
 202   UNIQUE KEY `ldap_id` (`ldap_id`),
 203   UNIQUE KEY `session_string` (`session_string`),
 204   UNIQUE KEY `login` (`login`),
 205   KEY `user_action_id` (`user_action_id`)
 206 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 207
 208 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 209 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 210 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 211 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 212 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 213 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 214