packaging/init_menu-screen_DB.sh

   1 #!/bin/sh
   2 source /etc/tizen-platform.conf
   3 if [ ! -d $1/dbspace ]
   4 then
   5        mkdir -p $1/dbspace
   6 fi
   7 if [ ! -d $1/shortcut ]
   8 then
   9        mkdir -p $1/shortcut
  10 else
  11        rm -rf $1/shortcut/*
  12 fi
  13 sqlite3 $1/dbspace/.menu_screen.db 'PRAGMA journal_mode = PERSIST;
  14         create table if not exists shortcut (
  15                 ROWID INTEGER PRIMARY KEY AUTOINCREMENT,
  16                 appid TEXT,
  17                 name TEXT,
  18                 type INTEGER,
  19                 content_info TEXT,
  20                 icon TEXT
  21         );
  22 '
  23 users_gid=$(getent group $TZ_SYS_USER_GROUP | cut -f3 -d':')
  24
  25 INHOUSE_ID="$users_gid"
  26 chown -R $INHOUSE_ID:$INHOUSE_ID $1
  27 chown root:$INHOUSE_ID $1/dbspace/.menu_screen.db
  28 chown root:$INHOUSE_ID $1/dbspace/.menu_screen.db-journal
  29
  30 chmod 660 $1/dbspace/.menu_screen.db
  31 chmod 660 $1/dbspace/.menu_screen.db-journal
  32