-- MySQL dump 9.10
--
-- Host: localhost    Database: ao
-- ------------------------------------------------------
-- Server version	4.0.18-log

--
-- Table structure for table `stocksection`
--

CREATE TABLE stocksection (
  type varchar(9) NOT NULL default '',
  section varchar(12) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `stocksection`
--

INSERT INTO stocksection VALUES ('labour','Bench work');
INSERT INTO stocksection VALUES ('labour','Cutting');
INSERT INTO stocksection VALUES ('labour','Finishing');
INSERT INTO stocksection VALUES ('labour','Sewing time');
INSERT INTO stocksection VALUES ('fabric','jo');
INSERT INTO stocksection VALUES ('fabric','knit');
INSERT INTO stocksection VALUES ('fabric','samples');
INSERT INTO stocksection VALUES ('fabric','special');
INSERT INTO stocksection VALUES ('fabric','woven');
INSERT INTO stocksection VALUES ('component','10 vis zip');
INSERT INTO stocksection VALUES ('component','3 coil zip');
INSERT INTO stocksection VALUES ('component','5 coil zip');
INSERT INTO stocksection VALUES ('component','5 vis zip');
INSERT INTO stocksection VALUES ('component','dome');
INSERT INTO stocksection VALUES ('component','misc item');
INSERT INTO stocksection VALUES ('component','plastic bitt');
INSERT INTO stocksection VALUES ('component','sleeping bag');
INSERT INTO stocksection VALUES ('component','slider');
INSERT INTO stocksection VALUES ('component','toggle');
INSERT INTO stocksection VALUES ('length','chain');
INSERT INTO stocksection VALUES ('length','elastic');
INSERT INTO stocksection VALUES ('length','flag stuff');
INSERT INTO stocksection VALUES ('length','webbing');

--
-- Table structure for table `stocktype`
--

CREATE TABLE stocktype (
  type varchar(9) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `stocktype`
--

INSERT INTO stocktype VALUES ('labour');
INSERT INTO stocktype VALUES ('fabric');
INSERT INTO stocktype VALUES ('component');
INSERT INTO stocktype VALUES ('length');

--
-- Table structure for table `stock`
--

CREATE TABLE stock (
  id int(8) NOT NULL default '0',
  type varchar(9) NOT NULL default '',
  section varchar(12) NOT NULL default '',
  codename varchar(16) NOT NULL default '',
  size varchar(8) default NULL,
  description varchar(30) default NULL,
  supplier varchar(16) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;