X-Git-Url: http://git.pippins.net/embedvideo/.git/static/gitweb.js?a=blobdiff_plain;f=sql%2Feq.sql;h=7d0add889529ac0c16c668e73d87136a7152a3d1;hb=d0fe650e8a63864d8fd593aec3429abdec5eac95;hp=277ab8bc706fa3d7d3cf7c0d9819ed224b840245;hpb=e7988503f790bfa136f25cd4ae6e23fdcfaee322;p=eq%2F.git diff --git a/sql/eq.sql b/sql/eq.sql index 277ab8b..7d0add8 100644 --- a/sql/eq.sql +++ b/sql/eq.sql @@ -159,19 +159,6 @@ CREATE TABLE `eq_family` ( PRIMARY KEY (`family`) ) ENGINE=MyISAM AUTO_INCREMENT=277 DEFAULT CHARSET=latin1; --- --- Table structure for table `eq_interview` --- -CREATE TABLE `eq_interview` ( - `interview` int(16) unsigned NOT NULL auto_increment, - `interviewer` int(16) unsigned default NULL, - `elder` int(16) unsigned default NULL, - `aaronic` int(16) unsigned NOT NULL default '0', - `date` date default NULL, - `notes` text, - PRIMARY KEY (`interview`) -) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=latin1; - -- -- Table structure for table `eq_parent` -- @@ -203,6 +190,7 @@ CREATE TABLE `eq_ppi` ( `ppi` int(16) unsigned NOT NULL auto_increment, `interviewer` int(16) unsigned default NULL, `elder` int(16) unsigned default NULL, + `aaronic` int(16) unsigned NOT NULL default '0', `date` date default NULL, `notes` text, `eqpresppi` tinyint(1) default '0',