This updates the username code, basically I for now take for granted

[handlerosm.git] / create.sql

CREATE TABLE usernames (id serial, username varchar(255), password varchar(255));
CREATE TABLE nodes (id serial, g geometry, username integer, timestamp timestamptz, foreign key(username) references usernames);
CREATE TABLE node_tags (node integer, k varchar(255), v varchar(1024), primary key (node, k), foreign key(node) references nodes);
CREATE TABLE relations(id serial, username integer, timestamp timestamptz, foreign key(username) references usernames);
CREATE TABLE members_node (relation integer, idx integer, to_node integer, role varchar(255), foreign key(relation) references relations, foreign key(to_node) references nodes, primary key(relation, idx));
CREATE TABLE members_relation (relation integer, idx integer, to_relation integer, role varchar(255), foreign key(relation) references relations, foreign key(to_relation) references relations, primary key(relation, idx));
CREATE TABLE relation_tags (relation integer, k varchar(255), v varchar(1024), foreign key(relation) references relations, primary key(relation, k));