DfhUTgCu

1-- MySQL dump 10.13  Distrib 5.1.52, for pc-linux-gnu (i686)
2--
3-- Host: localhost    Database: exchange
4-- ------------------------------------------------------
5-- Server version	5.1.52
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `sh_dividents_sending`
20--
21
22DROP TABLE IF EXISTS `sh_dividents_sending`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `sh_dividents_sending` (
26  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
27  `date` datetime DEFAULT NULL,
28  `last_update` datetime DEFAULT NULL,
29  `completed` tinyint(1) unsigned DEFAULT '0',
30  `amount` double(10,2) NOT NULL DEFAULT '0.00',
31  `shares` text COLLATE utf8_unicode_ci NOT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `sh_dividents_sending`
38--
39
40LOCK TABLES `sh_dividents_sending` WRITE;
41/*!40000 ALTER TABLE `sh_dividents_sending` DISABLE KEYS */;
42/*!40000 ALTER TABLE `sh_dividents_sending` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `sh_emails`
47--
48
49DROP TABLE IF EXISTS `sh_emails`;
50/*!40101 SET @saved_cs_client     = @@character_set_client */;
51/*!40101 SET character_set_client = utf8 */;
52CREATE TABLE `sh_emails` (
53  `id` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
54  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
55  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
56  `text` text COLLATE utf8_unicode_ci,
57  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
58  UNIQUE KEY `id` (`id`)
59) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
60/*!40101 SET character_set_client = @saved_cs_client */;
61
62--
63-- Dumping data for table `sh_emails`
64--
65
66LOCK TABLES `sh_emails` WRITE;
67/*!40000 ALTER TABLE `sh_emails` DISABLE KEYS */;
68INSERT INTO `sh_emails` (`id`, `name`, `subject`, `text`, `status`) VALUES ('registration','Registration Completetion','Registration Info','Hello #name#,\n\nThank you for registration on our site.\n\nYour login information:\n\nLogin: #username#\nPassword: #password#\n\nYou can login here: #site_url#\n\nContact us immediately if you did not authorize this registration.\n\nThank you.',1),('confirm_registration','Registration Confirmation','Confirm your registration','Hello #name#,\n\nThank you for registering in our program.\nPlease confirm your registration or ignore this message.\n\nCopy and paste this link to your browser:\n#site_url#/?a=confirm_registration&c=#confirm_string#\n\nThank you.\n#site_name#',1),('forgot_password','Password Reminder','The password you requested','Hello #name#,\r\n\r\nSomeone (most likely you) requested your username and password from the IP #ip#.\r\nYour password has been changed!!!\r\n\r\nYou can log into our account with:\r\n\r\nUsername: #username#\r\nPassword: #password#\r\n\r\nHope that helps.',1),('bonus','Bonus Notification','Bonus Notification','Hello #name#,\r\n\r\nYou received a bonus: $#amount#\r\nYou can check your statistics here:\r\n#site_url#\r\n\r\nGood luck.',1),('penalty','Penalty Notification','Penalty Notification','Hello #name#,\r\n\r\nYour account has been charged for $#amount#\r\nYou can check your statistics here:\r\n#site_url#\r\n\r\nGood luck.',1),('change_account','Account Change Notification','Account Change Notification','Hello #name#,\n\nYour account data has been changed from ip #ip#\n\n\nNew information:\n\nPassword: #password#\nE-gold account: #egold#\nE-mail address: #email#\n\nContact us immediately if you did not authorize this change.\n\nThank you.',1),('withdraw_request_user_notification','User Withdrawal Request Notification','Withdrawal Request has been sent','Hello #name#,\n\n\nYou has requested to withdraw $#amount#.\nRequest IP address is #ip#.\n\n\nThank you.\n#site_name#\n#site_url#',1),('withdraw_request_admin_notification','Administrator Withdrawal Request Notification','Withdrawal Request has been sent','User #username# requested to withdraw $#amount# from IP #ip#.',1),('withdraw_user_notification','User Withdrawal Notification','Withdrawal has been sent','Hello #name#.\n\n$#amount# has been successfully sent to your #currency# account #account#.\nTransaction batch is #batch#.\n\n#site_name#\n#site_url#',1),('withdraw_admin_notification','Administrator Withdrawal Notification','Withdrawal has been sent','User #username# received $#amount# to #currency# account #account#. Batch is #batch#.',1),('deposit_admin_notification','Administrator Deposit Notification','A deposit has been processed','User #username# deposit $#amount# #currency# to by #shares_amount# of #type#. Price of one share is $#price#.\n\nAccount: #account#\nBatch: #batch#\nReferrers fee: $#ref_sum#',1),('brute_force_activation','Account Activation after Brute Force','#site_name# - Your account activation code.','Someone from IP #ip# has entered a password for your account \"#username#\" incorrectly #max_tries# times. System locked your accout until you activate it.\n\nClick here to activate your account :\n\n#site_url#?a=activate&code=#activation_code#\n\nThank you.\n#site_name#',1),('direct_signup_notification','Direct Referral Signup','You have a new direct signup on #site_name#','Dear #name# (#username#)\n\nYou have a new direct signup on #site_name#\nUser: #ref_username#\nName: #ref_name#\nE-mail: #ref_email#\n\nThank you.',1),('referral_commision_notification','Referral Comission Notification','#site_name# Referral Comission','Dear #name# (#username#)\n\nYou have recived a referral comission of $#amount# #currency# from the #ref_name# (#ref_username#) deposit.\n\nThank you.',1),('pending_deposit_admin_notification','Deposit Request Admin Notification','Deposit Request Notification','User #username# save deposit $#amount# #currency# to by #shares_amount# of #type#. Price of one share is $#price#.\n\n#fields#',1),('deposit_approved_admin_notification','Deposit Approved Admin Notification','Deposit has been approved','Deposit has been approved:\n\nUser: #username# (#name#)\nAmount: $#amount# of #currency#\nShare: #type#\nNumber: #shares_amount#\nOne Share price: #price#\nDate: #deposit_date#\n#fields#',1),('deposit_approved_user_notification','Deposit Approved User Notification','Deposit has been approved','Dear #name# (#username#)\n\nYour deposit has been approved:\n\nAmount: $#amount# of #currency#\nShares Name: #type#\nNumber: #shares_amount#\nOne Share Price: $#price#\n#fields#',1),('account_update_confirmation','Account Update Confirmation','Account Update Confirmation','Dear #name# (#username#),\n\nSomeone from IP address #ip# (most likely you) is trying to change your account data.\n\nTo confirm these changes please use this Confirmation Code:\n#confirmation_code#\n\nThank you.\n#site_name#\n#site_url#',1);
69/*!40000 ALTER TABLE `sh_emails` ENABLE KEYS */;
70UNLOCK TABLES;
71
72--
73-- Table structure for table `sh_exchange_rates`
74--
75
76DROP TABLE IF EXISTS `sh_exchange_rates`;
77/*!40101 SET @saved_cs_client     = @@character_set_client */;
78/*!40101 SET character_set_client = utf8 */;
79CREATE TABLE `sh_exchange_rates` (
80  `sfrom` int(10) unsigned DEFAULT NULL,
81  `sto` int(10) unsigned DEFAULT NULL,
82  `percent` float(3,2) DEFAULT '0.00'
83) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
84/*!40101 SET character_set_client = @saved_cs_client */;
85
86--
87-- Dumping data for table `sh_exchange_rates`
88--
89
90LOCK TABLES `sh_exchange_rates` WRITE;
91/*!40000 ALTER TABLE `sh_exchange_rates` DISABLE KEYS */;
92/*!40000 ALTER TABLE `sh_exchange_rates` ENABLE KEYS */;
93UNLOCK TABLES;
94
95--
96-- Table structure for table `sh_graphs`
97--
98
99DROP TABLE IF EXISTS `sh_graphs`;
100/*!40101 SET @saved_cs_client     = @@character_set_client */;
101/*!40101 SET character_set_client = utf8 */;
102CREATE TABLE `sh_graphs` (
103  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
104  `type_id` bigint(20) unsigned DEFAULT NULL,
105  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
106  `title_font_size` tinyint(1) unsigned DEFAULT '3',
107  `hscale` double(10,2) DEFAULT '1.00',
108  `wlength` int(10) unsigned DEFAULT '1',
109  `wscale` enum('hour','day','week','month','year') COLLATE utf8_unicode_ci DEFAULT 'day',
110  `status` enum('on','off') COLLATE utf8_unicode_ci DEFAULT 'on',
111  PRIMARY KEY (`id`),
112  KEY `type_id` (`type_id`)
113) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
114/*!40101 SET character_set_client = @saved_cs_client */;
115
116--
117-- Dumping data for table `sh_graphs`
118--
119
120LOCK TABLES `sh_graphs` WRITE;
121/*!40000 ALTER TABLE `sh_graphs` DISABLE KEYS */;
122INSERT INTO `sh_graphs` (`id`, `type_id`, `title`, `title_font_size`, `hscale`, `wlength`, `wscale`, `status`) VALUES (1,1,'',2,1.00,10,'day','on');
123/*!40000 ALTER TABLE `sh_graphs` ENABLE KEYS */;
124UNLOCK TABLES;
125
126--
127-- Table structure for table `sh_history`
128--
129
130DROP TABLE IF EXISTS `sh_history`;
131/*!40101 SET @saved_cs_client     = @@character_set_client */;
132/*!40101 SET character_set_client = utf8 */;
133CREATE TABLE `sh_history` (
134  `id` bigint(20) NOT NULL AUTO_INCREMENT,
135  `user_id` bigint(20) NOT NULL DEFAULT '0',
136  `amount` float(10,5) DEFAULT NULL,
137  `type` enum('deposit','bonus','penality','earning','withdrawal','commissions','sell','add_funds','withdraw_pending','exchange_in','exchange_out','internal_transaction_spend','internal_transaction_receive') COLLATE utf8_unicode_ci DEFAULT NULL,
138  `description` text COLLATE utf8_unicode_ci NOT NULL,
139  `actual_amount` float(10,5) DEFAULT NULL,
140  `batch` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
141  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
142  `str` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
143  `ec` int(11) NOT NULL DEFAULT '0',
144  `deposit_id` bigint(20) NOT NULL DEFAULT '0',
145  PRIMARY KEY (`id`)
146) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
147/*!40101 SET character_set_client = @saved_cs_client */;
148
149--
150-- Dumping data for table `sh_history`
151--
152
153LOCK TABLES `sh_history` WRITE;
154/*!40000 ALTER TABLE `sh_history` DISABLE KEYS */;
155/*!40000 ALTER TABLE `sh_history` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `sh_news`
160--
161
162DROP TABLE IF EXISTS `sh_news`;
163/*!40101 SET @saved_cs_client     = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `sh_news` (
166  `id` bigint(20) NOT NULL AUTO_INCREMENT,
167  `date` datetime DEFAULT NULL,
168  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
169  `small_text` text COLLATE utf8_unicode_ci,
170  `full_text` text COLLATE utf8_unicode_ci,
171  PRIMARY KEY (`id`)
172) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `sh_news`
177--
178
179LOCK TABLES `sh_news` WRITE;
180/*!40000 ALTER TABLE `sh_news` DISABLE KEYS */;
181/*!40000 ALTER TABLE `sh_news` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `sh_online`
186--
187
188DROP TABLE IF EXISTS `sh_online`;
189/*!40101 SET @saved_cs_client     = @@character_set_client */;
190/*!40101 SET character_set_client = utf8 */;
191CREATE TABLE `sh_online` (
192  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
193  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
194) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
195/*!40101 SET character_set_client = @saved_cs_client */;
196
197--
198-- Dumping data for table `sh_online`
199--
200
201LOCK TABLES `sh_online` WRITE;
202/*!40000 ALTER TABLE `sh_online` DISABLE KEYS */;
203INSERT INTO `sh_online` (`ip`, `date`) VALUES ('95.122.33.205','2011-07-11 06:53:23');
204/*!40000 ALTER TABLE `sh_online` ENABLE KEYS */;
205UNLOCK TABLES;
206
207--
208-- Table structure for table `sh_pay_errors`
209--
210
211DROP TABLE IF EXISTS `sh_pay_errors`;
212/*!40101 SET @saved_cs_client     = @@character_set_client */;
213/*!40101 SET character_set_client = utf8 */;
214CREATE TABLE `sh_pay_errors` (
215  `id` bigint(20) NOT NULL AUTO_INCREMENT,
216  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
217  `txt` text COLLATE utf8_unicode_ci NOT NULL,
218  PRIMARY KEY (`id`)
219) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
220/*!40101 SET character_set_client = @saved_cs_client */;
221
222--
223-- Dumping data for table `sh_pay_errors`
224--
225
226LOCK TABLES `sh_pay_errors` WRITE;
227/*!40000 ALTER TABLE `sh_pay_errors` DISABLE KEYS */;
228/*!40000 ALTER TABLE `sh_pay_errors` ENABLE KEYS */;
229UNLOCK TABLES;
230
231--
232-- Table structure for table `sh_pay_settings`
233--
234
235DROP TABLE IF EXISTS `sh_pay_settings`;
236/*!40101 SET @saved_cs_client     = @@character_set_client */;
237/*!40101 SET character_set_client = utf8 */;
238CREATE TABLE `sh_pay_settings` (
239  `n` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
240  `v` text COLLATE utf8_unicode_ci NOT NULL
241) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
242/*!40101 SET character_set_client = @saved_cs_client */;
243
244--
245-- Dumping data for table `sh_pay_settings`
246--
247
248LOCK TABLES `sh_pay_settings` WRITE;
249/*!40000 ALTER TABLE `sh_pay_settings` DISABLE KEYS */;
250/*!40000 ALTER TABLE `sh_pay_settings` ENABLE KEYS */;
251UNLOCK TABLES;
252
253--
254-- Table structure for table `sh_pending_deposits`
255--
256
257DROP TABLE IF EXISTS `sh_pending_deposits`;
258/*!40101 SET @saved_cs_client     = @@character_set_client */;
259/*!40101 SET character_set_client = utf8 */;
260CREATE TABLE `sh_pending_deposits` (
261  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
262  `ec` bigint(20) unsigned DEFAULT NULL,
263  `price` double(10,2) DEFAULT NULL,
264  `fields` text COLLATE utf8_unicode_ci,
265  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
266  `amount` float(10,5) NOT NULL DEFAULT '0.00000',
267  `type_id` bigint(20) unsigned NOT NULL DEFAULT '0',
268  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
269  `status` enum('new','problem','processed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
270  PRIMARY KEY (`id`)
271) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
272/*!40101 SET character_set_client = @saved_cs_client */;
273
274--
275-- Dumping data for table `sh_pending_deposits`
276--
277
278LOCK TABLES `sh_pending_deposits` WRITE;
279/*!40000 ALTER TABLE `sh_pending_deposits` DISABLE KEYS */;
280/*!40000 ALTER TABLE `sh_pending_deposits` ENABLE KEYS */;
281UNLOCK TABLES;
282
283--
284-- Table structure for table `sh_prices`
285--
286
287DROP TABLE IF EXISTS `sh_prices`;
288/*!40101 SET @saved_cs_client     = @@character_set_client */;
289/*!40101 SET character_set_client = utf8 */;
290CREATE TABLE `sh_prices` (
291  `id` bigint(20) NOT NULL AUTO_INCREMENT,
292  `type_id` bigint(20) NOT NULL DEFAULT '0',
293  `price` float(10,2) DEFAULT NULL,
294  `date` datetime DEFAULT NULL,
295  PRIMARY KEY (`id`)
296) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
297/*!40101 SET character_set_client = @saved_cs_client */;
298
299--
300-- Dumping data for table `sh_prices`
301--
302
303LOCK TABLES `sh_prices` WRITE;
304/*!40000 ALTER TABLE `sh_prices` DISABLE KEYS */;
305INSERT INTO `sh_prices` (`id`, `type_id`, `price`, `date`) VALUES (1,1,0.69,'2011-07-05 17:53:40');
306/*!40000 ALTER TABLE `sh_prices` ENABLE KEYS */;
307UNLOCK TABLES;
308
309--
310-- Table structure for table `sh_processings`
311--
312
313DROP TABLE IF EXISTS `sh_processings`;
314/*!40101 SET @saved_cs_client     = @@character_set_client */;
315/*!40101 SET character_set_client = utf8 */;
316CREATE TABLE `sh_processings` (
317  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
318  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
319  `infofields` text COLLATE utf8_unicode_ci,
320  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
321  `description` text COLLATE utf8_unicode_ci NOT NULL,
322  PRIMARY KEY (`id`)
323) ENGINE=MyISAM AUTO_INCREMENT=1007 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
324/*!40101 SET character_set_client = @saved_cs_client */;
325
326--
327-- Dumping data for table `sh_processings`
328--
329
330LOCK TABLES `sh_processings` WRITE;
331/*!40000 ALTER TABLE `sh_processings` DISABLE KEYS */;
332INSERT INTO `sh_processings` (`id`, `name`, `infofields`, `status`, `description`) VALUES (999,'Bank Wire','a:3:{i:1;s:9:\"Bank Name\";i:2;s:12:\"Account Name\";i:3;s:15:\"Payment Details\";}',0,'Send your bank wires here:<br>\r\nBeneficiary\'s Bank Name: <b>Your Bank Name</b><br>\r\nBeneficiary\'s Bank SWIFT code: <b>Your Bank SWIFT code</b><br>\r\nBeneficiary\'s Bank Address: <b>Your Bank address</b><br>\r\nBeneficiary Account: <b>Your Account</b><br>\r\nBeneficiary Name: <b>Your Name</b><br>\r\n\r\nCorrespondent Bank Name: <b>Your Bank Name</b><br>\r\nCorrespondent Bank Address: <b>Your Bank Address</b><br>\r\nCorrespondent Bank codes: <b>Your Bank codes</b><br>\r\nABA: <b>Your ABA</b><br>'),(1000,'e-Bullion','a:2:{i:1;s:13:\"Payer Account\";i:2;s:14:\"Transaction ID\";}',0,'Please send your payments to this account: <b>Your e-Bullion account</b>'),(1001,'NetPay','a:2:{i:1;s:13:\"Payer Account\";i:2;s:14:\"Transaction ID\";}',0,'Send your funds to account: <b>Your NetPay account</b>'),(1002,'GoldMoney','a:2:{i:1;s:13:\"Payer Account\";i:2;s:14:\"Transaction ID\";}',0,'Send your fund to account: <b>your GoldMoney account</b>'),(1003,'MoneyBookers','a:2:{i:1;s:13:\"Payer Account\";i:2;s:14:\"Transaction ID\";}',0,'Send your funds to account: <b>your MoneyBookers account</b>'),(1004,'Pecunix','a:2:{i:1;s:19:\"Your e-mail address\";i:2;s:16:\"Reference Number\";}',0,'Send your funds to account: <b>your Pecunix account</b>'),(1005,'PicPay','a:2:{i:1;s:13:\"Payer Account\";i:2;s:14:\"Transaction ID\";}',0,'Send your funds to account: <b>Your PicPay account</b>'),(1006,'LibertyReserve','a:2:{i:1;s:15:\"Your LR Account\";i:2;s:5:\"Batch\";}',1,'Pay to U0999499');
333/*!40000 ALTER TABLE `sh_processings` ENABLE KEYS */;
334UNLOCK TABLES;
335
336--
337-- Table structure for table `sh_referal`
338--
339
340DROP TABLE IF EXISTS `sh_referal`;
341/*!40101 SET @saved_cs_client     = @@character_set_client */;
342/*!40101 SET character_set_client = utf8 */;
343CREATE TABLE `sh_referal` (
344  `id` bigint(20) NOT NULL AUTO_INCREMENT,
345  `level` bigint(20) NOT NULL DEFAULT '0',
346  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
347  `from_value` bigint(20) NOT NULL DEFAULT '0',
348  `to_value` bigint(20) NOT NULL DEFAULT '0',
349  `percent` double(10,2) DEFAULT NULL,
350  PRIMARY KEY (`id`)
351) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
352/*!40101 SET character_set_client = @saved_cs_client */;
353
354--
355-- Dumping data for table `sh_referal`
356--
357
358LOCK TABLES `sh_referal` WRITE;
359/*!40000 ALTER TABLE `sh_referal` DISABLE KEYS */;
360/*!40000 ALTER TABLE `sh_referal` ENABLE KEYS */;
361UNLOCK TABLES;
362
363--
364-- Table structure for table `sh_referal_stats`
365--
366
367DROP TABLE IF EXISTS `sh_referal_stats`;
368/*!40101 SET @saved_cs_client     = @@character_set_client */;
369/*!40101 SET character_set_client = utf8 */;
370CREATE TABLE `sh_referal_stats` (
371  `date` date NOT NULL DEFAULT '0000-00-00',
372  `user_id` bigint(20) NOT NULL DEFAULT '0',
373  `income` bigint(20) NOT NULL DEFAULT '0',
374  `reg` bigint(20) NOT NULL DEFAULT '0'
375) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
376/*!40101 SET character_set_client = @saved_cs_client */;
377
378--
379-- Dumping data for table `sh_referal_stats`
380--
381
382LOCK TABLES `sh_referal_stats` WRITE;
383/*!40000 ALTER TABLE `sh_referal_stats` DISABLE KEYS */;
384/*!40000 ALTER TABLE `sh_referal_stats` ENABLE KEYS */;
385UNLOCK TABLES;
386
387--
388-- Table structure for table `sh_settings`
389--
390
391DROP TABLE IF EXISTS `sh_settings`;
392/*!40101 SET @saved_cs_client     = @@character_set_client */;
393/*!40101 SET character_set_client = utf8 */;
394CREATE TABLE `sh_settings` (
395  `name` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
396  `value` text COLLATE utf8_unicode_ci NOT NULL
397) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
398/*!40101 SET character_set_client = @saved_cs_client */;
399
400--
401-- Dumping data for table `sh_settings`
402--
403
404LOCK TABLES `sh_settings` WRITE;
405/*!40000 ALTER TABLE `sh_settings` DISABLE KEYS */;
406/*!40000 ALTER TABLE `sh_settings` ENABLE KEYS */;
407UNLOCK TABLES;
408
409--
410-- Table structure for table `sh_shares`
411--
412
413DROP TABLE IF EXISTS `sh_shares`;
414/*!40101 SET @saved_cs_client     = @@character_set_client */;
415/*!40101 SET character_set_client = utf8 */;
416CREATE TABLE `sh_shares` (
417  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
418  `type_id` bigint(20) unsigned DEFAULT NULL,
419  `user_id` bigint(20) unsigned DEFAULT NULL,
420  `amount` bigint(20) unsigned NOT NULL DEFAULT '0',
421  `date` datetime DEFAULT NULL,
422  `price` double(10,5) DEFAULT '0.00000',
423  `status` enum('on','off') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'on',
424  `ec` bigint(20) unsigned DEFAULT NULL,
425  PRIMARY KEY (`id`),
426  KEY `type_id` (`type_id`,`user_id`)
427) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
428/*!40101 SET character_set_client = @saved_cs_client */;
429
430--
431-- Dumping data for table `sh_shares`
432--
433
434LOCK TABLES `sh_shares` WRITE;
435/*!40000 ALTER TABLE `sh_shares` DISABLE KEYS */;
436/*!40000 ALTER TABLE `sh_shares` ENABLE KEYS */;
437UNLOCK TABLES;
438
439--
440-- Table structure for table `sh_types`
441--
442
443DROP TABLE IF EXISTS `sh_types`;
444/*!40101 SET @saved_cs_client     = @@character_set_client */;
445/*!40101 SET character_set_client = utf8 */;
446CREATE TABLE `sh_types` (
447  `id` bigint(20) NOT NULL AUTO_INCREMENT,
448  `name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
449  `description` text COLLATE utf8_unicode_ci,
450  `status` enum('on','off','suspended') COLLATE utf8_unicode_ci DEFAULT NULL,
451  `parent` int(11) NOT NULL DEFAULT '0',
452  `sell` tinyint(1) unsigned NOT NULL DEFAULT '0',
453  `sell_percent` double(10,2) NOT NULL DEFAULT '0.00',
454  `sell_duration` int(10) unsigned NOT NULL DEFAULT '0',
455  `closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
456  `dsc` text COLLATE utf8_unicode_ci,
457  `price` float(10,2) NOT NULL DEFAULT '0.00',
458  `q_shares` bigint(20) NOT NULL DEFAULT '0',
459  `buy_percent` float(10,2) NOT NULL DEFAULT '0.00',
460  `last_update` datetime DEFAULT NULL,
461  PRIMARY KEY (`id`)
462) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
463/*!40101 SET character_set_client = @saved_cs_client */;
464
465--
466-- Dumping data for table `sh_types`
467--
468
469LOCK TABLES `sh_types` WRITE;
470/*!40000 ALTER TABLE `sh_types` DISABLE KEYS */;
471INSERT INTO `sh_types` (`id`, `name`, `description`, `status`, `parent`, `sell`, `sell_percent`, `sell_duration`, `closed`, `dsc`, `price`, `q_shares`, `buy_percent`, `last_update`) VALUES (1,'Share 1',NULL,'on',0,1,0.01,0,0,'',0.69,1000,0.01,'2011-07-05 17:53:40');
472/*!40000 ALTER TABLE `sh_types` ENABLE KEYS */;
473UNLOCK TABLES;
474
475--
476-- Table structure for table `sh_user_access_log`
477--
478
479DROP TABLE IF EXISTS `sh_user_access_log`;
480/*!40101 SET @saved_cs_client     = @@character_set_client */;
481/*!40101 SET character_set_client = utf8 */;
482CREATE TABLE `sh_user_access_log` (
483  `id` bigint(20) NOT NULL AUTO_INCREMENT,
484  `user_id` bigint(20) NOT NULL DEFAULT '0',
485  `date` datetime DEFAULT NULL,
486  `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
487  PRIMARY KEY (`id`)
488) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
489/*!40101 SET character_set_client = @saved_cs_client */;
490
491--
492-- Dumping data for table `sh_user_access_log`
493--
494
495LOCK TABLES `sh_user_access_log` WRITE;
496/*!40000 ALTER TABLE `sh_user_access_log` DISABLE KEYS */;
497INSERT INTO `sh_user_access_log` (`id`, `user_id`, `date`, `ip`) VALUES (1,1,'2011-07-05 17:22:39','114.57.132.172'),(2,1,'2011-07-07 11:38:20','89.165.89.115');
498/*!40000 ALTER TABLE `sh_user_access_log` ENABLE KEYS */;
499UNLOCK TABLES;
500
501--
502-- Table structure for table `sh_users`
503--
504
505DROP TABLE IF EXISTS `sh_users`;
506/*!40101 SET @saved_cs_client     = @@character_set_client */;
507/*!40101 SET character_set_client = utf8 */;
508CREATE TABLE `sh_users` (
509  `id` bigint(20) NOT NULL AUTO_INCREMENT,
510  `name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
511  `username` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
512  `password` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
513  `date_register` datetime DEFAULT NULL,
514  `egold_account` bigint(20) NOT NULL DEFAULT '0',
515  `email` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
516  `status` enum('on','off','suspended') COLLATE utf8_unicode_ci DEFAULT NULL,
517  `came_from` text COLLATE utf8_unicode_ci NOT NULL,
518  `ref` bigint(20) NOT NULL DEFAULT '0',
519  `deposit_total` float(10,2) NOT NULL DEFAULT '0.00',
520  `confirm_string` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
521  `ip_reg` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
522  `last_access_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
523  `last_access_ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
524  `stat_password` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
525  `auto_withdraw` int(11) NOT NULL DEFAULT '1',
526  `user_auto_pay_earning` int(11) NOT NULL DEFAULT '0',
527  `admin_auto_pay_earning` int(11) NOT NULL DEFAULT '0',
528  `pswd` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
529  `evocash_account` bigint(20) NOT NULL DEFAULT '0',
530  `intgold_account` bigint(20) NOT NULL DEFAULT '0',
531  `hid` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
532  `l_e_t` datetime NOT NULL DEFAULT '2004-01-01 00:00:00',
533  `activation_code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
534  `bf_counter` tinyint(3) unsigned NOT NULL DEFAULT '0',
535  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
536  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
537  `state` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
538  `zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
539  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
540  `transaction_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
541  `stormpay_account` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
542  `ebullion_account` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
543  `technocash_account` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
544  `anonygold_account` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
545  PRIMARY KEY (`id`)
546) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
547/*!40101 SET character_set_client = @saved_cs_client */;
548
549--
550-- Dumping data for table `sh_users`
551--
552
553LOCK TABLES `sh_users` WRITE;
554/*!40000 ALTER TABLE `sh_users` DISABLE KEYS */;
555INSERT INTO `sh_users` (`id`, `name`, `username`, `password`, `date_register`, `egold_account`, `email`, `status`, `came_from`, `ref`, `deposit_total`, `confirm_string`, `ip_reg`, `last_access_time`, `last_access_ip`, `stat_password`, `auto_withdraw`, `user_auto_pay_earning`, `admin_auto_pay_earning`, `pswd`, `evocash_account`, `intgold_account`, `hid`, `l_e_t`, `activation_code`, `bf_counter`, `address`, `city`, `state`, `zip`, `country`, `transaction_code`, `stormpay_account`, `ebullion_account`, `technocash_account`, `anonygold_account`) VALUES (1,'admin name','admin','fe01ce2a7fbac8fafaed7c982a04e229',NULL,0,'demo@phphyip.net','on','     ',0,0.00,'','','2011-07-07 11:38:22','89.165.89.115','',1,0,0,'',0,0,'A89D61FF9B7E719E2C5A925B13650B','2004-01-01 00:00:00','',0,NULL,NULL,NULL,NULL,NULL,'11061977','','','','');
556/*!40000 ALTER TABLE `sh_users` ENABLE KEYS */;
557UNLOCK TABLES;
558
559--
560-- Dumping routines for database 'exchange'
561--
562/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
563
564/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
565/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
566/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
567/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
568/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
569/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
570/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
571
572-- Dump completed on 2011-07-12  3:50:39