cs-1.2.276.0.76.5.438-2015-03-03T000000.sql

        --DROP TABLE manchestertriagesystem CASCADE;
        CREATE TABLE manchestertriagesystem (
            manchestertriagesystem_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL,
            statusCode varchar(255),
            effectiveDate varchar(255),
            expirationDate varchar(255),
            officialReleaseDate varchar(255),
        );
        
            INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (1, '1', '1.2.276.0.76.5.438', 'sofort - rot - 0 Minuten', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (2, '2', '1.2.276.0.76.5.438', 'sehr dringend - orange - 10 Minuten', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (3, '3', '1.2.276.0.76.5.438', 'dringend - gelb - 30 Minuten', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (4, '4', '1.2.276.0.76.5.438', 'normal - grün - 90 Minuten', 'active', '2015-03-03T00:00:00', '', '');
        
            INSERT INTO manchestertriagesystem (manchestertriagesystem_id, code, codeSystem, displayName, statusCode, effectiveDate, expirationDate, officialReleaseDate)
            VALUES (5, '5', '1.2.276.0.76.5.438', 'nicht dringend - blau - 120 Minuten', 'active', '2015-03-03T00:00:00', '', '');