| Server IP : 46.105.57.169 / Your IP : 216.73.216.67 Web Server : Apache System : Linux webm002.cluster120.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64 User : verseaumee ( 152031) PHP Version : 8.5.7 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/verseaumee/ptitsanes/plugins/solidres/invoice/sql/mysql/ |
Upload File : |
-- -----------------------------------------------------
-- Create table `#__sr_invoices`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `#__sr_invoices` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`invoice_date` DATETIME NULL ,
`filename` VARCHAR(255) NULL ,
`html` LONGTEXT NULL ,
`sent_on` DATETIME NULL ,
`invoice_number` INT(11) NULL ,
`created_date` DATETIME NULL ,
`created_by` INT(11) NULL ,
`modified_date` DATETIME NULL ,
`modified_by` INT(11) NULL ,
`reservation_id` INT(11) UNSIGNED NOT NULL ,
PRIMARY KEY (`id`) ,
INDEX `fk_sr_invoices_sr_reservations1_idx` (`reservation_id` ASC) ,
CONSTRAINT `fk_sr_invoices_sr_reservations1`
FOREIGN KEY (`reservation_id` )
REFERENCES `#__sr_reservations` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;