CREATE TABLE SALES
(
  PROD_ID        INTEGER                         NOT NULL,
  CUST_ID        INTEGER                         NOT NULL,
  TIME_ID        TIMESTAMP                           NOT NULL,
  CHANNEL_ID     INTEGER                         NOT NULL,
  PROMO_ID       INTEGER                         NOT NULL,
  QUANTITY_SOLD  FLOAT(10.2)                   NOT NULL,
  AMOUNT_SOLD    FLOAT(10.2)                   NOT NULL
)
PARTITION BY RANGE (UNIX_TIMESTAMP(TIME_ID))
(  
  PARTITION SALES_1995 VALUES LESS THAN (UNIX_TIMESTAMP('1996-01-01 00:00:00'))
         ,  
  PARTITION SALES_1996 VALUES LESS THAN (UNIX_TIMESTAMP('1997-01-01 00:00:00'))
         ,  
  PARTITION SALES_H1_1997 VALUES LESS THAN (UNIX_TIMESTAMP('1997-07-01 00:00:00'))
         ,  
  PARTITION SALES_H2_1997 VALUES LESS THAN (UNIX_TIMESTAMP('1998-01-01 00:00:00'))
         ,  
  PARTITION SALES_Q1_1998 VALUES LESS THAN (UNIX_TIMESTAMP('1998-04-01 00:00:00'))
         ,  
  PARTITION SALES_Q2_1998 VALUES LESS THAN (UNIX_TIMESTAMP('1998-07-01 00:00:00'))
         ,  
  PARTITION SALES_Q3_1998 VALUES LESS THAN (UNIX_TIMESTAMP('1998-10-01 00:00:00'))
         ,  
  PARTITION SALES_Q4_1998 VALUES LESS THAN (UNIX_TIMESTAMP('1999-01-01 00:00:00'))
         ,  
  PARTITION SALES_Q1_1999 VALUES LESS THAN (UNIX_TIMESTAMP('1999-04-01 00:00:00'))
         ,  
  PARTITION SALES_Q2_1999 VALUES LESS THAN (UNIX_TIMESTAMP('1999-07-01 00:00:00'))
         ,  
  PARTITION SALES_Q3_1999 VALUES LESS THAN (UNIX_TIMESTAMP('1999-10-01 00:00:00'))
         ,  
  PARTITION SALES_Q4_1999 VALUES LESS THAN (UNIX_TIMESTAMP('2000-01-01 00:00:00'))
         ,  
  PARTITION SALES_Q1_2000 VALUES LESS THAN (UNIX_TIMESTAMP('2000-04-01 00:00:00'))
         ,  
  PARTITION SALES_Q2_2000 VALUES LESS THAN (UNIX_TIMESTAMP('2000-07-01 00:00:00'))
         ,  
  PARTITION SALES_Q3_2000 VALUES LESS THAN (UNIX_TIMESTAMP('2000-10-01 00:00:00'))
         ,  
  PARTITION SALES_Q4_2000 VALUES LESS THAN (UNIX_TIMESTAMP('2001-01-01 00:00:00'))
         ,  
  PARTITION SALES_Q1_2001 VALUES LESS THAN (UNIX_TIMESTAMP('2001-04-01 00:00:00'))
         ,  
  PARTITION SALES_Q2_2001 VALUES LESS THAN (UNIX_TIMESTAMP('2001-07-01 00:00:00'))
         ,  
  PARTITION SALES_Q3_2001 VALUES LESS THAN (UNIX_TIMESTAMP('2001-10-01 00:00:00'))
         ,  
  PARTITION SALES_Q4_2001 VALUES LESS THAN (UNIX_TIMESTAMP('2002-01-01 00:00:00'))
         ,  
  PARTITION SALES_Q1_2002 VALUES LESS THAN (UNIX_TIMESTAMP('2002-04-01 00:00:00'))
         ,  
  PARTITION SALES_Q2_2002 VALUES LESS THAN (UNIX_TIMESTAMP('2002-07-01 00:00:00'))
         ,  
  PARTITION SALES_Q3_2002 VALUES LESS THAN (UNIX_TIMESTAMP('2002-10-01 00:00:00'))
         ,  
  PARTITION SALES_Q4_2002 VALUES LESS THAN (UNIX_TIMESTAMP('2003-01-01 00:00:00'))
         ,  
  PARTITION SALES_Q1_2003 VALUES LESS THAN (UNIX_TIMESTAMP('2003-04-01 00:00:00'))
         ,  
  PARTITION SALES_Q2_2003 VALUES LESS THAN (UNIX_TIMESTAMP('2003-07-01 00:00:00'))
         ,  
  PARTITION SALES_Q3_2003 VALUES LESS THAN (UNIX_TIMESTAMP('2003-10-01 00:00:00'))
         ,  
  PARTITION SALES_Q4_2003 VALUES LESS THAN (UNIX_TIMESTAMP('2004-01-01 00:00:00'))
      );