sql/kyber2.sql

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