
INSERT IGNORE `#__role_node` ( `rolid`, `parent`, `lft`, `rgt`, `core`, `joomla`, `j16`, `namekey`, `color`, `type`, `depth` ) VALUES ("1", "0", "1", "70", "1", "28", "1", "allusers", "blue", "1", "0" ), ("2", "1", "2", "71", "1", "29", "1", "visitor", "aqua", "1", "1" ), ("3", "2", "2", "69", "1", "18", "2", "registered", "navy", "1", "1" ), ("4", "3", "3", "22", "1", "19", "3", "author", "teal", "1", "1" ), ("5", "4", "4", "13", "1", "20", "4", "editor", "silver", "1", "2" ), ("6", "5", "5", "12", "1", "21", "5", "publisher", "maroon", "1", "3" ), ("7", "6", "6", "11", "1", "23", "6", "manager", "orange", "1", "4" ), ("8", "7", "7", "10", "1", "24", "7", "admin", "fuchsia", "1", "5" ), ("9", "8", "8", "9", "1", "25", "8", "sadmin", "red", "1", "6" ), ("11", "3", "23", "24", "1", "0", "0", "customer", "green", "1", "1" ), ("12", "4", "14", "19", "1", "0", "0", "supplier", "olive", "1", "2" ), ("13", "12", "15", "18", "1", "0", "0", "vendor", "purple", "1", "3" ), ("14", "3", "25", "28", "1", "0", "0", "affiliate", "teal", "1", "1" ), ("15", "14", "26", "27", "1", "0", "0", "reseller", "black", "1", "2" ), ("16", "3", "29", "34", "1", "0", "0", "agent", "teal", "1", "1" ), ("17", "30", "30", "31", "1", "0", "0", "supportmanager", "orange", "1", "0" ), ("18", "3", "35", "40", "1", "0", "0", "mailauthor", "teal", "1", "1" ), ("19", "18", "34", "39", "1", "0", "0", "maileditor", "silver", "1", "2" ), ("20", "19", "35", "38", "1", "0", "0", "mailpublisher", "maroon", "1", "3" ), ("21", "13", "16", "17", "1", "0", "0", "storemanager", "red", "1", "4" ), ("30", "16", "30", "33", "1", "0", "0", "moderator", "black", "1", "1" ), ("31", "3", "41", "48", "1", "0", "0", "groupmoderator", "teal", "1", "1" ), ("32", "31", "42", "47", "1", "0", "0", "groupmanager", "maroon", "1", "2" ), ("33", "32", "43", "46", "1", "0", "0", "communitymoderator", "orange", "1", "3" ), ("34", "33", "44", "45", "1", "0", "0", "communitymanager", "red", "1", "4" ), ("35", "3", "49", "54", "1", "0", "0", "articleauthor", "teal", "1", "1" ), ("36", "35", "50", "53", "1", "0", "0", "articleeditor", "silver", "1", "2" ), ("37", "36", "51", "52", "1", "0", "0", "articlepublisher", "maroon", "1", "3" ), ("38", "20", "36", "37", "1", "0", "0", "mailmanager", "orange", "1", "4" ), ("39", "3", "55", "56", "1", "0", "0", "listmanager", "black", "1", "1" ), ("43", "4", "20", "21", "1", "0", "0", "sales_support", "black", "1", "2" ), ("45", "43", "21", "20", "1", "0", "0", "sales_agent", "purple", "1", "3" ), ("46", "45", "20", "21", "1", "0", "0", "sales_manager", "red", "1", "4" ), ("48", "3", "57", "62", "1", "0", "0", "developer", "purple", "1", "2" ), ("49", "48", "58", "61", "1", "0", "0", "developer_manager", "orange", "1", "3" ), ("50", "49", "59", "60", "1", "0", "0", "developer_architec", "red", "1", "4" ), ("51", "3", "63", "68", "1", "0", "0", "project_member", "purple", "1", "2" ), ("52", "51", "64", "67", "1", "0", "0", "project_manager", "orange", "1", "3" ), ("53", "52", "65", "66", "1", "0", "0", "project_admin", "red", "1", "4" ) ;

INSERT IGNORE `#__role_trans` ( `rolid`, `lgid`, `name`, `description`, `auto`, `fromlgid` ) VALUES ("1", "1", "All Users", "This is the default role any visitor has.", "1", "0" ), ("2", "1", "Visitor", "This is the default role any visitor has.", "1", "0" ), ("3", "1", "Registered", "Any user allowed to log in on the front-end of the website.", "1", "0" ), ("4", "1", "Author", "This role allows the user to create and modify articles.", "1", "0" ), ("5", "1", "Editor", "This role allows the user to edit articles.", "1", "0" ), ("6", "1", "Publisher", "This role allows the user to publish articles.", "1", "0" ), ("7", "1", "Manager", "This role allows the user to log in on the back-end of the website. Managers can edit any menu or article.", "1", "0" ), ("8", "1", "Administrator", "This role allows the administration of menus, articles and applications.", "1", "0" ), ("9", "1", "Super Administrator", "This role allows access to all functions on the website, including configuration and maintenance.", "1", "0" ), ("11", "1", "Customer", "Any one who purchase a product in the store.", "1", "0" ), ("12", "1", "Supplier", "Manufacturer or any organization that provides goods and services.", "1", "0" ), ("13", "1", "Vendor", "This role allows the user to be a vendor.", "1", "0" ), ("14", "1", "Affiliate", "Any person who register to be an affiliate.", "1", "0" ), ("15", "1", "Reseller", "Any person who has signed up to be a reseller.", "1", "0" ), ("16", "1", "Support Agent", "Agent responsible to communicate with the customers.", "1", "0" ), ("17", "1", "Support Manager", "Agents' manager. This role enables to create agent, and define their project and access rights.", "1", "0" ), ("18", "1", "Mail Author", "This role allows the user to create mails.", "1", "0" ), ("19", "1", "Mail Editor", "This role allows the user to edit mails.", "1", "0" ), ("20", "1", "Mail Publisher", "This role allows the user to publish mails.", "1", "0" ), ("21", "1", "Store Manager", "This role allows to manage the store.", "1", "0" ), ("30", "1", "Moderator", "Any person allowed to moderate the forum.", "1", "0" ), ("31", "1", "Group Moderator", "Group moderator is allowed to moderate any group she is assigned to.", "1", "0" ), ("32", "1", "Group Manager", "Creator of a group, can administrate the group.", "1", "0" ), ("33", "1", "Community Moderator", "Can moderate any group part of the community.", "1", "0" ), ("34", "1", "Community Manager", "Administrate the community. This role is required to install and setup the community.", "1", "0" ), ("35", "1", "Article Author", "This role allows to create article, blog, or wiki pages.", "1", "0" ), ("36", "1", "Article Editor", "This role allows to edit article, blog, or wiki pages.", "1", "0" ), ("37", "1", "Article Publisher", "This role allows to publish article, blog, or wiki pages.", "1", "0" ), ("38", "1", "Mail Manager", "With this role user can manager the mail application and preferences", "1", "0" ), ("39", "1", "List Manager", "Allow to manage the list of members.", "1", "0" ), ("43", "1", "Sales Support", "This role allows to access customer profile and organization profile.", "2", "0" ), ("45", "1", "Sales Agent", "This role allows to access all information about contacts and organization.", "2", "0" ), ("46", "1", "Sales Manager", "This role allows to manager all sales agents. Provide access to all information and access to specific settings for contacts and organization.", "2", "0" ), ("48", "1", "Developer", "Any one who develop and customize Apps.", "2", "0" ), ("49", "1", "Developer Manager", "The manager of the developers. Has access to create new apps and invite developers.", "2", "0" ), ("50", "1", "Architect", "Direct and inspire all developers' managers.", "2", "0" ), ("51", "1", "Team Member", "Anyone who can be added on a project to create and execute tasks.", "2", "0" ), ("52", "1", "Project Manager", "Project manager are able to create and manage projects. They can recruit project members to be part of their project.", "2", "0" ), ("53", "1", "Project Administrator", "Person who define general preferences and different project types.", "2", "0" ) ;
































UPDATE `#__theme_node` SET `premium` = '1' WHERE `namekey` ='joomla30.admin.theme';

UPDATE `#__theme_node` SET `premium` = '1' WHERE `namekey` ='wp40.admin.theme';

UPDATE `#__language_node` SET  `publish` =  1 WHERE `code` = 'en';