packaging/email-service.spec

   1 Name:       email-service
   2 Summary:    E-mail Framework Middleware package
   3 Version:    0.3.6
   4 Release:    3
   5 Group:      System/Services
   6 License:    Apache-2.0
   7 Source0:    %{name}-%{version}.tar.gz
   8 Requires(post):    /sbin/ldconfig
   9 Requires(post):    /usr/bin/sqlite3
  10 Requires(post):    /usr/bin/vconftool
  11 Requires(postun):  /sbin/ldconfig
  12 BuildRequires:  cmake
  13 BuildRequires:  gettext-tools
  14 BuildRequires:  pkgconfig(glib-2.0)
  15 BuildRequires:  pkgconfig(gthread-2.0)
  16 BuildRequires:  pkgconfig(aul)
  17 BuildRequires:  pkgconfig(vconf)
  18 BuildRequires:  pkgconfig(heynoti)
  19 BuildRequires:  pkgconfig(dlog)
  20 BuildRequires:  pkgconfig(db-util)
  21 BuildRequires:  pkgconfig(dbus-1)
  22 BuildRequires:  pkgconfig(dbus-glib-1)
  23 BuildRequires:  pkgconfig(contacts-service)
  24 BuildRequires:  pkgconfig(uw-imap-toolkit)
  25 BuildRequires:  pkgconfig(drm-service)
  26 BuildRequires:  pkgconfig(openssl)
  27 BuildRequires:  pkgconfig(alarm-service)
  28 BuildRequires:  pkgconfig(mm-player)
  29 BuildRequires:  pkgconfig(devman_haptic)
  30 BuildRequires:  pkgconfig(secure-storage)
  31 BuildRequires:  pkgconfig(notification)
  32 BuildRequires:  pkgconfig(accounts-svc)
  33 BuildRequires:  pkgconfig(libcurl)
  34 BuildRequires:  pkgconfig(gconf-2.0)
  35 BuildRequires:  pkgconfig(mm-session)
  36 BuildRequires:  pkgconfig(capi-base-common)
  37
  38
  39
  40 %description
  41 E-mail Framework Middleware Library/Binary package
  42
  43
  44 %package devel
  45 Summary:    E-mail Framework Middleware Development package
  46 Group:      Development/Libraries
  47 Requires:   %{name} = %{version}-%{release}
  48
  49 %description devel
  50 E-mail Framework Middleware Development package
  51
  52
  53 %package tools
  54 Summary:    Tools for use with email-service
  55 Group:      Development/Libraries
  56 Requires:   %{name} = %{version}-%{release}
  57
  58 %description tools
  59 Tools for use with email-service
  60
  61
  62 %prep
  63 %setup -q
  64
  65 %build
  66
  67 export CFLAGS="${CFLAGS} -fPIC -Wall -g -fvisibility=hidden"
  68 export CXXFLAGS="${CXXFLAGS} -fPIC -Wall -g -fvisibility=hidden"
  69 export LDFLAGS="${LDFLAGS} -Wl,--hash-style=both -Wl,--rpath=%{_prefix}/lib -Wl,--as-needed"
  70
  71 cmake . -DCMAKE_INSTALL_PREFIX=%{_prefix}
  72
  73 # Call make instruction with smp support
  74 #make %{?jobs:-j%jobs}
  75 make
  76
  77 %install
  78 %make_install
  79
  80 %post
  81 /sbin/ldconfig
  82
  83 #################################################################
  84 # Add preset account information
  85 #################################################################
  86 echo "[EMAIL-SERVICE] Start adding preset account information..."
  87
  88 #################################################################
  89 # Email Settings
  90 #################################################################
  91
  92 ## Setting
  93 # Sending
  94 vconftool set -g 5000 -t bool   db/Services/Email/Sending/KeepCopy                      "1"
  95 vconftool set -g 5000 -t bool   db/Services/Email/Sending/SendMeCopy            "1"
  96 vconftool set -g 5000 -t bool   db/Services/Email/Sending/ReqDeliveryRep        "0"
  97 vconftool set -g 5000 -t bool   db/Services/Email/Sending/ReqReadRep            "0"
  98 vconftool set -g 5000 -t int    db/Services/Email/Sending/Priority                      "1"
  99 vconftool set -g 5000 -t string db/Services/Email/Sending/ActiveAccount         ""
 100 vconftool set -g 5000 -t bool   db/Services/Email/Sending/IncBodyReply          "1"
 101 vconftool set -g 5000 -t bool   db/Services/Email/Sending/IncAttachFwd          "1"
 102 # Receiving
 103 vconftool set -g 5000 -t int    db/Services/Email/Receiving/AutoPoll            "0"
 104 vconftool set -g 5000 -t int    db/Services/Email/Receiving/PollTime            "0"
 105 vconftool set -g 5000 -t int    db/Services/Email/Receiving/SendReadRep         "2"
 106 vconftool set -g 5000 -t int    db/Services/Email/Receiving/Reclimit            "0"
 107 vconftool set -g 5000 -t int    db/Services/Email/Receiving/FetchOption         "0"
 108 vconftool set -g 5000 -t bool   db/Services/Email/Receiving/KeepServer          "1"
 109 vconftool set -g 5000 -t int    db/Services/Email/Receiving/ServDelOption       "1"
 110
 111 vconftool set -g 5000 -t int    db/Services/Email/NbAccount                     "6"
 112
 113 ## Accounts
 114
 115 # Gmail
 116 vconftool set -g 5000 -t string db/Services/Email/1/General/NetworkName         "default"
 117 vconftool set -g 5000 -t string db/Services/Email/1/General/AccountName         "Gmail"
 118 vconftool set -g 5000 -t string db/Services/Email/1/General/EmailAddr           ""
 119 vconftool set -g 5000 -t string db/Services/Email/1/General/UserId                      ""
 120 vconftool set -g 5000 -t string db/Services/Email/1/General/Password            ""
 121 vconftool set -g 5000 -t string db/Services/Email/1/General/LoginType           "username_type"
 122
 123 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
 124 vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/MailboxType        "1"
 125 vconftool set -g 5000 -t string db/Services/Email/1/Incoming/ServAddr       "imap.gmail.com"
 126 vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/Port           "993"
 127 vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/Secure         "1"
 128 vconftool set -g 5000 -t bool   db/Services/Email/1/Incoming/Apop                       "0"
 129 vconftool set -g 5000 -t bool   db/Services/Email/1/Incoming/AutoEmailSync      "0"
 130 vconftool set -g 5000 -t bool   db/Services/Email/1/Incoming/IncludeAttach      "0"
 131 vconftool set -g 5000 -t int    db/Services/Email/1/Incoming/ImapFetchOpt       "1"
 132
 133 vconftool set -g 5000 -t string db/Services/Email/1/Outgoing/ServAddr           "smtp.gmail.com"
 134 vconftool set -g 5000 -t int    db/Services/Email/1/Outgoing/Port                       "465"
 135 vconftool set -g 5000 -t bool   db/Services/Email/1/Outgoing/SmtpAuth           "0"
 136 vconftool set -g 5000 -t int    db/Services/Email/1/Outgoing/Secure                     "1"
 137 vconftool set -g 5000 -t bool   db/Services/Email/1/Outgoing/SameIdPwd          "1"
 138 vconftool set -g 5000 -t bool   db/Services/Email/1/Outgoing/PopBeforeSmtp      "0"
 139
 140 # Hotmail
 141 vconftool set -g 5000 -t string db/Services/Email/2/General/NetworkName         "default"
 142 vconftool set -g 5000 -t string db/Services/Email/2/General/AccountName         "Hotmail"
 143 vconftool set -g 5000 -t string db/Services/Email/2/General/EmailAddr           ""
 144 vconftool set -g 5000 -t string db/Services/Email/2/General/UserId                      ""
 145 vconftool set -g 5000 -t string db/Services/Email/2/General/Password            ""
 146 vconftool set -g 5000 -t string db/Services/Email/2/General/LoginType           "username_type"
 147
 148 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
 149 vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/MailboxType        "0"
 150 vconftool set -g 5000 -t string db/Services/Email/2/Incoming/ServAddr       "pop3.live.com"
 151 vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/Port           "995"
 152 vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/Secure         "1"
 153 vconftool set -g 5000 -t bool   db/Services/Email/2/Incoming/Apop                       "0"
 154 vconftool set -g 5000 -t bool   db/Services/Email/2/Incoming/AutoEmailSync      "0"
 155 vconftool set -g 5000 -t bool   db/Services/Email/2/Incoming/IncludeAttach      "0"
 156 vconftool set -g 5000 -t int    db/Services/Email/2/Incoming/ImapFetchOpt       "1"
 157
 158 vconftool set -g 5000 -t string db/Services/Email/2/Outgoing/ServAddr           "smtp.live.com"
 159 vconftool set -g 5000 -t int    db/Services/Email/2/Outgoing/Port                       "587"
 160 vconftool set -g 5000 -t bool   db/Services/Email/2/Outgoing/SmtpAuth           "0"
 161 vconftool set -g 5000 -t int    db/Services/Email/2/Outgoing/Secure                     "2"
 162 vconftool set -g 5000 -t bool   db/Services/Email/2/Outgoing/SameIdPwd          "1"
 163 vconftool set -g 5000 -t bool   db/Services/Email/2/Outgoing/PopBeforeSmtp      "0"
 164
 165 # AOL
 166 vconftool set -g 5000 -t string db/Services/Email/3/General/NetworkName         "default"
 167 vconftool set -g 5000 -t string db/Services/Email/3/General/AccountName         "AOL"
 168 vconftool set -g 5000 -t string db/Services/Email/3/General/EmailAddr           ""
 169 vconftool set -g 5000 -t string db/Services/Email/3/General/UserId                      ""
 170 vconftool set -g 5000 -t string db/Services/Email/3/General/Password            ""
 171 vconftool set -g 5000 -t string db/Services/Email/3/General/LoginType           "username_type"
 172
 173 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
 174 vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/MailboxType        "1"
 175 vconftool set -g 5000 -t string db/Services/Email/3/Incoming/ServAddr       "imap.aol.com"
 176 vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/Port           "143"
 177 vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/Secure         "0"
 178 vconftool set -g 5000 -t bool   db/Services/Email/3/Incoming/Apop                       "0"
 179 vconftool set -g 5000 -t bool   db/Services/Email/3/Incoming/AutoEmailSync      "0"
 180 vconftool set -g 5000 -t bool   db/Services/Email/3/Incoming/IncludeAttach      "0"
 181 vconftool set -g 5000 -t int    db/Services/Email/3/Incoming/ImapFetchOpt       "0"
 182
 183 vconftool set -g 5000 -t string db/Services/Email/3/Outgoing/ServAddr           "smtp.aol.com"
 184 vconftool set -g 5000 -t int    db/Services/Email/3/Outgoing/Port                       "587"
 185 vconftool set -g 5000 -t bool   db/Services/Email/3/Outgoing/SmtpAuth           "0"
 186 vconftool set -g 5000 -t int    db/Services/Email/3/Outgoing/Secure                     "0"
 187 vconftool set -g 5000 -t bool   db/Services/Email/3/Outgoing/SameIdPwd          "1"
 188 vconftool set -g 5000 -t bool   db/Services/Email/3/Outgoing/PopBeforeSmtp      "0"
 189
 190 # Yahoo
 191 vconftool set -g 5000 -t string db/Services/Email/6/General/NetworkName         "default"
 192 vconftool set -g 5000 -t string db/Services/Email/6/General/AccountName         "Yahoomail"
 193 vconftool set -g 5000 -t string db/Services/Email/6/General/EmailAddr           ""
 194 vconftool set -g 5000 -t string db/Services/Email/6/General/UserId                      ""
 195 vconftool set -g 5000 -t string db/Services/Email/6/General/Password            ""
 196 vconftool set -g 5000 -t string db/Services/Email/6/General/LoginType           "username_type"
 197
 198 # MailboxType : pop3(0), imap4(1) -> pop3(1), imap4(2) in email-service
 199 vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/MailboxType        "0"
 200 vconftool set -g 5000 -t string db/Services/Email/6/Incoming/ServAddr       "pop.mail.yahoo.co.kr"
 201 vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/Port           "995"
 202 vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/Secure         "1"
 203 vconftool set -g 5000 -t bool   db/Services/Email/6/Incoming/Apop                       "0"
 204 vconftool set -g 5000 -t bool   db/Services/Email/6/Incoming/AutoEmailSync      "0"
 205 vconftool set -g 5000 -t bool   db/Services/Email/6/Incoming/IncludeAttach      "0"
 206 vconftool set -g 5000 -t int    db/Services/Email/6/Incoming/ImapFetchOpt       "1"
 207
 208 vconftool set -g 5000 -t string db/Services/Email/6/Outgoing/ServAddr           "smtp.mail.yahoo.co.kr"
 209 vconftool set -g 5000 -t int    db/Services/Email/6/Outgoing/Port                       "465"
 210 vconftool set -g 5000 -t bool   db/Services/Email/6/Outgoing/SmtpAuth           "0"
 211 vconftool set -g 5000 -t int    db/Services/Email/6/Outgoing/Secure                     "1"
 212 vconftool set -g 5000 -t bool   db/Services/Email/6/Outgoing/SameIdPwd          "1"
 213 vconftool set -g 5000 -t bool   db/Services/Email/6/Outgoing/PopBeforeSmtp      "0"
 214
 215 vconftool set -t string db/email/preset_account/aol/sending_address   "smtp.aol.com"
 216 vconftool set -t int    db/email/preset_account/aol/sending_port      "587"
 217 vconftool set -t int    db/email/preset_account/aol/sending_ssl       "0"
 218 vconftool set -t int    db/email/preset_account/aol/receiving_type    "2"
 219 vconftool set -t string db/email/preset_account/aol/receiving_address "imap.aol.com"
 220 vconftool set -t int    db/email/preset_account/aol/receiving_port    "143"
 221 vconftool set -t int    db/email/preset_account/aol/receiving_ssl     "0"
 222
 223 vconftool set -t string db/email/preset_account/gmail/sending_address   "smtp.gmail.com"
 224 vconftool set -t int    db/email/preset_account/gmail/sending_port      "465"
 225 vconftool set -t int    db/email/preset_account/gmail/sending_ssl       "1"
 226 vconftool set -t int    db/email/preset_account/gmail/receiving_type    "2"
 227 # for POP3 server
 228 #vconftool set -t string db/email/preset_account/gmail/receiving_address "pop.gmail.com"
 229 #vconftool set -t int    db/email/preset_account/gmail/receiving_port    "995"
 230 # for IMAP4 server
 231 vconftool set -t string db/email/preset_account/gmail/receiving_address "imap.gmail.com"
 232 vconftool set -t int    db/email/preset_account/gmail/receiving_port    "993"
 233 vconftool set -t int    db/email/preset_account/gmail/receiving_ssl     "1"
 234
 235 vconftool set -t string db/email/preset_account/yahoo/sending_address   "smtp.mail.yahoo.co.kr"
 236 vconftool set -t int    db/email/preset_account/yahoo/sending_port      "465"
 237 vconftool set -t int    db/email/preset_account/yahoo/sending_ssl       "1"
 238 vconftool set -t int    db/email/preset_account/yahoo/receiving_type    "1"
 239 vconftool set -t string db/email/preset_account/yahoo/receiving_address "pop.mail.yahoo.co.kr"
 240 vconftool set -t int    db/email/preset_account/yahoo/receiving_port    "995"
 241 vconftool set -t int    db/email/preset_account/yahoo/receiving_ssl     "1"
 242
 243 vconftool set -t string db/email/preset_account/hotmail/sending_address   "smtp.live.com"
 244 vconftool set -t int    db/email/preset_account/hotmail/sending_port      "587"
 245 vconftool set -t int    db/email/preset_account/hotmail/sending_ssl       "2"
 246 vconftool set -t int    db/email/preset_account/hotmail/receiving_type    "1"
 247 vconftool set -t string db/email/preset_account/hotmail/receiving_address "pop3.live.com"
 248 vconftool set -t int    db/email/preset_account/hotmail/receiving_port    "995"
 249 vconftool set -t int    db/email/preset_account/hotmail/receiving_ssl     "1"
 250
 251 # for Active Sync       - Let email app create this key
 252 #vconftool set -t int    db/email_handle/active_sync_handle     "0"
 253
 254 # for contact sync - sync from the first contact change
 255 vconftool set -t int    db/email/last_sync_time "0"
 256
 257 # for contact sync - sync from the first contact change
 258 vconftool set -t int    db/email/slot_size "100"
 259
 260 # for badge
 261 vconftool set -t int    db/badge/org.tizen.email "0"
 262
 263
 264 echo "[EMAIL-SERVICE] Finish adding preset account information"
 265
 266
 267 #################################################################
 268 # Set executin script
 269 #################################################################
 270 echo "[EMAIL-SERVICE] Set executing script ..."
 271 EMAIL_SERVICE_EXEC_SCRIPT=/etc/rc.d/init.d/email-service
 272 EMAIL_SERVICE_BOOT_SCRIPT=/etc/rc.d/rc3.d/S70email-service
 273 EMAIL_SERVICE_FASTBOOT_SCRIPT=/etc/rc.d/rc5.d/S70email-service
 274 echo '#!/bin/sh' > ${EMAIL_SERVICE_EXEC_SCRIPT}
 275 echo '/usr/bin/email-service &' >> ${EMAIL_SERVICE_EXEC_SCRIPT}
 276 chmod 755 ${EMAIL_SERVICE_EXEC_SCRIPT}
 277 rm -rf ${EMAIL_SERVICE_BOOT_SCRIPT}
 278 rm -rf ${EMAIL_SERVICE_FASTBOOT_SCRIPT}
 279 ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_BOOT_SCRIPT}
 280 ln -s ${EMAIL_SERVICE_EXEC_SCRIPT} ${EMAIL_SERVICE_FASTBOOT_SCRIPT}
 281 echo "[EMAIL-SERVICE] Finish executing script ..."
 282
 283 #################################################################
 284 # Create DB file and tables.
 285 #################################################################
 286 echo "[EMAIL-SERVICE] Creating Email Tables ..."
 287 sqlite3 /opt/dbspace/.email-service.db 'PRAGMA journal_mode = PERSIST;
 288 CREATE TABLE mail_account_tbl
 289 (
 290         account_bind_type INTEGER,
 291         account_name varchar(51),
 292         receiving_server_type INTEGER,
 293         receiving_server_addr varchar(51),
 294         email_addr varchar(129),
 295         user_name varchar(51),
 296         password varchar(51),
 297         retrieval_mode INTEGER,
 298         port_num INTEGER,
 299         use_security INTEGER,
 300         sending_server_type INTEGER,
 301         sending_server_addr varchar(51),
 302         sending_port_num INTEGER,
 303         sending_auth INTEGER,
 304         sending_security INTEGER,
 305         sending_user varchar(51),
 306         sending_password varchar(51),
 307         display_name varchar(31),
 308         reply_to_addr varchar(129),
 309         return_addr varchar(129),
 310         account_id INTEGER,
 311         keep_on_server INTEGER,
 312         flag1 INTEGER,
 313         flag2 INTEGER,
 314         pop_before_smtp INTEGER,
 315         apop INTEGER,
 316         logo_icon_path varchar(256),
 317         preset_account INTEGER,
 318         target_storage INTEGER,
 319         check_interval INTEGER,
 320         priority INTEGER,
 321         keep_local_copy INTEGER,
 322         req_delivery_receipt INTEGER,
 323         req_read_receipt INTEGER,
 324         download_limit INTEGER,
 325         block_address INTEGER,
 326         block_subject INTEGER,
 327         display_name_from varchar(256),
 328         reply_with_body INTEGER,
 329         forward_with_files INTEGER,
 330         add_myname_card INTEGER,
 331         add_signature INTEGER,
 332         signature varchar(256),
 333         add_my_address_to_bcc INTEGER,
 334         my_account_id INTEGER,
 335         index_color INTEGER
 336 );
 337
 338 CREATE TABLE mail_attachment_tbl
 339 (
 340         attachment_id       INTEGER PRIMARY KEY,
 341         attachment_name     varchar(257),
 342         attachment_path     varchar(257),
 343         attachment_size     INTEGER,
 344         mail_id             INTEGER,
 345         account_id          INTEGER,
 346         mailbox_name        varchar(129),
 347         file_yn             INTEGER,
 348         flag1               INTEGER,
 349         flag2               INTEGER,
 350         flag3               INTEGER
 351 );
 352
 353 CREATE TABLE mail_box_tbl
 354 (
 355         mailbox_id                  INTEGER,
 356         account_id                  INTEGER,
 357         local_yn                    INTEGER,
 358         mailbox_name                varchar(256),
 359         mailbox_type                INTEGER,
 360         alias                       varchar(256),
 361         sync_with_server_yn         INTEGER,
 362         modifiable_yn               INTEGER,
 363         total_mail_count_on_server  INTEGER,
 364         has_archived_mails          INTEGER,
 365         mail_slot_size              INTEGER
 366 );
 367 CREATE TABLE mail_read_mail_uid_tbl
 368 (
 369         account_id            INTEGER ,
 370         local_mbox                 varchar(129)  ,
 371         local_uid             INTEGER ,
 372         mailbox_name       varchar(129)  ,
 373         s_uid                       varchar(129)  ,
 374         data1                       INTEGER ,
 375         data2                        varchar(257)  ,
 376         flag                    INTEGER ,
 377         idx_num              INTEGER  PRIMARY KEY
 378 );
 379 CREATE TABLE mail_rule_tbl
 380 (
 381         account_id     INTEGER ,
 382         rule_id        INTEGER  PRIMARY KEY,
 383         type           INTEGER ,
 384         value          varchar(257)  ,
 385         action_type    INTEGER ,
 386         dest_mailbox   varchar(129),
 387         flag1          INTEGER  ,
 388         flag2          INTEGER
 389 );
 390 CREATE TABLE mail_tbl
 391 (
 392         mail_id                   INTEGER,
 393         account_id                INTEGER,
 394         mailbox_name              VARCHAR(129),
 395         mailbox_type              INTEGER,
 396         subject                   UCS2TEXT,
 397         date_time                 VARCHAR(129),
 398         server_mail_status        INTEGER,
 399         server_mailbox_name       VARCHAR(129),
 400         server_mail_id            VARCHAR(129),
 401         message_id                VARCHAR(257),
 402         full_address_from         UCS2TEXT,
 403         full_address_reply        UCS2TEXT,
 404         full_address_to           UCS2TEXT,
 405         full_address_cc           UCS2TEXT,
 406         full_address_bcc          UCS2TEXT,
 407         full_address_return       UCS2TEXT,
 408         email_address_sender      UCS2TEXT collation user1,
 409         email_address_recipient   UCS2TEXT collation user1,
 410         alias_sender              UCS2TEXT,
 411         alias_recipient           UCS2TEXT,
 412         body_download_status      INTEGER,
 413         file_path_plain           VARCHAR(257),
 414         file_path_html            VARCHAR(257),
 415         mail_size                 INTEGER,
 416         mail_status               INTEGER,
 417         DRM_status                INTEGER,
 418         priority                  INTEGER,
 419         save_status               INTEGER,
 420         lock_status               INTEGER,
 421         report_status             INTEGER,
 422         attachment_count          INTEGER,
 423         inline_content_count      INTEGER,
 424         thread_id                 INTEGER,
 425         thread_item_count         INTEGER,
 426         preview_text              UCS2TEXT,
 427         meeting_request_status    INTEGER
 428 );
 429 CREATE TABLE mail_meeting_tbl
 430 (
 431         mail_id             INTEGER PRIMARY KEY,
 432         account_id          INTEGER,
 433         mailbox_name        UCS2TEXT ,
 434         meeting_response        INTEGER,
 435         start_time          INTEGER,
 436         end_time            INTEGER,
 437         location            UCS2TEXT ,
 438         global_object_id    UCS2TEXT ,
 439         offset              INTEGER,
 440         standard_name       UCS2TEXT ,
 441         standard_time_start_date          INTEGER,
 442         standard_bias       INTEGER,
 443         daylight_name       UCS2TEXT ,
 444         daylight_time_start_date          INTEGER,
 445         daylight_bias       INTEGER
 446 );
 447 CREATE TABLE mail_local_activity_tbl
 448 (
 449         activity_id              INTEGER,
 450         account_id       INTEGER,
 451         mail_id                  INTEGER,
 452         activity_type    INTEGER,
 453         server_mailid    VARCHAR(129),
 454         src_mbox                 VARCHAR(129),
 455         dest_mbox                VARCHAR(129)
 456 );
 457
 458
 459 CREATE UNIQUE INDEX mail_account_idx1 ON mail_account_tbl (account_bind_type, account_id);
 460 CREATE UNIQUE INDEX mail_attachment_idx1 ON mail_attachment_tbl (mail_id, attachment_id);
 461 CREATE UNIQUE INDEX mail_box_idx1 ON mail_box_tbl (account_id, local_yn, mailbox_name);
 462 CREATE UNIQUE INDEX mail_idx1 ON mail_tbl (mail_id, account_id);
 463 CREATE UNIQUE INDEX mail_read_mail_uid_idx1 ON mail_read_mail_uid_tbl (account_id, local_mbox, local_uid, mailbox_name, s_uid);
 464 CREATE UNIQUE INDEX mail_meeting_idx1 ON mail_meeting_tbl (mail_id);
 465 CREATE INDEX mail_idx_date_time ON mail_tbl (date_time);
 466 CREATE INDEX mail_idx_thread_item_count ON mail_tbl (thread_item_count);
 467 '
 468
 469 echo "[EMAIL-SERVICE] Finish Creating Email Tables."
 470
 471
 472 #################################################################
 473 # Change file permission
 474 #################################################################
 475 #echo "[EMAIL-SERVICE] Start setting permission ..."
 476 # 1. libraries
 477 #chmod 644 /usr/lib/libemail-ipc.so.0.0.0
 478 #chmod 644 /usr/lib/libemail-core.so.0.0.0
 479 #chmod 644 /usr/lib/libemail-emn-storage.so.0.0.0
 480 #chmod 644 /usr/lib/libemail-base.so.0.0.0
 481 #chmod 644 /usr/lib/libem-storage.so.0.0.0
 482 #chmod 644 /usr/lib/libem-network.so.0.0.0
 483 #chmod 644 /usr/lib/libemail-mapi.so.0.0.0
 484 #chmod 644 /usr/lib/libem-storage.so
 485 #chmod 644 /usr/lib/libemail-base.so.0
 486 #chmod 644 /usr/lib/libem-network.so.0
 487 #chmod 644 /usr/lib/libemail-core.so.0
 488 #chmod 644 /usr/lib/libemail-emn-storage.so
 489 #chmod 644 /usr/lib/libemail-ipc.so
 490 #chmod 644 /usr/lib/libemail-mapi.so.0
 491 #chmod 644 /usr/lib/libem-storage.so.0
 492 #chmod 644 /usr/lib/libem-network.so
 493 #chmod 644 /usr/lib/libemail-ipc.so.0
 494 #chmod 644 /usr/lib/libemail-core.so
 495 #chmod 644 /usr/lib/libemail-base.so
 496 #chmod 644 /usr/lib/libemail-mapi.so
 497 #chmod 644 /usr/lib/libemail-emn-storage.so.0
 498
 499 # 2. executables
 500 #chmod 700 /usr/bin/email-service_initDB
 501 #chmod 700 /usr/bin/email-service
 502
 503 # 3. DB files
 504 chmod 644 /opt/dbspace/.email-service.db
 505 chmod 644 /opt/dbspace/.email-service.db-journal
 506
 507
 508 #################################################################
 509 # Change file owner
 510 #################################################################
 511 #echo "[EMAIL-SERVICE] Start setting owner ..."
 512
 513         # 1. libraries
 514 #       chown root:root /usr/lib/libemail-ipc.so.0.0.0
 515 #       chown root:root /usr/lib/libemail-core.so.0.0.0
 516 #       chown root:root /usr/lib/libemail-emn-storage.so.0.0.0
 517 #       chown root:root /usr/lib/libemail-base.so.0.0.0
 518 #       chown root:root /usr/lib/libem-storage.so.0.0.0
 519 #       chown root:root /usr/lib/libem-network.so.0.0.0
 520 #       chown root:root /usr/lib/libemail-mapi.so.0.0.0
 521 #       chown root:root /usr/lib/libem-storage.so
 522 #       chown root:root /usr/lib/libemail-base.so.0
 523 #       chown root:root /usr/lib/libem-network.so.0
 524 #       chown root:root /usr/lib/libemail-core.so.0
 525 #       chown root:root /usr/lib/libemail-emn-storage.so
 526 #       chown root:root /usr/lib/libemail-ipc.so
 527 #       chown root:root /usr/lib/libemail-mapi.so.0
 528 #       chown root:root /usr/lib/libem-storage.so.0
 529 #       chown root:root /usr/lib/libem-network.so
 530 #       chown root:root /usr/lib/libemail-ipc.so.0
 531 #       chown root:root /usr/lib/libemail-core.so
 532 #       chown root:root /usr/lib/libemail-base.so
 533 #       chown root:root /usr/lib/libemail-mapi.so
 534 #       chown root:root /usr/lib/libemail-emn-storage.so.0
 535
 536         # 2. executables
 537 #       chown root:root /usr/bin/email-service_initDB
 538 #       chown root:root /usr/bin/email-service
 539
 540         # 3. DB files
 541 chown root:root /opt/dbspace/.email-service.db
 542 chown root:root /opt/dbspace/.email-service.db-journal
 543
 544 %postun -p /sbin/ldconfig
 545
 546
 547
 548 %files
 549 %defattr(-,root,root,-)
 550 %exclude /opt/dbspace/.email-service.db
 551 %exclude /opt/dbspace/.email-service.db-journal
 552 %exclude %{_bindir}/email-test-app
 553 %{_libdir}/libemail-api.so.*
 554 %{_libdir}/libemail-base.so.*
 555 %{_libdir}/libemail-core.so.*
 556 %{_libdir}/libemail-ipc.so.*
 557 %{_libdir}/libemail-network.so.*
 558 %{_libdir}/libemail-storage.so.*
 559 %{_bindir}/email-service
 560 /opt/apps/email-service/res/locale/de_DE/LC_MESSAGES/email.mo
 561 /opt/apps/email-service/res/locale/el_GR/LC_MESSAGES/email.mo
 562 /opt/apps/email-service/res/locale/en/LC_MESSAGES/email.mo
 563 /opt/apps/email-service/res/locale/es_ES/LC_MESSAGES/email.mo
 564 /opt/apps/email-service/res/locale/fr_FR/LC_MESSAGES/email.mo
 565 /opt/apps/email-service/res/locale/it_IT/LC_MESSAGES/email.mo
 566 /opt/apps/email-service/res/locale/ja_JP/LC_MESSAGES/email.mo
 567 /opt/apps/email-service/res/locale/ko_KR/LC_MESSAGES/email.mo
 568 /opt/apps/email-service/res/locale/nl_NL/LC_MESSAGES/email.mo
 569 /opt/apps/email-service/res/locale/pt_PT/LC_MESSAGES/email.mo
 570 /opt/apps/email-service/res/locale/ru_RU/LC_MESSAGES/email.mo
 571 /opt/apps/email-service/res/locale/tr_TR/LC_MESSAGES/email.mo
 572 /opt/apps/email-service/res/locale/zh_CN/LC_MESSAGES/email.mo
 573 /opt/apps/email-service/res/locale/zh_HK/LC_MESSAGES/email.mo
 574 /opt/apps/email-service/res/locale/zh_TW/LC_MESSAGES/email.mo
 575
 576
 577 %files devel
 578 %defattr(-,root,root,-)
 579 %{_includedir}/email-service/*.h
 580 %{_libdir}/libemail-api.so
 581 %{_libdir}/libemail-base.so
 582 %{_libdir}/libemail-core.so
 583 %{_libdir}/libemail-ipc.so
 584 %{_libdir}/libemail-network.so
 585 %{_libdir}/libemail-storage.so
 586 %{_libdir}/pkgconfig/*.pc
 587