Changelogs 29/07/2013

Changelogs :
- Add new database table for mentorship features
- Add Mentorship function was done
- Add Tanggal Investasi Awal for each FormTimE views
- Fixing EClass select query in UserProfile for FAC

Replace Files :
- controllers > TimMKE.php
- models > timmke_model.php
- views > FormTimE1,E2,E3,E4,E5,E6_views.php
- views > header.php

Adding New Files :
- views > PRJ_MTR.php

Mentorship Query :
create sequence mentorship_id_seq;
CREATE TABLE mentorship (
	idmentorship INT PRIMARY KEY not null default
nextval('mentorship_id_seq'),
	tgl_mentorship TIMESTAMP,
	pertemuan TEXT,
	status TEXT,
	nama_mentor TEXT,
	nik_mentor TEXT
);
alter sequence mentorship_id_seq owned by mentorship.idmentorship;

create sequence mentorship_attendance_id_seq;
create table mentorship_attendance (
	idattendance int primary key not null default
nextval('mentorship_attendance_id_seq'),
	nim_attendance text,
	idmentorship int
);
alter sequence mentorship_attendance_id_seq owned by
mentorship_attendance.idattendance;
ALTER TABLE ONLY mentorship_attendance
    ADD CONSTRAINT mentorship_att_id_mentorship FOREIGN KEY
(idmentorship) REFERENCES mentorship(idmentorship);

alter table mentorship add created_date TIMESTAMP;
alter table mentorship add status_edit_by text;
alter table mentorship add status_edit_date timestamp;
alter table mentorship add status_edit_note text;
alter table mentorship add created_by text;

alter table mentorship add id_tim int;

ALTER TABLE ONLY mentorship
    ADD CONSTRAINT mentorship_id_tim FOREIGN KEY (id_tim) REFERENCES
tim(id_tim);