renewenewsshopdd_1.php
1.92 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
<?php
@include("../../inc/header.php");
/*
SoftName : EmpireBak
Author : wm_chief
Copyright: Powered by www.phome.net
*/
E_D("DROP TABLE IF EXISTS `renewenewsshopdd`;");
E_C("CREATE TABLE `renewenewsshopdd` (
`ddid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ddno` varchar(30) NOT NULL DEFAULT '',
`ddtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`userid` mediumint(8) unsigned NOT NULL DEFAULT '0',
`username` varchar(30) NOT NULL DEFAULT '',
`outproduct` tinyint(1) NOT NULL DEFAULT '0',
`haveprice` tinyint(1) NOT NULL DEFAULT '0',
`checked` tinyint(1) NOT NULL DEFAULT '0',
`truename` varchar(20) NOT NULL DEFAULT '',
`oicq` varchar(25) NOT NULL DEFAULT '',
`msn` varchar(120) NOT NULL DEFAULT '',
`email` varchar(120) NOT NULL DEFAULT '',
`mycall` varchar(30) NOT NULL DEFAULT '',
`phone` varchar(30) NOT NULL DEFAULT '',
`address` varchar(255) NOT NULL DEFAULT '',
`zip` varchar(8) NOT NULL DEFAULT '',
`psid` smallint(6) NOT NULL DEFAULT '0',
`psname` varchar(60) NOT NULL DEFAULT '',
`pstotal` float(11,2) NOT NULL DEFAULT '0.00',
`alltotal` float(11,2) NOT NULL DEFAULT '0.00',
`payfsid` smallint(6) NOT NULL DEFAULT '0',
`payfsname` varchar(60) NOT NULL DEFAULT '',
`payby` tinyint(4) NOT NULL DEFAULT '0',
`alltotalfen` float(11,2) NOT NULL DEFAULT '0.00',
`fp` tinyint(1) NOT NULL DEFAULT '0',
`fptt` varchar(255) NOT NULL DEFAULT '',
`fptotal` float(11,2) NOT NULL DEFAULT '0.00',
`fpname` varchar(50) NOT NULL DEFAULT '',
`userip` varchar(20) NOT NULL DEFAULT '',
`signbuild` varchar(100) NOT NULL DEFAULT '',
`besttime` varchar(120) NOT NULL DEFAULT '',
`pretotal` float(11,2) NOT NULL DEFAULT '0.00',
`ddtruetime` int(10) unsigned NOT NULL DEFAULT '0',
`havecutnum` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`ddid`),
KEY `ddno` (`ddno`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8");
@include("../../inc/footer.php");
?>