CREATE TABLE aboutus (
  id bigint(20) NOT NULL auto_increment,
  isi text NOT NULL,
  tanggal varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `admin`
#

CREATE TABLE admin (
  ID varchar(50) NOT NULL default '',
  username varchar(20) NOT NULL default '',
  passwd varchar(20) NOT NULL default '',
  nama varchar(25) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  session_ID varchar(50) NOT NULL default '',
  last_login varchar(50) NOT NULL default '',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `artikel`
#

CREATE TABLE artikel (
  souvenirid bigint(20) NOT NULL auto_increment,
  judul varchar(200) NOT NULL default '',
  snapshot text NOT NULL,
  beritalengkap text NOT NULL,
  sumber varchar(200) NOT NULL default '',
  gambar varchar(50) NOT NULL default '',
  gambar2 varchar(50) NOT NULL default '',
  date varchar(50) NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (souvenirid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `berita`
#

CREATE TABLE berita (
  souvenirid bigint(20) NOT NULL auto_increment,
  judul varchar(200) NOT NULL default '',
  snapshot text NOT NULL,
  beritalengkap text NOT NULL,
  gambar varchar(50) NOT NULL default '',
  date varchar(50) NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (souvenirid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `biodiesel`
#

CREATE TABLE biodiesel (
  id bigint(20) NOT NULL auto_increment,
  isi text NOT NULL,
  tanggal varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `events`
#

CREATE TABLE events (
  souvenirid bigint(20) NOT NULL auto_increment,
  judul varchar(200) NOT NULL default '',
  snapshot text NOT NULL,
  beritalengkap text NOT NULL,
  tanggalmulai date NOT NULL default '0000-00-00',
  tempat varchar(200) NOT NULL default '',
  gambar varchar(50) NOT NULL default '',
  date varchar(50) NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (souvenirid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `jatrophacurcas`
#

CREATE TABLE jatrophacurcas (
  id bigint(20) NOT NULL auto_increment,
  isi text NOT NULL,
  tanggal varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `kontak`
#

CREATE TABLE kontak (
  id bigint(20) NOT NULL auto_increment,
  nama varchar(50) NOT NULL default '',
  email varchar(50) NOT NULL default '',
  perusahaan varchar(50) NOT NULL default '',
  phone varchar(25) NOT NULL default '',
  comment text NOT NULL,
  date varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `linkage`
#

CREATE TABLE linkage (
  souvenirid bigint(20) NOT NULL auto_increment,
  title text NOT NULL,
  urladdr varchar(250) default NULL,
  kelas_id varchar(250) default NULL,
  date datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (souvenirid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `photogallery`
#

CREATE TABLE photogallery (
  souvenirid bigint(20) NOT NULL auto_increment,
  title text NOT NULL,
  kelas_id varchar(250) default NULL,
  gambar varchar(50) NOT NULL default '',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (souvenirid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `produk`
#

CREATE TABLE produk (
  id bigint(20) NOT NULL auto_increment,
  isi text NOT NULL,
  tanggal varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `servis`
#

CREATE TABLE servis (
  id bigint(20) NOT NULL auto_increment,
  isi text NOT NULL,
  tanggal varchar(50) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `sitebanner`
#

CREATE TABLE sitebanner (
  souvenirid bigint(20) NOT NULL auto_increment,
  namabanner varchar(200) NOT NULL default '',
  keterangan text NOT NULL,
  gambar varchar(50) NOT NULL default '',
  date datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (souvenirid)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `tb_kelas`
#

CREATE TABLE tb_kelas (
  id bigint(50) NOT NULL auto_increment,
  kategori varchar(180) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `tb_kelasphoto`
#

CREATE TABLE tb_kelasphoto (
  id bigint(50) NOT NULL auto_increment,
  kategori varchar(180) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;