'CREATE TABLE `kogud` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `kogu_id` int(10) DEFAULT NULL,
  `tyyp` smallint(5) NOT NULL DEFAULT '0',
  `lyhend` varchar(10) CHARACTER SET utf8 NOT NULL,
  `nimetus` varchar(64) CHARACTER SET utf8 NOT NULL,
  `tiitel` varchar(80) CHARACTER SET utf8 DEFAULT NULL,
  `aadress` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `rada` varchar(128) CHARACTER SET utf8 NOT NULL,
  `on_line` tinyint(1) NOT NULL DEFAULT '0',
  `pin` int(10) NOT NULL DEFAULT '0',
  `email` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `k3id` smallint(5) DEFAULT NULL,
  `kirje_muudetud` datetime DEFAULT NULL,
  `c1` varchar(10) DEFAULT NULL,
  `c2` varchar(10) DEFAULT NULL,
  `c3` varchar(10) DEFAULT NULL,
  `c4` tinyint(1) NOT NULL DEFAULT '0',
  `c5` tinyint(1) NOT NULL DEFAULT '0',
  `n1` int(10) DEFAULT '0',
  `n2` int(10) DEFAULT '0',
  `n3` int(10) DEFAULT '0',
  `n4` int(10) DEFAULT '0',
  `n5` int(10) DEFAULT '5',
  `m1` decimal(19,4) DEFAULT '0.0000',
  `m2` decimal(19,4) DEFAULT '0.0000',
  `m3` decimal(19,4) DEFAULT '0.0000',
  `t1` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `t2` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `t3` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `smtp` varchar(50) DEFAULT NULL,
  `GUID` varchar(40) DEFAULT NULL,
  `d1` datetime DEFAULT NULL,
  `regnum` varchar(15) DEFAULT NULL,
  `n6` smallint(5) NOT NULL DEFAULT '0',
  `d2` datetime DEFAULT NULL,
  `jrk` tinyint(3) DEFAULT NULL,
  `c6` tinyint(1) DEFAULT '0',
  `parool` varchar(64) NOT NULL DEFAULT '827ccb0eea8a706c4c34a16891f84e7b',
  PRIMARY KEY (`id`),
  KEY `KOGUD_FK1` (`kogu_id`),
  CONSTRAINT `KOGUD_FK1` FOREIGN KEY (`kogu_id`) REFERENCES `kogud` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1'