projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
changed visit_type to type
[eq/.git]
/
sql
/
tc.sql
diff --git
a/sql/tc.sql
b/sql/tc.sql
index 7b23e0817b6b1e0d813ebf9b1664eefd402088b8..f5520dbaeee32d909b912eedfff10087a4e6e741 100644
(file)
--- a/
sql/tc.sql
+++ b/
sql/tc.sql
@@
-149,7
+149,7
@@
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_interview` (
`individual` int(16) unsigned default NULL,
`date` date default NULL,
`notes` text,
`individual` int(16) unsigned default NULL,
`date` date default NULL,
`notes` text,
- `
interview_type` enum('hti','ppi') NOT NULL DEFAULT 'hti
',
+ `
type` enum('H','P') NOT NULL DEFAULT 'H
',
PRIMARY KEY (`interview`)
) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=latin1;
PRIMARY KEY (`interview`)
) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=latin1;
@@
-182,7
+182,7
@@
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_visit` (
`date` date default NULL,
`notes` text,
`visited` enum('y','n','') default NULL,
`date` date default NULL,
`notes` text,
`visited` enum('y','n','') default NULL,
- `
visit_type` enum('presidency','hometeaching') not null default 'hometeaching
',
+ `
type` enum('P','H') not null default 'H
',
PRIMARY KEY (`visit`)
) ENGINE=MyISAM AUTO_INCREMENT=9513 DEFAULT CHARSET=latin1;
PRIMARY KEY (`visit`)
) ENGINE=MyISAM AUTO_INCREMENT=9513 DEFAULT CHARSET=latin1;