10_sql/CREATE_TABLE.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "7d45dda5",
   "metadata": {},
   "source": [
    "# SQL Data Definition Language"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e9b0f459",
   "metadata": {},
   "source": [
    "## Preparation"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "38d00b5d",
   "metadata": {},
   "source": [
    "For this section you need `chinook.db` database file and working `%sql` magic.  \n",
    "If you don't have it, please go back to the [previous section](../09_sql/connect_to_database.ipynb) and follow the instructions.  \n",
    "The following code should not produce any errors:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a6eb7abf",
   "metadata": {},
   "outputs": [],
   "source": [
    "%load_ext sql\n",
    "%sql sqlite:///chinook.db"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9a16ac82",
   "metadata": {},
   "source": [
    "## `CREATE TABLE` - adding a new empty table to the database"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "175ec84d",
   "metadata": {},
   "source": [
    "### Overview"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "076d9c10",
   "metadata": {},
   "source": [
    "The main syntax we need to use for creating a new table:"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3d39b938",
   "metadata": {},
   "source": [
    "```sql\n",
    "CREATE TABLE [IF NOT EXIST] table_name (\n",
    "    name_1 data_type_1 PRIMARY KEY,      -- first column\n",
    "    name_2 data_type_2 NOT NULL,         -- second column\n",
    "    name_3 data_type_3 DEFAULT 0,        /* third column */\n",
    "    table_constraints                    \n",
    ")\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "37779d08",
   "metadata": {},
   "source": [
    "As you can see:\n",
    "- we must specify the table name. \n",
    "- we (can) use `IF NOT EXIST` to create the table only if it doesn't exist. If you try to create a table that already exists inside the database you will get an error message. To avoid this, you can use an optional clause `IF NOT EXISTS`.\n",
    "- we must specify the list of table columns. Each column must have a `name` and a `data type`.\n",
    "- we may specify additional column constraints/properties: `PRIMARY KEY`, `FOREIGN KEY`, `UNIQUE`, `NOT NULL`, `CHECK`, `DEFAULT`."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e4c38072",
   "metadata": {},
   "source": [
    "### Constraints"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "227647e5",
   "metadata": {},
   "source": [
    "Constraints are the rules enforced on a data columns on table. These are used to limit the type of data that can get added into a table. This ensures the accuracy and reliability of the data in the database."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "57ec3a85",
   "metadata": {},
   "source": [
    "#### `NOT NULL` - the column must only have valid values"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6dc089f4",
   "metadata": {},
   "source": [
    "Ensures that a column cannot have NULL value.\n",
    "\n",
    "If `NOT NULL` constraint is applied on a column then you cannot insert a new row in the table with `NULL` value in that column."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c7a0221d",
   "metadata": {},
   "source": [
    "#### `PRIMARY KEY` - defines primary key column(s)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8f26516d",
   "metadata": {},
   "source": [
    "The `PRIMARY KEY` constraint identifies that the column belongs to the set of primary key columns which uniquely identify each row of the table. No two rows in a table are allowed to have exactly the same values in all of its primary key columns. We cannot enter `NULL` value in a primary key column."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fd206538",
   "metadata": {},
   "source": [
    "Primary key(s) might be defined in two ways:\n",
    "\n",
    "- If the primary key has only one column:\n",
    "\n",
    "```sql\n",
    "`CREATE TABLE table_name(\n",
    "   column_1 INTEGER NOT NULL PRIMARY KEY,\n",
    "   ...\n",
    ")\n",
    "```\n",
    "\n",
    "- If the primary key consists of two or more columns:\n",
    "\n",
    "```sql\n",
    "CREATE TABLE table_name(\n",
    "   column_1 INTEGER NOT NULL,\n",
    "   column_2 INTEGER NOT NULL,\n",
    "   ...\n",
    "   PRIMARY KEY(column_1,column_2,...)\n",
    ")\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7a2e7bee",
   "metadata": {},
   "source": [
    "#### `FOREIGN KEY` - defines a relation to (other) table"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b755b2e3",
   "metadata": {},
   "source": [
    "`FOREIGN KEY` is used to describe that the current table stores a relation to a parent table and arguments specify:\n",
    "- the name of the referenced (parent) table after `REFERENCES`\n",
    "- what *action* should be taken `ON UPDATE` of a referenced row in the parent table (so, when the value is changed)\n",
    "- what *action* should be taken `ON DELETE` of a referenced row in the parent table (so, when the row gets removed)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4c915a68",
   "metadata": {},
   "source": [
    "The SQL specification follows the pattern:"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "68158234",
   "metadata": {},
   "source": [
    "```sql\n",
    "FOREIGN KEY (foreign_key_columns)\n",
    "   REFERENCES parent_table(parent_key_columns)\n",
    "      ON UPDATE action \n",
    "      ON DELETE action\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6e0bb857",
   "metadata": {},
   "source": [
    "The following actions are allowed (more desciption [here](https://www.sqlitetutorial.net/sqlite-foreign-key/)):"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d139b041",
   "metadata": {},
   "source": [
    "- `NO ACTION`: No action is taken on update/delete.\n",
    "- `CASCADE`: Propagates the changes from the parent table to the child table when you update or delete the parent key.\n",
    "- `SET NULL`\n",
    "- `SET DEFAULT`\n",
    "- `RESTRICT`"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eb3a178d",
   "metadata": {},
   "source": [
    "#### `UNIQUE` - this column must have no duplicated values"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3010dc84",
   "metadata": {},
   "source": [
    "Ensures that all values in a column are different. The `UNIQUE` constraint restricts one or more columns to contain unique values within a table.\n",
    "\n",
    "Although both a `UNIQUE` constraint and a `PRIMARY KEY` constraint enforce uniqueness, use a `UNIQUE` constraint instead of a `PRIMARY KEY` constraint when you want to enforce the uniqueness of a column, or combination of columns, that is not the primary key."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a0682cdf",
   "metadata": {},
   "source": [
    "#### `CHECK` - constraints checks in form of expressions"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4e59a6cc",
   "metadata": {},
   "source": [
    "The `CHECK` constraint is used to restrict the values that can be placed in a column. It allows to write expressions which must be met before a value is allowed to be inserted/changed."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "daf6d99b",
   "metadata": {},
   "source": [
    "#### `DEFAULT` - value to be used when not provided"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "23296cf9",
   "metadata": {},
   "source": [
    "`DEFAULT` specifies the default value for the columns. A column default is some value that will be inserted in the column by the database engine when an `INSERT` statement doesn't explicitly assign a particular value."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fed0f685",
   "metadata": {},
   "source": [
    "## `DROP TABLE` - removing a table from the database"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "cae0242e",
   "metadata": {},
   "source": [
    "Use the following syntax to remove a table from the database:"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2059d8b1",
   "metadata": {},
   "source": [
    "```sql\n",
    "DROP TABLE table_name\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e25c5f0c",
   "metadata": {},
   "source": [
    "*Note:* Dropping of a table might fail when presence of table rows are necessary due to constraints present in other tables."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "84639899",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "42568795",
   "metadata": {},
   "source": [
    "## Example 1: Create two tables with many-to-many relation"
   ]
  },
  {
   "attachments": {
    "image.png": {
     "image/png": "iVBORw0KGgoAAAANSUhEUgAAAi8AAACWCAIAAACZ7P+HAAAK2WlDQ1BJQ0MgUHJvZmlsZQAASImVlwdUU9kWhs+96Y2WgICU0HsXCCAl9NClg6iEJJBQQkwIKnZlcATHgogIKCM6VAVHhyJjAUSxDYoN+4AMCso4WLChMhd4hJl567233r5r3/OtnX322eese9b6AwAliC0SpcMKAGQIs8Thfp702Lh4Ou4pgJCHDBhAmc2RiJhhYUEAsdnx7/buDpKL2E2LqVr//vt/NSUuT8IBAEpAOIkr4WQg3I74GEckzgIAdQyJ663IEk3xLYRpYqRBhIenOGWGP09x0jSjFaZzIsO9ENYHAE9ms8UpAJCtkTg9m5OC1CGHIWwt5AqECG9A2I3DZ3MRRtYF5hkZmVM8irAxki8CgEJDmJH0l5opf6ufJKvPZqfIeGZf04b3FkhE6exV/+fR/G/LSJfOrmGIOJkv9g9HRlXk/O6mZQbKWJgUEjrLAu50/jTzpf5Rs8yReMXPMpftHSibmx4SNMvJAl+WrE4WK3KWeRKfiFkWZ4bL1koWezFnmS2eW1eaFiWL83ksWf0cfmTMLGcLokNmWZIWETiX4yWLi6Xhsv55Qj/PuXV9ZXvPkPxlvwKWbG4WP9Jftnf2XP88IXOupiRW1huX5+0zlxMlyxdlecrWEqWHyfJ56X6yuCQ7QjY3C/k45+aGyc4wlR0QNsuACSJAFOJ0EA3igS1wBE7AH/hk8VZmTW3GK1O0SixI4WfRmciN49FZQo6lOd3W2tYWgKn7O/NJvLk7fS8hFfxcjL8bAPulCHyciyUj96oF6VsRnosZZQJARc6hw5YjFWfPxNBTLwwgAnlAA2pAC+gBY2CBdOcAXIAH8AEBIBREgjiwFHAAH2QAMVgB1oCNIA8UgJ1gDygFFeAQqAFHwXHQAk6BDnABXAHXwW3wAPSDIfACjIF3YAKCIBxEgaiQGqQNGUBmkC3EgNwgHygICofioEQoBRJCUmgNtBkqgAqhUuggVAv9CJ2EOqBLUC90DxqARqDX0CcYBZNhGqwJG8JWMANmwoFwJLwEToGXwzlwLrwdLoEr4SNwM9wBX4Fvw/3wC3gcBVAklApKB2WBYqC8UKGoeFQySoxah8pHFaMqUQ2oNlQ36iaqHzWK+ojGoqloOtoC7YL2R0ehOejl6HXobehSdA26Gd2FvokeQI+hv2IoGA2MGcYZw8LEYlIwKzB5mGJMFaYJcx5zGzOEeYfFYlWwRlhHrD82DpuKXY3dht2PbcS2Y3uxg9hxHA6nhjPDueJCcWxcFi4Ptw93BHcWdwM3hPuAJ+G18bZ4X3w8XojfhC/G1+HP4G/gn+EnCAoEA4IzIZTAJawi7CAcJrQRrhGGCBNERaIR0ZUYSUwlbiSWEBuI54kPiW9IJJIuyYm0iCQgbSCVkI6RLpIGSB/JSmRTshc5gSwlbydXk9vJ98hvKBSKIcWDEk/Jomyn1FLOUR5TPshR5SzlWHJcufVyZXLNcjfkXsoT5A3kmfJL5XPki+VPyF+TH1UgKBgqeCmwFdYplCmcVOhTGFekKtoohipmKG5TrFO8pDishFMyVPJR4irlKh1SOqc0SEVR9aheVA51M/Uw9Tx1iIalGdFYtFRaAe0orYc2pqykvEA5WnmlcpnyaeV+FZSKoQpLJV1lh8pxlTsqn+ZpzmPO483bOq9h3o1571Xnq3qo8lTzVRtVb6t+UqOr+ailqe1Sa1F7pI5WN1VfpL5C/YD6efXR+bT5LvM58/PnH59/XwPWMNUI11itcUjjqsa4ppamn6ZIc5/mOc1RLRUtD61UrSKtM1oj2lRtN22BdpH2We3ndGU6k55OL6F30cd0NHT8daQ6B3V6dCZ0jXSjdDfpNuo+0iPqMfSS9Yr0OvXG9LX1g/XX6Nfr3zcgGDAM+AZ7DboN3hsaGcYYbjFsMRw2UjViGeUY1Rs9NKYYuxsvN640vmWCNWGYpJnsN7luCpvam/JNy0yvmcFmDmYCs/1mveYYcydzoXmleZ8F2YJpkW1RbzFgqWIZZLnJssXypZW+VbzVLqtuq6/W9tbp1oetH9go2QTYbLJps3lta2rLsS2zvWVHsfO1W2/XavdqgdkC3oIDC+7aU+2D7bfYd9p/cXB0EDs0OIw46jsmOpY79jFojDDGNsZFJ4yTp9N6p1NOH50dnLOcjzv/4WLhkuZS5zK80Gghb+HhhYOuuq5s14Ou/W50t0S379363XXc2e6V7k889Dy4HlUez5gmzFTmEeZLT2tPsWeT53svZ6+1Xu3eKG8/73zvHh8lnyifUp/Hvrq+Kb71vmN+9n6r/dr9Mf6B/rv8+1iaLA6rljUW4BiwNqArkBwYEVga+CTINEgc1BYMBwcE7w5+GGIQIgxpCQWhrNDdoY/CjMKWh/28CLsobFHZoqfhNuFrwrsjqBHLIuoi3kV6Ru6IfBBlHCWN6oyWj06Iro1+H+MdUxjTH2sVuzb2Spx6nCCuNR4XHx1fFT++2GfxnsVDCfYJeQl3lhgtWbnk0lL1pelLTy+TX8ZediIRkxiTWJf4mR3KrmSPJ7GSypPGOF6cvZwXXA9uEXeE58or5D1Ldk0uTB5OcU3ZnTLCd+cX80cFXoJSwatU/9SK1PdpoWnVaZPpMemNGfiMxIyTQiVhmrArUytzZWavyEyUJ+pf7rx8z/IxcaC4SgJJlkhas2iIULoqNZZ+Ix3Idssuy/6wInrFiZWKK4Urr64yXbV11bMc35wfVqNXc1Z3rtFZs3HNwFrm2oProHVJ6zrX663PXT+0wW9DzUbixrSNv2yy3lS46e3mmM1tuZq5G3IHv/H7pj5PLk+c17fFZUvFt+hvBd/2bLXbum/r13xu/uUC64Ligs/bONsuf2fzXcl3k9uTt/fscNhxYCd2p3DnnV3uu2oKFQtzCgd3B+9uLqIX5Re93bNsz6XiBcUVe4l7pXv7S4JKWvfp79u573Mpv/R2mWdZY7lG+dby9/u5+28c8DjQUKFZUVDx6XvB93cP+h1srjSsLD6EPZR96Onh6MPdPzB+qK1Sryqo+lItrO6vCa/pqnWsra3TqNtRD9dL60eOJBy5ftT7aGuDRcPBRpXGgmPgmPTY8x8Tf7xzPPB45wnGiYafDH4qb6I25TdDzauax1r4Lf2tca29JwNOdra5tDX9bPlz9SmdU2WnlU/vOEM8k3tm8mzO2fF2UftoR0rHYOeyzgfnYs/d6lrU1XM+8PzFC74XznUzu89edL146pLzpZOXGZdbrjhcab5qf7XpF/tfmnocepqvOV5rve50va13Ye+ZG+43Om5637xwi3Xryu2Q2713ou7c7Uvo67/LvTt8L/3eq/vZ9ycebHiIeZj/SOFR8WONx5W/mvza2O/Qf3rAe+Dqk4gnDwY5gy9+k/z2eSj3KeVp8TPtZ7XDtsOnRnxHrj9f/HzohejFxGje74q/l780fvnTHx5/XB2LHRt6JX41+XrbG7U31W8XvO0cDxt//C7j3cT7/A9qH2o+Mj52f4r59GxixWfc55IvJl/avgZ+fTiZMTkpYovZ01IAhTicnAzA62pEH8chWuE6AMTFM/p62qCZ/wTTBP4Tz2jwaXMAoNoDgGjEp+RReTsiaTcgmgTxMCQW6QFgOzuZ/8skyXa2M7VILYg0KZ6cfIPoR5wJAF/6JicnWiYnv1Qhzd4HoP3djK6fMuwJRN90AED4/V759lzwD5vR/H/Z4z9HIOvgb+OfTAoafkXnCMQAAAA4ZVhJZk1NACoAAAAIAAGHaQAEAAAAAQAAABoAAAAAAAKgAgAEAAAAAQAAAi+gAwAEAAAAAQAAAJYAAAAA05/lKwAAQABJREFUeAHt3Xu091tV0P+faVZaSEoiIHIOJBcFA/ESKnYQwQwMIyqVkOBYKYZhWoqOxogGY4hiaVQShpIJJVqK4S3wEgOUbJQhGpnBOVwUNCss0O71ez37fc7kw3fv/fA8+9nX56z1x9pzzTVva8651vx8Pt/v/n7e7//9v//3/622PLA8sDywPLA8cKYe+C1nqn0pXx5YHlgeWB5YHrjkgVWNVh4sDywPLA8sD5y9B1Y1OvsYLAuWB5YHlgeWB1Y1WjmwPLA8sDywPHD2HljV6OxjsCxYHlgeWB5YHljVaOXA8sDywPLA8sDZe2BVo7OPwbJgeWB5YHlgeWBVo5UDywPLA8sDywNn74FVjc4+BsuC5YHlgeWB5YFVjVYOLA8sDywPLA+cvQdWNTr7GCwLlgeWB5YHlgdWNVo5sDywPLA8sDxw9h5Y1ejsY7AsWB5YHlgeWB5Y1WjlwPLA8sDywPLA2XtgVaOzj8GyYHlgeWB5YHngAy7jgv/9v//3B3zAB/zf//t/f8tvuVS0fuM3fuOlL33pd33Xd7397W//pV/6pXe9613ejfR+7/d+SUB2GVFr6lo88P7v//53vvOd73Wve9397nd/3OMe98f+2B/7kA/5EAL/1//6X7/1t/7Wa5F8Jrwrr87E7fuVrrza75OFuXYPHDmv3u9K3rb367/+689//vO//uu//rGPfewTn/jEj/qoj3IyfvAHf3AVSEHSrkTOta/zjiOhKwDrzclq/5vf/Oa3vOUt3/3d3/2KV7ziy7/8y5/xjGf8jt/xOxBsrwkuln9WXp1+vFZerfPqJLLuWPLq0Coy192/8iu/8oQnPOEud7nL3/pbf+uud73rzsW4o9Bxqe3gT2LBd2SZPFzVAbz1rW/9yq/8yje+8Y0//MM/fI973ON//s//+YEf+IEXxTkrr85VpFZenatwXDfGHDGvnHEHtv/zf/4PvIvxj/zIj/ymb/omcBiPWRx/wSFTfKCQhbwWD3C1lgROBuu1MILiDtUj02tRcfq8K69O3+c7GvfSauXVjlfW8Fo9cO15dek5z4Htv//3//7ud7/7IQ95iGd0ThCaFKE5CrG4yB3GLTzIBVyLBzh82Ll36/kJhLvVhz70oR7i/bf/9t+G+JwDK6/ONkArr/h/nVfHnoTHkleHPqlzz/hX/+pffd3rXve93/u9TPewdXsXCeN8hPGBVfiGW5oFX4sHts9h+dZwMMTCCL8HdI961KM+67M+y4O7a9F1yrwrr07Z4Vt1k0VSSNtLq/d8sRZm5dXWXQu+Qg8cS14dWo1ccd/znvd8/etf7zsL208m1CH5ysQ+KAr21bsrNHqRXaEHOhdcBIyfwWr/zpXBr/7qrz7gAQ/wLcff/tt/+xVKPluylVdn6/+VV/y/zqtjT8Jjyav3/yt/5a8caNlLXvISCv70n/7TZucGSO1xJoplGCcjoKoIPlDOQh7NA7zKt1rlp2vYnNx9qsengN/5O3/na1/7Wk8ePFM9mqJT5lp5dcoO31G38mqdVzspcSzDY8mr99yk79jkAZ2v0oVUlgIcf8VyhsNl6hjbVNrqH8nZsF9FBNtjOhp4n6aAO82xBzi4/8f/+B/RONBnIe7/IHe0mO3QB5jaSoMxrE/a8fYk19Iy8NisUDX1eZ/3ef/kn/yT28nP+9+rzSvxKsQFaJxcOBpOQHOIj6aKWrPFXU8UzF/7a3/N7eaXfumXRkMOQOM4NFpCDtPLmL/xN/6GZ6RPf/rTUUYPIEdrqCeNzC3Bfrh1wUcJyAZywPUwYG2AiGfY7NYDYfRRtmomDSPe2AOCzTa8g+TVeOlYAMmZe0nLn7k94WEGFnfBjV4/gQ5A9rznPc8x++f+3J+DiTgJghhNaTYCAaMOAZl/82/+TRKe9rSnYYwF0r4YOfEeY09yjczbwUupS2/DK8mrQ6vRrbfe+sAHPpAg4qYCDTD6TgLga6bP3bQhLS2MZxvafpBC5WQJmRdKC7PwH/RBHzTm5Qv0zhEPtQQPVyowgn/bb/ttiAtzHkQMg1GPBoArgfyQGfrIwpMTcHJ99ow6pn7sx37sLbfccnIaj1fy1eaVePWsEjCWcDs//OZv/iaAB3pKWSBEyr9hmS0WCATLPtQn4d/9u3+HBb6EQSkNNEM0M3WYXpT/5t/8G7pc67AnFlmXSVlINWkoDeWMqfCIw0CCW5dZlARC4tIzyVAflz6BKEv7hvBJRjzPadkfFySxhq2aOsLHkpE8wI46jNd3Xs3CrxHgKK52ehRu0kq8SdfCGjJdKMs6vOKS57fR+dmf/VlDLKYmSbrgQC+IekqTSQggdZBJ/vmf//ksKZ2wUGpfEEsO9mtc9ZWzt7ro2fk+8oqhBzb/3Mpu/O00gKUeSHnsSB8tJJPSgL4z9vCHP5wfKxs9QnQJgOCpT33qp37qp46DPv3TPx3y0z7t07heC+/70C0EHua5z30uGitKzl//639d2B72sId9wid8wmxseeA/TDPgm7/5m0c+AGW25R9ytARGf6K9haQdQK+j9nf9rt91ohqPUfgR8koGf+InfqJQzi76p//0n2bSp3zKp8wpIO/7VwRTRX8bMoEmR8JAkoMYjQznwNkwANJuuummhB+o91u+5VtIQKaRgBJZ9MEzJFlakimR9F/yJV+CkQEy7Yu/+Is/6ZM+acxDBilvYVBqFuseLrHWGCPJZOK1BSSwuBPSLAKLwuVyOAO4goVtFrOZOnYeCNzR8upAJxwNKS6f/MmfXPj0mn9RhyTNWTGnkEyYsIpI/72OuMT+s3/2z0oDN0Z7Ai51gps90UyF+wN/4A+EF2vparbdQf4P/uAPkiDuGnpahNWXbyVDZGgcpGyrJedE+yvPq9ueTuy3hoOmGJi1bNm/n+ykMcKTiuoNt7Lqh37oh/KsImFWNTLUXPZG3BZVYxoWMMcBv/z+3//7BWaOrc4Iz16IpaJ4+9UD600mFT/yIz8i2KKYtO5/PeoxHPOwaxGcdK82d+KkiF7n10krPS75V5tXsu7jP/7jLZDb2fCGN7yhffXyl7+8/f+N3/iN2VbF+jN/5s8YgoWvzWzXgUW2bBE4Q8UJmf8gBhNoA3OpaBpqfnbkML12u3qA5k/9qT9Fwl7Y3xP68qHoZAPzIHHtCf7//vbf/tuGzh0rgmEAITBlbFdXMM4LsxIb7ECRfqZKMH5wwdTlVB6wNDfHcjuZVPzAD/xAJ6ByS/jNN99MWp4h8LB2h8qrw5xwtXjuxVIgJJUo/Pt//+8LhOfnLhfABQtZlyBlcixTb5AJa7XqKU95ipz8oi/6IizONLETTYlUXhVZh5vgOrJsqM6iX/zFX0RpqBDiBXvWR4KdAkk+U+0FuWeq7DV7Cu3K8+rQapT1YytHcPQMTxRo11HBd3pD18IcyomGmcHRhgWv8uCMQGnWLxQwPuLs/P7v//5CaOiyQqRVteTYokXa1LaGESWK9rlZCZF2jJ7SYBwLORosLTKsdEnpyfWyaqvIkHknp+54JV9tXtljXSLk857OMcmWE2Kt4wCmuIsRuBMcptmuOdrAwXJmgoh+4O6V7fzD9PJ81cjnRsNFgiZdSyqw8pPZ6CPrgHjOc56TBBc3VUTEFY/xDAK5ZyFWZ9ZaAHP91GlS5juMkHUtRcsrX/nK8tyBiEVWGCp4OWHHWpJ3GjKqB2l4HefVLPMaAV7tfBAIsEZgvfQrCoMUVhgNjdNGDrzsZS/LAOnB212OuAoROEfc3AB0Ehad0s8JJsqFeLuEdJVsSo5hyUAXveBExbKFt0KOF77yvDr0AaJltLEBlsE71hN8yZ0n1lLBTYC2lt5Q35VFm1YZEAkbnuMUA7CGjF0Yhc0zN1OZef/73z9YMDwGRMZBVazW6JtpKFN33/veF4wGV4cLTJL1PkujlC4nCEVuh3HBmOIf+DSeXG8hbM5Uy6SobXByGo9XMqddVV75nEkU3CtgbLHZY+287THImHfDDTeABeLf/tt/y0tCY0gXDGLhFiC9Ibyqlg/tfwBRGuA7vuM74jpMLzL5RhQ5k2AsxKWFN6QRgRMnsTA9tUcQpQzMtuRQ7a4dMUYrlXuZ97a3vQ2gybE8kHaY1EGWsRh5IJN+7+/9vQBTBIKlN12eKKBJ+/4ePZrERmaYxv3E5xDDVAa3auZZCFefgv003rL3qa3TiVJD2sWUD3OjsIp1Hvu4j/u4AAdRxOUDLpFiLUYEnmbDKEXlsHv6QiMHcL3whS9EA/iFX/gFZLYA+WWgYemEEo2UMywZOvE++qM/2pRdoFIi7gzMpBPqabnyvDr09CSFfRNOiwfrT8joEdvubQFpn/5f/It/gQyBPkt4k539fqvY45oU/Jf/8l+2BMRzdSAYfSwkJORg6UZY4JEZQiJIo5+Dm/UCCrMpt1PIPudzPkdf9uCl2tRohDmhlklj2AlpOTmxV5tX9773vUX51a9+dTuniDOP87V//s//Oc8n069YFTj/gCUuYlpQkHEXuKsW1zGGvuFif3ok+2Vf9mVk2th+op4cz08SeJheqhHg7azpFICBJ4dSwmUXjP6nfuqn4IkFRy8/2cNOZIxEppW0P/3TP43SFExP8BxGd7vb3RgMQyNGLM4+PXYCAegBeeBNb3pTntFrkLg0V9Po/eRxPmx2p0cAU78zdSGGeaAEaCE5+aSNFxQ/0EVXsRYR4eBGrhZWgXNqiX6RdZ0Eo93nPvdhGGLRKZoAXMVUxLEjMyUT/EQyYoeY7CKnKzD0ygw8vRShBJMQjCx2mFSkC97xxdrHPOYxprCcdEvLFeo6tBpZDNM17tYz2sa7QqHXvsKyKocy4NGPfrSHEsS+4AUv0PshVxcIaJwveu6GbE8y1a5zpggn4uR4bovA3atZRxX4xS9+sd4HQj/2Yz8GKJYA9M961rOIovprv/Zr0RPi2oQNMAi0z/3cz0XWdyXEHoZn2IBm5OwRnlTXeum6zOFyUrqvWe7V5pUtV+h7QsXJmjz0yLSr0T4NYpfAiZfNBs45BUU0YcC4NO/mMEQpdk6HYMXJ0U/Ua17zGlOQh+l1L1UFIoolQkA+IC7IgvIH/+AffPCDH0yOx2iQzhRff0BT7OQtGB6BKujXNFxBw/jIJ/ZnP/vZlvDkJz/Z0DJxfd/3fR9FHllnIY14c8U3fMM3ADiWByzKQ7xu+MiXqHrbh7QeROM6rGXbHSSvDnPCEfBSpU+j5Z7CI2SuaLld/VA5+LMcgP+ar/kaw54Gi5eooWxHSD+xQwPZqdWNkSfGkKzSo/TA1pUZGkM30D3F9fA5YkoZgAY9RQRi8ZkopPuk8vazP/uzzTL4CCs9GstV5JU9cGCjWPbPVDA3DeaEAC7b6h0tnMuD3C0SbOsZiDAj6AByBdEmh2FnT05zX1FMFDmQ5BR7gQT0MWMXHYi1aASSKM1TWndgSSuHxrBTBhhD49ZFYIadshlHVsfUHeOJalEHyjTlkvARj3hEzteL3Y/+6I9KcfRCb9iUqPlkSHzJb5fO50ZliDPaVE/zbWZbFLGt204mxBWGfEjgYXrhXcSMMdmcUr1hV0gAwz6pLmP7yly1M7PdsiAjUAN0BzOSfcIE2TKTUMa6mUOTnGQaRgBQmXBpapIhFs2KOCf8YX027ISGhMPozxueqTvGs7BFnaiplDqytJtuumnCxJj52mefcMNIM1kn37KzixXfdMi8vmnSV3J8zo1eyATOrFD27TsZK7H74NNU+da1WqcTFgLdWtFOgkYjCc7JGQawQTsF/1xVXh2abYxm7gQy+BSst/1ykx6sjVLeH9iXEVjo9JEHjJw61DCzI8Y1yOI3i4KPptUVV58rwndTnNjgkYZ9R84IPAVga3DqGM8Vp6D6WFQcOa+KkeVr/D/pMVYVlEkYZKbiagrGUBNWO7asmFBiNDXSBgh5Sevt/+QAEy9MZGVI8AjcSiC8q1HHTQT6ST+URBnu593BZAxKDVe3Oz4QStfMJnDMox294WCi3/ZNJWGk3RHyauuEI8Pjva5Fio4cg+fSZidJtjE1tTMcUcXC7LDPV3jYGRJQcLMcvH8JJBBF+7Dspzk5zCxnVDDmsLw69EkdhjNpyrtLDJVfD9a8k81HAoo82FWDxbg4fdWrXsU8D+Vc+gFcNWStIe+DLb4rC4xEiRMkDGAIumwksIualKKH73o5sakwmwr0aIJXfwoeEMo2eTEViGJqCJhoFhRJIkAaMjuQeQiagmlKWD0hmbDaMGgwlgaG1GE8UC8JyOJNctIIh9fIMevzHhiAWzFI16o+yCTz8Y9/fMbozaKhTosYsuXkVXgYZlDaAUeUqbSYNQUmR1ZrzRqiIVBLWjSGzsckr/54PcC3+VwygAtBz+s4vwjOLbiYil0GABCIryFYw15Yw0eMALs2lGlEj1jK6cvG/esiR8MbizxBk5z6/SxnhTl31YiDuLXG1/zyu3/37/Y5YT9+80f+yB/h+h59+gKCJ7bCkH8BWo4uqOC2n4hquVhICh4gRqGa2GCkOsrpEWzhgjqYBZyoB4SGw+0lEQQL0IRbHE1p8NWP4ghfuNu9hmOhY2KiWaAbbmmoiJHk/XozI4FgeqsTcg+jD4HY4Br2He94hy95U+FTRmQum8y+6U1vuvHGG/Fuc4wB2ZBMU5PGgwd0zLV2AvfWfakqsxzSurQk5ArqDFvXyHE+RrP64/IAP080BQUsAYqgvljwf+FIKQIYUUNcKPWmIAPIiTIAMoEINFMpikXcDZMZ/ehKOyRMEmhET3WU9ek6D/1tX0ncbwpDW2FT1sMRlnTSC0jR2GNIY0q5ElDAHAH2Z2TsDMk8DUubkNMB8cID6nGlZYSTHIupgc2CaSEHXhQTzg/JTPsp9y0h+1MNnnw9ZWOOoI7rjpZXbnS2h+lOKMcVoiNqHLKNUbzDgrgolwCGiEUZQXt7u64dvabYr0362fOKFnzS0ksUGsZo5SpMirbCKaURZoCZzUI9jOQkjWRCSvUhg4Hf5gNRLR9LWW0JtEAmc3i3wH45d5C82jrhCPC4lAOLgnBAGvK5EBSvgKJZVtAVCwCmtEGmlYQABEM8GTLphKBA75iNSyNQC9ZTXZZGvE2YHfbjHWbJVt1l8uo9V/3Ha8SRpfH+8FrJxAnS1uJ9m9965iwAawITF3pkRb19TogpIeypK2JDZHt8tzFisWOTUE8CmkoROVqM5daWcsEn6gGRFQtNKepaj7qQRVaYAiC7FZ4EQGkPw+MF2JyZKhnQwODd27OX8EIs3IZmCTxML0o5MGmAuE0OGEvQJBYGTKzskj8ZEAw/mOhLMHDLZCGMPoBG0vRcwTZk7I+xhYBr6FsXIIzlE4VrMLfTrr/X6gERKRyCC9YLED9LJ6LLTEChR1B04JHBw2iGTqcZRiyIiBOOAFwQpRNeNFryDQMmJUqA9OJCgCt2fbk6eYjsnLTb1rPfGkvlCKtqyhrA1gy/n/gYMVsVDDAUBvLBwjaK4DOPVTNVkCLL4JnCmOTwwkYsTAsEwA+jNTYc9rjq03vSfpiV7gDbVTSVqfA7lOdzeLV5NXceO8sR6xJDKNv5OwSGQwPmJS4SYoDGDPDEd4CEGOLdXktuhWOffZHkkmFSIr1Dtn8JLNEIQQMgBG/DJMdrypFhmdsFEo6+tUdW+YS0orIaDZZmwQCHEYLLNLrYEEtkYAIz7zKM52SK8W3MMZ4nW9RJW0gL1frxOY2p1oMnMUSqrCsczeItmrF0bVE+iJ1VaIQgwwsoRjOEqcWOBS9KZPCk7aQxfFOUIk717TKO/29W0dgqKAAfllfvuRE5fkOOJJGtPKhldLurKOqJFAY9j5tCAy6oTRUwNGXAuGA/pnhThFFUhnHkDBKmlrT8eztu/T1ZD2z3knBPrCf625NalLUMQommocwRu8IH03ZFVpKUaehLJwSS4TC9uBDIDcQlD7HkaPBh0ps69IaZhEUD65vVT4MHRwkozRxbZebcF5qadYGJQsPaocyYkYbG1Kwu+as/Lg9wLFEiUikCS4OEC01BHGQx0kdgFrEANRQ4LOSIeEi9hmx7FoUpKzCmBYBdz5KmkBEuMRBoqZBF8Gg0YvXhz0l/uWrEblbOlrOS/NXa9Pm9obVFuX9hEx40ZqOHbAgzALhICEnaq0DFL3ePdsR5PO/DT4QAhq4rU8ewoYGheo4weMMkJ5BMjUkjDQGM2drAWZKFTW3r5XZRzaInKi6YIRi/mR1kLPt7pqJnAzmJGnv2E59PTAa3avCV5xXiiZSlja8CeEPIwHuOuXT3Ewal/MlXPIxGg2RAyA76orzd9omFhxy9WLpfIUEW4TULLtlmezM1fBpTBDmrnrQheYSTo2VPlMhwETLVcayKWE84gq0cC4RsgdEjIwcyvCHzBjbEjn5ootdfoMZ41o6HrzyvdtbImWFyHS8Z5q7g+i0NFkgGaADE/MkAw9JgooBrImhKwqCBxOVHy2I3LK8M5ZWpMjbehGdkStPV7OSVYaccIVoyZVEEnmnjmpWaDR52krUtQfIhy6umxkXh0TBvYMOryyviDmwEafO5sf08O40CUzPcI3xPhxJBjONE05AzjHc2WLOJBee7aCAbpoB/q0wNE4gyACWZwRin5AASvuXdj0mmvql+vG6E7MxuDQBvjcwAfcAwAkhDmfyR3BB+XApzWCOE2FlIfkZ8YBDPITJvnFxe5fP68WdKi9EWOW5E0CxPRhxmKy1iBGM8FgQFDr7hsKMfXckp4ign9EM8emcW77QhA2x5++07SJT6ETI7i0nM0Jo1RKNviIu0WQ4jozS78oqjihpvcFRwfd6Gr+XPLXLciGC8fTv5JcxW2kRnAhGBnsziNZYQgn50hb9u8upyd2rOsi6XrBmsGAJ4B7IkruyPl/lIVayZ4k2UeTP3NRxXEmiWZH1tRAHIIQGAAJzfI55ZEtDQRSYJw56pQwbI5hE1coYyYxKiT3t9NEkYFSS4jrDtx05TUbquYW3LHEUxbkVlNjw5ZeQQDzDqtgD56BnJJHix2K59S3k+YatjucCdRF6N6wA83EYF0OV6cF7AmPPR7KRWeBEZryKIBjF/MtuwzDS0kMlMQOx6BEMz9GNSuVTKDdkEqyQxnMSYKQAhE26KwDAl24ECzZaoIwSmFYUZLSuvxIU/RSR/NtzZyLzH7SuvTiKvDv0Wg0Ldw4dSdnZI+00wfAlE5ApVyEl3+PbzYACshwfYCfp2SJjI4GkpzG0YaTEsYBqdJsio6/jGOIaNELwdPa4cU5p5O5Tot7OxD9LaVRraqeu8mDV2lMQ7XDvCzZrCyxJwAMwOWexOgdkArRdZSkf+AEOQ5IY7wRricwjsmDoOyb3XnlfjNwLBM9y6gsMFtx5eKgoQ1VyaPUKmmYrdLD9rGSk3rAKX5EdgdrSAMaIMDyaTnJBbG4ITuO1lF7EkbInHS2YJJDyB+1MxyvBJGF7DTJ1ZQsy2hbfEY+1OsLYmnTd4x9RZdb5deSXo5z+vLt18HNjs1fBSU7MHxBUGYB8GWN4Eu/0jCdq6FZUkQAIIiRGApqv7CAwBNOKKmDSK9LG022HMghNOtSHkaCEhRlP9spMYEB7NHBAMwGIqXVYRpgW2kEoRMlzhYyct7cjgMTabBPQINLPkpxeQhYNpUSFTQSYWjUlZReCBLRUkp6XhBGtknltgTG11FpIDAceSV8TyjOULa57MFWkJNgUQ4oZS0VlWsPR7EbiUZsIRAThR0SAmzSw8gvqhRBPmUjj3JMySo2GeTMieLElseThcEQ9L9PIEO2O27JaMrFUTRV1k8SY8GoYF1NMVVykKRqzPbMCO5VuTzhs8plqaZiG5CLDyikMuRF4dWo3KSDknqOVluau3eyHbcvIevJcAlxYs9pPxUhzjZK3Z2XsAZKULArCMqX4YxmXLETv3QGDHB/kIwHrsZALanBkWpo1tCjvhnTumwHqtqbe97W1bXZmXZCcOwCxdg8euwZPgAhmeDc3qExVB8vUBmc1Xhu9+97tHIMtxhecuukhGrO2pOqDDAkt7vARGdEnTRWg5n6VcZ+0OERiA/ljyihwOKRZzKCd/3MO9pRAfhsQ1sEAUoCKSqcUXWfQkg9MyYq1IXKKRz1RkCV5Lu+WWW1KhZwAkAhK01MUyKtJLJiFlSAfupeTY+1UhcrIBgSlDDZdsB5hiDOEhDYnSJs1mIQASkOlXXuUWPY8VF94GGPIPf5paeXVCeXXo50azXYuEkBQn2QwQmIbIHNztk2Fp89Qjw2sbmB2M1C/GZoOrOmhIFnj4essuCUajKTCBFYzYIafZ1QjKJNZSZI/N7ADkU5eWiDFmBvZYzGps0ENapq3+xje+EdxaWlrskBkD2JrN1AiopqIvR0AiYwAJ8BgJ3K7F1Ji6BaK39ghioW5Lc57hMZtPeLXlMPi48oooMmnZxqLwbQOBzMdIXQD1+ivhyG/5lktLBkimChwgzK233op4YgpPHXoYqumFQaAFRFAqgmcXsEqDYQmuUVfywBCohuUxsIY4llaXZH3XWwDNFNXI2iAwCYx9j+S2j1HDb92y8op/BJFPuH0ixaXhV16dbF7x74GN9+GLSv2QGUp3uwvGLtV3aSa5o4kXDCOQgIib9dZUBJqf0Pez2V505jgA+0FieeAFaIaAdp2jH5cePYA0MsFo/OoXwCth9HbyP/7H/zj5O33WhuzH7tB7k7yeBAK9KQec8fWdjFi8XOTTP/3Tn/rUpyKwZL8Gb71+jJlt9jaCDDOrMQmGut5ZAHPzzTc/7GEPIwTesbJHdeloA9P71re+1ZsFvKPWURINMo32HYeHnx4veEwFkzyz5xzI1Ba4s0zDa88rEvgzJ4jOHNNgjuVnrwvqVUks8Uv73Oi9D7gMObYXMYA1b6AgR8RlrIQMCdOvcRumZbsKcHi65lf9e5+Nn1U021urC7E+CViofstb3sI2GyFFLDHbb9Uns4RvX0haswSWbJBySbJJQqLsKSxRSjaUFu5NBFbqhCUnvSVSPUzAyiuumNCAO69WXp1CXh16irVDytqdTO1HLGYqgK0aWDa3eQa/BewKsx0NdjsYplPDBsPbC9A62fXKDExcal6icJmysZ0RfqLffYwtZ+/ZZiR0OiAOwIJeetHi0s9GRaOG2ZbEms1sgHNnbxGXVoFFTwugd8l0FkAC6KK0lb7iFa+A/Lmf+zlIAGsBdIG9HkntYSfJ5PQuk+RQlJy3v/3tvXUU/ZU0SpGNzcFZO+zReLVXmIbgZz7zmcO43W9gFg4x+v3NesefowiAMd5YmgoD/uqv/mpcoxSGqdthMF5TV5VX6FtCuooUtxt6z4grG5c1nM/JKDudYURc3MWFXsSMofrnf/7nnTUwXs0AQG+xCWR8ZHjhvTHvEz/xE9/whjcocm5oYLSWgLKUuNOd7gQZu7RE5p1DOxcclI7/wSlFzB5XPKaYDbaW5OzpueQ6tQfsOsYqRouUA7ebrBSM0hkKIJMTCLRwWqwF8sBWCFpLBGBy4JnRLDmWKYtGAjykFgE8Lm0kbCnR7G+H5RVGxLFv8zbMV33VV43kAKaOXpjgJKy84pzzllc74bstiAdiIS8TXbNthg4CgZejyQHsxD4a+YpMctiZT3/608sSvctM+8dxAEiC99q5cQnWu71QDG699Vb2GJZkYLtrNmpIF7xdTg4ZpcmJ16xX8HUbBw+phESQPa0ig2OpNIbHOHdyHV42PFPTQoLXavnZZta6FiYWXnNt6whA6dIVMlNdpb785S+3BLP96nNm5CKixp/ht32mJme4sjZ2yCqxQm4tRMUC6UxsaivwyDCxSbbM17zmNY961KP82vqHfdiH+YX1n/qpn0osw1ilGUYcZpRupyCvPK8oHSFgZ/FTnvKUYhfeZYqbWjAk1RIJjULCgHipvummm37pl36pejPSBkApRhJSQDO+qYSAJzGGBYCLRskm4q0uJC1jHvxMNasfMyJT9tSSqgiDVcpSiFJDm0hlcsQAHOjYWagGu6SDd4MFkxzJ5jKIcAIhD2stcGsV2Fqi3y5/kN7q8shHPvIeew1giHjWiEWyxX6ZfN5vD0btsLyFp0ImR5DkTN0xnmRykr/yih/OYV7tRP+2Z+Uy7ArbXqpculxyB9CTbkez6y/sMgPgLYR0yAw0enlgCh4ZAk/q73e/++GF1Gum3LJoGWCn9Z4IQ7oe+MAHYpTWyIiNxi1R6WWDwVQbHvSgB6GJAAZgSBqAUjsWy+/7fb+Pzc0qLdGzihnI9OiRDQbcM0OqwYw0BWYYIQ6LF77whb50DrY9HFvOKbrYn3Z4lmN0pqAkP2nPf/7zXWsbarGj56s2D/gIjWHUtV5rJBmG6j0ll1YHmTEwLSF141U0MIe1TDK7tTPeF73oRX/yT/7Jz//8z1e8XVh8wRd8wZOe9KS/83f+TgZgZJg+vcnZ36f3yvMqCbgsqsU+9KEPtd6RzNWSxxCg/5iP+Rhm9KFdjmIevH+AJwTQWjjQJQKBcQHMSi29hSPTTJX5APQ5Fj6BAHklH0pdQ7xe2VlqpYUBWnrhy8OmaDEkqiDmbRjl5Fu/9VvZAzalsrqMI+TGG2/Uo89mvas0zs9IfclG17y8mElX3kQEMbHDkuVuE0X5yU9+8s/sNYAhZCFgNhYwvWxjBuDAllhTrTQn6LFrZnNvmQxPFLygB+jJj2ss3AIpXXl13vJqG6OBr7oayUWxtza9VsYQJ94OaxjhByOTRhHbb+kzNOWOxFAO6fdkXGLxQMNUZLbZiPVQglgEKLGQgIZ2d2BoSnfyJaVz0M40W/4lGQHi9oOp17/+9fqesfzkT/6kIwMZOZPQ5CCw4ac60qghQKakmSITBhl1NuF//a//tSXr/8Jf+AvvfOc7e8yCINXW9dEf/dFPe9rT6GohADdS8AQii1JPOMkUZcbezJV2eInl86SRQ5dNC0iLoanWSwU4XcGpGQzkTotAz7YhAwiQxyY/8RM/4dbkwz/8w3/P7/k9KtM/+2f/7FnPetYv//Iv8xsnlAAA2kfODkCU2WgyMgJeOjCvotcLIlOxFFwSMFoyV0gkeDQIXBAwwxcazRoKIo9FZhjSWxxxOfSzxErZb8qzVjSGEy9WtShIjmUDMgJp1yPmeQkJqZHm3pFGsCm8AJRgU/BpwYKXQHgtV/Q9C/Rqmzt79BqN2jOe8QyMLmtaCxpIs6723A8xNefDuFWyLmmfc1BeeWMSCehJa/mG/+E//AfPgV/96lerQCKuAQwhBR0BS2LhfCsCt6j9/ViCrEihAWipSxSZ8aJnUlwI4Gc4orYAOWhyZkKaXXmVH84qr7Yxeg8sQgc2FBNCBMEyQ07rNUi9fdheSkixDxbvgHq7F/2te8/cXOjhsvlpsdVdzfn8Fpkac8ve03MHOgInnRw1ixElLma47vNEwuFit1P33Oc+F6NPgBFgAVOkDwZo8jjAviUE7KMFkqnernEM7swyVV2JV+q7naI3Y0ISEgBpljGxWCYzPLhjoVUwhnnJR+mbEV/3dV/noYrLcOwUZXOiLt9jj2XIsBM+w2aRdY5EX1/1RWAYBtyWjn2QDXf67ay10Kv/tm/7NndFAoe4Beolyed93ueZYkNk8fYUF2YkB5s9Ql5tQ1wCuNAh0Cd5HFsJkTxOeUG3dqExnGRgw0033eR2FpADfanBw73EgiGxCJMglioegmFBkG8xslxrOS1/YgGQLab6RIecJFcVYok3FkYOL0pJ7l4TAKnHNbN4zRLLPBmYlnYTDA+0RkmF0TcXfE5mW7l3TOmBfZYUjgjAqTa1zU/Cv/3bv1352S8HUtDhcwWAAfqt2P1c48AYEWMPWb8/bxXXrRxkTN1qCYZfeXU+82obvoHf6xQbLOCw6JrapmZkFSFwEsqhYGmxPe/w+hAFveZazwmuqDivAejLoR5BkGbP25AhFSEYzRcQEDtEnCwevLgMJEqZmdLi9KFlvhpg6AKTcIB9S4IN3DeX1Ax40aqoMDtdkO1nexs9aZrZvrMkv9VOeOwJZKehCodR85i+W6ubb775EY94BBp7MkpiUTrpkNFLIGCr15AN1AEObPl27EQDJrPGFQEUWVTqbp98z3eLYZpC43gdAtse/sA2NAGf8Rmf0appRD+zBAanPT8MknyzO8ZbQovarjoyws2Cc0VkwTs9mT/2Yz+WJXqxRqAAZExXIfJQFBgTr6A8/OEPV8YQe5KGEoy3dTnBzTrxEctYxx8C9hNCF/ptchI1trG5Bb7uda+Ly30w3speVXOMr4pTil0+t95OcDkm/VC6dmG/WcvJn8h8YhSZDyBbo5tvlPYLFplJZnhLIFydLtlG9Q6Q/TuhIYFqfYEDF8qEtzqYkA0R8wwLP/MzPxM8ZgAObGi2bfJqi8yGwRCubYfBO8ZbYItaecVdvHGu8mon/RoepRoV9S5/pClA/lkqvLQo9o7sWX9eMETg6vKRj3xkum0w9MH1ZQ96B0Tw9iKrK6bJLXs1LxPbFdAoGplDDNPsCEx+lMjMtq56+C3vCBx6FiYKmTbsPm1WLDsNW6BZXKN3R5QhS8YY2lHuX8hwRTlGwoN33BjxfuRgEsKwLhSykJz3qTfJrQ4vwIdG7o3GvAE8r3vJS15C4xicFpgd47EMDThHvc+8IiSuWFh+GePTOH0VBWMmAfA2SzsguAuarW3ww4LL8g33NN/WQQ4ekJw93G26LoneuzUkNoMbooEJzr0wEWzlRJNJ8O6H+voPFo/sii8hGBk2klFeJv3MasncsoATOGa0qSH/3t/7e26DdmQaQpoiCjxGJv+wfkvWwsurLX1mjJGAwQwZzI7xQx8+a1deccsEdDwmCuCJxenk1cRugPcqBoMFXCa6ZuV6Cygt2qJq0khowS2vHVs2wM9/VMgM9wdoukJMbBKGfRwHP7uUKDJVo0nKcasLtK6bXIiZjQC9Fo1+ZIK1iQEV4NYSPD1gKAGGYQIIDNnh7pbI1RwztO7YUtEs+akYvdi1RJkaOMxOH9fYYBZsmWFGJnxrB6R3iwFv21YjCYe1Ycn+hv/xP/7Hu9zlLl2SZ4MwKcOQvq4mCqMdPcYxNfYdsxHQ3oqi1x+WV0lAvwNknloydk6CoYzekg9jzCSU2MEoNUMpNIqisRZNlPXuDwR9aKKcnq6EpBS7lnnhRzIAxtSWMlgxGCEpIsTHdQzo7qEne6MUkArEJIzMLcHAo24whFuXIaBZMFF0+dzoQz/0Q+X24AGGkP5jIQlN6XM+4LA2GrN2hpM5mTF4QJghIBmGnUMTDB+mtc+KUrTyKv+cVV5NsAa46mpUakrK4u24aTeWH22SpEegnySb5EBgXzXUDwA5GdbGS0gCpxqN9QFRbmWCKe1SbisheEfyEGS82QgIybC0nJM+k8ZmVoFzPv9kuYVwo9CYnbUAYIrF9nS+9nX52P/ud7/7P/yH/9BJ9Ku/+qsvfvGLb7jhBk9WaXRxQP7EFHzYqWFd7NdbjjZH/A49Ai2bJ9nQw1BnSt8QZiijNxWgp2vIyqu0R6PXItBPAmOE5z2S4XcMGIHIwNowZgleQHA0+mk7+KxqNjhpxIYcesAgRxpgzEvvdmo/nLStHPBl8soD87vd7W5//+///V/bawBDyP2Sj4Zhc4yAbd5yBUyGIWBk2bWTJy0kz+i5Isz7PK8IR5k3yN/60NAszCC3BODhilJf2wokYYdshgGpuJ31tusJQ9FPTgvZpodZXLFEFr0+Yv32MByNMQ6LoantLMw1tqRlRqLAE74d4VddjeK3+BRsVzJTkKM4IN+xDFc9/ADg8BFPH1exJ1MDF068+bcwZEyMprRkhkk49pEMmPiBiY1raAbYspwHeGdpTLI60c3g7T7ZXvqZReb6PfpjXAjJwvTa1772sY99rH/89PWqnf832tk2h50a1pWRY1sxnUo2AIE5oWTYoc8DRInvNsS+mYJyv/dgxsJsGIEBsQSPe7eUIcNsiVPHBguhouVkUjDiUc3g6FNUP7OGW9jw0tr2DiCi4o0lZD3MTNGV0sj291m+pQFfPq98K1XQ/ZOZBjDcL/YaMexnxk7eWt3ObSjjD8urDMDS0hK4tcrUeCmagjWJhBjcMAIYNBISYy2B4+SciQUZgmbxhocJGGkNkXWmRT827+CbrR/G0mPLMgTRMCYAjSmqA7bSYJCZarHbqSPDKZ2VplqwDhR4MBbpYdFlMZe1kjTNalMwi9yxQPBMzSziYR8gCYZbsqEE5KYyYOR3Tl3eiRgnLfbLT28RDR7hDc9Pn6+25oEFa4vPe895znNaacT6vmdxKQa3X0kdy7oKSgbsSP76r//6rQqROiyvmJcEV69opjmJlNWQCKLRb/f5NrjUNdTvLfS9LnVp6SwgwWyWY0ksIF+1CrODbxWzusGPhLIrvH6SDUtLayr59fGWvdmAxtT2Miu9SUOZ8RE3VZ/wzBsjZ1+QqaGcqS3vVkJkYcCisDU79vJquBDU9su8FgxdGaPfn7f+tTlj9LRTxNQd4yFNIbja8yqBE8FZRZitlpkCUDShzLZmMyCZW3owpDQuDYgdyZNUQz9TAXrGIIvSMC3ohxJBB9pYZbaHIjtL21p7oJ1jxhGABI5VWShYB4q69DBndv4WsP+JmKdwhIKH2Kyl+uAHi8V0GY7G0PERBjs4xuAhRkCa1ix8wAxhQtJIF8qGGF0WQW55Obfn5hHvsV66V0DDAMPsGeEDWAKaBCKjKEpwBgtk32JK5nnoW+MsgUlgy4Qf86wdDJnfwGYji3HLPlxHA7aieM+QP3lS3suKvmc1cSl8B+YVFnjffrTBsiSbCZxqhKZlTsRRjgGEI8iAnbVM+u3gGzJ1/3uzRmw09Gr8uU2JsiVKs7RHHIaRY/noxW7XtJDoR1HS6knDgiAhqYZBXE8yWGuLWeB8pQ2MkalE6bXRfhkg+wkc+oRnSYw7eUV++6tZell1GRVHmKJ91sgwMMxWKQwzrN2SGbA1HjzGm73C8yojJeGkLiHY4ekiE8wPkAhg4CFhOoIiiyUD4k1sEQmDBkH4+lGUELPMsFiNfD0MCVsnZ1L9iCIHTMsAhq2InHLSVPHa4R0hxwW0qK0WsLVk246W93LHztyBQ4skzhSJEQS0eDB/WecQ5PEwkO0iAGs0s6Y0QBjCNTAaSHA0hlSUdpDN6jV5EIavw+hxZdjEL2mmCKcRvmoaS7xF2lS8560UzeoOBHKCpXGItqUx1apDcsV29lpgQcGefDDJekPne1PboGw30n6leBHbNhprDdGLeMkQvdUBtqtD1sIRg7WRjBivYlNaDh5AhT7JZknAmFhc2shBw6qWBl9KwMC3nCgNM8OpJ38IJy35uEY19tyib5lm0ROYND05ZuNlW6qTQNfohUFsFn1HJyGQWDKpRcVIhba1JPyV9K0LrxVpIzDtDKgZUnElAq+chmrrHbOtq6WNhNY+BIMfgG3Zzy0hA+BJBo9bwqcRZc5EBqhHADDFCTncEDsWmACzWVj4og82xUVmCYQBYNTgDQPA09zS0UKp1RGOvh4Beg0+XfUw8aY0s4PhM3iEh28XQLZYABXaDIf+dID3bN0r11fYeDbrZ8Fh9HPKc3Fe44tgLHyHZkKLPQl6SPQNC0/ZD7mNVgYkeczmQVqcBYLEywkxi0xvCChs2LWsJR+92aKVkchin2iNlvMMWIg1WlpGyioAh4S0XqsbtxzXQghM72ghmQPpKnbBW5MOVI3dfQNidmK0CphaK7Ics/GWDO0Z2hsiZgziFo4SjKafMzAVWdYW7rwhXZPcEFka8UqArV4ECY++FKIIC0xI9ca3OWaN1JGWatLyCSEwbCAQV0vGYqh2woha0tKI2OpSnbQ0piWZvBcQkl7ycVGqT0vrGtuuEMhjwztmjCIEwUNzhZIvQ3ZY3nKI5VhsvIaAy+tttmAxPhZcYfQ75xUCruPMouYfp3jvBS94AcowJV4GoDTLySPWEBml4xYGg+MCF/eCEjHeJJM5wvsvSYxElcMZjBK9RkI21MNbXc1syRBxlOBZFBbSMp4zx4GQaLSt5FODj1KNrG0czXqRYK6l1s8UIF+0VH7nIzTYtbjQXPLr3olmChKxIRi9XmwQ0zLsYfTIhkYMgiUWCdFnCc/euvcDEKlmEoHgGsbsBMCkxX/jNjtBuo36fP8ph1qdZUo19nIIR4VEkG+3HrjGNfFeIeM6J0jSCkcpQSMCZJRexp9mbbmCiKXMAQQTixcyCZFZjjQgWbixoyyIhujTuLPz4ZEhzrb6bEZv6IIUAQyYfOz6lE4qmiVBDxNv9mDRwmcYPN68AZ/BgPITMTkI8tsb9/4Lu6gNJWNmdSgZiR0XyaM9jd20tWp9NlNBoD4LUR6hMQZXS07gVghF6doirx2+TN7ySYulheqWfBmNLM9vaDjz8udVa0GvcZr1+glgvV+nLbvGmYalCkpOxojeCzyp4zGzMDktOaVlUcMYL5PMIivKs4pY4AmhEb4e3vVKcAJjiRIGgZ5J4X9x7//906W3dgSjJYAzCWSwvn8A3yE4vaFlHNhYYEkzFcxcLaSFWYBmGDK4WfT8Puz2GxqYW265xf/r+TViXtZ6WQMyQBiu9G/wMP59we+7fP/3fz9LRBemf60XePvWkAq/2mC21HzT7W9twcjvmYQG8PCHPxwZyQxABq4JFTkPe9jDKAJofoaVeXrEaBLS1DnpZ11jjzUy1VBEQm4DAYNg+v3ssVx7T3vCRztg4PEkU7MnjcHbWXglYUszYgUFLJfEMYKRj8vvMBVW/9D2qVf53qyMwS49XLvYsX4D11Cy/aN/9I+aHSMbUo0s2K9vtMm/7Mu+DOAfUeHloZTOznouItOUxLvppptuvvlmw3aBFclDvDQisE1MdYiU2CT02z+QfsTELwP5py6U9gLKiGGoYD/J3ptFVBmOTKNi666Q07e67AwJJhZ8WF5hIVA/wEg7FiBj6qkgc8yzlh0VTJ3Zodwz7Sjn1Qi/5Nm9RpRIwQvNU5/6VAkmENzr95bMg/uFdUGMPgtl8hgjUg6i3qwm0N5mkGP9WAb2Qi/r0KMk3//RJwrGf5IF026ooWFPSCXQ2mmUcjARJLyjL+SkiqFfBrEi1vrhqOgf8YhH+C2Pj//4j5+Lj/DX2O8EjjSmjpE7wm8zfQdriOHA6O6nvDxmmzdgG8Zq/a4JrmoJ4JWvfCV17HbQ5HdZ3g2KGIuo/2NA0L+d+4KNrZhSSGcQuF/MbOWG2ImaXVQFajlYXvayl6FkCRgxmEBi/QJxZWkMS8u56lvjTmhayLmy8zBjmLpjPMoW5aJv/0IQR49mOxsSb4Bzwaz9JsdsbzCMoUtsFzF4yytBx6J3UsPEJVWyFpepqsh6bxbHbh2ei85tz9RJCUYGl1dXZfMcGgkxVCrApR+x5YySX6bN628Y4CzqUhi9UyvtziKwVqmQV2adMIn1o1OAKKWr6y2zVLjC7kdy0ZP8aZ/2afDOKNUFMasg8bLH/5hv1751AtXsJB99zzaxYG8JKVWN3Al4AUqHalN0oR9RKC2WtFjMXnmLZURhBDP4QAkHY5FuV5gI/RGsGTsCttWbNM7t0i/jYDQ1v0PB9UJ4PXvyCDndKrl2EDD0JZCX0MB0sqTLFEZO7PdVAYKBbGSCvaDTcC49BEMYhJA69NoQnxOgRY1XWQU+LLrnxOatGZfPqyJbQK1r/A/YqVXRSAlkfLLem8XJJ/TerG34zi18+by6FrNJ7lQByDQn2FwN9yOBkJOoc5rTuN2khhhdGwH6xSkFxj10Z9qY58Rz9M0VeXjnYbteXw1T9nonAHY0X/iFX9hFORjNVi97VDjmOeikRwR6t3ff933fB5ijr3N450J8x7zMwHXlLZatSWCePFDC7jNEdMfb+LcjI7GGHJoTAZB8Xd0WHo7rsRuLUbYSxJGZRRw7jLD5t38Bdp2r/d2/+3dhcJnSS6DkY+/BKF5XH8jgNTTgsufGG2/0cMP7+ryaiEDBSw4DSFvtFDzA1ZoaIzSiSaMQiDhAOADrvVln8t6sUwj9uVLh5NE6kRjmGHFuSEjJaSg5fboZbOgnN92vlKjIOmFdUZFgtr5CZegUIg3S100NpXQHIy6PZC4dSXvnoZ4oBPXJgUxal2sOOj+AgsBhRftLXvKSHv8gjtI+Gr0AlAi86cosekMn5zve8Q70Xnbz5Cc/WW27973vbWhWP60jd4bYBz4J4L10n4QCMnnQMjTe11twGFM8JbQ//uM/Du/HRXjcJbA+Ar6AL8YFoxpDAuQNN9zgosDb0sDwek/tsSRWnFqOJJBM8CR45VpvhQHTq+/3lV/1qlfdcsstvjbjZQS4TGlUMyMhqz9pDxRTESncnJ9G+0oEIUUEjEw0I+4yBZmhqfXeLF469vdmnXTcz5t8J7Xck1EM40/HSDmZnVLOlGYKRmX68i//crDmctanPnidaQjMdno4eZxOhvXkgyWzgofsR3/0R5G96EUvIqH0NkUjGkN9MKDDE6CpHJ7rmIJE78wU96EkkFJmMIZYGumKxRALSk8OXXwT5cNIR59C1cclWT6i0O8pvK0jczs8fpi+AxtNbJqpYCsfzNGAbgyH18dobmA9G3UXyU3wrjW40g2j+s+blRl682w3uWVDLhsjH/KQh3hTQ0OixDItMDlxwgyfLt9WwFLUv/d7v9fNrFUjRiCEsZ+3vhDMqpkHZvZ5s/Mwew7LK9vD0lqdvjvUWVcRT+ZEtqFQou/hqntf4evTfnklhdZ7sw4LxA4+z19/ebWzzCscdj6UaY6juMpGR5OvGHCU5tRypptFWTUCOzrm1DLMsYBuXwC1PqTwGadr6DC+vSXP1QaUHXedRbMLtg+rWaXGaEz17QMf/ER8u/j3/LWVGiQz2GfwTlq2keN5o6twNaxVb8kQWya8BdbeI/fKoKvKqxO/N2JNFwV8qvXFeQA/muJBwfuKr/gK9yWmOMKUIuHFEzmlhzbc0VSZIWbYYZw+CACEuN90gQD2JUVX0zBEUYFY62tywuzLJGi4HvKJT3yiVEDsuxKf+7mf++hHP5oEU4SjB/Qcj5zVTtoDoiDvhYYivZzRi1FDUwD5rxcX/eSVlED5kR/5kT4UvO997ysffAvOeSFn7MOIAR7GOkc8l0DvOtFHiXqMft3VEzDZknYJidizFIcCpClVDVkazU4y25xshgf4ogRKkiUMOWxguWSDQaBnLcDDxlmUIWkaYrPwJKudAB8nuGgDMJ6cP/pH/+hXfuVXstY39x7wgAdAunLybEeWEkJj6qL86q/+avYzydRWlyEt1AFWe58eKHAlD6eVeLj4kHsBvM29vl3F/wAhQNzbCXzLTmLIHxmI0qxeISleZTJMoXeLowih0WCUKNlrNo2pnvzp8DQFL4Fp0aj+nM/5HG+dJqEyZpaWsdnX5Ew5FeU/UbLa0Msw3dVZhSLqhyVvuukmr4AhH69vYyLwJbJf//VfZwkaXFZXgznBxugDG5UtqdlgwTiQ+EqQ1qltKUcaQOT0WgQNwQCq7a5hHKuSNsOtBBsbfQTxRjZikzwyA5odgSNhh+xsh7loayRYsM7WqivXfpm8alHFqyPVNhDEFig6tLiF0hfZekME671Z+0Owt59u21BcxLHjsQOJ8+RM5fYZnnPgMnl1tZbLtJKtYwR7my7kbED+MQUJ05Th9qRK7zZjYQrEfjJTSY5rdEGGD7MTwaayZGSGJEcJTBoMRj1KfU+YwJDDpVhGPH2m0pv8hMzsFQK4UCYhFvBh59WJ3xtRrFm2mqyBWz9ABdZbLcC5o9dgtIYoAYqzsjwrQQNGQ5qlmtUbwgP0BLpeaP3wePXIcCXWUAMH4NLA+jGAapgURbb6k/aAGMkTcREIB4HA2cmirDIVOwZMNMGQoizcGB/1qEe57xE+7YEPfKCbZrPYs7kNcCn/9i4MTWFpCsYQF2KQabYAAB2rSURBVL1EMQC+fEAjkUyhYUO8kDCZgV4zxGI2LYbYNWLJhMcChhmNAJiGUYIB6GnEYggmSsPOGy5g73//+3vZsdn73e9+7tgSyxKz6Fme8VvJoxSAPsnpXf2BHhBEjuJ8HhOLaPKwWPAtJ+vRaIgLE8fKBMTCkf8LnL6fyEJmNkY0kcUyZpQ/+jIBgN2sHiaxCcmGpsAsQUAmzHAR7l4nrrI0k1AyKYEY48KYhZlECEb0ZuGRITiFdtvJvl8TU6yz9GVZxkHup1yYs/WAMNk20utszbhC7YflFftnSvZrhi1K7tkks20gzV6hukV2ZA9cuLxyhk5ilCSdWkfwwDbHOgZhppbD0NUju21mbtUhGHq8klljSUYG7wxjR4B+sp2u6gSgTYEM4HJ5imVyUhcZghhbiB69x3oNd+xMYK4Dkzbmga+xpSu9iQIzNUU7wteu3nHIGp6NB9ppbQkW2Dz2uZQta21Ou9QGM4VGQp+NlUvr9e4BWTfZJd9knWLgdC4zDcvA7tfBpkrLHBOvpHXgEiWNzZbbpsITUlbDICOhIcDjMphKETIElSL47lHGkkpRjFRnmJ4uDSbGhMNUAABoIEmOBT7JCWEtmSxvOafcX1E1Yr12ypYtdde9B7Z5ZW/0Ma8NYz/YIaXcdmO0wWyk9tt175+1wNP3QEdzSVi1yIay0dndcM509BokjNpTZmKEUVTUDIx9JGMqIegD9F11AbBobl8wlvN0TZ7PbRAaBHplA1mF0BBxlcxszRThqYBhDLhH36ZI3q4lFhi2maoc3iboFP9crhpN4WWPlWinaNhSdd164MC8sgf6bMYz+jKtazfbA6DZKu29Lft166O1sDPygNxzyktCR7waIOXkHlvKPVPwUyQAhmbh5WfP7sLUy1V4NaaUJgQeUgNAUtHRT1Q0pMHErpykXR+mHrF9gYzw/JQWsKnkRwDOKqLMQsLUtyICRwiCsSGxp9wfWo3O1qxT9sJSd2oeOCyv4NtpszcC4O0f8JwLQ3BqNi9FdygPOOU7wa3awd3aA0w57qXiJGEFBj4AMQK9pNWX7cGGhJhVumAAEr6cNwxAM819jFpFkVJEeHpHOBb4hoOMN6W0AILh5+5qS1OJgkEcniJthiFPrX/f1WhcyaYtfGomLkXXkwdme2xzKbgd3ra3JYYyjH7OiP1b93py0VrL2Xqg25HJT4knG5nUGQ1fQiLTnPKKQc/EMttQflZFwmBBOexY5DYkyogNJ6WnEvSNOIxE9Z9G6UWJXhsL0wJ/qZLsNbMKJHzEUYIh9dGTlvHbR3yQaLRoTrk/tBodaMfO+g+kWcjlgav1QHmlt/fitSu6cGvz6GcKMDvqahUt+uWBK/GAHJOB/YcAQJOczmj4clXNcOJ3/QTpWAcrLV7uEKWiABNxJYcQqis2l4rJ7R98mEWWirEtFnhCZguYhfdfRGESGEuUMAj0TArvn3MB6dLbUwiamr7v2jGYWP8kO4YNwakBu5aN4jO0aWxYwPXngcPyynYyZe/ZrvaSZodD2jxgvSnesGEgt/vw+nPRWtHZeqCTnQ3dkUg5TXJ644zEU5PgeykRGr9cUA3oZ9/+xJ/4E5CT5P2jEnZct9xyi5/w6UcTJPNzn/vcKpNftzPUiPXjDijf9KY3+QlpP1QGSZTk9zMKwbfeeqv/OYNBQ69ZzUsl2KycqD3IGKBPuF+ZGXsY4OkCXix+7AOLHyP3E0EIiPJLNI94xCMe//jHJxbyDBqbDmz9JspMcSi4fpALOH0PyDmns0BMLPwa233uc5/Tt+RoGldeHc1vJ8110fPK0WlfjJeCZ48M/n0C7h6GhpAewcH044dN+ddj6sB+1Ge932jcdSBQCHZCk/f201/y6YHNbx+99KUvFYxLx95eKVJsD6RcyFP2QOGg1AmiFyY/snfKNhxZ3cqrI7vupBkvdF4dVzXa72SS3eI4T/mn8xCNG3e/eNmbqeHbifA9GUvI9giGUcPcmgDW+40Oq0aHPqlzavhxRreNbuvEAD+AfwGrnaEHSnQGCEp35d6a9ZjHPOYMTboq1Suvrspdp0Z80fPquBzliNP61zcy1SG7rE/7HYCf8RmfYdiRCPhDf+gPrfcbHZfnL8kpC/f3fsD1rne9q+eVpoRnP8HCnK0HBMUVmQu0u9zlLv/pP/2nszXmyrWvvLpyX50J5QXNK0fZ9pgKnru9q/IkXkUIS+wkA7oNev3rX58ol+k+wplbIsh+jdu9kVq1o9e3IRDs3Db5wMZnP354nnwAAteXPrNB1mt3soGKTumEqIuE+zX3XuTaMlFCbo2Bj94NmaoJ9qSRhbT0iAuBZsgAPxzOZi+VMPQDj9SNqJ2FHOHxWBLSRb4GbkUNt/2h90Yf8iEfYsF/+S//ZdQ++MKv9clY8OrPxAMSRYBTLc+8QcBbMO50pzudiTFHULry6ghOOwWWi55Xx+gix10nHp8Q26f63rDgGwHe6GH3+bhI77ttT3/603uLhIMRBpef7tV3Tjo5sev7hQW7dYxEo54ZKmleauN1IWAvNyGEOiVHedA7uIeLEEVFxTLlAYP3VitCFDHSTwZ/0zd90wgHkJ9S71ghEPxZn/VZL3zhC00Z6r1yxavd2OYh/1/6S3/JNyY8XyHKJ9Dkj1Iwk+Ap0lrRVtExwxQc1hjhGyPPfvazGXQYzcKfoQee9axneV2hBD1DG46geuXVEZx2miwXMa8cizsX4Dx2LAcXycnp5HVSO/q9iUqvHvgeWnhlSWJT2kuq3O50c1PgfFbkJVgoo4G0c30dfB4JmvLQz2urvuEbvgGvIRqzVKsfszR4GIXBUyuwpmD4eh5iNN3ZmKVl1k4RMi/N6j5JoTL85m/+ZiwAXwVE7Ax5ylOeQhFer3aD91Xvd77znWiusWXG2E8amPwDxR6MHVJXBJ7XtVrIWeEQLOCsPOBtjx/xER/RlzvPyoYj6115dWTXnTTjBc0rB9zOkcdRRzuvnMga9iknyamQpAUmJEpA9Fj2Xxr2xGyKEHY0+8l2rE3gnpL3KEIzcsBaNmTSyAxp9vp5v1FLvec97+klgy972cue8IQnqK7qsKivdrYecAXkfaDf/d3fLTR3v/vdL2Xl3mXO2Vp1hdqZaresvLpCd50m2YXOq+NylJPd3YO7BFnqWVlilSXDnl91b2HoMJTMKAGm1A/Enr+1GSFR6tf7ja48NId+bkQEV+p9SP4TP/ETD3nIQz75kz/5SU960otf/OKf+ZmfceNpSkiuXNOivCoPuAja0rtnf93rXveSl7zEv9cJhHC8+tWv/rAP+zAxqm2JzznMYBauvDqTMF3HeXUs/pScqoiKUlFJps9dDBUqw/oqE+L82R50Hu7xXXoC5k6lYXczHZXIsIMhUxQ+LdW5RMGkIgJTDfUwPbtDEzxKhwvQ51KkgZXVhA9BApuFHHxctIwZzephsmEwxw7s/tjRjgL3emp7gfHFre/5nu/xeZdP3jxpMcWzGpbxzg77Gh7ZA1za1Vbu9Q/YN9xww4033uhLpf5f+s53vjO8lPIcwL9wC9A2sY6s9NQYV16dmqt3FF2veSX/nUVz5jqmwUfYF+oEF+04LWlNdRi23cIjdrHYtwaGcerNbEzmdZpn1da2puz3ioFbsb7IEE3Chx1AptVtMQ33Wz72nBXQEsZRzADzA/x+kw6tRnkTZw5KaPHgBYLyrEsArolmv/SFuRYP8LPW4wKZKuGKIodPdBEIjX5+UfRaNJ4C78qrU3Dy5VVcyqrrLq9sCouyR1p7G6RT6/Le2JltN9loBDrcmrUHE7UtDDDKRkVo9mPAVjshpMHMIVnVYS287UAFXRqBMGMPsi4dOgHe9a53dd2ZnCld6DuWh/FcAflt/MM2sGXC77fz0Gq0JY2TvwZ5KZ33fliw8FfMZ3YB1+6BSXSiZBs/83+B3Aov2FvMBYJXXp1+sK7XvLI7nEjXXo2KCC/1uwnEDtzum4M1gFJnq9qgp31/YYgs/Ha3EquujMH0JgQNJBhjTwg7eJNAHUqYGBF3Dlec9ms//QTb0diSx2lmwVddjeJvkUS0zq1QGPi5NzS1Y8caXosHJk1z7HYInhi78mrbDMG1KD0F3pVXp+Dky6iYPLnO8uq4qlH5eVXHunpgG7pxwcW9mu1JjjNXIFSdHrttJaPsREZcsJoFt7VDgtvghpW9rWFzOEe8wzvIswXmpNqu9Kqr0XZt46nDFpanDptd+CN4gM9tME04tYnliLq4Prcc67KQlVcTzVMDrte8klF2xGyTUmsy7crd6/R3hT1yMBKrv7QV99qIQgmBsqoTnl4AJIB2sFklhBBilSWAodLV3U/ERPU4DgtG90xotjZsixCWVgcYFemFOW+tEIzBzAMfVo12P6+bxbR+nGo73w2eN7feH3x+meECrtEDk4syfkRtQws/n53uJOvQn0Ng5dXZBuV6zavj8moFg7QO0Dk65x6lygGvZrQ3h5JvtXe/+92++QUIT5Rt2wMMyd/5CYBHowfPiUpgb0iC9wUlT+pSEUGqlTHIke+XhObs7XzAe0Hbod/w7hGcNc/HdMqSRVbW+DQXADRIDlrtGD3A1ZNkxEpZbZtkQmM/5P95XrolOJ/wyqtjTJIjiLpe8+oYs91pViGxAe0yvxoH4xjUfJ0YRu+XdXy7OP/D7H//UG8tku0u5f3kT263YTsq2wXk+x8vpQtyNvvnf/7nEwiD0f+2U0oLjKqjUtL7yEc+EruN72cgbrrppic+8YmEo4E5RiecjSheWG15YHlgeeBCe8Dp6TieJQQrKoO5QsA1X5R4g0n2k6OQt9xyCxhQTbr55ptpec5znqNy+EUfeK/g85Y8wA//8A+jdPkOVswUD9Lc2UDOAzoY7FnYrCn0/qVd7QFo6H/oh34IMG9UAj/4wQ/2Uj6/S0QXC9WzrErUJbbz1LJqJzQZvN/MS85dbXlgeWB54EJ7wAG3c+RZzhEOaOe7liuwKwZf9EVfZKiWqBZ+SBrG78i5Fxl3KTYReHI+52ylJQNUFyxo4lKlYtkqSpoloFTeqPvxH/9xqgGQJPtBuVe+8pVY3CQhcM/kh+9wGY7SI6w3vSfXZ9JOaMbgHb2HPqnDsNrywPLA8sAdygMOes2SnfuKh9rgp689YfOUzCM1z9y8arkq4oTNMwAYJQcNFnD1xs9mQ8LotbiwKEVgx3SKYKpSAGTwDf3kzXd8x3d4Xke7H+n3o90/+7M/i8bPhHs3xFOf+tT73e9+TnNKIWsYbwcv5N9VjS5k2JbRywPLAyfhAcUgsRWbG2+80YskerzmNsWsF0CoJWiqJV3dKzDoFYNLpez9399tjRLiwV0VaGoPJAmGSojCQwj2hI9eUxF87Md+7JOf/GQwycqb26Ov+IqvINwd0r/+1//6W77lWzwPxIU9USfhjVOWeUX//XrKNi11ywPLA8sDV+UBlcCpPeeyYxrsrL/a24VhSQIbSIDMGC+m8/vRj3vc41SpQaoQSoVKg0bvV6+e//zn+/jHpzuG3hDxzGc+01sx3cqgrMjBY6EiLozwMxyN0ZvSfGfBb1SqhWbVIf1nf/Znq1UAK/UFPEI8vsvO89Pnz3Emw8DWNd7bmrrujbbeWPDywPLAHdoDDvfW74jvsx8P6yBrX/iFX/jn//yfHwdVJxysioreOas8gL2Fz4M13+oG+4VJXzdwQ4MLgZ5YZFUaVYpkSMOEkOO1sG62PBL05QVmkPPBH/zBqqBSZOgx3aMf/WiPAT2sw4VdjUTwy7/8y2PYBQXeU/Yv6AKW2csDywPLAw5ltcFhnSu6GHeyd9ZflX/IccoPy3aoiqgThBOb5Jnt94txeaDXZzm0m4VhFWT1Jgn1owLgWZyqAxibWwIMXkoBySF8aMiBzxKzATDnp2XqrIVhYK6A32/kqkb7fbIwywPLAxfMAw5iR/+1V6OdejNlo/N0hu5vOMjdjH5qA7hSFCZ7qhCxT+kalvD1iQJXC9EMbGpaFa4DHc0sGcEUwiE+c6CVzgLZ06Lg99u2ntTt98nCLA8sD9xBPeCUr9KoIs7NbkoUAENnfWeoXh3SFKemqhBc1o0LRnBFJT+qGUOJ3YdGephqiT4WyLhIplED9JlQchISF+KAppjHJDAWvdnwelMDn2dgVaPzHJ1l2/LA8sBpe8CZ7pRXkxQDuh3rlQqVpuM+vENf5ah4IFAnUGrhK2kx6qsQxKI37LfWgmM0FTGNMPNoDoC4KXhkWh7Z0tPLvKpXvGMkYlOxnPN+VaNzHqBl3vLA8sDpecAh7tDXlAq9KgKjCHW4s6N6k0GQhuAIDFUIMKTeDVC1Sv0wFZxkLPGaggfD4AX4AClKmGoYfBXIrBavXsGjSEsC4jSih0Sgpw6w7o04YbXlgeWB5YGL5AEnuNPc+Q5wk9HpP8e6lfSfrQCz8K0NUMGIMa6+b23Kozaz2wduMeq7hSKksgHoPoYNU7donFsrSFMNUZKQruzpR+1gQiLumxHr3qgwrX55YHlgeeDCeMA57ramgsToioShclINcOKHrG9hCsasMLIpMwQqBnoP3KZ4mMVOLF1pUcZ6wmaYBJhUYDQVDImgITgt5GjJoUIDawnc2hb+3PbrSd25Dc0ybHlgeeC0PdCxrnem67urcO4rJw736kS/mhpy7/C/7ed5KgM9o0M/pqNsSkVR1RILWbWABEcMxthtFhgBA3rOFpKc6mIs3fo0xbZkkpA6dYiuaMaY8wysanSeo7NsWx5YHjhVD3SyU1lVUBI0Q8e6HhzQcQ+DHkZvKqTe/dOULjQapCd1kMgQqxMADV4JARDiU5/qE3o02pvf/GZ3PwhGaUVuyFA2BYD037KGaAiEUYcIAVyUdpFsvSg+XXYuDywPXFwPqBAd9052t0FgLyvSa95p5HyHdwP0vOc9r3sRL3ewWPBb3vIWNAjAt9xyi6rgdxwe9rCHPe1pT4P3o6u99AhxlFULlOhx+TGFikclhxnedYSYLnii9JrZXjBBstcdIUPj5xj84oOfabhk5V6D1PoqefD571c1Ov8xWhYuDywPnJIH3IvM3UZHv2IA+Ru/8Rve4PD4xz9eJfD0zM1H9zd+2ucv/sW/yDh16973vrdZ5UF/n/vcx7vyiPpX/+pfPeABD/AYzYuI/GIQUW6SYLyZAtLPcvtNbuzk++07YrWWSs53fud3skFFgfmYj/mYV7ziFdjdMPlBVbOvfe1r4XvXkRL1mte85kUvehGZaJKgV5g86BuZgz+ngFWttjywPLA8cKE94Hh15s4SghWDwVw5oMwg7q5CCSHZ+Z4oLxnyy9xeoOf0H+Fetefdr34p9Yu/+Isxhr/55ptRqlWxwzPppptucif08pe/nJyx50u/9Etf9rKXNczsDCDHT9WpRqaw9JolBPAUKWbgXm6k5DBAHUrdiBoLBxilpwakunWNYXxyoAGXfv5oteWB5YHlgeWBPNA3F9wSGTpGPQRz3IMd9w960IOUCj9RqhoZRuPAbej2BRlYD1ZI/GQqGKCeOX/BiN/2trd967d+6wte8AKUkITf9773NUWgWdo1eLNVQVPKktcsfdu3fVtCsLg9Ypu7MY8BkZGAPnXoNUr1ZCLOpD30ue7Wk7pzHZ5l3PLA8sBpesARn7pOc4XBTZKHXeqEY90tiAdr3hlhWClCjMXXFpSEn/u5nzNUMNQAdy0w7373u2EUA8TYe+b2UR/1UT7gUdUIQewZnR/njpG6DCABe/8/ZMrbKNwPQaLX8BqifNWrXuXVFd/+7d/+gz/4g8gu/y9NCM57a3mrXx5YHlgeuLgecM46ncf+4I77QV4JgLFndHgVIU/qfMXgG7/xG/H66gEtAF8oCFAw0Lt5Uod8bgSJHoFS5BsKyNzTKEWj15M6GCyqDl54/Sd8wif4HkQ0mT30AHL06hDhTNIMvXLCdyjwKpk/8AM/oBRVxkxlGKAWi4Xcjjjtvxm8XRd4x8ixaT2p45nVlgeWB5YHbvOAAgDqhqZ60xfkIPsym9MzUoUKmVLhH1Tvda97qTQe0GGBVJDucY97vPWtb+0eC71TWEOs+ULE3Fr5GoKnbQm///3vn3A0hKD/uI/7OIBC6LaMKDAC1dEXIsBf8iVf8pjHPAbvk570JAXJPZNCBc8S2vt/W1yjK7PPbX/b/0mdW/uWYcsDywPLA+/TA45gZ/cc/S7JwQ5u+PfJuyXYYVEGbrjhBkjlQe9YBxDu6MeVFj3Vc+IrCWDaZ1Z9CoPX87phTG+zYEKUN1xs1sInpKkd20yFmVW7B8qwJOcQonYYmz2dPtWtIo1gy4Tfb8D63Gi/TxZmeWB54A7qAWe3mmHxlZ856FWR6g2gE7+zHiUWU30mZIglrnqzPW1z/uLFFcscx4mFVH70Dmu9Vt1KSMe3KTSjCA0hCJLpQ6MMU5NaAi40YDZcknju27o3OvchWgYuDywPvC8POHCnPKDtYtxhfVEO4ve1vos6XwgKR2sAr3ujixrOZffywPLA8sAdwQPrSd0dIcprjcsDywPLA+fdA6sanfcILfuWB5YHlgfuCB5Y1eiOEOW1xuWB5YHlgfPugVWNznuEln3LA8sDywN3BA+sanRHiPJa4/LA8sDywHn3wKpG5z1Cy77lgeWB5YE7ggdWNbojRHmtcXng+vdA/yjqH1z8f+j85+n1v+zzvUL/7+W/cYVDXGrs7d9y9xu+qtF+nyzM8sDywAXzgJcpvOtd7/JTBY4/P33dzxNcsDVcp+Z2ZWBx/YfyO9/5zjvd6U4HrnVVowPdspDLA8sDF8kDd73rXd/+9rfPr+x09b1q0pmH0I1RP3HUj2KAf+VXfuUud7nLgYatanSgWxZyeWB54CJ54KEPfai3evvVmTHafdJclQ9yAafsgUJQXDypo90LmR7ykIccaMaqRge6ZSGXB5YHLpIHvFjhe77ne/xCqINPc/C5T+p6/CIt47qztR+KLRBuVQVImB772MceuND1q6kHumUhlweWBy6SB/7zf/7P97nPfX76p3+6t3pnurK0bo/OPIoqUA/rWOLG6DM/8zNf//rXf/iHf/h+w9a90X6fLMzywPLABfPAh37oh3oB3TOf+cwuwPv61ro3OvMouiBQihQkr31izNd8zdc84xnPOOxzo3VvdObxWgYsDywPHIMHnHef9Emf9AVf8AVf9VVfRZz3/Xj56THIXSKOyQPPfvazvTf9Va96VW/X3S91vYl8v08WZnlgeeCCeeA3f/M3XYP/yI/8yKd8yqfc+c53vvnmmw+7Meqz9MNmL9iyz4257oGyhWN3fOtrdTDPe97zXvSiF/3kT/7kYaUI+7o3OjfxXIYsDywPXIMHPA7yxe53vOMdf/yP//F73vOeX/d1X+cl4uTB6+ejiz5MqiZdg7bF+l4eUG+4dOqQLzQaCof2xje+8Wu/9mt/7dd+7Tu/8zs/4iM+As1hH+atz43ey6drsDywPHBBPaDeOOnudre7veIVr3jQgx7kqZ2y9A/+wT94wxveoCApQi7SHZGHHYUXdNXnxGweriBV+3n7F37hF77ru77rCU94wsMf/vAHP/jBr3zlK+9+97srTgxWqw40e90bHeiWhVweWB64YB7wuZED8QM/8APZ7bsM/+W//JeXv/zlL33pS9/85je/7W1vM+uI7P9hffn7sAPxgq353Ji7damS80Ef9EH3ute97n3ve//hP/yHH/e4x83XFlwNiMJht0erGp2beC5DlgeWB67BA67K53GcYuN83GIS7DTUnIbXoGexHuCBw1yq/CtO7kq7SuB8oQneL2V9i2G/TxZmeWB54IJ5wBW3UuSkc/b1LM456OxrGcqSofpkyrm5v0pdsNWeP3Mr/9kF5uS5MoDkdj9l6/cDfdFRf9gFwbo3On+BXRYtDywPXL0H9teY7amnXBn2uQXZU6iuXs/iOMADuVoR2vp8h647pJ1AbGlWNdp6Y8HLA8sDF94D2+v0FtNnFZ2Vweu7DCcUZtWIh7W+VALgajem3ZVeXumqRpf3z5pdHlgeWB5YHjgND6xveJ+Gl5eO5YHlgeWB5YHLe2BVo8v7Z80uDywPLA8sD5yGB1Y1Og0vLx3LA8sDywPLA5f3wKpGl/fPml0eWB5YHlgeOA0PrGp0Gl5eOpYHlgeWB5YHLu+B/x98aJLxhwkb8AAAAABJRU5ErkJggg=="
    }
   },
   "cell_type": "markdown",
   "id": "facc96b1",
   "metadata": {},
   "source": [
    "Suppose you have to manage contacts in an SQL database.\n",
    "\n",
    "Each contact has the following information:\n",
    "\n",
    "- First name\n",
    "- Last name\n",
    "- Email\n",
    "- Phone\n",
    "\n",
    "The requirement is that the email and phone must be unique. In addition, each contact belongs to one or many groups, and each group can have zero or many contacts.\n",
    "\n",
    "Based on these requirements, we came up with three tables:\n",
    "\n",
    "- The `contacts` table that stores contact information.\n",
    "- The `groups` table that stores group information.\n",
    "- The `contact_groups` table that stores the relationship between contacts and groups.\n",
    "\n",
    "The following database diagram illustrates tables:`contacts` `groups`, and `contact_groups`.\n",
    "\n",
    "![image.png](attachment:image.png)\n",
    "\n",
    "*Note:* We need to know what are the constraints before creating tables."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "99c53452",
   "metadata": {},
   "source": [
    "### The following statement creates the `contacts` table"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2dcce260",
   "metadata": {
    "scrolled": true
   },
   "source": [
    "```sql\n",
    "CREATE TABLE IF NOT EXISTS contacts (\n",
    "    contact_id INTEGER PRIMARY KEY,\n",
    "    first_name TEXT NOT NULL,\n",
    "    last_name TEXT NOT NULL,\n",
    "    email TEXT NOT NULL UNIQUE,\n",
    "    phone TEXT NOT NULL UNIQUE\n",
    ")\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2127a3cd",
   "metadata": {},
   "source": [
    "### The following statement creates the `groups`table"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b2de75d3",
   "metadata": {
    "scrolled": true
   },
   "source": [
    "```sql\n",
    "CREATE TABLE IF NOT EXISTS groups (\n",
    "   group_id INTEGER PRIMARY KEY,\n",
    "   name TEXT NOT NULL\n",
    ")\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "21180484",
   "metadata": {},
   "source": [
    "### The following statement creates `contact_groups` table"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "42ebedb8",
   "metadata": {},
   "source": [
    "```sql\n",
    "CREATE TABLE IF NOT EXISTS contact_groups(\n",
    "   contact_id INTEGER,\n",
    "   group_id INTEGER,\n",
    "   PRIMARY KEY (contact_id, group_id),\n",
    "   FOREIGN KEY (contact_id) \n",
    "      REFERENCES contacts (contact_id) \n",
    "         ON DELETE CASCADE \n",
    "         ON UPDATE NO ACTION,\n",
    "   FOREIGN KEY (group_id) \n",
    "      REFERENCES groups (group_id) \n",
    "         ON DELETE CASCADE \n",
    "         ON UPDATE NO ACTION\n",
    ")\n",
    "```"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9dcdcf52",
   "metadata": {},
   "source": [
    "## Example 2: Create two tables and drop"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "72edfc7c",
   "metadata": {},
   "source": [
    "For the demonstration purpose, we will create two related tables: `people` and `addresses`:\n",
    "- Each person has zero or one address. \n",
    "- And an address can be shared by any number of people."
   ]
  },
  {
   "attachments": {
    "image.png": {
     "image/png": "iVBORw0KGgoAAAANSUhEUgAAAVYAAACTCAIAAABan6ZnAAAK2WlDQ1BJQ0MgUHJvZmlsZQAASImVlwdUU9kWhs+96Y2WgICU0HsXCCAl9NClg6iEJJBQQkwIKnZlcATHgogIKCM6VAVHhyJjAUSxDYoN+4AMCso4WLChMhd4hJl567233r5r3/OtnX322eese9b6AwAliC0SpcMKAGQIs8Thfp702Lh4Ou4pgJCHDBhAmc2RiJhhYUEAsdnx7/buDpKL2E2LqVr//vt/NSUuT8IBAEpAOIkr4WQg3I74GEckzgIAdQyJ663IEk3xLYRpYqRBhIenOGWGP09x0jSjFaZzIsO9ENYHAE9ms8UpAJCtkTg9m5OC1CGHIWwt5AqECG9A2I3DZ3MRRtYF5hkZmVM8irAxki8CgEJDmJH0l5opf6ufJKvPZqfIeGZf04b3FkhE6exV/+fR/G/LSJfOrmGIOJkv9g9HRlXk/O6mZQbKWJgUEjrLAu50/jTzpf5Rs8yReMXPMpftHSibmx4SNMvJAl+WrE4WK3KWeRKfiFkWZ4bL1koWezFnmS2eW1eaFiWL83ksWf0cfmTMLGcLokNmWZIWETiX4yWLi6Xhsv55Qj/PuXV9ZXvPkPxlvwKWbG4WP9Jftnf2XP88IXOupiRW1huX5+0zlxMlyxdlecrWEqWHyfJ56X6yuCQ7QjY3C/k45+aGyc4wlR0QNsuACSJAFOJ0EA3igS1wBE7AH/hk8VZmTW3GK1O0SixI4WfRmciN49FZQo6lOd3W2tYWgKn7O/NJvLk7fS8hFfxcjL8bAPulCHyciyUj96oF6VsRnosZZQJARc6hw5YjFWfPxNBTLwwgAnlAA2pAC+gBY2CBdOcAXIAH8AEBIBREgjiwFHAAH2QAMVgB1oCNIA8UgJ1gDygFFeAQqAFHwXHQAk6BDnABXAHXwW3wAPSDIfACjIF3YAKCIBxEgaiQGqQNGUBmkC3EgNwgHygICofioEQoBRJCUmgNtBkqgAqhUuggVAv9CJ2EOqBLUC90DxqARqDX0CcYBZNhGqwJG8JWMANmwoFwJLwEToGXwzlwLrwdLoEr4SNwM9wBX4Fvw/3wC3gcBVAklApKB2WBYqC8UKGoeFQySoxah8pHFaMqUQ2oNlQ36iaqHzWK+ojGoqloOtoC7YL2R0ehOejl6HXobehSdA26Gd2FvokeQI+hv2IoGA2MGcYZw8LEYlIwKzB5mGJMFaYJcx5zGzOEeYfFYlWwRlhHrD82DpuKXY3dht2PbcS2Y3uxg9hxHA6nhjPDueJCcWxcFi4Ptw93BHcWdwM3hPuAJ+G18bZ4X3w8XojfhC/G1+HP4G/gn+EnCAoEA4IzIZTAJawi7CAcJrQRrhGGCBNERaIR0ZUYSUwlbiSWEBuI54kPiW9IJJIuyYm0iCQgbSCVkI6RLpIGSB/JSmRTshc5gSwlbydXk9vJ98hvKBSKIcWDEk/Jomyn1FLOUR5TPshR5SzlWHJcufVyZXLNcjfkXsoT5A3kmfJL5XPki+VPyF+TH1UgKBgqeCmwFdYplCmcVOhTGFekKtoohipmKG5TrFO8pDishFMyVPJR4irlKh1SOqc0SEVR9aheVA51M/Uw9Tx1iIalGdFYtFRaAe0orYc2pqykvEA5WnmlcpnyaeV+FZSKoQpLJV1lh8pxlTsqn+ZpzmPO483bOq9h3o1571Xnq3qo8lTzVRtVb6t+UqOr+ailqe1Sa1F7pI5WN1VfpL5C/YD6efXR+bT5LvM58/PnH59/XwPWMNUI11itcUjjqsa4ppamn6ZIc5/mOc1RLRUtD61UrSKtM1oj2lRtN22BdpH2We3ndGU6k55OL6F30cd0NHT8daQ6B3V6dCZ0jXSjdDfpNuo+0iPqMfSS9Yr0OvXG9LX1g/XX6Nfr3zcgGDAM+AZ7DboN3hsaGcYYbjFsMRw2UjViGeUY1Rs9NKYYuxsvN640vmWCNWGYpJnsN7luCpvam/JNy0yvmcFmDmYCs/1mveYYcydzoXmleZ8F2YJpkW1RbzFgqWIZZLnJssXypZW+VbzVLqtuq6/W9tbp1oetH9go2QTYbLJps3lta2rLsS2zvWVHsfO1W2/XavdqgdkC3oIDC+7aU+2D7bfYd9p/cXB0EDs0OIw46jsmOpY79jFojDDGNsZFJ4yTp9N6p1NOH50dnLOcjzv/4WLhkuZS5zK80Gghb+HhhYOuuq5s14Ou/W50t0S379363XXc2e6V7k889Dy4HlUez5gmzFTmEeZLT2tPsWeT53svZ6+1Xu3eKG8/73zvHh8lnyifUp/Hvrq+Kb71vmN+9n6r/dr9Mf6B/rv8+1iaLA6rljUW4BiwNqArkBwYEVga+CTINEgc1BYMBwcE7w5+GGIQIgxpCQWhrNDdoY/CjMKWh/28CLsobFHZoqfhNuFrwrsjqBHLIuoi3kV6Ru6IfBBlHCWN6oyWj06Iro1+H+MdUxjTH2sVuzb2Spx6nCCuNR4XHx1fFT++2GfxnsVDCfYJeQl3lhgtWbnk0lL1pelLTy+TX8ZediIRkxiTWJf4mR3KrmSPJ7GSypPGOF6cvZwXXA9uEXeE58or5D1Ldk0uTB5OcU3ZnTLCd+cX80cFXoJSwatU/9SK1PdpoWnVaZPpMemNGfiMxIyTQiVhmrArUytzZWavyEyUJ+pf7rx8z/IxcaC4SgJJlkhas2iIULoqNZZ+Ix3Idssuy/6wInrFiZWKK4Urr64yXbV11bMc35wfVqNXc1Z3rtFZs3HNwFrm2oProHVJ6zrX663PXT+0wW9DzUbixrSNv2yy3lS46e3mmM1tuZq5G3IHv/H7pj5PLk+c17fFZUvFt+hvBd/2bLXbum/r13xu/uUC64Ligs/bONsuf2fzXcl3k9uTt/fscNhxYCd2p3DnnV3uu2oKFQtzCgd3B+9uLqIX5Re93bNsz6XiBcUVe4l7pXv7S4JKWvfp79u573Mpv/R2mWdZY7lG+dby9/u5+28c8DjQUKFZUVDx6XvB93cP+h1srjSsLD6EPZR96Onh6MPdPzB+qK1Sryqo+lItrO6vCa/pqnWsra3TqNtRD9dL60eOJBy5ftT7aGuDRcPBRpXGgmPgmPTY8x8Tf7xzPPB45wnGiYafDH4qb6I25TdDzauax1r4Lf2tca29JwNOdra5tDX9bPlz9SmdU2WnlU/vOEM8k3tm8mzO2fF2UftoR0rHYOeyzgfnYs/d6lrU1XM+8PzFC74XznUzu89edL146pLzpZOXGZdbrjhcab5qf7XpF/tfmnocepqvOV5rve50va13Ye+ZG+43Om5637xwi3Xryu2Q2713ou7c7Uvo67/LvTt8L/3eq/vZ9ycebHiIeZj/SOFR8WONx5W/mvza2O/Qf3rAe+Dqk4gnDwY5gy9+k/z2eSj3KeVp8TPtZ7XDtsOnRnxHrj9f/HzohejFxGje74q/l780fvnTHx5/XB2LHRt6JX41+XrbG7U31W8XvO0cDxt//C7j3cT7/A9qH2o+Mj52f4r59GxixWfc55IvJl/avgZ+fTiZMTkpYovZ01IAhTicnAzA62pEH8chWuE6AMTFM/p62qCZ/wTTBP4Tz2jwaXMAoNoDgGjEp+RReTsiaTcgmgTxMCQW6QFgOzuZ/8skyXa2M7VILYg0KZ6cfIPoR5wJAF/6JicnWiYnv1Qhzd4HoP3djK6fMuwJRN90AED4/V759lzwD5vR/H/Z4z9HIOvgb+OfTAoafkXnCMQAAAA4ZVhJZk1NACoAAAAIAAGHaQAEAAAAAQAAABoAAAAAAAKgAgAEAAAAAQAAAVagAwAEAAAAAQAAAJMAAAAA9Pv9lwAAIAxJREFUeAHtnVvobVX1x/NPdMEe6pioB/JSGt2gOtlR+xOC0kMReUwDjwZqWT6EJZRJEERglhzQhIos1Dz0EJR4LDR7UIPQyG5Ux8DqHKnUhPK8hJceov/H86Xvf+w511p7r8tee+3fnuthMdaY4za/Y8y551p7XY74z3/+84KyFQQKApuKwP9sasdLvwsCBYHnEShTQKmDgsBGI1CmgI1Of+l8QaBMAaUGCgIbjUCZAjY6/aXzBYEyBZQaKAhsNAIvbO79oUOH7rjjjn379j366KNPPvnkU0891SxfWgdE4KijjjruuONOOumkc84559xzz922bduAxpdtqlTOshFusN+ucrgvoHJ79tlnv/CFLxx99NEf/OAHb7/99gMHDpDUSsnCXBICAA7s3/ve9y666CISce211z799NNL8jWg2VI5A4LZzVSrynlBpY/HH398586d559/Pj/+lQKFOTICBw8ePO+889785jf/9a9/Hdl1K3elclrBNYLw3MqpmAIoshNOOOHGG28cIb7iohUCN9xwA6l57LHHWmmNJlwqZzSo2zpqqJx0CmCpuWPHjq985SttfRT5cRBgan7b2972zDPPjONucS+lchbHaiWSdZWT/iOwZ8+e448//mMf+1jDxYbStEIErrjiiu3bt19//fUrjKHSdamcSlimw6yrnCOYkBwlVxFe97rXPfTQQyeeeKKZhZgaAlygOf300x955JGXv/zlE4mtVM5EEtEcRmXlzKwC7rzzzrPPPnszx//ll19+xBFHsFhqBnEKrfxNeOaZZ37/+9+fQjCKYYKV05DQhqbpQLqMSCorJ50Cdu3atQzfxeawCJAmRt2wNvtYI5hSOX0AHE03r5yZKeDhhx/mUtNo0RRHnREgTfv37++sPrhiqZzBIV2SwbxyZqaAv/3tb8cee+ySfHcw+7+HN9bn3ljC2Y6Wc2764Q9/6Cb0zIfw8r7ZoNUhGoxHsVXRXBF84oknVuU99ztm5cTMQpNTxxPznkyRdU0kOjbJWl32KaToXcJ4r+PT1NaU+7IkoqJy4v8TeI2HK6ff8Y53CIg//vGPvmz55S9/GVpNH/3oRxWkDmOT6ESywSCm8BUtVBqXuynsJ5WscYKhDFQPTm48jCWBwIJNyjvCqrGkYHyIwbvvvls2lX0psq/jWzcvpAYVGV/qnl5E+7MHs21RbiV0HNgEYOBcCk6bmpC3jAOOnDqDCCujZLrBuG1OgUgSudqQVhWMsxazLCic64YmJGXBo7Qh+26isy48LMzlW1iREFidyjhJTJI15zEhpFe+vfa1r1UMp5xyiggjaI74Dz74oAilP9H605/+JE5uUHzt5xqPwoUeGQGW3FdeeWWd05j3N73pTa4H5BuaorWG7J988skMUU4EkHfhMarf/e53V/Jt1sLiEFWDKWuNRsxcCxjNazdHeXryWVOWY+6tBe6JXzdFvhNWZzwKF3pMBJjENf5JnLITBzaRxLwn1wIammIX5mbfVaHlw3ve8x6p5/zOpmI8I9BrMAVcc801AkIEa3UGs3Lv6zG+6MKUrCZfApSWEhbtQNtgBLrBeBQr9PgIJFM2KfbAdt6pBALj2vAiTXkXGrLva37S0p+gFFsdv4OpPJ4xOJ69IPAXD1dOJ3M84TH+HVUc1TQhXNdkrQaDsmbJBuP2slpiUskaLRgShC9tZNNpUi5ifpOE1jVJjH3Mps3akVqjdzU182ltayqGsSSayKPlmRuEOc+hTX2bwp4feeZynW4NEs/gBgeJqpuRSSVrUsF0w3NztJJkrcGJwObkpvS0IDA+AmUKGB/z4rEgMCEEZlb+yQphQmGWUDIEJpWsSQWTQVUYMwgkySqrgBl0ykFBYNMQKFPApmW89LcgMINAmQJm4CgHBYFNQ6BMAZuW8dLfgsAMAukzAlwqmGkvBwWBxRAolbMYTpOTSqeA5luDGtLcrDi5fq9/QA25WEnnmgugIdpmxZX0ZWs7TXKRTgENnUezIVvNrQ1mS9OWR6C5Nppbtzw4K+9giykgxkradNgwKUT5QhcEhECpnKlVQpfLgZq2GfxszujUOpbHUxkqTL9HYEEVi1UadGshcgRATGUzYOVUZrCSmcfTmVOZ+manlSoOoLnVYssguqwCYv6glxHWMmx2CLVBpWHiWEbwW8PmmlZODn5DYeTC4jSorLaWuqwC6BL90VbX4cinh0xyfqza7/kUnyY2ocCe5715nk8cEdB6CByblSqI+X0BeImuI40dHRIANJvN2nKUh0ZGTbmLiy++OAoctvf8Th2hKXpB3R1MJJMuo7i1t/8WzqK/HC4bcHNyI7aGK2cm2HKYgI9uXmM5xy5MYEd07hS+HFlYhFRomlwtOSUQxBoPE7pzq970oEfxReutLxjkQWC8iGlCrcj7KW5JRl3TIqLxJGwfKn4rwtfj33AskxBRJXEhO5Kf2xEE5KVZMvHefKjYmmWW1Hr11VcnlpuD6dyql+3JlwEXITydwblMjOTgo57UWM5JeqpD9ajSaaW8vLOXymprKUnHzJhP2pLOdG5Vt20N0IGA7Bp9mqDhIMmrHSQZ0y9OTI9U4CTGUYcj+WSv+BMjMOvkUZdKpQszKzuSeFFUlZLYcZeTgJsPm9PRrLtg67333nvWWWcdc3iDuO+++6SYu8450UWf1sQOcCXYYryOGbGtBD+vsZwTAzCtHlVGYpmEkAohRTRUGGZWBpl46V9LMQCCbHEigLTWUZhg81pITFrFr9wTt/lveMMboP/whz984xvfkC57aDiWgeBVUHTeAmqSbk5Hxbl0NBIDm6tYKVDXkehFinWSlWZXzvzqV7966aWXXnbZZb8/vEFccsklMDsE1qdycOeVuV1HbJ3BSqZVKsHPayzn2EIl0ey0UqWBWRkk8tGL1OskG4zXNbWYAjBBLpVOm2OIimnOXIKK4h2+bHEVgJFPfOITiS4cGUdS54HoWibSZi5CREW/YW4RxUqZuo5EL1Ksk6w0u1omnwb5/Oc//5Of/GT37t3bDm8QHMKkqUNsyiPVYt1FKkdn2rfddltSYxFbZ7CSaXd14Oc1lnNsJCeanebyzZy6IKMXWaiTbLZf3SpwDXE8rKMxRJP2kaiT1zqHn3QEvOZJFJnLEaAVQnYY9mym1YpTZGwHms2RwEcdjrSSvcVsBJumE2EdSqXORTRodXfElrW2VFRWQd6S7rKNLEJEU4vIt5K5+eabL7roolzlwgsvvOWWW3LXOSfXhSMxC5uoFIZJglwDMVkoCs9mJjIR2+hO4B8usZkayzmVsdlUZSQNKlOoJQevOFtcC3DHZCLu3VRJqNuAiwqbkoek+GKSS3FizqDV6jqIKrIjjv2iIr45JjAl2kYUUqUdSUqlzoXCo1UCsSOoa+TDxIujyiXh0OogFyfcncVVmiWfe+45TvjViw77ZuNqVcxxP1fLkVAhAOU6ET/PIHwzE2xz8PGuJEpLweScPEjkxbRNO4UvZqIllaQJX3CQlFNoNiS1qbO0DltLGI+xzR7MtkW5SMuEDZmIMpFWryJny9PkjKSqm0vq/lzY24L8s5/97NRTT5UWP/V1q4Bbb701d51zKr1LzMImKoULUwgMXksJ7O2uBaDsjfigdUZn5kQIokq2kQPjqhJfs1EMfFIiTu0jR7K4u1/84hf+rjTx33PPPQcPHozqBw4c+NGPfkRTZHagp1w5eXeSQuIwl1kqZ+m1FOdaehIP6+jY4TqZwl82Agsma/EwPvShD/G/jOVvuukmvkK7d+/epw5vXJPjUAK565xjO5EolRPRWBWdJGvm4T9mOMKKeSr0ZBEYPFlvectbWP/v2LHDXf7pT3/62c9+Vpej+V+Kjy+dccYZtOauc46NFGJqCCTJmhnzSdvUQi/xRASGTdazzz579NFHHzp06EUvelH0Uklfd9113CAYm4YNJlou9OAIJMnqfi1g8MiKwRUi8Lvf/e71r3/9IuOfIJPxv8Kwi+v+CJQpoD+GW8FCvBa4FfpT+rAwAiNNAbrHU099LRIba5VFxEaTaRtPW/nROlLn6Je//KX/DqiTGZ9f+cjd+GF08Ni2ANrKdwipTmWkKYC7OLnQqFsv60Ixn8SbngLRNp628lPo4zSngCkg0yGGtgXQVr5DSE0q8Z8J5OLhULTdY1Au+J9c98xxCJ3cj+XDPAAJ604sdH37FIS9+AYy7Pi2Kkz5z3kIWTZHYURmdB3jyVVoZZO8aPYKJhoZnMbFUDafeeaZI4888l//+ldngwMGE2MQ2k6u051nQRzrOqHOBTWj1lzXWiaQQTEvs0rdxDVG7BQ6V6GVTb5Esx+hYNy7JFkzZZS0Wac/YcsihAt7LJNXp4dWBm2OqQNQkwe5rGmcS8a6ImRZNSTcoZ0AuUPRWnYUidhaqYJBzNpylI92hqXV90FsxvsCuxkcMJgYgJAEWJhGVQR7M6HZYgzQcFBMSgsVmigY60Lkm6wt4jfXhRODqXS3koJxqBEomCubAjwO4wBWlBFBx13ZhBGEExmlPzESuy0av64PLECrMhJrHNpUnYoE5DfK56YG5MQe9TTLI8C8QKmPkQGDiWEYeTGV7jiw4ZM4OImkcpGXVl0Go1PoxFqD30RRh1avcyeBkQvGoSbJGulaAF7rNu5/JIVcDtFWJzaXnz9V3qzS4YnrOpWTTz6ZQmSDaHY6zda1uxAQn5+PdAJvXlp1GUwU6w6jr0jXyde5m1TBrH4KAL5WT2jncNc9VZ5LRk6HJ67rVAhg//793DwLEV2sC712U0B8fj7SOeBJadVlMFes5ERfka4UhlnnbloF4+UBBEHHwwFpWxbBQsgnAvr9lC9onYBZPonBSyzx8xUa6ugilkhGg6ZNYA1Tcp141KElTUQVmCz52NxqotLaIMyhXPS/Fkh3hgomQSZJotItJnuEI00MYpJHSc4trbqky6yDafZrsUgYEBO02h3M8QvG4cWQYM6M+aTNOv0JWxYBxMBhs9Dw2ciZmOIooxaDqMwNfKmzV/rZJ5I02Y5pyUjX4z9RlJbjyVVQd9gQMm55Ox2ccC96Wu5/LZAAhgom6UuSC1CFg0zMgjgwySBhsKkGxFciYDpHUddJ7+NXBhMLLoDcXQxmzIJxhARgGqI8IwAga7lx6YT89Q/9a1/72m9/+9uvf/3rfUwNFUyfGIrugggkyeryKZEFPfUXI9bEyCBFn9jc8EMuBJx++umbDMKGl9kkLgfW1V9croiukyz8zgis3bXAzj2tU9zwMptZTCYrhDrICn8KCAySrFbPCDf0epBgGuyXpgERSJI16VXAgN0upioRaPWMcKWFwlx3BMoUsO4Z7BV/eUa4F3xbQrlMAVsijV07US4EdEVu6+iNNAVw+tEKs7byrYx3EG4bT1v5DiENorKOU0BPbOeqzxVIkG8rn6iv/HCkKaBVP1f8+HQWa9t42spnDkdicC2QUHnZ+Uj+hnDTE9u56nMFkk60lU/UJ3EY/xEhoHg4IG3LvoULju/NSm7h8mEeAPda0ap7qqKF3KwkddOuvPs+LQhZNgeBhBldx3hyFVrZJC+aPQbZopHB6f72B7kvUP3qH0wdPgZTt/f5kETA0SE02/OIH96gZS1nWj0KRNdRoFIdAclDaJPTaGTiNAHHCGcPZtuiXE9aXuNd9MIXs4xeZRcaMWTclDtVk+YOi1WaVassa4IgYXInwu4gbCr3mLQqwoSJQVywyXKztUoXHZhJIjtY6P+MsJ32D8amIgGkdbUhkNlLvjIvOXNuaqJAro6vleQ6YtKfTpI16hSQRE8oIB4HsARiGhKVpIl8wElkZDaRjN0WjV+XFxag4SSmdGhTdSoSkF9ULF9pbShm7FE3m8m3Q7oZkVb/YCq9N9QGIGvCRbEyL5XMuamxQKU6viQwcq4rwenMTJK1gmsByYP9+UPdhNhhS8zOtVD3LHeDYp3KpB7/bog/aZr+tcAFa6MyL5XMBIGGwzr1Nc11Q09HXQVoUmce1QRGWKbF4aeYtZ9n4nyeS5q0Cqg0m0jiy9ZEJ9O8W3PCpupU4BMJZiFQt3xuakBO7FEHs4M8I2y/PYOxnQYiqQ1ArlsFyEhlsuamxgKV6lheSa4bYOnQlCTr/wcGtpK2DtbrVGQ5ntpBwwRxUssmRQj4DZE4Q5LXFFBpNpGMXTNtAmuYkmtZTvaWNBFVYFIZbG41kdgZ8LCniwGvBdKpnsHUwXK4NKprg/x6CkgCcCpjVJXMSr/WMoFYVB8/15VxdmbGfmFk1CngeX//3RhvhhVCbM8F4pDmpJ/JwEZMMv+1Wt4XkABWezjgtUCltdZTv4a62uDFOzTZtgpDZeCpvJIZSyspJ1mzQK6OfZcoBIeoWN7BTJxQ2A6yPCakslm/PXekkMXOcX/4wx/mGeGPfOQjnS1ExZ7BRFOFXjYCSbJWcDlw8R4Sa7ItrlskmxGY/rXA5vhL61AITHoK8FrFxFDd3hp2LrnkkoceeqhDX9bxvsAO3SwqiyAw6SlgkQ5ssgzvsb7gggve/va333rrrYzqBIr77rvv7LPPPvbwBnH//fdboDwjbCgKUaaANa6BT3/609yj/rnPfe673/3u8ccff9VVVx04cED94WrfpZdeetlll/GuazYIlgww1VqeEV7jrA8d+swlJU68+1xhGjq2Yq8JgSRZDH5eAfqtb32LRcHu3bs/+clPMs6ZF2ziL3/5y6mnnvqb3/zmuOOOG/ZaIC6SYOy0EBNEIElWWQVMMEddQnrNa16zZ88exvkHPvCBL33pS//+97+/853v/OMf/7AtpoN3vetd99xzD5xyLdCwFGLmZz+ZHsZEB9f8DZt8kKuSOWBUlf1tdlqp4pCaWy02CIGvznbOOuss7m958Ytf3NlCojhyx7VWbet02fIJJpM9THDY6FVAh7OeBpXxHx0nmGTjtt9bbrmFy4Tbtm277rrr/v73v0eBCy+8kAuHcO69994Bx//ItU78eGyL9rLlRwZhSHexRLAbDwekuWHLQfvmLd1RC183WrEKwGPOhI+A78GK92xJBS21ypTCzjl5d9zf3CnCcpRoSYUm7CtsOOqRPVqXJjYHGb0gLL68REk4sb9JAD5ExTQEJf6pT33qla98JY/WfPvb3z7qqKO4OpAIwHzyyScjcyg6CWYos9gxaHYhwmhDICOPAhPahCOxvFuxw4YkHFrZJCyavQRsYcsQ9Cv2ZfZgti3K9aGVRVlwbkQoAZogoNmclUomRhBQyiUMB0nGjOyrNeeoNdkLi0qniaQPowpe4DsMEzDzIOu8NEvab04oEs75f/CDHzDsGfxMAUwEkrzpppu2b9++d+/epw5vt912G4d8+DS3MwhHwQxiKhpJQNMolS+jTTE4+xCeDqIdaMtD55jDxDgJZZOXKJ+YWvfDJFljTAEJZEQAvmDtzCHQwERYWUEs5ptDpRxm0quck8SgQ2lVRlIpD1MqSX0QHhwzK4NMvEilUhI77m9dGIqEpf5JJ53EdX4W/5wCJMIPPvgg5/y6LwCCw0RgwMME/6EsJ6DJbJ4Cw9UQRnN2sCwBLED4cKiOTMpOgtJ4HxTjeX6qEPfe4hfayaL4lUyr6Clufs3MQZ4PSFMrXOQQE7j9nLk5lq8kmp1WqjQwK4NEPnqReqXkKaec0mA8NvGHP5f9d+7cGZmmzzjjDM75fbimRA5a3hFef8jyh6HLT0LemnAqMadg9CIAhJNr0on61jsc43IgD3UxPlmLai40iFSwac8OlUyL1X2wPfmMPPI5x0ZyotlpLt/MqQsyepGFOslm+27lLoC68W+ZdSdy0PIe7dq166677tq3bx9E3ppw6jCnSvfv38+vC0SissUP4xKFrsbDoei4nIPGi9ZaJpqZCHulR0gxSPgy7nMKiEpOZV9sqjKSBhVCsi5ihOEeSStpJSSpSEznKYmK7Egy9rcyDJjRRZ3MaPwlBZOAJljsywTdJO9zQbO8CRTRAnMImORFqRFuUUycrbFP+jUz5pO2ATuMZW3AbdCVYPhav2lI5Ew4MbsWQFHJI04EZN9zQc7Ju4OKmLaZR5JoSUXybsIXHA7lFJpN8bB3kCovOKpXZFDJJeFgx8brCEVS1zoyf3nBGDS7MGG06SyQsrnXQtWHIiyfY45Nq0PIheUTO+t+aADVkancGkRYW3tjeXnNNdc88MADdJMTV074SUCfLic3ePQx1V935cFwpYkzzU07je+WuCRZY1wL6BbosFp0O9mGtT/XGhecuGqlGBj/8Ydorm4RaEBAV5rAtoz/BpQamsoqoAGcSTcxm/RcRwzYvUkFM2C/tqSpJFmbsgrYkrksnSoI9EegTAH9MSwWCgJrjECZAtY4eSX0gkB/BMoU0B/DYqEgsMYIzEwBRx555NNPP73GvdmY0P/5z3++7GUv25juduwo170aNJtbGxQrm7DGf72VTXXMtgG0la/zm/BnpgBeKfX4448nEuVwggiQJp78m2Bg0wmp7YAcOfK24bWVX7w7M1PAG9/4xl//+teLKxfJVSHwq1/9imStyvtofql7fvpuvPFG9my+e198MT02/F3Zyy+/nAgvvvhi9siwtwUOoefGr3sNZF/ClR4tJo8NklKPfmN4uXH6wiZ50VE+2hmAjnc73nzzzbyUOnIKPU0EeEEgzwhNJzYKcRnB6AYq3WEtmr0JPJpGxnf4Egy3FasJmXjbv5nw62K2TWQwy23CkWPahMSwBkdm8QghAYjKLbYqYMQiE794VwBJU6XBxZlJx2cyx9sleLHMI488sri5Ijk+AjzQRpoOHTo0vus6j0lV1Ym15cchgS6DXKPCo93MOM7lJdG16zhWzYwELqJ9mhJOZRgySxhRF1rTQbQv2uHVqUjA0Vo+N9WWkyRr5kSAF87x8umrr74aobJNEwHy/ZnPfIYcveIVr5hmhMNGpWd1ZNPvDjABX7TfEBFX7zESltN1TVEsceSm3CNNkak49TICOWLPo8dwbKSSqFPR+wuYRJZ94/PMFECIV1555Z///OcvfvGLleEW5soRuPbaa5944okrrrhi5ZGMHwDvDuBpf/zGlwiYrntDhM7Y89dVNMRvm5aJHNMmENMLL+peRmA7OVGnQtgjvb8gX0XwLvoTTjiBqyZ5U+GsFoEbbriB1Dz22GOrDSP3TmXnzP4crX5Zh2PKK2ER7M2E5teSTR4hpKKo4jIeGqZ062KO9lml110LwJdN1ZnV+byiyvcOwAQyVoGJdza3mshNteIkdqozx39Op5122vnnn//oo4+2sl6El4TAwYMHzzvvPN4FxhJgSS76mE2qqo+pqKvRyJDGPpuGLgLiJ0wtxWF6LhAnCjNW4xiLviKtgSf74kcjeRiKUPwoibuoHl1AO7xcJfZCxqN8YqftIcajSu3TZs8999z1119PH/giJSdavKPy1a9+9Ute8hLhUvYjIEAKGPk///nPWRPyjVDO0bhSM833/3PeS1UNjgn/lvV/scLgUa27wSRZczLHZec77riD11STDF5Bz18G697/NYqfy/68/5cx8N73vvfcc8/lYu1kg0+qaqg4R5gCiDyJdhlzWeJitYdJsuZMAauNtXhfFwSSqlqXsDczziRZ6T8CmwlK6XVBYGMRKFPAxqa+dLwg8DwCZQoodVAQ2GgEyhSw0ekvnS8IlCmg1MBmIZD/BbB4/9vqtpVfPJIBJcsUMCCYxdTUEeBfxs4httVtK985sJ6KZQroCWBRXy4Cfibfv6gMLWhtGmbiOA6a4LDxaBBP8ktSrwnwU/e00qRnh4455hi8SB0+8tAmbNa6bo0x6Kl+CYuO8jYyRSLeKljogkA3BKjsborNWrpzVjfe6t7eyDEtwqYIBo6YukVXNAIJwSFMbgf2PcUQHNpUJKwLExcSi0zdeqw4kYlN0c7K6SRZS8ncyjtZAhgZgaSqhvLOcPLglM2EQyucZLDFKcCRMD4RsyQEnNgquqEj1o1TBlqeNSQg7/Atby8TIZI+vpDjshUEJotAfCZfQUZOpPt0ge+RsfJn0DKe59rRE/68C8CShMFzNHrCH+ayn/C330GIci1gEBiLkWUhEJ/Jl4/IiXSfCHbt2nXXXXft27cPYq6d1T/hPzfEVgITWZyUMNYaAUpuGfFrLc0e4yy/tZjHlzix1UyditOkVkclXQ4VKq3xRAA+v/8Jx7om3E0TNKGFUwiYBMnmVhO2MAUiiaqcCABI2SaKACtqRhTPSio+DTNGrznQWnUzCMWEaO4MI5Yr+f4LIApzOuBDzgswKI9mShenbPrjgCY88sIiDplEOB2AA8Ehupaf8qlBeVLQ+S1EdwRU8d31J6DJP3m8XGzKY3UokJJklWsBQwFb7KwrArr1gCXAJoz/PEllFZBjUjitEUh+WFrrF4UREUiSVVYBI2JfXBUEpodAmQKml5MSUUFgRATKFDAi2FvXVfkm9brkNv8mdZkC1iV3k46zfJN60ukJweXfpC5TQICnkF0RKN+k7orc2Hr5N6nLFDB2Drakv/e9733cXbslu7bFOkWazjnnnNip8qdgRKPQHRHgexPcOc939dh3NFHUlo/Aww8/fOaZZ3JrY/wmbVkFLB/4DfBQvkk9/SRzw3LlN6nLFDD93K1HhOWb1BPPU903qctjQhNP3NqE99KXvvTOO+985zvfyR+EH//4x9cm7s0IlGeZvvnNbz7wwAP5Z0HLtYDNKIGxesmHj9///ve/6lWv2rNnz4knnjiW2+KnFgE+Dn7VVVeRl9tvv53/bnO5ciKQY1I43RHYvn37j3/847e+9a07d+7cvXv33r17easHn0jubrFotkcAwIGdBx8vuOCC0047bceOHffff3/l+Md2WQW0B7hoLIBA+Sb1AiAtS6TVN6nLFLCsNBS7BYG1QKCcCKxFmkqQBYFlIVCmgGUhW+wWBNYCgTIFrEWaSpAFgWUhUKaAZSFb7BYE1gKBMgWsRZpKkAWBZSHwf2NHm0jSg+AdAAAAAElFTkSuQmCC"
    }
   },
   "cell_type": "markdown",
   "id": "e7744f48",
   "metadata": {},
   "source": [
    "![image.png](attachment:image.png)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f223b6ad",
   "metadata": {},
   "source": [
    "### Create tables"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "61e40076",
   "metadata": {},
   "outputs": [],
   "source": [
    "%%sql\n",
    "CREATE TABLE IF NOT EXISTS people (\n",
    "   person_id INTEGER PRIMARY KEY,\n",
    "   first_name TEXT,\n",
    "   last_name TEXT,\n",
    "   address_id INTEGER,\n",
    "   FOREIGN KEY (address_id) \n",
    "      REFERENCES addresses (address_id)\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a8476f8b",
   "metadata": {},
   "outputs": [],
   "source": [
    "%%sql\n",
    "CREATE TABLE IF NOT EXISTS addresses (\n",
    "   address_id INTEGER PRIMARY KEY,\n",
    "   house_no TEXT,\n",
    "   street TEXT,\n",
    "   city TEXT,\n",
    "   postal_code TEXT,\n",
    "   country TEXT\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7eb5e062",
   "metadata": {},
   "source": [
    "### Insert example data"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1fc8f0d2",
   "metadata": {},
   "source": [
    "Let's insert an address and a person into the addresses and people tables."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "53a38c2c",
   "metadata": {},
   "outputs": [],
   "source": [
    "%%sql\n",
    "INSERT INTO addresses ( house_no, street, city, postal_code, country ) \n",
    "  VALUES ( '3960', 'North 1st Street', 'San Jose', '95134', 'USA' ); \n",
    "INSERT INTO people ( first_name, last_name, address_id ) \n",
    "  VALUES ('John', 'Doe', 1);\n",
    "INSERT INTO people ( first_name, last_name) \n",
    "  VALUES ('Tonny', 'Homeless');"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "868367e9",
   "metadata": {},
   "source": [
    "### Show inserted data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ba16b7be",
   "metadata": {},
   "outputs": [],
   "source": [
    "%sql SELECT * FROM addresses"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "faa35b15",
   "metadata": {},
   "outputs": [],
   "source": [
    "%sql SELECT * FROM people"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "63470e04",
   "metadata": {},
   "source": [
    "### Drop table"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8a9afc84",
   "metadata": {},
   "source": [
    "Try to use the `DROP TABLE` statement to remove the `addresses` table."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fadc2ef0",
   "metadata": {},
   "outputs": [],
   "source": [
    "%%sql\n",
    "DROP TABLE IF EXISTS addresses"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "EfDS2",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}