Schema update #48
Annotations
3 errors, 3 warnings, and 1 notice
destructive changes detected:
dirs/ecommerce/migrations/20240707130650.sql#L2
Dropping non-virtual column "user_name" (DS103)
Details: https://atlasgo.io/lint/analyzers#DS103
|
data dependent changes detected:
dirs/ecommerce/migrations/20240707130650.sql#L2
Adding a non-nullable "varchar" column "username" on table "users" without a default value implicitly sets existing rows with "" (MY101)
Details: https://atlasgo.io/lint/analyzers#MY101
|
lint
Atlas failed with code 1: {
"Env": {
"Driver": "mysql",
"URL": {
"Scheme": "mysql",
"Opaque": "",
"User": {},
"Host": "localhost:3306",
"Path": "/dev",
"RawPath": "",
"OmitHost": false,
"ForceQuery": false,
"RawQuery": "parseTime=true",
"Fragment": "",
"RawFragment": "",
"Schema": "dev"
},
"Dir": "dirs/ecommerce/migrations"
},
"Schema": {
"Current": "table \"categories\" {\n schema = schema.dev\n column \"id\" {\n null = false\n type = int\n }\n column \"category_name\" {\n null = false\n type = varchar(255)\n }\n primary_key {\n columns = [column.id]\n }\n}\ntable \"comments\" {\n schema = schema.dev\n column \"id\" {\n null = false\n type = int\n }\n column \"user_id\" {\n null = false\n type = int\n }\n column \"review_id\" {\n null = true\n type = int\n }\n column \"parent_comment_id\" {\n null = true\n type = int\n }\n column \"comment_text\" {\n null = false\n type = text\n }\n primary_key {\n columns = [column.id]\n }\n foreign_key \"comments_ibfk_1\" {\n columns = [column.user_id]\n ref_columns = [table.users.column.id]\n on_update = NO_ACTION\n on_delete = CASCADE\n }\n foreign_key \"comments_ibfk_2\" {\n columns = [column.review_id]\n ref_columns = [table.product_reviews.column.id]\n on_update = NO_ACTION\n on_delete = CASCADE\n }\n foreign_key \"comments_ibfk_3\" {\n columns = [column.parent_comment_id]\n ref_columns = [table.comments.column.id]\n on_update = NO_ACTION\n on_delete = CASCADE\n }\n index \"parent_comment_id\" {\n columns = [column.parent_comment_id]\n }\n index \"review_id\" {\n columns = [column.review_id]\n }\n index \"user_id\" {\n columns = [column.user_id]\n }\n}\ntable \"fulfillment_centers\" {\n schema = schema.dev\n column \"id\" {\n null = false\n type = int\n }\n column \"name\" {\n null = false\n type = varchar(255)\n }\n column \"location\" {\n null = false\n type = varchar(255)\n }\n primary_key {\n columns = [column.id]\n }\n}\ntable \"inventory\" {\n schema = schema.dev\n column \"id\" {\n null = false\n type = int\n }\n column \"product_id\" {\n null = false\n type = int\n }\n column \"fulfillment_center_id\" {\n null = false\n type = int\n }\n column \"quantity\" {\n null = false\n type = int\n }\n primary_key {\n columns = [column.id]\n }\n foreign_key \"inventory_ibfk_1\" {\n columns = [column.product_id]\n ref_columns = [table.products.column.id]\n on_update = NO_ACTION\n on_delete = CASCADE\n }\n foreign_key \"inventory_ibfk_2\" {\n columns = [column.fulfillment_center_id]\n ref_columns = [table.fulfillment_centers.column.id]\n on_update = NO_ACTION\n on_delete = CASCADE\n }\n index \"fulfillment_center_id\" {\n columns = [column.fulfillment_center_id]\n }\n index \"product_id\" {\n columns = [column.product_id]\n }\n}\ntable \"order_items\" {\n schema = schema.dev\n column \"id\" {\n null = false\n type = int\n }\n column \"order_id\" {\n null = false\n type = int\n }\n column \"product_id\" {\n null = false\n type = int\n }\n column \"quantity\" {\n null = false\n type = int\n }\n column \"price\" {\n null = false\n type = decimal(10,2)\n unsigned = false\n }\n primary_key {\n columns = [column.id]\n }\n foreign_key \"order_items_ibfk_1\" {\n columns = [column.order_id]\n ref_columns = [table.orders.column.id]\n on_update = NO_ACTION\n on_delete = CASCADE\n }\n foreign_key \"order_items_ibfk_2\" {\n columns = [column.product_id]\n ref_columns = [table.products.column.id]\n on_update = NO_ACTION\n on_delete = CASCADE\n }\n index \"order_id\" {\n columns = [column.order_id]\n }\n index \"product_id\" {\n columns = [column.product_id]\n }\n}\ntable \"orders\" {\n schema = schema.dev\n column \"id\" {\n
|
lint
The following actions uses Node.js version which is deprecated and will be forced to run on node20: actions/[email protected], ariga/atlas-action@v0. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
|
lint
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
|
lint
The `save-state` command is deprecated and will be disabled soon. Please upgrade to using Environment Files. For more information see: https://github.blog/changelog/2022-10-11-github-actions-deprecating-save-state-and-set-output-commands/
|
lint
For full report visit: https://gh.atlasgo.cloud/ci-runs/8589934823
|