当前位置：首页 > news >正文

怎么用wordpress做搜索网站百度搜索seo优化技巧

news 2026/4/8 6:30:28

怎么用wordpress做搜索网站,百度搜索seo优化技巧,网页设计的尺寸,宣讲家网站李慎明两学一做搭建postgresql-11.3，和客户端工具 1，准备对应的包，右键直接下一步安装完即可， 将postgresql设置为本地服务，方便启动， 2，用对应客户端软件连接，新建一个数据库controlDB 新建用户…

搭建postgresql-11.3，和客户端工具

1，准备对应的包，右键直接下一步安装完即可，将postgresql设置为本地服务，方便启动，

2，用对应客户端软件连接，新建一个数据库controlDB 新建用户lzkj 密码lzkj123 设为controlDB的所有者再新建目前总控上面用到的两张表


```sql
1、Controller_Users： //用户表
CREATE UNLOGGED TABLE public."Controller_Users"
("UserID" bigint NOT NULL,"UserName" character varying(128) NOT NULL,"PassWord" character varying(128) NOT NULL,"Nullity" character varying(1) NOT NULL,"MobilePhone" character varying(11) NOT NULL,"CreateTime" timestamp(6) with time zone,CONSTRAINT "Controller_Users_pkey" PRIMARY KEY ("UserID")
)
WITH (OIDS=FALSE
);
ALTER TABLE public."Controller_Users"OWNER TO test;
COMMENT ON TABLE public."Controller_Users"IS '总表';

第二张表
2、Owner//1表
CREATE UNLOGGED TABLE public."Owner"
("ID" bigint NOT NULL,"OwnerID" character varying(64) NOT NULL,"OwnerName" character varying(64) NOT NULL,"ServerIP" character varying(32) NOT NULL,"ServerPost" character varying(4) NOT NULL DEFAULT 80,"Telephone" character varying(11) NOT NULL,"CreationTime" character varying(64),CONSTRAINT "Owner_pkey" PRIMARY KEY ("ID")
)
WITH (OIDS=FALSE
);
ALTER TABLE public."Owner"OWNER TO test;
COMMENT ON TABLE public."Owner"IS '1表';
######
新建两个序列：
CREATE SEQUENCE public.controller_userid_seqINCREMENT 1MINVALUE 1MAXVALUE 999999START 4CACHE 1;
ALTER TABLE public.controller_userid_seqOWNER TO test;
第二个
CREATE SEQUENCE public.owner_id_seqINCREMENT 1MINVALUE 1MAXVALUE 999999START 1CACHE 1;
ALTER TABLE public.owner_id_seqOWNER TO test