254DQBhb

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 21, 2016 at 02:24 PM
7-- Server version: 5.5.52-0ubuntu0.14.04.1
8-- PHP Version: 5.5.9-1ubuntu4.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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: `auburntree`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `nested_categories`
27--
28
29CREATE TABLE IF NOT EXISTS `nested_categories` (
30  `category_id` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(20) NOT NULL,
32  `lft` int(11) NOT NULL,
33  `rgt` int(11) NOT NULL,
34  `created_at` datetime NOT NULL,
35  `updated_at` datetime NOT NULL,
36  PRIMARY KEY (`category_id`)
37) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
38
39--
40-- Dumping data for table `nested_categories`
41--
42
43INSERT INTO `nested_categories` (`category_id`, `name`, `lft`, `rgt`, `created_at`, `updated_at`) VALUES
44(1, 'PRODUCTS', 1, 26, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
45(2, 'MATERIALS', 2, 17, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
46(3, 'roofing', 3, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
47(4, 'underlayments', 5, 6, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
48(5, 'ventilation', 7, 8, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
49(6, 'nails', 9, 10, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
50(7, 'plywood', 11, 12, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
51(8, 'plumbing', 13, 14, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
52(9, 'tools', 15, 16, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
53(10, 'SERVICES', 18, 25, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
54(11, 'tear and install', 19, 24, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
55(12, 'clean up', 20, 23, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
56(21, 'waste disposal', 21, 22, '0000-00-00 00:00:00', '0000-00-00 00:00:00');
57
58/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
59/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
60/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;