/*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_uint` ( `itemid` bigint(20) unsigned NOT NULL DEFAULT '0', `clock` int(11) NOT NULL DEFAULT '0', `value` bigint(20) unsigned NOT NULL DEFAULT '0', KEY `history_uint_1` (`itemid`,`clock`) ) /*!50100 PARTITION BY RANGE ( clock) (PARTITION p2012_01_05 VALUES LESS THAN (1325707200), PARTITION p2012_01_06 VALUES LESS THAN (1325793600), PARTITION p2012_01_07 VALUES LESS THAN (1325880000), PARTITION p2012_01_08 VALUES LESS THAN (1325966400), PARTITION p2012_01_09 VALUES LESS THAN (1326052800), PARTITION p2012_01_10 VALUES LESS THAN (1326139200), PARTITION p2012_01_11 VALUES LESS THAN (1326225600), PARTITION p2012_01_12 VALUES LESS THAN (1326312000), PARTITION p2012_01_13 VALUES LESS THAN (1326398400), PARTITION p2012_01_14 VALUES LESS THAN (1326484800), PARTITION p2012_01_15 VALUES LESS THAN (1326571200), PARTITION p2012_01_16 VALUES LESS THAN (1326657600), PARTITION p2012_01_17 VALUES LESS THAN (1326744000), PARTITION p2012_01_18 VALUES LESS THAN (1326830400), PARTITION p2012_01_19 VALUES LESS THAN (1326916800), PARTITION p2012_01_20 VALUES LESS THAN (1327003200), PARTITION p2012_01_21 VALUES LESS THAN (1327089600), PARTITION p2012_01_22 VALUES LESS THAN (1327176000), PARTITION p2012_01_23 VALUES LESS THAN (1327262400), PARTITION p2012_01_24 VALUES LESS THAN (1327348800), PARTITION p2012_01_25 VALUES LESS THAN (1327435200), PARTITION p2012_01_26 VALUES LESS THAN (1327521600), PARTITION p2012_01_27 VALUES LESS THAN (1327608000), PARTITION p2012_01_28 VALUES LESS THAN (1327694400), PARTITION p2012_01_29 VALUES LESS THAN (1327780800), PARTITION p2012_01_30 VALUES LESS THAN (1327867200), PARTITION p2012_01_31 VALUES LESS THAN (1327953600), PARTITION p2012_02_01 VALUES LESS THAN (1328040000), PARTITION p2012_02_02 VALUES LESS THAN (1328126400), PARTITION p2012_02_03 VALUES LESS THAN (1328212800), PARTITION p2012_02_04 VALUES LESS THAN (1328299200), PARTITION p2012_02_05 VALUES LESS THAN (1328385600), PARTITION p2012_02_06 VALUES LESS THAN (1328472000), PARTITION p2012_02_07 VALUES LESS THAN (1328558400), PARTITION p2012_02_08 VALUES LESS THAN (1328644800), PARTITION p2012_02_09 VALUES LESS THAN (1328731200), PARTITION p2012_02_10 VALUES LESS THAN (1328817600), PARTITION p2012_02_11 VALUES LESS THAN (1328904000), PARTITION p2012_02_12 VALUES LESS THAN (1328990400), PARTITION p2012_02_13 VALUES LESS THAN (1329076800), PARTITION p2012_02_14 VALUES LESS THAN (1329163200), PARTITION p2012_02_15 VALUES LESS THAN (1329249600), PARTITION p2012_02_16 VALUES LESS THAN (1329336000), PARTITION p2012_02_17 VALUES LESS THAN (1329422400), PARTITION p2012_02_18 VALUES LESS THAN (1329508800), PARTITION p2012_02_19 VALUES LESS THAN (1329595200), PARTITION p2012_02_20 VALUES LESS THAN (1329681600), PARTITION p2012_02_21 VALUES LESS THAN (1329768000), PARTITION p2012_02_22 VALUES LESS THAN (1329854400), PARTITION p2012_02_23 VALUES LESS THAN (1329940800), PARTITION p2012_02_24 VALUES LESS THAN (1330027200), PARTITION p2012_02_25 VALUES LESS THAN (1330113600), PARTITION p2012_02_26 VALUES LESS THAN (1330200000), PARTITION p2012_02_27 VALUES LESS THAN (1330286400), PARTITION p2012_02_28 VALUES LESS THAN (1330372800), PARTITION p2012_02_29 VALUES LESS THAN (1330459200), PARTITION p2012_03_01 VALUES LESS THAN (1330545600), PARTITION p2012_03_02 VALUES LESS THAN (1330632000), PARTITION p2012_03_03 VALUES LESS THAN (1330718400), PARTITION p2012_03_04 VALUES LESS THAN (1330804800), PARTITION p2012_03_05 VALUES LESS THAN (1330891200), PARTITION p2012_03_06 VALUES LESS THAN (1330977600), PARTITION p2012_03_07 VALUES LESS THAN (1331064000), PARTITION p2012_03_08 VALUES LESS THAN (1331150400), PARTITION p2012_03_09 VALUES LESS THAN (1331236800), PARTITION p2012_03_10 VALUES LESS THAN (1331323200), PARTITION p2012_03_11 VALUES LESS THAN (1331409600), PARTITION p2012_03_12 VALUES LESS THAN (1331496000), PARTITION p2012_03_13 VALUES LESS THAN (1331582400), PARTITION p2012_03_14 VALUES LESS THAN (1331668800), PARTITION p2012_03_15 VALUES LESS THAN (1331755200), PARTITION p2012_03_16 VALUES LESS THAN (1331841600), PARTITION p2012_03_17 VALUES LESS THAN (1331928000), PARTITION p2012_03_18 VALUES LESS THAN (1332014400), PARTITION p2012_03_19 VALUES LESS THAN (1332100800), PARTITION p2012_03_20 VALUES LESS THAN (1332187200), PARTITION p2012_03_21 VALUES LESS THAN (1332273600), PARTITION p2012_03_22 VALUES LESS THAN (1332360000), PARTITION p2012_03_23 VALUES LESS THAN (1332446400), PARTITION p2012_03_24 VALUES LESS THAN (1332532800), PARTITION p2012_03_25 VALUES LESS THAN (1332619200), PARTITION p2012_03_26 VALUES LESS THAN (1332705600), PARTITION p2012_03_27 VALUES LESS THAN (1332792000), PARTITION p2012_03_28 VALUES LESS THAN (1332878400), PARTITION p2012_03_29 VALUES LESS THAN (1332964800), PARTITION p2012_03_30 VALUES LESS THAN (1333051200), PARTITION p2012_03_31 VALUES LESS THAN (1333137600), PARTITION p2012_04_01 VALUES LESS THAN (1333224000), PARTITION p2012_04_02 VALUES LESS THAN (1333310400), PARTITION p2012_04_03 VALUES LESS THAN (1333396800), PARTITION p2012_04_04 VALUES LESS THAN (1333483200), PARTITION p2012_04_05 VALUES LESS THAN (1333569600), PARTITION p2012_04_06 VALUES LESS THAN (1333656000), PARTITION p2012_04_07 VALUES LESS THAN (1333742400), PARTITION p2012_04_08 VALUES LESS THAN (1333828800), PARTITION p2012_04_09 VALUES LESS THAN (1333915200), PARTITION p2012_04_10 VALUES LESS THAN (1334001600), PARTITION p2012_04_11 VALUES LESS THAN (1334088000), PARTITION p2012_04_12 VALUES LESS THAN (1334174400), PARTITION p2012_04_13 VALUES LESS THAN (1334260800), PARTITION p2012_04_14 VALUES LESS THAN (1334347200), PARTITION p2012_04_15 VALUES LESS THAN (1334433600), PARTITION p2012_04_16 VALUES LESS THAN (1334520000), PARTITION p2012_04_17 VALUES LESS THAN (1334606400), PARTITION p2012_04_18 VALUES LESS THAN (1334692800), PARTITION p2012_04_19 VALUES LESS THAN (1334779200), PARTITION p2012_04_20 VALUES LESS THAN (1334865600), PARTITION p2012_04_21 VALUES LESS THAN (1334952000), PARTITION p2012_04_22 VALUES LESS THAN (1335038400), PARTITION p2012_04_23 VALUES LESS THAN (1335124800), PARTITION p2012_04_24 VALUES LESS THAN (1335211200), PARTITION p2012_04_25 VALUES LESS THAN (1335297600), PARTITION p2012_04_26 VALUES LESS THAN (1335384000), PARTITION p2012_04_27 VALUES LESS THAN (1335470400), PARTITION p2012_04_28 VALUES LESS THAN (1335556800), PARTITION p2012_04_29 VALUES LESS THAN (1335643200), PARTITION p2012_04_30 VALUES LESS THAN (1335729600), PARTITION p2012_05_01 VALUES LESS THAN (1335816000), PARTITION p2012_05_02 VALUES LESS THAN (1335902400), PARTITION p2012_05_03 VALUES LESS THAN (1335988800), PARTITION p2012_05_04 VALUES LESS THAN (1336075200), PARTITION p2012_05_05 VALUES LESS THAN (1336161600), PARTITION p2012_05_06 VALUES LESS THAN (1336248000), PARTITION p2012_05_07 VALUES LESS THAN (1336334400), PARTITION p2012_05_08 VALUES LESS THAN (1336420800), PARTITION p2012_05_09 VALUES LESS THAN (1336507200), PARTITION p2012_05_10 VALUES LESS THAN (1336593600), PARTITION p2012_05_11 VALUES LESS THAN (1336680000), PARTITION p2012_05_12 VALUES LESS THAN (1336766400), PARTITION p2012_05_13 VALUES LESS THAN (1336852800), PARTITION p2012_05_14 VALUES LESS THAN (1336939200), PARTITION p2012_05_15 VALUES LESS THAN (1337025600), PARTITION p2012_05_16 VALUES LESS THAN (1337112000), PARTITION p2012_05_17 VALUES LESS THAN (1337198400), PARTITION p2012_05_18 VALUES LESS THAN (1337284800), PARTITION p2012_05_19 VALUES LESS THAN (1337371200), PARTITION p2012_05_20 VALUES LESS THAN (1337457600), PARTITION p2012_05_21 VALUES LESS THAN (1337544000), PARTITION p2012_05_22 VALUES LESS THAN (1337630400), PARTITION p2012_05_23 VALUES LESS THAN (1337716800), PARTITION p2012_05_24 VALUES LESS THAN (1337803200), PARTITION p2012_05_25 VALUES LESS THAN (1337889600), PARTITION p2012_05_26 VALUES LESS THAN (1337976000), PARTITION p2012_05_27 VALUES LESS THAN (1338062400), PARTITION p2012_05_28 VALUES LESS THAN (1338148800), PARTITION p2012_05_29 VALUES LESS THAN (1338235200), PARTITION p2012_05_30 VALUES LESS THAN (1338321600), PARTITION p2012_05_31 VALUES LESS THAN (1338408000), PARTITION p2012_06_01 VALUES LESS THAN (1338494400), PARTITION p2012_06_02 VALUES LESS THAN (1338580800), PARTITION p2012_06_03 VALUES LESS THAN (1338667200), PARTITION p2012_06_04 VALUES LESS THAN (1338753600), PARTITION p2012_06_05 VALUES LESS THAN (1338840000), PARTITION p2012_06_06 VALUES LESS THAN (1338926400), PARTITION p2012_06_07 VALUES LESS THAN (1339012800), PARTITION p2012_06_08 VALUES LESS THAN (1339099200), PARTITION p2012_06_09 VALUES LESS THAN (1339185600), PARTITION p2012_06_10 VALUES LESS THAN (1339272000), PARTITION p2012_06_11 VALUES LESS THAN (1339358400), PARTITION p2012_06_12 VALUES LESS THAN (1339444800), PARTITION p2012_06_13 VALUES LESS THAN (1339531200), PARTITION p2012_06_14 VALUES LESS THAN (1339617600), PARTITION p2012_06_15 VALUES LESS THAN (1339704000), PARTITION p2012_06_16 VALUES LESS THAN (1339790400), PARTITION p2012_06_17 VALUES LESS THAN (1339876800), PARTITION p2012_06_18 VALUES LESS THAN (1339963200), PARTITION p2012_06_19 VALUES LESS THAN (1340049600), PARTITION p2012_06_20 VALUES LESS THAN (1340136000), PARTITION p2012_06_21 VALUES LESS THAN (1340222400), PARTITION p2012_06_22 VALUES LESS THAN (1340308800), PARTITION p2012_06_23 VALUES LESS THAN (1340395200), PARTITION p2012_06_24 VALUES LESS THAN (1340481600), PARTITION p2012_06_25 VALUES LESS THAN (1340568000), PARTITION p2012_06_26 VALUES LESS THAN (1340654400), PARTITION p2012_06_27 VALUES LESS THAN (1340740800), PARTITION p2012_06_28 VALUES LESS THAN (1340827200), PARTITION p2012_06_29 VALUES LESS THAN (1340913600), PARTITION p2012_06_30 VALUES LESS THAN (1341000000), PARTITION p2012_07_01 VALUES LESS THAN (1341086400), PARTITION p2012_07_02 VALUES LESS THAN (1341172800), PARTITION p2012_07_03 VALUES LESS THAN (1341259200), PARTITION p2012_07_04 VALUES LESS THAN (1341345600), PARTITION p2012_07_05 VALUES LESS THAN (1341432000), PARTITION p2012_07_06 VALUES LESS THAN (1341518400), PARTITION p2012_07_07 VALUES LESS THAN (1341604800), PARTITION p2012_07_08 VALUES LESS THAN (1341691200), PARTITION p2012_07_09 VALUES LESS THAN (1341777600), PARTITION p2012_07_10 VALUES LESS THAN (1341864000), PARTITION p2012_07_11 VALUES LESS THAN (1341950400), PARTITION p2012_07_12 VALUES LESS THAN (1342036800), PARTITION p2012_07_13 VALUES LESS THAN (1342123200), PARTITION p2012_07_14 VALUES LESS THAN (1342209600), PARTITION p2012_07_15 VALUES LESS THAN (1342296000), PARTITION p2012_07_16 VALUES LESS THAN (1342382400), PARTITION p2012_07_17 VALUES LESS THAN (1342468800), PARTITION p2012_07_18 VALUES LESS THAN (1342555200), PARTITION p2012_07_19 VALUES LESS THAN (1342641600), PARTITION p2012_07_20 VALUES LESS THAN (1342728000), PARTITION p2012_07_21 VALUES LESS THAN (1342814400), PARTITION p2012_07_22 VALUES LESS THAN (1342900800), PARTITION p2012_07_23 VALUES LESS THAN (1342987200), PARTITION p2012_07_24 VALUES LESS THAN (1343073600), PARTITION p2012_07_25 VALUES LESS THAN (1343160000)) */; /*!40101 SET character_set_client = @saved_cs_client */;