ahmadtea.com
Date:~ 2020-11-20
Lines:~ 160000
Example:
Код:
CREATE TABLE `newsletter_subscriber` (
`subscriber_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Subscriber Id',
`store_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Store Id',
`change_status_at` timestamp NULL DEFAULT NULL COMMENT 'Change Status At',
`customer_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Id',
`subscriber_email` varchar(150) DEFAULT NULL COMMENT 'Subscriber Email',
`subscriber_status` int(11) NOT NULL DEFAULT 0 COMMENT 'Subscriber Status',
`subscriber_confirm_code` varchar(32) DEFAULT 'NULL' COMMENT 'Subscriber Confirm Code',
`subscriber_country` varchar(255) DEFAULT '',
`subscriber_firstname` varchar(50) DEFAULT NULL,
`subscriber_lastname` varchar(50) DEFAULT NULL,
`mailchimp_sync_delta` datetime NOT NULL,
`mailchimp_sync_error` varchar(255) NOT NULL,
`mailchimp_sync_modified` int(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`subscriber_id`),
KEY `IDX_NEWSLETTER_SUBSCRIBER_CUSTOMER_ID` (`customer_id`),
KEY `IDX_NEWSLETTER_SUBSCRIBER_STORE_ID` (`store_id`),
CONSTRAINT `FK_NEWSLETTER_SUBSCRIBER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=39582 DEFAULT CHARSET=utf8 COMMENT='Newsletter Subscriber';
INSERT INTO `newsletter_subscriber` VALUES
(9,1,NULL,0,'[email protected]',3,'d56yuxg83nuj5224ffxwgdk1kiuchuxb',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(15,1,NULL,0,'[email protected]',3,'25rljg9abad4kymq9pnkcvogixkwm3vv',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(16,1,NULL,0,'[email protected]',3,'dtk0w1h642jesan237n57uwyhyqkyvls',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(17,1,NULL,0,'[email protected]',3,'7cip34di6pep9dhx434oz3jkwmvbxufy',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(18,1,NULL,0,'[email protected]',3,'i62tzn5hr77hlnhure2pad644l2hoby1',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(19,1,NULL,0,'[email protected]',3,'r3xidqxfyfn81cehtgyh1oj93vsdc6tp',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(20,1,NULL,0,'[email protected]',3,'hwg0nlf0ih7kricfxcn9dttgnqn1ztg5',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(21,1,NULL,0,'[email protected]',3,'wbtgeyv267hqzu54rjzqbdatjt6oxltz',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(22,1,NULL,0,'[email protected]',3,'9r1dc4y46yeu1jogr2njg32q2h8gjdnt',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(23,1,NULL,0,'[email protected]',3,'jbgusvlmy29kgrjnp6pshu12uv60tn00',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(24,1,NULL,0,'[email protected]',3,'7l6jk3vna0775q4i6dug1tmg2s3rkpfv',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(25,1,NULL,0,'[email protected]',3,'m2eizyn1y9ae9x00fkjfg818wob58o6w',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(30,1,NULL,0,'[email protected]',1,'b9gx8ojzr7ki3nsw2ftdk8vvkrv8s7g7',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(31,1,NULL,0,'[email protected]',3,'294u0yc92e46w96jfnfhjm4tmtskqm0l',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(32,1,NULL,0,'[email protected]',3,'0q9r31rksbwr9voaxny7nk5j2fv0jws0',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(33,1,NULL,0,'[email protected]',3,'4608c5tsjhk31jvnh01yr1m40545w89g',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(35,1,NULL,0,'[email protected]',3,'gf53qv6axnoflcuh7r9x9qxtao9zst0c',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(36,1,NULL,0,'[email protected]',1,'zk4wedms3gvzflpbvo723xdllbcyqmmy',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(37,1,NULL,0,'[email protected]',3,'asf8bpsa7kqsyctzhduijg3d04437xu9',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(38,1,NULL,0,'[email protected]',3,'lfp2lf2wtydd6tmb04eoj3ivocw7u6lp','',NULL,NULL,'0000-00-00 00:00:00','',0),
(39,1,NULL,0,'[email protected]',3,'i8xqm4twxngxgd7bg5y11bfngvxk752k',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(43,1,NULL,0,'[email protected]',3,'6gmoo4z8ep1hfty830zz74ygkgzmm9zn',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(44,1,NULL,0,'[email protected]',3,'kr95raxpae02a9dsllciskz50egeplt4',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(46,1,NULL,0,'[email protected]',3,'4nvatcb1wd54spgeq39nwm0oebctsoox',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(47,1,NULL,0,'[email protected]',3,'yk1663qougcrkskzlotgybg50ta7u4zb',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(50,1,NULL,0,'[email protected]',3,'eehye2kxme8zbynxhos4vsdm2urjm9xr',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(52,1,NULL,0,'[email protected]',3,'h8n1wwd6iah90w4z55k9ost0i5xji2g5',NULL,NULL,NULL,'2017-11-16 10:40:13','',0),
(53,1,NULL,0,'[email protected]',1,'j9ixm20sxicykof5aflgk7qq45tb8zfw',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(54,1,NULL,0,'[email protected]',1,'cf2ybm1alqgigqkr72tm43oqtmhkidbg',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(56,1,NULL,0,'[email protected]',3,'f9ofes7fv1kcpdhzsrr6ld8ewlwhnutc',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(58,1,NULL,0,'[email protected]',3,'3g4ikiz9u9axr7yw3vqvrti8sd1rcyyf','',NULL,NULL,'0000-00-00 00:00:00','',0),
(59,1,NULL,0,'[email protected]',3,'prj5lwnmi7gr2dscopxcax7dbedibwo6',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(60,1,NULL,0,'[email protected]',3,'7jfuh2e205q8yat095zo6sxlg26svefo','',NULL,NULL,'0000-00-00 00:00:00','',0),
(62,1,NULL,0,'[email protected]',3,'x5on22dpunzc7bxd42etq4oi6e9f4jvv',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(64,1,NULL,40292,'[email protected]',3,'yg3g9pajsqvay047kcvqbrcj18gmk1jf','Select',NULL,NULL,'2017-11-16 10:40:14','',0),
(65,1,NULL,0,'[email protected]',3,'2a58glwel6o2gdc5n3wmus232on1cwgk',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(67,1,NULL,0,'[email protected]',3,'op19arye1qgej9xkwyiw8nsxsfizpc8e',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(68,1,NULL,0,'[email protected]',3,'bzm3l8ur2xqegci2owixgpfy5wg5b0si',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(70,1,NULL,0,'[email protected]',3,'462skj9zrxu9etwkv100172gs8fffj20',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(71,1,NULL,0,'[email protected]',3,'pfx7w8xghk1awyev0pol4lak6n8vvpsx',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(72,1,NULL,0,'[email protected]',1,'3l6ka8lldkgvks5hvq8seammj6iqaas5',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(73,1,NULL,802,'[email protected]',3,'exi148tapdop9rhrljfl725chxq48pvr',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(75,1,NULL,0,'[email protected]',1,'harmkj23nckoib1x5paoh431vt7g9g2n',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(76,1,NULL,0,'[email protected]',3,'k8mdp0jgh4k51b2gllwwl6lz0ykeavlm',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(77,1,NULL,0,'[email protected]',3,'jhto51mks3au4x5vbck3a2qai0gigq1f',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(78,1,NULL,0,'[email protected]',1,'rmyn6gon98r9nw6brqr51somtsyl0c67',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(79,1,NULL,0,'[email protected]',1,'bk7apl0efbuk1otzfmmcufbounah16tl',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(80,1,NULL,0,'[email protected]',1,'z5jyzm9i17kgltf6eo65v2cqqssl4ynb',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(81,1,NULL,0,'[email protected]',3,'v41mqkrocsi2bat4vfm093sljta3uf4c',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(82,1,NULL,0,'[email protected]',3,'34qc6bedonlubt7k3l75dj2lmdf8rjvo',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(83,1,NULL,0,'[email protected]',3,'41hkj9zsz6u5naqg9r8h0q3g4hg0bt62',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(84,1,NULL,0,'[email protected]',3,'gg26muca1ojcy743pnb9gpv6oap1zes2',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(85,1,NULL,0,'[email protected]',3,'6tuymx40ajrtqdw0cxycfmjfjzdye5ro',NULL,NULL,NULL,'2017-11-16 10:40:14','',0),
(86,1,NULL,0,'[email protected]',3,'9vlybl6udsarui35s5727r8vy6g0vdmj',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(87,1,NULL,0,'[email protected]',3,'276oj7shk754tjxrztzkghjfvem0ww1g',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(88,1,NULL,0,'[email protected]',3,'dsp53v7gh8gmcav8v02x1throqhqqyh8',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(90,1,NULL,0,'[email protected]',1,'wcrm741yoye0f59as3zyjldn7ku4fwqy',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(91,1,NULL,0,'[email protected]',3,'77yc5assblpaefiw22hqi1oemlwkrm9w',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(92,1,NULL,0,'[email protected]',3,'7a8meoljc0aqi468uqkcjdxikn0s7noy',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(94,1,NULL,0,'[email protected]',3,'m2nwj8whh4x10kbpqniurxlzigq0o81r',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(95,0,NULL,0,NULL,3,'NULL','',NULL,NULL,'0000-00-00 00:00:00','',0),
(97,1,NULL,0,'[email protected]',3,'4opqqmj1c31mfog96pcjwwhacces8ngi',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(99,1,NULL,0,'[email protected]',3,'6omlxhfej6ec04gcgeut9xraex8gce64',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
(100,1,NULL,0,'[email protected]',3,'00fw0lz25zatepbhysqywqpryziuqe9k',NULL,NULL,NULL,'2017-11-16 10:45:05','',0),
