Skip to content

Instantly share code, notes, and snippets.

@Kronos11

Kronos11/gist:1041680

Created June 23, 2011 01:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Kronos11/1041680 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Kronos11/1041680 to your computer and use it in GitHub Desktop.
Download ZIP
entire account table with stored procs
Raw
gistfile1.txt
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.48-community
/*!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_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
--
-- Create schema account
--
CREATE DATABASE IF NOT EXISTS account;
USE account;
--
-- Definition of table `accounts`
--
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
`account_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Account ID',
`account_username` char(32) NOT NULL DEFAULT '' COMMENT 'Account username',
`account_password` char(64) NOT NULL COMMENT 'Account password',
`account_station_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Account STATION_ID',
`account_level` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Account - CSR Flag',
`account_banned` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Account - Banned Status',
`account_email` char(64) NOT NULL DEFAULT '' COMMENT 'Account - User email',
`account_joindate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Account - Join Date',
`account_lastlogin` timestamp NULL DEFAULT NULL COMMENT 'Account - Last Login Timestamp',
`account_active` tinyint(1) DEFAULT NULL COMMENT 'Account - Active Flag',
`account_loggedin` int(1) NOT NULL DEFAULT '0' COMMENT 'Account - Cluster id account is logged into',
`account_authenticated` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Account - Authenticated Status',
`account_characters_allowed` tinyint(3) unsigned NOT NULL DEFAULT '2' COMMENT 'Number of characters allowed',
`account_session_key` varchar(32) DEFAULT NULL COMMENT 'Client Launcher - Session Key',
`account_lastcreate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Account - Last Character Create TimeStamp',
PRIMARY KEY (`account_id`),
UNIQUE KEY `account_username` (`account_username`)
) ENGINE=InnoDB AUTO_INCREMENT=1036 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `accounts`
--
/*!40000 ALTER TABLE `accounts` DISABLE KEYS */;
INSERT INTO `accounts` (`account_id`,`account_username`,`account_password`,`account_station_id`,`account_level`,`account_banned`,`account_email`,`account_joindate`,`account_lastlogin`,`account_active`,`account_loggedin`,`account_authenticated`,`account_characters_allowed`,`account_session_key`,`account_lastcreate`) VALUES
(537,'test1','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000000,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(538,'test2','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000001,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(539,'test3','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000002,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(540,'test4','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000003,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(541,'test5','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000004,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(542,'test6','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000005,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(543,'test7','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000006,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(544,'test8','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000007,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(545,'test9','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000008,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(546,'test10','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000009,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(547,'test11','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000010,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(548,'test12','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000011,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(549,'test13','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000012,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(550,'test14','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000013,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(551,'test15','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000014,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(552,'test16','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000015,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(553,'test17','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000016,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(554,'test18','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000017,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(555,'test19','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000018,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(556,'test20','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000019,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(557,'test21','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000020,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(558,'test22','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000021,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(559,'test23','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000022,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(560,'test24','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000023,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(561,'test25','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000024,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(562,'test26','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000025,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(563,'test27','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000026,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(564,'test28','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000027,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(565,'test29','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000028,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(566,'test30','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000029,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(567,'test31','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000030,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(568,'test32','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000031,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(569,'test33','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000032,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(570,'test34','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000033,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(571,'test35','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000034,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(572,'test36','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000035,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(573,'test37','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000036,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(574,'test38','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000037,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(575,'test39','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000038,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(576,'test40','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000039,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(577,'test41','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000040,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(578,'test42','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000041,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(579,'test43','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000042,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(580,'test44','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000043,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(581,'test45','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000044,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(582,'test46','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000045,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(583,'test47','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000046,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(584,'test48','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000047,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(585,'test49','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000048,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(586,'test50','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000049,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(587,'test51','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000050,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(588,'test52','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000051,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(589,'test53','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000052,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(590,'test54','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000053,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(591,'test55','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000054,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(592,'test56','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000055,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(593,'test57','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000056,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(594,'test58','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000057,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(595,'test59','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000058,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(596,'test60','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000059,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(597,'test61','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000060,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(598,'test62','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000061,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(599,'test63','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000062,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(600,'test64','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000063,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(601,'test65','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000064,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(602,'test66','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000065,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(603,'test67','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000066,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(604,'test68','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000067,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(605,'test69','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000068,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(606,'test70','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000069,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(607,'test71','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000070,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(608,'test72','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000071,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(609,'test73','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000072,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(610,'test74','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000073,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(611,'test75','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000074,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(612,'test76','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000075,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(613,'test77','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000076,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(614,'test78','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000077,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(615,'test79','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000078,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(616,'test80','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000079,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(617,'test81','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000080,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(618,'test82','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000081,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(619,'test83','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000082,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(620,'test84','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000083,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(621,'test85','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000084,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(622,'test86','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000085,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(623,'test87','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000086,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(624,'test88','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000087,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(625,'test89','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000088,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(626,'test90','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000089,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(627,'test91','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000090,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(628,'test92','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000091,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(629,'test93','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000092,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(630,'test94','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000093,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(631,'test95','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000094,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(632,'test96','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000095,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(633,'test97','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000096,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(634,'test98','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000097,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(635,'test99','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000098,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(636,'test100','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000099,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(637,'test101','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000100,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(638,'test102','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000101,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(639,'test103','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000102,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(640,'test104','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000103,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(641,'test105','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000104,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(642,'test106','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000105,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(643,'test107','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000106,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(644,'test108','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000107,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(645,'test109','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000108,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(646,'test110','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000109,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(647,'test111','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000110,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(648,'test112','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000111,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(649,'test113','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000112,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(650,'test114','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000113,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(651,'test115','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000114,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(652,'test116','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000115,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(653,'test117','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000116,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(654,'test118','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000117,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(655,'test119','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000118,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(656,'test120','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000119,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(657,'test121','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000120,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(658,'test122','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000121,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(659,'test123','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000122,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(660,'test124','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000123,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(661,'test125','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000124,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(662,'test126','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000125,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(663,'test127','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000126,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(664,'test128','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000127,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(665,'test129','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000128,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(666,'test130','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000129,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(667,'test131','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000130,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(668,'test132','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000131,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(669,'test133','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000132,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(670,'test134','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000133,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(671,'test135','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000134,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(672,'test136','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000135,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(673,'test137','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000136,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(674,'test138','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000137,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(675,'test139','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000138,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(676,'test140','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000139,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(677,'test141','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000140,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(678,'test142','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000141,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(679,'test143','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000142,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(680,'test144','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000143,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(681,'test145','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000144,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(682,'test146','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000145,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(683,'test147','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000146,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(684,'test148','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000147,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(685,'test149','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000148,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(686,'test150','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000149,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(687,'test151','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000150,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(688,'test152','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000151,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(689,'test153','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000152,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(690,'test154','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000153,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(691,'test155','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000154,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(692,'test156','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000155,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(693,'test157','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000156,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(694,'test158','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000157,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(695,'test159','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000158,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(696,'test160','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000159,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(697,'test161','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000160,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(698,'test162','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000161,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(699,'test163','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000162,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(700,'test164','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000163,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(701,'test165','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000164,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(702,'test166','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000165,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(703,'test167','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000166,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(704,'test168','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000167,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(705,'test169','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000168,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(706,'test170','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000169,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(707,'test171','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000170,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(708,'test172','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000171,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(709,'test173','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000172,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(710,'test174','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000173,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(711,'test175','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000174,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(712,'test176','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000175,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(713,'test177','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000176,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(714,'test178','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000177,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(715,'test179','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000178,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(716,'test180','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000179,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(717,'test181','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000180,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(718,'test182','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000181,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(719,'test183','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000182,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(720,'test184','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000183,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(721,'test185','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000184,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(722,'test186','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000185,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(723,'test187','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000186,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(724,'test188','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000187,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(725,'test189','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000188,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(726,'test190','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000189,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(727,'test191','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000190,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(728,'test192','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000191,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(729,'test193','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000192,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(730,'test194','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000193,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(731,'test195','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000194,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(732,'test196','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000195,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(733,'test197','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000196,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(734,'test198','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000197,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(735,'test199','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000198,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(736,'test200','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000199,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(737,'test201','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000200,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(738,'test202','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000201,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(739,'test203','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000202,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(740,'test204','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000203,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(741,'test205','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000204,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(742,'test206','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000205,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(743,'test207','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000206,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(744,'test208','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000207,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(745,'test209','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000208,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(746,'test210','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000209,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(747,'test211','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000210,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(748,'test212','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000211,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(749,'test213','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000212,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(750,'test214','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000213,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(751,'test215','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000214,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(752,'test216','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000215,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(753,'test217','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000216,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(754,'test218','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000217,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(755,'test219','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000218,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(756,'test220','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000219,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(757,'test221','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000220,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(758,'test222','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000221,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(759,'test223','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000222,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(760,'test224','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000223,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(761,'test225','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000224,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(762,'test226','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000225,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(763,'test227','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000226,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(764,'test228','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000227,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(765,'test229','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000228,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(766,'test230','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000229,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(767,'test231','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000230,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(768,'test232','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000231,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(769,'test233','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000232,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(770,'test234','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000233,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(771,'test235','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000234,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(772,'test236','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000235,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(773,'test237','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000236,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(774,'test238','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000237,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(775,'test239','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000238,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(776,'test240','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000239,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(777,'test241','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000240,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(778,'test242','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000241,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(779,'test243','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000242,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(780,'test244','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000243,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(781,'test245','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000244,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(782,'test246','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000245,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(783,'test247','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000246,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(784,'test248','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000247,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(785,'test249','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000248,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(786,'test250','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000249,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(787,'test251','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000250,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(788,'test252','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000251,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(789,'test253','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000252,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(790,'test254','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000253,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(791,'test255','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000254,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(792,'test256','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000255,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(793,'test257','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000256,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(794,'test258','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000257,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(795,'test259','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000258,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(796,'test260','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000259,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(797,'test261','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000260,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(798,'test262','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000261,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(799,'test263','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000262,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(800,'test264','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000263,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(801,'test265','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000264,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(802,'test266','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000265,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(803,'test267','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000266,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(804,'test268','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000267,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(805,'test269','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000268,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(806,'test270','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000269,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(807,'test271','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000270,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(808,'test272','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000271,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(809,'test273','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000272,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(810,'test274','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000273,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(811,'test275','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000274,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(812,'test276','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000275,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(813,'test277','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000276,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(814,'test278','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000277,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(815,'test279','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000278,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(816,'test280','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000279,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(817,'test281','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000280,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(818,'test282','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000281,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(819,'test283','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000282,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(820,'test284','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000283,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(821,'test285','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000284,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(822,'test286','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000285,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(823,'test287','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000286,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(824,'test288','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000287,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(825,'test289','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000288,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(826,'test290','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000289,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(827,'test291','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000290,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(828,'test292','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000291,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(829,'test293','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000292,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(830,'test294','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000293,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(831,'test295','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000294,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(832,'test296','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000295,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(833,'test297','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000296,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(834,'test298','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000297,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(835,'test299','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000298,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(836,'test300','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000299,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(837,'test301','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000300,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(838,'test302','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000301,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(839,'test303','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000302,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(840,'test304','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000303,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(841,'test305','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000304,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(842,'test306','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000305,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(843,'test307','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000306,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(844,'test308','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000307,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(845,'test309','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000308,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(846,'test310','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000309,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(847,'test311','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000310,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(848,'test312','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000311,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(849,'test313','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000312,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(850,'test314','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000313,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(851,'test315','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000314,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(852,'test316','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000315,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(853,'test317','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000316,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(854,'test318','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000317,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(855,'test319','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000318,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(856,'test320','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000319,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(857,'test321','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000320,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(858,'test322','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000321,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(859,'test323','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000322,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(860,'test324','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000323,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(861,'test325','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000324,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(862,'test326','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000325,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(863,'test327','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000326,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(864,'test328','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000327,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(865,'test329','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000328,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(866,'test330','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000329,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(867,'test331','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000330,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(868,'test332','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000331,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(869,'test333','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000332,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(870,'test334','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000333,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(871,'test335','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000334,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(872,'test336','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000335,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(873,'test337','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000336,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(874,'test338','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000337,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(875,'test339','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000338,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(876,'test340','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000339,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(877,'test341','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000340,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(878,'test342','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000341,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(879,'test343','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000342,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(880,'test344','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000343,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(881,'test345','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000344,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(882,'test346','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000345,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(883,'test347','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000346,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(884,'test348','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000347,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(885,'test349','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000348,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(886,'test350','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000349,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(887,'test351','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000350,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(888,'test352','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000351,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(889,'test353','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000352,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(890,'test354','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000353,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(891,'test355','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000354,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(892,'test356','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000355,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(893,'test357','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000356,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(894,'test358','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000357,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(895,'test359','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000358,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(896,'test360','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000359,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(897,'test361','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000360,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(898,'test362','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000361,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17');
INSERT INTO `accounts` (`account_id`,`account_username`,`account_password`,`account_station_id`,`account_level`,`account_banned`,`account_email`,`account_joindate`,`account_lastlogin`,`account_active`,`account_loggedin`,`account_authenticated`,`account_characters_allowed`,`account_session_key`,`account_lastcreate`) VALUES
(899,'test363','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000362,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(900,'test364','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000363,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(901,'test365','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000364,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(902,'test366','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000365,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(903,'test367','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000366,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(904,'test368','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000367,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(905,'test369','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000368,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(906,'test370','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000369,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(907,'test371','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000370,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(908,'test372','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000371,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(909,'test373','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000372,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(910,'test374','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000373,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(911,'test375','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000374,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(912,'test376','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000375,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(913,'test377','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000376,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(914,'test378','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000377,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(915,'test379','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000378,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(916,'test380','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000379,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(917,'test381','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000380,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(918,'test382','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000381,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(919,'test383','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000382,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(920,'test384','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000383,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(921,'test385','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000384,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(922,'test386','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000385,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(923,'test387','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000386,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(924,'test388','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000387,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(925,'test389','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000388,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(926,'test390','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000389,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(927,'test391','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000390,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(928,'test392','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000391,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(929,'test393','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000392,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(930,'test394','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000393,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(931,'test395','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000394,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(932,'test396','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000395,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(933,'test397','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000396,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(934,'test398','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000397,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(935,'test399','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000398,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(936,'test400','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000399,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(937,'test401','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000400,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(938,'test402','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000401,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(939,'test403','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000402,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(940,'test404','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000403,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(941,'test405','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000404,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(942,'test406','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000405,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(943,'test407','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000406,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(944,'test408','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000407,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(945,'test409','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000408,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(946,'test410','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000409,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(947,'test411','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000410,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(948,'test412','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000411,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(949,'test413','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000412,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(950,'test414','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000413,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(951,'test415','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000414,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(952,'test416','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000415,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(953,'test417','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000416,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(954,'test418','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000417,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(955,'test419','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000418,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(956,'test420','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000419,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(957,'test421','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000420,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(958,'test422','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000421,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(959,'test423','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000422,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(960,'test424','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000423,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(961,'test425','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000424,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(962,'test426','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000425,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(963,'test427','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000426,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(964,'test428','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000427,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(965,'test429','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000428,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(966,'test430','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000429,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(967,'test431','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000430,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(968,'test432','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000431,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(969,'test433','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000432,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(970,'test434','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000433,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(971,'test435','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000434,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(972,'test436','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000435,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(973,'test437','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000436,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(974,'test438','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000437,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(975,'test439','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000438,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(976,'test440','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000439,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(977,'test441','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000440,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(978,'test442','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000441,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(979,'test443','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000442,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(980,'test444','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000443,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(981,'test445','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000444,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(982,'test446','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000445,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(983,'test447','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000446,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(984,'test448','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000447,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(985,'test449','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000448,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(986,'test450','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000449,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(987,'test451','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000450,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(988,'test452','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000451,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(989,'test453','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000452,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(990,'test454','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000453,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(991,'test455','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000454,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(992,'test456','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000455,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(993,'test457','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000456,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(994,'test458','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000457,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(995,'test459','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000458,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(996,'test460','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000459,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(997,'test461','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000460,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(998,'test462','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000461,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(999,'test463','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000462,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1000,'test464','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000463,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1001,'test465','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000464,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1002,'test466','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000465,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1003,'test467','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000466,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1004,'test468','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000467,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1005,'test469','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000468,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1006,'test470','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000469,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1007,'test471','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000470,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1008,'test472','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000471,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1009,'test473','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000472,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1010,'test474','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000473,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1011,'test475','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000474,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1012,'test476','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000475,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1013,'test477','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000476,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1014,'test478','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000477,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1015,'test479','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000478,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1016,'test480','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000479,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1017,'test481','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000480,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1018,'test482','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000481,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1019,'test483','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000482,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1020,'test484','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000483,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1021,'test485','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000484,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1022,'test486','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000485,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1023,'test487','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000486,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1024,'test488','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000487,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1025,'test489','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000488,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1026,'test490','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000489,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1027,'test491','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000490,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1028,'test492','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000491,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1029,'test493','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000492,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1030,'test494','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000493,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1031,'test495','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000494,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1032,'test496','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000495,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1033,'test497','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000496,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1034,'test498','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000497,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17'),
(1035,'test499','a94a8fe5ccb19ba61c4c0873d391e987982fbbd3',1000498,0,0,'[email protected]','2011-05-11 19:02:17','2011-05-11 19:02:17',1,0,0,1,'123456789','2011-05-10 19:02:17');
/*!40000 ALTER TABLE `accounts` ENABLE KEYS */;
--
-- Definition of function `sf_CharacterDelete`
--
DROP FUNCTION IF EXISTS `sf_CharacterDelete`;
DELIMITER $$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` FUNCTION `sf_CharacterDelete`(character_id BIGINT) RETURNS int(11)
BEGIN
DECLARE attributes_id int(11);
DECLARE faction_id int(11);
DECLARE check_value INT(11);
DECLARE error_code INT(11);
SET error_code = 0;
UPDATE characters SET archived = 1 WHERE id = character_id;
UPDATE characters SET deletiondate = (DATE_ADD(NOW(), INTERVAL +90 DAY)) WHERE id = character_id;
SELECT COUNT(*) from characters WHERE id = character_id AND archived = 1 INTO check_value;
IF check_value > 0 THEN SET error_code = 1;
END IF;
RETURN(error_code);
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */ $$
DELIMITER ;
--
-- Definition of procedure `sp_AddTestAccount`
--
DROP PROCEDURE IF EXISTS `sp_AddTestAccount`;
DELIMITER $$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_AddTestAccount`(IN number INT)
BEGIN
DECLARE mAccount_id BIGINT(20);
DECLARE mStation_id BIGINT(20);
DECLARE mAccount_password CHAR(64);
DECLARE mUsername VARCHAR(64);
DECLARE a INT Default 1 ;
account_loop: LOOP
SET mUsername = concat('test',a);
SELECT SHA1('test') INTO mAccount_password;
SELECT MAX(account_id) + a FROM account.accounts INTO mAccount_id FOR UPDATE;
IF mAccount_id IS NULL THEN
SET mAccount_id = 1;
END IF;
SELECT MAX(account_station_id) + 1 FROM account.accounts INTO mStation_id;
IF mStation_id IS NULL THEN
SET mStation_id = 1000000;
END IF;
INSERT INTO account.accounts VALUES (NULL, mUsername, mAccount_password, mStation_id, 0, 0, '[email protected]', NOW(), NOW(), 1, 0, 0, 1, NULL, NOW() - INTERVAL 1 DAY);
SET a = a+1;
if a=number THEN
LEAVE account_loop;
END IF;
END LOOP account_loop;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */ $$
DELIMITER ;
--
-- Definition of procedure `sp_ReturnAccountCharacters`
--
DROP PROCEDURE IF EXISTS `sp_ReturnAccountCharacters`;
DELIMITER $$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_ReturnAccountCharacters`(IN account_id INT)
BEGIN
SELECT A.id, A.firstname, A.lastname, A.galaxy_id, B.base_model_string
FROM swganh.characters A
INNER JOIN swganh.character_appearance B ON (A.id = B.character_id)
WHERE A.account_id= account_id AND A.archived=0;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */ $$
DELIMITER ;
--
-- Definition of procedure `sp_ReturnUserAccount`
--
DROP PROCEDURE IF EXISTS `sp_ReturnUserAccount`;
DELIMITER $$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_ReturnUserAccount`(IN usrName CHAR(255),IN pwrd CHAR(255))
BEGIN
DECLARE shaPwrd CHAR(255);
SET shaPwrd = SHA1(pwrd);
SELECT
account_id,
account_username,
account_password,
account_station_id,
account_banned,
account_active,
account_characters_allowed,
account_level,
account_session_key
FROM account.accounts
WHERE account_banned=0 AND account_authenticated = 0 AND account_loggedin = 0 AND account_username= usrName AND account_password = shaPwrd;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */ $$
DELIMITER ;
--
-- Definition of procedure `sp_UpdateAuthentication`
--
DROP PROCEDURE IF EXISTS `sp_UpdateAuthentication`;
DELIMITER $$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_UpdateAuthentication`(IN authenticated INT , acc_id BIGINT)
BEGIN
update accounts set account_authenticated = authenticated
where account_id = acc_id;
END $$
/*!50003 SET SESSION SQL_MODE=@TEMP_SQL_MODE */ $$
DELIMITER ;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment