1 #IfMissingColumn users calendar
3 ADD `calendar` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 = appears in calendar';
4 UPDATE users SET calendar = 1 WHERE authorized = 1 AND ( info IS NULL OR info NOT LIKE '%Nocalendar%' );
7 #IfNotRow2D list_options list_id lists option_id lbfnames
8 INSERT INTO list_options VALUES ('lists','lbfnames','Layout-Based Visit Forms',9,0,0);
12 CREATE TABLE `lbf_data` (
13 `form_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'references forms.form_id',
14 `field_id` varchar(31) NOT NULL COMMENT 'references layout_options.field_id',
15 `field_value` varchar(255) NOT NULL,
16 PRIMARY KEY (`form_id`,`field_id`)
17 ) ENGINE=MyISAM COMMENT='contains all data from layout-based forms';