diff options
Diffstat (limited to 'test/users.sql')
-rw-r--r-- | test/users.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/test/users.sql b/test/users.sql new file mode 100644 index 0000000..ec6f046 --- /dev/null +++ b/test/users.sql @@ -0,0 +1,14 @@ +BEGIN; +SELECT plan(7); + +SELECT has_table('users'); +SELECT columns_are('users', ARRAY[ 'user_id', 'username', 'password', 'name', 'modified_at', 'created_at']); +SELECT has_sequence('users_user_id_seq'); +SELECT has_index('teamdraft', 'users', 'users_pk', 'user_id'); + +SELECT has_table('sessions'); +SELECT columns_are('sessions', ARRAY[ 'session_id', 'user_id', 'expires', 'modified', 'created']); +SELECT has_index('teamdraft', 'sessions', 'sessions_pkey', 'session_id'); + +SELECT * FROM finish(); +ROLLBACK; |