-- MySQL dump 10.13  Distrib 5.1.42, for mandriva-linux-gnu (x86_64)
--
-- Host: localhost    Database: website
-- ------------------------------------------------------
-- Server version	5.1.42

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `pics_archiveitems`
--

DROP TABLE IF EXISTS `pics_archiveitems`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pics_archiveitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `year` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `source` varchar(90) COLLATE utf8_unicode_ci NOT NULL,
  `date_created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pics_archiveitems`
--

LOCK TABLES `pics_archiveitems` WRITE;
/*!40000 ALTER TABLE `pics_archiveitems` DISABLE KEYS */;
INSERT INTO `pics_archiveitems` VALUES (1,'commodore_computing_int_1982-06_001','Commodore','1982-06-00','technical','Commodore Computing International','2012-07-01 00:00:00'),(2,'comm_000','Commodore','1975-11-13','consumer','New Scientist','2012-07-01 00:00:00'),(3,'comm_001-a','Commodore','1982-11-17','consumer','Just Seventeen','2012-07-01 00:00:00'),(4,'comm_001','Commodore','1976-10-28','consumer','New Scientist','2012-07-01 00:00:00'),(5,'comm_002-a,comm_003-a','Commodore','1983-06-00','technical','Practical Computing','2012-07-01 00:00:00'),(6,'comm_002','Commodore','1982-00-00','technical','unknown','2012-07-01 00:00:00'),(7,'comm_003','Commodore','1982-00-00','consumer','Sunday Times','2012-07-01 00:00:00'),(8,'comm_004-a','Acorn','1983-06-00','technical','Practical Computing','2012-07-01 00:00:00'),(9,'comm_004','Commodore','1982-00-00','consumer','Sunday Times','2012-07-01 00:00:00'),(10,'comm_005-a,comm_006-a','Commodore','1981-09-01','channel','','2012-07-01 00:00:00'),(11,'comm_006','Commodore','1987-02-00','consumer','Sunday Times','2012-07-01 00:00:00'),(12,'comm_007','Commodore','1979-10-07','consumer','Sunday Times','2012-07-01 00:00:00'),(13,'comm_008-acorn','Acorn','1983-00-00','channel','','2012-07-01 00:00:00'),(14,'comm_008-calc','Commodore','1974-00-00','consumer','unknown','2012-07-01 00:00:00'),(15,'comm_009','Commodore','1981-12-00','consumer','unknown','2012-07-01 00:00:00'),(16,'comm_010','Commodore','1981-00-00','consumer','unknown','2012-07-01 00:00:00'),(17,'comm_011','Commodore','1985-00-00','consumer','Sunday Times','2012-07-01 00:00:00'),(18,'comm_012','Commodore','1978-00-00','channel','unknown','2012-07-01 00:00:00'),(19,'comm_013','MITS Altair','1976-12-00','technical','Popular Electronics','2012-07-01 00:00:00'),(20,'comm_014','MITS Altair','1976-12-00','technical','Popular Electronics','2012-07-01 00:00:00'),(21,'comm_015','IMSAI','1976-12-00','technical','Popular Electronics','2012-07-01 00:00:00'),(22,'comm_016','Commodore','1979-05-00','technical','Personal Computer World','2012-07-01 00:00:00'),(23,'adve_000','Micronix','1983-06-00','technical','Practical Computing','2012-07-01 00:00:00'),(24,'adve_001','Commodore','1980-01-00','technical','CPUCN - Commodore PET Users\' Club Newsletter, Vol 2 Issue 4','2012-07-01 00:00:00'),(25,'adve_002','Research Machines','1980-10-00','technical','Personal Computer World','2012-07-01 00:00:00'),(26,'adve_003','Tandy/Radio Shack','1979-08-00','technical','Personal Computer World','2012-07-01 00:00:00'),(27,'adve_004','Apple','1979-08-00','technical','Personal Computer World','2012-07-01 00:00:00'),(28,'adve_005','Cromemco','1979-08-00','technical','Personal Computer World','2012-07-01 00:00:00'),(29,'adve_006','Transam','1980-10-00','technical','Personal Computer World','2012-07-01 00:00:00'),(30,'adve_007,adve_008','Sinclair','1980-10-00','technical','Personal Computer World','2012-07-01 00:00:00'),(31,'adve_009','Intel','1977-11-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(32,'adve_010','Tandy/Radio Shack','1977-11-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(33,'adve_012,adve_011','Apple','1977-11-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(34,'adve_013','North Star Computers','1977-11-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(35,'adve_014','Cromemco','1977-01-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(36,'adve_016','IMSAI','1977-01-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(37,'adve_017','Compucolor Corporation','1977-07-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(38,'adve_018,adve_019','Commodore','1983-06-00','technical','Commodore Computing International','2012-07-01 00:00:00'),(39,'adve_020','Tandy/Radio Shack','1983-08-18','technical','Personal Computer News','2012-07-01 00:00:00'),(40,'adve_021,adve_022','Mattel','1983-08-18','technical','Personal Computer News','2012-07-01 00:00:00'),(41,'adve_023','Oric','1983-08-18','technical','Personal Computer News','2012-07-01 00:00:00'),(42,'adve_024','Acorn','1981-03-00','technical','Practical Computing','2012-07-01 00:00:00'),(43,'adve_026,adve_025','Sinclair','1981-03-00','technical','Practical Computing','2012-07-01 00:00:00'),(44,'adve_027','Hewlett-Packard','1981-03-00','technical','Practical Computing','2012-07-01 00:00:00'),(45,'adve_028','Commodore','1981-03-00','technical','Practical Computing','2012-07-01 00:00:00'),(46,'adve_029','Commodore','1981-03-00','technical','Practical Computing','2012-07-01 00:00:00'),(47,'adve_030','Hewlett-Packard','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(48,'adve_031','Lucas','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(49,'adve_032','Transam','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(50,'adve_033','Commodore','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(51,'adve_034','Sharp','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(52,'adve_035','Apple','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(53,'adve_036','DAI','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(54,'adve_039,adve_037,adve_038','Sinclair','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(55,'adve_040,adve_041','LSI','1982-02-00','technical','Personal Computer World','2012-07-01 00:00:00'),(56,'adve_042','Texas Instruments','1982-07-00','technical','Personal Computer World','2012-07-01 00:00:00'),(57,'adve_043','Transam','1982-07-00','technical','Personal Computer World','2012-07-01 00:00:00'),(58,'adve_045','IBM','1982-07-00','technical','Personal Computer World','2012-07-01 00:00:00'),(59,'adve_046','DAI','1982-07-00','technical','Personal Computer World','2012-07-01 00:00:00'),(60,'adve_047','Atari','1982-07-00','technical','Personal Computer World','2012-07-01 00:00:00'),(61,'adve_048,adve_049','Sinclair','1982-07-00','technical','Personal Computer World','2012-07-01 00:00:00'),(62,'adve_050','Ithaca','1981-06-00','technical','Personal Computer World','2012-07-01 00:00:00'),(63,'adve_051,adve_052,adve_053,adve_054','Commodore','1984-11-00','channel','','2012-07-01 00:00:00'),(64,'adve_055,adve_056,adve_057,adve_058,adve_059','Commodore','1982-01-00','channel','unknown','2012-07-01 00:00:00'),(65,'adve_060','Tatung','1984-09-00','technical','The Micro User','2012-07-01 00:00:00'),(66,'adve_061,adve_062','Acorn','1984-09-00','technical','The Micro User','2012-07-01 00:00:00'),(67,'adve_063','Torch','1984-09-00','technical','The Micro User','2012-07-01 00:00:00'),(68,'adve_065,adve_066','Acorn','1984-09-00','technical','The Micro User','2012-07-01 00:00:00'),(69,'adve_067','Acorn','1984-09-00','technical','The Micro User','2012-07-01 00:00:00'),(70,'adve_068,adve_069','Commodore','1984-11-00','technical','Commodore Computing International','2012-07-01 00:00:00'),(71,'adve_070','Sinclair','1984-00-00','technical','The Home Computer Course','2012-07-01 00:00:00'),(72,'adve_071','Acorn','1980-03-00','technical','Computing Today','2012-07-01 00:00:00'),(73,'adve_072,adve_073','Commodore','1984-03-00','technical','Commodore Computing International','2012-07-01 00:00:00'),(74,'adve_074','Tandy/Radio Shack','1978-10-00','technical','Personal Compuer World','2012-07-01 00:00:00'),(75,'adve_075','Sinclair','1978-09-00','technical','Personal Compuer World','2012-07-01 00:00:00'),(76,'adve_076','Sinclair','1978-06-00','technical','Electronics Today','2012-07-01 00:00:00'),(77,'adve_077','Nascom','1978-06-00','technical','Electronics Today','2012-07-01 00:00:00'),(78,'adve_078','Sinclair','1978-06-00','technical','Electronics Today','2012-07-01 00:00:00'),(79,'adve_079','SWTPC','1977-11-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(80,'adve_080','Research Machines','1979-05-00','technical','Personal Computer World','2012-07-01 00:00:00'),(81,'adve_081','Heathkit','1978-04-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(82,'adve_082','IMSAI','1978-02-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(83,'adve_083','SWTPC','1978-01-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(84,'adve_084','Compuserve','1984-08-00','technical','Compute\'s Gazette','2012-07-01 00:00:00'),(85,'adve_085','Commodore','1985-12-00','technical','Commodore Computing International','2012-07-01 00:00:00'),(86,'adve_086','Commodore','1984-11-00','technical','Compute\'s Gazette','2012-07-01 00:00:00'),(87,'adve_087,adve_088','Commodore','1985-12-00','technical','Commodore Computing International','2012-07-01 00:00:00'),(88,'adve_089','Commodore','1985-12-00','technical','Commodore User','2012-07-01 00:00:00'),(89,'adve_090,adve_091','Commodore','1985-12-00','technical','Commodore User','2012-07-01 00:00:00'),(90,'adve_092','Seiko','1985-10-00','technical','Commodore User','2012-07-01 00:00:00'),(91,'ads_000','Commodore','1983-08-00','technical','Creative Computing','2012-07-01 00:00:00'),(92,'ads_002','Atari','1978-11-16','consumer','Country Life','2012-07-01 00:00:00'),(93,'ads_003','Elliott','1962-07-04','consumer','Punch','2012-07-01 00:00:00'),(94,'ads_004','Sinclair','1981-08-00','technical','Unknown','2012-07-01 00:00:00'),(95,'ads_005,ads_006','Spectravideo','1983-08-00','technical','Creative Computing','2012-07-01 00:00:00'),(96,'ads_007','Apple','1981-00-00','consumer','Sunday Telegraph','2012-07-01 00:00:00'),(97,'ads_008','Sinclair','1981-09-00','consumer','Sunday Telegraph','2012-07-01 00:00:00'),(98,'ads_009','Hewlett-Packard','1983-00-00','technical','US Magazine','2012-07-01 00:00:00'),(99,'ads_010','NCR','1962-00-00','technical','Creative Computing','2012-07-01 00:00:00'),(100,'ads_011','Sinclair','1981-08-00','technical','Creative Computing','2012-07-01 00:00:00'),(101,'ads_012,ads_013','Dragon Data','1983-00-00','technical','Creative Computing','2012-07-01 00:00:00'),(102,'ads_014','Commodore','1983-03-00','technical','Creative Computing','2012-07-01 00:00:00'),(103,'ads_015','Bendix','1962-00-00','technical','Unknown','2012-07-01 00:00:00'),(104,'ads_016,ads_017','Commodore','1984-07-00','consumer','Business Magazine','2012-07-01 00:00:00'),(105,'ads_018','IBM','1964-11-18','consumer','Punch','2012-07-01 00:00:00'),(106,'ads_019,ads_020','Apple','1983-01-00','technical','Creative Computing','2012-07-01 00:00:00'),(107,'ads_021','MITS Altair','1977-05-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(108,'ads_022','Tandy/Radio Shack','1983-06-00','technical','Personal Computer World','2012-07-01 00:00:00'),(109,'ads_023','Jupiter Cantab','1983-05-00','technical','Practical Computing','2012-07-01 00:00:00'),(110,'ads_024,ads_025,ads_026','Sinclair','1983-03-00','technical','Personal Computer World','2012-07-01 00:00:00'),(111,'ads_027','Shugart','1978-12-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(112,'ads_028','Processor Technology','1978-12-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(113,'ads_029,ads_030','Apple','1978-12-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(114,'ads_031','PerSci','1978-12-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(115,'ads_032','Smoke Signal','1978-12-00','technical','Byte - The Small Systems Journal','2012-07-01 00:00:00'),(116,'ads_033','Sharp','1980-10-00','technical','Personal Computer World','2012-07-01 00:00:00'),(117,'ads_038,ads_034,ads_035','ACT/Victor','1982-03-00','technical','Personal Computer World','2012-07-01 00:00:00'),(118,'ads_036,ads_037','Acorn','1986-11-00','technical','The Micro User','2012-07-01 00:00:00'),(119,'ns','North Star Computers','1982-07-00','technical','Personal Computer World','2012-07-01 00:00:00'),(120,'phot_000','Novation','1980-02-00','technical','Creative Computing','2012-07-01 00:00:00'),(121,'phot_001','Digital','1983-06-00','technical','Unknown','2012-07-01 00:00:00'),(122,'phot_002','Franklin','1982-08-00','technical','Creative Computing','2012-07-01 00:00:00'),(123,'ad3_000,ad3_001','Commodore','1981-09-00','technical','Computing Today','2012-07-01 00:00:00'),(124,'ad3_002','Commodore','1981-09-00','technical','Computing Today','2012-07-01 00:00:00'),(125,'ad3_003','Pearcom','1981-09-00','technical','Computing Today','2012-07-01 00:00:00'),(126,'ad3_004','Video Genie','1981-09-00','technical','Computing Today','2012-07-01 00:00:00'),(127,'ad3_005','Tangerine','1981-03-00','technical','Computing Today','2012-07-01 00:00:00'),(128,'ad4_001','Epson','1983-05-00','technical','Computing Today','2012-07-01 00:00:00'),(129,'ad4_002','Zenith Data Systems','1983-05-00','technical','Practical Computing','2012-07-01 00:00:00'),(130,'atari_001a,atari_001b','Atari','1981-02-10','technical','Omni','2012-07-01 00:00:00'),(131,'shatner_001','Commodore','1982-00-00','technical','Unknown','2012-07-01 00:00:00'),(132,'atari_002','Atari','1979-00-00','technical','Omni','2012-07-01 00:00:00'),(133,'az_personal_computers_1984-10_001','C/WP-Cortex','1984-10-00','consumer','A-Z of Personal Computers','2012-07-01 00:00:00'),(134,'computing_today_1981-03','Commodore','1981-03-00','technical','Computing Today','2012-07-01 00:00:00'),(135,'az_personal_computers_1984-10_004','Toshiba','1984-10-00','technical','A-Z of Personal Computers','2012-07-01 00:00:00'),(136,'practical_computing_1983-11_001','Computer Facilities','1983-11-00','technical','Practical Computing','2012-07-01 00:00:00'),(137,'acorn_1982-09_001a,acorn_1982-09_001c','Acorn','1982-09-00','sales','Sales Literature','2012-07-01 00:00:00'),(138,'practical_computing_1983-08_002','Epson','1983-08-00','technical','Practical Computing','2012-07-01 00:00:00'),(140,'atari_2600_1982-06_001a,atari_2600_1982-06_001b,atari_2600_1982-06_001c,atari_2600_1982-06_001d','Atari','1982-06-00','sales channel','Sales Brochure','2012-07-01 00:00:00'),(141,'practical_computing_1983-08_001','Qume','1983-08-00','technical','Practical Computing','2012-07-01 00:00:00');
/*!40000 ALTER TABLE `pics_archiveitems` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-11-22 23:11:07
