
--
-- Table structure for table `wpnk_term_relationships`
--

CREATE TABLE `wpnk_term_relationships` (
  `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `term_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`object_id`,`term_taxonomy_id`),
  KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpnk_term_relationships`
--

INSERT INTO `wpnk_term_relationships` VALUES (1,1,0),(28,2,0),(29,2,0),(30,2,0);

--
-- Table structure for table `wpnk_term_taxonomy`
--

CREATE TABLE `wpnk_term_taxonomy` (
  `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
  `count` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_taxonomy_id`),
  UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
  KEY `taxonomy` (`taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpnk_term_taxonomy`
--

INSERT INTO `wpnk_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'nav_menu','',0,3);

--
-- Table structure for table `wpnk_termmeta`
--

CREATE TABLE `wpnk_termmeta` (
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`meta_id`),
  KEY `term_id` (`term_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpnk_termmeta`
--


--
-- Table structure for table `wpnk_terms`
--

CREATE TABLE `wpnk_terms` (
  `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `term_group` bigint(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`term_id`),
  KEY `slug` (`slug`(191)),
  KEY `name` (`name`(191))
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpnk_terms`
--

INSERT INTO `wpnk_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Menu 1','menu-1',0);

--
-- Table structure for table `wpnk_usermeta`
--

CREATE TABLE `wpnk_usermeta` (
  `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
  PRIMARY KEY (`umeta_id`),
  KEY `user_id` (`user_id`),
  KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

--
-- Dumping data for table `wpnk_usermeta`
--

INSERT INTO `wpnk_usermeta` VALUES (1,1,'nickname','admin'),(2,1,'first_name',''),(3,1,'last_name',''),(4,1,'description',''),(5,1,'rich_editing','true'),(6,1,'syntax_highlighting','true'),(7,1,'comment_shortcuts','false'),(8,1,'admin_color','fresh'),(9,1,'use_ssl','0'),(10,1,'show_admin_bar_front','true'),(11,1,'locale',''),(12,1,'wpnk_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(13,1,'wpnk_user_level','10'),(14,1,'dismissed_wp_pointers',''),(15,1,'show_welcome_panel','1'),(16,1,'session_tokens','a:30:{s:64:\"65d98c60823fb39a945e31110b49370ec2186413fe85ebe4e24a3c9b7a2bf2e7\";a:4:{s:10:\"expiration\";i:1637845471;s:2:\"ip\";s:15:\"174.248.145.204\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637672671;}s:64:\"b722020a71c60ece9c286cc0f16263bb3efc3923d700dfb08da3c95dafaa865e\";a:4:{s:10:\"expiration\";i:1637849064;s:2:\"ip\";s:15:\"174.248.145.204\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637676264;}s:64:\"6ec6b6e192e7b12b2114d0b6931e9699d80312c084c36b678724a807722c37d3\";a:4:{s:10:\"expiration\";i:1637850471;s:2:\"ip\";s:15:\"174.248.145.204\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637677671;}s:64:\"0c10996f4e312bad97ffeee5a71528e9719eca5bab2f05dca2990d36129ad608\";a:4:{s:10:\"expiration\";i:1637861618;s:2:\"ip\";s:15:\"174.248.145.204\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637688818;}s:64:\"39a877e26d9801750f7276d749ff10b39e542ba9f6212815a23eaa1fdd01d1d3\";a:4:{s:10:\"expiration\";i:1637935659;s:2:\"ip\";s:15:\"174.248.145.204\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637762859;}s:64:\"b44956aa6a7a42a9848b6eab34d2e83df5557b758ffce9d8714f610359f7b70d\";a:4:{s:10:\"expiration\";i:1637956857;s:2:\"ip\";s:15:\"174.248.145.204\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637784057;}s:64:\"7293c2ab722290fe775f2122862571046824b56d574bf0928b7315383a0bbc41\";a:4:{s:10:\"expiration\";i:1637973573;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637800773;}s:64:\"317955bf60c36694c22549eedf669ad56d875f5c29709b85b04cb55db672b6e9\";a:4:{s:10:\"expiration\";i:1637973946;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637801146;}s:64:\"514c24854e06aadc86c3651034cac1422a0753aa14b1710af688b1517694e1ba\";a:4:{s:10:\"expiration\";i:1637976817;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637804017;}s:64:\"7eb88e3c9b54710c785fd4d2c559d3abb1039ee97f81850d64182c64e89ed4ae\";a:4:{s:10:\"expiration\";i:1637977951;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637805151;}s:64:\"5c711e1ca7cf003edaa8170f96fb79d430affb726ac5926754e23957d0ed6d38\";a:4:{s:10:\"expiration\";i:1637982071;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809271;}s:64:\"9a86b6386a25975cacbafd16cf446b8ebc55f19b3e037cf92a5662c1ee9cb747\";a:4:{s:10:\"expiration\";i:1639018889;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809289;}s:64:\"1a5b97f9fcc3ac7869435d70e42f8478abeca2a71e02ee8782d2e018c7ab5eb4\";a:4:{s:10:\"expiration\";i:1639018917;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809317;}s:64:\"a3c3babc470a9811fb10c44b405b3863792cbfb05ccd64a58ed8679fd8592937\";a:4:{s:10:\"expiration\";i:1637982288;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809488;}s:64:\"0d69be9face40095ad0d0c4ada38eb245cd6cca38ff0e08a0a4e17fa89ec0a39\";a:4:{s:10:\"expiration\";i:1639019100;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809500;}s:64:\"34b9d7909ef37951fffc1a5df5003fa3c3133ad722b5b52430a884884c432160\";a:4:{s:10:\"expiration\";i:1639019247;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809647;}s:64:\"3af1d7df9479fa3148a4c7e17ccd144a4e08f12537b01773f74b4775cf8585c3\";a:4:{s:10:\"expiration\";i:1637982476;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809676;}s:64:\"f1509e5d6c5816a599d834193c455f820011138709068f321381b29b0ff47581\";a:4:{s:10:\"expiration\";i:1637982532;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809732;}s:64:\"7ead70c3e03de973a3a6dc33793938cd734a9ef3e67fb25cdef5011b0ede836f\";a:4:{s:10:\"expiration\";i:1637982553;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637809753;}s:64:\"edc345837e8f749c170302092b702955639350b77a69ee8d2632240dfbb71ce7\";a:4:{s:10:\"expiration\";i:1637983141;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637810341;}s:64:\"5c8bf2e0938b0753d807bf28e9525f2f48fd1682b0340e8e3dd2bceb6e1cd88e\";a:4:{s:10:\"expiration\";i:1637983495;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637810695;}s:64:\"c00b2ca9a4633023e39b39d29a07853eaf616bded52cc67d09015126997534d2\";a:4:{s:10:\"expiration\";i:1637983525;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637810725;}s:64:\"64c9134b10cb52a78cf288e69fd2ddd904b7eca84e3fc20b051b2795a7831f0e\";a:4:{s:10:\"expiration\";i:1637984564;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637811764;}s:64:\"7c50091d9c4f99507c1e7e6bf70d5505024630889223272ad95fd610a95579ea\";a:4:{s:10:\"expiration\";i:1637984576;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637811776;}s:64:\"935610136f793c2153b144cbf708450e6fac0caa74a9ce13435c9955cf609f20\";a:4:{s:10:\"expiration\";i:1637984631;s:2:\"ip\";s:14:\"174.248.150.83\";s:2:\"ua\";s:114:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.45 Safari/537.36\";s:5:\"login\";i:1637811831;}s:64:\"edafe4a89a1627f7318f08de16ae1885192264b33c0a529f22d527527cba7311\";a:4:{s:10:\"expiration\";i:1637984897;s:2:\"ip\";s:11:\"10.10.10.10\";s:2:\"ua\";s:77:\"Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0\";s:5:\"login\";i:1637812097;}s:64:\"4769a8a0bfa68c5399427eb2fd4699c17e0d64583c392e394e0e2535aa86938d\";a:4:{s:10:\"expiration\";i:1637984945;s:2:\"ip\";s:11:\"10.10.10.10\";s:2:\"ua\";s:77:\"Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0\";s:5:\"login\";i:1637812145;}s:64:\"fdb84c5eeef0c84528600499145f260b491d089cc42aef18389c141a1aa3e137\";a:4:{s:10:\"expiration\";i:1637984969;s:2:\"ip\";s:11:\"10.10.10.10\";s:2:\"ua\";s:77:\"Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0\";s:5:\"login\";i:1637812169;}s:64:\"fccadf5ab65703a6ca2c532604b82281533ee4d5f79cedd2ba58a324bd949a3e\";a:4:{s:10:\"expiration\";i:1637985042;s:2:\"ip\";s:11:\"10.10.10.10\";s:2:\"ua\";s:77:\"Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0\";s:5:\"login\";i:1637812242;}s:64:\"6430a4bf16441aadb8c656658027dd4767f20b474c89d1ef40f6cdcf20c39bf4\";a:4:{s:10:\"expiration\";i:1637985054;s:2:\"ip\";s:11:\"10.10.10.10\";s:2:\"ua\";s:77:\"Mozilla/5.0 (Windows NT 6.2; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0\";s:5:\"login\";i:1637812254;}}'),(17,1,'wpnk_dashboard_quick_press_last_post_id','4'),(18,1,'community-events-location','a:1:{s:2:\"ip\";s:13:\"174.248.145.0\";}'),(19,2,'nickname','staff'),(20,2,'first_name','Joalize'),(21,2,'last_name','Troffer'),(22,2,'description',''),(23,2,'rich_editing','true'),(24,2,'syntax_highlighting','true'),(25,2,'comment_shortcuts','false'),(26,2,'admin_color','fresh'),(27,2,'use_ssl','0'),(28,2,'show_admin_bar_front','true'),(29,2,'locale',''),(30,2,'wpnk_capabilities','a:1:{s:5:\"staff\";b:1;}'),(31,2,'wpnk_user_level','0'),(32,2,'dismissed_wp_pointers',''),(40,2,'session_tokens','a:1:{s:64:\"5e4c32d7ab7a9051eabbbf96378605d8281040e93880c8d7cb956afd763360c9\";a:4:{s:10:\"expiration\";i:1637869663;s:2:\"ip\";s:15:\"174.248.145.204\";s:2:\"ua\";s:131:\"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36 Edg/95.0.1020.44\";s:5:\"login\";i:1637696863;}}'),(35,1,'vikappointments_rss_display_dashboard','1'),(36,2,'community-events-location','a:1:{s:2:\"ip\";s:13:\"174.248.145.0\";}'),(37,1,'vikappointments_rss_optin','0'),(39,2,'vikappointments_rss_optin','0');

--
-- Table structure for table `wpnk_vikappointments_api_ban`
--

CREATE TABLE `wpnk_vikappointments_api_ban` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(24) DEFAULT '',
  `fail_count` int(4) DEFAULT '0',
  `last_update` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_api_ban`
--


--
-- Table structure for table `wpnk_vikappointments_api_login`
--

CREATE TABLE `wpnk_vikappointments_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` datetime DEFAULT NULL,
  `denied` varchar(256) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_api_login`
--


--
-- Table structure for table `wpnk_vikappointments_api_login_event_options`
--

CREATE TABLE `wpnk_vikappointments_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 COMMENT 'JSON configuration for event/user relation',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_api_login_event_options`
--


--
-- Table structure for table `wpnk_vikappointments_api_login_logs`
--

CREATE TABLE `wpnk_vikappointments_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,
  `ip` varchar(24) DEFAULT '',
  `createdon` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_api_login_logs`
--


--
-- Table structure for table `wpnk_vikappointments_cf_service_assoc`
--

CREATE TABLE `wpnk_vikappointments_cf_service_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_field` int(10) unsigned NOT NULL,
  `id_service` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_cf_service_assoc`
--


--
-- Table structure for table `wpnk_vikappointments_cities`
--

CREATE TABLE `wpnk_vikappointments_cities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_state` int(10) unsigned NOT NULL DEFAULT '0',
  `city_name` varchar(64) NOT NULL,
  `city_2_code` char(2) NOT NULL,
  `city_3_code` char(3) DEFAULT '',
  `longitude` decimal(11,8) DEFAULT NULL,
  `latitude` decimal(11,8) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_cities`
--


--
-- Table structure for table `wpnk_vikappointments_config`
--

CREATE TABLE `wpnk_vikappointments_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 AUTO_INCREMENT=172 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_config`
--

INSERT INTO `wpnk_vikappointments_config` VALUES (1,'version','1.2.1'),(2,'bcv','1.2.1'),(3,'subversion','0'),(4,'securehashkey',''),(5,'findresmode','1'),(6,'update_extra_fields','0'),(7,'exportresparams','{}'),(8,'agencyname','Salon Booking'),(9,'companylogo',''),(10,'ismultilang','0'),(11,'askconfirm','1'),(12,'router','0'),(13,'showfooter','0'),(14,'googleapikey',''),(15,'sitetheme','light'),(16,'refreshtime','30'),(17,'dateformat','m/d/Y'),(18,'timeformat','h:i A'),(19,'formatduration','1'),(20,'minuteintervals','30'),(21,'openingtime','8:30'),(22,'closingtime','19:0'),(23,'minrestr','30'),(24,'mindate','0'),(25,'maxdate','0'),(26,'keepapplock','15'),(27,'showphprefix','0'),(28,'conversion_track','0'),(29,'calendarlayout','calendar'),(30,'calendarlayoutsite','monthly'),(31,'calendarweekdays','5'),(32,'numcals','3'),(33,'nummonths','6'),(34,'calsfrom','1'),(35,'calsfromyear','2021'),(36,'legendcal','1'),(37,'firstday','0'),(38,'gdpr','0'),(39,'policylink','https://thelocalshopper.net/salonbooking/?page_id=3'),(40,'multitimezone','0'),(41,'synckey','CD9EES334J40'),(42,'zipcfid','0'),(43,'zipcodes','[]'),(44,'listablecols','id,sid,checkin_ts,checkout,employee,service,info,nominative,mail,phone,total,status'),(45,'listablecf',''),(46,'adminemail','info@thelocalshopper.net'),(47,'senderemail','info@thelocalshopper.net'),(48,'mailcustwhen','[\"C\",\"P\"]'),(49,'mailempwhen','[\"C\",\"P\"]'),(50,'mailadminwhen','[\"C\",\"P\",\"W\"]'),(51,'mailtmpl','customer_email_tmpl.php'),(52,'adminmailtmpl','admin_email_tmpl.php'),(53,'empmailtmpl','employee_email_tmpl.php'),(54,'cancmailtmpl','cancellation_email_tmpl.php'),(55,'mailattach','[]'),(56,'icsattach','0;0;0'),(57,'csvattach','0;0;0'),(58,'currencysymb','$'),(59,'currencyname','USD'),(60,'currsymbpos','2'),(61,'currdecimalsep','.'),(62,'currthousandssep',','),(63,'currdecimaldig','2'),(64,'defstatus','C'),(65,'showcheckout','0'),(66,'loginreq','0'),(67,'printorders','1'),(68,'invoiceorders','0'),(69,'showcountdown','1'),(70,'enablecart','0'),(71,'maxcartsize','-1'),(72,'cartallowsync','0'),(73,'shoplink','0'),(74,'shoplinkcustom',''),(75,'confcartdisplay','1'),(76,'enablecanc','0'),(77,'canctime','2'),(78,'usercredit','0'),(79,'usedeposit','0'),(80,'depositafter','300'),(81,'depositvalue','40'),(82,'deposittype','1'),(83,'enablewaitlist','0'),(84,'waitlistsmscont','[{\"en-US\":null},{\"en-US\":null}]'),(85,'waitlistmailtmpl','waitlist_email_tmpl.php'),(86,'enablerecur','0'),(87,'repeatbyrecur','0;1;1;0;0'),(88,'minamountrecur','1'),(89,'maxamountrecur','12'),(90,'fornextrecur','1;1;1'),(91,'enablereviews','0'),(92,'revservices','0'),(93,'revemployees','0'),(94,'revcommentreq','0'),(95,'revminlength',''),(96,'revmaxlength',''),(97,'revlimlist','5'),(98,'revlangfilter','0'),(99,'revautopublished','0'),(100,'revloadmode','1'),(101,'enablepackages','0'),(102,'packsperrow','3'),(103,'maxpackscart','-1'),(104,'packsreguser','0'),(105,'packsmandatory','0'),(106,'packmailtmpl','packages_email_tmpl.php'),(107,'subscrreguser','0'),(108,'subscrmandatory','0'),(109,'subscrthreshold','0'),(110,'deftax','0'),(111,'usetaxbd','0'),(112,'invoiceobj','{\"params\":{\"number\":2,\"suffix\":\"2021\",\"datetype\":1,\"date\":null,\"legalinfo\":\"\",\"sendinvoice\":0},\"constraints\":{\"pageOrientation\":\"P\",\"unit\":\"mm\",\"pageFormat\":\"A4\",\"margins\":{\"top\":10,\"bottom\":10,\"right\":10,\"left\":10,\"header\":5,\"footer\":5},\"imageScaleRatio\":1.25,\"font\":\"courier\",\"fontSizes\":{\"header\":10,\"body\":10,\"footer\":10},\"headerTitle\":null,\"showFooter\":false}}'),(113,'emplistlim','10'),(114,'emplistmode','{\"1\":\"1\",\"2\":\"1\",\"3\":\"1\",\"4\":\"1\",\"5\":\"1\",\"6\":\"1\",\"7\":\"1\",\"8\":\"1\"}'),(115,'empdesclength','1024'),(116,'emplinkhref','1'),(117,'empgroupfilter','1'),(118,'empordfilter','1'),(119,'empajaxsearch','0'),(120,'serdesclength','256'),(121,'serlinkhref','1'),(122,'oriwres','256'),(123,'orihres','256'),(124,'smallwres','128'),(125,'smallhres','128'),(126,'isresize','0'),(127,'isconfig','1'),(128,'empsignup','0'),(129,'empsignstatus','1'),(130,'empsignrule','3'),(131,'empassignser',''),(132,'empcreate','0'),(133,'empmaxser','5'),(134,'empattachser','1'),(135,'empmanageser','1'),(136,'empmanagerate','0'),(137,'empremove','0'),(138,'empmanage','1'),(139,'empmanagewd','1'),(140,'empmanageloc','1'),(141,'empmanagepay','1'),(142,'empmanagecoupon','0'),(143,'empmanagecustfield','0'),(144,'emprescreate','1'),(145,'empresmanage','1'),(146,'empresremove','0'),(147,'empresnotify','1'),(148,'empresconfirm','1'),(149,'closingdays',''),(150,'closingperiods',''),(151,'smsapi',''),(152,'smsenabled','0'),(153,'smsapito','1,1,0'),(154,'smsapiadminphone',''),(155,'smsapifields',''),(156,'smstextcust',''),(157,'smstmplcust',''),(158,'smstmplcustmulti',''),(159,'smstmpladmin',''),(160,'smstmpladminmulti',''),(161,'cron_secure_key','CD9EES334J40'),(162,'cron_log_mode','1'),(163,'apifw','0'),(164,'apilogmode','1'),(165,'apilogflush','7'),(166,'apimaxfail','20'),(167,'webhooksmaxfail','5'),(168,'webhooksuselog','1'),(169,'webhookslogspath',''),(170,'webhooksgroup','day'),(171,'multilanguage','0');

--
-- Table structure for table `wpnk_vikappointments_conversion`
--

CREATE TABLE `wpnk_vikappointments_conversion` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(128) DEFAULT '',
  `published` tinyint(1) DEFAULT '0',
  `statuses` varchar(512) DEFAULT '[]' COMMENT 'a JSON string containing all the supported statuses',
  `jsfile` varchar(256) DEFAULT '',
  `snippet` text,
  `page` varchar(48) DEFAULT '' COMMENT 'to which page it refers',
  `type` varchar(48) DEFAULT '' COMMENT 'to which table it refers',
  `createdon` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_conversion`
--


--
-- Table structure for table `wpnk_vikappointments_countries`
--

CREATE TABLE `wpnk_vikappointments_countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country_name` varchar(48) NOT NULL,
  `country_2_code` char(2) NOT NULL,
  `country_3_code` char(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 AUTO_INCREMENT=248 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_countries`
--

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

--
-- Table structure for table `wpnk_vikappointments_coupon`
--

CREATE TABLE `wpnk_vikappointments_coupon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(32) NOT NULL,
  `type` tinyint(2) NOT NULL DEFAULT '1',
  `percentot` tinyint(2) NOT NULL DEFAULT '2',
  `value` decimal(10,2) NOT NULL DEFAULT '0.00',
  `mincost` decimal(10,2) NOT NULL DEFAULT '0.00',
  `pubmode` tinyint(1) DEFAULT '1' COMMENT '1 to consider publishing on current date, 2 for checkin date',
  `dstart` datetime DEFAULT NULL,
  `dend` datetime DEFAULT NULL,
  `lastminute` int(4) DEFAULT '0',
  `max_quantity` int(8) DEFAULT '1',
  `used_quantity` int(8) DEFAULT '0',
  `maxperuser` int(6) unsigned DEFAULT '0',
  `applicable` varchar(16) DEFAULT NULL COMMENT 'the group to which the coupon is applicable',
  `remove_gift` tinyint(1) DEFAULT '0',
  `notes` varchar(512) DEFAULT '',
  `id_group` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_coupon`
--


--
-- Table structure for table `wpnk_vikappointments_coupon_employee_assoc`
--

CREATE TABLE `wpnk_vikappointments_coupon_employee_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_employee` int(10) unsigned NOT NULL,
  `id_coupon` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_coupon_employee_assoc`
--


--
-- Table structure for table `wpnk_vikappointments_coupon_group`
--

CREATE TABLE `wpnk_vikappointments_coupon_group` (
  `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;

--
-- Dumping data for table `wpnk_vikappointments_coupon_group`
--


--
-- Table structure for table `wpnk_vikappointments_coupon_service_assoc`
--

CREATE TABLE `wpnk_vikappointments_coupon_service_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_service` int(10) unsigned NOT NULL,
  `id_coupon` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_coupon_service_assoc`
--


--
-- Table structure for table `wpnk_vikappointments_cronjob`
--

CREATE TABLE `wpnk_vikappointments_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,
  `createdon` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_cronjob`
--


--
-- Table structure for table `wpnk_vikappointments_cronjob_log`
--

CREATE TABLE `wpnk_vikappointments_cronjob_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` text NOT 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;

--
-- Dumping data for table `wpnk_vikappointments_cronjob_log`
--


--
-- Table structure for table `wpnk_vikappointments_cust_mail`
--

CREATE TABLE `wpnk_vikappointments_cust_mail` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `position` varchar(128) DEFAULT '',
  `status` varchar(16) DEFAULT '',
  `tag` varchar(8) NOT NULL,
  `content` text,
  `file` varchar(128) DEFAULT '',
  `published` tinyint(1) DEFAULT '1',
  `id_service` int(10) unsigned DEFAULT '0',
  `id_employee` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_cust_mail`
--


--
-- Table structure for table `wpnk_vikappointments_custfields`
--

CREATE TABLE `wpnk_vikappointments_custfields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `formname` varchar(32) DEFAULT '',
  `description` varchar(2048) DEFAULT NULL,
  `type` varchar(64) NOT NULL DEFAULT 'text',
  `choose` text,
  `multiple` tinyint(1) DEFAULT '0',
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `ordering` int(10) NOT NULL DEFAULT '1',
  `rule` varchar(32) DEFAULT '0',
  `poplink` varchar(256) DEFAULT NULL,
  `locale` varchar(8) DEFAULT '*',
  `repeat` tinyint(1) unsigned DEFAULT '0' COMMENT 'repeat for each attendee',
  `id_employee` int(10) DEFAULT '-1',
  `group` tinyint(1) DEFAULT '0' COMMENT '0 for shop, 1 for employees registration',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_custfields`
--

INSERT INTO `wpnk_vikappointments_custfields` VALUES (1,'CUSTOMF_NAME','',NULL,'text','',0,1,1,'nominative',NULL,'*',0,-1,0),(2,'CUSTOMF_LNAME','',NULL,'text','',0,1,2,'nominative',NULL,'*',0,-1,0),(3,'CUSTOMF_EMAIL','',NULL,'text','',0,1,3,'email',NULL,'*',0,-1,0),(4,'CUSTOMF_PHONE','',NULL,'text','US',0,0,4,'phone',NULL,'*',0,-1,0),(5,'I read and accept the terms and conditions','',NULL,'checkbox',NULL,0,1,5,'0','https://thelocalshopper.net/salonbooking/?page_id=3','*',0,-1,0);

--
-- Table structure for table `wpnk_vikappointments_emp_worktime`
--

CREATE TABLE `wpnk_vikappointments_emp_worktime` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_employee` int(10) NOT NULL,
  `id_service` int(10) DEFAULT '-1',
  `day` int(2) NOT NULL,
  `fromts` int(6) NOT NULL,
  `endts` int(6) NOT NULL,
  `ts` int(12) DEFAULT '-1',
  `tsdate` date DEFAULT NULL COMMENT 'Y-m-d format of ts in UTC',
  `closed` tinyint(1) NOT NULL DEFAULT '0',
  `id_location` int(10) DEFAULT '-1',
  `parent` int(10) DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_emp_worktime`
--

INSERT INTO `wpnk_vikappointments_emp_worktime` VALUES (1,1,-1,1,480,1140,-1,'0000-00-00',0,-1,-1),(2,1,1,1,480,1140,-1,'0000-00-00',0,-1,1),(3,1,-1,2,480,1020,-1,'0000-00-00',0,-1,-1),(4,1,1,2,480,1020,-1,'0000-00-00',0,-1,3),(5,1,-1,3,480,780,-1,'0000-00-00',0,-1,-1),(6,1,1,3,480,780,-1,'0000-00-00',0,-1,5),(7,1,-1,4,480,1140,-1,'0000-00-00',0,-1,-1),(8,1,1,4,480,1140,-1,'0000-00-00',0,-1,7),(9,1,-1,5,480,1140,-1,'0000-00-00',0,-1,-1),(10,1,1,5,480,1140,-1,'0000-00-00',0,-1,9),(11,1,-1,6,480,780,-1,'0000-00-00',0,-1,-1),(12,1,1,6,480,780,-1,'0000-00-00',0,-1,11),(13,1,-1,0,0,0,-1,'0000-00-00',1,-1,-1),(14,1,1,0,0,0,-1,'0000-00-00',1,-1,13),(15,2,-1,1,480,780,-1,NULL,0,-1,-1),(16,2,-1,2,480,780,-1,NULL,0,-1,-1),(17,2,-1,3,480,780,-1,NULL,0,-1,-1),(18,2,-1,4,480,780,-1,NULL,0,-1,-1),(19,2,-1,5,480,780,-1,NULL,0,-1,-1),(20,2,-1,6,480,780,-1,NULL,0,-1,-1),(21,2,-1,0,0,0,-1,NULL,1,-1,-1),(22,2,2,1,480,780,-1,'0000-00-00',0,-1,15),(23,2,2,2,480,780,-1,'0000-00-00',0,-1,16),(24,2,2,3,480,780,-1,'0000-00-00',0,-1,17),(25,2,2,4,480,780,-1,'0000-00-00',0,-1,18),(26,2,2,5,480,780,-1,'0000-00-00',0,-1,19),(27,2,2,6,480,780,-1,'0000-00-00',0,-1,20),(28,2,2,0,0,0,-1,'0000-00-00',1,-1,21),(29,3,-1,1,480,780,-1,NULL,0,-1,-1),(30,3,3,1,480,780,-1,NULL,0,-1,29),(31,3,-1,2,480,780,-1,NULL,0,-1,-1),(32,3,3,2,480,780,-1,NULL,0,-1,31),(33,3,-1,3,480,780,-1,NULL,0,-1,-1),(34,3,3,3,480,780,-1,NULL,0,-1,33),(35,3,-1,5,480,780,-1,NULL,0,-1,-1),(36,3,3,5,480,780,-1,NULL,0,-1,35);

--
-- Table structure for table `wpnk_vikappointments_employee`
--

CREATE TABLE `wpnk_vikappointments_employee` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `firstname` varchar(128) NOT NULL,
  `lastname` varchar(128) NOT NULL,
  `nickname` varchar(128) NOT NULL,
  `alias` varchar(128) NOT NULL,
  `email` varchar(128) DEFAULT '',
  `notify` tinyint(1) NOT NULL DEFAULT '0',
  `showphone` tinyint(1) NOT NULL DEFAULT '0',
  `quick_contact` tinyint(1) NOT NULL DEFAULT '0',
  `listable` tinyint(1) NOT NULL DEFAULT '1',
  `phone` varchar(32) DEFAULT '',
  `image` varchar(128) DEFAULT '',
  `note` text,
  `synckey` varchar(32) DEFAULT 'secret',
  `jid` int(10) DEFAULT '-1',
  `id_group` int(10) DEFAULT '-1',
  `active_to` int(12) DEFAULT '-1',
  `active_to_date` datetime DEFAULT NULL,
  `active_since` datetime DEFAULT NULL,
  `timezone` varchar(32) DEFAULT '',
  `billing_json` varchar(2048) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_employee`
--

INSERT INTO `wpnk_vikappointments_employee` VALUES (1,'Joalize','Troffer','Joalize Troffer','joalize-troffer','support@theartgangster.com',1,1,0,1,'+1 (574) 386-3345','1employee.jpg','','MF8NTF13MZY5',0,2,-1,'0000-00-00 00:00:00',NULL,'',''),(2,'Liz','McNeil','Liz McNeil','liz-mcneil','info@myrvbuddy.com',1,1,0,1,'+1 (574) 386-3345','best-skincare-products-from-experts-292898-1619401893713-image.700x0c.jpg','','YH6ESZ2Z18Q1',0,1,-1,'0000-00-00 00:00:00',NULL,'',''),(3,'Rachael','Hansen','Rachael Hansen','rachael-hansen','info@myrvbuddy.com',1,1,1,1,'+1 (574) 386-3345','massagegirl.jpg','','0O23932JOX5Y',0,3,-1,'0000-00-00 00:00:00',NULL,'','');

--
-- Table structure for table `wpnk_vikappointments_employee_group`
--

CREATE TABLE `wpnk_vikappointments_employee_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` text,
  `ordering` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_employee_group`
--

INSERT INTO `wpnk_vikappointments_employee_group` VALUES (1,'Skin Care',NULL,1),(2,'Hair Stylist',NULL,2),(3,'Massage Therapist',NULL,3);

--
-- Table structure for table `wpnk_vikappointments_employee_location`
--

CREATE TABLE `wpnk_vikappointments_employee_location` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) DEFAULT '',
  `id_employee` int(10) DEFAULT '-1',
  `id_country` int(10) DEFAULT '-1',
  `id_state` int(10) DEFAULT '-1',
  `id_city` int(10) DEFAULT '-1',
  `address` varchar(64) DEFAULT '',
  `zip` varchar(8) DEFAULT '',
  `longitude` decimal(11,8) DEFAULT NULL,
  `latitude` decimal(11,8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_employee_location`
--


--
-- Table structure for table `wpnk_vikappointments_employee_settings`
--

CREATE TABLE `wpnk_vikappointments_employee_settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_employee` int(10) unsigned NOT NULL,
  `listlimit` int(3) unsigned DEFAULT '5',
  `listposition` tinyint(1) unsigned DEFAULT '1',
  `listordering` varchar(4) DEFAULT 'ASC',
  `numcals` int(2) unsigned DEFAULT '6',
  `firstmonth` int(2) DEFAULT '-1',
  `zipcodes` varchar(2048) DEFAULT '',
  `zip_field_id` int(10) DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_employee_settings`
--


--
-- Table structure for table `wpnk_vikappointments_gpayments`
--

CREATE TABLE `wpnk_vikappointments_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',
  `appointments` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'allowed for appointments purchases',
  `subscr` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'allowed for packages and subscriptions',
  `prenote` text,
  `note` text,
  `charge` decimal(8,4) DEFAULT '0.0000',
  `id_tax` int(10) unsigned DEFAULT '0',
  `setconfirmed` tinyint(1) NOT NULL DEFAULT '0',
  `icontype` tinyint(1) DEFAULT '0',
  `icon` varchar(128) DEFAULT '',
  `position` varchar(64) DEFAULT '',
  `level` tinyint(1) DEFAULT '1' COMMENT 'the access view level',
  `id_employee` int(10) unsigned DEFAULT '0',
  `createdby` int(10) unsigned NOT NULL DEFAULT '0',
  `params` varchar(512) DEFAULT NULL,
  `ordering` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_gpayments`
--


--
-- Table structure for table `wpnk_vikappointments_group`
--

CREATE TABLE `wpnk_vikappointments_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` text,
  `ordering` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_group`
--

INSERT INTO `wpnk_vikappointments_group` VALUES (1,'Hair Stylist','',1),(2,'Skin Care','',2),(3,'Massage','',3),(4,'Nails','',4);

--
-- Table structure for table `wpnk_vikappointments_invoice`
--

CREATE TABLE `wpnk_vikappointments_invoice` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_order` int(10) unsigned NOT NULL,
  `inv_number` varchar(32) NOT NULL,
  `inv_date` datetime NOT NULL,
  `file` varchar(32) NOT NULL,
  `createdon` datetime NOT NULL,
  `group` varchar(48) DEFAULT 'appointments',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_invoice`
--

INSERT INTO `wpnk_vikappointments_invoice` VALUES (1,2,'1/2021','2021-11-23 17:36:25','2-6K026OY0CEU8ANWT.pdf','2021-11-23 17:36:25','appointments');

--
-- Table structure for table `wpnk_vikappointments_lang_customf`
--

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

--
-- Dumping data for table `wpnk_vikappointments_lang_customf`
--


--
-- Table structure for table `wpnk_vikappointments_lang_empgroup`
--

CREATE TABLE `wpnk_vikappointments_lang_empgroup` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` text,
  `tag` varchar(8) NOT NULL,
  `id_empgroup` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_empgroup`
--


--
-- Table structure for table `wpnk_vikappointments_lang_employee`
--

CREATE TABLE `wpnk_vikappointments_lang_employee` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nickname` varchar(128) NOT NULL,
  `alias` varchar(128) DEFAULT NULL,
  `note` text,
  `tag` varchar(8) NOT NULL,
  `id_employee` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_employee`
--


--
-- Table structure for table `wpnk_vikappointments_lang_group`
--

CREATE TABLE `wpnk_vikappointments_lang_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` text,
  `tag` varchar(8) NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_group`
--


--
-- Table structure for table `wpnk_vikappointments_lang_option`
--

CREATE TABLE `wpnk_vikappointments_lang_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` varchar(1024) DEFAULT '',
  `tag` varchar(8) NOT NULL,
  `id_option` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_option`
--


--
-- Table structure for table `wpnk_vikappointments_lang_option_group`
--

CREATE TABLE `wpnk_vikappointments_lang_option_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` varchar(1024) DEFAULT '',
  `tag` varchar(8) NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_option_group`
--


--
-- Table structure for table `wpnk_vikappointments_lang_option_value`
--

CREATE TABLE `wpnk_vikappointments_lang_option_value` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `tag` varchar(8) NOT NULL,
  `id_variation` int(10) unsigned NOT NULL,
  `id_parent` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_option_value`
--


--
-- Table structure for table `wpnk_vikappointments_lang_package`
--

CREATE TABLE `wpnk_vikappointments_lang_package` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` text,
  `tag` varchar(8) NOT NULL,
  `id_package` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_package`
--


--
-- Table structure for table `wpnk_vikappointments_lang_package_group`
--

CREATE TABLE `wpnk_vikappointments_lang_package_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  `description` text,
  `tag` varchar(8) NOT NULL,
  `id_package_group` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_package_group`
--


--
-- Table structure for table `wpnk_vikappointments_lang_payment`
--

CREATE TABLE `wpnk_vikappointments_lang_payment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `prenote` text,
  `note` text,
  `tag` varchar(8) NOT NULL,
  `id_payment` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_payment`
--


--
-- Table structure for table `wpnk_vikappointments_lang_service`
--

CREATE TABLE `wpnk_vikappointments_lang_service` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `alias` varchar(128) DEFAULT NULL,
  `description` text,
  `tag` varchar(8) NOT NULL,
  `id_service` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_service`
--


--
-- Table structure for table `wpnk_vikappointments_lang_status_code`
--

CREATE TABLE `wpnk_vikappointments_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;

--
-- Dumping data for table `wpnk_vikappointments_lang_status_code`
--


--
-- Table structure for table `wpnk_vikappointments_lang_subscr`
--

CREATE TABLE `wpnk_vikappointments_lang_subscr` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` text,
  `id_subscr` int(10) unsigned NOT NULL,
  `tag` varchar(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_lang_subscr`
--


--
-- Table structure for table `wpnk_vikappointments_lang_tax`
--

CREATE TABLE `wpnk_vikappointments_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;

--
-- Dumping data for table `wpnk_vikappointments_lang_tax`
--


--
-- Table structure for table `wpnk_vikappointments_lang_tax_rule`
--

CREATE TABLE `wpnk_vikappointments_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;

--
-- Dumping data for table `wpnk_vikappointments_lang_tax_rule`
--


--
-- Table structure for table `wpnk_vikappointments_option`
--

CREATE TABLE `wpnk_vikappointments_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `description` varchar(1024) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `id_tax` int(10) unsigned DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `single` tinyint(1) NOT NULL DEFAULT '1',
  `maxq` int(6) NOT NULL DEFAULT '1',
  `maxqpeople` tinyint(1) DEFAULT '0' COMMENT '1 when the maxq depends on number of participants',
  `required` tinyint(1) DEFAULT '0',
  `image` varchar(128) DEFAULT '',
  `displaymode` tinyint(1) DEFAULT '1',
  `id_group` int(10) unsigned DEFAULT '0',
  `ordering` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_option`
--


--
-- Table structure for table `wpnk_vikappointments_option_group`
--

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

--
-- Dumping data for table `wpnk_vikappointments_option_group`
--


--
-- Table structure for table `wpnk_vikappointments_option_value`
--

CREATE TABLE `wpnk_vikappointments_option_value` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_option` int(10) unsigned NOT NULL,
  `name` varchar(64) NOT NULL,
  `inc_price` decimal(10,2) NOT NULL,
  `ordering` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_option_value`
--


--
-- Table structure for table `wpnk_vikappointments_order_status`
--

CREATE TABLE `wpnk_vikappointments_order_status` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_order` int(10) unsigned NOT NULL,
  `status` varchar(16) NOT NULL,
  `comment` varchar(512) DEFAULT NULL,
  `client` tinyint(1) unsigned DEFAULT '0' COMMENT 'admin (1) or site (0)',
  `ip` varchar(32) NOT NULL,
  `createdby` int(10) unsigned DEFAULT '0',
  `createdon` datetime DEFAULT NULL,
  `type` varchar(48) DEFAULT '' COMMENT 'to which table it refers',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_order_status`
--

INSERT INTO `wpnk_vikappointments_order_status` VALUES (1,1,'C','VAP_STATUS_CONFIRMED_AS_NO_PAYMENT',0,'174.248.145.204',1,'2021-11-23 14:57:13','reservation'),(2,2,'C','VAP_STATUS_CONFIRMED_AS_NO_PAYMENT',0,'174.248.145.204',1,'2021-11-23 15:54:41','reservation'),(3,3,'P','VAP_STATUS_CHANGED_ON_MANAGE',1,'174.248.145.204',2,'2021-11-23 16:00:19','reservation'),(4,4,'W','VAP_STATUS_CHANGED_ON_MANAGE',1,'174.248.145.204',2,'2021-11-23 17:53:40','reservation'),(5,4,'E','VAP_STATUS_ORDER_REMOVED',0,'174.248.145.204',0,'2021-11-23 18:09:15','reservation'),(6,5,'C','VAP_STATUS_CONFIRMED_AS_NO_PAYMENT',0,'174.248.145.204',0,'2021-11-23 20:25:46','reservation'),(7,6,'C','VAP_STATUS_CHANGED_ON_MANAGE',1,'174.248.145.204',2,'2021-11-23 21:22:11','reservation'),(8,7,'C','VAP_STATUS_CHANGED_ON_MANAGE',1,'174.248.145.204',2,'2021-11-23 21:24:33','reservation');

--
-- Table structure for table `wpnk_vikappointments_package`
--

CREATE TABLE `wpnk_vikappointments_package` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text,
  `price` decimal(10,2) NOT NULL,
  `num_app` int(4) unsigned NOT NULL,
  `published` tinyint(1) unsigned DEFAULT '0',
  `start_ts` datetime DEFAULT NULL,
  `end_ts` datetime DEFAULT NULL,
  `id_group` int(10) DEFAULT '-1',
  `level` tinyint(1) DEFAULT '1' COMMENT 'the access view level',
  `id_tax` int(10) unsigned DEFAULT '0',
  `ordering` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_package`
--


--
-- Table structure for table `wpnk_vikappointments_package_group`
--

CREATE TABLE `wpnk_vikappointments_package_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(512) NOT NULL,
  `description` text,
  `ordering` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_package_group`
--


--
-- Table structure for table `wpnk_vikappointments_package_order`
--

CREATE TABLE `wpnk_vikappointments_package_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` varchar(16) NOT NULL,
  `id_payment` int(10) DEFAULT '-1',
  `status` varchar(16) DEFAULT 'W',
  `total_cost` decimal(10,2) DEFAULT '0.00',
  `tot_paid` decimal(10,2) DEFAULT '0.00',
  `total_net` decimal(10,2) DEFAULT '0.00',
  `total_tax` decimal(10,2) DEFAULT '0.00',
  `payment_charge` decimal(5,2) DEFAULT '0.00',
  `payment_tax` decimal(5,2) DEFAULT '0.00',
  `discount` decimal(10,2) DEFAULT '0.00',
  `coupon` varchar(128) DEFAULT NULL,
  `purchaser_nominative` varchar(128) DEFAULT '',
  `purchaser_mail` varchar(64) NOT NULL,
  `purchaser_phone` varchar(32) DEFAULT '',
  `purchaser_prefix` varchar(10) DEFAULT '',
  `purchaser_country` varchar(2) DEFAULT '',
  `langtag` varchar(8) DEFAULT '',
  `custom_f` text,
  `createdon` datetime DEFAULT NULL,
  `createdby` int(10) DEFAULT '-1',
  `id_user` int(10) DEFAULT '-1',
  `log` text,
  `cc_data` text,
  `payment_attempt` int(4) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_package_order`
--


--
-- Table structure for table `wpnk_vikappointments_package_order_item`
--

CREATE TABLE `wpnk_vikappointments_package_order_item` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_order` int(10) NOT NULL,
  `id_package` int(10) NOT NULL,
  `price` decimal(10,2) DEFAULT '0.00',
  `net` decimal(10,2) DEFAULT '0.00',
  `tax` decimal(10,2) DEFAULT '0.00',
  `gross` decimal(10,2) DEFAULT '0.00',
  `discount` decimal(10,2) DEFAULT '0.00',
  `tax_breakdown` varchar(1024) DEFAULT NULL,
  `quantity` int(4) unsigned DEFAULT '1',
  `num_app` int(4) unsigned DEFAULT '1',
  `used_app` int(4) unsigned DEFAULT '0',
  `modifiedon` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_package_order_item`
--


--
-- Table structure for table `wpnk_vikappointments_package_service`
--

CREATE TABLE `wpnk_vikappointments_package_service` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_package` int(10) unsigned NOT NULL,
  `id_service` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_package_service`
--


--
-- Table structure for table `wpnk_vikappointments_res_opt_assoc`
--

CREATE TABLE `wpnk_vikappointments_res_opt_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_reservation` int(10) NOT NULL,
  `id_option` int(10) NOT NULL,
  `id_variation` int(10) DEFAULT '-1',
  `inc_price` decimal(10,2) NOT NULL,
  `net` decimal(10,2) DEFAULT '0.00',
  `tax` decimal(10,2) DEFAULT '0.00',
  `gross` decimal(10,2) DEFAULT '0.00',
  `discount` decimal(10,2) DEFAULT '0.00',
  `tax_breakdown` varchar(1024) DEFAULT NULL,
  `quantity` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_res_opt_assoc`
--


--
-- Table structure for table `wpnk_vikappointments_reservation`
--

CREATE TABLE `wpnk_vikappointments_reservation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_payment` int(10) NOT NULL,
  `id_employee` int(10) NOT NULL,
  `id_service` int(10) NOT NULL,
  `checkin_ts` datetime NOT NULL,
  `tz_offset` varchar(8) DEFAULT NULL,
  `people` int(4) NOT NULL DEFAULT '1',
  `duration` int(10) NOT NULL,
  `sleep` int(4) NOT NULL DEFAULT '0',
  `total_cost` decimal(10,2) DEFAULT '0.00',
  `tot_paid` decimal(10,2) DEFAULT '0.00',
  `total_net` decimal(10,2) DEFAULT '0.00',
  `total_tax` decimal(10,2) DEFAULT '0.00',
  `service_price` decimal(10,2) DEFAULT '0.00',
  `service_net` decimal(10,2) DEFAULT '0.00',
  `service_tax` decimal(10,2) DEFAULT '0.00',
  `service_gross` decimal(10,2) DEFAULT '0.00',
  `service_discount` decimal(10,2) DEFAULT '0.00',
  `payment_charge` decimal(5,2) DEFAULT '0.00',
  `payment_tax` decimal(5,2) DEFAULT '0.00',
  `discount` decimal(10,2) DEFAULT '0.00',
  `tax_breakdown` varchar(1024) DEFAULT NULL,
  `paid` tinyint(1) NOT NULL 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 '',
  `langtag` varchar(8) DEFAULT '',
  `custom_f` text,
  `attendees` text,
  `coupon_str` varchar(128) DEFAULT '',
  `status` varchar(16) DEFAULT 'W',
  `locked_until` int(12) DEFAULT '0',
  `sid` varchar(16) NOT NULL DEFAULT '000000000000',
  `conf_key` varchar(12) DEFAULT '',
  `view_emp` tinyint(1) DEFAULT '0',
  `notes` text,
  `uploads` varchar(256) DEFAULT '',
  `id_parent` int(10) NOT NULL DEFAULT '-1',
  `createdon` datetime DEFAULT NULL,
  `createdby` int(10) DEFAULT '-1',
  `id_user` int(10) DEFAULT '-1',
  `user_timezone` varchar(32) DEFAULT NULL,
  `skip_deposit` tinyint(1) unsigned DEFAULT '0',
  `icaluid` varchar(128) DEFAULT NULL,
  `log` text,
  `closure` tinyint(1) DEFAULT '0',
  `cc_data` text,
  `payment_attempt` int(4) DEFAULT '1',
  `conversion` varchar(64) DEFAULT '' COMMENT 'built as [PAGE].[ORDER_STATUS] (e.g. order.confirmed)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_reservation`
--

INSERT INTO `wpnk_vikappointments_reservation` VALUES (1,0,1,1,'2021-11-25 12:00:00','+00:00',1,60,0,55.00,0.00,55.00,0.00,55.00,55.00,0.00,55.00,0.00,0.00,0.00,0.00,'[]',0,'Jackie Smith','info@christiaanbekker.com','+1 (574) 274-6132','+1','US','en-US','{\"CUSTOMF_NAME\":\"Jackie\",\"CUSTOMF_LNAME\":\"Smith\",\"CUSTOMF_EMAIL\":\"info@christiaanbekker.com\",\"CUSTOMF_PHONE\":\"+1 (574) 274-6132\",\"I read and accept the terms and conditions\":\"1\"}','[]','','C',1637680333,'RCD8EMRD40N2706X','461VO9NO6188',0,NULL,'[]',1,'2021-11-23 14:57:13',1,1,NULL,0,NULL,NULL,0,NULL,1,''),(2,0,2,2,'2021-12-16 10:00:00','+00:00',1,60,0,35.00,0.00,35.00,0.00,35.00,35.00,0.00,35.00,0.00,0.00,0.00,0.00,'[]',0,'Shara Crowther','info@myrvbuddy.com','+1 (574) 274-6132','+1','US','en-US','{\"CUSTOMF_NAME\":\"Shara\",\"CUSTOMF_LNAME\":\"Crowther\",\"CUSTOMF_EMAIL\":\"info@myrvbuddy.com\",\"CUSTOMF_PHONE\":\"+1 (574) 274-6132\",\"I read and accept the terms and conditions\":\"1\"}','[]','','C',1637683781,'6K026OY0CEU8ANWT','BMM0234131N2',0,NULL,'[]',2,'2021-11-23 15:54:41',1,1,NULL,0,NULL,NULL,0,NULL,1,''),(3,0,2,2,'2021-12-22 11:00:00','+00:00',1,60,0,35.00,0.00,35.00,0.00,35.00,35.00,0.00,35.00,0.00,0.00,0.00,0.00,'[]',0,'','','','+1','US','','{\"CUSTOMF_NAME\":\"\",\"CUSTOMF_LNAME\":\"\",\"CUSTOMF_EMAIL\":\"\",\"CUSTOMF_PHONE\":\"\"}','[]','','P',1637684119,'524V5DE79SXRP7WU','8H2KND9317Z8',0,'','[]',3,'2021-11-23 16:00:19',2,0,NULL,0,NULL,NULL,0,NULL,1,''),(4,0,2,2,'2021-12-08 11:00:00','+00:00',1,60,0,35.00,0.00,35.00,0.00,35.00,35.00,0.00,35.00,0.00,0.00,0.00,0.00,'[]',0,'Barb Knipe','christiaanbekkerartist@gmail.com','+1 (574) 386-3345','+1','US','','{\"CUSTOMF_NAME\":\"\",\"CUSTOMF_LNAME\":\"\",\"CUSTOMF_EMAIL\":\"\",\"CUSTOMF_PHONE\":\"\"}','[]','','E',1637690920,'DC9UOZ0KA5C0F984','UME88YDG4MBK',0,'','[]',4,'2021-11-23 17:53:40',2,0,NULL,0,NULL,NULL,0,NULL,1,''),(5,0,1,1,'2021-11-30 09:00:00','+00:00',1,60,0,55.00,0.00,55.00,0.00,55.00,55.00,0.00,55.00,0.00,0.00,0.00,0.00,'[]',0,'Nancy Clover','support@theartgangster.com','+1 (547) 386-3345','+1','US','en-US','{\"CUSTOMF_NAME\":\"Nancy\",\"CUSTOMF_LNAME\":\"Clover\",\"CUSTOMF_EMAIL\":\"support@theartgangster.com\",\"CUSTOMF_PHONE\":\"+1 (547) 386-3345\",\"I read and accept the terms and conditions\":\"1\"}','[]','','C',1637700046,'7IASZ6HUWKP7YT8U','9MR50P7R4S0Z',1,NULL,'[]',5,'2021-11-23 20:25:46',0,2,NULL,0,NULL,NULL,0,NULL,1,''),(6,0,2,2,'2021-04-12 11:00:00','+00:00',1,60,0,35.00,0.00,35.00,0.00,35.00,35.00,0.00,35.00,0.00,0.00,0.00,0.00,'[]',0,'Barbara','info@advertisingwholesaler.com','+1 (574) 386-3345','+1','US','','{\"CUSTOMF_NAME\":\"\",\"CUSTOMF_LNAME\":\"\",\"CUSTOMF_EMAIL\":\"\",\"CUSTOMF_PHONE\":\"\"}','[]','','C',1637703431,'HPXAZE7WY97M505L','8D783824BH9D',1,'','[]',6,'2021-11-23 21:22:11',2,0,NULL,0,NULL,NULL,0,'',1,''),(7,0,2,2,'2021-12-20 12:00:00','+00:00',1,60,0,35.00,0.00,35.00,0.00,35.00,35.00,0.00,35.00,0.00,0.00,0.00,0.00,'[]',0,'Niles','','+1 (661) 675-3456','+1','US','','{\"CUSTOMF_NAME\":\"\",\"CUSTOMF_LNAME\":\"\",\"CUSTOMF_EMAIL\":\"\",\"CUSTOMF_PHONE\":\"\"}','[]','','C',1637703573,'O663AAP98A7028SX','FZVCA88T530H',1,'','[]',7,'2021-11-23 21:24:33',2,0,NULL,0,NULL,NULL,0,NULL,1,'');

--
-- Table structure for table `wpnk_vikappointments_reviews`
--

CREATE TABLE `wpnk_vikappointments_reviews` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jid` int(10) NOT NULL,
  `timestamp` datetime DEFAULT NULL,
  `name` varchar(128) NOT NULL,
  `email` varchar(128) NOT NULL,
  `title` varchar(64) DEFAULT '',
  `comment` text,
  `rating` int(1) unsigned DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `langtag` varchar(8) DEFAULT '',
  `id_employee` int(10) DEFAULT '-1',
  `id_service` int(10) DEFAULT '-1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_reviews`
--


--
-- Table structure for table `wpnk_vikappointments_ser_emp_assoc`
--

CREATE TABLE `wpnk_vikappointments_ser_emp_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_service` int(10) NOT NULL,
  `id_employee` int(10) NOT NULL,
  `global` tinyint(1) DEFAULT '1',
  `rate` decimal(8,2) DEFAULT '0.00',
  `duration` int(6) NOT NULL,
  `sleep` int(4) NOT NULL DEFAULT '0',
  `max_capacity` int(5) DEFAULT '1',
  `description` text,
  `ordering` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_ser_emp_assoc`
--

INSERT INTO `wpnk_vikappointments_ser_emp_assoc` VALUES (1,1,1,1,55.00,60,0,1,'',1),(2,2,2,1,35.00,60,0,1,'',1),(3,3,3,1,45.00,60,0,1,'',1);

--
-- Table structure for table `wpnk_vikappointments_ser_opt_assoc`
--

CREATE TABLE `wpnk_vikappointments_ser_opt_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_service` int(10) NOT NULL,
  `id_option` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_ser_opt_assoc`
--


--
-- Table structure for table `wpnk_vikappointments_ser_rates_assoc`
--

CREATE TABLE `wpnk_vikappointments_ser_rates_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_special_rate` int(10) unsigned NOT NULL,
  `id_service` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_ser_rates_assoc`
--


--
-- Table structure for table `wpnk_vikappointments_ser_restr_assoc`
--

CREATE TABLE `wpnk_vikappointments_ser_restr_assoc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_restriction` int(10) unsigned NOT NULL,
  `id_service` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_ser_restr_assoc`
--


--
-- Table structure for table `wpnk_vikappointments_service`
--

CREATE TABLE `wpnk_vikappointments_service` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `alias` varchar(128) NOT NULL,
  `description` text,
  `duration` int(6) NOT NULL,
  `sleep` int(4) NOT NULL DEFAULT '0',
  `interval` tinyint(1) NOT NULL DEFAULT '1',
  `minrestr` int(8) NOT NULL DEFAULT '-1',
  `mindate` int(4) NOT NULL DEFAULT '-1',
  `maxdate` int(4) NOT NULL DEFAULT '-1',
  `price` decimal(10,2) NOT NULL,
  `id_tax` int(10) unsigned DEFAULT '0',
  `max_capacity` int(5) NOT NULL DEFAULT '1',
  `min_per_res` int(5) NOT NULL DEFAULT '1',
  `max_per_res` int(5) NOT NULL DEFAULT '1',
  `priceperpeople` tinyint(1) NOT NULL DEFAULT '1',
  `app_per_slot` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'when disabled, the maximum capacity is ignored',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `quick_contact` tinyint(1) NOT NULL DEFAULT '0',
  `choose_emp` tinyint(1) NOT NULL DEFAULT '1',
  `random_emp` tinyint(1) unsigned DEFAULT '0',
  `enablezip` tinyint(1) NOT NULL DEFAULT '0',
  `use_recurrence` tinyint(1) NOT NULL DEFAULT '0',
  `image` varchar(128) DEFAULT '',
  `start_publishing` datetime DEFAULT NULL,
  `end_publishing` datetime DEFAULT NULL,
  `has_own_cal` tinyint(1) DEFAULT '0',
  `checkout_selection` tinyint(1) DEFAULT '0',
  `display_seats` tinyint(1) DEFAULT '0' COMMENT 'when enabled, the timeline will display the remaining seats',
  `id_group` int(10) DEFAULT '-1',
  `level` tinyint(1) DEFAULT '1' COMMENT 'the access view level',
  `color` varchar(6) DEFAULT NULL COMMENT 'the hex color tag',
  `createdby` int(10) unsigned DEFAULT '0',
  `ordering` int(10) NOT NULL DEFAULT '1',
  `metadata` text,
  `attachments` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_service`
--

INSERT INTO `wpnk_vikappointments_service` VALUES (1,'Hair','hair-stylist','Hair stylists are beauty service professionals who specialize in the fashioning and treatment of hair. Hair stylist responsibilities include cleaning and cutting hair, offering hair care and hair styling consultations and recommending hair styling products, among other duties.',60,0,1,-1,-1,-1,55.00,0,1,1,1,1,1,1,0,1,1,0,0,'1employee.jpg','0000-00-00 00:00:00','0000-00-00 00:00:00',1,0,0,1,1,'428BCA',0,1,'{\"title\":\"\",\"description\":\"\",\"keywords\":\"\"}','[]'),(2,'Skin Care','skin-care','',60,0,1,-1,-1,-1,35.00,0,1,1,1,1,1,1,0,1,1,0,0,'image2.jpg','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,2,1,'5CB85C',0,2,'{\"title\":\"\",\"description\":\"\",\"keywords\":\"\"}','[]'),(3,'Massage','massage','',60,0,1,-1,-1,-1,45.00,0,1,1,1,1,1,1,0,1,1,0,0,'massage.jpg','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,3,1,'AD4363',0,3,'{\"title\":\"\",\"description\":\"\",\"keywords\":\"\"}','[]'),(4,'Nails','nails','',60,0,1,-1,-1,-1,55.00,0,1,1,1,1,1,1,0,1,1,0,0,'nails.jpg','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,4,1,'F0AD4E',0,4,'{\"title\":\"\",\"description\":\"\",\"keywords\":\"\"}','[]');

--
-- Table structure for table `wpnk_vikappointments_special_rates`
--

CREATE TABLE `wpnk_vikappointments_special_rates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` varchar(512) NOT NULL,
  `charge` decimal(10,2) NOT NULL COMMENT 'negative is supported for discounts',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `weekdays` varchar(16) DEFAULT '' COMMENT 'a list of accepted week days (comma separated)',
  `fromdate` datetime DEFAULT NULL COMMENT 'start publishing',
  `todate` datetime DEFAULT NULL COMMENT 'end publishing',
  `fromtime` int(4) DEFAULT '0' COMMENT 'from time: built as hour * 60 + minutes',
  `totime` int(4) DEFAULT '0' COMMENT 'end time: built as hour * 60 + minutes',
  `people` int(4) DEFAULT '0',
  `usergroups` varchar(32) DEFAULT '' COMMENT 'a list of accepted user groups (comma separated)',
  `createdon` datetime DEFAULT NULL,
  `params` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_special_rates`
--


--
-- Table structure for table `wpnk_vikappointments_special_restrictions`
--

CREATE TABLE `wpnk_vikappointments_special_restrictions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `maxapp` int(4) DEFAULT '0' COMMENT 'max number of appointments per interval (0: unlimited)',
  `interval` varchar(32) DEFAULT NULL COMMENT 'the interval identifier',
  `mode` tinyint(1) DEFAULT '1' COMMENT 'applies to current date (1) or check-in date (2)',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `all` tinyint(1) DEFAULT '0' COMMENT 'unused @since 1.2',
  `usergroups` varchar(32) DEFAULT '' COMMENT 'a list of accepted user groups (comma separated)',
  `createdon` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_special_restrictions`
--


--
-- Table structure for table `wpnk_vikappointments_states`
--

CREATE TABLE `wpnk_vikappointments_states` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(10) unsigned NOT NULL DEFAULT '0',
  `state_name` varchar(64) NOT NULL,
  `state_2_code` char(2) NOT NULL,
  `state_3_code` char(3) DEFAULT '',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_state_2_code` (`id_country`,`state_2_code`)
) ENGINE=InnoDB AUTO_INCREMENT=524 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_states`
--

INSERT INTO `wpnk_vikappointments_states` VALUES (1,12,'Aragatsotn','AG','ARG',1),(2,12,'Ararat','AR','ARR',1),(3,12,'Armavir','AV','ARM',1),(4,12,'Gegharkunik','GR','GEG',1),(5,12,'Kotayk','KT','KOT',1),(6,12,'Lori','LO','LOR',1),(7,12,'Shirak','SH','SHI',1),(8,12,'Syunik','SU','SYU',1),(9,12,'Tavush','TV','TAV',1),(10,12,'Vayots-Dzor','VD','VAD',1),(11,12,'Yerevan','ER','YER',1),(12,11,'Buenos Aires','BA','BAS',1),(13,11,'Ciudad Autonoma De Buenos Aires','CB','CBA',1),(14,11,'Catamarca','CA','CAT',1),(15,11,'Chaco','CH','CHO',1),(16,11,'Chubut','CT','CTT',1),(17,11,'Cordoba','CO','COD',1),(18,11,'Corrientes','CR','CRI',1),(19,11,'Entre Rios','ER','ERS',1),(20,11,'Formosa','FR','FRM',1),(21,11,'Jujuy','JU','JUJ',1),(22,11,'La Pampa','LP','LPM',1),(23,11,'La Rioja','LR','LRI',1),(24,11,'Mendoza','ME','MED',1),(25,11,'Misiones','MI','MIS',1),(26,11,'Neuquen','NQ','NQU',1),(27,11,'Rio Negro','RN','RNG',1),(28,11,'Salta','SA','SAL',1),(29,11,'San Juan','SJ','SJN',1),(30,11,'San Luis','SL','SLU',1),(31,11,'Santa Cruz','SC','SCZ',1),(32,11,'Santa Fe','SF','SFE',1),(33,11,'Santiago Del Estero','SE','SEN',1),(34,11,'Tierra Del Fuego','TF','TFE',1),(35,11,'Tucuman','TU','TUC',1),(36,15,'Australian Capital Territory','AC','ACT',1),(37,15,'New South Wales','NS','NSW',1),(38,15,'Northern Territory','NT','NOT',1),(39,15,'Queensland','QL','QLD',1),(40,15,'South Australia','SA','SOA',1),(41,15,'Tasmania','TS','TAS',1),(42,15,'Victoria','VI','VIC',1),(43,15,'Western Australia','WA','WEA',1),(44,32,'Acre','AC','ACR',1),(45,32,'Alagoas','AL','ALG',1),(46,32,'Amap','AP','AMP',1),(47,32,'Amazonas','AM','AMZ',1),(48,32,'Bah','BA','BAH',1),(49,32,'Cear','CE','CEA',1),(50,32,'Distrito Federal','DF','DFB',1),(51,32,'Espirito Santo','ES','ESS',1),(52,32,'Goi','GO','GOI',1),(53,32,'Maranh','MA','MAR',1),(54,32,'Mato Grosso','MT','MAT',1),(55,32,'Mato Grosso do Sul','MS','MGS',1),(56,32,'Minas Gera','MG','MIG',1),(57,32,'Paran','PR','PAR',1),(58,32,'Para','PB','PRB',1),(59,32,'Par','PA','PAB',1),(60,32,'Pernambuco','PE','PER',1),(61,32,'Piau','PI','PIA',1),(62,32,'Rio Grande do Norte','RN','RGN',1),(63,32,'Rio Grande do Sul','RS','RGS',1),(64,32,'Rio de Janeiro','RJ','RDJ',1),(65,32,'Rond','RO','RON',1),(66,32,'Roraima','RR','ROR',1),(67,32,'Santa Catarina','SC','SAC',1),(68,32,'Sergipe','SE','SER',1),(69,32,'S','SP','SAP',1),(70,32,'Tocantins','TO','TOC',1),(71,41,'Alberta','AB','ALB',1),(72,41,'British Columbia','BC','BRC',1),(73,41,'Manitoba','MB','MAB',1),(74,41,'New Brunswick','NB','NEB',1),(75,41,'Newfoundland and Labrador','NL','NFL',1),(76,41,'Northwest Territories','NT','NWT',1),(77,41,'Nova Scotia','NS','NOS',1),(78,41,'Nunavut','NU','NUT',1),(79,41,'Ontario','ON','ONT',1),(80,41,'Prince Edward Island','PE','PEI',1),(81,41,'Quebec','QC','QEC',1),(82,41,'Saskatchewan','SK','SAK',1),(83,41,'Yukon','YT','YUT',1),(84,47,'Anhui','34','ANH',1),(85,47,'Beijing','11','BEI',1),(86,47,'Chongqing','50','CHO',1),(87,47,'Fujian','35','FUJ',1),(88,47,'Gansu','62','GAN',1),(89,47,'Guangdong','44','GUA',1),(90,47,'Guangxi Zhuang','45','GUZ',1),(91,47,'Guizhou','52','GUI',1),(92,47,'Hainan','46','HAI',1),(93,47,'Hebei','13','HEB',1),(94,47,'Heilongjiang','23','HEI',1),(95,47,'Henan','41','HEN',1),(96,47,'Hubei','42','HUB',1),(97,47,'Hunan','43','HUN',1),(98,47,'Jiangsu','32','JIA',1),(99,47,'Jiangxi','36','JIX',1),(100,47,'Jilin','22','JIL',1),(101,47,'Liaoning','21','LIA',1),(102,47,'Nei Mongol','15','NML',1),(103,47,'Ningxia Hui','64','NIH',1),(104,47,'Qinghai','63','QIN',1),(105,47,'Shandong','37','SNG',1),(106,47,'Shanghai','31','SHH',1),(107,47,'Shaanxi','61','SHX',1),(108,47,'Sichuan','51','SIC',1),(109,47,'Tianjin','12','TIA',1),(110,47,'Xinjiang Uygur','65','XIU',1),(111,47,'Xizang','54','XIZ',1),(112,47,'Yunnan','53','YUN',1),(113,47,'Zhejiang','33','ZHE',1),(114,86,'ΛΕΥΚΑΔΑΣ','ΛΕ','ΛΕΥ',1),(115,86,'ΛΑΡΙΣΑΣ','ΛΡ','ΛΑΡ',1),(116,86,'ΑΡΚΑΔΙΑΣ','ΑΚ','ΑΡΚ',1),(117,86,'ΑΡΓΟΛΙΔΑΣ','ΑΡ','ΑΡΓ',1),(118,86,'ΛΑΣΙΘΙΟΥ','ΛΑ','ΛΑΣ',1),(119,86,'ΛΕΣΒΟΥ','ΛΣ','ΛΕΣ',1),(120,86,'ΚΥΚΛΑΔΩΝ','ΚΥ','ΚΥΚ',1),(121,86,'ΑΙΤΩΛΟΑΚΑΡΝΑΝΙΑΣ','ΑΙ','ΑΙΤ',1),(122,86,'ΚΟΡΙΝΘΙΑΣ','ΚΟ','ΚΟΡ',1),(123,86,'ΛΑΚΩΝΙΑΣ','ΛK','ΛΑΚ',1),(124,86,'ΗΜΑΘΙΑΣ','ΗΜ','ΗΜΑ',1),(125,86,'ΗΡΑΚΛΕΙΟΥ','ΗΡ','ΗΡΑ',1),(126,86,'ΘΕΣΠΡΩΤΙΑΣ','ΘΠ','ΘΕΠ',1),(127,86,'ΘΕΣΣΑΛΟΝΙΚΗΣ','ΘΕ','ΘΕΣ',1),(128,86,'ΙΩΑΝΝΙΝΩΝ','ΙΩ','ΙΩΑ',1),(129,86,'ΚΑΒΑΛΑΣ','ΚΒ','ΚΑΒ',1),(130,86,'ΚΑΡΔΙΤΣΑΣ','ΚΡ','ΚΑΡ',1),(131,86,'ΚΑΣΤΟΡΙΑΣ','ΚΣ','ΚΑΣ',1),(132,86,'ΚΕΡΚΥΡΑΣ','ΚΕ','ΚΕΡ',1),(133,86,'ΚΕΦΑΛΛΗΝΙΑΣ','ΚΦ','ΚΕΦ',1),(134,86,'ΚΙΛΚΙΣ','ΚΙ','ΚΙΛ',1),(135,86,'ΚΟΖΑΝΗΣ','ΚZ','ΚΟΖ',1),(136,86,'ΑΧΑΪΑΣ','ΑΧ','ΑΧΑ',1),(137,86,'ΒΟΙΩΤΙΑΣ','ΒΟ','ΒΟΙ',1),(138,86,'ΓΡΕΒΕΝΩΝ','ΓΡ','ΓΡΕ',1),(139,86,'ΔΡΑΜΑΣ','ΔΡ','ΔΡΑ',1),(140,86,'ΔΩΔΕΚΑΝΗΣΟΥ','ΔΩ','ΔΩΔ',1),(141,86,'ΕΒΡΟΥ','ΕΒ','ΕΒΡ',1),(142,86,'ΕΥΒΟΙΑΣ','ΕΥ','ΕΥΒ',1),(143,86,'ΕΥΡΥΤΑΝΙΑΣ','ΕΡ','ΕΥΡ',1),(144,86,'ΖΑΚΥΝΘΟΥ','ΖΑ','ΖΑΚ',1),(145,86,'ΗΛΕΙΑΣ','ΗΛ','ΗΛΕ',1),(146,86,'ΑΡΤΑΣ','ΑΑ','ΑΡΤ',1),(147,86,'ΑΤΤΙΚΗΣ','ΑΤ','ΑΤΤ',1),(148,86,'ΜΑΓΝΗΣΙΑΣ','ΜΑ','ΜΑΓ',1),(149,86,'ΜΕΣΣΗΝΙΑΣ','ΜΕ','ΜΕΣ',1),(150,86,'ΞΑΝΘΗΣ','ΞΑ','ΞΑΝ',1),(151,86,'ΠΕΛΛΗΣ','ΠΕ','ΠΕΛ',1),(152,86,'ΠΙΕΡΙΑΣ','ΠΙ','ΠΙΕ',1),(153,86,'ΠΡΕΒΕΖΑΣ','ΠΡ','ΠΡΕ',1),(154,86,'ΡΕΘΥΜΝΗΣ','ΡΕ','ΡΕΘ',1),(155,86,'ΡΟΔΟΠΗΣ','ΡΟ','ΡΟΔ',1),(156,86,'ΣΑΜΟΥ','ΣΑ','ΣΑΜ',1),(157,86,'ΣΕΡΡΩΝ','ΣΕ','ΣΕΡ',1),(158,86,'ΤΡΙΚΑΛΩΝ','ΤΡ','ΤΡΙ',1),(159,86,'ΦΘΙΩΤΙΔΑΣ','ΦΘ','ΦΘΙ',1),(160,86,'ΦΛΩΡΙΝΑΣ','ΦΛ','ΦΛΩ',1),(161,86,'ΦΩΚΙΔΑΣ','ΦΩ','ΦΩΚ',1),(162,86,'ΧΑΛΚΙΔΙΚΗΣ','ΧΑ','ΧΑΛ',1),(163,86,'ΧΑΝΙΩΝ','ΧΝ','ΧΑΝ',1),(164,86,'ΧΙΟΥ','ΧΙ','ΧΙΟ',1),(165,102,'Andaman & Nicobar Islands','AI','ANI',1),(166,102,'Andhra Pradesh','AN','AND',1),(167,102,'Arunachal Pradesh','AR','ARU',1),(168,102,'Assam','AS','ASS',1),(169,102,'Bihar','BI','BIH',1),(170,102,'Chandigarh','CA','CHA',1),(171,102,'Chhatisgarh','CH','CHH',1),(172,102,'Dadra & Nagar Haveli','DD','DAD',1),(173,102,'Daman & Diu','DA','DAM',1),(174,102,'Delhi','DE','DEL',1),(175,102,'Goa','GO','GOA',1),(176,102,'Gujarat','GU','GUJ',1),(177,102,'Haryana','HA','HAR',1),(178,102,'Himachal Pradesh','HI','HIM',1),(179,102,'Jammu & Kashmir','JA','JAM',1),(180,102,'Jharkhand','JH','JHA',1),(181,102,'Karnataka','KA','KAR',1),(182,102,'Kerala','KE','KER',1),(183,102,'Lakshadweep','LA','LAK',1),(184,102,'Madhya Pradesh','MD','MAD',1),(185,102,'Maharashtra','MH','MAH',1),(186,102,'Manipur','MN','MAN',1),(187,102,'Meghalaya','ME','MEG',1),(188,102,'Mizoram','MI','MIZ',1),(189,102,'Nagaland','NA','NAG',1),(190,102,'Orissa','OR','ORI',1),(191,102,'Pondicherry','PO','PON',1),(192,102,'Punjab','PU','PUN',1),(193,102,'Rajasthan','RA','RAJ',1),(194,102,'Sikkim','SI','SIK',1),(195,102,'Tamil Nadu','TA','TAM',1),(196,102,'Tripura','TR','TRI',1),(197,102,'Uttaranchal','UA','UAR',1),(198,102,'Uttar Pradesh','UT','UTT',1),(199,102,'West Bengal','WE','WES',1),(200,104,'Ahmadi va Kohkiluyeh','BO','BOK',1),(201,104,'Ardabil','AR','ARD',1),(202,104,'Azarbayjan-e Gharbi','AG','AZG',1),(203,104,'Azarbayjan-e Sharqi','AS','AZS',1),(204,104,'Bushehr','BU','BUS',1),(205,104,'Chaharmahal va Bakhtiari','CM','CMB',1),(206,104,'Esfahan','ES','ESF',1),(207,104,'Fars','FA','FAR',1),(208,104,'Gilan','GI','GIL',1),(209,104,'Gorgan','GO','GOR',1),(210,104,'Hamadan','HA','HAM',1),(211,104,'Hormozgan','HO','HOR',1),(212,104,'Ilam','IL','ILA',1),(213,104,'Kerman','KE','KER',1),(214,104,'Kermanshah','BA','BAK',1),(215,104,'Khorasan-e Junoubi','KJ','KHJ',1),(216,104,'Khorasan-e Razavi','KR','KHR',1),(217,104,'Khorasan-e Shomali','KS','KHS',1),(218,104,'Khuzestan','KH','KHU',1),(219,104,'Kordestan','KO','KOR',1),(220,104,'Lorestan','LO','LOR',1),(221,104,'Markazi','MR','MAR',1),(222,104,'Mazandaran','MZ','MAZ',1),(223,104,'Qazvin','QA','QAS',1),(224,104,'Qom','QO','QOM',1),(225,104,'Semnan','SE','SEM',1),(226,104,'Sistan va Baluchestan','SB','SBA',1),(227,104,'Tehran','TE','TEH',1),(228,104,'Yazd','YA','YAZ',1),(229,104,'Zanjan','ZA','ZAN',1),(230,108,'Israel','IL','ISL',1),(231,108,'Gaza Strip','GZ','GZS',1),(232,108,'West Bank','WB','WBK',1),(233,109,'Agrigento','AG','AGR',1),(234,109,'Alessandria','AL','ALE',1),(235,109,'Ancona','AN','ANC',1),(236,109,'Aosta','AO','AOS',1),(237,109,'Arezzo','AR','ARE',1),(238,109,'Ascoli Piceno','AP','API',1),(239,109,'Asti','AT','AST',1),(240,109,'Avellino','AV','AVE',1),(241,109,'Bari','BA','BAR',1),(242,109,'Belluno','BL','BEL',1),(243,109,'Benevento','BN','BEN',1),(244,109,'Bergamo','BG','BEG',1),(245,109,'Biella','BI','BIE',1),(246,109,'Bologna','BO','BOL',1),(247,109,'Bolzano','BZ','BOZ',1),(248,109,'Brescia','BS','BRE',1),(249,109,'Brindisi','BR','BRI',1),(250,109,'Cagliari','CA','CAG',1),(251,109,'Caltanissetta','CL','CAL',1),(252,109,'Campobasso','CB','CBO',1),(253,109,'Carbonia-Iglesias','CI','CAR',1),(254,109,'Caserta','CE','CAS',1),(255,109,'Catania','CT','CAT',1),(256,109,'Catanzaro','CZ','CTZ',1),(257,109,'Chieti','CH','CHI',1),(258,109,'Como','CO','COM',1),(259,109,'Cosenza','CS','COS',1),(260,109,'Cremona','CR','CRE',1),(261,109,'Crotone','KR','CRO',1),(262,109,'Cuneo','CN','CUN',1),(263,109,'Enna','EN','ENN',1),(264,109,'Ferrara','FE','FER',1),(265,109,'Firenze','FI','FIR',1),(266,109,'Foggia','FG','FOG',1),(267,109,'Forli-Cesena','FC','FOC',1),(268,109,'Frosinone','FR','FRO',1),(269,109,'Genova','GE','GEN',1),(270,109,'Gorizia','GO','GOR',1),(271,109,'Grosseto','GR','GRO',1),(272,109,'Imperia','IM','IMP',1),(273,109,'Isernia','IS','ISE',1),(274,109,'L\'Aquila','AQ','AQU',1),(275,109,'La Spezia','SP','LAS',1),(276,109,'Latina','LT','LAT',1),(277,109,'Lecce','LE','LEC',1),(278,109,'Lecco','LC','LCC',1),(279,109,'Livorno','LI','LIV',1),(280,109,'Lodi','LO','LOD',1),(281,109,'Lucca','LU','LUC',1),(282,109,'Macerata','MC','MAC',1),(283,109,'Mantova','MN','MAN',1),(284,109,'Massa-Carrara','MS','MAS',1),(285,109,'Matera','MT','MAA',1),(286,109,'Medio Campidano','VS','MED',1),(287,109,'Messina','ME','MES',1),(288,109,'Milano','MI','MIL',1),(289,109,'Modena','MO','MOD',1),(290,109,'Napoli','NA','NAP',1),(291,109,'Novara','NO','NOV',1),(292,109,'Nuoro','NU','NUR',1),(293,109,'Ogliastra','OG','OGL',1),(294,109,'Olbia-Tempio','OT','OLB',1),(295,109,'Oristano','OR','ORI',1),(296,109,'Padova','PD','PDA',1),(297,109,'Palermo','PA','PAL',1),(298,109,'Parma','PR','PAA',1),(299,109,'Pavia','PV','PAV',1),(300,109,'Perugia','PG','PER',1),(301,109,'Pesaro e Urbino','PU','PES',1),(302,109,'Pescara','PE','PSC',1),(303,109,'Piacenza','PC','PIA',1),(304,109,'Pisa','PI','PIS',1),(305,109,'Pistoia','PT','PIT',1),(306,109,'Pordenone','PN','POR',1),(307,109,'Potenza','PZ','PTZ',1),(308,109,'Prato','PO','PRA',1),(309,109,'Ragusa','RG','RAG',1),(310,109,'Ravenna','RA','RAV',1),(311,109,'Reggio Calabria','RC','REG',1),(312,109,'Reggio Emilia','RE','REE',1),(313,109,'Rieti','RI','RIE',1),(314,109,'Rimini','RN','RIM',1),(315,109,'Roma','RM','ROM',1),(316,109,'Rovigo','RO','ROV',1),(317,109,'Salerno','SA','SAL',1),(318,109,'Sassari','SS','SAS',1),(319,109,'Savona','SV','SAV',1),(320,109,'Siena','SI','SIE',1),(321,109,'Siracusa','SR','SIR',1),(322,109,'Sondrio','SO','SOO',1),(323,109,'Taranto','TA','TAR',1),(324,109,'Teramo','TE','TER',1),(325,109,'Terni','TR','TRN',1),(326,109,'Torino','TO','TOR',1),(327,109,'Trapani','TP','TRA',1),(328,109,'Trento','TN','TRE',1),(329,109,'Treviso','TV','TRV',1),(330,109,'Trieste','TS','TRI',1),(331,109,'Udine','UD','UDI',1),(332,109,'Varese','VA','VAR',1),(333,109,'Venezia','VE','VEN',1),(334,109,'Verbano Cusio Ossola','VB','VCO',1),(335,109,'Vercelli','VC','VER',1),(336,109,'Verona','VR','VRN',1),(337,109,'Vibo Valenzia','VV','VIV',1),(338,109,'Vicenza','VI','VII',1),(339,109,'Viterbo','VT','VIT',1),(340,142,'Aguascalientes','AG','AGS',1),(341,142,'Baja California Norte','BN','BCN',1),(342,142,'Baja California Sur','BS','BCS',1),(343,142,'Campeche','CA','CAM',1),(344,142,'Chiapas','CS','CHI',1),(345,142,'Chihuahua','CH','CHA',1),(346,142,'Coahuila','CO','COA',1),(347,142,'Colima','CM','COL',1),(348,142,'Distrito Federal','DF','DFM',1),(349,142,'Durango','DO','DGO',1),(350,142,'Guanajuato','GO','GTO',1),(351,142,'Guerrero','GU','GRO',1),(352,142,'Hidalgo','HI','HGO',1),(353,142,'Jalisco','JA','JAL',1),(354,142,'M','EM','EDM',1),(355,142,'Michoac','MI','MCN',1),(356,142,'Morelos','MO','MOR',1),(357,142,'Nayarit','NY','NAY',1),(358,142,'Nuevo Le','NL','NUL',1),(359,142,'Oaxaca','OA','OAX',1),(360,142,'Puebla','PU','PUE',1),(361,142,'Quer','QU','QRO',1),(362,142,'Quintana Roo','QR','QUR',1),(363,142,'San Luis Potos','SP','SLP',1),(364,142,'Sinaloa','SI','SIN',1),(365,142,'Sonora','SO','SON',1),(366,142,'Tabasco','TA','TAB',1),(367,142,'Tamaulipas','TM','TAM',1),(368,142,'Tlaxcala','TX','TLX',1),(369,142,'Veracruz','VZ','VER',1),(370,142,'Yucat','YU','YUC',1),(371,142,'Zacatecas','ZA','ZAC',1),(372,156,'St. Maarten','SM','STM',1),(373,156,'Bonaire','BN','BNR',1),(374,156,'Curacao','CR','CUR',1),(375,183,'Alba','AB','ABA',1),(376,183,'Arad','AR','ARD',1),(377,183,'Arges','AG','ARG',1),(378,183,'Bacau','BC','BAC',1),(379,183,'Bihor','BH','BIH',1),(380,183,'Bistrita-Nasaud','BN','BIS',1),(381,183,'Botosani','BT','BOT',1),(382,183,'Braila','BR','BRL',1),(383,183,'Brasov','BV','BRA',1),(384,183,'Bucuresti','B','BUC',1),(385,183,'Buzau','BZ','BUZ',1),(386,183,'Calarasi','CL','CAL',1),(387,183,'Caras Severin','CS','CRS',1),(388,183,'Cluj','CJ','CLJ',1),(389,183,'Constanta','CT','CST',1),(390,183,'Covasna','CV','COV',1),(391,183,'Dambovita','DB','DAM',1),(392,183,'Dolj','DJ','DLJ',1),(393,183,'Galati','GL','GAL',1),(394,183,'Giurgiu','GR','GIU',1),(395,183,'Gorj','GJ','GOR',1),(396,183,'Hargita','HR','HRG',1),(397,183,'Hunedoara','HD','HUN',1),(398,183,'Ialomita','IL','IAL',1),(399,183,'Iasi','IS','IAS',1),(400,183,'Ilfov','IF','ILF',1),(401,183,'Maramures','MM','MAR',1),(402,183,'Mehedinti','MH','MEH',1),(403,183,'Mures','MS','MUR',1),(404,183,'Neamt','NT','NEM',1),(405,183,'Olt','OT','OLT',1),(406,183,'Prahova','PH','PRA',1),(407,183,'Salaj','SJ','SAL',1),(408,183,'Satu Mare','SM','SAT',1),(409,183,'Sibiu','SB','SIB',1),(410,183,'Suceava','SV','SUC',1),(411,183,'Teleorman','TR','TEL',1),(412,183,'Timis','TM','TIM',1),(413,183,'Tulcea','TL','TUL',1),(414,183,'Valcea','VL','VAL',1),(415,183,'Vaslui','VS','VAS',1),(416,183,'Vrancea','VN','VRA',1),(417,209,'A Coru','15','ACO',1),(418,209,'Alava','01','ALA',1),(419,209,'Albacete','02','ALB',1),(420,209,'Alicante','03','ALI',1),(421,209,'Almeria','04','ALM',1),(422,209,'Asturias','33','AST',1),(423,209,'Avila','05','AVI',1),(424,209,'Badajoz','06','BAD',1),(425,209,'Baleares','07','BAL',1),(426,209,'Barcelona','08','BAR',1),(427,209,'Burgos','09','BUR',1),(428,209,'Caceres','10','CAC',1),(429,209,'Cadiz','11','CAD',1),(430,209,'Cantabria','39','CAN',1),(431,209,'Castellon','12','CAS',1),(432,209,'Ceuta','51','CEU',1),(433,209,'Ciudad Real','13','CIU',1),(434,209,'Cordoba','14','COR',1),(435,209,'Cuenca','16','CUE',1),(436,209,'Girona','17','GIR',1),(437,209,'Granada','18','GRA',1),(438,209,'Guadalajara','19','GUA',1),(439,209,'Guipuzcoa','20','GUI',1),(440,209,'Huelva','21','HUL',1),(441,209,'Huesca','22','HUS',1),(442,209,'Jaen','23','JAE',1),(443,209,'La Rioja','26','LRI',1),(444,209,'Las Palmas','35','LPA',1),(445,209,'Leon','24','LEO',1),(446,209,'Lleida','25','LLE',1),(447,209,'Lugo','27','LUG',1),(448,209,'Madrid','28','MAD',1),(449,209,'Malaga','29','MAL',1),(450,209,'Melilla','52','MEL',1),(451,209,'Murcia','30','MUR',1),(452,209,'Navarra','31','NAV',1),(453,209,'Ourense','32','OUR',1),(454,209,'Palencia','34','PAL',1),(455,209,'Pontevedra','36','PON',1),(456,209,'Salamanca','37','SAL',1),(457,209,'Santa Cruz de Tenerife','38','SCT',1),(458,209,'Segovia','40','SEG',1),(459,209,'Sevilla','41','SEV',1),(460,209,'Soria','42','SOR',1),(461,209,'Tarragona','43','TAR',1),(462,209,'Teruel','44','TER',1),(463,209,'Toledo','45','TOL',1),(464,209,'Valencia','46','VAL',1),(465,209,'Valladolid','47','VLL',1),(466,209,'Vizcaya','48','VIZ',1),(467,209,'Zamora','49','ZAM',1),(468,209,'Zaragoza','50','ZAR',1),(469,235,'England','EN','ENG',1),(470,235,'Northern Ireland','NI','NOI',1),(471,235,'Scotland','SD','SCO',1),(472,235,'Wales','WS','WLS',1),(473,236,'Alabama','AL','ALA',1),(474,236,'Alaska','AK','ALK',1),(475,236,'Arizona','AZ','ARZ',1),(476,236,'Arkansas','AR','ARK',1),(477,236,'California','CA','CAL',1),(478,236,'Colorado','CO','COL',1),(479,236,'Connecticut','CT','CCT',1),(480,236,'Delaware','DE','DEL',1),(481,236,'District Of Columbia','DC','DOC',1),(482,236,'Florida','FL','FLO',1),(483,236,'Georgia','GA','GEA',1),(484,236,'Hawaii','HI','HWI',1),(485,236,'Idaho','ID','IDA',1),(486,236,'Illinois','IL','ILL',1),(487,236,'Indiana','IN','IND',1),(488,236,'Iowa','IA','IOA',1),(489,236,'Kansas','KS','KAS',1),(490,236,'Kentucky','KY','KTY',1),(491,236,'Louisiana','LA','LOA',1),(492,236,'Maine','ME','MAI',1),(493,236,'Maryland','MD','MLD',1),(494,236,'Massachusetts','MA','MSA',1),(495,236,'Michigan','MI','MIC',1),(496,236,'Minnesota','MN','MIN',1),(497,236,'Mississippi','MS','MIS',1),(498,236,'Missouri','MO','MIO',1),(499,236,'Montana','MT','MOT',1),(500,236,'Nebraska','NE','NEB',1),(501,236,'Nevada','NV','NEV',1),(502,236,'New Hampshire','NH','NEH',1),(503,236,'New Jersey','NJ','NEJ',1),(504,236,'New Mexico','NM','NEM',1),(505,236,'New York','NY','NEY',1),(506,236,'North Carolina','NC','NOC',1),(507,236,'North Dakota','ND','NOD',1),(508,236,'Ohio','OH','OHI',1),(509,236,'Oklahoma','OK','OKL',1),(510,236,'Oregon','OR','ORN',1),(511,236,'Pennsylvania','PA','PEA',1),(512,236,'Rhode Island','RI','RHI',1),(513,236,'South Carolina','SC','SOC',1),(514,236,'South Dakota','SD','SOD',1),(515,236,'Tennessee','TN','TEN',1),(516,236,'Texas','TX','TXS',1),(517,236,'Utah','UT','UTA',1),(518,236,'Vermont','VT','VMT',1),(519,236,'Virginia','VA','VIA',1),(520,236,'Washington','WA','WAS',1),(521,236,'West Virginia','WV','WEV',1),(522,236,'Wisconsin','WI','WIS',1),(523,236,'Wyoming','WY','WYO',1);

--
-- Table structure for table `wpnk_vikappointments_stats_widget`
--

CREATE TABLE `wpnk_vikappointments_stats_widget` (
  `id` int(4) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(128) DEFAULT NULL,
  `widget` varchar(64) NOT NULL,
  `position` varchar(64) NOT NULL,
  `location` varchar(16) NOT NULL,
  `size` varchar(32) DEFAULT NULL,
  `ordering` int(4) unsigned DEFAULT '1',
  `params` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_stats_widget`
--

INSERT INTO `wpnk_vikappointments_stats_widget` VALUES (1,0,NULL,'dashboard_appointments_table','top','dashboard','',1,NULL),(2,0,NULL,'dashboard_appointments_calendar','top','dashboard','small',2,'{\"services\":null,\"employees\":null}'),(3,0,NULL,'finance_revenue_chart','top','finance','',1,NULL),(4,0,NULL,'finance_overall','top','finance','small',2,NULL),(5,0,NULL,'finance_coupons_table','bottom','finance','',3,NULL),(6,0,NULL,'finance_coupons_chart','bottom','finance','',4,NULL),(7,0,NULL,'appointments_revenue_chart','top','appointments','',1,NULL),(8,0,NULL,'appointments_status_count','top','appointments','small',2,NULL),(9,0,NULL,'appointments_revenue_table','bottom','appointments','',3,NULL),(10,0,NULL,'appointments_customers_chart','bottom','appointments','small',4,NULL),(11,0,NULL,'services_revenue_chart','top','services','',1,NULL),(12,0,NULL,'services_revenue_count','top','services','small',2,NULL),(13,0,NULL,'services_employees_count','bottom','services','small',3,NULL),(14,0,NULL,'services_employees_chart','bottom','services','',4,NULL),(15,0,NULL,'employees_revenue_chart','top','employees','',1,NULL),(16,0,NULL,'employees_revenue_count','top','employees','small',2,NULL),(17,0,NULL,'employees_services_count','bottom','employees','small',3,NULL),(18,0,NULL,'employees_services_chart','bottom','employees','',4,NULL),(19,0,NULL,'customers_appointments_chart','top','customers','',1,NULL),(20,0,NULL,'customers_appointments_weekdays','top','customers','',2,NULL),(21,0,NULL,'customers_status_count','middle','customers','',3,NULL),(22,0,NULL,'customers_overall','middle','customers','',4,NULL),(23,0,NULL,'customers_preferred_services','bottom','customers','',5,NULL),(24,0,NULL,'packages_items_chart','top','packages','',1,NULL),(25,0,NULL,'packages_items_count','top','packages','small',2,NULL),(26,0,NULL,'packages_revenue_chart','middle','packages','',3,NULL),(27,0,NULL,'packages_status_count','middle','packages','',4,NULL),(28,0,NULL,'packages_rog','middle','packages','',5,NULL),(29,0,NULL,'packages_revenue_table','bottom','packages','',6,NULL),(30,0,NULL,'subscriptions_items_chart','top','subscriptions','',1,NULL),(31,0,NULL,'subscriptions_items_count','top','subscriptions','small',2,NULL),(32,0,NULL,'subscriptions_revenue_chart','middle','subscriptions','',3,NULL),(33,0,NULL,'subscriptions_status_count','middle','subscriptions','',4,NULL),(34,0,NULL,'subscriptions_rog','middle','subscriptions','',5,NULL),(35,0,NULL,'subscriptions_revenue_table','bottom','subscriptions','',6,NULL);

--
-- Table structure for table `wpnk_vikappointments_status_code`
--

CREATE TABLE `wpnk_vikappointments_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',
  `appointments` tinyint(1) DEFAULT '1',
  `packages` tinyint(1) DEFAULT '1',
  `subscriptions` 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 AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_status_code`
--

INSERT INTO `wpnk_vikappointments_status_code` VALUES (1,'Confirmed',NULL,'C','008000',1,1,1,1,1,1,0,0,0),(2,'Paid',NULL,'P','339CCC',2,1,1,1,1,1,0,0,1),(3,'Pending',NULL,'W','FF7000',3,1,1,1,0,1,0,0,0),(4,'Removed',NULL,'E','990000',4,1,0,0,0,0,1,0,0),(5,'Cancelled',NULL,'X','F01B17',5,1,1,1,0,0,0,1,0),(6,'Refunded',NULL,'R','8116C9',6,1,1,1,0,0,0,1,1),(7,'No-Show',NULL,'N','828282',7,1,0,0,1,1,0,0,0);

--
-- Table structure for table `wpnk_vikappointments_subscr_order`
--

CREATE TABLE `wpnk_vikappointments_subscr_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` varchar(16) NOT NULL,
  `id_user` int(10) unsigned DEFAULT '0' COMMENT 'for customers only',
  `id_employee` int(10) unsigned DEFAULT '0' COMMENT 'for employees only',
  `id_subscr` int(10) unsigned NOT NULL,
  `id_payment` int(10) DEFAULT '-1',
  `total_cost` decimal(10,2) DEFAULT '0.00',
  `tot_paid` decimal(10,2) DEFAULT '0.00',
  `total_net` decimal(10,2) DEFAULT '0.00',
  `total_tax` decimal(10,2) DEFAULT '0.00',
  `payment_charge` decimal(5,2) DEFAULT '0.00',
  `payment_tax` decimal(5,2) DEFAULT '0.00',
  `discount` decimal(10,2) DEFAULT '0.00',
  `coupon` varchar(128) DEFAULT NULL,
  `status` varchar(16) DEFAULT 'W',
  `createdon` datetime DEFAULT NULL,
  `cc_data` text,
  `payment_attempt` int(4) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_subscr_order`
--


--
-- Table structure for table `wpnk_vikappointments_subscription`
--

CREATE TABLE `wpnk_vikappointments_subscription` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` text,
  `amount` int(10) unsigned NOT NULL,
  `type` tinyint(1) unsigned NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `id_tax` int(10) unsigned DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `trial` tinyint(1) NOT NULL DEFAULT '0',
  `group` tinyint(1) unsigned DEFAULT '0' COMMENT 'available for customers (0) or for employees (1)',
  `services` varchar(256) DEFAULT NULL COMMENT 'all the available services (for customers group only)',
  `ordering` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_subscription`
--

INSERT INTO `wpnk_vikappointments_subscription` VALUES (1,'One Week',NULL,1,2,0.00,0,0,1,0,NULL,1),(2,'One Month',NULL,1,3,30.00,0,0,0,0,NULL,2),(3,'Six Months',NULL,6,3,162.00,0,0,0,0,NULL,3),(4,'One Year',NULL,1,4,292.00,0,0,0,0,NULL,4),(5,'One Week',NULL,1,2,0.00,0,0,1,1,NULL,1),(6,'One Month',NULL,1,3,30.00,0,0,0,1,NULL,2),(7,'Six Months',NULL,6,3,162.00,0,0,0,1,NULL,3),(8,'One Year',NULL,1,4,292.00,0,0,0,1,NULL,4);

--
-- Table structure for table `wpnk_vikappointments_tag`
--

CREATE TABLE `wpnk_vikappointments_tag` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(48) NOT NULL,
  `description` varchar(256) DEFAULT NULL,
  `color` varchar(8) DEFAULT NULL,
  `icon` varchar(48) DEFAULT 'fas fa-bookmark',
  `group` varchar(32) DEFAULT NULL,
  `createdon` datetime DEFAULT NULL,
  `author` int(10) unsigned DEFAULT NULL,
  `ordering` int(10) unsigned DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_tag`
--


--
-- Table structure for table `wpnk_vikappointments_tax`
--

CREATE TABLE `wpnk_vikappointments_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;

--
-- Dumping data for table `wpnk_vikappointments_tax`
--


--
-- Table structure for table `wpnk_vikappointments_tax_rule`
--

CREATE TABLE `wpnk_vikappointments_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.0000',
  `cap` decimal(10,2) DEFAULT '0.00',
  `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;

--
-- Dumping data for table `wpnk_vikappointments_tax_rule`
--


--
-- Table structure for table `wpnk_vikappointments_user_notes`
--

CREATE TABLE `wpnk_vikappointments_user_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned DEFAULT '0',
  `id_parent` int(10) unsigned DEFAULT '0',
  `group` varchar(32) DEFAULT NULL COMMENT 'to which section the note belongs',
  `title` varchar(128) DEFAULT NULL,
  `content` text,
  `attachments` varchar(1024) DEFAULT NULL COMMENT 'JSON array of files',
  `status` tinyint(1) DEFAULT '0',
  `tags` varchar(256) DEFAULT NULL COMMENT 'comma-separated list of tags',
  `createdon` datetime DEFAULT NULL,
  `modifiedon` datetime DEFAULT NULL,
  `author` int(10) DEFAULT NULL,
  `secret` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_user_notes`
--


--
-- Table structure for table `wpnk_vikappointments_waitinglist`
--

CREATE TABLE `wpnk_vikappointments_waitinglist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_service` int(10) unsigned NOT NULL,
  `id_employee` int(10) DEFAULT '-1',
  `email` varchar(64) DEFAULT '',
  `phone_number` varchar(32) DEFAULT '',
  `phone_prefix` varchar(10) DEFAULT '',
  `timestamp` date NOT NULL,
  `jid` int(10) DEFAULT '-1',
  `created_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_waitinglist`
--


--
-- Table structure for table `wpnk_vikappointments_webhook`
--

CREATE TABLE `wpnk_vikappointments_webhook` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `hook` varchar(128) NOT NULL,
  `url` varchar(1024) NOT NULL,
  `secret` varchar(128) DEFAULT NULL,
  `published` tinyint(1) DEFAULT '0',
  `params` varchar(2048) DEFAULT NULL,
  `createdon` datetime DEFAULT NULL,
  `modifiedon` datetime DEFAULT NULL,
  `lastping` datetime DEFAULT NULL,
  `failed` int(4) unsigned DEFAULT '0',
  `logkey` varchar(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_webhook`
--


--
-- Table structure for table `wpnk_vikappointments_wpshortcodes`
--

CREATE TABLE `wpnk_vikappointments_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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wpnk_vikappointments_wpshortcodes`
--

INSERT INTO `wpnk_vikappointments_wpshortcodes` VALUES (1,'2021-11-23 13:38:55',1,'[]','allorders','COM_VIKAPPOINTMENTS_ALLORDERS_VIEW_DEFAULT_TITLE','All Orders View','en-US','[vikappointments view=\"allorders\" lang=\"en-US\"]',58,0),(2,'2021-11-23 13:42:51',1,'[]','confirmapp','COM_VIKAPPOINTMENTS_CONFIRMAPP_VIEW_DEFAULT_TITLE','Confirmation','en-US','[vikappointments view=\"confirmapp\" lang=\"en-US\"]',0,0),(3,'2021-11-23 14:41:14',1,'{\"id_employee\":\"1\"}','employeesearch','COM_VIKAPPOINTMENTS_EMPLOYEESEARCH_VIEW_DEFAULT_TITLE','Employee Details','en-US','[vikappointments id_employee=\"1\" view=\"employeesearch\" lang=\"en-US\"]',64,0),(4,'2021-11-23 14:42:38',1,'{\"employee_group\":\"0\"}','employeeslist','COM_VIKAPPOINTMENTS_EMPLOYEESLIST_VIEW_DEFAULT_TITLE','Employee List','en-US','[vikappointments employee_group=\"0\" view=\"employeeslist\" lang=\"en-US\"]',23,0),(5,'2021-11-23 14:44:25',1,'[]','order','COM_VIKAPPOINTMENTS_ORDER_VIEW_DEFAULT_TITLE','Order Overview','en-US','[vikappointments view=\"order\" lang=\"en-US\"]',70,0),(6,'2021-11-23 14:47:26',1,'{\"id_service\":\"1\"}','servicesearch','COM_VIKAPPOINTMENTS_SERVICESEARCH_VIEW_DEFAULT_TITLE','Service Details','en-US','[vikappointments id_service=\"1\" view=\"servicesearch\" lang=\"en-US\"]',73,0),(7,'2021-11-23 14:48:58',1,'{\"service_group\":\"0\"}','serviceslist','COM_VIKAPPOINTMENTS_SERVICESLIST_VIEW_DEFAULT_TITLE','Service List','*','[vikappointments service_group=\"0\" view=\"serviceslist\" lang=\"*\"]',76,0);


