JEISA-WEBAPP/pocketbase/pb_migrations/1779619907_created_orders.js

197 lines
4.8 KiB
JavaScript

/// <reference path="../pb_data/types.d.ts" />
migrate((app) => {
const collection = new Collection({
"createRule": "@request.auth.id != ''",
"deleteRule": "@request.auth.id != ''",
"fields": [
{
"autogeneratePattern": "[a-z0-9]{15}",
"hidden": false,
"id": "text3208210256",
"max": 15,
"min": 15,
"name": "id",
"pattern": "^[a-z0-9]+$",
"presentable": false,
"primaryKey": true,
"required": true,
"system": true,
"type": "text"
},
{
"hidden": false,
"id": "autodate2990389176",
"name": "created",
"onCreate": true,
"onUpdate": false,
"presentable": false,
"system": true,
"type": "autodate"
},
{
"hidden": false,
"id": "autodate3332085495",
"name": "updated",
"onCreate": true,
"onUpdate": true,
"presentable": false,
"system": true,
"type": "autodate"
},
{
"autogeneratePattern": "",
"hidden": false,
"id": "text1428098945",
"max": 0,
"min": 0,
"name": "order_number",
"pattern": "",
"presentable": false,
"primaryKey": false,
"required": true,
"system": false,
"type": "text"
},
{
"cascadeDelete": false,
"collectionId": "pbc_3866053794",
"hidden": false,
"id": "relation1337919823",
"maxSelect": 1,
"minSelect": 0,
"name": "company",
"presentable": false,
"required": true,
"system": false,
"type": "relation"
},
{
"cascadeDelete": false,
"collectionId": "pbc_108570809",
"hidden": false,
"id": "relation2168032777",
"maxSelect": 1,
"minSelect": 0,
"name": "customer",
"presentable": false,
"required": false,
"system": false,
"type": "relation"
},
{
"cascadeDelete": false,
"collectionId": "pbc_2527524235",
"hidden": false,
"id": "relation1802619892",
"maxSelect": 1,
"minSelect": 0,
"name": "quote",
"presentable": false,
"required": false,
"system": false,
"type": "relation"
},
{
"hidden": false,
"id": "select2063623452",
"maxSelect": 0,
"name": "status",
"presentable": false,
"required": false,
"system": false,
"type": "select",
"values": [
"new",
"processing",
"order_ready",
"po_generated",
"completed",
"cancelled"
]
},
{
"autogeneratePattern": "",
"hidden": false,
"id": "text18589324",
"max": 0,
"min": 0,
"name": "notes",
"pattern": "",
"presentable": false,
"primaryKey": false,
"required": false,
"system": false,
"type": "text"
},
{
"hidden": false,
"id": "bool4089043106",
"name": "quote_matching_attempted",
"presentable": false,
"required": false,
"system": false,
"type": "bool"
},
{
"hidden": false,
"id": "number411142254",
"max": null,
"min": null,
"name": "quote_match_confidence",
"onlyInt": false,
"presentable": false,
"required": false,
"system": false,
"type": "number"
},
{
"cascadeDelete": false,
"collectionId": "pbc_2527524235",
"hidden": false,
"id": "relation3429253314",
"maxSelect": 1,
"minSelect": 0,
"name": "potential_quote",
"presentable": false,
"required": false,
"system": false,
"type": "relation"
},
{
"hidden": false,
"id": "number255023534",
"max": null,
"min": null,
"name": "potential_quote_confidence",
"onlyInt": false,
"presentable": false,
"required": false,
"system": false,
"type": "number"
},
{
"hidden": false,
"id": "bool1967699178",
"name": "is_repair_order",
"presentable": false,
"required": false,
"system": false,
"type": "bool"
}
],
"id": "pbc_3527180448",
"indexes": [],
"listRule": "@request.auth.id != ''",
"name": "orders",
"system": false,
"type": "base",
"updateRule": "@request.auth.id != ''",
"viewRule": "@request.auth.id != ''"
});
return app.save(collection);
}, (app) => {
const collection = app.findCollectionByNameOrId("pbc_3527180448");
return app.delete(collection);
})