CREATE TABLE TblUsers( user_id VARCHAR(18) NOT NULL PRIMARY KEY, user_password VARCHAR(255) NOT NULL, question TEXT NOT NULL, q_answer TEXT NOT NULL, CONSTRAINT user_id_fk FOREIGN KEY(user_id) REFERENCES TblPermissions(user_id)); CREATE TABLE TblPermissions( user_id VARCHAR(18) NOT NULL PRIMARY KEY, perm_one INT NOT NULL DEFAULT 0 CHECK( perm_one < 1 && perm_one > 0 ), perm_two INT NOT NULL DEFAULT 0 CHECK( perm_two < 1 && perm_two > 0 ) );