?? empirecms.com.sql
字號:
`softfj` varchar(255) NOT NULL default '',
`language` varchar(16) NOT NULL default '',
`softtype` varchar(16) NOT NULL default '',
`softsq` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`downpath` mediumtext NOT NULL,
`softsay` text NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_flash`;
CREATE TABLE `phome_ecms_infotmp_flash` (
`id` bigint(20) NOT NULL auto_increment,
`classid` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(30) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`keyboard` varchar(255) NOT NULL default '',
`titlepic` varchar(200) NOT NULL default '',
`flashwriter` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`filesize` varchar(16) NOT NULL default '',
`flashurl` varchar(255) NOT NULL default '',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
`flashsay` text NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_info`;
CREATE TABLE `phome_ecms_infotmp_info` (
`id` bigint(20) NOT NULL auto_increment,
`classid` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(30) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`keyboard` varchar(255) NOT NULL default '',
`titlepic` varchar(200) NOT NULL default '',
`smalltext` text NOT NULL,
`myarea` varchar(30) NOT NULL default '',
`email` varchar(80) NOT NULL default '',
`mycontact` varchar(255) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_movie`;
CREATE TABLE `phome_ecms_infotmp_movie` (
`id` bigint(20) NOT NULL auto_increment,
`classid` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(30) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`keyboard` varchar(255) NOT NULL default '',
`titlepic` varchar(200) NOT NULL default '',
`movietype` varchar(16) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`movietime` varchar(20) NOT NULL default '',
`player` varchar(255) NOT NULL default '',
`playadmin` varchar(255) NOT NULL default '',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`playdk` varchar(30) NOT NULL default '',
`playtime` varchar(20) NOT NULL default '',
`moviefen` int(11) NOT NULL default '0',
`downpath` mediumtext NOT NULL,
`onlinepath` mediumtext NOT NULL,
`moviesay` text NOT NULL,
`playerid` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_news`;
CREATE TABLE `phome_ecms_infotmp_news` (
`id` bigint(20) NOT NULL auto_increment,
`classid` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(30) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`keyboard` varchar(255) NOT NULL default '',
`titlepic` varchar(200) NOT NULL default '',
`ftitle` varchar(200) NOT NULL default '',
`smalltext` text NOT NULL,
`writer` varchar(30) NOT NULL default '',
`befrom` varchar(60) NOT NULL default '',
`newstext` mediumtext NOT NULL,
`diggtop` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_photo`;
CREATE TABLE `phome_ecms_infotmp_photo` (
`id` bigint(20) NOT NULL auto_increment,
`classid` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(30) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`keyboard` varchar(255) NOT NULL default '',
`titlepic` varchar(200) NOT NULL default '',
`filesize` varchar(10) NOT NULL default '',
`picsize` varchar(20) NOT NULL default '',
`picfbl` varchar(20) NOT NULL default '',
`picfrom` varchar(120) NOT NULL default '',
`picurl` varchar(200) NOT NULL default '',
`morepic` mediumtext NOT NULL,
`num` tinyint(4) NOT NULL default '0',
`width` varchar(12) NOT NULL default '',
`height` varchar(12) NOT NULL default '',
`picsay` text NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_infotmp_shop`;
CREATE TABLE `phome_ecms_infotmp_shop` (
`id` bigint(20) NOT NULL auto_increment,
`classid` int(11) NOT NULL default '0',
`oldurl` varchar(255) NOT NULL default '',
`checked` tinyint(1) NOT NULL default '0',
`tmptime` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(200) NOT NULL default '',
`newstime` datetime NOT NULL default '0000-00-00 00:00:00',
`username` varchar(30) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`truetime` int(11) NOT NULL default '0',
`keyboard` varchar(255) NOT NULL default '',
`titlepic` varchar(200) NOT NULL default '',
`productno` varchar(30) NOT NULL default '',
`pbrand` varchar(30) NOT NULL default '',
`intro` text NOT NULL,
`unit` varchar(16) NOT NULL default '',
`weight` varchar(20) NOT NULL default '',
`tprice` float(11,2) NOT NULL default '0.00',
`price` float(11,2) NOT NULL default '0.00',
`buyfen` int(11) NOT NULL default '0',
`pmaxnum` int(11) NOT NULL default '0',
`productpic` varchar(255) NOT NULL default '',
`newstext` mediumtext NOT NULL,
PRIMARY KEY (`id`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_movie`;
CREATE TABLE `phome_ecms_movie` (
`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` varchar(255) NOT NULL default '',
`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',
`titlefont` varchar(50) 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',
`isqf` tinyint(1) NOT NULL default '0',
`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 '',
`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',
`infopfen` int(11) NOT NULL default '0',
`infopfennum` int(11) NOT NULL default '0',
`votenum` int(11) NOT NULL default '0',
`movietype` varchar(16) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`movietime` varchar(20) NOT NULL default '',
`player` varchar(255) NOT NULL default '',
`playadmin` varchar(255) NOT NULL default '',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`playdk` varchar(30) NOT NULL default '',
`playtime` varchar(20) NOT NULL default '',
`moviefen` int(11) NOT NULL default '0',
`downpath` mediumtext NOT NULL,
`onlinepath` mediumtext NOT NULL,
`moviesay` text NOT NULL,
`playerid` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_movie_doc`;
CREATE TABLE `phome_ecms_movie_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` varchar(255) NOT NULL default '',
`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',
`titlefont` varchar(50) 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',
`isqf` tinyint(1) NOT NULL default '0',
`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 '',
`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',
`infopfen` int(11) NOT NULL default '0',
`infopfennum` int(11) NOT NULL default '0',
`votenum` int(11) NOT NULL default '0',
`movietype` varchar(16) NOT NULL default '',
`company` varchar(200) NOT NULL default '',
`movietime` varchar(20) NOT NULL default '',
`player` varchar(255) NOT NULL default '',
`playadmin` varchar(255) NOT NULL default '',
`filetype` varchar(10) NOT NULL default '',
`filesize` varchar(16) NOT NULL default '',
`star` tinyint(1) NOT NULL default '0',
`playdk` varchar(30) NOT NULL default '',
`playtime` varchar(20) NOT NULL default '',
`moviefen` int(11) NOT NULL default '0',
`downpath` mediumtext NOT NULL,
`onlinepath` mediumtext NOT NULL,
`moviesay` text NOT NULL,
`playerid` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `checked` (`checked`),
KEY `newstime` (`newstime`),
KEY `truetime` (`truetime`),
KEY `classid` (`classid`)
) TYPE=MyISAM;
# --------------------------------------------------------
DROP TABLE IF EXISTS `phome_ecms_news`;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -