wtfHEADmain

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;