3 s = 'CREATE TABLE people\n(\nID int,\nName text,\nFirstName'\
4 +' text,\nBorn text,\nbornYear int,\nDied text,'\
5 +'\ndiedYear int,\nbornMonth int,\ndiedMonth int,'\
6 +'\nURL text,\nPicture text,\nPreName text,\nPostName text,'\
7 +'\nfullName text, \nbornDay int,\ndiedDay int);'
11 s = 'CREATE UNIQUE INDEX id_index ON people (ID);'
15 s = 'CREATE TABLE names\n(\nID int,\nName text);'
19 s = 'CREATE TABLE styles\n(\nID int,\nStyle text,\nStart text,\nstartYear int'\
20 +',\nStop text,\nstopYear int,\nstartDate date,\nstopDate date);'
24 #s = 'CREATE TABLE territories\n(\nID int,\nTerritory text,'\
25 # +'\nStart text,\nstartYear,\nStop text,\nstopYear);'
29 s = 'CREATE TABLE parents\n(\nID int,\nparentID text);'
33 s = 'CREATE TABLE families\n(\nID int, \nfamily text);'
37 s = 'CREATE INDEX pid_index ON parents (ID);'
41 s = 'CREATE INDEX sid_index ON styles (ID);'