# phpMyAdmin MySQL-Dump
# version 2.4.0-rc2
# http://www.phpmyadmin.net/ (download page)
#
# מארח: localhost
# זמן יצירה: יוני 28, 2003 at 11:16 PM
# גרסת שרת: 3.23.47
# גרסת PHP: 4.1.2
# מסד נתונים : `heb17test`
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_authors`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_autonews`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_banner`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bannerclient`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbauth_access`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbbanlist`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbcategories`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbconfig`
#

INSERT INTO nuke_bbconfig VALUES ('config_id', '1');
INSERT INTO nuke_bbconfig VALUES ('board_disable', '0');
INSERT INTO nuke_bbconfig VALUES ('sitename', 'MySite.com');
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', 'MySite.com');
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', 'Thanks, [email protected]');
INSERT INTO nuke_bbconfig VALUES ('board_email', '[email protected]');
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', 'G:i ,j F Y');
INSERT INTO nuke_bbconfig VALUES ('board_timezone', '2');
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', 'hebrew');
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', 'MySite.com');
INSERT INTO nuke_bbconfig VALUES ('server_port', '80');
INSERT INTO nuke_bbconfig VALUES ('script_path', '/modules/Forums/');
INSERT INTO nuke_bbconfig VALUES ('version', '.0.4');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbdisallow`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbforum_prune`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbforums`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbgroups`
#

INSERT INTO nuke_bbgroups VALUES (1, 1, 'אנונימי', 'משתמש פרטי', 0, 1);
INSERT INTO nuke_bbgroups VALUES (3, 2, 'אחראים', 'אחראים על פורום זה', 5, 0);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbposts`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbposts_text`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbprivmsgs`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbprivmsgs_text`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbranks`
#

INSERT INTO nuke_bbranks VALUES (1, 'מנהל האתר', -1, -1, 1, 'modules/Forums/images/ranks/6stars.gif');
INSERT INTO nuke_bbranks VALUES (2, 'חדש', 1, 0, 0, 'modules/Forums/images/ranks/1star.gif');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbsearch_results`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbsearch_wordlist`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbsearch_wordmatch`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbsessions`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbsmilies`
#

INSERT INTO nuke_bbsmilies VALUES (1, ':D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO nuke_bbsmilies VALUES (2, ':-D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO nuke_bbsmilies VALUES (3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO nuke_bbsmilies VALUES (4, '', 'icon_smile.gif', 'Smile');
INSERT INTO nuke_bbsmilies VALUES (5, ':-)', 'icon_smile.gif', 'Smile');
INSERT INTO nuke_bbsmilies VALUES (6, ':smile:', 'icon_smile.gif', 'Smile');
INSERT INTO nuke_bbsmilies VALUES (7, ':(', 'icon_sad.gif', 'Sad');
INSERT INTO nuke_bbsmilies VALUES (8, ':-(', 'icon_sad.gif', 'Sad');
INSERT INTO nuke_bbsmilies VALUES (9, ':sad:', 'icon_sad.gif', 'Sad');
INSERT INTO nuke_bbsmilies VALUES (10, ':o', 'icon_surprised.gif', 'Surprised');
INSERT INTO nuke_bbsmilies VALUES (11, ':-o', 'icon_surprised.gif', 'Surprised');
INSERT INTO nuke_bbsmilies VALUES (12, ':eek:', 'icon_surprised.gif', 'Surprised');
INSERT INTO nuke_bbsmilies VALUES (13, '8O', 'icon_eek.gif', 'Shocked');
INSERT INTO nuke_bbsmilies VALUES (14, '8-O', 'icon_eek.gif', 'Shocked');
INSERT INTO nuke_bbsmilies VALUES (15, ':shock:', 'icon_eek.gif', 'Shocked');
INSERT INTO nuke_bbsmilies VALUES (16, ':?', 'icon_confused.gif', 'Confused');
INSERT INTO nuke_bbsmilies VALUES (17, ':-?', 'icon_confused.gif', 'Confused');
INSERT INTO nuke_bbsmilies VALUES (18, ':???:', 'icon_confused.gif', 'Confused');
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', 'Laughing');
INSERT INTO nuke_bbsmilies VALUES (23, ':x', 'icon_mad.gif', 'Mad');
INSERT INTO nuke_bbsmilies VALUES (24, ':-x', 'icon_mad.gif', 'Mad');
INSERT INTO nuke_bbsmilies VALUES (25, ':mad:', 'icon_mad.gif', 'Mad');
INSERT INTO nuke_bbsmilies VALUES (26, ':P', 'icon_razz.gif', 'Razz');
INSERT INTO nuke_bbsmilies VALUES (27, ':-P', 'icon_razz.gif', 'Razz');
INSERT INTO nuke_bbsmilies VALUES (28, ':razz:', 'icon_razz.gif', 'Razz');
INSERT INTO nuke_bbsmilies VALUES (29, ':oops:', 'icon_redface.gif', 'Embarassed');
INSERT INTO nuke_bbsmilies VALUES (30, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
INSERT INTO nuke_bbsmilies VALUES (31, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
INSERT INTO nuke_bbsmilies VALUES (32, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
INSERT INTO nuke_bbsmilies VALUES (33, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
INSERT INTO nuke_bbsmilies VALUES (34, ':wink:', 'icon_wink.gif', 'Wink');
INSERT INTO nuke_bbsmilies VALUES (35, ';)', 'icon_wink.gif', 'Wink');
INSERT INTO nuke_bbsmilies VALUES (36, ';-)', 'icon_wink.gif', 'Wink');
INSERT INTO nuke_bbsmilies VALUES (37, ':!:', 'icon_exclaim.gif', 'Exclamation');
INSERT INTO nuke_bbsmilies VALUES (38, ':?:', 'icon_question.gif', 'Question');
INSERT INTO nuke_bbsmilies VALUES (39, ':idea:', 'icon_idea.gif', 'Idea');
INSERT INTO nuke_bbsmilies VALUES (40, ':arrow:', 'icon_arrow.gif', 'Arrow');
INSERT INTO nuke_bbsmilies VALUES (41, ':|', 'icon_neutral.gif', 'Neutral');
INSERT INTO nuke_bbsmilies VALUES (42, ':-|', 'icon_neutral.gif', 'Neutral');
INSERT INTO nuke_bbsmilies VALUES (43, ':neutral:', 'icon_neutral.gif', 'Neutral');
INSERT INTO nuke_bbsmilies VALUES (44, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `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);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbthemes_name`
#

INSERT INTO nuke_bbthemes_name VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbtopics`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbtopics_watch`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbuser_group`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbvote_desc`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbvote_results`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbvote_voters`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_bbwords`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_blocks`
#

INSERT INTO nuke_blocks VALUES (1, '', 'אפשרויות באתר', '', '', 'l', 2, 1, 0, '', '', 'block-Modules.php', 0);
INSERT INTO nuke_blocks VALUES (2, 'admin', 'ניהול', '<b><big>·</big></b> <a href="admin.php">פאנל ניהול</a><br>\r\n<b><big>·</big></b> <a href="admin.php?op=adminStory">הוסף מאמר</a><br>\r\n<b><big>·</big></b> <a href="admin.php?op=create">שנה סקר</a><br>\r\n<b><big>·</big></b> <a href="admin.php?op=content">תוכן</a><br>\r\n<b><big>·</big></b> <a href="admin.php?op=logout">התנתק</a>', '', 'l', 3, 1, 0, '985591188', '', '', 2);
INSERT INTO nuke_blocks VALUES (3, '', 'מי מחובר', '', '', 'l', 4, 1, 0, '', '', 'block-Who_is_Online.php', 0);
INSERT INTO nuke_blocks VALUES (4, '', 'חיפוש', '', '', 'l', 5, 0, 0, '', '', 'block-Search.php', 0);
INSERT INTO nuke_blocks VALUES (15, '', 'תפריט', '<b><big>·</big></b><b> תפריט ראשי</b></a><br>\r\n<b><big>·</big></b> <a href="index.php">דף הבית</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Topics">נושאי האתר</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Sections">אזורים</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Stories_Archive">ארכיון כתבות</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Downloads">הורדות</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=FAQ">שאלות נפוצות - FAQ</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Web_Links">קישורים</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Content">תוכן</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Reviews">סיקורים</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Forums">פורומים</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Statistics">סטטיסטיקות</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Surveys">סקרים</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Top">עשרת המובחרים</a><br>\r\n<br>\r\n<b><big>·</big></b><b> חשבון המשתמש</b></a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Your_Account">החשבון שלי</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Submit_News">שלח כתבה/מאמר</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Recommend_Us">המלץ עלינו</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Journal">יומן</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Private_Messages">הודעות פרטיות</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Members_List">רשימת חברים</a><br>\r\n<br>\r\n<b><big>·</big></b><b> אפשרויות באתר</b></a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=AvantGo">הדפסת כתבות</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Feedback">משוב</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=WebMail">דואר אלקטרוני</a><br>\r\n<b><big>·</big></b> <a href="modules.php?name=Search">חיפוש</a><br>\r\n<b><big>·</big></b> <a href="admin.php">ניהול</a><br>', '', 'l', 1, 1, 0, '', '', '', 0);
INSERT INTO nuke_blocks VALUES (8, 'userbox', 'תפריט אישי', '', '', 'r', 1, 1, 0, '', '', '', 1);
INSERT INTO nuke_blocks VALUES (9, '', 'קטגוריות', '', '', 'r', 2, 0, 0, '', '', 'block-Categories.php', 0);
INSERT INTO nuke_blocks VALUES (10, '', 'סקר', '', '', 'r', 3, 1, 0, '', '', 'block-Survey.php', 0);
INSERT INTO nuke_blocks VALUES (11, '', 'התחברות', '', '', 'r', 4, 1, 0, '', '', 'block-Login.php', 3);
INSERT INTO nuke_blocks VALUES (12, '', 'הסיפור הגדול !', '', '', 'r', 5, 1, 0, '', '', 'block-Big_Story_of_Today.php', 0);
INSERT INTO nuke_blocks VALUES (13, '', 'מאמרים ישנים', '', '', 'r', 6, 1, 0, '', '', 'block-Old_Articles.php', 0);
INSERT INTO nuke_blocks VALUES (14, '', 'מידע', '<br><center><font class="content">\r\n<a href="http://www.hebnuker.org"><img src="images/powered/hebnuker.gif" width="88" height="31" alt="מופעל על ידי HebNukeR" title="מופעל על ידי HebNukeR" border="0"></a>\r\n<br><br>\r\n<a href="http://phpnuke.org"><img src="images/powered/nuke.gif" border="0" alt="Powered by PHP-Nuke" title="Powered by PHP-Nuke" width="88" height="31"></a>\r\n<br><br>\r\n<a href="http://www.ototoy.com"><img src="images/powered/ototoy.gif" width="88" height="31" alt="oToToY" title="oToToY" border="0"></a></font></center><br>', '', 'r', 7, 1, 0, '', '', '', 0);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_comments`
#

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

#
# מבנה טבלה לטבלה `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(10) 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;

#
# הזרם מידע לטבלה `nuke_config`
#

INSERT INTO nuke_config VALUES ('HebNukeR Powered Web Site', 'http://www.your-site-name.com', 'logo.gif', 'הניוקר-S הישראלים !', '01/07/03', '[email protected]', 0, 'DeepBlue', 'כל התמונות והסמלים המסחריים אשר באתר זה שייכים לבעלייהם החוקיים. הערות המשתמש שיכות להם וצוות האתר אינו אחראי עליהם. כל שאר התוכן אשר נמצא באתר שייך על פי חוק לצוות האתר © 2002 - 2003.', '', '', 4096, 'אנונימי', 5, 1, 1, 1, 1, 10, 10, 1, 30, 0, 1, 'Site Name', 'he-il', 'hebrew', 'he_IL', 0, 0, 0, '[email protected]', 'הגשות באתר שלך', 'חדשות הגיעו לאתרי !', 'webmaster', 'דואר אלקטרוני זה נשלח על ידי שירות לחברים רשומים באתרyour-site בלבד !\r\nhttp://www.your-site.com', 1, '/var/www/html/modules/WebMail/tmp/', 0, 0, 'modules/WebMail/attachments/', '', 0, 'החשבון שלי', -1, 'modules/WebMail/images', 1, 0, 1, 1, 1000, 3, '*', 'אתר זה מופעל על \r\nידי מערכת <a href="http://www.hebnuker.org" target="_blank">HebNukeR \r\nv1.7</a> אשר מבוססת על \r\nמערכת <a href="http://www.phpnuke.org" target="_blank">PhpNuke v6.7</a><br><a \r\nhref="http://www.hebnuker.org" target="_blank"><img src="http://www.hebnuker.org/images/hebnuker.gif" \r\nborder="0"></a> <a href="http://www.ototoy.com" target="_blank"><img \r\nsrc="http://www.hebnuker.org/images/ototoy.gif" border="0"></a> <a href="http://www.phpnuke.org" \r\ntarget="_blank"><img src="http://www.hebnuker.org/images/phpnuke.gif" border="0"></a><br>כל הזכויות שמורות ©', '6.7');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_contactbook`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_counter`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_downloads_categories`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_downloads_downloads`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_downloads_editorials`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_downloads_modrequest`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_downloads_newdownload`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_downloads_votedata`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_encyclopedia`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_encyclopedia_text`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_ephem`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_faqAnswer`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_faqCategories`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_headlines`
#

INSERT INTO nuke_headlines VALUES (1, 'PHP-Nuke', 'http://phpnuke.org/backend.php');
INSERT INTO nuke_headlines VALUES (2, 'LinuxCentral', 'http://linuxcentral.com/backend/lcnew.rdf');
INSERT INTO nuke_headlines VALUES (3, 'NewsForge', 'http://www.newsforge.com/newsforge.rdf');
INSERT INTO nuke_headlines VALUES (4, 'PHPBuilder', 'http://phpbuilder.com/rss_feed.php');
INSERT INTO nuke_headlines VALUES (5, 'PHP-Nuke Espaסol', 'http://phpnuke-espanol.org/backend.php');
INSERT INTO nuke_headlines VALUES (6, 'Freshmeat', 'http://freshmeat.net/backend/fm.rdf');
INSERT INTO nuke_headlines VALUES (7, 'LinuxWeelyNews', 'http://lwn.net/headlines/rss');
INSERT INTO nuke_headlines VALUES (8, 'HappyPenguin', 'http://happypenguin.org/html/news.rdf');
INSERT INTO nuke_headlines VALUES (9, 'BrunchingShuttlecocks', 'http://www.brunching.com/brunching.rdf');
INSERT INTO nuke_headlines VALUES (10, 'MozillaNewsBot', 'http://www.mozilla.org/newsbot/newsbot.rdf');
INSERT INTO nuke_headlines VALUES (11, 'AbsoluteGames', 'http://files.gameaholic.com/agfa.rdf');
INSERT INTO nuke_headlines VALUES (12, 'HollywoodBitchslap', 'http://hollywoodbitchslap.com/hbs.rdf');
INSERT INTO nuke_headlines VALUES (13, 'Listology', 'http://listology.com/recent.rdf');
INSERT INTO nuke_headlines VALUES (14, 'PDABuzz', 'http://www.pdabuzz.com/netscape.txt');
INSERT INTO nuke_headlines VALUES (15, 'TheNextLevel', 'http://www.the-nextlevel.com/rdf/tnl.rdf');
INSERT INTO nuke_headlines VALUES (16, 'Gnome Desktop', 'http://www.gnomedesktop.org/backend.php');
INSERT INTO nuke_headlines VALUES (17, 'DailyDaemonNews', 'http://daily.daemonnews.org/ddn.rdf.php3');
INSERT INTO nuke_headlines VALUES (18, 'PerlMonks', 'http://www.perlmonks.org/headlines.rdf');
INSERT INTO nuke_headlines VALUES (19, 'BSDToday', 'http://www.bsdtoday.com/backend/bt.rdf');
INSERT INTO nuke_headlines VALUES (20, 'DotKDE', 'http://dot.kde.org/rdf');
INSERT INTO nuke_headlines VALUES (21, 'DigitalTheatre', 'http://www.dtheatre.com/backend.php3?xml=yes');
INSERT INTO nuke_headlines VALUES (22, 'WebReference', 'http://webreference.com/webreference.rdf');
INSERT INTO nuke_headlines VALUES (23, 'FreeDOS', 'http://www.freedos.org/channels/rss.cgi');
INSERT INTO nuke_headlines VALUES (24, 'PHP.net', 'http://www.php.net/news.rss');
INSERT INTO nuke_headlines VALUES (25, 'LinuxJournal', 'http://www.linuxjournal.com/news.rss');
INSERT INTO nuke_headlines VALUES (26, 'ComputerCops', 'http://www.computercops.com/backend.php');
INSERT INTO nuke_headlines VALUES (27, 'NukeCops', 'http://www.nukecops.com/backend.php');
INSERT INTO nuke_headlines VALUES (28, 'Learning Linux', 'http://www.learninglinux.com/backend.php');
INSERT INTO nuke_headlines VALUES (29, 'Nuke Resources', 'http://www.nukeresources.com/backend.php');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_journal`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_journal_comments`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_journal_stats`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_links_categories`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_links_editorials`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_links_links`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_links_modrequest`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_links_newlink`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_links_votedata`
#

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

#
# מבנה טבלה לטבלה `nuke_main`
#

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

#
# הזרם מידע לטבלה `nuke_main`
#

INSERT INTO nuke_main VALUES ('News');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_message`
#

INSERT INTO nuke_message VALUES (1, 'ברוך הבא אל HebNukeR 1.7 !', 'מזל \r\nטוב יש לכם פורטל מותקן מסוג HebNukeR 1.7 !. אתם יכולים לשנות את ההודעה כאן \r\nב<a href="admin.php">פאנל ניהול</a>.\r\n<br><br>\r\nהמערכת נבנתה ע"י <a \r\nhref="http://www.hebnuker.org" target="_blank">HebNukeR</a> בשיתוף עם האתר \r\n<a \r\nhref="http://www.ototoy.com" \r\ntarget="_blank">oToToY.com</a><br>\r\n<center><b>מסיבות אבטחה רצוי ליצור \r\nמשתמש על עם הרשאה מתאימה<a href="admin.php"> לחץ כאן \r\n</a></b></center>\r\n<br><br>תוכל גם ליצור משתמש רגיל באותו עמוד. (מומלץ \r\n!)\r\nצוות HebNukeR מקווה שתהנו במערכת על ידי שימוש בה וכן תואילו לדווח לו \r\nעל כל באג שתתקלו בו.\r\n<br><br>\r\nHebNukeR היא מערכת מתקדמת <i>וחכמה</i> \r\nלניהול תוכן,שנבנתה במאמצים מרובים ,וכן מכילה קהילת משתמשים גדולה מאד . \r\n(משתמשים ומתכנתים) המחכים לך שתצטרף למהפכה החדשה ב-<a \r\nhref="http://www.hebnuker.org">http://www.hebnuker.org</a> היכן שתוכל \r\nלמצא מודולים / תוספים,ערכות ,בלוקים, גרפיקה,עזרים \r\nועוד...\r\nגם כן, ניתן למצוא באתר הרשמי www.HebNukeR.org, מדריך שלם למערכת הנקרא המדריך השלם לפורייקט HebNukeR.\r\n<br><br>\r\nתודה לך על התמיכה ועל הבחירה שלך ב- HebNukeR מקווים \r\nשתהנה מהמערכת .\r\n<br><br>\r\n<center>\r\n<a \r\nhref="http://www.hebnuker.org"><img \r\nsrc="http://www.hebnuker.org/images/HebNukeR_small.gif" \r\nborder="0"></a>\r\n</cneter>', '993373194', 0, 1, 1, '');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_modules`
#

INSERT INTO nuke_modules VALUES (1, 'AvantGo', 'הדפסת כתבות', 1, 0, 1);
INSERT INTO nuke_modules VALUES (2, 'Downloads', 'הורדות', 1, 1, 1);
INSERT INTO nuke_modules VALUES (3, 'Feedback', 'משוב', 1, 0, 1);
INSERT INTO nuke_modules VALUES (4, 'Journal', 'יומן מסע', 1, 0, 1);
INSERT INTO nuke_modules VALUES (5, 'News', 'חדשות', 1, 0, 1);
INSERT INTO nuke_modules VALUES (6, 'Private_Messages', 'הודעות פרטיות', 1, 0, 1);
INSERT INTO nuke_modules VALUES (7, 'Recommend_Us', 'המלץ עלינו', 1, 0, 1);
INSERT INTO nuke_modules VALUES (8, 'Search', 'חיפוש', 1, 0, 1);
INSERT INTO nuke_modules VALUES (9, 'Statistics', 'סטטיסטיקות', 1, 0, 1);
INSERT INTO nuke_modules VALUES (10, 'Stories_Archive', 'ארכיון כתבות', 1, 0, 1);
INSERT INTO nuke_modules VALUES (11, 'Submit_News', 'שלח חדשות', 1, 0, 1);
INSERT INTO nuke_modules VALUES (12, 'Surveys', 'סקרים', 1, 0, 1);
INSERT INTO nuke_modules VALUES (13, 'Top', 'עשרת המובחרים', 1, 0, 1);
INSERT INTO nuke_modules VALUES (14, 'Topics', 'נושאי האתר', 1, 0, 1);
INSERT INTO nuke_modules VALUES (15, 'Web_Links', 'קישורים', 1, 0, 1);
INSERT INTO nuke_modules VALUES (16, 'WebMail', 'דואר אלקטרוני', 1, 1, 1);
INSERT INTO nuke_modules VALUES (17, 'Your_Account', 'החשבון שלי', 1, 0, 1);
INSERT INTO nuke_modules VALUES (19, 'Content', 'תוכן', 1, 1, 1);
INSERT INTO nuke_modules VALUES (20, 'Encyclopedia', 'אינציקלופדיה', 1, 0, 1);
INSERT INTO nuke_modules VALUES (21, 'FAQ', 'שאלות ותשובות', 1, 0, 1);
INSERT INTO nuke_modules VALUES (22, 'Forums', 'פורומים', 1, 0, 1);
INSERT INTO nuke_modules VALUES (23, 'Members_List', 'רשימת חברים', 1, 1, 1);
INSERT INTO nuke_modules VALUES (24, 'Reviews', 'סיקורים', 1, 0, 1);
INSERT INTO nuke_modules VALUES (25, 'Sections', 'אזורים', 1, 1, 1);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_pages`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_pages_categories`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_poll_check`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_poll_data`
#

INSERT INTO nuke_poll_data VALUES (1, 'אמממממ, לא רע...', 0, 1);
INSERT INTO nuke_poll_data VALUES (1, 'מגניב', 0, 2);
INSERT INTO nuke_poll_data VALUES (1, 'מזעזע', 0, 3);
INSERT INTO nuke_poll_data VALUES (1, 'הדבר הטוב ביותר !', 0, 4);
INSERT INTO nuke_poll_data VALUES (1, 'מה לכל הרוחות זה ?', 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);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_poll_desc`
#

INSERT INTO nuke_poll_desc VALUES (1, 'מה אתה חושב על המערכת HebNukeR 1.7 ?', 961405160, 0, 'hebrew', 0);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_pollcomments`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_popsettings`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_priv_msgs`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_public_messages`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_queue`
#

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

#
# מבנה טבלה לטבלה `nuke_quotes`
#

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

#
# הזרם מידע לטבלה `nuke_quotes`
#

INSERT INTO nuke_quotes VALUES (1, 'ברכות לרגל פתיחת אתרך - מצוות HebNukeR');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_referer`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_related`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_reviews`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_reviews_add`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_reviews_comments`
#

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

#
# מבנה טבלה לטבלה `nuke_reviews_main`
#

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

#
# הזרם מידע לטבלה `nuke_reviews_main`
#

INSERT INTO nuke_reviews_main VALUES ('כותרת אזור הסיקורים', 'אזור הסיקורים הסבר מפורט יותר');
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_seccont`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_sections`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_session`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `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, 9);
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);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_stats_hour`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `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, 9);
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);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `nuke_stats_year`
#

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

#
# הזרם מידע לטבלה `nuke_stats_year`
#

INSERT INTO nuke_stats_year VALUES (2003, 9);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_stories`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_stories_cat`
#

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

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_topics`
#

INSERT INTO nuke_topics VALUES (1, 'HebNukeR', 'HebNukeR.gif', 'HebNukeR', 0);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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 '2',
user_style tinyint(4) default NULL,
user_lang varchar(255) NOT NULL default 'hebrew',
user_dateformat varchar(14) NOT NULL default 'G:i ,j F Y',
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;

#
# הזרם מידע לטבלה `nuke_users`
#

INSERT INTO nuke_users VALUES (1, '', 'אנונימי', '', '', '', 'blank.gif', '1 ,יולי 2003', '', '', '', '', '', 0, 0, '', '', '', '', 10, '', 0, 0, 0, '', 0, '', '', 4096, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 10, NULL, 'hebrew', 'G:i ,j F Y', 0, 0, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 0, 3, NULL, NULL, NULL);
# --------------------------------------------------------

#
# מבנה טבלה לטבלה `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;

#
# הזרם מידע לטבלה `nuke_users_temp`
#

$dbhost = "localhost";
$dbuname = "securityalert";
$dbpass = "vmj0uvz.";
$dbname = "securityalert";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "jhuihvr454445646eiuvre";