API tools faq
paste
Dazholmes

Java aliber-wx Project Database Dump By Daz Holmes

Dazholmes
Dec 5th, 2013
162
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 86.97 KB | None | 0 0
raw download clone embed print report
  1. Java aliber-wx Project Database Dump By C0dersec
  2.  
  3. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  4. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  5. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  6. /*!40101 SET NAMES utf8 */;
  7.  
  8. --
  9. -- Database: `cutionline`
  10. --
  11.  
  12. -- --------------------------------------------------------
  13.  
  14. --
  15. -- Table structure for table `backend_user`
  16. --
  17.  
  18. CREATE TABLE IF NOT EXISTS `backend_user` (
  19. `id` varchar(255) NOT NULL,
  20. `active_flag` int(11) DEFAULT NULL,
  21. `create_by` varchar(255) DEFAULT NULL,
  22. `create_date` datetime DEFAULT NULL,
  23. `update_by` varchar(255) DEFAULT NULL,
  24. `update_date` datetime DEFAULT NULL,
  25. `city` varchar(255) DEFAULT NULL,
  26. `address1` varchar(255) DEFAULT NULL,
  27. `address2` varchar(255) DEFAULT NULL,
  28. `description` varchar(255) DEFAULT NULL,
  29. `email` varchar(255) DEFAULT NULL,
  30. `foto` longblob,
  31. `first_name` varchar(255) DEFAULT NULL,
  32. `last_name` varchar(255) DEFAULT NULL,
  33. `nik` varchar(255) DEFAULT NULL,
  34. `password` varchar(255) DEFAULT NULL,
  35. `sisa_cuti` varchar(255) DEFAULT NULL,
  36. `tahun` varchar(255) DEFAULT NULL,
  37. `tgl_mulai_kerja` datetime DEFAULT NULL,
  38. `username` varchar(255) DEFAULT NULL,
  39. `workspace_type` varchar(255) DEFAULT NULL,
  40. `site_id` varchar(255) DEFAULT NULL,
  41. `company_id` varchar(255) DEFAULT NULL,
  42. `job_position_id` varchar(255) DEFAULT NULL,
  43. `role_id` varchar(255) DEFAULT NULL,
  44. `user_id` varchar(255) DEFAULT NULL,
  45. `manager_id` varchar(255) DEFAULT NULL,
  46. `hutangCuti` varchar(255) DEFAULT NULL,
  47. PRIMARY KEY (`id`),
  48. UNIQUE KEY `username` (`username`),
  49. UNIQUE KEY `username_2` (`username`),
  50. KEY `FK34849A96519415C5` (`user_id`),
  51. KEY `FK34849A96EF11CEA3` (`manager_id`)
  52. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  53.  
  54. --
  55. -- Dumping data for table `backend_user`
  56. --
  57.  
  58. INSERT INTO `backend_user` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `city`, `address1`, `address2`, `description`, `email`, `foto`, `first_name`, `last_name`, `nik`, `password`, `sisa_cuti`, `tahun`, `tgl_mulai_kerja`, `username`, `workspace_type`, `site_id`, `company_id`, `job_position_id`, `role_id`, `user_id`, `manager_id`, `hutangCuti`) VALUES
  59. ('0', 1, '1', '2011-04-20 13:50:43', 'ff8081812da1ca99012da1d013bb0009', '2011-05-27 11:17:50', '', '', '', NULL, '', 0, 'Manager', 'Utama', '', 'bWFzdGVy', '', NULL, '2011-04-20 00:00:00', 'master', NULL, NULL, NULL, '402809ab2f679278012f6795278d0001', 'ff8080812f655322012f65634f3f0006', NULL, 'ff8081812da1ca99012da1d013bb0009', NULL);
  60. INSERT INTO `backend_user` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `city`, `address1`, `address2`, `description`, `email`, `foto`, `first_name`, `last_name`, `nik`, `password`, `sisa_cuti`, `tahun`, `tgl_mulai_kerja`, `username`, `workspace_type`, `site_id`, `company_id`, `job_position_id`, `role_id`, `user_id`, `manager_id`, `hutangCuti`) VALUES
  61. ('1', 1, NULL, '2005-08-12 11:28:20', '1', '2008-10-16 13:48:14', 'Jakarta Selatan', 'Grand Wijaya Center Jl Wijaya II', 'Blok H No 41', '', 'admin@meruvian.org', NULL, 'Administrator', 'Workspace', NULL, 'YWRtaW4=', NULL, NULL, NULL, 'admin', 'flat', 'EE185CE0B82B41C1724F284685', 'blueoxygen', 'mgr', '1', NULL, NULL, NULL),
  62. ('402880f91d19d3fb011d19dc022a0008', 1, '1', '2008-10-20 17:45:28', '1', '2008-11-11 00:03:05', '', '', '', '', '', NULL, 'test', 'test', NULL, 'dGVzdA==', NULL, NULL, NULL, 'test', 'menu', NULL, 'blueoxygen', 'mgr', 'ff8081811ac3700b011ac3716b270001', NULL, NULL, NULL),
  63. ('96f673bc-283e-4b75-b63d-6edc', 1, NULL, '2007-09-19 16:04:47', '1', '2008-10-16 13:48:14', '', '', '', '', '', NULL, 'GX', 'Admin', NULL, 'Z3hhZG1pbg==', NULL, NULL, NULL, 'gxadmin', 'tree', 'EE185CE0B82B41C1724F284685', 'blueoxygen', 'mgr', '2-gx', NULL, NULL, NULL),
  64. ('f2f900fb1f3718ba011f371b5dd80001', 1, NULL, '2009-02-02 20:09:14', NULL, '2009-02-02 20:09:14', 'malang', 'jl bunga anyelir 15', '', NULL, 'bagus.candra@meruvian.org', NULL, 'bece', 'el', NULL, 'Y2hpYmk=', NULL, NULL, NULL, 'chibi', NULL, NULL, NULL, NULL, 'f2f900fb1f3714e1011f3715b0f60001', NULL, NULL, NULL),
  65. ('ff8080811ddcf1f4011ddd0f17160003', 1, '1', '2008-11-27 15:27:13', '1', '2008-11-27 15:27:13', '', '', '', '', '', NULL, 'asdasd', 'adasd', NULL, 'YWRhc2Q=', NULL, NULL, NULL, 'asdasd', 'tree', NULL, 'blueoxygen', 'mgr', 'ff8081811ac3700b011ac3716b270001', NULL, NULL, NULL),
  66. ('ff8081811cf90e28011cf919a3ff000d', 1, '1', '2008-10-14 09:05:19', '1', '2008-10-14 09:05:19', '', '', '', '', '', NULL, 'aroma admin', '', NULL, 'YXJvbWE=', NULL, NULL, NULL, 'aroma', NULL, NULL, 'blueoxygen', 'mgr', 'ff8081811cf90e28011cf918c4500009', NULL, NULL, NULL),
  67. ('ff8081811cf90e28011cf91cc1e40016', 1, '1', '2008-10-14 09:08:43', '1', '2008-10-14 09:08:43', '', '', '', '', '', NULL, 'kuga', '', NULL, 'a3VnYQ==', NULL, NULL, NULL, 'kuga', NULL, NULL, 'blueoxygen', 'mgr', 'ff8081811cf90e28011cf91a75b90010', NULL, NULL, NULL),
  68. ('ff8081812da1ca99012da1d013bb0009', 1, '1', '2011-01-20 12:05:24', '1', '2011-01-20 12:05:24', '', '', '', '', 'edy_valiant_band@yahoo.co.id', NULL, 'edy', 'setiawan', NULL, 'YWRtaW4=', NULL, NULL, NULL, 'valiant', 'tree', NULL, 'blueoxygen', 'mgr', 'ff8081812da1ca99012da1ceb79c0005', NULL, NULL, NULL);
  69.  
  70. -- --------------------------------------------------------
  71.  
  72. --
  73. -- Table structure for table `category`
  74. --
  75.  
  76. CREATE TABLE IF NOT EXISTS `category` (
  77. `id` varchar(255) NOT NULL,
  78. `active_flag` int(11) DEFAULT NULL,
  79. `create_by` varchar(255) DEFAULT NULL,
  80. `create_date` datetime DEFAULT NULL,
  81. `update_by` varchar(255) DEFAULT NULL,
  82. `update_date` datetime DEFAULT NULL,
  83. `code` varchar(255) DEFAULT NULL,
  84. `description` varchar(255) DEFAULT NULL,
  85. `url_category_image` varchar(255) DEFAULT NULL,
  86. `site_id` varchar(255) DEFAULT NULL,
  87. `categoryDescriptor_id` varchar(255) DEFAULT NULL,
  88. `iparentcode` varchar(255) DEFAULT NULL,
  89. PRIMARY KEY (`id`),
  90. KEY `FK302BCFE60140B49` (`categoryDescriptor_id`),
  91. KEY `FK302BCFED94CFE2B` (`iparentcode`),
  92. KEY `FK302BCFE3CAE8F1E` (`site_id`)
  93. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  94.  
  95. --
  96. -- Dumping data for table `category`
  97. --
  98.  
  99. INSERT INTO `category` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `code`, `description`, `url_category_image`, `site_id`, `categoryDescriptor_id`, `iparentcode`) VALUES
  100. ('4028817a05ccb32a0105ccc27179', 1, '1', '2005-08-19 10:22:39', '', '2008-03-17 18:36:38', 'dsc', 'descriptor', '', NULL, NULL, NULL),
  101. ('4028817a05cdd1d80105cdd88938', 1, '1', '2005-08-19 15:26:24', '', '2008-03-17 18:36:38', 'evn', 'event parent', '', NULL, NULL, NULL),
  102. ('4028817a05cdd1d80105cddb412e', 1, '1', '2005-08-19 15:29:22', '', '2008-03-17 18:36:38', 'mdf', 'module function parent', '', NULL, NULL, NULL),
  103. ('4028817a05cdd1d80105cddf0499', 1, '1', '2005-08-19 15:33:29', '', '2008-03-17 18:36:38', 'sec', 'section parent', '', NULL, NULL, NULL),
  104. ('4028817a05cdd1d80105cde43c12', 1, '1', '2005-08-19 15:39:11', '', '2008-03-17 18:36:38', 'bus', 'back end user profile parent', '', NULL, NULL, NULL),
  105. ('4028817a05cdd1d80105cde99219', 1, '1', '2005-08-19 15:45:00', '', '2008-03-17 18:36:38', 'sit', 'site parent', '', NULL, NULL, NULL),
  106. ('4028817a05e2d2140105e2d5768b', 1, '1', '2005-08-23 17:15:04', '', '2008-03-17 18:36:38', 'oke', 'category ok', '', NULL, NULL, NULL),
  107. ('4028817a05e2d2140105e2d705f2', 1, '1', '2005-08-23 17:16:46', '', '2008-03-17 18:36:38', 'poi', 'Age poi', '', NULL, NULL, NULL),
  108. ('4028817a05e2d2140105e2d84ba6', 1, '1', '2005-08-23 17:18:10', '', '2008-03-17 18:36:38', 'col', 'colection', '', NULL, NULL, NULL),
  109. ('4028817a05e2d2140105e2d8a79d', 1, '1', '2005-08-23 17:18:33', '', '2008-03-17 18:36:38', 'ctr', 'country', '', NULL, NULL, NULL),
  110. ('4028817a05e2d2140105e2d9381f', 1, '1', '2005-08-23 17:19:10', '1', '2005-08-24 11:02:02', 'faq', 'faq f', 'faq.jpg', NULL, NULL, NULL),
  111. ('4028817a05e2d2140105e2d983c6', 1, '1', '2005-08-23 17:19:30', '', '2008-03-17 18:36:38', 'itm', 'item', '', NULL, NULL, NULL),
  112. ('4028817a05e2d2140105e2da47c3', 1, '1', '2005-08-23 17:20:20', '', '2008-03-17 18:36:38', 'md2', 'module function', '', NULL, NULL, NULL),
  113. ('4028817a05e2d2140105e2e89a70', 1, '1', '2005-08-23 17:35:58', '', '2008-03-17 18:36:38', 'wf2', 'workflow role', '', NULL, NULL, NULL),
  114. ('4028817a05e6973b0105e6a33932', 1, '1', '2005-08-24 10:58:40', '', '2008-03-17 18:36:38', 'luk', 'test', '', NULL, NULL, NULL),
  115. ('402881b709bdfd9b0109bdfdbba2', 1, '1', '2006-03-03 09:44:15', '', '2008-03-17 18:36:38', 'ttt', 'sdasd ', NULL, NULL, NULL, NULL),
  116. ('402881b709be135e0109be138332', 1, '1', '2006-03-03 10:08:03', '', '2008-03-17 18:36:38', 'der', 'dafas ', NULL, NULL, NULL, NULL),
  117. ('402881b709be135e0109be13d624', 1, '1', '2006-03-03 10:08:24', '', '2008-03-17 18:36:38', 'wrt', 'dsasad ', NULL, NULL, NULL, NULL),
  118. ('402881b709be21e60109be223cd9', 1, '1', '2006-03-03 10:24:08', '', '2008-03-17 18:36:38', '589', 'dsad ', 'ari.gif', NULL, NULL, NULL),
  119. ('ff80808106067a250106067ac6bd', 1, '1', '2005-08-30 15:22:21', '1', '2005-08-30 15:37:28', 'oki', 'adda', 'saas', NULL, NULL, NULL);
  120.  
  121. -- --------------------------------------------------------
  122.  
  123. --
  124. -- Table structure for table `company`
  125. --
  126.  
  127. CREATE TABLE IF NOT EXISTS `company` (
  128. `id` varchar(255) NOT NULL,
  129. `active_flag` int(11) DEFAULT NULL,
  130. `create_by` varchar(255) DEFAULT NULL,
  131. `create_date` datetime DEFAULT NULL,
  132. `update_by` varchar(255) DEFAULT NULL,
  133. `update_date` datetime DEFAULT NULL,
  134. `address` varchar(255) DEFAULT NULL,
  135. `email` varchar(255) DEFAULT NULL,
  136. `faximile` varchar(255) DEFAULT NULL,
  137. `name` varchar(255) DEFAULT NULL,
  138. `state` varchar(255) DEFAULT NULL,
  139. `telephone` varchar(255) DEFAULT NULL,
  140. `website` varchar(255) DEFAULT NULL,
  141. `zip_number` varchar(255) DEFAULT NULL,
  142. `site_id` varchar(255) DEFAULT NULL,
  143. PRIMARY KEY (`id`),
  144. KEY `FK38A73C7D3CAE8F1E` (`site_id`)
  145. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  146.  
  147. --
  148. -- Dumping data for table `company`
  149. --
  150.  
  151. INSERT INTO `company` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `address`, `email`, `faximile`, `name`, `state`, `telephone`, `website`, `zip_number`, `site_id`) VALUES
  152. ('blueoxygen', 0, 'F162B448063A847', '2003-02-07 16:51:14', NULL, '2008-03-17 18:32:00', 'Wijaya Grand Center Blok H No. 41, 4fl Jakarta Selatan', 'frans@blueoxygen.org', '4260933', 'BlueOxygen Tech', 'Jakarta', '4260933', 'www.blueoxygen.org', '12830', NULL);
  153.  
  154. -- --------------------------------------------------------
  155.  
  156. --
  157. -- Table structure for table `debus_action_type`
  158. --
  159.  
  160. CREATE TABLE IF NOT EXISTS `debus_action_type` (
  161. `id` varchar(255) NOT NULL,
  162. `active_flag` int(11) DEFAULT NULL,
  163. `create_by` varchar(255) DEFAULT NULL,
  164. `create_date` datetime DEFAULT NULL,
  165. `update_by` varchar(255) DEFAULT NULL,
  166. `update_date` datetime DEFAULT NULL,
  167. `description` varchar(255) DEFAULT NULL,
  168. `name` varchar(255) DEFAULT NULL,
  169. `site_id` varchar(255) DEFAULT NULL,
  170. PRIMARY KEY (`id`),
  171. KEY `FK7F7199C33CAE8F1E` (`site_id`)
  172. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  173.  
  174. --
  175. -- Dumping data for table `debus_action_type`
  176. --
  177.  
  178. INSERT INTO `debus_action_type` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `name`, `site_id`) VALUES
  179. ('ff8081811ab367fc011ab3685c200001', 1, '1', '2008-06-23 10:12:18', '1', '2008-06-23 10:12:18', 'Create Action', 'create', NULL),
  180. ('ff8081811ab367fc011ab3689b180002', 1, '1', '2008-06-23 10:12:34', '1', '2008-06-23 10:12:34', 'Save Action', 'save', NULL),
  181. ('ff8081811ab367fc011ab368e3570003', 1, '1', '2008-06-23 10:12:53', '1', '2008-06-23 10:12:53', 'Filter Action', 'filter', NULL);
  182.  
  183. -- --------------------------------------------------------
  184.  
  185. --
  186. -- Table structure for table `debus_descriptor_access`
  187. --
  188.  
  189. CREATE TABLE IF NOT EXISTS `debus_descriptor_access` (
  190. `id` varchar(255) NOT NULL,
  191. `active_flag` int(11) DEFAULT NULL,
  192. `create_by` varchar(255) DEFAULT NULL,
  193. `create_date` datetime DEFAULT NULL,
  194. `update_by` varchar(255) DEFAULT NULL,
  195. `update_date` datetime DEFAULT NULL,
  196. `site_id` varchar(255) DEFAULT NULL,
  197. `action_id` varchar(255) DEFAULT NULL,
  198. `descriptor_id` varchar(255) DEFAULT NULL,
  199. `permission_id` varchar(255) DEFAULT NULL,
  200. `role_id` varchar(255) DEFAULT NULL,
  201. PRIMARY KEY (`id`),
  202. KEY `FK56A63A547C369E4D` (`action_id`),
  203. KEY `FK56A63A54456510EF` (`role_id`),
  204. KEY `FK56A63A54569CB2AD` (`permission_id`),
  205. KEY `FK56A63A54F5B73B87` (`descriptor_id`),
  206. KEY `FK56A63A543CAE8F1E` (`site_id`)
  207. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  208.  
  209. --
  210. -- Dumping data for table `debus_descriptor_access`
  211. --
  212.  
  213.  
  214. -- --------------------------------------------------------
  215.  
  216. --
  217. -- Table structure for table `debus_permission_type`
  218. --
  219.  
  220. CREATE TABLE IF NOT EXISTS `debus_permission_type` (
  221. `id` varchar(255) NOT NULL,
  222. `active_flag` int(11) DEFAULT NULL,
  223. `create_by` varchar(255) DEFAULT NULL,
  224. `create_date` datetime DEFAULT NULL,
  225. `update_by` varchar(255) DEFAULT NULL,
  226. `update_date` datetime DEFAULT NULL,
  227. `create_flag` int(11) DEFAULT NULL,
  228. `delete_flag` int(11) DEFAULT NULL,
  229. `description` varchar(255) DEFAULT NULL,
  230. `name` varchar(255) DEFAULT NULL,
  231. `read_flag` int(11) DEFAULT NULL,
  232. `update_flag` int(11) DEFAULT NULL,
  233. `site_id` varchar(255) DEFAULT NULL,
  234. PRIMARY KEY (`id`),
  235. KEY `FK714919CA3CAE8F1E` (`site_id`)
  236. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  237.  
  238. --
  239. -- Dumping data for table `debus_permission_type`
  240. --
  241.  
  242.  
  243. -- --------------------------------------------------------
  244.  
  245. --
  246. -- Table structure for table `descriptor`
  247. --
  248.  
  249. CREATE TABLE IF NOT EXISTS `descriptor` (
  250. `id` varchar(255) NOT NULL,
  251. `active_flag` int(11) DEFAULT NULL,
  252. `create_by` varchar(255) DEFAULT NULL,
  253. `create_date` datetime DEFAULT NULL,
  254. `update_by` varchar(255) DEFAULT NULL,
  255. `update_date` datetime DEFAULT NULL,
  256. `description` varchar(255) DEFAULT NULL,
  257. `descriptor_flag` int(11) DEFAULT NULL,
  258. `name` varchar(255) DEFAULT NULL,
  259. `type_flag` int(11) DEFAULT NULL,
  260. `url_action` varchar(255) DEFAULT NULL,
  261. `url_descriptor` varchar(255) DEFAULT NULL,
  262. `site_id` varchar(255) DEFAULT NULL,
  263. `window_id` varchar(255) DEFAULT NULL,
  264. PRIMARY KEY (`id`),
  265. KEY `FKD364D36FC1381B1C` (`window_id`),
  266. KEY `FKD364D36F3CAE8F1E` (`site_id`)
  267. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  268.  
  269. --
  270. -- Dumping data for table `descriptor`
  271. --
  272.  
  273. INSERT INTO `descriptor` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `descriptor_flag`, `name`, `type_flag`, `url_action`, `url_descriptor`, `site_id`, `window_id`) VALUES
  274. ('1', 1, NULL, '2005-08-05 17:09:15', '1', '2008-05-22 12:54:16', 'Descriptor', 1, 'descriptor', 2, NULL, 'descriptor.xml', 'EE185CE0B82B41C1724F284685', NULL),
  275. ('14', 1, NULL, '2005-08-19 10:08:57', '1', '2008-05-22 12:54:16', 'Workflow Role', 1, 'workflow_role', 2, NULL, 'workflow_role.xml', 'EE185CE0B82B41C1724F284685', NULL),
  276. ('2', 1, NULL, '2005-08-05 17:10:38', '1', '2008-05-22 12:54:16', 'Site', 1, 'site', 2, NULL, 'site.xml', 'EE185CE0B82B41C1724F284685', NULL),
  277. ('22', 1, NULL, '2005-09-19 23:49:01', '1', '2008-05-22 12:54:16', 'Template', 1, 'template', 2, NULL, 'template.xml', 'EE185CE0B82B41C1724F284685', NULL),
  278. ('31', 1, NULL, '2005-08-12 11:31:40', '1', '2008-05-22 12:54:16', 'Module Function', 1, 'module_function', 2, NULL, 'module_function.xml', 'EE185CE0B82B41C1724F284685', NULL),
  279. ('32', 1, NULL, '2002-05-29 00:00:00', '1', '2008-05-22 12:54:16', 'Role Privilage', 1, 'role_privilage', 2, NULL, 'role_privilage.xml', 'EE185CE0B82B41C1724F284685', NULL),
  280. ('402880f91d19d3fb011d19d95edf0004', 1, '1', '2008-10-20 17:42:35', '1', '2008-10-20 17:42:35', 'child1', -1, 'test1', 2, '', '', NULL, NULL),
  281. ('402880f91d19d3fb011d19df08d2000d', 1, '1', '2008-10-20 17:48:46', '1', '2008-11-27 16:38:57', 'child3', -1, 'test3', 2, '', '', NULL, NULL),
  282. ('6', 1, NULL, '2005-08-05 17:17:33', '1', '2008-05-22 12:54:16', 'Category', 1, 'category', 2, NULL, 'category.xml', 'EE185CE0B82B41C1724F284685', NULL),
  283. ('7', 1, NULL, '2002-05-29 00:00:00', '1', '2008-05-22 12:54:16', 'Section', 1, 'section', 2, NULL, 'section.xml', 'EE185CE0B82B41C1724F284685', NULL),
  284. ('EE187CB92554E9877310D9041D', 0, NULL, '2002-06-27 00:00:00', '1', '2008-05-22 12:54:16', 'Assign User to a Site', 0, 'assign_user_site', 0, NULL, 'EE188C8D1BCFFF7C61672BFA2Cassign_user_site.xml', 'EE185CE0B82B41C1724F284685', NULL),
  285. ('EE399186B35C580610D4EDD7A3', 1, NULL, '2002-06-10 00:00:00', '1', '2008-05-22 12:54:16', 'Collection Content', 0, 'collection_descriptor', 1, NULL, 'EE39A7FDB43CDFD00B21EA6672coll_desc.xml', 'EE185CE0B82B41C1724F284685', NULL),
  286. ('EE8C6A49BC200D77F9DD3F92AA', 1, NULL, '2002-06-27 00:00:00', '1', '2008-05-22 12:54:16', 'User Manager', 0, 'user_site', 1, NULL, 'EE8C72398F20734B22553E88D6user_site.xml', 'EE185CE0B82B41C1724F284685', NULL),
  287. ('EEB49F22144357635AD6A684B6', 1, NULL, '2002-07-19 00:00:00', '1', '2008-05-22 12:54:16', 'Role Manager', 0, 'rolemanager', 2, NULL, '', 'EE185CE0B82B41C1724F284685', NULL),
  288. ('EF1F0CD62F63F3B0A7205D5BC4', 1, NULL, '2002-07-19 00:00:00', '1', '2008-05-22 12:54:16', 'Role Site Privilage', 0, 'rsp', 2, NULL, '', 'EE185CE0B82B41C1724F284685', NULL),
  289. ('F2E587923AC44C8979FBF2F26C', 1, NULL, '2005-09-19 23:48:26', '1', '2008-05-22 12:54:16', 'Job Position', 0, 'job_position', 2, NULL, 'F2E59F1CD7D0A8F31C1B034C4Bjob_position.xml', 'EE185CE0B82B41C1724F284685', NULL),
  290. ('F332B5D5577E444B78297AFE84', 1, NULL, '2005-09-19 23:48:08', '1', '2008-05-22 12:54:16', 'Company', 0, 'company', 2, NULL, 'F33682657AE8F60C0818178F40company.xml', 'EE185CE0B82B41C1724F284685', NULL),
  291. ('F76A9583B418F4FB3D261C1D53', 1, NULL, '2003-09-04 10:13:28', NULL, '2008-05-22 12:54:16', 'User Manager ver.2.0', 0, 'usersite_v2.0', 1, NULL, NULL, 'EE185CE0B82B41C1724F284685', NULL),
  292. ('ff808081151cf62001151cf94fb0', 1, NULL, '2007-09-19 15:54:01', '1', '2008-05-22 12:54:16', 'GXWindow', 1, 'window', 2, NULL, '', NULL, NULL),
  293. ('ff808081152136f101152137b298', 1, NULL, '2007-09-20 11:40:39', '1', '2008-05-22 12:54:16', 'GX2-Table', 1, 'gx-table', 2, NULL, '', NULL, NULL),
  294. ('ff808081153a8e6301153a90b1e9', 1, NULL, '2007-09-25 09:48:22', '1', '2008-05-22 12:54:16', 'Droplist GX2', 1, 'gx-droplist', 2, NULL, '', NULL, NULL),
  295. ('ff808081163cbe8a01163cc1db2f0001', 1, NULL, '2007-11-14 13:04:05', '1', '2008-05-22 12:54:16', 'user', 1, 'user', 2, NULL, '', NULL, NULL),
  296. ('ff8081811ab34d3d011ab35046030001', 1, '1', '2008-06-23 09:45:59', '1', '2008-06-23 09:45:59', 'Action Type', -1, 'actiontype', 2, '', '', NULL, NULL),
  297. ('ff8081811abdfa54011abdfb6a840001', 1, '1', '2008-06-25 11:29:08', '1', '2008-06-25 11:29:08', 'Role Descriptor ACL', -1, 'roledescriptor', 2, '', '', NULL, NULL),
  298. ('ff8081811ae1d2a0011ae1d34d2c0001', 1, '1', '2008-07-02 10:31:38', '1', '2008-07-02 10:31:38', 'Role Site Descriptor ACL', -1, 'rolesitedescriptor', 2, '', '', NULL, NULL),
  299. ('ff8081811b064fc9011b0650c67c0001', 1, '1', '2008-07-09 12:35:01', '1', '2008-07-09 12:35:01', 'Site Descriptor', -1, 'sitedescriptor', 2, '', '', NULL, NULL),
  300. ('ff8081811b1ab72e011b1ac871650001', 1, '1', '2008-07-13 11:58:08', '1', '2008-07-13 11:58:08', 'Window Role ACL', -1, 'windowrole', 2, '', '', NULL, NULL),
  301. ('ff8081811b20754f011b2090def70001', 1, '1', '2008-07-14 14:55:09', '1', '2008-07-14 14:55:09', 'Gx Window Role', -1, 'gxwindowrole', 2, '', '', NULL, NULL),
  302. ('ff8081811cf90e28011cf91426cf0001', 1, '1', '2008-10-14 08:59:19', '1', '2008-10-14 08:59:19', 'Invitation', -1, 'invite', 2, '', '', NULL, NULL),
  303. ('ff8081811cf90e28011cf91474600002', 1, '1', '2008-10-14 08:59:39', '1', '2008-10-14 08:59:39', 'Survey Management', -1, 'aroma', 2, '', '', NULL, NULL),
  304. ('ff8081811cf90e28011cf91513d30003', 1, '1', '2008-10-14 09:00:20', '1', '2008-10-14 09:00:20', 'Aroma Profile', -1, 'aromaprofile', 2, '', '', NULL, NULL),
  305. ('ff8081812da1ca99012da1cca3fc0001', 1, '1', '2011-01-20 12:01:39', '1', '2011-04-18 04:38:22', 'Karyawan', -1, 'KARYAWAN', 2, '', '', NULL, NULL),
  306. ('ff8081812da1ca99012da1d17080000c', 1, '1', '2011-01-20 12:06:53', '1', '2011-04-18 04:41:15', 'Jabatan', -1, 'JABATAN', 2, '', '', NULL, NULL),
  307. ('ff8081812da1ca99012da1d25879000e', 1, '1', '2011-01-20 12:07:53', '1', '2011-04-18 04:37:28', 'Jenis Cuti', -1, 'JENIS CUTI', 2, '', '', NULL, NULL),
  308. ('ff8081812da1d39b012da1d4c4ec0001', 1, '1', '2011-01-20 12:10:31', '1', '2011-01-20 12:10:31', 'PENGAJUAN', -1, 'PENGAJUAN', 2, '', '', NULL, NULL),
  309. ('ff8081812db746fb012db74881af0001', 1, '1', '2011-01-24 16:08:58', '1', '2011-04-18 04:39:12', 'Konfirmasi Pengajuan Cuti', -1, 'KONFIRMASI PENGAJUAN CUTI', 2, '', '', NULL, NULL),
  310. ('402809da2f6dff62012f6e00b9ea0001', 1, '1', '2011-04-19 20:43:52', '1', '2011-04-19 20:43:52', 'Cuti Bersama', -1, 'CUTI BERSAMA', 2, '', '', NULL, NULL),
  311. ('ff8081812faeea77012faef180a00001', 1, '1', '2011-05-02 11:22:33', '1', '2011-05-02 11:22:33', 'Kalender Cuti', -1, 'KALENDER CUTI', 2, '', '', NULL, NULL);
  312.  
  313. -- --------------------------------------------------------
  314.  
  315. --
  316. -- Table structure for table `gx_db_column`
  317. --
  318.  
  319. CREATE TABLE IF NOT EXISTS `gx_db_column` (
  320. `id` varchar(255) NOT NULL,
  321. `active_flag` int(11) DEFAULT NULL,
  322. `create_by` varchar(255) DEFAULT NULL,
  323. `create_date` datetime DEFAULT NULL,
  324. `update_by` varchar(255) DEFAULT NULL,
  325. `update_date` datetime DEFAULT NULL,
  326. `db_column` varchar(255) DEFAULT NULL,
  327. `description` varchar(255) DEFAULT NULL,
  328. `encrypted_flag` int(11) DEFAULT NULL,
  329. `key_column_flag` int(11) DEFAULT NULL,
  330. `length` int(11) DEFAULT NULL,
  331. `mandatory_flag` int(11) DEFAULT NULL,
  332. `max_length` int(11) DEFAULT NULL,
  333. `min_length` int(11) DEFAULT NULL,
  334. `name` varchar(255) DEFAULT NULL,
  335. `parent_link_column_flag` int(11) DEFAULT NULL,
  336. `reference_flag` int(11) DEFAULT NULL,
  337. `site_id` varchar(255) DEFAULT NULL,
  338. `element_id` varchar(255) DEFAULT NULL,
  339. `reference_droplist_id` varchar(255) DEFAULT NULL,
  340. `reference_table_id` varchar(255) DEFAULT NULL,
  341. `table_id` varchar(255) DEFAULT NULL,
  342. PRIMARY KEY (`id`),
  343. KEY `FK8A8BA86953C5DB3` (`reference_droplist_id`),
  344. KEY `FK8A8BA8696598D100` (`element_id`),
  345. KEY `FK8A8BA869785E49CC` (`reference_table_id`),
  346. KEY `FK8A8BA8693CAE8F1E` (`site_id`),
  347. KEY `FK8A8BA869D1195358` (`table_id`)
  348. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  349.  
  350. --
  351. -- Dumping data for table `gx_db_column`
  352. --
  353.  
  354.  
  355. -- --------------------------------------------------------
  356.  
  357. --
  358. -- Table structure for table `gx_db_table`
  359. --
  360.  
  361. CREATE TABLE IF NOT EXISTS `gx_db_table` (
  362. `id` varchar(255) NOT NULL,
  363. `active_flag` int(11) DEFAULT NULL,
  364. `create_by` varchar(255) DEFAULT NULL,
  365. `create_date` datetime DEFAULT NULL,
  366. `update_by` varchar(255) DEFAULT NULL,
  367. `update_date` datetime DEFAULT NULL,
  368. `db_table` varchar(255) DEFAULT NULL,
  369. `description` varchar(255) DEFAULT NULL,
  370. `name` varchar(255) DEFAULT NULL,
  371. `site_id` varchar(255) DEFAULT NULL,
  372. `data_access_level_id` varchar(255) DEFAULT NULL,
  373. `entity_id` varchar(255) DEFAULT NULL,
  374. `window_id` varchar(255) DEFAULT NULL,
  375. PRIMARY KEY (`id`),
  376. KEY `FKEC9AF85B17208EB9` (`entity_id`),
  377. KEY `FKEC9AF85BD45FA55E` (`data_access_level_id`),
  378. KEY `FKEC9AF85BC1381B1C` (`window_id`),
  379. KEY `FKEC9AF85B3CAE8F1E` (`site_id`)
  380. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  381.  
  382. --
  383. -- Dumping data for table `gx_db_table`
  384. --
  385.  
  386.  
  387. -- --------------------------------------------------------
  388.  
  389. --
  390. -- Table structure for table `gx_droplist_name`
  391. --
  392.  
  393. CREATE TABLE IF NOT EXISTS `gx_droplist_name` (
  394. `id` varchar(255) NOT NULL,
  395. `active_flag` int(11) DEFAULT NULL,
  396. `create_by` varchar(255) DEFAULT NULL,
  397. `create_date` datetime DEFAULT NULL,
  398. `update_by` varchar(255) DEFAULT NULL,
  399. `update_date` datetime DEFAULT NULL,
  400. `description` varchar(255) DEFAULT NULL,
  401. `name` varchar(255) NOT NULL,
  402. `site_id` varchar(255) DEFAULT NULL,
  403. `parent_id` varchar(255) DEFAULT NULL,
  404. PRIMARY KEY (`id`),
  405. UNIQUE KEY `name` (`name`),
  406. UNIQUE KEY `name_2` (`name`),
  407. KEY `FK707448AF3CAE8F1E` (`site_id`),
  408. KEY `FK707448AF754C7EEA` (`parent_id`)
  409. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  410.  
  411. --
  412. -- Dumping data for table `gx_droplist_name`
  413. --
  414.  
  415. INSERT INTO `gx_droplist_name` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `name`, `site_id`, `parent_id`) VALUES
  416. ('ff808081153bcda301153bce42640001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 08:54:53', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:33:48', 'Column Data Type', 'columndatatype', NULL, 'ff80808115f0a3280115f0b0103b0003'),
  417. ('ff80808115422db9011542327c580001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 21:22:25', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:34:09', 'Field Data Type', 'fielddatatype', NULL, 'ff80808115f0a3280115f0afa52a0002'),
  418. ('ff80808115425bc401154271168a0001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 22:30:48', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 22:30:48', 'Country', 'country', NULL, NULL),
  419. ('ff80808115ace81f0115acee87d70001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 14:47:34', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:30:29', 'Used in GxWindow', 'window', NULL, 'ff80808115d6cdb70115d6cf03060001'),
  420. ('ff80808115ace81f0115acef78020002', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 14:49:20', '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 16:42:01', 'Window Type', 'window_type', NULL, 'ff80808115ace81f0115acee87d70001'),
  421. ('ff80808115d6cdb70115d6cf03060001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-25 17:57:11', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:31:54', 'Used In Gx Cimande Workspace', 'GX', NULL, NULL),
  422. ('ff80808115f0a3280115f0afa52a0002', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:33:03', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:33:03', 'Used in GxTab', 'tab', NULL, 'ff80808115d6cdb70115d6cf03060001'),
  423. ('ff80808115f0a3280115f0b0103b0003', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:33:31', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 18:33:31', 'Used in GxColumn', 'column', NULL, 'ff80808115d6cdb70115d6cf03060001'),
  424. ('ff80808115f0cf5a0115f0d214ed0002', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:10:40', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:10:40', 'Access Control Type', 'acl_type', NULL, 'ff80808115d6cdb70115d6cf03060001');
  425.  
  426. -- --------------------------------------------------------
  427.  
  428. --
  429. -- Table structure for table `gx_droplist_value`
  430. --
  431.  
  432. CREATE TABLE IF NOT EXISTS `gx_droplist_value` (
  433. `id` varchar(255) NOT NULL,
  434. `active_flag` int(11) DEFAULT NULL,
  435. `create_by` varchar(255) DEFAULT NULL,
  436. `create_date` datetime DEFAULT NULL,
  437. `update_by` varchar(255) DEFAULT NULL,
  438. `update_date` datetime DEFAULT NULL,
  439. `description` varchar(255) DEFAULT NULL,
  440. `value` varchar(255) DEFAULT NULL,
  441. `site_id` varchar(255) DEFAULT NULL,
  442. `droplist_name_id` varchar(255) DEFAULT NULL,
  443. PRIMARY KEY (`id`),
  444. KEY `FK9E8587CD9304CF37` (`droplist_name_id`),
  445. KEY `FK9E8587CD3CAE8F1E` (`site_id`)
  446. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  447.  
  448. --
  449. -- Dumping data for table `gx_droplist_value`
  450. --
  451.  
  452. INSERT INTO `gx_droplist_value` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `value`, `site_id`, `droplist_name_id`) VALUES
  453. ('ff808081153c589b01153c5946ad0001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:07:43', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 14:17:04', 'String', 'String', NULL, 'ff808081153bcda301153bce42640001'),
  454. ('ff808081153c6d5601153c6e1a6e0001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:07:44', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 14:17:27', 'Number', 'Number', NULL, 'ff808081153bcda301153bce42640001'),
  455. ('ff808081153c724b01153c7430e70001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:07:46', '96f673bc-283e-4b75-b63d-6edc', '2007-10-23 18:06:01', 'Table', 'Table', NULL, 'ff808081153bcda301153bce42640001'),
  456. ('ff80808115408aa7011540ade5ec0006', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:07:49', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 14:17:59', 'Date', 'Date', NULL, 'ff808081153bcda301153bce42640001'),
  457. ('ff80808115422db90115423307c10002', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:07:56', '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 15:47:00', 'Textfield', 'text', NULL, 'ff80808115422db9011542327c580001'),
  458. ('ff80808115422db90115423349760003', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:07:57', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 21:23:18', 'Textarea', 'textarea', NULL, 'ff80808115422db9011542327c580001'),
  459. ('ff80808115422db901154233b5300004', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:07:58', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 21:23:45', 'Radio Button', 'radio', NULL, 'ff80808115422db9011542327c580001'),
  460. ('ff80808115422db9011542345ab40005', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:00', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 21:24:28', 'Check Box', 'checkbox', NULL, 'ff80808115422db9011542327c580001'),
  461. ('ff80808115422db901154234e44d0006', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:01', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 21:25:03', 'Droplist Select Box', 'select', NULL, 'ff80808115422db9011542327c580001'),
  462. ('ff80808115422db9011542354dee0007', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:02', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 21:25:30', 'File Upload', 'file', NULL, 'ff80808115422db9011542327c580001'),
  463. ('ff80808115422db901154235bdec0008', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:04', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 21:25:59', 'Reference Table', 'reference', NULL, 'ff80808115422db9011542327c580001'),
  464. ('ff80808115425bc40115427185fd0002', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:11', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 22:31:17', 'Indonesia', 'Indonesia', NULL, 'ff80808115425bc401154271168a0001'),
  465. ('ff80808115425bc40115427208120003', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:12', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 22:31:50', 'United States of America', 'USA', NULL, 'ff80808115425bc401154271168a0001'),
  466. ('ff80808115425bc401154272533c0004', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:13', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 22:32:09', 'United Kingdom', 'UK', NULL, 'ff80808115425bc401154271168a0001'),
  467. ('ff80808115425bc40115427287080005', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:15', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 22:32:22', 'Malaysia', 'Malaysia', NULL, 'ff80808115425bc401154271168a0001'),
  468. ('ff8080811542796a0115428c3e8a0001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:17', '96f673bc-283e-4b75-b63d-6edc', '2007-09-26 23:00:28', 'Japanese', 'Japanese', NULL, 'ff80808115425bc401154271168a0001'),
  469. ('ff8080811542f5340115445dfabb0001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 09:08:32', '96f673bc-283e-4b75-b63d-6edc', '2007-09-27 07:29:10', 'Hidden', 'hidden', NULL, 'ff80808115422db9011542327c580001'),
  470. ('ff80808115ace81f0115acf1eaae0003', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 14:51:16', '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 14:51:16', 'Default', 'default', NULL, 'ff80808115ace81f0115acef78020002'),
  471. ('ff80808115ace81f0115acf239340004', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 14:51:36', '96f673bc-283e-4b75-b63d-6edc', '2007-10-17 14:51:36', 'Extended', 'extended', NULL, 'ff80808115ace81f0115acef78020002'),
  472. ('ff80808115cc81140115cc8a8dbe0001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-23 18:06:13', '96f673bc-283e-4b75-b63d-6edc', '2007-10-23 18:06:13', 'Droplist', 'Droplist', NULL, 'ff808081153bcda301153bce42640001'),
  473. ('ff80808115f0cf5a0115f0d2732b0003', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:11:04', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:11:04', 'Create New Record', 'create', NULL, 'ff80808115f0cf5a0115f0d214ed0002'),
  474. ('ff80808115f0cf5a0115f0d3125c0004', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:11:45', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:11:45', 'Search and Read From Database', 'read', NULL, 'ff80808115f0cf5a0115f0d214ed0002'),
  475. ('ff80808115f0cf5a0115f0d3629b0005', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:12:06', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:12:06', 'Update Record', 'update', NULL, 'ff80808115f0cf5a0115f0d214ed0002'),
  476. ('ff80808115f0cf5a0115f0d3a7af0006', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:12:23', '96f673bc-283e-4b75-b63d-6edc', '2007-10-30 19:12:23', 'Delete Record', 'delete', NULL, 'ff80808115f0cf5a0115f0d214ed0002');
  477.  
  478. -- --------------------------------------------------------
  479.  
  480. --
  481. -- Table structure for table `gx_form_field`
  482. --
  483.  
  484. CREATE TABLE IF NOT EXISTS `gx_form_field` (
  485. `id` varchar(255) NOT NULL,
  486. `active_flag` int(11) DEFAULT NULL,
  487. `create_by` varchar(255) DEFAULT NULL,
  488. `create_date` datetime DEFAULT NULL,
  489. `update_by` varchar(255) DEFAULT NULL,
  490. `update_date` datetime DEFAULT NULL,
  491. `description` varchar(255) DEFAULT NULL,
  492. `displayed_length` int(11) DEFAULT NULL,
  493. `displayed_flag` int(11) DEFAULT NULL,
  494. `name` varchar(255) DEFAULT NULL,
  495. `sequence` int(11) NOT NULL,
  496. `site_id` varchar(255) DEFAULT NULL,
  497. `column_id` varchar(255) DEFAULT NULL,
  498. `entity_type_id` varchar(255) DEFAULT NULL,
  499. `tab_id` varchar(255) DEFAULT NULL,
  500. PRIMARY KEY (`id`),
  501. KEY `FKE202E5CD89B487A6` (`entity_type_id`),
  502. KEY `FKE202E5CDA4D86978` (`tab_id`),
  503. KEY `FKE202E5CD3CAE8F1E` (`site_id`),
  504. KEY `FKE202E5CD2C6F195C` (`column_id`)
  505. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  506.  
  507. --
  508. -- Dumping data for table `gx_form_field`
  509. --
  510.  
  511.  
  512. -- --------------------------------------------------------
  513.  
  514. --
  515. -- Table structure for table `gx_form_tab`
  516. --
  517.  
  518. CREATE TABLE IF NOT EXISTS `gx_form_tab` (
  519. `id` varchar(255) NOT NULL,
  520. `active_flag` int(11) DEFAULT NULL,
  521. `create_by` varchar(255) DEFAULT NULL,
  522. `create_date` datetime DEFAULT NULL,
  523. `update_by` varchar(255) DEFAULT NULL,
  524. `update_date` datetime DEFAULT NULL,
  525. `description` varchar(255) DEFAULT NULL,
  526. `name` varchar(255) DEFAULT NULL,
  527. `sequence` int(11) NOT NULL,
  528. `single_row_layout_flag` int(11) DEFAULT NULL,
  529. `site_id` varchar(255) DEFAULT NULL,
  530. `process_id` varchar(255) DEFAULT NULL,
  531. `table_id` varchar(255) DEFAULT NULL,
  532. `window_id` varchar(255) DEFAULT NULL,
  533. PRIMARY KEY (`id`),
  534. KEY `FK8C171D28C1381B1C` (`window_id`),
  535. KEY `FK8C171D283CAE8F1E` (`site_id`),
  536. KEY `FK8C171D28D1195358` (`table_id`),
  537. KEY `FK8C171D285C6EB8AD` (`process_id`)
  538. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  539.  
  540. --
  541. -- Dumping data for table `gx_form_tab`
  542. --
  543.  
  544.  
  545. -- --------------------------------------------------------
  546.  
  547. --
  548. -- Table structure for table `gx_form_window`
  549. --
  550.  
  551. CREATE TABLE IF NOT EXISTS `gx_form_window` (
  552. `id` varchar(255) NOT NULL,
  553. `active_flag` int(11) DEFAULT NULL,
  554. `create_by` varchar(255) DEFAULT NULL,
  555. `create_date` datetime DEFAULT NULL,
  556. `update_by` varchar(255) DEFAULT NULL,
  557. `update_date` datetime DEFAULT NULL,
  558. `description` varchar(255) DEFAULT NULL,
  559. `height` int(11) NOT NULL,
  560. `image` varchar(255) DEFAULT NULL,
  561. `name` varchar(255) DEFAULT NULL,
  562. `width` int(11) NOT NULL,
  563. `site_id` varchar(255) DEFAULT NULL,
  564. `entity_type_id` varchar(255) DEFAULT NULL,
  565. `window_type_id` varchar(255) DEFAULT NULL,
  566. PRIMARY KEY (`id`),
  567. KEY `FK7B60317D89B487A6` (`entity_type_id`),
  568. KEY `FK7B60317D3CAE8F1E` (`site_id`),
  569. KEY `FK7B60317DBE2422B3` (`window_type_id`)
  570. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  571.  
  572. --
  573. -- Dumping data for table `gx_form_window`
  574. --
  575.  
  576. INSERT INTO `gx_form_window` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `height`, `image`, `name`, `width`, `site_id`, `entity_type_id`, `window_type_id`) VALUES
  577. ('ff80808115b6b1dd0115b6f2f4ae0009', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-10-19 13:28:36', '96f673bc-283e-4b75-b63d-6edc', '2008-07-13 12:37:39', 'Purchasing Window', 100, '', 'Purchasing', 100, NULL, NULL, NULL),
  578. ('ff8080811647f2f1011647f99cd70006', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-16 17:20:49', '96f673bc-283e-4b75-b63d-6edc', '2008-07-13 12:37:39', 'Employee Registration', 50, '', 'Employee', 50, NULL, NULL, NULL);
  579.  
  580. -- --------------------------------------------------------
  581.  
  582. --
  583. -- Table structure for table `gx_window_role`
  584. --
  585.  
  586. CREATE TABLE IF NOT EXISTS `gx_window_role` (
  587. `id` varchar(255) NOT NULL,
  588. `active_flag` int(11) DEFAULT NULL,
  589. `create_by` varchar(255) DEFAULT NULL,
  590. `create_date` datetime DEFAULT NULL,
  591. `update_by` varchar(255) DEFAULT NULL,
  592. `update_date` datetime DEFAULT NULL,
  593. `site_id` varchar(255) DEFAULT NULL,
  594. `role_id` varchar(255) DEFAULT NULL,
  595. `window_id` varchar(255) DEFAULT NULL,
  596. PRIMARY KEY (`id`),
  597. KEY `FKFAB3DD17456510EF` (`role_id`),
  598. KEY `FKFAB3DD17C1381B1C` (`window_id`),
  599. KEY `FKFAB3DD173CAE8F1E` (`site_id`)
  600. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  601.  
  602. --
  603. -- Dumping data for table `gx_window_role`
  604. --
  605.  
  606. INSERT INTO `gx_window_role` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `role_id`, `window_id`) VALUES
  607. ('ff808081161f180d01161f1cae9a0001', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:54:41', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:54:41', NULL, 'ff80808113bece750113bed0f44c', 'ff80808115b6b1dd0115b6f2f4ae0009'),
  608. ('ff808081161f180d01161f1dbb1c0004', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', NULL, 'ff808081104d995b01104da90177', 'ff80808115b6b1dd0115b6f2f4ae0009');
  609.  
  610. -- --------------------------------------------------------
  611.  
  612. --
  613. -- Table structure for table `gx_window_role_access`
  614. --
  615.  
  616. CREATE TABLE IF NOT EXISTS `gx_window_role_access` (
  617. `id` varchar(255) NOT NULL,
  618. `active_flag` int(11) DEFAULT NULL,
  619. `create_by` varchar(255) DEFAULT NULL,
  620. `create_date` datetime DEFAULT NULL,
  621. `update_by` varchar(255) DEFAULT NULL,
  622. `update_date` datetime DEFAULT NULL,
  623. `allowed` char(1) DEFAULT NULL,
  624. `site_id` varchar(255) DEFAULT NULL,
  625. `dv_access_name_id` varchar(255) DEFAULT NULL,
  626. `window_role_id` varchar(255) DEFAULT NULL,
  627. `acl_id` varchar(255) DEFAULT NULL,
  628. `gx_window_role_id` varchar(255) DEFAULT NULL,
  629. PRIMARY KEY (`id`),
  630. KEY `FK2B7C3D8CEE7064B2` (`acl_id`),
  631. KEY `FK2B7C3D8CEBD8BA83` (`dv_access_name_id`),
  632. KEY `FK2B7C3D8C3CAE8F1E` (`site_id`),
  633. KEY `FK2B7C3D8C1123302B` (`gx_window_role_id`),
  634. KEY `FK2B7C3D8C87FE6F1D` (`window_role_id`)
  635. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  636.  
  637. --
  638. -- Dumping data for table `gx_window_role_access`
  639. --
  640.  
  641. INSERT INTO `gx_window_role_access` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `allowed`, `site_id`, `dv_access_name_id`, `window_role_id`, `acl_id`, `gx_window_role_id`) VALUES
  642. ('ff808081161f180d01161f1caee50002', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:54:41', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:54:41', '0', NULL, 'ff80808115f0cf5a0115f0d2732b0003', 'ff808081161f180d01161f1cae9a0001', NULL, NULL),
  643. ('ff808081161f180d01161f1caeee0003', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:54:41', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:54:41', '0', NULL, 'ff80808115f0cf5a0115f0d3125c0004', 'ff808081161f180d01161f1cae9a0001', NULL, NULL),
  644. ('ff808081161f180d01161f1dbb250005', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '0', NULL, 'ff80808115f0cf5a0115f0d2732b0003', 'ff808081161f180d01161f1dbb1c0004', NULL, NULL),
  645. ('ff808081161f180d01161f1dbb280006', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '0', NULL, 'ff80808115f0cf5a0115f0d3125c0004', 'ff808081161f180d01161f1dbb1c0004', NULL, NULL),
  646. ('ff808081161f180d01161f1dbb2e0007', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '0', NULL, 'ff80808115f0cf5a0115f0d3629b0005', 'ff808081161f180d01161f1dbb1c0004', NULL, NULL),
  647. ('ff808081161f180d01161f1dbb320008', 1, '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '96f673bc-283e-4b75-b63d-6edc', '2007-11-08 18:55:50', '0', NULL, 'ff80808115f0cf5a0115f0d3a7af0006', 'ff808081161f180d01161f1dbb1c0004', NULL, NULL);
  648.  
  649. -- --------------------------------------------------------
  650.  
  651. --
  652. -- Table structure for table `job_position`
  653. --
  654.  
  655. CREATE TABLE IF NOT EXISTS `job_position` (
  656. `id` varchar(255) NOT NULL,
  657. `active_flag` int(11) DEFAULT NULL,
  658. `create_by` varchar(255) DEFAULT NULL,
  659. `create_date` datetime DEFAULT NULL,
  660. `update_by` varchar(255) DEFAULT NULL,
  661. `update_date` datetime DEFAULT NULL,
  662. `description` varchar(255) DEFAULT NULL,
  663. `name` varchar(255) DEFAULT NULL,
  664. `site_id` varchar(255) DEFAULT NULL,
  665. PRIMARY KEY (`id`),
  666. KEY `FK74CD136B3CAE8F1E` (`site_id`)
  667. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  668.  
  669. --
  670. -- Dumping data for table `job_position`
  671. --
  672.  
  673. INSERT INTO `job_position` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `name`, `site_id`) VALUES
  674. ('mgr', 0, '1', '2005-09-19 23:59:09', 'ff8081812da1ca99012da1d013bb0009', '2011-02-09 16:54:14', 'Manager', 'manager', NULL),
  675. ('ff8081812e0d7b10012e0e2414ae0001', 0, '1', '2011-02-10 12:56:08', 'ff8081812da1ca99012da1d013bb0009', '2011-04-16 00:08:05', 'Tetap sekali', 'Karyawan', NULL),
  676. ('ff8081812e0d7b10012e0e5c778e0009', 1, '1', '2011-02-10 13:57:44', 'ff8081812da1ca99012da1d013bb0009', '2011-05-07 14:27:51', 'Tetap', 'Supervisor', NULL),
  677. ('ff8080812f3fde41012f3fe2a0060002', 0, '1', '2011-04-10 21:48:27', 'ff8081812da1ca99012da1d013bb0009', '2011-04-15 11:42:10', 'mengurus pembelian dari luar negri', 'suplay cain sip', NULL),
  678. ('4028818f2f5a20f3012f5a21facc0001', 0, '1', '2011-04-16 00:07:47', 'ff8081812da1ca99012da1d013bb0009', '2011-04-18 14:48:47', 'manager', 'manager', NULL),
  679. ('402809ab2f679278012f6795278d0001', 1, '1', '2011-04-18 14:48:38', '1', '2011-04-18 14:48:38', 'Manager', 'Manager', NULL),
  680. ('402809ab2f679278012f6795825b0002', 1, '1', '2011-04-18 14:49:02', '1', '2011-04-18 14:49:02', 'Staff', 'Staff', NULL),
  681. ('402882832f6e4373012f6e44070d0001', 0, '1', '2011-04-19 21:57:22', 'ff8081812da1ca99012da1d013bb0009', '2011-04-19 22:13:13', 'penghimpunan dana', 'suplay cain', NULL),
  682. ('402882832f6e5207012f6e52a5070001', 0, '1', '2011-04-19 22:13:20', 'ff8081812da1ca99012da1d013bb0009', '2011-04-19 22:13:26', 'fdcygerty', 'wqeqwe', NULL),
  683. ('402882a22f7ec8b6012f7ecbf9440001', 0, '1', '2011-04-23 02:59:47', 'ff8081812da1ca99012da1d013bb0009', '2011-05-07 14:41:35', 'HRD', 'HRD', NULL);
  684.  
  685. -- --------------------------------------------------------
  686.  
  687. --
  688. -- Table structure for table `module_function`
  689. --
  690.  
  691. CREATE TABLE IF NOT EXISTS `module_function` (
  692. `id` varchar(255) NOT NULL,
  693. `active_flag` int(11) DEFAULT NULL,
  694. `create_by` varchar(255) DEFAULT NULL,
  695. `create_date` datetime DEFAULT NULL,
  696. `update_by` varchar(255) DEFAULT NULL,
  697. `update_date` datetime DEFAULT NULL,
  698. `description` varchar(255) DEFAULT NULL,
  699. `name` varchar(255) DEFAULT NULL,
  700. `ref_desc` varchar(255) DEFAULT NULL,
  701. `viewall_flag` int(11) DEFAULT NULL,
  702. `site_id` varchar(255) DEFAULT NULL,
  703. `descriptor_id` varchar(255) DEFAULT NULL,
  704. `iparent` varchar(255) DEFAULT NULL,
  705. PRIMARY KEY (`id`),
  706. KEY `FK6A1F784BF5B73B87` (`descriptor_id`),
  707. KEY `FK6A1F784B3CAE8F1E` (`site_id`),
  708. KEY `FK6A1F784BCE69F19E` (`iparent`)
  709. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  710.  
  711. --
  712. -- Dumping data for table `module_function`
  713. --
  714.  
  715. INSERT INTO `module_function` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `name`, `ref_desc`, `viewall_flag`, `site_id`, `descriptor_id`, `iparent`) VALUES
  716. ('0', 1, '1', '2007-11-14 13:04:05', '1', '2007-11-15 21:26:13', 'Master', 'Master', 'id', 1, 'EE185CE0B82B41C1724F284685', '1', NULL),
  717. ('402880f91d19d3fb011d19d6ca590002', 1, '1', '2008-10-20 17:39:46', '1', '2008-10-20 17:44:26', 'induk', 'induk', '', 1, NULL, NULL, '0'),
  718. ('402880f91d19d3fb011d19d9cd680005', 1, '1', '2008-10-20 17:43:03', '1', '2008-10-20 17:43:03', 'child1', 'test1', '', 1, NULL, '402880f91d19d3fb011d19d95edf0004', '402880f91d19d3fb011d19d6ca590002'),
  719. ('402880f91d19d3fb011d19ddd832000b', 1, '1', '2008-10-20 17:47:28', '1', '2008-10-20 17:47:28', 'induk2', 'induk2', '', 1, NULL, NULL, '0'),
  720. ('402880f91d19d3fb011d19dea69e000c', 1, '1', '2008-10-20 17:48:21', '1', '2008-11-27 17:11:19', 'subInduk3', 'subInduk3', 'vbb', 1, NULL, NULL, '402880f91d19d3fb011d19ddd832000b'),
  721. ('402880f91d19d3fb011d19df7836000e', 1, '1', '2008-10-20 17:49:15', '1', '2008-10-20 17:49:15', 'child3', 'test3', '', 1, NULL, '402880f91d19d3fb011d19df08d2000d', '402880f91d19d3fb011d19dea69e000c'),
  722. ('ff80808105a3a8ed0105a3b185a9', 1, '1', '2005-08-11 11:30:23', '', '2008-03-17 18:29:48', 'Site Manager', 'Site Manager', 'id', 0, 'EE185CE0B82B41C1724F284685', '1', '0'),
  723. ('ff80808105a3a8ed0105a3b4137b', 1, '1', '2005-08-11 11:22:37', '', '2008-03-17 18:29:48', 'User Management', 'User Management', 'id', 1, 'EE185CE0B82B41C1724F284685', '1', 'ff80808105a3a8ed0105a3b185a9'),
  724. ('ff80808105a3b96f0105a3bdf32c', 1, '1', '2005-08-11 11:30:31', '', '2008-03-17 18:29:48', 'Workflow Designer', 'Workflow Designer', 'id', 1, 'EE185CE0B82B41C1724F284685', '1', '0'),
  725. ('ff80808105a3b96f0105a3e1e581', 1, '1', '2005-08-11 11:52:34', '', '2008-03-17 18:29:48', 'Company', 'Company', 'id', 1, NULL, 'F332B5D5577E444B78297AFE84', 'ff80808105a3a8ed0105a3b4137b'),
  726. ('ff80808105a3b96f0105a3e418bd', 1, '1', '2005-08-11 11:54:59', '', '2008-03-17 18:29:48', 'Job Position', 'Job Position', 'id', 1, NULL, 'F2E587923AC44C8979FBF2F26C', 'ff80808105a3a8ed0105a3b4137b'),
  727. ('ff80808105a3b96f0105a402cfe0', 1, '1', '2005-08-11 12:28:31', '', '2008-03-17 18:29:48', 'Multi Site', 'Multi Site', 'id', 0, NULL, '2', 'ff80808105a3a8ed0105a3b185a9'),
  728. ('ff80808105a3b96f0105a403f9f1', 1, '1', '2005-08-11 12:29:48', '', '2008-03-17 18:29:48', 'Module Manager', 'Module Manager', 'id', 0, NULL, '1', 'ff80808105a3a8ed0105a3b185a9'),
  729. ('ff80808105a3b96f0105a4083f82', 1, '1', '2005-08-11 12:34:28', '', '2008-03-17 18:29:48', 'Descriptor Manager', 'Descriptor Manager', 'description', 0, NULL, '1', 'ff80808105a3a8ed0105a3b185a9'),
  730. ('ff80808105a3b96f0105a40b7e1b', 1, '1', '2005-08-11 12:38:00', '', '2008-03-17 18:29:48', 'Site', 'Site', 'id', 0, NULL, '2', 'ff80808105a3b96f0105a402cfe0'),
  731. ('ff80808105a3b96f0105a41d0113', 1, '1', '2005-08-11 12:57:08', '', '2008-03-17 18:29:48', 'Role Site Privilage', 'Role Site Privilage', 'id', 1, NULL, 'EF1F0CD62F63F3B0A7205D5BC4', 'ff80808105a3b96f0105a403f9f1'),
  732. ('ff80808105a3b96f0105a41e79a7', 1, '1', '2005-08-11 12:58:44', '', '2008-03-17 18:29:48', 'Role Manager', 'Role Manager', 'id', 1, NULL, 'EEB49F22144357635AD6A684B6', 'ff80808105a3b96f0105a403f9f1'),
  733. ('ff80808105a3b96f0105a426ac13', 1, '1', '2005-08-11 13:07:42', '', '2008-03-17 18:29:48', 'Role Privilage', 'Role Privilage', 'role_id', 0, NULL, '32', 'ff80808105a3b96f0105a403f9f1'),
  734. ('ff80808105a3b96f0105a4279ca8', 1, '1', '2005-08-11 13:08:43', '', '2008-03-17 18:29:48', 'Module Function', 'Module Function', 'description', 0, NULL, '31', 'ff80808105a3b96f0105a403f9f1'),
  735. ('ff80808105a3b96f0105a431a20c', 1, '1', '2005-08-11 13:19:40', '', '2008-03-17 18:29:48', 'Descriptor', 'Descriptor', 'description', 0, NULL, '1', 'ff80808105a3b96f0105a4083f82'),
  736. ('ff80808105a3b96f0105a451002d', 1, '1', '2005-08-11 13:53:56', '', '2008-03-17 18:29:48', 'WF Role', 'WF Role', 'name', 1, NULL, '14', 'ff80808105a3b96f0105a3bdf32c'),
  737. ('ff808081151cf62001151cfd6d90', 1, '1', '2007-09-19 15:58:31', '', '2008-03-17 18:29:48', 'GX Admin', 'GXAdmin', '', 1, NULL, 'EE187CB92554E9877310D9041D', '0'),
  738. ('ff808081151cf62001151cfedc84', 1, '1', '2007-09-19 16:00:05', '', '2008-03-17 18:29:48', 'Window', 'window', '', 1, NULL, 'ff808081151cf62001151cf94fb0', 'ff808081151cf62001151cfd6d90'),
  739. ('ff808081152136f1011521388462', 1, '1', '2007-10-11 11:46:45', '', '2008-03-17 18:29:48', 'Table', 'GX2Table', '', 1, NULL, 'ff808081152136f101152137b298', 'ff808081151cf62001151cfd6d90'),
  740. ('ff808081153a8e6301153a926a5c', 1, '1', '2007-10-11 11:46:40', '', '2008-03-17 18:29:48', 'Droplist', 'GX2Droplist', '', 1, NULL, 'ff808081153a8e6301153a90b1e9', 'ff808081151cf62001151cfd6d90'),
  741. ('ff808081163cbe8a01163cc2c2280002', 1, '1', '2007-11-14 13:05:04', '', '2008-03-17 18:29:48', 'User Manager Ver.2.1', 'user_mvc', '', 1, NULL, 'ff808081163cbe8a01163cc1db2f0001', 'ff80808105a3a8ed0105a3b4137b'),
  742. ('ff8081811ab34d3d011ab353e2b00002', 1, '1', '2008-06-23 09:49:56', '1', '2008-06-23 09:49:56', 'Access Control', 'Access Control', '', 1, NULL, NULL, '0'),
  743. ('ff8081811ab34d3d011ab35471520003', 1, '1', '2008-06-23 09:50:33', '1', '2008-06-23 09:50:33', 'Action Type', 'actiontype', '', 1, NULL, 'ff8081811ab34d3d011ab35046030001', 'ff8081811ab34d3d011ab353e2b00002'),
  744. ('ff8081811abdfa54011abdfbfaff0002', 1, '1', '2008-06-25 11:29:45', '1', '2008-06-25 11:29:45', 'Role Descriptor ACL', 'roledescriptor', '', 1, NULL, 'ff8081811abdfa54011abdfb6a840001', 'ff8081811ab34d3d011ab353e2b00002'),
  745. ('ff8081811ae1d2a0011ae1d402dc0002', 1, '1', '2008-07-02 10:32:25', '1', '2008-07-02 10:32:25', 'Role Site Descriptor ACL', 'rolesitedescriptor', '', 1, NULL, 'ff8081811ae1d2a0011ae1d34d2c0001', 'ff8081811ab34d3d011ab353e2b00002'),
  746. ('ff8081811b064fc9011b065162f70002', 1, '1', '2008-07-09 12:35:41', '1', '2008-07-09 12:35:41', 'Site Descriptor', 'sitedescriptor', '', 1, NULL, 'ff8081811b064fc9011b0650c67c0001', 'ff8081811ab34d3d011ab353e2b00002'),
  747. ('ff8081811b1ab72e011b1ac91f6b0002', 1, '1', '2008-07-13 11:58:53', '1', '2008-07-14 14:55:50', 'Window Role Access', 'windowrole', '', 1, NULL, 'ff8081811b20754f011b2090def70001', 'ff8081811ab34d3d011ab353e2b00002'),
  748. ('ff8081811cf90e28011cf9167a730004', 1, '1', '2008-10-14 09:01:51', '1', '2008-10-14 09:01:51', 'Aroma', 'AromaAdmin', '', 1, NULL, NULL, '0'),
  749. ('ff8081811cf90e28011cf916dbc30005', 1, '1', '2008-10-14 09:02:16', '1', '2008-10-14 09:02:16', 'Invitation', 'invite', '', 1, NULL, 'ff8081811cf90e28011cf91426cf0001', 'ff8081811cf90e28011cf9167a730004'),
  750. ('ff8081811cf90e28011cf917338d0006', 1, '1', '2008-10-14 09:02:39', '1', '2008-10-14 09:02:39', 'Aroma Profile', 'aromaprofile', '', 1, NULL, 'ff8081811cf90e28011cf91513d30003', 'ff8081811cf90e28011cf9167a730004'),
  751. ('ff8081811cf90e28011cf9180bc70007', 1, '1', '2008-10-14 09:03:34', '1', '2008-10-14 09:03:34', 'Survey Management', 'aroma', '', 1, NULL, 'ff8081811cf90e28011cf91474600002', 'ff8081811cf90e28011cf9167a730004'),
  752. ('ff8081811cf90e28011cf91b237d0011', 1, '1', '2008-10-14 09:06:57', '1', '2008-10-14 09:06:57', 'Aroma', 'AromaUser', '', 1, NULL, NULL, '0'),
  753. ('ff8081811cf90e28011cf91c03e90012', 1, '1', '2008-10-14 09:07:54', '1', '2008-10-14 09:07:54', 'Survey Management', 'aroma', '', 1, NULL, 'ff8081811cf90e28011cf91474600002', 'ff8081811cf90e28011cf91b237d0011'),
  754. ('ff8081812da1ca99012da1cd11fd0002', 1, '1', '2011-01-20 12:02:07', '1', '2011-04-18 04:20:36', 'Admin', 'Admin', '', 1, NULL, NULL, '0'),
  755. ('ff8081812da1ca99012da1cd9cc70003', 1, '1', '2011-01-20 12:02:42', '1', '2011-04-18 04:41:56', 'Karyawan', 'ADMIN KARYAWAN', '', 1, NULL, 'ff8081812da1ca99012da1cca3fc0001', 'ff8081812da1ca99012da1cd11fd0002'),
  756. ('ff8081812da1ca99012da1d1f27f000d', 1, '1', '2011-01-20 12:07:26', '1', '2011-04-18 04:40:56', 'Jabatan', 'ADMIN JABATAN', '', 1, NULL, 'ff8081812da1ca99012da1d17080000c', 'ff8081812da1ca99012da1cd11fd0002'),
  757. ('ff8081812da1ca99012da1d2b673000f', 1, '1', '2011-01-20 12:08:17', '1', '2011-04-18 04:41:40', 'Jenis Cuti', 'ADMIN JENIS CUTI', '', 1, NULL, 'ff8081812da1ca99012da1d25879000e', 'ff8081812da1ca99012da1cd11fd0002'),
  758. ('ff8081812da1d39b012da1d55e1a0002', 1, '1', '2011-01-20 12:11:11', '1', '2011-04-18 04:21:26', 'Staff', 'Staff', '', 1, NULL, NULL, '0'),
  759. ('ff8081812da1d39b012da1d672770003', 1, '1', '2011-01-20 12:12:21', '1', '2011-04-18 04:42:30', 'Pengajuan Cuti', 'STAFF PENGAJUAN CUTI', '', 1, NULL, 'ff8081812da1d39b012da1d4c4ec0001', 'ff8081812da1d39b012da1d55e1a0002'),
  760. ('ff8081812dda15a2012dda1cedc20001', 1, '1', '2011-01-31 10:28:05', '1', '2011-04-18 04:20:59', 'Supervisor', 'Supervisor', '', 1, NULL, NULL, '0'),
  761. ('ff8081812dda15a2012dda1ee4610002', 1, '1', '2011-01-31 10:30:13', '1', '2011-04-18 04:43:26', 'Konfirmasi Pengajuan Cuti', 'SV KONFIRMASI PENGAJUAN CUTI', '', 1, NULL, 'ff8081812db746fb012db74881af0001', 'ff8081812dda15a2012dda1cedc20001'),
  762. ('ff8080812f655322012f655a26e50001', 1, '1', '2011-04-18 04:24:57', '1', '2011-04-18 04:26:56', 'pengajuan Cuti', 'SV PENGAJUAN CUTI', '', 1, NULL, 'ff8081812da1d39b012da1d4c4ec0001', 'ff8081812dda15a2012dda1cedc20001'),
  763. ('ff8080812f655322012f656040070002', 1, '1', '2011-04-18 04:31:37', '1', '2011-04-18 04:31:37', 'Manager', 'HRD MANAGER', '', 1, NULL, NULL, '0'),
  764. ('ff8080812f655322012f65618ea10003', 1, '1', '2011-04-18 04:33:03', '1', '2011-04-18 04:33:03', 'Konfirmasi Pengajuan Cuti', 'HRD KONFIRMASI', '', 1, NULL, 'ff8081812db746fb012db74881af0001', 'ff8080812f655322012f656040070002'),
  765. ('ff8080812f655322012f65626e400004', 1, '1', '2011-04-18 04:34:00', '1', '2011-04-18 04:34:00', 'Pengajuan Cuti', 'HRD PENGAJUAN', '', 1, NULL, 'ff8081812da1d39b012da1d4c4ec0001', 'ff8080812f655322012f656040070002'),
  766. ('402809da2f6dff62012f6e022c6b0002', 1, '1', '2011-04-19 20:45:26', '1', '2011-04-19 20:46:47', 'Cuti Bersama', 'Cuti BersamaHRD', '', 1, NULL, '402809da2f6dff62012f6e00b9ea0001', '0'),
  767. ('402882a22f76cc8a012f76d25aba0001', 1, '1', '2011-04-21 13:49:47', '1', '2011-04-21 13:49:47', 'Cuti Bersama', 'Cuti BersamaHRD', '', 1, NULL, '402809da2f6dff62012f6e00b9ea0001', 'ff8080812f655322012f656040070002'),
  768. ('ff8081812faeea77012faef245930002', 1, '1', '2011-05-02 11:23:23', '1', '2011-05-02 11:23:23', 'Kalender Cuti', 'KALENDER CUTIHRD', '', 1, NULL, 'ff8081812faeea77012faef180a00001', 'ff8080812f655322012f656040070002'),
  769. ('ff8081812fc33cac012fc3456efd0001', 1, '1', '2011-05-06 10:06:38', '1', '2011-05-06 10:06:38', 'Kalender Cuti', 'SV KALENDER CUTI', '', 1, NULL, 'ff8081812faeea77012faef180a00001', 'ff8081812dda15a2012dda1cedc20001'),
  770. ('ff8081812fc33cac012fc3465d3d0002', 1, '1', '2011-05-06 10:07:39', '1', '2011-05-06 10:07:39', 'Kalender Cuti', 'STAFF KALENDER CUTI', '', 1, NULL, 'ff8081812faeea77012faef180a00001', 'ff8081812da1d39b012da1d55e1a0002');
  771.  
  772. -- --------------------------------------------------------
  773.  
  774. --
  775. -- Table structure for table `role_descriptor_acl`
  776. --
  777.  
  778. CREATE TABLE IF NOT EXISTS `role_descriptor_acl` (
  779. `id` varchar(255) NOT NULL,
  780. `active_flag` int(11) DEFAULT NULL,
  781. `create_by` varchar(255) DEFAULT NULL,
  782. `create_date` datetime DEFAULT NULL,
  783. `update_by` varchar(255) DEFAULT NULL,
  784. `update_date` datetime DEFAULT NULL,
  785. `site_id` varchar(255) DEFAULT NULL,
  786. `descriptor_id` varchar(255) DEFAULT NULL,
  787. `role_id` varchar(255) DEFAULT NULL,
  788. PRIMARY KEY (`id`),
  789. KEY `FK54CF5EA3456510EF` (`role_id`),
  790. KEY `FK54CF5EA3F5B73B87` (`descriptor_id`),
  791. KEY `FK54CF5EA33CAE8F1E` (`site_id`)
  792. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  793.  
  794. --
  795. -- Dumping data for table `role_descriptor_acl`
  796. --
  797.  
  798. INSERT INTO `role_descriptor_acl` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `descriptor_id`, `role_id`) VALUES
  799. ('ff8081811ac417bb011ac4182e810001', 1, '1', '2008-06-26 15:58:16', '1', '2008-06-26 15:58:16', NULL, '31', 'ff8081811ac3700b011ac3716b270001'),
  800. ('ff8081811ac7b550011ac7bc10d20001', 1, '1', '2008-06-27 08:56:08', '1', '2008-06-27 08:56:08', NULL, '1', 'ff8081811ac3700b011ac3716b270001'),
  801. ('ff8081811ac8c506011ac8c598010001', 1, '1', '2008-06-27 13:46:10', '1', '2008-06-27 13:46:10', NULL, 'ff8081811ab34d3d011ab35046030001', '1');
  802.  
  803. -- --------------------------------------------------------
  804.  
  805. --
  806. -- Table structure for table `role_descriptor_acl_access`
  807. --
  808.  
  809. CREATE TABLE IF NOT EXISTS `role_descriptor_acl_access` (
  810. `id` varchar(255) NOT NULL,
  811. `active_flag` int(11) DEFAULT NULL,
  812. `create_by` varchar(255) DEFAULT NULL,
  813. `create_date` datetime DEFAULT NULL,
  814. `update_by` varchar(255) DEFAULT NULL,
  815. `update_date` datetime DEFAULT NULL,
  816. `site_id` varchar(255) DEFAULT NULL,
  817. `acl_id` varchar(255) DEFAULT NULL,
  818. `role_description_acl_id` varchar(255) DEFAULT NULL,
  819. PRIMARY KEY (`id`),
  820. KEY `FK93C22680EE7064B2` (`acl_id`),
  821. KEY `FK93C226803CAE8F1E` (`site_id`),
  822. KEY `FK93C22680921AFD6F` (`role_description_acl_id`)
  823. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  824.  
  825. --
  826. -- Dumping data for table `role_descriptor_acl_access`
  827. --
  828.  
  829. INSERT INTO `role_descriptor_acl_access` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `acl_id`, `role_description_acl_id`) VALUES
  830. ('ff8081811ac7b550011ac7bc11b40002', 1, '1', '2008-06-27 08:56:08', '1', '2008-06-27 08:56:08', NULL, 'ff80808115f0cf5a0115f0d3629b0005', 'ff8081811ac7b550011ac7bc10d20001'),
  831. ('ff8081811ac7b550011ac7bc618c0003', 1, '1', '2008-06-27 08:56:29', '1', '2008-06-27 08:56:29', NULL, 'ff80808115f0cf5a0115f0d2732b0003', 'ff8081811ac417bb011ac4182e810001'),
  832. ('ff8081811ac8d6cc011ac8d8b92c0001', 1, '1', '2008-06-27 14:07:03', '1', '2008-06-27 14:07:03', NULL, 'ff80808115f0cf5a0115f0d3125c0004', 'ff8081811ac8c506011ac8c598010001'),
  833. ('ff8081811ac8d6cc011ac8d9d8e50002', 1, '1', '2008-06-27 14:08:17', '1', '2008-06-27 14:08:17', NULL, 'ff80808115f0cf5a0115f0d2732b0003', 'ff8081811ac8c506011ac8c598010001');
  834.  
  835. -- --------------------------------------------------------
  836.  
  837. --
  838. -- Table structure for table `role_privilage`
  839. --
  840.  
  841. CREATE TABLE IF NOT EXISTS `role_privilage` (
  842. `id` varchar(255) NOT NULL,
  843. `active_flag` int(11) DEFAULT NULL,
  844. `create_by` varchar(255) DEFAULT NULL,
  845. `create_date` datetime DEFAULT NULL,
  846. `update_by` varchar(255) DEFAULT NULL,
  847. `update_date` datetime DEFAULT NULL,
  848. `privilage_flag` int(11) NOT NULL,
  849. `url_xml` varchar(255) DEFAULT NULL,
  850. `site_id` varchar(255) DEFAULT NULL,
  851. `module_function_id` varchar(255) DEFAULT NULL,
  852. `role_id` varchar(255) DEFAULT NULL,
  853. PRIMARY KEY (`id`),
  854. KEY `FK45FBC724FB81ACDA` (`module_function_id`),
  855. KEY `FK45FBC724456510EF` (`role_id`),
  856. KEY `FK45FBC7243CAE8F1E` (`site_id`)
  857. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  858.  
  859. --
  860. -- Dumping data for table `role_privilage`
  861. --
  862.  
  863. INSERT INTO `role_privilage` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `privilage_flag`, `url_xml`, `site_id`, `module_function_id`, `role_id`) VALUES
  864. ('402880f91d19d3fb011d19db35740006', 1, '1', '2008-10-20 17:44:35', '1', '2008-10-20 17:44:35', 1, NULL, NULL, '402880f91d19d3fb011d19d6ca590002', 'ff8081811ac3700b011ac3716b270001'),
  865. ('402880f91d19d3fb011d19dfcd5b000f', 1, '1', '2008-10-20 17:49:36', '1', '2008-10-20 17:49:36', 1, NULL, NULL, '402880f91d19d3fb011d19ddd832000b', 'ff8081811ac3700b011ac3716b270001'),
  866. ('ff80808105a521520105a52239c8', 1, '', '2008-03-17 18:12:34', '', '2008-03-17 18:12:34', 1, NULL, NULL, 'ff80808105a3b96f0105a3bdf32c', '1'),
  867. ('ff80808105a8de2e0105a8e066ce', 1, '', '2008-03-17 18:12:34', '', '2008-03-17 18:12:34', 1, NULL, NULL, 'ff80808105a3a8ed0105a3b185a9', '1'),
  868. ('ff808081151cf62001151d01a98b', 1, '', '2008-03-17 18:12:34', '', '2008-03-17 18:12:34', 1, NULL, NULL, 'ff808081151cf62001151cfd6d90', '2-gx'),
  869. ('ff8080811ddcf1f4011ddd0c61ba0001', 1, '1', '2008-11-27 15:24:15', '1', '2008-11-27 15:24:15', 1, NULL, NULL, 'ff808081151cf62001151cfd6d90', '1'),
  870. ('ff8080811ddcf1f4011ddd0e404e0002', 1, '1', '2008-11-27 15:26:18', '1', '2008-11-27 15:26:18', 1, NULL, NULL, '402880f91d19d3fb011d19d6ca590002', '1'),
  871. ('ff8080811ddd57e6011ddd705cc30001', 1, '1', '2008-11-27 17:13:27', '1', '2008-11-27 17:13:27', 1, NULL, NULL, 'ff808081151cf62001151cfd6d90', 'ff8081811ac3700b011ac3716b270001'),
  872. ('ff8081811ab34d3d011ab354d93d0004', 1, '1', '2008-06-23 09:50:59', '1', '2008-06-23 09:50:59', 1, NULL, NULL, 'ff8081811ab34d3d011ab353e2b00002', '1'),
  873. ('ff8081811cf90e28011cf9192a5c000b', 1, '1', '2008-10-14 09:04:48', '1', '2008-10-14 09:04:48', 1, NULL, NULL, 'ff8081811cf90e28011cf9167a730004', 'ff8081811cf90e28011cf918c4500009'),
  874. ('ff8081811cf90e28011cf91c554d0014', 1, '1', '2008-10-14 09:08:15', '1', '2008-10-14 09:08:15', 1, NULL, NULL, 'ff8081811cf90e28011cf91b237d0011', 'ff8081811cf90e28011cf91a75b90010'),
  875. ('ff8081812da1ca99012da1cf045e0007', 1, '1', '2011-01-20 12:04:14', '1', '2011-01-20 12:04:14', 1, NULL, NULL, 'ff8081812da1ca99012da1cd11fd0002', 'ff8081812da1ca99012da1ceb79c0005'),
  876. ('ff8081812da1d39b012da1d7aee90007', 1, '1', '2011-01-20 12:13:42', '1', '2011-01-20 12:13:42', 1, NULL, NULL, 'ff8081812da1d39b012da1d55e1a0002', 'ff8081812da1d39b012da1d73ddf0005'),
  877. ('ff8081812dda15a2012dda219ceb0006', 1, '1', '2011-01-31 10:33:12', '1', '2011-01-31 10:33:12', 1, NULL, NULL, 'ff8081812dda15a2012dda1cedc20001', 'ff8081812dda15a2012dda1f7c170004'),
  878. ('ff8080812f655322012f6563f3850008', 1, '1', '2011-04-18 04:35:39', '1', '2011-04-18 04:35:39', 1, NULL, NULL, 'ff8080812f655322012f656040070002', 'ff8080812f655322012f65634f3f0006');
  879.  
  880. -- --------------------------------------------------------
  881.  
  882. --
  883. -- Table structure for table `role_site`
  884. --
  885.  
  886. CREATE TABLE IF NOT EXISTS `role_site` (
  887. `id` varchar(255) NOT NULL,
  888. `active_flag` int(11) DEFAULT NULL,
  889. `create_by` varchar(255) DEFAULT NULL,
  890. `create_date` datetime DEFAULT NULL,
  891. `update_by` varchar(255) DEFAULT NULL,
  892. `update_date` datetime DEFAULT NULL,
  893. `site_id` varchar(255) DEFAULT NULL,
  894. `role_id` varchar(255) DEFAULT NULL,
  895. `rsite_id` varchar(255) DEFAULT NULL,
  896. PRIMARY KEY (`id`),
  897. KEY `FK1406F170456510EF` (`role_id`),
  898. KEY `FK1406F1707EF48A6C` (`rsite_id`),
  899. KEY `FK1406F1703CAE8F1E` (`site_id`)
  900. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  901.  
  902. --
  903. -- Dumping data for table `role_site`
  904. --
  905.  
  906. INSERT INTO `role_site` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `role_id`, `rsite_id`) VALUES
  907. ('402880f91d19d3fb011d19d7005d0003', 1, '1', '2008-10-20 17:40:00', '1', '2008-10-20 17:40:00', NULL, 'ff8081811ac3700b011ac3716b270001', '402880f91d19d3fb011d19d54cf10001'),
  908. ('e1802384-1353-49c3-9651-bab3', 1, NULL, '2007-09-19 16:02:51', NULL, '2008-03-17 18:15:44', 'EE185CE0B82B41C1724F284685', '2-gx', 'ff808081151cf62001151cfc0584'),
  909. ('ff808081168fbd0301168fc010a10001', 1, NULL, '2007-11-30 15:50:37', NULL, '2007-11-30 15:50:37', NULL, '1', 'EE185CE0B82B41C1724F284685'),
  910. ('ff8081811cf90e28011cf918fa7c000a', 1, '1', '2008-10-14 09:04:35', '1', '2008-10-14 09:04:35', NULL, 'ff8081811cf90e28011cf918c4500009', 'ff8081811cf90e28011cf91890070008'),
  911. ('ff8081811cf90e28011cf91c30c30013', 1, '1', '2008-10-14 09:08:06', '1', '2008-10-14 09:08:06', NULL, 'ff8081811cf90e28011cf91a75b90010', 'ff8081811cf90e28011cf91890070008'),
  912. ('ff8081812da1ca99012da1cee2760006', 1, '1', '2011-01-20 12:04:06', '1', '2011-01-20 12:04:06', NULL, 'ff8081812da1ca99012da1ceb79c0005', 'ff8081812da1ca99012da1ce3a710004'),
  913. ('ff8081812da1d39b012da1d775be0006', 1, '1', '2011-01-20 12:13:28', '1', '2011-01-20 12:13:28', NULL, 'ff8081812da1d39b012da1d73ddf0005', 'ff8081812da1d39b012da1d6da320004'),
  914. ('ff8081812dda15a2012dda21627c0005', 1, '1', '2011-01-31 10:32:57', '1', '2011-01-31 10:32:57', NULL, 'ff8081812dda15a2012dda1f7c170004', 'ff8081812dda15a2012dda1f3ddf0003'),
  915. ('ff8080812f6543b6012f654793990001', 1, '1', '2011-04-18 04:04:40', '1', '2011-04-18 04:04:40', NULL, 'ff8081812dda15a2012dda1f7c170004', 'ff8081812da1d39b012da1d6da320004'),
  916. ('ff8080812f655322012f6563c34f0007', 1, '1', '2011-04-18 04:35:27', '1', '2011-04-18 04:35:27', NULL, 'ff8080812f655322012f65634f3f0006', 'ff8080812f655322012f6562e0510005');
  917.  
  918. -- --------------------------------------------------------
  919.  
  920. --
  921. -- Table structure for table `role_site_privilage`
  922. --
  923.  
  924. CREATE TABLE IF NOT EXISTS `role_site_privilage` (
  925. `id` varchar(255) NOT NULL,
  926. `active_flag` int(11) DEFAULT NULL,
  927. `create_by` varchar(255) DEFAULT NULL,
  928. `create_date` datetime DEFAULT NULL,
  929. `update_by` varchar(255) DEFAULT NULL,
  930. `update_date` datetime DEFAULT NULL,
  931. `privilage_flag` int(11) NOT NULL,
  932. `url_xml` varchar(255) DEFAULT NULL,
  933. `site_id` varchar(255) DEFAULT NULL,
  934. `module_function_id` varchar(255) DEFAULT NULL,
  935. `role_site_id` varchar(255) DEFAULT NULL,
  936. `rs_site_id` varchar(255) DEFAULT NULL,
  937. PRIMARY KEY (`id`),
  938. KEY `FKFE17C79E2CB07320` (`rs_site_id`),
  939. KEY `FKFE17C79EFB81ACDA` (`module_function_id`),
  940. KEY `FKFE17C79E3CAE8F1E` (`site_id`),
  941. KEY `FKFE17C79E7124EB9C` (`role_site_id`)
  942. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  943.  
  944. --
  945. -- Dumping data for table `role_site_privilage`
  946. --
  947.  
  948. INSERT INTO `role_site_privilage` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `privilage_flag`, `url_xml`, `site_id`, `module_function_id`, `role_site_id`, `rs_site_id`) VALUES
  949. ('402880f91d19d3fb011d19db6e270007', 1, '1', '2008-10-20 17:44:50', '1', '2008-10-20 17:44:50', 0, NULL, NULL, '402880f91d19d3fb011d19d6ca590002', '402880f91d19d3fb011d19d7005d0003', '402880f91d19d3fb011d19d54cf10001'),
  950. ('402880f91d19d3fb011d19e016890010', 1, '1', '2008-10-20 17:49:55', '1', '2008-10-20 17:49:55', 0, NULL, NULL, '402880f91d19d3fb011d19ddd832000b', '402880f91d19d3fb011d19d7005d0003', '402880f91d19d3fb011d19d54cf10001'),
  951. ('ff808081168fbd0301168fc0453c0002', 1, NULL, '2007-11-30 15:50:50', NULL, '2007-11-30 15:50:50', 0, NULL, NULL, 'ff80808105a3a8ed0105a3b185a9', 'ff808081168fbd0301168fc010a10001', 'EE185CE0B82B41C1724F284685'),
  952. ('ff808081168fbd0301168fc07f770004', 1, NULL, '2007-11-30 15:51:05', NULL, '2007-11-30 15:51:05', 0, NULL, NULL, 'ff808081151cf62001151cfd6d90', 'ff808081168fbd0301168fc010a10001', 'EE185CE0B82B41C1724F284685'),
  953. ('ff8081811a6c481b011a6c50497a0001', 1, '1', '2008-06-09 14:52:58', '1', '2008-06-09 14:52:58', 0, NULL, NULL, 'ff80808105a3b96f0105a3bdf32c', 'ff808081168fbd0301168fc010a10001', 'EE185CE0B82B41C1724F284685'),
  954. ('ff8081811a75ff5a011a760184f30001', 1, '1', '2008-06-11 12:03:08', '1', '2008-06-11 12:03:08', 0, NULL, NULL, 'ff808081151cf62001151cfd6d90', 'e1802384-1353-49c3-9651-bab3', 'ff808081151cf62001151cfc0584'),
  955. ('ff8081811ab34d3d011ab35558910005', 1, '1', '2008-06-23 09:51:32', '1', '2008-06-23 09:51:32', 0, NULL, NULL, 'ff8081811ab34d3d011ab353e2b00002', 'ff808081168fbd0301168fc010a10001', 'EE185CE0B82B41C1724F284685'),
  956. ('ff8081811cf90e28011cf91951c8000c', 1, '1', '2008-10-14 09:04:58', '1', '2008-10-14 09:04:58', 0, NULL, NULL, 'ff8081811cf90e28011cf9167a730004', 'ff8081811cf90e28011cf918fa7c000a', 'ff8081811cf90e28011cf91890070008'),
  957. ('ff8081811cf90e28011cf91c786d0015', 1, '1', '2008-10-14 09:08:24', '1', '2008-10-14 09:08:24', 0, NULL, NULL, 'ff8081811cf90e28011cf91b237d0011', 'ff8081811cf90e28011cf91c30c30013', 'ff8081811cf90e28011cf91890070008'),
  958. ('ff8081812da1ca99012da1cf3fc50008', 1, '1', '2011-01-20 12:04:30', '1', '2011-01-20 12:04:30', 0, NULL, NULL, 'ff8081812da1ca99012da1cd11fd0002', 'ff8081812da1ca99012da1cee2760006', 'ff8081812da1ca99012da1ce3a710004'),
  959. ('ff8081812da1d39b012da1d7f0630008', 1, '1', '2011-01-20 12:13:59', '1', '2011-01-20 12:13:59', 0, NULL, NULL, 'ff8081812da1d39b012da1d55e1a0002', 'ff8081812da1d39b012da1d775be0006', 'ff8081812da1d39b012da1d6da320004'),
  960. ('ff8081812dda15a2012dda21d8100007', 1, '1', '2011-01-31 10:33:27', '1', '2011-01-31 10:33:27', 0, NULL, NULL, 'ff8081812dda15a2012dda1cedc20001', 'ff8081812dda15a2012dda21627c0005', 'ff8081812dda15a2012dda1f3ddf0003'),
  961. ('ff8080812f655322012f65642be10009', 1, '1', '2011-04-18 04:35:54', '1', '2011-04-18 04:35:54', 0, NULL, NULL, 'ff8080812f655322012f656040070002', 'ff8080812f655322012f6563c34f0007', 'ff8080812f655322012f6562e0510005');
  962.  
  963. -- --------------------------------------------------------
  964.  
  965. --
  966. -- Table structure for table `rs_descriptor_acl`
  967. --
  968.  
  969. CREATE TABLE IF NOT EXISTS `rs_descriptor_acl` (
  970. `id` varchar(255) NOT NULL,
  971. `active_flag` int(11) DEFAULT NULL,
  972. `create_by` varchar(255) DEFAULT NULL,
  973. `create_date` datetime DEFAULT NULL,
  974. `update_by` varchar(255) DEFAULT NULL,
  975. `update_date` datetime DEFAULT NULL,
  976. `site_id` varchar(255) DEFAULT NULL,
  977. `descriptor_id` varchar(255) DEFAULT NULL,
  978. `role_site_id` varchar(255) DEFAULT NULL,
  979. PRIMARY KEY (`id`),
  980. KEY `FKBDA42178F5B73B87` (`descriptor_id`),
  981. KEY `FKBDA421783CAE8F1E` (`site_id`),
  982. KEY `FKBDA421787124EB9C` (`role_site_id`)
  983. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  984.  
  985. --
  986. -- Dumping data for table `rs_descriptor_acl`
  987. --
  988.  
  989. INSERT INTO `rs_descriptor_acl` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `descriptor_id`, `role_site_id`) VALUES
  990. ('ff8081811aec24c8011aec2e33400001', 1, '1', '2008-07-04 10:47:08', '1', '2008-07-04 10:47:08', NULL, 'ff8081811ab34d3d011ab35046030001', 'e1802384-1353-49c3-9651-bab3'),
  991. ('ff8081811aec3132011aec63532c0001', 1, '1', '2008-07-04 11:45:09', '1', '2008-07-04 11:45:09', NULL, 'ff8081811ab34d3d011ab35046030001', 'ff808081168fbd0301168fc010a10001');
  992.  
  993. -- --------------------------------------------------------
  994.  
  995. --
  996. -- Table structure for table `rs_descriptor_acl_access`
  997. --
  998.  
  999. CREATE TABLE IF NOT EXISTS `rs_descriptor_acl_access` (
  1000. `id` varchar(255) NOT NULL,
  1001. `active_flag` int(11) DEFAULT NULL,
  1002. `create_by` varchar(255) DEFAULT NULL,
  1003. `create_date` datetime DEFAULT NULL,
  1004. `update_by` varchar(255) DEFAULT NULL,
  1005. `update_date` datetime DEFAULT NULL,
  1006. `site_id` varchar(255) DEFAULT NULL,
  1007. `acl_id` varchar(255) DEFAULT NULL,
  1008. `rs_descriptor_acl_id` varchar(255) DEFAULT NULL,
  1009. PRIMARY KEY (`id`),
  1010. KEY `FK66C97A0BD39099AE` (`rs_descriptor_acl_id`),
  1011. KEY `FK66C97A0BEE7064B2` (`acl_id`),
  1012. KEY `FK66C97A0B3CAE8F1E` (`site_id`)
  1013. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1014.  
  1015. --
  1016. -- Dumping data for table `rs_descriptor_acl_access`
  1017. --
  1018.  
  1019. INSERT INTO `rs_descriptor_acl_access` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `acl_id`, `rs_descriptor_acl_id`) VALUES
  1020. ('ff8081811aec3132011aec6353360002', 1, '1', '2008-07-04 11:45:09', '1', '2008-07-04 11:45:09', NULL, 'ff80808115f0cf5a0115f0d3125c0004', 'ff8081811aec3132011aec63532c0001');
  1021.  
  1022. -- --------------------------------------------------------
  1023.  
  1024. --
  1025. -- Table structure for table `section`
  1026. --
  1027.  
  1028. CREATE TABLE IF NOT EXISTS `section` (
  1029. `id` varchar(255) NOT NULL,
  1030. `active_flag` int(11) DEFAULT NULL,
  1031. `create_by` varchar(255) DEFAULT NULL,
  1032. `create_date` datetime DEFAULT NULL,
  1033. `update_by` varchar(255) DEFAULT NULL,
  1034. `update_date` datetime DEFAULT NULL,
  1035. `code` varchar(255) DEFAULT NULL,
  1036. `description` varchar(255) DEFAULT NULL,
  1037. `url_section` varchar(255) DEFAULT NULL,
  1038. `site_id` varchar(255) DEFAULT NULL,
  1039. `sectionDescriptor_id` varchar(255) DEFAULT NULL,
  1040. PRIMARY KEY (`id`),
  1041. KEY `FK756F7EE54149D8C2` (`sectionDescriptor_id`),
  1042. KEY `FK756F7EE53CAE8F1E` (`site_id`)
  1043. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1044.  
  1045. --
  1046. -- Dumping data for table `section`
  1047. --
  1048.  
  1049. INSERT INTO `section` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `code`, `description`, `url_section`, `site_id`, `sectionDescriptor_id`) VALUES
  1050. ('402881b709be21e60109be253122', 1, '1', '2006-03-03 10:27:21', '', '2008-03-17 18:29:22', 'dfd', 'asfafa ', 'ari.gif', NULL, NULL),
  1051. ('402881b709be21e60109be234262', 1, '1', '2006-03-03 10:25:15', '1', '2006-03-03 10:26:43', '582', ' sas ', '', NULL, NULL);
  1052.  
  1053. -- --------------------------------------------------------
  1054.  
  1055. --
  1056. -- Table structure for table `site`
  1057. --
  1058.  
  1059. CREATE TABLE IF NOT EXISTS `site` (
  1060. `id` varchar(255) NOT NULL,
  1061. `active_flag` int(11) DEFAULT NULL,
  1062. `create_by` varchar(255) DEFAULT NULL,
  1063. `create_date` datetime DEFAULT NULL,
  1064. `update_by` varchar(255) DEFAULT NULL,
  1065. `update_date` datetime DEFAULT NULL,
  1066. `admin_email` varchar(255) DEFAULT NULL,
  1067. `description` varchar(255) DEFAULT NULL,
  1068. `name` varchar(255) DEFAULT NULL,
  1069. `notify_email` varchar(255) DEFAULT NULL,
  1070. `notify_flag` int(11) NOT NULL,
  1071. `notify_from` varchar(255) DEFAULT NULL,
  1072. `notify_message` varchar(255) DEFAULT NULL,
  1073. `site_url` varchar(255) DEFAULT NULL,
  1074. `title` varchar(255) DEFAULT NULL,
  1075. `url_branding` varchar(255) DEFAULT NULL,
  1076. `workspace_type` varchar(255) DEFAULT NULL,
  1077. `site_id` varchar(255) DEFAULT NULL,
  1078. `secret_key` varchar(255) DEFAULT NULL,
  1079. `parentId` varchar(255) DEFAULT NULL,
  1080. PRIMARY KEY (`id`),
  1081. KEY `FK35DF473CAE8F1E` (`site_id`),
  1082. KEY `FK35DF4758EA950` (`parentId`)
  1083. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1084.  
  1085. --
  1086. -- Dumping data for table `site`
  1087. --
  1088.  
  1089. INSERT INTO `site` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `admin_email`, `description`, `name`, `notify_email`, `notify_flag`, `notify_from`, `notify_message`, `site_url`, `title`, `url_branding`, `workspace_type`, `site_id`, `secret_key`, `parentId`) VALUES
  1090. ('402880f91d19d3fb011d19d54cf10001', 1, '1', '2008-10-20 17:38:08', '1', '2008-10-20 17:38:08', '', 'test', 'test', '', 1, '', '', '', '', '', 'menu', NULL, NULL, NULL),
  1091. ('EE185CE0B82B41C1724F284685', 1, '1', '2002-07-05 09:48:26', '1', '2011-05-16 09:51:02', '', 'Cimande Backend Site', 'Cimande Backend', '', 1, '', '', '', '', '', 'tree', 'EE185CE0B82B41C1724F284685', '4105efb9-d1ea-49ef-9601-d1590b28e28c', NULL),
  1092. ('ff808081151cf62001151cfc0584', 1, '1', '2007-09-19 15:56:59', '1', '2007-09-19 15:56:59', '', 'GXAdmin Site', 'GXAdmin', '', 1, '', '', '', '', '', 'tree', NULL, NULL, NULL),
  1093. ('ff8081811cf90e28011cf91890070008', 1, '1', '2008-10-14 09:04:08', '1', '2008-10-14 09:04:08', '', 'Aroma Project', 'Aroma Project', '', 1, '', '', '', '', '', NULL, NULL, NULL, NULL),
  1094. ('f2f900fb1f3714e1011f3715f5c00002', 1, '1', '2009-02-02 20:03:19', '1', '2009-02-02 20:03:19', '', 'default', 'default', '', 1, '', '', '', '', '', 'tree', NULL, NULL, NULL),
  1095. ('ff8081812da1ca99012da1ce3a710004', 1, '1', '2011-01-20 12:03:23', '1', '2011-05-20 11:06:49', '', 'Valiant Admin', 'Valiant Adminsite', '', 1, '', '', '', '', '', 'tree', NULL, '6c5a5e17-73e1-4ba8-bb03-ea6d24ebbf83', NULL),
  1096. ('ff8081812da1d39b012da1d6da320004', 1, '1', '2011-01-20 12:12:48', '1', '2011-05-20 11:07:10', '', 'Valiant Staff', 'Valiant Staffsite', '', 1, '', '', '', '', '', 'tree', NULL, 'a2ff4c28-5e2d-411a-851f-45b3d844bc2a', NULL),
  1097. ('ff8081812dda15a2012dda1f3ddf0003', 1, '1', '2011-01-31 10:30:36', '1', '2011-05-20 11:07:26', '', 'Valiant Supervisor', 'Valiant Supervisorsite', '', 1, '', '', '', '', '', 'tree', NULL, '704f59c6-aa01-4989-9224-118a2c2b05c5', NULL),
  1098. ('ff8080812f655322012f6562e0510005', 1, '1', '2011-04-18 04:34:29', '1', '2011-05-12 16:48:51', '', 'Site HRD Manager', 'SITE HRD MANAGER', '', 1, '', '', '', '', '', 'tree', NULL, '171ddd4a-1ab8-441a-8fc0-af5ad6cef5bc', NULL);
  1099.  
  1100. -- --------------------------------------------------------
  1101.  
  1102. --
  1103. -- Table structure for table `site_descriptor_acl`
  1104. --
  1105.  
  1106. CREATE TABLE IF NOT EXISTS `site_descriptor_acl` (
  1107. `id` varchar(255) NOT NULL,
  1108. `active_flag` int(11) DEFAULT NULL,
  1109. `create_by` varchar(255) DEFAULT NULL,
  1110. `create_date` datetime DEFAULT NULL,
  1111. `update_by` varchar(255) DEFAULT NULL,
  1112. `update_date` datetime DEFAULT NULL,
  1113. `site_id` varchar(255) DEFAULT NULL,
  1114. `descriptor_id` varchar(255) DEFAULT NULL,
  1115. `site_acl_id` varchar(255) DEFAULT NULL,
  1116. PRIMARY KEY (`id`),
  1117. KEY `FKC5D63B24BD37AF3` (`site_acl_id`),
  1118. KEY `FKC5D63B2F5B73B87` (`descriptor_id`),
  1119. KEY `FKC5D63B23CAE8F1E` (`site_id`)
  1120. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1121.  
  1122. --
  1123. -- Dumping data for table `site_descriptor_acl`
  1124. --
  1125.  
  1126.  
  1127. -- --------------------------------------------------------
  1128.  
  1129. --
  1130. -- Table structure for table `site_descriptor_acl_access`
  1131. --
  1132.  
  1133. CREATE TABLE IF NOT EXISTS `site_descriptor_acl_access` (
  1134. `id` varchar(255) NOT NULL,
  1135. `active_flag` int(11) DEFAULT NULL,
  1136. `create_by` varchar(255) DEFAULT NULL,
  1137. `create_date` datetime DEFAULT NULL,
  1138. `update_by` varchar(255) DEFAULT NULL,
  1139. `update_date` datetime DEFAULT NULL,
  1140. `site_id` varchar(255) DEFAULT NULL,
  1141. `acl_id` varchar(255) DEFAULT NULL,
  1142. `site_descriptor_acl_id` varchar(255) DEFAULT NULL,
  1143. PRIMARY KEY (`id`),
  1144. KEY `FK5C862291EE7064B2` (`acl_id`),
  1145. KEY `FK5C8622913CAE8F1E` (`site_id`),
  1146. KEY `FK5C86229192F8820A` (`site_descriptor_acl_id`)
  1147. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1148.  
  1149. --
  1150. -- Dumping data for table `site_descriptor_acl_access`
  1151. --
  1152.  
  1153.  
  1154. -- --------------------------------------------------------
  1155.  
  1156. --
  1157. -- Table structure for table `user_role`
  1158. --
  1159.  
  1160. CREATE TABLE IF NOT EXISTS `user_role` (
  1161. `id` varchar(255) NOT NULL,
  1162. `active_flag` int(11) DEFAULT NULL,
  1163. `create_by` varchar(255) DEFAULT NULL,
  1164. `create_date` datetime DEFAULT NULL,
  1165. `update_by` varchar(255) DEFAULT NULL,
  1166. `update_date` datetime DEFAULT NULL,
  1167. `site_id` varchar(255) DEFAULT NULL,
  1168. `role_id` varchar(255) DEFAULT NULL,
  1169. `user_id` varchar(255) DEFAULT NULL,
  1170. PRIMARY KEY (`id`),
  1171. KEY `FK143BF46A456510EF` (`role_id`),
  1172. KEY `FK143BF46A519415C5` (`user_id`),
  1173. KEY `FK143BF46A3CAE8F1E` (`site_id`)
  1174. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1175.  
  1176. --
  1177. -- Dumping data for table `user_role`
  1178. --
  1179.  
  1180. INSERT INTO `user_role` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `role_id`, `user_id`) VALUES
  1181. ('402880f91d19d3fb011d19dc18810009', 1, '1', '2008-10-20 17:45:33', '1', '2008-10-20 17:45:33', NULL, 'ff8081811ac3700b011ac3716b270001', '402880f91d19d3fb011d19dc022a0008'),
  1182. ('adaa9b6c-4f3a-489e-836a-179a', 1, '1', '2007-09-19 16:04:47', NULL, '2008-03-17 18:28:12', NULL, '2-gx', '96f673bc-283e-4b75-b63d-6edc'),
  1183. ('ff808081163dbc9001163dbd54820001', 0, '1', '1970-01-01 07:00:00', NULL, '2007-11-30 13:06:50', NULL, '1', '1'),
  1184. ('ff8080811ddcf1f4011ddd0f39f00004', 1, '1', '2008-11-27 15:27:21', '1', '2008-11-27 15:27:21', NULL, 'ff8081811ac3700b011ac3716b270001', 'ff8080811ddcf1f4011ddd0f17160003'),
  1185. ('ff8081811adcba6b011addef1b1f000a', 1, '1', '2008-07-01 16:23:32', '1', '2008-07-01 16:23:32', NULL, 'ff8081811adcba6b011addebe3190002', 'ff8081811adcba6b011addef08ad0009'),
  1186. ('ff8081811cf90e28011cf919b584000e', 1, '1', '2008-10-14 09:05:23', '1', '2008-10-14 09:05:23', NULL, 'ff8081811cf90e28011cf918c4500009', 'ff8081811cf90e28011cf919a3ff000d'),
  1187. ('ff8081811cf90e28011cf91ccf060017', 1, '1', '2008-10-14 09:08:46', '1', '2008-10-14 09:08:46', NULL, 'ff8081811cf90e28011cf91a75b90010', 'ff8081811cf90e28011cf91cc1e40016'),
  1188. ('402880f91ee3708f011ee377482a0005', 1, '1', '2009-01-17 14:21:31', '1', '2009-01-17 14:21:31', NULL, 'ff8081811ac3700b011ac3716b270001', '402880f91ee3708f011ee3712fdc0001'),
  1189. ('402880f91ee544c1011ee54ddac70002', 1, '402880f91ee544c1011ee54dda980001', '2009-01-17 22:55:31', '402880f91ee544c1011ee54dda980001', '2009-01-17 22:55:31', NULL, NULL, '402880f91ee544c1011ee54dda980001'),
  1190. ('402880f91ee56206011ee563c9e30002', 1, '402880f91ee56206011ee563c9b50001', '2009-01-17 23:19:28', '402880f91ee56206011ee563c9b50001', '2009-01-17 23:19:28', NULL, NULL, '402880f91ee56206011ee563c9b50001'),
  1191. ('f2f900fb1f36e1d3011f36f05ef20002', 1, 'f2f900fb1f36e1d3011f36f05e940001', '2009-02-02 19:22:16', 'f2f900fb1f36e1d3011f36f05e940001', '2009-02-02 19:22:16', NULL, NULL, 'f2f900fb1f36e1d3011f36f05e940001'),
  1192. ('f2f900fb1f3718ba011f371b5de70002', 1, 'f2f900fb1f3718ba011f371b5dd80001', '2009-02-02 20:09:14', 'f2f900fb1f3718ba011f371b5dd80001', '2009-02-02 20:09:14', NULL, 'f2f900fb1f3714e1011f3715b0f60001', 'f2f900fb1f3718ba011f371b5dd80001'),
  1193. ('ff8081812da1ca99012da1d022e3000a', 1, '1', '2011-01-20 12:05:28', '1', '2011-01-20 12:05:28', NULL, 'ff8081812da1ca99012da1ceb79c0005', 'ff8081812da1ca99012da1d013bb0009');
  1194.  
  1195. -- --------------------------------------------------------
  1196.  
  1197. --
  1198. -- Table structure for table `user_site`
  1199. --
  1200.  
  1201. CREATE TABLE IF NOT EXISTS `user_site` (
  1202. `id` varchar(255) NOT NULL,
  1203. `active_flag` int(11) DEFAULT NULL,
  1204. `create_by` varchar(255) DEFAULT NULL,
  1205. `create_date` datetime DEFAULT NULL,
  1206. `update_by` varchar(255) DEFAULT NULL,
  1207. `update_date` datetime DEFAULT NULL,
  1208. `site_id` varchar(255) DEFAULT NULL,
  1209. `user_site_id` varchar(255) DEFAULT NULL,
  1210. `user_id` varchar(255) DEFAULT NULL,
  1211. PRIMARY KEY (`id`),
  1212. KEY `FK143C533B519415C5` (`user_id`),
  1213. KEY `FK143C533B3CAE8F1E` (`site_id`),
  1214. KEY `FK143C533B979E26AA` (`user_site_id`)
  1215. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1216.  
  1217. --
  1218. -- Dumping data for table `user_site`
  1219. --
  1220.  
  1221. INSERT INTO `user_site` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `site_id`, `user_site_id`, `user_id`) VALUES
  1222. ('2e660f2f-499b-4eb3-b05c-5699', 1, '1', '2007-09-19 16:04:47', NULL, '2008-03-17 18:24:53', 'EE185CE0B82B41C1724F284685', 'ff808081151cf62001151cfc0584', '96f673bc-283e-4b75-b63d-6edc'),
  1223. ('402880f91d19d3fb011d19dc3446000a', 1, '1', '2008-10-20 17:45:41', '1', '2008-10-20 17:45:41', NULL, '402880f91d19d3fb011d19d54cf10001', '402880f91d19d3fb011d19dc022a0008'),
  1224. ('eeb', 1, '1', '2003-09-27 10:27:35', NULL, '2008-03-17 18:24:53', 'EE185CE0B82B41C1724F284685', 'EE185CE0B82B41C1724F284685', '1'),
  1225. ('ff8080811ddcf1f4011ddd0f5ff70005', 1, '1', '2008-11-27 15:27:31', '1', '2008-11-27 15:27:31', NULL, '402880f91d19d3fb011d19d54cf10001', 'ff8080811ddcf1f4011ddd0f17160003'),
  1226. ('ff8081811adcba6b011addef3887000b', 1, '1', '2008-07-01 16:23:39', '1', '2008-07-01 16:23:39', NULL, 'ff8081811adcba6b011addebaa220001', 'ff8081811adcba6b011addef08ad0009'),
  1227. ('ff8081811cf90e28011cf919c640000f', 1, '1', '2008-10-14 09:05:27', '1', '2008-10-14 09:05:27', NULL, 'ff8081811cf90e28011cf91890070008', 'ff8081811cf90e28011cf919a3ff000d'),
  1228. ('ff8081811cf90e28011cf91cefac0018', 1, '1', '2008-10-14 09:08:55', '1', '2008-10-14 09:08:55', NULL, 'ff8081811cf90e28011cf91890070008', 'ff8081811cf90e28011cf91cc1e40016'),
  1229. ('f2f900fb1f36e1d3011f36f05f400003', 1, 'f2f900fb1f36e1d3011f36f05e940001', '2009-02-02 19:22:16', 'f2f900fb1f36e1d3011f36f05e940001', '2009-02-02 19:22:16', NULL, NULL, 'f2f900fb1f36e1d3011f36f05e940001'),
  1230. ('402880f91ee3708f011ee375e9170004', 1, '1', '2009-01-17 14:20:02', '1', '2009-01-17 14:20:02', NULL, '402880f91d19d3fb011d19d54cf10001', '402880f91ee3708f011ee3712fdc0001'),
  1231. ('f2f900fb1f3718ba011f371b5df70003', 1, 'f2f900fb1f3718ba011f371b5dd80001', '2009-02-02 20:09:14', 'f2f900fb1f3718ba011f371b5dd80001', '2009-02-02 20:09:14', NULL, 'f2f900fb1f3714e1011f3715f5c00002', 'f2f900fb1f3718ba011f371b5dd80001'),
  1232. ('ff8081812da1ca99012da1d06bff000b', 1, '1', '2011-01-20 12:05:47', '1', '2011-01-20 12:05:47', NULL, 'ff8081812da1ca99012da1ce3a710004', 'ff8081812da1ca99012da1d013bb0009');
  1233.  
  1234. -- --------------------------------------------------------
  1235.  
  1236. --
  1237. -- Table structure for table `valiant_jenis_cuti`
  1238. --
  1239.  
  1240. CREATE TABLE IF NOT EXISTS `valiant_jenis_cuti` (
  1241. `id` varchar(255) NOT NULL,
  1242. `active_flag` int(11) DEFAULT NULL,
  1243. `create_by` varchar(255) DEFAULT NULL,
  1244. `create_date` datetime DEFAULT NULL,
  1245. `update_by` varchar(255) DEFAULT NULL,
  1246. `update_date` datetime DEFAULT NULL,
  1247. `description` varchar(255) DEFAULT NULL,
  1248. `name` varchar(255) DEFAULT NULL,
  1249. `site_id` varchar(255) DEFAULT NULL,
  1250. PRIMARY KEY (`id`),
  1251. KEY `FKC31603293CAE8F1E` (`site_id`)
  1252. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1253.  
  1254. --
  1255. -- Dumping data for table `valiant_jenis_cuti`
  1256. --
  1257.  
  1258. INSERT INTO `valiant_jenis_cuti` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `name`, `site_id`) VALUES
  1259. ('ff8081812e0d7b10012e0e269a9f0002', 1, '1', '2011-02-10 12:58:54', 'ff8081812da1ca99012da1d013bb0009', '2011-05-02 21:50:17', 'Bersama', 'Tahun Baru', NULL),
  1260. ('ff8081812e0d7b10012e0e26d67b0003', 1, '1', '2011-02-10 12:59:09', 'ff8081812da1ca99012da1d013bb0009', '2011-05-02 16:48:58', 'Bersama', 'Idul Fitri', NULL),
  1261. ('ff8081812e0d7b10012e0e2707570004', 1, '1', '2011-02-10 12:59:22', '1', '2011-02-10 12:59:22', 'Bersama', 'Idul Adha', NULL),
  1262. ('ff8081812e0d7b10012e0e5e4898000a', 1, '1', '2011-02-10 13:59:43', '1', '2011-02-10 13:59:43', 'Agama Kristen dan katholik', 'Natal', NULL),
  1263. ('ff8080812f3fde41012f3fe383d70003', 1, '1', '2011-04-10 21:49:25', 'ff8081812da1ca99012da1d013bb0009', '2011-04-10 21:49:42', 'setelah dinas lebih dari 7 hari', 'Cuti dari perjalanan Dinas sip', NULL),
  1264. ('4028818a2f4295ab012f429768e30001', 0, '1', '2011-04-11 10:25:09', 'ff8081812da1ca99012da1d013bb0009', '2011-04-15 11:42:35', 'Khusus Ibu hamil', 'Hamil', NULL),
  1265. ('ff8081812fa18dc9012fa20f52a10003', 1, '1', '2011-04-29 23:20:03', '1', '2011-04-29 23:20:03', 'karena berbarengan', 'Cuti Bersama', NULL),
  1266. ('ff8081812fc5b63e012fc5e599b20001', 1, '1', '2011-05-06 22:20:49', '1', '2011-05-06 22:20:49', 'Sip', 'Cuti Sekolah', NULL);
  1267.  
  1268. -- --------------------------------------------------------
  1269.  
  1270. --
  1271. -- Table structure for table `valiant_pengajuan_cuti`
  1272. --
  1273.  
  1274. CREATE TABLE IF NOT EXISTS `valiant_pengajuan_cuti` (
  1275. `id` varchar(255) NOT NULL,
  1276. `active_flag` int(11) DEFAULT NULL,
  1277. `create_by` varchar(255) DEFAULT NULL,
  1278. `create_date` datetime DEFAULT NULL,
  1279. `update_by` varchar(255) DEFAULT NULL,
  1280. `update_date` datetime DEFAULT NULL,
  1281. `alasan` varchar(255) DEFAULT NULL,
  1282. `catatan` varchar(255) DEFAULT NULL,
  1283. `dikonfirmasi` varchar(255) DEFAULT NULL,
  1284. `lama_cuti` int(11) NOT NULL,
  1285. `tahun` varchar(255) DEFAULT NULL,
  1286. `tgl_bekerja` datetime DEFAULT NULL,
  1287. `tgl_berakhir` datetime DEFAULT NULL,
  1288. `tgl_mulai` datetime DEFAULT NULL,
  1289. `tgl_pengajuan` datetime DEFAULT NULL,
  1290. `tgl_persetujuan` datetime DEFAULT NULL,
  1291. `site_id` varchar(255) DEFAULT NULL,
  1292. `jenisCuti_id` varchar(255) DEFAULT NULL,
  1293. `user_id` varchar(255) DEFAULT NULL,
  1294. `konfirmasiSV` varchar(255) DEFAULT NULL,
  1295. `lama_cuti_kerja` int(11) DEFAULT NULL,
  1296. PRIMARY KEY (`id`),
  1297. KEY `FKE90BB9FB519415C5` (`user_id`)
  1298. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  1299.  
  1300. --
  1301. -- Dumping data for table `valiant_pengajuan_cuti`
  1302. --
  1303.  
  1304.  
  1305. -- --------------------------------------------------------
  1306.  
  1307. --
  1308. -- Table structure for table `workflow_role`
  1309. --
  1310.  
  1311. CREATE TABLE IF NOT EXISTS `workflow_role` (
  1312. `id` varchar(255) NOT NULL,
  1313. `active_flag` int(11) DEFAULT NULL,
  1314. `create_by` varchar(255) DEFAULT NULL,
  1315. `create_date` datetime DEFAULT NULL,
  1316. `update_by` varchar(255) DEFAULT NULL,
  1317. `update_date` datetime DEFAULT NULL,
  1318. `description` varchar(255) DEFAULT NULL,
  1319. `name` varchar(255) DEFAULT NULL,
  1320. `workspace_type` varchar(255) DEFAULT NULL,
  1321. `site_id` varchar(255) DEFAULT NULL,
  1322. `parentId` varchar(255) DEFAULT NULL,
  1323. PRIMARY KEY (`id`),
  1324. KEY `FK441060F63CAE8F1E` (`site_id`),
  1325. KEY `FK441060F6395F0EB0` (`parentId`)
  1326. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  1327.  
  1328. --
  1329. -- Dumping data for table `workflow_role`
  1330. --
  1331.  
  1332. INSERT INTO `workflow_role` (`id`, `active_flag`, `create_by`, `create_date`, `update_by`, `update_date`, `description`, `name`, `workspace_type`, `site_id`, `parentId`) VALUES
  1333. ('1', 0, '', '2003-09-03 15:40:41', '1', '2007-12-05 18:59:11', 'Gods', 'Gods', 'tree', 'EE185CE0B82B41C1724F284685', NULL),
  1334. ('2-gx', 0, '1', '2007-09-19 15:57:20', '1', '2007-09-19 15:57:20', 'GXAdmin Role', 'GXAdmin', 'tree', NULL, NULL),
  1335. ('ff8081811ac3700b011ac3716b270001', 0, '1', '2008-06-26 12:56:07', '1', '2008-11-10 19:32:25', 'test', 'test', 'tree', NULL, NULL),
  1336. ('ff8081811cf90e28011cf918c4500009', 0, '1', '2008-10-14 09:04:21', '1', '2008-10-14 09:04:21', 'Admin Aroma', 'admin_aroma', NULL, NULL, NULL),
  1337. ('ff8081811cf90e28011cf91a75b90010', 0, '1', '2008-10-14 09:06:12', '1', '2008-10-25 22:15:56', 'User Aroma', 'User Aroma', 'tree', NULL, NULL),
  1338. ('f2f900fb1f3714e1011f3715b0f60001', 0, '1', '2009-02-02 20:03:02', '1', '2009-02-02 20:03:02', 'default', 'default', 'tree', NULL, NULL),
  1339. ('ff8081812da1ca99012da1ceb79c0005', 1, '1', '2011-01-20 12:03:55', '1', '2011-04-18 04:47:13', 'Admin', 'Admin', 'tree', NULL, NULL),
  1340. ('ff8081812da1d39b012da1d73ddf0005', 1, '2', '2011-01-20 12:13:13', '1', '2011-04-18 04:47:02', 'Staff', 'Staff', 'tree', NULL, NULL),
  1341. ('ff8081812dda15a2012dda1f7c170004', 1, '3', '2011-01-31 10:30:52', '1', '2011-04-18 04:46:35', 'Supervisor', 'Supervisor', 'tree', NULL, NULL),
  1342. ('ff8080812f655322012f65634f3f0006', 1, '4', '2011-04-18 04:34:57', '1', '2011-04-18 04:46:18', 'Manager', 'Manager', 'tree', NULL, NULL);
  1343.  
  1344. --
  1345. -- Constraints for dumped tables
  1346. --
  1347.  
  1348. --
  1349. -- Constraints for table `backend_user`
  1350. --
  1351. ALTER TABLE `backend_user`
  1352. ADD CONSTRAINT `FK34849A96519415C5` FOREIGN KEY (`user_id`) REFERENCES `backend_user` (`id`),
  1353. ADD CONSTRAINT `FK34849A96EF11CEA3` FOREIGN KEY (`manager_id`) REFERENCES `backend_user` (`id`);
  1354.  
  1355. --
  1356. -- Constraints for table `valiant_pengajuan_cuti`
  1357. --
  1358. ALTER TABLE `valiant_pengajuan_cuti`
  1359. ADD CONSTRAINT `FKE90BB9FB519415C5` FOREIGN KEY (`user_id`) REFERENCES `backend_user` (`id`);
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!