(6581,1,NULL,8772,'draziel@aol.com',1,'0b2d80cf34d9a685a98056fbe3cbed6d'),(6582,1,NULL,8774,'danifig@danifig.com',1,'1bd399e66615e94d1d9967faaa6e2423'),(6583,1,NULL,8775,'ezdz@hotmail.co.uk',1,'6db094409cd5f1c5c2fa000034f8b2e3'),(6584,1,NULL,8776,'gpmail@roadrunner.com',1,'39a41c142f5b2edddb77f7191d3ac142'),(6585,1,NULL,8777,'davewsound@gmail.com',1,'d93b421c217a3eec436c774d8c6b485f'),(6586,1,NULL,8778,'Nathan@tisd.tv',1,'5b73a82c03c3c59b77e8dbbe194dba31'),(6587,1,NULL,8779,'emeyer123@free.fr',1,'b73edfbeefda5537739e753d977fc8db'),(6588,1,NULL,8780,'rob@robbiedwyermusic.com',1,'cfa7ea9aa355b9c712aa0273c22982cf'),(6589,1,NULL,8782,'mark@zaffin.co.uk',1,'87129186e44bb92d36d9e24dc78e2152'),(6590,1,NULL,8783,'sondy65@gmail.com',1,'88616ce05c67920a003973e4e4ba99e9'),(6591,1,NULL,8784,'julien.home@free.fr',1,'a325052e9be0363a748911a5569f2b4a'),(6592,1,NULL,8791,'dutchlow@nyc.rr.com',1,'ae54f1d53e659280f7cf4ddf9ba54848'),(6593,1,NULL,8793,'george@sonicarcade.com',1,'8a054ea1de8b157a56d40ca8415249ef'),(6594,1,NULL,8794,'gsseattle@comcast.net',1,'0f43c42cd131d7a9440f66bb6a323717'),(6595,1,NULL,8796,'steve@stevehillier.net',1,'42a643b24234fe608947ccf1826b170b'),(6596,1,NULL,8797,'fernamds@gmail.com',1,'5f3dd47eb36df3c9e079030584a67f30'),(6597,1,NULL,8799,'bruce@brucekaphan.com',1,'329d0de3eabce0475d3ab6554782326e'),(6598,1,NULL,8800,'shaneking@mac.com',1,'226cfaa1bd000e8bf0bf6496ae165b31'),(6599,1,NULL,8801,'juand@audio4m.com',1,'3a9bac8e8002cb0b4a0546426e18e965'),(6600,1,NULL,8802,'wizecrkr@bellsouth.net',1,'31b43975b7e40a5c6dd011d33710d881'),(6601,1,NULL,8803,'culdaff@me.com',1,'18bb88f401c7a30def26176179b32534'),(6602,1,NULL,8804,'carlesmir@mac.com',1,'ded97e163c5fddf04062bc8805a4da9f'),(6603,1,NULL,8805,'george@sarant.net',1,'980c3f7d76c45b13fd785a4364662051'),(6604,1,NULL,8806,'theoutersounds@gmail.com',1,'e8899b4837e90671cdcffa54069e31b8'),(6605,1,NULL,8807,'gkurowsk@calarts.edu',1,'7ec1811ff361e341d683fe7b35b701a3'),(6606,1,NULL,8808,'andywilla@yahoo.com.au',1,'bafb15bf75941d00794fc6b011703108'),(6607,1,NULL,8809,'Mattatodd2002@gmail.com',1,'3601b9c32f3122f3338986fbe67a4818'),(6608,1,NULL,8810,'randamills@gmail.com',1,'6d76b477ecc5fe4f3d9e2492da5aa5ce'),(6609,1,NULL,8811,'jimmortimore@hotmail.com',1,'33210948acdc96c12bcce817708de5db'),(6610,1,NULL,8812,'vrojr.option@gmail.com',1,'3393f5d58acbe60dfc8afbed7748cb86'),(6611,1,NULL,8813,'KENCOLEMAN1@GMAIL.COM',1,'e5be7887f4d5108e5d43f7bf49b940ec'),(6612,1,NULL,8814,'audiomichael@mac.com',1,'aef0654943d2403b4eeb8e81980f6060'),(6613,1,NULL,8817,'tony@wizardaudio.com',1,'f25647fd8b36cac61d50af04f7ad6ec0'),(6614,1,NULL,8818,'wlipiec@sbcglobal.net',1,'01cbda92a84f24e5219b9566cbbee524'),(6615,1,NULL,8819,'mail@glennkaufmann.com',1,'37f8196d6e4f6696bdcaeae70e3a2e6f'),(6616,1,NULL,8822,'anishsanto@gmail.com',1,'1ea58b595d98878da28bff97832b8622'),(6617,1,NULL,8823,'th@tonyhumecke.com',1,'294a4892759c4680869ca97392475cb4'),(6618,1,NULL,8825,'matteogaggioli79@gmail.com',1,'b6aaa4fbc9dbe2dbdf02ee6b12f3345d'),(6619,1,NULL,8827,'bembiii@hotmail.com',1,'4039ea36be2791e57ae38340db6c659a'),(6620,1,NULL,8828,'hmilla@gmail.com',1,'3ee9f3725bb85759cc8fac2f589bc749'),(6621,1,NULL,8830,'thackeray.ben@gmail.com',1,'711a081d6eb0555668f0774950199fc1'),(6622,1,NULL,8831,'graydonmonk1953@gmail.com',1,'0b6c4dbaf2b114ab407b0156285fccc6'),(6623,1,NULL,8834,'bookings@acoustevents.com',1,'8f71041b0a1734273d85c8578d3dd3e5'),(6624,1,NULL,8837,'mwpeters75@gmx.com',1,'c4c7d7cd78236ea546d51de7eea2d0bb'),(6625,1,NULL,8839,'jamesmellor980@gmail.com',1,'5f8c954eaa650419a6d4358398717c9b'),(6626,1,NULL,8841,'matt@twelveeightsound.com',1,'718c85ea71cd504eba39e823de351db3'),(6627,1,NULL,8842,'FLANZER@USRNY.COM',1,'f09f6f26f82ca777347d9d5e812c942f'),(6628,1,NULL,8843,'ronharris1@mac.com',1,'f5bc2064cace3bb653143ceed06dbc7b'),(6629,1,NULL,8848,'stevebertrandmusic@gmail.com',1,'141bb05de77b1abe25d3047d93991fb4'),(6630,1,NULL,8851,'Build312heavy@gmail.com',1,'c270948f0b9794633e9866375aac0ced'),(6631,1,NULL,8852,'yaronfuchs@gmail.com',1,'5eaf4b7c76b5d842bdf14b0c9caff093'),(6632,1,NULL,8853,'fivet3v3@hotmail.com',1,'fdadeeb4d75852b26027d472eb7a0d94'),(6633,1,NULL,8855,'Robertmacinnis@hotmail.com',1,'377136933807479b15d3f495730a296a'),(6634,1,NULL,8856,'terrydawson@att.net',1,'6c79272093f31daa714c0de54d79b23f');

--
-- Table structure for table `newsletter_template`
--

CREATE TABLE `newsletter_template` (
  `template_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `template_code` varchar(150) DEFAULT NULL COMMENT 'Template Code',
  `template_text` text COMMENT 'Template Text',
  `template_styles` text COMMENT 'Template Styles',
  `template_type` int unsigned DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) DEFAULT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `template_actual` smallint unsigned DEFAULT '1' COMMENT 'Template Actual',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Added At',
  `modified_at` timestamp NULL DEFAULT NULL COMMENT 'Modified At',
  `is_legacy` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Should the template render in legacy mode',
  PRIMARY KEY (`template_id`),
  KEY `NEWSLETTER_TEMPLATE_TEMPLATE_ACTUAL` (`template_actual`),
  KEY `NEWSLETTER_TEMPLATE_ADDED_AT` (`added_at`),
  KEY `NEWSLETTER_TEMPLATE_MODIFIED_AT` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Newsletter Template';

--
-- Dumping data for table `newsletter_template`
--


--
-- Table structure for table `oauth_consumer`
--

CREATE TABLE `oauth_consumer` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `name` varchar(255) NOT NULL COMMENT 'Name of consumer',
  `key` varchar(32) NOT NULL COMMENT 'Key code',
  `secret` varchar(32) NOT NULL COMMENT 'Secret code',
  `callback_url` text COMMENT 'Callback URL',
  `rejected_callback_url` text NOT NULL COMMENT 'Rejected callback URL',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `OAUTH_CONSUMER_KEY` (`key`),
  UNIQUE KEY `OAUTH_CONSUMER_SECRET` (`secret`),
  KEY `OAUTH_CONSUMER_CREATED_AT` (`created_at`),
  KEY `OAUTH_CONSUMER_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='OAuth Consumers';

--
-- Dumping data for table `oauth_consumer`
--


--
-- Table structure for table `oauth_nonce`
--

CREATE TABLE `oauth_nonce` (
  `nonce` varchar(32) NOT NULL COMMENT 'Nonce String',
  `timestamp` int unsigned NOT NULL COMMENT 'Nonce Timestamp',
  `consumer_id` int unsigned NOT NULL COMMENT 'Consumer ID',
  UNIQUE KEY `OAUTH_NONCE_NONCE_CONSUMER_ID` (`nonce`,`consumer_id`),
  KEY `OAUTH_NONCE_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` (`consumer_id`),
  KEY `OAUTH_NONCE_TIMESTAMP` (`timestamp`),
  CONSTRAINT `OAUTH_NONCE_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `oauth_consumer` (`entity_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='OAuth Nonce';

--
-- Dumping data for table `oauth_nonce`
--


--
-- Table structure for table `oauth_token`
--

CREATE TABLE `oauth_token` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `consumer_id` int unsigned DEFAULT NULL COMMENT 'Oauth Consumer ID',
  `admin_id` int unsigned DEFAULT NULL COMMENT 'Admin user ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer user ID',
  `type` varchar(16) NOT NULL COMMENT 'Token Type',
  `token` varchar(32) NOT NULL COMMENT 'Token',
  `secret` varchar(32) NOT NULL COMMENT 'Token Secret',
  `verifier` varchar(32) DEFAULT NULL COMMENT 'Token Verifier',
  `callback_url` text NOT NULL COMMENT 'Token Callback URL',
  `revoked` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token revoked',
  `authorized` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token authorized',
  `user_type` int DEFAULT NULL COMMENT 'User type',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Token creation timestamp',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `OAUTH_TOKEN_TOKEN` (`token`),
  KEY `OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` (`admin_id`),
  KEY `OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
  KEY `OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`),
  CONSTRAINT `OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `OAUTH_TOKEN_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `oauth_consumer` (`entity_id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='OAuth Tokens';

--
-- Dumping data for table `oauth_token`
--

