2.0_alpha release commit
[framework/messaging/email-service.git] / packaging / email-service.spec
old mode 100644 (file)
new mode 100755 (executable)
index 645c617..369ff10
@@ -1,19 +1,14 @@
 Name:       email-service
 Summary:    E-mail Framework Middleware package
-Version:    0.4.2
+Version:    0.9.8
 Release:    1
 Group:      System/Libraries
 License:    TBD
 Source0:    %{name}-%{version}.tar.gz
-Source1:    email.service
-Source1001: packaging/email-service.manifest 
 Requires(post):    /sbin/ldconfig
-Requires(post):    systemd
 Requires(post):    /usr/bin/sqlite3
 Requires(post):    /usr/bin/vconftool
-Requires(preun):   systemd
 Requires(postun):  /sbin/ldconfig
-Requires(postun):  systemd
 BuildRequires:  cmake
 BuildRequires:  pkgconfig(glib-2.0)
 BuildRequires:  pkgconfig(gthread-2.0)
@@ -26,7 +21,7 @@ BuildRequires:  pkgconfig(dbus-1)
 BuildRequires:  pkgconfig(dbus-glib-1)
 BuildRequires:  pkgconfig(contacts-service)
 BuildRequires:  pkgconfig(uw-imap-toolkit)
-BuildRequires:  pkgconfig(drm-service)
+BuildRequires:  pkgconfig(drm-client)
 BuildRequires:  pkgconfig(openssl)
 BuildRequires:  pkgconfig(alarm-service)
 BuildRequires:  pkgconfig(mm-player)
@@ -39,8 +34,11 @@ BuildRequires:  pkgconfig(capi-base-common)
 BuildRequires:  pkgconfig(libcurl)
 BuildRequires:  pkgconfig(libxml-2.0)
 BuildRequires:  pkgconfig(gconf-2.0)
+BuildRequires:  pkgconfig(cert-svc)
 
 
+BuildRoot:  %{_tmppath}/%{name}-%{version}-build
+
 %description
 E-mail Framework Middleware Library/Binary package
 
@@ -58,7 +56,6 @@ E-mail Framework Middleware Development package
 %setup -q
 
 %build
-cp %{SOURCE1001} .
 
 export CFLAGS="${CFLAGS} -fPIC -Wall -g -fvisibility=hidden"
 export CXXFLAGS="${CXXFLAGS} -fPIC -Wall -g -fvisibility=hidden"
@@ -66,107 +63,132 @@ export LDFLAGS="${LDFLAGS} -Wl,--hash-style=both -Wl,--rpath=%{_prefix}/lib -Wl,
 
 cmake . -DCMAKE_INSTALL_PREFIX=%{_prefix}
 
-make %{?_smp_mflags}
+# Call make instruction with smp support
+#make %{?jobs:-j%jobs}
+make
 
 %install
 %make_install
 
-mkdir -p %{buildroot}%{_libdir}/systemd/user/tizen-middleware.target.wants
-install -m 0644 %SOURCE1 %{buildroot}%{_libdir}/systemd/user/
-ln -sf ../email.service %{buildroot}%{_libdir}/systemd/user/tizen-middleware.target.wants/
+%clean
+rm -rf %{buildroot}
+
+%post
+/sbin/ldconfig
+
+
+#################################################################
+# Add preset account information
+#################################################################
+echo "[EMAIL-SERVICE] Start adding preset account information..." 
+
+################################################################################################
 
-rm -f %{buildroot}%{_bindir}/email-test-app
+# for default mail slot szie
+vconftool set -t int    db/private/email-service/slot_size "100"        -g 6514
 
-# FIXME: remove initscripts after systemd is ready
-mkdir -p %{buildroot}%{_sysconfdir}/rc.d/init.d
-cat << EOF > %{buildroot}%{_sysconfdir}/rc.d/init.d/email-service
-#!/bin/sh
-/usr/bin/email-service &
-EOF
+# for latest mail id
+vconftool set -t int    db/private/email-service/latest_mail_id "0"     -g 6514
 
-mkdir -p %{buildroot}%{_sysconfdir}/rc.d/rc3.d
-mkdir -p %{buildroot}%{_sysconfdir}/rc.d/rc5.d
-ln -sf ../init.d/email-service %{buildroot}%{_sysconfdir}/rc.d/rc3.d/S70email-service 
-ln -sf ../init.d/email-service %{buildroot}%{_sysconfdir}/rc.d/rc5.d/S70email-service
+# for default account id
+vconftool set -t int    db/private/email-service/default_account_id "0" -g 6514
 
-# Remove installed DB files; these are not the ones we want
-rm -f %{buildroot}/opt/dbspace/.email-service.db
-rm -f %{buildroot}/opt/dbspace/.email-service.db-journal
+
+#################################################################
+# Set executin script
+#################################################################
+echo "[EMAIL-SERVICE] Set executing script ..."
+EMAIL_SERVICE_EXEC_SCRIPT=/etc/rc.d/init.d/email-service
+EMAIL_SERVICE_BOOT_SCRIPT=/etc/rc.d/rc3.d/S70email-service
+EMAIL_SERVICE_FASTBOOT_SCRIPT=/etc/rc.d/rc5.d/S70email-service
+echo '#!/bin/sh' > ${EMAIL_SERVICE_EXEC_SCRIPT}
+echo '/usr/bin/email-service &' >> ${EMAIL_SERVICE_EXEC_SCRIPT} 
+chmod 755 ${EMAIL_SERVICE_EXEC_SCRIPT}
+rm -rf ${EMAIL_SERVICE_BOOT_SCRIPT}
+rm -rf ${EMAIL_SERVICE_FASTBOOT_SCRIPT}
+ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_BOOT_SCRIPT} 
+ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_FASTBOOT_SCRIPT}
+echo "[EMAIL-SERVICE] Finish executing script ..."
 
 #################################################################
 # Create DB file and tables.
 #################################################################
-sqlite3 %{buildroot}/opt/dbspace/.email-service.db 'PRAGMA journal_mode = PERSIST;
+echo "[EMAIL-SERVICE] Creating Email Tables ..."
+sqlite3 /opt/dbspace/.email-service.db 'PRAGMA journal_mode = PERSIST;
 CREATE TABLE mail_account_tbl 
 ( 
-       account_bind_type                INTEGER,
-       account_name                     VARCHAR(51),
-       receiving_server_type            INTEGER,
-       receiving_server_addr            VARCHAR(51),
-       email_addr                       VARCHAR(129),
-       user_name                        VARCHAR(51),
-       password                         VARCHAR(51),
-       retrieval_mode                   INTEGER,
-       port_num                         INTEGER,
-       use_security                     INTEGER,
-       sending_server_type              INTEGER,
-       sending_server_addr              VARCHAR(51),
-       sending_port_num                 INTEGER,
-       sending_auth                     INTEGER,
-       sending_security                 INTEGER,
-       sending_user                     VARCHAR(51),
-       sending_password                 VARCHAR(51),
-       display_name                     VARCHAR(31),
-       reply_to_addr                    VARCHAR(129),
-       return_addr                      VARCHAR(129),
-       account_id                       INTEGER PRIMARY KEY,
-       keep_on_server                   INTEGER,
-       flag1                            INTEGER,
-       flag2                            INTEGER,
-       pop_before_smtp                  INTEGER,
-       apop                             INTEGER,
-       logo_icon_path                   VARCHAR(256),
-       preset_account                   INTEGER,
-       target_storage                   INTEGER,
-       check_interval                   INTEGER,
-       priority                         INTEGER,
-       keep_local_copy                  INTEGER,
-       req_delivery_receipt             INTEGER,
-       req_read_receipt                 INTEGER,
-       download_limit                   INTEGER,
-       block_address                    INTEGER,
-       block_subject                    INTEGER,
-       display_name_from                VARCHAR(256),
-       reply_with_body                  INTEGER,
-       forward_with_files               INTEGER,
-       add_myname_card                  INTEGER,
-       add_signature                    INTEGER,
-       signature                        VARCHAR(256),
-       add_my_address_to_bcc            INTEGER,
-       my_account_id                    INTEGER,
-       index_color                      INTEGER,
-       sync_status                      INTEGER
+       account_id                               INTEGER PRIMARY KEY,
+       account_name                             VARCHAR(51),
+       logo_icon_path                           VARCHAR(256),
+       user_data                                BLOB,
+       user_data_length                         INTEGER,
+       account_svc_id                           INTEGER,
+       sync_status                              INTEGER,
+       sync_disabled                            INTEGER,
+       default_mail_slot_size                   INTEGER,
+       user_display_name                        VARCHAR(31),
+       user_email_address                       VARCHAR(129),
+       reply_to_address                         VARCHAR(129),
+       return_address                           VARCHAR(129),
+       incoming_server_type                     INTEGER,
+       incoming_server_address                  VARCHAR(51),
+       incoming_server_port_number              INTEGER,
+       incoming_server_user_name                VARCHAR(51),
+       incoming_server_password                 VARCHAR(51),
+       incoming_server_secure_connection        INTEGER,
+       retrieval_mode                           INTEGER,
+       keep_mails_on_pop_server_after_download  INTEGER,
+       check_interval                           INTEGER,
+       auto_download_size                       INTEGER,
+       outgoing_server_type                     INTEGER,
+       outgoing_server_address                  VARCHAR(51),
+       outgoing_server_port_number              INTEGER,
+       outgoing_server_user_name                VARCHAR(51),
+       outgoing_server_password                 VARCHAR(51),
+       outgoing_server_secure_connection        INTEGER,
+       outgoing_server_need_authentication      INTEGER,
+       outgoing_server_use_same_authenticator   INTEGER,
+       priority                                 INTEGER,
+       keep_local_copy                          INTEGER,
+       req_delivery_receipt                     INTEGER,
+       req_read_receipt                         INTEGER,
+       download_limit                           INTEGER,
+       block_address                            INTEGER,
+       block_subject                            INTEGER,
+       display_name_from                        VARCHAR(256),
+       reply_with_body                          INTEGER,
+       forward_with_files                       INTEGER,
+       add_myname_card                          INTEGER,
+       add_signature                            INTEGER,
+       signature                                VARCHAR(256),
+       add_my_address_to_bcc                    INTEGER,
+       pop_before_smtp                          INTEGER,
+       incoming_server_requires_apop            INTEGER,
+       smime_type                               INTEGER,
+       certificate_path                         VARCHAR(256),
+       cipher_type                              INTEGER,
+       digest_type                              INTEGER
 );
 
 CREATE TABLE mail_attachment_tbl 
 ( 
-       attachment_id                    INTEGER PRIMARY KEY,
-       attachment_name                  VARCHAR(257),
-       attachment_path                  VARCHAR(257),
-       attachment_size                  INTEGER,
-       mail_id                          INTEGER,
-       account_id                       INTEGER,
-       mailbox_name                     VARCHAR(129),
-       attachment_save_status           INTEGER,
-       attachment_drm_type              INTEGER,
-       attachment_drm_method            INTEGER,
-       attachment_inline_content_status INTEGER,
-       attachment_mime_type             VARCHAR(257)
+       attachment_id                            INTEGER PRIMARY KEY,
+       attachment_name                          VARCHAR(257),
+       attachment_path                          VARCHAR(257),
+       attachment_size                          INTEGER,
+       mail_id                                  INTEGER,
+       account_id                               INTEGER,
+       mailbox_id                               INTEGER,
+       attachment_save_status                   INTEGER,
+       attachment_drm_type                      INTEGER,
+       attachment_drm_method                    INTEGER,
+       attachment_inline_content_status         INTEGER,
+       attachment_mime_type                     VARCHAR(257)
 );
 
 CREATE TABLE mail_box_tbl 
 (    
-       mailbox_id                       INTEGER,
+       mailbox_id                       INTEGER PRIMARY KEY,
        account_id                       INTEGER,
        local_yn                         INTEGER,
        mailbox_name                     VARCHAR(256),    
@@ -176,34 +198,38 @@ CREATE TABLE mail_box_tbl
        modifiable_yn                    INTEGER,    
        total_mail_count_on_server       INTEGER,
        has_archived_mails               INTEGER,    
-       mail_slot_size                   INTEGER
+       mail_slot_size                   INTEGER,
+       last_sync_time                   DATETIME
 );
+
 CREATE TABLE mail_read_mail_uid_tbl          
 (    
        account_id                       INTEGER ,
-       local_mbox                       VARCHAR(129)  ,
+       mailbox_id                       INTEGER ,
        local_uid                        INTEGER ,
-       mailbox_name                     VARCHAR(129)  ,
-       s_uid                            VARCHAR(129)  ,
+       mailbox_name                     VARCHAR(256) ,
+       s_uid                            VARCHAR(129) ,
        data1                            INTEGER ,
-       data2                            VARCHAR(257)  ,
+       data2                            VARCHAR(257) ,
        flag                             INTEGER ,
-       idx_num                          INTEGER  PRIMARY KEY
+       idx_num                          INTEGER PRIMARY KEY
 );
+
 CREATE TABLE mail_rule_tbl          
 (    
        account_id                       INTEGER ,
-       rule_id                          INTEGER  PRIMARY KEY,
+       rule_id                          INTEGER PRIMARY KEY,
        type                             INTEGER ,
        value                            VARCHAR(257)  ,
        action_type                      INTEGER ,
-       dest_mailbox                     VARCHAR(129),
-       flag1                            INTEGER  ,
+       target_mailbox_id                INTEGER ,
+       flag1                            INTEGER ,
        flag2                            INTEGER    
 );
+
 CREATE TABLE mail_tbl
 (
-       mail_id                          INTEGER PRIMARY_KEY,
+       mail_id                          INTEGER PRIMARY KEY,
        account_id                       INTEGER,
        mailbox_id                       INTEGER,
        mailbox_name                     VARCHAR(129),
@@ -227,6 +253,7 @@ CREATE TABLE mail_tbl
        body_download_status             INTEGER,
        file_path_plain                  VARCHAR(257),
        file_path_html                   VARCHAR(257),
+       file_path_mime_entity            VARCHAR(257),
        mail_size                        INTEGER,
        flags_seen_field                 BOOLEAN,
        flags_deleted_field              BOOLEAN,
@@ -246,13 +273,17 @@ CREATE TABLE mail_tbl
        thread_item_count                INTEGER,
        preview_text                     TEXT, 
        meeting_request_status           INTEGER,
+       message_class                    INTEGER,
+       digest_type                      INTEGER,
+       smime_type                       INTEGER,
        FOREIGN KEY(account_id)          REFERENCES mail_account_tbl(account_id)
 );
+
 CREATE TABLE mail_meeting_tbl
 (
        mail_id                          INTEGER PRIMARY KEY,
        account_id                       INTEGER,
-       mailbox_name                     TEXT ,
+       mailbox_id                       INTEGER,
        meeting_response                 INTEGER,
        start_time                       INTEGER,
        end_time                         INTEGER,
@@ -266,6 +297,7 @@ CREATE TABLE mail_meeting_tbl
        daylight_time_start_date         INTEGER,
        daylight_bias                    INTEGER
 );
+
 CREATE TABLE mail_local_activity_tbl  
 (  
        activity_id                      INTEGER,
@@ -277,312 +309,60 @@ CREATE TABLE mail_local_activity_tbl
        dest_mbox                        VARCHAR(129) 
 );
 
+CREATE TABLE mail_certificate_tbl 
+( 
+       certificate_id              INTEGER,
+       issue_year                  INTEGER,
+       issue_month                 INTEGER,
+       issue_day                   INTEGER,
+       expiration_year             INTEGER,
+       expiration_month            INTEGER,
+       expiration_day              INTEGER,
+       issue_organization_name     VARCHAR(256),
+       email_address               VARCHAR(129),
+       subject_str                 VARCHAR(256),
+       filepath                    VARCHAR(256),
+       password                    VARCHAR(51)
+);
+
 
-CREATE UNIQUE INDEX mail_account_idx1 ON mail_account_tbl (account_bind_type, account_id);
+CREATE UNIQUE INDEX mail_account_idx1 ON mail_account_tbl (account_id);
 CREATE UNIQUE INDEX mail_attachment_idx1 ON mail_attachment_tbl (mail_id, attachment_id);
-CREATE UNIQUE INDEX mail_box_idx1 ON mail_box_tbl (account_id, local_yn, mailbox_name);
+CREATE UNIQUE INDEX mail_box_idx1 ON mail_box_tbl (mailbox_id);
 CREATE UNIQUE INDEX mail_idx1 ON mail_tbl (mail_id, account_id);
-CREATE UNIQUE INDEX mail_read_mail_uid_idx1 ON mail_read_mail_uid_tbl (account_id, local_mbox, local_uid, mailbox_name, s_uid);
+CREATE UNIQUE INDEX mail_read_mail_uid_idx1 ON mail_read_mail_uid_tbl (account_id, mailbox_id, local_uid, mailbox_name, s_uid);
 CREATE UNIQUE INDEX mail_meeting_idx1 ON mail_meeting_tbl (mail_id);
 CREATE INDEX mail_idx_date_time ON mail_tbl (date_time);
 CREATE INDEX mail_idx_thread_item_count ON mail_tbl (thread_item_count);
 '
 
-%preun
-if [ $1 == 0]; then
-    systemctl stop email.service
-fi
+echo "[EMAIL-SERVICE] Finish Creating Email Tables."
 
-%post
-/sbin/ldconfig
-systemctl daemon-reload
-if [ $1 == 1 ]; then
-    systemctl restart email.service
-fi
 
 #################################################################
-# Add preset account information
+# Change file permission
 #################################################################
-echo "[EMAIL-SERVICE] Start adding preset account information..." 
-
-#################################################################
-# Email Settings
-#################################################################
-
-#if [ ${USER} = "root" ]
-#then
-
-       ## Setting
-       # Sending
-       vconftool set -g 5000 -t bool   db/Services/Email/Sending/KeepCopy                      "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/Sending/SendMeCopy            "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/Sending/ReqDeliveryRep        "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/Sending/ReqReadRep            "0"
-       vconftool set -g 5000 -t int    db/Services/Email/Sending/Priority                      "1"
-       vconftool set -g 5000 -t string db/Services/Email/Sending/ActiveAccount         ""
-       vconftool set -g 5000 -t bool   db/Services/Email/Sending/IncBodyReply          "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/Sending/IncAttachFwd          "1"
-       # Receiving
-       vconftool set -g 5000 -t int    db/Services/Email/Receiving/AutoPoll            "0"
-       vconftool set -g 5000 -t int    db/Services/Email/Receiving/PollTime            "0"
-       vconftool set -g 5000 -t int    db/Services/Email/Receiving/SendReadRep         "2"
-       vconftool set -g 5000 -t int    db/Services/Email/Receiving/Reclimit            "0"
-       vconftool set -g 5000 -t int    db/Services/Email/Receiving/FetchOption         "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/Receiving/KeepServer          "1"
-       vconftool set -g 5000 -t int    db/Services/Email/Receiving/ServDelOption       "1"
-
-       vconftool set -g 5000 -t int    db/Services/Email/NbAccount                     "6"
-
-       ## Accounts
-
-       # Gmail
-       vconftool set -g 5000 -t string db/Services/Email/1/General/NetworkName         "default"
-       vconftool set -g 5000 -t string db/Services/Email/1/General/AccountName         "Gmail"
-       vconftool set -g 5000 -t string db/Services/Email/1/General/EmailAddr           ""
-       vconftool set -g 5000 -t string db/Services/Email/1/General/UserId                      ""
-       vconftool set -g 5000 -t string db/Services/Email/1/General/Password            ""
-       vconftool set -g 5000 -t string db/Services/Email/1/General/LoginType           "username_type"
-
-       # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
-       vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/MailboxType        "1"
-       vconftool set -g 5000 -t string db/Services/Email/1/Incoming/ServAddr       "imap.gmail.com"
-       vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/Port           "993"
-       vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/Secure         "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/1/Incoming/Apop                       "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/1/Incoming/AutoEmailSync      "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/1/Incoming/IncludeAttach      "0"
-       vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/ImapFetchOpt       "1"
-
-       vconftool set -g 5000 -t string db/Services/Email/1/Outgoing/ServAddr           "smtp.gmail.com"
-       vconftool set -g 5000 -t int    db/Services/Email/1/Outgoing/Port                       "465"
-       vconftool set -g 5000 -t bool   db/Services/Email/1/Outgoing/SmtpAuth           "0"
-       vconftool set -g 5000 -t int    db/Services/Email/1/Outgoing/Secure                     "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/1/Outgoing/SameIdPwd          "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/1/Outgoing/PopBeforeSmtp      "0"
-
-       # Hotmail
-       vconftool set -g 5000 -t string db/Services/Email/2/General/NetworkName         "default"
-       vconftool set -g 5000 -t string db/Services/Email/2/General/AccountName         "Hotmail"
-       vconftool set -g 5000 -t string db/Services/Email/2/General/EmailAddr           ""
-       vconftool set -g 5000 -t string db/Services/Email/2/General/UserId                      ""
-       vconftool set -g 5000 -t string db/Services/Email/2/General/Password            ""
-       vconftool set -g 5000 -t string db/Services/Email/2/General/LoginType           "username_type"
-
-       # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
-       vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/MailboxType        "0"
-       vconftool set -g 5000 -t string db/Services/Email/2/Incoming/ServAddr       "pop3.live.com"
-       vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/Port           "995"
-       vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/Secure         "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/2/Incoming/Apop                       "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/2/Incoming/AutoEmailSync      "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/2/Incoming/IncludeAttach      "0"
-       vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/ImapFetchOpt       "1"
-
-       vconftool set -g 5000 -t string db/Services/Email/2/Outgoing/ServAddr           "smtp.live.com"
-       vconftool set -g 5000 -t int    db/Services/Email/2/Outgoing/Port                       "587"
-       vconftool set -g 5000 -t bool   db/Services/Email/2/Outgoing/SmtpAuth           "0"
-       vconftool set -g 5000 -t int    db/Services/Email/2/Outgoing/Secure                     "2"
-       vconftool set -g 5000 -t bool   db/Services/Email/2/Outgoing/SameIdPwd          "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/2/Outgoing/PopBeforeSmtp      "0"
-
-       # AOL
-       vconftool set -g 5000 -t string db/Services/Email/3/General/NetworkName         "default"
-       vconftool set -g 5000 -t string db/Services/Email/3/General/AccountName         "AOL"
-       vconftool set -g 5000 -t string db/Services/Email/3/General/EmailAddr           ""
-       vconftool set -g 5000 -t string db/Services/Email/3/General/UserId                      ""
-       vconftool set -g 5000 -t string db/Services/Email/3/General/Password            ""
-       vconftool set -g 5000 -t string db/Services/Email/3/General/LoginType           "username_type"
-
-       # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
-       vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/MailboxType        "1"
-       vconftool set -g 5000 -t string db/Services/Email/3/Incoming/ServAddr       "imap.aol.com"
-       vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/Port           "143"
-       vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/Secure         "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/3/Incoming/Apop                       "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/3/Incoming/AutoEmailSync      "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/3/Incoming/IncludeAttach      "0"
-       vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/ImapFetchOpt       "0"
-
-       vconftool set -g 5000 -t string db/Services/Email/3/Outgoing/ServAddr           "smtp.aol.com"
-       vconftool set -g 5000 -t int    db/Services/Email/3/Outgoing/Port                       "587"
-       vconftool set -g 5000 -t bool   db/Services/Email/3/Outgoing/SmtpAuth           "0"
-       vconftool set -g 5000 -t int    db/Services/Email/3/Outgoing/Secure                     "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/3/Outgoing/SameIdPwd          "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/3/Outgoing/PopBeforeSmtp      "0"
-
-       # Samsung 3G for test
-       vconftool set -g 5000 -t string db/Services/Email/4/General/NetworkName         "default"
-       vconftool set -g 5000 -t string db/Services/Email/4/General/AccountName         "Samsung 3G"
-       vconftool set -g 5000 -t string db/Services/Email/4/General/EmailAddr           ""
-       vconftool set -g 5000 -t string db/Services/Email/4/General/UserId                      ""
-       vconftool set -g 5000 -t string db/Services/Email/4/General/Password            ""
-       vconftool set -g 5000 -t string db/Services/Email/4/General/LoginType           "username_type"
-
-       # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
-       vconftool set -g 5000 -t int    db/Services/Email/4/Incoming/MailboxType        "0"
-       vconftool set -g 5000 -t string db/Services/Email/4/Incoming/ServAddr       "165.213.73.235"
-       vconftool set -g 5000 -t int    db/Services/Email/4/Incoming/Port           "995"
-       vconftool set -g 5000 -t int    db/Services/Email/4/Incoming/Secure         "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/4/Incoming/Apop                       "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/4/Incoming/AutoEmailSync      "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/4/Incoming/IncludeAttach      "0"
-       vconftool set -g 5000 -t int    db/Services/Email/4/Incoming/ImapFetchOpt       "1"
-
-       vconftool set -g 5000 -t string db/Services/Email/4/Outgoing/ServAddr           "165.213.73.235"
-       vconftool set -g 5000 -t int    db/Services/Email/4/Outgoing/Port                       "465"
-       vconftool set -g 5000 -t bool   db/Services/Email/4/Outgoing/SmtpAuth           "0"
-       vconftool set -g 5000 -t int    db/Services/Email/4/Outgoing/Secure                     "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/4/Outgoing/SameIdPwd          "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/4/Outgoing/PopBeforeSmtp      "0"
-
-       # Samsung Imap for test
-       vconftool set -g 5000 -t string db/Services/Email/5/General/NetworkName         "default"
-       vconftool set -g 5000 -t string db/Services/Email/5/General/AccountName         "Samsung Imap"
-       vconftool set -g 5000 -t string db/Services/Email/5/General/EmailAddr           ""
-       vconftool set -g 5000 -t string db/Services/Email/5/General/UserId                      ""
-       vconftool set -g 5000 -t string db/Services/Email/5/General/Password            ""
-       vconftool set -g 5000 -t string db/Services/Email/5/General/LoginType           "username_type"
-
-       # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
-       vconftool set -g 5000 -t int    db/Services/Email/5/Incoming/MailboxType        "1"
-       vconftool set -g 5000 -t string db/Services/Email/5/Incoming/ServAddr       "165.213.73.235"
-       vconftool set -g 5000 -t int    db/Services/Email/5/Incoming/Port           "993"
-       vconftool set -g 5000 -t int    db/Services/Email/5/Incoming/Secure         "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/5/Incoming/Apop                       "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/5/Incoming/AutoEmailSync      "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/5/Incoming/IncludeAttach      "0"
-       vconftool set -g 5000 -t int    db/Services/Email/5/Incoming/ImapFetchOpt       "1"
-
-       vconftool set -g 5000 -t string db/Services/Email/5/Outgoing/ServAddr           "165.213.73.235"
-       vconftool set -g 5000 -t int    db/Services/Email/5/Outgoing/Port                       "465"
-       vconftool set -g 5000 -t bool   db/Services/Email/5/Outgoing/SmtpAuth           "0"
-       vconftool set -g 5000 -t int    db/Services/Email/5/Outgoing/Secure                     "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/5/Outgoing/SameIdPwd          "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/5/Outgoing/PopBeforeSmtp      "0"
-
-
-       # Yahoo
-       vconftool set -g 5000 -t string db/Services/Email/6/General/NetworkName         "default"
-       vconftool set -g 5000 -t string db/Services/Email/6/General/AccountName         "Yahoomail"
-       vconftool set -g 5000 -t string db/Services/Email/6/General/EmailAddr           ""
-       vconftool set -g 5000 -t string db/Services/Email/6/General/UserId                      ""
-       vconftool set -g 5000 -t string db/Services/Email/6/General/Password            ""
-       vconftool set -g 5000 -t string db/Services/Email/6/General/LoginType           "username_type"
-
-       # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
-       vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/MailboxType        "0"
-       vconftool set -g 5000 -t string db/Services/Email/6/Incoming/ServAddr       "pop.mail.yahoo.co.kr"
-       vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/Port           "995"
-       vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/Secure         "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/6/Incoming/Apop                       "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/6/Incoming/AutoEmailSync      "0"
-       vconftool set -g 5000 -t bool   db/Services/Email/6/Incoming/IncludeAttach      "0"
-       vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/ImapFetchOpt       "1"
-
-       vconftool set -g 5000 -t string db/Services/Email/6/Outgoing/ServAddr           "smtp.mail.yahoo.co.kr"
-       vconftool set -g 5000 -t int    db/Services/Email/6/Outgoing/Port                       "465"
-       vconftool set -g 5000 -t bool   db/Services/Email/6/Outgoing/SmtpAuth           "0"
-       vconftool set -g 5000 -t int    db/Services/Email/6/Outgoing/Secure                     "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/6/Outgoing/SameIdPwd          "1"
-       vconftool set -g 5000 -t bool   db/Services/Email/6/Outgoing/PopBeforeSmtp      "0"
-
-#fi
+#echo "[EMAIL-SERVICE] Start setting permission ..."
+# 1. libraries
 
+# 2. executables
 
-################################################################################################
-
-#if [ ${USER} = "root" ]
-#then
-
-vconftool set -t string db/email/preset_account/aol/sending_address   "smtp.aol.com"
-vconftool set -t int    db/email/preset_account/aol/sending_port      "587"
-vconftool set -t int    db/email/preset_account/aol/sending_ssl       "0"
-vconftool set -t int    db/email/preset_account/aol/receiving_type    "2"
-vconftool set -t string db/email/preset_account/aol/receiving_address "imap.aol.com"
-vconftool set -t int    db/email/preset_account/aol/receiving_port    "143"
-vconftool set -t int    db/email/preset_account/aol/receiving_ssl     "0"
-
-vconftool set -t string db/email/preset_account/gmail/sending_address   "smtp.gmail.com"
-vconftool set -t int    db/email/preset_account/gmail/sending_port      "465"
-vconftool set -t int    db/email/preset_account/gmail/sending_ssl       "1"
-vconftool set -t int    db/email/preset_account/gmail/receiving_type    "2"
-# for POP3 server
-#vconftool set -t string db/email/preset_account/gmail/receiving_address "pop.gmail.com"
-#vconftool set -t int    db/email/preset_account/gmail/receiving_port    "995"
-# for IMAP4 server
-vconftool set -t string db/email/preset_account/gmail/receiving_address "imap.gmail.com"
-vconftool set -t int    db/email/preset_account/gmail/receiving_port    "993"
-vconftool set -t int    db/email/preset_account/gmail/receiving_ssl     "1"
-
-vconftool set -t string db/email/preset_account/yahoo/sending_address   "smtp.mail.yahoo.co.kr"
-vconftool set -t int    db/email/preset_account/yahoo/sending_port      "465"
-vconftool set -t int    db/email/preset_account/yahoo/sending_ssl       "1"
-vconftool set -t int    db/email/preset_account/yahoo/receiving_type    "1"
-vconftool set -t string db/email/preset_account/yahoo/receiving_address "pop.mail.yahoo.co.kr"
-vconftool set -t int    db/email/preset_account/yahoo/receiving_port    "995"
-vconftool set -t int    db/email/preset_account/yahoo/receiving_ssl     "1"
-
-vconftool set -t string db/email/preset_account/hotmail/sending_address   "smtp.live.com"
-vconftool set -t int    db/email/preset_account/hotmail/sending_port      "587"
-vconftool set -t int    db/email/preset_account/hotmail/sending_ssl       "2"
-vconftool set -t int    db/email/preset_account/hotmail/receiving_type    "1"
-vconftool set -t string db/email/preset_account/hotmail/receiving_address "pop3.live.com"
-vconftool set -t int    db/email/preset_account/hotmail/receiving_port    "995"
-vconftool set -t int    db/email/preset_account/hotmail/receiving_ssl     "1"
-
-vconftool set -t string db/email/preset_account/samsung_pop3/sending_address   "165.213.73.235"
-vconftool set -t int    db/email/preset_account/samsung_pop3/sending_port      "465"
-vconftool set -t int    db/email/preset_account/samsung_pop3/sending_ssl       "1"
-vconftool set -t int    db/email/preset_account/samsung_pop3/receiving_type    "1"
-vconftool set -t string db/email/preset_account/samsung_pop3/receiving_address "165.213.73.235"
-vconftool set -t int    db/email/preset_account/samsung_pop3/receiving_port    "995"
-vconftool set -t int    db/email/preset_account/samsung_pop3/receiving_ssl     "1"
-
-vconftool set -t string db/email/preset_account/samsung_imap4/sending_address   "165.213.73.235"
-vconftool set -t int    db/email/preset_account/samsung_imap4/sending_port      "465"
-vconftool set -t int    db/email/preset_account/samsung_imap4/sending_ssl       "1"
-vconftool set -t int    db/email/preset_account/samsung_imap4/receiving_type    "2"
-vconftool set -t string db/email/preset_account/samsung_imap4/receiving_address "165.213.73.235"
-vconftool set -t int    db/email/preset_account/samsung_imap4/receiving_port    "993"
-vconftool set -t int    db/email/preset_account/samsung_imap4/receiving_ssl     "1"
-
-# for Active Sync      - Let email app create this key
-#vconftool set -t int    db/email_handle/active_sync_handle     "0"
-
-# for contact sync - sync from the first contact change
-vconftool set -t int    db/email/last_sync_time "0"
-
-# for contact sync - sync from the first contact change
-vconftool set -t int    db/email/slot_size "100"
-
-# for badge
-vconftool set -t int   db/badge/com.samsung.email "0"
-
-#fi
-
-echo "[EMAIL-SERVICE] Finish adding preset account information"
-
-
-
-%postun
-/sbin/ldconfig
-systemctl daemon-reload
+# 3. DB files
+chmod 644 /opt/dbspace/.email-service.db                                   
+chmod 644 /opt/dbspace/.email-service.db-journal       
 
+%postun -p /sbin/ldconfig
 
 %files
-%manifest email-service.manifest
-%attr(0755,root,root) %{_sysconfdir}/rc.d/init.d/email-service
-%{_sysconfdir}/rc.d/rc3.d/S70email-service
-%{_sysconfdir}/rc.d/rc5.d/S70email-service
-%config(noreplace) %attr(0644,root,root) /opt/dbspace/.email-service.db
-%config(noreplace) %attr(0644,root,root) /opt/dbspace/.email-service.db-journal
-%{_bindir}/email-service
+%exclude /usr/bin/email-test-app
 %{_libdir}/lib*.so.*
-%{_libdir}/systemd/user/email.service
-%{_libdir}/systemd/user/tizen-middleware.target.wants/email.service
+%{_bindir}/email-service
+/opt/data/email/res/*
+
 
 %files devel
-%manifest email-service.manifest
 %{_includedir}/email-service/*.h
 %{_libdir}/lib*.so
 %{_libdir}/pkgconfig/*.pc
+
+