API tools faq
paste
Advertisement
Guest User

DB#1

a guest
Jul 24th, 2016
440
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.56 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 2.11.11.3
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 50.63.238.6
  6. -- Generation Time: Mar 21, 2013 at 11:23 AM
  7. -- Server version: 5.0.96
  8. -- PHP Version: 5.1.6
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `rental2233`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Table structure for table `main_building`
  20. --
  21.  
  22. CREATE TABLE `main_building` (
  23. `id` int(11) NOT NULL auto_increment,
  24. `name` text NOT NULL,
  25. `address` text NOT NULL,
  26. `city` text NOT NULL,
  27. `province` text NOT NULL,
  28. `postal` text NOT NULL,
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  31.  
  32. --
  33. -- Dumping data for table `main_building`
  34. --
  35.  
  36. INSERT INTO `main_building` VALUES(1, 'THE CORNER', '2416 14A ST SW', 'CALGARY', 'ALBERTA', 'T2T 3X3');
  37. INSERT INTO `main_building` VALUES(2, 'EL VALLE MANOR', '2417 14A ST SW', 'CALGARY', 'ALBERTA', 'T2T 3X4');
  38. INSERT INTO `main_building` VALUES(3, 'THE PARK', '3802 16 ST SW', 'CALGARY', 'ALBERTA', 'T2T 4H3');
  39.  
  40. -- --------------------------------------------------------
  41.  
  42. --
  43. -- Table structure for table `suites`
  44. --
  45.  
  46. CREATE TABLE `suites` (
  47. `id` int(11) NOT NULL auto_increment,
  48. `email` text NOT NULL,
  49. `pass` text NOT NULL,
  50. `b_name` text NOT NULL,
  51. `unit` text NOT NULL,
  52. `fname` text NOT NULL,
  53. `lname` text NOT NULL,
  54. `hphone` text NOT NULL,
  55. `wphone` text NOT NULL,
  56. `cphone` text NOT NULL,
  57. `rentamount` decimal(7,2) NOT NULL,
  58. `startrent` date NOT NULL,
  59. `endrent` date NOT NULL,
  60. `lease` text NOT NULL,
  61. `regulation` text NOT NULL,
  62. `walk` text NOT NULL,
  63. PRIMARY KEY (`id`)
  64. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=59 ;
  65.  
  66. --
  67. -- Dumping data for table `suites`
  68. --
  69.  
  70. INSERT INTO `suites` VALUES(9, 'blittle@westjet.com', 'c26rbfvj', 'THE CORNER', '104', 'bLAIR', 'lITTLE', '403-797-6235', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  71. INSERT INTO `suites` VALUES(8, '', 'oxg7z3es', 'THE CORNER', '103', 'Judy', 'Smith', '403-244-3433', '', '', 900.00, '2011-12-01', '2011-12-01', '', '', '');
  72. INSERT INTO `suites` VALUES(34, '', 'ue40zfiv', 'EL VALLE MANOR', '103', 'Daniel', 'Fonkwe', '', '', '', 900.00, '2011-12-01', '2011-12-01', '', '', '');
  73. INSERT INTO `suites` VALUES(35, '', 'uobwruz6', 'EL VALLE MANOR', '105', 'faisal', 'ahmed', '', '', '', 1000.00, '2013-01-01', '2013-06-30', '', '', '');
  74. INSERT INTO `suites` VALUES(33, '', 'ksxnm6yv', 'EL VALLE MANOR', '101', 'Gramoz', 'Halili', '', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  75. INSERT INTO `suites` VALUES(10, 'tinaye.masiwa@yagoo.ca', 'ah7fo4ga', 'THE CORNER', '105', 'tinaya', 'masiwa', '403-689-4909', '', '', 885.00, '2011-12-01', '2011-12-01', '', '', '');
  76. INSERT INTO `suites` VALUES(11, '', 'zt5octay', 'THE CORNER', '106', 'Diana', 'mamedov', '403-614-2372', '403-614-7243', '', 900.00, '2012-10-01', '2013-03-31', '', '', '');
  77. INSERT INTO `suites` VALUES(12, 'wyndjam2@hotmail.com', 'uvtqgs0w', 'THE CORNER', '107', 'David', 'Wynne', '403-245-0196', '', '', 1000.00, '2011-12-01', '2011-12-01', '', '', '');
  78. INSERT INTO `suites` VALUES(13, 'rholmes@telus.net', '2ha2z8a6', 'THE CORNER', '108', 'Rodney', 'holmes', '403-243-6693', '', '', 1100.00, '2011-12-01', '2011-12-01', '', '', '');
  79. INSERT INTO `suites` VALUES(14, 'meaghan@calgaryhomeless.com', 'w8qgzmh0', 'THE CORNER', '201', 'meaghan', 'bell', '403-862-9189', '', '', 1100.00, '2012-09-01', '2013-02-28', '', '', '');
  80. INSERT INTO `suites` VALUES(16, 'brencrosby@gmail.com', '6gm3v274', 'THE CORNER', '202', 'branden', 'crosby', '403-483-7893', '403-888-6403', '', 1200.00, '2011-12-01', '2011-12-01', '', '', '');
  81. INSERT INTO `suites` VALUES(17, 'nicole.white@ledcore.com', 'ahzfkf7o', 'THE CORNER', '203', 'nicole', 'white', '780-215-2043', '', '', 900.00, '2012-10-01', '2013-03-31', '', '', '');
  82. INSERT INTO `suites` VALUES(18, 'cfgoddard@gmail.com', 'o7apjzpg', 'THE CORNER', '204', 'Cynthia', 'goddard', '403-620-7924', '', '', 885.00, '2011-12-01', '2011-12-01', '', '', '');
  83. INSERT INTO `suites` VALUES(19, 'mchakaza@hotmail.com', 'adh3efzm', 'THE CORNER', '205', 'Matthew', 'Chakaza', '403-560-0774', '', '', 885.00, '2011-12-01', '2011-12-01', '', '', '');
  84. INSERT INTO `suites` VALUES(20, 'escavo@hotmail.com', 'ymw8v20y', 'THE CORNER', '206', 'cayla', 'scavo', '403-701-9522', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  85. INSERT INTO `suites` VALUES(23, 'ctetreau@gmail.com', 'mip2jqt7', 'THE CORNER', '208', 'michelle', 'tetreau', '403-863-5845', '', '', 1100.00, '2011-12-01', '2011-12-01', '', '', '');
  86. INSERT INTO `suites` VALUES(22, 'gelu.lapusneaunu@yahoo.com', 'thduais8', 'THE CORNER', '207', 'Gelu', 'lapusneanu', '403-542-6602', '403-629-3102', '', 1100.00, '2011-12-01', '2011-12-01', '', '', '');
  87. INSERT INTO `suites` VALUES(24, 'mikebdawson@gmail.com', 'zij62oa3', 'THE CORNER', '301', 'michael', 'dawson', '403-923-7796', '', '', 1300.00, '2013-02-01', '2013-07-31', '', '', '');
  88. INSERT INTO `suites` VALUES(25, 'claudiupop28@gmail.com', 'u0yjsvxh', 'THE CORNER', '302', 'claudiu', 'pop', '403-970-6117', '', '', 1100.00, '2012-09-01', '2013-02-28', '', '', '');
  89. INSERT INTO `suites` VALUES(26, 'marquis.jennings@gmail.com', 'x3ysq8ef', 'THE CORNER', '303', 'marquis', 'jennings', '587-888-5352', '', '', 1000.00, '2012-02-01', '2013-07-31', '', '', '');
  90. INSERT INTO `suites` VALUES(27, 'senyathi@msn.com', 'rxipegqg', 'THE CORNER', '304', 'Se', 'neyathi', '403-470-7572', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  91. INSERT INTO `suites` VALUES(28, 'mworth@mtroyal.ca', 'ay3qt7x6', 'THE CORNER', '305', 'myles', 'worth', '403-542-8967', '587-215-2985', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  92. INSERT INTO `suites` VALUES(29, 'walchuck@ualberta.ca', '5n02vmd0', 'THE CORNER', '306', 'michael', 'walchuck', '403-479-8007', '', '', 885.00, '2011-12-01', '2011-12-01', '', '', '');
  93. INSERT INTO `suites` VALUES(32, 'tannis.weiss@gmail.com', '00xa7apk', 'THE CORNER', '308', 'Tannis', 'Weiss', '403-975-6251', '403-700-4866', '', 1100.00, '2011-12-01', '2011-12-01', '', '', '');
  94. INSERT INTO `suites` VALUES(31, '', '6cquc8vj', 'THE CORNER', '307', 'scott', 'kennedy', '403-603-8315', '403-652-8984', '', 1200.00, '2012-10-01', '2013-03-31', '', '', '');
  95. INSERT INTO `suites` VALUES(36, 'bouvier888@gmail.com', 'wrjz34ku', 'THE CORNER', '102', 'Louise', 'Bouvier', '403-220-9553', '', '', 0.00, '2011-12-01', '2011-12-01', '', '', '');
  96. INSERT INTO `suites` VALUES(37, 'dbartman@gmail.com', 'b5a0zmxk', 'EL VALLE MANOR', '201', 'Declan', 'Bartman', '587-899-5850', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  97. INSERT INTO `suites` VALUES(38, '', 'figaxime', 'EL VALLE MANOR', '202', 'Yetnayet (Yeti)', 'Dinberu', '', '', '', 1100.00, '2011-12-01', '2011-12-01', '', '', '');
  98. INSERT INTO `suites` VALUES(39, '', '4kvm5wxn', 'EL VALLE MANOR', '203', 'Shola', 'adeniyi', '', '', '', 900.00, '2011-12-01', '2011-12-01', '', '', '');
  99. INSERT INTO `suites` VALUES(40, '', 'h8soyzdf', 'EL VALLE MANOR', '204', 'netize', 'ozgur', '', '', '', 1000.00, '2013-02-01', '2013-07-31', '', '', '');
  100. INSERT INTO `suites` VALUES(41, '', 'g42virx6', 'EL VALLE MANOR', '205', 'lindsay', 'lenny', '', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  101. INSERT INTO `suites` VALUES(42, '', '83xdmbzg', 'EL VALLE MANOR', '206', 'margaret', 'bain', '', '', '', 1200.00, '2011-12-01', '2011-12-01', '', '', '');
  102. INSERT INTO `suites` VALUES(43, '', 'fegeqjjp', 'EL VALLE MANOR', '207', 'david', 'budd', '', '', '', 900.00, '2011-12-01', '2011-12-01', '', '', '');
  103. INSERT INTO `suites` VALUES(44, '', 'nndagpq4', 'EL VALLE MANOR', '301', 'michael', 'amentie', '', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  104. INSERT INTO `suites` VALUES(46, '', '4m7erb8g', 'EL VALLE MANOR', '302', 'guy', 'lemieux', '', '', '', 1155.00, '2011-12-01', '2011-12-01', '', '', '');
  105. INSERT INTO `suites` VALUES(47, '', 'fwiepp3x', 'EL VALLE MANOR', '303', 'jessica', 'henderson', '', '', '', 900.00, '2011-12-01', '2011-12-01', '', '', '');
  106. INSERT INTO `suites` VALUES(48, '', 'qyqy5tw2', 'EL VALLE MANOR', '304', 'brandyn', 'ewanek', '', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  107. INSERT INTO `suites` VALUES(49, '', 'tv7ar4ax', 'EL VALLE MANOR', '305', 'sirghi', 'iurie', '', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  108. INSERT INTO `suites` VALUES(50, '', '4pub50t5', 'EL VALLE MANOR', '306', 'karen', 'hay', '', '', '', 1200.00, '2011-12-01', '2011-12-01', '', '', '');
  109. INSERT INTO `suites` VALUES(51, '', 'ogutvq4r', 'EL VALLE MANOR', '307', 'sharon', 'bonney', '', '', '', 1000.00, '2011-12-01', '2011-12-01', '', '', '');
  110. INSERT INTO `suites` VALUES(52, '', 'sbm2cm0s', 'EL VALLE MANOR', '401', 'ben', 'griffiths', '', '', '', 1000.00, '2013-03-01', '2013-08-31', '', '', '');
  111. INSERT INTO `suites` VALUES(53, '', 'zoqv3pxt', 'EL VALLE MANOR', '402', 'john', 'han', '', '', '', 1200.00, '2011-12-01', '2011-12-01', '', '', '');
  112. INSERT INTO `suites` VALUES(54, '', '5xty6y7f', 'EL VALLE MANOR', '403', 'james', 'ryckman', '', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  113. INSERT INTO `suites` VALUES(55, '', 'ar32qjkh', 'EL VALLE MANOR', '404', 'john', 'annobil', '', '', '', 850.00, '2011-12-01', '2011-12-01', '', '', '');
  114. INSERT INTO `suites` VALUES(56, '', 'hruqw7ta', 'EL VALLE MANOR', '405', 'mahmoud', 'allahdadi', '', '', '', 900.00, '2011-12-01', '2011-12-01', '', '', '');
  115. INSERT INTO `suites` VALUES(57, '', 'tg3yav3b', 'EL VALLE MANOR', '406', 'laurelle', 'johnson', '', '', '', 1100.00, '2011-12-01', '2011-12-01', '', '', '');
  116. INSERT INTO `suites` VALUES(58, '', 'bicciq4y', 'EL VALLE MANOR', '407', 'jarod', 'ewing', '', '', '', 1050.00, '2012-10-01', '2013-03-31', '', '', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!