use gitb;
CREATE TABLE communities (
  id BIGINT(20) NOT NULL AUTO_INCREMENT,
  sname VARCHAR(254) NOT NULL,
  fname VARCHAR(254) NOT NULL,
  domain BIGINT(20) NULL DEFAULT NULL,
  PRIMARY KEY (id));
ALTER TABLE organizations ADD COLUMN community BIGINT(20) NOT NULL AFTER legal_notice;
ALTER TABLE testresults CHANGE COLUMN start_time start_time TIMESTAMP NOT NULL DEFAULT '1970-01-01 00:00:01', CHANGE COLUMN end_time end_time TIMESTAMP NULL DEFAULT NULL;
insert into communities(id, sname, fname) values(0, 'Default community', 'Default community');
update communities set id = 0;
ALTER TABLE organizations ADD COLUMN admin_organization TINYINT(4) NOT NULL DEFAULT '0' AFTER type;
UPDATE organizations SET admin_organization = '1' WHERE id = '0';
ALTER TABLE landingpages ADD COLUMN community BIGINT(20) NOT NULL AFTER description;
ALTER TABLE legalnotices ADD COLUMN community BIGINT(20) NOT NULL AFTER description;
ALTER TABLE legalnotices DROP INDEX unique_name;
ALTER TABLE landingpages DROP INDEX unique_name;
commit;