Changed the themes module.

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Changed the settings module to use dbforge, half-way through converting the settings insertions to use the settings library.

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Trying to get all keys and indexes properly handled. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the blog module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the comments module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the contact module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the files module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the groups module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the keywords module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the navigation module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the pages module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Converted the settings module to use dbforge. (#1150)

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Small fix in Module.php
Getting the models included hideously for groups, navigation, pages, (no modular extensions while in installer).
Fixing some table definitions for variables and widgets modules.

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Installer now works.
Reverted to using $this->db->insert() for inserting the default records of modules. Pity we can't use the libraries and models.
Made final changes so that there are minimum deviations from the original schema.
Through the process of converting in general, some changes to the schema occurred:

CREATE UNIQUE INDEX `unique_title` ON `default_blog`(`title`) USING BTREE ;
CREATE INDEX `category_id` ON `default_blog`(`category_id`) USING BTREE ;
ALTER TABLE `default_blog` DROP INDEX `title`;
ALTER TABLE `default_blog` DROP INDEX `category_id - normal`;
CREATE UNIQUE INDEX `unique_slug` ON `default_blog_categories`(`slug`) USING BTREE ;
CREATE UNIQUE INDEX `unique_title` ON `default_blog_categories`(`title`) USING BTREE ;
CREATE INDEX `slug` ON `default_blog_categories`(`slug`) USING BTREE ;
ALTER TABLE `default_blog_categories` DROP INDEX `slug - unique`;
ALTER TABLE `default_blog_categories` DROP INDEX `title - unique`;
ALTER TABLE `default_blog_categories` DROP INDEX `slug - normal`;
ALTER TABLE `default_comments` MODIFY COLUMN `id`  int(11) NOT NULL FIRST ;
ALTER TABLE `default_comments` MODIFY COLUMN `is_active`  int(1) NOT NULL DEFAULT 0 AFTER `id`;
ALTER TABLE `default_comments` MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ;
ALTER TABLE `default_contact_log` MODIFY COLUMN `id`  int(11) NOT NULL FIRST ;
ALTER TABLE `default_contact_log` MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ;
ALTER TABLE `default_email_templates` ENGINE=InnoDB,
ROW_FORMAT=Compact;
ALTER TABLE `default_files` ENGINE=InnoDB,
ROW_FORMAT=Compact;
ALTER TABLE `default_file_folders` ENGINE=InnoDB,
ROW_FORMAT=Compact;
ALTER TABLE `default_navigation_links` MODIFY COLUMN `target`  varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `position`;
ALTER TABLE `default_navigation_links` MODIFY COLUMN `restricted_to`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `target`;
CREATE INDEX `navigation_group_id` ON `default_navigation_links`(`navigation_group_id`) USING BTREE ;
ALTER TABLE `default_pages` DROP INDEX `parent`;
ALTER TABLE `default_pages` MODIFY COLUMN `id`  int(11) NOT NULL FIRST ;
ALTER TABLE `default_pages` MODIFY COLUMN `parent_id`  int(11) NOT NULL DEFAULT 0 AFTER `uri`;
ALTER TABLE `default_pages` MODIFY COLUMN `is_home`  int(1) NOT NULL DEFAULT 0 AFTER `restricted_to`;
CREATE INDEX `parent_id` ON `default_pages`(`parent_id`) USING BTREE ;
ALTER TABLE `default_pages` MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ;
ALTER TABLE `default_page_layouts` MODIFY COLUMN `id`  int(11) NOT NULL FIRST ;
ALTER TABLE `default_page_layouts` MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ;
ALTER TABLE `default_redirects` DROP INDEX `request`;
ALTER TABLE `default_redirects` MODIFY COLUMN `from`  varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `id`;
ALTER TABLE `default_redirects` MODIFY COLUMN `to`  varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL AFTER `from`;
CREATE INDEX `from` ON `default_redirects`(`from`) USING BTREE ;
ALTER TABLE `default_redirects` ENGINE=InnoDB,
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci,
ROW_FORMAT=Compact;
ALTER TABLE `default_settings` DROP INDEX `index - slug`;
ALTER TABLE `default_settings` DROP INDEX `unique - slug`;
ALTER TABLE `default_settings` MODIFY COLUMN `is_required`  int(1) NOT NULL AFTER `options`;
ALTER TABLE `default_settings` MODIFY COLUMN `is_gui`  int(1) NOT NULL AFTER `is_required`;
ALTER TABLE `default_settings` MODIFY COLUMN `order`  int(10) NOT NULL DEFAULT 0 AFTER `module`;
CREATE UNIQUE INDEX `unique_slug` ON `default_settings`(`slug`) USING BTREE ;
CREATE INDEX `slug` ON `default_settings`(`slug`) USING BTREE ;
ALTER TABLE `default_theme_options` MODIFY COLUMN `id`  int(11) NOT NULL FIRST ;
ALTER TABLE `default_theme_options` MODIFY COLUMN `is_required`  int(1) NOT NULL AFTER `options`;
ALTER TABLE `default_theme_options` MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ;
ALTER TABLE `default_variables` ENGINE=InnoDB,
ROW_FORMAT=Compact;
ALTER TABLE `default_widgets` MODIFY COLUMN `enabled`  int(1) NOT NULL DEFAULT 1 AFTER `version`;
ALTER TABLE `default_widgets` MODIFY COLUMN `order`  int(10) NOT NULL DEFAULT 0 AFTER `enabled`;
ALTER TABLE `default_widget_areas` DROP INDEX `unique_slug`;

Basically most are index name changes, there are some column type changes (tinyint -> int) to help with the multi-database compatibility and some constraint changes just to make everything more uniform (id with int(5) turned to id with int(11) as it is more commonly used throughout the rest of the tables).

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
#1150 Done, fixed default email and lang settings values. Also set the default theme to `base` instead of `default` following 02acb11b0024cd65ca860702763fdfa57a2589b2

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Removing the need for model loading. Thanks @philsturgeon

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Removed unnecessary comments, and replaced radio button default values (and some values) with booleans

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
INDEX is a synonym for KEY.

Signed-off-by: George Petsagourakis <petsagouris@gmail.com>
Merge pull request #1171 from petsagouris/modules-use-dbforge

Switched module installation to use DBForge. Wahey!
Fixed incorrect profile edit message and a bug when an admin edited another user's profile