# MySQL-Front Dump 2.2
#
# Host: localhost   Database: tmp
#--------------------------------------------------------
# Server version 3.23.43-max-debug


#
# Table structure for table 'category'
#

CREATE TABLE `category` (
  `ID` smallint(5) NOT NULL auto_increment,
  `CategoryName` varchar(30) NOT NULL default '',
  `Father` smallint(5) NOT NULL default '0',
  `DateOfCreation` date default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;



#
# Table structure for table 'garant'
#

CREATE TABLE `garant` (
  `ID` tinyint(4) unsigned NOT NULL auto_increment,
  `NameOfCompany` varchar(35) NOT NULL default '',
  `Tel` varchar(10) default NULL,
  `Cell` varchar(10) default NULL,
  `Fax` varchar(10) default NULL,
  `Address` varchar(30) default NULL,
  `ContactPerson` varchar(30) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;



#
# Table structure for table 'product'
#

CREATE TABLE `product` (
  `ID` mediumint(6) unsigned NOT NULL auto_increment,
  `Name` varchar(30) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `Price` float NOT NULL default '0',
  `PriceWithoutVat` float default NULL,
  `ArrivingDate` date NOT NULL default '0000-00-00',
  `Photo` varchar(15) NOT NULL default '',
  `Count` tinyint(3) unsigned NOT NULL default '0',
  `CategoryID` smallint(4) unsigned NOT NULL default '0',
  `DiscountProcent` mediumint(2) unsigned default '0',
  `DiscountFromDate` date default NULL,
  `DiscountTillDate` date default '0000-00-00',
  `GarantID` smallint(4) unsigned NOT NULL default '0',
  `TermOfGarant` varchar(20) NOT NULL default '',
  `SendGarant` enum('yes','no') default 'yes',
  `SumOfContinue` float default NULL,
  `TermOfContinue` varchar(20) default NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

