function getInitSQL()
{
$res = (array) parent::getInitSQL();
$res[] = 'INSERT INTO service_component_category
(category_name, runsheet_title_format, handout_title_format, length_mins_default)
VALUES
("Songs", "Song: %title%", "Song: %title%", 3),
("Prayers", "%title%", "%title%", 2),
("Creeds", "The %title%", "The %title%", 2),
("Other", "%title%", "%title%", 1);';
return $res;
}
function getInitSQL()
{
$res = (array) parent::getInitSQL();
$res[] = 'INSERT INTO service_component_category
(category_name, runsheet_title_format, handout_title_format, length_mins_default, personnel_default)
VALUES
("Songs", "Song: %title%", "Song: %title%", 3, "%SONG_LEADER_FIRSTNAME%"),
("Prayers", "%title%", "%title%", 2, "%SERVICE_LEADER_FIRSTNAME%"),
("Creeds", "The %title%", "The %title%", 2, "%SERVICE_LEADER_FIRSTNAME%"),
("Other", "%title%", "%title%", 1, "");';
return $res;
}
function getInitSQL()
{
// Need to create the group-membership table as well as the group table
return array(parent::getInitSQL('_person_group'), "CREATE TABLE person_group_membership_status (\n\t\t\t\t\tid INT AUTO_INCREMENT PRIMARY KEY,\n\t\t\t\t\tlabel VARCHAR(255) NOT NULL,\n\t\t\t\t\trank int not null default 0,\n\t\t\t\t\tis_default TINYINT(1) UNSIGNED DEFAULT 0,\n\t\t\t\t\tCONSTRAINT UNIQUE INDEX (label)\n\t\t\t\t) ENGINE=InnoDB;", "INSERT INTO person_group_membership_status (label, is_default)\n\t\t\t\tVALUES ('Member', 1);", "CREATE TABLE `person_group_membership` (\n\t\t\t\t `personid` int(11) NOT NULL default '0',\n\t\t\t\t `groupid` int(11) NOT NULL default '0',\n\t\t\t\t `membership_status` int DEFAULT NULL,\n\t\t\t\t `created` timestamp NOT NULL default CURRENT_TIMESTAMP,\n\t\t\t\t PRIMARY KEY (`personid`,`groupid`),\n\t\t\t\t INDEX personid (personid),\n\t\t\t\t INDEX groupid (groupid),\n\t\t\t\t CONSTRAINT `membership_status_fk` FOREIGN KEY (membership_status) REFERENCES person_group_membership_status (id) ON DELETE SET NULL\n\t\t\t\t) ENGINE=InnoDB");
}
