-- 
-- Ľṹ `##__pplog_admin`
-- 

DROP TABLE IF EXISTS `##__pplog_admin`;
CREATE TABLE `##__pplog_admin` (
  `uid` int(11) NOT NULL auto_increment,
  `userid` varchar(20) NOT NULL,
  `name` varchar(40) NOT NULL,
  `privkey` text NOT NULL,
  `loginban` tinyint(1) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;

-- --------------------------------------------------------
-- 
-- Ľṹ `##__pplog_article`
-- 
DROP TABLE IF EXISTS `##__pplog_article`;
CREATE TABLE `##__pplog_article` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(80) NOT NULL,
  `class` smallint(6) NOT NULL,
  `myclass` int(11) NOT NULL,
  `tags` varchar(250) NOT NULL,
  `body` mediumtext NOT NULL,
  `author` int(11) NOT NULL,
  `postip` varchar(20) NOT NULL,
  `posttime` int(11) NOT NULL,
  `postdate` varchar(8) NOT NULL,
  `orderkey` int(11) NOT NULL,
  `read` int(11) NOT NULL,
  `reply` int(11) NOT NULL,
  `box` tinyint(4) NOT NULL,
  `replyban` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

-- 
-- Ľṹ `##__pplog_class`
-- 
DROP TABLE IF EXISTS `##__pplog_class`;
CREATE TABLE `##__pplog_class` (
  `id` smallint(6) NOT NULL auto_increment,
  `classname` varchar(20) NOT NULL,
  `orderkey` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

-- 
-- Ľṹ `##__pplog_fdlink`
-- 
DROP TABLE IF EXISTS `##__pplog_fdlink`;
CREATE TABLE `##__pplog_fdlink` (
  `id` int(10) NOT NULL auto_increment,
  `author` int(10) NOT NULL,
  `fdtitle` varchar(40) NOT NULL,
  `fddescrip` varchar(200) NOT NULL,
  `fdurl` varchar(150) NOT NULL,
  `orderkey` smallint(6) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

-- 
-- Ľṹ `##__pplog_liuyan`
-- 
DROP TABLE IF EXISTS `##__pplog_liuyan`;
CREATE TABLE `##__pplog_liuyan` (
  `id` int(11) NOT NULL auto_increment,
  `pploger` int(11) NOT NULL,
  `replyer` int(11) NOT NULL,
  `replyername` varchar(20) NOT NULL,
  `secret` tinyint(1) NOT NULL,
  `liuyan` text NOT NULL,
  `huifu` text NOT NULL,
  `postip` varchar(24) NOT NULL,
  `posttime` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

-- 
-- Ľṹ `##__pplog_myclass`
-- 
DROP TABLE IF EXISTS `##__pplog_myclass`;
CREATE TABLE `##__pplog_myclass` (
  `id` int(11) NOT NULL auto_increment,
  `classname` varchar(30) NOT NULL,
  `author` int(11) NOT NULL,
  `orderkey` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

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

-- 
-- Ľṹ `##__pplog_passport`
-- 
DROP TABLE IF EXISTS `##__pplog_passport`;
CREATE TABLE `##__pplog_passport` (
  `uid` int(11) NOT NULL,
  `username` varchar(20) NOT NULL,
  `pplogtitle` varchar(30) NOT NULL,
  `pplogopen` int(11) NOT NULL,
  `visit` int(11) NOT NULL,
  `why` varchar(250) NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM;

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

-- 
-- Ľṹ `##__pplog_reply`
-- 
DROP TABLE IF EXISTS `##__pplog_reply`;
CREATE TABLE `##__pplog_reply` (
  `id` int(11) NOT NULL auto_increment,
  `articleid` int(11) NOT NULL,
  `articleauthor` int(11) NOT NULL,
  `replyauthor` int(11) NOT NULL,
  `shortname` varchar(20) NOT NULL,
  `homepage` varchar(80) NOT NULL,
  `replytitle` varchar(40) NOT NULL,
  `articletitle` varchar(60) NOT NULL,
  `reply` text NOT NULL,
  `postip` varchar(24) NOT NULL,
  `posttime` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;
