-- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 23, 2009 at 03:55 PM -- Server version: 5.0.51 -- PHP Version: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `swelpixo_kele` -- -- -------------------------------------------------------- -- -- Table structure for table `all_careers` -- CREATE TABLE IF NOT EXISTS `all_careers` ( `id_all_careers` int(10) unsigned NOT NULL auto_increment, `id_all_user` tinyint(3) unsigned NOT NULL default '0', `category` varchar(100) NOT NULL default '', `careers_date` date NOT NULL default '0000-00-00', `careers_title` varchar(150) NOT NULL default '', `careers_intro` text NOT NULL, `careers_desc` text NOT NULL, `careers_photo` varchar(100) NOT NULL default '', `careers_onmain` binary(1) NOT NULL default '0', `careers_added_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id_all_careers`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `all_careers` -- -- -------------------------------------------------------- -- -- Table structure for table `all_news` -- CREATE TABLE IF NOT EXISTS `all_news` ( `id_all_news` int(10) unsigned NOT NULL auto_increment, `id_all_user` tinyint(3) unsigned NOT NULL default '0', `category` varchar(100) NOT NULL default '', `news_date` date NOT NULL default '0000-00-00', `news_title` varchar(150) NOT NULL default '', `news_intro` text NOT NULL, `news_desc` text NOT NULL, `news_photo` varchar(100) NOT NULL default '', `news_onmain` binary(1) NOT NULL default '0', `news_added_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id_all_news`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ; -- -- Dumping data for table `all_news` -- INSERT INTO `all_news` (`id_all_news`, `id_all_user`, `category`, `news_date`, `news_title`, `news_intro`, `news_desc`, `news_photo`, `news_onmain`, `news_added_date`) VALUES (28, 1, '', '2009-09-13', 'Kele News', 'This is going to be the introduction for kele news. A short description will go here.', 'This is where the full news for kele goes, a full detailed news can go here.', '09091310092535.jpg', '1', '2009-09-13 22:09:25'), (27, 1, 'Publications', '2009-07-08', 'Kele Launches its website', 'KELE CONTRACTING LAUNCHES ITS NEW WEBSITE', 'KELE CONTRACTING LAUNCHES ITS NEW WEBSITE', '09080701213579.jpg', '1', '2008-12-29 12:59:22'); -- -------------------------------------------------------- -- -- Table structure for table `all_user` -- CREATE TABLE IF NOT EXISTS `all_user` ( `id_all_user` int(11) unsigned NOT NULL auto_increment, `id_all_industry` tinyint(11) unsigned NOT NULL default '0', `username` varchar(100) NOT NULL default '', `password` varchar(100) NOT NULL default '', `email` varchar(100) NOT NULL default '', `fullname` varchar(255) NOT NULL default '', `lastlogin` datetime NOT NULL default '0000-00-00 00:00:00', `dateadded` datetime NOT NULL default '0000-00-00 00:00:00', `removable` binary(1) NOT NULL default '1', PRIMARY KEY (`id_all_user`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `all_user` -- INSERT INTO `all_user` (`id_all_user`, `id_all_industry`, `username`, `password`, `email`, `fullname`, `lastlogin`, `dateadded`, `removable`) VALUES (1, 0, 'administrator', 'adminkele', 'info@alkhaleejgroup.org', 'Administrator', '2009-11-23 14:06:02', '0000-00-00 00:00:00', '0'), (12, 4, 'aa', 'aa', '', 'aa', '2008-11-25 21:06:38', '2008-04-30 14:52:34', '1'); -- -------------------------------------------------------- -- -- Table structure for table `all_var` -- CREATE TABLE IF NOT EXISTS `all_var` ( `id_all_var` int(11) NOT NULL auto_increment, `var_name` varchar(100) NOT NULL default '', `var_value` text NOT NULL, `var_description` text NOT NULL, PRIMARY KEY (`id_all_var`), UNIQUE KEY `var_name` (`var_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ; -- -- Dumping data for table `all_var` -- INSERT INTO `all_var` (`id_all_var`, `var_name`, `var_value`, `var_description`) VALUES (1, 'texts_photo_width', '350', 'Images width of all the pages that contains only a text and photo'), (2, 'texts_photo_height', '350', 'Images height of all the pages that contains only a text and photo'), (3, 'texts_thumb_width', '104', 'Thumbs width of all the pages that contains only a text and photo. Will be used only in the CMS.'), (4, 'texts_thumb_height', '86', 'Thumbs height of all the pages that contains only a text and photo. Will be used only in the CMS.'), (5, 'news_img_width', '400', 'Width of the image that appears in the news section'), (6, 'news_img_height', '280', 'Height of the image that appears in the news section'), (7, 'news_thumb_width', '100', 'Width of the thumbnail that appears in the news listing'), (8, 'news_thumb_height', '70', 'Height of the thumbnail that appears in the news listing'), (9, 'gallery_img_width', '955', 'galleryp image width'), (10, 'gallery_img_height', '648', 'galleryp image height'), (11, 'gallery_thumb_width', '79', 'galleryp thumbnail width'), (12, 'gallery_thumb_height', '53', 'galleryp thumbnail height'), (13, 'publication_img_width', '400', 'publication imgage width'), (14, 'publication_img_height', '280', 'publication imgage width'), (15, 'publication_thumb_width', '100', 'publication thumb width'), (16, 'publication_thumb_height', '70', 'publication thumb height'); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE IF NOT EXISTS `category` ( `id_category` int(10) NOT NULL auto_increment, `category` varchar(100) NOT NULL default '', PRIMARY KEY (`id_category`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id_category`, `category`) VALUES (1, '1st category'), (2, '2nd category'); -- -------------------------------------------------------- -- -- Table structure for table `client` -- CREATE TABLE IF NOT EXISTS `client` ( `id_client` int(10) unsigned NOT NULL auto_increment, `id_all_user` tinyint(3) unsigned NOT NULL default '0', `client_date` date NOT NULL default '0000-00-00', `client` varchar(150) NOT NULL default '', `client_photo` varchar(100) NOT NULL default '', `url` varchar(100) NOT NULL default '', `text` varchar(255) NOT NULL default '', `client_added_date` datetime NOT NULL default '0000-00-00 00:00:00', `all_news_priority` int(11) NOT NULL default '0', PRIMARY KEY (`id_client`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `client` -- INSERT INTO `client` (`id_client`, `id_all_user`, `client_date`, `client`, `client_photo`, `url`, `text`, `client_added_date`, `all_news_priority`) VALUES (9, 0, '0000-00-00', 'Hydra', 'Hydra-Logo.jpg', 'www.hydraproperties.com/', '', '0000-00-00 00:00:00', 10), (10, 0, '0000-00-00', 'National Engineering Bureau', 'neb.jpg', 'www.neb.ae', '', '0000-00-00 00:00:00', 0), (11, 0, '0000-00-00', 'Mazaya', 'mazaya.jpg', 'www.mazayarealestate.com', '', '0000-00-00 00:00:00', 0), (12, 0, '0000-00-00', 'Mizin', 'Mizin-B-logo-E-A-copy.jpg', 'mizin.ae', '', '0000-00-00 00:00:00', 0); -- -------------------------------------------------------- -- -- Table structure for table `country` -- CREATE TABLE IF NOT EXISTS `country` ( `id_country` int(11) NOT NULL auto_increment, `country` varchar(40) NOT NULL default '', PRIMARY KEY (`id_country`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=761 ; -- -- Dumping data for table `country` -- INSERT INTO `country` (`id_country`, `country`) VALUES (756, 'Dubai'); -- -------------------------------------------------------- -- -- Table structure for table `financials` -- CREATE TABLE IF NOT EXISTS `financials` ( `id_financials` int(10) NOT NULL auto_increment, `financials_title` varchar(100) NOT NULL default '', `financials_pdf` varchar(100) NOT NULL default '', `id_all_user` tinyint(3) NOT NULL default '0', `financials_added_date` datetime NOT NULL default '0000-00-00 00:00:00', `financials_date` date NOT NULL default '0000-00-00', PRIMARY KEY (`id_financials`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ; -- -- Dumping data for table `financials` -- INSERT INTO `financials` (`id_financials`, `financials_title`, `financials_pdf`, `id_all_user`, `financials_added_date`, `financials_date`) VALUES (4, 'tttt', '0902171149562726.txt', 1, '2009-02-17 11:49:56', '2009-02-17'), (6, 'vvvv', '0902171237342966.txt', 1, '2009-02-17 12:37:34', '2009-02-17'), (7, 'ddd', '090217123956829.txt', 1, '2009-02-17 12:39:56', '2009-02-17'), (8, 'zzzz', '0902171241552975.txt', 1, '2009-02-17 12:41:55', '2009-02-17'), (9, 'xxxx', '0902171242000902.txt', 1, '2009-02-17 12:42:00', '2009-02-17'), (10, 'cccc', '0902171242055219.txt', 1, '2009-02-17 12:42:05', '2009-02-17'), (11, 'vvvvv', '0902171242135857.txt', 1, '2009-02-17 12:42:13', '2009-02-17'), (12, 'bbbbb', '0902171242190175.txt', 1, '2009-02-17 12:42:19', '2009-02-17'), (13, 'qewg', '0902170523024346.txt', 1, '2009-02-17 17:23:02', '2009-02-17'), (14, 'qegrg', '0902170523085787.txt', 1, '2009-02-17 17:23:08', '2009-02-17'), (15, 'gfkjyfu', '0902170523130986.txt', 1, '2009-02-17 17:23:13', '2009-02-17'); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE IF NOT EXISTS `gallery` ( `id_gallery` int(10) NOT NULL auto_increment, `id_all_news` int(10) NOT NULL default '0', `title` varchar(100) NOT NULL default '', `photo` varchar(100) NOT NULL default '', PRIMARY KEY (`id_gallery`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `gallery` -- -- -------------------------------------------------------- -- -- Table structure for table `galleryp` -- CREATE TABLE IF NOT EXISTS `galleryp` ( `id_gallery` int(10) NOT NULL auto_increment, `id_project` int(10) NOT NULL default '0', `id_all_user` tinyint(3) NOT NULL default '0', `gallery_title` varchar(100) NOT NULL default '', `gallery_photo` varchar(100) NOT NULL default '', `gallery_added_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id_gallery`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=98 ; -- -- Dumping data for table `galleryp` -- INSERT INTO `galleryp` (`id_gallery`, `id_project`, `id_all_user`, `gallery_title`, `gallery_photo`, `gallery_added_date`) VALUES (22, 15, 1, 'bbb', '0902101141422117.gif', '2009-02-10 11:41:42'), (23, 15, 1, 'ew', '0902101238001004.jpg', '2009-02-10 12:38:00'), (16, 15, 1, 'kurul', '081218053050994.jpg', '2008-12-18 17:30:50'), (8, 15, 1, '444', '0812171112015914.jpg', '2008-12-17 11:11:36'), (15, 15, 1, 'q54y54w', '0812180530424131.jpg', '2008-12-18 17:30:43'), (11, 15, 3, 'was', '0812171113432793.jpg', '2008-12-17 11:13:43'), (25, 15, 1, 'hk', '0902101239594839.jpg', '2009-02-10 12:39:59'), (26, 15, 1, 'kiutgl', '0902101240061097.jpg', '2009-02-10 12:40:06'), (27, 15, 1, 'bbb', '0902101240171773.jpg', '2009-02-10 12:40:17'), (45, 33, 1, 'Beau Monde', '09102301042563.jpg', '2009-10-23 12:24:18'), (44, 33, 1, 'Beau Monde', '09102301031411.jpg', '2009-10-23 12:23:35'), (43, 33, 1, 'Beau Monde', '09102301025563.jpg', '2009-10-23 12:22:34'), (31, 31, 1, 'QUEUE POINT', '0908070128349511.jpg', '2009-08-07 13:28:35'), (32, 31, 1, 'QUEUE POINT', '0908070128412011.jpg', '2009-08-07 13:28:41'), (33, 31, 1, 'QUEUE POINT', '0908070128497168.jpg', '2009-08-07 13:28:50'), (34, 31, 1, 'QUEUE POINT', '0908070128585605.jpg', '2009-08-07 13:28:59'), (35, 31, 1, 'QUEUE POINT', '0908070129088886.jpg', '2009-08-07 13:29:09'), (36, 31, 1, 'QUEUE POINT', '090807012917748.jpg', '2009-08-07 13:29:18'), (37, 31, 1, 'QUEUE POINT', '0908070129246074.jpg', '2009-08-07 13:29:25'), (38, 31, 1, 'QUEUE POINT', '0908070129312949.jpg', '2009-08-07 13:29:31'), (42, 33, 1, 'Beau Monde', '09102301024057.jpg', '2009-10-23 12:22:11'), (41, 33, 1, 'Beau Monde', '09102301021914.jpg', '2009-10-23 12:21:13'), (46, 33, 1, 'Beau Monde', '09102301004626.jpg', '2009-10-23 12:24:39'), (47, 34, 1, 'Newington', '09102301062768.jpg', '2009-10-23 13:06:27'), (48, 34, 1, 'Newington', '09102301065881.jpg', '2009-10-23 13:06:59'), (49, 34, 1, 'Newington', '09102301085088.jpg', '2009-10-23 13:08:04'), (50, 34, 1, 'Newington', '09102301091133.jpg', '2009-10-23 13:09:12'), (51, 35, 1, 'Walsh bay waterfront apartments', '09102301161407.jpg', '2009-10-23 13:16:14'), (52, 35, 1, 'Walsh bay waterfront apartments', '09102301172599.jpg', '2009-10-23 13:17:27'), (53, 35, 1, 'Walsh bay waterfront apartments', '09102301220146.jpg', '2009-10-23 13:22:02'), (54, 35, 1, 'Walsh bay waterfront apartments', '09102301221741.jpg', '2009-10-23 13:22:17'), (55, 36, 1, 'AL DUAA MARINA TOWER', '0910260150597.jpg', '2009-10-26 13:51:00'), (56, 37, 1, 'HYDRA TOWERS ', '09102602192267.jpg', '2009-10-26 14:19:23'), (88, 37, 1, 'MAIN', '09111109261822.png', '2009-11-11 09:26:19'), (89, 43, 1, 'Dubai Marine', '09111110251715.jpg', '2009-11-11 10:25:18'), (59, 37, 1, 'Hydra Towers', '09102811044336.jpg', '2009-10-28 11:04:45'), (87, 36, 1, 'MIAN', '09111108330318.jpg', '2009-11-11 08:33:04'), (61, 36, 1, 'AL DUAA MARINA TOWER', '09102811081263.jpg', '2009-10-28 11:08:13'), (62, 36, 1, 'AL DUAA MARINA TOWER', '09102811084506.jpg', '2009-10-28 11:08:45'), (63, 38, 1, 'PROMOSEVEN TOWER', '09102811110766.jpg', '2009-10-28 11:11:08'), (64, 38, 1, 'PROMOSEVEN TOWER', '0910281112022.jpg', '2009-10-28 11:12:02'), (65, 38, 1, 'PROMOSEVEN TOWER', '09102811122411.jpg', '2009-10-28 11:12:25'), (66, 38, 1, 'PROMOSEVEN TOWER', '09102811125728.jpg', '2009-10-28 11:12:58'), (67, 39, 1, 'Corporate Tower', '09102811192961.jpg', '2009-10-28 11:19:30'), (68, 40, 1, 'Enshaa Labour Camp', '09102811222266.jpg', '2009-10-28 11:22:23'), (69, 41, 1, 'Ettalong Beach Resort', '09102811235158.jpg', '2009-10-28 11:23:52'), (70, 41, 1, 'Ettalong Beach Resort', '09102811242691.jpg', '2009-10-28 11:24:27'), (71, 41, 1, 'Ettalong Beach Resort', '09102811250479.jpg', '2009-10-28 11:25:05'), (72, 41, 1, 'Ettalong Beach Resort', '09102811261455.jpg', '2009-10-28 11:26:14'), (73, 42, 1, 'Velodrome', '09102811273093.jpg', '2009-10-28 11:27:31'), (74, 42, 1, 'Velodrome', '09102811282803.jpg', '2009-10-28 11:28:28'), (75, 42, 1, 'Velodrome', '09102811285672.jpg', '2009-10-28 11:28:57'), (76, 42, 1, 'Velodrome', '09102811292693.jpg', '2009-10-28 11:29:27'), (77, 42, 1, 'Velodrome', '09102811294394.jpg', '2009-10-28 11:29:44'), (78, 43, 1, 'DUBAI MARINA', '09102811375323.jpg', '2009-10-28 11:37:54'), (79, 43, 1, 'DUBAI MARINA', '09102811385832.jpg', '2009-10-28 11:38:59'), (80, 43, 1, 'DUBAI MARINA', '09102811395665.jpg', '2009-10-28 11:39:57'), (81, 44, 1, 'Main', '09110901144364.jpg', '2009-11-09 13:14:45'), (82, 45, 1, 'Office Building', '09110901202982.jpg', '2009-11-09 13:20:31'), (97, 46, 1, '1', '09112302073144.jpg', '2009-11-23 14:07:32'), (84, 46, 1, 'RP 2', '0911090124258.jpg', '2009-11-09 13:24:26'), (85, 46, 1, 'RP 3', '09110901244798.jpg', '2009-11-09 13:24:48'), (90, 43, 1, 'Dubai Marine', '09111110270781.jpg', '2009-11-11 10:27:09'), (91, 43, 1, 'Dubai Marina', '09111110295851.jpg', '2009-11-11 10:30:00'), (92, 43, 1, 'Dubai Marina', '09111110304482.jpg', '2009-11-11 10:30:46'), (93, 43, 1, 'Dubai Marina', '09111110321867.jpg', '2009-11-11 10:32:20'), (94, 43, 1, 'Dubai Marina', '09111110365119.jpg', '2009-11-11 10:36:51'), (95, 43, 1, 'Dubai Marina', '0911111037486.jpg', '2009-11-11 10:37:50'); -- -------------------------------------------------------- -- -- Table structure for table `pdf` -- CREATE TABLE IF NOT EXISTS `pdf` ( `id_pdf` int(10) NOT NULL auto_increment, `id_all_news` int(10) NOT NULL default '0', `title` varchar(100) NOT NULL default '', `pdf` varchar(100) NOT NULL default '', PRIMARY KEY (`id_pdf`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `pdf` -- -- -------------------------------------------------------- -- -- Table structure for table `pdfp` -- CREATE TABLE IF NOT EXISTS `pdfp` ( `id_pdf` int(10) NOT NULL auto_increment, `id_project` int(10) NOT NULL default '0', `title` varchar(100) NOT NULL default '', `pdf` varchar(100) NOT NULL default '', PRIMARY KEY (`id_pdf`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `pdfp` -- -- -------------------------------------------------------- -- -- Table structure for table `project` -- CREATE TABLE IF NOT EXISTS `project` ( `id_project` int(10) NOT NULL auto_increment, `project_title` varchar(100) NOT NULL default '', `project_photo` varchar(100) NOT NULL default '', `project_desc` text NOT NULL, `project_pdf` varchar(100) NOT NULL default '', `id_all_user` tinyint(3) NOT NULL default '0', `project_added_date` datetime NOT NULL default '0000-00-00 00:00:00', `project_date` date NOT NULL default '0000-00-00', `id_status` int(10) NOT NULL default '0', `id_category` int(10) NOT NULL default '0', `id_type` int(10) NOT NULL default '0', `id_country` int(10) NOT NULL default '0', PRIMARY KEY (`id_project`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=48 ; -- -- Dumping data for table `project` -- INSERT INTO `project` (`id_project`, `project_title`, `project_photo`, `project_desc`, `project_pdf`, `id_all_user`, `project_added_date`, `project_date`, `id_status`, `id_category`, `id_type`, `id_country`) VALUES (33, 'Beau monde - Sydney', '09102312195646.jpg', 'Client: Multiplex Constructions
\r\nProject: 6 Level Basement Car Park, 40 Storey Residential Tower', '', 1, '2009-10-23 12:19:56', '2009-10-23', 2, 0, 0, 756), (34, 'Newington - Sydney', '09102301052772.jpg', 'Client: Mirvac Constructions
\r\nProject: Basement Car Park, 4 Level Residential Unit Buildings', '', 1, '2009-10-23 13:05:27', '2009-10-23', 2, 0, 0, 756), (35, 'Walsh bay waterfront apartments - Sydney', '09102301110927.jpg', 'Client: Mirvac Constructions
\r\nProject: 5 Level Car Park, 7 Level and 9 Level Low Rise Luxury Residential Towers', '', 1, '2009-10-23 13:11:09', '2009-10-23', 2, 0, 0, 756), (36, 'AL DUAA MARINA TOWER - DUBAI', '09102601481722.jpg', '\r\n\r\n\r\n\r\n\r\n\r\nClient: Al Duaa Holdings
\r\nConsultant: Dimensions Engineering Consultants
\r\nProject: - 24 Storey Residential & 2 Level Basement Car park
\r\nCommence: May 2009
\r\nContract Duration : 20 Months', '', 1, '2009-10-26 13:48:17', '2009-10-26', 2, 0, 0, 756), (31, 'Queue Point - DUBAI', '090807012814248.jpg', '\r\n\r\n\r\n
Client: AL MAZAYA REAL ESTATE
\r\n
Consultant: National Engineering Bureau
\r\n
Project: 22 Residential Buildings (G+5 to G+10)
\r\n
Commence: May 2009
\r\nContract Duration: 24 Months', '', 1, '2009-08-07 13:12:13', '2009-05-01', 1, 0, 0, 756), (37, 'HYDRA TOWERS - DUBAI', '09102602105191.jpg', '\r\n\r\n\r\n\r\n\r\n\r\nClient: Hydra Properties
\r\nConsultant: National Engineering Bureau
\r\nProject: - 38 Storey Commercial Tower, 4 Level podium and 6 Level Basement
\r\nCommence: June 2009
\r\nContract Duration : 29 Months', '', 1, '2009-10-26 14:10:52', '2009-10-26', 2, 0, 0, 756), (38, 'PROMOSEVEN TOWER - DUBAI', '09102602284131.jpg', '\r\n\r\n\r\n\r\n\r\n\r\nClient: Promoseven Media Group
\r\nConsultant: National Engineering Bureau
\r\nProject: - 14 Storey Commercial Tower and 4 Level Basement
\r\nCommence: APRIL 2009
\r\nContract Duration : 24 Months', '', 1, '2009-10-26 14:28:41', '2009-10-26', 2, 0, 0, 756), (39, 'Corporate Tower - DUBAI', '09102811174092.jpg', '
Location: Jumeirah Lakes Towers
\r\nClient: SHEFFIELD INVESTMENTS LLC
\r\n
Consultant: NEB Consultants
\r\n
Project: - 49 Storey Commercial & Podium & 4 Basement Car park
\r\n
Status: Ongoing
', '', 1, '2009-10-28 11:17:41', '2009-10-28', 2, 0, 0, 756), (40, 'Enshaa Labour Camp - DUBAI', '0910281118563.jpg', '
Location: JEBEL ALI
\r\n
Client: ENSHAA PJSC
\r\n
Consultant: TNQ ARCHITECTS
\r\n
Project: - 3 off G+4+Roof Labour Accommodation
\r\n
Commence: JUNE 09
', '', 1, '2009-10-28 11:18:56', '2009-10-28', 2, 0, 0, 756), (41, 'Ettalong Beach Resort - Sydney', '09102811221213.jpg', 'Location: Ettalong, Central Coast NSW
\r\nClient : Austress Freyssine
\r\nProject : Basement car park, 7 storey hotel apartments
\r\nStatus: Completed', '', 1, '2009-10-28 11:22:12', '2009-10-28', 2, 0, 0, 756), (42, 'Velodrome - Sydney', '09102811265642.jpg', 'Location: Homebush Bay, Sydney
\r\nClient : Concrete Constructions Group
\r\nProject : Cycling Track, Stadium Seating, Auditorium, Kiosk and Amenities
\r\nStatus Completed', '', 1, '2009-10-28 11:26:56', '2009-10-28', 2, 0, 0, 756), (43, 'Marina Promenade - DUBAI', '09102811363953.jpg', 'Client: NASA MULTIPLEX / EMAAR PROPERTIES
\r\nConsultant:ARIF AND BINTOAK Consultants
\r\nProject: - 6x 35-48 Storey RESIDENTIAL Towers & Podium
\r\nCommence:COMPLETED
\r\nContract Duration : 28 Months', '', 1, '2009-10-28 11:36:39', '2009-10-28', 2, 0, 0, 756), (44, 'Fortune Serene - DUBAI', '09110901062975.jpg', '

Location: International Media Production Zone
\r\nClient : Fortune Group
\r\nConsultant : Adnan Saffarini
\r\nProject : 2 x 18 Storey Residential
\r\nCommence: ONGOING

', '', 1, '2009-11-09 13:06:30', '2009-11-09', 2, 0, 0, 756), (45, 'Office Building - DUBAI', '09110901194471.jpg', '
Location:  AL BARSHA  
\r\n
Client: AL NAKHEEL INVESTMENTS LLC
\r\n
Consultant: CCE Consultants
\r\n
Project: - 2 off 2B+G+6+Roof Commercial
\r\n
Commence: ONGOING
', '', 1, '2009-11-09 13:19:44', '2009-11-09', 2, 0, 0, 756), (46, 'Regent Place - Sydney', '09110901252797.jpg', 'Location: George Street, Sydney
\r\nClient: Multiplex Group
\r\nDetails: 9 Level Underground Car Park, 48 Level Residential, 33 Level Serviced Apartment Tower
\r\nStatus: COMPLETED', '', 1, '2009-11-09 13:22:58', '2009-11-09', 2, 0, 0, 756); -- -------------------------------------------------------- -- -- Table structure for table `publication` -- CREATE TABLE IF NOT EXISTS `publication` ( `id_publication` int(10) unsigned NOT NULL auto_increment, `id_all_user` tinyint(3) unsigned NOT NULL default '0', `publication_date` date NOT NULL default '0000-00-00', `publication_title` varchar(150) NOT NULL default '', `publication_intro` text NOT NULL, `publication_desc` text NOT NULL, `publication_photo` varchar(100) NOT NULL default '', `publication_onmain` binary(1) NOT NULL default '0', `publication_added_date` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id_publication`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `publication` -- INSERT INTO `publication` (`id_publication`, `id_all_user`, `publication_date`, `publication_title`, `publication_intro`, `publication_desc`, `publication_photo`, `publication_onmain`, `publication_added_date`) VALUES (2, 1, '2008-12-29', 'pp', '

pp

', '

pp

', '', '1', '2008-12-29 11:40:06'); -- -------------------------------------------------------- -- -- Table structure for table `status` -- CREATE TABLE IF NOT EXISTS `status` ( `id_status` int(10) NOT NULL auto_increment, `status` varchar(100) NOT NULL default '', PRIMARY KEY (`id_status`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `status` -- INSERT INTO `status` (`id_status`, `status`) VALUES (1, 'Current Project'), (2, 'Completed Project'); -- -------------------------------------------------------- -- -- Table structure for table `type` -- CREATE TABLE IF NOT EXISTS `type` ( `id_type` int(10) NOT NULL auto_increment, `type` varchar(100) NOT NULL default '', PRIMARY KEY (`id_type`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `type` -- INSERT INTO `type` (`id_type`, `type`) VALUES (1, '1st type'), (2, '2nd type');