 INSERT INTO `#__password_rule` VALUES ('','Must be at least 8 characters long',1,'Must be at least 8 characters long','hub',13,3,'minPasswordLength','8');
 INSERT INTO `#__password_rule` VALUES ('nonalpha','Must contain at least 1 number or punctuation mark',1,'Must contain at least 1 number or punctuation mark','hub',12,2,'minClassCharacters','1');
 INSERT INTO `#__password_rule` VALUES ('alpha','Must contain at least 1 letter',1,'Must contain at least 1 letter','hub',11,1,'minClassCharacters','1');
-/*!40000 ALTER TABLE `#__password_rule` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping data for table `#__project_types`
---
-
-LOCK TABLES `#__project_types` WRITE;
-/*!40000 ALTER TABLE `#__project_types` DISABLE KEYS */;
+
+--
+-- HUBzero sample data for table `#__project_types`
+--
+
 INSERT INTO `#__project_types` (`id`, `type`, `description`, `params`) VALUES (1,'General','Individual or collaborative projects of general nature','apps_dev=0\npublications_public=1\nteam_public=1\nallow_invite=0');
 INSERT INTO `#__project_types` (`id`, `type`, `description`, `params`) VALUES (3,'Content publication','Projects created with the purpose to publish data as a resource or a collection of related resources','apps_dev=0\npublications_public=1\nteam_public=1\nallow_invite=0');
 INSERT INTO `#__project_types` (`id`, `type`, `description`, `params`) VALUES (2,'Application development','Projects created with the purpose to develop and publish a simulation tool or a code library','apps_dev=1\npublications_public=1\nteam_public=1\nallow_invite=0');
-/*!40000 ALTER TABLE `#__project_types` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
--- Dumping data for table `#__resource_licenses`
---
-
-LOCK TABLES `#__resource_licenses` WRITE;
-/*!40000 ALTER TABLE `#__resource_licenses` DISABLE KEYS */;
+
+--
+-- HUBzero sample data for table `#__resource_licenses`
+--
+
 INSERT INTO `#__resource_licenses` (`id`, `name`, `text`, `title`, `ordering`, `apps_only`, `main`, `icon`, `url`, `agreement`, `info`) VALUES (1,'cc25-by-nc-sa','You are free:\r\n\r\nto Share — to copy, distribute and transmit the work\r\nto Remix — to adapt the work\r\n\r\nUnder the following conditions:\r\n\r\nAttribution — You must attribute the work in the manner specified by the author or licensor (but not in any way that suggests that they endorse you or your use of the work).\r\nNoncommercial — You may not use this work for commercial purposes.\r\n\r\nShare Alike — If you alter, transform, or build upon this work, you may distribute the resulting work only under the same or similar license to this one.\r\n\r\nWith the understanding that:\r\n\r\nWaiver — Any of the above conditions can be waived if you get permission from the copyright holder.\r\n\r\nPublic Domain — Where the work or any of its elements is in the public domain under applicable law, that status is in no way affected by the license.\r\n\r\nOther Rights — In no way are any of the following rights affected by the license:\r\n- Your fair dealing or fair use rights, or other applicable copyright exceptions and limitations;\r\n- The author\'s moral rights;\r\n- Rights other persons may have either in the work itself or in how the work is used, such as publicity or privacy rights.\r\n\r\nNotice — For any reuse or distribution, you must make clear to others the license terms of this work. The best way to do this is with a link to this web page.','Creative Commons BY-NC-SA 2.5',6,0,NULL,NULL,'http://creativecommons.org/licenses/by-nc-sa/2.5/',0,NULL);
 INSERT INTO `#__resource_licenses` (`id`, `name`, `text`, `title`, `ordering`, `apps_only`, `main`, `icon`, `url`, `agreement`, `info`) VALUES (2,'cc30-by-nc-sa','You are free:\r\n\r\nto Share — to copy, distribute and transmit the work\r\nto Remix — to adapt the work\r\n\r\nUnder the following conditions:\r\n\r\nAttribution — You must attribute the work in the manner specified by the author or licensor (but not in any way that suggests that they endorse you or your use of the work).\r\n\r\nNoncommercial — You may not use this work for commercial purposes.\r\n\r\nShare Alike — If you alter, transform, or build upon this work, you may distribute the resulting work only under the same or similar license to this one.\r\n\r\nWith the understanding that:\r\n\r\nWaiver — Any of the above conditions can be waived if you get permission from the copyright holder.\r\n\r\nPublic Domain — Where the work or any of its elements is in the public domain under applicable law, that status is in no way affected by the license.\r\n\r\nOther Rights — In no way are any of the following rights affected by the license:\r\n- Your fair dealing or fair use rights, or other applicable copyright exceptions and limitations;\r\n- The author\'s moral rights;\r\n- Rights other persons may have either in the work itself or in how the work is used, such as publicity or privacy rights.','Creative Commons BY-NC-SA 3.0',7,0,NULL,NULL,'http://creativecommons.org/licenses/by-nc-sa/3.0/',0,NULL);
 INSERT INTO `#__resource_licenses` (`id`, `name`, `text`, `title`, `ordering`, `apps_only`, `main`, `icon`, `url`, `agreement`, `info`) VALUES (3,'cc','You are free:\r\n\r\nto Share — to copy, distribute and transmit the work\r\nto Remix — to adapt the work\r\n\r\nUnder the following conditions:\r\n\r\nAttribution — You must attribute the work in the manner specified by the author or licensor (but not in any way that suggests that they endorse you or your use of the work).\r\nNoncommercial — You may not use this work for commercial purposes.\r\n\r\nShare Alike — If you alter, transform, or build upon this work, you may distribute the resulting work only under the same or similar license to this one.\r\n\r\nWith the understanding that:\r\n\r\nWaiver — Any of the above conditions can be waived if you get permission from the copyright holder.\r\n\r\nPublic Domain — Where the work or any of its elements is in the public domain under applicable law, that status is in no way affected by the license.\r\n\r\nOther Rights — In no way are any of the following rights affected by the license:\r\n- Your fair dealing or fair use rights, or other applicable copyright exceptions and limitations;\r\n- The author\'s moral rights;\r\n- Rights other persons may have either in the work itself or in how the work is used, such as publicity or privacy rights.\r\n\r\nNotice — For any reuse or distribution, you must make clear to others the license terms of this work. The best way to do this is with a link to this web page.','Creative Commons',1,0,NULL,NULL,'http://creativecommons.org/licenses/by-nc-sa/2.5/',0,NULL);

INSERT INTO `#__resource_licenses` (`id`, `name`, `text`, `title`, `ordering`, `apps_only`, `main`, `icon`, `url`, `agreement`, `info`) VALUES (6,'cc30-by-sa','You are free:\r\n\r\nto Share — to copy, distribute and transmit the work\r\nto Remix — to adapt the work\r\nto make commercial use of the work\r\n\r\nUnder the following conditions:\r\n\r\nAttribution — You must attribute the work in the manner specified by the author or licensor (but not in any way that suggests that they endorse you or your use of the work).\r\n\r\nShare Alike — If you alter, transform, or build upon this work, you may distribute the resulting work only under the same or similar license to this one.\r\nWith the understanding that:\r\n\r\nWaiver — Any of the above conditions can be waived if you get permission from the copyright holder.\r\n\r\nPublic Domain — Where the work or any of its elements is in the public domain under applicable law, that status is in no way affected by the license.\r\n\r\nOther Rights — In no way are any of the following rights affected by the license:\r\n- Your fair dealing or fair use rights, or other applicable copyright exceptions and limitations;\r\n- The author\'s moral rights;\r\n- Rights other persons may have either in the work itself or in how the work is used, such as publicity or privacy rights.','Creative Commons BY-SA 3.0',3,0,NULL,NULL,'http://creativecommons.org/licenses/by-sa/3.0/',0,NULL);
INSERT INTO `#__resource_licenses` (`id`, `name`, `text`, `title`, `ordering`, `apps_only`, `main`, `icon`, `url`, `agreement`, `info`) VALUES (7,'cc30-by-nd','You are free:\r\n\r\nto Share — to copy, distribute and transmit the work\r\nto make commercial use of the work\r\n\r\nUnder the following conditions:\r\n\r\nAttribution — You must attribute the work in the manner specified by the author or licensor (but not in any way that suggests that they endorse you or your use of the work).\r\n\r\nNo Derivative Works — You may not alter, transform, or build upon this work.\r\n\r\nWith the understanding that:\r\n\r\nWaiver — Any of the above conditions can be waived if you get permission from the copyright holder.\r\n\r\nPublic Domain — Where the work or any of its elements is in the public domain under applicable law, that status is in no way affected by the license.\r\n\r\nOther Rights — In no way are any of the following rights affected by the license:\r\n- Your fair dealing or fair use rights, or other applicable copyright exceptions and limitations;\r\nThe author\'s moral rights;\r\n- Rights other persons may have either in the work itself or in how the work is used, such as publicity or privacy rights.','Creative Commons BY-ND 3.0',4,0,NULL,NULL,'http://creativecommons.org/licenses/by-nd/3.0/',0,NULL);
INSERT INTO `#__resource_licenses` (`id`, `name`, `text`, `title`, `ordering`, `apps_only`, `main`, `icon`, `url`, `agreement`, `info`) VALUES (8,'cc30-by-nc','You are free:\r\n\r\nto Share — to copy, distribute and transmit the work\r\nto Remix — to adapt the work\r\n\r\nUnder the following conditions:\r\n\r\nAttribution — You must attribute the work in the manner specified by the author or licensor (but not in any way that suggests that they endorse you or your use of the work).\r\n\r\nNoncommercial — You may not use this work for commercial purposes.\r\n\r\nWith the understanding that:\r\n\r\nWaiver — Any of the above conditions can be waived if you get permission from the copyright holder.\r\n\r\nPublic Domain — Where the work or any of its elements is in the public domain under applicable law, that status is in no way affected by the license.\r\n\r\nOther Rights — In no way are any of the following rights affected by the license:\r\n- Your fair dealing or fair use rights, or other applicable copyright exceptions and limitations;\r\n- The author\'s moral rights;\r\n- Rights other persons may have either in the work itself or in how the work is used, such as publicity or privacy rights.','Creative Commons BY-NC 3.0',5,0,NULL,NULL,'http://creativecommons.org/licenses/by-nc/3.0/',0,NULL);
/*!40000 ALTER TABLE `#__resource_licenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping data for table `#__resource_types`
--

LOCK TABLES `#__resource_types` WRITE;
/*!40000 ALTER TABLE `#__resource_types` DISABLE KEYS */;
INSERT INTO `#__resource_types` VALUES ('1', 'seminars', 'Seminars', '27', 'A lecture of some sort, usually recorded with voice or video.  It may be a graduate or undergraduate level seminar, a lecture for a class, or a tutorial presentation.', '1', '{\"fields\":[{\"default\":\"\",\"name\":\"bio\",\"label\":\"Bio\",\"type\":\"textarea\",\"required\":\"0\"},{\"default\":\"\",\"name\":\"credits\",\"label\":\"Credits\",\"type\":\"textarea\",\"required\":\"0\"},{\"default\":\"\",\"name\":\"sponsoredby\",\"label\":\"Sponsored by\",\"type\":\"textarea\",\"required\":\"0\"}]}', 'plg_share=0\nplg_favorite=0\nplg_versions=0\nplg_reviews=0\nplg_questions=0\nplg_wishlist=0\nplg_usage=0\nplg_related=0\nplg_recommendations=0\nplg_citations=0\nplg_supportingdocs=0\nplg_usagenew=0\nplg_about=1\nplg_abouttool=0');
INSERT INTO `#__resource_types` VALUES ('2', 'workshops', 'Workshops', '27', 'A collection of lectures, seminars, and materials that were presented at a workshop.', '0', 'credits=Credits=textarea=0\nsponsoredby=Sponsored by=textarea=0', 'plg_citations=0\nplg_questions=0\nplg_recommendations=1\nplg_related=1\nplg_reviews=1\nplg_usage=0\nplg_versions=0\nplg_favorite=1\nplg_share=1\nplg_wishlist=0\nplg_supportingdocs=1\nplg_about=1\nplg_abouttool=0');
INSERT INTO `#__resource_types` VALUES ('3', 'publications', 'Publications', '27', 'Articles, technical reports, theses, and other documents, usually in PDF or DOC format.', '1', 'acknowledgments=Acknowledgments=textarea=0\nreferences=References=textarea=0', 'plg_citations=0\nplg_questions=0\nplg_recommendations=1\nplg_related=1\nplg_reviews=1\nplg_usage=0\nplg_versions=0\nplg_favorite=1\nplg_share=1\nplg_wishlist=0\nplg_supportingdocs=1\nplg_about=1\nplg_abouttool=0');

#
# HUBzero is a registered trademark of Purdue University.
#

#
# IMPORTANT - THIS FILE MUST BE SAVED WITH UTF-8 ENCODING ONLY. BEWARE IF EDITING!
#

UPDATE `#__extensions` SET enabled='0' WHERE `type`='component' AND `element` IN ('com_banners','com_weblinks','com_contacts','com_search','com_wrapper','com_mailto','com_massmail');
UPDATE `#__extensions` SET params='{"show_headings":"1","show_name":"1","show_articles":"1","show_link":"1","show_cat_description":"1","show_cat_items":"1","show_feed_image":"1","show_feed_description":"1","show_item_description":"1","feed_word_count":"0"}' WHERE `type`='component' AND `element`='com_newsfeeds';
UPDATE `#__extensions` SET params='{"upload_extensions":"bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS","upload_maxsize":"10000000","file_path":"site/media","image_path":"site/media/images","restrict_uploads":"1","allowed_media_usergroup":"3","check_mime":"1","image_extensions":"bmp, gif, jpg, png","ignore_extensions":"","upload_mime":"image/jpeg, image/gif, image/png, image/bmp, application/x-shockwave-flash, application/msword, application/excel, application/pdf, application/powerpoint, text/plain, application/x-zip","upload_mime_illegal":"text/html","enable_flash":"0"}' WHERE `type`='component' AND `element`='com_media';
UPDATE `#__extensions` SET params='{"show_noauth":"0","show_title":"1","link_titles":"0","show_intro":"1","show_section":"0","link_section":"0","show_category":"0","link_category":"0","show_author":"0","show_create_date":"0","show_modify_date":"0","show_item_navigation":"0","show_readmore":"1","show_vote":"0","show_icons":"0","show_print_icon":"0","show_email_icon":"0","show_hits":"0","feed_summary":"0","filter_tags":"","filter_attritbutes":""}' WHERE `type`='component' AND `element`='com_content';
UPDATE `#__extensions` SET params='{"allowUserRegistration":"1","new_usertype":"Registered","useractivation":"1","frontend_userparams":"1","allow_duplicate_emails":"0"}' WHERE `type`='component' AND `element`='com_users';


UPDATE `#__modules` SET position='user3' WHERE title='Main Menu';
UPDATE `#__modules` SET showtitle='0' WHERE title='Main Menu';
UPDATE `#__modules` SET params= '{"menutype":"mainmenu","menu_style":"list","startLevel":"0","endLevel":"0","showAllChildren":"1","window_open":"","show_whitespace":"0","cache":"1","tag_id":"","class_sfx":"","moduleclass_sfx":"_menu","maxdepth":"10","menu_images":"0","menu_images_align":"0","menu_images_link":"0","expand_menu":"0","activate_parent":"0","full_active_id":"0","indent_image":"0","indent_image1":"","indent_image2":"","indent_image3":"","indent_image4":"","indent_image5":"","indent_image6":"","spacer":"","end_spacer":""}',0,'');
UPDATE `#__modules` SET published='0' WHERE title='Quick Icons';
UPDATE `#__modules` SET module='mod_hubmenu' WHERE title='Admin Menu';

--
-- HUBzero sample data for table `hosttype`
--

INSERT INTO `hosttype` (`name`, `value`, `description`) VALUES ('workspace',1,'Workspace host');
INSERT INTO `hosttype` (`name`, `value`, `description`) VALUES ('fileserver',2,'Fileserver host');
INSERT INTO `hosttype` (`name`, `value`, `description`) VALUES ('pubnet',4,'Public host');
INSERT INTO `hosttype` (`name`, `value`, `description`) VALUES ('sessions',8,'Normal jobs');
INSERT INTO `hosttype` (`name`, `value`, `description`) VALUES ('openvz',16,'OpenVZ');

--
-- HUBzero sample data for table `#__assets`
--

REPLACE INTO `#__assets` VALUES (1,0,0,191,0,'root.1','Root Asset','{"core.login.site":{"1":1,"6":1,"2":1},"core.login.admin":{"6":1},"core.login.offline":{"6":1},"core.admin":{"8":1},"core.manage":{"7":1},"core.create":{"6":1,"3":1},"core.delete":{"6":1},"core.edit":{"6":1,"4":1},"core.edit.state":{"6":1,"5":1},"core.edit.own":{"6":1,"3":1}}');
REPLACE INTO `#__assets` VALUES (2,1,75,76,1,'com_admin','com_admin','{}');
REPLACE INTO `#__assets` VALUES (3,1,77,80,1,'com_banners','com_banners','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (4,1,81,82,1,'com_cache','com_cache','{"core.admin":{"7":1},"core.manage":{"7":1}}');
REPLACE INTO `#__assets` VALUES (5,1,83,84,1,'com_checkin','com_checkin','{"core.admin":{"7":1},"core.manage":{"7":1}}');
REPLACE INTO `#__assets` VALUES (6,1,85,86,1,'com_config','com_config','{"core.admin":{"7":1},"core.manage":{"7":1},"core.create":{"7":1},"core.delete":{"7":1},"core.edit":{"7":1},"core.edit.state":{"7":1}}');
REPLACE INTO `#__assets` VALUES (7,1,87,90,1,'com_contact','com_contact','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (8,1,91,144,1,'com_content','com_content','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (9,1,145,146,1,'com_cpanel','com_cpanel','{}');
REPLACE INTO `#__assets` VALUES (10,1,147,148,1,'com_installer','com_installer','{"core.admin":[],"core.manage":{"7":0},"core.delete":{"7":0},"core.edit.state":{"7":0}}');
REPLACE INTO `#__assets` VALUES (11,1,149,150,1,'com_languages','com_languages','{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (12,1,151,152,1,'com_login','com_login','{}');
REPLACE INTO `#__assets` VALUES (13,1,153,154,1,'com_mailto','com_mailto','{"core.admin":{"7":1},"core.manage":{"7":1},"core.create":{"7":1},"core.delete":{"7":1},"core.edit":{"7":1},"core.edit.state":{"7":1}}');
REPLACE INTO `#__assets` VALUES (14,1,155,156,1,'com_massmail','com_massmail','{"core.admin":{"7":1},"core.manage":{"7":1},"core.create":{"7":1},"core.delete":{"7":1},"core.edit":{"7":1},"core.edit.state":{"7":1}}');
REPLACE INTO `#__assets` VALUES (15,1,157,158,1,'com_media','com_media','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":{"5":1}}');
REPLACE INTO `#__assets` VALUES (16,1,159,160,1,'com_menus','com_menus','{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (17,1,161,162,1,'com_messages','com_messages','{"core.admin":{"7":1},"core.manage":{"7":1}}');
REPLACE INTO `#__assets` VALUES (18,1,163,164,1,'com_modules','com_modules','{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (19,1,165,168,1,'com_newsfeeds','com_newsfeeds','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (20,1,169,170,1,'com_plugins','com_plugins','{"core.admin":{"7":1},"core.manage":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (21,1,171,172,1,'com_redirect','com_redirect','{"core.admin":{"7":1},"core.manage":[]}');
REPLACE INTO `#__assets` VALUES (22,1,173,174,1,'com_search','com_search','{"core.admin":{"7":1},"core.manage":{"6":1}}');
REPLACE INTO `#__assets` VALUES (23,1,175,176,1,'com_templates','com_templates','{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (24,1,177,180,1,'com_users','com_users','{"core.admin":{"7":1},"core.manage":[],"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (25,1,181,184,1,'com_weblinks','com_weblinks','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":{"3":1},"core.delete":[],"core.edit":{"4":1},"core.edit.state":{"5":1},"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (26,1,185,186,1,'com_wrapper','com_wrapper','{}');
REPLACE INTO `#__assets` VALUES (27,8,134,143,2,'com_content.category.2','Uncategorised','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (28,3,78,79,2,'com_banners.category.3','Uncategorised','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (29,7,88,89,2,'com_contact.category.4','Uncategorised','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (30,19,166,167,2,'com_newsfeeds.category.5','Uncategorised','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (31,25,182,183,2,'com_weblinks.category.6','Uncategorised','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[],"core.edit.own":[]}');
REPLACE INTO `#__assets` VALUES (32,24,178,179,2,'com_users.category.7','Uncategorised','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
REPLACE INTO `#__assets` VALUES (33,1,187,188,1,'com_finder','com_finder','{"core.admin":{"7":1},"core.manage":{"6":1}}');
REPLACE INTO `#__assets` VALUES (34,1,189,190,1,'com_joomlaupdate','com_joomlaupdate','{"core.admin":[],"core.manage":[],"core.delete":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (35,1,69,70,1,'com_answers','com_answers','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (36,1,67,68,1,'com_billboards','com_billboards','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (37,1,65,66,1,'com_blog','com_blog','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (38,1,33,34,1,'com_citations','com_citations','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (39,1,31,32,1,'com_courses','com_courses','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (40,1,29,30,1,'com_cron','com_cron','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (41,1,19,28,1,'com_events','com_events','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (42,1,17,18,1,'com_features','com_features','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (43,1,15,16,1,'com_feedback','com_feedback','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (44,1,13,14,1,'com_forum','com_forum','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (45,1,73,74,1,'com_groups','com_groups','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (46,1,11,12,1,'com_help','com_help','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (47,1,9,10,1,'com_jobs','com_jobs','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (48,1,7,8,1,'com_kb','com_kb','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (49,1,5,6,1,'com_members','com_members','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (50,1,3,4,1,'com_newsletter','com_newsletter','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (51,1,35,36,1,'com_poll','com_poll','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (52,1,37,38,1,'com_projects','com_projects','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (53,1,39,40,1,'com_register','com_register','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (54,1,63,64,1,'com_resources','com_resources','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (55,1,61,62,1,'com_services','com_services','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (56,1,59,60,1,'com_store','com_store','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (57,1,57,58,1,'com_support','com_support','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (58,1,55,56,1,'com_system','com_system','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (59,1,53,54,1,'com_tags','com_tags','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (60,1,71,72,1,'com_tools','com_tools','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (61,1,51,52,1,'com_topics','com_topics','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (62,1,49,50,1,'com_usage','com_usage','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (63,1,47,48,1,'com_user','com_user','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (64,1,45,46,1,'com_whatsnew','com_whatsnew','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (65,1,43,44,1,'com_wiki','com_wiki','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (66,1,41,42,1,'com_wishlist','com_wishlist','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (67,1,1,2,1,'com_ysearch','com_ysearch','{"core.admin":{"7":1},"core.manage":{"6":1},"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (68,8,92,107,2,'com_content.category.8','com_content','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (69,8,108,125,2,'com_content.category.9','com_content','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (70,8,126,127,2,'com_content.category.10','com_content','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (71,8,128,129,2,'com_content.category.11','com_content','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (72,41,20,21,2,'com_events.category.12','com_events','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (73,41,22,23,2,'com_events.category.13','com_events','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (74,41,24,25,2,'com_events.category.14','com_events','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (75,41,26,27,2,'com_events.category.15','com_events','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (76,77,131,132,3,'com_content.category.16','com_content','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (77,8,130,133,2,'com_content.category.17','com_content','{"core.create":[],"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (78,27,135,136,3,'com_content.article.1','Home','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (79,68,93,94,3,'com_content.article.2','Our Cyberinfrastructure','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (80,68,95,96,3,'com_content.article.3','About Us','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (81,68,97,98,3,'com_content.article.4','Contact Us','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (82,68,99,100,3,'com_content.article.5','Quotes','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (83,68,101,102,3,'com_content.article.6','Usage','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (84,68,103,104,3,'com_content.article.7','Copyrights','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (85,68,105,106,3,'com_content.article.8','Feedback','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (86,69,109,110,3,'com_content.article.11','Terms of Use','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (87,69,111,112,3,'com_content.article.12','Intellectual Property Considerations','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (88,69,113,114,3,'com_content.article.13','Creative Commons','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (89,69,115,116,3,'com_content.article.14','Submitting Content','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (90,27,137,138,3,'com_content.article.22','Discover','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (91,27,139,140,3,'com_content.article.32','Congratulations','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (92,69,117,118,3,'com_content.article.27','Privacy Policy','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (93,69,119,120,3,'com_content.article.28','Abuse Policy','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (94,69,121,122,3,'com_content.article.29','Legal','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (95,69,123,124,3,'com_content.article.30','HUBzero Accessibility Statement','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');
INSERT INTO `#__assets` VALUES (96,27,141,142,3,'com_content.article.31','Community','{"core.delete":[],"core.edit":[],"core.edit.state":[]}');

--
-- HUBzero sample data for table `#__auth_domain`
--

INSERT INTO `#__auth_domain` VALUES ('facebook','',1,'','authentication');
INSERT INTO `#__auth_domain` VALUES ('google','',2,'','authentication');
INSERT INTO `#__auth_domain` VALUES ('linkedin','',3,'','authentication');
INSERT INTO `#__auth_domain` VALUES ('pucas','',4,'','authentication');

--
-- HUBzero sample data for table `#__categories`
--

INSERT INTO `#__categories` VALUES (8,68,1,1,2,1,'about','com_content','about','about','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (9,69,1,3,4,1,'legal','com_content','legal','legal','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (10,70,1,5,6,1,'browse','com_content','browse','browse','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (11,71,1,7,8,1,'presenters','com_content','presenters','presenters','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (12,72,1,9,10,1,'meeting','com_events','Meeting','meeting','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (13,73,1,11,12,1,'seminar','com_events','Seminar','seminar','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (14,74,1,13,14,1,'workshop','com_events','Workshop','workshop','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (15,75,1,15,16,1,'general','com_events','General','general','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (16,76,17,18,19,2,'features/frontpage','com_content','frontpage','frontpage','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');
INSERT INTO `#__categories` VALUES (17,77,1,17,20,1,'features','com_content','features','features','','',1,0,'0000-00-00 00:00:00',1,'','','','',0,'0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,'');

--
-- HUBzero sample data for table `#__citations_types`
--

INSERT INTO `#__citations_types` VALUES (1,'journal','Journal','',NULL,NULL);
INSERT INTO `#__citations_types` VALUES (2,'article','Article','',NULL,NULL);
INSERT INTO `#__citations_types` VALUES (3,'book','Book','',NULL,NULL);
