sic_1987.rb in earth-1.0.0

- old
+ new

@@ -1,6 +1,23 @@
+require 'earth/model'
+
+require 'earth/industry/naics_2002'
+require 'earth/industry/naics_2002_sic_1987_concordance'
+
 class Sic1987 < ActiveRecord::Base
+  extend Earth::Model
+
+  TABLE_STRUCTURE = <<-EOS
+
+CREATE TABLE sic_1987
+  (
+     code        CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
+     description CHARACTER VARYING(255)
+  );
+
+EOS
+
   self.primary_key = "code"
   self.table_name = "sic_1987"
   
   has_many :naics_2002_sic_1987_concordances, :foreign_key => :sic_1987_code
   has_many :naics_2002, :through => :naics_2002_sic_1987_concordances
@@ -8,8 +25,6 @@
   # for data import
   def self.format_description(description)
     (desc = description.match /^(.+?) \(/) ? desc.captures.first : description
   end
   
-  col :code
-  col :description
 end