Files
BeWoPlaner/Model/Alt/_bewo alters.txt
2019-08-09 16:40:41 +02:00

31 lines
824 B
Plaintext

ALTER TABLE `Mandator`
ADD `IsSchedulerAllowed` tinyint(1) DEFAULT NULL;
ALTER TABLE `Mandator`
ADD `IsMedicationAllowed` tinyint(1) DEFAULT NULL;
ALTER TABLE `NewSchedulerAppointment`
ADD `FormerBookingSequenceOid` bigint(19) DEFAULT NULL;
ALTER TABLE `InvoiceItem`
MODIFY UnitDescription VARCHAR(256) DEFAULT NULL;
ALTER TABLE `InvoiceBase`
ADD `InvoiceTypeText` VARCHAR(256) DEFAULT NULL;
CREATE TABLE bewomobilbrowserinfo (
`Oid` bigint(19) NOT NULL AUTO_INCREMENT,
`InsTs` datetime DEFAULT NULL,
`Tenant`varchar(256),
`Type` varchar(256) DEFAULT NULL,
`Name` varchar(256) DEFAULT NULL,
`Version` varchar(256) DEFAULT NULL,
`Platform` varchar(256) DEFAULT NULL,
PRIMARY KEY (`Oid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `invoiceitem`
DROP FOREIGN KEY fk_invoiceitem_ServiceRecordOid