private function createAuthorityPermissionsTable() {

        //Drop the authority table if exists, create if doesn't
        $this->database->query("DROP TABLE IF EXISTS `?authority_permissions`;");
        $this->database->query(
            "CREATE TABLE IF NOT EXISTS `?authority_permissions` (
                `authority_permission_key` bigint(20) NOT NULL AUTO_INCREMENT,
                `authority_id` bigint(20) NOT NULL,
                `permission_area_uri` varchar(255) NOT NULL,
                `permission` varchar(45) NOT NULL DEFAULT '1',
                `permission_type` varchar(45) NOT NULL,
                `permission_title` varchar(45) NOT NULL,
                PRIMARY KEY (`authority_permission_key`),
                UNIQUE KEY `UNIQUE` (`permission_area_uri`,`permission_type`,`authority_id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"
        );
        //Dumping default permission data to authority_permission tablegit
        $this->database->query(
            "INSERT INTO `?authority_permissions` (`authority_permission_key`, `authority_id`, `permission_area_uri`, `permission`, `permission_type`, `permission_title`) VALUES
                (1,	4,	'^/admin(/[a-z0-9-]*)*',	'allow',	'special',	'Console'),
                (2,	1,	'^/admin/setup/install(/[a-z0-9-]*)*',	'allow',	'execute',	'Installer'),
                (3,	4,	'^/page(/[a-z0-9-]*)*',	'allow',	'execute',	'Content'),
                (4,	2,	'^/member(/[a-z0-9-]*)*',	'allow',	'execute',	'Member Pages'),
                (5,	1,	'^/member/sign([a-z0-9-]*)*',	'allow',	'execute',	'Authentication'),
                (6,	2,	'^/message(/[a-z0-9-]*)*',	'allow',	'execute',	'Messages'),
                (7,	1,	'^/search(/[a-z0-9-]*)*',	'allow',	'execute',	'Search'),
                (8,	4,	'^/listing(/[a-z0-9-]*)*',	'allow',	'special',	'Directory'),
                (9,	2,	'^/notification(/[a-z0-9-]*)*',	'allow',	'execute',	'Messages'),
                (10,	1,	'^/post(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (11,	1,	'^/event(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (12,	1,	'^/stream(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (13,	1,	'^/group(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (14,	1,	'^/file(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (16,	2,	'^/post(/[a-z0-9-]*)*',	'allow',	'execute',	'Content'),
                (15,	1,	'^/page(/[a-z0-9-]*)*',	'allow',	'view',	'Content');"
        );
    }
private function createAuthorityPermissionsTable() {

        //Drop the authority table if exists, create if doesn't
        $this->database->query("DROP TABLE IF EXISTS `?authority_permissions`;");
        $this->database->query(
            "CREATE TABLE IF NOT EXISTS `?authority_permissions` (
                `authority_permission_key` bigint(20) NOT NULL AUTO_INCREMENT,
                `authority_id` bigint(20) NOT NULL,
                `permission_area_uri` varchar(255) NOT NULL,
                `permission` varchar(45) NOT NULL DEFAULT '1',
                `permission_type` varchar(45) NOT NULL,
                `permission_title` varchar(45) NOT NULL,
                PRIMARY KEY (`authority_permission_key`),
                UNIQUE KEY `UNIQUE` (`permission_area_uri`,`permission_type`,`authority_id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"
        );
        //Dumping default permission data to authority_permission tablegit
        $this->database->query(
            "INSERT INTO `?authority_permissions` (`authority_permission_key`, `authority_id`, `permission_area_uri`, `permission`, `permission_type`, `permission_title`) VALUES
                (1,	4,	'^/admin(/[a-z0-9-]*)*',	'allow',	'special',	'Console'),
                (2,	1,	'^/admin/setup/install(/[a-z0-9-]*)*',	'allow',	'execute',	'Installer'),
                (3,	4,	'^/page(/[a-z0-9-]*)*',	'allow',	'execute',	'Content'),
                (4,	2,	'^/member(/[a-z0-9-]*)*',	'allow',	'execute',	'Member Pages'),
                (5,	1,	'^/member/sign([a-z0-9-]*)*',	'allow',	'execute',	'Authentication'),
                (6,	2,	'^/message(/[a-z0-9-]*)*',	'allow',	'execute',	'Messages'),
                (7,	1,	'^/search(/[a-z0-9-]*)*',	'allow',	'execute',	'Search'),
                (8,	4,	'^/listing(/[a-z0-9-]*)*',	'allow',	'special',	'Directory'),
                (9,	2,	'^/notification(/[a-z0-9-]*)*',	'allow',	'execute',	'Messages'),
                (10,	1,	'^/post(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (11,	1,	'^/event(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (12,	1,	'^/stream(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (13,	1,	'^/group(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (14,	1,	'^/file(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (16,	2,	'^/post(/[a-z0-9-]*)*',	'allow',	'execute',	'Content'),
                (15,	1,	'^/page(/[a-z0-9-]*)*',	'allow',	'view',	'Content');"
        );
    }
private function createAuthorityPermissionsTable ( ) { //Drop the authority table if exists, create if doesn't $ this -> database -> query ( "DROP TABLE IF EXISTS `?authority_permissions`;" ) ; $ this -> database -> query ( "CREATE TABLE IF NOT EXISTS `?authority_permissions` (
                `authority_permission_key` bigint(20) NOT NULL AUTO_INCREMENT,
                `authority_id` bigint(20) NOT NULL,
                `permission_area_uri` varchar(255) NOT NULL,
                `permission` varchar(45) NOT NULL DEFAULT '1',
                `permission_type` varchar(45) NOT NULL,
                `permission_title` varchar(45) NOT NULL,
                PRIMARY KEY (`authority_permission_key`),
                UNIQUE KEY `UNIQUE` (`permission_area_uri`,`permission_type`,`authority_id`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;" ) ; //Dumping default permission data to authority_permission tablegit $ this -> database -> query ( "INSERT INTO `?authority_permissions` (`authority_permission_key`, `authority_id`, `permission_area_uri`, `permission`, `permission_type`, `permission_title`) VALUES
                (1,	4,	'^/admin(/[a-z0-9-]*)*',	'allow',	'special',	'Console'),
                (2,	1,	'^/admin/setup/install(/[a-z0-9-]*)*',	'allow',	'execute',	'Installer'),
                (3,	4,	'^/page(/[a-z0-9-]*)*',	'allow',	'execute',	'Content'),
                (4,	2,	'^/member(/[a-z0-9-]*)*',	'allow',	'execute',	'Member Pages'),
                (5,	1,	'^/member/sign([a-z0-9-]*)*',	'allow',	'execute',	'Authentication'),
                (6,	2,	'^/message(/[a-z0-9-]*)*',	'allow',	'execute',	'Messages'),
                (7,	1,	'^/search(/[a-z0-9-]*)*',	'allow',	'execute',	'Search'),
                (8,	4,	'^/listing(/[a-z0-9-]*)*',	'allow',	'special',	'Directory'),
                (9,	2,	'^/notification(/[a-z0-9-]*)*',	'allow',	'execute',	'Messages'),
                (10,	1,	'^/post(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (11,	1,	'^/event(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (12,	1,	'^/stream(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (13,	1,	'^/group(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (14,	1,	'^/file(/[a-z0-9-]*)*',	'allow',	'view',	'Content'),
                (16,	2,	'^/post(/[a-z0-9-]*)*',	'allow',	'execute',	'Content'),
                (15,	1,	'^/page(/[a-z0-9-]*)*',	'allow',	'view',	'Content');" ) ; }
Creates the authority permission table
@return void
Creates the authority permission table