- 精华
- 阅读权限
- 70
- 好友
- 相册
- 分享
- 听众
- 收听
- 注册时间
- 2011-6-10
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
发表于 2023-7-18 21:34:31
|
显示全部楼层
本帖最后由 xiaohaotest123 于 2023-7-18 21:37 编辑
魔法上网搜pgadmin,用这个连接数据库改表结构,N11有BUG
非要用N11,右键把表导出为create table语句,添加2L那几个字段,删表重新执行
送佛送到西,老外帖子里面找来的,自己改!
- DROP TABLE IF EXISTS "player_room_container";
- CREATE TABLE "player_room_container" (
- "id" int4 NOT NULL,
- "item_id" int4 NOT NULL,
- "durability" int4 NOT NULL,
- "maker" text COLLATE "default" DEFAULT ''::character varying,
- "identify" int2 DEFAULT 1,
- "embedded_amount" int4 DEFAULT 0,
- "embedded_id1" int4 DEFAULT '-1'::integer,
- "create_time" int4 DEFAULT 1,
- "due_date" int4 DEFAULT 0,
- "container_index" int4 DEFAULT '-1'::integer,
- "strengthen" int4 DEFAULT 0,
- "cur_maxdurability" int4 DEFAULT 0,
- "bind" int4 DEFAULT 0,
- "account_id" int4 NOT NULL,
- "loc" int4 NOT NULL,
- "witchcraft" int4 DEFAULT 0,
- "quality" int2 DEFAULT 0,
- "plus_parameter" int8 DEFAULT 0,
- "color" int8 DEFAULT 0,
- "item_level" int4 DEFAULT 1,
- "item_exp" int4 DEFAULT 0,
- "embedded_level1" int4 DEFAULT 0,
- "embedded_exp1" int4 DEFAULT 0,
- "combo_id1" int4 DEFAULT 0,
- "combo_plusrate1" int4 DEFAULT 0,
- "combo_id2" int4 DEFAULT 0,
- "combo_plusrate2" int4 DEFAULT 0,
- "combo_id3" int4 DEFAULT 0,
- "combo_plusrate3" int4 DEFAULT 0,
- "combo_id4" int4 DEFAULT 0,
- "combo_plusrate4" int4 DEFAULT 0,
- "embedded_comboid1" int4 DEFAULT 0,
- "embedded_comboid2" int4 DEFAULT 0,
- "extra1" int4 DEFAULT 0,
- "extra2" int4 DEFAULT 0,
- "extra3" int4 DEFAULT 0,
- "extra4" int4 DEFAULT 0,
- "extra5" int4 DEFAULT 0,
- "extra6" int4 DEFAULT 0,
- "extra7" int4 DEFAULT 0,
- "bind_after_combine" int4 DEFAULT 0,
- "come_from" int4 DEFAULT 0,
- "locked" int4 DEFAULT 0,
- "param1" int4 DEFAULT 0,
- "param2" int4 DEFAULT 0,
- "combo_id5" int4 DEFAULT 0,
- "combo_plusrate5" int4 DEFAULT 0,
- "combo_id6" int4 DEFAULT 0,
- "combo_plusrate6" int4 DEFAULT 0,
- "combo_id7" int4 DEFAULT 0,
- "combo_plusrate7" int4 DEFAULT 0,
- "combo_id8" int4 DEFAULT 0,
- "combo_plusrate8" int4 DEFAULT 0
- )
- WITH (OIDS=FALSE)
- ;
复制代码
|
|