Spade
Mini Shell
| Directory:~$ /home/lmsyaran/www/administrator/components/com_phocainstall/ |
| [Home] [System Details] [Kill Me] |
<?xml version="1.0" encoding="utf-8"?>
<extension method="upgrade" type="component"
version="3">
<name>com_phocainstall</name>
<author>Jan Pavelka (www.phoca.cz)</author>
<creationDate>04/10/2021</creationDate>
<authorEmail></authorEmail>
<authorUrl>www.phoca.cz</authorUrl>
<copyright>Jan Pavelka</copyright>
<license>GNU/GPL</license>
<version>3.1.0</version>
<description>Phoca Install</description>
<scriptfile>install/script.php</scriptfile>
<!-- || 1 || INSTRUCTIONS - Write your instructions here -->
<pinstructions><![CDATA[<h1>Phoca Cart Demo Data</h1>
<div>This package will attempt to install demo data (images, items in
database) of <b>Phoca Cart</b> component. Be sure you have
installed latest <b>Phoca Cart</b> version (for Joomla! 3 CMS)
and there are no data yet.<br>
(Check it here: <a
href="http://www.phoca.cz/version/index.php?phocacart=test"
target="_blank">http://www.phoca.cz/version/index.php?phocacart=test</a>).</div>
<div>This package does not install country or region sample data.
Countries and Regions can be imported in component
administration.</div>]]></pinstructions>
<!-- || 1 || END INSTRUCTIONS -->
<!-- || 2 || SQL QUERY Write your SQL queries here -->
<psql><![CDATA[INSERT INTO `#__phocacart_attributes` (`id`,
`product_id`, `title`, `alias`, `required`, `type`, `published`,
`checked_out`, `checked_out_time`, `ordering`, `date`, `params`,
`language`) VALUES
(6, 5, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(7, 4, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(8, 6, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(11, 8, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(12, 9, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(23, 3, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(25, 7, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(26, 2, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(28, 1, 'Color', 'color', 0, 1, 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
'');
INSERT INTO `#__phocacart_attribute_values` (`id`, `attribute_id`, `title`,
`alias`, `amount`, `operator`, `stock`, `weight`, `operator_weight`,
`volume`, `operator_volume`, `ordering`, `language`) VALUES
(11, 6, 'Blue', 'blue', 1000, '+', 0, 0,
'+', 0, '0', 0, ''),
(12, 6, 'Grey', 'grey', 1500, '+', 0, 0,
'+', 0, '0', 0, ''),
(13, 7, 'White', 'white', 1000, '+', 0, 0,
'+', 0, '0', 0, ''),
(14, 7, 'Red', 'red', 1500, '+', 0, 0,
'+', 0, '0', 0, ''),
(15, 8, 'Blue', 'blue', 2000, '+', 0, 0,
'+', 0, '0', 0, ''),
(16, 8, 'Yellow', 'yellow', 3000, '+', 0, 0,
'+', 0, '0', 0, ''),
(21, 11, 'Blue', 'blue', 3000, '+', 0, 0,
'+', 0, '0', 0, ''),
(22, 11, 'Red', 'red', 2500, '+', 0, 0,
'+', 0, '0', 0, ''),
(23, 12, 'White', 'white', 1000, '+', 0, 0,
'+', 0, '0', 0, ''),
(24, 12, 'Blue', 'blue', 2000, '+', 0, 0,
'+', 0, '0', 0, ''),
(45, 23, 'White', 'white', 2000, '+', 0, 0,
'+', 0, '0', 0, ''),
(46, 23, 'Grey', 'grey', 1200, '+', 0, 0,
'+', 0, '0', 0, ''),
(49, 25, 'White', 'white', 1000, '+', 0, 0,
'+', 0, '0', 0, ''),
(50, 25, 'Blue', 'blue', 2000, '+', 0, 0,
'+', 0, '0', 0, ''),
(51, 26, 'White', 'white', 1500, '+', 0, 0,
'+', 0, '0', 0, ''),
(52, 26, 'Red', 'red', 20000, '+', 0, 0,
'+', 0, '0', 0, ''),
(55, 28, 'White', 'white', 1000, '+', 0, 0,
'+', 0, '0', 0, ''),
(56, 28, 'Grey', 'grey', 500, '+', 0, 0,
'+', 0, '0', 0, '');
INSERT INTO `#__phocacart_product_categories` (`product_id`, `category_id`,
`ordering`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 2, 1),
(5, 2, 2),
(6, 2, 3),
(7, 3, 1),
(8, 3, 2),
(9, 3, 3);
INSERT INTO `#__phocacart_categories` (`id`, `parent_id`, `title`, `alias`,
`image`, `description`, `published`, `checked_out`, `checked_out_time`,
`ordering`, `access`, `date`, `count`, `hits`, `params`, `metakey`,
`metadesc`, `metadata`, `language`) VALUES
(1, 0, 'Škoda', 'skoda',
'Skoda/octavia.png', '', 1, 0, '0000-00-00
00:00:00', 1, 1, '0000-00-00 00:00:00', 0, 0, '',
'', '', '', '*'),
(2, 0, 'Volkswagen', 'volkswagen',
'Volkswagen/passat-alltrack.png', '', 1, 0,
'0000-00-00 00:00:00', 2, 1, '0000-00-00 00:00:00', 0,
0, '', '', '', '', '*'),
(3, 0, 'Audi', 'audi',
'Audi/a5-coupe-facelift.png', '', 1, 0,
'0000-00-00 00:00:00', 3, 1, '0000-00-00 00:00:00', 0,
0, '', '', '', '', '*');
INSERT INTO `#__phocacart_coupons` (`id`, `title`, `alias`, `code`,
`discount`, `total_amount`, `calculation_type`, `free_shipping`,
`valid_from`, `valid_to`, `available_quantity`, `available_quantity_user`,
`description`, `published`, `checked_out`, `checked_out_time`, `ordering`,
`params`, `language`, `access`) VALUES
(1, 'Coupon', 'coupon', 'coupon', 10, 0, 1,
0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0,
'', 1, 0, '0000-00-00 00:00:00', 1, '',
'*', 1);
INSERT INTO `#__phocacart_manufacturers` (`id`, `title`, `alias`, `image`,
`description`, `published`, `checked_out`, `checked_out_time`, `ordering`,
`date`, `params`, `language`) VALUES
(1, 'Škoda', 'skoda', '', '', 1,
0, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00',
'', '*'),
(2, 'Volkswagen', 'volkswagen', '',
'', 1, 0, '0000-00-00 00:00:00', 2, '0000-00-00
00:00:00', '', '*'),
(3, 'Audi', 'audi', '', '', 1, 0,
'0000-00-00 00:00:00', 3, '0000-00-00 00:00:00',
'', '*');
INSERT INTO `#__phocacart_payment_methods` (`id`, `tax_id`, `cost`,
`operator`, `title`, `alias`, `image`, `description`, `lowest_amount`,
`highest_amount`, `active_amount`, `active_country`, `active_region`,
`active_shipping`, `method`, `access`, `published`, `checked_out`,
`checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 0, 0, '0', 'Cash On Delivery',
'cash-on-delivery', '', '', 0, 0, 0, 0, 0, 0,
'cash_on_delivery', 1, 1, 0, '0000-00-00 00:00:00', 1,
'{}', ''),
(2, 0, 0, '0', 'Paypal', 'paypal',
'', '', 0, 0, 0, 0, 0, 0, 'paypal_standard',
1, 1, 0, '0000-00-00 00:00:00', 2, '{}', '');
INSERT INTO `#__phocacart_products` (`id`, `catid`, `tax_id`,
`manufacturer_id`, `title`, `alias`, `description`, `description_long`,
`price`, `price_original`, `length`, `width`, `height`, `unit_size`,
`weight`, `unit_weight`, `volume`, `unit_volume`, `stock`, `min_quantity`,
`stockstatus_a_id`, `stockstatus_n_id`, `availability`, `sku`, `upc`,
`ean`, `jan`, `isbn`, `mpn`, `image`, `featured`, `allow_upload`,
`custom_text`, `download_token`, `download_folder`, `download_file`,
`download_hits`, `published`, `checked_out`, `checked_out_time`,
`ordering`, `access`, `date`, `hits`, `params`, `metakey`, `metadesc`,
`metadata`, `language`) VALUES
(1, 1, 1, 1, 'Škoda Octavia', 'skoda-octavia',
'', '<p>This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this
car.</p>', 39000, 42000, 4506, 1730, 1412, 0, 1270, 0, 0, 0, 0,
0, 2, 0, '', '111222333', '', '',
'', '', '',
'Skoda/Octavia/octavia.png', 0, 0, '',
'61031fd0300f963eacac488e1d9d5b9592e7834140d8b77a7b8fad6ef541f579',
'b01a2cbc8fdedc01', '', 0, 1, 0, '0000-00-00
00:00:00', 1, 1, '2014-04-18 00:00:00', 0, '',
'', '', '', '*'),
(2, 1, 1, 1, 'Škoda Rapid', 'skoda-rapid',
'', '<p>This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this
car.</p>', 36000, 35000, 4304, 1706, 1459, 0, 1260, 0, 0, 0, 0,
0, 2, 0, '', '111222444', '', '',
'', '', '',
'Skoda/Rapid/rapid-spaceback.png', 0, 0, '',
'f2e277788eeb0381f49d09cb53e24674f1c0c16df12ea680e5e8e270da43b8f1',
'813b79f11915eb26', '', 0, 1, 0, '0000-00-00
00:00:00', 0, 1, '2014-04-18 00:00:00', 0, '',
'', '', '', '*'),
(3, 1, 1, 1, 'Škoda Superb', 'skoda-superb',
'', '<p>This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this car. This is
long description of this car. This is long description of this
car.</p>', 45000, 48000, 4838, 1817, 1510, 0, 1577, 0, 0, 0, 0,
0, 2, 0, '', '111222999', '', '',
'', '', '',
'Skoda/Superb/superb-combi.png', 0, 0, '',
'0e5fe2f1313494b7a06d4f2420b3087354fbf1cf4fdc9095406d642294bb8f92',
'36fbf0ff4d686c34', '', 0, 1, 0, '0000-00-00
00:00:00', 0, 1, '2014-04-18 00:00:00', 0, '',
'', '', '', '*'),
(4, 2, 1, 2, 'Volkswagen Golf', 'volkswagen-golf',
'', '', 47000, 48000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2,
0, '', '111222777', '', '',
'', '', '',
'Volkswagen/Golf/golf-7.png', 0, 0, '',
'9ca957d22ab81a9d359827bd98ab357675c28ae9624976cac5bb42157fafbc70',
'391d2f0f66a5a39c', '', 0, 1, 0, '0000-00-00
00:00:00', 1, 1, '2014-04-18 00:00:00', 0, '',
'', '', '', '*'),
(5, 2, 1, 2, 'Volkswagen Passat', 'volkswagen-passat',
'', '', 55000, 57000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2,
0, '', '111222555', '', '',
'', '', '',
'Volkswagen/Passat/passat-alltrack.png', 0, 0, '',
'ea49e0bfae2f6042abbcf64ed2f98c3d209d4de57ed546f6f0bd54443779114a',
'436f2d4950d4627c', '', 0, 1, 0, '0000-00-00
00:00:00', 2, 1, '2014-04-18 12:26:47', 0, '',
'', '', '', '*'),
(6, 2, 1, 2, 'Volkswagen Touareg',
'volkswagen-touareg', '', '', 72000, 75000,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, '', '111222888',
'', '', '', '', '',
'Volkswagen/Touareg/touareg-edition-x.png', 0, 0, '',
'b558b044623eed52796ad5b62477131b241d929eec8c3ca46c982cef564e5b78',
'c2eeff9100660f4d', '', 0, 1, 0, '0000-00-00
00:00:00', 3, 1, '2014-04-18 12:28:22', 0, '',
'', '', '', '*'),
(7, 3, 1, 3, 'Audi A5', 'audi-a5', '',
'', 53000, 67000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0,
'', '222111333', '', '',
'', '', '',
'Audi/A5/a5-coupe-facelift.png', 0, 0, '',
'8aa787995103de4216c35dceb6dd7281c70e479257a7fd74172bacb5cdc583ec',
'12a6854c332a4ba8', '', 0, 1, 0, '0000-00-00
00:00:00', 1, 1, '2014-04-18 00:00:00', 0, '',
'', '', '', '*'),
(8, 3, 1, 3, 'Audi A8', 'audi-a8', '',
'', 97000, 99000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0,
'', '222111555', '', '',
'', '', '',
'Audi/A8/a8-facelift.png', 0, 0, '',
'252d603b5556a14bc82f19a1e62c0dc89e824a43399b659858d61dc9edf53c64',
'b9028a3d8d949f6c', '', 0, 1, 0, '0000-00-00
00:00:00', 2, 1, '2014-04-18 12:32:00', 0, '',
'', '', '', '*'),
(9, 3, 1, 3, 'Audi S3', 'audi-s3', '',
'', 83000, 85000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0,
'', '222111555', '', '',
'', '', '', 'Audi/S3/audi-s3.png',
0, 0, '',
'de02e677b05fa8427ee746ab1fdae54b226ba05245abf17b2a80c46dc14039bf',
'6ee1d8c44b07f46c', '', 0, 1, 0, '0000-00-00
00:00:00', 3, 1, '2014-04-18 12:33:33', 0, '',
'', '', '', '*');
INSERT INTO `#__phocacart_product_images` (`id`, `product_id`, `image`)
VALUES
(16, 5, 'Volkswagen/Passat/passat-alltrack.png'),
(17, 5, 'Volkswagen/Passat/cc.png'),
(18, 5, 'Volkswagen/Passat/passat-alltrackb.png'),
(19, 4, 'Volkswagen/Golf/golf-7.png'),
(20, 4, 'Volkswagen/Golf/golf-gtd.png'),
(21, 4, 'Volkswagen/Golf/golf-variant.png'),
(22, 6, 'Volkswagen/Touareg/touareg-edition-x.png'),
(23, 6, 'Volkswagen/Touareg/touareg-edition-xb.png'),
(24, 6, 'Volkswagen/Touareg/touareg-edition-xc.png'),
(31, 8, 'Audi/A8/a8-facelift.png'),
(32, 8, 'Audi/A8/a8-l-hybrid.png'),
(33, 8, 'Audi/A8/a8.png'),
(34, 9, 'Audi/S3/audi-s3.png'),
(35, 9, 'Audi/S3/audi-s3-sportback.png'),
(36, 9, 'Audi/S3/audi-s3b.png'),
(67, 3, 'Skoda/Superb/superb-combi.png'),
(68, 3, 'Skoda/Superb/superb-combib.png'),
(69, 3, 'Skoda/Superb/superb-combic.png'),
(73, 7, 'Audi/A5/a5-cabriolet-facelift.png'),
(74, 7, 'Audi/A5/a5-coupe-facelift.png'),
(75, 7, 'Audi/A5/a5-sportback-facelift.png'),
(76, 2, 'Skoda/Rapid/rapid-spaceback.png'),
(77, 2, 'Skoda/Rapid/rapid-spacebackb.png'),
(78, 2, 'Skoda/Rapid/rapid-spacebackc.png'),
(82, 1, 'Skoda/Octavia/octavia.png'),
(83, 1, 'Skoda/Octavia/octaviab.png'),
(84, 1, 'Skoda/Octavia/octavia-combi.png');
INSERT INTO `#__phocacart_product_related` (`id`, `product_a`, `product_b`)
VALUES
(11, 3, 2),
(12, 3, 1),
(15, 2, 3),
(16, 2, 1),
(19, 1, 2),
(20, 1, 3);
INSERT INTO `#__phocacart_shipping_methods` (`id`, `tax_id`, `cost`,
`title`, `alias`, `image`, `description`, `lowest_weight`,
`highest_weight`, `active_volume`, `lowest_volume`, `highest_volume`,
`active_weight`, `lowest_amount`, `highest_amount`, `active_amount`,
`active_country`, `active_region`, `published`, `checked_out`,
`checked_out_time`, `ordering`, `date`, `params`, `language`, `access`)
VALUES
(1, 1, 0, 'Standard Shipping', 'standard-shipping',
'', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0,
'0000-00-00 00:00:00', 1, '0000-00-00 00:00:00',
'', '', 1);
INSERT INTO `#__phocacart_specifications` (`id`, `product_id`, `group_id`,
`title`, `alias`, `value`, `alias_value`,`published`, `checked_out`,
`checked_out_time`, `ordering`, `date`, `params`, `language`) VALUES
(19, 3, 1, 'Engine', 'engine', '2.0 TDI CR DPF
125kW', '2-0-tdi-cr-dpf-125kw', 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(20, 3, 2, 'Type', 'type', 'Combi',
'combi', 0, 0, '0000-00-00 00:00:00', 0,
'0000-00-00 00:00:00', '', ''),
(21, 3, 3, 'Doors', 'doors', '5',
'5', 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00
00:00:00', '', ''),
(25, 2, 1, 'Engine', 'engine', '1.6 TDI
105hp', '1-6-tdi-105hp', 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(26, 2, 2, 'Type', 'type', 'Hatchback',
'Hatchback', 0, 0, '0000-00-00 00:00:00', 0,
'0000-00-00 00:00:00', '', ''),
(27, 2, 3, 'Doors', 'doors', '5',
'5', 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00
00:00:00', '', ''),
(31, 1, 1, 'Engine', 'engine', '1.9 TDI
96kW', '1-9-tdi-96kw', 0, 0, '0000-00-00
00:00:00', 0, '0000-00-00 00:00:00', '',
''),
(32, 1, 2, 'Type', 'type', 'Liftback',
'liftback', 0, 0, '0000-00-00 00:00:00', 0,
'0000-00-00 00:00:00', '', ''),
(33, 1, 3, 'Doors', 'doors', '5',
'5', 0, 0, '0000-00-00 00:00:00', 0, '0000-00-00
00:00:00', '', '');
INSERT INTO `#__phocacart_specification_groups` (`id`, `title`, `alias`,
`published`, `checked_out`, `checked_out_time`, `ordering`, `date`,
`params`, `language`) VALUES
(1, 'Engine', 'engine', 1, 0, '0000-00-00
00:00:00', 1, '0000-00-00 00:00:00', '',
'*'),
(2, 'Type', 'type', 1, 0, '0000-00-00
00:00:00', 2, '0000-00-00 00:00:00', '',
'*'),
(3, 'Doors', 'doors', 1, 0, '0000-00-00
00:00:00', 3, '0000-00-00 00:00:00', '',
'*');
INSERT INTO `#__phocacart_taxes` (`id`, `title`, `alias`, `tax_rate`,
`calculation_type`, `published`, `checked_out`, `checked_out_time`,
`ordering`, `params`, `language`) VALUES
(1, 'VAT', 'vat', 20, 1, 1, 0, '0000-00-00
00:00:00', 1, '', '');
INSERT INTO `#__phocacart_feeds` (`id`, `title`, `alias`, `description`,
`header`, `footer`, `root`, `item`, `item_params`, `feed_params`,
`published`, `checked_out`, `checked_out_time`, `ordering`, `date`, `type`,
`language`) VALUES
(1, 'Heureka', 'heureka', '', '<?xml
version="1.0" encoding="utf-8" ?>',
'', 'SHOP', 'SHOPITEM',
'{"item_id":"ITEM_ID","item_title":"PRODUCTNAME","item_title_extended":"","item_sku":"","item_EAN":"EAN","item_description_short":"DESCRIPTION","item_description_long":"","item_url":"URL","item_url_image":"IMGURL","item_url_video":"VIDEO_URL","item_manufacturer":"MANUFACTURER","item_category":"","feed_category":"CATEGORYTEXT","item_original_price_with_vat":"","item_original_price_without_vat":"","item_final_price_with_vat":"PRICE_VAT","item_final_price_without_vat":"","item_vat":"","item_currency":"","item_stock":"","item_delivery_date":"DELIVERY_DATE","feed_delivery_date":"","item_attribute":"PARAM","item_attribute_name":"PARAM_NAME","item_attribute_value":"VAL"}',
'{"export_published_only":"1","export_in_stock_only":"0","export_price_only":"1","strip_html_tags_desc":"1","display_attributes":"0","item_limit":"","item_ordering":"1","category_ordering":"0"}',
1, 0, '0000-00-00 00:00:00', 1, '0000-00-00 00:00:00',
0, '*');]]></psql>
<!-- || 2 || END SQL QUERY -->
<!-- || 3 || FILES - Write your files here (file TAG) - such files will
be copied
from "installfiles" folder to destination written
after the "installfiles" folder e.g.
FROM:
installfiles/administrator/com_phocainstall/test.txt
TO:
administrator/com_phocainstall/test.txt
Files needs to be included in ZIP package in "installfiles"
folder
Or write only a name of folder (folder TAG) - all files from this
folder will be copied, e.g.:
<folder>administrator</folder>
This folder must be included in "installfiles" folder
-->
<pfiles>
<folder>images</folder>
</pfiles>
<!-- || 3 || END FILES -->
<update>
<schemas/>
</update>
<media destination="com_phocainstall"
folder="media">
<filename>index.html</filename>
<folder>css</folder>
<folder>images</folder>
</media>
<languages>
<language tag="en-GB"
client="site">language/en-GB/en-GB.com_phocainstall.ini</language>
<language tag="en-GB"
client="site">language/en-GB/en-GB.com_phocainstall.sys.ini</language>
</languages>
<administration>
<menu
img="media/com_phocainstall/images/administrator/icon-16-pi-menu.png"
link="option=com_phocainstall">COM_PHOCAINSTALL</menu>
<files folder="admin">
<filename>config.xml</filename>
<filename>controller.php</filename>
<filename>index.html</filename>
<filename>phocainstall.php</filename>
<filename>phocainstall.xml</filename>
<folder>controllers</folder>
<folder>help</folder>
<folder>helpers</folder>
<folder>install</folder>
<folder>installfiles</folder>
<folder>views</folder>
</files>
<languages>
<language
tag="en-GB">language/en-GB/en-GB.com_phocainstall.ini</language>
<language
tag="en-GB">language/en-GB/en-GB.com_phocainstall.sys.ini</language>
</languages>
</administration>
</extension>