Advertisement
Guest User

Transactions.sql

a guest
Dec 17th, 2015
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 3.63 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.0.10.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Dec 17, 2015 at 07:51 PM
  7. -- Server version: 5.5.46-0ubuntu0.14.04.2
  8. -- PHP Version: 5.5.9-1ubuntu4.14
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Database: `denilson_xlost`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `Transactions`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `Transactions` (
  30.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  31.   `Portfolio` varchar(64) NOT NULL,
  32.   `Date` datetime NOT NULL,
  33.   `Amount` decimal(20,12) NOT NULL,
  34.   PRIMARY KEY (`ID`)
  35. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=88 ;
  36.  
  37. --
  38. -- Dumping data for table `Transactions`
  39. --
  40.  
  41. INSERT INTO `Transactions` (`ID`, `Portfolio`, `Date`, `Amount`) VALUES
  42. (1, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2014-09-04 19:50:50', 0.000010000000),
  43. (2, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2014-03-17 07:39:04', 0.000100000000),
  44. (3, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-06-29 21:42:10', 0.020000000000),
  45. (4, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-05-09 17:55:10', 0.010000000000),
  46. (5, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-05-08 23:16:37', 0.000040000000),
  47. (6, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-04-05 13:38:40', 0.100000000000),
  48. (7, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-03-22 16:56:22', 0.019000010000),
  49. (8, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-03-22 10:00:55', 0.009999970000),
  50. (9, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-03-19 17:11:15', 0.040000000000),
  51. (10, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-03-19 17:09:43', 0.040000000000),
  52. (11, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-03-12 02:00:14', 0.000000040000),
  53. (12, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-02-28 19:17:40', 0.300000000000),
  54. (13, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-02-18 20:57:27', 0.389789290000),
  55. (14, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-02-13 00:46:54', 0.100000000000),
  56. (15, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-01-21 17:14:46', 0.300000000000),
  57. (16, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-01-20 01:57:15', 0.010000000000),
  58. (17, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-01-06 01:34:43', 0.104519600000),
  59. (18, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2013-01-05 18:50:43', 1.980000000000),
  60. (19, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-12-16 18:01:24', 1.000000000000),
  61. (20, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-12-06 17:53:42', 1.000000000000),
  62. (21, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-12-04 23:50:49', 0.111001100000),
  63. (22, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-11-11 19:53:05', 0.004430000000),
  64. (23, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-11-09 19:02:07', 0.130000000000),
  65. (24, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-10-30 22:22:36', 0.750000000000),
  66. (25, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-09-28 17:44:18', 0.010000000000),
  67. (26, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-09-24 22:31:49', 0.010000000000),
  68. (27, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-09-07 12:52:59', 3.000000000000),
  69. (28, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-08-29 19:10:32', 0.120000000000),
  70. (29, '1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28', '2012-07-17 18:37:57', 1.000000000000);
  71.  
  72. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  73. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  74. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement