"Fossies" - the Fresh Open Source Software Archive

Member "tiki-21.2/installer/schema/20080924_webmail_tiki.sql" (29 Jul 2020, 1030 Bytes) of package /linux/www/tiki-21.2.tar.xz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 #2008-09-16  MatWho
    2 ALTER TABLE tiki_user_mail_accounts ADD COLUMN `flagsPublic` char(1) default 'n' AFTER `smtpPort`;
    3 ALTER TABLE tiki_user_mail_accounts ADD COLUMN `autoRefresh` int(4) NOT NULL default 0 AFTER `flagsPublic`;
    4 ALTER TABLE tiki_webmail_messages ADD COLUMN `flaggedMsg` varchar(50) default '' AFTER `isFlagged`;
    5 
    6 #2008-09-27  MatWho
    7 INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_use_group_webmail', 'Can use group webmail', 'registered', 'webmail');
    8 INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_admin_group_webmail', 'Can administrate group webmail accounts', 'registered', 'webmail');
    9 INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_use_personal_webmail', 'Can use personal webmail accounts', 'registered', 'webmail');
   10 INSERT INTO users_permissions (`permName`, `permDesc`, level, type) VALUES ('tiki_p_admin_personal_webmail', 'Can administrate personal webmail accounts', 'registered', 'webmail');
   11