Advertisement
goroh_kun

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

Dec 4th, 2011
7,176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.93 KB | None | 0 0
  1. PRAGMA foreign_keys=OFF;
  2. BEGIN TRANSACTION;
  3. CREATE TABLE android_metadata (locale TEXT);
  4. INSERT INTO "android_metadata" VALUES('ja_JP');
  5. 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);
  6. 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);
  7. INSERT INTO "T_LIFELOG" VALUES(2,1319878845,7,6,1,1,10001,3,'2',NULL,'DATA:■□───────
  8.  
  9. モバイルサイト情報
  10.  
  11. ───────□■
  12.  
  13.  
  14.  
  15. ◎10月30日(日)まで!週末限定セール開催中!
  16.  
  17.  
  18.  
  19. ◎期間限定、10月31日(月)まで!Adobe当社指定商品、通常のビック特価より10%OFF!
  20.  
  21.  
  22.  
  23. ◎【週末限定】お安くなりました!日立のオーブンレンジMRO-JV300が71,500円!
  24.  
  25.  
  26.  
  27. ◎人気のカシオソーラー電波時計オシアナス「OCW-T1000-1AJF」が、今ならポイント13%サービス!
  28.  
  29.  
  30.  
  31. ◎ニンテンドー3DSの新色「ミスティ・ピンク」入荷致しました!
  32.  
  33.  
  34.  
  35. ◎マリオカート7をさらに楽しむことができる、3DS専用ハンドルが登場!(2011年12月1日発売)
  36.  
  37.  
  38.  
  39. ◎ナノブロック2011年限定商品【クリスマスハウス2011】予約分','FLG:0','ADD:magazine@xxxxamera.com','DBID:22','TITLE:ビック:新商品&お買い得情報',NULL,NULL,NULL,NULL,NULL,NULL,0,1);
  40. 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);
  41. INSERT INTO "T_PERSON" VALUES(1,1,1,-1,'111',0);
  42. INSERT INTO "T_PERSON" VALUES(2,2,1,-1,'magazine@xxxxamera.com',1);
  43. 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 );
  44. 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);
  45. 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);
  46. 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 );
  47. CREATE TABLE T_PHONE_BOOK( PHONE_BOOK_ID INTEGER PRIMARY KEY AUTOINCREMENT, PHONE_ID INTEGER, PHONE_NUM TEXT, MAIL_ADDRESS TEXT );
  48. CREATE TABLE T_MAIL( MAIL_ID INTEGER, LIFELOG_ID INTEGER, DELETE_FLAG INTEGER DEFAULT 0);
  49. INSERT INTO "T_MAIL" VALUES(22,2,1);
  50. CREATE TABLE T_SPAREPARTS( PACKAGE_NAME TEXT, LAUNCH_COUNT INTEGER, LAUNCH_DATE INTEGER );
  51. DELETE FROM sqlite_sequence;
  52. INSERT INTO "sqlite_sequence" VALUES('T_LIFELOG',2);
  53. INSERT INTO "sqlite_sequence" VALUES('T_PERSON',2);
  54. CREATE INDEX I_LIFELOG ON T_LIFELOG ( DATE DESC );
  55. CREATE INDEX I_PERSON ON T_PERSON ( LIFELOG_ID, PHONE_BOOK_ID );
  56. CREATE INDEX I_SUMMARY ON T_SUMMARY ( L_CATEGORY_ID, M_CATEGORY_ID, S_CATEGORY_ID, OPERATION_ID, TAG, DATE );
  57. CREATE INDEX I_COMMUNICATION ON T_COMMUNICATION ( PHONE_BOOK_ID, L_CATEGORY_ID, M_CATEGORY_ID, S_CATEGORY_ID, OPERATION_ID, DATE );
  58. CREATE INDEX I_PHONE_BOOK ON T_PHONE_BOOK ( PHONE_ID );
  59. CREATE INDEX I_MAIL ON T_MAIL ( MAIL_ID );
  60. CREATE INDEX I_SPAREPARTS_DATE ON T_SPAREPARTS ( LAUNCH_DATE DESC );
  61. CREATE INDEX I_SPAREPARTS_COUNT ON T_SPAREPARTS ( LAUNCH_COUNT DESC );
  62. COMMIT;
  63.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement