API tools faq
paste
olegbo

Untitled

olegbo
Aug 6th, 2020
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 29.27 KB | None | 0 0
raw download clone embed print report
  1. -- Create syntax for TABLE '4sq_checkin'
  2. CREATE TABLE `4sq_checkin` (
  3.   `id` int(11) NOT NULL AUTO_INCREMENT,
  4.   `4sq_user_id` int(11) DEFAULT NULL,
  5.   `lat` decimal(20,16) NOT NULL,
  6.   `lng` decimal(20,16) NOT NULL,
  7.   `name` varchar(256) COLLATE utf8mb4_unicode_ci NOT NULL,
  8.   `cr_date` datetime DEFAULT NULL,
  9.   `user_id` int(11) unsigned DEFAULT NULL,
  10.   `4sq_checkin_id` varchar(48) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  11.   `checkin_json` longtext COLLATE utf8mb4_unicode_ci,
  12.   `venue_id` char(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  13.   PRIMARY KEY (`id`),
  14.   KEY `4sq_checkin_df07e4e7` (`lat`,`lng`),
  15.   KEY `4sq_checkin_96511a37` (`cr_date`),
  16.   KEY `user_id_refs_uid_a754358d` (`user_id`),
  17.   CONSTRAINT `user_id_refs_uid_a754358d` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  18. ) ENGINE=InnoDB AUTO_INCREMENT=9889 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  19.  
  20. -- Create syntax for TABLE 'auth_group'
  21. CREATE TABLE `auth_group` (
  22.   `id` int(11) NOT NULL AUTO_INCREMENT,
  23.   `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  24.   PRIMARY KEY (`id`),
  25.   UNIQUE KEY `name` (`name`)
  26. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  27.  
  28. -- Create syntax for TABLE 'auth_group_permissions'
  29. CREATE TABLE `auth_group_permissions` (
  30.   `id` int(11) NOT NULL AUTO_INCREMENT,
  31.   `group_id` int(11) NOT NULL,
  32.   `permission_id` int(11) NOT NULL,
  33.   PRIMARY KEY (`id`),
  34.   UNIQUE KEY `group_id` (`group_id`,`permission_id`),
  35.   KEY `auth_group_permissions_5f412f9a` (`group_id`),
  36.   KEY `auth_group_permissions_83d7f98b` (`permission_id`),
  37.   CONSTRAINT `group_id_refs_id_f4b32aac` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  38.   CONSTRAINT `permission_id_refs_id_6ba0f519` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  39. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  40.  
  41. -- Create syntax for TABLE 'auth_permission'
  42. CREATE TABLE `auth_permission` (
  43.   `id` int(11) NOT NULL AUTO_INCREMENT,
  44.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  45.   `content_type_id` int(11) NOT NULL,
  46.   `codename` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  47.   PRIMARY KEY (`id`),
  48.   UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),
  49.   KEY `auth_permission_37ef4eb4` (`content_type_id`)
  50. ) ENGINE=InnoDB AUTO_INCREMENT=280 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  51.  
  52. -- Create syntax for TABLE 'auth_user'
  53. CREATE TABLE `auth_user` (
  54.   `id` int(11) NOT NULL AUTO_INCREMENT,
  55.   `password` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  56.   `last_login` datetime DEFAULT NULL,
  57.   `is_superuser` tinyint(1) NOT NULL,
  58.   `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  59.   `first_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  60.   `last_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  61.   `email` varchar(254) COLLATE utf8mb4_unicode_ci NOT NULL,
  62.   `is_staff` tinyint(1) NOT NULL,
  63.   `is_active` tinyint(1) NOT NULL,
  64.   `date_joined` datetime NOT NULL,
  65.   PRIMARY KEY (`id`),
  66.   UNIQUE KEY `username` (`username`)
  67. ) ENGINE=InnoDB AUTO_INCREMENT=3738 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  68.  
  69. -- Create syntax for TABLE 'auth_user_groups'
  70. CREATE TABLE `auth_user_groups` (
  71.   `id` int(11) NOT NULL AUTO_INCREMENT,
  72.   `user_id` int(11) NOT NULL,
  73.   `group_id` int(11) NOT NULL,
  74.   PRIMARY KEY (`id`),
  75.   UNIQUE KEY `user_id` (`user_id`,`group_id`),
  76.   KEY `auth_user_groups_6340c63c` (`user_id`),
  77.   KEY `auth_user_groups_5f412f9a` (`group_id`),
  78.   CONSTRAINT `group_id_refs_id_274b862c` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  79.   CONSTRAINT `user_id_refs_id_40c41112` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  80. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  81.  
  82. -- Create syntax for TABLE 'auth_user_user_permissions'
  83. CREATE TABLE `auth_user_user_permissions` (
  84.   `id` int(11) NOT NULL AUTO_INCREMENT,
  85.   `user_id` int(11) NOT NULL,
  86.   `permission_id` int(11) NOT NULL,
  87.   PRIMARY KEY (`id`),
  88.   UNIQUE KEY `user_id` (`user_id`,`permission_id`),
  89.   KEY `auth_user_user_permissions_6340c63c` (`user_id`),
  90.   KEY `auth_user_user_permissions_83d7f98b` (`permission_id`),
  91.   CONSTRAINT `permission_id_refs_id_35d9ac25` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  92.   CONSTRAINT `user_id_refs_id_4dc23c39` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  93. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  94.  
  95. -- Create syntax for TABLE 'code_sent_history'
  96. CREATE TABLE `code_sent_history` (
  97.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  98.   `datetime` datetime NOT NULL,
  99.   `phone` decimal(16,0) NOT NULL,
  100.   `text` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  101.   `ip` varchar(39) CHARACTER SET ascii NOT NULL,
  102.   `method` enum('NexmoSMS','NexmoTTS','TwilioSMS') NOT NULL,
  103.   PRIMARY KEY (`id`)
  104. ) ENGINE=InnoDB AUTO_INCREMENT=4683 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  105.  
  106. -- Create syntax for TABLE 'currency'
  107. CREATE TABLE `currency` (
  108.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  109.   `currency` char(5) CHARACTER SET ascii NOT NULL DEFAULT '',
  110.   `cur_description` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  111.   `exchange_rate` decimal(12,6) DEFAULT NULL,
  112.   PRIMARY KEY (`id`),
  113.   UNIQUE KEY `idx_currency` (`currency`)
  114. ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  115.  
  116. -- Create syntax for TABLE 'currency_currency'
  117. CREATE TABLE `currency_currency` (
  118.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  119.   `currency1` char(3) CHARACTER SET ascii NOT NULL DEFAULT '',
  120.   `currency2` char(3) CHARACTER SET ascii NOT NULL DEFAULT '',
  121.   `exchange_rate` decimal(30,18) DEFAULT NULL,
  122.   PRIMARY KEY (`id`),
  123.   UNIQUE KEY `idx_currency_currency` (`currency1`,`currency2`),
  124.   KEY `fk_currency_currency2` (`currency2`),
  125.   CONSTRAINT `fk_currency_currency1` FOREIGN KEY (`currency1`) REFERENCES `currency` (`currency`),
  126.   CONSTRAINT `fk_currency_currency2` FOREIGN KEY (`currency2`) REFERENCES `currency` (`currency`)
  127. ) ENGINE=InnoDB AUTO_INCREMENT=32762 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  128.  
  129. -- Create syntax for TABLE 'django_admin_log'
  130. CREATE TABLE `django_admin_log` (
  131.   `id` int(11) NOT NULL AUTO_INCREMENT,
  132.   `action_time` datetime NOT NULL,
  133.   `user_id` int(11) NOT NULL,
  134.   `content_type_id` int(11) DEFAULT NULL,
  135.   `object_id` longtext COLLATE utf8mb4_unicode_ci,
  136.   `object_repr` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  137.   `action_flag` smallint(5) unsigned NOT NULL,
  138.   `change_message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  139.   PRIMARY KEY (`id`),
  140.   KEY `django_admin_log_6340c63c` (`user_id`),
  141.   KEY `django_admin_log_37ef4eb4` (`content_type_id`),
  142.   CONSTRAINT `content_type_id_refs_id_93d2d1f8` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type1` (`id`),
  143.   CONSTRAINT `user_id_refs_id_c0d12874` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
  144. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  145.  
  146. -- Create syntax for TABLE 'django_content_type'
  147. CREATE TABLE `django_content_type` (
  148.   `id` int(11) NOT NULL AUTO_INCREMENT,
  149.   `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  150.   `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  151.   `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  152.   PRIMARY KEY (`id`)
  153. ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  154.  
  155. -- Create syntax for TABLE 'django_content_type1'
  156. CREATE TABLE `django_content_type1` (
  157.   `id` int(11) NOT NULL AUTO_INCREMENT,
  158.   `app_label` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  159.   `model` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  160.   PRIMARY KEY (`id`),
  161.   UNIQUE KEY `app_label` (`app_label`,`model`)
  162. ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  163.  
  164. -- Create syntax for TABLE 'django_cron_cronjoblog'
  165. CREATE TABLE `django_cron_cronjoblog` (
  166.   `id` int(11) NOT NULL AUTO_INCREMENT,
  167.   `code` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  168.   `start_time` datetime NOT NULL,
  169.   `end_time` datetime NOT NULL,
  170.   `is_success` tinyint(1) NOT NULL,
  171.   `message` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  172.   `ran_at_time` time DEFAULT NULL,
  173.   PRIMARY KEY (`id`),
  174.   KEY `django_cron_cronjoblog_09bb5fb3` (`code`),
  175.   KEY `django_cron_cronjoblog_66db471f` (`start_time`),
  176.   KEY `django_cron_cronjoblog_a3457057` (`end_time`),
  177.   KEY `django_cron_cronjoblog_164a3ee7` (`ran_at_time`),
  178.   KEY `django_cron_cronjoblog_63e2740d` (`code`,`is_success`,`ran_at_time`),
  179.   KEY `django_cron_cronjoblog_1fe0e40b` (`code`,`start_time`,`ran_at_time`),
  180.   KEY `django_cron_cronjoblog_495fb183` (`code`,`start_time`)
  181. ) ENGINE=InnoDB AUTO_INCREMENT=43454 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  182.  
  183. -- Create syntax for TABLE 'django_migrations'
  184. CREATE TABLE `django_migrations` (
  185.   `id` int(11) NOT NULL AUTO_INCREMENT,
  186.   `app` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  187.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  188.   `applied` datetime NOT NULL,
  189.   PRIMARY KEY (`id`)
  190. ) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  191.  
  192. -- Create syntax for TABLE 'django_session'
  193. CREATE TABLE `django_session` (
  194.   `session_key` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  195.   `session_data` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  196.   `expire_date` datetime NOT NULL,
  197.   PRIMARY KEY (`session_key`),
  198.   KEY `django_session_b7b81f0c` (`expire_date`)
  199. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  200.  
  201. -- Create syntax for TABLE 'django_site'
  202. CREATE TABLE `django_site` (
  203.   `id` int(11) NOT NULL AUTO_INCREMENT,
  204.   `domain` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  205.   `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  206.   PRIMARY KEY (`id`),
  207.   UNIQUE KEY `django_site_domain_a2e37b91_uniq` (`domain`)
  208. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  209.  
  210. -- Create syntax for TABLE 'event'
  211. CREATE TABLE `event` (
  212.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  213.   `event_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  214.   `cr_date` datetime NOT NULL,
  215.   `owner_id` int(11) unsigned NOT NULL,
  216.   `del_date` datetime DEFAULT NULL,
  217.   `mod_date` datetime NOT NULL,
  218.   `image_url` varchar(512) CHARACTER SET ascii DEFAULT NULL,
  219.   `second_owner_id` int(11) unsigned DEFAULT NULL,
  220.   `checkin_id` int(11) DEFAULT NULL,
  221.   `venue_id` char(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  222.   PRIMARY KEY (`id`),
  223.   UNIQUE KEY `idx_owner_second_owner` (`owner_id`,`second_owner_id`),
  224.   KEY `event_owner` (`owner_id`),
  225.   KEY `second_event_owner` (`second_owner_id`),
  226.   KEY `fk_event_checkin` (`checkin_id`),
  227.   KEY `event_del_date_f5c48f03` (`del_date`),
  228.   CONSTRAINT `event_owner` FOREIGN KEY (`owner_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE,
  229.   CONSTRAINT `fk_event_checkin` FOREIGN KEY (`checkin_id`) REFERENCES `4sq_checkin` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  230.   CONSTRAINT `second_event_owner` FOREIGN KEY (`second_owner_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  231. ) ENGINE=InnoDB AUTO_INCREMENT=102225 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;
  232.  
  233. -- Create syntax for TABLE 'event_user'
  234. CREATE TABLE `event_user` (
  235.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  236.   `user_id` int(11) unsigned NOT NULL DEFAULT '0',
  237.   `event_id` int(11) unsigned NOT NULL DEFAULT '0',
  238.   `family_head_id` int(10) unsigned DEFAULT NULL,
  239.   `is_subscriber` tinyint(1) DEFAULT '0',
  240.   PRIMARY KEY (`id`),
  241.   UNIQUE KEY `event_agent` (`user_id`,`event_id`),
  242.   KEY `fk_event_user_event` (`event_id`),
  243.   KEY `fk_event_user_family_head_id` (`family_head_id`),
  244.   CONSTRAINT `fk_event_user_event` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  245.   CONSTRAINT `fk_event_user_family_head_id` FOREIGN KEY (`family_head_id`) REFERENCES `event_user` (`id`) ON DELETE SET NULL ON UPDATE SET NULL,
  246.   CONSTRAINT `fk_event_user_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  247. ) ENGINE=InnoDB AUTO_INCREMENT=106115 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  248.  
  249. -- Create syntax for TABLE 'google_credential'
  250. CREATE TABLE `google_credential` (
  251.   `package_name` varchar(127) COLLATE utf8mb4_unicode_ci NOT NULL,
  252.   `credential` longtext COLLATE utf8mb4_unicode_ci,
  253.   PRIMARY KEY (`package_name`)
  254. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  255.  
  256. -- Create syntax for TABLE 'invitation_sent_history'
  257. CREATE TABLE `invitation_sent_history` (
  258.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  259.   `sent_at` datetime NOT NULL,
  260.   `phone` decimal(16,0) NOT NULL,
  261.   PRIMARY KEY (`id`)
  262. ) ENGINE=InnoDB AUTO_INCREMENT=991 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  263.  
  264. -- Create syntax for TABLE 'last_updated'
  265. CREATE TABLE `last_updated` (
  266.   `id` int(11) NOT NULL AUTO_INCREMENT,
  267.   `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  268.   `time` datetime NOT NULL,
  269.   PRIMARY KEY (`id`)
  270. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  271.  
  272. -- Create syntax for TABLE 'move'
  273. CREATE TABLE `move` (
  274.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  275.   `operation_id` int(11) unsigned NOT NULL,
  276.   `pair_id` int(11) unsigned DEFAULT NULL,
  277.   `owner_id` int(11) unsigned NOT NULL,
  278.   `amount` decimal(12,4) NOT NULL,
  279.   `currency` char(5) CHARACTER SET ascii NOT NULL DEFAULT '',
  280.   `is_payee` tinyint(1) NOT NULL,
  281.   `del_date` datetime DEFAULT NULL,
  282.   `event_id` int(11) unsigned NOT NULL,
  283.   `move_type` enum('real','virtual') CHARACTER SET ascii NOT NULL DEFAULT 'real',
  284.   `move_kind` enum('usual','tips','service_fee') CHARACTER SET ascii NOT NULL DEFAULT 'usual',
  285.   PRIMARY KEY (`id`),
  286.   KEY `idx_pair_id` (`pair_id`) USING BTREE,
  287.   KEY `idx_full` (`event_id`,`owner_id`,`del_date`) USING BTREE,
  288.   KEY `idx_agent_id` (`owner_id`) USING BTREE,
  289.   KEY `fk_move_operation` (`operation_id`) USING BTREE,
  290.   KEY `fk_move_currency` (`currency`) USING BTREE,
  291.   KEY `idx_del_date` (`del_date`),
  292.   KEY `move_del_date_9e81433b` (`del_date`),
  293.   KEY `idx_operation_id` (`operation_id`),
  294.   KEY `move_currency_3269f515` (`currency`),
  295.   KEY `move_move_type_a81f700f` (`move_type`)
  296. ) ENGINE=InnoDB AUTO_INCREMENT=225975 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  297.  
  298. -- Create syntax for TABLE 'move_backup'
  299. CREATE TABLE `move_backup` (
  300.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  301.   `operation_id` int(11) unsigned NOT NULL,
  302.   `pair_id` int(11) unsigned DEFAULT NULL,
  303.   `owner_id` int(11) unsigned NOT NULL,
  304.   `amount` decimal(12,4) NOT NULL,
  305.   `is_payee` tinyint(1) NOT NULL,
  306.   `del_date` datetime DEFAULT NULL,
  307.   `event_id` int(11) unsigned NOT NULL,
  308.   `currency` char(3) CHARACTER SET ascii NOT NULL DEFAULT '',
  309.   `move_type` enum('real','virtual') CHARACTER SET ascii NOT NULL DEFAULT 'real',
  310.   `move_kind` enum('usual','tips','service_fee') CHARACTER SET ascii NOT NULL DEFAULT 'usual',
  311.   PRIMARY KEY (`id`),
  312.   KEY `idx_pair_id` (`pair_id`),
  313.   KEY `idx_full` (`event_id`,`owner_id`,`del_date`),
  314.   KEY `idx_agent_id` (`owner_id`),
  315.   KEY `fk_move_operation` (`operation_id`),
  316.   KEY `fk_move_currency` (`currency`),
  317.   CONSTRAINT `fk_move_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
  318.   CONSTRAINT `fk_move_operation` FOREIGN KEY (`operation_id`) REFERENCES `operation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  319.   CONSTRAINT `fk_move_owner` FOREIGN KEY (`owner_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  320. ) ENGINE=InnoDB AUTO_INCREMENT=138058 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  321.  
  322. -- Create syntax for TABLE 'move_old'
  323. CREATE TABLE `move_old` (
  324.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  325.   `operation_id` int(11) unsigned NOT NULL,
  326.   `pair_id` int(11) unsigned DEFAULT NULL,
  327.   `owner_id` int(11) unsigned NOT NULL,
  328.   `amount` decimal(12,4) NOT NULL,
  329.   `is_payee` tinyint(1) NOT NULL,
  330.   `del_date` datetime DEFAULT NULL,
  331.   `event_id` int(11) unsigned DEFAULT NULL,
  332.   `currency` char(3) NOT NULL DEFAULT '',
  333.   `move_type` enum('real','virtual') NOT NULL DEFAULT 'real',
  334.   `move_kind` enum('usual','tips','service_fee') DEFAULT NULL,
  335.   PRIMARY KEY (`id`)
  336. ) ENGINE=InnoDB AUTO_INCREMENT=38165 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
  337.  
  338. -- Create syntax for TABLE 'move2'
  339. CREATE TABLE `move2` (
  340.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  341.   `operation_id` int(11) unsigned NOT NULL,
  342.   `pair_id` int(11) unsigned DEFAULT NULL,
  343.   `owner_id` int(11) unsigned NOT NULL,
  344.   `amount` decimal(12,4) NOT NULL,
  345.   `is_payee` tinyint(1) NOT NULL,
  346.   `del_date` datetime DEFAULT NULL,
  347.   `event_id` int(11) unsigned NOT NULL,
  348.   `currency` char(3) CHARACTER SET ascii NOT NULL DEFAULT '',
  349.   `move_type` enum('real','virtual') CHARACTER SET ascii NOT NULL DEFAULT 'real',
  350.   `move_kind` enum('usual','tips','service_fee') CHARACTER SET ascii NOT NULL DEFAULT 'usual',
  351.   PRIMARY KEY (`id`),
  352.   KEY `idx_pair_id` (`pair_id`) USING BTREE,
  353.   KEY `idx_full` (`event_id`,`owner_id`,`del_date`) USING BTREE,
  354.   KEY `idx_agent_id` (`owner_id`) USING BTREE,
  355.   KEY `fk_move_operation` (`operation_id`) USING BTREE,
  356.   KEY `fk_move_currency` (`currency`) USING BTREE
  357. ) ENGINE=InnoDB AUTO_INCREMENT=139233 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  358.  
  359. -- Create syntax for TABLE 'noevent_pair'
  360. CREATE TABLE `noevent_pair` (
  361.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  362.   `owner_id1` int(11) unsigned NOT NULL,
  363.   `owner_id2` int(11) unsigned NOT NULL,
  364.   `mod_date` datetime NOT NULL,
  365.   `del_date` datetime DEFAULT NULL,
  366.   PRIMARY KEY (`id`),
  367.   KEY `fk_event_pair_owner2` (`owner_id2`),
  368.   KEY `idx_owner1_owner2` (`owner_id1`,`owner_id2`),
  369.   CONSTRAINT `fk_event_pair_owner1` FOREIGN KEY (`owner_id1`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE,
  370.   CONSTRAINT `fk_event_pair_owner2` FOREIGN KEY (`owner_id2`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  371. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  372.  
  373. -- Create syntax for TABLE 'operation'
  374. CREATE TABLE `operation` (
  375.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  376.   `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  377.   `date` datetime DEFAULT NULL,
  378.   `cr_date` datetime NOT NULL,
  379.   `del_date` datetime DEFAULT NULL,
  380.   `owner_id` int(11) unsigned DEFAULT NULL,
  381.   `operation_type` enum('purchase','transfer','exchange','update','deposit','optimization','payback','comment') CHARACTER SET ascii NOT NULL DEFAULT 'purchase',
  382.   `event_id` int(11) unsigned NOT NULL,
  383.   `info` decimal(10,2) DEFAULT NULL,
  384.   `is_personal` tinyint(1) NOT NULL DEFAULT '0',
  385.   `purchase_type` enum('even','split') CHARACTER SET ascii DEFAULT NULL,
  386.   `image_url` varchar(512) CHARACTER SET ascii DEFAULT NULL,
  387.   `checkin_id` int(11) DEFAULT NULL,
  388.   `venue_id` char(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  389.   `is_financial` tinyint(1) unsigned NOT NULL DEFAULT '1',
  390.   PRIMARY KEY (`id`),
  391.   KEY `fk_operation_event` (`event_id`),
  392.   KEY `fk_operation_owner` (`owner_id`),
  393.   KEY `fk_operation_checkin` (`checkin_id`),
  394.   KEY `idx_del_date` (`del_date`),
  395.   KEY `operation_del_date_139f8161` (`del_date`),
  396.   CONSTRAINT `fk_operation_checkin` FOREIGN KEY (`checkin_id`) REFERENCES `4sq_checkin` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  397.   CONSTRAINT `fk_operation_event` FOREIGN KEY (`event_id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  398.   CONSTRAINT `fk_operation_owner` FOREIGN KEY (`owner_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  399. ) ENGINE=InnoDB AUTO_INCREMENT=123964 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;
  400.  
  401. -- Create syntax for TABLE 'silk_profile'
  402. CREATE TABLE `silk_profile` (
  403.   `id` int(11) NOT NULL AUTO_INCREMENT,
  404.   `name` varchar(300) NOT NULL,
  405.   `start_time` datetime(6) NOT NULL,
  406.   `end_time` datetime(6) DEFAULT NULL,
  407.   `time_taken` double DEFAULT NULL,
  408.   `file_path` varchar(300) NOT NULL,
  409.   `line_num` int(11) DEFAULT NULL,
  410.   `end_line_num` int(11) DEFAULT NULL,
  411.   `func_name` varchar(300) NOT NULL,
  412.   `exception_raised` tinyint(1) NOT NULL,
  413.   `dynamic` tinyint(1) NOT NULL,
  414.   `request_id` varchar(36) DEFAULT NULL,
  415.   PRIMARY KEY (`id`),
  416.   KEY `silk_profile_request_id_7b81bd69_fk_silk_request_id` (`request_id`),
  417.   CONSTRAINT `silk_profile_request_id_7b81bd69_fk_silk_request_id` FOREIGN KEY (`request_id`) REFERENCES `silk_request` (`id`)
  418. ) ENGINE=InnoDB AUTO_INCREMENT=1336 DEFAULT CHARSET=latin1;
  419.  
  420. -- Create syntax for TABLE 'silk_profile_queries'
  421. CREATE TABLE `silk_profile_queries` (
  422.   `id` int(11) NOT NULL AUTO_INCREMENT,
  423.   `profile_id` int(11) NOT NULL,
  424.   `sqlquery_id` int(11) NOT NULL,
  425.   PRIMARY KEY (`id`),
  426.   UNIQUE KEY `silk_profile_queries_profile_id_sqlquery_id_b2403d9b_uniq` (`profile_id`,`sqlquery_id`),
  427.   KEY `silk_profile_queries_sqlquery_id_155df455_fk_silk_sqlquery_id` (`sqlquery_id`),
  428.   CONSTRAINT `silk_profile_queries_profile_id_a3d76db8_fk_silk_profile_id` FOREIGN KEY (`profile_id`) REFERENCES `silk_profile` (`id`),
  429.   CONSTRAINT `silk_profile_queries_sqlquery_id_155df455_fk_silk_sqlquery_id` FOREIGN KEY (`sqlquery_id`) REFERENCES `silk_sqlquery` (`id`)
  430. ) ENGINE=InnoDB AUTO_INCREMENT=57015 DEFAULT CHARSET=latin1;
  431.  
  432. -- Create syntax for TABLE 'silk_request'
  433. CREATE TABLE `silk_request` (
  434.   `id` varchar(36) NOT NULL,
  435.   `path` varchar(190) NOT NULL,
  436.   `query_params` longtext NOT NULL,
  437.   `raw_body` longtext NOT NULL,
  438.   `body` longtext NOT NULL,
  439.   `method` varchar(10) NOT NULL,
  440.   `start_time` datetime(6) NOT NULL,
  441.   `view_name` varchar(190) DEFAULT NULL,
  442.   `end_time` datetime(6) DEFAULT NULL,
  443.   `time_taken` double DEFAULT NULL,
  444.   `encoded_headers` longtext NOT NULL,
  445.   `meta_time` double DEFAULT NULL,
  446.   `meta_num_queries` int(11) DEFAULT NULL,
  447.   `meta_time_spent_queries` double DEFAULT NULL,
  448.   `pyprofile` longtext NOT NULL,
  449.   `num_sql_queries` int(11) NOT NULL,
  450.   `prof_file` varchar(300) NOT NULL,
  451.   PRIMARY KEY (`id`),
  452.   KEY `silk_request_path_9f3d798e` (`path`),
  453.   KEY `silk_request_start_time_1300bc58` (`start_time`),
  454.   KEY `silk_request_view_name_68559f7b` (`view_name`)
  455. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  456.  
  457. -- Create syntax for TABLE 'silk_response'
  458. CREATE TABLE `silk_response` (
  459.   `id` varchar(36) NOT NULL,
  460.   `status_code` int(11) NOT NULL,
  461.   `raw_body` longtext NOT NULL,
  462.   `body` longtext NOT NULL,
  463.   `encoded_headers` longtext NOT NULL,
  464.   `request_id` varchar(36) NOT NULL,
  465.   PRIMARY KEY (`id`),
  466.   UNIQUE KEY `request_id` (`request_id`),
  467.   CONSTRAINT `silk_response_request_id_1e8e2776_fk_silk_request_id` FOREIGN KEY (`request_id`) REFERENCES `silk_request` (`id`)
  468. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  469.  
  470. -- Create syntax for TABLE 'silk_sqlquery'
  471. CREATE TABLE `silk_sqlquery` (
  472.   `id` int(11) NOT NULL AUTO_INCREMENT,
  473.   `query` longtext NOT NULL,
  474.   `start_time` datetime(6) DEFAULT NULL,
  475.   `end_time` datetime(6) DEFAULT NULL,
  476.   `time_taken` double DEFAULT NULL,
  477.   `traceback` longtext NOT NULL,
  478.   `request_id` varchar(36) DEFAULT NULL,
  479.   `identifier` int(11) NOT NULL,
  480.   PRIMARY KEY (`id`),
  481.   KEY `silk_sqlquery_request_id_6f8f0527_fk_silk_request_id` (`request_id`),
  482.   CONSTRAINT `silk_sqlquery_request_id_6f8f0527_fk_silk_request_id` FOREIGN KEY (`request_id`) REFERENCES `silk_request` (`id`)
  483. ) ENGINE=InnoDB AUTO_INCREMENT=168089 DEFAULT CHARSET=latin1;
  484.  
  485. -- Create syntax for TABLE 'subscription'
  486. CREATE TABLE `subscription` (
  487.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  488.   `owner_id` int(11) unsigned NOT NULL,
  489.   `device_type` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  490.   `start_date` datetime NOT NULL,
  491.   `end_date` datetime NOT NULL,
  492.   `product_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  493.   `valid` tinyint(1) NOT NULL,
  494.   `credential` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  495.   PRIMARY KEY (`id`),
  496.   KEY `subscription_cb902d83` (`owner_id`),
  497.   CONSTRAINT `owner_id_refs_uid_3d09dd97` FOREIGN KEY (`owner_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  498. ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  499.  
  500. -- Create syntax for TABLE 'temp'
  501. CREATE TABLE `temp` (
  502.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  503.   `move_id` int(11) NOT NULL,
  504.   PRIMARY KEY (`id`)
  505. ) ENGINE=InnoDB AUTO_INCREMENT=2082 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  506.  
  507. -- Create syntax for TABLE 'user_auth_token'
  508. CREATE TABLE `user_auth_token` (
  509.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  510.   `user_id` int(11) unsigned NOT NULL,
  511.   `auth_token` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'в токен я бы клал base64 от id пользователя и далее разделитель и далее рандомная строка чтобы по токену можно было легко понимать id пользователя не ходя в базу',
  512.   `cr_date` datetime NOT NULL,
  513.   `user_agent` varchar(256) DEFAULT NULL,
  514.   `device_token` longtext,
  515.   `device_type` varchar(10) CHARACTER SET ascii DEFAULT NULL,
  516.   PRIMARY KEY (`id`),
  517.   UNIQUE KEY `idx_auth_token` (`auth_token`),
  518.   UNIQUE KEY `auth_token` (`auth_token`) USING BTREE,
  519.   KEY `fk_auth_token_user` (`user_id`) USING BTREE,
  520.   CONSTRAINT `fk_auth_token_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE,
  521.   CONSTRAINT `user_auth_token_user_id_e997cf9e_fk_users_uid` FOREIGN KEY (`user_id`) REFERENCES `users` (`uid`) ON DELETE NO ACTION ON UPDATE NO ACTION
  522. ) ENGINE=InnoDB AUTO_INCREMENT=7335 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
  523.  
  524. -- Create syntax for TABLE 'user_contact'
  525. CREATE TABLE `user_contact` (
  526.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  527.   `owner_id` int(11) unsigned NOT NULL,
  528.   `user_id` int(11) NOT NULL,
  529.   `device` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  530.   `contact_name` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  531.   `contact_phone` decimal(16,0) NOT NULL,
  532.   PRIMARY KEY (`id`),
  533.   KEY `fk_contact_user` (`owner_id`) USING BTREE,
  534.   KEY `idx_contact_phone` (`contact_phone`),
  535.   CONSTRAINT `user_contact_owner_id_bebf54f3_fk_users_uid` FOREIGN KEY (`owner_id`) REFERENCES `users` (`uid`)
  536. ) ENGINE=InnoDB AUTO_INCREMENT=6323549 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;
  537.  
  538. -- Create syntax for TABLE 'user_phone'
  539. CREATE TABLE `user_phone` (
  540.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  541.   `owner_id` int(11) unsigned NOT NULL,
  542.   `code` int(4) unsigned DEFAULT NULL,
  543.   `code_sent_date` datetime DEFAULT NULL,
  544.   `phone` decimal(16,0) NOT NULL,
  545.   `code_confirmed_date` datetime DEFAULT NULL,
  546.   PRIMARY KEY (`id`),
  547.   UNIQUE KEY `idx_phone` (`phone`),
  548.   KEY `fk_user_phone_owner_id` (`owner_id`) USING BTREE,
  549.   CONSTRAINT `fk_user_phone_owner_id` FOREIGN KEY (`owner_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE
  550. ) ENGINE=InnoDB AUTO_INCREMENT=3949 DEFAULT CHARSET=utf8mb4;
  551.  
  552. -- Create syntax for TABLE 'users'
  553. CREATE TABLE `users` (
  554.   `uid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  555.   `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  556.   `pass` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  557.   `mail` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '',
  558.   `mode` tinyint(4) NOT NULL DEFAULT '0',
  559.   `sort` tinyint(4) DEFAULT '0',
  560.   `threshold` tinyint(4) DEFAULT '0',
  561.   `theme` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  562.   `signature` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  563.   `created` int(11) NOT NULL DEFAULT '0',
  564.   `access` int(11) NOT NULL DEFAULT '0',
  565.   `login` int(11) NOT NULL DEFAULT '0',
  566.   `status` tinyint(4) NOT NULL DEFAULT '0',
  567.   `timezone` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  568.   `language` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  569.   `picture` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  570.   `init` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT '',
  571.   `data` longtext COLLATE utf8mb4_unicode_ci,
  572.   `currency` char(5) CHARACTER SET ascii NOT NULL DEFAULT 'USD',
  573.   `avatar_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  574.   `full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  575.   `creator_id` int(11) unsigned DEFAULT NULL,
  576.   `password` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  577.   `4sq_user_id` int(11) DEFAULT NULL,
  578.   `4sq_access_token` varchar(96) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  579.   `registration_date` datetime DEFAULT NULL,
  580.   `gender` enum('M','F') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'M',
  581.   `family_head_id` int(11) unsigned DEFAULT NULL,
  582.   `user_id` int(11) DEFAULT NULL,
  583.   `code` int(11) DEFAULT NULL,
  584.   `code_confirmed_date` datetime(6) DEFAULT NULL,
  585.   `code_sent_date` datetime(6) DEFAULT NULL,
  586.   `phone` decimal(16,0) NOT NULL,
  587.   PRIMARY KEY (`uid`),
  588.   UNIQUE KEY `name` (`name`),
  589.   UNIQUE KEY `users_phone_2b77170a_uniq` (`phone`),
  590.   UNIQUE KEY `user_id` (`user_id`),
  591.   KEY `created` (`created`),
  592.   KEY `access` (`access`),
  593.   KEY `fk_users_creator` (`creator_id`),
  594.   KEY `fk_users_currency` (`currency`),
  595.   CONSTRAINT `fk_users_creator` FOREIGN KEY (`creator_id`) REFERENCES `users` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE,
  596.   CONSTRAINT `fk_users_currency` FOREIGN KEY (`currency`) REFERENCES `currency` (`currency`) ON DELETE CASCADE ON UPDATE CASCADE,
  597.   CONSTRAINT `users_user_id_26693996_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
  598. ) ENGINE=InnoDB AUTO_INCREMENT=102080 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=COMPACT;
Add Comment
Please, Sign In to add comment
Public Pastes
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!