linux服务器织梦搭建

// 数据库配置文件 config.php
$dbhost = 'localhost'; // 数据库主机
$dbuser = 'root'; // 数据库用户名
$dbpwd = 'password'; // 数据库密码
$dbname = 'dedecms'; // 数据库名称

-- 创建数据库表结构
CREATE TABLE `dede_archives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `typeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `channel` smallint(5) unsigned NOT NULL DEFAULT '0',
  `arcrank` smallint(5) unsigned NOT NULL DEFAULT '0',
  `mid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `click` int(11) unsigned NOT NULL DEFAULT '0',
  `title` varchar(80) NOT NULL DEFAULT '',
  `color` varchar(10) NOT NULL DEFAULT '',
  `writer` varchar(30) NOT NULL DEFAULT '',
  `source` varchar(50) NOT NULL DEFAULT '',
  `litpic` varchar(100) NOT NULL DEFAULT '',
  `pubdate` int(11) unsigned NOT NULL DEFAULT '0',
  `senddate` int(11) unsigned NOT NULL DEFAULT '0',
  `adminID` smallint(5) unsigned NOT NULL DEFAULT '0',
  `keywords` varchar(60) NOT NULL DEFAULT '',
  `description` varchar(250) NOT NULL DEFAULT '',
  `filetype` smallint(5) unsigned NOT NULL DEFAULT '0',
  `sortrank` int(11) unsigned NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `ismake` tinyint(1) NOT NULL DEFAULT '-1',
  `ishot` tinyint(1) NOT NULL DEFAULT '0',
  `istop` tinyint(1) NOT NULL DEFAULT '0',
  `isdelete` tinyint(1) NOT NULL DEFAULT '0',
  `listorder` int(11) NOT NULL DEFAULT '0',
  `imgwidth` smallint(5) unsigned NOT NULL DEFAULT '0',
  `imgheight` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `idx_channel` (`channel`,`status`,`pubdate`,`id`),
  KEY `idxtypeid` (`typeid`,`status`,`pubdate`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;