-- http://www.phpmyadmin.net
--




--
-- Database: `mm_new`
--

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

--
-- Table structure for table `snf_abstract_indexing`
--

CREATE TABLE IF NOT EXISTS `snf_abstract_indexing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journalID` int(11) NOT NULL,
  `journalLink` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `snf_abstract_indexing`
--

INSERT INTO `snf_abstract_indexing` (`id`, `journalID`, `journalLink`, `entryDate`, `status`) VALUES
(2, 4, 'http://localhost/projects/mm_new/journal-details/applied-bioinformatics-in-animal-health-microbiology/4/abstracting-and-indexing', '2013-07-27 11:04:22', 1);

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

--
-- Table structure for table `snf_ads`
--

CREATE TABLE IF NOT EXISTS `snf_ads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adImage` varchar(255) NOT NULL,
  `adFile` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_ads`
--

INSERT INTO `snf_ads` (`id`, `adImage`, `adFile`, `entryDate`) VALUES
(1, '20130727211854.jpg', '086d1_RamadhanHealth_Guide.pdf', '2013-07-27 21:54:19'),
(2, '20130727213655.jpg', '40c59_RamadhanHealth_Guide.pdf', '2013-07-27 21:55:36'),
(3, 'test', 'test', '2013-07-28 00:00:00');

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

--
-- Table structure for table `snf_archives`
--

CREATE TABLE IF NOT EXISTS `snf_archives` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journalID` int(11) NOT NULL,
  `archiveYear` int(11) NOT NULL,
  `archiveMonth` int(11) NOT NULL,
  `currentIssueID` int(11) NOT NULL,
  `archiveTitle` varchar(255) NOT NULL,
  `archiveVolume` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  `archiveStatus` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `snf_archives`
--

INSERT INTO `snf_archives` (`id`, `journalID`, `archiveYear`, `archiveMonth`, `currentIssueID`, `archiveTitle`, `archiveVolume`, `entryDate`, `archiveStatus`) VALUES
(2, 4, 2012, 1, 2, 'January; 84 (1): 1 - 671', 'Vol. 87, Issue 6', '2013-06-26 10:28:04', 1),
(3, 4, 2013, 2, 2, 'February; 84 (3): 1213 - 1664', 'Vol. 87, Issue 6', '2013-06-26 10:28:31', 1),
(4, 4, 2013, 3, 2, 'March; 84 (5): 2187 - 2634 ', 'Vol. 87, Issue 6', '2013-06-26 10:28:52', 1),
(5, 4, 2013, 6, 2, 'June; 84 (11): 5457 - 5846', 'Vol. 87, Issue 6', '2013-06-26 13:00:05', 1),
(6, 4, 2013, 6, 3, 'June; 84 (11): 5457 - 5846', 'Vol. 87, Issue 6', '2013-06-29 07:22:16', 1);

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

--
-- Table structure for table `snf_books`
--

CREATE TABLE IF NOT EXISTS `snf_books` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bookName` varchar(255) NOT NULL,
  `bookEditorAuthor` varchar(255) NOT NULL,
  `bookISBN` varchar(255) NOT NULL,
  `bookPages` int(11) NOT NULL,
  `bookPublisher` varchar(255) NOT NULL,
  `bookPublicationDate` date NOT NULL,
  `bookPrice` float(10,2) NOT NULL,
  `bookDescription` text NOT NULL,
  `bookImage` varchar(255) NOT NULL,
  `bookFile` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  `bookStatus` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_books`
--

INSERT INTO `snf_books` (`id`, `bookName`, `bookEditorAuthor`, `bookISBN`, `bookPages`, `bookPublisher`, `bookPublicationDate`, `bookPrice`, `bookDescription`, `bookImage`, `bookFile`, `entryDate`, `bookStatus`) VALUES
(2, 'Liver Biopsy', 'Hirokazu Takahashi', '978-953-307-644-7', 500, 'Caister Academic Press', '2010-10-10', 500.00, '<p>Chapter 1: Biodiesel Production by Using Heterogeneous Catalysts Rubi Romero, Sandra Luz Mart&iacute;nez and Reyna Natividad</p>\r\n<p>Chapter 2: Biodiesel Production by Using Heterogeneous Catalysts Rubi Romero, Sandra Luz Mart&iacute;nez and Reyna Natividad</p>\r\n<p>Chapter 3: Biodiesel Production by Using Heterogeneous Catalysts Rubi Romero, Sandra Luz Mart&iacute;nez and Reyna Natividad</p>\r\n<p>Chapter 4: Biodiesel Production by Using Heterogeneous Catalysts Rubi Romero, Sandra Luz Mart&iacute;nez and Reyna Natividad</p>\r\n<p>Chapter 5: Biodiesel Production by Using Heterogeneous Catalysts Rubi Romero, Sandra Luz Mart&iacute;nez and Reyna Natividad</p>\r\n<p>Chapter 6: Biodiesel Production by Using Heterogeneous Catalysts Rubi Romero, Sandra Luz Mart&iacute;nez and Reyna Natividad</p>\r\n<p>Chapter 7: Biodiesel Production by Using Heterogeneous Catalysts Rubi Romero, Sandra Luz Mart&iacute;nez and Reyna Natividad</p>', '20130710112923.png', '1373455409_NTS-GAT-A-Sample-Paper.pdf', '0000-00-00 00:00:00', 1),
(3, 'Ramzan', 'Qari Abdul Basit', '743-524-307-326-1', 100, 'Ramzan Publishers', '2010-10-10', 500.00, '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas dictum  non justo id rutrum. Suspendisse eros mauris, lacinia et mollis a,  vulputate ut turpis. Phasellus volutpat, libero ac ultrices consectetur,  purus quam consequat nisi, vel commodo magna massa quis magna. Sed  risus ante, consequat sit amet urna non, iaculis adipiscing sem.  Maecenas elementum ac neque in faucibus. Aliquam porttitor ante non  scelerisque suscipit. Etiam at urna quis metus consequat semper. Morbi  elementum tincidunt est ut porta. Aenean nec ante non neque euismod  euismod ut in mi. Sed auctor tellus lacus, at dignissim diam interdum  sit amet. Suspendisse in convallis nunc. Pellentesque vestibulum turpis  sed ligula eleifend commodo.</p>\r\n<p>Aliquam erat volutpat. Integer vitae ornare orci. Integer rutrum tellus  vitae odio sollicitudin, in rhoncus augue malesuada. Cum sociis natoque  penatibus et magnis dis parturient montes, nascetur ridiculus mus.  Nullam fermentum mollis mauris, id malesuada eros luctus vitae. Aenean  aliquet sapien eu nibh varius mollis. Sed volutpat nisi ac massa  pulvinar, et interdum dolor accumsan. Donec aliquam eu eros id eleifend.  Mauris commodo massa sed justo convallis, in interdum lacus fermentum.  Quisque mi lacus, tristique nec vestibulum ac, pretium sed urna.</p>\r\n<p>Suspendisse sodales metus eu risus lacinia bibendum. Nulla fermentum  turpis eget ligula venenatis semper. Suspendisse gravida velit et risus  rhoncus venenatis. Phasellus eleifend mauris eleifend, condimentum nunc  vel, accumsan ipsum. Nam egestas eget massa in tincidunt. Sed non est  bibendum justo ornare porta. Curabitur auctor lectus in mauris  sollicitudin, nec congue velit consequat. Donec luctus suscipit  adipiscing. Cras volutpat ut nunc vel dictum. Donec sit amet ante augue.  Donec ut congue augue, non fermentum tellus.</p>\r\n<p>Praesent ut enim at eros congue egestas et tincidunt neque. Aenean  lectus tortor, lobortis et dignissim id, bibendum sit amet tellus. Donec  malesuada viverra nunc id pretium. Aenean et augue nunc. Maecenas  laoreet metus arcu, eu ultrices nibh consequat id. Nulla vel cursus  urna. Curabitur eu condimentum urna. Phasellus accumsan felis sit amet  erat egestas vulputate. Donec ac magna massa. Sed sit amet vestibulum  sem. Pellentesque viverra tempus eros, sed convallis ante dictum at.  Vivamus eget massa gravida, luctus sapien vitae, hendrerit justo.</p>', '20130710143925.jpg', '1373466339_FoRE-chapter01-v7.pdf', '0000-00-00 00:00:00', 1);

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

--
-- Table structure for table `snf_bookscontactus`
--

CREATE TABLE IF NOT EXISTS `snf_bookscontactus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `emailAddress` varchar(255) NOT NULL,
  `phoneNumber` varchar(255) NOT NULL,
  `emailAddress2` varchar(255) NOT NULL,
  `emailAddress3` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `snf_bookscontactus`
--

INSERT INTO `snf_bookscontactus` (`id`, `emailAddress`, `phoneNumber`, `emailAddress2`, `emailAddress3`) VALUES
(1, 'info@smithandfranklin.com', '0010 222 111 1234', 'info@smithandfranklin.com', 'info@smithandfranklin.com');

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

--
-- Table structure for table `snf_countries`
--

CREATE TABLE IF NOT EXISTS `snf_countries` (
  `iso1_code` char(2) COLLATE utf8_bin NOT NULL,
  `name_caps` varchar(80) COLLATE utf8_bin NOT NULL,
  `name` varchar(80) COLLATE utf8_bin NOT NULL,
  `iso3_code` char(3) COLLATE utf8_bin DEFAULT NULL,
  `num_code` smallint(6) DEFAULT NULL,
  `shipping_rate` int(11) NOT NULL,
  `shiping_rate_otherkg` int(11) NOT NULL,
  `ccode` varchar(20) COLLATE utf8_bin NOT NULL,
  `status` varchar(2) COLLATE utf8_bin NOT NULL DEFAULT 'A',
  PRIMARY KEY (`iso1_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `snf_countries`
--

INSERT INTO `snf_countries` (`iso1_code`, `name_caps`, `name`, `iso3_code`, `num_code`, `shipping_rate`, `shiping_rate_otherkg`, `ccode`, `status`) VALUES
('AD', 'ANDORRA', 'Andorra', 'AND', 20, 1, 0, 'Euro', 'A'),
('AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'ARE', 784, 0, 0, 'AED', 'A'),
('AF', 'AFGHANISTAN', 'Afghanistan', 'AFG', 4, 10, 5, 'AFA', 'A'),
('AG', 'ANTIGUA', 'Antigua', 'ATG', 28, 0, 0, 'XCD', 'A'),
('AI', 'ANGUILLA', 'Anguilla', 'AIA', 660, 0, 0, 'XCD', 'A'),
('AL', 'ALBANIA', 'Albania', 'ALB', 8, 0, 0, 'Lek', 'A'),
('AM', 'ARMENIA', 'Armenia', 'ARM', 51, 0, 0, 'Dram', 'A'),
('AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'ANT', 530, 0, 0, 'ANG', 'A'),
('AO', 'ANGOLA', 'Angola', 'AGO', 24, 0, 0, 'AOA', 'A'),
('AQ', 'ANTARCTICA', 'Antarctica', 'AA', NULL, 0, 0, '', 'A'),
('AR', 'ARGENTINA', 'Argentina', 'ARG', 32, 0, 0, 'ARS', 'A'),
('AS', 'AMERICAN SAMOA', 'American Samoa', 'ASM', 16, 0, 0, 'USD', 'A'),
('AT', 'AUSTRIA', 'Austria', 'AUT', 40, 0, 0, 'Euro', 'A'),
('AU', 'AUSTRALIA', 'Australia', 'AUS', 36, 0, 0, 'AUD', 'A'),
('AW', 'ARUBA', 'Aruba', 'ABW', 533, 0, 0, 'AWG', 'A'),
('AZ', 'AZERBAIJAN', 'Azerbaijan', 'AZE', 31, 0, 0, 'Manat', 'A'),
('BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia ', 'BIH', 70, 0, 0, 'BAM', 'A'),
('BB', 'BARBADOS', 'Barbados', 'BRB', 52, 0, 0, 'BBD', 'A'),
('BD', 'BANGLADESH', 'Bangladesh', 'BGD', 50, 0, 0, 'Taka', 'A'),
('BE', 'BELGIUM', 'Belgium', 'BEL', 56, 0, 0, 'euro', 'A'),
('BF', 'BURKINA FASO', 'Burkina Faso', 'BFA', 854, 0, 0, 'XOF', 'A'),
('BG', 'BULGARIA', 'Bulgaria', 'BGR', 100, 0, 0, 'BGN', 'A'),
('BH', 'BAHRAIN', 'Bahrain', 'BHR', 48, 0, 0, 'BHD', 'A'),
('BI', 'BURUNDI', 'Burundi', 'BDI', 108, 0, 0, 'BIF', 'A'),
('BJ', 'BENIN', 'Benin', 'BEN', 204, 0, 0, 'CFA', 'A'),
('BM', 'BERMUDA', 'Bermuda', 'BMU', 60, 0, 0, 'BMD', 'A'),
('BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'BRN', 96, 0, 0, 'BND', 'A'),
('BO', 'BOLIVIA', 'Bolivia', 'BOL', 68, 0, 0, 'BOB', 'A'),
('BR', 'BRAZIL', 'Brazil', 'BRA', 76, 0, 0, 'BRL', 'A'),
('BS', 'BAHAMAS', 'Bahamas', 'BHS', 44, 0, 0, 'BSD', 'A'),
('BT', 'BHUTAN', 'Bhutan', 'BTN', 64, 0, 0, 'BTN', 'A'),
('BV', 'BOUVET ISLAND', 'Bouvet Island', NULL, NULL, 0, 0, 'NOK', 'A'),
('BW', 'BOTSWANA', 'Botswana', 'BWA', 72, 0, 0, 'BWP', 'A'),
('BY', 'BELARUS', 'Belarus', 'BLR', 112, 0, 0, 'BYR', 'A'),
('BZ', 'BELIZE', 'Belize', 'BLZ', 84, 0, 0, 'BZD', 'A'),
('CA', 'CANADA', 'Canada', 'CAN', 124, 0, 0, 'CAD', 'A'),
('CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', NULL, NULL, 0, 0, '', 'A'),
('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, Democratic Republic', 'COD', 180, 0, 0, '', 'A'),
('CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'CAF', 140, 0, 0, 'XAF', 'A'),
('CG', 'CONGO', 'Congo', 'COG', 178, 0, 0, '', 'A'),
('CH', 'SWITZERLAND', 'Switzerland', 'CHE', 756, 0, 0, 'CHF', 'A'),
('CI', 'COTE D''IVOIRE', 'Cote D''Ivoire', 'CIV', 384, 0, 0, '', 'A'),
('CK', 'COOK ISLANDS', 'Cook Islands', 'COK', 184, 0, 0, '', 'A'),
('CL', 'CHILE', 'Chile', 'CHL', 152, 0, 0, 'CLP', 'A'),
('CM', 'CAMEROON', 'Cameroon', 'CMR', 120, 0, 0, '', 'A'),
('CN', 'CHINA', 'China', 'CHN', 156, 0, 0, 'CNY', 'A'),
('CO', 'COLOMBIA', 'Colombia', 'COL', 170, 0, 0, 'COP', 'A'),
('CR', 'COSTA RICA', 'Costa Rica', 'CRI', 188, 0, 0, '', 'A'),
('CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', NULL, NULL, 0, 0, 'CSD', 'A'),
('CU', 'CUBA', 'Cuba', 'CUB', 192, 0, 0, '', 'A'),
('CV', 'CAPE VERDE', 'Cape Verde', 'CPV', 132, 0, 0, 'CVE', 'A'),
('CX', 'CHRISTMAS ISLAND', 'Christmas Island', NULL, NULL, 0, 0, '', 'A'),
('CY', 'CYPRUS', 'Cyprus', 'CYP', 196, 0, 0, '', 'A'),
('CZ', 'CZECH REPUBLIC', 'Czech Republic', 'CZE', 203, 0, 0, 'CZK', 'A'),
('DE', 'GERMANY', 'Germany', 'DEU', 276, 0, 0, '', 'A'),
('DJ', 'DJIBOUTI', 'Djibouti', 'DJI', 262, 0, 0, '', 'A'),
('DK', 'DENMARK', 'Denmark', 'DNK', 208, 0, 0, 'DKK', 'A'),
('DM', 'DOMINICA', 'Dominica', 'DMA', 212, 0, 0, '', 'A'),
('DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'DOM', 214, 0, 0, '', 'A'),
('DZ', 'ALGERIA', 'Algeria', 'DZA', 12, 15, 12, 'DZD', 'A'),
('EC', 'ECUADOR', 'Ecuador', 'ECU', 218, 0, 0, 'EUR', 'A'),
('EE', 'ESTONIA', 'Estonia', 'EST', 233, 0, 0, 'EEK', 'A'),
('EG', 'EGYPT', 'Egypt', 'EGY', 818, 0, 0, 'EGP', 'A'),
('EH', 'WESTERN SAHARA', 'Western Sahara', 'ESH', 732, 0, 0, '', 'A'),
('ER', 'ERITREA', 'Eritrea', 'ERI', 232, 0, 0, '', 'A'),
('ES', 'SPAIN', 'Spain', 'ESP', 724, 0, 0, '', 'A'),
('ET', 'ETHIOPIA', 'Ethiopia', 'ETH', 231, 0, 0, '', 'A'),
('FI', 'FINLAND', 'Finland', 'FIN', 246, 0, 0, '', 'A'),
('FJ', 'FIJI', 'Fiji', 'FJI', 242, 0, 0, 'FJD', 'A'),
('FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'FLK', 238, 0, 0, '', 'A'),
('FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia', 'FSM', 583, 0, 0, '', 'A'),
('FO', 'FAROE ISLANDS', 'Faroe Islands', 'FRO', 234, 0, 0, '', 'A'),
('FR', 'FRANCE', 'France', 'FRA', 250, 0, 0, '', 'A'),
('GA', 'GABON', 'Gabon', 'GAB', 266, 0, 0, '', 'A'),
('GB', 'UNITED KINGDOM', 'United Kingdom', 'GBR', 826, 0, 0, '', 'A'),
('GD', 'GRENADA', 'Grenada', 'GRD', 308, 0, 0, '', 'A'),
('GE', 'GEORGIA', 'Georgia', 'GEO', 268, 0, 0, '', 'A'),
('GF', 'FRENCH GUIANA', 'French Guiana', 'GUF', 254, 0, 0, '', 'A'),
('GH', 'GHANA', 'Ghana', 'GHA', 288, 0, 0, '', 'A'),
('GI', 'GIBRALTAR', 'Gibraltar', 'GIB', 292, 0, 0, '', 'A'),
('GL', 'GREENLAND', 'Greenland', 'GRL', 304, 0, 0, '', 'A'),
('GM', 'GAMBIA', 'Gambia', 'GMB', 270, 0, 0, '', 'A'),
('GN', 'GUINEA', 'Guinea', 'GIN', 324, 0, 0, '', 'A'),
('GP', 'GUADELOUPE', 'Guadeloupe', 'GLP', 312, 0, 0, '', 'A'),
('GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'GNQ', 226, 0, 0, '', 'A'),
('GR', 'GREECE', 'Greece', 'GRC', 300, 0, 0, '', 'A'),
('GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia ', NULL, NULL, 0, 0, '', 'A'),
('GT', 'GUATEMALA', 'Guatemala', 'GTM', 320, 0, 0, '', 'A'),
('GU', 'GUAM', 'Guam', 'GUM', 316, 0, 0, '', 'A'),
('GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'GNB', 624, 0, 0, '', 'A'),
('GY', 'GUYANA', 'Guyana', 'GUY', 328, 0, 0, '', 'A'),
('HK', 'HONG KONG', 'Hong Kong', 'HKG', 344, 0, 0, 'HKD', 'A'),
('HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Islands', NULL, NULL, 0, 0, '', 'A'),
('HN', 'HONDURAS', 'Honduras', 'HND', 340, 0, 0, 'HNL', 'A'),
('HR', 'CROATIA', 'Croatia', 'HRV', 191, 0, 0, 'HRK', 'A'),
('HT', 'HAITI', 'Haiti', 'HTI', 332, 0, 0, '', 'A'),
('HU', 'HUNGARY', 'Hungary', 'HUN', 348, 0, 0, 'HUF', 'A'),
('ID', 'INDONESIA', 'Indonesia', 'IDN', 360, 0, 0, 'IDR', 'A'),
('IE', 'IRELAND', 'Ireland', 'IRL', 372, 0, 0, '', 'A'),
('IL', 'ISRAEL', 'Israel', 'ISR', 376, 0, 0, 'ILS', 'A'),
('IN', 'INDIA', 'India', 'IND', 356, 0, 0, 'INR', 'A'),
('IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', 'io', NULL, 0, 0, 'GBP', 'A'),
('IQ', 'IRAQ', 'Iraq', 'IRQ', 368, 0, 0, '', 'A'),
('IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran', 'IRN', 364, 0, 0, '', 'A'),
('IS', 'ICELAND', 'Iceland', 'ISL', 352, 0, 0, 'ISK', 'A'),
('IT', 'ITALY', 'Italy', 'ITA', 380, 0, 0, '', 'A'),
('JM', 'JAMAICA', 'Jamaica', 'JAM', 388, 0, 0, '', 'A'),
('JO', 'JORDAN', 'Jordan', 'JOR', 400, 0, 0, '', 'A'),
('JP', 'JAPAN', 'Japan', 'JPN', 392, 0, 0, 'JPY', 'A'),
('KE', 'KENYA', 'Kenya', 'KEN', 404, 0, 0, '', 'A'),
('KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'KGZ', 417, 0, 0, '', 'A'),
('KH', 'CAMBODIA', 'Cambodia', 'KHM', 116, 0, 0, 'RIEL', 'A'),
('KI', 'KIRIBATI', 'Kiribati', 'KIR', 296, 0, 0, '', 'A'),
('KM', 'COMOROS', 'Comoros', 'COM', 174, 0, 0, '', 'A'),
('KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts', 'KNA', 659, 0, 0, '', 'A'),
('KP', 'KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF', 'Korea', 'PRK', 408, 0, 0, 'KRW', 'A'),
('KR', 'KOREA, REPUBLIC OF', 'Korea, Republic ', 'KOR', 410, 0, 0, '', 'A'),
('KW', 'KUWAIT', 'Kuwait', 'KWT', 414, 0, 0, 'KWD', 'A'),
('KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'CYM', 136, 0, 0, 'KYD', 'A'),
('KZ', 'KAZAKHSTAN', 'Kazakhstan', 'KAZ', 398, 0, 0, 'KZT', 'A'),
('LA', 'LAO PEOPLE''S DEMOCRATIC REPUBLIC', 'Lao People''s Democratic Republic', 'LAO', 418, 0, 0, '', 'A'),
('LB', 'LEBANON', 'Lebanon', 'LBN', 422, 0, 0, '', 'A'),
('LC', 'SAINT LUCIA', 'Saint Lucia', 'LCA', 662, 0, 0, '', 'A'),
('LI', 'LIECHTENSTEIN', 'Liechtenstein', 'LIE', 438, 0, 0, '', 'A'),
('LK', 'SRI LANKA', 'Sri Lanka', 'LKA', 144, 0, 0, 'LKR', 'A'),
('LR', 'LIBERIA', 'Liberia', 'LBR', 430, 0, 0, '', 'A'),
('LS', 'LESOTHO', 'Lesotho', 'LSO', 426, 0, 0, '', 'A'),
('LT', 'LITHUANIA', 'Lithuania', 'LTU', 440, 0, 0, 'LTL', 'A'),
('LU', 'LUXEMBOURG', 'Luxembourg', 'LUX', 442, 0, 0, '', 'A'),
('LV', 'LATVIA', 'Latvia', 'LVA', 428, 0, 0, '', 'A'),
('LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'LBY', 434, 0, 0, '', 'A'),
('MA', 'MOROCCO', 'Morocco', 'MAR', 504, 0, 0, 'MAD', 'A'),
('MC', 'MONACO', 'monaco', 'MCO', 492, 0, 0, '', 'A'),
('MD', 'MOLDOVA, REPUBLIC OF', 'Moldova', 'MDA', 498, 0, 0, '', 'A'),
('MG', 'MADAGASCAR', 'Madagascar', 'MDG', 450, 0, 0, '', 'A'),
('MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'MHL', 584, 0, 0, '', 'A'),
('MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia', 'MKD', 807, 0, 0, '', 'A'),
('ML', 'MALI', 'Mali', 'MLI', 466, 0, 0, '', 'A'),
('MM', 'MYANMAR', 'Myanmar', 'MMR', 104, 0, 0, '', 'A'),
('MN', 'MONGOLIA', 'Mongolia', 'MNG', 496, 0, 0, '', 'A'),
('MO', 'MACAO', 'Macao', 'MAC', 446, 0, 0, '', 'A'),
('MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'MNP', 580, 0, 0, '', 'A'),
('MQ', 'MARTINIQUE', 'Martinique', 'MTQ', 474, 0, 0, '', 'A'),
('MR', 'MAURITANIA', 'Mauritania', 'MRT', 478, 0, 0, '', 'A'),
('MS', 'MONTSERRAT', 'Montserrat', 'MSR', 500, 0, 0, '', 'A'),
('MT', 'MALTA', 'Malta', 'MLT', 470, 0, 0, '', 'A'),
('MU', 'MAURITIUS', 'Mauritius', 'MUS', 480, 0, 0, 'MUR', 'A'),
('MV', 'MALDIVES', 'Maldives', 'MDV', 462, 0, 0, '', 'A'),
('MW', 'MALAWI', 'Malawi', 'MWI', 454, 0, 0, '', 'A'),
('MX', 'MEXICO', 'Mexico', 'MEX', 484, 0, 0, 'MXN', 'A'),
('MY', 'MALAYSIA', 'Malaysia', 'MYS', 458, 0, 0, 'MYR', 'A'),
('MZ', 'MOZAMBIQUE', 'Mozambique', 'MOZ', 508, 0, 0, '', 'A'),
('NA', 'NAMIBIA', 'Namibia', 'NAM', 516, 0, 0, '', 'A'),
('NC', 'NEW CALEDONIA', 'New Caledonia', 'NCL', 540, 0, 0, '', 'A'),
('NE', 'NIGER', 'Niger', 'NER', 562, 0, 0, '', 'A'),
('NF', 'NORFOLK ISLAND', 'Norfolk Island', 'NFK', 574, 0, 0, '', 'A'),
('NG', 'NIGERIA', 'Nigeria', 'NGA', 566, 0, 0, '', 'A'),
('NI', 'NICARAGUA', 'Nicaragua', 'NIC', 558, 0, 0, '', 'A'),
('NL', 'NETHERLANDS', 'Netherlands', 'NLD', 528, 0, 0, '', 'A'),
('NO', 'NORWAY', 'Norway', 'NOR', 578, 0, 0, 'NOK', 'A'),
('NP', 'NEPAL', 'Nepal', 'NPL', 524, 0, 0, 'NPR', 'A'),
('NR', 'NAURU', 'Nauru', 'NRU', 520, 0, 0, '', 'A'),
('NU', 'NIUE', 'Niue', 'NIU', 570, 0, 0, '', 'A'),
('NZ', 'NEW ZEALAND', 'New Zealand', 'NZL', 554, 0, 0, 'NZD', 'A'),
('OM', 'OMAN', 'Oman', 'OMN', 512, 0, 0, 'OMR', 'A'),
('PA', 'PANAMA', 'Panama', 'PAN', 591, 0, 0, '', 'A'),
('PE', 'PERU', 'Peru', 'PER', 604, 0, 0, 'PEN', 'A'),
('PF', 'FRENCH POLYNESIA', 'French Polynesia', 'PYF', 258, 0, 0, 'PLN', 'A'),
('PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'PNG', 598, 0, 0, '', 'A'),
('PH', 'PHILIPPINES', 'Philippines', 'PHL', 608, 0, 0, 'PHP', 'A'),
('PK', 'PAKISTAN', 'Pakistan', 'PAK', 586, 500, 200, 'PKR', 'A'),
('PL', 'POLAND', 'Poland', 'POL', 616, 0, 0, '', 'A'),
('PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre', 'SPM', 666, 0, 0, '', 'A'),
('PN', 'PITCAIRN', 'Pitcairn', 'PCN', 612, 0, 0, '', 'A'),
('PR', 'PUERTO RICO', 'Puerto Rico', 'PRI', 630, 0, 0, '', 'A'),
('PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian ', NULL, NULL, 0, 0, '', 'A'),
('PT', 'PORTUGAL', 'Portugal', 'PRT', 620, 0, 0, '', 'A'),
('PW', 'PALAU', 'Palau', 'PLW', 585, 0, 0, '', 'A'),
('PY', 'PARAGUAY', 'Paraguay', 'PRY', 600, 0, 0, '', 'A'),
('QA', 'QATAR', 'Qatar', 'QAT', 634, 0, 0, 'QAR', 'A'),
('RE', 'REUNION', 'Reunion', 'REU', 638, 0, 0, '', 'A'),
('RO', 'ROMANIA', 'Romania', 'ROM', 642, 0, 0, 'RON', 'A'),
('RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'RUS', 643, 0, 0, 'RUB', 'A'),
('RW', 'RWANDA', 'Rwanda', 'RWA', 646, 0, 0, '', 'A'),
('SA', 'SAUDI ARABIA', 'Saudi Arabia', 'SAU', 682, 0, 0, 'SAR', 'A'),
('SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'SLB', 90, 0, 0, '', 'A'),
('SC', 'SEYCHELLES', 'Seychelles', 'SYC', 690, 0, 0, '', 'A'),
('SD', 'SUDAN', 'Sudan', 'SDN', 736, 0, 0, '', 'A'),
('SE', 'SWEDEN', 'Sweden', 'SWE', 752, 0, 0, 'SEK', 'A'),
('SG', 'SINGAPORE', 'Singapore', 'SGP', 702, 0, 0, 'SGD', 'A'),
('SH', 'SAINT HELENA', 'Saint Helena', 'SHN', 654, 0, 0, '', 'A'),
('SI', 'SLOVENIA', 'Slovenia', 'SVN', 705, 0, 0, 'SIT', 'A'),
('SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard', 'SJM', 744, 0, 0, '', 'A'),
('SK', 'SLOVAKIA', 'Slovakia', 'SVK', 703, 0, 0, 'SKK', 'A'),
('SL', 'SIERRA LEONE', 'Sierra Leone', 'SLE', 694, 0, 0, '', 'A'),
('SM', 'SAN MARINO', 'San Marino', 'SMR', 674, 0, 0, '', 'A'),
('SN', 'SENEGAL', 'Senegal', 'SEN', 686, 0, 0, '', 'A'),
('SO', 'SOMALIA', 'Somalia', 'SOM', 706, 0, 0, '', 'A'),
('SR', 'SURINAME', 'Suriname', 'SUR', 740, 0, 0, '', 'A'),
('ST', 'SAO TOME AND PRINCIPE', 'Sao Tome ', 'STP', 678, 0, 0, '', 'A'),
('SV', 'EL SALVADOR', 'El Salvador', 'SLV', 222, 0, 0, '', 'A'),
('SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'SYR', 760, 0, 0, '', 'A'),
('SZ', 'SWAZILAND', 'Swaziland', 'SWZ', 748, 0, 0, '', 'A'),
('TC', 'CAICOS ISLANDS', 'Caicos Islands', 'TCA', 796, 0, 0, '', 'A'),
('TD', 'CHAD', 'Chad', 'TCD', 148, 0, 0, '', 'A'),
('TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', NULL, NULL, 0, 0, '', 'A'),
('TG', 'TOGO', 'Togo', 'TGO', 768, 0, 0, '', 'A'),
('TH', 'THAILAND', 'Thailand', 'THA', 764, 0, 0, 'THB', 'A'),
('TJ', 'TAJIKISTAN', 'Tajikistan', 'TJK', 762, 0, 0, '', 'A'),
('TK', 'TOKELAU', 'Tokelau', 'TKL', 772, 0, 0, '', 'A'),
('TL', 'TIMOR-LESTE', 'Timor-Leste', NULL, NULL, 0, 0, '', 'A'),
('TM', 'TURKMENISTAN', 'Turkmenistan', 'TKM', 795, 0, 0, '', 'A'),
('TN', 'TUNISIA', 'Tunisia', 'TUN', 788, 0, 0, '', 'A'),
('TO', 'TONGA', 'Tonga', 'TON', 776, 0, 0, '', 'A'),
('TR', 'TURKEY', 'Turkey', 'TUR', 792, 0, 0, 'TRY', 'A'),
('TT', 'TRINIDAD AND TOBAGO', 'Trinidad', 'TTO', 780, 0, 0, 'TTD', 'A'),
('TV', 'TUVALU', 'Tuvalu', 'TUV', 798, 0, 0, '', 'A'),
('TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan', 'TWN', 158, 0, 0, 'TWD', 'A'),
('TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic', 'TZA', 834, 0, 0, '', 'A'),
('UA', 'UKRAINE', 'Ukraine', 'UKR', 804, 0, 0, 'UAH', 'A'),
('UG', 'UGANDA', 'Uganda', 'UGA', 800, 0, 0, '', 'A'),
('UM', 'UNITED STATES ISLANDS', 'United States Islands', NULL, NULL, 0, 0, '', 'A'),
('US', 'UNITED STATES', 'United States', 'USA', 840, 0, 0, 'USD', 'A'),
('UY', 'URUGUAY', 'Uruguay', 'URY', 858, 0, 0, '', 'A'),
('UZ', 'UZBEKISTAN', 'Uzbekistan', 'UZB', 860, 0, 0, '', 'A'),
('VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'VAT', 336, 0, 0, '', 'A'),
('VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent', 'VCT', 670, 0, 0, '', 'A'),
('VE', 'VENEZUELA', 'Venezuela', 'VEN', 862, 0, 0, 'VEB', 'A'),
('VG', 'VIRGIN ISLANDS', 'Virgin Islands', 'VGB', 92, 0, 0, '', 'A'),
('VN', 'VIET NAM', 'Viet Nam', 'VNM', 704, 0, 0, '', 'A'),
('VU', 'VANUATU', 'Vanuatu', 'VUT', 548, 0, 0, '', 'A'),
('WF', 'WALLIS', 'Wallis', 'WLF', 876, 0, 0, '', 'A'),
('WS', 'SAMOA', 'Samoa', 'WSM', 882, 0, 0, '', 'A'),
('YE', 'YEMEN', 'Yemen', 'YEM', 887, 0, 0, '', 'A'),
('YT', 'MAYOTTE', 'Mayotte', NULL, NULL, 0, 0, '', 'A'),
('ZA', 'SOUTH AFRICA', 'South Africa', 'ZAF', 710, 0, 0, 'ZAR', 'A'),
('ZM', 'ZAMBIA', 'Zambia', 'ZMB', 894, 0, 0, '', 'A'),
('ZW', 'ZIMBABWE', 'Zimbabwe', 'ZWE', 716, 0, 0, '', 'A');

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

--
-- Table structure for table `snf_current_issues`
--

CREATE TABLE IF NOT EXISTS `snf_current_issues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journalID` int(11) NOT NULL,
  `currIssueCat` int(11) NOT NULL,
  `currentIssueTitle` varchar(255) NOT NULL,
  `currentIssueSEOTitle` varchar(255) NOT NULL,
  `currentIssueShortDesc` text NOT NULL,
  `entryDate` datetime NOT NULL,
  `currentIssueStatus` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_current_issues`
--

INSERT INTO `snf_current_issues` (`id`, `journalID`, `currIssueCat`, `currentIssueTitle`, `currentIssueSEOTitle`, `currentIssueShortDesc`, `entryDate`, `currentIssueStatus`) VALUES
(1, 5, 1, 'RNA Transfer from Poliovirus 135S Particles across Membranes Is Mediated by Long Umbilical Connectors', 'rna-transfer-from-poliovirus', '<p>Mike Strauss, Hazel C. Levy, Mihnea Bostina, David J. Filman, and James M.  J. Virol. April 2013 87:3903-3914; published ahead of print 30 January 2013, doi:10.1128/JVI.03209-12</p>', '2013-06-17 09:18:28', 1),
(2, 4, 3, '2013 ESH/ESC Guidelines for the management of arterial hypertension: The Task Force for the management of arterial hypertension of the European Society of Hypertension (ESH) and of the European Society of Cardiology (ESC)', '2013-ESH-ESC-guidelines-for-the-management-of-arterial-hypertension', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean at urna  felis. Morbi at mauris ac dui faucibus mollis rhoncus eu erat. Nam  pretium congue bibendum. Ut turpis odio, vulputate at tincidunt sed,  auctor id nulla. Nunc a commodo ipsum. Fusce pellentesque, justo quis  rhoncus sagittis, enim orci auctor odio, ac pulvinar eros dui ut est.  Nulla a urna facilisis, feugiat diam in, porttitor ante. Nam ut blandit  metus. Pellentesque at ante aliquet</p>', '2013-06-25 06:44:40', 1),
(3, 4, 3, 'Articles with a blue lock are available only to subscribers. For complete access to the magazine', 'articles-with-a-blue-lock-are-available-only-to-subscribers', '<p><em>The New Yorker Reader series</em>:<br />\r\nAnthologies that draw from the magazine&rsquo;s rich archive, on food, digital  technology, baseball, golf, travel, sustainability, and health care.  Subscribers who have already downloaded the app can find the New Yorker  Reader series in their library or the app&rsquo;s store.</p>', '2013-06-29 07:08:24', 1);

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

--
-- Table structure for table `snf_current_issues_categories`
--

CREATE TABLE IF NOT EXISTS `snf_current_issues_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryTitle` varchar(255) NOT NULL,
  `seoTitle` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_current_issues_categories`
--

INSERT INTO `snf_current_issues_categories` (`id`, `categoryTitle`, `seoTitle`, `entryDate`, `status`) VALUES
(1, 'Structure and Assembly', 'structure-and-assembly', '2013-06-16 18:40:34', 1),
(3, 'Immunity', 'immunity', '2013-06-16 18:44:26', 1);

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

--
-- Table structure for table `snf_current_issues_social`
--

CREATE TABLE IF NOT EXISTS `snf_current_issues_social` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currIssueCatID` int(11) NOT NULL,
  `currIssueID` int(11) NOT NULL,
  `CiteULike` varchar(255) NOT NULL,
  `Connotea` varchar(255) NOT NULL,
  `Delicious` varchar(255) NOT NULL,
  `Digg` varchar(255) NOT NULL,
  `Facebook` varchar(255) NOT NULL,
  `Google` varchar(255) NOT NULL,
  `Mendeley` varchar(255) NOT NULL,
  `Reddit` varchar(255) NOT NULL,
  `StumbleUpon` varchar(255) NOT NULL,
  `Twitter` varchar(255) NOT NULL,
  `LinkedIn` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `snf_current_issues_social`
--

INSERT INTO `snf_current_issues_social` (`id`, `currIssueCatID`, `currIssueID`, `CiteULike`, `Connotea`, `Delicious`, `Digg`, `Facebook`, `Google`, `Mendeley`, `Reddit`, `StumbleUpon`, `Twitter`, `LinkedIn`) VALUES
(1, 0, 0, 'http://www.CiteULike.com/', 'http://www.Connotea.com/', 'http://www.Delicious.com/', 'http://www.Digg.com/', 'http://www.Facebook.com/', 'http://www.Google.com/', 'http://www.Mendeley.com/', 'http://www.Reddit.com/', 'http://www.StumbleUpon.com/', 'http://www.Twitter.com/', 'http://www.LinkedIn.com/');

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

--
-- Table structure for table `snf_current_issue_details`
--

CREATE TABLE IF NOT EXISTS `snf_current_issue_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journalID` int(11) NOT NULL,
  `currIssueCatID` int(11) NOT NULL,
  `currIssueID` int(11) NOT NULL,
  `title1` text NOT NULL,
  `currentIssueTitle` text NOT NULL,
  `currentIssueSeoTitle` text NOT NULL,
  `currentIssueAuthors` text NOT NULL,
  `currentIssueAuthorAff` text NOT NULL,
  `currentIssuePDF` varchar(255) NOT NULL,
  `currentIssueHTML` varchar(255) NOT NULL,
  `currentIssueEPUB` varchar(255) NOT NULL,
  `currentIssueEdigital` varchar(255) NOT NULL,
  `currentIssueExpRef` varchar(255) NOT NULL,
  `currentIssueServices` varchar(255) NOT NULL,
  `currentIssueAbstract` longtext NOT NULL,
  `currentIssueIntroduction` longtext NOT NULL,
  `currentIssueMatMet` longtext NOT NULL,
  `currentIssueResults` longtext NOT NULL,
  `currentIssueDiscussion` longtext NOT NULL,
  `currentIssueAckno` longtext NOT NULL,
  `currentIssueFootNotes` longtext NOT NULL,
  `currentIssueRef` longtext NOT NULL,
  `entryDate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_current_issue_details`
--

INSERT INTO `snf_current_issue_details` (`id`, `journalID`, `currIssueCatID`, `currIssueID`, `title1`, `currentIssueTitle`, `currentIssueSeoTitle`, `currentIssueAuthors`, `currentIssueAuthorAff`, `currentIssuePDF`, `currentIssueHTML`, `currentIssueEPUB`, `currentIssueEdigital`, `currentIssueExpRef`, `currentIssueServices`, `currentIssueAbstract`, `currentIssueIntroduction`, `currentIssueMatMet`, `currentIssueResults`, `currentIssueDiscussion`, `currentIssueAckno`, `currentIssueFootNotes`, `currentIssueRef`, `entryDate`) VALUES
(1, 5, 1, 1, 'J. Virol. February 2012 vol. 86 no. 3 pages 1297-1306 http://dx.doi.org/10.1155/2013/878237', 'In Vitro Assembly of Virus-Like Particles of a Gammaretrovirus, the Murine Leukemia Virus XMRV', 'in-vitro-assembly-of-virus-like-particles-of-a-gammaretrovirus', 'Romana Hadravovaa, Alex de Marcob, Pavel Ulbrichc, Jitka Stokrovaa, Michal Dolezal Iva Pichovaa, Tomas Rumlc, John A. G. Briggsb', 'aInstitute of Organic Chemistry and Biochemistry, Academy of Sciences of the Czech\r\nRepublic, v.v.i., IOCB and Gilead Research Center, Prague, Czech Republic, \r\nbStructural and Computational Unit, European Molecular Biology Laboratory,\r\nHeidelberg, Germany, cDepartment of Biochemistry and Microbiology, Institute of\r\nChemical Technology, Prague, Czech Republic.', '1371480503SE_08_w3.pdf', '1371481452Ethical Issues in E-voting_Updated.doc', '1371480503DACS By Adnan Khan.ppt', '1371480503Models 2(1).docx', '', '1371480503Ethical Issues in E-voting_Updated.doc', '<p><em>Immature retroviral particles are assembled by self-association of the structural  polyprotein precursor Gag. During maturation the Gag polyprotein is proteolytically  cleaved, yielding mature structural proteins, matrix (MA), capsid (CA), and nucleocapsid (NC), that reassemble into a mature viral particle. Proteolytic cleavage causes the N terminus of CA to fold back to form a &beta;-hairpin, anchored by an internal salt bridge between the N-terminal proline and the inner aspartate. Using an in vitro assembly system of capsid-nucleocapsid protein (CANC), we studied the formation of virus-like particles (VLP) of a gammaretrovirus, the xenotropic murine leukemia virus (MLV) related virus (XMRV). We show here that, unlike other retroviruses, XMRV CA and CANC do not assemble tubular particles characteristic of mature assembly. The prevention of &beta;-hairpin formation by the deletion of either the N-terminal proline or 10 initial amino acids enabled the assembly of &#8710;ProCANC or &#8710;10CANC into immature-like spherical particles. Detailed three-dimensional (3D) structural analysis of these particles revealed that below a disordered N-terminal CA layer, the C terminus of CA assembles a typical immature lattice, which is linked by rod-like densities with the RNP.</em></p>', '<p>Gag itself is sufficient for immature-particle assembly. The interactions critical for immature-particle assembly are mediated by CA-CA and NC-RNA interfaces. CA consists of two subdomains, the CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected by a short sequence. Despite a low level of sequence homology, all available retroviral CA-NTD structures show conserved structural motifs consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin anchored by a salt bridge between the N-terminal proline and an aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different phases: immature- and mature-particle formation. Initially, the virus is formed in immature form by self-association of the major structural polyprotein Gag into spherical particles either at the plasma membrane (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a distinct site within the infected cell (betaretroviruses). The particles are organized by lattices of Gag and Gag-derived polyproteins that associate with the plasma membrane that becomes the outer layer of the immature particle released during budding. Upon release from the host cell, the Gag precursor is proteolytically processed into N-terminal membrane binding matrix protein (MA), two-domain capsid protein (CA), and RNA-binding nucleocapsid protein (NC). This cleavage leads to a dramatic morphological change and reorganization of the virus particle from its immature form into a mature, infectious virion.</p>', '<p><strong>Cloning. </strong>All expression vectors were prepared by standard cloning techniques, propagated in Escherichia coli DH5&alpha;, and verified by sequencing.</p>\r\n<p><strong>Bacterial expression. </strong>Luria-Bertani medium containing ampicillin (100 &micro;g/ml) was inoculated with E. coli BL21(DE3) cells carrying the appropriate construct.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious  retroviruses comprises two different phases: immature- and  mature-particle formation. Initially, the virus is formed in immature  form by self-association of the major structural polyprotein Gag into  spherical particles either at the plasma membrane (alpharetroviruses,  gammaretroviruses, or lentiviruses) or at a distinct site within the  infected cell (betaretroviruses). The particles are organized by  lattices of Gag and Gag-derived polyproteins that associate with the  plasma membrane that becomes the outer layer of the immature particle  released during budding. Upon release from the host cell, the Gag  precursor is proteolytically processed into N-terminal membrane binding  matrix protein (MA), two-domain capsid protein (CA), and RNA-binding  nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious  retroviruses comprises two different phases: immature- and  mature-particle formation. Initially, the virus is formed in immature  form by self-association of the major structural polyprotein Gag into  spherical particles either at the plasma membrane (alpharetroviruses,  gammaretroviruses, or lentiviruses) or at a distinct site within the  infected cell (betaretroviruses). The particles are organized by  lattices of Gag and Gag-derived polyproteins that associate with the  plasma membrane that becomes the outer layer of the immature particle  released during budding. Upon release from the host cell, the Gag  precursor is proteolytically processed into N-terminal membrane binding  matrix protein (MA), two-domain capsid protein (CA), and RNA-binding  nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious  retroviruses comprises two different phases: immature- and  mature-particle formation. Initially, the virus is formed in immature  form by self-association of the major structural polyprotein Gag into  spherical particles either at the plasma membrane (alpharetroviruses,  gammaretroviruses, or lentiviruses) or at a distinct site within the  infected cell (betaretroviruses). The particles are organized by  lattices of Gag and Gag-derived polyproteins that associate with the  plasma membrane that becomes the outer layer of the immature particle  released during budding. Upon release from the host cell, the Gag  precursor is proteolytically processed into N-terminal membrane binding  matrix protein (MA), two-domain capsid protein (CA), and RNA-binding  nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious  retroviruses comprises two different phases: immature- and  mature-particle formation. Initially, the virus is formed in immature  form by self-association of the major structural polyprotein Gag into  spherical particles either at the plasma membrane (alpharetroviruses,  gammaretroviruses, or lentiviruses) or at a distinct site within the  infected cell (betaretroviruses). The particles are organized by  lattices of Gag and Gag-derived polyproteins that associate with the  plasma membrane that becomes the outer layer of the immature particle  released during budding. Upon release from the host cell, the Gag  precursor is proteolytically processed into N-terminal membrane binding  matrix protein (MA), two-domain capsid protein (CA), and RNA-binding  nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious  retroviruses comprises two different phases: immature- and  mature-particle formation. Initially, the virus is formed in immature  form by self-association of the major structural polyprotein Gag into  spherical particles either at the plasma membrane (alpharetroviruses,  gammaretroviruses, or lentiviruses) or at a distinct site within the  infected cell (betaretroviruses). The particles are organized by  lattices of Gag and Gag-derived polyproteins that associate with the  plasma membrane that becomes the outer layer of the immature particle  released during budding. Upon release from the host cell, the Gag  precursor is proteolytically processed into N-terminal membrane binding  matrix protein (MA), two-domain capsid protein (CA), and RNA-binding  nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '2013-06-17 14:48:23'),
(2, 4, 3, 2, 'Mechanisms of Action', 'Male and Female Plasmodium falciparum Mature Gametocytes Show Different Responses to Antimalarial Drugs ', 'male-and-female-plasmodium-falciparum-mature-gametocy', '<p>Romana Hadravovaa, Alex de Marcob, Pavel Ulbrichc, Jitka Stokrovaa, Michal Dolezal Iva Pichovaa, Tomas Rumlc, John A. G. Briggsb</p>', '<p>aInstitute of Organic Chemistry and Biochemistry, Academy of Sciences of the Czech Republic, v.v.i., IOCB and Gilead Research Center, Prague, Czech Republic,  bStructural and Computational Unit, European Molecular Biology Laboratory, Heidelberg, Germany, cDepartment of Biochemistry and Microbiology, Institute of Chemical Technology, Prague, Czech Republic.</p>', '1372144138Functional versus Non-functional.pdf', '', '1372144138FoRE-chapter01-v7.pdf', '', '', '', '<p><em>Immature retroviral particles are assembled by self-association  of the structural  polyprotein precursor Gag. During maturation the Gag  polyprotein is proteolytically  cleaved, yielding mature structural  proteins, matrix (MA), capsid (CA), and nucleocapsid (NC), that  reassemble into a mature viral particle. Proteolytic cleavage causes the  N terminus of CA to fold back to form a &beta;-hairpin, anchored by an  internal salt bridge between the N-terminal proline and the inner  aspartate. Using an in vitro assembly system of capsid-nucleocapsid  protein (CANC), we studied the formation of virus-like particles (VLP)  of a gammaretrovirus, the xenotropic murine leukemia virus (MLV) related  virus (XMRV). We show here that, unlike other retroviruses, XMRV CA and  CANC do not assemble tubular particles characteristic of mature  assembly. The prevention of &beta;-hairpin formation by the deletion of  either the N-terminal proline or 10 initial amino acids enabled the  assembly of &#8710;ProCANC or &#8710;10CANC into immature-like spherical particles.  Detailed three-dimensional (3D) structural analysis of these particles  revealed that below a disordered N-terminal CA layer, the C terminus of  CA assembles a typical immature lattice, which is linked by rod-like  densities with the RNP.</em></p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different  phases: immature- and mature-particle formation. Initially, the virus  is formed in immature form by self-association of the major structural  polyprotein Gag into spherical particles either at the plasma membrane  (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a distinct  site within the infected cell (betaretroviruses). The particles are  organized by lattices of Gag and Gag-derived polyproteins that associate  with the plasma membrane that becomes the outer layer of the immature  particle released during budding. Upon release from the host cell, the  Gag precursor is proteolytically processed into N-terminal membrane  binding matrix protein (MA), two-domain capsid protein (CA), and  RNA-binding nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different  phases: immature- and mature-particle formation. Initially, the virus  is formed in immature form by self-association of the major structural  polyprotein Gag into spherical particles either at the plasma membrane  (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a distinct  site within the infected cell (betaretroviruses). The particles are  organized by lattices of Gag and Gag-derived polyproteins that associate  with the plasma membrane that becomes the outer layer of the immature  particle released during budding. Upon release from the host cell, the  Gag precursor is proteolytically processed into N-terminal membrane  binding matrix protein (MA), two-domain capsid protein (CA), and  RNA-binding nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p><img width="180" height="135" align="left" alt="" src="/userfiles/image/Asif%20Khan.jpg" style="MARGIN-RIGHT: 10px" /></p>\r\n<h3>Type the title here</h3>\r\n<p>Gag itself is sufficient for immature-particle assembly. The   interactions critical for immature-particle assembly are mediated by   CA-CA and NC-RNA interfaces. CA consists of two subdomains, the   CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected   by a short sequence. Despite a low level of sequence homology, all   available retroviral CA-NTD structures show conserved structural motifs   consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin   anchored by a salt bridge between the N-terminal proline and an   aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different   phases: immature- and mature-particle formation. Initially, the virus   is formed in immature form by self-association of the major structural   polyprotein Gag into spherical particles either at the plasma membrane   (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a  distinct  site within the infected cell (betaretroviruses). The  particles are  organized by lattices of Gag and Gag-derived polyproteins  that associate  with the plasma membrane that becomes the outer layer  of the immature  particle released during budding. Upon release from the  host cell, the  Gag precursor is proteolytically processed into  N-terminal membrane  binding matrix protein (MA), two-domain capsid  protein (CA), and  RNA-binding nucleocapsid protein (NC). This cleavage  leads to a dramatic  morphological change and reorganization of the  virus particle from its  immature form into a mature, infectious virion.</p>\r\n<h3>Type the title here</h3>\r\n<p><img width="180" height="135" align="left" alt="" src="/userfiles/image/Asif%20Khan.jpg" style="MARGIN-RIGHT: 10px" /></p>\r\n<p>Gag itself is sufficient for immature-particle assembly. The    interactions critical for immature-particle assembly are mediated by    CA-CA and NC-RNA interfaces. CA consists of two subdomains, the    CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected    by a short sequence. Despite a low level of sequence homology, all    available retroviral CA-NTD structures show conserved structural motifs    consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin    anchored by a salt bridge between the N-terminal proline and an    aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different    phases: immature- and mature-particle formation. Initially, the virus    is formed in immature form by self-association of the major  structural   polyprotein Gag into spherical particles either at the  plasma membrane   (alpharetroviruses, gammaretroviruses, or  lentiviruses) or at a  distinct  site within the infected cell  (betaretroviruses). The  particles are  organized by lattices of Gag and  Gag-derived polyproteins  that associate  with the plasma membrane that  becomes the outer layer  of the immature  particle released during  budding. Upon release from the  host cell, the  Gag precursor is  proteolytically processed into  N-terminal membrane  binding matrix  protein (MA), two-domain capsid  protein (CA), and  RNA-binding  nucleocapsid protein (NC). This cleavage  leads to a dramatic   morphological change and reorganization of the  virus particle from its   immature form into a mature, infectious virion.</p>\r\n<p>&nbsp;</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different  phases: immature- and mature-particle formation. Initially, the virus  is formed in immature form by self-association of the major structural  polyprotein Gag into spherical particles either at the plasma membrane  (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a distinct  site within the infected cell (betaretroviruses). The particles are  organized by lattices of Gag and Gag-derived polyproteins that associate  with the plasma membrane that becomes the outer layer of the immature  particle released during budding. Upon release from the host cell, the  Gag precursor is proteolytically processed into N-terminal membrane  binding matrix protein (MA), two-domain capsid protein (CA), and  RNA-binding nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different  phases: immature- and mature-particle formation. Initially, the virus  is formed in immature form by self-association of the major structural  polyprotein Gag into spherical particles either at the plasma membrane  (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a distinct  site within the infected cell (betaretroviruses). The particles are  organized by lattices of Gag and Gag-derived polyproteins that associate  with the plasma membrane that becomes the outer layer of the immature  particle released during budding. Upon release from the host cell, the  Gag precursor is proteolytically processed into N-terminal membrane  binding matrix protein (MA), two-domain capsid protein (CA), and  RNA-binding nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different  phases: immature- and mature-particle formation. Initially, the virus  is formed in immature form by self-association of the major structural  polyprotein Gag into spherical particles either at the plasma membrane  (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a distinct  site within the infected cell (betaretroviruses). The particles are  organized by lattices of Gag and Gag-derived polyproteins that associate  with the plasma membrane that becomes the outer layer of the immature  particle released during budding. Upon release from the host cell, the  Gag precursor is proteolytically processed into N-terminal membrane  binding matrix protein (MA), two-domain capsid protein (CA), and  RNA-binding nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '<p>Gag itself is sufficient for immature-particle assembly. The  interactions critical for immature-particle assembly are mediated by  CA-CA and NC-RNA interfaces. CA consists of two subdomains, the  CA&ndash;N-terminal domain (NTD) and the CA&ndash;C-terminal domain (CTD), connected  by a short sequence. Despite a low level of sequence homology, all  available retroviral CA-NTD structures show conserved structural motifs  consisting of six or seven &alpha;-helices and an N-terminal &beta;-hairpin  anchored by a salt bridge between the N-terminal proline and an  aspartate in helix 3.</p>\r\n<p>The assembly of fully infectious retroviruses comprises two different  phases: immature- and mature-particle formation. Initially, the virus  is formed in immature form by self-association of the major structural  polyprotein Gag into spherical particles either at the plasma membrane  (alpharetroviruses, gammaretroviruses, or lentiviruses) or at a distinct  site within the infected cell (betaretroviruses). The particles are  organized by lattices of Gag and Gag-derived polyproteins that associate  with the plasma membrane that becomes the outer layer of the immature  particle released during budding. Upon release from the host cell, the  Gag precursor is proteolytically processed into N-terminal membrane  binding matrix protein (MA), two-domain capsid protein (CA), and  RNA-binding nucleocapsid protein (NC). This cleavage leads to a dramatic  morphological change and reorganization of the virus particle from its  immature form into a mature, infectious virion.</p>', '2013-06-25 07:08:58'),
(3, 4, 3, 3, 'Articles with a blue lock', 'Articles with a blue lock are available only to subscribers. For complete access to the magazine', 'articles-with-a-blue-lock-are-available-only-to-subscribers', 'Romana Hadravovaa, Alex de Marcob, Pavel Ulbrichc, Jitka Stokrovaa, Michal Dolezal Iva Pichovaa, Tomas Rumlc, John A. G. Briggsb', 'aInstitute of Organic Chemistry and Biochemistry, Academy of Sciences of the Czech\r\nRepublic, v.v.i., IOCB and Gilead Research Center, Prague, Czech Republic, \r\nbStructural and Computational Unit, European Molecular Biology Laboratory,\r\nHeidelberg, Germany, cDepartment of Biochemistry and Microbiology, Institute of\r\nChemical Technology, Prague, Czech Republic.', '1372490210gatsp(1).pdf', '', '1372490210gatsp.pdf', '', '', '', '<p><em>Following a period of economic boom, a financial bubble &mdash; global in  scope &mdash; burst, even causing some of the world&rsquo;s largest financial  institutions have collapsed. With the resulting recession, many  governments of the wealthiest nations in the world have resorted to  extensive bail-out and rescue packages for the remaining large banks and  financial institutions while imposing harsh austerity measures on  themselves.</em></p>', '<p>Some of the bail-outs have also led to charges of hypocrisy due to the apparent <q>socializing of the costs while privatizing the profits.</q>  Furthermore, the institutions being rescued are typically the ones got  the world into this trouble in the first place. For smaller businesses  and poorer people, such options for bail out and rescue are rarely  available when they find themselves in crisis.</p>\r\n<p>Plummeting stock  markets at one point wiped out 33% of the value of companies, $14.5  trillion. Taxpayers bailed out their banks and financial institutions  with large amounts of money. US taxpayers alone have spent some $9.7  trillion in bailout packages and plans. The UK and other European  countries have also spent some $2 trillion on rescues and bailout  packages. More is expected. Much more.</p>', '<p>Some of the bail-outs have also led to charges of hypocrisy due to the apparent <q>socializing of the costs while privatizing the profits.</q>  Furthermore, the institutions being rescued are typically the ones got  the world into this trouble in the first place. For smaller businesses  and poorer people, such options for bail out and rescue are rarely  available when they find themselves in crisis.</p>\r\n<p>Plummeting stock  markets at one point wiped out 33% of the value of companies, $14.5  trillion. Taxpayers bailed out their banks and financial institutions  with large amounts of money. US taxpayers alone have spent some $9.7  trillion in bailout packages and plans. The UK and other European  countries have also spent some $2 trillion on rescues and bailout  packages. More is expected. Much more.</p>', '<p>Some of the bail-outs have also led to charges of hypocrisy due to the apparent <q>socializing of the costs while privatizing the profits.</q>  Furthermore, the institutions being rescued are typically the ones got  the world into this trouble in the first place. For smaller businesses  and poorer people, such options for bail out and rescue are rarely  available when they find themselves in crisis.</p>\r\n<p>Plummeting stock  markets at one point wiped out 33% of the value of companies, $14.5  trillion. Taxpayers bailed out their banks and financial institutions  with large amounts of money. US taxpayers alone have spent some $9.7  trillion in bailout packages and plans. The UK and other European  countries have also spent some $2 trillion on rescues and bailout  packages. More is expected. Much more.</p>', '<p>Some of the bail-outs have also led to charges of hypocrisy due to the apparent <q>socializing of the costs while privatizing the profits.</q>  Furthermore, the institutions being rescued are typically the ones got  the world into this trouble in the first place. For smaller businesses  and poorer people, such options for bail out and rescue are rarely  available when they find themselves in crisis.</p>\r\n<p>Plummeting stock  markets at one point wiped out 33% of the value of companies, $14.5  trillion. Taxpayers bailed out their banks and financial institutions  with large amounts of money. US taxpayers alone have spent some $9.7  trillion in bailout packages and plans. The UK and other European  countries have also spent some $2 trillion on rescues and bailout  packages. More is expected. Much more.</p>', '<p>Some of the bail-outs have also led to charges of hypocrisy due to the apparent <q>socializing of the costs while privatizing the profits.</q>  Furthermore, the institutions being rescued are typically the ones got  the world into this trouble in the first place. For smaller businesses  and poorer people, such options for bail out and rescue are rarely  available when they find themselves in crisis.</p>\r\n<p>Plummeting stock  markets at one point wiped out 33% of the value of companies, $14.5  trillion. Taxpayers bailed out their banks and financial institutions  with large amounts of money. US taxpayers alone have spent some $9.7  trillion in bailout packages and plans. The UK and other European  countries have also spent some $2 trillion on rescues and bailout  packages. More is expected. Much more.</p>', '<p>Some of the bail-outs have also led to charges of hypocrisy due to the apparent <q>socializing of the costs while privatizing the profits.</q>  Furthermore, the institutions being rescued are typically the ones got  the world into this trouble in the first place. For smaller businesses  and poorer people, such options for bail out and rescue are rarely  available when they find themselves in crisis.</p>\r\n<p>Plummeting stock  markets at one point wiped out 33% of the value of companies, $14.5  trillion. Taxpayers bailed out their banks and financial institutions  with large amounts of money. US taxpayers alone have spent some $9.7  trillion in bailout packages and plans. The UK and other European  countries have also spent some $2 trillion on rescues and bailout  packages. More is expected. Much more.</p>', '<p>Some of the bail-outs have also led to charges of hypocrisy due to the apparent <q>socializing of the costs while privatizing the profits.</q>  Furthermore, the institutions being rescued are typically the ones got  the world into this trouble in the first place. For smaller businesses  and poorer people, such options for bail out and rescue are rarely  available when they find themselves in crisis.</p>\r\n<p>Plummeting stock  markets at one point wiped out 33% of the value of companies, $14.5  trillion. Taxpayers bailed out their banks and financial institutions  with large amounts of money. US taxpayers alone have spent some $9.7  trillion in bailout packages and plans. The UK and other European  countries have also spent some $2 trillion on rescues and bailout  packages. More is expected. Much more.</p>', '2013-06-29 07:16:50');

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

--
-- Table structure for table `snf_emails`
--

CREATE TABLE IF NOT EXISTS `snf_emails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_emails`
--

INSERT INTO `snf_emails` (`id`, `email`) VALUES
(3, 'drmunir.muhammad@gmail.com');

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

--
-- Table structure for table `snf_email_conf`
--

CREATE TABLE IF NOT EXISTS `snf_email_conf` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(500) NOT NULL,
  `email_body` text NOT NULL,
  `email_type` varchar(50) NOT NULL,
  `entry_by` int(11) NOT NULL,
  `entry_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_p2p_email_conf_fk_1` (`entry_by`),
  KEY `tbl_p2p_email_conf_fk_2` (`modified_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `snf_email_conf`
--

INSERT INTO `snf_email_conf` (`id`, `subject`, `email_body`, `email_type`, `entry_by`, `entry_date`, `modified_date`, `modified_by`) VALUES
(3, 'New Account', '<p><span style="font-family: Tahoma; font-size: small; ">Dear %displayname%!&nbsp;</span><br style="font-family: Tahoma; font-size: small; " />\r\n<br style="font-family: Tahoma; font-size: small; " />\r\n<span style="font-family: Tahoma; font-size: small; ">You have successfully created your profile. You are registered with %email% email address. Please click below URL to activate your profile at </span>Royal Airport Services<span style="font-family: Tahoma; font-size: small; ">.&nbsp;</span></p>\r\n<p><br style="font-family: Tahoma; font-size: small; " />\r\n<b style="font-family: Tahoma; font-size: small; ">Activation URL:</b><span style="font-family: Tahoma; font-size: small; ">&nbsp;(if you are unable to click on below URL then copy and paste into your browser)</span><br style="font-family: Tahoma; font-size: small; " />\r\n<span style="font-family: Tahoma; font-size: small; ">%activationlink%&nbsp;</span><br style="font-family: Tahoma; font-size: small; " />\r\n<br style="font-family: Tahoma; font-size: small; " />\r\n<b style="font-family: Tahoma; font-size: small; ">Confirmation Code:</b><span style="font-family: Tahoma; font-size: small; ">&nbsp;%confirmationcode%&nbsp;</span></p>\r\n<p><b style="font-family: Tahoma; font-size: small; ">Your Password:</b><span style="font-family: Tahoma; font-size: small; ">&nbsp;%password%&nbsp;</span></p>\r\n<p><br style="font-family: Tahoma; font-size: small; " />\r\n<span style="font-family: Tahoma; font-size: small; ">Thanks,</span><br style="font-family: Tahoma; font-size: small; " />\r\n<br style="font-family: Tahoma; font-size: small; " />\r\n<span style="font-family: Tahoma; font-size: small; ">The Royal Airport Service!</span></p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>', 'new_account', 1, '2012-09-04 18:30:28', '2012-09-20 09:24:15', 1),
(4, 'Account Status Has been changed', '<p><strong>&nbsp;<span style="font-family: Tahoma; font-size: small; ">Dear %displayname%!&nbsp;</span></strong></p>\r\n<div>Your account status has now been changed your new current status is %newstatus%.</div>\r\n<div>&nbsp;</div>\r\n<div>&nbsp;</div>\r\n<div>Thanks</div>\r\n<div>&nbsp;</div>\r\n<div>Green İslands Finance of America Ltd.</div>\r\n<p style="text-align: center; ">&nbsp;Green Islands Finance of America Ltd adheres to standard Lending Codes. Lending Codes set minimum standards of good practice when dealing with certain customers in relation to loans, and Credit Cards.</p>\r\n<div style="text-align: center; ">Green Islands Finance of America Ltd. Reg Office 145-157,St John Street, London, England EC1V 4PW. Company Registration. 8163829.&nbsp;</div>\r\n<p>&nbsp;</p>', 'change_status', 1, '2012-09-04 11:56:54', '2012-09-13 11:02:50', 1),
(5, 'Installment Received', '<p><strong>Dear&nbsp;<span style="font-family: Tahoma; font-size: small; ">&nbsp;</span><span style="font-family: Tahoma; font-size: small; ">%displayname%!&nbsp;</span></strong></p>\r\n<div>Your Installment amount of %amount% has been received your account balance will be updated and you will recieve conformation.</div>\r\n<div>&nbsp;</div>\r\n<div>&nbsp;</div>\r\n<div>Thanks,</div>\r\n<div>&nbsp;</div>\r\n<div>Green İslands Finance of America Ltd</div>\r\n<p style="text-align: center; ">Green Islands Finance of America Ltd adheres to standard Lending Codes. Lending Codes set minimum standards of good practice when dealing with certain customers in relation to loans, and Credit Cards.</p>\r\n<div style="text-align: center; ">Green Islands Finance of America Ltd. Reg Office. 145-157,St John Street, London, England EC1V 4PW. Company Reg 8163829.</div>', 'instalment', 1, '2012-09-04 12:57:31', '2012-09-13 11:04:11', 1);

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

--
-- Table structure for table `snf_events_deadlines`
--

CREATE TABLE IF NOT EXISTS `snf_events_deadlines` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `page_date` date NOT NULL,
  `page_title` varchar(255) DEFAULT NULL,
  `page_heading` varchar(250) NOT NULL,
  `page_link` varchar(255) NOT NULL,
  `page_seo` varchar(255) NOT NULL,
  `page_subheading` varchar(250) NOT NULL,
  `meta_keyword` longtext,
  `meta_phrase` longtext,
  `meta_description` longtext,
  `page_type` varchar(50) DEFAULT NULL,
  `entry_by` int(11) NOT NULL,
  `entry_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `type` varchar(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_p2p_pagecontent_fk_1` (`entry_by`),
  KEY `tbl_p2p_pagecontent_fk_2` (`modified_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `snf_events_deadlines`
--

INSERT INTO `snf_events_deadlines` (`id`, `page_date`, `page_title`, `page_heading`, `page_link`, `page_seo`, `page_subheading`, `meta_keyword`, `meta_phrase`, `meta_description`, `page_type`, `entry_by`, `entry_date`, `modified_date`, `modified_by`, `link_id`, `type`) VALUES
(2, '2013-10-10', 'AAI Advanced Course in Immunology', 'AAI Advanced Course in Immunology', 'http://www.asm.org/index.php/meeting-and-event-calendar', 'aai-advanced-course-in-immunology', '', 'AAI Advanced Course in Immunology', 'AAI Advanced Course in Immunology', '<p>Course Director: Leslie J. Berg, Ph.D; University of Massachusetts Medical School&nbsp;</p>\r\n<p>This intensive course is directed toward advanced trainees and  scientists who wish to expand or update their understanding of the  field. Leading experts will present recent advances in the biology of  the immune system and address its role in health and disease. This is  not an introductory course; attendees will need to have a firm  understanding of the principles of immunology.</p>\r\n<p>Those seeking a basic course are referred to the AAI Introductory Course in Immunology.</p>\r\n<p>Financial support for underrepresented minority scientists is available through the FASEB MARC Program.</p>\r\n<p>Financial support for international trainees is available from IUIS.</p>\r\n<p>Support in part for this AAI course has been generously provided by the Society for Glycobiology.</p>\r\n<p>The AAI Advanced Course in Immunology is sponsored by The American  Association of Immunologists, the largest and most prestigious  association in the world for professional scientists engaged in basic  and clinical immunological research.</p>', '', 1, '2013-07-27 13:48:43', '2013-07-27 13:48:43', 1, 0, '');

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

--
-- Table structure for table `snf_exp_ref`
--

CREATE TABLE IF NOT EXISTS `snf_exp_ref` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journalID` int(11) NOT NULL,
  `currIssueCatID` int(11) NOT NULL,
  `currIssueID` int(11) NOT NULL,
  `EndNote` varchar(255) NOT NULL,
  `ReferenceManager` varchar(255) NOT NULL,
  `SimpleTextFile` varchar(255) NOT NULL,
  `BibTex` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `snf_exp_ref`
--

INSERT INTO `snf_exp_ref` (`id`, `journalID`, `currIssueCatID`, `currIssueID`, `EndNote`, `ReferenceManager`, `SimpleTextFile`, `BibTex`, `entryDate`, `status`) VALUES
(1, 4, 3, 3, '', '', '', '', '2013-08-01 22:39:49', 1);

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

--
-- Table structure for table `snf_faqs`
--

CREATE TABLE IF NOT EXISTS `snf_faqs` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `entry_by` date NOT NULL,
  `modified_date` date NOT NULL,
  `modified_by` date NOT NULL,
  `entry_date` date NOT NULL,
  `status` char(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `snf_faqs`
--

INSERT INTO `snf_faqs` (`id`, `title`, `description`, `entry_by`, `modified_date`, `modified_by`, `entry_date`, `status`) VALUES
(9, 'The standard Lorem Ipsum passage, used since the 1500s', '"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(10, 'Section 1.10.32 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC', '"Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?"', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(11, '1914 translation by H. Rackham', '"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?"', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(12, 'Section 1.10.33 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC', '"At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat."', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(13, '1914 translation by H. Rackham', '"On the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain. These cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammelled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains."', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A');

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

--
-- Table structure for table `snf_google_analytic`
--

CREATE TABLE IF NOT EXISTS `snf_google_analytic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `analytic_code` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `snf_google_analytic`
--

INSERT INTO `snf_google_analytic` (`id`, `analytic_code`) VALUES
(1, '');

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

--
-- Table structure for table `snf_journals`
--

CREATE TABLE IF NOT EXISTS `snf_journals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `seo` varchar(255) NOT NULL,
  `shortDescription` text NOT NULL,
  `spotLightDesc` longtext NOT NULL,
  `description` longtext NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  `leftimage` varchar(100) NOT NULL,
  `detailimage` varchar(100) NOT NULL,
  `bannerImage` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `snf_journals`
--

INSERT INTO `snf_journals` (`id`, `name`, `seo`, `shortDescription`, `spotLightDesc`, `description`, `status`, `leftimage`, `detailimage`, `bannerImage`) VALUES
(1, 'Research in Veterinary and Animal Sciences', 'research-in-veterinary-and-animal-sciences', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged', '', '<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and  typesetting industry. Lorem Ipsum has been the industry''s standard dummy  text ever since the 1500s, when an unknown printer took a galley of  type and scrambled it to make a type specimen book. It has survived not  only five centuries, but also the leap into electronic typesetting,  remaining essentially unchanged</p>', 'A', '20130508221838.gif', '20130508221838.gif', ''),
(2, 'Reviews in Veterinary Virology', 'reviews-in-veterinary-virology', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ''Content here, content here'', making it look like readable English', '', '<p>It is a long established fact that a reader will be distracted by the  readable content of a page when looking at its layout. The point of  using Lorem Ipsum is that it has a more-or-less normal distribution of  letters, as opposed to using ''Content here, content here'', making it  look like readable English</p>', 'A', '20130508221539.jpg', '20130508221539.jpg', ''),
(3, 'Pathogens & Infections', 'pathogens-and-infections', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged', '', '<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and  typesetting industry. Lorem Ipsum has been the industry''s standard dummy  text ever since the 1500s, when an unknown printer took a galley of  type and scrambled it to make a type specimen book. It has survived not  only five centuries, but also the leap into electronic typesetting,  remaining essentially unchanged</p>', 'A', '20130508220840.jpg', '20130508220840.jpg', ''),
(4, 'Applied Bioinformatics in Animal Health Microbiology', 'applied-bioinformatics-in-animal-health-microbiology', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ''Content here, content here'', making it look like readable English', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English</p>', '<p>It is a long established fact that a reader will be distracted by the  readable content of a page when looking at its layout. The point of  using Lorem Ipsum is that it has a more-or-less normal distribution of  letters, as opposed to using ''Content here, content here'', making it  look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the     readable content of a page when looking at its layout. The point of     using Lorem Ipsum is that it has a more-or-less normal distribution of     letters, as opposed to using ''Content here, content here'', making it     look like readable English It is a long established fact that a reader   will be distracted by the   readable content of a page when looking at   its layout. The point of   using Lorem Ipsum is that it has a   more-or-less normal distribution of   letters, as opposed to using   ''Content here, content here'', making it   look like readable English.</p>', 'A', '20130508230929.gif', '20130508232330.gif', '20130708193911.png'),
(5, 'Journal of Veterinary Molecular Diagnostics', 'journal-of-veterinary-molecular-diagnostics', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ''Content here, content here'', making it look like readable English', '', '<p>It is a long established fact that a reader will be distracted by the  readable content of a page when looking at its layout. The point of  using Lorem Ipsum is that it has a more-or-less normal distribution of  letters, as opposed to using ''Content here, content here'', making it  look like readable English</p>', 'A', '20130508220541.jpg', '20130508220541.jpg', ''),
(6, 'Veterinary Epidemiology and Animal Health', 'veterinary-epidemiology-and-animal-health', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged', '', '<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and  typesetting industry. Lorem Ipsum has been the industry''s standard dummy  text ever since the 1500s, when an unknown printer took a galley of  type and scrambled it to make a type specimen book. It has survived not  only five centuries, but also the leap into electronic typesetting,  remaining essentially unchanged</p>', 'A', '20130508223241.jpg', '20130508223241.jpg', '');

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

--
-- Table structure for table `snf_journals_details`
--

CREATE TABLE IF NOT EXISTS `snf_journals_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journal_id` int(11) NOT NULL,
  `lable_id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `file` varchar(200) NOT NULL,
  `banner_image` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `snf_journals_details`
--

INSERT INTO `snf_journals_details` (`id`, `journal_id`, `lable_id`, `title`, `file`, `banner_image`, `description`, `status`) VALUES
(1, 4, 1, 'Applied Bioinformatics in Animal Health Microbiology - Aims and scope', '', 'Array', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed purus  et ipsum interdum cursus sit amet in tellus. Integer aliquet tincidunt  odio dapibus dictum. Sed sollicitudin, urna eget fermentum hendrerit,  dolor neque ullamcorper ipsum, vitae dignissim tellus justo vitae nisi.  Ut in sapien libero. Sed posuere placerat egestas. Proin condimentum  malesuada libero, at ultrices est viverra a. Praesent commodo semper  mollis. Phasellus ut eros id urna rhoncus viverra. Cum sociis natoque  penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam  metus lacus, aliquet ut gravida vitae, iaculis laoreet tortor. Sed  ligula mi, bibendum vitae varius et, adipiscing id lorem. Integer quis  pretium ante. Mauris blandit luctus eros et convallis. Nulla facilisi.</p>\r\n<p>Mauris sodales mi non diam tincidunt fermentum. Pellentesque non velit  nunc. Phasellus quis lacus massa. Curabitur adipiscing erat ut nibh  tristique ultrices. Quisque ac nisl justo. Etiam at rhoncus nibh. Fusce  suscipit congue malesuada. Pellentesque interdum nisi vitae diam lacinia  at vulputate diam accumsan. Nulla facilisi. Maecenas mattis fringilla  nisi, sit amet porttitor arcu interdum quis.</p>\r\n<p>Duis non mi elit, eu ornare leo. Mauris adipiscing velit nec orci  laoreet sed aliquet mi condimentum. Vivamus lacinia dui in lorem mollis  semper. Nullam sed consequat dui. Sed nec est purus. Ut pellentesque  eleifend nisi, auctor luctus eros luctus non. Quisque vel diam id justo  congue bibendum. Nulla feugiat tortor vitae dui pulvinar tincidunt.  Phasellus eu erat eros, consectetur fermentum lectus. Duis vulputate  dolor eget nunc placerat quis semper elit tincidunt. Mauris ac magna a  neque convallis porta id vitae neque. Proin at ligula at nunc mattis  accumsan commodo non ipsum.</p>\r\n<p>Phasellus vel enim mi. Aenean cursus hendrerit lacus ut placerat.  Vestibulum convallis leo nec erat ornare tincidunt. Proin fermentum  gravida augue. Nullam metus felis, scelerisque rhoncus consequat a,  placerat in tellus. Etiam magna urna, malesuada id semper et, euismod  bibendum purus. Aliquam elementum porttitor tempus. Ut vitae lorem non  risus viverra adipiscing. Vivamus vitae elit vel diam rutrum euismod vel  et quam. Phasellus a libero massa, eget vestibulum urna. Pellentesque  eget magna magna, non convallis velit. Cum sociis natoque penatibus et  magnis dis parturient montes, nascetur ridiculus mus. Donec adipiscing  felis quis elit tempus facilisis.</p>', 'A'),
(2, 4, 2, 'Applied Bioinformatics in Animal Health Microbiology - Editorial Board', '', 'Array', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sed purus  et ipsum interdum cursus sit amet in tellus. Integer aliquet tincidunt  odio dapibus dictum. Sed sollicitudin, urna eget fermentum hendrerit,  dolor neque ullamcorper ipsum, vitae dignissim tellus justo vitae nisi.  Ut in sapien libero. Sed posuere placerat egestas. Proin condimentum  malesuada libero, at ultrices est viverra a. Praesent commodo semper  mollis. Phasellus ut eros id urna rhoncus viverra. Cum sociis natoque  penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam  metus lacus, aliquet ut gravida vitae, iaculis laoreet tortor. Sed  ligula mi, bibendum vitae varius et, adipiscing id lorem. Integer quis  pretium ante. Mauris blandit luctus eros et convallis. Nulla facilisi.</p>\r\n<p>Mauris sodales mi non diam tincidunt fermentum. Pellentesque non velit  nunc. Phasellus quis lacus massa. Curabitur adipiscing erat ut nibh  tristique ultrices. Quisque ac nisl justo. Etiam at rhoncus nibh. Fusce  suscipit congue malesuada. Pellentesque interdum nisi vitae diam lacinia  at vulputate diam accumsan. Nulla facilisi. Maecenas mattis fringilla  nisi, sit amet porttitor arcu interdum quis.</p>\r\n<p>Duis non mi elit, eu ornare leo. Mauris adipiscing velit nec orci  laoreet sed aliquet mi condimentum. Vivamus lacinia dui in lorem mollis  semper. Nullam sed consequat dui. Sed nec est purus. Ut pellentesque  eleifend nisi, auctor luctus eros luctus non. Quisque vel diam id justo  congue bibendum. Nulla feugiat tortor vitae dui pulvinar tincidunt.  Phasellus eu erat eros, consectetur fermentum lectus. Duis vulputate  dolor eget nunc placerat quis semper elit tincidunt. Mauris ac magna a  neque convallis porta id vitae neque. Proin at ligula at nunc mattis  accumsan commodo non ipsum.</p>\r\n<p>Phasellus vel enim mi. Aenean cursus hendrerit lacus ut placerat.  Vestibulum convallis leo nec erat ornare tincidunt. Proin fermentum  gravida augue. Nullam metus felis, scelerisque rhoncus consequat a,  placerat in tellus. Etiam magna urna, malesuada id semper et, euismod  bibendum purus. Aliquam elementum porttitor tempus. Ut vitae lorem non  risus viverra adipiscing. Vivamus vitae elit vel diam rutrum euismod vel  et quam. Phasellus a libero massa, eget vestibulum urna. Pellentesque  eget magna magna, non convallis velit. Cum sociis natoque penatibus et  magnis dis parturient montes, nascetur ridiculus mus. Donec adipiscing  felis quis elit tempus facilisis.</p>', 'A'),
(3, 4, 3, 'Applied Bioinformatics in Animal Health Microbiology - Online First Article', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(4, 4, 4, 'Applied Bioinformatics in Animal Health Microbiology', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(5, 4, 5, 'Applied Bioinformatics in Animal Health Microbiology - Archive', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(6, 4, 6, 'Applied Bioinformatics in Animal Health Microbiology - Journal Spotlights', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(7, 4, 7, 'Applied Bioinformatics in Animal Health Microbiology', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(8, 4, 8, 'Applied Bioinformatics in Animal Health Microbiology - Contact Information', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(9, 4, 9, 'Applied Bioinformatics in Animal Health Microbiology - Free eTOC alerts', '', 'Array', '<ol>\r\n    <li>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. </li>\r\n    <li>The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</li>\r\n    <li>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. </li>\r\n    <li>The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  </li>\r\n    <li>making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. </li>\r\n    <li>The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</li>\r\n</ol>', 'A'),
(10, 4, 10, 'Applied Bioinformatics in Animal Health Microbiology - Abstracting and indexing', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(11, 4, 11, 'Applied Bioinformatics in Animal Health Microbiology - Thanks to reviewers', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(12, 4, 12, 'Applied Bioinformatics in Animal Health Microbiology - Permissions and Reprints', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(13, 4, 13, 'Applied Bioinformatics in Animal Health Microbiology - Open Special Issues', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(14, 4, 14, 'Applied Bioinformatics in Animal Health Microbiology - Call for Special Issues', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(15, 4, 15, 'Applied Bioinformatics in Animal Health Microbiology - Special issue guidelines', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A'),
(16, 4, 16, 'Applied Bioinformatics in Animal Health Microbiology - Published special issues', '', 'Array', '<p>It is a long established fact that a reader will be distracted by the   readable content of a page when looking at its layout. The point of   using Lorem Ipsum is that it has a more-or-less normal distribution of   letters, as opposed to using ''Content here, content here'', making it   look like readable English.</p>\r\n<p>It is a long established fact that a reader will be distracted by the      readable content of a page when looking at its layout. The point of      using Lorem Ipsum is that it has a more-or-less normal distribution  of     letters, as opposed to using ''Content here, content here'',  making it     look like readable English It is a long established fact  that a reader   will be distracted by the   readable content of a page  when looking at   its layout. The point of   using Lorem Ipsum is that  it has a   more-or-less normal distribution of   letters, as opposed to  using   ''Content here, content here'', making it   look like readable  English.</p>', 'A');

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

--
-- Table structure for table `snf_journals_issues`
--

CREATE TABLE IF NOT EXISTS `snf_journals_issues` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journal_id` int(11) NOT NULL,
  `lable` varchar(200) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `snf_journals_issues`
--

INSERT INTO `snf_journals_issues` (`id`, `journal_id`, `lable`, `status`) VALUES
(4, 1, 'Existence and Approximation Algorithm for Fixed Points of Nonlinear Operators and Solutions of Varia', 'A'),
(3, 4, 'Regular Issue', 'A'),
(8, 2, 'Importatn', 'A');

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

--
-- Table structure for table `snf_lables`
--

CREATE TABLE IF NOT EXISTS `snf_lables` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `seoTitle` varchar(255) NOT NULL,
  `modified_date` date NOT NULL,
  `entry_date` date NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `snf_lables`
--

INSERT INTO `snf_lables` (`id`, `title`, `seoTitle`, `modified_date`, `entry_date`, `status`) VALUES
(1, 'Aims & Scope', 'aims-and-scope', '2013-05-26', '2013-05-25', 1),
(2, 'Editorial Board', 'editorial-board', '2013-05-26', '2013-05-25', 1),
(3, 'Online First Articles', 'online-first-articles', '2013-05-26', '2013-05-25', 1),
(4, 'Current Issue', 'current-issue', '2013-05-26', '2013-05-25', 1),
(5, 'Archive', 'archive', '2013-05-26', '2013-05-25', 1),
(6, 'Journal Spotlights', 'journal-spotlights', '2013-05-26', '2013-05-25', 1),
(7, 'Author Guidelines', 'author-guidelines', '2013-05-26', '2013-05-25', 1),
(8, 'Contact Information', 'contact-information', '2013-05-26', '2013-05-25', 1),
(9, 'Free eTOC Alerts', 'free-etoc-alerts', '2013-05-26', '2013-05-25', 1),
(10, 'Abstracting & Indexing', 'abstracting-and-indexing', '2013-05-25', '2013-05-25', 1),
(11, 'Thanks to Reviewers', 'thanks-to-reviewers', '2013-05-26', '2013-05-25', 1),
(12, 'Permissions & Reprints', 'permissions-and-reprints', '2013-05-26', '2013-05-25', 1),
(13, 'Open Special Issues', 'open-special-issues', '2013-05-26', '2013-05-25', 1),
(14, 'Call for Special Issues', 'call-for-special-issues', '2013-05-26', '2013-05-25', 1),
(15, 'Special Issue Guidelines', 'special-issue-guidelines', '2013-05-26', '2013-05-25', 1),
(16, 'Published Special Issues', 'published-special-issues', '2013-05-26', '2013-05-25', 1),
(17, 'Subscription', 'subscription', '2013-07-28', '2013-07-28', 1),
(18, 'Search for articles', 'search-for-articles', '2013-07-28', '2013-07-28', 1);

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

--
-- Table structure for table `snf_manuscript`
--

CREATE TABLE IF NOT EXISTS `snf_manuscript` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ms_no` int(6) NOT NULL,
  `journal_id` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `type_id` int(11) NOT NULL,
  `issue_id` int(11) NOT NULL,
  `file` varchar(100) NOT NULL,
  `cover_letter` varchar(100) NOT NULL,
  `supplementary_materials` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'Manuscript submitted',
  `user_id` int(11) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `snf_manuscript`
--

INSERT INTO `snf_manuscript` (`id`, `ms_no`, `journal_id`, `title`, `type_id`, `issue_id`, `file`, `cover_letter`, `supplementary_materials`, `status`, `user_id`, `date`) VALUES
(14, 785317, 2, 'Another test', 7, 0, '20130215202011.pdf', '20130215202011_1.pdf', '20130215202011_2.pdf', 'Initial quality control', 2, '2013-02-15'),
(2, 486694, 1, 'Manuscript Title', 4, 5, '20121024073901.jpg', 'Array', 'Array', 'Initial quality control', 1, '2012-10-24'),
(3, 446814, 1, 'Test', 3, 3, '20121101081430.pdf', '20121101081430_1.pdf', 'Array', 'Under review', 2, '2012-11-01'),
(4, 852426, 1, 'Test', 2, 3, '20121109175131.pdf', 'Array', 'Array', 'Decision in process', 2, '2012-11-09'),
(5, 152867, 1, 'dsfsdf', 4, 0, 'Array', 'Array', 'Array', 'Initial quality control', 1, '2012-12-04'),
(17, 817122, 2, 'Another test for message', 8, 8, '20130221143316.pdf', '20130221143316_1.pdf', 'Array', 'Manuscript submitted', 2, '2013-02-21'),
(16, 919348, 12, 'testing menuscript', 8, 0, '20130219125344.pdf', 'Array', 'Array', 'Accepted', 1, '2013-02-19'),
(15, 472933, 2, 'Test with message to sender', 5, 8, '20130218224352.pdf', '20130218224452.pdf', 'Array', 'Accepted', 2, '2013-02-18'),
(18, 349976, 2, 'test script', 5, 8, '20130221154204.pdf', '20130221154204_1.pdf', 'Array', 'Manuscript submitted', 1, '2013-02-21'),
(19, 567322, 2, '', 0, 0, 'Array', 'Array', 'Array', 'Manuscript submitted', 1, '2013-02-22');

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

--
-- Table structure for table `snf_manuscript_authors`
--

CREATE TABLE IF NOT EXISTS `snf_manuscript_authors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `given_names` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `affiliation` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `corresponding_author` tinyint(1) NOT NULL,
  `menuscript_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

--
-- Dumping data for table `snf_manuscript_authors`
--

INSERT INTO `snf_manuscript_authors` (`id`, `title`, `given_names`, `last_name`, `email`, `affiliation`, `country`, `corresponding_author`, `menuscript_id`) VALUES
(1, 'Dr', 'Shakeel', 'Zafar', 'shahid.iqbal@hiconintl.com', 'test', 'Pakistan', 1, 1),
(2, 'Mrs', 'test', 'test', 'test@test.com', 'test', 'Afghanistan', 0, 1),
(3, 'Mr', 'Shakeel', 'test', 'shakeel@hiconintl.com', 'test', 'Afghanistan', 1, 2),
(4, 'Dr', 'Muhammad', 'Munir', 'drmunir.muhammad@gmail.com', 'SLu', 'Sweden', 1, 3),
(5, 'Mr', 'Munir', 'Muhammad', 'drmunir.muhammad@gmail.com', 'SLU', 'Pakistan', 1, 4),
(6, 'Dr', 'sdf', 'dsf', 'shak@gmail.com', 'sdf', 'Albania', 1, 5),
(7, 'Dr', 'sdf', 'sdf', 'shak@gmail.com', 'sada', 'Afghanistan', 0, 5),
(8, 'Mr', 'asd', 'asd', 'asdshak@gmail.com', 'asd', 'Afghanistan', 0, 5),
(9, '', '', '', '', '', '', 0, 7),
(10, '', '', '', '', '', '', 0, 7),
(11, '', '', '', '', '', '', 0, 7),
(12, '', '', '', '', '', '', 0, 8),
(13, '', '', '', '', '', '', 0, 8),
(14, '', '', '', '', '', '', 0, 8),
(15, '', '', '', '', '', '', 0, 9),
(16, '', '', '', '', '', '', 0, 9),
(17, '', '', '', '', '', '', 0, 9),
(18, '', '', '', '', '', '', 0, 10),
(19, '', '', '', '', '', '', 0, 10),
(20, '', '', '', '', '', '', 0, 10),
(21, '', '', '', '', '', '', 0, 11),
(22, '', '', '', '', '', '', 0, 11),
(23, '', '', '', '', '', '', 0, 11),
(24, '', '', '', '', '', '', 0, 12),
(25, '', '', '', '', '', '', 0, 12),
(26, '', '', '', '', '', '', 0, 12),
(27, '', '', '', '', '', '', 0, 13),
(28, '', '', '', '', '', '', 0, 13),
(29, '', '', '', '', '', '', 0, 13),
(30, 'Dr', 'Muhammad', 'Munir', 'drmunir.muhammad@gmail.com', 'SLU', 'Sweden', 1, 14),
(31, 'Dr', 'Munir', 'Muhammad', 'drmunir.muhammad@gmail.com', 'SLU', 'Sweden', 1, 15),
(32, 'Dr', 'aadil', 'rehman', 'aadil@hiconintl.com', 'nexus', 'Pakistan', 1, 16),
(33, 'Dr', 'slkd', 'sd', 'aadil@hiconintl.com', 'nexus', 'Pakistan', 0, 16),
(34, 'Mrs', 'slkd', 'slkd', 'aadil@hiconintl.com', 'zx', 'Pakistan', 0, 16),
(35, 'Dr', 'Munir', 'Muhammad', 'drmunir.muhammad@gmail.com', 'SLU', 'Sweden', 1, 17),
(36, 'Mr', 'aadil', 'rehman', 'aadil@hiconintl.com', 'sfdf', 'Pakistan', 1, 18),
(37, 'Mr', 'aadil', 'rehman', 'aadil@hiconintl.com', 'sdf', 'Pakistan', 0, 18),
(38, 'Mr', 'aadil', 'rehman', 'aadil@hiconintl.com', 'sdf', 'Pakistan', 0, 18),
(39, '', '', '', '', '', '', 0, 19);

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

--
-- Table structure for table `snf_manuscript_type`
--

CREATE TABLE IF NOT EXISTS `snf_manuscript_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lable` varchar(200) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'A',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `snf_manuscript_type`
--

INSERT INTO `snf_manuscript_type` (`id`, `lable`, `status`) VALUES
(8, 'Research Article', 'A'),
(3, 'Review Article', 'A'),
(4, 'Editorial', 'A'),
(5, 'Letter to the Editor', 'A'),
(6, 'Erratum', 'A'),
(7, 'Revised Manuscript', 'A');

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

--
-- Table structure for table `snf_msg_manage`
--

CREATE TABLE IF NOT EXISTS `snf_msg_manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `type` varchar(50) NOT NULL,
  `page_id` varchar(50) NOT NULL,
  `entry_by` int(11) NOT NULL,
  `entry_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_p2p_msg_manage_fk_1` (`entry_by`),
  KEY `tbl_p2p_msg_manage_fk_2` (`modified_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `snf_msg_manage`
--

INSERT INTO `snf_msg_manage` (`id`, `message`, `type`, `page_id`, `entry_by`, `entry_date`, `modified_date`, `modified_by`) VALUES
(2, '<p>Thank you very much for contacting Smith &amp; Franklin - Academic Publishing Corporation.<br />\r\n<br />\r\nThis is an automated response.<br />\r\n<br />\r\nWe will get back to you shortly via e-mail or one of our customer support officer will contact you within 24 hours.<br />\r\n<br />\r\n<br />\r\nThanks for your understanding.<br />\r\n<br />\r\n&nbsp;<br />\r\n<strong><br />\r\nSmith &amp; Franklin - Academic Publishing Corporation</strong></p>', 'contact_us', '', 1, '2012-02-22 02:33:50', '2013-04-28 19:00:49', 1),
(3, '<p><span style="color: rgb(0, 0, 0); ">Thank you very much for registering with Smith &amp; Franklin - Academic Publishing Corporation</span></p>\r\n<p><span style="color: rgb(0, 0, 0); ">This is an automated response.</span></p>\r\n<p><span style="color: rgb(0, 0, 0); ">We will get back to you shortly via e-mail or one of our customer support officer will contact you within 24 hours.</span></p>\r\n<p style="text-align: left; "><span style="color: rgb(0, 0, 0); "><br />\r\n</span><span style="color: rgb(0, 0, 0); ">Thanks</span> for your understanding.</p>\r\n<p style="text-align: left; "><strong>Smith &amp; Franklin - Academic Publishing Corporation</strong></p>', 'register', '', 1, '2012-09-20 08:58:19', '2013-04-28 20:36:16', 1),
(4, '<p>Thank you for Account activation with Royal Airport Services.</p>\r\n<p>This is an automated response.</p>\r\n<p>We will get back to you shortly via e-mail or one of customer support officer.</p>\r\n<p>Royal Airport Services.</p>\r\n<p>Thanks.&nbsp;</p>', 'dealersactive', '', 1, '2012-09-20 09:22:59', '2012-09-20 09:22:59', 1),
(5, '<p>Account already activated with Royal Airport Services.</p>\r\n<p>This is an automated response.</p>\r\n<p>We will get back to you shortly via e-mail or one of customer support officer.</p>\r\n<p>Royal Airport Services.</p>\r\n<p>Thanks.&nbsp;</p>', 'alreadyactive', '', 1, '2012-09-20 09:23:26', '2012-09-20 09:23:26', 1),
(6, '<p>Invalid authentication informaiton. Please try again with correct information or contact us (right top corner) for futher help.</p>', 'login_failed', '', 1, '2012-09-20 10:09:18', '2012-12-11 18:37:45', 1),
(7, '<p>&nbsp;You are logged out successfully. Thanks for visiting us.</p>', 'logout', '', 1, '2012-09-20 10:58:03', '2012-12-11 18:36:06', 1),
(8, '<p>Thanks for your free subscription for eTOC.</p>', 'eTOC_Alerts', '', 1, '2012-12-11 18:38:47', '2012-12-11 18:38:47', 1),
(9, '<p>Thank you very much for contacting Smith &amp; Franklin - Academic Publishing Corporation.<br />\r\n<br />\r\nThis is an automated response.<br />\r\n&nbsp;  <br />\r\n<strong><br />\r\nSmith &amp; Franklin - Academic Publishing Corporation</strong></p>', 'article_send_to_friend', '', 1, '2013-06-20 13:52:50', '2013-06-20 13:52:50', 1),
(10, '<p>Your email is not sent, please try again.<br />\r\n<strong><br />\r\nSmith &amp; Franklin - Academic Publishing Corporation</strong></p>', 'article_not_send_to_friend', '', 1, '2013-06-20 13:53:41', '2013-06-20 13:53:41', 1),
(11, '<p><span style="color: rgb(0, 0, 0); ">Your account is successfully updated.</span></p>\r\n<p style="text-align: left; "><strong>Smith &amp; Franklin - Academic Publishing Corporation</strong></p>', 'profile', '', 1, '2013-07-03 07:10:45', '2013-07-03 07:10:45', 1),
(12, '<p><span style="color: rgb(0, 0, 0); ">Thank you very much for newsletter subscription with Smith &amp; Franklin - Academic Publishing Corporation</span></p>\r\n<p><span style="color: rgb(0, 0, 0); ">This is an automated response.</span></p>\r\n<p><span style="color: rgb(0, 0, 0); ">We will get back to you shortly via e-mail.</span></p>\r\n<p style="text-align: left; "><span style="color: rgb(0, 0, 0); "><br />\r\n</span><span style="color: rgb(0, 0, 0); ">Thanks</span> for your understanding.</p>\r\n<p style="text-align: left; "><strong>Smith &amp; Franklin - Academic Publishing Corporation</strong></p>', 'newsletter', '', 1, '2013-07-16 17:06:38', '2013-07-16 17:06:38', 1);

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

--
-- Table structure for table `snf_news`
--

CREATE TABLE IF NOT EXISTS `snf_news` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `entry_by` date NOT NULL,
  `modified_date` date NOT NULL,
  `modified_by` date NOT NULL,
  `entry_date` date NOT NULL,
  `status` char(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `snf_news`
--

INSERT INTO `snf_news` (`id`, `title`, `description`, `entry_by`, `modified_date`, `modified_by`, `entry_date`, `status`) VALUES
(9, 'The standard Lorem Ipsum passage, used since the 1500s', '"Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(10, 'Section 1.10.32 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC', '"Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?"', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(11, '1914 translation by H. Rackham', '"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?"', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(12, 'Section 1.10.33 of "de Finibus Bonorum et Malorum", written by Cicero in 45 BC', '"At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint occaecati cupiditate non provident, similique sunt in culpa qui officia deserunt mollitia animi, id est laborum et dolorum fuga. Et harum quidem rerum facilis est et expedita distinctio. Nam libero tempore, cum soluta nobis est eligendi optio cumque nihil impedit quo minus id quod maxime placeat facere possimus, omnis voluptas assumenda est, omnis dolor repellendus. Temporibus autem quibusdam et aut officiis debitis aut rerum necessitatibus saepe eveniet ut et voluptates repudiandae sint et molestiae non recusandae. Itaque earum rerum hic tenetur a sapiente delectus, ut aut reiciendis voluptatibus maiores alias consequatur aut perferendis doloribus asperiores repellat."', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A'),
(13, '1914 translation by H. Rackham', '"On the other hand, we denounce with righteous indignation and dislike men who are so beguiled and demoralized by the charms of pleasure of the moment, so blinded by desire, that they cannot foresee the pain and trouble that are bound to ensue; and equal blame belongs to those who fail in their duty through weakness of will, which is the same as saying through shrinking from toil and pain. These cases are perfectly simple and easy to distinguish. In a free hour, when our power of choice is untrammelled and when nothing prevents our being able to do what we like best, every pleasure is to be welcomed and every pain avoided. But in certain circumstances and owing to the claims of duty or the obligations of business it will frequently occur that pleasures have to be repudiated and annoyances accepted. The wise man therefore always holds in these matters to this principle of selection: he rejects pleasures to secure other greater pleasures, or else he endures pains to avoid worse pains."', '0000-00-00', '2013-07-25', '0000-00-00', '2013-07-25', 'A');

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

--
-- Table structure for table `snf_newsletter`
--

CREATE TABLE IF NOT EXISTS `snf_newsletter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_subject` varchar(255) NOT NULL,
  `email_content` longtext NOT NULL,
  `email_dateentry` datetime NOT NULL,
  `email_status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `snf_newsletter`
--

INSERT INTO `snf_newsletter` (`id`, `email_subject`, `email_content`, `email_dateentry`, `email_status`) VALUES
(8, 'Welcome To Smith & Franklin - Academic Publishing Corporation', '<p>Dear All,<br />\r\n<br />\r\nthis is test email, please do not responce<br />\r\n<br />\r\nRegards,<br />\r\n<br />\r\nSmith &amp; Franklin<br />\r\n<br />\r\nAcademic Publishing Coorporation</p>', '2013-04-30 16:54:27', 0);

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

--
-- Table structure for table `snf_online_first_articles`
--

CREATE TABLE IF NOT EXISTS `snf_online_first_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journalID` int(11) NOT NULL,
  `dateSelected` date NOT NULL,
  `articleTitle` varchar(255) NOT NULL,
  `articleSEOTitle` varchar(255) NOT NULL,
  `articleShortDesc` text NOT NULL,
  `entryDate` datetime NOT NULL,
  `articleStatus` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_online_first_articles`
--

INSERT INTO `snf_online_first_articles` (`id`, `journalID`, `dateSelected`, `articleTitle`, `articleSEOTitle`, `articleShortDesc`, `entryDate`, `articleStatus`) VALUES
(1, 1, '2013-05-31', 'Merkel Cell Polyomavirus Large T Antigen has Growth Promoting and Inhibitory Activities', 'merkel-cell-polyomavirus-large', '<p>Jingwei Cheng, Orit Rozenblatt-Rosen, Kelly G. Paulson, Paul Nghiem, and James A.</p>\r\n<p>DeCaprio J. Virol. published ahead of print 20 March 2013, doi:10.1128/JVI.00385-13</p>', '2013-06-10 03:13:23', 1),
(2, 4, '2013-05-31', 'In Vitro Assembly of Virus-Like Particles of a Gammaretrovirus, the Murine Leukemia Virus XMRV', 'in-vitro-assembly-of-virus-like-particles', '<p>Romana Hadravov&aacute;a, Alex de Marcob, Pavel Ulbrichc, Jitka &Scaron;tokrov&aacute;a,</p>\r\n<p>Michal Doležal Iva Pichov&aacute;a, Tom&aacute;&scaron; Rumlc, John A. G. Briggsb</p>', '2013-06-14 04:13:18', 1),
(3, 4, '2013-06-14', 'Applying Bioinformatics to Precision Medicine', 'article-for-applying-bioinformatics-to-precision-medicine', '<p>Applied Bioinformatics is a resource for professional bioinformaticists,  providing readers with topical reviews of computational and  methodological developments. In addition, the journal contains original  research articles on all areas of bioinformatics, with a focus on  microarray analysis, databases and datamining, protein structure  prediction and genomics. Applied Bioinformatics features articles that  provide the practising bioinformaticist with information relating to  global and regional bioinformatics resources, and a future view of this  developing field. In this respect, we endeavour to keep our readers  updated on various computational and experimental standards and  practices that emerge.</p>', '2013-06-13 19:33:16', 1);

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

--
-- Table structure for table `snf_online_first_articles_details`
--

CREATE TABLE IF NOT EXISTS `snf_online_first_articles_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articleID` int(11) NOT NULL,
  `journalID` int(11) NOT NULL,
  `title1` varchar(255) NOT NULL,
  `articleTitle` varchar(255) NOT NULL,
  `articleSEOTitle` varchar(255) NOT NULL,
  `authors` varchar(255) NOT NULL,
  `authorsAffiliations` text NOT NULL,
  `articleFile` varchar(255) NOT NULL,
  `abstract` longtext NOT NULL,
  `entryDate` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `snf_online_first_articles_details`
--

INSERT INTO `snf_online_first_articles_details` (`id`, `articleID`, `journalID`, `title1`, `articleTitle`, `articleSEOTitle`, `authors`, `authorsAffiliations`, `articleFile`, `abstract`, `entryDate`) VALUES
(1, 3, 4, 'J. Virol. published ahead of print 20 March 2013, doi:10.1128/JVI.00385-13', 'In Vitro Assembly of Virus-Like Particles of a Gammaretrovirus, the Murine Leukemia Virus XMRV', 'article-for-applying-bioinformatics-to-precision-medicine', 'Romana Hadravovaa, Alex de Marcob, Pavel Ulbrichc, Jitka Stokrovaa, Michal Dolezal Iva Pichovaa, Tomas Rumlc, John A. G. Briggsb', 'aInstitute of Organic Chemistry and Biochemistry, Academy of Sciences of the Czech\r\nRepublic, v.v.i., IOCB and Gilead Research Center, Prague, Czech Republic, \r\nbStructural and Computational Unit, European Molecular Biology Laboratory,\r\nHeidelberg, Germany, cDepartment of Biochemistry and Microbiology, Institute of\r\nChemical Technology, Prague, Czech Republic.', '1371283842automata.pdf', '<p>Immature retroviral particles are assembled by self-association of the structural polyprotein precursor Gag. During maturation the Gag polyprotein is proteolytically cleaved, yielding mature structural proteins, matrix (MA), capsid (CA), and nucleocapsid (NC), that reassemble into a mature viral particle. Proteolytic cleavage causes the N terminus of CA to fold back to form a &beta;-hairpin, anchored by an internal salt bridge between the N-terminal proline and the inner aspartate. Using an in vitro assembly system of capsid-nucleocapsid protein (CANC), we studied the formation of virus-like particles (VLP) of a gammaretrovirus, the xenotropic murine leukemia virus (MLV) related virus (XMRV). We show here that, unlike other retroviruses, XMRV CA and CANC do not assemble tubular particles characteristic of mature assembly. The prevention of &beta;-hairpin formation by the deletion of either the N-terminal proline or 10 initial amino acids enabled the assembly of &#8710;ProCANC or &#8710;10CANC into immature-like spherical particles. Detailed three-dimensional (3D) structural analysis of these particles revealed that below a disordered N-terminal CA layer, the C terminus of CA assembles a typical immature lattice, which is linked by rod-like densities with the RNP</p>', '2013-06-13 21:56:07'),
(2, 2, 4, 'Most-Read Articles during May 2013', 'Most-Read Articles during May 2013', 'most-read-articles-during-may-2013', 'Romana Hadravovaa, Alex de Marcob, Pavel Ulbrichc, Jitka Stokrovaa, Michal Dolezal Iva Pichovaa, Tomas Rumlc, John A. G. Briggsb', 'Romana Hadravovaa, Alex de Marcob, Pavel Ulbrichc, Jitka Stokrovaa, Michal Dolezal Iva Pichovaa, Tomas Rumlc, John A. G. Briggsb', '1371291060automata-ciaa02.pdf', '<p><em>Accurate alignment of high-throughput RNA-seq data is a challenging and yet unsolved problem because of the non-contiguous transcript structure, relatively short read lengths and constantly increasing throughput of the sequencing technologies. Currently available RNA-seq aligners suffer from high mapping error rates, low mapping speed, read length limitation and mapping biases. To align our large (&gt;80 billon reads) ENCODE Transcriptome RNA-seq  dataset, we developed the Spliced Transcripts Alignment                      to a Reference (STAR) software based on a  previously undescribed RNA-seq alignment algorithm that uses sequential  maximum                      mappable seed search in uncompressed suffix arrays  followed by seed clustering and stitching procedure. STAR outperforms  other                      aligners by a factor of &gt;50 in mapping speed,  aligning to the human genome 550 million 2 &times; 76 bp paired-end reads per  hour                      on a modest 12-core server, while at the same time  improving alignment sensitivity and precision. In addition to unbiased                      de novo detection of canonical junctions,  STAR can discover non-canonical splices and chimeric (fusion)  transcripts, and is also                      capable of mapping full-length RNA sequences. Using  Roche 454 sequencing of reverse transcription polymerase chain reaction                      amplicons, we experimentally validated 1960 novel  intergenic splice junctions with an 80&ndash;90% success rate, corroborating  the                      high precision of the STAR mapping strategy.</em></p>', '2013-06-15 10:11:00');

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

--
-- Table structure for table `snf_online_first_articles_social`
--

CREATE TABLE IF NOT EXISTS `snf_online_first_articles_social` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `articleID` int(11) NOT NULL,
  `journalID` int(11) NOT NULL,
  `CiteULike` varchar(255) NOT NULL,
  `Connotea` varchar(255) NOT NULL,
  `Delicious` varchar(255) NOT NULL,
  `Digg` varchar(255) NOT NULL,
  `Facebook` varchar(255) NOT NULL,
  `Google` varchar(255) NOT NULL,
  `Mendeley` varchar(255) NOT NULL,
  `Reddit` varchar(255) NOT NULL,
  `StumbleUpon` varchar(255) NOT NULL,
  `Twitter` varchar(255) NOT NULL,
  `LinkedIn` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `snf_online_first_articles_social`
--

INSERT INTO `snf_online_first_articles_social` (`id`, `articleID`, `journalID`, `CiteULike`, `Connotea`, `Delicious`, `Digg`, `Facebook`, `Google`, `Mendeley`, `Reddit`, `StumbleUpon`, `Twitter`, `LinkedIn`) VALUES
(1, 3, 4, 'http://www.CiteULike.com/', 'http://www.Connotea.com/', 'http://www.Delicious.com/', 'http://www.Digg.com/', 'http://www.Facebook.com/', 'http://www.Google.com/', 'http://www.Mendeley.com/', 'http://www.Reddit.com/', 'http://www.StumbleUpon.com/', 'http://www.Twitter.com/', 'http://www.LinkedIn.com/'),
(2, 2, 4, 'http://www.CiteULike,com/', 'http://www.Connotea,com/', 'http://www.Delicious,com/', 'http://www.Digg,com/', 'http://www.Facebook,com/', 'http://www.Google,com/', 'http://www.Mendeley,com/', 'http://www.Reddit,com/', 'http://www.StumbleUpon,com/', 'http://www.Twitter,com/', 'http://www.LinkedIn,com/'),
(3, 1, 1, 'http://www.CiteULike.com/', 'http://www.Connotea.com/', 'http://www.Delicious.com/', 'http://www.Digg.com/', 'http://www.Facebook.com/', 'http://www.Google.com/', 'http://www.Mendeley.com/', 'http://www.Reddit.com/', 'http://www.StumbleUpon.com/', 'http://www.Twitter.com/', 'http://www.LinkedIn.com/'),
(4, 0, 0, 'http://www.CiteULike.com/', 'http://www.Connotea.com/', 'http://www.Delicious.com/', 'http://www.Digg.com/', 'http://www.Facebook.com/', 'http://www.Google.com/', 'http://www.Mendeley.com/', 'http://www.Reddit.com/', 'http://www.StumbleUpon.com/', 'http://www.Twitter.com/', 'http://www.LinkedIn.com/');

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

--
-- Table structure for table `snf_pagecontent`
--

CREATE TABLE IF NOT EXISTS `snf_pagecontent` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) DEFAULT NULL,
  `page_heading` varchar(250) NOT NULL,
  `page_subheading` varchar(250) NOT NULL,
  `meta_keyword` longtext,
  `meta_phrase` longtext,
  `meta_description` longtext,
  `page_type` varchar(50) DEFAULT NULL,
  `entry_by` int(11) NOT NULL,
  `entry_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `type` varchar(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_p2p_pagecontent_fk_1` (`entry_by`),
  KEY `tbl_p2p_pagecontent_fk_2` (`modified_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;



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

--
-- Table structure for table `snf_seometatags`
--

CREATE TABLE IF NOT EXISTS `snf_seometatags` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `classification` text NOT NULL,
  `robots` text NOT NULL,
  `google_site_verification` text NOT NULL,
  `language` text NOT NULL,
  `resource_type` text NOT NULL,
  `copyright` text NOT NULL,
  `author` text NOT NULL,
  `PICS_Label` text NOT NULL,
  `distribution` text NOT NULL,
  `coverage` text NOT NULL,
  `country` text NOT NULL,
  `location` text NOT NULL,
  `entry_by` int(11) NOT NULL,
  `entry_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  PRIMARY KEY (`tag_id`),
  KEY `tbl_p2p_seometatags_fk_1` (`entry_by`),
  KEY `tbl_p2p_seometatags_fk_2` (`modified_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `snf_seometatags`
--

INSERT INTO `snf_seometatags` (`tag_id`, `classification`, `robots`, `google_site_verification`, `language`, `resource_type`, `copyright`, `author`, `PICS_Label`, `distribution`, `coverage`, `country`, `location`, `entry_by`, `entry_date`, `modified_date`, `modified_by`) VALUES
(1, 'Classification Classification', 'index,follow', ' ', 'En-UK', 'Resource Type Resource Type', 'Copyright Copyright', 'British Claims Company', 'PICS Label PICS Label', 'Distribution Distribution', 'WorldWide', 'United Kingdom', 'United Kingdom', 1, '2012-02-21 23:33:07', '2013-05-13 01:51:21', 1);

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

--
-- Table structure for table `snf_socialpages`
--

CREATE TABLE IF NOT EXISTS `snf_socialpages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `facebook` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `linkedin` varchar(255) NOT NULL,
  `googleplus` varchar(255) NOT NULL,
  `wikipedia` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `podcast` varchar(255) NOT NULL,
  `rss` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `snf_socialpages`
--

INSERT INTO `snf_socialpages` (`id`, `facebook`, `twitter`, `linkedin`, `googleplus`, `wikipedia`, `youtube`, `podcast`, `rss`) VALUES
(1, 'https://www.facebook.com/', 'http://www.twitter.com/', 'http://www.linkedin.com/', 'https://plus.google.com/', 'http://www.wikipedia.org/', 'https://www.youtube.com/', 'http://www.podcast.com', 'http://www.rss.org/');

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

--
-- Table structure for table `snf_spotlights`
--

CREATE TABLE IF NOT EXISTS `snf_spotlights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imageTitle` varchar(255) NOT NULL,
  `imageLink` varchar(255) NOT NULL,
  `imageImage` varchar(255) NOT NULL,
  `imageDescription` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  `imageStatus` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_spotlights`
--

INSERT INTO `snf_spotlights` (`id`, `imageTitle`, `imageLink`, `imageImage`, `imageDescription`, `entryDate`, `imageStatus`) VALUES
(2, 'Amithab - Bollywood King', 'http://hardwar.olx.in/warehouse-space-for-rent-mkt-by-manav-properties-09760143999-iid-477402434', '20130723125044.jpg', 'Warehouse Space for Rent mkt by Manav Properties 09760143999 we r provide all type of godowns size n best rate in haridwar sidcul n all bahadrabad call MANAV PROPERTIES S 282 SHIVALIK NAGAR HARIDWAR 09760143999, 09997240817\r\n', '2013-07-23 12:44:50', 1),
(3, 'Property Seller', 'http://www.purpleinternational.eu/PropertySalesRentals.aspx', '20130723125746.jpg', 'Purpose: Rent\r\nType: Apartment\r\nBedrooms: 1\r\nRegion: Larnaca\r\nCountry: Cyprus\r\nPrice: €300\r\nRef.: DEV7000 ', '2013-07-23 12:46:57', 1);

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

--
-- Table structure for table `snf_tableofcontents`
--

CREATE TABLE IF NOT EXISTS `snf_tableofcontents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `script_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `descraption` longtext NOT NULL,
  `file` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  `journals_id` int(11) NOT NULL,
  `s_description` longtext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `snf_tableofcontents`
--

INSERT INTO `snf_tableofcontents` (`id`, `script_id`, `title`, `descraption`, `file`, `date`, `journals_id`, `s_description`) VALUES
(3, 4, 'sdsaa', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lectus orci, laoreet id pretium sed, laoreet ultricies lacus. In ac metus velit. Morbi mollis mollis imperdiet. Nulla tristique feugiat vehicula. Ut id enim augue, sed consequat nunc. Proin eu risus ipsum, sit amet faucibus augue. Cras varius mauris ut erat mollis blandit. Ut feugiat eleifend orci, vel congue enim sagittis ac.   Ut egestas magna nunc. Sed in massa sapien, sit amet luctus lorem. Sed libero leo, vestibulum sed porttitor id, adipiscing a elit. Mauris placerat mattis lacus, ut vulputate diam imperdiet sit amet. Ut tempus sollicitudin justo, ac cursus eros dictum vel. Donec in mauris turpis, quis pulvinar augue. Nullam laoreet, eros nec viverra ullamcorper, massa mauris consequat ligula, non facilisis nulla dolor ut quam. Phasellus fermentum dolor sit amet nisi lacinia placerat.</p>', '20130208182920.docx', '2013-02-05 00:00:00', 5, ''),
(4, 4, 'bind to the longer target DNA and the first unp', '<p>Muhammad Munir, Gulzeb, Asif&nbsp;             <style type="text/css">\r\n<!--{13612828173820}-</style></p>\r\n<p><style type="text/css"></style><span style="font-size:12.0pt;line-height:115%;font-family:\r\n&quot;Times New Roman&quot;;mso-fareast-font-family:&quot;ＭＳ 明æœ&quot;;mso-fareast-theme-font:minor-fareast;\r\nmso-ansi-language:EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA">Foot and mouth disease (FMD) remained an endemic disease in Pakistani livestock population during 2011 and 2012. <span style="mso-spacerun:yes">&nbsp;</span>To ascertain the genetic nature of circulating FMD virus, samples were collected from suspected outbreaks in Southern Punjab. The virus was primarily detected with RT-PCR with P1/P2 and 1F/1R universal primer pairs directly from field samples including tissues, vesicle and secretion. The direct sequencing and subsequent analysis of amplified PCR products for VP1 gene indicated the circulation of O serotype of FMD in studied areas. Moreover, The SA<sub>(F)</sub>/SA<sub>(R)</sub> designed O serotype specific primer were confirmed serotype O in all representative samples. The PCR product of SA<sub>(F)</sub>/SA<sub>(R) </sub>has targeted the complete VP1 gene, which is most variable region in FMD genome. The nucleotide sequences representative to different areas were found 98% similar to each other and clustered into PanAsian II lineage of FMD O serotype along with previous isolates of Pakistan. These isolates have homology with previous isolates of Pakistan such as <span style="color:black;mso-themecolor:text1">O/PAK Lahore vaccine</span>, Afghanistan, Iran, India, Nepal and Bhutan. The network analysis of complete VP1 gene nucleotide sequence with other sixty PanAsian II isolates demonstrated central node with some <span style="color:black;\r\nmso-themecolor:text1">Nepal 2003, Bhutan 2004, Pakistani, Afghan and Iranian isolates. The O/PAK Lahore vaccine was at two mutations from central node, while</span> <span style="color:black;mso-themecolor:text1">HE647819 and <span style="background:white">HE647820 </span>were clustered into a separate single taxon at eightieth (80) mutations from central node.</span></span></p>', '20130211185003.pdf', '2013-02-05 00:00:00', 12, ''),
(5, 5, 'Test', '<p>Test Content</p>', '20130211180324.pdf', '2013-02-06 11:55:49', 1, '<p>test page for short descraptino.</p>'),
(7, 3, 'ajdlöfjalsd', '<div>A fetal goat cell line (ZZ-R 127) supplied by the Collection of Cell Lines in Veterinary Medicine of the</div>\r\n<div>Friedrich Loeffler Institute was examined for susceptibility to infection by foot-and-mouth disease (FMD) virus</div>\r\n<div>(FMDV) and by two other viruses causing clinically indistinguishable vesicular conditions, namely, the viruses</div>\r\n<div>of swine vesicular disease and vesicular stomatitis. Primary bovine thyroid (BTY) cells are generally the most</div>\r\n<div>sensitive cell culture system for FMDV detection but are problematic to produce, particularly for laboratories</div>\r\n<div>that infrequently perform FMD diagnostic tests and for those in countries where FMD is endemic that face</div>\r\n<div>problems in sourcing thyroid glands from FMD-negative calves. Strains representing all seven serotypes of</div>\r\n<div>FMDV could be isolated in ZZ-R 127 cells with a sensitivity that was considerably higher than that of</div>\r\n<div>established cell lines and within 0.5 log of that for BTY cells. The ZZ-R 127 cell line was found to be a sensitive,</div>\r\n<div>rapid, and convenient tool for the isolation of FMDV and a useful alternative to BTY cells for FMD diagnosis.</div>', '20130215193014.pdf', '2013-02-15 00:00:00', 12, ''),
(11, 0, 'Genomic and biological characterization of a velogenic Newcastle disease virus isolated from a healthy backyard poultry flock in 2010', '<p>Muhammad Munir, Muhammad Abbas, Muhammad Tanveer Khan, Siamak Zohari and Mikael Berg</p>\r\n<p>Issue 1, Volume 1, Pages 1-6</p>\r\n<h6><strong>Abstract</strong><br />\r\n<br />\r\nNewcastle disease virus (NDV) causes severe and economically important disease in poultry around the globe. None of NDV strains in Pakistan have been completely characterized and the role of rural poultry in harbouring NDV is unclear. Since they have a very important role for long-term circulation of the virus, samples were collected from apparently healthy backyard poultry (BYP) flocks. These samples were biologically analyzed using mean death time (MDT) and intracerebral pathogenicity index (ICPI), whereas genotypically characterized by the real-time PCRs coupled with sequencing of the complete genome. Despite of being non-pathogenic for BYP, the isolate exhibited MDT of 49.6 h in embryonated chicken eggs and an ICPI value of 1.5. The F gene based real-time PCR was positive, whereas M-gene based was negative due to substantial changes in the probe-binding site. The entire genome of the isolate was found to be 15192 nucleotides long and encodes for six genes with an order of 3&rsquo;-NP-P-M-F-HN-L-5&rsquo;. The F protein cleavage site, an indicative of pathogenicity, was 112RRQKRF117. Complete genome comparison indicated that the RNA dependent RNA polymerase gene was the most and the phosphoprotein was least conserved gene, among all the genes. The isolate showed an Y526Q substitution in the HN protein, which determines neuraminidase receptor binding and fusion activity of NDV. Phylogenetic analysis, based on F and HN genes, classified this isolate into genotype VII, a predominant genotype responsible for ND outbreaks in Asian countries. However, it clustered well apart from other isolates in this genotype to be considered a new subgenotype (VII-f). These results revealed that this isolate was similar to virulent strains of NDV and was avirulent in BYP either due to resistance of local breeds or due to other factors such as substantial mutations in the HN protein. Furthermore, we have characterized the first isolate of NDV, which could act as domestic reference strain and could help in development and selection of appropriate strain of NDV for vaccine in the country.<br />\r\n<br />\r\n<strong>Keywords:</strong> Newcastle disease, Rural poultry, DNA sequencing, Genome characterization, Pakistan</h6>', '20130219203521.pdf', '2013-02-19 00:00:00', 2, '<p>Muhammad Munir, Muhammad Abbas, Muhammad Tanveer Khan, Siamak Zohari and Mikael Berg</p>'),
(13, 0, 'Complete Genome Sequencing of a Velogenic Viscerotropic Avian Paramyxovirus 1 Isolated from Pheasants (Pucrasia macrolopha) in Lahore, Pakistan', '<p>Muhammad Zubair Shabbir<sup>a</sup> Mohsan Ullah Goraya<sup>b</sup> Muhammad Abbas<sup>c</sup> Tahir Yaqub<sup>,d </sup>Muhammad Abu Bakr Shabbir,<sup>a</sup> Arfan Ahmad<sup>,a</sup> Muhammad Anees,<sup>e</sup> and Muhammad Munir<sup>b</sup></p>\r\n<p>Issue 1, Volume 1, Pages 15-20</p>\r\n<p style="text-align: justify;"><br />\r\nUniversity Diagnostic Laboratory, University of Veterinary and Animal Sciences, Lahore, Pakistana; Department of Biomedical Sciences and Veterinary Public Health,<br />\r\nSwedish University of Agricultural Sciences (SLU), Uppsala, Swedenb; Quality Operations Laboratory, Veterinary Research Institute, Lahore, Pakistanc; Quality Operations<br />\r\nLaboratory, University of Veterinary and Animal Sciences, Lahore, Pakistand; and Livestock and Dairy Development Department, Punjab, Pakistan</p>\r\n<p style="text-align: justify;"><strong>Abstract</strong><br />\r\n<br />\r\nWe report the complete genome sequence of avian paramyxovirus 1 (APMV-1) isolated from an acute and highly contagious outbreak in pheasants (Pucrasia macrolopha) in Lahore, Pakistan. Biological and serological characterization showed a velogenic strain of APMV-1, which was further confirmed by the sequence analysis of the cleavage site in the fusion protein. Complete genome sequencing and phylogenetic analysis indicated that this isolate belonged to genotype VII, specifically to subgenotype VIIa, and clustered closely with isolates characterized from Indonesia. Notably, the isolate showed significant differences from previously characterized APMV-1 from Pakistani commercial and rural chicken.</p>\r\n<p style="text-align: justify;"><strong>Keywords:</strong> Pakistan, Genetic Analysis, Sequencing</p>', '20130219204638.pdf', '2013-02-19 00:00:00', 2, '<p>Muhammad Zubair Shabbir<sup>a</sup> Mohsan Ullah Goraya<sup>b</sup> Muhammad Abbas<sup>c</sup> Tahir Yaqub<sup>,d </sup>Muhammad Abu Bakr Shabbir,<sup>a</sup> Arfan Ahmad<sup>,a</sup> Muhammad Anees,<sup>e</sup></p>\r\n<p>&nbsp;</p>'),
(12, 0, 'Biological characterization and phylogenetic analysis of a novel genetic group of Newcastle disease virus isolated from outbreaks in commercial poultry and from backyard poultry flocks in Pakistan', '<p>&nbsp;</p>\r\n<p style="text-align: justify;"><br />\r\n<em><sup>a</sup>The Department of Biomedical Sciences and Veterinary Public Health, Swedish University of Agricultural Sciences (SLU), Ulls v&auml;g 2B, SE-751 89 Uppsala, Sweden<br />\r\n<sup>b</sup>Department of Virology, Immunobiology and Parasitology, National Veterinary Institute (SVA), Ulls v&auml;g 2B, SE-751 89 Uppsala, Sweden<br />\r\n<sup>c</sup>Quality Control Laboratory, Veterinary Research Institute, Lahore, Pakistan<br />\r\n<sup>d</sup>Disease Section, Poultry Research Institute, Rawalpindi, Pakistan<br />\r\n<sup>e</sup>University Diagnostic Laboratory, University of Veterinary and Animal Science, Lahore, Pakistan<br />\r\n<sup>f</sup>Department of Microbiology, Quaid-i-Azam University, Islamabad, Pakistan</em><br />\r\n&nbsp;</p>\r\n<p style="text-align: justify;"><strong>Abstract</strong></p>\r\n<p style="text-align: justify;"><br />\r\nNewcastle disease (ND) is a contagious viral disease of many avian species particularly domestic poultry, and is responsible for devastating outbreaks in the poultry industries around the globe. In spite of its importance and endemicity in Southern Asia, data on the genetic nature of the viruses and epizootiological information of the disease is scarce. In this study, six isolates from an emerging wave of ND outbreaks in the north of Pakistan and two isolates from healthy poultry flocks were biologically and genetically characterized. Based on pathogenicity indices such as intracerebral pathogenicity index (ICPI), mean death time (MDT) and cleavage motifs in the fusion protein, all these isolates were classified as virulent. Phylogenetic analysis of the fusion (F), hemagglutinin-neuraminidase (HN) and matrix (M) genes indicated the emergence of a novel genetic group within lineage 5, distinct from isolates previously reported in the region. Several mutations in the neutralizing epitopes and functionally important motifs of the F and HN genes pose a need for re-evaluation of the currently used vaccine and vaccination practices. The characteristics of Newcastle disease virus (NDV) as virulent (F protein cleavage site, ICPI and MDT) in apparently healthy backyard poultry (BYP) explain that BYP can play crucial role in the epizootiology and spread of the disease. The present investigation provides essential information on the genetic nature of NDV circulating in Pakistan and its implication on disease diagnosis and control. Furthermore, these investigations emphasize the importance of continuous surveillance of ND in developing countries.</p>\r\n<p style="text-align: justify;"><strong>Keywords:</strong> Newcastle disease, Pakistan, Poultry, Sequencing, Phylogenetic analysis</p>', '20130219204929.pdf', '2013-02-19 00:00:00', 2, '<p>jjkaldkf lkasdlfka al&ouml;sdkfl&ouml;aksd a&ouml;ldksfl&ouml;aks</p>\r\n<p>&nbsp;</p>'),
(14, 14, 'testing file', '<p>this is detai descraption whic is display in site.</p>', '20130221115805.pdf', '2013-02-21 00:00:00', 1, '<p>this is test short descraption..</p>');

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

--
-- Table structure for table `snf_testimonials`
--

CREATE TABLE IF NOT EXISTS `snf_testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `yourName` varchar(255) NOT NULL,
  `yourFeedback` varchar(255) NOT NULL,
  `entryDate` datetime NOT NULL,
  `status` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `snf_updates`
--

CREATE TABLE IF NOT EXISTS `snf_updates` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `page_title` varchar(255) DEFAULT NULL,
  `page_heading` varchar(250) NOT NULL,
  `page_seo` varchar(255) NOT NULL,
  `page_subheading` varchar(250) NOT NULL,
  `meta_keyword` longtext,
  `meta_phrase` longtext,
  `meta_description` longtext,
  `page_type` varchar(50) DEFAULT NULL,
  `entry_by` int(11) NOT NULL,
  `entry_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `modified_by` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `type` varchar(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbl_p2p_pagecontent_fk_1` (`entry_by`),
  KEY `tbl_p2p_pagecontent_fk_2` (`modified_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `snf_updates`
--

INSERT INTO `snf_updates` (`id`, `page_title`, `page_heading`, `page_seo`, `page_subheading`, `meta_keyword`, `meta_phrase`, `meta_description`, `page_type`, `entry_by`, `entry_date`, `modified_date`, `modified_by`, `link_id`, `type`) VALUES
(2, 'Natural Pest Control Protein Effective Against Hookworm: A Billion Could Benefit', 'Natural Pest Control Protein Effective Against Hookworm: A Billion Could Benefit', 'natural-pest-control-protein-effective-against-hookworm', '', 'Natural Pest Control Protein Effective Against Hookworm: A Billion Could Benefit', 'Natural Pest Control Protein Effective Against Hookworm: A Billion Could Benefit', '<p><b>WASHINGTON, DC &ndash; July 23, 2013 -- </b>A benign crystal protein,  produced naturally by bacteria and used as an organic pesticide, could  be a safe, inexpensive treatment for parasitic worms in humans and  provide effective relief to over a billion people around the world.  Researchers from the University of California, San Diego, La Jolla, CA,  report on this potentially promising solution in a study published ahead  of print in the journal <i>Applied and Environmental Microbiology.</i></p>\r\n<p>Hookworms, and other intestinal parasites known as helminths infect  more than 1 billion people in poverty-stricken, tropical nations,  sucking the vitality from the body, and leaving hundreds of millions of  children physically and mentally stunted. Current drugs are  insufficiently effective, and resistance is rising, but little effort  has been made to develop better drugs because the relevant populations  do not represent a profitable market for drug companies.</p>\r\n<p>&ldquo;The challenge is that any cure must be <i>very</i> cheap, it must  have the ability to be mass produced in tremendous quantities, safe, and  able to withstand rough conditions, including lack of refrigeration,  extreme heat, and remote locations,&rdquo; says Raffi Aroian, a researcher on  the study.</p>\r\n<p>In earlier research, Aroian and his collaborators described a  protein, Cry5B, that can kill intestinal nematode parasites&mdash;such as  human hookworms&mdash;in infected test animals (hamsters). Cry5B belongs to a  family of proteins that are generally accepted as safe for humans. These  proteins are produced naturally in <i>Bacillus thuringiensis</i> (Bt), a  bacterium which is applied to crops as a natural insecticide on some  organic farms, and CryB proteins have been engineered into food crops  such as corn and rice, to render them pest resistant.</p>\r\n<p>As shown for the first time in this paper, Cry5B can also be expressed in a species of bacterium, <i>Bacillus subtilis</i>, which is closely related to <i>Bacillus thuringiensis</i>,  and which is also related to bacteria which are present in some  probiotics, says Aroian. In the current research researchers showed that  a small dose of Cry5B, expressed in this bacterium can achieve a 93  percent elimination of hookworm parasites from infected hamsters. That,  says Aroian, is substantially better than current drugs.</p>\r\n<p>The scientific significance of the research, he says, is that  &ldquo;bacteria similar to those that are food grade&mdash;which are cheap and can  readily be mass produced--can be engineered to produce molecules that  can cure parasitic diseases.&rdquo;</p>\r\n<p>Aroian notes that both the Bill and Melinda Gates Foundation, and the  American taxpayer, via the National Institutes of Health, played an  essential role in funding the research.</p>\r\n<p>A copy of the manuscript can be found online at <a href="http://bit.ly/asmtip0713a">http://bit.ly/asmtip0713a</a>.&nbsp;&nbsp;The paper is scheduled to be formally published in the September, 2013 issue of <i>Applied and Environmental Microbiology.</i></p>', '', 1, '2013-07-24 07:51:59', '2013-07-24 07:51:59', 1, 0, ''),
(3, 'H7N9 Influenza Strain Resistant to Antivirals, But Tests Fail to Identify Resistance ', 'H7N9 Influenza Strain Resistant to Antivirals, But Tests Fail to Identify Resistance ', 'influenza-strain-resistant-to-antivirals-but-tests-fail-to-identify-resistance', '', 'H7N9 Influenza Strain Resistant to Antivirals, But Tests Fail to Identify Resistance ', 'H7N9 Influenza Strain Resistant to Antivirals, But Tests Fail to Identify Resistance ', '<p>WASHINGTON, DC &ndash; July 16, 2013 &ndash; Some strains of the avian H7N9 influenza that emerged in China this year have developed resistance to the only antiviral drugs available to treat the infection, but testing for antiviral resistance can give misleading results, helping hasten the spread of resistant strains.</p>\r\n<p>The authors of a study published in mBio&reg;, the online open-access journal of the American Society for Microbiology, characterized viruses taken from the first person known to be stricken with H7N9 influenza and found that 35% of those viruses are resistant to oseltamivir (commercially known as Tamiflu) and zanamivir (Relenza), front line drugs used for treating H7N9 infections. However, lab testing of the viruses, which detects the activity of a viral enzyme, fails to detect that these strains are resistant, so monitoring for the development of resistance using this technique would prove futile.</p>\r\n<p>&quot;If H7N9 does acquire human-to-human transmissibility, what do we have to treat it with until we have a vaccine? Oseltamivir.  We would be in big trouble,&rdquo; says corresponding author Robert Webster of St. Jude Children&rsquo;s Research Hospital in Memphis, Tennessee.  Resistant strains of H7N9 can flourish in patients treated with oseltamivir or zanamivir, he says, inadvertently leading to the spread of resistant infections.</p>\r\n<p>In the mBio study, the authors tested antiviral susceptibility of an H7N9 strain isolated from the first confirmed human case of avian H7N9 influenza using a method that tests the activity of the neuraminidase enzyme. The reassuring results were, unfortunately, misleading: the enzyme-based test indicated that the flu strain was susceptible to NA inhibiting antiviral drugs, but it is not.</p>\r\n<p>A closer look at the viral isolate revealed it is actually made up of two distinct types of H7N9 viruses. Roughly 35% of the viruses carried a mutation known as R292K, making them resistant to NA inhibitors, while 65% were sensitive to these same drugs. The enzyme-based testing gave misleading results, says Webster, because the functioning wild-type enzymes masked the presence of the non-functioning mutant enzymes.</p>\r\n<p>Using NA inhibitors to treat a patient infected with a resistant strain of H7N9 only encourages the virus to proliferate and can lead to enhanced spread of the resistant strain. The authors write that these results prove that it is crucial to use a gene-based surveillance technique that can detect these resistant influenza strains in a mixed infection.</p>\r\n<p>H7N9 first emerged in China in early 2013, in some cases infecting individuals who had been in contact with poultry or with places where poultry are housed. The virus has since been detected in poultry at live markets near where human infections have been reported. After the closure of many live poultry markets in China and with the start of the warm season, which is not conducive to influenza spread, the infection rate appears to have slowed. As of July 12, the number of infections stands at 132 and the number of deaths at 43.</p>\r\n<p>If the recent history of H5N1 influenza is a guide, says Webster, then H7N9 could rapidly evolve the ability to spread from person to person. If it does, and if the virus reemerges in the fall, the situation with H7N9 could become quite serious. In the event of a widespread outbreak, Tamiflu and Relenza will work alright as treatments, but the development of the R292K mutation puts those options in jeopardy, says Webster.</p>\r\n<p>But the news isn''t all bad. Webster also points out that antiviral resistance is something of a burden for influenza viruses, and that fitter wild-type H7N9 strains may eventually win out over resistant strains. In the absence of a drug like Tamiflu, Webster says, it seems unlikely that these resistant viruses would acquire epidemic characteristics.</p>\r\n<p>Regardless of the specific evolutionary steps H7N9 will take, influenza is an ongoing threat - and the lack of suitable drugs is a grave cause for concern.</p>', '', 1, '2013-07-24 07:55:37', '2013-07-24 07:57:32', 1, 0, '');

