renewecms_article_1.php
2.24 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
<?php
@include("../../inc/header.php");
/*
SoftName : EmpireBak
Author : wm_chief
Copyright: Powered by www.phome.net
*/
E_D("DROP TABLE IF EXISTS `renewecms_article`;");
E_C("CREATE TABLE `renewecms_article` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`classid` smallint(5) unsigned NOT NULL DEFAULT '0',
`ttid` smallint(5) unsigned NOT NULL DEFAULT '0',
`onclick` int(10) unsigned NOT NULL DEFAULT '0',
`plnum` mediumint(8) unsigned NOT NULL DEFAULT '0',
`totaldown` mediumint(8) unsigned NOT NULL DEFAULT '0',
`newspath` char(20) NOT NULL DEFAULT '',
`filename` char(36) NOT NULL DEFAULT '',
`userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` char(20) NOT NULL DEFAULT '',
`firsttitle` tinyint(1) NOT NULL DEFAULT '0',
`isgood` tinyint(1) NOT NULL DEFAULT '0',
`ispic` tinyint(1) NOT NULL DEFAULT '0',
`istop` tinyint(1) NOT NULL DEFAULT '0',
`isqf` tinyint(1) NOT NULL DEFAULT '0',
`ismember` tinyint(1) NOT NULL DEFAULT '0',
`isurl` tinyint(1) NOT NULL DEFAULT '0',
`truetime` int(10) unsigned NOT NULL DEFAULT '0',
`lastdotime` int(10) unsigned NOT NULL DEFAULT '0',
`havehtml` tinyint(1) NOT NULL DEFAULT '0',
`groupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`userfen` smallint(5) unsigned NOT NULL DEFAULT '0',
`titlefont` char(14) NOT NULL DEFAULT '',
`titleurl` char(200) NOT NULL DEFAULT '',
`stb` tinyint(3) unsigned NOT NULL DEFAULT '1',
`fstb` tinyint(3) unsigned NOT NULL DEFAULT '1',
`restb` tinyint(3) unsigned NOT NULL DEFAULT '1',
`keyboard` char(80) NOT NULL DEFAULT '',
`title` char(100) NOT NULL DEFAULT '',
`newstime` int(10) unsigned NOT NULL DEFAULT '0',
`titlepic` char(120) NOT NULL DEFAULT '',
`ftitle` char(120) NOT NULL DEFAULT '',
`smalltext` char(255) NOT NULL DEFAULT '',
`writer` char(30) NOT NULL DEFAULT '',
`befrom` char(60) NOT NULL DEFAULT '',
`newstext` char(50) NOT NULL DEFAULT '',
`diggtop` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `classid` (`classid`),
KEY `newstime` (`newstime`),
KEY `ttid` (`ttid`),
KEY `firsttitle` (`firsttitle`),
KEY `isgood` (`isgood`),
KEY `ispic` (`ispic`),
KEY `useridis` (`userid`,`ismember`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");
@include("../../inc/footer.php");
?>