parser/component/script/501.component_upgrade.sh.in

   1 #!/bin/sh
   2
   3 #------------------------------------------#
   4 # component db upgrade (4.0 -> 5.5)        #
   5 #------------------------------------------#
   6
   7 # Macro
   8 PATH=/bin:/usr/bin:/sbin:/usr/sbin
   9
  10 GLOBAL_USER_DB=/opt/dbspace/.component.db
  11 DEFAULT_USER_DB=/opt/dbspace/user/5001/.component.db
  12
  13 # Create DB
  14 sqlite3 $GLOBAL_USER_DB << EOF
  15 PRAGMA journal_mode = PERSIST;
  16 PRAGMA user_version = @COMPONENT_DB_VERSION@;
  17
  18 CREATE TABLE IF NOT EXISTS component_info (
  19         package TEXT NOT NULL,
  20         app_id TEXT NOT NULL,
  21         component_id TEXT NOT NULL,
  22         component_type TEXT NOT NULL,
  23         component_launch_mode TEXT NOT NULL,
  24         component_main TEXT NOT NULL,
  25         component_icon_display NOT NULL,
  26         component_taskmanage NOT NULL,
  27         PRIMARY KEY (component_id)
  28 );
  29
  30 CREATE TABLE IF NOT EXISTS component_localized_info (
  31         component_id TEXT NOT NULL,
  32         component_locale TEXT NOT NULL DEFAULT 'No Locale',
  33         component_label TEXT,
  34         component_icon TEXT,
  35         PRIMARY KEY (component_id, component_locale)
  36         FOREIGN KEY (component_id)
  37         REFERENCES component_info(component_id) ON DELETE CASCADE
  38 );
  39
  40 EOF
  41
  42 # Create DB Path for default user
  43 mkdir -p /opt/dbspace/user/5001
  44 chmod 770 /opt/dbspace/user/5001
  45 chown owner:system_share /opt/dbspace/user/5001
  46 chsmack -a User::Home /opt/dbspace/user
  47 chsmack -a User::Home /opt/dbspace/user/5001
  48
  49 # Copy DB
  50 cp $GLOBAL_USER_DB $DEFAULT_USER_DB
  51
  52 # Adjust Permission
  53 chmod 664 $GLOBAL_USER_DB
  54 chmod 664 $GLOBAL_USER_DB-journal
  55
  56 chown owner:users $GLOBAL_USER_DB
  57 chown owner:users $GLOBAL_USER_DB-journal
  58
  59 chsmack -a User::Home $GLOBAL_USER_DB
  60 chsmack -a User::Home $GLOBAL_USER_DB-journal
  61
  62 chmod 666 $DEFAULT_USER_DB
  63 chmod 666 $DEFAULT_USER_DB-journal
  64
  65 chsmack -a User::Home $DEFAULT_USER_DB
  66 chsmack -a User::Home $DEFAULT_USER_DB-journal