-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Erstellungszeit: 14. Sep 2023 um 10:42
-- Server-Version: 10.4.8-MariaDB
-- PHP-Version: 7.3.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Datenbank: `test`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `pdf_canvas_meta`
--

CREATE TABLE `pdf_canvas_meta` (
  `id` int(11) NOT NULL,
  `creacion` timestamp NOT NULL DEFAULT current_timestamp(),
  `ultmodif` timestamp NULL DEFAULT current_timestamp(),
  `proyecto` varchar(20) NOT NULL,
  `meta` varchar(50) DEFAULT NULL,
  `valor` varchar(20) DEFAULT NULL,
  `attr` varchar(20) DEFAULT NULL,
  `cantidad` varchar(20) DEFAULT NULL,
  `precio` varchar(20) DEFAULT NULL,
  `takeoff` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Daten für Tabelle `pdf_canvas_meta`
--

INSERT INTO `pdf_canvas_meta` (`id`, `creacion`, `ultmodif`, `proyecto`, `meta`, `valor`, `attr`, `cantidad`, `precio`, `takeoff`) VALUES
(5, '2023-09-14 08:32:57', '2023-09-14 08:32:57', '666', 'takeoff', '2', NULL, NULL, NULL, '{\"version\":\"5.2.1\",\"objects\":[{\"type\":\"image\",\"version\":\"5.2.1\",\"originX\":\"left\",\"originY\":\"top\",\"left\":0,\"top\":0,\"width\":1654,\"height\":2339,\"fill\":\"rgb(0,0,0)\",\"stroke\":null,\"strokeWidth\":0,\"strokeDashArray\":null,\"strokeLineCap\":\"butt\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"miter\",\"strokeUniform\":false,\"strokeMiterLimit\":4,\"scaleX\":1,\"scaleY\":1,\"angle\":0,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":null,\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"cropX\":0,\"cropY\":0,\"src\":\"http://localhost/takeoff/multimedia/pdf-2.jpg\",\"crossOrigin\":null,\"filters\":[]},{\"type\":\"circle\",\"version\":\"5.2.1\",\"originX\":\"left\",\"originY\":\"top\",\"left\":172.32,\"top\":410.9,\"width\":30,\"height\":30,\"fill\":\"#ff9900\",\"stroke\":null,\"strokeWidth\":1,\"strokeDashArray\":null,\"strokeLineCap\":\"butt\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"miter\",\"strokeUniform\":false,\"strokeMiterLimit\":4,\"scaleX\":15.67,\"scaleY\":15.67,\"angle\":0,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":null,\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"radius\":15,\"startAngle\":0,\"endAngle\":360,\"title\":\"orange\",\"note\":\"circ\"}]}'),
(6, '2023-09-14 08:33:38', '2023-09-14 08:33:38', '666', 'takeoff', '1', NULL, NULL, NULL, '{\"version\":\"5.2.1\",\"objects\":[{\"type\":\"image\",\"version\":\"5.2.1\",\"originX\":\"left\",\"originY\":\"top\",\"left\":0,\"top\":0,\"width\":1700,\"height\":2200,\"fill\":\"rgb(0,0,0)\",\"stroke\":null,\"strokeWidth\":0,\"strokeDashArray\":null,\"strokeLineCap\":\"butt\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"miter\",\"strokeUniform\":false,\"strokeMiterLimit\":4,\"scaleX\":1,\"scaleY\":1,\"angle\":0,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":null,\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"cropX\":0,\"cropY\":0,\"src\":\"http://localhost/takeoff/multimedia/pdf-1.jpg\",\"crossOrigin\":null,\"filters\":[]},{\"type\":\"image\",\"version\":\"5.2.1\",\"originX\":\"left\",\"originY\":\"top\",\"left\":0,\"top\":0,\"width\":1700,\"height\":2200,\"fill\":\"rgb(0,0,0)\",\"stroke\":null,\"strokeWidth\":0,\"strokeDashArray\":null,\"strokeLineCap\":\"butt\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"miter\",\"strokeUniform\":false,\"strokeMiterLimit\":4,\"scaleX\":1,\"scaleY\":1,\"angle\":0,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":null,\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"cropX\":0,\"cropY\":0,\"src\":\"http://localhost/takeoff/multimedia/pdf-1.jpg\",\"crossOrigin\":null,\"filters\":[]},{\"type\":\"rect\",\"version\":\"5.2.1\",\"originX\":\"left\",\"originY\":\"top\",\"left\":86.43,\"top\":634.85,\"width\":30,\"height\":30,\"fill\":\"#000000\",\"stroke\":null,\"strokeWidth\":1,\"strokeDashArray\":null,\"strokeLineCap\":\"butt\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"miter\",\"strokeUniform\":false,\"strokeMiterLimit\":4,\"scaleX\":16.55,\"scaleY\":16.55,\"angle\":0,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":null,\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"rx\":0,\"ry\":0,\"title\":\"primero\",\"note\":\"negro\"},{\"type\":\"triangle\",\"version\":\"5.2.1\",\"originX\":\"left\",\"originY\":\"top\",\"left\":279.76,\"top\":806.16,\"width\":30,\"height\":30,\"fill\":\"#ff0000\",\"stroke\":null,\"strokeWidth\":1,\"strokeDashArray\":null,\"strokeLineCap\":\"butt\",\"strokeDashOffset\":0,\"strokeLineJoin\":\"miter\",\"strokeUniform\":false,\"strokeMiterLimit\":4,\"scaleX\":17.65,\"scaleY\":33.14,\"angle\":248.35,\"flipX\":false,\"flipY\":false,\"opacity\":1,\"shadow\":null,\"visible\":true,\"backgroundColor\":\"\",\"fillRule\":\"nonzero\",\"paintFirst\":\"fill\",\"globalCompositeOperation\":\"source-over\",\"skewX\":0,\"skewY\":0,\"title\":\"\",\"note\":\"\"}]}');

--
-- Indizes der exportierten Tabellen
--

--
-- Indizes für die Tabelle `pdf_canvas_meta`
--
ALTER TABLE `pdf_canvas_meta`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT für exportierte Tabellen
--

--
-- AUTO_INCREMENT für Tabelle `pdf_canvas_meta`
--
ALTER TABLE `pdf_canvas_meta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
