- 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;
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.