Op verzoek van Roeland:
CREATE TABLE "sys"."nodes_legacy" (
"id" int NOT NULL DEFAULT next value for "sys"."s_nodes",
"long" double,
"lat" double,
"uid" int,
"timestamp" timestamptz(7),
"zcurve" bigint,
CONSTRAINT "pk_nodes_id" PRIMARY KEY ("id")
);
CREATE TABLE "sys"."node_tags" (
"node" int,
"k" varchar(255),
"v" varchar(1024)
);
CREATE TABLE "sys"."ways" (
"id" int NOT NULL DEFAULT next value for "sys"."s_ways",
"uid" int,
"timestamp" timestamptz(7),
CONSTRAINT "pk_ways_id" PRIMARY KEY ("id")
);
CREATE TABLE "sys"."way_tags" (
"way" int,
"k" varchar(255),
"v" varchar(1024)
);
CREATE TABLE "sys"."way_nds" (
"way" int,
"idx" int,
"to_node" int
);
CREATE TABLE "sys"."relations" (
"id" int NOT NULL DEFAULT next value for "sys"."s_relations",
"uid" int,
"timestamp" timestamptz(7),
CONSTRAINT "pk_relations_id" PRIMARY KEY ("id")
);
CREATE TABLE "sys"."relation_members_node" (
"relation" int NOT NULL,
"idx" int NOT NULL,
"to_node" int,
"role" varchar(255),
CONSTRAINT "pk_relation_members_node" PRIMARY KEY ("relation",
"idx")
);
CREATE TABLE "sys"."relation_members_relation" (
"relation" int NOT NULL,
"idx" int NOT NULL,
"to_relation" int,
"role" varchar(255),
CONSTRAINT "pk_relation_members_relation" PRIMARY KEY
("relation", "idx")
);
CREATE TABLE "sys"."relation_members_way" (
"relation" int NOT NULL,
"idx" int NOT NULL,
"to_way" int,
"role" varchar(255),
CONSTRAINT "pk_relation_members_way" PRIMARY KEY ("relation",
"idx")
);
CREATE TABLE "sys"."relation_tags" (
"relation" int,
"k" varchar(255),
"v" varchar(1024)
);
_______________________________________________
Talk-nl mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/talk-nl
