packaging/init_db.sh

   1 #!/bin/sh
   2 PATH=/bin:/usr/bin:/sbin:/usr/sbin
   3
   4 eval $(tzplatform-get TZ_SYS_DB)
   5
   6 if [ ! -f $TZ_SYS_DB/.bluetooth_transfer.db ]
   7 then
   8         /usr/bin/sqlite3 $TZ_SYS_DB/.bluetooth_transfer.db 'PRAGMA journal_mode = PERSIST;
   9         create table if not exists inbound (
  10                 id INTEGER PRIMARY KEY autoincrement,
  11                 sid INTEGER,
  12                 tr_status INTEGER,
  13                 file_path TEXT,
  14                 dev_name TEXT,
  15                 timestamp INTEGER default 0,
  16                 addr TEXT,
  17                 type TEXT,
  18                 content TEXT,
  19                 size INTEGER
  20         );
  21         create table if not exists outbound (
  22                 id INTEGER PRIMARY KEY autoincrement,
  23                 sid INTEGER,
  24                 tr_status INTEGER,
  25                 file_path TEXT,
  26                 dev_name TEXT,
  27                 timestamp INTEGER default 0,
  28                 addr TEXT,
  29                 type TEXT,
  30                 content TEXT,
  31                 size INTEGER
  32         );
  33         '
  34 fi
  35
  36 /usr/bin/chown 5001:100 $TZ_SYS_DB/.bluetooth_transfer.db
  37 /usr/bin/chown 5001:100 $TZ_SYS_DB/.bluetooth_transfer.db-journal
  38 /usr/bin/chmod 664 $TZ_SYS_DB/.bluetooth_transfer.db
  39 /usr/bin/chmod 664 $TZ_SYS_DB/.bluetooth_transfer.db-journal
  40
  41 /usr/bin/chsmack -a 'User::Home' $TZ_SYS_DB/.bluetooth_transfer.db
  42 /usr/bin/chsmack -a 'User::Home' $TZ_SYS_DB/.bluetooth_transfer.db-journal