spade-fork/db/spawn/create_configurations.sql @ cbfa8568

USE authspade;

CREATE TABLE IF NOT EXISTS configurations (
    id INT AUTO_INCREMENT PRIMARY KEY,
    configHash VARCHAR(255),
    config TEXT NOT NULL,
    isDefault CHAR(1) NOT NULL,
    defaultConfigName VARCHAR(255)
);

CREATE TABLE IF NOT EXISTS user_configurations (
    userId INT NOT NULL,
    configId INT NOT NULL,
    configurationName VARCHAR(255) NOT NULL,
    FOREIGN KEY (userId) REFERENCES users(id),
    FOREIGN KEY (configId) REFERENCES configurations(id),
    PRIMARY KEY (userId, configId)
);

INSERT INTO configurations (config, isDefault, defaultConfigName) VALUES (
    '{
    "configuration": [
        {
            "antiPattern": "TooLongSprint",
            "thresholds": [
                {
                    "thresholdName": "maxIterationLength",
                    "value": "21"
                },
                {
                    "thresholdName": "maxNumberOfTooLongIterations",
                    "value": "0"
                }
            ]
        },
        {
            "antiPattern": "VaryingSprintLength",
            "thresholds": [
                {
                    "thresholdName": "maxDaysDifference",
                    "value": "7"
                },
                {
                    "thresholdName": "maxIterationChanged",
                    "value": "1"
                }
            ]
        },
        {
            "antiPattern": "BusinessAsUsual",
            "thresholds": [
                {
                    "thresholdName": "divisionOfIterationsWithRetrospective",
                    "value": "66.66f"
                },
                {
                    "thresholdName": "searchSubstringsWithRetrospective",
                    "value": "%retr%||%revi%||%week%scrum%"
                }
            ]
        },
        {
            "antiPattern": "SpecifyNothing",
            "thresholds": [
                {
                    "thresholdName": "minNumberOfWikiPagesWithSpecification",
                    "value": "1"
                },
                {
                    "thresholdName": "minNumberOfActivitiesWithSpecification",
                    "value": "1"
                },
                {
                    "thresholdName": "minAvgLengthOfActivityDescription",
                    "value": "150"
                },
                {
                    "thresholdName": "searchSubstringsWithProjectSpecification",
                    "value": "%dsp%||%specifikace%||%specification%||%vize%proj%||%vize%produ%"
                }
            ]
        },
        {
            "antiPattern": "RoadToNowhere",
            "thresholds": [
                {
                    "thresholdName": "minNumberOfWikiPagesWithProjectPlan",
                    "value": "1"
                },
                {
                    "thresholdName": "minNumberOfActivitiesWithProjectPlan",
                    "value": "1"
                },
                {
                    "thresholdName": "searchSubstringsWithProjectPlan",
                    "value": "%pl n projektu%||%project plan%||%plan project%||%projektov  pl n%"
                }
            ]
        },
        {
            "antiPattern": "LongOrNonExistentFeedbackLoops",
            "thresholds": [
                {
                    "thresholdName": "divisionOfIterationsWithFeedbackLoop",
                    "value": "50.00f"
                },
                {
                    "thresholdName": "maxGapBetweenFeedbackLoopRate",
                    "value": "2f"
                },
                {
                    "thresholdName": "searchSubstringsWithFeedbackLoop",
                    "value": "%sch z%z kazn k%||%p edveden %z kazn k%||%z kazn%demo%||%sch z%zadavat%||%inform%sch z%||%z kazn%||%zadavatel%"
                }
            ]
        },
        {
            "antiPattern": "NinetyNinetyRule",
            "thresholds": [
                {
                    "thresholdName": "maxDivisionRange",
                    "value": "1.25f"
                },
                {
                    "thresholdName": "maxBadDivisionLimit",
                    "value": "2"
                }
            ]
        },
        {
            "antiPattern": "UnknownPoster",
            "thresholds": [
                {
                    "thresholdName": "searchSubstringsInvalidNames",
                    "value": "%unknown%||%anonym%"
                }
            ]
        },
        {
            "antiPattern": "BystanderApathy",
            "thresholds": [
                {
                    "thresholdName": "searchSubstringsInvalidContributors",
                    "value": "%dependabot%"
                },
                {
                    "thresholdName": "maximumPercentageOfTasksWithoutTeamwork",
                    "value": "30f"
                }
            ]
        },
        {
            "antiPattern": "YetAnotherProgrammer",
            "thresholds": [
                {
                    "thresholdName": "maxNumberOfNewContributors",
                    "value": "5"
                },
                {
                    "thresholdName": "numberOfFirstMonthsWithoutDetection",
                    "value": "2"
                }
            ]
        }
    ]
}',
    'Y', 'default configuration'
);