API tools faq
paste
Advertisement
ArizonaMilitia

TORCH Antifa Sql DB

ArizonaMilitia
Sep 17th, 2017
1,009
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.83 KB | None | 0 0
raw download clone embed print report
  1. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  2. SET time_zone = "+00:00";
  3.  
  4.  
  5. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  6. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  7. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  8. /*!40101 SET NAMES utf8 */;
  9.  
  10. --
  11. -- Database: `CARBON`
  12. --
  13.  
  14. -- --------------------------------------------------------
  15.  
  16. --
  17. -- Table structure for table `nodes`
  18. --
  19.  
  20. CREATE TABLE IF NOT EXISTS `nodes` (
  21. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ai tracker',
  22. `type` int(11) NOT NULL COMMENT 'type of node, 0 being person, 1 being a primary (clique) group, 2 being a secondary, 3 being a superstructure',
  23. `name` text NOT NULL COMMENT 'name of the node',
  24. `description` text NOT NULL COMMENT 'description of the group',
  25. `lastupdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The last time information about this node was updated',
  26. PRIMARY KEY (`id`)
  27. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='This table holds all of the top level nodes in our graph. Descriptors and edges will point to these rows.' AUTO_INCREMENT=48 ;
  28.  
  29. --
  30. -- Dumping data for table `nodes`
  31. --
  32.  
  33. INSERT INTO `nodes` (`id`, `type`, `name`, `description`, `lastupdated`) VALUES
  34. (5, 0, 'Yvette Felarca', 'TGVhZGVyIG9mIEJBTU4sIGFuYXJjaGlzdCB0ZXJyb3Jpc3QgZ3JvdXAgaW4gTm9yQ2FsLiBMZWQgdGhlIFNhY3JhbWVudG8gUmlvdC4gV29ya3MgYXQgTWFydGluIEx1dGhlciBLaW5nIEpyLiBNaWRkbGUgc2Nob29sIGluIEJlcmtlbGV5IGFzIGEgSHVtYW5pdGllcyBUZWFjaGVyIGZvciB0aGUgN3RoIGdyYWRlLg==', '2017-07-31 17:19:38'),
  35. (23, 2, 'Party for Socialism and Liberation', 'aHR0cDovL3d3dy5wc2x3ZWIub3JnLw0KDQoiVGhlIFBhcnR5IGZvciBTb2NpYWxpc20gYW5kIExpYmVyYXRpb24gYmVsaWV2ZXMgdGhhdCB0aGUgb25seSBzb2x1dGlvbiB0byB0aGUgZGVlcGVuaW5nIGNyaXNpcyBvZiBjYXBpdGFsaXNtIGlzIHRoZSBzb2NpYWxpc3QgdHJhbnNmb3JtYXRpb24gb2Ygc29jaWV0eS4i', '2017-07-31 01:30:10'),
  36. (24, 2, 'Grassroots Campaigns - MI', 'dG8gcXVvdGUgdGhlaXIgc2l0ZToNCj5XaXRoIGFuIGVtcGhhc2lzIG9uIHNtYWxsLWRvbm9yIGZ1bmRyYWlzaW5nLCB3ZSBoZWxwZWQgY2hhbmdlIGhvdyB0aGUgYXZlcmFnZSBwZXJzb24gaW50ZXJhY3RlZCB3aXRoIGEgcG9saXRpY2FsIHBhcnR5LiAgV2l0aCBvdmVyIDIsMDAwIHN0YWZmIG1lbWJlcnMsIHdlIHdlcmUgYWJsZSB0byBzaWduIG9uIHRob3VzYW5kcyBvZiBuZXcgc3VwcG9ydGVycyBhbmQgcmFpc2luZyBtaWxsaW9ucyBvZiBkb2xsYXJzLiBNb3JlIGltcG9ydGFudGx5LCBvdXIgd29yayBhbGxvd2VkIGV2ZXJ5ZGF5IHBlb3BsZSB0byBzZWUgdGhleSBjb3VsZCBpbXBhY3QgdGhlIHBvbGl0aWNhbCBwcm9jZXNzLg0KaHR0cHM6Ly93d3cuZmFjZWJvb2suY29tL0dyYXNzcm9vdHMtQ2FtcGFpZ25zLUFubi1BcmJvci0xNTQ2NzI3NjU1NjMwNjY2Lw0KaHR0cHM6Ly9hbm5hcmJvci5jcmFpZ3NsaXN0Lm9yZy9ucG8vNjE3Nzc2MzExMi5odG1sDQpodHRwOi8vZ3Jhc3Nyb290c2NhbXBhaWducy5jb20v', '2017-07-31 01:30:10'),
  37. (25, 2, 'Redneck Revolt', 'UmVkbmVjayBSZXZvbHQgaXMgYSBuYXRpb25hbCBuZXR3b3JrIG9mIGNvbW11bml0eSBkZWZlbnNlIHByb2plY3RzIGZyb20gYSBicm9hZCBzcHJlYWQgb2YgcG9saXRpY2FsLCByZWxpZ2lvdXMsIGFuZCBjdWx0dXJhbCBiYWNrZ3JvdW5kcy4gSXQgaXMgYSBwcm8td29ya2VyLCBhbnRpLXJhY2lzdCBvcmdhbml6YXRpb24gdGhhdCBmb2N1c2VzIG9uIHdvcmtpbmcgY2xhc3MgbGliZXJhdGlvbiBmcm9tIHRoZSBvcHByZXNzaXZlIHN5c3RlbXMgd2hpY2ggZG9taW5hdGUgb3VyIGxpdmVzLiBJbiBzdGF0ZXMgd2hlcmUgaXQgaXMgbGVnYWwgdG8gcHJhY3RpY2UgYXJtZWQgY29tbXVuaXR5IGRlZmVuc2UsIG1hbnkgYnJhbmNoZXMgY2hvb3NlIHRvIGJlY29tZSBKb2huIEJyb3duIEd1biBDbHVicywgdHJhaW5pbmcgb3Vyc2VsdmVzIGFuZCBvdXIgY29tbXVuaXRpZXMgaW4gZGVmZW5zZSBhbmQgbXV0dWFsIGFpZC4gDQoNCmh0dHBzOi8vd3d3LnJlZG5lY2tyZXZvbHQub3JnLw==', '2017-07-31 05:05:55'),
  38. (26, 2, 'Michigan Organizer (antifa)', 'aHR0cHM6Ly9taWNoaWdhbm9yZ2FuaXplci5pbmZvLw0KRXNzZW50aWFsbHkgYSBkYXRlYm9vayBvZiBldmVudHMgZm9yIGFudGlmYSBvcmdhbml6aW5nDQpSdW4gYnkgUllBTiBIVUdIRVMgKD8p', '2017-07-31 01:30:11'),
  39. (27, 2, 'South Side Chigcago ARA', 'aHR0cDovL3NvdXRoc2lkZWFudGlmYS5ibG9nc3BvdC5jb20vDQpBbHNvIHN5bmRpY2F0ZWQgd2l0aCB0aGUgdG9yY2hhbnRpZmEub3JnIGdyb3VwLg==', '2017-07-31 01:30:11'),
  40. (28, 2, 'ARA LA', 'QSByYXRoZXIgaGlnaCBwb3dlcmVkIGdyb3VwLiAgQWxzbyBydW5zIGEgemluZS4NCmh0dHBzOi8vYW50aXJhY2lzdC5vcmcv', '2017-07-31 01:30:11'),
  41. (29, 2, 'Arch City ARA (Ohio)', 'aHR0cDovL2FyY2hjaXR5YXJhLmJsb2dzcG90LmNvbS8NCkxhcmdlbHkgaW5hY3RpdmUu', '2017-07-31 01:30:11'),
  42. (30, 2, 'ONE PEOPLE''S PROJECT', 'SW5ncmVzcyBwb2ludCBmb3IgZnVuZHMgaW50byBhbnRpZmEuICBBS0EgcGhpbGx5IGFudGlmYSdzIHBlcnNvbmFsIHNsdXNoIGZ1bmQuDQpodHRwOi8vb25lcGVvcGxlc3Byb2plY3QuY29tLw==', '2017-07-31 01:30:11'),
  43. (31, 2, 'Rocky Mountain Antifa (Colorado)', 'aHR0cHM6Ly9yb2NreW1vdW50YWluYW50aWZhLmJsb2dzcG90LmNvbS8NCmh0dHBzOi8vdHdpdHRlci5jb20vUmNreU10bkFudGlmYQ==', '2017-07-31 01:30:11'),
  44. (32, 2, 'Rose City Antifa (Oregon)', 'aHR0cDovL3Jvc2VjaXR5YW50aWZhLm9yZy8NCmNpaTU3cmtkdGNnZzU1ZmUub25pb24NClNvbWV0aGluZyBpcyB1cCB3aXRoIHRoZWlyIHRvciBzZXJ2aWNlLiAgRXhwbG9pdGFibGU/', '2017-07-31 01:30:11'),
  45. (33, 2, 'The Socialist Worker (zine)', 'aHR0cHM6Ly9zb2NpYWxpc3R3b3JrZXIub3JnLw0KDQpSdW4gYnkgYXMgYSBzaGVsbCBieSB0aGUgaW50ZXJuYXRpb25hbCBzb2NpYWxpc3RzLiAgQWN0aXZlIGluIENoaWNhZ28sIGFuZCBzZWVtcyB0byBiZSBiYXNlZCBvdXQgb2YgdGhlcmUuICBBbHNvIGhhcyBwaHlzaWNhbCBkaXN0cmlidXRpb24u', '2017-07-31 01:30:12'),
  46. (34, 2, 'Chicago Socialists', 'aHR0cDovL2NoaWNhZ29zb2NpYWxpc3RzLm9yZy8NCmh0dHBzOi8vd3d3LmZhY2Vib29rLmNvbS9jaGljYWdvc29jaWFsaXN0cw0KaHR0cHM6Ly90d2l0dGVyLmNvbS9jaGljYWdvX2lzbw0KU29tZW9uZSBkdW1wIHRoZWlyIHR3aXR0ZXIvZmFjZWJvb2sgZm9sbG93ZXJzICYgdmlld2Vycy4=', '2017-07-31 01:30:12'),
  47. (35, 2, 'Hoosier Action', 'aHR0cHM6Ly93d3cuaG9vc2llcmFjdGlvbi5vcmcvDQoNCiJXZSBiZWxpZXZlIHRoYXQgcGVvcGxl4oCUcGFydGljdWxhcmx5IGxvdy1pbmNvbWUgcGVvcGxlIOKAlG11c3QgYmUgYXQgdGhlIGNlbnRlciBvZiBkZWNpc2lvbiBtYWtpbmcsIGFuZCB0aGVpciBsaXZlcyBhbmQgdGhlaXIgdm9pY2VzIG11c3QgYmUgYSBmb3VuZGF0aW9uYWwgcGFydCBvZiBvdXIgc2hhcmVkIGRlbW9jcmFjeS4iDQoNCkZpbmQgYSB3YXkgdG8gY3V0IG9mZiB0aGVpciBkb25hdGlvbiBzdHJlYW0/DQpodHRwczovL3d3dy5ob29zaWVyYWN0aW9uLm9yZy9qb2ludXM=', '2017-07-31 01:30:12'),
  48. (36, 3, 'TORCH antifa', 'U3VwZXJzdHJ1Y3R1cmUgZ3JvdXAgZm9yIHNlbGVjdCBhbnRpZmEgZ3JvdXAuCkFuZCB0byBxdW90ZSB0aGVpciBzaXRlOgo+VGhlIFRvcmNoIE5ldHdvcmsgaXMgYSBuZXR3b3JrIG9mIE1pbGl0YW50IGFudGlmYXNjaXN0cyBhY3Jvc3MgKGJ1dCBub3QgbGltaXRlZCB0bykgdGhlIHVuaXRlZCBzdGF0ZXMuIFdlIGFyZSBib3JuIG91dCBvZiwgYW5kIHBheSBvdXIgcmVzcGVjdHMgdG8sIHRoZSBBbnRpLVJhY2lzdCBBY3Rpb24gTmV0d29yay4gV2UgYXJlIGRlZGljYXRlZCB0byBjb25mcm9udGluZyBmYXNjaXNtIGFuZCBvdGhlciBlbGVtZW50IG9mIG9wcHJlc3Npb24uIFdlIGJlbGlldmUgaW4gZGlyZWN0IGFjdGlvbi4=', '2017-07-31 01:44:18'),
  49. (37, 2, 'Hoosier Anti Racist Movement', 'SEFSTSBncm91cCwgYW50aWZhIGluIGluZGlhbmEuCgpodHRwczovL3d3dy5mYWNlYm9vay5jb20vcGcvSW5kaWFuYUFudGlmYS9hYm91dC8/cmVmPXBhZ2VfaW50ZXJuYWw=', '2017-08-09 17:02:26'),
  50. (38, 2, 'idavox', 'SWRhdm94IGlzIGEgc21hbGwgc2hlbGwgemluZSBydW4gYnkgdG9yY2guCmh0dHA6Ly9pZGF2b3guY29tLw==', '2017-07-31 02:51:35'),
  51. (40, 3, 'International Socialist Organization', 'PlRoZSBJU08gaXMgYnVpbGRpbmcgYSBzb2NpYWxpc3QgYWx0ZXJuYXRpdmUgaW4gYSB3b3JsZCBvZiBwb3ZlcnR5LCBvcHByZXNzaW9uIGFuZCB3YXIuIE91ciBvcmdhbml6YXRpb24gcGFydGljaXBhdGVzIGluIG1hbnkgZGlmZmVyZW50IHN0cnVnZ2xlcyBmb3IganVzdGljZSBhbmQgbGliZXJhdGlvbiB0b2RheSwgd2hpbGUgd29ya2luZyB0b3dhcmQgYSBmdXR1cmUgc29jaWFsaXN0IHNvY2lldHksIGZyZWUgb2YgYWxsIGV4cGxvaXRhdGlvbiBhbmQgb3BwcmVzc2lvbiwgYW5kIGJ1aWx0IG9uIHRoZSBwcmluY2lwbGVzIG9mIHNvbGlkYXJpdHkgYW5kIGRlbW9jcmFjeS4KaHR0cDovL3d3dy5pbnRlcm5hdGlvbmFsc29jaWFsaXN0Lm9yZy8=', '2017-07-31 03:37:28'),
  52. (41, 3, 'SOCIALIST PARTY USA', 'PlRIRSBTT0NJQUxJU1QgUEFSVFkgc3RyaXZlcyB0byBlc3RhYmxpc2ggYSByYWRpY2FsIGRlbW9jcmFjeSB0aGF0IHBsYWNlcyBwZW9wbGUncyBsaXZlcyB1bmRlciB0aGVpciBvd24gY29udHJvbCAtLSBhIG5vbi1yYWNpc3QsIGNsYXNzbGVzcywgZmVtaW5pc3QsIHNvY2lhbGlzdCBzb2NpZXR5IGluIHdoaWNoIHBlb3BsZSBjb29wZXJhdGUgYXQgd29yaywgYXQgaG9tZSwgYW5kIGluIHRoZSBjb21tdW5pdHkuCmh0dHBzOi8vd3d3LnNvY2lhbGlzdHBhcnR5dXNhLm5ldC8=', '2017-07-31 03:54:37'),
  53. (42, 2, 'Redneck Revolt MI', 'SVROOiBTaGVsdGVyZWQgcmljaCBraWRkaWVzIHByZXRlbmQgdG8gaGF2ZSBqb2JzIGFuZCByZXByZXNlbnQgdGhlIHdvcmtpbmcgY2xhc3MKPlRoaXMgcHJvamVjdCB3YXMgZm91bmRlZCBpbiBKdW5lIDIwMTYsIGJ5IHNldmVyYWwgbWVtYmVycyBvZiBwcmV2aW91cyBzaW1pbGFyIGNvbW11bml0eSBkZWZlbnNlIGZvcm1hdGlvbnMgaW4gS2Fuc2FzIGFuZCBDb2xvcmFkby4gV2UgaGF2ZSAzMCsgdmV0dGVkIGJyYW5jaGVzLCB1bml0ZWQgdW5kZXIgb3VyIGNvbW1vbiBnb2FscyBhcyBvdXRsaW5lZCBpbiBvdXIgcHJpbmNpcGxlcywgYW5kIG9yZ2FuaXplZCB0aHJvdWdoIGEgY29sbGFib3JhdGl2ZWx5IGJ1aWx0IG5hdGlvbmFsIG5ldHdvcmsuCmh0dHBzOi8vd3d3LmZhY2Vib29rLmNvbS9Ob3J0aGVybi1Mb3dlci1NaWNoaWdhbi1SZWRuZWNrUmV2b2x0LTI5NjE5MzMzNDE3MDU2OC8KVGhleSBkb24ndCBldmVuIGhhdmUgYSByZWFsIHdlYnNpdGUgZm9yIHRoZWlyIGJyYW5jaGVzLg==', '2017-07-31 05:18:53'),
  54. (43, 3, 'By Any Means Necessary', 'Q29hbGl0aW9uIHRvIERlZmVuZCBBZmZpcm1hdGl2ZSBBY3Rpb24sIEludGVncmF0aW9uICYgSW1taWdyYW50IFJpZ2h0cyBhbmQgRmlnaHQgZm9yIEVxdWFsaXR5IEJ5IEFueSBNZWFucyBOZWNlc3NhcnkuIA==', '2017-08-09 17:07:21'),
  55. (44, 0, 'BENJAMIN PHILLIPS', 'U29tZWhvdyBhZmZpbGlhdGVkIHdpdGggQkFNTiBhbmQgYSBwb3NzaWJsZSBrZXkgbGVhZGVyLg==', '2017-08-09 17:06:02'),
  56. (45, 2, 'http://www.unicornriot.ninja/', 'QW4gYXV0aXN0aWMgbGliZXJhbCBuZXdzIHdlYnNpdGUuDQo+VW5pY29ybiBSaW90IGlzIGEgdm9sdW50ZWVyLW9wZXJhdGVkIGRlY2VudHJhbGl6ZWQgbWVkaWEgY29sbGVjdGl2ZSBjb21wcmlzZWQgb2YgbXVsdGltZWRpYSBhcnRpc3RzIGFuZCBqb3VybmFsaXN0cy4gQm9ybiBmcm9tIHRoZSBJbnRlcm5ldCBpbiAyMDE1LCB3ZSBvcGVyYXRlIG5vbi1oaWVyYXJjaGljYWxseSwgaW5kZXBlbmRlbnQgb2YgY29ycG9yYXRlIGFuZCBnb3Zlcm5tZW50IGZ1bmRpbmcuIE91ciBub24tcHJvZml0IG1lZGlhIG9yZ2FuaXphdGlvbiBjdXJyZW50bHkgc3BhbnMgYWNyb3NzIG11bHRpcGxlIFVTIGNpdGllcyBpbmNsdWRpbmcgQm9zdG9uLCBEZW52ZXIsIE1pbm5lYXBvbGlzLCBhbmQgTmV3IFlvcmsgQ2l0eS4gDQo+VW5pY29ybiBSaW904oCZcyBwdXJwb3NlIGlzIHRvIGFtcGxpZnkgdGhlIHZvaWNlcyBvZiBwZW9wbGUgd2hvIG1pZ2h0IG90aGVyd2lzZSBnbyB1bmhlYXJkLCBhbmQgYnJvYWRjYXN0IHRoZSBzdG9yaWVzIHRoYXQgbWlnaHQgb3RoZXJ3aXNlIGdvIHVudG9sZCwgYXMgd2UgZnVydGhlciB1bmRlcnN0YW5kaW5nIG9mIGR5bmFtaWMgc29jaWFsIHN0cnVnZ2xlcy4gV2UgYXJlIGNvbW1pdHRlZCB0byBwcm9kdWNpbmcgbWVkaWEgdGhhdCBleHBvc2VzIHJvb3QgY2F1c2VzIG9mIHNvY2lhbCBjb25mbGljdCBhbmQgZXhwbG9yZXMgc3VzdGFpbmFibGUgYWx0ZXJuYXRpdmVzIGluIHRvZGF54oCZcyBnbG9iYWxpemVkIHdvcmxkLg==', '2017-08-15 02:49:07'),
  57. (46, 2, 'Popular resistance', 'UG9wdWxhclJlc2lzdGFuY2Uub3JnIHNlZWtzIHRvIGFpZCBpbiBicmluZ2luZyBtb3ZlbWVudHMgZm9yIHBlYWNlLCBqdXN0aWNlLCBlY29ub21pYyBmYWlybmVzcyBhbmQgZW52aXJvbm1lbnRhbCBwcm90ZWN0aW9uIHRvZ2V0aGVyIGludG8gYW4gaW5kZXBlbmRlbnQsIG5vbnZpb2xlbnQgYW5kIGRpdmVyc2UgbW92ZW1lbnQgdGhhdCBjYW4gZW5kIHRoZSBwb3dlciBvZiBjb25jZW50cmF0ZWQgd2VhbHRoLCBzaGlmdCBwb3dlciB0byB0aGUgcGVvcGxlIGFuZCBwdXQgaHVtYW4gbmVlZHMgYmVmb3JlIGNvcnBvcmF0ZSBncmVlZC4=', '2017-08-25 13:18:41'),
  58. (47, 2, 'The Base', 'VGhlIEJhc2UgaXMgYW4gYW5hcmNoaXN0IHBvbGl0aWNhbCBjZW50ZXIgaW4gQnVzaHdpY2ssIEJyb29rbHluLCBjb21taXR0ZWQgdG8gdGhlIGRpc3NlbWluYXRpb24gb2YgcmV2b2x1dGlvbmFyeSBsZWZ0IGFuZCBhbmFyY2hpc3QgaWRlYXMgYW5kIG9yZ2FuaXppbmcuIFRoZSBtaXNzaW9uIG9mIHRoZSBzcGFjZSBpcyB0byBzcHJlYWQgaWRlYXMgYW5kIHByYWN0aWNlcyB0byB0aGUgYnJvYWRlciBwb3B1bGFjZSBhbmQgcHJvdmlkZSBhIHBsYWNlIHdoZXJlIGluZGl2aWR1YWxzIGNhbiBsZWFybiwgZ3JvdywgYW5kIG9yZ2FuaXplIG91dHNpZGUgb2YgdHJhZGl0aW9uYWwgYWN0aXZpc3QgYW5kIGVkdWNhdGlvbmFsIGluc3RpdHV0aW9ucy4gV2Ugd2lsbCBwcm92aWRlIGEgZm91bmRhdGlvbiBmb3IgZm9zdGVyaW5nIHRoZSBpZGVhcyBhbmQgdGhlb3J5IG9mIHBlb3BsZSB3aG8gaGF2ZSBlaXRoZXIgYSBwcmVsaW1pbmFyeSBiYWNrZ3JvdW5kIGluIHBvbGl0aWNhbCB0aG91Z2h0LCBvciB3aG8gaGF2ZSBub3QgZ3JhcHBsZWQgd2l0aCBwb2xpdGljYWwgdGhlb3J5IGF0IGFueSBsZXZlbC4gRnVydGhlcm1vcmUsIHdlIHdpbGwgZXN0YWJsaXNoIGEgZnJhbWV3b3JrIHdoZXJlIGNyZWF0aXZlIG1vZGVzIG9mIHNoYXJpbmcgd2lsbCBiZSBlbmNvdXJhZ2VkLCB3aXRoIHRoZSBnb2FsIG9mIHNwcmVhZGluZyB0aGVzZSBtb2RlcyBiZXlvbmQgdGhlIGNvbmZpbmVzIG9mIHRoZSBzcGFjZSBpdHNlbGYuIFdlIGludGVuZCB0byBlc3RhYmxpc2ggYSBzb2Npb3BvbGl0aWNhbCBtb2RlbCBpbiBOZXcgWW9yayBDaXR5IHdoZXJlIHBhcnRpY2lwYW50cyBjYW4gY3JlYXRlIHByb2plY3RzIHRoYXQgYXJlIGV4cGFuc2l2ZSBhbmQgY3JlYXRpdmUuIExhc3RseSwgdGhpcyB3aWxsIGJlIGEgcGxhY2Ugd2hlcmUgcGVvcGxlIGNhbiBncmFwcGxlIHdpdGgsIG9yZ2FuaXplLCBhbmQgZmluZCBzb2x1dGlvbnMgdG8gaXNzdWVzIHRoYXQgYWZmZWN0IHRoZWlyIGxpdmluZyBzaXR1YXRpb24gaW4gYSBjb25zdHJ1Y3RpdmUgZW52aXJvbm1lbnQu', '2017-09-07 12:05:30');
  59.  
  60. -- --------------------------------------------------------
  61.  
  62. --
  63. -- Table structure for table `descriptors`
  64. --
  65.  
  66. CREATE TABLE IF NOT EXISTS `descriptors` (
  67. `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'AI tracker for table.',
  68. `pointer` int(11) NOT NULL COMMENT 'what node this information describes',
  69. `attribute` text NOT NULL COMMENT 'The type of information. Reffer to documentation for a full list of default values. Custom values can be put here, although not reccomended.',
  70. `information` mediumtext NOT NULL COMMENT 'in information relivant to the attribute. For example, an email would be put here if an email attribute was specified.',
  71. `lastupdated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The last time information about this descriptor was updated.',
  72. PRIMARY KEY (`id`)
  73. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='attributes that hold information about each group' AUTO_INCREMENT=126 ;
  74.  
  75. --
  76. -- Dumping data for table `descriptors`
  77. --
  78.  
  79. INSERT INTO `descriptors` (`id`, `pointer`, `attribute`, `information`, `lastupdated`) VALUES
  80. (64, 24, 'email', 'info@grassrootscampaigns.com', '2017-07-31 01:30:10'),
  81. (65, 24, 'phone', '(734) 887-6657', '2017-07-31 01:30:10'),
  82. (66, 24, 'address', '186 Lincoln St. First Floor Boston, MA 02111', '2017-07-31 01:30:10'),
  83. (67, 25, 'email', 'recruitment@redneckrevolt.org, education@redneckrevolt.org, communication@redneckrevolt.org', '2017-07-31 01:30:10'),
  84. (70, 26, 'email', 'ryan@iheartryan.com or GNEBULON@YAHOO.COM', '2017-07-31 01:30:11'),
  85. (71, 26, 'phone', '734-272-9677 or 7349965970', '2017-07-31 01:30:11'),
  86. (72, 26, 'address', '900 OAKLAND AVE, ANN ARBOR MI 48104 US ', '2017-07-31 01:30:11'),
  87. (73, 27, 'email', 'southsidechicagoara@hushmail.com', '2017-07-31 01:30:11'),
  88. (75, 27, 'address', 'Chicago', '2017-07-31 01:30:11'),
  89. (76, 28, 'email', 'antiracistaction_la@yahoo.com', '2017-07-31 01:30:11'),
  90. (78, 28, 'address', 'Los Angeles', '2017-07-31 01:30:11'),
  91. (79, 29, 'email', 'archcity@antiracistaction.org', '2017-07-31 01:30:11'),
  92. (81, 29, 'address', 'Columbus Ohio', '2017-07-31 01:30:11'),
  93. (82, 30, 'email', 'dlj@oppforum.com (?)', '2017-07-31 01:30:11'),
  94. (83, 30, 'phone', '(215) 501-7958 or 2679820039', '2017-07-31 01:30:11'),
  95. (84, 30, 'address', 'PO Box 42817, Philadelphia, PA, 19101', '2017-07-31 01:30:11'),
  96. (85, 31, 'email', 'rockymountainantifa@riseup.net', '2017-07-31 01:30:11'),
  97. (87, 31, 'address', 'Colorado', '2017-07-31 01:30:11'),
  98. (88, 32, 'email', 'fight_them_back@riseup.net ', '2017-07-31 01:30:11'),
  99. (90, 32, 'address', 'Oregon', '2017-07-31 01:30:12'),
  100. (91, 33, 'email', 'info@socialistworker.org', '2017-07-31 01:30:12'),
  101. (93, 33, 'address', 'SW, P.O. Box 16085, Chicago, IL 60616', '2017-07-31 01:30:12'),
  102. (94, 34, 'email', 'ChicagoSocialists@gmail.com', '2017-07-31 01:30:12'),
  103. (96, 34, 'address', 'Chicago', '2017-07-31 01:30:12'),
  104. (98, 35, 'phone', '812-727-0392', '2017-07-31 01:30:12'),
  105. (99, 35, 'address', '1461 W. Bloomfield Rd. Bloomington, IN 47403', '2017-07-31 01:30:12'),
  106. (100, 36, 'Website', 'https://torchantifa.org/', '2017-08-09 03:32:47'),
  107. (101, 43, 'Website', 'http://www.bamn.com/', '2017-08-09 17:03:15'),
  108. (102, 43, 'Phone', '855-275-2266', '2017-08-09 17:03:42'),
  109. (103, 43, 'Phone', '4156269438', '2017-08-09 17:05:05'),
  110. (104, 43, 'Address', '438 W. GRAND AVENUE #616, OAKLAND CALIFORNIA 94612-2335 US ', '2017-08-09 17:05:18'),
  111. (105, 44, 'Address', '438 W. GRAND AVENUE #616, OAKLAND CALIFORNIA 94612-2335 US ', '2017-08-09 17:06:17'),
  112. (106, 44, 'Phone', '4156269438', '2017-08-09 17:06:28'),
  113. (107, 44, 'Email', 'BENJAMINDAVIDPHILLIPS@GMAIL.COM', '2017-08-09 17:06:37'),
  114. (108, 45, 'Website', 'http://www.unicornriot.ninja/', '2017-08-15 02:49:34'),
  115. (109, 45, 'Address', 'Unicorn Riot PO Box 7472 Minneapolis, MN 55407', '2017-08-15 02:51:03'),
  116. (110, 35, 'Website', 'https://www.hoosieraction.org/', '2017-08-21 00:59:10'),
  117. (111, 46, 'Website', 'popularresistance.org', '2017-08-25 13:19:05'),
  118. (112, 46, 'RSS2', 'https://popularresistance.org/feed/', '2017-08-25 13:20:20'),
  119. (113, 46, 'Facebook', 'http://www.facebook.com/pages/Stop-the-Machine-Create-a-New-World/128235120588487', '2017-08-25 13:20:41'),
  120. (114, 46, 'Twitter', 'https://twitter.com/popresistance', '2017-08-25 13:20:57'),
  121. (115, 35, 'Email', 'dpace44@gmail.com', '2017-08-27 20:51:56'),
  122. (116, 47, 'Website', 'https://thebasebk.org/', '2017-09-07 12:06:02'),
  123. (117, 47, 'Address', '1302 Myrtle Ave Brooklyn, NY 11221', '2017-09-07 12:06:21'),
  124. (118, 47, 'Twitter', 'https://twitter.com/TheBaseBK', '2017-09-07 12:08:46'),
  125. (119, 28, 'Website', 'https://ara-la.tumblr.com/', '2017-09-11 13:12:33'),
  126. (120, 28, 'Website', 'https://antiracist.org/', '2017-09-11 13:12:40'),
  127. (124, 30, 'Website', 'https://fundrazr.com/opproject', '2017-09-13 19:32:48'),
  128. (125, 30, 'Website', 'https://www.gofundme.com/onepeoplesproject', '2017-09-13 19:32:59');
  129.  
  130. -- desu desu
  131. -- desu ......... desu
  132. -- desu .............. desu
  133. -- desu .............. desu
  134. -- desu .............. desu
  135. -- desu ......... desu
  136. -- desu desu
  137.  
  138. -- desu desu desu
  139. -- desu
  140. -- desu
  141. -- desu desu
  142. -- desu
  143. -- desu
  144. -- desu desu desu
  145.  
  146. -- ... desu desu
  147. -- desu
  148. -- desu
  149. -- .... desu desu
  150. -- ............ desu
  151. -- ............ desu
  152. -- desu desu
  153.  
  154. -- desu ........ desu
  155. -- desu ........ desu
  156. -- desu ........ desu
  157. -- desu ........ desu
  158. -- desu ........ desu
  159. -- .... desu desu
  160.  
  161. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  162. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  163. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!