alerts.install
Search API
File
modules/alerts/alerts.installView source
- <?php
-
- /**
- * This file should contain only hooks relating to installing, enabling, disabling, and uninstalling this module.
- *
- */
-
-
- /**
- * Hook install. Called when the module is installed on the admin modules page.
- *
- */
- function alerts_install() {
-
- $q = "
- CREATE TABLE `content__alert` (
- `cid` int(10) unsigned NOT NULL,
- `vid` int(10) unsigned NOT NULL,
- `field__student_id` varchar(255) DEFAULT NULL,
- `field__target_faculty_id` varchar(255) DEFAULT NULL,
- `field__exclude_advisor` tinyint(4) DEFAULT 0,
- `field__alert_status` varchar(255) DEFAULT NULL,
- `field__tags` text DEFAULT NULL,
- `field__alert_msg` longtext DEFAULT NULL,
- `field__visibility` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`vid`),
- KEY `cid` (`cid`),
- KEY `field__student_id` (`field__student_id`),
- KEY `field__alert_status` (`field__alert_status`),
- KEY `field__alert_msg` (`field__alert_msg`(768)),
- KEY `field__visibility` (`field__visibility`),
- KEY `field__exclude_advisor` (`field__exclude_advisor`),
- KEY `field__target_faculty_id` (`field__target_faculty_id`),
- KEY `field__tags` (`field__tags`(500))
- );
- ";
- db_query($q);
-
-
-
-
-
-
-
- $q = "
- CREATE TABLE `content__activity_record` (
- `cid` int unsigned NOT NULL,
- `vid` int unsigned NOT NULL,
- `field__student_id` varchar(255) DEFAULT NULL,
- `field__faculty_id` varchar(255) DEFAULT NULL,
- `field__activity_type` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`vid`) ,
- KEY `cid` (`cid`) ,
- KEY `field__student_id` (`field__student_id`) ,
- KEY `field__alert_status` (`field__activity_type`),
- KEY `field__faculty_id` (`field__faculty_id`)
- );
- ";
- db_query($q);
-
-
-
-
-
-
- } // hook_install
-
-
- function alerts_update($old_schema, $new_schema) {
-
- if (intval($old_schema) < 2) {
- // Convert text fields to longtext.
- db_query("ALTER TABLE content__alert MODIFY field__alert_msg LONGTEXT");
- fpm("Altered content__alert to use LONGTEXT instead of just TEXT.");
-
- }
-
- if (intval($old_schema) < 3) {
- // Get rid of "field__department", add "field__tags"
- db_query("ALTER TABLE content__alert DROP COLUMN field__department ");
- db_query("ALTER TABLE content__alert ADD COLUMN `field__tags` text DEFAULT NULL ");
- db_query("ALTER TABLE content__alert ADD INDEX (`field__tags`(500)) ");
-
-
- }
-
-
- if ($old_schema < 4) {
- db_query('ALTER TABLE content__alert ADD COLUMN field__target_faculty_id varchar(255) DEFAULT NULL');
- db_query('ALTER TABLE content__alert ADD COLUMN field__exclude_advisor tinyint(4) DEFAULT 0');
-
- db_query("ALTER TABLE content__alert ADD INDEX (`field__exclude_advisor`) ");
- db_query("ALTER TABLE content__alert ADD INDEX (`field__target_faculty_id`) ");
-
-
- }
-
-
- } // hook_update
-
-
-
Functions
Name | Description |
---|---|
alerts_install | Hook install. Called when the module is installed on the admin modules page. |
alerts_update |