X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=sql%2Ftc.sql;h=9aaff5ea88d60bab34c31e3f5ceb3462edeaf34c;hb=61df0220f9c24a23b834d1fdf64c2a3630e52560;hp=ce19e36d3adc7a34635dac1c8b5ea753f4f0d80d;hpb=9cbfdccb986373952fc820285cbc027b41c44b5e;p=eq%2F.git diff --git a/sql/tc.sql b/sql/tc.sql index ce19e36..9aaff5e 100644 --- a/sql/tc.sql +++ b/sql/tc.sql @@ -161,11 +161,8 @@ 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, - `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`)