-
Notifications
You must be signed in to change notification settings - Fork 0
/
migrations.sql
67 lines (59 loc) · 32.3 KB
/
migrations.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
PRAGMA foreign_keys = OFF;
DROP TABLE IF EXISTS "loads";
DROP TABLE IF EXISTS "medications";
DROP TABLE IF EXISTS "images";
DROP TABLE IF EXISTS "drones";
PRAGMA foreign_keys = ON;
CREATE TABLE "drones" (
"drone_id" INTEGER PRIMARY KEY,
"serial_number" VARCHAR(100) UNIQUE,
"model" VARCHAR(20),
"weight_limit" REAL,
"battery_capacity" INTEGER,
"state" VARCHAR(15)
);
INSERT INTO "drones" VALUES (NULL, "QWOIEJO1202115", "Lightweight", 250, 80, "IDLE");
INSERT INTO "drones" VALUES (NULL, "ASFKJALSJOEWIO", "Lightweight", 250, 30, "LOADING");
INSERT INTO "drones" VALUES (NULL, "SLDFLISDKFDSSD", "Middleweight", 325, 100, "LOADING");
INSERT INTO "drones" VALUES (NULL, "FDFIEFE5664846", "Middleweight", 275, 76, "IDLE");
INSERT INTO "drones" VALUES (NULL, "DKFJDLKFJ79899", "Cruiserweight", 400, 10, "RETURNING");
INSERT INTO "drones" VALUES (NULL, "LFDLKSLDFLSLOO", "Cruiserweight", 410, 1, "IDLE");
INSERT INTO "drones" VALUES (NULL, "DSLK0000000015", "Lightweight", 220, 99, "IDLE");
INSERT INTO "drones" VALUES (NULL, "SAL79879879313", "Heavyweight", 500, 57, "LOADING");
INSERT INTO "drones" VALUES (NULL, "SDFSLKD4898499", "Heavyweight", 480, 89, "DELIVERING");
CREATE TABLE "images" (
"image_id" INTEGER PRIMARY KEY,
"mime" VARCHAR(50),
"base64" TEXT
);
INSERT INTO "images" VALUES (NULL, "image/jpeg", "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tMTU3Ojo6Iys/RD84QzQ5OjcBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAFwAXAMBEQACEQEDEQH/xAAcAAABBQEBAQAAAAAAAAAAAAAAAQMEBQYHAgj/xABHEAABAwIDAwgHBAITAAAAAAABAAIDBBEFEiETMXEGMjRBUXOBsQcUIjZhkbIjg5KhFdEWJCYzQkNSU1RicoKTs8LS4eLw/8QAGwEBAAIDAQEAAAAAAAAAAAAAAAEFAgMEBgf/xAA0EQACAQIDBgQEBAcAAAAAAAAAAQIDERIhMQQFMkFRsSI0gZETYaHhFFJx8AYVJDOC0eL/2gAMAwEAAhEDEQA/AO4IAQHnaM/lt+aAZlr6OGQxy1dOx43tdK0EeF1NmbI0qkldRfsef0ph/wDT6X/Gb+tLMn4NX8r9iVmHaFBqEL2De5vzUXRNmIZohvkZ+IKMUepOGXQTbw/zsf4gmOPUYJdD2CCLjULIxFQAgEQDVX0Wbu3eSA5hgrcaON07p8QzU+31jDt7b7uZw61sxQtoX1ZbL+HeGHitr+2UfpI98q/7v6Groo8B6HcXkYevczDuaeC2Mt3ofR0g+zaRbmhVkz5dHUqK5973bGeJC5punzO6ikZrFGSSODmNYLdTS3XitWLZ1qvoWNKEHrJ+5SSMxJocaemo3jXSZgdv4qU9jks4P2O6FPZk86kvc6vhTS3DKRrt4hYD+ELuhbCrHkqzvVk11ZKWRqBAIgGazok/du8kCMRhRk9cg+1YW59QN+9QWdRL4by5GM9JHvlX/d/Q1dtHgPWbi8jD17mYdzTwWxlu9D6S2bXwtDhf2VXSVz5XialkUuJYfoS2nDh/a/5XNOkWFCv1kZPEIHMcb0kZHZtQP9S5nGKedSxd0Kia4n7fYpyacSZJ8DppGn+G6sbospSpxg3Gs2+l2jram1eNRr/E65hwAoKcBoaBE32Qb20Gl13w4UeKq8cv1ZIWRgCARAM1vQ5+7d5IEYbCbeuwHYEfac4cVBaVP7T8XIyfL+nkqeXFbFEPaIj8Bkauyk7QzPUbmqRp7vjKXz7kjBeSNNiELtnUR1Dm87ZyB2X5HRYyqSRq2resqTs1b0Oux1EG3NKJWGdjA90Qd7QadAbdmi5/meKcZWx2y6jxsepQYkWejZLe7reC1SpKRthVcShxKgjIIdKCOxzAVxVIuOkizoVpdO5oqIBtJA0bhG0DT4KwhwoqqnGx9ZGAIAQDFd0Kfu3eSBGFwcg1kGWdx9vVp4qC1qp/Dfh5FdjlJDW8uMWgmcWiRkbLt3gGNq6E7RRb7JUlDd1OUeTfcm0XJPFmRSPglpYnBpjZs5XMdUtM20OdzQC3QW07TuCOojjq7x2dtKSb55pO3htkm8888x79iuN7GTNUROkdAIwTWSBxtM94BdluRldbw+THE1/zDZm14cr34V+VLS9tVcWiocXo+UkUU0jmwsYXesufmZnfEyOwBeS4ZwDY2KxbWEirW2aeytxWb5c7KTfS2nQsqPCsVppqeZ1bE8RZrB0ziHazWaSb3vnjJ7v4BQ3HoclTaKMk0o6/8/6fuWEMtTLUwx1DaIB+YFrHFxNr7tLdh1WqVOLRoySbjcumDK0C24ItDmeoqkAgFQDFf0Kfu3eSBGHwraetwZo2kZ+cOrVQWdXD8N2ZmOWlc+g5e1szd32eYf3GrrhHFA9Luqiq27ox/XuSsOxLC304z1E1gNWmQC3tZuy+8D5LGWLoc1fYqyk7L6G5p+SWHhjDM6SR4yknQNJFtcvVuHHrutWNnnZbbUbyyCXk3hdHCZiyoeGEusH3OoDT+XmTvTG2Y/i6snbI8so8FZSspY453xwkPDA12+wA6vgPFLyvcOtWcsbebH8LoMMhrI5aWnqI5gwMBcH5QGtIA107UbdjGrWqyjhk8i9WBzAgBAKgI+IdBqO7d5IStTE4TDlq4XNLrB+oBuN/zHihYVKqdNoxfpH98a/7v6Grto8B63cXkY+vczLuaVtZbvQ+kY3jK1txew0VafK3qKZGDVz2jiUIGJ5CbbCoijffXNY37PLzQlW5niGZ8kzf23TvZqcke86cVJLtYnjcoMRUAiAVAR8R6DUd2fJCVqZPC4y58UmhaD23t528CoNsnyMB6Rz+7Gut2R/Q1d1HgPb7jf8AQw9e5mHH2TwWxstm8jvVc5hqd0eYBpJIjuNN93a9RVcfMCMzY3Nn05bm3gw6Cx/q/D8kA7nY5rHNewNuA7KWXvfu/ihBKw1rjIXt/exfe4X+GmQWQhly3cEMRUAIAQEbEegVHdnyQlamaooQ2Zr26G4vcX/P9d1Bm5HOPSL74V3CP/Lau2jwI9zuTyUfXuZl3NPBbGWz0PoKaWoY8bHVuUfxBdbd13Crz5e0rg2esMgGU2zAG0FvzL0FkI2SufI1tnsb1vLGf7j/AOCEeEnAm1ibntQgls5o4IQKgBACAjYl0Co7s+SErUz9Hzm8VAkcy9InvhXcI/oau2lwI95uTyUfXuZp3NPBbC1eh3yoe8S2a5wuBo17+zXQNKrz5i9RpsskzWOyyPa6zvZ2h7d2gQaEuikcC5r2Sgude5a627tchDJl0MCWzmN4ID0gBACAEBDlw6Fzs8Y2bvhuPggMXyj9Hc2N41UYh+k44Wy5bM2JcRZoG+47FuhVwq1i/wBi32tloKlgvb5/YhN9EwtZ+NHwpv8AssnX+Rvl/EkuVP6/Y6K2ms0DOVznmm7u4vqzeslCBfV2dpQC+rs+PzQDgFhZAKgBACAEAIAQCIAQCoACAEAIAQAgP//Z");
INSERT INTO "images" VALUES (NULL, "image/jpeg", "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tMTU3Ojo6Iys/RD84QzQ5OjcBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAKAAoAMBEQACEQEDEQH/xAAbAAEAAQUBAAAAAAAAAAAAAAAABAECAwUGB//EAEYQAAIBAwIDBAQICwYHAAAAAAECAwAEEQUhBhIxE0FRcSIyYbEHFDRzgZGh0RUWIzNScpKUwdLwF0JTk7LhJDWCg4Siwv/EABsBAQACAwEBAAAAAAAAAAAAAAABBAIDBQYH/8QANhEBAAEDAgMECAUDBQAAAAAAAAECAxEEIRIxUQVBYXEGE4GRocHR4SIyM7HwFBWiFiNisvH/2gAMAwEAAhEDEQA/APcaBQKBQKC2RgiMzdFGTQQm1OJX5Sj5+j2ffQXw38cxUKjekQBn2jP8KC9bpWCkIfSCn6+lBes3MMgePf4UF3OfAfXQY2uQvVSen2nAoMDanEuSUc/0f5TQUGqRc5Xkfbr0oJ43AIoK0CgUCgUCgUCgUCgxXfyWb9Q+6g0Mn54+Y960GewHpQ/OL/pNBKhHoRfqRe80GeIeiPJ/fQZj1Hn/AAoIko2X/t/6qDWSj0T5H3SUFo/Ov9P8aDpE9UeVBWgUCgUCgUCgUCgUGK7+SzfqH3UGjYDtSMgHPf5j7qDPaDs2jLMNmUnHsBFBLhQ8sfQ4CA/QTmgzpGygD2N9tBkI3Hn/AAoIsowB/wBH2Gg10sfon0hj6fB/vFBFM8QlZebc5xsfb7KDp09RfKguoFAoFAoFAoFAoFBjnUvDIg6spAoNXLYyq7SEry+w0EKbULe1l7OXn5vYo++gkw63ZgDaX9kffQZjr1oP7sv1D76CxuIrL9GX/wBfvoIlzxLYIp5lm+gJ/NQRBrllcRs0YmwPFR99BKj0eeVo50ZOVwGAY74NB0iDCgHuFBWgUCgUCgUCgUCgUCgwXMqRxkE9e6g568tvjFyHCk7eFBfHYtjaM/s0FZbObHoRn/Kz/GghTW16OltI36tuP56CBPb352+JTH/xh/PUIX2NlcEMJYXj/WhA/wDo0Hb2hU28YB6IBUpZqBQKBQKBQKBQKBQUJxQaqe67WVgWIjXooOCaCyNI3YHl+s0E2KBMZFBmCIB1oMUrKpxmgs7aP9NfpoMbyoOrrQYjLbk4Lee9BYzWo3DuD7GoMtneqsoiMhYN05j0oNrQKBQKBQKBQKBQYro8ttKw6hD7qDmdNJuWLMdupNBN7T0vQGFqBlxJKu/MoHcPGgxiFw3Nls+PjQXlXYjnLbUFJIebdM58CKAkCqA0q5PcDQRmhj5z2ceAem1BgvNPkE3MriOLHfvv4UERwY5IijZIYb/TUjtV6UFaBQKBQKBQKBQYL44sp/m291ByWgyFrQEH1hQec/CHrupzXj2tlc3EMKEhEtmZWbHecbmtE1TMunbsUU24mYzMvOE1fXZC4i1PU35N2CXMh5R7d6zzLTwW2Vb3iV5OzW61pn7LtuUSyk9n+nj9H29KndHDaViv+IJLhrYX+p9umeaNrmQMPoJrHMs/V28ZwmQLxOZUeefVzCD6ZFy/T9r2VMTLCqi227i/Ldoo19oQCMLdPzAg75/KbVlmWmaaVssGqL6o18MpVSvxp8kkP3c+cHl+z6DLHFLo/gwkvvxkuYL2S+IFiWEd3OZGDc4GcEnB+rrRFUREO11W8htJIe3Zl535VAUkk9e4VLB6AhyAfEUF1AoFAoFAoFAoI9/8huPm291Bx/Co7TTomI2x1qB5ZxhdS2GsSXNvy9rG78pdcgZyD9hrRG0uzNMVWohzk3G+sSdoF+LxMwwWi51I69PS2O/u8BW3fGVL1UZ5pdzx9q99DJA9tpyBoOwDQxyIyLvgrh9iASB51FU4Z0afMtTAs81ybjt3M7ZLSBzzHPtFVa7uHTt6SZjk38F/aJYxxXtpcXMkeQX+OOFbJJ3APgdvKlN+EXezrmcwhvrNhFzD4nechbOBqEmAMjbOftrfTcieShd0tVPNDg4gsoVQtbXrz8uHPx18McdcZ9p7u+tuVWbU5dT8GN1b3et6xNZwPATpj8xkmLknI35jk06kU4qpierrtQuzJc6WACJIWyzZ2JMLHY99TEsLtHDOeuXrEfqrn9EVLUvoFAoFAoFAoFBHv/kVx823uoOS4UYHR4AOoGD9dQPIuO1d9QlSNSztIQqjqSTsPrqvMxG8u1P6cNt8JXD1ppXwb6L8TWI3FlcG3uZUXdpCrcwJ9jAiptRHDxTG8ubTVM3Jx4t7xhprWraTpmnadYPw7fvaw2lxFGO0ik5wSS3fzLn+hWmuiLdvMRvjn4t2mjiqqqmd4zs6LiuwsfiOtQ3lnaQQckcencqKrtOwO6439ZlH0GortW6Yq/DjEc/Hf+e00mouW7tFVFUzOd48P5lJXT7Q8WXUUVhbyLZaWgEfZLhpGYn68KKx9Ra9ZTTNMcszt5fdM3rv9PNXFO9X7R94ar8FafdcXcNRXltaHWY7OSXUYoo15ccmBzKNvWbb6azi3Rw0xNOMzy+LCa6uGuInNMd7RXGgWPE/BWspawQLqUt5dXtmsahWKxyGNQPYQuPDLVYopp4qpiPD4Qr8UxiUPhuNbXXrjT4o1ElrwzCkgRMEyEKxz4nDLS3vRxdWdH54nxTp4+e/slPOpLoDvgj8g3d3VnSy1E/P93sajCjyrNWVoFAoFAoFAoFBHv8A5FcfNN7qDj+E1IsE8KgcDPJbwcbRXF1bzXKwSSSpBFHzmR1DFR5ZGT5VWqp4pw693PqNlY+Lotf4ZbSNc0GVL2fUkuI4LKyISVVdXfO49NsSA+ea3cO04c3hmmqMJmmcSaRpNjo+nadDrNzpkV+btpbq33RQDyRoP1iu/sPjWmuNsVT3x7MLFu1XdmZjnjrzQm1KC84wfV57eYRSXglVZIsScikAAD2hRXO1dc13o3/Ds9Fo9N6vQzTwxFeKunfnG7o5eK1ccRX1laXZuLtY47Uqinkwm3NhtvSLdO4Vai/bruV1xPdiNp8fs5X9uvRTat3IxvMzvHh49IWx8V6VHxhLrMNhqTTz2IgEa23WQHJOc7jCj9mt1M01XKa/D+fNovWL1uxNqcYznnH1cLpfE1xo+scL3dtZ3zWNnYCzu17BsuzMTLy+O/KfMVuojhjHnKnVRzy23Cl+NW474o1NY5o4LqzZou2iweQcqjY+VZ9SiMTT5tzKp/Cli+eYNKmGxjP5Fu7u/wB6ilN+cxHt/d6+vQeVZq6tAoFAoFAoFAoI9/8AIrj5pvdQcjw5JyacigDOM1EjzDiGW6j4iVLGbsZ55xAHx6oZwP69mRWiObsV0xNqM9G1l0nWbqO2uYeIGZvRaMLbIojDKqsW37gzDxIHfW5zcxHcyNa64sLltcbmYOyEQLykGRlUEg7ZyG78YOOlY1Z6ttFVETvGXGJxLeXd2l9NcuLlQOV1PKU6nbHTqa59ymuasy9Hpq7NNv1eNpdZwzHeTaY13a6m9qju3MOy58lcYPXJ326bE+GaysWKojMS0a7V2pr4aqM4x3rH0vijU7xzaa1Y9pDPJap2pwTkhScBSN9tvPbrVqimrnly7l2zjEU4zhAtF4w1XTIrxdX04R3MXa4cZYBjnGyn0thsO8Y8c7YhTmaZnaGw4WjvLfizVvwjepdsdIZkkiPKAvOcj2EMG+ynUpxxU46w2F1IDeWrIOjLgjr+YY7nxpSy1EYiPb+72OP1R5Cs1ZdQKBQKBQKBQKCPqHyG4+ab3UHIcNKDZptkY7qgcVxXwPrOoXTy2j2YUuSC8zKR39y1wL3bels1zTVFWfL7uxFcVURGHJS/BRxFJIzyS6czsSzM07Ek+J9CsY9I9H0q933aPV+EKxfBXxJC/PFPpyNgjmW4YHBGDvy94yKj/Uej6Ve77p4JjfEMyfBfxKuwm07/AD2/lrCfSDRdKvdH1bYqrhVvgv4jbrJppPzzfy0jt/R9KvdH1ZTcrwxp8GPFEEyzW9zYxSp6rx3Lqw7tiFrOn0h0ndFXu+7VVTVVHJDb4KuIB1fTf85v5azj0i0fSr3R9Wr1NXSHVfB9wlqXDc+q3N61qVawdV7GQnfIO+w8Ku6PtOxq6ppt5zEZ3/8AWE26oroz1bzUY3M2mSc/Mkx9AYPogQv7fbXRiMNN6Y4pjpl6xH6q+QrJpX0CgUCgUCgUCgjaj8gufmm91ByXDRxaIPZSBh1CznOpRzPbtNAhJZAV32ONiQDvivJXdbpbd7/cn4PR2L1HqJoirFU/zuRmt7dzg6BIuVC8yiHPtPre3r1/hs/uvZ0xy+DZFVyN4vx/l9Fs1vDKjhdBlid0IDr2RCP3HHP5d46UntTs6c7fBNFddMxm/ExE/wDLf4I2nWUltb20UujNM0cQEpYQku2SSck564Hl3VjT2poIiMx8G6/ei5VVVTexmdvzbRt3Yx1nzS0ghU4bQHPTHowjlwPDm3y2foxWcdq9nzOIj/FXmqvnF/8A7dfLohzWk7W8KDSOymE0RM2I15UUqW9U5ySG38K16nWaabNVMU4nHPhmPksU3rcVzM3cxirbfnOcc/Z7W5lrytLlod3cS21lcPbsokYxxgsnMAHkVTt37E16b0c/Xr8vmqaqcUwhahCz3iCTVEuJLV2PZRxqhBKsN99u+vXqD09PVXyqRdQKBQKBQKBQKCNqP/L7n5pvdQclw0n/AAisTsBSOY2txjORXzDtH9efOXTtckaqOW9VFMjqg6sdqt6LSV6u9FqjnLC5VFFPFLYx6UCAWnwfYv8AvXqafRe1j8Vyc+SnOrnuhltbJbd8MVkZjkNjurr9ndm29FRMRvM9/e03bs3JZp5Fz2ZQEnuxmuhNNNW0w1RPRxGqmY6g6WsjiIkhSkQZRud85rweutWbeouU0xGInr4Q61qc0RMsN2rLpzK787CW2BbGMnt46v8Ao9MTqK5iMbfNo1f5YRGjDahduE7OJ5GIQ5QjIY7rgY378165Qepx+ovkKkXUCgUCgUCgUCgjaj8gufmm91ByPD/MtqFP1UjmNtP318x7R/Xnzl07XKEfB8KoYlvytZpo2SW35O1jbmUP0bxHs86u9n6v+j1EXcZYXKIrpwknW5uzIbTJhJ4pIhB+kke6vZU+keimMzmPYozpaurUXmrQ3siR3kiW3YseVUnbtObG/pLjHkK53aPa9+/ERpaZiOeVi1p4o3ndhLafcSrE97NMWUMqy3MhVg3TqcHNcuvW9pTR+KqcfRui3RziFq3ti0Ebw3Nv2LIGQqwCldyMfUfqNU5sXoqxVE5Zo13KkunyNE6uO2tt1Ocfl469D6PUVUairiju+apqvywivL2+q3dwk7tbh2aNe0PK45TvuSMfQMe2vWqD1KP1V8hUi6gUCgUCgUCgUEbUfkFz803uoOP0STKb71A2s6K+5Ga+fdsaW9Z1E7bTvEujYu7Ixgjz+brkxxLPHPVb2Ef6GKzjiOOeqqxRgghdx7afiOOZ70KTRLGSVpZEkLs3MW7VvW2wevdgY8K3xqr0Rju8kZW3Wk2UwQNGwCKiqFdhgLnlHXuyfrrKjU3YmZ6+HUygy6Fp5OeyctyFCe0bcH+vsqzGrvz3/BHEz2mkQyxXNrHJLCJWWTtFPMVYOrAjOR1UbV2+xKq69RM1d1PzVdVOaYLjS7gT9p+FZmcsOZjbwAt5kJXqFF6EowAPZQXUCgUCgUCgUCgj6h8gufmm91BwuipIGYyOMDoAuPrqBvgvMMA0EpIhydxx41HDT0TmWNfXLcnKO/NRw09DMsU3I7rsMjvqeGnoZlRoAycxzvtio4KehmWOQSRqQFQjPUmnDT0MyzZBj9KNQanhjoZlp7lihlLMck7DwpEGWntMtqCb/wB8e+pQ9RFSK0CgUCgUCgUCgsmj7WJ4845lI+yg8+gnjsbyW1uQLe4Q4dGOA3gynvBqBt4rtNuUkjxFBJW6wuRjp40EeW9YR8yqXOdlU7mgu7RSOYnY+PWgPfK64AZCvTmHWgjSX47ZI2GSNzt08KDKLln+nwoNbqT+iSSB5mggaLbtfarHBbnnIYNIy7iNe8k/YBQenAYqRWgUCgUCgUCgUCgg6ppGn6rEI7+1jmC+qWHpL5HqKDQ/2faFnK/HUHgty2KB/Z/oo6SX/wC9NQV/EHRv8XUP3tqB+IOj90uofvbUA8A6OesuofvbUAcAaODkTaj+9tQPxA0f/G1H98egovwfaErhnF5Jjue5Yg0HRafp1npsHY2NvHCneEHU+099BKoFAoFAoP/Z");
INSERT INTO "images" VALUES (NULL, "image/jpeg", "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEABQODxIPDRQSEBIXFRQYHjIhHhwcHj0sLiQySUBMS0dARkVQWnNiUFVtVkVGZIhlbXd7gYKBTmCNl4x9lnN+gXwBFRcXHhoeOyEhO3xTRlN8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fP/AABEIAIIAggMBEQACEQEDEQH/xAAaAAACAwEBAAAAAAAAAAAAAAACAwABBAUG/8QAQxAAAQMCAwQFCgIHCAMAAAAAAQIDEQAEEiExBRNBUQYiYXGxFDJCcoGRocHR8FLSFiQzQ2KC4RUjNFRjc5KyJURT/8QAGQEBAAMBAQAAAAAAAAAAAAAAAAECAwQF/8QAKxEAAgIBAgUEAQUBAQAAAAAAAAECEQMSIQQTMUFRMlJhoRQicYGx8COR/9oADAMBAAIRAxEAPwD2dASgBxp50BMYoCt4BQFb1I1mgCStK/NINAFQEoCiQNaArGKAmMUBRcA50BW+RxMUAYIUJBkUBdASgJQAO/s1UApOgoAqApVAKX9/GgAY/wASigN9ASgEv6poCk0BfCgBVx++dAJc1NAMstF99AaqAlASgAcBLZCdaAQgqmCINANz5/CgBIPP4UApYVyJ9lADbIUp0LiAOdAbqAlAJuArqlIkCgBRJGeVAHHb8KAFQP2KAzu4h6JPsoB9o2pCVFXE0BooCUAtxeGANTQFAzrnQBgigLmgBJoASaAWpVAL8oLZnUcRQD97iPVOVAEIoApFASaAomgAUaAUpcUBbNxLgQrOdDQGqgOVtq+NiltaWwsqOHMxFVk6N8GLmyabOOrpBeHzEtJ/lJ+dZ62dq4PH3sBra+2LlCnGVspbDwZkj0iUgeifxD41dW+5xzeOEnHT9jt9t9QRFxbysSAO6fw1NPyRzMfs+2ZztPbBfYZFw1iexwoiAkJJBJ6uWlKfkjmQ9n2xjd3t1aUrL1uEmc1cIJBmE9lKfka8fs+2K/traCHHG3t1ibMHKQcpB4cDVW2jpw4seWN1X8jE7beVAW0gyeBIopsS4WK6M13m13LR3cttJMJBxKJ8KSnTorg4ZZI6mzG90ivkNqWndDCJ83+tQptm0uGxwi5eBib7bji0AO26MaErT3EgD0eavgavT8nFrx+z7I5dbcQlS1XLGFBAMDSYjLD2ilPyTzIez7YhO09suLuQh9r9Xc3SpA6xmDHV0GvtpT8ka4ez7Y5d3txoLK3LdRTomc1edp1eSSaU/I14/Z9sSjb14pCVHdEET5v9aprZ2/i42kzdsvaa7q/bbW2kcZSflV4ys5s2BY46kz0lWOU4/SBjfpZSTACpPxrLLJRVs6eHm4N0c5FoyiIQk+t1vGuJ8Q+yN3Ob6s5SmdptXD3kyFpbU4VJwqTHDP4D3V0xzw0q2c2jdtoimtrlGGXYOoxpHCPCp5+PyNC8CX39oAKYeccVM4k4k8czp31opqStF44n1S+xJvdoJWVB5xKj6p5/U++rakVeCXgJm4fTvFPYXFLXiUXEgk1WTN8WJxTu0aGX7Z3JaFMrkYVJzSc+I1HsqFRdyml5R2Lu0S7dlaySMKQADHCss2WMH8meLLKONRiJurRJtHkNNJxqQQIAn3msI8Q9SvZETc5LdnOQjbAAA3ogAecjKIj/AKj3V1c/H5MdC8ELO1k5YncKRGa06RHgKjnw8jl/BnXd361Yy44pQkBWIcda11I05Mq9P2LN5tApU2HncKgQR1dM+PtPvqdSM3gl2X9DhdKQhKXGmlwAM0wfeKzs7FBxSps62w1sObSZU1jQvCZQrMajMH61eNWYZ5S0VI9fVzjOP0hxblvAVgzqjXjWGatrNIHGSF4ZwvkyD1jnXK2vg03KShW8TDTwg6zAOc55VNquqFb9A7u+AGBnNXFXAd1Ux4e8jthiveRy46xJzJ411nRQGGVE0IrcBwFQgVJWSsBAhaUjmPGrIwnsj0W0cflKcJejAP2entrHJWp3RxRuhBSvKUPZiNc5E1imr7FqCtjullxaHG0xBxqyHcI1yFRNalSdloJt7Iz3l4p+UI6rfxVV8eJR3fU74Y9O7McQmtzStgAmBQhKhTiMRk6VJnJWdLo3nthv1T4irxOTiPSe5rQ4jjdIXm2UMl0KwlUdXuNYZ4tx2N8MdTZxBdMKUAw0pxevWMDLOuZY5vqzp5VK2C4Lu6VgVAzjClQHb4VrDEo9DWMscdxW4cVhATJUnEI5c/hV6NnkilZabR1Y6oSfN0UOOlTTKvNBdRZtnYnDAgmZyymfClDmxewBt1hsrSApIBUSCDkJ/KfdSiOZFbGRMl9MDKR41KM572eg2hdW7d0UPBYVhTpxrHNGWu0c2LG5RsQm5JlVoz2YlnsnSqLDKXqZty4wf6hKmn3jvFHFmB5wjOI8RW0YKKpG8ZwWyBFu4tUJT6eDM+lyqaLvJFf2TyR0oCgkFJAIMjs+tTTK86F0LXbuJ/aDCJjMxnShzIvoLuWXGEytMCcOvHP6GlEcyMuhp6Mz/a7c8j4irx6nJn9B7qtDiOD0nbL3kbcxieAJ5CDVJHRw8tLb+DgN2y0oWsupSpCQVjATGId3Ks6O1zulXU0qRcNLcUh/EWkpWogRqBGo5eFNxFwlScepFM3IWQVZtN70HkIBy++BqaZOrHp/d0Eti7t9HQRvA2SnOCIwzlp29lKaKqWKfb5Fbl8DAHQFqRvN3GqYPZGk5Upk6oeqtvIbtldAlIdCwpe7MA6krB4aTi99KZRZMb7f7YxO2a2sC8QIlM5HKYI++ypSIeVSN20bdT+0XcKgMKG9dIOpqZK2Uwz0QX8ira3XLIauEjeSpBwHUSOXYcqqkbSmt9UegbDVwvdJbc6r5IRw80R7MgIqNy0njVtroWhq5WkvhYTiKlEnUlOZ4fZFTT6iUsaemv8AMht7xLqbYKkhIKIggiQBBjgY91KfQrqxNa6BbZddaJbuAplCSCYOUDhlOlNxKUIveO5HrC6W4W3HAQBiJiRMns1199TTKrLjStILYTC2dtNYjIUgkHn5v37KmK3Mc81KOx7StDjOB0qdUy3bLQYUF5HlkapM6eHSbaZxE3C7vfpbtwVugYilcaZCs3KlbOtRUKbfQ1IN5vJNsIUMKk4x1hgCdeGk+2o5kfJFY2t5f7qMUq8SINuCIWIxjRU+En301ryRpxe7x9A7678pD6beNcSCoEKB4VOtX1I04tOlyFE3OIL8nO9De7x4hERExzjt9lRrXkt/zrTq2/YB565bccuHGSMbyXM1zEEkJ7utUqSfQlLHJKKfYxOXSnFgRhCsKTmTMR9PGrWUeJROhtG7Va7RXhAIU2kKSeP386mTplMMFLGrF263lBhdvakpZlKZcyMzz79az1JdTaWndSl1+B7abvdlsW4gQUELSMHVw+3LwprXkj/nd6v326huO3cOhVqDvCo5KGUpjLxqda8ldOLapdPgFt29aKyhnVe8SDBwZyQOw0U15JlHDKrYts3DLS22LZSEqBmXASCRAzy0qNcVtZMnCTTlK6+BK7p62UlLjX7sIgq1AOuVSpd0HjhNWn3GbAeLu2GgdEpVhHIEjL751eL3MM0FGJ7WtDjPOdMP8Pbz/wDT5GqT6HTw3qZxNn3DbJWHZCVgCRwiuecXJUjtmm0mjem5tzh/WVa6lJ+lZcqXwU0z9oflLATAuiY/hP0qOU/CI0y9v+/9AFyxGVyqPVP0pypPshpl7Sy8zJO+XBM6GrLE/gipe0RePtqtloStSyoRJGlXhjcXZMYtvpRxxIdQD+IeNbFpdNzpbby2kfUT4VMupnw/oGWt0ym2Q24tSFIkZCZBM1zzxtu0aSjLVaVmkXFuZ/WlDTVJ+lZ8qXwV0z9pF3LH+ZJBP4T9KcqS7IaZ+0guGTl5Qo+w/SnJl4RGmXtK3zQIl9eXYatyn8Efq9pg2m6HS2GyTgnM8ZrWENKo0hFrcZ0aM7aRP4T4ito9THiPSe6rQ4TznTHO3t/9z5GqT6HTw3qZ5cHPsFZnehhXHyqC9hgwmhPYJgY4AzkxUoq5Ujqo2Y5hAdcSjsGdX0nE+JiuiJc7NQhgqbKlYc1BRiR2VLiVjxDbpnBUtBdQEowwoZ4p41U3d92b9uD/AMmo/wCmnwpLqV4f0GJJ41Q6UEFEqipLXuE4YFQS2arVhdwvA2AVa56VZKzHJNRVs6KdmCRvXvYgVfQcr4nwjHtS0TapC8JUg5AYoIPbUNJE48rnt3F9G1Be20EJw9U5TPEUj1Iz+jc91Whxnnel6cVsx1kphROfHI1SR0cO6kzzqbJ85JAUCJBB1GU+NU0nUssa3KdtHmxjUiEAx3UposskZSpAFXUOfCqmzewVuqNcqko90d+xuUqbUXnQVpPpQIFaxex5+WFSqKMu0doFaFIZPV0KufdVXI1x4K3kcdFo4cDgw4QQo9aahIvKa6HQ2yyXdpgJWkFSQAJz08KmS3K4paYGUWb5SVYJw5QDxy+vwNVo350Ba2HLdwh0RyPOjVFsclLdAuHTvqC8marV5TZxIVhWMgalOik4qWzO6LphDAXvQZGvFXsrW0eby5SlSRxNp3Ll0pKMkpJyBPxJqjdnZDGsasf0etnGNstKWAApJiDPEVMVuY5ZKUdj21XOU890vKRbMYgT1jGcZwapPodHD25Ojzv6njC07xuTnHDLWq2jpqf7hp3DiQlV0sHiFAmc8vhFP5H6ou1Epxi1I6l2BlnKSZNKQU8neJmbClqShAzPOqo1lKluaUMPbsOdTDhxCTmrXTLkJq1GfNj0Ldt1jJTiZxYSPaR8qUQsi8FuvYQlpNw2UjD1UiZz0makwrvQ/bCmRtKHUKV1BOfDDypKrL4VLl7GQG3bxBpx5uCMMHhx09tRsaVLukNCLVa5XdqKBzSZpsQnOK2iIfaZQJbuA4ZgJw5981DSLqUm6aAbStRKk5QQO8mY8DRFpTSe5qNs8gKKiiE+dBkjU/Kpoz5sSg1u7gFTzYCM5J459vZRIrKeqNJG3Yjxd20zLqXOorJKYjMVZdTDIqj0PZVc5zPdJCsONIUk5EEZUF0YlbH2c9OK2bBPFPV8KrpRqss13Eq6NbOVol1PqufWmlFlxExZ6K2J/fXI/mT+Wo0It+TLwiv0Wsx+/uf+Sfy00Ifky8In6MWPpOXC+9Y+QqdKKvPLwghsHZzf7lSvWWaaURz5+Q02dswRuGG0qOQKU51KSRm5yl1Zrct2l/3dw0hcD0kg1NEKTXQQvYWzXP8A1wn1FEfOq6UarPkXcUroxs9Q6pfR3LHzFRoRb8iYB6K2Uzv7n3p/LTQifyZeEV+i9mJ/v7nPXrJ/LTQR+RLwiDo1s9JlReX6y/oKnSiHnmwxsXZ7eluD6yifnTSirzTfc0WbDaLhIYbQhKczhTFWM22+p1aEEUkKEKAI7aASbYegpSezWgK3Lo0Wk94oCt29zR7zQE3b38HvoCtw8dVIFAV5Io+c77hQDW7dtoykSrmaANbSXPOE0AryYjzHCO8TQE3Tw0Uk0BW7e/g99AVunj+Ae2gK8ndOq0j40BYswfPcUewZUA9tpDSYQIFAHQEoCUBKAlASgJQEoCUBKAlASgJQEoCUBKAlASgP/9k=");
INSERT INTO "images" VALUES (NULL, "image/jpeg", "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEABQODxIPDRQSEBIXFRQYHjIhHhwcHj0sLiQySUBMS0dARkVQWnNiUFVtVkVGZIhlbXd7gYKBTmCNl4x9lnN+gXwBFRcXHhoeOyEhO3xTRlN8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fP/AABEIAIIAggMBEQACEQEDEQH/xAAaAAABBQEAAAAAAAAAAAAAAAAAAQIDBQYE/8QAQBAAAQMCAgUICAUDAwUAAAAAAQIDEQAEEiEFExQxUQYVIjJBUmFxVIGRk6GxwtEjNXLB8EKS4SR0siUzNkNi/8QAGQEBAQEBAQEAAAAAAAAAAAAAAAEDAgQF/8QAKxEAAgICAQMEAgEEAwAAAAAAAAECEQMSIRMxURQiQVIEYTJikcHwQoGh/9oADAMBAAIRAxEAPwDWvOFuIAzrx/k55Yar5O4x2I9pVwFeT10/CO+mg2lXAU9fPwh00G0q4Cnr5+ETpoNoVwFX10/CHTRzc7DG4ktLTq1BKiU5SSI7fEVr6nJSarkmqE54awqUJUEhZJCd2Ewf8U9Rm7Uvj/0aocdLNBxxvEMbbiG1J7QVRHqzFT1Oak6XP+BqhX9KJYcCFpOYkkJkJExJpD8rLNWkg4pCnSbYU+CtILGbn/zlNT1Wbj2rkaobzqkN43G1tJxBMuJw7+2uvU5bpJMaomavC62lxKYChIxAg+ys5fm5IumkVQTHbQrgK59dPwi9NBtCuAp66fhE6aDaFcBT10/CHTQ9p5S1gECtsH5Uss9WiSikrJ6+iZnDpG6Ytg3r3Ut4pjEd9eH8zFPIlorO4yUe5w86WPpTXtrwelzfVnfUh5HJ0lZKMC7Z9awKelz/AFY6kPJ1hJUAUiQdxFc+ny/U62QurX3TV9Pl+o2RAux1ibkKxQ+IMdmUZVoseZa+3sc2iLmpAS+lAUgPNpbPgACJH87BXdZ7Vx7Ox7fIOaKQ66XFBeMvpeBHYRhy8ugKiWdKlH4r/f7k9pK5YIduUPutBZQmEhSZgzM/CuY488YuKiytxbshGiEwqVOq1iVJXJ62IzPhnWjWf6E9vkevRy32Q3dLU8nEFZpAmPKuVDLF3CFDh92dDTDjbSUKKnCkRiVvPnWcsGVu1E6Ul5H6tfdNceny/UbI537q3tjhffbbV3VLAPsq+mzfVhzivkh50sfSmv7qvpc/1ZOpDydFlfWr9wEMvoWsg5A16PxsGSGTaUaRzKcWqTLKvqmZmeWXVs/Nf01rjM8hl62MRRQHdozSj2jXgUEqZJ6bXYfLga5lFM6jJo3DDyLhlDzSsSFiQa8z4N07Oe7uXbd4HE3qQgrWCklUDgZjtArlujWMU1+yJu/dLiC6lKW9WtagiVECRhPrGKllcF8EpvgXQEJOBP8A3CQZGUxHH+dhq2c68Cp0lbKBONQAQlclBGR3evwpaHTkLzjbjCVKKQRiJI6oic+H+RxFLQ0kG3slCFJKlBawhMDefsONLGkjqqnBnuUOmlsLNnaLwuf+xY3p8B41pCN8sznKuEZbtJOZO81uYgaFLbkv+ct/oV8qzyfxOofyNvWBuZnll1bPzX9NaYzPIZetzEWgCgL3k5pZNqs2twrCysyhR3JV9jWU43yjSEq4Zpbizt7uC8jH0SnrEAg9hg57hWDSfc9EZyj2Gq0daqSEqbJgESVqnOO2ZnIZ01RepIid0Wy4rCEw2TiX0lEk5T2xnGdTVHSyyRK7o+1eJK25mNy1Ddu3GmqZyskl2YDR9qFLVqgSshSsRJkjzPhVpDeXkObrTCE6kQDIAJ38aaoby72Q6V0k1oy2ygvEQ23+58K7jHZmUpUYdalLWpa1FSlGSo9pr0nnG0AUBbcl/wA6b/Qr5Vnk/idw/kbisDczHLLq2fmv6a1xmeQy9amQtUgTQAKAmburlpOFq5fbSNwQ6oD2A1KRbY7b7302698r70pF2Ybfeem3PvlfepqvBNmG33vpt175X3pS8C2G33nplz79X3q6obMUXt8Rld3Xvlfes3PGu7NlizSVpMgUHFqKl4lKO8qMk06uPyPT5vqwwq7pp1oeR6fL9WGFXdPsp1YeR6fL9QwL7p9lOrDyPT5fqWvJlKhppuQR0FfKuZZIyVJlWHJDmSNtWZ0Zjln1bPzX9NaYzOZmK2MgqkCgCgFmgEoUWhAoBUxiE7prjJero1w69SO3Ys2SNUmVM9uSxMeqa+Wux92a57MkxIKgE7J/Z21eP0cU15/uAwpUBrbdJSSJw/zjQO38Pka86A2cLjQJy/DRHhx4Go3wdQjzyn/2Ri7UBBbaV4qTNTZnfSXlndoFwuaXalKUwlXVTHZXeN3Ix/JjriZra9R8sy/LXq2fmv6a0xmcyuTYMHQltdFKtc4+EKOI7pI3V1s7o5pa2QabtWbLSS2LcFKAlJAKiezxrqDtWyTVM4Jrs4FmgCaASaFJbdvX3DLOKNY4lE8JMfvUfCC5ZY6Yb0dbLctbZl1L7SgC4pcg5Sa4js+WdypcFVNaGYoUdwV8a4eOD5aNVmyRVKTDErvH21OlDwXr5fswxK7x9tOlDwOvl+zOr/SQn8R+f6t3j/iuemvqjrrz+zF/0WI/i3GGOAmadNeEOvP7M7uTha54Z1a3FKwrxYt26uXBJWkXqSlw22bSuCmX5a9Wz81/TWkDOZzN/wDjNn/uh/yNX/kF/EtrjWXOmF2lxYoXZrbkvFBkZd7dvy41wuFfydPvVcFW7Zh7R2iTas60a0ha0JnLF2n1Gu06bs5atKjsLTaL7TCkWrbymktqbb1c54JyHnXPwi/LGoaS+9om5urVDFy64tK2wiApOFWZB8h7ava0hV0yG2cTc3t2gWjClWKFi2ZSiMZBjPjuHto1SX7InbHhR/6be3Fq0xdruA0U6spxJJicJzBHZTyl2L4ZNibvNP3DNwyyrZUlTQCOkswnfnnFTtGxdyojm3fv9Hay3WHi4oFS7bVBacKsoPAxV5SY4sjDjd+xpS2VbMNotAdSW0QRBI/b41aqmTvaM3WxiFQoVSBUKWvJf87b/Qr5VnPsdw7m6rA2Mty16tn5r+mtYGczOi5fDCWQ6rVJViCZyB41rS7mdskXpK9W0ppd06W1yVAq3zU1XgWxrN9dW7SmmLhxtCt6QarSfcJtdi20RdO7DpV9TytdqgQsnOQDFZyStI7i+GyqXfXS7hNwu4cLqOqucx5VpSXBxb7kaX3UP65Di0uzOMHOaVxQse7eXD7yXnXlrcQQUqJ6scKJJEtsbtDxuNfrV66ZxznPnSl2FvuSuX9248h5dy4XG+qoq6vlTVFtkaLl5GtKHVguzrIPX8/bSkS2RVQFAFAFAWvJf88b/Qr5VnPsdw7m6rA2Mty16tn5r+mtYHEyqshY6kbTq8UImTn11T47sNdO/g4VfJOjmwONIWlo5dJXYMo3zx+VT3UX2jUHRw1QIaklsKzmB/VPxn1VfcPaRuCxKbWA2FlRDokQOG7Ki2I9R8WSgtKUNFSsaGwCMyVdFUzkM/YDxp7i+0gtNl2VJf1RJQsyTChmmMt8xij1VXd8EVfJItGj1XbvSSGktykJVAJkx8I9dRbUPbY1+3tWHGFtKxo6azKusE5j2mR41U2w0kV812cCTQBNAE0ATQC0Ba8l/wA8b/Qv5VnPsdw7m6rA2Mvy0Eps/Nf01rjM5lOw/Z7Mlp5AxapQxhEkKUSPgDPqEV207tHKaJbm5sVG21aUgouEqcIREolXh5fwVEnyVtCPP2a0w2W0iO1BBnGk9id+EHw7MqJMWh212YcnCgp/DI/D3Qel2cCeO6pqxaInXrV0WqZRKXFF0xvGIkCYE5fturpJqyNoZb3TWzKQ7GtUlwlRT/UcMdh8aNchPg7E31jrQSlAbCySNXmQUDw7xNc6suyILW5tW7ZKVasOhazJTkJSoCDB7YqtOwmkiTa7HLElKoSmQG+t1gR8RU1kNkNTd2wQQ4pCyWnEyEZFRXKcsPCKtMbInsb+0t7YJcIhTAQEgSUrlck+cipKLbCkkiTnCwJcUt0qW4Gphs4QUGcuA8KayLsht3pC0fYwoWCQy5vTG9MADxxQfCKKLQckyhrUyLbkv+eN/oV8qzn2O4dzdVgbGV5bLwJspEyV/TWkHRzJWZPXjumu9zPQNoHdNXcaBtA7pqbjQNeO6abjQXXjumruNA147pqbjQNeO7TcaBrx3abjQNoHcNNxoGvHdpuXQNeO58abk0DaB3D7abjQNoHc+NNxoG0DufGm5dC45KO49OtjDHQX8q5lK0WMaZvazNDJ8uepZea/pqojM3Z2YuVoSVhONWFM7prOc6dI9WHApQc5HSnRGMJKTKVOhoKnKeO7dXO8jZ4MK4d9rFXogIcCCoSXEtiD2kAjs8abyRI4MLV89rFVohtJWC+kYVpQZJAk+rdkfZU6kgsGN/DOW8stmUpIJlBgz211DI3LVmeXBFY+pE5YrejxBFKAYaUAw0oCYaAIpQCKUDs0fbtuKUt4SlO4cTWWSWvCN8MFLlktw0woEIbSjxSIrJTdnolji12OnkiI0834IX8q9L7Hi+aN/XJTK8uOrZea/prqJzIzDLy2CCg5gyPA1J4lJ2a4vyJY1rVomTpC4SAkLUAMwMRgZz88656P7NfV/wBKHc43OZKzmQo59o3H4CnR/ZPV/wBKEN8+pWIq6WIKme0bjU6H7L6vitURPPuXBJcMk7zxruONRdmWT8iU461SI8NaHnDDQBhoBMNKAYaUAw0AmGgJWnNWCDuNZ5Ibco2xZdOGC3hGWdZrG7NpZo1wWfJMRp1v9C/lWzVI8qds3tcHZluWvVsvNf013A4kUNrg1DmtYb1SUqxOEHHiIOEJM75/ea6ZyiZTLRW9a6ttAaaSoOx0p6MyfHEfhT9l/QjyGlm6QlhKBbuhCcA6ShiKYPE5T7aBiN29oslEulzsAG4T8ciPjTkcAm2awwW1EhIlQnfhzy4TFLBz7K/iKdUcQ3jhv+xq2iCG3dCcWDKJkEZ0BHFCBFUBFAEUARQEjLq2CooCZUIzExUoWS7e9rCvAziIA6nCfuaal2OzkqI021+hXyqS7CPc3lYmpnOVtq/ci02dlx3CVzgSTG6tINHElZRJtdKoZ1ItXtXnCSwDv35kTXftOOQVZ6UWzqlW1wW4AjVdg3AmJNLiORXLXSzoSF29yoJIUPw+0bics/XT2jkaLLSaVYk21yD4Nmlocii00qJi3uc9/wCGae0vIbJpXGpez3OJW84Dnv8Auae0ciCz0oEgbNcwBA/DOVOByR82X/oT/uzVtEpi82X/AKFce7NLQpic13/oT/uzS0KYc2X/AKFce7NLQphzZf8AoVx7s0tCmHNd/wChXHuzS0KYc13/AKFce7NLQplnycsbtjS7bj1s62gIV0lIIG6uZtUWKdmxrI1CgCgCgCgCgCgCgCgCgCgCgCgCgCgCgCgCgP/Z");
INSERT INTO "images" VALUES (NULL, "image/jpeg", "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tMTU3Ojo6Iys/RD84QzQ5OjcBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAFwAXAMBEQACEQEDEQH/xAAcAAABBAMBAAAAAAAAAAAAAAAABAUGBwECAwj/xABEEAABAgQEAgUIBgYLAAAAAAABAgMABAURBhIhMRNRByJBYXEUFTJCUoGh0hcjkZSxslRVcnTB8BYkJSYzNERFYmTT/8QAGgEBAAIDAQAAAAAAAAAAAAAAAAIEAQMFBv/EADQRAAEDAgQDBQYGAwAAAAAAAAEAAgMEERMhMVEFEkEUMmFxgQahscHR8CIzNEJSkRVygv/aAAwDAQACEQMRAD8AvGCIgiIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIozjKrTcuqRpVHd4dSn3NHQkK4DKSC45YgjayRftUOUSaBqVgnokiput8cIM4pJKM1kpaIAvqb5O8DvsrlDJYsVnzlUVEZZ90A214begO3q+yCffDJPVcn6rU0NcQTzgy2WtPDbvlAKiPQ3y2EBZDdbGoVfh8MT7heAy3DTZucwTf0f2jDJM1q3VKkpor84OkHMpP1beoylQ9XwhkizM1KqJbcLc89mSF2Twm9bZT7PjDJPVbS8/VXX30GouDLmypLTfYpQ9nkUQNtkF91qKpU1Zj5a6B6p4bet0hQ9XmFCFhsiy7U6mAS3POkg3sUN6jRXs9qSfshYJmuNQrdUpAlqm/NqmKciYCZtHDR1WV9XPcJB6irHvBMZABy6rDiRmpwlSVJCkkEEXBB3iCmqN6YJ2bk8a55SZeYPkLaczSyk2zKNriLtOAWZrn1TiHixUOFaqZdP9pzwKiEk+UL1F9t+8/aY38jdlXxH7lKqfOYgni8JOoT7vBZU84EzC9EJGvb9givUz09MAZbAEgepWyMTSmzSf7SZVaqi0a1WeIJ2Mysg/GLHI3Za8STcrrLVOtTEw0zL1CorecNkpbfcUVa9gBiEhijaXvsAOpWQ6Vxs0m6cZ2SxVTqX5ZPPz0tLoKUALmz26ABIVoI58HFaConEETg52egyy8VvfBUsZzuuB5prNaqoUctUnxrt5Uv4ax08Nmyr4r9ynCinEVbneBIT8646hKipaptYCE6bm+mtvH3RSrqyloIsSfIeVySt0LZpncrD70tTT8YecHZFL9RU+zYqCZw5QDsb5tor/AOY4bgCcvAafDPLUWsp9nqufkzuPFc6iziGnPOsz1UmEOtNIeUny1ZNlEgW11PVV9o5iJ0nEqSraHQtJBJGnUW+qxJDPHfmd700qq1SdZU25UZxbawQpCphZSoW2IJsRHSDG7KuXvOVyvQOCFFWD6KpRJJkmrk/siObJ3yurH3Aqh6as39NRb9Ca28Vxcp+4qdV3woKP8WxHrfxjeqqs7osEnJqelVm1TmWETJSfVaJOVPjYhXgtMeA9qnzT2kb+Uwlv/XU/LzBXb4e1rBY945+iiWNKEaJXXJZlsmWmDxZYAdhOqB4HTwy849HwHiQrKIOefxNyP19R81QrqfDly0K71vDScOyEk7VX1rmZlVhLMEJ4YFio5ze5GYaADXtiFDxl3EZ3x0rRyt6u67ZDf7HRSkpBAwOkOZ2Vh45TJPYcbTPvONSq32QXUAEoudDY9nOPEcCM0deTCAXAOsD4DRdaqDHQ2dpkoXi7BbdCpYn5V56bRxUhzNlSEJPrbG+th749Xwn2jfXVOBI0Mve2uZ+81zqjh7Yo+dpJSvC9MSispZoVZflpzyVL76X2AsBCspyW2JGZJ3Fr6dttHFq4vpi6sgDmcxa0h1sx1vtrvpn0vKmhDZBhPsbXNwnGioea6Tp5qZmnJlxEpbiuJA0IQbAAAAC+34xz6x0bvZ5jo2BoL9B6jr1+9FvYCK4gm+SYulE2xYj9ya/OuOz7IfoHf7H4BVeKfmt8lEs1k/zyj1S5oXo7AZvguh/uLX5RHLkzeV12d0KoumoXxoNf9G1+K4uU/cVKq7yjFDkZWan21VKeZlpJLn1uYlSlJvqEhIJ12vpbXwjRX1M0MREEZc8jK2gPifkoQRse78bgAnJFdnpXEvlLU1IO2eK+KhptCVI9nOUhQ6oy87Wjmf4ynloOR7HA2tYlxN97Xsc89lZNQ9s9wRb0+KmOK63h6rSsu5LVOXVOyUwiYl8wWAopIJQTbQEfEDlHmeFcP4jSSOD4ncjwWn1628F0J54JG94XGaSY4mKNiemyr8nV5BuYllKIbmHghRSq2YAbk3SnYEGLXAYqzhVS9s0Li1wGYF9NPsrVWGOpjHI4XC3x3W6TN4XEhK1GXemQWlZEEqva1wbDQ9xtEOA8PqouI4z4yG/izI3++ilWTRug5Q4XySahYvlUYQnpOrJbedlW+E0y7qJlCtEp77bHknXnFrifApTxNktNkHm5I/aRqfXXzWqlrG4Ba/Ue9NnR7VGJGvTc/VpxCA4ysLdWdVrUtKr2HgTyi97SUMktDHT0zCbEZDYAjVaKGZomdJIbXTxKVemo6Qp2qqnmRJOS4Sl251OVItbf1T2Ry5KCrdwNlKIzzh17W6Z+isiaPtZk5ha26Y+kCelKniFubkJht9nyVDeZPYoKUSLHuUI7XsxTTUtI6OZpaea+foqnEZGSPDmG+SjK0lSQhAutZyp7yQAI9A9wY0uPRVImGR4a3Ur0rhFtLWF6S2j0USjaR4BIEciJxewOPVdypYI5nMHQ2VcY8Yk5jpFfRPscZrzQOrlJscxAOmt9ezXXSLrCRHcHqudIAZMx0TKaThpLiUty8w4spU6QeKClAJuCNOsOqLb3VroQYlzybqGHHsk88xR2JtC5aTcSHAsrStha0pzNrygII0IVl08ezbILyMysFsYOQSvyDDSpdbrcspSEnKLtvJBJA01Fyq5voDprqYjzSX1UsOO2iT0aVowm5hl1hD7a37y12Hc3Dtm9Iiw6uYakEEXPMTc51gVFjGXIIWrNPocyVh1hxslxQzkONpzb5QCNLpIIG+oHdGC+QDVMOMnRRyWpVQm1qTLSjq1hPEIR7Omo57jbs1iw57RqVUaxztAlgw1WFKITT3yb7ZLHXbuiOKzdSEUmyQTMpMyjim5llbShlzBQta6bi/uIiYNxcKDhymx1XNCVLKUoSVE7BIvfQQLmtF3HJZaxzzytFylNKYU5USt1CkplRmIULdciyR+J90criNQ3C5WnvfBei4DQOfVc7xYNzz36L0Rg/XCtJP8A1G/yiNcP5bfJZr/1Unmfiqp6V6i/TceKeliAtci0g3vtnKrac8tj3Ex0IWhzM1x6h5a/JR1zGVTdm0P5JZC2wUpyoVaxUFH1v+PxMTwW6LV2h97roMb1S4yolRlN7cNWulrentoIYDVntDtkm/pVUfKRMgtA5klSbKyqskp161zoR2+qnlEsFtrKOO6910exdU3jLZjLgtLzpUlKrk5VJ115LPwjAhaFk1DiurmNam42QtmSIIy2CXBYWI06+mhP29wswGp2h2yGsaVRmfM6ESxdS0WkJIOQdbMTbNvuNxv3RgwNtZO0OvdKUY7qKUKbMpI5FHr/AFSiVEADU577ab7adgh2dvinaX+CbJurCoTzs4+gJccy5ilKk7JA3BPL4xuY3lFgtEpMjuZSLDLso5SKgqUEuqohxsfWqsoN27OqCdbXjh8YILgH6ZW+fyXouANIbdgzub/1l6arGIZgplZVt0S/G4pylm5UUW1Cr72P8I5cYBH4dB8V6eJz2yZ9VbeDR/dOj2/Q2vyiOvF+WPJeZrs6qTzPxVa9I0jIT/SCpupzaZVlNOQoOKcSnrZjYa77k2AJ0i/E4tjyHVcqZrXSWcbZKKqoVKdddMrWZZsBYCRMOo9hJVchQucxI0FrC942CR3Vq0mJnRyw5h6nM2V5/kHUlTaSGjdQzKCSbZtgMx8ANr6ZxHfxWDEwfuXc4Xp+UAYip+p7SNNbe1v/ADe0YxXfxWcJn8gmGoSqJSfVLsvtTLaCmzzfoquAefZe3iDG1hJF7LS9oaSAUlHobJ35xm6iVhW6vR3jKLZRAJvl3VC6ALRoPTb4l5Jouum2w0Gm5PYIrTVDIhdxVylo5J38rBcqX0OgS8rL5l1CWRPLVkdccXkDadPQ1ud+WuU6jQRxJpXVOd7Db5r1lLTN4fk5hcSNR8PDz9yy7SkZysVWnKcUm+ZcyVE7XFyNBqbeHZEMM7hWu2Maconf19/0rowUScI0YkbyTX5RF6PuBefq/wBQ/wAyuNbwVh+vT3ltVkVPzGQIziYdR1RewslQHaY3Nkc0WBVR0bXahIfoywh+q3Pvr/zxLGk3UcGPZY+jHB/6rc989MfPDHk3TBj2WPowwf8Aqpf31/54Y8m6YMeyPowweCD5qc02/rr/AM8Zx5N0wY9kDovwcBbzU5bf/Ov/ADxjHk3WcFmyD0YYOP8AtTnunX/nhjybrGDHstVdFuDVelSnT4z8x/6REyPOpUhGwdEulsBYZlWOBLU0tN8kTDov4nNcxWfBHI7mcLnzKvQ108DeWM2HkPotVYAwyr0qe597e+eMCnjHRbjxWsP7/cPotD0dYVO9Nc++P/PEsFmygeJVR/d7h9FIpKTYkJNmUlUZGGUBDaMxOVI2FzqY2gWFgqT3F7i46lKILCIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIiCIgiIIiCL/9k=");
INSERT INTO "images" VALUES (NULL, "image/jpeg", "/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBwgHBgkIBwgKCgkLDRYPDQwMDRsUFRAWIB0iIiAdHx8kKDQsJCYxJx8fLT0tMTU3Ojo6Iys/RD84QzQ5OjcBCgoKDQwNGg8PGjclHyU3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3Nzc3N//AABEIAFwAXAMBEQACEQEDEQH/xAAbAAACAwEBAQAAAAAAAAAAAAAABQMEBgIHAf/EAEIQAAIBAwMBBAYDDgUFAAAAAAECAwAEEQUSITEGE0FRIjJhcYGxFBWRFiM1QlJTcnSUobTB0dIHJLPT8FRigoOT/8QAGwEAAgMBAQEAAAAAAAAAAAAAAAQBAgMFBgf/xAA4EQABAgQCBQoFBAMBAAAAAAABAAIDBBEhEjEFQVGBkRMUIjNhcaGx0fAjMlLh8ZKywdIVQmIl/9oADAMBAAIRAxEAPwDN+7r7elIL6em9xpumq/3rV4tm5VUFd5GSAScEYAznx6HBNTZJMmI5F4X8e/daKKfTrKOBJYtVhk3sq7RGQRnqSM5AUdePIeNFArsjxS4gwyKV1/bWvpstMWdYm1P0RG7vIIiQWGdqjGeeOTnHIxRQKOWmMOIQ9YtXife9T/VulCZwdVURDuxGwIJ5OGJx5YHl1z4czQKnOJnCPh3vXPdx952jk0/TS8KQakvplt5YqQgAJx4DwAByA27wxzFFZsePQl0P3bv3jVTXVfV0nT2bC63bn0Q2e72888csOf59ccZmg2qDNRwOqPH7e+NJI7e0i7q2i15hazqxnVCVUEL4jODk44Ph40W2qpiRHVe6D0hlx48OCjt7Ozt7xx9cCOSIKY5YcrlznI3Z4xgZPmcVCu+LFewHkqg1qDe3d26uK6+q9OJcNrsRbdjd3XGPP1uf60UCrzmPb4R4pVcJHHM6RS96inAfbjd7R7KhOMcXNBIoVHQrIoQihCKEIoQihCKEIoQihCKEIoQihCKEIoQhmCjLEAUKC4NFSo1mDEFRke3xqpKXMfFZi0/0jsxfL/mNOvdNlPVrSUSoP/FunwqRFhnMUSgZpCF8rw8f9Ch4j+VDJoNpOc6VrllcZ6RXGYJPsbqasMJ+Uqf8hEh9fBcO0dIeCXXml39if81ayIPygMqfiOKktcNSYgz8rGsx4rsyPAqnVU2nN1Do+mLbRX0V/PcSW8cztDOiIN67gAChPAPXNUfFaw0IqloLZqZDnwy0AEi4JNrbQo459BlfZFp2rux/FW6Qn/TqnOG/StHS820VdEYNx/supm0WAAz6VrMYJwC9yg+cdSY7Rm0qGQZl/wAsVh3H+yiN32e/6HVP2uP/AG6jnDNnir80nfrb+k/2UWsWkdjqMtvC7PEFR0ZwN210VxnHiA2PhWypLxXRYYc4UNwdxI/hVY03nGcVR7sIWpKguLEO+95XOOigjHyqginYlYsuIjsTiffFcbViKKMkE45qc1mWNhkAa1uOz0NtJolp9Z29tM17qC2doz24LRrj0myuGI3EDk1tDDS3pDXRcifiR4cy4S7yKNxG9uCUt2cnZrOCG5hmnuppYVTBCgxrmQ7ucqDxnHUHGRyaGARTtTcPS8NwcS0gNFa7a0GXbqUKaVqdvbQSWdy699kxrEXKON23jaDnnwIB9lXa17EvHmJWOSHNr358DQ8KpXNNeiYw3oiY5I3DbuBHUeifnUucTYrXRrGNjfDcabKmnApj2qUtqFkqjJNhagD/ANS0lMdZwXoNFkCXeT9T/Mp0y2Gg6KwlErSXCPC6BQN+QfSDbeMcEcngkFQeTpRsNt1zAY85MdGlBQjs7KV7wbZ3B2WrK8GprdXF9pc8e+27qPvpB3ICjOcEAj8UlsHAz0zVmux1LgsYsEy+BkOID0qmg6Vzv7aC1Ssl2gsYtPu4o4CGjkgSUMuSCG5GCevv4pWIwNNl35CO6NCJdmCRwVvtL+GG/VrX+Hjp4enkFzpTqt7v3uS1M848qpEyTKGhyuSOKyDrrN0IFVJ8LLAP+8/KtW5FIxujFYB2rUWlujWtjINdms54VLQrICqQszHLITgAY6kZ6fCrtNhfJJRwOUifCxYrEg3ItamrwVuztNbhijTTb7Tr2GKF44lIAKLJ6wDLtcZLdd2cnqMVoC4UpQpOLDl3k4sTK0tmLZcFUm167itbjRtWtYxFsZHKSYdFaER7VJ3dRljk8l2qeXLbEKjtFhzRFhuDt1AaHwtb7JTrOpDUtQgkRGiAjcGMlWAYsTkMDzwQMkD1elD4jXgUTOhZeJAiuET7K52kcR6rYOyFwtjanaGwT97XxwaQj9ZwXpdHAmWeB9T/ADK111qGmWkMlxItzd9xLhWd2mxlQcdTs8eDj1ce2mXPYBU3XAhS8xFcGCjajsGvx7757lR1HWrrU/oqaR3LtIheQopPcDHpE+0gnK8jAxis3RXOpg/CZl5KFL4jMVFMu3ZTuORtnWqz3bCWA6isFrNLIkSAPuclQ/jtBxj7ByTWMcjFQLraKY/kS94AJO+nb+TZHaX8MN+rWv8ADx02PTyCWlOq3u/e5Lk6P+j/ADFUiZJgrSwaPaS9kpNTladJoopSFG0rIckK3B3AbsAkjHHxoZCaWYta5ExPRYc4ILaUJbuyqNlxv3rFzENd2ynoZCPlVmixRHeeVB7163eaVoVhdPYwXWrWpjZQO6mWRAWA8Hz+UPtpzm7aWK4TZyYiDG9rTup5US+XQtNnTv01yAgDk3mng5zzyyY/JPPsNUMudvgtmT722MM7nHyNdqq3/Y6aZWaKXS55MldyXjxtnHAKsDzhl8fKqGXdsWg0owC+IDuB8bLF32k3mkaisN9GqOyF12uGBXOM5HuNULC2xXS0fMQpiJihmqZ9pozLqlhEmNz2NqoycDJjWk5i8Tgu1o1wbLPcdTn+ZU+j/XuluptUhZBkqkkqFQWxk+sOfRHwoZyjMljNcymQcZNewGtq9naurufXLrLxCOJX2DEc6+i8ZIDDLcNweR/OpLojrhRChyUOzqmlcwcjqNrjvSG8tJ7YKbhQpcsMBwxyDg5wfOsC0jNdSDGZEqGaqatqa9pfww36ta/w8ddAenkFyJTqt7v3uS+P1ZP0f5iqRMgt3LXxxpH/AIdyXLpCJdskUUpiMr7WY7lyB97B55Ykc+2tWD4Vfv8Ahedmn/8AohoNuiSK0FqUN/mpsAqvPC2Zo2zjaxOfLpVdSZNHPFVs4+3faNAA97DOoHqz2yEfuAqwmHhZnQkqbio3qVe3N43N1pOjzkggn6OyEgjHUMfDirCadsWZ0I3/AEiEePopp+2VjdCQXvZyPMisrmC8ZSwbOc+jznJ+2rtm9oWDtDR2dXFG8flZnV71NR1RrmKEwxBNkaM24gZLHJ/SZj8aziRA91QuloyUfL2eak38h/CtdqmKahZsvUWFqR/81pKY6zgu1osAwHA/U/zKsaNqKXhmGqXsNsFAKv8AR0LMSefxfL/hohvDvmNFjNyxhYeQYXbz6q5dy6fBaSyW+rwTSxoTGht48sQcAer5c/YfZV3FoFQ5LwmTD4ga+EQCb9I9517fRZa9vJbxxJMI9wXb6CBfl76WLic13IUBkIUb51TftL+GG/VrX+HjrofbyC40n1W9373JcvEb+4fOqP1LWIclpwrnsXJLLpTgLausd/HMCrDe3oOvVcFjjz4rVgOC438V52ae3nYDYl8Qq2ndcHXkF55ITvj545qNS1cekE3zWK7IKCQoyaEEgBdspUgMpUkZGR1FQpBDlyF5zVm5qzW3TSDXtTggjgS4QxxrtQS28chUeQLKTj2VtVZuk4LnFxFzsLh5ELv7o9U/PW/7FB/ZUV7PAKOZQNh/U71R90eqfnrf9ig/sor2eARzKBsP6neqPuj1T89b/sUH9lTX3QI5lA2H9TvVLrm4mu7iS4uZGkmkOXdupNQTVMMY2G0MYKAKGVtkLn3VRyzjHJartFZiy7PNFa2M80SId17De7hHlg3dyRgeqPb0JOOprcso2gHivLQ5jlY2J7wDXLDnqqDt7qLzO7lKhSDg5IqGhax4mGlE+Vh0zS67odRd740lj75xGhPrN7wD86GtLsllMzcOXFXHbRah7BL5F+hd3NCIw0dm8gWSFfEIxzuA6jPHJ44xWpbXJc2HNcnd9if9gKtPeNR7r8VnbpRDdtCjSHbneJF2lGHVSPMVQNoV1ZaYdEeGnZWxqFHV0+ihCKEIoQihChu3CQ8+LD5GoKTm3YQCl82pSM0rCeTdKNshDn0x5HzHvq1CuO97KADUlN4+TH7zWrBmufNOuAtOByKUXphStlzqunNdqpYolvFFvd3PGC2CAMZJOaclRVhw5ry2mnEzADsqflaPsjoX3TXtzb2cr2y2se+OZVBjU5wBjqM89PI1k2ESSDmnJiehwmh0IdE6toV3tJ2Ql0XR4b6/uQ2oG4cSKh3I6MeDnHrZwfias5mFt1poqa5acNBankFlqzXp0UIRQhFCEUIS3WU70RpvKgZJHnUtNFydKNx4W12pO1sw6OK0xrhulyMiqtzuVowxzV20KUjhzSMRT03bs3B2r7KXwrsc6c42smlpc/WEttpeTvupUiQj8UswAP21MPG13RWc6YEWH8TML2217Nro+y10WCWK1WJUZo7kIXYHl2OMscHqfKnm0AXADwW3WU/xM1pLjUb3R1Kk20cLY8QxO4/uK0vGzXa0ABy1dd/JYCsF65FCEUIRQhFCEguC0jZd2PxrReejFzzUlVnBz67fuqaBKOB2rg2qTkF2bI8sVYGioZVsY1cSmENordZH/d/SqEp+HIsOs+HorunxGwvYb21lkS5ibfHJn1T0zjp40B5GSY/xcs49IE7/AEonsvaHXLg5l1nUT7FuXQfYpFQXu2rZmjJNuUMb7+aXt99neeUmSdzl5XO524xyTyeKqXE5puFLwYZqxgHcAvtQt0UIRQhFCEUIX//Z");
CREATE TABLE "medications" (
"medication_id" INTEGER PRIMARY KEY,
"name" VARCHAR(100) UNIQUE,
"weight" REAL,
"code" VARCHAR(100) UNIQUE,
"image_id" INTEGER,
FOREIGN KEY ("image_id") REFERENCES "images" ("image_id")
);
INSERT INTO "medications" VALUES (NULL, "Dalsy", 50, "DALSY_1520", 1);
INSERT INTO "medications" VALUES (NULL, "Aspirin", 45.2, "ASP-2022", 2);
INSERT INTO "medications" VALUES (NULL, "Acetaminophen", 78.8, "ACETAM000", 3);
INSERT INTO "medications" VALUES (NULL, "Ibuprofen", 25.55, "IBU-0-200", 4);
INSERT INTO "medications" VALUES (NULL, "Advil", 15.0, "A500-565-1", 5);
INSERT INTO "medications" VALUES (NULL, "Tylenol", 29.9, "TY_B000", 6);
CREATE TABLE "loads" (
"load_id" INTEGER PRIMARY KEY,
"drone_id" INTEGER,
"medication_id" INTEGER,
"quantity" INTEGER,
FOREIGN KEY ("drone_id") REFERENCES "drones" ("drone_id"),
FOREIGN KEY ("medication_id") REFERENCES "medications" ("medication_id")
);
INSERT INTO "loads" VALUES (NULL, 2, 1, 2);
INSERT INTO "loads" VALUES (NULL, 3, 2, 3);
INSERT INTO "loads" VALUES (NULL, 8, 5, 1);