2023-03-22 16:07:10 +00:00
|
|
|
#! /bin/bash
|
|
|
|
|
2023-06-15 08:24:43 +00:00
|
|
|
tables=("users" "groups" "memberships" "jwt_refresh_storage" "jwt_storage" "password_reset_tokens" "group_attribute_schema" "group_attributes")
|
2023-03-22 16:07:10 +00:00
|
|
|
echo ".header on"
|
|
|
|
|
|
|
|
for table in ${tables[@]}; do
|
|
|
|
echo ".mode insert $table"
|
|
|
|
echo "select * from $table;"
|
2023-05-16 02:29:34 +00:00
|
|
|
done
|
2023-06-15 08:24:43 +00:00
|
|
|
|
|
|
|
echo ".mode insert user_attribute_schema"
|
|
|
|
echo "select * from user_attribute_schema where user_attribute_schema_name not in ('first_name', 'last_name', 'avatar');"
|
|
|
|
|
|
|
|
echo ".mode insert user_attributes"
|
|
|
|
echo "select * from user_attributes;"
|