Changes between Version 2 and Version 3 of Partition

Timestamp:

06/15/22 00:54:13 (2 years ago)

Author:

krit

Comment:

--

Partition

@@ -13 +13 @@
           paymentDate datetime NOT NULL, 
           amount decimal(10,2) NOT NULL, 
-          PRIMARY KEY (customerNumber,paymentDate ) ) PARTITION BY RANGE( TO_DAYS(paymentDate) ) 
+          PRIMARY KEY (customerNumber,paymentDate ) ) 
+          ENGINE=InnoDB PARTITION BY RANGE( TO_DAYS(paymentDate) ) 
           ( PARTITION p2003 VALUES LESS THAN (TO_DAYS('2004-01-01')), 
             PARTITION p2004 VALUES LESS THAN (TO_DAYS('2005-01-01')),