table pasien

CREATE TABLE IF NOT EXISTS `klinik_pasien` (
  `pat_id` int(11) NOT NULL AUTO_INCREMENT,
  `pat_name1` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `pat_name2` varchar(120) COLLATE latin1_general_ci NOT NULL,
  `pat_com` int(11) NOT NULL COMMENT 'ignore aja..',
  `pat_ins` int(11) NOT NULL COMMENT 'ignore aja..',
  `pat_addr` text COLLATE latin1_general_ci NOT NULL,
  `pat_addr2` varchar(255)  COMMENT 'posisi kelurahan' COLLATE latin1_general_ci NOT NULL,
  `pat_addr3` varchar(7)  COMMENT 'ignore aja..' COLLATE latin1_general_ci NOT NULL,
  `pat_gen` smallint(6) NOT NULL,
  `pat_birth` date NOT NULL,
  `pat_phone` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `pat_inp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pat_desc` text COLLATE latin1_general_ci NOT NULL,
  `pat_blood` char(10) COLLATE latin1_general_ci NOT NULL,
  `pat_dataEdit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pat_religi` int(11) NOT NULL,
  `pat_status` tinyint(1) NOT NULL,
  `pat_wni` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'Indonesia',
  PRIMARY KEY (`pat_id`),
  KEY `lahir` (`pat_birth`),
  KEY `pat_com` (`pat_com`),
  KEY `pat_ins` (`pat_ins`),
  KEY `nama` (`pat_name1`,`pat_name2`,`pat_gen`),
  FULLTEXT KEY `alamat` (`pat_addr`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='pasien table' AUTO_INCREMENT=377761 ;