DROP TABLE IF EXISTS `cscart_users`;
CREATE TABLE `cscart_users` (
  `user_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `status` char(1) NOT NULL DEFAULT 'A',
  `user_type` char(1) NOT NULL DEFAULT 'C',
  `user_login` varchar(255) NOT NULL DEFAULT '',
  `referer` varchar(255) NOT NULL DEFAULT '',
  `is_root` char(1) NOT NULL DEFAULT 'N',
  `company_id` int(11) unsigned NOT NULL DEFAULT '0',
  `last_login` int(11) unsigned NOT NULL DEFAULT '0',
  `timestamp` int(11) unsigned NOT NULL DEFAULT '0',
  `password` varchar(255) NOT NULL DEFAULT '',
  `firstname` varchar(128) NOT NULL DEFAULT '',
  `lastname` varchar(128) NOT NULL DEFAULT '',
  `company` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(128) NOT NULL DEFAULT '',
  `phone` varchar(128) NOT NULL DEFAULT '',
  `fax` varchar(128) NOT NULL DEFAULT '',
  `url` varchar(128) NOT NULL DEFAULT '',
  `tax_exempt` char(1) NOT NULL DEFAULT 'N',
  `lang_code` char(2) NOT NULL DEFAULT '',
  `birthday` int(11) NOT NULL DEFAULT '0',
  `purchase_timestamp_from` int(11) NOT NULL DEFAULT '0',
  `purchase_timestamp_to` int(11) NOT NULL DEFAULT '0',
  `responsible_email` varchar(80) NOT NULL DEFAULT '',
  `password_change_timestamp` int(11) unsigned NOT NULL DEFAULT '0',
  `salt` varchar(10) DEFAULT '',
  `api_key` varchar(255) NOT NULL DEFAULT '',
  `last_activity` int(11) unsigned NOT NULL DEFAULT '0',
  `helpdesk_user_id` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`),
  KEY `user_login` (`user_login`),
  KEY `uname` (`firstname`,`lastname`),
  KEY `idx_email` (`email`),
  KEY `idx_last_activity` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `cscart_users` (`user_id`, `status`, `user_type`, `user_login`, `referer`, `is_root`, `company_id`, `last_login`, `timestamp`, `password`, `firstname`, `lastname`, `company`, `email`, `phone`, `fax`, `url`, `tax_exempt`, `lang_code`, `birthday`, `purchase_timestamp_from`, `purchase_timestamp_to`, `responsible_email`, `password_change_timestamp`, `salt`, `api_key`, `last_activity`, `helpdesk_user_id`) VALUES
(1, 'A', 'A', 'Antar', '', 'Y', 0, 1662307141, 1327495253, '$2y$10$wHhuIxWmD0ZlAEZuwd0x4eh0If/kHltjZKqT5JZ3dvKLzzDV6AjB2', 'Cig', 'Service', 'Your company', '[email protected]', '0527955455', 'test', 'test', 'N', 'he', 0, 0, 0, '', 1648404719, '', '$2y$10$irLswU/H75I.7ghck4fCcOQq34L83Uv0ZSUP7RfZuogpMVj5.mLbm', 1662307141, 100020687),
(5, 'A', 'C', 'Dr7041', '', 'N', 1, 1521299490, 1328996851, '3c2f5ec3f260555332872b193cbd2012', 'Dror', 'golan', '', '[email protected]', '0532345616', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(2232, 'A', 'C', 'user_2232', '', 'N', 1, 1464095353, 1403176434, '84eda405b0d55f895306955fcc821c9a', 'ישראל', 'שנייד', '', '[email protected]', '0504171275', '', '', 'N', 'he', 0, 0, 0, '', 1, 'UR00>`IS.j', '', 0, 0),
(690, 'A', 'C', 'user_690', '', 'N', 1, 1351808731, 1345541450, '46f94c8de14fb36680850768ff1b7f2a', 'אייל', 'טאייברט', '', '[email protected]', '0527808667', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(8, 'A', 'C', 'lelik1976', '', 'N', 1, 1330793726, 1330764243, '692c094a03d152c6374221d5d339596d', '', 'צפון', '', '[email protected]', '0506824585', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(9, 'A', 'C', 'wolfking', '', 'N', 1, 1331278734, 1330875355, '427fcd92fd069f7089b8c1dfa4c4a981', '', '', '', '[email protected]', '0523133560', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(10, 'A', 'C', 'Udi biksa', '', 'N', 1, 0, 1331230902, 'fbac487a2862982e696834f88b5b8824', 'יהודה', 'אבקסיס', '', '[email protected]', '0578122264', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(88, 'A', 'C', 'uri2', '', 'N', 1, 1337138789, 1337119438, '671bdd9e5118d8f70d625d09a3625046', 'אוריאל', 'יונגרמן', '', '[email protected]', '0506284080', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(12, 'A', 'C', 'גלית', '', 'N', 1, 0, 1331542991, '9f7bd294b9f9656b40846a407f678342', 'galit\\dvora', 'baruch', '', '[email protected]', '0508992914', '', '', 'N', 'he', 0, 0, 0, '', 1462984990, 'keQ)Pbfc}_', '', 0, 0),
(13, 'A', 'C', 'שניר עוזיאל', '', 'N', 1, 0, 1331720403, '1533143e973f2a5b96aae8582b559aa0', 'שניר', 'עוזיאל', '', '[email protected]', '0573933666', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(14, 'A', 'C', 'aslanyehuda', '', 'N', 1, 0, 1331898071, 'f61e4592cd31d2496bf38cc9045f0c0d', 'קפה', 'לינק', '', '[email protected]', '0545656571', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(15, 'A', 'C', 'oni', '', 'N', 1, 0, 1332069761, '69cb2fc4e5b87cbfef01fe8c9334ab70', '', '', '', '[email protected]', '0503059599', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(16, 'A', 'C', 'לימור רודן', '', 'N', 1, 1638342112, 1332089322, '$2y$10$D6q59shSeGLFCoVVExR.A./Bj2Nf8sf2o/7Us4VjKK/qpTzxP6sDm', 'philip', 'roden', '', '[email protected]', '0542020377', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(17, 'A', 'C', 'סרגיי סולוביוב', '', 'N', 1, 0, 1332154094, 'c62a3f59f996e7dd5da11c4f92e55a65', 'סרגיי', 'סולוביוב', '', '[email protected]', '054-5772436', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(18, 'A', 'C', 'הייאף', '', 'N', 1, 0, 1332181451, '8df3351a3ac2b7dcb1c112b301971c60', 'היאף', 'נסראלדין', '', '[email protected]', '0527901158', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(19, 'D', 'C', '[email protected]', '', 'N', 1, 0, 1332185197, 'a03d3bcf6a8aa49c853553040da571f6', 'Michelle', 'Bushusha', '', '[email protected]', '050-9123193', '', '', 'N', 'he', 0, 0, 0, '', 1358469131, '/v7@=L,mpf', '', 1657634018, 0),
(20, 'A', 'C', 'איילה רבהון', '', 'N', 1, 1332209502, 1332208164, '29e4b0e2ff780073bde7b364f3f8575a', 'ענבל', 'רבהון', '', '[email protected]', '0523878703', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(21, 'A', 'C', 'ויק', '', 'N', 1, 0, 1332348789, 'd82b8c994f1a94ddf5746f63609020c8', 'ויק', 'אסור', '', '[email protected]', '0524011160', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(22, 'A', 'C', 'Yaniv3490', '', 'N', 1, 0, 1332492509, '0d0ceabba9ea5e15976dcd189bfe9915', 'יניב', 'שוקרון', '', '[email protected]', '0576767027', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),
(23, 'A', 'C', 'לינוי', '', 'N', 1, 0, 1332589619, 'e174932f3b8f6cc41fcefdfd5fe5f61e', 'לינוי', 'גלמן', '', '[email protected]', '0523356150', '', '', 'N', 'he', 0, 0, 0, '', 1, '', '', 0, 0),