PC World 2005 April/PCWorld_2005-04_cd.bin/akce/web/unitednuke/unitednuke.exe/sql/united-nuke_czech.sql

Text File | 2004-01-14 | 115KB | 3,179 lines

# --------------------------------------------------------

#
# Struktura tabulky `nuke_actual`
#

CREATE TABLE `nuke_actual` (
  `id` int(11) NOT NULL auto_increment,
  `text` mediumtext,
  `link` varchar(255) default NULL,
  `date` int(11) default NULL,
  `admin` smallint(6) default NULL,
  `status` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_actual`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_actual_config`
#

CREATE TABLE `nuke_actual_config` (
  `allow_add_users` tinyint(1) NOT NULL default '0',
  `allow_HTML` tinyint(1) NOT NULL default '0',
  `allow_down` tinyint(1) NOT NULL default '1',
  `js_jump_menu` tinyint(1) NOT NULL default '1',
  `allow_direct_comit` tinyint(1) NOT NULL default '1',
  `show_flash_news` tinyint(1) NOT NULL default '1',
  `delete_advance` tinyint(1) NOT NULL default '1',
  `max_all` int(3) NOT NULL default '150',
  `maxlimit_norm` tinyint(2) NOT NULL default '5',
  `maxlimit_admin` tinyint(2) NOT NULL default '10',
  `maxlimit_down` tinyint(1) NOT NULL default '3',
  `separator` varchar(255) NOT NULL default '',
  `separator_not` varchar(255) NOT NULL default '',
  `separator_adm` varchar(255) NOT NULL default '',
  `allow_mail` tinyint(1) NOT NULL default '0',
  `mail` varchar(255) NOT NULL default '',
  `reply_mail` varchar(255) NOT NULL default '',
  `subject_text` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_actual_config`
#

INSERT INTO `nuke_actual_config` VALUES (0, 0, 1, 1, 1, 1, 1, 150, 5, 10, 3, '<font><b>.:</b></font>', '<font color="red"><b>X</b></font>', '<font color="red"><b>0</b></font>', 0, '[e-mail]', '[e-mail]', 'Novß aktualita na serveru');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_authors`
#

CREATE TABLE `nuke_authors` (
  `aid` varchar(25) NOT NULL default '',
  `name` varchar(50) default NULL,
  `url` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `pwd` varchar(40) default NULL,
  `counter` int(11) NOT NULL default '0',
  `radminarticle` tinyint(2) NOT NULL default '0',
  `radmintopic` tinyint(2) NOT NULL default '0',
  `radminuser` tinyint(2) NOT NULL default '0',
  `radminsurvey` tinyint(2) NOT NULL default '0',
  `radminsection` tinyint(2) NOT NULL default '0',
  `radminlink` tinyint(2) NOT NULL default '0',
  `radminephem` tinyint(2) NOT NULL default '0',
  `radminfaq` tinyint(2) NOT NULL default '0',
  `radmindownload` tinyint(2) NOT NULL default '0',
  `radminreviews` tinyint(2) NOT NULL default '0',
  `radminnewsletter` tinyint(2) NOT NULL default '0',
  `radminforum` tinyint(2) NOT NULL default '0',
  `radmincontent` tinyint(2) NOT NULL default '0',
  `radminency` tinyint(2) NOT NULL default '0',
  `radminsuper` tinyint(2) NOT NULL default '1',
  `admlanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`aid`),
  KEY `aid` (`aid`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_authors`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_autonews`
#

CREATE TABLE `nuke_autonews` (
  `anid` int(11) NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `aid` varchar(30) NOT NULL default '',
  `title` varchar(80) NOT NULL default '',
  `time` varchar(19) NOT NULL default '',
  `hometext` text NOT NULL,
  `bodytext` text NOT NULL,
  `topic` int(3) NOT NULL default '1',
  `informant` varchar(20) NOT NULL default '',
  `notes` text NOT NULL,
  `ihome` int(1) NOT NULL default '0',
  `alanguage` varchar(30) NOT NULL default '',
  `acomm` int(1) NOT NULL default '0',
  `associated` text NOT NULL,
  PRIMARY KEY  (`anid`),
  KEY `anid` (`anid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_autonews`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_banner`
#

CREATE TABLE `nuke_banner` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `imptotal` int(11) NOT NULL default '0',
  `impmade` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `imageurl` varchar(100) NOT NULL default '',
  `clickurl` varchar(200) NOT NULL default '',
  `alttext` varchar(255) NOT NULL default '',
  `date` datetime default NULL,
  `dateend` datetime default NULL,
  `type` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`bid`),
  KEY `bid` (`bid`),
  KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_banner`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bannerclient`
#

CREATE TABLE `nuke_bannerclient` (
  `cid` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `contact` varchar(60) NOT NULL default '',
  `email` varchar(60) NOT NULL default '',
  `login` varchar(10) NOT NULL default '',
  `passwd` varchar(10) NOT NULL default '',
  `extrainfo` text NOT NULL,
  PRIMARY KEY  (`cid`),
  KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bannerclient`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbauth_access`
#

CREATE TABLE `nuke_bbauth_access` (
  `group_id` mediumint(8) NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `auth_view` tinyint(1) NOT NULL default '0',
  `auth_read` tinyint(1) NOT NULL default '0',
  `auth_post` tinyint(1) NOT NULL default '0',
  `auth_reply` tinyint(1) NOT NULL default '0',
  `auth_edit` tinyint(1) NOT NULL default '0',
  `auth_delete` tinyint(1) NOT NULL default '0',
  `auth_sticky` tinyint(1) NOT NULL default '0',
  `auth_announce` tinyint(1) NOT NULL default '0',
  `auth_vote` tinyint(1) NOT NULL default '0',
  `auth_pollcreate` tinyint(1) NOT NULL default '0',
  `auth_attachments` tinyint(1) NOT NULL default '0',
  `auth_mod` tinyint(1) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbauth_access`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbbanlist`
#

CREATE TABLE `nuke_bbbanlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL default '0',
  `ban_ip` varchar(8) NOT NULL default '',
  `ban_email` varchar(255) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbbanlist`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbcategories`
#

CREATE TABLE `nuke_bbcategories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbcategories`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbconfig`
#

CREATE TABLE `nuke_bbconfig` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbconfig`
#

INSERT INTO `nuke_bbconfig` VALUES ('config_id', '1');
INSERT INTO `nuke_bbconfig` VALUES ('board_disable', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sitename', 'Mujweb.cz');
INSERT INTO `nuke_bbconfig` VALUES ('site_desc', '');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_name', 'phpbb2mysql');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_path', '/');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_domain', 'Mujweb.cz');
INSERT INTO `nuke_bbconfig` VALUES ('cookie_secure', '0');
INSERT INTO `nuke_bbconfig` VALUES ('session_length', '3600');
INSERT INTO `nuke_bbconfig` VALUES ('allow_html', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_html_tags', 'b,i,u,pre');
INSERT INTO `nuke_bbconfig` VALUES ('allow_bbcode', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_smilies', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_sig', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_namechange', '0');
INSERT INTO `nuke_bbconfig` VALUES ('allow_theme_create', '0');
INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_local', '1');
INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_remote', '0');
INSERT INTO `nuke_bbconfig` VALUES ('allow_avatar_upload', '0');
INSERT INTO `nuke_bbconfig` VALUES ('override_user_style', '1');
INSERT INTO `nuke_bbconfig` VALUES ('posts_per_page', '15');
INSERT INTO `nuke_bbconfig` VALUES ('topics_per_page', '50');
INSERT INTO `nuke_bbconfig` VALUES ('hot_threshold', '25');
INSERT INTO `nuke_bbconfig` VALUES ('max_poll_options', '10');
INSERT INTO `nuke_bbconfig` VALUES ('max_sig_chars', '255');
INSERT INTO `nuke_bbconfig` VALUES ('max_inbox_privmsgs', '100');
INSERT INTO `nuke_bbconfig` VALUES ('max_sentbox_privmsgs', '100');
INSERT INTO `nuke_bbconfig` VALUES ('max_savebox_privmsgs', '100');
INSERT INTO `nuke_bbconfig` VALUES ('board_email_sig', 'D∞kujeme, [e-mail]');
INSERT INTO `nuke_bbconfig` VALUES ('board_email', '[e-mail]');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_delivery', '0');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_host', '');
INSERT INTO `nuke_bbconfig` VALUES ('require_activation', '0');
INSERT INTO `nuke_bbconfig` VALUES ('flood_interval', '15');
INSERT INTO `nuke_bbconfig` VALUES ('board_email_form', '0');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_filesize', '6144');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_max_width', '80');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_max_height', '80');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_path', 'modules/Forums/images/avatars');
INSERT INTO `nuke_bbconfig` VALUES ('avatar_gallery_path', 'modules/Forums/images/avatars');
INSERT INTO `nuke_bbconfig` VALUES ('smilies_path', 'modules/Forums/images/smiles');
INSERT INTO `nuke_bbconfig` VALUES ('default_style', '1');
INSERT INTO `nuke_bbconfig` VALUES ('default_dateformat', 'D d. M, Y G:i');
INSERT INTO `nuke_bbconfig` VALUES ('board_timezone', '1');
INSERT INTO `nuke_bbconfig` VALUES ('prune_enable', '0');
INSERT INTO `nuke_bbconfig` VALUES ('privmsg_disable', '0');
INSERT INTO `nuke_bbconfig` VALUES ('gzip_compress', '0');
INSERT INTO `nuke_bbconfig` VALUES ('coppa_fax', '');
INSERT INTO `nuke_bbconfig` VALUES ('coppa_mail', '');
INSERT INTO `nuke_bbconfig` VALUES ('board_startdate', '1013908210');
INSERT INTO `nuke_bbconfig` VALUES ('default_lang', 'czech');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_username', '');
INSERT INTO `nuke_bbconfig` VALUES ('smtp_password', '');
INSERT INTO `nuke_bbconfig` VALUES ('record_online_users', '2');
INSERT INTO `nuke_bbconfig` VALUES ('record_online_date', '1034668530');
INSERT INTO `nuke_bbconfig` VALUES ('server_name', 'vasweb.cz');
INSERT INTO `nuke_bbconfig` VALUES ('server_port', '80');
INSERT INTO `nuke_bbconfig` VALUES ('script_path', '/modules/Forums/');
INSERT INTO `nuke_bbconfig` VALUES ('version', '.0.6');
INSERT INTO `nuke_bbconfig` VALUES ('enable_confirm', '0');
INSERT INTO `nuke_bbconfig` VALUES ('sendmail_fix', '0');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbconfirm`
#

CREATE TABLE `nuke_bbconfirm` (
  `confirm_id` char(32) NOT NULL default '',
  `session_id` char(32) NOT NULL default '',
  `code` char(6) NOT NULL default '',
  PRIMARY KEY  (`session_id`,`confirm_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbconfirm`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbdisallow`
#

CREATE TABLE `nuke_bbdisallow` (
  `disallow_id` mediumint(8) unsigned NOT NULL auto_increment,
  `disallow_username` varchar(25) default NULL,
  PRIMARY KEY  (`disallow_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbdisallow`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbforum_prune`
#

CREATE TABLE `nuke_bbforum_prune` (
  `prune_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `prune_days` tinyint(4) unsigned NOT NULL default '0',
  `prune_freq` tinyint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prune_id`),
  KEY `forum_id` (`forum_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbforum_prune`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbforums`
#

CREATE TABLE `nuke_bbforums` (
  `forum_id` smallint(5) unsigned NOT NULL auto_increment,
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '1',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbforums`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbgroups`
#

CREATE TABLE `nuke_bbgroups` (
  `group_id` mediumint(8) NOT NULL auto_increment,
  `group_type` tinyint(4) NOT NULL default '1',
  `group_name` varchar(40) NOT NULL default '',
  `group_description` varchar(255) NOT NULL default '',
  `group_moderator` mediumint(8) NOT NULL default '0',
  `group_single_user` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`group_id`),
  KEY `group_single_user` (`group_single_user`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

#
# Vypisuji data pro tabulku `nuke_bbgroups`
#

INSERT INTO `nuke_bbgroups` VALUES (1, 1, 'Anonymnφ', 'Anonymnφ u╛ivatelΘ', 0, 1);
INSERT INTO `nuke_bbgroups` VALUES (3, 2, 'Moderßto°i', 'Moderßto°i tohoto f≤ra', 5, 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbposts`
#

CREATE TABLE `nuke_bbposts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbposts`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbposts_text`
#

CREATE TABLE `nuke_bbposts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbposts_text`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbprivmsgs`
#

CREATE TABLE `nuke_bbprivmsgs` (
  `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
  `privmsgs_type` tinyint(4) NOT NULL default '0',
  `privmsgs_subject` varchar(255) NOT NULL default '0',
  `privmsgs_from_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_to_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_date` int(11) NOT NULL default '0',
  `privmsgs_ip` varchar(8) NOT NULL default '',
  `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
  `privmsgs_enable_html` tinyint(1) NOT NULL default '0',
  `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
  `privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`privmsgs_id`),
  KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
  KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbprivmsgs`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbprivmsgs_text`
#

CREATE TABLE `nuke_bbprivmsgs_text` (
  `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0',
  `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0',
  `privmsgs_text` text,
  PRIMARY KEY  (`privmsgs_text_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbprivmsgs_text`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbranks`
#

CREATE TABLE `nuke_bbranks` (
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_max` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Vypisuji data pro tabulku `nuke_bbranks`
#

INSERT INTO `nuke_bbranks` VALUES (1, 'Administrßtor serveru', -1, -1, 1, 'modules/Forums/images/ranks/6stars.gif');
INSERT INTO `nuke_bbranks` VALUES (2, 'NovßΦek', 1, 0, 0, 'modules/Forums/images/ranks/1star.gif');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbsearch_results`
#

CREATE TABLE `nuke_bbsearch_results` (
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(32) NOT NULL default '',
  `search_array` text NOT NULL,
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbsearch_results`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbsearch_wordlist`
#

CREATE TABLE `nuke_bbsearch_wordlist` (
  `word_text` varchar(50) binary NOT NULL default '',
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_text`),
  KEY `word_id` (`word_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbsearch_wordlist`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbsearch_wordmatch`
#

CREATE TABLE `nuke_bbsearch_wordmatch` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `word_id` (`word_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbsearch_wordmatch`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbsessions`
#

CREATE TABLE `nuke_bbsessions` (
  `session_id` char(32) NOT NULL default '',
  `session_user_id` mediumint(8) NOT NULL default '0',
  `session_start` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_ip` char(8) NOT NULL default '0',
  `session_page` int(11) NOT NULL default '0',
  `session_logged_in` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbsessions`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbsmilies`
#

CREATE TABLE `nuke_bbsmilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`)
) TYPE=MyISAM AUTO_INCREMENT=45 ;

#
# Vypisuji data pro tabulku `nuke_bbsmilies`
#

INSERT INTO `nuke_bbsmilies` VALUES (1, ':D', 'icon_biggrin.gif', 'Velmi ╣╗astn²');
INSERT INTO `nuke_bbsmilies` VALUES (2, ':-D', 'icon_biggrin.gif', 'Velmi ╣╗astn²');
INSERT INTO `nuke_bbsmilies` VALUES (3, ':grin:', 'icon_biggrin.gif', 'Velmi ╣╗astn²');
INSERT INTO `nuke_bbsmilies` VALUES (4, ':)', 'icon_smile.gif', 'Usmφvajφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (5, ':-)', 'icon_smile.gif', 'Usmφvajφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (6, ':smile:', 'icon_smile.gif', 'Usmφvajφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (7, ':(', 'icon_sad.gif', 'Smutn²');
INSERT INTO `nuke_bbsmilies` VALUES (8, ':-(', 'icon_sad.gif', 'Smutn²');
INSERT INTO `nuke_bbsmilies` VALUES (9, ':sad:', 'icon_sad.gif', 'Smutn²');
INSERT INTO `nuke_bbsmilies` VALUES (10, ':o', 'icon_surprised.gif', 'P°ekvapen²');
INSERT INTO `nuke_bbsmilies` VALUES (11, ':-o', 'icon_surprised.gif', 'P°ekvapen²');
INSERT INTO `nuke_bbsmilies` VALUES (12, ':eek:', 'icon_surprised.gif', 'P°ekvapen²');
INSERT INTO `nuke_bbsmilies` VALUES (13, '8O', 'icon_eek.gif', '⌐okovan²');
INSERT INTO `nuke_bbsmilies` VALUES (14, '8-O', 'icon_eek.gif', '⌐okovan²');
INSERT INTO `nuke_bbsmilies` VALUES (15, ':shock:', 'icon_eek.gif', '⌐okovan²');
INSERT INTO `nuke_bbsmilies` VALUES (16, ':?', 'icon_confused.gif', 'Popleten²');
INSERT INTO `nuke_bbsmilies` VALUES (17, ':-?', 'icon_confused.gif', 'Popleten²');
INSERT INTO `nuke_bbsmilies` VALUES (18, ':???:', 'icon_confused.gif', 'Popleten²');
INSERT INTO `nuke_bbsmilies` VALUES (19, '8)', 'icon_cool.gif', 'Cool');
INSERT INTO `nuke_bbsmilies` VALUES (20, '8-)', 'icon_cool.gif', 'Cool');
INSERT INTO `nuke_bbsmilies` VALUES (21, ':cool:', 'icon_cool.gif', 'Cool');
INSERT INTO `nuke_bbsmilies` VALUES (22, ':lol:', 'icon_lol.gif', 'Sm∞jφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (23, ':x', 'icon_mad.gif', 'Zu°iv²');
INSERT INTO `nuke_bbsmilies` VALUES (24, ':-x', 'icon_mad.gif', 'Zu°iv²');
INSERT INTO `nuke_bbsmilies` VALUES (25, ':mad:', 'icon_mad.gif', 'Zu°iv²');
INSERT INTO `nuke_bbsmilies` VALUES (26, ':P', 'icon_razz.gif', 'Rßzn²');
INSERT INTO `nuke_bbsmilies` VALUES (27, ':-P', 'icon_razz.gif', 'Rßzn²');
INSERT INTO `nuke_bbsmilies` VALUES (28, ':razz:', 'icon_razz.gif', 'Rßzn²');
INSERT INTO `nuke_bbsmilies` VALUES (29, ':oops:', 'icon_redface.gif', 'Na rozpacφch');
INSERT INTO `nuke_bbsmilies` VALUES (30, ':cry:', 'icon_cry.gif', 'PlaΦφcφ nebo velmi smutn²');
INSERT INTO `nuke_bbsmilies` VALUES (31, ':evil:', 'icon_evil.gif', 'Zl² nebo velmi zu°iv²');
INSERT INTO `nuke_bbsmilies` VALUES (32, ':twisted:', 'icon_twisted.gif', 'Podl²');
INSERT INTO `nuke_bbsmilies` VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Koulejφcφ oΦima');
INSERT INTO `nuke_bbsmilies` VALUES (34, ':wink:', 'icon_wink.gif', 'Mrkajφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (35, ';)', 'icon_wink.gif', 'Mrkajφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (36, ';-)', 'icon_wink.gif', 'Mrkajφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (37, ':!:', 'icon_exclaim.gif', 'Upozor≥ujφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (38, ':?:', 'icon_question.gif', 'Tßzajφcφ');
INSERT INTO `nuke_bbsmilies` VALUES (39, ':idea:', 'icon_idea.gif', 'My╣lenka');
INSERT INTO `nuke_bbsmilies` VALUES (40, ':arrow:', 'icon_arrow.gif', '⌐ipka');
INSERT INTO `nuke_bbsmilies` VALUES (41, ':|', 'icon_neutral.gif', 'Neutrßlnφ');
INSERT INTO `nuke_bbsmilies` VALUES (42, ':-|', 'icon_neutral.gif', 'Neutrßlnφ');
INSERT INTO `nuke_bbsmilies` VALUES (43, ':neutral:', 'icon_neutral.gif', 'Neutrßlnφ');
INSERT INTO `nuke_bbsmilies` VALUES (44, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbthemes`
#

CREATE TABLE `nuke_bbthemes` (
  `themes_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(30) NOT NULL default '',
  `style_name` varchar(30) NOT NULL default '',
  `head_stylesheet` varchar(100) default NULL,
  `body_background` varchar(100) default NULL,
  `body_bgcolor` varchar(6) default NULL,
  `body_text` varchar(6) default NULL,
  `body_link` varchar(6) default NULL,
  `body_vlink` varchar(6) default NULL,
  `body_alink` varchar(6) default NULL,
  `body_hlink` varchar(6) default NULL,
  `tr_color1` varchar(6) default NULL,
  `tr_color2` varchar(6) default NULL,
  `tr_color3` varchar(6) default NULL,
  `tr_class1` varchar(25) default NULL,
  `tr_class2` varchar(25) default NULL,
  `tr_class3` varchar(25) default NULL,
  `th_color1` varchar(6) default NULL,
  `th_color2` varchar(6) default NULL,
  `th_color3` varchar(6) default NULL,
  `th_class1` varchar(25) default NULL,
  `th_class2` varchar(25) default NULL,
  `th_class3` varchar(25) default NULL,
  `td_color1` varchar(6) default NULL,
  `td_color2` varchar(6) default NULL,
  `td_color3` varchar(6) default NULL,
  `td_class1` varchar(25) default NULL,
  `td_class2` varchar(25) default NULL,
  `td_class3` varchar(25) default NULL,
  `fontface1` varchar(50) default NULL,
  `fontface2` varchar(50) default NULL,
  `fontface3` varchar(50) default NULL,
  `fontsize1` tinyint(4) default NULL,
  `fontsize2` tinyint(4) default NULL,
  `fontsize3` tinyint(4) default NULL,
  `fontcolor1` varchar(6) default NULL,
  `fontcolor2` varchar(6) default NULL,
  `fontcolor3` varchar(6) default NULL,
  `span_class1` varchar(25) default NULL,
  `span_class2` varchar(25) default NULL,
  `span_class3` varchar(25) default NULL,
  `img_size_poll` smallint(5) unsigned default NULL,
  `img_size_privmsg` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`themes_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_bbthemes`
#

INSERT INTO `nuke_bbthemes` VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', '0E3259', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \'Courier New\', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', NULL, NULL);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbthemes_name`
#

CREATE TABLE `nuke_bbthemes_name` (
  `themes_id` smallint(5) unsigned NOT NULL default '0',
  `tr_color1_name` char(50) default NULL,
  `tr_color2_name` char(50) default NULL,
  `tr_color3_name` char(50) default NULL,
  `tr_class1_name` char(50) default NULL,
  `tr_class2_name` char(50) default NULL,
  `tr_class3_name` char(50) default NULL,
  `th_color1_name` char(50) default NULL,
  `th_color2_name` char(50) default NULL,
  `th_color3_name` char(50) default NULL,
  `th_class1_name` char(50) default NULL,
  `th_class2_name` char(50) default NULL,
  `th_class3_name` char(50) default NULL,
  `td_color1_name` char(50) default NULL,
  `td_color2_name` char(50) default NULL,
  `td_color3_name` char(50) default NULL,
  `td_class1_name` char(50) default NULL,
  `td_class2_name` char(50) default NULL,
  `td_class3_name` char(50) default NULL,
  `fontface1_name` char(50) default NULL,
  `fontface2_name` char(50) default NULL,
  `fontface3_name` char(50) default NULL,
  `fontsize1_name` char(50) default NULL,
  `fontsize2_name` char(50) default NULL,
  `fontsize3_name` char(50) default NULL,
  `fontcolor1_name` char(50) default NULL,
  `fontcolor2_name` char(50) default NULL,
  `fontcolor3_name` char(50) default NULL,
  `span_class1_name` char(50) default NULL,
  `span_class2_name` char(50) default NULL,
  `span_class3_name` char(50) default NULL,
  PRIMARY KEY  (`themes_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbthemes_name`
#

INSERT INTO `nuke_bbthemes_name` VALUES (1, 'Nejsv∞tlej╣φ barva °ßdku', 'St°ednφ barva °ßdku', 'Nejtmav∞j╣φ barva °ßdku', '', '', '', 'OhraniΦenφ okolo celΘ strßnky', 'Vn∞j╣φ ohraniΦenφ tabulky', 'Vnit°nφ ohraniΦenφ strßnky', 'St°ibrn² stφnovan² obrßzek', 'Modr² stφnovan² obrßzek', 'Obrßzek do ztracena na indexu', 'Pozadφ pro okolφ citace', 'V╣echna bφla mφsta', '', 'Pozadφ titulku p°φsp∞vku', 'DruhΘ pozadφ titulku p°φsp∞vku', '', 'Hlavnφ pφsma', 'Dal╣φ pφsma pro titulek p°φp∞vku', 'Pφsma formulß°e', 'Nejmen╣φ pφsmo', 'St°ednφ velikost pφsma', 'Normßlnφ velikost pφsma (t∞lo p°φsp∞vku apod.)', 'Citace & text copyrightu', 'Barva textu k≤du', 'Barva hlaviΦky hlavnφ tabulky', '', '', '');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbtopics`
#

CREATE TABLE `nuke_bbtopics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` char(60) NOT NULL default '',
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbtopics`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbtopics_watch`
#

CREATE TABLE `nuke_bbtopics_watch` (
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `notify_status` tinyint(1) NOT NULL default '0',
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_status` (`notify_status`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbtopics_watch`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbuser_group`
#

CREATE TABLE `nuke_bbuser_group` (
  `group_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_pending` tinyint(1) default NULL,
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbuser_group`
#

INSERT INTO `nuke_bbuser_group` VALUES (1, -1, 0);
INSERT INTO `nuke_bbuser_group` VALUES (3, 5, 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbvote_desc`
#

CREATE TABLE `nuke_bbvote_desc` (
  `vote_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_text` text NOT NULL,
  `vote_start` int(11) NOT NULL default '0',
  `vote_length` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vote_id`),
  KEY `topic_id` (`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbvote_desc`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbvote_results`
#

CREATE TABLE `nuke_bbvote_results` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_option_id` tinyint(4) unsigned NOT NULL default '0',
  `vote_option_text` varchar(255) NOT NULL default '',
  `vote_result` int(11) NOT NULL default '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbvote_results`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbvote_voters`
#

CREATE TABLE `nuke_bbvote_voters` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_user_id` mediumint(8) NOT NULL default '0',
  `vote_user_ip` char(8) NOT NULL default '',
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_bbvote_voters`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_bbwords`
#

CREATE TABLE `nuke_bbwords` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` char(100) NOT NULL default '',
  `replacement` char(100) NOT NULL default '',
  PRIMARY KEY  (`word_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_bbwords`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_blocks`
#

CREATE TABLE `nuke_blocks` (
  `bid` int(10) NOT NULL auto_increment,
  `bkey` varchar(15) NOT NULL default '',
  `title` varchar(60) NOT NULL default '',
  `content` text NOT NULL,
  `url` varchar(200) NOT NULL default '',
  `bposition` char(1) NOT NULL default '',
  `weight` int(10) NOT NULL default '1',
  `active` int(1) NOT NULL default '1',
  `refresh` int(10) NOT NULL default '0',
  `time` varchar(14) NOT NULL default '0',
  `blanguage` varchar(30) NOT NULL default '',
  `blockfile` varchar(255) NOT NULL default '',
  `view` int(1) NOT NULL default '0',
  PRIMARY KEY  (`bid`),
  KEY `bid` (`bid`),
  KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;

#
# Vypisuji data pro tabulku `nuke_blocks`
#

INSERT INTO `nuke_blocks` VALUES (1, '', 'Moduly', '', '', 'l', 1, 1, 0, '', '', 'block-Modules.php', 0);
INSERT INTO `nuke_blocks` VALUES (2, 'admin', 'Administrace', '<strong><big>·</big></strong> <a href="admin.php">Administrace</a><br>\r\n<strong><big>·</big></strong> <a href="admin.php?op=adminStory">NOV▌ Φlßnek</a><br>\r\n<strong><big>·</big></strong> <a href="admin.php?op=create">Zm∞nit anketu</a><br>\r\n<strong><big>·</big></strong> <a href="admin.php?op=content">Obsah</a><br>\r\n<strong><big>·</big></strong> <a href="admin.php?op=logout">Odhlßsit se</a>', '', 'l', 2, 1, 0, '985591188', '', '', 2);
INSERT INTO `nuke_blocks` VALUES (3, '', 'NṠSidebar', '', '', 'l', 3, 1, 3600, '', '', 'block-Sidebar.php', 0);
INSERT INTO `nuke_blocks` VALUES (4, '', 'Kdo je online', '', '', 'l', 4, 1, 0, '', '', 'block-Who_is_Online.php', 0);
INSERT INTO `nuke_blocks` VALUES (5, '', 'Vyhledßvßnφ', '', '', 'l', 5, 0, 3600, '', '', 'block-Search.php', 0);
INSERT INTO `nuke_blocks` VALUES (6, '', 'Jazyky', '', '', 'l', 6, 1, 3600, '', '', 'block-Languages.php', 0);
INSERT INTO `nuke_blocks` VALUES (7, '', 'NßhodnΘ zprßvy', '', '', 'l', 7, 0, 3600, '', '', 'block-Random_Headlines.php', 0);
INSERT INTO `nuke_blocks` VALUES (8, 'userbox', 'Osobnφ menu', '', '', 'r', 1, 1, 0, '', '', '', 1);
INSERT INTO `nuke_blocks` VALUES (9, '', 'Kategorie', '', '', 'r', 2, 0, 0, '', '', 'block-Categories.php', 0);
INSERT INTO `nuke_blocks` VALUES (10, '', 'Pr∙zkum', '', '', 'r', 3, 1, 3600, '', '', 'block-Survey.php', 0);
INSERT INTO `nuke_blocks` VALUES (11, '', 'Free Software pro Vßs!', '', '', 'r', 4, 1, 3600, '', '', 'block-Support_us.php', 0);
INSERT INTO `nuke_blocks` VALUES (12, '', 'P°ihlß╣enφ', '', '', 'r', 5, 1, 3600, '', '', 'block-Login.php', 3);
INSERT INTO `nuke_blocks` VALUES (13, '', 'NejΦten∞j╣φ Φlßnek', '', '', 'r', 6, 1, 3600, '', '', 'block-Big_Story_of_Today.php', 0);
INSERT INTO `nuke_blocks` VALUES (14, '', 'Star╣φ Φlßnky', '', '', 'r', 7, 1, 3600, '', '', 'block-Old_Articles.php', 0);
INSERT INTO `nuke_blocks` VALUES (15, '', 'Informace', '<br><center><font class="content">\r\n<a href="http://united-nuke.openland.cz"><img src="images/powered/phpnuke.gif" border="0" alt="Powered by UNITED-NUKE" title="Powered by UNITED-NUKE" width="88" height="31"></a>\r\n<br><br>\r\n<a href="http://validator.w3.org/check/referer"><img src="images/html401.gif" width="88" height="31" alt="Valid HTML 4.01!" title="Valid HTML 4.01!" border="0"></a>\r\n<br><br>\r\n<a href="http://jigsaw.w3.org/css-validator"><img src="images/css.gif" width="88" height="31" alt="Valid CSS!" title="Valid CSS!" border="0"></a></font></center><br>', '', 'r', 8, 1, 0, '', '', '', 0);
INSERT INTO `nuke_blocks` VALUES (16, '', 'Aktuality', '', '', 'c', 1, 0, 3600, '', '', 'block-Flashnews.php', 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_comments`
#

CREATE TABLE `nuke_comments` (
  `tid` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `date` datetime default NULL,
  `name` varchar(60) NOT NULL default '',
  `email` varchar(60) default NULL,
  `url` varchar(60) default NULL,
  `host_name` varchar(60) default NULL,
  `subject` varchar(85) NOT NULL default '',
  `comment` text NOT NULL,
  `score` tinyint(4) NOT NULL default '0',
  `reason` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `tid` (`tid`),
  KEY `pid` (`pid`),
  KEY `sid` (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_comments`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_config`
#

CREATE TABLE `nuke_config` (
  `sitename` varchar(255) NOT NULL default '',
  `nukeurl` varchar(255) NOT NULL default '',
  `site_logo` varchar(255) NOT NULL default '',
  `slogan` varchar(255) NOT NULL default '',
  `startdate` varchar(50) NOT NULL default '',
  `adminmail` varchar(255) NOT NULL default '',
  `anonpost` tinyint(1) NOT NULL default '0',
  `Default_Theme` varchar(255) NOT NULL default '',
  `foot1` text NOT NULL,
  `foot2` text NOT NULL,
  `foot3` text NOT NULL,
  `commentlimit` int(9) NOT NULL default '4096',
  `anonymous` varchar(255) NOT NULL default '',
  `minpass` tinyint(1) NOT NULL default '5',
  `pollcomm` tinyint(1) NOT NULL default '1',
  `articlecomm` tinyint(1) NOT NULL default '1',
  `broadcast_msg` tinyint(1) NOT NULL default '1',
  `my_headlines` tinyint(1) NOT NULL default '1',
  `top` int(3) NOT NULL default '10',
  `storyhome` int(2) NOT NULL default '10',
  `user_news` tinyint(1) NOT NULL default '1',
  `oldnum` int(2) NOT NULL default '30',
  `ultramode` tinyint(1) NOT NULL default '0',
  `banners` tinyint(1) NOT NULL default '1',
  `backend_title` varchar(255) NOT NULL default '',
  `backend_language` varchar(10) NOT NULL default '',
  `language` varchar(100) NOT NULL default '',
  `locale` varchar(20) NOT NULL default '',
  `multilingual` tinyint(1) NOT NULL default '0',
  `useflags` tinyint(1) NOT NULL default '0',
  `notify` tinyint(1) NOT NULL default '0',
  `notify_email` varchar(255) NOT NULL default '',
  `notify_subject` varchar(255) NOT NULL default '',
  `notify_message` varchar(255) NOT NULL default '',
  `notify_from` varchar(255) NOT NULL default '',
  `footermsgtxt` text NOT NULL,
  `email_send` tinyint(1) NOT NULL default '1',
  `attachmentdir` varchar(255) NOT NULL default '',
  `attachments` tinyint(1) NOT NULL default '0',
  `attachments_view` tinyint(1) NOT NULL default '0',
  `download_dir` varchar(255) NOT NULL default '',
  `defaultpopserver` varchar(255) NOT NULL default '',
  `singleaccount` tinyint(1) NOT NULL default '0',
  `singleaccountname` varchar(255) NOT NULL default '',
  `numaccounts` tinyint(2) NOT NULL default '-1',
  `imgpath` varchar(255) NOT NULL default '',
  `filter_forward` tinyint(1) NOT NULL default '1',
  `moderate` tinyint(1) NOT NULL default '0',
  `admingraphic` tinyint(1) NOT NULL default '1',
  `httpref` tinyint(1) NOT NULL default '1',
  `httprefmax` int(5) NOT NULL default '1000',
  `CensorMode` tinyint(1) NOT NULL default '3',
  `CensorReplace` varchar(10) NOT NULL default '',
  `copyright` text NOT NULL,
  `Version_Num` varchar(10) NOT NULL default ''
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_config`
#

INSERT INTO `nuke_config` VALUES ('UNITED-NUKE Powered Site', 'http://vasweb.cz', 'logo.gif', 'Vß╣ slogan zde', 'Leden 2004', '[e-mail]', 0, 'DeepBlue', '<a href=\"http://united-nuke.openland.cz\" target=\"_blank\"><img src=\"images/powered/nuke.gif\" border=\"0\" alt=\"Web site powered by UNITED-NUKE\" hspace=\"10\"></a><br>', 'V╣echny obchodnφ znßmky a nßzvy pat°φ jejich p°φslu╣n²m vlastnφk∙m, komentß°e pat°φ jejich odesφlatel∙m.<br>V╣e ostatnφ vlastnφ © 2004 UNITED-NUKE Powered Site.', 'Odebφrat na╣e zprßvy m∙╛ete pomocφ souboru <a href=\"backend.php\"><font class=\"footmsg_l\">backend.php</font></a> nebo <a href=\"ultramode.txt\"><font class=\"footmsg_l\">ultramode.txt</font></a>.', 4096, 'Anonymnφ', 5, 1, 1, 1, 1, 10, 10, 1, 30, 0, 1, 'UNITED-NUKE Powered Site', 'cs-cz', 'czech', 'cs_CZ.ISO-8859-2', 0, 0, 0, '[e-mail]', '╚L┴NEK pro m∙j server', 'Ahoj! Obdr╛el jste nov² Φlßnek pro vß╣ server.', 'webmaster', 'Tento e-mail byl odeslßn pomocφ slu╛by WebMail na UNITED-NUKE Powered Site\r\n- http://vasweb.cz', 1, '/var/www/html/modules/WebMail/tmp/', 0, 0, 'modules/WebMail/attachments/', '', 0, 'Vß╣ ·Φet', -1, 'modules/WebMail/images', 1, 0, 1, 1, 1000, 3, '*****', 'Powered by Copyright © <a href=\"http://united-nuke.openland.cz\"><font class=\"footmsg_l\">UNITED-NUKE</font></a>. V╣echna prßva vyhrazena.<br>UNITED-NUKE je Free Software publikovan² pod <a href=\"http://www.gnu.org\"><font class=\"footmsg_l\">GNU/GPL Licencφ</font></a>.', '6.9');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_config_sidebar`
#

CREATE TABLE `nuke_config_sidebar` (
  `shwsearch` tinyint(4) NOT NULL default '0',
  `searchdown` tinyint(4) NOT NULL default '0',
  `btn` tinyint(4) NOT NULL default '1',
  `shwstor` tinyint(4) NOT NULL default '0',
  `stornum` smallint(6) NOT NULL default '3',
  `shwfn` tinyint(4) NOT NULL default '0',
  `fnnum` smallint(6) NOT NULL default '3',
  `shwlad` tinyint(4) NOT NULL default '0',
  `ladnum` smallint(6) NOT NULL default '3',
  `shwtopd` tinyint(4) NOT NULL default '0',
  `topdnum` smallint(6) NOT NULL default '3',
  `shwlcomm` tinyint(4) NOT NULL default '0',
  `lcomm` smallint(6) NOT NULL default '3',
  `shwlfa` tinyint(4) NOT NULL default '0',
  `lfanum` smallint(6) NOT NULL default '3'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_config_sidebar`
#

INSERT INTO `nuke_config_sidebar` VALUES (1, 1, 0, 1, 3, 0, 3, 1, 5, 0, 3, 1, 3, 1, 3);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_contactbook`
#

CREATE TABLE `nuke_contactbook` (
  `uid` int(11) NOT NULL default '0',
  `contactid` int(11) NOT NULL auto_increment,
  `firstname` varchar(50) default NULL,
  `lastname` varchar(50) default NULL,
  `email` varchar(255) default NULL,
  `company` varchar(255) default NULL,
  `homeaddress` varchar(255) default NULL,
  `city` varchar(80) default NULL,
  `homephone` varchar(255) default NULL,
  `workphone` varchar(255) default NULL,
  `homepage` varchar(255) default NULL,
  `IM` varchar(255) default NULL,
  `events` text,
  `reminders` int(11) default NULL,
  `notes` text,
  PRIMARY KEY  (`contactid`),
  KEY `uid` (`uid`),
  KEY `contactid` (`contactid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_contactbook`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_counter`
#

CREATE TABLE `nuke_counter` (
  `type` varchar(80) NOT NULL default '',
  `var` varchar(80) NOT NULL default '',
  `count` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_counter`
#

INSERT INTO `nuke_counter` VALUES ('total', 'hits', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'WebTV', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'Lynx', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'MSIE', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'Opera', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'Konqueror', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'Netscape', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'Bot', 0);
INSERT INTO `nuke_counter` VALUES ('browser', 'Other', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'Windows', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'Linux', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'Mac', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'FreeBSD', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'SunOS', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'IRIX', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'BeOS', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'OS/2', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'AIX', 0);
INSERT INTO `nuke_counter` VALUES ('os', 'Other', 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_downloads_categories`
#

CREATE TABLE `nuke_downloads_categories` (
  `cid` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `cdescription` text NOT NULL,
  `parentid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cid`),
  KEY `cid` (`cid`),
  KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_downloads_categories`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_downloads_downloads`
#

CREATE TABLE `nuke_downloads_downloads` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `date` datetime default NULL,
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `submitter` varchar(60) NOT NULL default '',
  `downloadratingsummary` double(6,4) NOT NULL default '0.0000',
  `totalvotes` int(11) NOT NULL default '0',
  `totalcomments` int(11) NOT NULL default '0',
  `filesize` int(11) NOT NULL default '0',
  `version` varchar(10) NOT NULL default '',
  `homepage` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`lid`),
  KEY `lid` (`lid`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_downloads_downloads`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_downloads_editorials`
#

CREATE TABLE `nuke_downloads_editorials` (
  `downloadid` int(11) NOT NULL default '0',
  `adminid` varchar(60) NOT NULL default '',
  `editorialtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `editorialtext` text NOT NULL,
  `editorialtitle` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`downloadid`),
  KEY `downloadid` (`downloadid`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_downloads_editorials`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_downloads_modrequest`
#

CREATE TABLE `nuke_downloads_modrequest` (
  `requestid` int(11) NOT NULL auto_increment,
  `lid` int(11) NOT NULL default '0',
  `cid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `modifysubmitter` varchar(60) NOT NULL default '',
  `brokendownload` int(3) NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `version` varchar(10) NOT NULL default '',
  `homepage` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`requestid`),
  UNIQUE KEY `requestid` (`requestid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_downloads_modrequest`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_downloads_newdownload`
#

CREATE TABLE `nuke_downloads_newdownload` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `submitter` varchar(60) NOT NULL default '',
  `filesize` int(11) NOT NULL default '0',
  `version` varchar(10) NOT NULL default '',
  `homepage` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`lid`),
  KEY `lid` (`lid`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`),
  KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_downloads_newdownload`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_downloads_votedata`
#

CREATE TABLE `nuke_downloads_votedata` (
  `ratingdbid` int(11) NOT NULL auto_increment,
  `ratinglid` int(11) NOT NULL default '0',
  `ratinguser` varchar(60) NOT NULL default '',
  `rating` int(11) NOT NULL default '0',
  `ratinghostname` varchar(60) NOT NULL default '',
  `ratingcomments` text NOT NULL,
  `ratingtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ratingdbid`),
  KEY `ratingdbid` (`ratingdbid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_downloads_votedata`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_encyclopedia`
#

CREATE TABLE `nuke_encyclopedia` (
  `eid` int(10) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `elanguage` varchar(30) NOT NULL default '',
  `active` int(1) NOT NULL default '0',
  PRIMARY KEY  (`eid`),
  KEY `eid` (`eid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_encyclopedia`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_encyclopedia_text`
#

CREATE TABLE `nuke_encyclopedia_text` (
  `tid` int(10) NOT NULL auto_increment,
  `eid` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `counter` int(10) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `tid` (`tid`),
  KEY `eid` (`eid`),
  KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_encyclopedia_text`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_ephem`
#

CREATE TABLE `nuke_ephem` (
  `eid` int(11) NOT NULL auto_increment,
  `did` int(2) NOT NULL default '0',
  `mid` int(2) NOT NULL default '0',
  `yid` int(4) NOT NULL default '0',
  `content` text NOT NULL,
  `elanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`eid`),
  KEY `eid` (`eid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_ephem`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_faqAnswer`
#

CREATE TABLE `nuke_faqAnswer` (
  `id` tinyint(4) NOT NULL auto_increment,
  `id_cat` tinyint(4) NOT NULL default '0',
  `question` varchar(255) default '',
  `answer` text,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `id_cat` (`id_cat`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_faqAnswer`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_faqCategories`
#

CREATE TABLE `nuke_faqCategories` (
  `id_cat` tinyint(3) NOT NULL auto_increment,
  `categories` varchar(255) default NULL,
  `flanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id_cat`),
  KEY `id_cat` (`id_cat`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_faqCategories`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_headlines`
#

CREATE TABLE `nuke_headlines` (
  `hid` int(11) NOT NULL auto_increment,
  `sitename` varchar(30) NOT NULL default '',
  `headlinesurl` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`hid`),
  KEY `hid` (`hid`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

#
# Vypisuji data pro tabulku `nuke_headlines`
#

INSERT INTO `nuke_headlines` VALUES (1, 'UNITED-NUKE', 'http://united-nuke.openland.cz/backend.php?enc=iso&img=1');
INSERT INTO `nuke_headlines` VALUES (2, 'Boule webzine', 'http://www.boule.cz/backend.php?enc=iso');
INSERT INTO `nuke_headlines` VALUES (3, 'CMD-SITE.net', 'http://www.cmd-site.net/backend.php?enc=iso');
INSERT INTO `nuke_headlines` VALUES (4, 'ROOT.CZ', 'http://www.root.cz/rss/index.php4');
INSERT INTO `nuke_headlines` VALUES (5, 'AbcLinuxu.cz', 'http://www.abclinuxu.cz/auto/abc.rss');
INSERT INTO `nuke_headlines` VALUES (6, 'Penguin.cz', 'http://www.penguin.cz/rss.php3');
INSERT INTO `nuke_headlines` VALUES (7, 'Underground.cz', 'http://underground.cz/backend.php');
INSERT INTO `nuke_headlines` VALUES (8, 'czilla.cz', 'http://www.czilla.cz/rss/rss.html');
INSERT INTO `nuke_headlines` VALUES (9, 'Openland.cz', 'http://www.openland.cz/backend.php?enc=iso&img=1');
INSERT INTO `nuke_headlines` VALUES (10, 'Linuxem.cz', 'http://www.linuxem.cz/backend.php?enc=iso');
INSERT INTO `nuke_headlines` VALUES (11, 'Zive.cz', 'http://www.zive.cz/system/RSS.xml');
INSERT INTO `nuke_headlines` VALUES (12, 'Mobilmania.cz', 'http://www.mobilmania.cz/system/RSS.xml');
INSERT INTO `nuke_headlines` VALUES (13, 'Mobil.cz', 'http://mobil.idnes.cz/iso/day_rss.html');
INSERT INTO `nuke_headlines` VALUES (14, 'Technet.cz', 'http://technet.idnes.cz/iso/day_rss.html');
INSERT INTO `nuke_headlines` VALUES (15, 'Palmare.cz', 'http://palmare.idnes.cz/iso/day_rss.html');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_journal`
#

CREATE TABLE `nuke_journal` (
  `jid` int(11) NOT NULL auto_increment,
  `aid` varchar(30) NOT NULL default '',
  `title` varchar(80) default NULL,
  `bodytext` text NOT NULL,
  `mood` varchar(48) NOT NULL default '',
  `pdate` varchar(48) NOT NULL default '',
  `ptime` varchar(48) NOT NULL default '',
  `status` varchar(48) NOT NULL default '',
  `mtime` varchar(48) NOT NULL default '',
  `mdate` varchar(48) NOT NULL default '',
  PRIMARY KEY  (`jid`),
  KEY `jid` (`jid`),
  KEY `aid` (`aid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_journal`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_journal_comments`
#

CREATE TABLE `nuke_journal_comments` (
  `cid` int(11) NOT NULL auto_increment,
  `rid` varchar(48) NOT NULL default '',
  `aid` varchar(30) NOT NULL default '',
  `comment` text NOT NULL,
  `pdate` varchar(48) NOT NULL default '',
  `ptime` varchar(48) NOT NULL default '',
  PRIMARY KEY  (`cid`),
  KEY `cid` (`cid`),
  KEY `rid` (`rid`),
  KEY `aid` (`aid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_journal_comments`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_journal_stats`
#

CREATE TABLE `nuke_journal_stats` (
  `id` int(11) NOT NULL auto_increment,
  `joid` varchar(48) NOT NULL default '',
  `nop` varchar(48) NOT NULL default '',
  `ldp` varchar(24) NOT NULL default '',
  `ltp` varchar(24) NOT NULL default '',
  `micro` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_journal_stats`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_links_categories`
#

CREATE TABLE `nuke_links_categories` (
  `cid` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `cdescription` text NOT NULL,
  `parentid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cid`),
  KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_links_categories`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_links_editorials`
#

CREATE TABLE `nuke_links_editorials` (
  `linkid` int(11) NOT NULL default '0',
  `adminid` varchar(60) NOT NULL default '',
  `editorialtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `editorialtext` text NOT NULL,
  `editorialtitle` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`linkid`),
  KEY `linkid` (`linkid`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_links_editorials`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_links_links`
#

CREATE TABLE `nuke_links_links` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `date` datetime default NULL,
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `submitter` varchar(60) NOT NULL default '',
  `linkratingsummary` double(6,4) NOT NULL default '0.0000',
  `totalvotes` int(11) NOT NULL default '0',
  `totalcomments` int(11) NOT NULL default '0',
  PRIMARY KEY  (`lid`),
  KEY `lid` (`lid`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_links_links`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_links_modrequest`
#

CREATE TABLE `nuke_links_modrequest` (
  `requestid` int(11) NOT NULL auto_increment,
  `lid` int(11) NOT NULL default '0',
  `cid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `modifysubmitter` varchar(60) NOT NULL default '',
  `brokenlink` int(3) NOT NULL default '0',
  PRIMARY KEY  (`requestid`),
  UNIQUE KEY `requestid` (`requestid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_links_modrequest`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_links_newlink`
#

CREATE TABLE `nuke_links_newlink` (
  `lid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `submitter` varchar(60) NOT NULL default '',
  PRIMARY KEY  (`lid`),
  KEY `lid` (`lid`),
  KEY `cid` (`cid`),
  KEY `sid` (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_links_newlink`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_links_votedata`
#

CREATE TABLE `nuke_links_votedata` (
  `ratingdbid` int(11) NOT NULL auto_increment,
  `ratinglid` int(11) NOT NULL default '0',
  `ratinguser` varchar(60) NOT NULL default '',
  `rating` int(11) NOT NULL default '0',
  `ratinghostname` varchar(60) NOT NULL default '',
  `ratingcomments` text NOT NULL,
  `ratingtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`ratingdbid`),
  KEY `ratingdbid` (`ratingdbid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_links_votedata`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_main`
#

CREATE TABLE `nuke_main` (
  `main_module` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_main`
#

INSERT INTO `nuke_main` VALUES ('News');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_message`
#

CREATE TABLE `nuke_message` (
  `mid` int(11) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL default '',
  `content` text NOT NULL,
  `date` varchar(14) NOT NULL default '',
  `expire` int(7) NOT NULL default '0',
  `active` int(1) NOT NULL default '1',
  `view` int(1) NOT NULL default '1',
  `mlanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`mid`),
  UNIQUE KEY `mid` (`mid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_message`
#

INSERT INTO `nuke_message` VALUES (1, 'Vφtejte v publikaΦnφm systΘmu UNITED-NUKE!', '<br>Gratulujeme! Prßv∞ jste ·sp∞╣n∞ nainstaloval(a) tento webov² portßl! Tuto zprßvu m∙╛ete zm∞nit v <a href="admin.php">Administraci</a>.\r\n<br><br>\r\n<center><b>Z bezpeΦnostnφch d∙vod∙ NYN═ doporuΦujeme vytvo°it Super U╛ivatele kliknutφm <a href="admin.php">ZDE</a></b></center>\r\n<br><br>\r\nNa tomto mφst∞ m∙╛ete takΘ vytvo°it b∞╛nΘho u╛ivatele. P°eΦt∞te si prosφm soubor README a soubor CREDITS, abyste v∞d∞li kdo je autorem tohoto softwaru a nezapome≥te, ╛e tento software je publikovan² pod licencφ GPL (Φt∞te soubor COPYING pro detaily). Doufßme, ╛e se vßm tento software bude lφbit. V╣echny chyby, kterΘ naleznete nßm prosφm sd∞lte, pokusφme se je opravit v dal╣φm verzi.\r\n<br><br>\r\nJestli╛e se vßm tento software lφbφ, m∙╛ete podpo°it nßs a otev°en² software zakoupenφm jakΘhokoli zbo╛φ v <a href="http://www.openland.cz" target="_blank">Openland.cz eShopu</a>.\r\n<br><br>\r\nUNITED-NUKE je <i>inteligentnφ</i> publikaΦnφ systΘm navr╛en² a naprogramovan² s vysok²m nasazenφm. UNITED-NUKE mß jednu z nejv∞t╣φch komunit v ╚R. Chcete-li se podφlet na v²voji tΘto revoluΦnφ aplikace, m∙╛ete nßs kontaktovat na adrese <a href="http://united-nuke.openland.cz">http://united-nuke.openland.cz</a> kde takΘ naleznete dal╣φ moduly, bloky a r∙znß vylep╣enφ...\r\n<br><br>\r\nD∞kujeme vßm za va╣i podporu a za vybranφ aplikace UNITED-NUKE jako vß╣ publikaΦnφ systΘm pro vß╣ web! Doufßme, ╛e tuto aplikaci budete pou╛φvat rßdi, tak jako ji my rßdi vytvß°φme pro vßs!', '993373194', 0, 1, 1, '');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_modules`
#

CREATE TABLE `nuke_modules` (
  `mid` int(10) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `custom_title` varchar(255) NOT NULL default '',
  `active` int(1) NOT NULL default '0',
  `view` int(1) NOT NULL default '0',
  `inmenu` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`mid`),
  KEY `mid` (`mid`),
  KEY `title` (`title`),
  KEY `custom_title` (`custom_title`)
) TYPE=MyISAM AUTO_INCREMENT=29 ;

#
# Vypisuji data pro tabulku `nuke_modules`
#

INSERT INTO `nuke_modules` VALUES (1, 'AvantGo', 'Verze pro PDA', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (2, 'Downloads', 'Soubory', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (3, 'Feedback', 'P°ipomφnky', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (4, 'Journal', 'Denφk', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (5, 'News', 'Novinky', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (6, 'Private_Messages', 'SoukromΘ zprßvy', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (7, 'Recommend_Us', 'DoporuΦit nßs', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (8, 'Search', 'Vyhledßvßnφ', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (9, 'Statistics', 'Statistiky', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (10, 'Stories_Archive', 'Archφv Φlßnk∙', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (11, 'Submit_News', 'Poslat Φlßnek', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (12, 'Surveys', 'Pr∙zkumy', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (13, 'Top', 'Top 10', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (14, 'Topics', 'TΘmata', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (15, 'Web_Links', 'Odkazy', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (16, 'WebMail', 'WebMail', 1, 1, 1);
INSERT INTO `nuke_modules` VALUES (17, 'Your_Account', 'Vß╣ ·Φet', 1, 0, 1);
INSERT INTO `nuke_modules` VALUES (18, 'Addon_Sample', 'Addon Sample', 0, 2, 1);
INSERT INTO `nuke_modules` VALUES (19, 'Content', 'Obsah', 0, 0, 1);
INSERT INTO `nuke_modules` VALUES (20, 'Encyclopedia', 'Encyklopedie', 0, 0, 1);
INSERT INTO `nuke_modules` VALUES (21, 'FAQ', 'FAQ', 0, 0, 1);
INSERT INTO `nuke_modules` VALUES (22, 'Forums', 'F≤rum (phpBB)', 0, 0, 1);
INSERT INTO `nuke_modules` VALUES (23, 'Splatt_Forums', 'F≤rum (Splatt)', 0, 0, 1);
INSERT INTO `nuke_modules` VALUES (24, 'Members_List', 'Seznam u╛ivatel∙', 0, 1, 1);
INSERT INTO `nuke_modules` VALUES (25, 'Reviews', 'Recenze', 0, 0, 1);
INSERT INTO `nuke_modules` VALUES (26, 'Sections', 'Sekce', 0, 0, 1);
INSERT INTO `nuke_modules` VALUES (27, 'Flashnews', 'Aktuality', 1, 0, 0);
INSERT INTO `nuke_modules` VALUES (28, 'Sidebar', 'Sidebar', 1, 0, 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_pages`
#

CREATE TABLE `nuke_pages` (
  `pid` int(10) NOT NULL auto_increment,
  `cid` int(10) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `subtitle` varchar(255) NOT NULL default '',
  `active` int(1) NOT NULL default '0',
  `page_header` text NOT NULL,
  `text` text NOT NULL,
  `page_footer` text NOT NULL,
  `signature` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `counter` int(10) NOT NULL default '0',
  `clanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`pid`),
  KEY `pid` (`pid`),
  KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_pages`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_pages_categories`
#

CREATE TABLE `nuke_pages_categories` (
  `cid` int(10) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`cid`),
  KEY `cid` (`cid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_pages_categories`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_poll_check`
#

CREATE TABLE `nuke_poll_check` (
  `ip` varchar(20) NOT NULL default '',
  `time` varchar(14) NOT NULL default '',
  `pollID` int(10) NOT NULL default '0'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_poll_check`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_poll_data`
#

CREATE TABLE `nuke_poll_data` (
  `pollID` int(11) NOT NULL default '0',
  `optionText` char(50) NOT NULL default '',
  `optionCount` int(11) NOT NULL default '0',
  `voteID` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_poll_data`
#

INSERT INTO `nuke_poll_data` VALUES (1, 'Hmm, nenφ ╣patn²', 0, 1);
INSERT INTO `nuke_poll_data` VALUES (1, 'Skv∞l²', 0, 2);
INSERT INTO `nuke_poll_data` VALUES (1, 'Stra╣n²', 0, 3);
INSERT INTO `nuke_poll_data` VALUES (1, 'Nejlep╣φ!', 0, 4);
INSERT INTO `nuke_poll_data` VALUES (1, 'Co to jako mß b²t?', 0, 5);
INSERT INTO `nuke_poll_data` VALUES (1, '', 0, 6);
INSERT INTO `nuke_poll_data` VALUES (1, '', 0, 7);
INSERT INTO `nuke_poll_data` VALUES (1, '', 0, 8);
INSERT INTO `nuke_poll_data` VALUES (1, '', 0, 9);
INSERT INTO `nuke_poll_data` VALUES (1, '', 0, 10);
INSERT INTO `nuke_poll_data` VALUES (1, '', 0, 11);
INSERT INTO `nuke_poll_data` VALUES (1, '', 0, 12);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_poll_desc`
#

CREATE TABLE `nuke_poll_desc` (
  `pollID` int(11) NOT NULL auto_increment,
  `pollTitle` varchar(100) NOT NULL default '',
  `timeStamp` int(11) NOT NULL default '0',
  `voters` mediumint(9) NOT NULL default '0',
  `planguage` varchar(30) NOT NULL default '',
  `artid` int(10) NOT NULL default '0',
  PRIMARY KEY  (`pollID`),
  KEY `pollID` (`pollID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_poll_desc`
#

INSERT INTO `nuke_poll_desc` VALUES (1, 'Jak² je tento web?', 961405160, 0, 'czech', 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_pollcomments`
#

CREATE TABLE `nuke_pollcomments` (
  `tid` int(11) NOT NULL auto_increment,
  `pid` int(11) NOT NULL default '0',
  `pollID` int(11) NOT NULL default '0',
  `date` datetime default NULL,
  `name` varchar(60) NOT NULL default '',
  `email` varchar(60) default NULL,
  `url` varchar(60) default NULL,
  `host_name` varchar(60) default NULL,
  `subject` varchar(60) NOT NULL default '',
  `comment` text NOT NULL,
  `score` tinyint(4) NOT NULL default '0',
  `reason` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`tid`),
  KEY `tid` (`tid`),
  KEY `pid` (`pid`),
  KEY `pollID` (`pollID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_pollcomments`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_popsettings`
#

CREATE TABLE `nuke_popsettings` (
  `id` int(11) NOT NULL auto_increment,
  `uid` int(11) NOT NULL default '0',
  `account` varchar(50) default '',
  `popserver` varchar(255) default '',
  `port` int(5) default '0',
  `uname` varchar(100) default '',
  `passwd` varchar(20) default '',
  `numshow` int(11) default '0',
  `deletefromserver` char(1) default '',
  `refresh` int(11) default '0',
  `timeout` int(11) default '0',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`),
  KEY `uid` (`uid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_popsettings`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_priv_msgs`
#

CREATE TABLE `nuke_priv_msgs` (
  `msg_id` int(10) NOT NULL auto_increment,
  `msg_image` varchar(100) default NULL,
  `subject` varchar(100) default NULL,
  `from_userid` int(10) NOT NULL default '0',
  `to_userid` int(10) NOT NULL default '0',
  `msg_time` varchar(20) default NULL,
  `msg_text` text,
  `read_msg` tinyint(10) NOT NULL default '0',
  PRIMARY KEY  (`msg_id`),
  KEY `msg_id` (`msg_id`),
  KEY `to_userid` (`to_userid`),
  KEY `from_userid` (`from_userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_priv_msgs`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_public_messages`
#

CREATE TABLE `nuke_public_messages` (
  `mid` int(10) NOT NULL auto_increment,
  `content` varchar(255) NOT NULL default '',
  `date` varchar(14) default NULL,
  `who` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`mid`),
  KEY `mid` (`mid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_public_messages`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_queue`
#

CREATE TABLE `nuke_queue` (
  `qid` smallint(5) unsigned NOT NULL auto_increment,
  `uid` mediumint(9) NOT NULL default '0',
  `uname` varchar(40) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  `story` text,
  `storyext` text NOT NULL,
  `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `topic` varchar(20) NOT NULL default '',
  `alanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`qid`),
  KEY `qid` (`qid`),
  KEY `uid` (`uid`),
  KEY `uname` (`uname`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_queue`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_quotes`
#

CREATE TABLE `nuke_quotes` (
  `qid` int(10) unsigned NOT NULL auto_increment,
  `quote` text,
  PRIMARY KEY  (`qid`),
  KEY `qid` (`qid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_quotes`
#

INSERT INTO `nuke_quotes` VALUES (1, 'Nos morituri te salutamus - CBHS');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_rediract`
#

CREATE TABLE `nuke_rediract` (
  `actuid` int(11) NOT NULL default '0',
  `link` varchar(255) default NULL,
  `impres` int(11) default NULL,
  PRIMARY KEY  (`actuid`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_rediract`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_referer`
#

CREATE TABLE `nuke_referer` (
  `rid` int(11) NOT NULL auto_increment,
  `url` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`rid`),
  KEY `rid` (`rid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_referer`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_related`
#

CREATE TABLE `nuke_related` (
  `rid` int(11) NOT NULL auto_increment,
  `tid` int(11) NOT NULL default '0',
  `name` varchar(30) NOT NULL default '',
  `url` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`rid`),
  KEY `rid` (`rid`),
  KEY `tid` (`tid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_related`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_reviews`
#

CREATE TABLE `nuke_reviews` (
  `id` int(10) NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `title` varchar(150) NOT NULL default '',
  `text` text NOT NULL,
  `reviewer` varchar(20) default NULL,
  `email` varchar(60) default NULL,
  `score` int(10) NOT NULL default '0',
  `cover` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `url_title` varchar(50) NOT NULL default '',
  `hits` int(10) NOT NULL default '0',
  `rlanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_reviews`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_reviews_add`
#

CREATE TABLE `nuke_reviews_add` (
  `id` int(10) NOT NULL auto_increment,
  `date` date default NULL,
  `title` varchar(150) NOT NULL default '',
  `text` text NOT NULL,
  `reviewer` varchar(20) NOT NULL default '',
  `email` varchar(60) default NULL,
  `score` int(10) NOT NULL default '0',
  `url` varchar(100) NOT NULL default '',
  `url_title` varchar(50) NOT NULL default '',
  `rlanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_reviews_add`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_reviews_comments`
#

CREATE TABLE `nuke_reviews_comments` (
  `cid` int(10) NOT NULL auto_increment,
  `rid` int(10) NOT NULL default '0',
  `userid` varchar(25) NOT NULL default '',
  `date` datetime default NULL,
  `comments` text,
  `score` int(10) NOT NULL default '0',
  PRIMARY KEY  (`cid`),
  KEY `cid` (`cid`),
  KEY `rid` (`rid`),
  KEY `userid` (`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_reviews_comments`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_reviews_main`
#

CREATE TABLE `nuke_reviews_main` (
  `title` varchar(100) default NULL,
  `description` text
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_reviews_main`
#

INSERT INTO `nuke_reviews_main` VALUES ('Titulek sekce s recenzemi', 'Podrobn∞j╣φ popis sekce s recenzemi');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_seccont`
#

CREATE TABLE `nuke_seccont` (
  `artid` int(11) NOT NULL auto_increment,
  `secid` int(11) NOT NULL default '0',
  `title` text NOT NULL,
  `content` text NOT NULL,
  `counter` int(11) NOT NULL default '0',
  `slanguage` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`artid`),
  KEY `artid` (`artid`),
  KEY `secid` (`secid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_seccont`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_sections`
#

CREATE TABLE `nuke_sections` (
  `secid` int(11) NOT NULL auto_increment,
  `secname` varchar(40) NOT NULL default '',
  `image` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`secid`),
  KEY `secid` (`secid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_sections`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_session`
#

CREATE TABLE `nuke_session` (
  `uname` varchar(25) NOT NULL default '',
  `time` varchar(14) NOT NULL default '',
  `host_addr` varchar(48) NOT NULL default '',
  `guest` int(1) NOT NULL default '0',
  KEY `time` (`time`),
  KEY `guest` (`guest`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_session`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_access`
#

CREATE TABLE `nuke_splattforum_access` (
  `access_id` int(10) NOT NULL default '0',
  `access_title` varchar(20) default NULL,
  PRIMARY KEY  (`access_id`),
  KEY `access_id` (`access_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_splattforum_access`
#

INSERT INTO `nuke_splattforum_access` VALUES (-1, 'Odstran∞n² u╛ivatel');
INSERT INTO `nuke_splattforum_access` VALUES (1, 'U╛ivatel');
INSERT INTO `nuke_splattforum_access` VALUES (2, 'Moderßtor');
INSERT INTO `nuke_splattforum_access` VALUES (3, 'Super Moderßtor');
INSERT INTO `nuke_splattforum_access` VALUES (4, 'Administrßtor');

# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_catagories`
#

CREATE TABLE `nuke_splattforum_catagories` (
  `cat_id` tinyint(3) unsigned NOT NULL auto_increment,
  `cat_title` varchar(30) default NULL,
  `cat_order` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_id` (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_splattforum_catagories`
#

INSERT INTO `nuke_splattforum_catagories` VALUES (1, 'Kategorie pro otestovßnφ', 1);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_config`
#

CREATE TABLE `nuke_splattforum_config` (
  `allow_html` tinyint(1) NOT NULL default '0',
  `allow_bbcode` tinyint(1) NOT NULL default '0',
  `allow_sig` tinyint(1) NOT NULL default '0',
  `posts_per_page` tinyint(3) unsigned NOT NULL default '0',
  `hot_threshold` tinyint(3) unsigned NOT NULL default '0',
  `topics_per_page` tinyint(3) unsigned NOT NULL default '0',
  `index_head` text,
  `index_foot` text,
  `max_upfile` int(6) NOT NULL default '300',
  `allow_topblock` tinyint(1) NOT NULL default '0',
  `allow_faccine` varchar(20) NOT NULL default '',
  `allow_css` varchar(20) NOT NULL default '',
  `allow_report_abuse` tinyint(1) NOT NULL default '0',
  `allow_seguidisc` tinyint(1) NOT NULL default '0',
  `allow_icons` varchar(20) NOT NULL default '',
  `allow_subject` varchar(20) NOT NULL default '',
  `versione` varchar(10) NOT NULL default '',
  `aspam` tinyint(3) unsigned default NULL
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_splattforum_config`
#

INSERT INTO `nuke_splattforum_config` VALUES (1, 1, 0, 20, 10, 25, 'text zßhlavφ', 'text zßpatφ', 300, 0, 'yellow', 'style-forum.css', 1, 1, 'splatt_blue', 'splatt_blue', '4.2', NULL);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_forums`
#

CREATE TABLE `nuke_splattforum_forums` (
  `forum_id` tinyint(3) unsigned NOT NULL auto_increment,
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_access` tinyint(1) unsigned NOT NULL default '1',
  `cat_id` tinyint(3) unsigned NOT NULL default '0',
  `forum_type` tinyint(1) unsigned NOT NULL default '0',
  `forum_pass` varchar(60) default NULL,
  `forum_notify_email` varchar(30) default NULL,
  `forum_atch` tinyint(1) unsigned NOT NULL default '0',
  `forum_rules` text,
  `image_in_post` tinyint(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`forum_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_splattforum_forums`
#

INSERT INTO `nuke_splattforum_forums` VALUES (1, 'F≤rum pro otestovßnφ', 'Popis f≤ra', 0, 1, 0, '', '', 1, '╪ßd f≤ra', 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_forumtopics`
#

CREATE TABLE `nuke_splattforum_forumtopics` (
  `topic_id` int(10) NOT NULL auto_increment,
  `topic_title` varchar(100) default NULL,
  `topic_poster` int(10) NOT NULL default '0',
  `topic_time` varchar(20) default NULL,
  `topic_views` int(10) NOT NULL default '0',
  `forum_id` tinyint(3) unsigned NOT NULL default '0',
  `topic_status` tinyint(1) unsigned NOT NULL default '0',
  `topic_notify` tinyint(1) unsigned default '0',
  `highlight` tinyint(2) unsigned default NULL,
  PRIMARY KEY  (`topic_id`),
  KEY `topic_poster` (`topic_poster`),
  KEY `topic_time` (`topic_time`),
  KEY `forum_id` (`forum_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_splattforum_forumtopics`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_mods`
#

CREATE TABLE `nuke_splattforum_mods` (
  `forum_id` int(10) NOT NULL default '0',
  `user_id` int(10) NOT NULL default '0',
  KEY `forum_id` (`forum_id`),
  KEY `user_id` (`user_id`)
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_splattforum_mods`
#

INSERT INTO `nuke_splattforum_mods` VALUES (1, 2);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_notifica`
#

CREATE TABLE `nuke_splattforum_notifica` (
  `notifi_id` int(11) NOT NULL auto_increment,
  `topic_id` int(11) NOT NULL default '0',
  `username` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`notifi_id`),
  KEY `topic_id` (`topic_id`,`username`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_splattforum_notifica`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_posts`
#

CREATE TABLE `nuke_splattforum_posts` (
  `post_id` int(10) NOT NULL auto_increment,
  `image` varchar(10) default NULL,
  `topic_id` int(10) NOT NULL default '0',
  `forum_id` tinyint(3) unsigned NOT NULL default '0',
  `poster_id` int(10) default NULL,
  `post_text` text,
  `post_time` varchar(20) default NULL,
  `poster_ip` varchar(16) default NULL,
  PRIMARY KEY  (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_id` (`post_id`),
  KEY `topic_id_2` (`topic_id`),
  KEY `forum_id_2` (`forum_id`),
  KEY `poster_id_2` (`poster_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_splattforum_posts`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_splattforum_ranks`
#

CREATE TABLE `nuke_splattforum_ranks` (
  `rank_id` int(10) NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` int(10) NOT NULL default '0',
  `rank_max` int(10) NOT NULL default '0',
  `rank_special` int(2) default '0',
  `rank_image` varchar(50) default NULL,
  PRIMARY KEY  (`rank_id`),
  KEY `rank_min` (`rank_min`),
  KEY `rank_max` (`rank_max`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_splattforum_ranks`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_stats_date`
#

CREATE TABLE `nuke_stats_date` (
  `year` smallint(6) NOT NULL default '0',
  `month` tinyint(4) NOT NULL default '0',
  `date` tinyint(4) NOT NULL default '0',
  `hits` bigint(20) NOT NULL default '0'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_stats_date`
#

INSERT INTO `nuke_stats_date` VALUES (2003, 1, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 1, 31, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 2, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 3, 31, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 4, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 5, 31, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 6, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 7, 31, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 8, 31, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 9, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 10, 31, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 11, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 1, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 2, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 3, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 4, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 5, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 6, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 7, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 8, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 9, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 10, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 11, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 12, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 13, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 14, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 15, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 16, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 17, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 18, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 19, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 20, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 21, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 22, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 23, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 24, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 25, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 26, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 27, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 28, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 29, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 30, 0);
INSERT INTO `nuke_stats_date` VALUES (2003, 12, 31, 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_stats_hour`
#

CREATE TABLE `nuke_stats_hour` (
  `year` smallint(6) NOT NULL default '0',
  `month` tinyint(4) NOT NULL default '0',
  `date` tinyint(4) NOT NULL default '0',
  `hour` tinyint(4) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_stats_hour`
#

INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 0, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 1, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 2, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 3, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 4, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 5, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 6, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 7, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 8, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 9, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 10, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 11, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 12, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 13, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 14, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 15, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 16, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 17, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 18, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 19, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 20, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 21, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 22, 0);
INSERT INTO `nuke_stats_hour` VALUES (2003, 9, 27, 23, 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_stats_month`
#

CREATE TABLE `nuke_stats_month` (
  `year` smallint(6) NOT NULL default '0',
  `month` tinyint(4) NOT NULL default '0',
  `hits` bigint(20) NOT NULL default '0'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_stats_month`
#

INSERT INTO `nuke_stats_month` VALUES (2003, 1, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 2, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 3, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 4, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 5, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 6, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 7, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 8, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 9, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 10, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 11, 0);
INSERT INTO `nuke_stats_month` VALUES (2003, 12, 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_stats_year`
#

CREATE TABLE `nuke_stats_year` (
  `year` smallint(6) NOT NULL default '0',
  `hits` bigint(20) NOT NULL default '0'
) TYPE=MyISAM;

#
# Vypisuji data pro tabulku `nuke_stats_year`
#

INSERT INTO `nuke_stats_year` VALUES (2003, 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_stories`
#

CREATE TABLE `nuke_stories` (
  `sid` int(11) NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `aid` varchar(30) NOT NULL default '',
  `title` varchar(80) default NULL,
  `time` datetime default NULL,
  `hometext` text,
  `bodytext` text NOT NULL,
  `comments` int(11) default '0',
  `counter` mediumint(8) unsigned default NULL,
  `topic` int(3) NOT NULL default '1',
  `informant` varchar(20) NOT NULL default '',
  `notes` text NOT NULL,
  `ihome` int(1) NOT NULL default '0',
  `alanguage` varchar(30) NOT NULL default '',
  `acomm` int(1) NOT NULL default '0',
  `haspoll` int(1) NOT NULL default '0',
  `pollID` int(10) NOT NULL default '0',
  `score` int(10) NOT NULL default '0',
  `ratings` int(10) NOT NULL default '0',
  `associated` text NOT NULL,
  PRIMARY KEY  (`sid`),
  KEY `sid` (`sid`),
  KEY `catid` (`catid`),
  KEY `counter` (`counter`),
  KEY `topic` (`topic`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_stories`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_stories_cat`
#

CREATE TABLE `nuke_stories_cat` (
  `catid` int(11) NOT NULL auto_increment,
  `title` varchar(20) NOT NULL default '',
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`catid`),
  KEY `catid` (`catid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_stories_cat`
#


# --------------------------------------------------------

#
# Struktura tabulky `nuke_topics`
#

CREATE TABLE `nuke_topics` (
  `topicid` int(3) NOT NULL auto_increment,
  `topicname` varchar(20) default NULL,
  `topicimage` varchar(20) default NULL,
  `topictext` varchar(40) default NULL,
  `counter` int(11) NOT NULL default '0',
  PRIMARY KEY  (`topicid`),
  KEY `topicid` (`topicid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_topics`
#

INSERT INTO `nuke_topics` VALUES (1, 'phpnuke', 'phpnuke.gif', 'UNITED-NUKE', 0);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_users`
#

CREATE TABLE `nuke_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `name` varchar(60) NOT NULL default '',
  `username` varchar(25) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `femail` varchar(255) NOT NULL default '',
  `user_website` varchar(255) NOT NULL default '',
  `user_avatar` varchar(255) NOT NULL default '',
  `user_regdate` varchar(20) NOT NULL default '',
  `user_icq` varchar(15) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_interests` varchar(150) NOT NULL default '',
  `user_sig` varchar(255) default NULL,
  `user_viewemail` tinyint(2) default NULL,
  `user_theme` int(3) default NULL,
  `user_aim` varchar(18) default NULL,
  `user_yim` varchar(25) default NULL,
  `user_msnm` varchar(25) default NULL,
  `user_password` varchar(40) NOT NULL default '',
  `storynum` tinyint(4) NOT NULL default '10',
  `umode` varchar(10) NOT NULL default '',
  `uorder` tinyint(1) NOT NULL default '0',
  `thold` tinyint(1) NOT NULL default '0',
  `noscore` tinyint(1) NOT NULL default '0',
  `bio` tinytext NOT NULL,
  `ublockon` tinyint(1) NOT NULL default '0',
  `ublock` tinytext NOT NULL,
  `theme` varchar(255) NOT NULL default '',
  `commentmax` int(11) NOT NULL default '4096',
  `counter` int(11) NOT NULL default '0',
  `newsletter` int(1) NOT NULL default '0',
  `user_posts` int(10) NOT NULL default '0',
  `user_attachsig` int(2) NOT NULL default '0',
  `user_rank` int(10) NOT NULL default '0',
  `user_level` int(10) NOT NULL default '1',
  `broadcast` tinyint(1) NOT NULL default '1',
  `popmeson` tinyint(1) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_timezone` tinyint(4) NOT NULL default '1',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) NOT NULL default 'czech',
  `user_dateformat` varchar(14) NOT NULL default 'D d. M, Y G:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '0',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_avatar_type` tinyint(4) NOT NULL default '3',
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `uid` (`user_id`),
  KEY `uname` (`username`),
  KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Vypisuji data pro tabulku `nuke_users`
#

INSERT INTO `nuke_users` VALUES (1, '', 'Anonymnφ', '', '', '', 'gallery/blank.gif', 'Nov 10, 2000', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 10, NULL, 'czech', 'D d. M, Y G:i', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 0, 3, NULL, NULL, NULL);

# --------------------------------------------------------

#
# Struktura tabulky `nuke_users_temp`
#

CREATE TABLE `nuke_users_temp` (
  `user_id` int(10) NOT NULL auto_increment,
  `username` varchar(25) NOT NULL default '',
  `user_email` varchar(255) NOT NULL default '',
  `user_password` varchar(40) NOT NULL default '',
  `user_regdate` varchar(20) NOT NULL default '',
  `check_num` varchar(50) NOT NULL default '',
  `time` varchar(14) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Vypisuji data pro tabulku `nuke_users_temp`
#