COME ONE!! PLEASE!!!!
-----Original Message-----
From: Manesh Manickam [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 4:39 PM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] My SQL
How do i add these table, the file is called nuke.sql
when i run it, it just shows as text. i use IIS5
CREATE TABLE access (
access_id int(10) NOT NULL auto_increment,
access_title varchar(20),
PRIMARY KEY (access_id)
);
#
# Dumping data for table 'access'
#
INSERT INTO access VALUES (1,'User');
INSERT INTO access VALUES (2,'Moderator');
INSERT INTO access VALUES (3,'Super Moderator');
#
# Table structure for table 'adminblock'
#
CREATE TABLE adminblock (
title varchar(60),
content text
);
#
# Dumping data for table 'adminblock'
#
INSERT INTO adminblock VALUES ('Administration','Admins can have its own
box, but just one. Who need more?<br>\r\nAdd the options you like. This box
will appear only if you\r\nhas been logged like Admin. No others users can
view this.<br>\r\n<li><a href=admin.php>Administration</a>\r\n<li><a
href=admin.php?op=logout>Logout</a>');
#
# Table structure for table 'authors'
#
CREATE TABLE authors (
aid varchar(30) DEFAULT '' NOT NULL,
name varchar(50),
url varchar(60),
email varchar(60),
pwd varchar(13),
counter int(11) DEFAULT '0' NOT NULL,
radminarticle tinyint(2) DEFAULT '0' NOT NULL,
radmintopic tinyint(2) DEFAULT '0' NOT NULL,
radminleft tinyint(2) DEFAULT '0' NOT NULL,
radminright tinyint(2) DEFAULT '0' NOT NULL,
radminuser tinyint(2) DEFAULT '0' NOT NULL,
radminmain 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,
radminfilem tinyint(2) DEFAULT '0' NOT NULL,
radminhead tinyint(2) DEFAULT '0' NOT NULL,
radminfaq tinyint(2) DEFAULT '0' NOT NULL,
radmindownload tinyint(2) DEFAULT '0' NOT NULL,
radminforum tinyint(2) DEFAULT '0' NOT NULL,
radminreviews tinyint(2) DEFAULT '0' NOT NULL,
radminsuper tinyint(2) DEFAULT '1' NOT NULL,
PRIMARY KEY (aid)
);
#
# Dumping data for table 'authors'
#
INSERT INTO authors VALUES
('God','God','http://phpnuke.org','http://phpnuke.org','Password',1,0,0,0,0,
0,0,0,0,0,0,0,0,0,0,0,0,1);
#
# Table structure for table 'autonews'
#
CREATE TABLE autonews (
anid int(11) NOT NULL auto_increment,
catid int(11) DEFAULT '0' NOT NULL,
aid varchar(30) DEFAULT '' NOT NULL,
title varchar(80) DEFAULT '' NOT NULL,
time varchar(19) DEFAULT '' NOT NULL,
hometext text DEFAULT '' NOT NULL,
bodytext text DEFAULT '' NOT NULL,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) DEFAULT '' NOT NULL,
notes text DEFAULT '' NOT NULL,
ihome int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (anid)
);
#
# Dumping data for table 'autonews'
#
#
# Table structure for table 'banner'
#
CREATE TABLE 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) DEFAULT '' NOT NULL,
clickurl varchar(200) DEFAULT '' NOT NULL,
date datetime,
PRIMARY KEY (bid)
);
#
# Dumping data for table 'banner'
#
#
# Table structure for table 'bannerclient'
#
CREATE TABLE bannerclient (
cid int(11) NOT NULL auto_increment,
name varchar(60) DEFAULT '' NOT NULL,
contact varchar(60) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
login varchar(10) DEFAULT '' NOT NULL,
passwd varchar(10) DEFAULT '' NOT NULL,
extrainfo text DEFAULT '' NOT NULL,
PRIMARY KEY (cid)
);
#
# Dumping data for table 'bannerclient'
#
#
# Table structure for table 'bannerfinish'
#
CREATE TABLE bannerfinish (
bid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
impressions int(11) DEFAULT '0' NOT NULL,
clicks int(11) DEFAULT '0' NOT NULL,
datestart datetime,
dateend datetime,
PRIMARY KEY (bid)
);
#
# Dumping data for table 'bannerfinish'
#
#
# Table structure for table 'catagories'
#
CREATE TABLE catagories (
cat_id int(10) NOT NULL auto_increment,
cat_title varchar(100),
PRIMARY KEY (cat_id)
);
#
# Dumping data for table 'catagories'
#
#
# Table structure for table 'comments'
#
CREATE TABLE comments (
tid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0',
sid int(11) DEFAULT '0',
date datetime,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60),
url varchar(60),
host_name varchar(60),
subject varchar(85) DEFAULT '' NOT NULL,
comment text DEFAULT '' NOT NULL,
score tinyint(4) DEFAULT '0' NOT NULL,
reason tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (tid)
);
#
# Dumping data for table 'comments'
#
INSERT INTO comments VALUES (1,0,1,'2000-12-04
12:00:00','','','','150.10.10.10','Re: Welcome to PHP-Nuke 4.3','FIRST
COMMENT!\r<br>\n\r<br>\nAll my life I wanted to do this ;)',0,0);
#
# Table structure for table 'config'
#
CREATE TABLE config (
allow_html int(2),
allow_bbcode int(2),
allow_sig int(2),
posts_per_page int(10),
hot_threshold int(10),
topics_per_page int(10)
);
#
# Dumping data for table 'config'
#
INSERT INTO config VALUES (1,1,1,10,10,10);
#
# Table structure for table 'counter'
#
CREATE TABLE counter (
type varchar(80) DEFAULT '' NOT NULL,
var varchar(80) DEFAULT '' NOT NULL,
count int(10) unsigned DEFAULT '0' NOT NULL
);
#
# Dumping data for table 'counter'
#
INSERT INTO counter VALUES ('total','hits',1);
INSERT INTO counter VALUES ('browser','WebTV',0);
INSERT INTO counter VALUES ('browser','Lynx',0);
INSERT INTO counter VALUES ('browser','MSIE',0);
INSERT INTO counter VALUES ('browser','Opera',0);
INSERT INTO counter VALUES ('browser','Konqueror',0);
INSERT INTO counter VALUES ('browser','Netscape',1);
INSERT INTO counter VALUES ('browser','Bot',0);
INSERT INTO counter VALUES ('browser','Other',0);
INSERT INTO counter VALUES ('os','Windows',0);
INSERT INTO counter VALUES ('os','Linux',1);
INSERT INTO counter VALUES ('os','Mac',0);
INSERT INTO counter VALUES ('os','FreeBSD',0);
INSERT INTO counter VALUES ('os','SunOS',0);
INSERT INTO counter VALUES ('os','IRIX',0);
INSERT INTO counter VALUES ('os','BeOS',0);
INSERT INTO counter VALUES ('os','OS/2',0);
INSERT INTO counter VALUES ('os','AIX',0);
INSERT INTO counter VALUES ('os','Other',0);
#
# Table structure for table 'downloads'
#
CREATE TABLE downloads (
did int(10) NOT NULL auto_increment,
dcounter int(10) DEFAULT '0' NOT NULL,
durl varchar(255),
dfilename varchar(255),
dfilesize bigint(15),
ddate date DEFAULT '0000-00-00' NOT NULL,
dweb varchar(255),
duser varchar(30),
dver varchar(6),
dcategory varchar(15),
ddescription text,
privs enum('0','1','2') DEFAULT '0',
PRIMARY KEY (did)
);
#
# Dumping data for table 'downloads'
#
#
# Table structure for table 'ephem'
#
CREATE TABLE ephem (
eid int(11) NOT NULL auto_increment,
did int(2) DEFAULT '0' NOT NULL,
mid int(2) DEFAULT '0' NOT NULL,
yid int(4) DEFAULT '0' NOT NULL,
content text DEFAULT '' NOT NULL,
PRIMARY KEY (eid)
);
#
# Dumping data for table 'ephem'
#
#
# Table structure for table 'faqAnswer'
#
CREATE TABLE faqAnswer (
id tinyint(4) NOT NULL auto_increment,
id_cat tinyint(4),
question varchar(255),
answer text,
PRIMARY KEY (id)
);
#
# Dumping data for table 'faqAnswer'
#
#
# Table structure for table 'faqCategories'
#
CREATE TABLE faqCategories (
id_cat tinyint(3) NOT NULL auto_increment,
categories varchar(255),
PRIMARY KEY (id_cat)
);
#
# Dumping data for table 'faqCategories'
#
#
# Table structure for table 'forums'
#
CREATE TABLE forums (
forum_id int(10) NOT NULL auto_increment,
forum_name varchar(150),
forum_desc text,
forum_access int(10) DEFAULT '1',
forum_moderator int(10),
cat_id int(10),
forum_type int(10) DEFAULT '0',
forum_pass varchar(60),
PRIMARY KEY (forum_id)
);
#
# Dumping data for table 'forums'
#
#
# Table structure for table 'forumtopics'
#
CREATE TABLE forumtopics (
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,
forum_id int(10),
topic_status int(10) DEFAULT '0' NOT NULL,
topic_notify int(2) DEFAULT '0',
PRIMARY KEY (topic_id)
);
#
# Dumping data for table 'forumtopics'
#
#
# Table structure for table 'headlines'
#
CREATE TABLE headlines (
hid int(11) NOT NULL auto_increment,
sitename varchar(30) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
headlinesurl varchar(200) DEFAULT '' NOT NULL,
status tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (hid)
);
#
# Dumping data for table 'headlines'
#
INSERT INTO headlines VALUES
(1,'PHP-Nuke','http://phpnuke.org','http://phpnuke.org/backend.php',0);
INSERT INTO headlines VALUES
(2,'LinuxPreview','http://linuxpreview.org','http://linuxpreview.org/backend
.php3',0);
INSERT INTO headlines VALUES
(3,'Slashdot','http://slashdot.org','http://slashdot.org/slashdot.rdf',0);
INSERT INTO headlines VALUES
(4,'NewsForge','http://www.newsforge.com','http://www.newsforge.com/newsforg
e.rdf',0);
INSERT INTO headlines VALUES
(5,'PHPBuilder','http://phpbuilder.com','http://phpbuilder.com/rss_feed.php'
,0);
INSERT INTO headlines VALUES
(6,'Linux.com','http://linux.com','http://linux.com/mrn/front_page.rss',0);
INSERT INTO headlines VALUES
(7,'Freshmeat','http://freshmeat.net','http://freshmeat.net/backend/fm.rdf',
0);
INSERT INTO headlines VALUES
(8,'AppWatch','http://static.appwatch.com','http://static.appwatch.com/appwa
tch.rdf',0);
INSERT INTO headlines VALUES
(9,'LinuxWeelyNews','http://lwn.net','http://lwn.net/headlines/rss',0);
INSERT INTO headlines VALUES
(10,'HappyPenguin','http://happypenguin.org','http://happypenguin.org/html/n
ews.rdf',0);
INSERT INTO headlines VALUES
(11,'Segfault','http://segfault.org','http://segfault.org/stories.xml',0);
INSERT INTO headlines VALUES
(13,'KDE','http://www.kde.org','http://www.kde.org/news/kdenews.rdf',0);
INSERT INTO headlines VALUES
(14,'Perl.com','http://www.perl.com','http://www.perl.com/pace/perlnews.rdf'
,0);
INSERT INTO headlines VALUES
(15,'Themes.org','http://themes.org','http://www.themes.org/news.rdf.phtml',
0);
INSERT INTO headlines VALUES
(16,'BrunchingShuttlecocks','http://www.brunching.com','http://www.brunching
.com/brunching.rdf',0);
INSERT INTO headlines VALUES
(17,'MozillaNewsBot','http://www.mozilla.org/newsbot/','http://www.mozilla.o
rg/newsbot/newsbot.rdf',0);
INSERT INTO headlines VALUES
(18,'NewsTrolls','http://newstrolls.com','http://newstrolls.com/newstrolls.r
df',0);
INSERT INTO headlines VALUES
(19,'FreakTech','http://sunsite.auc.dk/FreakTech/','http://sunsite.auc.dk/Fr
eakTech/FreakTech.rdf',0);
INSERT INTO headlines VALUES
(20,'AbsoluteGames','http://files.gameaholic.com','http://files.gameaholic.c
om/agfa.rdf',0);
INSERT INTO headlines VALUES
(21,'SciFi-News','http://www.technopagan.org/sf-news/','http://www.technopag
an.org/sf-news/rdf.php',0);
INSERT INTO headlines VALUES
(22,'SisterMachineGun','http://www.smg.org','http://www.smg.org/index/mynets
cape.html',0);
INSERT INTO headlines VALUES
(23,'LinuxM68k','http://www.linux-m68k.org','http://www.linux-m68k.org/linux
-m68k.rdf',0);
INSERT INTO headlines VALUES
(24,'Protest.net','http://www.protest.net','http://www.protest.net/netcenter
_rdf.cgi',0);
INSERT INTO headlines VALUES
(25,'HollywoodBitchslap','http://hollywoodbitchslap.com','http://hollywoodbi
tchslap.com/hbs.rdf',0);
INSERT INTO headlines VALUES
(26,'DrDobbsTechNetCast','http://www.technetcast.com','http://www.technetcas
t.com/tnc_headlines.rdf',0);
INSERT INTO headlines VALUES
(27,'RivaExtreme','http://rivaextreme.com','http://rivaextreme.com/ssi/rivae
xtreme.rdf.cdf',0);
INSERT INTO headlines VALUES
(28,'Linuxpower','http://linuxpower.org','http://linuxpower.org/linuxpower.r
df',0);
INSERT INTO headlines VALUES
(29,'PBSOnline','http://www.pbs.org','http://cgi.pbs.org/cgi-registry/featur
esrdf.pl',0);
INSERT INTO headlines VALUES
(30,'Listology','http://www.listology.com','http://listology.com/recent.rdf'
,0);
INSERT INTO headlines VALUES
(31,'Linuxdev.net','http://linuxdev.net','http://linuxdev.net/archive/news.c
df',0);
INSERT INTO headlines VALUES
(32,'LinuxNewbie','http://www.linuxnewbie.org','http://www.linuxnewbie.org/n
ews.cdf',0);
INSERT INTO headlines VALUES
(33,'exoScience','http://www.exosci.com','http://www.exosci.com/exosci.rdf',
0);
INSERT INTO headlines VALUES
(34,'Technocrat','http://www.technocrat.net','http://technocrat.net/rdf',0);
INSERT INTO headlines VALUES
(35,'PDABuzz','http://www.pdabuzz.com','http://www.pdabuzz.com/netscape.txt'
,0);
INSERT INTO headlines VALUES
(36,'MicroUnices','http://mu.current.nu','http://mu.current.nu/mu.rdf',0);
INSERT INTO headlines VALUES
(37,'TheNextLevel','http://www.the-nextlevel.com','http://www.the-nextlevel.
com/rdf/tnl.rdf',0);
INSERT INTO headlines VALUES
(38,'Gnotices','http://news.gnome.org/gnome-news/','http://news.gnome.org/gn
ome-news/rdf',0);
INSERT INTO headlines VALUES
(39,'DailyDaemonNews','http://daily.daemonnews.org','http://daily.daemonnews
.org/ddn.rdf.php3',0);
INSERT INTO headlines VALUES
(40,'PerlMonks','http://www.perlmonks.org','http://www.perlmonks.org/headlin
es.rdf',0);
INSERT INTO headlines VALUES
(41,'PerlNews','http://news.perl.org','http://news.perl.org/perl-news-short.
rdf',0);
INSERT INTO headlines VALUES
(42,'BSDToday','http://www.bsdtoday.com','http://www.bsdtoday.com/backend/bt
.rdf',0);
INSERT INTO headlines VALUES
(43,'DotKDE','http://dot.kde.org','http://dot.kde.org/rdf',0);
INSERT INTO headlines VALUES
(44,'GeekNik','http://www.geeknik.net','http://www.geeknik.net/backend/weblo
g.rdf',0);
INSERT INTO headlines VALUES
(45,'HotWired','http://www.hotwired.com','http://www.hotwired.com/webmonkey/
meta/headlines.rdf',0);
INSERT INTO headlines VALUES
(46,'JustLinux','http://www.justlinux.com','http://www.justlinux.com/backend
/features.rdf',0);
INSERT INTO headlines VALUES
(47,'LAN-Systems','http://www.lansystems.com','http://www.lansystems.com/bac
kend/gazette_news_backend.rdf',0);
INSERT INTO headlines VALUES
(48,'LinuxCentral','http://linuxcentral.com','http://linuxcentral.com/backen
d/lcnew.rdf',0);
INSERT INTO headlines VALUES
(49,'Linux.nu','http://www.linux.nu','http://www.linux.nu/backend/lnu.rdf',0
);
INSERT INTO headlines VALUES
(50,'Lin-x-pert','http://www.lin-x-pert.com','http://www.lin-x-pert.com/linx
pert_apps.rdf',0);
INSERT INTO headlines VALUES
(51,'MaximumBSD','http://www.maximumbsd.com','http://www.maximumbsd.com/back
end/weblog.rdf',0);
INSERT INTO headlines VALUES
(52,'SolarisCentral','http://www.SolarisCentral.org','http://www.SolarisCent
ral.org/news/SolarisCentral.rdf',0);
INSERT INTO headlines VALUES
(53,'DigitalTheatre','http://www.dtheatre.com','http://www.dtheatre.com/back
end.php3?xml=yes',0);
#
# Table structure for table 'lblocks'
#
CREATE TABLE lblocks (
id tinyint(4) NOT NULL auto_increment,
title varchar(60),
content text,
PRIMARY KEY (id)
);
#
# Dumping data for table 'lblocks'
#
INSERT INTO lblocks VALUES (1,'First Left Block','You can add/remove/edit
blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like
<a href=http://phpnuke.org>links</a>, <b>Bold</b> text, images, etc.\r\nJust
use you imagination.');
INSERT INTO lblocks VALUES (2,'Special Sections','What about a <a
href=sections.php>Special Sections</a>option in the PHP-Nuke code? A place
to publish reviews, special articles, interviews, or whatever, independent
of the main news.');
#
# Table structure for table 'links_categories'
#
CREATE TABLE links_categories (
cid int(11) NOT NULL auto_increment,
title varchar(50) DEFAULT '' NOT NULL,
cdescription text DEFAULT '' NOT NULL,
PRIMARY KEY (cid)
);
#
# Dumping data for table 'links_categories'
#
#
# Table structure for table 'links_editorials'
#
CREATE TABLE links_editorials (
linkid int(11) DEFAULT '0' NOT NULL,
adminid varchar(60) DEFAULT '' NOT NULL,
editorialtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
editorialtext text DEFAULT '' NOT NULL,
editorialtitle varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY (linkid)
);
#
# Dumping data for table 'links_editorials'
#
#
# Table structure for table 'links_links'
#
CREATE TABLE links_links (
lid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
date datetime,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
hits int(11) DEFAULT '0' NOT NULL,
submitter varchar(60) DEFAULT '' NOT NULL,
linkratingsummary double(6,4) DEFAULT '0.0000' NOT NULL,
totalvotes int(11) DEFAULT '0' NOT NULL,
totalcomments int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (lid)
);
#
# Dumping data for table 'links_links'
#
#
# Table structure for table 'links_modrequest'
#
CREATE TABLE links_modrequest (
requestid int(11) NOT NULL auto_increment,
lid int(11) DEFAULT '0' NOT NULL,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
modifysubmitter varchar(60) DEFAULT '' NOT NULL,
brokenlink int(3) DEFAULT '0' NOT NULL,
PRIMARY KEY (requestid),
UNIQUE requestid (requestid)
);
#
# Dumping data for table 'links_modrequest'
#
#
# Table structure for table 'links_newlink'
#
CREATE TABLE links_newlink (
lid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
submitter varchar(60) DEFAULT '' NOT NULL,
PRIMARY KEY (lid)
);
#
# Dumping data for table 'links_newlink'
#
#
# Table structure for table 'links_subcategories'
#
CREATE TABLE links_subcategories (
sid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
title varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (sid)
);
#
# Dumping data for table 'links_subcategories'
#
#
# Table structure for table 'links_votedata'
#
CREATE TABLE links_votedata (
ratingdbid int(11) NOT NULL auto_increment,
ratinglid int(11) DEFAULT '0' NOT NULL,
ratinguser varchar(60) DEFAULT '' NOT NULL,
rating int(11) DEFAULT '0' NOT NULL,
ratinghostname varchar(60) DEFAULT '' NOT NULL,
ratingcomments text DEFAULT '' NOT NULL,
ratingtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
PRIMARY KEY (ratingdbid)
);
#
# Dumping data for table 'links_votedata'
#
#
# Table structure for table 'mainblock'
#
CREATE TABLE mainblock (
title varchar(60),
content text
);
#
# Dumping data for table 'mainblock'
#
INSERT INTO mainblock VALUES ('Main Menu','<li><a
href=index.php>Home</a>\r\n<li><a href=topics.php>Topics</a>\r\n<li><a
href=forum.php>Forums</a>\r\n<li><a href=sections.php>Sections</a>\r\n<li><a
href=reviews.php>Reviews</a>\r\n<li><a href=links.php>Web
Links</a>\r\n<li><a href=download.php>Downloads</a>\r\n<li><a
href=friend.php>Recommend Us</a>\r\n<li><a href=memberslist.php>Members
List</a>\r\n<li><a href=user.php>Your Account</a>\r\n<li><a
href=submit.php>Submit News</a>\r\n<li><a href=stats.php>Stats</a>\r\n<li><a
href=top.php>Top 10</a>\r\n<li><a href=faq.php>FAQ</a>');
#
# Table structure for table 'poll_data'
#
CREATE TABLE poll_data (
pollID int(11) DEFAULT '0' NOT NULL,
optionText char(50) DEFAULT '' NOT NULL,
optionCount int(11) DEFAULT '0' NOT NULL,
voteID int(11) DEFAULT '0' NOT NULL
);
#
# Dumping data for table 'poll_data'
#
INSERT INTO poll_data VALUES (1,'Ummmm, not bad',0,1);
INSERT INTO poll_data VALUES (1,'Cool',0,2);
INSERT INTO poll_data VALUES (1,'Terrific',0,3);
INSERT INTO poll_data VALUES (1,'The best one!',0,4);
INSERT INTO poll_data VALUES (1,'what the hell is this?',0,5);
INSERT INTO poll_data VALUES (1,'',0,6);
INSERT INTO poll_data VALUES (1,'',0,7);
INSERT INTO poll_data VALUES (1,'',0,8);
INSERT INTO poll_data VALUES (1,'',0,9);
INSERT INTO poll_data VALUES (1,'',0,10);
INSERT INTO poll_data VALUES (1,'',0,11);
INSERT INTO poll_data VALUES (1,'',0,12);
#
# Table structure for table 'poll_desc'
#
CREATE TABLE poll_desc (
pollID int(11) NOT NULL auto_increment,
pollTitle char(100) DEFAULT '' NOT NULL,
timeStamp int(11) DEFAULT '0' NOT NULL,
voters mediumint(9) DEFAULT '0' NOT NULL,
PRIMARY KEY (pollID)
);
#
# Dumping data for table 'poll_desc'
#
INSERT INTO poll_desc VALUES (1,'What do you think about
PHP-Nuke?',961405160,0);
#
# Table structure for table 'pollcomments'
#
CREATE TABLE pollcomments (
tid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0',
pollID int(11) DEFAULT '0',
date datetime,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60),
url varchar(60),
host_name varchar(60),
subject varchar(60) DEFAULT '' NOT NULL,
comment text DEFAULT '' NOT NULL,
score tinyint(4) DEFAULT '0' NOT NULL,
reason tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (tid)
);
#
# Dumping data for table 'pollcomments'
#
#
# Table structure for table 'posts'
#
CREATE TABLE posts (
post_id int(10) NOT NULL auto_increment,
image varchar(100) DEFAULT '' NOT NULL,
topic_id int(10) DEFAULT '0' NOT NULL,
forum_id int(10) DEFAULT '0' NOT NULL,
poster_id int(10),
post_text text,
post_time varchar(20),
poster_ip varchar(16),
PRIMARY KEY (post_id)
);
#
# Dumping data for table 'posts'
#
#
# Table structure for table 'priv_msgs'
#
CREATE TABLE priv_msgs (
msg_id int(10) NOT NULL auto_increment,
msg_image varchar(100),
subject varchar(100),
from_userid int(10) DEFAULT '0' NOT NULL,
to_userid int(10) DEFAULT '0' NOT NULL,
msg_time varchar(20),
msg_text text,
read_msg tinyint(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (msg_id),
KEY msg_id (msg_id),
KEY to_userid (to_userid)
);
#
# Dumping data for table 'priv_msgs'
#
#
# Table structure for table 'queue'
#
CREATE TABLE queue (
qid smallint(5) unsigned NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) DEFAULT '' NOT NULL,
subject varchar(100) DEFAULT '' NOT NULL,
story text,
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
topic varchar(20) DEFAULT 'Linux' NOT NULL,
PRIMARY KEY (qid)
);
#
# Dumping data for table 'queue'
#
#
# Table structure for table 'quotes'
#
CREATE TABLE quotes (
qid int(10) unsigned NOT NULL auto_increment,
quote text,
PRIMARY KEY (qid)
);
#
# Dumping data for table 'quotes'
#
INSERT INTO quotes VALUES (1,'Nos morituri te salutamus - CBHS');
#
# Table structure for table 'ranks'
#
CREATE TABLE ranks (
rank_id int(10) NOT NULL auto_increment,
rank_title varchar(50) DEFAULT '' NOT NULL,
rank_min int(10) DEFAULT '0' NOT NULL,
rank_max int(10) DEFAULT '0' NOT NULL,
rank_special int(2) DEFAULT '0',
PRIMARY KEY (rank_id),
KEY rank_min (rank_min),
KEY rank_max (rank_max)
);
#
# Dumping data for table 'ranks'
#
#
# Table structure for table 'rblocks'
#
CREATE TABLE rblocks (
id tinyint(4) NOT NULL auto_increment,
title varchar(60),
content text,
PRIMARY KEY (id)
);
#
# Dumping data for table 'rblocks'
#
INSERT INTO rblocks VALUES (1,'First Right Block','You can add/remove/edit
blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like
<a href=http://phpnuke.org>links</a>, <b>Bold</b> text, images, etc.\r\nJust
use you imagination.');
INSERT INTO rblocks VALUES (2,'Information','<center>\r\nSite made
with:<br>\r\n<a href=http://phpnuke.org><img src=images/powered/phpnuke.gif
border=0></a><br>\r\n');
#
# Table structure for table 'referer'
#
CREATE TABLE referer (
rid int(11) NOT NULL auto_increment,
url varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY (rid)
);
#
# Dumping data for table 'referer'
#
#
# Table structure for table 'related'
#
CREATE TABLE related (
rid int(11) NOT NULL auto_increment,
tid int(11) DEFAULT '0' NOT NULL,
name varchar(30) DEFAULT '' NOT NULL,
url varchar(200) DEFAULT '' NOT NULL,
PRIMARY KEY (rid)
);
#
# Dumping data for table 'related'
#
#
# Table structure for table 'reviews'
#
CREATE TABLE reviews (
id int(10) NOT NULL auto_increment,
date date DEFAULT '0000-00-00' NOT NULL,
title varchar(150) DEFAULT '' NOT NULL,
text text DEFAULT '' NOT NULL,
reviewer varchar(20),
email varchar(30),
score int(10) DEFAULT '0' NOT NULL,
cover varchar(100) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
url_title varchar(50) DEFAULT '' NOT NULL,
hits int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'reviews'
#
#
# Table structure for table 'reviews_add'
#
CREATE TABLE reviews_add (
id int(10) NOT NULL auto_increment,
date date,
title varchar(150) DEFAULT '' NOT NULL,
text text DEFAULT '' NOT NULL,
reviewer varchar(20) DEFAULT '' NOT NULL,
email varchar(30) DEFAULT '' NOT NULL,
score int(10) DEFAULT '0' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
url_title varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
);
#
# Dumping data for table 'reviews_add'
#
#
# Table structure for table 'reviews_comments'
#
CREATE TABLE reviews_comments (
cid int(10) NOT NULL auto_increment,
rid int(10) DEFAULT '0' NOT NULL,
userid varchar(25) DEFAULT '' NOT NULL,
date datetime,
comments text,
score int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (cid)
);
#
# Dumping data for table 'reviews_comments'
#
#
# Table structure for table 'reviews_main'
#
CREATE TABLE reviews_main (
title varchar(100),
description text
);
#
# Dumping data for table 'reviews_main'
#
INSERT INTO reviews_main VALUES ('Reviews Section Title','Reviews Section
Long Description');
#
# Table structure for table 'seccont'
#
CREATE TABLE seccont (
artid int(11) NOT NULL auto_increment,
secid int(11) DEFAULT '0' NOT NULL,
title text DEFAULT '' NOT NULL,
content text DEFAULT '' NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (artid)
);
#
# Dumping data for table 'seccont'
#
#
# Table structure for table 'sections'
#
CREATE TABLE sections (
secid int(11) NOT NULL auto_increment,
secname varchar(40) DEFAULT '' NOT NULL,
image varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (secid)
);
#
# Dumping data for table 'sections'
#
#
# Table structure for table 'session'
#
CREATE TABLE session (
username varchar(25) DEFAULT '' NOT NULL,
time varchar(14) DEFAULT '' NOT NULL,
host_addr varchar(20) DEFAULT '' NOT NULL,
guest int(1) DEFAULT '0' NOT NULL
);
#
# Dumping data for table 'session'
#
INSERT INTO session VALUES
('150.187.58.251','981661688','150.187.58.251',1);
#
# Table structure for table 'stories'
#
CREATE TABLE stories (
sid int(11) NOT NULL auto_increment,
catid int(11) DEFAULT '0' NOT NULL,
aid varchar(30) DEFAULT '' NOT NULL,
title varchar(80),
time datetime,
hometext text,
bodytext text DEFAULT '' NOT NULL,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) DEFAULT '' NOT NULL,
notes text DEFAULT '' NOT NULL,
ihome int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (sid)
);
#
# Dumping data for table 'stories'
#
INSERT INTO stories VALUES (1,0,'god','Welcome to PHP-Nuke!!!','2000-12-04
12:00:00','This is the first <a href=http://phpnuke.org>article in
PHP-Nuke</a>. You can delete it. Remember to set/change nickname and/or
password for the main admin user. There aren\'t any registered/default user,
so maybe you want to set the first one. Pelase read carefully the README
file for some details, CREDITS files to see from where comes the things and
remember that this is free software under the GPL License (COPYING file for
details). Hope you enjoy this software. Please report any bug you find, and
you\'ll for sure, so drop me an email when one of this annoying things
happens and I\'ll try to fix it for the next
releases.','',1,36,10,'god','',0);
#
# Table structure for table 'stories_cat'
#
CREATE TABLE stories_cat (
catid int(11) NOT NULL auto_increment,
title varchar(20) DEFAULT '' NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (catid)
);
#
# Dumping data for table 'stories_cat'
#
#
# Table structure for table 'topics'
#
CREATE TABLE topics (
topicid int(3) NOT NULL auto_increment,
topicname varchar(20),
topicimage varchar(20),
topictext varchar(40),
counter int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (topicid)
);
#
# Dumping data for table 'topics'
#
INSERT INTO topics VALUES (1,'linux','linux.gif','Linux',0);
INSERT INTO topics VALUES (2,'amd','amd.gif','AMD',0);
INSERT INTO topics VALUES (3,'aol','aol.jpg','America Online',0);
INSERT INTO topics VALUES (4,'caldera','caldera.gif','Caldera Systems',0);
INSERT INTO topics VALUES (5,'apple','mac.gif','Apple / Mac',0);
INSERT INTO topics VALUES (6,'beos','beos.gif','BeOS',0);
INSERT INTO topics VALUES (7,'compaq','compaq.gif','Compaq',0);
INSERT INTO topics VALUES (8,'corel','corel.gif','Corel',0);
INSERT INTO topics VALUES (9,'debian','debian.gif','Debian',0);
INSERT INTO topics VALUES (10,'phpnuke','phpnuke.gif','PHP-Nuke',0);
INSERT INTO topics VALUES (11,'freebsd','freebsd.gif','FreeBSD',0);
INSERT INTO topics VALUES (12,'gimp','gimp.gif','GIMP',0);
INSERT INTO topics VALUES (13,'gnome','gnome.gif','GNOME',0);
INSERT INTO topics VALUES (14,'gnu','gnu.jpg','GNU / GPL',0);
INSERT INTO topics VALUES (15,'hp','hp.gif','Hewlett Packard',0);
INSERT INTO topics VALUES (16,'ibm','ibm.gif','IBM',0);
INSERT INTO topics VALUES (17,'intel','intel.gif','Intel',0);
INSERT INTO topics VALUES (18,'java','java.gif','Java',0);
INSERT INTO topics VALUES (19,'kde','kde.gif','KDE',0);
INSERT INTO topics VALUES (20,'mandrake','mandrake.gif','Mandrake',0);
INSERT INTO topics VALUES (21,'microsoft','microsoft.gif','Microsoft',0);
INSERT INTO topics VALUES (22,'mozilla','mozilla.gif','Mozilla',0);
INSERT INTO topics VALUES (23,'netscape','netscape.gif','Netscape',0);
INSERT INTO topics VALUES (24,'perl','perl.gif','Perl',0);
INSERT INTO topics VALUES (25,'redhat','redhat.gif','Red Hat',0);
INSERT INTO topics VALUES (26,'sgi','sgi.gif','Silicon Graphics',0);
INSERT INTO topics VALUES (27,'sun','sun.gif','Sun Microsystems',0);
INSERT INTO topics VALUES (28,'suse','suse.gif','SuSE',0);
INSERT INTO topics VALUES (29,'x','x.jpg','X Window',0);
#
# Table structure for table 'users'
#
CREATE TABLE users (
uid int(11) NOT NULL auto_increment,
name varchar(60) DEFAULT '' NOT NULL,
uname varchar(25) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
femail varchar(60) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
user_avatar varchar(30),
user_regdate varchar(20) DEFAULT '' NOT NULL,
user_icq varchar(15),
user_occ varchar(100),
user_from varchar(100),
user_intrest varchar(150),
user_sig varchar(255),
user_viewemail tinyint(2),
user_theme int(3),
user_aim varchar(18),
user_yim varchar(25),
user_msnm varchar(25),
pass varchar(40) DEFAULT '' NOT NULL,
storynum tinyint(4) DEFAULT '10' NOT NULL,
umode varchar(10) DEFAULT '' NOT NULL,
uorder tinyint(1) DEFAULT '0' NOT NULL,
thold tinyint(1) DEFAULT '0' NOT NULL,
noscore tinyint(1) DEFAULT '0' NOT NULL,
bio tinytext DEFAULT '' NOT NULL,
ublockon tinyint(1) DEFAULT '0' NOT NULL,
ublock tinytext DEFAULT '' NOT NULL,
theme varchar(255) DEFAULT '' NOT NULL,
commentmax int(11) DEFAULT '4096' NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);
#
# Dumping data for table 'users'
#
INSERT INTO users VALUES (1,'','Anonymous','','','','blank.gif','Nov 10,
2000','','','','','',0,0,'','','','',10,'',0,0,0,'',0,'','',4096,0);
#
# Table structure for table 'users_status'
#
CREATE TABLE users_status (
uid int(11) NOT NULL auto_increment,
posts int(10) DEFAULT '0',
attachsig int(2) DEFAULT '0',
rank int(10) DEFAULT '0',
level int(10) DEFAULT '1',
PRIMARY KEY (uid)
);
#
# Dumping data for table 'users_status'
#
INSERT INTO users_status VALUES (1,0,0,0,0);
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
