-- MySQL dump 10.11
--
-- Host: localhost    Database: webcal
-- ------------------------------------------------------
-- Server version	5.0.60

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `webcal_access_function`
--

DROP TABLE IF EXISTS `webcal_access_function`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_access_function` (
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_permissions` varchar(64) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`cal_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_access_function`
--

LOCK TABLES `webcal_access_function` WRITE;
/*!40000 ALTER TABLE `webcal_access_function` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_access_function` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_access_user`
--

DROP TABLE IF EXISTS `webcal_access_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_access_user` (
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_other_user` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_can_view` int(11) NOT NULL default '0',
  `cal_can_edit` int(11) NOT NULL default '0',
  `cal_can_approve` int(11) NOT NULL default '0',
  `cal_can_invite` char(1) collate latin1_general_ci default 'Y',
  `cal_can_email` char(1) collate latin1_general_ci default 'Y',
  `cal_see_time_only` char(1) collate latin1_general_ci default 'N',
  PRIMARY KEY  (`cal_login`,`cal_other_user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_access_user`
--

LOCK TABLES `webcal_access_user` WRITE;
/*!40000 ALTER TABLE `webcal_access_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_access_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_asst`
--

DROP TABLE IF EXISTS `webcal_asst`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_asst` (
  `cal_boss` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_assistant` varchar(25) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`cal_boss`,`cal_assistant`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_asst`
--

LOCK TABLES `webcal_asst` WRITE;
/*!40000 ALTER TABLE `webcal_asst` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_asst` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_blob`
--

DROP TABLE IF EXISTS `webcal_blob`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_blob` (
  `cal_blob_id` int(11) NOT NULL,
  `cal_id` int(11) default NULL,
  `cal_login` varchar(25) collate latin1_general_ci default NULL,
  `cal_name` varchar(30) collate latin1_general_ci default NULL,
  `cal_description` varchar(128) collate latin1_general_ci default NULL,
  `cal_size` int(11) default NULL,
  `cal_mime_type` varchar(50) collate latin1_general_ci default NULL,
  `cal_type` char(1) collate latin1_general_ci NOT NULL,
  `cal_mod_date` int(11) NOT NULL,
  `cal_mod_time` int(11) NOT NULL,
  `cal_blob` longblob,
  PRIMARY KEY  (`cal_blob_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_blob`
--

LOCK TABLES `webcal_blob` WRITE;
/*!40000 ALTER TABLE `webcal_blob` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_blob` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_categories`
--

DROP TABLE IF EXISTS `webcal_categories`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_categories` (
  `cat_id` int(11) NOT NULL,
  `cat_owner` varchar(25) collate latin1_general_ci default NULL,
  `cat_name` varchar(80) collate latin1_general_ci NOT NULL,
  `cat_color` varchar(8) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_categories`
--

LOCK TABLES `webcal_categories` WRITE;
/*!40000 ALTER TABLE `webcal_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_config`
--

DROP TABLE IF EXISTS `webcal_config`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_config` (
  `cal_setting` varchar(50) collate latin1_general_ci NOT NULL,
  `cal_value` varchar(100) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`cal_setting`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_config`
--

LOCK TABLES `webcal_config` WRITE;
/*!40000 ALTER TABLE `webcal_config` DISABLE KEYS */;
INSERT INTO `webcal_config` VALUES ('SERVER_URL','http://vmtest/webcal/'),('APPLICATION_NAME','Title'),('ADD_LINK_IN_VIEWS','N'),('ADMIN_OVERRIDE_UAC','Y'),('ALLOW_ATTACH','N'),('ALLOW_ATTACH_ANY','N'),('ALLOW_ATTACH_PART','N'),('ALLOW_COLOR_CUSTOMIZATION','Y'),('ALLOW_COMMENTS','N'),('ALLOW_COMMENTS_ANY','N'),('ALLOW_COMMENTS_PART','N'),('ALLOW_CONFLICT_OVERRIDE','Y'),('ALLOW_CONFLICTS','N'),('ALLOW_EXTERNAL_HEADER','N'),('ALLOW_EXTERNAL_USERS','N'),('ALLOW_HTML_DESCRIPTION','Y'),('ALLOW_SELF_REGISTRATION','N'),('ALLOW_USER_HEADER','N'),('ALLOW_USER_THEMES','Y'),('ALLOW_VIEW_OTHER','Y'),('APPROVE_ASSISTANT_EVENT','Y'),('AUTO_REFRESH','N'),('AUTO_REFRESH_TIME','0'),('BGCOLOR','#FFFFFF'),('BGIMAGE',''),('BGREPEAT','repeat fixed center'),('BOLD_DAYS_IN_YEAR','Y'),('CAPTIONS','#B04040'),('CATEGORIES_ENABLED','Y'),('CELLBG','#C0C0C0'),('CONFLICT_REPEAT_MONTHS','6'),('CUSTOM_HEADER','N'),('CUSTOM_SCRIPT','N'),('CUSTOM_TRAILER','N'),('DATE_FORMAT','LANGUAGE_DEFINED'),('DATE_FORMAT_MD','LANGUAGE_DEFINED'),('DATE_FORMAT_MY','LANGUAGE_DEFINED'),('DATE_FORMAT_TASK','LANGUAGE_DEFINED'),('DEMO_MODE','N'),('DISABLE_ACCESS_FIELD','N'),('DISABLE_CROSSDAY_EVENTS','N'),('DISABLE_LOCATION_FIELD','N'),('DISABLE_PARTICIPANTS_FIELD','N'),('DISABLE_POPUPS','N'),('DISABLE_PRIORITY_FIELD','N'),('DISABLE_REMINDER_FIELD','N'),('DISABLE_REPEATING_FIELD','N'),('DISABLE_URL_FIELD','Y'),('DISPLAY_ALL_DAYS_IN_MONTH','N'),('DISPLAY_CREATED_BYPROXY','Y'),('DISPLAY_DESC_PRINT_DAY','Y'),('DISPLAY_END_TIMES','N'),('DISPLAY_LOCATION','N'),('DISPLAY_LONG_DAYS','N'),('DISPLAY_MINUTES','N'),('DISPLAY_MOON_PHASES','N'),('DISPLAY_SM_MONTH','Y'),('DISPLAY_TASKS','N'),('DISPLAY_TASKS_IN_GRID','N'),('DISPLAY_UNAPPROVED','Y'),('DISPLAY_WEEKENDS','Y'),('DISPLAY_WEEKNUMBER','Y'),('EMAIL_ASSISTANT_EVENTS','Y'),('EMAIL_EVENT_ADDED','Y'),('EMAIL_EVENT_CREATE','N'),('EMAIL_EVENT_DELETED','Y'),('EMAIL_EVENT_REJECTED','Y'),('EMAIL_EVENT_UPDATED','Y'),('EMAIL_FALLBACK_FROM','youremailhere'),('EMAIL_HTML','N'),('EMAIL_MAILER','mail'),('EMAIL_REMINDER','Y'),('ENABLE_CAPTCHA','N'),('ENABLE_GRADIENTS','N'),('ENABLE_ICON_UPLOADS','N'),('ENTRY_SLOTS','144'),('EXTERNAL_NOTIFICATIONS','N'),('EXTERNAL_REMINDERS','N'),('FONTS','Arial, Helvetica, sans-serif'),('FREEBUSY_ENABLED','N'),('GENERAL_USE_GMT','Y'),('GROUPS_ENABLED','N'),('H2COLOR','#000000'),('HASEVENTSBG','#FFFF33'),('IMPORT_CATEGORIES','Y'),('LANGUAGE','none'),('LIMIT_APPTS','N'),('LIMIT_APPTS_NUMBER','6'),('LIMIT_DESCRIPTION_SIZE','N'),('MENU_DATE_TOP','Y'),('MENU_ENABLED','Y'),('MENU_THEME','default'),('MYEVENTS','#006000'),('NONUSER_AT_TOP','Y'),('NONUSER_ENABLED','Y'),('OTHERMONTHBG','#D0D0D0'),('OVERRIDE_PUBLIC','N'),('OVERRIDE_PUBLIC_TEXT','Not available'),('PARTICIPANTS_IN_POPUP','N'),('PLUGINS_ENABLED','N'),('POPUP_BG','#FFFFFF'),('POPUP_FG','#000000'),('PUBLIC_ACCESS','N'),('PUBLIC_ACCESS_ADD_NEEDS_APPROVAL','N'),('PUBLIC_ACCESS_CAN_ADD','N'),('PUBLIC_ACCESS_DEFAULT_SELECTED','N'),('PUBLIC_ACCESS_DEFAULT_VISIBLE','N'),('PUBLIC_ACCESS_OTHERS','Y'),('PUBLIC_ACCESS_VIEW_PART','N'),('PUBLISH_ENABLED','Y'),('PULLDOWN_WEEKNUMBER','N'),('REMEMBER_LAST_LOGIN','N'),('REMINDER_DEFAULT','N'),('REMINDER_OFFSET','240'),('REMINDER_WITH_DATE','N'),('REMOTES_ENABLED','N'),('REPORTS_ENABLED','N'),('REQUIRE_APPROVALS','Y'),('RSS_ENABLED','N'),('SELF_REGISTRATION_BLACKLIST','N'),('SELF_REGISTRATION_FULL','Y'),('SEND_EMAIL','N'),('SERVER_TIMEZONE','America/New_York'),('SITE_EXTRAS_IN_POPUP','N'),('SMTP_AUTH','N'),('SMTP_HOST','localhost'),('SMTP_PASSWORD',''),('SMTP_PORT','25'),('SMTP_USERNAME',''),('STARTVIEW','month.php'),('SUMMARY_LENGTH','80'),('TABLEBG','#000000'),('TEXTCOLOR','#000000'),('THBG','#FFFFFF'),('THFG','#000000'),('TIME_FORMAT','12'),('TIME_SLOTS','24'),('TIME_SPACER','» '),('TIMED_EVT_LEN','D'),('TIMEZONE','America/New_York'),('TODAYCELLBG','#FFFF33'),('UAC_ENABLED','N'),('USER_PUBLISH_ENABLED','Y'),('USER_PUBLISH_RW_ENABLED','Y'),('USER_RSS_ENABLED','N'),('USER_SEES_ONLY_HIS_GROUPS','Y'),('USER_SORT_ORDER','cal_lastname, cal_firstname'),('WEBCAL_PROGRAM_VERSION','v1.2.b1'),('WEEK_START','0'),('WEEKEND_START','6'),('WEEKENDBG','#D0D0D0'),('WEEKNUMBER','#FF6633'),('WORK_DAY_END_HOUR','17'),('WORK_DAY_START_HOUR','8');
/*!40000 ALTER TABLE `webcal_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_entry`
--

DROP TABLE IF EXISTS `webcal_entry`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_entry` (
  `cal_id` int(11) NOT NULL,
  `cal_group_id` int(11) default NULL,
  `cal_ext_for_id` int(11) default NULL,
  `cal_create_by` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_date` int(11) NOT NULL,
  `cal_time` int(11) default NULL,
  `cal_mod_date` int(11) default NULL,
  `cal_mod_time` int(11) default NULL,
  `cal_duration` int(11) NOT NULL,
  `cal_due_date` int(11) default NULL,
  `cal_due_time` int(11) default NULL,
  `cal_priority` int(11) default '5',
  `cal_type` char(1) collate latin1_general_ci default 'E',
  `cal_access` char(1) collate latin1_general_ci default 'P',
  `cal_name` varchar(80) collate latin1_general_ci NOT NULL,
  `cal_location` varchar(100) collate latin1_general_ci default NULL,
  `cal_url` varchar(100) collate latin1_general_ci default NULL,
  `cal_completed` int(11) default NULL,
  `cal_description` text collate latin1_general_ci,
  PRIMARY KEY  (`cal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_entry`
--

LOCK TABLES `webcal_entry` WRITE;
/*!40000 ALTER TABLE `webcal_entry` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_entry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_entry_categories`
--

DROP TABLE IF EXISTS `webcal_entry_categories`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_entry_categories` (
  `cal_id` int(11) NOT NULL default '0',
  `cat_id` int(11) NOT NULL default '0',
  `cat_order` int(11) NOT NULL default '0',
  `cat_owner` varchar(25) collate latin1_general_ci default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_entry_categories`
--

LOCK TABLES `webcal_entry_categories` WRITE;
/*!40000 ALTER TABLE `webcal_entry_categories` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_entry_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_entry_ext_user`
--

DROP TABLE IF EXISTS `webcal_entry_ext_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_entry_ext_user` (
  `cal_id` int(11) NOT NULL default '0',
  `cal_fullname` varchar(50) collate latin1_general_ci NOT NULL,
  `cal_email` varchar(75) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`cal_id`,`cal_fullname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_entry_ext_user`
--

LOCK TABLES `webcal_entry_ext_user` WRITE;
/*!40000 ALTER TABLE `webcal_entry_ext_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_entry_ext_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_entry_log`
--

DROP TABLE IF EXISTS `webcal_entry_log`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_entry_log` (
  `cal_log_id` int(11) NOT NULL,
  `cal_entry_id` int(11) NOT NULL,
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_user_cal` varchar(25) collate latin1_general_ci default NULL,
  `cal_type` char(1) collate latin1_general_ci NOT NULL,
  `cal_date` int(11) NOT NULL,
  `cal_time` int(11) default NULL,
  `cal_text` text collate latin1_general_ci,
  PRIMARY KEY  (`cal_log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_entry_log`
--

LOCK TABLES `webcal_entry_log` WRITE;
/*!40000 ALTER TABLE `webcal_entry_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_entry_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_entry_repeats`
--

DROP TABLE IF EXISTS `webcal_entry_repeats`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_entry_repeats` (
  `cal_id` int(11) NOT NULL default '0',
  `cal_type` varchar(20) collate latin1_general_ci default NULL,
  `cal_end` int(11) default NULL,
  `cal_endtime` int(11) default NULL,
  `cal_frequency` int(11) default '1',
  `cal_days` char(7) collate latin1_general_ci default NULL,
  `cal_bymonth` varchar(50) collate latin1_general_ci default NULL,
  `cal_bymonthday` varchar(100) collate latin1_general_ci default NULL,
  `cal_byday` varchar(100) collate latin1_general_ci default NULL,
  `cal_bysetpos` varchar(50) collate latin1_general_ci default NULL,
  `cal_byweekno` varchar(50) collate latin1_general_ci default NULL,
  `cal_byyearday` varchar(50) collate latin1_general_ci default NULL,
  `cal_wkst` char(2) collate latin1_general_ci default 'MO',
  `cal_count` int(11) default NULL,
  PRIMARY KEY  (`cal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_entry_repeats`
--

LOCK TABLES `webcal_entry_repeats` WRITE;
/*!40000 ALTER TABLE `webcal_entry_repeats` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_entry_repeats` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_entry_repeats_not`
--

DROP TABLE IF EXISTS `webcal_entry_repeats_not`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_entry_repeats_not` (
  `cal_id` int(11) NOT NULL,
  `cal_date` int(11) NOT NULL,
  `cal_exdate` int(1) NOT NULL default '1',
  PRIMARY KEY  (`cal_id`,`cal_date`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_entry_repeats_not`
--

LOCK TABLES `webcal_entry_repeats_not` WRITE;
/*!40000 ALTER TABLE `webcal_entry_repeats_not` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_entry_repeats_not` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_entry_user`
--

DROP TABLE IF EXISTS `webcal_entry_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_entry_user` (
  `cal_id` int(11) NOT NULL default '0',
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_status` char(1) collate latin1_general_ci default 'A',
  `cal_category` int(11) default NULL,
  `cal_percent` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cal_id`,`cal_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_entry_user`
--

LOCK TABLES `webcal_entry_user` WRITE;
/*!40000 ALTER TABLE `webcal_entry_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_entry_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_group`
--

DROP TABLE IF EXISTS `webcal_group`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_group` (
  `cal_group_id` int(11) NOT NULL,
  `cal_owner` varchar(25) collate latin1_general_ci default NULL,
  `cal_name` varchar(50) collate latin1_general_ci NOT NULL,
  `cal_last_update` int(11) NOT NULL,
  PRIMARY KEY  (`cal_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_group`
--

LOCK TABLES `webcal_group` WRITE;
/*!40000 ALTER TABLE `webcal_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_group_user`
--

DROP TABLE IF EXISTS `webcal_group_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_group_user` (
  `cal_group_id` int(11) NOT NULL,
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`cal_group_id`,`cal_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_group_user`
--

LOCK TABLES `webcal_group_user` WRITE;
/*!40000 ALTER TABLE `webcal_group_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_group_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_import`
--

DROP TABLE IF EXISTS `webcal_import`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_import` (
  `cal_import_id` int(11) NOT NULL,
  `cal_name` varchar(50) collate latin1_general_ci default NULL,
  `cal_date` int(11) NOT NULL,
  `cal_type` varchar(10) collate latin1_general_ci NOT NULL,
  `cal_login` varchar(25) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`cal_import_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_import`
--

LOCK TABLES `webcal_import` WRITE;
/*!40000 ALTER TABLE `webcal_import` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_import` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_import_data`
--

DROP TABLE IF EXISTS `webcal_import_data`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_import_data` (
  `cal_import_id` int(11) NOT NULL,
  `cal_id` int(11) NOT NULL,
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_import_type` varchar(15) collate latin1_general_ci NOT NULL,
  `cal_external_id` varchar(200) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`cal_id`,`cal_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_import_data`
--

LOCK TABLES `webcal_import_data` WRITE;
/*!40000 ALTER TABLE `webcal_import_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_import_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_nonuser_cals`
--

DROP TABLE IF EXISTS `webcal_nonuser_cals`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_nonuser_cals` (
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_lastname` varchar(25) collate latin1_general_ci default NULL,
  `cal_firstname` varchar(25) collate latin1_general_ci default NULL,
  `cal_admin` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_is_public` char(1) collate latin1_general_ci NOT NULL default 'N',
  `cal_url` varchar(255) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`cal_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_nonuser_cals`
--

LOCK TABLES `webcal_nonuser_cals` WRITE;
/*!40000 ALTER TABLE `webcal_nonuser_cals` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_nonuser_cals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_reminders`
--

DROP TABLE IF EXISTS `webcal_reminders`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_reminders` (
  `cal_id` int(11) NOT NULL default '0',
  `cal_date` int(11) NOT NULL default '0',
  `cal_offset` int(11) NOT NULL default '0',
  `cal_related` char(1) collate latin1_general_ci NOT NULL default 'S',
  `cal_before` char(1) collate latin1_general_ci NOT NULL default 'Y',
  `cal_last_sent` int(11) NOT NULL default '0',
  `cal_repeats` int(11) NOT NULL default '0',
  `cal_duration` int(11) NOT NULL default '0',
  `cal_times_sent` int(11) NOT NULL default '0',
  `cal_action` varchar(12) collate latin1_general_ci NOT NULL default 'EMAIL',
  PRIMARY KEY  (`cal_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_reminders`
--

LOCK TABLES `webcal_reminders` WRITE;
/*!40000 ALTER TABLE `webcal_reminders` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_reminders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_report`
--

DROP TABLE IF EXISTS `webcal_report`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_report` (
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_report_id` int(11) NOT NULL,
  `cal_is_global` char(1) collate latin1_general_ci NOT NULL default 'N',
  `cal_report_type` varchar(20) collate latin1_general_ci NOT NULL,
  `cal_include_header` char(1) collate latin1_general_ci NOT NULL default 'Y',
  `cal_report_name` varchar(50) collate latin1_general_ci NOT NULL,
  `cal_time_range` int(11) NOT NULL,
  `cal_user` varchar(25) collate latin1_general_ci default NULL,
  `cal_allow_nav` char(1) collate latin1_general_ci default 'Y',
  `cal_cat_id` int(11) default NULL,
  `cal_include_empty` char(1) collate latin1_general_ci default 'N',
  `cal_show_in_trailer` char(1) collate latin1_general_ci default 'N',
  `cal_update_date` int(11) NOT NULL,
  PRIMARY KEY  (`cal_report_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_report`
--

LOCK TABLES `webcal_report` WRITE;
/*!40000 ALTER TABLE `webcal_report` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_report` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_report_template`
--

DROP TABLE IF EXISTS `webcal_report_template`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_report_template` (
  `cal_report_id` int(11) NOT NULL,
  `cal_template_type` char(1) collate latin1_general_ci NOT NULL,
  `cal_template_text` text collate latin1_general_ci,
  PRIMARY KEY  (`cal_report_id`,`cal_template_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_report_template`
--

LOCK TABLES `webcal_report_template` WRITE;
/*!40000 ALTER TABLE `webcal_report_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_report_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_site_extras`
--

DROP TABLE IF EXISTS `webcal_site_extras`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_site_extras` (
  `cal_id` int(11) NOT NULL default '0',
  `cal_name` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_type` int(11) NOT NULL,
  `cal_date` int(11) default '0',
  `cal_remind` int(11) default '0',
  `cal_data` text collate latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_site_extras`
--

LOCK TABLES `webcal_site_extras` WRITE;
/*!40000 ALTER TABLE `webcal_site_extras` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_site_extras` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_timezones`
--

DROP TABLE IF EXISTS `webcal_timezones`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_timezones` (
  `tzid` varchar(100) collate latin1_general_ci NOT NULL default '',
  `dtstart` varchar(25) collate latin1_general_ci default NULL,
  `dtend` varchar(25) collate latin1_general_ci default NULL,
  `vtimezone` text collate latin1_general_ci,
  PRIMARY KEY  (`tzid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_timezones`
--

LOCK TABLES `webcal_timezones` WRITE;
/*!40000 ALTER TABLE `webcal_timezones` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_timezones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_user`
--

DROP TABLE IF EXISTS `webcal_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_user` (
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_passwd` varchar(32) collate latin1_general_ci default NULL,
  `cal_lastname` varchar(25) collate latin1_general_ci default NULL,
  `cal_firstname` varchar(25) collate latin1_general_ci default NULL,
  `cal_is_admin` char(1) collate latin1_general_ci default 'N',
  `cal_email` varchar(75) collate latin1_general_ci default NULL,
  `cal_enabled` char(1) collate latin1_general_ci default 'Y',
  `cal_telephone` varchar(50) collate latin1_general_ci default NULL,
  `cal_address` varchar(75) collate latin1_general_ci default NULL,
  `cal_title` varchar(75) collate latin1_general_ci default NULL,
  `cal_birthday` int(11) default NULL,
  `cal_last_login` int(11) default NULL,
  PRIMARY KEY  (`cal_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_user`
--

LOCK TABLES `webcal_user` WRITE;
/*!40000 ALTER TABLE `webcal_user` DISABLE KEYS */;
INSERT INTO `webcal_user` VALUES ('Me','318b2739ddc2c16c97b33c9b04b79f3e',NULL,NULL,'Y',NULL,'Y',NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `webcal_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_user_layers`
--

DROP TABLE IF EXISTS `webcal_user_layers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_user_layers` (
  `cal_layerid` int(11) NOT NULL default '0',
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_layeruser` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_color` varchar(25) collate latin1_general_ci default NULL,
  `cal_dups` char(1) collate latin1_general_ci default 'N',
  PRIMARY KEY  (`cal_login`,`cal_layeruser`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_user_layers`
--

LOCK TABLES `webcal_user_layers` WRITE;
/*!40000 ALTER TABLE `webcal_user_layers` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_user_layers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_user_pref`
--

DROP TABLE IF EXISTS `webcal_user_pref`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_user_pref` (
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_setting` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_value` varchar(100) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`cal_login`,`cal_setting`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_user_pref`
--

LOCK TABLES `webcal_user_pref` WRITE;
/*!40000 ALTER TABLE `webcal_user_pref` DISABLE KEYS */;
INSERT INTO `webcal_user_pref` VALUES ('Me','LANGUAGE','none'),('Me','TIMEZONE','America/New_York'),('Me','DATE_FORMAT','LANGUAGE_DEFINED'),('Me','DATE_FORMAT_MY','LANGUAGE_DEFINED'),('Me','DATE_FORMAT_MD','LANGUAGE_DEFINED'),('Me','DATE_FORMAT_TASK','LANGUAGE_DEFINED'),('Me','TIME_FORMAT','12'),('Me','WEEK_START','0'),('Me','WEEKEND_START','6'),('Me','WORK_DAY_START_HOUR','8'),('Me','WORK_DAY_END_HOUR','17'),('Me','STARTVIEW','month.php'),('Me','FONTS','Arial, Helvetica, sans-serif'),('Me','DISPLAY_SM_MONTH','N'),('Me','DISPLAY_WEEKENDS','Y'),('Me','DISPLAY_LONG_DAYS','N'),('Me','DISPLAY_MINUTES','N'),('Me','DISPLAY_END_TIMES','N'),('Me','DISPLAY_ALL_DAYS_IN_MONTH','N'),('Me','DISPLAY_WEEKNUMBER','Y'),('Me','DISPLAY_TASKS','N'),('Me','DISPLAY_TASKS_IN_GRID','N'),('Me','DISPLAY_MOON_PHASES','N'),('Me','DISPLAY_UNAPPROVED','Y'),('Me','TIMED_EVT_LEN','D'),('Me','CATEGORY_VIEW','0'),('Me','DISABLE_CROSSDAY_EVENTS','N'),('Me','DISPLAY_DESC_PRINT_DAY','Y'),('Me','ENTRY_SLOTS','144'),('Me','TIME_SLOTS','24'),('Me','AUTO_REFRESH','N'),('Me','AUTO_REFRESH_TIME','0'),('Me','THEME','none'),('Me','MENU_THEME','default'),('Me','APPROVE_ASSISTANT_EVENT','Y'),('Me','DISPLAY_CREATED_BYPROXY','Y'),('Me','USER_REMOTE_ACCESS','0'),('Me','USER_PUBLISH_ENABLED','Y'),('Me','USER_PUBLISH_RW_ENABLED','Y'),('Me','FREEBUSY_ENABLED','N'),('Me','BGCOLOR','#FFFFFF'),('Me','H2COLOR','#000000'),('Me','TEXTCOLOR','#000000'),('Me','MYEVENTS','#006000'),('Me','TABLEBG','#000000'),('Me','THBG','#FFFFFF'),('Me','THFG','#000000'),('Me','CELLBG','#C0C0C0'),('Me','TODAYCELLBG','#FFFF33'),('Me','HASEVENTSBG','#FFFF33'),('Me','WEEKENDBG','#D0D0D0'),('Me','OTHERMONTHBG','#D0D0D0'),('Me','WEEKNUMBER','#FF6633'),('Me','POPUP_BG','#FFFFFF'),('Me','POPUP_FG','#000000');
/*!40000 ALTER TABLE `webcal_user_pref` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_user_template`
--

DROP TABLE IF EXISTS `webcal_user_template`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_user_template` (
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_type` char(1) collate latin1_general_ci NOT NULL,
  `cal_template_text` text collate latin1_general_ci,
  PRIMARY KEY  (`cal_login`,`cal_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_user_template`
--

LOCK TABLES `webcal_user_template` WRITE;
/*!40000 ALTER TABLE `webcal_user_template` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_user_template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_view`
--

DROP TABLE IF EXISTS `webcal_view`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_view` (
  `cal_view_id` int(11) NOT NULL,
  `cal_owner` varchar(25) collate latin1_general_ci NOT NULL,
  `cal_name` varchar(50) collate latin1_general_ci NOT NULL,
  `cal_view_type` char(1) collate latin1_general_ci default NULL,
  `cal_is_global` char(1) collate latin1_general_ci NOT NULL default 'N',
  PRIMARY KEY  (`cal_view_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_view`
--

LOCK TABLES `webcal_view` WRITE;
/*!40000 ALTER TABLE `webcal_view` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_view` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `webcal_view_user`
--

DROP TABLE IF EXISTS `webcal_view_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `webcal_view_user` (
  `cal_view_id` int(11) NOT NULL,
  `cal_login` varchar(25) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`cal_view_id`,`cal_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `webcal_view_user`
--

LOCK TABLES `webcal_view_user` WRITE;
/*!40000 ALTER TABLE `webcal_view_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `webcal_view_user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-08-04 17:58:18