boogerlad/mj - Change 5RSETDN4QCQLU7Z55EFXSW27CBEW6HD2MVD2MKB6WDBXIKXFHKNQC

go with default naming for constraints / indicies except for unique partial indicies. also, store_time replace partial index with full index, but constraint not empty on the field instead

Created by boogerlad on March 18, 2020

5RSETDN4QCQLU7Z55EFXSW27CBEW6HD2MVD2MKB6WDBXIKXFHKNQC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 66 [5.17]
∅:D[3.171] → [4.158:198]
∅:D[2.219] → [4.158:198]
B:BD[4.158] → [4.158:198]
```
	constraint online_or_physical check (
```
[2.219]
[2.220]
```
	check (
```

Replacement in initialize.sql at line 71 [5.17]

B:BD[6.407] → [4.459:1015]

create unique index unique_store_3 on store (name, region, country) where address is null and address2 is null and city is null and postal_code is null;
create unique index unique_store_6 on store (name, address, city, region, country, postal_code) where address is not null and address2 is null and city is not null and postal_code is not null;
create unique index unique_store_7 on store (name, address, address2, city, region, country, postal_code) where address is not null and address2 is not null and city is not null and postal_code is not null;

[6.407]

[6.504]

create unique index upi_store_3 on store (name, region, country) where address is null and address2 is null and city is null and postal_code is null;
create unique index upi_store_6 on store (name, address, city, region, country, postal_code) where address is not null and address2 is null and city is not null and postal_code is not null;
create unique index upi_store_7 on store (name, address, address2, city, region, country, postal_code) where address is not null and address2 is not null and city is not null and postal_code is not null;

Replacement in initialize.sql at line 79 [5.17]
B:BD[7.5370] → [2.639:692]
```
	constraint unique_store_tax unique(store_id, name)
```
[7.5370]
[5.528]
```
	unique(store_id, name)
```

Replacement in initialize.sql at line 84 [5.17]

∅:D[2.793] → [7.5421:5699]

B:BD[6.886] → [7.5421:5699]

B:BD[7.5699] → [2.794:873]

	open int4range not null,--number of minutes in a week. possible to use int2range instead but need to be user defined. lazy and edge cases... input should be [,) in case someone puts as end and start for two separate entries, won't collide https://stackoverflow.com/a/27971136
	exclude using gist (store_id with =, open with &&) where (not isempty(open))

[2.793]

[5.917]

	open int4range not null check (not isempty(open)),--number of minutes in a week. possible to use int2range instead but need to be user defined. lazy and edge cases... input should be [,) in case someone puts as end and start for two separate entries, won't collide https://stackoverflow.com/a/27971136
	exclude using gist (store_id with =, open with &&)

Replacement in initialize.sql at line 93 [5.17]
B:BD[7.6021] → [2.997:1051]
```
	constraint unique_store_image unique(store_id, url)
```
[7.6021]
[7.6072]
```
	unique(store_id, url)
```

Replacement in initialize.sql at line 120 [5.17]

B:BD[5.2612] → [8.359:697]

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;

[5.2612]

[7.7013]

create unique index upi_product_3p on product (producer, joined_name, type) where brand is null;
create unique index upi_product_3b on product (brand, joined_name, type) where producer is null;
create unique index upi_product_4 on product (producer, brand, joined_name, type) where brand is not null and producer is not null;

Replacement in initialize.sql at line 131 [5.17]

B:BD[7.7441] → [2.1347:1413]

	constraint unique_product_image unique(product_id, destination)

[7.7441]

[7.7504]

	unique(product_id, destination)

Replacement in initialize.sql at line 141 [5.17]

B:BD[5.2925] → [2.1577:2105]

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

[5.2925]

[7.7768]

create unique index upi_variant_2 on variant (product_id, quantity) where portions is null and flavor is null;
create unique index upi_variant_3_portions on variant (product_id, portions, quantity) where portions is not null and flavor is null;
create unique index upi_variant_3_flavor on variant (product_id, quantity, flavor) where portions is null and flavor is not null;
create unique index upi_variant_4 on variant (product_id, portions, quantity, flavor) where portions is not null and flavor is not null;

Replacement in initialize.sql at line 149 [5.17]
B:BD[7.7915] → [2.2219:2283]
```
	constraint unique_variant_identifier unique(variant_id, gtin)
```
[7.7915]
[7.7976]
```
	unique(variant_id, gtin)
```
Replacement in initialize.sql at line 161 [5.17]
B:BD[7.8302] → [2.2452:2512]
```
	constraint unique_menu_item unique(variant_id, store_id),
```
[7.8302]
[9.105]
```
	unique(variant_id, store_id),
```

Replacement in initialize.sql at line 210 [5.17]

B:BD[6.3356] → [2.3474:3601]

create unique index unique_cart on cart (user_id, store_id) where status = 'active' or status = 'placed' or status = 'ready';

[6.3356]

[5.5860]

create unique index upi_cart on cart (user_id, store_id) where status = 'active' or status = 'placed' or status = 'ready';

Replacement in initialize.sql at line 216 [5.17]
B:BD[10.552] → [2.3772:3832]
```
	constraint unique_line_item unique(cart_id, menu_item_id)
```
[10.552]
[5.6196]
```
	unique(cart_id, menu_item_id)
```

go with default naming for constraints / indicies except for unique partial indicies. also, store_time replace partial index with full index, but constraint not empty on the field instead

Dependencies

In channels

Change contents

Replacement in initialize.sql at line 66 [5.17]

Replacement in initialize.sql at line 71 [5.17]

Replacement in initialize.sql at line 79 [5.17]

Replacement in initialize.sql at line 84 [5.17]

Replacement in initialize.sql at line 93 [5.17]

Replacement in initialize.sql at line 120 [5.17]

Replacement in initialize.sql at line 131 [5.17]

Replacement in initialize.sql at line 141 [5.17]

Replacement in initialize.sql at line 149 [5.17]

Replacement in initialize.sql at line 161 [5.17]

Replacement in initialize.sql at line 210 [5.17]

Replacement in initialize.sql at line 216 [5.17]