IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'GoodsForm')
BEGIN
    CREATE TABLE [dbo].[GoodsForm]
    (
        [Id] [INT] IDENTITY(1, 1) NOT NULL,
        [Code] [VARCHAR](10) NULL,
        [Name] [NVARCHAR](MAX) NULL,
        CONSTRAINT [PK_tblGoodsForm]
            PRIMARY KEY CLUSTERED ([Id] ASC)
    ) ON [PRIMARY];

    INSERT [dbo].[GoodsForm]
    VALUES
    ('00346', 'Aerosol'),
    ('00349', 'Ampoule'),
    ('00347', 'Ampoule Inhaler'),
    ('00351', 'Beads'),
    ('01881', 'Buccal'),
    ('02933', 'Buccal Gel'),
    ('00352', 'Bulk'),
    ('00354', 'Capsule'),
    ('02729', 'Capsule (Soft Gel),'),
    ('00871', 'Capsule Inhaler'),
    ('00355', 'Cartrige'),
    ('02932', 'Chewable F.C. Tablet'),
    ('00815', 'Chewable Tablet'),
    ('00356', 'Chewing Gum'),
    ('02922', 'Concentrated for Infusio'),
    ('01874', 'Concentrated Solutio'),
    ('02891', 'Concentrated Solution for Infusio'),
    ('00357', 'Cream'),
    ('02927', 'Dental Gel'),
    ('00360', 'Disinfectant'),
    ('02737', 'Dispersible Tablet'),
    ('02739', 'Double Scored Tablet'),
    ('00879', 'Douch Vaginal'),
    ('00361', 'Drop'),
    ('00810', 'E.C. Tablet'),
    ('00410', 'Effervescent Tablet'),
    ('00365', 'Elixir'),
    ('00366', 'Enema'),
    ('02897', 'Extended Release Capsule'),
    ('02731', 'Extended Release Tablet'),
    ('01877', 'F.C. Tablet'),
    ('00368', 'Foam'),
    ('01880', 'For Infusio'),
    ('00870', 'For Inhalatio'),
    ('00869', 'For Inhale'),
    ('01878', 'For Injectio'),
    ('02712', 'For Injection Concentrate'),
    ('00377', 'For Irrigatio'),
    ('01879', 'For Suspensio'),
    ('02941', 'Gel'),
    ('02380', 'Gel Ophtalmic'),
    ('00826', 'Granul for Susp.'),
    ('00835', 'Granule'),
    ('02939', 'Granule For Oral Suspensio'),
    ('02940', 'Hand Gel'),
    ('00373', 'Implant'),
    ('00375', 'Inhalation Device'),
    ('00868', 'Inhaler'),
    ('00374', 'Injectable Solution (Infusion)'),
    ('02725', 'Injectable Suspensio'),
    ('00376', 'Injectio'),
    ('00378', 'Liquid'),
    ('00379', 'Lotio'),
    ('01322', 'Lozenge'),
    ('02928', 'Microcoated Tablet'),
    ('00381', 'Mouth Wash'),
    ('00362', 'Nasal Drop'),
    ('00403', 'Nasal Spray'),
    ('00382', 'Ointment'),
    ('02924', 'Oral Disintegrating Tablet'),
    ('00364', 'Oral Drop'),
    ('02904', 'Oral Paste'),
    ('00386', 'Oral Solutio'),
    ('02696', 'Oral Suspensio'),
    ('00387', 'Others'),
    ('00899', 'Ovule'),
    ('02382', 'Pack'),
    ('00388', 'Package'),
    ('01321', 'Pad'),
    ('01885', 'Paste'),
    ('02600', 'Pastil'),
    ('01884', 'Patch'),
    ('00389', 'Pearl'),
    ('00819', 'Pellet'),
    ('01519', 'Pessary'),
    ('00390', 'Plaster'),
    ('00393', 'Powder'),
    ('00392', 'Powder for Inhalatio'),
    ('02726', 'Powder For Oral Solutio'),
    ('02723', 'Powder For Oral Suspensio'),
    ('00391', 'Powder for Suspensio'),
    ('00380', 'Powder Milk'),
    ('02898', 'Prefilled Syringe of Injectable Solutio'),
    ('02738', 'Rectal Ointment'),
    ('02711', 'Rectal Suppository'),
    ('00884', 'Rectal Tube'),
    ('00394', 'Roll'),
    ('01871', 'S.C. Tablet'),
    ('00395', 'Sachet'),
    ('02890', 'Scored Chewable Tablet'),
    ('02705', 'Scored Extended Release Tablet'),
    ('02691', 'Scored F.C. Tablet'),
    ('02694', 'Scored Tablet'),
    ('02724', 'Scored Two Layer Tablet'),
    ('00396', 'Set'),
    ('00397', 'Shampoo(Lotion),'),
    ('00398', 'Soap'),
    ('00401', 'Solutio'),
    ('00350', 'Solution Anticeptic'),
    ('00841', 'Solution for INFU'),
    ('02686', 'Solution For Injectio'),
    ('00399', 'Solution Inhalatio'),
    ('01470', 'Sponge'),
    ('00402', 'Spray'),
    ('02713', 'Spray Solutio'),
    ('00363', 'Sterile Eye Drops'),
    ('00383', 'Sterile Ophthalmic Ointment'),
    ('00881', 'Sterile Ophthalmic Solutio'),
    ('02894', 'Sterile Ophthalmic/ Otic/ Nasal Drop'),
    ('02882', 'Sterile Ophthalmic/Otic Drops'),
    ('01876', 'Sterile Otic Drops'),
    ('02926', 'Sterile Solutio'),
    ('02708', 'Sterile Solution for Irrigatio'),
    ('00404', 'Stick'),
    ('00405', 'Strip'),
    ('02925', 'Sublingual Capsule'),
    ('00817', 'Sublingual Tablet'),
    ('00406', 'Suppository'),
    ('01882', 'Surgical Scrub'),
    ('00407', 'Suspensio'),
    ('02918', 'Sustained Release Capsule'),
    ('02878', 'Swab'),
    ('02041', 'Syringe'),
    ('00408', 'Syrup'),
    ('00409', 'Tablet'),
    ('01872', 'Tablet Chewable Coated'),
    ('01873', 'Tablet Coated'),
    ('00411', 'Tablet SR'),
    ('02905', 'Tincture'),
    ('00892', 'Tooth Paste'),
    ('02695', 'Topical Cream'),
    ('00369', 'Topical Gel'),
    ('02692', 'Topical Lotio'),
    ('02693', 'Topical Ointment'),
    ('00400', 'Topical Solutio'),
    ('02873', 'Vaginal and Rectal Suppository'),
    ('02929', 'Vaginal Capsule'),
    ('00359', 'Vaginal Cream'),
    ('00371', 'Vaginal Gel'),
    ('00882', 'Vaginal Suppository'),
    ('00412', 'Vaginal Tablet'),
    ('00413', 'Vial'),
    ('02764', 'Wipe');
END;