article.sql

采用模块化设计,自由组合文章,软件,论坛等模块,安装方便快捷 模板支持Dreamweaver可视化编辑,创建风格更为容易,专业

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `la_article_config` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `value` text NOT NULL,
  `explain` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `la_article_config` (`id`, `value`, `explain`) VALUES
(1, '', ''),
(2, '维护中...', ''),
(3, '20', ''),
(4, '10', ''),
(5, '090508', ''),
(6, '[a,18,3,5] [b,6,3,5]', '');

CREATE TABLE `la_article_lists` (
  `fid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `cl_1` varchar(20) NOT NULL,
  `cl_2` varchar(20) NOT NULL,
  `cl_3` varchar(20) NOT NULL,
  `cl_4` varchar(20) NOT NULL,
  `cl_5` varchar(20) NOT NULL,
  `cls` varchar(30) NOT NULL,
  `news` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `admins` varchar(255) NOT NULL,
  `c` varchar(255) NOT NULL,
  `zu` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `xu` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `h1` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h2` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h3` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h4` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `h5` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(2) NOT NULL DEFAULT '-1',
  `a1` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a2` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a3` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a4` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `a5` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `titles` int(10) unsigned NOT NULL DEFAULT '0',
  `admint` tinyint(2) unsigned NOT NULL DEFAULT '1',
  `v` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `v_` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `ha` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`fid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `la_article_lists` (`fid`, `name`, `cl_1`, `cl_2`, `cl_3`, `cl_4`, `cl_5`, `cls`, `news`, `admins`, `c`, `zu`, `xu`, `h1`, `h2`, `h3`, `h4`, `h5`, `level`, `a1`, `a2`, `a3`, `a4`, `a5`, `titles`, `admint`, `v`, `v_`, `ha`) VALUES
(1, '默认栏目', '原创', '转载', '', '', '', '1,2', 10, '', '', 0, 0, 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0);

CREATE TABLE `la_article_pv` (
  `name` varchar(12) NOT NULL,
  `p0` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p1` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p2` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p3` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p4` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p5` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p6` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p7` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p8` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p9` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p10` smallint(5) unsigned NOT NULL DEFAULT '0',
  `p11` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `la_article_pv` (`name`, `p0`, `p1`, `p2`, `p3`, `p4`, `p5`, `p6`, `p7`, `p8`, `p9`, `p10`, `p11`) VALUES
('a1', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
('a2', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
('a3', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
('a4', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
('a5', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1),
('r1', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('r2', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('r3', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('r4', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('r5', 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('g1', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('g2', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('g3', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('g4', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('g5', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0);

CREATE TABLE `la_article_titles` (
  `tid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `fid` smallint(6) unsigned NOT NULL DEFAULT '0',
  `author` varchar(18) NOT NULL DEFAULT '',
  `authorid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) NOT NULL,
  `stitle` varchar(255) NOT NULL,
  `etime` int(10) unsigned NOT NULL DEFAULT '0',
  `f_top` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `f_lock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sell` smallint(5) unsigned NOT NULL DEFAULT '0',
  `muser` varchar(255) NOT NULL,
  `cl_1` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cl_2` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cl_3` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cl_4` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cl_5` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`),
  KEY `fid` (`fid`),
  KEY `authorid` (`authorid`),
  KEY `etime` (`etime`),
  KEY `cl_1` (`cl_1`),
  KEY `cl_2` (`cl_2`),
  KEY `cl_3` (`cl_3`),
  KEY `cl_4` (`cl_4`),
  KEY `cl_5` (`cl_5`),
  FULLTEXT KEY `stitle` (`stitle`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;