I'm sure I've done something since I remembered to commit...

[familyTree.git] / familyTree / makeMarriageTable.py

diff --git a/familyTree/makeMarriageTable.py b/familyTree/makeMarriageTable.py
index 900bb386ed2cb80dc0287f490dba1aa2d3c466bf..f5eea8c86df2056dffe938c5670708df7961b236 100755 (executable)
--- a/familyTree/makeMarriageTable.py
+++ b/familyTree/makeMarriageTable.py
@@ -1,9 +1,19 @@
 #!/usr/bin/python
 
-s = 'CREATE TABLE marriages\n(\nIDa int,\nIDb text);'
+s = 'CREATE TABLE marriages\n(\nIDa int,\nIDb text,'\
+       +'\nMarriage text,\nend text,\nmarriageYear int,'\
+       +'\nstartDate date,\nendDate date,\nRelated text);'
 
 print s
 
-s = 'CREATE TABLE consorts\n(\nID int,\nconsort text);'
+#s = 'CREATE TABLE consorts\n(\nID int,\nconsort text);'
+
+#print s
+
+s = 'CREATE INDEX spid_index ON marriages (IDa);'
+
+print s
+
+s = 'CREATE INDEX spidb_index ON marriages (IDb);'
 
 print s