move signup sql to static function