38 lines
1.2 KiB
MySQL
38 lines
1.2 KiB
MySQL
|
-- SOGo Database Creation
|
||
|
|
|
||
|
|
CREATE DATABASE IF NOT EXISTS `sogo`;
|
||
|
|
|
||
|
|
CONNECT `sogo`;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `sogo_folder_info` (
|
||
|
|
`c_folder_id` bigint(20) unsigned NOT NULL auto_increment,
|
||
|
|
`c_path` varchar(255) NOT NULL,
|
||
|
|
`c_path1` varchar(255) NOT NULL,
|
||
|
|
`c_path2` varchar(255) default NULL,
|
||
|
|
`c_path3` varchar(255) default NULL,
|
||
|
|
`c_path4` varchar(255) default NULL,
|
||
|
|
`c_foldername` varchar(255) NOT NULL,
|
||
|
|
`c_location` varchar(2048) NOT NULL,
|
||
|
|
`c_quick_location` varchar(2048) default NULL,
|
||
|
|
`c_acl_location` varchar(2048) default NULL,
|
||
|
|
`c_folder_type` varchar(255) NOT NULL,
|
||
|
|
PRIMARY KEY (`c_path`),
|
||
|
|
UNIQUE KEY `c_folder_id` (`c_folder_id`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `sogo_user_profile` (
|
||
|
|
`c_uid` varchar(255) NOT NULL,
|
||
|
|
`c_defaults` text,
|
||
|
|
`c_settings` text,
|
||
|
|
PRIMARY KEY (`c_uid`)
|
||
|
|
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS`sogo_alarms_folder` (
|
||
|
|
`c_path` varchar(255) NOT NULL,
|
||
|
|
`c_name` varchar(255) NOT NULL,
|
||
|
|
`c_uid` varchar(255) NOT NULL,
|
||
|
|
`c_recurrence_id` int(11) default NULL,
|
||
|
|
`c_alarm_number` int(11) NOT NULL,
|
||
|
|
`c_alarm_date` int(11) NOT NULL
|
||
|
|
)ENGINE=MyISAM DEFAULT CHARSET=latin1;
|