diff options
| author | spider@app1 <spiderr@bitweaver.org> | 2018-01-10 15:35:41 -0500 |
|---|---|---|
| committer | spider@app1 <spiderr@bitweaver.org> | 2018-01-10 15:35:41 -0500 |
| commit | a4289d2ff33cb46bafd5b2ad8eb00cf1460c96fe (patch) | |
| tree | 23be7ccb8f08680cb1a02517bc7318578b85aac0 /admin | |
| parent | 06f3d6ce436489f54a2618fd8a3bfce78731172d (diff) | |
| download | users-a4289d2ff33cb46bafd5b2ad8eb00cf1460c96fe.tar.gz users-a4289d2ff33cb46bafd5b2ad8eb00cf1460c96fe.tar.bz2 users-a4289d2ff33cb46bafd5b2ad8eb00cf1460c96fe.zip | |
clean up schema_inc with users_auth_map in non-ROLES section
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 13 |
1 files changed, 10 insertions, 3 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 4bff0b7..2f94bc0 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -35,7 +35,6 @@ $tables = array( map_position I4 CONSTRAINT ', CONSTRAINT `users_fav_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`) , CONSTRAINT `users_fav_con_ref` FOREIGN KEY (`favorite_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' - ' ", 'users_auth_map' => " @@ -44,8 +43,7 @@ $tables = array( provider_identifier C(64) NOTNULL, last_login I8, profile_json X - CONSTRAINT ', CONSTRAINT `users_auth_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`) - ' + CONSTRAINT ', CONSTRAINT `users_auth_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)' ", 'users_permissions' => " @@ -137,6 +135,15 @@ $tables = array( , CONSTRAINT `users_logo_attach_ref` FOREIGN KEY (`logo_attachment_id`) REFERENCES `".BIT_DB_PREFIX."liberty_attachments` (`attachment_id`)' ", +'users_auth_map' => " + user_id I4 PRIMARY, + provider C(64) PRIMARY, + provider_identifier C(64) NOTNULL, + last_login I8, + profile_json X + CONSTRAINT ', CONSTRAINT `users_auth_user_ref` FOREIGN KEY (`user_id`) REFERENCES `".BIT_DB_PREFIX."users_users` (`user_id`)' +", + 'users_favorites_map' => " favorite_content_id I4 PRIMARY, user_id I4 PRIMARY, |