-- MySQL dump 9.10
--
-- Host: localhost    Database: tracker01
-- ------------------------------------------------------
-- Server version	4.0.17-nt

--
-- Table structure for table `customer`
--

CREATE TABLE customer (
  id mediumint(8) unsigned NOT NULL auto_increment,
  surname varchar(64) NOT NULL default '',
  address text NOT NULL,
  phone varchar(20) NOT NULL default '',
  lastaccess datetime NOT NULL default '0000-00-00 00:00:00',
  mother varchar(32) NOT NULL default '',
  father varchar(32) NOT NULL default '',
  children varchar(255) NOT NULL default '',
  ages varchar(255) NOT NULL default '',
  notes text NOT NULL,
  postcode varchar(20) NOT NULL default '',
  title enum('mr','mrs','ms','miss') NOT NULL default 'mr',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `group_type`
--

CREATE TABLE group_type (
  id smallint(5) unsigned NOT NULL auto_increment,
  code varchar(6) NOT NULL default '',
  description varchar(128) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY id (id,code,description)
) TYPE=MyISAM;

--
-- Table structure for table `product`
--

CREATE TABLE product (
  id smallint(5) unsigned NOT NULL auto_increment,
  description varchar(128) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `sale`
--

CREATE TABLE sale (
  id mediumint(8) unsigned NOT NULL auto_increment,
  session_id mediumint(8) unsigned NOT NULL default '0',
  salesperson varchar(64) NOT NULL default '',
  sale float NOT NULL default '0',
  notes text NOT NULL,
  date_placed datetime NOT NULL default '0000-00-00 00:00:00',
  date_collected datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `sale_product`
--

CREATE TABLE sale_product (
  sale_id mediumint(8) unsigned NOT NULL default '0',
  product_id smallint(5) unsigned NOT NULL default '0',
  quantity smallint(6) NOT NULL default '0',
  UNIQUE KEY sale_id (sale_id,product_id)
) TYPE=MyISAM;

--
-- Table structure for table `session`
--

CREATE TABLE session (
  id mediumint(8) unsigned NOT NULL auto_increment,
  number varchar(20) NOT NULL default '',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  photographer varchar(64) NOT NULL default '',
  sessiontype_id smallint(5) unsigned NOT NULL default '0',
  grouptype_id smallint(5) unsigned NOT NULL default '0',
  customer_id mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table `session_type`
--

CREATE TABLE session_type (
  id smallint(5) unsigned NOT NULL auto_increment,
  code varchar(6) NOT NULL default '',
  description varchar(128) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;