schema.sql

-- Database schema for practice tools

-- Speed Standards tool
DELIMITER //

CREATE PROCEDURE IF NOT EXISTS init_speed_standards()
BEGIN
    DECLARE table_exists INT DEFAULT 0;

    SELECT COUNT(*) INTO table_exists
    FROM information_schema.tables
    WHERE table_schema = DATABASE()
    AND table_name = 'speed_standards_songs';

    IF table_exists = 0 THEN
        CREATE TABLE speed_standards_songs (
            id INT AUTO_INCREMENT PRIMARY KEY,
            title VARCHAR(255) NOT NULL,
            achieved DECIMAL(6,2) DEFAULT 0.00,
            target DECIMAL(6,2) DEFAULT 0.00,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
            INDEX idx_title (title)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

        -- Insert initial repertoire data (only runs if table was just created)
        INSERT INTO speed_standards_songs (title, achieved, target) VALUES
    ('Alone together', 72, 160),
    ('Beatrice', 0, 0),
    ('Blue in green', 50, 66),
    ('Body and soul', 48, 48),
    ('Footprints', 108, 180),
    ('God bless the child', 0, 0),
    ('I hear a rhapsody', 0, 0),
    ('I love you', 0, 0),
    ('I''ll remember April', 0, 0),
    ('Invitation', 0, 0),
    ('Lover man', 0, 0),
    ('Nostalgia in Times Square', 0, 0),
    ('Prelude to a kiss', 0, 0),
    ('Round midnight', 0, 0),
    ('Tenderly', 0, 0),
    ('Solar', 0, 0),
    ('The night has a thousand eyes', 0, 0),
    ('Some day my Prince will come', 0, 0),
    ('What is this thing called love', 0, 0),
    ('Beautiful love', 49.78, 160),
    ('Oleo', 0, 0),
    ('Night dreamer', 0, 0);
    END IF;
END//

DELIMITER ;

-- Run initialization
CALL init_speed_standards();

-- Clean up procedure
DROP PROCEDURE IF EXISTS init_speed_standards;

-- Strategy Cards tool
DELIMITER //

CREATE PROCEDURE IF NOT EXISTS init_strategy_cards()
BEGIN
    DECLARE table_exists INT DEFAULT 0;

    SELECT COUNT(*) INTO table_exists
    FROM information_schema.tables
    WHERE table_schema = DATABASE()
    AND table_name = 'strategy_cards';

    IF table_exists = 0 THEN
        CREATE TABLE strategy_cards (
            id INT AUTO_INCREMENT PRIMARY KEY,
            content TEXT NOT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

        -- Insert initial example data
        INSERT INTO strategy_cards (content) VALUES
            ('Loop some shit'),
            ('Fray out, focus in'),
            ('Meta-reflection'),
            ('Copy somebody'),
            ('You focused on X, but it could have been Y'),
            ('Maybe I can be an alternative to that [thing I can’t do]'),
            ('Sing portraying a character of your voice'),
            ('Maybe you can contrast crispness and clouds'),
            ('Move to a different medium'),
            ('Try recording backwards and in combination with doubling'),
            ('Define goals you want achieve by the end, then go about reaching those goals'),
            ('Do the thing you’re trying to avoid'),
            ('Stop worrying about the start and finish, work out the middle'),
            ('Can probably be way simpler than you think'),
            ('Well could you change [arbitrary element]…?'),
            ('Introduce one quirky thing and draw concentric lines around it'),
            ('Cast a wide net'),
            ('More is more'),
            ('Clave. Make it groove'),
            ('Come up with a big picture of the sound'),
            ('Take a “cleaning” approach: work on dirtiest spot. Get it done before the guests arrive!'),
            ('Defer unconscious acts. Add them to a temporary flow chart'),
            ('Compose by mood instead of chord'),
            ('Start with the most simple elements, such as a metronome click'),
            ('Have one clear idea'),
            ('Be water. Or be something else. So many things you could be.'),
            ('You don’t see things as they are. You see things as you are.'),
            ('You see something on a different wavelength to you. Try to get in sync with it as an experiment'),
            ('Do all your recording, mixing, etc. on laptop, phone, little speakers. Help you to ignore things'),
            ('To locate things establish an ordering of groups?'),
            ('What would the voice of normalcy say? Find it and inject a little bit. Or establish a normal framework to work within.'),
            ('You gotta be out to be about'),
            ('Remember: Engage in potentially constructive dialogue'),
            ('Find awe. (For happiness, find awe)'),
            ('Get wooden letters of the alphabet and use them as physical cues to remember things'),
            ('life’s about reducing the amount of things you’ll regret later'),
            ('When you feel "the others are against me", respond with empathic, pro-social behaviour!'),
            ('Reflect also on why things went well, and why. For example, if you have a productive day, why was it productive? Keep a record'),
            ('Dimension to modulate: more narrow versus more divergent associations'),
            ('Make a pain proportional investment'),
            ('Once it’s clear what adds value: optimize for that, and everything else, buy!'),
            ('Shorten the feedback loop. Minimize it!'),
            ('Try not to do anything that isn’t necessary'),
            ('Powers of ten method'),
            ('5 whys Taiichi Ohno'),
            ('“Is there anything else I should have asked?”'),
            ('“Who else should I talk to?”');
    END IF;
END//

DELIMITER ;

-- Run initialization
CALL init_strategy_cards();

-- Clean up procedure
DROP PROCEDURE IF EXISTS init_strategy_cards;