projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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,
`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`)
`valid` tinyint(1) default '1',
KEY `leader` (`leader`),
KEY `individual` (`individual`)