commit a6ce4c686839017314ac766e2c90e548fc99b8de
parent d6e537eb2877185bc96274421f1f122112d5beb6
Author: Christian <github@christianwolf.email>
Date: Fri, 18 Dec 2020 18:31:26 +0100
Merge pull request #1088 from christianlupus/dev/docker-dev-helpers
Add docker files to generate a development environment
Diffstat:
18 files changed, 2383 insertions(+), 0 deletions(-)
diff --git a/.github/workflows/docker.yml b/.github/workflows/docker.yml
@@ -0,0 +1,54 @@
+name: Docker Image Creation
+
+on:
+ push:
+ branches:
+ - master
+ tags:
+ - '**'
+
+jobs:
+
+ base-image:
+
+ runs-on: ubuntu-latest
+ name: Create the base image
+
+ steps:
+ - uses: actions/checkout@v2
+ - name: Fetch git tags
+ run: git fetch --unshallow origin +refs/tags/*:refs/tags/*
+
+ - name: Build the base docker image
+ run: docker pull partkeepr/base-dev:latest && docker build docker/base-dev --file docker/base/Dockerfile --cache-from partkeepr/base-dev:latest --tag partkeepr/base-dev:latest
+ - name: Tag the base docker image with git hash
+ run: docker tag partkeepr/base-dev:latest partkeepr/base-dev:$(git describe)
+ - name: Deploy the base docker images
+ run: |
+ docker login -u ${{ secrets.DOCKER_USERNAME }} -p ${{ secrets.DOCKER_TOKEN }}
+ docker push partkeepr/base-dev:latest
+ docker push partkeepr/base-dev:$(git describe)
+
+ development-image:
+
+ runs-on: ubuntu-latest
+ needs: base-image
+ name: Create the development image
+
+ steps:
+ - uses: actions/checkout@v2
+ - name: Fetch git tags
+ run: git fetch --unshallow origin +refs/tags/*:refs/tags/*
+
+ - name: Build development image
+ run: |
+ docker pull partkeepr/development:latest
+ docker build docker/development/app --file docker/development/app/Dockerfile --tag partkeepr/development:latest --build-arg SRC_IMAGE=partkeepr/base-dev:$(git describe) --cache-from partkeepr/development:latest
+ - name: Tag the development docker image with git hash
+ run: docker tag partkeepr/development:latest partkeepr/development:$(git describe)
+ - name: Deploy the development docker images
+ run: |
+ docker login -u ${{ secrets.DOCKER_USERNAME }} -p ${{ secrets.DOCKER_TOKEN }}
+ docker push partkeepr/development:latest
+ docker push partkeepr/development:$(git describe)
+
diff --git a/docker/README.md b/docker/README.md
@@ -0,0 +1,79 @@
+# Docker configurations
+
+## Folder structure
+
+The Docker images are composed of different layers and can be used in different ways. Here is a short overview:
+
+| Foldername | Description |
+|----|----|
+| `base` | A basic image containing the required php extensions to run PartKeepr. It will be generated as a starting point for any further images. |
+| `development` | This folder contains a complete setup using docker-compose suitable for developing PartKeepr. It can be used for local unit testing and debugging. |
+
+## Details on the base image
+
+The image installs a set of php extensions, composer, and configures apache to serve `/var/www/pk/web`. That is, PartKeepr should be installed in `/var/www/pk`.
+
+This image is not ready to run but serves as a basis for the other images related to PartKeepr.
+
+## Details on the development installation
+
+The docker-compose file registers multiple container services. The main PartKeepr application is called `app`. The database is a basic configuration with `mariadb:10.1` for compatibility. Third, there is a service called `initdb`. Its purpose is to restore the database and `data` folder to a pristine state. This one should normally not be used unless one wants to reset the database.
+
+**Note:** There needs to be a useful default inserted into the initdb. At the moment it only clears out the database to be valid but containing no parts at all. Exactly the situtation you have after a fresh installation. Some test data might be useful here.
+
+## The main development image
+
+Apart from some additional tools in the docker image mainly an xdebug extension for php is installed.
+
+The image is intended to work on the main sources as checked out. This allows easy updating and testing cycles.
+
+The local files typically belong to the developer user. This causes problems when PartKeepr does not have sufficient permissions or if the UID does not match. To overcome this, the entry point script changes the UID of the `www-data` user in the image to some UID provided by the environment variable `GITHUB_DEBUG_UID`. Any access is thus made from the same rights as the development user outside and all newly created files will belong to `www-data`.
+
+If no explicit command is given, the service starts apache.
+
+Before apache is started, some preparations are made. First composer is called to update any dependencies. If the user has set `PARTKEEPR_FORCE_UPDATE` to `yes`, a set of steps are run that represent a setup (see [the wiki](https://wiki.partkeepr.org/wiki/Running_PartKeepr_from_GIT#Updating)). All cron jobs are run upon restarting to avoid additional messages here.
+
+Calling a manual command is possible as well.
+Then, no initialation script is run and no composer run is performed.
+Just do something like `docker-compose run --rm app composer update`.
+
+By setting `ADD_PHPINFO_FILE` to `1`, the developer can add a file to the web folder that serves a `phpinfo()` command.
+
+There is also a commented sketch in the docker-compose how to debug and develop the Dockerfile.
+
+## Setting up a development environment
+
+In order to start using the suggested development environment a few steps are required to set them up for the first time.
+This guide assumes, you have just freshly checked out the PartKeer repository from git.
+
+- Navigate in a console to the folder `docker/development`.
+- Copy the file `.github.env.dist` to `.github.env`.
+- Create a github personal access token in the settings on github. You need no additional rights. Put the generated token into the file `.github.env` where the `XXX...XXX` markers are.
+ - Alternatively, you can also remove the line in the `.github.env` file. The reason for this setup is that github poses a rate limit on the number of accesses. When using the `composer` command much, these rate limits might be triggered easily. By logging in, the limits are pushed to higher values.
+
+- Call `docker-compose pull` to fetch all images from the docker hub. Alternatively you could [build the images manually](#building-the-images-manually).
+- Now you need to fire up the database and let it initialize. This is done by callng `docker-compose up -d db`. You can peek into the process by `docker-compose logs -f db`. Wait for a message that the server is ready for connections and listening on port 3306. Using `<Ctrl><c>`, you can exit from the logs.
+- Build the `initdb` image by calling `docker-compose build initdb`. This will take a few moments as it builds a docker image.
+ By default the line `RESET_DATABASE: 'yes'` in the file `docker-compose.yml` is commented. This is to avoid accidentially removing your data. Uncomment the line. Then:
+ - Initialize the data by calling `docker-compose up initdb`.
+ - Recomment the line in the `docker-compose.yml` file you just uncommented.
+- Now, you can fire up the main container by calling `docker-compose up -d app`.
+- The container will initialize some dependencies. This might take some time as well. Again using `docker-compose logs -f app` you can peek into the process and with `<Ctrl><c>` you can return to the console.
+ There might be some error messages regarding missing tables.
+- The partkeepr instance is avaliable at http://127.0.0.1:8082/.
+ - Note: If you don't set `PARTKEEPR_FORCE_UPDATE` to `yes` in the `docker-compose` file on your first run you will get a white screen as you need to start the [setup](http://127.0.0.1:8082/setup/) once. Just accept the defaults but do not create a new set of users (keep the existing ones) and select HTTP Basic authentication.
+- You may or may or not want to set up a cron job as described. The check is disabled by default.
+ - Alternatively, you can run the cron command manually with `php app/console partkeepr:cron:run` after logging in to the container with `docker exec -it partkeepr_dev_app_1 bash`.
+
+## Building the images manually
+
+It is possible to build the image manually. The main purpose is to test, debug and alter the docker setup. In order to perform the build from scratch:
+
+- Go to `/docker/base-dev/`.
+- Call `docker build -t partkeepr/base-dev:latest .`. You can also give another tag name but you need to adopt later.
+- Go to `/docker/development`.
+- Alter the `docker-compose.yml` file.
+ - Uncomment all the lines in the `app` service that start with the `build:` name as the comment indicates.
+ - You might want to alter the `SRC_IMAGE` if you tagged with a different name above.
+ - You might want to alter the name of the generated image to not overwrite the local `partkeepr/deevelopment:latest` image.
+- Call `docker-compose build app`.
diff --git a/docker/base-dev/Dockerfile b/docker/base-dev/Dockerfile
@@ -0,0 +1,35 @@
+
+FROM php:7.1-apache-buster
+
+RUN apt-get update && \
+ apt-get upgrade -y && \
+ apt-get install -y sudo curl wget git unzip libldap2-dev libpng++-dev libicu-dev libcurl4-gnutls-dev libxml2-dev libpq-dev libfreetype6-dev nano less vim && \
+ apt-get clean && \
+ docker-php-ext-configure ldap && docker-php-ext-install ldap && \
+ docker-php-ext-configure bcmath && docker-php-ext-install bcmath && \
+ docker-php-ext-configure gd --with-freetype-dir=/usr/include/freetype2 && docker-php-ext-install gd && \
+ docker-php-ext-install opcache intl dom pdo pdo_mysql pdo_pgsql && \
+ pecl install xdebug && docker-php-ext-enable xdebug && \
+ pecl install apcu_bc-beta && \
+ docker-php-ext-enable apcu apc && \
+ mv /usr/local/etc/php/conf.d/docker-php-ext-apcu.ini /usr/local/etc/php/conf.d/10-docker-php-ext-apcu.ini && \
+ mv /usr/local/etc/php/conf.d/docker-php-ext-apc.ini /usr/local/etc/php/conf.d/20-docker-php-ext-apc.ini
+
+RUN mkdir /var/www/pk && chown www-data /var/www/pk
+
+WORKDIR /var/www/pk
+
+# Setup Apache settings
+RUN a2enmod rewrite
+RUN find /etc/apache2 -type f -exec sed 's@/var/www/html@/var/www/pk/web@g' -i \{\} +
+
+# Install Composer
+# See https://tecnstuff.net/how-to-install-composer-on-debian-10/
+RUN cd /tmp && php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');" && \
+ HASH="$(wget -q -O - https://composer.github.io/installer.sig)" && \
+ php -r "if (hash_file('SHA384', 'composer-setup.php') === '$HASH') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); exit(1); } echo PHP_EOL;" && \
+ php composer-setup.php --install-dir=/usr/local/bin --filename=composer --version 1.10.9
+
+COPY xdebug.config /tmp
+RUN cat /tmp/xdebug.config >> /usr/local/etc/php/conf.d/docker-php-ext-xdebug.ini && \
+ rm /tmp/xdebug.config
diff --git a/docker/base-dev/xdebug.config b/docker/base-dev/xdebug.config
@@ -0,0 +1,5 @@
+xdebug.remote_connect_back = true
+xdebug.remote_enable = true
+xdebug.remote_handler = dbgp
+#xdebug.remote_log = /tmp/xdebug.log
+#xdebug.remote_log_level = 7
diff --git a/docker/development/.env b/docker/development/.env
@@ -0,0 +1 @@
+COMPOSE_PROJECT_NAME=partkeepr_dev
diff --git a/docker/development/.gitignore b/docker/development/.gitignore
@@ -0,0 +1 @@
+github.env
diff --git a/docker/development/app/Dockerfile b/docker/development/app/Dockerfile
@@ -0,0 +1,16 @@
+
+ARG SRC_IMAGE=partkeepr/base-dev:latest
+FROM ${SRC_IMAGE}
+
+# Setup PHP settings
+RUN sed 's@;date.timezone =@date.timezone = UTC@;s@max_execution_time = .*@max_execution_time = 72000@;s@memory_limit = .*@memory_limit = 512M@' /usr/local/etc/php/php.ini-development > /usr/local/etc/php/php.ini
+
+COPY entrypoint.sh /entrypoint.sh
+COPY user-entrypoint.sh /user-entrypoint.sh
+COPY phpinfo.php /var/www/html/phpinfo.php
+COPY parameters.defaults.php /parameters.defaults.php
+
+WORKDIR /var/www/pk
+
+ENTRYPOINT ["/entrypoint.sh"]
+CMD ["docker-php-entrypoint", "apache2-foreground"]
diff --git a/docker/development/app/entrypoint.sh b/docker/development/app/entrypoint.sh
@@ -0,0 +1,21 @@
+#!/bin/sh
+
+# Adopt the uid of the php user to the uid of the outer world.
+sed '/www-data/s@www-data:x:\([0-9]*\)@www-data:x:'"$GITHUB_DEBUG_UID@" -i /etc/passwd
+
+cd /var/www/pk
+
+# Allow www-data to use composer
+# This must be done after the uid of www-data has been alterd.
+mkdir /var/www/.composer && chown www-data: /var/www/.composer
+
+if [ "$1" = "docker-php-entrypoint" ]; then
+ # Do the preparation as user www-data
+ sudo -u www-data --preserve-env=COMPOSER_AUTH /user-entrypoint.sh
+
+ exec "$@"
+else
+ echo "Calling manual command $@ as user www-data"
+
+ sudo -u www-data -E "$@"
+fi
diff --git a/docker/development/app/parameters.defaults.php b/docker/development/app/parameters.defaults.php
@@ -0,0 +1,12 @@
+$container->setParameter('database_driver', 'pdo_mysql');
+$container->setParameter('database_host', 'db');
+$container->setParameter('database_name', 'partkeepr');
+$container->setParameter('database_password', 'partkeepr');
+$container->setParameter('database_port', 3306);
+$container->setParameter('database_user', 'partkeepr');
+
+$container->setParameter('partkeepr.cronjob.check', false);
+
+$container->setParameter('partkeepr.frontend.auto_login.enabled', true);
+$container->setParameter('partkeepr.frontend.auto_login.password', 'admin');
+$container->setParameter('partkeepr.frontend.auto_login.username', 'admin');
diff --git a/docker/development/app/phpinfo.php b/docker/development/app/phpinfo.php
@@ -0,0 +1,3 @@
+<?php
+
+phpinfo();
diff --git a/docker/development/app/user-entrypoint.sh b/docker/development/app/user-entrypoint.sh
@@ -0,0 +1,41 @@
+#! /bin/sh
+
+cd /var/www/pk
+
+# Check if parameters are present
+if [ ! -f app/config/parameters.php ]; then
+ echo 'No configuration was found yet. A defult configuration was generated.' >&2
+ echo 'Please visit the setup page if you encounter issues.' >&2
+
+ # Remove any db related config from the dist file
+ grep -v "setParameter('database_" app/config/parameters.php.dist > app/config/parameters.php
+ cat /parameters.defaults.php >> app/config/parameters.php
+fi
+
+# Run composer
+composer install
+
+# Simulare a setup run
+if [ "x$PARTKEEPR_FORCE_UPDATE" = "xyes" ]; then
+
+ # Clears the production cache
+ php app/console cache:clear --env=prod
+
+ # Executes the database migrations
+ php app/console doctrine:migrations:migrate --no-interaction
+
+ # Updates the database schema
+ php app/console doctrine:schema:update --force
+
+ # Builds all required files and warms up the cache
+ ./vendor/bin/phing
+
+fi
+
+# Runs all crons
+php app/console partkeepr:cron:run
+
+# Add phpinfo() file if requested
+if [ -n "$ADD_PHPINFO_FILE" ]; then
+ cp /var/www/html/phpinfo.php /var/www/pk/web
+fi
diff --git a/docker/development/docker-compose.yml b/docker/development/docker-compose.yml
@@ -0,0 +1,51 @@
+---
+version: "3.7"
+
+volumes:
+ db:
+
+services:
+ app:
+ image: partkeepr/development:latest
+
+ # Use this instead if you want to develop the docker infrastructure
+ #build:
+ #context: ./app
+ #args:
+ #SRC_IMAGE: partkeepr/base-dev:latest
+
+ ports:
+ - 8082:80
+ volumes:
+ - "../..:/var/www/pk"
+ env_file:
+ - ./github.env
+ environment:
+ GITHUB_DEBUG_UID: 1000
+ #ADD_PHPINFO_FILE: 1
+ #PARTKEEPR_FORCE_UPDATE: "yes"
+
+ db:
+ image: mariadb:10.1
+ volumes:
+ - db:/var/lib/mysql
+ environment:
+ MYSQL_ROOT_PASSWORD: root
+ MYSQL_USER: partkeepr
+ MYSQL_PASSWORD: partkeepr
+ MYSQL_DATABASE: partkeepr
+
+ initdb:
+ build: initdb
+ depends_on:
+ - db
+ environment:
+ MYSQL_USER: partkeepr
+ MYSQL_ROOT_PASSWORD: root
+ MYSQL_DATABASE: partkeepr
+ # Setting this to yes will enable reset upon running
+ #RESET_DATABASE: 'yes'
+ GITHUB_DEBUG_UID: 1000
+ volumes:
+ - "../../data:/data"
+
diff --git a/docker/development/github.env.dist b/docker/development/github.env.dist
@@ -0,0 +1,3 @@
+
+# Personal GitHub token
+COMPOSER_AUTH={"github-oauth": {"github.com": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"}}
diff --git a/docker/development/initdb/Dockerfile b/docker/development/initdb/Dockerfile
@@ -0,0 +1,11 @@
+
+FROM mariadb:10.1
+RUN apt-get update && apt-get install -y netcat && apt-get clean
+
+COPY command.sh /usr/local/bin/initdb.sh
+COPY dump.sql /dump.sql
+
+RUN mkdir /data
+COPY data.tar.gz /data.tar.gz
+
+CMD /usr/local/bin/initdb.sh
diff --git a/docker/development/initdb/command.sh b/docker/development/initdb/command.sh
@@ -0,0 +1,51 @@
+#! /bin/bash
+
+if [ ! "x$RESET_DATABASE" = "xyes" ]; then
+ echo "No reset of database was requested. Skpping."
+ exit 0
+fi
+
+if [ -z "$DB_HOST" ]; then
+ DB_HOST=db
+fi
+
+if [ -z "$DB_PORT" ]; then
+ DB_PORT=3306
+fi
+
+while ! nc -z "$DB_HOST" "$DB_PORT"
+do
+ echo "sleeping..."
+ sleep 1
+done
+
+echo "MySQL server should now be reachable"
+
+function sql () {
+ mysql -u "root" -p"$MYSQL_ROOT_PASSWORD" -h "$DB_HOST" "$@"
+}
+
+echo "Dropping old database tables (housekeeping)"
+
+echo "DROP DATABASE $MYSQL_DATABASE;" | sql
+
+echo "CREATE DATABASE $MYSQL_DATABASE;" | sql
+echo "GRANT ALL ON $MYSQL_DATABASE.* TO $MYSQL_USER;" | sql
+
+echo "SHOW TABLES;" | sql "$MYSQL_DATABASE"
+
+sql "$MYSQL_DATABASE" < /dump.sql
+
+echo "Dumping completed"
+
+echo "Resetting data folder"
+mkdir /tmp/data
+cd /tmp/data
+
+tar xzf /data.tar.gz
+
+chown "$GITHUB_DEBUG_UID" -R .
+
+cp -a . /data
+
+echo "Data folder was reset"
diff --git a/docker/development/initdb/data.tar.gz b/docker/development/initdb/data.tar.gz
Binary files differ.
diff --git a/docker/development/initdb/dump.sql b/docker/development/initdb/dump.sql
@@ -0,0 +1,1998 @@
+
+/*!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 */;
+DROP TABLE IF EXISTS `BatchJob`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `BatchJob` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ `baseEntity` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_AF3CBF045E237E06` (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `BatchJob` WRITE;
+/*!40000 ALTER TABLE `BatchJob` DISABLE KEYS */;
+/*!40000 ALTER TABLE `BatchJob` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `BatchJobQueryField`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `BatchJobQueryField` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `property` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `operator` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ `value` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `description` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `dynamic` tinyint(1) NOT NULL,
+ `batchJob_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_6118E78CABE62C64` (`batchJob_id`),
+ CONSTRAINT `FK_6118E78CABE62C64` FOREIGN KEY (`batchJob_id`) REFERENCES `BatchJob` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `BatchJobQueryField` WRITE;
+/*!40000 ALTER TABLE `BatchJobQueryField` DISABLE KEYS */;
+/*!40000 ALTER TABLE `BatchJobQueryField` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `BatchJobUpdateField`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `BatchJobUpdateField` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `property` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `value` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `description` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `dynamic` tinyint(1) NOT NULL,
+ `batchJob_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_E1ADA7DFABE62C64` (`batchJob_id`),
+ CONSTRAINT `FK_E1ADA7DFABE62C64` FOREIGN KEY (`batchJob_id`) REFERENCES `BatchJob` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `BatchJobUpdateField` WRITE;
+/*!40000 ALTER TABLE `BatchJobUpdateField` DISABLE KEYS */;
+/*!40000 ALTER TABLE `BatchJobUpdateField` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `CachedImage`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CachedImage` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `originalId` int(11) NOT NULL,
+ `originalType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `cacheFile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `CachedImage` WRITE;
+/*!40000 ALTER TABLE `CachedImage` DISABLE KEYS */;
+/*!40000 ALTER TABLE `CachedImage` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `CronLogger`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `CronLogger` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `lastRunDate` datetime NOT NULL,
+ `cronjob` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `cronjob` (`cronjob`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `CronLogger` WRITE;
+/*!40000 ALTER TABLE `CronLogger` DISABLE KEYS */;
+INSERT INTO `CronLogger` VALUES (1,'2020-02-19 12:25:02','partkeepr:cron:versioncheck');
+INSERT INTO `CronLogger` VALUES (2,'2020-02-19 12:25:02','partkeepr:cron:synctips');
+INSERT INTO `CronLogger` VALUES (3,'2020-02-19 12:25:02','partkeepr:cron:create-statistic-snapshot');
+/*!40000 ALTER TABLE `CronLogger` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `Distributor`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Distributor` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `address` longtext COLLATE utf8_unicode_ci,
+ `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `comment` longtext COLLATE utf8_unicode_ci,
+ `skuurl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `enabledForReports` tinyint(1) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_2559D8A65E237E06` (`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `Distributor` WRITE;
+/*!40000 ALTER TABLE `Distributor` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Distributor` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `FOSUser`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `FOSUser` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `username` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
+ `username_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
+ `enabled` tinyint(1) NOT NULL,
+ `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `last_login` datetime DEFAULT NULL,
+ `confirmation_token` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `password_requested_at` datetime DEFAULT NULL,
+ `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
+ `email_canonical` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_37EF34F492FC23A8` (`username_canonical`),
+ UNIQUE KEY `UNIQ_37EF34F4C05FB297` (`confirmation_token`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `FOSUser` WRITE;
+/*!40000 ALTER TABLE `FOSUser` DISABLE KEYS */;
+INSERT INTO `FOSUser` VALUES (1,'admin','admin',1,'Wxcg.J15FytGq8.do8Z0FQNbrOmRzpoWW24hnCAcEbA','W+fu9VmA5h/fevafE9+VNZcw590iTu4Nd8zepUCUVElcJ3RJlwheGBajYJPvrdQktUxr0HH+DsurgSeyHBusOw==',NULL,NULL,NULL,'a:1:{i:0;s:16:\"ROLE_SUPER_ADMIN\";}','foo@bar.com','foo@bar.com');
+/*!40000 ALTER TABLE `FOSUser` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `Footprint`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Footprint` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `category_id` int(11) DEFAULT NULL,
+ `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_7CF324945E237E06` (`name`),
+ KEY `IDX_7CF3249412469DE2` (`category_id`),
+ CONSTRAINT `FK_7CF3249412469DE2` FOREIGN KEY (`category_id`) REFERENCES `FootprintCategory` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `Footprint` WRITE;
+/*!40000 ALTER TABLE `Footprint` DISABLE KEYS */;
+INSERT INTO `Footprint` VALUES (1,3,'CBGA-32','32-Lead Ceramic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (2,5,'FCBGA-576','576-Ball Ball Grid Array, Thermally Enhanced');
+INSERT INTO `Footprint` VALUES (3,7,'PBGA-119','119-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (4,9,'PBGA-169','169-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (5,11,'PBGA-225','225-Ball Plastic a Ball Grid Array');
+INSERT INTO `Footprint` VALUES (6,13,'PBGA-260','260-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (7,15,'PBGA-297','297-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (8,17,'PBGA-304','304-Lead Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (9,19,'PBGA-316','316-Lead Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (10,21,'PBGA-324','324-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (11,23,'PBGA-385','385-Lead Ball Grid Array');
+INSERT INTO `Footprint` VALUES (12,25,'PBGA-400','400-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (13,27,'PBGA-484','484-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (14,29,'PBGA-625','625-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (15,31,'PBGA-676','676-Ball Plastic Ball Grid Array');
+INSERT INTO `Footprint` VALUES (16,33,'SBGA-256','256-Ball Ball Grid Array, Thermally Enhanced');
+INSERT INTO `Footprint` VALUES (17,35,'SBGA-304','304-Ball Ball Grid Array, Thermally Enhanced');
+INSERT INTO `Footprint` VALUES (18,37,'SBGA-432','432-Ball Ball Grid Array, Thermally Enhanced');
+INSERT INTO `Footprint` VALUES (19,39,'CerDIP-8','8-Lead Ceramic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (20,41,'CerDIP-14','14-Lead Ceramic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (21,43,'CerDIP-16','16-Lead Ceramic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (22,45,'CerDIP-18','18-Lead Ceramic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (23,47,'CerDIP-20','20-Lead Ceramic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (24,49,'CerDIP-24 Narrow','24-Lead Ceramic Dual In-Line Package - Narrow Body');
+INSERT INTO `Footprint` VALUES (25,51,'CerDIP-24 Wide','24-Lead Ceramic Dual In-Line Package - Wide Body');
+INSERT INTO `Footprint` VALUES (26,53,'CerDIP-28','28-Lead Ceramic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (27,55,'CerDIP-40','40-Lead Ceramic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (28,57,'PDIP-8','8-Lead Plastic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (29,59,'PDIP-14','14-Lead Plastic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (30,61,'PDIP-16','16-Lead Plastic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (31,63,'PDIP-18','18-Lead Plastic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (32,65,'PDIP-20','20-Lead Plastic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (33,67,'PDIP-24','24-Lead Plastic Dual In-Line Package');
+INSERT INTO `Footprint` VALUES (34,69,'PDIP-28 Narrow','28-Lead Plastic Dual In-Line Package, Narrow Body');
+INSERT INTO `Footprint` VALUES (35,71,'PDIP-28 Wide','28-Lead Plastic Dual In-Line Package, Wide Body');
+INSERT INTO `Footprint` VALUES (36,NULL,'SOIC-N-EP-8','8-Lead Standard Small Outline Package, with Expose Pad');
+/*!40000 ALTER TABLE `Footprint` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `FootprintAttachment`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `FootprintAttachment` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `footprint_id` int(11) DEFAULT NULL,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_7B7388A151364C98` (`footprint_id`),
+ CONSTRAINT `FK_7B7388A151364C98` FOREIGN KEY (`footprint_id`) REFERENCES `Footprint` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `FootprintAttachment` WRITE;
+/*!40000 ALTER TABLE `FootprintAttachment` DISABLE KEYS */;
+/*!40000 ALTER TABLE `FootprintAttachment` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `FootprintCategory`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `FootprintCategory` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `parent_id` int(11) DEFAULT NULL,
+ `lft` int(11) NOT NULL,
+ `rgt` int(11) NOT NULL,
+ `lvl` int(11) NOT NULL,
+ `root` int(11) DEFAULT NULL,
+ `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `categoryPath` longtext COLLATE utf8_unicode_ci,
+ PRIMARY KEY (`id`),
+ KEY `IDX_C026BA6A727ACA70` (`parent_id`),
+ KEY `IDX_C026BA6ADA439252` (`lft`),
+ KEY `IDX_C026BA6AD5E02D69` (`rgt`),
+ CONSTRAINT `FK_C026BA6A727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `FootprintCategory` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `FootprintCategory` WRITE;
+/*!40000 ALTER TABLE `FootprintCategory` DISABLE KEYS */;
+INSERT INTO `FootprintCategory` VALUES (1,NULL,1,142,0,1,'Root Category',NULL,'Root Category');
+INSERT INTO `FootprintCategory` VALUES (2,1,2,5,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (3,2,3,4,2,1,'CBGA',NULL,'Root Category ➤ BGA ➤ CBGA');
+INSERT INTO `FootprintCategory` VALUES (4,1,6,9,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (5,4,7,8,2,1,'FCBGA',NULL,'Root Category ➤ BGA ➤ FCBGA');
+INSERT INTO `FootprintCategory` VALUES (6,1,10,13,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (7,6,11,12,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (8,1,14,17,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (9,8,15,16,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (10,1,18,21,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (11,10,19,20,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (12,1,22,25,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (13,12,23,24,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (14,1,26,29,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (15,14,27,28,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (16,1,30,33,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (17,16,31,32,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (18,1,34,37,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (19,18,35,36,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (20,1,38,41,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (21,20,39,40,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (22,1,42,45,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (23,22,43,44,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (24,1,46,49,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (25,24,47,48,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (26,1,50,53,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (27,26,51,52,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (28,1,54,57,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (29,28,55,56,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (30,1,58,61,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (31,30,59,60,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (32,1,62,65,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (33,32,63,64,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (34,1,66,69,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (35,34,67,68,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (36,1,70,73,1,1,'BGA',NULL,'Root Category ➤ BGA');
+INSERT INTO `FootprintCategory` VALUES (37,36,71,72,2,1,'PBGA',NULL,'Root Category ➤ BGA ➤ PBGA');
+INSERT INTO `FootprintCategory` VALUES (38,1,74,77,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (39,38,75,76,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (40,1,78,81,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (41,40,79,80,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (42,1,82,85,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (43,42,83,84,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (44,1,86,89,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (45,44,87,88,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (46,1,90,93,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (47,46,91,92,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (48,1,94,97,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (49,48,95,96,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (50,1,98,101,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (51,50,99,100,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (52,1,102,105,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (53,52,103,104,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (54,1,106,109,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (55,54,107,108,2,1,'CERDIP',NULL,'Root Category ➤ DIP ➤ CERDIP');
+INSERT INTO `FootprintCategory` VALUES (56,1,110,113,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (57,56,111,112,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+INSERT INTO `FootprintCategory` VALUES (58,1,114,117,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (59,58,115,116,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+INSERT INTO `FootprintCategory` VALUES (60,1,118,121,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (61,60,119,120,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+INSERT INTO `FootprintCategory` VALUES (62,1,122,125,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (63,62,123,124,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+INSERT INTO `FootprintCategory` VALUES (64,1,126,129,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (65,64,127,128,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+INSERT INTO `FootprintCategory` VALUES (66,1,130,133,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (67,66,131,132,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+INSERT INTO `FootprintCategory` VALUES (68,1,134,137,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (69,68,135,136,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+INSERT INTO `FootprintCategory` VALUES (70,1,138,141,1,1,'DIP',NULL,'Root Category ➤ DIP');
+INSERT INTO `FootprintCategory` VALUES (71,70,139,140,2,1,'PDIP',NULL,'Root Category ➤ DIP ➤ PDIP');
+/*!40000 ALTER TABLE `FootprintCategory` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `FootprintImage`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `FootprintImage` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `footprint_id` int(11) DEFAULT NULL,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_3B22699151364C98` (`footprint_id`),
+ CONSTRAINT `FK_3B22699151364C98` FOREIGN KEY (`footprint_id`) REFERENCES `Footprint` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `FootprintImage` WRITE;
+/*!40000 ALTER TABLE `FootprintImage` DISABLE KEYS */;
+INSERT INTO `FootprintImage` VALUES (1,1,'footprint','1b614228-517c-11ea-abf0-df07e0119f97','CBGA-32.png','image/png',23365,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (2,2,'footprint','1b63770a-517c-11ea-8454-92064e7639f6','FCBGA-576.png','image/png',47861,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (3,3,'footprint','1b63b0e4-517c-11ea-ba68-6d0f91f0c135','PBGA-119.png','image/png',32537,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (4,4,'footprint','1b63f96e-517c-11ea-a0fc-b0836905e28f','PBGA-169.png','image/png',36699,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (5,5,'footprint','1b643582-517c-11ea-8288-44c7cc4082be','PBGA-225.png','image/png',39366,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (6,6,'footprint','1b64666a-517c-11ea-8276-fcf401bad075','PBGA-260.png','image/png',61202,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (7,7,'footprint','1b64a288-517c-11ea-a103-2bac72df83f2','PBGA-297.png','image/png',68013,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (8,8,'footprint','1b64dc76-517c-11ea-b2f0-af292bdaf294','PBGA-304.png','image/png',55833,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (9,9,'footprint','1b6511be-517c-11ea-aeab-598288f4b9f9','PBGA-316.png','image/png',55996,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (10,10,'footprint','1b654a30-517c-11ea-b389-0f42afcb7306','PBGA-324.png','image/png',44882,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (11,11,'footprint','1b657c1c-517c-11ea-a9a8-e6c551e2818e','PBGA-385.png','image/png',35146,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (12,12,'footprint','1b65aa84-517c-11ea-9953-bc48badc789c','PBGA-400.png','image/png',67933,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (13,13,'footprint','1b65e1ca-517c-11ea-8c40-59fab99a84a0','PBGA-484.png','image/png',49851,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (14,14,'footprint','1b6613c0-517c-11ea-972d-39c41375f445','PBGA-625.png','image/png',65307,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (15,15,'footprint','1b664250-517c-11ea-a3d9-b47a1a2242cb','PBGA-676.png','image/png',54708,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (16,16,'footprint','1b667838-517c-11ea-8977-5b5865ff9ca0','SBGA-256.png','image/png',48636,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (17,17,'footprint','1b66adb2-517c-11ea-b7b4-7f7c94b28d87','SBGA-304.png','image/png',51944,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (18,18,'footprint','1b66e21e-517c-11ea-9c1a-577cc2ece8dc','SBGA-432.png','image/png',63247,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (19,19,'footprint','1b6718ce-517c-11ea-921d-b45648294db9','CERDIP-8.png','image/png',13544,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (20,20,'footprint','1b6747f4-517c-11ea-a1b9-49ea24d34e37','CERDIP-14.png','image/png',14226,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (21,21,'footprint','1b677332-517c-11ea-b3a5-47f1c7fba789','CERDIP-16.png','image/png',14576,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (22,22,'footprint','1b679a60-517c-11ea-897c-a85add34303b','CERDIP-18.png','image/png',9831,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (23,23,'footprint','1b67c3e6-517c-11ea-9e32-235fc3df1155','CERDIP-20.png','image/png',10209,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (24,24,'footprint','1b67ecae-517c-11ea-b082-45d96b9cd05a','CERDIP-24-N.png','image/png',11582,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (25,25,'footprint','1b68118e-517c-11ea-bcfb-4eb5975ac9db','CERDIP-24-W.png','image/png',12407,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (26,26,'footprint','1b683754-517c-11ea-a0c9-4f8614fa4e5a','CERDIP-28.png','image/png',12233,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (27,27,'footprint','1b686152-517c-11ea-92dd-891364b6b3ac','CERDIP-40.png','image/png',12421,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (28,28,'footprint','1b688eac-517c-11ea-b074-23df72f58f66','PDIP-8.png','image/png',13537,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (29,29,'footprint','1b68b9fe-517c-11ea-a238-f95b4fe0544c','PDIP-14.png','image/png',13779,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (30,30,'footprint','1b68e078-517c-11ea-8f25-38997cd97702','PDIP-16.png','image/png',18305,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (31,31,'footprint','1b6908c8-517c-11ea-8831-71c365f054e0','PDIP-18.png','image/png',14893,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (32,32,'footprint','1b692e98-517c-11ea-af51-9c818fee0248','PDIP-20.png','image/png',14429,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (33,33,'footprint','1b6954f4-517c-11ea-9de4-ae9526322ddf','PDIP-24.png','image/png',14647,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (34,34,'footprint','1b697b28-517c-11ea-a5f1-27bc161d3dd2','PDIP-28-N.png','image/png',18703,'png',NULL,'2020-02-17 11:53:26');
+INSERT INTO `FootprintImage` VALUES (35,35,'footprint','1b69a47c-517c-11ea-8c9d-2b8a8acd34e3','PDIP-28-W.png','image/png',15728,'png',NULL,'2020-02-17 11:53:26');
+/*!40000 ALTER TABLE `FootprintImage` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `GridPreset`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `GridPreset` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `grid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `configuration` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `gridDefault` tinyint(1) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `name_grid_unique` (`grid`,`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `GridPreset` WRITE;
+/*!40000 ALTER TABLE `GridPreset` DISABLE KEYS */;
+/*!40000 ALTER TABLE `GridPreset` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ImportPreset`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ImportPreset` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `baseEntity` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `configuration` longtext COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `name_entity_unique` (`baseEntity`,`name`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ImportPreset` WRITE;
+/*!40000 ALTER TABLE `ImportPreset` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ImportPreset` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `Manufacturer`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Manufacturer` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `address` longtext COLLATE utf8_unicode_ci,
+ `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `comment` longtext COLLATE utf8_unicode_ci,
+ `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_253B3D245E237E06` (`name`)
+) ENGINE=InnoDB AUTO_INCREMENT=286 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `Manufacturer` WRITE;
+/*!40000 ALTER TABLE `Manufacturer` DISABLE KEYS */;
+INSERT INTO `Manufacturer` VALUES (1,'Integrated Circuit Designs',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (2,'ACTEL',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (3,'ALTINC',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (4,'Aeroflex',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (5,'Agilent Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (6,'AKM Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (7,'Alesis Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (8,'ALi (Acer Laboratories Inc.)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (9,'Allayer Communications',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (10,'Allegro Microsystems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (11,'Alliance Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (12,'Alpha Industries',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (13,'Alpha Microelectronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (14,'Altera',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (15,'Advanced Micro Devices (AMD)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (16,'American Microsystems, Inc. (AMI)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (17,'Amic Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (18,'Amphus',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (19,'Anachip Corp.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (20,'ANADIGICs',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (21,'Analog Devices',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (22,'Analog Systems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (23,'Anchor Chips',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (24,'Apex Microtechnology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (25,'ARK Logic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (26,'ASD',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (27,'Astec Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (28,'ATC (Analog Technologie)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (29,'ATecoM',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (30,'ATI Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (31,'Atmel',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (32,'AT&T',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (33,'AudioCodes',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (34,'Aura Vision',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (35,'Aureal',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (36,'Austin Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (37,'Avance Logic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (38,'Bel Fuse',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (39,'Benchmarq Microelectronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (40,'BI Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (41,'Bowmar/White',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (42,'Brightflash',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (43,'Broadcom',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (44,'Brooktree(now Rockwell)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (45,'Burr Brown',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (46,'California Micro Devices',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (47,'Calogic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (48,'Catalyst Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (49,'Centon Electronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (50,'Ceramate Technical',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (51,'Cherry Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (52,'Chipcon AS',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (53,'Chips',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (54,'Chrontel',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (55,'Cirrus Logic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (56,'ComCore Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (57,'Conexant',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (58,'Cosmo Electronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (59,'Chrystal',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (60,'Cygnal',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (61,'Cypress Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (62,'Cyrix Corporation',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (63,'Daewoo Electronics Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (64,'Dallas Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (65,'Davicom Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (66,'Data Delay Devices',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (67,'Diamond Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (68,'DIOTEC',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (69,'DTC Data Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (70,'DVDO',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (71,'EG&G',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (72,'Elan Microelectronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (73,'ELANTEC',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (74,'Electronic Arrays',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (75,'Elite Flash Storage Technology Inc. (EFST)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (76,'EM Microelectronik - Marin',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (77,'Enhanced Memory Systems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (78,'Ensoniq Corp',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (79,'EON Silicon Devices',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (80,'Epson',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (81,'Ericsson',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (82,'ESS Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (83,'Electronic Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (84,'EXAR',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (85,'Excel Semiconductor Inc.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (86,'Fairschild',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (87,'Freescale Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (88,'Fujitsu',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (89,'Galileo Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (90,'Galvantech',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (91,'GEC Plessey',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (92,'Gennum',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (93,'General Electric (Harris)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (94,'General Instruments',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (95,'G-Link Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (96,'Goal Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (97,'Goldstar',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (98,'Gould',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (99,'Greenwich Instruments',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (100,'General Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (101,'Harris Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (102,'VEB',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (103,'Hitachi Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (104,'Holtek',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (105,'Hewlett Packard',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (106,'Hualon',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (107,'Hynix Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (108,'Hyundai',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (109,'IC Design',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (110,'Integrated Circuit Systems (ICS)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (111,'IC - Haus',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (112,'ICSI (Integrated Circuit Solution Inc.)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (113,'I-Cube',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (114,'IC Works',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (115,'Integrated Device Technology (IDT)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (116,'IGS Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (117,'IMPALA Linear',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (118,'IMP',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (119,'Infineon',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (120,'INMOS',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (121,'Intel',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (122,'Intersil',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (123,'International Rectifier',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (124,'Information Storage Devices',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (125,'ISSI (Integrated Silicon Solution, Inc.)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (126,'Integrated Technology Express',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (127,'ITT Semiconductor (Micronas Intermetall)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (128,'IXYS',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (129,'Korea Electronics (KEC)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (130,'Kota Microcircuits',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (131,'Lattice Semiconductor Corp.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (132,'Lansdale Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (133,'Level One Communications',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (134,'LG Semicon (Lucky Goldstar Electronic Co.)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (135,'Linear Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (136,'Linfinity Microelectronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (137,'Lite-On',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (138,'Lucent Technologies (AT&T Microelectronics)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (139,'Macronix International',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (140,'Marvell Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (141,'Matsushita Panasonic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (142,'Maxim Dallas',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (143,'Media Vision',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (144,'Microchip (Arizona Michrochip Technology)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (145,'Matra MHS',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (146,'Micrel Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (147,'Micronas',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (148,'Micronix Integrated Systems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (149,'Micron Technology, Inc.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (150,'Microsemi',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (151,'Mini-Circuits',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (152,'Mitel Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (153,'Mitsubishi Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (154,'Micro Linear',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (155,'MMI (Monolithic Memories, Inc.)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (156,'Mosaic Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (157,'Mosel Vitelic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (158,'MOS Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (159,'Mostek',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (160,'MoSys',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (161,'Motorola',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (162,'Microtune',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (163,'M-Systems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (164,'Murata Manufacturing',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (165,'MWave (IBM)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (166,'Myson Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (167,'NEC Electronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (168,'NexFlash Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (169,'New Japan Radio',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (170,'National Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (171,'NVidia Corporation',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (172,'Oak Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (173,'Oki Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (174,'Opti',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (175,'Orbit Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (176,'Oren Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (177,'Performance Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (178,'Pericom Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (179,'PhaseLink Laboratories',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (180,'Philips Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (181,'PLX Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (182,'PMC- Sierra',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (183,'Precision Monolithics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (184,'Princeton Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (185,'PowerSmart',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (186,'QuickLogic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (187,'Qlogic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (188,'Quality Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (189,'Rabbit Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (190,'Ramtron International Co.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (191,'Raytheon Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (192,'RCA Solid State',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (193,'Realtek Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (194,'Rectron',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (195,'Rendition',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (196,'Renesas Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (197,'Rockwell',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (198,'Rohm Corp.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (199,'S3',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (200,'Sage',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (201,'Saifun Semiconductors Ltd.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (202,'Sames',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (203,'Samsung',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (204,'Sanken',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (205,'Sanyo',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (206,'Scenix',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (207,'Samsung Electronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (208,'SEEQ Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (209,'Seiko Instruments',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (210,'Semtech',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (211,'SGS-Ates',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (212,'SGS-Thomson Microelectonics ST-M)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (213,'Sharp Microelectronics (USA)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (214,'Shindengen',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (215,'Siemens Microelectronics, Inc.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (216,'Sierra',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (217,'Sigma Tel',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (218,'Signetics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (219,'Silicon Laboratories',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (220,'Silicon Magic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (221,'Simtec Corp.',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (222,'Siliconix',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (223,'Siliconians',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (224,'Sipex',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (225,'Silicon Integrated Systems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (226,'SMC',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (227,'Standard Microsystems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (228,'Sony Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (229,'Space Electronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (230,'Spectek',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (231,'Signal Processing Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (232,'Solid State Scientific',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (233,'Silicon Storage Technology (SST)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (234,'STMicroelectronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (235,'SUMMIT Microelectronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (236,'Synergy Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (237,'Synertek',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (238,'Taiwan Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (239,'TDK Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (240,'Teccor Electronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (241,'TelCom Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (242,'Teledyne',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (243,'Telefunken',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (244,'Teltone',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (245,'Thomson-CSF',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (246,'Texas Instruments',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (247,'Toko Amerika',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (248,'Toshiba (US)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (249,'Trident',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (250,'TriQuint Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (251,'Triscend',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (252,'Tseng Labs',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (253,'Tundra',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (254,'Turbo IC',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (255,'Ubicom',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (256,'United Microelectronics Corp (UMC)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (257,'Unitrode',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (258,'USAR Systems',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (259,'United Technologies Microelectronics Center (UTMC)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (260,'Utron',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (261,'V3 Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (262,'Vadem',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (263,'Vanguard International Semiconductor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (264,'Vantis',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (265,'Via Technologies',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (266,'Virata',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (267,'Vishay',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (268,'Vision Tech',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (269,'Vitelic',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (270,'VLSI Technology',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (271,'Volterra',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (272,'VTC',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (273,'Waferscale Integration (WSI)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (274,'Western Digital',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (275,'Weitek',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (276,'Winbond',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (277,'Wofson Microelectronics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (278,'Xwmics',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (279,'Xicor',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (280,'Xilinx',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (281,'Yamaha',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (282,'Zetex Semiconductors',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (283,'Zilog',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (284,'ZMD (Zentrum Mikroelektronik Dresden)',NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `Manufacturer` VALUES (285,'Zoran',NULL,NULL,NULL,NULL,NULL,NULL);
+/*!40000 ALTER TABLE `Manufacturer` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ManufacturerICLogo`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ManufacturerICLogo` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `manufacturer_id` int(11) DEFAULT NULL,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_3F1EF213A23B42D` (`manufacturer_id`),
+ CONSTRAINT `FK_3F1EF213A23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `Manufacturer` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=347 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ManufacturerICLogo` WRITE;
+/*!40000 ALTER TABLE `ManufacturerICLogo` DISABLE KEYS */;
+INSERT INTO `ManufacturerICLogo` VALUES (1,1,'iclogo','1bf234c2-517c-11ea-b35d-fce0933e9505','acer.png','image/png',2195,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (2,2,'iclogo','1bf2ae16-517c-11ea-97d9-6f9707d791fa','actel.png','image/png',5003,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (3,3,'iclogo','1bf2cacc-517c-11ea-9c25-20eb09bb4805','advldev.png','image/png',1835,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (4,4,'iclogo','1bf2e55c-517c-11ea-8e4a-d5b5d8376133','aeroflex1.png','image/png',9649,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (5,4,'iclogo','1bf2f3a8-517c-11ea-9fc3-e855a641c013','aeroflex2.png','image/png',4562,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (6,5,'iclogo','1bf3125c-517c-11ea-8ad6-7584dd4872e3','agilent.png','image/png',5264,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (7,6,'iclogo','1bf32e22-517c-11ea-ae4b-31942bf0a604','akm.png','image/png',2204,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (8,7,'iclogo','1bf34a60-517c-11ea-a1a2-bf3e0c5eb129','alesis.png','image/png',1475,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (9,8,'iclogo','1bf36504-517c-11ea-b942-de884c035401','ali1.png','image/png',2462,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (10,8,'iclogo','1bf37062-517c-11ea-a769-94c5b8b16606','ali2.png','image/png',1784,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (11,9,'iclogo','1bf38a84-517c-11ea-b777-febc878c93b9','allayer.png','image/png',1869,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (12,10,'iclogo','1bf3a4f6-517c-11ea-9354-9dfe667f3ffb','allegro.png','image/png',1475,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (13,11,'iclogo','1bf3bf68-517c-11ea-94ca-3bee1054a469','alliance.png','image/png',1949,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (14,12,'iclogo','1bf3d9d0-517c-11ea-96c3-2f286e2c43a0','alphaind.png','image/png',1403,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (15,13,'iclogo','1bf3f334-517c-11ea-af41-fdd860f3be55','alphamic.png','image/png',2989,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (16,13,'iclogo','1bf3fe4c-517c-11ea-a72b-0068adddb063','alpha.png','image/png',1534,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (17,14,'iclogo','1bf418f0-517c-11ea-ad16-02b4db63573c','altera.png','image/png',4064,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (18,15,'iclogo','1bf4342a-517c-11ea-9979-9b3ed7ceef28','amd.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (19,16,'iclogo','1bf44e10-517c-11ea-b3ce-a5475ba9f143','ami1.png','image/png',2399,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (20,16,'iclogo','1bf458b0-517c-11ea-ac44-fcd1f1523dfe','ami2.png','image/png',1706,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (21,17,'iclogo','1bf46fda-517c-11ea-bdf4-c5c1170ce7c9','amic.png','image/png',2228,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (22,18,'iclogo','1bf48808-517c-11ea-9b81-8d820fae5bbd','ampus.png','image/png',6150,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (23,19,'iclogo','1bf4a270-517c-11ea-86c5-542d43a8d1ec','anachip.png','image/png',3549,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (24,20,'iclogo','1bf4bc60-517c-11ea-8c03-fab80f6570c4','anadigic.png','image/png',5147,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (25,21,'iclogo','1bf4d650-517c-11ea-b630-b2bc58c88656','analog1.png','image/png',1262,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (26,21,'iclogo','1bf4e19a-517c-11ea-842a-b91a0a77f6cd','analog.png','image/png',1403,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (27,22,'iclogo','1bf4fa68-517c-11ea-a4a0-a9084394413c','anasys.png','image/png',3309,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (28,23,'iclogo','1bf512fa-517c-11ea-bffc-0c69b625faa2','anchorch.png','image/png',1475,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (29,24,'iclogo','1bf52cc2-517c-11ea-b02c-919367aa0ba2','apex1.png','image/png',2627,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (30,24,'iclogo','1bf53834-517c-11ea-8391-de106a74aba7','apex.png','image/png',3974,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (31,25,'iclogo','1bf54f40-517c-11ea-8d3c-f7c4839de3bb','ark.png','image/png',2089,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (32,26,'iclogo','1bf5670a-517c-11ea-b2df-82cfd5ece312','asd.png','image/png',5024,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (33,27,'iclogo','1bf5856e-517c-11ea-a6ab-95387f5ec787','astec.png','image/png',3369,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (34,28,'iclogo','1bf5a198-517c-11ea-9a5b-421f9569f655','atc.png','image/png',8660,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (35,29,'iclogo','1bf5bd4a-517c-11ea-8fee-4e86d0972f53','atecom.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (36,30,'iclogo','1bf5d6a4-517c-11ea-a217-1842bb5bd149','ati.png','image/png',2630,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (37,31,'iclogo','1bf5f116-517c-11ea-aad9-d71f69b54477','atmel.png','image/png',2843,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (38,32,'iclogo','1bf609a8-517c-11ea-85c8-138b50f5d7b5','att.png','image/png',2816,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (39,33,'iclogo','1bf621b8-517c-11ea-bfd4-f2c4d3a50749','audiocod.png','image/png',2429,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (40,34,'iclogo','1bf63c0c-517c-11ea-8cf1-c65671cbf54d','auravis.png','image/png',2281,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (41,35,'iclogo','1bf6576e-517c-11ea-bd4f-717aa432e8e7','aureal.png','image/png',2109,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (42,36,'iclogo','1bf670b4-517c-11ea-b4c9-1b53837dd170','austin.png','image/png',2464,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (43,37,'iclogo','1bf688ec-517c-11ea-9657-24b12d0441e7','averlog.png','image/png',1552,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (44,38,'iclogo','1bf6a02a-517c-11ea-85e6-0377c723dd77','belfuse.png','image/png',2204,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (45,39,'iclogo','1bf6b86c-517c-11ea-8f7e-019a2d142c32','benchmrq.png','image/png',1370,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (46,40,'iclogo','1bf6ceec-517c-11ea-ba79-6d72a2c4f46d','bi.png','image/png',2008,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (47,41,'iclogo','1bf6e512-517c-11ea-b0bc-6d136df08bae','bowmar_white.png','image/png',4652,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (48,42,'iclogo','1bf70092-517c-11ea-9e22-bbd284f7649d','bright.png','image/png',6839,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (49,43,'iclogo','1bf71cf8-517c-11ea-9d0a-3c376ae135a1','broadcom.png','image/png',6056,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (50,44,'iclogo','1bf73832-517c-11ea-97cb-b942028e671a','brooktre.png','image/png',1364,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (51,45,'iclogo','1bf75362-517c-11ea-bc6f-80f3acb4a325','burrbrwn.png','image/png',3563,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (52,46,'iclogo','1bf76e24-517c-11ea-854f-87b093c998fa','calmicro.png','image/png',2109,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (53,47,'iclogo','1bf78738-517c-11ea-81ff-41ad2951bde7','calogic.png','image/png',3367,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (54,48,'iclogo','1bf79e8a-517c-11ea-bffe-b984ab8fdb7f','catalys1.png','image/png',1922,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (55,48,'iclogo','1bf7a7d6-517c-11ea-ab45-005d289b56bb','catalyst.png','image/png',2228,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (56,49,'iclogo','1bf7c1bc-517c-11ea-b821-59ea3b1ac07a','ccube.png','image/png',1309,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (57,50,'iclogo','1bf7d9e0-517c-11ea-809d-d3f3ae05ccb5','ceramate1.png','image/png',2917,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (58,50,'iclogo','1bf7e3e0-517c-11ea-8642-b964a9e4a334','ceramate2.png','image/png',2917,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (59,51,'iclogo','1bf7f9d4-517c-11ea-ba22-63cef6e34ab7','cherry.png','image/png',2507,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (60,52,'iclogo','1bf80ed8-517c-11ea-b815-7ed2d2d5d78d','chipcon1.png','image/png',8655,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (61,52,'iclogo','1bf818d8-517c-11ea-b5b9-d2874e1b0ff8','chipcon2.png','image/png',2923,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (62,53,'iclogo','1bf82ea4-517c-11ea-aa02-39e47783e38a','chips.png','image/png',2864,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (63,54,'iclogo','1bf84394-517c-11ea-b098-e8e85c3d4206','chrontel.png','image/png',1476,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (64,55,'iclogo','1bf85b7c-517c-11ea-b616-47df838cf0dc','cirrus.png','image/png',3218,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (65,56,'iclogo','1bf87472-517c-11ea-b4fb-6fe8a64387ec','comcore.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (66,57,'iclogo','1bf88d18-517c-11ea-bcff-e2bf3e4e7649','conexant.png','image/png',2051,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (67,58,'iclogo','1bf8a44c-517c-11ea-977e-4d78192c3092','cosmo.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (68,59,'iclogo','1bf8bab8-517c-11ea-ab3e-4b8a8705546f','crystal.png','image/png',3605,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (69,60,'iclogo','1bf8d30e-517c-11ea-abba-3238b2c0ea75','cygnal.png','image/png',2135,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (70,61,'iclogo','1bf8ea60-517c-11ea-8c30-e6807cbb2737','cypres1.png','image/png',2504,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (71,61,'iclogo','1bf8f334-517c-11ea-a2e0-d749c5031ab2','cypress.png','image/png',4275,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (72,62,'iclogo','1bf90d9c-517c-11ea-a112-69c5a0aa197c','cyrix.png','image/png',2204,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (73,63,'iclogo','1bf92890-517c-11ea-97d1-5da2675827f1','daewoo.png','image/png',1907,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (74,64,'iclogo','1bf94186-517c-11ea-86dc-26d3edd8f145','dallas1.png','image/png',1469,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (75,64,'iclogo','1bf94ca8-517c-11ea-9806-96823e02d5ed','dallas2.png','image/png',1309,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (76,64,'iclogo','1bf957c0-517c-11ea-b634-55cc3b2db562','dallas3.png','image/png',1869,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (77,65,'iclogo','1bf97336-517c-11ea-9c7e-80afc2c87a7e','davicom.png','image/png',4589,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (78,66,'iclogo','1bf98c5e-517c-11ea-abff-9a621015476e','ddd.png','image/png',3235,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (79,67,'iclogo','1bf9a662-517c-11ea-acf5-db688dccdf07','diamond.png','image/png',2504,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (80,68,'iclogo','1bf9c14c-517c-11ea-808e-c282bbc876ad','diotec.png','image/png',1454,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (81,69,'iclogo','1bf9dbaa-517c-11ea-b367-dd80173d488e','dtc1.png','image/png',2513,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (82,69,'iclogo','1bf9e712-517c-11ea-85ea-a6558bee54c0','dtc2.png','image/png',1670,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (83,70,'iclogo','1bfa01d4-517c-11ea-823b-03d239269963','dvdo.png','image/png',2357,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (84,71,'iclogo','1bfa1c14-517c-11ea-b4dc-9e4265231d64','egg.png','image/png',1628,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (85,72,'iclogo','1bfa330c-517c-11ea-8724-27b7465727ee','elan.png','image/png',13826,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (86,73,'iclogo','1bfa50b2-517c-11ea-83be-8f0b837351cd','elantec1.png','image/png',1400,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (87,73,'iclogo','1bfa5a26-517c-11ea-81a9-d5d926ac5e69','elantec.png','image/png',3274,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (88,74,'iclogo','1bfa7524-517c-11ea-b662-f101388794c0','elec_arrays.png','image/png',5602,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (89,75,'iclogo','1bfa902c-517c-11ea-b316-3cd0b135afd8','elite[1].png','image/png',8285,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (90,76,'iclogo','1bfaab8e-517c-11ea-b19b-57bae656542c','emmicro.png','image/png',3599,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (91,77,'iclogo','1bfac6a0-517c-11ea-a1c3-79047a53283d','enhmemsy.png','image/png',1403,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (92,78,'iclogo','1bfae0ea-517c-11ea-9632-584ec84a88e7','ensoniq.png','image/png',3557,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (93,79,'iclogo','1bfafcec-517c-11ea-ac52-746bcccd59d4','eon.png','image/png',5393,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (94,80,'iclogo','1bfb15a6-517c-11ea-902d-29e6ae671f9a','epson1.png','image/png',2349,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (95,80,'iclogo','1bfb1fc4-517c-11ea-8341-8ef9a22eefca','epson2.png','image/png',2405,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (96,81,'iclogo','1bfb345a-517c-11ea-ad1f-fed1829ccd5f','ericsson.png','image/png',4184,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (97,82,'iclogo','1bfb4a58-517c-11ea-ae94-4395a635356d','ess.png','image/png',3030,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (98,83,'iclogo','1bfb63da-517c-11ea-8083-9c1de13bafdf','etc.png','image/png',2189,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (99,84,'iclogo','1bfb7c30-517c-11ea-bf37-f1c1e1ea7e18','exar.png','image/png',2771,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (100,85,'iclogo','1bfb968e-517c-11ea-86dd-eaf0052b7e7b','excelsemi1.png','image/png',7632,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (101,85,'iclogo','1bfba174-517c-11ea-952a-b55ebce4fb74','excelsemi2.png','image/png',2339,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (102,85,'iclogo','1bfbacaa-517c-11ea-be29-1685ece46cba','exel.png','image/png',2771,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (103,86,'iclogo','1bfbc5fa-517c-11ea-959d-5c319a41f521','fairchil.png','image/png',1552,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (104,87,'iclogo','1bfbe0c6-517c-11ea-98db-05cfd383483e','freescale.png','image/png',3840,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (105,88,'iclogo','1bfbfbce-517c-11ea-9060-c6c9b647d7b4','fujielec.png','image/png',5048,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (106,88,'iclogo','1bfc0858-517c-11ea-95c2-055b6cb1116b','fujitsu2.png','image/png',1860,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (107,89,'iclogo','1bfc2360-517c-11ea-9be3-0f8b4bdcec36','galileo.png','image/png',3779,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (108,90,'iclogo','1bfc39f4-517c-11ea-a0d7-2359c3171477','galvant.png','image/png',2669,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (109,91,'iclogo','1bfc548e-517c-11ea-9c95-c21253387d8e','gecples.png','image/png',2312,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (110,92,'iclogo','1bfc6f00-517c-11ea-afe0-b59f0d9790ee','gennum.png','image/png',2614,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (111,93,'iclogo','1bfc86a2-517c-11ea-85f3-9287d9be2d26','ge.png','image/png',2321,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (112,94,'iclogo','1bfc9caa-517c-11ea-91c4-e5566819f23c','gi1.png','image/png',1385,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (113,94,'iclogo','1bfca5ec-517c-11ea-9727-250bd1d8d03d','gi.png','image/png',1691,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (114,95,'iclogo','1bfcbbe0-517c-11ea-98e6-b54f366c4785','glink.png','image/png',1706,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (115,96,'iclogo','1bfcd15c-517c-11ea-8bbc-89e6e97c734b','goal1.png','image/png',9092,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (116,96,'iclogo','1bfcdb8e-517c-11ea-83df-1bdb667d3784','goal2.png','image/png',9649,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (117,97,'iclogo','1bfcf29a-517c-11ea-8dca-ce6803b0fa42','goldstar1.png','image/png',2923,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (118,97,'iclogo','1bfcfba0-517c-11ea-9eb7-175b577ae714','goldstar2.png','image/png',11387,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (119,98,'iclogo','1bfd13ba-517c-11ea-bf22-05493d42da08','gould.png','image/png',1549,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (120,99,'iclogo','1bfd2a9e-517c-11ea-b1b6-046b268735a8','greenwich.png','image/png',9761,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (121,100,'iclogo','1bfd4326-517c-11ea-99d4-d12f48b5586f','gsemi.png','image/png',1704,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (122,101,'iclogo','1bfd5dc0-517c-11ea-b2c3-c45a7273a70f','harris1.png','image/png',1549,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (123,101,'iclogo','1bfd69dc-517c-11ea-bd3b-940b5a317d89','harris2.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (124,102,'iclogo','1bfd8264-517c-11ea-a5f5-e8b2a83b95d8','hfo.png','image/png',1958,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (125,103,'iclogo','1bfd9a6a-517c-11ea-acbc-5ab4fbe5088e','hitachi.png','image/png',2611,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (126,104,'iclogo','1bfdb572-517c-11ea-8e51-4a6a710fcb37','holtek.png','image/png',2160,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (127,105,'iclogo','1bfdce2c-517c-11ea-ac3d-ae0eb8a2a8fb','hp.png','image/png',2464,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (128,106,'iclogo','1bfde70e-517c-11ea-9a54-5d0b880141fd','hualon.png','image/png',2864,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (129,107,'iclogo','1bfdff6e-517c-11ea-8f96-52e6914ab4e4','hynix.png','image/png',8444,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (130,108,'iclogo','1bfe17ba-517c-11ea-bb15-5f7d54a0717c','hyundai2.png','image/png',2269,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (131,109,'iclogo','1bfe2d72-517c-11ea-8a2a-f6dafbea652a','icdesign.png','image/png',3014,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (132,110,'iclogo','1bfe41d6-517c-11ea-a559-ed0946b2e069','icd.png','image/png',1641,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (133,110,'iclogo','1bfe4a14-517c-11ea-9d6e-07c45d9e3672','ics.png','image/png',2042,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (134,111,'iclogo','1bfe6044-517c-11ea-833e-8bcdac840021','ichaus1.png','image/png',3370,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (135,111,'iclogo','1bfe694a-517c-11ea-af58-e981d014fd42','ichaus.png','image/png',1552,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (136,112,'iclogo','1bfe80e2-517c-11ea-ae64-49d37c814c9a','icsi.png','image/png',4049,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (137,113,'iclogo','1bfe9618-517c-11ea-b4eb-0cee245bf283','icube.png','image/png',1629,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (138,114,'iclogo','1bfeaba8-517c-11ea-af8d-a4e5813116a6','icworks.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (139,115,'iclogo','1bfec21e-517c-11ea-8bc8-30480dc1dea6','idt1.png','image/png',3995,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (140,115,'iclogo','1bfecb6a-517c-11ea-b72b-e176777267ee','idt.png','image/png',1553,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (141,116,'iclogo','1bfee122-517c-11ea-8530-17141168bd55','igstech.png','image/png',3832,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (142,117,'iclogo','1bfef7ca-517c-11ea-ad5a-3ae067957707','impala.png','image/png',1628,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (143,118,'iclogo','1bff0fda-517c-11ea-a958-35ac08edcac1','imp.png','image/png',2175,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (144,119,'iclogo','1bff2790-517c-11ea-abe0-f4d953ce7c7e','infineon.png','image/png',4511,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (145,120,'iclogo','1bff3de8-517c-11ea-a1ff-ed0fad37fd43','inmos.png','image/png',3365,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (146,121,'iclogo','1bff52d8-517c-11ea-a777-acdbbfd4fa57','intel2.png','image/png',2010,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (147,122,'iclogo','1bff66e2-517c-11ea-947e-cdba52b90f3d','intresil4.png','image/png',2614,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (148,122,'iclogo','1bff6ebc-517c-11ea-8c01-ce54dfb0c7c2','intrsil1.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (149,122,'iclogo','1bff76e6-517c-11ea-8bbf-709275240ff8','intrsil2.png','image/png',2520,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (150,122,'iclogo','1bff829e-517c-11ea-9baa-7e486e7dab62','intrsil3.png','image/png',3295,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (151,123,'iclogo','1bff9d7e-517c-11ea-a26b-0e60ade8fd3e','ir.png','image/png',2729,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (152,124,'iclogo','1bffb642-517c-11ea-b506-d2fe916b8b2c','isd.png','image/png',2554,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (153,125,'iclogo','1bffd28a-517c-11ea-ac6d-22001c97b5e5','issi.png','image/png',3030,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (154,126,'iclogo','1bffec52-517c-11ea-a9cf-401e56c6e1b7','ite.png','image/png',3302,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (155,127,'iclogo','1c000570-517c-11ea-ab6c-acb5469a8586','itt.png','image/png',2483,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (156,128,'iclogo','1c001f74-517c-11ea-b90e-5fc501a2e044','ixys.png','image/png',3575,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (157,129,'iclogo','1c003842-517c-11ea-9465-d28775ef9c48','kec.png','image/png',2567,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (158,130,'iclogo','1c004e9a-517c-11ea-af88-922808e4b75b','kota.png','image/png',1552,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (159,131,'iclogo','1c006506-517c-11ea-afb6-4c51e1e4a5c3','lattice1.png','image/png',1768,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (160,131,'iclogo','1c006e66-517c-11ea-8e08-5462bf3c1594','lattice2.png','image/png',1519,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (161,131,'iclogo','1c007726-517c-11ea-ba4d-bdd30d05962b','lattice3.png','image/png',1216,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (162,132,'iclogo','1c008efa-517c-11ea-a6eb-51e332125040','lds1.png','image/png',2136,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (163,132,'iclogo','1c0099b8-517c-11ea-a9fd-4bbf82cc2483','lds.png','image/png',1959,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (164,133,'iclogo','1c00b024-517c-11ea-a9ea-f6612c38b00e','levone.png','image/png',4189,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (165,134,'iclogo','1c00c9ba-517c-11ea-839a-063da728a1c3','lgs1.png','image/png',2417,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (166,134,'iclogo','1c00d374-517c-11ea-85c2-7d6d32b4f3c3','lgs.png','image/png',737,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (167,135,'iclogo','1c00eda0-517c-11ea-afde-79daf9208531','linear.png','image/png',2486,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (168,136,'iclogo','1c0106b4-517c-11ea-a202-fd908f7f22ee','linfin.png','image/png',4844,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (169,137,'iclogo','1c012162-517c-11ea-9a81-e995a332bc37','liteon.png','image/png',2388,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (170,138,'iclogo','1c013b3e-517c-11ea-80a4-2aa3478966ea','lucent.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (171,139,'iclogo','1c015416-517c-11ea-bca4-909d0dbe703b','macronix.png','image/png',2324,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (172,140,'iclogo','1c016d48-517c-11ea-a239-810b41df7b97','marvell.png','image/png',3131,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (173,141,'iclogo','1c018724-517c-11ea-b67a-0ca1cc0f28c1','matsush1.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (174,141,'iclogo','1c019250-517c-11ea-b94a-353b6456b126','matsushi.png','image/png',2029,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (175,142,'iclogo','1c01a998-517c-11ea-973d-b0655018261d','maxim.png','image/png',2690,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (176,143,'iclogo','1c01c068-517c-11ea-81e5-c24385c6515f','mediavi1.png','image/png',2189,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (177,143,'iclogo','1c01ca0e-517c-11ea-a5ac-f473ef1d085b','mediavi2.png','image/png',2487,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (178,144,'iclogo','1c01e386-517c-11ea-a622-c15bf4a48054','me.png','image/png',2411,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (179,144,'iclogo','1c01ef3e-517c-11ea-b1f1-76021c9e2dd9','microchp.png','image/png',2814,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (180,145,'iclogo','1c0208e8-517c-11ea-aaf0-32487cc4aeea','mhs2.png','image/png',2036,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (181,145,'iclogo','1c021414-517c-11ea-b3ed-c28eb6079886','mhs.png','image/png',1870,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (182,146,'iclogo','1c0229cc-517c-11ea-b83a-000b93a70a0e','micrel1.png','image/png',9695,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (183,146,'iclogo','1c0234bc-517c-11ea-8eb0-93e625e49c31','micrel2.png','image/png',9695,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (184,147,'iclogo','1c024a4c-517c-11ea-9c27-906076b4ba39','micronas.png','image/png',1871,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (185,148,'iclogo','1c026216-517c-11ea-9e86-40aa7b23bf2e','micronix.png','image/png',1856,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (186,149,'iclogo','1c027666-517c-11ea-b195-686cbbfc8dce','micron.png','image/png',1763,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (187,150,'iclogo','1c028d4a-517c-11ea-b9df-b3fdbcea5d82','microsemi1.png','image/png',3714,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (188,150,'iclogo','1c0298f8-517c-11ea-b218-c45dd384deef','microsemi2.png','image/png',11992,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (189,151,'iclogo','1c02b180-517c-11ea-bdb2-d2d6eb049447','minicirc.png','image/png',1391,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (190,152,'iclogo','1c02c904-517c-11ea-b67d-afeb389800ab','mitel.png','image/png',2819,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (191,153,'iclogo','1c02e196-517c-11ea-b32a-0ae758ede01b','mitsubis.png','image/png',2311,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (192,154,'iclogo','1c02f94c-517c-11ea-8d31-a90b54774436','mlinear.png','image/png',3377,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (193,155,'iclogo','1c030f4a-517c-11ea-89a3-5ff18e28f89a','mmi.png','image/png',2692,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (194,156,'iclogo','1c03264c-517c-11ea-b62e-63ded48d45e3','mosaic.png','image/png',2959,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (195,157,'iclogo','1c033e3e-517c-11ea-aa6e-295a944e6492','moselvit.png','image/png',2504,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (196,158,'iclogo','1c0355e0-517c-11ea-bf4c-e717b3328fb1','mos.png','image/png',2857,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (197,159,'iclogo','1c036f08-517c-11ea-bf43-999f653af02d','mostek1.png','image/png',7502,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (198,159,'iclogo','1c0379ee-517c-11ea-9b02-3bf48e6eaab9','mostek2.png','image/png',7502,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (199,159,'iclogo','1c0384f2-517c-11ea-9290-32805a3430f6','mostek3.png','image/png',2514,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (200,160,'iclogo','1c039b7c-517c-11ea-8d53-f043c2deb6ca','mosys.png','image/png',2321,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (201,161,'iclogo','1c03b2e2-517c-11ea-8ebb-01be54fdbdf9','motorol1.png','image/png',999,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (202,161,'iclogo','1c03bcd8-517c-11ea-afe8-cbb3c5e03c13','motorol2.png','image/png',2417,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (203,162,'iclogo','1c03d2ea-517c-11ea-a34d-a66320bbd0af','mpd.png','image/png',2663,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (204,163,'iclogo','1c03e974-517c-11ea-b074-f60a7a398d3e','msystem.png','image/png',1670,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (205,164,'iclogo','1c040260-517c-11ea-ac03-3aaf5dc1627d','murata1.png','image/png',4874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (206,164,'iclogo','1c040bd4-517c-11ea-8b18-9d21b1cecec6','murata.png','image/png',4777,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (207,165,'iclogo','1c042146-517c-11ea-b728-f1af7f5823da','mwave.png','image/png',3370,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (208,166,'iclogo','1c0438b6-517c-11ea-91a4-40317701bdee','myson.png','image/png',1932,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (209,167,'iclogo','1c044d56-517c-11ea-a73f-6124c8db30ce','nec1.png','image/png',3166,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (210,167,'iclogo','1c045530-517c-11ea-9a1e-ace96cd68b31','nec2.png','image/png',3071,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (211,168,'iclogo','1c04685e-517c-11ea-9361-24d3d2ad1761','nexflash.png','image/png',7789,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (212,169,'iclogo','1c047f6a-517c-11ea-9622-6860561ff933','njr.png','image/png',3419,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (213,170,'iclogo','1c0494e6-517c-11ea-b11c-1b21d20160c4','ns1.png','image/png',1959,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (214,170,'iclogo','1c049cac-517c-11ea-86c4-0ceab8233d46','ns2.png','image/png',1952,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (215,171,'iclogo','1c04b0ac-517c-11ea-8c67-ada0612fed55','nvidia.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (216,172,'iclogo','1c04cab0-517c-11ea-83b5-0023cd1d89c8','oak.png','image/png',2614,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (217,173,'iclogo','1c04e3ce-517c-11ea-8375-63787777febe','oki1.png','image/png',2267,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (218,173,'iclogo','1c04ed42-517c-11ea-ac34-8000feba210b','oki.png','image/png',2546,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (219,174,'iclogo','1c050340-517c-11ea-9946-f582cab0e1bd','opti.png','image/png',1684,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (220,175,'iclogo','1c051e84-517c-11ea-96c8-fafd2105d748','orbit.png','image/png',3347,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (221,176,'iclogo','1c053680-517c-11ea-a6f3-277c109d8a6f','oren.png','image/png',3497,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (222,177,'iclogo','1c054ec2-517c-11ea-844f-270877ad5696','perform.png','image/png',3284,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (223,178,'iclogo','1c05665a-517c-11ea-99b3-4acaf5fc9854','pericom.png','image/png',2311,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (224,179,'iclogo','1c057bcc-517c-11ea-8089-435334dd563a','phaslink.png','image/png',2669,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (225,180,'iclogo','1c0590c6-517c-11ea-926f-34b94eaf1902','philips.png','image/png',8690,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (226,181,'iclogo','1c05a80e-517c-11ea-9e30-e33221f6f0a4','plx.png','image/png',4749,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (227,182,'iclogo','1c05bff6-517c-11ea-b120-39c4b7530228','pmc.png','image/png',3497,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (228,183,'iclogo','1c05d7c0-517c-11ea-a6a3-af0f81d6cf9d','pmi.png','image/png',3807,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (229,184,'iclogo','1c05ef3a-517c-11ea-b73d-ce3eff1ee86c','ptc.png','image/png',2669,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (230,185,'iclogo','1c06063c-517c-11ea-97fb-feea529c5c72','pwrsmart.png','image/png',1389,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (231,186,'iclogo','1c061b18-517c-11ea-9647-186c8c43a9e3','qlogic.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (232,187,'iclogo','1c0630c6-517c-11ea-877b-80a4cb92e8fa','qualcomm.png','image/png',3326,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (233,188,'iclogo','1c0645ca-517c-11ea-bb75-12f5658e276e','quality.png','image/png',1309,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (234,189,'iclogo','1c065b6e-517c-11ea-bc6c-7cd93ce04c43','rabbit.png','image/png',2857,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (235,190,'iclogo','1c06719e-517c-11ea-aaf4-07313e0e9c74','ramtron.png','image/png',1573,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (236,191,'iclogo','1c06874c-517c-11ea-8e1d-51547328f4b5','raytheon.png','image/png',4303,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (237,192,'iclogo','1c06a3b2-517c-11ea-8d4d-ff6d78a6c2e9','rca.png','image/png',1860,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (238,193,'iclogo','1c06bb40-517c-11ea-880a-53bee4296b25','realtek.png','image/png',2993,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (239,194,'iclogo','1c06d580-517c-11ea-9336-9871318f8422','rectron.png','image/png',1691,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (240,195,'iclogo','1c06f146-517c-11ea-9989-c14fad4bd6ea','rendit.png','image/png',1370,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (241,196,'iclogo','1c070bcc-517c-11ea-9689-b9afafa26e25','renesas.png','image/png',8761,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (242,197,'iclogo','1c0727ec-517c-11ea-b133-74f25d1b7d8d','rockwell.png','image/png',1704,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (243,198,'iclogo','1c0742f4-517c-11ea-b4ae-338cc7624971','rohm.png','image/png',2693,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (244,199,'iclogo','1c075c30-517c-11ea-926d-226fdf1e4639','s3.png','image/png',2189,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (245,200,'iclogo','1c0775da-517c-11ea-8d9a-29d435e9092d','sage.png','image/png',2735,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (246,201,'iclogo','1c078ed0-517c-11ea-88fb-6e511e646f63','saifun.png','image/png',19242,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (247,202,'iclogo','1c07af82-517c-11ea-948c-6ccadf955d15','sames.png','image/png',2614,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (248,203,'iclogo','1c07c77e-517c-11ea-a083-dfd6889ff8d5','samsung.png','image/png',1841,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (249,204,'iclogo','1c07e43e-517c-11ea-967c-e9d1e43965c3','sanken1.png','image/png',2214,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (250,204,'iclogo','1c07f208-517c-11ea-9630-334688b21f8f','sanken.png','image/png',5309,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (251,205,'iclogo','1c080eaa-517c-11ea-875b-710ef452ec7f','sanyo1.png','image/png',2228,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (252,205,'iclogo','1c081c10-517c-11ea-b8b9-97487d91ea85','sanyo.png','image/png',2455,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (253,206,'iclogo','1c0836be-517c-11ea-b122-c02317eaf2d9','scenix.png','image/png',1869,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (254,207,'iclogo','1c085144-517c-11ea-8ddf-f9b7adf9fc7e','sec1.png','image/png',9392,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (255,207,'iclogo','1c085ffe-517c-11ea-9148-a7a7b72cd1a6','sec.png','image/png',2051,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (256,208,'iclogo','1c087aca-517c-11ea-a535-ad0400d0785f','seeq.png','image/png',2903,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (257,209,'iclogo','1c08969a-517c-11ea-bb99-7ed8fdf78efc','seikoi.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (258,209,'iclogo','1c08a3a6-517c-11ea-aeda-fba30c92bc5f','semelab.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (259,210,'iclogo','1c08beea-517c-11ea-a35c-96ffa9a7c509','semtech.png','image/png',1431,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (260,211,'iclogo','1c08da4c-517c-11ea-97b3-72424c0951d6','sgs1.png','image/png',2339,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (261,212,'iclogo','1c08f63a-517c-11ea-9d3b-cd6fccb9b34a','sgs2.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (262,213,'iclogo','1c090ee0-517c-11ea-bc50-298cbcc2f07b','sharp.png','image/png',2258,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (263,214,'iclogo','1c0926e6-517c-11ea-95c9-a0e63e26801b','shindgen.png','image/png',1629,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (264,215,'iclogo','1c09407c-517c-11ea-bdbf-1b48dfbc3f82','siemens1.png','image/png',1216,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (265,215,'iclogo','1c094b26-517c-11ea-831c-1cef32a858b2','siemens2.png','image/png',2916,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (266,216,'iclogo','1c096688-517c-11ea-85cc-db64fd8bb257','sierra.png','image/png',2321,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (267,217,'iclogo','1c09821c-517c-11ea-9a06-fa89108cd973','sigmatel.png','image/png',1790,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (268,218,'iclogo','1c0999c8-517c-11ea-918f-19ee711c3d38','signetic.png','image/png',1519,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (269,219,'iclogo','1c09b37c-517c-11ea-bce2-fd88b95ea8bd','siliconlabs.png','image/png',5540,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (270,220,'iclogo','1c09d122-517c-11ea-8b37-a171745dc985','siliconm.png','image/png',3817,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (271,221,'iclogo','1c09eb1c-517c-11ea-bdf1-4f38bf8dad38','silicons.png','image/png',2320,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (272,221,'iclogo','1c09f774-517c-11ea-a2d6-864f6a53237f','simtek.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (273,222,'iclogo','1c0a13f8-517c-11ea-b0fa-062e3cc44d2d','siliconx.png','image/png',2464,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (274,223,'iclogo','1c0a316c-517c-11ea-a4df-1f96e88298ce','silnans.png','image/png',1549,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (275,224,'iclogo','1c0a4d3c-517c-11ea-9f5b-1ba9d886caa5','sipex.png','image/png',4029,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (276,225,'iclogo','1c0a6786-517c-11ea-aab3-05026ba5c269','sis.png','image/png',3608,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (277,226,'iclogo','1c0a7ffa-517c-11ea-a1b7-295a2785bec3','smc1.png','image/png',1763,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (278,227,'iclogo','1c0a99a4-517c-11ea-ac2e-8c558d1fddea','smsc1.png','image/png',1781,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (279,227,'iclogo','1c0aa6ce-517c-11ea-b54b-c444098d7c8d','smsc.png','image/png',2117,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (280,228,'iclogo','1c0ac1fe-517c-11ea-9536-9bb2fd9a5b86','sony.png','image/png',2476,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (281,229,'iclogo','1c0adbee-517c-11ea-8f89-3c7e51df0277','space.png','image/png',3377,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (282,230,'iclogo','1c0af7f0-517c-11ea-be3d-536311ad51f8','spectek.png','image/png',2228,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (283,231,'iclogo','1c0b1014-517c-11ea-8c86-726446ba6ae5','spt.png','image/png',3419,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (284,232,'iclogo','1c0b2a90-517c-11ea-a19a-02d8b32b0ba5','sss.png','image/png',1871,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (285,233,'iclogo','1c0b4462-517c-11ea-b9ed-8388174dcc63','sst.png','image/png',3072,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (286,234,'iclogo','1c0b5d26-517c-11ea-bf6e-a401d8af9e02','st.png','image/png',1604,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (287,235,'iclogo','1c0b764e-517c-11ea-990d-ce7023a3a859','summit.png','image/png',11440,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (288,236,'iclogo','1c0b8f3a-517c-11ea-92f5-84d33ae2e347','synergy.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (289,237,'iclogo','1c0ba5ba-517c-11ea-9743-08386f480818','synertek.png','image/png',1789,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (290,238,'iclogo','1c0bbb9a-517c-11ea-8d66-18505514406d','taiwsemi.png','image/png',1475,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (291,239,'iclogo','1c0bd166-517c-11ea-b3a6-c95270af6d2f','tdk.png','image/png',3687,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (292,240,'iclogo','1c0be782-517c-11ea-b0ff-90e7b45462fe','teccor.png','image/png',1869,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (293,241,'iclogo','1c0bfda8-517c-11ea-979f-15d592d8c158','telcom.png','image/png',2555,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (294,242,'iclogo','1c0c132e-517c-11ea-82b4-078c8c95c31e','teledyne.png','image/png',1904,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (295,243,'iclogo','1c0c2904-517c-11ea-82fa-0cff1324b488','telefunk.png','image/png',2715,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (296,244,'iclogo','1c0c3eda-517c-11ea-acce-7c4dc69776ca','teltone.png','image/png',4303,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (297,245,'iclogo','1c0c58b6-517c-11ea-b5fb-3013ce098a99','thomscsf.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (298,246,'iclogo','1c0c7436-517c-11ea-9716-302dada7716a','ti1.png','image/png',1869,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (299,246,'iclogo','1c0c80f2-517c-11ea-ac66-4d136cec08f3','ti.png','image/png',1789,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (300,247,'iclogo','1c0c9cd6-517c-11ea-ac88-58d0882c88f3','toko.png','image/png',1907,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (301,248,'iclogo','1c0cb86a-517c-11ea-9d76-08d6f88fcb34','toshiba1.png','image/png',1922,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (302,248,'iclogo','1c0cc5bc-517c-11ea-900e-275f9183e6b9','toshiba2.png','image/png',1309,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (303,248,'iclogo','1c0cd2e6-517c-11ea-846e-6e6327a714c5','toshiba3.png','image/png',2269,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (304,249,'iclogo','1c0cedd0-517c-11ea-9fb7-9e85f317ef6d','trident.png','image/png',1414,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (305,250,'iclogo','1c0d0612-517c-11ea-a19d-3e7f543af34f','triquint.png','image/png',2294,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (306,251,'iclogo','1c0d214c-517c-11ea-9be2-102ad0c00d51','triscend.png','image/png',4521,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (307,252,'iclogo','1c0d3cf4-517c-11ea-b115-cb72f949089e','tseng.png','image/png',1466,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (308,253,'iclogo','1c0d5824-517c-11ea-aa67-b349aac71caa','tundra.png','image/png',1709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (309,254,'iclogo','1c0d7160-517c-11ea-b55e-7accfc5c477c','turbo_ic.png','image/png',7784,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (310,255,'iclogo','1c0d8dee-517c-11ea-9088-e015423b4ad5','ubicom.png','image/png',2047,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (311,256,'iclogo','1c0da928-517c-11ea-99b1-2dfc4d90ec87','umc.png','image/png',3032,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (312,257,'iclogo','1c0dc516-517c-11ea-80bb-a9a9739b779a','unitrode.png','image/png',1309,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (313,258,'iclogo','1c0de0c8-517c-11ea-ac5c-8bddf99acce6','usar1.png','image/png',2771,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (314,258,'iclogo','1c0def00-517c-11ea-ad70-0d7666847c17','usar.png','image/png',2793,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (315,259,'iclogo','1c0e0b20-517c-11ea-b2f6-ee77d3ffaf3f','utmc.png','image/png',2047,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (316,260,'iclogo','1c0e2678-517c-11ea-bbf4-2b8cc2e082b5','utron.png','image/png',2047,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (317,261,'iclogo','1c0e423e-517c-11ea-b759-9409a88533d7','v3.png','image/png',3248,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (318,262,'iclogo','1c0e5e04-517c-11ea-8a0f-376eea0bee6c','vadem.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (319,263,'iclogo','1c0e7876-517c-11ea-a914-badcea1efc0f','vanguard.png','image/png',1454,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (320,264,'iclogo','1c0e94c8-517c-11ea-bf66-41221a342775','vantis.png','image/png',1475,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (321,265,'iclogo','1c0eaeea-517c-11ea-8d38-cac7c9477d88','via.png','image/png',1922,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (322,266,'iclogo','1c0ec8d0-517c-11ea-ac07-98cada6476cc','virata.png','image/png',3764,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (323,267,'iclogo','1c0ee0b8-517c-11ea-a7ff-8e2f79414576','vishay.png','image/png',4410,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (324,268,'iclogo','1c0ef7ba-517c-11ea-86ed-4f740cd530ed','vistech.png','image/png',1942,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (325,269,'iclogo','1c0f0e3a-517c-11ea-b3c5-85841275bc70','vitelic.png','image/png',1691,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (326,270,'iclogo','1c0f2762-517c-11ea-b2b7-52fadbb768d8','vlsi.png','image/png',1874,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (327,271,'iclogo','1c0f3e32-517c-11ea-acf7-4dcdd4aa1ac1','volterra.png','image/png',2029,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (328,272,'iclogo','1c0f555c-517c-11ea-a6bc-e7f695ee407b','vtc.png','image/png',2223,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (329,273,'iclogo','1c0f6bbe-517c-11ea-8a9a-4fb4583341b6','wafscale.png','image/png',2985,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (330,274,'iclogo','1c0f8004-517c-11ea-8c05-b43d04e5e3f1','wdc1.png','image/png',1784,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (331,274,'iclogo','1c0f88ba-517c-11ea-ad37-90dc024ad52f','wdc2.png','image/png',1403,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (332,275,'iclogo','1c0f9fc6-517c-11ea-a913-9af8c6316c4c','weitek.png','image/png',1468,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (333,276,'iclogo','1c0fb8e4-517c-11ea-8aee-7fce4cfceb26','winbond.png','image/png',5402,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (334,277,'iclogo','1c0fd2fc-517c-11ea-a208-3de00791a5d1','wolf.png','image/png',2343,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (335,278,'iclogo','1c0febc0-517c-11ea-bc93-3a920704ed1f','xemics.png','image/png',2029,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (336,279,'iclogo','1c1006a0-517c-11ea-a8c5-3cb725704fee','xicor1.png','image/png',1259,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (337,279,'iclogo','1c101294-517c-11ea-821f-7b98c1f341b8','xicor.png','image/png',3389,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (338,280,'iclogo','1c102e32-517c-11ea-a464-12216c5183b7','xilinx.png','image/png',4186,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (339,281,'iclogo','1c104908-517c-11ea-afe2-e2328b8d09e3','yamaha.png','image/png',1779,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (340,282,'iclogo','1c106168-517c-11ea-ab1c-f405d22f0595','zetex.png','image/png',1255,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (341,283,'iclogo','1c107658-517c-11ea-831c-70746e0710f8','zilog1.png','image/png',1958,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (342,283,'iclogo','1c108080-517c-11ea-b6d9-664ee50fe109','zilog2.png','image/png',2204,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (343,283,'iclogo','1c108a4e-517c-11ea-a62d-706a26744fcc','zilog3.png','image/png',2614,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (344,283,'iclogo','1c109430-517c-11ea-a624-80b2229a137f','zilog4.png','image/png',2405,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (345,284,'iclogo','1c10aa60-517c-11ea-8ac5-71d1750e8d1c','zmda.png','image/png',3709,'png',NULL,'2020-02-17 11:53:27');
+INSERT INTO `ManufacturerICLogo` VALUES (346,285,'iclogo','1c10c18a-517c-11ea-a781-aaffe43be5d4','zoran.png','image/png',2784,'png',NULL,'2020-02-17 11:53:27');
+/*!40000 ALTER TABLE `ManufacturerICLogo` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `MetaPartParameterCriteria`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `MetaPartParameterCriteria` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `unit_id` int(11) DEFAULT NULL,
+ `partParameterName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `operator` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `value` double DEFAULT NULL,
+ `normalizedValue` double DEFAULT NULL,
+ `stringValue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `valueType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `siPrefix_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_6EE1D3924CE34BEC` (`part_id`),
+ KEY `IDX_6EE1D39219187357` (`siPrefix_id`),
+ KEY `IDX_6EE1D392F8BD700D` (`unit_id`),
+ CONSTRAINT `FK_6EE1D39219187357` FOREIGN KEY (`siPrefix_id`) REFERENCES `SiPrefix` (`id`),
+ CONSTRAINT `FK_6EE1D3924CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`),
+ CONSTRAINT `FK_6EE1D392F8BD700D` FOREIGN KEY (`unit_id`) REFERENCES `Unit` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `MetaPartParameterCriteria` WRITE;
+/*!40000 ALTER TABLE `MetaPartParameterCriteria` DISABLE KEYS */;
+/*!40000 ALTER TABLE `MetaPartParameterCriteria` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `Part`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Part` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `category_id` int(11) DEFAULT NULL,
+ `footprint_id` int(11) DEFAULT NULL,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `comment` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `stockLevel` int(11) NOT NULL,
+ `minStockLevel` int(11) NOT NULL,
+ `averagePrice` decimal(13,4) NOT NULL,
+ `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `needsReview` tinyint(1) NOT NULL,
+ `partCondition` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `productionRemarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `createDate` datetime DEFAULT NULL,
+ `internalPartNumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `removals` tinyint(1) NOT NULL,
+ `lowStock` tinyint(1) NOT NULL,
+ `metaPart` tinyint(1) NOT NULL DEFAULT '0',
+ `partUnit_id` int(11) DEFAULT NULL,
+ `storageLocation_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_E93DDFF812469DE2` (`category_id`),
+ KEY `IDX_E93DDFF851364C98` (`footprint_id`),
+ KEY `IDX_E93DDFF8F7A36E87` (`partUnit_id`),
+ KEY `IDX_E93DDFF873CD58AF` (`storageLocation_id`),
+ CONSTRAINT `FK_E93DDFF812469DE2` FOREIGN KEY (`category_id`) REFERENCES `PartCategory` (`id`),
+ CONSTRAINT `FK_E93DDFF851364C98` FOREIGN KEY (`footprint_id`) REFERENCES `Footprint` (`id`),
+ CONSTRAINT `FK_E93DDFF873CD58AF` FOREIGN KEY (`storageLocation_id`) REFERENCES `StorageLocation` (`id`),
+ CONSTRAINT `FK_E93DDFF8F7A36E87` FOREIGN KEY (`partUnit_id`) REFERENCES `PartUnit` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `Part` WRITE;
+/*!40000 ALTER TABLE `Part` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Part` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `PartAttachment`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PartAttachment` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ `isImage` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_76D73D864CE34BEC` (`part_id`),
+ CONSTRAINT `FK_76D73D864CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `PartAttachment` WRITE;
+/*!40000 ALTER TABLE `PartAttachment` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PartAttachment` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `PartCategory`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PartCategory` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `parent_id` int(11) DEFAULT NULL,
+ `lft` int(11) NOT NULL,
+ `rgt` int(11) NOT NULL,
+ `lvl` int(11) NOT NULL,
+ `root` int(11) DEFAULT NULL,
+ `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `categoryPath` longtext COLLATE utf8_unicode_ci,
+ PRIMARY KEY (`id`),
+ KEY `IDX_131FB619727ACA70` (`parent_id`),
+ KEY `IDX_131FB619DA439252` (`lft`),
+ KEY `IDX_131FB619D5E02D69` (`rgt`),
+ CONSTRAINT `FK_131FB619727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `PartCategory` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `PartCategory` WRITE;
+/*!40000 ALTER TABLE `PartCategory` DISABLE KEYS */;
+INSERT INTO `PartCategory` VALUES (1,NULL,1,2,0,1,'Root Category',NULL,'Root Category');
+/*!40000 ALTER TABLE `PartCategory` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `PartDistributor`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PartDistributor` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `distributor_id` int(11) DEFAULT NULL,
+ `orderNumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `packagingUnit` int(11) NOT NULL,
+ `price` decimal(13,4) DEFAULT NULL,
+ `currency` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `sku` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `ignoreForReports` tinyint(1) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_FBA293844CE34BEC` (`part_id`),
+ KEY `IDX_FBA293842D863A58` (`distributor_id`),
+ CONSTRAINT `FK_FBA293842D863A58` FOREIGN KEY (`distributor_id`) REFERENCES `Distributor` (`id`),
+ CONSTRAINT `FK_FBA293844CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `PartDistributor` WRITE;
+/*!40000 ALTER TABLE `PartDistributor` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PartDistributor` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `PartKeeprUser`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PartKeeprUser` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `provider_id` int(11) DEFAULT NULL,
+ `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
+ `password` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `admin` tinyint(1) NOT NULL,
+ `legacy` tinyint(1) NOT NULL,
+ `lastSeen` datetime DEFAULT NULL,
+ `active` tinyint(1) NOT NULL,
+ `protected` tinyint(1) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `username_provider` (`username`,`provider_id`),
+ KEY `IDX_7572D706A53A8AA` (`provider_id`),
+ CONSTRAINT `FK_7572D706A53A8AA` FOREIGN KEY (`provider_id`) REFERENCES `UserProvider` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `PartKeeprUser` WRITE;
+/*!40000 ALTER TABLE `PartKeeprUser` DISABLE KEYS */;
+INSERT INTO `PartKeeprUser` VALUES (1,1,'admin',NULL,NULL,0,0,NULL,1,0);
+/*!40000 ALTER TABLE `PartKeeprUser` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `PartManufacturer`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PartManufacturer` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `manufacturer_id` int(11) DEFAULT NULL,
+ `partNumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_F085878B4CE34BEC` (`part_id`),
+ KEY `IDX_F085878BA23B42D` (`manufacturer_id`),
+ CONSTRAINT `FK_F085878B4CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`),
+ CONSTRAINT `FK_F085878BA23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `Manufacturer` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `PartManufacturer` WRITE;
+/*!40000 ALTER TABLE `PartManufacturer` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PartManufacturer` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `PartParameter`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PartParameter` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `unit_id` int(11) DEFAULT NULL,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `value` double DEFAULT NULL,
+ `normalizedValue` double DEFAULT NULL,
+ `maximumValue` double DEFAULT NULL,
+ `normalizedMaxValue` double DEFAULT NULL,
+ `minimumValue` double DEFAULT NULL,
+ `normalizedMinValue` double DEFAULT NULL,
+ `stringValue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `valueType` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `siPrefix_id` int(11) DEFAULT NULL,
+ `minSiPrefix_id` int(11) DEFAULT NULL,
+ `maxSiPrefix_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_A28A98594CE34BEC` (`part_id`),
+ KEY `IDX_A28A9859F8BD700D` (`unit_id`),
+ KEY `IDX_A28A985919187357` (`siPrefix_id`),
+ KEY `IDX_A28A9859569AA479` (`minSiPrefix_id`),
+ KEY `IDX_A28A9859EFBC3F08` (`maxSiPrefix_id`),
+ CONSTRAINT `FK_A28A985919187357` FOREIGN KEY (`siPrefix_id`) REFERENCES `SiPrefix` (`id`),
+ CONSTRAINT `FK_A28A98594CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`),
+ CONSTRAINT `FK_A28A9859569AA479` FOREIGN KEY (`minSiPrefix_id`) REFERENCES `SiPrefix` (`id`),
+ CONSTRAINT `FK_A28A9859EFBC3F08` FOREIGN KEY (`maxSiPrefix_id`) REFERENCES `SiPrefix` (`id`),
+ CONSTRAINT `FK_A28A9859F8BD700D` FOREIGN KEY (`unit_id`) REFERENCES `Unit` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `PartParameter` WRITE;
+/*!40000 ALTER TABLE `PartParameter` DISABLE KEYS */;
+/*!40000 ALTER TABLE `PartParameter` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `PartUnit`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `PartUnit` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `shortName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `is_default` tinyint(1) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `PartUnit` WRITE;
+/*!40000 ALTER TABLE `PartUnit` DISABLE KEYS */;
+INSERT INTO `PartUnit` VALUES (1,'Pieces','pcs',1);
+/*!40000 ALTER TABLE `PartUnit` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `Project`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Project` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `user_id` int(11) DEFAULT NULL,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_E00EE972A76ED395` (`user_id`),
+ CONSTRAINT `FK_E00EE972A76ED395` FOREIGN KEY (`user_id`) REFERENCES `PartKeeprUser` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `Project` WRITE;
+/*!40000 ALTER TABLE `Project` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Project` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ProjectAttachment`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProjectAttachment` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `project_id` int(11) DEFAULT NULL,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_44010C5B166D1F9C` (`project_id`),
+ CONSTRAINT `FK_44010C5B166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `Project` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ProjectAttachment` WRITE;
+/*!40000 ALTER TABLE `ProjectAttachment` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ProjectAttachment` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ProjectPart`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProjectPart` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `project_id` int(11) DEFAULT NULL,
+ `quantity` int(11) NOT NULL,
+ `remarks` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `overageType` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
+ `overage` int(11) NOT NULL DEFAULT '0',
+ `lotNumber` longtext COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_B0B193364CE34BEC` (`part_id`),
+ KEY `IDX_B0B19336166D1F9C` (`project_id`),
+ CONSTRAINT `FK_B0B19336166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `Project` (`id`),
+ CONSTRAINT `FK_B0B193364CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ProjectPart` WRITE;
+/*!40000 ALTER TABLE `ProjectPart` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ProjectPart` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ProjectRun`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProjectRun` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `project_id` int(11) DEFAULT NULL,
+ `runDateTime` datetime NOT NULL,
+ `quantity` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_574A3B5C166D1F9C` (`project_id`),
+ CONSTRAINT `FK_574A3B5C166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `Project` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ProjectRun` WRITE;
+/*!40000 ALTER TABLE `ProjectRun` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ProjectRun` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ProjectRunPart`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ProjectRunPart` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `quantity` int(11) NOT NULL,
+ `lotNumber` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `projectRun_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_BF41064B1A221EF0` (`projectRun_id`),
+ KEY `IDX_BF41064B4CE34BEC` (`part_id`),
+ CONSTRAINT `FK_BF41064B1A221EF0` FOREIGN KEY (`projectRun_id`) REFERENCES `ProjectRun` (`id`),
+ CONSTRAINT `FK_BF41064B4CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ProjectRunPart` WRITE;
+/*!40000 ALTER TABLE `ProjectRunPart` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ProjectRunPart` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `Report`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Report` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `createDateTime` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `Report` WRITE;
+/*!40000 ALTER TABLE `Report` DISABLE KEYS */;
+/*!40000 ALTER TABLE `Report` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ReportPart`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ReportPart` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `report_id` int(11) DEFAULT NULL,
+ `part_id` int(11) DEFAULT NULL,
+ `distributor_id` int(11) DEFAULT NULL,
+ `quantity` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_1BF0BD554BD2A4C0` (`report_id`),
+ KEY `IDX_1BF0BD554CE34BEC` (`part_id`),
+ KEY `IDX_1BF0BD552D863A58` (`distributor_id`),
+ CONSTRAINT `FK_1BF0BD552D863A58` FOREIGN KEY (`distributor_id`) REFERENCES `Distributor` (`id`),
+ CONSTRAINT `FK_1BF0BD554BD2A4C0` FOREIGN KEY (`report_id`) REFERENCES `Report` (`id`),
+ CONSTRAINT `FK_1BF0BD554CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ReportPart` WRITE;
+/*!40000 ALTER TABLE `ReportPart` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ReportPart` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `ReportProject`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `ReportProject` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `report_id` int(11) DEFAULT NULL,
+ `project_id` int(11) DEFAULT NULL,
+ `quantity` int(11) NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_83B0909B4BD2A4C0` (`report_id`),
+ KEY `IDX_83B0909B166D1F9C` (`project_id`),
+ CONSTRAINT `FK_83B0909B166D1F9C` FOREIGN KEY (`project_id`) REFERENCES `Project` (`id`),
+ CONSTRAINT `FK_83B0909B4BD2A4C0` FOREIGN KEY (`report_id`) REFERENCES `Report` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `ReportProject` WRITE;
+/*!40000 ALTER TABLE `ReportProject` DISABLE KEYS */;
+/*!40000 ALTER TABLE `ReportProject` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `SchemaVersions`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SchemaVersions` (
+ `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`version`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `SchemaVersions` WRITE;
+/*!40000 ALTER TABLE `SchemaVersions` DISABLE KEYS */;
+INSERT INTO `SchemaVersions` VALUES ('20150608120000');
+INSERT INTO `SchemaVersions` VALUES ('20150708120022');
+INSERT INTO `SchemaVersions` VALUES ('20150724174030');
+INSERT INTO `SchemaVersions` VALUES ('20151001180120');
+INSERT INTO `SchemaVersions` VALUES ('20151002183125');
+INSERT INTO `SchemaVersions` VALUES ('20151031163951');
+INSERT INTO `SchemaVersions` VALUES ('20151208162723');
+INSERT INTO `SchemaVersions` VALUES ('20160103145302');
+INSERT INTO `SchemaVersions` VALUES ('20170108122512');
+INSERT INTO `SchemaVersions` VALUES ('20170108143802');
+INSERT INTO `SchemaVersions` VALUES ('20170113203042');
+INSERT INTO `SchemaVersions` VALUES ('20170601175559');
+/*!40000 ALTER TABLE `SchemaVersions` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `SiPrefix`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SiPrefix` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `prefix` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `symbol` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
+ `exponent` int(11) NOT NULL,
+ `base` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `SiPrefix` WRITE;
+/*!40000 ALTER TABLE `SiPrefix` DISABLE KEYS */;
+INSERT INTO `SiPrefix` VALUES (1,'yotta','Y',24,10);
+INSERT INTO `SiPrefix` VALUES (2,'zetta','Z',21,10);
+INSERT INTO `SiPrefix` VALUES (3,'exa','E',18,10);
+INSERT INTO `SiPrefix` VALUES (4,'peta','P',15,10);
+INSERT INTO `SiPrefix` VALUES (5,'tera','T',12,10);
+INSERT INTO `SiPrefix` VALUES (6,'giga','G',9,10);
+INSERT INTO `SiPrefix` VALUES (7,'mega','M',6,10);
+INSERT INTO `SiPrefix` VALUES (8,'kilo','k',3,10);
+INSERT INTO `SiPrefix` VALUES (9,'hecto','h',2,10);
+INSERT INTO `SiPrefix` VALUES (10,'deca','da',1,10);
+INSERT INTO `SiPrefix` VALUES (11,'-','',0,10);
+INSERT INTO `SiPrefix` VALUES (12,'deci','d',-1,10);
+INSERT INTO `SiPrefix` VALUES (13,'centi','c',-2,10);
+INSERT INTO `SiPrefix` VALUES (14,'milli','m',-3,10);
+INSERT INTO `SiPrefix` VALUES (15,'micro','μ',-6,10);
+INSERT INTO `SiPrefix` VALUES (16,'nano','n',-9,10);
+INSERT INTO `SiPrefix` VALUES (17,'pico','p',-12,10);
+INSERT INTO `SiPrefix` VALUES (18,'femto','f',-15,10);
+INSERT INTO `SiPrefix` VALUES (19,'atto','a',-18,10);
+INSERT INTO `SiPrefix` VALUES (20,'zepto','z',-21,10);
+INSERT INTO `SiPrefix` VALUES (21,'yocto','y',-24,10);
+INSERT INTO `SiPrefix` VALUES (22,'kibi','Ki',1,1024);
+INSERT INTO `SiPrefix` VALUES (23,'mebi','Mi',2,1024);
+INSERT INTO `SiPrefix` VALUES (24,'gibi','Gi',3,1024);
+INSERT INTO `SiPrefix` VALUES (25,'tebi','Ti',4,1024);
+INSERT INTO `SiPrefix` VALUES (26,'pebi','Pi',5,1024);
+INSERT INTO `SiPrefix` VALUES (27,'exbi','Ei',6,1024);
+INSERT INTO `SiPrefix` VALUES (28,'zebi','Zi',7,1024);
+INSERT INTO `SiPrefix` VALUES (29,'yobi','Yi',8,1024);
+/*!40000 ALTER TABLE `SiPrefix` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `StatisticSnapshot`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `StatisticSnapshot` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `dateTime` datetime NOT NULL,
+ `parts` int(11) NOT NULL,
+ `categories` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `StatisticSnapshot` WRITE;
+/*!40000 ALTER TABLE `StatisticSnapshot` DISABLE KEYS */;
+INSERT INTO `StatisticSnapshot` VALUES (1,'2020-02-17 11:53:56',0,1);
+INSERT INTO `StatisticSnapshot` VALUES (2,'2020-02-18 08:54:12',0,1);
+INSERT INTO `StatisticSnapshot` VALUES (3,'2020-02-19 12:25:02',0,1);
+/*!40000 ALTER TABLE `StatisticSnapshot` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `StatisticSnapshotUnit`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `StatisticSnapshotUnit` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `stockLevel` int(11) NOT NULL,
+ `statisticSnapshot_id` int(11) DEFAULT NULL,
+ `partUnit_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_368BD669A16DD05F` (`statisticSnapshot_id`),
+ KEY `IDX_368BD669F7A36E87` (`partUnit_id`),
+ CONSTRAINT `FK_368BD669A16DD05F` FOREIGN KEY (`statisticSnapshot_id`) REFERENCES `StatisticSnapshot` (`id`),
+ CONSTRAINT `FK_368BD669F7A36E87` FOREIGN KEY (`partUnit_id`) REFERENCES `PartUnit` (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `StatisticSnapshotUnit` WRITE;
+/*!40000 ALTER TABLE `StatisticSnapshotUnit` DISABLE KEYS */;
+INSERT INTO `StatisticSnapshotUnit` VALUES (1,0,1,1);
+INSERT INTO `StatisticSnapshotUnit` VALUES (2,0,2,1);
+INSERT INTO `StatisticSnapshotUnit` VALUES (3,0,3,1);
+/*!40000 ALTER TABLE `StatisticSnapshotUnit` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `StockEntry`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `StockEntry` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `part_id` int(11) DEFAULT NULL,
+ `user_id` int(11) DEFAULT NULL,
+ `stockLevel` int(11) NOT NULL,
+ `price` decimal(13,4) DEFAULT NULL,
+ `dateTime` datetime NOT NULL,
+ `correction` tinyint(1) NOT NULL,
+ `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_E182997B4CE34BEC` (`part_id`),
+ KEY `IDX_E182997BA76ED395` (`user_id`),
+ CONSTRAINT `FK_E182997B4CE34BEC` FOREIGN KEY (`part_id`) REFERENCES `Part` (`id`),
+ CONSTRAINT `FK_E182997BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `PartKeeprUser` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `StockEntry` WRITE;
+/*!40000 ALTER TABLE `StockEntry` DISABLE KEYS */;
+/*!40000 ALTER TABLE `StockEntry` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `StorageLocation`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `StorageLocation` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `category_id` int(11) DEFAULT NULL,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_2C59071C5E237E06` (`name`),
+ KEY `IDX_2C59071C12469DE2` (`category_id`),
+ CONSTRAINT `FK_2C59071C12469DE2` FOREIGN KEY (`category_id`) REFERENCES `StorageLocationCategory` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `StorageLocation` WRITE;
+/*!40000 ALTER TABLE `StorageLocation` DISABLE KEYS */;
+/*!40000 ALTER TABLE `StorageLocation` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `StorageLocationCategory`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `StorageLocationCategory` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `parent_id` int(11) DEFAULT NULL,
+ `lft` int(11) NOT NULL,
+ `rgt` int(11) NOT NULL,
+ `lvl` int(11) NOT NULL,
+ `root` int(11) DEFAULT NULL,
+ `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `categoryPath` longtext COLLATE utf8_unicode_ci,
+ PRIMARY KEY (`id`),
+ KEY `IDX_3E39FA47727ACA70` (`parent_id`),
+ KEY `IDX_3E39FA47DA439252` (`lft`),
+ KEY `IDX_3E39FA47D5E02D69` (`rgt`),
+ CONSTRAINT `FK_3E39FA47727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `StorageLocationCategory` (`id`) ON DELETE CASCADE
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `StorageLocationCategory` WRITE;
+/*!40000 ALTER TABLE `StorageLocationCategory` DISABLE KEYS */;
+INSERT INTO `StorageLocationCategory` VALUES (1,NULL,1,2,0,1,'Root Category',NULL,'Root Category');
+/*!40000 ALTER TABLE `StorageLocationCategory` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `StorageLocationImage`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `StorageLocationImage` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ `storageLocation_id` int(11) DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `UNIQ_666717F073CD58AF` (`storageLocation_id`),
+ CONSTRAINT `FK_666717F073CD58AF` FOREIGN KEY (`storageLocation_id`) REFERENCES `StorageLocation` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `StorageLocationImage` WRITE;
+/*!40000 ALTER TABLE `StorageLocationImage` DISABLE KEYS */;
+/*!40000 ALTER TABLE `StorageLocationImage` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `SystemNotice`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SystemNotice` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `date` datetime NOT NULL,
+ `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `description` longtext COLLATE utf8_unicode_ci NOT NULL,
+ `acknowledged` tinyint(1) NOT NULL,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `SystemNotice` WRITE;
+/*!40000 ALTER TABLE `SystemNotice` DISABLE KEYS */;
+/*!40000 ALTER TABLE `SystemNotice` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `SystemPreference`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `SystemPreference` (
+ `preferenceKey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `preferenceValue` longtext COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`preferenceKey`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `SystemPreference` WRITE;
+/*!40000 ALTER TABLE `SystemPreference` DISABLE KEYS */;
+/*!40000 ALTER TABLE `SystemPreference` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `TempImage`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TempImage` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `TempImage` WRITE;
+/*!40000 ALTER TABLE `TempImage` DISABLE KEYS */;
+/*!40000 ALTER TABLE `TempImage` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `TempUploadedFile`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TempUploadedFile` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `originalname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `mimetype` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `size` int(11) NOT NULL,
+ `extension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `description` longtext COLLATE utf8_unicode_ci,
+ `created` datetime NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `TempUploadedFile` WRITE;
+/*!40000 ALTER TABLE `TempUploadedFile` DISABLE KEYS */;
+/*!40000 ALTER TABLE `TempUploadedFile` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `TipOfTheDay`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TipOfTheDay` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `TipOfTheDay` WRITE;
+/*!40000 ALTER TABLE `TipOfTheDay` DISABLE KEYS */;
+/*!40000 ALTER TABLE `TipOfTheDay` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `TipOfTheDayHistory`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `TipOfTheDayHistory` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `user_id` int(11) DEFAULT NULL,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`),
+ KEY `IDX_3177BC2A76ED395` (`user_id`),
+ CONSTRAINT `FK_3177BC2A76ED395` FOREIGN KEY (`user_id`) REFERENCES `PartKeeprUser` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `TipOfTheDayHistory` WRITE;
+/*!40000 ALTER TABLE `TipOfTheDayHistory` DISABLE KEYS */;
+/*!40000 ALTER TABLE `TipOfTheDayHistory` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `Unit`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `Unit` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `symbol` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `Unit` WRITE;
+/*!40000 ALTER TABLE `Unit` DISABLE KEYS */;
+INSERT INTO `Unit` VALUES (1,'Meter','m');
+INSERT INTO `Unit` VALUES (2,'Gram','g');
+INSERT INTO `Unit` VALUES (3,'Second','s');
+INSERT INTO `Unit` VALUES (4,'Kelvin','K');
+INSERT INTO `Unit` VALUES (5,'Mol','mol');
+INSERT INTO `Unit` VALUES (6,'Candela','cd');
+INSERT INTO `Unit` VALUES (7,'Ampere','A');
+INSERT INTO `Unit` VALUES (8,'Ohm','Ω');
+INSERT INTO `Unit` VALUES (9,'Volt','V');
+INSERT INTO `Unit` VALUES (10,'Hertz','Hz');
+INSERT INTO `Unit` VALUES (11,'Newton','N');
+INSERT INTO `Unit` VALUES (12,'Pascal','Pa');
+INSERT INTO `Unit` VALUES (13,'Joule','J');
+INSERT INTO `Unit` VALUES (14,'Watt','W');
+INSERT INTO `Unit` VALUES (15,'Coulomb','C');
+INSERT INTO `Unit` VALUES (16,'Farad','F');
+INSERT INTO `Unit` VALUES (17,'Siemens','S');
+INSERT INTO `Unit` VALUES (18,'Weber','Wb');
+INSERT INTO `Unit` VALUES (19,'Tesla','T');
+INSERT INTO `Unit` VALUES (20,'Henry','H');
+INSERT INTO `Unit` VALUES (21,'Celsius','°C');
+INSERT INTO `Unit` VALUES (22,'Lumen','lm');
+INSERT INTO `Unit` VALUES (23,'Lux','lx');
+INSERT INTO `Unit` VALUES (24,'Becquerel','Bq');
+INSERT INTO `Unit` VALUES (25,'Gray','Gy');
+INSERT INTO `Unit` VALUES (26,'Sievert','Sv');
+INSERT INTO `Unit` VALUES (27,'Katal','kat');
+INSERT INTO `Unit` VALUES (28,'Ampere Hour','Ah');
+/*!40000 ALTER TABLE `Unit` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `UnitSiPrefixes`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UnitSiPrefixes` (
+ `unit_id` int(11) NOT NULL,
+ `siprefix_id` int(11) NOT NULL,
+ PRIMARY KEY (`unit_id`,`siprefix_id`),
+ KEY `IDX_72356740F8BD700D` (`unit_id`),
+ KEY `IDX_723567409BE9F1F4` (`siprefix_id`),
+ CONSTRAINT `FK_723567409BE9F1F4` FOREIGN KEY (`siprefix_id`) REFERENCES `SiPrefix` (`id`),
+ CONSTRAINT `FK_72356740F8BD700D` FOREIGN KEY (`unit_id`) REFERENCES `Unit` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `UnitSiPrefixes` WRITE;
+/*!40000 ALTER TABLE `UnitSiPrefixes` DISABLE KEYS */;
+INSERT INTO `UnitSiPrefixes` VALUES (1,8);
+INSERT INTO `UnitSiPrefixes` VALUES (1,11);
+INSERT INTO `UnitSiPrefixes` VALUES (1,12);
+INSERT INTO `UnitSiPrefixes` VALUES (1,13);
+INSERT INTO `UnitSiPrefixes` VALUES (1,14);
+INSERT INTO `UnitSiPrefixes` VALUES (1,15);
+INSERT INTO `UnitSiPrefixes` VALUES (1,16);
+INSERT INTO `UnitSiPrefixes` VALUES (2,8);
+INSERT INTO `UnitSiPrefixes` VALUES (2,11);
+INSERT INTO `UnitSiPrefixes` VALUES (2,14);
+INSERT INTO `UnitSiPrefixes` VALUES (3,11);
+INSERT INTO `UnitSiPrefixes` VALUES (3,14);
+INSERT INTO `UnitSiPrefixes` VALUES (4,11);
+INSERT INTO `UnitSiPrefixes` VALUES (5,11);
+INSERT INTO `UnitSiPrefixes` VALUES (6,14);
+INSERT INTO `UnitSiPrefixes` VALUES (7,8);
+INSERT INTO `UnitSiPrefixes` VALUES (7,11);
+INSERT INTO `UnitSiPrefixes` VALUES (7,14);
+INSERT INTO `UnitSiPrefixes` VALUES (7,15);
+INSERT INTO `UnitSiPrefixes` VALUES (7,16);
+INSERT INTO `UnitSiPrefixes` VALUES (7,17);
+INSERT INTO `UnitSiPrefixes` VALUES (8,5);
+INSERT INTO `UnitSiPrefixes` VALUES (8,6);
+INSERT INTO `UnitSiPrefixes` VALUES (8,8);
+INSERT INTO `UnitSiPrefixes` VALUES (8,11);
+INSERT INTO `UnitSiPrefixes` VALUES (8,14);
+INSERT INTO `UnitSiPrefixes` VALUES (8,15);
+INSERT INTO `UnitSiPrefixes` VALUES (9,8);
+INSERT INTO `UnitSiPrefixes` VALUES (9,11);
+INSERT INTO `UnitSiPrefixes` VALUES (9,14);
+INSERT INTO `UnitSiPrefixes` VALUES (10,5);
+INSERT INTO `UnitSiPrefixes` VALUES (10,6);
+INSERT INTO `UnitSiPrefixes` VALUES (10,8);
+INSERT INTO `UnitSiPrefixes` VALUES (10,11);
+INSERT INTO `UnitSiPrefixes` VALUES (10,14);
+INSERT INTO `UnitSiPrefixes` VALUES (11,8);
+INSERT INTO `UnitSiPrefixes` VALUES (11,11);
+INSERT INTO `UnitSiPrefixes` VALUES (12,8);
+INSERT INTO `UnitSiPrefixes` VALUES (12,11);
+INSERT INTO `UnitSiPrefixes` VALUES (12,14);
+INSERT INTO `UnitSiPrefixes` VALUES (13,8);
+INSERT INTO `UnitSiPrefixes` VALUES (13,11);
+INSERT INTO `UnitSiPrefixes` VALUES (13,14);
+INSERT INTO `UnitSiPrefixes` VALUES (13,15);
+INSERT INTO `UnitSiPrefixes` VALUES (14,6);
+INSERT INTO `UnitSiPrefixes` VALUES (14,7);
+INSERT INTO `UnitSiPrefixes` VALUES (14,8);
+INSERT INTO `UnitSiPrefixes` VALUES (14,11);
+INSERT INTO `UnitSiPrefixes` VALUES (14,14);
+INSERT INTO `UnitSiPrefixes` VALUES (14,15);
+INSERT INTO `UnitSiPrefixes` VALUES (15,8);
+INSERT INTO `UnitSiPrefixes` VALUES (15,11);
+INSERT INTO `UnitSiPrefixes` VALUES (16,11);
+INSERT INTO `UnitSiPrefixes` VALUES (16,14);
+INSERT INTO `UnitSiPrefixes` VALUES (16,15);
+INSERT INTO `UnitSiPrefixes` VALUES (16,16);
+INSERT INTO `UnitSiPrefixes` VALUES (16,17);
+INSERT INTO `UnitSiPrefixes` VALUES (17,11);
+INSERT INTO `UnitSiPrefixes` VALUES (17,14);
+INSERT INTO `UnitSiPrefixes` VALUES (18,11);
+INSERT INTO `UnitSiPrefixes` VALUES (19,11);
+INSERT INTO `UnitSiPrefixes` VALUES (20,11);
+INSERT INTO `UnitSiPrefixes` VALUES (20,14);
+INSERT INTO `UnitSiPrefixes` VALUES (20,15);
+INSERT INTO `UnitSiPrefixes` VALUES (21,11);
+INSERT INTO `UnitSiPrefixes` VALUES (22,11);
+INSERT INTO `UnitSiPrefixes` VALUES (23,11);
+INSERT INTO `UnitSiPrefixes` VALUES (24,11);
+INSERT INTO `UnitSiPrefixes` VALUES (25,11);
+INSERT INTO `UnitSiPrefixes` VALUES (26,11);
+INSERT INTO `UnitSiPrefixes` VALUES (26,14);
+INSERT INTO `UnitSiPrefixes` VALUES (26,15);
+INSERT INTO `UnitSiPrefixes` VALUES (27,11);
+INSERT INTO `UnitSiPrefixes` VALUES (28,8);
+INSERT INTO `UnitSiPrefixes` VALUES (28,11);
+INSERT INTO `UnitSiPrefixes` VALUES (28,14);
+/*!40000 ALTER TABLE `UnitSiPrefixes` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `UserPreference`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UserPreference` (
+ `user_id` int(11) NOT NULL,
+ `preferenceKey` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `preferenceValue` longtext COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`preferenceKey`,`user_id`),
+ KEY `IDX_922CE7A2A76ED395` (`user_id`),
+ CONSTRAINT `FK_922CE7A2A76ED395` FOREIGN KEY (`user_id`) REFERENCES `PartKeeprUser` (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `UserPreference` WRITE;
+/*!40000 ALTER TABLE `UserPreference` DISABLE KEYS */;
+INSERT INTO `UserPreference` VALUES (1,'partkeepr.tipoftheday.showtips','s:4:\"true\";');
+/*!40000 ALTER TABLE `UserPreference` ENABLE KEYS */;
+UNLOCK TABLES;
+DROP TABLE IF EXISTS `UserProvider`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `UserProvider` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `editable` tinyint(1) NOT NULL,
+ PRIMARY KEY (`id`),
+ UNIQUE KEY `type` (`type`)
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+LOCK TABLES `UserProvider` WRITE;
+/*!40000 ALTER TABLE `UserProvider` DISABLE KEYS */;
+INSERT INTO `UserProvider` VALUES (1,'Builtin',1);
+/*!40000 ALTER TABLE `UserProvider` 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 */;
+
diff --git a/web/.gitignore b/web/.gitignore
@@ -0,0 +1 @@
+/phpinfo.php
