[Libreoffice-bugs] [Bug 125283] Subform within Form now giving SQL error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125283

--- Comment #2 from Robert <rhogg4718 at hrobert17.uk> ---
Here is the sql to create the table structure as used in the Form.
--
-- Table structure for table `bank_account`
--

DROP TABLE IF EXISTS `bank_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bank_account` (
  `a_bank_id` int(10) NOT NULL AUTO_INCREMENT,
  `a_bank_account` varchar(50) DEFAULT NULL,
  `a_bank` varchar(100) DEFAULT NULL,
  `a_tax_rate` double(16,2) DEFAULT NULL,
  `a_interest_rate` double(16,4) DEFAULT NULL,
  `a_interest_rounding` int(10) NOT NULL,
  `a_interest_truncate` int(10) NOT NULL,
  `a_tax_truncate` int(10) NOT NULL,
  `a_amount_rounding` int(10) NOT NULL,
  `a_amount_truncate` int(10) NOT NULL,
  `a_basis_divisor` double(16,2) DEFAULT NULL,
  `a_long_short_term` char(1) NOT NULL,
  `a_country` varchar(10) DEFAULT NULL,
  `a_closed` varchar(1) NOT NULL,
  PRIMARY KEY (`a_bank_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transactions` (
  `t_bank_id` int(7) NOT NULL,
  `t_date` date NOT NULL,
  `t_amount` decimal(16,2) NOT NULL,
  `t_comment` varchar(100) DEFAULT NULL,
  `t_interest_rate` double(16,4) NOT NULL,
  `t_tran_type` char(1) NOT NULL,
  `t_id` int(10) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`t_id`),
  UNIQUE KEY `index1` (`t_bank_id`,`t_date`,`t_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25425 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Temporary view structure for view `v_bank_account`
--

DROP TABLE IF EXISTS `v_bank_account`;
/*!50001 DROP VIEW IF EXISTS `v_bank_account`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_bank_account` AS SELECT 
 1 AS `a_bank_id`,
 1 AS `a_bank_account`,
 1 AS `a_bank`,
 1 AS `a_tax_rate`,
 1 AS `a_interest_rate`,
 1 AS `a_interest_rounding`,
 1 AS `a_interest_truncate`,
 1 AS `a_tax_truncate`,
 1 AS `a_amount_rounding`,
 1 AS `a_amount_truncate`,
 1 AS `a_basis_divisor`,
 1 AS `a_long_short_term`,
 1 AS `a_country`,
 1 AS `b_date`,
 1 AS `b_balance`*/;
SET character_set_client = @saved_cs_client;

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190514/a182a648/attachment.html>