Advertisement
Guest User

Untitled

a guest
Feb 11th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. CREATE TABLE `linktable` (
  2. `id1` bigint(20) unsigned NOT NULL DEFAULT '0',
  3. `id1_type` int(10) unsigned NOT NULL DEFAULT '0',
  4. `id2` bigint(20) unsigned NOT NULL DEFAULT '0',
  5. `id2_type` int(10) unsigned NOT NULL DEFAULT '0',
  6. `link_type` bigint(20) unsigned NOT NULL DEFAULT '0',
  7. `visibility` tinyint(3) NOT NULL DEFAULT '0',
  8. `data` varchar(255) NOT NULL DEFAULT '',
  9. `time` bigint(20) unsigned NOT NULL DEFAULT '0',
  10. `version` int(11) unsigned NOT NULL DEFAULT '0',
  11. PRIMARY KEY (link_type, `id1`,`id2`) COMMENT 'cf_link_pk',
  12. KEY `id1_type` (`id1`,`link_type`,`visibility`,`time`,`id2`,`version`,`data`) COMMENT 'rev:cf_link_id1_type'
  13. ) ENGINE=RocksDB DEFAULT COLLATE=latin1_bin;
  14.  
  15. CREATE TABLE `counttable` (
  16. `id` bigint(20) unsigned NOT NULL DEFAULT '0',
  17. `id_type` int(10) unsigned NOT NULL DEFAULT '0',
  18. `link_type` bigint(20) unsigned NOT NULL DEFAULT '0',
  19. `count` int(10) unsigned NOT NULL DEFAULT '0',
  20. `time` bigint(20) unsigned NOT NULL DEFAULT '0',
  21. `version` bigint(20) unsigned NOT NULL DEFAULT '0',
  22. PRIMARY KEY (`id`,`link_type`) COMMENT 'cf_count_pk'
  23. ) ENGINE=RocksDB DEFAULT COLLATE=latin1_bin;
  24.  
  25. CREATE TABLE `nodetable` (
  26. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  27. `type` int(10) unsigned NOT NULL,
  28. `version` bigint(20) unsigned NOT NULL,
  29. `time` int(10) unsigned NOT NULL,
  30. `data` mediumtext NOT NULL,
  31. primary key(`id`) COMMENT 'cf_node_pk'
  32. ) ENGINE=RocksDB DEFAULT COLLATE=latin1_bin;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement