boogerlad/mj - Change NJ233BBUD2WBHKNEWPO5JWQTECTGR5F43NYTSNOZ5J3K22U5C47QC

now that we lookup producer and brand through a list we maintain ourselves, update unique indicies to reflect that

Created by boogerlad on March 3, 2020

NJ233BBUD2WBHKNEWPO5JWQTECTGR5F43NYTSNOZ5J3K22U5C47QC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 74 [5.17]

B:BD[3.213] → [4.6183:6341]

create type product_type as enum ('flower', 'preroll', 'oil', 'spray', 'capsule', 'cartridge', 'disposable', 'tea', 'gummy', 'mint', 'chocolate', 'cookie');

[3.213]

[2.0]

create type product_type as enum ('flower', 'preroll', 'oil', 'spray', 'capsule', 'cartridge', 'disposable', 'tea', 'gummy', 'mint', 'chocolate', 'baked');

Replacement in initialize.sql at line 80 [5.17]

B:BD[5.1719] → [6.80:271]

∅:D[3.6032] → [5.1778:1808]

∅:D[6.271] → [5.1778:1808]

B:BD[5.1778] → [5.1778:1808]

B:BD[5.1808] → [7.1670:1687]

∅:D[7.1687] → [5.1904:1935]

B:BD[5.1904] → [5.1904:1935]

	joined_brand citext not null,--should probably strip out spaces. higher probability to match?
	joined_name citext not null,--should probably strip out spaces. higher probability to match?
	type product_type not null,
	producer text,
	display_brand text not null,

[5.1719]

[2.183]

	producer text,--null means unknown
	brand text,--null means producer is the brand

Insertion in initialize.sql at line 83 [5.17]

[2.213]

[7.1688]

	joined_name citext not null,
	type product_type not null,

Replacement in initialize.sql at line 93 [5.17]
∅:D[8.78] → [5.2540:2608]
∅:D[7.1959] → [5.2540:2608]
∅:D[4.7012] → [5.2540:2608]
B:BD[5.2540] → [5.2540:2608]
```
	constraint unique_product unique(joined_brand, joined_name, type)
```
[4.7012]
[5.2608]
```
	check (brand is not null or producer is not null)
```

Insertion in initialize.sql at line 95 [5.17]

[5.2612]

[4.7013]

create unique index unique_product_3p on product (producer, joined_name, type) where brand is null;
create unique index unique_product_3b on product (brand, joined_name, type) where producer is null;
create unique index unique_product_4 on product (producer, brand, joined_name, type) where brand is not null and producer is not null;