· 8 years ago · Sep 17, 2017, 10:18 PM
1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET 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
20CREATE 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
33INSERT 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
66CREATE 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
79INSERT 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 */;