mysql.sql

在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.

-- phpMyAdmin SQL Dump
-- version 2.6.0-rc2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Dec 09, 2004 at 02:54 PM
-- Server version: 4.0.22
-- PHP Version: 4.3.9
-- 
-- Database: `dev_xoops`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `xmline_categories`
-- 

CREATE TABLE `xmline_categories` (
  `category_id` int(8) unsigned NOT NULL auto_increment,
  `image` varchar(255) default NULL,
  `title` varchar(255) NOT NULL default '',
  `category_order` int(8) NOT NULL default '1',
  PRIMARY KEY  (`category_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `xmline_categories`
-- 

INSERT INTO `xmline_categories` VALUES (1, 'topxoops.png', 'XOOPS', 1);
INSERT INTO `xmline_categories` VALUES (2, 'google.gif', 'News', 2);
INSERT INTO `xmline_categories` VALUES (3, 'xmline.png', 'XML', 3);
INSERT INTO `xmline_categories` VALUES (4, 'sitepoint.gif', 'BLOG', 4);

-- --------------------------------------------------------

-- 
-- Table structure for table `xmline_digests`
-- 

CREATE TABLE `xmline_digests` (
  `digest_id` int(8) unsigned NOT NULL auto_increment,
  `category_id` int(8) unsigned NOT NULL default '1',
  `digest_order` int(8) NOT NULL default '1',
  `rss` varchar(255) NOT NULL default '',
  `online` int(1) NOT NULL default '1',
  `title` varchar(40) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  `maxitems` int(4) unsigned NOT NULL default '0',
  `charset` varchar(40) default NULL,
  `charset_inter` varchar(40) default NULL,
  `updatetime` int(4) unsigned NOT NULL default '60',
  `lastupdate` int(11) unsigned NOT NULL default '0',
  `items` text,
  PRIMARY KEY  (`digest_id`),
  KEY `category_id` (`category_id`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `xmline_digests`
-- 

INSERT INTO `xmline_digests` VALUES (1, 1, 1, 'http://xoops.org/backend.php', 1, 'XOOPS', 'XOOPS Official', 'http://xoops.org', 'xoops.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (2, 1, 2, 'http://xoops.org.cn/backend.php', 1, 'XCN', 'XOOPS CHINA', 'http://xoops.org.cn', 'xoopschina.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (3, 1, 3, 'http://xoops2.org/modules/newbb/rss.php', 1, 'XOOPS2', 'NewBB RSS', 'http://xoops2.org', 'newbb.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (4, 1, 4, 'http://xoops.org.cn/modules/newbb/rss.php', 1, 'XCNBB', 'XOOPS CHINA NewBB', 'http://xoops.org.cn/', 'xoopschinanewbb.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (5, 2, 1, 'http://www.sitepoint.com/recent.rdf', 1, 'SPNews', 'SitePoint News', 'http://www.sitepoint.com', 'sitepoint.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (6, 2, 2, 'http://sourceforge.net/export/rss_sfnews.php', 1, 'SFNEWS', 'Source forge news', 'http://sourceforge.net', 'sf.jpg', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (7, 2, 3, 'http://rss.xinhuanet.com/rss/it.xml', 1, 'XINHUA', 'XinHua Net News', 'http://xinhuanet.com', 'xinhua.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (8, 3, 1, 'http://www.oreillynet.com/meerkat/?_fl=atom&t=ALL&c=47', 1, 'XML', 'XML Atom Feed', 'http://xml.com', 'xml.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (9, 3, 2, 'http://www.oreillynet.com/meerkat/?_fl=rss10&t=ALL&c=47', 1, 'XMLRDF', 'XML RDF 1.0 Feed', 'http://www.oreillynet.com', 'rdf.png', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (10, 4, 1, 'http://www.sitepoint.com/blogs.rdf', 1, 'SPBLOG', 'SitePoint Blogs', 'http://www.sitepoint.com/', 'sitepoint.gif', 20, '', '', 60, 0, NULL);
INSERT INTO `xmline_digests` VALUES (11, 4, 2, 'http://xoops.org.cn/modules/wordpress/wp-rss.php', 1, 'WPRSS', 'WordPress RSS', 'http://xoops.org.cn', 'xoopschina.gif', 20, '', '', 60, 0, NULL);