ALTER TABLE "public"."base_contract"
ADD COLUMN "isrejected" int2 DEFAULT 0 NOT NULL;

ALTER TABLE "public"."base_contract"
ADD COLUMN "userid" int8 DEFAULT 0 NOT NULL;

ALTER TABLE "public"."base_user"
ADD COLUMN "telphone" varchar(20) DEFAULT ''::character varying NOT NULL;

INSERT INTO "base_role" VALUES ('21', '代理商', '只能查看對屬于自己的所有合同');

update base_contract a set userid=(SELECT b.userid from base_user b where a.username=b.username LIMIT 1)

delete from base_menu;

BEGIN;
INSERT INTO "base_menu" VALUES ('1', 'infoMenu', null, '公用菜單', null, null, null, null, 'Y', '0');
INSERT INTO "base_menu" VALUES ('2', 'ediUser', 'infoMenu', '修改個人資料', 'Note', 'ediUser.jsp', 'top', '2', 'N', '0');
COMMIT;