diff options
Diffstat (limited to 'abs/mv-core/webcal/createdb.sql')
| -rw-r--r-- | abs/mv-core/webcal/createdb.sql | 810 |
1 files changed, 810 insertions, 0 deletions
diff --git a/abs/mv-core/webcal/createdb.sql b/abs/mv-core/webcal/createdb.sql new file mode 100644 index 0000000..e511483 --- /dev/null +++ b/abs/mv-core/webcal/createdb.sql @@ -0,0 +1,810 @@ +-- 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 |