12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- Database(s) structure
- =====================
- We have a single postgres instance on ``db`` container. ``tt-rss`` has its own
- database ``tt-rss`` (?). There will be another one for the app that keeps all
- together.
- feedati
- -------
- The db structure is, right now, the following:
- ======== ======= ======= =========
- Schema Name Type Owner
- ======== ======= ======= =========
- public users table postgres
- ======== ======= ======= =========
- The following statements create the db and the table:
- .. code:: sql
- CREATE DATABASE feedati WITH ENCODING=UTF8 OWNER=postgres;
- Then create the table:
- .. code:: sql
- CREATE EXTENSION IF NOT EXIST "uuid-ossp";
- CREATE TABLE users
- (
- uuid uuid NOT NULL DEFAULT uuid_generate_v1(),
- email text NOT NULL,
- pass_hash varchar(512) NOT NULL,
- CONSTRAINT users_pkey PRIMARY KEY (uuid)
- );
- Example table content:
- ====================================== ============= ==============================================================
- uuid email pass_hash
- ====================================== ============= ==============================================================
- b0abc42e-be71-11e8-a054-0242ac110002 me@domin.io $2a$10$8z35dF9/U6VJzpwDt2.Hm.QT78izNZI.IYSZFYCFQmBykEwWUNajq
- cff36cba-be71-11e8-a054-0242ac110002 luke@dom.it $2a$10$J7slNiXjQexMJXNgaEkeAeUtw7ERwNciM1KVMGwM3X.P/GUk8o7.C
- ====================================== ============= ==============================================================
|