CREATE DATABASE horoscope;

USE horoscope;

CREATE TABLE `tblhoroscope` (
  `id` varchar(15) collate latin1_general_ci NOT NULL,
  `deskripsi` varchar(20) collate latin1_general_ci default NULL,
  `tanggal` varchar(40) collate latin1_general_ci default NULL,
  `ramalan` varchar(250) collate latin1_general_ci default NULL,
  `asmara` varchar(250) collate latin1_general_ci default NULL,
  `keuangan` varchar(250) collate latin1_general_ci default NULL,
  `kesehatan` varchar(250) collate latin1_general_ci default NULL,
  `karir` varchar(250) collate latin1_general_ci default NULL,
  `warna` varchar(250) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `deskripsi` (`deskripsi`),
  UNIQUE KEY `deskripsi_2` (`deskripsi`)
);