import {CDM_RUNTIME_SCHEMA} from "../../../utils/globals"

export function up(knex: any): Promise<any> {
    return knex.schema
    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."Space" ("Id", "TenantId", "CreatedAt", "DescriptorSchemaId", "DescriptorSchemaVersion", "Descriptor", "Editable", "IsDefault", "InstanceId") VALUES
    ('81bad4c6-6eaf-4cea-a5ab-6c33e0195c09', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '2022-03-20 10:01:10.017607+00', '2', '1', '{ "sap.ui": {"name": {"newName": "test"}}}', 'f', 'f', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('b41f6aba-7a4d-48fe-a66f-dfff3769d379', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '2022-03-20 17:48:33.917986+00', '2', '1', '{ "sap.ui": {"name": {"newName": "test"}}}', 'f', 'f', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."WorkPage" ("Id", "TenantId", "CreatedAt", "DescriptorSchemaId", "DescriptorSchemaVersion", "Descriptor", "Editable", "IsDefault", "CurrentVersionId", "Draft", "Versions", "InstanceId") VALUES
    ('6a559319-8878-40a9-b8b7-22dd81f3c208', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '2022-03-20 11:23:32.383083+00', NULL, '1.0', '{ "sap.ui": {"name": {"newName": "test"}, "Title": ""}}', 'f', 'f', '4', NULL, NULL, '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('b05b53e8-1248-4191-9bbf-9a8f7374cf99', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '2022-03-20 17:53:14.698569+00', NULL, '1.0', '{ "sap.ui": {"name": {"newName": "test"}}}', 'f', 'f', '3', NULL, NULL, '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."WorkPageVersion" ("Id", "TenantId", "Contents", "PublishedTimestamp", "PublishedByUser", "WorkPageId", "CreatedAt", "BaselineVersionId", "InstanceId") VALUES
    ('02a482dc-5774-4c6d-a359-432be2490d73', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
      "WorkPage": {
          "ID": "wp0001",
          "Rows": [
              {
                  "ID": "row0",
                  "Columns": [
                      {
                          "ID": "col01",
                          "Cells": [
                              {
                                  "ID": "cell01",
                                  "Widgets": [
                                      {
                                          "ID": "imageComponentCard",
                                          "Descriptor": {
                                              "Title": "WidgetTitle",
                                              "sap.app": {
                                                  "entityUnderWidget": "WidgetDescriptor"
                                              }
                                          },
                                          "DescriptorRef": null,
                                          "Visualization": {
                                              "ID": "97176e7f-b2ea-4e31-842a-3efa5086b320"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 24
                              }
                          }
                      }
                  ],
                  "Descriptor": {
                      "Title": "",
                      "TitleInfo": "",
                      "FillRowHeight": true,
                      "FullWidthBackground": false
                  }
              },
              {
                  "ID": "row1",
                  "Columns": [
                      {
                          "ID": "col11",
                          "Cells": [
                              {
                                  "ID": "cell11",
                                  "Widgets": [
                                      {
                                          "ID": "customTileWidget1",
                                          "Descriptor": {},
                                          "DescriptorRef": null,
                                          "Visualization": {
                                              "ID": "7adb5695-f954-4e5c-b8b7-ac947cff3ac9"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 24
                              }
                          }
                      }
                  ],
                  "Descriptor": {
                      "Title": "",
                      "FillRowHeight": true,
                      "FullWidthBackground": false
                  }
              },
              {
                  "ID": "row2",
                  "Columns": [
                      {
                          "ID": "col21",
                          "Cells": [
                              {
                                  "ID": "cell21",
                                  "Widgets": [
                                      {
                                          "ID": "chartCard1",
                                          "Visualization": {
                                              "ID": "1e504721-8532-4a80-8fdd-0d88744c336f"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 8
                              }
                          }
                      },
                      {
                          "ID": "col22",
                          "Cells": [
                              {
                                  "ID": "cell22",
                                  "Widgets": [
                                      {
                                          "ID": "tableCard1",
                                          "Visualization": {
                                              "ID": "5a119bf3-8540-42b6-a0b4-059db20cd459"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 8
                              }
                          }
                      },
                      {
                          "ID": "col23",
                          "Cells": [
                              {
                                  "ID": "cell23",
                                  "Widgets": [
                                      {
                                          "ID": "sfsfCard1",
                                          "Visualization": {
                                              "ID": "287e3392-00d9-4548-ba64-7055318f5565"
                                          }
                                      },
                                      {
                                          "ID": "sfsfCard2",
                                          "Visualization": {
                                              "ID": "25aa15f2-d26f-4070-84fa-6d47257fa95e"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 8
                              }
                          }
                      }
                  ],
                  "Descriptor": {
                      "Title": "",
                      "TitleInfo": "Cell mode: Section",
                      "FillRowHeight": true,
                      "FullWidthBackground": true
                  }
              }
          ],
          "Descriptor": {
              "Title": "",
              "sap.ui": {
                  "name": {
                      "newName": "test"
                  }
              }
          }
      }
  }', '2021-12-17 02:00:54.737', 'admin', 'b05b53e8-1248-4191-9bbf-9a8f7374cf99', '2022-03-20 18:15:50.511405+00', '3', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('2d11358c-b005-4372-a00d-39d194ba920b', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
      "WorkPage": {
          "ID": "wp0001",
          "Rows": [
              {
                  "ID": "row0",
                  "Columns": [
                      {
                          "ID": "col01",
                          "Cells": [
                              {
                                  "ID": "cell01",
                                  "Widgets": [
                                      {
                                          "ID": "imageComponentCard",
                                          "Descriptor": {
                                              "Title": "WidgetTitle",
                                              "sap.app": {
                                                  "entityUnderWidget": "WidgetDescriptor"
                                              }
                                          },
                                          "DescriptorRef": null,
                                          "Visualization": {
                                              "ID": "97176e7f-b2ea-4e31-842a-3efa5086b320"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 24
                              }
                          }
                      }
                  ],
                  "Descriptor": {
                      "Title": "",
                      "TitleInfo": "",
                      "FillRowHeight": true,
                      "FullWidthBackground": false
                  }
              },
              {
                  "ID": "row1",
                  "Columns": [
                      {
                          "ID": "col11",
                          "Cells": [
                              {
                                  "ID": "cell11",
                                  "Widgets": [
                                      {
                                          "ID": "customTileWidget1",
                                          "Descriptor": {},
                                          "DescriptorRef": null,
                                          "Visualization": {
                                              "ID": "7adb5695-f954-4e5c-b8b7-ac947cff3ac9"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 24
                              }
                          }
                      }
                  ],
                  "Descriptor": {
                      "Title": "",
                      "FillRowHeight": true,
                      "FullWidthBackground": false
                  }
              },
              {
                  "ID": "row2",
                  "Columns": [
                      {
                          "ID": "col21",
                          "Cells": [
                              {
                                  "ID": "cell21",
                                  "Widgets": [
                                      {
                                          "ID": "chartCard1",
                                          "Visualization": {
                                              "ID": "1e504721-8532-4a80-8fdd-0d88744c336f"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 8
                              }
                          }
                      },
                      {
                          "ID": "col22",
                          "Cells": [
                              {
                                  "ID": "cell22",
                                  "Widgets": [
                                      {
                                          "ID": "tableCard1",
                                          "Visualization": {
                                              "ID": "5a119bf3-8540-42b6-a0b4-059db20cd459"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 8
                              }
                          }
                      },
                      {
                          "ID": "col23",
                          "Cells": [
                              {
                                  "ID": "cell23",
                                  "Widgets": [
                                      {
                                          "ID": "sfsfCard1",
                                          "Visualization": {
                                              "ID": "287e3392-00d9-4548-ba64-7055318f5565"
                                          }
                                      },
                                      {
                                          "ID": "sfsfCard2",
                                          "Visualization": {
                                              "ID": "25aa15f2-d26f-4070-84fa-6d47257fa95e"
                                          }
                                      }
                                  ],
                                  "Descriptor": {
                                      "Mode": ""
                                  },
                                  "Configurations": {}
                              }
                          ],
                          "Configurations": {
                              "Settings": {
                                  "Colspan": 8
                              }
                          }
                      }
                  ],
                  "Descriptor": {
                      "Title": "",
                      "TitleInfo": "Cell mode: Section",
                      "FillRowHeight": true,
                      "FullWidthBackground": true
                  }
              }
          ],
          "Descriptor": {
              "Title": "",
              "sap.ui": {
                  "name": {
                      "newName": "test"
                  }
              }
          }
      }
  }', '2021-12-17 02:00:54.737', 'admin', '6a559319-8878-40a9-b8b7-22dd81f3c208', '2022-03-20 12:14:36.36885+00', '4', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('566af3e1-5d8c-487b-bd55-1f8eb3b773f7', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
        "WorkPage": {
          "ID": "6a559319-8878-40a9-b8b7-22dd81f3c208",
          "Descriptor": {
            "sap.ui": {
              "name": {
                "newName": "test"
              }
            }
          },
          "Rows": [
            {
              "ID": "row0",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col01",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell01",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "imageComponentCard",
                          "Descriptor": {
                            "Title": "WidgetTitle",
                            "sap.app": {
                              "entityUnderWidget": "WidgetDescriptor"
                            }
                          },
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "97176e7f-b2ea-4e31-842a-3efa5086b320"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row1",
              "Descriptor": {
                "Title": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col11",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell11",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "customTileWidget1",
                          "Descriptor": {},
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "7adb5695-f954-4e5c-b8b7-ac947cff3ac9"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row2",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "Cell mode: Section",
                "FillRowHeight": true,
                "FullWidthBackground": true
              },
              "Columns": [
                {
                  "ID": "col21",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell21",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "1e504721-8532-4a80-8fdd-0d88744c336f"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col22",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell22",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "5a119bf3-8540-42b6-a0b4-059db20cd459"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col23",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell23",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ', '2021-12-17 02:00:54.737', 'admin', '6a559319-8878-40a9-b8b7-22dd81f3c208', '2022-03-20 12:13:25.938174+00', '3', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('7b1ac976-ddc7-466e-bc8b-9d83bd609beb', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
        "WorkPage": {
          "ID": "6a559319-8878-40a9-b8b7-22dd81f3c208",
          "Descriptor": {
            "sap.ui": {
              "name": {
                "newName": "test"
              }
            }
          },
          "Rows": [
            {
              "ID": "row0",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col01",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell01",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "imageComponentCard",
                          "Descriptor": {
                            "Title": "WidgetTitle",
                            "sap.app": {
                              "entityUnderWidget": "WidgetDescriptor"
                            }
                          },
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "97176e7f-b2ea-4e31-842a-3efa5086b320"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row1",
              "Descriptor": {
                "Title": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col11",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell11",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "customTileWidget1",
                          "Descriptor": {},
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "7adb5695-f954-4e5c-b8b7-ac947cff3ac9"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row2",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "Cell mode: Section",
                "FillRowHeight": true,
                "FullWidthBackground": true
              },
              "Columns": [
                {
                  "ID": "col21",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell21",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "1e504721-8532-4a80-8fdd-0d88744c336f"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col22",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell22",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "5a119bf3-8540-42b6-a0b4-059db20cd459"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col23",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell23",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ', '2021-12-17 02:00:54.737', 'admin', 'b05b53e8-1248-4191-9bbf-9a8f7374cf99', '2022-03-20 17:53:14.693294+00', '1', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('92b5e18a-2a2c-4aef-bd8f-2a348b0b83ee', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
        "WorkPage": {
          "ID": "6a559319-8878-40a9-b8b7-22dd81f3c208",
          "Descriptor": {
            "sap.ui": {
              "name": {
                "newName": "test"
              }
            }
          },
          "Rows": [
            {
              "ID": "row0",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col01",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell01",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "imageComponentCard",
                          "Descriptor": {
                            "Title": "WidgetTitle",
                            "sap.app": {
                              "entityUnderWidget": "WidgetDescriptor"
                            }
                          },
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "97176e7f-b2ea-4e31-842a-3efa5086b320"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row1",
              "Descriptor": {
                "Title": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col11",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell11",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "customTileWidget1",
                          "Descriptor": {},
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "7adb5695-f954-4e5c-b8b7-ac947cff3ac9"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row2",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "Cell mode: Section",
                "FillRowHeight": true,
                "FullWidthBackground": true
              },
              "Columns": [
                {
                  "ID": "col21",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell21",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "1e504721-8532-4a80-8fdd-0d88744c336f"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col22",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell22",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "5a119bf3-8540-42b6-a0b4-059db20cd459"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col23",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell23",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ', '2021-12-17 02:00:54.737', 'admin', '6a559319-8878-40a9-b8b7-22dd81f3c208', '2022-03-20 12:09:19.468206+00', '2', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('a7a31442-1c74-4897-b4b9-c20a884a82a4', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
        "WorkPage": {
          "ID": "6a559319-8878-40a9-b8b7-22dd81f3c208",
          "Descriptor": {
            "sap.ui": {
              "name": {
                "newName": "test"
              }
            }
          },
          "Rows": [
            {
              "ID": "row0",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col01",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell01",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "imageComponentCard",
                          "Descriptor": {
                            "Title": "WidgetTitle",
                            "sap.app": {
                              "entityUnderWidget": "WidgetDescriptor"
                            }
                          },
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "97176e7f-b2ea-4e31-842a-3efa5086b320"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row1",
              "Descriptor": {
                "Title": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col11",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell11",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "customTileWidget1",
                          "Descriptor": {},
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "7adb5695-f954-4e5c-b8b7-ac947cff3ac9"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row2",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "Cell mode: Section",
                "FillRowHeight": true,
                "FullWidthBackground": true
              },
              "Columns": [
                {
                  "ID": "col21",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell21",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "1e504721-8532-4a80-8fdd-0d88744c336f"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col22",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell22",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "5a119bf3-8540-42b6-a0b4-059db20cd459"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col23",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell23",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ', '2021-12-17 02:00:54.737', 'admin', '6a559319-8878-40a9-b8b7-22dd81f3c208', '2022-03-20 11:23:32.378026+00', '1', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b'),
    ('f6b00dfa-5bef-47ca-98a0-fae5e03be64d', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
        "WorkPage": {
          "ID": "6a559319-8878-40a9-b8b7-22dd81f3c208",
          "Descriptor": {
            "sap.ui": {
              "name": {
                "newName": "test"
              }
            }
          },
          "Rows": [
            {
              "ID": "row0",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col01",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell01",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "imageComponentCard",
                          "Descriptor": {
                            "Title": "WidgetTitle",
                            "sap.app": {
                              "entityUnderWidget": "WidgetDescriptor"
                            }
                          },
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "97176e7f-b2ea-4e31-842a-3efa5086b320"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row1",
              "Descriptor": {
                "Title": "",
                "FillRowHeight": true,
                "FullWidthBackground": false
              },
              "Columns": [
                {
                  "ID": "col11",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 24
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell11",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "customTileWidget1",
                          "Descriptor": {},
                          "DescriptorRef": null,
                          "Visualization": {
                            "ID": "7adb5695-f954-4e5c-b8b7-ac947cff3ac9"
                          }
                        }
                      ]
                    }
                  ]
                }
              ]
            },
            {
              "ID": "row2",
              "Descriptor": {
                "Title": "",
                "TitleInfo": "Cell mode: Section",
                "FillRowHeight": true,
                "FullWidthBackground": true
              },
              "Columns": [
                {
                  "ID": "col21",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell21",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "1e504721-8532-4a80-8fdd-0d88744c336f"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col22",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell22",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": [
                        {
                          "ID": "chartCard1",
                          "Visualization": {
                            "ID": "5a119bf3-8540-42b6-a0b4-059db20cd459"
                          }
                        }
                      ]
                    }
                  ]
                },
                {
                  "ID": "col23",
                  "Configurations": {
                    "Settings": {
                      "Colspan": 8
                    }
                  },
                  "Cells": [
                    {
                      "ID": "cell23",
                      "Descriptor": {
                        "Mode": ""
                      },
                      "Configurations": {},
                      "Widgets": []
                    }
                  ]
                }
              ]
            }
          ]
        }
      }
    ', '2021-12-17 02:00:54.737', 'admin', 'b05b53e8-1248-4191-9bbf-9a8f7374cf99', '2022-03-20 17:57:04.955557+00', '2', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."Role-Spaces" ("RoleId", "SpaceId") VALUES
    ('2115d87d-b288-419f-bbe4-6b0c677937ce', '81bad4c6-6eaf-4cea-a5ab-6c33e0195c09'),
    ('2115d87d-b288-419f-bbe4-6b0c677937ce', 'b41f6aba-7a4d-48fe-a66f-dfff3769d379');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."WorkPage-WorkPageVersions" ("WorkPageId", "WorkPageVersionId") VALUES
    ('6a559319-8878-40a9-b8b7-22dd81f3c208', '2d11358c-b005-4372-a00d-39d194ba920b'),
    ('6a559319-8878-40a9-b8b7-22dd81f3c208', '566af3e1-5d8c-487b-bd55-1f8eb3b773f7'),
    ('6a559319-8878-40a9-b8b7-22dd81f3c208', '92b5e18a-2a2c-4aef-bd8f-2a348b0b83ee'),
    ('6a559319-8878-40a9-b8b7-22dd81f3c208', 'a7a31442-1c74-4897-b4b9-c20a884a82a4'),
    ('b05b53e8-1248-4191-9bbf-9a8f7374cf99', '02a482dc-5774-4c6d-a359-432be2490d73'),
    ('b05b53e8-1248-4191-9bbf-9a8f7374cf99', '7b1ac976-ddc7-466e-bc8b-9d83bd609beb'),
    ('b05b53e8-1248-4191-9bbf-9a8f7374cf99', 'f6b00dfa-5bef-47ca-98a0-fae5e03be64d');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."Space-WorkPages" ("SpaceId", "WorkPageId") VALUES
    ('81bad4c6-6eaf-4cea-a5ab-6c33e0195c09', '6a559319-8878-40a9-b8b7-22dd81f3c208'),
    ('81bad4c6-6eaf-4cea-a5ab-6c33e0195c09', 'b05b53e8-1248-4191-9bbf-9a8f7374cf99'),
    ('b41f6aba-7a4d-48fe-a66f-dfff3769d379', 'b05b53e8-1248-4191-9bbf-9a8f7374cf99');`)
    // Addition of dev content

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."WorkPage" ("Id", "TenantId", "CreatedAt", "DescriptorSchemaId", "DescriptorSchemaVersion", "Descriptor", "Editable", "IsDefault", "CurrentVersionId", "Draft", "Versions", "InstanceId") VALUES
    ('70b3aa12-ce74-4b22-83c3-f6e1f801adbf', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '2022-03-20 17:53:14.698569+00', NULL, '1.0', '{ "sap.ui": {"name": {"newName": "test"}}}', 'f', 'f', '1', NULL, NULL, '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."Space-WorkPages" ("SpaceId", "WorkPageId") VALUES
    ('81bad4c6-6eaf-4cea-a5ab-6c33e0195c09', '70b3aa12-ce74-4b22-83c3-f6e1f801adbf');`)

    .raw(`INSERT INTO "${CDM_RUNTIME_SCHEMA}"."WorkPageVersion" ("Id", "TenantId", "Contents", "PublishedTimestamp", "PublishedByUser", "WorkPageId", "CreatedAt", "BaselineVersionId", "InstanceId") VALUES
    ('dd8fb1ef-457e-45ea-a6a1-62e988157de1', '9f77a69d-5d71-48b4-b759-93616a3d60f6', '{
      "WorkPage": {
        "ID": "70b3aa12-ce74-4b22-83c3-f6e1f801adbf",
        "Descriptor": {
          "Title": "",
          "sap.ui": {
            "name": {
              "newName": "test"
            }
          }
        }
      }
    }', '2021-12-17 02:00:54.737', 'admin', '70b3aa12-ce74-4b22-83c3-f6e1f801adbf', '2022-03-20 18:15:50.511405+00', '1', '1d59c4d7-5985-4f21-ad3c-1ac66bf14d2b');`);
}

export function down(knex: any): Promise<any> {
    return knex.schema.raw(`DROP SCHEMA IF EXISTS "${CDM_RUNTIME_SCHEMA}" CASCADE;`);
}