-- phpMyAdmin SQL Dump
-- version 2.11.3deb1ubuntu1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 08, 2008 at 09:28 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.4-2ubuntu5.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `ilkom`
--

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

--
-- Table structure for table `posts`
--

CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL auto_increment,
  `site_id` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(255) collate latin1_general_ci NOT NULL default '',
  `content` text collate latin1_general_ci NOT NULL,
  `url` varchar(255) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `post` (`content`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=439 ;

--
-- Dumping data for table `posts`
--


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

--
-- Table structure for table `sessions`
--

CREATE TABLE IF NOT EXISTS `sessions` (
  `session_id` varchar(40) NOT NULL default '0',
  `ip_address` varchar(16) NOT NULL default '0',
  `user_agent` varchar(50) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES
('3b4f8cd4be71453cd695bd375e268527', '127.0.0.1', 'Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.', 1213589867);

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

--
-- Table structure for table `site`
--

CREATE TABLE IF NOT EXISTS `site` (
  `site_id` int(11) NOT NULL auto_increment,
  `name` varchar(60) collate latin1_general_ci NOT NULL default '',
  `site_url` varchar(255) collate latin1_general_ci NOT NULL default '',
  `feed_url` varchar(255) collate latin1_general_ci NOT NULL default '',
  `last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  `update_interval` int(11) NOT NULL default '0',
  PRIMARY KEY  (`site_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=24 ;

--
-- Dumping data for table `site`
--

INSERT INTO `site` (`site_id`, `name`, `site_url`, `feed_url`, `last_update`, `update_interval`) VALUES
(22, 'saeeedd', 'assdf', 'asd', '0000-00-00 00:00:00', 0),
(23, 'sdfsg', 'dfgdfg', 'fdgdfg', '0000-00-00 00:00:00', 0);

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` bigint(11) unsigned NOT NULL auto_increment,
  `FK_group_id` tinyint(3) unsigned NOT NULL default '0',
  `location` varchar(75) collate utf8_unicode_ci NOT NULL,
  `join_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `username` varchar(15) collate utf8_unicode_ci NOT NULL,
  `password` varchar(40) collate utf8_unicode_ci NOT NULL,
  `email` varchar(40) collate utf8_unicode_ci NOT NULL,
  `company` varchar(255) collate utf8_unicode_ci NOT NULL,
  `telpon` varchar(40) collate utf8_unicode_ci NOT NULL,
  `hash` varchar(40) collate utf8_unicode_ci NOT NULL,
  `activation_code` varchar(40) collate utf8_unicode_ci NOT NULL default '0',
  `change_password` tinyint(1) unsigned NOT NULL default '0',
  `active` tinyint(1) unsigned NOT NULL,
  `type` tinyint(1) NOT NULL default '1',
  `last_failure` int(10) unsigned NOT NULL default '0',
  `failed_logins` tinyint(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  KEY `FK_group_id` (`FK_group_id`),
  KEY `active` (`active`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`user_id`, `FK_group_id`, `location`, `join_date`, `name`, `username`, `password`, `email`, `company`, `telpon`, `hash`, `activation_code`, `change_password`, `active`, `type`, `last_failure`, `failed_logins`) VALUES
(1, 1, '0', '2008-05-24 01:22:22', 'ibnud2', 'admin', '77a9fc588bc3b6260af6093de6161f1fc5eda2ba', 'xibnoe@gmail.com', '', '', '000d9221b44792bdfd2f8020ce77070049f6ccc8', '0', 0, 1, 1, 1215478845, 0),
(2, 2, 'malang', '2008-06-29 10:28:08', 'Mala', 'ibnoe', 'abd6fde70aa7ea554b04bf9f60b94dbdb2cffbb5', 'xibnoe2@gmail.com', '', '', '5ea4c76d4a0717ed13853c178131e7b2ab9e3d25', '0', 0, 1, 1, 1215234318, 1);

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

--
-- Table structure for table `user_groups`
--

CREATE TABLE IF NOT EXISTS `user_groups` (
  `group_id` tinyint(3) unsigned NOT NULL auto_increment,
  `title` varchar(20) collate utf8_unicode_ci NOT NULL,
  `description` varchar(100) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`group_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Dumping data for table `user_groups`
--

INSERT INTO `user_groups` (`group_id`, `title`, `description`) VALUES
(1, 'Administrators', ''),
(2, 'Users', '');