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

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||||||