diff options
Diffstat (limited to 'templates/database/etc')
| -rw-r--r-- | templates/database/etc/openbook/database/create_openbook_schemas.sql | 2040 |
1 files changed, 2006 insertions, 34 deletions
diff --git a/templates/database/etc/openbook/database/create_openbook_schemas.sql b/templates/database/etc/openbook/database/create_openbook_schemas.sql index 4e1e75d..7c2d67b 100644 --- a/templates/database/etc/openbook/database/create_openbook_schemas.sql +++ b/templates/database/etc/openbook/database/create_openbook_schemas.sql @@ -10,7 +10,7 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook` /*!40100 DEFAULT CHARACTER SET utf8 */; +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook` /*!40100 DEFAULT CHARACTER SET latin1 */; GRANT ALL PRIVILEGES ON openbook.* TO openbook@'%' IDENTIFIED BY '{{ openbook_database_password }}'; GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{{ openbook_database_password }}'; @@ -87,7 +87,7 @@ CREATE TABLE `t_audit_event` ( PRIMARY KEY (`event_id`), KEY `ix_audit_event_1` (`event_time`,`event_type`,`entity_id`), KEY `ix_audit_event_2` (`user_id`,`event_time`) -) ENGINE=InnoDB AUTO_INCREMENT=2263 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2209 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -235,6 +235,13 @@ CREATE TABLE `t_aws_raw_data` ( /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; +CREATE TABLE `t_cpu_models` ( + `host_aggregate` varchar(255) DEFAULT NULL, + `cpu_model` varchar(64) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; CREATE TABLE `t_credit` ( `credit_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `payer_id` int(10) unsigned NOT NULL, @@ -290,7 +297,7 @@ CREATE TABLE `t_customer` ( `registration_number` varchar(128) DEFAULT NULL, PRIMARY KEY (`customer_id`), UNIQUE KEY `ix_customer_3` (`management_region_id`,`customer_name`(255)) -) ENGINE=InnoDB AUTO_INCREMENT=315871 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=315625 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -420,7 +427,7 @@ CREATE TABLE `t_host` ( `disk_allocation_ratio` decimal(6,2) DEFAULT NULL, PRIMARY KEY (`host_id`), KEY `ix_host_1` (`service_manager_id`,`service_region_id`,`host_foreign_id`(255)) -) ENGINE=InnoDB AUTO_INCREMENT=2129 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2015 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -436,7 +443,7 @@ CREATE TABLE `t_host_attributes` ( `vm_count` int(11) NOT NULL, `socket_count` int(11) NOT NULL, PRIMARY KEY (`host_id`,`update_date`) -) ENGINE=InnoDB AUTO_INCREMENT=2129 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2015 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -459,7 +466,7 @@ CREATE TABLE `t_invoice` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `ix_invoice_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=12487308 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=12487601 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -559,7 +566,332 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (to_days(`aggregate_datetime`)) -(PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, +(PARTITION `p736747` VALUES LESS THAN (736747) ENGINE = InnoDB, + PARTITION `p736748` VALUES LESS THAN (736748) ENGINE = InnoDB, + PARTITION `p736749` VALUES LESS THAN (736749) ENGINE = InnoDB, + PARTITION `p736750` VALUES LESS THAN (736750) ENGINE = InnoDB, + PARTITION `p736751` VALUES LESS THAN (736751) ENGINE = InnoDB, + PARTITION `p736752` VALUES LESS THAN (736752) ENGINE = InnoDB, + PARTITION `p736753` VALUES LESS THAN (736753) ENGINE = InnoDB, + PARTITION `p736754` VALUES LESS THAN (736754) ENGINE = InnoDB, + PARTITION `p736755` VALUES LESS THAN (736755) ENGINE = InnoDB, + PARTITION `p736756` VALUES LESS THAN (736756) ENGINE = InnoDB, + PARTITION `p736757` VALUES LESS THAN (736757) ENGINE = InnoDB, + PARTITION `p736758` VALUES LESS THAN (736758) ENGINE = InnoDB, + PARTITION `p736759` VALUES LESS THAN (736759) ENGINE = InnoDB, + PARTITION `p736760` VALUES LESS THAN (736760) ENGINE = InnoDB, + PARTITION `p736761` VALUES LESS THAN (736761) ENGINE = InnoDB, + PARTITION `p736762` VALUES LESS THAN (736762) ENGINE = InnoDB, + PARTITION `p736763` VALUES LESS THAN (736763) ENGINE = InnoDB, + PARTITION `p736764` VALUES LESS THAN (736764) ENGINE = InnoDB, + PARTITION `p736765` VALUES LESS THAN (736765) ENGINE = InnoDB, + PARTITION `p736766` VALUES LESS THAN (736766) ENGINE = InnoDB, + PARTITION `p736767` VALUES LESS THAN (736767) ENGINE = InnoDB, + PARTITION `p736768` VALUES LESS THAN (736768) ENGINE = InnoDB, + PARTITION `p736769` VALUES LESS THAN (736769) ENGINE = InnoDB, + PARTITION `p736770` VALUES LESS THAN (736770) ENGINE = InnoDB, + PARTITION `p736771` VALUES LESS THAN (736771) ENGINE = InnoDB, + PARTITION `p736772` VALUES LESS THAN (736772) ENGINE = InnoDB, + PARTITION `p736773` VALUES LESS THAN (736773) ENGINE = InnoDB, + PARTITION `p736774` VALUES LESS THAN (736774) ENGINE = InnoDB, + PARTITION `p736775` VALUES LESS THAN (736775) ENGINE = InnoDB, + PARTITION `p736776` VALUES LESS THAN (736776) ENGINE = InnoDB, + PARTITION `p736777` VALUES LESS THAN (736777) ENGINE = InnoDB, + PARTITION `p736778` VALUES LESS THAN (736778) ENGINE = InnoDB, + PARTITION `p736779` VALUES LESS THAN (736779) ENGINE = InnoDB, + PARTITION `p736780` VALUES LESS THAN (736780) ENGINE = InnoDB, + PARTITION `p736781` VALUES LESS THAN (736781) ENGINE = InnoDB, + PARTITION `p736782` VALUES LESS THAN (736782) ENGINE = InnoDB, + PARTITION `p736783` VALUES LESS THAN (736783) ENGINE = InnoDB, + PARTITION `p736784` VALUES LESS THAN (736784) ENGINE = InnoDB, + PARTITION `p736785` VALUES LESS THAN (736785) ENGINE = InnoDB, + PARTITION `p736786` VALUES LESS THAN (736786) ENGINE = InnoDB, + PARTITION `p736787` VALUES LESS THAN (736787) ENGINE = InnoDB, + PARTITION `p736788` VALUES LESS THAN (736788) ENGINE = InnoDB, + PARTITION `p736789` VALUES LESS THAN (736789) ENGINE = InnoDB, + PARTITION `p736790` VALUES LESS THAN (736790) ENGINE = InnoDB, + PARTITION `p736791` VALUES LESS THAN (736791) ENGINE = InnoDB, + PARTITION `p736792` VALUES LESS THAN (736792) ENGINE = InnoDB, + PARTITION `p736793` VALUES LESS THAN (736793) ENGINE = InnoDB, + PARTITION `p736794` VALUES LESS THAN (736794) ENGINE = InnoDB, + PARTITION `p736795` VALUES LESS THAN (736795) ENGINE = InnoDB, + PARTITION `p736796` VALUES LESS THAN (736796) ENGINE = InnoDB, + PARTITION `p736797` VALUES LESS THAN (736797) ENGINE = InnoDB, + PARTITION `p736798` VALUES LESS THAN (736798) ENGINE = InnoDB, + PARTITION `p736799` VALUES LESS THAN (736799) ENGINE = InnoDB, + PARTITION `p736800` VALUES LESS THAN (736800) ENGINE = InnoDB, + PARTITION `p736801` VALUES LESS THAN (736801) ENGINE = InnoDB, + PARTITION `p736802` VALUES LESS THAN (736802) ENGINE = InnoDB, + PARTITION `p736803` VALUES LESS THAN (736803) ENGINE = InnoDB, + PARTITION `p736804` VALUES LESS THAN (736804) ENGINE = InnoDB, + PARTITION `p736805` VALUES LESS THAN (736805) ENGINE = InnoDB, + PARTITION `p736806` VALUES LESS THAN (736806) ENGINE = InnoDB, + PARTITION `p736807` VALUES LESS THAN (736807) ENGINE = InnoDB, + PARTITION `p736808` VALUES LESS THAN (736808) ENGINE = InnoDB, + PARTITION `p736809` VALUES LESS THAN (736809) ENGINE = InnoDB, + PARTITION `p736810` VALUES LESS THAN (736810) ENGINE = InnoDB, + PARTITION `p736811` VALUES LESS THAN (736811) ENGINE = InnoDB, + PARTITION `p736812` VALUES LESS THAN (736812) ENGINE = InnoDB, + PARTITION `p736813` VALUES LESS THAN (736813) ENGINE = InnoDB, + PARTITION `p736814` VALUES LESS THAN (736814) ENGINE = InnoDB, + PARTITION `p736815` VALUES LESS THAN (736815) ENGINE = InnoDB, + PARTITION `p736816` VALUES LESS THAN (736816) ENGINE = InnoDB, + PARTITION `p736817` VALUES LESS THAN (736817) ENGINE = InnoDB, + PARTITION `p736818` VALUES LESS THAN (736818) ENGINE = InnoDB, + PARTITION `p736819` VALUES LESS THAN (736819) ENGINE = InnoDB, + PARTITION `p736820` VALUES LESS THAN (736820) ENGINE = InnoDB, + PARTITION `p736821` VALUES LESS THAN (736821) ENGINE = InnoDB, + PARTITION `p736822` VALUES LESS THAN (736822) ENGINE = InnoDB, + PARTITION `p736823` VALUES LESS THAN (736823) ENGINE = InnoDB, + PARTITION `p736824` VALUES LESS THAN (736824) ENGINE = InnoDB, + PARTITION `p736825` VALUES LESS THAN (736825) ENGINE = InnoDB, + PARTITION `p736826` VALUES LESS THAN (736826) ENGINE = InnoDB, + PARTITION `p736827` VALUES LESS THAN (736827) ENGINE = InnoDB, + PARTITION `p736828` VALUES LESS THAN (736828) ENGINE = InnoDB, + PARTITION `p736829` VALUES LESS THAN (736829) ENGINE = InnoDB, + PARTITION `p736830` VALUES LESS THAN (736830) ENGINE = InnoDB, + PARTITION `p736831` VALUES LESS THAN (736831) ENGINE = InnoDB, + PARTITION `p736832` VALUES LESS THAN (736832) ENGINE = InnoDB, + PARTITION `p736833` VALUES LESS THAN (736833) ENGINE = InnoDB, + PARTITION `p736834` VALUES LESS THAN (736834) ENGINE = InnoDB, + PARTITION `p736835` VALUES LESS THAN (736835) ENGINE = InnoDB, + PARTITION `p736836` VALUES LESS THAN (736836) ENGINE = InnoDB, + PARTITION `p736837` VALUES LESS THAN (736837) ENGINE = InnoDB, + PARTITION `p736838` VALUES LESS THAN (736838) ENGINE = InnoDB, + PARTITION `p736839` VALUES LESS THAN (736839) ENGINE = InnoDB, + PARTITION `p736840` VALUES LESS THAN (736840) ENGINE = InnoDB, + PARTITION `p736841` VALUES LESS THAN (736841) ENGINE = InnoDB, + PARTITION `p736842` VALUES LESS THAN (736842) ENGINE = InnoDB, + PARTITION `p736843` VALUES LESS THAN (736843) ENGINE = InnoDB, + PARTITION `p736844` VALUES LESS THAN (736844) ENGINE = InnoDB, + PARTITION `p736845` VALUES LESS THAN (736845) ENGINE = InnoDB, + PARTITION `p736846` VALUES LESS THAN (736846) ENGINE = InnoDB, + PARTITION `p736847` VALUES LESS THAN (736847) ENGINE = InnoDB, + PARTITION `p736848` VALUES LESS THAN (736848) ENGINE = InnoDB, + PARTITION `p736849` VALUES LESS THAN (736849) ENGINE = InnoDB, + PARTITION `p736850` VALUES LESS THAN (736850) ENGINE = InnoDB, + PARTITION `p736851` VALUES LESS THAN (736851) ENGINE = InnoDB, + PARTITION `p736852` VALUES LESS THAN (736852) ENGINE = InnoDB, + PARTITION `p736853` VALUES LESS THAN (736853) ENGINE = InnoDB, + PARTITION `p736854` VALUES LESS THAN (736854) ENGINE = InnoDB, + PARTITION `p736855` VALUES LESS THAN (736855) ENGINE = InnoDB, + PARTITION `p736856` VALUES LESS THAN (736856) ENGINE = InnoDB, + PARTITION `p736857` VALUES LESS THAN (736857) ENGINE = InnoDB, + PARTITION `p736858` VALUES LESS THAN (736858) ENGINE = InnoDB, + PARTITION `p736859` VALUES LESS THAN (736859) ENGINE = InnoDB, + PARTITION `p736860` VALUES LESS THAN (736860) ENGINE = InnoDB, + PARTITION `p736861` VALUES LESS THAN (736861) ENGINE = InnoDB, + PARTITION `p736862` VALUES LESS THAN (736862) ENGINE = InnoDB, + PARTITION `p736863` VALUES LESS THAN (736863) ENGINE = InnoDB, + PARTITION `p736864` VALUES LESS THAN (736864) ENGINE = InnoDB, + PARTITION `p736865` VALUES LESS THAN (736865) ENGINE = InnoDB, + PARTITION `p736866` VALUES LESS THAN (736866) ENGINE = InnoDB, + PARTITION `p736867` VALUES LESS THAN (736867) ENGINE = InnoDB, + PARTITION `p736868` VALUES LESS THAN (736868) ENGINE = InnoDB, + PARTITION `p736869` VALUES LESS THAN (736869) ENGINE = InnoDB, + PARTITION `p736870` VALUES LESS THAN (736870) ENGINE = InnoDB, + PARTITION `p736871` VALUES LESS THAN (736871) ENGINE = InnoDB, + PARTITION `p736872` VALUES LESS THAN (736872) ENGINE = InnoDB, + PARTITION `p736873` VALUES LESS THAN (736873) ENGINE = InnoDB, + PARTITION `p736874` VALUES LESS THAN (736874) ENGINE = InnoDB, + PARTITION `p736875` VALUES LESS THAN (736875) ENGINE = InnoDB, + PARTITION `p736876` VALUES LESS THAN (736876) ENGINE = InnoDB, + PARTITION `p736877` VALUES LESS THAN (736877) ENGINE = InnoDB, + PARTITION `p736878` VALUES LESS THAN (736878) ENGINE = InnoDB, + PARTITION `p736879` VALUES LESS THAN (736879) ENGINE = InnoDB, + PARTITION `p736880` VALUES LESS THAN (736880) ENGINE = InnoDB, + PARTITION `p736881` VALUES LESS THAN (736881) ENGINE = InnoDB, + PARTITION `p736882` VALUES LESS THAN (736882) ENGINE = InnoDB, + PARTITION `p736883` VALUES LESS THAN (736883) ENGINE = InnoDB, + PARTITION `p736884` VALUES LESS THAN (736884) ENGINE = InnoDB, + PARTITION `p736885` VALUES LESS THAN (736885) ENGINE = InnoDB, + PARTITION `p736886` VALUES LESS THAN (736886) ENGINE = InnoDB, + PARTITION `p736887` VALUES LESS THAN (736887) ENGINE = InnoDB, + PARTITION `p736888` VALUES LESS THAN (736888) ENGINE = InnoDB, + PARTITION `p736889` VALUES LESS THAN (736889) ENGINE = InnoDB, + PARTITION `p736890` VALUES LESS THAN (736890) ENGINE = InnoDB, + PARTITION `p736891` VALUES LESS THAN (736891) ENGINE = InnoDB, + PARTITION `p736892` VALUES LESS THAN (736892) ENGINE = InnoDB, + PARTITION `p736893` VALUES LESS THAN (736893) ENGINE = InnoDB, + PARTITION `p736894` VALUES LESS THAN (736894) ENGINE = InnoDB, + PARTITION `p736895` VALUES LESS THAN (736895) ENGINE = InnoDB, + PARTITION `p736896` VALUES LESS THAN (736896) ENGINE = InnoDB, + PARTITION `p736897` VALUES LESS THAN (736897) ENGINE = InnoDB, + PARTITION `p736898` VALUES LESS THAN (736898) ENGINE = InnoDB, + PARTITION `p736899` VALUES LESS THAN (736899) ENGINE = InnoDB, + PARTITION `p736900` VALUES LESS THAN (736900) ENGINE = InnoDB, + PARTITION `p736901` VALUES LESS THAN (736901) ENGINE = InnoDB, + PARTITION `p736902` VALUES LESS THAN (736902) ENGINE = InnoDB, + PARTITION `p736903` VALUES LESS THAN (736903) ENGINE = InnoDB, + PARTITION `p736904` VALUES LESS THAN (736904) ENGINE = InnoDB, + PARTITION `p736905` VALUES LESS THAN (736905) ENGINE = InnoDB, + PARTITION `p736906` VALUES LESS THAN (736906) ENGINE = InnoDB, + PARTITION `p736907` VALUES LESS THAN (736907) ENGINE = InnoDB, + PARTITION `p736908` VALUES LESS THAN (736908) ENGINE = InnoDB, + PARTITION `p736909` VALUES LESS THAN (736909) ENGINE = InnoDB, + PARTITION `p736910` VALUES LESS THAN (736910) ENGINE = InnoDB, + PARTITION `p736911` VALUES LESS THAN (736911) ENGINE = InnoDB, + PARTITION `p736912` VALUES LESS THAN (736912) ENGINE = InnoDB, + PARTITION `p736913` VALUES LESS THAN (736913) ENGINE = InnoDB, + PARTITION `p736914` VALUES LESS THAN (736914) ENGINE = InnoDB, + PARTITION `p736915` VALUES LESS THAN (736915) ENGINE = InnoDB, + PARTITION `p736916` VALUES LESS THAN (736916) ENGINE = InnoDB, + PARTITION `p736917` VALUES LESS THAN (736917) ENGINE = InnoDB, + PARTITION `p736918` VALUES LESS THAN (736918) ENGINE = InnoDB, + PARTITION `p736919` VALUES LESS THAN (736919) ENGINE = InnoDB, + PARTITION `p736920` VALUES LESS THAN (736920) ENGINE = InnoDB, + PARTITION `p736921` VALUES LESS THAN (736921) ENGINE = InnoDB, + PARTITION `p736922` VALUES LESS THAN (736922) ENGINE = InnoDB, + PARTITION `p736923` VALUES LESS THAN (736923) ENGINE = InnoDB, + PARTITION `p736924` VALUES LESS THAN (736924) ENGINE = InnoDB, + PARTITION `p736925` VALUES LESS THAN (736925) ENGINE = InnoDB, + PARTITION `p736926` VALUES LESS THAN (736926) ENGINE = InnoDB, + PARTITION `p736927` VALUES LESS THAN (736927) ENGINE = InnoDB, + PARTITION `p736928` VALUES LESS THAN (736928) ENGINE = InnoDB, + PARTITION `p736929` VALUES LESS THAN (736929) ENGINE = InnoDB, + PARTITION `p736930` VALUES LESS THAN (736930) ENGINE = InnoDB, + PARTITION `p736931` VALUES LESS THAN (736931) ENGINE = InnoDB, + PARTITION `p736932` VALUES LESS THAN (736932) ENGINE = InnoDB, + PARTITION `p736933` VALUES LESS THAN (736933) ENGINE = InnoDB, + PARTITION `p736934` VALUES LESS THAN (736934) ENGINE = InnoDB, + PARTITION `p736935` VALUES LESS THAN (736935) ENGINE = InnoDB, + PARTITION `p736936` VALUES LESS THAN (736936) ENGINE = InnoDB, + PARTITION `p736937` VALUES LESS THAN (736937) ENGINE = InnoDB, + PARTITION `p736938` VALUES LESS THAN (736938) ENGINE = InnoDB, + PARTITION `p736939` VALUES LESS THAN (736939) ENGINE = InnoDB, + PARTITION `p736940` VALUES LESS THAN (736940) ENGINE = InnoDB, + PARTITION `p736941` VALUES LESS THAN (736941) ENGINE = InnoDB, + PARTITION `p736942` VALUES LESS THAN (736942) ENGINE = InnoDB, + PARTITION `p736943` VALUES LESS THAN (736943) ENGINE = InnoDB, + PARTITION `p736944` VALUES LESS THAN (736944) ENGINE = InnoDB, + PARTITION `p736945` VALUES LESS THAN (736945) ENGINE = InnoDB, + PARTITION `p736946` VALUES LESS THAN (736946) ENGINE = InnoDB, + PARTITION `p736947` VALUES LESS THAN (736947) ENGINE = InnoDB, + PARTITION `p736948` VALUES LESS THAN (736948) ENGINE = InnoDB, + PARTITION `p736949` VALUES LESS THAN (736949) ENGINE = InnoDB, + PARTITION `p736950` VALUES LESS THAN (736950) ENGINE = InnoDB, + PARTITION `p736951` VALUES LESS THAN (736951) ENGINE = InnoDB, + PARTITION `p736952` VALUES LESS THAN (736952) ENGINE = InnoDB, + PARTITION `p736953` VALUES LESS THAN (736953) ENGINE = InnoDB, + PARTITION `p736954` VALUES LESS THAN (736954) ENGINE = InnoDB, + PARTITION `p736955` VALUES LESS THAN (736955) ENGINE = InnoDB, + PARTITION `p736956` VALUES LESS THAN (736956) ENGINE = InnoDB, + PARTITION `p736957` VALUES LESS THAN (736957) ENGINE = InnoDB, + PARTITION `p736958` VALUES LESS THAN (736958) ENGINE = InnoDB, + PARTITION `p736959` VALUES LESS THAN (736959) ENGINE = InnoDB, + PARTITION `p736960` VALUES LESS THAN (736960) ENGINE = InnoDB, + PARTITION `p736961` VALUES LESS THAN (736961) ENGINE = InnoDB, + PARTITION `p736962` VALUES LESS THAN (736962) ENGINE = InnoDB, + PARTITION `p736963` VALUES LESS THAN (736963) ENGINE = InnoDB, + PARTITION `p736964` VALUES LESS THAN (736964) ENGINE = InnoDB, + PARTITION `p736965` VALUES LESS THAN (736965) ENGINE = InnoDB, + PARTITION `p736966` VALUES LESS THAN (736966) ENGINE = InnoDB, + PARTITION `p736967` VALUES LESS THAN (736967) ENGINE = InnoDB, + PARTITION `p736968` VALUES LESS THAN (736968) ENGINE = InnoDB, + PARTITION `p736969` VALUES LESS THAN (736969) ENGINE = InnoDB, + PARTITION `p736970` VALUES LESS THAN (736970) ENGINE = InnoDB, + PARTITION `p736971` VALUES LESS THAN (736971) ENGINE = InnoDB, + PARTITION `p736972` VALUES LESS THAN (736972) ENGINE = InnoDB, + PARTITION `p736973` VALUES LESS THAN (736973) ENGINE = InnoDB, + PARTITION `p736974` VALUES LESS THAN (736974) ENGINE = InnoDB, + PARTITION `p736975` VALUES LESS THAN (736975) ENGINE = InnoDB, + PARTITION `p736976` VALUES LESS THAN (736976) ENGINE = InnoDB, + PARTITION `p736977` VALUES LESS THAN (736977) ENGINE = InnoDB, + PARTITION `p736978` VALUES LESS THAN (736978) ENGINE = InnoDB, + PARTITION `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) ENGINE = InnoDB, + PARTITION `p737011` VALUES LESS THAN (737011) ENGINE = InnoDB, + PARTITION `p737012` VALUES LESS THAN (737012) ENGINE = InnoDB, + PARTITION `p737013` VALUES LESS THAN (737013) ENGINE = InnoDB, + PARTITION `p737014` VALUES LESS THAN (737014) ENGINE = InnoDB, + PARTITION `p737015` VALUES LESS THAN (737015) ENGINE = InnoDB, + PARTITION `p737016` VALUES LESS THAN (737016) ENGINE = InnoDB, + PARTITION `p737017` VALUES LESS THAN (737017) ENGINE = InnoDB, + PARTITION `p737018` VALUES LESS THAN (737018) ENGINE = InnoDB, + PARTITION `p737019` VALUES LESS THAN (737019) ENGINE = InnoDB, + PARTITION `p737020` VALUES LESS THAN (737020) ENGINE = InnoDB, + PARTITION `p737021` VALUES LESS THAN (737021) ENGINE = InnoDB, + PARTITION `p737022` VALUES LESS THAN (737022) ENGINE = InnoDB, + PARTITION `p737023` VALUES LESS THAN (737023) ENGINE = InnoDB, + PARTITION `p737024` VALUES LESS THAN (737024) ENGINE = InnoDB, + PARTITION `p737025` VALUES LESS THAN (737025) ENGINE = InnoDB, + PARTITION `p737026` VALUES LESS THAN (737026) ENGINE = InnoDB, + PARTITION `p737027` VALUES LESS THAN (737027) ENGINE = InnoDB, + PARTITION `p737028` VALUES LESS THAN (737028) ENGINE = InnoDB, + PARTITION `p737029` VALUES LESS THAN (737029) ENGINE = InnoDB, + PARTITION `p737030` VALUES LESS THAN (737030) ENGINE = InnoDB, + PARTITION `p737031` VALUES LESS THAN (737031) ENGINE = InnoDB, + PARTITION `p737032` VALUES LESS THAN (737032) ENGINE = InnoDB, + PARTITION `p737033` VALUES LESS THAN (737033) ENGINE = InnoDB, + PARTITION `p737034` VALUES LESS THAN (737034) ENGINE = InnoDB, + PARTITION `p737035` VALUES LESS THAN (737035) ENGINE = InnoDB, + PARTITION `p737036` VALUES LESS THAN (737036) ENGINE = InnoDB, + PARTITION `p737037` VALUES LESS THAN (737037) ENGINE = InnoDB, + PARTITION `p737038` VALUES LESS THAN (737038) ENGINE = InnoDB, + PARTITION `p737039` VALUES LESS THAN (737039) ENGINE = InnoDB, + PARTITION `p737040` VALUES LESS THAN (737040) ENGINE = InnoDB, + PARTITION `p737041` VALUES LESS THAN (737041) ENGINE = InnoDB, + PARTITION `p737042` VALUES LESS THAN (737042) ENGINE = InnoDB, + PARTITION `p737043` VALUES LESS THAN (737043) ENGINE = InnoDB, + PARTITION `p737044` VALUES LESS THAN (737044) ENGINE = InnoDB, + PARTITION `p737045` VALUES LESS THAN (737045) ENGINE = InnoDB, + PARTITION `p737046` VALUES LESS THAN (737046) ENGINE = InnoDB, + PARTITION `p737047` VALUES LESS THAN (737047) ENGINE = InnoDB, + PARTITION `p737048` VALUES LESS THAN (737048) ENGINE = InnoDB, + PARTITION `p737049` VALUES LESS THAN (737049) ENGINE = InnoDB, + PARTITION `p737050` VALUES LESS THAN (737050) ENGINE = InnoDB, + PARTITION `p737051` VALUES LESS THAN (737051) ENGINE = InnoDB, + PARTITION `p737052` VALUES LESS THAN (737052) ENGINE = InnoDB, + PARTITION `p737053` VALUES LESS THAN (737053) ENGINE = InnoDB, + PARTITION `p737054` VALUES LESS THAN (737054) ENGINE = InnoDB, + PARTITION `p737055` VALUES LESS THAN (737055) ENGINE = InnoDB, + PARTITION `p737056` VALUES LESS THAN (737056) ENGINE = InnoDB, + PARTITION `p737057` VALUES LESS THAN (737057) ENGINE = InnoDB, + PARTITION `p737058` VALUES LESS THAN (737058) ENGINE = InnoDB, + PARTITION `p737059` VALUES LESS THAN (737059) ENGINE = InnoDB, + PARTITION `p737060` VALUES LESS THAN (737060) ENGINE = InnoDB, + PARTITION `p737061` VALUES LESS THAN (737061) ENGINE = InnoDB, + PARTITION `p737062` VALUES LESS THAN (737062) ENGINE = InnoDB, + PARTITION `p737063` VALUES LESS THAN (737063) ENGINE = InnoDB, + PARTITION `p737064` VALUES LESS THAN (737064) ENGINE = InnoDB, + PARTITION `p737065` VALUES LESS THAN (737065) ENGINE = InnoDB, + PARTITION `p737066` VALUES LESS THAN (737066) ENGINE = InnoDB, + PARTITION `p737067` VALUES LESS THAN (737067) ENGINE = InnoDB, + PARTITION `p737068` VALUES LESS THAN (737068) ENGINE = InnoDB, + PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB, + PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB, + PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB, + PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB, PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB, PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB, @@ -630,7 +962,8 @@ CREATE TABLE `t_metric_aggregate_customer_daily` ( PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB); + PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB, + PARTITION `p737144` VALUES LESS THAN (737144) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -647,7 +980,27 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (to_days(`aggregate_datetime`)) -(PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, +(PARTITION `p737052` VALUES LESS THAN (737052) ENGINE = InnoDB, + PARTITION `p737053` VALUES LESS THAN (737053) ENGINE = InnoDB, + PARTITION `p737054` VALUES LESS THAN (737054) ENGINE = InnoDB, + PARTITION `p737055` VALUES LESS THAN (737055) ENGINE = InnoDB, + PARTITION `p737056` VALUES LESS THAN (737056) ENGINE = InnoDB, + PARTITION `p737057` VALUES LESS THAN (737057) ENGINE = InnoDB, + PARTITION `p737058` VALUES LESS THAN (737058) ENGINE = InnoDB, + PARTITION `p737059` VALUES LESS THAN (737059) ENGINE = InnoDB, + PARTITION `p737060` VALUES LESS THAN (737060) ENGINE = InnoDB, + PARTITION `p737061` VALUES LESS THAN (737061) ENGINE = InnoDB, + PARTITION `p737062` VALUES LESS THAN (737062) ENGINE = InnoDB, + PARTITION `p737063` VALUES LESS THAN (737063) ENGINE = InnoDB, + PARTITION `p737064` VALUES LESS THAN (737064) ENGINE = InnoDB, + PARTITION `p737065` VALUES LESS THAN (737065) ENGINE = InnoDB, + PARTITION `p737066` VALUES LESS THAN (737066) ENGINE = InnoDB, + PARTITION `p737067` VALUES LESS THAN (737067) ENGINE = InnoDB, + PARTITION `p737068` VALUES LESS THAN (737068) ENGINE = InnoDB, + PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB, + PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB, + PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB, + PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB, PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB, PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB, @@ -718,7 +1071,8 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` ( PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB); + PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB, + PARTITION `p737144` VALUES LESS THAN (737144) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -757,7 +1111,332 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (to_days(`aggregate_datetime`)) -(PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, +(PARTITION `p736747` VALUES LESS THAN (736747) ENGINE = InnoDB, + PARTITION `p736748` VALUES LESS THAN (736748) ENGINE = InnoDB, + PARTITION `p736749` VALUES LESS THAN (736749) ENGINE = InnoDB, + PARTITION `p736750` VALUES LESS THAN (736750) ENGINE = InnoDB, + PARTITION `p736751` VALUES LESS THAN (736751) ENGINE = InnoDB, + PARTITION `p736752` VALUES LESS THAN (736752) ENGINE = InnoDB, + PARTITION `p736753` VALUES LESS THAN (736753) ENGINE = InnoDB, + PARTITION `p736754` VALUES LESS THAN (736754) ENGINE = InnoDB, + PARTITION `p736755` VALUES LESS THAN (736755) ENGINE = InnoDB, + PARTITION `p736756` VALUES LESS THAN (736756) ENGINE = InnoDB, + PARTITION `p736757` VALUES LESS THAN (736757) ENGINE = InnoDB, + PARTITION `p736758` VALUES LESS THAN (736758) ENGINE = InnoDB, + PARTITION `p736759` VALUES LESS THAN (736759) ENGINE = InnoDB, + PARTITION `p736760` VALUES LESS THAN (736760) ENGINE = InnoDB, + PARTITION `p736761` VALUES LESS THAN (736761) ENGINE = InnoDB, + PARTITION `p736762` VALUES LESS THAN (736762) ENGINE = InnoDB, + PARTITION `p736763` VALUES LESS THAN (736763) ENGINE = InnoDB, + PARTITION `p736764` VALUES LESS THAN (736764) ENGINE = InnoDB, + PARTITION `p736765` VALUES LESS THAN (736765) ENGINE = InnoDB, + PARTITION `p736766` VALUES LESS THAN (736766) ENGINE = InnoDB, + PARTITION `p736767` VALUES LESS THAN (736767) ENGINE = InnoDB, + PARTITION `p736768` VALUES LESS THAN (736768) ENGINE = InnoDB, + PARTITION `p736769` VALUES LESS THAN (736769) ENGINE = InnoDB, + PARTITION `p736770` VALUES LESS THAN (736770) ENGINE = InnoDB, + PARTITION `p736771` VALUES LESS THAN (736771) ENGINE = InnoDB, + PARTITION `p736772` VALUES LESS THAN (736772) ENGINE = InnoDB, + PARTITION `p736773` VALUES LESS THAN (736773) ENGINE = InnoDB, + PARTITION `p736774` VALUES LESS THAN (736774) ENGINE = InnoDB, + PARTITION `p736775` VALUES LESS THAN (736775) ENGINE = InnoDB, + PARTITION `p736776` VALUES LESS THAN (736776) ENGINE = InnoDB, + PARTITION `p736777` VALUES LESS THAN (736777) ENGINE = InnoDB, + PARTITION `p736778` VALUES LESS THAN (736778) ENGINE = InnoDB, + PARTITION `p736779` VALUES LESS THAN (736779) ENGINE = InnoDB, + PARTITION `p736780` VALUES LESS THAN (736780) ENGINE = InnoDB, + PARTITION `p736781` VALUES LESS THAN (736781) ENGINE = InnoDB, + PARTITION `p736782` VALUES LESS THAN (736782) ENGINE = InnoDB, + PARTITION `p736783` VALUES LESS THAN (736783) ENGINE = InnoDB, + PARTITION `p736784` VALUES LESS THAN (736784) ENGINE = InnoDB, + PARTITION `p736785` VALUES LESS THAN (736785) ENGINE = InnoDB, + PARTITION `p736786` VALUES LESS THAN (736786) ENGINE = InnoDB, + PARTITION `p736787` VALUES LESS THAN (736787) ENGINE = InnoDB, + PARTITION `p736788` VALUES LESS THAN (736788) ENGINE = InnoDB, + PARTITION `p736789` VALUES LESS THAN (736789) ENGINE = InnoDB, + PARTITION `p736790` VALUES LESS THAN (736790) ENGINE = InnoDB, + PARTITION `p736791` VALUES LESS THAN (736791) ENGINE = InnoDB, + PARTITION `p736792` VALUES LESS THAN (736792) ENGINE = InnoDB, + PARTITION `p736793` VALUES LESS THAN (736793) ENGINE = InnoDB, + PARTITION `p736794` VALUES LESS THAN (736794) ENGINE = InnoDB, + PARTITION `p736795` VALUES LESS THAN (736795) ENGINE = InnoDB, + PARTITION `p736796` VALUES LESS THAN (736796) ENGINE = InnoDB, + PARTITION `p736797` VALUES LESS THAN (736797) ENGINE = InnoDB, + PARTITION `p736798` VALUES LESS THAN (736798) ENGINE = InnoDB, + PARTITION `p736799` VALUES LESS THAN (736799) ENGINE = InnoDB, + PARTITION `p736800` VALUES LESS THAN (736800) ENGINE = InnoDB, + PARTITION `p736801` VALUES LESS THAN (736801) ENGINE = InnoDB, + PARTITION `p736802` VALUES LESS THAN (736802) ENGINE = InnoDB, + PARTITION `p736803` VALUES LESS THAN (736803) ENGINE = InnoDB, + PARTITION `p736804` VALUES LESS THAN (736804) ENGINE = InnoDB, + PARTITION `p736805` VALUES LESS THAN (736805) ENGINE = InnoDB, + PARTITION `p736806` VALUES LESS THAN (736806) ENGINE = InnoDB, + PARTITION `p736807` VALUES LESS THAN (736807) ENGINE = InnoDB, + PARTITION `p736808` VALUES LESS THAN (736808) ENGINE = InnoDB, + PARTITION `p736809` VALUES LESS THAN (736809) ENGINE = InnoDB, + PARTITION `p736810` VALUES LESS THAN (736810) ENGINE = InnoDB, + PARTITION `p736811` VALUES LESS THAN (736811) ENGINE = InnoDB, + PARTITION `p736812` VALUES LESS THAN (736812) ENGINE = InnoDB, + PARTITION `p736813` VALUES LESS THAN (736813) ENGINE = InnoDB, + PARTITION `p736814` VALUES LESS THAN (736814) ENGINE = InnoDB, + PARTITION `p736815` VALUES LESS THAN (736815) ENGINE = InnoDB, + PARTITION `p736816` VALUES LESS THAN (736816) ENGINE = InnoDB, + PARTITION `p736817` VALUES LESS THAN (736817) ENGINE = InnoDB, + PARTITION `p736818` VALUES LESS THAN (736818) ENGINE = InnoDB, + PARTITION `p736819` VALUES LESS THAN (736819) ENGINE = InnoDB, + PARTITION `p736820` VALUES LESS THAN (736820) ENGINE = InnoDB, + PARTITION `p736821` VALUES LESS THAN (736821) ENGINE = InnoDB, + PARTITION `p736822` VALUES LESS THAN (736822) ENGINE = InnoDB, + PARTITION `p736823` VALUES LESS THAN (736823) ENGINE = InnoDB, + PARTITION `p736824` VALUES LESS THAN (736824) ENGINE = InnoDB, + PARTITION `p736825` VALUES LESS THAN (736825) ENGINE = InnoDB, + PARTITION `p736826` VALUES LESS THAN (736826) ENGINE = InnoDB, + PARTITION `p736827` VALUES LESS THAN (736827) ENGINE = InnoDB, + PARTITION `p736828` VALUES LESS THAN (736828) ENGINE = InnoDB, + PARTITION `p736829` VALUES LESS THAN (736829) ENGINE = InnoDB, + PARTITION `p736830` VALUES LESS THAN (736830) ENGINE = InnoDB, + PARTITION `p736831` VALUES LESS THAN (736831) ENGINE = InnoDB, + PARTITION `p736832` VALUES LESS THAN (736832) ENGINE = InnoDB, + PARTITION `p736833` VALUES LESS THAN (736833) ENGINE = InnoDB, + PARTITION `p736834` VALUES LESS THAN (736834) ENGINE = InnoDB, + PARTITION `p736835` VALUES LESS THAN (736835) ENGINE = InnoDB, + PARTITION `p736836` VALUES LESS THAN (736836) ENGINE = InnoDB, + PARTITION `p736837` VALUES LESS THAN (736837) ENGINE = InnoDB, + PARTITION `p736838` VALUES LESS THAN (736838) ENGINE = InnoDB, + PARTITION `p736839` VALUES LESS THAN (736839) ENGINE = InnoDB, + PARTITION `p736840` VALUES LESS THAN (736840) ENGINE = InnoDB, + PARTITION `p736841` VALUES LESS THAN (736841) ENGINE = InnoDB, + PARTITION `p736842` VALUES LESS THAN (736842) ENGINE = InnoDB, + PARTITION `p736843` VALUES LESS THAN (736843) ENGINE = InnoDB, + PARTITION `p736844` VALUES LESS THAN (736844) ENGINE = InnoDB, + PARTITION `p736845` VALUES LESS THAN (736845) ENGINE = InnoDB, + PARTITION `p736846` VALUES LESS THAN (736846) ENGINE = InnoDB, + PARTITION `p736847` VALUES LESS THAN (736847) ENGINE = InnoDB, + PARTITION `p736848` VALUES LESS THAN (736848) ENGINE = InnoDB, + PARTITION `p736849` VALUES LESS THAN (736849) ENGINE = InnoDB, + PARTITION `p736850` VALUES LESS THAN (736850) ENGINE = InnoDB, + PARTITION `p736851` VALUES LESS THAN (736851) ENGINE = InnoDB, + PARTITION `p736852` VALUES LESS THAN (736852) ENGINE = InnoDB, + PARTITION `p736853` VALUES LESS THAN (736853) ENGINE = InnoDB, + PARTITION `p736854` VALUES LESS THAN (736854) ENGINE = InnoDB, + PARTITION `p736855` VALUES LESS THAN (736855) ENGINE = InnoDB, + PARTITION `p736856` VALUES LESS THAN (736856) ENGINE = InnoDB, + PARTITION `p736857` VALUES LESS THAN (736857) ENGINE = InnoDB, + PARTITION `p736858` VALUES LESS THAN (736858) ENGINE = InnoDB, + PARTITION `p736859` VALUES LESS THAN (736859) ENGINE = InnoDB, + PARTITION `p736860` VALUES LESS THAN (736860) ENGINE = InnoDB, + PARTITION `p736861` VALUES LESS THAN (736861) ENGINE = InnoDB, + PARTITION `p736862` VALUES LESS THAN (736862) ENGINE = InnoDB, + PARTITION `p736863` VALUES LESS THAN (736863) ENGINE = InnoDB, + PARTITION `p736864` VALUES LESS THAN (736864) ENGINE = InnoDB, + PARTITION `p736865` VALUES LESS THAN (736865) ENGINE = InnoDB, + PARTITION `p736866` VALUES LESS THAN (736866) ENGINE = InnoDB, + PARTITION `p736867` VALUES LESS THAN (736867) ENGINE = InnoDB, + PARTITION `p736868` VALUES LESS THAN (736868) ENGINE = InnoDB, + PARTITION `p736869` VALUES LESS THAN (736869) ENGINE = InnoDB, + PARTITION `p736870` VALUES LESS THAN (736870) ENGINE = InnoDB, + PARTITION `p736871` VALUES LESS THAN (736871) ENGINE = InnoDB, + PARTITION `p736872` VALUES LESS THAN (736872) ENGINE = InnoDB, + PARTITION `p736873` VALUES LESS THAN (736873) ENGINE = InnoDB, + PARTITION `p736874` VALUES LESS THAN (736874) ENGINE = InnoDB, + PARTITION `p736875` VALUES LESS THAN (736875) ENGINE = InnoDB, + PARTITION `p736876` VALUES LESS THAN (736876) ENGINE = InnoDB, + PARTITION `p736877` VALUES LESS THAN (736877) ENGINE = InnoDB, + PARTITION `p736878` VALUES LESS THAN (736878) ENGINE = InnoDB, + PARTITION `p736879` VALUES LESS THAN (736879) ENGINE = InnoDB, + PARTITION `p736880` VALUES LESS THAN (736880) ENGINE = InnoDB, + PARTITION `p736881` VALUES LESS THAN (736881) ENGINE = InnoDB, + PARTITION `p736882` VALUES LESS THAN (736882) ENGINE = InnoDB, + PARTITION `p736883` VALUES LESS THAN (736883) ENGINE = InnoDB, + PARTITION `p736884` VALUES LESS THAN (736884) ENGINE = InnoDB, + PARTITION `p736885` VALUES LESS THAN (736885) ENGINE = InnoDB, + PARTITION `p736886` VALUES LESS THAN (736886) ENGINE = InnoDB, + PARTITION `p736887` VALUES LESS THAN (736887) ENGINE = InnoDB, + PARTITION `p736888` VALUES LESS THAN (736888) ENGINE = InnoDB, + PARTITION `p736889` VALUES LESS THAN (736889) ENGINE = InnoDB, + PARTITION `p736890` VALUES LESS THAN (736890) ENGINE = InnoDB, + PARTITION `p736891` VALUES LESS THAN (736891) ENGINE = InnoDB, + PARTITION `p736892` VALUES LESS THAN (736892) ENGINE = InnoDB, + PARTITION `p736893` VALUES LESS THAN (736893) ENGINE = InnoDB, + PARTITION `p736894` VALUES LESS THAN (736894) ENGINE = InnoDB, + PARTITION `p736895` VALUES LESS THAN (736895) ENGINE = InnoDB, + PARTITION `p736896` VALUES LESS THAN (736896) ENGINE = InnoDB, + PARTITION `p736897` VALUES LESS THAN (736897) ENGINE = InnoDB, + PARTITION `p736898` VALUES LESS THAN (736898) ENGINE = InnoDB, + PARTITION `p736899` VALUES LESS THAN (736899) ENGINE = InnoDB, + PARTITION `p736900` VALUES LESS THAN (736900) ENGINE = InnoDB, + PARTITION `p736901` VALUES LESS THAN (736901) ENGINE = InnoDB, + PARTITION `p736902` VALUES LESS THAN (736902) ENGINE = InnoDB, + PARTITION `p736903` VALUES LESS THAN (736903) ENGINE = InnoDB, + PARTITION `p736904` VALUES LESS THAN (736904) ENGINE = InnoDB, + PARTITION `p736905` VALUES LESS THAN (736905) ENGINE = InnoDB, + PARTITION `p736906` VALUES LESS THAN (736906) ENGINE = InnoDB, + PARTITION `p736907` VALUES LESS THAN (736907) ENGINE = InnoDB, + PARTITION `p736908` VALUES LESS THAN (736908) ENGINE = InnoDB, + PARTITION `p736909` VALUES LESS THAN (736909) ENGINE = InnoDB, + PARTITION `p736910` VALUES LESS THAN (736910) ENGINE = InnoDB, + PARTITION `p736911` VALUES LESS THAN (736911) ENGINE = InnoDB, + PARTITION `p736912` VALUES LESS THAN (736912) ENGINE = InnoDB, + PARTITION `p736913` VALUES LESS THAN (736913) ENGINE = InnoDB, + PARTITION `p736914` VALUES LESS THAN (736914) ENGINE = InnoDB, + PARTITION `p736915` VALUES LESS THAN (736915) ENGINE = InnoDB, + PARTITION `p736916` VALUES LESS THAN (736916) ENGINE = InnoDB, + PARTITION `p736917` VALUES LESS THAN (736917) ENGINE = InnoDB, + PARTITION `p736918` VALUES LESS THAN (736918) ENGINE = InnoDB, + PARTITION `p736919` VALUES LESS THAN (736919) ENGINE = InnoDB, + PARTITION `p736920` VALUES LESS THAN (736920) ENGINE = InnoDB, + PARTITION `p736921` VALUES LESS THAN (736921) ENGINE = InnoDB, + PARTITION `p736922` VALUES LESS THAN (736922) ENGINE = InnoDB, + PARTITION `p736923` VALUES LESS THAN (736923) ENGINE = InnoDB, + PARTITION `p736924` VALUES LESS THAN (736924) ENGINE = InnoDB, + PARTITION `p736925` VALUES LESS THAN (736925) ENGINE = InnoDB, + PARTITION `p736926` VALUES LESS THAN (736926) ENGINE = InnoDB, + PARTITION `p736927` VALUES LESS THAN (736927) ENGINE = InnoDB, + PARTITION `p736928` VALUES LESS THAN (736928) ENGINE = InnoDB, + PARTITION `p736929` VALUES LESS THAN (736929) ENGINE = InnoDB, + PARTITION `p736930` VALUES LESS THAN (736930) ENGINE = InnoDB, + PARTITION `p736931` VALUES LESS THAN (736931) ENGINE = InnoDB, + PARTITION `p736932` VALUES LESS THAN (736932) ENGINE = InnoDB, + PARTITION `p736933` VALUES LESS THAN (736933) ENGINE = InnoDB, + PARTITION `p736934` VALUES LESS THAN (736934) ENGINE = InnoDB, + PARTITION `p736935` VALUES LESS THAN (736935) ENGINE = InnoDB, + PARTITION `p736936` VALUES LESS THAN (736936) ENGINE = InnoDB, + PARTITION `p736937` VALUES LESS THAN (736937) ENGINE = InnoDB, + PARTITION `p736938` VALUES LESS THAN (736938) ENGINE = InnoDB, + PARTITION `p736939` VALUES LESS THAN (736939) ENGINE = InnoDB, + PARTITION `p736940` VALUES LESS THAN (736940) ENGINE = InnoDB, + PARTITION `p736941` VALUES LESS THAN (736941) ENGINE = InnoDB, + PARTITION `p736942` VALUES LESS THAN (736942) ENGINE = InnoDB, + PARTITION `p736943` VALUES LESS THAN (736943) ENGINE = InnoDB, + PARTITION `p736944` VALUES LESS THAN (736944) ENGINE = InnoDB, + PARTITION `p736945` VALUES LESS THAN (736945) ENGINE = InnoDB, + PARTITION `p736946` VALUES LESS THAN (736946) ENGINE = InnoDB, + PARTITION `p736947` VALUES LESS THAN (736947) ENGINE = InnoDB, + PARTITION `p736948` VALUES LESS THAN (736948) ENGINE = InnoDB, + PARTITION `p736949` VALUES LESS THAN (736949) ENGINE = InnoDB, + PARTITION `p736950` VALUES LESS THAN (736950) ENGINE = InnoDB, + PARTITION `p736951` VALUES LESS THAN (736951) ENGINE = InnoDB, + PARTITION `p736952` VALUES LESS THAN (736952) ENGINE = InnoDB, + PARTITION `p736953` VALUES LESS THAN (736953) ENGINE = InnoDB, + PARTITION `p736954` VALUES LESS THAN (736954) ENGINE = InnoDB, + PARTITION `p736955` VALUES LESS THAN (736955) ENGINE = InnoDB, + PARTITION `p736956` VALUES LESS THAN (736956) ENGINE = InnoDB, + PARTITION `p736957` VALUES LESS THAN (736957) ENGINE = InnoDB, + PARTITION `p736958` VALUES LESS THAN (736958) ENGINE = InnoDB, + PARTITION `p736959` VALUES LESS THAN (736959) ENGINE = InnoDB, + PARTITION `p736960` VALUES LESS THAN (736960) ENGINE = InnoDB, + PARTITION `p736961` VALUES LESS THAN (736961) ENGINE = InnoDB, + PARTITION `p736962` VALUES LESS THAN (736962) ENGINE = InnoDB, + PARTITION `p736963` VALUES LESS THAN (736963) ENGINE = InnoDB, + PARTITION `p736964` VALUES LESS THAN (736964) ENGINE = InnoDB, + PARTITION `p736965` VALUES LESS THAN (736965) ENGINE = InnoDB, + PARTITION `p736966` VALUES LESS THAN (736966) ENGINE = InnoDB, + PARTITION `p736967` VALUES LESS THAN (736967) ENGINE = InnoDB, + PARTITION `p736968` VALUES LESS THAN (736968) ENGINE = InnoDB, + PARTITION `p736969` VALUES LESS THAN (736969) ENGINE = InnoDB, + PARTITION `p736970` VALUES LESS THAN (736970) ENGINE = InnoDB, + PARTITION `p736971` VALUES LESS THAN (736971) ENGINE = InnoDB, + PARTITION `p736972` VALUES LESS THAN (736972) ENGINE = InnoDB, + PARTITION `p736973` VALUES LESS THAN (736973) ENGINE = InnoDB, + PARTITION `p736974` VALUES LESS THAN (736974) ENGINE = InnoDB, + PARTITION `p736975` VALUES LESS THAN (736975) ENGINE = InnoDB, + PARTITION `p736976` VALUES LESS THAN (736976) ENGINE = InnoDB, + PARTITION `p736977` VALUES LESS THAN (736977) ENGINE = InnoDB, + PARTITION `p736978` VALUES LESS THAN (736978) ENGINE = InnoDB, + PARTITION `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) ENGINE = InnoDB, + PARTITION `p737011` VALUES LESS THAN (737011) ENGINE = InnoDB, + PARTITION `p737012` VALUES LESS THAN (737012) ENGINE = InnoDB, + PARTITION `p737013` VALUES LESS THAN (737013) ENGINE = InnoDB, + PARTITION `p737014` VALUES LESS THAN (737014) ENGINE = InnoDB, + PARTITION `p737015` VALUES LESS THAN (737015) ENGINE = InnoDB, + PARTITION `p737016` VALUES LESS THAN (737016) ENGINE = InnoDB, + PARTITION `p737017` VALUES LESS THAN (737017) ENGINE = InnoDB, + PARTITION `p737018` VALUES LESS THAN (737018) ENGINE = InnoDB, + PARTITION `p737019` VALUES LESS THAN (737019) ENGINE = InnoDB, + PARTITION `p737020` VALUES LESS THAN (737020) ENGINE = InnoDB, + PARTITION `p737021` VALUES LESS THAN (737021) ENGINE = InnoDB, + PARTITION `p737022` VALUES LESS THAN (737022) ENGINE = InnoDB, + PARTITION `p737023` VALUES LESS THAN (737023) ENGINE = InnoDB, + PARTITION `p737024` VALUES LESS THAN (737024) ENGINE = InnoDB, + PARTITION `p737025` VALUES LESS THAN (737025) ENGINE = InnoDB, + PARTITION `p737026` VALUES LESS THAN (737026) ENGINE = InnoDB, + PARTITION `p737027` VALUES LESS THAN (737027) ENGINE = InnoDB, + PARTITION `p737028` VALUES LESS THAN (737028) ENGINE = InnoDB, + PARTITION `p737029` VALUES LESS THAN (737029) ENGINE = InnoDB, + PARTITION `p737030` VALUES LESS THAN (737030) ENGINE = InnoDB, + PARTITION `p737031` VALUES LESS THAN (737031) ENGINE = InnoDB, + PARTITION `p737032` VALUES LESS THAN (737032) ENGINE = InnoDB, + PARTITION `p737033` VALUES LESS THAN (737033) ENGINE = InnoDB, + PARTITION `p737034` VALUES LESS THAN (737034) ENGINE = InnoDB, + PARTITION `p737035` VALUES LESS THAN (737035) ENGINE = InnoDB, + PARTITION `p737036` VALUES LESS THAN (737036) ENGINE = InnoDB, + PARTITION `p737037` VALUES LESS THAN (737037) ENGINE = InnoDB, + PARTITION `p737038` VALUES LESS THAN (737038) ENGINE = InnoDB, + PARTITION `p737039` VALUES LESS THAN (737039) ENGINE = InnoDB, + PARTITION `p737040` VALUES LESS THAN (737040) ENGINE = InnoDB, + PARTITION `p737041` VALUES LESS THAN (737041) ENGINE = InnoDB, + PARTITION `p737042` VALUES LESS THAN (737042) ENGINE = InnoDB, + PARTITION `p737043` VALUES LESS THAN (737043) ENGINE = InnoDB, + PARTITION `p737044` VALUES LESS THAN (737044) ENGINE = InnoDB, + PARTITION `p737045` VALUES LESS THAN (737045) ENGINE = InnoDB, + PARTITION `p737046` VALUES LESS THAN (737046) ENGINE = InnoDB, + PARTITION `p737047` VALUES LESS THAN (737047) ENGINE = InnoDB, + PARTITION `p737048` VALUES LESS THAN (737048) ENGINE = InnoDB, + PARTITION `p737049` VALUES LESS THAN (737049) ENGINE = InnoDB, + PARTITION `p737050` VALUES LESS THAN (737050) ENGINE = InnoDB, + PARTITION `p737051` VALUES LESS THAN (737051) ENGINE = InnoDB, + PARTITION `p737052` VALUES LESS THAN (737052) ENGINE = InnoDB, + PARTITION `p737053` VALUES LESS THAN (737053) ENGINE = InnoDB, + PARTITION `p737054` VALUES LESS THAN (737054) ENGINE = InnoDB, + PARTITION `p737055` VALUES LESS THAN (737055) ENGINE = InnoDB, + PARTITION `p737056` VALUES LESS THAN (737056) ENGINE = InnoDB, + PARTITION `p737057` VALUES LESS THAN (737057) ENGINE = InnoDB, + PARTITION `p737058` VALUES LESS THAN (737058) ENGINE = InnoDB, + PARTITION `p737059` VALUES LESS THAN (737059) ENGINE = InnoDB, + PARTITION `p737060` VALUES LESS THAN (737060) ENGINE = InnoDB, + PARTITION `p737061` VALUES LESS THAN (737061) ENGINE = InnoDB, + PARTITION `p737062` VALUES LESS THAN (737062) ENGINE = InnoDB, + PARTITION `p737063` VALUES LESS THAN (737063) ENGINE = InnoDB, + PARTITION `p737064` VALUES LESS THAN (737064) ENGINE = InnoDB, + PARTITION `p737065` VALUES LESS THAN (737065) ENGINE = InnoDB, + PARTITION `p737066` VALUES LESS THAN (737066) ENGINE = InnoDB, + PARTITION `p737067` VALUES LESS THAN (737067) ENGINE = InnoDB, + PARTITION `p737068` VALUES LESS THAN (737068) ENGINE = InnoDB, + PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB, + PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB, + PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB, + PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB, PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB, PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB, @@ -828,7 +1507,8 @@ CREATE TABLE `t_metric_aggregate_resource_daily` ( PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB); + PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB, + PARTITION `p737144` VALUES LESS THAN (737144) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -848,7 +1528,27 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PRIMARY KEY (`metric_id`,`resource_id`,`resource_foreign_id`,`service_region_id`,`aggregate_datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (to_days(`aggregate_datetime`)) -(PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, +(PARTITION `p737052` VALUES LESS THAN (737052) ENGINE = InnoDB, + PARTITION `p737053` VALUES LESS THAN (737053) ENGINE = InnoDB, + PARTITION `p737054` VALUES LESS THAN (737054) ENGINE = InnoDB, + PARTITION `p737055` VALUES LESS THAN (737055) ENGINE = InnoDB, + PARTITION `p737056` VALUES LESS THAN (737056) ENGINE = InnoDB, + PARTITION `p737057` VALUES LESS THAN (737057) ENGINE = InnoDB, + PARTITION `p737058` VALUES LESS THAN (737058) ENGINE = InnoDB, + PARTITION `p737059` VALUES LESS THAN (737059) ENGINE = InnoDB, + PARTITION `p737060` VALUES LESS THAN (737060) ENGINE = InnoDB, + PARTITION `p737061` VALUES LESS THAN (737061) ENGINE = InnoDB, + PARTITION `p737062` VALUES LESS THAN (737062) ENGINE = InnoDB, + PARTITION `p737063` VALUES LESS THAN (737063) ENGINE = InnoDB, + PARTITION `p737064` VALUES LESS THAN (737064) ENGINE = InnoDB, + PARTITION `p737065` VALUES LESS THAN (737065) ENGINE = InnoDB, + PARTITION `p737066` VALUES LESS THAN (737066) ENGINE = InnoDB, + PARTITION `p737067` VALUES LESS THAN (737067) ENGINE = InnoDB, + PARTITION `p737068` VALUES LESS THAN (737068) ENGINE = InnoDB, + PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB, + PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB, + PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB, + PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB, PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB, PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB, @@ -919,7 +1619,8 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` ( PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB); + PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB, + PARTITION `p737144` VALUES LESS THAN (737144) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -959,7 +1660,332 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (to_days(`aggregate_datetime`)) -(PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, +(PARTITION `p736747` VALUES LESS THAN (736747) ENGINE = InnoDB, + PARTITION `p736748` VALUES LESS THAN (736748) ENGINE = InnoDB, + PARTITION `p736749` VALUES LESS THAN (736749) ENGINE = InnoDB, + PARTITION `p736750` VALUES LESS THAN (736750) ENGINE = InnoDB, + PARTITION `p736751` VALUES LESS THAN (736751) ENGINE = InnoDB, + PARTITION `p736752` VALUES LESS THAN (736752) ENGINE = InnoDB, + PARTITION `p736753` VALUES LESS THAN (736753) ENGINE = InnoDB, + PARTITION `p736754` VALUES LESS THAN (736754) ENGINE = InnoDB, + PARTITION `p736755` VALUES LESS THAN (736755) ENGINE = InnoDB, + PARTITION `p736756` VALUES LESS THAN (736756) ENGINE = InnoDB, + PARTITION `p736757` VALUES LESS THAN (736757) ENGINE = InnoDB, + PARTITION `p736758` VALUES LESS THAN (736758) ENGINE = InnoDB, + PARTITION `p736759` VALUES LESS THAN (736759) ENGINE = InnoDB, + PARTITION `p736760` VALUES LESS THAN (736760) ENGINE = InnoDB, + PARTITION `p736761` VALUES LESS THAN (736761) ENGINE = InnoDB, + PARTITION `p736762` VALUES LESS THAN (736762) ENGINE = InnoDB, + PARTITION `p736763` VALUES LESS THAN (736763) ENGINE = InnoDB, + PARTITION `p736764` VALUES LESS THAN (736764) ENGINE = InnoDB, + PARTITION `p736765` VALUES LESS THAN (736765) ENGINE = InnoDB, + PARTITION `p736766` VALUES LESS THAN (736766) ENGINE = InnoDB, + PARTITION `p736767` VALUES LESS THAN (736767) ENGINE = InnoDB, + PARTITION `p736768` VALUES LESS THAN (736768) ENGINE = InnoDB, + PARTITION `p736769` VALUES LESS THAN (736769) ENGINE = InnoDB, + PARTITION `p736770` VALUES LESS THAN (736770) ENGINE = InnoDB, + PARTITION `p736771` VALUES LESS THAN (736771) ENGINE = InnoDB, + PARTITION `p736772` VALUES LESS THAN (736772) ENGINE = InnoDB, + PARTITION `p736773` VALUES LESS THAN (736773) ENGINE = InnoDB, + PARTITION `p736774` VALUES LESS THAN (736774) ENGINE = InnoDB, + PARTITION `p736775` VALUES LESS THAN (736775) ENGINE = InnoDB, + PARTITION `p736776` VALUES LESS THAN (736776) ENGINE = InnoDB, + PARTITION `p736777` VALUES LESS THAN (736777) ENGINE = InnoDB, + PARTITION `p736778` VALUES LESS THAN (736778) ENGINE = InnoDB, + PARTITION `p736779` VALUES LESS THAN (736779) ENGINE = InnoDB, + PARTITION `p736780` VALUES LESS THAN (736780) ENGINE = InnoDB, + PARTITION `p736781` VALUES LESS THAN (736781) ENGINE = InnoDB, + PARTITION `p736782` VALUES LESS THAN (736782) ENGINE = InnoDB, + PARTITION `p736783` VALUES LESS THAN (736783) ENGINE = InnoDB, + PARTITION `p736784` VALUES LESS THAN (736784) ENGINE = InnoDB, + PARTITION `p736785` VALUES LESS THAN (736785) ENGINE = InnoDB, + PARTITION `p736786` VALUES LESS THAN (736786) ENGINE = InnoDB, + PARTITION `p736787` VALUES LESS THAN (736787) ENGINE = InnoDB, + PARTITION `p736788` VALUES LESS THAN (736788) ENGINE = InnoDB, + PARTITION `p736789` VALUES LESS THAN (736789) ENGINE = InnoDB, + PARTITION `p736790` VALUES LESS THAN (736790) ENGINE = InnoDB, + PARTITION `p736791` VALUES LESS THAN (736791) ENGINE = InnoDB, + PARTITION `p736792` VALUES LESS THAN (736792) ENGINE = InnoDB, + PARTITION `p736793` VALUES LESS THAN (736793) ENGINE = InnoDB, + PARTITION `p736794` VALUES LESS THAN (736794) ENGINE = InnoDB, + PARTITION `p736795` VALUES LESS THAN (736795) ENGINE = InnoDB, + PARTITION `p736796` VALUES LESS THAN (736796) ENGINE = InnoDB, + PARTITION `p736797` VALUES LESS THAN (736797) ENGINE = InnoDB, + PARTITION `p736798` VALUES LESS THAN (736798) ENGINE = InnoDB, + PARTITION `p736799` VALUES LESS THAN (736799) ENGINE = InnoDB, + PARTITION `p736800` VALUES LESS THAN (736800) ENGINE = InnoDB, + PARTITION `p736801` VALUES LESS THAN (736801) ENGINE = InnoDB, + PARTITION `p736802` VALUES LESS THAN (736802) ENGINE = InnoDB, + PARTITION `p736803` VALUES LESS THAN (736803) ENGINE = InnoDB, + PARTITION `p736804` VALUES LESS THAN (736804) ENGINE = InnoDB, + PARTITION `p736805` VALUES LESS THAN (736805) ENGINE = InnoDB, + PARTITION `p736806` VALUES LESS THAN (736806) ENGINE = InnoDB, + PARTITION `p736807` VALUES LESS THAN (736807) ENGINE = InnoDB, + PARTITION `p736808` VALUES LESS THAN (736808) ENGINE = InnoDB, + PARTITION `p736809` VALUES LESS THAN (736809) ENGINE = InnoDB, + PARTITION `p736810` VALUES LESS THAN (736810) ENGINE = InnoDB, + PARTITION `p736811` VALUES LESS THAN (736811) ENGINE = InnoDB, + PARTITION `p736812` VALUES LESS THAN (736812) ENGINE = InnoDB, + PARTITION `p736813` VALUES LESS THAN (736813) ENGINE = InnoDB, + PARTITION `p736814` VALUES LESS THAN (736814) ENGINE = InnoDB, + PARTITION `p736815` VALUES LESS THAN (736815) ENGINE = InnoDB, + PARTITION `p736816` VALUES LESS THAN (736816) ENGINE = InnoDB, + PARTITION `p736817` VALUES LESS THAN (736817) ENGINE = InnoDB, + PARTITION `p736818` VALUES LESS THAN (736818) ENGINE = InnoDB, + PARTITION `p736819` VALUES LESS THAN (736819) ENGINE = InnoDB, + PARTITION `p736820` VALUES LESS THAN (736820) ENGINE = InnoDB, + PARTITION `p736821` VALUES LESS THAN (736821) ENGINE = InnoDB, + PARTITION `p736822` VALUES LESS THAN (736822) ENGINE = InnoDB, + PARTITION `p736823` VALUES LESS THAN (736823) ENGINE = InnoDB, + PARTITION `p736824` VALUES LESS THAN (736824) ENGINE = InnoDB, + PARTITION `p736825` VALUES LESS THAN (736825) ENGINE = InnoDB, + PARTITION `p736826` VALUES LESS THAN (736826) ENGINE = InnoDB, + PARTITION `p736827` VALUES LESS THAN (736827) ENGINE = InnoDB, + PARTITION `p736828` VALUES LESS THAN (736828) ENGINE = InnoDB, + PARTITION `p736829` VALUES LESS THAN (736829) ENGINE = InnoDB, + PARTITION `p736830` VALUES LESS THAN (736830) ENGINE = InnoDB, + PARTITION `p736831` VALUES LESS THAN (736831) ENGINE = InnoDB, + PARTITION `p736832` VALUES LESS THAN (736832) ENGINE = InnoDB, + PARTITION `p736833` VALUES LESS THAN (736833) ENGINE = InnoDB, + PARTITION `p736834` VALUES LESS THAN (736834) ENGINE = InnoDB, + PARTITION `p736835` VALUES LESS THAN (736835) ENGINE = InnoDB, + PARTITION `p736836` VALUES LESS THAN (736836) ENGINE = InnoDB, + PARTITION `p736837` VALUES LESS THAN (736837) ENGINE = InnoDB, + PARTITION `p736838` VALUES LESS THAN (736838) ENGINE = InnoDB, + PARTITION `p736839` VALUES LESS THAN (736839) ENGINE = InnoDB, + PARTITION `p736840` VALUES LESS THAN (736840) ENGINE = InnoDB, + PARTITION `p736841` VALUES LESS THAN (736841) ENGINE = InnoDB, + PARTITION `p736842` VALUES LESS THAN (736842) ENGINE = InnoDB, + PARTITION `p736843` VALUES LESS THAN (736843) ENGINE = InnoDB, + PARTITION `p736844` VALUES LESS THAN (736844) ENGINE = InnoDB, + PARTITION `p736845` VALUES LESS THAN (736845) ENGINE = InnoDB, + PARTITION `p736846` VALUES LESS THAN (736846) ENGINE = InnoDB, + PARTITION `p736847` VALUES LESS THAN (736847) ENGINE = InnoDB, + PARTITION `p736848` VALUES LESS THAN (736848) ENGINE = InnoDB, + PARTITION `p736849` VALUES LESS THAN (736849) ENGINE = InnoDB, + PARTITION `p736850` VALUES LESS THAN (736850) ENGINE = InnoDB, + PARTITION `p736851` VALUES LESS THAN (736851) ENGINE = InnoDB, + PARTITION `p736852` VALUES LESS THAN (736852) ENGINE = InnoDB, + PARTITION `p736853` VALUES LESS THAN (736853) ENGINE = InnoDB, + PARTITION `p736854` VALUES LESS THAN (736854) ENGINE = InnoDB, + PARTITION `p736855` VALUES LESS THAN (736855) ENGINE = InnoDB, + PARTITION `p736856` VALUES LESS THAN (736856) ENGINE = InnoDB, + PARTITION `p736857` VALUES LESS THAN (736857) ENGINE = InnoDB, + PARTITION `p736858` VALUES LESS THAN (736858) ENGINE = InnoDB, + PARTITION `p736859` VALUES LESS THAN (736859) ENGINE = InnoDB, + PARTITION `p736860` VALUES LESS THAN (736860) ENGINE = InnoDB, + PARTITION `p736861` VALUES LESS THAN (736861) ENGINE = InnoDB, + PARTITION `p736862` VALUES LESS THAN (736862) ENGINE = InnoDB, + PARTITION `p736863` VALUES LESS THAN (736863) ENGINE = InnoDB, + PARTITION `p736864` VALUES LESS THAN (736864) ENGINE = InnoDB, + PARTITION `p736865` VALUES LESS THAN (736865) ENGINE = InnoDB, + PARTITION `p736866` VALUES LESS THAN (736866) ENGINE = InnoDB, + PARTITION `p736867` VALUES LESS THAN (736867) ENGINE = InnoDB, + PARTITION `p736868` VALUES LESS THAN (736868) ENGINE = InnoDB, + PARTITION `p736869` VALUES LESS THAN (736869) ENGINE = InnoDB, + PARTITION `p736870` VALUES LESS THAN (736870) ENGINE = InnoDB, + PARTITION `p736871` VALUES LESS THAN (736871) ENGINE = InnoDB, + PARTITION `p736872` VALUES LESS THAN (736872) ENGINE = InnoDB, + PARTITION `p736873` VALUES LESS THAN (736873) ENGINE = InnoDB, + PARTITION `p736874` VALUES LESS THAN (736874) ENGINE = InnoDB, + PARTITION `p736875` VALUES LESS THAN (736875) ENGINE = InnoDB, + PARTITION `p736876` VALUES LESS THAN (736876) ENGINE = InnoDB, + PARTITION `p736877` VALUES LESS THAN (736877) ENGINE = InnoDB, + PARTITION `p736878` VALUES LESS THAN (736878) ENGINE = InnoDB, + PARTITION `p736879` VALUES LESS THAN (736879) ENGINE = InnoDB, + PARTITION `p736880` VALUES LESS THAN (736880) ENGINE = InnoDB, + PARTITION `p736881` VALUES LESS THAN (736881) ENGINE = InnoDB, + PARTITION `p736882` VALUES LESS THAN (736882) ENGINE = InnoDB, + PARTITION `p736883` VALUES LESS THAN (736883) ENGINE = InnoDB, + PARTITION `p736884` VALUES LESS THAN (736884) ENGINE = InnoDB, + PARTITION `p736885` VALUES LESS THAN (736885) ENGINE = InnoDB, + PARTITION `p736886` VALUES LESS THAN (736886) ENGINE = InnoDB, + PARTITION `p736887` VALUES LESS THAN (736887) ENGINE = InnoDB, + PARTITION `p736888` VALUES LESS THAN (736888) ENGINE = InnoDB, + PARTITION `p736889` VALUES LESS THAN (736889) ENGINE = InnoDB, + PARTITION `p736890` VALUES LESS THAN (736890) ENGINE = InnoDB, + PARTITION `p736891` VALUES LESS THAN (736891) ENGINE = InnoDB, + PARTITION `p736892` VALUES LESS THAN (736892) ENGINE = InnoDB, + PARTITION `p736893` VALUES LESS THAN (736893) ENGINE = InnoDB, + PARTITION `p736894` VALUES LESS THAN (736894) ENGINE = InnoDB, + PARTITION `p736895` VALUES LESS THAN (736895) ENGINE = InnoDB, + PARTITION `p736896` VALUES LESS THAN (736896) ENGINE = InnoDB, + PARTITION `p736897` VALUES LESS THAN (736897) ENGINE = InnoDB, + PARTITION `p736898` VALUES LESS THAN (736898) ENGINE = InnoDB, + PARTITION `p736899` VALUES LESS THAN (736899) ENGINE = InnoDB, + PARTITION `p736900` VALUES LESS THAN (736900) ENGINE = InnoDB, + PARTITION `p736901` VALUES LESS THAN (736901) ENGINE = InnoDB, + PARTITION `p736902` VALUES LESS THAN (736902) ENGINE = InnoDB, + PARTITION `p736903` VALUES LESS THAN (736903) ENGINE = InnoDB, + PARTITION `p736904` VALUES LESS THAN (736904) ENGINE = InnoDB, + PARTITION `p736905` VALUES LESS THAN (736905) ENGINE = InnoDB, + PARTITION `p736906` VALUES LESS THAN (736906) ENGINE = InnoDB, + PARTITION `p736907` VALUES LESS THAN (736907) ENGINE = InnoDB, + PARTITION `p736908` VALUES LESS THAN (736908) ENGINE = InnoDB, + PARTITION `p736909` VALUES LESS THAN (736909) ENGINE = InnoDB, + PARTITION `p736910` VALUES LESS THAN (736910) ENGINE = InnoDB, + PARTITION `p736911` VALUES LESS THAN (736911) ENGINE = InnoDB, + PARTITION `p736912` VALUES LESS THAN (736912) ENGINE = InnoDB, + PARTITION `p736913` VALUES LESS THAN (736913) ENGINE = InnoDB, + PARTITION `p736914` VALUES LESS THAN (736914) ENGINE = InnoDB, + PARTITION `p736915` VALUES LESS THAN (736915) ENGINE = InnoDB, + PARTITION `p736916` VALUES LESS THAN (736916) ENGINE = InnoDB, + PARTITION `p736917` VALUES LESS THAN (736917) ENGINE = InnoDB, + PARTITION `p736918` VALUES LESS THAN (736918) ENGINE = InnoDB, + PARTITION `p736919` VALUES LESS THAN (736919) ENGINE = InnoDB, + PARTITION `p736920` VALUES LESS THAN (736920) ENGINE = InnoDB, + PARTITION `p736921` VALUES LESS THAN (736921) ENGINE = InnoDB, + PARTITION `p736922` VALUES LESS THAN (736922) ENGINE = InnoDB, + PARTITION `p736923` VALUES LESS THAN (736923) ENGINE = InnoDB, + PARTITION `p736924` VALUES LESS THAN (736924) ENGINE = InnoDB, + PARTITION `p736925` VALUES LESS THAN (736925) ENGINE = InnoDB, + PARTITION `p736926` VALUES LESS THAN (736926) ENGINE = InnoDB, + PARTITION `p736927` VALUES LESS THAN (736927) ENGINE = InnoDB, + PARTITION `p736928` VALUES LESS THAN (736928) ENGINE = InnoDB, + PARTITION `p736929` VALUES LESS THAN (736929) ENGINE = InnoDB, + PARTITION `p736930` VALUES LESS THAN (736930) ENGINE = InnoDB, + PARTITION `p736931` VALUES LESS THAN (736931) ENGINE = InnoDB, + PARTITION `p736932` VALUES LESS THAN (736932) ENGINE = InnoDB, + PARTITION `p736933` VALUES LESS THAN (736933) ENGINE = InnoDB, + PARTITION `p736934` VALUES LESS THAN (736934) ENGINE = InnoDB, + PARTITION `p736935` VALUES LESS THAN (736935) ENGINE = InnoDB, + PARTITION `p736936` VALUES LESS THAN (736936) ENGINE = InnoDB, + PARTITION `p736937` VALUES LESS THAN (736937) ENGINE = InnoDB, + PARTITION `p736938` VALUES LESS THAN (736938) ENGINE = InnoDB, + PARTITION `p736939` VALUES LESS THAN (736939) ENGINE = InnoDB, + PARTITION `p736940` VALUES LESS THAN (736940) ENGINE = InnoDB, + PARTITION `p736941` VALUES LESS THAN (736941) ENGINE = InnoDB, + PARTITION `p736942` VALUES LESS THAN (736942) ENGINE = InnoDB, + PARTITION `p736943` VALUES LESS THAN (736943) ENGINE = InnoDB, + PARTITION `p736944` VALUES LESS THAN (736944) ENGINE = InnoDB, + PARTITION `p736945` VALUES LESS THAN (736945) ENGINE = InnoDB, + PARTITION `p736946` VALUES LESS THAN (736946) ENGINE = InnoDB, + PARTITION `p736947` VALUES LESS THAN (736947) ENGINE = InnoDB, + PARTITION `p736948` VALUES LESS THAN (736948) ENGINE = InnoDB, + PARTITION `p736949` VALUES LESS THAN (736949) ENGINE = InnoDB, + PARTITION `p736950` VALUES LESS THAN (736950) ENGINE = InnoDB, + PARTITION `p736951` VALUES LESS THAN (736951) ENGINE = InnoDB, + PARTITION `p736952` VALUES LESS THAN (736952) ENGINE = InnoDB, + PARTITION `p736953` VALUES LESS THAN (736953) ENGINE = InnoDB, + PARTITION `p736954` VALUES LESS THAN (736954) ENGINE = InnoDB, + PARTITION `p736955` VALUES LESS THAN (736955) ENGINE = InnoDB, + PARTITION `p736956` VALUES LESS THAN (736956) ENGINE = InnoDB, + PARTITION `p736957` VALUES LESS THAN (736957) ENGINE = InnoDB, + PARTITION `p736958` VALUES LESS THAN (736958) ENGINE = InnoDB, + PARTITION `p736959` VALUES LESS THAN (736959) ENGINE = InnoDB, + PARTITION `p736960` VALUES LESS THAN (736960) ENGINE = InnoDB, + PARTITION `p736961` VALUES LESS THAN (736961) ENGINE = InnoDB, + PARTITION `p736962` VALUES LESS THAN (736962) ENGINE = InnoDB, + PARTITION `p736963` VALUES LESS THAN (736963) ENGINE = InnoDB, + PARTITION `p736964` VALUES LESS THAN (736964) ENGINE = InnoDB, + PARTITION `p736965` VALUES LESS THAN (736965) ENGINE = InnoDB, + PARTITION `p736966` VALUES LESS THAN (736966) ENGINE = InnoDB, + PARTITION `p736967` VALUES LESS THAN (736967) ENGINE = InnoDB, + PARTITION `p736968` VALUES LESS THAN (736968) ENGINE = InnoDB, + PARTITION `p736969` VALUES LESS THAN (736969) ENGINE = InnoDB, + PARTITION `p736970` VALUES LESS THAN (736970) ENGINE = InnoDB, + PARTITION `p736971` VALUES LESS THAN (736971) ENGINE = InnoDB, + PARTITION `p736972` VALUES LESS THAN (736972) ENGINE = InnoDB, + PARTITION `p736973` VALUES LESS THAN (736973) ENGINE = InnoDB, + PARTITION `p736974` VALUES LESS THAN (736974) ENGINE = InnoDB, + PARTITION `p736975` VALUES LESS THAN (736975) ENGINE = InnoDB, + PARTITION `p736976` VALUES LESS THAN (736976) ENGINE = InnoDB, + PARTITION `p736977` VALUES LESS THAN (736977) ENGINE = InnoDB, + PARTITION `p736978` VALUES LESS THAN (736978) ENGINE = InnoDB, + PARTITION `p736979` VALUES LESS THAN (736979) ENGINE = InnoDB, + PARTITION `p736980` VALUES LESS THAN (736980) ENGINE = InnoDB, + PARTITION `p736981` VALUES LESS THAN (736981) ENGINE = InnoDB, + PARTITION `p736982` VALUES LESS THAN (736982) ENGINE = InnoDB, + PARTITION `p736983` VALUES LESS THAN (736983) ENGINE = InnoDB, + PARTITION `p736984` VALUES LESS THAN (736984) ENGINE = InnoDB, + PARTITION `p736985` VALUES LESS THAN (736985) ENGINE = InnoDB, + PARTITION `p736986` VALUES LESS THAN (736986) ENGINE = InnoDB, + PARTITION `p736987` VALUES LESS THAN (736987) ENGINE = InnoDB, + PARTITION `p736988` VALUES LESS THAN (736988) ENGINE = InnoDB, + PARTITION `p736989` VALUES LESS THAN (736989) ENGINE = InnoDB, + PARTITION `p736990` VALUES LESS THAN (736990) ENGINE = InnoDB, + PARTITION `p736991` VALUES LESS THAN (736991) ENGINE = InnoDB, + PARTITION `p736992` VALUES LESS THAN (736992) ENGINE = InnoDB, + PARTITION `p736993` VALUES LESS THAN (736993) ENGINE = InnoDB, + PARTITION `p736994` VALUES LESS THAN (736994) ENGINE = InnoDB, + PARTITION `p736995` VALUES LESS THAN (736995) ENGINE = InnoDB, + PARTITION `p736996` VALUES LESS THAN (736996) ENGINE = InnoDB, + PARTITION `p736997` VALUES LESS THAN (736997) ENGINE = InnoDB, + PARTITION `p736998` VALUES LESS THAN (736998) ENGINE = InnoDB, + PARTITION `p736999` VALUES LESS THAN (736999) ENGINE = InnoDB, + PARTITION `p737000` VALUES LESS THAN (737000) ENGINE = InnoDB, + PARTITION `p737001` VALUES LESS THAN (737001) ENGINE = InnoDB, + PARTITION `p737002` VALUES LESS THAN (737002) ENGINE = InnoDB, + PARTITION `p737003` VALUES LESS THAN (737003) ENGINE = InnoDB, + PARTITION `p737004` VALUES LESS THAN (737004) ENGINE = InnoDB, + PARTITION `p737005` VALUES LESS THAN (737005) ENGINE = InnoDB, + PARTITION `p737006` VALUES LESS THAN (737006) ENGINE = InnoDB, + PARTITION `p737007` VALUES LESS THAN (737007) ENGINE = InnoDB, + PARTITION `p737008` VALUES LESS THAN (737008) ENGINE = InnoDB, + PARTITION `p737009` VALUES LESS THAN (737009) ENGINE = InnoDB, + PARTITION `p737010` VALUES LESS THAN (737010) ENGINE = InnoDB, + PARTITION `p737011` VALUES LESS THAN (737011) ENGINE = InnoDB, + PARTITION `p737012` VALUES LESS THAN (737012) ENGINE = InnoDB, + PARTITION `p737013` VALUES LESS THAN (737013) ENGINE = InnoDB, + PARTITION `p737014` VALUES LESS THAN (737014) ENGINE = InnoDB, + PARTITION `p737015` VALUES LESS THAN (737015) ENGINE = InnoDB, + PARTITION `p737016` VALUES LESS THAN (737016) ENGINE = InnoDB, + PARTITION `p737017` VALUES LESS THAN (737017) ENGINE = InnoDB, + PARTITION `p737018` VALUES LESS THAN (737018) ENGINE = InnoDB, + PARTITION `p737019` VALUES LESS THAN (737019) ENGINE = InnoDB, + PARTITION `p737020` VALUES LESS THAN (737020) ENGINE = InnoDB, + PARTITION `p737021` VALUES LESS THAN (737021) ENGINE = InnoDB, + PARTITION `p737022` VALUES LESS THAN (737022) ENGINE = InnoDB, + PARTITION `p737023` VALUES LESS THAN (737023) ENGINE = InnoDB, + PARTITION `p737024` VALUES LESS THAN (737024) ENGINE = InnoDB, + PARTITION `p737025` VALUES LESS THAN (737025) ENGINE = InnoDB, + PARTITION `p737026` VALUES LESS THAN (737026) ENGINE = InnoDB, + PARTITION `p737027` VALUES LESS THAN (737027) ENGINE = InnoDB, + PARTITION `p737028` VALUES LESS THAN (737028) ENGINE = InnoDB, + PARTITION `p737029` VALUES LESS THAN (737029) ENGINE = InnoDB, + PARTITION `p737030` VALUES LESS THAN (737030) ENGINE = InnoDB, + PARTITION `p737031` VALUES LESS THAN (737031) ENGINE = InnoDB, + PARTITION `p737032` VALUES LESS THAN (737032) ENGINE = InnoDB, + PARTITION `p737033` VALUES LESS THAN (737033) ENGINE = InnoDB, + PARTITION `p737034` VALUES LESS THAN (737034) ENGINE = InnoDB, + PARTITION `p737035` VALUES LESS THAN (737035) ENGINE = InnoDB, + PARTITION `p737036` VALUES LESS THAN (737036) ENGINE = InnoDB, + PARTITION `p737037` VALUES LESS THAN (737037) ENGINE = InnoDB, + PARTITION `p737038` VALUES LESS THAN (737038) ENGINE = InnoDB, + PARTITION `p737039` VALUES LESS THAN (737039) ENGINE = InnoDB, + PARTITION `p737040` VALUES LESS THAN (737040) ENGINE = InnoDB, + PARTITION `p737041` VALUES LESS THAN (737041) ENGINE = InnoDB, + PARTITION `p737042` VALUES LESS THAN (737042) ENGINE = InnoDB, + PARTITION `p737043` VALUES LESS THAN (737043) ENGINE = InnoDB, + PARTITION `p737044` VALUES LESS THAN (737044) ENGINE = InnoDB, + PARTITION `p737045` VALUES LESS THAN (737045) ENGINE = InnoDB, + PARTITION `p737046` VALUES LESS THAN (737046) ENGINE = InnoDB, + PARTITION `p737047` VALUES LESS THAN (737047) ENGINE = InnoDB, + PARTITION `p737048` VALUES LESS THAN (737048) ENGINE = InnoDB, + PARTITION `p737049` VALUES LESS THAN (737049) ENGINE = InnoDB, + PARTITION `p737050` VALUES LESS THAN (737050) ENGINE = InnoDB, + PARTITION `p737051` VALUES LESS THAN (737051) ENGINE = InnoDB, + PARTITION `p737052` VALUES LESS THAN (737052) ENGINE = InnoDB, + PARTITION `p737053` VALUES LESS THAN (737053) ENGINE = InnoDB, + PARTITION `p737054` VALUES LESS THAN (737054) ENGINE = InnoDB, + PARTITION `p737055` VALUES LESS THAN (737055) ENGINE = InnoDB, + PARTITION `p737056` VALUES LESS THAN (737056) ENGINE = InnoDB, + PARTITION `p737057` VALUES LESS THAN (737057) ENGINE = InnoDB, + PARTITION `p737058` VALUES LESS THAN (737058) ENGINE = InnoDB, + PARTITION `p737059` VALUES LESS THAN (737059) ENGINE = InnoDB, + PARTITION `p737060` VALUES LESS THAN (737060) ENGINE = InnoDB, + PARTITION `p737061` VALUES LESS THAN (737061) ENGINE = InnoDB, + PARTITION `p737062` VALUES LESS THAN (737062) ENGINE = InnoDB, + PARTITION `p737063` VALUES LESS THAN (737063) ENGINE = InnoDB, + PARTITION `p737064` VALUES LESS THAN (737064) ENGINE = InnoDB, + PARTITION `p737065` VALUES LESS THAN (737065) ENGINE = InnoDB, + PARTITION `p737066` VALUES LESS THAN (737066) ENGINE = InnoDB, + PARTITION `p737067` VALUES LESS THAN (737067) ENGINE = InnoDB, + PARTITION `p737068` VALUES LESS THAN (737068) ENGINE = InnoDB, + PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB, + PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB, + PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB, + PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB, PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB, PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB, @@ -1030,7 +2056,8 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` ( PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB); + PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB, + PARTITION `p737144` VALUES LESS THAN (737144) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1048,7 +2075,27 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (to_days(`aggregate_datetime`)) -(PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, +(PARTITION `p737052` VALUES LESS THAN (737052) ENGINE = InnoDB, + PARTITION `p737053` VALUES LESS THAN (737053) ENGINE = InnoDB, + PARTITION `p737054` VALUES LESS THAN (737054) ENGINE = InnoDB, + PARTITION `p737055` VALUES LESS THAN (737055) ENGINE = InnoDB, + PARTITION `p737056` VALUES LESS THAN (737056) ENGINE = InnoDB, + PARTITION `p737057` VALUES LESS THAN (737057) ENGINE = InnoDB, + PARTITION `p737058` VALUES LESS THAN (737058) ENGINE = InnoDB, + PARTITION `p737059` VALUES LESS THAN (737059) ENGINE = InnoDB, + PARTITION `p737060` VALUES LESS THAN (737060) ENGINE = InnoDB, + PARTITION `p737061` VALUES LESS THAN (737061) ENGINE = InnoDB, + PARTITION `p737062` VALUES LESS THAN (737062) ENGINE = InnoDB, + PARTITION `p737063` VALUES LESS THAN (737063) ENGINE = InnoDB, + PARTITION `p737064` VALUES LESS THAN (737064) ENGINE = InnoDB, + PARTITION `p737065` VALUES LESS THAN (737065) ENGINE = InnoDB, + PARTITION `p737066` VALUES LESS THAN (737066) ENGINE = InnoDB, + PARTITION `p737067` VALUES LESS THAN (737067) ENGINE = InnoDB, + PARTITION `p737068` VALUES LESS THAN (737068) ENGINE = InnoDB, + PARTITION `p737069` VALUES LESS THAN (737069) ENGINE = InnoDB, + PARTITION `p737070` VALUES LESS THAN (737070) ENGINE = InnoDB, + PARTITION `p737071` VALUES LESS THAN (737071) ENGINE = InnoDB, + PARTITION `p737072` VALUES LESS THAN (737072) ENGINE = InnoDB, PARTITION `p737073` VALUES LESS THAN (737073) ENGINE = InnoDB, PARTITION `p737074` VALUES LESS THAN (737074) ENGINE = InnoDB, PARTITION `p737075` VALUES LESS THAN (737075) ENGINE = InnoDB, @@ -1119,7 +2166,8 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` ( PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB); + PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB, + PARTITION `p737144` VALUES LESS THAN (737144) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1157,8 +2205,7 @@ CREATE TABLE `t_metric_values` ( KEY `ix_metric_values_3` (`metric_id`,`customer_id`,`service_region_id`,`metric_datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY RANGE (to_days(`metric_datetime`)) -(PARTITION `p737104` VALUES LESS THAN (737104) ENGINE = InnoDB, - PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB, +(PARTITION `p737105` VALUES LESS THAN (737105) ENGINE = InnoDB, PARTITION `p737106` VALUES LESS THAN (737106) ENGINE = InnoDB, PARTITION `p737107` VALUES LESS THAN (737107) ENGINE = InnoDB, PARTITION `p737108` VALUES LESS THAN (737108) ENGINE = InnoDB, @@ -1196,7 +2243,8 @@ CREATE TABLE `t_metric_values` ( PARTITION `p737140` VALUES LESS THAN (737140) ENGINE = InnoDB, PARTITION `p737141` VALUES LESS THAN (737141) ENGINE = InnoDB, PARTITION `p737142` VALUES LESS THAN (737142) ENGINE = InnoDB, - PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB); + PARTITION `p737143` VALUES LESS THAN (737143) ENGINE = InnoDB, + PARTITION `p737144` VALUES LESS THAN (737144) ENGINE = InnoDB); /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1228,7 +2276,7 @@ CREATE TABLE `t_payment` ( `external_reference` varchar(256) DEFAULT NULL, PRIMARY KEY (`payment_id`), KEY `ix_payment_1` (`payer_type`,`payer_id`,`payment_date`) -) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1252,7 +2300,7 @@ CREATE TABLE `t_product` ( `public_product` tinyint(4) NOT NULL, `management_region_id` int(10) unsigned NOT NULL, PRIMARY KEY (`product_id`) -) ENGINE=InnoDB AUTO_INCREMENT=91 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1275,7 +2323,7 @@ CREATE TABLE `t_promo_code` ( UNIQUE KEY `ix_promo_code_3` (`management_region_id`,`promo_code`), KEY `ix_promo_code_1` (`promo_code`), KEY `ix_promo_code_2` (`salesperson`) -) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1403,7 +2451,7 @@ CREATE TABLE `t_rate` ( `rate_structure` text NOT NULL, PRIMARY KEY (`rate_id`), KEY `ix_rate_1` (`rate_plan_id`) -) ENGINE=InnoDB AUTO_INCREMENT=896 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=1471 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1418,7 +2466,7 @@ CREATE TABLE `t_rate_plan` ( PRIMARY KEY (`rate_plan_id`), UNIQUE KEY `ix_rate_plan_2` (`management_region_id`,`rate_plan_name`), KEY `ix_rate_plan_1` (`management_region_id`) -) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1444,7 +2492,7 @@ CREATE TABLE `t_region` ( PRIMARY KEY (`region_id`), UNIQUE KEY `ix_region_1` (`parent_region_id`,`region_type`,`region_name`), KEY `ix_region_2` (`parent_region_id`) -) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1530,7 +2578,7 @@ CREATE TABLE `t_service_instance` ( PRIMARY KEY (`service_instance_id`), UNIQUE KEY `ix_provisioned_entity_1` (`service_manager_id`,`service_region_id`,`service_instance_foreign_id`(255)), KEY `ix_provisioned_entity_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=108497 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=106979 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1588,7 +2636,7 @@ CREATE TABLE `t_service_manager` ( `service_manager_type_id` int(10) unsigned NOT NULL, PRIMARY KEY (`service_manager_id`), UNIQUE KEY `ix_service_manager_1` (`service_manager_name`(255)) -) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1634,7 +2682,7 @@ CREATE TABLE `t_tenant` ( KEY `ix_tenant_1` (`tenant_id`), KEY `ix_tenant_2` (`customer_id`), KEY `ix_tenant_3` (`service_manager_id`) -) ENGINE=InnoDB AUTO_INCREMENT=2467 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=2153 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1643,7 +2691,7 @@ CREATE TABLE `t_tenant_type` ( `name` varchar(32) NOT NULL DEFAULT '', `description` varchar(256) DEFAULT NULL, KEY `ix_tenant_1` (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1673,7 +2721,7 @@ CREATE TABLE `t_unbilled_charges` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=692 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=866 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1755,7 +2803,7 @@ CREATE TABLE `t_unbilled_charges_temp` ( `payer_metadata` text DEFAULT NULL, PRIMARY KEY (`invoice_id`), KEY `t_unbilled_charges_1` (`management_region_id`,`payer_type`,`payer_id`) -) ENGINE=InnoDB AUTO_INCREMENT=693 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=867 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; @@ -1800,7 +2848,7 @@ CREATE TABLE `t_users` ( `external` tinyint(1) DEFAULT 0, PRIMARY KEY (`user_id`), UNIQUE KEY `username` (`username`) -) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; @@ -2136,6 +3184,930 @@ SET character_set_client = utf8; `tenant_type` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `v_users` ( + `user_id` tinyint NOT NULL, + `username` tinyint NOT NULL, + `first_name` tinyint NOT NULL, + `last_name` tinyint NOT NULL, + `email_address` tinyint NOT NULL, + `phone_number` tinyint NOT NULL, + `password` tinyint NOT NULL, + `is_active` tinyint NOT NULL, + `password_change_token` tinyint NOT NULL, + `last_password_change_date` tinyint NOT NULL, + `password_change_token_expire_date` tinyint NOT NULL, + `external` tinyint NOT NULL, + `name` tinyint NOT NULL, + `role_context` tinyint NOT NULL +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_jobs` /*!40100 DEFAULT CHARACTER SET utf8 */; + +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@'%' IDENTIFIED BY '{{ openbook_database_password }}'; +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{{ openbook_database_password }}'; + +USE `openbook_jobs`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_BLOB_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `BLOB_DATA` blob DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_CALENDARS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `CALENDAR_NAME` varchar(200) NOT NULL, + `CALENDAR` blob NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_CRON_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `CRON_EXPRESSION` varchar(120) NOT NULL, + `TIME_ZONE_ID` varchar(80) DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_FIRED_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `ENTRY_ID` varchar(95) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `INSTANCE_NAME` varchar(200) NOT NULL, + `FIRED_TIME` bigint(13) NOT NULL, + `SCHED_TIME` bigint(13) NOT NULL, + `PRIORITY` int(11) NOT NULL, + `STATE` varchar(16) NOT NULL, + `JOB_NAME` varchar(200) DEFAULT NULL, + `JOB_GROUP` varchar(200) DEFAULT NULL, + `IS_NONCONCURRENT` varchar(1) DEFAULT NULL, + `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`), + KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`), + KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`), + KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_JOB_DETAILS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `JOB_NAME` varchar(200) NOT NULL, + `JOB_GROUP` varchar(200) NOT NULL, + `DESCRIPTION` varchar(250) DEFAULT NULL, + `JOB_CLASS_NAME` varchar(250) NOT NULL, + `IS_DURABLE` varchar(1) NOT NULL, + `IS_NONCONCURRENT` varchar(1) NOT NULL, + `IS_UPDATE_DATA` varchar(1) NOT NULL, + `REQUESTS_RECOVERY` varchar(1) NOT NULL, + `JOB_DATA` blob DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`), + KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_LOCKS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `LOCK_NAME` varchar(40) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_SCHEDULER_STATE` ( + `SCHED_NAME` varchar(120) NOT NULL, + `INSTANCE_NAME` varchar(200) NOT NULL, + `LAST_CHECKIN_TIME` bigint(13) NOT NULL, + `CHECKIN_INTERVAL` bigint(13) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `REPEAT_COUNT` bigint(7) NOT NULL, + `REPEAT_INTERVAL` bigint(12) NOT NULL, + `TIMES_TRIGGERED` bigint(10) NOT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_SIMPROP_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `STR_PROP_1` varchar(512) DEFAULT NULL, + `STR_PROP_2` varchar(512) DEFAULT NULL, + `STR_PROP_3` varchar(512) DEFAULT NULL, + `INT_PROP_1` int(11) DEFAULT NULL, + `INT_PROP_2` int(11) DEFAULT NULL, + `LONG_PROP_1` bigint(20) DEFAULT NULL, + `LONG_PROP_2` bigint(20) DEFAULT NULL, + `DEC_PROP_1` decimal(13,4) DEFAULT NULL, + `DEC_PROP_2` decimal(13,4) DEFAULT NULL, + `BOOL_PROP_1` varchar(1) DEFAULT NULL, + `BOOL_PROP_2` varchar(1) DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `QRTZ_TRIGGERS` ( + `SCHED_NAME` varchar(120) NOT NULL, + `TRIGGER_NAME` varchar(200) NOT NULL, + `TRIGGER_GROUP` varchar(200) NOT NULL, + `JOB_NAME` varchar(200) NOT NULL, + `JOB_GROUP` varchar(200) NOT NULL, + `DESCRIPTION` varchar(250) DEFAULT NULL, + `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL, + `PREV_FIRE_TIME` bigint(13) DEFAULT NULL, + `PRIORITY` int(11) DEFAULT NULL, + `TRIGGER_STATE` varchar(16) NOT NULL, + `TRIGGER_TYPE` varchar(8) NOT NULL, + `START_TIME` bigint(13) NOT NULL, + `END_TIME` bigint(13) DEFAULT NULL, + `CALENDAR_NAME` varchar(200) DEFAULT NULL, + `MISFIRE_INSTR` smallint(2) DEFAULT NULL, + `JOB_DATA` blob DEFAULT NULL, + PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), + KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`), + KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`), + KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`), + KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`), + KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`), + KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`), + KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`), + KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), + CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook_workflow` /*!40100 DEFAULT CHARACTER SET utf8 */; + +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{{ openbook_database_password }}'; +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{{ openbook_database_password }}'; + +USE `openbook_workflow`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_EVT_LOG` ( + `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT, + `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT current_timestamp(3) ON UPDATE current_timestamp(3), + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DATA_` longblob DEFAULT NULL, + `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, + `IS_PROCESSED_` tinyint(4) DEFAULT 0, + PRIMARY KEY (`LOG_NR_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_GE_BYTEARRAY` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `BYTES_` longblob DEFAULT NULL, + `GENERATED_` tinyint(4) DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`), + CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_GE_PROPERTY` ( + `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, + `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, + `REV_` int(11) DEFAULT NULL, + PRIMARY KEY (`NAME_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_ACTINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `START_TIME_` datetime(3) NOT NULL, + `END_TIME_` datetime(3) DEFAULT NULL, + `DURATION_` bigint(20) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`), + KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`), + KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`), + KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_ATTACHMENT` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TIME_` datetime(3) DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_COMMENT` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TIME_` datetime(3) NOT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `FULL_MSG_` longblob DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_DETAIL` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, + `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `REV_` int(11) DEFAULT NULL, + `TIME_` datetime(3) NOT NULL, + `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DOUBLE_` double DEFAULT NULL, + `LONG_` bigint(20) DEFAULT NULL, + `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`), + KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`), + KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`), + KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`), + KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_IDENTITYLINK` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`), + KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`), + KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_PROCINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `START_TIME_` datetime(3) NOT NULL, + `END_TIME_` datetime(3) DEFAULT NULL, + `DURATION_` bigint(20) DEFAULT NULL, + `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`), + KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`), + KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_TASKINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `START_TIME_` datetime(3) NOT NULL, + `CLAIM_TIME_` datetime(3) DEFAULT NULL, + `END_TIME_` datetime(3) DEFAULT NULL, + `DURATION_` bigint(20) DEFAULT NULL, + `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `PRIORITY_` int(11) DEFAULT NULL, + `DUE_DATE_` datetime(3) DEFAULT NULL, + `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_HI_VARINST` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, + `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL, + `REV_` int(11) DEFAULT NULL, + `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DOUBLE_` double DEFAULT NULL, + `LONG_` bigint(20) DEFAULT NULL, + `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `CREATE_TIME_` datetime(3) DEFAULT NULL, + `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`), + KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`), + KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_GROUP` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_INFO` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PASSWORD_` longblob DEFAULT NULL, + `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_MEMBERSHIP` ( + `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + PRIMARY KEY (`USER_ID_`,`GROUP_ID_`), + KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`), + CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`), + CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_ID_USER` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_PROCDEF_INFO` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`), + KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`), + KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`), + CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), + CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RE_DEPLOYMENT` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL, + PRIMARY KEY (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RE_MODEL` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, + `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL, + `VERSION_` int(11) DEFAULT NULL, + `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`), + KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`), + KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`), + CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`), + CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), + CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RE_PROCDEF` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `KEY_` varchar(255) COLLATE utf8_bin NOT NULL, + `VERSION_` int(11) NOT NULL, + `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL, + `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL, + `SUSPENSION_STATE_` int(11) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_EVENT_SUBSCR` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `CREATED_` timestamp(3) NOT NULL DEFAULT current_timestamp(3), + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`), + KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`), + CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_EXECUTION` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `IS_ACTIVE_` tinyint(4) DEFAULT NULL, + `IS_CONCURRENT_` tinyint(4) DEFAULT NULL, + `IS_SCOPE_` tinyint(4) DEFAULT NULL, + `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL, + `SUSPENSION_STATE_` int(11) DEFAULT NULL, + `CACHED_ENT_STATE_` int(11) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`), + KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`), + KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`), + KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`), + KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`), + CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), + CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_IDENTITYLINK` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`), + KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`), + KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`), + KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`), + KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`), + CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), + CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_JOB` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, + `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `EXCLUSIVE_` tinyint(1) DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `RETRIES_` int(11) DEFAULT NULL, + `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `DUEDATE_` timestamp(3) NULL DEFAULT NULL, + `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + PRIMARY KEY (`ID_`), + KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`), + CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_TASK` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PRIORITY_` int(11) DEFAULT NULL, + `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, + `DUE_DATE_` datetime(3) DEFAULT NULL, + `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + `SUSPENSION_STATE_` int(11) DEFAULT NULL, + `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', + `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`), + KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`), + KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`), + KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`), + CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), + CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `ACT_RU_VARIABLE` ( + `ID_` varchar(64) COLLATE utf8_bin NOT NULL, + `REV_` int(11) DEFAULT NULL, + `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, + `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, + `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, + `DOUBLE_` double DEFAULT NULL, + `LONG_` bigint(20) DEFAULT NULL, + `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, + PRIMARY KEY (`ID_`), + KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`), + KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`), + KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`), + KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`), + CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), + CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), + CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +/*!40101 SET character_set_client = @saved_cs_client */; + +GRANT ALL PRIVILEGES ON openbook.* TO openbook@'%' IDENTIFIED BY '{{ openbook_database_password }}'; +GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{{ openbook_database_password }}'; + +USE `openbook`; +/*!50001 DROP TABLE IF EXISTS `v_all_charges`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_all_charges` AS select `t_invoice`.`invoice_id` AS `invoice_id`,`t_invoice`.`payer_id` AS `payer_id`,`t_invoice`.`payer_type` AS `payer_type`,`t_invoice`.`payer_name` AS `payer_name`,`t_invoice`.`invoice_number` AS `invoice_number`,`t_invoice`.`invoice_date` AS `invoice_date`,`t_invoice`.`period_begin` AS `period_begin`,`t_invoice`.`period_end` AS `period_end`,`t_invoice`.`invoice_amount` AS `invoice_amount`,`t_invoice`.`actual_charges` AS `actual_charges`,`t_invoice`.`invoice_currency` AS `invoice_currency`,`t_invoice`.`management_region_id` AS `management_region_id` from `t_invoice` union select `t_unbilled_charges`.`invoice_id` AS `invoice_id`,`t_unbilled_charges`.`payer_id` AS `payer_id`,`t_unbilled_charges`.`payer_type` AS `payer_type`,`t_unbilled_charges`.`payer_name` AS `payer_name`,`t_unbilled_charges`.`invoice_number` AS `invoice_number`,`t_unbilled_charges`.`invoice_date` AS `invoice_date`,`t_unbilled_charges`.`period_begin` AS `period_begin`,`t_unbilled_charges`.`period_end` AS `period_end`,`t_unbilled_charges`.`invoice_amount` AS `invoice_amount`,`t_unbilled_charges`.`actual_charges` AS `actual_charges`,`t_unbilled_charges`.`invoice_currency` AS `invoice_currency`,`t_unbilled_charges`.`management_region_id` AS `management_region_id` from `t_unbilled_charges` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_all_charges_detail`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_all_charges_detail` AS select `t_invoice_detail`.`invoice_id` AS `invoice_id`,`t_invoice_detail`.`customer_id` AS `customer_id`,`t_invoice_detail`.`customer_name` AS `customer_name`,`t_invoice_detail`.`service_region_id` AS `service_region_id`,`t_invoice_detail`.`rate` AS `rate`,`t_invoice_detail`.`rate_display` AS `rate_display`,`t_invoice_detail`.`rate_unit` AS `rate_unit`,`t_invoice_detail`.`rate_interval` AS `rate_interval`,`t_invoice_detail`.`rate_multiplier_percent` AS `rate_multiplier_percent`,`t_invoice_detail`.`units_billed` AS `units_billed`,`t_invoice_detail`.`units_billed_display` AS `units_billed_display`,`t_invoice_detail`.`item_invoice_amount` AS `item_invoice_amount`,`t_invoice_detail`.`item_category` AS `item_category`,`t_invoice_detail`.`item_group` AS `item_group`,`t_invoice_detail`.`item_type` AS `item_type`,`t_invoice_detail`.`item_detail` AS `item_detail`,`t_invoice_detail`.`tenant_id` AS `tenant_id`,`t_invoice_detail`.`tenant_name` AS `tenant_name` from `t_invoice_detail` union select `t_unbilled_charges_detail`.`invoice_id` AS `invoice_id`,`t_unbilled_charges_detail`.`customer_id` AS `customer_id`,`t_unbilled_charges_detail`.`customer_name` AS `customer_name`,`t_unbilled_charges_detail`.`service_region_id` AS `service_region_id`,`t_unbilled_charges_detail`.`rate` AS `rate`,`t_unbilled_charges_detail`.`rate_display` AS `rate_display`,`t_unbilled_charges_detail`.`rate_unit` AS `rate_unit`,`t_unbilled_charges_detail`.`rate_interval` AS `rate_interval`,`t_unbilled_charges_detail`.`rate_multiplier_percent` AS `rate_multiplier_percent`,`t_unbilled_charges_detail`.`units_billed` AS `units_billed`,`t_unbilled_charges_detail`.`units_billed_display` AS `units_billed_display`,`t_unbilled_charges_detail`.`item_invoice_amount` AS `item_invoice_amount`,`t_unbilled_charges_detail`.`item_category` AS `item_category`,`t_unbilled_charges_detail`.`item_group` AS `item_group`,`t_unbilled_charges_detail`.`item_type` AS `item_type`,`t_unbilled_charges_detail`.`item_detail` AS `item_detail`,`t_unbilled_charges_detail`.`tenant_id` AS `tenant_id`,`t_unbilled_charges_detail`.`tenant_name` AS `tenant_name` from `t_unbilled_charges_detail` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_current_host`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_current_host` AS select `h`.`host_id` AS `host_id`,`h`.`service_manager_id` AS `service_manager_id`,`sm`.`service_manager_name` AS `service_manager_name`,`h`.`service_region_id` AS `service_region_id`,`r`.`region_name` AS `region_name`,`h`.`host_foreign_id` AS `host_foreign_id`,`h`.`host_name` AS `host_name`,`h`.`hypervisor_type` AS `hypervisor_type`,`h`.`host_aggregate` AS `host_aggregate`,`h`.`add_date` AS `add_date`,`h`.`remove_date` AS `remove_date`,`h`.`cpu_allocation_ratio` AS `cpu_allocation_ratio`,`h`.`ram_allocation_ratio` AS `ram_allocation_ratio`,`h`.`disk_allocation_ratio` AS `disk_allocation_ratio`,`ha`.`update_date` AS `update_date`,`ha`.`ram_mb` AS `ram_mb`,`ha`.`ram_mb_used` AS `ram_mb_used`,`ha`.`disk_gb` AS `disk_gb`,`ha`.`disk_gb_used` AS `disk_gb_used`,`ha`.`vcpus` AS `vcpus`,`ha`.`vcpus_used` AS `vcpus_used`,`ha`.`vm_count` AS `vm_count`,`ha`.`socket_count` AS `socket_count` from (((`t_host` `h` join `v_current_host_attributes` `ha` on(`h`.`host_id` = `ha`.`host_id`)) join `t_service_manager` `sm` on(`h`.`service_manager_id` = `sm`.`service_manager_id`)) join `t_region` `r` on(`h`.`service_region_id` = `r`.`region_id`)) where `h`.`remove_date` > curdate() */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_current_host_attributes`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_current_host_attributes` AS select `tha1`.`host_id` AS `host_id`,`tha1`.`update_date` AS `update_date`,`tha1`.`ram_mb` AS `ram_mb`,`tha1`.`ram_mb_used` AS `ram_mb_used`,`tha1`.`disk_gb` AS `disk_gb`,`tha1`.`disk_gb_used` AS `disk_gb_used`,`tha1`.`vcpus` AS `vcpus`,`tha1`.`vcpus_used` AS `vcpus_used`,`tha1`.`vm_count` AS `vm_count`,`tha1`.`socket_count` AS `socket_count` from `t_host_attributes` `tha1` where `tha1`.`update_date` = (select max(`t_host_attributes`.`update_date`) from `t_host_attributes` where `t_host_attributes`.`host_id` = `tha1`.`host_id`) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_customer`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_customer` AS select `c`.`customer_id` AS `customer_id`,`c`.`customer_name` AS `customer_name`,`c`.`metadata` AS `metadata`,`c`.`tax_rate` AS `tax_rate`,`c`.`currency` AS `currency`,`c`.`discount_percent` AS `discount_percent`,`c`.`billing_frequency` AS `billing_frequency`,`c`.`last_bill_date` AS `last_bill_date`,`c`.`next_bill_date` AS `next_bill_date`,`c`.`is_active` AS `is_active`,`c`.`create_date` AS `create_date`,`c`.`activate_date` AS `activate_date`,`c`.`billing_start_date` AS `billing_start_date`,`c`.`last_payment_date` AS `last_payment_date`,`c`.`deactivate_date` AS `deactivate_date`,`c`.`description` AS `description`,`c`.`minimum_invoice_commitment` AS `minimum_invoice_commitment`,`c`.`invoicing_method` AS `invoicing_method`,`c`.`management_region_id` AS `management_region_id`,`c`.`billing_address_line_1` AS `billing_address_line_1`,`c`.`billing_address_line_2` AS `billing_address_line_2`,`c`.`billing_address_city` AS `billing_address_city`,`c`.`billing_address_region` AS `billing_address_region`,`c`.`billing_address_country` AS `billing_address_country`,`c`.`billing_address_postal_code` AS `billing_address_postal_code`,`c`.`payer_payment_details` AS `payer_payment_details`,`c`.`payment_method_confirmed` AS `payment_method_confirmed`,`c`.`balance_due` AS `balance_due`,`c`.`spend_soft_limit` AS `spend_soft_limit`,`c`.`spend_hard_limit` AS `spend_hard_limit`,`c`.`terms_and_conditions_2_accept_date` AS `terms_and_conditions_2_accept_date`,`c`.`tax_id` AS `tax_id`,`c`.`registration_number` AS `registration_number`,`r1`.`region_name` AS `management_region_name` from (`t_customer` `c` left join `t_region` `r1` on(`c`.`management_region_id` = `r1`.`region_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_metric`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_metric` AS select `m`.`metric_id` AS `metric_id`,`m`.`service_manager_type_id` AS `service_manager_type_id`,`m`.`metric_name` AS `metric_name`,`m`.`metric_label` AS `metric_label`,`m`.`metric_source` AS `metric_source`,`m`.`metric_type` AS `metric_type`,`m`.`metric_unit` AS `metric_unit`,`m`.`entity_resolution` AS `entity_resolution`,`m`.`time_resolution` AS `time_resolution`,`sm`.`service_manager_type` AS `service_manager_type` from (`t_metric` `m` left join `t_service_manager_type` `sm` on(`m`.`service_manager_type_id` = `sm`.`service_manager_type_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_promo_code_redemption`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_promo_code_redemption` AS select `p`.`management_region_id` AS `management_region_id`,`p`.`promo_code_id` AS `promo_code_id`,`p`.`promo_code` AS `promo_code`,`p`.`salesperson` AS `salesperson`,`p`.`discount_or_credit` AS `discount_or_credit`,`p`.`credit_amount` AS `credit_amount`,`p`.`credit_type` AS `credit_type`,`p`.`apply_to_charge_category` AS `apply_to_charge_category`,`p`.`trigger_charge_category` AS `trigger_charge_category`,`p`.`trigger_amount` AS `trigger_amount`,`p`.`discount_percent` AS `discount_percent`,`p`.`available_invoice_periods` AS `available_invoice_periods`,`p`.`expire_date` AS `expire_date`,`p`.`currency` AS `currency`,`r`.`redemption_date` AS `redemption_date`,`c`.`customer_id` AS `customer_id`,`c`.`customer_name` AS `customer_name` from ((`t_promo_code_redemption` `r` join `t_customer` `c`) join `t_promo_code` `p`) where `r`.`payer_type` = 'Customer' and `r`.`payer_id` = `c`.`customer_id` and `p`.`promo_code_id` = `r`.`promo_code_id` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_provider`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_provider` AS select `t_provider`.`provider_id` AS `provider_id`,`t_provider`.`provider_name` AS `provider_name`,`t_provider`.`provider_type` AS `provider_type`,`t_provider`.`metadata` AS `metadata`,`t_provider`.`tax_rate` AS `tax_rate`,`t_provider`.`currency` AS `currency`,`t_provider`.`discount_percent` AS `discount_percent`,`t_provider`.`billing_frequency` AS `billing_frequency`,`t_provider`.`last_bill_date` AS `last_bill_date`,`t_provider`.`next_bill_date` AS `next_bill_date`,`t_provider`.`last_payment_date` AS `last_payment_date`,`t_provider`.`is_active` AS `is_active`,`t_provider`.`create_date` AS `create_date`,`t_provider`.`activate_date` AS `activate_date`,`t_provider`.`billing_start_date` AS `billing_start_date`,`t_provider`.`deactivate_date` AS `deactivate_date`,`t_provider`.`description` AS `description`,`t_provider`.`minimum_invoice_commitment` AS `minimum_invoice_commitment`,`t_provider`.`invoicing_method` AS `invoicing_method`,`t_provider`.`invoice_processing_method` AS `invoice_processing_method`,`t_provider`.`billing_address_line_1` AS `billing_address_line_1`,`t_provider`.`billing_address_line_2` AS `billing_address_line_2`,`t_provider`.`billing_address_city` AS `billing_address_city`,`t_provider`.`billing_address_region` AS `billing_address_region`,`t_provider`.`billing_address_country` AS `billing_address_country`,`t_provider`.`billing_address_postal_code` AS `billing_address_postal_code`,`t_provider`.`legal_address_line_1` AS `legal_address_line_1`,`t_provider`.`legal_address_line_2` AS `legal_address_line_2`,`t_provider`.`legal_address_city` AS `legal_address_city`,`t_provider`.`legal_address_region` AS `legal_address_region`,`t_provider`.`legal_address_country` AS `legal_address_country`,`t_provider`.`legal_address_postal_code` AS `legal_address_postal_code`,`t_provider`.`payer_payment_details` AS `payer_payment_details`,`t_provider`.`payee_payment_details` AS `payee_payment_details`,`t_provider`.`public_url` AS `public_url`,`t_provider`.`management_region_id` AS `management_region_id`,`t_provider`.`balance_due` AS `balance_due`,`t_provider`.`openbook_processes_payments` AS `openbook_processes_payments`,`t_provider`.`openbook_processes_past_due_invoices` AS `openbook_processes_past_due_invoices`,`t_provider`.`openstack_tenant_id` AS `openstack_tenant_id`,`t_provider`.`tax_id` AS `tax_id`,`t_provider`.`registration_number` AS `registration_number`,`t_provider`.`os_service_manager_id` AS `os_service_manager_id`,`t_region`.`parent_region_id` AS `parent_management_region_id` from (`t_provider` left join `t_region` on(`t_region`.`region_id` = `t_provider`.`management_region_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_rate_plan_assignment`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_rate_plan_assignment` AS select `a`.`rate_plan_id` AS `rate_plan_id`,`a`.`assignee_id` AS `assignee_id`,`a`.`assignee_type` AS `assignee_type`,`a`.`assignment_start_date` AS `assignment_start_date`,`a`.`assignment_end_date` AS `assignment_end_date`,`a`.`assignment_type` AS `assignment_type`,`r`.`management_region_id` AS `management_region_id` from (`t_rate_plan_assignment` `a` left join `t_rate_plan` `r` on(`a`.`rate_plan_id` = `r`.`rate_plan_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service` AS select `s`.`service_id` AS `service_id`,`s`.`service_type` AS `service_type`,`s`.`service_description` AS `service_description`,`s`.`service_manager_type_id` AS `service_manager_type_id`,`s`.`states` AS `states`,`s`.`externally_managed` AS `externally_managed`,`sm`.`service_manager_type` AS `service_manager_type` from (`t_service` `s` left join `t_service_manager_type` `sm` on(`s`.`service_manager_type_id` = `sm`.`service_manager_type_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_instance`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_instance` AS select `tsi`.`service_instance_id` AS `service_instance_id`,`tsi`.`service_id` AS `service_id`,`tsi`.`service_instance_name` AS `service_instance_name`,`tsi`.`service_manager_id` AS `service_manager_id`,`tsi`.`service_region_id` AS `service_region_id`,`tsi`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tsi`.`tenant_id` AS `tenant_id`,`tsi`.`current_attributes` AS `current_attributes`,`tt`.`tenant_name` AS `tenant_name`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`tr`.`region_name` AS `service_region_name`,`tsmt`.`service_manager_type` AS `service_manager_type`,`ts`.`service_type` AS `service_type`,`tsis`.`start_date` AS `provisioned_date`,`tsis`.`end_date` AS `deprovisioned_date` from (((((((`t_service_instance` `tsi` left join `t_tenant` `tt` on(`tsi`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tc`.`customer_id` = `tt`.`customer_id`)) left join `t_service` `ts` on(`tsi`.`service_id` = `ts`.`service_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_region` `tr` on(`tsi`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager` `tsm` on(`tsi`.`service_manager_id` = `tsm`.`service_manager_id`)) left join `t_service_instance_state` `tsis` on(`tsi`.`service_instance_id` = `tsis`.`service_instance_id` and `tsis`.`state` = 'In Existence')) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_instance_attributes`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_instance_attributes` AS select `tpsa`.`service_instance_id` AS `service_instance_id`,`tpsa`.`start_date` AS `start_date`,`tpsa`.`end_date` AS `end_date`,`tpsa`.`attributes` AS `attributes`,`tt`.`tenant_id` AS `tenant_id`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`tenant_name` AS `tenant_name`,`tc`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tps`.`service_instance_name` AS `service_instance_name`,`tps`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tps`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`ts`.`service_id` AS `service_id`,`ts`.`service_type` AS `service_type`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tr`.`region_id` AS `service_region_id`,`tr`.`region_name` AS `service_region_name` from (((((((`t_service_instance_attributes` `tpsa` left join `t_service_instance` `tps` on(`tps`.`service_instance_id` = `tpsa`.`service_instance_id`)) left join `t_service` `ts` on(`ts`.`service_id` = `tps`.`service_id`)) left join `t_service_manager` `tsm` on(`tsm`.`service_manager_id` = `tps`.`service_manager_id`)) left join `t_region` `tr` on(`tps`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant` `tt` on(`tps`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tt`.`customer_id` = `tc`.`customer_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_instance_state`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_instance_state` AS select `tpss`.`service_instance_id` AS `service_instance_id`,`tpss`.`state` AS `state`,`tpss`.`start_date` AS `start_date`,`tpss`.`end_date` AS `end_date`,`tpss`.`interval_length_milliseconds` AS `interval_length_milliseconds`,`tt`.`tenant_id` AS `tenant_id`,`tt`.`tenant_foreign_id` AS `tenant_foreign_id`,`tt`.`tenant_name` AS `tenant_name`,`tc`.`customer_id` AS `customer_id`,`tc`.`customer_name` AS `customer_name`,`tc`.`management_region_id` AS `management_region_id`,`tps`.`service_instance_name` AS `service_instance_name`,`tps`.`service_instance_foreign_id` AS `service_instance_foreign_id`,`tps`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`ts`.`service_id` AS `service_id`,`ts`.`service_type` AS `service_type`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tr`.`region_id` AS `service_region_id`,`tr`.`region_name` AS `service_region_name` from (((((((`t_service_instance_state` `tpss` left join `t_service_instance` `tps` on(`tps`.`service_instance_id` = `tpss`.`service_instance_id`)) left join `t_service` `ts` on(`ts`.`service_id` = `tps`.`service_id`)) left join `t_service_manager` `tsm` on(`tsm`.`service_manager_id` = `tps`.`service_manager_id`)) left join `t_region` `tr` on(`tps`.`service_region_id` = `tr`.`region_id`)) left join `t_service_manager_type` `tsmt` on(`ts`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant` `tt` on(`tps`.`tenant_id` = `tt`.`tenant_id`)) left join `t_customer` `tc` on(`tt`.`customer_id` = `tc`.`customer_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_service_manager`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_service_manager` AS select `tsm`.`service_manager_id` AS `service_manager_id`,`tsm`.`service_manager_name` AS `service_manager_name`,`tsm`.`service_manager_description` AS `service_manager_description`,`tsm`.`metadata` AS `metadata`,`tsm`.`service_region_id` AS `service_region_id`,`tsm`.`service_manager_type_id` AS `service_manager_type_id`,`tsmt`.`service_manager_type` AS `service_manager_type` from (`t_service_manager` `tsm` left join `t_service_manager_type` `tsmt` on(`tsm`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_tenant`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_tenant` AS select `t`.`tenant_id` AS `tenant_id`,`t`.`tenant_name` AS `tenant_name`,`t`.`tenant_foreign_id` AS `tenant_foreign_id`,`t`.`create_date` AS `create_date`,`t`.`deactivate_date` AS `deactivate_date`,`t`.`customer_id` AS `customer_id`,`t`.`service_manager_id` AS `service_manager_id`,`t`.`is_active` AS `is_active`,`c`.`customer_name` AS `customer_name`,`c`.`management_region_id` AS `management_region_id`,`tsmt`.`service_manager_type` AS `service_manager_type`,`tt`.`name` AS `tenant_type` from ((((`t_tenant` `t` left join `t_customer` `c` on(`t`.`customer_id` = `c`.`customer_id`)) left join `t_service_manager` `tsm` on(`t`.`service_manager_id` = `tsm`.`service_manager_id`)) left join `t_service_manager_type` `tsmt` on(`tsm`.`service_manager_type_id` = `tsmt`.`service_manager_type_id`)) left join `t_tenant_type` `tt` on(`t`.`tenant_type_id` = `tt`.`id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!50001 DROP TABLE IF EXISTS `v_users`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = utf8 */; +/*!50001 SET character_set_results = utf8 */; +/*!50001 SET collation_connection = utf8_general_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`openbook`@`%` SQL SECURITY DEFINER */ +/*!50001 VIEW `v_users` AS select `u`.`user_id` AS `user_id`,`u`.`username` AS `username`,`u`.`first_name` AS `first_name`,`u`.`last_name` AS `last_name`,`u`.`email_address` AS `email_address`,`u`.`phone_number` AS `phone_number`,`u`.`password` AS `password`,`u`.`is_active` AS `is_active`,`u`.`password_change_token` AS `password_change_token`,`u`.`last_password_change_date` AS `last_password_change_date`,`u`.`password_change_token_expire_date` AS `password_change_token_expire_date`,`u`.`external` AS `external`,`r`.`name` AS `name`,`ur`.`role_context` AS `role_context` from ((`t_users` `u` left join `t_user_roles` `ur` on(`u`.`user_id` = `ur`.`user_id`)) left join `t_role` `r` on(`ur`.`role_id` = `r`.`id`)) */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; + +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@'%' IDENTIFIED BY '{{ openbook_database_password }}'; +GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{{ openbook_database_password }}'; + +USE `openbook_jobs`; + +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{{ openbook_database_password }}'; +GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{{ openbook_database_password }}'; + +USE `openbook_workflow`; +/*!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 */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + use openbook; CALL p_preallocate_partitions('t_metric_values', 'metric_datetime', CURDATE(), 31); CALL p_preallocate_partitions('t_metric_aggregate_resource_hourly', 'aggregate_datetime', CURDATE(), 31); |