-- MySQL dump 10.17 Distrib 10.3.25-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: harbinge_ocv1 -- ------------------------------------------------------ -- Server version 10.3.25-MariaDB /*!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 utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `harbinge_404_page_tbl` -- DROP TABLE IF EXISTS `harbinge_404_page_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_404_page_tbl` ( `id` tinyint(4) NOT NULL AUTO_INCREMENT, `404_title` varchar(100) NOT NULL, `404_heading` varchar(300) NOT NULL, `404_text` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_404_page_tbl` -- LOCK TABLES `harbinge_404_page_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_404_page_tbl` DISABLE KEYS */; INSERT INTO `harbinge_404_page_tbl` (`id`, `404_title`, `404_heading`, `404_text`) VALUES (1,'Page Not Found!','Page Not Found!','The page you are looking for does not exist.

\nYou are now being redirected to the Home Page.'); /*!40000 ALTER TABLE `harbinge_404_page_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_blog_tbl` -- DROP TABLE IF EXISTS `harbinge_blog_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_blog_tbl` ( `blog_sett_id` bigint(20) NOT NULL AUTO_INCREMENT, `blog_enabled` set('0','1') NOT NULL, PRIMARY KEY (`blog_sett_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_blog_tbl` -- LOCK TABLES `harbinge_blog_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_blog_tbl` DISABLE KEYS */; INSERT INTO `harbinge_blog_tbl` (`blog_sett_id`, `blog_enabled`) VALUES (1,'0'); /*!40000 ALTER TABLE `harbinge_blog_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_business_tbl` -- DROP TABLE IF EXISTS `harbinge_business_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_business_tbl` ( `business_id` bigint(20) NOT NULL AUTO_INCREMENT, `business_name` text NOT NULL, `account_name` text NOT NULL, `sign_up_date` date NOT NULL, `domain_name_hosting` set('yes','no') NOT NULL, `domain_name_registered` set('yes','no','not through us') NOT NULL, `account_paid` set('yes','no') NOT NULL, `day` varchar(2) NOT NULL, `month` varchar(8) NOT NULL, `year` varchar(4) NOT NULL, `notes_text` text NOT NULL, `logo_url` varchar(250) NOT NULL, `banner_url` varchar(200) NOT NULL, `business_type` varchar(100) NOT NULL, `ABN` varchar(30) NOT NULL, `domain_url` varchar(150) NOT NULL, `contact_person` varchar(100) NOT NULL, `contact_email` varchar(200) NOT NULL, `phone_number` text NOT NULL, `contact_mobile` text NOT NULL, `contact_fax` text NOT NULL, `postal_address` text NOT NULL, `street` text NOT NULL, `city` varchar(50) NOT NULL, `state` varchar(20) NOT NULL, `post_code` varchar(6) NOT NULL, `country` text NOT NULL, `email_address` varchar(100) NOT NULL, `template_id` bigint(20) NOT NULL, `client_indent` bigint(20) NOT NULL, `shop` int(1) NOT NULL, `bgbody_url` varchar(150) NOT NULL, `navbar_url` varchar(150) NOT NULL, `ems_id` varchar(32) NOT NULL, `ems_list1` varchar(32) NOT NULL, `ems_list2` varchar(32) NOT NULL, PRIMARY KEY (`business_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_business_tbl` -- LOCK TABLES `harbinge_business_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_business_tbl` DISABLE KEYS */; INSERT INTO `harbinge_business_tbl` (`business_id`, `business_name`, `account_name`, `sign_up_date`, `domain_name_hosting`, `domain_name_registered`, `account_paid`, `day`, `month`, `year`, `notes_text`, `logo_url`, `banner_url`, `business_type`, `ABN`, `domain_url`, `contact_person`, `contact_email`, `phone_number`, `contact_mobile`, `contact_fax`, `postal_address`, `street`, `city`, `state`, `post_code`, `country`, `email_address`, `template_id`, `client_indent`, `shop`, `bgbody_url`, `navbar_url`, `ems_id`, `ems_list1`, `ems_list2`) VALUES (1,'harbingertechnology','harbinge','0000-00-00','','','','','','','','','banner.png','','','harbingertec.com.au','','enquiries@harbingertec.com.au','1300 364 727','','','','','Bella Vista','NSW','2153','Australia','',12,0,0,'','','','',''); /*!40000 ALTER TABLE `harbinge_business_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_cat_tbl` -- DROP TABLE IF EXISTS `harbinge_cat_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_cat_tbl` ( `id_cat` bigint(20) NOT NULL AUTO_INCREMENT, `business_id` bigint(20) NOT NULL, `category_id` bigint(20) NOT NULL, `category_name` text NOT NULL, `cat_order` int(8) NOT NULL, `cat_text` text NOT NULL, `cat_title` varchar(255) NOT NULL, `cat_meta_desc` varchar(255) NOT NULL, `cat_meta_key` varchar(255) NOT NULL, `cat_url` varchar(255) NOT NULL, PRIMARY KEY (`id_cat`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_cat_tbl` -- LOCK TABLES `harbinge_cat_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_cat_tbl` DISABLE KEYS */; /*!40000 ALTER TABLE `harbinge_cat_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_client_tbl` -- DROP TABLE IF EXISTS `harbinge_client_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_client_tbl` ( `client_id` bigint(20) NOT NULL AUTO_INCREMENT, `account_name` text NOT NULL, `email_address` varchar(130) NOT NULL, `client_fname` varchar(50) NOT NULL, `client_lname` varchar(50) NOT NULL, `mobile` text NOT NULL, `phone` text NOT NULL, `fax` text NOT NULL, `client_abn` text NOT NULL, `company_name` text NOT NULL, `client_notes` text NOT NULL, PRIMARY KEY (`client_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_client_tbl` -- LOCK TABLES `harbinge_client_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_client_tbl` DISABLE KEYS */; /*!40000 ALTER TABLE `harbinge_client_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_css` -- DROP TABLE IF EXISTS `harbinge_css`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_css` ( `css_id` bigint(20) NOT NULL AUTO_INCREMENT, `bk_colour` varchar(11) NOT NULL, `hover_colour` varchar(11) NOT NULL, `footer_colour` varchar(11) NOT NULL, `navbar_colour` varchar(11) NOT NULL, `any_tab_hover` varchar(11) NOT NULL, `head_nav_bk` varchar(11) NOT NULL, `td_head_bk` varchar(11) NOT NULL, PRIMARY KEY (`css_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_css` -- LOCK TABLES `harbinge_css` WRITE; /*!40000 ALTER TABLE `harbinge_css` DISABLE KEYS */; INSERT INTO `harbinge_css` (`css_id`, `bk_colour`, `hover_colour`, `footer_colour`, `navbar_colour`, `any_tab_hover`, `head_nav_bk`, `td_head_bk`) VALUES (1,'264981','264981','000000','040404','264981','5f5f5f','264981'); /*!40000 ALTER TABLE `harbinge_css` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_footer_tbl` -- DROP TABLE IF EXISTS `harbinge_footer_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_footer_tbl` ( `footer_id` bigint(20) NOT NULL AUTO_INCREMENT, `footer_text_name` varchar(100) NOT NULL, `footer_text` text NOT NULL, PRIMARY KEY (`footer_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_footer_tbl` -- LOCK TABLES `harbinge_footer_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_footer_tbl` DISABLE KEYS */; INSERT INTO `harbinge_footer_tbl` (`footer_id`, `footer_text_name`, `footer_text`) VALUES (1,'stats',''); /*!40000 ALTER TABLE `harbinge_footer_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_front_page_tbl` -- DROP TABLE IF EXISTS `harbinge_front_page_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_front_page_tbl` ( `front_page_id` bigint(20) NOT NULL AUTO_INCREMENT, `business_id` bigint(20) NOT NULL, `intro_text` text NOT NULL, `right_menu_text` text NOT NULL, `title` text NOT NULL, `intro_title` text NOT NULL, PRIMARY KEY (`front_page_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_front_page_tbl` -- LOCK TABLES `harbinge_front_page_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_front_page_tbl` DISABLE KEYS */; INSERT INTO `harbinge_front_page_tbl` (`front_page_id`, `business_id`, `intro_text`, `right_menu_text`, `title`, `intro_title`) VALUES (1,1,'

Business solutions, ecommerce solutions, merchant payments solution, you’re an entrepreneur??…have ideas??

We can help….!!

','','Harbinger Technology','Welcome to Harbinger Technology'); /*!40000 ALTER TABLE `harbinge_front_page_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_front_photos` -- DROP TABLE IF EXISTS `harbinge_front_photos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_front_photos` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `business_id` bigint(20) NOT NULL, `sort` bigint(20) NOT NULL, `image` varchar(64) NOT NULL, `image_big` varchar(64) NOT NULL, `caption` text NOT NULL, `link` varchar(150) NOT NULL, `link_target` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_front_photos` -- LOCK TABLES `harbinge_front_photos` WRITE; /*!40000 ALTER TABLE `harbinge_front_photos` DISABLE KEYS */; INSERT INTO `harbinge_front_photos` (`id`, `business_id`, `sort`, `image`, `image_big`, `caption`, `link`, `link_target`) VALUES (4,1,99,'slider1.png','slider1.png','','',0),(5,1,99,'slider2.png','slider2.png','','',0),(6,1,99,'slider3.png','slider3.png','','',0); /*!40000 ALTER TABLE `harbinge_front_photos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_htaccess` -- DROP TABLE IF EXISTS `harbinge_htaccess`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_htaccess` ( `htaccess_id` bigint(8) NOT NULL AUTO_INCREMENT, `htaccess_text` text NOT NULL, PRIMARY KEY (`htaccess_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_htaccess` -- LOCK TABLES `harbinge_htaccess` WRITE; /*!40000 ALTER TABLE `harbinge_htaccess` DISABLE KEYS */; INSERT INTO `harbinge_htaccess` (`htaccess_id`, `htaccess_text`) VALUES (1,''); /*!40000 ALTER TABLE `harbinge_htaccess` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_incro_tbl` -- DROP TABLE IF EXISTS `harbinge_incro_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_incro_tbl` ( `incro_id` bigint(20) NOT NULL AUTO_INCREMENT, `business_id` bigint(20) NOT NULL, PRIMARY KEY (`incro_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_incro_tbl` -- LOCK TABLES `harbinge_incro_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_incro_tbl` DISABLE KEYS */; INSERT INTO `harbinge_incro_tbl` (`incro_id`, `business_id`) VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0); /*!40000 ALTER TABLE `harbinge_incro_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_menu_tbl` -- DROP TABLE IF EXISTS `harbinge_menu_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_menu_tbl` ( `menu_id` bigint(20) NOT NULL AUTO_INCREMENT, `parent_id` int(5) NOT NULL, `business_id` bigint(20) NOT NULL, `menu_order` bigint(20) NOT NULL, `menu_text` text NOT NULL, `external_url` text NOT NULL, `external_target` text NOT NULL, `identifer_id` varchar(100) NOT NULL, `overview` int(1) NOT NULL, `overview_heading` varchar(100) NOT NULL, `overview_text` text NOT NULL, `overview_title` varchar(100) NOT NULL, `overview_url` varchar(100) NOT NULL, `meta_desc` varchar(255) NOT NULL, `meta_key` varchar(255) NOT NULL, PRIMARY KEY (`menu_id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_menu_tbl` -- LOCK TABLES `harbinge_menu_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_menu_tbl` DISABLE KEYS */; INSERT INTO `harbinge_menu_tbl` (`menu_id`, `parent_id`, `business_id`, `menu_order`, `menu_text`, `external_url`, `external_target`, `identifer_id`, `overview`, `overview_heading`, `overview_text`, `overview_title`, `overview_url`, `meta_desc`, `meta_key`) VALUES (1,0,1,1,'Home','','','',0,'','','','','',''),(2,0,1,5,'Contact','','','',0,'','','','','',''),(4,0,1,2,'About Us','','','',0,'','','','','',''),(5,0,1,3,'Our Services','','','',0,'','','','','',''),(6,0,1,4,'Resources','','','',0,'','','','','',''); /*!40000 ALTER TABLE `harbinge_menu_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_meta_data_tbl` -- DROP TABLE IF EXISTS `harbinge_meta_data_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_meta_data_tbl` ( `business_id` bigint(20) NOT NULL, `keywords` text NOT NULL, `description` text NOT NULL, PRIMARY KEY (`business_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_meta_data_tbl` -- LOCK TABLES `harbinge_meta_data_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_meta_data_tbl` DISABLE KEYS */; INSERT INTO `harbinge_meta_data_tbl` (`business_id`, `keywords`, `description`) VALUES (1,'Harbinger Technology, Harbinger, Business solutions, ecommerce solutions, merchant payments, mobile development','WELCOME TO HARBINGER TECHNOLOGY.\r\nBusiness solutions, ecommerce solutions, merchant payments solutions, if you’re an entrepreneur and have ideas, we can help!\r\nOur team has years of experience in web and mobile application development. We have the capability, capacity to manage and deliver small, medium & large scale projects.'); /*!40000 ALTER TABLE `harbinge_meta_data_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_pages_tbl` -- DROP TABLE IF EXISTS `harbinge_pages_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_pages_tbl` ( `page_id` bigint(20) NOT NULL AUTO_INCREMENT, `business_id` bigint(20) NOT NULL, `menu_id` bigint(20) NOT NULL, `page_title` varchar(300) NOT NULL, `page_url` varchar(300) NOT NULL, `page_text` longtext NOT NULL, `photo_id` bigint(20) NOT NULL, `site_map_ref` varchar(1000) NOT NULL, `b_date` date NOT NULL, `blog_page` set('0','1') NOT NULL, `meta_keywords` text NOT NULL, `meta_description` text NOT NULL, `page_heading` varchar(100) NOT NULL, `external_link` varchar(200) NOT NULL, `external_target` varchar(50) DEFAULT '_blank', `sort_order` int(11) NOT NULL, `feature_img` varchar(255) NOT NULL, `author` varchar(255) NOT NULL, `profile_url` varchar(255) NOT NULL, PRIMARY KEY (`page_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_pages_tbl` -- LOCK TABLES `harbinge_pages_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_pages_tbl` DISABLE KEYS */; INSERT INTO `harbinge_pages_tbl` (`page_id`, `business_id`, `menu_id`, `page_title`, `page_url`, `page_text`, `photo_id`, `site_map_ref`, `b_date`, `blog_page`, `meta_keywords`, `meta_description`, `page_heading`, `external_link`, `external_target`, `sort_order`, `feature_img`, `author`, `profile_url`) VALUES (1,1,1,'Home','','',2,'1','0000-00-00','','','','','','_blank',0,'','',''),(2,1,2,'Contact','contact-us','

  enquiries@harbingertec.com.au

\r\n

  1300 364 727

\r\n


View Larger Map

\r\n


',3,'2','0000-00-00','0','','','','','_blank',0,'','',''),(5,0,4,'About us','about-us','

Harbinger technologies are one of the world’s fastest growing mobile application development firms. At Harbinger we strive to be the best and do not set limits to what we can achieve. Our customers are treated with highest regard and you are guaranteed a quality IT service second to none.  

\r\n

Our team has years of experience in web and mobile application development. We have the capability, capacity to manage and deliver small, medium & large scale projects. We are an extremely dedicated group of professionals who will listen, understand and deliver to your expectations.

\r\n

Please feel free to call us for an obligation free quote. Alternatively complete your details and nominate a preferred time. One of our friendly staff will call you. 

',0,'3','2013-06-27','0','','','','','_blank',0,'','',''),(6,0,5,'Our Services','our-services','

Harbinger provides custom mobile app development for iPhone, iPad, Android, Blackberry & Windows Phone. We boast a very strong technical capability to deliver customer requirements across any platform resulting in quantifiable benefits to our clients.

\r\n

We specialise in;

\r\n\r\n

Harbinger uses iterative and agile development methodologies such as SCRUM for application development. We usually breakdown projects in smaller iterations to meet delivery timeframes and approach allows client to view quantifiable progress path. Clients are kept transparent and open to different phases of the project and issues/risks called out during regular update sessions.

',0,'4','2013-06-27','0','','','','','_blank',0,'','',''),(7,0,6,'Resources','resources','

Do you have an in house development or testing arrangement? We can assist in providing specialised resources to fulfil your project requirements.

\r\n

At Harbinger we specialise in mobile application development. We hire some of the best in the industry and we can work with you to leverage their skills to fulfil your project needs. We specialise in finance and banking sector (merchant payment solutions, NFC technology, mobile payments & ecommerce solutions). We are more than willing to have an obligation free discussion on your project needs.

',0,'5','2013-06-27','0','','','','','_blank',0,'','',''); /*!40000 ALTER TABLE `harbinge_pages_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_phone_nav` -- DROP TABLE IF EXISTS `harbinge_phone_nav`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_phone_nav` ( `phone_id` tinyint(4) NOT NULL AUTO_INCREMENT, `on_off` set('0','1') NOT NULL, PRIMARY KEY (`phone_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_phone_nav` -- LOCK TABLES `harbinge_phone_nav` WRITE; /*!40000 ALTER TABLE `harbinge_phone_nav` DISABLE KEYS */; INSERT INTO `harbinge_phone_nav` (`phone_id`, `on_off`) VALUES (1,'0'); /*!40000 ALTER TABLE `harbinge_phone_nav` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_settings_tbl` -- DROP TABLE IF EXISTS `harbinge_settings_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_settings_tbl` ( `settings_id` tinyint(4) NOT NULL AUTO_INCREMENT, `photo_display` set('0','1') NOT NULL, `banner_width` int(10) NOT NULL, `banner_height` int(10) NOT NULL, `photo_width` int(10) NOT NULL, `photo_height` int(10) NOT NULL, `sitemap_submit` tinyint(4) NOT NULL DEFAULT 0, `google_verification` varchar(128) NOT NULL, PRIMARY KEY (`settings_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_settings_tbl` -- LOCK TABLES `harbinge_settings_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_settings_tbl` DISABLE KEYS */; INSERT INTO `harbinge_settings_tbl` (`settings_id`, `photo_display`, `banner_width`, `banner_height`, `photo_width`, `photo_height`, `sitemap_submit`, `google_verification`) VALUES (1,'0',930,250,940,375,1,''); /*!40000 ALTER TABLE `harbinge_settings_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_site_map` -- DROP TABLE IF EXISTS `harbinge_site_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_site_map` ( `site_map_id` int(11) NOT NULL AUTO_INCREMENT, `location` text NOT NULL, `last_mod` datetime NOT NULL, `change_freq` text NOT NULL, `priority` varchar(11) NOT NULL, `site_map_ref` varchar(1000) NOT NULL, `page_title` varchar(500) NOT NULL, `order_no` text NOT NULL, PRIMARY KEY (`site_map_id`) ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_site_map` -- LOCK TABLES `harbinge_site_map` WRITE; /*!40000 ALTER TABLE `harbinge_site_map` DISABLE KEYS */; INSERT INTO `harbinge_site_map` (`site_map_id`, `location`, `last_mod`, `change_freq`, `priority`, `site_map_ref`, `page_title`, `order_no`) VALUES (1,'https://www.harbingertec.com.au/','2013-07-22 11:08:06','weekly','1.0','1','Home','1'),(2,'https://www.harbingertec.com.au/contact-us','2013-06-28 09:52:57','monthly','0.8','2','Contact','1'),(5,'https://www.harbingertec.com.au/resources','2013-07-09 14:10:13','monthly','0.8','5','Resources','5'); /*!40000 ALTER TABLE `harbinge_site_map` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_site_photos` -- DROP TABLE IF EXISTS `harbinge_site_photos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_site_photos` ( `id` int(8) unsigned NOT NULL AUTO_INCREMENT, `business_id` bigint(8) NOT NULL, `sort` int(8) NOT NULL, `image` varchar(64) NOT NULL, `image_big` varchar(64) NOT NULL, `description` text NOT NULL, `category_id` bigint(20) NOT NULL, `title` varchar(300) NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_site_photos` -- LOCK TABLES `harbinge_site_photos` WRITE; /*!40000 ALTER TABLE `harbinge_site_photos` DISABLE KEYS */; /*!40000 ALTER TABLE `harbinge_site_photos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `harbinge_splash_page_tbl` -- DROP TABLE IF EXISTS `harbinge_splash_page_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `harbinge_splash_page_tbl` ( `splash_id` tinyint(4) NOT NULL AUTO_INCREMENT, `on_off` set('0','1') NOT NULL, `splash_theme` varchar(50) NOT NULL, `splash_title` varchar(300) NOT NULL, `bg_color` varchar(50) NOT NULL, `splash_text` longtext NOT NULL, PRIMARY KEY (`splash_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `harbinge_splash_page_tbl` -- LOCK TABLES `harbinge_splash_page_tbl` WRITE; /*!40000 ALTER TABLE `harbinge_splash_page_tbl` DISABLE KEYS */; INSERT INTO `harbinge_splash_page_tbl` (`splash_id`, `on_off`, `splash_theme`, `splash_title`, `bg_color`, `splash_text`) VALUES (1,'0','mywork_white','Coming soon... - harbingertechnology','ffffff','<img style="display: block; margin-left: auto; margin-right: auto;" border="0" src="https://images.mywork.com.au/splash/mywork-light-top.jpg" height="546" width="800" /><a href="https://www.mywork.com.au" target="_blank"><img style="display: block; margin-left: auto; margin-right: auto;" border="0" src="https://images.mywork.com.au/splash/mywork-light-bottom.jpg" height="48" width="800" /></a>'); /*!40000 ALTER TABLE `harbinge_splash_page_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'harbinge_ocv1' -- -- -- Dumping routines for database 'harbinge_ocv1' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2020-10-12 13:22:20