📄 empirecms.sql

📁 帝国CMS,功能全面的CMS源码,下载试用下
💻 SQL
📖 第 1 页 / 共 5 页
字号:
# --------------------------------------------------------

#
# 表的结构 `phome_ecms_download_doc`
#

DROP TABLE IF EXISTS `phome_ecms_download_doc`;
CREATE TABLE `phome_ecms_download_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',
  `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_doc`
#


# --------------------------------------------------------

#
# 表的结构 `phome_ecms_flash`
#

DROP TABLE IF EXISTS `phome_ecms_flash`;
CREATE TABLE `phome_ecms_flash` (
  `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',
  `flashwriter` varchar(30) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `star` tinyint(1) NOT NULL default '0',
  `filesize` varchar(30) NOT NULL default '',
  `flashurl` varchar(255) NOT NULL default '',
  `width` varchar(20) NOT NULL default '',
  `height` varchar(20) NOT NULL default '',
  `flashsay` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `newstime` (`newstime`),
  KEY `truetime` (`truetime`),
  KEY `classid` (`classid`)
) TYPE=MyISAM;

#
# 导出表中的数据 `phome_ecms_flash`
#

INSERT INTO `phome_ecms_flash` VALUES (1, 6, 2, '', '拳皇', '3,5', 1, 'admin', '|', 1, 0, 1158144881, 0, 0, 0, 1, '', '', '', '1', '', 0, 0, 5, 0, 0, '', ',', ',', 0, ',', 0, '拳皇-梦幻之战', '2006-09-13 18:51:44', 'http://file3.flash8.net/2oo6swf/27/flash8net_26589_200.jpg', 0, 0, 1, 1158151091, 0, '梦旅人', '', 3, '2053 KB', 'http://file8.flash8.net/2oo6swf/27/flash8net_26589.swf', '530', '380', ' 以《拳皇》为蓝本制作的flash格斗游戏，实现了格斗游戏的基本要素，具有优秀的操作感、打击感和爽快的连续技，超越了国内外大多数flash格斗游戏。目前为止只是制作flash格斗引擎，以后将不断加入新角色甚至原创角色，实现梦幻般的动漫游戏角色大乱斗。');
INSERT INTO `phome_ecms_flash` VALUES (2, 6, 2, '', '', '', 1, 'admin', '|', 1, 0, 1158145076, 0, 0, 0, 0, '', '', '', '2', '', 0, 0, 5, 0, 0, '', ',', ',', 0, ',', 0, '魔力弹球2', '2006-09-13 18:56:28', 'http://file3.flash8.net/2oo6swf/27/flash8net_26733_200.jpg', 0, 0, 1, 1158151167, 0, '快刀吹雪', '', 3, '869 K', 'http://file3.flash8.net/2oo6swf/27/flash8net_26733.swf', '530', '380', '魔力弹球2');
INSERT INTO `phome_ecms_flash` VALUES (3, 6, 0, '', '拳皇', '1,5', 1, 'admin', '|', 1, 0, 1158145194, 0, 0, 0, 0, '', '', '', '3', '', 0, 0, 5, 0, 0, '', ',', ',', 0, ',', 0, '拳皇-梦幻之战（2）', '2006-09-13 18:51:44', 'http://file3.flash8.net/2oo6swf/27/flash8net_26589_200.jpg', 0, 0, 1, 1158151129, 0, '梦旅人', '', 3, '2053 KB', 'http://file8.flash8.net/2oo6swf/27/flash8net_26589.swf', '530', '380', ' 以《拳皇》为蓝本制作的flash格斗游戏，实现了格斗游戏的基本要素，具有优秀的操作感、打击感和爽快的连续技，超越了国内外大多数flash格斗游戏。目前为止只是制作flash格斗引擎，以后将不断加入新角色甚至原创角色，实现梦幻般的动漫游戏角色大乱斗。');
INSERT INTO `phome_ecms_flash` VALUES (4, 6, 0, '', '', '', 1, 'admin', '|', 1, 0, 1158145194, 0, 0, 0, 0, '', '', '', '4', '', 0, 0, 5, 0, 0, '', ',', ',', 0, ',', 0, '魔力弹球2（2）', '2006-09-13 18:56:28', 'http://file3.flash8.net/2oo6swf/27/flash8net_26733_200.jpg', 0, 0, 1, 1158151178, 0, '快刀吹雪', '', 3, '869 K', 'http://file3.flash8.net/2oo6swf/27/flash8net_26733.swf', '530', '380', '魔力弹球2');
INSERT INTO `phome_ecms_flash` VALUES (5, 6, 0, '', '拳皇', '1,3', 1, 'admin', '|', 1, 0, 1158145209, 0, 0, 0, 0, '', '', '', '5', '', 0, 0, 5, 0, 0, '', ',', ',', 0, ',', 0, '拳皇-梦幻之战（3）', '2006-09-13 18:51:44', 'http://file3.flash8.net/2oo6swf/27/flash8net_26589_200.jpg', 0, 0, 1, 1158151143, 0, '梦旅人', '', 3, '2053 KB', 'http://file8.flash8.net/2oo6swf/27/flash8net_26589.swf', '530', '380', ' 以《拳皇》为蓝本制作的flash格斗游戏，实现了格斗游戏的基本要素，具有优秀的操作感、打击感和爽快的连续技，超越了国内外大多数flash格斗游戏。目前为止只是制作flash格斗引擎，以后将不断加入新角色甚至原创角色，实现梦幻般的动漫游戏角色大乱斗。');

# --------------------------------------------------------

#
# 表的结构 `phome_ecms_flash_doc`
#

DROP TABLE IF EXISTS `phome_ecms_flash_doc`;
CREATE TABLE `phome_ecms_flash_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',
  `flashwriter` varchar(30) NOT NULL default '',
  `email` varchar(80) NOT NULL default '',
  `star` tinyint(1) NOT NULL default '0',
  `filesize` varchar(30) NOT NULL default '',
  `flashurl` varchar(255) NOT NULL default '',
  `width` varchar(20) NOT NULL default '',
  `height` varchar(20) NOT NULL default '',
  `flashsay` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `newstime` (`newstime`),
  KEY `truetime` (`truetime`),
  KEY `classid` (`classid`)
) TYPE=MyISAM;

#
# 导出表中的数据 `phome_ecms_flash_doc`
#


# --------------------------------------------------------
💿 文件大小 2811 K
👤 上传用户 sunny_02
📂 所属分类 Internet/网络编程
🏷️ 相关标签

#CMS #源码
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -