Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -ree1d3b43703292593ead74d5d38121490b620a02 -rbaa2dacb7b58a7543652a196e880d3f4a060c6cb --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision ee1d3b43703292593ead74d5d38121490b620a02) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision baa2dacb7b58a7543652a196e880d3f4a060c6cb) @@ -209,7 +209,7 @@ , create_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , authentication_method_id BIGINT(20) NOT NULL DEFAULT 0 , workspace_id BIGINT(20) - , base_organisation_id BIGINT(20) NOT NULL DEFAULT 0 + , base_organisation_id BIGINT(20) , PRIMARY KEY (user_id) , INDEX (authentication_method_id) , CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id) Index: lams_common/db/sql/create_lams_db.sql =================================================================== diff -u -rc81b345a12784e7be6e9c9853acf75522fd88fc0 -rbaa2dacb7b58a7543652a196e880d3f4a060c6cb --- lams_common/db/sql/create_lams_db.sql (.../create_lams_db.sql) (revision c81b345a12784e7be6e9c9853acf75522fd88fc0) +++ lams_common/db/sql/create_lams_db.sql (.../create_lams_db.sql) (revision baa2dacb7b58a7543652a196e880d3f4a060c6cb) @@ -245,7 +245,7 @@ , create_date DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , authentication_method_id BIGINT(20) NOT NULL DEFAULT 0 , workspace_id BIGINT(20) - , base_organisation_id BIGINT(20) NOT NULL DEFAULT 0 + , base_organisation_id BIGINT(20) , PRIMARY KEY (user_id) , INDEX (authentication_method_id) , CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id)