Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql =================================================================== diff -u -r7bdba5eda1d29c67b71ec3c8a643cab7f27890cd -ra88f61d1992e0842c274ee3023b25e6421b569a1 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql (.../patch0015_updateFrom22.sql) (revision 7bdba5eda1d29c67b71ec3c8a643cab7f27890cd) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql (.../patch0015_updateFrom22.sql) (revision a88f61d1992e0842c274ee3023b25e6421b569a1) @@ -21,6 +21,24 @@ insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) values ('SMTPPassword','', 'config.smtp.password', 'config.header.email', 'STRING', 0); +-- LDEV-2099 -------------- +ALTER TABLE lams_user ADD COLUMN lams_community_token VARCHAR(255); +ALTER TABLE lams_user ADD COLUMN lams_community_username VARCHAR(255); + +CREATE TABLE lams_registration ( + uid BIGINT NOT NULL auto_increment + , site_name VARCHAR(255) NOT NULL + , organisation VARCHAR(255) NOT NULL + , name VARCHAR(255) NOT NULL + , email VARCHAR(255) NOT NULL + , server_country VARCHAR(2) NOT NULL + , public_directory TINYINT(1) DEFAULT 1 + , enable_lams_community TINYINT(1) DEFAULT 0 + , server_key VARCHAR(255) NOT NULL + , server_id VARCHAR(255) NOT NULL + , PRIMARY KEY (uid) +)TYPE=InnoDB; + -- LDEV-2107 -------------- INSERT into lams_workspace_folder_type VALUES (3, 'PUBLIC SEQUENCES');