test/schema.sql in stffn-declarative_authorization-0.2.4 vs test/schema.sql in stffn-declarative_authorization-0.2.5

- old
+ new

@@ -1,17 +1,21 @@ CREATE TABLE 'test_models' ( 'id' INTEGER PRIMARY KEY NOT NULL, 'test_attr_through_id' INTEGER, - 'content' text, + 'content' text, + 'country_id' integer, 'created_at' datetime, 'updated_at' datetime ); CREATE TABLE 'test_attrs' ( 'id' INTEGER PRIMARY KEY NOT NULL, 'test_model_id' integer, 'test_another_model_id' integer, + 'test_a_third_model_id' integer, + 'branch_id' integer, + 'company_id' integer, 'test_attr_through_id' INTEGER, 'n_way_join_item_id' INTEGER, 'test_model_security_model_id' integer, 'attr' integer default 1 ); @@ -27,6 +31,23 @@ 'attr_2' integer default 1 ); CREATE TABLE 'n_way_join_items' ( 'id' INTEGER PRIMARY KEY NOT NULL +); + +CREATE TABLE 'branches' ( + 'id' INTEGER PRIMARY KEY NOT NULL, + 'company_id' integer, + 'name' text +); + +CREATE TABLE 'companies' ( + 'id' INTEGER PRIMARY KEY NOT NULL, + 'country_id' integer, + 'name' text +); + +CREATE TABLE 'countries' ( + 'id' INTEGER PRIMARY KEY NOT NULL, + 'name' text );