# ========================================================
#
# Database saved : Nuke
# On 09-12-2003 at 21:44 by God !
#
# ========================================================
# --------------------------------------------------------
#
# Table structure for table 'nuke_access'
#
CREATE TABLE nuke_access (
access_id int(10) NOT NULL auto_increment,
access_title varchar(20),
PRIMARY KEY (access_id)
);
#
# Dumping data for table 'nuke_access'
#
INSERT INTO nuke_access VALUES ( '-1', 'Deleted');
INSERT INTO nuke_access VALUES ( '1', 'User');
INSERT INTO nuke_access VALUES ( '2', 'Moderator');
INSERT INTO nuke_access VALUES ( '3', 'Super Moderator');
INSERT INTO nuke_access VALUES ( '4', 'Administrator');
# --------------------------------------------------------
#
# Table structure for table 'nuke_authors'
#
CREATE TABLE nuke_authors (
aid varchar(25) NOT NULL,
name varchar(50),
url varchar(255) NOT NULL,
email varchar(255) NOT NULL,
pwd varchar(40),
counter int(11) DEFAULT '0' NOT NULL,
radminarticle tinyint(2) DEFAULT '0' NOT NULL,
radmintopic tinyint(2) DEFAULT '0' NOT NULL,
radminuser tinyint(2) DEFAULT '0' NOT NULL,
radminsurvey tinyint(2) DEFAULT '0' NOT NULL,
radminsection tinyint(2) DEFAULT '0' NOT NULL,
radminlink tinyint(2) DEFAULT '0' NOT NULL,
radminephem tinyint(2) DEFAULT '0' NOT NULL,
radminfaq tinyint(2) DEFAULT '0' NOT NULL,
radmindownload tinyint(2) DEFAULT '0' NOT NULL,
radminreviews tinyint(2) DEFAULT '0' NOT NULL,
radminnewsletter tinyint(2) DEFAULT '0' NOT NULL,
radminforum tinyint(2) DEFAULT '0' NOT NULL,
radmincontent tinyint(2) DEFAULT '0' NOT NULL,
radminency tinyint(2) DEFAULT '0' NOT NULL,
radminsuper tinyint(2) DEFAULT '1' NOT NULL,
admlanguage varchar(30) NOT NULL,
PRIMARY KEY (aid)
);
#
# Dumping data for table 'nuke_authors'
#
INSERT INTO nuke_authors VALUES ( 'Admin', 'God', 'http://www.guitarguru777.com', 'guitarguru777@guitarguru777.com', '50bb74ce51a41babf01392b71fcf29a4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '');
INSERT INTO nuke_authors VALUES ( 'guitarguru777', 'guitarguru777', 'http://www.guitarguru777.vom', 'guitarguru777@guitarguru777.com', '50bb74ce51a41babf01392b71fcf29a4', '0', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 'english');
INSERT INTO nuke_authors VALUES ( 'Dark', 'Dark', 'http://www.guitarguru777.com', 'dark_starsxx02@yahoo.com', '1ffd9e753c8054cc61456ac7fac1ac89', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', 'english');
INSERT INTO nuke_authors VALUES ( 'Buzzmaster', 'Buzzmaster', '', 'aceshigh_104@hotmail.com', '4f877911cb49bf0a20d6783a21d9a282', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '1', '0', '1', '1', '1', '0', 'english');
INSERT INTO nuke_authors VALUES ( 'miztec_cetzim', 'miztec_cetzim', '', 'miztec26@aol.com', '39a284b9b0206e7f67a0b706aa7215e4', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '1', '0', '1', '1', '1', '0', 'english');
# --------------------------------------------------------
#
# Table structure for table 'nuke_autonews'
#
CREATE TABLE nuke_autonews (
anid int(11) NOT NULL auto_increment,
catid int(11) DEFAULT '0' NOT NULL,
aid varchar(30) NOT NULL,
title varchar(80) NOT NULL,
time varchar(19) NOT NULL,
hometext text NOT NULL,
bodytext text NOT NULL,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) NOT NULL,
notes text NOT NULL,
ihome int(1) DEFAULT '0' NOT NULL,
alanguage varchar(30) NOT NULL,
acomm int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (anid)
);
#
# Dumping data for table 'nuke_autonews'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_banlist'
#
CREATE TABLE nuke_banlist (
ban_id int(10) NOT NULL auto_increment,
ban_userid int(10),
ban_ip varchar(16),
ban_start int(32),
ban_end int(50),
ban_time_type int(10),
PRIMARY KEY (ban_id),
KEY ban_id (ban_id)
);
#
# Dumping data for table 'nuke_banlist'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_banner'
#
CREATE TABLE nuke_banner (
bid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
imptotal int(11) DEFAULT '0' NOT NULL,
impmade int(11) DEFAULT '0' NOT NULL,
clicks int(11) DEFAULT '0' NOT NULL,
imageurl varchar(100) NOT NULL,
clickurl varchar(200) NOT NULL,
date datetime,
dateend datetime,
type tinyint(1) DEFAULT '0' NOT NULL,
active tinyint(1) DEFAULT '1' NOT NULL,
PRIMARY KEY (bid)
);
#
# Dumping data for table 'nuke_banner'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_bannerclient'
#
CREATE TABLE nuke_bannerclient (
cid int(11) NOT NULL auto_increment,
name varchar(60) NOT NULL,
contact varchar(60) NOT NULL,
email varchar(60) NOT NULL,
login varchar(10) NOT NULL,
passwd varchar(10) NOT NULL,
extrainfo text NOT NULL,
PRIMARY KEY (cid)
);
#
# Dumping data for table 'nuke_bannerclient'
#
INSERT INTO nuke_bannerclient VALUES ( '1', 'Favored Nations', 'Jason', 'fn@favorednations.com', 'favored', 'favored', '');
# --------------------------------------------------------
#
# Table structure for table 'nuke_bbtopics'
#
CREATE TABLE nuke_bbtopics (
topic_id int(10) NOT NULL auto_increment,
topic_title varchar(100),
topic_poster int(10),
topic_time varchar(20),
topic_views int(10) DEFAULT '0' NOT NULL,
topic_replies int(10) DEFAULT '0' NOT NULL,
topic_last_post_id int(10) DEFAULT '0' NOT NULL,
forum_id int(10) DEFAULT '0' NOT NULL,
topic_status int(10) DEFAULT '0' NOT NULL,
topic_notify int(2) DEFAULT '0',
PRIMARY KEY (topic_id),
KEY topic_id (topic_id),
KEY forum_id (forum_id),
KEY topic_last_post_id (topic_last_post_id)
);
#
# Dumping data for table 'nuke_bbtopics'
#
# --------------------------------------------------------
#
# Table structure for table 'nuke_blocks'
#
CREATE TABLE nuke_blocks (
bid int(10) NOT NULL auto_increment,
bkey varchar(15) NOT NULL,
title varchar(60) NOT NULL,
content text NOT NULL,
url varchar(200) NOT NULL,
position char(1) NOT NULL,
weight int(10) DEFAULT '1' NOT NULL,
active int(1) DEFAULT '1' NOT NULL,
refresh int(10) DEFAULT '0' NOT NULL,
time varchar(14) DEFAULT '0' NOT NULL,
blanguage varchar(30) NOT NULL,
blockfile varchar(255) NOT NULL,
view int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (bid)
);
#
# Dumping data for table 'nuke_blocks'
#
INSERT INTO nuke_blocks VALUES ( '1', '', 'Modules', '', '', 'c', '6', '1', '0', '', '', 'block-Modules.php', '2');
INSERT INTO nuke_blocks VALUES ( '2', 'admin', 'Administration', '·Administration ·NEW Story ·Change Survey ·Content ·Logout', '', 'l', '7', '1', '0', '985591188', '', '', '2');
INSERT INTO nuke_blocks VALUES ( '3', '', 'Who\'s Online', '', '', 'r', '2', '0', '0', '', '', 'block-Who_is_Online.php', '0');
INSERT INTO nuke_blocks VALUES ( '4', '', 'Search', '', '', 'l', '5', '0', '3600', '', '', 'block-Search.php', '0');
INSERT INTO nuke_blocks VALUES ( '5', '', 'Languages', '', '', 'r', '5', '0', '0', '', '', 'block-Languages.php', '0');
INSERT INTO nuke_blocks VALUES ( '6', '', 'Random Headlines', '', '', 'l', '8', '0', '3600', '', '', 'block-Random_Headlines.php', '0');
INSERT INTO nuke_blocks VALUES ( '7', '', 'Amazon', '', '', 'l', '9', '0', '3600', '', '', 'block-Amazon.php', '0');
INSERT INTO nuke_blocks VALUES ( '8', 'userbox', 'User\'s Custom Box', '', '', 'r', '6', '0', '0', '', '', '', '1');
INSERT INTO nuke_blocks VALUES ( '9', '', 'Categories Menu', '', '', 'r', '7', '0', '0', '', '', 'block-Categories.php', '0');
INSERT INTO nuke_blocks VALUES ( '10', '', 'Survey', '', '', 'r', '4', '0', '3600', '', '', 'block-Survey.php', '0');
INSERT INTO nuke_blocks VALUES ( '11', '', 'Login', '', '', 'r', '1', '1', '0', '', '', 'block-Login.php', '0');
INSERT INTO nuke_blocks VALUES ( '12', '', 'Big Story of Today', '', '', 'r', '8', '0', '3600', '', '', 'block-Big_Story_of_Today.php', '0');
INSERT INTO nuke_blocks VALUES ( '13', '', 'Old Articles', '', '', 'r', '9', '0', '3600', '', '', 'block-Old_Articles.php', '0');
INSERT INTO nuke_blocks VALUES ( '14', '', 'Information', 'Website owned and operated by
JASON COHEN
aka
Guitarguru777.
If you have any questions or comments you can contact Jason Here', '', 'l', '6', '1', '0', '', '', '', '0');
INSERT INTO nuke_blocks VALUES ( '16', '', 'Affiliations', '
Musicians Friend
The Largest Online Music Store Has Signed Up With Us As An Affiliate.
We Can Now Link You Directly From Our Site To Theirs, For You To Purchase Items We Review Here.
Click Here To Visit Musicians Friend
FAVORED NATIONS RECORDS
Together we will bring to you some of the best talent on the face of the planet, as well as some of the old favorites you have always enjoyed.
Reach more than 1000 users a month, by advertising here on Guitarguru777.com, Spread the word about your website, or services.
Through our affilite program you will be reaching thousands of prospective viewers, looking for your services and you.
For more information E-mail Guitarguru777@guitarguru777.com