· 10 years ago · Jun 19, 2015, 09:15 PM
1-- --------------------------------------------------------
2
3--
4-- Table structure for table `tbladmin`
5--
6
7CREATE TABLE `tbladmin` (
8 `intid` int(10) NOT NULL auto_increment,
9 `varusername` varchar(100) NOT NULL default '',
10 `varpassword` varchar(200) NOT NULL default '',
11 `varfirstname` varchar(50) NOT NULL default '',
12 `varlastname` varchar(50) NOT NULL default '',
13 `varphone` varchar(50) NOT NULL default '',
14 `varemail` varchar(100) NOT NULL default '',
15 `intstatus` int(10) NOT NULL default '0',
16 PRIMARY KEY (`intid`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
18
19--
20-- Dumping data for table `tbladmin`
21--
22
23INSERT INTO `tbladmin` VALUES (2, 'x', 'laZcpXVbYbblo', 'x', 'x', 'x', 1);
24INSERT INTO `tbladmin` VALUES (3, 'admin', 'admin', 'admin', 'worlds', 'admin@admin.com', 2);
25INSERT INTO `tbladmin` VALUES (4, 'fsdfsdfsdf', 'fsdfsdfsdf', 'fsdfsdfsdf', 'fsdfsdfsdf', 'fsdfsdfsdf@gmail.com', 0);
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `tblcoinimage`
31--
32
33CREATE TABLE `tblcoinimage` (
34 `intId` int(10) NOT NULL auto_increment,
35 `intCoinId` int(10) NOT NULL default '0',
36 `varPath` varchar(255) default NULL,
37 PRIMARY KEY (`intId`)
38) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
39
40--
41-- Dumping data for table `tblcoinimage`
42--
43
44INSERT INTO `tblcoinimage` VALUES (1, 1, '3411.jpg');
45INSERT INTO `tblcoinimage` VALUES (2, 2, '6722.jpg');
46INSERT INTO `tblcoinimage` VALUES (3, 3, '4333.jpg');
47INSERT INTO `tblcoinimage` VALUES (4, 4, 'i836_lg44.jpg');
48INSERT INTO `tblcoinimage` VALUES (5, 5, 'layout55.gif');
49INSERT INTO `tblcoinimage` VALUES (6, 6, 'player66.jpg');
50INSERT INTO `tblcoinimage` VALUES (7, 7, 'crock[1]77.jpg');
51INSERT INTO `tblcoinimage` VALUES (8, 8, 'Know_Your_Enemy_by_Ghost_in_the_Snow88.jpg');
52INSERT INTO `tblcoinimage` VALUES (9, 9, 'sfdg99.jpg');
53INSERT INTO `tblcoinimage` VALUES (10, 10, 'mmmm1010.jpg');
54INSERT INTO `tblcoinimage` VALUES (11, 11, 'blackberry1111.jpg');
55INSERT INTO `tblcoinimage` VALUES (12, 12, 'money1212.jpg');
56INSERT INTO `tblcoinimage` VALUES (13, 13, 'Hand Logo1313.jpg');
57INSERT INTO `tblcoinimage` VALUES (14, 14, 'AMT53601414.jpg');
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table `tblcoins`
63--
64
65CREATE TABLE `tblcoins` (
66 `intId` int(10) NOT NULL auto_increment,
67 `varTitle` varchar(200) NOT NULL default '',
68 `varDescription` text,
69 `intMemberId` int(10) NOT NULL default '0',
70 `dtadded` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
71 `intTotalHit` int(10) NOT NULL default '0',
72 `intTotalBuyOffer` int(10) NOT NULL default '0',
73 `intTotalTradeOffer` int(10) NOT NULL default '0',
74 `viewstatus` enum('0','1') NOT NULL default '0',
75 PRIMARY KEY (`intId`)
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
77
78--
79-- Dumping data for table `tblcoins`
80--
81
82INSERT INTO `tblcoins` VALUES (4, 'post', 'asdfasdf', 14, '2006-08-22 12:11:13', 7, 1, 3, '0');
83INSERT INTO `tblcoins` VALUES (5, 'tradi', 'adsfafds', 15, '2006-08-22 12:12:27', 12, 1, 1, '1');
84INSERT INTO `tblcoins` VALUES (6, 'trad2', 'asdfadf', 16, '2006-08-22 12:13:28', 3, 1, 0, '0');
85INSERT INTO `tblcoins` VALUES (7, 'funny', 'funny picture, will trade for a spoon\r\n\r\nor sell for $10', 18, '2006-08-22 12:51:11', 7, 1, 0, '0');
86INSERT INTO `tblcoins` VALUES (8, 'funny', 'very ', 18, '2006-08-22 12:55:32', 54, 2, 0, '1');
87INSERT INTO `tblcoins` VALUES (9, 'asdfasdf', 'asdfasdf', 14, '2006-08-31 18:03:05', 1, 0, 0, '1');
88INSERT INTO `tblcoins` VALUES (10, 'asdfasdfasdf', 'asdfasdfasdfasdfasdf', 14, '2006-08-31 18:03:33', 0, 0, 0, '1');
89INSERT INTO `tblcoins` VALUES (11, 'sdgsdgf', 'sdfgsfdgsfdgdsfgsdg', 14, '2006-09-06 13:02:54', 1, 0, 0, '1');
90INSERT INTO `tblcoins` VALUES (12, 'adsfadf', 'dasfasdfasdfasdf', 14, '2006-09-06 13:03:34', 2, 0, 0, '1');
91INSERT INTO `tblcoins` VALUES (13, 'REMOVING', 'adfasdfadf', 15, '2006-09-14 00:57:30', 1, 0, 1, '1');
92INSERT INTO `tblcoins` VALUES (14, 'awefe', 'asdfasfd', 14, '2006-09-14 00:58:10', 3, 0, 0, '1');
93
94-- --------------------------------------------------------
95
96--
97-- Table structure for table `tbldiscussion`
98--
99
100CREATE TABLE `tbldiscussion` (
101 `intId` int(11) NOT NULL auto_increment,
102 `intCoinId` int(11) NOT NULL default '0',
103 `intPostedFrom` int(11) NOT NULL default '0',
104 `intPostedTo` int(11) NOT NULL default '0',
105 `textMsg` text NOT NULL,
106 `intIsRead` enum('0','1') NOT NULL default '0',
107 `ttPostedat` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
108 `varPostedIP` varchar(200) NOT NULL default '',
109 `intRef` int(11) default '0',
110 PRIMARY KEY (`intId`)
111) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
112
113--
114-- Dumping data for table `tbldiscussion`
115--
116
117INSERT INTO `tbldiscussion` VALUES (2, 2, 11, 11, '2', '0', '2006-08-21 04:34:45', '2', 0);
118INSERT INTO `tbldiscussion` VALUES (3, 3, 0, 3, '3', '0', '2006-08-21 04:16:15', '3', 0);
119INSERT INTO `tbldiscussion` VALUES (4, 4, 4, 0, '4', '0', '2006-08-21 04:16:15', '4', 0);
120INSERT INTO `tbldiscussion` VALUES (6, 6, 0, 6, '6', '0', '2006-08-21 04:15:46', '6', 6);
121INSERT INTO `tbldiscussion` VALUES (12, 1, 11, 1, '1', '0', '2006-08-21 04:16:15', '1', 0);
122INSERT INTO `tbldiscussion` VALUES (13, 4, 18, 14, 'i have a funny picture that i can trade for.. if u want :) ', '1', '2006-08-22 12:52:42', '65.242.167.3', 0);
123INSERT INTO `tbldiscussion` VALUES (14, 13, 14, 15, 'why dont you answer?', '0', '2006-09-14 01:01:08', '24.185.83.30', 0);
124
125-- --------------------------------------------------------
126
127--
128-- Table structure for table `tblmembers`
129--
130
131CREATE TABLE `tblmembers` (
132 `intId` int(11) NOT NULL auto_increment,
133 `varUsername` varchar(200) NOT NULL default '',
134 `varPassword` varchar(200) NOT NULL default '',
135 `varEmail` varchar(200) NOT NULL default '',
136 `varFirstName` varchar(200) NOT NULL default '',
137 `varLastName` varchar(200) NOT NULL default '',
138 `varPhone` varchar(200) NOT NULL default '',
139 `intStatus` enum('0','1') NOT NULL default '0',
140 `varNickName` varchar(200) NOT NULL default '',
141 `ttRegisteredDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
142 `varRegisteredID` varchar(200) NOT NULL default '',
143 `ttLastLogin` timestamp NOT NULL default '0000-00-00 00:00:00',
144 `varLastLoginIP` varchar(200) NOT NULL default '',
145 `intTotalView` int(11) NOT NULL default '0',
146 PRIMARY KEY (`intId`)
147) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
148
149--
150-- Dumping data for table `tblmembers`
151--
152
153INSERT INTO `tblmembers` VALUES (14, 'UserOne', 'volume', 'resuba@gmail.com', 'First1', 'Last1', '1', 'UserOne', '2006-08-22 08:47:43', '72.89.210.83', '0000-00-00 00:00:00', '72.89.215.47', 0);
154INSERT INTO `tblmembers` VALUES (15, 'UserTwo', 'volume', 'introsoft2000@yahoo.co.uk', 'First2', 'Last2', '1', 'UserTwo', '2006-08-22 08:48:36', '72.89.210.83', '0000-00-00 00:00:00', '24.185.83.30', 0);
155INSERT INTO `tblmembers` VALUES (16, 'UserThree', 'volume', 'userdude3@yahoo.com', 'First3', 'Last3', '1', 'UserThree', '2006-08-22 08:49:37', '72.89.210.83', '0000-00-00 00:00:00', '72.89.210.83', 0);
156INSERT INTO `tblmembers` VALUES (17, 'Vi0let', 'poopsik', 'vi0let28@hotmail.com', 'Vi0let', 'Name', '0', 'Vi0let', '2006-08-22 12:38:52', '65.242.167.3', '0000-00-00 00:00:00', '0', 0);
157INSERT INTO `tblmembers` VALUES (18, 'Spoon45', 'poopsik', 'anizelnik@yahoo.com', 'me', 'you', '1', 'Spoon45', '2006-08-22 12:44:37', '65.242.167.3', '0000-00-00 00:00:00', '65.242.167.3', 0);
158INSERT INTO `tblmembers` VALUES (19, 'lalala', 'voliume', 'yo@yo.com', 'qqq', 'w', '0', 'lalala', '2006-08-25 13:04:00', '72.89.210.83', '0000-00-00 00:00:00', '0', 0);
159INSERT INTO `tblmembers` VALUES (20, 'dude222', 'volume', 'bla@ba.com', 'blah', 'bla', '0', 'dude222', '2006-08-25 14:46:03', '72.89.210.83', '0000-00-00 00:00:00', '0', 0);
160INSERT INTO `tblmembers` VALUES (21, 'mxicoders', 'pass12', 'mxicoders@yahoo.com', 'Ashok', 'Rathod', '1', 'mxicoders', '2006-08-30 23:04:50', '61.17.213.56', '0000-00-00 00:00:00', '61.17.213.56', 0);
161INSERT INTO `tblmembers` VALUES (22, 'agCooper0680', '0860repooCga', 'agCooper0680@hondo-corp.com', 'Larry', 'Cooper', '0', 'agCooper0680', '2006-09-05 16:28:15', '209.190.6.82', '0000-00-00 00:00:00', '0', 0);
162
163-- --------------------------------------------------------
164
165--
166-- Table structure for table `tbloffers`
167--
168
169CREATE TABLE `tbloffers` (
170 `intId` int(11) NOT NULL auto_increment,
171 `intCoinId` int(11) NOT NULL default '0',
172 `intOfferTo` int(11) NOT NULL default '0',
173 `intOfferFrom` int(11) NOT NULL default '0',
174 `intOfferType` int(11) NOT NULL default '0',
175 `decPrice` decimal(10,0) NOT NULL default '0',
176 `ttOfferDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
177 `intOfferStatus` int(11) NOT NULL default '0',
178 `varIP` varchar(200) NOT NULL default '',
179 PRIMARY KEY (`intId`)
180) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
181
182--
183-- Dumping data for table `tbloffers`
184--
185
186INSERT INTO `tbloffers` VALUES (1, 1, 9, 8, 2, 44, '2006-08-21 02:16:46', 0, '192.168.1.12');
187INSERT INTO `tbloffers` VALUES (2, 2, 8, 11, 2, 2222, '2006-08-21 02:16:46', 0, '192.168.1.12');
188INSERT INTO `tbloffers` VALUES (3, 4, 14, 15, 2, 45, '2006-08-22 12:12:40', 0, '72.89.210.83');
189INSERT INTO `tbloffers` VALUES (4, 5, 15, 16, 2, 656, '2006-08-22 12:13:59', 1, '72.89.210.83');
190INSERT INTO `tbloffers` VALUES (5, 7, 18, 14, 2, 2, '2006-08-22 13:49:36', 2, '72.89.210.83');
191INSERT INTO `tbloffers` VALUES (6, 8, 18, 14, 2, 5555, '2006-08-22 13:53:05', 2, '72.89.210.83');
192INSERT INTO `tbloffers` VALUES (7, 8, 18, 16, 2, 77, '2006-08-22 13:56:30', 2, '72.89.210.83');
193INSERT INTO `tbloffers` VALUES (8, 6, 16, 14, 2, 44, '2006-08-22 14:13:08', 2, '72.89.210.83');
194
195-- --------------------------------------------------------
196
197--
198-- Table structure for table `tblsettings`
199--
200
201CREATE TABLE `tblsettings` (
202 `intid` int(10) NOT NULL auto_increment,
203 `intMaxImagePercoin` int(10) NOT NULL default '0',
204 `varContactEmail` varchar(200) NOT NULL default '',
205 `varSiteURL` varchar(200) NOT NULL default '',
206 `varSiteTitle` varchar(200) NOT NULL default '',
207 `varcurrency` varchar(30) NOT NULL default '',
208 `mailsender` varchar(5) NOT NULL default '',
209 `thumbh` int(10) NOT NULL default '0',
210 `largeh` int(10) NOT NULL default '0',
211 `intimgheight` int(10) NOT NULL default '0',
212 `intwidth` int(10) NOT NULL default '0',
213 `varimgsize` varchar(20) NOT NULL default '',
214 `maindisplay` int(10) NOT NULL default '0',
215 `ttSettingUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
216 `varSettingsUpdatedFrom` varchar(200) NOT NULL default '',
217 PRIMARY KEY (`intid`)
218) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
219
220--
221-- Dumping data for table `tblsettings`
222--
223
224INSERT INTO `tblsettings` VALUES (1, 4, 'resuba@gmail.com', 'http://blah.com/blah/', 'blah blah', '$', '', 1, 1, 225, 225, '1000000000', 6, '2006-09-06 13:00:40', '72.89.215.47');
225
226-- --------------------------------------------------------
227
228--
229-- Table structure for table `tbltrading`
230--
231
232CREATE TABLE `tbltrading` (
233 `intId` int(10) NOT NULL auto_increment,
234 `intcoinid` int(10) NOT NULL default '0',
235 `intcoinid2` int(10) NOT NULL default '0',
236 `intstatus` int(10) default '0',
237 `datepost` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
238 `tradefrom` int(10) NOT NULL default '0',
239 `tradeto` int(10) NOT NULL default '0',
240 PRIMARY KEY (`intId`)
241) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
242
243--
244-- Dumping data for table `tbltrading`
245--
246
247INSERT INTO `tbltrading` VALUES (1, 1, 2, 1, '2006-08-21 02:27:33', 8, 9);
248INSERT INTO `tbltrading` VALUES (2, 2, 3, 2, '2006-08-21 02:27:33', 11, 8);
249INSERT INTO `tbltrading` VALUES (3, 4, 5, 0, '2006-08-22 12:12:27', 15, 14);
250INSERT INTO `tbltrading` VALUES (4, 5, 6, 0, '2006-08-22 12:13:28', 16, 15);
251INSERT INTO `tbltrading` VALUES (5, 4, 7, 1, '2006-08-22 12:51:11', 18, 14);
252INSERT INTO `tbltrading` VALUES (6, 4, 8, 0, '2006-08-22 12:55:32', 18, 14);
253INSERT INTO `tbltrading` VALUES (7, 13, 14, 2, '2006-09-14 00:58:10', 14, 0);