libervia-pubsub: db/pubsub.sql annotate

annotate db/pubsub.sql @ 433:920440200570

PostgreSQL: don't use `regconfig` and `GENERATED` column anymore /!\ pgsql schema needs to be updated /!\ /!\ Minimal PostgreSQL required version is back to 9.5 /!\ `regconfig` is using system table, and `pg_upgrade` can't handle that, causing trouble when moving to a new major version of PostgreSQL. To work around this, the `data_fts_cfg` column type in `items` has been changed from `regconfig` to `text`. GENERATED column can't be used with type casting to `regconfig`, so the data_fts column is now generated with a trigger. As a result, the minimal requirement of PostgreSQL 12 is not necessary anymore.

author	Goffi <goffi@goffi.org>
date	Thu, 14 Jan 2021 17:59:23 +0100
parents	5a0ada3b61ca
children	b5e1e8d93dd4

rev	line source
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	1 CREATE TABLE entities (
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	2 entity_id serial PRIMARY KEY,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	3 jid text NOT NULL UNIQUE
87 f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	4 );
f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	5
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	6 CREATE TABLE nodes (
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	7 node_id serial PRIMARY KEY,
294 df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	8 node text NOT NULL,
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	9 pep text,
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	10 node_type text NOT NULL DEFAULT 'leaf'
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	11 CHECK (node_type IN ('leaf', 'collection')),
240 70c8bb90d75f added access_model to config, default to 'open' Goffi <goffi@goffi.org> parents: 206 diff changeset	12 access_model text NOT NULL DEFAULT 'open'
350 4d4575911060 sql (PostgreSQL): schema update: Goffi <goffi@goffi.org> parents: 329 diff changeset	13 CHECK (access_model IN ('open', 'presence', 'publisher-roster', 'whitelist', 'publish-only', 'self-publisher')),
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	14 persist_items boolean,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	15 deliver_payloads boolean NOT NULL DEFAULT TRUE,
403 1dc606612405 implemented experimental "consistent_publisher" option: Goffi <goffi@goffi.org> parents: 367 diff changeset	16 max_items integer NOT NULL DEFAULT 0
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	17 CHECK (max_items >= 0),
367 a772f7dac930 backend, storage(pgsql): creation/update date + serial ids: Goffi <goffi@goffi.org> parents: 360 diff changeset	18 serial_ids boolean NOT NULL DEFAULT FALSE,
403 1dc606612405 implemented experimental "consistent_publisher" option: Goffi <goffi@goffi.org> parents: 367 diff changeset	19 consistent_publisher boolean NOT NULL DEFAULT FALSE,
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	20 fts_language text NOT NULL DEFAULT 'generic',
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	21 send_last_published_item text NOT NULL DEFAULT 'on_sub'
260 f0cd02c032b3 publish model management Goffi <goffi@goffi.org> parents: 248 diff changeset	22 CHECK (send_last_published_item IN ('never', 'on_sub')),
f0cd02c032b3 publish model management Goffi <goffi@goffi.org> parents: 248 diff changeset	23 publish_model text NOT NULL DEFAULT 'publishers'
359 1d93f94feee3 psql (schema): fixed forgotten comma Goffi <goffi@goffi.org> parents: 350 diff changeset	24 CHECK (publish_model IN ('publishers', 'subscribers', 'open')),
360 6350622d9eb9 psql (schema): fixed bad semi-colon Goffi <goffi@goffi.org> parents: 359 diff changeset	25 schema xml
87 f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	26 );
f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	27
294 df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	28 /* we need 2 partial indexes to manage NULL value for PEP */
df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	29 CREATE UNIQUE INDEX nodes_node_pep_key_not_null ON nodes(node, pep) WHERE pep IS NOT NULL;
df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	30 CREATE UNIQUE INDEX nodes_node_pep_key_null ON nodes(node) WHERE pep IS NULL;
df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	31
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	32 INSERT INTO nodes (node, node_type) values ('', 'collection');
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	33
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	34 CREATE TABLE affiliations (
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	35 affiliation_id serial PRIMARY KEY,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	36 entity_id integer NOT NULL REFERENCES entities ON DELETE CASCADE,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	37 node_id integer NOT NULL references nodes ON DELETE CASCADE,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	38 affiliation text NOT NULL
329 98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	39 CHECK (affiliation IN ('outcast', 'member', 'publisher', 'owner')),
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	40 UNIQUE (entity_id, node_id)
87 f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	41 );
f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	42
243 42048e37699e added experimental roster access_model (use remote_roster) Goffi <goffi@goffi.org> parents: 240 diff changeset	43 CREATE TABLE node_groups_authorized (
42048e37699e added experimental roster access_model (use remote_roster) Goffi <goffi@goffi.org> parents: 240 diff changeset	44 node_groups_authorized_id serial PRIMARY KEY,
42048e37699e added experimental roster access_model (use remote_roster) Goffi <goffi@goffi.org> parents: 240 diff changeset	45 node_id integer NOT NULL references nodes ON DELETE CASCADE,
42048e37699e added experimental roster access_model (use remote_roster) Goffi <goffi@goffi.org> parents: 240 diff changeset	46 groupname text NOT NULL,
42048e37699e added experimental roster access_model (use remote_roster) Goffi <goffi@goffi.org> parents: 240 diff changeset	47 UNIQUE (node_id,groupname)
42048e37699e added experimental roster access_model (use remote_roster) Goffi <goffi@goffi.org> parents: 240 diff changeset	48 );
42048e37699e added experimental roster access_model (use remote_roster) Goffi <goffi@goffi.org> parents: 240 diff changeset	49
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	50 CREATE TABLE subscriptions (
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	51 subscription_id serial PRIMARY KEY,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	52 entity_id integer NOT NULL REFERENCES entities ON DELETE CASCADE,
87 f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	53 resource text,
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	54 node_id integer NOT NULL REFERENCES nodes ON delete CASCADE,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	55 state text NOT NULL DEFAULT 'subscribed'
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	56 CHECK (state IN ('subscribed', 'pending', 'unconfigured')),
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	57 subscription_type text
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	58 CHECK (subscription_type IN (NULL, 'items', 'nodes')),
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	59 subscription_depth text
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	60 CHECK (subscription_depth IN (NULL, '1', 'all')),
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	61 UNIQUE (entity_id, resource, node_id));
87 f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	62
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	63 CREATE TABLE items (
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	64 item_id serial PRIMARY KEY,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	65 node_id integer NOT NULL REFERENCES nodes ON DELETE CASCADE,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	66 item text NOT NULL,
274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	67 publisher text NOT NULL,
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	68 data xml NOT NULL,
433 920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	69 data_fts tsvector,
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	70 data_fts_cfg text NOT NULL DEFAULT 'simple',
248 50f6ee966da8 item are gotten according to item's access model in getItems Goffi <goffi@goffi.org> parents: 244 diff changeset	71 access_model text NOT NULL DEFAULT 'open'
329 98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	72 CHECK (access_model IN ('open', 'publisher-roster', 'whitelist')),
367 a772f7dac930 backend, storage(pgsql): creation/update date + serial ids: Goffi <goffi@goffi.org> parents: 360 diff changeset	73 created timestamp with time zone NOT NULL DEFAULT now(),
a772f7dac930 backend, storage(pgsql): creation/update date + serial ids: Goffi <goffi@goffi.org> parents: 360 diff changeset	74 updated timestamp with time zone NOT NULL DEFAULT now(),
206 274a45d2a5ab Implement root collection that includes all leaf nodes. Ralph Meijer <ralphm@ik.nu> parents: 188 diff changeset	75 UNIQUE (node_id, item)
87 f766e46dce0f Initial revision Ralph Meijer <ralphm@ik.nu> parents: diff changeset	76 );
244 3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	77
3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	78 CREATE TABLE item_groups_authorized (
3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	79 item_groups_authorized_id serial PRIMARY KEY,
3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	80 item_id integer NOT NULL references items ON DELETE CASCADE,
3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	81 groupname text NOT NULL,
3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	82 UNIQUE (item_id,groupname)
3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	83 );
3ecc94407e36 item access_model (not finished) Goffi <goffi@goffi.org> parents: 243 diff changeset	84
329 98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	85 CREATE TABLE item_jids_authorized (
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	86 item_jids_authorized_id serial PRIMARY KEY,
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	87 item_id integer NOT NULL references items ON DELETE CASCADE,
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	88 jid text NOT NULL,
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	89 UNIQUE (item_id,jid)
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	90 );
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	91
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	92 CREATE TABLE item_languages (
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	93 item_languages_id serial PRIMARY KEY,
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	94 item_id integer NOT NULL references items ON DELETE CASCADE,
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	95 language text NOT NULL,
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	96 UNIQUE (item_id,language)
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	97 );
98409ef42c94 PostGreSQL: schema update: Goffi <goffi@goffi.org> parents: 301 diff changeset	98
301 05c875a13a62 categories are now stored in a dedicated table if item contain an atom entry: Goffi <goffi@goffi.org> parents: 295 diff changeset	99 CREATE TABLE item_categories (
05c875a13a62 categories are now stored in a dedicated table if item contain an atom entry: Goffi <goffi@goffi.org> parents: 295 diff changeset	100 item_categories_id serial PRIMARY KEY,
05c875a13a62 categories are now stored in a dedicated table if item contain an atom entry: Goffi <goffi@goffi.org> parents: 295 diff changeset	101 item_id integer NOT NULL references items ON DELETE CASCADE,
05c875a13a62 categories are now stored in a dedicated table if item contain an atom entry: Goffi <goffi@goffi.org> parents: 295 diff changeset	102 category text NOT NULL,
05c875a13a62 categories are now stored in a dedicated table if item contain an atom entry: Goffi <goffi@goffi.org> parents: 295 diff changeset	103 UNIQUE (item_id,category)
05c875a13a62 categories are now stored in a dedicated table if item contain an atom entry: Goffi <goffi@goffi.org> parents: 295 diff changeset	104 );
05c875a13a62 categories are now stored in a dedicated table if item contain an atom entry: Goffi <goffi@goffi.org> parents: 295 diff changeset	105
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	106 /* Full Text Search */
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	107 CREATE INDEX items_data_fts ON items USING GIN (data_fts);
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	108
433 920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	109 CREATE OR REPLACE FUNCTION update_data_fts_cfg() RETURNS TRIGGER AS
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	110 $$
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	111 BEGIN
433 920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	112 UPDATE items SET data_fts_cfg=replace(new.fts_language, 'generic', 'simple')
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	113 WHERE items.node_id=new.node_id
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	114 AND NOT EXISTS(SELECT FROM item_languages AS lang WHERE lang.item_id=items.item_id);
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	115 RETURN new;
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	116 END;
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	117 $$
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	118 language plpgsql;
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	119
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	120 CREATE TRIGGER nodes_fts_language_update
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	121 AFTER UPDATE OF fts_language ON nodes
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	122 FOR EACH ROW
433 920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	123 EXECUTE PROCEDURE update_data_fts_cfg();
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	124
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	125 CREATE FUNCTION update_data_fts() RETURNS TRIGGER AS
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	126 $$
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	127 BEGIN
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	128 new.data_fts=to_tsvector(new.data_fts_cfg::regconfig, new.data::text);
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	129 RETURN new;
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	130 END
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	131 $$
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	132 language plpgsql;
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	133
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	134 CREATE TRIGGER items_fts_tsvector_update
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	135 BEFORE INSERT OR UPDATE OF data_fts_cfg,data ON items
920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	136 FOR EACH ROW
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	137 EXECUTE PROCEDURE update_data_fts();
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	138
433 920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	139
294 df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	140 CREATE TABLE metadata (
430 5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	141 key text PRIMARY KEY,
5a0ada3b61ca Full-Text Search implementation: Goffi <goffi@goffi.org> parents: 403 diff changeset	142 value text
294 df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	143 );
df1edebb0466 PEP implementation, draft (huge patch sorry): Goffi <goffi@goffi.org> parents: 260 diff changeset	144
433 920440200570 PostgreSQL: don't use `regconfig` and `GENERATED` column anymore Goffi <goffi@goffi.org> parents: 430 diff changeset	145 INSERT INTO metadata VALUES ('version', '7');

Mercurial > libervia-pubsub

annotate db/pubsub.sql @ 433:920440200570