test/db/test.sqlite3 in cbac-0.6.2 vs test/db/test.sqlite3 in cbac-0.6.3

- old
+ new

@@ -1,7 +1,6 @@ -SQLite format 3@ M Z--gtablecbac_membershipscbac_membershipsCREATE TABLE "cbac_memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "generic_role_id" integer, "created_at" datetime, "updated_at" datetime)R99?tablecbac_known_permissionscbac_known_permissionsCREATE TABLE "cbac_known_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permission_number" integer, "permission_type" integer DEFAULT 0)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)W11Ytablecbac_generic_rolescbac_generic_rolesCREATE TABLE "cbac_generic_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "remarks" text, "created_at" datetime, "updated_at"  Q'administratorAdministrators role. Grants full access to the entire system. 1cbac_privilege_set1cbac_privilege_set-cbac_permissionsT-cbac_memberships*1cbac_generic_roles  *  TS9authorize_context_role AW11Ytablecbac_generic_rolescbac_generic_rolesCREATE TABLE "cbac_generic_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "remarks" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)R99?tablecbac_known_permissionscbac_known_permissionsCREATE TABLE "cbac_known_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permission_number" integer, "permission_type" integer DEFAULT 0)Z--gtablecbac_membershipscbac_membershipsCREATE TABLE "cbac_memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "generic_role_id" integer, "created_at" datetime, "updated_at" datetime) ---Gtablecbac_permissionscbac_permissionsCREATE TABLE "cbac_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "generic_role_id" integer DEFAULT 0, "context_role" varchar(255), "privilege_set_id" integer, "created_at" datetime, "updated_at" datetime) U|C AAcbac_generic_role_incor1/ Acbac_generic_role2010-11-30 16:56wGGAAtest_adding_new_privilege_settest_adding_new_privilege_set2010-11-30 16:56:55.D3AAnews_item_moderatorModerator2010-11-30 17:09:24.8751252010-11-30 17:09:24.880125;SAAnews_item_administratorAllows administration of news items2010-11-30 17:09:24.8631242010-11-30 17:09:24.868124t-]AAnews_item_updateAllows changing existing news_item items2010-11-30 17:09:24.8521232010-11-30 17:09:24.857124-KAAnews_item_createAllows creating news_item items2010-11-30 17:09:24.8411232010-11-30 17:09:24.846123)IAAnews_item_readAllows reading news_item items2010-11-30 17:09:24.8311222010-11-30 17:09:24.836122*SAAloginAllows users to log onto the system2010-11-30 17:09:24.8211222010-11-30 17:09:24.8261223WAAcbac_administrationAllows administration of CBAC modules2010-11-30 17:09:24.8061212010-11-30 17:09:24.813121/cbac_generic_role/cbac_context_role9existing_privilege_set  #= !!Etablenews_itemsnews_items CREATE TABLE "news_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "body" text, "created_at" datetime, "updated_at" datetime)_11itablecbac_privilege_setcbac_privilege_setCREATE TABLE "cbac_privilege_set" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "comment" varchar(255), "created_at" datetime, "updated_at" datetime)D;;tablecbac_staged_permissionscbac_staged_permissions +SQLite format 3@  Z--gtablecbac_membershipscbac_membershipsCREATE TABLE "cbac_memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "generic_role_id" integer, "created_at" datetime, "updated_at" datetime)R99?tablecbac_known_permissionscbac_known_permissionsCREATE TABLE "cbac_known_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permission_number" integer, "permission_type" integer DEFAULT 0)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)W11Ytablecbac_generic_rolescbac_generic_rolesCREATE TABLE "cbac_generic_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "remarks" text, "created_at" datetime, "updated_at"  Q'administratorAdministrators role. Grants full access to the entire system. 1cbac_privilege_set1cbac_privilege_set$-cbac_permissionsh-cbac_memberships41cbac_generic_roles  4  hg9authorize_context_role AW11Ytablecbac_generic_rolescbac_generic_rolesCREATE TABLE "cbac_generic_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "remarks" text, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)R99?tablecbac_known_permissionscbac_known_permissionsCREATE TABLE "cbac_known_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "permission_number" integer, "permission_type" integer DEFAULT 0)Z--gtablecbac_membershipscbac_membershipsCREATE TABLE "cbac_memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "generic_role_id" integer, "created_at" datetime, "updated_at" datetime) +--Gtablecbac_permissionscbac_permissionsCREATE TABLE "cbac_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "generic_role_id" integer DEFAULT 0, "context_role" varchar(255), "privilege_set_id" integer, "created_at" datetime, "updated_at" datetime) xxxxxxU|C AAcbac_generic_role_incor1i99AAtest_add_simple_actiontest_add_simple_action2011-02-24 21:29:50.4287732011-02-24 21:29:50.428773ggAAtest_warning_on_adding_method_with_identifiertest_warning_on_adding_method_with_identifier2011-02-24 21:29:50.4387732011-02-24 21:29:50.448773XC AAcbac_generic_role_incorrect2011-02-24 21:29:50.5187732011-02-24 21:29:50.548773^O AAtest_adding_double_privilege_sets2011-02-24 21:29:50.5587732011-02-24 21:29:50.578773wGGAAtest_adding_new_privilege_settest_adding_new_privilege_set2011-02-24 21:29:50.5887732011-02-24 21:29:50.588773iSAAtest_initializing_new_privilege_setSomething2011-02-24 21:29:50.6087732011-02-24 21:29:50.618773K) AAcbac_privilege2011-02-24 21:29:50.6287732011-02-24 21:29:50.628773WA AAbase_inheritence_privilege2011-02-24 21:29:50.6387732011-02-24 21:29:50.638773Q]AAcbac_inheritence_after_declarationPrivilegeSet/cbac_generic_role/cbac_context_role9existing_privilege_set  #= !!Etablenews_itemsnews_items CREATE TABLE "news_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "body" text, "created_at" datetime, "updated_at" datetime)_11itablecbac_privilege_setcbac_privilege_setCREATE TABLE "cbac_privilege_set" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "comment" varchar(255), "created_at" datetime, "updated_at" datetime)D;;tablecbac_staged_permissionscbac_staged_permissions CREATE TABLE "cbac_staged_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "pristine_role_id" integer, "privilege_set_name" varchar(255), "line_number" integer, "comment" varchar(255), "operation" text(2), "created_at" datetime, "updated_at" datetime)q//tablecbac_staged_rolescbac_staged_roles CREATE TABLE "cbac_staged_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "role_type" varchar(255), "name" varchar(255), "role_id" integer, "created_at" datetime, "updated_at" datetime)     D =//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)= !!Etablenews_itemsnews_items CREATE TABLE "news_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "body" text, "created_at" datetime, "updated_at" datetime)9 Qtableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "password" varchar(255), "created_at" datetime, "updated_at" datetime) )20091211120305)20091210115111)20100713162636 -)20091211120305)20091210115111)20100713162636  <o<$:1/ Acbac_generic_role2010-11-30 16:56:55.8722841/ Acbac_context_role2010-11-30 16:56:55.826282ggAAtest_warning_on_adding_method_with_identifiertest_warning_on_adding_method_with_identifier2010-11-30 16:56:55.8122812010-11-30 16:56:55.817281f~99AAtest_add_simple_actiontest_add_simple_action2010-11-30 16:56:55.8002802010-11-30 16:56:55.805280l}??AAtest_add_multiple_methodstest_add_multiple_methods2010-11-30 16:56:55.7852792010-11-30 16:56:55.792280|WWAAtest_add_method_with_single_parametertest_add_method_with_single_parameter2010-11-30 16:56:55.7722782010-11-30 16:56:55.776279{YYAAtest_add_method_with_parameter_mappingtest_add_method_with_parameter_mapping2010-11-30 16:56:55.7602782010-11-30 16:56:55.764278z[[AAtest_add_method_with_multiple_parametertest_add_method_with_multiple_parameter2010-11-30 16:56:55.7462772010-11-30 16:56:55.752277/cbac_ge?9Aexisting_privilege_setSomething2010-11-30 16:56:55.912286 +Jj@+?mAAcbac_multiple_inheritencechild PrivilegeSet for multiple inheritence test2010-11-30 16:56:55.9932912010-11-30 16:56:55.999291 -?{AAbase_multiple_inheritenceparent/ base PrivilegeSet for multiple inheritence test2010-11-30 16:56:55.9832912010-11-30 16:56:55.988291Q]AAcbac_inheritence_after_declarationPrivilegeSet for single inheritence test2010-11-30 16:56:55.9662902010-11-30 16:56:55.975290TA AAbase_inheritence_privilege2010-11-30 16:56:55.9402882010-11-30 16:56:55.944288H) AAcbac_privilege2010-11-30 16:56:55.9302872010-11-30 16:56:55.934288fSAAtest_initializing_new_privilege_setSomething2010-11-30 16:56:55.9202872010-11-30 16:56:55.924287tGGAAtest_adding_new_privilege_settest_adding_new_privilege_set2010-11-30 16:56:55.9022862010-11-30 16:56:55.906286[O AAtest_adding_double_privilege_sets2010-11-30 16:56:55.8912852010-11-30 16:56:55.897286UC AAcbac_generic_role_incorrect2010-11-30 16:56:55.8772842010-11-30 16:56:55.882285'(ggAAtest_warning_on_adding_method_with_identifiertest_warning_on_adding_method_with_identifier2010-11-27 13:55:09.5505912010-11-27 13:55:09.556591f99AAtest_add_simple_actiontest_add_simple_action2010-11-27 13:55:09.5205892010-11-27 13:55:09.529590l??AAtest_add_multiple_methodstest_add_multiple_methods2010-11-27 13:55:09.4895872010-11-27 13:55:09.512589WWAAtest_add_method_with_single_parametertest_add_method_with_single_parameter2010-11-27 13:55:09.4625862010-11-27WWAAtest_add_method_with_single_parametertest_add_method_with_single_parameter2010-11-27 13:55y;]AAcbac_single_inheritencePrivilegeSet for single inheritence test2010-11-27 15:27:09.6483222010-11-27 15:27:09.653323?mAAcbac_multiple_inheritencechild PrivilegeSet for multiple inheritence test2010-11-27 15:27:09.6133202010-11-27 15:27:09.619321 +)20091211120305)20091210115111)20100713162636  <o<$:1/ Acbac_generic_role2011-02-24 21:29:50.5087731/ Acbac_context_role2011-02-24 21:29:50.468773ggAAtest_warning_on_adding_method_with_identifiertest_warning_on_adding_method_with_identifier2011-02-24 21:29:50.4387732011-02-24 21:29:50.448773f99AAtest_add_simple_actiontest_add_simple_action2011-02-24 21:29:50.4287732011-02-24 21:29:50.428773l??AAtest_add_multiple_methodstest_add_multiple_methods2011-02-24 21:29:50.3587732011-02-24 21:29:50.378773WWAAtest_add_method_with_single_parametertest_add_method_with_single_parameter2011-02-24 21:29:50.2987732011-02-24 21:29:50.308773YYAAtest_add_method_with_parameter_mappingtest_add_method_with_parameter_mapping2011-02-24 21:29:50.2887732011-02-24 21:29:50.288773[[AAtest_add_method_with_multiple_parametertest_add_method_with_multiple_parameter2011-02-24 21:29:50.2787732011-02-24 21:29:50.278773/cbac_ge?9Aexisting_privilege_setSomething2011-02-24 21:29:50.598773 @Jj@$Q]AAcbac_inheritence_after_declarationPrivilegeSet for single inheritence test2011-02-24 21:29:50.8987742011-02-24 21:29:50.898774T#A AAbase_inheritence_privilege2011-02-24 21:29:50.6387732011-02-24 21:29:50.638773H") AAcbac_privilege2011-02-24 21:29:50.6287732011-02-24 21:29:50.628773f!SAAtest_initializing_new_privilege_setSomething2011-02-24 21:29:50.6087732011-02-24 21:29:50.618773t GGAAtest_adding_new_privilege_settest_adding_new_privilege_set2011-02-24 21:29:50.5887732011-02-24 21:29:50.588773[O AAtest_adding_double_privilege_sets2011-02-24 21:29:50.5587732011-02-24 21:29:50.578773UC AAcbac_generic_role_incorrect2011-02-24 21:29:50.5187732011-02-24 21:29:50.548773'(ggAAtest_warning_on_adding_method_with_identifiertest_warning_on_adding_method_with_identifier2010-11-27 13:55:09.5505912010-11-27 13:55:09.556591f99AAtest_add_simple_actiontest_add_simple_action2010-11-27 13:55:09.5205892010-11-27 13:55:09.529590l??AAtest_add_multiple_methodstest_add_multiple_methods2010-11-27 13:55:09.4895872010-11-27 13:55:09.512589WWAAtest_add_method_with_single_parametertest_add_method_with_single_parameter2010-11-27 13:55:09.4625862010-11-27WWAAtest_add_method_with_single_parametertest_add_method_with_single_parameter2010-11-27 13:55y;]AAcbac_single_inheritencePrivilegeSet for single inheritence test2010-11-27 15:27:09.6483222010-11-27 15:27:09.653323?mAAcbac_multiple_inheritencechild PrivilegeSet for multiple inheritence test2010-11-27 15:27:09.6133202010-11-27 15:27:09.619321 ?{AAbase_muly ;]AAcbac_single_inheritencePrivilegeSet for single inheritence test2010-11-30 16:56:56.0102922010-11-30 16:56:56.015292 \ No newline at end of file