X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=sql%2Ftc.sql;h=c54f74e7dcd5fa4abd5d5366f04e9b91d3514afe;hb=14cfa28359cc338a5c0697981474bc88f0e008c1;hp=2d1c631740c32637f3baddb6f5ddccf0ba4cbce5;hpb=b5c74cd3f678ed412df81cda7f8f77344d374d7a;p=eq%2F.git diff --git a/sql/tc.sql b/sql/tc.sql index 2d1c631..c54f74e 100644 --- a/sql/tc.sql +++ b/sql/tc.sql @@ -161,7 +161,6 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_interview` ( CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_leader` ( `leader` int(16) unsigned NOT NULL auto_increment, `individual` int(16) unsigned NOT NULL default '0', - `district` int(16) unsigned default '0', `email` varchar(60) NOT NULL, `type` enum( 'P', 'C', 'S', 'D' ) NOT NULL, `valid` tinyint(1) default '1', @@ -176,8 +175,6 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_visit` ( `visit` int(16) unsigned NOT NULL auto_increment, `family` int(16) unsigned default NULL, `companionship` int(16) unsigned default NULL, - `companion1` int(16) unsigned default NULL, - `companion2` int(16) unsigned default NULL, `date` date default NULL, `notes` text, `visited` enum('y','n','') default NULL,