create_schema-1.2.sql

tinypm敏捷开发工具是一界面简单功能齐全的敏捷开发工具 适合初学者使用

        tagId integer not null,
        unique (tagId)
    ) type=InnoDB;

    create table tpm_user_story_tags_versions (
        userStoryId integer not null,
        tagId integer not null,
        revision integer not null,
        revisionType tinyint,
        primary key (userStoryId, tagId, revision)
    ) type=InnoDB;

    create table tpm_users (
        id integer not null auto_increment,
        active bit,
        email varchar(255),
        login varchar(32) not null unique,
        name varchar(64) not null,
        password varchar(32) not null,
        roleId integer,
        primary key (id)
    ) type=InnoDB;

    create table tpm_users_versions (
        id integer not null,
        revision integer not null,
        revisionType tinyint,
        active bit,
        email varchar(255),
        login varchar(32),
        name varchar(64),
        password varchar(32),
        roleId integer,
        primary key (id, revision)
    ) type=InnoDB;

    create table tpm_userstory_comments (
        userStoryId integer not null,
        comment integer not null,
        unique (comment)
    ) type=InnoDB;

    create table tpm_userstory_comments_versions (
        userStoryId integer not null,
        comment integer not null,
        revision integer not null,
        revisionType tinyint,
        primary key (userStoryId, comment, revision)
    ) type=InnoDB;

    create table tpm_wiki_attachments (
        id integer not null auto_increment,
        content mediumblob,
        name varchar(255),
        size integer,
        wikiPageId integer,
        primary key (id)
    ) type=InnoDB;

    create table tpm_wiki_pages (
        id integer not null auto_increment,
        createdAt datetime,
        createdBy varchar(255),
        lastModifiedAt datetime,
        lastModifiedBy varchar(255),
        code varchar(255) unique,
        text text,
        projectId integer,
        primary key (id)
    ) type=InnoDB;

    alter table tpm_activities 
        add index FKB36F2F7B6BF38F65 (taskId), 
        add constraint FKB36F2F7B6BF38F65 
        foreign key (taskId) 
        references tpm_tasks (id);

    alter table tpm_comments_versions 
        add index FK294FD538BA619436 (revision), 
        add constraint FK294FD538BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_demo_accounts 
        add index FK5C03987474EB8C8D (projectId), 
        add constraint FK5C03987474EB8C8D 
        foreign key (projectId) 
        references tpm_projects (id);

    alter table tpm_iterations 
        add index FKD0ECE0C474EB8C8D (projectId), 
        add constraint FKD0ECE0C474EB8C8D 
        foreign key (projectId) 
        references tpm_projects (id);

    alter table tpm_iterations_versions 
        add index FK52DD6BB6BA619436 (revision), 
        add constraint FK52DD6BB6BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_priorities_versions 
        add index FK1FCBB52ABA619436 (revision), 
        add constraint FK1FCBB52ABA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_privilege_group_features 
        add index FKBB39C0594FE4A829 (privilegeGroupCode), 
        add constraint FKBB39C0594FE4A829 
        foreign key (privilegeGroupCode) 
        references tpm_privilege_groups (code);

    alter table tpm_privilege_group_features 
        add index FKBB39C0596BE28459 (featureCode), 
        add constraint FKBB39C0596BE28459 
        foreign key (featureCode) 
        references tpm_features (code);

    alter table tpm_project_comments 
        add index FK2643C16874EB8C8D (projectId), 
        add constraint FK2643C16874EB8C8D 
        foreign key (projectId) 
        references tpm_projects (id);

    alter table tpm_project_comments 
        add index FK2643C1689C3B1999 (commentId), 
        add constraint FK2643C1689C3B1999 
        foreign key (commentId) 
        references tpm_comments (id);

    alter table tpm_project_comments_versions 
        add index FK604F0392BA619436 (revision), 
        add constraint FK604F0392BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_project_estimation_scale 
        add index FKF5C8BF8A74EB8C8D (projectId), 
        add constraint FKF5C8BF8A74EB8C8D 
        foreign key (projectId) 
        references tpm_projects (id);

    alter table tpm_project_users 
        add index FK18AE7F1474EB8C8D (projectId), 
        add constraint FK18AE7F1474EB8C8D 
        foreign key (projectId) 
        references tpm_projects (id);

    alter table tpm_project_users 
        add index FK18AE7F146EA08271 (userId), 
        add constraint FK18AE7F146EA08271 
        foreign key (userId) 
        references tpm_users (id);

    alter table tpm_project_users_versions 
        add index FKDF00E766BA619436 (revision), 
        add constraint FKDF00E766BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_projects 
        add index FK6DB0978861976F59 (ownerId), 
        add constraint FK6DB0978861976F59 
        foreign key (ownerId) 
        references tpm_users (id);

    alter table tpm_projects_versions 
        add index FKA0211172BA619436 (revision), 
        add constraint FKA0211172BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_revisions 
        add index FK9BDAA6AA256B0D07 (historyEventId), 
        add constraint FK9BDAA6AA256B0D07 
        foreign key (historyEventId) 
        references tpm_history_events (id);

    alter table tpm_role_features 
        add index FK26A7398694B2D07 (roleId), 
        add constraint FK26A7398694B2D07 
        foreign key (roleId) 
        references tpm_roles (id);

    alter table tpm_role_features 
        add index FK26A73986BE28459 (featureCode), 
        add constraint FK26A73986BE28459 
        foreign key (featureCode) 
        references tpm_features (code);

    alter table tpm_roles_versions 
        add index FK8C4E26BBA619436 (revision), 
        add constraint FK8C4E26BBA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_tags_versions 
        add index FK8247C1B3BA619436 (revision), 
        add constraint FK8247C1B3BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_task_assigned_users 
        add index FKE254F6836BF38F65 (taskId), 
        add constraint FKE254F6836BF38F65 
        foreign key (taskId) 
        references tpm_tasks (id);

    alter table tpm_task_assigned_users 
        add index FKE254F68359B5F7E0 (assignedUsersId), 
        add constraint FKE254F68359B5F7E0 
        foreign key (assignedUsersId) 
        references tpm_users (id);

    alter table tpm_task_assigned_users_versions 
        add index FK9F885CD7BA619436 (revision), 
        add constraint FK9F885CD7BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_task_comments 
        add index FK2D1DF9209C3B1999 (commentId), 
        add constraint FK2D1DF9209C3B1999 
        foreign key (commentId) 
        references tpm_comments (id);

    alter table tpm_task_comments 
        add index FK2D1DF9206BF38F65 (taskId), 
        add constraint FK2D1DF9206BF38F65 
        foreign key (taskId) 
        references tpm_tasks (id);

    alter table tpm_task_comments_versions 
        add index FKCACBFADABA619436 (revision), 
        add constraint FKCACBFADABA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_tasks 
        add index FKD03A0740839A160F (userStoryId), 
        add constraint FKD03A0740839A160F 
        foreign key (userStoryId) 
        references tpm_user_stories (id);

    alter table tpm_tasks_versions 
        add index FK748DD0BABA619436 (revision), 
        add constraint FK748DD0BABA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_user_events 
        add index FKD06BA63FD7C5AD1F (eventsId), 
        add constraint FKD06BA63FD7C5AD1F 
        foreign key (eventsId) 
        references tpm_system_events (id);

    alter table tpm_user_events 
        add index FKD06BA63F6EA08271 (userId), 
        add constraint FKD06BA63F6EA08271 
        foreign key (userId) 
        references tpm_users (id);

    alter table tpm_user_stories 
        add index FK1EC53FEDCE514BE3 (priorityId), 
        add constraint FK1EC53FEDCE514BE3 
        foreign key (priorityId) 
        references tpm_priorities (id);

    alter table tpm_user_stories 
        add index FK1EC53FED3A161315 (iterationId), 
        add constraint FK1EC53FED3A161315 
        foreign key (iterationId) 
        references tpm_iterations (id);

    alter table tpm_user_stories 
        add index FK1EC53FED74EB8C8D (projectId), 
        add constraint FK1EC53FED74EB8C8D 
        foreign key (projectId) 
        references tpm_projects (id);

    alter table tpm_user_stories 
        add index FK1EC53FEDAA149CCB (acceptingUserId), 
        add constraint FK1EC53FEDAA149CCB 
        foreign key (acceptingUserId) 
        references tpm_users (id);

    alter table tpm_user_stories 
        add index FK1EC53FED61976F59 (ownerId), 
        add constraint FK1EC53FED61976F59 
        foreign key (ownerId) 
        references tpm_users (id);

    alter table tpm_user_stories_versions 
        add index FK78C30AADBA619436 (revision), 
        add constraint FK78C30AADBA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_user_story_tags 
        add index FKE7250749839A160F (userStoryId), 
        add constraint FKE7250749839A160F 
        foreign key (userStoryId) 
        references tpm_user_stories (id);

    alter table tpm_user_story_tags 
        add index FKE7250749EAB5194F (tagId), 
        add constraint FKE7250749EAB5194F 
        foreign key (tagId) 
        references tpm_tags (id);

    alter table tpm_user_story_tags_versions 
        add index FK8C97CAD1BA619436 (revision), 
        add constraint FK8C97CAD1BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_users 
        add index FKD05019BA694B2D07 (roleId), 
        add constraint FKD05019BA694B2D07 
        foreign key (roleId) 
        references tpm_roles (id);

    alter table tpm_users_versions 
        add index FKC22BE780BA619436 (revision), 
        add constraint FKC22BE780BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_userstory_comments 
        add index FK4F5CC17839A160F (userStoryId), 
        add constraint FK4F5CC17839A160F 
        foreign key (userStoryId) 
        references tpm_user_stories (id);

    alter table tpm_userstory_comments 
        add index FK4F5CC172DFD283E (comment), 
        add constraint FK4F5CC172DFD283E 
        foreign key (comment) 
        references tpm_comments (id);

    alter table tpm_userstory_comments_versions 
        add index FKC67C8DC3BA619436 (revision), 
        add constraint FKC67C8DC3BA619436 
        foreign key (revision) 
        references tpm_revisions (id);

    alter table tpm_wiki_attachments 
        add index FK312462AFD27D8679 (wikiPageId), 
        add constraint FK312462AFD27D8679 
        foreign key (wikiPageId) 
        references tpm_wiki_pages (id);

    alter table tpm_wiki_pages 
        add index FK5D89720374EB8C8D (projectId), 
        add constraint FK5D89720374EB8C8D 
        foreign key (projectId) 
        references tpm_projects (id);