test

ユーザー

CREATE TABLE "Users"
(
   "Code" integer NOT NULL, 
   "TimeStamp" timestamp without time zone NOT NULL DEFAULT '2000-01-01 00:00:00', 
   "Name" text, 
   "Bio" text, 
   "URL" text, 
   "Protect" boolean DEFAULT FALSE,
   CONSTRAINT users_pkey PRIMARY KEY ("Code")
) WITHOUT OIDS;
ALTER TABLE "Users" OWNER TO "user";

ステータス

CREATE TABLE "Status"
(
  "Code" integer NOT NULL,
  "UserCode" integer NOT NULL,
  "TimeStamp" timestamp without time zone NOT NULL,
  "Content" text,
  "AtUser" integer,
  "Client" text,
  CONSTRAINT "Status_pkey" PRIMARY KEY ("Code", "UserCode")
) 
WITHOUT OIDS;
ALTER TABLE "Status" OWNER TO "user";