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.
9 -- Host: localhost Database: kyberia2
10 -- ------------------------------------------------------
11 -- Server version 4.1.10-log
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' */;
22 -- Table structure for table `logs`
25 DROP TABLE IF EXISTS `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
;
37 -- Table structure for table `mail`
40 DROP TABLE IF EXISTS `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',
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
;
62 -- Table structure for table `neurons`
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
;
81 -- Table structure for table `node_access`
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
;
102 -- Table structure for table `node_content`
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
;
114 -- Table structure for table `nodes`
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
;
149 -- Table structure for table `tiamat`
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,
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
;
176 -- Table structure for table `users`
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
;
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 */;