aboutsummaryrefslogblamecommitdiffstats
path: root/test/users.sql
blob: ec6f0460a73bb75b2c78eb63ace87304a76b7d90 (plain) (tree) 
8d018d9














1
2
3
4
5
6
7
8
9
10
11
12
13
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;