IS05のLifeLogServiceが保存するデータベースのダンプ

PRAGMA foreign_keys=OFF;

BEGIN TRANSACTION;

CREATE TABLE android_metadata (locale TEXT);

INSERT INTO "android_metadata" VALUES('ja_JP');

CREATE TABLE T_LIFELOG( LIFELOG_ID INTEGER PRIMARY KEY AUTOINCREMENT, DATE INTEGER, DAY_OF_WEEK INTEGER, TIMEZONE_ID INTEGER, L_CATEGORY_ID INTEGER, M_CATEGORY_ID INTEGER, S_CATEGORY_ID INTEGER, OPERATION_ID INTEGER, PERSON_ID TEXT, TAG TEXT, DATA1 TEXT, DATA2 TEXT, DATA3 TEXT, DATA4 TEXT, DATA5 TEXT, DATA6 TEXT, DATA7 TEXT, DATA8 TEXT, DATA9 TEXT, DATA10 TEXT, TAGEX TEXT, SECRET_FLAG INTEGER, DELETE_FLAG INTEGER DEFAULT 0);

INSERT INTO "T_LIFELOG" VALUES(1,1319889110,7,6,28,61,10001,44,'1','0','CALLNUM:111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0);

INSERT INTO "T_LIFELOG" VALUES(2,1319878845,7,6,1,1,10001,3,'2',NULL,'DATA:■□───────

 

モバイルサイト情報

 

───────□■

 

 

 

◎10月30日(日)まで！週末限定セール開催中！

 

 

 

◎期間限定、10月31日(月)まで！Adobe当社指定商品、通常のビック特価より10％OFF!

 

 

 

◎【週末限定】お安くなりました！日立のオーブンレンジMRO-JV300が71,500円！

 

 

 

◎人気のカシオソーラー電波時計オシアナス「OCW-T1000-1AJF」が、今ならポイント13％サービス！

 

 

 

◎ニンテンドー3DSの新色「ミスティ・ピンク」入荷致しました！

 

 

 

◎マリオカート7をさらに楽しむことができる、3DS専用ハンドルが登場！(2011年12月1日発売)

 

 

 

◎ナノブロック2011年限定商品【クリスマスハウス2011】予約分','FLG:0','ADD:magazine@xxxxamera.com','DBID:22','TITLE:ビック：新商品＆お買い得情報',NULL,NULL,NULL,NULL,NULL,NULL,0,1);

CREATE TABLE T_PERSON( PERSON_ID INTEGER PRIMARY KEY AUTOINCREMENT, LIFELOG_ID INTEGER, REGIST_KIND INTEGER, PHONE_BOOK_ID INTEGER, PERSON_INFO TEXT, DELETE_FLAG INTEGER DEFAULT 0);

INSERT INTO "T_PERSON" VALUES(1,1,1,-1,'111',0);

INSERT INTO "T_PERSON" VALUES(2,2,1,-1,'magazine@xxxxamera.com',1);

CREATE TABLE T_SUMMARY( L_CATEGORY_ID INTEGER, M_CATEGORY_ID INTEGER, S_CATEGORY_ID INTEGER, OPERATION_ID INTEGER, TAG TEXT, LIFELOG_ID INTEGER, DATE INTEGER, COUNT INTEGER, SUNDAY INTEGER, MONDAY INTEGER, TUESDAY INTEGER, WEDNESDAY INTEGER, THURSDAY INTEGER, FRIDAY INTEGER, SATURDAY INTEGER, TIMEZONE_0 INTEGER, TIMEZONE_1 INTEGER, TIMEZONE_2 INTEGER, TIMEZONE_3 INTEGER, TIMEZONE_4 INTEGER, TIMEZONE_5 INTEGER, TIMEZONE_6 INTEGER, TIMEZONE_7 INTEGER, LOG_TYPE INTEGER  );

INSERT INTO "T_SUMMARY" VALUES(28,61,10001,44,'0',1,1319889110,1,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0);

INSERT INTO "T_SUMMARY" VALUES(1,1,10001,3,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1);

CREATE TABLE T_COMMUNICATION( PHONE_BOOK_ID INTEGER, L_CATEGORY_ID INTEGER, M_CATEGORY_ID INTEGER, S_CATEGORY_ID INTEGER, OPERATION_ID INTEGER, COUNT INTEGER, DATE INTEGER, LIFELOG_ID INTEGER );

CREATE TABLE T_PHONE_BOOK( PHONE_BOOK_ID INTEGER PRIMARY KEY AUTOINCREMENT, PHONE_ID INTEGER, PHONE_NUM TEXT, MAIL_ADDRESS TEXT );

CREATE TABLE T_MAIL( MAIL_ID INTEGER, LIFELOG_ID INTEGER, DELETE_FLAG INTEGER DEFAULT 0);

INSERT INTO "T_MAIL" VALUES(22,2,1);

CREATE TABLE T_SPAREPARTS( PACKAGE_NAME TEXT, LAUNCH_COUNT INTEGER, LAUNCH_DATE INTEGER );

DELETE FROM sqlite_sequence;

INSERT INTO "sqlite_sequence" VALUES('T_LIFELOG',2);

INSERT INTO "sqlite_sequence" VALUES('T_PERSON',2);

CREATE INDEX I_LIFELOG ON T_LIFELOG ( DATE DESC );

CREATE INDEX I_PERSON ON T_PERSON ( LIFELOG_ID, PHONE_BOOK_ID );

CREATE INDEX I_SUMMARY ON T_SUMMARY ( L_CATEGORY_ID, M_CATEGORY_ID, S_CATEGORY_ID, OPERATION_ID, TAG, DATE );

CREATE INDEX I_COMMUNICATION ON T_COMMUNICATION ( PHONE_BOOK_ID, L_CATEGORY_ID, M_CATEGORY_ID, S_CATEGORY_ID, OPERATION_ID, DATE );

CREATE INDEX I_PHONE_BOOK ON T_PHONE_BOOK ( PHONE_ID );

CREATE INDEX I_MAIL ON T_MAIL ( MAIL_ID );

CREATE INDEX I_SPAREPARTS_DATE ON T_SPAREPARTS ( LAUNCH_DATE DESC );

CREATE INDEX I_SPAREPARTS_COUNT ON T_SPAREPARTS ( LAUNCH_COUNT DESC );

COMMIT;