Файловый менеджер - Редактировать - /home/avadvi5/calendar.aeronextgen.com/sql.zip
Ðазад
PK 큓\c} ��] �] tables-mysql.sqlnu �[��� /* $Id: tables-mysql.sql,v 1.25 2009/11/22 16:47:47 bbannon Exp $ */ /** * Description: * This file is used to create all tables used by WebCalendar * and initialize some of those tables with the required data. * * The comments in the table definitions will be parsed to * generate a document (in HTML) that describes these tables. */ /** * Defines a WebCalendar user. */ CREATE TABLE webcal_user ( /* the unique user login */ cal_login VARCHAR(25) NOT NULL, /* the user's password. (not used for http) */ cal_passwd VARCHAR(32), /* user's last name */ cal_lastname VARCHAR(25), /* user's first name */ cal_firstname VARCHAR(25), /* is the user a WebCalendar administrator ('Y' = yes, 'N' = no) */ cal_is_admin CHAR(1) DEFAULT 'N', /* user's email address */ cal_email VARCHAR(75) NULL, /* allow admin to disable account ('Y' = yes, 'N' = no) */ cal_enabled CHAR(1) DEFAULT 'Y', /* user's telephone */ cal_telephone VARCHAR(50) NULL, /* user's address */ cal_address VARCHAR(75) NULL, /* user's title */ cal_title VARCHAR(75) NULL, /* user's birthday */ cal_birthday INT NULL, /* user's last log in date */ cal_last_login INT NULL, PRIMARY KEY ( cal_login ) ); # create a DEFAULT admin user INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' ); /** * Defines a calendar event. Each event in the system has one entry in * this table unless the event starts before midnight and ends after * midnight. In that case a secondary event will be created with * cal_ext_for_id set to the cal_id of the original entry. The following * tables contain additional information about each event: * <ul> * <li><a href="#webcal_entry_user">webcal_entry_user</a> * - lists participants in the event and specifies the status * (accepted, rejected) and category of each participant.</li> * <li><a href="#webcal_entry_repeats">webcal_entry_repeats</a> * - contains information if the event repeats.</li> * <li><a href="#webcal_entry_repeats_not">webcal_entry_repeats_not</a> * - specifies which dates the repeating event does not repeat * (because they were deleted or modified for just that date by the * user)</li> * <li><a href="#webcal_entry_log">webcal_entry_log</a> * - provides a history of changes to this event.</li> * <li><a href="#webcal_site_extras">webcal_site_extras</a> * - stores event data as defined in site_extras.php (such as * reminders and other custom event fields).</li> * </ul> */ CREATE TABLE webcal_entry ( /* cal_id is unique integer id for event */ cal_id INT NOT NULL, /* cal_group_id: the parent event id if this event is overriding an */ /* occurrence of a repeating event */ cal_group_id INT NULL, /* used when an event goes past midnight into the next day, */ /* in which case an additional entry in this table */ /* will use this field to indicate the original event cal_id */ cal_ext_for_id INT NULL, /* user login of user that created the event */ cal_create_by VARCHAR(25) NOT NULL, /* date of event (in YYYYMMDD format) */ cal_date INT NOT NULL, /* event time (in HHMMSS format) */ cal_time INT NULL, /* date the event was last modified (in YYYYMMDD format) */ cal_mod_date INT, /* time the event was last modified (in HHMMSS format) */ cal_mod_time INT, /* duration of event in minutes */ cal_duration INT NOT NULL, /* Task due date */ cal_due_date INT DEFAULT NULL, /* Task due time */ cal_due_time INT DEFAULT NULL, /* event priority: 1=Low, 2=Med, 3=High */ cal_priority INT DEFAULT 5, /* 'E' = Event, 'M' = Repeating event, 'T' = Task */ cal_type CHAR(1) DEFAULT 'E', /* 'P' = Public, */ /* 'R' = Private (others cannot see the event), */ /* 'C' = Confidential (others can see time allocated but not what it is) */ cal_access CHAR(1) DEFAULT 'P', /* brief description of event */ cal_name VARCHAR(80) NOT NULL, /* location of event */ cal_location varchar(100) DEFAULT NULL, /* URL of event */ cal_url varchar(100) DEFAULT NULL, /* date task completed */ cal_completed INT DEFAULT NULL, /* full description of event */ cal_description TEXT, PRIMARY KEY ( cal_id ) ); /** * Contains category foreign keys * to enable multiple categories for each event or task */ CREATE TABLE webcal_entry_categories ( /* id of event. Not unique*/ cal_id INT DEFAULT 0 NOT NULL, /* id of category. Not unique */ cat_id INT DEFAULT 0 NOT NULL, /* order that user requests their categories appear. */ /* Globals are always last */ cat_order INT DEFAULT 0 NOT NULL, /* user that owns this record. Global categories will be NULL */ cat_owner varchar(25) DEFAULT NULL ); /** * Defines repeating info about an event. * The event is defined in <a href="#webcal_entry">webcal_entry</a>. */ CREATE TABLE webcal_entry_repeats ( /* event id */ cal_id INT DEFAULT 0 NOT NULL, /* type of repeating: */ /* <ul> */ /* <li>daily - repeats daily</li> */ /* <li>monthlyByDate - repeats on same day of the month</li> */ /* <li>monthlyBySetPos */ /* - repeats based on position within other ByXXX values</li> */ /* <li>monthlyByDay */ /* - repeats on specified weekday (2nd Monday, for example)</li> */ /* <li>weekly - repeats every week</li> */ /* <li>yearly - repeats on same date every year</li> */ /* </ul> */ cal_type VARCHAR(20), /* end date for repeating event (in YYYYMMDD format) */ cal_end INT, cal_endtime INT DEFAULT NULL, /* frequency of repeat: 1 = every, 2 = every other, 3 = every 3rd, etc. */ cal_frequency INT DEFAULT 1, /* NO LONGER USED. We'll leave it in for now */ cal_days CHAR(7), /* the following columns are values as specified in RFC2445 */ cal_bymonth varchar(50) DEFAULT NULL, cal_bymonthday varchar(100) DEFAULT NULL, cal_byday varchar(100) DEFAULT NULL, cal_bysetpos varchar(50) DEFAULT NULL, cal_byweekno varchar(50) DEFAULT NULL, cal_byyearday varchar(50) DEFAULT NULL, cal_wkst char(2) DEFAULT 'MO', cal_count INT DEFAULT NULL, PRIMARY KEY (cal_id) ); /** * This table specifies which dates in a repeating event have either been * deleted, included, or replaced with a replacement event for that day. * When replaced, the cal_group_id (I know... not the best name, but it * was not being used) column will be set to the original event. * That way the user can delete the original event and (at the same time) * delete any exception events. */ CREATE TABLE webcal_entry_repeats_not ( /* event id of repeating event */ cal_id INT NOT NULL, /* cal_date: date event should not repeat (in YYYYMMDD format) */ cal_date INT NOT NULL, /* indicates whether this record is an exclusion (1) or inclusion (0) */ cal_exdate int(1) NOT NULL DEFAULT 1, PRIMARY KEY ( cal_id, cal_date ) ); /** * This table associates one or more users with an event by the event id. * The event can be found in <a href="#webcal_entry">webcal_entry</a>. */ CREATE TABLE webcal_entry_user ( /* event id */ cal_id INT DEFAULT 0 NOT NULL, /* participant in the event */ cal_login VARCHAR(25) NOT NULL, /* status of event for this user: */ /* <ul> */ /* <li>A=Accepted</li> */ /* <li>C=Completed</li> */ /* <li>D=Deleted</li> */ /* <li>P=In-Progress</li> */ /* <li>R=Rejected/Declined</li> */ /* <li>W=Waiting</li> */ /* </ul>*/ cal_status CHAR(1) DEFAULT 'A', /* category of the event for this user */ cal_category INT DEFAULT NULL, /* Task percentage of completion for this user's task */ cal_percent INT DEFAULT 0 NOT NULL, PRIMARY KEY ( cal_id, cal_login ) ); /** * This table associates one or more external users (people who do not * have a WebCalendar login) with an event by the event id. An event must * still have at least one WebCalendar user associated with it. This table * is not used unless external users are enabled* in system settings. The * event can be found in <a href="#webcal_entry">webcal_entry</a>. */ CREATE TABLE webcal_entry_ext_user ( /* event id */ cal_id INT DEFAULT 0 NOT NULL, /* external user fill name */ cal_fullname VARCHAR(50) NOT NULL, /* external user email (for sending a reminder) */ cal_email VARCHAR(75) NULL, PRIMARY KEY ( cal_id, cal_fullname ) ); /** * Specify preferences for a user. * Most preferences are set via pref.php. * Values in this table are loaded after system settings * found in <a href="#webcal_config">webcal_config</a>. */ CREATE TABLE webcal_user_pref ( /* user login */ cal_login VARCHAR(25) NOT NULL, /* setting name */ cal_setting VARCHAR(25) NOT NULL, /* setting value */ cal_value VARCHAR(100) NULL, PRIMARY KEY ( cal_login, cal_setting ) ); /** * Define layers for a user. */ CREATE TABLE webcal_user_layers ( /* unique layer id */ cal_layerid INT DEFAULT 0 NOT NULL, /* login of owner of this layer */ cal_login VARCHAR(25) NOT NULL, /* login name of user that this layer represents */ cal_layeruser VARCHAR(25) NOT NULL, /* color to display this layer in */ cal_color VARCHAR(25) NULL, /* show duplicates ('N' or 'Y') */ cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ) ); /** * This table holds data for site extra fields * (customized in site_extra.php). */ CREATE TABLE webcal_site_extras ( /* event id */ cal_id INT DEFAULT 0 NOT NULL, /* the brief name of this type (first field in $site_extra array) */ cal_name VARCHAR(25) NOT NULL, /* EXTRA_URL, EXTRA_DATE, etc. */ cal_type INT NOT NULL, /* only used for EXTRA_DATE type fields (in YYYYMMDD format) */ cal_date INT DEFAULT 0, /* how many minutes before event should a reminder be sent */ cal_remind INT DEFAULT 0, /* used to store text data */ cal_data TEXT ); /** * Stores information about reminders */ CREATE TABLE webcal_reminders ( cal_id INT NOT NULL default '0', /* timestamp that specifies send datetime. */ /* Use this or cal_offset, but not both */ cal_date INT NOT NULL default '0', /* offset in minutes from the selected edge */ cal_offset INT NOT NULL default '0', /* S=Start, E=End. Specifies which edge of entry this reminder applies to */ cal_related CHAR(1) NOT NULL default 'S', /* specifies whether reminder is sent before or after selected edge */ cal_before CHAR(1) NOT NULL default 'Y', /* timestamp of last sent reminder */ cal_last_sent INT NOT NULL default '0', /* number of times to repeat in addition to original occurance */ cal_repeats INT NOT NULL default '0', /* time in ISO 8601 format that specifies time between repeated reminders */ cal_duration INT NOT NULL default '0', /* number of times this reminder has been sent */ cal_times_sent INT NOT NULL default '0', /* action as imported, may be used in the future */ cal_action VARCHAR(12) NOT NULL default 'EMAIL', PRIMARY KEY ( cal_id ) ); /** * Define a group. Group members can be found in * <a href="#webcal_group_user">webcal_group_user</a>. */ CREATE TABLE webcal_group ( /* unique group id */ cal_group_id INT NOT NULL, /* user login of user that created this group */ cal_owner VARCHAR(25) NULL, /* name of the group */ cal_name VARCHAR(50) NOT NULL, /* date last updated (in YYYYMMDD format) */ cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ) ); /** * Specify users in a group. The group is defined in * <a href="#webcal_group">webcal_group</a>. */ CREATE TABLE webcal_group_user ( /* group id */ cal_group_id INT NOT NULL, /* user login */ cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); /** * A "view" allows a user to put the calendars of multiple users all on one * page. A "view" is valid only for the owner (cal_owner) of the view. * Users for the view are in * <a href="#webcal_view_user">webcal_view_user</a>. */ CREATE TABLE webcal_view ( /* unique view id */ cal_view_id INT NOT NULL, /* login name of owner of this view */ cal_owner VARCHAR(25) NOT NULL, /* name of view */ cal_name VARCHAR(50) NOT NULL, /* "W" for week view, "D" for day view, "M" for month view */ cal_view_type CHAR(1), /* is this a global view (can it be accessed by other users) ('Y' or 'N') */ cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_view_id ) ); /** * Specify users in a view. See <a href="#webcal_view">webcal_view</a>. */ CREATE TABLE webcal_view_user ( /* view id */ cal_view_id INT NOT NULL, /* a user in the view */ cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); /** * System settings (set by the admin interface in admin.php) */ CREATE TABLE webcal_config ( /* setting name */ cal_setting VARCHAR(50) NOT NULL, /* setting value */ cal_value VARCHAR(100) NULL, PRIMARY KEY ( cal_setting ) ); /** * Activity log for an event. */ CREATE TABLE webcal_entry_log ( /* unique id of this log entry */ cal_log_id INT NOT NULL, /* event id */ cal_entry_id INT NOT NULL, /* user who performed this action */ cal_login VARCHAR(25) NOT NULL, /* user of calendar affected */ cal_user_cal VARCHAR(25) NULL, /* log types: */ /* <ul> */ /* <li>C: Created</li> */ /* <li>A: Approved/Confirmed by user</li> */ /* <li>R: Rejected by user</li> */ /* <li>U: Updated by user</li> */ /* <li>M: Mail Notification sent</li> */ /* <li>E: Reminder sent</li> */ /* </ul> */ cal_type CHAR(1) NOT NULL, /* date in YYYYMMDD format */ cal_date INT NOT NULL, /* time in HHMMSS format */ cal_time INT NULL, /* optional text */ cal_text TEXT, PRIMARY KEY ( cal_log_id ) ); /** * Defines user categories. Categories can be specific to a user or global. * When a category is global, the cat_owner field will be NULL. * (Only an admin user can create a global category.) */ CREATE TABLE webcal_categories ( /* unique category id */ cat_id INT NOT NULL, /* user login of category owner. */ /* If this is NULL, then it is a global category */ cat_owner VARCHAR(25) NULL, /* category name */ cat_name VARCHAR(80) NOT NULL, /* RGB color for category */ cat_color VARCHAR(8) NULL, PRIMARY KEY ( cat_id ) ); /** * Define assitant/boss relationship. */ CREATE TABLE webcal_asst ( /* user login of boss */ cal_boss VARCHAR(25) NOT NULL, /* user login of assistant */ cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); /** * Defines non-user calendars. */ CREATE TABLE webcal_nonuser_cals ( /* the unique id for the calendar */ cal_login VARCHAR(25) NOT NULL, /* calendar's last name */ cal_lastname VARCHAR(25) NULL, /* calendar's first name */ cal_firstname VARCHAR(25) NULL, /* who is the calendar administrator */ cal_admin VARCHAR(25) NOT NULL, /* can this nonuser calendar be a public calendar (no login required) */ cal_is_public CHAR(1) NOT NULL DEFAULT 'N', /* url of the remote calendar */ cal_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY ( cal_login ) ); /** * Used to track import data (one row per import) */ CREATE TABLE webcal_import ( /* unique id for import */ cal_import_id INT NOT NULL, /* name of import (optional) */ cal_name VARCHAR(50) NULL, /* date of import (YYYYMMDD format) */ cal_date INT NOT NULL, /* type of import (ical, vcal, palm, outlookcsv) */ cal_type VARCHAR(10) NOT NULL, /* user who performed the import */ cal_login VARCHAR(25) NULL, PRIMARY KEY ( cal_import_id ) ); /** * Used to track import data (one row per event) */ CREATE TABLE webcal_import_data ( /* import id (from webcal_import table) */ cal_import_id INT NOT NULL, /* event id in WebCalendar */ cal_id INT NOT NULL, /* user login */ cal_login VARCHAR(25) NOT NULL, /* type of import: 'palm', 'vcal', 'ical' or 'outlookcsv' */ cal_import_type VARCHAR(15) NOT NULL, /* external id used in external calendar system */ /* (for example, UID in iCal) */ cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ) ); /** * Defines a custom report created by a user. */ CREATE TABLE webcal_report ( /* creator of report */ cal_login VARCHAR(25) NOT NULL, /* unique id of this report */ cal_report_id INT NOT NULL, /* is this a global report (can it be accessed by other users) */ /* ('Y' or 'N') */ cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, /* format of report (html, plain or csv) */ cal_report_type VARCHAR(20) NOT NULL, /* if cal_report_type is 'html', should the DEFAULT HTML header and */ /* trailer be included? ('Y' or 'N') */ cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, /* name of the report */ cal_report_name VARCHAR(50) NOT NULL, /* time range for report: */ /* <ul> */ /* <li>0 = tomorrow</li> */ /* <li>1 = today</li> */ /* <li>2 = yesterday</li> */ /* <li>3 = day before yesterday</li> */ /* <li>10 = next week</li> */ /* <li>11 = current week</li> */ /* <li>12 = last week</li> */ /* <li>13 = week before last</li> */ /* <li>20 = next week and week after</li> */ /* <li>21 = current week and next week</li> */ /* <li>22 = last week and this week</li> */ /* <li>23 = last two weeks</li> */ /* <li>30 = next month</li> */ /* <li>31 = current month</li> */ /* <li>32 = last month</li> */ /* <li>33 = month before last</li> */ /* <li>40 = next year</li> */ /* <li>41 = current year</li> */ /* <li>42 = last year</li> */ /* <li>43 = year before last</li> */ /* </ul> */ cal_time_range INT NOT NULL, /* user calendar to display (NULL indicates current user) */ cal_user VARCHAR(25) NULL, /* allow user to navigate to different dates with next/previous */ /* ('Y' or 'N') */ cal_allow_nav CHAR(1) DEFAULT 'Y', /* category to filter on (optional) */ cal_cat_id INT NULL, /* include empty dates in report ('Y' or 'N') */ cal_include_empty CHAR(1) DEFAULT 'N', /* include a link for this report in the "Go to" section of the */ /* navigation in the page trailer ('Y' or 'N') */ cal_show_in_trailer CHAR(1) DEFAULT 'N', /* date created or last updated (in YYYYMMDD format) */ cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ) ); /** * Defines one of the templates used for a report. * Each report has three templates: * <ol> * <li>Page template - Defines the entire page (except for header and * footer). The following variables can be defined: * <ul> * <li>${days}<sup>*</sup> * - the HTML of all dates (generated from the Date template)</li> * </ul></li> * <li>Date template - Defines events for one day. If the report * is for a week or month, then the results of each day will be * concatenated and used as the ${days} variable in the Page template. * The following variables can be defined: * <ul> * <li>${events}<sup>*</sup> - the HTML of all events * for the data (generated from the Event template)</li> * <li>${date} - the date</li> * <li>${fulldate} - date (includes weekday)</li> * </ul></li> * <li>Event template - Defines a single event. * The following variables can be defined: * <ul> * <li>${name}<sup>*</sup> - Brief Description of event</li> * <li>${description} - Full Description of event</li> * <li>${date} - Date of event</li> * <li>${fulldate} - Date of event (includes weekday)</li> * <li>${time} - Time of event (4:00pm - 4:30pm)</li> * <li>${starttime} - Start time of event</li> * <li>${endtime} - End time of event</li> * <li>${duration} - Duration of event (in minutes)</li> * <li>${priority} - Priority of event</li> * <li>${href} - URL to view event details</li> * </ul></li> * </ol> * <sup>*</sup> denotes a required template variable */ CREATE TABLE webcal_report_template ( /* report id (in webcal_report table) */ cal_report_id INT NOT NULL, /* type of template: <ul> */ /* <li>'P': page template represents entire document</li> */ /* <li>'D': date template represents a single day of events</li> */ /* <li>'E': event template represents a single event</li> */ /* </ul> */ cal_template_type CHAR(1) NOT NULL, /* text of template */ cal_template_text TEXT, PRIMARY KEY ( cal_report_id, cal_template_type ) ); /** * Specifies which users can access another user's calendar. */ CREATE TABLE webcal_access_user ( /* the current user who is attempting to look at another user's calendar */ cal_login VARCHAR(25) NOT NULL, /* the login of the other user whose calendar the current user */ /* wants to access */ cal_other_user VARCHAR(25) NOT NULL, /* can current user view events on the other user's calendar? */ cal_can_view INT NOT NULL DEFAULT '0', /* can current user edit events on the other user's calendar? */ cal_can_edit INT NOT NULL DEFAULT '0', /* can current user approve events on the other user's calendar? */ cal_can_approve INT NOT NULL DEFAULT '0', /* can current user see other user in Participant lists? */ cal_can_invite CHAR(1) DEFAULT 'Y', /* can current user send emails to other user? */ cal_can_email CHAR(1) DEFAULT 'Y', /* can current user can only see time of other user? */ cal_see_time_only CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_other_user ) ); /** * Specifies what WebCalendar functions a user can access. Each function * has a corresponding numeric value (specified in the file * includes/access.php). For example, view event is 0, so the very first * character in the cal_permissions column is either a "Y" if this user * can view events or a "N" if they cannot. */ CREATE TABLE webcal_access_function ( /* user login */ cal_login VARCHAR(25) NOT NULL, /* a string of 'Y' or 'N' for the various functions */ cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ) ); /** * This table stores the custom header/stylesheet/trailer. If configured * properly, each user (or nonuser cal) can have their own custom * header/trailer. */ CREATE TABLE webcal_user_template ( /* user login (or nonuser cal name), the DEFAULT for all users is stored */ /* with the username '__system__' */ cal_login VARCHAR(25) NOT NULL, /* type ('H' = header, 'S' = stylesheet/script, 'T' = trailer) */ cal_type CHAR(1) NOT NULL, /* text of template */ cal_template_text TEXT, PRIMARY KEY ( cal_login, cal_type ) ); /** * This table stores event attachments and comments. */ CREATE TABLE webcal_blob ( /* Unique identifier for this object */ cal_blob_id INT NOT NULL, /* event id (if applicable) */ cal_id INT NULL, /* login of user who created */ cal_login VARCHAR(25) NULL, /* filename of object (not used for comments) */ cal_name VARCHAR(30) NULL, /* description of what the object is (subject for comment) */ cal_description VARCHAR(128) NULL, /* size of object (not used for comment) */ cal_size INT NULL, /* MIME type of object (as specified by browser during upload) */ /* (not used for comment) */ cal_mime_type VARCHAR(50) NULL, /* type of object: C=Comment, A=Attachment */ cal_type CHAR(1) NOT NULL, /* date added (in YYYYMMDD format) */ cal_mod_date INT NOT NULL, /* time added in HHMMSS format */ cal_mod_time INT NOT NULL, /* binary data for object */ cal_blob LONGBLOB, PRIMARY KEY ( cal_blob_id ) ); /** * This table stores timezones of the world. */ CREATE TABLE webcal_timezones ( /* Unique name of timezone, try to use Olsen naming conventions */ tzid varchar(100) NOT NULL default '', /* earliest date this timezone represents YYYYMMDDTHHMMSSZ format */ dtstart varchar(25) default NULL, /* last date this timezone represents YYYYMMDDTHHMMSSZ format */ dtend varchar(25) default NULL, /* Complete VTIMEZONE text gleaned from imported ics files */ vtimezone text, PRIMARY KEY ( tzid ) ); PK 큓\F���F1 F1 upgrade-ibase.sqlnu �[��� /* $Id: upgrade-ibase.sql,v 1.30 2009/10/30 11:47:16 bbannon Exp $ */ /*UPGRADE_V0.9.14*/ UPDATE WEBCAL_ENTRY SET CAL_TIME = -1 WHERE CAL_TIME IS NULL; CREATE TABLE WEBCAL_ENTRY_REPEATS ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_TYPE VARCHAR(20) CHARACTER SET WIN1252, CAL_END INTEGER, CAL_FREQUENCY INTEGER DEFAULT 1, CAL_DAYS CHAR(7) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_ENTRY_REPEATSNEWINDEX ON WEBCAL_ENTRY_REPEATS(CAL_ID); /*UPGRADE_V0.9.22*/ CREATE TABLE WEBCAL_USER_LAYERS ( CAL_LAYERID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_LAYERUSER VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_COLOR VARCHAR(25) CHARACTER SET WIN1252, CAL_DUPS CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' ); CREATE INDEX IWEBCAL_USER_LAYERSNEWINDEX ON WEBCAL_USER_LAYERS(CAL_LOGIN, CAL_LAYERUSER); /*UPGRADE_V0.9.27*/ CREATE TABLE WEBCAL_SITE_EXTRAS ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_NAME VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_TYPE INTEGER NOT NULL, CAL_DATE INTEGER DEFAULT 0, CAL_REMIND INTEGER DEFAULT 0, CAL_DATA VARCHAR(500) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_SITE_EXTRASNEWINDEX ON WEBCAL_SITE_EXTRAS(CAL_ID, CAL_NAME, CAL_TYPE); /*UPGRADE_V0.9.35*/ CREATE TABLE WEBCAL_GROUP ( CAL_GROUP_ID INTEGER DEFAULT 0 NOT NULL, CAL_OWNER VARCHAR(25) CHARACTER SET WIN1252, CAL_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_LAST_UPDATE INTEGER DEFAULT 0 NOT NULL ); CREATE INDEX IWEBCAL_GROUPNEWINDEX ON WEBCAL_GROUP(CAL_GROUP_ID); CREATE TABLE WEBCAL_GROUP_USER ( CAL_GROUP_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_GROUPUSERNEWINDEX ON WEBCAL_GROUP_USER(CAL_GROUP_ID, CAL_LOGIN); CREATE TABLE WEBCAL_VIEW ( CAL_VIEW_ID INTEGER DEFAULT 0 NOT NULL, CAL_OWNER VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_VIEW_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_IS_GLOBAL CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL ); CREATE INDEX IWEBCAL_VIEWNEWINDEX ON WEBCAL_VIEW(CAL_VIEW_ID); CREATE TABLE WEBCAL_VIEW_USER ( CAL_VIEW_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_VIEWUSERNEWINDEX ON WEBCAL_VIEW_USER(CAL_VIEW_ID, CAL_LOGIN); CREATE TABLE WEBCAL_CONFIG ( CAL_SETTING VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_VALUE VARCHAR(100) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_CONFIGNEWINDEX ON WEBCAL_CONFIG(CAL_SETTING); CREATE TABLE WEBCAL_ENTRY_LOG ( CAL_LOG_ID INTEGER DEFAULT 0 NOT NULL, CAL_ENTRY_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_USER_CAL VARCHAR(25) CHARACTER SET WIN1252, CAL_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_DATE INTEGER, CAL_TIME INTEGER, CAL_TEXT VARCHAR(500) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_ENTRYLOGINDEX ON WEBCAL_ENTRY_LOG(CAL_LOG_ID); /*UPGRADE_V0.9.37*/ CREATE TABLE WEBCAL_ENTRY_REPEATS_NOT ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_DATE INTEGER NOT NULL ); CREATE INDEX IWEBCAL_ENTRY_REP_NOTNEWINDEX ON WEBCAL_ENTRY_REPEATS_NOT(CAL_ID, CAL_DATE); /*UPGRADE_V0.9.38*/ ALTER TABLE WEBCAL_ENTRY_USER ADD CAL_CATEGORY INTEGER DEFAULT NULL; CREATE TABLE WEBCAL_CATEGORIES ( CAT_ID INTEGER DEFAULT 0 NOT NULL, CAT_OWNER VARCHAR(25) CHARACTER SET WIN1252, CAT_NAME VARCHAR(80) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_CATEGORIESINDEX ON WEBCAL_CATEGORIES(CAT_ID); /*UPGRADE_V0.9.40*/ DELETE FROM WEBCAL_CONFIG WHERE CAL_SETTING LIKE 'DATE_FORMAT%'; DELETE FROM WEBCAL_USER_PREF WHERE CAL_SETTING LIKE 'DATE_FORMAT%'; CREATE TABLE WEBCAL_ASST ( CAL_BOSS VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_ASSISTANT VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_BOSSINDEX ON WEBCAL_ASST(CAL_BOSS, CAL_ASSISTANT); CREATE TABLE WEBCAL_ENTRY_EXT_USER ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_FULLNAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_EMAIL VARCHAR(75) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_ENTRY_EXTUSERNEWINDEX ON WEBCAL_ENTRY_EXT_USER(CAL_ID, CAL_FULLNAME); ALTER TABLE WEBCAL_ENTRY ADD CAL_EXT_FOR_ID INTEGER DEFAULT NULL; /*UPGRADE_V0.9.41*/ CREATE TABLE WEBCAL_NONUSER_CALS ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_LASTNAME VARCHAR(25) CHARACTER SET WIN1252, CAL_FIRSTNAME VARCHAR(25) CHARACTER SET WIN1252, CAL_ADMIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_NONUSERCALSINDEX ON WEBCAL_NONUSER_CALS(CAL_LOGIN); /*UPGRADE_V0.9.42*/ CREATE TABLE WEBCAL_REPORT ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_REPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_IS_GLOBAL VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL, CAL_REPORT_TYPE VARCHAR(20) CHARACTER SET WIN1252 NOT NULL, CAL_INCLUDE_HEADER VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_REPORT_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_TIME_RANGE INTEGER DEFAULT 0 NOT NULL, CAL_USER VARCHAR(25) CHARACTER SET WIN1252, CAL_ALLOW_NAV VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_CAT_ID INTEGER, CAL_INCLUDE_EMPTY VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL, CAL_SHOW_IN_TRAILER VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL, CAL_UPDATE_DATE INTEGER DEFAULT 0 NOT NULL ); CREATE INDEX IWEBCAL_REPORTINDEX ON WEBCAL_REPORT(CAL_REPORT_ID); CREATE TABLE WEBCAL_REPORT_TEMPLATE ( CAL_REPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_TEMPLATE_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_TEMPLATE_TEXT VARCHAR(1024) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_REPORTTEMPLATEINDEX ON WEBCAL_REPORT_TEMPLATE(CAL_REPORT_ID, CAL_TEMPLATE_TYPE); /*UPGRADE_V0.9.43*/ ALTER TABLE WEBCAL_USER ALTER CAL_PASSWD VARCHAR(32); CREATE TABLE WEBCAL_IMPORT ( CAL_IMPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_NAME VARCHAR(50) CHARACTER SET WIN1252, CAL_DATE INTEGER DEFAULT 0 NOT NULL, CAL_TYPE VARCHAR(10) CHARACTER SET WIN1252 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_IMPORT2INDEX ON WEBCAL_IMPORT(CAL_IMPORT_ID); CREATE TABLE WEBCAL_IMPORT_DATA ( CAL_IMPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_IMPORT_TYPE VARCHAR(15) CHARACTER SET WIN1252 NOT NULL, CAL_EXTERNAL_ID VARCHAR(200) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_IMPORTINDEX ON WEBCAL_IMPORT_DATA(CAL_LOGIN, CAL_ID); /*UPGRADE_V1.0RC3*/ ALTER TABLE WEBCAL_VIEW ADD CAL_IS_GLOBAL CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL; UPDATE WEBCAL_USER_PREF SET CAL_VALUE = 'DAY.PHP' WHERE CAL_VALUE = 'DAY' AND CAL_SETTING = 'STARTVIEW'; UPDATE WEBCAL_USER_PREF SET CAL_VALUE = 'WEEK.PHP' WHERE CAL_VALUE = 'WEEK' AND CAL_SETTING = 'STARTVIEW'; UPDATE WEBCAL_USER_PREF SET CAL_VALUE = 'MONTH.PHP' WHERE CAL_VALUE = 'MONTH' AND CAL_SETTING = 'STARTVIEW'; UPDATE WEBCAL_USER_PREF SET CAL_VALUE = 'YEAR.PHP' WHERE CAL_VALUE = 'YEAR' AND CAL_SETTING = 'STARTVIEW'; UPDATE WEBCAL_CONFIG SET CAL_VALUE = 'WEEK.PHP' WHERE CAL_SETTING = 'STARTVIEW'; /*upgrade_v1.1.0-CVS*/ CREATE TABLE WEBCAL_ACCESS_FUNCTION ( cal_login VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_PERMISSIONS VARCHAR(64) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_ACCESSFUNCTIONINDEX ON WEBCAL_ACCESS_FUNCTION(CAL_LOGIN); CREATE TABLE WEBCAL_ACCESS_USER ( cal_login VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, cal_other_user VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); ALTER TABLE WEBCAL_NONUSER_CALS ADD CAL_IS_PUBLIC CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL; /*upgrade_v1.1.0a-CVS*/ CREATE TABLE WEBCAL_USER_TEMPLATE ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_TEMPLATE_TEXT VARCHAR(1024) CHARACTER SET WIN1252 NOT NULL ); CREATE INDEX IWEBCAL_USERTEMPLATE ON WEBCAL_USER_TEMPLATE(CAL_LOGIN,CAL_TYPE); ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_ENDTIME INTEGER DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_BYMONTH VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_BYMONTHDAY VARCHAR(100) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_BYDAY VARCHAR(100) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_BYSETPOS VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_BYWEEKNO VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_BYYEARDAY VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_WKST CHAR(2) CHARACTER SET WIN1252 DEFAULT 'MO'; ALTER TABLE WEBCAL_ENTRY_REPEATS ADD CAL_COUNT INTEGER DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_REPEATS_NOT ADD CAL_EXDATE INTEGER DEFAULT '1' NOT NULL; ALTER TABLE WEBCAL_ENTRY ADD CAL_DUE_DATE INTEGER DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY ADD CAL_DUE_TIME INTEGER DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY ADD CAL_LOCATION VARCHAR(100) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY ADD CAL_URL VARCHAR(100) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY ADD CAL_COMPLETED INTEGER DEFAULT NULL; ALTER TABLE WEBCAL_ENTRY_USER ADD CAL_PERCENT INTEGER DEFAULT '0' NOT NULL; DROP INDEX IWEBCAL_SITE_EXTRASNEWINDEX; /*upgrade_v1.1.0b-CVS*/ CREATE TABLE WEBCAL_ENTRY_CATEGORIES ( CAL_ID INTEGER DEFAULT '0' NOT NULL, CAT_ID INTEGER DEFAULT '0' NOT NULL, CAT_ORDER INTEGER DEFAULT '0' NOT NULL, CAT_OWNER VARCHAR(25) CHARACTER SET WIN1252 DEFAULT NULL ); /*upgrade_v1.1.0c-CVS*/ CREATE TABLE WEBCAL_BLOB ( CAL_BLOB_ID INTEGER NOT NULL, CAL_ID INTEGER DEFAULT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 DEFAULT NULL, CAL_NAME VARCHAR(30) CHARACTER SET WIN1252 DEFAULT NULL, CAL_DESCRIPTION VARCHAR(128) CHARACTER SET WIN1252 DEFAULT NULL, CAL_SIZE INTEGER DEFAULT NULL, CAL_MIME_TYPE VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL, CAL_TYPE CHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_MOD_DATE INTEGER NOT NULL, CAL_MOD_TIME INTEGER NOT NULL, CAL_BLOB BLOB ); CREATE INDEX IWEBCAL_BLOB ON WEBCAL_BLOB(CAL_BLOB_ID); /*upgrade_v1.1.0d-CVS*/ DROP TABLE WEBCAL_ACCESS_USER; CREATE TABLE WEBCAL_ACCESS_USER ( cal_login VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, cal_other_user VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_CAN_VIEW INTEGER DEFAULT '0' NOT NULL, CAL_CAN_EDIT INTEGER DEFAULT '0' NOT NULL, CAL_CAN_APPROVE INTEGER DEFAULT '0' NOT NULL, CAL_CAN_INVITE CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_CAN_EMAIL CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_SEE_TIMES_ONLY CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL ); CREATE INDEX IWEBCAL_ACCESSUSERINDEX ON WEBCAL_ACCESS_USER(CAL_LOGIN, CAL_OTHER_USER); /*upgrade_v1.1.0e-CVS*/ CREATE TABLE WEBCAL_REMINDERS ( CAL_ID INTEGER DEFAULT '0' NOT NULL, CAL_DATE INTEGER DEFAULT '0' NOT NULL, CAL_OFFSET INTEGER DEFAULT '0' NOT NULL, CAL_RELATED CHAR(1) CHARACTER SET WIN1252 DEFAULT 'S' NOT NULL, CAL_BEFORE CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_LAST_SENT INTEGER DEFAULT '0' NOT NULL, CAL_REPEATS INTEGER DEFAULT '0' NOT NULL, CAL_DURATION INTEGER DEFAULT '0' NOT NULL, CAL_TIMES_SENT INTEGER DEFAULT '0' NOT NULL, CAL_ACTION VARCHAR(12) CHARACTER SET WIN1252 DEFAULT 'EMAIL' NOT NULL ); CREATE INDEX IWEBCAL_REMINDERSNEWINDEX ON WEBCAL_REMINDERS(CAL_ID); /*upgrade_v1.1.1*/ ALTER TABLE webcal_nonuser_cals ADD cal_url VARCHAR(75) CHARACTER SET WIN1252 DEFAULT NULL; /*upgrade_v1.1.2*/ ALTER TABLE webcal_categories ADD cat_color VARCHAR(8) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE webcal_user ADD cal_enabled CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y'; ALTER TABLE webcal_user ADD cal_telephone VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE webcal_user ADD cal_address VARCHAR(75) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE webcal_user ADD cal_title VARCHAR(75) CHARACTER SET WIN1252 DEFAULT NULL; ALTER TABLE webcal_user ADD cal_birthday INT NULL; ALTER TABLE webcal_user ADD cal_last_login INT NULL; /*upgrade_v1.1.3*/ CREATE TABLE webcal_TIMEZONES ( TZID VARCHAR(100) CHARACTER SET WIN1252 DEFAULT '' NOT NULL, DTSTART VARCHAR(25) CHARACTER SET WIN1252 DEFAULT NULL, DTEND VARCHAR(25) CHARACTER SET WIN1252 DEFAULT NULL, VTIMEZONE VARCHAR(500) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_TIMEZONESNEWINDEX ON WEBCAL_TIMEZONES(TZID); /*upgrade_v1.3.0*/ PK 큓\�Ja=$ =$ upgrade-db2.sqlnu �[��� /* $Id: upgrade-db2.sql,v 1.28 2009/10/30 11:47:16 bbannon Exp $ */ /*upgrade_v0.9.14*/ UPDATE webcal_entry SET cal_time = -1 WHERE cal_time is null; CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT 0 NOT NULL, cal_type VARCHAR(20), cal_end INT, cal_frequency INT DEFAULT 1, cal_days CHAR(7), PRIMARY KEY (cal_id) ); /*upgrade_v0.9.22*/ CREATE TABLE webcal_user_layers ( cal_layerid INT DEFAULT 0 NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_layeruser VARCHAR(25) NOT NULL, cal_color VARCHAR(25), cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ) ); /*upgrade_v0.9.27*/ CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT 0 NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT 0, cal_remind INT DEFAULT 0, cal_data VARCHAR(1024), PRIMARY KEY ( cal_id, cal_name, cal_type ) ); /*upgrade_v0.9.35*/ CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_owner VARCHAR(25), cal_name VARCHAR(50) NOT NULL, cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_view_type CHAR(1), PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(50), PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_date INT NOT NULL, cal_time INT, cal_text VARCHAR(1024), PRIMARY KEY ( cal_log_id ) ); /*upgrade_v0.9.37*/ ALTER TABLE webcal_entry_log ADD cal_user_cal VARCHAR(25); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); /*upgrade_v0.9.38*/ ALTER TABLE webcal_entry_user ADD cal_category INT DEFAULT NULL; CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_owner VARCHAR(25), cat_name VARCHAR(80) NOT NULL, PRIMARY KEY ( cat_id ) ); /*upgrade_v0.9.40*/ DELETE FROM webcal_config WHERE cal_setting LIKE 'DATE_FORMAT%'; DELETE FROM webcal_user_pref WHERE cal_setting LIKE 'DATE_FORMAT%'; CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75), PRIMARY KEY ( cal_id, cal_fullname ) ); ALTER TABLE webcal_entry ADD cal_ext_for_id INT; /*upgrade_v0.9.41*/ CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_lastname VARCHAR(25), cal_firstname VARCHAR(25), cal_admin VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_login ) ); /*upgrade_v0.9.42*/ CREATE TABLE webcal_report ( cal_login VARCHAR(25) NOT NULL, cal_report_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_time_range INT NOT NULL, cal_user VARCHAR(25), cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT, cal_include_empty CHAR(1) DEFAULT 'N', cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text VARCHAR(1024), PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_import_data ( cal_id int NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v0.9.43*/ ALTER TABLE webcal_user MODIFY cal_passwd VARCHAR(32); DROP TABLE webcal_import_data; CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_name VARCHAR(50), cal_date INT NOT NULL, cal_type VARCHAR(10) NOT NULL, cal_login VARCHAR(25), PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_import_id INT NOT NULL, cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200), PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v1.0RC3*/ ALTER TABLE webcal_view ADD cal_is_global CHAR(1) DEFAULT 'N' NOT NULL; UPDATE webcal_user_pref SET cal_value = 'day.php' WHERE cal_value = 'day' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'week.php' WHERE cal_value = 'week' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'month.php' WHERE cal_value = 'month' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'year.php' WHERE cal_value = 'year' AND cal_setting = 'STARTVIEW'; UPDATE webcal_config SET cal_value = 'week.php' WHERE cal_setting = 'STARTVIEW'; /*upgrade_v1.1.0-CVS*/ CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); ALTER TABLE webcal_nonuser_cals ADD cal_is_public CHAR(1) DEFAULT 'N' NOT NULL; /*upgrade_v1.1.0a-CVS*/ CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text VARCHAR(1024), PRIMARY KEY ( cal_login, cal_type ) ); ALTER TABLE webcal_entry_repeats ADD cal_endtime INT DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonth VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonthday VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byday VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bysetpos VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byweekno VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byyearday VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_wkst CHAR(2) DEFAULT 'MO'; ALTER TABLE webcal_entry_repeats ADD cal_count INT DEFAULT NULL; ALTER TABLE webcal_entry_repeats_not ADD cal_exdate INT NOT NULL DEFAULT 1; ALTER TABLE webcal_entry ADD cal_due_date INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_due_time INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_location VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_url VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_completed INT DEFAULT NULL; ALTER TABLE webcal_entry_user ADD cal_percent INT NOT NULL DEFAULT 0; ALTER TABLE webcal_site_extras DROP PRIMARY KEY; /*upgrade_v1.1.0b-CVS*/ CREATE TABLE webcal_entry_categories ( cal_id INT NOT NULL DEFAULT 0, cat_id INT NOT NULL DEFAULT 0, cat_order INT NOT NULL DEFAULT 0, cat_owner VARCHAR(25) DEFAULT NULL ); /*upgrade_v1.1.0c-CVS*/ CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT, cal_login VARCHAR(25), cal_name VARCHAR(30), cal_description VARCHAR(128), cal_size INT, cal_mime_type VARCHAR(50), cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob BLOB, PRIMARY KEY ( cal_blob_id ) ); /*upgrade_v1.1.0d-CVS*/ DROP TABLE webcal_access_user; CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT DEFAULT '0' NOT NULL, cal_can_edit INT DEFAULT '0' NOT NULL, cal_can_approve INT DEFAULT '0' NOT NULL, cal_can_invite CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_email CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_see_times_only CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); /*upgrade_v1.1.0e-CVS*/ CREATE TABLE webcal_reminders ( cal_id INT DEFAULT '0' NOT NULL, cal_date INT DEFAULT '0' NOT NULL, cal_offset INT DEFAULT '0' NOT NULL, cal_related CHAR(1) DEFAULT 'S' NOT NULL, cal_before CHAR(1) DEFAULT 'Y' NOT NULL, cal_last_sent INT DEFAULT '0' NOT NULL, cal_repeats INT DEFAULT '0' NOT NULL, cal_duration INT DEFAULT '0' NOT NULL, cal_times_sent INT DEFAULT '0' NOT NULL, cal_action VARCHAR(12) DEFAULT 'EMAIL' NOT NULL, PRIMARY KEY ( cal_id ) ); /*upgrade_v1.1.1*/ ALTER TABLE webcal_nonuser_cals ADD cal_url VARCHAR(255) DEFAULT NULL; /*upgrade_v1.1.2*/ ALTER TABLE webcal_categories ADD cat_color VARCHAR(8) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_enabled CHAR(1) DEFAULT 'Y'; ALTER TABLE webcal_user ADD cal_telephone VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_address VARCHAR(75) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_title VARCHAR(75) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_birthday INT NULL; ALTER TABLE webcal_user ADD cal_last_login INT NULL; /*upgrade_v1.1.3*/ CREATE TABLE webcal_timezones ( tzid VARCHAR(100) DEFAULT '' NOT NULL, dtstart VARCHAR(25) DEFAULT NULL, dtend VARCHAR(25) DEFAULT NULL, vtimezone VARCHAR(500), PRIMARY KEY ( tzid ) ); /*upgrade_v1.3.0*/ PK 큓\�y�@ @ upgrade_matrix.phpnu �[��� <?php //Program Version for this release $PROGRAM_VERSION = 'v1.3.0'; //array element[0] = sql insertion testy //array element[1] = sql delete to clean up //array element[2] = old program version **The last entry will be the $PROGRAM_VERSION //array element[3] = install point in upgrade-mysql.php $database_upgrade_matrix = [ ['INSERT INTO webcal_user_pref VALUES ( "zzz","zzz","zzz" )', 'DELETE FROM webcal_user_pref WHERE cal_login = "zzz"', 'pre-v0.9.07', 'upgrade_v0.9.14'], ['INSERT INTO webcal_entry_repeats ( cal_id ) VALUES ( -999 )', 'DELETE FROM webcal_entry_repeats WHERE cal_id = -999', 'v0.9.12 - v0.9.13', 'upgrade_v0.9.14'], ['INSERT INTO webcal_user_layers ( cal_layerid, cal_login, cal_layeruser ) VALUES ( -999,"zzz","zzz" )', 'DELETE FROM webcal_user_layers WHERE cal_layerid = -999', 'v0.9.14 - v0.9.21', 'upgrade_v0.9.22'], ['INSERT INTO webcal_site_extras ( cal_id, cal_name )VALUES ( -999,"zzz" )', 'DELETE FROM webcal_site_extras WHERE cal_id = -999', 'v0.9.22 - v0.9.26', 'upgrade_v0.9.27'], ['INSERT INTO webcal_group VALUES ( -999,"zzz","zzz", -999 )', 'DELETE FROM webcal_group WHERE cal_group_id = -999', 'v0.9.27 - v0.9.34', 'upgrade_v0.9.35'], ['INSERT INTO webcal_entry_repeats_not ( cal_id ) VALUES ( -999 )', 'DELETE FROM webcal_entry_repeats_not WHERE cal_id = -999', 'v0.9.35 - v0.9.36', 'upgrade_v0.9.37'], ['INSERT INTO webcal_categories ( cat_id, cat_owner, cat_name ) VALUES ( -999,"zzz","zzz" )', 'DELETE FROM webcal_categories WHERE cat_id = -999', 'v0.9.37', 'upgrade_v0.9.38'], ['INSERT INTO webcal_asst ( cal_boss, cal_assistant ) VALUES ( "zzz","zzz" )', 'DELETE FROM webcal_asst WHERE cal_boss = "zzz"', 'v0.9.38 - v0.9.39', 'upgrade_v0.9.40'], ['INSERT INTO webcal_nonuser_cals ( cal_login, cal_admin ) VALUES ( "zzz","zzz" )', 'DELETE FROM webcal_nonuser_cals WHERE cal_login = "zzz"', 'v0.9.40', 'upgrade_v0.9.41'], ['INSERT INTO webcal_report_template ( cal_report_id, cal_template_type ) VALUES ( -999, "Z" )', 'DELETE FROM webcal_report_template WHERE cal_report_id = -999', 'v0.9.41', 'upgrade_v0.9.42'], ['INSERT INTO webcal_import ( cal_import_id, cal_type ) VALUES ( -999, "zzz" )', 'DELETE FROM webcal_import WHERE cal_import_id = -999', 'v0.9.42', 'upgrade_v0.9.43'], ['INSERT INTO webcal_view ( cal_view_id, cal_is_global ) VALUES ( -999, "Z" )', 'DELETE FROM webcal_view WHERE cal_view_id = -999', 'v0.9.43 - v1.0RC', 'upgrade_v1.0RC3'], ['INSERT INTO webcal_access_function ( cal_login, cal_permissions ) VALUES ( "zzz","zzz" )', 'DELETE FROM webcal_access_function WHERE cal_login = "zzz"', 'v1.0RC3 - v1.0.5', 'upgrade_v1.1.0-CVS'], ['INSERT INTO webcal_user_template ( cal_login, cal_type ) VALUES ( "zzz", "Z" )', 'DELETE FROM webcal_user_template WHERE cal_login = "zzz"', 'v1.1.0-CVS', 'upgrade_v1.1.0a-CVS'], ['INSERT INTO webcal_entry_categories ( cal_id ) VALUES ( -999)', 'DELETE FROM webcal_entry_categories WHERE cal_id = -999', 'v1.1.0a-CVS', 'upgrade_v1.1.0b-CVS'], ['INSERT INTO webcal_blob ( cal_blob_id, cal_type ) VALUES ( -999, "Z" )', 'DELETE FROM webcal_blob WHERE cal_blob_id = -999', 'v1.1.0b-CVS', 'upgrade_v1.1.0c-CVS'], ['INSERT INTO webcal_access_user ( cal_login, cal_other_user ) VALUES ( "zzz", "zzz" )', 'DELETE FROM webcal_access_user WHERE cal_login = "zzz"', 'v1.1.0c-CVS', 'upgrade_v1.1.0d-CVS'], ['INSERT INTO webcal_reminders ( cal_id ) VALUES ( -999 )', 'DELETE FROM webcal_reminders WHERE cal_id = -999', 'v1.1.0d-CVS', 'upgrade_v1.1.0e-CVS'], ['INSERT INTO webcal_nonuser_cals ( cal_login, cal_admin, cal_url ) VALUES ( "zzz", "zzz", "zzz" )', 'DELETE FROM webcal_nonuser_cals WHERE cal_login = "zzz"', 'v1.1.0e-CVS', 'upgrade_v1.1.1'], ['INSERT INTO webcal_categories ( cat_id, cat_name, cat_color ) VALUES ( "999", "zzz", "#FFFFFF" )', 'DELETE FROM webcal_categories WHERE cat_id = 999', 'v1.1.1', 'upgrade_v1.1.2'], // Craig. These two tests are identical. Do we really need both? ['INSERT INTO webcal_timezones ( tzid ) VALUES ( "zzz" )', 'DELETE FROM webcal_timezones WHERE tzid = "zzz"', 'v1.1.2', 'upgrade_v1.1.3'], ['INSERT INTO webcal_timezones ( tzid ) VALUES ( "zzz" )', 'DELETE FROM webcal_timezones WHERE tzid = "zzz"', 'v1.1.3', 'upgrade_v1.2.8'], //don't change this array element ['','', $PROGRAM_VERSION, ''] ]; ?> PK 큓\� �O� � tables-db2.sqlnu �[��� CREATE TABLE webcal_user ( cal_login VARCHAR(25) NOT NULL, cal_passwd VARCHAR(32), cal_lastname VARCHAR(25), cal_firstname VARCHAR(25), cal_is_admin CHAR(1) DEFAULT 'N', cal_email VARCHAR(75), cal_enabled CHAR(1) DEFAULT 'Y', cal_telephone VARCHAR(50), cal_address VARCHAR(75), cal_title VARCHAR(75), cal_birthday INT, cal_last_login INT, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_entry ( cal_id INT NOT NULL, cal_group_id INT, cal_ext_for_id INT, cal_create_by VARCHAR(25) NOT NULL, cal_date INT NOT NULL, cal_time INT, cal_mod_date INT, cal_mod_time INT, cal_duration INT NOT NULL, cal_due_date INT, cal_due_time INT, cal_priority INT DEFAULT 5, cal_type CHAR(1) DEFAULT 'E', cal_access CHAR(1) DEFAULT 'P', cal_name VARCHAR(80) NOT NULL, cal_location VARCHAR(100), cal_url VARCHAR(100), cal_completed INT, cal_description VARCHAR(1024), PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT 0 NOT NULL, cal_type VARCHAR(20), cal_end INT, cal_endtime INT, cal_frequency INT DEFAULT 1, cal_days CHAR(7), cal_bymonth VARCHAR(50), cal_bymonthday VARCHAR(100), cal_byday VARCHAR(100), cal_bysetpos VARCHAR(50), cal_byweekno VARCHAR(50), cal_byyearday VARCHAR(50), cal_wkst CHAR(2) DEFAULT 'MO', cal_count INT, PRIMARY KEY (cal_id) ); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, cal_exdate INT DEFAULT 1 NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); CREATE TABLE webcal_entry_user ( cal_id int DEFAULT 0 NOT NULL, cal_login VARCHAR(25) DEFAULT '' NOT NULL, cal_status CHAR(1) DEFAULT 'A' NOT NULL, cal_category INT DEFAULT NULL, cal_percent INT DEFAULT 0 NOT NULL, PRIMARY KEY ( cal_id,cal_login ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75), PRIMARY KEY ( cal_id, cal_fullname ) ); CREATE TABLE webcal_user_pref ( cal_login VARCHAR(25) NOT NULL, cal_setting VARCHAR(25) NOT NULL, cal_value VARCHAR(100), PRIMARY KEY ( cal_login, cal_setting ) ); CREATE TABLE webcal_user_layers ( cal_layerid INT DEFAULT 0 NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_layeruser VARCHAR(25) NOT NULL, cal_color VARCHAR(25), cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ) ); CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT 0 NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT 0, cal_remind INT DEFAULT 0, cal_data VARCHAR(1024) ); CREATE TABLE webcal_reminders ( cal_id INT DEFAULT 0 NOT NULL, cal_date INT DEFAULT 0 NOT NULL, cal_offset INT DEFAULT 0 NOT NULL, cal_related CHAR(1) DEFAULT 'S' NOT NULL, cal_before CHAR(1) DEFAULT 'Y' NOT NULL, cal_last_sent INT DEFAULT 0 NOT NULL, cal_repeats INT DEFAULT 0 NOT NULL, cal_duration INT DEFAULT 0 NOT NULL, cal_times_sent INT DEFAULT 0 NOT NULL, cal_action VARCHAR(12) DEFAULT 'EMAIL' NOT NULL, PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_owner VARCHAR(25), cal_name VARCHAR(50) NOT NULL, cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_view_type CHAR(1), cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(100), PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_user_cal VARCHAR(25), cal_type CHAR(1) NOT NULL, cal_date INT NOT NULL, cal_time INT, cal_text VARCHAR(1024), PRIMARY KEY ( cal_log_id ) ); CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_owner VARCHAR(25), cat_name VARCHAR(80) NOT NULL, cat_color VARCHAR(8), PRIMARY KEY ( cat_id ) ); CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_lastname VARCHAR(25), cal_firstname VARCHAR(25), cal_admin VARCHAR(25) NOT NULL, cal_is_public CHAR(1) DEFAULT 'N' NOT NULL, cal_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_name VARCHAR(50), cal_date INT NOT NULL, cal_type VARCHAR(10) NOT NULL, cal_login VARCHAR(25), PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_import_id INT NOT NULL, cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200), PRIMARY KEY ( cal_id, cal_login ) ); CREATE TABLE webcal_report ( cal_login VARCHAR(25) NOT NULL, cal_report_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_time_range INT NOT NULL, cal_user VARCHAR(25), cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT, cal_include_empty CHAR(1) DEFAULT 'N', cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text VARCHAR(1024), PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT DEFAULT '0' NOT NULL, cal_can_edit INT DEFAULT '0' NOT NULL, cal_can_approve INT DEFAULT '0' NOT NULL, cal_can_invite CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_email CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_see_times_only CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text VARCHAR(1024), PRIMARY KEY ( cal_login, cal_type ) ); CREATE TABLE webcal_entry_categories ( cal_id INT DEFAULT 0 NOT NULL, cat_id INT DEFAULT 0 NOT NULL, cat_order INT DEFAULT 0 NOT NULL, cat_owner varchar(25) ); CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT, cal_login VARCHAR(25), cal_name VARCHAR(30), cal_description VARCHAR(128), cal_size INT, cal_mime_type VARCHAR(50), cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob BLOB, PRIMARY KEY ( cal_blob_id ) ); CREATE TABLE webcal_timezones ( tzid VARCHAR(100) DEFAULT '' NOT NULL, dtstart VARCHAR(25) DEFAULT NULL, dtend VARCHAR(25) DEFAULT NULL, vtimezone VARCHAR(500), PRIMARY KEY ( tzid ) ); PK 큓\���� � tables-postgres.sqlnu �[��� CREATE TABLE webcal_user ( cal_login VARCHAR(25) NOT NULL, cal_passwd VARCHAR(32), cal_lastname VARCHAR(25), cal_firstname VARCHAR(25), cal_is_admin CHAR(1) DEFAULT 'N', cal_email VARCHAR(75) DEFAULT NULL, cal_enabled CHAR(1) DEFAULT 'Y', cal_telephone VARCHAR(50) DEFAULT NULL, cal_address VARCHAR(75) DEFAULT NULL, cal_title VARCHAR(75) DEFAULT NULL, cal_birthday INT DEFAULT NULL, cal_last_login INT DEFAULT NULL, PRIMARY KEY ( cal_login ) ); INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' ); CREATE TABLE webcal_entry ( cal_id INT NOT NULL, cal_group_id INT, cal_ext_for_id INT NULL, cal_create_by VARCHAR(25) NOT NULL, cal_date INT NOT NULL, cal_time INT, cal_mod_date INT, cal_mod_time INT, cal_duration INT NOT NULL, cal_due_date INT DEFAULT NULL, cal_due_time INT DEFAULT NULL, cal_priority INT DEFAULT 5, cal_type CHAR(1) DEFAULT 'E', cal_access CHAR(1) DEFAULT 'P', cal_name VARCHAR(80) NOT NULL, cal_location VARCHAR(100) DEFAULT NULL, cal_url VARCHAR(100) DEFAULT NULL, cal_completed INT DEFAULT NULL, cal_description TEXT, PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT '0' NOT NULL, cal_type VARCHAR(20), cal_end INT, cal_endtime INT DEFAULT NULL, cal_frequency INT DEFAULT '1', cal_days CHAR(7), cal_bymonth VARCHAR(50) DEFAULT NULL, cal_bymonthday VARCHAR(100) DEFAULT NULL, cal_byday VARCHAR(100) DEFAULT NULL, cal_bysetpos VARCHAR(50) DEFAULT NULL, cal_byweekno VARCHAR(50) DEFAULT NULL, cal_byyearday VARCHAR(50) DEFAULT NULL, cal_wkst CHAR(2) DEFAULT 'MO', cal_count INT DEFAULT NULL, PRIMARY KEY (cal_id) ); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, cal_exdate INT DEFAULT '1' NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); CREATE TABLE webcal_entry_user ( cal_id INT DEFAULT '0' NOT NULL, cal_login VARCHAR(25) DEFAULT '' NOT NULL, cal_status CHAR(1) DEFAULT 'A' NOT NULL, cal_category INT DEFAULT NULL, cal_percent INT DEFAULT '0' NOT NULL, PRIMARY KEY ( cal_id,cal_login ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT '0' NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75) NOT NULL, PRIMARY KEY ( cal_id, cal_fullname ) ); CREATE TABLE webcal_user_pref ( cal_login VARCHAR(25) NOT NULL, cal_setting VARCHAR(25) NOT NULL, cal_value VARCHAR(100), PRIMARY KEY ( cal_login, cal_setting ) ); CREATE TABLE webcal_user_layers ( cal_layerid INT DEFAULT '0' NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_layeruser VARCHAR(25) NOT NULL, cal_color VARCHAR(25), cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ) ); CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT '0' NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT '0', cal_remind INT DEFAULT '0', cal_data TEXT ); CREATE TABLE webcal_reminders ( cal_id INT DEFAULT '0' NOT NULL, cal_date INT DEFAULT '0' NOT NULL, cal_offset INT DEFAULT '0' NOT NULL, cal_related CHAR(1) DEFAULT 'S' NOT NULL, cal_before CHAR(1) DEFAULT 'Y' NOT NULL, cal_last_sent INT DEFAULT '0' NOT NULL, cal_repeats INT DEFAULT '0' NOT NULL, cal_duration INT DEFAULT '0' NOT NULL, cal_times_sent INT DEFAULT '0' NOT NULL, cal_action VARCHAR(12) DEFAULT 'EMAIL' NOT NULL, PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_view_type CHAR(1), cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(100) NOT NULL, PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_user_cal VARCHAR(25) NULL, cal_type CHAR(1) NOT NULL, cal_date INT NOT NULL, cal_time INT NOT NULL, cal_text TEXT, PRIMARY KEY ( cal_log_id ) ); CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_owner VARCHAR(25), cat_name VARCHAR(80) NOT NULL, cat_color VARCHAR(8) DEFAULT NULL, PRIMARY KEY ( cat_id ) ); CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_lastname VARCHAR(25) NULL, cal_firstname VARCHAR(25) NULL, cal_admin VARCHAR(25) NOT NULL, cal_is_public CHAR(1) DEFAULT 'N' NOT NULL, cal_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_name VARCHAR(50) NULL, cal_date INT NOT NULL, cal_type VARCHAR(10) NOT NULL, cal_login VARCHAR(25) NULL, PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_import_id INT NOT NULL, cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ) ); CREATE TABLE webcal_report ( cal_login VARCHAR(25) NOT NULL, cal_report_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_time_range INT NOT NULL, cal_user VARCHAR(25) NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT DEFAULT '0' NOT NULL, cal_can_edit INT DEFAULT '0' NOT NULL, cal_can_approve INT DEFAULT '0' NOT NULL, cal_can_invite CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_email CHAR(1) DEFAULT 'Y' NOT NULL, cal_see_time_only CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY ( cal_login, cal_type ) ); CREATE TABLE webcal_entry_categories ( cal_id INT DEFAULT '0' NOT NULL, cat_id INT DEFAULT '0' NOT NULL, cat_order INT DEFAULT '0' NOT NULL, cat_owner VARCHAR(25) DEFAULT NULL ); CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT NULL, cal_login VARCHAR(25) NULL, cal_name VARCHAR(30) NULL, cal_description VARCHAR(128) NULL, cal_size INT NULL, cal_mime_type VARCHAR(50) NULL, cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob BYTEA, PRIMARY KEY ( cal_blob_id ) ); CREATE TABLE webcal_timezones ( tzid VARCHAR(100) DEFAULT '' NOT NULL, dtstart VARCHAR(25) DEFAULT NULL, dtend VARCHAR(25) DEFAULT NULL, vtimezone TEXT, PRIMARY KEY ( tzid ) ); PK 큓\+���R( R( upgrade-postgres.sqlnu �[��� /* $Id: upgrade-postgres.sql,v 1.30 2009/10/30 11:47:16 bbannon Exp $ */ /*upgrade_v0.9.14*/ UPDATE webcal_entry SET cal_time = -1 WHERE cal_time is null; CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT '0' NOT NULL, cal_days CHAR(7), cal_end INT, cal_frequency INT DEFAULT '1', cal_type VARCHAR(20), PRIMARY KEY (cal_id) ); /*upgrade_v0.9.22*/ CREATE TABLE webcal_user_layers ( cal_login varchar(25) NOT NULL, cal_layeruser varchar(25) NOT NULL, cal_color varchar(25) NULL, cal_dups CHAR(1) DEFAULT 'N', cal_layerid INT DEFAULT '0' NOT NULL, PRIMARY KEY ( cal_login, cal_layeruser ) ); /*upgrade_v0.9.27*/ CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT '0' NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT '0', cal_remind INT DEFAULT '0', cal_data TEXT, PRIMARY KEY ( cal_id, cal_name, cal_type ) ); /*upgrade_v0.9.35*/ CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_last_update INT NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_owner VARCHAR(25) NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_view_type CHAR(1), PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(50) NULL, PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_date INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_time INT NULL, cal_type CHAR(1) NOT NULL, cal_text TEXT, PRIMARY KEY ( cal_log_id ) ); /*upgrade_v0.9.37*/ ALTER TABLE webcal_entry_log ADD cal_user_cal VARCHAR(25); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); /*upgrade_v0.9.38*/ ALTER TABLE webcal_entry_user ADD cal_category INT DEFAULT NULL; CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_name VARCHAR(80) NOT NULL, cat_owner VARCHAR(25), PRIMARY KEY ( cat_id ) ); /*upgrade_v0.9.40*/ DELETE FROM webcal_config WHERE cal_setting LIKE 'DATE_FORMAT%'; DELETE FROM webcal_user_pref WHERE cal_setting LIKE 'DATE_FORMAT%'; CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75) NULL, PRIMARY KEY ( cal_id, cal_fullname ) ); ALTER TABLE webcal_entry ADD cal_ext_for_id INT NULL; /*upgrade_v0.9.41*/ CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_admin VARCHAR(25) NOT NULL, cal_firstname VARCHAR(25), cal_lastname VARCHAR(25), PRIMARY KEY ( cal_login ) ); /*upgrade_v0.9.42*/ CREATE TABLE webcal_report ( cal_report_id INT NOT NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_time_range INT NOT NULL, cal_update_date INT NOT NULL, cal_user VARCHAR(25) NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_import_data ( cal_id int NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_external_id VARCHAR(200) NULL, cal_import_type VARCHAR(15) NOT NULL, PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v0.9.43*/ ALTER TABLE webcal_user ALTER COLUMN cal_passwd TYPE VARCHAR(32); ALTER TABLE webcal_user ALTER COLUMN cal_passwd DROP NOT NULL; DROP TABLE webcal_import_data; CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_date INT NOT NULL, cal_login VARCHAR(25) NULL, cal_name VARCHAR(50) NULL, cal_type VARCHAR(10) NOT NULL, PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_external_id VARCHAR(200) NULL, cal_import_id INT NOT NULL, cal_import_type VARCHAR(15) NOT NULL, PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v1.0RC3*/ UPDATE webcal_config SET cal_value = 'week.php' WHERE cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'day.php' WHERE cal_value = 'day' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'month.php' WHERE cal_value = 'month' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'week.php' WHERE cal_value = 'week' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'year.php' WHERE cal_value = 'year' AND cal_setting = 'STARTVIEW'; ALTER TABLE webcal_view ADD cal_is_global CHAR(1); UPDATE webcal_view SET cal_is_global = 'N'; ALTER TABLE webcal_view ALTER cal_is_global SET DEFAULT 'N'; ALTER TABLE webcal_view ALTER cal_is_global SET NOT NULL; /*upgrade_v1.1.0-CVS*/ CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); ALTER TABLE webcal_nonuser_cals ADD cal_is_public CHAR(1); UPDATE webcal_nonuser_cals SET cal_is_public = 'N'; ALTER TABLE webcal_nonuser_cals ALTER cal_is_public SET DEFAULT 'N'; ALTER TABLE webcal_nonuser_cals ALTER cal_is_public SET NOT NULL; /*upgrade_v1.1.0a-CVS*/ CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY ( cal_login, cal_type ) ); ALTER TABLE webcal_entry ADD cal_completed INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_due_date INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_due_time INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_location VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_url VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_endtime INT DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byday VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonth VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonthday VARCHAR(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bysetpos VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byweekno VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byyearday VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_count INT DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_wkst CHAR(2); UPDATE webcal_entry_repeats SET cal_wkst = 'MO'; ALTER TABLE webcal_entry_repeats ALTER cal_wkst SET DEFAULT 'MO'; ALTER TABLE webcal_entry_repeats_not ADD cal_exdate int; UPDATE webcal_entry_repeats_not SET cal_exdate = '1'; ALTER TABLE webcal_entry_repeats_not ALTER cal_exdate SET DEFAULT '1'; ALTER TABLE webcal_entry_repeats_not ALTER cal_exdate SET NOT NULL; ALTER TABLE webcal_entry_user ADD cal_percent int; UPDATE webcal_entry_user SET cal_percent = '0'; ALTER TABLE webcal_entry_user ALTER cal_percent SET DEFAULT '0'; ALTER TABLE webcal_entry_user ALTER cal_percent SET NOT NULL; ALTER TABLE webcal_site_extras DROP CONSTRAINT webcal_site_extras_pkey; /*upgrade_v1.1.0b-CVS*/ CREATE TABLE webcal_entry_categories ( cal_id INT DEFAULT '0' NOT NULL, cat_id INT NOT NULL DEFAULT '0', cat_order INT DEFAULT '0' NOT NULL, cat_owner VARCHAR(25) DEFAULT NULL ); /*upgrade_v1.1.0c-CVS*/ CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_description VARCHAR(128) NULL, cal_id INT NULL, cal_login VARCHAR(25) NULL, cal_mime_type VARCHAR(50) NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_name VARCHAR(30) NULL, cal_size INT NULL, cal_type CHAR(1) NOT NULL, cal_blob BYTEA, PRIMARY KEY ( cal_blob_id ) ); /*upgrade_v1.1.0d-CVS*/ DROP TABLE webcal_access_user; CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_approve INT DEFAULT '0' NOT NULL, cal_can_edit INT DEFAULT '0' NOT NULL, cal_can_email CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_invite CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_view INT DEFAULT '0' NOT NULL, cal_see_time_only CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); /*upgrade_v1.1.0e-CVS*/ CREATE TABLE webcal_reminders ( cal_id INT DEFAULT '0' NOT NULL, cal_action VARCHAR(12) DEFAULT 'EMAIL' NOT NULL, cal_before CHAR(1) DEFAULT 'Y' NOT NULL, cal_date INT DEFAULT '0' NOT NULL, cal_duration INT DEFAULT '0' NOT NULL, cal_last_sent INT DEFAULT '0' NOT NULL, cal_offset INT DEFAULT '0' NOT NULL, cal_related CHAR(1) DEFAULT 'S' NOT NULL, cal_repeats INT DEFAULT '0' NOT NULL, cal_times_sent INT DEFAULT '0' NOT NULL, PRIMARY KEY ( cal_id ) ); /*upgrade_v1.1.1*/ ALTER TABLE webcal_nonuser_cals ADD cal_url VARCHAR(75) DEFAULT NULL; /*upgrade_v1.1.2*/ ALTER TABLE webcal_categories ADD cat_color VARCHAR(8) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_address VARCHAR(75) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_birthday INT NULL; ALTER TABLE webcal_user ADD cal_enabled CHAR(1); UPDATE TABLE webcal_user SET cal_enabled = 'Y'; ALTER TABLE webcal_user ALTER cal_enabled SET DEFAULT 'Y'; ALTER TABLE webcal_user ALTER cal_enabled SET NOT NULL; ALTER TABLE webcal_user ADD cal_last_login INT NULL; ALTER TABLE webcal_user ADD cal_telephone VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_title VARCHAR(75) DEFAULT NULL; /*upgrade_v1.1.3*/ CREATE TABLE webcal_timezones ( tzid VARCHAR(100) DEFAULT '' NOT NULL, dtstart VARCHAR(25) DEFAULT NULL, dtend VARCHAR(25) DEFAULT NULL, vtimezone TEXT, PRIMARY KEY ( tzid ) ); /*upgrade_v1.3.0*/ PK 큓\����$ �$ upgrade-oracle.sqlnu �[��� /* $Id: upgrade-oracle.sql,v 1.29 2009/10/30 11:47:16 bbannon Exp $ */ /*upgrade_v0.9.14*/ UPDATE webcal_entry SET cal_time = -1 WHERE cal_time is null; CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT 0 NOT NULL, cal_days CHAR(7), cal_end INT, cal_frequency INT DEFAULT 1, cal_type VARCHAR2(20), PRIMARY KEY ( cal_id ) ); /*upgrade_v0.9.22*/ CREATE TABLE webcal_user_layers ( cal_login VARCHAR2(25) NOT NULL, cal_layeruser VARCHAR2(25) NOT NULL, cal_color VARCHAR2(25) NULL, cal_dups CHAR(1) DEFAULT 'N', cal_layerid INT DEFAULT 0 NOT NULL, PRIMARY KEY ( cal_login, cal_layeruser ) ); /*upgrade_v0.9.27*/ CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT 0 NOT NULL, cal_name VARCHAR2(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT 0, cal_remind INT DEFAULT 0, cal_data LONG, PRIMARY KEY ( cal_id, cal_name, cal_type ) ); /*upgrade_v0.9.35*/ CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_last_update INT NOT NULL, cal_name VARCHAR2(50) NOT NULL, cal_owner VARCHAR2(25) NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_name VARCHAR2(50) NOT NULL, cal_owner VARCHAR2(25) NOT NULL, cal_view_type CHAR(1), PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR2(50) NOT NULL, cal_value VARCHAR2(50) NULL, PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_date INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_time INT NULL, cal_type CHAR(1) NOT NULL, cal_text VARCHAR2(4000), PRIMARY KEY ( cal_log_id ) ); /*upgrade_v0.9.37*/ ALTER TABLE webcal_entry_log ADD cal_user_cal VARCHAR2(25); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); /*upgrade_v0.9.38*/ ALTER TABLE webcal_entry_user ADD cal_category INT DEFAULT NULL; CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_name VARCHAR2(80) NOT NULL, cat_owner VARCHAR2(25), PRIMARY KEY ( cat_id ) ); /*upgrade_v0.9.40*/ DELETE FROM webcal_config WHERE cal_setting LIKE 'DATE_FORMAT%'; DELETE FROM webcal_user_pref WHERE cal_setting LIKE 'DATE_FORMAT%'; CREATE TABLE webcal_asst ( cal_boss VARCHAR2(25) NOT NULL, cal_assistant VARCHAR2(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR2(50) NOT NULL, cal_email VARCHAR2(75) NULL, PRIMARY KEY ( cal_id, cal_fullname ) ); ALTER TABLE webcal_entry ADD cal_ext_for_id INT NULL; /*upgrade_v0.9.41*/ CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR2(25) NOT NULL, cal_admin VARCHAR2(25) NOT NULL, cal_firstname VARCHAR2(25), cal_lastname VARCHAR2(25), PRIMARY KEY ( cal_login ) ); /*upgrade_v0.9.42*/ CREATE TABLE webcal_report ( cal_report_id INT NOT NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_report_name VARCHAR2(50) NOT NULL, cal_report_type VARCHAR2(20) NOT NULL, cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_time_range INT NOT NULL, cal_update_date INT NOT NULL, cal_user VARCHAR2(25) NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text VARCHAR2(4000), PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_import_data ( cal_id int NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_external_id VARCHAR2(200) NULL, cal_import_type VARCHAR2(15) NOT NULL, PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v0.9.43*/ ALTER TABLE webcal_user MODIFY cal_passwd VARCHAR2(32) NULL; DROP TABLE webcal_import_data; CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_date INT NOT NULL, cal_login VARCHAR2(25) NULL, cal_name VARCHAR2(50) NULL, cal_type VARCHAR2(10) NOT NULL, PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_external_id VARCHAR2(200) NULL, cal_import_id INT NOT NULL, cal_import_type VARCHAR2(15) NOT NULL, PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v1.0RC3*/ ALTER TABLE webcal_view ADD cal_is_global CHAR(1) DEFAULT 'N' NOT NULL; UPDATE webcal_config SET cal_value = 'week.php' WHERE cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'day.php' WHERE cal_value = 'day' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'month.php' WHERE cal_value = 'month' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'week.php' WHERE cal_value = 'week' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'year.php' WHERE cal_value = 'year' AND cal_setting = 'STARTVIEW'; /*upgrade_v1.1.0-CVS*/ CREATE TABLE webcal_access_function ( cal_login VARCHAR2(25) NOT NULL, cal_permissions VARCHAR2(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR2(50) NOT NULL, cal_other_user VARCHAR2(50) NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); ALTER TABLE webcal_nonuser_cals ADD cal_is_public CHAR(1) DEFAULT 'N' NOT NULL; /*upgrade_v1.1.0a-CVS*/ CREATE TABLE webcal_user_template ( cal_login VARCHAR2(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text VARCHAR2(1024), PRIMARY KEY ( cal_login, cal_type ) ); ALTER TABLE webcal_entry ADD cal_completed INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_due_date INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_due_time INT DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_location VARCHAR2(100) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_url VARCHAR2(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_endtime INT DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byday VARCHAR2(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonth VARCHAR2(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonthday VARCHAR2(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bysetpos VARCHAR2(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byweekno VARCHAR2(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byyearday VARCHAR2(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_count INT DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_wkst CHAR(2) DEFAULT 'MO'; ALTER TABLE webcal_entry_repeats_not ADD cal_exdate INT DEFAULT 1 NOT NULL; ALTER TABLE webcal_entry_user ADD cal_percent INT DEFAULT 0 NOT NULL; ALTER TABLE webcal_site_extras DROP PRIMARY KEY; /*upgrade_v1.1.0b-CVS*/ CREATE TABLE webcal_entry_categories ( cal_id INT DEFAULT 0 NOT NULL, cat_id INT DEFAULT 0 NOT NULL, cat_order INT DEFAULT 0 NOT NULL, cat_owner VARCHAR2(25) DEFAULT NULL ); /*upgrade_v1.1.0c-CVS*/ CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_description VARCHAR2(128) NULL, cal_id INT NULL, cal_login VARCHAR2(25) NULL, cal_mime_type VARCHAR2(50) NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_name VARCHAR2(30) NULL, cal_size INT NULL, cal_type CHAR(1) NOT NULL, cal_blob BLOB, PRIMARY KEY ( cal_blob_id ) ); /*upgrade_v1.1.0d-CVS*/ DROP TABLE webcal_access_user; CREATE TABLE webcal_access_user ( cal_login VARCHAR2(50) NOT NULL, cal_other_user VARCHAR2(50) NOT NULL, cal_can_approve INT DEFAULT 0 NOT NULL, cal_can_edit INT DEFAULT 0 NOT NULL, cal_can_email CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_invite CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_view INT DEFAULT 0 NOT NULL, cal_see_time_only CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); /*upgrade_v1.1.0e-CVS*/ CREATE TABLE webcal_reminders ( cal_id INT DEFAULT 0 NOT NULL, cal_action VARCHAR2(12) DEFAULT 'EMAIL' NOT NULL, cal_before CHAR(1) DEFAULT 'Y' NOT NULL, cal_date INT DEFAULT 0 NOT NULL, cal_duration INT DEFAULT 0 NOT NULL, cal_last_sent INT DEFAULT 0 NOT NULL, cal_offset INT DEFAULT 0 NOT NULL, cal_related CHAR(1) DEFAULT 'S' NOT NULL, cal_repeats INT DEFAULT 0 NOT NULL, cal_times_sent INT DEFAULT 0 NOT NULL, PRIMARY KEY ( cal_id ) ); /*upgrade_v1.1.1*/ ALTER TABLE webcal_nonuser_cals ADD cal_url VARCHAR2(75) DEFAULT NULL; /*upgrade_v1.1.2*/ ALTER TABLE webcal_categories ADD cat_color VARCHAR2(8) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_address VARCHAR2(75) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_birthday INT NULL; ALTER TABLE webcal_user ADD cal_enabled CHAR(1) DEFAULT 'Y'; ALTER TABLE webcal_user ADD cal_last_login INT NULL; ALTER TABLE webcal_user ADD cal_telephone VARCHAR2(50) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_title VARCHAR2(75) DEFAULT NULL; /*upgrade_v1.1.3*/ CREATE TABLE webcal_timezones ( tzid VARCHAR2(100) DEFAULT '' NOT NULL, dtstart VARCHAR2(25) DEFAULT NULL, dtend VARCHAR2(25) DEFAULT NULL, vtimezone VARCHAR2(256), PRIMARY KEY ( tzid ) ); /*upgrade_v1.3.0*/ PK 큓\!f���" �" upgrade-mysql.sqlnu �[��� /* $Id: upgrade-mysql.sql,v 1.28 2009/10/30 11:47:16 bbannon Exp $ */ /*upgrade_v0.9.14*/ UPDATE webcal_entry SET cal_time = -1 WHERE cal_time IS NULL; ALTER TABLE webcal_entry MODIFY cal_time INT NOT NULL DEFAULT -1; CREATE TABLE webcal_entry_repeats ( cal_id INT NOT NULL, cal_days CHAR(7), cal_end INT, cal_frequency INT DEFAULT 1, cal_type VARCHAR(20), PRIMARY KEY (cal_id) ); /*upgrade_v0.9.22*/ CREATE TABLE webcal_user_layers ( cal_login VARCHAR(25) NOT NULL, cal_layeruser VARCHAR(25) NOT NULL, cal_color VARCHAR(25), cal_dups CHAR(1) NOT NULL DEFAULT 'N', cal_layerid INT NOT NULL, PRIMARY KEY (cal_login,cal_layeruser) ); /*upgrade_v0.9.27*/ CREATE TABLE webcal_site_extras ( cal_id INT NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT, cal_remind INT, cal_data TEXT, PRIMARY KEY (cal_id,cal_name,cal_type) ); /*upgrade_v0.9.35*/ CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(50), PRIMARY KEY (cal_setting) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_date INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_time INT, cal_type CHAR(1) NOT NULL, cal_text TEXT, PRIMARY KEY (cal_log_id) ); CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_last_update INT NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_owner VARCHAR(25), PRIMARY KEY (cal_group_id) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY (cal_group_id,cal_login) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_view_type CHAR(1), PRIMARY KEY (cal_view_id) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY (cal_view_id,cal_login) ); /*upgrade_v0.9.37*/ ALTER TABLE webcal_entry_log ADD cal_user_cal VARCHAR(25); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, PRIMARY KEY (cal_id,cal_date) ); /*upgrade_v0.9.38*/ ALTER TABLE webcal_entry_user ADD cal_category INT; CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_name VARCHAR(80) NOT NULL, cat_owner VARCHAR(25), PRIMARY KEY (cat_id) ); /*upgrade_v0.9.40*/ DELETE FROM webcal_config WHERE cal_setting LIKE 'DATE_FORMAT%'; DELETE FROM webcal_user_pref WHERE cal_setting LIKE 'DATE_FORMAT%'; ALTER TABLE webcal_entry ADD cal_ext_for_id INT; CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY (cal_boss,cal_assistant) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75), PRIMARY KEY (cal_id,cal_fullname) ); /*upgrade_v0.9.41*/ CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_admin VARCHAR(25) NOT NULL, cal_firstname VARCHAR(25), cal_lastname VARCHAR(25), PRIMARY KEY (cal_login) ); /*upgrade_v0.9.42*/ CREATE TABLE webcal_report ( cal_report_id INT NOT NULL, cal_allow_nav CHAR(1) NOT NULL DEFAULT 'Y', cal_cat_id INT, cal_include_empty CHAR(1) NOT NULL DEFAULT 'N', cal_include_header CHAR(1) NOT NULL DEFAULT 'Y', cal_is_global CHAR(1) NOT NULL DEFAULT 'N', cal_login VARCHAR(25) NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_show_in_trailer CHAR(1) NOT NULL DEFAULT 'N', cal_time_range INT NOT NULL, cal_update_date INT NOT NULL, cal_user VARCHAR(25), PRIMARY KEY (cal_report_id) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY (cal_report_id,cal_template_type) ); /*upgrade_v0.9.43*/ ALTER TABLE webcal_user MODIFY cal_passwd VARCHAR(32); DROP TABLE IF EXISTS webcal_import_data; CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_date INT NOT NULL, cal_login VARCHAR(25), cal_name VARCHAR(50), cal_type VARCHAR(10) NOT NULL, PRIMARY KEY (cal_import_id) ); CREATE TABLE webcal_import_data ( cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_external_id VARCHAR(200), cal_import_id INT NOT NULL, cal_import_type VARCHAR(15) NOT NULL, PRIMARY KEY (cal_id,cal_login) ); /*upgrade_v1.0RC3*/ ALTER TABLE webcal_view ADD cal_is_global CHAR(1) NOT NULL DEFAULT 'N'; UPDATE webcal_config SET cal_value = 'week.php' WHERE cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'day.php' WHERE cal_value = 'day' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'month.php' WHERE cal_value = 'month' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'week.php' WHERE cal_value = 'week' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'year.php' WHERE cal_value = 'year' AND cal_setting = 'STARTVIEW'; UPDATE webcal_view SET cal_is_global = 'N'; /*upgrade_v1.1.0-CVS*/ CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY (cal_login) ); ALTER TABLE webcal_nonuser_cals ADD cal_is_public CHAR(1) NOT NULL DEFAULT 'N'; /*upgrade_v1.1.0a-CVS*/ CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY (cal_login,cal_type) ); ALTER TABLE webcal_entry_repeats ADD cal_endtime int(11) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonth varchar(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonthday varchar(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byday varchar(100) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bysetpos varchar(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byweekno varchar(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_byyearday varchar(50) DEFAULT NULL; ALTER TABLE webcal_entry_repeats ADD cal_wkst char(2) DEFAULT 'MO'; ALTER TABLE webcal_entry_repeats ADD cal_count int(11) DEFAULT NULL; ALTER TABLE webcal_entry_repeats_not ADD cal_exdate int(1) NOT NULL DEFAULT '1'; ALTER TABLE webcal_entry ADD cal_due_date int(11) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_due_time int(11) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_location varchar(100) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_url varchar(100) DEFAULT NULL; ALTER TABLE webcal_entry ADD cal_completed int(11) DEFAULT NULL; ALTER TABLE webcal_entry_user ADD cal_percent int(11) NOT NULL DEFAULT '0'; ALTER TABLE webcal_site_extras DROP PRIMARY KEY; /*upgrade_v1.1.0b-CVS*/ 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) DEFAULT NULL ); /*upgrade_v1.1.0c-CVS*/ CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT NULL, cal_login VARCHAR(25) NULL, cal_name VARCHAR(30) NULL, cal_description VARCHAR(128) NULL, cal_size INT NULL, cal_mime_type VARCHAR(50) NULL, cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob LONGBLOB, PRIMARY KEY ( cal_blob_id ) ); /*upgrade_v1.1.0d-CVS*/ DROP TABLE IF EXISTS webcal_access_user; CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT NOT NULL DEFAULT '0', cal_can_edit INT NOT NULL DEFAULT '0', cal_can_approve INT NOT NULL DEFAULT '0', cal_can_invite CHAR(1) DEFAULT 'Y', cal_can_email CHAR(1) DEFAULT 'Y', cal_see_time_only CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_other_user ) ); /*upgrade_v1.1.0e-CVS*/ CREATE TABLE webcal_reminders ( cal_id INT NOT NULL DEFAULT '0', cal_date INT NOT NULL DEFAULT '0', cal_offset INT NOT NULL DEFAULT '0', cal_related CHAR(1) NOT NULL DEFAULT 'S', cal_before CHAR(1) NOT NULL DEFAULT 'Y', cal_last_sent INT NOT NULL DEFAULT '0', cal_repeats INT NOT NULL DEFAULT '0', cal_duration INT NOT NULL DEFAULT '0', cal_times_sent INT NOT NULL DEFAULT '0', cal_action VARCHAR(12) NOT NULL DEFAULT 'EMAIL', PRIMARY KEY ( cal_id ) ); /*upgrade_v1.1.1*/ ALTER TABLE webcal_nonuser_cals ADD cal_url VARCHAR(255) DEFAULT NULL; /*upgrade_v1.1.2*/ ALTER TABLE webcal_categories ADD cat_color VARCHAR(8) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_enabled CHAR(1) DEFAULT 'Y'; ALTER TABLE webcal_user ADD cal_telephone VARCHAR(50) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_address VARCHAR(75) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_title VARCHAR(75) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_birthday INT NULL; ALTER TABLE webcal_user ADD cal_last_login INT NULL; /*upgrade_v1.1.3*/ CREATE TABLE webcal_timezones ( tzid varchar(100) NOT NULL default '', dtstart varchar(25) default NULL, dtend varchar(25) default NULL, vtimezone text, PRIMARY KEY ( tzid ) ); /*upgrade_v1.3.0*/ PK 큓\�+3� � tables-sqlite3.phpnu �[��� <?php /** * Description: * This file will create a SQLite3 database. */ function populate_sqlite_db ( $database, $db ) { $c = new SQLite3 (); $c->open ( $database, SQLITE3_OPEN_CREATE ); $c->query($db, "CREATE TABLE webcal_user (cal_login VARCHAR(25) NOT NULL, cal_passwd VARCHAR(32), cal_lastname VARCHAR(25), cal_firstname VARCHAR(25), cal_is_admin CHAR(1) DEFAULT 'N',cal_email VARCHAR(75) NULL,cal_enabled CHAR(1) DEFAULT 'Y',cal_telephone VARCHAR(50) NULL,cal_address VARCHAR(75) NULL,cal_title VARCHAR(75) NULL,cal_birthday INT,cal_last_login INT, PRIMARY KEY ( cal_login ))"); $c->query($db, "INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' );"); $c->query($db, "CREATE TABLE webcal_entry ( cal_id INT NOT NULL, cal_group_id INT NULL, cal_ext_for_id INT NULL, cal_create_by VARCHAR(25) NOT NULL, cal_date INT NOT NULL, cal_time INT NULL, cal_mod_date INT, cal_mod_time INT, cal_duration INT NOT NULL, cal_due_date INT default NULL, cal_due_time INT default NULL, cal_location varchar(100) default NULL, cal_url varchar(100) default NULL, cal_completed INT default NULL, cal_priority INT DEFAULT 5, cal_type CHAR(1) DEFAULT 'E', cal_access CHAR(1) DEFAULT 'P', cal_name VARCHAR(80) NOT NULL, cal_description TEXT, PRIMARY KEY ( cal_id ))"); $c->query($db, "CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT 0 NOT NULL, cal_type VARCHAR(20), cal_end INT, cal_frequency INT DEFAULT 1, cal_days CHAR(7), cal_endtime int(11) default NULL, cal_bymonth varchar(50) default NULL, cal_bymonthday varchar(100) default NULL, cal_byday varchar(100) default NULL, cal_bysetpos varchar(50) default NULL, cal_byweekno varchar(50) default NULL, cal_byyearday varchar(50) default NULL, cal_wkst char(2) default 'MO', cal_count int(11) default NULL, PRIMARY KEY (cal_id))"); $c->query($db, "CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, cal_exdate INT NOT NULL default '1', PRIMARY KEY ( cal_id, cal_date ))"); $c->query($db, "CREATE TABLE webcal_entry_user ( cal_id INT DEFAULT 0 NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_status CHAR(1) DEFAULT 'A', cal_category INT DEFAULT NULL, cal_percent INT NOT NULL default '0', PRIMARY KEY ( cal_id, cal_login ))"); $c->query($db, "CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75) NULL, PRIMARY KEY ( cal_id, cal_fullname ))"); $c->query($db, "CREATE TABLE webcal_user_pref ( cal_login VARCHAR(25) NOT NULL, cal_setting VARCHAR(25) NOT NULL, cal_value VARCHAR(100) NULL, PRIMARY KEY ( cal_login, cal_setting ))"); $c->query($db, "CREATE TABLE webcal_user_layers ( cal_layerid INT DEFAULT 0 NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_layeruser VARCHAR(25) NOT NULL, cal_color VARCHAR(25) NULL, cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ))"); $c->query($db, "CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT 0 NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT 0, cal_remind INT DEFAULT 0, cal_data TEXT)"); $c->query($db, "CREATE TABLE webcal_reminders (cal_id INT DEFAULT 0 NOT NULL,cal_date INT DEFAULT 0 NOT NULL,cal_offset INT DEFAULT 0 NOT NULL,cal_related CHAR(1) DEFAULT 'S' NOT NULL,cal_before CHAR(1) DEFAULT 'Y' NOT NULL,cal_last_sent INT DEFAULT NULL,cal_repeats INT DEFAULT 0 NOT NULL,cal_duration INT DEFAULT 0 NOT NULL,cal_times_sent INT DEFAULT 0 NOT NULL,cal_action VARCHAR(12) DEFAULT 'EMAIL' NOT NULL,PRIMARY KEY ( cal_id ))"); $c->query($db, "CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_owner VARCHAR(25) NULL, cal_name VARCHAR(50) NOT NULL, cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ))"); $c->query($db, "CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ))"); $c->query($db, "CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_view_type CHAR(1), cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_view_id ))"); $c->query($db, "CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ))"); $c->query($db, "CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(100) NULL, PRIMARY KEY ( cal_setting ))"); $c->query($db, "CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_user_cal VARCHAR(25) NULL, cal_type CHAR(1) NOT NULL, cal_date INT NOT NULL, cal_time INT NULL, cal_text TEXT, PRIMARY KEY ( cal_log_id ))"); $c->query($db, "CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_owner VARCHAR(25) NULL, cat_name VARCHAR(80) NOT NULL,cat_color VARCHAR(8) NULL, PRIMARY KEY ( cat_id ))"); $c->query($db, "CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ))"); $c->query($db, "CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_lastname VARCHAR(25) NULL, cal_firstname VARCHAR(25) NULL, cal_admin VARCHAR(25) NOT NULL, cal_is_public CHAR(1) DEFAULT 'N' NOT NULL, cal_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY ( cal_login ))"); $c->query($db, "CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_name VARCHAR(50) NULL, cal_date INT NOT NULL, cal_type VARCHAR(10) NOT NULL, cal_login VARCHAR(25) NULL, PRIMARY KEY ( cal_import_id ))"); $c->query($db, "CREATE TABLE webcal_import_data ( cal_import_id INT NOT NULL, cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ))"); $c->query($db, "CREATE TABLE webcal_report ( cal_login VARCHAR(25) NOT NULL, cal_report_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_time_range INT NOT NULL, cal_user VARCHAR(25) NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ))"); $c->query($db, "CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY ( cal_report_id, cal_template_type ))"); $c->query($db, "CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT NOT NULL DEFAULT '0', cal_can_edit INT NOT NULL DEFAULT '0', cal_can_approve INT NOT NULL DEFAULT '0', cal_can_invite CHAR(1) NOT NULL DEFAULT 'Y', cal_can_email CHAR(1) NOT NULL DEFAULT 'Y', cal_see_time_only CHAR(1) NOT NULL DEFAULT 'N', PRIMARY KEY ( cal_login, cal_other_user ))"); $c->query($db, "CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ))"); $c->query($db, "CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL default '', cal_type CHAR(1) NOT NULL default '', cal_template_text text, PRIMARY KEY (cal_login,cal_type))"); $c->query($db, "CREATE TABLE webcal_entry_categories (cal_id INT NOT NULL default '0', cat_id INT NOT NULL default '0', cat_order INT NOT NULL default '0', cat_owner VARCHAR(25) default NULL)"); $c->query($db, "CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT NULL, cal_login VARCHAR(25) NULL, cal_name VARCHAR(30) NULL, cal_description VARCHAR(128) NULL, cal_size INT NULL, cal_mime_type VARCHAR(50) NULL, cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob BLOB, PRIMARY KEY ( cal_blob_id ))"); $c->query($db, "CREATE TABLE webcal_timezones (tzid varchar(100) NOT NULL default '', dtstart varchar(25) default NULL, dtend varchar(25) default NULL, vtimezone text, PRIMARY KEY ( tzid ))"); $c->close (); } ?> PK 큓\� [�, �, tables-ibase.sqlnu �[��� CREATE TABLE WEBCAL_ENTRY ( CAL_ID INTEGER NOT NULL, CAL_GROUP_ID INTEGER, CAL_CREATE_BY VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_DATE INTEGER NOT NULL, CAL_EXT_FOR_ID INTEGER, CAL_TIME INTEGER, CAL_MOD_DATE INTEGER, CAL_MOD_TIME INTEGER, CAL_DURATION INTEGER NOT NULL, CAL_DUE_DATE INTEGER, CAL_DUE_TIME INTEGER, CAL_PRIORITY INTEGER DEFAULT 2, CAL_TYPE CHAR(1) CHARACTER SET WIN1252 DEFAULT 'E', CAL_ACCESS CHAR(1) CHARACTER SET WIN1252 DEFAULT 'P', CAL_NAME VARCHAR(80) CHARACTER SET WIN1252 NOT NULL, CAL_LOCATION VARCHAR(100)CHARACTER SET WIN1252, CAL_URL VARCHAR(100)CHARACTER SET WIN1252, CAL_COMPLETED INTEGER DEFAULT NULL, CAL_DESCRIPTION VARCHAR(1024) CHARACTER SET WIN1252 ); CREATE TABLE WEBCAL_USER ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_PASSWD VARCHAR(32) CHARACTER SET WIN1252, CAL_LASTNAME VARCHAR(25) CHARACTER SET WIN1252, CAL_FIRSTNAME VARCHAR(25) CHARACTER SET WIN1252, CAL_IS_ADMIN CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N', CAL_EMAIL VARCHAR(75) CHARACTER SET WIN1252, CAL_ENABLED CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y', CAL_TELEPHONE VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL, CAL_ADDRESS VARCHAR(75) CHARACTER SET WIN1252 DEFAULT NULL, CAL_TITLE VARCHAR(75) CHARACTER SET WIN1252 DEFAULT NULL, CAL_BIRTHDAY INTEGER DEFAULT NULL CAL_LAST_LOGIN INTEGER DEFAULT NULL ); CREATE TABLE WEBCAL_ENTRY_REPEATS ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_TYPE VARCHAR(20) CHARACTER SET WIN1252, CAL_END INTEGER, CAL_ENDTIME INTEGER DEFAULT NULL, CAL_FREQUENCY INTEGER DEFAULT 1 NOT NULL, CAL_DAYS CHAR(7) CHARACTER SET WIN1252, CAL_BYMONTH VARCHAR(50) CHARACTER SET WIN1252, CAL_BYMONTHDAY VARCHAR(100) CHARACTER SET WIN1252, CAL_BYDAY VARCHAR(100) CHARACTER SET WIN1252, CAL_BYSETPOS VARCHAR(50) CHARACTER SET WIN1252, CAL_BYWEEKNO VARCHAR(50) CHARACTER SET WIN1252, CAL_BYYEARDAY VARCHAR(50) CHARACTER SET WIN1252, CAL_WKST CHAR(2) CHARACTER SET WIN1252 DEFAULT 'MO', CAL_COUNT INTEGER ); CREATE TABLE WEBCAL_ENTRY_REPEATS_NOT ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_DATE INTEGER NOT NULL, CAL_EXDATE INTEGER DEFAULT 1 NOT NULL ); CREATE TABLE WEBCAL_ENTRY_USER ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_STATUS VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'A', CAL_CATEGORY INTEGER, CAL_PERCENT INTEGER DEFAULT 0 NOT NULL ); CREATE TABLE WEBCAL_ENTRY_EXT_USER ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_FULLNAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_EMAIL VARCHAR(75) CHARACTER SET WIN1252 ); CREATE TABLE WEBCAL_REMINDERS ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_DATE INTEGER DEFAULT 0 NOT NULL, CAL_OFFSET INTEGER DEFAULT 0 NOT NULL, CAL_RELATED CHAR(1) CHARACTER SET WIN1252 DEFAULT 'S' NOT NULL, CAL_BEFORE CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_LAST_SENT INTEGER DEFAULT 0 NOT NULL, CAL_REPEATS INTEGER DEFAULT 0 NOT NULL, CAL_DURATION INTEGER DEFAULT 0 NOT NULL, CAL_TIMES_SENT INTEGER DEFAULT 0 NOT NULL, CAL_ACTION VARCHAR(12) CHARACTER SET WIN1252 DEFAULT 'EMAIL' NOT NULL ); CREATE TABLE WEBCAL_SITE_EXTRAS ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_NAME VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_TYPE INTEGER NOT NULL, CAL_DATE INTEGER DEFAULT 0, CAL_REMIND INTEGER DEFAULT 0, CAL_DATA VARCHAR(500) CHARACTER SET WIN1252 ); CREATE TABLE WEBCAL_USER_LAYERS ( CAL_LAYERID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_LAYERUSER VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_COLOR VARCHAR(25) CHARACTER SET WIN1252, CAL_DUPS CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' ); CREATE TABLE WEBCAL_USER_PREF ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_SETTING VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_VALUE VARCHAR(100) CHARACTER SET WIN1252 ); CREATE TABLE WEBCAL_GROUP ( CAL_GROUP_ID INTEGER DEFAULT 0 NOT NULL, CAL_OWNER VARCHAR(25) CHARACTER SET WIN1252, CAL_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_LAST_UPDATE INTEGER DEFAULT 0 NOT NULL ); CREATE TABLE WEBCAL_GROUP_USER ( CAL_GROUP_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE TABLE WEBCAL_VIEW ( CAL_VIEW_ID INTEGER DEFAULT 0 NOT NULL, CAL_OWNER VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_VIEW_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_IS_GLOBAL CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL ); CREATE TABLE WEBCAL_VIEW_USER ( CAL_VIEW_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE TABLE WEBCAL_CONFIG ( CAL_SETTING VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_VALUE VARCHAR(100) CHARACTER SET WIN1252 ); CREATE TABLE WEBCAL_ENTRY_LOG ( CAL_LOG_ID INTEGER DEFAULT 0 NOT NULL, CAL_ENTRY_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_USER_CAL VARCHAR(25) CHARACTER SET WIN1252, CAL_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_DATE INTEGER, CAL_TIME INTEGER, CAL_TEXT VARCHAR(500) CHARACTER SET WIN1252 ); CREATE TABLE WEBCAL_CATEGORIES ( CAT_ID INTEGER DEFAULT 0 NOT NULL, CAT_OWNER VARCHAR(25) CHARACTER SET WIN1252, CAT_NAME VARCHAR(80) CHARACTER SET WIN1252 NOT NULL, CAT_COLOR VARCHAR(8) CHARACTER SET WIN1252 DEFAULT NULL ); CREATE TABLE WEBCAL_ASST ( CAL_BOSS VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_ASSISTANT VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE TABLE WEBCAL_NONUSER_CALS ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_LASTNAME VARCHAR(25) CHARACTER SET WIN1252, CAL_FIRSTNAME VARCHAR(25) CHARACTER SET WIN1252, CAL_ADMIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_URL VARCHAR(255) CHARACTER SET WIN1252 DEFAULT NULL, CAL_IS_PUBLIC VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL ); CREATE TABLE WEBCAL_IMPORT ( CAL_IMPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_NAME VARCHAR(50) CHARACTER SET WIN1252, CAL_DATE INTEGER DEFAULT 0 NOT NULL, CAL_TYPE VARCHAR(10) CHARACTER SET WIN1252 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL ); CREATE TABLE WEBCAL_IMPORT_DATA ( CAL_IMPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_ID INTEGER DEFAULT 0 NOT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_IMPORT_TYPE VARCHAR(15) CHARACTER SET WIN1252 NOT NULL, CAL_EXTERNAL_ID VARCHAR(200) CHARACTER SET WIN1252 ); CREATE TABLE WEBCAL_REPORT ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_REPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_IS_GLOBAL VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL, CAL_REPORT_TYPE VARCHAR(20) CHARACTER SET WIN1252 NOT NULL, CAL_INCLUDE_HEADER VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_REPORT_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL, CAL_TIME_RANGE INTEGER DEFAULT 0 NOT NULL, CAL_USER VARCHAR(25) CHARACTER SET WIN1252, CAL_ALLOW_NAV VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_CAT_ID INTEGER, CAL_INCLUDE_EMPTY VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL, CAL_SHOW_IN_TRAILER VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL, CAL_UPDATE_DATE INTEGER DEFAULT 0 NOT NULL ); CREATE TABLE WEBCAL_REPORT_TEMPLATE ( CAL_REPORT_ID INTEGER DEFAULT 0 NOT NULL, CAL_TEMPLATE_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_TEMPLATE_TEXT VARCHAR(1024) CHARACTER SET WIN1252 NOT NULL ); CREATE TABLE WEBCAL_ACCESS_USER ( cal_login VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, cal_other_user VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_CAN_VIEW INTEGER DEFAULT '0' NOT NULL, CAL_CAN_EDIT INTEGER DEFAULT '0' NOT NULL, CAL_CAN_APPROVE INTEGER DEFAULT '0' NOT NULL, CAL_CAN_INVITE CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_CAN_EMAIL CHAR(1) CHARACTER SET WIN1252 DEFAULT 'Y' NOT NULL, CAL_SEE_TIMES_ONLY CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N' NOT NULL ); CREATE TABLE WEBCAL_ACCESS_FUNCTION ( cal_login VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_PERMISSIONS VARCHAR(64) CHARACTER SET WIN1252 NOT NULL ); CREATE TABLE WEBCAL_USER_TEMPLATE ( CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL, CAL_TYPE VARCHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_TEMPLATE_TEXT VARCHAR(1024) CHARACTER SET WIN1252 NOT NULL ); CREATE TABLE WEBCAL_ENTRY_CATEGORIES ( CAL_ID INTEGER DEFAULT 0 NOT NULL, CAT_ID INTEGER DEFAULT 0 NOT NULL, CAT_ORDER INTEGER DEFAULT 0 NOT NULL, CAT_OWNER VARCHAR(25)CHARACTER SET WIN1252 DEFAULT NULL ); CREATE TABLE WEBCAL_BLOB ( CAL_BLOB_ID INTEGER NOT NULL, CAL_ID INTEGER DEFAULT NULL, CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 DEFAULT NULL, CAL_NAME VARCHAR(30) CHARACTER SET WIN1252 DEFAULT NULL, CAL_DESCRIPTION VARCHAR(128) CHARACTER SET WIN1252 DEFAULT NULL, CAL_SIZE INTEGER DEFAULT NULL, CAL_MIME_TYPE VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL, CAL_TYPE CHAR(1) CHARACTER SET WIN1252 NOT NULL, CAL_MOD_DATE INTEGER NOT NULL, CAL_MOD_TIME INTEGER NOT NULL, CAL_BLOB BLOB ); CREATE TABLE webcal_TIMEZONES ( TZID VARCHAR(100) CHARACTER SET WIN1252 DEFAULT '' NOT NULL, DTSTART VARCHAR(25) CHARACTER SET WIN1252 DEFAULT NULL, DTEND VARCHAR(25) CHARACTER SET WIN1252 DEFAULT NULL, VTIMEZONE VARCHAR(500) CHARACTER SET WIN1252 ); CREATE INDEX IWEBCAL_ENTRYNEWINDEX ON WEBCAL_ENTRY(CAL_ID); CREATE INDEX IWEBCAL_ENTRY_REPEATSNEWINDEX ON WEBCAL_ENTRY_REPEATS(CAL_ID); CREATE INDEX IWEBCAL_ENTRY_REP_NOTNEWINDEX ON WEBCAL_ENTRY_REPEATS_NOT(CAL_ID, CAL_DATE); CREATE INDEX IWEBCAL_ENTRY_USERNEWINDEX ON WEBCAL_ENTRY_USER(CAL_ID, CAL_LOGIN); CREATE INDEX IWEBCAL_ENTRY_EXTUSERNEWINDEX ON WEBCAL_ENTRY_EXT_USER(CAL_ID, CAL_FULLNAME); CREATE INDEX IWEBCAL_REMINDERSNEWINDEX ON WEBCAL_REMINDERS(CAL_ID); CREATE INDEX IWEBCAL_USERNEWINDEX ON WEBCAL_USER(CAL_LOGIN); CREATE INDEX IWEBCAL_USER_LAYERSNEWINDEX ON WEBCAL_USER_LAYERS(CAL_LOGIN, CAL_LAYERUSER); CREATE INDEX IWEBCAL_USER_PREFNEWINDEX ON WEBCAL_USER_PREF(CAL_LOGIN, CAL_SETTING); CREATE INDEX IWEBCAL_GROUPNEWINDEX ON WEBCAL_GROUP(CAL_GROUP_ID); CREATE INDEX IWEBCAL_GROUPUSERNEWINDEX ON WEBCAL_GROUP_USER(CAL_GROUP_ID, CAL_LOGIN); CREATE INDEX IWEBCAL_VIEWNEWINDEX ON WEBCAL_VIEW(CAL_VIEW_ID); CREATE INDEX IWEBCAL_VIEWUSERNEWINDEX ON WEBCAL_VIEW_USER(CAL_VIEW_ID, CAL_LOGIN); CREATE INDEX IWEBCAL_CONFIGNEWINDEX ON WEBCAL_CONFIG(CAL_SETTING); CREATE INDEX IWEBCAL_ENTRYLOGINDEX ON WEBCAL_ENTRY_LOG(CAL_LOG_ID); CREATE INDEX IWEBCAL_CATEGORIESINDEX ON WEBCAL_CATEGORIES(CAT_ID); CREATE INDEX IWEBCAL_BOSSINDEX ON WEBCAL_ASST(CAL_BOSS, CAL_ASSISTANT); CREATE INDEX IWEBCAL_NONUSERCALSINDEX ON WEBCAL_NONUSER_CALS(CAL_LOGIN); CREATE INDEX IWEBCAL_IMPORT2INDEX ON WEBCAL_IMPORT(CAL_IMPORT_ID); CREATE INDEX IWEBCAL_IMPORTINDEX ON WEBCAL_IMPORT_DATA(CAL_LOGIN, CAL_ID); CREATE INDEX IWEBCAL_REPORTINDEX ON WEBCAL_REPORT(CAL_REPORT_ID); CREATE INDEX IWEBCAL_REPORTTEMPLATEINDEX ON WEBCAL_REPORT_TEMPLATE(CAL_REPORT_ID, CAL_TEMPLATE_TYPE); CREATE INDEX IWEBCAL_ACCESSUSERINDEX ON WEBCAL_ACCESS_USER(CAL_LOGIN, CAL_OTHER_USER); CREATE INDEX IWEBCAL_ACCESSFUNCTIONINDEX ON WEBCAL_ACCESS_FUNCTION(CAL_LOGIN); CREATE INDEX IWEBCAL_USERTEMPLATE ON WEBCAL_USER_TEMPLATE(CAL_LOGIN,CAL_TYPE); CREATE INDEX IWEBCAL_BLOB ON WEBCAL_BLOB(CAL_BLOB_ID); CREATE INDEX IWEBCAL_TIMEZONESNEWINDEX ON WEBCAL_TIMEZONES(TZID); PK 큓\��t�# �# upgrade-mssql.sqlnu �[��� /* $Id: upgrade-mssql.sql,v 1.29 2009/10/30 11:47:16 bbannon Exp $ */ /*upgrade_v0.9.14*/ UPDATE webcal_entry SET cal_time = -1 WHERE cal_time is null; CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT '0' NOT NULL, cal_type VARCHAR(20) NULL, cal_end INT NULL, cal_frequency INT DEFAULT '1', cal_days CHAR(7) NULL, PRIMARY KEY (cal_id) ); /*upgrade_v0.9.22*/ CREATE TABLE webcal_user_layers ( cal_layerid INT DEFAULT '0' NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_layeruser VARCHAR(25) NOT NULL, cal_color VARCHAR(25) NULL, cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ) ); /*upgrade_v0.9.27*/ CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT '0' NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT '0', cal_remind INT DEFAULT '0', cal_data TEXT NULL, PRIMARY KEY ( cal_id, cal_name, cal_type ) ); /*upgrade_v0.9.35*/ CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_owner VARCHAR(25) NULL, cal_name VARCHAR(50) NOT NULL, cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_view_type CHAR(1) NULL, PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(50) NULL, PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_date INT NOT NULL, cal_time INT NULL, cal_text TEXT NULL, PRIMARY KEY ( cal_log_id ) ); /*upgrade_v0.9.37*/ ALTER TABLE webcal_entry_log ADD cal_user_cal VARCHAR(25) NULL; CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); /*upgrade_v0.9.38*/ ALTER TABLE webcal_entry_user ADD cal_category INT NULL; CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_owner VARCHAR(25) NULL, cat_name VARCHAR(80) NOT NULL, PRIMARY KEY ( cat_id ) ); /*upgrade_v0.9.40*/ DELETE FROM webcal_config WHERE cal_setting LIKE 'DATE_FORMAT%'; DELETE FROM webcal_user_pref WHERE cal_setting LIKE 'DATE_FORMAT%'; CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75) NULL, PRIMARY KEY ( cal_id, cal_fullname ) ); ALTER TABLE webcal_entry ADD cal_ext_for_id INT NULL; /*upgrade_v0.9.41*/ CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_lastname VARCHAR(25) NULL, cal_firstname VARCHAR(25) NULL, cal_admin VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_login ) ); /*upgrade_v0.9.42*/ CREATE TABLE webcal_report ( cal_login VARCHAR(25) NOT NULL, cal_report_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_time_range INT NOT NULL, cal_user VARCHAR(25) NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text TEXT NULL, PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_import_data ( cal_id int NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v0.9.43*/ ALTER TABLE webcal_user MODIFY cal_passwd VARCHAR(32) NULL; DROP TABLE webcal_import_data; CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_name VARCHAR(50) NULL, cal_date INT NOT NULL, cal_type VARCHAR(10) NOT NULL, cal_login VARCHAR(25) NULL, PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_import_id INT NOT NULL, cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ) ); /*upgrade_v1.0RC3*/ ALTER TABLE webcal_view ADD cal_is_global CHAR(1) DEFAULT 'N' NOT NULL; UPDATE webcal_user_pref SET cal_value = 'day.php' WHERE cal_value = 'day' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'week.php' WHERE cal_value = 'week' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'month.php' WHERE cal_value = 'month' AND cal_setting = 'STARTVIEW'; UPDATE webcal_user_pref SET cal_value = 'year.php' WHERE cal_value = 'year' AND cal_setting = 'STARTVIEW'; UPDATE webcal_config SET cal_value = 'week.php' WHERE cal_setting = 'STARTVIEW'; /*upgrade_v1.1.0-CVS*/ CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); ALTER TABLE webcal_nonuser_cals ADD cal_is_public CHAR(1) DEFAULT 'N' NOT NULL; /*upgrade_v1.1.0a-CVS*/ CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text TEXT NULL, PRIMARY KEY ( cal_login, cal_type ) ); ALTER TABLE webcal_entry_repeats ADD cal_endtime INT NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonth VARCHAR(50) NULL; ALTER TABLE webcal_entry_repeats ADD cal_bymonthday VARCHAR(100) NULL; ALTER TABLE webcal_entry_repeats ADD cal_byday VARCHAR(100) NULL; ALTER TABLE webcal_entry_repeats ADD cal_bysetpos VARCHAR(50) NULL; ALTER TABLE webcal_entry_repeats ADD cal_byweekno VARCHAR(50) NULL; ALTER TABLE webcal_entry_repeats ADD cal_byyearday VARCHAR(50) NULL; ALTER TABLE webcal_entry_repeats ADD cal_wkst char(2) default 'MO'; ALTER TABLE webcal_entry_repeats ADD cal_count INT NULL; ALTER TABLE webcal_entry_repeats_not ADD cal_exdate INT NOT NULL default '1'; ALTER TABLE webcal_entry ADD cal_due_date INT NULL; ALTER TABLE webcal_entry ADD cal_due_time INT NULL; ALTER TABLE webcal_entry ADD cal_location VARCHAR(100) NULL; ALTER TABLE webcal_entry ADD cal_url VARCHAR(100) NULL; ALTER TABLE webcal_entry ADD cal_completed INT NULL; ALTER TABLE webcal_entry_user ADD cal_percent INT NOT NULL default '0'; /*upgrade_v1.1.0b-CVS*/ CREATE TABLE webcal_entry_categories ( cal_id INT NOT NULL default '0', cat_id INT NOT NULL default '0', cat_order INT NOT NULL default '0', cat_owner VARCHAR(25) NULL ); /*upgrade_v1.1.0c-CVS*/ CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT NULL, cal_login VARCHAR(25) NULL, cal_name VARCHAR(30) NULL, cal_description VARCHAR(128) NULL, cal_size INT NULL, cal_mime_type VARCHAR(50) NULL, cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob IMAGE NULL, PRIMARY KEY ( cal_blob_id ) ); /*upgrade_v1.1.0d-CVS*/ DROP TABLE webcal_access_user; CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT NOT NULL DEFAULT '0', cal_can_edit INT NOT NULL DEFAULT '0', cal_can_approve INT NOT NULL DEFAULT '0', cal_can_invite CHAR(1) NOT NULL DEFAULT 'Y', cal_can_email CHAR(1) NOT NULL DEFAULT 'Y', cal_see_time_only CHAR(1) NOT NULL DEFAULT 'N', PRIMARY KEY ( cal_login, cal_other_user ) ); /*upgrade_v1.1.0e-CVS*/ CREATE TABLE webcal_reminders ( cal_id INT NOT NULL DEFAULT '0', cal_date INT NOT NULL DEFAULT '0', cal_offset INT NOT NULL DEFAULT '0', cal_related CHAR(1) NOT NULL DEFAULT 'S', cal_before CHAR(1) NOT NULL DEFAULT 'Y', cal_last_sent INT NOT NULL DEFAULT '0', cal_repeats INT NOT NULL DEFAULT '0', cal_duration INT NOT NULL DEFAULT '0', cal_times_sent INT NOT NULL DEFAULT '0', cal_action VARCHAR(12) NOT NULL DEFAULT 'EMAIL', PRIMARY KEY ( cal_id ) ); /*upgrade_v1.1.1*/ ALTER TABLE webcal_nonuser_cals ADD cal_url VARCHAR(75) DEFAULT NULL; /*upgrade_v1.1.2*/ ALTER TABLE webcal_categories ADD cat_color VARCHAR(8) DEFAULT NULL; ALTER TABLE webcal_user ADD cal_enabled CHAR(1) DEFAULT 'Y'; ALTER TABLE webcal_user ADD cal_telephone VARCHAR(50) NULL; ALTER TABLE webcal_user ADD cal_address VARCHAR(75) NULL; ALTER TABLE webcal_user ADD cal_title VARCHAR(75) NULL; ALTER TABLE webcal_user ADD cal_birthday INT NULL; ALTER TABLE webcal_user ADD cal_last_login INT NULL; /*upgrade_v1.1.3*/ CREATE TABLE webcal_timezones ( tzid VARCHAR(100) NOT NULL DEFAULT '', dtstart VARCHAR(25) DEFAULT NULL, dtend VARCHAR(25) DEFAULT NULL, vtimezone TEXT, PRIMARY KEY ( tzid ) ); /*upgrade_v1.3.0*/ PK 큓\�<�E E tables-oracle.sqlnu �[��� CREATE TABLE webcal_user ( cal_login VARCHAR2(25) NOT NULL, cal_address VARCHAR2(75) NULL, cal_birthday INT NULL, cal_email VARCHAR2(75) NULL, cal_enabled CHAR(1) DEFAULT 'Y', cal_firstname VARCHAR2(25), cal_lastname VARCHAR2(25), cal_is_admin CHAR(1) DEFAULT 'N', cal_last_login INT NULL, cal_passwd VARCHAR2(32), cal_telephone VARCHAR2(50) NULL, cal_title VARCHAR2(75) NULL, PRIMARY KEY ( cal_login ) ); INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' ); CREATE TABLE webcal_entry ( cal_id INT NOT NULL, cal_access CHAR(1) DEFAULT 'P', cal_completed INT NULL, cal_create_by VARCHAR2(25) NOT NULL, cal_date INT NOT NULL, cal_description VARCHAR2(1024), cal_due_date INT NULL, cal_due_time INT NULL, cal_duration INT NOT NULL, cal_ext_for_id INT NULL, cal_group_id INT NULL, cal_location VARCHAR2(100) NULL, cal_mod_date INT, cal_mod_time INT, cal_name VARCHAR2(80) NOT NULL, cal_priority INT DEFAULT 5, cal_time INT NULL, cal_type CHAR(1) DEFAULT 'E', cal_url VARCHAR2(100) NULL, PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT 0 NOT NULL, cal_days CHAR(7), cal_end INT, cal_endtime INT NULL, cal_frequency INT DEFAULT 1, cal_type VARCHAR2(20), cal_byday VARCHAR2(100) NULL, cal_bymonth VARCHAR2(50) NULL, cal_bymonthday VARCHAR2(100) NULL, cal_bysetpos VARCHAR2(50) NULL, cal_byweekno VARCHAR2(50) NULL, cal_byyearday VARCHAR2(50) NULL, cal_count INT NULL, cal_wkst CHAR(2) DEFAULT 'MO', PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, cal_exdate INT DEFAULT 1 NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); CREATE TABLE webcal_entry_user ( cal_id INT DEFAULT 0 NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_category INT NULL, cal_percent INT DEFAULT 0 NOT NULL, cal_status CHAR(1) DEFAULT 'A', PRIMARY KEY ( cal_id,cal_login ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR2(50) NOT NULL, cal_email VARCHAR2(75) NULL, PRIMARY KEY ( cal_id, cal_fullname ) ); CREATE TABLE webcal_user_pref ( cal_login VARCHAR2(25) NOT NULL, cal_setting VARCHAR2(25) NOT NULL, cal_value VARCHAR2(100) NULL, PRIMARY KEY ( cal_login, cal_setting ) ); CREATE TABLE webcal_user_layers ( cal_login VARCHAR2(25) NOT NULL, cal_layeruser VARCHAR2(25) NOT NULL, cal_color VARCHAR2(25) NULL, cal_dups CHAR(1) DEFAULT 'N', cal_layerid INT DEFAULT 0 NOT NULL, PRIMARY KEY ( cal_login, cal_layeruser ) ); CREATE TABLE webcal_site_extras ( cal_date INT DEFAULT 0, cal_id INT DEFAULT 0 NOT NULL, cal_name VARCHAR2(25) NOT NULL, cal_remind INT DEFAULT 0, cal_type INT NOT NULL, cal_data LONG ); CREATE TABLE webcal_reminders ( cal_id INT DEFAULT 0 NOT NULL, cal_action VARCHAR2(12) DEFAULT 'EMAIL' NOT NULL, cal_before CHAR(1) DEFAULT 'Y' NOT NULL, cal_date INT DEFAULT 0 NOT NULL, cal_duration INT DEFAULT 0 NOT NULL, cal_last_sent INT DEFAULT 0 NOT NULL, cal_offset INT DEFAULT 0 NOT NULL, cal_related CHAR(1) DEFAULT 'S' NOT NULL, cal_repeats INT DEFAULT 0 NOT NULL, cal_times_sent INT DEFAULT 0 NOT NULL, PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_last_update INT NOT NULL, cal_name VARCHAR2(50) NOT NULL, cal_owner VARCHAR2(25) NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_name VARCHAR2(50) NOT NULL, cal_owner VARCHAR2(25) NOT NULL, cal_view_type CHAR(1), PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR2(50) NOT NULL, cal_value VARCHAR2(100) NULL, PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_date INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_time INT NULL, cal_type CHAR(1) NOT NULL, cal_user_cal VARCHAR2(25) NULL, cal_text VARCHAR2(1024), PRIMARY KEY ( cal_log_id ) ); CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_color VARCHAR2(8) NULL, cat_name VARCHAR2(80) NOT NULL, cat_owner VARCHAR2(25), PRIMARY KEY ( cat_id ) ); CREATE TABLE webcal_asst ( cal_boss VARCHAR2(25) NOT NULL, cal_assistant VARCHAR2(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR2(25) NOT NULL, cal_admin VARCHAR2(25) NOT NULL, cal_firstname VARCHAR2(25) NULL, cal_lastname VARCHAR2(25) NULL, cal_is_public CHAR(1) DEFAULT 'N' NOT NULL, cal_url VARCHAR2(255) DEFAULT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_date INT NOT NULL, cal_login VARCHAR2(25) NULL, cal_name VARCHAR2(50) NULL, cal_type VARCHAR2(10) NOT NULL, PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_id INT NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_external_id VARCHAR2(200) NULL, cal_import_id INT NOT NULL, cal_import_type VARCHAR2(15) NOT NULL, PRIMARY KEY ( cal_id, cal_login ) ); CREATE TABLE webcal_report ( cal_report_id INT NOT NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_login VARCHAR2(25) NOT NULL, cal_report_name VARCHAR2(50) NOT NULL, cal_report_type VARCHAR2(20) NOT NULL, cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_time_range INT NOT NULL, cal_update_date INT NOT NULL, cal_user VARCHAR2(25) NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text LONG, PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR2(50) NOT NULL, cal_other_user VARCHAR2(50) NOT NULL, cal_can_approve INT DEFAULT 0 NOT NULL, cal_can_edit INT DEFAULT 0 NOT NULL, cal_can_email CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_invite CHAR(1) DEFAULT 'Y' NOT NULL, cal_can_view INT DEFAULT 0 NOT NULL, cal_see_time_only CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_login, cal_other_user ) ); CREATE TABLE webcal_access_function ( cal_login VARCHAR2(50) NOT NULL, cal_permissions VARCHAR2(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_user_template ( cal_login VARCHAR2(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text VARCHAR2(1024), PRIMARY KEY ( cal_login, cal_type ) ); CREATE TABLE webcal_entry_categories ( cal_id INT DEFAULT 0 NOT NULL, cat_id INT DEFAULT 0 NOT NULL, cat_order INT DEFAULT 0 NOT NULL, cat_owner VARCHAR2(25) NULL ); CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_description VARCHAR2(128) NULL, cal_id INT NULL, cal_login VARCHAR2(25) NULL, cal_mime_type VARCHAR2(50) NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_name VARCHAR2(30) NULL, cal_size INT NULL, cal_type CHAR(1) NOT NULL, cal_blob BLOB, PRIMARY KEY ( cal_blob_id ) ); CREATE TABLE webcal_timezones ( tzid VARCHAR2(100) DEFAULT '' NOT NULL, dtstart VARCHAR2(25) DEFAULT NULL, dtend VARCHAR2(25) DEFAULT NULL, vtimezone VARCHAR2(4000), PRIMARY KEY ( tzid ) ); PK 큓\(k��" �" tables-mssql.sqlnu �[��� CREATE TABLE webcal_user ( cal_login VARCHAR(25) NOT NULL, cal_passwd VARCHAR(32) NULL, cal_lastname VARCHAR(25) NULL, cal_firstname VARCHAR(25) NULL, cal_is_admin CHAR(1) DEFAULT 'N', cal_email VARCHAR(75) NULL, cal_enabled CHAR(1) DEFAULT 'Y', cal_telephone VARCHAR(50) NULL, cal_address VARCHAR(75) NULL, cal_title VARCHAR(75) NULL, cal_birthday INT NULL, cal_last_login INT NULL, PRIMARY KEY ( cal_login ) ); INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' ); CREATE TABLE webcal_entry ( cal_id INT NOT NULL, cal_group_id INT NULL, cal_ext_for_id INT NULL, cal_create_by VARCHAR(25) NOT NULL, cal_date INT NOT NULL, cal_time INT NULL, cal_mod_date INT NULL, cal_mod_time INT NULL, cal_duration INT NOT NULL, cal_due_date INT NULL, cal_due_time INT NULL, cal_priority INT DEFAULT 5, cal_type CHAR(1) DEFAULT 'E', cal_access CHAR(1) DEFAULT 'P', cal_name VARCHAR(80) NOT NULL, cal_location VARCHAR(100) NULL, cal_url VARCHAR(100) NULL, cal_completed INT NULL, cal_description TEXT NULL, PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT '0' NOT NULL, cal_type VARCHAR(20) NOT NULL, cal_end INT NULL, cal_frequency INT DEFAULT '1', cal_days CHAR(7) NULL, cal_endtime INT NULL, cal_bymonth VARCHAR(50) NULL, cal_bymonthday VARCHAR(100) NULL, cal_byday VARCHAR(100) NULL, cal_bysetpos VARCHAR(50) NULL, cal_byweekno VARCHAR(50) NULL, cal_byyearday VARCHAR(50) NULL, cal_wkst char(2) DEFAULT 'MO', cal_count INT NULL, PRIMARY KEY (cal_id) ); CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, cal_exdate INT DEFAULT '1' NOT NULL, PRIMARY KEY ( cal_id, cal_date ) ); CREATE TABLE webcal_entry_user ( cal_id int DEFAULT '0' NOT NULL, cal_login varchar(25) DEFAULT '' NOT NULL, cal_status char(1) DEFAULT 'A' NOT NULL, cal_category INT NULL, cal_percent INT DEFAULT '0' NOT NULL, PRIMARY KEY ( cal_id,cal_login ) ); CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75) NOT NULL, PRIMARY KEY ( cal_id, cal_fullname ) ); CREATE TABLE webcal_user_pref ( cal_login varchar(25) NOT NULL, cal_setting varchar(25) NOT NULL, cal_value varchar(100) NULL, PRIMARY KEY ( cal_login, cal_setting ) ); CREATE TABLE webcal_user_layers ( cal_layerid INT DEFAULT '0' NOT NULL, cal_login varchar(25) NOT NULL, cal_layeruser varchar(25) NOT NULL, cal_color varchar(25) NULL, cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ) ); CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT '0' NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT '0', cal_remind INT DEFAULT '0', cal_data TEXT ); CREATE TABLE webcal_reminders ( cal_id INT NOT NULL DEFAULT '0', cal_date INT NOT NULL DEFAULT '0', cal_offset INT NOT NULL DEFAULT '0', cal_related CHAR(1) NOT NULL DEFAULT 'S', cal_before CHAR(1) NOT NULL DEFAULT 'Y', cal_last_sent INT DEFAULT '0', cal_repeats INT NOT NULL DEFAULT '0', cal_duration INT NOT NULL DEFAULT '0', cal_times_sent INT NOT NULL DEFAULT '0', cal_action VARCHAR(12) NOT NULL DEFAULT 'EMAIL', PRIMARY KEY ( cal_id ) ); CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ) ); CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ) ); CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_view_type CHAR(1) NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_view_id ) ); CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ) ); CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(100) NULL, PRIMARY KEY ( cal_setting ) ); CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_user_cal VARCHAR(25) NULL, cal_type CHAR(1) NOT NULL, cal_date INT NOT NULL, cal_time INT NOT NULL, cal_text TEXT NULL, PRIMARY KEY ( cal_log_id ) ); CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_owner VARCHAR(25) NULL, cat_name VARCHAR(80) NOT NULL, cat_color VARCHAR(8) NULL, PRIMARY KEY ( cat_id ) ); CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ) ); CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_lastname VARCHAR(25) NULL, cal_firstname VARCHAR(25) NULL, cal_admin VARCHAR(25) NOT NULL, cal_is_public CHAR(1) NOT NULL DEFAULT 'N', cal_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_name VARCHAR(50) NULL, cal_date INT NOT NULL, cal_type VARCHAR(10) NOT NULL, cal_login VARCHAR(25) NULL, PRIMARY KEY ( cal_import_id ) ); CREATE TABLE webcal_import_data ( cal_import_id INT NOT NULL, cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ) ); CREATE TABLE webcal_report ( cal_login VARCHAR(25) NOT NULL, cal_report_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_time_range INT NOT NULL, cal_user VARCHAR(25) NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ) ); CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text TEXT NULL, PRIMARY KEY ( cal_report_id, cal_template_type ) ); CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT NOT NULL DEFAULT '0', cal_can_edit INT NOT NULL DEFAULT '0', cal_can_approve INT NOT NULL DEFAULT '0', cal_can_invite CHAR(1) NOT NULL DEFAULT 'Y', cal_can_email CHAR(1) NOT NULL DEFAULT 'Y', cal_see_time_only CHAR(1) NOT NULL DEFAULT 'N', PRIMARY KEY ( cal_login, cal_other_user ) ); CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ) ); CREATE TABLE webcal_tz_zones ( zone_name VARCHAR(50) NOT NULL DEFAULT '', zone_gmtoff INT NOT NULL DEFAULT '0', zone_rules VARCHAR(50) NOT NULL DEFAULT '', zone_format VARCHAR(20) NOT NULL DEFAULT '', zone_from BIGINT NOT NULL DEFAULT '0', zone_until BIGINT NOT NULL DEFAULT '0', zone_cc CHAR(2) NOT NULL DEFAULT '', zone_coord VARCHAR(20) NOT NULL DEFAULT '', zone_country VARCHAR(50) NOT NULL DEFAULT '' ); CREATE TABLE webcal_tz_rules ( rule_name VARCHAR(50) DEFAULT '' NOT NULL, rule_from INT DEFAULT '0' NOT NULL, rule_to INT DEFAULT '0' NOT NULL, rule_type VARCHAR(20) DEFAULT '' NOT NULL, rule_in INT DEFAULT '0' NOT NULL, rule_on VARCHAR(20) DEFAULT '' NOT NULL, rule_at INT DEFAULT '0' NOT NULL, rule_at_suffix CHAR(1) DEFAULT '' NOT NULL, rule_save INT default '0' NOT NULL, rule_letter VARCHAR(5) DEFAULT '' NOT NULL ); CREATE TABLE webcal_tz_list ( tz_list_id INT default '0' NOT NULL, tz_list_name VARCHAR(50) default '' NOT NULL, tz_list_text VARCHAR(75) default '' NOT NULL ); CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL, cal_type CHAR(1) NOT NULL, cal_template_text TEXT NULL, PRIMARY KEY ( cal_login, cal_type ) ); CREATE TABLE webcal_entry_categories ( cal_id INT DEFAULT '0' NOT NULL, cat_id INT DEFAULT '0' NOT NULL, cat_order INT DEFAULT '0' NOT NULL, cat_owner VARCHAR(25) NULL ); CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT NULL, cal_login VARCHAR(25) NULL, cal_name VARCHAR(30) NULL, cal_description VARCHAR(128) NULL, cal_size INT NULL, cal_mime_type VARCHAR(50) NULL, cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob IMAGE NULL, PRIMARY KEY ( cal_blob_id ) ); CREATE TABLE webcal_timezones ( tzid VARCHAR(100) NOT NULL DEFAULT '', dtstart VARCHAR(25) DEFAULT NULL, dtend VARCHAR(25) DEFAULT NULL, vtimezone TEXT, PRIMARY KEY ( tzid ) ); PK 큓\e��.> > tables-sqlite.phpnu �[��� <?php // $Id: tables-sqlite.php,v 1.24 2009/11/22 16:47:47 bbannon Exp $ /** * Description: * This file will create an SQLite database. */ function populate_sqlite_db ( $database, $db ) { sqlite_query($db, "CREATE TABLE webcal_user (cal_login VARCHAR(25) NOT NULL, cal_passwd VARCHAR(32), cal_lastname VARCHAR(25), cal_firstname VARCHAR(25), cal_is_admin CHAR(1) DEFAULT 'N',cal_email VARCHAR(75) NULL,cal_enabled CHAR(1) DEFAULT 'Y',cal_telephone VARCHAR(50) NULL,cal_address VARCHAR(75) NULL,cal_title VARCHAR(75) NULL,cal_birthday INT,cal_last_login INT, PRIMARY KEY ( cal_login ))"); sqlite_query($db, "INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' );"); sqlite_query($db, "CREATE TABLE webcal_entry ( cal_id INT NOT NULL, cal_group_id INT NULL, cal_ext_for_id INT NULL, cal_create_by VARCHAR(25) NOT NULL, cal_date INT NOT NULL, cal_time INT NULL, cal_mod_date INT, cal_mod_time INT, cal_duration INT NOT NULL, cal_due_date INT default NULL, cal_due_time INT default NULL, cal_location varchar(100) default NULL, cal_url varchar(100) default NULL, cal_completed INT default NULL, cal_priority INT DEFAULT 5, cal_type CHAR(1) DEFAULT 'E', cal_access CHAR(1) DEFAULT 'P', cal_name VARCHAR(80) NOT NULL, cal_description TEXT, PRIMARY KEY ( cal_id ))"); sqlite_query($db, "CREATE TABLE webcal_entry_repeats ( cal_id INT DEFAULT 0 NOT NULL, cal_type VARCHAR(20), cal_end INT, cal_frequency INT DEFAULT 1, cal_days CHAR(7), cal_endtime int(11) default NULL, cal_bymonth varchar(50) default NULL, cal_bymonthday varchar(100) default NULL, cal_byday varchar(100) default NULL, cal_bysetpos varchar(50) default NULL, cal_byweekno varchar(50) default NULL, cal_byyearday varchar(50) default NULL, cal_wkst char(2) default 'MO', cal_count int(11) default NULL, PRIMARY KEY (cal_id))"); sqlite_query($db, "CREATE TABLE webcal_entry_repeats_not ( cal_id INT NOT NULL, cal_date INT NOT NULL, cal_exdate INT NOT NULL default '1', PRIMARY KEY ( cal_id, cal_date ))"); sqlite_query($db, "CREATE TABLE webcal_entry_user ( cal_id INT DEFAULT 0 NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_status CHAR(1) DEFAULT 'A', cal_category INT DEFAULT NULL, cal_percent INT NOT NULL default '0', PRIMARY KEY ( cal_id, cal_login ))"); sqlite_query($db, "CREATE TABLE webcal_entry_ext_user ( cal_id INT DEFAULT 0 NOT NULL, cal_fullname VARCHAR(50) NOT NULL, cal_email VARCHAR(75) NULL, PRIMARY KEY ( cal_id, cal_fullname ))"); sqlite_query($db, "CREATE TABLE webcal_user_pref ( cal_login VARCHAR(25) NOT NULL, cal_setting VARCHAR(25) NOT NULL, cal_value VARCHAR(100) NULL, PRIMARY KEY ( cal_login, cal_setting ))"); sqlite_query($db, "CREATE TABLE webcal_user_layers ( cal_layerid INT DEFAULT 0 NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_layeruser VARCHAR(25) NOT NULL, cal_color VARCHAR(25) NULL, cal_dups CHAR(1) DEFAULT 'N', PRIMARY KEY ( cal_login, cal_layeruser ))"); sqlite_query($db, "CREATE TABLE webcal_site_extras ( cal_id INT DEFAULT 0 NOT NULL, cal_name VARCHAR(25) NOT NULL, cal_type INT NOT NULL, cal_date INT DEFAULT 0, cal_remind INT DEFAULT 0, cal_data TEXT)"); sqlite_query($db, "CREATE TABLE webcal_reminders (cal_id INT DEFAULT 0 NOT NULL,cal_date INT DEFAULT 0 NOT NULL,cal_offset INT DEFAULT 0 NOT NULL,cal_related CHAR(1) DEFAULT 'S' NOT NULL,cal_before CHAR(1) DEFAULT 'Y' NOT NULL,cal_last_sent INT DEFAULT NULL,cal_repeats INT DEFAULT 0 NOT NULL,cal_duration INT DEFAULT 0 NOT NULL,cal_times_sent INT DEFAULT 0 NOT NULL,cal_action VARCHAR(12) DEFAULT 'EMAIL' NOT NULL,PRIMARY KEY ( cal_id ))"); sqlite_query($db, "CREATE TABLE webcal_group ( cal_group_id INT NOT NULL, cal_owner VARCHAR(25) NULL, cal_name VARCHAR(50) NOT NULL, cal_last_update INT NOT NULL, PRIMARY KEY ( cal_group_id ))"); sqlite_query($db, "CREATE TABLE webcal_group_user ( cal_group_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_group_id, cal_login ))"); sqlite_query($db, "CREATE TABLE webcal_view ( cal_view_id INT NOT NULL, cal_owner VARCHAR(25) NOT NULL, cal_name VARCHAR(50) NOT NULL, cal_view_type CHAR(1), cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, PRIMARY KEY ( cal_view_id ))"); sqlite_query($db, "CREATE TABLE webcal_view_user ( cal_view_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_view_id, cal_login ))"); sqlite_query($db, "CREATE TABLE webcal_config ( cal_setting VARCHAR(50) NOT NULL, cal_value VARCHAR(100) NULL, PRIMARY KEY ( cal_setting ))"); sqlite_query($db, "CREATE TABLE webcal_entry_log ( cal_log_id INT NOT NULL, cal_entry_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_user_cal VARCHAR(25) NULL, cal_type CHAR(1) NOT NULL, cal_date INT NOT NULL, cal_time INT NULL, cal_text TEXT, PRIMARY KEY ( cal_log_id ))"); sqlite_query($db, "CREATE TABLE webcal_categories ( cat_id INT NOT NULL, cat_owner VARCHAR(25) NULL, cat_name VARCHAR(80) NOT NULL,cat_color VARCHAR(8) NULL, PRIMARY KEY ( cat_id ))"); sqlite_query($db, "CREATE TABLE webcal_asst ( cal_boss VARCHAR(25) NOT NULL, cal_assistant VARCHAR(25) NOT NULL, PRIMARY KEY ( cal_boss, cal_assistant ))"); sqlite_query($db, "CREATE TABLE webcal_nonuser_cals ( cal_login VARCHAR(25) NOT NULL, cal_lastname VARCHAR(25) NULL, cal_firstname VARCHAR(25) NULL, cal_admin VARCHAR(25) NOT NULL, cal_is_public CHAR(1) DEFAULT 'N' NOT NULL, cal_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY ( cal_login ))"); sqlite_query($db, "CREATE TABLE webcal_import ( cal_import_id INT NOT NULL, cal_name VARCHAR(50) NULL, cal_date INT NOT NULL, cal_type VARCHAR(10) NOT NULL, cal_login VARCHAR(25) NULL, PRIMARY KEY ( cal_import_id ))"); sqlite_query($db, "CREATE TABLE webcal_import_data ( cal_import_id INT NOT NULL, cal_id INT NOT NULL, cal_login VARCHAR(25) NOT NULL, cal_import_type VARCHAR(15) NOT NULL, cal_external_id VARCHAR(200) NULL, PRIMARY KEY ( cal_id, cal_login ))"); sqlite_query($db, "CREATE TABLE webcal_report ( cal_login VARCHAR(25) NOT NULL, cal_report_id INT NOT NULL, cal_is_global CHAR(1) DEFAULT 'N' NOT NULL, cal_report_type VARCHAR(20) NOT NULL, cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL, cal_report_name VARCHAR(50) NOT NULL, cal_time_range INT NOT NULL, cal_user VARCHAR(25) NULL, cal_allow_nav CHAR(1) DEFAULT 'Y', cal_cat_id INT NULL, cal_include_empty CHAR(1) DEFAULT 'N', cal_show_in_trailer CHAR(1) DEFAULT 'N', cal_update_date INT NOT NULL, PRIMARY KEY ( cal_report_id ))"); sqlite_query($db, "CREATE TABLE webcal_report_template ( cal_report_id INT NOT NULL, cal_template_type CHAR(1) NOT NULL, cal_template_text TEXT, PRIMARY KEY ( cal_report_id, cal_template_type ))"); sqlite_query($db, "CREATE TABLE webcal_access_user ( cal_login VARCHAR(25) NOT NULL, cal_other_user VARCHAR(25) NOT NULL, cal_can_view INT NOT NULL DEFAULT '0', cal_can_edit INT NOT NULL DEFAULT '0', cal_can_approve INT NOT NULL DEFAULT '0', cal_can_invite CHAR(1) NOT NULL DEFAULT 'Y', cal_can_email CHAR(1) NOT NULL DEFAULT 'Y', cal_see_time_only CHAR(1) NOT NULL DEFAULT 'N', PRIMARY KEY ( cal_login, cal_other_user ))"); sqlite_query($db, "CREATE TABLE webcal_access_function ( cal_login VARCHAR(25) NOT NULL, cal_permissions VARCHAR(64) NOT NULL, PRIMARY KEY ( cal_login ))"); sqlite_query($db, "CREATE TABLE webcal_user_template ( cal_login VARCHAR(25) NOT NULL default '', cal_type CHAR(1) NOT NULL default '', cal_template_text text, PRIMARY KEY (cal_login,cal_type))"); sqlite_query($db, "CREATE TABLE webcal_entry_categories (cal_id INT NOT NULL default '0', cat_id INT NOT NULL default '0', cat_order INT NOT NULL default '0', cat_owner VARCHAR(25) default NULL)"); sqlite_query($db, "CREATE TABLE webcal_blob ( cal_blob_id INT NOT NULL, cal_id INT NULL, cal_login VARCHAR(25) NULL, cal_name VARCHAR(30) NULL, cal_description VARCHAR(128) NULL, cal_size INT NULL, cal_mime_type VARCHAR(50) NULL, cal_type CHAR(1) NOT NULL, cal_mod_date INT NOT NULL, cal_mod_time INT NOT NULL, cal_blob BLOB, PRIMARY KEY ( cal_blob_id ))"); sqlite_query($db, "CREATE TABLE webcal_timezones (tzid varchar(100) NOT NULL default '', dtstart varchar(25) default NULL, dtend varchar(25) default NULL, vtimezone text, PRIMARY KEY ( tzid ))"); } ?> PK 큓\c} ��] �] tables-mysql.sqlnu �[��� PK 큓\F���F1 F1 �] upgrade-ibase.sqlnu �[��� PK 큓\�Ja=$ =$ I� upgrade-db2.sqlnu �[��� PK 큓\�y�@ @ ų upgrade_matrix.phpnu �[��� PK 큓\� �O� � G� tables-db2.sqlnu �[��� PK 큓\���� � /� tables-postgres.sqlnu �[��� PK 큓\+���R( R( D upgrade-postgres.sqlnu �[��� PK 큓\����$ �$ �) upgrade-oracle.sqlnu �[��� PK 큓\!f���" �" �N upgrade-mysql.sqlnu �[��� PK 큓\�+3� � r tables-sqlite3.phpnu �[��� PK 큓\� [�, �, I� tables-ibase.sqlnu �[��� PK 큓\��t�# �# r� upgrade-mssql.sqlnu �[��� PK 큓\�<�E E �� tables-oracle.sqlnu �[��� PK 큓\(k��" �" 7 tables-mssql.sqlnu �[��� PK 큓\e��.> > �$ tables-sqlite.phpnu �[��� PK � xE
| ver. 1.1 | |
.
| PHP 8.3.30 | Ð“ÐµÐ½ÐµÑ€Ð°Ñ†Ð¸Ñ Ñтраницы: 0 |
proxy
|
phpinfo
|
ÐаÑтройка