public function loginAction()
{
$configForm = $this->getInvokeArg('bootstrap')->getResource('configForm');
$loginForm = new \Zend_Form($configForm->login);
if ($this->getRequest()->isPost()) {
if ($loginForm->isValid($_POST)) {
try {
$auth = $this->getInvokeArg('bootstrap')->auth;
$auth->setIdentity($loginForm->getValue('login'))->setCredential($loginForm->getValue('password'));
$result = \Zend_Auth::getInstance()->authenticate($auth);
if ($result->isValid()) {
$this->_redirect('/admin');
} else {
$this->_helper->systemMessages('error', 'Anmeldung verweigert');
}
} catch (\Exception $e) {
$log = $this->getInvokeArg('bootstrap')->log;
$log->log($e->getMessage(), \Zend_Log::ERR, array('trace' => $e->getTraceAsString()));
$this->_helper->systemMessages('error', 'Fehler bei der Anmeldung');
}
}
}
$loginForm->setAction('/login');
$this->view->form = $loginForm;
}
public function setModel(Zend_Form $form, \Model\EmployeeTraining $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->training = $em->find("Training", $values['training']);
$model->employee = $em->find("Employee", $form->getValue("parent"));
}
private function getPartnerFilterFromForm(Zend_Form $form)
{
$filter = new KalturaPartnerFilter();
$filterType = $form->getValue('filter_type');
$filterInput = $form->getValue('filter_input');
$includeActive = $form->getValue('include_active');
$includeBlocked = $form->getValue('include_blocked');
$includeRemoved = $form->getValue('include_removed');
if ($filterType == 'byid') {
$filter->idIn = $filterInput;
} else {
if ($filterType == 'byname') {
$filter->nameLike = $filterInput;
} elseif ($filterType == 'free' && $filterInput) {
$filter->partnerNameDescriptionWebsiteAdminNameAdminEmailLike = $filterInput;
}
}
$statuses = array();
if ($includeActive) {
$statuses[] = KalturaPartnerStatus::ACTIVE;
}
if ($includeBlocked) {
$statuses[] = KalturaPartnerStatus::BLOCKED;
}
if ($includeRemoved) {
$statuses[] = KalturaPartnerStatus::FULL_BLOCK;
}
$filter->statusIn = implode(',', $statuses);
$filter->orderBy = KalturaPartnerOrderBy::ID_DESC;
return $filter;
}
public function setModel(Zend_Form $form, \Model\Renouncement $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->documentSendDate = $values['document_send_date'];
$model->policyCreateDate = $values['policy_create_date'];
$model->policyNumber = $values['policy_number'];
$model->customer = $em->find("Customer", $form->getValue("parent"));
}
public function setModel(Zend_Form $form, \Model\CustomerHistory $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->date = $values['date'];
$model->info = $values['info'];
$model->customer = $em->find("Customer", $form->getValue("parent"));
$model->instruction = $em->find("Instruction", $values['instruction']);
}
public function setModel(\Zend_Form $form, \Model\CustomerAddress $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->city = $values['city'];
$model->postcode = $values['postcode'];
$model->state = $em->find("State", $values['state']);
$model->street = $values['street'];
$model->addressType = $values['address_type'];
$model->houseNumber = $values['house_number'];
$model->flatNumber = $values['flat_number'];
$model->customer = $em->find("Customer", $form->getValue("parent"));
}
/** THis is where they pick the duration */
function bookingAction()
{
$this->layout('layout/layout-appointment-summary');
$layoutViewModel = $this->layout();
$progress = new ViewModel(['step' => 3]);
$progress->setTemplate('application/progress');
$layoutViewModel->addChild($progress, 'progress');
$service = $this->serviceDataMapper()->find($this->params('service'));
$durations = array();
foreach ($service['durations'] as $duration) {
$durations[$duration] = $this->durationLabels[$duration];
}
$form = new \Zend_Form();
$form->addElement('radio', 'appointment_duration', array('label' => 'Appointment Duration', 'multiOptions' => $durations, 'separator' => ''));
if ($this->getRequest()->isPost() && $form->isValid($this->params()->fromPost())) {
$url = $this->url()->fromRoute('make-booking', array('action' => 'booking2', 'duration' => $form->getValue('appointment_duration'), 'service' => $this->params('service'), 'day' => $this->params('day')));
$this->redirect()->toUrl($url);
return;
}
$this->viewParams['form'] = $form;
$summary = new ViewModel($this->params()->fromRoute());
$summary->setTemplate('application/summary');
$layoutViewModel->addChild($summary, 'appointment_summary');
$viewModel = new ViewModel($this->viewParams);
$viewModel->setTemplate('application/booking');
return $viewModel;
}
public function indexAction()
{
$session = new \Zend_Session_Namespace('twitter', true);
$oauthConfig = array('callbackUrl' => 'http://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'], 'siteUrl' => 'http://twitter.com/oauth');
$configForm = $this->getInvokeArg('bootstrap')->getResource('configForm');
$twitterApiForm = new \Zend_Form($configForm->twitterApi);
if ($this->getRequest()->isPost()) {
if ($twitterApiForm->isValid($_POST)) {
try {
$this->twitterRepository->saveEntity($twitterApiForm->getValues());
$oauthConfig['consumerKey'] = $twitterApiForm->getValue('consumerKey');
$oauthConfig['consumerSecret'] = $twitterApiForm->getValue('consumerSecret');
$consumer = new \Zend_Oauth_Consumer($oauthConfig);
$token = $consumer->getRequestToken();
$session->twitterRequestToken = serialize($token);
$consumer->redirect();
} catch (\Exception $e) {
$log = $this->getInvokeArg('bootstrap')->log;
$log->log($e->getMessage(), \Zend_Log::ERR, array('trace' => $e->getTraceAsString()));
$this->_helper->systemMessages('error', 'Einstellungen konnte nicht gespeichert werden');
}
}
} else {
try {
$entity = $this->twitterRepository->fetchEntity();
if ($entity) {
if (isset($session->twitterRequestToken)) {
$oauthConfig['consumerKey'] = $entity->consumerKey;
$oauthConfig['consumerSecret'] = $entity->consumerSecret;
$consumer = new \Zend_Oauth_Consumer($oauthConfig);
$token = $consumer->getAccessToken($_GET, unserialize($session->twitterRequestToken));
$this->twitterRepository->saveEntity(array('accessToken' => serialize($token)));
unset($session->twitterRequestToken);
$this->_helper->systemMessages('notice', 'Einstellungen erfolgreich gespeichert');
}
$twitterApiForm->populate($entity->toArray());
}
} catch (\Exception $e) {
$log = $this->getInvokeArg('bootstrap')->log;
$log->log($e->getMessage(), \Zend_Log::ERR, array('trace' => $e->getTraceAsString()));
$this->_helper->systemMessages('error', 'Einstellungen konnte nicht gespeichert werden');
}
}
$twitterApiForm->setAction('/admin/twitter');
$this->view->form = $twitterApiForm;
}
public function setModel(Zend_Form $form, \Model\InstitutionProduct $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->name = $values['name'];
$model->active = $values['active'];
$model->institution = $em->find("Institution", $values['institution']);
}
private function save(Zend_Form $form)
{
$id = (int) $form->getValue('id');
$category = new GC\Entity\Category(array('id' => $id));
if ($id != 0) {
$category = $this->_em->find('GC\\Entity\\Category', $id);
}
$category->populate($form->getValues());
$this->_em->getRepository('GC\\Entity\\Category')->save($category);
}
public function setModel(Zend_Form $form, \Model\CustomerCredit $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->amount = $values['amount'];
$model->balance = $values['balance'];
$model->balanceDate = $values['balance_date'];
$model->bank = $values['bank'];
$model->conclusionDateStart = $values['conclusion_date_start'];
$model->costOfRepayment = $values['cost_of_repayment'];
$model->currency = $em->find("Currency", $values['currency']);
$model->currencyRate = $values['currency_rate'];
$model->installment = $values['installment'];
$model->periodInMonths = $values['period_in_months'];
$model->type = $em->find("CreditType", $values["type"]);
$model->margin = $values['margin'];
$model->rrso = $values['rrso'];
$model->customer = $em->find("Customer", $form->getValue("parent"));
}
public function setModel(Zend_Form $form, \Model\CustomerOldProduct $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->institution = $em->find("Institution", $values['institution']);
$model->institutionProduct = $em->find("InstitutionProduct", $values['institution_product']);
$model->instruction = $em->find("Instruction", $values['instruction']);
$model->insuranceSum = $values['insurance_sum'];
$model->insuranceSumNnw = $values['insurance_sum_nnw'];
$model->insuranceSumNkw = $values['insurance_sum_nkw'];
$model->conclusionDateStart = $values['conclusion_date_start'];
$model->conclusionDateEnd = $values['conclusion_date_end'];
$model->fee = $values['fee'];
$model->premiumType = $em->find("PremiumType", $values['premium_type']);
$model->contribution = $values['contribution'];
$model->amount = $values['amount'];
$model->productCreateDate = $values['create_date'];
$model->policyNumber = $values['policy_number'];
$model->description = $values['description'];
$model->customer = $em->find("Customer", $form->getValue("parent"));
}
public function setPolicy(\Zend_Form $form, \Model\Policy $policy, \Model\Application $application)
{
$em = EntityManager::getInstance();
$values = $form->getValue("policy");
$policy->application = $application;
$policy->outerNumber = $values['policy_outer_number'];
$policy->createDate = $values['policy_create_date'];
$policy->endDate = $values['policy_end_date'];
$policy->popPlace = $values['policy_pop_place'];
$policy->deliveryDate = $values['policy_delivery_date'];
$policy->popReturnDate = $values['policy_pop_return_date'];
}
public function setModel(\Zend_Form $form, \Model\Shipment $model)
{
$em = EntityManager::getInstance();
$values = $form->getValue("basic");
$model->createDate = date("Y-m-d H:i:s");
$model->street = $values['street'];
$model->email = $values['email'];
$model->city = $values['city'];
$model->postcode = $values['postcode'];
$model->state = $em->find("State", $values['state']);
$model->type = $em->find("ShipmentType", $values['type']);
$model->phoneNumber = $values['phone_number'];
}
public function testGetValueCanReturnSubFormValuesFromArrayToWhichElementsBelong()
{
$subForm = new Zend_Form_SubForm();
$subForm->addElements(array('foo' => 'text', 'bar' => 'text'))->setElementsBelongTo('subform');
$subForm->foo->setValue('foo value');
$subForm->bar->setValue('bar value');
$this->form->addSubForm($subForm, 'page1');
$values = $this->form->getValue('subform');
$this->assertTrue(isset($values['foo']), var_export($values, 1));
$this->assertTrue(isset($values['bar']));
$this->assertEquals($subForm->foo->getValue(), $values['foo']);
$this->assertEquals($subForm->bar->getValue(), $values['bar']);
}
public function setModel(\Zend_Form $form, \Model\Document $model)
{
$em = \Application\Entity\EntityManager::getInstance();
$values = $form->getValue("basic");
$model->createDate = date("Y-m-d H:i:s");
$oldFilename = APPLICATION_PATH . "/../tmp/" . $values['document'];
$uniqName = md5(time()) . "." . pathinfo($oldFilename, PATHINFO_EXTENSION);
$newFilename = APPLICATION_PATH . "/../public/documents/" . $uniqName;
rename($oldFilename, $newFilename);
$model->path = $uniqName;
$model->employee = $em->find("Employee", Zend_Auth::getInstance()->getIdentity()->employee_id);
$model->name = $values['name'];
$model->type = $values['type'];
}
/**
* Present a login form and handle user authentication.
*/
public function loginAction()
{
/*
* Build the login form
*/
$form = new Zend_Form();
$form->setMethod('post');
$username = $form->createElement('text', 'username');
$username->setLabel($this->view->translate->_('Username'));
$username->setRequired(true);
$username->addValidator('alnum');
$password = $form->createElement('password', 'password');
$password->setLabel($this->view->translate->_('Password'));
$password->setRequired(true);
$form->addElement($username);
$form->addElement($password);
$form->addElement('submit', 'login', array('label' => $this->view->translate->_('Login')));
/*
* Handle authentication
*/
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData)) {
try {
Model_DbTable_User::authenticate($form->getValue('username'), $form->getValue('password'));
/*
* Set the current user session
*/
$user = Model_DbTable_User::findByUsername($form->getValue('username'));
$currentUser = new Zend_Session_Namespace('currentUser');
$currentUser->id = $user->id;
$currentUser->username = $user->username;
$currentUser->apiKey = $user->apiKey;
$currentUser->language = $user->language;
$currentUser->skin = $user->skin;
$currentUser->isAdmin = $user->isAdmin;
/*
* Redirect back to the index page.
*/
$this->_helper->_redirector->goToRouteAndExit(array('controller' => 'index', 'action' => 'index'));
} catch (Exception $e) {
$this->view->errorMessage = $this->view->translate->_('Login failed.') . ' ' . $e->getMessage();
}
} else {
$this->view->errorMessage = $this->view->translate->_('Login failed.') . ' ' . $this->view->translate->_('Please completely fill out the login form.');
$form->populate($formData);
}
}
$this->view->headTitle($this->view->translate->_('Login'));
$this->view->form = $form;
}
private function getCategoryFromForm(Zend_Form $form)
{
$category = $this->_em->find('GC\\Entity\\Category', (int) $form->getValue('categoryId'));
return $category;
}
/**
* Make sure PHP is up to snuff, that we can write to the right places, and
* make the first user.
*/
public function indexAction()
{
$phpCheck = array('PHP Version >= 5.2.3' => version_compare(PHP_VERSION, '5.2.3') >= 0, 'Standard Extension Loaded' => extension_loaded('standard'), 'SOAP Extension Loaded' => extension_loaded('soap'), 'PCRE Extension Loaded' => extension_loaded('pcre'), 'PDO Extension Loaded' => extension_loaded('pdo'), 'PDO SQLite Extension Loaded' => extension_loaded('pdo_sqlite'), 'SPL Extension Loaded' => extension_loaded('spl'), 'Session Extension Loaded' => extension_loaded('session'), 'Ctype Extension Loaded' => extension_loaded('ctype'));
$systemCheck = array('Languages Directory (' . LANGUAGE_PATH . ') Writable' => is_writable(LANGUAGE_PATH), 'Skins Directory (' . SKIN_PATH . ') Writable' => is_writable(SKIN_PATH), 'Database Directory (' . APPLICATION_PATH . '/../data/db) Writable' => is_writable(APPLICATION_PATH . '/../data/db'), 'Configuration File (' . CONFIG_PATH . '/settings.ini' . ') Writable' => is_writable(CONFIG_PATH . '/settings.ini'));
/*
* Show an error if there are any PHP or system errors.
*/
$hasPhpErrors = false;
$hasSystemErrors = false;
foreach ($phpCheck as $check) {
if (!$check) {
$hasPhpErrors = true;
break;
}
}
foreach ($systemCheck as $check) {
if (!$check) {
$hasSystemErrors = true;
break;
}
}
if (!$hasPhpErrors && !$hasSystemErrors) {
/*
* Build the add user form.
*/
$config = Zend_Registry::get('config');
$skins = Model_Skin::getAllSkins();
$languages = Model_Language::getAllLanguages();
/*
* Turn the skin and language lists into something more Zend_Form
* friendly.
*/
foreach ($skins as $skin) {
$skinList[$skin->name] = $skin->name;
}
foreach ($languages as $language) {
$languageList[$language->name] = $language->name;
}
$form = new Zend_Form();
$form->setMethod('post');
$username = $form->createElement('text', 'username');
$username->setLabel(ucfirst($this->view->translate->_('username')));
$username->setRequired(true);
$username->addValidator('alnum');
$apiKey = $form->createElement('text', 'apiKey');
$apiKey->setLabel(ucfirst($this->view->translate->_('API key')));
$apiKey->setRequired(true);
$apiKey->addValidator('alnum');
$skin = $form->createElement('select', 'skin');
$skin->setLabel(ucfirst($this->view->translate->_('skin')));
$skin->addMultiOptions($skinList);
$skin->setValue($config->defaults->skin);
$skin->setRequired(true);
$language = $form->createElement('select', 'language');
$language->setLabel(ucfirst($this->view->translate->_('language')));
$language->addMultiOptions($languageList);
$language->setValue($config->defaults->language);
$language->setRequired(true);
$form->addElement($username);
$form->addElement($apiKey);
$form->addElement($skin);
$form->addElement($language);
$form->addElement('submit', 'submit', array('label' => $this->view->translate->_('Submit')));
/*
* Process form submission.
*/
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData)) {
/*
* Try out the username and API key to make sure they
* entered a good one.
*/
$account = null;
$client = SoftLayer_SoapClient::getClient('SoftLayer_Account', null, $form->getValue('username'), $form->getValue('apiKey'));
try {
$account = $client->getObject();
} catch (Exception $e) {
$this->view->errorMessage = $this->view->translate->_('Please enter a valid username and API key combination.');
}
/*
* Add the user.
*/
if ($account != null) {
try {
$user = Model_DbTable_User::addUser($form->getValue('username'), $form->getValue('apiKey'), $form->getValue('skin'), $form->getValue('language'), true);
$this->_helper->_redirector->goToRouteAndExit(array('controller' => 'index', 'action' => null));
} catch (Exception $e) {
$this->view->errorMessage = $this->view->translate->_('Unable to add user.') . ' ' . $e->getMessage();
}
}
} else {
$this->view->errorMessage = $this->view->translate->_('Please completely fill out the configuration form.');
}
$form->populate($formData);
}
$this->view->form = $form;
}
$this->view->pageTitle = 'Installation';
$this->view->headTitle('Installation');
$this->view->phpCheck = $phpCheck;
$this->view->systemCheck = $systemCheck;
$this->view->hasPhpErrors = $hasPhpErrors;
$this->view->hasSystemErrors = $hasSystemErrors;
}
/**
* Hook for node save
*
* @param Zend_Form $form
* @param array $arguments
*/
public function nodeSave(Zend_Form $form, &$arguments)
{
$item = array_shift($arguments);
if (Zend_Auth::getInstance()->hasIdentity()) {
$identity = Zend_Auth::getInstance()->getIdentity();
$uid = $identity->id;
} else {
$uid = 0;
}
$filters = Zoo::getService('filter')->getFiltersByUser($uid);
if ($filters && $filters->count() > 0) {
foreach ($filters as $filter) {
$value = $filter->optional ? $form->getValue('filter_' . $filter->name) : 1;
Zoo::getService('content')->setFilter($item, $filter->id, $value);
}
}
}
public function indexAction()
{
$form = new Zend_Form();
$form->addElement('text', 'seckey', array('label' => 'Security Key'));
$form->addElement('submit', 'submit', array('label' => 'install'));
$form->setMethod('post');
if ($this->getRequest()->isPost()) {
if (Zend_Registry::get("SECURITY_KEY") == "write what ever you want but make it unique!") {
$this->view->massage = 'Warning: You have to change your security key at first in your config file!';
} else {
if ($form->populate($this->getRequest()->getParams()) && $form->getValue('seckey') == Zend_Registry::get("SECURITY_KEY")) {
$dbAdapter = Zend_Registry::get('DB_CONNECTION1');
$error = false;
$errorMassage = "";
try {
$tableList = $dbAdapter->listTables();
} catch (Exception $e) {
$error = true;
$errorMassage = "Can't access the db.";
}
$params = $dbAdapter->getConfig();
if (!$error) {
if (count($tableList) == 0) {
/*
* TODO for at script changing
* - remove security for the views
* - remove the last semicolon
* - remove comments
*/
$installScript = "\n\t\t \t\t \n\t\t \t\t SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";\n\t\t \t\t CREATE TABLE IF NOT EXISTS `annotations` (\n\t\t\t\t\t\t\t `ANNO_ID` int(11) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `CEhIM_ID` int(10) unsigned NOT NULL,\n\t\t\t\t\t\t\t `PARENT_ID` int(11) unsigned default NULL,\n\t\t\t\t\t\t\t `PART_ID` int(8) unsigned NOT NULL,\n\t\t\t\t\t\t\t `ANNO_COMMENT` text,\n\t\t\t\t\t\t\t `ANNO_DATE` datetime default NULL,\n\t\t\t\t\t\t\t `ANNO_GROUP` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ANNO_WS_REF` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ANNO_WEBGR_REF` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ANNO_COUNT` int(4) unsigned NOT NULL,\n\t\t\t\t\t\t\t `ANNO_DECIMAL` decimal(7,0) NOT NULL,\n\t\t\t\t\t\t\t `ANNO_SUB` varchar(10) default NULL,\n\t\t\t\t\t\t\t `ANNO_BRIGHTNESS` decimal(10,0) default NULL,\n\t\t\t\t\t\t\t `ANNO_CONTRAST` decimal(10,0) default NULL,\n\t\t\t\t\t\t\t `ANNO_COLOR` decimal(10,0) default NULL,\n\t\t\t\t\t\t\t `ANNO_MAGNIFICATION` decimal(10,0) default NULL,\n\t\t\t\t\t\t\t `ANNO_FINAL` tinyint(1) NOT NULL,\n\t\t\t\t\t\t\t `ANNO_CREATE_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP,\n\t\t\t\t\t\t\t PRIMARY KEY (`ANNO_ID`),\n\t\t\t\t\t\t\t KEY `ANNOTATIONS_FKIndex1` (`PART_ID`),\n\t\t\t\t\t\t\t KEY `ANNOTATIONS_FKIndex2` (`PARENT_ID`),\n\t\t\t\t\t\t\t KEY `ANNOTATIONS_FKIndex3` (`CEhIM_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `attribute_desc` (\n\t\t\t\t\t\t\t `ATDE_ID` int(5) NOT NULL auto_increment,\n\t\t\t\t\t\t\t `USER_ID` int(7) unsigned NOT NULL,\n\t\t\t\t\t\t\t `ATDE_NAME` varchar(255) character set latin1 NOT NULL,\n\t\t\t\t\t\t\t `ATDE_UNIT` varchar(255) character set latin1 default NULL,\n\t\t\t\t\t\t\t `ATDE_DESCRIPTION` text character set latin1,\n\t\t\t\t\t\t\t `ATDE_DEFAULT` varchar(4000) character set latin1 default NULL,\n\t\t\t\t\t\t\t `ATDE_REQUIRED` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ATDE_IS_STANDARD` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ATDE_ACTIVE` tinyint(1) unsigned NOT NULL default '1',\n\t\t\t\t\t\t\t `ATDE_DATATYPE` varchar(20) character set latin1 NOT NULL,\n\t\t\t\t\t\t\t `ATDE_FORMTYPE` varchar(20) character set latin1 NOT NULL,\n\t\t\t\t\t\t\t `ATDE_VALUELIST` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ATDE_SEQUENCE` int(3) unsigned default '0',\n\t\t\t\t\t\t\t `ATDE_MULTIPLE` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ATDE_SHOWINLIST` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `ATDE_GROUP` varchar(20) character set latin1 NOT NULL,\n\t\t\t\t\t\t\t `ATDE_FILTERS` varchar(4000) character set latin1 default NULL,\n\t\t\t\t\t\t\t `ATDE_VALIDATORS` varchar(4000) character set latin1 default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`ATDE_ID`),\n\t\t\t\t\t\t\t KEY `ATTRIBUTE_DESC_FISH_FKIndex1` (`USER_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT AUTO_INCREMENT=509 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `caex_has_atde` (\n\t\t\t\t\t\t\t `CAEX_ID` int(6) unsigned NOT NULL,\n\t\t\t\t\t\t\t `ATDE_ID` int(5) NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`CAEX_ID`,`ATDE_ID`),\n\t\t\t\t\t\t\t KEY `CAEX_has_ATDEF_FKIndex1` (`CAEX_ID`),\n\t\t\t\t\t\t\t KEY `CAEX_has_ATDEF_FKIndex2` (`ATDE_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='shown attributes';\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `calibration_exercise` (\n\t\t\t\t\t\t\t `CAEX_ID` int(6) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `KETA_ID` int(5) unsigned default NULL,\n\t\t\t\t\t\t\t `WORK_ID` int(5) unsigned default NULL,\n\t\t\t\t\t\t\t `EXPE_ID` int(5) unsigned default NULL,\n\t\t\t\t\t\t\t `CAEX_NAME` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `CAEX_DESCRIPTION` text,\n\t\t\t\t\t\t\t `CAEX_COMPAREABLE` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `CAEX_RANDOMIZED` int(1) unsigned default NULL,\n\t\t\t\t\t\t\t `CAEX_IS_STOPPED` tinyint(1) unsigned NOT NULL default '1',\n\t\t\t\t\t\t\t `CAEX_TRAINING` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t PRIMARY KEY (`CAEX_ID`),\n\t\t\t\t\t\t\t KEY `CALIBRATION_EXERCISE_FKIndex1` (`KETA_ID`),\n\t\t\t\t\t\t\t KEY `CALIBRATION_EXERCISE_FKIndex2` (`EXPE_ID`),\n\t\t\t\t\t\t\t KEY `CALIBRATION_EXERCISE_FKIndex3` (`WORK_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `ce_has_image` (\n\t\t\t\t\t\t\t `CEhIM_ID` int(10) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `CAEX_ID` int(6) unsigned NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_ID` int(9) unsigned NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`CEhIM_ID`),\n\t\t\t\t\t\t\t KEY `SUBSET_HAS_IMAGE_FKIndex1` (`IMAGE_ID`),\n\t\t\t\t\t\t\t KEY `CE_HAS_IMAGE_FKIndex2` (`CAEX_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `dots` (\n\t\t\t\t\t\t\t `DOTS_ID` int(11) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `ANNO_ID` int(11) unsigned NOT NULL,\n\t\t\t\t\t\t\t `DOTS_X` float default NULL,\n\t\t\t\t\t\t\t `DOTS_Y` float default NULL,\n\t\t\t\t\t\t\t `DOTS_SEQUENCE` int(2) unsigned NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`DOTS_ID`),\n\t\t\t\t\t\t\t KEY `DOTS_FKIndex1` (`ANNO_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=217 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `expertise` (\n\t\t\t\t\t\t\t `EXPE_ID` int(5) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `EXPE_SPECIES` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `EXPE_AREA` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `EXPE_SUBJECT` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`EXPE_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `fish` (\n\t\t\t\t\t\t\t `FISH_ID` int(9) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `FISH_SAMPLE_CODE` varchar(50) NOT NULL,\n\t\t\t\t\t\t\t `USER_ID` int(7) unsigned NOT NULL COMMENT 'owner of data/metadata',\n\t\t\t\t\t\t\t PRIMARY KEY (`FISH_ID`),\n\t\t\t\t\t\t\t UNIQUE KEY `FISH_SAMPLE_CODE_2` (`FISH_SAMPLE_CODE`),\n\t\t\t\t\t\t\t KEY `FISH_SAMPLE_CODE` (`FISH_SAMPLE_CODE`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=463 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `image` (\n\t\t\t\t\t\t\t `IMAGE_ID` int(9) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `USER_ID` int(7) unsigned NOT NULL COMMENT 'owner of file and data/metadata',\n\t\t\t\t\t\t\t `FISH_ID` int(9) unsigned NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_CHECKSUM` varchar(50) default NULL,\n\t\t\t\t\t\t\t `IMAGE_GUID` char(36) NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_ORIGINAL_CHECKSUM` varchar(50) NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_ORIGINAL_FILENAME` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_DIM_X` int(4) NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_DIM_Y` int(4) NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_RATIO_EXTERNAL` float default NULL COMMENT 'ratio (calculated WebGR external) between pixel and physical length in micrometer',\n `IMAGE_RATIO_INTERNAL` float default NULL COMMENT 'ratio (calculated WebGR internal) between pixel and physical length in micrometer',\n `IMAGE_SHRINKED_RATIO` float default NULL COMMENT 'ratio between shrinked working copy and original image',\n\t\t\t\t\t\t\t PRIMARY KEY (`IMAGE_ID`),\n\t\t\t\t\t\t\t KEY `IMAGE_FKIndex2` (`FISH_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=144 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `imageset_attributes` (\n\t\t\t\t\t\t\t `IMAT_ID` int(6) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `ATDE_ID` int(5) NOT NULL,\n\t\t\t\t\t\t\t `CAEX_ID` int(6) unsigned NOT NULL,\n\t\t\t\t\t\t\t `VALI_ID` int(5) unsigned default NULL,\n\t\t\t\t\t\t\t `VALUE` varchar(255) default NULL,\n\t\t\t\t\t\t\t `IMAT_FROM` varchar(4000) default NULL,\n\t\t\t\t\t\t\t `IMAT_TO` varchar(4000) default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`IMAT_ID`),\n\t\t\t\t\t\t\t KEY `COLLECTION_ATTRIBUTES_FKIndex4` (`VALI_ID`),\n\t\t\t\t\t\t\t KEY `COLLECTION_ATTRIBUTES_FKIndex1` (`CAEX_ID`),\n\t\t\t\t\t\t\t KEY `IMAGESET_ATTRIBUTES_FKIndex3` (`ATDE_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `key_table` (\n\t\t\t\t\t\t\t `KETA_ID` int(5) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `KETA_AREA` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `KETA_SPECIES` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `KETA_AGE` tinyint(1) unsigned default NULL,\n\t\t\t\t\t\t\t `KETA_MATURITY` tinyint(1) unsigned default NULL,\n\t\t\t\t\t\t\t `KETA_NAME` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `KETA_SUBJECT` varchar(255) NOT NULL COMMENT 'replaces KETA_AGE and _MATURITY',\n\t\t\t\t\t\t\t `KETA_FILENAME` varchar(259) character set utf8 collate utf8_unicode_ci NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`KETA_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `meta_data_fish` (\n\t\t\t\t\t\t\t `MEDFI_ID` int(11) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `ATDE_ID` int(5) NOT NULL,\n\t\t\t\t\t\t\t `FISH_ID` int(9) unsigned NOT NULL,\n\t\t\t\t\t\t\t `MEDFI_VALUE` varchar(4000) default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`MEDFI_ID`),\n\t\t\t\t\t\t\t KEY `META_DATA_FKIndex3` (`FISH_ID`),\n\t\t\t\t\t\t\t KEY `META_DATA_FISH_FKIndex2` (`ATDE_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=154 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `meta_data_image` (\n\t\t\t\t\t\t\t `MEDIM_ID` int(11) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `ATDE_ID` int(5) NOT NULL,\n\t\t\t\t\t\t\t `IMAGE_ID` int(9) unsigned NOT NULL,\n\t\t\t\t\t\t\t `MEDIM_VALUE` varchar(4000) default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`MEDIM_ID`),\n\t\t\t\t\t\t\t KEY `META_DATA_IMAGE_FKIndex1` (`IMAGE_ID`),\n\t\t\t\t\t\t\t KEY `META_DATA_IMAGE_FKIndex2` (`ATDE_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `participant` (\n\t\t\t\t\t\t\t `PART_ID` int(8) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `CAEX_ID` int(6) unsigned NOT NULL,\n\t\t\t\t\t\t\t `USER_ID` int(7) unsigned NOT NULL,\n\t\t\t\t\t\t\t `PART_EXPERTISE_LEVEL` varchar(30) default NULL,\n\t\t\t\t\t\t\t `PART_STOCK_ASSESSMENT` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t\t\t\t\t `PART_PARTICIPANT_ROLE` varchar(30) NOT NULL default 'Reader',\n\t\t\t\t\t\t\t `PART_NUMBER` int(3) unsigned NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`PART_ID`),\n\t\t\t\t\t\t\t KEY `PARTICIPANT_FKIndex1` (`USER_ID`),\n\t\t\t\t\t\t\t KEY `PARTICIPANT_FKIndex2` (`CAEX_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `user` (\n\t\t\t\t\t\t\t `USER_ID` int(7) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `USER_USERNAME` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `USER_LASTNAME` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `USER_FIRSTNAME` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `USER_PASSWORD` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `USER_E_MAIL` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `USER_INSTITUTION` varchar(255) default NULL,\n\t\t\t\t\t\t\t `USER_STREET` varchar(255) default NULL,\n\t\t\t\t\t\t\t `USER_COUNTRY` varchar(255) default NULL,\n\t\t\t\t\t\t\t `USER_PHONE` varchar(255) default NULL,\n\t\t\t\t\t\t\t `USER_FAX` varchar(255) default NULL,\n\t\t\t\t\t\t\t `USER_CITY` varchar(255) default NULL,\n\t\t\t\t\t\t\t `USER_ACTIVE` tinyint(1) unsigned NOT NULL default '1',\n\t\t\t\t\t\t\t `USER_ROLE` varchar(11) NOT NULL default 'reader',\n\t\t\t\t\t\t\t `USER_GUID` varchar(40) default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`USER_ID`),\n\t\t\t\t\t\t\t UNIQUE KEY `USERNAME_UNIQUE` (`USER_USERNAME`),\n\t\t\t\t\t\t\t UNIQUE KEY `USER_GUID` (`USER_GUID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=101 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `user_has_expertise` (\n\t\t\t\t\t\t\t `USER_ID` int(7) unsigned NOT NULL,\n\t\t\t\t\t\t\t `EXPE_ID` int(5) unsigned NOT NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`USER_ID`,`EXPE_ID`),\n\t\t\t\t\t\t\t KEY `USER_has_STOCK_FKIndex1` (`USER_ID`),\n\t\t\t\t\t\t\t KEY `USER_has_EXPERTISE_FKIndex2` (`EXPE_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `value_list` (\n\t\t\t\t\t\t\t `VALI_ID` int(5) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `ATDE_ID` int(5) NOT NULL,\n\t\t\t\t\t\t\t `VALI_NAME` varchar(255) default NULL,\n\t\t\t\t\t\t\t `VALI_VALUE` varchar(4000) default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`VALI_ID`),\n\t\t\t\t\t\t\t KEY `VALUE_LIST_FKIndex1` (`ATDE_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1021 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `v_all_annotations` (\n\t\t\t\t\t\t\t`ANNO_ID` int(11) unsigned\n\t\t\t\t\t\t\t,`CEhIM_ID` int(10) unsigned\n\t\t\t\t\t\t\t,`PARENT_ID` int(11) unsigned\n\t\t\t\t\t\t\t,`PART_ID` int(8) unsigned\n\t\t\t\t\t\t\t,`ANNO_COMMENT` text\n\t\t\t\t\t\t\t,`ANNO_DATE` datetime\n\t\t\t\t\t\t\t,`ANNO_GROUP` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`ANNO_WS_REF` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`ANNO_WEBGR_REF` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`ANNO_COUNT` int(4) unsigned\n\t\t\t\t\t\t\t,`ANNO_DECIMAL` decimal(7,0)\n\t\t\t\t\t\t\t,`ANNO_SUB` varchar(10)\n\t\t\t\t\t\t\t,`ANNO_BRIGHTNESS` decimal(10,0)\n\t\t\t\t\t\t\t,`ANNO_CONTRAST` decimal(10,0)\n\t\t\t\t\t\t\t,`ANNO_COLOR` decimal(10,0)\n\t\t\t\t\t\t\t,`ANNO_MAGNIFICATION` decimal(10,0)\n\t\t\t\t\t\t\t,`ANNO_FINAL` tinyint(1)\n\t\t\t\t\t\t\t,`ANNO_CREATE_DATE` timestamp\n\t\t\t\t\t\t\t,`PART_NUMBER` int(3) unsigned\n\t\t\t\t\t\t\t,`IMAGE_ID` int(9) unsigned\n\t\t\t\t\t\t\t,`CAEX_ID` int(6) unsigned\n\t\t\t\t\t\t\t,`KETA_ID` int(5) unsigned\n\t\t\t\t\t\t\t,`WORK_ID` int(5) unsigned\n\t\t\t\t\t\t\t,`EXPE_ID` int(5) unsigned\n\t\t\t\t\t\t\t,`CAEX_NAME` varchar(255)\n\t\t\t\t\t\t\t,`CAEX_DESCRIPTION` text\n\t\t\t\t\t\t\t,`CAEX_COMPAREABLE` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`CAEX_RANDOMIZED` int(1) unsigned\n\t\t\t\t\t\t\t,`CAEX_IS_STOPPED` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`CAEX_TRAINING` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`WORK_NAME` varchar(255)\n\t\t\t\t\t\t\t,`IMAGE_ORIGINAL_FILENAME` varchar(255)\n\t\t\t\t\t\t\t,`KETA_NAME` varchar(255)\n\t\t\t\t\t\t\t);\n\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `v_ce_list` (\n\t\t\t\t\t\t\t`CAEX_ID` int(6) unsigned\n\t\t\t\t\t\t\t,`CAEX_DESCRIPTION` text\n\t\t\t\t\t\t\t,`CAEX_NAME` varchar(255)\n\t\t\t\t\t\t\t,`CAEX_TRAINING` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`KETA_ID` int(5) unsigned\n\t\t\t\t\t\t\t,`EXPE_ID` int(5) unsigned\n\t\t\t\t\t\t\t,`WORK_NAME` varchar(255)\n\t\t\t\t\t\t\t,`WORK_ID` int(5) unsigned\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `v_fish_info` (\n\t\t\t\t\t\t\t`FISH_SAMPLE_CODE` varchar(50)\n\t\t\t\t\t\t\t,`MEDFI_VALUE` varchar(4000)\n\t\t\t\t\t\t\t,`ATDE_NAME` varchar(255)\n\t\t\t\t\t\t\t,`ATDE_UNIT` varchar(255)\n\t\t\t\t\t\t\t,`ATDE_VALUELIST` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`VALI_NAME` varchar(255)\n\t\t\t\t\t\t\t,`CEhIM_ID` int(10) unsigned\n\t\t\t\t\t\t\t,`UNIT` varchar(4000)\n\t\t\t\t\t\t\t,`IMAGE_ID` int(9) unsigned\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `v_imageset_info` (\n\t\t\t\t\t\t\t`IMAT_FROM` varchar(4000)\n\t\t\t\t\t\t\t,`IMAT_TO` varchar(4000)\n\t\t\t\t\t\t\t,`VALI_NAME` varchar(255)\n\t\t\t\t\t\t\t,`VALUE` varchar(255)\n\t\t\t\t\t\t\t,`ATDE_NAME` varchar(255)\n\t\t\t\t\t\t\t,`ATDE_UNIT` varchar(255)\n\t\t\t\t\t\t\t,`ATDE_VALUELIST` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`CEhIM_ID` int(10) unsigned\n\t\t\t\t\t\t\t,`CAEX_ID` int(6) unsigned\n\t\t\t\t\t\t\t,`UNIT` varchar(4000)\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `v_image_info` (\n\t\t\t\t\t\t\t`IMAGE_ORIGINAL_FILENAME` varchar(255)\n\t\t\t\t\t\t\t,`MEDIM_VALUE` varchar(4000)\n\t\t\t\t\t\t\t,`ATDE_NAME` varchar(255)\n\t\t\t\t\t\t\t,`ATDE_UNIT` varchar(255)\n\t\t\t\t\t\t\t,`ATDE_VALUELIST` tinyint(1) unsigned\n\t\t\t\t\t\t\t,`VALI_NAME` varchar(255)\n\t\t\t\t\t\t\t,`CEhIM_ID` int(10) unsigned\n\t\t\t\t\t\t\t,`UNIT` varchar(4000)\n\t\t\t\t\t\t\t,`IMAGE_ID` int(9) unsigned\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `workshop` (\n\t\t\t\t\t\t\t `WORK_ID` int(5) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `USER_ID` int(7) unsigned NOT NULL,\n\t\t\t\t\t\t\t `WORK_NAME` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `WORK_STARTDATE` date NOT NULL,\n\t\t\t\t\t\t\t `WORK_ENDDATE` date default NULL,\n\t\t\t\t\t\t\t `WORK_LOCATION` varchar(255) default NULL,\n\t\t\t\t\t\t\t `WORK_HOST_ORGANISATION` varchar(255) default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`WORK_ID`),\n\t\t\t\t\t\t\t KEY `WORKSHOP_FKIndex1` (`USER_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `ws_info` (\n\t\t\t\t\t\t\t `WSIN_ID` int(7) unsigned NOT NULL auto_increment,\n\t\t\t\t\t\t\t `WORK_ID` int(5) unsigned NOT NULL,\n\t\t\t\t\t\t\t `WSIN_TEXT` varchar(255) NOT NULL,\n\t\t\t\t\t\t\t `WSIN_LINK` varchar(255) default NULL,\n\t\t\t\t\t\t\t `WSIN_FILE` varchar(255) default NULL,\n\t\t\t\t\t\t\t PRIMARY KEY (`WSIN_ID`),\n\t\t\t\t\t\t\t KEY `WS_INFO_FKIndex1` (`WORK_ID`)\n\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tDROP TABLE IF EXISTS `v_all_annotations`;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE VIEW `" . $params['dbname'] . "`.`v_all_annotations` AS \n\t\t\t\t\t\t\t(select `" . $params['dbname'] . "`.`annotations`.`ANNO_ID` AS `ANNO_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`CEhIM_ID` AS `CEhIM_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`PARENT_ID` AS `PARENT_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`PART_ID` AS `PART_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_COMMENT` AS `ANNO_COMMENT`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_DATE` AS `ANNO_DATE`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_GROUP` AS `ANNO_GROUP`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_WS_REF` AS `ANNO_WS_REF`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_WEBGR_REF` AS `ANNO_WEBGR_REF`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_COUNT` AS `ANNO_COUNT`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_DECIMAL` AS `ANNO_DECIMAL`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_SUB` AS `ANNO_SUB`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_BRIGHTNESS` AS `ANNO_BRIGHTNESS`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_CONTRAST` AS `ANNO_CONTRAST`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_COLOR` AS `ANNO_COLOR`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_MAGNIFICATION` AS `ANNO_MAGNIFICATION`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_FINAL` AS `ANNO_FINAL`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`annotations`.`ANNO_CREATE_DATE` AS `ANNO_CREATE_DATE`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`participant`.`PART_NUMBER` AS `PART_NUMBER`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`ce_has_image`.`IMAGE_ID` AS `IMAGE_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID` AS `CAEX_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`KETA_ID` AS `KETA_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`WORK_ID` AS `WORK_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`EXPE_ID` AS `EXPE_ID`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_NAME` AS `CAEX_NAME`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_DESCRIPTION` AS `CAEX_DESCRIPTION`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_COMPAREABLE` AS `CAEX_COMPAREABLE`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_RANDOMIZED` AS `CAEX_RANDOMIZED`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_IS_STOPPED` AS `CAEX_IS_STOPPED`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_TRAINING` AS `CAEX_TRAINING`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`workshop`.`WORK_NAME` AS `WORK_NAME`,`" . $params['dbname'] . "`.\n\t\t\t\t\t\t\t`image`.`IMAGE_ORIGINAL_FILENAME` AS `IMAGE_ORIGINAL_FILENAME`,\n\t\t\t\t\t\t\t`" . $params['dbname'] . "`.`key_table`.`KETA_NAME` AS `KETA_NAME` \n\t\t\t\t\t\t\tfrom ((((((`" . $params['dbname'] . "`.`annotations` \n\t\t\t\t\t\t\tjoin `" . $params['dbname'] . "`.`participant` on((`" . $params['dbname'] . "`.`annotations`.`PART_ID` = `" . $params['dbname'] . "`.`participant`.`PART_ID`))) \n\t\t\t\t\t\t\tjoin `" . $params['dbname'] . "`.`ce_has_image` on((`" . $params['dbname'] . "`.`annotations`.`CEhIM_ID` = `" . $params['dbname'] . "`.`ce_has_image`.`CEhIM_ID`))) \n\t\t\t\t\t\t\tjoin `" . $params['dbname'] . "`.`image` on((`" . $params['dbname'] . "`.`ce_has_image`.`IMAGE_ID` = `" . $params['dbname'] . "`.`image`.`IMAGE_ID`))) \n\t\t\t\t\t\t\tjoin `" . $params['dbname'] . "`.`calibration_exercise` on((`" . $params['dbname'] . "`.`ce_has_image`.`CAEX_ID` = `" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID`))) \n\t\t\t\t\t\t\tleft join `" . $params['dbname'] . "`.`workshop` on((`" . $params['dbname'] . "`.`calibration_exercise`.`WORK_ID` = `" . $params['dbname'] . "`.`workshop`.`WORK_ID`))) \n\t\t\t\t\t\t\tjoin `" . $params['dbname'] . "`.`key_table` on((`" . $params['dbname'] . "`.`calibration_exercise`.`KETA_ID` = `" . $params['dbname'] . "`.`key_table`.`KETA_ID`))));\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tDROP TABLE IF EXISTS `v_ce_list`;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE VIEW `" . $params['dbname'] . "`.`v_ce_list` AS \n\t\t\t\t\t\t\t(select `" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID` AS `CAEX_ID`,`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_DESCRIPTION` AS `CAEX_DESCRIPTION`,`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_NAME` AS `CAEX_NAME`,`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_TRAINING` AS `CAEX_TRAINING`,`" . $params['dbname'] . "`.`calibration_exercise`.`KETA_ID` AS `KETA_ID`,`" . $params['dbname'] . "`.`calibration_exercise`.`EXPE_ID` AS `EXPE_ID`,`" . $params['dbname'] . "`.`workshop`.`WORK_NAME` AS `WORK_NAME`,`" . $params['dbname'] . "`.`workshop`.`WORK_ID` AS `WORK_ID` from ((`" . $params['dbname'] . "`.`calibration_exercise` left join `" . $params['dbname'] . "`.`workshop` on((`" . $params['dbname'] . "`.`calibration_exercise`.`WORK_ID` = `" . $params['dbname'] . "`.`workshop`.`WORK_ID`))) left join `" . $params['dbname'] . "`.`participant` on((`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID` = `" . $params['dbname'] . "`.`participant`.`CAEX_ID`))) group by `" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID`);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tDROP TABLE IF EXISTS `v_fish_info`;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tcreate or replace view v_fish_info as (\n\t\t\t\t\t\t\tSELECT \n\t\t\t\t\t\t\t fish.FISH_SAMPLE_CODE,\n\t\t\t\t\t\t\t meta_data_fish.MEDFI_VALUE,\n\t\t\t\t\t\t\t attribute_desc.ATDE_NAME,\n\t\t\t\t\t\t\t attribute_desc.ATDE_UNIT,\n\t\t\t\t\t\t\t attribute_desc.ATDE_VALUELIST,\n\t\t\t\t\t\t\t value_list.VALI_NAME,\n\t\t\t\t\t\t\t ce_has_image.CEhIM_ID,\n\t\t\t\t\t\t\t unitlist.VALI_VALUE as UNIT,\n\t\t\t\t\t\t\t image.IMAGE_ID\n\t\t\t\t\t\t\tfrom caex_has_atde\n\t\t\t\t\t\t\tjoin ce_has_image on caex_has_atde.CAEX_ID = ce_has_image.CAEX_ID\n\t\t\t\t\t\t\tjoin image on ce_has_image.IMAGE_ID = image.IMAGE_ID\n\t\t\t\t\t\t\tjoin fish on image.FISH_ID = fish.FISH_ID\n\t\t\t\t\t\t\tjoin meta_data_fish on fish.FISH_ID = meta_data_fish.FISH_ID AND meta_data_fish.ATDE_ID = caex_has_atde.ATDE_ID\n\t\t\t\t\t\t\tjoin attribute_desc on meta_data_fish.ATDE_ID = attribute_desc.ATDE_ID\n\t\t\t\t\t\t\tleft join value_list on meta_data_fish.MEDFI_VALUE = value_list.VALI_ID\n\t\t\t\t\t\t\tleft join value_list as unitlist on attribute_desc.ATDE_UNIT = unitlist.VALI_ID\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tDROP TABLE IF EXISTS `v_imageset_info`;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tCREATE VIEW `" . $params['dbname'] . "`.`v_imageset_info` AS \n\t\t\t\t\t\t\t(select max(`" . $params['dbname'] . "`.`imageset_attributes`.`IMAT_FROM`) AS `IMAT_FROM`,max(`" . $params['dbname'] . "`.`imageset_attributes`.`IMAT_TO`) AS `IMAT_TO`,max(`" . $params['dbname'] . "`.`value_list`.`VALI_NAME`) AS `VALI_NAME`,max(`" . $params['dbname'] . "`.`imageset_attributes`.`VALUE`) AS `VALUE`,`" . $params['dbname'] . "`.`attribute_desc`.`ATDE_NAME` AS `ATDE_NAME`,`" . $params['dbname'] . "`.`attribute_desc`.`ATDE_UNIT` AS `ATDE_UNIT`,`" . $params['dbname'] . "`.`attribute_desc`.`ATDE_VALUELIST` AS `ATDE_VALUELIST`,`" . $params['dbname'] . "`.`ce_has_image`.`CEhIM_ID` AS `CEhIM_ID`,`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID` AS `CAEX_ID`,`unitlist`.`VALI_VALUE` AS `UNIT` from (((((`" . $params['dbname'] . "`.`imageset_attributes` join `" . $params['dbname'] . "`.`attribute_desc` on((`" . $params['dbname'] . "`.`imageset_attributes`.`ATDE_ID` = `" . $params['dbname'] . "`.`attribute_desc`.`ATDE_ID`))) left join `" . $params['dbname'] . "`.`value_list` `unitlist` on((`" . $params['dbname'] . "`.`attribute_desc`.`ATDE_UNIT` = `unitlist`.`VALI_ID`))) left join `" . $params['dbname'] . "`.`value_list` on((`" . $params['dbname'] . "`.`imageset_attributes`.`VALUE` = `" . $params['dbname'] . "`.`value_list`.`VALI_ID`))) join `" . $params['dbname'] . "`.`calibration_exercise` on((`" . $params['dbname'] . "`.`imageset_attributes`.`CAEX_ID` = `" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID`))) join `" . $params['dbname'] . "`.`ce_has_image` on((`" . $params['dbname'] . "`.`calibration_exercise`.`CAEX_ID` = `" . $params['dbname'] . "`.`ce_has_image`.`CAEX_ID`))) group by `" . $params['dbname'] . "`.`attribute_desc`.`ATDE_NAME`,`" . $params['dbname'] . "`.`ce_has_image`.`CEhIM_ID`);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tDROP TABLE IF EXISTS `v_image_info`;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tcreate or replace view v_image_info as (\n\t\t\t\t\t\t\tSelect image.IMAGE_ORIGINAL_FILENAME,\n\t\t\t\t\t\t\t meta_data_image.MEDIM_VALUE,\n\t\t\t\t\t\t\t attribute_desc.ATDE_NAME,\n\t\t\t\t\t\t\t attribute_desc.ATDE_UNIT,\n\t\t\t\t\t\t\t attribute_desc.ATDE_VALUELIST,\n\t\t\t\t\t\t\t value_list.VALI_NAME,\n\t\t\t\t\t\t\t ce_has_image.CEhIM_ID,\n\t\t\t\t\t\t\t unitlist.VALI_VALUE as UNIT,\n\t\t\t\t\t\t\t image.IMAGE_ID\n\t\t\t\t\t\t\tfrom caex_has_atde\n\t\t\t\t\t\t\tjoin ce_has_image on caex_has_atde.CAEX_ID = ce_has_image.CAEX_ID\n\t\t\t\t\t\t\tjoin image on ce_has_image.IMAGE_ID = image.IMAGE_ID\n\t\t\t\t\t\t\tjoin meta_data_image on image.IMAGE_ID = meta_data_image.IMAGE_ID AND meta_data_image.ATDE_ID = caex_has_atde.ATDE_ID\n\t\t\t\t\t\t\tjoin attribute_desc on meta_data_image.ATDE_ID = attribute_desc.ATDE_ID\n\t\t\t\t\t\t\tleft join value_list as unitlist on attribute_desc.ATDE_UNIT = unitlist.VALI_ID\n\t\t\t\t\t\t\tleft join value_list on meta_data_image.MEDIM_VALUE = value_list.VALI_ID\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `annotations`\n\t\t\t\t\t\t\t ADD CONSTRAINT `annotations_ibfk_1` FOREIGN KEY (`PART_ID`) REFERENCES `participant` (`PART_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `annotations_ibfk_2` FOREIGN KEY (`PARENT_ID`) REFERENCES `annotations` (`ANNO_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `annotations_ibfk_3` FOREIGN KEY (`CEhIM_ID`) REFERENCES `ce_has_image` (`CEhIM_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `attribute_desc`\n\t\t\t\t\t\t\t ADD CONSTRAINT `attribute_desc_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `caex_has_atde`\n\t\t\t\t\t\t\t ADD CONSTRAINT `caex_has_atde_ibfk_2` FOREIGN KEY (`ATDE_ID`) REFERENCES `attribute_desc` (`ATDE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `caex_has_atde_ibfk_3` FOREIGN KEY (`CAEX_ID`) REFERENCES `calibration_exercise` (`CAEX_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `calibration_exercise`\n\t\t\t\t\t\t\t ADD CONSTRAINT `calibration_exercise_ibfk_1` FOREIGN KEY (`EXPE_ID`) REFERENCES `expertise` (`EXPE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `calibration_exercise_ibfk_3` FOREIGN KEY (`KETA_ID`) REFERENCES `key_table` (`KETA_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `calibration_exercise_ibfk_4` FOREIGN KEY (`WORK_ID`) REFERENCES `workshop` (`WORK_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `ce_has_image`\n\t\t\t\t\t\t\t ADD CONSTRAINT `ce_has_image_ibfk_1` FOREIGN KEY (`IMAGE_ID`) REFERENCES `image` (`IMAGE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `ce_has_image_ibfk_2` FOREIGN KEY (`CAEX_ID`) REFERENCES `calibration_exercise` (`CAEX_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `dots`\n\t\t\t\t\t\t\t ADD CONSTRAINT `dots_ibfk_1` FOREIGN KEY (`ANNO_ID`) REFERENCES `annotations` (`ANNO_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `image`\n\t\t\t\t\t\t\t ADD CONSTRAINT `image_ibfk_1` FOREIGN KEY (`FISH_ID`) REFERENCES `fish` (`FISH_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `imageset_attributes`\n\t\t\t\t\t\t\t ADD CONSTRAINT `imageset_attributes_ibfk_1` FOREIGN KEY (`ATDE_ID`) REFERENCES `attribute_desc` (`ATDE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `imageset_attributes_ibfk_2` FOREIGN KEY (`VALI_ID`) REFERENCES `value_list` (`VALI_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `imageset_attributes_ibfk_3` FOREIGN KEY (`CAEX_ID`) REFERENCES `calibration_exercise` (`CAEX_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `meta_data_fish`\n\t\t\t\t\t\t\t ADD CONSTRAINT `meta_data_fish_ibfk_4` FOREIGN KEY (`ATDE_ID`) REFERENCES `attribute_desc` (`ATDE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `meta_data_fish_ibfk_5` FOREIGN KEY (`FISH_ID`) REFERENCES `fish` (`FISH_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `meta_data_image`\n\t\t\t\t\t\t\t ADD CONSTRAINT `meta_data_image_ibfk_2` FOREIGN KEY (`ATDE_ID`) REFERENCES `attribute_desc` (`ATDE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `meta_data_image_ibfk_3` FOREIGN KEY (`IMAGE_ID`) REFERENCES `image` (`IMAGE_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `participant`\n\t\t\t\t\t\t\t ADD CONSTRAINT `participant_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `participant_ibfk_2` FOREIGN KEY (`CAEX_ID`) REFERENCES `calibration_exercise` (`CAEX_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `user_has_expertise`\n\t\t\t\t\t\t\t ADD CONSTRAINT `user_has_expertise_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,\n\t\t\t\t\t\t\t ADD CONSTRAINT `user_has_expertise_ibfk_2` FOREIGN KEY (`EXPE_ID`) REFERENCES `expertise` (`EXPE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `value_list`\n\t\t\t\t\t\t\t ADD CONSTRAINT `value_list_ibfk_1` FOREIGN KEY (`ATDE_ID`) REFERENCES `attribute_desc` (`ATDE_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `workshop`\n\t\t\t\t\t\t\t ADD CONSTRAINT `workshop_ibfk_1` FOREIGN KEY (`USER_ID`) REFERENCES `user` (`USER_ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tALTER TABLE `ws_info`\n\t\t\t\t\t\t\t ADD CONSTRAINT `ws_info_ibfk_1` FOREIGN KEY (`WORK_ID`) REFERENCES `workshop` (`WORK_ID`) ON DELETE CASCADE ON UPDATE NO ACTION\n\t\t \t\t ";
$attributeScript = "\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t-- Datenbank: `webgr`\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t-- Daten für Tabelle `user`\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tINSERT INTO `user` (`USER_ID`, `USER_USERNAME`, `USER_LASTNAME`, `USER_FIRSTNAME`, `USER_PASSWORD`, `USER_E_MAIL`, `USER_INSTITUTION`, `USER_STREET`, `USER_COUNTRY`, `USER_PHONE`, `USER_FAX`, `USER_CITY`, `USER_ACTIVE`, `USER_ROLE`, `USER_GUID`) VALUES\n\t\t\t\t\t\t\t(1, '*****@*****.**', 'Lastname', 'Firstname', '{SHA}jme7JrNY4u0g/lUu1vuDLzl6UH0=', '*****@*****.**', '255', 'Villichgasse', '234', '0228', '', 'Bonn', 1, 'admin', NULL);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t-- Datenbank: `webgr`\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t-- --------------------------------------------------------\n\t\t\t\t\t\t\t\n--\n-- Daten für Tabelle `attribute_desc`\n--\n\nINSERT INTO `attribute_desc` (`ATDE_ID`, `USER_ID`, `ATDE_NAME`, `ATDE_UNIT`, `ATDE_DESCRIPTION`, `ATDE_DEFAULT`, `ATDE_REQUIRED`, `ATDE_IS_STANDARD`, `ATDE_ACTIVE`, `ATDE_DATATYPE`, `ATDE_FORMTYPE`, `ATDE_VALUELIST`, `ATDE_SEQUENCE`, `ATDE_MULTIPLE`, `ATDE_SHOWINLIST`, `ATDE_GROUP`, `ATDE_FILTERS`, `ATDE_VALIDATORS`) VALUES\n(1, 1, 'LENGTH', '218', 'total length of the fish in millimeter', '', 0, 1, 1, 'decimal', 'text', 0, NULL, 0, 1, 'fish', NULL, NULL),\n(2, 1, 'WEIGHT', '220', 'weight of the fish sample in gramm', '', 0, 1, 1, 'decimal', 'text', 0, NULL, 0, 1, 'fish', NULL, NULL),\n(4, 1, 'RESOLUTION', '418', 'Image scan/print resolution in dots per inch', '', 0, 1, 1, 'decimal', 'text', 0, NULL, 0, 1, 'image', NULL, NULL),\n(8, 1, 'STOCK', '', 'Individual information/classification about fish stock, refers to the spatial distribution of a population', '', 0, 1, 1, 'string', 'text', 0, NULL, 0, 1, 'fish', NULL, NULL),\n(10, 1, 'ARCHIVING_CODE', '', 'Internal institute code to store the physical structure', '', 0, 1, 1, 'string', 'text', 0, NULL, 0, 1, 'fish', NULL, NULL),\n(13, 1, 'SEX', '', 'gender/sex of fish', '', 0, 1, 1, 'integer', 'radio', 1, 2, 0, 1, 'fish', NULL, NULL),\n(16, 1, 'AREA', '', 'referes to a geographic region, area code like ICES and NAFO', '', 0, 1, 1, 'string', 'text', 0, NULL, 0, 1, 'fish', NULL, NULL),\n(17, 1, 'CAPTURE_DATE', '', 'Date of capture of fish, format YYYY-MM-DD', '', 0, 1, 1, 'date', 'text', 0, NULL, 0, 1, 'fish', NULL, NULL),\n(24, 1, 'GEAR', '', '', '', 0, 0, 1, 'string', 'text', 0, NULL, 0, 0, 'fish', NULL, NULL),\n(30, 1, 'FISH_COMMENT', '', 'just additional comment to this dataset', '', 0, 0, 1, 'string', 'text', 0, NULL, 0, 0, 'fish', NULL, NULL),\n(31, 1, 'IMAGE_COMMENT', '', 'just additional comment to this dataset', '', 0, 0, 1, 'string', 'text', 0, NULL, 0, 0, 'image', NULL, NULL),\n(32, 1, 'MAGNIFICATION', '', 'Magnification of subject for image creation', '', 0, 0, 1, 'decimal', 'text', 0, NULL, 0, 1, 'image', NULL, NULL),\n(33, 1, 'PREPARATION_METHOD', '', 'Preparation method of subject shown on image', '', 0, 0, 1, 'string', 'text', 0, NULL, 0, 0, 'image', NULL, NULL),\n(501, 1, 'SAMPLING_DATE', NULL, 'Date of sampling of fish, format YYYY-MM-DD', NULL, 0, 1, 1, 'date', 'text', 0, 0, 0, 1, 'fish', NULL, NULL),\n(502, 1, 'OBSERVED_MATURITY_STAGE', NULL, 'Maturity stage observed before processing inside WebGR annotation', NULL, 0, 0, 1, 'string', 'text', 0, 0, 0, 1, 'fish', NULL, NULL),\n(503, 1, 'SAMPLING_INSTITUTE', NULL, 'institute of sampling the physical structure', NULL, 0, 0, 1, 'string', 'text', 0, 0, 0, 1, 'fish', NULL, NULL),\n(504, 1, 'ARCHIVING_INSTITUTE', NULL, 'institute of archiving the physical structure', NULL, 0, 0, 1, 'string', 'text', 0, 0, 0, 1, 'fish', NULL, NULL),\n(505, 1, 'RESPONSABLE_SCIENTIST', NULL, 'Responsable scientist to contact', NULL, 0, 0, 1, 'string', 'text', 0, 0, 0, 0, 'fish', NULL, NULL),\n(506, 1, 'SAMPLING_SOURCE', NULL, 'Sampling source', NULL, 0, 0, 1, 'integer', 'select', 1, 0, 0, 1, 'fish', NULL, NULL),\n(507, 1, 'LONGTITUDE', '1011', 'Longtitude of fish catch, measured in G (= degree), no degree sign, western hemisphere has negative sign', NULL, 0, 0, 1, 'decimal', 'text', 0, 0, 0, 1, 'fish', NULL, NULL),\n(508, 1, 'LATITUDE', '1011', 'Latitude of fish catch, measured in G (= degree), no degree sign, southern hemisphere has negative sign', NULL, 0, 0, 1, 'decimal', 'text', 0, 0, 0, 1, 'fish', NULL, NULL),\n(601, 1, 'Location', '', '', '', 0, 0, 1, 'integer', 'select', 1, NULL, 0, 0, 'system', NULL, NULL),\n(602, 1, 'Country', '', '', '', 0, 0, 1, 'integer', 'select', 1, NULL, 0, 0, 'system', NULL, NULL),\n(603, 1, 'Institution', '', '', '', 0, 0, 1, 'integer', 'select', 1, NULL, 0, 0, 'system', NULL, NULL),\n(604, 1, 'UNIT', NULL, NULL, NULL, 0, 0, 1, 'integer', 'select', 1, 0, 0, 0, 'system', NULL, NULL),\n(605, 1, 'SPECIES', '', 'Fish scientific name (latin)', '', 0, 0, 1, 'integer', 'select', 1, NULL, 0, 1, 'fish', NULL, NULL),\n(606, 1, 'TYPE_OF_STRUCTURE', NULL, 'Subject of visual analysis (otolith, gonad etc.)', NULL, 0, 1, 1, 'integer', 'select', 1, 1, 0, 1, 'image', NULL, NULL);\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tSET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t-- Datenbank: `webgr`\n\t\t\t\t\t\t\t--\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t-- --------------------------------------------------------\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\n--\n-- Daten für Tabelle `value_list`\n--\n\nINSERT INTO `value_list` (`VALI_ID`, `ATDE_ID`, `VALI_NAME`, `VALI_VALUE`) VALUES\n(215, 601, 'Bonn', 'Bonn'),\n(218, 604, 'mm', 'mm'),\n(219, 604, 'm', 'm'),\n(220, 604, 'g', 'g'),\n(221, 604, 'kg', 'kg'),\n(225, 602, 'Austria', 'Austria'),\n(226, 602, 'Belgium', 'Belgium'),\n(227, 602, 'Bulgaria', 'Bulgaria'),\n(228, 602, 'Cyprus', 'Cyprus'),\n(229, 602, 'Czech Republic', 'Czech Republic'),\n(230, 602, 'Denmark', 'Denmark'),\n(231, 602, 'Estonia', 'Estonia'),\n(232, 602, 'Finland', 'Finland'),\n(233, 602, 'France', 'France'),\n(234, 602, 'Germany', 'Germany'),\n(235, 602, 'Greece', 'Greece'),\n(236, 602, 'Hungary', 'Hungary'),\n(237, 602, 'Ireland', 'Ireland'),\n(238, 602, 'Italy', 'Italy'),\n(239, 602, 'Latvia', 'Latvia'),\n(240, 602, 'Lithuania', 'Lithuania'),\n(241, 602, 'Luxembourg', 'Luxembourg'),\n(242, 602, 'Malta', 'Malta'),\n(243, 602, 'Netherlands', 'Netherlands'),\n(244, 602, 'Poland', 'Poland'),\n(245, 602, 'Portugal', 'Portugal'),\n(246, 602, 'Romania', 'Romania'),\n(247, 602, 'Slovakia', 'Slovakia'),\n(248, 602, 'Slovenia', 'Slovenia'),\n(249, 602, 'Spain', 'Spain'),\n(250, 602, 'Sweden', 'Sweden'),\n(251, 602, 'United Kingdom', 'United Kingdom'),\n(252, 603, 'Laboratório Nacional de Recursos Biológicos – IPIMAR (Portugal) –', 'Laboratório Nacional de Recursos Biológicos – IPIMAR (Portugal)'),\n(253, 603, 'The Agri-Food & Biosciences Institute (UK)', 'The Agri-Food & Biosciences Institute (UK)'),\n(254, 603, 'AZTI Foundation (Spain)', 'AZTI Foundation (Spain)'),\n(255, 603, 'Federal Agency for Agriculture and Food (Germany)', 'Federal Agency for Agriculture and Food (Germany)'),\n(256, 603, 'Johann Heinrich von Thünen Institute (Germany)', 'Johann Heinrich von Thünen Institute (Germany)'),\n(257, 603, 'Hellenic Centre for Marine Research (Greece)', 'Hellenic Centre for Marine Research (Greece)'),\n(258, 603, 'Instituto Español de Oceanografia (Spain)', 'Instituto Español de Oceanografia (Spain)'),\n(259, 603, 'Institut français de recherche pour l’exploitation de la mer (France)', 'Institut français de recherche pour l’exploitation de la mer (France)'),\n(260, 603, 'Wageningen IMARES (The Netherlands)', 'Wageningen IMARES (The Netherlands)'),\n(261, 603, 'Institute of Marine Research (Norway)', 'Institute of Marine Research (Norway)'),\n(262, 603, 'Swedish Board of Fisheries (Sweden)', 'Swedish Board of Fisheries (Sweden)'),\n(263, 603, 'Italian Society for Marine Biology (Italy)', 'Italian Society for Marine Biology (Italy)'),\n(266, 13, 'female', 'female'),\n(267, 13, 'male', 'male'),\n(268, 13, 'undefined', 'undefined'),\n(269, 601, 'Sukarrieta', 'Sukarrieta'),\n(401, 605, 'Clupea harengus', 'Clupea harengus'),\n(402, 605, 'Engraulis encrasicolus', 'Engraulis encrasicolus'),\n(403, 605, 'Gadus morhua', 'Gadus morhua'),\n(404, 605, 'Limanda limanda', 'Limanda limanda'),\n(405, 605, 'Melanogrammus aeglefiunus', 'Melanogrammus aeglefiunus'),\n(406, 605, 'Merlangius merlangus', 'Merlangius merlangus'),\n(407, 605, 'Merluccius merluccius', 'Merluccius merluccius'),\n(408, 605, 'Micromesistius poutassou', 'Micromesistius poutassou'),\n(409, 605, 'Platichthys flesus', 'Platichthys flesus'),\n(410, 605, 'Pleuronectes platessa', 'Pleuronectes platessa'),\n(411, 605, 'Psetta maxima', 'Psetta maxima'),\n(412, 605, 'Sardina pilchardus', 'Sardina pilchardus'),\n(413, 605, 'Scomber scombrus', 'Scomber scombrus'),\n(414, 605, 'Scophthalmus rhombus', 'Scophthalmus rhombus'),\n(415, 605, 'Solea solea', 'Solea solea'),\n(416, 605, 'Sprattus sprattus', 'Sprattus sprattus'),\n(417, 605, 'Trachurus trachurus', 'Trachurus trachurus'),\n(418, 604, 'dpi', 'dpi'),\n(419, 603, 'Guest', 'Guest'),\n(420, 605, 'Mullus surmuletus', 'Mullus surmuletus'),\n(421, 605, 'Pollachius virens', 'Pollachius virens'),\n(426, 605, 'Glyptocephalus cynoglossus', 'Glyptocephalus cynoglossus'),\n(1001, 606, 'gonad', 'gonad'),\n(1002, 606, 'otolith', 'otolith'),\n(1003, 606, 'spine', 'spine'),\n(1004, 606, 'scale', 'scale'),\n(1005, 606, 'operculum', 'operculum'),\n(1006, 606, 'illicium', 'illicium'),\n(1007, 606, 'egg', 'egg'),\n(1008, 606, 'vertebra', 'vertebra'),\n(1009, 606, 'fin rays', 'fin rays'),\n(1010, 606, 'bone', 'bone'),\n(1011, 604, 'degree', 'degree'),\n(1012, 506, 'harbour', 'harbour'),\n(1013, 506, 'survey', 'survey'),\n(1014, 506, 'self sampling', 'self sampling'),\n(1015, 506, 'on-board', 'on-board'),\n(1016, 602, 'Norway', 'Norway'),\n(1017, 603, 'CEFAS', 'CEFAS'),\n(1019, 602, 'other', 'other'),\n(1020, 605, 'Lepidorhombus whiffiagonis', 'Lepidorhombus whiffiagonis');";
$installSqriptArray = explode(';', $installScript);
$attributeScriptArray = explode(';', $attributeScript);
try {
$dbAdapter->beginTransaction();
foreach ($installSqriptArray as $script) {
$dbAdapter->query($script);
}
$dbAdapter->commit();
try {
foreach ($attributeScriptArray as $script) {
if (!empty($script)) {
$dbAdapter->query($script);
}
}
$dbAdapter->commit();
} catch (Exception $e) {
$dbAdapter->rollBack();
$error = true;
$errorMassage = "Error while inserting the sample data: " . $e->getMessage();
}
} catch (Exception $e) {
$dbAdapter->rollBack();
$error = true;
$errorMassage = "Error while installing the db structure: " . $e->getMessage();
}
if ($error) {
$this->view->massage = $errorMassage;
} else {
$this->view->massage = '<span style="color:green">installed sucessful.</span>';
}
} else {
$this->view->massage = 'Your database is not empty.';
}
} else {
$this->view->massage = $errorMassage;
}
} else {
$this->view->massage = 'The security key is not correct.';
}
}
}
$this->view->form = $form;
}
/**
* Reboot a server
*
* Allow user reboot via management card, power strip, or both.
*/
public function rebootAction()
{
$hardware = null;
$rebootSuccessful = false;
if ($this->_getParam('id') == null) {
$this->view->errorMessage = $this->view->translate->_('Please provide a hardware id.');
} else {
$client = SoftLayer_SoapClient::getClient('SoftLayer_Hardware_Server', $this->_getParam('id'));
/*
* Build the reboot form.
*/
$form = new Zend_Form();
$form->setMethod('post');
$rebootMethod = $form->createElement('select', 'rebootMethod');
$rebootMethod->setLabel(ucfirst($this->view->translate->_('reboot via')));
$rebootMethod->addMultiOptions(array('rebootDefault' => $this->view->translate->_('management card with powerstrip fallback'), 'rebootSoft' => $this->view->translate->_('management card only'), 'powerCycle' => $this->view->translate->_('power strip only')));
$rebootMethod->setRequired(true);
$form->addElement($rebootMethod);
$form->addElement('submit', 'reboot', array('label' => ucfirst($this->view->translate->_('reboot'))));
/*
* Get hardware info.
*/
$objectMask = new SoftLayer_ObjectMask();
$objectMask->recentRemoteManagementCommands;
$client->setObjectMask($objectMask);
try {
$hardware = $client->getObject();
} catch (Exception $e) {
$this->view->errorMessage = $this->translate->_('Error retrieving hardware record.') . ' ' . $e->getMessage();
}
/*
* Handle the reboot request.
*/
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData)) {
try {
switch ($form->getValue('rebootMethod')) {
case 'rebootDefault':
$result = $client->rebootDefault();
break;
case 'rebootSoft':
$result = $client->rebootSoft();
break;
case 'powerCycle':
$result = $client->powerCycle();
break;
}
$rebootSuccessful = true;
} catch (Exception $e) {
$this->view->errorMessage = $this->view->translate->_('Reboot failed.') . ' ' . $e->getMessage();
}
} else {
$this->view->errorMessage = $this->view->translate->_('Reboot failed.') . ' ' . $this->view->translate->_('Please completely fill out the reboot form.');
$form->populate($formData);
}
}
}
if ($hardware != null) {
$this->view->pageTitle = ucfirst($this->view->translate->_('reboot')) . ' ' . $hardware->hostname . '.' . $hardware->domain;
$this->view->headTitle(ucfirst($this->view->translate->_('reboot')) . ' ' . $hardware->hostname . '.' . $hardware->domain);
$this->view->form = $form;
}
$this->view->rebootSuccessful = $rebootSuccessful;
$this->view->hardware = $hardware;
}
/**
* Подготовка массива для регистрации
*
* @param Zend_Form $form
* @return array
*/
protected function _makeInsertRegistration($form)
{
return array('salt' => $form->getValue('salt'), 'active' => 1, 'email' => $form->getValue('email'), 'name' => $form->getValue('name'), 'sername' => $form->getValue('sername'), 'role_name' => 'user', 'password' => md5(Zend_Registry::get('config')->Db->staticSalt . md5($form->getValue('password')) . $form->getValue('salt')), 'username' => $form->getValue('username'));
}
public function setModel(Zend_Form $form, \Model\Instruction $model)
{
$values = $form->getValue("basic");
$model->name = $values['name'];
$model->active = $values['active'];
}
public function editlanguageAction()
{
$language = null;
$config = Zend_Registry::get('config');
/*
* Retrieve the language.
*/
try {
$language = new Model_Language($this->_getParam('name'));
} catch (Exception $e) {
$this->view->errorMessage = $this->translate->_('Unable to locate language.') . ' ' . $e->getMessage();
}
if ($language != null) {
/*
* Build the delete form. Only show it if the language is not the default system language.
*/
$deleteForm = null;
if ($language->name != $config->defaults->language) {
$deleteForm = new Zend_Form();
$deleteForm->setMethod('post');
$hidden = $deleteForm->createElement('hidden', 'mode');
$hidden->setValue('delete');
$deleteForm->addElement($hidden);
$deleteForm->addElement('submit', 'submit', array('label' => $this->view->translate->_('Submit')));
}
/*
* Build the edit forms. One for the logo, one for the css.
*/
$languages = Model_Language::getAllLanguages();
$form = new Zend_Form();
$form->setMethod('post');
$lang = $form->createElement('textarea', 'language');
$lang->setRequired(true);
$lang->setValue($language->getLanguageContent());
$lang->setAttrib('rows', '24');
$lang->setAttrib('cols', '80');
$lang->setAttrib('style', 'margin-left: 60px;');
$hidden = $form->createElement('hidden', 'mode');
$hidden->setValue('edit');
$form->addElement($lang);
$form->addElement($hidden);
$form->addElement('submit', 'submit', array('label' => $this->view->translate->_('Submit')));
/*
* Process form submission.
*/
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
switch ($formData['mode']) {
/*
* Delete the language.
*/
case 'delete':
/*
* You may not delete the default system language.
*/
if ($language->name == $config->defaults->language) {
$this->view->errorMessage = $this->view->translate->_('You may not delete the default system language.');
} else {
try {
$language->deleteLanguage();
$this->_helper->_redirector->goToRouteAndExit(array('controller' => 'admin', 'action' => 'languages', 'id' => null, 'name' => null));
} catch (Exception $e) {
$this->view->errorMessage = $this->view->translate->_('Unable to delete language.') . ' ' . $e->getMessage();
}
}
break;
/*
* Change the language's content.
*/
/*
* Change the language's content.
*/
case 'edit':
if ($form->isValid($formData)) {
try {
$language->updateLanguage($form->getValue('language'));
$this->view->statusMessage = $this->view->translate->_('Language saved.');
} catch (Exception $e) {
$this->view->errorMessage = $this->view->translate->_('Unable to save language.') . ' ' . $e->getMessage();
}
} else {
$this->view->errorMessage = $this->view->translate->_('Please completely fill out the configuration form.');
}
$form->populate($formData);
break;
}
}
$this->view->pageTitle = $this->view->translate->_('Edit') . ' ' . $language->name;
$this->view->headTitle($this->view->translate->_('Edit') . ' ' . $language->name);
$this->view->form = $form;
$this->view->deleteForm = $deleteForm;
}
$this->view->language = $language;
}
