my newsgroup base database. (test)
Netkiller
chan.neo at gmail.com
Tue Jul 4 02:48:19 EDT 2006
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"
<openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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
<openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\r\nUser-Agent: Thunderbird
1.5.0.4 (Windows/20060516)\r\nMIME-Version: 1.0\r\nNewsgroups:
cn.test\r\nSubject: Re: dddddMy Usenet
<openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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 <openunix at 163.com>\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');
More information about the Python-list
mailing list