[prev in list] [next in list] [prev in thread] [next in thread] 

List:       squirrelmail-plugins
Subject:    Re: [SM-PLUGINS] Password in calendar_sql_backend
From:       "Paul Lesniewski" <paul () squirrelmail ! org>
Date:       2008-03-06 19:09:09
Message-ID: 58191e420803061109h1e90bc4fh6e95fa5b0680a64d () mail ! gmail ! com
[Download RAW message or body]

You might want to use a better subject next time.

> We are using mysql ver 5 here. We found that we had to change the database
> file a little to create the database in version 5 of mysql. Here are the
> changes that we put into a file called "DATABASE_squirrelmail_calendar".

If you are suggesting some changes, you should send a unified diff of
those changes.  Type "man diff" if you've never used diff before.


> ################################################ file start
> #
> # You can create the database from the shell with:
> #
> # mysql -u root -p < DATABASE_squirrelmail_calendar
> 
> # File name:
> # DATABASE_squirrelmail_calendar
> #
> 
> CREATE DATABASE squirrelmail_calendar;
> GRANT SELECT, UPDATE, INSERT, DELETE on squirrelmail_calendar.* TO \
> 'user'@'localhost'; 
> USE squirrelmail_calendar;
> CREATE TABLE calendars (
> id varchar(250) NOT NULL,
> type varchar(30) NOT NULL,
> name varchar(255) default '',
> domain varchar(128) default '',
> created_on datetime,
> last_modified_on datetime,
> ical_raw text NOT NULL,
> PRIMARY KEY (id),
> UNIQUE KEY id (id),
> KEY type (type)
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE calendar_owners (
> calendar_id varchar(250) NOT NULL,
> owner_name varchar(128) NOT NULL,
> PRIMARY KEY (calendar_id, owner_name),
> UNIQUE KEY cal_owner (calendar_id, owner_name)
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE calendar_readers (
> calendar_id varchar(250) NOT NULL,
> reader_name varchar(128) NOT NULL,
> PRIMARY KEY (calendar_id, reader_name),
> UNIQUE KEY cal_reader (calendar_id, reader_name)
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE calendar_writers (
> calendar_id varchar(250) NOT NULL,
> writer_name varchar(128) NOT NULL,
> PRIMARY KEY (calendar_id, writer_name),
> UNIQUE KEY cal_writer (calendar_id, writer_name)
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE events (
> id int(11) NOT NULL AUTO_INCREMENT,
> event_id varchar(250) NOT NULL,
> calendar_id varchar(250) NOT NULL,
> domain varchar(128) default '',
> evt_start datetime,
> evt_end datetime,
> isAllDay enum('YES', 'NO') NOT NULL,
> isRecurring enum('YES', 'NO') NOT NULL,
> isTask enum('YES', 'NO') NOT NULL,
> isHoliday enum('YES', 'NO') NOT NULL,
> priority tinyint(3) unsigned default 5,  -- default NORMAL priority
> created_on datetime,
> last_modified_on datetime,
> ical_raw text NOT NULL,
> PRIMARY KEY (id),
> UNIQUE KEY id (id),
> UNIQUE KEY event_id (event_id, calendar_id),
> KEY isRecurring (isRecurring),
> KEY isTask (isTask),
> KEY isHoliday (isHoliday),
> KEY evt_start (evt_start),
> KEY evt_end (evt_end)        -- TODO: should create some sensible composite keys
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE event_parent_calendars (
> event_key int(11) NOT NULL,
> parent_calendar_id varchar(250) NOT NULL,
> PRIMARY KEY (event_key, parent_calendar_id),
> UNIQUE KEY event_parent (event_key, parent_calendar_id)
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE event_owners (
> event_key int(11) NOT NULL,
> owner_name varchar(128) NOT NULL,
> PRIMARY KEY (event_key, owner_name),
> UNIQUE KEY event_owner (event_key, owner_name)
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE event_readers (
> event_key int(11) NOT NULL,
> reader_name varchar(128) NOT NULL,
> PRIMARY KEY (event_key, reader_name),
> UNIQUE KEY event_reader (event_key, reader_name)
> ) TYPE=MyISAM;
> 
> USE squirrelmail_calendar;
> CREATE TABLE event_writers (
> event_key int(11) NOT NULL,
> writer_name varchar(128) NOT NULL,
> PRIMARY KEY (event_key, writer_name),
> UNIQUE KEY event_writer (event_key, writer_name)
> ) TYPE=MyISAM;
> 
> ###################################### end of file
> 

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
-----
squirrelmail-plugins mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-plugins@lists.sourceforge.net
List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins
List info (subscribe/unsubscribe/change options): \
https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins


[prev in list] [next in list] [prev in thread] [next in thread]