Commit | Line | Data |
---|---|---|
e586807d H |
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 |