3 #------------------------------------------#
4 # badge patch for upgrade (2.4 -> 3.0) #
5 #------------------------------------------#
8 PATH=/bin:/usr/bin:/sbin:/usr/sbin
11 DB_BADGE=$DB_DIR/.badge.db
13 sqlite3 $DB_BADGE << EOF
15 DROP TABLE IF EXISTS badge_data_temp;
17 CREATE TABLE badge_data_temp (
19 pkgname TEXT NOT NULL,
21 badge INTEGER default 0,
22 rowid INTEGER PRIMARY KEY AUTOINCREMENT,
26 INSERT INTO badge_data_temp (pkgname, writable_pkgs, badge, rowid) SELECT pkgname, writable_pkgs, badge, rowid FROM badge_data;
27 UPDATE badge_data_temp SET uid=5001;
28 DROP TABLE badge_data;
29 ALTER TABLE badge_data_temp RENAME TO badge_data;
31 DROP TABLE IF EXISTS badge_option_temp;
33 CREATE TABLE badge_option_temp (
35 pkgname TEXT NOT NULL,
36 display INTEGER default 1,
40 INSERT INTO badge_option_temp (pkgname, display) SELECT pkgname, display FROM badge_option;
41 UPDATE badge_option_temp SET uid=5001;
42 DROP TABLE badge_option;
43 ALTER TABLE badge_option_temp RENAME TO badge_option;
47 chown app_fw:app_fw $DB_BADGE
48 chown app_fw:app_fw $DB_BADGE-journal
50 chsmack -a System $DB_BADGE
51 chsmack -a System $DB_BADGE-journal