/
086-088-a.sql
22 lines (22 loc) · 4.9 KB
/
086-088-a.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
UPDATE `<?php echo $table_prefix ?>config_options` set `value` = 'marine' where `category_name` = 'general' and `name` = 'theme';
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('features', 'login_show_options', '1', 'BoolConfigHandler', 0, 0, 'Show options on the login page') ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_categories` (`name`, `is_system`, `category_order`) VALUES ('authentication', 0, 8);
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('authentication', 'authdb server', 'localhost', 'StringConfigHandler', 0, 1, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('authentication', 'authdb username', 'root', 'StringConfigHandler', 0, 2, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('authentication', 'authdb password', '', 'PasswordConfigHandler', 0, 3, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('authentication', 'authdb database', '', 'StringConfigHandler', 0, 3, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('authentication', 'authdb sql', "select `user_email` as email from `wp_users` where `user_login` = '$username' and user_pass = md5('$password') limit 1", 'StringConfigHandler', 0, 4, NULL);
ALTER TABLE `<?php echo $table_prefix ?>wiki_pages` ADD `parent_id` INT( 10 ) NOT NULL DEFAULT 0 AFTER `id`;
CREATE UNIQUE INDEX `subpages` ON `<?php echo $table_prefix ?>wiki_pages` ( `parent_id`, `id` );
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('general', 'dashboard_logs_count', '50', 'IntegerConfigHandler', 0, 27, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('general', 'map url', 'http://maps.google.com?q=$location', 'StringConfigHandler', 0, 3, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('general', 'route url', 'http://maps.google.com?saddr=$from&daddr=$to', 'StringConfigHandler', 0, 3, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
INSERT INTO `<?php echo $table_prefix ?>config_options` (`category_name`, `name`, `value`, `config_handler_class`, `is_system`, `option_order`, `dev_comment`) VALUES ('general', 'parking space reservation url', '', 'StringConfigHandler', 0, 3, NULL) ON DUPLICATE KEY UPDATE `name` = `name`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `first_name` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `display_name`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `middle_name` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `first_name`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `last_name` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `middle_name`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `license_plate` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `home_number`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `food_preferences` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `license_plate`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `department_details` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `food_preferences`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `location_details` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `department_details`;
ALTER TABLE `<?php echo $table_prefix ?>contacts` ADD `language_preferences` VARCHAR( 50 ) <?php echo $default_charset ?> <?php echo $default_collation ?> NOT NULL DEFAULT '' AFTER `location_details`;