   softwareid int(10) ,
 
   k varchar(250), 
-  v varchar(250), 
-  position int(10)  default 0,
+  v TEXT, 
+  position int(10)  default 0,
+  rolevisibility VARCHAR(250),
 
   lastupdts timestamp  default current_timestamp,
   lastupduser int(10)  default 0,

insert into userrole values (1, 1, 11, now(), 1);
insert into lab values (1, 1, 'default lab', 1, 1, now(), 1);
insert into labuser values (1, 1, 1, 6, now(), 1);

ALTER TABLE acct_quotemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE adaptormeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE adaptorsetmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE filemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE jobdraftmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE jobmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE jobsamplemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE labmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE labpendingmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE meta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE resourcecategorymeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE resourcemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE runmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE sampledraftmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE samplemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE samplesourcemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE samplesubtypemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE softwaremeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE statemeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE usermeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE userpendingmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE workflowmeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE workflowresourcecategorymeta ADD rolevisibility VARCHAR(250) AFTER position;
ALTER TABLE workflowsoftwaremeta ADD rolevisibility VARCHAR(250) AFTER position;

ALTER TABLE acct_quotemeta MODIFY v TEXT;
ALTER TABLE adaptormeta MODIFY v TEXT;
ALTER TABLE adaptorsetmeta MODIFY v TEXT;
ALTER TABLE filemeta MODIFY v TEXT;
ALTER TABLE jobdraftmeta MODIFY v TEXT;
ALTER TABLE jobmeta MODIFY v TEXT;
ALTER TABLE jobsamplemeta MODIFY v TEXT;
ALTER TABLE labmeta MODIFY v TEXT;
ALTER TABLE labpendingmeta MODIFY v TEXT;
ALTER TABLE meta MODIFY v TEXT;
ALTER TABLE resourcecategorymeta MODIFY v TEXT;
ALTER TABLE resourcemeta MODIFY v TEXT;
ALTER TABLE runmeta MODIFY v TEXT;
ALTER TABLE sampledraftmeta MODIFY v TEXT;
ALTER TABLE samplemeta MODIFY v TEXT;
ALTER TABLE samplesourcemeta MODIFY v TEXT;
ALTER TABLE samplesubtypemeta MODIFY v TEXT;
ALTER TABLE softwaremeta MODIFY v TEXT;
ALTER TABLE statemeta MODIFY v TEXT;
ALTER TABLE usermeta MODIFY v TEXT;
ALTER TABLE userpendingmeta MODIFY v TEXT;
ALTER TABLE workflowmeta MODIFY v TEXT;
ALTER TABLE workflowresourcecategorymeta MODIFY v TEXT;
ALTER TABLE workflowsoftwaremeta MODIFY v TEXT;
  stateid int(10) ,

  k varchar(250) ,
  v TEXT,
  position int(10)  default 0,
  rolevisibility VARCHAR(250),

  lastupdts timestamp  default current_timestamp,
  lastupduser int(10)  default 0,
