voc-2.16.840.1.113883.1.11.14570-2014-03-26T000000.sql

    --DROP TABLE AdministrableDrugForm CASCADE;
    CREATE TABLE AdministrableDrugForm (
            AdministrableDrugForm_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (1, 'APPFUL', '2.16.840.1.113883.5.85', 'Applicatorful');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (2, 'PUFF', '2.16.840.1.113883.5.85', 'Puff');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (3, 'SCOOP', '2.16.840.1.113883.5.85', 'Scoops');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (4, 'SPRY', '2.16.840.1.113883.5.85', 'Sprays');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (5, 'DROP', '2.16.840.1.113883.5.85', 'Drops');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (6, 'NDROP', '2.16.840.1.113883.5.85', 'Nasal Drops');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (7, 'OPDROP', '2.16.840.1.113883.5.85', 'Ophthalmic Drops');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (8, 'ORDROP', '2.16.840.1.113883.5.85', 'Oral Drops');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (9, 'OTDROP', '2.16.840.1.113883.5.85', 'Otic Drops');
        
    --DROP TABLE AdministrableDrugForm CASCADE;
    CREATE TABLE AdministrableDrugForm (
            AdministrableDrugForm_id int NOT NULL PRIMARY KEY,
            code varchar(255) NOT NULL,
            codeSystem varchar(255) NOT NULL,
            displayName varchar(255) NOT NULL
        );
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (1, 'APPFUL', '2.16.840.1.113883.5.85', 'Applicatorful');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (2, 'PUFF', '2.16.840.1.113883.5.85', 'Puff');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (3, 'SCOOP', '2.16.840.1.113883.5.85', 'Scoops');
        
    INSERT INTO AdministrableDrugForm (AdministrableDrugForm_id, code, codeSystem, displayName)
            VALUES (4, 'SPRY', '2.16.840.1.113883.5.85', 'Sprays');