Customer or customer group specific items

How to configure and adapt Aimeos based shops as developer
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Post Reply
clearmedia
Posts: 8
Joined: 17 Aug 2018, 09:18

Re: Customer or customer group specific items

Post by clearmedia » 05 Sep 2018, 14:16

nos3 wrote:Regarding the infinitive loop, can you post a dump of your users, users_list and mshop_customer_group tables (structure and data) nevertheless? Because we are unable to reproduce the problem.

Code: Select all

# ************************************************************
# Sequel Pro SQL dump
# Version 4541
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 127.0.0.1 (MySQL 5.6.38)
# Database: ceod
# Generation Time: 2018-09-05 14:12:03 +0000
# ************************************************************


/*!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 utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table mshop_customer_group
# ------------------------------------------------------------

DROP TABLE IF EXISTS `mshop_customer_group`;

CREATE TABLE `mshop_customer_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `siteid` int(11) DEFAULT NULL,
  `code` varchar(32) CHARACTER SET utf8 NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 NOT NULL,
  `mtime` datetime NOT NULL,
  `ctime` datetime NOT NULL,
  `editor` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unq_mscusgr_sid_code` (`siteid`,`code`),
  KEY `idx_mscusgr_sid_label` (`siteid`,`label`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

LOCK TABLES `mshop_customer_group` WRITE;
/*!40000 ALTER TABLE `mshop_customer_group` DISABLE KEYS */;

INSERT INTO `mshop_customer_group` (`id`, `siteid`, `code`, `label`, `mtime`, `ctime`, `editor`)
VALUES
	(1,1,'admin','Administrator','2018-06-25 04:34:39','2018-06-25 04:34:39','core:setup'),
	(2,1,'customer','Customer','2018-08-16 12:40:38','2018-06-25 04:34:39','ivancik@studiotem.com');

/*!40000 ALTER TABLE `mshop_customer_group` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `email` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `password` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `remember_token` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `superuser` smallint(6) DEFAULT '0',
  `siteid` int(11) DEFAULT NULL,
  `label` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `salutation` varchar(8) CHARACTER SET utf8 DEFAULT '',
  `company` varchar(100) CHARACTER SET utf8 DEFAULT '',
  `coc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `vatid` varchar(32) CHARACTER SET utf8 DEFAULT '',
  `taxid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(64) CHARACTER SET utf8 DEFAULT '',
  `firstname` varchar(64) CHARACTER SET utf8 DEFAULT '',
  `lastname` varchar(64) CHARACTER SET utf8 DEFAULT '',
  `address1` varchar(200) CHARACTER SET utf8 DEFAULT '',
  `address2` varchar(200) CHARACTER SET utf8 DEFAULT '',
  `address3` varchar(200) CHARACTER SET utf8 DEFAULT '',
  `postal` varchar(16) CHARACTER SET utf8 DEFAULT '',
  `city` varchar(200) CHARACTER SET utf8 DEFAULT '',
  `state` varchar(200) CHARACTER SET utf8 DEFAULT '',
  `langid` varchar(5) CHARACTER SET utf8 DEFAULT NULL,
  `countryid` char(2) CHARACTER SET utf8 DEFAULT NULL,
  `telephone` varchar(32) CHARACTER SET utf8 DEFAULT '',
  `telefax` varchar(32) CHARACTER SET utf8 DEFAULT '',
  `website` varchar(255) CHARACTER SET utf8 DEFAULT '',
  `longitude` decimal(8,6) DEFAULT NULL,
  `latitude` decimal(8,6) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `vdate` date DEFAULT NULL,
  `status` smallint(6) NOT NULL DEFAULT '1',
  `editor` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `pcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `idx_lvusr_langid` (`langid`),
  KEY `idx_lvusr_last_first` (`lastname`,`firstname`),
  KEY `idx_lvusr_post_addr1` (`postal`,`address1`),
  KEY `idx_lvusr_post_city` (`postal`,`city`),
  KEY `idx_lvusr_lastname` (`lastname`),
  KEY `idx_lvusr_address1` (`address1`),
  KEY `idx_lvusr_city` (`city`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;

INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `superuser`, `siteid`, `label`, `salutation`, `company`, `coc`, `vatid`, `taxid`, `title`, `firstname`, `lastname`, `address1`, `address2`, `address3`, `postal`, `city`, `state`, `langid`, `countryid`, `telephone`, `telefax`, `website`, `longitude`, `latitude`, `birthday`, `vdate`, `status`, `editor`, `pcode`)
VALUES
	(3267,'ivancik@studiotem.com','ivancik@studiotem.com','$2y$10$q3/IJECE4xcuSz.Fb94lFevsB8BYubZbwjlGBWRM9fyCoKe40Op76','UTYz1WgZyS3ZhvXObgaTolscaFeZSQSCgVGOX9cUsON95U4VLvbTuc3uyOvD',NULL,'0000-00-00 00:00:00',1,1,' test','mr','','','','','','test','test','test','','','94912','test','','sk','SK','','','',NULL,NULL,NULL,NULL,1,'ivancik@studiotem.com','');

/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users_list
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users_list`;

CREATE TABLE `users_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `typeid` int(11) NOT NULL,
  `parentid` int(11) NOT NULL,
  `siteid` int(11) NOT NULL,
  `domain` varchar(32) CHARACTER SET utf8 NOT NULL,
  `refid` varchar(32) CHARACTER SET utf8 NOT NULL,
  `start` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `config` text CHARACTER SET utf8 NOT NULL,
  `pos` int(11) NOT NULL,
  `status` smallint(6) NOT NULL,
  `mtime` datetime NOT NULL,
  `ctime` datetime NOT NULL,
  `editor` varchar(255) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unq_lvuli_sid_dm_rid_tid_pid` (`siteid`,`domain`,`refid`,`typeid`,`parentid`),
  KEY `idx_lvuli_sid_stat_start_end` (`siteid`,`status`,`start`,`end`),
  KEY `idx_lvuli_pid_sid_rid_dom_tid` (`parentid`,`siteid`,`refid`,`domain`,`typeid`),
  KEY `idx_lvuli_pid_sid_start` (`parentid`,`siteid`,`start`),
  KEY `idx_lvuli_pid_sid_end` (`parentid`,`siteid`,`end`),
  KEY `idx_lvuli_pid_sid_pos` (`parentid`,`siteid`,`pos`),
  KEY `IDX_8B41B616E70B032` (`typeid`),
  KEY `IDX_8B41B616856A684C` (`parentid`),
  CONSTRAINT `fk_lvuli_pid` FOREIGN KEY (`parentid`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_lvuli_typeid` FOREIGN KEY (`typeid`) REFERENCES `users_list_type` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!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 */;
Top
Post Reply

Return to “Help”