/// <reference path="../pb_data/types.d.ts" />
migrate((app) => {
  const collection = new Collection({
    "createRule": null,
    "deleteRule": null,
    "fields": [
      {
        "autogeneratePattern": "",
        "hidden": false,
        "id": "text3208210256",
        "max": 0,
        "min": 0,
        "name": "id",
        "pattern": "^[a-z0-9]+$",
        "presentable": false,
        "primaryKey": true,
        "required": true,
        "system": true,
        "type": "text"
      },
      {
        "autogeneratePattern": "",
        "hidden": false,
        "id": "_clone_OhO7",
        "max": 0,
        "min": 0,
        "name": "doctor",
        "pattern": "",
        "presentable": false,
        "primaryKey": false,
        "required": false,
        "system": false,
        "type": "text"
      },
      {
        "hidden": false,
        "id": "number432430951",
        "max": null,
        "min": null,
        "name": "cnt",
        "onlyInt": false,
        "presentable": false,
        "required": false,
        "system": false,
        "type": "number"
      }
    ],
    "id": "pbc_3856397659",
    "indexes": [],
    "listRule": null,
    "name": "dvn_by_doctor",
    "system": false,
    "type": "view",
    "updateRule": null,
    "viewQuery": "select \n  (ROW_NUMBER() OVER()) as id,\n  doctor, \n  count(doctor) as cnt\nfrom dvn2\ngroup by doctor\n",
    "viewRule": null
  });

  return app.save(collection);
}, (app) => {
  const collection = app.findCollectionByNameOrId("pbc_3856397659");

  return app.delete(collection);
})
