don't remove partitions from database script

author: ckonstanski <ckonstanski@pippiandcarlos.com> 2017-11-14 10:00:36 -0700
committer: ckonstanski <ckonstanski@pippiandcarlos.com> 2017-11-14 10:00:36 -0700
commit: 8a183ce966f114ac8a3434f11a0e340b903f144d (patch)
tree: 0be9fd80423363bac7957765fa41ed00c22efc62 /salt/openbook
parent: a14ad3b7a813b25f8282433e61cfa175fce000cb (diff)
1 files changed, 1534 insertions, 15 deletions
diff --git a/salt/openbook/database/files/create_openbook_schemas.sql b/salt/openbook/database/files/create_openbook_schemas.sql
index ed21ba2..6437dd1 100644
--- a/salt/openbook/database/files/create_openbook_schemas.sql
+++ b/salt/openbook/database/files/create_openbook_schemas.sql
@@ -1,3 +1,4 @@
+
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
@@ -8,9 +9,12 @@
 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `openbook` /*!40100 DEFAULT CHARACTER SET latin1 */;
+
 GRANT ALL PRIVILEGES ON openbook.* TO openbook@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
 GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
+
 USE `openbook`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -83,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=1798 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=1801 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 */;
@@ -286,7 +290,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=315462 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=315465 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 */;
@@ -416,7 +420,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=1858 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=1861 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 */;
@@ -432,7 +436,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=1858 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=1861 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 */;
@@ -554,7 +558,401 @@ CREATE TABLE `t_metric_aggregate_customer_daily` (
   `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
   PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- PARTITION BY RANGE (to_days(`aggregate_datetime`));
+ PARTITION BY RANGE (to_days(`aggregate_datetime`))
+(PARTITION `p736651` VALUES LESS THAN (736651) ENGINE = InnoDB,
+ PARTITION `p736652` VALUES LESS THAN (736652) ENGINE = InnoDB,
+ PARTITION `p736653` VALUES LESS THAN (736653) ENGINE = InnoDB,
+ PARTITION `p736654` VALUES LESS THAN (736654) ENGINE = InnoDB,
+ PARTITION `p736655` VALUES LESS THAN (736655) ENGINE = InnoDB,
+ PARTITION `p736656` VALUES LESS THAN (736656) ENGINE = InnoDB,
+ PARTITION `p736657` VALUES LESS THAN (736657) ENGINE = InnoDB,
+ PARTITION `p736658` VALUES LESS THAN (736658) ENGINE = InnoDB,
+ PARTITION `p736659` VALUES LESS THAN (736659) ENGINE = InnoDB,
+ PARTITION `p736660` VALUES LESS THAN (736660) ENGINE = InnoDB,
+ PARTITION `p736661` VALUES LESS THAN (736661) ENGINE = InnoDB,
+ PARTITION `p736662` VALUES LESS THAN (736662) ENGINE = InnoDB,
+ PARTITION `p736663` VALUES LESS THAN (736663) ENGINE = InnoDB,
+ PARTITION `p736664` VALUES LESS THAN (736664) ENGINE = InnoDB,
+ PARTITION `p736665` VALUES LESS THAN (736665) ENGINE = InnoDB,
+ PARTITION `p736666` VALUES LESS THAN (736666) ENGINE = InnoDB,
+ PARTITION `p736667` VALUES LESS THAN (736667) ENGINE = InnoDB,
+ PARTITION `p736668` VALUES LESS THAN (736668) ENGINE = InnoDB,
+ PARTITION `p736669` VALUES LESS THAN (736669) ENGINE = InnoDB,
+ PARTITION `p736670` VALUES LESS THAN (736670) ENGINE = InnoDB,
+ PARTITION `p736671` VALUES LESS THAN (736671) ENGINE = InnoDB,
+ PARTITION `p736672` VALUES LESS THAN (736672) ENGINE = InnoDB,
+ PARTITION `p736673` VALUES LESS THAN (736673) ENGINE = InnoDB,
+ PARTITION `p736674` VALUES LESS THAN (736674) ENGINE = InnoDB,
+ PARTITION `p736675` VALUES LESS THAN (736675) ENGINE = InnoDB,
+ PARTITION `p736676` VALUES LESS THAN (736676) ENGINE = InnoDB,
+ PARTITION `p736677` VALUES LESS THAN (736677) ENGINE = InnoDB,
+ PARTITION `p736678` VALUES LESS THAN (736678) ENGINE = InnoDB,
+ PARTITION `p736679` VALUES LESS THAN (736679) ENGINE = InnoDB,
+ PARTITION `p736680` VALUES LESS THAN (736680) ENGINE = InnoDB,
+ PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
+ PARTITION `p736682` VALUES LESS THAN (736682) ENGINE = InnoDB,
+ PARTITION `p736683` VALUES LESS THAN (736683) ENGINE = InnoDB,
+ PARTITION `p736684` VALUES LESS THAN (736684) ENGINE = InnoDB,
+ PARTITION `p736685` VALUES LESS THAN (736685) ENGINE = InnoDB,
+ PARTITION `p736686` VALUES LESS THAN (736686) ENGINE = InnoDB,
+ PARTITION `p736687` VALUES LESS THAN (736687) ENGINE = InnoDB,
+ PARTITION `p736688` VALUES LESS THAN (736688) ENGINE = InnoDB,
+ PARTITION `p736689` VALUES LESS THAN (736689) ENGINE = InnoDB,
+ PARTITION `p736690` VALUES LESS THAN (736690) ENGINE = InnoDB,
+ PARTITION `p736691` VALUES LESS THAN (736691) ENGINE = InnoDB,
+ PARTITION `p736692` VALUES LESS THAN (736692) ENGINE = InnoDB,
+ PARTITION `p736693` VALUES LESS THAN (736693) ENGINE = InnoDB,
+ PARTITION `p736694` VALUES LESS THAN (736694) ENGINE = InnoDB,
+ PARTITION `p736695` VALUES LESS THAN (736695) ENGINE = InnoDB,
+ PARTITION `p736696` VALUES LESS THAN (736696) ENGINE = InnoDB,
+ PARTITION `p736697` VALUES LESS THAN (736697) ENGINE = InnoDB,
+ PARTITION `p736698` VALUES LESS THAN (736698) ENGINE = InnoDB,
+ PARTITION `p736699` VALUES LESS THAN (736699) ENGINE = InnoDB,
+ PARTITION `p736700` VALUES LESS THAN (736700) ENGINE = InnoDB,
+ PARTITION `p736701` VALUES LESS THAN (736701) ENGINE = InnoDB,
+ PARTITION `p736702` VALUES LESS THAN (736702) ENGINE = InnoDB,
+ PARTITION `p736703` VALUES LESS THAN (736703) ENGINE = InnoDB,
+ PARTITION `p736704` VALUES LESS THAN (736704) ENGINE = InnoDB,
+ PARTITION `p736705` VALUES LESS THAN (736705) ENGINE = InnoDB,
+ PARTITION `p736706` VALUES LESS THAN (736706) ENGINE = InnoDB,
+ PARTITION `p736707` VALUES LESS THAN (736707) ENGINE = InnoDB,
+ PARTITION `p736708` VALUES LESS THAN (736708) ENGINE = InnoDB,
+ PARTITION `p736709` VALUES LESS THAN (736709) ENGINE = InnoDB,
+ PARTITION `p736710` VALUES LESS THAN (736710) ENGINE = InnoDB,
+ PARTITION `p736711` VALUES LESS THAN (736711) ENGINE = InnoDB,
+ PARTITION `p736712` VALUES LESS THAN (736712) ENGINE = InnoDB,
+ PARTITION `p736713` VALUES LESS THAN (736713) ENGINE = InnoDB,
+ PARTITION `p736714` VALUES LESS THAN (736714) ENGINE = InnoDB,
+ PARTITION `p736715` VALUES LESS THAN (736715) ENGINE = InnoDB,
+ PARTITION `p736716` VALUES LESS THAN (736716) ENGINE = InnoDB,
+ PARTITION `p736717` VALUES LESS THAN (736717) ENGINE = InnoDB,
+ PARTITION `p736718` VALUES LESS THAN (736718) ENGINE = InnoDB,
+ PARTITION `p736719` VALUES LESS THAN (736719) ENGINE = InnoDB,
+ PARTITION `p736720` VALUES LESS THAN (736720) ENGINE = InnoDB,
+ PARTITION `p736721` VALUES LESS THAN (736721) ENGINE = InnoDB,
+ PARTITION `p736722` VALUES LESS THAN (736722) ENGINE = InnoDB,
+ PARTITION `p736723` VALUES LESS THAN (736723) ENGINE = InnoDB,
+ PARTITION `p736724` VALUES LESS THAN (736724) ENGINE = InnoDB,
+ PARTITION `p736725` VALUES LESS THAN (736725) ENGINE = InnoDB,
+ PARTITION `p736726` VALUES LESS THAN (736726) ENGINE = InnoDB,
+ PARTITION `p736727` VALUES LESS THAN (736727) ENGINE = InnoDB,
+ PARTITION `p736728` VALUES LESS THAN (736728) ENGINE = InnoDB,
+ PARTITION `p736729` VALUES LESS THAN (736729) ENGINE = InnoDB,
+ PARTITION `p736730` VALUES LESS THAN (736730) ENGINE = InnoDB,
+ PARTITION `p736731` VALUES LESS THAN (736731) ENGINE = InnoDB,
+ PARTITION `p736732` VALUES LESS THAN (736732) ENGINE = InnoDB,
+ PARTITION `p736733` VALUES LESS THAN (736733) ENGINE = InnoDB,
+ PARTITION `p736734` VALUES LESS THAN (736734) ENGINE = InnoDB,
+ PARTITION `p736735` VALUES LESS THAN (736735) ENGINE = InnoDB,
+ PARTITION `p736736` VALUES LESS THAN (736736) ENGINE = InnoDB,
+ PARTITION `p736737` VALUES LESS THAN (736737) ENGINE = InnoDB,
+ PARTITION `p736738` VALUES LESS THAN (736738) ENGINE = InnoDB,
+ PARTITION `p736739` VALUES LESS THAN (736739) ENGINE = InnoDB,
+ PARTITION `p736740` VALUES LESS THAN (736740) ENGINE = InnoDB,
+ PARTITION `p736741` VALUES LESS THAN (736741) ENGINE = InnoDB,
+ PARTITION `p736742` VALUES LESS THAN (736742) ENGINE = InnoDB,
+ PARTITION `p736743` VALUES LESS THAN (736743) ENGINE = InnoDB,
+ PARTITION `p736744` VALUES LESS THAN (736744) ENGINE = InnoDB,
+ PARTITION `p736745` VALUES LESS THAN (736745) ENGINE = InnoDB,
+ PARTITION `p736746` VALUES LESS THAN (736746) 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);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -570,7 +968,100 @@ CREATE TABLE `t_metric_aggregate_customer_hourly` (
   `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
   PRIMARY KEY (`metric_id`,`customer_id`,`service_region_id`,`aggregate_datetime`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- PARTITION BY RANGE (to_days(`aggregate_datetime`));
+ PARTITION BY RANGE (to_days(`aggregate_datetime`))
+(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);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -608,7 +1099,401 @@ CREATE TABLE `t_metric_aggregate_resource_daily` (
   `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
   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 BY RANGE (to_days(`aggregate_datetime`))
+(PARTITION `p736651` VALUES LESS THAN (736651) ENGINE = InnoDB,
+ PARTITION `p736652` VALUES LESS THAN (736652) ENGINE = InnoDB,
+ PARTITION `p736653` VALUES LESS THAN (736653) ENGINE = InnoDB,
+ PARTITION `p736654` VALUES LESS THAN (736654) ENGINE = InnoDB,
+ PARTITION `p736655` VALUES LESS THAN (736655) ENGINE = InnoDB,
+ PARTITION `p736656` VALUES LESS THAN (736656) ENGINE = InnoDB,
+ PARTITION `p736657` VALUES LESS THAN (736657) ENGINE = InnoDB,
+ PARTITION `p736658` VALUES LESS THAN (736658) ENGINE = InnoDB,
+ PARTITION `p736659` VALUES LESS THAN (736659) ENGINE = InnoDB,
+ PARTITION `p736660` VALUES LESS THAN (736660) ENGINE = InnoDB,
+ PARTITION `p736661` VALUES LESS THAN (736661) ENGINE = InnoDB,
+ PARTITION `p736662` VALUES LESS THAN (736662) ENGINE = InnoDB,
+ PARTITION `p736663` VALUES LESS THAN (736663) ENGINE = InnoDB,
+ PARTITION `p736664` VALUES LESS THAN (736664) ENGINE = InnoDB,
+ PARTITION `p736665` VALUES LESS THAN (736665) ENGINE = InnoDB,
+ PARTITION `p736666` VALUES LESS THAN (736666) ENGINE = InnoDB,
+ PARTITION `p736667` VALUES LESS THAN (736667) ENGINE = InnoDB,
+ PARTITION `p736668` VALUES LESS THAN (736668) ENGINE = InnoDB,
+ PARTITION `p736669` VALUES LESS THAN (736669) ENGINE = InnoDB,
+ PARTITION `p736670` VALUES LESS THAN (736670) ENGINE = InnoDB,
+ PARTITION `p736671` VALUES LESS THAN (736671) ENGINE = InnoDB,
+ PARTITION `p736672` VALUES LESS THAN (736672) ENGINE = InnoDB,
+ PARTITION `p736673` VALUES LESS THAN (736673) ENGINE = InnoDB,
+ PARTITION `p736674` VALUES LESS THAN (736674) ENGINE = InnoDB,
+ PARTITION `p736675` VALUES LESS THAN (736675) ENGINE = InnoDB,
+ PARTITION `p736676` VALUES LESS THAN (736676) ENGINE = InnoDB,
+ PARTITION `p736677` VALUES LESS THAN (736677) ENGINE = InnoDB,
+ PARTITION `p736678` VALUES LESS THAN (736678) ENGINE = InnoDB,
+ PARTITION `p736679` VALUES LESS THAN (736679) ENGINE = InnoDB,
+ PARTITION `p736680` VALUES LESS THAN (736680) ENGINE = InnoDB,
+ PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
+ PARTITION `p736682` VALUES LESS THAN (736682) ENGINE = InnoDB,
+ PARTITION `p736683` VALUES LESS THAN (736683) ENGINE = InnoDB,
+ PARTITION `p736684` VALUES LESS THAN (736684) ENGINE = InnoDB,
+ PARTITION `p736685` VALUES LESS THAN (736685) ENGINE = InnoDB,
+ PARTITION `p736686` VALUES LESS THAN (736686) ENGINE = InnoDB,
+ PARTITION `p736687` VALUES LESS THAN (736687) ENGINE = InnoDB,
+ PARTITION `p736688` VALUES LESS THAN (736688) ENGINE = InnoDB,
+ PARTITION `p736689` VALUES LESS THAN (736689) ENGINE = InnoDB,
+ PARTITION `p736690` VALUES LESS THAN (736690) ENGINE = InnoDB,
+ PARTITION `p736691` VALUES LESS THAN (736691) ENGINE = InnoDB,
+ PARTITION `p736692` VALUES LESS THAN (736692) ENGINE = InnoDB,
+ PARTITION `p736693` VALUES LESS THAN (736693) ENGINE = InnoDB,
+ PARTITION `p736694` VALUES LESS THAN (736694) ENGINE = InnoDB,
+ PARTITION `p736695` VALUES LESS THAN (736695) ENGINE = InnoDB,
+ PARTITION `p736696` VALUES LESS THAN (736696) ENGINE = InnoDB,
+ PARTITION `p736697` VALUES LESS THAN (736697) ENGINE = InnoDB,
+ PARTITION `p736698` VALUES LESS THAN (736698) ENGINE = InnoDB,
+ PARTITION `p736699` VALUES LESS THAN (736699) ENGINE = InnoDB,
+ PARTITION `p736700` VALUES LESS THAN (736700) ENGINE = InnoDB,
+ PARTITION `p736701` VALUES LESS THAN (736701) ENGINE = InnoDB,
+ PARTITION `p736702` VALUES LESS THAN (736702) ENGINE = InnoDB,
+ PARTITION `p736703` VALUES LESS THAN (736703) ENGINE = InnoDB,
+ PARTITION `p736704` VALUES LESS THAN (736704) ENGINE = InnoDB,
+ PARTITION `p736705` VALUES LESS THAN (736705) ENGINE = InnoDB,
+ PARTITION `p736706` VALUES LESS THAN (736706) ENGINE = InnoDB,
+ PARTITION `p736707` VALUES LESS THAN (736707) ENGINE = InnoDB,
+ PARTITION `p736708` VALUES LESS THAN (736708) ENGINE = InnoDB,
+ PARTITION `p736709` VALUES LESS THAN (736709) ENGINE = InnoDB,
+ PARTITION `p736710` VALUES LESS THAN (736710) ENGINE = InnoDB,
+ PARTITION `p736711` VALUES LESS THAN (736711) ENGINE = InnoDB,
+ PARTITION `p736712` VALUES LESS THAN (736712) ENGINE = InnoDB,
+ PARTITION `p736713` VALUES LESS THAN (736713) ENGINE = InnoDB,
+ PARTITION `p736714` VALUES LESS THAN (736714) ENGINE = InnoDB,
+ PARTITION `p736715` VALUES LESS THAN (736715) ENGINE = InnoDB,
+ PARTITION `p736716` VALUES LESS THAN (736716) ENGINE = InnoDB,
+ PARTITION `p736717` VALUES LESS THAN (736717) ENGINE = InnoDB,
+ PARTITION `p736718` VALUES LESS THAN (736718) ENGINE = InnoDB,
+ PARTITION `p736719` VALUES LESS THAN (736719) ENGINE = InnoDB,
+ PARTITION `p736720` VALUES LESS THAN (736720) ENGINE = InnoDB,
+ PARTITION `p736721` VALUES LESS THAN (736721) ENGINE = InnoDB,
+ PARTITION `p736722` VALUES LESS THAN (736722) ENGINE = InnoDB,
+ PARTITION `p736723` VALUES LESS THAN (736723) ENGINE = InnoDB,
+ PARTITION `p736724` VALUES LESS THAN (736724) ENGINE = InnoDB,
+ PARTITION `p736725` VALUES LESS THAN (736725) ENGINE = InnoDB,
+ PARTITION `p736726` VALUES LESS THAN (736726) ENGINE = InnoDB,
+ PARTITION `p736727` VALUES LESS THAN (736727) ENGINE = InnoDB,
+ PARTITION `p736728` VALUES LESS THAN (736728) ENGINE = InnoDB,
+ PARTITION `p736729` VALUES LESS THAN (736729) ENGINE = InnoDB,
+ PARTITION `p736730` VALUES LESS THAN (736730) ENGINE = InnoDB,
+ PARTITION `p736731` VALUES LESS THAN (736731) ENGINE = InnoDB,
+ PARTITION `p736732` VALUES LESS THAN (736732) ENGINE = InnoDB,
+ PARTITION `p736733` VALUES LESS THAN (736733) ENGINE = InnoDB,
+ PARTITION `p736734` VALUES LESS THAN (736734) ENGINE = InnoDB,
+ PARTITION `p736735` VALUES LESS THAN (736735) ENGINE = InnoDB,
+ PARTITION `p736736` VALUES LESS THAN (736736) ENGINE = InnoDB,
+ PARTITION `p736737` VALUES LESS THAN (736737) ENGINE = InnoDB,
+ PARTITION `p736738` VALUES LESS THAN (736738) ENGINE = InnoDB,
+ PARTITION `p736739` VALUES LESS THAN (736739) ENGINE = InnoDB,
+ PARTITION `p736740` VALUES LESS THAN (736740) ENGINE = InnoDB,
+ PARTITION `p736741` VALUES LESS THAN (736741) ENGINE = InnoDB,
+ PARTITION `p736742` VALUES LESS THAN (736742) ENGINE = InnoDB,
+ PARTITION `p736743` VALUES LESS THAN (736743) ENGINE = InnoDB,
+ PARTITION `p736744` VALUES LESS THAN (736744) ENGINE = InnoDB,
+ PARTITION `p736745` VALUES LESS THAN (736745) ENGINE = InnoDB,
+ PARTITION `p736746` VALUES LESS THAN (736746) 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);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -627,7 +1512,100 @@ CREATE TABLE `t_metric_aggregate_resource_hourly` (
   `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
   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 BY RANGE (to_days(`aggregate_datetime`))
+(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);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -666,7 +1644,401 @@ CREATE TABLE `t_metric_aggregate_tenant_daily` (
   `customer_id` int(11) NOT NULL DEFAULT 0,
   PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- PARTITION BY RANGE (to_days(`aggregate_datetime`));
+ PARTITION BY RANGE (to_days(`aggregate_datetime`))
+(PARTITION `p736651` VALUES LESS THAN (736651) ENGINE = InnoDB,
+ PARTITION `p736652` VALUES LESS THAN (736652) ENGINE = InnoDB,
+ PARTITION `p736653` VALUES LESS THAN (736653) ENGINE = InnoDB,
+ PARTITION `p736654` VALUES LESS THAN (736654) ENGINE = InnoDB,
+ PARTITION `p736655` VALUES LESS THAN (736655) ENGINE = InnoDB,
+ PARTITION `p736656` VALUES LESS THAN (736656) ENGINE = InnoDB,
+ PARTITION `p736657` VALUES LESS THAN (736657) ENGINE = InnoDB,
+ PARTITION `p736658` VALUES LESS THAN (736658) ENGINE = InnoDB,
+ PARTITION `p736659` VALUES LESS THAN (736659) ENGINE = InnoDB,
+ PARTITION `p736660` VALUES LESS THAN (736660) ENGINE = InnoDB,
+ PARTITION `p736661` VALUES LESS THAN (736661) ENGINE = InnoDB,
+ PARTITION `p736662` VALUES LESS THAN (736662) ENGINE = InnoDB,
+ PARTITION `p736663` VALUES LESS THAN (736663) ENGINE = InnoDB,
+ PARTITION `p736664` VALUES LESS THAN (736664) ENGINE = InnoDB,
+ PARTITION `p736665` VALUES LESS THAN (736665) ENGINE = InnoDB,
+ PARTITION `p736666` VALUES LESS THAN (736666) ENGINE = InnoDB,
+ PARTITION `p736667` VALUES LESS THAN (736667) ENGINE = InnoDB,
+ PARTITION `p736668` VALUES LESS THAN (736668) ENGINE = InnoDB,
+ PARTITION `p736669` VALUES LESS THAN (736669) ENGINE = InnoDB,
+ PARTITION `p736670` VALUES LESS THAN (736670) ENGINE = InnoDB,
+ PARTITION `p736671` VALUES LESS THAN (736671) ENGINE = InnoDB,
+ PARTITION `p736672` VALUES LESS THAN (736672) ENGINE = InnoDB,
+ PARTITION `p736673` VALUES LESS THAN (736673) ENGINE = InnoDB,
+ PARTITION `p736674` VALUES LESS THAN (736674) ENGINE = InnoDB,
+ PARTITION `p736675` VALUES LESS THAN (736675) ENGINE = InnoDB,
+ PARTITION `p736676` VALUES LESS THAN (736676) ENGINE = InnoDB,
+ PARTITION `p736677` VALUES LESS THAN (736677) ENGINE = InnoDB,
+ PARTITION `p736678` VALUES LESS THAN (736678) ENGINE = InnoDB,
+ PARTITION `p736679` VALUES LESS THAN (736679) ENGINE = InnoDB,
+ PARTITION `p736680` VALUES LESS THAN (736680) ENGINE = InnoDB,
+ PARTITION `p736681` VALUES LESS THAN (736681) ENGINE = InnoDB,
+ PARTITION `p736682` VALUES LESS THAN (736682) ENGINE = InnoDB,
+ PARTITION `p736683` VALUES LESS THAN (736683) ENGINE = InnoDB,
+ PARTITION `p736684` VALUES LESS THAN (736684) ENGINE = InnoDB,
+ PARTITION `p736685` VALUES LESS THAN (736685) ENGINE = InnoDB,
+ PARTITION `p736686` VALUES LESS THAN (736686) ENGINE = InnoDB,
+ PARTITION `p736687` VALUES LESS THAN (736687) ENGINE = InnoDB,
+ PARTITION `p736688` VALUES LESS THAN (736688) ENGINE = InnoDB,
+ PARTITION `p736689` VALUES LESS THAN (736689) ENGINE = InnoDB,
+ PARTITION `p736690` VALUES LESS THAN (736690) ENGINE = InnoDB,
+ PARTITION `p736691` VALUES LESS THAN (736691) ENGINE = InnoDB,
+ PARTITION `p736692` VALUES LESS THAN (736692) ENGINE = InnoDB,
+ PARTITION `p736693` VALUES LESS THAN (736693) ENGINE = InnoDB,
+ PARTITION `p736694` VALUES LESS THAN (736694) ENGINE = InnoDB,
+ PARTITION `p736695` VALUES LESS THAN (736695) ENGINE = InnoDB,
+ PARTITION `p736696` VALUES LESS THAN (736696) ENGINE = InnoDB,
+ PARTITION `p736697` VALUES LESS THAN (736697) ENGINE = InnoDB,
+ PARTITION `p736698` VALUES LESS THAN (736698) ENGINE = InnoDB,
+ PARTITION `p736699` VALUES LESS THAN (736699) ENGINE = InnoDB,
+ PARTITION `p736700` VALUES LESS THAN (736700) ENGINE = InnoDB,
+ PARTITION `p736701` VALUES LESS THAN (736701) ENGINE = InnoDB,
+ PARTITION `p736702` VALUES LESS THAN (736702) ENGINE = InnoDB,
+ PARTITION `p736703` VALUES LESS THAN (736703) ENGINE = InnoDB,
+ PARTITION `p736704` VALUES LESS THAN (736704) ENGINE = InnoDB,
+ PARTITION `p736705` VALUES LESS THAN (736705) ENGINE = InnoDB,
+ PARTITION `p736706` VALUES LESS THAN (736706) ENGINE = InnoDB,
+ PARTITION `p736707` VALUES LESS THAN (736707) ENGINE = InnoDB,
+ PARTITION `p736708` VALUES LESS THAN (736708) ENGINE = InnoDB,
+ PARTITION `p736709` VALUES LESS THAN (736709) ENGINE = InnoDB,
+ PARTITION `p736710` VALUES LESS THAN (736710) ENGINE = InnoDB,
+ PARTITION `p736711` VALUES LESS THAN (736711) ENGINE = InnoDB,
+ PARTITION `p736712` VALUES LESS THAN (736712) ENGINE = InnoDB,
+ PARTITION `p736713` VALUES LESS THAN (736713) ENGINE = InnoDB,
+ PARTITION `p736714` VALUES LESS THAN (736714) ENGINE = InnoDB,
+ PARTITION `p736715` VALUES LESS THAN (736715) ENGINE = InnoDB,
+ PARTITION `p736716` VALUES LESS THAN (736716) ENGINE = InnoDB,
+ PARTITION `p736717` VALUES LESS THAN (736717) ENGINE = InnoDB,
+ PARTITION `p736718` VALUES LESS THAN (736718) ENGINE = InnoDB,
+ PARTITION `p736719` VALUES LESS THAN (736719) ENGINE = InnoDB,
+ PARTITION `p736720` VALUES LESS THAN (736720) ENGINE = InnoDB,
+ PARTITION `p736721` VALUES LESS THAN (736721) ENGINE = InnoDB,
+ PARTITION `p736722` VALUES LESS THAN (736722) ENGINE = InnoDB,
+ PARTITION `p736723` VALUES LESS THAN (736723) ENGINE = InnoDB,
+ PARTITION `p736724` VALUES LESS THAN (736724) ENGINE = InnoDB,
+ PARTITION `p736725` VALUES LESS THAN (736725) ENGINE = InnoDB,
+ PARTITION `p736726` VALUES LESS THAN (736726) ENGINE = InnoDB,
+ PARTITION `p736727` VALUES LESS THAN (736727) ENGINE = InnoDB,
+ PARTITION `p736728` VALUES LESS THAN (736728) ENGINE = InnoDB,
+ PARTITION `p736729` VALUES LESS THAN (736729) ENGINE = InnoDB,
+ PARTITION `p736730` VALUES LESS THAN (736730) ENGINE = InnoDB,
+ PARTITION `p736731` VALUES LESS THAN (736731) ENGINE = InnoDB,
+ PARTITION `p736732` VALUES LESS THAN (736732) ENGINE = InnoDB,
+ PARTITION `p736733` VALUES LESS THAN (736733) ENGINE = InnoDB,
+ PARTITION `p736734` VALUES LESS THAN (736734) ENGINE = InnoDB,
+ PARTITION `p736735` VALUES LESS THAN (736735) ENGINE = InnoDB,
+ PARTITION `p736736` VALUES LESS THAN (736736) ENGINE = InnoDB,
+ PARTITION `p736737` VALUES LESS THAN (736737) ENGINE = InnoDB,
+ PARTITION `p736738` VALUES LESS THAN (736738) ENGINE = InnoDB,
+ PARTITION `p736739` VALUES LESS THAN (736739) ENGINE = InnoDB,
+ PARTITION `p736740` VALUES LESS THAN (736740) ENGINE = InnoDB,
+ PARTITION `p736741` VALUES LESS THAN (736741) ENGINE = InnoDB,
+ PARTITION `p736742` VALUES LESS THAN (736742) ENGINE = InnoDB,
+ PARTITION `p736743` VALUES LESS THAN (736743) ENGINE = InnoDB,
+ PARTITION `p736744` VALUES LESS THAN (736744) ENGINE = InnoDB,
+ PARTITION `p736745` VALUES LESS THAN (736745) ENGINE = InnoDB,
+ PARTITION `p736746` VALUES LESS THAN (736746) 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);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -683,7 +2055,100 @@ CREATE TABLE `t_metric_aggregate_tenant_hourly` (
   `service_region_id` int(10) unsigned NOT NULL DEFAULT 0,
   PRIMARY KEY (`metric_id`,`tenant_id`,`service_region_id`,`aggregate_datetime`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8
- PARTITION BY RANGE (to_days(`aggregate_datetime`));
+ PARTITION BY RANGE (to_days(`aggregate_datetime`))
+(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);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -720,7 +2185,47 @@ CREATE TABLE `t_metric_values` (
   KEY `ix_metric_values_2` (`metric_id`,`tenant_id`,`service_region_id`,`metric_datetime`),
   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 BY RANGE (to_days(`metric_datetime`))
+(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);
 /*!40101 SET character_set_client = @saved_cs_client */;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1026,7 +2531,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=82254 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=83401 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 */;
@@ -1129,7 +2634,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=1940 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=1967 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 */;
@@ -1149,7 +2654,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=824 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=898 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 */;
@@ -1231,7 +2736,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=824 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=898 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 */;
@@ -1637,9 +3142,12 @@ SET character_set_client = utf8;
   `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 '{% raw %}{{ openbook_database_password }}{% endraw %}';
 GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
+
 USE `openbook_jobs`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -1812,9 +3320,12 @@ CREATE TABLE `QRTZ_TRIGGERS` (
   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 '{% raw %}{{ openbook_database_password }}{% endraw %}';
 GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
+
 USE `openbook_workflow`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
@@ -2303,8 +3814,10 @@ CREATE TABLE `ACT_RU_VARIABLE` (
   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 '{% raw %}{{ openbook_database_password }}{% endraw %}';
 GRANT ALL PRIVILEGES ON openbook.* TO openbook@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
+
 USE `openbook`;
 /*!50001 DROP TABLE IF EXISTS `v_all_charges`*/;
 /*!50001 SET @saved_cs_client          = @@character_set_client */;
@@ -2514,13 +4027,18 @@ USE `openbook`;
 /*!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 '{% raw %}{{ openbook_database_password }}{% endraw %}';
 GRANT ALL PRIVILEGES ON openbook_jobs.* TO openbook_jobs@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
+
 USE `openbook_jobs`;
+
 GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@'%' IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
 GRANT ALL PRIVILEGES ON openbook_workflow.* TO openbook_workflow@localhost IDENTIFIED BY '{% raw %}{{ openbook_database_password }}{% endraw %}';
+
 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 */;
@@ -2528,6 +4046,7 @@ USE `openbook_workflow`;
 /*!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);
author	ckonstanski <ckonstanski@pippiandcarlos.com>	2017-11-14 10:00:36 -0700
committer	ckonstanski <ckonstanski@pippiandcarlos.com>	2017-11-14 10:00:36 -0700
commit	8a183ce966f114ac8a3434f11a0e340b903f144d (patch)
tree	0be9fd80423363bac7957765fa41ed00c22efc62 /salt/openbook
parent	a14ad3b7a813b25f8282433e61cfa175fce000cb (diff)