diff options
41 files changed, 14 insertions, 4546 deletions
diff --git a/LedgerSMB/DBObject/Payment.pm b/LedgerSMB/DBObject/Payment.pm index 2c523717..417843df 100644 --- a/LedgerSMB/DBObject/Payment.pm +++ b/LedgerSMB/DBObject/Payment.pm @@ -379,6 +379,7 @@ sub get_payment_detail_data { $inv->{invoices} = []; @{$inv->{invoices}} = $self->_parse_array($tmp_invoices); } + # $self->{dbh}->commit; # Commit locks } sub post_bulk { diff --git a/UI/payments/payments_detail.html b/UI/payments/payments_detail.html index ef6f3a9b..be424d91 100644 --- a/UI/payments/payments_detail.html +++ b/UI/payments/payments_detail.html @@ -64,8 +64,8 @@ } ?> <?lsmb INCLUDE input element_data = { type = "hidden" - name = "business" - value = business + name = "business_id" + value = business_id } ?> <?lsmb INCLUDE input element_data = { type = "hidden" diff --git a/UI/payments/payments_filter.html b/UI/payments/payments_filter.html index f3ff8e3d..9f50a613 100644 --- a/UI/payments/payments_filter.html +++ b/UI/payments/payments_filter.html @@ -60,7 +60,7 @@ <?lsmb IF businesses ?> <div id = "payments-filter-businesses" class="input"> <label for="businesses"><?lsmb text('Business Class') ?></label> - <select name="business" id="businesses"> + <select name="business_id" id="businesses"> <?lsmb FOREACH b = businesses ?> <option value="<?lsmb b.id ?>"><?lsmb b.description ?></option> <?lsmb END ?> diff --git a/UI/rp-search-payments.html b/UI/rp-search-payments.html index 54a3ca0b..ff97d0a2 100644 --- a/UI/rp-search-payments.html +++ b/UI/rp-search-payments.html @@ -3,6 +3,12 @@ <td colspan="3"><?lsmb PROCESS select element_data=form.paymentaccounts ?></td> </tr> <tr> + <th aligh="right"><?lsmb text('Vendor Number') ?></th> + <td colpan="3"><?lsmb INCLUDE input element_data = { + name = "meta_number" + size = '35' + } ?></td> + <tr> <th align="right"><?lsmb text('Description') ?></th> <td colspan="3"><?lsmb PROCESS input element_data={ name => 'description', @@ -131,7 +131,7 @@ qq|<option value="$_->{description}--$_->{id}">$_->{description}\n|; } } - &display_form(1); + &dislay_form(1); } @@ -1923,7 +1923,7 @@ sub list_payments { RP->payments( \%myconfig, \%$form ); - my @columns = $form->sort_columns(qw(transdate name paid source meta_number + my @columns = $form->sort_columns(qw(meta_number transdate name paid source memo)); if ( $form->{till} ) { diff --git a/sql/legacy/NAICS-1997.sql b/sql/legacy/NAICS-1997.sql deleted file mode 100755 index 42d1c8da..00000000 --- a/sql/legacy/NAICS-1997.sql +++ /dev/null @@ -1,2347 +0,0 @@ -begin; --- 1997 NAICS --- leave it SIC (Standard Industrial Code) --- useful for other countries too --- -INSERT INTO sic (code,description) VALUES ('11','Agriculture, Forestry, Fishing and Hunting'); -INSERT INTO sic (code,description) VALUES ('111','Crop Production'); -INSERT INTO sic (code,description) VALUES ('1111','Oilseed and Grain Farming'); -INSERT INTO sic (code,description) VALUES ('11111','Soybean Farming'); -INSERT INTO sic (code,description) VALUES ('111110','Soybean Farming'); -INSERT INTO sic (code,description) VALUES ('11112','Oilseed (except Soybean) Farming'); -INSERT INTO sic (code,description) VALUES ('111120','Oilseed (except Soybean) Farming'); -INSERT INTO sic (code,description) VALUES ('11113','Dry Pea and Bean Farming'); -INSERT INTO sic (code,description) VALUES ('111130','Dry Pea and Bean Farming'); -INSERT INTO sic (code,description) VALUES ('11114','Wheat Farming'); -INSERT INTO sic (code,description) VALUES ('111140','Wheat Farming'); -INSERT INTO sic (code,description) VALUES ('11115','Corn Farming'); -INSERT INTO sic (code,description) VALUES ('111150','Corn Farming'); -INSERT INTO sic (code,description) VALUES ('11116','Rice Farming'); -INSERT INTO sic (code,description) VALUES ('111160','Rice Farming'); -INSERT INTO sic (code,description) VALUES ('11119','Other Grain Farming'); -INSERT INTO sic (code,description) VALUES ('111191','Oilseed and Grain Combination Farming'); -INSERT INTO sic (code,description) VALUES ('111199','All Other Grain Farming'); -INSERT INTO sic (code,description) VALUES ('1112','Vegetable and Melon Farming'); -INSERT INTO sic (code,description) VALUES ('11121','Vegetable and Melon Farming'); -INSERT INTO sic (code,description) VALUES ('111211','Potato Farming'); -INSERT INTO sic (code,description) VALUES ('111219','Other Vegetable (except Potato) and Melon Farming'); -INSERT INTO sic (code,description) VALUES ('1113','Fruit and Tree Nut Farming'); -INSERT INTO sic (code,description) VALUES ('11131','Orange Groves'); -INSERT INTO sic (code,description) VALUES ('111310','Orange Groves'); -INSERT INTO sic (code,description) VALUES ('11132','Citrus (except Orange) Groves'); -INSERT INTO sic (code,description) VALUES ('111320','Citrus (except Orange) Groves'); -INSERT INTO sic (code,description) VALUES ('11133','Noncitrus Fruit and Tree Nut Farming'); -INSERT INTO sic (code,description) VALUES ('111331','Apple Orchards'); -INSERT INTO sic (code,description) VALUES ('111332','Grape Vineyards'); -INSERT INTO sic (code,description) VALUES ('111333','Strawberry Farming'); -INSERT INTO sic (code,description) VALUES ('111334','Berry (except Strawberry) Farming'); -INSERT INTO sic (code,description) VALUES ('111335','Tree Nut Farming'); -INSERT INTO sic (code,description) VALUES ('111336','Fruit and Tree Nut Combination Farming'); -INSERT INTO sic (code,description) VALUES ('111339','Other Noncitrus Fruit Farming'); -INSERT INTO sic (code,description) VALUES ('1114','Greenhouse, Nursery, and Floriculture Production'); -INSERT INTO sic (code,description) VALUES ('11141','Food Crops Grown Under Cover'); -INSERT INTO sic (code,description) VALUES ('111411','Mushroom Production'); -INSERT INTO sic (code,description) VALUES ('111419','Other Food Crops Grown Under Cover'); -INSERT INTO sic (code,description) VALUES ('11142','Nursery and Floriculture Production'); -INSERT INTO sic (code,description) VALUES ('111421','Nursery and Tree Production'); -INSERT INTO sic (code,description) VALUES ('111422','Floriculture Production'); -INSERT INTO sic (code,description) VALUES ('1119','Other Crop Farming'); -INSERT INTO sic (code,description) VALUES ('11191','Tobacco Farming'); -INSERT INTO sic (code,description) VALUES ('111910','Tobacco Farming'); -INSERT INTO sic (code,description) VALUES ('11192','Cotton Farming'); -INSERT INTO sic (code,description) VALUES ('111920','Cotton Farming'); -INSERT INTO sic (code,description) VALUES ('11193','Sugarcane Farming'); -INSERT INTO sic (code,description) VALUES ('111930','Sugarcane Farming'); -INSERT INTO sic (code,description) VALUES ('11194','Hay Farming'); -INSERT INTO sic (code,description) VALUES ('111940','Hay Farming'); -INSERT INTO sic (code,description) VALUES ('11199','All Other Crop Farming'); -INSERT INTO sic (code,description) VALUES ('111991','Sugar Beet Farming'); -INSERT INTO sic (code,description) VALUES ('111992','Peanut Farming'); -INSERT INTO sic (code,description) VALUES ('111998','All Other Miscellaneous Crop Farming'); -INSERT INTO sic (code,description) VALUES ('112','Animal Production'); -INSERT INTO sic (code,description) VALUES ('1121','Cattle Ranching and Farming'); -INSERT INTO sic (code,description) VALUES ('11211','Beef Cattle Ranching and Farming, including Feedlots'); -INSERT INTO sic (code,description) VALUES ('112111','Beef Cattle Ranching and Farming'); -INSERT INTO sic (code,description) VALUES ('112112','Cattle Feedlots'); -INSERT INTO sic (code,description) VALUES ('11212','Dairy Cattle and Milk Production'); -INSERT INTO sic (code,description) VALUES ('112120','Dairy Cattle and Milk Production'); -INSERT INTO sic (code,description) VALUES ('11213','Dual-Purpose Cattle Ranching and Farming'); -INSERT INTO sic (code,description) VALUES ('112130','Dual-Purpose Cattle Ranching and Farming'); -INSERT INTO sic (code,description) VALUES ('1122','Hog and Pig Farming'); -INSERT INTO sic (code,description) VALUES ('11221','Hog and Pig Farming'); -INSERT INTO sic (code,description) VALUES ('112210','Hog and Pig Farming'); -INSERT INTO sic (code,description) VALUES ('1123','Poultry and Egg Production'); -INSERT INTO sic (code,description) VALUES ('11231','Chicken Egg Production'); -INSERT INTO sic (code,description) VALUES ('112310','Chicken Egg Production'); -INSERT INTO sic (code,description) VALUES ('11232','Broilers and Other Meat Type Chicken Production'); -INSERT INTO sic (code,description) VALUES ('112320','Broilers and Other Meat Type Chicken Production'); -INSERT INTO sic (code,description) VALUES ('11233','Turkey Production'); -INSERT INTO sic (code,description) VALUES ('112330','Turkey Production'); -INSERT INTO sic (code,description) VALUES ('11234','Poultry Hatcheries'); -INSERT INTO sic (code,description) VALUES ('112340','Poultry Hatcheries'); -INSERT INTO sic (code,description) VALUES ('11239','Other Poultry Production'); -INSERT INTO sic (code,description) VALUES ('112390','Other Poultry Production'); -INSERT INTO sic (code,description) VALUES ('1124','Sheep and Goat Farming'); -INSERT INTO sic (code,description) VALUES ('11241','Sheep Farming'); -INSERT INTO sic (code,description) VALUES ('112410','Sheep Farming'); -INSERT INTO sic (code,description) VALUES ('11242','Goat Farming'); -INSERT INTO sic (code,description) VALUES ('112420','Goat Farming'); -INSERT INTO sic (code,description) VALUES ('1125','Animal Aquaculture'); -INSERT INTO sic (code,description) VALUES ('11251','Animal Aquaculture'); -INSERT INTO sic (code,description) VALUES ('112511','Finfish Farming and Fish Hatcheries'); -INSERT INTO sic (code,description) VALUES ('112512','Shellfish Farming'); -INSERT INTO sic (code,description) VALUES ('112519','Other Animal Aquaculture'); -INSERT INTO sic (code,description) VALUES ('1129','Other Animal Production'); -INSERT INTO sic (code,description) VALUES ('11291','Apiculture'); -INSERT INTO sic (code,description) VALUES ('112910','Apiculture'); -INSERT INTO sic (code,description) VALUES ('11292','Horses and Other Equine Production'); -INSERT INTO sic (code,description) VALUES ('112920','Horses and Other Equine Production'); -INSERT INTO sic (code,description) VALUES ('11293','Fur-Bearing Animal and Rabbit Production'); -INSERT INTO sic (code,description) VALUES ('112930','Fur-Bearing Animal and Rabbit Production'); -INSERT INTO sic (code,description) VALUES ('11299','All Other Animal Production'); -INSERT INTO sic (code,description) VALUES ('112990','All Other Animal Production'); -INSERT INTO sic (code,description) VALUES ('113','Forestry and Logging'); -INSERT INTO sic (code,description) VALUES ('1131','Timber Tract Operations'); -INSERT INTO sic (code,description) VALUES ('11311','Timber Tract Operations'); -INSERT INTO sic (code,description) VALUES ('113110','Timber Tract Operations'); -INSERT INTO sic (code,description) VALUES ('1132','Forest Nurseries and Gathering of Forest Products'); -INSERT INTO sic (code,description) VALUES ('11321','Forest Nurseries and Gathering of Forest Products'); -INSERT INTO sic (code,description) VALUES ('113210','Forest Nurseries and Gathering of Forest Products'); -INSERT INTO sic (code,description) VALUES ('1133','Logging'); -INSERT INTO sic (code,description) VALUES ('11331','Logging'); -INSERT INTO sic (code,description) VALUES ('113310','Logging'); -INSERT INTO sic (code,description) VALUES ('114','Fishing, Hunting and Trapping'); -INSERT INTO sic (code,description) VALUES ('1141','Fishing'); -INSERT INTO sic (code,description) VALUES ('11411','Fishing'); -INSERT INTO sic (code,description) VALUES ('114111','Finfish Fishing'); -INSERT INTO sic (code,description) VALUES ('114112','Shellfish Fishing'); -INSERT INTO sic (code,description) VALUES ('114119','Other Marine Fishing'); -INSERT INTO sic (code,description) VALUES ('1142','Hunting and Trapping'); -INSERT INTO sic (code,description) VALUES ('11421','Hunting and Trapping'); -INSERT INTO sic (code,description) VALUES ('114210','Hunting and Trapping'); -INSERT INTO sic (code,description) VALUES ('115','Support Activities for Agriculture and Forestry'); -INSERT INTO sic (code,description) VALUES ('1151','Support Activities for Crop Production'); -INSERT INTO sic (code,description) VALUES ('11511','Support Activities for Crop Production'); -INSERT INTO sic (code,description) VALUES ('115111','Cotton Ginning'); -INSERT INTO sic (code,description) VALUES ('115112','Soil Preparation, Planting, and Cultivating'); -INSERT INTO sic (code,description) VALUES ('115113','Crop Harvesting, Primarily by Machine'); -INSERT INTO sic (code,description) VALUES ('115114','Postharvest Crop Activities (except Cotton Ginning)'); -INSERT INTO sic (code,description) VALUES ('115115','Farm Labor Contractors and Crew Leaders'); -INSERT INTO sic (code,description) VALUES ('115116','Farm Management Services'); -INSERT INTO sic (code,description) VALUES ('1152','Support Activities for Animal Production'); -INSERT INTO sic (code,description) VALUES ('11521','Support Activities for Animal Production'); -INSERT INTO sic (code,description) VALUES ('115210','Support Activities for Animal Production'); -INSERT INTO sic (code,description) VALUES ('1153','Support Activities for Forestry'); -INSERT INTO sic (code,description) VALUES ('11531','Support Activities for Forestry'); -INSERT INTO sic (code,description) VALUES ('115310','Support Activities for Forestry'); -INSERT INTO sic (code,description) VALUES ('21','Mining'); -INSERT INTO sic (code,description) VALUES ('211','Oil and Gas Extraction'); -INSERT INTO sic (code,description) VALUES ('2111','Oil and Gas Extraction'); -INSERT INTO sic (code,description) VALUES ('21111','Oil and Gas Extraction'); -INSERT INTO sic (code,description) VALUES ('211111','Crude Petroleum and Natural Gas Extraction'); -INSERT INTO sic (code,description) VALUES ('211112','Natural Gas Liquid Extraction'); -INSERT INTO sic (code,description) VALUES ('212','Mining (except Oil and Gas)'); -INSERT INTO sic (code,description) VALUES ('2121','Coal Mining'); -INSERT INTO sic (code,description) VALUES ('21211','Coal Mining'); -INSERT INTO sic (code,description) VALUES ('212111','Bituminous Coal and Lignite Surface Mining'); -INSERT INTO sic (code,description) VALUES ('212112','Bituminous Coal Underground Mining'); -INSERT INTO sic (code,description) VALUES ('212113','Anthracite Mining'); -INSERT INTO sic (code,description) VALUES ('2122','Metal Ore Mining'); -INSERT INTO sic (code,description) VALUES ('21221','Iron Ore Mining'); -INSERT INTO sic (code,description) VALUES ('212210','Iron Ore Mining'); -INSERT INTO sic (code,description) VALUES ('21222','Gold Ore and Silver Ore Mining'); -INSERT INTO sic (code,description) VALUES ('212221','Gold Ore Mining'); -INSERT INTO sic (code,description) VALUES ('212222','Silver Ore Mining'); -INSERT INTO sic (code,description) VALUES ('21223','Copper, Nickel, Lead, and Zinc Mining'); -INSERT INTO sic (code,description) VALUES ('212231','Lead Ore and Zinc Ore Mining'); -INSERT INTO sic (code,description) VALUES ('212234','Copper Ore and Nickel Ore Mining'); -INSERT INTO sic (code,description) VALUES ('21229','Other Metal Ore Mining'); -INSERT INTO sic (code,description) VALUES ('212291','Uranium-Radium-Vanadium Ore Mining'); -INSERT INTO sic (code,description) VALUES ('212299','All Other Metal Ore Mining'); -INSERT INTO sic (code,description) VALUES ('2123','Nonmetallic Mineral Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('21231','Stone Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('212311','Dimension Stone Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('212312','Crushed and Broken Limestone Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('212313','Crushed and Broken Granite Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('212319','Other Crushed and Broken Stone Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('21232','Sand, Gravel, Clay, and Ceramic and Refractory Minerals Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('212321','Construction Sand and Gravel Mining'); -INSERT INTO sic (code,description) VALUES ('212322','Industrial Sand Mining'); -INSERT INTO sic (code,description) VALUES ('212324','Kaolin and Ball Clay Mining'); -INSERT INTO sic (code,description) VALUES ('212325','Clay and Ceramic and Refractory Minerals Mining'); -INSERT INTO sic (code,description) VALUES ('21239','Other Nonmetallic Mineral Mining and Quarrying'); -INSERT INTO sic (code,description) VALUES ('212391','Potash, Soda, and Borate Mineral Mining'); -INSERT INTO sic (code,description) VALUES ('212392','Phosphate Rock Mining'); -INSERT INTO sic (code,description) VALUES ('212393','Other Chemical and Fertilizer Mineral Mining'); -INSERT INTO sic (code,description) VALUES ('212399','All Other Nonmetallic Mineral Mining'); -INSERT INTO sic (code,description) VALUES ('213','Support Activities for Mining'); -INSERT INTO sic (code,description) VALUES ('2131','Support Activities for Mining'); -INSERT INTO sic (code,description) VALUES ('21311','Support Activities for Mining'); -INSERT INTO sic (code,description) VALUES ('213111','Drilling Oil and Gas Wells'); -INSERT INTO sic (code,description) VALUES ('213112','Support Activities for Oil and Gas Operations'); -INSERT INTO sic (code,description) VALUES ('213113','Support Activities for Coal Mining'); -INSERT INTO sic (code,description) VALUES ('213114','Support Activities for Metal Mining'); -INSERT INTO sic (code,description) VALUES ('213115','Support Activities for Nonmetallic Minerals (except Fuels)'); -INSERT INTO sic (code,description) VALUES ('22','Utilities'); -INSERT INTO sic (code,description) VALUES ('221','Utilities'); -INSERT INTO sic (code,description) VALUES ('2211','Electric Power Generation, Transmission and Distribution'); -INSERT INTO sic (code,description) VALUES ('22111','Electric Power Generation'); -INSERT INTO sic (code,description) VALUES ('221111','Hydroelectric Power Generation'); -INSERT INTO sic (code,description) VALUES ('221112','Fossil Fuel Electric Power Generation'); -INSERT INTO sic (code,description) VALUES ('221113','Nuclear Electric Power Generation'); -INSERT INTO sic (code,description) VALUES ('221119','Other Electric Power Generation'); -INSERT INTO sic (code,description) VALUES ('22112','Electric Power Transmission, Control, and Distribution'); -INSERT INTO sic (code,description) VALUES ('221121','Electric Bulk Power Transmission and Control'); -INSERT INTO sic (code,description) VALUES ('221122','Electric Power Distribution'); -INSERT INTO sic (code,description) VALUES ('2212','Natural Gas Distribution'); -INSERT INTO sic (code,description) VALUES ('22121','Natural Gas Distribution'); -INSERT INTO sic (code,description) VALUES ('221210','Natural Gas Distribution'); -INSERT INTO sic (code,description) VALUES ('2213','Water, Sewage and Other Systems'); -INSERT INTO sic (code,description) VALUES ('22131','Water Supply and Irrigation Systems'); -INSERT INTO sic (code,description) VALUES ('221310','Water Supply and Irrigation Systems'); -INSERT INTO sic (code,description) VALUES ('22132','Sewage Treatment Facilities'); -INSERT INTO sic (code,description) VALUES ('221320','Sewage Treatment Facilities'); -INSERT INTO sic (code,description) VALUES ('22133','Steam and Air-Conditioning Supply'); -INSERT INTO sic (code,description) VALUES ('221330','Steam and Air-Conditioning Supply'); -INSERT INTO sic (code,description) VALUES ('23','Construction'); -INSERT INTO sic (code,description) VALUES ('236','Construction of Buildings'); -INSERT INTO sic (code,description) VALUES ('2361','Residential Building Construction'); -INSERT INTO sic (code,description) VALUES ('23611','Residential Building Construction'); -INSERT INTO sic (code,description) VALUES ('236115','New Single-Family Housing Construction (except Operative Builders)'); -INSERT INTO sic (code,description) VALUES ('236116','New Multifamily Housing Construction (except Operative Builders)'); -INSERT INTO sic (code,description) VALUES ('236117','New Housing Operative Builders'); -INSERT INTO sic (code,description) VALUES ('236118','Residential Remodelers'); -INSERT INTO sic (code,description) VALUES ('2362','Nonresidential Building Construction'); -INSERT INTO sic (code,description) VALUES ('23621','Industrial Building Construction'); -INSERT INTO sic (code,description) VALUES ('236210','Industrial Building Construction'); -INSERT INTO sic (code,description) VALUES ('23622','Commercial and Institutional Building Construction'); -INSERT INTO sic (code,description) VALUES ('236220','Commercial and Institutional Building Construction'); -INSERT INTO sic (code,description) VALUES ('237','Heavy and Civil Engineering Construction'); -INSERT INTO sic (code,description) VALUES ('2371','Utility System Construction'); -INSERT INTO sic (code,description) VALUES ('23711','Water and Sewer Line and Related Structures Construction'); -INSERT INTO sic (code,description) VALUES ('237110','Water and Sewer Line and Related Structures Construction'); -INSERT INTO sic (code,description) VALUES ('23712','Oil and Gas Pipeline and Related Structures Construction'); -INSERT INTO sic (code,description) VALUES ('237120','Oil and Gas Pipeline and Related Structures Construction'); -INSERT INTO sic (code,description) VALUES ('23713','Power and Communication Line and Related Structures Construction'); -INSERT INTO sic (code,description) VALUES ('237130','Power and Communication Line and Related Structures Construction'); -INSERT INTO sic (code,description) VALUES ('2372','Land Subdivision'); -INSERT INTO sic (code,description) VALUES ('23721','Land Subdivision'); -INSERT INTO sic (code,description) VALUES ('237210','Land Subdivision'); -INSERT INTO sic (code,description) VALUES ('2373','Highway, Street, and Bridge Construction'); -INSERT INTO sic (code,description) VALUES ('23731','Highway, Street, and Bridge Construction'); -INSERT INTO sic (code,description) VALUES ('237310','Highway, Street, and Bridge Construction'); -INSERT INTO sic (code,description) VALUES ('2379','Other Heavy and Civil Engineering Construction'); -INSERT INTO sic (code,description) VALUES ('23799','Other Heavy and Civil Engineering Construction'); -INSERT INTO sic (code,description) VALUES ('237990','Other Heavy and Civil Engineering Construction'); -INSERT INTO sic (code,description) VALUES ('238','Specialty Trade Contractors'); -INSERT INTO sic (code,description) VALUES ('2381','Foundation, Structure, and Building Exterior Contractors'); -INSERT INTO sic (code,description) VALUES ('23811','Poured Concrete Foundation and Structure Contractors'); -INSERT INTO sic (code,description) VALUES ('238110','Poured Concrete Foundation and Structure Contractors'); -INSERT INTO sic (code,description) VALUES ('23812','Structural Steel and Precast Concrete Contractors'); -INSERT INTO sic (code,description) VALUES ('238120','Structural Steel and Precast Concrete Contractors'); -INSERT INTO sic (code,description) VALUES ('23813','Framing Contractors'); -INSERT INTO sic (code,description) VALUES ('238130','Framing Contractors'); -INSERT INTO sic (code,description) VALUES ('23814','Masonry Contractors'); -INSERT INTO sic (code,description) VALUES ('238140','Masonry Contractors'); -INSERT INTO sic (code,description) VALUES ('23815','Glass and Glazing Contractors'); -INSERT INTO sic (code,description) VALUES ('238150','Glass and Glazing Contractors'); -INSERT INTO sic (code,description) VALUES ('23816','Roofing Contractors'); -INSERT INTO sic (code,description) VALUES ('238160','Roofing Contractors'); -INSERT INTO sic (code,description) VALUES ('23817','Siding Contractors'); -INSERT INTO sic (code,description) VALUES ('238170','Siding Contractors'); -INSERT INTO sic (code,description) VALUES ('23819','Other Foundation, Structure, and Building Exterior Contractors'); -INSERT INTO sic (code,description) VALUES ('238190','Other Foundation, Structure, and Building Exterior Contractors'); -INSERT INTO sic (code,description) VALUES ('2382','Building Equipment Contractors'); -INSERT INTO sic (code,description) VALUES ('23821','Electrical Contractors'); -INSERT INTO sic (code,description) VALUES ('238210','Electrical Contractors'); -INSERT INTO sic (code,description) VALUES ('23822','Plumbing, Heating, and Air-Conditioning Contractors'); -INSERT INTO sic (code,description) VALUES ('238220','Plumbing, Heating, and Air-Conditioning Contractors'); -INSERT INTO sic (code,description) VALUES ('23829','Other Building Equipment Contractors'); -INSERT INTO sic (code,description) VALUES ('238290','Other Building Equipment Contractors'); -INSERT INTO sic (code,description) VALUES ('2383','Building Finishing Contractors'); -INSERT INTO sic (code,description) VALUES ('23831','Drywall and Insulation Contractors'); -INSERT INTO sic (code,description) VALUES ('238310','Drywall and Insulation Contractors'); -INSERT INTO sic (code,description) VALUES ('23832','Painting and Wall Covering Contractors'); -INSERT INTO sic (code,description) VALUES ('238320','Painting and Wall Covering Contractors'); -INSERT INTO sic (code,description) VALUES ('23833','Flooring Contractors'); -INSERT INTO sic (code,description) VALUES ('238330','Flooring Contractors'); -INSERT INTO sic (code,description) VALUES ('23834','Tile and Terrazzo Contractors'); -INSERT INTO sic (code,description) VALUES ('238340','Tile and Terrazzo Contractors'); -INSERT INTO sic (code,description) VALUES ('23835','Finish Carpentry Contractors'); -INSERT INTO sic (code,description) VALUES ('238350','Finish Carpentry Contractors'); -INSERT INTO sic (code,description) VALUES ('23839','Other Building Finishing Contractors'); -INSERT INTO sic (code,description) VALUES ('238390','Other Building Finishing Contractors'); -INSERT INTO sic (code,description) VALUES ('2389','Other Specialty Trade Contractors'); -INSERT INTO sic (code,description) VALUES ('23891','Site Preparation Contractors'); -INSERT INTO sic (code,description) VALUES ('238910','Site Preparation Contractors'); -INSERT INTO sic (code,description) VALUES ('23899','All Other Specialty Trade Contractors'); -INSERT INTO sic (code,description) VALUES ('238990','All Other Specialty Trade Contractors'); -INSERT INTO sic (code,description) VALUES ('31-33','Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311','Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3111','Animal Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31111','Animal Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311111','Dog and Cat Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311119','Other Animal Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3112','Grain and Oilseed Milling'); -INSERT INTO sic (code,description) VALUES ('31121','Flour Milling and Malt Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311211','Flour Milling'); -INSERT INTO sic (code,description) VALUES ('311212','Rice Milling'); -INSERT INTO sic (code,description) VALUES ('311213','Malt Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31122','Starch and Vegetable Fats and Oils Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311221','Wet Corn Milling'); -INSERT INTO sic (code,description) VALUES ('311222','Soybean Processing'); -INSERT INTO sic (code,description) VALUES ('311223','Other Oilseed Processing'); -INSERT INTO sic (code,description) VALUES ('311225','Fats and Oils Refining and Blending'); -INSERT INTO sic (code,description) VALUES ('31123','Breakfast Cereal Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311230','Breakfast Cereal Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3113','Sugar and Confectionery Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31131','Sugar Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311311','Sugarcane Mills'); -INSERT INTO sic (code,description) VALUES ('311312','Cane Sugar Refining'); -INSERT INTO sic (code,description) VALUES ('311313','Beet Sugar Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31132','Chocolate and Confectionery Manufacturing from Cacao Beans'); -INSERT INTO sic (code,description) VALUES ('311320','Chocolate and Confectionery Manufacturing from Cacao Beans'); -INSERT INTO sic (code,description) VALUES ('31133','Confectionery Manufacturing from Purchased Chocolate'); -INSERT INTO sic (code,description) VALUES ('311330','Confectionery Manufacturing from Purchased Chocolate'); -INSERT INTO sic (code,description) VALUES ('31134','Nonchocolate Confectionery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311340','Nonchocolate Confectionery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3114','Fruit and Vegetable Preserving and Specialty Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31141','Frozen Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311411','Frozen Fruit, Juice, and Vegetable Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311412','Frozen Specialty Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31142','Fruit and Vegetable Canning, Pickling, and Drying'); -INSERT INTO sic (code,description) VALUES ('311421','Fruit and Vegetable Canning'); -INSERT INTO sic (code,description) VALUES ('311422','Specialty Canning'); -INSERT INTO sic (code,description) VALUES ('311423','Dried and Dehydrated Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3115','Dairy Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31151','Dairy Product (except Frozen) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311511','Fluid Milk Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311512','Creamery Butter Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311513','Cheese Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311514','Dry, Condensed, and Evaporated Dairy Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31152','Ice Cream and Frozen Dessert Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311520','Ice Cream and Frozen Dessert Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3116','Animal Slaughtering and Processing'); -INSERT INTO sic (code,description) VALUES ('31161','Animal Slaughtering and Processing'); -INSERT INTO sic (code,description) VALUES ('311611','Animal (except Poultry) Slaughtering'); -INSERT INTO sic (code,description) VALUES ('311612','Meat Processed from Carcasses'); -INSERT INTO sic (code,description) VALUES ('311613','Rendering and Meat Byproduct Processing'); -INSERT INTO sic (code,description) VALUES ('311615','Poultry Processing'); -INSERT INTO sic (code,description) VALUES ('3117','Seafood Product Preparation and Packaging'); -INSERT INTO sic (code,description) VALUES ('31171','Seafood Product Preparation and Packaging'); -INSERT INTO sic (code,description) VALUES ('311711','Seafood Canning'); -INSERT INTO sic (code,description) VALUES ('311712','Fresh and Frozen Seafood Processing'); -INSERT INTO sic (code,description) VALUES ('3118','Bakeries and Tortilla Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31181','Bread and Bakery Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311811','Retail Bakeries'); -INSERT INTO sic (code,description) VALUES ('311812','Commercial Bakeries'); -INSERT INTO sic (code,description) VALUES ('311813','Frozen Cakes, Pies, and Other Pastries Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31182','Cookie, Cracker, and Pasta Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311821','Cookie and Cracker Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311822','Flour Mixes and Dough Manufacturing from Purchased Flour'); -INSERT INTO sic (code,description) VALUES ('311823','Dry Pasta Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31183','Tortilla Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311830','Tortilla Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3119','Other Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31191','Snack Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311911','Roasted Nuts and Peanut Butter Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311919','Other Snack Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31192','Coffee and Tea Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311920','Coffee and Tea Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31193','Flavoring Syrup and Concentrate Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311930','Flavoring Syrup and Concentrate Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31194','Seasoning and Dressing Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311941','Mayonnaise, Dressing, and Other Prepared Sauce Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311942','Spice and Extract Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31199','All Other Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311991','Perishable Prepared Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('311999','All Other Miscellaneous Food Manufacturing'); -INSERT INTO sic (code,description) VALUES ('312','Beverage and Tobacco Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3121','Beverage Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31211','Soft Drink and Ice Manufacturing'); -INSERT INTO sic (code,description) VALUES ('312111','Soft Drink Manufacturing'); -INSERT INTO sic (code,description) VALUES ('312112','Bottled Water Manufacturing'); -INSERT INTO sic (code,description) VALUES ('312113','Ice Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31212','Breweries'); -INSERT INTO sic (code,description) VALUES ('312120','Breweries'); -INSERT INTO sic (code,description) VALUES ('31213','Wineries'); -INSERT INTO sic (code,description) VALUES ('312130','Wineries'); -INSERT INTO sic (code,description) VALUES ('31214','Distilleries'); -INSERT INTO sic (code,description) VALUES ('312140','Distilleries'); -INSERT INTO sic (code,description) VALUES ('3122','Tobacco Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31221','Tobacco Stemming and Redrying'); -INSERT INTO sic (code,description) VALUES ('312210','Tobacco Stemming and Redrying'); -INSERT INTO sic (code,description) VALUES ('31222','Tobacco Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('312221','Cigarette Manufacturing'); -INSERT INTO sic (code,description) VALUES ('312229','Other Tobacco Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('313','Textile Mills'); -INSERT INTO sic (code,description) VALUES ('3131','Fiber, Yarn, and Thread Mills'); -INSERT INTO sic (code,description) VALUES ('31311','Fiber, Yarn, and Thread Mills'); -INSERT INTO sic (code,description) VALUES ('313111','Yarn Spinning Mills'); -INSERT INTO sic (code,description) VALUES ('313112','Yarn Texturizing, Throwing, and Twisting Mills'); -INSERT INTO sic (code,description) VALUES ('313113','Thread Mills'); -INSERT INTO sic (code,description) VALUES ('3132','Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('31321','Broadwoven Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('313210','Broadwoven Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('31322','Narrow Fabric Mills and Schiffli Machine Embroidery'); -INSERT INTO sic (code,description) VALUES ('313221','Narrow Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('313222','Schiffli Machine Embroidery'); -INSERT INTO sic (code,description) VALUES ('31323','Nonwoven Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('313230','Nonwoven Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('31324','Knit Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('313241','Weft Knit Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('313249','Other Knit Fabric and Lace Mills'); -INSERT INTO sic (code,description) VALUES ('3133','Textile and Fabric Finishing and Fabric Coating Mills'); -INSERT INTO sic (code,description) VALUES ('31331','Textile and Fabric Finishing Mills'); -INSERT INTO sic (code,description) VALUES ('313311','Broadwoven Fabric Finishing Mills'); -INSERT INTO sic (code,description) VALUES ('313312','Textile and Fabric Finishing (except Broadwoven Fabric) Mills'); -INSERT INTO sic (code,description) VALUES ('31332','Fabric Coating Mills'); -INSERT INTO sic (code,description) VALUES ('313320','Fabric Coating Mills'); -INSERT INTO sic (code,description) VALUES ('314','Textile Product Mills'); -INSERT INTO sic (code,description) VALUES ('3141','Textile Furnishings Mills'); -INSERT INTO sic (code,description) VALUES ('31411','Carpet and Rug Mills'); -INSERT INTO sic (code,description) VALUES ('314110','Carpet and Rug Mills'); -INSERT INTO sic (code,description) VALUES ('31412','Curtain and Linen Mills'); -INSERT INTO sic (code,description) VALUES ('314121','Curtain and Drapery Mills'); -INSERT INTO sic (code,description) VALUES ('314129','Other Household Textile Product Mills'); -INSERT INTO sic (code,description) VALUES ('3149','Other Textile Product Mills'); -INSERT INTO sic (code,description) VALUES ('31491','Textile Bag and Canvas Mills'); -INSERT INTO sic (code,description) VALUES ('314911','Textile Bag Mills'); -INSERT INTO sic (code,description) VALUES ('314912','Canvas and Related Product Mills'); -INSERT INTO sic (code,description) VALUES ('31499','All Other Textile Product Mills'); -INSERT INTO sic (code,description) VALUES ('314991','Rope, Cordage, and Twine Mills'); -INSERT INTO sic (code,description) VALUES ('314992','Tire Cord and Tire Fabric Mills'); -INSERT INTO sic (code,description) VALUES ('314999','All Other Miscellaneous Textile Product Mills'); -INSERT INTO sic (code,description) VALUES ('315','Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3151','Apparel Knitting Mills'); -INSERT INTO sic (code,description) VALUES ('31511','Hosiery and Sock Mills'); -INSERT INTO sic (code,description) VALUES ('315111','Sheer Hosiery Mills'); -INSERT INTO sic (code,description) VALUES ('315119','Other Hosiery and Sock Mills'); -INSERT INTO sic (code,description) VALUES ('31519','Other Apparel Knitting Mills'); -INSERT INTO sic (code,description) VALUES ('315191','Outerwear Knitting Mills'); -INSERT INTO sic (code,description) VALUES ('315192','Underwear and Nightwear Knitting Mills'); -INSERT INTO sic (code,description) VALUES ('3152','Cut and Sew Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31521','Cut and Sew Apparel Contractors'); -INSERT INTO sic (code,description) VALUES ('315211','Men\'s and Boys\' Cut and Sew Apparel Contractors'); -INSERT INTO sic (code,description) VALUES ('315212','Women\'s, Girls\', and Infants\' Cut and Sew Apparel Contractors'); -INSERT INTO sic (code,description) VALUES ('31522','Men\'s and Boys\' Cut and Sew Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315221','Men\'s and Boys\' Cut and Sew Underwear and Nightwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315222','Men\'s and Boys\' Cut and Sew Suit, Coat, and Overcoat Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315223','Men\'s and Boys\' Cut and Sew Shirt (except Work Shirt) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315224','Men\'s and Boys\' Cut and Sew Trouser, Slack, and Jean Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315225','Men\'s and Boys\' Cut and Sew Work Clothing Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315228','Men\'s and Boys\' Cut and Sew Other Outerwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31523','Women\'s and Girls\' Cut and Sew Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315231','Women\'s and Girls\' Cut and Sew Lingerie, Loungewear, and Nightwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315232','Women\'s and Girls\' Cut and Sew Blouse and Shirt Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315233','Women\'s and Girls\' Cut and Sew Dress Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315234','Women\'s and Girls\' Cut and Sew Suit, Coat, Tailored Jacket, and Skirt Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315239','Women\'s and Girls\' Cut and Sew Other Outerwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31529','Other Cut and Sew Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315291','Infants\' Cut and Sew Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315292','Fur and Leather Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315299','All Other Cut and Sew Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3159','Apparel Accessories and Other Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31599','Apparel Accessories and Other Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315991','Hat, Cap, and Millinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315992','Glove and Mitten Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315993','Men\'s and Boys\' Neckwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('315999','Other Apparel Accessories and Other Apparel Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316','Leather and Allied Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3161','Leather and Hide Tanning and Finishing'); -INSERT INTO sic (code,description) VALUES ('31611','Leather and Hide Tanning and Finishing'); -INSERT INTO sic (code,description) VALUES ('316110','Leather and Hide Tanning and Finishing'); -INSERT INTO sic (code,description) VALUES ('3162','Footwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31621','Footwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316211','Rubber and Plastics Footwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316212','House Slipper Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316213','Men\'s Footwear (except Athletic) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316214','Women\'s Footwear (except Athletic) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316219','Other Footwear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3169','Other Leather and Allied Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('31699','Other Leather and Allied Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316991','Luggage Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316992','Women\'s Handbag and Purse Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316993','Personal Leather Good (except Women\'s Handbag and Purse) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('316999','All Other Leather Good Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321','Wood Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3211','Sawmills and Wood Preservation'); -INSERT INTO sic (code,description) VALUES ('32111','Sawmills and Wood Preservation'); -INSERT INTO sic (code,description) VALUES ('321113','Sawmills'); -INSERT INTO sic (code,description) VALUES ('321114','Wood Preservation'); -INSERT INTO sic (code,description) VALUES ('3212','Veneer, Plywood, and Engineered Wood Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32121','Veneer, Plywood, and Engineered Wood Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321211','Hardwood Veneer and Plywood Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321212','Softwood Veneer and Plywood Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321213','Engineered Wood Member (except Truss) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321214','Truss Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321219','Reconstituted Wood Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3219','Other Wood Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32191','Millwork'); -INSERT INTO sic (code,description) VALUES ('321911','Wood Window and Door Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321912','Cut Stock, Resawing Lumber, and Planing'); -INSERT INTO sic (code,description) VALUES ('321918','Other Millwork (including Flooring)'); -INSERT INTO sic (code,description) VALUES ('32192','Wood Container and Pallet Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321920','Wood Container and Pallet Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32199','All Other Wood Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321991','Manufactured Home (Mobile Home) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321992','Prefabricated Wood Building Manufacturing'); -INSERT INTO sic (code,description) VALUES ('321999','All Other Miscellaneous Wood Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322','Paper Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3221','Pulp, Paper, and Paperboard Mills'); -INSERT INTO sic (code,description) VALUES ('32211','Pulp Mills'); -INSERT INTO sic (code,description) VALUES ('322110','Pulp Mills'); -INSERT INTO sic (code,description) VALUES ('32212','Paper Mills'); -INSERT INTO sic (code,description) VALUES ('322121','Paper (except Newsprint) Mills'); -INSERT INTO sic (code,description) VALUES ('322122','Newsprint Mills'); -INSERT INTO sic (code,description) VALUES ('32213','Paperboard Mills'); -INSERT INTO sic (code,description) VALUES ('322130','Paperboard Mills'); -INSERT INTO sic (code,description) VALUES ('3222','Converted Paper Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32221','Paperboard Container Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322211','Corrugated and Solid Fiber Box Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322212','Folding Paperboard Box Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322213','Setup Paperboard Box Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322214','Fiber Can, Tube, Drum, and Similar Products Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322215','Nonfolding Sanitary Food Container Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32222','Paper Bag and Coated and Treated Paper Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322221','Coated and Laminated Packaging Paper and Plastics Film Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322222','Coated and Laminated Paper Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322223','Plastics, Foil, and Coated Paper Bag Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322224','Uncoated Paper and Multiwall Bag Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322225','Laminated Aluminum Foil Manufacturing for Flexible Packaging Uses'); -INSERT INTO sic (code,description) VALUES ('322226','Surface-Coated Paperboard Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32223','Stationery Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322231','Die-Cut Paper and Paperboard Office Supplies Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322232','Envelope Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322233','Stationery, Tablet, and Related Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32229','Other Converted Paper Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322291','Sanitary Paper Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('322299','All Other Converted Paper Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('323','Printing and Related Support Activities'); -INSERT INTO sic (code,description) VALUES ('3231','Printing and Related Support Activities'); -INSERT INTO sic (code,description) VALUES ('32311','Printing'); -INSERT INTO sic (code,description) VALUES ('323110','Commercial Lithographic Printing'); -INSERT INTO sic (code,description) VALUES ('323111','Commercial Gravure Printing'); -INSERT INTO sic (code,description) VALUES ('323112','Commercial Flexographic Printing'); -INSERT INTO sic (code,description) VALUES ('323113','Commercial Screen Printing'); -INSERT INTO sic (code,description) VALUES ('323114','Quick Printing'); -INSERT INTO sic (code,description) VALUES ('323115','Digital Printing'); -INSERT INTO sic (code,description) VALUES ('323116','Manifold Business Forms Printing'); -INSERT INTO sic (code,description) VALUES ('323117','Books Printing'); -INSERT INTO sic (code,description) VALUES ('323118','Blankbook, Looseleaf Binders, and Devices Manufacturing'); -INSERT INTO sic (code,description) VALUES ('323119','Other Commercial Printing'); -INSERT INTO sic (code,description) VALUES ('32312','Support Activities for Printing'); -INSERT INTO sic (code,description) VALUES ('323121','Tradebinding and Related Work'); -INSERT INTO sic (code,description) VALUES ('323122','Prepress Services'); -INSERT INTO sic (code,description) VALUES ('324','Petroleum and Coal Products Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3241','Petroleum and Coal Products Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32411','Petroleum Refineries'); -INSERT INTO sic (code,description) VALUES ('324110','Petroleum Refineries'); -INSERT INTO sic (code,description) VALUES ('32412','Asphalt Paving, Roofing, and Saturated Materials Manufacturing'); -INSERT INTO sic (code,description) VALUES ('324121','Asphalt Paving Mixture and Block Manufacturing'); -INSERT INTO sic (code,description) VALUES ('324122','Asphalt Shingle and Coating Materials Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32419','Other Petroleum and Coal Products Manufacturing'); -INSERT INTO sic (code,description) VALUES ('324191','Petroleum Lubricating Oil and Grease Manufacturing'); -INSERT INTO sic (code,description) VALUES ('324199','All Other Petroleum and Coal Products Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325','Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3251','Basic Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32511','Petrochemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325110','Petrochemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32512','Industrial Gas Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325120','Industrial Gas Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32513','Synthetic Dye and Pigment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325131','Inorganic Dye and Pigment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325132','Synthetic Organic Dye and Pigment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32518','Other Basic Inorganic Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325181','Alkalies and Chlorine Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325182','Carbon Black Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325188','All Other Basic Inorganic Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32519','Other Basic Organic Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325191','Gum and Wood Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325192','Cyclic Crude and Intermediate Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325193','Ethyl Alcohol Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325199','All Other Basic Organic Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3252','Resin, Synthetic Rubber, and Artificial Synthetic Fibers and Filaments Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32521','Resin and Synthetic Rubber Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325211','Plastics Material and Resin Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325212','Synthetic Rubber Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32522','Artificial and Synthetic Fibers and Filaments Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325221','Cellulosic Organic Fiber Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325222','Noncellulosic Organic Fiber Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3253','Pesticide, Fertilizer, and Other Agricultural Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32531','Fertilizer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325311','Nitrogenous Fertilizer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325312','Phosphatic Fertilizer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325314','Fertilizer (Mixing Only) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32532','Pesticide and Other Agricultural Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325320','Pesticide and Other Agricultural Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3254','Pharmaceutical and Medicine Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32541','Pharmaceutical and Medicine Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325411','Medicinal and Botanical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325412','Pharmaceutical Preparation Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325413','In-Vitro Diagnostic Substance Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325414','Biological Product (except Diagnostic) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3255','Paint, Coating, and Adhesive Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32551','Paint and Coating Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325510','Paint and Coating Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32552','Adhesive Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325520','Adhesive Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3256','Soap, Cleaning Compound, and Toilet Preparation Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32561','Soap and Cleaning Compound Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325611','Soap and Other Detergent Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325612','Polish and Other Sanitation Good Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325613','Surface Active Agent Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32562','Toilet Preparation Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325620','Toilet Preparation Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3259','Other Chemical Product and Preparation Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32591','Printing Ink Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325910','Printing Ink Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32592','Explosives Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325920','Explosives Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32599','All Other Chemical Product and Preparation Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325991','Custom Compounding of Purchased Resins'); -INSERT INTO sic (code,description) VALUES ('325992','Photographic Film, Paper, Plate, and Chemical Manufacturing'); -INSERT INTO sic (code,description) VALUES ('325998','All Other Miscellaneous Chemical Product and Preparation Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326','Plastics and Rubber Products Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3261','Plastics Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32611','Plastics Packaging Materials and Unlaminated Film and Sheet Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326111','Plastics Bag Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326112','Plastics Packaging Film and Sheet (including Laminated) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326113','Unlaminated Plastics Film and Sheet (except Packaging) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32612','Plastics Pipe, Pipe Fitting, and Unlaminated Profile Shape Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326121','Unlaminated Plastics Profile Shape Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326122','Plastics Pipe and Pipe Fitting Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32613','Laminated Plastics Plate, Sheet (except Packaging), and Shape Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326130','Laminated Plastics Plate, Sheet (except Packaging), and Shape Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32614','Polystyrene Foam Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326140','Polystyrene Foam Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32615','Urethane and Other Foam Product (except Polystyrene) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326150','Urethane and Other Foam Product (except Polystyrene) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32616','Plastics Bottle Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326160','Plastics Bottle Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32619','Other Plastics Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326191','Plastics Plumbing Fixture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326192','Resilient Floor Covering Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326199','All Other Plastics Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3262','Rubber Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32621','Tire Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326211','Tire Manufacturing (except Retreading)'); -INSERT INTO sic (code,description) VALUES ('326212','Tire Retreading'); -INSERT INTO sic (code,description) VALUES ('32622','Rubber and Plastics Hoses and Belting Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326220','Rubber and Plastics Hoses and Belting Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32629','Other Rubber Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('326291','Rubber Product Manufacturing for Mechanical Use'); -INSERT INTO sic (code,description) VALUES ('326299','All Other Rubber Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327','Nonmetallic Mineral Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3271','Clay Product and Refractory Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32711','Pottery, Ceramics, and Plumbing Fixture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327111','Vitreous China Plumbing Fixture and China and Earthenware Bathroom Accessories Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327112','Vitreous China, Fine Earthenware, and Other Pottery Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327113','Porcelain Electrical Supply Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32712','Clay Building Material and Refractories Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327121','Brick and Structural Clay Tile Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327122','Ceramic Wall and Floor Tile Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327123','Other Structural Clay Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327124','Clay Refractory Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327125','Nonclay Refractory Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3272','Glass and Glass Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32721','Glass and Glass Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327211','Flat Glass Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327212','Other Pressed and Blown Glass and Glassware Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327213','Glass Container Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327215','Glass Product Manufacturing Made of Purchased Glass'); -INSERT INTO sic (code,description) VALUES ('3273','Cement and Concrete Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32731','Cement Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327310','Cement Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32732','Ready-Mix Concrete Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327320','Ready-Mix Concrete Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32733','Concrete Pipe, Brick, and Block Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327331','Concrete Block and Brick Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327332','Concrete Pipe Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32739','Other Concrete Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327390','Other Concrete Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3274','Lime and Gypsum Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32741','Lime Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327410','Lime Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32742','Gypsum Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327420','Gypsum Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3279','Other Nonmetallic Mineral Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32791','Abrasive Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327910','Abrasive Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('32799','All Other Nonmetallic Mineral Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327991','Cut Stone and Stone Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327992','Ground or Treated Mineral and Earth Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327993','Mineral Wool Manufacturing'); -INSERT INTO sic (code,description) VALUES ('327999','All Other Miscellaneous Nonmetallic Mineral Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('331','Primary Metal Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3311','Iron and Steel Mills and Ferroalloy Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33111','Iron and Steel Mills and Ferroalloy Manufacturing'); -INSERT INTO sic (code,description) VALUES ('331111','Iron and Steel Mills'); -INSERT INTO sic (code,description) VALUES ('331112','Electrometallurgical Ferroalloy Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3312','Steel Product Manufacturing from Purchased Steel'); -INSERT INTO sic (code,description) VALUES ('33121','Iron and Steel Pipe and Tube Manufacturing from Purchased Steel'); -INSERT INTO sic (code,description) VALUES ('331210','Iron and Steel Pipe and Tube Manufacturing from Purchased Steel'); -INSERT INTO sic (code,description) VALUES ('33122','Rolling and Drawing of Purchased Steel'); -INSERT INTO sic (code,description) VALUES ('331221','Rolled Steel Shape Manufacturing'); -INSERT INTO sic (code,description) VALUES ('331222','Steel Wire Drawing'); -INSERT INTO sic (code,description) VALUES ('3313','Alumina and Aluminum Production and Processing'); -INSERT INTO sic (code,description) VALUES ('33131','Alumina and Aluminum Production and Processing'); -INSERT INTO sic (code,description) VALUES ('331311','Alumina Refining'); -INSERT INTO sic (code,description) VALUES ('331312','Primary Aluminum Production'); -INSERT INTO sic (code,description) VALUES ('331314','Secondary Smelting and Alloying of Aluminum'); -INSERT INTO sic (code,description) VALUES ('331315','Aluminum Sheet, Plate, and Foil Manufacturing'); -INSERT INTO sic (code,description) VALUES ('331316','Aluminum Extruded Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('331319','Other Aluminum Rolling and Drawing'); -INSERT INTO sic (code,description) VALUES ('3314','Nonferrous Metal (except Aluminum) Production and Processing'); -INSERT INTO sic (code,description) VALUES ('33141','Nonferrous Metal (except Aluminum) Smelting and Refining'); -INSERT INTO sic (code,description) VALUES ('331411','Primary Smelting and Refining of Copper'); -INSERT INTO sic (code,description) VALUES ('331419','Primary Smelting and Refining of Nonferrous Metal (except Copper and Aluminum)'); -INSERT INTO sic (code,description) VALUES ('33142','Copper Rolling, Drawing, Extruding, and Alloying'); -INSERT INTO sic (code,description) VALUES ('331421','Copper Rolling, Drawing, and Extruding'); -INSERT INTO sic (code,description) VALUES ('331422','Copper Wire (except Mechanical) Drawing'); -INSERT INTO sic (code,description) VALUES ('331423','Secondary Smelting, Refining, and Alloying of Copper'); -INSERT INTO sic (code,description) VALUES ('33149','Nonferrous Metal (except Copper and Aluminum) Rolling, Drawing, Extruding, and Alloying'); -INSERT INTO sic (code,description) VALUES ('331491','Nonferrous Metal (except Copper and Aluminum) Rolling, Drawing, and Extruding'); -INSERT INTO sic (code,description) VALUES ('331492','Secondary Smelting, Refining, and Alloying of Nonferrous Metal (except Copper and Aluminum)'); -INSERT INTO sic (code,description) VALUES ('3315','Foundries'); -INSERT INTO sic (code,description) VALUES ('33151','Ferrous Metal Foundries'); -INSERT INTO sic (code,description) VALUES ('331511','Iron Foundries'); -INSERT INTO sic (code,description) VALUES ('331512','Steel Investment Foundries'); -INSERT INTO sic (code,description) VALUES ('331513','Steel Foundries (except Investment)'); -INSERT INTO sic (code,description) VALUES ('33152','Nonferrous Metal Foundries'); -INSERT INTO sic (code,description) VALUES ('331521','Aluminum Die-Casting Foundries'); -INSERT INTO sic (code,description) VALUES ('331522','Nonferrous (except Aluminum) Die-Casting Foundries'); -INSERT INTO sic (code,description) VALUES ('331524','Aluminum Foundries (except Die-Casting)'); -INSERT INTO sic (code,description) VALUES ('331525','Copper Foundries (except Die-Casting)'); -INSERT INTO sic (code,description) VALUES ('331528','Other Nonferrous Foundries (except Die-Casting)'); -INSERT INTO sic (code,description) VALUES ('332','Fabricated Metal Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3321','Forging and Stamping'); -INSERT INTO sic (code,description) VALUES ('33211','Forging and Stamping'); -INSERT INTO sic (code,description) VALUES ('332111','Iron and Steel Forging'); -INSERT INTO sic (code,description) VALUES ('332112','Nonferrous Forging'); -INSERT INTO sic (code,description) VALUES ('332114','Custom Roll Forming'); -INSERT INTO sic (code,description) VALUES ('332115','Crown and Closure Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332116','Metal Stamping'); -INSERT INTO sic (code,description) VALUES ('332117','Powder Metallurgy Part Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3322','Cutlery and Handtool Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33221','Cutlery and Handtool Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332211','Cutlery and Flatware (except Precious) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332212','Hand and Edge Tool Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332213','Saw Blade and Handsaw Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332214','Kitchen Utensil, Pot, and Pan Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3323','Architectural and Structural Metals Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33231','Plate Work and Fabricated Structural Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332311','Prefabricated Metal Building and Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332312','Fabricated Structural Metal Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332313','Plate Work Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33232','Ornamental and Architectural Metal Products Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332321','Metal Window and Door Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332322','Sheet Metal Work Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332323','Ornamental and Architectural Metal Work Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3324','Boiler, Tank, and Shipping Container Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33241','Power Boiler and Heat Exchanger Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332410','Power Boiler and Heat Exchanger Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33242','Metal Tank (Heavy Gauge) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332420','Metal Tank (Heavy Gauge) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33243','Metal Can, Box, and Other Metal Container (Light Gauge) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332431','Metal Can Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332439','Other Metal Container Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3325','Hardware Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33251','Hardware Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332510','Hardware Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3326','Spring and Wire Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33261','Spring and Wire Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332611','Spring (Heavy Gauge) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332612','Spring (Light Gauge) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332618','Other Fabricated Wire Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3327','Machine Shops; Turned Product; and Screw, Nut, and Bolt Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33271','Machine Shops'); -INSERT INTO sic (code,description) VALUES ('332710','Machine Shops'); -INSERT INTO sic (code,description) VALUES ('33272','Turned Product and Screw, Nut, and Bolt Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332721','Precision Turned Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332722','Bolt, Nut, Screw, Rivet, and Washer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3328','Coating, Engraving, Heat Treating, and Allied Activities'); -INSERT INTO sic (code,description) VALUES ('33281','Coating, Engraving, Heat Treating, and Allied Activities'); -INSERT INTO sic (code,description) VALUES ('332811','Metal Heat Treating'); -INSERT INTO sic (code,description) VALUES ('332812','Metal Coating, Engraving (except Jewelry and Silverware), and Allied Services to Manufacturers'); -INSERT INTO sic (code,description) VALUES ('332813','Electroplating, Plating, Polishing, Anodizing, and Coloring'); -INSERT INTO sic (code,description) VALUES ('3329','Other Fabricated Metal Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33291','Metal Valve Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332911','Industrial Valve Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332912','Fluid Power Valve and Hose Fitting Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332913','Plumbing Fixture Fitting and Trim Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332919','Other Metal Valve and Pipe Fitting Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33299','All Other Fabricated Metal Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332991','Ball and Roller Bearing Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332992','Small Arms Ammunition Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332993','Ammunition (except Small Arms) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332994','Small Arms Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332995','Other Ordnance and Accessories Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332996','Fabricated Pipe and Pipe Fitting Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332997','Industrial Pattern Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332998','Enameled Iron and Metal Sanitary Ware Manufacturing'); -INSERT INTO sic (code,description) VALUES ('332999','All Other Miscellaneous Fabricated Metal Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333','Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3331','Agriculture, Construction, and Mining Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33311','Agricultural Implement Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333111','Farm Machinery and Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333112','Lawn and Garden Tractor and Home Lawn and Garden Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33312','Construction Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333120','Construction Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33313','Mining and Oil and Gas Field Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333131','Mining Machinery and Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333132','Oil and Gas Field Machinery and Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3332','Industrial Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33321','Sawmill and Woodworking Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333210','Sawmill and Woodworking Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33322','Plastics and Rubber Industry Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333220','Plastics and Rubber Industry Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33329','Other Industrial Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333291','Paper Industry Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333292','Textile Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333293','Printing Machinery and Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333294','Food Product Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333295','Semiconductor Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333298','All Other Industrial Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3333','Commercial and Service Industry Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33331','Commercial and Service Industry Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333311','Automatic Vending Machine Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333312','Commercial Laundry, Drycleaning, and Pressing Machine Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333313','Office Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333314','Optical Instrument and Lens Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333315','Photographic and Photocopying Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333319','Other Commercial and Service Industry Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3334','Ventilation, Heating, Air-Conditioning, and Commercial Refrigeration Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33341','Ventilation, Heating, Air-Conditioning, and Commercial Refrigeration Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333411','Air Purification Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333412','Industrial and Commercial Fan and Blower Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333414','Heating Equipment (except Warm Air Furnaces) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333415','Air-Conditioning and Warm Air Heating Equipment and Commercial and Industrial Refrigeration Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3335','Metalworking Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33351','Metalworking Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333511','Industrial Mold Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333512','Machine Tool (Metal Cutting Types) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333513','Machine Tool (Metal Forming Types) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333514','Special Die and Tool, Die Set, Jig, and Fixture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333515','Cutting Tool and Machine Tool Accessory Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333516','Rolling Mill Machinery and Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333518','Other Metalworking Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3336','Engine, Turbine, and Power Transmission Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33361','Engine, Turbine, and Power Transmission Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333611','Turbine and Turbine Generator Set Units Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333612','Speed Changer, Industrial High-Speed Drive, and Gear Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333613','Mechanical Power Transmission Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333618','Other Engine Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3339','Other General Purpose Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33391','Pump and Compressor Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333911','Pump and Pumping Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333912','Air and Gas Compressor Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333913','Measuring and Dispensing Pump Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33392','Material Handling Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333921','Elevator and Moving Stairway Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333922','Conveyor and Conveying Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333923','Overhead Traveling Crane, Hoist, and Monorail System Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333924','Industrial Truck, Tractor, Trailer, and Stacker Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33399','All Other General Purpose Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333991','Power-Driven Handtool Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333992','Welding and Soldering Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333993','Packaging Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333994','Industrial Process Furnace and Oven Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333995','Fluid Power Cylinder and Actuator Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333996','Fluid Power Pump and Motor Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333997','Scale and Balance (except Laboratory) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('333999','All Other Miscellaneous General Purpose Machinery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334','Computer and Electronic Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3341','Computer and Peripheral Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33411','Computer and Peripheral Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334111','Electronic Computer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334112','Computer Storage Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334113','Computer Terminal Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334119','Other Computer Peripheral Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3342','Communications Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33421','Telephone Apparatus Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334210','Telephone Apparatus Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33422','Radio and Television Broadcasting and Wireless Communications Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334220','Radio and Television Broadcasting and Wireless Communications Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33429','Other Communications Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334290','Other Communications Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3343','Audio and Video Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33431','Audio and Video Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334310','Audio and Video Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3344','Semiconductor and Other Electronic Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33441','Semiconductor and Other Electronic Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334411','Electron Tube Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334412','Bare Printed Circuit Board Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334413','Semiconductor and Related Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334414','Electronic Capacitor Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334415','Electronic Resistor Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334416','Electronic Coil, Transformer, and Other Inductor Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334417','Electronic Connector Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334418','Printed Circuit Assembly (Electronic Assembly) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334419','Other Electronic Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3345','Navigational, Measuring, Electromedical, and Control Instruments Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33451','Navigational, Measuring, Electromedical, and Control Instruments Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334510','Electromedical and Electrotherapeutic Apparatus Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334511','Search, Detection, Navigation, Guidance, Aeronautical, and Nautical System and Instrument Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334512','Automatic Environmental Control Manufacturing for Residential, Commercial, and Appliance Use'); -INSERT INTO sic (code,description) VALUES ('334513','Instruments and Related Products Manufacturing for Measuring, Displaying, and Controlling Industrial Process Variables'); -INSERT INTO sic (code,description) VALUES ('334514','Totalizing Fluid Meter and Counting Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334515','Instrument Manufacturing for Measuring and Testing Electricity and Electrical Signals'); -INSERT INTO sic (code,description) VALUES ('334516','Analytical Laboratory Instrument Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334517','Irradiation Apparatus Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334518','Watch, Clock, and Part Manufacturing'); -INSERT INTO sic (code,description) VALUES ('334519','Other Measuring and Controlling Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3346','Manufacturing and Reproducing Magnetic and Optical Media'); -INSERT INTO sic (code,description) VALUES ('33461','Manufacturing and Reproducing Magnetic and Optical Media'); -INSERT INTO sic (code,description) VALUES ('334611','Software Reproducing'); -INSERT INTO sic (code,description) VALUES ('334612','Prerecorded Compact Disc (except Software), Tape, and Record Reproducing'); -INSERT INTO sic (code,description) VALUES ('334613','Magnetic and Optical Recording Media Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335','Electrical Equipment, Appliance, and Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3351','Electric Lighting Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33511','Electric Lamp Bulb and Part Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335110','Electric Lamp Bulb and Part Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33512','Lighting Fixture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335121','Residential Electric Lighting Fixture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335122','Commercial, Industrial, and Institutional Electric Lighting Fixture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335129','Other Lighting Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3352','Household Appliance Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33521','Small Electrical Appliance Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335211','Electric Housewares and Household Fan Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335212','Household Vacuum Cleaner Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33522','Major Appliance Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335221','Household Cooking Appliance Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335222','Household Refrigerator and Home Freezer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335224','Household Laundry Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335228','Other Major Household Appliance Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3353','Electrical Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33531','Electrical Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335311','Power, Distribution, and Specialty Transformer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335312','Motor and Generator Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335313','Switchgear and Switchboard Apparatus Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335314','Relay and Industrial Control Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3359','Other Electrical Equipment and Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33591','Battery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335911','Storage Battery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335912','Primary Battery Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33592','Communication and Energy Wire and Cable Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335921','Fiber Optic Cable Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335929','Other Communication and Energy Wire Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33593','Wiring Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335931','Current-Carrying Wiring Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335932','Noncurrent-Carrying Wiring Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33599','All Other Electrical Equipment and Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335991','Carbon and Graphite Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('335999','All Other Miscellaneous Electrical Equipment and Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336','Transportation Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3361','Motor Vehicle Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33611','Automobile and Light Duty Motor Vehicle Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336111','Automobile Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336112','Light Truck and Utility Vehicle Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33612','Heavy Duty Truck Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336120','Heavy Duty Truck Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3362','Motor Vehicle Body and Trailer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33621','Motor Vehicle Body and Trailer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336211','Motor Vehicle Body Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336212','Truck Trailer Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336213','Motor Home Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336214','Travel Trailer and Camper Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3363','Motor Vehicle Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33631','Motor Vehicle Gasoline Engine and Engine Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336311','Carburetor, Piston, Piston Ring, and Valve Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336312','Gasoline Engine and Engine Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33632','Motor Vehicle Electrical and Electronic Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336321','Vehicular Lighting Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336322','Other Motor Vehicle Electrical and Electronic Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33633','Motor Vehicle Steering and Suspension Components (except Spring) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336330','Motor Vehicle Steering and Suspension Components (except Spring) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33634','Motor Vehicle Brake System Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336340','Motor Vehicle Brake System Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33635','Motor Vehicle Transmission and Power Train Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336350','Motor Vehicle Transmission and Power Train Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33636','Motor Vehicle Seating and Interior Trim Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336360','Motor Vehicle Seating and Interior Trim Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33637','Motor Vehicle Metal Stamping'); -INSERT INTO sic (code,description) VALUES ('336370','Motor Vehicle Metal Stamping'); -INSERT INTO sic (code,description) VALUES ('33639','Other Motor Vehicle Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336391','Motor Vehicle Air-Conditioning Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336399','All Other Motor Vehicle Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3364','Aerospace Product and Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33641','Aerospace Product and Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336411','Aircraft Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336412','Aircraft Engine and Engine Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336413','Other Aircraft Parts and Auxiliary Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336414','Guided Missile and Space Vehicle Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336415','Guided Missile and Space Vehicle Propulsion Unit and Propulsion Unit Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336419','Other Guided Missile and Space Vehicle Parts and Auxiliary Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3365','Railroad Rolling Stock Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33651','Railroad Rolling Stock Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336510','Railroad Rolling Stock Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3366','Ship and Boat Building'); -INSERT INTO sic (code,description) VALUES ('33661','Ship and Boat Building'); -INSERT INTO sic (code,description) VALUES ('336611','Ship Building and Repairing'); -INSERT INTO sic (code,description) VALUES ('336612','Boat Building'); -INSERT INTO sic (code,description) VALUES ('3369','Other Transportation Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33699','Other Transportation Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336991','Motorcycle, Bicycle, and Parts Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336992','Military Armored Vehicle, Tank, and Tank Component Manufacturing'); -INSERT INTO sic (code,description) VALUES ('336999','All Other Transportation Equipment Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337','Furniture and Related Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3371','Household and Institutional Furniture and Kitchen Cabinet Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33711','Wood Kitchen Cabinet and Countertop Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337110','Wood Kitchen Cabinet and Countertop Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33712','Household and Institutional Furniture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337121','Upholstered Household Furniture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337122','Nonupholstered Wood Household Furniture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337124','Metal Household Furniture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337125','Household Furniture (except Wood and Metal) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337127','Institutional Furniture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337129','Wood Television, Radio, and Sewing Machine Cabinet Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3372','Office Furniture (including Fixtures) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33721','Office Furniture (including Fixtures) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337211','Wood Office Furniture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337212','Custom Architectural Woodwork and Millwork Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337214','Office Furniture (except Wood) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337215','Showcase, Partition, Shelving, and Locker Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3379','Other Furniture Related Product Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33791','Mattress Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337910','Mattress Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33792','Blind and Shade Manufacturing'); -INSERT INTO sic (code,description) VALUES ('337920','Blind and Shade Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339','Miscellaneous Manufacturing'); -INSERT INTO sic (code,description) VALUES ('3391','Medical Equipment and Supplies Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33911','Medical Equipment and Supplies Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339111','Laboratory Apparatus and Furniture Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339112','Surgical and Medical Instrument Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339113','Surgical Appliance and Supplies Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339114','Dental Equipment and Supplies Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339115','Ophthalmic Goods Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339116','Dental Laboratories'); -INSERT INTO sic (code,description) VALUES ('3399','Other Miscellaneous Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33991','Jewelry and Silverware Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339911','Jewelry (except Costume) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339912','Silverware and Hollowware Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339913','Jewelers\' Material and Lapidary Work Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339914','Costume Jewelry and Novelty Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33992','Sporting and Athletic Goods Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339920','Sporting and Athletic Goods Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33993','Doll, Toy, and Game Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339931','Doll and Stuffed Toy Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339932','Game, Toy, and Children\'s Vehicle Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33994','Office Supplies (except Paper) Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339941','Pen and Mechanical Pencil Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339942','Lead Pencil and Art Good Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339943','Marking Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339944','Carbon Paper and Inked Ribbon Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33995','Sign Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339950','Sign Manufacturing'); -INSERT INTO sic (code,description) VALUES ('33999','All Other Miscellaneous Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339991','Gasket, Packing, and Sealing Device Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339992','Musical Instrument Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339993','Fastener, Button, Needle, and Pin Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339994','Broom, Brush, and Mop Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339995','Burial Casket Manufacturing'); -INSERT INTO sic (code,description) VALUES ('339999','All Other Miscellaneous Manufacturing'); -INSERT INTO sic (code,description) VALUES ('42','Wholesale Trade'); -INSERT INTO sic (code,description) VALUES ('423','Merchant Wholesalers, Durable Goods'); -INSERT INTO sic (code,description) VALUES ('4231','Motor Vehicle and Motor Vehicle Parts and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42311','Automobile and Other Motor Vehicle Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423110','Automobile and Other Motor Vehicle Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42312','Motor Vehicle Supplies and New Parts Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423120','Motor Vehicle Supplies and New Parts Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42313','Tire and Tube Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423130','Tire and Tube Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42314','Motor Vehicle Parts (Used) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423140','Motor Vehicle Parts (Used) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4232','Furniture and Home Furnishing Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42321','Furniture Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423210','Furniture Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42322','Home Furnishing Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423220','Home Furnishing Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4233','Lumber and Other Construction Materials Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42331','Lumber, Plywood, Millwork, and Wood Panel Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423310','Lumber, Plywood, Millwork, and Wood Panel Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42332','Brick, Stone, and Related Construction Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423320','Brick, Stone, and Related Construction Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42333','Roofing, Siding, and Insulation Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423330','Roofing, Siding, and Insulation Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42339','Other Construction Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423390','Other Construction Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4234','Professional and Commercial Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42341','Photographic Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423410','Photographic Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42342','Office Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423420','Office Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42343','Computer and Computer Peripheral Equipment and Software Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423430','Computer and Computer Peripheral Equipment and Software Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42344','Other Commercial Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423440','Other Commercial Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42345','Medical, Dental, and Hospital Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423450','Medical, Dental, and Hospital Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42346','Ophthalmic Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423460','Ophthalmic Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42349','Other Professional Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423490','Other Professional Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4235','Metal and Mineral (except Petroleum) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42351','Metal Service Centers and Other Metal Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423510','Metal Service Centers and Other Metal Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42352','Coal and Other Mineral and Ore Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423520','Coal and Other Mineral and Ore Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4236','Electrical and Electronic Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42361','Electrical Apparatus and Equipment, Wiring Supplies, and Related Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423610','Electrical Apparatus and Equipment, Wiring Supplies, and Related Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42362','Electrical and Electronic Appliance, Television, and Radio Set Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423620','Electrical and Electronic Appliance, Television, and Radio Set Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42369','Other Electronic Parts and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423690','Other Electronic Parts and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4237','Hardware, and Plumbing and Heating Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42371','Hardware Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423710','Hardware Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42372','Plumbing and Heating Equipment and Supplies (Hydronics) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423720','Plumbing and Heating Equipment and Supplies (Hydronics) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42373','Warm Air Heating and Air-Conditioning Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423730','Warm Air Heating and Air-Conditioning Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42374','Refrigeration Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423740','Refrigeration Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4238','Machinery, Equipment, and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42381','Construction and Mining (except Oil Well) Machinery and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423810','Construction and Mining (except Oil Well) Machinery and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42382','Farm and Garden Machinery and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423820','Farm and Garden Machinery and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42383','Industrial Machinery and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423830','Industrial Machinery and Equipment Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42384','Industrial Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423840','Industrial Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42385','Service Establishment Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423850','Service Establishment Equipment and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42386','Transportation Equipment and Supplies (except Motor Vehicle) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423860','Transportation Equipment and Supplies (except Motor Vehicle) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4239','Miscellaneous Durable Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42391','Sporting and Recreational Goods and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423910','Sporting and Recreational Goods and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42392','Toy and Hobby Goods and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423920','Toy and Hobby Goods and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42393','Recyclable Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423930','Recyclable Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42394','Jewelry, Watch, Precious Stone, and Precious Metal Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423940','Jewelry, Watch, Precious Stone, and Precious Metal Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42399','Other Miscellaneous Durable Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('423990','Other Miscellaneous Durable Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424','Merchant Wholesalers, Nondurable Goods'); -INSERT INTO sic (code,description) VALUES ('4241','Paper and Paper Product Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42411','Printing and Writing Paper Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424110','Printing and Writing Paper Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42412','Stationery and Office Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424120','Stationery and Office Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42413','Industrial and Personal Service Paper Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424130','Industrial and Personal Service Paper Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4242','Drugs and Druggists\' Sundries Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42421','Drugs and Druggists\' Sundries Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424210','Drugs and Druggists\' Sundries Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4243','Apparel, Piece Goods, and Notions Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42431','Piece Goods, Notions, and Other Dry Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424310','Piece Goods, Notions, and Other Dry Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42432','Men\'s and Boys\' Clothing and Furnishings Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424320','Men\'s and Boys\' Clothing and Furnishings Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42433','Women\'s, Children\'s, and Infants\' Clothing and Accessories Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424330','Women\'s, Children\'s, and Infants\' Clothing and Accessories Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42434','Footwear Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424340','Footwear Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4244','Grocery and Related Product Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42441','General Line Grocery Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424410','General Line Grocery Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42442','Packaged Frozen Food Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424420','Packaged Frozen Food Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42443','Dairy Product (except Dried or Canned) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424430','Dairy Product (except Dried or Canned) Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42444','Poultry and Poultry Product Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424440','Poultry and Poultry Product Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42445','Confectionery Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424450','Confectionery Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42446','Fish and Seafood Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424460','Fish and Seafood Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42447','Meat and Meat Product Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424470','Meat and Meat Product Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42448','Fresh Fruit and Vegetable Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424480','Fresh Fruit and Vegetable Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42449','Other Grocery and Related Products Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424490','Other Grocery and Related Products Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4245','Farm Product Raw Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42451','Grain and Field Bean Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424510','Grain and Field Bean Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42452','Livestock Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424520','Livestock Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42459','Other Farm Product Raw Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424590','Other Farm Product Raw Material Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4246','Chemical and Allied Products Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42461','Plastics Materials and Basic Forms and Shapes Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424610','Plastics Materials and Basic Forms and Shapes Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42469','Other Chemical and Allied Products Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424690','Other Chemical and Allied Products Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4247','Petroleum and Petroleum Products Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42471','Petroleum Bulk Stations and Terminals'); -INSERT INTO sic (code,description) VALUES ('424710','Petroleum Bulk Stations and Terminals'); -INSERT INTO sic (code,description) VALUES ('42472','Petroleum and Petroleum Products Merchant Wholesalers (except Bulk Stations and Terminals)'); -INSERT INTO sic (code,description) VALUES ('424720','Petroleum and Petroleum Products Merchant Wholesalers (except Bulk Stations and Terminals)'); -INSERT INTO sic (code,description) VALUES ('4248','Beer, Wine, and Distilled Alcoholic Beverage Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42481','Beer and Ale Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424810','Beer and Ale Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42482','Wine and Distilled Alcoholic Beverage Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424820','Wine and Distilled Alcoholic Beverage Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('4249','Miscellaneous Nondurable Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42491','Farm Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424910','Farm Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42492','Book, Periodical, and Newspaper Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424920','Book, Periodical, and Newspaper Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42493','Flower, Nursery Stock, and Florists\' Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424930','Flower, Nursery Stock, and Florists\' Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42494','Tobacco and Tobacco Product Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424940','Tobacco and Tobacco Product Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42495','Paint, Varnish, and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424950','Paint, Varnish, and Supplies Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('42499','Other Miscellaneous Nondurable Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('424990','Other Miscellaneous Nondurable Goods Merchant Wholesalers'); -INSERT INTO sic (code,description) VALUES ('425','Wholesale Electronic Markets and Agents and Brokers'); -INSERT INTO sic (code,description) VALUES ('4251','Wholesale Electronic Markets and Agents and Brokers'); -INSERT INTO sic (code,description) VALUES ('42511','Business to Business Electronic Markets'); -INSERT INTO sic (code,description) VALUES ('425110','Business to Business Electronic Markets'); -INSERT INTO sic (code,description) VALUES ('42512','Wholesale Trade Agents and Brokers'); -INSERT INTO sic (code,description) VALUES ('425120','Wholesale Trade Agents and Brokers'); -INSERT INTO sic (code,description) VALUES ('44-45','Retail Trade'); -INSERT INTO sic (code,description) VALUES ('441','Motor Vehicle and Parts Dealers'); -INSERT INTO sic (code,description) VALUES ('4411','Automobile Dealers'); -INSERT INTO sic (code,description) VALUES ('44111','New Car Dealers'); -INSERT INTO sic (code,description) VALUES ('441110','New Car Dealers'); -INSERT INTO sic (code,description) VALUES ('44112','Used Car Dealers'); -INSERT INTO sic (code,description) VALUES ('441120','Used Car Dealers'); -INSERT INTO sic (code,description) VALUES ('4412','Other Motor Vehicle Dealers'); -INSERT INTO sic (code,description) VALUES ('44121','Recreational Vehicle Dealers'); -INSERT INTO sic (code,description) VALUES ('441210','Recreational Vehicle Dealers'); -INSERT INTO sic (code,description) VALUES ('44122','Motorcycle, Boat, and Other Motor Vehicle Dealers'); -INSERT INTO sic (code,description) VALUES ('441221','Motorcycle Dealers'); -INSERT INTO sic (code,description) VALUES ('441222','Boat Dealers'); -INSERT INTO sic (code,description) VALUES ('441229','All Other Motor Vehicle Dealers'); -INSERT INTO sic (code,description) VALUES ('4413','Automotive Parts, Accessories, and Tire Stores'); -INSERT INTO sic (code,description) VALUES ('44131','Automotive Parts and Accessories Stores'); -INSERT INTO sic (code,description) VALUES ('441310','Automotive Parts and Accessories Stores'); -INSERT INTO sic (code,description) VALUES ('44132','Tire Dealers'); -INSERT INTO sic (code,description) VALUES ('441320','Tire Dealers'); -INSERT INTO sic (code,description) VALUES ('442','Furniture and Home Furnishings Stores'); -INSERT INTO sic (code,description) VALUES ('4421','Furniture Stores'); -INSERT INTO sic (code,description) VALUES ('44211','Furniture Stores'); -INSERT INTO sic (code,description) VALUES ('442110','Furniture Stores'); -INSERT INTO sic (code,description) VALUES ('4422','Home Furnishings Stores'); -INSERT INTO sic (code,description) VALUES ('44221','Floor Covering Stores'); -INSERT INTO sic (code,description) VALUES ('442210','Floor Covering Stores'); -INSERT INTO sic (code,description) VALUES ('44229','Other Home Furnishings Stores'); -INSERT INTO sic (code,description) VALUES ('442291','Window Treatment Stores'); -INSERT INTO sic (code,description) VALUES ('442299','All Other Home Furnishings Stores'); -INSERT INTO sic (code,description) VALUES ('443','Electronics and Appliance Stores'); -INSERT INTO sic (code,description) VALUES ('4431','Electronics and Appliance Stores'); -INSERT INTO sic (code,description) VALUES ('44311','Appliance, Television, and Other Electronics Stores'); -INSERT INTO sic (code,description) VALUES ('443111','Household Appliance Stores'); -INSERT INTO sic (code,description) VALUES ('443112','Radio, Television, and Other Electronics Stores'); -INSERT INTO sic (code,description) VALUES ('44312','Computer and Software Stores'); -INSERT INTO sic (code,description) VALUES ('443120','Computer and Software Stores'); -INSERT INTO sic (code,description) VALUES ('44313','Camera and Photographic Supplies Stores'); -INSERT INTO sic (code,description) VALUES ('443130','Camera and Photographic Supplies Stores'); -INSERT INTO sic (code,description) VALUES ('444','Building Material and Garden Equipment and Supplies Dealers'); -INSERT INTO sic (code,description) VALUES ('4441','Building Material and Supplies Dealers'); -INSERT INTO sic (code,description) VALUES ('44411','Home Centers'); -INSERT INTO sic (code,description) VALUES ('444110','Home Centers'); -INSERT INTO sic (code,description) VALUES ('44412','Paint and Wallpaper Stores'); -INSERT INTO sic (code,description) VALUES ('444120','Paint and Wallpaper Stores'); -INSERT INTO sic (code,description) VALUES ('44413','Hardware Stores'); -INSERT INTO sic (code,description) VALUES ('444130','Hardware Stores'); -INSERT INTO sic (code,description) VALUES ('44419','Other Building Material Dealers'); -INSERT INTO sic (code,description) VALUES ('444190','Other Building Material Dealers'); -INSERT INTO sic (code,description) VALUES ('4442','Lawn and Garden Equipment and Supplies Stores'); -INSERT INTO sic (code,description) VALUES ('44421','Outdoor Power Equipment Stores'); -INSERT INTO sic (code,description) VALUES ('444210','Outdoor Power Equipment Stores'); -INSERT INTO sic (code,description) VALUES ('44422','Nursery, Garden Center, and Farm Supply Stores'); -INSERT INTO sic (code,description) VALUES ('444220','Nursery, Garden Center, and Farm Supply Stores'); -INSERT INTO sic (code,description) VALUES ('445','Food and Beverage Stores'); -INSERT INTO sic (code,description) VALUES ('4451','Grocery Stores'); -INSERT INTO sic (code,description) VALUES ('44511','Supermarkets and Other Grocery (except Convenience) Stores'); -INSERT INTO sic (code,description) VALUES ('445110','Supermarkets and Other Grocery (except Convenience) Stores'); -INSERT INTO sic (code,description) VALUES ('44512','Convenience Stores'); -INSERT INTO sic (code,description) VALUES ('445120','Convenience Stores'); -INSERT INTO sic (code,description) VALUES ('4452','Specialty Food Stores'); -INSERT INTO sic (code,description) VALUES ('44521','Meat Markets'); -INSERT INTO sic (code,description) VALUES ('445210','Meat Markets'); -INSERT INTO sic (code,description) VALUES ('44522','Fish and Seafood Markets'); -INSERT INTO sic (code,description) VALUES ('445220','Fish and Seafood Markets'); -INSERT INTO sic (code,description) VALUES ('44523','Fruit and Vegetable Markets'); -INSERT INTO sic (code,description) VALUES ('445230','Fruit and Vegetable Markets'); -INSERT INTO sic (code,description) VALUES ('44529','Other Specialty Food Stores'); -INSERT INTO sic (code,description) VALUES ('445291','Baked Goods Stores'); -INSERT INTO sic (code,description) VALUES ('445292','Confectionery and Nut Stores'); -INSERT INTO sic (code,description) VALUES ('445299','All Other Specialty Food Stores'); -INSERT INTO sic (code,description) VALUES ('4453','Beer, Wine, and Liquor Stores'); -INSERT INTO sic (code,description) VALUES ('44531','Beer, Wine, and Liquor Stores'); -INSERT INTO sic (code,description) VALUES ('445310','Beer, Wine, and Liquor Stores'); -INSERT INTO sic (code,description) VALUES ('446','Health and Personal Care Stores'); -INSERT INTO sic (code,description) VALUES ('4461','Health and Personal Care Stores'); -INSERT INTO sic (code,description) VALUES ('44611','Pharmacies and Drug Stores'); -INSERT INTO sic (code,description) VALUES ('446110','Pharmacies and Drug Stores'); -INSERT INTO sic (code,description) VALUES ('44612','Cosmetics, Beauty Supplies, and Perfume Stores'); -INSERT INTO sic (code,description) VALUES ('446120','Cosmetics, Beauty Supplies, and Perfume Stores'); -INSERT INTO sic (code,description) VALUES ('44613','Optical Goods Stores'); -INSERT INTO sic (code,description) VALUES ('446130','Optical Goods Stores'); -INSERT INTO sic (code,description) VALUES ('44619','Other Health and Personal Care Stores'); -INSERT INTO sic (code,description) VALUES ('446191','Food (Health) Supplement Stores'); -INSERT INTO sic (code,description) VALUES ('446199','All Other Health and Personal Care Stores'); -INSERT INTO sic (code,description) VALUES ('447','Gasoline Stations'); -INSERT INTO sic (code,description) VALUES ('4471','Gasoline Stations'); -INSERT INTO sic (code,description) VALUES ('44711','Gasoline Stations with Convenience Stores'); -INSERT INTO sic (code,description) VALUES ('447110','Gasoline Stations with Convenience Stores'); -INSERT INTO sic (code,description) VALUES ('44719','Other Gasoline Stations'); -INSERT INTO sic (code,description) VALUES ('447190','Other Gasoline Stations'); -INSERT INTO sic (code,description) VALUES ('448','Clothing and Clothing Accessories Stores'); -INSERT INTO sic (code,description) VALUES ('4481','Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('44811','Men\'s Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('448110','Men\'s Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('44812','Women\'s Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('448120','Women\'s Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('44813','Children\'s and Infants\' Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('448130','Children\'s and Infants\' Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('44814','Family Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('448140','Family Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('44815','Clothing Accessories Stores'); -INSERT INTO sic (code,description) VALUES ('448150','Clothing Accessories Stores'); -INSERT INTO sic (code,description) VALUES ('44819','Other Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('448190','Other Clothing Stores'); -INSERT INTO sic (code,description) VALUES ('4482','Shoe Stores'); -INSERT INTO sic (code,description) VALUES ('44821','Shoe Stores'); -INSERT INTO sic (code,description) VALUES ('448210','Shoe Stores'); -INSERT INTO sic (code,description) VALUES ('4483','Jewelry, Luggage, and Leather Goods Stores'); -INSERT INTO sic (code,description) VALUES ('44831','Jewelry Stores'); -INSERT INTO sic (code,description) VALUES ('448310','Jewelry Stores'); -INSERT INTO sic (code,description) VALUES ('44832','Luggage and Leather Goods Stores'); -INSERT INTO sic (code,description) VALUES ('448320','Luggage and Leather Goods Stores'); -INSERT INTO sic (code,description) VALUES ('451','Sporting Goods, Hobby, Book, and Music Stores'); -INSERT INTO sic (code,description) VALUES ('4511','Sporting Goods, Hobby, and Musical Instrument Stores'); -INSERT INTO sic (code,description) VALUES ('45111','Sporting Goods Stores'); -INSERT INTO sic (code,description) VALUES ('451110','Sporting Goods Stores'); -INSERT INTO sic (code,description) VALUES ('45112','Hobby, Toy, and Game Stores'); -INSERT INTO sic (code,description) VALUES ('451120','Hobby, Toy, and Game Stores'); -INSERT INTO sic (code,description) VALUES ('45113','Sewing, Needlework, and Piece Goods Stores'); -INSERT INTO sic (code,description) VALUES ('451130','Sewing, Needlework, and Piece Goods Stores'); -INSERT INTO sic (code,description) VALUES ('45114','Musical Instrument and Supplies Stores'); -INSERT INTO sic (code,description) VALUES ('451140','Musical Instrument and Supplies Stores'); -INSERT INTO sic (code,description) VALUES ('4512','Book, Periodical, and Music Stores'); -INSERT INTO sic (code,description) VALUES ('45121','Book Stores and News Dealers'); -INSERT INTO sic (code,description) VALUES ('451211','Book Stores'); -INSERT INTO sic (code,description) VALUES ('451212','News Dealers and Newsstands'); -INSERT INTO sic (code,description) VALUES ('45122','Prerecorded Tape, Compact Disc, and Record Stores'); -INSERT INTO sic (code,description) VALUES ('451220','Prerecorded Tape, Compact Disc, and Record Stores'); -INSERT INTO sic (code,description) VALUES ('452','General Merchandise Stores'); -INSERT INTO sic (code,description) VALUES ('4521','Department Stores'); -INSERT INTO sic (code,description) VALUES ('45211','Department Stores'); -INSERT INTO sic (code,description) VALUES ('452111','Department Stores (except Discount Department Stores)'); -INSERT INTO sic (code,description) VALUES ('452112','Discount Department Stores'); -INSERT INTO sic (code,description) VALUES ('4529','Other General Merchandise Stores'); -INSERT INTO sic (code,description) VALUES ('45291','Warehouse Clubs and Supercenters'); -INSERT INTO sic (code,description) VALUES ('452910','Warehouse Clubs and Supercenters'); -INSERT INTO sic (code,description) VALUES ('45299','All Other General Merchandise Stores'); -INSERT INTO sic (code,description) VALUES ('452990','All Other General Merchandise Stores'); -INSERT INTO sic (code,description) VALUES ('453','Miscellaneous Store Retailers'); -INSERT INTO sic (code,description) VALUES ('4531','Florists'); -INSERT INTO sic (code,description) VALUES ('45311','Florists'); -INSERT INTO sic (code,description) VALUES ('453110','Florists'); -INSERT INTO sic (code,description) VALUES ('4532','Office Supplies, Stationery, and Gift Stores'); -INSERT INTO sic (code,description) VALUES ('45321','Office Supplies and Stationery Stores'); -INSERT INTO sic (code,description) VALUES ('453210','Office Supplies and Stationery Stores'); -INSERT INTO sic (code,description) VALUES ('45322','Gift, Novelty, and Souvenir Stores'); -INSERT INTO sic (code,description) VALUES ('453220','Gift, Novelty, and Souvenir Stores'); -INSERT INTO sic (code,description) VALUES ('4533','Used Merchandise Stores'); -INSERT INTO sic (code,description) VALUES ('45331','Used Merchandise Stores'); -INSERT INTO sic (code,description) VALUES ('453310','Used Merchandise Stores'); -INSERT INTO sic (code,description) VALUES ('4539','Other Miscellaneous Store Retailers'); -INSERT INTO sic (code,description) VALUES ('45391','Pet and Pet Supplies Stores'); -INSERT INTO sic (code,description) VALUES ('453910','Pet and Pet Supplies Stores'); -INSERT INTO sic (code,description) VALUES ('45392','Art Dealers'); -INSERT INTO sic (code,description) VALUES ('453920','Art Dealers'); -INSERT INTO sic (code,description) VALUES ('45393','Manufactured (Mobile) Home Dealers'); -INSERT INTO sic (code,description) VALUES ('453930','Manufactured (Mobile) Home Dealers'); -INSERT INTO sic (code,description) VALUES ('45399','All Other Miscellaneous Store Retailers'); -INSERT INTO sic (code,description) VALUES ('453991','Tobacco Stores'); -INSERT INTO sic (code,description) VALUES ('453998','All Other Miscellaneous Store Retailers (except Tobacco Stores)'); -INSERT INTO sic (code,description) VALUES ('454','Nonstore Retailers'); -INSERT INTO sic (code,description) VALUES ('4541','Electronic Shopping and Mail-Order Houses'); -INSERT INTO sic (code,description) VALUES ('45411','Electronic Shopping and Mail-Order Houses'); -INSERT INTO sic (code,description) VALUES ('454111','Electronic Shopping'); -INSERT INTO sic (code,description) VALUES ('454112','Electronic Auctions'); -INSERT INTO sic (code,description) VALUES ('454113','Mail-Order Houses'); -INSERT INTO sic (code,description) VALUES ('4542','Vending Machine Operators'); -INSERT INTO sic (code,description) VALUES ('45421','Vending Machine Operators'); -INSERT INTO sic (code,description) VALUES ('454210','Vending Machine Operators'); -INSERT INTO sic (code,description) VALUES ('4543','Direct Selling Establishments'); -INSERT INTO sic (code,description) VALUES ('45431','Fuel Dealers'); -INSERT INTO sic (code,description) VALUES ('454311','Heating Oil Dealers'); -INSERT INTO sic (code,description) VALUES ('454312','Liquefied Petroleum Gas (Bottled Gas) Dealers'); -INSERT INTO sic (code,description) VALUES ('454319','Other Fuel Dealers'); -INSERT INTO sic (code,description) VALUES ('45439','Other Direct Selling Establishments'); -INSERT INTO sic (code,description) VALUES ('454390','Other Direct Selling Establishments'); -INSERT INTO sic (code,description) VALUES ('48-49','Transportation and Warehousing'); -INSERT INTO sic (code,description) VALUES ('481','Air Transportation'); -INSERT INTO sic (code,description) VALUES ('4811','Scheduled Air Transportation'); -INSERT INTO sic (code,description) VALUES ('48111','Scheduled Air Transportation'); -INSERT INTO sic (code,description) VALUES ('481111','Scheduled Passenger Air Transportation'); -INSERT INTO sic (code,description) VALUES ('481112','Scheduled Freight Air Transportation'); -INSERT INTO sic (code,description) VALUES ('4812','Nonscheduled Air Transportation'); -INSERT INTO sic (code,description) VALUES ('48121','Nonscheduled Air Transportation'); -INSERT INTO sic (code,description) VALUES ('481211','Nonscheduled Chartered Passenger Air Transportation'); -INSERT INTO sic (code,description) VALUES ('481212','Nonscheduled Chartered Freight Air Transportation'); -INSERT INTO sic (code,description) VALUES ('481219','Other Nonscheduled Air Transportation'); -INSERT INTO sic (code,description) VALUES ('482','Rail Transportation'); -INSERT INTO sic (code,description) VALUES ('4821','Rail Transportation'); -INSERT INTO sic (code,description) VALUES ('48211','Rail Transportation'); -INSERT INTO sic (code,description) VALUES ('482111','Line-Haul Railroads'); -INSERT INTO sic (code,description) VALUES ('482112','Short Line Railroads'); -INSERT INTO sic (code,description) VALUES ('483','Water Transportation'); -INSERT INTO sic (code,description) VALUES ('4831','Deep Sea, Coastal, and Great Lakes Water Transportation'); -INSERT INTO sic (code,description) VALUES ('48311','Deep Sea, Coastal, and Great Lakes Water Transportation'); -INSERT INTO sic (code,description) VALUES ('483111','Deep Sea Freight Transportation'); -INSERT INTO sic (code,description) VALUES ('483112','Deep Sea Passenger Transportation'); -INSERT INTO sic (code,description) VALUES ('483113','Coastal and Great Lakes Freight Transportation'); -INSERT INTO sic (code,description) VALUES ('483114','Coastal and Great Lakes Passenger Transportation'); -INSERT INTO sic (code,description) VALUES ('4832','Inland Water Transportation'); -INSERT INTO sic (code,description) VALUES ('48321','Inland Water Transportation'); -INSERT INTO sic (code,description) VALUES ('483211','Inland Water Freight Transportation'); -INSERT INTO sic (code,description) VALUES ('483212','Inland Water Passenger Transportation'); -INSERT INTO sic (code,description) VALUES ('484','Truck Transportation'); -INSERT INTO sic (code,description) VALUES ('4841','General Freight Trucking'); -INSERT INTO sic (code,description) VALUES ('48411','General Freight Trucking, Local'); -INSERT INTO sic (code,description) VALUES ('484110','General Freight Trucking, Local'); -INSERT INTO sic (code,description) VALUES ('48412','General Freight Trucking, Long-Distance'); -INSERT INTO sic (code,description) VALUES ('484121','General Freight Trucking, Long-Distance, Truckload'); -INSERT INTO sic (code,description) VALUES ('484122','General Freight Trucking, Long-Distance, Less Than Truckload'); -INSERT INTO sic (code,description) VALUES ('4842','Specialized Freight Trucking'); -INSERT INTO sic (code,description) VALUES ('48421','Used Household and Office Goods Moving'); -INSERT INTO sic (code,description) VALUES ('484210','Used Household and Office Goods Moving'); -INSERT INTO sic (code,description) VALUES ('48422','Specialized Freight (except Used Goods) Trucking, Local'); -INSERT INTO sic (code,description) VALUES ('484220','Specialized Freight (except Used Goods) Trucking, Local'); -INSERT INTO sic (code,description) VALUES ('48423','Specialized Freight (except Used Goods) Trucking, Long-Distance'); -INSERT INTO sic (code,description) VALUES ('484230','Specialized Freight (except Used Goods) Trucking, Long-Distance'); -INSERT INTO sic (code,description) VALUES ('485','Transit and Ground Passenger Transportation'); -INSERT INTO sic (code,description) VALUES ('4851','Urban Transit Systems'); -INSERT INTO sic (code,description) VALUES ('48511','Urban Transit Systems'); -INSERT INTO sic (code,description) VALUES ('485111','Mixed Mode Transit Systems'); -INSERT INTO sic (code,description) VALUES ('485112','Commuter Rail Systems'); -INSERT INTO sic (code,description) VALUES ('485113','Bus and Other Motor Vehicle Transit Systems'); -INSERT INTO sic (code,description) VALUES ('485119','Other Urban Transit Systems'); -INSERT INTO sic (code,description) VALUES ('4852','Interurban and Rural Bus Transportation'); -INSERT INTO sic (code,description) VALUES ('48521','Interurban and Rural Bus Transportation'); -INSERT INTO sic (code,description) VALUES ('485210','Interurban and Rural Bus Transportation'); -INSERT INTO sic (code,description) VALUES ('4853','Taxi and Limousine Service'); -INSERT INTO sic (code,description) VALUES ('48531','Taxi Service'); -INSERT INTO sic (code,description) VALUES ('485310','Taxi Service'); -INSERT INTO sic (code,description) VALUES ('48532','Limousine Service'); -INSERT INTO sic (code,description) VALUES ('485320','Limousine Service'); -INSERT INTO sic (code,description) VALUES ('4854','School and Employee Bus Transportation'); -INSERT INTO sic (code,description) VALUES ('48541','School and Employee Bus Transportation'); -INSERT INTO sic (code,description) VALUES ('485410','School and Employee Bus Transportation'); -INSERT INTO sic (code,description) VALUES ('4855','Charter Bus Industry'); -INSERT INTO sic (code,description) VALUES ('48551','Charter Bus Industry'); -INSERT INTO sic (code,description) VALUES ('485510','Charter Bus Industry'); -INSERT INTO sic (code,description) VALUES ('4859','Other Transit and Ground Passenger Transportation'); -INSERT INTO sic (code,description) VALUES ('48599','Other Transit and Ground Passenger Transportation'); -INSERT INTO sic (code,description) VALUES ('485991','Special Needs Transportation'); -INSERT INTO sic (code,description) VALUES ('485999','All Other Transit and Ground Passenger Transportation'); -INSERT INTO sic (code,description) VALUES ('486','Pipeline Transportation'); -INSERT INTO sic (code,description) VALUES ('4861','Pipeline Transportation of Crude Oil'); -INSERT INTO sic (code,description) VALUES ('48611','Pipeline Transportation of Crude Oil'); -INSERT INTO sic (code,description) VALUES ('486110','Pipeline Transportation of Crude Oil'); -INSERT INTO sic (code,description) VALUES ('4862','Pipeline Transportation of Natural Gas'); -INSERT INTO sic (code,description) VALUES ('48621','Pipeline Transportation of Natural Gas'); -INSERT INTO sic (code,description) VALUES ('486210','Pipeline Transportation of Natural Gas'); -INSERT INTO sic (code,description) VALUES ('4869','Other Pipeline Transportation'); -INSERT INTO sic (code,description) VALUES ('48691','Pipeline Transportation of Refined Petroleum Products'); -INSERT INTO sic (code,description) VALUES ('486910','Pipeline Transportation of Refined Petroleum Products'); -INSERT INTO sic (code,description) VALUES ('48699','All Other Pipeline Transportation'); -INSERT INTO sic (code,description) VALUES ('486990','All Other Pipeline Transportation'); -INSERT INTO sic (code,description) VALUES ('487','Scenic and Sightseeing Transportation'); -INSERT INTO sic (code,description) VALUES ('4871','Scenic and Sightseeing Transportation, Land'); -INSERT INTO sic (code,description) VALUES ('48711','Scenic and Sightseeing Transportation, Land'); -INSERT INTO sic (code,description) VALUES ('487110','Scenic and Sightseeing Transportation, Land'); -INSERT INTO sic (code,description) VALUES ('4872','Scenic and Sightseeing Transportation, Water'); -INSERT INTO sic (code,description) VALUES ('48721','Scenic and Sightseeing Transportation, Water'); -INSERT INTO sic (code,description) VALUES ('487210','Scenic and Sightseeing Transportation, Water'); -INSERT INTO sic (code,description) VALUES ('4879','Scenic and Sightseeing Transportation, Other'); -INSERT INTO sic (code,description) VALUES ('48799','Scenic and Sightseeing Transportation, Other'); -INSERT INTO sic (code,description) VALUES ('487990','Scenic and Sightseeing Transportation, Other'); -INSERT INTO sic (code,description) VALUES ('488','Support Activities for Transportation'); -INSERT INTO sic (code,description) VALUES ('4881','Support Activities for Air Transportation'); -INSERT INTO sic (code,description) VALUES ('48811','Airport Operations'); -INSERT INTO sic (code,description) VALUES ('488111','Air Traffic Control'); -INSERT INTO sic (code,description) VALUES ('488119','Other Airport Operations'); -INSERT INTO sic (code,description) VALUES ('48819','Other Support Activities for Air Transportation'); -INSERT INTO sic (code,description) VALUES ('488190','Other Support Activities for Air Transportation'); -INSERT INTO sic (code,description) VALUES ('4882','Support Activities for Rail Transportation'); -INSERT INTO sic (code,description) VALUES ('48821','Support Activities for Rail Transportation'); -INSERT INTO sic (code,description) VALUES ('488210','Support Activities for Rail Transportation'); -INSERT INTO sic (code,description) VALUES ('4883','Support Activities for Water Transportation'); -INSERT INTO sic (code,description) VALUES ('48831','Port and Harbor Operations'); -INSERT INTO sic (code,description) VALUES ('488310','Port and Harbor Operations'); -INSERT INTO sic (code,description) VALUES ('48832','Marine Cargo Handling'); -INSERT INTO sic (code,description) VALUES ('488320','Marine Cargo Handling'); -INSERT INTO sic (code,description) VALUES ('48833','Navigational Services to Shipping'); -INSERT INTO sic (code,description) VALUES ('488330','Navigational Services to Shipping'); -INSERT INTO sic (code,description) VALUES ('48839','Other Support Activities for Water Transportation'); -INSERT INTO sic (code,description) VALUES ('488390','Other Support Activities for Water Transportation'); -INSERT INTO sic (code,description) VALUES ('4884','Support Activities for Road Transportation'); -INSERT INTO sic (code,description) VALUES ('48841','Motor Vehicle Towing'); -INSERT INTO sic (code,description) VALUES ('488410','Motor Vehicle Towing'); -INSERT INTO sic (code,description) VALUES ('48849','Other Support Activities for Road Transportation'); -INSERT INTO sic (code,description) VALUES ('488490','Other Support Activities for Road Transportation'); -INSERT INTO sic (code,description) VALUES ('4885','Freight Transportation Arrangement'); -INSERT INTO sic (code,description) VALUES ('48851','Freight Transportation Arrangement'); -INSERT INTO sic (code,description) VALUES ('488510','Freight Transportation Arrangement'); -INSERT INTO sic (code,description) VALUES ('4889','Other Support Activities for Transportation'); -INSERT INTO sic (code,description) VALUES ('48899','Other Support Activities for Transportation'); -INSERT INTO sic (code,description) VALUES ('488991','Packing and Crating'); -INSERT INTO sic (code,description) VALUES ('488999','All Other Support Activities for Transportation'); -INSERT INTO sic (code,description) VALUES ('491','Postal Service'); -INSERT INTO sic (code,description) VALUES ('4911','Postal Service'); -INSERT INTO sic (code,description) VALUES ('49111','Postal Service'); -INSERT INTO sic (code,description) VALUES ('491110','Postal Service'); -INSERT INTO sic (code,description) VALUES ('492','Couriers and Messengers'); -INSERT INTO sic (code,description) VALUES ('4921','Couriers'); -INSERT INTO sic (code,description) VALUES ('49211','Couriers'); -INSERT INTO sic (code,description) VALUES ('492110','Couriers'); -INSERT INTO sic (code,description) VALUES ('4922','Local Messengers and Local Delivery'); -INSERT INTO sic (code,description) VALUES ('49221','Local Messengers and Local Delivery'); -INSERT INTO sic (code,description) VALUES ('492210','Local Messengers and Local Delivery'); -INSERT INTO sic (code,description) VALUES ('493','Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('4931','Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('49311','General Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('493110','General Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('49312','Refrigerated Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('493120','Refrigerated Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('49313','Farm Product Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('493130','Farm Product Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('49319','Other Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('493190','Other Warehousing and Storage'); -INSERT INTO sic (code,description) VALUES ('51','Information'); -INSERT INTO sic (code,description) VALUES ('511','Publishing Industries (except Internet)'); -INSERT INTO sic (code,description) VALUES ('5111','Newspaper, Periodical, Book, and Directory Publishers'); -INSERT INTO sic (code,description) VALUES ('51111','Newspaper Publishers'); -INSERT INTO sic (code,description) VALUES ('511110','Newspaper Publishers'); -INSERT INTO sic (code,description) VALUES ('51112','Periodical Publishers'); -INSERT INTO sic (code,description) VALUES ('511120','Periodical Publishers'); -INSERT INTO sic (code,description) VALUES ('51113','Book Publishers'); -INSERT INTO sic (code,description) VALUES ('511130','Book Publishers'); -INSERT INTO sic (code,description) VALUES ('51114','Directory and Mailing List Publishers'); -INSERT INTO sic (code,description) VALUES ('511140','Directory and Mailing List Publishers'); -INSERT INTO sic (code,description) VALUES ('51119','Other Publishers'); -INSERT INTO sic (code,description) VALUES ('511191','Greeting Card Publishers'); -INSERT INTO sic (code,description) VALUES ('511199','All Other Publishers'); -INSERT INTO sic (code,description) VALUES ('5112','Software Publishers'); -INSERT INTO sic (code,description) VALUES ('51121','Software Publishers'); -INSERT INTO sic (code,description) VALUES ('511210','Software Publishers'); -INSERT INTO sic (code,description) VALUES ('512','Motion Picture and Sound Recording Industries'); -INSERT INTO sic (code,description) VALUES ('5121','Motion Picture and Video Industries'); -INSERT INTO sic (code,description) VALUES ('51211','Motion Picture and Video Production'); -INSERT INTO sic (code,description) VALUES ('512110','Motion Picture and Video Production'); -INSERT INTO sic (code,description) VALUES ('51212','Motion Picture and Video Distribution'); -INSERT INTO sic (code,description) VALUES ('512120','Motion Picture and Video Distribution'); -INSERT INTO sic (code,description) VALUES ('51213','Motion Picture and Video Exhibition'); -INSERT INTO sic (code,description) VALUES ('512131','Motion Picture Theaters (except Drive-Ins)'); -INSERT INTO sic (code,description) VALUES ('512132','Drive-In Motion Picture Theaters'); -INSERT INTO sic (code,description) VALUES ('51219','Postproduction Services and Other Motion Picture and Video Industries'); -INSERT INTO sic (code,description) VALUES ('512191','Teleproduction and Other Postproduction Services'); -INSERT INTO sic (code,description) VALUES ('512199','Other Motion Picture and Video Industries'); -INSERT INTO sic (code,description) VALUES ('5122','Sound Recording Industries'); -INSERT INTO sic (code,description) VALUES ('51221','Record Production'); -INSERT INTO sic (code,description) VALUES ('512210','Record Production'); -INSERT INTO sic (code,description) VALUES ('51222','Integrated Record Production/Distribution'); -INSERT INTO sic (code,description) VALUES ('512220','Integrated Record Production/Distribution'); -INSERT INTO sic (code,description) VALUES ('51223','Music Publishers'); -INSERT INTO sic (code,description) VALUES ('512230','Music Publishers'); -INSERT INTO sic (code,description) VALUES ('51224','Sound Recording Studios'); -INSERT INTO sic (code,description) VALUES ('512240','Sound Recording Studios'); -INSERT INTO sic (code,description) VALUES ('51229','Other Sound Recording Industries'); -INSERT INTO sic (code,description) VALUES ('512290','Other Sound Recording Industries'); -INSERT INTO sic (code,description) VALUES ('515','Broadcasting (except Internet)'); -INSERT INTO sic (code,description) VALUES ('5151','Radio and Television Broadcasting'); -INSERT INTO sic (code,description) VALUES ('51511','Radio Broadcasting'); -INSERT INTO sic (code,description) VALUES ('515111','Radio Networks'); -INSERT INTO sic (code,description) VALUES ('515112','Radio Stations'); -INSERT INTO sic (code,description) VALUES ('51512','Television Broadcasting'); -INSERT INTO sic (code,description) VALUES ('515120','Television Broadcasting'); -INSERT INTO sic (code,description) VALUES ('5152','Cable and Other Subscription Programming'); -INSERT INTO sic (code,description) VALUES ('51521','Cable and Other Subscription Programming'); -INSERT INTO sic (code,description) VALUES ('515210','Cable and Other Subscription Programming'); -INSERT INTO sic (code,description) VALUES ('516','Internet Publishing and Broadcasting'); -INSERT INTO sic (code,description) VALUES ('5161','Internet Publishing and Broadcasting'); -INSERT INTO sic (code,description) VALUES ('51611','Internet Publishing and Broadcasting'); -INSERT INTO sic (code,description) VALUES ('516110','Internet Publishing and Broadcasting'); -INSERT INTO sic (code,description) VALUES ('517','Telecommunications'); -INSERT INTO sic (code,description) VALUES ('5171','Wired Telecommunications Carriers'); -INSERT INTO sic (code,description) VALUES ('51711','Wired Telecommunications Carriers'); -INSERT INTO sic (code,description) VALUES ('517110','Wired Telecommunications Carriers'); -INSERT INTO sic (code,description) VALUES ('5172','Wireless Telecommunications Carriers (except Satellite)'); -INSERT INTO sic (code,description) VALUES ('51721','Wireless Telecommunications Carriers (except Satellite)'); -INSERT INTO sic (code,description) VALUES ('517211','Paging'); -INSERT INTO sic (code,description) VALUES ('517212','Cellular and Other Wireless Telecommunications'); -INSERT INTO sic (code,description) VALUES ('5173','Telecommunications Resellers'); -INSERT INTO sic (code,description) VALUES ('51731','Telecommunications Resellers'); -INSERT INTO sic (code,description) VALUES ('517310','Telecommunications Resellers'); -INSERT INTO sic (code,description) VALUES ('5174','Satellite Telecommunications'); -INSERT INTO sic (code,description) VALUES ('51741','Satellite Telecommunications'); -INSERT INTO sic (code,description) VALUES ('517410','Satellite Telecommunications'); -INSERT INTO sic (code,description) VALUES ('5175','Cable and Other Program Distribution'); -INSERT INTO sic (code,description) VALUES ('51751','Cable and Other Program Distribution'); -INSERT INTO sic (code,description) VALUES ('517510','Cable and Other Program Distribution'); -INSERT INTO sic (code,description) VALUES ('5179','Other Telecommunications'); -INSERT INTO sic (code,description) VALUES ('51791','Other Telecommunications'); -INSERT INTO sic (code,description) VALUES ('517910','Other Telecommunications'); -INSERT INTO sic (code,description) VALUES ('518','Internet Service Providers, Web Search Portals, and Data Processing Services'); -INSERT INTO sic (code,description) VALUES ('5181','Internet Service Providers and Web Search Portals'); -INSERT INTO sic (code,description) VALUES ('51811','Internet Service Providers and Web Search Portals'); -INSERT INTO sic (code,description) VALUES ('518111','Internet Service Providers'); -INSERT INTO sic (code,description) VALUES ('518112','Web Search Portals'); -INSERT INTO sic (code,description) VALUES ('5182','Data Processing, Hosting, and Related Services'); -INSERT INTO sic (code,description) VALUES ('51821','Data Processing, Hosting, and Related Services'); -INSERT INTO sic (code,description) VALUES ('518210','Data Processing, Hosting, and Related Services'); -INSERT INTO sic (code,description) VALUES ('519','Other Information Services'); -INSERT INTO sic (code,description) VALUES ('5191','Other Information Services'); -INSERT INTO sic (code,description) VALUES ('51911','News Syndicates'); -INSERT INTO sic (code,description) VALUES ('519110','News Syndicates'); -INSERT INTO sic (code,description) VALUES ('51912','Libraries and Archives'); -INSERT INTO sic (code,description) VALUES ('519120','Libraries and Archives'); -INSERT INTO sic (code,description) VALUES ('51919','All Other Information Services'); -INSERT INTO sic (code,description) VALUES ('519190','All Other Information Services'); -INSERT INTO sic (code,description) VALUES ('52','Finance and Insurance'); -INSERT INTO sic (code,description) VALUES ('521','Monetary Authorities - Central Bank'); -INSERT INTO sic (code,description) VALUES ('5211','Monetary Authorities - Central Bank'); -INSERT INTO sic (code,description) VALUES ('52111','Monetary Authorities - Central Bank'); -INSERT INTO sic (code,description) VALUES ('521110','Monetary Authorities - Central Bank'); -INSERT INTO sic (code,description) VALUES ('522','Credit Intermediation and Related Activities'); -INSERT INTO sic (code,description) VALUES ('5221','Depository Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('52211','Commercial Banking'); -INSERT INTO sic (code,description) VALUES ('522110','Commercial Banking'); -INSERT INTO sic (code,description) VALUES ('52212','Savings Institutions'); -INSERT INTO sic (code,description) VALUES ('522120','Savings Institutions'); -INSERT INTO sic (code,description) VALUES ('52213','Credit Unions'); -INSERT INTO sic (code,description) VALUES ('522130','Credit Unions'); -INSERT INTO sic (code,description) VALUES ('52219','Other Depository Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('522190','Other Depository Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('5222','Nondepository Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('52221','Credit Card Issuing'); -INSERT INTO sic (code,description) VALUES ('522210','Credit Card Issuing'); -INSERT INTO sic (code,description) VALUES ('52222','Sales Financing'); -INSERT INTO sic (code,description) VALUES ('522220','Sales Financing'); -INSERT INTO sic (code,description) VALUES ('52229','Other Nondepository Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('522291','Consumer Lending'); -INSERT INTO sic (code,description) VALUES ('522292','Real Estate Credit'); -INSERT INTO sic (code,description) VALUES ('522293','International Trade Financing'); -INSERT INTO sic (code,description) VALUES ('522294','Secondary Market Financing'); -INSERT INTO sic (code,description) VALUES ('522298','All Other Nondepository Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('5223','Activities Related to Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('52231','Mortgage and Nonmortgage Loan Brokers'); -INSERT INTO sic (code,description) VALUES ('522310','Mortgage and Nonmortgage Loan Brokers'); -INSERT INTO sic (code,description) VALUES ('52232','Financial Transactions Processing, Reserve, and Clearinghouse Activities'); -INSERT INTO sic (code,description) VALUES ('522320','Financial Transactions Processing, Reserve, and Clearinghouse Activities'); -INSERT INTO sic (code,description) VALUES ('52239','Other Activities Related to Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('522390','Other Activities Related to Credit Intermediation'); -INSERT INTO sic (code,description) VALUES ('523','Securities, Commodity Contracts, and Other Financial Investments and Related Activities'); -INSERT INTO sic (code,description) VALUES ('5231','Securities and Commodity Contracts Intermediation and Brokerage'); -INSERT INTO sic (code,description) VALUES ('52311','Investment Banking and Securities Dealing'); -INSERT INTO sic (code,description) VALUES ('523110','Investment Banking and Securities Dealing'); -INSERT INTO sic (code,description) VALUES ('52312','Securities Brokerage'); -INSERT INTO sic (code,description) VALUES ('523120','Securities Brokerage'); -INSERT INTO sic (code,description) VALUES ('52313','Commodity Contracts Dealing'); -INSERT INTO sic (code,description) VALUES ('523130','Commodity Contracts Dealing'); -INSERT INTO sic (code,description) VALUES ('52314','Commodity Contracts Brokerage'); -INSERT INTO sic (code,description) VALUES ('523140','Commodity Contracts Brokerage'); -INSERT INTO sic (code,description) VALUES ('5232','Securities and Commodity Exchanges'); -INSERT INTO sic (code,description) VALUES ('52321','Securities and Commodity Exchanges'); -INSERT INTO sic (code,description) VALUES ('523210','Securities and Commodity Exchanges'); -INSERT INTO sic (code,description) VALUES ('5239','Other Financial Investment Activities'); -INSERT INTO sic (code,description) VALUES ('52391','Miscellaneous Intermediation'); -INSERT INTO sic (code,description) VALUES ('523910','Miscellaneous Intermediation'); -INSERT INTO sic (code,description) VALUES ('52392','Portfolio Management'); -INSERT INTO sic (code,description) VALUES ('523920','Portfolio Management'); -INSERT INTO sic (code,description) VALUES ('52393','Investment Advice'); -INSERT INTO sic (code,description) VALUES ('523930','Investment Advice'); -INSERT INTO sic (code,description) VALUES ('52399','All Other Financial Investment Activities'); -INSERT INTO sic (code,description) VALUES ('523991','Trust, Fiduciary, and Custody Activities'); -INSERT INTO sic (code,description) VALUES ('523999','Miscellaneous Financial Investment Activities'); -INSERT INTO sic (code,description) VALUES ('524','Insurance Carriers and Related Activities'); -INSERT INTO sic (code,description) VALUES ('5241','Insurance Carriers'); -INSERT INTO sic (code,description) VALUES ('52411','Direct Life, Health, and Medical Insurance Carriers'); -INSERT INTO sic (code,description) VALUES ('524113','Direct Life Insurance Carriers'); -INSERT INTO sic (code,description) VALUES ('524114','Direct Health and Medical Insurance Carriers'); -INSERT INTO sic (code,description) VALUES ('52412','Direct Insurance (except Life, Health, and Medical) Carriers'); -INSERT INTO sic (code,description) VALUES ('524126','Direct Property and Casualty Insurance Carriers'); -INSERT INTO sic (code,description) VALUES ('524127','Direct Title Insurance Carriers'); -INSERT INTO sic (code,description) VALUES ('524128','Other Direct Insurance (except Life, Health, and Medical) Carriers'); -INSERT INTO sic (code,description) VALUES ('52413','Reinsurance Carriers'); -INSERT INTO sic (code,description) VALUES ('524130','Reinsurance Carriers'); -INSERT INTO sic (code,description) VALUES ('5242','Agencies, Brokerages, and Other Insurance Related Activities'); -INSERT INTO sic (code,description) VALUES ('52421','Insurance Agencies and Brokerages'); -INSERT INTO sic (code,description) VALUES ('524210','Insurance Agencies and Brokerages'); -INSERT INTO sic (code,description) VALUES ('52429','Other Insurance Related Activities'); -INSERT INTO sic (code,description) VALUES ('524291','Claims Adjusting'); -INSERT INTO sic (code,description) VALUES ('524292','Third Party Administration of Insurance and Pension Funds'); -INSERT INTO sic (code,description) VALUES ('524298','All Other Insurance Related Activities'); -INSERT INTO sic (code,description) VALUES ('525','Funds, Trusts, and Other Financial Vehicles'); -INSERT INTO sic (code,description) VALUES ('5251','Insurance and Employee Benefit Funds'); -INSERT INTO sic (code,description) VALUES ('52511','Pension Funds'); -INSERT INTO sic (code,description) VALUES ('525110','Pension Funds'); -INSERT INTO sic (code,description) VALUES ('52512','Health and Welfare Funds'); -INSERT INTO sic (code,description) VALUES ('525120','Health and Welfare Funds'); -INSERT INTO sic (code,description) VALUES ('52519','Other Insurance Funds'); -INSERT INTO sic (code,description) VALUES ('525190','Other Insurance Funds'); -INSERT INTO sic (code,description) VALUES ('5259','Other Investment Pools and Funds'); -INSERT INTO sic (code,description) VALUES ('52591','Open-End Investment Funds'); -INSERT INTO sic (code,description) VALUES ('525910','Open-End Investment Funds'); -INSERT INTO sic (code,description) VALUES ('52592','Trusts, Estates, and Agency Accounts'); -INSERT INTO sic (code,description) VALUES ('525920','Trusts, Estates, and Agency Accounts'); -INSERT INTO sic (code,description) VALUES ('52593','Real Estate Investment Trusts'); -INSERT INTO sic (code,description) VALUES ('525930','Real Estate Investment Trusts'); -INSERT INTO sic (code,description) VALUES ('52599','Other Financial Vehicles'); -INSERT INTO sic (code,description) VALUES ('525990','Other Financial Vehicles'); -INSERT INTO sic (code,description) VALUES ('53','Real Estate and Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('531','Real Estate'); -INSERT INTO sic (code,description) VALUES ('5311','Lessors of Real Estate'); -INSERT INTO sic (code,description) VALUES ('53111','Lessors of Residential Buildings and Dwellings'); -INSERT INTO sic (code,description) VALUES ('531110','Lessors of Residential Buildings and Dwellings'); -INSERT INTO sic (code,description) VALUES ('53112','Lessors of Nonresidential Buildings (except Miniwarehouses)'); -INSERT INTO sic (code,description) VALUES ('531120','Lessors of Nonresidential Buildings (except Miniwarehouses)'); -INSERT INTO sic (code,description) VALUES ('53113','Lessors of Miniwarehouses and Self-Storage Units'); -INSERT INTO sic (code,description) VALUES ('531130','Lessors of Miniwarehouses and Self-Storage Units'); -INSERT INTO sic (code,description) VALUES ('53119','Lessors of Other Real Estate Property'); -INSERT INTO sic (code,description) VALUES ('531190','Lessors of Other Real Estate Property'); -INSERT INTO sic (code,description) VALUES ('5312','Offices of Real Estate Agents and Brokers'); -INSERT INTO sic (code,description) VALUES ('53121','Offices of Real Estate Agents and Brokers'); -INSERT INTO sic (code,description) VALUES ('531210','Offices of Real Estate Agents and Brokers'); -INSERT INTO sic (code,description) VALUES ('5313','Activities Related to Real Estate'); -INSERT INTO sic (code,description) VALUES ('53131','Real Estate Property Managers'); -INSERT INTO sic (code,description) VALUES ('531311','Residential Property Managers'); -INSERT INTO sic (code,description) VALUES ('531312','Nonresidential Property Managers'); -INSERT INTO sic (code,description) VALUES ('53132','Offices of Real Estate Appraisers'); -INSERT INTO sic (code,description) VALUES ('531320','Offices of Real Estate Appraisers'); -INSERT INTO sic (code,description) VALUES ('53139','Other Activities Related to Real Estate'); -INSERT INTO sic (code,description) VALUES ('531390','Other Activities Related to Real Estate'); -INSERT INTO sic (code,description) VALUES ('532','Rental and Leasing Services'); -INSERT INTO sic (code,description) VALUES ('5321','Automotive Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('53211','Passenger Car Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('532111','Passenger Car Rental'); -INSERT INTO sic (code,description) VALUES ('532112','Passenger Car Leasing'); -INSERT INTO sic (code,description) VALUES ('53212','Truck, Utility Trailer, and RV (Recreational Vehicle) Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('532120','Truck, Utility Trailer, and RV (Recreational Vehicle) Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('5322','Consumer Goods Rental'); -INSERT INTO sic (code,description) VALUES ('53221','Consumer Electronics and Appliances Rental'); -INSERT INTO sic (code,description) VALUES ('532210','Consumer Electronics and Appliances Rental'); -INSERT INTO sic (code,description) VALUES ('53222','Formal Wear and Costume Rental'); -INSERT INTO sic (code,description) VALUES ('532220','Formal Wear and Costume Rental'); -INSERT INTO sic (code,description) VALUES ('53223','Video Tape and Disc Rental'); -INSERT INTO sic (code,description) VALUES ('532230','Video Tape and Disc Rental'); -INSERT INTO sic (code,description) VALUES ('53229','Other Consumer Goods Rental'); -INSERT INTO sic (code,description) VALUES ('532291','Home Health Equipment Rental'); -INSERT INTO sic (code,description) VALUES ('532292','Recreational Goods Rental'); -INSERT INTO sic (code,description) VALUES ('532299','All Other Consumer Goods Rental'); -INSERT INTO sic (code,description) VALUES ('5323','General Rental Centers'); -INSERT INTO sic (code,description) VALUES ('53231','General Rental Centers'); -INSERT INTO sic (code,description) VALUES ('532310','General Rental Centers'); -INSERT INTO sic (code,description) VALUES ('5324','Commercial and Industrial Machinery and Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('53241','Construction, Transportation, Mining, and Forestry Machinery and Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('532411','Commercial Air, Rail, and Water Transportation Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('532412','Construction, Mining, and Forestry Machinery and Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('53242','Office Machinery and Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('532420','Office Machinery and Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('53249','Other Commercial and Industrial Machinery and Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('532490','Other Commercial and Industrial Machinery and Equipment Rental and Leasing'); -INSERT INTO sic (code,description) VALUES ('533','Lessors of Nonfinancial Intangible Assets (except Copyrighted Works)'); -INSERT INTO sic (code,description) VALUES ('5331','Lessors of Nonfinancial Intangible Assets (except Copyrighted Works)'); -INSERT INTO sic (code,description) VALUES ('53311','Lessors of Nonfinancial Intangible Assets (except Copyrighted Works)'); -INSERT INTO sic (code,description) VALUES ('533110','Lessors of Nonfinancial Intangible Assets (except Copyrighted Works)'); -INSERT INTO sic (code,description) VALUES ('54','Professional, Scientific, and Technical Services'); -INSERT INTO sic (code,description) VALUES ('541','Professional, Scientific, and Technical Services'); -INSERT INTO sic (code,description) VALUES ('5411','Legal Services'); -INSERT INTO sic (code,description) VALUES ('54111','Offices of Lawyers'); -INSERT INTO sic (code,description) VALUES ('541110','Offices of Lawyers'); -INSERT INTO sic (code,description) VALUES ('54112','Offices of Notaries'); -INSERT INTO sic (code,description) VALUES ('541120','Offices of Notaries'); -INSERT INTO sic (code,description) VALUES ('54119','Other Legal Services'); -INSERT INTO sic (code,description) VALUES ('541191','Title Abstract and Settlement Offices'); -INSERT INTO sic (code,description) VALUES ('541199','All Other Legal Services'); -INSERT INTO sic (code,description) VALUES ('5412','Accounting, Tax Preparation, Bookkeeping, and Payroll Services'); -INSERT INTO sic (code,description) VALUES ('54121','Accounting, Tax Preparation, Bookkeeping, and Payroll Services'); -INSERT INTO sic (code,description) VALUES ('541211','Offices of Certified Public Accountants'); -INSERT INTO sic (code,description) VALUES ('541213','Tax Preparation Services'); -INSERT INTO sic (code,description) VALUES ('541214','Payroll Services'); -INSERT INTO sic (code,description) VALUES ('541219','Other Accounting Services'); -INSERT INTO sic (code,description) VALUES ('5413','Architectural, Engineering, and Related Services'); -INSERT INTO sic (code,description) VALUES ('54131','Architectural Services'); -INSERT INTO sic (code,description) VALUES ('541310','Architectural Services'); -INSERT INTO sic (code,description) VALUES ('54132','Landscape Architectural Services'); -INSERT INTO sic (code,description) VALUES ('541320','Landscape Architectural Services'); -INSERT INTO sic (code,description) VALUES ('54133','Engineering Services'); -INSERT INTO sic (code,description) VALUES ('541330','Engineering Services'); -INSERT INTO sic (code,description) VALUES ('54134','Drafting Services'); -INSERT INTO sic (code,description) VALUES ('541340','Drafting Services'); -INSERT INTO sic (code,description) VALUES ('54135','Building Inspection Services'); -INSERT INTO sic (code,description) VALUES ('541350','Building Inspection Services'); -INSERT INTO sic (code,description) VALUES ('54136','Geophysical Surveying and Mapping Services'); -INSERT INTO sic (code,description) VALUES ('541360','Geophysical Surveying and Mapping Services'); -INSERT INTO sic (code,description) VALUES ('54137','Surveying and Mapping (except Geophysical) Services'); -INSERT INTO sic (code,description) VALUES ('541370','Surveying and Mapping (except Geophysical) Services'); -INSERT INTO sic (code,description) VALUES ('54138','Testing Laboratories'); -INSERT INTO sic (code,description) VALUES ('541380','Testing Laboratories'); -INSERT INTO sic (code,description) VALUES ('5414','Specialized Design Services'); -INSERT INTO sic (code,description) VALUES ('54141','Interior Design Services'); -INSERT INTO sic (code,description) VALUES ('541410','Interior Design Services'); -INSERT INTO sic (code,description) VALUES ('54142','Industrial Design Services'); -INSERT INTO sic (code,description) VALUES ('541420','Industrial Design Services'); -INSERT INTO sic (code,description) VALUES ('54143','Graphic Design Services'); -INSERT INTO sic (code,description) VALUES ('541430','Graphic Design Services'); -INSERT INTO sic (code,description) VALUES ('54149','Other Specialized Design Services'); -INSERT INTO sic (code,description) VALUES ('541490','Other Specialized Design Services'); -INSERT INTO sic (code,description) VALUES ('5415','Computer Systems Design and Related Services'); -INSERT INTO sic (code,description) VALUES ('54151','Computer Systems Design and Related Services'); -INSERT INTO sic (code,description) VALUES ('541511','Custom Computer Programming Services'); -INSERT INTO sic (code,description) VALUES ('541512','Computer Systems Design Services'); -INSERT INTO sic (code,description) VALUES ('541513','Computer Facilities Management Services'); -INSERT INTO sic (code,description) VALUES ('541519','Other Computer Related Services'); -INSERT INTO sic (code,description) VALUES ('5416','Management, Scientific, and Technical Consulting Services'); -INSERT INTO sic (code,description) VALUES ('54161','Management Consulting Services'); -INSERT INTO sic (code,description) VALUES ('541611','Administrative Management and General Management Consulting Services'); -INSERT INTO sic (code,description) VALUES ('541612','Human Resources and Executive Search Consulting Services'); -INSERT INTO sic (code,description) VALUES ('541613','Marketing Consulting Services'); -INSERT INTO sic (code,description) VALUES ('541614','Process, Physical Distribution, and Logistics Consulting Services'); -INSERT INTO sic (code,description) VALUES ('541618','Other Management Consulting Services'); -INSERT INTO sic (code,description) VALUES ('54162','Environmental Consulting Services'); -INSERT INTO sic (code,description) VALUES ('541620','Environmental Consulting Services'); -INSERT INTO sic (code,description) VALUES ('54169','Other Scientific and Technical Consulting Services'); -INSERT INTO sic (code,description) VALUES ('541690','Other Scientific and Technical Consulting Services'); -INSERT INTO sic (code,description) VALUES ('5417','Scientific Research and Development Services'); -INSERT INTO sic (code,description) VALUES ('54171','Research and Development in the Physical, Engineering, and Life Sciences'); -INSERT INTO sic (code,description) VALUES ('541710','Research and Development in the Physical, Engineering, and Life Sciences'); -INSERT INTO sic (code,description) VALUES ('54172','Research and Development in the Social Sciences and Humanities'); -INSERT INTO sic (code,description) VALUES ('541720','Research and Development in the Social Sciences and Humanities'); -INSERT INTO sic (code,description) VALUES ('5418','Advertising and Related Services'); -INSERT INTO sic (code,description) VALUES ('54181','Advertising Agencies'); -INSERT INTO sic (code,description) VALUES ('541810','Advertising Agencies'); -INSERT INTO sic (code,description) VALUES ('54182','Public Relations Agencies'); -INSERT INTO sic (code,description) VALUES ('541820','Public Relations Agencies'); -INSERT INTO sic (code,description) VALUES ('54183','Media Buying Agencies'); -INSERT INTO sic (code,description) VALUES ('541830','Media Buying Agencies'); -INSERT INTO sic (code,description) VALUES ('54184','Media Representatives'); -INSERT INTO sic (code,description) VALUES ('541840','Media Representatives'); -INSERT INTO sic (code,description) VALUES ('54185','Display Advertising'); -INSERT INTO sic (code,description) VALUES ('541850','Display Advertising'); -INSERT INTO sic (code,description) VALUES ('54186','Direct Mail Advertising'); -INSERT INTO sic (code,description) VALUES ('541860','Direct Mail Advertising'); -INSERT INTO sic (code,description) VALUES ('54187','Advertising Material Distribution Services'); -INSERT INTO sic (code,description) VALUES ('541870','Advertising Material Distribution Services'); -INSERT INTO sic (code,description) VALUES ('54189','Other Services Related to Advertising'); -INSERT INTO sic (code,description) VALUES ('541890','Other Services Related to Advertising'); -INSERT INTO sic (code,description) VALUES ('5419','Other Professional, Scientific, and Technical Services'); -INSERT INTO sic (code,description) VALUES ('54191','Marketing Research and Public Opinion Polling'); -INSERT INTO sic (code,description) VALUES ('541910','Marketing Research and Public Opinion Polling'); -INSERT INTO sic (code,description) VALUES ('54192','Photographic Services'); -INSERT INTO sic (code,description) VALUES ('541921','Photography Studios, Portrait'); -INSERT INTO sic (code,description) VALUES ('541922','Commercial Photography'); -INSERT INTO sic (code,description) VALUES ('54193','Translation and Interpretation Services'); -INSERT INTO sic (code,description) VALUES ('541930','Translation and Interpretation Services'); -INSERT INTO sic (code,description) VALUES ('54194','Veterinary Services'); -INSERT INTO sic (code,description) VALUES ('541940','Veterinary Services'); -INSERT INTO sic (code,description) VALUES ('54199','All Other Professional, Scientific, and Technical Services'); -INSERT INTO sic (code,description) VALUES ('541990','All Other Professional, Scientific, and Technical Services'); -INSERT INTO sic (code,description) VALUES ('55','Management of Companies and Enterprises'); -INSERT INTO sic (code,description) VALUES ('551','Management of Companies and Enterprises'); -INSERT INTO sic (code,description) VALUES ('5511','Management of Companies and Enterprises'); -INSERT INTO sic (code,description) VALUES ('55111','Management of Companies and Enterprises'); -INSERT INTO sic (code,description) VALUES ('551111','Offices of Bank Holding Companies'); -INSERT INTO sic (code,description) VALUES ('551112','Offices of Other Holding Companies'); -INSERT INTO sic (code,description) VALUES ('551114','Corporate, Subsidiary, and Regional Managing Offices'); -INSERT INTO sic (code,description) VALUES ('56','Administrative and Support and Waste Management and Remediation Services'); -INSERT INTO sic (code,description) VALUES ('561','Administrative and Support Services'); -INSERT INTO sic (code,description) VALUES ('5611','Office Administrative Services'); -INSERT INTO sic (code,description) VALUES ('56111','Office Administrative Services'); -INSERT INTO sic (code,description) VALUES ('561110','Office Administrative Services'); -INSERT INTO sic (code,description) VALUES ('5612','Facilities Support Services'); -INSERT INTO sic (code,description) VALUES ('56121','Facilities Support Services'); -INSERT INTO sic (code,description) VALUES ('561210','Facilities Support Services'); -INSERT INTO sic (code,description) VALUES ('5613','Employment Services'); -INSERT INTO sic (code,description) VALUES ('56131','Employment Placement Agencies'); -INSERT INTO sic (code,description) VALUES ('561310','Employment Placement Agencies'); -INSERT INTO sic (code,description) VALUES ('56132','Temporary Help Services'); -INSERT INTO sic (code,description) VALUES ('561320','Temporary Help Services'); -INSERT INTO sic (code,description) VALUES ('56133','Professional Employer Organizations'); -INSERT INTO sic (code,description) VALUES ('561330','Professional Employer Organizations'); -INSERT INTO sic (code,description) VALUES ('5614','Business Support Services'); -INSERT INTO sic (code,description) VALUES ('56141','Document Preparation Services'); -INSERT INTO sic (code,description) VALUES ('561410','Document Preparation Services'); -INSERT INTO sic (code,description) VALUES ('56142','Telephone Call Centers'); -INSERT INTO sic (code,description) VALUES ('561421','Telephone Answering Services'); -INSERT INTO sic (code,description) VALUES ('561422','Telemarketing Bureaus'); -INSERT INTO sic (code,description) VALUES ('56143','Business Service Centers'); -INSERT INTO sic (code,description) VALUES ('561431','Private Mail Centers'); -INSERT INTO sic (code,description) VALUES ('561439','Other Business Service Centers (including Copy Shops)'); -INSERT INTO sic (code,description) VALUES ('56144','Collection Agencies'); -INSERT INTO sic (code,description) VALUES ('561440','Collection Agencies'); -INSERT INTO sic (code,description) VALUES ('56145','Credit Bureaus'); -INSERT INTO sic (code,description) VALUES ('561450','Credit Bureaus'); -INSERT INTO sic (code,description) VALUES ('56149','Other Business Support Services'); -INSERT INTO sic (code,description) VALUES ('561491','Repossession Services'); -INSERT INTO sic (code,description) VALUES ('561492','Court Reporting and Stenotype Services'); -INSERT INTO sic (code,description) VALUES ('561499','All Other Business Support Services'); -INSERT INTO sic (code,description) VALUES ('5615','Travel Arrangement and Reservation Services'); -INSERT INTO sic (code,description) VALUES ('56151','Travel Agencies'); -INSERT INTO sic (code,description) VALUES ('561510','Travel Agencies'); -INSERT INTO sic (code,description) VALUES ('56152','Tour Operators'); -INSERT INTO sic (code,description) VALUES ('561520','Tour Operators'); -INSERT INTO sic (code,description) VALUES ('56159','Other Travel Arrangement and Reservation Services'); -INSERT INTO sic (code,description) VALUES ('561591','Convention and Visitors Bureaus'); -INSERT INTO sic (code,description) VALUES ('561599','All Other Travel Arrangement and Reservation Services'); -INSERT INTO sic (code,description) VALUES ('5616','Investigation and Security Services'); -INSERT INTO sic (code,description) VALUES ('56161','Investigation, Guard, and Armored Car Services'); -INSERT INTO sic (code,description) VALUES ('561611','Investigation Services'); -INSERT INTO sic (code,description) VALUES ('561612','Security Guards and Patrol Services'); -INSERT INTO sic (code,description) VALUES ('561613','Armored Car Services'); -INSERT INTO sic (code,description) VALUES ('56162','Security Systems Services'); -INSERT INTO sic (code,description) VALUES ('561621','Security Systems Services (except Locksmiths)'); -INSERT INTO sic (code,description) VALUES ('561622','Locksmiths'); -INSERT INTO sic (code,description) VALUES ('5617','Services to Buildings and Dwellings'); -INSERT INTO sic (code,description) VALUES ('56171','Exterminating and Pest Control Services'); -INSERT INTO sic (code,description) VALUES ('561710','Exterminating and Pest Control Services'); -INSERT INTO sic (code,description) VALUES ('56172','Janitorial Services'); -INSERT INTO sic (code,description) VALUES ('561720','Janitorial Services'); -INSERT INTO sic (code,description) VALUES ('56173','Landscaping Services'); -INSERT INTO sic (code,description) VALUES ('561730','Landscaping Services'); -INSERT INTO sic (code,description) VALUES ('56174','Carpet and Upholstery Cleaning Services'); -INSERT INTO sic (code,description) VALUES ('561740','Carpet and Upholstery Cleaning Services'); -INSERT INTO sic (code,description) VALUES ('56179','Other Services to Buildings and Dwellings'); -INSERT INTO sic (code,description) VALUES ('561790','Other Services to Buildings and Dwellings'); -INSERT INTO sic (code,description) VALUES ('5619','Other Support Services'); -INSERT INTO sic (code,description) VALUES ('56191','Packaging and Labeling Services'); -INSERT INTO sic (code,description) VALUES ('561910','Packaging and Labeling Services'); -INSERT INTO sic (code,description) VALUES ('56192','Convention and Trade Show Organizers'); -INSERT INTO sic (code,description) VALUES ('561920','Convention and Trade Show Organizers'); -INSERT INTO sic (code,description) VALUES ('56199','All Other Support Services'); -INSERT INTO sic (code,description) VALUES ('561990','All Other Support Services'); -INSERT INTO sic (code,description) VALUES ('562','Waste Management and Remediation Services'); -INSERT INTO sic (code,description) VALUES ('5621','Waste Collection'); -INSERT INTO sic (code,description) VALUES ('56211','Waste Collection'); -INSERT INTO sic (code,description) VALUES ('562111','Solid Waste Collection'); -INSERT INTO sic (code,description) VALUES ('562112','Hazardous Waste Collection'); -INSERT INTO sic (code,description) VALUES ('562119','Other Waste Collection'); -INSERT INTO sic (code,description) VALUES ('5622','Waste Treatment and Disposal'); -INSERT INTO sic (code,description) VALUES ('56221','Waste Treatment and Disposal'); -INSERT INTO sic (code,description) VALUES ('562211','Hazardous Waste Treatment and Disposal'); -INSERT INTO sic (code,description) VALUES ('562212','Solid Waste Landfill'); -INSERT INTO sic (code,description) VALUES ('562213','Solid Waste Combustors and Incinerators'); -INSERT INTO sic (code,description) VALUES ('562219','Other Nonhazardous Waste Treatment and Disposal'); -INSERT INTO sic (code,description) VALUES ('5629','Remediation and Other Waste Management Services'); -INSERT INTO sic (code,description) VALUES ('56291','Remediation Services'); -INSERT INTO sic (code,description) VALUES ('562910','Remediation Services'); -INSERT INTO sic (code,description) VALUES ('56292','Materials Recovery Facilities'); -INSERT INTO sic (code,description) VALUES ('562920','Materials Recovery Facilities'); -INSERT INTO sic (code,description) VALUES ('56299','All Other Waste Management Services'); -INSERT INTO sic (code,description) VALUES ('562991','Septic Tank and Related Services'); -INSERT INTO sic (code,description) VALUES ('562998','All Other Miscellaneous Waste Management Services'); -INSERT INTO sic (code,description) VALUES ('61','Educational Services'); -INSERT INTO sic (code,description) VALUES ('611','Educational Services'); -INSERT INTO sic (code,description) VALUES ('6111','Elementary and Secondary Schools'); -INSERT INTO sic (code,description) VALUES ('61111','Elementary and Secondary Schools'); -INSERT INTO sic (code,description) VALUES ('611110','Elementary and Secondary Schools'); -INSERT INTO sic (code,description) VALUES ('6112','Junior Colleges'); -INSERT INTO sic (code,description) VALUES ('61121','Junior Colleges'); -INSERT INTO sic (code,description) VALUES ('611210','Junior Colleges'); -INSERT INTO sic (code,description) VALUES ('6113','Colleges, Universities, and Professional Schools'); -INSERT INTO sic (code,description) VALUES ('61131','Colleges, Universities, and Professional Schools'); -INSERT INTO sic (code,description) VALUES ('611310','Colleges, Universities, and Professional Schools'); -INSERT INTO sic (code,description) VALUES ('6114','Business Schools and Computer and Management Training'); -INSERT INTO sic (code,description) VALUES ('61141','Business and Secretarial Schools'); -INSERT INTO sic (code,description) VALUES ('611410','Business and Secretarial Schools'); -INSERT INTO sic (code,description) VALUES ('61142','Computer Training'); -INSERT INTO sic (code,description) VALUES ('611420','Computer Training'); -INSERT INTO sic (code,description) VALUES ('61143','Professional and Management Development Training'); -INSERT INTO sic (code,description) VALUES ('611430','Professional and Management Development Training'); -INSERT INTO sic (code,description) VALUES ('6115','Technical and Trade Schools'); -INSERT INTO sic (code,description) VALUES ('61151','Technical and Trade Schools'); -INSERT INTO sic (code,description) VALUES ('611511','Cosmetology and Barber Schools'); -INSERT INTO sic (code,description) VALUES ('611512','Flight Training'); -INSERT INTO sic (code,description) VALUES ('611513','Apprenticeship Training'); -INSERT INTO sic (code,description) VALUES ('611519','Other Technical and Trade Schools'); -INSERT INTO sic (code,description) VALUES ('6116','Other Schools and Instruction'); -INSERT INTO sic (code,description) VALUES ('61161','Fine Arts Schools'); -INSERT INTO sic (code,description) VALUES ('611610','Fine Arts Schools'); -INSERT INTO sic (code,description) VALUES ('61162','Sports and Recreation Instruction'); -INSERT INTO sic (code,description) VALUES ('611620','Sports and Recreation Instruction'); -INSERT INTO sic (code,description) VALUES ('61163','Language Schools'); -INSERT INTO sic (code,description) VALUES ('611630','Language Schools'); -INSERT INTO sic (code,description) VALUES ('61169','All Other Schools and Instruction'); -INSERT INTO sic (code,description) VALUES ('611691','Exam Preparation and Tutoring'); -INSERT INTO sic (code,description) VALUES ('611692','Automobile Driving Schools'); -INSERT INTO sic (code,description) VALUES ('611699','All Other Miscellaneous Schools and Instruction'); -INSERT INTO sic (code,description) VALUES ('6117','Educational Support Services'); -INSERT INTO sic (code,description) VALUES ('61171','Educational Support Services'); -INSERT INTO sic (code,description) VALUES ('611710','Educational Support Services'); -INSERT INTO sic (code,description) VALUES ('62','Health Care and Social Assistance'); -INSERT INTO sic (code,description) VALUES ('621','Ambulatory Health Care Services'); -INSERT INTO sic (code,description) VALUES ('6211','Offices of Physicians'); -INSERT INTO sic (code,description) VALUES ('62111','Offices of Physicians'); -INSERT INTO sic (code,description) VALUES ('621111','Offices of Physicians (except Mental Health Specialists)'); -INSERT INTO sic (code,description) VALUES ('621112','Offices of Physicians, Mental Health Specialists'); -INSERT INTO sic (code,description) VALUES ('6212','Offices of Dentists'); -INSERT INTO sic (code,description) VALUES ('62121','Offices of Dentists'); -INSERT INTO sic (code,description) VALUES ('621210','Offices of Dentists'); -INSERT INTO sic (code,description) VALUES ('6213','Offices of Other Health Practitioners'); -INSERT INTO sic (code,description) VALUES ('62131','Offices of Chiropractors'); -INSERT INTO sic (code,description) VALUES ('621310','Offices of Chiropractors'); -INSERT INTO sic (code,description) VALUES ('62132','Offices of Optometrists'); -INSERT INTO sic (code,description) VALUES ('621320','Offices of Optometrists'); -INSERT INTO sic (code,description) VALUES ('62133','Offices of Mental Health Practitioners (except Physicians)'); -INSERT INTO sic (code,description) VALUES ('621330','Offices of Mental Health Practitioners (except Physicians)'); -INSERT INTO sic (code,description) VALUES ('62134','Offices of Physical, Occupational and Speech Therapists, and Audiologists'); -INSERT INTO sic (code,description) VALUES ('621340','Offices of Physical, Occupational and Speech Therapists, and Audiologists'); -INSERT INTO sic (code,description) VALUES ('62139','Offices of All Other Health Practitioners'); -INSERT INTO sic (code,description) VALUES ('621391','Offices of Podiatrists'); -INSERT INTO sic (code,description) VALUES ('621399','Offices of All Other Miscellaneous Health Practitioners'); -INSERT INTO sic (code,description) VALUES ('6214','Outpatient Care Centers'); -INSERT INTO sic (code,description) VALUES ('62141','Family Planning Centers'); -INSERT INTO sic (code,description) VALUES ('621410','Family Planning Centers'); -INSERT INTO sic (code,description) VALUES ('62142','Outpatient Mental Health and Substance Abuse Centers'); -INSERT INTO sic (code,description) VALUES ('621420','Outpatient Mental Health and Substance Abuse Centers'); -INSERT INTO sic (code,description) VALUES ('62149','Other Outpatient Care Centers'); -INSERT INTO sic (code,description) VALUES ('621491','HMO Medical Centers'); -INSERT INTO sic (code,description) VALUES ('621492','Kidney Dialysis Centers'); -INSERT INTO sic (code,description) VALUES ('621493','Freestanding Ambulatory Surgical and Emergency Centers'); -INSERT INTO sic (code,description) VALUES ('621498','All Other Outpatient Care Centers'); -INSERT INTO sic (code,description) VALUES ('6215','Medical and Diagnostic Laboratories'); -INSERT INTO sic (code,description) VALUES ('62151','Medical and Diagnostic Laboratories'); -INSERT INTO sic (code,description) VALUES ('621511','Medical Laboratories'); -INSERT INTO sic (code,description) VALUES ('621512','Diagnostic Imaging Centers'); -INSERT INTO sic (code,description) VALUES ('6216','Home Health Care Services'); -INSERT INTO sic (code,description) VALUES ('62161','Home Health Care Services'); -INSERT INTO sic (code,description) VALUES ('621610','Home Health Care Services'); -INSERT INTO sic (code,description) VALUES ('6219','Other Ambulatory Health Care Services'); -INSERT INTO sic (code,description) VALUES ('62191','Ambulance Services'); -INSERT INTO sic (code,description) VALUES ('621910','Ambulance Services'); -INSERT INTO sic (code,description) VALUES ('62199','All Other Ambulatory Health Care Services'); -INSERT INTO sic (code,description) VALUES ('621991','Blood and Organ Banks'); -INSERT INTO sic (code,description) VALUES ('621999','All Other Miscellaneous Ambulatory Health Care Services'); -INSERT INTO sic (code,description) VALUES ('622','Hospitals'); -INSERT INTO sic (code,description) VALUES ('6221','General Medical and Surgical Hospitals'); -INSERT INTO sic (code,description) VALUES ('62211','General Medical and Surgical Hospitals'); -INSERT INTO sic (code,description) VALUES ('622110','General Medical and Surgical Hospitals'); -INSERT INTO sic (code,description) VALUES ('6222','Psychiatric and Substance Abuse Hospitals'); -INSERT INTO sic (code,description) VALUES ('62221','Psychiatric and Substance Abuse Hospitals'); -INSERT INTO sic (code,description) VALUES ('622210','Psychiatric and Substance Abuse Hospitals'); -INSERT INTO sic (code,description) VALUES ('6223','Specialty (except Psychiatric and Substance Abuse) Hospitals'); -INSERT INTO sic (code,description) VALUES ('62231','Specialty (except Psychiatric and Substance Abuse) Hospitals'); -INSERT INTO sic (code,description) VALUES ('622310','Specialty (except Psychiatric and Substance Abuse) Hospitals'); -INSERT INTO sic (code,description) VALUES ('623','Nursing and Residential Care Facilities'); -INSERT INTO sic (code,description) VALUES ('6231','Nursing Care Facilities'); -INSERT INTO sic (code,description) VALUES ('62311','Nursing Care Facilities'); -INSERT INTO sic (code,description) VALUES ('623110','Nursing Care Facilities'); -INSERT INTO sic (code,description) VALUES ('6232','Residential Mental Retardation, Mental Health and Substance Abuse Facilities'); -INSERT INTO sic (code,description) VALUES ('62321','Residential Mental Retardation Facilities'); -INSERT INTO sic (code,description) VALUES ('623210','Residential Mental Retardation Facilities'); -INSERT INTO sic (code,description) VALUES ('62322','Residential Mental Health and Substance Abuse Facilities'); -INSERT INTO sic (code,description) VALUES ('623220','Residential Mental Health and Substance Abuse Facilities'); -INSERT INTO sic (code,description) VALUES ('6233','Community Care Facilities for the Elderly'); -INSERT INTO sic (code,description) VALUES ('62331','Community Care Facilities for the Elderly'); -INSERT INTO sic (code,description) VALUES ('623311','Continuing Care Retirement Communities'); -INSERT INTO sic (code,description) VALUES ('623312','Homes for the Elderly'); -INSERT INTO sic (code,description) VALUES ('6239','Other Residential Care Facilities'); -INSERT INTO sic (code,description) VALUES ('62399','Other Residential Care Facilities'); -INSERT INTO sic (code,description) VALUES ('623990','Other Residential Care Facilities'); -INSERT INTO sic (code,description) VALUES ('624','Social Assistance'); -INSERT INTO sic (code,description) VALUES ('6241','Individual and Family Services'); -INSERT INTO sic (code,description) VALUES ('62411','Child and Youth Services'); -INSERT INTO sic (code,description) VALUES ('624110','Child and Youth Services'); -INSERT INTO sic (code,description) VALUES ('62412','Services for the Elderly and Persons with Disabilities'); -INSERT INTO sic (code,description) VALUES ('624120','Services for the Elderly and Persons with Disabilities'); -INSERT INTO sic (code,description) VALUES ('62419','Other Individual and Family Services'); -INSERT INTO sic (code,description) VALUES ('624190','Other Individual and Family Services'); -INSERT INTO sic (code,description) VALUES ('6242','Community Food and Housing, and Emergency and Other Relief Services'); -INSERT INTO sic (code,description) VALUES ('62421','Community Food Services'); -INSERT INTO sic (code,description) VALUES ('624210','Community Food Services'); -INSERT INTO sic (code,description) VALUES ('62422','Community Housing Services'); -INSERT INTO sic (code,description) VALUES ('624221','Temporary Shelters'); -INSERT INTO sic (code,description) VALUES ('624229','Other Community Housing Services'); -INSERT INTO sic (code,description) VALUES ('62423','Emergency and Other Relief Services'); -INSERT INTO sic (code,description) VALUES ('624230','Emergency and Other Relief Services'); -INSERT INTO sic (code,description) VALUES ('6243','Vocational Rehabilitation Services'); -INSERT INTO sic (code,description) VALUES ('62431','Vocational Rehabilitation Services'); -INSERT INTO sic (code,description) VALUES ('624310','Vocational Rehabilitation Services'); -INSERT INTO sic (code,description) VALUES ('6244','Child Day Care Services'); -INSERT INTO sic (code,description) VALUES ('62441','Child Day Care Services'); -INSERT INTO sic (code,description) VALUES ('624410','Child Day Care Services'); -INSERT INTO sic (code,description) VALUES ('71','Arts, Entertainment, and Recreation'); -INSERT INTO sic (code,description) VALUES ('711','Performing Arts, Spectator Sports, and Related Industries'); -INSERT INTO sic (code,description) VALUES ('7111','Performing Arts Companies'); -INSERT INTO sic (code,description) VALUES ('71111','Theater Companies and Dinner Theaters'); -INSERT INTO sic (code,description) VALUES ('711110','Theater Companies and Dinner Theaters'); -INSERT INTO sic (code,description) VALUES ('71112','Dance Companies'); -INSERT INTO sic (code,description) VALUES ('711120','Dance Companies'); -INSERT INTO sic (code,description) VALUES ('71113','Musical Groups and Artists'); -INSERT INTO sic (code,description) VALUES ('711130','Musical Groups and Artists'); -INSERT INTO sic (code,description) VALUES ('71119','Other Performing Arts Companies'); -INSERT INTO sic (code,description) VALUES ('711190','Other Performing Arts Companies'); -INSERT INTO sic (code,description) VALUES ('7112','Spectator Sports'); -INSERT INTO sic (code,description) VALUES ('71121','Spectator Sports'); -INSERT INTO sic (code,description) VALUES ('711211','Sports Teams and Clubs'); -INSERT INTO sic (code,description) VALUES ('711212','Racetracks'); -INSERT INTO sic (code,description) VALUES ('711219','Other Spectator Sports'); -INSERT INTO sic (code,description) VALUES ('7113','Promoters of Performing Arts, Sports, and Similar Events'); -INSERT INTO sic (code,description) VALUES ('71131','Promoters of Performing Arts, Sports, and Similar Events with Facilities'); -INSERT INTO sic (code,description) VALUES ('711310','Promoters of Performing Arts, Sports, and Similar Events with Facilities'); -INSERT INTO sic (code,description) VALUES ('71132','Promoters of Performing Arts, Sports, and Similar Events without Facilities'); -INSERT INTO sic (code,description) VALUES ('711320','Promoters of Performing Arts, Sports, and Similar Events without Facilities'); -INSERT INTO sic (code,description) VALUES ('7114','Agents and Managers for Artists, Athletes, Entertainers, and Other Public Figures'); -INSERT INTO sic (code,description) VALUES ('71141','Agents and Managers for Artists, Athletes, Entertainers, and Other Public Figures'); -INSERT INTO sic (code,description) VALUES ('711410','Agents and Managers for Artists, Athletes, Entertainers, and Other Public Figures'); -INSERT INTO sic (code,description) VALUES ('7115','Independent Artists, Writers, and Performers'); -INSERT INTO sic (code,description) VALUES ('71151','Independent Artists, Writers, and Performers'); -INSERT INTO sic (code,description) VALUES ('711510','Independent Artists, Writers, and Performers'); -INSERT INTO sic (code,description) VALUES ('712','Museums, Historical Sites, and Similar Institutions'); -INSERT INTO sic (code,description) VALUES ('7121','Museums, Historical Sites, and Similar Institutions'); -INSERT INTO sic (code,description) VALUES ('71211','Museums'); -INSERT INTO sic (code,description) VALUES ('712110','Museums'); -INSERT INTO sic (code,description) VALUES ('71212','Historical Sites'); -INSERT INTO sic (code,description) VALUES ('712120','Historical Sites'); -INSERT INTO sic (code,description) VALUES ('71213','Zoos and Botanical Gardens'); -INSERT INTO sic (code,description) VALUES ('712130','Zoos and Botanical Gardens'); -INSERT INTO sic (code,description) VALUES ('71219','Nature Parks and Other Similar Institutions'); -INSERT INTO sic (code,description) VALUES ('712190','Nature Parks and Other Similar Institutions'); -INSERT INTO sic (code,description) VALUES ('713','Amusement, Gambling, and Recreation Industries'); -INSERT INTO sic (code,description) VALUES ('7131','Amusement Parks and Arcades'); -INSERT INTO sic (code,description) VALUES ('71311','Amusement and Theme Parks'); -INSERT INTO sic (code,description) VALUES ('713110','Amusement and Theme Parks'); -INSERT INTO sic (code,description) VALUES ('71312','Amusement Arcades'); -INSERT INTO sic (code,description) VALUES ('713120','Amusement Arcades'); -INSERT INTO sic (code,description) VALUES ('7132','Gambling Industries'); -INSERT INTO sic (code,description) VALUES ('71321','Casinos (except Casino Hotels)'); -INSERT INTO sic (code,description) VALUES ('713210','Casinos (except Casino Hotels)'); -INSERT INTO sic (code,description) VALUES ('71329','Other Gambling Industries'); -INSERT INTO sic (code,description) VALUES ('713290','Other Gambling Industries'); -INSERT INTO sic (code,description) VALUES ('7139','Other Amusement and Recreation Industries'); -INSERT INTO sic (code,description) VALUES ('71391','Golf Courses and Country Clubs'); -INSERT INTO sic (code,description) VALUES ('713910','Golf Courses and Country Clubs'); -INSERT INTO sic (code,description) VALUES ('71392','Skiing Facilities'); -INSERT INTO sic (code,description) VALUES ('713920','Skiing Facilities'); -INSERT INTO sic (code,description) VALUES ('71393','Marinas'); -INSERT INTO sic (code,description) VALUES ('713930','Marinas'); -INSERT INTO sic (code,description) VALUES ('71394','Fitness and Recreational Sports Centers'); -INSERT INTO sic (code,description) VALUES ('713940','Fitness and Recreational Sports Centers'); -INSERT INTO sic (code,description) VALUES ('71395','Bowling Centers'); -INSERT INTO sic (code,description) VALUES ('713950','Bowling Centers'); -INSERT INTO sic (code,description) VALUES ('71399','All Other Amusement and Recreation Industries'); -INSERT INTO sic (code,description) VALUES ('713990','All Other Amusement and Recreation Industries'); -INSERT INTO sic (code,description) VALUES ('72','Accommodation and Food Services'); -INSERT INTO sic (code,description) VALUES ('721','Accommodation'); -INSERT INTO sic (code,description) VALUES ('7211','Traveler Accommodation'); -INSERT INTO sic (code,description) VALUES ('72111','Hotels (except Casino Hotels) and Motels'); -INSERT INTO sic (code,description) VALUES ('721110','Hotels (except Casino Hotels) and Motels'); -INSERT INTO sic (code,description) VALUES ('72112','Casino Hotels'); -INSERT INTO sic (code,description) VALUES ('721120','Casino Hotels'); -INSERT INTO sic (code,description) VALUES ('72119','Other Traveler Accommodation'); -INSERT INTO sic (code,description) VALUES ('721191','Bed-and-Breakfast Inns'); -INSERT INTO sic (code,description) VALUES ('721199','All Other Traveler Accommodation'); -INSERT INTO sic (code,description) VALUES ('7212','RV (Recreational Vehicle) Parks and Recreational Camps'); -INSERT INTO sic (code,description) VALUES ('72121','RV (Recreational Vehicle) Parks and Recreational Camps'); -INSERT INTO sic (code,description) VALUES ('721211','RV (Recreational Vehicle) Parks and Campgrounds'); -INSERT INTO sic (code,description) VALUES ('721214','Recreational and Vacation Camps (except Campgrounds)'); -INSERT INTO sic (code,description) VALUES ('7213','Rooming and Boarding Houses'); -INSERT INTO sic (code,description) VALUES ('72131','Rooming and Boarding Houses'); -INSERT INTO sic (code,description) VALUES ('721310','Rooming and Boarding Houses'); -INSERT INTO sic (code,description) VALUES ('722','Food Services and Drinking Places'); -INSERT INTO sic (code,description) VALUES ('7221','Full-Service Restaurants'); -INSERT INTO sic (code,description) VALUES ('72211','Full-Service Restaurants'); -INSERT INTO sic (code,description) VALUES ('722110','Full-Service Restaurants'); -INSERT INTO sic (code,description) VALUES ('7222','Limited-Service Eating Places'); -INSERT INTO sic (code,description) VALUES ('72221','Limited-Service Eating Places'); -INSERT INTO sic (code,description) VALUES ('722211','Limited-Service Restaurants'); -INSERT INTO sic (code,description) VALUES ('722212','Cafeterias'); -INSERT INTO sic (code,description) VALUES ('722213','Snack and Nonalcoholic Beverage Bars'); -INSERT INTO sic (code,description) VALUES ('7223','Special Food Services'); -INSERT INTO sic (code,description) VALUES ('72231','Food Service Contractors'); -INSERT INTO sic (code,description) VALUES ('722310','Food Service Contractors'); -INSERT INTO sic (code,description) VALUES ('72232','Caterers'); -INSERT INTO sic (code,description) VALUES ('722320','Caterers'); -INSERT INTO sic (code,description) VALUES ('72233','Mobile Food Services'); -INSERT INTO sic (code,description) VALUES ('722330','Mobile Food Services'); -INSERT INTO sic (code,description) VALUES ('7224','Drinking Places (Alcoholic Beverages)'); -INSERT INTO sic (code,description) VALUES ('72241','Drinking Places (Alcoholic Beverages)'); -INSERT INTO sic (code,description) VALUES ('722410','Drinking Places (Alcoholic Beverages)'); -INSERT INTO sic (code,description) VALUES ('81','Other Services (except Public Administration)'); -INSERT INTO sic (code,description) VALUES ('811','Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('8111','Automotive Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('81111','Automotive Mechanical and Electrical Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811111','General Automotive Repair'); -INSERT INTO sic (code,description) VALUES ('811112','Automotive Exhaust System Repair'); -INSERT INTO sic (code,description) VALUES ('811113','Automotive Transmission Repair'); -INSERT INTO sic (code,description) VALUES ('811118','Other Automotive Mechanical and Electrical Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('81112','Automotive Body, Paint, Interior, and Glass Repair'); -INSERT INTO sic (code,description) VALUES ('811121','Automotive Body, Paint, and Interior Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811122','Automotive Glass Replacement Shops'); -INSERT INTO sic (code,description) VALUES ('81119','Other Automotive Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811191','Automotive Oil Change and Lubrication Shops'); -INSERT INTO sic (code,description) VALUES ('811192','Car Washes'); -INSERT INTO sic (code,description) VALUES ('811198','All Other Automotive Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('8112','Electronic and Precision Equipment Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('81121','Electronic and Precision Equipment Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811211','Consumer Electronics Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811212','Computer and Office Machine Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811213','Communication Equipment Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811219','Other Electronic and Precision Equipment Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('8113','Commercial and Industrial Machinery and Equipment (except Automotive and Electronic) Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('81131','Commercial and Industrial Machinery and Equipment (except Automotive and Electronic) Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811310','Commercial and Industrial Machinery and Equipment (except Automotive and Electronic) Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('8114','Personal and Household Goods Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('81141','Home and Garden Equipment and Appliance Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811411','Home and Garden Equipment Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811412','Appliance Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('81142','Reupholstery and Furniture Repair'); -INSERT INTO sic (code,description) VALUES ('811420','Reupholstery and Furniture Repair'); -INSERT INTO sic (code,description) VALUES ('81143','Footwear and Leather Goods Repair'); -INSERT INTO sic (code,description) VALUES ('811430','Footwear and Leather Goods Repair'); -INSERT INTO sic (code,description) VALUES ('81149','Other Personal and Household Goods Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('811490','Other Personal and Household Goods Repair and Maintenance'); -INSERT INTO sic (code,description) VALUES ('812','Personal and Laundry Services'); -INSERT INTO sic (code,description) VALUES ('8121','Personal Care Services'); -INSERT INTO sic (code,description) VALUES ('81211','Hair, Nail, and Skin Care Services'); -INSERT INTO sic (code,description) VALUES ('812111','Barber Shops'); -INSERT INTO sic (code,description) VALUES ('812112','Beauty Salons'); -INSERT INTO sic (code,description) VALUES ('812113','Nail Salons'); -INSERT INTO sic (code,description) VALUES ('81219','Other Personal Care Services'); -INSERT INTO sic (code,description) VALUES ('812191','Diet and Weight Reducing Centers'); -INSERT INTO sic (code,description) VALUES ('812199','Other Personal Care Services'); -INSERT INTO sic (code,description) VALUES ('8122','Death Care Services'); -INSERT INTO sic (code,description) VALUES ('81221','Funeral Homes and Funeral Services'); -INSERT INTO sic (code,description) VALUES ('812210','Funeral Homes and Funeral Services'); -INSERT INTO sic (code,description) VALUES ('81222','Cemeteries and Crematories'); -INSERT INTO sic (code,description) VALUES ('812220','Cemeteries and Crematories'); -INSERT INTO sic (code,description) VALUES ('8123','Drycleaning and Laundry Services'); -INSERT INTO sic (code,description) VALUES ('81231','Coin-Operated Laundries and Drycleaners'); -INSERT INTO sic (code,description) VALUES ('812310','Coin-Operated Laundries and Drycleaners'); -INSERT INTO sic (code,description) VALUES ('81232','Drycleaning and Laundry Services (except Coin-Operated)'); -INSERT INTO sic (code,description) VALUES ('812320','Drycleaning and Laundry Services (except Coin-Operated)'); -INSERT INTO sic (code,description) VALUES ('81233','Linen and Uniform Supply'); -INSERT INTO sic (code,description) VALUES ('812331','Linen Supply'); -INSERT INTO sic (code,description) VALUES ('812332','Industrial Launderers'); -INSERT INTO sic (code,description) VALUES ('8129','Other Personal Services'); -INSERT INTO sic (code,description) VALUES ('81291','Pet Care (except Veterinary) Services'); -INSERT INTO sic (code,description) VALUES ('812910','Pet Care (except Veterinary) Services'); -INSERT INTO sic (code,description) VALUES ('81292','Photofinishing'); -INSERT INTO sic (code,description) VALUES ('812921','Photofinishing Laboratories (except One-Hour)'); -INSERT INTO sic (code,description) VALUES ('812922','One-Hour Photofinishing'); -INSERT INTO sic (code,description) VALUES ('81293','Parking Lots and Garages'); -INSERT INTO sic (code,description) VALUES ('812930','Parking Lots and Garages'); -INSERT INTO sic (code,description) VALUES ('81299','All Other Personal Services'); -INSERT INTO sic (code,description) VALUES ('812990','All Other Personal Services'); -INSERT INTO sic (code,description) VALUES ('813','Religious, Grantmaking, Civic, Professional, and Similar Organizations'); -INSERT INTO sic (code,description) VALUES ('8131','Religious Organizations'); -INSERT INTO sic (code,description) VALUES ('81311','Religious Organizations'); -INSERT INTO sic (code,description) VALUES ('813110','Religious Organizations'); -INSERT INTO sic (code,description) VALUES ('8132','Grantmaking and Giving Services'); -INSERT INTO sic (code,description) VALUES ('81321','Grantmaking and Giving Services'); -INSERT INTO sic (code,description) VALUES ('813211','Grantmaking Foundations'); -INSERT INTO sic (code,description) VALUES ('813212','Voluntary Health Organizations'); -INSERT INTO sic (code,description) VALUES ('813219','Other Grantmaking and Giving Services'); -INSERT INTO sic (code,description) VALUES ('8133','Social Advocacy Organizations'); -INSERT INTO sic (code,description) VALUES ('81331','Social Advocacy Organizations'); -INSERT INTO sic (code,description) VALUES ('813311','Human Rights Organizations'); -INSERT INTO sic (code,description) VALUES ('813312','Environment, Conservation and Wildlife Organizations'); -INSERT INTO sic (code,description) VALUES ('813319','Other Social Advocacy Organizations'); -INSERT INTO sic (code,description) VALUES ('8134','Civic and Social Organizations'); -INSERT INTO sic (code,description) VALUES ('81341','Civic and Social Organizations'); -INSERT INTO sic (code,description) VALUES ('813410','Civic and Social Organizations'); -INSERT INTO sic (code,description) VALUES ('8139','Business, Professional, Labor, Political, and Similar Organizations'); -INSERT INTO sic (code,description) VALUES ('81391','Business Associations'); -INSERT INTO sic (code,description) VALUES ('813910','Business Associations'); -INSERT INTO sic (code,description) VALUES ('81392','Professional Organizations'); -INSERT INTO sic (code,description) VALUES ('813920','Professional Organizations'); -INSERT INTO sic (code,description) VALUES ('81393','Labor Unions and Similar Labor Organizations'); -INSERT INTO sic (code,description) VALUES ('813930','Labor Unions and Similar Labor Organizations'); -INSERT INTO sic (code,description) VALUES ('81394','Political Organizations'); -INSERT INTO sic (code,description) VALUES ('813940','Political Organizations'); -INSERT INTO sic (code,description) VALUES ('81399','Other Similar Organizations (except Business, Professional, Labor, and Political Organizations)'); -INSERT INTO sic (code,description) VALUES ('813990','Other Similar Organizations (except Business, Professional, Labor, and Political Organizations)'); -INSERT INTO sic (code,description) VALUES ('814','Private Households'); -INSERT INTO sic (code,description) VALUES ('8141','Private Households'); -INSERT INTO sic (code,description) VALUES ('81411','Private Households'); -INSERT INTO sic (code,description) VALUES ('814110','Private Households'); -INSERT INTO sic (code,description) VALUES ('92','Public Administration'); -INSERT INTO sic (code,description) VALUES ('921','Executive, Legislative, and Other General Government Support'); -INSERT INTO sic (code,description) VALUES ('9211','Executive, Legislative, and Other General Government Support'); -INSERT INTO sic (code,description) VALUES ('92111','Executive Offices'); -INSERT INTO sic (code,description) VALUES ('921110','Executive Offices'); -INSERT INTO sic (code,description) VALUES ('92112','Legislative Bodies'); -INSERT INTO sic (code,description) VALUES ('921120','Legislative Bodies'); -INSERT INTO sic (code,description) VALUES ('92113','Public Finance Activities'); -INSERT INTO sic (code,description) VALUES ('921130','Public Finance Activities'); -INSERT INTO sic (code,description) VALUES ('92114','Executive and Legislative Offices, Combined'); -INSERT INTO sic (code,description) VALUES ('921140','Executive and Legislative Offices, Combined'); -INSERT INTO sic (code,description) VALUES ('92115','American Indian and Alaska Native Tribal Governments'); -INSERT INTO sic (code,description) VALUES ('921150','American Indian and Alaska Native Tribal Governments'); -INSERT INTO sic (code,description) VALUES ('92119','Other General Government Support'); -INSERT INTO sic (code,description) VALUES ('921190','Other General Government Support'); -INSERT INTO sic (code,description) VALUES ('922','Justice, Public Order, and Safety Activities'); -INSERT INTO sic (code,description) VALUES ('9221','Justice, Public Order, and Safety Activities'); -INSERT INTO sic (code,description) VALUES ('92211','Courts'); -INSERT INTO sic (code,description) VALUES ('922110','Courts'); -INSERT INTO sic (code,description) VALUES ('92212','Police Protection'); -INSERT INTO sic (code,description) VALUES ('922120','Police Protection'); -INSERT INTO sic (code,description) VALUES ('92213','Legal Counsel and Prosecution'); -INSERT INTO sic (code,description) VALUES ('922130','Legal Counsel and Prosecution'); -INSERT INTO sic (code,description) VALUES ('92214','Correctional Institutions'); -INSERT INTO sic (code,description) VALUES ('922140','Correctional Institutions'); -INSERT INTO sic (code,description) VALUES ('92215','Parole Offices and Probation Offices'); -INSERT INTO sic (code,description) VALUES ('922150','Parole Offices and Probation Offices'); -INSERT INTO sic (code,description) VALUES ('92216','Fire Protection'); -INSERT INTO sic (code,description) VALUES ('922160','Fire Protection'); -INSERT INTO sic (code,description) VALUES ('92219','Other Justice, Public Order, and Safety Activities'); -INSERT INTO sic (code,description) VALUES ('922190','Other Justice, Public Order, and Safety Activities'); -INSERT INTO sic (code,description) VALUES ('923','Administration of Human Resource Programs'); -INSERT INTO sic (code,description) VALUES ('9231','Administration of Human Resource Programs'); -INSERT INTO sic (code,description) VALUES ('92311','Administration of Education Programs'); -INSERT INTO sic (code,description) VALUES ('923110','Administration of Education Programs'); -INSERT INTO sic (code,description) VALUES ('92312','Administration of Public Health Programs'); -INSERT INTO sic (code,description) VALUES ('923120','Administration of Public Health Programs'); -INSERT INTO sic (code,description) VALUES ('92313','Administration of Human Resource Programs (except Education, Public Health, and Veterans\' Affairs Programs)'); -INSERT INTO sic (code,description) VALUES ('923130','Administration of Human Resource Programs (except Education, Public Health, and Veterans\' Affairs Programs)'); -INSERT INTO sic (code,description) VALUES ('92314','Administration of Veterans\' Affairs'); -INSERT INTO sic (code,description) VALUES ('923140','Administration of Veterans\' Affairs'); -INSERT INTO sic (code,description) VALUES ('924','Administration of Environmental Quality Programs'); -INSERT INTO sic (code,description) VALUES ('9241','Administration of Environmental Quality Programs'); -INSERT INTO sic (code,description) VALUES ('92411','Administration of Air and Water Resource and Solid Waste Management Programs'); -INSERT INTO sic (code,description) VALUES ('924110','Administration of Air and Water Resource and Solid Waste Management Programs'); -INSERT INTO sic (code,description) VALUES ('92412','Administration of Conservation Programs'); -INSERT INTO sic (code,description) VALUES ('924120','Administration of Conservation Programs'); -INSERT INTO sic (code,description) VALUES ('925','Administration of Housing Programs, Urban Planning, and Community Development'); -INSERT INTO sic (code,description) VALUES ('9251','Administration of Housing Programs, Urban Planning, and Community Development'); -INSERT INTO sic (code,description) VALUES ('92511','Administration of Housing Programs'); -INSERT INTO sic (code,description) VALUES ('925110','Administration of Housing Programs'); -INSERT INTO sic (code,description) VALUES ('92512','Administration of Urban Planning and Community and Rural Development'); -INSERT INTO sic (code,description) VALUES ('925120','Administration of Urban Planning and Community and Rural Development'); -INSERT INTO sic (code,description) VALUES ('926','Administration of Economic Programs'); -INSERT INTO sic (code,description) VALUES ('9261','Administration of Economic Programs'); -INSERT INTO sic (code,description) VALUES ('92611','Administration of General Economic Programs'); -INSERT INTO sic (code,description) VALUES ('926110','Administration of General Economic Programs'); -INSERT INTO sic (code,description) VALUES ('92612','Regulation and Administration of Transportation Programs'); -INSERT INTO sic (code,description) VALUES ('926120','Regulation and Administration of Transportation Programs'); -INSERT INTO sic (code,description) VALUES ('92613','Regulation and Administration of Communications, Electric, Gas, and Other Utilities'); -INSERT INTO sic (code,description) VALUES ('926130','Regulation and Administration of Communications, Electric, Gas, and Other Utilities'); -INSERT INTO sic (code,description) VALUES ('92614','Regulation of Agricultural Marketing and Commodities'); -INSERT INTO sic (code,description) VALUES ('926140','Regulation of Agricultural Marketing and Commodities'); -INSERT INTO sic (code,description) VALUES ('92615','Regulation, Licensing, and Inspection of Miscellaneous Commercial Sectors'); -INSERT INTO sic (code,description) VALUES ('926150','Regulation, Licensing, and Inspection of Miscellaneous Commercial Sectors'); -INSERT INTO sic (code,description) VALUES ('927','Space Research and Technology'); -INSERT INTO sic (code,description) VALUES ('9271','Space Research and Technology'); -INSERT INTO sic (code,description) VALUES ('92711','Space Research and Technology'); -INSERT INTO sic (code,description) VALUES ('927110','Space Research and Technology'); -INSERT INTO sic (code,description) VALUES ('928','National Security and International Affairs'); -INSERT INTO sic (code,description) VALUES ('9281','National Security and International Affairs'); -INSERT INTO sic (code,description) VALUES ('92811','National Security'); -INSERT INTO sic (code,description) VALUES ('928110','National Security'); -INSERT INTO sic (code,description) VALUES ('92812','International Affairs'); -INSERT INTO sic (code,description) VALUES ('928120','International Affairs'); -commit; diff --git a/sql/legacy/Pg-upgrade-1.2.6-1.2.7.sql b/sql/legacy/Pg-upgrade-1.2.6-1.2.7.sql deleted file mode 100755 index 159f31b3..00000000 --- a/sql/legacy/Pg-upgrade-1.2.6-1.2.7.sql +++ /dev/null @@ -1,4 +0,0 @@ --- --- add the field shiptoemail to the customer table --- -alter table customer add column shiptoemail text; diff --git a/sql/legacy/Pg-upgrade-1.2.7-1.4.0.sql b/sql/legacy/Pg-upgrade-1.2.7-1.4.0.sql deleted file mode 100755 index 04e1a794..00000000 --- a/sql/legacy/Pg-upgrade-1.2.7-1.4.0.sql +++ /dev/null @@ -1,173 +0,0 @@ --- -CREATE TABLE newap ( - id int DEFAULT nextval ( 'id' ), - invnumber text, - transdate date DEFAULT current_date, - vendor int, - taxincluded bool DEFAULT FALSE, - amount float, - netamount float, - paid float, - datepaid date, - duedate date, - invoice bool DEFAULT FALSE, - ordnumber text -); --- -INSERT INTO newap (id, invnumber, transdate, vendor, amount, netamount, paid, -datepaid, duedate, invoice, ordnumber) -SELECT id, invnumber, transdate, vendor, amount, netamount, paid, -datepaid, duedate, invoice, ordnumber -FROM ap; --- -DROP TABLE ap; -ALTER TABLE newap RENAME TO ap; --- -CREATE TABLE newar ( - id int DEFAULT nextval ( 'id' ), - invnumber text, - transdate date DEFAULT current_date, - customer int, - taxincluded bool DEFAULT FALSE, - amount float, - netamount float, - paid float, - datepaid date, - duedate date, - invoice bool DEFAULT FALSE, - shippingpoint text, - terms int2, - notes text -); --- -INSERT INTO newar (id, invnumber, transdate, customer, amount, netamount, paid, -datepaid, duedate, invoice, shippingpoint, terms, notes) -SELECT id, invnumber, transdate, customer, amount, netamount, paid, -datepaid, duedate, invoice, shippingpoint, terms, notes -FROM ar; --- -DROP TABLE ar; -ALTER TABLE newar RENAME TO ar; --- -CREATE TABLE newcustomer ( - id int DEFAULT nextval ( 'id' ), - name varchar(35), - addr1 varchar(35), - addr2 varchar(35), - addr3 varchar(35), - contact varchar(35), - phone varchar(20), - fax varchar(20), - email text, - notes text, - ytd float, - discount float4, - taxincluded bool, - creditlimit float, - terms int2, - shiptoname varchar(35), - shiptoaddr1 varchar(35), - shiptoaddr2 varchar(35), - shiptoaddr3 varchar(35), - shiptocontact varchar(20), - shiptophone varchar(20), - shiptofax varchar(20), - shiptoemail text -); -INSERT INTO newcustomer ( -id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, ytd, -discount, creditlimit, terms, shiptoname, shiptoaddr1, shiptoaddr2, -shiptoaddr3, shiptocontact, shiptophone, shiptofax, shiptoemail ) -SELECT id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, ytd, -discount, creditlimit, terms, shiptoname, shiptoaddr1, shiptoaddr2, -shiptoaddr3, shiptocontact, shiptophone, shiptofax, shiptoemail -FROM customer; --- -DROP TABLE customer; -ALTER TABLE newcustomer RENAME TO customer; --- -CREATE TABLE customertax ( - customer_id int, - chart_id int -); --- -CREATE TABLE newdefaults ( - inventory_accno int, - income_accno int, - expense_accno int, - invnumber text, - ponumber text, - yearend varchar(5), - nativecurr varchar(3), - weightunit varchar(5) -); --- -INSERT INTO newdefaults ( -inventory_accno, income_accno, expense_accno, invnumber, ponumber) -SELECT inventory_accno, income_accno, expense_accno, invnumber, ponumber -FROM defaults; --- -DROP TABLE defaults; -ALTER TABLE newdefaults RENAME TO defaults; -UPDATE defaults SET yearend = '1/31', nativecurr = 'CAD', weightunit = 'kg'; --- -CREATE TABLE partstax ( - parts_id int, - chart_id int -); --- -CREATE TABLE tax ( - chart_id int, - rate float, - number text -); --- -CREATE TABLE newvendor ( - id int DEFAULT nextval ( 'id' ), - name varchar(35), - addr1 varchar(35), - addr2 varchar(35), - addr3 varchar(35), - contact varchar(35), - phone varchar(20), - fax varchar(20), - email text, - notes text, - ytd float, - discount float4, - taxincluded bool, - creditlimit float, - terms int2 -); --- -INSERT INTO newvendor ( -id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, ytd ) -SELECT id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, ytd -FROM vendor; --- -DROP TABLE vendor; -ALTER TABLE newvendor RENAME TO vendor; --- -CREATE TABLE vendortax ( - vendor_id int, - chart_id int -); --- -ALTER TABLE chart RENAME TO oldchart; --- -CREATE TABLE chart ( - id int DEFAULT nextval( 'id' ), - accno int UNIQUE, - description text, - balance float, - type char(1), - gifi int, - category char(1), - link text -); --- -INSERT INTO chart SELECT * FROM oldchart; --- -DROP TABLE oldchart; --- - diff --git a/sql/legacy/Pg-upgrade-1.4.0-1.6.0.sql b/sql/legacy/Pg-upgrade-1.4.0-1.6.0.sql deleted file mode 100755 index e0a38924..00000000 --- a/sql/legacy/Pg-upgrade-1.4.0-1.6.0.sql +++ /dev/null @@ -1,126 +0,0 @@ -alter table acc_trans rename column accno to chart_id; -update acc_trans set chart_id = - (select id from chart where accno = acc_trans.chart_id); --- -alter table parts rename column inventory_accno to inventory_accno_id; -alter table parts rename column income_accno to income_accno_id; -alter table parts rename column expense_accno to expense_accno_id; -alter table parts rename column number to partnumber; -update parts set inventory_accno_id = - (select id from chart where chart.accno = parts.inventory_accno_id); -update parts set income_accno_id = - (select id from chart where chart.accno = parts.income_accno_id); -update parts set expense_accno_id = - (select id from chart where chart.accno = parts.expense_accno_id); --- -create table assembly (id int, parts_id int, qty float); --- -alter table defaults rename column inventory_accno to inventory_accno_id; -alter table defaults rename column income_accno to income_accno_id; -alter table defaults rename column expense_accno to expense_accno_id; -alter table defaults add column businessnumber text; -alter table defaults add column version varchar(8); -update defaults set inventory_accno_id = - (select id from chart where chart.accno = defaults.inventory_accno_id); -update defaults set income_accno_id = - (select id from chart where chart.accno = defaults.income_accno_id); -update defaults set expense_accno_id = - (select id from chart where chart.accno = defaults.expense_accno_id); -update defaults set version = '1.6.0'; --- -alter table invoice rename column inventory_accno to inventory_accno_id; -alter table invoice rename column income_accno to income_accno_id; -alter table invoice rename column expense_accno to expense_accno_id; -alter table invoice rename column number to partnumber; -alter table invoice add column assemblyitem bool; -update invoice set assemblyitem = 'f'; -update invoice set inventory_accno_id = - (select id from chart where invoice.inventory_accno_id = chart.accno); -update invoice set income_accno_id = - (select id from chart where invoice.income_accno_id = chart.accno); -update invoice set expense_accno_id = - (select id from chart where invoice.expense_accno_id = chart.accno); --- -alter table gl rename column comment to description; --- -create table newvendor ( - id int default nextval ( 'id' ), - name varchar(35), - addr1 varchar(35), - addr2 varchar(35), - addr3 varchar(35), - addr4 varchar(35), - contact varchar(35), - phone varchar(20), - fax varchar(20), - email text, - notes text, - terms int2, - taxincluded bool -); -insert into newvendor ( - id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, terms, - taxincluded) - select - id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, terms, - taxincluded from vendor; -drop table vendor; -alter table newvendor rename to vendor; --- -create table newcustomer ( - id int default nextval ( 'id' ), - name varchar(35), - addr1 varchar(35), - addr2 varchar(35), - addr3 varchar(35), - addr4 varchar(35), - contact varchar(35), - phone varchar(20), - fax varchar(20), - email text, - notes text, - discount float4, - taxincluded bool, - creditlimit float, - terms int2, - shiptoname varchar(35), - shiptoaddr1 varchar(35), - shiptoaddr2 varchar(35), - shiptoaddr3 varchar(35), - shiptoaddr4 varchar(35), - shiptocontact varchar(20), - shiptophone varchar(20), - shiptofax varchar(20), - shiptoemail text -); -insert into newcustomer ( - id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, discount, - taxincluded, creditlimit, terms, shiptoname, shiptoaddr1, shiptoaddr2, - shiptoaddr3, shiptocontact, shiptophone, shiptofax, shiptoemail - ) - select - id, name, addr1, addr2, addr3, contact, phone, fax, email, notes, discount, - taxincluded, creditlimit, terms, shiptoname, shiptoaddr1, shiptoaddr2, - shiptoaddr3, shiptocontact, shiptophone, shiptofax, shiptoemail - from customer; -drop table customer; -alter table newcustomer rename to customer; --- -drop index chart_accno_key; -alter table chart rename to oldchart; -create table chart ( - id int default nextval('id'), - accno int unique, - description text, - charttype char(1), - gifi int, - category char(1), - link text -); -insert into chart (id, accno, description, charttype, gifi, category, link) - select id, accno, description, type, gifi, category, link from oldchart; -drop table oldchart; --- -alter table tax rename column number to taxnumber; --- --- apply diff --git a/sql/legacy/Pg-upgrade-1.6.0-1.8.0.sql b/sql/legacy/Pg-upgrade-1.6.0-1.8.0.sql deleted file mode 100755 index 4e98e1fe..00000000 --- a/sql/legacy/Pg-upgrade-1.6.0-1.8.0.sql +++ /dev/null @@ -1,104 +0,0 @@ --- -create table def ( - inventory_accno_id int, - income_accno_id int, - expense_accno_id int, - fxgain_accno_id int, - fxloss_accno_id int, - invnumber text, - ordnumber text, - yearend varchar(5), - weightunit varchar(5), - businessnumber text, - version varchar(8), - curr text -); -insert into def (inventory_accno_id, income_accno_id, expense_accno_id, invnumber, ordnumber, yearend, weightunit, businessnumber, version, curr) select inventory_accno_id, income_accno_id, expense_accno_id, invnumber, ponumber, yearend, weightunit, businessnumber, version, nativecurr from defaults; -drop table defaults; -alter table def rename to defaults; -update defaults set version = '1.8.0'; --- --- create a default accno for exchange rate gain and loss --- -select accno into temp from chart where category = 'I' order by accno desc limit 1; -update temp set accno = accno + 1; -insert into chart (accno) select accno from temp; -update chart set description = 'Foreign Exchange Gain', category = 'I', charttype = 'A' where accno = (select accno from temp); -update defaults set fxgain_accno_id = (select id from chart where chart.accno = temp.accno); -drop table temp; -select accno into temp from chart where category = 'E' order by accno desc limit 1; -update temp set accno = accno + 1; -insert into chart (accno) select accno from temp; -update chart set description = 'Foreign Exchange Loss', category = 'E', charttype = 'A' where accno = (select accno from temp); -update defaults set fxloss_accno_id = (select id from chart where chart.accno = temp.accno); -drop table temp; --- -alter table parts add column bin text; -alter table parts alter column onhand set default 0; -update parts set onhand = 0 where onhand = NULL; -alter table parts add column obsolete bool; -alter table parts alter column obsolete set default 'f'; -update parts set obsolete = 'f'; --- -alter table ap rename column vendor to vendor_id; -alter table ap add column curr char(3); --- -alter table ar rename column customer to customer_id; -alter table ar add column curr char(3); -alter table ar add column ordnumber text; --- -alter table acc_trans add column source text; -alter table acc_trans add column cleared bool; -alter table acc_trans alter column cleared set default 'f'; -alter table acc_trans add column fx_transaction bool; -alter table acc_trans alter column fx_transaction set default 'f'; -update acc_trans set cleared = 'f', fx_transaction = 'f'; --- -create table oe ( - id int default nextval('id'), - ordnumber text, - transdate date default current_date, - vendor_id int, - customer_id int, - amount float8, - netamount float8, - reqdate date, - taxincluded bool, - shippingpoint text, - notes text, - curr char(3) -); --- -create table orderitems ( - trans_id int, - parts_id int, - description text, - qty float4, - sellprice float8, - discount float4 -); --- -alter table invoice rename to invoiceold; -create table invoice ( - id int default nextval('id'), - trans_id int, - parts_id int, - description text, - qty float4, - allocated float4, - sellprice float8, - fxsellprice float8, - discount float4, - assemblyitem bool default 'f' -); -insert into invoice (id, trans_id, parts_id, description, qty, allocated, sellprice, fxsellprice, discount, assemblyitem) select id, trans_id, parts_id, description, qty, allocated, sellprice, sellprice, discount, assemblyitem from invoiceold; -update invoice set assemblyitem = 'f' where assemblyitem = NULL; -drop table invoiceold; --- -create table exchangerate ( - curr char(3), - transdate date, - buy float8, - sell float8 -); --- diff --git a/sql/legacy/Pg-upgrade-1.8.0-1.8.4.sql b/sql/legacy/Pg-upgrade-1.8.0-1.8.4.sql deleted file mode 100755 index 57b24f1f..00000000 --- a/sql/legacy/Pg-upgrade-1.8.0-1.8.4.sql +++ /dev/null @@ -1,21 +0,0 @@ --- -alter table chart add column gifi_accno text; --- -create table gifi (accno text, description text); -create unique index gifi_accno_key on gifi (accno); --- -create table mtemp (parts_id int, name text); -insert into mtemp select parts_id, name from makemodel; -drop table makemodel; -alter table mtemp rename to makemodel; --- -alter table defaults add column closedto date; -alter table defaults add column revtrans bool; --- -alter table ap add column notes text; --- -alter table customer add column businessnumber text; -alter table vendor add column businessnumber text; --- -update defaults set version = '1.8.4', revtrans = 'f'; --- diff --git a/sql/legacy/Pg-upgrade-1.8.4-1.8.5.sql b/sql/legacy/Pg-upgrade-1.8.4-1.8.5.sql deleted file mode 100755 index 807857aa..00000000 --- a/sql/legacy/Pg-upgrade-1.8.4-1.8.5.sql +++ /dev/null @@ -1,63 +0,0 @@ --- -alter table customer rename column businessnumber to customernumber; -create index customer_customernumber_key on customer (customernumber); -alter table vendor rename column businessnumber to vendornumber; -create index vendor_vendornumber_key on vendor (vendornumber); --- -CREATE TABLE employee ( - id int DEFAULT nextval ('id'), - login text, - name varchar(35), - addr1 varchar(35), - addr2 varchar(35), - addr3 varchar(35), - addr4 varchar(35), - workphone varchar(20), - homephone varchar(20), - startdate date default current_date, - enddate date, - notes text -); --- -create index employee_id_key on employee (id); -create unique index employee_login_key on employee (login); -create index employee_name_key on employee (name); --- -alter table gl add column employee_id int; -create index gl_employee_id_key on gl (employee_id); -alter table ar add column employee_id int; -create index ar_employee_id_key on ar (employee_id); -alter table ap add column employee_id int; -create index ap_employee_id_key on ap (employee_id); -alter table oe add column employee_id int; -create index oe_employee_id_key on oe (employee_id); --- -alter table invoice add column unit varchar(5); -alter table orderitems add column unit varchar(5); --- -update chart set gifi_accno = '' where gifi_accno = NULL; -alter table chart rename to chartold; -CREATE TABLE chart ( - id int DEFAULT nextval ('id'), - accno text NOT NULL, - description text, - charttype char(1) DEFAULT 'A', - category char(1), - link text, - gifi_accno text -); -insert into chart (id, accno, description, charttype, category, link, gifi_accno) select id, accno, description, charttype, category, link, gifi_accno from chartold; -drop table chartold; -create index chart_id_key on chart (id); -create unique index chart_accno_key on chart (accno); -create index chart_category_key on chart (category); -create index chart_link_key on chart (link); -create index chart_gifi_accno_key on chart (gifi_accno); --- -alter table parts alter column inventory_accno_id drop default; --- -alter table defaults rename ordnumber to sonumber; -alter table defaults add column ponumber text; --- -update defaults set version = '1.8.5', ponumber = sonumber; --- diff --git a/sql/legacy/Pg-upgrade-1.8.5-2.0.0.sql b/sql/legacy/Pg-upgrade-1.8.5-2.0.0.sql deleted file mode 100755 index ebc1d070..00000000 --- a/sql/legacy/Pg-upgrade-1.8.5-2.0.0.sql +++ /dev/null @@ -1,92 +0,0 @@ --- -alter table customer add column cc text; -alter table customer add column bcc text; --- -alter table vendor add column cc text; -alter table vendor add column bcc text; --- -create table shipto ( - trans_id int, - shiptoname varchar(35), - shiptoaddr1 varchar(35), - shiptoaddr2 varchar(35), - shiptoaddr3 varchar(35), - shiptoaddr4 varchar(35), - shiptocontact varchar(35), - shiptophone varchar(20), - shiptofax varchar(20), - shiptoemail text -); --- -insert into shipto (trans_id, shiptoname, shiptoaddr1, shiptoaddr2, shiptoaddr3, shiptoaddr4, shiptocontact, shiptophone, shiptofax, shiptoemail) select id, shiptoname, shiptoaddr1, shiptoaddr2, shiptoaddr3, shiptoaddr4, shiptocontact, shiptophone, shiptofax, shiptoemail from customer where shiptoname != '' or shiptoname is not null; --- -insert into shipto (trans_id, shiptoname, shiptoaddr1, shiptoaddr2, shiptoaddr3, shiptoaddr4, shiptocontact, shiptophone, shiptofax, shiptoemail) select distinct on (a.id) a.id, c.shiptoname, c.shiptoaddr1, c.shiptoaddr2, c.shiptoaddr3, c.shiptoaddr4, c.shiptocontact, c.shiptophone, c.shiptofax, c.shiptoemail from customer c, ar a where a.customer_id = c.id; --- -insert into shipto (trans_id, shiptoname, shiptoaddr1, shiptoaddr2, shiptoaddr3, shiptoaddr4, shiptocontact, shiptophone, shiptofax, shiptoemail) select distinct on (o.id) o.id, c.shiptoname, c.shiptoaddr1, c.shiptoaddr2, c.shiptoaddr3, c.shiptoaddr4, c.shiptocontact, c.shiptophone, c.shiptofax, c.shiptoemail from customer c, oe o where o.customer_id = c.id; --- -create index shipto_trans_id_key on shipto (trans_id); --- -create table custome ( - id int default nextval('id'), - name varchar(35), - addr1 varchar(35), - addr2 varchar(35), - addr3 varchar(35), - addr4 varchar(35), - contact varchar(35), - phone varchar(20), - fax varchar(20), - email text, - notes text, - discount float4, - taxincluded bool, - creditlimit float DEFAULT 0, - terms int2 DEFAULT 0, - customernumber text, - cc text, - bcc text -); -insert into custome (id, name, addr1, addr2, addr3, addr4, contact, phone, fax, email, notes, discount, taxincluded, creditlimit, terms, customernumber) select id, name, addr1, addr2, addr3, addr4, contact, phone, fax, email, notes, discount, taxincluded, creditlimit, terms, customernumber from customer; --- -drop table customer; -alter table custome rename to customer; -create index customer_id_key on customer (id); -create index customer_name_key on customer (name); -create index customer_contact_key on customer (contact); --- -alter table parts add column bom boolean; -alter table parts alter column bom set default 'f'; -update parts set bom = 'f'; -update parts set bom = 't' where assembly; -alter table parts add column image text; -alter table parts add column drawing text; -alter table parts add column microfiche text; --- -alter table gl add column notes text; --- -alter table oe add column closed bool; -alter table oe alter column closed set default 'f'; -update oe set closed = 'f'; --- -create table project ( - id int default nextval('id'), - projectnumber text, - description text -); --- -create index project_id_key on project (id); --- -alter table acc_trans add column project_id int; -update acc_trans set cleared = '0' where cleared = '1'; --- -alter table invoice add column project_id int; -alter table invoice add column deliverydate date; -alter table orderitems add column project_id int; -alter table orderitems add column reqdate date; --- -alter table gl rename source to reference; -create index gl_reference_key on gl (reference); -create index acc_trans_source_key on acc_trans (lower(source)); --- -update defaults set version = '2.0.0'; --- diff --git a/sql/legacy/Pg-upgrade-2.0.0-2.0.8.sql b/sql/legacy/Pg-upgrade-2.0.0-2.0.8.sql deleted file mode 100755 index ef73b1cb..00000000 --- a/sql/legacy/Pg-upgrade-2.0.0-2.0.8.sql +++ /dev/null @@ -1,12 +0,0 @@ --- -create table partsgroup (id int default nextval('id'), partsgroup text); -create index partsgroup_id_key on partsgroup (id); --- -alter table parts add partsgroup_id int; --- -alter table assembly add bom bool; -update assembly set bom = '0' where assembly.id = parts.id and parts.bom = '0'; -update assembly set bom = '1' where assembly.id = parts.id and parts.bom = '1'; --- -update defaults set version = '2.0.8'; --- diff --git a/sql/legacy/Pg-upgrade-2.0.8-2.2.0.sql b/sql/legacy/Pg-upgrade-2.0.8-2.2.0.sql deleted file mode 100755 index 00778722..00000000 --- a/sql/legacy/Pg-upgrade-2.0.8-2.2.0.sql +++ /dev/null @@ -1,9 +0,0 @@ --- -create unique index projectnumber_key on project (projectnumber); -create unique index partsgroup_key on partsgroup (partsgroup); --- -alter table ar add till varchar(20); -alter table ap add till varchar(20); --- -update defaults set version = '2.2.0'; --- diff --git a/sql/legacy/Pg-upgrade-2.2.0-2.3.0.sql b/sql/legacy/Pg-upgrade-2.2.0-2.3.0.sql deleted file mode 100755 index edadee6f..00000000 --- a/sql/legacy/Pg-upgrade-2.2.0-2.3.0.sql +++ /dev/null @@ -1,59 +0,0 @@ --- -alter table oe add column quotation bool; -alter table oe alter column quotation set default 'f'; -update oe set quotation = '0'; -alter table oe add column quonumber text; --- -alter table defaults add column sqnumber text; -alter table defaults add column rfqnumber text; --- -alter table invoice add column serialnumber text; --- -alter table ar add column quonumber text; -create index ar_quonumber_key on ar (lower(quonumber)); -alter table ap add column quonumber text; -create index ap_quonumber_key on ap (lower(quonumber)); --- -alter table employee add role text; --- -alter table makemodel add column make text; -alter table makemodel add column model text; -update makemodel set make = substr(name,1,strpos(name,':')-1); -update makemodel set model = substr(name,strpos(name,':')+1); -create table temp (parts_id int,make text,model text); -insert into temp (parts_id,make,model) select parts_id,make,model from makemodel; -drop table makemodel; -alter table temp rename to makemodel; --- -create index makemodel_parts_id_key on makemodel (parts_id); -create index makemodel_make_key on makemodel (lower(make)); -create index makemodel_model_key on makemodel (lower(model)); --- -create table status (trans_id int, formname text, printed bool default 'f', emailed bool default 'f', spoolfile text, chart_id int); -create index status_trans_id_key on status (trans_id); --- -create sequence invoiceid; -select setval('invoiceid', (select max(id) from invoice)); -alter table invoice alter column id set default nextval('invoiceid'); --- -alter table ar add column intnotes text; -alter table ap add column intnotes text; -alter table oe add column intnotes text; --- -create table department (id int default nextval('id'), description text, role char(1) default 'P'); -create index department_id_key on department (id); --- -alter table ar add column department_id int; -alter table ar alter column department_id set default 0; -update ar set department_id = 0; -alter table ap add column department_id int; -alter table ap alter column department_id set default 0; -update ap set department_id = 0; -alter table gl add column department_id int; -alter table gl alter column department_id set default 0; -update gl set department_id = 0; -alter table oe add column department_id int; -alter table oe alter column department_id set default 0; -update oe set department_id = 0; --- -update defaults set version = '2.3.0'; diff --git a/sql/legacy/Pg-upgrade-2.3.0-2.3.1.sql b/sql/legacy/Pg-upgrade-2.3.0-2.3.1.sql deleted file mode 100755 index 04cfe1b7..00000000 --- a/sql/legacy/Pg-upgrade-2.3.0-2.3.1.sql +++ /dev/null @@ -1,382 +0,0 @@ --- function check_department -create function check_department() returns trigger as ' - -declare - dpt_id int; - -begin - - if new.department_id = 0 then - delete from dpt_trans where trans_id = new.id; - return NULL; - end if; - - select into dpt_id trans_id from dpt_trans where trans_id = new.id; - - if dpt_id > 0 then - update dpt_trans set department_id = new.department_id where trans_id = dpt_id; - else - insert into dpt_trans (trans_id, department_id) values (new.id, new.department_id); - end if; -return NULL; - -end; -' language 'plpgsql'; --- end function - --- department transaction table -create table dpt_trans (trans_id int, department_id int); - --- function del_department -create function del_department() returns trigger as ' -begin - delete from dpt_trans where trans_id = old.id; - return NULL; -end; -' language 'plpgsql'; --- end function - --- triggers --- -create trigger check_department after insert or update on ar for each row execute procedure check_department(); --- end trigger -create trigger check_department after insert or update on ap for each row execute procedure check_department(); --- end trigger -create trigger check_department after insert or update on gl for each row execute procedure check_department(); --- end trigger -create trigger check_department after insert or update on oe for each row execute procedure check_department(); --- end trigger --- --- -create trigger del_department after delete on ar for each row execute procedure del_department(); --- end trigger -create trigger del_department after delete on ap for each row execute procedure del_department(); --- end trigger -create trigger del_department after delete on gl for each row execute procedure del_department(); --- end trigger -create trigger del_department after delete on oe for each row execute procedure del_department(); --- end trigger --- - --- business table -create table business (id int default nextval('id'), description text, discount float4); --- --- SIC -create table sic (code text, sictype char(1), description text); --- -alter table vendor add column gifi_accno text; -alter table vendor add column business_id int; -alter table vendor add column taxnumber text; -alter table vendor add column sic_code text; --- -alter table customer add column business_id int; -alter table customer add column taxnumber text; -alter table customer add column sic_code text; --- -create function del_customer() returns trigger as ' -begin - delete from shipto where trans_id = old.id; - delete from customertax where customer_id = old.id; - return NULL; -end; -' language 'plpgsql'; --- end function --- -create function del_vendor() returns trigger as ' -begin - delete from shipto where trans_id = old.id; - delete from vendortax where vendor_id = old.id; - return NULL; -end; -' language 'plpgsql'; --- end function --- -create trigger del_customer after delete on customer for each row execute procedure del_customer(); --- end trigger -create trigger del_vendor after delete on vendor for each row execute procedure del_vendor(); --- end trigger --- -alter table acc_trans add column memo text; --- -alter table employee add column sales bool; -alter table employee alter column sales set default 't'; --- -alter table vendor add discount float4; -alter table vendor add creditlimit float; --- --- function del_exchangerate -create function del_exchangerate() returns trigger as ' - -declare - t_transdate date; - t_curr char(3); - t_id int; - d_curr text; - -begin - - select into d_curr substr(curr,1,3) from defaults; - - if TG_RELNAME = ''ar'' then - select into t_curr, t_transdate curr, transdate from ar where id = old.id; - end if; - if TG_RELNAME = ''ap'' then - select into t_curr, t_transdate curr, transdate from ap where id = old.id; - end if; - if TG_RELNAME = ''oe'' then - select into t_curr, t_transdate curr, transdate from oe where id = old.id; - end if; - - if d_curr != t_curr then - - select into t_id a.id from acc_trans ac - join ar a on (a.id = ac.trans_id) - where a.curr = t_curr - and ac.transdate = t_transdate - - except select a.id from ar a where a.id = old.id - - union - - select a.id from acc_trans ac - join ap a on (a.id = ac.trans_id) - where a.curr = t_curr - and ac.transdate = t_transdate - - except select a.id from ap a where a.id = old.id - - union - - select o.id from oe o - where o.curr = t_curr - and o.transdate = t_transdate - - except select o.id from oe o where o.id = old.id; - - if not found then - delete from exchangerate where curr = t_curr and transdate = t_transdate; - end if; - end if; -return old; - -end; -' language 'plpgsql'; --- end function --- --- triggers --- -create trigger del_exchangerate before delete on ar for each row execute procedure del_exchangerate(); --- end trigger --- -create trigger del_exchangerate before delete on ap for each row execute procedure del_exchangerate(); --- end trigger --- -create trigger del_exchangerate before delete on oe for each row execute procedure del_exchangerate(); --- end trigger --- --- -alter table orderitems add ship float4; -alter table orderitems add serialnumber text; --- --- -create sequence orderitemsid maxvalue 100000 cycle; --- add id to orderitems, fill in id -alter table orderitems add id int default nextval('orderitemsid'); --- -create table warehouse (id int default nextval('id'), description text); --- -create table inventory (warehouse_id int, parts_id int, oe_id int, orderitems_id int, qty float4, shippingdate date); --- -create index orderitems_id_key on orderitems (id); --- -alter table ar add shipvia text; -alter table ap add shipvia text; -alter table oe add shipvia text; --- --- -alter table inventory add employee_id int; --- --- -create function check_inventory() returns trigger as ' - -declare - itemid int; - row_data inventory%rowtype; - -begin - - if not old.quotation then - for row_data in select * from inventory where oe_id = old.id loop - select into itemid id from orderitems where trans_id = old.id and id = row_data.orderitems_id; - - if itemid is null then - delete from inventory where oe_id = old.id and orderitems_id = row_data.orderitems_id; - end if; - end loop; - end if; - return old; -end; -' language 'plpgsql'; --- end function --- -create trigger check_inventory after update on oe for each row execute procedure check_inventory(); --- end trigger --- --- -create table yearend ( - trans_id int, - transdate date -); --- --- function del_yearend -create function del_yearend() returns trigger as ' -begin - delete from yearend where trans_id = old.id; - return NULL; -end; -' language 'plpgsql'; --- end function - --- triggers --- -create trigger del_yearend after delete on gl for each row execute procedure del_yearend(); --- end trigger --- --- -create table temp ( - id int default nextval('id'), - name varchar(64), - addr1 varchar(64), - addr2 varchar(64), - addr3 varchar(64), - addr4 varchar(64), - contact varchar(64), - phone varchar(20), - fax varchar(20), - email text, - notes text, - discount float4, - taxincluded bool, - creditlimit float default 0, - terms int2 default 0, - customernumber varchar(64), - cc text, - bcc text, - business_id int, - taxnumber varchar(64), - sic_code varchar(6), - iban varchar(34), - bic varchar(11) -); -insert into temp (id, name, addr1, addr2, addr3, addr4, contact, phone, fax, email, notes, discount, taxincluded, creditlimit, terms, customernumber, cc, bcc, business_id, taxnumber, sic_code) select id, name, addr1, addr2, addr3, addr4, contact, phone, fax, email, notes, discount, taxincluded, creditlimit, terms, customernumber, cc, bcc, business_id, taxnumber, sic_code from customer; --- -drop table customer; --- -alter table temp rename to customer; --- -create index customer_id_key on customer (id); -create index customer_customernumber_key on customer (customernumber); -create index customer_name_key on customer (name); -create index customer_contact_key on customer (contact); --- -create trigger del_customer after delete on customer for each row execute procedure del_customer(); --- end trigger --- -create table temp ( - id int default nextval('id'), - name varchar(64), - addr1 varchar(64), - addr2 varchar(64), - addr3 varchar(64), - addr4 varchar(64), - contact varchar(64), - phone varchar(20), - fax varchar(20), - email text, - notes text, - terms int2 default 0, - taxincluded bool, - vendornumber varchar(64), - cc text, - bcc text, - gifi_accno varchar(30), - business_id int, - taxnumber varchar(64), - sic_code varchar(6), - discount float4, - creditlimit float default 0, - iban varchar(34), - bic varchar(11) -); -insert into temp (id, name, addr1, addr2, addr3, addr4, contact, phone, fax, email, notes, discount, taxincluded, creditlimit, terms, vendornumber, cc, bcc, business_id, taxnumber, sic_code) select id, name, addr1, addr2, addr3, addr4, contact, phone, fax, email, notes, discount, taxincluded, creditlimit, terms, vendornumber, cc, bcc, business_id, taxnumber, sic_code from vendor; --- -drop table vendor; --- -alter table temp rename to vendor; --- -create index vendor_id_key on vendor (id); -create index vendor_name_key on vendor (name); -create index vendor_vendornumber_key on vendor (vendornumber); -create index vendor_contact_key on vendor (contact); --- -create trigger del_vendor after delete on vendor for each row execute procedure del_vendor(); --- end trigger --- -create table temp ( - code varchar(6), - sictype char(1), - description text -); -insert into temp (code, sictype, description) select code, sictype, description from sic; -drop table sic; -alter table temp rename to sic; --- -create table temp ( - trans_id int, - shiptoname varchar(64), - shiptoaddr1 varchar(64), - shiptoaddr2 varchar(64), - shiptoaddr3 varchar(64), - shiptoaddr4 varchar(64), - shiptocontact varchar(64), - shiptophone varchar(20), - shiptofax varchar(20), - shiptoemail text -); -insert into temp (trans_id, shiptoname, shiptoaddr1, shiptoaddr2, shiptoaddr3, shiptoaddr4, shiptocontact, shiptophone, shiptofax, shiptoemail) select trans_id, shiptoname, shiptoaddr1, shiptoaddr2, shiptoaddr3, shiptoaddr4, shiptocontact, shiptophone, shiptofax, shiptoemail from shipto; -drop table shipto; -alter table temp rename to shipto; -create index shipto_trans_id_key on shipto (trans_id); --- --- -create table temp ( - id int default nextval('id'), - login text, - name varchar(64), - addr1 varchar(64), - addr2 varchar(64), - addr3 varchar(64), - addr4 varchar(64), - workphone varchar(20), - homephone varchar(20), - startdate date default current_date, - enddate date, - notes text, - role varchar(20), - sales bool, - email text, - sin varchar(20), - iban varchar(34), - bic varchar(11) -); -insert into temp (id,login,name,addr1,addr2,addr3,addr4,workphone,homephone,startdate,enddate,notes,role,sales) select id,login,name,addr1,addr2,addr3,addr4,workphone,homephone,startdate,enddate,notes,role,sales from employee; --- -drop table employee; -alter table temp rename to employee; --- -create index employee_id_key on employee (id); -create unique index employee_login_key on employee (login); -create index employee_name_key on employee (name); --- -update defaults set version = '2.3.1'; - diff --git a/sql/legacy/Pg-upgrade-2.3.1-2.3.3.sql b/sql/legacy/Pg-upgrade-2.3.1-2.3.3.sql deleted file mode 100755 index 9ee09915..00000000 --- a/sql/legacy/Pg-upgrade-2.3.1-2.3.3.sql +++ /dev/null @@ -1,9 +0,0 @@ --- -create table partsvendor (vendor_id int, parts_id int, partnumber text, leadtime int2, lastcost float, curr char(3)); -create index partsvendor_vendor_id_key on partsvendor (vendor_id); -create index partsvendor_parts_id_key on partsvendor (parts_id); --- -alter table assembly add column adj bool; -update assembly set adj = 't'; --- -update defaults set version = '2.3.3'; diff --git a/sql/legacy/Pg-upgrade-2.3.3-2.3.4.sql b/sql/legacy/Pg-upgrade-2.3.3-2.3.4.sql deleted file mode 100755 index 98e7b47b..00000000 --- a/sql/legacy/Pg-upgrade-2.3.3-2.3.4.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -alter table customer add employee_id int; -alter table vendor add employee_id int; -alter table employee add managerid int; --- -update defaults set version = '2.3.4'; diff --git a/sql/legacy/Pg-upgrade-2.3.4-2.3.5.sql b/sql/legacy/Pg-upgrade-2.3.4-2.3.5.sql deleted file mode 100755 index f4ab90ba..00000000 --- a/sql/legacy/Pg-upgrade-2.3.4-2.3.5.sql +++ /dev/null @@ -1,142 +0,0 @@ --- -create table temp ( - id int default nextval('id'), - name varchar(64), - address1 varchar(32), - address2 varchar(32), - city varchar(32), - state varchar(32), - zipcode varchar(10), - country varchar(32), - contact varchar(64), - phone varchar(20), - fax varchar(20), - email text, - notes text, - discount float4, - taxincluded bool default 'f', - creditlimit float default 0, - terms int2 default 0, - customernumber varchar(32), - cc text, - bcc text, - business_id int, - taxnumber varchar(32), - sic_code varchar(6), - iban varchar(34), - bic varchar(11), - employee_id int -); --- -insert into temp (id,name,address1,city,country,state,contact,phone,fax,email,notes,discount,taxincluded,creditlimit,terms,customernumber,cc,bcc,business_id,taxnumber,sic_code,iban,bic,employee_id) select id,name,substr(addr1,1,32),substr(addr2,1,32),substr(addr3,1,32),substr(addr4,1,32),contact,phone,fax,email,notes,discount,taxincluded,creditlimit,terms,substr(customernumber,1,32),cc,bcc,business_id,substr(taxnumber,1,32),sic_code,iban,bic,employee_id from customer; --- -drop table customer; -alter table temp rename to customer; --- -create index customer_id_key on customer (id); -create index customer_customernumber_key on customer (customernumber); -create index customer_name_key on customer (name); -create index customer_contact_key on customer (contact); --- -create trigger del_customer after delete on customer for each row execute procedure del_customer(); --- end trigger --- -create table temp ( - id int default nextval('id'), - name varchar(64), - address1 varchar(32), - address2 varchar(32), - city varchar(32), - state varchar(32), - zipcode varchar(10), - country varchar(32), - contact varchar(64), - phone varchar(20), - fax varchar(20), - email text, - notes text, - terms int2 default 0, - taxincluded bool default 'f', - vendornumber varchar(32), - cc text, - bcc text, - gifi_accno varchar(30), - business_id int, - taxnumber varchar(32), - sic_code varchar(6), - discount float4, - creditlimit float default 0, - iban varchar(34), - bic varchar(11), - employee_id int -); --- -insert into temp (id,name,address1,city,country,state,contact,phone,fax,email,notes,terms,taxincluded,vendornumber,cc,bcc,gifi_accno,business_id,taxnumber,sic_code,discount,creditlimit,iban,bic,employee_id) select id,name,substr(addr1,1,32),substr(addr2,1,32),substr(addr3,1,32),substr(addr4,1,32),contact,phone,fax,email,notes,terms,taxincluded,substr(vendornumber,1,32),cc,bcc,gifi_accno,business_id,substr(taxnumber,1,32),sic_code,discount,creditlimit,iban,bic,employee_id from vendor; --- -drop table vendor; -alter table temp rename to vendor; --- -create index vendor_id_key on vendor (id); -create index vendor_name_key on vendor (name); -create index vendor_vendornumber_key on vendor (vendornumber); -create index vendor_contact_key on vendor (contact); --- -create trigger del_vendor after delete on vendor for each row execute procedure del_vendor(); --- end trigger --- -create table temp ( - trans_id int, - shiptoname varchar(64), - shiptoaddress1 varchar(32), - shiptoaddress2 varchar(32), - shiptocity varchar(32), - shiptostate varchar(32), - shiptozipcode varchar(10), - shiptocountry varchar(32), - shiptocontact varchar(64), - shiptophone varchar(20), - shiptofax varchar(20), - shiptoemail text -); --- -insert into temp (trans_id,shiptoname,shiptoaddress1,shiptocity,shiptocountry,shiptostate,shiptocontact,shiptophone,shiptofax,shiptoemail) select trans_id,shiptoname,substr(shiptoaddr1,1,32),substr(shiptoaddr2,1,32),substr(shiptoaddr3,1,32),substr(shiptoaddr4,1,32),shiptocontact,shiptophone,shiptofax,shiptoemail from shipto; --- -drop table shipto; -alter table temp rename to shipto; -create index shipto_trans_id_key on shipto (trans_id); --- -create table temp ( - id int default nextval('id'), - login text, - name varchar(64), - address1 varchar(32), - address2 varchar(32), - city varchar(32), - state varchar(32), - zipcode varchar(10), - country varchar(32), - workphone varchar(20), - homephone varchar(20), - startdate date default current_date, - enddate date, - notes text, - role varchar(20), - sales bool default 'f', - email text, - sin varchar(20), - iban varchar(34), - bic varchar(11), - managerid int -); --- -insert into temp (id,login,name,address1,city,country,state,workphone,homephone,startdate,enddate,notes,role,sales,email,sin,iban,bic,managerid) select id,login,name,substr(addr1,1,32),substr(addr2,1,32),substr(addr3,1,32),substr(addr4,1,32),workphone,homephone,startdate,enddate,notes,role,sales,email,sin,iban,bic,managerid from employee; --- -drop table employee; -alter table temp rename to employee; --- -create index employee_id_key on employee (id); -create unique index employee_login_key on employee (login); -create index employee_name_key on employee (name); --- -update defaults set version = '2.3.5'; - diff --git a/sql/legacy/Pg-upgrade-2.3.5-2.3.6.sql b/sql/legacy/Pg-upgrade-2.3.5-2.3.6.sql deleted file mode 100755 index 3eac490f..00000000 --- a/sql/legacy/Pg-upgrade-2.3.5-2.3.6.sql +++ /dev/null @@ -1,15 +0,0 @@ --- -create table pricegroup (id int default nextval('id'), pricegroup text); -create index pricegroup_pricegroup_key on pricegroup (pricegroup); -create index pricegroup_id_key on pricegroup (id); --- -create table partscustomer (parts_id int, customer_id int, pricegroup_id int, pricebreak float4, sellprice float, validfrom date, validto date); --- -create table language (code varchar(6), description text); -alter table customer add language_code varchar(6); -alter table customer add pricegroup_id int; --- -alter table vendor add language_code varchar(6); -alter table vendor add pricegroup_id int; --- -update defaults set version = '2.3.6'; diff --git a/sql/legacy/Pg-upgrade-2.3.6-2.3.7.sql b/sql/legacy/Pg-upgrade-2.3.6-2.3.7.sql deleted file mode 100755 index 8eb265b6..00000000 --- a/sql/legacy/Pg-upgrade-2.3.6-2.3.7.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -alter table partscustomer add curr char(3); -alter table customer add curr char(3); -alter table vendor add curr char(3); --- -update defaults set version = '2.3.7'; diff --git a/sql/legacy/Pg-upgrade-2.3.7-2.3.8.sql b/sql/legacy/Pg-upgrade-2.3.7-2.3.8.sql deleted file mode 100755 index 56979bee..00000000 --- a/sql/legacy/Pg-upgrade-2.3.7-2.3.8.sql +++ /dev/null @@ -1,16 +0,0 @@ --- -create table audittrail ( - trans_id int, - tablename text, - reference text, - formname text, - action text, - transdate timestamp default current_timestamp, - employee_id int -); -create index audittrail_trans_id_key on audittrail (trans_id); --- -alter table defaults add audittrail bool; -alter table defaults alter audittrail set default '0'; --- -update defaults set version = '2.3.8', audittrail = '0'; diff --git a/sql/legacy/Pg-upgrade-2.3.8-2.3.9.sql b/sql/legacy/Pg-upgrade-2.3.8-2.3.9.sql deleted file mode 100755 index dc484cec..00000000 --- a/sql/legacy/Pg-upgrade-2.3.8-2.3.9.sql +++ /dev/null @@ -1,15 +0,0 @@ --- -create table translation ( - trans_id int, - language_code varchar(6), - description text -); -create index translation_trans_id_key on translation (trans_id); --- -alter table ar add language_code varchar(6); -alter table ap add language_code varchar(6); -alter table oe add language_code varchar(6); --- -create unique index language_code_key on language (code); --- -update defaults set version = '2.3.9'; diff --git a/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql b/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql deleted file mode 100755 index 92096fbe..00000000 --- a/sql/legacy/Pg-upgrade-2.3.9-2.4.2.sql +++ /dev/null @@ -1,34 +0,0 @@ --- -drop trigger del_customer on customer; -drop trigger del_vendor on vendor; -drop function del_customer(); -drop function del_vendor(); --- -create function del_customer() returns trigger as ' -begin - delete from shipto where trans_id = old.id; - delete from customertax where customer_id = old.id; - delete from partscustomer where customer_id = old.id; - return NULL; -end; -' language 'plpgsql'; --- end function --- -create trigger del_customer after delete on customer for each row execute procedure del_customer(); --- end trigger --- -create function del_vendor() returns trigger as ' -begin - delete from shipto where trans_id = old.id; - delete from vendortax where vendor_id = old.id; - delete from partsvendor where vendor_id = old.id; - return NULL; -end; -' language 'plpgsql'; --- end function --- -create trigger del_vendor after delete on vendor for each row execute procedure del_vendor(); --- end trigger --- -update defaults set version = '2.4.2'; - diff --git a/sql/legacy/Pg-upgrade-2.4.2-2.4.3.sql b/sql/legacy/Pg-upgrade-2.4.2-2.4.3.sql deleted file mode 100755 index a3c21f33..00000000 --- a/sql/legacy/Pg-upgrade-2.4.2-2.4.3.sql +++ /dev/null @@ -1,17 +0,0 @@ --- -alter table defaults rename invnumber to sinumber; -alter table defaults add vinumber text; -alter table defaults add employeenumber text; -alter table defaults add partnumber text; -alter table defaults add customernumber text; -alter table defaults add vendornumber text; --- -alter table employee add employeenumber varchar(32); --- -alter table customer add startdate date; -alter table customer add enddate date; --- -alter table vendor add startdate date; -alter table vendor add enddate date; --- -update defaults set version = '2.4.3'; diff --git a/sql/legacy/Pg-upgrade-2.4.3-2.4.4.sql b/sql/legacy/Pg-upgrade-2.4.3-2.4.4.sql deleted file mode 100755 index 38e25751..00000000 --- a/sql/legacy/Pg-upgrade-2.4.3-2.4.4.sql +++ /dev/null @@ -1,5 +0,0 @@ --- -alter table employee add dob date; -alter table employee rename sin to ssn; --- -update defaults set version = '2.4.4'; diff --git a/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql b/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql deleted file mode 100755 index 82da5cd6..00000000 --- a/sql/legacy/Pg-upgrade-2.4.4-2.5.0.sql +++ /dev/null @@ -1,31 +0,0 @@ --- -alter table ar add ponumber text; -alter table ap add ponumber text; -alter table oe add ponumber text; --- -alter table project add startdate date; -alter table project add enddate date; --- -create table recurring (id int, reference text, startdate date, nextdate date, enddate date, repeat int2, unit varchar(6), howmany int, payment bool default 'f'); -create table recurringemail (id int, formname text, format text, message text); -create table recurringprint (id int, formname text, format text, printer text); --- -create function del_recurring() returns trigger as ' -begin - delete from recurring where id = old.id; - delete from recurringemail where id = old.id; - delete from recurringprint where id = old.id; - return NULL; -end; -' language 'plpgsql'; ---end function -create trigger del_recurring after delete on ar for each row execute procedure del_recurring(); --- end trigger -create trigger del_recurring after delete on ap for each row execute procedure del_recurring(); --- end trigger -create trigger del_recurring after delete on gl for each row execute procedure del_recurring(); --- end trigger -create trigger del_recurring after delete on oe for each row execute procedure del_recurring(); --- end trigger --- -update defaults set version = '2.5.0'; diff --git a/sql/legacy/Pg-upgrade-2.5.0-2.5.2.sql b/sql/legacy/Pg-upgrade-2.5.0-2.5.2.sql deleted file mode 100755 index b575bdd8..00000000 --- a/sql/legacy/Pg-upgrade-2.5.0-2.5.2.sql +++ /dev/null @@ -1,136 +0,0 @@ --- -create sequence jcitemsid; -create table jcitems (id int default nextval('jcitemsid'), project_id int, parts_id int, description text, qty float4, allocated float4, sellprice float8, fxsellprice float8, serialnumber text, checkedin timestamp with time zone, checkedout timestamp with time zone, employee_id int); -create index jcitems_id_key on jcitems (id); --- -alter table project add parts_id int; -alter table project add production float; -alter table project add completed float; -alter table project add customer_id int; -alter table project alter production set default 0; -alter table project alter completed set default 0; -update project set production = 0, completed = 0; --- -alter table parts add project_id int; --- -alter table parts add avgcost float; --- -create function avgcost(int) returns float as ' - -declare - -v_cost float; -v_qty float; -v_parts_id alias for $1; - -begin - - select into v_cost, v_qty sum(i.sellprice * i.qty), sum(i.qty) - from invoice i - join ap a on (a.id = i.trans_id) - where i.parts_id = v_parts_id; - - if not v_qty is null then - v_cost := v_cost/v_qty; - end if; - - if v_cost is null then - v_cost := 0; - end if; - -return v_cost; - -end; -' language 'plpgsql'; --- end function --- -create function lastcost(int) returns float as ' - -declare - -v_cost float; -v_parts_id alias for $1; - -begin - - select into v_cost sellprice from invoice i - join ap a on (a.id = i.trans_id) - where i.parts_id = v_parts_id - order by a.transdate desc - limit 1; - - if v_cost is null then - v_cost := 0; - end if; - -return v_cost; - -end; -' language 'plpgsql'; --- end function --- -alter table inventory rename oe_id to trans_id; --- -alter table ap add shippingpoint text; -alter table ap add terms int2; --- -drop trigger check_inventory on oe; -drop function check_inventory(); -create function check_inventory() returns trigger as ' - -declare - itemid int; - row_data inventory%rowtype; - -begin - - if not old.quotation then - for row_data in select * from inventory where trans_id = old.id loop - select into itemid id from orderitems where trans_id = old.id and id = row_data.orderitems_id; - - if itemid is null then - delete from inventory where trans_id = old.id and orderitems_id = row_data.orderitems_id; - end if; - end loop; - end if; -return old; -end; -' language 'plpgsql'; --- end function --- -create trigger check_inventory after update on oe for each row execute procedure check_inventory(); --- end trigger --- -alter table orderitems alter id drop default; --- -create function temp() returns int as ' - -declare - v_last int; - -begin - - SELECT INTO v_last last_value FROM orderitemsid; - drop sequence orderitemsid; - create sequence orderitemsid; - perform setval(''orderitemsid'', v_last); - -return NULL; -end; -' language 'plpgsql'; --- end function --- -select temp(); -drop function temp(); --- -alter table orderitems alter id set default nextval('orderitemsid'); --- -alter table chart add contra boolean; -alter table chart alter contra set default 'f'; -update chart set category = 'A', contra = '1' where category = 'C'; -update chart set contra = '0' where contra is null; --- -alter table defaults add glnumber text; --- -update defaults set version = '2.5.2'; - diff --git a/sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql b/sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql deleted file mode 100755 index 7a848b16..00000000 --- a/sql/legacy/Pg-upgrade-2.5.2-2.6.0.sql +++ /dev/null @@ -1,9 +0,0 @@ --- -alter table oe add terms smallint; -alter table oe alter terms set default 0; --- -alter table ap alter terms set default 0; --- -delete from inventory where warehouse_id = 0; --- -update defaults set version = '2.6.0'; diff --git a/sql/legacy/Pg-upgrade-2.6.0-2.6.1.sql b/sql/legacy/Pg-upgrade-2.6.0-2.6.1.sql deleted file mode 100755 index 026cdafe..00000000 --- a/sql/legacy/Pg-upgrade-2.6.0-2.6.1.sql +++ /dev/null @@ -1,5 +0,0 @@ --- -alter table jcitems add notes text; --- -update defaults set version = '2.6.1'; - diff --git a/sql/legacy/Pg-upgrade-2.6.1-2.6.2.sql b/sql/legacy/Pg-upgrade-2.6.1-2.6.2.sql deleted file mode 100755 index 39136600..00000000 --- a/sql/legacy/Pg-upgrade-2.6.1-2.6.2.sql +++ /dev/null @@ -1,60 +0,0 @@ --- -drop function avgcost(int); -CREATE FUNCTION avgcost(int) RETURNS FLOAT AS ' - -DECLARE - -v_cost float; -v_qty float; -v_parts_id alias for $1; - -BEGIN - - SELECT INTO v_cost, v_qty SUM(i.sellprice * i.qty), SUM(i.qty) - FROM invoice i - JOIN ap a ON (a.id = i.trans_id) - WHERE i.parts_id = v_parts_id; - - IF v_cost IS NULL THEN - v_cost := 0; - END IF; - - IF NOT v_qty IS NULL THEN - IF v_qty = 0 THEN - v_cost := 0; - ELSE - v_cost := v_cost/v_qty; - END IF; - END IF; - -RETURN v_cost; -END; -' language 'plpgsql'; --- end function --- -drop function lastcost(int); -CREATE FUNCTION lastcost(int) RETURNS FLOAT AS ' - -DECLARE - -v_cost float; -v_parts_id alias for $1; - -BEGIN - - SELECT INTO v_cost sellprice FROM invoice i - JOIN ap a ON (a.id = i.trans_id) - WHERE i.parts_id = v_parts_id - ORDER BY a.transdate desc, a.id desc - LIMIT 1; - - IF v_cost IS NULL THEN - v_cost := 0; - END IF; - -RETURN v_cost; -END; -' language 'plpgsql'; --- end function --- -update defaults set version = '2.6.2'; diff --git a/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql b/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql deleted file mode 100755 index 908ad198..00000000 --- a/sql/legacy/Pg-upgrade-2.6.12-2.6.17.sql +++ /dev/null @@ -1,19 +0,0 @@ -CREATE SEQUENCE session_session_id_seq; - -CREATE TABLE session( -session_id INTEGER PRIMARY KEY DEFAULT nextval('session_session_id_seq'), -sl_login VARCHAR(50), -token CHAR(32), -last_used TIMESTAMP default now() -); - --- LOCK TABLE acc_trans; -ALTER TABLE acc_trans ALTER COLUMN chart_id SET NOT NULL; - --- For older versions pre 8.0.3 -ALTER TABLE acc_trans ADD COLUMN amount2 NUMERIC; -UPDATE acc_trans set amount2 = amount; -ALTER TABLE acc_trans DROP COLUMN amount; -ALTER TABLE acc_trans RENAME column amount2 TO amount; - -UPDATE defaults SET version = '2.6.17'; diff --git a/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql b/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql deleted file mode 100644 index 7d27c2a4..00000000 --- a/sql/legacy/Pg-upgrade-2.6.17-2.6.18.sql +++ /dev/null @@ -1,289 +0,0 @@ -BEGIN; -ALTER TABLE chart ADD PRIMARY KEY (id); --- linuxpoet: --- adding primary key to acc_trans --- We are using standard postgresql names for the sequence for consistency as we move forward --- Do everything in a transaction in case it blows up - -LOCK acc_trans in EXCLUSIVE mode; -ALTER TABLE acc_trans ADD COLUMN entry_id bigint; -CREATE SEQUENCE acctrans_entry_id_seq; -ALTER TABLE acc_trans ALTER COLUMN entry_id SET DEFAULT nextval('acctrans_entry_id_seq'); -UPDATE acc_trans SET entry_id = nextval('acctrans_entry_id_seq'); -ALTER TABLE acc_trans ADD PRIMARY key (entry_id); - --- We should probably add a foreign key to chart.id -ALTER TABLE acc_trans ADD FOREIGN KEY (chart_id) REFERENCES chart (id); - --- Start changing floats -ALTER TABLE acc_trans ALTER COLUMN amount TYPE NUMERIC; - --- This may break someone if they for some reason have an actual float type in the qty column -ALTER TABLE invoice ALTER COLUMN qty TYPE numeric; - -ALTER TABLE invoice ALTER COLUMN allocated TYPE numeric; -ALTER TABLE invoice ALTER COLUMN sellprice TYPE NUMERIC; -ALTER TABLE invoice ALTER COLUMN fxsellprice TYPE NUMERIC; - -ALTER TABLE customer ALTER COLUMN discount TYPE numeric; -ALTER TABLE customer ALTER COLUMN creditlimit TYPE NUMERIC; - -ALTER TABLE parts ALTER COLUMN listprice TYPE NUMERIC; -ALTER TABLE parts ALTER COLUMN sellprice TYPE NUMERIC; -ALTER TABLE parts ALTER COLUMN lastcost TYPE NUMERIC; -ALTER TABLE parts ALTER COLUMN weight TYPE numeric; -ALTER TABLE parts ALTER COLUMN onhand TYPE numeric; -ALTER TABLE parts ALTER COLUMN avgcost TYPE NUMERIC; - -ALTER TABLE assembly ALTER COLUMN qty TYPE numeric; - -ALTER TABLE ar ALTER COLUMN amount TYPE NUMERIC; -ALTER TABLE ar ALTER COLUMN netamount TYPE NUMERIC; -ALTER TABLE ar ALTER COLUMN paid TYPE NUMERIC; - -ALTER TABLE ap ALTER COLUMN amount TYPE NUMERIC; -ALTER TABLE ap ALTER COLUMN netamount TYPE NUMERIC; -ALTER TABLE ap ALTER COLUMN paid TYPE NUMERIC; - -ALTER TABLE tax ALTER COLUMN rate TYPE numeric; - -ALTER TABLE oe ALTER COLUMN amount TYPE NUMERIC; -ALTER TABLE oe ALTER COLUMN netamount TYPE NUMERIC; - -ALTER TABLE orderitems ALTER COLUMN qty TYPE numeric; -ALTER TABLE orderitems ALTER COLUMN sellprice TYPE NUMERIC; -ALTER TABLE orderitems ALTER COLUMN discount TYPE numeric; -ALTER TABLE orderitems ALTER COLUMN ship TYPE numeric; - -ALTER TABLE exchangerate ALTER COLUMN buy TYPE numeric; -ALTER TABLE exchangerate ALTER COLUMN sell TYPE numeric; - -ALTER TABLE vendor ALTER COLUMN discount TYPE numeric; -ALTER TABLE vendor ALTER COLUMN creditlimit TYPE numeric; - -ALTER TABLE project ALTER COLUMN production TYPE numeric; -ALTER TABLE project ALTER COLUMN completed TYPE numeric; - -ALTER TABLE business ALTER COLUMN discount TYPE numeric; - -ALTER TABLE inventory ALTER COLUMN qty TYPE numeric; - -ALTER TABLE partsvendor ALTER COLUMN lastcost TYPE NUMERIC; - -ALTER TABLE partscustomer ALTER COLUMN pricebreak TYPE numeric; -ALTER TABLE partscustomer ALTER COLUMN sellprice TYPE NUMERIC; - -ALTER TABLE jcitems ALTER COLUMN qty TYPE numeric; -ALTER TABLE jcitems ALTER COLUMN allocated TYPE numeric; -ALTER TABLE jcitems ALTER COLUMN sellprice TYPE NUMERIC; -ALTER TABLE jcitems ALTER COLUMN fxsellprice TYPE NUMERIC; - --- The query rewrite rule necessary to notify the email app that a new report --- needs to be sent to the designated administrator. --- By Chris Travers --- chris@metatrontech.com --- Licensed under the GNU GPL 2.0 or later at your option. See accompanying --- GPL.txt - -CREATE OR REPLACE FUNCTION trigger_parts_short() RETURNS TRIGGER -AS -' -BEGIN - IF NEW.onhand >= NEW.rop THEN - NOTIFY parts_short; - END IF; - RETURN NEW; -END; -' LANGUAGE PLPGSQL; --- end function - -CREATE TRIGGER parts_short AFTER UPDATE ON parts -FOR EACH ROW EXECUTE PROCEDURE trigger_parts_short(); - -create table transactions ( - id int PRIMARY KEY, - table_name text -); - -insert into transactions (id, table_name) SELECT id, 'ap' FROM ap; - -CREATE RULE ap_id_track_i AS ON insert TO ap -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ap'); - -CREATE RULE ap_id_track_u AS ON update TO ap -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -insert into transactions (id, table_name) SELECT id, 'ar' FROM ar; - -CREATE RULE ar_id_track_i AS ON insert TO ar -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'ar'); - -CREATE RULE ar_id_track_u AS ON update TO ar -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'business' FROM business; - -CREATE RULE business_id_track_i AS ON insert TO business -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'business'); - -CREATE RULE business_id_track_u AS ON update TO business -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'chart' FROM chart; - -CREATE RULE chart_id_track_i AS ON insert TO chart -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'chart'); - -CREATE RULE chart_id_track_u AS ON update TO chart -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'customer' FROM customer; - -CREATE RULE customer_id_track_i AS ON insert TO customer -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'customer'); - -CREATE RULE customer_id_track_u AS ON update TO customer -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'department' FROM department; - -CREATE RULE department_id_track_i AS ON insert TO department -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'department'); - -CREATE RULE department_id_track_u AS ON update TO department -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'employee' FROM employee; - -CREATE RULE employee_id_track_i AS ON insert TO employee -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'employee'); - -CREATE RULE employee_id_track_u AS ON update TO employee -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'gl' FROM gl; - -CREATE RULE gl_id_track_i AS ON insert TO gl -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'gl'); - -CREATE RULE gl_id_track_u AS ON update TO gl -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'oe' FROM oe; - -CREATE RULE oe_id_track_i AS ON insert TO oe -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'oe'); - -CREATE RULE oe_id_track_u AS ON update TO oe -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'parts' FROM parts; - -CREATE RULE parts_id_track_i AS ON insert TO parts -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'parts'); - -CREATE RULE parts_id_track_u AS ON update TO parts -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'partsgroup' FROM partsgroup; - -CREATE RULE partsgroup_id_track_i AS ON insert TO partsgroup -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'partsgroup'); - -CREATE RULE partsgroup_id_track_u AS ON update TO partsgroup -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'pricegroup' FROM pricegroup; - -CREATE RULE pricegroup_id_track_i AS ON insert TO pricegroup -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'pricegroup'); - -CREATE RULE pricegroup_id_track_u AS ON update TO pricegroup -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'project' FROM project; - -CREATE RULE project_id_track_i AS ON insert TO project -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'project'); - -CREATE RULE project_id_track_u AS ON update TO project -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'vendor' FROM vendor; - -CREATE RULE vendor_id_track_i AS ON insert TO vendor -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'vendor'); - -CREATE RULE employee_id_track_u AS ON update TO vendor -DO UPDATE transactions SET id = new.id WHERE id = old.id; - -INSERT INTO transactions (id, table_name) SELECT id, 'warehouse' FROM warehouse; - -CREATE RULE warehouse_id_track_i AS ON insert TO warehouse -DO INSERT INTO transactions (id, table_name) VALUES (new.id, 'employee'); - -CREATE RULE warehouse_id_track_u AS ON update TO warehouse -DO UPDATE transactions SET id = new.id WHERE id = old.id; - - -CREATE TABLE custom_table_catalog ( -table_id SERIAL PRIMARY KEY, -extends TEXT, -table_name TEXT -); - -CREATE TABLE custom_field_catalog ( -field_id SERIAL PRIMARY KEY, -table_id INT REFERENCES custom_table_catalog, -field_name TEXT -); -CREATE OR REPLACE FUNCTION add_custom_field (VARCHAR, VARCHAR, VARCHAR) -RETURNS BOOL AS -' -DECLARE -table_name ALIAS FOR $1; -new_field_name ALIAS FOR $2; -field_datatype ALIAS FOR $3; - -BEGIN - EXECUTE ''SELECT TABLE_ID FROM custom_table_catalog - WHERE extends = '''''' || table_name || '''''' ''; - IF NOT FOUND THEN - BEGIN - INSERT INTO custom_table_catalog (extends) VALUES (table_name); - EXECUTE ''CREATE TABLE custom_''||table_name || - '' (row_id INT)''; - EXCEPTION WHEN duplicate_table THEN - -- do nothing - END; - END IF; - EXECUTE ''INSERT INTO custom_field_catalog (field_name, table_id) - VALUES ( '''''' || new_field_name ||'''''', (SELECT table_id FROM custom_table_catalog - WHERE extends = ''''''|| table_name || ''''''))''; - EXECUTE ''ALTER TABLE custom_''||table_name || '' ADD COLUMN '' - || new_field_name || '' '' || field_datatype; - RETURN TRUE; -END; -' LANGUAGE PLPGSQL; --- end function - -CREATE OR REPLACE FUNCTION drop_custom_field (VARCHAR, VARCHAR) -RETURNS BOOL AS -' -DECLARE -table_name ALIAS FOR $1; -custom_field_name ALIAS FOR $2; -BEGIN - DELETE FROM custom_field_catalog - WHERE field_name = custom_field_name AND - table_id = (SELECT table_id FROM custom_table_catalog - WHERE extends = table_name); - EXECUTE ''ALTER TABLE custom_'' || table_name || - '' DROP COLUMN '' || custom_field_name; - RETURN TRUE; -END; -' LANGUAGE PLPGSQL; --- end function - -UPDATE defaults SET version = '2.6.18'; -COMMIT; diff --git a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql b/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql deleted file mode 100644 index 020738a1..00000000 --- a/sql/legacy/Pg-upgrade-2.6.18-2.6.19.sql +++ /dev/null @@ -1,309 +0,0 @@ -BEGIN; - -ALTER TABLE ap ADD PRIMARY KEY (id); - -ALTER TABLE ar ADD PRIMARY KEY (id); - -ALTER TABLE assembly ADD PRIMARY KEY (id, parts_id); - -ALTER TABLE business ADD PRIMARY KEY (id); - -ALTER TABLE customer ADD PRIMARY KEY (id); - -ALTER TABLE customertax ADD PRIMARY KEY (customer_id, chart_id); - -ALTER TABLE department ADD PRIMARY KEY (id); - -ALTER TABLE dpt_trans ADD PRIMARY KEY (trans_id); - -ALTER TABLE employee ADD PRIMARY KEY (id); - -ALTER TABLE exchangerate ADD PRIMARY KEY (curr, transdate); - -ALTER TABLE gifi ADD PRIMARY KEY (accno); - -ALTER TABLE gl ADD PRIMARY KEY (id); - -ALTER TABLE invoice ADD PRIMARY KEY (id); - -ALTER TABLE jcitems ADD PRIMARY KEY (id); - -ALTER TABLE language ADD PRIMARY KEY (code); - -ALTER TABLE makemodel ADD PRIMARY KEY (parts_id); - -ALTER TABLE oe ADD PRIMARY KEY (id); - -SELECT setval('orderitemsid', 1); -UPDATE orderitems SET id = nextval('orderitemsid'); - -ALTER TABLE orderitems ADD PRIMARY KEY (id); - -ALTER TABLE parts ADD PRIMARY KEY (id); - -ALTER TABLE partsgroup ADD PRIMARY KEY (id); - -ALTER TABLE partstax ADD PRIMARY KEY (parts_id, chart_id); -ALTER TABLE partstax ADD FOREIGN KEY (chart_id) REFERENCES chart (id); -ALTER TABLE partstax ADD FOREIGN KEY (parts_id) REFERENCES parts (id); - -ALTER TABLE pricegroup ADD PRIMARY KEY (id); - -ALTER TABLE project ADD PRIMARY KEY (id); - -ALTER TABLE recurringemail ADD PRIMARY KEY (id); - -ALTER TABLE recurring ADD PRIMARY KEY (id); - -ALTER TABLE recurringprint ADD PRIMARY KEY (id); - -ALTER TABLE sic ADD PRIMARY KEY (code); - -ALTER TABLE status ADD PRIMARY KEY (trans_id); - --- Removing the primary key below since this is not quite the best way --- do this. The tax table could have multiple rows per chart_id. --- We need a better fix for 1.3 (perhaps changing date to timestamp and --- and defaulting to infinity. --- ALTER TABLE tax ADD PRIMARY KEY (chart_id); --- ALTER TABLE tax ADD FOREIGN KEY (chart_id) REFERENCES chart (id); - -ALTER TABLE translation ADD PRIMARY KEY (trans_id, language_code); - -ALTER TABLE vendor ADD PRIMARY KEY (id); - -ALTER TABLE vendortax ADD PRIMARY KEY (vendor_id, chart_id); - -ALTER TABLE warehouse ADD PRIMARY KEY (id); - -ALTER TABLE yearend ADD PRIMARY KEY (trans_id); - -LOCK inventory in EXCLUSIVE mode; -ALTER TABLE inventory ADD COLUMN entry_id bigint; -CREATE SEQUENCE inventory_entry_id_seq; - -ALTER TABLE inventory ALTER COLUMN entry_id -SET DEFAULT nextval('inventory_entry_id_seq'); - -UPDATE inventory SET entry_id = nextval('inventory_entry_id_seq'); -ALTER TABLE inventory ADD PRIMARY key (entry_id); - -LOCK partscustomer IN EXCLUSIVE MODE; -ALTER TABLE partscustomer ADD COLUMN entry_id int; -CREATE SEQUENCE partscustomer_entry_id_seq; - -ALTER TABLE partscustomer ALTER COLUMN entry_id -SET DEFAULT nextval('partscustomer_entry_id_seq'); - -UPDATE partscustomer SET entry_id = nextval('partscustomer_entry_id_seq'); -ALTER TABLE partscustomer ADD PRIMARY KEY (entry_id); - -LOCK partsvendor IN EXCLUSIVE MODE; -ALTER TABLE partsvendor ADD COLUMN entry_id int; -CREATE SEQUENCE partsvendor_entry_id_seq; - -ALTER TABLE partsvendor ALTER COLUMN entry_id -SET DEFAULT nextval('partsvendor_entry_id_seq'); - -UPDATE partsvendor SET entry_id = nextval('partsvendor_entry_id_seq'); -ALTER TABLE partsvendor ADD PRIMARY KEY (entry_id); - -LOCK audittrail IN EXCLUSIVE MODE; -ALTER TABLE audittrail ADD COLUMN entry_id int; -CREATE SEQUENCE audittrail_entry_id_seq ; - -ALTER TABLE audittrail ALTER COLUMN entry_id -SET DEFAULT nextval('audittrail_entry_id_seq'); - -UPDATE audittrail SET entry_id = nextval('audittrail_entry_id_seq'); -ALTER TABLE audittrail ADD PRIMARY KEY (entry_id); - -LOCK shipto IN EXCLUSIVE MODE; -ALTER TABLE shipto ADD COLUMN entry_id int; -CREATE SEQUENCE shipto_entry_id_seq ; - -ALTER TABLE shipto ALTER COLUMN entry_id -SET DEFAULT nextval('shipto_entry_id_seq'); - -UPDATE shipto SET entry_id = nextval('shipto_entry_id_seq'); -ALTER TABLE shipto ADD PRIMARY KEY (entry_id); - -CREATE TABLE taxmodule ( - taxmodule_id serial PRIMARY KEY, - taxmodulename text NOT NULL -); - -INSERT INTO taxmodule ( - taxmodule_id, taxmodulename - ) VALUES ( - 1, 'Simple' -); - -CREATE TABLE taxcategory ( - taxcategory_id serial PRIMARY KEY, - taxcategoryname text NOT NULL, - taxmodule_id int NOT NULL REFERENCES taxmodule (taxmodule_id) -); - -ALTER TABLE partstax ADD COLUMN taxcategory_id int REFERENCES taxcategory (taxcategory_id); - -LOCK tax IN EXCLUSIVE MODE; -ALTER TABLE tax ADD COLUMN pass int DEFAULT 0; -UPDATE tax SET pass = 0; -ALTER TABLE tax ALTER COLUMN pass SET NOT NULL; - -ALTER TABLE tax ADD COLUMN taxmodule_id int REFERENCES taxmodule DEFAULT 1; -UPDATE tax SET taxmodule_id = 1; -ALTER TABLE tax ALTER COLUMN taxmodule_id SET NOT NULL; - -ALTER TABLE defaults RENAME TO old_defaults; - -CREATE TABLE defaults ( - setting_key TEXT PRIMARY KEY, - value TEXT -); - -COMMENT ON TABLE defaults IS $$This table replaces the old one column per value system with a simple key => value table$$; - - -INSERT INTO defaults (setting_key, value) -SELECT 'inventory_accno_id', inventory_accno_id::text FROM old_defaults -UNION -SELECT 'income_accno_id', income_accno_id::text FROM old_defaults -UNION -SELECT 'expense_accno_id', expense_accno_id::text FROM old_defaults -UNION -SELECT 'fxloss_accno_id', fxloss_accno_id::text FROM old_defaults -UNION -SELECT 'fxgain_accno_id', fxgain_accno_id::text FROM old_defaults -UNION -SELECT 'sinumber', sinumber::text FROM old_defaults -UNION -SELECT 'sonumber', sonumber::text FROM old_defaults -UNION -SELECT 'yearend', yearend::text FROM old_defaults -UNION -SELECT 'weightunit', weightunit::text FROM old_defaults -UNION -SELECT 'businessnumber', businessnumber::text FROM old_defaults -UNION -SELECT 'version', '1.2.0'::text -UNION -SELECT 'curr', curr::text FROM old_defaults -UNION -SELECT 'closedto', to_char(closedto, 'YYYY-MM-DD') FROM old_defaults -UNION -SELECT 'revtrans', (CASE WHEN revtrans IS NULL THEN NULL - WHEN revtrans THEN '1' - ELSE '0' END) FROM old_defaults -UNION -SELECT 'ponumber', ponumber::text FROM old_defaults -UNION -SELECT 'sqnumber', sqnumber::text FROM old_defaults -UNION -SELECT 'rfqnumber', rfqnumber::text FROM old_defaults -UNION -SELECT 'audittrail', (CASE WHEN audittrail IS NULL THEN NULL - WHEN audittrail THEN '1' - ELSE '0' END) FROM old_defaults -UNION -SELECT 'vinumber', vinumber::text FROM old_defaults -UNION -SELECT 'employeenumber', employeenumber::text FROM old_defaults -UNION -SELECT 'partnumber', partnumber::text FROM old_defaults -UNION -SELECT 'customernumber', customernumber::text FROM old_defaults -UNION -SELECT 'vendornumber', vendornumber::text FROM old_defaults -UNION -SELECT 'glnumber', glnumber::text FROM old_defaults -UNION -SELECT 'projectnumber', projectnumber::text FROM old_defaults -UNION -SELECT 'appname', 'LedgerSMB'::text; - -DROP TABLE old_defaults; - -CREATE OR REPLACE FUNCTION del_exchangerate() RETURNS TRIGGER AS ' - -declare - t_transdate date; - t_curr char(3); - t_id int; - d_curr text; - -begin - - select into d_curr substr(value,1,3) from defaults where setting_key = ''curr''; - - if TG_RELNAME = ''ar'' then - select into t_curr, t_transdate curr, transdate from ar where id = old.id; - end if; - if TG_RELNAME = ''ap'' then - select into t_curr, t_transdate curr, transdate from ap where id = old.id; - end if; - if TG_RELNAME = ''oe'' then - select into t_curr, t_transdate curr, transdate from oe where id = old.id; - end if; - - if d_curr != t_curr then - - select into t_id a.id from acc_trans ac - join ar a on (a.id = ac.trans_id) - where a.curr = t_curr - and ac.transdate = t_transdate - - except select a.id from ar a where a.id = old.id - - union - - select a.id from acc_trans ac - join ap a on (a.id = ac.trans_id) - where a.curr = t_curr - and ac.transdate = t_transdate - - except select a.id from ap a where a.id = old.id - - union - - select o.id from oe o - where o.curr = t_curr - and o.transdate = t_transdate - - except select o.id from oe o where o.id = old.id; - - if not found then - delete from exchangerate where curr = t_curr and transdate = t_transdate; - end if; - end if; -return old; - -end; -' language 'plpgsql'; - -CREATE OR REPLACE FUNCTION add_custom_field (VARCHAR, VARCHAR, VARCHAR) -RETURNS BOOL AS -'BEGIN - EXECUTE ''SELECT TABLE_ID FROM custom_table_catalog - WHERE extends = '''''' || table_name || '''''' ''; - IF NOT FOUND THEN - BEGIN - INSERT INTO custom_table_catalog (extends) - VALUES (table_name); - EXECUTE ''CREATE TABLE custom_''||table_name || - '' (row_id INT PRIMARY KEY)''; - EXCEPTION WHEN duplicate_table THEN - -- do nothing - END; - END IF; - EXECUTE ''INSERT INTO custom_field_catalog (field_name, table_id) - VALUES ( '''''' || new_field_name ||'''''', (SELECT table_id FROM custom_table_catalog - WHERE extends = ''''''|| table_name || ''''''))''; - EXECUTE ''ALTER TABLE custom_''||table_name || '' ADD COLUMN '' - || new_field_name || '' '' || field_datatype; - RETURN TRUE; -END; -' LANGUAGE PLPGSQL; - -COMMIT; diff --git a/sql/legacy/Pg-upgrade-2.6.2-2.6.3.sql b/sql/legacy/Pg-upgrade-2.6.2-2.6.3.sql deleted file mode 100755 index 2abfe627..00000000 --- a/sql/legacy/Pg-upgrade-2.6.2-2.6.3.sql +++ /dev/null @@ -1,10 +0,0 @@ --- -delete from status where formname = 'receipt'; -delete from status where formname = 'check'; -create table statu (trans_id int, formname text, printed bool default 'f', emailed bool default 'f', spoolfile text); -insert into statu select trans_id, formname, printed, emailed, spoolfile from status; -drop table status; -alter table statu rename to status; -create index status_trans_id_key on status (trans_id); --- -update defaults set version = '2.6.3'; diff --git a/sql/legacy/Pg-upgrade-2.6.3-2.6.4.sql b/sql/legacy/Pg-upgrade-2.6.3-2.6.4.sql deleted file mode 100755 index 8456366c..00000000 --- a/sql/legacy/Pg-upgrade-2.6.3-2.6.4.sql +++ /dev/null @@ -1,6 +0,0 @@ --- -alter table orderitems add notes text; -alter table invoice add notes text; -alter table acc_trans add invoice_id int; --- -update defaults set version = '2.6.4'; diff --git a/sql/legacy/Pg-upgrade-2.6.4-2.6.7.sql b/sql/legacy/Pg-upgrade-2.6.4-2.6.7.sql deleted file mode 100755 index 41c14a24..00000000 --- a/sql/legacy/Pg-upgrade-2.6.4-2.6.7.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -alter table defaults add projectnumber text; --- -update defaults set version = '2.6.7'; diff --git a/sql/legacy/Pg-upgrade-2.6.7-2.6.12.sql b/sql/legacy/Pg-upgrade-2.6.7-2.6.12.sql deleted file mode 100755 index 2336f3da..00000000 --- a/sql/legacy/Pg-upgrade-2.6.7-2.6.12.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -alter table tax add validto date; --- -update defaults set version = '2.6.12'; diff --git a/sql/modules/Payment.sql b/sql/modules/Payment.sql index b3ba24a7..e8c0375b 100644 --- a/sql/modules/Payment.sql +++ b/sql/modules/Payment.sql @@ -223,8 +223,8 @@ BEGIN IF in_batch_id IS NULL THEN t_voucher_id := NULL; ELSE - INSERT INTO voucher (batch_id, trans_id) - values (in_batch_id, in_transactions[1][1]); + INSERT INTO voucher (batch_id, batch_class, trans_id) + values (in_batch_id, 3, in_transactions[1][1]); t_voucher_id := currval('voucher_id_seq'); END IF; |