7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
# File 'lib/free_zipcode_data/state_table.rb', line 7
def build
schema = " create table \#{tablename} (\n id integer not null primary key,\n country_id integer not null,\n abbr varchar(2) not null,\n name varchar(255)\n )\n SQL\n database.execute_batch(schema)\n\n ndx = <<-SQL\n CREATE UNIQUE INDEX \"main\".\"unique_state\"\n ON \#{tablename} (abbr, country_id COLLATE NOCASE ASC);\n SQL\n database.execute_batch(ndx)\n\n ndx = <<-SQL\n CREATE UNIQUE INDEX \"main\".\"state_name\"\n ON \#{tablename} (name COLLATE NOCASE ASC);\n SQL\n database.execute_batch(ndx)\nend\n"
|