sql dump from work

gistfile1.sql

-- phpMyAdmin SQL Dump
-- version 3.4.5deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 05, 2012 at 04:54 PM
-- Server version: 5.1.58
-- PHP Version: 5.3.6-13ubuntu3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Database: `SSI`
--

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

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `description`) VALUES
(1, 'DM510e', 'dm510 part groupe'),
(2, 'AM3', 'am cube part group'),
(3, 'FOO', 'BAR'),
(6, 'Lemon', 'Sour Group'),
(7, 'Wolf', 'No Description');

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

--
-- Table structure for table `group_item_mapping`
--

CREATE TABLE IF NOT EXISTS `group_item_mapping` (
  `group_id` int(10) NOT NULL,
  `item_id` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `group_item_mapping`
--

INSERT INTO `group_item_mapping` (`group_id`, `item_id`) VALUES
(2, 6),
(1, 9),
(1, 3),
(1, 4),
(1, 6),
(2, 5),
(1, 1),
(1, 2),
(3, 9),
(4, 10),
(3, 10),
(2, 10),
(1, 10),
(4, 14),
(2, 14),
(3, 15),
(4, 15),
(1, 16),
(2, 16),
(1, 17),
(1, 29),
(2, 29),
(1, 28),
(1, 30),
(3, 30),
(6, 35),
(2, 36),
(6, 36),
(3, 35),
(1, 36);

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

--
-- Table structure for table `inventory`
--

CREATE TABLE IF NOT EXISTS `inventory` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `part_code` varchar(255) NOT NULL,
  `part_description` varchar(255) NOT NULL,
  `part_supplier_id` int(10) NOT NULL,
  `supplier_part_code` varchar(255) NOT NULL,
  `loc` varchar(255) NOT NULL,
  `qty` int(10) NOT NULL,
  `unit_cost` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=37 ;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` (`id`, `part_code`, `part_description`, `part_supplier_id`, `supplier_part_code`, `loc`, `qty`, `unit_cost`) VALUES
(35, 'DM_adsfsfg', 'hello world', 20, 'SPC_0050', 'X', 100, 12.75),
(36, 'DM_500', 'Some new Description', -1, 'SPC_dm510e', 'X', 15, 7000),
(30, 'DM_', 'No Description', 11, 'SPC_', 'X', 0, 0);

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

--
-- Table structure for table `suppliers`
--

CREATE TABLE IF NOT EXISTS `suppliers` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `telephone` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `contact_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

--
-- Dumping data for table `suppliers`
--

INSERT INTO `suppliers` (`id`, `name`, `description`, `email`, `telephone`, `fax`, `url`, `contact_name`) VALUES
(1, 'Edge Elec', 'this is a description field.', 'name@email.com', '5551234567', '5551234567', 'http://dryermaster.com/', 'John Smith'),
(2, 'Carsan', 'circuit board - assembly services - smt assembly ', 'sales@car-san.com', '5198850403', '5198852604', 'http://www.car-san.com/', 'Caroline Grandy'),
(3, 'Arrow', 'this is a description field.', 'name@email.com', '465461321032', '5551234567', 'http://dryermaster.com/', 'John Smith'),
(4, 'Profom', 'this is a description field.', 'name@email.com', '5551234567', '5551234567', 'http://dryermaster.com/', 'John Smith'),
(6, 'Thermo-Kinetics', 'No Description', '', '', '', '', ''),
(7, 'Snowden', 'No Description', '', '', '', '', ''),
(8, 'TCH', 'No Description', '', '', '', '', ''),
(9, 'Goodal', 'No Description', '', '', '', '', ''),
(10, 'Abco', 'No Description', '', '', '', '', ''),
(11, 'Custom Foam', 'No Description', '', '', '', '', ''),
(12, 'Home Depot', 'No Description', '', '', '', '', ''),
(13, 'MAPP', 'No Description', '', '', '', '', ''),
(14, 'WatCus', 'No Description', '', '', '', '', ''),
(15, 'AccuTech', 'No Description', '', '', '', '', ''),
(16, 'Marshall', 'No Description', '', '', '', '', ''),
(18, 'Electrasonic', 'No Description', '', '', '', '', ''),
(19, 'Trade Automation', 'No Description', '', '', '', '', ''),
(20, 'Simcona', 'No Description', '', '', '', '', ''),
(21, 'Craft', 'No Description', '', '', '', '', ''),
(22, 'Excell', 'No Description', '', '', '', '', ''),
(23, 'Kevtron', 'No Description', '', '', '', '', ''),
(24, 'Versatile', 'No Description', '', '', '', '', ''),
(25, 'Morphy', 'No Description', '', '', '', '', ''),
(26, 'Excell', 'No Description', '', '', '', '', ''),
(27, 'Electromate', 'No Description', '', '', '', '', ''),
(28, 'Electra', 'No Description', '', '', '', '', ''),
(29, 'WCF', 'No Description', '', '', '', '', ''),
(30, 'Allied Electronics', 'No Description', '', '', '', '', ''),
(31, 'Digi-Key', 'No Description', '', '', '', '', '');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `role` enum('default','admin','owner') NOT NULL,
  `ui_theme` int(10) NOT NULL DEFAULT '0',
  `last_login` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `role`, `ui_theme`, `last_login`) VALUES
(1, 'rlemon', 'e77910ebb93b511588557806310f78f1', 'owner', 10, '2012-01-05 16:02:05'),
(2, 'wks', '4bb447bd76e938939e67a9dfda0ba2bd', 'admin', 14, '2012-01-05 16:01:53'),
(3, 'jmk', '9b1b3d63b0b7b1c3620fe97612832aaa', 'default', 0, '0000-00-00 00:00:00');

/*!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 */;