Re: My SQL
| From: | Zak Greant | Date: | Wed, 16 May 2001 22:17:18 +0000 |
| Subject: | Re: My SQL | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-7645@lists.php.net to get a copy of this message | ||
Manesh,
Don't be surprised that people are less than helpful when you sent a huge
(34k) message to the list! :)
The command you need is this:
mysql db_name < nuke.sql
Change the db_name to whatever database you want the tables to appear in.
All of this info is in the MySQL docs.
--zak
----- Original Message -----
From: "Manesh Manickam" <mmanickam@home.com>
To: "Manesh Manickam" <mmanickam@home.com>; <php-windows@lists.php.net>
Sent: Wednesday, May 16, 2001 3:37 PM
Subject: RE: [PHP-WIN] My SQL
> COME ONE!! PLEASE!!!!
>
> -----Original Message-----
> From: Manesh Manickam [mailto:mmanickam@home.com]
> Sent: Wednesday, May 16, 2001 4:39 PM
> To: php-windows@lists.php.net
> 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@$h
> 3S s);
> 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=ER
> O.=({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: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net
> For additional commands, e-mail: php-windows-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>