CREATE TABLE `user_card` (
`i_user_card_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`i_user_id` int(10) unsigned NOT NULL,
`s_sessionguid` varchar(50) NOT NULL,
`b_fullcapture` enum('1','0') NOT NULL DEFAULT '1',
`i_mkcardschemeid` int(10) NOT NULL,
`s_schemename` varchar(50) NOT NULL,
`i_issuenolength` int(10) NOT NULL DEFAULT '0',
`b_startdaterequired` enum('1','0') NOT NULL DEFAULT '0',
`i_csclength` int(10) NOT NULL,
`b_allowpayerauth` enum('1','0') NOT NULL DEFAULT '0',
`i_cpcoption` int(10) DEFAULT NULL,
`s_cpcidentificationmask` varchar(20) DEFAULT NULL,
`s_panstar` varchar(20) NOT NULL,
`s_cardnumberhash` varchar(64) NOT NULL,
`s_expirydate` varchar(4) NOT NULL,
`s_startdate` varchar(4) DEFAULT NULL,
`i_issueno` int(2) DEFAULT NULL,
`s_address1` varchar(250) DEFAULT NULL,
`s_address2` varchar(250) DEFAULT NULL,
`s_town` varchar(100) DEFAULT NULL,
`s_county` varchar(100) DEFAULT NULL,
`s_postcode` varchar(15) DEFAULT NULL,
`s_country` varchar(100) DEFAULT NULL,
`s_cardholdername` varchar(200) DEFAULT NULL,
`s_errorcode` varchar(10) DEFAULT NULL,
`s_errordescription` text,
`s_tokenid` text,
`dt_token_expiration_date` date DEFAULT NULL,
PRIMARY KEY (`i_user_card_id`),
KEY `FK_user_card_user` (`i_user_id`),
KEY `Index 3` (`s_cardnumberhash`),
CONSTRAINT `FK_user_card_user` FOREIGN KEY (`i_user_id`) REFERENCES `user` (`i_user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1540704 DEFAULT CHARSET=utf8;
/*!40000 ALTER TABLE `user_card` DISABLE KEYS */;
INSERT INTO `user_card` VALUES ('3','537703','BD9F3845-D992-4BE9-BB26-B44649C494C0','1','6','Visa Debit','0','0','3','1','0','%','453978******0126','PoguGOpSAQioJGF5gHudZNreWpCLNVVBZ6a93ahN7PQ=','1015',NULL,NULL,'13 waverley rd',NULL,NULL,NULL,'gl2 0sz',NULL,'mr a curtis','0',NULL,'2109378301',NULL),('23','349583','41EDA4BB-956F-4A4B-8E76-793D3ABF513C','1','6','Visa Debit','0','0','3','1','0','%','475714******8405','f85g510hvzNL1YFLEPrw9v82MWFqoZPWs62mhcqzOmQ=','0314',NULL,NULL,'9c Malvern Road',NULL,NULL,NULL,'E8 3LT',NULL,'Miss Z E Brown','0',NULL,'2097757402',NULL),('33','538153','7D9B51DC-C7E2-4FA2-B35C-13A1C3FD0249','1','6','Visa Debit','0','0','3','1','0','%','465858******2112','p2qP/0FDD8MV953pMdCjMOM8hd4uCWYuqASZ44TsiCc=','0615',NULL,NULL,'13 Waverley Road',NULL,NULL,NULL,'GL2 0SZ',NULL,'martyna grabian','0',NULL,'2097797902',NULL),('53','530173','9ECE6651-6157-4AC4-B70C-B720F5FC9C05','1','6','Visa Debit','0','0','3','1','0','%','475130******7910','oSkL1NtlHqzYYAB/u9qWo7D28Ezox28lGrHRJLdmwUY=','1115',NULL,NULL,'29 chartley avenue',NULL,'Stanmore','Middlesex','Ha7 3ra',NULL,'I biroli','0',NULL,'2097858102',NULL),('63','1061033','294D0D4E-46EF-4AE6-A476-6C3FEF4495C0','1','6','Visa Debit','0','0','3','1','0','%','454742******0538','0q/dKdPZ1kU4fPDOaJiZD8SjSJGGEg6GrXAPIfq4NtI=','0215',NULL,NULL,'37 bramber ave',NULL,'Peacehaven','East Sussex','bn10 8hr',NULL,'katie Sanders','0',NULL,'2097871502',NULL),('83','547393','CAB987D0-D27F-4D76-A55F-7C6F4E5B3C0E','1','6','Visa Debit','0','0','3','1','0','%','454742******0926','QYsnWHdo7Zak4pFIqMZJwKV6yP42TKZ1NUhP+5HZBec=','0815',NULL,NULL,'17 Kendal Close Leeds',NULL,'Leeds','West Yorkshire','ls3 1nt',NULL,'Mr L O Elliott','0',NULL,'2109674501',NULL),('93','538233','AB81F8FC-E076-4BF3-9450-A7A6C8AF66F4','1','6','Visa Debit','0','0','3','1','0','%','446278******9347','bLGb4HeWHBLSbTTosYyXbS1U9HT+ugmgd4fIYRSUE1U=','1113',NULL,NULL,'15 Baranscraig',NULL,NULL,NULL,'Bn18rf',NULL,'Mr a p kish','0',NULL,'2109696701',NULL),('103','538233','598BA002-A04C-4892-B35E-E5935F690C39','1','6','Visa Debit','0','0','3','1','0','%','454313******6429','vinlqrNAoTUxW0BOQcnaGLQ+jza6V19xSk96TPf/YYw=','0216',NULL,NULL,'Flat 6, 23 oriental place, brighton',NULL,NULL,NULL,'Bn1 2ll',NULL,'Miss L G Isaacs','0',NULL,'2109745501',NULL),('123','351183','CD8963B5-36B3-4DFC-B9D1-15DC6FD80896','1','6','Visa Debit','0','0','3','1','0','%','465858******9006','8iDpnwUBfpl7Izm8G5rb14yeDc5ZZ3r8RZtq9EmiCpY=','0615',NULL,NULL,'18a Electric Parade',NULL,NULL,NULL,'E18 2LY',NULL,'R Nioi','0',NULL,'2098102802',NULL),('133','538303','8BDF4A8E-50FF-47B5-9282-94E16E8A2D63','1','6','Visa Debit','0','0','3','1','0','%','475129******7327','R0p2STC3xYKWnVOl2n/Qxo1h/CyFlKJaYwkyP9tX7SE=','0913',NULL,NULL,'6 Ryefield avenue, Clayton, Bradford',NULL,NULL,NULL,'BD14 6BJ',NULL,'Miss Eloise L Carrick','0',NULL,'2110040401',NULL),('143','538353','6B0F71B7-2545-4C50-A55C-DF9306168D3A','1','6','Visa Debit','0','0','3','1','0','%','446291******9711','hOKra7KRWM1WD9OWZYkwafkGpxwLlmvePB8FLrEQz9s=','0815',NULL,NULL,'10 Wensleydale Close',NULL,NULL,NULL,'SN5 5SP',NULL,'Miss Keziah C Farthing','0',NULL,'2110095101',NULL),('163','308533','D9261FAB-73B5-4AA2-A1EA-2A1D90E680A6','1','6','Visa Debit','0','0','3','1','0','%','446272******6610','pI4h70TEYrBJzIFkk20DdhyRse810998zg0Mf7f5RYQ=','0116',NULL,NULL,'6 elsenham hall, bishops stortford herst',NULL,NULL,NULL,'cm22 6dp',NULL,'peter layzell','0',NULL,'2110145001',NULL),('183','538383','A5EA645F-55EF-4A24-8911-AEFD498AEABC','1','6','Visa Debit','0','0','3','1','0','%','465943******1915','bR/HbzGKtCh5UGmyYgFSP10BJ7i3AOEv45KtiucGTI0=','0716',NULL,NULL,'Flat 1 Sentinel House','Sentinel Square','London ',NULL,'NW4 2EN',NULL,'G I Goldstein','0',NULL,'2098520102',NULL),('193','505423','E80ADA84-4791-4E70-B633-1FFFEC989E33','1','6','Visa Debit','0','0','3','1','0','%','446291******8716','Mpe7MEx6R4o/Q6duNxQf27gDROkMZELCvx77qPEpq14=','1115',NULL,NULL,'115 rykneld rd',NULL,NULL,NULL,'De234aj',NULL,'J t perry','0',NULL,'2098602902',NULL),('203','538413','B3B4BB7F-2D11-41A9-A964-29F94C7F5802','1','6','Visa Debit','0','0','3','1','0','%','465859******7111','oAbX/DgD3UCaezaLuMG8vMPbFsx84WVMC62y4bSG83M=','0216',NULL,NULL,'128 Bristol Road',NULL,NULL,NULL,'B5 7XH',NULL,'mrs n n sultan','0',NULL,'2110549501',NULL),('213','264043','C9C9A644-A9A7-402C-81DC-E1C4F702C6D9','1','6','Visa Debit','0','0','3','1','0','%','475128******9701','mPumkNGYTn7GUGC8xpWffYgVGvw5+E/cr+aXrxYLKyw=','0915',NULL,NULL,'25 watney road',NULL,NULL,NULL,'sw147ra',NULL,'charlotte s keay','0',NULL,'2110576501',NULL),('223','533073','5155B486-F8DE-4E30-B12F-95D14E1B75D1','1','6','Visa Debit','0','0','3','1','0','%','475128******7672','IH4l7uXHZWq0lhD7cjidD2MNOWhUIGEdlFWFVWS0JYI=','0915',NULL,NULL,'23 alexandra road ',NULL,NULL,NULL,'sw14 8dl',NULL,'miss laura tingley','0',NULL,'2098653502',NULL),('233','538443','52FA7A60-056F-40EC-9D65-D5C6E8831C0E','1','2','Visa','0','0','3','1','0','%','492942******9003','F80pbhwlMggNCVbv/FKmm1SIhHKgJ9nyovahFmWe8ZQ=','0516',NULL,NULL,'62 Ivy Drive',NULL,NULL,NULL,'GU18 5YT',NULL,'R KNIGHTS','0',NULL,'2098660002',NULL),('253','538473','8911DD7B-1903-4725-8FB6-7A344E568EEB','1','6','Visa Debit','0','0','3','1','0','%','465858******5102','WBG3jS+7T7RYu1dHsNUyHL11ZEV1Rz/mRZJ1M7SPyfE=','1015',NULL,NULL,'39 Kingfisher Street ',NULL,NULL,NULL,'E6 5JZ',NULL,'Z Uselyte','0',NULL,'2110635001',NULL),('263','375573','92418262-9D94-4EB0-9F6C-9997252F8A4B','1','6','Visa Debit','0','0','3','1','0','%','476230******5912','gmWR1IkH2ByBr2oVNCBYZ1IYTvBW7r5b/B6EJy+W0do=','1013',NULL,NULL,'14 hoyland close',NULL,NULL,NULL,'m12 5ew',NULL,'Miss V E Copeland ','0',NULL,'2110679301',NULL),('273','413343','6621AB3A-DA88-4DA1-A1B3-12A81D318506','1','6','Visa Debit','0','0','3','1','0','%','465942******1832','ZOhmcm64RBo2JYyThMDhleYVbas2njoCYPgoYKhE3n0=','1015',NULL,NULL,'6 Crofters Close',NULL,NULL,NULL,'NN4 0BJ',NULL,'Miss K Norman','0',NULL,'2110754501',NULL),('283','538503','A1F8D432-B958-4BE2-A0B6-CF65B9AF31D8','1','6','Visa Debit','0','0','3','1','0','%','446291******2311','hTiOllUPec+iFF9AmPzbGdvhvaK3chq/U3G6PfGFulE=','1115',NULL,NULL,'1 curzon place, old farm park, milton keynes ,',NULL,NULL,NULL,'mk7 8rb',NULL,'mrs s master','0',NULL,'2110754801',NULL),('293','1633433','B4386CA0-05D0-4166-9806-3C13DFB9DE0F','1','3','Mastercard','0','0','3','1','0','%','533846******1815','WkJz8KbJHJXNiugWBQotdohuXdtkSR0jXeNKP0hMYL4=','0315',NULL,NULL,'Fairview',NULL,NULL,NULL,'CM22 7TP',NULL,'Dylan Canty','0',NULL,'3923692502',NULL),('303','538553','3EDC6EC7-A442-4A6A-892C-0126DF6D54FF','1','6','Visa Debit','0','0','3','1','0','%','453979******1127','EVLui6Pb8uB31MaUN2RmR/+/jaMguDUmr5XzrT259+I=','0615',NULL,NULL,'172 Castelnau',NULL,'Barnes',NULL,'Sw13 9Dh',NULL,'Miss C M Gammie','0',NULL,'2098906802',NULL),('313','240933','84A2A1D7-67D8-493D-816F-E064343E0692','1','2','Visa','0','0','3','1','0','%','454634******4279','nEEeOkC7TCT5wbmyWT7rO70qvbD5KT4bHlxZsRMQWQE=','1014',NULL,NULL,'FLAT 2 RUSHEYMEAD HOUSE, 234 PLUMSTEAD HIGH STREET',NULL,NULL,NULL,'SE181JL',NULL,'MR CONOR MCCULLAGH','0',NULL,'2111017101',NULL),('323','538603','0BEED25D-6205-49D6-89B2-C1DDD4792357','1','6','Visa Debit','0','0','3','1','0','%','492181******6028','NxcyDKzztNJYaKmaPzSRQ0XWY26My7QppAAjyLLiTxg=','0115',NULL,NULL,'21 Faunce St',NULL,NULL,NULL,'SE17 3TR',NULL,'Joy Elton','0',NULL,'2111188501',NULL),('343','538673','C72DADC5-6C3B-48F4-8C8F-4B7315DAEB10','1','3','Mastercard','0','0','3','1','0','%','518652******8806','UmU/TwoLyOgbulKvrzvKGbwEcf/qNDDLMJXqQ18XLSY=','0413',NULL,NULL,'16 troutbeck Close',NULL,NULL,NULL,'rg109da',NULL,'Benjamin Whitmarsh','0',NULL,'2099129102',NULL),('363','386333','9BFB17E6-D3C1-46C2-B10F-D95258760F90','1','6','Visa Debit','0','0','3','1','0','%','465943******6562','Kb3XWduUYv2AB44TuKZ2PrMMEoAUfnPxWaSuO7HhWXo=','0415',NULL,NULL,'152 wenlock road shrewsbury',NULL,NULL,NULL,'sy2 6la',NULL,'mr n g rutty','0',NULL,'2099131002',NULL),('373','538663','AB16A6BB-50E2-43A9-A5F8-2E7FA80D32E4','1','6','Visa Debit','0','0','3','1','0','%','465902******8012','D9Li7p0EhcZgMBhs9RaoBuEGGGxwYLE7nfulmnFkgxU=','1015',NULL,NULL,'61 woodfall drive, crayford',NULL,NULL,NULL,'da1 4tn',NULL,'c d shinn','0',NULL,'2111347501',NULL),('383','93813','0D3BDE89-B8AA-48EE-AEA9-EACFFD3A68BF','1','2','Visa','0','0','3','1','0','%','412985******2161','jldDilHSPZ8FWLtGUb/xbj+BuWOr3esGnV3WwoWln84=','1016',NULL,NULL,'13 The Brambles',NULL,NULL,NULL,'TW2 6QS',NULL,'Nicholas Ashley','0',NULL,'2099161102',NULL),('403','500093','92FB711C-C0BA-4286-9FD3-72F925FFCA83','1','6','Visa Debit','0','0','3','1','0','%','454313******7323','YEzBRmVCxNbBOkqQ2v2zRMsw3PQtIDsQsFjvM6ViE/A=','0217',NULL,NULL,'1 Shey Copse',NULL,NULL,NULL,'gu22 8hs',NULL,'J FITZGERALD','0',NULL,'2111394301',NULL),('413','538683','F98603F0-EA85-4BD1-A8A4-0EF065994DA4','1','6','Visa Debit','0','0','3','1','0','%','465946******3857','1qcfgOikqOy7Mx+dVrKh/oAmu/lD/YY4ohDIwuU4b8c=','0615',NULL,NULL,'14 Broadfield',NULL,NULL,NULL,'Cm6 1ny',NULL,'Mrs s m dearlove','0',NULL,'2111407301',NULL),('433','538693','76BE2255-65A1-4564-9A03-DA264C6C2E07','1','6','Visa Debit','0','0','3','1','0','%','492181******5325','9ritwJ9/yf4JQjNJiGLu05FuJR9dkE1bzx8Mjsaep4I=','0913',NULL,NULL,'99 Cottenham Park Road',NULL,NULL,NULL,'SW20 0DS',NULL,'Miss Jenefer R Lincoln','0',NULL,'2099195902',NULL),('453','498723','77CFB16A-6CC0-40E3-9B8C-279BA8D6A4C9','1','6','Visa Debit','0','0','3','1','0','%','465945******2297','FMgPpUVUh0sHkHhZaL9RghrC6ZErIPCJ8jB5v87YfAQ=','0214',NULL,NULL,'180 Springwell Road',NULL,NULL,NULL,'tw5 9bs',NULL,'C K Toor','0',NULL,'2099293002',NULL),('473','319003','B9351EEE-58DF-4920-9A53-95ABBB24F80D','1','2','Visa','0','0','3','1','0','%','454638******1978','utVthPwfCzHCbCmPB+ZoVLEqUpih7sJqxsjRQhIue1I=','0115',NULL,NULL,'158A Chichester Road',NULL,NULL,NULL,'PO2 0AH',NULL,'MR MARK ADRIAN HAWKINS','0',NULL,'2099314202',NULL),('493','538723','FD5DB1E0-23E6-4E6E-A6E9-F59765515380','1','6','Visa Debit','0','0','3','1','0','%','454313******2524','Y6tkf2aZAl0r3HjcbxDqbBhKYCufQhf8WPExL1jxyPs=','0514',NULL,NULL,'10 Percy rd',NULL,NULL,NULL,'TW77HB',NULL,'DC Bailey','0',NULL,'2111635901',NULL),('503','120533','723552CF-6DED-446D-AC2B-B97DC277F407','1','2','Visa','0','0','3','1','0','%','465590******6031','3dLEResoO6U9Dd0h/cSukpN3CA/AnXH8WjObYwmGWNc=','1013',NULL,NULL,'1
