--
-- Host: localhost    Database: kalosolo_wb
-- ------------------------------------------------------


--
-- Table structure for table `air_access`
--

CREATE TABLE `air_access` (
  `air_groupid` mediumint(8) unsigned NOT NULL,
  `air_menuid` mediumint(8) unsigned NOT NULL,
  KEY `air_groupid` (`air_groupid`,`air_menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `air_access`
--

INSERT INTO `air_access` (`air_groupid`, `air_menuid`) VALUES (0,0),(0,2),(0,3),(0,3),(0,3),(0,4),(0,6),(0,6),(0,6),(0,7),(0,7),(0,9),(0,9),(0,10),(0,10),(0,11),(0,11),(0,13),(0,16),(0,18),(1,2),(1,3),(1,4),(1,51),(1,58),(1,65),(1,67),(1,69);

--
-- Table structure for table `air_group`
--

CREATE TABLE `air_group` (
  `air_groupid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `air_groupname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`air_groupid`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `air_group`
--

INSERT INTO `air_group` (`air_groupid`, `air_groupname`) VALUES (1,'Superadmin');

--
-- Table structure for table `air_log`
--

CREATE TABLE `air_log` (
  `logid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `logtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `air_userid` mediumint(8) unsigned NOT NULL,
  `logdesc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`logid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `air_log`
--


--
-- Table structure for table `air_menu`
--

CREATE TABLE `air_menu` (
  `air_menuid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `air_menuname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `air_menuurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `air_menuparent` mediumint(8) unsigned NOT NULL,
  `air_menupriority` mediumint(5) NOT NULL,
  PRIMARY KEY (`air_menuid`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `air_menu`
--

INSERT INTO `air_menu` (`air_menuid`, `air_menuname`, `air_menuurl`, `air_menuparent`, `air_menupriority`) VALUES (1,'Galaxy User','guser',0,1),(2,'User Admin','user.php',1,1),(3,'Group & Access','group.php',1,2),(4,'Log','log.php',1,3),(8,'Services Management','services',0,2),(51,'Services','services.php',8,1);

--
-- Table structure for table `mod_services`
--

CREATE TABLE `mod_services` (
  `news_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `news_date` date NOT NULL,
  `news_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `news_short` text COLLATE utf8_unicode_ci NOT NULL,
  `news_desc` text COLLATE utf8_unicode_ci NOT NULL,
  `mainimagename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `position` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `priority` tinyint(2) NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `mod_services`
--

INSERT INTO `mod_services` (`news_id`, `news_date`, `news_title`, `news_short`, `news_desc`, `mainimagename`, `position`, `priority`, `url`) VALUES (14,'1970-01-01','Special Service','','<div>\r\n	&bull; Project Cargo handling</div>\r\n<div>\r\n	<br />\r\n	&bull; Certificates of origin preparation and processing</div>\r\n<div>\r\n	<br />\r\n	&bull; Import and export licenses</div>\r\n<div>\r\n	<br />\r\n	&bull; Exhibition Project Handling</div>\r\n<div>\r\n	<br />\r\n	&bull; Temporary Import processing</div>','product_3.jpg','',3,''),(13,'1970-01-01','Airfreight','','<div>\r\n	&bull; Full and partial charters programs</div>\r\n<div>\r\n	<br />\r\n	&bull; Direct AWB and Consolidation</div>\r\n<div>\r\n	<br />\r\n	&bull; Customs brokerage</div>\r\n<div>\r\n	<br />\r\n	&bull; Import, export and trans-shipment</div>\r\n<div>\r\n	<br />\r\n	&bull; Handling special cargo (re-export, temporary import, heavy cargo, etc)</div>\r\n<div>\r\n	<br />\r\n	&bull; Palletized cargo</div>','product_2.jpg','',2,''),(12,'1970-01-01','Seafreight','','<div>\r\n	&bull; NVOCC consolidation services<br />\r\n	&nbsp;</div>\r\n<div>\r\n	&bull; Buyer consolidation</div>\r\n<div>\r\n	<br />\r\n	&bull; Door-to-door service for LCL and FCL</div>\r\n<div>\r\n	<br />\r\n	&bull; Break bulk services</div>\r\n<div>\r\n	<br />\r\n	&bull; Cartage and inland freight by truck</div>\r\n<div>\r\n	<br />\r\n	&bull; Warehousing and storage (short and long term contract)</div>\r\n<div>\r\n	<br />\r\n	&bull; Packaging and crafting</div>\r\n<div>\r\n	<br />\r\n	&bull; Customs brokerage</div>','product_1.jpg','',1,'');

--
-- Dumping events for database 'kalosolo_wb'
--

--
-- Dumping routines for database 'kalosolo_wb'
--


