18 lines
440 B
SQL
18 lines
440 B
SQL
CREATE TABLE properties (
|
|
id serial PRIMARY KEY,
|
|
property_key varchar(255) UNIQUE NOT NULL,
|
|
property_value integer NOT NULL
|
|
);
|
|
|
|
-- users
|
|
CREATE TABLE users (
|
|
id serial PRIMARY KEY,
|
|
phone_number_hash varchar(128) UNIQUE NOT NULL,
|
|
address varchar(128) NOT NULL,
|
|
whisper_identity varchar(255) NOT NULL
|
|
);
|
|
|
|
-- database version
|
|
INSERT INTO properties (property_key, property_value)
|
|
VALUES ('current-version', 1);
|