Commits

Richard Lovelock  committed 3dd1dcd

Added upgrade changes to the install script

  • Participants
  • Parent commits c57b1f0

Comments (0)

Files changed (2)

File system/application/libraries/install/data.sql.php

 INSERT INTO `settings` VALUES ('offline_message_admin', '!site-name! is offline', 'Site offline admin message', 'Message to display in banner
  to admin whilst site is offline', 'site_status', 'text');
 
+-- command split --
+
+INSERT INTO `settings` VALUES ('debug', '1', 'Show debug output', 'Show PHP errors and Firephp output', 'debug', 'select_list', '0 debug is off, 1 debug for admin users, 2 debug for all users (emergency use only)');

File system/application/libraries/install/tables.sql.php

   `whitelist` int(1) NOT NULL default '0',
   `email_events_attending` int(1) NOT NULL default '1',
   `do_not_use_editor` int(1) NOT NULL default '0',
-  `email_message_notify`  int(1) NOT NULL DEFAULT 1 ,  
+  `email_message_notify`  int(1) NOT NULL DEFAULT 1 , 
+  `deleted` int(1) NOT NULL default '0',   
   UNIQUE KEY `id` (`id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
   `author_user_id`  int(10) NOT NULL ,
   `content`  longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
   `created`  int(10) NOT NULL ,
+  `moderate` int(1) NOT NULL DEFAULT '0',  
   PRIMARY KEY (`message_id`)
 ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
   COMMENT='Message information, relates to the original author';
   `subject`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
   `author_user_id`  int(10) NOT NULL ,
   `created`  int(10) NULL DEFAULT NULL ,
+  `moderate` int(1) NOT NULL DEFAULT '0',  
   PRIMARY KEY (`thread_id`)
 ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci 
   COMMENT='Information about threads, relates to original author';