CREATE TABLE IF NOT EXISTS `ANIMALS` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `ANI_ID` int(20) NOT NULL,
  `NAZWA` varchar(40) CHARACTER SET latin2 NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=417 ;

CREATE TABLE IF NOT EXISTS `CUSTOMER` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `CUST_ID` int(10) NOT NULL,
  `NAZWA` varchar(60) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=288 ;

CREATE TABLE IF NOT EXISTS `DOCTORS` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `DOCTOR_ID` int(11) NOT NULL,
  `FIRST_NAME` varchar(30) NOT NULL,
  `NAZWA` varchar(50) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

CREATE TABLE IF NOT EXISTS `WIZYTY` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `WIZ_ID` int(11) NOT NULL,
  `DATA` date NOT NULL,
  `CUST_ID` int(10) NOT NULL,
  `ANI_ID` int(20) NOT NULL,
  `DOCTOR_ID` int(11) NOT NULL,
  `TYP_WIZ` int(11) NOT NULL,
  `DOC_TYPE_ID` int(10) NOT NULL,
  `AMOUNT` decimal(18,4) NOT NULL,
  `DATA_ZGLOSZ` date NOT NULL,
  `GODZ_ZGLOSZ` time NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `WIZYTY_4` (`DATA`),
  KEY `WIZYTY_5` (`DATA`),
  KEY `WIZYTY_6` (`DATA`),
  KEY `WIZYTY_8` (`DOC_TYPE_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1235 ;