packaging/email-service.spec

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