
-- Inserted at 2008-09-09T11:19:45.920+01:00

ALTER TABLE ASSIDUOUSNESS_RECORD_MONTH_INDEX CHANGE COLUMN `YEAR_MONTH` `PARTIAL_YEAR_MONTH` VARCHAR(50) NOT NULL;


create table ASSIDUOUSNESS_RECORD_ASSIDUOUSNESS_RECORD_MONTH_INDEX (KEY_ASSIDUOUSNESS_RECORD int(11) not null, KEY_ASSIDUOUSNESS_RECORD_MONTH_INDEX int(11) not null,  primary key (KEY_ASSIDUOUSNESS_RECORD, KEY_ASSIDUOUSNESS_RECORD_MONTH_INDEX), key(KEY_ASSIDUOUSNESS_RECORD), key(KEY_ASSIDUOUSNESS_RECORD_MONTH_INDEX)) type=InnoDB;

insert into ASSIDUOUSNESS_RECORD_ASSIDUOUSNESS_RECORD_MONTH_INDEX
select ASSIDUOUSNESS_RECORD.ID_INTERNAL, KEY_ASSIDUOUSNESS_RECORD_MONTH_INDEX
from ASSIDUOUSNESS_RECORD ;

