Fixed bug in schedule yearly visit table. Bad index being used in vis_notes array.

[eq/.git] / sql / tc.sql

diff --git a/sql/tc.sql b/sql/tc.sql
index fddc9242b8b483e967613a537a9ad6c9f1af7789..ecea939e05aee03e176f801840b360bb8bc55264 100644 (file)
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -95,7 +95,6 @@ CREATE TABLE `tc_companionship` (
 --
 CREATE TABLE `tc_district` (
   `district` int(16) unsigned NOT NULL default '0',
-  `name` varchar(30) default NULL,
   `supervisor` int(16) unsigned default NULL,
   `valid` tinyint(1) default NULL,
   PRIMARY KEY  (`district`)
@@ -162,7 +161,6 @@ CREATE TABLE `tc_presidency` (
   `presidency` int(16) unsigned NOT NULL auto_increment,
   `individual` int(16) unsigned NOT NULL default '0',
   `district` int(16) unsigned default '0',
-  `name` varchar(60) NOT NULL,
   `email` varchar(60) NOT NULL,
   `president` tinyint(1) default '0',
   `counselor` tinyint(1) default '0',