From c02133a95f1fb95fcf00b86402d76b8f5b4f48f3 Mon Sep 17 00:00:00 2001 From: Stefan de Konink Date: Tue, 2 Sep 2008 02:41:10 +0200 Subject: [PATCH] If you want to run it for yourself, a user 0 is required. --- create.legacy.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/create.legacy.sql b/create.legacy.sql index 5c69a6c..65553d7 100644 --- a/create.legacy.sql +++ b/create.legacy.sql @@ -1,4 +1,5 @@ CREATE TABLE usernames (id serial, username varchar(255), password varchar(255)); +INSERT INTO usernames (id, username) VALUES (0, 'unknown'); CREATE TABLE nodes_legacy (id serial, x double, y double, username integer, timestamp timestamptz, foreign key(username) references usernames, visible boolean default true); CREATE TABLE node_tags (node integer, k varchar(255), v varchar(1024), primary key (node, k), foreign key(node) references nodes_legacy); CREATE TABLE relations(id serial, username integer, timestamp timestamptz, foreign key(username) references usernames, visible boolean default true); -- 2.11.4.GIT