FUKI AMFM DUMP

amfm.sql

-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Waktu pembuatan: 20. Januari 2014 jam 16:37
-- Versi Server: 5.5.33
-- Versi PHP: 5.4.4-14+deb7u7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `fuki`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `amfm`
--

CREATE TABLE IF NOT EXISTS `amfm` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kunci` varchar(45) NOT NULL,
  `jenis` int(10) unsigned NOT NULL,
  `isi` text,
  `induk` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`,`kunci`,`jenis`),
  KEY `index2` (`kunci`),
  KEY `index3` (`jenis`),
  KEY `index4` (`induk`),
  KEY `index5` (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31880 ;

-- --------------------------------------------------------

--
-- Struktur dari tabel `amfm_meta`
--

CREATE TABLE IF NOT EXISTS `amfm_meta` (
  `type` int(10) unsigned NOT NULL,
  `parent` int(10) unsigned NOT NULL,
  `valueint` int(11) DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`type`,`parent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

pendaftaran.sql

-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Waktu pembuatan: 20. Januari 2014 jam 17:02
-- Versi Server: 5.5.33
-- Versi PHP: 5.4.4-14+deb7u7

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `fuki`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `request`
--

CREATE TABLE IF NOT EXISTS `request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(500) NOT NULL,
  `nohp` varchar(20) NOT NULL,
  `waktudaftar` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `pilbid1` varchar(20) NOT NULL,
  `pilbid2` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `gender` varchar(1) NOT NULL,
  `prodi` varchar(20) NOT NULL,
  `npm` varchar(20) NOT NULL,
  `hid` tinyint(1) NOT NULL,
  `assign` int(11) NOT NULL,
  `rumah` varchar(200) DEFAULT 'Tidak ada',
  `kos` varchar(200) DEFAULT 'Tidak ada',
  `bb` varchar(200) DEFAULT 'Tidak ada',
  `wawancara1` tinyint(1) NOT NULL DEFAULT '0',
  `wawancara2` tinyint(1) NOT NULL DEFAULT '0',
  `tugasumum` tinyint(1) NOT NULL DEFAULT '0',
  `tugasbidang1` tinyint(1) NOT NULL DEFAULT '0',
  `tugasbidang2` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=290 ;

-- --------------------------------------------------------

--
-- Struktur dari tabel `request-s`
--

CREATE TABLE IF NOT EXISTS `request-s` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(30) NOT NULL,
  `banyak` int(11) NOT NULL,
  `link-i` text NOT NULL,
  `link-a` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQUE` (`nama`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data untuk tabel `request-s`
--

INSERT INTO `request-s` (`id`, `nama`, `banyak`, `link-i`, `link-a`) VALUES
(1, 'fukicorp', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdFVySk8tbVV1am1vU3BiQnYtaHFROHc&hl=en_US#gid=1', ' https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdE1pRDRIOF9DelVNcFZ5RE05c19JbVE'),
(2, 'kangmas', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdGpzWjVmUXBzU3poSkpiSzU2amFWd0E&hl=en_US#gid=1', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdDZka3E3NGFPMFhISnFLWXNSLVRFQ2c'),
(3, 'humas', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdFhjQTdNWFV5UnZOT1owaWdWbGdJX2c&hl=en_US#gid=1', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdG9IbXlWZEdKd1dqUndkY2d4cWxHdEE'),
(4, 'media', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdDZudWxPVlBwdTA3ajlIaUV3REJkNlE&hl=en_US#gid=0', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdEgtdEpvODBZOTd0U2pzUzhGeGdRMkE'),
(5, 'muc', 0, '', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdC03emx5ZTJfcWxJMk52clRDUmZhRGc'),
(6, 'ppsi', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdGViX05HWFp4dkk1SENBVmhfMlJWd1E&hl=en_US#gid=1', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdEhHRW5vdFhRVXRONWNsWFBJeGpST3c'),
(7, 'syiar', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdDNSZHNjWTJsUEJ1QS00dkdra1l4Y2c&hl=en_US#gid=1', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdDdJemtCUFNGcklKLTRiYzlpVDFlc0E'),
(8, 'mentari', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdENRSWtuT211Y2tFUTRyTzBHSzJRS3c&hl=en_US#gid=1', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdEhhVEFBRU8xR3lXcFNwTVQ4OW1kTlE'),
(9, 'paf', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdGg3OUpLUk5VNUczN3N5X0RaWVJFUUE&hl=en_US#gid=1', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdEhqVFhkMl84cTBzaUtETTNOSVBlalE'),
(10, 'ukhuwah', 0, 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdDBLaXNwNm9ENlljcjd0dXh2TXhjQWc&hl=en_US#gid=1', 'https://docs.google.com/spreadsheet/ccc?key=0Akq_YtlSVbpfdFdrU2dvVzFkczZhSkhpMzBKUGZNeHc');

-- --------------------------------------------------------

--
-- Struktur dari tabel `request_status`
--

CREATE TABLE IF NOT EXISTS `request_status` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `nama` varchar(200) NOT NULL,
  `npm` varchar(200) NOT NULL,
  `wawancara1` tinyint(1) NOT NULL DEFAULT '0',
  `wawancara2` tinyint(1) NOT NULL DEFAULT '0',
  `tugasumum` tinyint(1) NOT NULL DEFAULT '0',
  `tugasbidang1` tinyint(1) NOT NULL DEFAULT '0',
  `tugasbidang2` tinyint(1) NOT NULL DEFAULT '0',
  `bidang1` varchar(100) NOT NULL,
  `bidang2` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL,
  `nohp` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=303 ;

--
-- Dumping data untuk tabel `request_status`
--