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 3d287e52ee948d1f5eadd9b1d033772ae669abde..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;
@@
-263,6
+263,7
@@
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companion_sandbox` (
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship_sandbox` (
`companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
--
CREATE TABLE /*!42501 IF NOT EXISTS*/ `tc_companionship_sandbox` (
`companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+ `tc_companionship` INT( 16 ) UNSIGNED NOT NULL ,
`district` INT( 16 ) UNSIGNED NULL DEFAULT NULL
) ENGINE = MYISAM ;
`district` INT( 16 ) UNSIGNED NULL DEFAULT NULL
) ENGINE = MYISAM ;