osb/database/schema/mysql-schema.dump

1987 lines
103 KiB
Plaintext
Raw Permalink Normal View History

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
DROP TABLE IF EXISTS `ab_account_billing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_account_billing` (
`id` int(11) NOT NULL,
`site_id` int(11) NOT NULL,
`account_id` bigint(20) DEFAULT NULL,
`checkout_id` int(11) NOT NULL,
`service_id` bigint(20) DEFAULT NULL,
`checkout_data` blob DEFAULT NULL,
`checkout_amount` double DEFAULT NULL,
`notes` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`checkout_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`service_id`),
KEY `fk_ab_a` (`account_id`,`site_id`),
KEY `fk_ab_s` (`service_id`,`site_id`),
CONSTRAINT `fk_ab_a` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_ab_s` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_account_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_account_group` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_start` bigint(20) DEFAULT NULL,
`date_expire` bigint(20) DEFAULT NULL,
`group_id` int(11) NOT NULL DEFAULT 0,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`service_id` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`,`group_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`group_id`,`account_id`),
KEY `fk_ag_acc_idx` (`account_id`,`site_id`),
KEY `fk_ag_grp_idx` (`group_id`,`site_id`),
CONSTRAINT `fk_ag_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_ag_grp` FOREIGN KEY (`group_id`, `site_id`) REFERENCES `ab_group` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_account_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_account_log` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`ip` varchar(32) DEFAULT NULL,
`details` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
KEY `fk_al_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_al_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_account_memo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_account_memo` (
`id` bigint(20) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`staff_id` bigint(20) DEFAULT NULL,
`account_id` bigint(20) DEFAULT NULL,
`type` varchar(32) DEFAULT NULL,
`memo` varchar(255) DEFAULT NULL,
`misc` varchar(32) DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `account` (`account_id`),
KEY `memo` (`memo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_account_oauth`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_account_oauth` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`account_id` bigint(20) DEFAULT NULL,
`oauth_id` int(11) NOT NULL,
`userid` varchar(128) NOT NULL,
`oauth_data` blob DEFAULT NULL,
`user_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`oauth_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`account_id`,`oauth_id`),
UNIQUE KEY `ab_account_oauth_site_id_user_id_oauth_id_unique` (`site_id`,`user_id`,`oauth_id`),
KEY `fk_ao_o_idx` (`oauth_id`,`site_id`),
KEY `fk_ao_a_idx` (`account_id`,`site_id`),
KEY `site_user_id_idx` (`user_id`,`site_id`),
CONSTRAINT `fk_ao_a` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_ao_o` FOREIGN KEY (`oauth_id`, `site_id`) REFERENCES `ab_oauth` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `site_user_id` FOREIGN KEY (`user_id`, `site_id`) REFERENCES `users` (`id`, `site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_adsl_plan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_adsl_plan` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`adsl_supplier_plan_id` bigint(20) NOT NULL DEFAULT 0,
`contract_term` int(11) DEFAULT NULL,
`base_down_peak` double DEFAULT NULL,
`base_up_peak` double DEFAULT NULL,
`base_down_offpeak` double DEFAULT NULL,
`base_up_offpeak` double DEFAULT NULL,
`extra_charged` tinyint(4) DEFAULT NULL,
`extra_shaped` varchar(8) DEFAULT NULL,
`extra_down_peak` double DEFAULT NULL,
`extra_up_peak` double DEFAULT NULL,
`extra_down_offpeak` double DEFAULT NULL,
`extra_up_offpeak` double DEFAULT NULL,
`metric` double NOT NULL DEFAULT 0,
PRIMARY KEY (`id`,`site_id`,`adsl_supplier_plan_id`),
KEY `fk_ap_asp_idx` (`adsl_supplier_plan_id`,`site_id`),
CONSTRAINT `fk_ap_asp` FOREIGN KEY (`adsl_supplier_plan_id`, `site_id`) REFERENCES `ab_adsl_supplier_plan` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_adsl_supplier`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_adsl_supplier` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`active` tinyint(4) DEFAULT NULL,
`debug` tinyint(4) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`notes` varchar(255) DEFAULT NULL,
`provision_plugin` varchar(128) DEFAULT NULL,
`provision_plugin_data` longtext DEFAULT NULL,
`max_accounts` int(11) DEFAULT NULL,
`stats_url` varchar(256) DEFAULT NULL,
`stats_lastupdate` date DEFAULT NULL,
`stats_username` varchar(16) DEFAULT NULL,
`stats_password` varchar(16) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_as_set_idx` (`site_id`),
CONSTRAINT `fk_as_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_adsl_supplier_plan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_adsl_supplier_plan` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`supplier_id` int(11) NOT NULL DEFAULT 0,
`product_id` varchar(16) DEFAULT NULL,
`product_desc` varchar(128) DEFAULT NULL,
`base_cost` double DEFAULT NULL,
`setup_cost` double DEFAULT NULL,
`contract_term` int(11) DEFAULT NULL,
`base_down_peak` double DEFAULT NULL,
`base_up_peak` double DEFAULT NULL,
`base_down_offpeak` double DEFAULT NULL,
`base_up_offpeak` double DEFAULT NULL,
`extra_charged` tinyint(4) DEFAULT NULL,
`extra_shaped` varchar(8) DEFAULT NULL,
`offpeak_start` bigint(20) DEFAULT NULL,
`offpeak_end` bigint(20) DEFAULT NULL,
`extra_down_peak` double DEFAULT NULL,
`extra_up_peak` double DEFAULT NULL,
`extra_down_offpeak` double DEFAULT NULL,
`extra_up_offpeak` double DEFAULT NULL,
`metric` double NOT NULL DEFAULT 0,
`speed` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`supplier_id`),
KEY `fk_asp_as_idx` (`supplier_id`,`site_id`),
CONSTRAINT `fk_asp_as` FOREIGN KEY (`supplier_id`, `site_id`) REFERENCES `ab_adsl_supplier` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_affiliate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_affiliate` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`avail_campaign_id` longtext DEFAULT NULL,
`affiliate_plugin` varchar(32) DEFAULT NULL,
`parent_affiliate_id` varchar(16) DEFAULT NULL,
`max_tiers` int(11) DEFAULT NULL,
`commission_minimum` double DEFAULT NULL,
`new_commission_type` tinyint(4) DEFAULT NULL,
`new_commission_rate` longtext DEFAULT NULL,
`recurr_commission_type` tinyint(4) DEFAULT NULL,
`recurr_commission_rate` longtext DEFAULT NULL,
`recurr_max_commission_periods` int(11) DEFAULT NULL,
`plugin_data` longtext DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
KEY `fk_aff_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_aff_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_asset`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_asset` (
`id` bigint(20) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`service_id` bigint(20) DEFAULT NULL,
`pool_id` int(11) DEFAULT NULL,
`asset` varchar(128) DEFAULT NULL,
`misc` varchar(255) DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `assets` (`id`,`site_id`),
KEY `asso` (`pool_id`),
KEY `service` (`service_id`),
KEY `asset` (`asset`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_asset_pool`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_asset_pool` (
`id` int(11) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `main` (`id`,`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_cart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_cart` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`session_id` varchar(32) NOT NULL DEFAULT '',
`quantity` int(11) DEFAULT NULL,
`module_id` int(11) NOT NULL DEFAULT 0,
`module_item` int(11) NOT NULL DEFAULT 0,
`module_data` text DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_mod_crt_idx` (`module_id`,`site_id`),
CONSTRAINT `fk_mod_crt` FOREIGN KEY (`module_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_charge`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_charge` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`processed` tinyint(4) DEFAULT NULL,
`sweep_type` int(11) DEFAULT NULL,
`type` int(11) DEFAULT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`product_id` bigint(20) DEFAULT NULL,
`service_id` bigint(20) DEFAULT NULL,
`date_charge` bigint(20) DEFAULT NULL,
`amount` double DEFAULT NULL,
`quantity` double DEFAULT NULL,
`taxable` tinyint(4) DEFAULT NULL,
`attributes` blob DEFAULT NULL,
`description` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
KEY `fk_chg_acc_idx` (`account_id`,`site_id`),
KEY `fk_chg_svc_idx` (`service_id`,`site_id`),
KEY `fk_chg_pdt_idx` (`product_id`,`site_id`),
CONSTRAINT `fk_chg_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_chg_pdt` FOREIGN KEY (`product_id`, `site_id`) REFERENCES `ab_product` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_chg_svc` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_checkout`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_checkout` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`active` tinyint(4) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`plugin` varchar(32) DEFAULT NULL,
`plugin_data` longtext DEFAULT NULL,
`graphic_url` varchar(128) DEFAULT NULL,
`amount_min` double DEFAULT 0,
`amount_max` double DEFAULT NULL,
`fee_fixed` double DEFAULT NULL,
`fee_variable` double DEFAULT NULL,
`fee_passon` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_cko_set_idx` (`site_id`),
CONSTRAINT `fk_cko_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_checkout_notify`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_checkout_notify` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`checkout_id` int(11) NOT NULL,
`active` tinyint(4) DEFAULT NULL,
`data` blob NOT NULL,
`processed` tinyint(4) DEFAULT NULL,
`result` text DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`checkout_id`),
KEY `fk_cn_c_idx` (`checkout_id`,`site_id`),
CONSTRAINT `fk_cn_c` FOREIGN KEY (`checkout_id`, `site_id`) REFERENCES `ab_checkout` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_country`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_country` (
`id` int(11) NOT NULL DEFAULT 0,
`name` varchar(128) DEFAULT NULL,
`description` varchar(128) DEFAULT NULL,
`notes` varchar(128) DEFAULT NULL,
`two_code` varchar(16) DEFAULT NULL,
`three_code` varchar(16) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`currency_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `two_code_UNIQUE` (`two_code`),
UNIQUE KEY `three_code_UNIQUE` (`three_code`),
UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_currency`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_currency` (
`id` int(11) NOT NULL DEFAULT 0,
`country_id` int(11) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`convert_array` longtext DEFAULT NULL,
`notes` varchar(128) DEFAULT NULL,
`symbol` varchar(16) DEFAULT NULL,
`iso_code` varchar(3) DEFAULT NULL,
`rounding` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `three_digit_UNIQUE` (`iso_code`),
KEY `fk_cur_cty_idx` (`country_id`),
CONSTRAINT `fk_cur_cty` FOREIGN KEY (`country_id`) REFERENCES `ab_country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_discount`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_discount` (
`id` bigint(20) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`date_start` bigint(20) DEFAULT NULL,
`date_expire` bigint(20) DEFAULT NULL,
`name` varchar(64) DEFAULT NULL,
`notes` longtext DEFAULT NULL,
`max_usage_account` int(11) DEFAULT NULL,
`max_usage_global` int(11) DEFAULT NULL,
`avail_account_id` bigint(20) DEFAULT NULL,
`avail_product_id` longtext DEFAULT NULL,
`avail_group_id` longtext DEFAULT NULL,
`avail_tld_id` longtext DEFAULT NULL,
`new_status` tinyint(4) DEFAULT NULL,
`new_type` tinyint(4) DEFAULT NULL,
`new_rate` double DEFAULT NULL,
`new_max_discount` double DEFAULT NULL,
`new_min_cost` double DEFAULT NULL,
`recurr_status` tinyint(4) DEFAULT NULL,
`recurr_type` tinyint(4) DEFAULT NULL,
`recurr_rate` double DEFAULT NULL,
`recurr_max_discount` double DEFAULT NULL,
`recurr_min_cost` double DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `start` (`date_start`),
KEY `expire` (`date_expire`),
KEY `status` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_domain_registrar`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_domain_registrar` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`active` tinyint(4) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`file` varchar(32) DEFAULT NULL,
`whitelabel_url` varchar(256) DEFAULT NULL,
`whitelabel_ns` varchar(1024) DEFAULT NULL,
`manage_url` varchar(256) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `fk_hrp_set` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_domain_tld`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_domain_tld` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`taxable` tinyint(4) DEFAULT NULL,
`whois_plugin` varchar(32) DEFAULT NULL,
`whois_plugin_data` longtext DEFAULT NULL,
`registrar_plugin_id` int(11) NOT NULL DEFAULT 0,
`registrar_plugin_data` longtext DEFAULT NULL,
`auto_search` tinyint(4) DEFAULT NULL,
`default_term_new` int(11) DEFAULT NULL,
`price_group` longtext DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`registrar_plugin_id`),
KEY `fk_ht_hrp_idx` (`registrar_plugin_id`,`site_id`),
CONSTRAINT `fk_ht_hrp` FOREIGN KEY (`registrar_plugin_id`, `site_id`) REFERENCES `ab_domain_registrar` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_email_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_email_log` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`email_template_translate_id` bigint(20) DEFAULT NULL,
`email` varchar(128) DEFAULT NULL,
`subject` varchar(128) DEFAULT NULL,
`message` longtext DEFAULT NULL,
`html` tinyint(4) DEFAULT NULL,
`urgent` tinyint(4) DEFAULT NULL,
`userread` tinyint(4) DEFAULT NULL,
`data` blob DEFAULT NULL,
`module_id` int(11) DEFAULT NULL,
`module_data` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
KEY `fk_el_ett_idx` (`email_template_translate_id`,`site_id`),
KEY `fk_el_acc_idx` (`account_id`,`site_id`),
KEY `fk_el_mod_idx` (`module_id`,`site_id`),
CONSTRAINT `fk_el_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_el_ett` FOREIGN KEY (`email_template_translate_id`, `site_id`) REFERENCES `ab_email_template_translate` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_el_mod` FOREIGN KEY (`module_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_email_setup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_email_setup` (
`id` int(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`name` varchar(128) DEFAULT NULL,
`notes` longtext DEFAULT NULL,
`type` tinyint(4) DEFAULT NULL,
`from_name` varchar(128) DEFAULT NULL,
`from_email` varchar(128) DEFAULT NULL,
`cc_list` longtext DEFAULT NULL,
`bcc_list` longtext DEFAULT NULL,
`server` varchar(128) DEFAULT NULL,
`username` varchar(128) DEFAULT NULL,
`password` varchar(128) DEFAULT NULL,
`piping` varchar(4) DEFAULT NULL,
`piping_host` varchar(128) DEFAULT NULL,
`piping_username` varchar(128) DEFAULT NULL,
`piping_password` varchar(128) DEFAULT NULL,
`piping_action` varchar(4) DEFAULT NULL,
`queue` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
KEY `fk_es_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_es_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_email_template`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_email_template` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`active` tinyint(4) DEFAULT NULL,
`email_setup_id` int(11) NOT NULL DEFAULT 0,
`name` varchar(128) DEFAULT NULL,
`description` varchar(32) DEFAULT NULL,
`notes` longtext DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`email_setup_id`),
KEY `fk_et_es_idx` (`email_setup_id`,`site_id`),
CONSTRAINT `fk_et_es` FOREIGN KEY (`email_setup_id`, `site_id`) REFERENCES `ab_email_setup` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_email_template_translate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_email_template_translate` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`email_template_id` bigint(20) NOT NULL DEFAULT 0,
`language_id` int(11) NOT NULL DEFAULT 0,
`subject` varchar(255) NOT NULL,
`message_text` longtext NOT NULL,
`message_html` longtext DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`email_template_id`,`language_id`),
KEY `fk_emt_et_idx` (`email_template_id`,`site_id`),
KEY `fk_emt_lan_idx` (`language_id`),
CONSTRAINT `fk_emt_et` FOREIGN KEY (`email_template_id`, `site_id`) REFERENCES `ab_email_template` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_emt_lan` FOREIGN KEY (`language_id`) REFERENCES `ab_language` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_export`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_export` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`name` varchar(128) NOT NULL DEFAULT '',
`plugin` varchar(128) NOT NULL DEFAULT '',
`active` tinyint(4) DEFAULT NULL,
`url` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`name`),
KEY `fk_exp_set_idx` (`site_id`),
CONSTRAINT `fk_exp_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_export_datamap`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_export_datamap` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`export_module_id` bigint(20) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`item_id` bigint(20) DEFAULT NULL,
`module_id` int(11) NOT NULL,
`map_data` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`export_module_id`,`module_id`),
UNIQUE KEY `UNIQUE` (`item_id`,`export_module_id`,`site_id`),
KEY `fk_edm_mod_idx` (`export_module_id`,`site_id`),
KEY `fk_edm_mod_idx1` (`module_id`,`site_id`),
CONSTRAINT `fk_edm_exm` FOREIGN KEY (`export_module_id`, `site_id`) REFERENCES `ab_export_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_edm_mod` FOREIGN KEY (`module_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_export_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_export_item` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`export_module_id` bigint(20) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`item_id` bigint(20) NOT NULL DEFAULT 0,
`reference` varchar(64) DEFAULT NULL,
`crc` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`export_module_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`export_module_id`,`item_id`),
KEY `fk_exp_eit_idx` (`export_module_id`,`site_id`),
CONSTRAINT `fk_eit_exm` FOREIGN KEY (`export_module_id`, `site_id`) REFERENCES `ab_export_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_export_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_export_module` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`export_id` bigint(20) NOT NULL DEFAULT 0,
`module_id` int(11) NOT NULL DEFAULT 0,
`display` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`export_id`,`module_id`),
KEY `fk_exp_exm_idx` (`export_id`,`site_id`),
KEY `fk_exp_mod_idx` (`module_id`,`site_id`),
CONSTRAINT `fk_exm_exp` FOREIGN KEY (`export_id`, `site_id`) REFERENCES `ab_export` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_exm_mod` FOREIGN KEY (`module_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_group` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_start` bigint(20) DEFAULT NULL,
`date_expire` bigint(20) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`pricing` tinyint(4) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`notes` longtext DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_grp_set_idx` (`site_id`),
CONSTRAINT `fk_grp_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_group_method`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_group_method` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`method_id` int(11) NOT NULL DEFAULT 0,
`group_id` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`,`site_id`,`method_id`,`group_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
KEY `fk_gm_mm_idx` (`method_id`,`site_id`),
KEY `fk_gm_grp_idx` (`group_id`,`site_id`),
CONSTRAINT `fk_gm_grp` FOREIGN KEY (`group_id`, `site_id`) REFERENCES `ab_group` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_gm_mm` FOREIGN KEY (`method_id`, `site_id`) REFERENCES `ab_module_method` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_host_server`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_host_server` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`active` tinyint(4) DEFAULT NULL,
`debug` tinyint(4) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`notes` varchar(255) DEFAULT NULL,
`provision_plugin` varchar(128) DEFAULT NULL,
`provision_plugin_data` longtext DEFAULT NULL,
`max_accounts` int(11) DEFAULT NULL,
`whitelabel_url` varchar(256) DEFAULT NULL,
`manage_url` varchar(256) DEFAULT NULL,
`manage_username` varchar(45) DEFAULT NULL,
`manage_password` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
UNIQUE KEY `IDS` (`site_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_host_server_affiliate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_host_server_affiliate` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`affiliate_id` bigint(20) NOT NULL,
`host_server_id` int(11) NOT NULL,
`host_username` varchar(45) DEFAULT NULL,
`host_password` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`affiliate_id`,`host_server_id`),
KEY `fk_hsa_aff_idx` (`affiliate_id`,`site_id`),
KEY `fk_hsa_hs_idx` (`host_server_id`,`site_id`),
CONSTRAINT `fk_hsa_aff` FOREIGN KEY (`affiliate_id`, `site_id`) REFERENCES `ab_affiliate` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_hsa_hs` FOREIGN KEY (`host_server_id`, `site_id`) REFERENCES `ab_host_server` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_host_server_id`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_host_server_id` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_host_tld_id`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_host_tld_id` (
`id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_import`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_import` (
`id` bigint(20) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`plugin` varchar(32) DEFAULT NULL,
`action` varchar(32) DEFAULT NULL,
`remote_table` varchar(32) DEFAULT NULL,
`ab_table` varchar(32) DEFAULT NULL,
`remote_id` bigint(20) DEFAULT NULL,
`ab_id` bigint(20) DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_invoice`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_invoice` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`process_status` tinyint(4) DEFAULT NULL,
`billing_status` tinyint(4) DEFAULT NULL,
`print_status` tinyint(4) DEFAULT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`account_billing_id` int(11) DEFAULT NULL,
`discount_amt` double DEFAULT NULL,
`due_date` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`reminders` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
KEY `fk_inv_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_inv_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_invoice_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_invoice_item` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`service_id` bigint(20) DEFAULT NULL,
`invoice_id` bigint(20) NOT NULL,
`active` tinyint(1) DEFAULT NULL,
`product_id` bigint(20) DEFAULT NULL,
`module_id` int(11) DEFAULT NULL,
`module_ref` bigint(20) DEFAULT NULL,
`quantity` double DEFAULT NULL,
`item_type` tinyint(4) DEFAULT NULL,
`product_name` varchar(128) DEFAULT NULL,
`discount_amt` double DEFAULT NULL,
`price_base` double DEFAULT NULL,
`recurring_schedule` int(11) DEFAULT NULL,
`date_start` bigint(20) DEFAULT NULL,
`date_stop` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`invoice_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
KEY `fk_ii_inv_idx` (`invoice_id`,`site_id`),
KEY `fk_ii_pdt_idx` (`product_id`,`site_id`),
KEY `fk_ii_svc_idx` (`service_id`,`site_id`),
KEY `fk_ii_mod_idx` (`module_id`,`site_id`),
CONSTRAINT `fk_ii_inv` FOREIGN KEY (`invoice_id`, `site_id`) REFERENCES `ab_invoice` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_ii_mod` FOREIGN KEY (`module_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_ii_pdt` FOREIGN KEY (`product_id`, `site_id`) REFERENCES `ab_product` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_ii_svc` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_invoice_item_discount`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_invoice_item_discount` (
`id` int(11) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`invoice_id` bigint(20) DEFAULT NULL,
`account_id` bigint(20) DEFAULT NULL,
`invoice_item_id` bigint(20) DEFAULT NULL,
`discount` varchar(64) DEFAULT NULL,
`amount` double DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `discounts` (`discount`),
KEY `invoice_id` (`invoice_id`,`invoice_item_id`),
KEY `dates` (`date_orig`),
KEY `accounts` (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_invoice_item_tax`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_invoice_item_tax` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`invoice_item_id` bigint(20) NOT NULL DEFAULT 0,
`tax_id` int(11) NOT NULL DEFAULT 0,
`amount` double NOT NULL DEFAULT 0,
PRIMARY KEY (`id`,`site_id`,`invoice_item_id`,`tax_id`),
KEY `fk_iit_ii_idx` (`invoice_item_id`,`site_id`),
KEY `fk_iit_tax_idx` (`tax_id`),
CONSTRAINT `fk_iit_ii` FOREIGN KEY (`invoice_item_id`, `site_id`) REFERENCES `ab_invoice_item` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_iit_tax` FOREIGN KEY (`tax_id`) REFERENCES `ab_tax` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_invoice_memo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_invoice_memo` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`invoice_id` bigint(20) NOT NULL DEFAULT 0,
`account_id` bigint(20) DEFAULT NULL,
`type` varchar(32) DEFAULT NULL,
`memo` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`invoice_id`),
KEY `fk_im_inv_idx` (`invoice_id`,`site_id`),
KEY `fk_im_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_im_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_im_inv` FOREIGN KEY (`invoice_id`, `site_id`) REFERENCES `ab_invoice` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_language`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_language` (
`id` int(11) NOT NULL,
`name` varchar(45) DEFAULT NULL,
`iso` varchar(5) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name_UNIQUE` (`name`),
UNIQUE KEY `iso_UNIQUE` (`iso`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_log_error`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_log_error` (
`id` bigint(20) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`account_id` bigint(20) DEFAULT NULL,
`module` varchar(64) DEFAULT NULL,
`method` varchar(64) DEFAULT NULL,
`message` longtext DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_module`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_module` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`name` varchar(128) NOT NULL DEFAULT '',
`date_orig` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`parent_id` int(11) DEFAULT NULL,
`notes` longtext DEFAULT NULL,
`external` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`name`),
KEY `fk_mod_set_idx` (`site_id`),
KEY `fk_mod_idx` (`parent_id`,`site_id`),
CONSTRAINT `fk_mod` FOREIGN KEY (`parent_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_mod_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_module_method`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_module_method` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`module_id` int(11) NOT NULL DEFAULT 0,
`name` varchar(64) DEFAULT '',
`notes` varchar(128) DEFAULT NULL,
`menu_display` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`module_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
UNIQUE KEY `UNIQUE2` (`site_id`,`module_id`,`name`),
KEY `fk_mm_mod_idx` (`module_id`,`site_id`),
CONSTRAINT `fk_mm_mod` FOREIGN KEY (`module_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_module_method_token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_module_method_token` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`method_id` int(11) NOT NULL DEFAULT 0,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`token` varchar(36) NOT NULL DEFAULT '',
`date_orig` bigint(20) NOT NULL DEFAULT 0,
`date_last` bigint(20) DEFAULT NULL,
`date_expire` bigint(20) DEFAULT NULL,
`uses` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`method_id`,`account_id`),
KEY `fk_mmt_mm_idx` (`method_id`,`site_id`),
KEY `fk_mmt_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_mmt_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_mmt_mm` FOREIGN KEY (`method_id`, `site_id`) REFERENCES `ab_module_method` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_oauth`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_oauth` (
`id` int(11) NOT NULL,
`site_id` int(11) NOT NULL,
`active` tinyint(4) DEFAULT NULL,
`name` varchar(32) NOT NULL,
`app_id` varchar(128) DEFAULT NULL,
`secret` varchar(128) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
UNIQUE KEY `ab_oauth_site_id_name_unique` (`site_id`,`name`),
KEY `fk_o_set_idx` (`site_id`),
CONSTRAINT `fk_o_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_payment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_payment` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`date_payment` bigint(20) DEFAULT NULL,
`checkout_id` int(11) NOT NULL DEFAULT 0,
`checkout_data` varchar(255) DEFAULT NULL,
`total_amt` double DEFAULT NULL,
`fees_amt` double DEFAULT NULL,
`source_id` bigint(20) DEFAULT NULL,
`pending_status` tinyint(4) DEFAULT NULL,
`notes` text DEFAULT NULL,
`ip` varchar(32) DEFAULT NULL,
`pending` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`,`checkout_id`,`account_id`,`site_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
KEY `fk_pay_acc_idx` (`account_id`,`site_id`),
KEY `fk_pay_cp_idx` (`checkout_id`,`site_id`),
KEY `fk_pay_acc_b_idx` (`source_id`,`site_id`),
CONSTRAINT `fk_pay_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_pay_acc_b` FOREIGN KEY (`source_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_pay_co` FOREIGN KEY (`checkout_id`, `site_id`) REFERENCES `ab_checkout` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_payment_item`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_payment_item` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`payment_id` bigint(20) NOT NULL DEFAULT 0,
`invoice_id` bigint(20) DEFAULT NULL,
`alloc_amt` double DEFAULT NULL,
PRIMARY KEY (`id`,`payment_id`,`site_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
KEY `fk_pi_pay_idx` (`payment_id`,`site_id`),
KEY `fk_pi_inv_idx` (`invoice_id`,`site_id`),
CONSTRAINT `fk_pi_inv` FOREIGN KEY (`invoice_id`, `site_id`) REFERENCES `ab_invoice` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_pi_pay` FOREIGN KEY (`payment_id`, `site_id`) REFERENCES `ab_payment` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_pivot_product_cat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_pivot_product_cat` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL,
`product_id` bigint(20) DEFAULT NULL,
`product_cat_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`product_id`,`product_cat_id`),
KEY `fk_pc_idx` (`product_cat_id`,`site_id`),
KEY `fk_p_idx` (`product_id`,`site_id`),
CONSTRAINT `fk_p` FOREIGN KEY (`product_id`, `site_id`) REFERENCES `ab_product` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_pc` FOREIGN KEY (`product_cat_id`, `site_id`) REFERENCES `ab_product_cat` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_product` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`taxable` tinyint(4) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`position` tinyint(4) DEFAULT NULL,
`cart_multiple` tinyint(4) DEFAULT NULL,
`group_avail` blob DEFAULT NULL,
`avail_category` blob DEFAULT NULL,
`price_type` tinyint(4) DEFAULT NULL,
`price_group` blob DEFAULT NULL,
`price_recurr_default` tinyint(4) DEFAULT NULL,
`price_recurr_day` tinyint(4) DEFAULT NULL,
`price_recurr_weekday` tinyint(4) DEFAULT NULL,
`price_recurr_strict` tinyint(4) DEFAULT NULL,
`prod_plugin_file` varchar(128) DEFAULT NULL,
`prod_plugin_data` blob DEFAULT NULL,
`accounting` varchar(64) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_pdt_set_idx` (`site_id`),
CONSTRAINT `fk_pdt_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_product_cat`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_product_cat` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`parent_id` int(11) DEFAULT NULL,
`group_avail` blob DEFAULT NULL,
`notes` blob DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`template` varchar(128) DEFAULT NULL,
`position` int(11) DEFAULT NULL,
`recur_schedule` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_pc_set_idx` (`site_id`),
KEY `fk_pc_pc_idx` (`parent_id`),
CONSTRAINT `fk_pc_pc` FOREIGN KEY (`parent_id`) REFERENCES `ab_product_cat` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_pc_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_product_cat_translate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_product_cat_translate` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`product_cat_id` int(11) NOT NULL DEFAULT 0,
`language_id` int(11) NOT NULL DEFAULT 0,
`name` varchar(128) DEFAULT NULL,
`description` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`product_cat_id`,`language_id`),
UNIQUE KEY `UNIQUE` (`site_id`,`product_cat_id`,`language_id`),
KEY `fk_pct_pc_idx` (`product_cat_id`,`site_id`),
KEY `fk_pct_lan_idx` (`language_id`),
CONSTRAINT `fk_pct_lan` FOREIGN KEY (`language_id`) REFERENCES `ab_language` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_pct_pc` FOREIGN KEY (`product_cat_id`, `site_id`) REFERENCES `ab_product_cat` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_product_translate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_product_translate` (
`id` int(11) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`product_id` bigint(20) NOT NULL DEFAULT 0,
`language_id` int(11) NOT NULL DEFAULT 0,
`name` varchar(128) DEFAULT NULL,
`description_short` longtext DEFAULT NULL,
`description_full` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`product_id`,`language_id`),
UNIQUE KEY `UNIQUE` (`product_id`,`language_id`,`site_id`),
KEY `fk_pt_p_idx` (`site_id`,`product_id`),
KEY `fk_pt_l_idx` (`language_id`),
CONSTRAINT `fk_pt_l` FOREIGN KEY (`language_id`) REFERENCES `ab_language` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_pt_p` FOREIGN KEY (`site_id`, `product_id`) REFERENCES `ab_product` (`site_id`, `id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_record_id`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_record_id` (
`site_id` int(11) NOT NULL DEFAULT 0,
`module_id` int(11) NOT NULL DEFAULT 0,
`id` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`site_id`,`module_id`),
KEY `fk_rid_set_idx` (`site_id`),
KEY `fk_rid_mod_idx` (`module_id`,`site_id`),
CONSTRAINT `fk_rid_mod` FOREIGN KEY (`module_id`, `site_id`) REFERENCES `ab_module` (`id`, `site_id`),
CONSTRAINT `fk_rid_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_rtm`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_rtm` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`name` varchar(64) NOT NULL DEFAULT '',
`parent_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
UNIQUE KEY `uq_name` (`name`),
KEY `fk_rtm_set_idx` (`account_id`,`site_id`),
KEY `fk_rtm_acc_p_idx` (`parent_id`),
CONSTRAINT `fk_rtm_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_rtm_rtm` FOREIGN KEY (`parent_id`) REFERENCES `ab_rtm` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`account_billing_id` bigint(20) DEFAULT NULL,
`product_id` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`suspend_billing` tinyint(4) DEFAULT NULL,
`external_billing` tinyint(4) DEFAULT NULL,
`price` double DEFAULT NULL,
`price_group` int(11) NOT NULL DEFAULT 0,
`price_override` double DEFAULT NULL,
`taxable` tinyint(4) DEFAULT NULL,
`queue` varchar(16) DEFAULT NULL,
`date_last_invoice` bigint(20) DEFAULT NULL,
`date_next_invoice` bigint(20) DEFAULT NULL,
`recur_schedule` int(11) DEFAULT NULL,
`prod_attr` longtext DEFAULT NULL,
`date_start` bigint(20) DEFAULT NULL,
`date_end` bigint(20) DEFAULT NULL,
`orderby_id` int(10) unsigned DEFAULT NULL,
`order_status` varchar(191) DEFAULT NULL,
`order_info` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`price_group`),
UNIQUE KEY `UNIQUE` (`site_id`,`id`,`account_id`),
KEY `fk_svc_acc_idx` (`account_id`,`site_id`),
KEY `fk_svc_grp_idx` (`site_id`,`price_group`),
KEY `ab_service_orderby_id_foreign` (`orderby_id`),
CONSTRAINT `ab_service_orderby_id_foreign` FOREIGN KEY (`orderby_id`) REFERENCES `users` (`id`),
CONSTRAINT `fk_svc_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_svc_grp` FOREIGN KEY (`site_id`, `price_group`) REFERENCES `ab_group` (`site_id`, `id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service__adsl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service__adsl` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`service_id` bigint(20) NOT NULL DEFAULT 0,
`provided_adsl_plan_id` bigint(20) DEFAULT NULL,
`service_number` varchar(10) DEFAULT NULL,
`service_address` varchar(128) DEFAULT NULL,
`contract_term` int(11) DEFAULT NULL,
`service_connect_date` bigint(20) DEFAULT NULL,
`service_contract_date` bigint(20) DEFAULT NULL,
`service_username` varchar(128) DEFAULT NULL,
`service_password` varchar(16) DEFAULT NULL,
`service_stats_collect` tinyint(4) DEFAULT NULL,
`service_stats_lastupdate` date DEFAULT NULL,
`ipaddress` varchar(45) DEFAULT NULL,
`offpeak_start` time DEFAULT NULL,
`offpeak_end` time DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`service_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
UNIQUE KEY `uq_service_username` (`service_username`),
KEY `fk_service_number` (`service_number`),
KEY `fk_sa_svc_idx` (`service_id`,`site_id`),
KEY `fk_sa_ap_idx` (`provided_adsl_plan_id`,`site_id`),
CONSTRAINT `fk_sa_ap` FOREIGN KEY (`provided_adsl_plan_id`, `site_id`) REFERENCES `ab_adsl_plan` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sa_svc` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service__adsl_traffic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service__adsl_traffic` (
`site_id` int(11) NOT NULL DEFAULT 0,
`date` date NOT NULL,
`service` varchar(128) DEFAULT NULL,
`supplier_id` int(11) NOT NULL,
`up_peak` int(11) DEFAULT NULL,
`up_offpeak` int(11) DEFAULT NULL,
`down_peak` int(11) DEFAULT NULL,
`down_offpeak` int(11) DEFAULT NULL,
`peer` int(11) DEFAULT NULL,
`internal` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`ab_service_adsl_id` bigint(20) DEFAULT NULL,
UNIQUE KEY `ab_service__adsl_traffic_ab_service_adsl_id_date_time_unique` (`ab_service_adsl_id`,`date`,`time`),
KEY `in_sat_SERVICE` (`service`),
KEY `in_sat_DATE` (`date`),
KEY `in_sat_SERVICE_DATE` (`service`,`date`),
KEY `fk_sat_as_idx` (`supplier_id`,`site_id`),
CONSTRAINT `ab_service__adsl_traffic_ab_service_adsl_id_foreign` FOREIGN KEY (`ab_service_adsl_id`) REFERENCES `ab_service__adsl` (`id`),
CONSTRAINT `fk_sat_as` FOREIGN KEY (`supplier_id`, `site_id`) REFERENCES `ab_adsl_supplier` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service__domain`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service__domain` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`service_id` bigint(20) NOT NULL DEFAULT 0,
`domain_tld_id` int(11) NOT NULL DEFAULT 0,
`domain_registrar_id` int(11) NOT NULL DEFAULT 0,
`domain_name` varchar(128) DEFAULT NULL,
`domain_expire` bigint(20) DEFAULT NULL,
`registrar_type` varchar(16) DEFAULT NULL,
`registrar_username` varchar(128) DEFAULT NULL,
`registrar_password` varchar(128) DEFAULT NULL,
`registrar_auth_password` varchar(128) DEFAULT NULL,
`registrar_pending_transfer` varchar(16) DEFAULT NULL,
`registrar_ns` varchar(1024) DEFAULT NULL,
`registrar_lastsync` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`service_id`,`domain_tld_id`,`domain_registrar_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
KEY `fk_sd_svc_idx` (`service_id`,`site_id`),
KEY `fk_sd_hrp_idx` (`domain_registrar_id`,`site_id`),
KEY `fk_sd_ht_idx` (`domain_tld_id`,`site_id`),
CONSTRAINT `fk_sd_hrp` FOREIGN KEY (`domain_registrar_id`, `site_id`) REFERENCES `ab_domain_registrar` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sd_ht` FOREIGN KEY (`domain_tld_id`, `site_id`) REFERENCES `ab_domain_tld` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sd_svc` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Contain Service Information for HOST_TLD records';
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service__hosting`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service__hosting` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`service_id` bigint(20) NOT NULL DEFAULT 0,
`domain_tld_id` int(11) NOT NULL DEFAULT 0,
`host_server_id` int(11) NOT NULL DEFAULT 0,
`domain_name` varchar(128) DEFAULT NULL,
`host_expire` bigint(20) DEFAULT NULL,
`host_type` varchar(16) DEFAULT NULL,
`host_username` varchar(45) DEFAULT NULL,
`host_password` varchar(45) DEFAULT NULL,
`ftp_username` varchar(16) DEFAULT NULL,
`ftp_password` varchar(16) DEFAULT NULL,
`server_data` blob DEFAULT NULL,
`server_data_date` text DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`service_id`,`domain_tld_id`,`host_server_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
UNIQUE KEY `uq_ftp_username` (`host_server_id`,`ftp_username`),
KEY `fk_service_id` (`service_id`,`site_id`),
KEY `fk_domain_tld_id` (`domain_tld_id`,`site_id`),
KEY `fk_sh_hs_idx` (`host_server_id`,`site_id`),
CONSTRAINT `fk_sh_hs` FOREIGN KEY (`host_server_id`, `site_id`) REFERENCES `ab_host_server` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sh_ht` FOREIGN KEY (`domain_tld_id`, `site_id`) REFERENCES `ab_domain_tld` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sh_svc` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service__ssl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service__ssl` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`service_id` bigint(20) NOT NULL,
`ssl_ca_id` bigint(20) DEFAULT NULL,
`csr` text NOT NULL,
`pk` text DEFAULT NULL,
`cert` text DEFAULT NULL,
PRIMARY KEY (`id`,`service_id`,`site_id`),
UNIQUE KEY `UNIQUE` (`id`,`site_id`),
KEY `fk_ss_svc_idx` (`service_id`,`site_id`),
KEY `fk_ss_sca_idx` (`ssl_ca_id`,`site_id`),
CONSTRAINT `fk_ss_sca` FOREIGN KEY (`ssl_ca_id`, `site_id`) REFERENCES `ab_ssl_ca` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_ss_svc` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service__voip`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service__voip` (
`id` bigint(20) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`service_id` bigint(20) DEFAULT NULL,
`service_number` varchar(10) DEFAULT NULL,
`service_address` varchar(128) DEFAULT NULL,
`contract_term` int(11) DEFAULT NULL,
`service_connect_date` bigint(20) DEFAULT NULL,
`service_contract_date` bigint(20) DEFAULT NULL,
`service_username` varchar(128) DEFAULT NULL,
`service_password` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service_change`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service_change` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`service_id` bigint(20) NOT NULL,
`product_id` bigint(20) NOT NULL,
`ordered_by` bigint(20) NOT NULL,
`date_ordered` bigint(20) DEFAULT NULL,
`date_effective` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`complete` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`service_id`,`product_id`,`ordered_by`),
KEY `fk_s_sc_idx` (`site_id`,`id`),
KEY `fk_s_p_idx` (`site_id`,`product_id`),
KEY `fk_sc_a_idx` (`site_id`,`ordered_by`),
CONSTRAINT `fk_sc_a` FOREIGN KEY (`site_id`, `ordered_by`) REFERENCES `accounts` (`site_id`, `id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sc_p` FOREIGN KEY (`site_id`, `product_id`) REFERENCES `ab_product` (`site_id`, `id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sc_s` FOREIGN KEY (`site_id`, `id`) REFERENCES `ab_service` (`site_id`, `id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_service_memo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_service_memo` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`service_id` bigint(20) NOT NULL DEFAULT 0,
`account_id` bigint(20) DEFAULT NULL,
`type` varchar(32) DEFAULT NULL,
`memo` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`service_id`),
KEY `fk_sm_svc_idx` (`service_id`,`site_id`),
KEY `fk_sm_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_sm_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sm_svc` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_setup_invoice`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_setup_invoice` (
`id` int(11) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`bill_to_company` tinyint(4) DEFAULT NULL,
`invoice_currency` varchar(8) DEFAULT NULL,
`invoice_decimals` int(11) DEFAULT NULL,
`items_summary_max` int(11) DEFAULT NULL,
`news` text DEFAULT NULL,
`page_type` varchar(8) DEFAULT NULL,
`invoice_delivery` int(11) DEFAULT NULL,
`invoice_show_itemized` tinyint(4) DEFAULT NULL,
`invoice_show_service_dates` tinyint(4) DEFAULT NULL,
`invoice_grace` int(11) DEFAULT NULL,
`invoice_advance_gen` int(11) DEFAULT NULL,
`invoice_terms` int(11) DEFAULT NULL,
`invoice_pdf_plugin` varchar(16) DEFAULT NULL,
`contact_us_url` varchar(64) DEFAULT NULL,
`contact_us_phone` varchar(64) DEFAULT NULL,
`advance_notice` int(11) DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_ssl`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_ssl` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`extensions` varchar(64) NOT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_ssl_set_idx` (`site_id`),
CONSTRAINT `fk_ssl_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_ssl_ca`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_ssl_ca` (
`id` bigint(20) NOT NULL,
`site_id` int(11) NOT NULL,
`account_id` bigint(20) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`sign_pk` text NOT NULL,
`sign_cert` text NOT NULL,
`parent_ssl_ca_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`account_id`),
KEY `fk_sca_idx` (`parent_ssl_ca_id`,`site_id`),
KEY `fk_sca_acc_idx` (`account_id`,`site_id`),
CONSTRAINT `fk_sca` FOREIGN KEY (`parent_ssl_ca_id`, `site_id`) REFERENCES `ab_ssl_ca` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_sca_acc` FOREIGN KEY (`account_id`, `site_id`) REFERENCES `accounts` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_static_page`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_static_page` (
`id` int(11) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`static_page_category_id` int(11) DEFAULT NULL,
`date_start` bigint(20) DEFAULT NULL,
`date_expire` bigint(20) DEFAULT NULL,
`sort_order` int(11) DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`description` longtext DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `cat` (`static_page_category_id`),
KEY `start` (`date_start`),
KEY `expire` (`date_expire`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_static_page_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_static_page_category` (
`id` int(11) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`group_avail` varchar(255) DEFAULT NULL,
`name` varchar(128) DEFAULT NULL,
`description` longtext DEFAULT NULL,
`active` tinyint(4) DEFAULT NULL,
`sort_order` int(11) DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`),
KEY `name` (`name`),
KEY `status` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_static_page_translate`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_static_page_translate` (
`id` int(11) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`static_page_id` int(11) DEFAULT NULL,
`language_id` varchar(16) DEFAULT NULL,
`body_intro` longtext DEFAULT NULL,
`body_full` longtext DEFAULT NULL,
`title` varchar(128) DEFAULT NULL,
UNIQUE KEY `IDS` (`site_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_task`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_task` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`date_run` bigint(20) DEFAULT NULL,
`active` int(11) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`log` tinyint(4) DEFAULT NULL,
`type` int(11) DEFAULT NULL,
`command` varchar(128) DEFAULT NULL,
`int_min` varchar(32) DEFAULT NULL,
`int_hour` varchar(32) DEFAULT NULL,
`int_month` varchar(32) DEFAULT NULL,
`int_month_day` varchar(32) DEFAULT NULL,
`int_week_day` varchar(32) DEFAULT NULL,
`running` tinyint(4) DEFAULT NULL,
`running_host` varchar(4) DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_tsk_set_idx` (`site_id`),
CONSTRAINT `fk_tsk_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_task_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_task_log` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`task_id` bigint(20) NOT NULL DEFAULT 0,
`result` tinyint(4) DEFAULT NULL,
`message` blob DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`,`task_id`),
KEY `fk_tl_task` (`task_id`,`site_id`),
CONSTRAINT `fk_tl_t` FOREIGN KEY (`task_id`, `site_id`) REFERENCES `ab_task` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_tax`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_tax` (
`id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`country_id` int(11) NOT NULL DEFAULT 0,
`zone` varchar(128) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`rate` double DEFAULT NULL,
`tax_id_collect` tinyint(4) DEFAULT NULL,
`tax_id_name` varchar(32) DEFAULT NULL,
`tax_id_req` tinyint(4) DEFAULT NULL,
`tax_id_exempt` tinyint(4) DEFAULT NULL,
`tax_id_regex` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UNIQUE` (`country_id`,`zone`),
KEY `fk_tax_cty_idx` (`country_id`),
CONSTRAINT `fk_tax_cty` FOREIGN KEY (`country_id`) REFERENCES `ab_country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `ab_voip_plan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ab_voip_plan` (
`id` bigint(20) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `accounts`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `accounts` (
`id` bigint(20) NOT NULL DEFAULT 0,
`site_id` int(11) NOT NULL DEFAULT 0,
`date_orig` bigint(20) DEFAULT NULL,
`date_last` bigint(20) DEFAULT NULL,
`date_expire` bigint(20) DEFAULT NULL,
`language_id` int(11) NOT NULL,
`country_id` int(11) NOT NULL,
`rtm_id` bigint(20) DEFAULT NULL,
`currency_id` int(11) NOT NULL,
`active` tinyint(4) DEFAULT NULL,
`company` varchar(255) DEFAULT NULL,
`address1` varchar(128) DEFAULT NULL,
`address2` varchar(128) DEFAULT NULL,
`city` varchar(32) DEFAULT NULL,
`state` varchar(32) DEFAULT NULL,
`zip` varchar(16) DEFAULT NULL,
`user_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`,`site_id`),
KEY `fk_acc_set_idx` (`site_id`),
KEY `fk_acc_lan_idx` (`language_id`),
KEY `fk_acc_rtm_idx` (`rtm_id`,`site_id`),
KEY `fk_acc_cty_idx` (`country_id`),
KEY `fk_acc_cur_idx` (`currency_id`),
KEY `ab_account_user_id_foreign` (`user_id`),
CONSTRAINT `ab_account_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
CONSTRAINT `fk_acc_cty` FOREIGN KEY (`country_id`) REFERENCES `ab_country` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_acc_cur` FOREIGN KEY (`currency_id`) REFERENCES `ab_currency` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_acc_lan` FOREIGN KEY (`language_id`) REFERENCES `ab_language` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_acc_rtm` FOREIGN KEY (`rtm_id`, `site_id`) REFERENCES `ab_rtm` (`id`, `site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_acc_set` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `external_account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `external_account` (
`account_id` bigint(20) NOT NULL,
`site_id` int(11) DEFAULT NULL,
`external_integration_id` int(10) unsigned NOT NULL,
`link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
UNIQUE KEY `sae` (`site_id`,`account_id`,`external_integration_id`),
KEY `external_account_external_integration_id_foreign` (`external_integration_id`),
KEY `external_account_account_id_foreign` (`account_id`),
CONSTRAINT `external_account_account_id_foreign` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),
CONSTRAINT `external_account_external_integration_id_foreign` FOREIGN KEY (`external_integration_id`) REFERENCES `external_integrations` (`id`),
CONSTRAINT `external_account_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `external_integrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `external_integrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`active` tinyint(1) NOT NULL,
`user_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `external_integrations_user_id_foreign` (`user_id`),
CONSTRAINT `external_integrations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `invites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `invites` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`for` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`max` int(11) NOT NULL DEFAULT 1,
`uses` int(11) NOT NULL DEFAULT 0,
`valid_until` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `invites_code_unique` (`code`),
UNIQUE KEY `invites_for_unique` (`for`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint(3) unsigned NOT NULL,
`reserved_at` int(10) unsigned DEFAULT NULL,
`available_at` int(10) unsigned NOT NULL,
`created_at` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_access_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int(11) DEFAULT NULL,
`client_id` int(11) NOT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `oauth_auth_codes`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_auth_codes` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` int(11) NOT NULL,
`client_id` int(11) NOT NULL,
`scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_clients` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL,
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
`personal_access_client` tinyint(1) NOT NULL,
`password_client` tinyint(1) NOT NULL,
`revoked` tinyint(1) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `oauth_personal_access_clients`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_personal_access_clients` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`client_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `oauth_refresh_tokens` (
`id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_resets` (
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `quickbooks_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quickbooks_tokens` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`realm_id` bigint(20) unsigned NOT NULL,
`access_token` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
`access_token_expires_at` datetime NOT NULL,
`refresh_token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`refresh_token_expires_at` datetime NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `quickbooks_tokens_user_id_foreign` (`user_id`),
CONSTRAINT `quickbooks_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `service__generic`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `service__generic` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL,
`service_id` bigint(20) NOT NULL,
`product_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `service__generic_site_id_service_id_unique` (`site_id`,`service_id`),
KEY `service__generic_service_id_site_id_foreign` (`service_id`,`site_id`),
KEY `service__generic_product_id_site_id_foreign` (`product_id`,`site_id`),
CONSTRAINT `service__generic_product_id_site_id_foreign` FOREIGN KEY (`product_id`, `site_id`) REFERENCES `ab_product` (`id`, `site_id`),
CONSTRAINT `service__generic_service_id_site_id_foreign` FOREIGN KEY (`service_id`, `site_id`) REFERENCES `ab_service` (`id`, `site_id`),
CONSTRAINT `service__generic_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `site_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `site_details` (
`site_id` int(11) NOT NULL,
`key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
UNIQUE KEY `site_details_site_id_key_unique` (`site_id`,`key`),
CONSTRAINT `site_details_site_id_foreign` FOREIGN KEY (`site_id`) REFERENCES `sites` (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `sites`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sites` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL,
`date_orig` bigint(20) DEFAULT NULL,
`active` tinyint(1) NOT NULL,
`country_id` int(11) NOT NULL,
`language_id` int(11) NOT NULL,
`currency_id` int(11) NOT NULL,
`url` varchar(256) NOT NULL,
`admin_id` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sites_site_id_url_unique` (`site_id`,`url`),
KEY `sites_site_id_index` (`site_id`),
KEY `sites_country_id_foreign` (`country_id`),
KEY `sites_currency_id_foreign` (`currency_id`),
KEY `sites_language_id_foreign` (`language_id`),
KEY `sites_admin_id_site_id_foreign` (`admin_id`,`site_id`),
CONSTRAINT `sites_admin_id_site_id_foreign` FOREIGN KEY (`admin_id`, `site_id`) REFERENCES `users` (`id`, `site_id`),
CONSTRAINT `sites_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `ab_country` (`id`),
CONSTRAINT `sites_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `ab_currency` (`id`),
CONSTRAINT `sites_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `ab_language` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`site_id` int(11) NOT NULL,
`email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`active` tinyint(1) NOT NULL,
`title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`lastname` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
`country_id` int(11) NOT NULL,
`address1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`postcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailable` tinyint(1) NOT NULL DEFAULT 1,
`parent_id` int(10) unsigned DEFAULT NULL,
`language_id` int(11) DEFAULT NULL,
`currency_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_site_id_email_unique` (`site_id`,`email`),
KEY `users_parent_id_foreign` (`parent_id`),
KEY `users_language_id_foreign` (`language_id`),
KEY `users_currency_id_foreign` (`currency_id`),
KEY `site_user_id_idx` (`id`,`site_id`),
CONSTRAINT `users_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `ab_currency` (`id`),
CONSTRAINT `users_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `ab_language` (`id`),
CONSTRAINT `users_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
INSERT INTO `migrations` VALUES (1,'2016_06_01_000001_create_oauth_auth_codes_table',1);
INSERT INTO `migrations` VALUES (2,'2016_06_01_000002_create_oauth_access_tokens_table',1);
INSERT INTO `migrations` VALUES (3,'2016_06_01_000003_create_oauth_refresh_tokens_table',1);
INSERT INTO `migrations` VALUES (4,'2016_06_01_000004_create_oauth_clients_table',1);
INSERT INTO `migrations` VALUES (5,'2016_06_01_000005_create_oauth_personal_access_clients_table',1);
INSERT INTO `migrations` VALUES (6,'2017_04_04_185723_create_invites_table',1);
INSERT INTO `migrations` VALUES (7,'2018_05_14_122513_currency_add_rounding',1);
INSERT INTO `migrations` VALUES (8,'2018_05_20_052944_account_add_remember_token',1);
INSERT INTO `migrations` VALUES (301,'2017_06_18_104531_create_ab_account_billing_table',0);
INSERT INTO `migrations` VALUES (302,'2017_06_18_104531_create_ab_account_group_table',0);
INSERT INTO `migrations` VALUES (303,'2017_06_18_104531_create_ab_account_log_table',0);
INSERT INTO `migrations` VALUES (304,'2017_06_18_104531_create_ab_account_memo_table',0);
INSERT INTO `migrations` VALUES (305,'2017_06_18_104531_create_ab_account_oauth_table',0);
INSERT INTO `migrations` VALUES (306,'2017_06_18_104531_create_ab_account_table',0);
INSERT INTO `migrations` VALUES (307,'2017_06_18_104531_create_ab_adsl_plan_table',0);
INSERT INTO `migrations` VALUES (308,'2017_06_18_104531_create_ab_adsl_supplier_plan_table',0);
INSERT INTO `migrations` VALUES (309,'2017_06_18_104531_create_ab_adsl_supplier_table',0);
INSERT INTO `migrations` VALUES (310,'2017_06_18_104531_create_ab_affiliate_table',0);
INSERT INTO `migrations` VALUES (311,'2017_06_18_104531_create_ab_asset_pool_table',0);
INSERT INTO `migrations` VALUES (312,'2017_06_18_104531_create_ab_asset_table',0);
INSERT INTO `migrations` VALUES (313,'2017_06_18_104531_create_ab_cart_table',0);
INSERT INTO `migrations` VALUES (314,'2017_06_18_104531_create_ab_charge_table',0);
INSERT INTO `migrations` VALUES (315,'2017_06_18_104531_create_ab_checkout_notify_table',0);
INSERT INTO `migrations` VALUES (316,'2017_06_18_104531_create_ab_checkout_table',0);
INSERT INTO `migrations` VALUES (317,'2017_06_18_104531_create_ab_country_table',0);
INSERT INTO `migrations` VALUES (318,'2017_06_18_104531_create_ab_currency_table',0);
INSERT INTO `migrations` VALUES (319,'2017_06_18_104531_create_ab_discount_table',0);
INSERT INTO `migrations` VALUES (320,'2017_06_18_104531_create_ab_domain_registrar_table',0);
INSERT INTO `migrations` VALUES (321,'2017_06_18_104531_create_ab_domain_tld_table',0);
INSERT INTO `migrations` VALUES (322,'2017_06_18_104531_create_ab_email_log_table',0);
INSERT INTO `migrations` VALUES (323,'2017_06_18_104531_create_ab_email_setup_table',0);
INSERT INTO `migrations` VALUES (324,'2017_06_18_104531_create_ab_email_template_table',0);
INSERT INTO `migrations` VALUES (325,'2017_06_18_104531_create_ab_email_template_translate_table',0);
INSERT INTO `migrations` VALUES (326,'2017_06_18_104531_create_ab_export_datamap_table',0);
INSERT INTO `migrations` VALUES (327,'2017_06_18_104531_create_ab_export_item_table',0);
INSERT INTO `migrations` VALUES (328,'2017_06_18_104531_create_ab_export_module_table',0);
INSERT INTO `migrations` VALUES (329,'2017_06_18_104531_create_ab_export_table',0);
INSERT INTO `migrations` VALUES (330,'2017_06_18_104531_create_ab_group_method_table',0);
INSERT INTO `migrations` VALUES (331,'2017_06_18_104531_create_ab_group_table',0);
INSERT INTO `migrations` VALUES (332,'2017_06_18_104531_create_ab_host_server_affiliate_table',0);
INSERT INTO `migrations` VALUES (333,'2017_06_18_104531_create_ab_host_server_id_table',0);
INSERT INTO `migrations` VALUES (334,'2017_06_18_104531_create_ab_host_server_table',0);
INSERT INTO `migrations` VALUES (335,'2017_06_18_104531_create_ab_host_tld_id_table',0);
INSERT INTO `migrations` VALUES (336,'2017_06_18_104531_create_ab_import_table',0);
INSERT INTO `migrations` VALUES (337,'2017_06_18_104531_create_ab_invoice_item_discount_table',0);
INSERT INTO `migrations` VALUES (338,'2017_06_18_104531_create_ab_invoice_item_table',0);
INSERT INTO `migrations` VALUES (339,'2017_06_18_104531_create_ab_invoice_item_tax_table',0);
INSERT INTO `migrations` VALUES (340,'2017_06_18_104531_create_ab_invoice_memo_table',0);
INSERT INTO `migrations` VALUES (341,'2017_06_18_104531_create_ab_invoice_table',0);
INSERT INTO `migrations` VALUES (342,'2017_06_18_104531_create_ab_language_table',0);
INSERT INTO `migrations` VALUES (343,'2017_06_18_104531_create_ab_log_error_table',0);
INSERT INTO `migrations` VALUES (344,'2017_06_18_104531_create_ab_module_method_table',0);
INSERT INTO `migrations` VALUES (345,'2017_06_18_104531_create_ab_module_method_token_table',0);
INSERT INTO `migrations` VALUES (346,'2017_06_18_104531_create_ab_module_table',0);
INSERT INTO `migrations` VALUES (347,'2017_06_18_104531_create_ab_oauth_table',0);
INSERT INTO `migrations` VALUES (348,'2017_06_18_104531_create_ab_payment_item_table',0);
INSERT INTO `migrations` VALUES (349,'2017_06_18_104531_create_ab_payment_table',0);
INSERT INTO `migrations` VALUES (350,'2017_06_18_104531_create_ab_pivot_product_cat_table',0);
INSERT INTO `migrations` VALUES (351,'2017_06_18_104531_create_ab_product_cat_table',0);
INSERT INTO `migrations` VALUES (352,'2017_06_18_104531_create_ab_product_cat_translate_table',0);
INSERT INTO `migrations` VALUES (353,'2017_06_18_104531_create_ab_product_table',0);
INSERT INTO `migrations` VALUES (354,'2017_06_18_104531_create_ab_product_translate_table',0);
INSERT INTO `migrations` VALUES (355,'2017_06_18_104531_create_ab_record_id_table',0);
INSERT INTO `migrations` VALUES (356,'2017_06_18_104531_create_ab_rtm_table',0);
INSERT INTO `migrations` VALUES (357,'2017_06_18_104531_create_ab_service__adsl_table',0);
INSERT INTO `migrations` VALUES (358,'2017_06_18_104531_create_ab_service__adsl_traffic_table',0);
INSERT INTO `migrations` VALUES (359,'2017_06_18_104531_create_ab_service__domain_table',0);
INSERT INTO `migrations` VALUES (360,'2017_06_18_104531_create_ab_service__hosting_table',0);
INSERT INTO `migrations` VALUES (361,'2017_06_18_104531_create_ab_service__ssl_table',0);
INSERT INTO `migrations` VALUES (362,'2017_06_18_104531_create_ab_service__voip_table',0);
INSERT INTO `migrations` VALUES (363,'2017_06_18_104531_create_ab_service_change_table',0);
INSERT INTO `migrations` VALUES (364,'2017_06_18_104531_create_ab_service_memo_table',0);
INSERT INTO `migrations` VALUES (365,'2017_06_18_104531_create_ab_service_table',0);
INSERT INTO `migrations` VALUES (366,'2017_06_18_104531_create_ab_setup_invoice_table',0);
INSERT INTO `migrations` VALUES (367,'2017_06_18_104531_create_ab_setup_table',0);
INSERT INTO `migrations` VALUES (368,'2017_06_18_104531_create_ab_ssl_ca_table',0);
INSERT INTO `migrations` VALUES (369,'2017_06_18_104531_create_ab_ssl_table',0);
INSERT INTO `migrations` VALUES (370,'2017_06_18_104531_create_ab_static_page_category_table',0);
INSERT INTO `migrations` VALUES (371,'2017_06_18_104531_create_ab_static_page_table',0);
INSERT INTO `migrations` VALUES (372,'2017_06_18_104531_create_ab_static_page_translate_table',0);
INSERT INTO `migrations` VALUES (373,'2017_06_18_104531_create_ab_task_log_table',0);
INSERT INTO `migrations` VALUES (374,'2017_06_18_104531_create_ab_task_table',0);
INSERT INTO `migrations` VALUES (375,'2017_06_18_104531_create_ab_tax_table',0);
INSERT INTO `migrations` VALUES (376,'2017_06_18_104531_create_ab_voip_plan_table',0);
INSERT INTO `migrations` VALUES (377,'2017_06_18_104531_create_countries_table',0);
INSERT INTO `migrations` VALUES (378,'2017_06_18_104531_create_currencies_table',0);
INSERT INTO `migrations` VALUES (379,'2017_06_18_104531_create_sites_table',0);
INSERT INTO `migrations` VALUES (381,'2017_06_18_104533_add_foreign_keys_to_ab_account_billing_table',0);
INSERT INTO `migrations` VALUES (382,'2017_06_18_104533_add_foreign_keys_to_ab_account_group_table',0);
INSERT INTO `migrations` VALUES (383,'2017_06_18_104533_add_foreign_keys_to_ab_account_log_table',0);
INSERT INTO `migrations` VALUES (384,'2017_06_18_104533_add_foreign_keys_to_ab_account_oauth_table',0);
INSERT INTO `migrations` VALUES (385,'2017_06_18_104533_add_foreign_keys_to_ab_account_table',0);
INSERT INTO `migrations` VALUES (386,'2017_06_18_104533_add_foreign_keys_to_ab_adsl_plan_table',0);
INSERT INTO `migrations` VALUES (387,'2017_06_18_104533_add_foreign_keys_to_ab_adsl_supplier_plan_table',0);
INSERT INTO `migrations` VALUES (388,'2017_06_18_104533_add_foreign_keys_to_ab_adsl_supplier_table',0);
INSERT INTO `migrations` VALUES (389,'2017_06_18_104533_add_foreign_keys_to_ab_affiliate_table',0);
INSERT INTO `migrations` VALUES (390,'2017_06_18_104533_add_foreign_keys_to_ab_cart_table',0);
INSERT INTO `migrations` VALUES (391,'2017_06_18_104533_add_foreign_keys_to_ab_charge_table',0);
INSERT INTO `migrations` VALUES (392,'2017_06_18_104533_add_foreign_keys_to_ab_checkout_notify_table',0);
INSERT INTO `migrations` VALUES (393,'2017_06_18_104533_add_foreign_keys_to_ab_checkout_table',0);
INSERT INTO `migrations` VALUES (394,'2017_06_18_104533_add_foreign_keys_to_ab_currency_table',0);
INSERT INTO `migrations` VALUES (395,'2017_06_18_104533_add_foreign_keys_to_ab_domain_tld_table',0);
INSERT INTO `migrations` VALUES (396,'2017_06_18_104533_add_foreign_keys_to_ab_email_log_table',0);
INSERT INTO `migrations` VALUES (397,'2017_06_18_104533_add_foreign_keys_to_ab_email_setup_table',0);
INSERT INTO `migrations` VALUES (398,'2017_06_18_104533_add_foreign_keys_to_ab_email_template_table',0);
INSERT INTO `migrations` VALUES (399,'2017_06_18_104533_add_foreign_keys_to_ab_email_template_translate_table',0);
INSERT INTO `migrations` VALUES (400,'2017_06_18_104533_add_foreign_keys_to_ab_export_datamap_table',0);
INSERT INTO `migrations` VALUES (401,'2017_06_18_104533_add_foreign_keys_to_ab_export_item_table',0);
INSERT INTO `migrations` VALUES (402,'2017_06_18_104533_add_foreign_keys_to_ab_export_module_table',0);
INSERT INTO `migrations` VALUES (403,'2017_06_18_104533_add_foreign_keys_to_ab_export_table',0);
INSERT INTO `migrations` VALUES (404,'2017_06_18_104533_add_foreign_keys_to_ab_group_method_table',0);
INSERT INTO `migrations` VALUES (405,'2017_06_18_104533_add_foreign_keys_to_ab_group_table',0);
INSERT INTO `migrations` VALUES (406,'2017_06_18_104533_add_foreign_keys_to_ab_host_server_affiliate_table',0);
INSERT INTO `migrations` VALUES (407,'2017_06_18_104533_add_foreign_keys_to_ab_invoice_item_table',0);
INSERT INTO `migrations` VALUES (408,'2017_06_18_104533_add_foreign_keys_to_ab_invoice_item_tax_table',0);
INSERT INTO `migrations` VALUES (409,'2017_06_18_104533_add_foreign_keys_to_ab_invoice_memo_table',0);
INSERT INTO `migrations` VALUES (410,'2017_06_18_104533_add_foreign_keys_to_ab_invoice_table',0);
INSERT INTO `migrations` VALUES (411,'2017_06_18_104533_add_foreign_keys_to_ab_module_method_table',0);
INSERT INTO `migrations` VALUES (412,'2017_06_18_104533_add_foreign_keys_to_ab_module_method_token_table',0);
INSERT INTO `migrations` VALUES (413,'2017_06_18_104533_add_foreign_keys_to_ab_module_table',0);
INSERT INTO `migrations` VALUES (414,'2017_06_18_104533_add_foreign_keys_to_ab_oauth_table',0);
INSERT INTO `migrations` VALUES (415,'2017_06_18_104533_add_foreign_keys_to_ab_payment_item_table',0);
INSERT INTO `migrations` VALUES (416,'2017_06_18_104533_add_foreign_keys_to_ab_payment_table',0);
INSERT INTO `migrations` VALUES (417,'2017_06_18_104533_add_foreign_keys_to_ab_pivot_product_cat_table',0);
INSERT INTO `migrations` VALUES (418,'2017_06_18_104533_add_foreign_keys_to_ab_product_cat_table',0);
INSERT INTO `migrations` VALUES (419,'2017_06_18_104533_add_foreign_keys_to_ab_product_cat_translate_table',0);
INSERT INTO `migrations` VALUES (420,'2017_06_18_104533_add_foreign_keys_to_ab_product_table',0);
INSERT INTO `migrations` VALUES (421,'2017_06_18_104533_add_foreign_keys_to_ab_product_translate_table',0);
INSERT INTO `migrations` VALUES (422,'2017_06_18_104533_add_foreign_keys_to_ab_record_id_table',0);
INSERT INTO `migrations` VALUES (423,'2017_06_18_104533_add_foreign_keys_to_ab_rtm_table',0);
INSERT INTO `migrations` VALUES (424,'2017_06_18_104533_add_foreign_keys_to_ab_service__adsl_table',0);
INSERT INTO `migrations` VALUES (425,'2017_06_18_104533_add_foreign_keys_to_ab_service__adsl_traffic_table',0);
INSERT INTO `migrations` VALUES (426,'2017_06_18_104533_add_foreign_keys_to_ab_service__domain_table',0);
INSERT INTO `migrations` VALUES (427,'2017_06_18_104533_add_foreign_keys_to_ab_service__hosting_table',0);
INSERT INTO `migrations` VALUES (428,'2017_06_18_104533_add_foreign_keys_to_ab_service__ssl_table',0);
INSERT INTO `migrations` VALUES (429,'2017_06_18_104533_add_foreign_keys_to_ab_service_change_table',0);
INSERT INTO `migrations` VALUES (430,'2017_06_18_104533_add_foreign_keys_to_ab_service_memo_table',0);
INSERT INTO `migrations` VALUES (431,'2017_06_18_104533_add_foreign_keys_to_ab_service_table',0);
INSERT INTO `migrations` VALUES (432,'2017_06_18_104533_add_foreign_keys_to_ab_setup_table',0);
INSERT INTO `migrations` VALUES (433,'2017_06_18_104533_add_foreign_keys_to_ab_ssl_ca_table',0);
INSERT INTO `migrations` VALUES (434,'2017_06_18_104533_add_foreign_keys_to_ab_ssl_table',0);
INSERT INTO `migrations` VALUES (435,'2017_06_18_104533_add_foreign_keys_to_ab_task_log_table',0);
INSERT INTO `migrations` VALUES (436,'2017_06_18_104533_add_foreign_keys_to_ab_task_table',0);
INSERT INTO `migrations` VALUES (437,'2017_06_18_104533_add_foreign_keys_to_ab_tax_table',0);
INSERT INTO `migrations` VALUES (438,'2017_06_18_104533_add_foreign_keys_to_countries_table',0);
INSERT INTO `migrations` VALUES (439,'2018_06_18_114830_currency_change_threecode',2);
INSERT INTO `migrations` VALUES (440,'2017_06_18_104531_create_users_table',3);
INSERT INTO `migrations` VALUES (441,'2018_06_22_062015_account_add_user',4);
INSERT INTO `migrations` VALUES (442,'2018_06_22_062022_user_add_heirachy',4);
INSERT INTO `migrations` VALUES (443,'2018_07_10_034223_users_add_language',4);
INSERT INTO `migrations` VALUES (444,'2018_07_28_234942_create_site_details',5);
INSERT INTO `migrations` VALUES (445,'2014_10_12_100000_create_password_resets_table',6);
INSERT INTO `migrations` VALUES (446,'2018_08_10_115648_service_add_status',7);
INSERT INTO `migrations` VALUES (447,'2019_01_24_142111_create_jobs_table',8);
INSERT INTO `migrations` VALUES (448,'2019_01_24_175606_create_failed_jobs_table',9);
INSERT INTO `migrations` VALUES (449,'2019_06_02_163527_add_model_to_service',10);
INSERT INTO `migrations` VALUES (450,'2018_03_11_141103_create_quick_books_tokens_table',11);
INSERT INTO `migrations` VALUES (451,'2019_06_11_160940_add_external',11);
INSERT INTO `migrations` VALUES (452,'2019_06_11_161150_add_external_account',11);
INSERT INTO `migrations` VALUES (453,'2019_06_29_101655_add_model_to_product',12);
INSERT INTO `migrations` VALUES (454,'2019_07_05_092048_add_user_to_accountoauth',12);
INSERT INTO `migrations` VALUES (455,'2020_04_22_231133_change_service_number_adsl',13);
INSERT INTO `migrations` VALUES (456,'2020_05_27_144223_enhance_adsl_traffic',14);
INSERT INTO `migrations` VALUES (457,'2020_07_24_153836_addpending_to_payment',15);
INSERT INTO `migrations` VALUES (458,'2020_12_01_225123_add_service_generic',16);
INSERT INTO `migrations` VALUES (459,'2021_06_30_171340_rename_setup',17);
INSERT INTO `migrations` VALUES (460,'2021_07_07_164413_rework_account',17);