kenmirrors/grocy
1
0
Fork 0
mirror of https://github.com/grocy/grocy.git synced 2026-04-26 23:32:03 +00:00
Code Issues Projects Releases Wiki Activity
Files
master
grocy/migrations
History
Bernd Bestel 6210077984 Optimized controller / services structure
2026-04-20 22:46:47 +02:00
..
0001.sql
…
0002.sql
…
0003.sql
Reorganize project part 3
2018-04-12 21:13:38 +02:00
0004.sql
…
0005.sql
…
0006.sql
…
0007.sql
…
0008.sql
Remove unneeded ORDER BY as this maybe lead to problems like in #33
2018-07-31 17:42:07 +02:00
0009.sql
…
0010.sql
…
0011.sql
Reorganize project part 3
2018-04-12 21:13:38 +02:00
0012.sql
Don't use ORDER BY in VIEWS (as this is invalid SQL, why does this even work sometimes in SQLite) (fixes #33)
2018-08-03 08:26:59 +02:00
0013.sql
Reorganize project part 3
2018-04-12 21:13:38 +02:00
0014.sql
Reorganize project part 3
2018-04-12 21:13:38 +02:00
0015.sql
…
0016.sql
…
0017.sql
…
0018.sql
Reorganize project part 3
2018-04-12 21:13:38 +02:00
0019.sql
Reorganize project part 3
2018-04-12 21:13:38 +02:00
0020.sql
…
0021.sql
Added localization support
2018-04-16 19:11:32 +02:00
0022.sql
Finish API documentation and token auth (references #5)
2018-04-21 19:18:00 +02:00
0023.sql
…
0024.sql
…
0025.sql
…
0026.sql
Replace the single user (defined in /data/config.php) with a multi user management thing
2018-07-24 19:31:43 +02:00
0027.php
Optimized controller / services structure
2026-04-20 22:46:47 +02:00
0028.sql
Renamed habits to chores as this is more what it is about
2018-09-22 13:26:58 +02:00
0029.sql
Add something for product price tracking (references #22)
2018-07-26 20:27:38 +02:00
0030.sql
Properly pluralize everything (closes #19)
2018-07-27 19:39:34 +02:00
0031.php
Optimized controller / services structure
2026-04-20 22:46:47 +02:00
0032.sql
…
0033.sql
…
0034.sql
Implement that recipe ingredients can have arbitrary quantity units (references #32)
2018-08-09 17:24:04 +02:00
0035.sql
Renamed habits to chores as this is more what it is about
2018-09-22 13:26:58 +02:00
0036.sql
…
0037.sql
…
0038.sql
…
0039.sql
…
0040.sql
…
0041.sql
Added a quick mockup for equipment / instruction manuals (references #25)
2018-10-02 20:03:08 +02:00
0042.sql
…
0043.sql
…
0044.sql
Created API endpoints to undo battery charge cycles and chore executions (references #63)
2018-10-27 10:55:30 +02:00
0045.sql
Fixed a problem with newer SQLite versions (references and fixes #133)
2019-01-05 20:28:21 +01:00
0046.sql
…
0047.sql
…
0048.sql
Remove missing translation and improve database migration for #149
2019-01-26 14:12:18 +01:00
0049.sql
…
0050.sql
…
0051.sql
…
0052.sql
…
0053.sql
…
0054.sql
Display total cost of recipes based on last purchase prices (closes #128)
2019-03-03 16:33:48 +01:00
0055.sql
…
0056.sql
Added possibility to export the calendar in iCal format (closes #141)
2019-03-04 17:44:48 +01:00
0057.sql
…
0058.sql
Implemented that included recipes can have a serving amount (closes #163 and references #127)
2019-03-05 23:45:04 +01:00
0059.sql
Fixed a rounding regarding stock amount comparison when a (scaled) recipe needs a decimal amount (closes #164)
2019-03-06 19:05:32 +01:00
0060.sql
…
0061.sql
…
0062.sql
Implemented multiple/named shopping lists (closes #190)
2019-04-20 17:04:40 +02:00
0063.php
Optimized controller / services structure
2026-04-20 22:46:47 +02:00
0064.sql
Show more info in product card (closes #173)
2019-04-22 10:11:58 +02:00
0065.sql
…
0066.sql
…
0067.sql
Finished migration to use gettext (this now closes #161)
2019-05-02 20:20:18 +02:00
0068.sql
Added "variable amount" for recipe ingredients (closes #181)
2019-05-04 14:50:15 +02:00
0069.sql
…
0070.sql
…
0071.sql
…
0072.sql
…
0073.sql
…
0074.sql
Fixed nested recipes costs calculation (fixes #299)
2019-07-06 14:48:46 +02:00
0075.sql
…
0076.sql
Added a "consume this recipe"-button to the meal plan (and also a button to consume all recipes for a whole week) (closes #283)
2019-07-06 20:02:40 +02:00
0077.sql
…
0078.sql
…
0079.sql
First draft for printable location content sheets (references #341)
2019-08-10 16:34:29 +02:00
0080.sql
…
0081.sql
…
0082.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:21:01 +02:00
0083.sql
…
0084.sql
…
0085.sql
…
0086.sql
…
0087.sql
Implemented a price factor option for recipe ingredients (closes #295)
2019-09-19 21:30:24 +02:00
0088.sql
Added a new field calories for products (closes #268)
2019-09-20 20:06:24 +02:00
0089.sql
…
0090.sql
…
0091.sql
…
0092.sql
…
0093.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0094.sql
Added a chore period type "yearly" (closes #407)
2019-10-04 11:24:51 +02:00
0095.sql
Squashed commit
2020-01-27 19:00:49 +01:00
0096.sql
Added the ability to directly add products to the meal plan (closes #450)
2020-01-25 11:51:00 +01:00
0097.sql
…
0098.sql
…
0099.sql
set default store for product, purchase set last store purchased if available or use product default (#672)
2020-03-27 19:27:40 +01:00
0100.sql
…
0101.sql
Fix weekday order for next chore execution calculation for weekly chores (fixes #570)
2020-04-13 15:16:38 +02:00
0102.sql
…
0103.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0104.sql
Optimized StockService->GetProductDetails performance (fixes #2283)
2023-07-31 16:54:58 +02:00
0105.sql
…
0106.sql
Fix is_aggregate_amount always 0 on stock_current (#1127)
2020-11-14 16:41:45 +01:00
0107.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0108.sql
…
0109.sql
…
0110.sql
Squashed commit
2020-12-07 19:48:33 +01:00
0111.sql
Fix is_aggregated_amount of stock_current did not work anymore
2020-11-10 20:11:43 +01:00
0112.sql
…
0113.sql
…
0114.sql
…
0115.sql
Don't use double quotes for SQL string literals (references #2170)
2023-03-16 21:16:27 +01:00
0116.sql
…
0117.sql
Also relate the shopping list amount to QU stock
2020-11-13 17:30:57 +01:00
0118.sql
…
0119.sql
…
0120.sql
Make it possible to merge products (closes #243)
2020-12-20 20:58:22 +01:00
0121.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0122.sql
Optimized/clarified new "Hide product from stock overview" option (references #906)
2020-12-21 20:43:10 +01:00
0123.sql
Optimized barcode concatenation handling
2020-12-20 16:00:14 +01:00
0124.sql
…
0125.sql
Implemented user pictures (closes #1158)
2020-12-20 22:08:50 +01:00
0126.sql
…
0127.sql
…
0128.sql
…
0129.sql
…
0130.sql
Fixed migration when having unsupported parent/child product nesting levels (fixes #1542)
2021-07-25 20:22:10 +02:00
0131.sql
Squashed commit
2021-06-28 17:00:16 +02:00
0132.sql
Use stock_log location instead of product location for stock journal (fixes #1381)
2021-07-02 17:04:40 +02:00
0133.sql
…
0134.sql
…
0135.sql
…
0136.sql
Squashed commit
2021-07-13 19:29:23 +02:00
0137.sql
…
0138.sql
…
0139.sql
Implemented meal plan sections (closes #370)
2021-07-15 17:54:48 +02:00
0140.sql
Removed unnecessary migration (references #1264)
2021-07-10 19:15:17 +02:00
0141.sql
…
0142.sql
…
0143.sql
…
0144.php
Optimized controller / services structure
2026-04-20 22:46:47 +02:00
0145.sql
…
0146.sql
Added a new product option "Should not be frozen" (closes #1320)
2021-07-12 19:27:21 +02:00
0147.sql
…
0148.sql
…
0149.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0150.sql
…
0151.sql
…
0152.sql
Fixed typo
2022-04-17 21:32:54 +02:00
0153.sql
…
0154.sql
…
0155.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0156.sql
…
0157.sql
…
0158.sql
…
0159.sql
Fixed missing recipe ingredient amount when "Only check if any amount is in stock" is enabled and when there are unit conversions (fixes #1718)
2022-01-23 13:56:41 +01:00
0160.sql
Fixed recipe ingredient stock fulfillment shopping list amount comparison (fixes #1717)
2022-02-06 20:02:19 +01:00
0161.sql
Move FEATURE_SETTING_STOCK_COUNT_OPENED_PRODUCTS_AGAINST_MINIMUM_STOCK_AMOUNT to per product option (closes #1753)
2022-02-07 19:12:31 +01:00
0162.php
Optimized controller / services structure
2026-04-20 22:46:47 +02:00
0163.sql
…
0164.sql
…
0165.sql
…
0166.sql
…
0167.sql
Fixed column selection of ix_chores_log_performance1 index
2022-02-11 17:46:17 +01:00
0168.sql
…
0169.sql
Added an daily-same-time chore period type (closes #1793)
2022-02-20 16:03:50 +01:00
0170.sql
Use products stock QU for product_barcodes when empty (references #1794)
2022-02-20 17:07:22 +01:00
0171.sql
Delete QU conversions when deleting QU (theoretical problem, closes #1796)
2022-02-20 19:18:10 +01:00
0172.sql
…
0173.sql
…
0174.sql
…
0175.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0176.sql
Added the possibility to manually reschedule chores (closes #1830)
2022-03-26 18:30:26 +01:00
0177.sql
Implemented a "recipes due score" (closes #1813)
2022-03-29 20:38:26 +02:00
0178.sql
…
0179.sql
…
0180.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0181.sql
Streamline in stock / out of stock wording
2025-01-18 10:33:26 +01:00
0182.sql
Optimizations regarding displaying prices (closes #1743)
2022-04-02 17:49:35 +02:00
0183.sql
…
0184.sql
…
0185.sql
…
0186.sql
…
0187.sql
…
0188.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0189.sql
Fixed typo
2022-04-17 21:32:54 +02:00
0190.sql
Add support for "Move on Open" (#1863)
2022-04-18 18:25:08 +02:00
0191.sql
Fixed recipe ingredient costs/calories when using substituted product with unit conversions (fixes #1903)
2022-05-29 22:48:48 +02:00
0192.sql
…
0193.sql
Split user setting stock_decimal_places_prices into separate settings for input/display (closes #1893)
2022-06-04 14:09:35 +02:00
0194.sql
…
0195.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0196.sql
…
0197.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0198.sql
…
0199.sql
Also update from_qu_id and to_qu_id of inverse unit conversions automatically (closes #1977)
2022-08-24 21:10:22 +02:00
0200.sql
Streamline in stock / out of stock wording
2025-01-18 10:33:26 +01:00
0201.sql
…
0202.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0203.sql
Added a dialog to show product related resolved QU conversions (references #2056 and #1360)
2022-12-04 19:02:15 +01:00
0204.sql
Added a dialog to show product related resolved QU conversions (references #2056 and #1360)
2022-12-04 19:02:15 +01:00
0205.sql
…
0206.sql
Fixed recipe ingredient costs/calories calculation when product substitution and unit conversions is involved at the same time (fixes #2075)
2022-12-21 20:16:22 +01:00
0207.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:14:33 +02:00
0208.sql
Merged the by @alkuzman contributed new quantity_unit_conversions_resolved view (closes #2297)
2023-08-19 08:13:34 +02:00
0209.sql
…
0210.sql
…
0211.sql
Optimize recipe ingredient costs/calories calculation when only_check_single_unit_in_stock is used (closes #780)
2022-12-26 19:48:26 +01:00
0212.sql
…
0213.sql
Optimized StockService->GetProductDetails performance (fixes #2283)
2023-07-31 16:54:58 +02:00
0214.sql
…
0215.sql
Optimized stock_missing_products view (fixes #2154)
2023-03-02 19:36:57 +01:00
0216.sql
Feature: Stock Purchase Metrics (#2135)
2023-04-01 17:05:41 +02:00
0217.sql
…
0218.sql
Make it possible to hide locations/stores/QUs/product_groups/task_categories (closes #2222)
2023-05-13 14:24:52 +02:00
0219.sql
…
0220.sql
…
0221.sql
…
0222.sql
…
0223.sql
Optimized /shoppinglist performance
2023-08-01 20:47:47 +02:00
0224.sql
Added missing semicolon
2023-08-05 21:51:13 +02:00
0225.sql
Cache expensive stock data calculations
2023-08-06 13:28:14 +02:00
0226.sql
…
0227.sql
Fixed handling of edited stock entries when calculating a product's average price (references #2292)
2023-08-06 14:05:35 +02:00
0228.sql
Removed unnecessary calculation step in view uihelper_shopping_list (closes #2298)
2023-08-07 21:57:12 +02:00
0229.sql
…
0230.sql
…
0231.sql
…
0232.sql
Merged the by @alkuzman contributed new quantity_unit_conversions_resolved view (closes #2297)
2023-08-19 08:13:34 +02:00
0233.sql
stock_current view now uses cached QUCs -> Recipes consume 50% faster (#2322)
2023-08-22 19:41:44 +02:00
0234.sql
Optimized performance of GetProductDetails
2023-09-01 17:03:22 +02:00
0235.sql
Show the number of items per shopping list in the shopping lists dropdown (closes #2467)
2024-02-12 20:36:33 +01:00
0236.sql
Fixed product's last_price related to empty / 0 stock transactions (fixes #2470)
2024-02-13 13:12:56 +01:00
0237.sql
Prefill desired_servings by base_servings when creating a recipe (closes #2479)
2024-02-23 18:09:55 +01:00
0238.sql
Optimized product Grocycode handling on consume page (and others / general) (fixes #2571)
2024-08-24 18:20:40 +02:00
0239.sql
Exclude self-produced product prices from spending reports (#2596)
2024-10-25 23:19:00 +02:00
0240.php
Finalized frontend external barcode lookup implementation (references #158)
2025-01-12 13:58:47 +01:00
0241.sql
Squashed commit
2025-01-13 17:41:08 +01:00
0242.php
Optimized controller / services structure
2026-04-20 22:46:47 +02:00
0243.sql
Fixed recipes_nestings_resolved recursive serving calculation (fixes #2361)
2025-01-13 21:37:16 +01:00
0244.sql
Optimized chore on-time tracking (closes #2385)
2025-01-14 20:39:07 +01:00
0245.sql
Various minor usability refinements
2025-01-16 21:34:01 +01:00
0246.sql
Added an upper limit for stock_decimal_places_* settings (references #2508)
2025-01-17 19:48:14 +01:00
0247.sql
Indicate incomplete recipe costs information (closes #1941)
2025-01-17 20:37:43 +01:00
0248.sql
Added a new product option default_purchase_price_type (closes #566)
2025-01-19 16:35:45 +01:00
0249.sql
Make it possible to round up shopping list and recipe ingredient amounts (closes #902, closes #2644)
2025-01-19 20:16:37 +01:00
0250.sql
Changed shopping_list_defaults default amount
2025-01-31 15:56:15 +01:00
0251.sql
Scale up values on the shopping list when shopping_list_round_up is enabled (closes #2687)
2025-02-25 18:43:42 +01:00
0252.sql
Also show the product's default store on /stockoverview (closes #2698)
2025-03-10 17:36:23 +01:00
0253.sql
Replaced barcode scanning library with ZXing (#2706)
2025-03-21 17:41:39 +01:00
0254.sql
Don't use double quoted string literals (in triggers / RAISE)
2025-08-03 23:22:38 +02:00
0255.sql
Optimized product definition quantity unit handling
2026-02-04 21:49:46 +01:00
8888.php
Optimized controller / services structure
2026-04-20 22:46:47 +02:00