-CREATE TABLE `tc_companionship` (
- `companionship` int(16) unsigned NOT NULL default '0',
- `individual` int(16) unsigned NOT NULL default '0',
- `district` int(16) unsigned default NULL,
- `scheduling_priority` int(16) unsigned default NULL,
- `valid` tinyint(1) default NULL,
- KEY `companionship` (`companionship`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+--
+-- Table structure for table `tc_companionship`
+--
+CREATE TABLE `phpgroupware`.`tc_companionship` (
+ `companionship` INT( 16 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+ `mls_id` INT( 16 ) UNSIGNED NULL DEFAULT NULL ,
+ `district` INT( 16 ) UNSIGNED NULL DEFAULT NULL ,
+ `valid` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1'
+) ENGINE = MYISAM ;