-- http://www.phpmyadmin.net
--




--
-- Database: `metro_client_accounts`
--

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

--
-- Table structure for table `account`
--

CREATE TABLE IF NOT EXISTS `account` (
  `id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) NOT NULL,
  `db` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `suburb` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `post_code` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `status` int(11) unsigned NOT NULL DEFAULT '1',
  `email` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `template` varchar(255) NOT NULL,
  `abn` varchar(255) NOT NULL DEFAULT '',
  `fax` varchar(255) NOT NULL DEFAULT '',
  `website` varchar(255) NOT NULL DEFAULT '',
  `template_login` varchar(255) NOT NULL,
  `domain` varchar(255) NOT NULL,
  `default_country` int(11) unsigned NOT NULL,
  `package_id` tinyint(4) unsigned NOT NULL,
  `creator` bigint(11) unsigned NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mobile` varchar(255) NOT NULL,
  `time_zone` int(11) unsigned NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `db` (`db`),
  UNIQUE KEY `domain` (`domain`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `account`
--

INSERT INTO `account` (`id`, `company_name`, `db`, `address`, `suburb`, `state`, `post_code`, `phone`, `status`, `email`, `first_name`, `last_name`, `title`, `template`, `abn`, `fax`, `website`, `template_login`, `domain`, `default_country`, `package_id`, `creator`, `date_created`, `mobile`, `time_zone`, `submitter`, `date_submitted`) VALUES
(1, 'Metro Signs', 'metro_client', '7 Wurundjeri Drive', ' Epping', 'Victoria', '3076', '+61 3 9422 1200', 1, 'bory.kim@bkstudios.com.au', 'Bory', 'Kim', 'Mr', 'default', '15512013307', '+61 3 9422 1209 ', 'http://www.metrosigns.com.au/', 'default', 'ihub', 27, 3, 0, '2016-01-19 10:48:08', '0401235517', 69, 121, '2016-01-19 10:48:08');

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

--
-- Table structure for table `account_settings`
--

CREATE TABLE IF NOT EXISTS `account_settings` (
  `account_id` bigint(11) NOT NULL,
  `date_format` int(11) NOT NULL,
  `normal_jobs_numbers` bigint(20) NOT NULL,
  `project_numbers` bigint(20) NOT NULL,
  `led_numbers` bigint(20) NOT NULL,
  `default_state` varchar(255) NOT NULL DEFAULT 'Victoria',
  `creator` int(11) NOT NULL,
  `date_created` datetime NOT NULL,
  `submitter` bigint(11) unsigned NOT NULL,
  `date_submitted` datetime NOT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `account_settings`
--

INSERT INTO `account_settings` (`account_id`, `date_format`, `normal_jobs_numbers`, `project_numbers`, `led_numbers`, `default_state`, `creator`, `date_created`, `submitter`, `date_submitted`) VALUES
(1, 6, 30000, 10000, 90000, 'Victoria', 0, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00');
