I'm working on a master dissertation about forensics investigation in
a MySQL database system. I have gone through the definition of the
.frm file and find some unclear information in the internals manual.
I need more information about the key area. It doesn't say anything
about how the keys or indexes are stored in the .frm file.
About the description of the columns I think it should have been like this:
This part is repeated
2152 1 08 Length of column-name including '\0' termination
2153 8 "column1\0" column-name
2154 3 ??
length of column-name + column-name + 3 bytes is repeat for
every column in the table
This part is also repeated for every column-name
215b 1 04 ??
215c 1 03 ??
215d 1 05 Number of bytes in column
215e 1 05 Number of bytes in column
215f 4 00020000 ??
2163 1 00 Flags for zerofill, unsigned, etc.
2164 1 80 Additional flags, and scale if decimal/numeric
2168 1 fe Data type (fe=char, 02=smallint, 03=int, etc.) see enum
field_types in include/mysql_com.h
2169 1 08 Character set or geometry type
Repeated until here I think
And I need more information about the key area. It doesn't say
anything about how the keys or indexes are stored in the .frm file.
Can somebody help me here?