create table tpm_activities (        id integer not null auto_increment,        date date,        info varchar(255),        timeSpent double precision not null,        taskId integer,        primary key (id)    ) type=InnoDB;    create table tpm_comments (        id integer not null auto_increment,        authorId integer,        authorName varchar(255),        body text not null,        date datetime,        primary key (id)    ) type=InnoDB;    create table tpm_comments_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        authorId integer,        authorName varchar(255),        body text,        date datetime,        primary key (id, revision)    ) type=InnoDB;    create table tpm_demo_accounts (        id integer not null auto_increment,        disabled bit not null,        expirationDate datetime,        registrationDate datetime,        projectId integer,        primary key (id)    ) type=InnoDB;    create table tpm_features (        code varchar(64) not null,        position integer,        primary key (code)    ) type=InnoDB;    create table tpm_history_events (        id integer not null auto_increment,        actionType varchar(255),        auditableClassName varchar(255),        auditableIdentifier varchar(255),        auditableName varchar(255),        auditableReferenced bit,        parameters varchar(255),        projectCode varchar(16),        projectId integer,        timestamp datetime,        userId integer,        userName varchar(64),        primary key (id)    ) type=InnoDB;    create table tpm_iterations (        id integer not null auto_increment,        duration integer not null check (duration<=100),        name varchar(128) not null,        position integer,        startDate date not null,        projectId integer,        primary key (id)    ) type=InnoDB;    create table tpm_iterations_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        duration integer,        name varchar(128),        position integer,        startDate date,        projectId integer,        primary key (id, revision)    ) type=InnoDB;    create table tpm_licenses (        id integer not null auto_increment,        data blob,        primary key (id)    ) type=InnoDB;    create table tpm_logo (        id integer not null auto_increment,        image mediumblob,        primary key (id)    ) type=InnoDB;    create table tpm_priorities (        id integer not null auto_increment,        name varchar(32) not null,        priority integer not null,        primary key (id)    ) type=InnoDB;    create table tpm_priorities_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        name varchar(32),        priority integer,        primary key (id, revision)    ) type=InnoDB;    create table tpm_privilege_group_features (        featureCode varchar(64) not null,        privilegeGroupCode varchar(255),        primary key (featureCode)    ) type=InnoDB;    create table tpm_privilege_groups (        code varchar(255) not null,        position integer,        primary key (code)    ) type=InnoDB;    create table tpm_project_comments (        projectId integer not null,        commentId integer not null,        unique (commentId)    ) type=InnoDB;    create table tpm_project_comments_versions (        projectId integer not null,        commentId integer not null,        revision integer not null,        revisionType tinyint,        primary key (projectId, commentId, revision)    ) type=InnoDB;    create table tpm_project_estimation_scale (        projectId integer not null,        element double precision    ) type=InnoDB;    create table tpm_project_users (        projectId integer not null,        userId integer not null    ) type=InnoDB;    create table tpm_project_users_versions (        projectId integer not null,        userId integer not null,        revision integer not null,        revisionType tinyint,        primary key (projectId, userId, revision)    ) type=InnoDB;    create table tpm_projects (        id integer not null auto_increment,        active bit not null,        createdAt datetime,        createdBy varchar(255),        lastModifiedAt datetime,        lastModifiedBy varchar(255),        code varchar(16) not null unique,        defaultTask varchar(255),        description text,        iterationLength integer not null check (iterationLength<=100),        name varchar(64) not null,        startDate date not null,        targetFinishDate date,        ownerId integer,        primary key (id)    ) type=InnoDB;    create table tpm_projects_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        active bit,        createdAt datetime,        createdBy varchar(255),        lastModifiedAt datetime,        lastModifiedBy varchar(255),        code varchar(16),        defaultTask varchar(255),        description text,        iterationLength integer,        name varchar(64),        startDate date,        targetFinishDate date,        ownerId integer,        primary key (id, revision)    ) type=InnoDB;    create table tpm_properties (        code varchar(255) not null,        value varchar(255),        primary key (code)    ) type=InnoDB;    create table tpm_revisions (        id integer not null auto_increment,        timestamp bigint not null,        userId integer,        userName varchar(64),        historyEventId integer,        primary key (id)    ) type=InnoDB;    create table tpm_role_features (        roleId integer not null,        featureCode varchar(64) not null    ) type=InnoDB;    create table tpm_roles (        id integer not null auto_increment,        name varchar(64) not null,        primary key (id)    ) type=InnoDB;    create table tpm_roles_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        name varchar(64),        primary key (id, revision)    ) type=InnoDB;    create table tpm_system_events (        id integer not null auto_increment,        code varchar(255) not null unique,        primary key (id)    ) type=InnoDB;    create table tpm_tags (        id integer not null auto_increment,        value varchar(255) not null,        primary key (id)    ) type=InnoDB;    create table tpm_tags_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        value varchar(255),        primary key (id, revision)    ) type=InnoDB;    create table tpm_task_assigned_users (        taskId integer not null,        assignedUsersId integer not null    ) type=InnoDB;    create table tpm_task_assigned_users_versions (        taskId integer not null,        assignedUsersId integer not null,        revision integer not null,        revisionType tinyint,        primary key (taskId, assignedUsersId, revision)    ) type=InnoDB;    create table tpm_task_comments (        taskId integer not null,        commentId integer not null,        unique (commentId)    ) type=InnoDB;    create table tpm_task_comments_versions (        taskId integer not null,        commentId integer not null,        revision integer not null,        revisionType tinyint,        primary key (taskId, commentId, revision)    ) type=InnoDB;    create table tpm_tasks (        id integer not null auto_increment,        createdAt datetime,        createdBy varchar(255),        lastModifiedAt datetime,        lastModifiedBy varchar(255),        completedAt datetime,        description text,        name varchar(128) not null,        startedAt datetime,        status integer,        userStoryId integer,        primary key (id)    ) type=InnoDB;    create table tpm_tasks_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        createdAt datetime,        createdBy varchar(255),        lastModifiedAt datetime,        lastModifiedBy varchar(255),        completedAt datetime,        description text,        name varchar(128),        startedAt datetime,        status integer,        userStoryId integer,        primary key (id, revision)    ) type=InnoDB;    create table tpm_user_events (        userId integer not null,        eventsId integer not null    ) type=InnoDB;    create table tpm_user_properties (        code varchar(255) not null,        userId integer not null,        value varchar(255),        primary key (code, userId)    ) type=InnoDB;    create table tpm_user_stories (        id integer not null auto_increment,        acceptanceStatus varchar(255),        createdAt datetime,        createdBy varchar(255),        lastModifiedAt datetime,        lastModifiedBy varchar(255),        color varchar(255),        description text,        estimatedEffort double precision,        name varchar(128) not null,        projectId integer,        acceptingUserId integer,        iterationId integer,        priorityId integer,        ownerId integer,        primary key (id)    ) type=InnoDB;    create table tpm_user_stories_versions (        id integer not null,        revision integer not null,        revisionType tinyint,        acceptanceStatus varchar(255),        createdAt datetime,        createdBy varchar(255),        lastModifiedAt datetime,        lastModifiedBy varchar(255),        color varchar(255),        description text,        estimatedEffort double precision,        name varchar(128),        acceptingUserId integer,        iterationId integer,        ownerId integer,        priorityId integer,        projectId integer,        primary key (id, revision)    ) type=InnoDB;    create table tpm_user_story_tags (        userStoryId integer not null,