aboutsummaryrefslogblamecommitdiffstats
path: root/vendor/sabre/dav/examples/sql/pgsql.users.sql
blob: 939c931d8c0e3577664e88334e8f57663341f4a1 (plain) (tree)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15














                                               
CREATE TABLE users (
    id SERIAL NOT NULL,
    username VARCHAR(50),
    digesta1 VARCHAR(32),
    UNIQUE(username)
);

ALTER TABLE ONLY users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);

CREATE UNIQUE INDEX users_ukey
    ON users USING btree (username);

INSERT INTO users (username,digesta1) VALUES
('admin',  '87fd274b7b6c01e48d7c2f965da8ddf7');