-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 20, 2018 at 03:57 PM
-- Server version: 5.5.42
-- PHP Version: 5.6.33

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `fce`
--

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

--
-- Table structure for table `fce_server_frieght_cart`
--

CREATE TABLE IF NOT EXISTS `fce_server_frieght_cart` (
  `fce_server_frieght_cart_server_id` bigint(20) unsigned NOT NULL,
  `fce_server_frieght_cart_type` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_id` mediumint(9) NOT NULL DEFAULT '0',
  `fce_server_frieght_cart_station` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_pos` varchar(255) NOT NULL,
  `fce_server_frieght_cart_load_state` varchar(255) NOT NULL,
  `fce_server_frieght_cart_inventory` varchar(255) NOT NULL,
  `fce_server_frieght_cart_inventory_itembase` varchar(255) NOT NULL,
  `fce_server_frieght_cart_inventory_used` mediumint(9) NOT NULL,
  `fce_server_frieght_cart_inventory_max` mediumint(9) NOT NULL,
  `fce_server_frieght_cart_error_state` varchar(255) NOT NULL,
  `fce_server_frieght_cart_track` varchar(255) NOT NULL,
  `fce_server_frieght_cart_pos` varchar(255) NOT NULL,
  `fce_server_frieght_cart_hashcode` varchar(255) NOT NULL,
  `fce_server_frieght_cart_travel_time` mediumint(9) NOT NULL DEFAULT '0',
  `fce_server_frieght_cart_route_count` mediumint(9) NOT NULL DEFAULT '0',
  `fce_server_frieght_cart_route` longtext,
  `fce_server_frieght_cart_timestamp` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `fce_server_frieght_cart_timestamp_update` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`fce_server_frieght_cart_server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `fce_server_frieght_cart_depot`
--

CREATE TABLE IF NOT EXISTS `fce_server_frieght_cart_depot` (
  `fce_server_frieght_cart_depot_id` bigint(20) unsigned NOT NULL,
  `fce_server_frieght_cart_depot_pos` varchar(255) NOT NULL,
  `fce_server_frieght_cart_depot_type` varchar(255) NOT NULL,
  `fce_server_frieght_cart_depot_inventory` text,
  `fce_server_frieght_cart_depot_timestamp` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `fce_server_frieght_cart_depot_timestamp_update` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`fce_server_frieght_cart_depot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `fce_server_frieght_cart_station`
--

CREATE TABLE IF NOT EXISTS `fce_server_frieght_cart_station` (
  `fce_server_frieght_cart_station_id` bigint(20) unsigned NOT NULL,
  `fce_server_frieght_cart_station_name` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_pos` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_offering` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_offering_amount` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_request` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_request_amount` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_isfull` bigint(20) NOT NULL,
  `fce_server_frieght_cart_station_storagehopper` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_storagehopper_inventory` longtext,
  `fce_server_frieght_cart_station_massstorage` varchar(255) NOT NULL,
  `fce_server_frieght_cart_station_massstorage_inventory` longtext,
  `fce_server_frieght_cart_station_enroute` text NOT NULL,
  `fce_server_frieght_cart_station_cart_leave_timer` mediumint(9) NOT NULL,
  `fce_server_frieght_cart_station_departed_carts` mediumint(9) NOT NULL,
  `fce_server_frieght_cart_station_assigned_carts` mediumint(9) NOT NULL DEFAULT '0',
  `fce_server_frieght_cart_station_timestamp` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  `fce_server_frieght_cart_station_timestamp_update` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`fce_server_frieght_cart_station_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `fce_server_map_segment`
--

CREATE TABLE IF NOT EXISTS `fce_server_map_segment` (
  `fce_server_map_segment_base_x` int(11) NOT NULL,
  `fce_server_map_segment_base_y` int(11) NOT NULL,
  `fce_server_map_segment_base_z` int(11) NOT NULL,
  `fce_server_map_segment_air_blocks` smallint(6) NOT NULL DEFAULT '0',
  `fce_server_map_segment_terrain_blocks` smallint(6) NOT NULL DEFAULT '0',
  `fce_server_map_segment_machine_blocks` smallint(6) NOT NULL DEFAULT '0',
  `fce_server_map_segment_terrain_cube_data` longtext NOT NULL,
  `fce_server_map_segment_machine_cube_data` longtext NOT NULL,
  `fce_server_map_segment_map_html` longtext NOT NULL,
  `fce_server_map_segment_request_update` tinyint(1) NOT NULL DEFAULT '0',
  `fce_server_map_segment_request_locked` tinyint(1) NOT NULL DEFAULT '0',
  `fce_server_map_segment_timestamp` varchar(255) NOT NULL DEFAULT '0000-00-00 00:00:00',
  UNIQUE KEY `fce_server_map_segment_base_x` (`fce_server_map_segment_base_x`,`fce_server_map_segment_base_y`,`fce_server_map_segment_base_z`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;