API tools faq
paste
Advertisement
Futurisma

Americandiscovery.net Database

Futurisma
Jan 6th, 2018
303
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 44.63 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 2.10.3
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Oct 02, 2012 at 02:16 AM
  7. -- Server version: 5.0.51
  8. -- PHP Version: 5.2.6
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Database: `brain`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Table structure for table `attachments`
  20. --
  21.  
  22. CREATE TABLE `attachments` (
  23. `id` int(11) NOT NULL auto_increment,
  24. `title` varchar(255) default NULL,
  25. `desc` longtext,
  26. `file` varchar(255) default NULL,
  27. `user` int(11) default NULL,
  28. `deadline` varchar(255) default NULL,
  29. `projects` varchar(255) default NULL,
  30. PRIMARY KEY (`id`)
  31. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ;
  32.  
  33. --
  34. -- Dumping data for table `attachments`
  35. --
  36.  
  37. INSERT INTO `attachments` VALUES (2, 'test', 'This is Just Description', '_index_02(1).jpg', 1, '1,11', '6');
  38. INSERT INTO `attachments` VALUES (9, 'test9', 'This is Just Description This is Just Description This is Just Description But Long This is Just Description This is Just Description This is Just Description But Long', '_index_02(1).jpg', 1, NULL, '4');
  39. INSERT INTO `attachments` VALUES (10, 'test10', 'This is Just Description This is Just Description This is Just Description But Small', '_index_02(1).jpg', 1, NULL, '4');
  40. INSERT INTO `attachments` VALUES (11, 'test11', 'This is Just Description This is Just Description This is Just Description But Long', '_index_02(1).jpg', 1, NULL, '6');
  41. INSERT INTO `attachments` VALUES (14, 'test14', 'This is Just Description This is Just Description This is Just Description But LongThis is Just Description This is Just Description This is Just Description But Long', '57658.jpg', 1, NULL, '3');
  42. INSERT INTO `attachments` VALUES (15, 'test15', ' This is Just Description This is Just Description This is Just Description But Long This is Just Description This is Just Description This is Just Description But Long', '_index_02(1).jpg', 1, NULL, '1');
  43. INSERT INTO `attachments` VALUES (58, 'asdasd', 'ad', 'yousef_06.jpg', 1, NULL, '11');
  44. INSERT INTO `attachments` VALUES (68, 'test', 'test', 'coming-soon (1).jpg', 1, NULL, '23');
  45. INSERT INTO `attachments` VALUES (69, 'dsad', 'ssdasd', '05.jpg', 1, NULL, '23');
  46. INSERT INTO `attachments` VALUES (70, 'Brain Guide', 'Brain Guide', 'read-me.pdf', 1, NULL, '49');
  47. INSERT INTO `attachments` VALUES (71, 'notes ', 'notes screenshot', 'notes.jpg', 1, NULL, '49');
  48. INSERT INTO `attachments` VALUES (55, 'wesam', 'dffdfdf', 'chat_example.zip', 1, NULL, '2');
  49. INSERT INTO `attachments` VALUES (56, 'sa', 'sss', 'AJAX.zip', 2, NULL, '2');
  50. INSERT INTO `attachments` VALUES (65, 'Some Desc', 'asdasd', 'screens.zip', 1, NULL, '18');
  51. INSERT INTO `attachments` VALUES (35, 'sf', 'sdf', 'yousef_081.jpg', 1, NULL, '11');
  52. INSERT INTO `attachments` VALUES (59, 'asd', 'asdasd', 'yousef_09.jpg', 1, NULL, '11');
  53. INSERT INTO `attachments` VALUES (60, 'sss', 's', '121_04.png', 1, NULL, '11');
  54. INSERT INTO `attachments` VALUES (63, 'dsfsdf', 'dsf', 'aa.png', 1, NULL, '2');
  55. INSERT INTO `attachments` VALUES (62, 'wwwww', '', '121_10.png', 2, NULL, '4');
  56. INSERT INTO `attachments` VALUES (64, 'Test', 'Test', 'photo2768_001 (1).jpg', 1, NULL, '18');
  57. INSERT INTO `attachments` VALUES (45, 'asd', 'asd', 'yousef_08.jpg', 1, NULL, '2');
  58. INSERT INTO `attachments` VALUES (46, 'ewq', 'qwe', 'yousef_06.jpg', 1, NULL, '2');
  59.  
  60. -- --------------------------------------------------------
  61.  
  62. --
  63. -- Table structure for table `chat`
  64. --
  65.  
  66. CREATE TABLE `chat` (
  67. `id` int(11) NOT NULL auto_increment,
  68. `chat_id` int(11) NOT NULL,
  69. `name` text NOT NULL,
  70. `color` text NOT NULL,
  71. `message` text NOT NULL,
  72. `rank` int(1) NOT NULL,
  73. `time` int(11) NOT NULL,
  74. KEY `id` (`id`)
  75. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
  76.  
  77. --
  78. -- Dumping data for table `chat`
  79. --
  80.  
  81. INSERT INTO `chat` VALUES (1, 49, 'FreeLance Website', '', '', 0, 0);
  82.  
  83. -- --------------------------------------------------------
  84.  
  85. --
  86. -- Table structure for table `chat_bans`
  87. --
  88.  
  89. CREATE TABLE `chat_bans` (
  90. `ip` text NOT NULL,
  91. `expire` int(11) NOT NULL,
  92. KEY `expire` (`expire`)
  93. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  94.  
  95. --
  96. -- Dumping data for table `chat_bans`
  97. --
  98.  
  99.  
  100. -- --------------------------------------------------------
  101.  
  102. --
  103. -- Table structure for table `chat_pms`
  104. --
  105.  
  106. CREATE TABLE `chat_pms` (
  107. `target` text NOT NULL,
  108. `name` text NOT NULL,
  109. `color` text NOT NULL,
  110. `message` text NOT NULL,
  111. `time` bigint(20) NOT NULL,
  112. `timestamp` int(11) NOT NULL,
  113. KEY `time` (`time`)
  114. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  115.  
  116. --
  117. -- Dumping data for table `chat_pms`
  118. --
  119.  
  120.  
  121. -- --------------------------------------------------------
  122.  
  123. --
  124. -- Table structure for table `chat_sessions`
  125. --
  126.  
  127. CREATE TABLE `chat_sessions` (
  128. `ip` text NOT NULL,
  129. `name` text NOT NULL,
  130. `color` text NOT NULL,
  131. `muted` text NOT NULL,
  132. `rank` int(1) NOT NULL,
  133. `lasttalk` int(11) NOT NULL,
  134. `lastcheck` int(11) NOT NULL,
  135. `lastid` int(11) NOT NULL,
  136. `chat_id` int(11) NOT NULL,
  137. KEY `lastcheck` (`lastcheck`)
  138. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  139.  
  140. --
  141. -- Dumping data for table `chat_sessions`
  142. --
  143.  
  144.  
  145. -- --------------------------------------------------------
  146.  
  147. --
  148. -- Table structure for table `chat_users`
  149. --
  150.  
  151. CREATE TABLE `chat_users` (
  152. `user` text NOT NULL,
  153. `pass` text NOT NULL,
  154. `lastactive` text NOT NULL,
  155. `linecount` text NOT NULL,
  156. `rank` text NOT NULL
  157. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  158.  
  159. --
  160. -- Dumping data for table `chat_users`
  161. --
  162.  
  163. INSERT INTO `chat_users` VALUES ('admin', 'admin', '', '', '6');
  164.  
  165. -- --------------------------------------------------------
  166.  
  167. --
  168. -- Table structure for table `contacts`
  169. --
  170.  
  171. CREATE TABLE `contacts` (
  172. `id` int(11) NOT NULL auto_increment,
  173. `first` varchar(255) default NULL,
  174. `last` varchar(255) default NULL,
  175. `tel` varchar(255) default NULL,
  176. `mob` varchar(255) default NULL,
  177. `email` varchar(255) default NULL,
  178. `position` varchar(255) default NULL,
  179. `company` varchar(255) default NULL,
  180. `user` int(11) default NULL,
  181. `projects` varchar(255) default NULL,
  182. PRIMARY KEY (`id`)
  183. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
  184.  
  185. --
  186. -- Dumping data for table `contacts`
  187. --
  188.  
  189. INSERT INTO `contacts` VALUES (2, 'mohammed', 'mahmood', '54654651', '565415213', 'mahmood@abb2.com', 'manager', 'dewa', 38, '22,18,2,1');
  190. INSERT INTO `contacts` VALUES (3, 'khalil', 'karam', '54654651', '565415213', 'khalil@xbox.com', 'manager', 'dewa', 38, '23,22,2,11,1');
  191. INSERT INTO `contacts` VALUES (23, 'Steve', 'Brain', '564416514', '654654541', 'steve@wesam.me', 'Sales Executive ', 'SME', 1, '49');
  192. INSERT INTO `contacts` VALUES (24, 'Mark', 'Hall', '5456654654', '65465416', 'mark@wesam.me', 'Sales Executive ', 'SME', 1, '49');
  193. INSERT INTO `contacts` VALUES (22, 'Ahmad', 'Mansour', '0095588745', '4548745151', 'admin@wesam.me', 'CEO', 'SME', 1, '49');
  194.  
  195. -- --------------------------------------------------------
  196.  
  197. --
  198. -- Table structure for table `deadline`
  199. --
  200.  
  201. CREATE TABLE `deadline` (
  202. `id` int(11) NOT NULL auto_increment,
  203. `name` varchar(255) default NULL,
  204. `attachment` varchar(255) default NULL,
  205. `assigned_to` varchar(255) default NULL,
  206. `deadline` varchar(255) default NULL,
  207. `user` int(11) default NULL,
  208. `date` varchar(255) default NULL,
  209. `project` varchar(255) default NULL,
  210. PRIMARY KEY (`id`)
  211. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;
  212.  
  213. --
  214. -- Dumping data for table `deadline`
  215. --
  216.  
  217. INSERT INTO `deadline` VALUES (41, 'Quality Assurance', '0', '38', '2012-11-20', 1, '02-10-2012', '49');
  218. INSERT INTO `deadline` VALUES (40, 'PHP Development', '0', '38,41', '2012-11-01', 1, '02-10-2012', '49');
  219. INSERT INTO `deadline` VALUES (39, 'Design Layout', '0', '38,39', '2012-10-13', 1, '02-10-2012', '49');
  220. INSERT INTO `deadline` VALUES (37, 'asdasdasdasd', '0', '38', 'asdasd', 1, '30-09-2012', '23');
  221. INSERT INTO `deadline` VALUES (36, 'asdasdasd', '0', '38,39', '345345345', 1, '30-09-2012', '22');
  222. INSERT INTO `deadline` VALUES (38, 'design', '0', '39', '13/09/1897', 1, '30-09-2012', '23');
  223. INSERT INTO `deadline` VALUES (32, 'asdasd', '64', '2,3,5,6', '9/29/2012', 1, '29-09-2012', '18');
  224. INSERT INTO `deadline` VALUES (27, 'sssss', '58,35', '3', '11/17/2009', 1, '17-11-2009', '11');
  225. INSERT INTO `deadline` VALUES (30, 'weqweqwe', '63,55,56', '7,2,3', '11/18/2009', 1, '18-11-2009', '2');
  226. INSERT INTO `deadline` VALUES (29, 'qweqwe', '62,9', '7,5', '11/18/2009', 2, '18-11-2009', '4');
  227.  
  228. -- --------------------------------------------------------
  229.  
  230. --
  231. -- Table structure for table `investment`
  232. --
  233.  
  234. CREATE TABLE `investment` (
  235. `id` int(11) NOT NULL auto_increment,
  236. `title` varchar(255) default NULL,
  237. `projects` varchar(255) default NULL,
  238. `desc` longtext,
  239. `money` int(11) default NULL,
  240. `time` int(11) default NULL,
  241. `user` int(11) default NULL,
  242. PRIMARY KEY (`id`)
  243. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;
  244.  
  245. --
  246. -- Dumping data for table `investment`
  247. --
  248.  
  249. INSERT INTO `investment` VALUES (1, 'making Creative', '11', 'Designer Making Creative', 15415, 20, 3);
  250. INSERT INTO `investment` VALUES (2, 'Wesam Creative', '11', 'Wesam Making Develpoments', 10000, 40, 3);
  251. INSERT INTO `investment` VALUES (3, 'Reading', '11', 'Saad reading', 1500, 3, 5);
  252. INSERT INTO `investment` VALUES (4, 'Reading', '11', 'Wesam making Ajax', 1000, 4, 5);
  253. INSERT INTO `investment` VALUES (5, 'Creative', '11', 'Talal Making Creative', 5600, 10, 7);
  254. INSERT INTO `investment` VALUES (6, 'Develpment', '11', 'Wesam Making Develpment', 3000, 20, 3);
  255. INSERT INTO `investment` VALUES (7, 'brain worx', '4', ' redevelopment by wesam', 5435, 48, 2);
  256. INSERT INTO `investment` VALUES (8, 'Dolphin', '4', 'REDEVELOPMENTS bY wESAM', 5640, 15, 2);
  257. INSERT INTO `investment` VALUES (9, 'asdasd', '4', ' asdasdasdasd', 1500, 0, 2);
  258. INSERT INTO `investment` VALUES (14, 'asdasd', '2', ' asdasd', 3324, 234, 1);
  259. INSERT INTO `investment` VALUES (12, 'asdsss', '4', ' asdasdasd', 2300, 32, 2);
  260. INSERT INTO `investment` VALUES (15, '234234', '2', ' 234234', 234, 3244, 1);
  261. INSERT INTO `investment` VALUES (16, 'Tff', '17', ' Ggggg', 444, 35, 1);
  262. INSERT INTO `investment` VALUES (17, 'Rr', '17', ' Fff', 44, 99, 1);
  263. INSERT INTO `investment` VALUES (18, 'asd', '18', ' asd', 50, 50, 1);
  264. INSERT INTO `investment` VALUES (19, 'PHP Developer ', '22', 'PHP Developer inHouse', 5000, 50, 38);
  265. INSERT INTO `investment` VALUES (20, 'Design The Layout', '22', ' Designer', 400, 30, 1);
  266. INSERT INTO `investment` VALUES (21, 'test', '23', 'test ', 50, 50, 1);
  267. INSERT INTO `investment` VALUES (22, 'design', '23', 'sdfgsdfsdf', 500, 50, 1);
  268. INSERT INTO `investment` VALUES (23, 'devlopment', '23', 'saDasd ', 800, 30, 1);
  269. INSERT INTO `investment` VALUES (24, 'Design', '49', 'we need graphic designer to design the layout ', 800, 20, 1);
  270. INSERT INTO `investment` VALUES (25, 'PHP Developer ', '49', ' we need PHP Developer to develope the website', 2500, 60, 1);
  271. INSERT INTO `investment` VALUES (26, 'Quality Assurance', '49', 'will handle Quality Assurance guy freelance', 1000, 20, 1);
  272.  
  273. -- --------------------------------------------------------
  274.  
  275. --
  276. -- Table structure for table `log_message`
  277. --
  278.  
  279. CREATE TABLE `log_message` (
  280. `message_id` int(11) NOT NULL auto_increment,
  281. `chat_id` int(11) NOT NULL default '0',
  282. `user_id` int(11) NOT NULL default '0',
  283. `user_name` varchar(64) default NULL,
  284. `message` text,
  285. `post_time` datetime default NULL,
  286. PRIMARY KEY (`message_id`)
  287. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=133 ;
  288.  
  289. --
  290. -- Dumping data for table `log_message`
  291. --
  292.  
  293. INSERT INTO `log_message` VALUES (1, 2, 1, 'Shadi Alhasan', 'hi every BODY', '2009-11-18 08:53:09');
  294. INSERT INTO `log_message` VALUES (2, 2, 1, 'Shadi Alhasan', 'hOW aRE yOU aLL', '2009-11-18 08:53:15');
  295. INSERT INTO `log_message` VALUES (3, 2, 1, 'Shadi Alhasan', 'MMMMMMMM', '2009-11-18 08:53:27');
  296. INSERT INTO `log_message` VALUES (4, 2, 1, 'Shadi Alhasan', 'THIS IS A CHAT', '2009-11-18 08:53:32');
  297. INSERT INTO `log_message` VALUES (5, 2, 3, 'majdi alomari', 'HI bOSS ', '2009-11-18 08:54:03');
  298. INSERT INTO `log_message` VALUES (6, 2, 3, 'majdi alomari', 'HOW ARE U', '2009-11-18 08:54:09');
  299. INSERT INTO `log_message` VALUES (7, 2, 3, 'majdi alomari', 'I\\''M SOO SLEEPY', '2009-11-18 08:54:27');
  300. INSERT INTO `log_message` VALUES (8, 2, 1, 'Shadi Alhasan', 'GO 2 hOME', '2009-11-18 08:54:51');
  301. INSERT INTO `log_message` VALUES (9, 2, 1, 'Shadi Alhasan', 'Yalla 7abibiy', '2009-11-18 08:55:17');
  302. INSERT INTO `log_message` VALUES (10, 2, 2, 'wesam taha', 'Hi All how is everything', '2009-11-18 08:56:33');
  303. INSERT INTO `log_message` VALUES (11, 2, 1, 'Shadi Alhasan', 'hala wesam', '2009-11-18 08:56:42');
  304. INSERT INTO `log_message` VALUES (12, 2, 1, 'Shadi Alhasan', 'keffak', '2009-11-18 08:56:52');
  305. INSERT INTO `log_message` VALUES (13, 2, 2, 'wesam taha', 'والله الحمد لله ', '2009-11-18 08:57:00');
  306. INSERT INTO `log_message` VALUES (14, 2, 1, 'shadi alhasan', 'ssssssssssss', '2009-11-18 09:10:52');
  307. INSERT INTO `log_message` VALUES (15, 2, 1, 'shadi alhasan', 'sssssssssssss', '2009-11-18 09:10:54');
  308. INSERT INTO `log_message` VALUES (16, 2, 1, 'shadi alhasan', 'ssssss', '2009-11-18 09:10:55');
  309. INSERT INTO `log_message` VALUES (17, 2, 1, 'shadi alhasan', 'weqweqweqw', '2009-11-18 09:11:34');
  310. INSERT INTO `log_message` VALUES (18, 2, 1, 'shadi alhasan', 'ccccccccccccccccccc', '2009-11-18 10:09:18');
  311. INSERT INTO `log_message` VALUES (19, 4, 2, 'wesam taha', 'asdasd', '2009-11-19 17:18:08');
  312. INSERT INTO `log_message` VALUES (20, 4, 2, 'wesam taha', 'asd', '2009-11-19 17:18:09');
  313. INSERT INTO `log_message` VALUES (21, 4, 2, 'wesam taha', 'sdfffffffffffff', '2009-11-19 17:18:13');
  314. INSERT INTO `log_message` VALUES (22, 4, 2, 'wesam taha', 'sadasd', '2009-11-19 17:23:21');
  315. INSERT INTO `log_message` VALUES (23, 4, 2, 'wesam taha', 'rtyrty', '2009-11-19 17:24:02');
  316. INSERT INTO `log_message` VALUES (24, 2, 3, 'majdi alomari', 'sadglklkadsf', '2009-11-19 17:26:17');
  317. INSERT INTO `log_message` VALUES (25, 2, 3, 'majdi alomari', 'asdg', '2009-11-19 17:26:19');
  318. INSERT INTO `log_message` VALUES (26, 2, 3, 'majdi alomari', 'asdgf', '2009-11-19 17:26:20');
  319. INSERT INTO `log_message` VALUES (27, 2, 3, 'majdi alomari', 'sdf', '2009-11-19 17:26:21');
  320. INSERT INTO `log_message` VALUES (28, 2, 3, 'majdi alomari', 'sddf', '2009-11-19 17:26:21');
  321. INSERT INTO `log_message` VALUES (29, 2, 3, 'majdi alomari', 'sef', '2009-11-19 17:26:21');
  322. INSERT INTO `log_message` VALUES (30, 2, 3, 'majdi alomari', 'wef', '2009-11-19 17:26:22');
  323. INSERT INTO `log_message` VALUES (31, 2, 3, 'majdi alomari', 'wef', '2009-11-19 17:26:23');
  324. INSERT INTO `log_message` VALUES (32, 2, 2, 'wesam taha', 'rewrwer', '2009-11-19 17:27:14');
  325. INSERT INTO `log_message` VALUES (33, 2, 3, 'majdi alomari', 'sadfnbk', '2009-11-19 17:27:14');
  326. INSERT INTO `log_message` VALUES (34, 2, 3, 'majdi alomari', 'sdkbg', '2009-11-19 17:27:15');
  327. INSERT INTO `log_message` VALUES (35, 2, 3, 'majdi alomari', 'kjsdg', '2009-11-19 17:27:15');
  328. INSERT INTO `log_message` VALUES (36, 2, 3, 'majdi alomari', 'bads', '2009-11-19 17:27:16');
  329. INSERT INTO `log_message` VALUES (37, 2, 3, 'majdi alomari', 'g[osdsgv', '2009-11-19 17:27:16');
  330. INSERT INTO `log_message` VALUES (38, 2, 3, 'majdi alomari', 'asg', '2009-11-19 17:27:16');
  331. INSERT INTO `log_message` VALUES (39, 2, 3, 'majdi alomari', 'asdg', '2009-11-19 17:27:17');
  332. INSERT INTO `log_message` VALUES (40, 2, 3, 'majdi alomari', 'asgfjp\\''adg', '2009-11-19 17:27:17');
  333. INSERT INTO `log_message` VALUES (41, 2, 3, 'majdi alomari', 'adg', '2009-11-19 17:27:18');
  334. INSERT INTO `log_message` VALUES (42, 2, 3, 'majdi alomari', 'adg', '2009-11-19 17:27:18');
  335. INSERT INTO `log_message` VALUES (43, 2, 3, 'majdi alomari', 'adrg', '2009-11-19 17:27:18');
  336. INSERT INTO `log_message` VALUES (44, 2, 3, 'majdi alomari', 'adr', '2009-11-19 17:27:19');
  337. INSERT INTO `log_message` VALUES (45, 2, 3, 'majdi alomari', 'adrg', '2009-11-19 17:27:19');
  338. INSERT INTO `log_message` VALUES (46, 2, 3, 'majdi alomari', 'ad', '2009-11-19 17:27:19');
  339. INSERT INTO `log_message` VALUES (47, 2, 3, 'majdi alomari', 'gad', '2009-11-19 17:27:19');
  340. INSERT INTO `log_message` VALUES (48, 2, 3, 'majdi alomari', 'adg', '2009-11-19 17:27:20');
  341. INSERT INTO `log_message` VALUES (49, 2, 3, 'majdi alomari', 'qgr', '2009-11-19 17:27:20');
  342. INSERT INTO `log_message` VALUES (50, 2, 3, 'majdi alomari', 'qegt', '2009-11-19 17:27:20');
  343. INSERT INTO `log_message` VALUES (51, 2, 3, 'majdi alomari', 'rtg', '2009-11-19 17:27:20');
  344. INSERT INTO `log_message` VALUES (52, 2, 3, 'majdi alomari', 'ergt', '2009-11-19 17:27:21');
  345. INSERT INTO `log_message` VALUES (53, 2, 3, 'majdi alomari', 'wtr', '2009-11-19 17:27:21');
  346. INSERT INTO `log_message` VALUES (54, 2, 3, 'majdi alomari', 'wrtg', '2009-11-19 17:27:21');
  347. INSERT INTO `log_message` VALUES (55, 2, 3, 'majdi alomari', 'rt', '2009-11-19 17:27:22');
  348. INSERT INTO `log_message` VALUES (56, 2, 3, 'majdi alomari', 'rt', '2009-11-19 17:27:22');
  349. INSERT INTO `log_message` VALUES (57, 2, 3, 'majdi alomari', 'rtbh', '2009-11-19 17:27:22');
  350. INSERT INTO `log_message` VALUES (58, 2, 3, 'majdi alomari', 'wtr', '2009-11-19 17:27:22');
  351. INSERT INTO `log_message` VALUES (59, 2, 3, 'majdi alomari', 'wrt', '2009-11-19 17:27:23');
  352. INSERT INTO `log_message` VALUES (60, 2, 3, 'majdi alomari', 'wrt', '2009-11-19 17:27:23');
  353. INSERT INTO `log_message` VALUES (61, 2, 3, 'majdi alomari', 'wrbth', '2009-11-19 17:27:23');
  354. INSERT INTO `log_message` VALUES (62, 2, 3, 'majdi alomari', 'r', '2009-11-19 17:27:24');
  355. INSERT INTO `log_message` VALUES (63, 2, 3, 'majdi alomari', 'sdf', '2009-11-19 17:27:28');
  356. INSERT INTO `log_message` VALUES (64, 2, 3, 'majdi alomari', 'fsdrf', '2009-11-19 17:27:29');
  357. INSERT INTO `log_message` VALUES (65, 2, 3, 'majdi alomari', 'wrf', '2009-11-19 17:27:30');
  358. INSERT INTO `log_message` VALUES (66, 2, 3, 'majdi alomari', 'werf', '2009-11-19 17:27:30');
  359. INSERT INTO `log_message` VALUES (67, 2, 3, 'majdi alomari', 'qewrf', '2009-11-19 17:27:30');
  360. INSERT INTO `log_message` VALUES (68, 2, 3, 'majdi alomari', 'qewrf', '2009-11-19 17:27:31');
  361. INSERT INTO `log_message` VALUES (69, 2, 3, 'majdi alomari', 'qwf', '2009-11-19 17:27:31');
  362. INSERT INTO `log_message` VALUES (70, 2, 3, 'majdi alomari', 'ewg', '2009-11-19 17:27:31');
  363. INSERT INTO `log_message` VALUES (71, 2, 3, 'majdi alomari', 'qegr', '2009-11-19 17:27:31');
  364. INSERT INTO `log_message` VALUES (72, 2, 3, 'majdi alomari', 'qewrg', '2009-11-19 17:27:32');
  365. INSERT INTO `log_message` VALUES (73, 2, 3, 'majdi alomari', 'werg', '2009-11-19 17:27:32');
  366. INSERT INTO `log_message` VALUES (74, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:32');
  367. INSERT INTO `log_message` VALUES (75, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:32');
  368. INSERT INTO `log_message` VALUES (76, 2, 3, 'majdi alomari', 'qewrgf', '2009-11-19 17:27:33');
  369. INSERT INTO `log_message` VALUES (77, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:33');
  370. INSERT INTO `log_message` VALUES (78, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:33');
  371. INSERT INTO `log_message` VALUES (79, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  372. INSERT INTO `log_message` VALUES (80, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  373. INSERT INTO `log_message` VALUES (81, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  374. INSERT INTO `log_message` VALUES (82, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  375. INSERT INTO `log_message` VALUES (83, 2, 3, 'majdi alomari', 'qeg', '2009-11-19 17:27:35');
  376. INSERT INTO `log_message` VALUES (84, 2, 3, 'majdi alomari', 'qeg', '2009-11-19 17:27:35');
  377. INSERT INTO `log_message` VALUES (85, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:35');
  378. INSERT INTO `log_message` VALUES (86, 2, 3, 'majdi alomari', 'qer', '2009-11-19 17:27:35');
  379. INSERT INTO `log_message` VALUES (87, 2, 3, 'majdi alomari', 'gqerg', '2009-11-19 17:27:36');
  380. INSERT INTO `log_message` VALUES (88, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:36');
  381. INSERT INTO `log_message` VALUES (89, 2, 3, 'majdi alomari', 'slq;dkg', '2009-11-19 17:27:36');
  382. INSERT INTO `log_message` VALUES (90, 2, 2, 'wesam taha', 'eeeeee', '2009-11-19 17:27:50');
  383. INSERT INTO `log_message` VALUES (91, 11, 1, 'shadi alhasan', 'dddddddd', '2009-11-19 17:39:10');
  384. INSERT INTO `log_message` VALUES (92, 11, 1, 'shadi alhasan', 'asdasd', '2009-11-19 17:39:14');
  385. INSERT INTO `log_message` VALUES (93, 11, 1, 'shadi alhasan', 'asdasdk', '2009-11-19 17:39:17');
  386. INSERT INTO `log_message` VALUES (94, 11, 1, 'shadi alhasan', 'akjsd', '2009-11-19 17:39:17');
  387. INSERT INTO `log_message` VALUES (95, 11, 1, 'shadi alhasan', '\\''[aspjd', '2009-11-19 17:39:17');
  388. INSERT INTO `log_message` VALUES (96, 11, 1, 'shadi alhasan', '[asjpd[', '2009-11-19 17:39:17');
  389. INSERT INTO `log_message` VALUES (97, 11, 1, 'shadi alhasan', 'ajsd', '2009-11-19 17:39:18');
  390. INSERT INTO `log_message` VALUES (98, 11, 1, 'shadi alhasan', 'ajsd', '2009-11-19 17:39:18');
  391. INSERT INTO `log_message` VALUES (99, 11, 1, 'shadi alhasan', '[ajsd', '2009-11-19 17:39:18');
  392. INSERT INTO `log_message` VALUES (100, 11, 1, 'shadi alhasan', '[asjd', '2009-11-19 17:39:18');
  393. INSERT INTO `log_message` VALUES (101, 11, 1, 'shadi alhasan', '[ajsd', '2009-11-19 17:39:19');
  394. INSERT INTO `log_message` VALUES (102, 11, 1, 'shadi alhasan', '[asjd', '2009-11-19 17:39:19');
  395. INSERT INTO `log_message` VALUES (103, 11, 1, 'shadi alhasan', 'ja s', '2009-11-19 17:39:19');
  396. INSERT INTO `log_message` VALUES (104, 11, 1, 'shadi alhasan', 'd[oj as', '2009-11-19 17:39:19');
  397. INSERT INTO `log_message` VALUES (105, 11, 1, 'shadi alhasan', '[dja', '2009-11-19 17:39:20');
  398. INSERT INTO `log_message` VALUES (106, 11, 1, 'shadi alhasan', ' s[odjk', '2009-11-19 17:39:20');
  399. INSERT INTO `log_message` VALUES (107, 11, 1, 'shadi alhasan', 'as\\''[pdk', '2009-11-19 17:39:20');
  400. INSERT INTO `log_message` VALUES (108, 11, 1, 'shadi alhasan', 'asdkl]a', '2009-11-19 17:39:20');
  401. INSERT INTO `log_message` VALUES (109, 11, 1, 'shadi alhasan', 'spld', '2009-11-19 17:39:21');
  402. INSERT INTO `log_message` VALUES (110, 11, 1, 'shadi alhasan', '][asld]', '2009-11-19 17:39:21');
  403. INSERT INTO `log_message` VALUES (111, 11, 1, 'shadi alhasan', '[asld]', '2009-11-19 17:39:21');
  404. INSERT INTO `log_message` VALUES (112, 11, 1, 'shadi alhasan', '[asld]', '2009-11-19 17:39:21');
  405. INSERT INTO `log_message` VALUES (113, 11, 1, 'shadi alhasan', '[asld', '2009-11-19 17:39:22');
  406. INSERT INTO `log_message` VALUES (114, 11, 1, 'shadi alhasan', '][asld', '2009-11-19 17:39:22');
  407. INSERT INTO `log_message` VALUES (115, 11, 1, 'shadi alhasan', '][asld]', '2009-11-19 17:39:22');
  408. INSERT INTO `log_message` VALUES (116, 11, 1, 'shadi alhasan', 'a[sld', '2009-11-19 17:39:22');
  409. INSERT INTO `log_message` VALUES (117, 11, 1, 'shadi alhasan', ']as[ld', '2009-11-19 17:39:23');
  410. INSERT INTO `log_message` VALUES (118, 11, 1, 'shadi alhasan', 'a]s[dl', '2009-11-19 17:39:23');
  411. INSERT INTO `log_message` VALUES (119, 11, 1, 'shadi alhasan', ']as[ld]', '2009-11-19 17:39:23');
  412. INSERT INTO `log_message` VALUES (120, 11, 1, 'shadi alhasan', 'a[sdpl', '2009-11-19 17:39:23');
  413. INSERT INTO `log_message` VALUES (121, 11, 1, 'shadi alhasan', ']as[dl', '2009-11-19 17:39:24');
  414. INSERT INTO `log_message` VALUES (122, 17, 1, 'shadi alhasan', 'asdasdasd', '2010-01-16 15:20:55');
  415. INSERT INTO `log_message` VALUES (123, 17, 1, 'shadi alhasan', 'asdadasd', '2010-01-16 15:20:57');
  416. INSERT INTO `log_message` VALUES (124, 17, 1, 'shadi alhasan', 'dffdfsd', '2010-01-16 15:21:03');
  417. INSERT INTO `log_message` VALUES (125, 17, 1, 'shadi alhasan', 'asd', '2010-01-16 16:29:48');
  418. INSERT INTO `log_message` VALUES (126, 17, 1, 'shadi alhasan', 'sadddddddddd', '2010-01-16 16:29:51');
  419. INSERT INTO `log_message` VALUES (127, 18, 1, 'shadi alhasan', 'asdasd', '2012-09-29 21:58:26');
  420. INSERT INTO `log_message` VALUES (128, 18, 1, 'shadi alhasan', 'asdasd', '2012-09-29 21:58:29');
  421. INSERT INTO `log_message` VALUES (129, 22, 1, 'Administrator', 'Hello', '2012-09-29 22:36:43');
  422. INSERT INTO `log_message` VALUES (130, 22, 1, 'Administrator', 'This is Chat Room For Test Project', '2012-09-29 22:37:04');
  423. INSERT INTO `log_message` VALUES (131, 22, 38, 'Employee1', 'Yes i Got it', '2012-09-29 22:49:39');
  424. INSERT INTO `log_message` VALUES (132, 22, 1, 'Administrator', 'aasdasd', '2012-09-30 21:44:12');
  425.  
  426. -- --------------------------------------------------------
  427.  
  428. --
  429. -- Table structure for table `message`
  430. --
  431.  
  432. CREATE TABLE `message` (
  433. `message_id` int(11) NOT NULL auto_increment,
  434. `chat_id` int(11) NOT NULL default '0',
  435. `user_id` int(11) NOT NULL default '0',
  436. `user_name` varchar(64) default NULL,
  437. `message` text,
  438. `post_time` datetime default NULL,
  439. PRIMARY KEY (`message_id`)
  440. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=213 ;
  441.  
  442. --
  443. -- Dumping data for table `message`
  444. --
  445.  
  446. INSERT INTO `message` VALUES (115, 2, 3, 'majdi alomari', 'kjsdg', '2009-11-19 17:27:15');
  447. INSERT INTO `message` VALUES (114, 2, 3, 'majdi alomari', 'sdkbg', '2009-11-19 17:27:15');
  448. INSERT INTO `message` VALUES (113, 2, 3, 'majdi alomari', 'sadfnbk', '2009-11-19 17:27:14');
  449. INSERT INTO `message` VALUES (112, 2, 2, 'wesam taha', 'rewrwer', '2009-11-19 17:27:14');
  450. INSERT INTO `message` VALUES (111, 2, 3, 'majdi alomari', 'wef', '2009-11-19 17:26:23');
  451. INSERT INTO `message` VALUES (109, 2, 3, 'majdi alomari', 'sef', '2009-11-19 17:26:21');
  452. INSERT INTO `message` VALUES (110, 2, 3, 'majdi alomari', 'wef', '2009-11-19 17:26:22');
  453. INSERT INTO `message` VALUES (108, 2, 3, 'majdi alomari', 'sddf', '2009-11-19 17:26:21');
  454. INSERT INTO `message` VALUES (105, 2, 3, 'majdi alomari', 'asdg', '2009-11-19 17:26:19');
  455. INSERT INTO `message` VALUES (106, 2, 3, 'majdi alomari', 'asdgf', '2009-11-19 17:26:20');
  456. INSERT INTO `message` VALUES (107, 2, 3, 'majdi alomari', 'sdf', '2009-11-19 17:26:21');
  457. INSERT INTO `message` VALUES (102, 4, 2, 'wesam taha', 'sadasd', '2009-11-19 17:23:21');
  458. INSERT INTO `message` VALUES (103, 4, 2, 'wesam taha', 'rtyrty', '2009-11-19 17:24:02');
  459. INSERT INTO `message` VALUES (104, 2, 3, 'majdi alomari', 'sadglklkadsf', '2009-11-19 17:26:17');
  460. INSERT INTO `message` VALUES (100, 4, 2, 'wesam taha', 'asd', '2009-11-19 17:18:09');
  461. INSERT INTO `message` VALUES (101, 4, 2, 'wesam taha', 'sdfffffffffffff', '2009-11-19 17:18:13');
  462. INSERT INTO `message` VALUES (99, 4, 2, 'wesam taha', 'asdasd', '2009-11-19 17:18:08');
  463. INSERT INTO `message` VALUES (98, 2, 1, 'shadi alhasan', 'ccccccccccccccccccc', '2009-11-18 10:09:18');
  464. INSERT INTO `message` VALUES (97, 2, 1, 'shadi alhasan', 'weqweqweqw', '2009-11-18 09:11:34');
  465. INSERT INTO `message` VALUES (116, 2, 3, 'majdi alomari', 'bads', '2009-11-19 17:27:16');
  466. INSERT INTO `message` VALUES (117, 2, 3, 'majdi alomari', 'g[osdsgv', '2009-11-19 17:27:16');
  467. INSERT INTO `message` VALUES (118, 2, 3, 'majdi alomari', 'asg', '2009-11-19 17:27:16');
  468. INSERT INTO `message` VALUES (119, 2, 3, 'majdi alomari', 'asdg', '2009-11-19 17:27:17');
  469. INSERT INTO `message` VALUES (120, 2, 3, 'majdi alomari', 'asgfjp\\''adg', '2009-11-19 17:27:17');
  470. INSERT INTO `message` VALUES (121, 2, 3, 'majdi alomari', 'adg', '2009-11-19 17:27:18');
  471. INSERT INTO `message` VALUES (122, 2, 3, 'majdi alomari', 'adg', '2009-11-19 17:27:18');
  472. INSERT INTO `message` VALUES (123, 2, 3, 'majdi alomari', 'adrg', '2009-11-19 17:27:18');
  473. INSERT INTO `message` VALUES (124, 2, 3, 'majdi alomari', 'adr', '2009-11-19 17:27:19');
  474. INSERT INTO `message` VALUES (125, 2, 3, 'majdi alomari', 'adrg', '2009-11-19 17:27:19');
  475. INSERT INTO `message` VALUES (126, 2, 3, 'majdi alomari', 'ad', '2009-11-19 17:27:19');
  476. INSERT INTO `message` VALUES (127, 2, 3, 'majdi alomari', 'gad', '2009-11-19 17:27:19');
  477. INSERT INTO `message` VALUES (128, 2, 3, 'majdi alomari', 'adg', '2009-11-19 17:27:20');
  478. INSERT INTO `message` VALUES (129, 2, 3, 'majdi alomari', 'qgr', '2009-11-19 17:27:20');
  479. INSERT INTO `message` VALUES (130, 2, 3, 'majdi alomari', 'qegt', '2009-11-19 17:27:20');
  480. INSERT INTO `message` VALUES (131, 2, 3, 'majdi alomari', 'rtg', '2009-11-19 17:27:20');
  481. INSERT INTO `message` VALUES (132, 2, 3, 'majdi alomari', 'ergt', '2009-11-19 17:27:21');
  482. INSERT INTO `message` VALUES (133, 2, 3, 'majdi alomari', 'wtr', '2009-11-19 17:27:21');
  483. INSERT INTO `message` VALUES (134, 2, 3, 'majdi alomari', 'wrtg', '2009-11-19 17:27:21');
  484. INSERT INTO `message` VALUES (135, 2, 3, 'majdi alomari', 'rt', '2009-11-19 17:27:22');
  485. INSERT INTO `message` VALUES (136, 2, 3, 'majdi alomari', 'rt', '2009-11-19 17:27:22');
  486. INSERT INTO `message` VALUES (137, 2, 3, 'majdi alomari', 'rtbh', '2009-11-19 17:27:22');
  487. INSERT INTO `message` VALUES (138, 2, 3, 'majdi alomari', 'wtr', '2009-11-19 17:27:22');
  488. INSERT INTO `message` VALUES (139, 2, 3, 'majdi alomari', 'wrt', '2009-11-19 17:27:23');
  489. INSERT INTO `message` VALUES (140, 2, 3, 'majdi alomari', 'wrt', '2009-11-19 17:27:23');
  490. INSERT INTO `message` VALUES (141, 2, 3, 'majdi alomari', 'wrbth', '2009-11-19 17:27:23');
  491. INSERT INTO `message` VALUES (142, 2, 3, 'majdi alomari', 'r', '2009-11-19 17:27:24');
  492. INSERT INTO `message` VALUES (143, 2, 3, 'majdi alomari', 'sdf', '2009-11-19 17:27:28');
  493. INSERT INTO `message` VALUES (144, 2, 3, 'majdi alomari', 'fsdrf', '2009-11-19 17:27:29');
  494. INSERT INTO `message` VALUES (145, 2, 3, 'majdi alomari', 'wrf', '2009-11-19 17:27:30');
  495. INSERT INTO `message` VALUES (146, 2, 3, 'majdi alomari', 'werf', '2009-11-19 17:27:30');
  496. INSERT INTO `message` VALUES (147, 2, 3, 'majdi alomari', 'qewrf', '2009-11-19 17:27:30');
  497. INSERT INTO `message` VALUES (148, 2, 3, 'majdi alomari', 'qewrf', '2009-11-19 17:27:31');
  498. INSERT INTO `message` VALUES (149, 2, 3, 'majdi alomari', 'qwf', '2009-11-19 17:27:31');
  499. INSERT INTO `message` VALUES (150, 2, 3, 'majdi alomari', 'ewg', '2009-11-19 17:27:31');
  500. INSERT INTO `message` VALUES (151, 2, 3, 'majdi alomari', 'qegr', '2009-11-19 17:27:31');
  501. INSERT INTO `message` VALUES (152, 2, 3, 'majdi alomari', 'qewrg', '2009-11-19 17:27:32');
  502. INSERT INTO `message` VALUES (153, 2, 3, 'majdi alomari', 'werg', '2009-11-19 17:27:32');
  503. INSERT INTO `message` VALUES (154, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:32');
  504. INSERT INTO `message` VALUES (155, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:32');
  505. INSERT INTO `message` VALUES (156, 2, 3, 'majdi alomari', 'qewrgf', '2009-11-19 17:27:33');
  506. INSERT INTO `message` VALUES (157, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:33');
  507. INSERT INTO `message` VALUES (158, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:33');
  508. INSERT INTO `message` VALUES (159, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  509. INSERT INTO `message` VALUES (160, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  510. INSERT INTO `message` VALUES (161, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  511. INSERT INTO `message` VALUES (162, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:34');
  512. INSERT INTO `message` VALUES (163, 2, 3, 'majdi alomari', 'qeg', '2009-11-19 17:27:35');
  513. INSERT INTO `message` VALUES (164, 2, 3, 'majdi alomari', 'qeg', '2009-11-19 17:27:35');
  514. INSERT INTO `message` VALUES (165, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:35');
  515. INSERT INTO `message` VALUES (166, 2, 3, 'majdi alomari', 'qer', '2009-11-19 17:27:35');
  516. INSERT INTO `message` VALUES (167, 2, 3, 'majdi alomari', 'gqerg', '2009-11-19 17:27:36');
  517. INSERT INTO `message` VALUES (168, 2, 3, 'majdi alomari', 'qerg', '2009-11-19 17:27:36');
  518. INSERT INTO `message` VALUES (169, 2, 3, 'majdi alomari', 'slq;dkg', '2009-11-19 17:27:36');
  519. INSERT INTO `message` VALUES (170, 2, 2, 'wesam taha', 'eeeeee', '2009-11-19 17:27:50');
  520. INSERT INTO `message` VALUES (212, 22, 1, 'Administrator', 'aasdasd', '2012-09-30 21:44:12');
  521. INSERT INTO `message` VALUES (209, 22, 1, 'Administrator', 'Hello', '2012-09-29 22:36:43');
  522. INSERT INTO `message` VALUES (210, 22, 1, 'Administrator', 'This is Chat Room For Test Project', '2012-09-29 22:37:04');
  523. INSERT INTO `message` VALUES (211, 22, 38, 'Employee1', 'Yes i Got it', '2012-09-29 22:49:39');
  524.  
  525. -- --------------------------------------------------------
  526.  
  527. --
  528. -- Table structure for table `notes`
  529. --
  530.  
  531. CREATE TABLE `notes` (
  532. `id` int(11) NOT NULL auto_increment,
  533. `title` varchar(255) default NULL,
  534. `desc` longtext,
  535. `project` varchar(255) default NULL,
  536. `user` varchar(255) default NULL,
  537. `date` varchar(255) default NULL,
  538. PRIMARY KEY (`id`)
  539. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;
  540.  
  541. --
  542. -- Dumping data for table `notes`
  543. --
  544.  
  545. INSERT INTO `notes` VALUES (1, 'Note Title 1', 'Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note', '1', '2', '10/10/2009');
  546. INSERT INTO `notes` VALUES (2, 'Note Title 2', 'Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note', '1', '3', '10/10/2009');
  547. INSERT INTO `notes` VALUES (3, 'titlesssss', ' desc', '1', '2', '10/10/2009');
  548. INSERT INTO `notes` VALUES (26, 'Www', ' Www', '17', '1', '30-12-2009');
  549. INSERT INTO `notes` VALUES (4, 'Note', 'Test notes', '2', '5', '10/10/2009');
  550. INSERT INTO `notes` VALUES (5, 'Note222', 'Test notes 22', '2', '5', '10/10/2009');
  551. INSERT INTO `notes` VALUES (6, 'hi', 'Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note Test Note', '4', '6', '10/10/2009');
  552. INSERT INTO `notes` VALUES (7, 'www', ' www', '6', '', '15-11-2009');
  553. INSERT INTO `notes` VALUES (8, '', '', '6', '1', '');
  554. INSERT INTO `notes` VALUES (9, 'hi', ' I''m Here', '3', '1', '15-11-2009');
  555. INSERT INTO `notes` VALUES (10, '', '', '6', '1', '');
  556. INSERT INTO `notes` VALUES (29, 'Note 1', 'This is note Form Employee 1 About The Project ', '22', '38', '29-09-2012');
  557. INSERT INTO `notes` VALUES (24, 'sad', ' asdasd', '2', '2', '17-11-2009');
  558. INSERT INTO `notes` VALUES (21, '', '', '6', '1', '');
  559. INSERT INTO `notes` VALUES (22, 'werwe', ' rwerssdasdasdbbbbbbbbbbbbb', '11', '1', '17-11-2009');
  560. INSERT INTO `notes` VALUES (23, 'asdasd', ' asdddddddddddddddddd asd asd asdsdffsdf', '11', '1', '17-11-2009');
  561. INSERT INTO `notes` VALUES (28, 'asdasd', ' asdsad', '18', '1', '29-09-2012');
  562. INSERT INTO `notes` VALUES (30, 'sdf', ' sdf', '23', '1', '30-09-2012');
  563. INSERT INTO `notes` VALUES (32, '2332', ' zdsd', '23', '1', '30-09-2012');
  564. INSERT INTO `notes` VALUES (33, 'Design css', 'The Design should be in css3 ', '49', '1', '02-10-2012');
  565. INSERT INTO `notes` VALUES (34, 'Rss Files', 'We have to prepare RSS Files for iphone app later on ', '49', '1', '02-10-2012');
  566.  
  567. -- --------------------------------------------------------
  568.  
  569. --
  570. -- Table structure for table `projects`
  571. --
  572.  
  573. CREATE TABLE `projects` (
  574. `id` int(11) NOT NULL auto_increment,
  575. `name` varchar(255) default NULL,
  576. `desc` longtext,
  577. `progress` int(11) default NULL,
  578. `start_date` int(11) NOT NULL,
  579. `end_date` int(11) NOT NULL,
  580. `client` text NOT NULL,
  581. `status` text NOT NULL,
  582. `team_leaders` varchar(255) default NULL,
  583. `team` varchar(255) default NULL,
  584. `user` int(11) default NULL,
  585. `date` varchar(255) default NULL,
  586. PRIMARY KEY (`id`)
  587. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;
  588.  
  589. --
  590. -- Dumping data for table `projects`
  591. --
  592.  
  593. INSERT INTO `projects` VALUES (22, 'Test Project ', '<ol><li><span style="font-weight: bold; background-color: rgb(246, 246, 246); ">Project Brief Will Goes Here \r\n Project Brief Will Goes Here \r\n Project Brief Will Goes Here \r\n Project Brief Will Goes Here \r\n Project Brief Will Goes Here \r\n Project Brief Will Goes Here</span></li><li><span style="font-weight: bold; background-color: rgb(246, 246, 246); "><br></span></li><li><span style="font-weight: bold; background-color: rgb(246, 246, 246); ">Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here</span></li><li><span style="font-weight: bold; background-color: rgb(246, 246, 246); "><br></span></li><li><span style="font-weight: bold; background-color: rgb(246, 246, 246); ">Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here</span></li><li><span style="font-weight: bold; background-color: rgb(246, 246, 246); "><br></span></li><li><span style="font-weight: bold; background-color: rgb(246, 246, 246); ">Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here Project Brief Will Goes Here</span></li></ol>', NULL, 2012, 2012, 'APH Company', '2', '1,38', '39,41', 1, '29-09-2012');
  594. INSERT INTO `projects` VALUES (49, 'FreeLance Website', '<p class="MsoNormal" align="center"><p class="MsoNormal" align="center"><p class="MsoNormal" align="center"><p><div style="text-align: center;"><span style="font-size: 11px; background-color: rgb(246, 246, 246); color: rgb(0, 0, 0);">Read it all Please Important</span></div><div style="text-align: center;"><span style="font-weight: normal; font-size: 11px; background-color: rgb(246, 246, 246); "><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);">BrainWorx Project management brainstorming&nbsp;</span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);">BrainWorx is a web based application the helps you to manage your company or \r\nfreelance projects with brainstorming tools, this revolutionary application also \r\nworks great for consultants, project managers, and service professionals.</span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);">features includes in BrainWorx:</span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); "><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); ">Project Management</span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); "><span style="font-weight: normal;">1- </span>Projects:<span style="font-weight: normal;"> create \r\nprojects and assign them to the customers.</span></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);">2- You can full manage projects [ \r\nadd / edit / delete / filtration ] , progress, cost, Team Leader, Team, Start \r\nand , End date, Project brief.</span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); "><span style="font-weight: normal;">3-</span> Notes:<span style="font-weight: normal;"> Project Managers or Staff members \r\ncan create Notes based on a specific project.</span></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); "><span style="font-weight: normal;">4- </span>Files:<span style="font-weight: normal;"> File Upload Tool \r\nallowed the users to attach files based on a specific project.</span></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); "><span style="font-weight: normal;">5- </span>Contacts:<span style="font-weight: normal;"> \r\nProject Managers can attach clients contact information to projects with a \r\nfeature to add clients from existing list&nbsp;</span></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); "><span style="font-weight: normal;">6- </span>Deadlines:<span style="font-weight: normal;"> Project Managers can \r\nadd multiple deadlines for each project.</span></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); "><span style="font-weight: normal;">7- </span>Project Investments:<span style="font-weight: normal;"> by adding \r\nprojects phases on cost and time, Brainworx automatically calculating the hall \r\nproject investments in total cost and total&nbsp;</span></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); ">Staff Management &amp; permissions:</span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);">- Just two levels of user-rights (Administrator or custom user permissions)</span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);"><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0);">- \r\nYou have flexibility over the permissions of each staff member, you can manage \r\nin the member permissions (hide/show tools, members can manage tools \r\n[add-edit-delete] or view only)</span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(246, 246, 246); "><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(246, 246, 246); "><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(246, 246, 246); "><br></span></div><div style="font-weight: normal; text-align: left; "><span style="font-size: 11px; background-color: rgb(246, 246, 246); "><br></span></div></p></p></p></p>', NULL, 2012, 2012, 'Mr.Jamal', '4', '38,1', '39,41', 1, '02-10-2012');
  595.  
  596. -- --------------------------------------------------------
  597.  
  598. --
  599. -- Table structure for table `users`
  600. --
  601.  
  602. CREATE TABLE `users` (
  603. `id` int(11) NOT NULL auto_increment,
  604. `username` varchar(255) NOT NULL default '',
  605. `password` varchar(255) NOT NULL default '',
  606. `name` varchar(255) NOT NULL default '',
  607. `mob` varchar(255) NOT NULL,
  608. `tel` varchar(255) NOT NULL default '',
  609. `email` varchar(255) NOT NULL default '',
  610. `type` varchar(255) NOT NULL default '',
  611. `add_attachent` int(11) NOT NULL,
  612. `add_contact` int(11) NOT NULL,
  613. `add_deadlines` int(11) NOT NULL,
  614. `add_notes` int(11) NOT NULL,
  615. `add_investment` int(11) NOT NULL,
  616. PRIMARY KEY (`id`)
  617. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;
  618.  
  619. --
  620. -- Dumping data for table `users`
  621. --
  622.  
  623. INSERT INTO `users` VALUES (1, 'admin', 'admin', 'Administrator', '*******', '*******', 'admin@wesam.me', '1', 1, 1, 1, 1, 1);
  624. INSERT INTO `users` VALUES (38, 'Employee1', 'password', 'Employee1', '*********', '*********', 'Employee1@example.com', '2', 1, 1, 1, 1, 1);
  625. INSERT INTO `users` VALUES (39, 'Employee2', 'password', 'Employee2', '************', '************', 'Employee2@example.com', '2', 2, 2, 2, 2, 2);
  626. INSERT INTO `users` VALUES (41, 'Employee3', 'password', 'Employee3', '*********', '*********', 'Employee3@example.com', '2', 0, 0, 0, 0, 2);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!