Demo-Daten

Diese Demo-Daten können verwendet werden, um Frontend-Formulare zu testen. Hinweis: Bitte ersetzen Sie die E-Mail-Adresse example@example.tld vorher durch ihre eigene E-Mail-Adresse. Die E-Mail-Adresse, kann hinterher auch im Backend geändert werden.

CREATE TABLE IF NOT EXISTS `ci_form` (
  `OXID` char(32) NOT NULL COMMENT 'Attachment id',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXTITLE` varchar(255) NOT NULL DEFAULT '',
  `OXCSSCLASS` varchar(255) NOT NULL DEFAULT '' COMMENT 'Frontend CSS Class',
  `OXACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Active',
  `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Active from specified date',
  `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Active to specified date',
  `OXSORT` int(5) NOT NULL DEFAULT 0 COMMENT 'Sorting',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  `OXACTION` varchar(255) NOT NULL DEFAULT '',
  `OXFIELDCONFIG` text DEFAULT NULL,
  `OXSENDFORM` varchar(255) NOT NULL DEFAULT '',
  `OXRECEIVER` varchar(255) NOT NULL DEFAULT '',
  `OXSUBJECT` varchar(255) NOT NULL DEFAULT '',
  `OXCONTENT` text DEFAULT NULL,
  `OXALIAS` varchar(255) NOT NULL DEFAULT '',
  `OXHTMLTEMPLATE` varchar(255) NOT NULL DEFAULT '',
  `OXCONFIRM` varchar(255) NOT NULL DEFAULT '',
  `OXRECEIVER_CONFIRM` varchar(255) NOT NULL DEFAULT '',
  `OXSUBJECT_CONFIRM` varchar(255) NOT NULL DEFAULT '',
  `OXCONTENT_CONFIRM` varchar(255) NOT NULL DEFAULT '',
  `APPLYFIELDS` varchar(255) NOT NULL DEFAULT '',
  `SUBMIT` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`OXID`),
  KEY `OXSORT` (`OXSORT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `ci_form` (`OXID`, `OXSHOPID`, `OXTITLE`, `OXCSSCLASS`, `OXACTIVE`, `OXACTIVEFROM`, `OXACTIVETO`, `OXSORT`, `OXTIMESTAMP`, `OXACTION`, `OXFIELDCONFIG`, `OXSENDFORM`, `OXRECEIVER`, `OXSUBJECT`, `OXCONTENT`, `OXALIAS`, `OXHTMLTEMPLATE`, `OXCONFIRM`, `OXRECEIVER_CONFIRM`, `OXSUBJECT_CONFIRM`, `OXCONTENT_CONFIRM`, `APPLYFIELDS`, `SUBMIT`) VALUES
('1283195e8e6ef2df8205b982478aa33f', 1, 'Artikel anfrage', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-11 11:40:41', 'Formular-erfolgreich-abgesendet/', '[{\"legend\":\"\",\"fields\":[\"f0fe484a825e33de0106875a6e7f05a3\",\"d28c63a3cd7853bef5d1c57ef2587c29\",\"815c89d152bc07829844acc7d8d9bc9f\",\"cabc7909e5ba9a58b322d19ca5ab5626\"]}]', '1', 'example@example.tld', 'Anfrage zu einem Artikel', 'Interessent: [{ $email }]\r\n\r\nNachricht\r\n\r\n[{ $message }]', 'artikel-anfrage', 'artikel-anfrage', '1', '', 'Dies ist eine Bestätigungs-E-Mail', 'Lorem Ipsum', '', ''),
('7cdf18f9830a5a355ed432d74a36c552', 1, 'Artikel nicht gefunden', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-01 13:25:07', 'Formular-erfolgreich-abgesendet/', '[{\"legend\":\"Adresse\",\"fields\":[\"06a6dfb826b76bcc11519b4ba2941919\",\"0cc960edb7b9095ae1dab7d3eac135bc\"]},{\"legend\":\"Kontakt\",\"fields\":[\"f0fe484a825e33de0106875a6e7f05a3\",\"cabc7909e5ba9a58b322d19ca5ab5626\"]}]', '', 'example@example.tld', 'Artikel nicht gefunden', 'Name: [{ $firstname }] [{ $lastname }]\r\n\r\nE-Mail: [{ $email }]', 'artikel-nicht-gefunden', 'artikel-nicht-gefunden', '', '', '', '', '', '');

CREATE TABLE IF NOT EXISTS `ci_form_element` (
  `OXID` char(32) NOT NULL COMMENT 'Attachment id',
  `OXSHOPID` int(11) NOT NULL DEFAULT 1 COMMENT 'Shop id (oxshops)',
  `OXTYPE` varchar(255) NOT NULL DEFAULT '',
  `OXTITLE` varchar(255) NOT NULL DEFAULT '',
  `OXVALUE` varchar(255) DEFAULT '',
  `OXCSSCLASS` varchar(255) DEFAULT '' COMMENT 'Frontend CSS Class',
  `OXACTIVE` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Active',
  `OXACTIVEFROM` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Active from specified date',
  `OXACTIVETO` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Active to specified date',
  `OXSORT` int(5) NOT NULL DEFAULT 0 COMMENT 'Sorting',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  `OXFORMID` char(32) NOT NULL COMMENT 'Parent form id',
  `OXLABEL` varchar(255) DEFAULT '',
  `OXREQUIRED` varchar(255) DEFAULT '',
  `OXVALIDATION` varchar(255) DEFAULT '',
  `OXPLACEHOLDER` varchar(255) DEFAULT '',
  `OXOPTIONS` text DEFAULT NULL COMMENT 'Options for select boxes, checkboxes and radiobuttons',
  `SUBMIT` varchar(255) NOT NULL DEFAULT '',
  `OXCONFIRMFIELD` varchar(255) DEFAULT '',
  PRIMARY KEY (`OXID`),
  KEY `OXSORT` (`OXSORT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `ci_form_element` (`OXID`, `OXSHOPID`, `OXTYPE`, `OXTITLE`, `OXVALUE`, `OXCSSCLASS`, `OXACTIVE`, `OXACTIVEFROM`, `OXACTIVETO`, `OXSORT`, `OXTIMESTAMP`, `OXFORMID`, `OXLABEL`, `OXREQUIRED`, `OXVALIDATION`, `OXPLACEHOLDER`, `OXOPTIONS`, `SUBMIT`, `OXCONFIRMFIELD`) VALUES
('06a6dfb826b76bcc11519b4ba2941919', 1, 'default', 'lastname', '', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-04 07:23:34', '', 'Nachname', '', '', '', NULL, '', ''),
('0cc960edb7b9095ae1dab7d3eac135bc', 1, 'default', 'firstname', '', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-04 07:23:38', '', 'Vorname', '', '', '', NULL, '', ''),
('38ded75cfe0373d10986ebdcfc95e2c4', 1, 'checkbox', 'categories', NULL, NULL, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-06 09:08:01', '', 'Art der Anfrage (Checkbox)', '0', '', '', '[{\"key\":\"one\",\"value\":\"Eins\"},{\"key\":\"two\",\"value\":\"Zwei\"},{\"key\":\"three\",\"value\":\"Drei\"}]', '', ''),
('815c89d152bc07829844acc7d8d9bc9f', 1, 'textarea', 'message', NULL, NULL, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-01 14:11:43', '', 'Nachricht', '0', NULL, '', NULL, '', ''),
('a19dedabe30280833b6fad288f6f0853', 1, 'default', 'street', NULL, NULL, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-02-28 13:54:30', '', 'Straße', '0', '', '', NULL, '', ''),
('cabc7909e5ba9a58b322d19ca5ab5626', 1, 'submit', 'submit', 'Absenden', 'btn btn-primary', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-05 09:07:33', '', '', '', '', '', NULL, '', ''),
('d28c63a3cd7853bef5d1c57ef2587c29', 1, 'select', 'category', NULL, NULL, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-05 13:17:44', '', 'Art der Anfrage', '1', '', '', '[{\"key\":\"interest\",\"value\":\"Ich m\\u00f6chte diesen Artikel kaufen\"},{\"key\":\"information\",\"value\":\"Ich m\\u00f6chte mehr \\u00fcber diesen Artikel erfahren\"},{\"key\":\"sonstiges\",\"value\":\"Sonstiges\"}]', '', ''),
('f0fe484a825e33de0106875a6e7f05a3', 1, 'default', 'email', '', '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, '2019-03-12 11:42:01', '', 'E-Mail', '1', 'email', '', 'null', '', '1');


CREATE TABLE IF NOT EXISTS `ci_form_element2form` (
  `OXID` char(32) NOT NULL COMMENT 'Element id',
  `OXELEMENTID` char(32) NOT NULL COMMENT 'Element id',
  `OXFORMID` char(32) NOT NULL COMMENT 'Element id',
  `OXTIMESTAMP` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Timestamp',
  `_OXTYPE` varchar(255) DEFAULT '',
  `_OXTITLE` varchar(255) DEFAULT '',
  `_OXLABEL` varchar(255) DEFAULT '',
  `_OXVALUE` varchar(255) DEFAULT '',
  `_OXREQUIRED` varchar(255) DEFAULT '',
  `_OXVALIDATION` varchar(255) DEFAULT '',
  `_OXPLACEHOLDER` varchar(255) DEFAULT '',
  `_OXOPTIONS` text DEFAULT NULL COMMENT 'Options for select boxes, checkboxes and radiobuttons',
  `_OXCONFIRMFIELD` varchar(255) DEFAULT '',
  PRIMARY KEY (`OXID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `ci_form_element2form` (`OXID`, `OXELEMENTID`, `OXFORMID`, `OXTIMESTAMP`, `_OXTYPE`, `_OXTITLE`, `_OXLABEL`, `_OXVALUE`, `_OXREQUIRED`, `_OXVALIDATION`, `_OXPLACEHOLDER`, `_OXOPTIONS`, `_OXCONFIRMFIELD`) VALUES
('472b7aa2bbc41ccc4bdd2b56bbc65bb6', 'a19dedabe30280833b6fad288f6f0853', '7cdf18f9830a5a355ed432d74a36c552', '2019-02-28 13:58:36', '', '', '', '', '', '', '', NULL, ''),
('54a70d4223dc43b5ec2f59e3928ca259', 'cabc7909e5ba9a58b322d19ca5ab5626', '7cdf18f9830a5a355ed432d74a36c552', '2019-02-28 13:36:44', '', '', '', '', '', '', '', NULL, ''),
('5698d1e9514e908af7089c36a6ac3b9c', 'd28c63a3cd7853bef5d1c57ef2587c29', '1283195e8e6ef2df8205b982478aa33f', '2019-03-05 13:17:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ''),
('6800a9add1d7daba2324c74ccbfa5917', 'f0fe484a825e33de0106875a6e7f05a3', '7cdf18f9830a5a355ed432d74a36c552', '2019-02-27 13:57:33', '', '', '', '', '', '', '', NULL, ''),
('a50bd474c288791c7ae7e0779a6494aa', 'f0fe484a825e33de0106875a6e7f05a3', '1283195e8e6ef2df8205b982478aa33f', '2019-03-06 10:16:57', '', '', '', '', '0', '', '', NULL, ''),
('aab4160aa601282c16e61feed41cf6ae', 'cabc7909e5ba9a58b322d19ca5ab5626', '1283195e8e6ef2df8205b982478aa33f', '2019-03-06 09:11:46', NULL, NULL, NULL, 'Anfrage senden', NULL, NULL, NULL, NULL, ''),
('b744300cb9ff30c72b200c15343a029d', '0cc960edb7b9095ae1dab7d3eac135bc', '7cdf18f9830a5a355ed432d74a36c552', '2019-02-27 13:45:38', '', '', '', '', '', '', '', NULL, ''),
('b74cba756587907539a15e9ebb4817ad', '815c89d152bc07829844acc7d8d9bc9f', '1283195e8e6ef2df8205b982478aa33f', '2019-03-01 14:11:57', '', '', '', '', '', '', '', NULL, ''),
('ed9a08cf4f2193dff04db5330a9f0507', '06a6dfb826b76bcc11519b4ba2941919', '7cdf18f9830a5a355ed432d74a36c552', '2019-02-27 13:45:38', '', '', '', '', '', '', '', NULL, '');
COMMIT;