SQLite format 3@ -  C95??5tablemy_forum_private_messagesmy_forum_private_messagesCREATE TABLE "my_forum_private_messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender_id" integer, "recipient_id" integer, "sender_deleted" boolean DEFAULT 'f', "recipient_deleted" boolean DEFAULT 'f', "unread" boolean DEFAULT 't', "subject" varchar, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)GG)tablemy_forum_category_permissionsmy_forum_category_permissionsCREATE TABLE "my_forum_category_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)s ??utablemy_forum_user_group_linksmy_forum_user_group_linksCREATE TABLE "my_forum_user_group_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_group_id" integer, "created_at" datetime, "updated_at" datetime)} 55tablemy_forum_user_groupsmy_forum_user_groups CREATE TABLE "my_forum_user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "html_color" varchar, "default" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime){ ;; tablemy_forum_log_read_marksmy_forum_log_read_marks CREATE TABLE "my_forum_log_read_marks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "topic_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)[ 33]tablemy_forum_user_rolesmy_forum_user_roles CREATE TABLE "my_forum_user_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime, "updated_at" datetime)V ))gtablemy_forum_rolesmy_forum_roles CREATE TABLE "my_forum_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "color" varchar, "rights" text, "created_at" datetime, "updated_at" datetime).))tablemy_forum_usersmy_forum_users CREATE TABLE "my_forum_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar, "password" varchar, "salt" varchar, "email" varchar, "posts_count" integer, "is_admin" boolean DEFAULT 'f', "is_moderator" boolean DEFAULT 'f', "is_deleted" boolean DEFAULT 'f', "permanently_banned" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "last_logged_in" datetime)E331tablemy_forum_categoriesmy_forum_categoriesCREATE TABLE "my_forum_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime)n))tablemy_forum_postsmy_forum_postsCREATE TABLE "my_forum_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "topic_id" integer, "forum_id" integer, "text" text, "created_at" datetime, "updated_at" datetime)++stablemy_forum_topicsmy_forum_topicsCREATE TABLE "my_forum_topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "forum_id" integer, "user_id" integer, "latest_post_id" integer, "name" varchar, "description" varchar, "views" integer, "posts_count" integer DEFAULT 0, "pinned" boolean DEFAULT 'f', "closed" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)++ctablemy_forum_forumsmy_forum_forumsCREATE TABLE "my_forum_forums" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "name" varchar, "description" varchar, "topics_count" integer, "posts_count" integer, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT  p^L:( )20151012095554 )20150227210814 )20150215212443 )20150215204852 )20150215200453)20150202115250)20141222094538)20141222094522)20141118131215)20141118081021)20141117122751)20141117122742)20141117122725  |iVC0 )20151012095554 )20150227210814 )20150215212443 )20150215204852 )20150215200453 )20150202115250)20141222094538)20141222094522)20141118131215)20141118081021)20141117122751)20141117122742) 20141117122725  5my_forum_user_groups) my_forum_users    ^ /AAadmin5e197298d9ae984e49aa1fbb6d593adf407f962138788a44311f17fbe96284a64196457f8b2ffebea985b363c9370e664cd49eb14ba2e5078b2f43883ba182c5admin@example.comffff2015-03-01 20:58:12.3262402015-03-01 20:58:12.326240    x1AAAAdminf2015-03-01 20:58:12.4126192015-03-01 20:58:12.412619EAAModeratorf2015-03-01 20:58:12.4119372015-03-01 20:58:12.411937BAAMembert2015-03-01 20:58:12.4112322015-03-01 20:58:12.411232BAAGuestsf2015-03-01 20:58:12.4102932015-03-01 20:58:12.410293      C95??5tablemy_forum_private_messagesmy_forum_private_messagesCREATE TABLE "my_forum_private_messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender_id" integer, "recipient_id" integer, "sender_deleted" boolean DEFAULT 'f', "recipient_deleted" boolean DEFAULT 'f', "unread" boolean DEFAULT 't', "subject" varchar, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)GG)tablemy_forum_category_permissionsmy_forum_category_permissionsCREATE TABLE "my_forum_category_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)s ??utablemy_forum_user_group_linksmy_forum_user_group_linksCREATE TABLE "my_forum_user_group_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_group_id" integer, "created_at" datetime, "updated_at" datetime)} 55tablemy_forum_user_groupsmy_forum_user_groups CREATE TABLE "my_forum_user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "html_color" varchar, "default" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime){ ;; tablemy_forum_log_read_marksmy_forum_log_read_marks CREATE TABLE "my_forum_log_read_marks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "topic_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)[ 33]tablemy_forum_user_rolesmy_forum_user_roles CREATE TABLE "my_forum_user_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime, "updated_at" datetime)V ))gtablemy_forum_rolesmy_forum_roles CREATE TABLE "my_forum_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "color" varchar, "rights" text, "created_at" datetime, "updated_at" datetime).))tablemy_forum_usersmy_forum_users CREATE TABLE "my_forum_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar, "password" varchar, "salt" varchar, "email" varchar, "posts_count" integer, "is_admin" boolean DEFAULT 'f', "is_moderator" boolean DEFAULT 'f', "is_deleted" boolean DEFAULT 'f', "permanently_banned" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime, "last_logged_in" datetime)E331tablemy_forum_categoriesmy_forum_categoriesCREATE TABLE "my_forum_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime, "updated_at" datetime)n))tablemy_forum_postsmy_forum_postsCREATE TABLE "my_forum_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "topic_id" integer, "forum_id" integer, "text" text, "created_at" datetime, "updated_at" datetime)++stablemy_forum_topicsmy_forum_topicsCREATE TABLE "my_forum_topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "forum_id" integer, "user_id" integer, "latest_post_id" integer, "name" varchar, "description" varchar, "views" integer, "posts_count" integer DEFAULT 0, "pinned" boolean DEFAULT 'f', "closed" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)++ctablemy_forum_forumsmy_forum_forumsCREATE TABLE "my_forum_forums" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_id" integer, "name" varchar, "description" varchar, "topics_count" integer, "posts_count" integer, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL) b"$ $ .  b++mtablemy_forum_imagesmy_forum_imagesCREATE TABLE "my_forum_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "post_id" integer, "file_name" varchar, "file_size" integer, "type" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)??5tablemy_forum_private_messagesmy_forum_private_messagesCREATE TABLE "my_forum_private_messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender_id" integer, "recipient_id" integer, "sender_deleted" boolean DEFAULT 'f', "recipient_deleted" boolean DEFAULT 'f', "unread" boolean DEFAULT 't', "subject" varchar, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)GG)tablemy_forum_category_permissionsmy_forum_category_permissionsCREATE TABLE "my_forum_category_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "category_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)s ??utablemy_forum_user_group_linksmy_forum_user_group_linksCREATE TABLE "my_forum_user_group_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_group_id" integer, "created_at" datetime, "updated_at" datetime)} 55tablemy_forum_user_groupsmy_forum_user_groups CREATE TABLE "my_forum_user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "html_color" varchar, "default" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime){ ;; tablemy_forum_log_read_marksmy_forum_log_read_marks CREATE TABLE "my_forum_log_read_marks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "topic_id" integer, "post_id" integer, "created_at" datetime, "updated_at" datetime)[ 33]tablemy_forum_user_rolesmy_forum_user_roles CREATE TABLE "my_forum_user_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime, "updated_at" datetime)