Script DB CTI

-- phpMyAdmin SQL Dump
-- version 4.0.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 22, 2014 at 03:56 AM
-- Server version: 5.5.35-cll
-- PHP Version: 5.3.17

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `zzimbaga_dbtools`
--

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

--
-- Table structure for table `gem`
--

CREATE TABLE IF NOT EXISTS `gem` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) DEFAULT NULL,
  `penjoki` varchar(100) DEFAULT NULL,
  `fbid` varchar(100) DEFAULT NULL,
  `ukey` varchar(100) DEFAULT NULL,
  `paket` varchar(100) DEFAULT NULL,
  `status` enum('Pending','Selesai','Error') DEFAULT NULL,
  `bukti` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=93 ;

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

--
-- Table structure for table `quiz`
--

CREATE TABLE IF NOT EXISTS `quiz` (
  `peserta` varchar(100) NOT NULL,
  `fbid` varchar(100) NOT NULL,
  `jawaban` varchar(100) NOT NULL,
  PRIMARY KEY (`peserta`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `shout_box`
--

CREATE TABLE IF NOT EXISTS `shout_box` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fbid` varchar(100) NOT NULL,
  `user` varchar(60) NOT NULL,
  `message` varchar(100) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1212 ;

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fbid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `level` enum('Member','Reseller','Broker','Developers','Pending') COLLATE utf8_unicode_ci NOT NULL,
  `saldo` bigint(255) NOT NULL,
  `uplink` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`fbid`),
  KEY `nama` (`password`),
  KEY `fbid` (`fbid`),
  FULLTEXT KEY `fbid_2` (`fbid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`password`, `fbid`, `level`, `saldo`, `uplink`) VALUES
('khalid', '100003597129795', 'Developers', 90000000, 'ewe'),
('mail', '100005169932980', 'Developers', 999999997499, 'Ismail Ajah Dah');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;