Lrandom

Lrandom supports this item

Supported

This author's response time can be up to 2 business days.

Popular questions for this item

Sql update

—Table structure for languages DROP TABLE IF EXISTS `languages`; CREATE TABLE `languages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `activated` tinyint(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `posts`; CREATE TABLE `posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `content` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `activated` tinyint(4) DEFAULT ‘0’, `cat_id` varchar(200) DEFAULT NULL, `description` varchar(1000) DEFAULT NULL, `keyword` varchar(255) DEFAULT NULL, `avt` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `pined` tinyint(4) DEFAULT ‘0’, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `post_cats`; CREATE TABLE `post_cats` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `parent_id` bigint(20) DEFAULT NULL, `activated` tinyint(4) DEFAULT ‘0’, `order` tinyint(4) DEFAULT ‘0’, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `partner`; CREATE TABLE `partner` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `activated` tinyint(4) DEFAULT ‘0’, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `top_slider`; CREATE TABLE `top_slider` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `updated_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `link` varchar(255) DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `activated` tinyint(4) DEFAULT ‘0’, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `banners`; CREATE TABLE `banners` ( `id` int(11) NOT NULL AUTO_INCREMENT, `position` tinyint(4) DEFAULT NULL, `activated` tinyint(4) DEFAULT ‘0’, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `link` varchar(255) DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE types ADD COLUMN `parent_id` bigint, ADD COLUMN `order` tinyint, ADD COLUMN `type` tinyint, ADD COLUMN `activated` tinyint

ALTER TABLE estates ADD COLUMN `link_youtube` varchar(255) COLLATE utf8_unicode_ci, ADD COLUMN `parent_id` int;

UPDATE estates SET time_rate=-1 WHERE time_rate=null;

Contact the author

This author provides limited support for this item through email contact form.

Item support includes:

  • Availability of the author to answer questions
  • Answering technical questions about item’s features
  • Assistance with reported bugs and issues
  • Help with included 3rd party assets

However, item support does not include:

  • Customization services
  • Installation services

View the item support policy

by
by
by
by
by
by