Help in Paritioning the Table
I have Two existing Tables in my Database
1] Lecture
2] LectureContent
Both tables to related to each other Lecturecontent is Txn table to Lecture
Desgin of these tables
Lecture
---------------------------------------------------
LectureId Int PrimaryKey Auto Incr
ClassroomId Int
Date DATETIME
ActualStartTime Time
ActualEndTime Time
.........
Unqiue Key ON
(LectureId, ClassroomId, Date, ActualStartTime, ActualEndTime)
LectureContent
-----------------------------------------
LectureConentId Int PrimaryKey Auto Incr
LectureId Int
ChapterId Int
.........
Now i am trying the to create Partition on this two tables
LTER TABLE Lecture PARTITION BY RANGE(LectureId)(
PARTITION p0 VALUES LESS THAN(25000),
PARTITION p1 VALUES LESS THAN(50000),
PARTITION p2 VALUES LESS THAN(75000),
PARTITION p3 VALUES LESS THAN(100000),
PARTITION p4 VALUES LESS THAN(125000),
PARTITION p5 VALUES LESS THAN(150000),
PARTITION p6 VALUES LESS THAN(175000),
PARTITION p7 VALUES LESS THAN(200000),
PARTITION p8 VALUES LESS THAN(225000));
ALTER TABLE LectureContent PARTITION BY RANGE(LectureId)(
PARTITION p0 VALUES LESS THAN(25000),
PARTITION p1 VALUES LESS THAN(50000),
PARTITION p2 VALUES LESS THAN(75000),
PARTITION p3 VALUES LESS THAN(100000),
PARTITION p4 VALUES LESS THAN(125000),
PARTITION p5 VALUES LESS THAN(150000),
PARTITION p6 VALUES LESS THAN(175000),
PARTITION p7 VALUES LESS THAN(200000),
PARTITION p8 VALUES LESS THAN(225000),
PARTITION p9 VALUES LESS THAN(250000));
But in both case i am getting the errors
Please help?