Definitions in the frm file

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?
Bjorn.

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com