API tools faq
paste
Guest User

Untitled

a guest
May 24th, 2010
419
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 64.16 KB | None | 0 0
raw download clone embed print report
  1. Checkinstall:
  2. [code]phpVMS Virtual Airline Administration Software
  3. Install Check
  4.  
  5. phpVMS Build Number: 934
  6.  
  7. Checking PHP version
  8. [OK] PHP version is 5.2.4-2ubuntu5.7.x
  9.  
  10. ASP Tags
  11. [OK] ASP-style tags are disabled
  12.  
  13. Checking connectivity...
  14. [OK] Can contact outside servers
  15.  
  16. Checking for SimpleXML module...
  17. [OK] SimpleXML module exists!
  18.  
  19. Checking file hashes for corrupt or mismatched files
  20. [OK] No errors found!
  21.  
  22. -- Checked 183 files, found 0 errors[/code]
  23.  
  24.  
  25. Checkdb:
  26.  
  27. [code]phpVMS Virtual Airline Administration Software
  28. Database Check
  29.  
  30. Checking phpvms_acarsdata...OK
  31. Checking phpvms_adminlog...OK
  32. Checking phpvms_aircraft...OK
  33. Checking phpvms_airlines...OK
  34. Checking phpvms_airports...OK
  35. Checking phpvms_awards...OK
  36. Checking phpvms_awardsgranted...OK
  37. Checking phpvms_bids...OK
  38. Checking phpvms_customfields...OK
  39. Checking phpvms_downloads...OK
  40. Checking phpvms_expenselog...OK
  41. Checking phpvms_expenses...OK
  42. Checking phpvms_fieldvalues...OK
  43. Checking phpvms_financedata...OK
  44. Checking phpvms_fuelprices...OK
  45. Checking phpvms_groupmembers...OK
  46. Checking phpvms_groups...OK
  47. Checking phpvms_navdata...OK
  48. Checking phpvms_news...OK
  49. Checking phpvms_pages...OK
  50. Checking phpvms_pilots...OK
  51. Checking phpvms_pirepcomments...OK
  52. Checking phpvms_pirepfields...OK
  53. Checking phpvms_pireps...OK
  54. Checking phpvms_pirepvalues...OK
  55. Checking phpvms_ranks...OK
  56. Checking phpvms_schedules...OK
  57. Checking phpvms_sessions...OK
  58. Checking phpvms_settings...OK
  59. Checking phpvms_updates...OK[/code]
  60.  
  61. here's the whole database content with the fspassengers tables:
  62.  
  63. [code]INSERT INTO `phpvms_adminlog` (`id`, `pilotid`, `datestamp`, `message`) VALUES
  64. (1, 1001, '2010-05-19 23:35:21', 'Recalculated ranks'),
  65. (2, 1001, '2010-05-19 23:35:26', 'Edited the airport "limc - airport Milan Malpensa"'),
  66. (3, 1001, '2010-05-19 23:36:03', 'Edited the airport "limc - airport Milan Malpensa"'),
  67. (4, 1001, '2010-05-19 23:37:04', 'Edited the rank "ATPL"'),
  68. (5, 1001, '2010-05-19 23:49:16', 'Updated profile for CIV0001 Thomas Zaniboni'),
  69. (6, 1001, '2010-05-19 23:49:19', 'Updated profile for CIV0001 Thomas Zaniboni'),
  70. (7, 1001, '2010-05-19 23:49:48', 'Updated profile for CIV0001 Thomas Zaniboni'),
  71. (8, 1001, '2010-05-19 23:49:50', 'Updated profile for CIV0001 Thomas Zaniboni'),
  72. (9, 1001, '2010-05-19 23:49:59', 'Updated profile for CIV0001 Thomas Zaniboni'),
  73. (10, 1001, '2010-05-19 23:50:01', 'Updated profile for CIV0001 Thomas Zaniboni'),
  74. (11, 1001, '2010-05-19 23:51:29', 'Edited the airport "LIMC - airport Milan Malpensa"'),
  75. (12, 1001, '2010-05-20 00:12:19', 'Edited the rank "ATPL"'),
  76. (13, 1001, '2010-05-20 00:15:34', 'Edited the rank "ATPL"'),
  77. (14, 1001, '2010-05-20 00:18:00', 'Edited the rank "ATPL"'),
  78. (15, 1001, '2010-05-20 00:18:33', 'Edited the rank "ATPL"'),
  79. (16, 1001, '2010-05-20 00:20:43', 'Added the rank "2nd Officer"'),
  80. (17, 1001, '2010-05-20 00:21:18', 'Edited the rank "2nd Officer"'),
  81. (18, 1001, '2010-05-20 00:22:48', 'Added the rank "1st Officer"'),
  82. (19, 1001, '2010-05-20 00:23:05', 'Edited the rank "1st Officer"'),
  83. (20, 1001, '2010-05-20 00:24:16', 'Added the rank "Captain"'),
  84. (21, 1001, '2010-05-20 00:24:29', 'Edited the rank "Captain"'),
  85. (22, 1001, '2010-05-20 00:25:25', 'Added the rank "Senior Captain"'),
  86. (23, 1001, '2010-05-20 00:25:39', 'Edited the rank "Senior Captain"'),
  87. (24, 1001, '2010-05-20 00:26:08', 'Edited the rank "1st Officer"'),
  88. (25, 1001, '2010-05-20 00:26:45', 'Edited the rank "2nd Officer"'),
  89. (26, 1001, '2010-05-20 00:26:52', 'Edited the rank "ATPL"'),
  90. (27, 1001, '2010-05-20 00:30:57', 'Recalculated ranks'),
  91. (28, 1001, '2010-05-20 00:32:31', 'Updated profile for CIV0001 Thomas Zaniboni'),
  92. (29, 1001, '2010-05-20 00:34:20', 'Added the airport "limc - airport Milan Malpensa"'),
  93. (30, 1001, '2010-05-20 00:35:43', 'Approved CIV0002 - Mario Chahine'),
  94. (31, 1001, '2010-05-20 00:44:59', 'Edited group "Active Pilots"'),
  95. (32, 1001, '2010-05-20 00:45:52', 'Approved CIV0003 - Davide Consiglio'),
  96. (33, 1001, '2010-05-20 00:57:50', 'Updated profile for CIV0001 Thomas Zaniboni'),
  97. (34, 1001, '2010-05-20 00:57:58', 'Updated profile for CIV0001 Thomas Zaniboni'),
  98. (35, 1001, '2010-05-20 00:57:58', 'Updated profile for CIV0001 Thomas Zaniboni'),
  99. (36, 1001, '2010-05-20 00:57:58', 'Updated profile for CIV0001 Thomas Zaniboni'),
  100. (37, 1001, '2010-05-20 00:57:59', 'Updated profile for CIV0001 Thomas Zaniboni'),
  101. (38, 1001, '2010-05-20 00:57:59', 'Updated profile for CIV0001 Thomas Zaniboni'),
  102. (39, 1001, '2010-05-20 01:12:28', 'Added the aircraft "MD-11F - EI-UPI"'),
  103. (40, 1001, '2010-05-20 14:05:36', 'Added pilot #1002 to group "Administrators"'),
  104. (41, 1001, '2010-05-20 14:12:31', 'Added page "Disclaimer"'),
  105. (42, 1001, '2010-05-20 14:14:23', 'Page Disclaimer edited'),
  106. (43, 1001, '2010-05-20 14:14:26', 'Page Disclaimer edited'),
  107. (44, 1001, '2010-05-20 14:14:56', 'Page Disclaimer edited'),
  108. (45, 1001, '2010-05-20 14:15:17', 'Added page "disclaimer"'),
  109. (46, 1001, '2010-05-20 14:16:22', 'Page disclaimer edited'),
  110. (47, 1001, '2010-05-20 14:17:43', 'Added page "Flight Ops"'),
  111. (48, 1001, '2010-05-20 14:21:30', 'Edited page ""'),
  112. (49, 1001, '2010-05-20 14:27:16', 'Page disclaimer edited'),
  113. (50, 1001, '2010-05-20 14:28:20', 'Page disclaimer edited'),
  114. (51, 1001, '2010-05-20 14:28:23', 'Page disclaimer edited'),
  115. (52, 1001, '2010-05-20 14:29:45', 'Edited page ""'),
  116. (53, 1001, '2010-05-20 14:30:03', 'Page disclaimer edited'),
  117. (54, 1001, '2010-05-20 14:30:16', 'Edited page ""'),
  118. (55, 1001, '2010-05-20 14:30:22', 'Page disclaimer edited'),
  119. (56, 1001, '2010-05-20 14:31:27', 'Page disclaimer edited'),
  120. (57, 1001, '2010-05-20 14:32:20', 'Page disclaimer edited'),
  121. (58, 1001, '2010-05-20 14:36:02', 'Edited page ""'),
  122. (59, 1001, '2010-05-20 14:36:36', 'Page disclaimer edited'),
  123. (60, 1001, '2010-05-20 14:37:05', 'Edited page ""'),
  124. (61, 1001, '2010-05-20 14:37:38', 'Page disclaimer edited'),
  125. (62, 1001, '2010-05-20 14:38:57', 'Edited page ""'),
  126. (63, 1001, '2010-05-20 14:39:14', 'Page disclaimer edited'),
  127. (64, 1001, '2010-05-20 14:57:10', 'Added page "Rules"'),
  128. (65, 1001, '2010-05-20 14:58:13', 'Page disclaimer edited'),
  129. (66, 1001, '2010-05-20 14:59:27', 'Added page "Disclaimer"'),
  130. (67, 1001, '2010-05-20 15:00:12', 'Page Rules edited'),
  131. (68, 1001, '2010-05-20 15:00:36', 'Page Disclaimer edited'),
  132. (69, 1001, '2010-05-20 15:01:03', 'Edited page ""'),
  133. (70, 1001, '2010-05-20 15:01:37', 'Page Disclaimer edited'),
  134. (71, 1001, '2010-05-20 15:02:05', 'Edited page ""'),
  135. (72, 1001, '2010-05-20 15:13:24', 'Added page "Staff"'),
  136. (73, 1001, '2010-05-20 15:14:20', 'Page Staff edited'),
  137. (74, 1001, '2010-05-20 15:15:28', 'Edited page ""'),
  138. (75, 1001, '2010-05-20 15:15:56', 'Page Rules edited'),
  139. (76, 1001, '2010-05-20 15:16:04', 'Edited page ""'),
  140. (77, 1001, '2010-05-20 15:16:06', 'Page Disclaimer edited'),
  141. (78, 1001, '2010-05-20 15:16:13', 'Edited page ""'),
  142. (79, 1001, '2010-05-20 15:16:19', 'Page Rules edited'),
  143. (80, 1001, '2010-05-20 15:16:26', 'Edited page ""'),
  144. (81, 1001, '2010-05-20 15:16:28', 'Page Disclaimer edited'),
  145. (82, 1001, '2010-05-20 15:16:34', 'Edited page ""'),
  146. (83, 1001, '2010-05-20 15:16:36', 'Page Staff edited'),
  147. (84, 1001, '2010-05-20 15:16:44', 'Edited page ""'),
  148. (85, 1001, '2010-05-20 15:17:31', 'Page Rules edited'),
  149. (86, 1001, '2010-05-20 15:21:45', 'Edited page ""'),
  150. (87, 1001, '2010-05-20 15:21:49', 'Page Disclaimer edited'),
  151. (88, 1001, '2010-05-20 15:22:53', 'Edited page ""'),
  152. (89, 1001, '2010-05-20 17:00:01', 'Added page "Fleet"'),
  153. (90, 1001, '2010-05-20 17:01:04', 'Page Fleet edited'),
  154. (91, 1001, '2010-05-20 17:01:59', 'Edited page ""'),
  155. (92, 1001, '2010-05-20 17:03:44', 'Page Fleet edited'),
  156. (93, 1001, '2010-05-20 17:04:39', 'Page Fleet edited'),
  157. (94, 1001, '2010-05-20 17:05:53', 'Edited page ""'),
  158. (95, 1001, '2010-05-20 17:09:03', 'Page Fleet edited'),
  159. (96, 1001, '2010-05-20 17:10:52', 'Page Fleet edited'),
  160. (97, 1001, '2010-05-20 17:11:43', 'Page Fleet edited'),
  161. (98, 1001, '2010-05-20 17:12:15', 'Edited page ""'),
  162. (99, 1001, '2010-05-20 17:13:23', 'Page Fleet edited'),
  163. (100, 1001, '2010-05-20 17:14:01', 'Edited page ""'),
  164. (101, 1001, '2010-05-20 17:15:04', 'Page Fleet edited'),
  165. (102, 1001, '2010-05-20 17:15:18', 'Edited page ""'),
  166. (103, 1001, '2010-05-20 17:15:50', 'Page Fleet edited'),
  167. (104, 1001, '2010-05-20 17:16:14', 'Edited page ""'),
  168. (105, 1001, '2010-05-20 17:20:50', 'Edited news item "Welcome to phpVMS!"'),
  169. (106, 1001, '2010-05-20 17:21:36', 'Deleted news 1'),
  170. (107, 1001, '2010-05-20 17:23:42', 'Added news "Welcome to the Cargoitalia Virtual"'),
  171. (108, 1001, '2010-05-20 17:24:35', 'Deleted news 2'),
  172. (109, 1001, '2010-05-20 17:25:27', 'Added news "Welcome Cargoitalia Virtual"'),
  173. (110, 1001, '2010-05-20 17:55:34', 'Edited group "Active Pilots"'),
  174. (111, 1001, '2010-05-20 17:55:48', 'Edited group "Active Pilots"'),
  175. (112, 1001, '2010-05-20 18:01:46', 'Edited the airport "LIMC - Milan Malpensa"'),
  176. (113, 1001, '2010-05-20 18:01:55', 'Edited the airport "LIMC - Milan Malpensa"'),
  177. (114, 1001, '2010-05-20 18:31:14', 'Added pilot #1003 to group "Administrators"'),
  178. (115, 1001, '2010-05-20 18:46:58', 'Edited news item "Welcome Cargoitalia Virtual"'),
  179. (116, 1001, '2010-05-20 19:57:54', 'Added page "Career"'),
  180. (117, 1001, '2010-05-20 19:58:45', 'Page Career edited'),
  181. (118, 1001, '2010-05-20 19:59:14', 'Edited page ""'),
  182. (119, 1001, '2010-05-20 19:59:44', 'Page Fleet edited'),
  183. (120, 1001, '2010-05-20 19:59:53', 'Edited page ""'),
  184. (121, 1001, '2010-05-20 19:59:57', 'Page Staff edited'),
  185. (122, 1001, '2010-05-20 20:00:07', 'Edited page ""'),
  186. (123, 1001, '2010-05-20 20:00:10', 'Page Disclaimer edited'),
  187. (124, 1001, '2010-05-20 20:00:24', 'Edited page ""'),
  188. (125, 1001, '2010-05-20 20:00:28', 'Page Rules edited'),
  189. (126, 1001, '2010-05-20 20:00:39', 'Edited page ""'),
  190. (127, 1001, '2010-05-20 20:05:43', 'Added the airport "LPPT - Lisboa / Portela"'),
  191. (128, 1001, '2010-05-20 20:06:03', 'Added the airport "OMDB - Dubai International Airport"'),
  192. (129, 1001, '2010-05-20 20:06:37', 'Added the airport "EDDH - airport Hamburg-Fuhlsbüttel"'),
  193. (130, 1001, '2010-05-20 20:07:01', 'Added the airport "EGBB - Birmingham / Airport"'),
  194. (131, 1001, '2010-05-20 20:07:25', 'Added the airport "EDDT - Tegel"'),
  195. (132, 1001, '2010-05-20 20:07:29', 'Page edited'),
  196. (133, 1001, '2010-05-20 20:07:39', 'Added the airport "EGLL - Heathrow"'),
  197. (134, 1001, '2010-05-20 20:07:50', 'Added the airport "ESSA - Arlanda"'),
  198. (135, 1001, '2010-05-20 20:08:15', 'Added the airport "KBOS - General Edward Lawrence Logan International Airport"'),
  199. (136, 1001, '2010-05-20 20:08:26', 'Added the airport "LEIB - Ibiza / Es Codola"'),
  200. (137, 1001, '2010-05-20 20:08:42', 'Added the airport "GMML - Laayoune/Hassan Isl"'),
  201. (138, 1001, '2010-05-20 20:08:52', 'Added the airport "LFRS - Nantes-Atlantique"'),
  202. (139, 1001, '2010-05-20 20:09:02', 'Added the airport "LPPR - Porto / Pedras Rubras"'),
  203. (140, 1001, '2010-05-20 20:09:39', 'Added the airport "EGKK - Gatwick Airport"'),
  204. (141, 1001, '2010-05-20 20:09:47', 'Added the airport "OLBA - Beirut International"'),
  205. (142, 1001, '2010-05-20 20:09:56', 'Added the airport "LMML - Luqa"'),
  206. (143, 1001, '2010-05-20 20:10:06', 'Added the airport "LHBP - Budapest / Ferihegy"'),
  207. (144, 1001, '2010-05-20 20:10:14', 'Added the airport "LGAV - Athens Eleftherios Venizelos International Airport"'),
  208. (145, 1001, '2010-05-20 20:21:33', 'Updated profile for CIV1002 Mario Chahine'),
  209. (146, 1001, '2010-05-20 20:21:36', 'Updated profile for CIV1002 Mario Chahine'),
  210. (147, 1001, '2010-05-20 20:24:04', 'Page Staff edited'),
  211. (148, 1001, '2010-05-20 20:24:30', 'Edited page ""'),
  212. (149, 1001, '2010-05-20 20:25:03', 'Page Rules edited'),
  213. (150, 1001, '2010-05-20 20:25:23', 'Edited page ""'),
  214. (151, 1001, '2010-05-20 20:25:59', 'Page Disclaimer edited'),
  215. (152, 1001, '2010-05-20 20:29:51', 'Edited page ""'),
  216. (153, 1001, '2010-05-20 20:29:57', 'Page Rules edited'),
  217. (154, 1001, '2010-05-20 20:30:33', 'Edited page ""'),
  218. (155, 1001, '2010-05-20 20:30:43', 'Page Disclaimer edited'),
  219. (156, 1001, '2010-05-20 20:31:00', 'Edited page ""'),
  220. (157, 1001, '2010-05-20 20:34:14', 'Page Rules edited'),
  221. (158, 1001, '2010-05-20 20:36:00', 'Edited page ""'),
  222. (159, 1001, '2010-05-20 20:36:04', 'Page Disclaimer edited'),
  223. (160, 1001, '2010-05-20 20:36:13', 'Edited page ""'),
  224. (161, 1001, '2010-05-20 20:36:18', 'Page Staff edited'),
  225. (162, 1001, '2010-05-20 20:36:27', 'Edited page ""'),
  226. (163, 1001, '2010-05-20 20:36:31', 'Page Fleet edited'),
  227. (164, 1001, '2010-05-20 20:37:23', 'Page Disclaimer edited'),
  228. (165, 1001, '2010-05-20 20:38:08', 'Edited page ""'),
  229. (166, 1001, '2010-05-20 21:59:28', 'Page Career edited'),
  230. (167, 1001, '2010-05-20 22:02:01', 'Edited page ""'),
  231. (168, 1001, '2010-05-20 22:04:08', 'Page Rules edited'),
  232. (169, 1001, '2010-05-20 22:05:45', 'Edited page ""'),
  233. (170, 1001, '2010-05-20 22:05:50', 'Page Disclaimer edited'),
  234. (171, 1001, '2010-05-20 22:06:13', 'Edited page ""'),
  235. (172, 1001, '2010-05-20 22:06:17', 'Page Staff edited'),
  236. (173, 1001, '2010-05-20 22:06:37', 'Edited page ""'),
  237. (174, 1001, '2010-05-20 22:06:41', 'Page Fleet edited'),
  238. (175, 1001, '2010-05-20 22:07:40', 'Edited page ""'),
  239. (176, 1001, '2010-05-20 22:07:51', 'Page Career edited'),
  240. (177, 1001, '2010-05-20 22:08:13', 'Edited page ""'),
  241. (178, 1001, '2010-05-20 22:08:20', 'Page Staff edited'),
  242. (179, 1001, '2010-05-20 22:09:24', 'Page Disclaimer edited'),
  243. (180, 1001, '2010-05-20 22:09:34', 'Page Staff edited'),
  244. (181, 1001, '2010-05-20 22:09:45', 'Page Rules edited'),
  245. (182, 1001, '2010-05-20 22:09:51', 'Edited page ""'),
  246. (183, 1001, '2010-05-20 22:10:19', 'Page Staff edited'),
  247. (184, 1001, '2010-05-20 22:10:29', 'Edited page ""'),
  248. (185, 1001, '2010-05-20 23:05:08', 'Added schedule "CIV641"'),
  249. (186, 1001, '2010-05-20 23:07:38', 'Edited the airline "CRG - Cargoitalia Virtual"'),
  250. (187, 1001, '2010-05-20 23:09:41', 'Added schedule "CRG653"'),
  251. (188, 1001, '2010-05-20 23:11:35', 'Added schedule "CRG656"'),
  252. (189, 1001, '2010-05-20 23:13:17', 'Added schedule "CRG669"'),
  253. (190, 1001, '2010-05-20 23:16:52', 'Added schedule "CRG632"'),
  254. (191, 1001, '2010-05-20 23:18:45', 'Added schedule "CRG644"'),
  255. (192, 1001, '2010-05-20 23:20:43', 'Added schedule "CRG665"'),
  256. (193, 1001, '2010-05-20 23:22:14', 'Added schedule "CRG678"'),
  257. (194, 1001, '2010-05-20 23:25:01', 'Added schedule "CRG635"'),
  258. (195, 1001, '2010-05-20 23:26:31', 'Added schedule "CRG647"'),
  259. (196, 1001, '2010-05-20 23:27:59', 'Added schedule "CRG662"'),
  260. (197, 1001, '2010-05-20 23:29:59', 'Edited schedule "CRG662"'),
  261. (198, 1001, '2010-05-20 23:31:08', 'Added schedule "CRG675"'),
  262. (199, 1001, '2010-05-20 23:33:39', 'Added schedule "CRG640"'),
  263. (200, 1001, '2010-05-20 23:35:24', 'Added schedule "CRG652"'),
  264. (201, 1001, '2010-05-20 23:37:00', 'Added schedule "CRG657"'),
  265. (202, 1001, '2010-05-20 23:39:06', 'Added schedule "CRG670"'),
  266. (203, 1001, '2010-05-20 23:42:34', 'Added schedule "CRG631"'),
  267. (204, 1001, '2010-05-20 23:43:36', 'Added schedule "CRG643"'),
  268. (205, 1001, '2010-05-20 23:44:54', 'Added schedule "CRG667"'),
  269. (206, 1001, '2010-05-20 23:46:32', 'Added schedule "CRG679"'),
  270. (207, 1001, '2010-05-20 23:49:56', 'Added schedule "CRG637"'),
  271. (208, 1001, '2010-05-20 23:51:21', 'Added schedule "CRG649"'),
  272. (209, 1001, '2010-05-20 23:52:44', 'Added schedule "CRG660"'),
  273. (210, 1001, '2010-05-20 23:54:12', 'Added schedule "CRG673"'),
  274. (211, 1001, '2010-05-20 23:56:27', 'Added schedule "CRG638"'),
  275. (212, 1001, '2010-05-20 23:57:31', 'Added schedule "CRG650"'),
  276. (213, 1001, '2010-05-20 23:58:59', 'Added schedule "CRG659"'),
  277. (214, 1001, '2010-05-21 00:00:40', 'Added schedule "CRG672"'),
  278. (215, 1001, '2010-05-21 00:08:11', 'Added schedule "CRG633"'),
  279. (216, 1001, '2010-05-21 00:09:26', 'Added schedule "CRG645"'),
  280. (217, 1001, '2010-05-21 00:11:27', 'Added schedule "CRG664"'),
  281. (218, 1001, '2010-05-21 00:13:09', 'Added schedule "CRG677"'),
  282. (219, 1001, '2010-05-21 00:15:37', 'Added schedule "CRG636"'),
  283. (220, 1001, '2010-05-21 00:16:37', 'Added schedule "CRG648"'),
  284. (221, 1001, '2010-05-21 00:18:02', 'Added schedule "CRG661"'),
  285. (222, 1001, '2010-05-21 00:19:00', 'Added schedule "CRG674"'),
  286. (223, 1001, '2010-05-21 00:22:09', 'Added schedule "CRG639"'),
  287. (224, 1001, '2010-05-21 00:23:17', 'Added schedule "CRG651"'),
  288. (225, 1001, '2010-05-21 00:24:31', 'Added schedule "CRG658"'),
  289. (226, 1001, '2010-05-21 00:25:46', 'Added schedule "CRG671"'),
  290. (227, 1001, '2010-05-21 00:28:02', 'Added schedule "CRG634"'),
  291. (228, 1001, '2010-05-21 00:29:10', 'Added schedule "CRG646"'),
  292. (229, 1001, '2010-05-21 00:30:22', 'Added schedule "CRG663"'),
  293. (230, 1001, '2010-05-21 00:31:47', 'Added schedule "CRG676"'),
  294. (231, 1001, '2010-05-21 00:35:55', 'Added schedule "CRG642"'),
  295. (232, 1001, '2010-05-21 00:38:06', 'Added schedule "CRG654"'),
  296. (233, 1001, '2010-05-21 00:39:25', 'Added schedule "CRG655"'),
  297. (234, 1001, '2010-05-21 00:40:33', 'Added schedule "CRG668"'),
  298. (235, 1001, '2010-05-21 00:45:34', 'Added the aircraft "MD-11F GE - EI-UPE"'),
  299. (236, 1001, '2010-05-21 00:46:09', 'Edited the aircraft "MD-11F - EI-UPE"'),
  300. (237, 1001, '2010-05-21 00:46:46', 'Edited the aircraft "MD-11F - EI-UPE"'),
  301. (238, 1001, '2010-05-21 00:47:51', 'Edited schedule "CRG653"'),
  302. (239, 1001, '2010-05-21 00:48:09', 'Edited schedule "CRG669"'),
  303. (240, 1001, '2010-05-21 00:48:25', 'Edited schedule "CRG644"'),
  304. (241, 1001, '2010-05-21 00:48:51', 'Edited schedule "CRG678"'),
  305. (242, 1001, '2010-05-21 00:49:11', 'Edited schedule "CRG647"'),
  306. (243, 1001, '2010-05-21 00:49:31', 'Edited schedule "CRG675"'),
  307. (244, 1001, '2010-05-21 00:49:51', 'Edited schedule "CRG652"'),
  308. (245, 1001, '2010-05-21 00:50:07', 'Edited schedule "CRG670"'),
  309. (246, 1001, '2010-05-21 00:50:29', 'Edited schedule "CRG643"'),
  310. (247, 1001, '2010-05-21 00:50:44', 'Edited schedule "CRG679"'),
  311. (248, 1001, '2010-05-21 00:51:02', 'Edited schedule "CRG645"'),
  312. (249, 1001, '2010-05-21 00:51:20', 'Edited schedule "CRG677"'),
  313. (250, 1001, '2010-05-21 00:53:06', 'Edited schedule "CRG649"'),
  314. (251, 1001, '2010-05-21 00:53:25', 'Edited schedule "CRG673"'),
  315. (252, 1001, '2010-05-21 00:53:48', 'Edited schedule "CRG650"'),
  316. (253, 1001, '2010-05-21 00:54:17', 'Edited schedule "CRG672"'),
  317. (254, 1001, '2010-05-21 00:55:15', 'Edited schedule "CRG648"'),
  318. (255, 1001, '2010-05-21 00:55:47', 'Edited schedule "CRG674"'),
  319. (256, 1001, '2010-05-21 00:56:34', 'Edited schedule "CRG651"'),
  320. (257, 1001, '2010-05-21 00:56:58', 'Edited schedule "CRG671"'),
  321. (258, 1001, '2010-05-21 00:57:19', 'Edited schedule "CRG646"'),
  322. (259, 1001, '2010-05-21 00:57:44', 'Edited schedule "CRG676"'),
  323. (260, 1001, '2010-05-21 00:58:11', 'Edited schedule "CRG654"'),
  324. (261, 1001, '2010-05-21 00:58:43', 'Edited schedule "CRG668"'),
  325. (262, 1001, '2010-05-21 00:59:15', 'Edited schedule "CRG668"'),
  326. (263, 1001, '2010-05-21 01:00:16', 'Edited schedule "CRG645"'),
  327. (264, 1001, '2010-05-21 01:18:14', 'Changed settings'),
  328. (265, 1001, '2010-05-21 01:22:23', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  329. (266, 1001, '2010-05-21 01:23:08', 'Changed settings'),
  330. (267, 1001, '2010-05-21 20:10:23', 'Edited the airport "EDDH - Hamburg-Fuhlsbüttel"'),
  331. (268, 1001, '2010-05-21 20:33:37', 'Changed settings'),
  332. (269, 1001, '2010-05-21 20:38:26', 'Page Fleet edited'),
  333. (270, 1001, '2010-05-21 21:04:14', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  334. (271, 1001, '2010-05-21 21:19:21', 'Page Staff edited'),
  335. (272, 1001, '2010-05-21 21:20:13', 'Edited page ""'),
  336. (273, 1001, '2010-05-21 21:20:59', 'Page Rules edited'),
  337. (274, 1001, '2010-05-21 21:21:26', 'Edited page ""'),
  338. (275, 1001, '2010-05-21 21:21:29', 'Page Disclaimer edited'),
  339. (276, 1001, '2010-05-21 21:22:06', 'Page Rules edited'),
  340. (277, 1001, '2010-05-21 21:22:31', 'Page Disclaimer edited'),
  341. (278, 1001, '2010-05-21 21:28:33', 'Page Fleet edited'),
  342. (279, 1001, '2010-05-21 21:28:58', 'Edited page ""'),
  343. (280, 1001, '2010-05-21 21:30:36', 'Page Disclaimer edited'),
  344. (281, 1001, '2010-05-21 21:32:01', 'Edited page ""'),
  345. (282, 1001, '2010-05-21 21:33:40', 'Page Disclaimer edited'),
  346. (283, 1001, '2010-05-21 21:35:30', 'Edited page ""'),
  347. (284, 1001, '2010-05-21 21:36:35', 'Page Career edited'),
  348. (285, 1001, '2010-05-21 21:42:05', 'Page Rules edited'),
  349. (286, 1001, '2010-05-21 21:43:31', 'Edited page ""'),
  350. (287, 1001, '2010-05-21 21:43:34', 'Page Disclaimer edited'),
  351. (288, 1001, '2010-05-21 21:44:14', 'Edited page ""'),
  352. (289, 1001, '2010-05-21 21:44:16', 'Page Staff edited'),
  353. (290, 1001, '2010-05-21 21:44:58', 'Edited page ""'),
  354. (291, 1001, '2010-05-21 21:45:06', 'Page Fleet edited'),
  355. (292, 1001, '2010-05-21 21:46:20', 'Page Fleet edited'),
  356. (293, 1001, '2010-05-21 21:46:38', 'Edited page ""'),
  357. (294, 1001, '2010-05-21 21:46:55', 'Page Fleet edited'),
  358. (295, 1001, '2010-05-21 21:47:03', 'Page Career edited'),
  359. (296, 1001, '2010-05-21 21:48:43', 'Page Career edited'),
  360. (297, 1001, '2010-05-21 21:50:55', 'Edited page ""'),
  361. (298, 1001, '2010-05-22 01:35:31', 'Page Career edited'),
  362. (299, 1001, '2010-05-22 01:36:08', 'Edited page ""'),
  363. (300, 1001, '2010-05-22 11:16:55', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  364. (301, 1001, '2010-05-22 11:18:26', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  365. (302, 1001, '2010-05-22 11:19:20', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  366. (303, 1001, '2010-05-22 11:19:49', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  367. (304, 1001, '2010-05-22 11:20:11', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  368. (305, 1001, '2010-05-22 11:21:59', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  369. (306, 1001, '2010-05-22 11:22:53', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  370. (307, 1001, '2010-05-22 11:22:58', 'Page Rules edited'),
  371. (308, 1001, '2010-05-22 11:23:46', 'Edited page ""'),
  372. (309, 1001, '2010-05-22 11:23:50', 'Page Disclaimer edited'),
  373. (310, 1001, '2010-05-22 11:24:20', 'Edited page ""'),
  374. (311, 1001, '2010-05-22 11:24:23', 'Page Staff edited'),
  375. (312, 1001, '2010-05-22 11:26:22', 'Edited page ""'),
  376. (313, 1001, '2010-05-22 11:26:27', 'Page Fleet edited'),
  377. (314, 1001, '2010-05-22 11:26:54', 'Edited page ""'),
  378. (315, 1001, '2010-05-22 11:26:57', 'Page Career edited'),
  379. (316, 1001, '2010-05-22 11:28:53', 'Edited page ""'),
  380. (317, 1001, '2010-05-22 11:35:32', 'Page Rules edited'),
  381. (318, 1001, '2010-05-22 11:47:00', 'Page Rules edited'),
  382. (319, 1001, '2010-05-22 11:50:15', 'Edited page ""'),
  383. (320, 1001, '2010-05-22 11:53:32', 'Page Disclaimer edited'),
  384. (321, 1001, '2010-05-22 11:53:59', 'Edited page ""'),
  385. (322, 1001, '2010-05-22 12:44:33', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  386. (323, 1002, '2010-05-22 12:53:53', 'Approved CRG1004 - Pinco Palli'),
  387. (324, 1001, '2010-05-22 12:54:01', 'Edited news item "Welcome to Cargoitalia Virtual"'),
  388. (325, 1001, '2010-05-23 01:41:44', 'Edited news item "Welcome to Cargoitalia Virtual"');
  389.  
  390. -- --------------------------------------------------------
  391.  
  392. --
  393. -- Table structure for table `phpvms_aircraft`
  394. --
  395.  
  396. CREATE TABLE IF NOT EXISTS `phpvms_aircraft` (
  397. `id` int(11) NOT NULL auto_increment,
  398. `icao` varchar(4) NOT NULL default '',
  399. `name` varchar(12) NOT NULL default '',
  400. `fullname` varchar(50) NOT NULL default '',
  401. `registration` varchar(30) NOT NULL,
  402. `downloadlink` text NOT NULL,
  403. `imagelink` text NOT NULL,
  404. `range` varchar(15) NOT NULL default '0',
  405. `weight` varchar(15) NOT NULL default '0',
  406. `cruise` varchar(15) NOT NULL default '0',
  407. `maxpax` float NOT NULL default '0',
  408. `maxcargo` float NOT NULL default '0',
  409. `minrank` int(11) NOT NULL default '0',
  410. `ranklevel` int(11) NOT NULL default '0',
  411. `enabled` smallint(6) NOT NULL default '1',
  412. PRIMARY KEY (`id`)
  413. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  414.  
  415. --
  416. -- Dumping data for table `phpvms_aircraft`
  417. --
  418.  
  419. INSERT INTO `phpvms_aircraft` (`id`, `icao`, `name`, `fullname`, `registration`, `downloadlink`, `imagelink`, `range`, `weight`, `cruise`, `maxpax`, `maxcargo`, `minrank`, `ranklevel`, `enabled`) VALUES
  420. (1, 'MD11', 'MD-11F', 'McDonnell Douglas MD-11F GE', 'EI-UPI', 'http://www.precisionmanuals.com/pages/product/md11.html', 'http://cdn-www.airliners.net/aviation-photos/middle/3/4/1/1592143.jpg', '3950 Nm', '112748 kgs', '41000 ft', 0, 95391, 0, 0, 1),
  421. (2, 'MD11', 'MD-11F', 'McDonnell Douglas MD-11F GE', 'EI-UPE', 'http://www.precisionmanuals.com/pages/product/md11.html', 'http://cdn-www.airliners.net/aviation-photos/middle/3/4/1/1592143.jpg', '3950', '112748', '41000', 0, 95391, 0, 0, 1);
  422.  
  423. -- --------------------------------------------------------
  424.  
  425. --
  426. -- Table structure for table `phpvms_airlines`
  427. --
  428.  
  429. CREATE TABLE IF NOT EXISTS `phpvms_airlines` (
  430. `id` int(11) NOT NULL auto_increment,
  431. `code` char(3) NOT NULL default '',
  432. `name` varchar(30) NOT NULL default '',
  433. `enabled` smallint(6) NOT NULL default '1',
  434. PRIMARY KEY (`id`),
  435. UNIQUE KEY `code` (`code`)
  436. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  437.  
  438. --
  439. -- Dumping data for table `phpvms_airlines`
  440. --
  441.  
  442. INSERT INTO `phpvms_airlines` (`id`, `code`, `name`, `enabled`) VALUES
  443. (1, 'CRG', 'Cargoitalia Virtual', 1);
  444.  
  445. -- --------------------------------------------------------
  446.  
  447. --
  448. -- Table structure for table `phpvms_airports`
  449. --
  450.  
  451. CREATE TABLE IF NOT EXISTS `phpvms_airports` (
  452. `id` int(11) NOT NULL auto_increment,
  453. `icao` varchar(5) NOT NULL default '',
  454. `name` text NOT NULL,
  455. `country` varchar(50) NOT NULL default '',
  456. `lat` float NOT NULL default '0',
  457. `lng` float NOT NULL default '0',
  458. `hub` smallint(6) NOT NULL default '0',
  459. `fuelprice` float NOT NULL default '0',
  460. `chartlink` text NOT NULL,
  461. PRIMARY KEY (`id`),
  462. UNIQUE KEY `icao` (`icao`)
  463. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
  464.  
  465. --
  466. -- Dumping data for table `phpvms_airports`
  467. --
  468.  
  469. INSERT INTO `phpvms_airports` (`id`, `icao`, `name`, `country`, `lat`, `lng`, `hub`, `fuelprice`, `chartlink`) VALUES
  470. (2, 'LIMC', 'Milan Malpensa', 'Italy', 45.6341, 8.72297, 1, 0, ''),
  471. (3, 'LPPT', 'Lisboa / Portela', 'Portugal', 38.7813, -9.13592, 0, 0, ''),
  472. (4, 'OMDB', 'Dubai International Airport', 'United Arab Emirates', 25.2528, 55.3644, 0, 0, ''),
  473. (5, 'EDDH', 'Hamburg-Fuhlsbüttel', 'Germany', 53.6304, 9.98823, 0, 0, ''),
  474. (6, 'EGBB', 'Birmingham / Airport', 'United Kingdom', 52.4539, -1.74803, 0, 0, ''),
  475. (7, 'EDDT', 'Tegel', 'Germany', 52.5597, 13.2877, 0, 0, ''),
  476. (8, 'EGLL', 'Heathrow', 'United Kingdom', 51.4711, -0.456491, 0, 0, ''),
  477. (9, 'ESSA', 'Arlanda', 'Sweden', 59.6519, 17.9186, 0, 0, ''),
  478. (10, 'KBOS', 'General Edward Lawrence Logan International Airport', 'United States', 42.3651, -71.0178, 0, 0, ''),
  479. (11, 'LEIB', 'Ibiza / Es Codola', 'Spain', 38.8729, 1.37312, 0, 0, ''),
  480. (12, 'GMML', 'Laayoune/Hassan Isl', 'Morocco', 27.1517, -13.2192, 0, 0, ''),
  481. (13, 'LFRS', 'Nantes-Atlantique', 'France', 47.1532, -1.61073, 0, 0, ''),
  482. (14, 'LPPR', 'Porto / Pedras Rubras', 'Portugal', 41.2481, -8.68139, 0, 0, ''),
  483. (15, 'EGKK', 'Gatwick Airport', 'United Kingdom', 51.1481, -0.190278, 0, 0, ''),
  484. (16, 'OLBA', 'Beirut International', 'Lebanon', 33.8209, 35.4884, 0, 0, ''),
  485. (17, 'LMML', 'Luqa', 'Malta', 35.8575, 14.4772, 0, 0, ''),
  486. (18, 'LHBP', 'Budapest / Ferihegy', 'Hungary', 47.4369, 19.2556, 0, 0, ''),
  487. (19, 'LGAV', 'Athens Eleftherios Venizelos International Airport', 'Greece', 37.9364, 23.9445, 0, 0, '');
  488.  
  489. -- --------------------------------------------------------
  490.  
  491. --
  492. -- Table structure for table `phpvms_awards`
  493. --
  494.  
  495. CREATE TABLE IF NOT EXISTS `phpvms_awards` (
  496. `awardid` int(11) NOT NULL auto_increment,
  497. `name` varchar(25) NOT NULL,
  498. `descrip` varchar(100) NOT NULL,
  499. `image` text NOT NULL,
  500. PRIMARY KEY (`awardid`)
  501. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  502.  
  503. --
  504. -- Dumping data for table `phpvms_awards`
  505. --
  506.  
  507.  
  508. -- --------------------------------------------------------
  509.  
  510. --
  511. -- Table structure for table `phpvms_awardsgranted`
  512. --
  513.  
  514. CREATE TABLE IF NOT EXISTS `phpvms_awardsgranted` (
  515. `id` int(11) NOT NULL auto_increment,
  516. `awardid` int(11) NOT NULL,
  517. `pilotid` int(11) NOT NULL,
  518. `dateissued` datetime NOT NULL,
  519. PRIMARY KEY (`id`)
  520. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  521.  
  522. --
  523. -- Dumping data for table `phpvms_awardsgranted`
  524. --
  525.  
  526.  
  527. -- --------------------------------------------------------
  528.  
  529. --
  530. -- Table structure for table `phpvms_bids`
  531. --
  532.  
  533. CREATE TABLE IF NOT EXISTS `phpvms_bids` (
  534. `bidid` int(11) NOT NULL auto_increment,
  535. `pilotid` int(11) NOT NULL default '0',
  536. `routeid` int(11) NOT NULL default '0',
  537. `dateadded` date NOT NULL,
  538. PRIMARY KEY (`bidid`)
  539. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  540.  
  541. --
  542. -- Dumping data for table `phpvms_bids`
  543. --
  544.  
  545.  
  546. -- --------------------------------------------------------
  547.  
  548. --
  549. -- Table structure for table `phpvms_customfields`
  550. --
  551.  
  552. CREATE TABLE IF NOT EXISTS `phpvms_customfields` (
  553. `fieldid` int(11) NOT NULL auto_increment,
  554. `title` varchar(75) NOT NULL,
  555. `fieldname` varchar(75) NOT NULL,
  556. `value` text NOT NULL,
  557. `type` varchar(25) NOT NULL default 'text',
  558. `public` smallint(6) NOT NULL default '0',
  559. `showonregister` smallint(6) NOT NULL default '0',
  560. PRIMARY KEY (`fieldid`),
  561. UNIQUE KEY `fieldname` (`fieldname`)
  562. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  563.  
  564. --
  565. -- Dumping data for table `phpvms_customfields`
  566. --
  567.  
  568.  
  569. -- --------------------------------------------------------
  570.  
  571. --
  572. -- Table structure for table `phpvms_downloads`
  573. --
  574.  
  575. CREATE TABLE IF NOT EXISTS `phpvms_downloads` (
  576. `id` int(11) NOT NULL auto_increment,
  577. `pid` int(11) default NULL,
  578. `name` varchar(50) default NULL,
  579. `description` text,
  580. `link` text,
  581. `image` text,
  582. `hits` int(11) default NULL,
  583. PRIMARY KEY (`id`)
  584. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  585.  
  586. --
  587. -- Dumping data for table `phpvms_downloads`
  588. --
  589.  
  590. INSERT INTO `phpvms_downloads` (`id`, `pid`, `name`, `description`, `link`, `image`, `hits`) VALUES
  591. (1, 0, 'Rule', NULL, '', '', NULL);
  592.  
  593. -- --------------------------------------------------------
  594.  
  595. --
  596. -- Table structure for table `phpvms_expenselog`
  597. --
  598.  
  599. CREATE TABLE IF NOT EXISTS `phpvms_expenselog` (
  600. `dateadded` int(11) NOT NULL,
  601. `name` varchar(25) NOT NULL,
  602. `type` varchar(2) NOT NULL,
  603. `cost` float NOT NULL,
  604. KEY `dateadded` (`dateadded`)
  605. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  606.  
  607. --
  608. -- Dumping data for table `phpvms_expenselog`
  609. --
  610.  
  611.  
  612. -- --------------------------------------------------------
  613.  
  614. --
  615. -- Table structure for table `phpvms_expenses`
  616. --
  617.  
  618. CREATE TABLE IF NOT EXISTS `phpvms_expenses` (
  619. `id` int(11) NOT NULL auto_increment,
  620. `name` varchar(25) NOT NULL,
  621. `cost` float NOT NULL,
  622. `fixed` int(11) NOT NULL default '0',
  623. `type` varchar(1) NOT NULL default 'M',
  624. PRIMARY KEY (`id`)
  625. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  626.  
  627. --
  628. -- Dumping data for table `phpvms_expenses`
  629. --
  630.  
  631.  
  632. -- --------------------------------------------------------
  633.  
  634. --
  635. -- Table structure for table `phpvms_fieldvalues`
  636. --
  637.  
  638. CREATE TABLE IF NOT EXISTS `phpvms_fieldvalues` (
  639. `id` int(11) NOT NULL auto_increment,
  640. `fieldid` int(11) NOT NULL,
  641. `pilotid` int(11) NOT NULL,
  642. `value` text NOT NULL,
  643. PRIMARY KEY (`id`),
  644. KEY `phpvms_fieldvalues_ibfk_1` (`fieldid`),
  645. KEY `phpvms_fieldvalues_ibfk_2` (`pilotid`)
  646. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  647.  
  648. --
  649. -- Dumping data for table `phpvms_fieldvalues`
  650. --
  651.  
  652.  
  653. -- --------------------------------------------------------
  654.  
  655. --
  656. -- Table structure for table `phpvms_financedata`
  657. --
  658.  
  659. CREATE TABLE IF NOT EXISTS `phpvms_financedata` (
  660. `id` int(11) NOT NULL auto_increment,
  661. `month` int(11) NOT NULL,
  662. `year` int(11) NOT NULL,
  663. `data` text NOT NULL,
  664. `total` float NOT NULL,
  665. PRIMARY KEY (`id`)
  666. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  667.  
  668. --
  669. -- Dumping data for table `phpvms_financedata`
  670. --
  671.  
  672.  
  673. -- --------------------------------------------------------
  674.  
  675. --
  676. -- Table structure for table `phpvms_fuelprices`
  677. --
  678.  
  679. CREATE TABLE IF NOT EXISTS `phpvms_fuelprices` (
  680. `id` int(11) NOT NULL auto_increment,
  681. `icao` varchar(4) NOT NULL,
  682. `lowlead` float NOT NULL,
  683. `jeta` float NOT NULL,
  684. `dateupdated` datetime NOT NULL,
  685. PRIMARY KEY (`id`)
  686. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  687.  
  688. --
  689. -- Dumping data for table `phpvms_fuelprices`
  690. --
  691.  
  692.  
  693. -- --------------------------------------------------------
  694.  
  695. --
  696. -- Table structure for table `phpvms_groupmembers`
  697. --
  698.  
  699. CREATE TABLE IF NOT EXISTS `phpvms_groupmembers` (
  700. `id` int(11) NOT NULL auto_increment,
  701. `groupid` int(11) NOT NULL default '0',
  702. `pilotid` int(11) NOT NULL default '0',
  703. PRIMARY KEY (`id`),
  704. KEY `phpvms_groupmembers_ibfk_1` (`groupid`),
  705. KEY `phpvms_groupmembers_ibfk_2` (`pilotid`)
  706. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
  707.  
  708. --
  709. -- Dumping data for table `phpvms_groupmembers`
  710. --
  711.  
  712. INSERT INTO `phpvms_groupmembers` (`id`, `groupid`, `pilotid`) VALUES
  713. (1, 2, 1001),
  714. (2, 1, 1001),
  715. (3, 2, 1002),
  716. (4, 2, 1003),
  717. (5, 1, 1002),
  718. (6, 1, 1003);
  719.  
  720. -- --------------------------------------------------------
  721.  
  722. --
  723. -- Table structure for table `phpvms_groups`
  724. --
  725.  
  726. CREATE TABLE IF NOT EXISTS `phpvms_groups` (
  727. `groupid` int(11) NOT NULL auto_increment,
  728. `name` varchar(25) NOT NULL default '',
  729. `permissions` varchar(25) NOT NULL default '',
  730. PRIMARY KEY (`groupid`),
  731. UNIQUE KEY `name` (`name`)
  732. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  733.  
  734. --
  735. -- Dumping data for table `phpvms_groups`
  736. --
  737.  
  738. INSERT INTO `phpvms_groups` (`groupid`, `name`, `permissions`) VALUES
  739. (1, 'Administrators', '35651519'),
  740. (2, 'Active Pilots', '0');
  741.  
  742. -- --------------------------------------------------------
  743.  
  744. --
  745. -- Table structure for table `phpvms_navdata`
  746. --
  747.  
  748. CREATE TABLE IF NOT EXISTS `phpvms_navdata` (
  749. `id` int(11) NOT NULL auto_increment,
  750. `name` varchar(7) NOT NULL,
  751. `title` varchar(25) NOT NULL,
  752. `airway` varchar(7) default NULL,
  753. `airway_type` varchar(1) default NULL,
  754. `seq` int(11) NOT NULL,
  755. `loc` varchar(4) NOT NULL,
  756. `lat` float(8,6) NOT NULL,
  757. `lng` float(9,6) NOT NULL,
  758. `freq` varchar(7) NOT NULL,
  759. `type` int(11) NOT NULL,
  760. PRIMARY KEY (`id`),
  761. KEY `name` (`name`),
  762. KEY `airway` (`airway`)
  763. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  764.  
  765. --
  766. -- Dumping data for table `phpvms_navdata`
  767. --
  768.  
  769.  
  770. -- --------------------------------------------------------
  771.  
  772. --
  773. -- Table structure for table `phpvms_news`
  774. --
  775.  
  776. CREATE TABLE IF NOT EXISTS `phpvms_news` (
  777. `id` int(11) NOT NULL auto_increment,
  778. `subject` varchar(30) NOT NULL default '',
  779. `body` text NOT NULL,
  780. `postdate` datetime NOT NULL default '0000-00-00 00:00:00',
  781. `postedby` varchar(50) NOT NULL default '',
  782. PRIMARY KEY (`id`)
  783. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  784.  
  785. --
  786. -- Dumping data for table `phpvms_news`
  787. --
  788.  
  789. INSERT INTO `phpvms_news` (`id`, `subject`, `body`, `postdate`, `postedby`) VALUES
  790. (3, 'Welcome to Cargoitalia Virtual', '<p style="text-align: center">\r\n <strong><em><span style="font-size: 18px"><img alt="" height="378" src="http://i1024.photobucket.com/albums/y303/thomas-zaniboni/Cargoitalia Virtual/imagescargo.jpg?" style="width: 704px; height: 297px" width="819" /></span></em></strong></p>\r\n<p style="text-align: center">\r\n <span style="font-size: 18px">Foto : MD-11F (EI-UPI) at LIMC Milano Malpensa terminal cargo.</span></p>\r\n', '2010-05-20 17:25:27', 'Thomas Zaniboni');
  791.  
  792. -- --------------------------------------------------------
  793.  
  794. --
  795. -- Table structure for table `phpvms_pages`
  796. --
  797.  
  798. CREATE TABLE IF NOT EXISTS `phpvms_pages` (
  799. `pageid` int(11) NOT NULL auto_increment,
  800. `pagename` varchar(30) NOT NULL default '',
  801. `filename` varchar(30) NOT NULL default '',
  802. `order` smallint(6) NOT NULL default '0',
  803. `postedby` varchar(50) NOT NULL default '',
  804. `postdate` datetime NOT NULL default '0000-00-00 00:00:00',
  805. `public` smallint(6) NOT NULL default '0',
  806. `enabled` smallint(6) NOT NULL default '1',
  807. PRIMARY KEY (`pageid`),
  808. UNIQUE KEY `pagename` (`pagename`)
  809. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
  810.  
  811. --
  812. -- Dumping data for table `phpvms_pages`
  813. --
  814.  
  815. INSERT INTO `phpvms_pages` (`pageid`, `pagename`, `filename`, `order`, `postedby`, `postdate`, `public`, `enabled`) VALUES
  816. (4, 'Rules', 'rules', 0, 'Thomas Zaniboni', '2010-05-20 14:57:10', 1, 1),
  817. (5, 'Disclaimer', 'disclaimer', 0, 'Thomas Zaniboni', '2010-05-20 14:59:27', 1, 1),
  818. (6, 'Staff', 'staff', 0, 'Thomas Zaniboni', '2010-05-20 15:13:24', 1, 1),
  819. (7, 'Fleet', 'fleet', 0, 'Thomas Zaniboni', '2010-05-20 17:00:01', 1, 1),
  820. (8, 'Career', 'career', 0, 'Thomas Zaniboni', '2010-05-20 19:57:54', 1, 1);
  821.  
  822. -- --------------------------------------------------------
  823.  
  824. --
  825. -- Table structure for table `phpvms_pilots`
  826. --
  827.  
  828. CREATE TABLE IF NOT EXISTS `phpvms_pilots` (
  829. `pilotid` int(11) NOT NULL auto_increment,
  830. `firstname` varchar(25) NOT NULL default '',
  831. `lastname` varchar(25) NOT NULL default '',
  832. `email` varchar(100) NOT NULL default '',
  833. `code` char(3) NOT NULL default '',
  834. `location` varchar(32) NOT NULL default '',
  835. `hub` varchar(4) NOT NULL default '',
  836. `password` varchar(32) NOT NULL default '',
  837. `salt` varchar(32) NOT NULL default '',
  838. `bgimage` varchar(30) NOT NULL default '',
  839. `lastlogin` date NOT NULL default '0000-00-00',
  840. `totalflights` int(11) NOT NULL default '0',
  841. `totalhours` float NOT NULL default '0',
  842. `totalpay` float NOT NULL default '0',
  843. `transferhours` float NOT NULL default '0',
  844. `rankid` int(11) NOT NULL default '0',
  845. `rank` varchar(32) NOT NULL default 'New Hire',
  846. `ranklevel` int(11) NOT NULL default '0',
  847. `confirmed` smallint(5) unsigned NOT NULL default '0',
  848. `retired` smallint(6) NOT NULL default '0',
  849. `joindate` datetime NOT NULL default '0000-00-00 00:00:00',
  850. `lastpirep` datetime NOT NULL default '0000-00-00 00:00:00',
  851. `lastip` varchar(25) default '',
  852. PRIMARY KEY (`pilotid`),
  853. KEY `code` (`code`),
  854. KEY `rank` (`rank`)
  855. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1005 ;
  856.  
  857. --
  858. -- Dumping data for table `phpvms_pilots`
  859. --
  860.  
  861. INSERT INTO `phpvms_pilots` (`pilotid`, `firstname`, `lastname`, `email`, `code`, `location`, `hub`, `password`, `salt`, `bgimage`, `lastlogin`, `totalflights`, `totalhours`, `totalpay`, `transferhours`, `rankid`, `rank`, `ranklevel`, `confirmed`, `retired`, `joindate`, `lastpirep`, `lastip`) VALUES
  862. (1001, 'Thomas', 'Zaniboni', '[email protected]', 'CRG', 'IT', 'LIMC', 'd0ad6404f631fcfdfd6aa0ef34a9cc39', '04b7f697b2bd7703e6f2ecfd406f3da8', 'background.png', '2010-05-23', 0, 0, 0, 1664, 1, 'Senior Captain', 1, 1, 0, '2010-05-19 23:30:01', '0000-00-00 00:00:00', '87.4.84.250'),
  863. (1002, 'Mario', 'Chahine', '[email protected]', 'CRG', 'IT', 'LIMC', 'd4fd42253c17e971ebf1c9d239f0123f', '53c6b48fc026659a2b691ba909b71e15', 'background.png', '2010-05-23', 0, 0, 0, 540, 1, 'Captain', 1, 1, 0, '2010-05-19 23:32:29', '2010-05-22 00:11:41', '93.48.150.37'),
  864. (1003, 'Davide', 'Consiglio', '[email protected]', 'CRG', 'IT', 'LIMC', 'd514fac7aad589d21a20b5bba95338ae', '1e631824ee4625f012d0bd01b4ad9434', '', '0000-00-00', 0, 0, 0, 224, 1, '1st Officer', 1, 1, 0, '2010-05-20 00:06:20', '0000-00-00 00:00:00', '151.61.54.234');
  865.  
  866. -- --------------------------------------------------------
  867.  
  868. --
  869. -- Table structure for table `phpvms_pirepcomments`
  870. --
  871.  
  872. CREATE TABLE IF NOT EXISTS `phpvms_pirepcomments` (
  873. `id` int(11) NOT NULL auto_increment,
  874. `pirepid` int(11) NOT NULL,
  875. `pilotid` int(11) NOT NULL,
  876. `comment` text NOT NULL,
  877. `postdate` datetime NOT NULL,
  878. PRIMARY KEY (`id`),
  879. KEY `phpvms_pirepcomments_ibfk_1` (`pirepid`)
  880. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  881.  
  882. --
  883. -- Dumping data for table `phpvms_pirepcomments`
  884. --
  885.  
  886.  
  887. -- --------------------------------------------------------
  888.  
  889. --
  890. -- Table structure for table `phpvms_pirepfields`
  891. --
  892.  
  893. CREATE TABLE IF NOT EXISTS `phpvms_pirepfields` (
  894. `fieldid` int(11) NOT NULL auto_increment,
  895. `title` varchar(25) NOT NULL,
  896. `name` varchar(25) NOT NULL,
  897. `type` varchar(25) NOT NULL,
  898. `options` text NOT NULL,
  899. PRIMARY KEY (`fieldid`),
  900. UNIQUE KEY `name` (`name`)
  901. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  902.  
  903. --
  904. -- Dumping data for table `phpvms_pirepfields`
  905. --
  906.  
  907.  
  908. -- --------------------------------------------------------
  909.  
  910. --
  911. -- Table structure for table `phpvms_pireps`
  912. --
  913.  
  914. CREATE TABLE IF NOT EXISTS `phpvms_pireps` (
  915. `pirepid` int(11) NOT NULL auto_increment,
  916. `pilotid` int(11) NOT NULL default '0',
  917. `code` char(3) NOT NULL default '',
  918. `flightnum` varchar(10) NOT NULL default '0',
  919. `depicao` varchar(4) NOT NULL default '',
  920. `arricao` varchar(4) NOT NULL default '',
  921. `route` text NOT NULL,
  922. `route_details` text NOT NULL,
  923. `aircraft` varchar(12) NOT NULL default '',
  924. `flighttime` varchar(10) NOT NULL default '',
  925. `flighttime_stamp` time NOT NULL,
  926. `distance` smallint(6) NOT NULL default '0',
  927. `landingrate` float NOT NULL default '0',
  928. `submitdate` datetime NOT NULL default '0000-00-00 00:00:00',
  929. `accepted` smallint(6) NOT NULL default '0',
  930. `log` text NOT NULL,
  931. `load` int(11) NOT NULL,
  932. `fuelused` float NOT NULL default '0',
  933. `fuelunitcost` float NOT NULL default '0',
  934. `fuelprice` float NOT NULL default '5.1',
  935. `price` float NOT NULL,
  936. `flighttype` varchar(1) NOT NULL default 'P',
  937. `gross` float NOT NULL,
  938. `pilotpay` float NOT NULL,
  939. `expenses` float NOT NULL,
  940. `expenselist` blob NOT NULL,
  941. `revenue` float NOT NULL,
  942. `source` varchar(25) NOT NULL,
  943. `exported` tinyint(4) NOT NULL,
  944. `rawdata` text NOT NULL,
  945. PRIMARY KEY (`pirepid`)
  946. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  947.  
  948. --
  949. -- Dumping data for table `phpvms_pireps`
  950. --
  951.  
  952.  
  953. -- --------------------------------------------------------
  954.  
  955. --
  956. -- Table structure for table `phpvms_pirepvalues`
  957. --
  958.  
  959. CREATE TABLE IF NOT EXISTS `phpvms_pirepvalues` (
  960. `id` int(11) NOT NULL auto_increment,
  961. `fieldid` int(11) NOT NULL,
  962. `pirepid` int(11) NOT NULL,
  963. `value` text NOT NULL,
  964. PRIMARY KEY (`id`)
  965. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  966.  
  967. --
  968. -- Dumping data for table `phpvms_pirepvalues`
  969. --
  970.  
  971.  
  972. -- --------------------------------------------------------
  973.  
  974. --
  975. -- Table structure for table `phpvms_ranks`
  976. --
  977.  
  978. CREATE TABLE IF NOT EXISTS `phpvms_ranks` (
  979. `rankid` int(11) NOT NULL auto_increment,
  980. `rank` varchar(32) NOT NULL default '',
  981. `rankimage` text NOT NULL,
  982. `minhours` smallint(6) NOT NULL default '0',
  983. `payrate` float NOT NULL default '0',
  984. PRIMARY KEY (`rankid`),
  985. UNIQUE KEY `rank` (`rank`)
  986. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  987.  
  988. --
  989. -- Dumping data for table `phpvms_ranks`
  990. --
  991.  
  992. INSERT INTO `phpvms_ranks` (`rankid`, `rank`, `rankimage`, `minhours`, `payrate`) VALUES
  993. (1, 'ATPL', 'http://www.cargoitaliavirtual.com/lib/images/ranks/cadet.jpg', 0, 40),
  994. (2, '2nd Officer', 'http://www.cargoitaliavirtual.com/lib/images/ranks/2nd officer.jpg', 50, 65),
  995. (3, '1st Officer', 'http://www.cargoitaliavirtual.com/lib/images/ranks/1st officer.jpg', 200, 120),
  996. (4, 'Captain', 'http://www.cargoitaliavirtual.com/lib/images/ranks/captain.jpg', 500, 160),
  997. (5, 'Senior Captain', 'http://www.cargoitaliavirtual.com/lib/images/ranks/senior captain.jpg', 1000, 200);
  998.  
  999. -- --------------------------------------------------------
  1000.  
  1001. --
  1002. -- Table structure for table `phpvms_schedules`
  1003. --
  1004.  
  1005. CREATE TABLE IF NOT EXISTS `phpvms_schedules` (
  1006. `id` int(11) NOT NULL auto_increment,
  1007. `code` char(3) NOT NULL default '',
  1008. `flightnum` varchar(10) NOT NULL default '0',
  1009. `depicao` varchar(4) NOT NULL default '',
  1010. `arricao` varchar(4) NOT NULL default '',
  1011. `route` text NOT NULL,
  1012. `route_details` text NOT NULL,
  1013. `aircraft` text NOT NULL,
  1014. `flightlevel` varchar(6) NOT NULL,
  1015. `distance` float NOT NULL default '0',
  1016. `deptime` varchar(15) NOT NULL default '',
  1017. `arrtime` varchar(15) NOT NULL default '',
  1018. `flighttime` float NOT NULL default '0',
  1019. `daysofweek` varchar(7) NOT NULL default '0123456',
  1020. `price` float NOT NULL,
  1021. `flighttype` varchar(1) NOT NULL default 'P',
  1022. `timesflown` int(11) NOT NULL default '0',
  1023. `notes` text NOT NULL,
  1024. `enabled` int(11) NOT NULL default '1',
  1025. `bidid` int(11) NOT NULL default '0',
  1026. PRIMARY KEY (`id`),
  1027. KEY `depicao` (`depicao`),
  1028. KEY `flightnum` (`flightnum`),
  1029. KEY `depicao_arricao` (`depicao`,`arricao`),
  1030. KEY `code` (`code`)
  1031. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
  1032.  
  1033. --
  1034. -- Dumping data for table `phpvms_schedules`
  1035. --
  1036.  
  1037. INSERT INTO `phpvms_schedules` (`id`, `code`, `flightnum`, `depicao`, `arricao`, `route`, `route_details`, `aircraft`, `flightlevel`, `distance`, `deptime`, `arrtime`, `flighttime`, `daysofweek`, `price`, `flighttype`, `timesflown`, `notes`, `enabled`, `bidid`) VALUES
  1038. (1, 'CRG', '641', 'LIMC', 'EDDH', 'ABESI UN851 KEMAD UL190 NOLGO', 'a:0:{}', '1', '34000', 490, '10:00', '11:35', 1.35, '0135', 0, 'C', 0, '', 1, 0),
  1039. (2, 'CRG', '653', 'LIMC', 'EDDH', 'ABESI UN851 KEMAD UL190 NOLGO', 'a:0:{}', '2', '34000', 490, '22:00', '23:35', 1.35, '0135', 0, 'C', 0, '', 1, 0),
  1040. (3, 'CRG', '656', 'LIMC', 'EDDH', 'ABESI UN851 KEMAD UL190 NOLGO', 'a:0:{}', '1', '34000', 490, '01:30', '03:05', 1.35, '246', 0, 'C', 0, '', 1, 0),
  1041. (4, 'CRG', '669', 'LIMC', 'EDDH', 'ABESI UN851 KEMAD UL190 NOLGO', 'a:0:{}', '2', '34000', 490, '13:30', '15:05', 1.35, '246', 0, 'C', 0, '', 1, 0),
  1042. (5, 'CRG', '632', 'LIMC', 'EDDT', 'ABESI UN851 LOHRE UN746 ROBEL T200 RUDAK', 'a:0:{}', '1', '34000', 491, '01:00', '02:35', 1.35, '0135', 0, 'C', 0, '', 1, 0),
  1043. (6, 'CRG', '644', 'LIMC', 'EDDT', 'ABESI UN851 LOHRE UN746 ROBEL T200 RUDAK', 'a:0:{}', '2', '34000', 491, '13:00', '14:35', 1.35, '0135', 0, 'C', 0, '', 1, 0),
  1044. (7, 'CRG', '665', 'LIMC', 'EDDT', 'ABESI UN851 LOHRE UN746 ROBEL T200 RUDAK', 'a:0:{}', '1', '34000', 491, '10:30', '12:05', 1.35, '246', 0, 'C', 0, '', 1, 0),
  1045. (8, 'CRG', '678', 'LIMC', 'EDDT', 'ABESI UN851 LOHRE UN746 ROBEL T200 RUDAK', 'a:0:{}', '2', '34000', 491, '22:30', '00:05', 1.35, '246', 0, 'C', 0, '', 1, 0),
  1046. (9, 'CRG', '635', 'LIMC', 'EGBB', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '1', '36000', 601, '04:00', '05:50', 1.5, '0135', 0, 'C', 0, '', 1, 0),
  1047. (10, 'CRG', '647', 'LIMC', 'EGBB', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '2', '36000', 601, '16:00', '17:50', 1.5, '0135', 0, 'C', 0, '', 1, 0),
  1048. (11, 'CRG', '662', 'LIMC', 'EGBB', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '1', '36000', 601, '07:30', '09:20', 1.5, '246', 0, 'C', 0, '', 1, 0),
  1049. (12, 'CRG', '675', 'LIMC', 'EGBB', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '2', '36000', 601, '19:30', '21:20', 1.5, '246', 0, 'C', 0, '', 1, 0),
  1050. (13, 'CRG', '640', 'LIMC', 'EGLL', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '1', '34000', 528, '09:00', '10:40', 1.4, '0135', 0, 'C', 0, '', 1, 0),
  1051. (14, 'CRG', '652', 'LIMC', 'EGLL', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '2', '34000', 528, '21:00', '22:40', 1.4, '0135', 0, 'C', 0, '', 1, 0),
  1052. (15, 'CRG', '657', 'LIMC', 'EGLL', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '1', '34000', 528, '02:30', '04:10', 1.4, '246', 0, 'C', 0, '', 1, 0),
  1053. (16, 'CRG', '670', 'LIMC', 'EGLL', 'AOSTA UL615 ORSUD UM729 DJL UH37 BRY UM733 KOPOR UT426 DIMAL UT420 BUZAD', 'a:0:{}', '2', '34000', 528, '14:30', '16:10', 1.4, '246', 0, 'C', 0, '', 1, 0),
  1054. (17, 'CRG', '631', 'LIMC', 'ESSA', 'ABESI UN851 TRS', 'a:0:{}', '1', '35000', 925, '00:00', '02:33', 2.33, '0135', 0, 'C', 0, '', 1, 0),
  1055. (18, 'CRG', '643', 'LIMC', 'ESSA', 'ABESI UN851 TRS', 'a:0:{}', '2', '35000', 925, '12:00', '14:33', 2.33, '0135', 0, 'C', 0, '', 1, 0),
  1056. (19, 'CRG', '667', 'LIMC', 'ESSA', 'ABESI UN851 TRS', 'a:0:{}', '1', '35000', 925, '11:30', '14:03', 2.33, '246', 0, 'C', 0, '', 1, 0),
  1057. (20, 'CRG', '679', 'LIMC', 'ESSA', 'ABESI UN851 TRS', 'a:0:{}', '2', '35000', 925, '23:30', '02:03', 2.33, '246', 0, 'C', 0, '', 1, 0),
  1058. (21, 'CRG', '637', 'LIMC', 'KBOS', 'AOSTA UM729 DJL UH10 AMODO UM729 RESMI UL851 LGL UN502 JSY UN160 LIZAD UL739 GAPLI DCT GIPER DCT DINIM 5020N 4830N 4640N 4450N BOBTU JAROM N48E KANNI SCUPP', 'a:0:{}', '1', '36000', 3420, '06:00', '14:06', 8.06, '0135', 0, 'C', 0, '', 1, 0),
  1059. (22, 'CRG', '649', 'LIMC', 'KBOS', 'AOSTA UM729 DJL UH10 AMODO UM729 RESMI UL851 LGL UN502 JSY UN160 LIZAD UL739 GAPLI DCT GIPER DCT DINIM 5020N 4830N 4640N 4450N BOBTU JAROM N48E KANNI SCUPP', 'a:0:{}', '2', '36000', 3420, '18:00', '02:06', 8.06, '0135', 0, 'C', 0, '', 1, 0),
  1060. (23, 'CRG', '660', 'LIMC', 'KBOS', 'AOSTA UM729 DJL UH10 AMODO UM729 RESMI UL851 LGL UN502 JSY UN160 LIZAD UL739 GAPLI DCT GIPER DCT DINIM 5020N 4830N 4640N 4450N BOBTU JAROM N48E KANNI SCUPP', 'a:0:{}', '1', '36000', 3420, '05:30', '13:36', 8.06, '246', 0, 'C', 0, '', 1, 0),
  1061. (24, 'CRG', '673', 'LIMC', 'KBOS', 'AOSTA UM729 DJL UH10 AMODO UM729 RESMI UL851 LGL UN502 JSY UN160 LIZAD UL739 GAPLI DCT GIPER DCT DINIM 5020N 4830N 4640N 4450N BOBTU JAROM N48E KANNI SCUPP', 'a:0:{}', '2', '36000', 3420, '17:30', '01:36', 8.06, '246', 0, 'C', 0, '', 1, 0),
  1062. (25, 'CRG', '638', 'LIMC', 'LEIB', 'NEDED UM984 DIVKO UN852 VERSO UL129 POS', 'a:0:{}', '1', '32000', 548, '07:00', '08:43', 1.43, '0135', 0, 'C', 0, '', 1, 0),
  1063. (26, 'CRG', '650', 'LIMC', 'LEIB', 'NEDED UM984 DIVKO UN852 VERSO UL129 POS', 'a:0:{}', '2', '32000', 548, '19:00', '20:43', 1.43, '0135', 0, 'C', 0, '', 1, 0),
  1064. (27, 'CRG', '659', 'LIMC', 'LEIB', 'NEDED UM984 DIVKO UN852 VERSO UL129 POS', 'a:0:{}', '1', '32000', 548, '04:30', '06:13', 1.43, '246', 0, 'C', 0, '', 1, 0),
  1065. (28, 'CRG', '672', 'LIMC', 'LEIB', 'NEDED UM984 DIVKO UN852 VERSO UL129 POS', 'a:0:{}', '2', '32000', 548, '16:30', '18:13', 1.43, '246', 0, 'C', 0, '', 1, 0),
  1066. (29, 'CRG', '633', 'LIMC', 'GMML', 'NEDED UM984 DIVKO UN975 BCN UM985 PIMOS UN869 ADM UA600 SOLNA ', 'a:0:{}', '1', '36000', 1549, '02:00', '05:56', 3.56, '0135', 0, 'C', 0, '', 1, 0),
  1067. (30, 'CRG', '645', 'LIMC', 'GMML', 'NEDED UM984 DIVKO UN975 BCN UM985 PIMOS UN869 ADM UA600 SOLNA', 'a:0:{}', '2', '36000', 1548, '14:00', '17:56', 3.56, '0135', 0, 'C', 0, '', 1, 0),
  1068. (31, 'CRG', '664', 'LIMC', 'GMML', 'NEDED UM984 DIVKO UN975 BCN UM985 PIMOS UN869 ADM UA600 SOLNA ', 'a:0:{}', '1', '36000', 1548, '09.30', '13:26', 3.56, '246', 0, 'C', 0, '', 1, 0),
  1069. (32, 'CRG', '677', 'LIMC', 'GMML', 'NEDED UM984 DIVKO UN975 BCN UM985 PIMOS UN869 ADM UA600 SOLNA', 'a:0:{}', '2', '36000', 1548, '21:30', '01:26', 3.56, '246', 0, 'C', 0, '', 1, 0),
  1070. (33, 'CRG', '636', 'LIMC', 'LFRS', 'TOP UP860 RUSIT UY105 LERGA UT183 MANAK', 'a:0:{}', '1', '32000', 512, '05:00', '06:38', 1.38, '0135', 0, 'C', 0, '', 1, 0),
  1071. (34, 'CRG', '648', 'LIMC', 'LFRS', 'TOP UP860 RUSIT UY105 LERGA UT183 MANAK', 'a:0:{}', '2', '32000', 512, '17:00', '18:38', 1.38, '0135', 0, 'C', 0, '', 1, 0),
  1072. (35, 'CRG', '661', 'LIMC', 'LFRS', 'TOP UP860 RUSIT UY105 LERGA UT183 MANAK', 'a:0:{}', '1', '32000', 512, '06:30', '08:08', 1.38, '245', 0, 'C', 0, '', 1, 0),
  1073. (36, 'CRG', '674', 'LIMC', 'LFRS', 'TOP UP860 RUSIT UY105 LERGA UT183 MANAK', 'a:0:{}', '2', '32000', 512, '18:30', '20:08', 1.38, '246', 0, 'C', 0, '', 1, 0),
  1074. (37, 'CRG', '639', 'LIMC', 'LPPR', 'AOSTA UZ637 MILPA UN869 AGN UL866 PPN UN976 DGO UN725 TUSBA UH80 ASPOR ', 'a:0:{}', '1', '34000', 874, '08:00', '10:26', 2.26, '0135', 0, 'C', 0, '', 1, 0),
  1075. (38, 'CRG', '651', 'LIMC', 'LPPR', 'AOSTA UZ637 MILPA UN869 AGN UL866 PPN UN976 DGO UN725 TUSBA UH80 ASPOR', 'a:0:{}', '2', '34000', 874, '20:00', '22:26', 2.26, '0135', 0, 'C', 0, '', 1, 0),
  1076. (39, 'CRG', '658', 'LIMC', 'LPPR', 'AOSTA UZ637 MILPA UN869 AGN UL866 PPN UN976 DGO UN725 TUSBA UH80 ASPOR ', 'a:0:{}', '1', '34000', 874, '03:30', '05:56', 2.26, '246', 0, 'C', 0, '', 1, 0),
  1077. (40, 'CRG', '671', 'LIMC', 'LPPR', 'AOSTA UZ637 MILPA UN869 AGN UL866 PPN UN976 DGO UN725 TUSBA UH80 ASPOR', 'a:0:{}', '2', '34000', 874, '15:30', '17:56', 2.26, '246', 0, 'C', 0, '', 1, 0),
  1078. (41, 'CRG', '634', 'LIMC', 'LPPT', 'NEDED UM984 DIVKO UN975 ELVAR/N0400FL240 UN975 ESP', 'a:0:{}', '1', '36000', 973, '03:00', '05:39', 2.39, '0135', 0, 'C', 0, '', 1, 0),
  1079. (42, 'CRG', '646', 'LIMC', 'LPPT', 'NEDED UM984 DIVKO UN975 ELVAR/N0400FL240 UN975 ESP', 'a:0:{}', '2', '36000', 973, '15:00', '17:39', 2.39, '0135', 0, 'C', 0, '', 1, 0),
  1080. (43, 'CRG', '663', 'LIMC', 'LPPT', 'NEDED UM984 DIVKO UN975 ELVAR/N0400FL240 UN975 ESP', 'a:0:{}', '1', '36000', 973, '08:30', '11:09', 2.39, '246', 0, 'C', 0, '', 1, 0),
  1081. (44, 'CRG', '676', 'LIMC', 'LPPT', 'NEDED UM984 DIVKO UN975 ELVAR/N0400FL240 UN975 ESP', 'a:0:{}', '2', '36000', 973, '20:30', '23:09', 2.39, '246', 0, 'C', 0, '', 1, 0),
  1082. (45, 'CRG', '642', 'LIMC', 'OMDB', 'N0486F350 DCT VAKON UQ702 CHI/N0486F370 UL614 SONIK/N0485F370 UL614 TORTO/N0483F370 UL614 SRT UR21 KABAN/N0481F370 R784 EMIDO DCT VUSEB UT888 KATUT UP975 AD R784 IMDAT B416 ORSAR G666 ITITA A791 DESDI DCT', 'a:0:{}', '1', '35000', 2619, '11:00', '17:19', 6.19, '0135', 0, 'C', 0, '', 1, 0),
  1083. (46, 'CRG', '654', 'LIMC', 'OMDB', 'N0486F350 DCT VAKON UQ702 CHI/N0486F370 UL614 SONIK/N0485F370 UL614 TORTO/N0483F370 UL614 SRT UR21 KABAN/N0481F370 R784 EMIDO DCT VUSEB UT888 KATUT UP975 AD R784 IMDAT B416 ORSAR G666 ITITA A791 DESDI DCT', 'a:0:{}', '2', '35000', 2619, '23:00', '05:19', 6.19, '0135', 0, 'C', 0, '', 1, 0),
  1084. (47, 'CRG', '655', 'LIMC', 'OMDB', 'N0486F350 DCT VAKON UQ702 CHI/N0486F370 UL614 SONIK/N0485F370 UL614 TORTO/N0483F370 UL614 SRT UR21 KABAN/N0481F370 R784 EMIDO DCT VUSEB UT888 KATUT UP975 AD R784 IMDAT B416 ORSAR G666 ITITA A791 DESDI DCT', 'a:0:{}', '1', '35000', 2619, '00:30', '06:49', 6.19, '246', 0, 'C', 0, '', 1, 0),
  1085. (48, 'CRG', '668', 'LIMC', 'OMDB', 'N0486F350 DCT VAKON UQ702 CHI/N0486F370 UL614 SONIK/N0485F370 UL614 TORTO/N0483F370 UL614 SRT UR21 KABAN/N0481F370 R784 EMIDO DCT VUSEB UT888 KATUT UP975 AD R784 IMDAT B416 ORSAR G666 ITITA A791 DESDI DCT', 'a:0:{}', '2', '35000', 2619, '12:30', '18:49', 6.19, '246', 0, 'C', 0, '', 1, 0);
  1086.  
  1087. -- --------------------------------------------------------
  1088.  
  1089. --
  1090. -- Table structure for table `phpvms_sessions`
  1091. --
  1092.  
  1093. CREATE TABLE IF NOT EXISTS `phpvms_sessions` (
  1094. `id` int(11) NOT NULL auto_increment,
  1095. `pilotid` int(11) NOT NULL,
  1096. `ipaddress` varchar(25) NOT NULL,
  1097. `logintime` datetime NOT NULL,
  1098. PRIMARY KEY (`id`)
  1099. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=144 ;
  1100.  
  1101. --
  1102. -- Dumping data for table `phpvms_sessions`
  1103. --
  1104.  
  1105. INSERT INTO `phpvms_sessions` (`id`, `pilotid`, `ipaddress`, `logintime`) VALUES
  1106. (1, 1001, '87.8.79.53', '2010-05-19 23:52:29'),
  1107. (2, 0, '151.61.54.234', '2010-05-20 00:06:29'),
  1108. (3, 1002, '93.48.153.207', '2010-05-20 09:39:10'),
  1109. (5, 0, '93.34.153.69', '2010-05-20 00:08:53'),
  1110. (4, 0, '87.8.79.53', '2010-05-20 01:01:03'),
  1111. (6, 1001, '87.8.79.53', '2010-05-20 01:19:48'),
  1112. (7, 0, '93.48.154.53', '2010-05-20 01:22:47'),
  1113. (8, 1002, '93.48.157.116', '2010-05-21 10:48:40'),
  1114. (9, 0, '93.48.156.172', '2010-05-20 11:31:38'),
  1115. (10, 0, '87.4.76.24', '2010-05-20 15:38:42'),
  1116. (11, 0, '93.48.153.207', '2010-05-20 14:04:19'),
  1117. (15, 0, '93.35.145.150', '2010-05-20 20:21:45'),
  1118. (12, 0, '93.34.171.194', '2010-05-20 12:41:25'),
  1119. (13, 0, '151.61.52.13', '2010-05-20 12:56:32'),
  1120. (14, 0, '87.0.157.226', '2010-05-20 13:53:17'),
  1121. (16, 0, '79.19.181.206', '2010-05-20 14:05:37'),
  1122. (17, 0, '87.4.76.24', '2010-05-21 01:19:16'),
  1123. (63, 0, '87.4.87.23', '2010-05-21 19:27:08'),
  1124. (18, 0, '79.18.252.25', '2010-05-20 19:00:40'),
  1125. (19, 0, '93.48.148.88', '2010-05-21 09:14:46'),
  1126. (65, 0, '93.48.148.88', '2010-05-21 09:14:46'),
  1127. (20, 0, '93.38.226.229', '2010-05-20 21:06:52'),
  1128. (21, 0, '87.4.76.24', '2010-05-20 21:07:37'),
  1129. (22, 0, '87.4.76.24', '2010-05-20 21:07:38'),
  1130. (23, 0, '87.4.76.24', '2010-05-20 21:08:27'),
  1131. (24, 0, '87.4.76.24', '2010-05-20 21:08:28'),
  1132. (25, 0, '87.4.76.24', '2010-05-20 21:10:38'),
  1133. (26, 0, '87.4.76.24', '2010-05-20 21:10:38'),
  1134. (27, 0, '87.4.76.24', '2010-05-20 21:11:05'),
  1135. (28, 0, '87.4.76.24', '2010-05-20 21:11:05'),
  1136. (29, 0, '87.4.76.24', '2010-05-20 21:11:23'),
  1137. (30, 0, '87.4.76.24', '2010-05-20 21:11:23'),
  1138. (31, 0, '87.4.76.24', '2010-05-20 21:11:53'),
  1139. (32, 0, '87.4.76.24', '2010-05-20 21:11:53'),
  1140. (33, 0, '87.4.76.24', '2010-05-20 21:12:40'),
  1141. (34, 0, '87.4.76.24', '2010-05-20 21:13:05'),
  1142. (35, 0, '87.4.76.24', '2010-05-20 21:13:05'),
  1143. (36, 0, '87.4.76.24', '2010-05-20 21:18:09'),
  1144. (37, 0, '87.4.76.24', '2010-05-20 21:18:09'),
  1145. (38, 0, '87.4.76.24', '2010-05-20 21:20:12'),
  1146. (39, 0, '87.4.76.24', '2010-05-20 21:20:13'),
  1147. (40, 0, '87.4.76.24', '2010-05-20 21:20:49'),
  1148. (41, 0, '87.4.76.24', '2010-05-20 21:20:49'),
  1149. (42, 0, '87.4.76.24', '2010-05-20 22:21:23'),
  1150. (43, 0, '87.4.76.24', '2010-05-20 22:21:23'),
  1151. (44, 0, '87.4.76.24', '2010-05-20 22:22:15'),
  1152. (45, 0, '87.4.76.24', '2010-05-20 22:22:15'),
  1153. (46, 0, '87.4.76.24', '2010-05-20 22:22:24'),
  1154. (47, 0, '87.4.76.24', '2010-05-20 22:22:25'),
  1155. (48, 0, '87.2.135.165', '2010-05-20 22:57:41'),
  1156. (49, 0, '87.2.135.165', '2010-05-20 23:36:29'),
  1157. (50, 0, '87.4.76.24', '2010-05-21 01:05:56'),
  1158. (51, 0, '87.4.76.24', '2010-05-21 01:06:08'),
  1159. (52, 0, '87.4.76.24', '2010-05-21 01:06:33'),
  1160. (53, 0, '87.4.76.24', '2010-05-21 01:06:33'),
  1161. (54, 0, '87.4.76.24', '2010-05-21 01:07:25'),
  1162. (55, 0, '87.4.76.24', '2010-05-21 01:07:26'),
  1163. (56, 0, '87.4.76.24', '2010-05-21 01:09:00'),
  1164. (57, 0, '87.4.76.24', '2010-05-21 01:09:00'),
  1165. (58, 0, '87.4.76.24', '2010-05-21 01:11:00'),
  1166. (59, 0, '87.4.76.24', '2010-05-21 01:11:23'),
  1167. (60, 0, '87.4.76.24', '2010-05-21 01:11:23'),
  1168. (61, 0, '87.4.76.24', '2010-05-21 01:12:52'),
  1169. (62, 0, '87.4.76.24', '2010-05-21 01:12:52'),
  1170. (64, 0, '151.66.103.117', '2010-05-21 01:37:27'),
  1171. (66, 0, '93.36.116.208', '2010-05-21 14:17:12'),
  1172. (67, 0, '93.48.158.61', '2010-05-21 21:05:48'),
  1173. (68, 0, '82.52.57.36', '2010-05-21 15:41:10'),
  1174. (69, 0, '93.66.15.148', '2010-05-21 16:55:22'),
  1175. (70, 0, '87.4.87.23', '2010-05-21 21:07:35'),
  1176. (85, 0, '87.4.87.23', '2010-05-21 22:36:44'),
  1177. (77, 0, '87.4.87.23', '2010-05-21 21:05:23'),
  1178. (71, 0, '87.4.87.23', '2010-05-21 18:45:40'),
  1179. (72, 0, '87.4.87.23', '2010-05-21 18:45:40'),
  1180. (73, 0, '87.4.87.23', '2010-05-21 18:54:01'),
  1181. (74, 0, '87.4.87.23', '2010-05-21 18:54:01'),
  1182. (75, 0, '87.4.87.23', '2010-05-21 18:54:14'),
  1183. (76, 0, '87.4.87.23', '2010-05-21 18:54:14'),
  1184. (84, 0, '93.48.150.37', '2010-05-22 12:34:38'),
  1185. (83, 0, '87.4.87.23', '2010-05-21 21:05:23'),
  1186. (78, 0, '82.52.95.235', '2010-05-21 20:10:49'),
  1187. (79, 0, '82.52.73.99', '2010-05-21 20:34:43'),
  1188. (80, 0, '87.0.142.50', '2010-05-21 21:11:56'),
  1189. (81, 0, '87.4.87.23', '2010-05-21 20:50:34'),
  1190. (82, 0, '87.4.87.23', '2010-05-21 20:50:34'),
  1191. (115, 0, '93.48.150.37', '2010-05-22 17:51:58'),
  1192. (86, 0, '87.0.142.50', '2010-05-21 21:16:02'),
  1193. (87, 0, '87.0.142.50', '2010-05-21 21:18:34'),
  1194. (88, 0, '87.4.87.23', '2010-05-21 21:39:34'),
  1195. (89, 0, '87.4.87.23', '2010-05-21 21:50:07'),
  1196. (90, 0, '82.60.64.137', '2010-05-21 22:14:13'),
  1197. (91, 0, '87.2.90.7', '2010-05-21 22:13:10'),
  1198. (92, 0, '87.4.84.104', '2010-05-22 08:53:35'),
  1199. (101, 0, '87.4.84.104', '2010-05-22 09:30:34'),
  1200. (93, 0, '87.4.87.23', '2010-05-21 22:36:45'),
  1201. (94, 0, '87.4.87.23', '2010-05-21 22:37:56'),
  1202. (95, 0, '204.236.253.88', '2010-05-22 00:40:45'),
  1203. (96, 0, '204.236.253.88', '2010-05-22 00:41:05'),
  1204. (97, 0, '204.236.253.88', '2010-05-22 00:41:06'),
  1205. (98, 0, '204.236.253.88', '2010-05-22 00:41:06'),
  1206. (99, 0, '93.48.158.61', '2010-05-22 01:08:32'),
  1207. (100, 0, '93.48.158.61', '2010-05-22 01:32:11'),
  1208. (102, 0, '66.249.65.99', '2010-05-22 09:01:24'),
  1209. (103, 0, '87.4.84.250', '2010-05-22 09:11:39'),
  1210. (104, 0, '87.4.84.104', '2010-05-22 09:30:54'),
  1211. (105, 0, '87.4.84.104', '2010-05-23 00:43:11'),
  1212. (106, 0, '66.249.65.99', '2010-05-22 10:43:09'),
  1213. (107, 0, '66.249.65.99', '2010-05-22 10:44:46'),
  1214. (108, 0, '66.249.65.99', '2010-05-22 10:47:07'),
  1215. (109, 0, '66.249.65.99', '2010-05-22 10:51:26'),
  1216. (110, 0, '66.249.65.99', '2010-05-22 10:53:36'),
  1217. (111, 0, '66.249.65.99', '2010-05-22 10:55:57'),
  1218. (112, 0, '66.249.65.99', '2010-05-22 11:01:00'),
  1219. (113, 0, '66.249.65.99', '2010-05-22 11:05:51'),
  1220. (114, 0, '66.249.65.99', '2010-05-22 11:10:57'),
  1221. (131, 1002, '93.48.150.37', '2010-05-23 02:05:21'),
  1222. (116, 0, '87.4.84.250', '2010-05-22 12:54:21'),
  1223. (117, 0, '93.48.150.37', '2010-05-22 12:46:42'),
  1224. (118, 0, '66.249.65.121', '2010-05-22 13:00:29'),
  1225. (119, 0, '66.249.65.121', '2010-05-22 13:00:29'),
  1226. (120, 0, '66.249.65.121', '2010-05-22 13:10:30'),
  1227. (121, 0, '82.52.94.99', '2010-05-22 14:12:15'),
  1228. (122, 0, '87.9.10.72', '2010-05-22 14:39:19'),
  1229. (123, 0, '67.195.37.179', '2010-05-22 14:54:41'),
  1230. (124, 0, '66.249.65.121', '2010-05-22 14:58:22'),
  1231. (125, 0, '66.249.65.121', '2010-05-22 15:00:25'),
  1232. (126, 0, '66.249.65.121', '2010-05-22 15:08:38'),
  1233. (127, 0, '84.253.160.213', '2010-05-22 15:15:06'),
  1234. (128, 0, '74.125.16.3', '2010-05-22 15:14:39'),
  1235. (129, 0, '74.125.16.3', '2010-05-22 15:14:51'),
  1236. (130, 0, '67.195.37.179', '2010-05-22 15:20:17'),
  1237. (132, 0, '82.60.3.52', '2010-05-22 19:50:42'),
  1238. (133, 0, '67.195.37.179', '2010-05-22 20:02:01'),
  1239. (134, 0, '67.195.37.179', '2010-05-22 20:46:23'),
  1240. (135, 0, '67.195.37.179', '2010-05-23 00:04:44'),
  1241. (136, 0, '67.195.37.179', '2010-05-23 00:07:12'),
  1242. (137, 0, '87.4.84.250', '2010-05-23 01:19:27'),
  1243. (138, 0, '87.4.84.104', '2010-05-23 00:43:12'),
  1244. (139, 0, '87.4.84.104', '2010-05-23 00:44:47'),
  1245. (140, 0, '87.4.84.104', '2010-05-23 01:39:02'),
  1246. (141, 0, '87.4.84.250', '2010-05-23 02:02:56'),
  1247. (142, 1001, '87.4.84.104', '2010-05-23 02:06:00'),
  1248. (143, 0, '87.4.84.250', '2010-05-23 02:02:57');
  1249.  
  1250. -- --------------------------------------------------------
  1251.  
  1252. --
  1253. -- Table structure for table `phpvms_settings`
  1254. --
  1255.  
  1256. CREATE TABLE IF NOT EXISTS `phpvms_settings` (
  1257. `id` int(11) NOT NULL auto_increment,
  1258. `friendlyname` varchar(25) NOT NULL default '',
  1259. `name` varchar(25) NOT NULL default '',
  1260. `value` varchar(150) NOT NULL default '',
  1261. `descrip` varchar(150) NOT NULL default '',
  1262. `core` smallint(6) NOT NULL default '1',
  1263. PRIMARY KEY (`id`),
  1264. UNIQUE KEY `name` (`name`)
  1265. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
  1266.  
  1267. --
  1268. -- Dumping data for table `phpvms_settings`
  1269. --
  1270.  
  1271. INSERT INTO `phpvms_settings` (`id`, `friendlyname`, `name`, `value`, `descrip`, `core`) VALUES
  1272. (1, 'Virtual Airline Name', 'SITE_NAME', 'Cargoitalia Virtual', 'The name of your site. This will show up in the browser title bar.', 1),
  1273. (2, 'Webmaster Email Address', 'ADMIN_EMAIL', '[email protected]', 'This is the email address that email will get sent to/from', 1),
  1274. (3, 'Date Format', 'DATE_FORMAT', 'd/m/Y', 'This is the date format to be used around the site.', 1),
  1275. (4, 'Current Skin', 'CURRENT_SKIN', 'ObsessBlue', 'Available skins', 1),
  1276. (5, 'Default User Group', 'DEFAULT_GROUP', '2', 'This is the default group if they are not explicitly denied', 1),
  1277. (6, 'Total VA Hours', 'TOTAL_HOURS', '0', 'Your total hours', 0);
  1278.  
  1279. -- --------------------------------------------------------
  1280.  
  1281. --
  1282. -- Table structure for table `phpvms_updates`
  1283. --
  1284.  
  1285. CREATE TABLE IF NOT EXISTS `phpvms_updates` (
  1286. `id` int(11) NOT NULL auto_increment,
  1287. `name` varchar(25) NOT NULL,
  1288. `lastupdate` datetime NOT NULL,
  1289. PRIMARY KEY (`id`),
  1290. KEY `name` (`name`)
  1291. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  1292.  
  1293. --
  1294. -- Dumping data for table `phpvms_updates`
  1295. --
  1296.  
  1297.  
  1298. -- --------------------------------------------------------
  1299.  
  1300. --
  1301. -- Table structure for table `user_profile`
  1302. --
  1303.  
  1304. CREATE TABLE IF NOT EXISTS `user_profile` (
  1305. `id` int(16) unsigned NOT NULL auto_increment,
  1306. `UserName` varchar(22) NOT NULL default '',
  1307. `Password` varchar(22) NOT NULL default '',
  1308. `Email` varchar(40) NOT NULL default '',
  1309. PRIMARY KEY (`id`),
  1310. KEY `UserName` (`UserName`)
  1311. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  1312.  
  1313. --
  1314. -- Dumping data for table `user_profile`
  1315. --
  1316.  
  1317. INSERT INTO `user_profile` (`id`, `UserName`, `Password`, `Email`) VALUES
  1318. (1, 'CRG1002', 'crgmaio', '');
  1319.  
  1320. --
  1321. -- Constraints for dumped tables
  1322. --
  1323.  
  1324. --
  1325. -- Constraints for table `phpvms_fieldvalues`
  1326. --
  1327. ALTER TABLE `phpvms_fieldvalues`
  1328. ADD CONSTRAINT `phpvms_fieldvalues_ibfk_1` FOREIGN KEY (`fieldid`) REFERENCES `phpvms_customfields` (`fieldid`) ON DELETE CASCADE,
  1329. ADD CONSTRAINT `phpvms_fieldvalues_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_pilots` (`pilotid`) ON DELETE CASCADE;
  1330.  
  1331. --
  1332. -- Constraints for table `phpvms_groupmembers`
  1333. --
  1334. ALTER TABLE `phpvms_groupmembers`
  1335. ADD CONSTRAINT `phpvms_groupmembers_ibfk_1` FOREIGN KEY (`groupid`) REFERENCES `phpvms_groups` (`groupid`) ON DELETE CASCADE,
  1336. ADD CONSTRAINT `phpvms_groupmembers_ibfk_2` FOREIGN KEY (`pilotid`) REFERENCES `phpvms_pilots` (`pilotid`) ON DELETE CASCADE;
  1337.  
  1338. --
  1339. -- Constraints for table `phpvms_pilots`
  1340. --
  1341. ALTER TABLE `phpvms_pilots`
  1342. ADD CONSTRAINT `phpvms_pilots_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines` (`code`) ON UPDATE CASCADE;
  1343.  
  1344. --
  1345. -- Constraints for table `phpvms_pirepcomments`
  1346. --
  1347. ALTER TABLE `phpvms_pirepcomments`
  1348. ADD CONSTRAINT `phpvms_pirepcomments_ibfk_1` FOREIGN KEY (`pirepid`) REFERENCES `phpvms_pireps` (`pirepid`) ON DELETE CASCADE ON UPDATE CASCADE;
  1349.  
  1350. --
  1351. -- Constraints for table `phpvms_schedules`
  1352. --
  1353. ALTER TABLE `phpvms_schedules`
  1354. ADD CONSTRAINT `phpvms_schedules_ibfk_1` FOREIGN KEY (`code`) REFERENCES `phpvms_airlines` (`code`) ON UPDATE CASCADE;
Advertisement
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!