-- MySQL dump 10.13  Distrib 5.5.34, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: ariaboard
-- ------------------------------------------------------
-- Server version	5.5.34-0ubuntu0.13.04.1

/*!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 `contacts`
--

DROP TABLE IF EXISTS `contacts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contacts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contacts`
--

LOCK TABLES `contacts` WRITE;
/*!40000 ALTER TABLE `contacts` DISABLE KEYS */;
INSERT INTO `contacts` VALUES (1,'','','','183.3.25.50','2013-09-14 07:39:47','2013-09-14 07:39:47'),(2,'','','','183.3.25.50','2013-09-14 07:39:50','2013-09-14 07:39:50'),(3,'','','','183.3.25.50','2013-09-16 08:15:13','2013-09-16 08:15:13'),(4,'test','test','test','101.80.70.167','2013-11-06 01:53:08','2013-11-06 01:53:08'),(5,'','','','50.116.13.25','2013-11-06 08:17:01','2013-11-06 08:17:01'),(6,'test','test','test','101.80.70.167','2013-11-08 06:01:16','2013-11-08 06:01:16'),(7,'','','','121.32.106.76','2013-11-10 08:22:24','2013-11-10 08:22:24'),(8,'','','','121.32.106.76','2013-11-10 08:22:31','2013-11-10 08:22:31'),(9,'','','','121.32.106.76','2013-11-10 08:22:44','2013-11-10 08:22:44'),(10,'','','','121.32.106.76','2013-11-10 08:22:45','2013-11-10 08:22:45'),(11,'','','','121.32.106.76','2013-11-10 08:22:48','2013-11-10 08:22:48'),(12,'','','','121.32.106.76','2013-11-10 08:22:49','2013-11-10 08:22:49'),(13,'','','','121.32.106.76','2013-11-10 08:22:51','2013-11-10 08:22:51'),(14,'','','','121.32.106.76','2013-11-10 08:22:52','2013-11-10 08:22:52'),(15,'','','','121.32.106.76','2013-11-10 08:22:55','2013-11-10 08:22:55'),(16,'','','','121.32.106.76','2013-11-10 08:22:59','2013-11-10 08:22:59'),(17,'','','','121.32.106.76','2013-11-10 08:23:02','2013-11-10 08:23:02'),(18,'','','','121.32.106.76','2013-11-10 08:23:02','2013-11-10 08:23:02'),(19,'','','','121.32.106.76','2013-11-10 08:23:06','2013-11-10 08:23:06'),(20,'','','','121.32.106.76','2013-11-10 08:23:12','2013-11-10 08:23:12'),(21,'','','','61.144.33.210','2013-12-03 05:42:47','2013-12-03 05:42:47'),(22,'Dale','dale@edenworth.com','Please advise cost for 1-10 samples of SOM and 1-5 development boards.','118.209.127.156','2014-04-01 07:25:50','2014-04-01 07:25:50'),(23,'Bogdan Teodorescu','bogdan.teodorescu@quartzmatrix.ro','Price and delivery condition for Aria Board in Romania','89.44.144.100','2014-04-08 08:20:37','2014-04-08 08:20:37'),(24,'Bogdan Teodorescu','bogdan.teodorescu@quartzmatrix.ro','Price and delivery condition for Aria Board in Romania','89.44.144.100','2014-04-08 08:21:25','2014-04-08 08:21:25'),(25,'','','','61.144.71.116','2014-05-15 14:04:47','2014-05-15 14:04:47'),(26,'','','','101.80.70.177','2014-07-08 10:36:50','2014-07-08 10:36:50');
/*!40000 ALTER TABLE `contacts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `downloads`
--

DROP TABLE IF EXISTS `downloads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `downloads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remote_download_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_des` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file_size` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `resource_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `downloads`
--

LOCK TABLES `downloads` WRITE;
/*!40000 ALTER TABLE `downloads` DISABLE KEYS */;
INSERT INTO `downloads` VALUES (2,'Aria Board Technical Reference Manual (Rev. I)  .pdf','Ariaboard Docs','/www/sources/Aria Board Technical Reference Manual (Rev. I)  .pdf','','Aria Coreboard 硬件设计参考手册(Rev . I)\r\n','429K','2013-10-29 10:58:05','2013-11-05 04:25:18',''),(3,'Aria Extboard A6.pdf','Ariaboard Docs','/www/sources/Aria Extboard A6.pdf','','Aria Ext Board A6 Sch pdf','762K','2013-11-04 07:07:04','2013-11-05 04:25:28',''),(4,'Aria Extboard A6 Sch&PCB.zip','Ariaboard Docs','/www/sources/Aria Extboard A6 Sch&PCB.zip','','Aria Ext Board A6 Sch and PCB(使用Altium Designer 6.0以上版本打开)','336K','2013-11-04 07:17:18','2013-11-05 04:25:38',''),(5,'armhf-rootfs-201211291926.tar.7z','Filesystem','','http://dl.ariaboard.com/armhf-rootfs-201211291926.tar.7z','Ubuntu 12.04 Filesystem 7zip','114.2M','2013-11-04 07:34:38','2013-11-05 04:24:26',''),(6,'PinMuxUtility_02_05_02_00.zip','Ti Tools','','http://dl.ariaboard.com/PinMuxUtility_02_05_02_00.zip','Ti Pinmux Utility','582.9K','2013-11-04 07:43:27','2013-11-05 04:24:42',''),(7,'gcc-linaro-arm-linux-gnueabihf-4.7-2013.04-20130415_linux.tar.xz','Toolchain','','http://dl.ariaboard.com/gcc-linaro-arm-linux-gnueabihf-4.7-2013.04-20130415_linux.tar.xz','Linaro cross compiler armhf binaries 4.7 2013.04','37.9M','2013-11-04 07:44:53','2013-11-05 04:24:09',''),(8,'gcc-linaro-arm-linux-gnueabihf-4.8-2013.08_linux.tar.xz','Toolchain','','http://dl.ariaboard.com/gcc-linaro-arm-linux-gnueabihf-4.8-2013.08_linux.tar.xz','Linaro cross compiler armhf binaries 4.8 2013.08','48.5M','2013-11-04 07:46:12','2013-11-05 04:23:17',''),(9,'ti-sdk-am335x-evm-06.00.00.00-Linux-x86-Install','Ti Tools','','http://dl.ariaboard.com/ti-sdk-am335x-evm-06.00.00.00-Linux-x86-Install','Ti Official AM335x SDK ','1.1G','2013-11-04 07:46:50','2013-11-05 04:23:49',''),(12,'Aria_Kernel','Linux Kernel & U-boot','','https://github.com/c2h2/aria-psp-kernel','Aria Linux Kernel','','2013-11-05 05:11:40','2013-11-05 05:12:54',''),(13,'Aria_Uboot','Linux Kernel & U-boot','','https://github.com/c2h2/aria-uboot','Aria Uboot','','2013-11-05 05:16:12','2013-11-05 05:16:12',''),(14,'静电测试-接触放电-正压-8KV.mp4','Videos','','http://dl.ariaboard.com/%e9%9d%99%e7%94%b5%e6%b5%8b%e8%af%95-%e6%8e%a5%e8%a7%a6%e6%94%be%e7%94%b5-%e6%ad%a3%e5%8e%8b-8KV.mp4','ESD +8KV video','','2013-11-05 06:26:44','2013-11-05 06:26:44',''),(15,'静电测试-接触放电-负压-8KV.mp4','Videos','','http://dl.ariaboard.com/%e9%9d%99%e7%94%b5%e6%b5%8b%e8%af%95-%e6%8e%a5%e8%a7%a6%e6%94%be%e7%94%b5-%e8%b4%9f%e5%8e%8b-8KV.mp4','ESD -8KV Video','','2013-11-05 06:27:27','2013-11-05 06:28:08',''),(16,'静电测试-气隙放电-负压-8KV.mp4','Videos','','http://dl.ariaboard.com/%e9%9d%99%e7%94%b5%e6%b5%8b%e8%af%95-%e6%b0%94%e9%9a%99%e6%94%be%e7%94%b5-%e8%b4%9f%e5%8e%8b-8KV.mp4','ESD -8KV Air Gap Discharge','','2013-11-05 06:29:51','2013-11-05 06:29:51',''),(17,'Wince运行视频.MP4','Videos','/www/sources/Wince运行视频.MP4','','Wince运行视频.MP4','113M','2014-03-19 11:27:04','2014-03-19 11:27:57','');
/*!40000 ALTER TABLE `downloads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `schema_migrations`
--

DROP TABLE IF EXISTS `schema_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schema_migrations` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  UNIQUE KEY `unique_schema_migrations` (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `schema_migrations`
--

LOCK TABLES `schema_migrations` WRITE;
/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
INSERT INTO `schema_migrations` VALUES ('20130824040912'),('20130824072912'),('20130914053853'),('20131104080215');
/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `var` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `thing_id` int(11) DEFAULT NULL,
  `thing_type` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_settings_on_thing_type_and_thing_id_and_var` (`thing_type`,`thing_id`,`var`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `settings` 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 2014-10-20  4:34:32
