■

ORマッパークラス（スキーマ）を作成する
・・・lib/MyApp/Schema 配下のpmを削除して、スキーマ再作成

perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at "MyApp::Schema", {relationships => 1, debug => 1}, ["dbi:Pg:dbname=sandbox_nishino1;host=st-db.shanon.co.jp;port=5432","nishino",]'

SQLの追加

[nishino@nishino-dev sql]$ cat create_table.sql
DROP TABLE dump_history;
DROP SEQUENCE dump_history_id_seq;

CREATE TABLE dump_history(
id integer NOT NULL PRIMARY KEY,
"disable" integer DEFAULT 0 NOT NULL,
memo text
);

• • ALTER TABLE ONLY dump_history
  • ADD CONSTRAINT dump_history_pkey PRIMARY KEY (id);

CREATE SEQUENCE dump_history_id_seq
START WITH 1
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;

ALTER TABLE dump_history ALTER COLUMN id SET DEFAULT nextval('dump_history_id_seq'::regclass);

INSERT INTO dump_history ("disable", memo) VALUES(0,'aaa');
INSERT INTO dump_history ("disable", memo) VALUES(0,'bbb');
INSERT INTO dump_history ("disable", memo) VALUES(0,'ccc');
INSERT INTO dump_history ("disable", memo) VALUES(0,'ddd');