X-Git-Url: http://git.pippins.net/embedvideo/.git/static/gitweb.js?a=blobdiff_plain;ds=sidebyside;f=sql%2Ftc.sql;h=1552367828e80341ae4a3a2a9369bd09484c3ebd;hb=cdf97a969659bdd67bf33e61b5ccf7ae042938fd;hp=23067212cd69b0cef6f8fc2f73e67aa4ec9b8f86;hpb=dac99ce35c9d3b885f7cc2584493812923303b3d;p=eq%2F.git diff --git a/sql/tc.sql b/sql/tc.sql index 2306721..1552367 100644 --- a/sql/tc.sql +++ b/sql/tc.sql @@ -105,9 +105,9 @@ CREATE TABLE `tc_district` ( -- -- Table structure for table `tc_indiv` -- -CREATE TABLE `tc_indiv` ( - `indiv` int(16) unsigned NOT NULL auto_increment, - `indiv_id` int(16) unsigned NOT NULL, +CREATE TABLE `tc_individual` ( + `individual` int(16) unsigned NOT NULL auto_increment, + `mls_indiv_id` int(16) unsigned NOT NULL, `name` varchar(60) default NULL, `address` varchar(255) default NULL, `phone` varchar(12) default NULL, @@ -133,7 +133,7 @@ CREATE TABLE `tc_family` ( `hofh_id` int(16) unsigned NOT NULL default '0', `name` varchar(30) NOT NULL default '', `name_id` varchar(30) NOT NULL default '', - `indiv_id` int(16) unsigned default '0', + `individual` int(16) unsigned default '0', `companionship` int(16) unsigned default NULL, `visit_pri` int(10) unsigned default '1', `visit_notes` varchar(128) default NULL,