-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 27, 2014 at 03:25 AM
-- Server version: 5.5.24-log
-- PHP Version: 5.4.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `mm_idata`
--

-- --------------------------------------------------------

--
-- Table structure for table `state_colour`
--

DROP TABLE IF EXISTS `state_colour`;
CREATE TABLE IF NOT EXISTS `state_colour` (
  `state_id` int(11) NOT NULL AUTO_INCREMENT,
  `state` varchar(5) NOT NULL,
  `class_code` varchar(10) NOT NULL,
  `open_bg` varchar(20) NOT NULL DEFAULT '#010101',
  `open_txt` varchar(20) NOT NULL DEFAULT '#DBDBDB',
  `tenative_bg` varchar(20) NOT NULL DEFAULT '#FFFFFF',
  `tenative_txt` varchar(20) NOT NULL DEFAULT '#FF0000',
  `booked_bg` varchar(20) NOT NULL DEFAULT '#010101',
  `booked_txt` varchar(20) NOT NULL DEFAULT '#DBDBDB',
  `tmp` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`state_id`),
  UNIQUE KEY `state_2` (`state`),
  KEY `state` (`state`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `state_colour`
--

INSERT INTO `state_colour` (`state_id`, `state`, `class_code`, `open_bg`, `open_txt`, `tenative_bg`, `tenative_txt`, `booked_bg`, `booked_txt`, `tmp`) VALUES
(1, 'QLD', 'sQLD', '#DE0D0D', '#303030', '#FFFFFF', '#FF1C14', '#FFDDCC', '#303030', 0),
(2, 'NT', 'sNT', '#A64D42', '#303030', '#FFFFFF', '#FF1C14', '#D9BCAD', '#303030', 0),
(3, 'NSW', 'sNSW', '#4488CC', '#303030', '#FFFFFF', '#FF1C14', '#77CCFF', '#303030', 0),
(4, 'ACT', 'sACT', '#4488CC', '#303030', '#FFFFFF', '#FF1C14', '#77CCFF', '#303030', 0),
(5, 'VIC', 'sVIC', '#F7FF0A', '#303030', '#FFFFFF', '#FF1C14', '#F1FC88', '#303030', 0),
(6, 'TAS', 'sTAS', '#009933', '#303030', '#FFFFFF', '#FF1C14', '#CCFF88', '#303030', 0),
(7, 'SA', 'sSA', '#FF9922', '#303030', '#FFFFFF', '#FF1C14', '#FFDD99', '#303030', 0),
(8, 'PH', 'sHoliday', '#010101', '#DBDBDB', '#FF1C14', '#DBDBDB', '#010101', '#DBDBDB', 0),
(9, 'NW', 'sNW', '#DE16C4', '#000000', '#FFFFFF', '#FF0000', '#78567D', '#EDEDED', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
