# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jun 22, 2004 at 07:49 PM
# Server version: 3.23.58
# PHP Version: 4.3.5
# 
# Database : `calendar`
# 

# --------------------------------------------------------

#
# Table structure for table `calendar_cat`
#

CREATE TABLE `calendar_cat` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_name` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`cat_id`),
  UNIQUE KEY `cat_id` (`cat_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `calendar_cat`
#

INSERT INTO `calendar_cat` VALUES (1, 'General');

# --------------------------------------------------------

#
# Table structure for table `calendar_events`
#

CREATE TABLE `calendar_events` (
  `id` int(11) NOT NULL auto_increment,
  `timestamp` timestamp(14) NOT NULL,
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `url` varchar(100) NOT NULL default '',
  `email` varchar(120) NOT NULL default '',
  `cat` tinyint(2) NOT NULL default '0',
  `starttime` varchar(8) NOT NULL default '',
  `endtime` varchar(8) NOT NULL default '',
  `day` tinyint(2) NOT NULL default '0',
  `month` smallint(2) NOT NULL default '0',
  `year` smallint(4) NOT NULL default '0',
  `approved` tinyint(1) NOT NULL default '0',
  `priority` tinyint(1) NOT NULL default '0',
  `user` varchar(30) NOT NULL default '',
  `timezone` varchar(5) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `calendar_events`
#

INSERT INTO `calendar_events` VALUES (1, 20040604174956, 'hi', 'hi how are you', 'www.yahoo.com', 'mails2suri@yahoo.com', 1, '05:05', '07:05', 4, 6, 2004, 1, 0, 'admin', '');

# --------------------------------------------------------

#
# Table structure for table `calendar_param`
#

CREATE TABLE `calendar_param` (
  `name` varchar(150) NOT NULL default '',
  `value` varchar(150) default NULL
) TYPE=MyISAM;

#
# Dumping data for table `calendar_param`
#

INSERT INTO `calendar_param` VALUES ('session_timeout', '3600');

# --------------------------------------------------------

#
# Table structure for table `calendar_users`
#

CREATE TABLE `calendar_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  `description` text,
  `group_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# Dumping data for table `calendar_users`
#

INSERT INTO `calendar_users` VALUES (1, 'admin', 'wekgLeN042D5U', '', 0);
INSERT INTO `calendar_users` VALUES (2, 'test', 'weELZPzyWKtD.', '', 1);