ALTER TABLE opl_user
ADD permissions text collate utf8_unicode_ci after permission;

ALTER TABLE opl_menuItem
ADD permissions varchar(255) default '' after permission;

ALTER TABLE opl_category
ADD  cattype varchar(30) collate utf8_unicode_ci NOT NULL AFTER catid, 
ADD  required enum('0','1') collate utf8_unicode_ci NOT NULL default '0',
ADD  defaultPerm text collate utf8_unicode_ci;

ALTER TABLE tb_loan
ADD  teacherName varchar(255) default NULL,
ADD  courseName varchar(255) default NULL;


ALTER TABLE tb_items 
CHANGE price price varchar(50) default NULL;

insert into eq_fieldDataType set id=6,dataType='GradeLevel';

