diff options
| author | Frederick Muriuki Muriithi | 2022-11-14 11:37:25 +0300 |
|---|---|---|
| committer | Frederick Muriuki Muriithi | 2022-11-14 11:37:25 +0300 |
| commit | 0144bfbcec8250d495d17c9728c7fca6beffae72 (patch) | |
| tree | 6c69a3bdb2c4ca814f95e36c0c1f87647c178d45 /migrations/auth/20221110_05_BaNtL-create-roles-table.py | |
| parent | 0cbb54819639ca77266398bb3e4663f74e837d8e (diff) | |
| download | genenetwork3-0144bfbcec8250d495d17c9728c7fca6beffae72.tar.gz | |
Migrations: Create `group_roles` table
* migrations/auth/20221110_05_BaNtL-create-roles-table.py: modify migration
* migrations/auth/20221114_03_PtWjc-create-group-roles-table.py: new migration
* tests/unit/auth/test_migrations_create_tables.py: test new migration
* tests/unit/auth/test_migrations_indexes.py: test new migration
Diffstat (limited to 'migrations/auth/20221110_05_BaNtL-create-roles-table.py')
| -rw-r--r-- | migrations/auth/20221110_05_BaNtL-create-roles-table.py | 12 |
1 files changed, 2 insertions, 10 deletions
diff --git a/migrations/auth/20221110_05_BaNtL-create-roles-table.py b/migrations/auth/20221110_05_BaNtL-create-roles-table.py index bf238f6..edf3ea4 100644 --- a/migrations/auth/20221110_05_BaNtL-create-roles-table.py +++ b/migrations/auth/20221110_05_BaNtL-create-roles-table.py @@ -10,17 +10,9 @@ steps = [ step( """ CREATE TABLE IF NOT EXISTS roles( - group_id TEXT NOT NULL, role_id TEXT NOT NULL PRIMARY KEY, - role_name TEXT NOT NULL, - FOREIGN KEY(group_id) REFERENCES groups(group_id) + role_name TEXT NOT NULL ) WITHOUT ROWID """, - "DROP TABLE IF EXISTS roles"), - step( - """ - CREATE INDEX IF NOT EXISTS idx_tbl_roles_cols_group_id - ON roles(group_id) - """, - "DROP INDEX IF EXISTS idx_tbl_roles_cols_group_id") + "DROP TABLE IF EXISTS roles") ] |