mysql> show create table TM_DATA\G *************************** 1. row *************************** Table: TM_DATA Create Table: CREATE TABLE `TM_DATA` ( `FTIME_SECS` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet filing time seconds', `FTIME_USECS` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet filing time useconds', `CTIME_SECS` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet creation time seconds', `CTIME_USECS` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet creation time useconds', `CREATE_ID` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet creation ID', `SPID` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet SPID', `DSTREAM` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Data stream', `VERSION` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet TDEV version', `GSID` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Ground station ID', `COUNTER` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet counter', `IDENT` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Identification entry', `GROUP_ID` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SPID group ID', `FLAGS` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'TDEV Flags', `VALIDITY` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Packet validity flags', `TPSD` int(11) NOT NULL DEFAULT '0' COMMENT 'TPSD Variable structure', `ROUTEID` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Route ID', `PUS_APID` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'PUS application ID', `PUS_SSC` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'PUS source site code', `PUS_ST` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'PUS service type', `PUS_SST` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'PUS service sub-type', `DATA` mediumblob COMMENT 'TM header + frame', PRIMARY KEY (`FTIME_SECS`,`FTIME_USECS`,`CTIME_SECS`,`CTIME_USECS`,`CREATE_ID`,`DSTREAM`), KEY `SPID_KEY` (`DSTREAM`,`SPID`,`FTIME_SECS`,`FTIME_USECS`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Telemetry packets data STA' /*!50100 PARTITION BY RANGE ( `FTIME_SECS`) (PARTITION p2008_01 VALUES LESS THAN (1201824000) ENGINE = MyISAM, PARTITION p2008_02 VALUES LESS THAN (1204329600) ENGINE = MyISAM, PARTITION p2008_03 VALUES LESS THAN (1207008000) ENGINE = MyISAM, PARTITION p2008_04 VALUES LESS THAN (1209600000) ENGINE = MyISAM, PARTITION p2008_05 VALUES LESS THAN (1212278400) ENGINE = MyISAM, PARTITION p2008_06 VALUES LESS THAN (1214870400) ENGINE = MyISAM, PARTITION p2008_07 VALUES LESS THAN (1217548800) ENGINE = MyISAM, PARTITION p2008_08 VALUES LESS THAN (1220227200) ENGINE = MyISAM, PARTITION p2008_09 VALUES LESS THAN (1222819200) ENGINE = MyISAM, PARTITION p2008_10 VALUES LESS THAN (1225497600) ENGINE = MyISAM, PARTITION p2008_11 VALUES LESS THAN (1228089600) ENGINE = MyISAM, PARTITION p2008_12 VALUES LESS THAN (1230768000) ENGINE = MyISAM, PARTITION p2009_01 VALUES LESS THAN (1233446400) ENGINE = MyISAM, PARTITION p2009_02 VALUES LESS THAN (1235865600) ENGINE = MyISAM, PARTITION p2009_03 VALUES LESS THAN (1238544000) ENGINE = MyISAM, PARTITION p2009_04 VALUES LESS THAN (1241136000) ENGINE = MyISAM, PARTITION p2009_05 VALUES LESS THAN (1243814400) ENGINE = MyISAM, PARTITION p2009_06 VALUES LESS THAN (1246406400) ENGINE = MyISAM, PARTITION p2009_07 VALUES LESS THAN (1249084800) ENGINE = MyISAM, PARTITION p2009_08 VALUES LESS THAN (1251763200) ENGINE = MyISAM, PARTITION p2009_09 VALUES LESS THAN (1254355200) ENGINE = MyISAM, PARTITION p2009_10 VALUES LESS THAN (1257033600) ENGINE = MyISAM, PARTITION p2009_11 VALUES LESS THAN (1259625600) ENGINE = MyISAM, PARTITION p2009_12 VALUES LESS THAN (1262304000) ENGINE = MyISAM, PARTITION p2010_01 VALUES LESS THAN (1264982400) ENGINE = MyISAM, PARTITION p2010_02 VALUES LESS THAN (1267401600) ENGINE = MyISAM, PARTITION p2010_03 VALUES LESS THAN (1270080000) ENGINE = MyISAM, PARTITION p2010_04 VALUES LESS THAN (1272672000) ENGINE = MyISAM, PARTITION p2010_05 VALUES LESS THAN (1275350400) ENGINE = MyISAM, PARTITION p2010_06 VALUES LESS THAN (1277942400) ENGINE = MyISAM, PARTITION p2010_07 VALUES LESS THAN (1280620800) ENGINE = MyISAM, PARTITION p2010_08 VALUES LESS THAN (1283299200) ENGINE = MyISAM, PARTITION p2010_09 VALUES LESS THAN (1285891200) ENGINE = MyISAM, PARTITION p2010_10 VALUES LESS THAN (1288569600) ENGINE = MyISAM, PARTITION p2010_11 VALUES LESS THAN (1291161600) ENGINE = MyISAM, PARTITION p2010_12 VALUES LESS THAN (1293840000) ENGINE = MyISAM, PARTITION p2011_01 VALUES LESS THAN (1296518400) ENGINE = MyISAM, PARTITION p2011_02 VALUES LESS THAN (1298937600) ENGINE = MyISAM, PARTITION p2011_03 VALUES LESS THAN (1301616000) ENGINE = MyISAM, PARTITION p2011_04 VALUES LESS THAN (1304208000) ENGINE = MyISAM, PARTITION p2011_05 VALUES LESS THAN (1306886400) ENGINE = MyISAM, PARTITION p2011_06 VALUES LESS THAN (1309478400) ENGINE = MyISAM, PARTITION p2011_07 VALUES LESS THAN (1312156800) ENGINE = MyISAM, PARTITION p2011_08 VALUES LESS THAN (1314835200) ENGINE = MyISAM, PARTITION p2011_09 VALUES LESS THAN (1317427200) ENGINE = MyISAM, PARTITION p2011_10 VALUES LESS THAN (1320105600) ENGINE = MyISAM, PARTITION p2011_11 VALUES LESS THAN (1322697600) ENGINE = MyISAM, PARTITION p2011_12 VALUES LESS THAN (1325376000) ENGINE = MyISAM, PARTITION p2012_01 VALUES LESS THAN (1328054400) ENGINE = MyISAM, PARTITION p2012_02 VALUES LESS THAN (1330560000) ENGINE = MyISAM, PARTITION p2012_03 VALUES LESS THAN (1333238400) ENGINE = MyISAM, PARTITION p2012_04 VALUES LESS THAN (1335830400) ENGINE = MyISAM, PARTITION p2012_05 VALUES LESS THAN (1338508800) ENGINE = MyISAM, PARTITION p2012_06 VALUES LESS THAN (1341100800) ENGINE = MyISAM, PARTITION p2012_07 VALUES LESS THAN (1343779200) ENGINE = MyISAM, PARTITION p2012_08 VALUES LESS THAN (1346457600) ENGINE = MyISAM, PARTITION p2012_09 VALUES LESS THAN (1349049600) ENGINE = MyISAM, PARTITION p2012_10 VALUES LESS THAN (1351728000) ENGINE = MyISAM, PARTITION p2012_11 VALUES LESS THAN (1354320000) ENGINE = MyISAM, PARTITION p2012_12 VALUES LESS THAN (1356998400) ENGINE = MyISAM, PARTITION p2013_01 VALUES LESS THAN (1359676800) ENGINE = MyISAM, PARTITION p2013_02 VALUES LESS THAN (1362096000) ENGINE = MyISAM, PARTITION p2013_03 VALUES LESS THAN (1364774400) ENGINE = MyISAM, PARTITION p2013_04 VALUES LESS THAN (1367366400) ENGINE = MyISAM, PARTITION p2013_05 VALUES LESS THAN (1370044800) ENGINE = MyISAM, PARTITION p2013_06 VALUES LESS THAN (1372636800) ENGINE = MyISAM, PARTITION p2013_07 VALUES LESS THAN (1375315200) ENGINE = MyISAM, PARTITION p2013_08 VALUES LESS THAN (1377993600) ENGINE = MyISAM, PARTITION p2013_09 VALUES LESS THAN (1380585600) ENGINE = MyISAM, PARTITION p2013_10 VALUES LESS THAN (1383264000) ENGINE = MyISAM, PARTITION p2013_11 VALUES LESS THAN (1385856000) ENGINE = MyISAM, PARTITION p2013_12 VALUES LESS THAN (1388534400) ENGINE = MyISAM, PARTITION p2014_01 VALUES LESS THAN (1391212800) ENGINE = MyISAM, PARTITION p2014_02 VALUES LESS THAN (1393632000) ENGINE = MyISAM, PARTITION p2014_03 VALUES LESS THAN (1396310400) ENGINE = MyISAM, PARTITION p2014_04 VALUES LESS THAN (1398902400) ENGINE = MyISAM, PARTITION p2014_05 VALUES LESS THAN (1401580800) ENGINE = MyISAM, PARTITION p2014_06 VALUES LESS THAN (1404172800) ENGINE = MyISAM, PARTITION p2014_07 VALUES LESS THAN (1406851200) ENGINE = MyISAM, PARTITION p2014_08 VALUES LESS THAN (1409529600) ENGINE = MyISAM, PARTITION p2014_09 VALUES LESS THAN (1412121600) ENGINE = MyISAM, PARTITION p2014_10 VALUES LESS THAN (1414800000) ENGINE = MyISAM, PARTITION p2014_11 VALUES LESS THAN (1417392000) ENGINE = MyISAM, PARTITION p2014_12 VALUES LESS THAN (1420070400) ENGINE = MyISAM, PARTITION p2015_01 VALUES LESS THAN (1422748800) ENGINE = MyISAM, PARTITION p2015_02 VALUES LESS THAN (1425168000) ENGINE = MyISAM, PARTITION p2015_03 VALUES LESS THAN (1427846400) ENGINE = MyISAM, PARTITION p2015_04 VALUES LESS THAN (1430438400) ENGINE = MyISAM, PARTITION p2015_05 VALUES LESS THAN (1433116800) ENGINE = MyISAM, PARTITION p2015_06 VALUES LESS THAN (1435708800) ENGINE = MyISAM, PARTITION p2015_07 VALUES LESS THAN (1438387200) ENGINE = MyISAM, PARTITION p2015_08 VALUES LESS THAN (1441065600) ENGINE = MyISAM, PARTITION p2015_09 VALUES LESS THAN (1443657600) ENGINE = MyISAM, PARTITION p2015_10 VALUES LESS THAN (1446336000) ENGINE = MyISAM, PARTITION p2015_11 VALUES LESS THAN (1448928000) ENGINE = MyISAM, PARTITION p2015_12 VALUES LESS THAN (1451606400) ENGINE = MyISAM, PARTITION p2016_01 VALUES LESS THAN (1454284800) ENGINE = MyISAM, PARTITION p2016_02 VALUES LESS THAN (1456790400) ENGINE = MyISAM, PARTITION p2016_03 VALUES LESS THAN (1459468800) ENGINE = MyISAM, PARTITION p2016_04 VALUES LESS THAN (1462060800) ENGINE = MyISAM, PARTITION p2016_05 VALUES LESS THAN (1464739200) ENGINE = MyISAM, PARTITION p2016_06 VALUES LESS THAN (1467331200) ENGINE = MyISAM, PARTITION p2016_07 VALUES LESS THAN (1470009600) ENGINE = MyISAM, PARTITION p2016_08 VALUES LESS THAN (1472688000) ENGINE = MyISAM, PARTITION p2016_09 VALUES LESS THAN (1475280000) ENGINE = MyISAM, PARTITION p2016_10 VALUES LESS THAN (1477958400) ENGINE = MyISAM, PARTITION p2016_11 VALUES LESS THAN (1480550400) ENGINE = MyISAM, PARTITION p2016_12 VALUES LESS THAN (1483228800) ENGINE = MyISAM, PARTITION p2017_01 VALUES LESS THAN (1485907200) ENGINE = MyISAM, PARTITION p2017_02 VALUES LESS THAN (1488326400) ENGINE = MyISAM, PARTITION p2017_03 VALUES LESS THAN (1491004800) ENGINE = MyISAM, PARTITION p2017_04 VALUES LESS THAN (1493596800) ENGINE = MyISAM, PARTITION p2017_05 VALUES LESS THAN (1496275200) ENGINE = MyISAM, PARTITION p2017_06 VALUES LESS THAN (1498867200) ENGINE = MyISAM, PARTITION p2017_07 VALUES LESS THAN (1501545600) ENGINE = MyISAM, PARTITION p2017_08 VALUES LESS THAN (1504224000) ENGINE = MyISAM, PARTITION p2017_09 VALUES LESS THAN (1506816000) ENGINE = MyISAM, PARTITION p2017_10 VALUES LESS THAN (1509494400) ENGINE = MyISAM, PARTITION p2017_11 VALUES LESS THAN (1512086400) ENGINE = MyISAM, PARTITION p2017_12 VALUES LESS THAN (1514764800) ENGINE = MyISAM, PARTITION p2018_01 VALUES LESS THAN (1517443200) ENGINE = MyISAM, PARTITION p2018_02 VALUES LESS THAN (1519862400) ENGINE = MyISAM, PARTITION p2018_03 VALUES LESS THAN (1522540800) ENGINE = MyISAM, PARTITION p2018_04 VALUES LESS THAN (1525132800) ENGINE = MyISAM, PARTITION p2018_05 VALUES LESS THAN (1527811200) ENGINE = MyISAM, PARTITION p2018_06 VALUES LESS THAN (1530403200) ENGINE = MyISAM, PARTITION p2018_07 VALUES LESS THAN (1533081600) ENGINE = MyISAM, PARTITION p2018_08 VALUES LESS THAN (1535760000) ENGINE = MyISAM, PARTITION p2018_09 VALUES LESS THAN (1538352000) ENGINE = MyISAM, PARTITION p2018_10 VALUES LESS THAN (1541030400) ENGINE = MyISAM, PARTITION p2018_11 VALUES LESS THAN (1543622400) ENGINE = MyISAM, PARTITION p2018_12 VALUES LESS THAN (1546300800) ENGINE = MyISAM, PARTITION p2019_01 VALUES LESS THAN (1548979200) ENGINE = MyISAM, PARTITION p2019_02 VALUES LESS THAN (1551398400) ENGINE = MyISAM, PARTITION p2019_03 VALUES LESS THAN (1554076800) ENGINE = MyISAM, PARTITION p2019_04 VALUES LESS THAN (1556668800) ENGINE = MyISAM, PARTITION p2019_05 VALUES LESS THAN (1559347200) ENGINE = MyISAM, PARTITION p2019_06 VALUES LESS THAN (1561939200) ENGINE = MyISAM, PARTITION p2019_07 VALUES LESS THAN (1564617600) ENGINE = MyISAM, PARTITION p2019_08 VALUES LESS THAN (1567296000) ENGINE = MyISAM, PARTITION p2019_09 VALUES LESS THAN (1569888000) ENGINE = MyISAM, PARTITION p2019_10 VALUES LESS THAN (1572566400) ENGINE = MyISAM, PARTITION p2019_11 VALUES LESS THAN (1575158400) ENGINE = MyISAM, PARTITION p2019_12 VALUES LESS THAN (1577836800) ENGINE = MyISAM, PARTITION p2020_01 VALUES LESS THAN (1580515200) ENGINE = MyISAM, PARTITION p2020_02 VALUES LESS THAN (1583020800) ENGINE = MyISAM, PARTITION p2020_03 VALUES LESS THAN (1585699200) ENGINE = MyISAM, PARTITION p2020_04 VALUES LESS THAN (1588291200) ENGINE = MyISAM, PARTITION p2020_05 VALUES LESS THAN (1590969600) ENGINE = MyISAM, PARTITION p2020_06 VALUES LESS THAN (1593561600) ENGINE = MyISAM, PARTITION p2020_07 VALUES LESS THAN (1596240000) ENGINE = MyISAM, PARTITION p2020_08 VALUES LESS THAN (1598918400) ENGINE = MyISAM, PARTITION p2020_09 VALUES LESS THAN (1601510400) ENGINE = MyISAM, PARTITION p2020_10 VALUES LESS THAN (1604188800) ENGINE = MyISAM, PARTITION p2020_11 VALUES LESS THAN (1606780800) ENGINE = MyISAM, PARTITION p2020_12 VALUES LESS THAN (1609459200) ENGINE = MyISAM, PARTITION p2021_01 VALUES LESS THAN (1612137600) ENGINE = MyISAM, PARTITION p2021_02 VALUES LESS THAN (1614556800) ENGINE = MyISAM, PARTITION p2021_03 VALUES LESS THAN (1617235200) ENGINE = MyISAM, PARTITION p2021_04 VALUES LESS THAN (1619827200) ENGINE = MyISAM, PARTITION p2021_05 VALUES LESS THAN (1622505600) ENGINE = MyISAM, PARTITION p2021_06 VALUES LESS THAN (1625097600) ENGINE = MyISAM, PARTITION p2021_07 VALUES LESS THAN (1627776000) ENGINE = MyISAM, PARTITION p2021_08 VALUES LESS THAN (1630454400) ENGINE = MyISAM, PARTITION p2021_09 VALUES LESS THAN (1633046400) ENGINE = MyISAM, PARTITION p2021_10 VALUES LESS THAN (1635724800) ENGINE = MyISAM, PARTITION p2021_11 VALUES LESS THAN (1638316800) ENGINE = MyISAM, PARTITION p2021_12 VALUES LESS THAN (1640995200) ENGINE = MyISAM, PARTITION p2022_01 VALUES LESS THAN (1643673600) ENGINE = MyISAM, PARTITION p2022_02 VALUES LESS THAN (1646092800) ENGINE = MyISAM, PARTITION p2022_03 VALUES LESS THAN (1648771200) ENGINE = MyISAM, PARTITION p2022_04 VALUES LESS THAN (1651363200) ENGINE = MyISAM, PARTITION p2022_05 VALUES LESS THAN (1654041600) ENGINE = MyISAM, PARTITION p2022_06 VALUES LESS THAN (1656633600) ENGINE = MyISAM, PARTITION p2022_07 VALUES LESS THAN (1659312000) ENGINE = MyISAM, PARTITION p2022_08 VALUES LESS THAN (1661990400) ENGINE = MyISAM, PARTITION p2022_09 VALUES LESS THAN (1664582400) ENGINE = MyISAM, PARTITION p2022_10 VALUES LESS THAN (1667260800) ENGINE = MyISAM, PARTITION p2022_11 VALUES LESS THAN (1669852800) ENGINE = MyISAM, PARTITION p2022_12 VALUES LESS THAN (1672531200) ENGINE = MyISAM, PARTITION p2023_01 VALUES LESS THAN (1675209600) ENGINE = MyISAM, PARTITION p2023_02 VALUES LESS THAN (1677628800) ENGINE = MyISAM, PARTITION p2023_03 VALUES LESS THAN (1680307200) ENGINE = MyISAM, PARTITION p2023_04 VALUES LESS THAN (1682899200) ENGINE = MyISAM, PARTITION p2023_05 VALUES LESS THAN (1685577600) ENGINE = MyISAM, PARTITION p2023_06 VALUES LESS THAN (1688169600) ENGINE = MyISAM, PARTITION p2023_07 VALUES LESS THAN (1690848000) ENGINE = MyISAM, PARTITION p2023_08 VALUES LESS THAN (1693526400) ENGINE = MyISAM, PARTITION p2023_09 VALUES LESS THAN (1696118400) ENGINE = MyISAM, PARTITION p2023_10 VALUES LESS THAN (1698796800) ENGINE = MyISAM, PARTITION p2023_11 VALUES LESS THAN (1701388800) ENGINE = MyISAM, PARTITION p2023_12 VALUES LESS THAN (1704067200) ENGINE = MyISAM, PARTITION p2024_01 VALUES LESS THAN (1706745600) ENGINE = MyISAM, PARTITION p2024_02 VALUES LESS THAN (1709251200) ENGINE = MyISAM, PARTITION p2024_03 VALUES LESS THAN (1711929600) ENGINE = MyISAM, PARTITION p2024_04 VALUES LESS THAN (1714521600) ENGINE = MyISAM, PARTITION p2024_05 VALUES LESS THAN (1717200000) ENGINE = MyISAM, PARTITION p2024_06 VALUES LESS THAN (1719792000) ENGINE = MyISAM, PARTITION p2024_07 VALUES LESS THAN (1722470400) ENGINE = MyISAM, PARTITION p2024_08 VALUES LESS THAN (1725148800) ENGINE = MyISAM, PARTITION p2024_09 VALUES LESS THAN (1727740800) ENGINE = MyISAM, PARTITION p2024_10 VALUES LESS THAN (1730419200) ENGINE = MyISAM, PARTITION p2024_11 VALUES LESS THAN (1733011200) ENGINE = MyISAM, PARTITION p2024_12 VALUES LESS THAN (1735689600) ENGINE = MyISAM, PARTITION p2025_01 VALUES LESS THAN (1738368000) ENGINE = MyISAM, PARTITION p2025_02 VALUES LESS THAN (1740787200) ENGINE = MyISAM, PARTITION p2025_03 VALUES LESS THAN (1743465600) ENGINE = MyISAM, PARTITION p2025_04 VALUES LESS THAN (1746057600) ENGINE = MyISAM, PARTITION p2025_05 VALUES LESS THAN (1748736000) ENGINE = MyISAM, PARTITION p2025_06 VALUES LESS THAN (1751328000) ENGINE = MyISAM, PARTITION p2025_07 VALUES LESS THAN (1754006400) ENGINE = MyISAM, PARTITION p2025_08 VALUES LESS THAN (1756684800) ENGINE = MyISAM, PARTITION p2025_09 VALUES LESS THAN (1759276800) ENGINE = MyISAM, PARTITION p2025_10 VALUES LESS THAN (1761955200) ENGINE = MyISAM, PARTITION p2025_11 VALUES LESS THAN (1764547200) ENGINE = MyISAM, PARTITION p2025_12 VALUES LESS THAN (1767225600) ENGINE = MyISAM, PARTITION p2026_01 VALUES LESS THAN (1769904000) ENGINE = MyISAM, PARTITION p2026_02 VALUES LESS THAN (1772323200) ENGINE = MyISAM, PARTITION p2026_03 VALUES LESS THAN (1775001600) ENGINE = MyISAM, PARTITION p2026_04 VALUES LESS THAN (1777593600) ENGINE = MyISAM, PARTITION p2026_05 VALUES LESS THAN (1780272000) ENGINE = MyISAM, PARTITION p2026_06 VALUES LESS THAN (1782864000) ENGINE = MyISAM, PARTITION p2026_07 VALUES LESS THAN (1785542400) ENGINE = MyISAM, PARTITION p2026_08 VALUES LESS THAN (1788220800) ENGINE = MyISAM, PARTITION p2026_09 VALUES LESS THAN (1790812800) ENGINE = MyISAM, PARTITION p2026_10 VALUES LESS THAN (1793491200) ENGINE = MyISAM, PARTITION p2026_11 VALUES LESS THAN (1796083200) ENGINE = MyISAM, PARTITION p2026_12 VALUES LESS THAN (1798761600) ENGINE = MyISAM, PARTITION p2027_00 VALUES LESS THAN MAXVALUE ENGINE = MyISAM) */