What database structure to use to store GEDCOM information?

Question

What database structure to use to store GEDCOM information?

Answer 1

Depending on text width, you can use varchar or text/tinytext/bigtext.

If your GEDCOM data looks like this:

0 HEAD 
1 SOUR Reunion
2 VERS V8.0
2 CORP Leister Productions
...

and you want to store each line in separate row, then varchar(255) should be enaugh.