Web Articles Database


Databases

Web Articles Database

22938 articles, 103 MB database size.

Database Sample CREATE TABLE IF NOT EXISTS `articles` (
`FileID` int(3) unsigned NOT NULL auto_increment,
`Title` varchar(50) NOT NULL default '',
`Author` varchar(50) NOT NULL default '',
`Category` varchar(50) default NULL,
`Keywords` varchar(80) default NULL,
`Articledata` text,
`Approved` char(1) default NULL,
`Views` varchar(10) default NULL,
`Submitdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`Votes` varchar(16) default NULL,
`Score` varchar(16) default NULL,
PRIMARY KEY (`FileID`),
KEY `Keywords` (`Keywords`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22939 ;

INSERT INTO `articles` VALUES (1, 'If You Drive - Consider A Greener Fuel As Smog Sea', 'News Canada', 'Auto And Trucks', 'news,canada,ethanol,smog,baker,news canada,canadian,mr,fuel,canadian renewable f', 'nnIf You Drive - Consider A Greener Fuel As Smog Season Beginsnnby: News Canadannrn(NC)-As the first smog alert warnings of the season approach, Canadians are being urged to use ethanol-blended fuel to alleviate the urban smog problems plaguing many parts of the country. Many regions such Vancouver, Calgary, Montreal and most parts of Ontario have experienced a significant increase in the number of "smog days" in recent years and the problem is getting worse according the Canadian Renewable Fuels Association. Mr. Bliss Baker, President of the Canadian Renewable Fuels Association (CRFA), suggests commuters and other motorists fill-up with ethanol-blended gasoline. "This is one way of addressing the issue of air pollution - since ethanol produces 30% less smog forming carbon monoxide than standard gasoline," said Mr. Baker.rnThe most commonly available ethanol-blended fuel is called E-10 - a mixture of 10% ethanol with 90% gasoline. This product, in addition to substantially reducing carbon monoxide, can reduce carbon dioxide emissions by up to 6 percent and all vehicles have warrantees for the use of E10. Using ethanol blends rather than standard gasoline also results in an overall decrease in ozone formation - the main culprit in the creation of smog. rn"This is no longer an urban problem," said Mr. Baker. Many rural parts of the country are now experiencing poor air quality. The good news is there is something we can do about it," concluded Mr. Baker.rnAll ethanol sold in Canada is produced from agricultural products such as corn and wheat. The corn producing areas of southwestern Ontario such as the Counties of Essex and Chatham-Kent produce the majority of Ontario''s ethanol while ethanol production in western Canada is produced from wheat grown throughout Alberta, Saskatchewan and Manitoba.rnThere are currently over 1,100 gas stations in Canada that sell ethanol- blended fuel, across the country from Alberta to Quebec. To find a station near you simply visit the Canadian Renewable Fuels website at www.greenfuels.org and search retail directory for a station near you. rnnnnnnAbout The AuthornnrnNews Canada provides a wide selection of current, ready-to-use copyright free news stories and ideas for Television, Print, Radio, and the Web. rnNews Canada is a niche service in public relations, offering access to print, radio, television, and now the Internet media, with ready-to-use, editorial "fill" items. Monitoring and analysis are two more of our primary services. The service supplies access to the national media for marketers in the private, the public, and the not-for-profit sectors. Your corporate and product news, consumer tips and information are packaged in a variety of ready-to-use formats and are made available to every Canadian media organization including weekly and daily newspapers, cable and commercial television stations, radio stations, as well as the Web sites Canadians visit most often. Visit News Canada and learn more about the NC services.rnnnnnThis article was posted on July 17, 2002nnnrn', 'Y', '9', '2006-11-27 21:01:39', '0', '0');
DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
`CatID` int(3) unsigned NOT NULL auto_increment,
`Category` varchar(50) NOT NULL default '',
`Parent` int(3) NOT NULL default '0',
`Approved` char(1) default 'N',
PRIMARY KEY (`CatID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

INSERT INTO `categories` VALUES (1, 'Online Business', 0, 'Y');

Price: $29.99