| ofs | hex dump | ascii |
|---|
| 0000 | 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 10 00 01 01 00 40 20 20 00 00 01 2d 00 00 01 0e | SQLite.format.3......@.....-.... |
| 0020 | 00 00 00 00 00 00 00 00 00 00 00 c0 00 00 00 04 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 | ................................ |
| 0040 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 2d | ...............................- |
| 0060 | 00 2e 38 08 05 00 00 00 05 0f e7 00 00 00 00 72 0f fb 0f f6 0f f1 0f ec 0f e7 0b af 08 6f 08 0d | ..8............r.............o.. |
| 0080 | 07 a4 07 06 06 7d 05 13 0b 5e 04 1c 03 b7 03 30 02 03 01 8e 01 00 00 f8 00 00 00 00 00 00 00 00 | .....}...^.....0................ |
| 00a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 00c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 00e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0b 57 00 08 00 00 00 00 | .........................W...... |
| 0100 | 81 0b 16 07 17 47 1f 01 81 3d 69 6e 64 65 78 55 51 45 5f 64 61 73 68 62 6f 61 72 64 5f 61 63 63 | .....G...=indexUQE_dashboard_acc |
| 0120 | 6f 75 6e 74 5f 69 64 5f 73 6c 75 67 64 61 73 68 62 6f 61 72 64 18 43 52 45 41 54 45 20 55 4e 49 | ount_id_slugdashboard.CREATE.UNI |
| 0140 | 51 55 45 20 49 4e 44 45 58 20 60 55 51 45 5f 64 61 73 68 62 6f 61 72 64 5f 61 63 63 6f 75 6e 74 | QUE.INDEX.`UQE_dashboard_account |
| 0160 | 5f 69 64 5f 73 6c 75 67 60 20 4f 4e 20 60 64 61 73 68 62 6f 61 72 64 60 20 28 60 61 63 63 6f 75 | _id_slug`.ON.`dashboard`.(`accou |
| 0180 | 6e 74 5f 69 64 60 2c 60 73 6c 75 67 60 29 73 15 07 17 3d 1f 01 81 17 69 6e 64 65 78 49 44 58 5f | nt_id`,`slug`)s...=....indexIDX_ |
| 01a0 | 64 61 73 68 62 6f 61 72 64 5f 61 63 63 6f 75 6e 74 5f 69 64 64 61 73 68 62 6f 61 72 64 17 43 52 | dashboard_account_iddashboard.CR |
| 01c0 | 45 41 54 45 20 49 4e 44 45 58 20 60 49 44 58 5f 64 61 73 68 62 6f 61 72 64 5f 61 63 63 6f 75 6e | EATE.INDEX.`IDX_dashboard_accoun |
| 01e0 | 74 5f 69 64 60 20 4f 4e 20 60 64 61 73 68 62 6f 61 72 64 60 20 28 60 61 63 63 6f 75 6e 74 5f 69 | t_id`.ON.`dashboard`.(`account_i |
| 0200 | 64 60 29 82 2a 14 07 17 1f 1f 01 84 23 74 61 62 6c 65 64 61 73 68 62 6f 61 72 64 64 61 73 68 62 | d`).*.......#tabledashboarddashb |
| 0220 | 6f 61 72 64 16 43 52 45 41 54 45 20 54 41 42 4c 45 20 60 64 61 73 68 62 6f 61 72 64 60 20 28 0a | oard.CREATE.TABLE.`dashboard`.(. |
| 0240 | 60 69 64 60 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 | `id`.INTEGER.PRIMARY.KEY.AUTOINC |
| 0260 | 52 45 4d 45 4e 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 76 65 72 73 69 6f 6e 60 20 49 4e 54 45 | REMENT.NOT.NULL.,.`version`.INTE |
| 0280 | 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 73 6c 75 67 60 20 54 45 58 54 20 4e 4f 54 20 4e | GER.NOT.NULL.,.`slug`.TEXT.NOT.N |
| 02a0 | 55 4c 4c 0a 2c 20 60 74 69 74 6c 65 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 64 | ULL.,.`title`.TEXT.NOT.NULL.,.`d |
| 02c0 | 61 74 61 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 61 63 63 6f 75 6e 74 5f 69 64 | ata`.TEXT.NOT.NULL.,.`account_id |
| 02e0 | 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 63 72 65 61 74 65 64 60 20 44 | `.INTEGER.NOT.NULL.,.`created`.D |
| 0300 | 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 75 70 64 61 74 65 64 60 20 44 41 54 | ATETIME.NOT.NULL.,.`updated`.DAT |
| 0320 | 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 29 81 04 13 07 17 43 1d 01 81 35 69 6e 64 65 78 55 | ETIME.NOT.NULL.).....C...5indexU |
| 0340 | 51 45 5f 6f 72 67 5f 75 73 65 72 5f 6f 72 67 5f 69 64 5f 75 73 65 72 5f 69 64 6f 72 67 5f 75 73 | QE_org_user_org_id_user_idorg_us |
| 0360 | 65 72 15 43 52 45 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 20 60 55 51 45 5f 6f 72 67 5f | er.CREATE.UNIQUE.INDEX.`UQE_org_ |
| 0380 | 75 73 65 72 5f 6f 72 67 5f 69 64 5f 75 73 65 72 5f 69 64 60 20 4f 4e 20 60 6f 72 67 5f 75 73 65 | user_org_id_user_id`.ON.`org_use |
| 03a0 | 72 60 20 28 60 6f 72 67 5f 69 64 60 2c 60 75 73 65 72 5f 69 64 60 29 63 12 07 17 33 1d 01 81 03 | r`.(`org_id`,`user_id`)c...3.... |
| 03c0 | 69 6e 64 65 78 49 44 58 5f 6f 72 67 5f 75 73 65 72 5f 6f 72 67 5f 69 64 6f 72 67 5f 75 73 65 72 | indexIDX_org_user_org_idorg_user |
| 03e0 | 14 43 52 45 41 54 45 20 49 4e 44 45 58 20 60 49 44 58 5f 6f 72 67 5f 75 73 65 72 5f 6f 72 67 5f | .CREATE.INDEX.`IDX_org_user_org_ |
| 0400 | 69 64 60 20 4f 4e 20 60 6f 72 67 5f 75 73 65 72 60 20 28 60 6f 72 67 5f 69 64 60 29 81 74 11 07 | id`.ON.`org_user`.(`org_id`).t.. |
| 0420 | 17 1d 1d 01 83 3b 74 61 62 6c 65 6f 72 67 5f 75 73 65 72 6f 72 67 5f 75 73 65 72 13 43 52 45 41 | .....;tableorg_userorg_user.CREA |
| 0440 | 54 45 20 54 41 42 4c 45 20 60 6f 72 67 5f 75 73 65 72 60 20 28 0a 60 69 64 60 20 49 4e 54 45 47 | TE.TABLE.`org_user`.(.`id`.INTEG |
| 0460 | 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 20 4e 4f 54 | ER.PRIMARY.KEY.AUTOINCREMENT.NOT |
| 0480 | 20 4e 55 4c 4c 0a 2c 20 60 6f 72 67 5f 69 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c | .NULL.,.`org_id`.INTEGER.NOT.NUL |
| 04a0 | 4c 0a 2c 20 60 75 73 65 72 5f 69 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c | L.,.`user_id`.INTEGER.NOT.NULL., |
| 04c0 | 20 60 72 6f 6c 65 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 63 72 65 61 74 65 64 | .`role`.TEXT.NOT.NULL.,.`created |
| 04e0 | 60 20 44 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 75 70 64 61 74 65 64 60 20 | `.DATETIME.NOT.NULL.,.`updated`. |
| 0500 | 44 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 29 82 67 0f 07 17 13 13 01 85 35 74 61 62 | DATETIME.NOT.NULL.).g.......5tab |
| 0520 | 6c 65 6f 72 67 6f 72 67 11 43 52 45 41 54 45 20 54 41 42 4c 45 20 60 6f 72 67 60 20 28 0a 60 69 | leorgorg.CREATE.TABLE.`org`.(.`i |
| 0540 | 64 60 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 | d`.INTEGER.PRIMARY.KEY.AUTOINCRE |
| 0560 | 4d 45 4e 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 76 65 72 73 69 6f 6e 60 20 49 4e 54 45 47 45 | MENT.NOT.NULL.,.`version`.INTEGE |
| 0580 | 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6e 61 6d 65 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c | R.NOT.NULL.,.`name`.TEXT.NOT.NUL |
| 05a0 | 4c 0a 2c 20 60 61 64 64 72 65 73 73 31 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 61 64 64 72 | L.,.`address1`.TEXT.NULL.,.`addr |
| 05c0 | 65 73 73 32 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 69 74 79 60 20 54 45 58 54 20 4e 55 | ess2`.TEXT.NULL.,.`city`.TEXT.NU |
| 05e0 | 4c 4c 0a 2c 20 60 73 74 61 74 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 7a 69 70 5f 63 6f | LL.,.`state`.TEXT.NULL.,.`zip_co |
| 0600 | 64 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 6f 75 6e 74 72 79 60 20 54 45 58 54 20 4e | de`.TEXT.NULL.,.`country`.TEXT.N |
| 0620 | 55 4c 4c 0a 2c 20 60 62 69 6c 6c 69 6e 67 5f 65 6d 61 69 6c 60 20 54 45 58 54 20 4e 55 4c 4c 0a | ULL.,.`billing_email`.TEXT.NULL. |
| 0640 | 2c 20 60 63 72 65 61 74 65 64 60 20 44 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 | ,.`created`.DATETIME.NOT.NULL.,. |
| 0660 | 60 75 70 64 61 74 65 64 60 20 44 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 29 81 06 0e | `updated`.DATETIME.NOT.NULL.)... |
| 0680 | 07 17 47 15 01 81 3d 69 6e 64 65 78 55 51 45 5f 73 74 61 72 5f 75 73 65 72 5f 69 64 5f 64 61 73 | ..G...=indexUQE_star_user_id_das |
| 06a0 | 68 62 6f 61 72 64 5f 69 64 73 74 61 72 10 43 52 45 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 | hboard_idstar.CREATE.UNIQUE.INDE |
| 06c0 | 58 20 60 55 51 45 5f 73 74 61 72 5f 75 73 65 72 5f 69 64 5f 64 61 73 68 62 6f 61 72 64 5f 69 64 | X.`UQE_star_user_id_dashboard_id |
| 06e0 | 60 20 4f 4e 20 60 73 74 61 72 60 20 28 60 75 73 65 72 5f 69 64 60 2c 60 64 61 73 68 62 6f 61 72 | `.ON.`star`.(`user_id`,`dashboar |
| 0700 | 64 5f 69 64 60 29 81 1b 0d 07 17 15 15 01 82 19 74 61 62 6c 65 73 74 61 72 73 74 61 72 0f 43 52 | d_id`)..........tablestarstar.CR |
| 0720 | 45 41 54 45 20 54 41 42 4c 45 20 60 73 74 61 72 60 20 28 0a 60 69 64 60 20 49 4e 54 45 47 45 52 | EATE.TABLE.`star`.(.`id`.INTEGER |
| 0740 | 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 20 4e 4f 54 20 4e | .PRIMARY.KEY.AUTOINCREMENT.NOT.N |
| 0760 | 55 4c 4c 0a 2c 20 60 75 73 65 72 5f 69 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c | ULL.,.`user_id`.INTEGER.NOT.NULL |
| 0780 | 0a 2c 20 60 64 61 73 68 62 6f 61 72 64 5f 69 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 | .,.`dashboard_id`.INTEGER.NOT.NU |
| 07a0 | 4c 4c 0a 29 67 0c 07 17 35 1f 01 81 07 69 6e 64 65 78 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f | LL.)g...5....indexIDX_temp_user_ |
| 07c0 | 73 74 61 74 75 73 74 65 6d 70 5f 75 73 65 72 0c 43 52 45 41 54 45 20 49 4e 44 45 58 20 60 49 44 | statustemp_user.CREATE.INDEX.`ID |
| 07e0 | 58 5f 74 65 6d 70 5f 75 73 65 72 5f 73 74 61 74 75 73 60 20 4f 4e 20 60 74 65 6d 70 5f 75 73 65 | X_temp_user_status`.ON.`temp_use |
| 0800 | 72 60 20 28 60 73 74 61 74 75 73 60 29 60 0b 06 17 31 1f 01 7f 69 6e 64 65 78 49 44 58 5f 74 65 | r`.(`status`)`...1...indexIDX_te |
| 0820 | 6d 70 5f 75 73 65 72 5f 63 6f 64 65 74 65 6d 70 5f 75 73 65 72 0b 43 52 45 41 54 45 20 49 4e 44 | mp_user_codetemp_user.CREATE.IND |
| 0840 | 45 58 20 60 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 63 6f 64 65 60 20 4f 4e 20 60 74 65 6d 70 | EX.`IDX_temp_user_code`.ON.`temp |
| 0860 | 5f 75 73 65 72 60 20 28 60 63 6f 64 65 60 29 67 0a 07 17 35 1f 01 81 07 69 6e 64 65 78 49 44 58 | _user`.(`code`)g...5....indexIDX |
| 0880 | 5f 74 65 6d 70 5f 75 73 65 72 5f 6f 72 67 5f 69 64 74 65 6d 70 5f 75 73 65 72 0a 43 52 45 41 54 | _temp_user_org_idtemp_user.CREAT |
| 08a0 | 45 20 49 4e 44 45 58 20 60 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 6f 72 67 5f 69 64 60 20 4f | E.INDEX.`IDX_temp_user_org_id`.O |
| 08c0 | 4e 20 60 74 65 6d 70 5f 75 73 65 72 60 20 28 60 6f 72 67 5f 69 64 60 29 83 4c 08 07 17 1f 1f 01 | N.`temp_user`.(`org_id`).L...... |
| 08e0 | 86 67 74 61 62 6c 65 74 65 6d 70 5f 75 73 65 72 74 65 6d 70 5f 75 73 65 72 08 43 52 45 41 54 45 | .gtabletemp_usertemp_user.CREATE |
| 0900 | 20 54 41 42 4c 45 20 60 74 65 6d 70 5f 75 73 65 72 60 20 28 0a 60 69 64 60 20 49 4e 54 45 47 45 | .TABLE.`temp_user`.(.`id`.INTEGE |
| 0920 | 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 20 4e 4f 54 20 | R.PRIMARY.KEY.AUTOINCREMENT.NOT. |
| 0940 | 4e 55 4c 4c 0a 2c 20 60 6f 72 67 5f 69 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c | NULL.,.`org_id`.INTEGER.NOT.NULL |
| 0960 | 0a 2c 20 60 76 65 72 73 69 6f 6e 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 | .,.`version`.INTEGER.NOT.NULL.,. |
| 0980 | 60 65 6d 61 69 6c 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6e 61 6d 65 60 20 54 | `email`.TEXT.NOT.NULL.,.`name`.T |
| 09a0 | 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 72 6f 6c 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 | EXT.NULL.,.`role`.TEXT.NULL.,.`c |
| 09c0 | 6f 64 65 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 73 74 61 74 75 73 60 20 54 45 | ode`.TEXT.NOT.NULL.,.`status`.TE |
| 09e0 | 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 69 6e 76 69 74 65 64 5f 62 79 5f 75 73 65 72 5f 69 | XT.NOT.NULL.,.`invited_by_user_i |
| 0a00 | 64 60 20 49 4e 54 45 47 45 52 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 6c 5f 73 65 6e 74 60 20 49 | d`.INTEGER.NULL.,.`email_sent`.I |
| 0a20 | 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 6c 5f 73 65 6e 74 5f 6f 6e | NTEGER.NOT.NULL.,.`email_sent_on |
| 0a40 | 60 20 44 41 54 45 54 49 4d 45 20 4e 55 4c 4c 0a 2c 20 60 72 65 6d 6f 74 65 5f 61 64 64 72 60 20 | `.DATETIME.NULL.,.`remote_addr`. |
| 0a60 | 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 72 65 61 74 65 64 60 20 44 41 54 45 54 49 4d 45 20 4e | TEXT.NULL.,.`created`.DATETIME.N |
| 0a80 | 4f 54 20 4e 55 4c 4c 0a 2c 20 60 75 70 64 61 74 65 64 60 20 44 41 54 45 54 49 4d 45 20 4e 4f 54 | OT.NULL.,.`updated`.DATETIME.NOT |
| 0aa0 | 20 4e 55 4c 4c 0a 29 56 06 06 17 29 15 01 7d 69 6e 64 65 78 55 51 45 5f 75 73 65 72 5f 65 6d 61 | .NULL.)V...)..}indexUQE_user_ema |
| 0ac0 | 69 6c 75 73 65 72 07 43 52 45 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 20 60 55 51 45 5f | iluser.CREATE.UNIQUE.INDEX.`UQE_ |
| 0ae0 | 75 73 65 72 5f 65 6d 61 69 6c 60 20 4f 4e 20 60 75 73 65 72 60 20 28 60 65 6d 61 69 6c 60 29 56 | user_email`.ON.`user`.(`email`)V |
| 0b00 | 05 06 17 29 15 01 7d 69 6e 64 65 78 55 51 45 5f 75 73 65 72 5f 6c 6f 67 69 6e 75 73 65 72 05 43 | ...)..}indexUQE_user_loginuser.C |
| 0b20 | 52 45 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 20 60 55 51 45 5f 75 73 65 72 5f 6c 6f 67 | REATE.UNIQUE.INDEX.`UQE_user_log |
| 0b40 | 69 6e 60 20 4f 4e 20 60 75 73 65 72 60 20 28 60 6c 6f 67 69 6e 60 29 00 00 00 07 17 15 15 4f 10 | in`.ON.`user`.(`login`).......O. |
| 0b60 | 06 17 25 13 01 75 69 6e 64 65 78 55 51 45 5f 6f 72 67 5f 6e 61 6d 65 6f 72 67 12 43 52 45 41 54 | ..%..uindexUQE_org_nameorg.CREAT |
| 0b80 | 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 20 60 55 51 45 5f 6f 72 67 5f 6e 61 6d 65 60 20 4f 4e | E.UNIQUE.INDEX.`UQE_org_name`.ON |
| 0ba0 | 20 60 6f 72 67 60 20 28 60 6e 61 6d 65 60 29 64 09 07 17 33 1f 01 81 03 69 6e 64 65 78 49 44 58 | .`org`.(`name`)d...3....indexIDX |
| 0bc0 | 5f 74 65 6d 70 5f 75 73 65 72 5f 65 6d 61 69 6c 74 65 6d 70 5f 75 73 65 72 09 43 52 45 41 54 45 | _temp_user_emailtemp_user.CREATE |
| 0be0 | 20 49 4e 44 45 58 20 60 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 65 6d 61 69 6c 60 20 4f 4e 20 | .INDEX.`IDX_temp_user_email`.ON. |
| 0c00 | 60 74 65 6d 70 5f 75 73 65 72 60 20 28 60 65 6d 61 69 6c 60 29 64 07 07 17 35 15 01 81 0b 69 6e | `temp_user`.(`email`)d...5....in |
| 0c20 | 64 65 78 49 44 58 5f 75 73 65 72 5f 6c 6f 67 69 6e 5f 65 6d 61 69 6c 75 73 65 72 04 43 52 45 41 | dexIDX_user_login_emailuser.CREA |
| 0c40 | 54 45 20 49 4e 44 45 58 20 60 49 44 58 5f 75 73 65 72 5f 6c 6f 67 69 6e 5f 65 6d 61 69 6c 60 20 | TE.INDEX.`IDX_user_login_email`. |
| 0c60 | 4f 4e 20 60 75 73 65 72 60 20 28 60 6c 6f 67 69 6e 60 2c 60 65 6d 61 69 6c 60 29 84 2c 04 07 17 | ON.`user`.(`login`,`email`).,... |
| 0c80 | 15 15 01 88 3b 74 61 62 6c 65 75 73 65 72 75 73 65 72 06 43 52 45 41 54 45 20 54 41 42 4c 45 20 | ....;tableuseruser.CREATE.TABLE. |
| 0ca0 | 60 75 73 65 72 60 20 28 0a 60 69 64 60 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 | `user`.(.`id`.INTEGER.PRIMARY.KE |
| 0cc0 | 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 76 65 72 73 | Y.AUTOINCREMENT.NOT.NULL.,.`vers |
| 0ce0 | 69 6f 6e 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6c 6f 67 69 6e 60 20 | ion`.INTEGER.NOT.NULL.,.`login`. |
| 0d00 | 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 6c 60 20 54 45 58 54 20 4e 4f 54 | TEXT.NOT.NULL.,.`email`.TEXT.NOT |
| 0d20 | 20 4e 55 4c 4c 0a 2c 20 60 6e 61 6d 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 70 61 73 73 | .NULL.,.`name`.TEXT.NULL.,.`pass |
| 0d40 | 77 6f 72 64 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 73 61 6c 74 60 20 54 45 58 54 20 4e 55 | word`.TEXT.NULL.,.`salt`.TEXT.NU |
| 0d60 | 4c 4c 0a 2c 20 60 72 61 6e 64 73 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 6f 6d 70 61 6e | LL.,.`rands`.TEXT.NULL.,.`compan |
| 0d80 | 79 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 6f 72 67 5f 69 64 60 20 49 4e 54 45 47 45 52 20 | y`.TEXT.NULL.,.`org_id`.INTEGER. |
| 0da0 | 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 69 73 5f 61 64 6d 69 6e 60 20 49 4e 54 45 47 45 52 20 4e 4f | NOT.NULL.,.`is_admin`.INTEGER.NO |
| 0dc0 | 54 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 6c 5f 76 65 72 69 66 69 65 64 60 20 49 4e 54 45 47 45 | T.NULL.,.`email_verified`.INTEGE |
| 0de0 | 52 20 4e 55 4c 4c 0a 2c 20 60 74 68 65 6d 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 72 | R.NULL.,.`theme`.TEXT.NULL.,.`cr |
| 0e00 | 65 61 74 65 64 60 20 44 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 75 70 64 61 | eated`.DATETIME.NOT.NULL.,.`upda |
| 0e20 | 74 65 64 60 20 44 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 68 65 6c 70 5f 66 | ted`.DATETIME.NOT.NULL.,.`help_f |
| 0e40 | 6c 61 67 73 31 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 20 44 45 46 41 55 4c 54 20 | lags1`.INTEGER.NOT.NULL.DEFAULT. |
| 0e60 | 30 2c 20 60 6c 61 73 74 5f 73 65 65 6e 5f 61 74 60 20 44 41 54 45 54 49 4d 45 20 4e 55 4c 4c 2c | 0,.`last_seen_at`.DATETIME.NULL, |
| 0e80 | 20 60 69 73 5f 64 69 73 61 62 6c 65 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 20 | .`is_disabled`.INTEGER.NOT.NULL. |
| 0ea0 | 44 45 46 41 55 4c 54 20 30 29 50 02 06 17 2b 2b 01 59 74 61 62 6c 65 73 71 6c 69 74 65 5f 73 65 | DEFAULT.0)P...++.Ytablesqlite_se |
| 0ec0 | 71 75 65 6e 63 65 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 03 43 52 45 41 54 45 20 54 41 42 | quencesqlite_sequence.CREATE.TAB |
| 0ee0 | 4c 45 20 73 71 6c 69 74 65 5f 73 65 71 75 65 6e 63 65 28 6e 61 6d 65 2c 73 65 71 29 82 01 01 07 | LE.sqlite_sequence(name,seq).... |
| 0f00 | 17 27 27 01 83 41 74 61 62 6c 65 6d 69 67 72 61 74 69 6f 6e 5f 6c 6f 67 6d 69 67 72 61 74 69 6f | .''..Atablemigration_logmigratio |
| 0f20 | 6e 5f 6c 6f 67 02 43 52 45 41 54 45 20 54 41 42 4c 45 20 60 6d 69 67 72 61 74 69 6f 6e 5f 6c 6f | n_log.CREATE.TABLE.`migration_lo |
| 0f40 | 67 60 20 28 0a 60 69 64 60 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 | g`.(.`id`.INTEGER.PRIMARY.KEY.AU |
| 0f60 | 54 4f 49 4e 43 52 45 4d 45 4e 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6d 69 67 72 61 74 69 6f | TOINCREMENT.NOT.NULL.,.`migratio |
| 0f80 | 6e 5f 69 64 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 73 71 6c 60 20 54 45 58 54 | n_id`.TEXT.NOT.NULL.,.`sql`.TEXT |
| 0fa0 | 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 73 75 63 63 65 73 73 60 20 49 4e 54 45 47 45 52 20 4e 4f | .NOT.NULL.,.`success`.INTEGER.NO |
| 0fc0 | 54 20 4e 55 4c 4c 0a 2c 20 60 65 72 72 6f 72 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c | T.NULL.,.`error`.TEXT.NOT.NULL., |
| 0fe0 | 20 60 74 69 6d 65 73 00 00 00 5b 63 00 00 00 49 54 00 00 00 33 40 00 00 00 1c 2f 00 00 00 1a 18 | .`times...[c...IT...3@..../..... |
| 1000 | 05 00 00 00 0a 0f c9 00 00 00 00 6d 0f fb 0f f6 0f f1 0f ec 0f e7 0f e1 0f db 0f d5 0f cf 0f c9 | ...........m.................... |
| 1020 | 06 1d 05 d9 05 62 05 23 04 a0 04 24 02 2f 01 af 01 2b 00 ae 00 00 00 00 00 00 00 00 00 00 00 00 | .....b.#...$./...+.............. |
| 1040 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 1060 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 1080 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 10a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 7b 16 08 00 59 81 01 09 0d 33 63 72 65 61 74 65 20 69 | ..............{...Y....3create.i |
| 10c0 | 6e 64 65 78 20 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 63 6f 64 65 20 2d 20 76 31 2d 37 43 52 | ndex.IDX_temp_user_code.-.v1-7CR |
| 10e0 | 45 41 54 45 20 49 4e 44 45 58 20 60 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 63 6f 64 65 60 20 | EATE.INDEX.`IDX_temp_user_code`. |
| 1100 | 4f 4e 20 60 74 65 6d 70 5f 75 73 65 72 60 20 28 60 63 6f 64 65 60 29 3b 32 30 32 30 2d 31 30 2d | ON.`temp_user`.(`code`);2020-10- |
| 1120 | 32 38 20 31 37 3a 31 37 3a 33 30 81 01 15 08 00 5d 81 09 09 0d 33 63 72 65 61 74 65 20 69 6e 64 | 28.17:17:30.....]....3create.ind |
| 1140 | 65 78 20 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 6f 72 67 5f 69 64 20 2d 20 76 31 2d 37 43 52 | ex.IDX_temp_user_org_id.-.v1-7CR |
| 1160 | 45 41 54 45 20 49 4e 44 45 58 20 60 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 6f 72 67 5f 69 64 | EATE.INDEX.`IDX_temp_user_org_id |
| 1180 | 60 20 4f 4e 20 60 74 65 6d 70 5f 75 73 65 72 60 20 28 60 6f 72 67 5f 69 64 60 29 3b 32 30 32 30 | `.ON.`temp_user`.(`org_id`);2020 |
| 11a0 | 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 7e 14 08 00 5b 81 05 09 0d 33 63 72 65 61 74 65 20 | -10-28.17:17:30~...[....3create. |
| 11c0 | 69 6e 64 65 78 20 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 65 6d 61 69 6c 20 2d 20 76 31 2d 37 | index.IDX_temp_user_email.-.v1-7 |
| 11e0 | 43 52 45 41 54 45 20 49 4e 44 45 58 20 60 49 44 58 5f 74 65 6d 70 5f 75 73 65 72 5f 65 6d 61 69 | CREATE.INDEX.`IDX_temp_user_emai |
| 1200 | 6c 60 20 4f 4e 20 60 74 65 6d 70 5f 75 73 65 72 60 20 28 60 65 6d 61 69 6c 60 29 3b 32 30 32 30 | l`.ON.`temp_user`.(`email`);2020 |
| 1220 | 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 83 72 13 08 00 43 87 05 09 0d 33 63 72 65 61 74 65 | -10-28.17:17:30.r...C....3create |
| 1240 | 20 74 65 6d 70 20 75 73 65 72 20 74 61 62 6c 65 20 76 31 2d 37 43 52 45 41 54 45 20 54 41 42 4c | .temp.user.table.v1-7CREATE.TABL |
| 1260 | 45 20 49 46 20 4e 4f 54 20 45 58 49 53 54 53 20 60 74 65 6d 70 5f 75 73 65 72 60 20 28 0a 60 69 | E.IF.NOT.EXISTS.`temp_user`.(.`i |
| 1280 | 64 60 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 | d`.INTEGER.PRIMARY.KEY.AUTOINCRE |
| 12a0 | 4d 45 4e 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6f 72 67 5f 69 64 60 20 49 4e 54 45 47 45 52 | MENT.NOT.NULL.,.`org_id`.INTEGER |
| 12c0 | 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 76 65 72 73 69 6f 6e 60 20 49 4e 54 45 47 45 52 20 4e 4f | .NOT.NULL.,.`version`.INTEGER.NO |
| 12e0 | 54 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 6c 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c | T.NULL.,.`email`.TEXT.NOT.NULL., |
| 1300 | 20 60 6e 61 6d 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 72 6f 6c 65 60 20 54 45 58 54 20 | .`name`.TEXT.NULL.,.`role`.TEXT. |
| 1320 | 4e 55 4c 4c 0a 2c 20 60 63 6f 64 65 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 73 | NULL.,.`code`.TEXT.NOT.NULL.,.`s |
| 1340 | 74 61 74 75 73 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 69 6e 76 69 74 65 64 5f | tatus`.TEXT.NOT.NULL.,.`invited_ |
| 1360 | 62 79 5f 75 73 65 72 5f 69 64 60 20 49 4e 54 45 47 45 52 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 | by_user_id`.INTEGER.NULL.,.`emai |
| 1380 | 6c 5f 73 65 6e 74 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 | l_sent`.INTEGER.NOT.NULL.,.`emai |
| 13a0 | 6c 5f 73 65 6e 74 5f 6f 6e 60 20 44 41 54 45 54 49 4d 45 20 4e 55 4c 4c 0a 2c 20 60 72 65 6d 6f | l_sent_on`.DATETIME.NULL.,.`remo |
| 13c0 | 74 65 5f 61 64 64 72 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 72 65 61 74 65 64 60 20 44 | te_addr`.TEXT.NULL.,.`created`.D |
| 13e0 | 41 54 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 75 70 64 61 74 65 64 60 20 44 41 54 | ATETIME.NOT.NULL.,.`updated`.DAT |
| 1400 | 45 54 49 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 29 3b 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 | ETIME.NOT.NULL.);2020-10-28.17:1 |
| 1420 | 37 3a 33 30 7a 12 08 00 4b 81 0d 09 0d 33 41 64 64 20 69 6e 64 65 78 20 75 73 65 72 2e 6c 6f 67 | 7:30z...K....3Add.index.user.log |
| 1440 | 69 6e 2f 75 73 65 72 2e 65 6d 61 69 6c 43 52 45 41 54 45 20 49 4e 44 45 58 20 60 49 44 58 5f 75 | in/user.emailCREATE.INDEX.`IDX_u |
| 1460 | 73 65 72 5f 6c 6f 67 69 6e 5f 65 6d 61 69 6c 60 20 4f 4e 20 60 75 73 65 72 60 20 28 60 6c 6f 67 | ser_login_email`.ON.`user`.(`log |
| 1480 | 69 6e 60 2c 60 65 6d 61 69 6c 60 29 3b 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 | in`,`email`);2020-10-28.17:17:30 |
| 14a0 | 81 00 11 08 00 49 81 1b 09 0d 33 41 64 64 20 69 73 5f 64 69 73 61 62 6c 65 64 20 63 6f 6c 75 6d | .....I....3Add.is_disabled.colum |
| 14c0 | 6e 20 74 6f 20 75 73 65 72 61 6c 74 65 72 20 74 61 62 6c 65 20 60 75 73 65 72 60 20 41 44 44 20 | n.to.useralter.table.`user`.ADD. |
| 14e0 | 43 4f 4c 55 4d 4e 20 60 69 73 5f 64 69 73 61 62 6c 65 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 | COLUMN.`is_disabled`.INTEGER.NOT |
| 1500 | 20 4e 55 4c 4c 20 44 45 46 41 55 4c 54 20 30 20 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 | .NULL.DEFAULT.0.2020-10-28.17:17 |
| 1520 | 3a 33 30 3d 10 07 00 37 29 09 0d 33 41 64 64 20 6d 69 73 73 69 6e 67 20 75 73 65 72 20 64 61 74 | :30=...7)..3Add.missing.user.dat |
| 1540 | 61 63 6f 64 65 20 6d 69 67 72 61 74 69 6f 6e 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a | acode.migration2020-10-28.17:17: |
| 1560 | 33 30 75 0f 08 00 4b 81 03 09 0d 33 41 64 64 20 6c 61 73 74 5f 73 65 65 6e 5f 61 74 20 63 6f 6c | 30u...K....3Add.last_seen_at.col |
| 1580 | 75 6d 6e 20 74 6f 20 75 73 65 72 61 6c 74 65 72 20 74 61 62 6c 65 20 60 75 73 65 72 60 20 41 44 | umn.to.useralter.table.`user`.AD |
| 15a0 | 44 20 43 4f 4c 55 4d 4e 20 60 6c 61 73 74 5f 73 65 65 6e 5f 61 74 60 20 44 41 54 45 54 49 4d 45 | D.COLUMN.`last_seen_at`.DATETIME |
| 15c0 | 20 4e 55 4c 4c 20 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 42 0e 07 00 3f 2b 09 | .NULL.2020-10-28.17:17:30B...?+. |
| 15e0 | 0d 33 55 70 64 61 74 65 20 75 73 65 72 20 74 61 62 6c 65 20 63 68 61 72 73 65 74 2d 2d 20 4e 4f | .3Update.user.table.charset--.NO |
| 1600 | 54 20 52 45 51 55 49 52 45 44 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 81 06 0d | T.REQUIRED2020-10-28.17:17:30... |
| 1620 | 08 00 55 81 1b 09 0d 33 41 64 64 20 63 6f 6c 75 6d 6e 20 68 65 6c 70 5f 66 6c 61 67 73 31 20 74 | ..U....3Add.column.help_flags1.t |
| 1640 | 6f 20 75 73 65 72 20 74 61 62 6c 65 61 6c 74 65 72 20 74 61 62 6c 65 20 60 75 73 65 72 60 20 41 | o.user.tablealter.table.`user`.A |
| 1660 | 44 44 20 43 4f 4c 55 4d 4e 20 60 68 65 6c 70 5f 66 6c 61 67 73 31 60 20 49 4e 54 45 47 45 52 20 | DD.COLUMN.`help_flags1`.INTEGER. |
| 1680 | 4e 4f 54 20 4e 55 4c 4c 20 44 45 46 41 55 4c 54 20 30 20 32 30 32 30 2d 31 30 2d 32 38 20 31 37 | NOT.NULL.DEFAULT.0.2020-10-28.17 |
| 16a0 | 3a 31 37 3a 33 30 4e 0c 07 00 39 49 09 0d 33 44 72 6f 70 20 6f 6c 64 20 74 61 62 6c 65 20 75 73 | :17:30N...9I..3Drop.old.table.us |
| 16c0 | 65 72 5f 76 31 44 52 4f 50 20 54 41 42 4c 45 20 49 46 20 45 58 49 53 54 53 20 60 75 73 65 72 5f | er_v1DROP.TABLE.IF.EXISTS.`user_ |
| 16e0 | 76 31 60 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 82 76 0b 08 00 3f 85 11 09 0d | v1`2020-10-28.17:17:30.v...?.... |
| 1700 | 33 63 6f 70 79 20 64 61 74 61 5f 73 6f 75 72 63 65 20 76 31 20 74 6f 20 76 32 49 4e 53 45 52 54 | 3copy.data_source.v1.to.v2INSERT |
| 1720 | 20 49 4e 54 4f 20 60 75 73 65 72 60 20 28 60 63 6f 6d 70 61 6e 79 60 0a 2c 20 60 6f 72 67 5f 69 | .INTO.`user`.(`company`.,.`org_i |
| 1740 | 64 60 0a 2c 20 60 69 64 60 0a 2c 20 60 6c 6f 67 69 6e 60 0a 2c 20 60 72 61 6e 64 73 60 0a 2c 20 | d`.,.`id`.,.`login`.,.`rands`.,. |
| 1760 | 60 70 61 73 73 77 6f 72 64 60 0a 2c 20 60 73 61 6c 74 60 0a 2c 20 60 69 73 5f 61 64 6d 69 6e 60 | `password`.,.`salt`.,.`is_admin` |
| 1780 | 0a 2c 20 60 63 72 65 61 74 65 64 60 0a 2c 20 60 75 70 64 61 74 65 64 60 0a 2c 20 60 76 65 72 73 | .,.`created`.,.`updated`.,.`vers |
| 17a0 | 69 6f 6e 60 0a 2c 20 60 65 6d 61 69 6c 60 0a 2c 20 60 6e 61 6d 65 60 29 20 53 45 4c 45 43 54 20 | ion`.,.`email`.,.`name`).SELECT. |
| 17c0 | 60 63 6f 6d 70 61 6e 79 60 0a 2c 20 60 61 63 63 6f 75 6e 74 5f 69 64 60 0a 2c 20 60 69 64 60 0a | `company`.,.`account_id`.,.`id`. |
| 17e0 | 2c 20 60 6c 6f 67 69 6e 60 0a 2c 20 60 72 61 6e 64 73 60 0a 2c 20 60 70 61 73 73 77 6f 72 64 60 | ,.`login`.,.`rands`.,.`password` |
| 1800 | 0a 2c 20 60 73 61 6c 74 60 0a 2c 20 60 69 73 5f 61 64 6d 69 6e 60 0a 2c 20 60 63 72 65 61 74 65 | .,.`salt`.,.`is_admin`.,.`create |
| 1820 | 64 60 0a 2c 20 60 75 70 64 61 74 65 64 60 0a 2c 20 60 76 65 72 73 69 6f 6e 60 0a 2c 20 60 65 6d | d`.,.`updated`.,.`version`.,.`em |
| 1840 | 61 69 6c 60 0a 2c 20 60 6e 61 6d 65 60 20 46 52 4f 4d 20 60 75 73 65 72 5f 76 31 60 32 30 32 30 | ail`.,.`name`.FROM.`user_v1`2020 |
| 1860 | 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 73 0a 07 00 4d 7f 09 0d 33 63 72 65 61 74 65 20 69 | -10-28.17:17:30s...M...3create.i |
| 1880 | 6e 64 65 78 20 55 51 45 5f 75 73 65 72 5f 65 6d 61 69 6c 20 2d 20 76 32 43 52 45 41 54 45 20 55 | ndex.UQE_user_email.-.v2CREATE.U |
| 18a0 | 4e 49 51 55 45 20 49 4e 44 45 58 20 60 55 51 45 5f 75 73 65 72 5f 65 6d 61 69 6c 60 20 4f 4e 20 | NIQUE.INDEX.`UQE_user_email`.ON. |
| 18c0 | 60 75 73 65 72 60 20 28 60 65 6d 61 69 6c 60 29 3b 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 | `user`.(`email`);2020-10-28.17:1 |
| 18e0 | 37 3a 33 30 73 09 07 00 4d 7f 09 0d 33 63 72 65 61 74 65 20 69 6e 64 65 78 20 55 51 45 5f 75 73 | 7:30s...M...3create.index.UQE_us |
| 1900 | 65 72 5f 6c 6f 67 69 6e 20 2d 20 76 32 43 52 45 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 | er_login.-.v2CREATE.UNIQUE.INDEX |
| 1920 | 20 60 55 51 45 5f 75 73 65 72 5f 6c 6f 67 69 6e 60 20 4f 4e 20 60 75 73 65 72 60 20 28 60 6c 6f | .`UQE_user_login`.ON.`user`.(`lo |
| 1940 | 67 69 6e 60 29 3b 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 83 63 08 08 00 35 86 | gin`);2020-10-28.17:17:30.c...5. |
| 1960 | 75 09 0d 33 63 72 65 61 74 65 20 75 73 65 72 20 74 61 62 6c 65 20 76 32 43 52 45 41 54 45 20 54 | u..3create.user.table.v2CREATE.T |
| 1980 | 41 42 4c 45 20 49 46 20 4e 4f 54 20 45 58 49 53 54 53 20 60 75 73 65 72 60 20 28 0a 60 69 64 60 | ABLE.IF.NOT.EXISTS.`user`.(.`id` |
| 19a0 | 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 | .INTEGER.PRIMARY.KEY.AUTOINCREME |
| 19c0 | 4e 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 76 65 72 73 69 6f 6e 60 20 49 4e 54 45 47 45 52 20 | NT.NOT.NULL.,.`version`.INTEGER. |
| 19e0 | 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6c 6f 67 69 6e 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c | NOT.NULL.,.`login`.TEXT.NOT.NULL |
| 1a00 | 0a 2c 20 60 65 6d 61 69 6c 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6e 61 6d 65 | .,.`email`.TEXT.NOT.NULL.,.`name |
| 1a20 | 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 70 61 73 73 77 6f 72 64 60 20 54 45 58 54 20 4e 55 | `.TEXT.NULL.,.`password`.TEXT.NU |
| 1a40 | 4c 4c 0a 2c 20 60 73 61 6c 74 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 72 61 6e 64 73 60 20 | LL.,.`salt`.TEXT.NULL.,.`rands`. |
| 1a60 | 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 6f 6d 70 61 6e 79 60 20 54 45 58 54 20 4e 55 4c 4c 0a | TEXT.NULL.,.`company`.TEXT.NULL. |
| 1a80 | 2c 20 60 6f 72 67 5f 69 64 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 69 | ,.`org_id`.INTEGER.NOT.NULL.,.`i |
| 1aa0 | 73 5f 61 64 6d 69 6e 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 | s_admin`.INTEGER.NOT.NULL.,.`ema |
| 1ac0 | 69 6c 5f 76 65 72 69 66 69 65 64 60 20 49 4e 54 45 47 45 52 20 4e 55 4c 4c 0a 2c 20 60 74 68 65 | il_verified`.INTEGER.NULL.,.`the |
| 1ae0 | 6d 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 72 65 61 74 65 64 60 20 44 41 54 45 54 49 | me`.TEXT.NULL.,.`created`.DATETI |
| 1b00 | 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 75 70 64 61 74 65 64 60 20 44 41 54 45 54 49 4d 45 | ME.NOT.NULL.,.`updated`.DATETIME |
| 1b20 | 20 4e 4f 54 20 4e 55 4c 4c 0a 29 3b 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 61 | .NOT.NULL.);2020-10-28.17:17:30a |
| 1b40 | 07 07 00 4f 59 09 0d 33 52 65 6e 61 6d 65 20 74 61 62 6c 65 20 75 73 65 72 20 74 6f 20 75 73 65 | ...OY..3Rename.table.user.to.use |
| 1b60 | 72 5f 76 31 20 2d 20 76 31 41 4c 54 45 52 20 54 41 42 4c 45 20 60 75 73 65 72 60 20 52 45 4e 41 | r_v1.-.v1ALTER.TABLE.`user`.RENA |
| 1b80 | 4d 45 20 54 4f 20 60 75 73 65 72 5f 76 31 60 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a | ME.TO.`user_v1`2020-10-28.17:17: |
| 1ba0 | 33 30 53 06 07 00 49 43 09 0d 33 64 72 6f 70 20 69 6e 64 65 78 20 55 51 45 5f 75 73 65 72 5f 65 | 30S...IC..3drop.index.UQE_user_e |
| 1bc0 | 6d 61 69 6c 20 2d 20 76 31 44 52 4f 50 20 49 4e 44 45 58 20 60 55 51 45 5f 75 73 65 72 5f 65 6d | mail.-.v1DROP.INDEX.`UQE_user_em |
| 1be0 | 61 69 6c 60 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 53 05 07 00 49 43 09 0d 33 | ail`2020-10-28.17:17:30S...IC..3 |
| 1c00 | 64 72 6f 70 20 69 6e 64 65 78 20 55 51 45 5f 75 73 65 72 5f 6c 6f 67 69 6e 20 2d 20 76 31 44 52 | drop.index.UQE_user_login.-.v1DR |
| 1c20 | 4f 50 20 49 4e 44 45 58 20 60 55 51 45 5f 75 73 65 72 5f 6c 6f 67 69 6e 60 32 30 32 30 2d 31 30 | OP.INDEX.`UQE_user_login`2020-10 |
| 1c40 | 2d 32 38 20 31 37 3a 31 37 3a 33 30 6e 04 07 00 43 7f 09 0d 33 61 64 64 20 75 6e 69 71 75 65 20 | -28.17:17:30n...C...3add.unique. |
| 1c60 | 69 6e 64 65 78 20 75 73 65 72 2e 65 6d 61 69 6c 43 52 45 41 54 45 20 55 4e 49 51 55 45 20 49 4e | index.user.emailCREATE.UNIQUE.IN |
| 1c80 | 44 45 58 20 60 55 51 45 5f 75 73 65 72 5f 65 6d 61 69 6c 60 20 4f 4e 20 60 75 73 65 72 60 20 28 | DEX.`UQE_user_email`.ON.`user`.( |
| 1ca0 | 60 65 6d 61 69 6c 60 29 3b 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 6e 03 07 00 | `email`);2020-10-28.17:17:30n... |
| 1cc0 | 43 7f 09 0d 33 61 64 64 20 75 6e 69 71 75 65 20 69 6e 64 65 78 20 75 73 65 72 2e 6c 6f 67 69 6e | C...3add.unique.index.user.login |
| 1ce0 | 43 52 45 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 20 60 55 51 45 5f 75 73 65 72 5f 6c 6f | CREATE.UNIQUE.INDEX.`UQE_user_lo |
| 1d00 | 67 69 6e 60 20 4f 4e 20 60 75 73 65 72 60 20 28 60 6c 6f 67 69 6e 60 29 3b 32 30 32 30 2d 31 30 | gin`.ON.`user`.(`login`);2020-10 |
| 1d20 | 2d 32 38 20 31 37 3a 31 37 3a 33 30 83 30 02 08 00 2f 86 15 09 0d 33 63 72 65 61 74 65 20 75 73 | -28.17:17:30.0.../....3create.us |
| 1d40 | 65 72 20 74 61 62 6c 65 43 52 45 41 54 45 20 54 41 42 4c 45 20 49 46 20 4e 4f 54 20 45 58 49 53 | er.tableCREATE.TABLE.IF.NOT.EXIS |
| 1d60 | 54 53 20 60 75 73 65 72 60 20 28 0a 60 69 64 60 20 49 4e 54 45 47 45 52 20 50 52 49 4d 41 52 59 | TS.`user`.(.`id`.INTEGER.PRIMARY |
| 1d80 | 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 76 | .KEY.AUTOINCREMENT.NOT.NULL.,.`v |
| 1da0 | 65 72 73 69 6f 6e 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6c 6f 67 69 | ersion`.INTEGER.NOT.NULL.,.`logi |
| 1dc0 | 6e 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 65 6d 61 69 6c 60 20 54 45 58 54 20 | n`.TEXT.NOT.NULL.,.`email`.TEXT. |
| 1de0 | 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 6e 61 6d 65 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 70 | NOT.NULL.,.`name`.TEXT.NULL.,.`p |
| 1e00 | 61 73 73 77 6f 72 64 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 73 61 6c 74 60 20 54 45 58 54 | assword`.TEXT.NULL.,.`salt`.TEXT |
| 1e20 | 20 4e 55 4c 4c 0a 2c 20 60 72 61 6e 64 73 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 63 6f 6d | .NULL.,.`rands`.TEXT.NULL.,.`com |
| 1e40 | 70 61 6e 79 60 20 54 45 58 54 20 4e 55 4c 4c 0a 2c 20 60 61 63 63 6f 75 6e 74 5f 69 64 60 20 49 | pany`.TEXT.NULL.,.`account_id`.I |
| 1e60 | 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 69 73 5f 61 64 6d 69 6e 60 20 49 4e 54 | NTEGER.NOT.NULL.,.`is_admin`.INT |
| 1e80 | 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 63 72 65 61 74 65 64 60 20 44 41 54 45 54 49 | EGER.NOT.NULL.,.`created`.DATETI |
| 1ea0 | 4d 45 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 75 70 64 61 74 65 64 60 20 44 41 54 45 54 49 4d 45 | ME.NOT.NULL.,.`updated`.DATETIME |
| 1ec0 | 20 4e 4f 54 20 4e 55 4c 4c 0a 29 3b 32 30 32 30 2d 31 30 2d 32 38 20 31 37 3a 31 37 3a 33 30 82 | .NOT.NULL.);2020-10-28.17:17:30. |
| 1ee0 | 1e 01 08 00 41 83 5f 09 0d 33 63 72 65 61 74 65 20 6d 69 67 72 61 74 69 6f 6e 5f 6c 6f 67 20 74 | ....A._..3create.migration_log.t |
| 1f00 | 61 62 6c 65 43 52 45 41 54 45 20 54 41 42 4c 45 20 49 46 20 4e 4f 54 20 45 58 49 53 54 53 20 60 | ableCREATE.TABLE.IF.NOT.EXISTS.` |
| 1f20 | 6d 69 67 72 61 74 69 6f 6e 5f 6c 6f 67 60 20 28 0a 60 69 64 60 20 49 4e 54 45 47 45 52 20 50 52 | migration_log`.(.`id`.INTEGER.PR |
| 1f40 | 49 4d 41 52 59 20 4b 45 59 20 41 55 54 4f 49 4e 43 52 45 4d 45 4e 54 20 4e 4f 54 20 4e 55 4c 4c | IMARY.KEY.AUTOINCREMENT.NOT.NULL |
| 1f60 | 0a 2c 20 60 6d 69 67 72 61 74 69 6f 6e 5f 69 64 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a | .,.`migration_id`.TEXT.NOT.NULL. |
| 1f80 | 2c 20 60 73 71 6c 60 20 54 45 58 54 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 73 75 63 63 65 73 73 | ,.`sql`.TEXT.NOT.NULL.,.`success |
| 1fa0 | 60 20 49 4e 54 45 47 45 52 20 4e 4f 54 20 4e 55 4c 4c 0a 2c 20 60 65 72 72 6f 72 60 20 54 45 58 | `.INTEGER.NOT.NULL.,.`error`.TEX |
| 1fc0 | 54 20 4e 4f 54 20 4e 55 4c 00 00 00 61 81 66 00 00 00 55 81 4f 00 00 00 4a 81 3a 00 00 00 3f 81 | T.NOT.NUL...a.f...U.O...J.:...?. |
| 1fe0 | 20 00 00 00 34 81 0c 00 00 00 26 74 00 00 00 25 5b 00 00 00 1f 46 00 00 00 0e 2c 00 00 00 0d 16 | ....4.....&t...%[....F....,..... |
| 2000 | 0d 0f 3e 00 0e 0e ef 05 0f 8b 0f e4 0f ac 0f bb 0f 2d 0f 9f 0f 00 0f ed 0f 63 0f 5b 0f 4e 0e ef | ..>..............-.......c.[.N.. |
| 2020 | 0f 76 0f 17 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | .v.............................. |
| 2040 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2060 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2080 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 20a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 20c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 20e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2100 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2120 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2140 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2160 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2180 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 21a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 21c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 21e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2200 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2220 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2240 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2260 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2280 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 22a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 22c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 22e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2300 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2320 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2340 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2360 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2380 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 23a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 23c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 23e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2400 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2420 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2440 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2460 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2480 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 24a0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 24c0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 24e0 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 | ................................ |
| 2500 | 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |