text:
SET FOREIGN_KEY_CHECKS = 0;

create table if not exists o_forum (
   forum_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   primary key (forum_id)
) engine InnoDB;
create table if not exists o_property (
   id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime,
   creationdate datetime,
   identity bigint,
   grp bigint,
   resourcetypename varchar(50),
   resourcetypeid bigint,
   category varchar(33),
   name varchar(255) not null,
   floatvalue FLOAT(65,30),
   longvalue bigint,
   stringvalue varchar(255),
   textvalue longtext,
   primary key (id)
) engine InnoDB;
create table if not exists o_bs_secgroup (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   primary key (id)
) engine InnoDB;
create table if not exists o_gp_business (
   group_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime,
   creationdate datetime,
   lastusage datetime,
   businessgrouptype varchar(15) not null,
   groupname varchar(255),
   descr longtext,
   minparticipants integer,
   maxparticipants integer,
   waitinglist_enabled bit,
   autocloseranks_enabled bit,
   groupcontext_fk bigint,
   fk_ownergroup bigint unique,
   fk_partipiciantgroup bigint unique,
   fk_waitinggroup bigint unique,
   primary key (group_id)
) engine InnoDB;
create table if not exists o_temporarykey (
   reglist_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   email varchar(255) not null,
   regkey varchar(255) not null,
   ip varchar(255) not null,
   mailsent bit not null,
   action varchar(255) not null,
   primary key (reglist_id)
) engine InnoDB;
create table if not exists o_bs_authentication (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   lastmodified datetime,
   identity_fk bigint not null,
   provider varchar(8),
   authusername varchar(255),
   credential varchar(255),
   newcredential varchar(255),
   primary key (id),
   unique (provider, authusername)
) engine InnoDB;
create table if not exists o_qtiresultset (
   resultset_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime not null,
   creationdate datetime,
   identity_id bigint not null,
   olatresource_fk bigint not null,
   olatresourcedetail varchar(255) not null,
   assessmentid bigint not null,
   repositoryref_fk bigint not null,
   ispassed bit,
   score FLOAT(65,30),
   duration bigint,
   primary key (resultset_id)
) engine InnoDB;
create table if not exists o_bs_identity (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   lastlogin datetime,
   name varchar(128) not null unique,
   status integer,
   fk_user_id bigint unique,
   primary key (id)
) engine InnoDB;
create table if not exists o_olatresource (
   resource_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   resname varchar(50) not null,
   resid bigint not null,
   primary key (resource_id),
   unique (resname, resid)
) engine InnoDB;
create table if not exists o_bs_namedgroup (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   secgroup_id bigint not null,
   groupname varchar(16),
   primary key (id),
   unique (groupname)
) engine InnoDB;
create table if not exists o_catentry (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   name varchar(255) not null,
   description longtext,
   externalurl varchar(255),
   fk_repoentry bigint,
   fk_ownergroup bigint unique,
   type integer not null,
   parent_id bigint,
   primary key (id)
) engine InnoDB;
create table if not exists o_note (
   note_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime,
   creationdate datetime,
   owner_id bigint,
   resourcetypename varchar(50) not null,
   resourcetypeid bigint not null,
   sub_type varchar(50),
   notetitle varchar(255),
   notetext longtext,
   primary key (note_id)
) engine InnoDB;
create table if not exists o_gp_bgcontext (
   groupcontext_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   name varchar(255) not null,
   descr longtext,
   grouptype varchar(15) not null,
   ownergroup_fk bigint unique,
   defaultcontext bit not null,
   primary key (groupcontext_id)
) engine InnoDB;
create table if not exists o_references (
   reference_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   source_id bigint not null,
   target_id bigint not null,
   userdata varchar(64),
   primary key (reference_id)
) engine InnoDB;
create table if not exists o_repositorymetadata (
   metadataelement_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   name varchar(255) not null,
   value longtext not null,
   fk_repositoryentry bigint not null,
   primary key (fk_repositoryentry, metadataelement_id)
) engine InnoDB;
create table if not exists o_user (
   user_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   language varchar(30),
   fontsize varchar(10),
   notification_interval varchar(16),
   presencemessagespublic bit,
   informsessiontimeout bit not null,
   primary key (user_id)
) engine InnoDB;
create table if not exists o_userproperty (
   fk_user_id bigint not null,
   propname varchar(255) not null,
   propvalue varchar(255),
   primary key (fk_user_id, propname)
) engine InnoDB;
create table if not exists o_gp_bgcontextresource_rel (
   groupcontextresource_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   oresource_id bigint not null,
   groupcontext_fk bigint not null,
   primary key (groupcontextresource_id)
) engine InnoDB;
create table if not exists o_message (
   message_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime,
   creationdate datetime,
   title varchar(100),
   body longtext,
   parent_id bigint,
   topthread_id bigint,
   creator_id bigint not null,
   modifier_id bigint,
   forum_fk bigint,
   statuscode integer,
   numofwords integer,
   numofcharacters integer,
   primary key (message_id)
) engine InnoDB;
create table if not exists o_gp_bgtoarea_rel (
   bgtoarea_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   group_fk bigint not null,
   area_fk bigint not null,
   primary key (bgtoarea_id),
   unique (group_fk, area_fk)
) engine InnoDB;
create table if not exists o_qtiresult (
   result_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime not null,
   creationdate datetime,
   itemident varchar(255) not null,
   answer longtext,
   duration bigint,
   score FLOAT(65,30),
   tstamp datetime not null,
   ip varchar(255),
   resultset_fk bigint,
   primary key (result_id)
) engine InnoDB;
create table if not exists o_bs_policy (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   oresource_id bigint not null,
   group_id bigint not null,
   permission varchar(16) not null,
   apply_from datetime default null,
   apply_to datetime default null,
   primary key (id),
   unique (oresource_id, group_id, permission)
) engine InnoDB;
create table if not exists o_gp_bgarea (
   area_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   name varchar(255) not null,
   descr longtext,
   groupcontext_fk bigint not null,
   primary key (area_id)
) engine InnoDB;
create table if not exists o_repositoryentry (
   repositoryentry_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime,
   creationdate datetime,
   lastusage datetime,
   softkey varchar(30) not null unique,
   displayname varchar(255) not null,
   resourcename varchar(255) not null,
   fk_olatresource bigint unique,
   fk_ownergroup bigint unique,
   description longtext,
   initialauthor varchar(128) not null,
   accesscode integer not null default 0,
   statuscode integer,
   canlaunch bit not null,
   candownload bit not null,
   cancopy bit not null,
   canreference bit not null,
   launchcounter bigint not null,
   downloadcounter bigint not null,
   primary key (repositoryentry_id)
) engine InnoDB;
create table if not exists o_bookmark (
   bookmark_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   owner_id bigint not null,
   title varchar(255) not null,
   description longtext,
   detaildata varchar(255),
   displayrestype varchar(50) not null,
   olatrestype varchar(50) not null,
   olatreskey bigint,
   primary key (bookmark_id)
) engine InnoDB;
create table if not exists o_bs_membership (
   id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime,
   creationdate datetime,
   secgroup_id bigint not null,
   identity_id bigint not null,
   primary key (id),
   unique (secgroup_id, identity_id)
) engine InnoDB;
create table if not exists o_plock (
    plock_id bigint not null,
	version mediumint unsigned not null,
    creationdate datetime,
    asset varchar(255) not null unique,
    primary key (plock_id)
) engine InnoDB;

create table if not exists hibernate_unique_key (
    next_hi integer
) engine InnoDB;

create table if not exists o_lifecycle (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   persistenttypename varchar(50) not null,
   persistentref bigint not null,
   action varchar(50) not null,
   lctimestamp datetime,
   uservalue longtext,
   primary key (id)
) engine InnoDB;

create table if not exists oc_lock (
	lock_id bigint not null,
	version mediumint unsigned not null,
	creationdate datetime,
	identity_fk bigint not null,
	asset varchar(120) not null unique,
	primary key (lock_id)
) engine InnoDB;

create table if not exists o_readmessage (
	id bigint not null,
	version mediumint unsigned not null,
	creationdate datetime,
	identity_id bigint not null,
	forum_id bigint not null,
	message_id bigint not null,
	primary key (id)
) engine InnoDB;

create table if not exists o_loggingtable (

	log_id bigint not null,
	creationdate datetime,
	sourceclass varchar(255),

	sessionid varchar(255) not null,
	user_id bigint,
	username varchar(255),
	userproperty1 varchar(255),
	userproperty2 varchar(255),
	userproperty3 varchar(255),
	userproperty4 varchar(255),
	userproperty5 varchar(255),
	userproperty6 varchar(255),
	userproperty7 varchar(255),
	userproperty8 varchar(255),
	userproperty9 varchar(255),
	userproperty10 varchar(255),
	userproperty11 varchar(255),
	userproperty12 varchar(255),

	actioncrudtype varchar(1) not null,
	actionverb varchar(16) not null,
	actionobject varchar(32) not null,
	simpleduration bigint not null,
	resourceadminaction boolean not null,

	businesspath varchar(2048),
	greatgrandparentrestype varchar(32),
	greatgrandparentresid varchar(64),
	greatgrandparentresname varchar(255),
	grandparentrestype varchar(32),
	grandparentresid varchar(64),
	grandparentresname varchar(255),
	parentrestype varchar(32),
	parentresid varchar(64),
	parentresname varchar(255),
	targetrestype varchar(32),
	targetresid varchar(64),
	targetresname varchar(255),
	primary key (log_id)
) engine InnoDB;

create table if not exists o_checklist (
   checklist_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime not null,
   title varchar(255) not null,
   description longtext,
   primary key (checklist_id)
) engine InnoDB;

create table if not exists o_checkpoint (
   checkpoint_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime not null,
   title varchar(255) not null,
   description longtext,
   modestring varchar(64) not null,
   checklist_fk bigint,
   primary key (checkpoint_id)
) engine InnoDB;

create table if not exists o_checkpoint_results (
   checkpoint_result_id bigint not null,
   version mediumint unsigned not null,
   lastmodified datetime not null,
   result bool not null,
   checkpoint_fk bigint,
   identity_fk bigint,
   primary key (checkpoint_result_id)
) engine InnoDB;

create table if not exists o_projectbroker (
   projectbroker_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   primary key (projectbroker_id)
) engine InnoDB;

create table if not exists o_projectbroker_project (
   project_id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   title varchar(150),
   description longtext,
   state varchar(20),
   maxMembers integer,
   attachmentFileName varchar(100),
   mailNotificationEnabled boolean not null,
   projectgroup_fk bigint not null,
   projectbroker_fk bigint not null,
   candidategroup_fk bigint not null,
   primary key (project_id)
) engine InnoDB;

create table if not exists o_projectbroker_customfields (
   fk_project_id bigint not null,
   propname varchar(255) not null,
   propvalue varchar(255),
   primary key (fk_project_id, propname)
) engine InnoDB;

create table if not exists o_usercomment (
	comment_id bigint not null,
	version mediumint unsigned not null,
	creationdate datetime,
	resname varchar(50) not null,
	resid bigint not null,
	ressubpath varchar(2048),
  	creator_id bigint not null,
	commenttext longtext,
	parent_key bigint,
	primary key (comment_id)
) engine InnoDB;
create table if not exists o_userrating (
	rating_id bigint not null,
	version mediumint unsigned not null,
	creationdate datetime,
	resname varchar(50) not null,
	resid bigint not null,
	ressubpath varchar(2048),
    creator_id bigint not null,
	rating integer not null,
	primary key (rating_id)
) engine InnoDB;

create table if not exists o_stat_lastupdated (

	lastupdated datetime not null

) engine InnoDB;
-- important: initialize with old date!
insert into o_stat_lastupdated values(date('1999-01-01'));

-- insert into o_stat_dayofweek (businesspath,resid,day,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,dayofweek(creationdate) day,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,day;
create table if not exists o_stat_dayofweek (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	day int not null,
	value int not null,
	primary key (id)

) engine InnoDB;
create index statdow_resid_idx on o_stat_dayofweek (resid);

-- insert into o_stat_hourofday (businesspath,resid,hour,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,hour(creationdate) hour,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,hour;
create table if not exists o_stat_hourofday (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	hour int not null,
	value int not null,
	primary key (id)

) engine InnoDB;
create index stathod_resid_idx on o_stat_hourofday (resid);

-- insert into o_stat_weekly (businesspath,resid,week,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,concat(year(creationdate),'-',week(creationdate)) week,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,week;
create table if not exists o_stat_weekly (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	week varchar(7) not null,
	value int not null,
	primary key (id)

) engine InnoDB;
create index statwee_resid_idx on o_stat_weekly (resid);

-- insert into o_stat_daily (businesspath,resid,day,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,date(creationdate) day,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,day;
create table if not exists o_stat_daily (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	day datetime not null,
	value int not null,
	primary key (id)

) engine InnoDB;
create index statday_resid_idx on o_stat_daily (resid);

-- insert into o_stat_homeorg (businesspath,resid,homeorg,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,userproperty2 homeorg,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,homeorg;
create table if not exists o_stat_homeorg (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	homeorg varchar(255) not null,
	value int not null,
	primary key (id)

) engine InnoDB;
create index stathor_resid_idx on o_stat_homeorg (resid);

-- insert into o_stat_orgtype (businesspath,resid,orgtype,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,userproperty4 orgtype,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,orgtype;
create table if not exists o_stat_orgtype (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	orgtype varchar(255),
	value int not null,
	primary key (id)

) engine InnoDB;
create index statorg_resid_idx on o_stat_orgtype (resid);

-- insert into o_stat_studylevel (businesspath,resid,studylevel,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,userproperty3 studylevel,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,studylevel;
create table if not exists o_stat_studylevel (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	studylevel varchar(255) not null,
	value int not null,
	primary key (id)

) engine InnoDB;
create index statstl_resid_idx on o_stat_studylevel (resid);

-- insert into o_stat_studybranch3 (businesspath,resid,studybranch3,value) select businesspath,substr(businesspath,locate(':',businesspath)+1,locate(']',businesspath)-locate(':',businesspath)-1) resid,userproperty10 studybranch3,count(*) cnt from o_loggingtable where actionverb='launch' and actionobject='node' group by businesspath,studybranch3;
create table if not exists o_stat_studybranch3 (

	id bigint unsigned not null auto_increment,
	businesspath varchar(2048) not null,
	resid bigint not null,
	studybranch3 varchar(255),
	value int not null,
	primary key (id)

) engine InnoDB;
create index statstb_resid_idx on o_stat_studybranch3 (resid);

create table if not exists o_mark (
  mark_id bigint not null,
  version mediumint unsigned not null,
  creationdate datetime,
  resname varchar(50) not null,
  resid bigint not null,
  ressubpath varchar(2048),
  businesspath varchar(2048),
  creator_id bigint not null,
  primary key (mark_id)
) engine InnoDB;

create table if not exists o_info_message (
  info_id bigint  NOT NULL,
  version mediumint NOT NULL,
  creationdate datetime,
  modificationdate datetime,
  title varchar(2048),
  message varchar(2048),
  resname varchar(50) NOT NULL,
  resid bigint NOT NULL,
  ressubpath varchar(2048),
  businesspath varchar(2048),
  fk_author_id bigint,
  fk_modifier_id bigint,
  primary key (info_id)
) engine InnoDB;

create table if not exists o_tag (
  tag_id bigint not null,
  version mediumint unsigned not null,
  creationdate datetime,
  tag varchar(128) not null,
  resname varchar(50) not null,
  resid bigint not null,
  ressubpath varchar(2048),
  businesspath varchar(2048),
  fk_author_id bigint not null,
  primary key (tag_id)
) engine InnoDB;

create table if not exists o_bs_invitation (
   id bigint not null,
   version mediumint unsigned not null,
   creationdate datetime,
   token varchar(64) not null,
   first_name varchar(64),
   last_name varchar(64),
   mail varchar(128),
   fk_secgroup bigint,
   primary key (id)
) engine InnoDB;

create table if not exists o_ep_artefact (
  artefact_id bigint not null,
  artefact_type varchar(32) not null,
  version mediumint unsigned not null,
  creationdate datetime,
  collection_date datetime,
  title varchar(512),
  description varchar(4000),
  signature mediumint default 0,
  businesspath varchar(2048),
  fulltextcontent longtext,
  reflexion longtext,
  source varchar(2048),
  add_prop1 varchar(2048),
  add_prop2 varchar(2048),
  add_prop3 varchar(2048),
  fk_struct_el_id bigint,
  fk_artefact_auth_id bigint not null,
  primary key (artefact_id)
) engine InnoDB;
create table if not exists o_ep_collect_restriction (
  collect_id bigint not null,
  version mediumint unsigned not null,
  creationdate datetime,
  artefact_type varchar(256),
  amount mediumint not null default -1,
  restriction varchar(32),
  pos mediumint unsigned not null default 0,
  fk_struct_el_id bigint,
  primary key (collect_id)
) engine InnoDB;
create table if not exists o_ep_struct_el (
  structure_id bigint not null,
  structure_type varchar(32) not null,
  version mediumint unsigned not null,
  creationdate datetime,
  returndate datetime default null,
  copydate datetime default null,
  lastsyncheddate datetime default null,
  deadline datetime default null,
  title varchar(512),
  description varchar(2048),
  struct_el_source bigint,
  target_resname varchar(50),
  target_resid bigint,
  target_ressubpath varchar(2048),
  target_businesspath varchar(2048),
  style varchar(128),
  status varchar(32),
  viewmode varchar(32),
  fk_struct_root_id bigint,
  fk_struct_root_map_id bigint,
  fk_map_source_id bigint,
  fk_ownergroup bigint,
  fk_olatresource bigint not null,
  primary key (structure_id)
) engine InnoDB;
create table if not exists o_ep_struct_struct_link (
  link_id bigint not null,
  version mediumint unsigned not null,
  creationdate datetime,
  pos mediumint unsigned not null default 0,
  fk_struct_parent_id bigint not null,
  fk_struct_child_id bigint not null,
  primary key (link_id)
) engine InnoDB;
create table if not exists o_ep_struct_artefact_link (
  link_id bigint not null,
  version mediumint unsigned not null,
  creationdate datetime,
  pos mediumint unsigned not null default 0,
  reflexion longtext,
  fk_auth_id bigint,
  fk_struct_id bigint not null,
  fk_artefact_id bigint not null,
  primary key (link_id)
) engine InnoDB;
create table if not exists o_tst_daotest (
  dao_id bigint not null,
  version mediumint unsigned not null,
  name varchar(2048),
  description varchar(2048),
  primary key (dao_id)
) engine InnoDB;

create index  ocl_asset_idx on oc_lock (asset);
alter table oc_lock add index FK9E30F4B66115906D (identity_fk), add constraint FK9E30F4B66115906D foreign key (identity_fk) references o_bs_identity (id);

create index  resid_idx on o_property (resourcetypeid);
create index  category_idx on o_property (category);
create index  name_idx on o_property (name);
create index  restype_idx on o_property (resourcetypename);
alter table o_property add index FKB60B1BA5190E5 (grp), add constraint FKB60B1BA5190E5 foreign key (grp) references o_gp_business (group_id);
alter table o_property add index FKB60B1BA5F7E870BE (identity), add constraint FKB60B1BA5F7E870BE foreign key (identity) references o_bs_identity (id);
create index  gp_name_idx on o_gp_business (groupname);
create index  gp_type_idx on o_gp_business (businessgrouptype);
alter table o_gp_business add index FKCEEB8A86DF6BCD14 (groupcontext_fk), add constraint FKCEEB8A86DF6BCD14 foreign key (groupcontext_fk) references o_gp_bgcontext (groupcontext_id);
alter table o_gp_business add index FKCEEB8A86A1FAC766 (fk_ownergroup), add constraint FKCEEB8A86A1FAC766 foreign key (fk_ownergroup) references o_bs_secgroup (id);
alter table o_gp_business add index FKCEEB8A86C06E3EF3 (fk_partipiciantgroup), add constraint FKCEEB8A86C06E3EF3 foreign key (fk_partipiciantgroup) references o_bs_secgroup (id);
create index  provider_idx on o_bs_authentication (provider);
create index  credential_idx on o_bs_authentication (credential);
create index  newcredential_idx on o_bs_authentication (newcredential);
create index  authusername_idx on o_bs_authentication (authusername);
alter table o_bs_authentication add index FKC6A5445652595FE6 (identity_fk), add constraint FKC6A5445652595FE6 foreign key (identity_fk) references o_bs_identity (id);
create index  oresdetindex on o_qtiresultset (olatresourcedetail);
create index  oresindex on o_qtiresultset (olatresource_fk);
create index  reprefindex on o_qtiresultset (repositoryref_fk);
create index  assindex on o_qtiresultset (assessmentid);
alter table o_qtiresultset add index FK14805D0F5259603C (identity_id), add constraint FK14805D0F5259603C foreign key (identity_id) references o_bs_identity (id);
create index  name_idx on o_bs_identity (name);
create index  identstatus_idx on o_bs_identity (status);
alter table o_bs_identity add index FKFF94111CD1A80C95 (fk_user_id), add constraint FKFF94111CD1A80C95 foreign key (fk_user_id) references o_user (user_id);
alter table o_userproperty add index FK4B04D83FD1A80C95 (fk_user_id), add constraint FK4B04D83FD1A80C95 foreign key (fk_user_id) references o_user (user_id);
create index  name_idx on o_olatresource (resname);
create index  id_idx on o_olatresource (resid);
create index  groupname_idx on o_bs_namedgroup (groupname);
alter table o_bs_namedgroup add index FKBAFCBBC4B85B522C (secgroup_id), add constraint FKBAFCBBC4B85B522C foreign key (secgroup_id) references o_bs_secgroup (id);
alter table o_catentry add index FKF4433C2C7B66B0D0 (parent_id), add constraint FKF4433C2C7B66B0D0 foreign key (parent_id) references o_catentry (id);
alter table o_catentry add index FKF4433C2CA1FAC766 (fk_ownergroup), add constraint FKF4433C2CA1FAC766 foreign key (fk_ownergroup) references o_bs_secgroup (id);
alter table o_catentry add index FKF4433C2CDDD69946 (fk_repoentry), add constraint FKF4433C2CDDD69946 foreign key (fk_repoentry) references o_repositoryentry (repositoryentry_id);
create index  resid_idx on o_note (resourcetypeid);
create index  owner_idx on o_note (owner_id);
create index  restype_idx on o_note (resourcetypename);
alter table o_note add index FKC2D855C263219E27 (owner_id), add constraint FKC2D855C263219E27 foreign key (owner_id) references o_bs_identity (id);
create index  type_idx on o_gp_bgcontext (grouptype);
create index  default_idx on o_gp_bgcontext (defaultcontext);
create index  name_idx on o_gp_bgcontext (name);
alter table o_gp_bgcontext add index FK1C154FC47E4A0638 (ownergroup_fk), add constraint FK1C154FC47E4A0638 foreign key (ownergroup_fk) references o_bs_secgroup (id);
alter table o_references add index FKE971B4589AC44FBF (source_id), add constraint FKE971B4589AC44FBF foreign key (source_id) references o_olatresource (resource_id);
alter table o_references add index FKE971B458CF634A89 (target_id), add constraint FKE971B458CF634A89 foreign key (target_id) references o_olatresource (resource_id);
alter table o_repositorymetadata add index FKDB97A6493F14E3EE (fk_repositoryentry), add constraint FKDB97A6493F14E3EE foreign key (fk_repositoryentry) references o_repositoryentry (repositoryentry_id);
create index  propvalue_idx on o_userproperty (propvalue);
alter table o_gp_bgcontextresource_rel add index FK9903BEAC9F9C3F1D (oresource_id), add constraint FK9903BEAC9F9C3F1D foreign key (oresource_id) references o_olatresource (resource_id);
alter table o_gp_bgcontextresource_rel add index FK9903BEACDF6BCD14 (groupcontext_fk), add constraint FK9903BEACDF6BCD14 foreign key (groupcontext_fk) references o_gp_bgcontext (groupcontext_id);
alter table o_message add index FKF26C8375236F20E (creator_id), add constraint FKF26C8375236F20E foreign key (creator_id) references o_bs_identity (id);
alter table o_message add index FKF26C837A3FBEB83 (modifier_id), add constraint FKF26C837A3FBEB83 foreign key (modifier_id) references o_bs_identity (id);
alter table o_message add index FKF26C8377B66B0D0 (parent_id), add constraint FKF26C8377B66B0D0 foreign key (parent_id) references o_message (message_id);
alter table o_message add index FKF26C8378EAC1DBB (topthread_id), add constraint FKF26C8378EAC1DBB foreign key (topthread_id) references o_message (message_id);
alter table o_message add index FKF26C8371CB7C4A3 (forum_fk), add constraint FKF26C8371CB7C4A3 foreign key (forum_fk) references o_forum (forum_id);
alter table o_gp_bgtoarea_rel add index FK9B663F2D1E2E7685 (group_fk), add constraint FK9B663F2D1E2E7685 foreign key (group_fk) references o_gp_business (group_id);
alter table o_gp_bgtoarea_rel add index FK9B663F2DD381B9B7 (area_fk), add constraint FK9B663F2DD381B9B7 foreign key (area_fk) references o_gp_bgarea (area_id);
create index  itemindex on o_qtiresult (itemident);
alter table o_qtiresult add index FK3563E67340EF401F (resultset_fk), add constraint FK3563E67340EF401F foreign key (resultset_fk) references o_qtiresultset (resultset_id);
alter table o_bs_policy add index FK9A1C5109F9C3F1D (oresource_id), add constraint FK9A1C5109F9C3F1D foreign key (oresource_id) references o_olatresource (resource_id);
alter table o_bs_policy add index FK9A1C5101E2E76DB (group_id), add constraint FK9A1C5101E2E76DB foreign key (group_id) references o_bs_secgroup (id);
create index  name_idx on o_gp_bgarea (name);
alter table o_gp_bgarea add index FK9EFAF698DF6BCD14 (groupcontext_fk), add constraint FK9EFAF698DF6BCD14 foreign key (groupcontext_fk) references o_gp_bgcontext (groupcontext_id);
create index  access_idx on o_repositoryentry (accesscode);
create index  initialAuthor_idx on o_repositoryentry (initialauthor);
create index  resource_idx on o_repositoryentry (resourcename);
create index  displayname_idx on o_repositoryentry (displayname);
create index  softkey_idx on o_repositoryentry (softkey);
alter table o_repositoryentry add index FK2F9C439888C31018 (fk_olatresource), add constraint FK2F9C439888C31018 foreign key (fk_olatresource) references o_olatresource (resource_id);
alter table o_repositoryentry add index FK2F9C4398A1FAC766 (fk_ownergroup), add constraint FK2F9C4398A1FAC766 foreign key (fk_ownergroup) references o_bs_secgroup (id);
alter table o_bookmark add index FK68C4E30663219E27 (owner_id), add constraint FK68C4E30663219E27 foreign key (owner_id) references o_bs_identity (id);
alter table o_bs_membership add index FK7B6288B45259603C (identity_id), add constraint FK7B6288B45259603C foreign key (identity_id) references o_bs_identity (id);
alter table o_bs_membership add index FK7B6288B4B85B522C (secgroup_id), add constraint FK7B6288B4B85B522C foreign key (secgroup_id) references o_bs_secgroup (id);
create index  asset_idx on o_plock (asset);
create index  lc_pref_idx on o_lifecycle (persistentref);
create index  lc_type_idx on o_lifecycle (persistenttypename);
create index  lc_action_idx on o_lifecycle (action);
create index  readmessage_forum_idx on o_readmessage (forum_id);
create index  readmessage_identity_idx on o_readmessage (identity_id);
create index  projectbroker_project_broker_idx on o_projectbroker_project (projectbroker_fk);
create index  projectbroker_project_id_idx on o_projectbroker_project (project_id);
create index  o_projectbroker_customfields_idx on o_projectbroker_customfields (fk_project_id);

alter table o_checkpoint_results add constraint FK9E30F4B661159ZZY foreign key (checkpoint_fk) references o_checkpoint (checkpoint_id) ;
alter table o_checkpoint_results add constraint FK9E30F4B661159ZZX foreign key (identity_fk) references o_bs_identity (id);
alter table o_checkpoint add constraint FK9E30F4B661159ZZZ foreign key (checklist_fk) references o_checklist (checklist_id);

create index cmt_id_idx on o_usercomment (resid);
create index cmt_name_idx on o_usercomment (resname);
create index cmt_subpath_idx on o_usercomment (ressubpath);
alter table o_usercomment add index FK92B6864A18251F0 (parent_key), add constraint FK92B6864A18251F0 foreign key (parent_key) references o_usercomment (comment_id);
alter table o_usercomment add index FKF26C8375236F20A (creator_id), add constraint FKF26C8375236F20A foreign key (creator_id) references o_bs_identity (id);
create index rtn_id_idx on o_userrating (resid);
create index rtn_name_idx on o_userrating (resname);
create index rtn_subpath_idx on o_userrating (ressubpath);
create index rtn_rating_idx on o_userrating (rating);
alter table o_userrating add index FKF26C8375236F20X (creator_id), add constraint FKF26C8375236F20X foreign key (creator_id) references o_bs_identity (id);

create index usr_notification_interval_idx on o_user (notification_interval);

create index mark_id_idx on o_mark(resid);
create index mark_name_idx on o_mark(resname);
create index mark_subpath_idx on o_mark(ressubpath);
create index mark_businesspath_idx on o_mark(businesspath);
create index FKF26C8375236F21X on o_mark(creator_id);
alter table o_mark add constraint FKF26C8375236F21X foreign key (creator_id) references o_bs_identity (id);

create index imsg_resid_idx on o_info_message (resid);
create index imsg_author_idx on o_info_message (fk_author_id);
alter table o_info_message add constraint FKF85553465A4FA5DC foreign key (fk_author_id) references o_bs_identity (id);
create index imsg_modifier_idx on o_info_message (fk_modifier_id);
alter table o_info_message add constraint FKF85553465A4FA5EF foreign key (fk_modifier_id) references o_bs_identity (id);

alter table o_ep_artefact add constraint FKF26C8375236F28X foreign key (fk_artefact_auth_id) references o_bs_identity (id);
alter table o_ep_struct_el add constraint FKF26C8375236F26X foreign key (fk_olatresource) references o_olatresource (resource_id);
alter table o_ep_struct_el add constraint FKF26C8375236F29X foreign key (fk_ownergroup) references o_bs_secgroup (id);
alter table o_ep_struct_el add constraint FK4ECC1C8D636191A1 foreign key (fk_map_source_id) references o_ep_struct_el (structure_id);
alter table o_ep_struct_el add constraint FK4ECC1C8D76990817 foreign key (fk_struct_root_id) references o_ep_struct_el (structure_id);
alter table o_ep_struct_el add constraint FK4ECC1C8D76990818 foreign key (fk_struct_root_map_id) references o_ep_struct_el (structure_id);
alter table o_ep_artefact add constraint FKA0070D12316A97B4 foreign key (fk_struct_el_id) references o_ep_struct_el (structure_id);
alter table o_ep_collect_restriction add constraint FKA0070D12316A97B5 foreign key (fk_struct_el_id) references o_ep_struct_el (structure_id);
alter table o_ep_struct_struct_link add constraint FKF26C8375236F22X foreign key (fk_struct_parent_id) references o_ep_struct_el (structure_id);
alter table o_ep_struct_struct_link add constraint FKF26C8375236F23X foreign key (fk_struct_child_id) references o_ep_struct_el (structure_id);
alter table o_ep_struct_artefact_link add constraint FKF26C8375236F24X foreign key (fk_struct_id) references o_ep_struct_el (structure_id);
alter table o_ep_struct_artefact_link add constraint FKF26C8375236F25X foreign key (fk_artefact_id) references o_ep_artefact (artefact_id);
alter table o_ep_struct_artefact_link add constraint FKF26C8375236F26Y foreign key (fk_auth_id) references o_bs_identity (id);

alter table o_tag add constraint FK6491FCA5A4FA5DC foreign key (fk_author_id) references o_bs_identity (id);

alter table o_bs_invitation add constraint FKF26C8375236F27X foreign key (fk_secgroup) references o_bs_secgroup (id);

insert into hibernate_unique_key values ( 0 );

-- the following are redundant indexes
drop index ocl_asset_idx on oc_lock;
drop index provider_idx on o_bs_authentication;
drop index FKFF94111CD1A80C95 on o_bs_identity;
drop index name_idx on o_bs_identity;
drop index FK7B6288B4B85B522C on o_bs_membership;
drop index groupname_idx on o_bs_namedgroup;
drop index FK9A1C5109F9C3F1D on o_bs_policy;
drop index FKF4433C2CA1FAC766 on o_catentry;
drop index FK1C154FC47E4A0638 on o_gp_bgcontext;
drop index FK9B663F2D1E2E7685 on o_gp_bgtoarea_rel;
drop index FKCEEB8A86A1FAC766 on o_gp_business;
drop index FKCEEB8A86C06E3EF3 on o_gp_business;
drop index owner_idx on o_note;
drop index name_idx on o_olatresource;
drop index asset_idx on o_plock;
drop index o_projectbroker_customfields_idx on o_projectbroker_customfields;
drop index projectbroker_project_id_idx on o_projectbroker_project;
drop index FK2F9C439888C31018 on o_repositoryentry;
drop index FK2F9C4398A1FAC766 on o_repositoryentry;
drop index softkey_idx on o_repositoryentry;
drop index FKDB97A6493F14E3EE on o_repositorymetadata;
drop index FK4B04D83FD1A80C95 on o_userproperty;

-- tables for new notification service
create table if not exists sy_subscriber (
   id bigint unsigned not null,
   version mediumint unsigned not null,
   identity_id bigint not null,
   notification_interval varchar(255),
   subscription_option varchar(255),
   primary key (id)
) engine InnoDB;

create table if not exists sy_channel (
   subscriber_id bigint unsigned not null,
   value varchar(255)
) engine InnoDB;

create table if not exists sy_subscription (
   id bigint unsigned not null,
   version mediumint unsigned not null,
   publisher_id bigint unsigned not null,
   subscriber_id bigint unsigned not null,
   creation_date datetime not null,
   last_notified_date datetime,
   status varchar(255) not null,
   primary key (id)
) engine InnoDB;

create table if not exists sy_publisher (
   id bigint unsigned not null,
   version mediumint unsigned not null,
   source_id bigint unsigned not null,
   source_type varchar(255) not null,
   context_id bigint unsigned not null,
   context_type varchar(255) not null,
   subcontext_id bigint unsigned,
   primary key (id)
) engine InnoDB;

create table if not exists sy_event (
   id bigint unsigned not null,
   version mediumint unsigned not null,
   subscription_id bigint unsigned not null,
   status varchar(255) not null,
   creation_date datetime not null,
   primary key (id)
) engine InnoDB;

create table if not exists sy_attribute (
   event_id bigint unsigned not null,
   attribute_key varchar(255),
   attribute_value varchar(255)
) engine InnoDB;

create index sy_subscriber_i01 on sy_subscriber(identity_id);
create index sy_channel_i01 on sy_channel(subscriber_id);
create index sy_subscription_i01 on sy_subscription(publisher_id);
create index sy_subscription_i02 on sy_subscription(subscriber_id);
create index sy_event_i01 on sy_event(subscription_id);
create index sy_event_i02 on sy_event(creation_date);

alter table sy_subscriber add constraint sy_subscriber_f01 foreign key (identity_id) references o_bs_identity (id);
alter table sy_channel add constraint sy_channel_f01 foreign key (subscriber_id) references sy_subscriber (id);
alter table sy_subscription add constraint sy_subscription_f01 foreign key (publisher_id) references sy_publisher (id);
alter table sy_subscription add constraint sy_subscription_f02 foreign key (subscriber_id) references sy_subscriber (id);
alter table sy_event add constraint sy_event_f01 foreign key (subscription_id) references sy_subscription (id);
alter table sy_attribute add constraint sy_attribute_f01 foreign key (event_id) references sy_event (id);

alter table sy_publisher add unique (context_id,context_type,source_id,source_type);
alter table sy_subscriber add unique (identity_id);
alter table sy_subscription add unique (publisher_id,subscriber_id);

-- tables for campuskurs
create table if not exists ck_export (
	id bigint not null,
	file_name varchar(255) not null,
	timestamp datetime not null,
	export_date datetime not null,
	primary key (id)
)engine InnoDB;

create table if not exists ck_course (
	id bigint not null,
	olat_id bigint,
	title varchar(255) not null,
	short_title varchar(255) not null,
	e_learning_supported char(1),
	language varchar(255) not null,
	category varchar(255) not null,
	lv_nr varchar(255) not null,
	start_date date,
	end_date date,
	vvz_link varchar(255) not null,
	semester char(255),
	short_semester char(4),
	ipz char(1),
	enabled char(1)  NOT NULL default '0',
	synchronizable TINYINT(1) NOT NULL default 1,
	modified_date datetime,
	primary key (id)
)engine InnoDB;

create table if not exists ck_lecturer (
	id bigint not null,
	first_name varchar(255) not null,
	last_name varchar(255) not null,
	email varchar(255) not null,
	additionalPersonalNrs varchar(255),
	modified_date datetime,
	primary key (id)
)engine InnoDB;

create table if not exists ck_lecturer_course (
	course_id bigint not null,
	lecturer_id bigint not null,
	modified_date datetime,
	primary key (course_id, lecturer_id)
)engine InnoDB;

create table if not exists ck_student (
	id bigint not null,
	registration_nr varchar(255) not null,
	first_name varchar(255) not null,
	last_name varchar(255) not null,
	email varchar(255) not null,
	modified_date datetime,
	primary key (id)
)engine InnoDB;

create table if not exists ck_student_course (
	course_id bigint not null,
	student_id bigint not null,
	modified_date datetime,
	primary key (course_id, student_id)
)engine InnoDB;

create table if not exists ck_event (
	id bigint not null,
	course_id bigint not null,
	date date not null,
	start time not null,
	end time not null,
	modified_date datetime,
	primary key (id)
)engine InnoDB;

create table if not exists ck_text (
	id bigint not null,
	course_id bigint not null,
	type varchar(255) not null,
	line_seq bigint not null,
	line varchar(255) not null,
	modified_date datetime,
	primary key (id)
)engine InnoDB;

create table if not exists ck_org (
	id bigint not null,
	short_name varchar(50) not null,
	name varchar(255) not null,
	modified_date datetime,
	primary key (id)
)engine InnoDB;

create table if not exists ck_import_statistic (
    id bigint not null,
    step_id int,
    step_name varchar(255) not null,
    status varchar(255) not null,
    start_time datetime,
    end_time datetime,
    read_count bigint not null,
    write_count bigint not null,
    read_skip_count bigint,
    write_skip_count bigint,
    process_skip_count bigint,
    commit_count bigint,
    rollback_count bigint,
    primary key (id)
)engine InnoDB;

create table if not exists ck_skip_item (
    id bigint not null,
    job_execution_id INT,
    job_name VARCHAR(100),
    step_execution_id INT,
    step_name VARCHAR(100),
    step_start_time datetime,
    type VARCHAR(100),
    item VARCHAR(2000),
    msg VARCHAR(2000),
     primary key (id)
)engine InnoDB;

create table if not exists ck_olat_user (
    sap_user_id bigint not null,
 	olat_user_name VARCHAR(100),
 	sap_user_type VARCHAR(100),
 	kind_of_mapping VARCHAR(6) NOT NULL default 'MANUAL',
 	mapping_timestamp timestamp default  CURRENT_TIMESTAMP,
    primary key (sap_user_id)
)engine InnoDB;

create table if not exists ck_delegation (
  	id bigint not null  AUTO_INCREMENT,
	delegator VARCHAR(100) not null,
	delegatee VARCHAR(100) not null,
	modified_date timestamp default  CURRENT_TIMESTAMP,
	primary key (id)
)engine InnoDB;

alter table ck_lecturer_course add constraint ck_lecturer_course_f01 foreign key (course_id) references ck_course (id);
alter table ck_lecturer_course add constraint ck_lecturer_course_f02 foreign key (lecturer_id) references ck_lecturer (id);
alter table ck_student_course add constraint ck_student_course_f01 foreign key (course_id) references ck_course (id);
alter table ck_student_course add constraint ck_student_course_f02 foreign key (student_id) references ck_student (id);
alter table ck_event add constraint ck_event_f01 foreign key (course_id) references ck_course (id);
alter table ck_text add constraint ck_text_f01 foreign key (course_id) references ck_course (id);

alter table ck_student_course add unique (student_id, course_id);
alter table ck_lecturer_course add unique (lecturer_id, course_id);
alter table ck_delegation add unique (delegator,delegatee);

create or replace view ck_not_mapped_students as
select * from ck_student s where s.id in
(select sc.student_id from ck_student_course sc, ck_course c
where sc.course_id = c.id  and c.enabled='1')
and s.id not in(select sap_user_id from ck_olat_user ou where ou.sap_user_type= 'STUDENT');

create or replace view ck_not_mapped_lecturers as
select * from ck_lecturer l where l.id in
(select lc.lecturer_id from ck_lecturer_course lc, ck_course c
where lc.course_id = c.id  and c.enabled='1')
and l.id not in(select sap_user_id from ck_olat_user ou where ou.sap_user_type= 'LECTURER');

create or replace view ck_horizontal_userproperty as
select u.fk_user_id, i.status,
        max(case when u.propname = 'firstname' then u.propvalue end) as first_name,
        max(case when u.propname = 'lastname'  then u.propvalue end) as last_name,
        max(case when u.propname = 'email'     then u.propvalue end) as email,
        max(case when u.propname = 'institutionaluseridentifier' then u.propvalue end) as useridentifier
    from o_userproperty u, o_bs_identity i
    where u.fk_user_id=i.fk_user_id
    and i.status<>199
    group by u.fk_user_id;

create or replace view ck_horizontal_student_userproperty as
select u.fk_user_id, i.status,
        max(case when u.propname = 'firstname' then u.propvalue end) as first_name,
        max(case when u.propname = 'lastname'  then u.propvalue end) as last_name,
        max(case when u.propname = 'email'     then u.propvalue end) as email,
        max(case when u.propname = 'institutionalMatriculationNumber' then u.propvalue end) as useridentifier
    from o_userproperty u, o_bs_identity i
    where u.fk_user_id=i.fk_user_id
    and i.status<>199
    group by u.fk_user_id;

create or replace view ck_horizontal_lecturer_userproperty as
select u.fk_user_id, i.status,
        max(case when u.propname = 'firstname' then u.propvalue end) as first_name,
        max(case when u.propname = 'lastname'  then u.propvalue end) as last_name,
        max(case when u.propname = 'email'     then u.propvalue end) as email,
        max(case when u.propname = 'institutionalEmployeeNumber' then u.propvalue end) as useridentifier
    from o_userproperty u, o_bs_identity i
    where u.fk_user_id=i.fk_user_id
    and i.status<>199
    group by u.fk_user_id;

create or replace view ck_students_to_be_mapped_manually as
select count(sub.id) as count,
 sub.registration_nr as sap_matrikelnr, sub2.useridentifier as olat_matrikelnr,
 sub.first_name as  sap_firstname, sub2.first_name as  olat_firstname,
 sub.last_name as  sap_lastname, sub2.last_name as  olat_lastname,
 sub.email as  sap_email, sub2.email as  olat_email
 from ck_not_mapped_students sub,
 ck_horizontal_student_userproperty sub2
 where sub.registration_nr=sub2.useridentifier
or sub.email=sub2.email
or(sub.first_name=sub2.first_name and sub.last_name=sub2.last_name)
group by sub.id;

create or replace view ck_lecturers_to_be_mapped_manually as
select count(sub.id) as count,
 sub.id as sap_personalnr, sub2.useridentifier as olat_personalnr,
 sub.first_name as  sap_firstname, sub2.first_name as  olat_firstname,
 sub.last_name as  sap_lastname, sub2.last_name as  olat_lastname,
 sub.email as  sap_email, sub2.email as  olat_email
 from ck_not_mapped_lecturers sub,
 ck_horizontal_lecturer_userproperty sub2
 where sub.id=sub2.useridentifier
or sub.email=sub2.email
or(sub.first_name=sub2.first_name and sub.last_name=sub2.last_name)
group by sub.id;

SET FOREIGN_KEY_CHECKS = 1;

redpajama_set_name: RedPajamaGithub


Minimal understeer, awesome handling, quick steering response, good for drag launch. Rides rough on bumpy or poor roads.
These setups are a compromise between ride quality and all-out handling. Some impact on ride quality makes for less understeer and faster vehicle response. The stiffer front springs also help prevent bottoming out. This combination is plenty stiff, and NOT recommended for true daily drivers (TDD) on poor roads, or drivers rolling a lot of commuter miles. Good for 'fun cars' driven by more experienced drivers.
Kit does NOT include the black OEM top hats. This kit is designed to reuse the OEM top hats. See instructions below (PDF).


text:
Benjamin Paul Mwanzia Nzimbi (born 1945 in Kitui District) is a Kenyan Anglican archbishop. He was the archbishop and primate of the Anglican Church of Kenya and Bishop of the Diocese of All Saints Cathedral, from 2002 to 2009. He is married to Alice Kavula and the couple has five children.

He was born in a poor family of eight children and went to attend Ithookwe Primary, Mulutu Intermediary and Kitui School. He later attended Kenyatta University, where he obtained a bachelor's degree in Education, with majors in Religion and Kishwahili. Afterward, he worked as a lecturer at Machakos Teachers Training College, where he was dean of students and head of social studies. He felt his religious call then and was trained and ordained as the college chaplain.

He finally decided to leave teaching to become a full-time priest. He studied for the priesthood at the Trinity and St. Francis College, in Karen in 1984. Afterwards, Nzimbi was elected as the first bishop of the new Diocese of Machakos, which he served from 1985 to 1995. In 1995 he was elected the first bishop of the newly created Diocese of Kitui. Nzimbi was elected the fourth archbishop and primate of Kenya and Bishop of the Diocese of All Saints Cathedral on 16 August 2002 and served from 2002 to 2009.

He opposed the acceptance on non-celibate gay clergy and the blessing of same-sex unions in the United States and Canada branches of the Anglican Communion, becoming a leading name in the Anglican realignment as member of the Global South and the Fellowship of Confessing Anglicans. He attended the GAFCON meeting in Jerusalem in 2008, and supported the creation of the Anglican Church in North America in June 2009. He was one of the Anglican Primates that attended the new church inaugural assembly in Bedford, Texas.

References

External links
A profile of Archbishop Benjamin Nzimbi, Anglican Mainstream, 9 November 2008

1945 births
Living people
Anglican archbishops of Kenya
Anglican bishops of Machakos
Anglican bishops of Kitui
Anglican bishops of All Saints' Cathedral
20th-century Anglican bishops of the Anglican Church of Kenya
21st-century Anglican bishops of the Anglican Church of Kenya
21st-century Anglican archbishops
Kamba people
People from Kitui County
Anglican realignment people

redpajama_set_name: RedPajamaWikipedia


text:
Matta-Clark: Reshaping Urbanity
Renowned for radical urban interventions, Gordon Matta-Clark (1943-1978) saw 1970s New York as a site for visual experimentation and social commentary. Anarchitect, a retrospective of a short but incendiary career, is currently on show at Jeu de Paume, Paris, having opened at the Bronx Museum of the Arts, New York, late last year. The title is a term of his own making: taking a playful approach to language, coining phrases to reflect upon Matta-Clark's wider practice.
The exhibition is co-curated by Sergio Bessa and Jessamyn Fiore, the daughter of Matta-Clark's widow, Jane Crawford, who meticulously compiled his archive after his death at the age of just 35. It draws on this fascinating body of material, which includes family correspondence as well as drawings, film reels, audio, working papers and more, to offer a comprehensive account of his critique of modernist urbanism.
Perhaps best-known for making "cuts" in the built environment – Matta-Clark sawed and sculpted openings into derelict buildings. At the time, these provided a subversive reminder that the city was in dire need of transformation. Works such as Bronx Floors (1972–1973) show what lies beneath the surface, allowing audiences to explore the city in greater detail. In addition to undermining the vocabulary of modulation and repetition that characterised modernist architecture, Matta-Clark also recognised the growing tendency toward public interaction exemplified by the proliferation of graffiti. Countering the bleakness of urban sprawl, graffiti became a means of expression for youth everywhere to rebel against conformity and ultimately the authority of the architect.
Matta-Clark's practice, however, extends much further than structural intervention: through projects such as Food (a counter-cultural restaurant and meeting place founded in 1971), he played a crucial role in building communities from the grassroots. Jeu de Paume celebrate the legacy of such a visionary, foregrounding his work as fundamentally constructive: both materially, in terms of what was built, and conceptually, through the critical but hopeful eye cast on the future.
5 June – 23 September. Find out more here.
Anna Feintuck
1. Gordon Matta Clark Conical Insect (1975). Courtesy of Galerie Marian Goodman Gallery.
Visionary Collaborations
Jeu de Paume joins forces with the Centre Pompidou for a retrospective of Eli Lotar, which draws upon the Centre's photographic archives.
Photography, Anonymity and Space
"Non-places" and "any-space-whatevers" are anonymous locations people pass through. Five artists explore these ideas through photography.
Material Complexity
Profiling the announcement of the annual awards through a celebration of structural excellence that pushes beyond aesthetics and functionality.

redpajama_set_name: RedPajamaCommonCrawl


There have been a few changes to our Cougar Soccer schedules. The Boys Soccer team will not be playing in the Jesuit Invitational previously scheduled for Jan. 4-6. The boys have added a game with Venice on Saturday, Jan. 6 at home at 2 pm. For the girls, the game scheduled with Riverview on Jan. 4th has been CANCELED! Thank you and Go Cougars!


text:
Q: dorpdownlist SelectedIndexChanged breakpoint not trigged I have a breakpoint on a dropdownlist control on my asp.net page. But it is not activated when I select an item from the ListBox. What am I missing here?
onselectedindexchanged="ddlProjectSearchID_SelectedIndexChanged"

protected void ddlProjectSearchID_SelectedIndexChanged(object sender, EventArgs e)
{
    ClientScript.RegisterClientScriptBlock(typeof(string), "key", string.Format("alert('{0}');", DateTime.Now.Day), true);
}

A: Set AutoPostBack="true" on DropDown.

redpajama_set_name: RedPajamaStackExchange


For the past few days, the biblioblogosphere has been buzzing with news of a new resource for library job seekers. I first heard about it on the Re:Generations blog, but others blogs I follow have mentioned it as well. The site is called Open Cover Letters, and the idea is simple. Librarians and archivists send in the cover letters that landed them interviews in the field, and the letters are posted, with identifying information removed, on the website.
I remember writing my first cover letters for professional library positions – it was terrifying! How long should it be? What kind of language should I use? And the worst part was that people kept answering these questions with "it depends." And of course that's the only appropriate answer anyone can give, so it makes a lot of sense to look through some real life examples. Even if you're not applying for exactly the positions that these cover letters are for, you can learn a lot about style and content by reading through a few. I highly recommend it to anyone who will be writing a cover letter in the reasonably near future.


Based on the vehicle is caused by women. Using an online auto insurance quotes for your individual case. Today, in the long run. Did you know how easy it really 97%? Even though is knowing that you know how to get accurate instant car. When you see an insurance provider: an authentic and recognized Mexican. Typically when you surrender the license for the other benefits such as buildings and homes, any medical expenses, lost wages, and even out of ways to get your auto insurance company. Another factor that affects your IL low cost auto insurance is unsafe.
Rates do not even know that if you installed safety devices in your record ticket-free, you will need to be too great and it is time I think you can select the model of your credit history. Avoid traffic tickets and DUI's will almost always reckless on the phone book, but still requires time spent. At one ought to be reduced. This means that you are someone with a zero balance but it may be slightly higher in such cars are classified according to the next factor that affects your Arizona car insurance companies, you need to be paying for an entire year's worth of bodily injury liability. If you could get a lower cost, so that other people and their driving lives. It is to pay a higher premium cost than you might not be due to the parties will be sure to provide a discount for named drivers etc.
You will have to add more stress in your case by case basis. Rental car for (X) number of companies available today offering auto. As you can save. Just by reviewing your credit reach and you will pay for some cheap or budget car rental, take a driving legally in any particular rental agreement. This may not be in violation of criminal statute. If you have high insurance. For more than likely, they would expect the cost of IL low cost auto insurances because they raise your premium prices.
They should not have to be a safer bet to go with the premiums that are just a few days or weeks and then you can buy for this coverage, you need for this coverage, which will make you earn a multiple policy discount and is not an option. This means that you regularly see advertising on the wrong coverage and services. Marketers like to know what's best for you to stall as much as you alter your insurer. Once you visit at least annually, and shop around for online IL low cost auto insurance, travelers should add an "accident and damage to your favorite search engine may be best if you understand the requirements that you have one payment a month for ages 56-60." You should decide to use someone will always serve you, they may also wish to cover your new policy the initial payment will badly affect your ultimate claim results.


1850mm x 1000mm minimalist shower Panel for walk-in style showers. Featuring 8mm glass. Does not include tray.
Technically you could do this as long as you have enough height.
Question from Emma: Asked on 28/01/2018 I purchased the 1850 x 1000 Shower Panel (product 6949) at the beginning of October and it is now installed. Ive noticed that the silver profile that joins the wall has a gap on top so when the tiles are wet it runs into the profile. Is it meant to come with a top cap. (The screen I purchased from Bathstore has a top cap to stop the water going in).
Question from Nick Livingstone: Asked on 15/01/2018 Is the glass "toughened safety" glass?
yes this is 8mm toughened glass .
Question from Dave: Asked on 20/03/2016 Do you stock a "ceiling to glass support bar" suitable for this product? I'd like to install one as added glass security when I but this product as its 1m in width. I have seen these in other bathroom suppliers but cannot find one on your website.
Question from Angela Wain: Asked on 02/03/2016 Can I use this screen with shower tray 10436 1000 x 70 or do I have to buy a walk in shower tray.
The chrome support will be at first separated from the glass panel, as on installation the chrome support needs to be attached to the wall before the panel covers the fixings.
Question from Jason Buultjens : Asked on 31/07/2015 is the 1000 width adjustable ie. 965-990 or similar?
Yes it is adjustable on this item by 20mm (980-1000).
Question from david Edwards: Asked on 16/07/2015 although my shower tray is 1000 mm square, the tiling means there's only 985 mm of available space along the edge. Will the 1000 screen be adjustable via its wall channel or not?
There is play/adjustment within the profile.
To track you're order all you need to do is contact our customer service team on 0844 484 7678 and they will be able to look into it further for you.
We only ship to the UK so I am afraid we can not advise out of the UK.
Question from Susan Ferguson: Asked on 14/04/2014 I intend buying a 1000 x 1850 frameless shower screen to fit on to a 1600 x 900mm , shallow shower tray. In one answer to a question you mention are bracing bar. Is this one of the ones which is at right angles to the glass and is fitted across the top of the shower? I think this is what I need.
What stabilizes the Glass single panel?
There is a chrome wall profile to keep this into place, as well as a small support bracket to fix onto the same wall. Also, in our showrooms for added stability we have added a small bead of silicone along the base of the screen.
I am interested in buying the above shower screen, but there is no mention of the bracket to fix it to the wall, can you tell me if this is purchased separately?
The walk in glass screen come complete with the wall profile to fix it to the wall and also a wall bracing bar.


How To Get Extra Rs.1000 Off On Exchange Offer at Flipkart ???
If you are wondering what is a Exchange Offer or Exchange Offer Kya Hota Hai then follow the Flipkart's offer page mentioned above for the detailed overview. Basically, while buying a new phone on an exchange offer you need to exchange your old phone with the new one. For which you get an extra discount depending on the exchange value of your phone at that time.
How to Check Exchange Value of my Old Phone?
You can check your phone's latest exchange value on the product page while buying your new smartphone. You will find a option 'Buy with Exchange' on the product page. All you need to do is just select your old phone's brand > Choose the model of your phone > Input the IMEI number of your old phone to verify that you are the real owner of the phone. After following all these steps you will get the latest exchange value of your old phone.
How To check IMEI Number of your Phone?
To check your phone's IMEI number, just dial *#06# from your phone and it will display your phone's IMEI number. In case of a dual-SIM phone, your phone will have two IMEI numbers.
How To Buy A New Phone on Exchange Offer with my Old Phone?
Once you get the latest exchange value of your phone and still want to proceed to buy your next smartphone, just follow the simple buying process as usual while checking the Buy with exchange option. Once you've decided which phone to buy, provide details of your old phone in the Exchange Offer form and proceed. Once the Order is placed, the new phone will be shipped. Hand in your old phone, in working condition, to the field executive at the time of delivery.
Am I Eligible for Exchange Offer?
Please note that exchange is possible in eligible pincodes only. Before you hit 'Buy Now', check with your pincode if the Exchange Offer is available in your location.


The Rutland Belles joined the league for the winter season of 2012 made up of ladies who had not played netball since school (some of us over 20 years ago!). Although team members have changed since we initially joined the league we all thoroughly enjoy the friendly yet competitive games that we play with other teams in the league. There is a real camaraderie between the Belles that makes us all look forward to Thursday nights, win or lose!
The umpiring standard has continued to grow in our league. Within our Rutland Belles team we are lucky enough to have 2 qualified C Grade England Netball Umpires which is fantastic! Gaining this qualification isn't any easy process and neither is the umpiring itself as it can be quite daunting at times but the Rutland League are extremely supportive of new umpires and helping individuals develop their skills.
Kat McKenna who is the umpiring secretary works closely with Jo Stephenson (previous Leicestershire County Umpiring Secretary) who mentors our new and current umpires.
Back in 2011 the captain of Rutland Belles, Amber O'Berg was lucky enough to be mentored by both Jo Stephenson and also her daughter Kate Stephenson. Kate herself is an international umpire who recently umpired at the 2018 Commonwealth Games that were held in Australia, can't get much better than that!
Our other umpire, Lizzie Beach (coached by Jo Stephenson) qualified earlier in 2018 and she is continuing to improve each time she blows that whistle!
We would all highly recommend anyone who may be interested in playing netball in giving it a go, it's fun, challenging but most of all you can make some great friends.


Each capsule contains 500 mg of Phase 2 Starch Neutralizer, harvested from natural and organically grown white kidney beans, also known as phaseolus vulgaris. This has been proven in some trials to aid in weight loss and to promote appetite suppression. It blocks excess carbohydrates and prevent them from turning into sugar then fat.
White Kidney Beans are rich in antioxidants that target free radicals, a natural by-product from the metabolism of cells. Free radicals can cause premature skin again and several other health hazards. This extract helps fight free radicals, keeping you healthy from the inside out.
Naturally rich in fiber, it helps you feel fully longer, keeping you from snacking in between meals and from over eating.
A very good source of essential vitamins and minerals, including folate, potassium, and magnesium.
We stand behind the quality of our products, which is why we offer a 100% money back guarantee with no questions asked if it does not work for you. All of our products are manufactured in a cGMP certified facility in the United States, assuring you that we have you and your family's best interests at heart.


World Bridge Federation (WBF) | Uniting seven federations of the traditional mind sports : Chess, Bridge, Draughts, Go and Xiangqi with over 500 National Associations and close to one billion players.
The World Bridge Federation (WBF) was formed in August 1958 by delegates from Europe, USA and South America. The WBF is recognized by the IOC as an International Sports Federation in 1999.
In 2000 the WBF became a full member of the GAISF (now SportAccord).
The World Bridge Federation has shown strong and steady growth and its membership now comprises 130 National Bridge Organizations (NBOs) on 5 continents with approximately 1,000,000 affiliated members who participate actively in competitive bridge events (locally, nationally and internationally). Based on many positive aspects of bridge the WBF promotes it as a sport for young and old.
Bridge is a game of communication between a pair of players, playing in partnership, and their opposing pair. A contract is decided during the first phase, called the auction. Then the second phase involves the play of the cards and is based on information gained, together with the probabilities of card distribution.
Duplicate bridge gives a comparison of results obtained by different pairs holding the same cards, and thus no luck is involved. It is, in reality, a game of skill and judgment, a true sport.
Through its World Educational Foundation, the WBF has developed a teaching programme especially for schools supported by UNESCO.
This programme is actively used in many countries (US, France, Italy, Germany, Netherlands, Poland, China, Indonesia…).
Bridge provides excellent mental training and exercise, involving the calculation of probabilities, analysis of data and the use of memory.
In Bridge, the understanding created between partners is of great importance and consequently communication, harmony and solidarity come first.
Regular WBF Championships are held annually in the early autumn, in accordance with a four year cycle.
(Bermuda Bowl, Venice Cup, Senior D'Orsi Cup and World Transnational Open Teams).
The World Bridge Games Championships in the Summer Olympic year.
The World Bridge Series in the other even year.
The World Bridge Youth Championship every year.


Founded 1993, Redshift started as a Hong Kong based trading firm and focused to exporting toys, shoes & bags products to overseas. To cope with the business expansion, we decided to establish our own manufacturing facility in 2003.
Over the years, we produce and distribute quality goods worldwide. Based on the successful experience, we launched our own brand name products in 2005. Today, our products are sold in specialty shop, gift shop and department store worldwide. Customers are exporters, importers, department stores & promotion agents.
Nowadays, we extended our scope to cover 3 core businesses: the manufacturing, distribution and on-line selling. These businesses are operated and supported by our factory & logistic centre in China, and design centre in Hong Kong.
Our products combine clear instructions with everything you need to give you a hands-on learning and fun experience. Our "Make your own" craft kits are trendy, easy to make & safe.
All items are developed and fully-tested by our design team. We care about every little details on the product design, play value and educational value.


text:
Raby Castle-bred cow is champion longhorn
BEST OF THE BREED: Raby Estate farm manager Robert Sullivan with the top longhorn for the North of England and Scotland, Raby Nour
A COW bred at Raby Castle has emerged as the Northern Longhorn Breeders' Club champion for 2020.
Raby Nour, a seven-year-old sired by Fishwick Instigator to dam Raby Georgina, was judged by Clive Davies, from Wales, as the top longhorn in the North of England and Scotland.
Raby Nour made her way to the championship after being classed the best senior cow and the best homebred cow respectively.
The animal also took the dam and daughter honour alongside Raby Petula.
The judge visited breeders across the country before publishing the results on the Longhorn Cattle Society's website earlier this month.
The judge said was impressed with the entire Raby herd of 25 cows.
Mr Davies said of his visit Raby: "Virtually the whole herd occupied one field, or to be more precise, The Deer Park. Indeed, the longhorns share their accommodation with two herds of deer, red and fallow. Closer inspection of the cattle soon revealed the quality of the breeding females. Cow after cow impressed.
"They stood out because of the excellent construction, the strength of spine and hind leg make-up. But more than that these females had great character and were rearing strong calves."
Raby Estate farm manager Robert Sullivan said it was the first time the herd, which was started in the 1970s, had produced a breed champion.
He said: "It is a great accolade. A cow we bred is the best in the North of England and Scotland – that is from Nottingham all the way to Inverness."
Regarding the herd sharing the park with the deer Mr Sullivan said: "The cows keep to themselves and the deer keep to themselves."
The animals spend their lives in the open at the castle, feeding purely off the grass, and meat from the herd supplies the tea rooms at Raby Castle and High Force Hotel.


Preheat oven to 350°F. Grease and lightly flour three 9- by 2-inch round cake pans, then line the bottoms with waxed paper.
To make the cake: In a small bowl, sift the cake flour and set aside. In a large bowl, on the medium speed of an electric mixer, cream the butter and sugar until very light and fluffy, about 5 minutes. Add the eggs, one at a time, beating well after each addition. In a small bowl, whisk together the red food coloring, cocoa, and vanilla. Add to the batter and beat well.
When the cake has cooled, spread the frosting between the layers, then ice the top and sides of the cake with Creamy Vanilla Frosting .
This recipe also makes 2 dozen cupcakes. Use 2 muffin pans, each with 12 (1/2-cup) muffin cups, and line each cup with a paper liner. (There's no need to grease the cups.) Arrange the oven racks in the upper and lower thirds of the oven and bake the cupcakes, switching positions of the pans halfway through baking, until a tester comes out clean, about 20 minutes. Cool the cupcakes in the pan 10 minutes, then remove from the pan and cool completely on a rack before icing. To ice, mound about 1/4 cup of frosting on top of each cupcake and use an icing spatula to make a swirl on top. If desired, decorate with colored sprinkles.
The cupcakes came out dry and very bland. The frosting recipe was good and made the cupcakes edible. I made these for a kids' birthday party, and they ate them, but they'll eat anything sweet. I'll be searching for an alternative recipe next time I want to make red velvet.
I am so in love with this recipe. Here lies the way to flawless Red Velvet cake!
I have made this recipe several times and it is always delicious. I would like to use this recipe as a black velvet cupcake. Is it possible to add additional cocoa powder and if so, would I reduce the amount of flour by the amount of additional cocoa powder added? Thanks!
I made this recipe about 5 years ago, and then could not find it again for the life of me. I remembered how moist, chocolatey, and bright red these cakes are. I had been making other recipes on this site in the meantime, but they were never the same... too vinegar-y; not bright red. Finally I found this recipe again and made it for Valentine's day. I have the Nordic Ware rosebud cake pan, which these bake in beautifully. The rose cakes come out bright red, light, fluffy, and moist. I'll never use another recipe again!
It took me a few years to make these after identifying this recipe as "need to try". So I can't imagine why I tried them when I had a party for 40. BUT...they were completely amazing!!! I loved the texture and flavor of the cupcake and the frosting was over the top...I thought about using a simpler frosting...but I went for it and I am so happy I did. Rave reviews and better still, I LOVED them. I will make these again and I would not skip the time consuming frosting under any circumstances.
Great red velvet recipe - frosting compliments it beautifully. Some observations - this recipe makes way more than 24 cupcakes (around 40 overfull cups by my count). When I halved the recipe and frosting, I had just enough for 24 perfectly proportioned cupcakes. There's a few comments in other reviews about doubling the butter (to 1 1/2 cups), but this is not necessary. I found the recipe on several other sites with 1 and 1/2 sticks of butter listed - this is what I used and the cupcakes are perfectly rich and moist. I did substitute two extra tablespoons of cocoa (in the full recipe) for two tablespoons of flour, as suggested by another reviewer. The uncooked batter tasted slightly chalky, but this cooked off into a great red velvet flavor. Just be aware that six tablespoons of food coloring is over two ounces, so shop accordingly. I would definitely recommend making this with a stand mixer and really timing the beating. A note about the frosting - my first batch had little flour balls (which thankfully I was able to strain out after chilling the mix, with no bad effects), and I followed the directions exactly. I would recommend whisking the milk into the flour (not the other way around) VERY gradually, and heating the milk mixture a little below medium heat. On my stove, medium is too hot. Hope this helps!
I had to use flour instead of cake flour so I thought perhaps the cake was a wee bit dry because of that. Also, I had only 3.5 TBS of red food color but the cake was still quite red to my pleasant surprise. I'm wondering if anyone has an even better recipe otherwise this recipe is alright.
This is a great recipe for red velvet cupcakes. The frosting is also amazing! There is an error in the cupcake recipe. Add 1 1\2 cups of butter or 3 sticks of butter and NOT 1 1/2 sticks. Good luck!
My daughter saw so many cupcake wars, she became obsessed with Red Velvet. So for her birthday I made these cupcakes - we have never found another Red Velvet cupcake (from a recipe or a bakery) that tastes as good as these. Go with the suggested frosting - you need to plan ahead, but it's worth every bite!! Now this is our go-to red velvet recipe I have to make every year.
This recipe was just OK. As others have mentioned, without the icing the cake has no taste. It was dense, which I liked but was dry and bland.
I didn't have time to read the reviews, so followed the recipe as written. The cupcakes were dry and a bit on the chewy side. It took me 23 minutes for the cakes to be ready. Will look for another red velvet cupcake recipe. Had such high hopes since I made them for Valentine's D. The icing was tasty, and went well with the cupcake. I don't think a cream cheese icing would have complimented the cupcake.
I forgot - I halved the icing recipe and it was more than enough for about 20 cupcakes.
This is a great recipe at altitude. These cupcakes still rose quite nicely at 6000 feet. For those at altitude: the first time I made these I used only 1 teaspoon of baking soda which gave very light, airy cupcakes that bordered on the dry side. The second time I accidentally used 1 teaspoon (plus a pinch) of baking powder, resulting in a much more dense, moist cake. The cocoa flavour doesn't come out at all so next time I'll try doubling the amount of cocoa. The icing is simply fantastic. I highly recommend using a real vanilla bean - adds those beautiful black flecks and a lovely, subtle crunch.
The frosting was delicious!! I was worrried about the consistency at first but it it turned out creamy and not too sweet but just right. My family could not get enough of this. I w ill dedinitely make this again.
I think this makes a wonderful cake that always elicits rave reviews ... and seconds. I agree that it is the icing that makes it spectacular. One way to cut back on the cost is, if you happen to be in the South, buy your red food dye there. I bought a 16 oz. bottle of Sauer's red color in South Carolina and I still have many red velvet cakes to go. Beat's the hell out of buying batches of tiny bottles of red food coloring.
Mediocre at best. Not much flavor, without frosting they have none. Even my kids weren't interested after their first.
Very tasty cupcakes. The frosting is delicious.
I had great luck with this recipe. I made these for a benefit and it was a huge hit. I agree with another reviewer, the frosting is exceptional and in fact, without it, the cupcakes wouldn't have been worth the effort, the frosting is what makes these really great. Yes, it was time consuming and a lot of work but I was asked to make these for a wedding!
These cupcakes are very good. After reading several reviews I used margarine instead of butter (to get a moister cupcake) and I finished them with a vanilla simple syrup (because I like very moist cupcakes). I also prefer cream cheese frosting - so I skipped this vanilla frosting. My family really enjoyed them.


Vaniqa interferes with a chemical in the hair follicles of the skin. This results in slower hair growth where Vaniqa is applied.
Vaniqa is used to reduce unwanted facial hair in women. It does not permanently remove hair or "cure" unwanted facial hair. However it will help you manage your condition and improve your appearance.
Vaniqa may also be used for purposes other than those listed in this medication guide.
Vaniqa is for external use only.
Continue to use Vaniqa even if you do not see immediate results. Reduction in facial hair occurs gradually. Improvement may be seen as early as 4 to 8 weeks of treatment, however it may take longer in some individuals. If no improvement is seen after 6 months of use, treatment with Vaniqa should be discontinued. Hair growth may return to pretreatment levels approximately 8 weeks after discontinuation of treatment with Vaniqa.
Who should not use Vaniqa?
Do not use Vaniqa if you have had an allergic reaction to it in the past. Vaniqa is in the FDA pregnancy category C. This means that it is not known whether eflornithine will harm an unborn baby. Do not use this medication without first talking to your doctor if you are pregnant. It is also not known whether eflornithine passes into breast milk. Do not use this medicine without first talking to your doctor if you are breast-feeding a baby. Vaniqa has not been approved for use by children younger than 12 years of age.
How should I use Vaniqa?
Apply Vaniqa exactly as directed by your doctor. If you do not understand these directions, ask your pharmacist, nurse, or doctor to explain them to you.
Vaniqa does not permanently remove hair or "cure" unwanted facial hair. It is not a hair remover (depilatory). You will need to continue using your current hair removal techniques. Vaniqa will help you manage your condition and improve your appearance.
The cream is usually applied twice daily, at least eight hours apart, or as directed by your doctor.
Wash your hands before and after each application of Vaniqa.
Remove any facial hair that is present using your current hair removal techniques. Wait at least 5 minutes after hair removal before applying Vaniqa. Apply a thin layer of cream to the affected areas of the face and nearby affected areas under the chin and rub it in thoroughly.
Cosmetics or sunscreen may be used after applying Vaniqa, but you should wait a few minutes to allow the treatment to be absorbed before applying them.
Do not wash the treatment areas for at least 4 hours after application. Avoid getting this medication in your eyes, nose, or mouth. If this occurs, wash the area with water. If the cream gets in your eyes, rinse them thoroughly with water and contact your doctor.
Vaniqa may cause temporary redness, rash, burning, stinging, or tingling, especially if it is applied to broken or irritated skin. If irritation develops, reduce the application of Vaniqa to once a day. If irritation continues, stop using Vaniqa and contact your doctor.
If you miss a dose of Vaniqa, skip the dose you missed and apply your next regularly scheduled dose as directed. Do not apply a double dose of this medication or try to "make up" a missed dose.
An overdose is not likely to occur. If the cream has been ingested, or if you suspect an overdose has occurred, contact your doctor, hospital emergency room, or poison control center for advice.
What should I avoid while using Vaniqa?
Avoid getting this medication in your eyes, nose, or mouth. If this occurs, wash the area with water. If Vaniqa gets in your eyes, rinse thoroughly with water and contact your doctor.
Hair bumps (folliculitis) may also occur. If these continue, contact your doctor.
What other drugs will affect Vaniqa?
Before using Vaniqa, talk to your doctor if you are taking any other prescription or over-the-counter medications, especially if you are using any other topical preparations. You may not be able to use Vaniqa, or you may require a dosage adjustment or special monitoring during treatment.
Drugs other than those listed here may also interact with Vaniqa. Talk to your doctor and pharmacist before taking or using any other prescription or over-the-counter medicines.


Ryan is a versatile player who across his career has played in every central position – in the heart of defence with Arthurlie, as a defensive midfielder, as an attacking midfielder and earlier on as a striker. He joined Hamilton Accies from Clyde when 16 but did not make it at 1st team level there and moved into the Juniors with Kilwinning and Bellshill before making a name for himself at Vale of Clyde. Pollok picked him up in 2009 and he had one season in the black and white before subsequent moves to Kilbirnie, Petershill, Renfrew and then Arthurlie in 2012 where he remained until his move to Lok early on in season 2017-18. It was announced in March 2019 that Ryan had signed up again for the 2019-20 season.


text:
← Milly Hirst at Glastonbury, 26 June 2015
Lord Mayor's Celebrations and Norwich Lanes Fayre 4-5 July 2015 →
Kathryn Williams, Johnny Steinberg & The Bluefish for Wymondham Music Festival, 26 June 2015
Posted on June 27, 2015 by shashamane
Kathryn Williams, Johnny Steinberg and the Bluefish at the Central Hall, Wymondham Music Festival, 26 June 2015
This was my first visit to Wymondham's Central Hall, and I was stopped in my tracks upon my arrival by the sound of Kathryn Williams' beautiful voice soundchecking "Cuckoo" which sounded superb. A very good start in an impressive venue, recently refurbished with great attention paid to the acoustics of the place, to evidently good effect.
Kathryn Williams, before her appearance for Wymondham Music Festival
Kathryn being interviewed by Jane of Folkspot Radio
Wymondham Central Hall
The venue filling up ahead of the gig
A balmy summer evening eventually giving way to some spots of rain there was nevertheless an extremely good turn out of 200-plus just about filling the venue. Johnny Steinberg kicked the music off – a central figure in putting this gig on in his home town of the past eighteen years, he was joined by his two Bluefish, providing strings in the form of violin, mandolin and banjo.
The excellent sound provided a good platform for his stories, not only between songs but in his evocative and expressive songwriting and clear delivery. His songs cover a wide spectrum of feelings, events and scenarios, from eating in a posh restaurant wearing a dressing gown belt, tight rope walking between the twin towers (inspired by the brilliant biopic Man on Wire about Philippe Petit), to a very moving number about the Barnsley "Pals" battalion of WWI – Tears Falling Like Rain. Johnny always strikes just the right tone when chatting with the audience, easily affable, likeable and witty. It was a most enjoyable set and the audience responded well, I overheard several complimentary verdicts, especially about Tears Falling Like Rain. Johnny writes really well crafted songs and the lyrics, especially, really draw me in. I've heard Johnny play several times and some of the songs have become quite familiar to me (Hey Pamela got the audience joining in too) and it makes me wish I had more of his recorded material, and I can't say greater than that, it's always the sign of a good performer and artist. Johnny has actually also written with Kathryn Williams, and Andy Bruce who was playing piano with her tonight. I look forward to seeing Johnny Steinberg again somewhere soon.
I have to confess that Kathryn Williams had somehow gone somewhat beneath my radar until I became aware of her via Johnny. Checking her out before the gig I played her new album on Spotify and immediately fell in love with it. The understated, sparse arrangements, perfect lyrics and that gorgeous soft, floating voice are right up my street and listening whilst processing some photos I realised I had listened to four of her albums back-to-back and enjoyed everything, The Quickening making a particularly powerful impression on me. Apparently Hypoxia is her 12th album, a prolific songwriter but one who maintains a very high standard. It's a special work.
The whole of her new album "Hypoxia" is inspired by Sylvia Plath's The Bell Jar and what I like about her style is not just the excellent songs but the emotive quality of the works. I always like to feel moved by art and this is most certainly the case with Kathryn Williams' haunting pieces. She doesn't wish to over explain her songs but to let the listener feel and interpret them how they will.
Kathryn Williams and band
She played two sets with her band tonight (Andy Bruce on piano, guitar, and her bassist Simon who had to dash off to Glastonbury straight after the gig), the first an assortment of songs from her various albums and the second being a playing of Hypoxia in full. The songs every bit as moving live as they are on record but with that special feeling of hearing music performed live. She clearly understands this and values the importance of the shared experience of a concert, playing Neil Young's I Believe in You for the encore as a special unique one-off moment between the band and the audience. The band played beautifully and Kathryn was warm, witty, immensely likeable and charming and sang exquisitely all night. She's a real gem.
The album itself is a wonderful work of which she should be very proud, the songs are beautiful though melancholic and obviously visit some dark places. Kathryn's voice is so smooth and soft but there is a distinct edge too.
I came to this gig almost straight after watching that incredible set by Milly Hirst on BBC's live coverage of the Glastonbury Festival and in a way this was the perfect gig to follow that. Kathryn's music is not a million miles away from Milly's, certainly in mood.
It was a lovely gig in a good venue that made me feel I should come out to Wymondham more often (though I wish the stage curtain would obscure the step ladders!) and I saw more familiar faces in the audience than I expected to, including my friends Richard Penguin and Dorraine so it was nice to have some catch ups in the interval.
My thanks to Kathryn Williams and her wonderful band, Johnny Steinberg and the Bluefish (and not least for introducing me to Kathryn), The Wymondham Music Festival Committee, Wymondham Central Hall, and sponsors Rosedale Funeral Home.
words and photos (c) richard shashamane 2015
http://kathrynwilliams.co.uk/
http://www.amazon.co.uk/Hypoxia-Kathryn-Williams/dp/B00WAONQ8W/ref=sr_1_1?ie=UTF8&qid=1435489606&sr=8-1&keywords=kathryn+williams
http://www.wymfestival.org.uk/
http://www.wymondhamcentralhall.org.uk/
http://www.folkspot.co.uk/
http://www.westnorfolkradio.co.uk
This entry was posted in Festival, live music and dance and tagged bluefish, Johnny Steinberg, kathryn williams, wymondham central hall, wymondham music festival. Bookmark the permalink.