insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'app.detail.view.contextpath', 'app/{app.dn}/versions/{app.version.dn}/details' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'app.detail.view.contextpath' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'docs.address', 'https://help.akana.com/content/current/cm/0_intro/index_cm.htm' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'docs.address' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.dashboard.path', 'home/dashboard' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.dashboard.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.email.change.path', 'home/updateemail' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.email.change.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.email.change.path.extension', 'home/updateemail?code={email.changecode}&email={email.newEmail}' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.email.change.path.extension' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.forgotpassword.path', 'home/forgotpassword' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.forgotpassword.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.forgotpassword.reset.path', 'home/forgotpassword/reset' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.forgotpassword.reset.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.forgotpassword.reset.path.extension', 'home/forgotpassword/reset?email={user.email}&resetCode={password.resetcode}' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.forgotpassword.reset.path.extension' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.learnmore.collaborate.path', 'learnmore/app_collaborate_collaboration.htm' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.learnmore.collaborate.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.learnmore.golive.path', 'learnmore/app_go_live.htm' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.learnmore.golive.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.learnmore.stayinformed.path', 'learnmore/app_stay_informed.htm' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.learnmore.stayinformed.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.login.registration.path', 'home/login/{registration.code}' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.login.registration.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.signup.invitation.path', 'home/signup/{invitation.code}' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.signup.invitation.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.signup.path', 'home/signup' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.signup.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'home.siteadmin.email.change.path.extension', 'home/forgotpassword/reset?email={email.newEmail}&resetCode={email.changecode}' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'home.siteadmin.email.change.path.extension' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'signupconfirm.path', 'signupconfirm/{signup.code}' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'signupconfirm.path' AND THEMEIMPL = 'hermosa');

insert into THEME_IMPL_PROPERTIES select DISTINCT 'hermosa', 'url.path.hash.delimiter', '/#/' FROM THEME_IMPL_PROPERTIES WHERE 0 = (SELECT COUNT(PROPERTY_NAME) FROM THEME_IMPL_PROPERTIES WHERE PROPERTY_NAME = 'url.path.hash.delimiter' AND THEMEIMPL = 'hermosa');