test/permissions/models/test.sqlite3 in hobo-0.8.5 vs test/permissions/models/test.sqlite3 in hobo-0.8.6

- old
+ new

@@ -1,70 +1,69 @@ -SQLite format 3@ k -  'code_examples/collaboratorships -users% imagescomments! comments" recipes "+My nice comment !!My comment  +My nice comment !My comment -  ujP6  -jN4 hN4 +existing recipe% +existing recipe# +existing recipe! -+existing recipe +existing recipenew name+existing recipe#test recipe+existing recipe"=recipe with code examplemy recipe +existing recipe -+existing recipe +existing recipe~+existing recipe}+existing recipe|+existing recipe{+existing recipez+existing recipey#test recipex#test recipew+existing recipev+existing recipeut1recipe with imagess1recipe with imagesr1recipe with imagesq+existing recipep+existing recipe     wo<GtableresponsesresponsesCREATE TABLE "responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255), "user_id" integer, "recipe_id" integer, "request_id" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255), "user_id" integer, "recipe_id" integer)otablerequestsrequestsCREATE TABLE "requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255), "user_id" integer) =}m]M= wimage 2 vimage 1 uimage 2 timage 1 simage 2pnew name qimage 2 rimage 1 nimage 1mnew image limage 2 kimage 1 6 sx6? ]tableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "crypted_password" varchar(40), "salt" varchar(40), "remember_token" varchar(255), "remember_token_expires_at" datetime, "name" varchar(255), "paid_up" boolean, "state" varchar(255) DEFAULT 'active', "key_timestamp" datetime)''[tablecode_examplescode_examples CREATE TABLE "code_examples" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "filename" varchar(255));MtablerecipesrecipesCREATE TABLE "recipes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "body" varchar(255), "user_id" integer, "code_example_id" integer))//tablecollaboratorshipscollaboratorshipsCREATE TABLE "collaboratorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "recipe_id" integer) -otableimagesimages CREATE TABLE "images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "recipe_id" integer)  code.zip code.zip#exmaple.zip#exmaple.zip#changed.zip#exmaple.zip#exmaple.zip  NpP0nT8rJ0vN% -7existing recipe owneractive -regularactive -)Collaborator 2active -)Collaborator 1active -a n otheractive -)Collaborator 2active -)Collaborator 1active -regularactive% -7existing recipe owneractive~ -regularactive} -a n otheractive| -)Collaborator 2active{ -)Collaborator 1activez -regularactivey -regularactivex -regularactivew -a n otheractivev -regularactiveu -a n otheractivet -regularactives -a n otheractiver -regularactiveq -a n otheractivep -regularactiveo -%paid up usertactiven -%paid up usertactivem -%paid up usertactivel -%paid up usertactivek -%paid up usertactive%j -7existing recipe owneractive%i -7existing recipe owneractive vbH'cB(~d<"v%% -7existing recipe owneractive$ -regularactive%# -7existing recipe owneractive" -regularactive%! -7existing recipe owneractive -regularactive% -7existing recipe owneractive -regularactive -regularactive -regularactive% -7existing recipe owneractive -regularactive -regularactive -regularactive -regularactive -)Collaborator 2active -)Collaborator 1active -regularactive -regularactive -regularactive -regularactive -regularactive -)Collaborator 2active -)Collaborator 1active -regularactive -)Collaborator 2active -)Collaborator 1active +SQLite format 3@ +e +  'code_examples recipes +users comments2 images+i collabor/collaboratorships 2+My nice comment1!My comment0+My nice comment/!My comment  ujP6  +jN4 fL2+existing recipe+existing recipe+existing recipe+existing recipe+existing recipenew name+existing recipe+existing recipe #test recipe ~+existing recipe"}=recipe with code example|my recipe{+existing recipez+existing recipey+existing recipex+existing recipew+existing recipev+existing recipeu+existing recipet+existing recipes#test reciper#test recipeq+existing recipep+existing recipeon1recipe with imagesm1recipe with imagesl1recipe with imagesk+existing recipej+existing recipe    6|5|4{3{2x1x wo<GtableresponsesresponsesCREATE TABLE "responses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255), "user_id" integer, "recipe_id" integer, "request_id" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#tablecommentscommentsCREATE TABLE "comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255), "user_id" integer, "recipe_id" integer)otablerequestsrequestsCREATE TABLE "requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255), "user_id" integer) =}m]M= +image 2s *image 1s )image 2r (image 1r 'image 2o$new namen %image 2n &image 1o "image 1m!new imagel image 2l image 1l 6 sx6? ]tableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "crypted_password" varchar(40), "salt" varchar(40), "remember_token" varchar(255), "remember_token_expires_at" datetime, "name" varchar(255), "paid_up" boolean, "state" varchar(255) DEFAULT 'active', "key_timestamp" datetime)''[tablecode_examplescode_examples CREATE TABLE "code_examples" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "filename" varchar(255));MtablerecipesrecipesCREATE TABLE "recipes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "body" varchar(255), "user_id" integer, "code_example_id" integer))//tablecollaboratorshipscollaboratorshipsCREATE TABLE "collaboratorships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "recipe_id" integer) +otableimagesimages CREATE TABLE "images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "recipe_id" integer) ||#%exmaple2.zip"%exmaple1.zip !code.zip code.zip#exmaple.zip#exmaple.zip#changed.zip#exmaple.zip ~ NpP0nT8rJ0vN%~ +7existing recipe owneractive} +regularactive| +)Collaborator 2active{ +)Collaborator 1activez +a n otheractivey +)Collaborator 2activex +)Collaborator 1activew +regularactive%v +7existing recipe owneractiveu +regularactivet +a n otheractives +)Collaborator 2activer +)Collaborator 1activeq +regularactivep +regularactiveo +regularactiven +a n otheractivem +regularactivel +a n otheractivek +regularactivej +a n otheractivei +regularactiveh +a n otheractiveg +regularactivef +%paid up usertactivee +%paid up usertactived +%paid up usertactivec +%paid up usertactiveb +%paid up usertactive%a +7existing recipe owneractive%` +7existing recipe owneractive \bH'cB(~dJ"\% +7existing recipe owneractive +regularactive% +7existing recipe owneractive +regularactive% +7existing recipe owneractive +regularactive% +7existing recipe owneractive +regularactive +regularactive +regularactive% +7existing recipe owneractive +regularactive +regularactive +regularactive +regularactive +regularactive +)Collaborator 2active +)Collaborator 1active +regularactive -regularactive% -7existing recipe owneractive +regularactive +regularactive +regularactive +regularactive +)Collaborator 2active +)Collaborator 1active +regularactive +)Collaborator 2active +)Collaborator 1active +regularactive% +7existing recipe owneractive regularactive \ No newline at end of file