projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
changed tc_presidency to tc_leader
[eq/.git]
/
sql
/
tc.sql
diff --git
a/sql/tc.sql
b/sql/tc.sql
index cc8493102a31bb167b584d26d8df26662205a901..ce19e36d3adc7a34635dac1c8b5ea753f4f0d80d 100644
(file)
--- a/
sql/tc.sql
+++ b/
sql/tc.sql
@@
-28,7
+28,7
@@
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_activity` (
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_appointment` (
`appointment` int(16) unsigned NOT NULL auto_increment,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_appointment` (
`appointment` int(16) unsigned NOT NULL auto_increment,
- `
presidency
` int(16) unsigned NOT NULL default '0',
+ `
leader
` int(16) unsigned NOT NULL default '0',
`family` int(16) unsigned default '0',
`individual` int(16) unsigned default '0',
`date` date NOT NULL default '0000-00-00',
`family` int(16) unsigned default '0',
`individual` int(16) unsigned default '0',
`date` date NOT NULL default '0000-00-00',
@@
-156,10
+156,10
@@
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_interview` (
--
--
--- Table structure for table `tc_
presidency
`
+-- Table structure for table `tc_
leader
`
--
--
-CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_
presidency
` (
- `
presidency
` int(16) unsigned NOT NULL auto_increment,
+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,
`individual` int(16) unsigned NOT NULL default '0',
`district` int(16) unsigned default '0',
`email` varchar(60) NOT NULL,
@@
-167,7
+167,7
@@
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_presidency` (
`counselor` tinyint(1) default '0',
`secretary` tinyint(1) default '0',
`valid` tinyint(1) default '1',
`counselor` tinyint(1) default '0',
`secretary` tinyint(1) default '0',
`valid` tinyint(1) default '1',
- KEY `
presidency` (`presidency
`),
+ KEY `
leader` (`leader
`),
KEY `individual` (`individual`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
KEY `individual` (`individual`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;