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