3 -- Host: localhost Database: phpgroupware
4 -- ------------------------------------------------------
7 -- Current Database: `phpgroupware`
10 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `phpgroupware` /*!40100 DEFAULT CHARACTER SET latin1 */;
15 -- Table structure for table `tc_activity`
17 CREATE TABLE `tc_activity` (
18 `activity` int(16) unsigned NOT NULL auto_increment,
19 `assignment` int(16) unsigned NOT NULL,
20 `date` date default NULL,
22 PRIMARY KEY (`activity`),
23 KEY `assignment` (`assignment`)
24 ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
27 -- Table structure for table `tc_appointment`
29 CREATE TABLE `tc_appointment` (
30 `appointment` int(16) unsigned NOT NULL auto_increment,
31 `presidency` int(16) unsigned NOT NULL default '0',
32 `family` int(16) unsigned default '0',
33 `individual` int(16) unsigned default '0',
34 `date` date NOT NULL default '0000-00-00',
35 `time` time NOT NULL default '00:00:00',
36 `location` varchar(120) default NULL,
37 `uid` bigint(64) unsigned NOT NULL default '0',
38 PRIMARY KEY (`appointment`)
39 ) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=latin1;
42 -- Table structure for table `tc_assignment`
44 CREATE TABLE `tc_assignment` (
45 `assignment` int(12) unsigned NOT NULL auto_increment,
46 `name` varchar(60) NOT NULL,
47 `abbreviation` varchar(12) default NULL,
48 PRIMARY KEY (`assignment`)
49 ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
52 -- Dumping data for table `tc_assignment`
54 LOCK TABLES `tc_assignment` WRITE;
55 /*!40000 ALTER TABLE `tc_assignment` DISABLE KEYS */;
56 INSERT INTO `tc_assignment` (`assignment`, `name`, `abbreviation`) VALUES (1,'Enrichment Night Babysitting','RS'),(2,'Building Lockup','LU'),(3,'Building Cleaning Coordinator','CC'),(4,'Missionary Splits','MS'),(5,'Stake Farm','SF'),(6,'Loveland Kitchen','LK'),(7,'Moves','MV'),(8,'Temple Kitchen & Laundary','TKL'),(9,'Temple Sealings','TS'),(10,'Temple Initatories','TI');
57 /*!40000 ALTER TABLE `tc_assignment` ENABLE KEYS */;
61 -- Table structure for table `tc_attendance`
63 CREATE TABLE `tc_attendance` (
64 `individual` int(16) unsigned NOT NULL default '0',
65 `date` date default NULL,
66 KEY `individual` (`individual`)
67 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
70 -- Table structure for table `tc_calling`
72 CREATE TABLE `tc_calling` (
73 `name` varchar(30) default NULL,
74 `organization` varchar(30) default NULL,
75 `position` varchar(30) default NULL,
76 `sustained` varchar(30) default NULL,
77 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
80 -- Table structure for table `tc_companionship`
83 CREATE TABLE `tc_companionship` (
84 `companionship` int(16) unsigned NOT NULL default '0',
85 `individual` int(16) unsigned NOT NULL default '0',
86 `district` int(16) unsigned default NULL,
87 `scheduling_priority` int(16) unsigned default NULL,
88 `valid` tinyint(1) default NULL,
89 KEY `companionship` (`companionship`)
90 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
93 -- Table structure for table `tc_district`
95 CREATE TABLE `tc_district` (
96 `district` int(16) unsigned NOT NULL default '0',
97 `name` varchar(30) default NULL,
98 `supervisor` int(16) unsigned default NULL,
99 `valid` tinyint(1) default NULL,
100 PRIMARY KEY (`district`)
101 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
104 -- Table structure for table `tc_individual`
106 CREATE TABLE `tc_individual` (
107 `individual` int(16) unsigned NOT NULL auto_increment,
108 `mls_id` int(16) unsigned NOT NULL,
109 `name` varchar(60) default NULL,
110 `address` varchar(255) default NULL,
111 `phone` varchar(12) default NULL,
112 `email` varchar(120) default NULL,
113 `family` int(16) unsigned default NULL,
114 `hh_position` enum('Head of Household','Spouse','Other') DEFAULT 'Other',
115 `priesthood` enum('High Priest','Elder','Priest','Teacher','Deacon','Unordained') DEFAULT NULL,
116 `steward` enum('High Priest','Elder') DEFAULT NULL,
117 `scheduling_priority` int(16) unsigned default NULL,
118 `attending` tinyint(1) default '0',
119 `valid` tinyint(1) default NULL,
120 PRIMARY KEY (`individual`)
121 ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=latin1;
124 -- Table structure for table `tc_family`
126 CREATE TABLE `tc_family` (
127 `family` int(16) unsigned NOT NULL auto_increment,
128 `hofh_id` int(16) unsigned NOT NULL default '0',
129 `name` varchar(30) NOT NULL default '',
130 `name_id` varchar(30) NOT NULL default '',
131 `individual` int(16) unsigned default '0',
132 `companionship` int(16) unsigned default NULL,
133 `scheduling_priority` int(16) unsigned default NULL,
134 `valid` tinyint(1) default NULL,
135 PRIMARY KEY (`family`)
136 ) ENGINE=MyISAM AUTO_INCREMENT=277 DEFAULT CHARSET=latin1;
139 -- Table structure for table `tc_participation`
141 CREATE TABLE `tc_participation` (
142 `individual` int(16) unsigned NOT NULL default '0',
143 `activity` int(16) unsigned default NULL,
144 UNIQUE KEY `activity_ndx` (`individual`,`activity`)
145 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
148 -- Table structure for table `tc_interview`
150 CREATE TABLE `tc_interview` (
151 `interview` int(16) unsigned NOT NULL auto_increment,
152 `interviewer` int(16) unsigned default NULL,
153 `individual` int(16) unsigned default NULL,
154 `date` date default NULL,
156 `interview_type` enum('hti','ppi') NOT NULL DEFAULT 'hti',
158 ) ENGINE=MyISAM AUTO_INCREMENT=248 DEFAULT CHARSET=latin1;
162 -- Table structure for table `tc_presidency`
164 CREATE TABLE `tc_presidency` (
165 `presidency` int(16) unsigned NOT NULL auto_increment,
166 `individual` int(16) unsigned NOT NULL default '0',
167 `district` int(16) unsigned default '0',
168 `name` varchar(60) NOT NULL,
169 `email` varchar(60) NOT NULL,
170 `president` tinyint(1) default '0',
171 `counselor` tinyint(1) default '0',
172 `secretary` tinyint(1) default '0',
173 `valid` tinyint(1) default '1',
174 KEY `presidency` (`presidency`),
175 KEY `individual` (`individual`)
176 ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
179 -- Table structure for table `tc_visit`
181 CREATE TABLE `tc_visit` (
182 `visit` int(16) unsigned NOT NULL auto_increment,
183 `family` int(16) unsigned default NULL,
184 `companionship` int(16) unsigned default NULL,
185 `companion1` int(16) unsigned default NULL,
186 `companion2` int(16) unsigned default NULL,
187 `date` date default NULL,
189 `visited` enum('y','n','') default NULL,
190 `visit_type` enum('presidency','hometeaching') not null default 'hometeaching',
191 PRIMARY KEY (`visit`)
192 ) ENGINE=MyISAM AUTO_INCREMENT=9513 DEFAULT CHARSET=latin1;
195 -- Table structure for table `tc_willingness`
197 CREATE TABLE `tc_willingness` (
198 `individual` int(16) unsigned NOT NULL,
199 `assignment` int(16) unsigned NOT NULL,
200 `willing` enum('y','n','') NOT NULL,
201 KEY `individual` (`individual`,`assignment`)
202 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
205 -- Table structure for table `tc_scheduling_priority`
207 CREATE TABLE `phpgroupware`.`tc_scheduling_priority` (
208 `scheduling_priority` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
209 `priority` INT( 10 ) UNSIGNED NOT NULL DEFAULT '30',
210 `notes` VARCHAR( 128 ) NOT NULL DEFAULT ''
214 -- Table structure for table `tc_email_list`
216 CREATE TABLE `phpgroupware`.`tc_email_list` (
217 `email_list` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
218 `name` VARCHAR( 128 ) NULL DEFAULT NULL
222 -- Table structure for table `tc_email_list_membership`
224 CREATE TABLE `phpgroupware`.`tc_email_list_membership` (
225 `individual` INT( 16 ) UNSIGNED NULL DEFAULT NULL ,
226 `email_list` INT( 16 ) UNSIGNED NULL DEFAULT NULL