
--
-- Table structure for table `josci_update_sites`
--

CREATE TABLE `josci_update_sites` (
  `update_site_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `location` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` int(11) DEFAULT '0',
  `last_check_timestamp` bigint(20) DEFAULT '0',
  `extra_query` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`update_site_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites';

--
-- Dumping data for table `josci_update_sites`
--

INSERT INTO `josci_update_sites` VALUES (1,'Joomla! Core','collection','https://update.joomla.org/core/list.xml',1,1589731819,''),(2,'Accredited Joomla! Translations','collection','https://update.joomla.org/language/translationlist_3.xml',1,1589731884,''),(3,'Joomla! Update Component Update Site','extension','https://update.joomla.org/core/extensions/com_joomlaupdate.xml',1,1589731884,''),(4,'','extension','http://update.joomlart.com/service/tracking/j16/plg_system_t3.xml',1,1589731885,''),(5,'','extension','http://update.joomlart.com/service/tracking/j31/purity_iii.xml',1,1589731885,''),(6,'JA Extension Manager','extension','http://update.joomlart.com/service/tracking/j16/com_jaextmanager.xml',1,1589731885,''),(7,'MigrateMe','extension','https://www.php-web-design.com/updates/check.php?ext=migrateme',1,1589731886,''),(9,'Regular Labs - Sourcerer','extension','https://download.regularlabs.com/updates.xml?e=sourcerer&type=.xml',1,1589731887,'');

--
-- Table structure for table `josci_update_sites_extensions`
--

CREATE TABLE `josci_update_sites_extensions` (
  `update_site_id` int(11) NOT NULL DEFAULT '0',
  `extension_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`update_site_id`,`extension_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites';

--
-- Dumping data for table `josci_update_sites_extensions`
--

INSERT INTO `josci_update_sites_extensions` VALUES (1,700),(2,802),(3,28),(4,10000),(5,10001),(6,10002),(7,10003),(9,10009);

--
-- Table structure for table `josci_updates`
--

CREATE TABLE `josci_updates` (
  `update_id` int(11) NOT NULL AUTO_INCREMENT,
  `update_site_id` int(11) DEFAULT '0',
  `extension_id` int(11) DEFAULT '0',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `element` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `type` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `folder` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `client_id` tinyint(3) DEFAULT '0',
  `version` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `detailsurl` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `infourl` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `extra_query` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`update_id`)
) ENGINE=InnoDB AUTO_INCREMENT=694 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';

--
-- Dumping data for table `josci_updates`
--

INSERT INTO `josci_updates` VALUES (617,2,0,'Armenian','','pkg_hy-AM','package','',0,'3.4.4.1','','https://update.joomla.org/language/details3/hy-AM_details.xml','',''),(618,2,0,'Malay','','pkg_ms-MY','package','',0,'3.4.1.2','','https://update.joomla.org/language/details3/ms-MY_details.xml','',''),(619,2,0,'Romanian','','pkg_ro-RO','package','',0,'3.9.13.1','','https://update.joomla.org/language/details3/ro-RO_details.xml','',''),(620,2,0,'Flemish','','pkg_nl-BE','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/nl-BE_details.xml','',''),(621,2,0,'Chinese Traditional','','pkg_zh-TW','package','',0,'3.8.0.1','','https://update.joomla.org/language/details3/zh-TW_details.xml','',''),(622,2,0,'French','','pkg_fr-FR','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/fr-FR_details.xml','',''),(623,2,0,'Galician','','pkg_gl-ES','package','',0,'3.3.1.2','','https://update.joomla.org/language/details3/gl-ES_details.xml','',''),(624,2,0,'Georgian','','pkg_ka-GE','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/ka-GE_details.xml','',''),(625,2,0,'Greek','','pkg_el-GR','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/el-GR_details.xml','',''),(626,2,0,'Japanese','','pkg_ja-JP','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/ja-JP_details.xml','',''),(627,2,0,'Hebrew','','pkg_he-IL','package','',0,'3.1.1.2','','https://update.joomla.org/language/details3/he-IL_details.xml','',''),(628,2,0,'Bengali','','pkg_bn-BD','package','',0,'3.8.10.1','','https://update.joomla.org/language/details3/bn-BD_details.xml','',''),(629,2,0,'Hungarian','','pkg_hu-HU','package','',0,'3.9.12.1','','https://update.joomla.org/language/details3/hu-HU_details.xml','',''),(630,2,0,'Afrikaans','','pkg_af-ZA','package','',0,'3.9.16.1','','https://update.joomla.org/language/details3/af-ZA_details.xml','',''),(631,2,0,'Arabic Unitag','','pkg_ar-AA','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/ar-AA_details.xml','',''),(632,2,0,'Belarusian','','pkg_be-BY','package','',0,'3.2.1.2','','https://update.joomla.org/language/details3/be-BY_details.xml','',''),(633,2,0,'Bulgarian','','pkg_bg-BG','package','',0,'3.6.5.2','','https://update.joomla.org/language/details3/bg-BG_details.xml','',''),(634,2,0,'Catalan','','pkg_ca-ES','package','',0,'3.9.11.2','','https://update.joomla.org/language/details3/ca-ES_details.xml','',''),(635,2,0,'Chinese Simplified','','pkg_zh-CN','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/zh-CN_details.xml','',''),(636,2,0,'Croatian','','pkg_hr-HR','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/hr-HR_details.xml','',''),(637,2,0,'Czech','','pkg_cs-CZ','package','',0,'3.9.16.1','','https://update.joomla.org/language/details3/cs-CZ_details.xml','',''),(638,2,0,'Danish','','pkg_da-DK','package','',0,'3.9.17.1','','https://update.joomla.org/language/details3/da-DK_details.xml','',''),(639,2,0,'Dutch','','pkg_nl-NL','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/nl-NL_details.xml','',''),(640,2,0,'Esperanto','','pkg_eo-XX','package','',0,'3.8.11.1','','https://update.joomla.org/language/details3/eo-XX_details.xml','',''),(641,2,0,'Estonian','','pkg_et-EE','package','',0,'3.9.14.2','','https://update.joomla.org/language/details3/et-EE_details.xml','',''),(642,2,0,'Italian','','pkg_it-IT','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/it-IT_details.xml','',''),(643,2,0,'Khmer','','pkg_km-KH','package','',0,'3.4.5.1','','https://update.joomla.org/language/details3/km-KH_details.xml','',''),(644,2,0,'Korean','','pkg_ko-KR','package','',0,'3.8.9.1','','https://update.joomla.org/language/details3/ko-KR_details.xml','',''),(645,2,0,'Latvian','','pkg_lv-LV','package','',0,'3.7.3.1','','https://update.joomla.org/language/details3/lv-LV_details.xml','',''),(646,2,0,'Lithuanian','','pkg_lt-LT','package','',0,'3.9.6.1','','https://update.joomla.org/language/details3/lt-LT_details.xml','',''),(647,2,0,'Macedonian','','pkg_mk-MK','package','',0,'3.6.5.1','','https://update.joomla.org/language/details3/mk-MK_details.xml','',''),(648,2,0,'Norwegian Bokmal','','pkg_nb-NO','package','',0,'3.8.11.1','','https://update.joomla.org/language/details3/nb-NO_details.xml','',''),(649,2,0,'Norwegian Nynorsk','','pkg_nn-NO','package','',0,'3.4.2.1','','https://update.joomla.org/language/details3/nn-NO_details.xml','',''),(650,2,0,'Persian','','pkg_fa-IR','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/fa-IR_details.xml','',''),(651,2,0,'Polish','','pkg_pl-PL','package','',0,'3.9.13.1','','https://update.joomla.org/language/details3/pl-PL_details.xml','',''),(652,2,0,'Portuguese','','pkg_pt-PT','package','',0,'3.9.15.1','','https://update.joomla.org/language/details3/pt-PT_details.xml','',''),(653,2,0,'Russian','','pkg_ru-RU','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/ru-RU_details.xml','',''),(654,2,0,'English AU','','pkg_en-AU','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/en-AU_details.xml','',''),(655,2,0,'Slovak','','pkg_sk-SK','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/sk-SK_details.xml','',''),(656,2,0,'English US','','pkg_en-US','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/en-US_details.xml','',''),(657,2,0,'Swedish','','pkg_sv-SE','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/sv-SE_details.xml','',''),(658,2,0,'Syriac','','pkg_sy-IQ','package','',0,'3.4.5.1','','https://update.joomla.org/language/details3/sy-IQ_details.xml','',''),(659,2,0,'Tamil','','pkg_ta-IN','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/ta-IN_details.xml','',''),(660,2,0,'Thai','','pkg_th-TH','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/th-TH_details.xml','',''),(661,2,0,'Turkish','','pkg_tr-TR','package','',0,'3.9.4.1','','https://update.joomla.org/language/details3/tr-TR_details.xml','',''),(662,2,0,'Ukrainian','','pkg_uk-UA','package','',0,'3.9.18.8','','https://update.joomla.org/language/details3/uk-UA_details.xml','',''),(663,2,0,'Uyghur','','pkg_ug-CN','package','',0,'3.7.5.2','','https://update.joomla.org/language/details3/ug-CN_details.xml','',''),(664,2,0,'Albanian','','pkg_sq-AL','package','',0,'3.1.1.2','','https://update.joomla.org/language/details3/sq-AL_details.xml','',''),(665,2,0,'Basque','','pkg_eu-ES','package','',0,'3.7.5.1','','https://update.joomla.org/language/details3/eu-ES_details.xml','',''),(666,2,0,'Hindi','','pkg_hi-IN','package','',0,'3.3.6.2','','https://update.joomla.org/language/details3/hi-IN_details.xml','',''),(667,2,0,'German DE','','pkg_de-DE','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/de-DE_details.xml','',''),(668,2,0,'Portuguese Brazil','','pkg_pt-BR','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/pt-BR_details.xml','',''),(669,2,0,'Serbian Latin','','pkg_sr-YU','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/sr-YU_details.xml','',''),(670,2,0,'Spanish','','pkg_es-ES','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/es-ES_details.xml','',''),(671,2,0,'Bosnian','','pkg_bs-BA','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/bs-BA_details.xml','',''),(672,2,0,'Serbian Cyrillic','','pkg_sr-RS','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/sr-RS_details.xml','',''),(673,2,0,'Vietnamese','','pkg_vi-VN','package','',0,'3.2.1.2','','https://update.joomla.org/language/details3/vi-VN_details.xml','',''),(674,2,0,'Bahasa Indonesia','','pkg_id-ID','package','',0,'3.6.2.1','','https://update.joomla.org/language/details3/id-ID_details.xml','',''),(675,2,0,'Finnish','','pkg_fi-FI','package','',0,'3.9.16.1','','https://update.joomla.org/language/details3/fi-FI_details.xml','',''),(676,2,0,'Swahili','','pkg_sw-KE','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/sw-KE_details.xml','',''),(677,2,0,'Montenegrin','','pkg_srp-ME','package','',0,'3.3.1.2','','https://update.joomla.org/language/details3/srp-ME_details.xml','',''),(678,2,0,'English CA','','pkg_en-CA','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/en-CA_details.xml','',''),(679,2,0,'French CA','','pkg_fr-CA','package','',0,'3.6.5.1','','https://update.joomla.org/language/details3/fr-CA_details.xml','',''),(680,2,0,'Welsh','','pkg_cy-GB','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/cy-GB_details.xml','',''),(681,2,0,'Sinhala','','pkg_si-LK','package','',0,'3.3.1.2','','https://update.joomla.org/language/details3/si-LK_details.xml','',''),(682,2,0,'Dari Persian','','pkg_prs-AF','package','',0,'3.4.4.3','','https://update.joomla.org/language/details3/prs-AF_details.xml','',''),(683,2,0,'Turkmen','','pkg_tk-TM','package','',0,'3.5.0.2','','https://update.joomla.org/language/details3/tk-TM_details.xml','',''),(684,2,0,'Irish','','pkg_ga-IE','package','',0,'3.8.13.1','','https://update.joomla.org/language/details3/ga-IE_details.xml','',''),(685,2,0,'Dzongkha','','pkg_dz-BT','package','',0,'3.6.2.1','','https://update.joomla.org/language/details3/dz-BT_details.xml','',''),(686,2,0,'Slovenian','','pkg_sl-SI','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/sl-SI_details.xml','',''),(687,2,0,'Spanish CO','','pkg_es-CO','package','',0,'3.9.15.1','','https://update.joomla.org/language/details3/es-CO_details.xml','',''),(688,2,0,'German CH','','pkg_de-CH','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/de-CH_details.xml','',''),(689,2,0,'German AT','','pkg_de-AT','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/de-AT_details.xml','',''),(690,2,0,'German LI','','pkg_de-LI','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/de-LI_details.xml','',''),(691,2,0,'German LU','','pkg_de-LU','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/de-LU_details.xml','',''),(692,2,0,'English NZ','','pkg_en-NZ','package','',0,'3.9.18.1','','https://update.joomla.org/language/details3/en-NZ_details.xml','',''),(693,2,0,'Kazakh','','pkg_kk-KZ','package','',0,'3.9.17.1','','https://update.joomla.org/language/details3/kk-KZ_details.xml','','');

--
-- Table structure for table `josci_user_keys`
--

CREATE TABLE `josci_user_keys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `series` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `invalid` tinyint(4) NOT NULL,
  `time` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uastring` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `series` (`series`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `josci_user_keys`
--


--
-- Table structure for table `josci_user_notes`
--

CREATE TABLE `josci_user_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `catid` int(10) unsigned NOT NULL DEFAULT '0',
  `subject` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` int(10) unsigned NOT NULL,
  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `review_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_category_id` (`catid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `josci_user_notes`
--


--
-- Table structure for table `josci_user_profiles`
--

CREATE TABLE `josci_user_profiles` (
  `user_id` int(11) NOT NULL,
  `profile_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';

--
-- Dumping data for table `josci_user_profiles`
--


--
-- Table structure for table `josci_user_usergroup_map`
--

CREATE TABLE `josci_user_usergroup_map` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id',
  `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id',
  PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `josci_user_usergroup_map`
--

INSERT INTO `josci_user_usergroup_map` VALUES (62,8),(63,3),(64,3),(65,3),(66,3),(67,3),(68,3),(69,3),(70,3),(71,3),(72,3),(73,2),(74,4),(76,3),(77,4),(94,5),(98,2),(109,2),(873,8);

--
-- Table structure for table `josci_usergroups`
--

CREATE TABLE `josci_usergroups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
  `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.',
  `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.',
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
  KEY `idx_usergroup_title_lookup` (`title`),
  KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
  KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `josci_usergroups`
--

INSERT INTO `josci_usergroups` VALUES (1,0,1,18,'Public'),(2,1,8,15,'Registered'),(3,2,9,14,'Author'),(4,3,10,13,'Editor'),(5,4,11,12,'Publisher'),(6,1,4,7,'Manager'),(7,6,5,6,'Administrator'),(8,1,16,17,'Super Users'),(9,1,2,3,'Guest');

--
-- Table structure for table `josci_users`
--

CREATE TABLE `josci_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(400) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `password` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `block` tinyint(4) NOT NULL DEFAULT '0',
  `sendEmail` tinyint(4) DEFAULT '0',
  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activation` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `params` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
  `resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime',
  `otpKey` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
  `otep` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
  `requireReset` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_name` (`name`(100)),
  KEY `idx_block` (`block`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=874 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `josci_users`
--

INSERT INTO `josci_users` VALUES (62,'Jack Brake','JHB','admin@letsrebuildit.com','41a032e8b25bf2ba4b481154044604bf:HPO7LaQxXuWHistiQTTM1jQ0Z68BngrI',0,1,'2010-04-26 21:24:32','2020-05-16 00:49:07','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(63,'Rick Joyner','OAK','office@theoakinitiative.org','c586175f8751e88d888ba2606834b8c1:2sOsTtZ25koQfaWbU2MKVAzvDXYnPEVc',0,1,'2010-04-28 12:32:07','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(64,'American Family Association','AFA','contact@afa.net','fd7e72579fccbdeb5c8d4fc85b71cb0a:TfX0yeF7KuKBuvF8JPWaAc4dc8RId6rL',0,1,'2010-04-28 19:20:04','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(65,'Fulton J. Sheen','FJS','fjs777@aol.com','449b89a6fe5f7da6018bb207bd396ff0:ynVakk1OodVn9yRDRtyOAATRUQ5ib6CB',0,1,'2010-04-29 00:05:41','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(66,'Tea Party Express','TPE','info@teapartyexpress.org','e38afc31ed917a8ceed9089a831ac05a:Jl64XqHsnXPVz1b04Bz2EgORKvOMS2Sq',0,1,'2010-04-29 00:10:04','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(67,'Americans for Prosperity Michigan','AFP','infomi@afphq.org','8d60b433cd1eb95c895da7ea34049003:KyWiWcyPitLtGu6mNAx4aGsYMFb7Qq3U',0,1,'2010-04-29 00:12:02','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(68,'Transformation Michigan','TMI','transformmi@tds.net','959f86bbd3561e0fc3016bee6d59c32a:CwCKyj42CNGVlqHgiPao5d7nTcjqRqWr',0,1,'2010-04-29 00:13:53','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(69,'Citizens for Traditional Values','CTV','ctv@ctvmichigan.org','1a4eb28dc03694950b7d3a6ad6b4735b:xZgGVpxtf7D4Ww4SQ8woRkaUwKKOh2UT',0,1,'2010-04-29 00:17:21','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(70,'Founding Fathers','ff','admin@letsrebuilt.com','a399d08a4436e5a7647c76311e02113a:sTcrrIkqerDKBlFfF9jJYJQnVwrxtSAa',0,1,'2010-04-29 00:40:14','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(71,'Craig von Buseck','cvb','info@cbn.com','f72127dee34b82c8d0b04142bc1631e9:AeJNGvORUpPjdHm1sX8xOsnswz2fjaU8',0,1,'2010-04-29 13:43:48','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(72,'Cardinal Newman Society','CNS','cns@letsrebuildit.com','4d4758246afb567463b9892cc082ec73:BqaVlgFRUvHW5D3iAfpYhk4uneqRnE3W',0,1,'2010-05-03 06:48:53','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(73,'Catholic Vote Action','cva','info@catholicvoteaction.org','c2ba20a4e25e8dd477eef2d54351ca1e:u0fKgRCEIpzVLkG4I61ux1s5dWKcjzHb',0,0,'2010-05-11 17:55:48','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(74,'Helio Rodriguez-Ecay','ECO','helio@reccpa.com','d1aebd1b5b83a4ff0d96b1e9ebd19cf4:QXXBb2beo8QNDJphKi2gG54GJRdLPG3M',0,1,'2010-05-12 03:16:01','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(76,'Elsie Deluca','EDL','elsieandphil@charter.net','45ffdecde53500ff3948c0b8da4e58fd:7CQD1oySjz1cL1CZBqwkBzWtLNUUD7JS',0,1,'2010-05-12 13:43:45','0000-00-00 00:00:00','','{\"language\":\"\",\"admin_style\":\"\",\"timezone\":\"\",\"editor\":\"\",\"helpsite\":\"\"}','0000-00-00 00:00:00',0,'','',0),(77,'Thomas Brake','Rock','benjiloghomes@gmail.com','b310425f8945cfa60fe4afe3eb62f5a8:cpWzdNqDvadU6BrMDpuLzoZSinad2ed4',0,1,'2010-05-15 03:13:53','0000-00-00 00:00:00','','{\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(94,'RetakeOurGov.com','WesN','wes@retakeourgov.com','09ab9df400835ad6863a9c6f71f0a698:NVE9xRn4EyfFBAKjQ4rdCWaFM9OCdra5',1,0,'2011-01-25 02:19:34','0000-00-00 00:00:00','','{\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"tinymce\",\"helpsite\":\"\",\"admin_style\":\"\",\"timezone\":\"\"}','0000-00-00 00:00:00',0,'','',0),(98,'MargaretAnderson','MargaretAnderson','margaretanderson@mail15.com','164b6678a43295765230a0efbda89d88:8UNcW27DLy38Dg4z5jGOnHw9QJIGkBS3',0,0,'2011-02-15 00:10:49','0000-00-00 00:00:00','','[]','0000-00-00 00:00:00',0,'','',0),(109,'PeetZaich','PeetZaich','peetzaich@gmail.com','d43084fcfbee0d82a3543e88e7dde028:kGDKqqqzKglScoIjOQlf0WTC8dbqe5sc',1,0,'2011-04-01 05:35:05','0000-00-00 00:00:00','74ef21847179854692872fcfe20a5dda','[]','0000-00-00 00:00:00',0,'','',0),(873,'Eagle21','admin','Eagle21@letsrebuildit.com','$2y$10$3UQM5vrSCdIGG05lPdY7eeItmCDs8ym1iOs7JJdh1jSEKsFdaXvsS',0,1,'2020-05-13 01:39:00','2020-05-17 16:11:22','0','','0000-00-00 00:00:00',0,'','',0);

--
-- Table structure for table `josci_utf8_conversion`
--

CREATE TABLE `josci_utf8_conversion` (
  `converted` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `josci_utf8_conversion`
--

INSERT INTO `josci_utf8_conversion` VALUES (4);

--
-- Table structure for table `josci_viewlevels`
--

CREATE TABLE `josci_viewlevels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `rules` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON encoded access control.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_assetgroup_title_lookup` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `josci_viewlevels`
--

INSERT INTO `josci_viewlevels` VALUES (1,'Public',0,'[1]'),(2,'Registered',2,'[6,2,8]'),(3,'Special',3,'[6,3,8]'),(5,'Guest',1,'[9]'),(6,'Super Users',4,'[8]');

--
-- Table structure for table `josci_weblinks`
--

CREATE TABLE `josci_weblinks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(250) NOT NULL DEFAULT '',
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `url` varchar(250) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `hits` int(11) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `access` int(11) NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  `language` char(7) NOT NULL DEFAULT '',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(10) unsigned NOT NULL DEFAULT '0',
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `metadata` text NOT NULL,
  `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.',
  `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `version` int(10) unsigned NOT NULL DEFAULT '1',
  `images` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`),
  KEY `idx_featured_catid` (`featured`,`catid`),
  KEY `idx_language` (`language`),
  KEY `idx_xreference` (`xreference`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `josci_weblinks`
--

INSERT INTO `josci_weblinks` VALUES (1,61,'Joomla!','joomla','http://www.joomla.org','Home of Joomla!',5,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"0\"}','','2005-02-14 15:19:02',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(2,61,'php.net','php','http://www.php.net','The language that Joomla! is developed in',8,0,0,'0000-00-00 00:00:00',3,1,'[]','','2004-07-07 11:33:24',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(3,61,'MySQL','mysql','http://www.mysql.com','The database that Joomla! uses',3,0,0,'0000-00-00 00:00:00',5,1,'[]','','2004-07-07 10:18:31',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(4,61,'OpenSourceMatters','opensourcematters','http://www.opensourcematters.org','Home of OSM',13,0,0,'0000-00-00 00:00:00',2,1,'{\"target\":\"0\"}','','2005-02-14 15:19:02',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(5,61,'Joomla! - Forums','joomla-forums','http://forum.joomla.org','Joomla! Forums',6,0,0,'0000-00-00 00:00:00',4,1,'{\"target\":\"0\"}','','2005-02-14 15:19:02',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(6,61,'Ohloh Tracking of Joomla!','ohloh-tracking-of-joomla','http://www.ohloh.net/projects/20','Objective reports from Ohloh about Joomla\'s development activity. Joomla! has some star developers with serious kudos.',3,0,0,'0000-00-00 00:00:00',6,1,'{\"target\":\"0\"}','','2007-07-19 09:28:31',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(7,49,'The Oak Initiative','oak','http://www.theoakinitiative.org/','The Oak Initiative is a grassroots movement to unite, mobilize, equip, and activate Christians to be the salt and light they are called to be by engaging in the great issues of our time from a sound biblical worldview.\r\n',230,0,0,'0000-00-00 00:00:00',6,1,'{\"target\":\"\"}','','2010-04-29 23:11:15',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(8,49,'American Family Association','afa','http://www.afa.net/','The American Family Association represents and stands for traditional family values and exists to motivate and equip citizens to reform our culture to reflect Biblical truth on which it was founded. We believe that God has communicated absolute truth to man through nature and the Bible, and that all men everywhere and at all times are subject to His authority. Therefore, a culture based on Biblical truth best serves the well-being of our country as evidenced by the vision of our forefathers as set forth in the Declaration of Independence.\r\n\r\n',239,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"\"}','','2010-04-29 23:14:09',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(9,49,'Transformation Michigan','tmi','http://transformmi.com/','*Become the next Herrnhutt where day and night prayer will rise 24/7/365 until the Lord returns.\r\n\r\n*Establish a networking, connective process where each county will have a flame kindled within to stand in the gap for their county, region, and state. Larger counties will be broken into sections such as Northwest, Northeast, Southwest, Southeast, and Central as houses of prayer arise (Example: Macomb County Southwest House of Prayer to Bring Transformation). All that is initially needed is for one in each county to stand (Ezekiel 22:30). \r\n\r\n*Embrace all races and Christians denominations as not to overlook any people group in the state (Acts 17:26-28, 10:34-35).',961,0,0,'0000-00-00 00:00:00',7,1,'{\"target\":\"\"}','','2010-04-29 23:18:15',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(10,49,'Our Country Deserves Better PAC (Tea Party Express)','tpx','http://www.ourcountrydeservesbetter.com/','Our Country Deserves Better PAC is leading the fight to champion the Reaganesque conservatism of lower taxes, smaller government, strong national defense, and respect for the strength of the family as the core of a strong America.',218,0,0,'0000-00-00 00:00:00',5,1,'{\"target\":\"\"}','','2010-04-30 05:36:53',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(11,49,'Isaiah 58:12','isaiah-5812','http://www.isaiah5812.org/','Your people will rebuild the ancient ruins and raise up the age-old foundations; You will be called Repairer of Broken Walls; Restorer of Streets with Dwellings” (NIV).',383,0,0,'0000-00-00 00:00:00',4,1,'{\"target\":\"\"}','','2010-04-29 23:33:27',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(12,49,'Citizens for Traditional Values MI','ctv','http://www.ctvmichigan.org/','Citizens for Traditional Values (CTV) is a nonprofit civic league working on the grassroots level to encourage an active and informed citizenry in the State of Michigan. CTV seeks to broaden public understanding of the importance of personal freedom and traditional family values; and to work for the adoption of laws and public policies which reflect those values. This is accomplished by educating, networking, and mobilizing the pro-life, pro-family community.\r\n\r\n',917,0,0,'0000-00-00 00:00:00',3,1,'{\"target\":\"\"}','','2010-04-29 23:36:31',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(13,49,'Americans for Prosperity MI','afp','http://www.americansforprosperity.org/michigan','AFP-Michigan is an organization of 29,000 activists committed to strengthening our constitutional government, establishing fiscal restraint, and giving taxpayers greater control over government. We are dedicated to recruiting, training, educating, and motivating grassroots activists to be effective in their own communities. As an AFP member, you will join hundreds of thousands of others around this nation. You will receive training on how to effectively communicate with government officials and get real results right where you live. Most importantly, you will send a message that there is still room for good ideas that make government work better and more efficiently in Michigan.',241,0,0,'0000-00-00 00:00:00',2,1,'{\"target\":\"\"}','','2010-04-29 23:38:11',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(14,15,'Why Taxes Matter','why-taxes-matter','http://www.taxfoundation.org/pdfs/whytaxesmatter.pdf','Beyond giving everybody a collective headache when April rolls around, taxes have a tremendous influence on the American way of life. From daily decisions like where to shop to life’s major decisions – where to buy property, where to establish a business, when and where to retire, and how to plan for death – taxes are there to push you one way or the other, often practically dictating what you can do.',251,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"\"}','','2010-05-11 16:37:29',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(15,15,'Tax Freedom Day','tax-freedom-day','http://www.taxfoundation.org/taxfreedomday/','Tax Freedom Day will arrive on April 9 this year, the 99th day of 2010, according to our annual calculation using the latest government data on income and taxes. Americans will work well over three months of the year—from January 1 to April 9—before they have earned enough money to pay this year\'s tax obligations at the federal, state and local levels.',898,0,0,'0000-00-00 00:00:00',2,1,'{\"target\":\"\"}','','2010-05-11 16:42:09',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(16,15,'What is Tax Deferral','what-is-tax-deferral','http://www.youtube.com/watch?v=hapfclt6mFY','TaxFoundation — May 11, 2009 — The Obama Administration is proposing to raise more than $100 billion from American multinational corporations by limiting in some way the ability of U.S. companies to defer tax on profits earned abroad. The premise behind the proposal is that by raising the taxes paid on the foreign profits of U.S. companies earned abroad, the companies will somehow have more incentive to locate their operations here in the United States.',470,0,0,'0000-00-00 00:00:00',3,1,'{\"target\":\"\"}','','2010-05-11 16:46:03',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(17,12,'Soak the Rich Lose the Rich','soak-the-rich-lose-the-rich','http://online.wsj.com/article/SB124260067214828295.html','Americans know how to use the moving van to escape high taxes.',953,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"\"}','','2010-05-11 16:49:21',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(18,12,'More States Look to Raise Taxes','more-states-look-to-raise-taxes','http://online.wsj.com/article/SB123923448796803135.html','By LESLIE EATON\r\nA free fall in tax revenue is driving more state lawmakers to turn to broad-based tax increases in a bid to close widening budget gaps.\r\n',212,0,0,'0000-00-00 00:00:00',2,1,'{\"target\":\"\"}','','2010-05-11 16:51:54',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(19,12,'Who Pays for Cap and Trade?','who-pays-for-cap-and-trade','http://online.wsj.com/article/SB123655590609066021.html','Cap and trade is the tax that dare not speak its name, and Democrats are hoping in particular that no one notices who would pay for their climate ambitions. With President Obama depending on vast new carbon revenues in his budget and Congress promising a bill by May, perhaps Americans would like to know the deeply unequal ways that climate costs would be distributed across regions and income groups.\r\n\r\n',815,0,0,'0000-00-00 00:00:00',3,1,'{\"target\":\"\"}','','2010-05-11 17:02:02',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(20,12,'Granholm\'s Tax Warning','granholms-tax-warning','http://online.wsj.com/article/SB121192942396124327.html#','It\'s no fun to kick a state when it\'s down – especially when the local politicians are doing a fine job of it – but the latest news of Michigan\'s deepening budget woe is a national warning of what happens when you raise taxes in a weak economy.\r\n\r\n',244,0,0,'0000-00-00 00:00:00',4,1,'{\"target\":\"\"}','','2010-05-11 16:54:16',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(21,12,'Union Workers Hit Harder by High State Taxes, Study Finds','union-workers-hit-harder-by-high-state-taxes-study-finds','http://blogs.wsj.com/economics/2009/08/24/union-workers-hit-harder-by-high-state-taxes-study-finds/','By Martin Vaughan\r\nUnion employees bear more of the burden of high state corporate taxes than non-union employees, according to a new study distributed by the National Bureau of Economic Research.\r\n',222,0,0,'0000-00-00 00:00:00',5,1,'{\"target\":\"\"}','','2010-05-11 16:56:29',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(22,11,'It\'s not just millionaires fleeing Maryland taxes','its-not-just-millionaires-fleeing-maryland-taxes','http://www.washingtonexaminer.com/opinion/columns/marta-mossburg/Its-not-just-millionaires-fleeing-Maryland-taxes-45349682.html','Anyone taking Economics 101 could have predicted that those best able to avoid Maryland’s new 6.25 percent marginal tax rate on income over $1 million would. They are the ones best able to choose where to live and to pay accountants and lawyers to lower their tax burden.',289,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"\"}','','2010-05-11 17:00:27',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(23,10,'Founding Father\'s Quotes','founding-fathers-quotes','http://www.marksquotes.com/Founding-Fathers/','Founding Fathers Quotes\r\nHere are quotes by America\'s founding fathers, quotations about the American Revolution, and assorted remarks related to America\'s founding.',217,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"\"}','','2010-05-13 03:04:19',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(24,10,'Heritage of the Founding Fathers','heritage-of-the-founding-fathers','http://www.heritageofthefoundingfathers.com/index.html','Today, not everyone knows the heritage of America\'s Founding Fathers.  Their intentions are, in some cases, misread or misinterpreted and at times their beliefs are portrayed falsely.  Who were the Founding Fathers and what did they stand for?',452,0,0,'0000-00-00 00:00:00',2,1,'{\"target\":\"\"}','','2010-05-13 03:09:10',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(25,9,'Pravda: American capitalism gone with a whimper ','pravda-american-capitalism-gone-with-a-whimper','http://english.pravda.ru/opinion/columnists/107459-0/','It must be said, that like the breaking of a great dam, the American decent into Marxism is happening with breath taking speed, against the back drop of a passive, hapless sheeple, excuse me dear reader, I meant people...',169,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"\"}','','2010-05-18 04:06:43',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,''),(26,8,'Mahmoud Ahmadinejad','mahmoud-ahmadinejad','http://www.un.org/ga/63/generaldebate/pdf/iran_en.pdf','Statement on Israel and Zionism during 2008 UN General Assembly',295,0,0,'0000-00-00 00:00:00',1,1,'{\"target\":\"\"}','','2010-05-18 04:23:15',873,'','0000-00-00 00:00:00',0,'','','[]',0,'','0000-00-00 00:00:00','0000-00-00 00:00:00',1,'');

--
-- Dumping events for database 'lrbadmin_joom151'
--

--
-- Dumping routines for database 'lrbadmin_joom151'
--


