3 #
Host: localhost
Database: kyberia
4 #
--------------------------------------------------------
5 #
Server version 3.23.47
8 #
Table structure for table 'admin'
11 action_id
int(11) NOT NULL auto_increment
,
12 action_name
varchar(23) DEFAULT '' NOT NULL,
13 action_parameter
int(11) DEFAULT '0' NOT NULL,
14 action_timestamp datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
15 action_status
enum('opened','resolved','stopped','veto','referendum') DEFAULT 'opened',
16 action_result
varchar(23),
18 admin_id
int(11) DEFAULT '0' NOT NULL,
20 PRIMARY KEY (action_id
)
24 #
Table structure for table 'admin_logs'
26 CREATE TABLE admin_logs (
27 action_id
int(11) NOT NULL auto_increment
,
28 action_name
varchar(23) DEFAULT '' NOT NULL,
29 action_parameter
int(11) DEFAULT '0' NOT NULL,
30 action_timestamp datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
31 action_status
enum('opened','resolved','stopped','veto','referendum') DEFAULT 'opened',
32 action_result
varchar(23),
34 admin_id
int(11) DEFAULT '0' NOT NULL,
36 PRIMARY KEY (action_id
)
40 #
Table structure for table 'albums'
43 id_album
int(11) NOT NULL auto_increment
,
50 PRIMARY KEY (id_album
)
54 #
Table structure for table 'articles'
56 CREATE TABLE articles (
57 id_article
int(11) NOT NULL auto_increment
,
58 id_rubrika
int(11) DEFAULT '0' NOT NULL,
63 id_rubrika_secondary
int(11),
64 title_image
varchar(100),
65 on_main
enum('yes','no') DEFAULT 'no',
78 PRIMARY KEY (id_article
)
82 #
Table structure for table 'category'
84 CREATE TABLE category (
85 category_id
int(11) NOT NULL auto_increment
,
86 category_name
char(255),
87 category_owner
int(11) DEFAULT '1',
88 category_forums
int(11) DEFAULT '0',
89 category_parent
int(11),
90 category_subcats
int(11) DEFAULT '0',
91 category_tree
char(23) DEFAULT '' NOT NULL,
92 PRIMARY KEY (category_id
)
96 #
Table structure for table 'dennik'
99 id int(4) NOT NULL auto_increment
,
104 id_diskuse
int(11) DEFAULT '0',
105 hits
int(11) DEFAULT '0',
106 prispevky
int(11) DEFAULT '0',
107 dennik_type
enum('journaux','report','story','dream','poetry','portugal') DEFAULT 'journaux',
108 type enum('private','public','kyberia') DEFAULT 'public',
111 KEY id_diskuse (id_diskuse
)
115 #
Table structure for table 'diskuse'
117 CREATE TABLE diskuse (
118 id_diskuse
int(11) NOT NULL auto_increment
,
119 kat
varchar(64) DEFAULT '' NOT NULL,
120 pocet_prispevku
int(11) DEFAULT '0' NOT NULL,
121 zalozeno datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
122 titulek
varchar(255),
123 PRIMARY KEY (id_diskuse
),
124 KEY idx_pocet_prispevku (pocet_prispevku
)
128 #
Table structure for table 'forum'
131 forum_id
int(11) NOT NULL auto_increment
,
132 forum_name
varchar(255),
133 forum_type
enum('flat','threaded') DEFAULT 'flat',
134 forum_owner
int(11) DEFAULT '38',
135 forum_submissions
int(11) DEFAULT '0',
136 forum_public
enum('private','public') DEFAULT 'public',
137 forum_co
enum('yes','no') DEFAULT 'no',
138 forum_category
int(11),
140 PRIMARY KEY (forum_id
)
144 #
Table structure for table 'forum_info'
146 CREATE TABLE forum_info (
147 forum_id
int(11) DEFAULT '0' NOT NULL,
149 PRIMARY KEY (forum_id
)
153 #
Table structure for table 'friends'
155 CREATE TABLE friends (
156 user_id
int(11) DEFAULT '0' NOT NULL,
157 friend_id
int(11) DEFAULT '0' NOT NULL,
162 #
Table structure for table 'guild'
165 guild_id
int(11) NOT NULL auto_increment
,
166 guild_name
char(200) DEFAULT '' NOT NULL,
167 PRIMARY KEY (guild_id
)
171 #
Table structure for table 'intros'
173 CREATE TABLE intros (
174 id_intro
int(11) NOT NULL auto_increment
,
178 PRIMARY KEY (id_intro
)
182 #
Table structure for table 'k_logs'
184 CREATE TABLE k_logs (
185 donor_id
int(11) DEFAULT '0' NOT NULL,
186 acceptor_id
int(11) DEFAULT '0' NOT NULL,
189 node_type
enum('dennik','submission'),
190 timestamp timestamp(14)
194 #
Table structure for table 'kbs_category'
196 CREATE TABLE kbs_category (
197 category_id
int(11) NOT NULL auto_increment
,
198 category_name
char(255),
199 category_parent
int(11),
200 category_tree
char(23),
201 PRIMARY KEY (category_id
)
205 #
Table structure for table 'kbs_items_get'
207 CREATE TABLE kbs_items_get (
208 item_id
int(11) NOT NULL auto_increment
,
212 type set('get','buy','exchange'),
214 location varchar(123),
215 PRIMARY KEY (item_id
)
219 #
Table structure for table 'kbs_items_give'
221 CREATE TABLE kbs_items_give (
222 item_id
int(11) NOT NULL auto_increment
,
226 type set('give','sell','exchange','auction'),
230 location varchar(123),
231 PRIMARY KEY (item_id
)
235 #
Table structure for table 'last_submissions'
237 CREATE TABLE last_submissions (
239 submission_owner
int(11) DEFAULT '0' NOT NULL,
240 submission_text
text DEFAULT '' NOT NULL,
241 submission_timestamp
timestamp(14),
242 submission_thread
varchar(60) DEFAULT '' NOT NULL,
243 submission_id
int(11) DEFAULT '0' NOT NULL,
244 PRIMARY KEY (submission_id
),
245 UNIQUE submission_index (submission_id
,forum_id
,submission_owner
),
246 KEY submission_owner (submission_owner
)
250 #
Table structure for table 'links'
253 link_id
int(11) NOT NULL auto_increment
,
255 link_submission
int(11) DEFAULT '0' NOT NULL,
256 link_owner
int(11) DEFAULT '0' NOT NULL,
257 link_forum
int(11) DEFAULT '0' NOT NULL,
258 PRIMARY KEY (link_id
)
262 #
Table structure for table 'mail'
265 mail_id
int(11) NOT NULL auto_increment
,
266 mail_from
int(11) DEFAULT '0' NOT NULL,
267 mail_to
int(11) DEFAULT '0' NOT NULL,
269 mail_timestamp datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
270 mail_no
int(11) DEFAULT '0',
271 mail_to_name
varchar(20),
272 PRIMARY KEY (mail_id
),
273 UNIQUE mail_order (mail_id
,mail_no
,mail_to
,mail_from
),
274 KEY mail_from (mail_from
),
275 KEY mail_to (mail_to
),
276 KEY mail (mail_from
,mail_to
)
280 #
Table structure for table 'mail2'
283 mail_id
int(11) NOT NULL auto_increment
,
284 mail_user
int(11) DEFAULT '0' NOT NULL,
285 mail_from
int(11) DEFAULT '0' NOT NULL,
286 mail_to
int(11) DEFAULT '0' NOT NULL,
288 mail_timestamp datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
289 PRIMARY KEY (mail_id
),
290 KEY mail_user (mail_user
,mail_id
),
291 KEY mail1 (mail_user
,mail_to
),
292 KEY mail_to (mail_to
),
293 KEY mail_from (mail_from
)
297 #
Table structure for table 'mail_from'
299 CREATE TABLE mail_from (
300 mail_id
int(11) NOT NULL auto_increment
,
301 mail_from
int(11) DEFAULT '0' NOT NULL,
302 mail_to
int(11) DEFAULT '0' NOT NULL,
304 mail_timestamp datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
305 PRIMARY KEY (mail_id
),
306 UNIQUE mail_order (mail_id
,mail_to
,mail_from
),
307 KEY mail_from (mail_from
),
308 KEY mail_to (mail_to
),
309 KEY mail (mail_from
,mail_to
)
313 #
Table structure for table 'mail_to'
315 CREATE TABLE mail_to (
316 mail_id
int(11) NOT NULL auto_increment
,
317 mail_from
int(11) DEFAULT '0' NOT NULL,
318 mail_to
int(11) DEFAULT '0' NOT NULL,
320 mail_timestamp datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
321 PRIMARY KEY (mail_id
),
322 UNIQUE mail_order (mail_id
,mail_to
,mail_from
),
323 KEY mail_from (mail_from
),
324 KEY mail_to (mail_to
),
325 KEY mail (mail_from
,mail_to
)
329 #
Table structure for table 'mailinfo'
331 CREATE TABLE mailinfo (
334 active
enum('yes','no')
338 #
Table structure for table 'mmm_articles'
340 CREATE TABLE mmm_articles (
341 id_article
int(11) NOT NULL auto_increment
,
342 id_rubrika
int(11) DEFAULT '0' NOT NULL,
347 id_rubrika_secondary
int(11),
348 title_image
varchar(100),
349 on_main
enum('yes','no') DEFAULT 'no',
359 PRIMARY KEY (id_article
)
363 #
Table structure for table 'node_access'
365 CREATE TABLE node_access (
366 node_type
enum('forum','journaux') DEFAULT 'forum' NOT NULL,
367 node_id
int(11) DEFAULT '0' NOT NULL,
368 user_id
int(11) DEFAULT '0' NOT NULL,
369 access_type
enum('master','op','access','ban') DEFAULT 'access' NOT NULL,
370 UNIQUE access (node_type
,user_id
,node_id
)
374 #
Table structure for table 'outro'
377 id_outro
int(11) NOT NULL auto_increment
,
380 PRIMARY KEY (id_outro
)
384 #
Table structure for table 'personalize'
386 CREATE TABLE personalize (
387 mail
varchar(100) DEFAULT '' NOT NULL,
388 java
enum('yes','no') DEFAULT 'no',
389 flash
enum('yes','no') DEFAULT 'no',
390 wired
enum('yes','no') DEFAULT 'no',
391 shadowbox
enum('yes','no') DEFAULT 'no',
392 zion
enum('yes','no') DEFAULT 'no',
393 sound
enum('yes','no') DEFAULT 'no',
394 article_count
int(4) DEFAULT '15',
397 partylist
enum('yes','no') DEFAULT 'no',
398 underground
enum('yes','no') DEFAULT 'no',
399 mailinfo
varchar(50) DEFAULT 'no',
404 #
Table structure for table 'poll_options'
406 CREATE TABLE poll_options (
407 id_option
int(11) NOT NULL auto_increment
,
411 PRIMARY KEY (id_option
),
412 KEY id_poll (id_poll
)
416 #
Table structure for table 'polls'
419 id_poll
int(11) NOT NULL auto_increment
,
421 question
varchar(255),
422 responses
int(11) DEFAULT '0' NOT NULL,
424 PRIMARY KEY (id_poll
),
425 KEY id_poll (id_poll
),
426 KEY forum_id (forum_id
)
430 #
Table structure for table 'prispevky'
432 CREATE TABLE prispevky (
433 id_prispevku
int(11) NOT NULL auto_increment
,
434 id_diskuse
int(11) DEFAULT '0' NOT NULL,
435 vlozeno datetime
DEFAULT '0000-00-00 00:00:00' NOT NULL,
436 jmeno
varchar(255) DEFAULT '' NOT NULL,
437 email
varchar(255) DEFAULT '' NOT NULL,
438 email_upozorneni
enum('ne','ano') DEFAULT 'ne' NOT NULL,
439 www
varchar(255) DEFAULT '' NOT NULL,
440 titulek
varchar(255) DEFAULT '' NOT NULL,
441 telo
text DEFAULT '' NOT NULL,
442 thread
varchar(255) DEFAULT '' NOT NULL,
443 znamka
tinyint(4) DEFAULT '0' NOT NULL,
444 duplicita
varchar(32) DEFAULT '' NOT NULL,
445 PRIMARY KEY (id_prispevku
)
449 #
Table structure for table 'referers'
451 CREATE TABLE referers (
452 referer
varchar(255),
459 #
Table structure for table 'rss_items'
461 CREATE TABLE rss_items (
462 id int(11) NOT NULL auto_increment
,
467 active
enum('yes','no') DEFAULT 'yes',
468 datetime
timestamp(14),
470 imagelink
varchar(255),
471 imagetitle
varchar(255),
472 imageurl
varchar(255),
477 #
Table structure for table 'rss_news'
479 CREATE TABLE rss_news (
480 news_id
int(8) NOT NULL auto_increment
,
481 news_desc
varchar(255),
482 news_title
varchar(200),
483 news_url
varchar(200),
484 news_image
varchar(200),
485 news_md5
varchar(25) DEFAULT '' NOT NULL,
486 news_image_link
varchar(25) DEFAULT '' NOT NULL,
487 news_image_title
varchar(25) DEFAULT '' NOT NULL,
488 news_source
int(11) DEFAULT '0' NOT NULL,
489 PRIMARY KEY (news_id
)
493 #
Table structure for table 'rss_sources'
495 CREATE TABLE rss_sources (
496 rss_id
int(8) NOT NULL auto_increment
,
497 rss_source
varchar(200),
498 rss_title
varchar(200),
499 rss_url
varchar(200),
500 rss_image
varchar(200),
501 rss_hash
varchar(32) DEFAULT '' NOT NULL,
506 #
Table structure for table 'rubriky'
508 CREATE TABLE rubriky (
509 id_rubriky
int(11) NOT NULL auto_increment
,
512 obrazok
varchar(100),
515 PRIMARY KEY (id_rubriky
)
519 #
Table structure for table 'session'
521 CREATE TABLE session (
523 user_name
varchar(30),
524 user_action
varchar(20),
525 user_action_id
int(11),
526 user_action_name
varchar(30),
527 user_id
int(11) DEFAULT '0' NOT NULL,
528 user_idle
timestamp(14),
529 user_mode
enum('normal','depresia','stastie','LASKA','vykaleny','nasrany','invisible') DEFAULT 'normal',
530 user_amount
int(9) DEFAULT '23' NOT NULL,
531 user_mode_message
varchar(200) DEFAULT '' NOT NULL,
532 admin enum('yes','no') DEFAULT 'no',
533 UNIQUE user_id (user_id
)
537 #
Table structure for table 'submissions'
539 CREATE TABLE submissions (
541 submission_owner
int(11) DEFAULT '0' NOT NULL,
542 submission_text
text DEFAULT '' NOT NULL,
543 submission_timestamp datetime
,
544 submission_thread
varchar(60) DEFAULT '' NOT NULL,
545 submission_id
int(11) NOT NULL auto_increment
,
546 submission_k
int(8) DEFAULT '0' NOT NULL,
547 PRIMARY KEY (submission_id
),
548 UNIQUE submission_index (submission_id
,forum_id
,submission_owner
),
549 KEY submission_owner (submission_owner
),
550 KEY lala (forum_id
,submission_owner
),
551 KEY lalala (forum_id
,submission_owner
,submission_id
),
552 KEY submission_timestamp (submission_timestamp
),
557 #
Table structure for table 'user'
560 id int(3) NOT NULL auto_increment
,
563 password varchar(128),
564 last_login
timestamp(14),
565 user_action
varchar(20),
566 user_mode
enum('off','normal','happy','depka','nasracky','neviditelny') DEFAULT 'off',
567 user_action_param_name
varchar(50),
568 user_action_param_value
varchar(50),
569 user_action_param_id
int(11),
570 user_ad
enum('yes','no') DEFAULT 'yes',
572 user_registered
timestamp(14),
573 user_mail
int(3) DEFAULT '0',
574 user_icq
varchar(20) DEFAULT '' NOT NULL,
575 user_www
varchar(100),
576 user_active
enum('yes','no','waiting'),
577 mail_name
varchar(23),
578 charisma
int(11) DEFAULT '0' NOT NULL,
579 user_amount
int(11) DEFAULT '23',
580 user_happy
varchar(200) DEFAULT '' NOT NULL,
581 user_sad
varchar(200) DEFAULT '' NOT NULL,
582 user_love
varchar(200) DEFAULT '' NOT NULL,
583 user_agressive
varchar(200) DEFAULT '' NOT NULL,
584 user_drugged
varchar(200) DEFAULT '' NOT NULL,
585 user_k
int(11) DEFAULT '0' NOT NULL,
586 user_karma
int(11) DEFAULT '0' NOT NULL,
587 admin enum('yes','no') DEFAULT 'no',
593 #
Table structure for table 'user_discussion'
595 CREATE TABLE user_discussion (
597 discussion_id
int(11),
598 submission_count
int(11),
600 KEY user_id (user_id
),
601 KEY discussion_id (discussion_id
)
605 #
Table structure for table 'user_forum'
607 CREATE TABLE user_forum (
608 user_id
int(11) DEFAULT '0' NOT NULL,
609 forum_id
int(11) DEFAULT '0' NOT NULL,
610 submission_count
int(11) DEFAULT '0',
611 last_visit datetime
DEFAULT '0000-00-00 00:00:00',
612 user_bookmark
enum('yes','no') DEFAULT 'no',
613 UNIQUE user_forum (user_id
,forum_id
),
614 KEY booked_users (forum_id
,user_bookmark
)
618 #
Table structure for table 'user_ip'
620 CREATE TABLE user_ip (
623 datetime
timestamp(14)
627 #
Table structure for table 'user_poll'
629 CREATE TABLE user_poll (
630 user_id
int(11) DEFAULT '0' NOT NULL,
631 poll_id
int(11) DEFAULT '0' NOT NULL