-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `glycomics`
--

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_11_18_105615_create_uploads_table', 1),
(6, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(8, '2020_04_18_065546_create_settings_table', 1),
(9, '2024_02_20_072827_create_permission_tables', 1),
(10, '2024_05_06_110806_create_pages_table', 2);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_keywords` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `page_layout` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `meta_keywords`, `meta_description`, `slug`, `body`, `created_at`, `updated_at`, `deleted_at`, `page_layout`) VALUES
(1, 'Databases', 'databases', 'databases', 'databases', '<div class=\"rightPan\">\r\n<div class=\"row\">\r\n<div class=\"col\">Column 1</div>\r\n<div class=\"col\">Column 2</div>\r\n</div>\r\n<h3>GlycobioInformatics Databases</h3>\r\nList of some selected databases that are often used for glycobioinformatics analysis. (see: <a href=\"http://glycomicsworkbench.org/dev/databases.php\">Publication</a>)\r\n<h2>CAZy</h2>\r\n<p>Carbohydrate Active EnZyme database. More information is available in the cazy Web site (see: <a href=\"http://www.cazy.org/\" target=\"_blank\" rel=\"noopener\">CAZy</a>)</p>\r\n<h2>GlycoGeneDB (GGDB)</h2>\r\n<p>Glyco enzyme database. More information is available in the Web site (see: <a href=\"https://acgg.asia/ggdb2/\" target=\"_blank\" rel=\"noopener\">GGDB</a>)</p>\r\n<h2>GlycoEpitope</h2>\r\n<p>On Glycan Binding Proteins. Also available at (see: <a href=\"https://glycosmos.org/\" target=\"_blank\" rel=\"noopener\">GlyCosmos.</a>) (see: <a href=\"https://glycoepitope.jp/\" target=\"_blank\" rel=\"noopener\">GlycEpitope</a>)</p>\r\n<h3>Other Useful Tools</h3>\r\n<h2>BRENDA</h2>\r\n<p>A Comprehensive Enzyme Information system. <a href=\"https://brenda-enzymes.org/\" target=\"_blank\" rel=\"noopener\">BRENDA</a> also provides structure-based search function.</p>\r\n<h2>RHEA</h2>\r\n<p>It is an expert-curated knowledgebase of chemical and transport reactions of biological interest. (see: <a href=\"https://www.rhea-db.org/\" target=\"_blank\" rel=\"noopener\">RHEA</a>)</p>\r\n<h2>UNIPROT</h2>\r\n<p>It is the world&rsquo;s leading high-quality, comprehensive and freely accessible resource of protein sequence and functional information. See: <a href=\"https://www.uniprot.org/\" target=\"_blank\" rel=\"noopener\">UniProt.</a></p>\r\n</div>', '2024-05-06 06:50:04', '2024-05-07 10:44:55', NULL, 'sidebar-right'),
(2, 'About', 'Glycomics Workbench', 'Glycomics Workbench', 'about', '<div class=\"rightPan\">\r\n<h3>About Glycomics Workbench</h3>\r\n<p style=\"text-align: justify;\">The development of <strong>Glycomics Workbench</strong> is based on a combination of Grid technology and cloud computing that will be supported by High-Performance Computing (similar technology was used earlier for CHOIS (<a href=\"http://glycomicsworkbench.org/publications/healthgrid10.pdf\" target=\"_blank\" rel=\"noopener\">CHOIS</a>) and various Large Language Models (LLMs) of generative AI for searching and generating chat or text based output. This is designed to serve the Glyco-Community and other researchers who have interest in Glycobiology. Unlike the <a href=\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3063003/\" target=\"_blank\" rel=\"noopener\">central dogma</a> where the information or code flows from DNA to RNA to Protein, <strong>Glycocode</strong> or the code that deciphers the information (human glycocode consists of a combination of 10 monosaccharides in different orders) for a variety of cellular functions including cell signaling are the result of orchestrated functions of a set of glycosyltransferases. A single protein can be decorated by a variety of carbohydrates (syn. Glycans) resulting in multiple forms of glycoproteins. Thus, while the total number of mammalian cellular proteins is estimated at about 20000, glycosylation turns those into unaccounted numbers. Structural identification of those glycoconjugates is time consuming and tedious. <strong>Glycome</strong> or the carbohydrate (glycan) related data generated using a variety of analytical techniques are needed for their structural identification. A variety of software tools and databases have been developed for <strong>Glycomics</strong> or the analysis of those glycoconjugates from glycoproteins, glycolipids and proteoglycans (see <a href=\"https://novapublishers.com/shop/glycome-the-hidden-code-in-biology/\" target=\"_blank\" rel=\"noopener\">here</a> for article 16). Not all are web-based making those stand-alone software tools unavailable for use when needed by the Glyco-Community. Glycomics Workbench is designed to provide those tools via C-Grid (see this paper), a community data grid that can be utilized by the developers and researchers for sharing those tools via this web portal. Moreover, this website will serve as a portal providing access to all the web-based resources needed for Glycome research. This is also designed to provide information generated by various LLMs that can benefit the students and researchers learning glycobiology. Educators will also benefit from that information teaching glycobiology in a class-based or one-on-one set-up.</p>\r\n</div>', '2024-05-07 06:11:14', '2024-05-07 06:12:25', NULL, 'sidebar-left'),
(3, 'Tools', 'Glycomics Workbench', 'Glycomics Workbench', 'tools', '<div class=\"rightPan\">GlycobioInformatics Tools\r\n<p>List of commonly used specialized software tools for Mass Spectral (MS/MS/LC-MS) Data Analysis (see: <a href=\"http://glycomicsworkbench.org/dev/tools.php\">Publication</a>)</p>\r\n<h3>BIONIC</h3>\r\n<p>For Glycopeptide identification, a Proprietary software (see: <a href=\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3545648/\" target=\"_blank\" rel=\"noopener\">PMID: 23255153</a>)</p>\r\n<h3>CARTOONIST</h3>\r\n<p>For MS analysis of glycan structure, a standalone tool software (see: <a href=\"https://link.springer.com/protocol/10.1007/978-1-62703-146-2_18\" target=\"_blank\" rel=\"noopener\">Yu, CY., et. al., 2013</a>)</p>\r\n<h3>GAGfinder</h3>\r\n<p>MS analysis specifically for GAGs, A standalone softwar (see: <a href=\"https://pubmed.ncbi.nlm.nih.gov/29615495/\" target=\"_blank\" rel=\"noopener\">PMID: 29615495</a>)</p>\r\n<h2>GAG-ID</h2>\r\n<p>MS analysis of heparin/heparan sulfate, a standalone software (see: <a href=\"https://pubmed.ncbi.nlm.nih.gov/25887393/\" target=\"_blank\" rel=\"noopener\">PMID: 25887393</a>)</p>\r\n<h3>GLYCOFOREST</h3>\r\n<p>LC-MS analysis of glycan, a standalone tool (see: <a href=\"https://achs-prod.acs.org/doi/10.1021/acs.analchem.7b02754\" target=\"_blank\" rel=\"noopener\">Glycoforest 1.0</a>)</p>\r\n<h3>GLYCOFRAGMENT</h3>\r\n<p>For MS analysis of glycan A part of glycosciences.de portal (see: Ref)</p>\r\n<h3>GLYCOANALYZER</h3>\r\n<p>Automated glycan annotation software from MS analysis data, a standalone software (see: <a href=\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3567444/\" target=\"_blank\" rel=\"noopener\">PMID: 22903841</a>)</p>\r\n<h3>Other Useful Tools</h3>\r\n<h3>GRITS Toolbox</h3>\r\n<p>A <a href=\"http://www.grits-toolbox.org/\" target=\"_blank\" rel=\"noopener\">platform</a> for glycomics data processing and archiving.</p>\r\n</div>', '2024-05-07 06:14:44', '2024-05-07 06:14:44', NULL, 'sidebar-left'),
(4, 'Portals', 'Glycomics Workbench', 'Glycomics Workbench', 'portals', '<h3>GlycobioInformatics Portals</h3>\r\n<p>List of portals that are commonly used for glycobioinformatics analysis. (see: <a href=\"http://glycomicsworkbench.org/dev/portals.php\">Publication</a>)</p>\r\n<h3>Glycomics@ExPaSy</h3>\r\n<p>Gateway to multiple resources, part of SIB resources; also includes GlyConnect. (see: <a href=\"https://www.expasy.org/search/glycomics\" target=\"_blank\" rel=\"noopener\">Expasy</a>)</p>\r\n<h3>GlyCosmos</h3>\r\n<p>Glycome database Supported by JSCR (see: <a href=\"https://glycosmos.org/\" target=\"_blank\" rel=\"noopener\">GlyCosmos</a>)</p>\r\n<h4>Other Useful Tools</h4>\r\n<h3>Protein Data Bank (PDB)</h3>\r\n<p>A <a href=\"https://www.wwpdb.org/\" target=\"_blank\" rel=\"noopener\">PDB</a> A single repository of information about the 3D structures of proteins, nucleic acids, and complex assemblies.</p>', '2024-05-07 06:16:09', '2024-05-07 06:16:36', NULL, 'sidebar-left'),
(5, 'Info Links', 'Glycomics Workbench', 'Glycomics Workbench', 'info-links', '<p style=\"text-align: justify;\">The federal government Office of the National Coordinator for Health Information Technology (<a href=\"https://www.healthit.gov/topic/about-onc\" target=\"_blank\" rel=\"noopener\">ONC</a>) is at the forefront of the administration&rsquo;s health IT efforts and is a resource to the entire health system to support the adoption of health information technology and the promotion of nationwide health information exchange to improve health care. ONC is organizationally located within the Office of the Secretary for the U.S. Department of Health and Human Services (HHS).</p>\r\n<p style=\"text-align: justify;\">The National Institutes of Health (<a href=\"http://www.nih.gov/\" target=\"_blank\" rel=\"noopener\">NIH</a>), a part of the U.S. Department of Health and Human Services (<a href=\"https://www.hhs.gov\" target=\"_blank\" rel=\"noopener\">HHS</a>), is the primary Federal agency for conducting and supporting medical research. It also provides authentic health information for public awareness (<a title=\"Health Information\" href=\"http://health.nih.gov/\" target=\"_blank\" rel=\"noopener\">see</a>; also see, <a title=\"AHRQ\" href=\"https://www.ahrq.gov/\" target=\"_blank\" rel=\"noopener\"><strong>AHRQ</strong></a>). Its Eunice Kennedy Shriver National Institute of Child Health and Human Development (<a title=\"NICHD\" href=\"http://www.nichd.nih.gov/\" target=\"_blank\" rel=\"noopener\">NICHD</a>), established by U.S. congress in 1962, conducts and supports research on topics related to the health of children. To learn more about the Institute and its activities, <a title=\"NICHD\" href=\"http://www.nichd.nih.gov/\" target=\"_blank\" rel=\"noopener\">see</a>.</p>\r\n<p style=\"text-align: justify;\">Centers for Disease Control and Prevention (<a href=\"http://www.cdc.gov/\" target=\"_blank\" rel=\"noopener\">CDC</a>) is dedicated to protecting health and promoting quality of life through appropriate information on the prevention and control of disease. Also, see its National Center for Public Health Informatics (<a href=\"http://www.cdc.gov/ncphi/\" target=\"_blank\" rel=\"noopener\">NCPHI</a>).</p>\r\n<p style=\"text-align: justify;\">​​The Lawrence Gartner, M.D., FAAP and Carol Gartner, Ph.D. Pediatric History Center is dedicated to preserving and cataloguing materials representing the history of pediatrics and children\'s health care. It also serves as the repository of the Archives of the American Academy of Pediatrics (<a href=\"http://www.aap.org/\" target=\"_blank\" rel=\"noopener\">AAP</a>).</p>\r\n<p style=\"text-align: justify;\">The American Medical Association (<a href=\"http://www.ama-assn.org/\" target=\"_blank\" rel=\"noopener\">AMA</a>) guides medical professionals helping patients by uniting physicians nationwide to work on important professional and public health issues.</p>\r\n<p style=\"text-align: justify;\">The Center for Nutrition Policy and Promotion at the United States Department of Agriculture (<a title=\"CNPP\" href=\"https://www.fns.usda.gov/cnpp\" target=\"_blank\" rel=\"noopener\">CNPP</a>) is dedicated to improve the health and well-being of Americans by developing and promoting dietary guidance that links scientific research to the nutrition needs of consumers. To learn more about the Center and its activities, <a href=\"http://www.cnpp.usda.gov\" target=\"_blank\" rel=\"noopener\">see</a>.</p>\r\n<p style=\"text-align: justify;\">When Kenneth H. Cooper, M.D., M.P.H., published his first bestseller, Aerobics, in 1968, he introduced a new word and a new concept in US. Millions of americans started exercising, motivated by his preventive medicine research, persuasive public appearances, and a series of inspiring books. In short, it started a fitness revolution. He then founded The <a title=\"Cooper Institute\" href=\"http://www.cooperinstitute.org\" target=\"_blank\" rel=\"noopener\">Cooper Institute </a>in 1970, to promote fitness education in US and across the Globe. To learn more about the Institute and its activities, <a href=\"http://www.cooperinstitute.org\" target=\"_blank\" rel=\"noopener\">see</a>.</p>', '2024-05-07 06:18:20', '2024-05-07 06:18:20', NULL, 'sidebar-left'),
(6, 'home', 'Glycomics Workbench', 'Glycomics Workbench', 'home', '<div class=\"row\">\r\n<div class=\"col-4 p-4\">\r\n<h3>News &amp; <span>Views</span></h3>\r\n<ul class=\"lists\">\r\n<li class=\"nopad\"><img src=\"images/NIHlogo.jpg\" alt=\" \" width=\"68\" height=\"56\" />\r\n<p>NIH announced new<strong> strategic plan Bridge2AI.</strong> Find out more <a target=\"_blank\" rel=\"noopener\">here</a> on the strategic plan for Bridge2AI research.</p>\r\n</li>\r\n<li class=\"nopad\"><img src=\"images/NIHlogo.jpg\" alt=\" \" width=\"68\" height=\"56\" />\r\n<p>NIH announced new <strong>programs under Common Fund.</strong> Bridge2AI <a href=\"StrategicPlanDiabetes.pdf\" target=\"_blank\" rel=\"noopener\">here</a> Bridge2AI is a short-term, goal-driven strategic investment supported by the NIH Common Fund. See its recent announcements: SysBio (https://commonfund.nih.gov/venture/sysbio) and Occulomics (https://commonfund.nih.gov/venture/oculomics).</p>\r\n</li>\r\n</ul>\r\n</div>\r\n<div class=\"col-4 p-4\">\r\n<h3>Welcome <span>Message</span></h3>\r\n<p>In collaboration with the glyco-community, higher education, and industries<strong><a href=\"http://www.dattaconsultinggroup.com/\" target=\"_blank\" rel=\"noopener\">DCG</a></strong> is engaged in developing software tools and technologies that can benefit this field of study.</p>\r\n</div>\r\n<div class=\"col-4 p-4\">\r\n<h3>Education &amp; <span>Training</span></h3>\r\n<p>Educating the workforce with proper training particularly on the application of CI-supported tools for glycome research is an important activity of <a href=\"http://www.dattaconsultinggroup.com/\" target=\"_blank\" rel=\"noopener\">DCG</a>. Read <a href=\"project_summary.pdf\" target=\"_blank\" rel=\"noopener\">here</a> for more.</p>\r\n</div>\r\n</div>', '2024-05-07 10:09:01', '2024-05-13 02:25:12', NULL, 'home');

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'create role', 'web', '2024-04-30 05:29:43', '2024-04-30 05:29:43'),
(2, 'update role', 'web', '2024-04-30 09:29:44', '2024-04-30 09:29:44');

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'web', '2024-04-30 05:29:17', '2024-04-30 05:29:17');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1);

-- --------------------------------------------------------

--
-- Table structure for table `slider`
--

CREATE TABLE IF NOT EXISTS `slider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `author` varchar(25) NOT NULL,
  `topic` varchar(25) NOT NULL,
  `slider_image` varchar(255) NOT NULL,
  `slider_thumbnail` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `read_more_url` varchar(255) NOT NULL,
  `slider_visible` enum('yes','no') NOT NULL DEFAULT 'yes',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `title`, `author`, `topic`, `slider_image`, `slider_thumbnail`, `description`, `read_more_url`, `slider_visible`, `created_at`, `updated_at`) VALUES
(3, 'Glycobiology Test', 'Glycomics', 'About Glycobiology Test', 'uploads/sliders/1714980360.jpg', 'uploads/sliders/t1714980360.jpg', '<p>test</p>', 'http://glycomicsworkbench.org/dev/', 'yes', '2024-05-05 13:23:26', '2024-05-07 10:42:10'),
(4, 'Glycoproteins', 'Glycomics', 'About Glycoproteins', 'uploads/sliders/1714937094.jpg', 'uploads/sliders/t1714937094.jpg', '<p>Carbohydrates are often covalently bonded to the side chains of amino acids in proteins forming glycoproteins. This attachment, termed glycosylation, can occur either at the nitrogen atom in the side chain of asparagine (N-linked glycosylation) or at the oxygen atom in the side chain of serine or threonine (O-linked glycosylation) of the amino acids. Glycosylation can occur either during protein translation or as a post-translational&nbsp;</p>', 'http://glycomicsworkbench.org/dev/', 'yes', '2024-05-05 13:54:55', '2024-05-05 13:54:55'),
(5, 'Glycolipids', 'Glycomics', 'About Glycolipids', 'uploads/sliders/1714937135.jpg', 'uploads/sliders/t1714937135.jpg', '<p>Carbohydrates when bind to a lipid via a glycosidic bond form glycolipids. The lipid portion can be either a glycerolipid (with a glycerol backbone) or a sphingolipid (with a sphingosine backbone). Fatty acids are connected to this backbone, resulting in a polar head and a non-polar tail. The carbohydrates attached to the polar head groups on the cell\'s outer surface form the ligand components of glycolipids. These are&nbsp;</p>', 'http://glycomicsworkbench.org/dev/', 'yes', '2024-05-05 13:55:35', '2024-05-05 13:55:35'),
(6, 'Proteoglycans', 'Glycomics', 'About Proteoglycans', 'uploads/sliders/1714937199.jpg', 'uploads/sliders/t1714937199.jpg', '<p>Proteoglycans are macromolecules consisting of a core protein to which one or more glycosaminoglycan (GAG) chains are covalently attached. The core protein can be either a glycerolipid or a sphingolipid. The GAG chains are long, linear carbohydrate polymers with negative charges due to sulfate and uronic acid groups. The point of attachment is typically a serine (Ser) residue, forming a tetrasaccharide bridge. These are found in our bodies, particularly in connective tissues, bone, cartilage, and cell surfaces.</p>', 'http://glycomicsworkbench.org/dev/', 'yes', '2024-05-05 13:56:39', '2024-05-05 13:56:39'),
(7, 'Roles in Health & Diseases', 'Glycomics', 'Health & Diseases', 'uploads/sliders/1714938778.jpg', 'uploads/sliders/t1714938778.jpg', '<div class=\"answercell post-layout--right\">\r\n<div class=\"s-prose js-post-body\">\r\n<p>You need to use <code>Laravel Eloquent</code> feature to make timestamps written to the Database automatically, when you insert data directly, <code>Laravel</code> does not know about your timestamps. You need to set the timestamps manually in the insert statement.</p>\r\n</div>\r\n</div>', 'http://glycomicsworkbench.org/dev/', 'yes', '2024-05-05 14:22:58', '2024-05-05 14:22:58');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

