boogerlad/mj - Change NBGKNI25T2AKNWDH5Z6U6JDUHLQPNRL6GQFF5VS37OOHONSP4CKQC

update schema to be compatible with scraped data

Created by boogerlad on February 8, 2020

NBGKNI25T2AKNWDH5Z6U6JDUHLQPNRL6GQFF5VS37OOHONSP4CKQC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 63 [4.17]

∅:D[2.6341] → [3.1481:1540]

B:BD[3.1481] → [3.1481:1540]

create type strain as enum('indica', 'sativa', 'hybrid');

[2.6341]

[3.1540]

create type strain as enum('indica', 'sativa', 'hybrid', 'blend');

Replacement in initialize.sql at line 65 [4.17]

B:BD[3.1602] → [2.6342:6445]

create type measurement_unit as enum('ml', 'mg', 'g', 'capsule', 'sachet', 'piece', 'gummy', 'mint');

[3.1602]

[4.1670]

create type measurement_unit as enum('ml', 'mg', 'g', 'capsule', 'sachet', 'piece', 'gummy', 'mint', 'cookie');

Replacement in initialize.sql at line 73 [4.17]
B:BD[4.1935] → [2.6446:6483]
```
	display_name text not null unique,
```
[4.1935]
[3.1688]
```
	display_name text not null,
```
Replacement in initialize.sql at line 76 [4.17]
∅:D[3.1782] → [5.6150:6179]
∅:D[2.6553] → [5.6150:6179]
B:BD[5.6150] → [5.6150:6179]
```
	description text not null,
```
[2.6553]
[3.1783]
```
	description text,
```

Replacement in initialize.sql at line 80 [4.17]

B:BD[2.6584] → [2.6584:6880]

	terpenes text[] not null default '{}',--http://www.databasesoup.com/2015/01/tag-all-things-part-3.html I guess we'll deal with uniqueness and order in application layer or https://stackoverflow.com/a/22677978 ?? will need to do a good job normalizing though. how to search when order matters??

[2.6584]

[2.6880]

	terpenes text[] not null default '{}',--http://www.databasesoup.com/2015/01/tag-all-things-part-3.html I guess we'll deal with uniqueness and order in application layer or https://stackoverflow.com/a/22677978 ?? will need to do a good job normalizing though. how to search when order matters?? https://stackoverflow.com/questions/866465

Replacement in initialize.sql at line 97 [4.17]
B:BD[4.2792] → [2.7509:7530]
∅:D[6.349] → [7.145:174]
∅:D[2.7530] → [7.145:174]
B:BD[4.2822] → [7.145:174]
```
	portions smallint,
	quantity decimal not null,
```
[4.2792]
[2.7531]
```
	portions smallint check (portions > 1),
	quantity decimal not null check (quantity > 0),
	flavor citext,
```

Replacement in initialize.sql at line 102 [4.17]

B:BD[4.2925] → [2.7568:7768]

create unique index unique_variant_2 on variant (product, quantity) where portions is null;
create unique index unique_variant_3 on variant (product, portions, quantity) where portions is not null;

[4.2925]

[2.7768]

create unique index unique_variant_2 on variant (product, quantity) where portions is null and flavor is null;
create unique index unique_variant_3_portions on variant (product, portions, quantity) where portions is not null and flavor is null;
create unique index unique_variant_3_flavor on variant (product, quantity, flavor) where portions is null and flavor is not null;
create unique index unique_variant_4 on variant (product, portions, quantity, flavor) where portions is not null and flavor is not null;