-- WP SQL --

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_wpshortcodes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `createdon` DATETIME NOT NULL,
  `createdby` int(10) NOT NULL,
  `json` text NOT NULL,
  `type` varchar(48) NOT NULL,
  `title` varchar(128) NOT NULL,
  `name` varchar(128) NOT NULL,
  `lang` varchar(8) DEFAULT '*',
  `shortcode` varchar(512) NOT NULL,
  `post_id` int(10) unsigned DEFAULT 0,
  `tmp_post_id` int(10) unsigned DEFAULT 0,
  `parent_id` int(10) unsigned DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- END WP SQL --

--
-- Table structure for table `#__vikrestaurants_reservation`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_reservation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_table` int(10) NOT NULL,
  `id_payment` int(10) DEFAULT 0,
  `coupon_str` varchar(64) DEFAULT '',
  `checkin_ts` int(11) NOT NULL,
  `stay_time` int(6) DEFAULT 0,
  `people` int(4) NOT NULL,
  `purchaser_nominative` varchar(128) DEFAULT '',
  `purchaser_mail` varchar(64) NOT NULL DEFAULT '',
  `purchaser_phone` varchar(32) DEFAULT '',
  `purchaser_prefix` varchar(10) DEFAULT '',
  `purchaser_country` varchar(2) DEFAULT '',
  `langtag` varchar(8) DEFAULT '',
  `custom_f` text DEFAULT NULL,
  `bill_closed` tinyint(1) NOT NULL DEFAULT 0,
  `bill_value` decimal(10,2) DEFAULT 0.0,
  `total_net` decimal(10,2) DEFAULT 0.0,
  `total_tax` decimal(10,2) DEFAULT 0.0,
  `payment_charge` decimal(6,2) DEFAULT 0.0,
  `payment_tax` decimal(6,2) DEFAULT 0.0,
  `deposit` decimal(10,2) DEFAULT 0.0,
  `tot_paid` decimal(10,2) DEFAULT 0.0,
  `discount_val` decimal(10,2) DEFAULT 0.0,
  `tip_amount` decimal(10,2) DEFAULT 0.0,
  `status` varchar(16) DEFAULT 'W',
  `rescode` int(4) DEFAULT 0,
  `arrived` tinyint(1) DEFAULT NULL,
  `locked_until` int(12) DEFAULT 0,
  `sid` varchar(16) NOT NULL DEFAULT '',
  `pin` varchar(4) DEFAULT NULL COMMENT 'used to access the ordering page via QR',
  `pinattempts` int(1) DEFAULT 0 COMMENT 'the number of times the PIN code has been entered erroneously',
  `notes` text DEFAULT NULL,
  `created_on` int(11) DEFAULT 0,
  `created_by` int(10) DEFAULT 0,
  `modified_on` int(11) DEFAULT 0,
  `id_user` int(10) DEFAULT 0,
  `id_operator` int(10) DEFAULT 0,
  `conf_key` varchar(12) DEFAULT '',
  `cc_details` text DEFAULT NULL,
  `need_notif` tinyint(1) DEFAULT 0 COMMENT '1 if the record requires to be notified',
  `closure` tinyint(1) DEFAULT 0,
  `id_parent` int(10) unsigned DEFAULT 0 COMMENT 'the reservation ID to which this record belongs (@see clusters)',
  `payment_log` text DEFAULT NULL,
  PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_table`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_table` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(16) NOT NULL,
  `min_capacity` int(3) NOT NULL,
  `max_capacity` int(3) NOT NULL,
  `multi_res` tinyint(1) NOT NULL DEFAULT 0,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `design_data` text DEFAULT NULL,
  `id_room` int(10) NOT NULL,
  `secretkey` varchar(16) DEFAULT NULL,
  `ordering` int(10) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_table_cluster`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_table_cluster` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `id_table_1` int(6) NOT NULL,
  `id_table_2` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_room`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_room` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `image` varchar(128) DEFAULT '',
  `graphics_properties` text DEFAULT NULL,
  `ordering` int(10) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_room_closure`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_room_closure` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_room` int(10) unsigned NOT NULL,
  `description` varchar(1024) DEFAULT NULL,
  `start_ts` int(11) NOT NULL,
  `end_ts` int(11) NOT NULL,
  `repeat` varchar(16) DEFAULT NULL,
  `stop` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_operator`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_operator` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(16) NOT NULL,
  `firstname` varchar(32) NOT NULL,
  `lastname` varchar(32) NOT NULL,
  `phone_number` varchar(20) DEFAULT '',
  `email` varchar(64) DEFAULT '',
  `can_login` tinyint(1) NOT NULL DEFAULT 0,
  `keep_track` tinyint(1) NOT NULL DEFAULT 1,
  `mail_notifications` tinyint(1) NOT NULL DEFAULT 0,
  `allres` tinyint(1) DEFAULT 0,
  `assign` tinyint(1) DEFAULT 1,
  `rooms` varchar(128) DEFAULT NULL COMMENT 'supported room IDs, comma separated',
  `products` varchar(512) DEFAULT NULL COMMENT 'supported product tags, comma separated',
  `manage_coupon` tinyint(1) NOT NULL DEFAULT 0,
  `group` tinyint(2) unsigned DEFAULT 0,
  `jid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_operator_log`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_operator_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_operator` int(10) unsigned NOT NULL,
  `id_reservation` int(10) unsigned DEFAULT 0,
  `log` varchar(256) NOT NULL COMMENT 'since 1.8 might contain the language key',
  `content` text DEFAULT NULL COMMENT 'a JSON containing the log data',
  `createdon` int(11) NOT NULL,
  `group` tinyint(2) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_shifts`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_shifts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `from` int(4) NOT NULL,
  `to` int(4) NOT NULL,
  `days` varchar(16) DEFAULT NULL,
  `group` tinyint(1) DEFAULT 1,
  `showlabel` tinyint(1) DEFAULT 1,
  `label` varchar(32) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_menus`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `cost` decimal(10,2) DEFAULT 0.0,
  `image` varchar(128) DEFAULT '',
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `choosable` tinyint(1) NOT NULL DEFAULT 1,
  `special_day` tinyint(1) NOT NULL DEFAULT 0,
  `working_shifts` varchar(128) DEFAULT '',
  `days_filter` varchar(64) DEFAULT '',
  `ordering` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_menus_section`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_menus_section` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `published` tinyint(1) DEFAULT 0,
  `highlight` tinyint(1) DEFAULT 1,
  `orderdishes` tinyint(1) DEFAULT 1,
  `ordering` int(10) unsigned NOT NULL,
  `image` varchar(128) DEFAULT '',
  `id_menu` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_section_product`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_section_product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(128) DEFAULT '',
  `price` decimal(10,2) DEFAULT 0.0,
  `id_tax` int(10) unsigned DEFAULT 0,
  `published` tinyint(1) DEFAULT 0,
  `tags` varchar(256) DEFAULT NULL,
  `hidden` tinyint(1) DEFAULT 0,
  `ordering` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_section_product_option`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_section_product_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `inc_price` decimal(10,2) DEFAULT 0.0, 
  `id_product` int(10) NOT NULL,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_section_product_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_section_product_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_section` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `charge` decimal(10,2) DEFAULT 0.0,
  `ordering` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_tag`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_tag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(48) NOT NULL,
  `description` varchar(256) DEFAULT NULL,
  `color` varchar(8) DEFAULT NULL,
  `group` varchar(32) DEFAULT NULL,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_res_menus_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_res_menus_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_reservation` int(10) unsigned NOT NULL,
  `id_menu` int(10) unsigned NOT NULL,
  `quantity` int(4) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_res_prod_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_res_prod_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_reservation` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_product_option` int(10) NOT NULL DEFAULT 0,
  `name` varchar(64) DEFAULT '',
  `quantity` int(4) DEFAULT 1,
  `price` decimal(10,2) DEFAULT 0,
  `net` decimal(10,2) DEFAULT 0.0,
  `tax` decimal(10,2) DEFAULT 0.0,
  `gross` decimal(10,2) DEFAULT 0.0,
  `discount` decimal(10,2) DEFAULT 0.0,
  `tax_breakdown` varchar(1024) DEFAULT NULL,
  `notes` varchar(128) DEFAULT NULL,
  `servingnumber` tinyint(1) DEFAULT 0,
  `rescode` int(4) DEFAULT 0,
  `status` tinyint(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_specialdays`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_specialdays` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `start_ts` int(11),
  `end_ts` int(11),
  `working_shifts` varchar(128) DEFAULT '',
  `custom_shifts` varchar(1024) DEFAULT NULL,
  `days_filter` varchar(64) DEFAULT '',
  `askdeposit` int(4) DEFAULT 1,
  `depositcost` decimal(10,2) NOT NULL,
  `perpersoncost` tinyint(1) NOT NULL DEFAULT 0,
  `peopleallowed` int(4) DEFAULT -1,
  `ignoreclosingdays` tinyint(1) NOT NULL DEFAULT 1,
  `markoncal` tinyint(1) NOT NULL DEFAULT 1,
  `choosemenu` tinyint(1) NOT NULL DEFAULT 0,
  `freechoose` tinyint(1) NOT NULL DEFAULT 1,
  `priority` tinyint(1) NOT NULL DEFAULT 1,
  `minorder` decimal(10,2) DEFAULT 0.0,
  `delivery_service` tinyint(1) DEFAULT -1,
  `delivery_areas` varchar(64) DEFAULT NULL COMMENT 'JSON array containing the accepted delivery areas',
  `group` tinyint(1) DEFAULT 1,
  `images` text DEFAULT NULL,
  `booknotes` text DEFAULT NULL COMMENT 'notes displayed during the booking process',
  `confnotes` text DEFAULT NULL COMMENT 'notes displayed after completing the booking process',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_sd_menus`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_sd_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_spday` int(10) NOT NULL,
  `id_menu` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_custfields`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_custfields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` varchar(2048) DEFAULT NULL,
  `type` varchar(64) NOT NULL DEFAULT 'text',
  `choose` text DEFAULT NULL,
  `required` tinyint(1) NOT NULL DEFAULT 0,
  `required_delivery` tinyint(1) NOT NULL DEFAULT 0,
  `ordering` int(10) NOT NULL DEFAULT 1,
  `rule` varchar(32) DEFAULT '0',
  `poplink` varchar(256) DEFAULT NULL,
  `multiple` tinyint(1) DEFAULT 0,
  `service` varchar(32) DEFAULT NULL,
  `locale` varchar(8) DEFAULT '*',
  `specialdays` varchar(256) DEFAULT NULL COMMENT 'a JSON list containing all the configured special days (IDs)',
  `readonly` tinyint(1) unsigned DEFAULT 0 COMMENT 'editable only once',
  `group` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 for restaurant, 1 for take-away',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_gpayments`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_gpayments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `file` varchar(64) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `enablecost` decimal(8,2) DEFAULT 0,
  `trust` int(4) unsigned DEFAULT 0,
  `prenote` text DEFAULT NULL,
  `note` text DEFAULT NULL,
  `charge` decimal(8,4) DEFAULT NULL,
  `percentot` tinyint(1) DEFAULT 2,
  `id_tax` int(10) unsigned DEFAULT 0,
  `setconfirmed` tinyint(1) NOT NULL DEFAULT 0,
  `selfconfirm` tinyint(1) NOT NULL DEFAULT 0,
  `icontype` tinyint(1) DEFAULT 0,
  `icon` varchar(128) DEFAULT '',
  `params` varchar(2048) DEFAULT NULL,
  `group` tinyint(1) DEFAULT 0,
  `service` varchar(32) DEFAULT NULL,
  `position` varchar(64) DEFAULT '',
  `ordering` int(10) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_coupons`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_coupons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 1,
  `percentot` tinyint(1) NOT NULL DEFAULT 1,
  `value` decimal(12,2) DEFAULT NULL,
  `datevalid` varchar(64) DEFAULT NULL COMMENT '@since 1.9 unused',
  `start_publishing` datetime DEFAULT NULL,
  `end_publishing` datetime DEFAULT NULL,
  `mincost` decimal(10,2) DEFAULT 0.0,
  `minpeople` tinyint(2) DEFAULT 0,
  `remove_gift` tinyint(1) DEFAULT 0,
  `usages` int(6) DEFAULT 0,
  `maxusages` int(6) DEFAULT 0,
  `maxperuser` int(6) DEFAULT 0,
  `group` tinyint(1) DEFAULT 0,
  `notes` varchar(512) DEFAULT '',
  `id_category` int(10) unsigned DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_coupon_category`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_coupon_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(48) NOT NULL,
  `description` varchar(2048) DEFAULT '',
  `ordering` int(10) unsigned DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_res_code`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_res_code` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(64) NOT NULL,
  `icon` varchar(128) DEFAULT '',
  `notes` varchar(1024) DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT 1,
  `rule` varchar(32) DEFAULT NULL,
  `sendmail` tinyint(1) DEFAULT 0,
  `ordering` int(10) unsigned DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_mail_text`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_mail_text` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `filters` text DEFAULT NULL,
  `actions` text DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `ordering` int(10) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_config`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `param` varchar(32) NOT NULL DEFAULT 'false',
  `setting` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `param` (`param`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_menus`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  -- @since 1.9 renamed from `publish_up`
  `start_publishing` int(11) DEFAULT NULL,
  -- @since 1.9 renamed from `publish_down`
  `end_publishing` int(11) DEFAULT NULL,
  `taxes_type` tinyint(1) NOT NULL DEFAULT 0,
  `taxes_amount` decimal(8,2) DEFAULT 0.0,
  `layout` varchar(32) DEFAULT 'list',
  `ordering` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_menus_entry`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_menus_entry` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(10,2) DEFAULT 0.0,
  `id_tax` int(10) unsigned DEFAULT 0,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `minqty` int(4) DEFAULT 1,
  `ready` tinyint(1) NOT NULL DEFAULT 0,
  `img_path` varchar(128) DEFAULT '',
  `img_extra` varchar(256) DEFAULT NULL,
  `items_in_stock` int(6) unsigned DEFAULT 9999,
  `notify_below` int(6) unsigned DEFAULT 5,
  `stock_notified` tinyint(1) DEFAULT 0,
  `id_takeaway_menu` int(10) NOT NULL,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_menus_entry_option`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_menus_entry_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `inc_price` decimal(10,2) DEFAULT 0.0,
  `published` tinyint(1) NOT NULL DEFAULT 1,
  `items_in_stock` int(6) unsigned DEFAULT 9999,
  `stock_enabled` tinyint(1) DEFAULT 1 COMMENT 'use parent stock params if disabled',
  `notify_below` int(6) unsigned DEFAULT 5,
  `stock_notified` tinyint(1) DEFAULT 0,
  `id_takeaway_menu_entry` int(10) NOT NULL,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_menus_attribute`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_menus_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(48) NOT NULL,
  `description` varchar(512) DEFAULT '',
  `published` tinyint(1) DEFAULT 1,
  `icontype` varchar(16) DEFAULT 'image' COMMENT 'either image or fonticon',
  `icon` varchar(64) DEFAULT '',
  `font` varchar(256) DEFAULT NULL COMMENT 'the font icon JSON config',
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_menus_attr_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_menus_attr_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_menuentry` int(10) unsigned NOT NULL,
  `id_attribute` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_topping_separator`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_topping_separator` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(48) NOT NULL,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_topping`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_topping` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` varchar(256) DEFAULT '',
  `price` decimal(10, 2) DEFAULT 0.0,
  `published` tinyint(1) DEFAULT 1,
  `id_separator` int(10) DEFAULT -1,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_entry_group_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_entry_group_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_entry` int(10) unsigned NOT NULL,
  `id_variation` int(10) DEFAULT -1,
  `title` varchar(64) NOT NULL,
  `description` varchar(128) DEFAULT NULL,
  `multiple` tinyint(1) DEFAULT 0,
  `min_toppings` tinyint(2) DEFAULT 1,
  `max_toppings` tinyint(2) DEFAULT 1,
  `use_quantity` tinyint(1) DEFAULT 0,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_group_topping_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_group_topping_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_group` int(10) unsigned NOT NULL,
  `id_topping` int(10) unsigned NOT NULL,
  `rate` decimal(10, 2) DEFAULT 0.0,
  `ordering` int(10) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_deal`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_deal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `max_quantity` int(4) DEFAULT -1,
  `start_ts` int(11) DEFAULT -1,
  `end_ts` int(11) DEFAULT -1,
  `shifts` varchar(128) DEFAULT '' COMMENT 'JSON list with shifts available',
  `service` tinyint(1) DEFAULT 2 COMMENT '0: pickup, 1: delivery, 2: both',
  `published` tinyint(1) DEFAULT 0,
  `ordering` int(10) unsigned DEFAULT 1,
  `params` varchar(2048) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_deal_day_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_deal_day_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_deal` int(10) unsigned NOT NULL,
  `id_weekday` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_deal_product_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_deal_product_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_deal` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_option` int(10) DEFAULT -1,
  `params` varchar(2048) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_deal_free_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_deal_free_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_deal` int(10) unsigned NOT NULL,
  `id_product` int(10) unsigned NOT NULL,
  `id_option` int(10) DEFAULT -1,
  `params` varchar(2048) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_delivery_area`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_delivery_area` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `type` varchar(64) NOT NULL,
  `content` text NOT NULL,
  `attributes` varchar(512) DEFAULT '',
  `charge` decimal(8, 2) DEFAULT 0.0,
  `min_cost` decimal(10, 2) DEFAULT 0.0,
  `published` tinyint(1) DEFAULT 1,
  `ordering` int(10) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_origin`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_origin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `address` varchar(512) NOT NULL,
  `description` varchar(1024) DEFAULT NULL,
  `latitude` decimal(12,9) DEFAULT NULL,
  `longitude` decimal(12,9) DEFAULT NULL,
  `image` varchar(256) DEFAULT NULL,
  `published` tinyint(1) DEFAULT 1,
  `ordering` int(10) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_reservation`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_reservation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_payment` int(10) DEFAULT 0,
  `delivery_service` tinyint(1) NOT NULL DEFAULT 1 COMMENT '@deprecated 1.11',
  `service` varchar(32) NOT NULL DEFAULT 'delivery',
  `coupon_str` varchar(64) DEFAULT '',
  `checkin_ts` int(11) NOT NULL,
  `preparation_ts` int(11) DEFAULT NULL,
  `asap` tinyint(1) DEFAULT 0,
  `purchaser_nominative` varchar(128) DEFAULT '',
  `purchaser_mail` varchar(64) NOT NULL DEFAULT '',
  `purchaser_phone` varchar(32) DEFAULT '',
  `purchaser_prefix` varchar(10) DEFAULT '',
  `purchaser_country` varchar(2) DEFAULT '',
  `purchaser_address` varchar(256) DEFAULT '',
  `langtag` varchar(8) DEFAULT '',
  `custom_f` text DEFAULT NULL,
  `total_to_pay` decimal(10,2) DEFAULT 0.0,
  `total_net` decimal(10,2) DEFAULT 0.0,
  `total_tax` decimal(10,2) DEFAULT 0.0,
  `tot_paid` decimal(10,2) DEFAULT 0.0,
  `payment_charge` decimal(6,2) DEFAULT 0.0,
  `payment_tax` decimal(6,2) DEFAULT 0.0,
  `delivery_charge` decimal(10,2) DEFAULT 0.0,
  `delivery_tax` decimal(6,2) DEFAULT 0.0,
  `discount_val` decimal(10,2) DEFAULT 0.0,
  `tip_amount` decimal(10,2) DEFAULT 0.0,
  `status` varchar(16) DEFAULT 'W',
  `rescode` int(4) DEFAULT 0,
  `locked_until` int(12) DEFAULT 0,
  `sid` varchar(16) NOT NULL DEFAULT '000000000000',
  `notes` text DEFAULT NULL,
  `created_on` int(11) DEFAULT 0,
  `created_by` int(10) DEFAULT 0,
  `modified_on` int(11) DEFAULT 0,
  `id_user` int(10) DEFAULT -1,
  `id_operator` int(10) DEFAULT 0,
  `conf_key` varchar(12) DEFAULT '',
  `route` varchar(512) DEFAULT '', 
  `cc_details` text DEFAULT NULL,
  `need_notif` tinyint(1) DEFAULT 0 COMMENT '1 if the record requires to be notified',
  `current` tinyint(1) DEFAULT NULL COMMENT 'flag used to stick the order within the current widget',
  `payment_log` text DEFAULT NULL,
  PRIMARY KEY (`id`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_res_prod_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_res_prod_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_product` int(10) NOT NULL,
  `id_product_option` int(10) NOT NULL DEFAULT 0,
  `id_res` int(10) NOT NULL,
  `quantity` int(5) NOT NULL DEFAULT 1,
  `price` decimal(10,2) NOT NULL DEFAULT 0.0,
  `net` decimal(10,2) DEFAULT 0.0,
  `tax` decimal(10,2) DEFAULT 0.0,
  `gross` decimal(10,2) DEFAULT 0.0,
  `discount` decimal(10,2) DEFAULT 0.0,
  `tax_breakdown` varchar(1024) DEFAULT NULL,
  `notes` varchar(256) DEFAULT NULL,
  `rescode` int(4) DEFAULT 0,
  `status` tinyint(1) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `tags` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_res_prod_topping_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_res_prod_topping_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_assoc` int(10) NOT NULL,
  `id_group` int(10) NOT NULL,
  `id_topping` int(10) NOT NULL,
  `units` tinyint(2) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_stock_override`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_stock_override` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `items_available` int(6) unsigned NOT NULL,
  `ts` int(12) unsigned NOT NULL,
  `id_takeaway_entry` int(10) unsigned NOT NULL,
  `id_takeaway_option` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_takeaway_avail_override`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_takeaway_avail_override` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `units` int(6) DEFAULT 0,
  `ts` int(12) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_upsell_item_pairs`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_upsell_item_pairs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_a` int(10) NOT NULL,
  `item_b` int(10) NOT NULL,
  `count` int(10) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_upsell_item_totals`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_upsell_item_totals` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item` int(10) NOT NULL,
  `count` int(10) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_users`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jid` int(10) NOT NULL,
  `fields` text DEFAULT NULL,
  `tkfields` text DEFAULT NULL,
  `country_code` varchar(2),
  `billing_name` varchar(64) DEFAULT '',
  `billing_mail` varchar(64) DEFAULT '',
  `billing_phone` varchar(64) DEFAULT '',
  `billing_state` varchar(64) DEFAULT '',
  `billing_city` varchar(64) DEFAULT '',
  `billing_address` varchar(128) DEFAULT '',
  `billing_address_2` varchar(64) DEFAULT '',
  `billing_zip` varchar(12) DEFAULT '',
  `company` varchar(64) DEFAULT '',
  `vatnum` varchar(24) DEFAULT '',
  `ssn` varchar(32) DEFAULT '',
  `notes` varchar(2048) DEFAULT '',
  `image` varchar(128) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_user_delivery`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_user_delivery` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned NOT NULL,
  `type` tinyint(1) DEFAULT 1,
  `country` varchar(2) DEFAULT '',
  `state` varchar(64) DEFAULT '',
  `city` varchar(64) DEFAULT '',
  `address` varchar(128) NOT NULL,
  `address_2` varchar(64) DEFAULT '',
  `zip` varchar(12) NOT NULL,
  `note` varchar(1024) DEFAULT NULL,
  `longitude` decimal(9,6) DEFAULT NULL,
  `latitude` decimal(9,6) DEFAULT NULL,
  `ordering` int(2) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_countries`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country_name` varchar(48) NOT NULL,
  `country_2_code` varchar(2) NOT NULL,
  `country_3_code` varchar(3) NOT NULL,
  `phone_prefix` varchar(8) NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `country_2_code` (`country_2_code`),
  UNIQUE KEY `country_3_code` (`country_3_code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_reviews`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_reviews` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jid` int(10) NOT NULL,
  `ipaddr` varchar(24) DEFAULT '',
  `timestamp` int(12) NOT NULL,
  `name` varchar(128) NOT NULL,
  `email` varchar(128) NOT NULL,
  `title` varchar(64) DEFAULT '',
  `comment` text DEFAULT NULL,
  `rating` int(1) unsigned DEFAULT 0, 
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `verified` tinyint(1) NOT NULL DEFAULT 0,
  `langtag` varchar(8) DEFAULT '',
  `id_takeaway_product` int(10) DEFAULT -1,
  `conf_key` varchar(12) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_invoice`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_invoice` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_order` int(10) unsigned NOT NULL,
  `inv_number` varchar(32) NOT NULL,
  `inv_date` int(11) NOT NULL,
  `file` varchar(32) NOT NULL,
  `createdon` int(11) NOT NULL,
  `group` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_order_status`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_order_status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_order` int(10) unsigned NOT NULL,
  `id_rescode` int(10) NOT NULL,
  `notes` varchar(1024) DEFAULT '',
  `createdby` int(10) NOT NULL,
  `createdon` int(11) NOT NULL,
  `group` tinyint(1) unsigned NOT NULL COMMENT '1 for restaurant, 2 for take-away',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_stats_widget`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_stats_widget` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned DEFAULT 0 NOT NULL,
  `name` varchar(128) DEFAULT NULL,
  `widget` varchar(64) NOT NULL,
  `position` varchar(64) NOT NULL,
  `group` varchar(16) NOT NULL COMMENT 'restaurant or takeaway',
  `location` varchar(16) NOT NULL COMMENT 'dashboard or statistics',
  `size` varchar(32) DEFAULT NULL,
  `ordering` int(4) unsigned DEFAULT 1,
  `params` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_admin_notes`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_admin_notes` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(2048) DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0 COMMENT '0: private, 1: public, 2: archived',
  `created` datetime DEFAULT NULL,
  `created_by` int(10) DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `modified_by` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_unicode_ci AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_tax`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_tax` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT '',
  `description` varchar(1024) DEFAULT '',
  `createdon` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_tax_rule`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_tax_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_tax` int(10) unsigned NOT NULL,
  `name` varchar(128) DEFAULT '',
  `operator` varchar(16) NOT NULL,
  `amount` decimal(10,4) DEFAULT 0.0,
  `cap` decimal(10,2) DEFAULT 0.0,
  `apply` tinyint(1) DEFAULT 1 COMMENT '1 base cost, 2 on cascade',
  `breakdown` varchar(1024) DEFAULT NULL COMMENT 'JSON representation of taxes breakdown',
  `ordering` tinyint(2) unsigned DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_media`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(256) NOT NULL,
  `alt` varchar(256) DEFAULT NULL,
  `title` varchar(256) DEFAULT NULL,
  `caption` varchar(2048) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_status_code`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_status_code` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` varchar(512) DEFAULT NULL,
  `code` varchar(16) NOT NULL,
  `color` varchar(8) DEFAULT NULL,
  `ordering` int(10) unsigned DEFAULT 1,
  `restaurant` tinyint(1) DEFAULT 1,
  `takeaway` tinyint(1) DEFAULT 1,
  `approved` tinyint(1) DEFAULT 0,
  `reserved` tinyint(1) DEFAULT 0,
  `expired` tinyint(1) DEFAULT 0,
  `cancelled` tinyint(1) DEFAULT 0,
  `paid` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_api_login`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_api_login` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `application` varchar(64) DEFAULT '',
  `username` varchar(128) NOT NULL,
  `password` varchar(128) NOT NULL,
  `ips` varchar(256) DEFAULT '',
  `active` tinyint(1) DEFAULT 0,
  `last_login` int(11) DEFAULT -1,
  `denied` varchar(256) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_api_login_event_options`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_api_login_event_options` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_login` int(10) unsigned NOT NULL,
  `id_event` varchar(128) NOT NULL,
  `options` text DEFAULT NULL COMMENT 'JSON configuration for event/user relation',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_api_login_logs`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_api_login_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_login` int(10) DEFAULT -1,
  `status` tinyint(1) DEFAULT 1,
  `content` varchar(512) NOT NULL,
  `payload` text DEFAULT NULL,
  `ip` varchar(24) DEFAULT '',
  `createdon` int(11) DEFAULT -1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_api_ban`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_api_ban` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(24) DEFAULT '',
  `fail_count` int(4) DEFAULt 0,
  `last_update` int(11) DEFAULT -1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_cronjob`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_cronjob` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `class` varchar(128) NOT NULL,
  `published` tinyint(1) DEFAULT 0,
  `params` text DEFAULT NULL,
  `createdon` datetime DEFAULT NULL,
  `resume_notif` datetime DEFAULT NULL COMMENT 'the date when the notifications will be resumed',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_cronjob_log`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_cronjob_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `metadata` blob DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `mailed` tinyint(1) DEFAULT 0,
  `createdon` datetime DEFAULT NULL,
  `id_cronjob` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_room`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_room` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` text DEFAULT NULL,
  `id_room` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_menus`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `id_menu` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_menus_section`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_menus_section` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `id_section` int(10) unsigned NOT NULL,
  `id_parent` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_section_product`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_section_product` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `id_product` int(10) unsigned NOT NULL,
  -- `id_parent` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_section_product_option`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_section_product_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `id_option` int(10) unsigned NOT NULL,
  `id_parent` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_section_product_attr_assoc`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_section_product_attr_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_menuentry` int(10) unsigned NOT NULL,
  `id_attribute` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_takeaway_menus`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_takeaway_menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `id_menu` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_takeaway_menus_entry`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_takeaway_menus_entry` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `id_entry` int(10) unsigned NOT NULL,
  `id_parent` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_takeaway_menus_entry_option`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_takeaway_menus_entry_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `alias` varchar(64) DEFAULT NULL,
  `id_option` int(10) unsigned NOT NULL,
  `id_parent` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_takeaway_menus_entry_topping_group`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_takeaway_menus_entry_topping_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` varchar(128) DEFAULT NULL,
  `id_group` int(10) unsigned NOT NULL,
  `id_parent` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_takeaway_topping`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_takeaway_topping` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` varchar(256) DEFAULT '',
  `id_topping` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_takeaway_menus_attribute`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_takeaway_menus_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` varchar(512) DEFAULT NULL,
  `id_attribute` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_takeaway_deal`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_takeaway_deal` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `id_deal` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_payments`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `note` text DEFAULT NULL,
  `prenote` text DEFAULT NULL,
  `id_payment` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_customf`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_customf` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(256) NOT NULL,
  `description` varchar(2048) DEFAULT NULL,
  `choose` text DEFAULT NULL,
  `poplink` varchar(256) DEFAULT '',
  `id_customf` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_status_code`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_status_code` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` varchar(512) NOT NULL,
  `id_status_code` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_tax`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_tax` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `id_tax` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_tax_rule`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_tax_rule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `breakdown` varchar(1024) DEFAULT NULL,
  `id_tax_rule` int(10) unsigned NOT NULL,
  `id_parent` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_media`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `alt` varchar(256) DEFAULT NULL,
  `title` varchar(256) DEFAULT NULL,
  `caption` varchar(2048) DEFAULT NULL,
  `image` varchar(256) NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Table structure for table `#__vikrestaurants_lang_config`
--

CREATE TABLE IF NOT EXISTS `#__vikrestaurants_lang_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `setting` text DEFAULT NULL,
  `param` varchar(32) NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

--
-- Dumping data for table `#__vikrestaurants_gpayments`
--

INSERT INTO `#__vikrestaurants_gpayments`
(               `name`,                    `file`, `published`, `setconfirmed`, `ordering`) VALUES
(             'PayPal', 'paypal_express_checkout',           0,              0,          1),
(     'Pay on Arrival',           'bank_transfer',           0,              1,          2),
('Offline Credit Card',     'offline_credit_card',           0,              0,          3);

--
-- Dumping data for table `#__vikrestaurants_custfields`
--

-- Restaurant

INSERT INTO `#__vikrestaurants_custfields`
(         `name`, `type`,       `rule`, `required`, `group`, `ordering`, `choose`) VALUES
( 'CUSTOMF_NAME', 'text', 'nominative',          1,       0,          1,       ''),
('CUSTOMF_LNAME', 'text', 'nominative',          1,       0,          2,       ''),
('CUSTOMF_EMAIL', 'text',      'email',          1,       0,          3,       ''),
('CUSTOMF_PHONE', 'text',      'phone',          1,       0,          4,     'US');

-- Take-Away

INSERT INTO `#__vikrestaurants_custfields`
(              `name`,      `type`,          `rule`,  `service`, `required`, `group`, `ordering`, `choose`) VALUES
-- billing details
(    'CUSTOMF_TKINFO', 'separator',              '',       NULL,          0,       1,          1,       ''),
(    'CUSTOMF_TKNAME',      'text',    'nominative',       NULL,          1,       1,          2,       ''),
(   'CUSTOMF_TKEMAIL',      'text',         'email',       NULL,          1,       1,          3,       ''),
(   'CUSTOMF_TKPHONE',      'text',         'phone',       NULL,          1,       1,          4,     'US'),
-- delivery details
('CUSTOMF_TKDELIVERY', 'separator',              '', 'delivery',          0,       1,          5,       ''),
( 'CUSTOMF_TKADDRESS',      'text',       'address', 'delivery',          1,       1,          6,       ''),
(     'CUSTOMF_TKZIP',      'text',           'zip', 'delivery',          1,       1,          7,       ''),
(    'CUSTOMF_TKNOTE',  'textarea', 'deliverynotes', 'delivery',          0,       1,          8,       '');

--
-- Dumping data for table `#__vikrestaurants_status_code`
--

INSERT INTO `#__vikrestaurants_status_code`
(     `name`, `code`,  `color`, `ordering`, `approved`, `reserved`, `expired`, `cancelled`, `paid`, `restaurant`, `takeaway`) VALUES
('Confirmed',    'C', '008000',          1,          1,          1,         0,           0,      0,            1,          1),
(     'Paid',    'P', '339CCC',          2,          1,          1,         0,           0,      1,            1,          1),
(  'Pending',    'W', 'FF7000',          3,          0,          1,         0,           0,      0,            1,          1),
(  'Removed',    'E', '990000',          4,          0,          0,         1,           0,      0,            1,          1),
('Cancelled',    'X', 'F01B17',          5,          0,          0,         0,           1,      0,            1,          1),
( 'Rejected',    'D', 'BD0045',          6,          0,          0,         1,           1,      0,            1,          1),
( 'Refunded',    'R', '8116C9',          7,          0,          0,         0,           1,      1,            1,          1),
(  'No-Show',    'N', '828282',          8,          1,          1,         0,           0,      0,            1,          1);

--
-- Dumping data for table `#__vikrestaurants_res_code`
--

-- Restaurant

INSERT INTO `#__vikrestaurants_res_code`
(         `code`,      `rule`,              `icon`, `type`, `ordering`) VALUES
(      'Arrived',   'Arrived',       'arrived.png',      1,          1),
(       'Seated',          '',        'seated.png',      1,          2),
(     'Starters',          '',      'starters.png',      1,          3),
( 'Main Courses',          '',  'main_courses.png',      1,          4),
(      'Dessert',          '',       'dessert.png',      1,          5),
('Table Cleared', 'CloseBill', 'table_cleared.png',      1,          6),
( 'Bill Dropped',     'Leave',  'bill_dropped.png',      1,          7);

-- Take-Away

INSERT INTO `#__vikrestaurants_res_code`
(     `code`,      `rule`,          `icon`, `type`, `ordering`, `notes`) VALUES
('Preparing', 'Preparing', 'preparing.png',      2,          1, 'Your order is in preparation.'),
(    'Ready',          '',     'ready.png',      2,          2, 'Your order is ready.'),
('Delivered', 'Completed', 'delivered.png',      2,          3, 'Your order has been delivered.'),
(   'Picked', 'Completed',    'picked.png',      2,          4, 'The order has been picked up.');

-- Food

INSERT INTO `#__vikrestaurants_res_code`
(      `code`,     `rule`,           `icon`, `type`, `ordering`) VALUES
( 'Scheduled',         '',  'scheduled.png',      3,          1),
(   'Cooking',  'Cooking',    'cooking.png',      3,          2),
(  'Prepared', 'Prepared',   'prepared.png',      3,          3),
('Delivering',   'Waiter', 'delivering.png',      3,          4);

--
-- Dumping data for table `#__vikrestaurants_takeaway_menus_attribute`
--

INSERT INTO `#__vikrestaurants_takeaway_menus_attribute`
(                         `name`, `ordering`, `icontype`, `font`) VALUES
(    'Cereals containing gluten',          1, 'fonticon', '{\"icon\":\"wheat-awn\",\"custom\":\"\",\"color\":\"E3C446\"}'),
(                  'Crustaceans',          2, 'fonticon', '{\"icon\":\"shrimp\",\"custom\":\"\",\"color\":\"F01641\"}'),
(                         'Eggs',          3, 'fonticon', '{\"icon\":\"egg\",\"custom\":\"\",\"color\":\"BD976F\"}'),
(                         'Fish',          4, 'fonticon', '{\"icon\":\"fish-fins\",\"custom\":\"\",\"color\":\"7EBCDE\"}'),
(                      'Peanuts',          5, 'fonticon', '{\"icon\":\"seedling\",\"custom\":\"\",\"color\":\"A8691C\"}'),
(                          'Soy',          6, 'fonticon', '{\"icon\":\"seedling\",\"custom\":\"\",\"color\":\"\"}'),
(                         'Milk',          7, 'fonticon', '{\"icon\":\"cow\",\"custom\":\"\",\"color\":\"818194\"}'),
(                         'Nuts',          8, 'fonticon', '{\"icon\":\"tree\",\"custom\":\"\",\"color\":\"0F7827\"}'),
(                       'Celery',          9, 'fonticon', '{\"icon\":\"leaf\",\"custom\":\"\",\"color\":\"96ED4E\"}'),
(                      'Mustard',         10, 'fonticon', '{\"icon\":\"bottle-droplet\",\"custom\":\"\",\"color\":\"F2DD77\"}'),
(                       'Sesame',         11, 'fonticon', '{\"icon\":\"bowl-rice\",\"custom\":\"\",\"color\":\"CF9A4F\"}'),
('Sulphur dioxide and sulphites',         12, 'fonticon', '{\"icon\":\"wine-glass\",\"custom\":\"\",\"color\":\"802980\"}'),
(                       'Lupins',         13, 'fonticon', '{\"icon\":\"custom\",\"custom\":\"circle-dot\",\"color\":\"DBBE55\"}'),
(                     'Molluscs',         14, 'fonticon', '{\"icon\":\"water\",\"custom\":\"\",\"color\":\"2C6AE8\"}'),
(                        'Spicy',         15, 'fonticon', '{\"icon\":\"pepper-hot\",\"custom\":\"\",\"color\":\"D61542\"}'),
(                   'Vegetarian',         16, 'fonticon', '{\"icon\":\"carrot\",\"custom\":\"\",\"color\":\"F0A638\"}');

--
-- Dumping data for table `#__vikrestaurants_stats_widget`
--

-- Restaurant Statistics

INSERT INTO `#__vikrestaurants_stats_widget` (`name`, `widget`, `position`, `group`, `location`, `size`, `ordering`) VALUES
('', 'weekres'    , 'top'   , 'restaurant', 'statistics', ''     , 1),
('', 'weekrevenue', 'top'   , 'restaurant', 'statistics', ''     , 2),
('', 'occupancy'  , 'top'   , 'restaurant', 'statistics', ''     , 3),
('', 'trend'      , 'center', 'restaurant', 'statistics', 'large', 4),
('', 'overall'    , 'center', 'restaurant', 'statistics', ''     , 5),
('', 'statusres'  , 'bottom', 'restaurant', 'statistics', ''     , 6),
('', 'avgdaily'   , 'bottom', 'restaurant', 'statistics', ''     , 7),
('', 'customers'  , 'bottom', 'restaurant', 'statistics', ''     , 8);

-- Take-Away Statistics

INSERT INTO `#__vikrestaurants_stats_widget` (`name`, `widget`, `position`, `group`, `location`, `size`, `ordering`) VALUES
('', 'weekres'     , 'top'   , 'takeaway', 'statistics', ''     , 1),
('', 'weekrevenue' , 'top'   , 'takeaway', 'statistics', ''     , 2),
('', 'rog'         , 'top'   , 'takeaway', 'statistics', 'small', 3),
('', 'trend'       , 'center', 'takeaway', 'statistics', 'large', 4),
('', 'bestproducts', 'center', 'takeaway', 'statistics', ''     , 5),
('', 'service'     , 'bottom', 'takeaway', 'statistics', ''     , 6),
('', 'avgdaily'    , 'bottom', 'takeaway', 'statistics', ''     , 7),
('', 'customers'   , 'bottom', 'takeaway', 'statistics', ''     , 8);

-- Restaurant Dashboard

INSERT INTO `#__vikrestaurants_stats_widget` (`name`, `widget`, `position`, `group`, `location`, `size`, `ordering`) VALUES
('', 'reservations', 'center', 'restaurant', 'dashboard', '', 1),
('', 'overview'    , 'footer', 'restaurant', 'dashboard', '', 2);

-- Take-Away Dashboard

INSERT INTO `#__vikrestaurants_stats_widget` (`name`, `widget`, `position`, `group`, `location`, `size`, `ordering`) VALUES
('', 'weekres'     , 'top'   , 'takeaway', 'dashboard', ''     , 1),
('', 'weekrevenue' , 'top'   , 'takeaway', 'dashboard', ''     , 2),
('', 'rog'         , 'top'   , 'takeaway', 'dashboard', 'small', 3),
('', 'orders'      , 'center', 'takeaway', 'dashboard', ''     , 4),
('', 'times'       , 'center', 'takeaway', 'dashboard', 'small', 5);

--
-- Dumping data for table `#__vikrestaurants_countries`
--

INSERT INTO `#__vikrestaurants_countries`
(                                `country_name`, `country_2_code`, `country_3_code`, `phone_prefix`, `published`) VALUES
(                                 'Afghanistan',             'AF',            'AFG',          '+93',           1),
(                                       'Aland',             'AX',            'ALA',      '+358 18',           1),
(                                     'Albania',             'AL',            'ALB',         '+355',           1),
(                                     'Algeria',             'DZ',            'DZA',         '+213',           1),
(                              'American Samoa',             'AS',            'ASM',       '+1 684',           1),
(                                     'Andorra',             'AD',            'AND',         '+376',           1),
(                                      'Angola',             'AO',            'AGO',         '+244',           1),
(                                    'Anguilla',             'AI',            'AIA',       '+1 264',           1),
(                                  'Antarctica',             'AQ',            'ATA',        '+6721',           1),
(                         'Antigua and Barbuda',             'AG',            'ATG',       '+1 268',           1),
(                                   'Argentina',             'AR',            'ARG',          '+54',           1),
(                                     'Armenia',             'AM',            'ARM',         '+374',           1),
(                                       'Aruba',             'AW',            'ABW',         '+297',           1),
(                            'Ascension Island',             'AC',            'ASC',         '+247',           1),
(                                   'Australia',             'AU',            'AUS',          '+61',           1),
(                                     'Austria',             'AT',            'AUT',          '+43',           1),
(                                  'Azerbaijan',             'AZ',            'AZE',         '+994',           1),
(                                     'Bahamas',             'BS',            'BHS',       '+1 242',           1),
(                                     'Bahrain',             'BH',            'BHR',         '+973',           1),
(                                  'Bangladesh',             'BD',            'BGD',         '+880',           1),
(                                    'Barbados',             'BB',            'BRB',       '+1 246',           1),
(                                     'Belarus',             'BY',            'BLR',         '+375',           1),
(                                     'Belgium',             'BE',            'BEL',          '+32',           1),
(                                      'Belize',             'BZ',            'BLZ',         '+501',           1),
(                                       'Benin',             'BJ',            'BEN',         '+229',           1),
(                                     'Bermuda',             'BM',            'BMU',       '+1 441',           1),
(                                      'Bhutan',             'BT',            'BTN',         '+975',           1),
(                                     'Bolivia',             'BO',            'BOL',         '+591',           1),
(                      'Bosnia and Herzegovina',             'BA',            'BIH',         '+387',           1),
(                                    'Botswana',             'BW',            'BWA',         '+267',           1),
(                               'Bouvet Island',             'BV',            'BVT',          '+47',           0),
(                                      'Brazil',             'BR',            'BRA',          '+55',           1),
(              'British Indian Ocean Territory',             'IO',            'IOT',         '+246',           1),
(                      'British Virgin Islands',             'VG',            'VGB',       '+1 284',           1),
(                                      'Brunei',             'BN',            'BRN',         '+673',           1),
(                                    'Bulgaria',             'BG',            'BGR',         '+359',           1),
(                                'Burkina Faso',             'BF',            'BFA',         '+226',           1),
(                                     'Burundi',             'BI',            'BDI',         '+257',           1),
(                                    'Cambodia',             'KH',            'KHM',         '+855',           1),
(                                    'Cameroon',             'CM',            'CMR',         '+237',           1),
(                                      'Canada',             'CA',            'CAN',           '+1',           1),
(                                  'Cape Verde',             'CV',            'CPV',         '+238',           1),
(                              'Cayman Islands',             'KY',            'CYM',       '+1 345',           1),
(                    'Central African Republic',             'CF',            'CAF',         '+236',           1),
(                                        'Chad',             'TD',            'TCD',         '+235',           1),
(                                       'Chile',             'CL',            'CHL',          '+56',           1),
(                                       'China',             'CN',            'CHN',          '+86',           1),
(                            'Christmas Island',             'CX',            'CXR',     '+61 8964',           1),
(                               'Cocos Islands',             'CC',            'CCK',     '+61 8962',           1),
(                                    'Colombia',             'CO',            'COL',          '+57',           1),
(                                     'Comoros',             'KM',            'COM',         '+269',           1),
(                                'Cook Islands',             'CK',            'COK',         '+682',           1),
(                                  'Costa Rica',             'CR',            'CRI',         '+506',           1),
(                              'Cote d\'Ivoire',             'CI',            'CIV',         '+225',           1),
(                                     'Croatia',             'HR',            'HRV',         '+385',           1),
(                                        'Cuba',             'CU',            'CUB',          '+53',           1),
(                                      'Cyprus',             'CY',            'CYP',         '+357',           1),
(                              'Czech Republic',             'CZ',            'CZE',         '+420',           1),
(            'Democratic Republic of the Congo',             'CD',            'COD',         '+243',           1),
(                                     'Denmark',             'DK',            'DNK',          '+45',           1),
(                                    'Djibouti',             'DJ',            'DJI',         '+253',           1),
(                                    'Dominica',             'DM',            'DMA',       '+1 767',           1),
(                          'Dominican Republic',             'DO',            'DOM',       '+1 809',           1),
(                                  'East Timor',             'TL',            'TLS',         '+670',           1),
(                                     'Ecuador',             'EC',            'ECU',         '+593',           1),
(                                       'Egypt',             'EG',            'EGY',          '+20',           1),
(                                 'El Salvador',             'SV',            'SLV',         '+503',           1),
(                           'Equatorial Guinea',             'GQ',            'GNQ',         '+240',           1),
(                                     'Eritrea',             'ER',            'ERI',         '+291',           1),
(                                     'Estonia',             'EE',            'EST',         '+372',           1),
(                                    'Ethiopia',             'ET',            'ETH',         '+251',           1),
(                            'Falkland Islands',             'FK',            'FLK',         '+500',           1),
(                               'Faroe Islands',             'FO',            'FRO',         '+298',           1),
(                                        'Fiji',             'FJ',            'FJI',         '+679',           1),
(                                     'Finland',             'FI',            'FIN',         '+358',           1),
(                                      'France',             'FR',            'FRA',          '+33',           1),
(    'French Austral and Antarctic Territories',             'TF',            'ATF',          '+33',           1),
(                               'French Guiana',             'GF',            'GUF',         '+594',           1),
(                            'French Polynesia',             'PF',            'PYF',         '+689',           1),
(                                       'Gabon',             'GA',            'GAB',         '+241',           1),
(                                      'Gambia',             'GM',            'GMB',         '+220',           1),
(                                     'Georgia',             'GE',            'GEO',         '+995',           1),
(                                     'Germany',             'DE',            'DEU',          '+49',           1),
(                                       'Ghana',             'GH',            'GHA',         '+233',           1),
(                                   'Gibraltar',             'GI',            'GIB',         '+350',           1),
(                                      'Greece',             'GR',            'GRC',          '+30',           1),
(                                   'Greenland',             'GL',            'GRL',         '+299',           1),
(                                     'Grenada',             'GD',            'GRD',       '+1 473',           1),
(                                  'Guadeloupe',             'GP',            'GLP',         '+590',           1),
(                                        'Guam',             'GU',            'GUM',       '+1 671',           1),
(                                   'Guatemala',             'GT',            'GTM',         '+502',           1),
(                                    'Guernsey',             'GG',            'GGY',     '+44 1481',           1),
(                                      'Guinea',             'GN',            'GIN',         '+224',           1),
(                               'Guinea-Bissau',             'GW',            'GNB',         '+245',           1),
(                                      'Guyana',             'GY',            'GUY',         '+592',           1),
(                                       'Haiti',             'HT',            'HTI',         '+509',           1),
(                  'Heard and McDonald Islands',             'HM',            'HMD',          '+61',           0),
(                                    'Honduras',             'HN',            'HND',         '+504',           1),
(                                   'Hong Kong',             'HK',            'HKG',         '+852',           1),
(                                     'Hungary',             'HU',            'HUN',          '+36',           1),
(                                     'Iceland',             'IS',            'ISL',         '+354',           1),
(                                       'India',             'IN',            'IND',          '+91',           1),
(                                   'Indonesia',             'ID',            'IDN',          '+62',           1),
(                                        'Iran',             'IR',            'IRN',          '+98',           1),
(                                        'Iraq',             'IQ',            'IRQ',         '+964',           1),
(                                     'Ireland',             'IE',            'IRL',         '+353',           1),
(                                 'Isle of Man',             'IM',            'IMN',     '+44 1624',           1),
(                                      'Israel',             'IL',            'ISR',         '+972',           1),
(                                       'Italy',             'IT',            'ITA',          '+39',           1),
(                                     'Jamaica',             'JM',            'JAM',       '+1 876',           1),
(                                       'Japan',             'JP',            'JPN',          '+81',           1),
(                                      'Jersey',             'JE',            'JEY',     '+44 1534',           1),
(                                      'Jordan',             'JO',            'JOR',         '+962',           1),
(                                  'Kazakhstan',             'KZ',            'KAZ',           '+7',           1),
(                                       'Kenya',             'KE',            'KEN',         '+254',           1),
(                                    'Kiribati',             'KI',            'KIR',         '+686',           1),
(                                      'Kosovo',             'KV',             'KV',         '+381',           1),
(                                      'Kuwait',             'KW',            'KWT',         '+965',           1),
(                                  'Kyrgyzstan',             'KG',            'KGZ',         '+996',           1),
(                                        'Laos',             'LA',            'LAO',         '+856',           1),
(                                      'Latvia',             'LV',            'LVA',         '+371',           1),
(                                     'Lebanon',             'LB',            'LBN',         '+961',           1),
(                                     'Lesotho',             'LS',            'LSO',         '+266',           1),
(                                     'Liberia',             'LR',            'LBR',         '+231',           1),
(                                       'Libya',             'LY',            'LBY',         '+218',           1),
(                               'Liechtenstein',             'LI',            'LIE',         '+423',           1),
(                                   'Lithuania',             'LT',            'LTU',         '+370',           1),
(                                  'Luxembourg',             'LU',            'LUX',         '+352',           1),
(                                       'Macau',             'MO',            'MAC',         '+853',           1),
(                                   'Macedonia',             'MK',            'MKD',         '+389',           1),
(                                  'Madagascar',             'MG',            'MDG',         '+261',           1),
(                                      'Malawi',             'MW',            'MWI',         '+265',           1),
(                                    'Malaysia',             'MY',            'MYS',          '+60',           1),
(                                    'Maldives',             'MV',            'MDV',         '+960',           1),
(                                        'Mali',             'ML',            'MLI',         '+223',           1),
(                                       'Malta',             'MT',            'MLT',         '+356',           1),
(                            'Marshall Islands',             'MH',            'MHL',         '+692',           1),
(                                  'Martinique',             'MQ',            'MTQ',         '+596',           1),
(                                  'Mauritania',             'MR',            'MRT',         '+222',           1),
(                                   'Mauritius',             'MU',            'MUS',         '+230',           1),
(                                     'Mayotte',             'YT',            'MYT',         '+262',           1),
(                                      'Mexico',             'MX',            'MEX',          '+52',           1),
(                                  'Micronesia',             'FM',            'FSM',         '+691',           1),
(                                     'Moldova',             'MD',            'MDA',         '+373',           1),
(                                      'Monaco',             'MC',            'MCO',         '+377',           1),
(                                    'Mongolia',             'MN',            'MNG',         '+976',           1),
(                                  'Montenegro',             'ME',            'MNE',         '+382',           1),
(                                  'Montserrat',             'MS',            'MSR',       '+1 664',           1),
(                                     'Morocco',             'MA',            'MAR',         '+212',           1),
(                                  'Mozambique',             'MZ',            'MOZ',         '+258',           1),
(                                     'Myanmar',             'MM',            'MMR',          '+95',           1),
(                                     'Namibia',             'NA',            'NAM',         '+264',           1),
(                                       'Nauru',             'NR',            'NRU',         '+674',           1),
(                                       'Nepal',             'NP',            'NPL',         '+977',           1),
(                                 'Netherlands',             'NL',            'NLD',          '+31',           1),
(                        'Netherlands Antilles',             'AN',            'ANT',         '+599',           1),
(                               'New Caledonia',             'NC',            'NCL',         '+687',           1),
(                                 'New Zealand',             'NZ',            'NZL',          '+64',           1),
(                                   'Nicaragua',             'NI',            'NIC',         '+505',           1),
(                                       'Niger',             'NE',            'NER',         '+227',           1),
(                                     'Nigeria',             'NG',            'NGA',         '+234',           1),
(                                        'Niue',             'NU',            'NIU',         '+683',           1),
(                              'Norfolk Island',             'NF',            'NFK',        '+6723',           1),
(                                 'North Korea',             'KP',            'PRK',         '+850',           1),
(                    'Northern Mariana Islands',             'MP',            'MNP',       '+1 670',           1),
(                                      'Norway',             'NO',            'NOR',          '+47',           1),
(                                        'Oman',             'OM',            'OMN',         '+968',           1),
(                                    'Pakistan',             'PK',            'PAK',          '+92',           1),
(                                       'Palau',             'PW',            'PLW',         '+680',           1),
(                                   'Palestine',             'PS',            'PSE',         '+970',           1),
(                                      'Panama',             'PA',            'PAN',         '+507',           1),
(                            'Papua New Guinea',             'PG',            'PNG',         '+675',           1),
(                                    'Paraguay',             'PY',            'PRY',         '+595',           1),
(                                        'Peru',             'PE',            'PER',          '+51',           1),
(                                 'Philippines',             'PH',            'PHL',          '+63',           1),
(                            'Pitcairn Islands',             'PN',            'PCN',         '+649',           1),
(                                      'Poland',             'PL',            'POL',          '+48',           1),
(                                    'Portugal',             'PT',            'PRT',         '+351',           1),
(                                 'Puerto Rico',             'PR',            'PRI',       '+1 787',           1),
(                                       'Qatar',             'QA',            'QAT',         '+974',           1),
(                       'Republic of the Congo',             'CG',            'COG',         '+242',           1),
(                                     'Reunion',             'RE',            'REU',         '+262',           1),
(                                     'Romania',             'RO',            'ROM',          '+40',           1),
(                                      'Russia',             'RU',            'RUS',           '+7',           1),
(                                      'Rwanda',             'RW',            'RWA',         '+250',           1),
(                                'Saint Helena',             'SH',            'SHN',         '+290',           1),
(                       'Saint Kitts and Nevis',             'KN',            'KNA',       '+1 869',           1),
(                                 'Saint Lucia',             'LC',            'LCA',       '+1 758',           1),
(                   'Saint Pierre and Miquelon',             'PM',            'SPM',         '+508',           1),
(            'Saint Vincent and the Grenadines',             'VC',            'VCT',       '+1 784',           1),
(                                       'Samoa',             'WS',            'WSM',         '+685',           1),
(                                  'San Marino',             'SM',            'SMR',         '+378',           1),
(                       'Sao Tome and Principe',             'ST',            'STP',         '+239',           1),
(                                'Saudi Arabia',             'SA',            'SAU',         '+966',           1),
(                                     'Senegal',             'SN',            'SEN',         '+221',           1),
(                                      'Serbia',             'RS',            'SRB',         '+381',           1),
(                                  'Seychelles',             'SC',            'SYC',         '+248',           1),
(                                'Sierra Leone',             'SL',            'SLE',         '+232',           1),
(                                   'Singapore',             'SG',            'SGP',          '+65',           1),
(                                'Sint Maarten',             'SX',            'SXM',       '+1 721',           1),
(                                    'Slovakia',             'SK',            'SVK',         '+421',           1),
(                                    'Slovenia',             'SI',            'SVN',         '+386',           1),
(                             'Solomon Islands',             'SB',            'SLB',         '+677',           1),
(                                     'Somalia',             'SO',            'SOM',         '+252',           1),
(                                'South Africa',             'ZA',            'ZAF',          '+27',           1),
('South Georgia and the South Sandwich Islands',             'GS',            'SGS',          '+44',           1),
(                                 'South Korea',             'KR',            'KOR',          '+82',           1),
(                                 'South Sudan',             'SS',            'SSD',         '+211',           1),
(                                       'Spain',             'ES',            'ESP',          '+34',           1),
(                                   'Sri Lanka',             'LK',            'LKA',          '+94',           1),
(                                       'Sudan',             'SD',            'SDN',         '+249',           1),
(                                    'Suriname',             'SR',            'SUR',         '+597',           1),
(              'Svalbard and Jan Mayen Islands',             'SJ',            'SJM',          '+47',           0),
(                                   'Swaziland',             'SZ',            'SWZ',         '+268',           1),
(                                      'Sweden',             'SE',            'SWE',          '+46',           1),
(                                 'Switzerland',             'CH',            'CHE',          '+41',           1),
(                                       'Syria',             'SY',            'SYR',         '+963',           1),
(                                      'Taiwan',             'TW',            'TWN',         '+886',           1),
(                                  'Tajikistan',             'TJ',            'TJK',         '+992',           1),
(                                    'Tanzania',             'TZ',            'TZA',         '+255',           1),
(                                    'Thailand',             'TH',            'THA',          '+66',           1),
(                                        'Togo',             'TG',            'TGO',         '+228',           1),
(                                     'Tokelau',             'TK',            'TKL',         '+690',           1),
(                                       'Tonga',             'TO',            'TON',         '+676',           1),
(                         'Trinidad and Tobago',             'TT',            'TTO',       '+1 868',           1),
(                                     'Tunisia',             'TN',            'TUN',         '+216',           1),
(                                      'Turkey',             'TR',            'TUR',          '+90',           1),
(                                'Turkmenistan',             'TM',            'TKM',         '+993',           1),
(                    'Turks and Caicos Islands',             'TC',            'TCA',       '+1 649',           1),
(                                      'Tuvalu',             'TV',            'TUV',         '+688',           1),
(                         'U.S. Virgin Islands',             'VI',            'VIR',       '+1 340',           1),
(                                      'Uganda',             'UG',            'UGA',         '+256',           1),
(                                     'Ukraine',             'UA',            'UKR',         '+380',           1),
(                        'United Arab Emirates',             'AE',            'ARE',         '+971',           1),
(                              'United Kingdom',             'GB',            'GBR',          '+44',           1),
(                               'United States',             'US',            'USA',           '+1',           1),
(                                     'Uruguay',             'UY',            'URY',         '+598',           1),
(                                  'Uzbekistan',             'UZ',            'UZB',         '+998',           1),
(                                     'Vanuatu',             'VU',            'VUT',         '+678',           1),
(                                'Vatican City',             'VA',            'VAT',         '+379',           1),
(                                   'Venezuela',             'VE',            'VEN',          '+58',           1),
(                                     'Vietnam',             'VN',            'VNM',          '+84',           1),
(                           'Wallis and Futuna',             'WF',            'WLF',         '+681',           1),
(                              'Western Sahara',             'EH',            'ESH',      '+212 28',           1),
(                                       'Yemen',             'YE',            'YEM',         '+967',           1),
(                                      'Zambia',             'ZM',            'ZMB',         '+260',           1),
(                                    'Zimbabwe',             'ZW',            'ZWE',         '+263',           1);

--
-- Dumping data for table `#__vikrestaurants_config` (GLOBAL)
--

INSERT INTO `#__vikrestaurants_config`
(`param`, `setting`) VALUES
-- Miscellaneous
(            'version', '1.5'),
(                'bcv', '1.5'),
(      'securehashkey',    ''),
('update_extra_fields',     0),
(    'exportresparams',  '{}'),
(        'firstconfig',     0),
(   'firstmediaconfig',     1),
(          'mediaprop',    ''),
(    'printorderstext',    ''),
(         'invoiceobj',    ''),
(          'stopuntil',    -1),
(        'tkstopuntil',    -1),
-- System
(         'restname', ''),
(      'companylogo', ''),
( 'enablerestaurant',  1),
(   'enabletakeaway',  1),
(    'multilanguage',  0),
(       'showfooter',  1),
(      'refreshdash', 30),
-- Date & Time
(  'dateformat', 'm/d/Y'),
(  'timeformat', 'h:i A'),
('opentimemode',       0),
(    'hourfrom',      14),
(      'hourto',      23),
-- Booking
(  'enablereg', 1),
('phoneprefix', 1),
-- E-mail
( 'adminemail', ''),
('senderemail', ''),
-- Currency
(    'currencysymb',   '€'),
(    'currencyname', 'EUR'),
(         'symbpos',     1),
(  'currdecimalsep',   '.'),
('currthousandssep',   ','),
(  'currdecimaldig',     2),
-- GDPR
(      'gdpr',  0),
('policylink', ''),
-- Google
(       'googleapikey', ''),
(    'googleapiplaces',  1),
('googleapidirections',  1),
( 'googleapistaticmap',  1),
-- Reviews
('enablereviews', 0),
( 'revleavemode', 1),
-- Reviews Comment
('revcommentreq',   0),
( 'revminlength',  48),
( 'revmaxlength', 512),
-- Reviews Publishing
(      'revlimlist', 5),
('revautopublished', 0),
(   'revlangfilter', 0),
-- Closing Days
('closingdays', '');

--
-- Dumping data for table `#__vikrestaurants_config` (RESTAURANT)
--

INSERT INTO `#__vikrestaurants_config`
(`param`, `setting`) VALUES
-- System
('ondashboard', 1),
-- Reservations
(      'defstatus', 'C'),
(    'selfconfirm',   0),
('averagetimestay',  60),
(    'tablocktime',  20),
(       'loginreq',   1),
-- Deposit
(   'askdeposit',  1),
(   'resdeposit', 10),
('costperperson',  1),
-- Cancellation
('enablecanc',      0),
('cancreason',      1),
(  'canctime',      2),
(  'cancunit', 'days'),
(  'cancmins',      0),
-- Date & Time
('minuteintervals', 30),
(      'bookrestr', 30),
(        'mindate',  0),
(        'maxdate',  0),
(      'resperint',  0),
(    'guestperint',  0),
-- People
('minimumpeople',  2),
('maximumpeople', 20),
('largepartylbl',  0),
('largepartyurl', ''),
-- Tables
('reservationreq', 1),
-- Safety
('safedistance', 0),
(  'safefactor', 2),
-- Food
(     'choosemenu',    0),
(      'orderfood',    0),
(       'editfood',    1),
(   'canclosebill',    1),
(  'servingnumber',    0),
('bill_items_auto', '[]'),
-- Taxes
(  'deftax', ''),
('usetaxbd',  0),
-- Reservations List Columns
('listablecols', 'id,sid,checkin_ts,people,tname,customer,mail,phone,info,deposit,billval,billclosed,rescode,status'),
-- Custom Fields
('listablecf', ''),
-- E-mail Notifications
( 'mailcustwhen',     '["C","P"]'),
( 'mailoperwhen', '["C","P","W"]'),
('mailadminwhen', '["C","P","W"]'),
-- E-mail Templates
(     'mailtmpl',     'customer_email_tmpl.php'),
('adminmailtmpl',        'admin_email_tmpl.php'),
( 'cancmailtmpl', 'cancellation_email_tmpl.php');

--
-- Dumping data for table `#__vikrestaurants_config` (TAKE-AWAY)
--

INSERT INTO `#__vikrestaurants_config`
(`param`, `setting`) VALUES
-- Orders
(  'tkdefstatus', 'C'),
('tkselfconfirm',   0),
(   'tklocktime',  15),
(   'tkloginreq',   1),
-- Cancellation
('tkenablecanc',      0),
('tkcancreason',      1),
(  'tkcanctime',      0),
(  'tkcancunit', 'days'),
(  'tkcancmins',      0),
-- Menus List
(    'tkshowimages',   1),
(     'tkshowtimes',   0),
(     'revtakeaway',   1),
('tkproddesclength', 256),
(          'tknote',  ''),
-- Date & Time
(   'tkminint', 15),
(  'asapafter', 30),
('tkallowdate',  1),
( 'tkwhenopen',  0),
( 'tkpreorder',  0),
(  'tkmindate',  0),
(  'tkmaxdate',  0),
-- Cart
('mincostperorder', 4.0),
(     'tkmaxitems', 100),
-- Availability
(     'tkordperint', 10),
(     'tkordmaxser',  1),
(     'mealsperint', 10),
('tkmealsbackslots',  2),
-- Food
( 'tkuseoverlay', 2),
('tkenablestock', 1),
-- Gratuities
('tkenablegratuity',      0),
(   'tkdefgratuity', '10:1'),
-- Delivery
('deliveryservice',   1),
(        'dsprice', 3.5),
(    'dspercentot',   2),
(   'freedelivery',  20),
-- Takeaway
(    'pickupprice', 0.0),
('pickuppercentot',   2),
-- Service
('tkdefaultservice', 'delivery'),
(    'tkservicetax',         ''),
-- Upselling
(         'enableupselling',    1),
(          'upselling_topn',    6),
('upselling_training_since',   ''),
(       'upselling_weights', '{}'),
-- Taxes
(  'tkdeftax', ''),
('tkusetaxbd',  0),
-- Reservations List Columns
('tklistablecols', 'id,sid,checkin_ts,delivery,customer,mail,phone,info,totpay,taxes,rescode,status'),
-- Custom Fields
('tklistablecf', ''),
-- E-mail Notifications
( 'tkmailcustwhen',     '["C","P"]'),
( 'tkmailoperwhen', '["C","P","W"]'),
('tkmailadminwhen', '["C","P","W"]'),
-- E-mail Templates
(      'tkmailtmpl',     'takeaway_customer_email_tmpl.php'),
( 'tkadminmailtmpl',        'takeaway_admin_email_tmpl.php'),
(  'tkcancmailtmpl', 'takeaway_cancellation_email_tmpl.php'),
('tkreviewmailtmpl',       'takeaway_review_email_tmpl.php'),
( 'tkstockmailtmpl',        'takeaway_stock_email_tmpl.php');

--
-- Dumping data for table `#__vikrestaurants_config` (APPLICATIONS)
--

INSERT INTO `#__vikrestaurants_config`
(`param`, `setting`) VALUES
-- API Settings
(      'apifw',  0),
( 'apilogmode',  1),
('apilogflush',  7),
( 'apimaxfail', 20),
-- SMS Provider
(          'smsapi', ''),
(      'smsapiwhen',  3),
(        'smsapito',  0),
('smsapiadminphone', ''),
-- SMS Driver Parameters
('smsapifields', ''),
-- SMS Templates
(   'smstextcust', ''),
(   'smstmplcust', ''),
(  'smstmpladmin', ''),
( 'smstmpltkcust', ''),
('smstmpltkadmin', ''),
-- Cron Jobs
('cron_secure_key', ''),
(  'cron_log_mode',  1),
( 'cron_log_flush', 30),
-- Customizer
('fields_layout_style', 'default'),
-- Backup
(  'backuptype', 'full'),
('backupfolder',     '');

--
-- Dumping data for table `#__vikrestaurants_config` (@deprecated)
--

INSERT INTO `#__vikrestaurants_config`
(`param`, `setting`) VALUES
(     'uiradio', 'ios'),
(  'taxesratio',   0.0),
(    'usetaxes',     0),
('tktaxesratio',   0.0),
(  'tkusetaxes',     0),
( 'tkshowtaxes',     0);