alter table opl_user
add `nickname` varchar(50) CHARACTER SET utf8 DEFAULT NULL after lastname,
add `fullname` text CHARACTER SET utf8  after lastname,
change `modified` `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
add `issueBy` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add `biometricLnk` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
add  `digitalSign` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `workPhone` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `neighborhood` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `residency` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
add  `addrLine1_alt` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `addrLine2_alt` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `city_alt` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `zip_alt` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
add  `state_alt` char(2) CHARACTER SET utf8 DEFAULT NULL,
add  `country_alt` varchar(25) CHARACTER SET utf8 DEFAULT NULL,
add  `neighborhood_alt` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `residency_alt` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
add  `addrExpiry_alt` datetime DEFAULT NULL,
add  `program` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `studies` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `permanent` enum('true','false') CHARACTER SET utf8 DEFAULT 'true',
add  `fulltime` enum('true','false') CHARACTER SET utf8 DEFAULT 'true',
add  `identification` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
add  `pref_contact` varchar(200) CHARACTER SET utf8 DEFAULT NULL;

alter table opl_delUser
add `nickname` varchar(50) CHARACTER SET utf8 DEFAULT NULL after lastname,
add `fullname` text CHARACTER SET utf8  after lastname,
change `modified` `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
add `issueBy` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add `biometricLnk` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
add  `digitalSign` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `workPhone` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `neighborhood` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `residency` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
add  `addrLine1_alt` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `addrLine2_alt` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `city_alt` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `zip_alt` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
add  `state_alt` char(2) CHARACTER SET utf8 DEFAULT NULL,
add  `country_alt` varchar(25) CHARACTER SET utf8 DEFAULT NULL,
add  `neighborhood_alt` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
add  `residency_alt` varchar(250) CHARACTER SET utf8 DEFAULT NULL,
add  `addrExpiry_alt` datetime DEFAULT NULL,
add  `program` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `studies` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
add  `permanent` enum('true','false') CHARACTER SET utf8 DEFAULT 'true',
add  `fulltime` enum('true','false') CHARACTER SET utf8 DEFAULT 'true',
add  `identification` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
add  `pref_contact` varchar(200) CHARACTER SET utf8 DEFAULT NULL;

alter table opl_guardian
add `gcountry` varchar(25) DEFAULT NULL after gstate,
add  `role` varchar(50) DEFAULT NULL;

insert into opl_preference(var,val,valShow,opt,varType,description,hidden,gid,gOrder) values ('libraryType','k-12','K-12',NULL,'radio','Library type; K-12, college or public',0,1,7);

insert into opl_prefFormParam(var,listOrder,name,val) values
('libraryType',1,'k-12','k-12'),
('libraryType',2,'College/University','academy'),
('libraryType',3,'Public Library','public');

truncate table opl_subSystem;
insert into opl_subSystem(id,name) values
    (1,"System management"),
    (2,"Library"),
    (3,"Textbook"),
    (4,"Equipment");
alter table opl_odl 
    add responsible int(10) unsigned DEFAULT NULL after odl_id,
    add `note` text,
    change type type set('overdue','lost','damaged','claimNeverLoaned','claimReturned') DEFAULT 'overdue';

alter table opl_itemType 
    add `timeOnShelvingCart` int(5) unsigned DEFAULT '0';

