Netkiller 写道： > Netkiller 写道： > > > #!/usr/bin/python > > # -*- coding: utf-8 -*- > > """ > > Project: Network News Transport Protocol Server Program > > Description: > > 基于数据库的新闻组，实现BBS前端使用NNTP协议来访问贴子 > >
Database SQL Script follow: -- phpMyAdmin SQL Dump -- version 2.7.0-rc1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 04, 2006 at 02:47 PM -- Server version: 4.1.18 -- PHP Version: 5.0.5 -- -- Database: `usenet` -- -- -------------------------------------------------------- -- -- Table structure for table `article` -- DROP TABLE IF EXISTS `article`; CREATE TABLE IF NOT EXISTS `article` ( `Number` int(10) unsigned NOT NULL auto_increment, `MessageID` varchar(255) NOT NULL default '', `body` text NOT NULL, `Date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`Number`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ; -- -- Dumping data for table `article` -- INSERT INTO `article` VALUES (25, '', 'From: "NEO" <[EMAIL PROTECTED]>\r\nNewsgroups: cn.test\r\nSubject: test\r\nDate: Fri, 30 Jun 2006 17:14:17 +0800\r\nLines: 3\r\nX-Priority: 3\r\nX-MSMail-Priority: Normal\r\nX-Newsreader: Microsoft Outlook Express 6.00.2900.2180\r\nX-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180\r\nX-RFC2646: Format=Flowed; Original\r\n\r\ntest ! \r\n\r\n\r\n', '2006-06-30 17:14:17'); INSERT INTO `article` VALUES (26, '', 'Date: Tue, 04 Jul 2006 11:34:54 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: aaaaaa\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\n wrote:\r\n> test ! \r\n> \r\n> \r\n-------------\r\n', '2006-07-04 11:34:54'); INSERT INTO `article` VALUES (27, '', 'Date: Tue, 04 Jul 2006 13:57:07 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: bbbbbb\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nbbbbbbbbbbb\r\n', '2006-07-04 13:57:07'); INSERT INTO `article` VALUES (28, '', 'Date: Tue, 04 Jul 2006 13:58:17 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: bbbbbb\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nMy Usenet wrote:\r\n> bbbbbbbbbbb\r\n', '2006-07-04 13:58:17'); INSERT INTO `article` VALUES (29, '', 'Date: Tue, 04 Jul 2006 14:28:00 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: cccccc\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\ncccccc\r\n', '2006-07-04 14:28:00'); INSERT INTO `article` VALUES (30, '', 'Date: Tue, 04 Jul 2006 14:29:02 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: cccccc My Usenet <[EMAIL PROTECTED]>\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nTue wrote:\r\n> cccccc\r\n', '2006-07-04 14:29:02'); INSERT INTO `article` VALUES (31, '', 'Date: Tue, 04 Jul 2006 14:29:22 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: cccccc My Usenet\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nTue wrote:\r\n> Tue wrote:\r\n>> cccccc\r\n', '2006-07-04 14:29:22'); INSERT INTO `article` VALUES (32, '', 'Date: Tue, 04 Jul 2006 14:29:55 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: ddddd\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nddddd\r\n', '2006-07-04 14:29:55'); INSERT INTO `article` VALUES (33, '', 'Date: Tue, 04 Jul 2006 14:31:32 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: dddddMy Usenet <[EMAIL PROTECTED]>\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nTue wrote:\r\n> ddddd\r\n', '2006-07-04 14:31:32'); INSERT INTO `article` VALUES (34, '', 'Date: Tue, 04 Jul 2006 14:31:45 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: bbbbbb\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nMy Usenet wrote:\r\n> bbbbbbbbbbb\r\n', '2006-07-04 14:31:45'); INSERT INTO `article` VALUES (35, '', 'Date: Tue, 04 Jul 2006 14:32:04 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: cccccc\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\ncccccc\r\n', '2006-07-04 14:32:04'); INSERT INTO `article` VALUES (36, '', 'Date: Tue, 04 Jul 2006 14:32:15 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: cccccc\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nMy Usenet wrote:\r\n> cccccc\r\n', '2006-07-04 14:32:15'); INSERT INTO `article` VALUES (37, '', 'Date: Tue, 04 Jul 2006 14:32:18 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: cccccc\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nMy Usenet wrote:\r\n> cccccc\r\n', '2006-07-04 14:32:18'); INSERT INTO `article` VALUES (38, '', 'Date: Tue, 04 Jul 2006 14:32:26 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: cccccc\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nMy Usenet wrote:\r\n> cccccc\r\n', '2006-07-04 14:32:26'); INSERT INTO `article` VALUES (39, '', 'Date: Tue, 04 Jul 2006 14:32:32 +0800\r\nFrom: My Usenet <[EMAIL PROTECTED]>\r\nUser-Agent: Thunderbird 1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups: cn.test\r\nSubject: Re: cccccc\r\nContent-Type: text/plain; charset=ISO-8859-1; format=flowed\r\nContent-Transfer-Encoding: 7bit\r\n\r\nMy Usenet wrote:\r\n> cccccc\r\n', '2006-07-04 14:32:32'); -- -------------------------------------------------------- -- -- Table structure for table `list` -- DROP TABLE IF EXISTS `list`; CREATE TABLE IF NOT EXISTS `list` ( `id` int(10) unsigned NOT NULL auto_increment, `group` varchar(255) NOT NULL default '', `last` varchar(10) NOT NULL default '', `first` varchar(10) NOT NULL default '', `p` char(1) default 'y', `date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='RFC977 3.6.1. LIST' AUTO_INCREMENT=3 ; -- -- Dumping data for table `list` -- INSERT INTO `list` VALUES (1, 'cn.test', '10', '5', 'y', '0000-00-00 00:00:00'); INSERT INTO `list` VALUES (2, 'cn.comp.os', '10', '5', 'y', '2006-06-27 00:00:00'); -- http://mail.python.org/mailman/listinfo/python-list
