Aaron
63285f61aa
Some checks failed
Vulhub Format Check and Lint / format-check (push) Has been cancelled
Vulhub Format Check and Lint / markdown-check (push) Has been cancelled
Vulhub Docker Image CI / longtime-images-test (push) Has been cancelled
Vulhub Docker Image CI / images-test (push) Has been cancelled
28 lines
776 B
SQL
28 lines
776 B
SQL
-- ----------------------------
|
|
-- Table structure for user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."user";
|
|
CREATE TABLE "public"."user" (
|
|
"id" int4 NOT NULL,
|
|
"name" varchar(255) COLLATE "default" NOT NULL,
|
|
"score" int4 DEFAULT 0
|
|
)
|
|
WITH (OIDS=FALSE)
|
|
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of user
|
|
-- ----------------------------
|
|
INSERT INTO "public"."user" VALUES ('1', 'zhang', '50');
|
|
INSERT INTO "public"."user" VALUES ('2', 'wang', '90');
|
|
INSERT INTO "public"."user" VALUES ('3', 'hu', '68');
|
|
|
|
-- ----------------------------
|
|
-- Alter Sequences Owned By
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table user
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."user" ADD PRIMARY KEY ("id"); |