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

[familyTree.git] / familyTree / makeTables.py

diff --git a/familyTree/makeTables.py b/familyTree/makeTables.py
index ca3f6038afd9677d0326b9446ea83490f57728cb..089031620c3ccc4b6b63f66c31305bea67d1a4e5 100755 (executable)
--- a/familyTree/makeTables.py
+++ b/familyTree/makeTables.py
@@ -2,22 +2,43 @@
 
 s = 'CREATE TABLE people\n(\nID int,\nName text,\nFirstName'\
        +' text,\nBorn text,\nbornYear int,\nDied text,'\
-       +'\ndiedYear int,\nbornMonth int,\ndiedMonth,'\
-       +'\nURL text,\nPicture text);'
+       +'\ndiedYear int,\nbornMonth int,\ndiedMonth int,'\
+       +'\nURL text,\nPicture text,\nPreName text,\nPostName text,'\
+       +'\nfullName text, \nbornDay int,\ndiedDay int);'
 
 print s
 
-s = 'CREATE TABLE styles\n(\nID int,\nStyle text,\nStart text,\nstartYear int'\
-       +',\nStop text,\nstopYear int);'
+s = 'CREATE UNIQUE INDEX id_index ON people (ID);'
+
+print s
+
+s = 'CREATE TABLE names\n(\nID int,\nName text);'
 
 print s
 
-s = 'CREATE TABLE territories\n(\nID int,\nTerritory text,'\
-       +'\nStart text,\nstartYear,\nStop text,\nstopYear);'
+s = 'CREATE TABLE styles\n(\nID int,\nStyle text,\nStart text,\nstartYear int'\
+       +',\nStop text,\nstopYear int,\nstartDate date,\nstopDate date);'
 
 print s
 
+#s = 'CREATE TABLE territories\n(\nID int,\nTerritory text,'\
+#      +'\nStart text,\nstartYear,\nStop text,\nstopYear);'
+#
+#print s
+
 s = 'CREATE TABLE parents\n(\nID int,\nparentID text);'
 
 print s
 
+s = 'CREATE TABLE families\n(\nID int, \nfamily text);'
+
+print s
+
+s = 'CREATE INDEX pid_index ON parents (ID);'
+
+print s
+
+s = 'CREATE INDEX sid_index ON styles (ID);'
+
+print s
+