converged president,counselor,secretary fields in tc_leader into one type field

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

diff --git a/sql/tc.sql b/sql/tc.sql
index ce19e36d3adc7a34635dac1c8b5ea753f4f0d80d..2d1c631740c32637f3baddb6f5ddccf0ba4cbce5 100644 (file)
--- a/sql/tc.sql
+++ b/sql/tc.sql
@@ -163,9 +163,7 @@ CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_leader` (
   `individual` int(16) unsigned NOT NULL default '0',
   `district` int(16) unsigned default '0',
   `email` varchar(60) NOT NULL,
-  `president` tinyint(1) default '0',
-  `counselor` tinyint(1) default '0',
-  `secretary` tinyint(1) default '0',
+  `type` enum( 'P', 'C', 'S', 'D' ) NOT NULL,
   `valid` tinyint(1) default '1',
   KEY `leader` (`leader`),
   KEY `individual` (`individual`)