DROP TABLE IF EXISTS testcase;
CREATE TABLE testcase (
   user_id varchar(32) NOT NULL,
   ip int(11) DEFAULT '0' NOT NULL,
   date date DEFAULT '0000-00-00' NOT NULL,
   cid int(10) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (user_id, ip, date, cid)
);

INSERT INTO testcase VALUES ( '0001a09759555a1658659c5aacc0343d', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '0001a09759555a1658659c5aacc0343d', '-1617682622', '2012-04-20', '97');
INSERT INTO testcase VALUES ( '0001a09759555a1658659c5aacc0343d', '-1617682622', '2012-04-20', '226');
INSERT INTO testcase VALUES ( '0001a09759555a1658659c5aacc0343d', '-1617682622', '2012-04-20', '14009');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '59');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '73');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '97');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '1106');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '14195');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '21739');
INSERT INTO testcase VALUES ( '0510771687f704f74e8a53ecf83cf504', '-1617682622', '2012-04-20', '21743');
INSERT INTO testcase VALUES ( '0a933d5b732eb5fb843f7111ad492d40', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '0a933d5b732eb5fb843f7111ad492d40', '-1617682622', '2012-04-20', '97');
INSERT INTO testcase VALUES ( '0a933d5b732eb5fb843f7111ad492d40', '-1617682622', '2012-04-20', '106');
INSERT INTO testcase VALUES ( '0a933d5b732eb5fb843f7111ad492d40', '-1617682622', '2012-04-20', '2390');
INSERT INTO testcase VALUES ( '1712d4b1e2e89f5f714bdab041f4580b', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '1712d4b1e2e89f5f714bdab041f4580b', '-1617682622', '2012-04-20', '300');
INSERT INTO testcase VALUES ( '1712d4b1e2e89f5f714bdab041f4580b', '-1617682622', '2012-04-20', '13970');
INSERT INTO testcase VALUES ( '1884d816e9d3eaa1a01418769e03e10d', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '3f6f061ea9a44f5a3b85272461a38f81', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '3f6f061ea9a44f5a3b85272461a38f81', '-1617682622', '2012-04-20', '285688');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '70');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '73');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '178');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '1075');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '4969');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '4978');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '4982');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '4986');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '15314');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '15395');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '20223');
INSERT INTO testcase VALUES ( '61f489bc84afeb3c1e42cbc5e4657503', '-1617682622', '2012-04-20', '20349');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '97');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '103');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '166');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '167');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '225');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '2358');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '3383');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '3388');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '3418');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '75383');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '284681');
INSERT INTO testcase VALUES ( '6d33ce84aa5dea8bcbc2d7414d68ca6e', '-1617682622', '2012-04-20', '285458');
INSERT INTO testcase VALUES ( 'c226cadc9d7b633195861af2955f17d5', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'c226cadc9d7b633195861af2955f17d5', '-1617682622', '2012-04-20', '59');
INSERT INTO testcase VALUES ( 'c226cadc9d7b633195861af2955f17d5', '-1617682622', '2012-04-20', '1097');
INSERT INTO testcase VALUES ( 'c226cadc9d7b633195861af2955f17d5', '-1617682622', '2012-04-20', '1109');
INSERT INTO testcase VALUES ( 'c226cadc9d7b633195861af2955f17d5', '-1617682622', '2012-04-20', '14195');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '59');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '70');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '71');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '73');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '1103');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '14195');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '15314');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '15398');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '15628');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '15647');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '16187');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '16188');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '20945');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '20983');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '22063');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '22065');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '22935');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '22973');
INSERT INTO testcase VALUES ( 'c54ee3dbe51352c3600fdba512e93ebf', '-1617682622', '2012-04-20', '22975');
INSERT INTO testcase VALUES ( 'c9166a4dbe98299ed661acd678e60983', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'c9166a4dbe98299ed661acd678e60983', '-1617682622', '2012-04-20', '5042');
INSERT INTO testcase VALUES ( 'd7db23881f377ce9f1c3754f094595c1', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'd7db23881f377ce9f1c3754f094595c1', '-1617682622', '2012-04-20', '59');
INSERT INTO testcase VALUES ( 'd7db23881f377ce9f1c3754f094595c1', '-1617682622', '2012-04-20', '14822');
INSERT INTO testcase VALUES ( 'e4a334ba1d141fbf4d55d8d34da54636', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'e4a334ba1d141fbf4d55d8d34da54636', '-1617682622', '2012-04-20', '97');
INSERT INTO testcase VALUES ( 'e4a334ba1d141fbf4d55d8d34da54636', '-1617682622', '2012-04-20', '159');
INSERT INTO testcase VALUES ( 'e4a334ba1d141fbf4d55d8d34da54636', '-1617682622', '2012-04-20', '3248');
INSERT INTO testcase VALUES ( 'e66e04e380317f21b4142e94ff3cbe62', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'e66e04e380317f21b4142e94ff3cbe62', '-1617682622', '2012-04-20', '179');
INSERT INTO testcase VALUES ( 'e66e04e380317f21b4142e94ff3cbe62', '-1617682622', '2012-04-20', '26191');
INSERT INTO testcase VALUES ( 'e66e04e380317f21b4142e94ff3cbe62', '-1617682622', '2012-04-20', '26203');
INSERT INTO testcase VALUES ( 'e66e04e380317f21b4142e94ff3cbe62', '-1617682622', '2012-04-20', '26291');
INSERT INTO testcase VALUES ( 'e945ff2db14011d91e70b5faf8dffda6', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'e945ff2db14011d91e70b5faf8dffda6', '-1617682622', '2012-04-20', '59');
INSERT INTO testcase VALUES ( 'e945ff2db14011d91e70b5faf8dffda6', '-1617682622', '2012-04-20', '1088');
INSERT INTO testcase VALUES ( 'e945ff2db14011d91e70b5faf8dffda6', '-1617682622', '2012-04-20', '1106');
INSERT INTO testcase VALUES ( 'e945ff2db14011d91e70b5faf8dffda6', '-1617682622', '2012-04-20', '14195');
INSERT INTO testcase VALUES ( 'f9e3c8c513e52d8ed6b37f08602da4d8', '-1617682622', '2012-04-20', '0');
INSERT INTO testcase VALUES ( 'f9e3c8c513e52d8ed6b37f08602da4d8', '-1617682622', '2012-04-20', '97');
INSERT INTO testcase VALUES ( 'f9e3c8c513e52d8ed6b37f08602da4d8', '-1617682622', '2012-04-20', '167');
INSERT INTO testcase VALUES ( 'f9e3c8c513e52d8ed6b37f08602da4d8', '-1617682622', '2012-04-20', '3420');
INSERT INTO testcase VALUES ( 'f9e3c8c513e52d8ed6b37f08602da4d8', '-1617682622', '2012-04-20', '5041');
INSERT INTO testcase VALUES ( 'f9e3c8c513e52d8ed6b37f08602da4d8', '-1617682622', '2012-04-20', '5842');

select count( distinct( user_id ) ) from test.testcase;
select count( distinct( ip ) ) from test.testcase;
select count( distinct( ip ) ), count( distinct( user_id ) ) from test.testcase;