?? empirecms.sql
字號:
# --------------------------------------------------------
#
# 帝國網站管理系統
#
# http://www.PHome.Net
#
# EmpireCMS Version 4.6
#
# --------------------------------------------------------
#
# 表的結構 `phome_ecms_article`
#
DROP TABLE IF EXISTS `phome_ecms_article`;
CREATE TABLE `phome_ecms_article` (
`id` int(11) NOT NULL auto_increment,
`classid` smallint(6) NOT NULL default '0',
`onclick` int(11) NOT NULL default '0',
`newspath` varchar(50) NOT NULL default '',
`keyboard` varchar(255) NOT NULL default '',
`keyid` varchar(255) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`ztid` text NOT NULL,
`checked` tinyint(1) NOT NULL default '0',
`istop` tinyint(4) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`ismember` tinyint(1) NOT NULL default '0',
`dokey` tinyint(1) NOT NULL default '0',
`userfen` int(11) NOT NULL default '0',
`isgood` tinyint(1) NOT NULL default '0',
`titlecolor` varchar(10) NOT NULL default '',
`titlefont` varchar(255) NOT NULL default '',
`titleurl` varchar(200) NOT NULL default '',
`filename` varchar(60) NOT NULL default '',
`filenameqz` varchar(28) NOT NULL default '',
`fh` tinyint(1) NOT NULL default '0',
`groupid` smallint(6) NOT NULL default '0',
`newstempid` smallint(6) NOT NULL default '0',
`plnum` int(11) NOT NULL default '0',
`firsttitle` tinyint(1) NOT NULL default '0',
`checkuser` text NOT NULL,
`docheckuser` text NOT NULL,
`viewcheckuser` text NOT NULL,
`returncheck` tinyint(1) NOT NULL default '0',
`notdocheckuser` text NOT NULL,
`totaldown` int(11) NOT NULL default '0',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(200) NOT NULL default '',
`wplay` tinyint(1) NOT NULL default '0',
`closepl` tinyint(1) NOT NULL default '0',
`havehtml` tinyint(1) NOT NULL default '0',
`lastdotime` int(11) NOT NULL default '0',
`haveaddfen` tinyint(1) NOT NULL default '0',
`ftitle` varchar(200) NOT NULL default '',
`smalltext` text NOT NULL,
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
#
# 導出表中的數據 `phome_ecms_article`
#
# --------------------------------------------------------
#
# 表的結構 `phome_ecms_article_doc`
#
DROP TABLE IF EXISTS `phome_ecms_article_doc`;
CREATE TABLE `phome_ecms_article_doc` (
`id` int(11) NOT NULL auto_increment,
`classid` smallint(6) NOT NULL default '0',
`onclick` int(11) NOT NULL default '0',
`newspath` varchar(50) NOT NULL default '',
`keyboard` varchar(255) NOT NULL default '',
`keyid` varchar(255) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`ztid` text NOT NULL,
`checked` tinyint(1) NOT NULL default '0',
`istop` tinyint(4) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`ismember` tinyint(1) NOT NULL default '0',
`dokey` tinyint(1) NOT NULL default '0',
`userfen` int(11) NOT NULL default '0',
`isgood` tinyint(1) NOT NULL default '0',
`titlecolor` varchar(10) NOT NULL default '',
`titlefont` varchar(255) NOT NULL default '',
`titleurl` varchar(200) NOT NULL default '',
`filename` varchar(60) NOT NULL default '',
`filenameqz` varchar(28) NOT NULL default '',
`fh` tinyint(1) NOT NULL default '0',
`groupid` smallint(6) NOT NULL default '0',
`newstempid` smallint(6) NOT NULL default '0',
`plnum` int(11) NOT NULL default '0',
`firsttitle` tinyint(1) NOT NULL default '0',
`checkuser` text NOT NULL,
`docheckuser` text NOT NULL,
`viewcheckuser` text NOT NULL,
`returncheck` tinyint(1) NOT NULL default '0',
`notdocheckuser` text NOT NULL,
`totaldown` int(11) NOT NULL default '0',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(200) NOT NULL default '',
`wplay` tinyint(1) NOT NULL default '0',
`closepl` tinyint(1) NOT NULL default '0',
`havehtml` tinyint(1) NOT NULL default '0',
`lastdotime` int(11) NOT NULL default '0',
`haveaddfen` tinyint(1) NOT NULL default '0',
`ftitle` varchar(200) NOT NULL default '',
`smalltext` text NOT NULL,
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
#
# 導出表中的數據 `phome_ecms_article_doc`
#
# --------------------------------------------------------
#
# 表的結構 `phome_ecms_download`
#
DROP TABLE IF EXISTS `phome_ecms_download`;
CREATE TABLE `phome_ecms_download` (
`id` int(11) NOT NULL auto_increment,
`classid` smallint(6) NOT NULL default '0',
`onclick` int(11) NOT NULL default '0',
`newspath` varchar(50) NOT NULL default '',
`keyboard` varchar(255) NOT NULL default '',
`keyid` varchar(255) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`username` varchar(30) NOT NULL default '',
`ztid` text NOT NULL,
`checked` tinyint(1) NOT NULL default '0',
`istop` tinyint(4) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`ismember` tinyint(1) NOT NULL default '0',
`dokey` tinyint(1) NOT NULL default '0',
`userfen` int(11) NOT NULL default '0',
`isgood` tinyint(1) NOT NULL default '0',
`titlecolor` varchar(10) NOT NULL default '',
`titlefont` varchar(255) NOT NULL default '',
`titleurl` varchar(200) NOT NULL default '',
`filename` varchar(60) NOT NULL default '',
`filenameqz` varchar(28) NOT NULL default '',
`fh` tinyint(1) NOT NULL default '0',
`groupid` smallint(6) NOT NULL default '0',
`newstempid` smallint(6) NOT NULL default '0',
`plnum` int(11) NOT NULL default '0',
`firsttitle` tinyint(1) NOT NULL default '0',
`checkuser` text NOT NULL,
`docheckuser` text NOT NULL,
`viewcheckuser` text NOT NULL,
`returncheck` tinyint(1) NOT NULL default '0',
`notdocheckuser` text NOT NULL,
`totaldown` int(11) NOT NULL default '0',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`titlepic` varchar(200) NOT NULL default '',
`wplay` tinyint(1) NOT NULL default '0',
`closepl` tinyint(1) NOT NULL default '0',
`havehtml` tinyint(1) NOT NULL default '0',
`lastdotime` int(11) NOT NULL default '0',
`haveaddfen` tinyint(1) NOT NULL default '0',
`softwriter` varchar(30) NOT NULL default '',
`homepage` varchar(80) NOT NULL default '',
`demo` varchar(120) NOT NULL default '',
`softfj` varchar(255) NOT NULL default '',
`language` varchar(30) NOT NULL default '',
`softtype` varchar(30) NOT NULL default '',
`softsq` varchar(30) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filetype` varchar(20) NOT NULL default '',
`filesize` varchar(30) NOT NULL default '',
`downpath` mediumtext NOT NULL,
`softsay` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
#
# 導出表中的數據 `phome_ecms_download`
#
INSERT INTO `phome_ecms_download` VALUES (1, 3, 0, '', '', '', 1, 'admin', '|', 1, 0, 1158139094, 0, 0, 0, 0, '', '', '', '1', '', 0, 0, 2, 0, 0, '', ',', ',', 0, ',', 23, '帝國網站管理系統下載', '2006-09-13 17:14:13', '', 0, 0, 1, 1176288224, 0, '帝國開發', 'http://www.phome.net', 'http://www.phome.net', 'PHP+MYSQL', '簡體中文', '國產軟件', '免費軟件', 5, '.rar', '2 MB', '下載地址1::::::http://www.phome.net::::::0::::::0::::::', ' Ecms全稱為"帝國網站管理系統",英文譯為"Empire CMS"簡稱"Ecms".\r\n 本系統由帝國開發工作組獨立開發,是一個經過完善設計的適用于Linux/windows/Unix等環境下高效的網站解決方案。從帝國新聞系統1.0版至今天的帝國網站管理系統,她的功能進行了數次飛躍性地革新,使得網站的架設與管理變得極其輕松!她采用了系統模型功能:通過后臺的字段定義與模型定義可實現多種系統的功能.采用模板分離功能:把內容與界面完全分離,靈活的標簽+用戶自定義標簽,使之能實現各式各樣的網站頁面與風格.欄目無限級分類.前臺全部靜態:可隨受強大的訪問量.強大的信息采集功能.超強廣告管理功能...');
INSERT INTO `phome_ecms_download` VALUES (2, 3, 0, '', '', '', 1, 'admin', '|', 1, 0, 1158139159, 0, 0, 0, 0, '', '', 'http://www.phome.net/product/Ebak.html', '2', '', 0, 0, 2, 0, 0, '', ',', ',', 0, ',', 0, '帝國備份王1.5穩定版下載', '2006-09-13 17:18:37', '', 0, 0, 0, 1158139159, 0, '', '', '', '', '', '', '', 0, '', '', '', '');
INSERT INTO `phome_ecms_download` VALUES (3, 3, 0, '', '', '', 1, 'admin', '|', 1, 0, 1158139243, 0, 0, 0, 0, '', '', '', '3', '', 0, 0, 2, 0, 0, '', ',', ',', 0, ',', 0, '帝國下載系統 2.1版免費下載', '2006-09-13 17:19:27', '', 0, 0, 1, 1158139365, 0, '帝國開發', 'http://www.phome.net', 'http://www.phome.net/tmp/edown21/', 'PHP+MYSQL', '簡體中文', '國產軟件', '免費軟件', 4, '.rar', '1.2 MB', '下載地址1::::::http://www.phome.net/tmp/edown21/::::::0::::::0::::::', '《帝國下載系統》是為網站資料下載與在線影視網站提供的解決方案。功能強大,簡單易用,全靜態頁面,完善的會員收費方案,全面滿足免費與收費下載或影視網站需求。');
INSERT INTO `phome_ecms_download` VALUES (4, 3, 0, '', 'Zend', '', 1, 'admin', '|', 1, 0, 1158140428, 0, 0, 0, 0, '', '', '', '4', '', 0, 0, 2, 0, 0, '', ',', ',', 0, ',', 0, 'Zend Optimizer 2.5.10下載', '2006-09-13 17:37:47', '', 0, 0, 1, 1158140428, 0, 'zend', 'http://www.zend.com', 'http://www.zend.com', 'Window/unix/linux', '簡體中文', '國外軟件', '免費軟件', 2, '.exe', '4.26 MB', '下載地址1::::::http://www.phome.net::::::0::::::0::::::', 'Zend Optimizer 2.5.10下載');
INSERT INTO `phome_ecms_download` VALUES (5, 3, 0, '', 'MYSQL', '', 1, 'admin', '|', 1, 0, 1158140616, 0, 0, 0, 0, '', '', '', '5', '', 0, 0, 2, 0, 0, '', ',', ',', 0, ',', 0, 'MYSQL下載', '2006-09-13 17:40:39', '', 0, 0, 1, 1158140616, 0, 'wm_chief', 'http://www.mysql.com', '#', 'WINDOW/UNIX/LINUX', '簡體中文', '國外軟件', '免費軟件', 3, '.rar', '5 MB', '下載地址1::::::http://www.phome.net::::::0::::::0::::::', 'MYSQL下載');
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -