# phpMyAdmin SQL Dump # version 2.5.5-rc2 # http://www.phpmyadmin.net # # Host: localhost # Generation Time: Feb 06, 2005 at 03:17 AM # Server version: 3.23.32 # PHP Version: 4.3.10 # # Database : `cnrss` # # -------------------------------------------------------- # # Table structure for table `cnrss3_newscategories` # # Creation: Jan 31, 2005 at 02:24 PM # Last update: Jan 31, 2005 at 02:39 PM # CAUTION: DROP TABLE IF EXISTS `cnrss3_newscategories`; CREATE TABLE `cnrss3_newscategories` ( `id` mediumint(9) unsigned NOT NULL auto_increment, `category` varchar(80) default NULL, `description` mediumtext, `public` enum('yes','no') NOT NULL default 'yes', `lastupdate` timestamp(14) NOT NULL, PRIMARY KEY (`id`) ) # # Dumping data for table `cnrss3_newscategories` # INSERT INTO `cnrss3_newscategories` (`id`, `category`, `description`, `public`, `lastupdate`) VALUES (1, 'Test', NULL, 'yes', 20050119215446), (2, 'Business', NULL, 'yes', 20050121180831), (3, 'U.S.', NULL, 'yes', 20050121180858), (4, 'International', NULL, 'yes', 20050121180911), (5, 'Politics', NULL, 'yes', 20050121180942), (6, 'Entertainment', NULL, 'yes', 20050121180958), (7, 'Sports', NULL, 'yes', 20050121181016), (17, 'Technology and Science', NULL, 'yes', 20050122020334), (9, 'Health', NULL, 'yes', 20050121181059), (10, 'Oddly Enough', NULL, 'yes', 20050121181121), (16, 'Life and Leisure', NULL, 'yes', 20050122020158), (12, 'The Newsroom', NULL, 'yes', 20050121181158), (13, 'Weather', NULL, 'yes', 20050121181212), (14, 'Television', NULL, 'yes', 20050121181246), (15, 'Pictures', NULL, 'yes', 20050121181356) # -------------------------------------------------------- # # Table structure for table `cnrss3_newsitems` # # Creation: Jan 31, 2005 at 02:24 PM # Last update: Feb 06, 2005 at 03:00 AM # CAUTION: DROP TABLE IF EXISTS `cnrss3_newsitems`; CREATE TABLE `cnrss3_newsitems` ( `id` int(10) NOT NULL auto_increment, `fkid` int(10) default NULL, `salutation` varchar(80) default NULL, `contact` varchar(80) default NULL, `organization` varchar(80) default NULL, `area` varchar(80) default NULL, `email` varchar(120) default NULL, `phone` varchar(20) default NULL, `fax` varchar(20) default NULL, `address` varchar(80) default NULL, `address2` varchar(80) default NULL, `city` varchar(35) default NULL, `stateprov` varchar(25) default NULL, `country` varchar(40) default NULL, `postalcode` varchar(20) default NULL, `url` varchar(255) default NULL, `description` mediumtext, `image` varchar(120) default NULL, `title` varchar(80) default NULL, `express` enum('on','off') default 'off', `category` varchar(80) NOT NULL default 'General', `approved` enum('yes','no') NOT NULL default 'yes', `received` date default NULL, `lastupdate` timestamp(14) NOT NULL, PRIMARY KEY (`id`) ) # # Dumping data for table `cnrss3_newsitems` # INSERT INTO `cnrss3_newsitems` (`id`, `fkid`, `salutation`, `contact`, `organization`, `area`, `email`, `phone`, `fax`, `address`, `address2`, `city`, `stateprov`, `country`, `postalcode`, `url`, `description`, `image`, `title`, `express`, `category`, `approved`, `received`, `lastupdate`) VALUES (24, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '24.jpg', 'Technology and Science', 'off', 'Technology and Science', 'yes', '2005-01-22', 20050206013124), (25, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '25.jpg', 'Television', 'off', 'Television', 'yes', '2005-01-22', 20050206013124), (26, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '26.gif', 'The Newsroom', 'off', 'The Newsroom', 'yes', '2005-01-22', 20050206013124), (27, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '27.jpg', 'U.S.', 'off', 'U.S.', 'yes', '2005-01-22', 20050206013124), (28, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '28.jpg', 'Weather', 'off', 'Weather', 'yes', '2005-01-22', 20050206013124), (20, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '20.jpg', 'Oddly Enough', 'off', 'Oddly Enough', 'yes', '2005-01-22', 20050206013124), (21, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '21.jpg', 'Pictures', 'off', 'Pictures', 'yes', '2005-01-22', 20050206013124), (22, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '22.jpg', 'Politics', 'off', 'Politics', 'yes', '2005-01-22', 20050206013124), (23, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '23.jpg', 'Sports', 'off', 'Sports', 'yes', '2005-01-22', 20050206031001), (15, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '15.jpg', 'Health', 'off', 'Health', 'yes', '2005-01-22', 20050206013124), (16, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', 'Innovation - The web is constantly evolving and so are our services. Check out our websites, let us know what you need. We do custom work, ask us. We offer free estimates for any project on request.', '16.jpg', 'Business', 'off', 'Business', 'yes', '2005-01-22', 20050206030515), (17, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', ' ', '17.jpg', 'Entertainment', 'off', 'Entertainment', 'yes', '2005-01-22', 20050206030939), (18, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '18.jpg', 'International', 'off', 'International', 'yes', '2005-01-22', 20050206013124), (19, NULL, NULL, NULL, 'Global I.S. S.A.', NULL, 'info@globalissa.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'http://www.globalissa.com', '', '19.jpg', 'Life and Leisure', 'off', 'Life and Leisure', 'yes', '2005-01-22', 20050206013124)