db debugging and tasks - mar 24 - apr
- https://cdn.kinopio.club/INh5awX-xmIg0Dbg9wRIG/CleanShot-2024-03-25-at-09.22.38-2x.png
- mar 25
- migration files
- [x] [[aside]] look through existing table indexes and let lucas know about duplicates that probably should be removed
- migration process
- [x] spaces_collaboratorKey
- [x] run migrations on blank db
- [] `personalBlogSubscribers_email_key` in personalBlogSubscribers table
- [x] eyeball test that tables, columns, associations, indexes matches prod
- [x] table names (check plurals)
- [] users table: duplicate users_email_key and users_appleAppAccountToken_key indexes
- [x] table structures
- [x] manually copy the SequelizeMeta table to local dev and prod dbs
- [x] prod
- [x] run migration after SequelizeMeta to ensure nothing runs
- [x] desktop
- [x] laptop
- [x] note to lucas w screenshot of sequelizeMeta
- [x] readme:
- [x] new migrations should match model.js and modelfiles
- [x] merge pr to prod
- ```sql
CREATE TABLE IF NOT EXISTS "SequelizeMeta" (
name VARCHAR(255) PRIMARY KEY
);
INSERT INTO "SequelizeMeta" (name)
VALUES
('000-create-table-user.js'),
('001-create-table-box.js'),
('002-create-table-card.js'),
('003-create-table-connection.js'),
('004-create-table-connectionType.js'),
('005-create-table-journalDailyPrompt.js'),
('006-create-table-journalPrompt.js'),
('007-create-table-meta.js'),
('008-create-table-notification.js'),
('009-create-table-personalBlogComment.js'),
('010-create-table-personalBlogSubscriber.js'),
('011-create-table-sessionToken.js'),
('012-create-table-shouldNotSendToNonUser.js'),
('013-create-table-shipping.js'),
('014-create-table-space.js'),
('015-create-table-tag.js'),
('016-create-table-userAIGeneratedImage.js'),
('017-create-table-userFavoriteColor.js'),
('018-create-table-userSpace.js'),
('022-create-table-spaceCollaboratorUser.js'),
('023-create-table-notificationUnsubscribe.js'),
('024-create-table-userVisitSpace.js'),
('025-initial-foreign-key-associations.js'),
('025-initial-indexes.js');
```
- [x] add info about how migrations are run
db debugging and tasks - mar 24 - apr
- https://cdn.kinopio.club/INh5awX-xmIg0Dbg9wRIG/CleanShot-2024-03-25-at-09.22.38-2x.png
- mar 25
- migration files
- [x] [[aside]] look through existing table indexes and let lucas know about duplicates that probably should be removed
- migration process
- [x] spaces_collaboratorKey
- [x] run migrations on blank db
- [] `personalBlogSubscribers_email_key` in personalBlogSubscribers table
- [x] eyeball test that tables, columns, associations, indexes matches prod
- [x] table names (check plurals)
- [] users table: duplicate users_email_key and users_appleAppAccountToken_key indexes
- [x] table structures
- [x] manually copy the SequelizeMeta table to local dev and prod dbs
- [x] prod
- [x] run migration after SequelizeMeta to ensure nothing runs
- [x] desktop
- [x] laptop
- [x] note to lucas w screenshot of sequelizeMeta
- [x] readme:
- [x] new migrations should match model.js and modelfiles
- [x] merge pr to prod
- ```sql
CREATE TABLE IF NOT EXISTS "SequelizeMeta" (
name VARCHAR(255) PRIMARY KEY
);
INSERT INTO "SequelizeMeta" (name)
VALUES
('000-create-table-user.js'),
('001-create-table-box.js'),
('002-create-table-card.js'),
('003-create-table-connection.js'),
('004-create-table-connectionType.js'),
('005-create-table-journalDailyPrompt.js'),
('006-create-table-journalPrompt.js'),
('007-create-table-meta.js'),
('008-create-table-notification.js'),
('009-create-table-personalBlogComment.js'),
('010-create-table-personalBlogSubscriber.js'),
('011-create-table-sessionToken.js'),
('012-create-table-shouldNotSendToNonUser.js'),
('013-create-table-shipping.js'),
('014-create-table-space.js'),
('015-create-table-tag.js'),
('016-create-table-userAIGeneratedImage.js'),
('017-create-table-userFavoriteColor.js'),
('018-create-table-userSpace.js'),
('022-create-table-spaceCollaboratorUser.js'),
('023-create-table-notificationUnsubscribe.js'),
('024-create-table-userVisitSpace.js'),
('025-initial-foreign-key-associations.js'),
('025-initial-indexes.js');
```
- [x] add info about how migrations are run