db/test.sqlite3 in okkez-multi_auth-0.0.5 vs db/test.sqlite3 in okkez-multi_auth-0.0.6
- old
+ new
@@ -3,12 +3,12 @@
h ++gtableemail_addressesemail_addressesCREATE TABLE "email_addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "activation_token" varchar(40) NOT NULL, "user_id" integer NOT NULL, "email" varchar(200) NOT NULL, "activated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)W+Aindexindex_email_addresses_on_activated_atemail_addressesCREATE INDEX "index_email_addresses_on_activated_at" ON "email_addresses" ("activated_at")._+_indexindex_email_addresses_on_activation_tokenemail_addressesCREATE UNIQUE INDEX "index_email_addresses_on_activation_token" ON "email_addresses" ("activation_token")S+9indexindex_email_addresses_on_created_atemail_addressesCREATE INDEX "index_email_addresses_on_created_at" ON "email_addresses" ("created_at")
jZ 0a+aindexindex_email_addresses_on_email_and_user_idemail_addressesCREATE UNIQUE INDEX "index_email_addresses_on_email_and_user_id" ON "email_addresses" ("email", "user_id")M+-indexindex_email_addresses_on_user_idemail_addresses
CREATE INDEX "index_email_addresses_on_user_id" ON "email_addresses" ("user_id")^//ktableemail_credentialsemail_credentialsCREATE TABLE "email_credentials" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "activation_token" varchar(40) NOT NULL, "user_id" integer NOT NULL, "email" varchar(200) NOT NULL, "hashed_password" varchar(73) NOT NULL, "activated_at" datetime, "loggedin_at" datetime)# [/Iindexindex_email_credentials_on_activated_atemail_credentialsCREATE INDEX "index_email_credentials_on_activated_at" ON "email_credentials" ("activated_at")
i P
- 35+3 2009-01-01 00:00:0033333333333333333333<arisa@example.jp21eedc90:a150fffb2c64f69fcebd61b4a2d154b744e7dd25cdfcf73ead5565d16ebf300c2009-01-01 00:00:006
- 351332009-01-01 00:00:0011111111111111111111! yuyakato@gmail.come60b1117:f54586e2d38168b3b91dec3276beaa51b2ae011fb17cbda564898951c206b0062009-01-01 00:00:002009-01-01 00:00:00V
- 353 2009-01-01 00:00:0022222222222222222222! yuya@nayutaya.co.jp327e1b98:59dd5cfa932066cc629118c50c2caf99abdd66cb7d4ea2b3ad23e82b16456fc6
+ 35+3 2009-01-01 00:00:0033333333333333333333<arisa@example.jp8aea4bc0:5ed6980796ae4a336ad695757ad7c46cac3e7f8ca88d2eecad77783a745f2f712009-01-01 00:00:006
+ 351332009-01-01 00:00:0011111111111111111111! yuyakato@gmail.comf4274781:ffa28a9968c0d3d9465b5f719de42443fc831280d30b9f81d6c20ad20de757682009-01-01 00:00:002009-01-01 00:00:00V
+ 353 2009-01-01 00:00:0022222222222222222222! yuya@nayutaya.co.jpa0d40c77:8170e6296761fa401992cb40e35161b59a32635eab19a485f3b289b16872ff9b
32009-01-01 00:00:001P32009-01-01 00:00:00+ V
5333333333333333333331P511111111111111111111+522222222222222222222V
D D 5 6
c/gindexindex_email_credentials_on_activation_tokenemail_credentials
CREATE UNIQUE INDEX "index_email_credentials_on_activation_token" ON "email_credentials" ("activation_token")W/Aindexindex_email_credentials_on_created_atemail_credentialsCREATE INDEX "index_email_credentials_on_created_at" ON "email_credentials" ("created_at")M/;indexindex_email_credentials_on_emailemail_credentialsCREATE UNIQUE INDEX "index_email_credentials_on_email" ON "email_credentials" ("email")
Q/5indexindex_email_credentials_on_user_idemail_credentialsCREATE INDEX "index_email_credentials_on_user_id" ON "email_credentials" ("user_id")1SSItableopen_id_authentication_associationsopen_id_authentication_associationsCREATE TABLE "open_id_authentication_associations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "issued" integer, "lifetime" integer, "handle" varchar(255), "assoc_type" varchar(255), "server_url" blob, "secret" blob)
32009-01-01 00:00:001P32009-01-01 00:00:00+32009-01-01 00:00:00V
+risa@example.jp1P1yuyakato@gmail.com+3yuya@nayutaya.co.jpV
\ No newline at end of file