API tools faq
paste
Guest User

xProfile tables dump

a guest
Apr 23rd, 2014
208
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.05 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.5.2.2
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: Apr 24, 2014 at 04:42 AM
  7. -- Server version: 5.5.27
  8. -- PHP Version: 5.4.7
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13. --
  14. -- Database: `devtrunk`
  15. --
  16.  
  17. -- --------------------------------------------------------
  18.  
  19. --
  20. -- Table structure for table `devtrunk_bp_xprofile_data`
  21. --
  22. -- Creation: Apr 18, 2014 at 02:59 AM
  23. --
  24.  
  25. DROP TABLE IF EXISTS `devtrunk_bp_xprofile_data`;
  26. CREATE TABLE IF NOT EXISTS `devtrunk_bp_xprofile_data` (
  27. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  28. `field_id` bigint(20) unsigned NOT NULL,
  29. `user_id` bigint(20) unsigned NOT NULL,
  30. `value` longtext NOT NULL,
  31. `last_updated` datetime NOT NULL,
  32. PRIMARY KEY (`id`),
  33. KEY `field_id` (`field_id`),
  34. KEY `user_id` (`user_id`)
  35. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;
  36.  
  37. --
  38. -- Dumping data for table `devtrunk_bp_xprofile_data`
  39. --
  40.  
  41. INSERT INTO `devtrunk_bp_xprofile_data` (`id`, `field_id`, `user_id`, `value`, `last_updated`) VALUES
  42. (1, 1, 1, 'admin', '2014-04-22 22:27:48'),
  43. (2, 1, 2, 'mercime', '2014-04-22 04:43:36'),
  44. (3, 1, 3, 'john', '2014-04-22 04:44:21'),
  45. (4, 1, 4, 'boone', '2014-04-22 04:44:56'),
  46. (5, 1, 5, 'hugo', '2014-04-22 04:45:27'),
  47. (6, 1, 6, 'matthieu', '2014-04-22 04:46:00'),
  48. (7, 1, 7, 'paul', '2014-04-22 04:47:03'),
  49. (8, 1, 8, 'r-a-y', '2014-04-22 04:47:34'),
  50. (9, 1, 9, 'ryan', '2014-04-22 04:48:13'),
  51. (10, 1, 10, 'tammie', '2014-04-22 04:48:46'),
  52. (11, 1, 11, 'antawn', '2014-04-22 23:16:46'),
  53. (12, 1, 12, 'chynna', '2014-04-22 06:04:31'),
  54. (13, 1, 13, 'kiki', '2014-04-22 06:04:31'),
  55. (14, 1, 14, 'malivai', '2014-04-22 06:04:31'),
  56. (15, 1, 15, 'matraca', '2014-04-22 06:04:32'),
  57. (16, 1, 16, 'ron', '2014-04-22 06:04:32'),
  58. (17, 1, 17, 'michellie', '2014-04-22 06:04:32'),
  59. (18, 1, 18, 'monta', '2014-04-22 06:04:33'),
  60. (19, 1, 19, 'picabo', '2014-04-22 06:04:33'),
  61. (20, 1, 20, 'ralph', '2014-04-22 06:04:33'),
  62. (21, 1, 21, 'seamus', '2014-04-22 06:04:34'),
  63. (22, 1, 22, 'shan', '2014-04-22 06:04:34'),
  64. (23, 1, 23, 'siobhan', '2014-04-22 06:04:34'),
  65. (24, 1, 24, 'stephen', '2014-04-22 06:04:34'),
  66. (25, 1, 25, 'wynonna', '2014-04-22 06:04:35'),
  67. (26, 1, 26, 'thomas', '2014-04-22 06:04:35'),
  68. (27, 1, 27, 'jason', '2014-04-22 06:04:36'),
  69. (28, 1, 28, 'mamah', '2014-04-22 06:04:36'),
  70. (29, 1, 29, 'cecelia', '2014-04-22 06:04:36'),
  71. (30, 1, 30, 'dan', '2014-04-22 06:04:41'),
  72. (31, 1, 31, 'vernon', '2014-04-22 06:04:41'),
  73. (32, 1, 32, 'andre', '2014-04-22 23:12:14'),
  74. (33, 1, 33, 'justin', '2014-04-22 06:04:42'),
  75. (34, 1, 34, 'keir', '2014-04-22 06:04:42'),
  76. (35, 2, 1, 'City of Atlantis', '2014-04-22 22:27:48'),
  77. (36, 3, 1, 'Fun and Games', '2014-04-22 22:27:48'),
  78. (37, 4, 1, '$1 Billion per annum net', '2014-04-22 22:27:48'),
  79. (38, 5, 1, 'Games', '2014-04-22 21:47:51'),
  80. (40, 7, 1, 'Mountain climbing, Web development', '2014-04-22 22:18:27'),
  81. (41, 6, 1, 'American Red Cross, Catholic Charities', '2014-04-22 22:27:21'),
  82. (42, 8, 1, 'Everytime I see you :)', '2014-04-22 22:27:48'),
  83. (43, 2, 32, 'Jamaica', '2014-04-22 23:12:14'),
  84. (44, 3, 32, 'Concert Pianist', '2014-04-22 23:12:14'),
  85. (45, 4, 32, '$2 Million', '2014-04-22 23:12:14'),
  86. (46, 8, 32, 'Playing the Piano', '2014-04-22 23:12:14'),
  87. (47, 5, 32, 'Pianist', '2014-04-22 23:12:14'),
  88. (48, 6, 32, 'Arthritis Foundation', '2014-04-22 23:12:14'),
  89. (49, 7, 32, 'Stamp collecting', '2014-04-22 23:12:14'),
  90. (50, 2, 11, 'Guantanamera', '2014-04-22 23:16:46'),
  91. (51, 3, 11, 'Singing', '2014-04-22 23:16:46'),
  92. (52, 4, 11, '$3 Million per annum', '2014-04-22 23:16:46'),
  93. (53, 8, 11, 'Singing in the rain', '2014-04-22 23:16:46'),
  94. (54, 5, 11, 'Singing everywhere', '2014-04-22 23:17:19'),
  95. (55, 6, 11, 'American Red Cross', '2014-04-22 23:17:40'),
  96. (56, 7, 11, 'Painting', '2014-04-22 23:17:55');
  97.  
  98. -- --------------------------------------------------------
  99.  
  100. --
  101. -- Table structure for table `devtrunk_bp_xprofile_fields`
  102. --
  103. -- Creation: Apr 18, 2014 at 02:59 AM
  104. --
  105.  
  106. DROP TABLE IF EXISTS `devtrunk_bp_xprofile_fields`;
  107. CREATE TABLE IF NOT EXISTS `devtrunk_bp_xprofile_fields` (
  108. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  109. `group_id` bigint(20) unsigned NOT NULL,
  110. `parent_id` bigint(20) unsigned NOT NULL,
  111. `type` varchar(150) NOT NULL,
  112. `name` varchar(150) NOT NULL,
  113. `description` longtext NOT NULL,
  114. `is_required` tinyint(1) NOT NULL DEFAULT '0',
  115. `is_default_option` tinyint(1) NOT NULL DEFAULT '0',
  116. `field_order` bigint(20) NOT NULL DEFAULT '0',
  117. `option_order` bigint(20) NOT NULL DEFAULT '0',
  118. `order_by` varchar(15) NOT NULL DEFAULT '',
  119. `can_delete` tinyint(1) NOT NULL DEFAULT '1',
  120. PRIMARY KEY (`id`),
  121. KEY `group_id` (`group_id`),
  122. KEY `parent_id` (`parent_id`),
  123. KEY `field_order` (`field_order`),
  124. KEY `can_delete` (`can_delete`),
  125. KEY `is_required` (`is_required`)
  126. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
  127.  
  128. --
  129. -- Dumping data for table `devtrunk_bp_xprofile_fields`
  130. --
  131.  
  132. INSERT INTO `devtrunk_bp_xprofile_fields` (`id`, `group_id`, `parent_id`, `type`, `name`, `description`, `is_required`, `is_default_option`, `field_order`, `option_order`, `order_by`, `can_delete`) VALUES
  133. (1, 1, 0, 'textbox', 'Name', '', 1, 0, 0, 0, '', 0),
  134. (2, 1, 0, 'textbox', 'Location', 'Where do you live?', 1, 0, 1, 0, '', 1),
  135. (3, 1, 0, 'textbox', 'Field of Expertise', '', 0, 0, 2, 0, '', 1),
  136. (4, 1, 0, 'textbox', 'Expected Salary', 'Salary per annum', 0, 0, 3, 0, '', 1),
  137. (5, 2, 0, 'textbox', 'Preferred Work', 'Choose your poison', 0, 0, 1, 0, '', 1),
  138. (6, 3, 0, 'textbox', 'Favorite Charities', '', 0, 0, 1, 0, '', 1),
  139. (7, 4, 0, 'textbox', 'List of Hobbies', '', 0, 0, 1, 0, '', 1),
  140. (8, 1, 0, 'textbox', 'Fun time?', '', 0, 0, 4, 0, '', 1);
  141.  
  142. -- --------------------------------------------------------
  143.  
  144. --
  145. -- Table structure for table `devtrunk_bp_xprofile_groups`
  146. --
  147. -- Creation: Apr 18, 2014 at 02:59 AM
  148. --
  149.  
  150. DROP TABLE IF EXISTS `devtrunk_bp_xprofile_groups`;
  151. CREATE TABLE IF NOT EXISTS `devtrunk_bp_xprofile_groups` (
  152. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  153. `name` varchar(150) NOT NULL,
  154. `description` mediumtext NOT NULL,
  155. `group_order` bigint(20) NOT NULL DEFAULT '0',
  156. `can_delete` tinyint(1) NOT NULL,
  157. PRIMARY KEY (`id`),
  158. KEY `can_delete` (`can_delete`)
  159. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
  160.  
  161. --
  162. -- Dumping data for table `devtrunk_bp_xprofile_groups`
  163. --
  164.  
  165. INSERT INTO `devtrunk_bp_xprofile_groups` (`id`, `name`, `description`, `group_order`, `can_delete`) VALUES
  166. (1, 'Base', '', 0, 0),
  167. (2, 'Work Experience', '', 0, 1),
  168. (3, 'Charities', '', 0, 1),
  169. (4, 'Hobbies', '', 0, 1);
  170.  
  171. -- --------------------------------------------------------
  172.  
  173. --
  174. -- Table structure for table `devtrunk_bp_xprofile_meta`
  175. --
  176. -- Creation: Apr 18, 2014 at 02:59 AM
  177. --
  178.  
  179. DROP TABLE IF EXISTS `devtrunk_bp_xprofile_meta`;
  180. CREATE TABLE IF NOT EXISTS `devtrunk_bp_xprofile_meta` (
  181. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  182. `object_id` bigint(20) NOT NULL,
  183. `object_type` varchar(150) NOT NULL,
  184. `meta_key` varchar(255) DEFAULT NULL,
  185. `meta_value` longtext,
  186. PRIMARY KEY (`id`),
  187. KEY `object_id` (`object_id`),
  188. KEY `meta_key` (`meta_key`)
  189. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
  190.  
  191. --
  192. -- Dumping data for table `devtrunk_bp_xprofile_meta`
  193. --
  194.  
  195. INSERT INTO `devtrunk_bp_xprofile_meta` (`id`, `object_id`, `object_type`, `meta_key`, `meta_value`) VALUES
  196. (1, 2, 'field', 'default_visibility', 'public'),
  197. (2, 2, 'field', 'allow_custom_visibility', 'allowed'),
  198. (3, 3, 'field', 'default_visibility', 'public'),
  199. (4, 3, 'field', 'allow_custom_visibility', 'allowed'),
  200. (5, 4, 'field', 'default_visibility', 'public'),
  201. (6, 4, 'field', 'allow_custom_visibility', 'allowed'),
  202. (7, 5, 'field', 'default_visibility', 'public'),
  203. (8, 5, 'field', 'allow_custom_visibility', 'allowed'),
  204. (9, 6, 'field', 'default_visibility', 'public'),
  205. (10, 6, 'field', 'allow_custom_visibility', 'allowed'),
  206. (11, 7, 'field', 'default_visibility', 'public'),
  207. (12, 7, 'field', 'allow_custom_visibility', 'allowed'),
  208. (13, 8, 'field', 'default_visibility', 'public'),
  209. (14, 8, 'field', 'allow_custom_visibility', 'allowed');
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!