Created
September 27, 2010 01:43
-
-
Save gavinblair/598481 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- phpMyAdmin SQL Dump | |
| -- version 3.2.5 | |
| -- http://www.phpmyadmin.net | |
| -- | |
| -- Host: localhost | |
| -- Generation Time: Sep 26, 2010 at 09:43 PM | |
| -- Server version: 5.1.44 | |
| -- PHP Version: 5.3.2 | |
| SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | |
| -- | |
| -- Database: `ldntrash` | |
| -- | |
| -- -------------------------------------------------------- | |
| -- | |
| -- Table structure for table `contents` | |
| -- | |
| CREATE TABLE `contents` ( | |
| `id` int(11) NOT NULL AUTO_INCREMENT, | |
| `slug` varchar(100) NOT NULL, | |
| `title` varchar(100) NOT NULL, | |
| `body` text NOT NULL, | |
| `created` date NOT NULL, | |
| `modified` date NOT NULL, | |
| `category` varchar(20) DEFAULT NULL, | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ; | |
| -- | |
| -- Dumping data for table `contents` | |
| -- | |
| INSERT INTO `contents` VALUES(1, 'missed-collections', 'Missed Collections', 'Your garbage may not be collected for a number reasons including:\r\n\r\n <ul>\r\n\r\n <li>The container or bag weighed more than 20 kg (44 lbs).</li>\r\n\r\n <li>The container or bag had yard materials or other non-collectable items inside.</li>\r\n\r\n <li>The container or bag was more than 125 litres (28 Imperial gallons).</li>\r\n\r\n <li>The garbage was set out on a snow bank.</li>\r\n\r\n <li>The garbage was placed inside an unlabeled cardboard box or small plastic bags.</li>\r\n\r\n <li>The garbage was not at the curb by 7 AM for collection.</li>\r\n\r\n <li>The lid was tied onto the reusable container.</li>\r\n\r\n <li>The garbage was not placed on the curb (it was on private property).</li>\r\n\r\n </ul>', '2010-09-26', '2010-09-26', 'pages'); | |
| INSERT INTO `contents` VALUES(7, '', '', '<strong>DO NOT</strong> place needles in the garbage. Place them in a hard plastic container and contact your local pharmacy, the Middlesex London Health Unit (519-663-5317, or <a href="http://www.healthunit.com">www.healthunit.com</a>), or visit <a href="http://www.dowhatyoucan.ca">www.dowhatyoucan.ca</a> for safe disposal information.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(2, 'garbage-safety', 'Garbage Safety', '<div>\r\n\r\n <ul>\r\n\r\n <li><strong>DO NOT</strong> place needles in the garbage. Place them in a hard plastic container and contact your local pharmacy, the Middlesex London Health Unit (519-663-5317, or <a href="http://www.healthunit.com">www.healthunit.com</a>), or visit <a href="http://www.dowhatyoucan.ca">www.dowhatyoucan.ca</a> for safe disposal information. </li> \r\n\r\n <li>Put broken glass and sharp metal objects in a sealed and clearly labeled cardboard box for garbage collectors. This will contain the glass if it breaks at collection.</li>\r\n\r\n <li>Remove bungee cords and straps from container lids. These can snap back and hit collectors, catch on their clothing or the truck.</li>\r\n\r\n <li>Ensure that animal waste and cat litter are free of liquid and double-bagged for garbage collection.</li>\r\n\r\n </ul>\r\n\r\n</div>', '2010-09-26', '2010-09-26', 'pages'); | |
| INSERT INTO `contents` VALUES(3, 'recycling-don-ts', 'Recycling - Don''ts', '<div>\r\n\r\n <em><strong>DON''T:</strong></em>\r\n\r\n <br/><br/>\r\n\r\n The following <strong>DO NOT</strong> belong in your Blue Box:\r\n\r\n <ul>\r\n\r\n <li>Bakery/food trays and clamshell containers. <em>(Why don''t we recycle them? Not all plastic has a recycling market or end user. Clamshell containers, bakery and food trays and plastic pots are light, thin-walled plastic that adversely affects the manufacturing of the end products by creating imperfections, bubbles and weak spots in the products. They have a different chemical makeup and melting point compared with a #1 plastic food or beverage bottle, even though they are all labelled #1 or PET or PETE. Hopefully market conditions will change in the near future.)</em></li>\r\n\r\n <li>Plastic plant pots.</li>\r\n\r\n <li>Styrofoam™ containers (foam containers like coffee cups, egg cartons and protective foam packaging).</li>\r\n\r\n <li>Waxed boxboard (such as frozen food packaging).</li>\r\n\r\n <li>Shredded paper - place in clear or translucent plastic bag for recycling collection, not loose in Blue Box.</li>\r\n\r\n </ul>\r\n\r\n</div>', '2010-09-26', '2010-09-26', 'pages'); | |
| INSERT INTO `contents` VALUES(4, 'garbage-1', 'Garbage', '<div>\r\n\r\n <em><strong>DO:</strong></em>\r\n\r\n <ul>\r\n\r\n <li>Put your garbage at the curb by 7 A.M. the day of garbage pickup, but no earlier than 6 P.M. the night before.</li>\r\n\r\n <li>Use plastic garbage bags, metal or plastic cans (minimum 30L, maximum 125L). Maximum weight for bags or cans is 20kg (44lbs.).</li>\r\n\r\n <li>We <strong>DO</strong> take large items like couches, mattresses, furniture and carpet cut to 1m (39") lengths tied in bundles. Remove mattresses from hideaway beds and tie springs down. Remove the tank from two-piece toilets and empty water.</li>\r\n\r\n <li>Dog feces and cat litter must be bagged, free of liquids and placed inside a larger bag.</li>\r\n\r\n <li>Bagged garbage is accepted at depots for a fee.</li>\r\n\r\n </ul>\r\n\r\n\r\n\r\n <em><strong>DON''T:</strong></em>\r\n\r\n <ul>\r\n\r\n <li>Don''t place small grocery or kitchen bags at the curb. They will not be picked up unless placed in garbage cans or larger bags.</li>\r\n\r\n <li>The following materials will <strong>NOT</strong> be collected at the curb: scrap metal (propane tanks, barbecues, bike frames, car parts, etc.), construction and renovation materials (drywall, wood, etc.), appliances (fridges, stoves, etc.), electronics (TVs, monitors, computers, etc.), tires, and compact fluorescent light bulbs / tubes.</li>\r\n\r\n <li>Don''t place garbage at the curbside outside of the specified hours.</li>\r\n\r\n <li>Don''t place needles in the garbage. Place them in a hard plastic container and contact your local pharmacy or visit <a href=www.healthunit.com>www.healthunit.com</a> or <a href=www.dowhatyoucan.ca>www.dowhatyoucan.ca</a> for safe disposal information.</li>\r\n\r\n <li>Don''t put broken glass and sharp metal objects in regular garbage. Place them in a sealed and clearly labeled cardboard box for garbage collectors. This will contain the glass if it breaks at collection.</li>\r\n\r\n </ul>\r\n\r\n</div>', '2010-09-26', '2010-09-26', 'pages'); | |
| INSERT INTO `contents` VALUES(5, 'yard-materials', 'Yard Materials', '<div>\r\n\r\n <em><strong>DO:</strong></em>\r\n\r\n <ul>\r\n\r\n <li>Place plant trimmings, brush, leaves and pumpkins in kraft paper bags, garbage cans or certified compostable bags. <strong>NO</strong> grass clippings. Certified compostable bags have one of the following images on it:<br/><br/>\r\n\r\n <img src="Certified_Compostable_Cdn_Logo.jpg"> <img src="Certified_Compostable_US_Logo1.jpg"></li>\r\n\r\n <li>Cut brush to a length of less than 1m (39") and tie it in bundles with string or rope. Limbs must be less than 10cm (4") in diameter.</li>\r\n\r\n <li>Place fall leaves and yard materials 1.5m (5'') from regular garbage by 7 A.M. on Monday of the designated week. It may be collected any time during the week, including Saturdays.</li>\r\n\r\n </ul>\r\n\r\n\r\n\r\n <em><strong>DON''T:</strong></em>\r\n\r\n <ul>\r\n\r\n <li>Don''t use regular plastic bags for yard materials.</li>\r\n\r\n <li>We <strong>DO NOT</strong> accept:</li>\r\n\r\n <ul>\r\n\r\n <li>Grass clippings.</li>\r\n\r\n <li>Sod.</li>\r\n\r\n <li>Dirt/soil.</li>\r\n\r\n <li>Rocks.</li>\r\n\r\n <li>Large branches (greater than 10cm / 4" in diameter).</li>\r\n\r\n <li>Tree stumps.</li>\r\n\r\n <li>Railway ties.</li>\r\n\r\n <li>Painted and treated wood.</li>\r\n\r\n <li>Flower pots/trays.</li>\r\n\r\n <li>Kitchen food scraps.</li>\r\n\r\n <li>Animal waste.</li>\r\n\r\n </ul>\r\n\r\n </ul>\r\n\r\n</div>', '2010-09-26', '2010-09-26', 'pages'); | |
| INSERT INTO `contents` VALUES(6, 'garbage-collection-general-info', 'Garbage Collection - General Info', '<div>\r\ns\r\n <ul>\r\n\r\n <li>Containers can be garbage bags or cans (minimum 30 L, maximum 125 L); maximum weight is 20 kg (44 lbs.).</li>\r\n\r\n <li>There is no limit to the number of bulky items set out on collection day. These include furniture, mattresses, carpet (1m / 39" lengths, tied in bundles), etc., but do not include non-collectables such as scrap metal, appliances, construction and renovation materials.</li>\r\n\r\n <li>A maximum of up to 4 containers per collection is allowed. The container limit applies to each registered residential unit. For example, a duplex is allowed 8 bags, a triplex is allowed 12 bags, and a multi-unit townhome complex is allowed 4 containers for each unit.</li>\r\n\r\n <li>Extra garbage? There are three depot locations where extra garbage can be taken (fees apply). Information about depot locations and hours can be found at <a href="http://www.london.ca">www.london.ca</a> or by calling 519-661-4585. In addition, there are two collection days per year when the container limit will not be enforced:</li>\r\n\r\n <ul>\r\n\r\n <li>The first collection following Christmas (December 25th).</li>\r\n\r\n <li>Spring collection in late April/early May.</li>\r\n\r\n </ul>\r\n\r\n </ul>\r\n\r\n</div>', '2010-09-26', '2010-09-26', 'pages'); | |
| INSERT INTO `contents` VALUES(8, '', '', 'Put broken glass and sharp metal objects in a sealed and clearly labeled cardboard box for garbage collectors. This will contain the glass if it breaks at collection.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(9, '', '', 'Remove bungee cords and straps from container lids. These can snap back and hit collectors, catch on their clothing or the truck.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(10, '', '', 'Ensure that animal waste and cat litter are free of liquid and double-bagged for garbage collection.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(11, '', '', 'Your garbage may not be collected if the container or bag weighs more than 20 kg (44 lbs).', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(12, '', '', 'Your garbage may not be collected if the container or bag has yard materials or other non-collectable items inside.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(13, '', '', 'Your garbage may not be collected if the container or bag is more than 125 litres (28 Imperial gallons).', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(14, '', '', 'Your garbage may not be collected if the garbage is set out on a snow bank.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(15, '', '', 'Your garbage may not be collected if the garbage is placed inside an unlabeled cardboard box or small plastic bags.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(16, '', '', 'Your garbage may not be collected if the garbage is not at the curb by 7 AM for collection.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(17, '', '', 'Your garbage may not be collected if the lid is tied onto the reusable container.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(18, '', '', 'Your garbage may not be collected if the garbage is not placed on the curb (on private property).', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(19, '', '', 'Bakery/food trays and clamshell containers <strong>DO NOT</strong> belong in your Blue Box.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(20, '', '', 'Plastic plant pots <strong>DO NOT</strong> belong in your Blue Box.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(21, '', '', 'Styrofoam™ containers (foam containers like coffee cups, egg cartons and protective foam packaging) <strong>DO NOT</strong> belong in your Blue Box.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(22, '', '', 'Waxed boxboard (such as frozen food packaging) <strong>DOES NOT</strong> belong in your Blue Box.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(23, '', '', 'Shredded paper <strong>DOES NOT</strong> belong loose in your Blue Box - place in clear or translucent plastic bag for recycling collection.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(24, '', '', 'Put your garbage at the curb by 7 A.M. the day of garbage pickup, but no earlier than 6 P.M. the night before.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(25, '', '', 'Use plastic garbage bags, metal or plastic cans (minimum 30L, maximum 125L). Maximum weight for bags or cans is 20kg (44lbs.).', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(26, '', '', 'We <strong>DO</strong> take large items like couches, mattresses, furniture and carpet cut to 1m (39") lengths tied in bundles. Remove mattresses from hideaway beds and tie springs down. Remove the tank from two-piece toilets and empty water.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(27, '', '', 'Dog feces and cat litter must be bagged, free of liquids and placed inside a larger bag.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(28, '', '', 'Bagged garbage is accepted at depots for a fee.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(29, '', '', 'Don''t place small grocery or kitchen bags at the curb. They will not be picked up unless placed in garbage cans or larger bags.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(30, '', '', 'The following materials will <strong>NOT</strong> be collected at the curb: scrap metal (propane tanks, barbecues, bike frames, car parts, etc.), construction and renovation materials (drywall, wood, etc.), appliances (fridges, stoves, etc.), electronics (TVs, monitors, computers, etc.), tires, and compact fluorescent light bulbs / tubes.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(31, '', '', 'Don''t place garbage at the curbside outside of the specified hours.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(32, '', '', 'Don''t place needles in the garbage. Place them in a hard plastic container and contact your local pharmacy or visit <a href=www.healthunit.com>www.healthunit.com</a> or <a href=www.dowhatyoucan.ca>www.dowhatyoucan.ca</a> for safe disposal information.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(33, '', '', 'Don''t put broken glass and sharp metal objects in regular garbage. Place them in a sealed and clearly labeled cardboard box for garbage collectors. This will contain the glass if it breaks at collection.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(34, '', '', 'Yard Waste - Place plant trimmings, brush, leaves and pumpkins in kraft paper bags, garbage cans or certified compostable bags. <strong>NO</strong> grass clippings.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(35, '', '', 'Yard Waste - Cut brush to a length of less than 1m (39") and tie it in bundles with string or rope. Limbs must be less than 10cm (4") in diameter.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(36, '', '', 'Yard Waste - Place fall leaves and yard materials 1.5m (5'') from regular garbage by 7 A.M. on Monday of the designated week. It may be collected any time during the week, including Saturdays.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(37, '', '', 'Yard Waste - Don''t use regular plastic bags for yard materials.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(38, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept grass clippings.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(39, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept sod.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(40, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept dirt/soil.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(41, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept rocks.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(42, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept large branches (greater than 10cm / 4" in diameter).', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(43, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept tree stumps.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(44, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept railway ties.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(45, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept painted and treated wood.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(46, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept flower pots/trays.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(47, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept kitchen food scraps.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(48, '', '', 'Yard Waste - We <strong>DO NOT</strong> accept animal waste.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(49, '', '', 'Containers can be garbage bags or cans (minimum 30 L, maximum 125 L); maximum weight is 20 kg (44 lbs.).', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(50, '', '', 'There is no limit to the number of bulky items set out on collection day. These include furniture, mattresses, carpet (1m / 39" lengths, tied in bundles), etc., but do not include non-collectables such as scrap metal, appliances, construction and renovation materials.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(51, '', '', 'A maximum of up to 4 containers per collection is allowed. The container limit applies to each registered residential unit. For example, a duplex is allowed 8 bags, a triplex is allowed 12 bags, and a multi-unit townhome complex is allowed 4 containers for each unit.', '0000-00-00', '0000-00-00', 'tips'); | |
| INSERT INTO `contents` VALUES(52, '', '', 'Extra garbage? There are three depot locations where extra garbage can be taken (fees apply). Information about depot locations and hours can be found at <a href="http://www.london.ca">www.london.ca</a> or by calling 519-661-4585. In addition, there are two collection days per year when the container limit will not be enforced:\r\n<strong>The first collection following Christmas (December 25th)</strong>, and <strong>Spring collection in late April/early May.</strong>', '0000-00-00', '0000-00-00', 'tips'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment