You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
21 lines
594 B
21 lines
594 B
2 years ago
|
#IfNotTable batchcom
|
||
|
|
##
|
||
|
|
## Table structure for table `batchcom`
|
||
|
|
##
|
||
|
|
CREATE TABLE IF NOT EXISTS `batchcom` (
|
||
|
|
`id` bigint(20) NOT NULL auto_increment,
|
||
|
|
`patient_id` int(11) NOT NULL default '0',
|
||
|
|
`sent_by` bigint(20) NOT NULL default '0',
|
||
|
|
`msg_type` varchar(60) NOT NULL default '',
|
||
|
|
`msg_subject` varchar(255) NOT NULL default '',
|
||
|
|
`msg_text` mediumtext NOT NULL,
|
||
|
|
`msg_date_sent` datetime NOT NULL default '0000-00-00 00:00:00',
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ENGINE=MyISAM ;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotColumnType billing code varchar(9)
|
||
|
|
ALTER TABLE billing
|
||
|
|
MODIFY `code` varchar(9) DEFAULT NULL;
|
||
|
|
#EndIf
|