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"); }