The definition of JIL Widget manager database table

This article firstly post to my QQ Zone. You can visit http://user.qzone.qq.com/457283 to get more blog.

 

StatRecordTable?   

CREATE TABLE StatRecordTable 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


widget_id TEXT,


dev_guid LONG,


action TEXT,


timestamp LONG,


action_status BOOLEAN


)





ACTION Definitions:


1. Launch


2. Close


3. Install

 

UserInfoTable?   

CREATE TABLE UserInfoTable 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


account TEXT,


password TEXT,


nickname TEXT,


imsi TEXT,


register_flag BOOLEAN,


last_report_date LONG


)

 

android_metadata

CREATE TABLE UserInfoTable 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


account TEXT,


password TEXT,


nickname TEXT,


imsi TEXT,


register_flag BOOLEAN,


last_report_date LONG


)

 

black_list

CREATE TABLE black_list 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


uuid TEXT,


version TEXT


)

 

checksums

CREATE TABLE checksums 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


uuid TEXT,


entryName TEXT,


checksum TEXT


)

 

galerryCategories

CREATE TABLE galleryCategories 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


id TEXT,


name TEXT,


chname TEXT,


parent TEXT,


widgets_url TEXT,


number INTEGER,


description TEXT,


need_refresh INTEGER,


timestamp TEXT,


icon_url TEXT


)

 

galleryWidgets

CREATE TABLE galleryWidgets 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


uwid TEXT,


uwName TEXT,


uwVersion TEXT,


uwUrl TEXT,


uwIcon_url TEXT,


uwPrice LONG,


uwRating INTEGER,


uwDate LONG,


uwSize INTEGER,


uwAuthor TEXT,


uwDescription TEXT,


uwCtr INTEGER,


category_id INTEGER,


timestamp INTEGER,


uwIcon_path TEXT


)

 

overallpreference

CREATE TABLE overallpreference 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


key TEXT,


value TEXT


)

 

package_stat

CREATE TABLE package_stat 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


start_time INTEGER,


end_time INTEGER,


count INTEGER,


type INTEGER


)

 

prefs

CREATE TABLE prefs 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


uuid TEXT,


key TEXT,


value TEXT


)

 

widgetFeaturesTable

CREATE TABLE widgetFeaturesTable 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


feature_name TEXT,


uuid TEXT,


feature_required INTEGER


)

 

widgetLocaledTable

CREATE TABLE widgetLocaledTable 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


uuid TEXT,


language TEXT,


country TEXT,


html_path TEXT,


icon_path TEXT,


name TEXT,


author_href TEXT,


author_email TEXT,


content_type TEXT,


content_charset TEXT,


icon_height INTEGER,


icon_width INTEGER,


displayname TEXT,


descriptions TEXT,


license TEXT,


license_href TEXT,


author TEXT


)

 

widgets

CREATE TABLE widgets 


(


_id INTEGER PRIMARY KEY AUTOINCREMENT,


uuid TEXT,


preload INTEGER,


path TEXT,


size INTEGER,


format INTEGER,


active INTEGER,


install_time INTEGER,


update_time INTEGER,


last_access_time INTEGER,


trust_domain INTEGER,


launch_count INTEGER,


name TEXT,


displayname TEXT,


version TEXT,


icon_path TEXT,


category_id INTEGER,


install_source INTEGER,


ad_count INTEGER,


ad_click_count INTEGER,


price FLOAT,


comments TEXT,


rank FLOAT,


html_path TEXT,


width INTEGER,


height INTEGER,


maximum_width INTEGER,


maximum_height INTEGER,


privilege LONG,


sharable INTEGER,


download_url TEXT,


update_url TEXT,


STATUS INTEGER,


position_x INTEGER,


position_y INTEGER,


scale FLOAT,


run_status INTEGER,


license TEXT,


license_href TEXT,


author TEXT,


author_email TEXT,


descriptions TEXT,


language TEXT,


author_href TEXT,


content_type TEXT,


content_charset TEXT,


icon_height INTEGER,


icon_width INTEGER,


cert_not_before INTEGER,


cert_not_after INTEGER,


access_localfs INTEGER DEFAULT 0,


access_network INTEGER DEFAULT 0,


access_remotescripts INTEGER DEFAULT 0,


billing_required INTEGER DEFAULT 0,


billing_price_point TEXT,


billing_display_text TEXT,


billing_cache_until INTEGER,


on_dock INTEGER DEFAULT 0 


)