table.rb

  DB.create_table :journals do
    primary_key :id
    string :title, :size=>1024, :index=>true
  
    string :issn, :size=>8, :index=>true
    string :e_issn, :size=>8, :index=>true

    text :journal_url

    text :publisher
    text :abbreviation

    text :cjdb_note
    text :local_note
  end

I, [2011-05-26T15:58:41.112082 #35894] INFO -- : (0.000132s) PRAGMA foreign_keys = 1
I, [2011-05-26T15:58:41.112291 #35894] INFO -- : (0.000072s) PRAGMA table_info('journals')
E, [2011-05-26T15:58:41.112647 #35894] ERROR -- : SQLite3::SQLException: no such table: journals: SELECT * FROM journals LIMIT 1
I, [2011-05-26T15:58:41.113574 #35894] INFO -- : (0.000039s) PRAGMA table_info('coverages')
E, [2011-05-26T15:58:41.113848 #35894] ERROR -- : SQLite3::SQLException: no such table: coverages: SELECT * FROM coverages LIMIT 1
=> true

setup_database
I, [2011-05-26T15:58:56.008205 #35894] INFO -- : (0.000643s) CREATE TABLE journals (id integer PRIMARY KEY AUTOINCREMENT, title varchar(1024), issn string(8), e_issn string(8), journal_url varchar(255), publisher varchar(255), abbreviation varchar(255), cjdb_note varchar(255), local_note varchar(255))
I, [2011-05-26T15:58:56.008702 #35894] INFO -- : (0.000200s) CREATE INDEX journals_title_index ON journals (title)
I, [2011-05-26T15:58:56.009064 #35894] INFO -- : (0.000179s) CREATE INDEX journals_issn_index ON journals (issn)
I, [2011-05-26T15:58:56.009416 #35894] INFO -- : (0.000172s) CREATE INDEX journals_e_issn_index ON journals (e_issn)

CREATE TABLE journals (id integer PRIMARY KEY AUTOINCREMENT, title varchar(1024), issn string(8), e_issn string(8), journal_url varchar(255), publisher varchar(255), abbreviation varchar(255), cjdb_note varchar(255), local_note varchar(255));

INSERT INTO journals (id, issn) VALUES (2, "00005678");

select * from journals; 2||5678||||||