rem: var sqlTables = { cal_calendars: "id INTEGER PRIMARY KEY, name STRING, type STRING, uri STRING", cal_calendars_prefs: "id INTEGER PRIMARY KEY, calendar INTERGER, name STRING, value STRING" 
add: var sqlTables = { cal_calendars: "id INTEGER PRIMARY KEY, type STRING, uri STRING", cal_calendars_prefs: "id INTEGER PRIMARY KEY, calendar INTEGER, name STRING, value STRING" 
context:     initDB: function() {        var sqlTables = { cal_calendars: "id INTEGER PRIMARY KEY, name STRING, type STRING, uri STRING",                          cal_calendars_prefs: "id INTEGER PRIMARY KEY, calendar INTERGER, name STRING, value STRING"        };        var dbService = Components.classes[kStorageServiceContractID].getService(kStorageServiceIID);        this.mDB = dbService.getProfileStorage("profile");        for (table in sqlTables) {            try {                this.mDB.createTable(table, sqlTables[table]);            } catch (ex) {                dump("error creating table " + table + " -- probably already exists\n");            }        }        this.mSelectCalendars = createStatement (            this.mDB,            "SELECT oid,* FROM cal_calendars");        this.mFindCalendar = createStatement (            this.mDB,            "SELECT id FROM cal_calendars WHERE name = :name AND type = :type AND uri = :uri");        this.mRegisterCalendar = createStatement (            this.mDB,            "INSERT INTO cal_calendars (name, type, uri) " +            "VALUES (:name, :type, :uri)"            );        this.mUnregisterCalendar = createStatement (            this.mDB,            "DELETE FROM cal_calendars WHERE id = :id"            );        this.mGetPref = createStatement (            this.mDB,            "SELECT value FROM cal_calendars_prefs WHERE calendar = :calendar AND name = :name");        this.mDeletePref = createStatement (            this.mDB,            "DELETE FROM cal_calendars_prefs WHERE calendar = :calendar AND name = :name");        this.mInsertPref = createStatement (            this.mDB,            "INSERT INTO cal_calendars_prefs (calendar, name, value) " +            "VALUES (:calendar, :name, :value)");    },
meta: 9421	/local1/tlutelli/issta_data/temp/all_js/javascript/2006_temp/2006/9421/a900c059739670f08b2946030aca01cb8bacb415/calCalendarManager.js/buggy/calendar/base/src/calCalendarManager.js