Gecko [ denebpollux.com ]

Name	Size	Permission
v15.sql	896 B	-rw-rw-rw-
v16.sql	1.89 KB	-rw-rw-rw-
v17.sql	2.67 KB	-rw-rw-rw-
v18.sql	2.05 KB	-rw-rw-rw-
v19.sql	473 B	-rw-rw-rw-
v20.sql	5.66 KB	-rw-rw-rw-
v21.sql	113 B	-rw-rw-rw-
v22.sql	113 B	-rw-rw-rw-
v23.sql	113 B	-rw-rw-rw-
v24.sql	403 B	-rw-rw-rw-
v25.sql	5.44 KB	-rw-rw-rw-
v26.sql	113 B	-rw-rw-rw-
v27.sql	16.67 KB	-rw-rw-rw-
v28.sql	704 B	-rw-rw-rw-
v29.sql	4.96 KB	-rw-rw-rw-
v30.sql	113 B	-rw-rw-rw-
v31.sql	433 B	-rw-rw-rw-
v32.sql	784 B	-rw-rw-rw-
v33.sql	1.09 KB	-rw-rw-rw-
v34.sql	269 B	-rw-rw-rw-
v35.sql	113 B	-rw-rw-rw-
v36.sql	126.6 KB	-rw-rw-rw-
v37.sql	720 B	-rw-rw-rw-
v38.sql	729 B	-rw-rw-rw-
v39.sql	1.99 KB	-rw-rw-rw-
v40.sql	2.19 KB	-rw-rw-rw-
v41.sql	2.77 KB	-rw-rw-rw-
v42.sql	540 B	-rw-rw-rw-
v43.sql	1.04 KB	-rw-rw-rw-
v44.sql	113 B	-rw-rw-rw-
v45.sql	821 B	-rw-rw-rw-
v46.sql	113 B	-rw-rw-rw-
v47.sql	113 B	-rw-rw-rw-
v48.sql	2.11 KB	-rw-rw-rw-
v49.sql	1.7 KB	-rw-rw-rw-
v50.sql	1.1 KB	-rw-rw-rw-
v51.sql	206 B	-rw-rw-rw-
v52.sql	1.61 KB	-rw-rw-rw-
v53.sql	873 B	-rw-rw-rw-
v54.sql	207 B	-rw-rw-rw-
v541.sql	113 B	-rw-rw-rw-
v542.sql	227 B	-rw-rw-rw-
v543.sql	113 B	-rw-rw-rw-
v544.sql	214 B	-rw-rw-rw-
v545.sql	385 B	-rw-rw-rw-
v55.sql	4.42 MB	-rw-rw-rw-
v551.sql	305 B	-rw-rw-rw-
v552.sql	2.25 KB	-rw-rw-rw-
v553.sql	202 B	-rw-rw-rw-
v554.sql	1.83 KB	-rw-rw-rw-
v555.sql	373 B	-rw-rw-rw-
v556.sql	293 B	-rw-rw-rw-
v557.sql	201 B	-rw-rw-rw-
v60.sql	2.09 KB	-rw-rw-rw-
v61.sql	111 B	-rw-rw-rw-
v611.sql	199 B	-rw-rw-rw-
v612.sql	723 B	-rw-rw-rw-
v613.sql	113 B	-rw-rw-rw-
v614.sql	113 B	-rw-rw-rw-
v615.sql	113 B	-rw-rw-rw-
v620.sql	3.08 KB	-rw-rw-rw-
v630.sql	24.09 KB	-rw-rw-rw-
v631.sql	604 B	-rw-rw-rw-
v632.sql	445 B	-rw-rw-rw-
v633.sql	113 B	-rw-rw-rw-
v640.sql	715 B	-rw-rw-rw-
v650.sql	229 B	-rw-rw-rw-
v700.sql	856 B	-rw-rw-rw-
v710.sql	113 B	-rw-rw-rw-
v720.sql	113 B	-rw-rw-rw-
v730.sql	180 B	-rw-rw-rw-
v740.sql	212 B	-rw-rw-rw-
v750.sql	113 B	-rw-rw-rw-
v760.sql	113 B	-rw-rw-rw-
v770.sql	113 B	-rw-rw-rw-
v780.sql	113 B	-rw-rw-rw-
v790.sql	113 B	-rw-rw-rw-
v791.sql	289 B	-rw-rw-rw-
v792.sql	300 B	-rw-rw-rw-
v793.sql	113 B	-rw-rw-rw-
v800.sql	1.48 KB	-rw-rw-rw-
v810.sql	111 B	-rw-rw-rw-
v820.sql	6.04 KB	-rw-rw-rw-
v830.sql	359 B	-rw-rw-rw-
v840.sql	783 B	-rw-rw-rw-
v850.sql	1.16 KB	-rw-rw-rw-
v860.sql	2.73 KB	-rw-rw-rw-
v870.sql	2.35 KB	-rw-rw-rw-
v880.sql	797 B	-rw-rw-rw-
v890.sql	3.01 KB	-rw-rw-rw-
v900.sql	7.4 KB	-rw-rw-rw-

Code Editor : v29.sql

INSERT INTO `business_settings` (`id`, `type`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'shipping_type', 'product_wise_shipping', current_timestamp(), current_timestamp());

INSERT INTO `business_settings` (`id`, `type`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'flat_rate_shipping_cost', '0', current_timestamp(), current_timestamp());

INSERT INTO `business_settings` (`id`, `type`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'shipping_cost_admin', '0', current_timestamp(), current_timestamp());

ALTER TABLE `shops` ADD `shipping_cost` DOUBLE(8,2) NOT NULL DEFAULT '0' AFTER `pick_up_point_id`;

ALTER TABLE `products` CHANGE `shipping_type` `shipping_type` VARCHAR(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'flat_rate';

ALTER TABLE `orders` CHANGE `delivery_viewed` `delivery_viewed` INT(1) NOT NULL DEFAULT '1';

ALTER TABLE `orders` CHANGE `payment_status_viewed` `payment_status_viewed` INT(1) NULL DEFAULT '1';

ALTER TABLE `countries` ADD `status` INT(1) NOT NULL DEFAULT '1' AFTER `name`;

ALTER TABLE `countries` ADD `created_at` TIMESTAMP NULL DEFAULT NULL AFTER `status`, ADD `updated_at` TIMESTAMP NULL DEFAULT NULL AFTER `created_at`;

UPDATE `business_settings` SET `value` = '2.9' WHERE `business_settings`.`type` = 'current_version';

-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 01, 2020 at 03:47 PM
-- Server version: 10.3.16-MariaDB
-- PHP Version: 7.3.7

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 */;

--
-- Database: `shop_demo`
--

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

--
-- Table structure for table `addresses`
--

CREATE TABLE `addresses` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `postal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `set_default` int(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `addresses`
--
ALTER TABLE `addresses`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `addresses`
--
ALTER TABLE `addresses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
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 */;

-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 01, 2020 at 03:48 PM
-- Server version: 10.3.16-MariaDB
-- PHP Version: 7.3.7

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

--
-- Database: `shop_demo`
--

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_title` text COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_description` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `keywords` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `meta_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
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 */;

${this.title}

Code Editor : v29.sql