SQLite format 3@ -% kU z EEwtableasset_host_core_vimeo_videosasset_host_core_vimeo_videosCREATE TABLE "asset_host_core_vimeo_videos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "videoid" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) CC'tableasset_host_core_permissionsasset_host_core_permissions CREATE TABLE "asset_host_core_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource" varchar(255), "ability" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i ;;itableasset_host_core_outputsasset_host_core_outputs CREATE TABLE "asset_host_core_outputs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255) NOT NULL, "size" varchar(255) NOT NULL, "extension" varchar(255) NOT NULL, "is_rich" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "prerender" boolean DEFAULT 'f' NOT NULL) OOtableasset_host_core_brightcove_videosasset_host_core_brightcove_videos CREATE TABLE "asset_host_core_brightcove_videos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "videoid" integer(8) NOT NULL, "length" integer, "created_at" datetime, "updated_at" datetime)3 99tableasset_host_core_assetsasset_host_core_assets CREATE TABLE "asset_host_core_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "caption" text, "owner" varchar(255), "url" varchar(255), "creator_id" integer DEFAULT 1 NOT NULL, "notes" text, "image_file_name" varchar(255), "image_content_type" varchar(255), "image_copyright" varchar(255), "image_fingerprint" varchar(255), "image_title" varchar(255), "image_description" varchar(255), "image_updated_at" datetime, "image_gravity" varchar(255) DEFAULT 'Center' NOT NULL, "image_width" integer, "image_height" integer, "image_file_size" integer, "image_version" integer, "image_taken" datetime, "native_id" integer, "native_type" varchar(255), "created_at" datetime, "updated_at" datetime, "is_hidden" boolean DEFAULT 'f' NOT NULL) GCindexasset_idasset_host_core_asset_outputs CREATE UNIQUE INDEX "asset_id" ON "asset_host_core_asset_outputs" ("asset_id", "output_id")GGtableasset_host_core_asset_outputsasset_host_core_asset_outputsCREATE TABLE "asset_host_core_asset_outputs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "asset_id" integer NOT NULL, "output_id" integer NOT NULL, "fingerprint" varchar(255), "created_at" datetime, "updated_at" datetime, "width" integer, "height" integer, "image_fingerprint" varchar(255) DEFAULT '' NOT NULL)J??#tableasset_host_core_api_usersasset_host_core_api_usersCREATE TABLE "asset_host_core_api_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "auth_token" varchar(255), "created_at" datetime, "updated_at" datetime, "is_active" boolean, "last_authenticated" datetime, "email" varchar(255))sUindexindex_asset_host_core_api_user_permissions_on_permission_idasset_host_core_api_user_permissionsCREATE INDEX "index_asset_host_core_api_user_permissions_on_permission_id" ON "asset_host_core_api_user_permissions" ("permission_id")lUindexindex_asset_host_core_api_user_permissions_on_api_user_idasset_host_core_api_user_permissionsCREATE INDEX "index_asset_host_core_api_user_permissions_on_api_user_id" ON "asset_host_core_api_user_permissions" ("api_user_id")*UU7tableasset_host_core_api_user_permissionsasset_host_core_api_user_permissionsCREATE TABLE "asset_host_core_api_user_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "api_user_id" integer, "permission_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)a!tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "is_admin" boolean NOT NULL, "created_at" datetime, "updated_at" datetime, "password_digest" varchar(               Uq g :  z EEwtableasset_host_core_vimeo_videosasset_host_core_vimeo_videosCREATE TABLE "assez EEwtableasset_host_core_vimeo_videosasset_host_core_vimeo_videosCREATE TABLE "asset_host_core_vimeo_videos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "videoid" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) CC'tableasset_host_core_permissionsasset_host_core_permissions CREATE TABLE "asset_host_core_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource" varchar(255), "ability" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)i ;;itableasset_host_core_outputsasset_host_core_outputs CREATE TABLE "asset_host_core_outputs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255) NOT NULL, "size" varchar(255) NOT NULL, "extension" varchar(255) NOT NULL, "is_rich" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "prerender" boolean DEFAULT 'f' NOT NULL) OOtableasset_host_core_brightcove_videosasset_host_core_brightcove_videos CREATE TABLE "asset_host_core_brightcove_videos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "videoid" integer(8) NOT NULL, "length" integer, "created_at" datetime, "updated_at" datetime)a!tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "username" varchar(255), "is_admin" boolean NOT NULL, "created_at" datetime, "updated_at" datetime, "password_digest" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)*UU7tableasset_host_core_api_user_permissionsasset_host_core_api_user_permissionsCREATE TABLE "asset_host_core_api_user_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "api_user_id" integer, "permission_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)lUindexindex_asset_host_core_api_user_permissions_on_api_user_idasset_host_core_api_user_permissionsCREATE INDEX "index_asset_host_core_api_user_permissions_on_api_user_id" ON "asset_host_core_api_user_permissions" ("api_user_id")sUindexindex_asset_host_core_api_user_permissions_on_permission_idasset_host_core_api_user_permissionsCREATE INDEX "index_asset_host_core_api_user_permissions_on_permission_id" ON "asset_host_core_api_user_permissions" ("permission_id")J??#tableasset_host_core_api_usersasset_host_core_api_usersCREATE TABLE "asset_host_core_api_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "auth_token" varchar(255), "created_at" datetime, "updated_at" datetime, "is_active" boolean, "last_authenticated" datetime, "email" varchar(255))GGtableasset_host_core_asset_outputsasset_host_core_asset_outputsCREATE TABLE "asset_host_core_asset_outputs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "asset_id" integer NOT NULL, "output_id" integer NOT NULL, "fingerprint" varchar(255), "created_at" datetime, "updated_at" datetime, "width" integer, "height" integer, "image_fingerprint" varchar(255) DEFAULT '' NOT NULL) GCindexasset_idasset_host_core_asset_outputs CREATE UNIQUE INDEX "asset_id" ON "asset_host_core_asset_outputs" ("asset_id", "output_id")3 99tableasset_host_core_assetsasset_host_core_assets CREATE TABLE "asset_host_core_assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "caption" text, "owner" varchar(255), "url" varchar(255), "creator_id" integer DEFAULT 1 NOT NULL, "notes" text, "image_file_name" varchar(255), "image_content_type" varchar(255), "image_copyright" varchar(255), "image_fingerprint" varchar(255), "image_title" varchar(255), "image_description" varchar(255), "image_updated_at" datetime, "image_gravity" varchar(255) DEFAULT 'Center' NOT NULL, "image_width" integer, "image_height" integer, "image_file_size" integer, "image_version" integer, "image_taken" datetime, "native_id" integer, "native_type" varchar(255), "created_at" datetime, "updated_at" datetime, "is_hidden" boolean DEFAULT 'f' NOT NULL)  q n  q=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) OOtableasset_host_core_brightcove_videosasset_host_core_brightcove_videos CREATE TABLE "asset_host_core_brightcove_videos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "videoid" integer(8) NOT NULL, "length" integer, "created_at" datetime, "updated_at" datetime)i ;;itableasset_host_core_outputsasset_host_core_outputs CREATE TABLE "asset_host_core_outputs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255) NOT NULL, "size" varchar(255) NOT NULL, "extension" varchar(255) NOT NULL, "is_rich" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "prerender" boolean DEFAULT 'f' NOT NULL) CC'tableasset_host_core_permissionsasset_host_core_permissions CREATE TABLE "asset_host_core_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource" varchar(255), "ability" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)z EEwtableasset_host_core_vimeo_videosasset_host_core_vimeo_videosCREATE TABLE "asset_host_core_vimeo_videos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "videoid" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)II{tableasset_host_core_youtube_videosasset_host_core_youtube_videosCREATE TABLE "asset_host_core_youtube_videos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "videoid" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)