-- 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