Index: lams_common/db/sql/create_lams_11_tables.sql =================================================================== diff -u -r1fe0f4f546903187be6f35e4d5c027853da9408c -r8300f0d96f19f17ea059dc59663a61cace7d583a --- lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 1fe0f4f546903187be6f35e4d5c027853da9408c) +++ lams_common/db/sql/create_lams_11_tables.sql (.../create_lams_11_tables.sql) (revision 8300f0d96f19f17ea059dc59663a61cace7d583a) @@ -317,6 +317,8 @@ , portrait_uuid BIGINT(20) , change_password TINYINT DEFAULT 0 , enable_flash TINYINT(1) DEFAULT 1 + , lams_community_token VARCHAR(255) + , lams_community_username VARCHAR(255) , PRIMARY KEY (user_id) , INDEX (authentication_method_id) , CONSTRAINT FK_lams_user_1 FOREIGN KEY (authentication_method_id) @@ -1056,4 +1058,20 @@ , patch_in_progress CHAR(1) NOT NULL DEFAULT 'F' , PRIMARY KEY (system_name) )TYPE=InnoDB; + +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; + + \ No newline at end of file