CREATE TABLE members (
    firstname VARCHAR(25) NOT NULL,
    lastname VARCHAR(25) NOT NULL,
    username VARCHAR(16) NOT NULL,
    email VARCHAR(35),
    joined DATE NOT NULL
)
PARTITION BY RANGE COLUMNS(joined) (
    PARTITION p0 VALUES LESS THAN ('1960-01-01'),
    PARTITION p1 VALUES LESS THAN ('1970-01-01'),
    PARTITION p2 VALUES LESS THAN ('1980-01-01'),
    PARTITION p3 VALUES LESS THAN ('1990-01-01'),
    PARTITION p4 VALUES LESS THAN MAXVALUE
);

CREATE TABLE sens.tags (
ID bigint(20) UNSIGNED ZEROFILL NOT NULL,
date_set datetime(3) DEFAULT NULL,
iv int(11) DEFAULT NULL,
PRIMARY KEY (ID)
)
PARTITION BY RANGE COLUMNS(date_set) (
    PARTITION p0 VALUES LESS THAN ('2016-08-27'),
    PARTITION p1 VALUES LESS THAN ('2016-09-01'),
    PARTITION p2 VALUES LESS THAN MAXVALUE
);