public function install()
{
$q = $this->_getQuery();
$q->createTable('resources');
$q->createDefinition('(
resource_id integer not null auto_increment,
resource_name varchar(255) not null default "",
resource_key varchar(64) not null default "",
resource_type integer not null default 0,
resource_note text not null default "",
resource_max_allocation integer not null default 100,
primary key (resource_id),
key (resource_name),
key (resource_type)
) ENGINE = MYISAM DEFAULT CHARSET=utf8 ');
if (!$q->exec()) {
return false;
}
$q->clear();
$q->createTable('resource_tasks');
$q->createDefinition('(
resource_id integer not null default 0,
task_id integer not null default 0,
percent_allocated integer not null default 100,
key (resource_id),
key (task_id, resource_id)
) ENGINE = MYISAM DEFAULT CHARSET=utf8 ');
if (!$q->exec()) {
return false;
}
$this->addTypes();
return parent::install();
}
public function install()
{
$result = $this->_checkRequirements();
if (!$result) {
return false;
}
$q = $this->_getQuery();
$q->createTable('links');
$q->createDefinition('(
link_id int( 11 ) NOT NULL AUTO_INCREMENT ,
link_url varchar( 255 ) NOT NULL default "",
link_project int( 11 ) NOT NULL default "0",
link_task int( 11 ) NOT NULL default "0",
link_name varchar( 255 ) NOT NULL default "",
link_parent int( 11 ) default "0",
link_description text,
link_owner int( 11 ) default "0",
link_date datetime default NULL ,
link_icon varchar( 20 ) default "obj/",
link_category int( 11 ) NOT NULL default "0",
PRIMARY KEY ( link_id ) ,
KEY idx_link_task ( link_task ) ,
KEY idx_link_project ( link_project ) ,
KEY idx_link_parent ( link_parent )
) ENGINE = MYISAM DEFAULT CHARSET=utf8 ');
if (!$q->exec()) {
return false;
}
$i = 0;
$linkTypes = array('Unknown', 'Document', 'Application');
//TODO: refactor as proper sysvals handling
foreach ($linkTypes as $linkType) {
$q = $this->_getQuery();
$q->addTable('sysvals');
$q->addInsert('sysval_key_id', 1);
$q->addInsert('sysval_title', 'LinkType');
$q->addInsert('sysval_value', $linkType);
$q->addInsert('sysval_value_id', $i);
$q->exec();
$i++;
}
return parent::install();
}
public function install()
{
$q = $this->_getQuery();
$q->createTable('history');
$q->createDefinition('(
history_id int(10) unsigned NOT NULL auto_increment,
history_date datetime NOT NULL default \'0000-00-00 00:00:00\',
history_user int(10) NOT NULL default \'0\',
history_action varchar(20) NOT NULL default \'modify\',
history_item int(10) NOT NULL,
history_table varchar(20) NOT NULL default \'\',
history_project int(10) NOT NULL default \'0\',
history_name varchar(255),
history_changes text,
history_description text,
PRIMARY KEY (history_id),
INDEX index_history_module (history_table, history_item),
INDEX index_history_item (history_item)
) ENGINE = MYISAM DEFAULT CHARSET=utf8 ');
if (!$q->exec()) {
return false;
}
return parent::install();
}
public function install()
{
$result = $this->_checkRequirements();
if (!$result) {
//$AppUI->setMsg($this->getErrors(), UI_MSG_ERROR);
}
$q = $this->_getQuery();
$q->createTable('project_designer_options');
$q->createDefinition('(
pd_option_id INT(11) NOT NULL auto_increment,
pd_option_user INT(11) NOT NULL default 0 UNIQUE,
pd_option_view_project INT(1) NOT NULL default 1,
pd_option_view_gantt INT(1) NOT NULL default 1,
pd_option_view_tasks INT(1) NOT NULL default 1,
pd_option_view_actions INT(1) NOT NULL default 1,
pd_option_view_addtasks INT(1) NOT NULL default 1,
pd_option_view_files INT(1) NOT NULL default 1,
PRIMARY KEY (pd_option_id)
) ENGINE = MYISAM DEFAULT CHARSET=utf8 ');
if (!$q->exec()) {
return false;
}
return parent::install();
}