store and stores boolean for type = 'physical'
Created by boogerlad on April 7, 2020
TQZJC7K5WOURWCLEFW3OP2SBWE3IGMCXBBLNVDKAPQS7NEHSLRJAC Dependencies
- [2]
5Y72WB5QDDV3MJ3FC2TODMYYLZ47CLIRAS6WTNYBFVO5KNOGJIHQC - [3]
72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC - [4]
E4HFJ4L4PAGV7R7EXVG2B2CWDGGW7XWU4D37VURZ66HZ3ILHCFUAC - [5]
63VXWIHIAKGK7J4VTNRUAG2V32N2QUSWFELB6GD34S54FGRWAPCQC - [6]
MM3HQWNEUZVOGQ3WWBTECBY6F47SN4U43I5UNDOAFWO3R7U5XPBAC - [7]
WYTMZJFYVKHR4QH7AV5JUNWXT6NAC5NNQNPZCQSDI6LGI7DVXFYAC - [8]
Q3A33UTWKXZATZKX3LQ42MUAWFTWDZDMNVMLKWGC3QF6L6HBLUQAC
In channels
main
Change contents
Replacement in initialize.sql at line 533 [4.17]
create or replace function get_store(_store_id integer) returns table(name text, url text, address citext, address2 citext, city citext, region citext, country citext, postal_code citext, longitude decimal, latitude decimal, timezone text, images json, times json) as $$create or replace function get_store(_store_id integer) returns table(name text, url text, address citext, address2 citext, city citext, region citext, country citext, postal_code citext, longitude decimal, latitude decimal, timezone text, images json, times json, physical boolean) as $$Replacement in initialize.sql at line 547 [4.17]
Replacement in server.js at line 425 [7.590]
let stores = (await pool.query('select distinct on(store_id) store_id as id, name, store_image.url from store left outer join store_image using (store_id)')).rows;let stores = (await pool.query(`select distinct on(store_id) store_id as id, name, type = 'physical', store_image.url from store left outer join store_image using (store_id)`)).rows;