1 | 22:33:41.200 | | info | yii\db\Command::query | SELECT
d.nspname AS table_schema,
c.relname AS table_name,
a.attname AS column_name,
COALESCE(td.typname, tb.typname, t.typname) AS data_type,
COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type,
(SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme,
a.attlen AS character_maximum_length,
pg_catalog.col_description(c.oid, a.attnum) AS column_comment,
a.atttypmod AS modifier,
a.attnotnull = false AS is_nullable,
CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default,
coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc,
pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name,
CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
ELSE NULL
END AS enum_values,
CASE atttypid
WHEN 21 /*int2*/ THEN 16
WHEN 23 /*int4*/ THEN 32
WHEN 20 /*int8*/ THEN 64
WHEN 1700 /*numeric*/ THEN
CASE WHEN atttypmod = -1
THEN null
ELSE ((atttypmod - 4) >> 16) & 65535
END
WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/
WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/
ELSE null
END AS numeric_precision,
CASE
WHEN atttypid IN (21, 23, 20) THEN 0
WHEN atttypid IN (1700) THEN
CASE
WHEN atttypmod = -1 THEN null
ELSE (atttypmod - 4) & 65535
END
ELSE null
END AS numeric_scale,
CAST(
information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t))
AS numeric
) AS size,
a.attnum = any (ct.conkey) as is_pkey,
COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension
FROM
pg_class c
LEFT JOIN pg_attribute a ON a.attrelid = c.oid
LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid
LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid
LEFT JOIN pg_namespace d ON d.oid = c.relnamespace
LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p'
WHERE
a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped
AND c.relname = 'audit_data'
AND d.nspname = 'public'
ORDER BY
a.attnum; |
2 | 22:33:41.207 | | info | yii\db\Command::query | select
ct.conname as constraint_name,
a.attname as column_name,
fc.relname as foreign_table_name,
fns.nspname as foreign_table_schema,
fa.attname as foreign_column_name
from
(SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s
FROM pg_constraint ct
) AS ct
inner join pg_class c on c.oid=ct.conrelid
inner join pg_namespace ns on c.relnamespace=ns.oid
inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s]
left join pg_class fc on fc.oid=ct.confrelid
left join pg_namespace fns on fc.relnamespace=fns.oid
left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s]
where
ct.contype='f'
and c.relname='audit_data'
and ns.nspname='public'
order by
fns.nspname, fc.relname, a.attnum |
3 | 22:33:41.212 | | info | yii\db\Command::execute | INSERT INTO "audit_data" ("entry_id", "type", "created", "data") VALUES (2110010, 'audit/request', '2025-10-15 22:33:41', 'x��W[s�8~�_��)�o�M�]�0k�M:�F`�5�톦���G26�&m�e_�}����''�-�i}K��U��p�%I��-���X�nU��YⰐTz�j��V���I��!�rO[���-K�\n�̺Uy`lW�{�� U�ٺ�)SW\\,�r��1~�yH�Z�ޒ+MБ��D���5�c�N)����%ٲ*x�&{i��RrH�m���x���\032�]�AH~?\\JwQ��]�V_i��[G���8��@���MDV,���u���s�p/K��\r��F��\032EXk��r5�qv�)vrFC����Sf�%J�Vy��(Ԧ�wfw~��� �!��4՚��Zo)W�G�tRU"��(C��Įg.�h蠭]�wUSo+S��Q||�9-���{�x��2����k�m��`��k�x#��\r���*!��HIUE{�7p��Y����wD�M�e��$�9,N9�jv�������V���/@NB�$�Qr,F�3Yk��)I�,������]_<�aΨ�������ݯ*�<�3��z��o��Ղ�{H���QNd+U�ۚ��4�\rM�`A���?\r�i�qֳ=e��<!�E0��f4��m�OV٦�6��Ν�X���a\032���N�~�q1,`��,�\000h�O�P/-"x��,J�/�ܿM��ͅ�G9w�e))�>�)�猗�XZ����~�''��H l�dY<���wr�s�;��y$&GB&� ��d��Ӳ�G�4����Joe�`~&h�@�Z!�C��3N�3Z��y�����_O^�jy#O��-ᕘ��r����?�g�x�Z�Q̗#��_�C�,�ˁ���^���3BStI���t�R oe#�T��U[\r�hK��7xȞ,���#�qg3H�%?�|J��8h��,]$w��_����Tri�,���uY�<�K4s�x6�iK��A~-�о�8d\\[���8c�&�����''KYµ��q�%���iA�䟫#�ӳ���L�''[����a�I��p�L���L�\n���Z� �B��S��Q挧JG��~+�]�tt>*&�yKE�7��|�~v�9�}�� �k�F��\032� ��\000�]/8rs�\\���\r�I �蒎�vAK1�}�YL�q���J�jj���m��@~pF��\n\000�k�n 4�\n)4�t�8-�Ԓy�t,''߀����c��)���r8�Zv0��"�ƙV��!9���"''E�@E�����|I�oR�&Q�MR_W ��x���bj x�I�;��fz�v�n��1d�؎���p��q�a�zwr̓�uV�)\nFn��!&������7.�-�E���mǬ��O3\rz��G���\000Q��x0���`���|�j��v�aB���i4�ʜ��_� ''�"x��������P�s֒''����1:�����''���<�r��I��'), (2110010, 'audit/log', '2025-10-15 22:33:41', 'x��X�n�F����e�%�/�Dѐ%�S�T�J�� F�Pf�[Hʵ���R�Q�b=3��P�����OH\032Μ�w.s���ٟr۲���9ޒ\\:Ƕi\nl#>���Ȗ�)��x�._!7�c�A�(��B�>ɋ�fL��ޟ��y�d��\032����qD��$r��\n��H灭�w_��-����ܽnd� ���ƹgk�j�����5�2� ����֤�m�B"�СiK���{I6��|��\0004�g� ������}ʘl)bB�������]׀`K�5ބ�ֽ''����\rq�3�� [J��>e�t[:��Ο�ۤ�P-M���O�T��E���o����)u''�ݢ�bpr�ǖ�~F�2}⋸���Zt�p������f~�z�^P�Tl�q5�R~ء֜�f%w9����n�[�*ۮV˷�W]�b��}3_�Qxhz\n)#�V��n��9M�KHb�{�a� ��� �E,l�{N �\\�;L�}���͂��Wq�\000�W�xu�I����(�( �~@21B C0��a����,�=�]+��!�i�`���M:�,<��g�&�G|�K<n�C0�|��_�����r�A��\n��b��1E�\\ƻ" b�v��,�!�}ؑt~�%q�Rgv����2� ���TfvU��l���i�,����D�m�0&�~�T�2�w��ɋJ�R%,��ۭB � v��Se��!�8J_�3\000��F���v�~�!�''wk<��l�������T��ّ\\��W�r��\032\032��B9��i�C\n�S+\nC?�P9�UQ���X�4\000��d\r\rjG��St��q\rt.0g(J�}��]tq&u�?��4\r�gqy\000�#��7�C���Y;og��sy����K��j/��q��nNr1��4v�F��f�\rr�&�N�NKiRt�@��� T�U�\\��b\032�n;-�\\U(��=w������i��s��[;nA�''Y�i�-;^ߡ��-�e�V�!+�a�P0�7( ���8a�\r�A��y� >��+�)��)n]"����$�0>h�t#__)�����T�WN��L� hAd�d��<��P�.�9�.C��CPݯ�q�7�5�v �\000�06�� ���z�Ϛ�ih��8�>�fV�t���h�EE-����i�zC�w���.t���M��D��=3-o;�9aZZ��lE�4�&b�H�g7"���Ä3*����c6�:�S�̿<[�e �|i���֭���2����.s����%iJ�\rLt}j~�&��嚢9�RݻM�rg����Ы�0��4�E8�l�\000��]a4�����`�5�^F�U�\032Ol)��r~�c�e���Ӥ���8��Ma�%8��\n?��8��W�����v�,�ZׁƄ���Ճ�z��UH蚈�oIL2�N���3{�l\032��U��p�}�T�r@�2��B�EI��T\000|����q�y�-=�&''�Ī\rlM\r�A���\\[����ؐ��x���E�~�����9~��\000_�����3�#��������{�!�iԧ���!M�]o2wZן\032\\�6���� 6���T��W7&�¤��e��4i�:2&\\�w�1\\So�@\n�]��H�b� �H��0�''0���J;����#�R��\n��/�[T��m��BB]b�#�s[`�''��%v�<��d3��)�;R��\032]�Fp�g�.�1�(��~�/�Ќ^����z�ΰ��:\000s''��]�CR�d��,7�!4JEYNñ���URc�Ǹ\\]��%LQ��@�"(xO����5�ER\\%���(R!j���6�1���=�;(݄���s¿�;��k�L��\\��.���V��=���P�*�\032�e=P�O嶲F�a�]����j�jK�j\r�����$��IH�2�Ť�v9ɜ��� ���=~���r"R�''l��tIO��g7��H�YJ�,K2��KzH���j\032L�0�f������y��g��t�6{��I|5_�[-�o\000�''���9�Lͪ^�\032�Ms�eE�y$�y�S��(���:.����rX5��د ]hmx��s��<S;�+�.~s|dC�+T�(���QewL�Wt�(z��+�0�:�����Gl�ig�5цCx|�]��{') |