API tools faq
paste
jhylands

monopoly

jhylands
Jun 14th, 2014
601
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 7.20 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 2.11.4
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jun 14, 2014 at 07:59 AM
  7. -- Server version: 5.1.57
  8. -- PHP Version: 5.2.17
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `a9206732_monopol`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Table structure for table `Properties`
  20. --
  21.  
  22. CREATE TABLE `Properties` (
  23.   `ID` INT(11) NOT NULL,
  24.   `Name` VARCHAR(22) COLLATE latin1_general_ci NOT NULL,
  25.   `RentO` INT(11) NOT NULL,
  26.   `Rent1` INT(11) NOT NULL,
  27.   `Rent2` INT(11) NOT NULL,
  28.   `Rent3` INT(11) NOT NULL,
  29.   `Rent4` INT(11) NOT NULL,
  30.   `RentH` INT(11) NOT NULL,
  31.   `Build` INT(11) NOT NULL,
  32.   `Mortgage` INT(11) NOT NULL,
  33.   `Price` INT(11) NOT NULL,
  34.   `Band` VARCHAR(7) COLLATE latin1_general_ci NOT NULL,
  35.   `image` text COLLATE latin1_general_ci NOT NULL,
  36.   PRIMARY KEY (`ID`)
  37. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
  38.  
  39. --
  40. -- Dumping data for table `Properties`
  41. --
  42.  
  43. INSERT INTO `Properties` VALUES(0, 'Go', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  44. INSERT INTO `Properties` VALUES(1, 'Old Kent Road', 2, 10, 30, 90, 160, 250, 50, 30, 80, 'Brown', 'http://2.bp.blogspot.com/-cWjS-8e3Iwg/UU3tKad-r5I/AAAAAAAAAfI/sdl1SsSrREs/s1600/old+kent+road.JPG');
  45. INSERT INTO `Properties` VALUES(2, 'Chest', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  46. INSERT INTO `Properties` VALUES(3, 'Whitechapel Road', 4, 20, 60, 180, 320, 450, 50, 30, 80, 'Brown', 'http://1.bp.blogspot.com/-HIV9DvCpH_M/UU3tGtD5DHI/AAAAAAAAAeM/euHb48NhvP4/s1600/WHS.jpg');
  47. INSERT INTO `Properties` VALUES(4, 'Income tax', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  48. INSERT INTO `Properties` VALUES(5, 'Kings Cross Station', 25, 50, 100, 200, 200, 200, 0, 100, 200, 'Train', 'http://3.bp.blogspot.com/-WOpIb442yz8/UU3tDa5NAzI/AAAAAAAAAdk/UsaPdPiSVkQ/s320/6-kings-cross-station.jpg');
  49. INSERT INTO `Properties` VALUES(6, 'The Angel Islington', 6, 30, 90, 270, 400, 550, 50, 50, 120, 'Aqua', 'http://3.bp.blogspot.com/-ExGDmWHy-gs/UU3tMZLAmxI/AAAAAAAAAgA/7oo-o8EIx04/s320/the+angle+islington.JPG');
  50. INSERT INTO `Properties` VALUES(7, 'Chance', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  51. INSERT INTO `Properties` VALUES(8, 'Euston road', 6, 30, 90, 270, 400, 550, 50, 50, 90, 'Aqua', 'http://1.bp.blogspot.com/-t1pcvZBK624/UU3tINDcaWI/AAAAAAAAAeg/3a712NhePbs/s320/euston+road.JPG');
  52. INSERT INTO `Properties` VALUES(9, 'Pentonville Road', 8, 40, 100, 300, 450, 600, 50, 60, 120, 'Aqua', 'http://4.bp.blogspot.com/-NBDAQoIjfFs/UU3tLnck0dI/AAAAAAAAAf0/F2sn4We_big/s320/pentavil+road.JPG');
  53. INSERT INTO `Properties` VALUES(10, 'Jail', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  54. INSERT INTO `Properties` VALUES(11, 'Pall Mall', 10, 50, 150, 450, 625, 750, 100, 70, 100, 'Pink', 'http://1.bp.blogspot.com/-Yr89tEA-Lnw/UU3tKtZaMqI/AAAAAAAAAfU/O8ZlcPScqio/s320/pall+mall.JPG');
  55. INSERT INTO `Properties` VALUES(12, 'The Electricity compan', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Utility', 'http://4.bp.blogspot.com/-3UDHGbf7cxs/UU3tMmfeDMI/AAAAAAAAAgE/P-fq8OJiY0k/s320/the+electricity+company.jpg');
  56. INSERT INTO `Properties` VALUES(13, 'Whitehall', 10, 50, 150, 450, 625, 750, 100, 70, 100, 'Pink', 'http://1.bp.blogspot.com/-f4u5BQNf41M/UU3tNMbYI9I/AAAAAAAAAgU/XoK3Q6WLb40/s320/whitehall.jpg');
  57. INSERT INTO `Properties` VALUES(14, 'Northumberland Avenue', 12, 60, 180, 500, 700, 900, 100, 80, 100, 'Pink', 'http://1.bp.blogspot.com/-y8N53kOWvrY/UU3tDoHYkBI/AAAAAAAAAdo/8o6BE2u_WP8/s320/Northumberland_Avenue.jpg');
  58. INSERT INTO `Properties` VALUES(15, 'Marylebone Station', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Train', 'http://2.bp.blogspot.com/-j9OiydkugmM/UU3tJIvFJPI/AAAAAAAAAe0/Rwkt0LQQCQY/s320/marlybone+station.jpg');
  59. INSERT INTO `Properties` VALUES(16, 'Bow Street', 14, 70, 200, 550, 750, 950, 100, 90, 110, 'Orange', '');
  60. INSERT INTO `Properties` VALUES(17, 'Chest', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  61. INSERT INTO `Properties` VALUES(18, 'Marlborough Street', 14, 70, 200, 550, 750, 950, 100, 90, 100, 'Orange', '');
  62. INSERT INTO `Properties` VALUES(19, 'Vine Street', 16, 80, 220, 600, 800, 1000, 100, 100, 100, 'Orange', '');
  63. INSERT INTO `Properties` VALUES(20, 'Free Parking', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  64. INSERT INTO `Properties` VALUES(21, 'Strand', 18, 90, 250, 700, 875, 1050, 150, 110, 210, 'Red', 'http://4.bp.blogspot.com/-ZLhBxThkyBQ/UU3tL935shI/AAAAAAAAAfw/tXIojRx5rIc/s320/strand.JPG');
  65. INSERT INTO `Properties` VALUES(22, 'Chance', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  66. INSERT INTO `Properties` VALUES(23, 'Fleet Street', 18, 90, 250, 700, 875, 1050, 150, 110, 110, 'Red', 'http://1.bp.blogspot.com/-RFoY8ADoQwY/UU3tIxjFiII/AAAAAAAAAe8/Pf8QJf7bYT8/s320/fleet+street.JPG');
  67. INSERT INTO `Properties` VALUES(24, 'Trafalgar Square', 20, 100, 300, 750, 925, 1100, 150, 120, 120, 'Red', 'http://2.bp.blogspot.com/-ckw0ASx6wGQ/UU3tM9OE7PI/AAAAAAAAAgM/Idr3EQT-T64/s320/trafalgar_square.jpg');
  68. INSERT INTO `Properties` VALUES(25, 'Fenchurch Street Stati', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Train', 'http://2.bp.blogspot.com/-dtKmiS3F_6E/UU3tIXDhhwI/AAAAAAAAAeo/bmmmg8wPKZo/s320/fenchurch_street_station.jpg');
  69. INSERT INTO `Properties` VALUES(26, 'Leicester Square', 22, 110, 330, 800, 975, 1150, 150, 130, 220, 'Yellow', 'http://1.bp.blogspot.com/-jr6OwJ8TNR4/UU3tDwMBbUI/AAAAAAAAAdw/zGnK33DSs0s/s320/LeicesterSquareCard.jpg');
  70. INSERT INTO `Properties` VALUES(27, 'Coventry Street', 22, 110, 330, 800, 975, 1150, 150, 130, 260, 'Yellow', '');
  71. INSERT INTO `Properties` VALUES(28, 'Water works', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Utility', 'http://3.bp.blogspot.com/-ot_RLN4UA9E/UU3tGmql77I/AAAAAAAAAeE/v6btlnoVsJA/s320/Water+Works+-+LFA+Talk.jpg');
  72. INSERT INTO `Properties` VALUES(29, 'Piccadilly', 24, 120, 360, 850, 1025, 1200, 150, 140, 220, 'Yellow', 'http://1.bp.blogspot.com/-2CO_x4JJLUY/UU3tLjTeW3I/AAAAAAAAAfs/iHny2Xnl5WA/s320/picadilly-circus-.jpg');
  73. INSERT INTO `Properties` VALUES(30, 'GOTO Jail', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  74. INSERT INTO `Properties` VALUES(31, 'Regent Street', 26, 130, 390, 900, 1100, 1275, 200, 150, 360, 'Green', 'http://1.bp.blogspot.com/-1VRPN00fD6M/UU3tEQaTdmI/AAAAAAAAAd8/AtAUcr27D6Y/s320/Regent_Street_London.jpg');
  75. INSERT INTO `Properties` VALUES(32, 'Oxford Street', 26, 130, 390, 900, 1100, 1275, 200, 150, 300, 'Green', 'http://1.bp.blogspot.com/-xYy1hfriHiE/UU3tH6F1pVI/AAAAAAAAAec/IbGngZ_ovIw/s320/Oxford_Street_December_2006.jpeg');
  76. INSERT INTO `Properties` VALUES(33, 'Chest', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  77. INSERT INTO `Properties` VALUES(34, 'Bond Street', 28, 150, 450, 1000, 1200, 1400, 200, 160, 300, 'Green', 'http://4.bp.blogspot.com/-oU5ZUp7-wBs/UU3tHgL6kcI/AAAAAAAAAeU/bZpm4_wkuwA/s320/bond+street.JPG');
  78. INSERT INTO `Properties` VALUES(35, 'Liverpool street stati', 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Train', 'http://3.bp.blogspot.com/-rPCjAmcDFLY/UU3tK4tPyoI/AAAAAAAAAfY/OSAncl4cJnM/s320/liverpool+street+station.jpg');
  79. INSERT INTO `Properties` VALUES(36, 'Chance', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  80. INSERT INTO `Properties` VALUES(37, 'Park Lane', 35, 175, 500, 1100, 1300, 1500, 200, 175, 360, 'Blue', 'http://2.bp.blogspot.com/-jBgvOkSOfVQ/UU3tLOD-AzI/AAAAAAAAAfg/rsfuM3XUsQg/s320/park+lane.JPG');
  81. INSERT INTO `Properties` VALUES(38, 'Super tax', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '');
  82. INSERT INTO `Properties` VALUES(39, 'Mayfair', 50, 200, 600, 1400, 1700, 2000, 200, 200, 400, 'Blue', 'http://1.bp.blogspot.com/-p6G8ebj9CZQ/UU3tJu2V0pI/AAAAAAAAAfA/yrVaZwm1AwE/s320/mayfair-london-gblnrg1.jpg');
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!