function alerts_install

6.x alerts.install alerts_install()

Hook install. Called when the module is installed on the admin modules page.

File

modules/alerts/alerts.install, line 13

Code

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






}