INSERT INTO tbl_credinfo SELECT new.id, strftime('%Y-%m-%d',new.dayofpayprimary,'+1 months'),'6300','5900','860','4000' FROM new;

CREATE TABLE "new" ("id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL , "dayofpayprimary" TEXT);
CREATE TABLE "tbl_credinfo" ("id" INTEGER, "srok" TEXT, "t1" TEXT, "t2" TEXT, "t3" TEXT, "t4" TEXT);
CREATE TRIGGER "credit_trigger" AFTER INSERT ON new 
BEGIN 
INSERT INTO tbl_credinfo SELECT new.id, strftime('%Y-%m-%d',new.dayofpayprimary,'+1 months'),'6300','5900','860','4000' FROM new WHERE new.id = last_insert_rowid(); 
END;
INSERT INTO new ("dayofpayprimary") VALUES ('2001-10-19');
INSERT INTO new ("dayofpayprimary") VALUES ('2002-11-19');
INSERT INTO new ("dayofpayprimary") VALUES ('2008-08-10');
INSERT INTO new ("dayofpayprimary") VALUES ('2007-02-08');

CREATE TRIGGER update_customer_address UPDATE OF address ON customers 
  BEGIN
    UPDATE orders SET address = new.address WHERE customer_name = old.name;
  END;