-- MySQL dump 10.7 -- -- Host: localhost Database: vas2 -- ------------------------------------------------------ -- Server version 5.0.1-alpha-nt /*!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 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */; -- -- Table structure for table `links` -- DROP TABLE IF EXISTS `links`; CREATE TABLE `links` ( `id` int(3) NOT NULL auto_increment, `linkname` varchar(50) NOT NULL default '', `position` smallint(2) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `links` -- /*!40000 ALTER TABLE `links` DISABLE KEYS */; LOCK TABLES `links` WRITE; INSERT INTO `links` VALUES (1,'Home',1),(2,'Services',2),(3,'Products',3),(4,'Value Proposition',4),(5,'About Us',5); UNLOCK TABLES; /*!40000 ALTER TABLE `links` ENABLE KEYS */; -- -- Table structure for table `newscontent` -- DROP TABLE IF EXISTS `newscontent`; CREATE TABLE `newscontent` ( `id` int(3) NOT NULL auto_increment, `newsbody` text, `priority` enum('Lastest','New','Old') default 'Lastest', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `newscontent` -- /*!40000 ALTER TABLE `newscontent` DISABLE KEYS */; LOCK TABLES `newscontent` WRITE; INSERT INTO `newscontent` VALUES (1,'Fleet Manager
Fleet Manager, is a portal solution that provide a comprehensive closed-loop workflow management system for Fleet / Logistics Organization.','Lastest'),(2,'Contact Numbers
Mobile : (234) - 802-561-9867,
D/Line : (234) -1-436-2897','Lastest'),(3,'Vas HR
Introducing Vas HR, a portal based Human Resource Application, is to be released soon!','Lastest'); UNLOCK TABLES; /*!40000 ALTER TABLE `newscontent` ENABLE KEYS */; -- -- Table structure for table `sublink` -- DROP TABLE IF EXISTS `sublink`; CREATE TABLE `sublink` ( `id` int(3) NOT NULL auto_increment, `parentid` int(3) NOT NULL default '0', `linkname` varchar(50) NOT NULL default '', `linkbody` text, `picturepath` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `sublink` -- /*!40000 ALTER TABLE `sublink` DISABLE KEYS */; LOCK TABLES `sublink` WRITE; INSERT INTO `sublink` VALUES (1,2,'Technology Consulting & Systems Integration','Technology Consulting & Systems Integration
\r\n
\r\nVAS technology consulting and integration services are designed to optimize its clients\' productivity through the selection and implementation of technologies best suited to the client\'s structure and mode of operation. We also provide solutions for customers who have an already existing technology investment but who need to extract more value from these investments. The scope of our operations includes customer readiness assessment, business process re-engineering, solution development/deployment/optimization, change management, project management and support. To achieve this, VAS provides technology consulting services in two broad areas:
\r\n
\r\nVendor Specific Solutions:
\r\n
\r\nOur commitment to delivering high value to our clients has led us to develop a high level of proficiency in an array of industry leading enterprise solutions thereby enabling us to respond appropriately to our clients\' requirements, budget and expectations. These solutions include:
\r\n
\r\nSiebel CRM (Call Center and eFinancials, sales force automation), Microsoft CRM, Crixp OpenCRX, Oracle Portal and Application Server, JBoss Enterprise Stack, IBM WebSphere and MQSeries, Microsoft Sharepoint Portal and SocketWorks (CRM, HR, College Management) and QuickBooks.
\r\n
\r\nCustomised Solutions:
\r\n
\r\nSometimes, certain client constraints, such as budget limits or even the uniqueness of the need, preclude the need for a vendor-specific product. In anticipation of this, Value Added Solution has invested in the development of a standards-based Java and MDA-based solutions framework for the delivery of custom business solutions. In line with our commitment to deliver high value to our clients, we develop and implement custom solutions for clients where we find that available vendor solutions do not meet their exact needs.
\r\n
\r\nOur framework enables us not only to develop and deploy custom solutions but also to integrate, through a plethora of interfaces, with diverse systems. The solution is designed to reduce the cost of software management by employing centralized deployment architecture while at the same time providing ubiquitous access within and outside the enterprise.','pic2_plain.jpg'),(2,2,'Skill Outsourcing','Skill Outsourcing
\r\n
\r\nThe depth and scope of our experience in the Enterprise Solutions Delivery industry in Nigeria have enabled us to develop a vast network of skilled manpower in the area of enterprise solutions delivery. We cater to our clients/partners resource needs through the provision of resources from a pool of skilled contract and full-time specialists. These resources are available on an outsourced basis and provide our clients with unfettered access to business and technical expertise in a flexible manner.','pic2_plain.jpg'),(3,3,'School Web Services','School Web Services
\r\n
\r\nSchoolWeb Services is a turnkey solution targeted at the school management requirements of educational institutions. Based on the award-winning SocketWorks CollegePortal solution, it allows all the role-players in an educational institution (administrative staff, teachers and students) use the Internet as a platform to perform a wide range of activities such as course registration, results checking and computation, fees payments, assignments and borrowing books from the library.
\r\n
\r\nThe CollegePortal® platform provides an open and modular architecture platform enabling academic institutions to connect and integrate their processes, applications and information repositories. It provides content management, security, personalization in a unified framework and supports standard protocols (SSL http, https, IIOP) and languages including Java, Java Script, Html, XML, J2EE).
\r\n
\r\nBy using the Internet as a platform for delivery, it ensures ubiquitous access to all and helps to facilitate effective and efficient communication by providing a devise for School Information Storage and Exchange.
\r\n
\r\nAs a SocketWorks Enterprise partner, we have developed a range of services around SocketWorks cPortal and CollegePortal solutions designed to maximise the utility of the platform. This range of services is known as SchoolWeb Services.
\r\n
\r\nThe range of these services include:\r\n','pic3_plain.jpg'),(4,3,'CRMx','CRMx
\r\n
\r\nCRMx is a standards-based application for managing relationships across the enterprise and across all involved applications built from foundation on a Model Driven Architecture. CRMx enables organizations to integrate all customer activities with their business processes and systems. CRMx is vendor and platform independent, scalable and flexible.
\r\n
\r\nEconomics
\r\n
\r\nVAS understands that making TCO (total cost of ownership) work for you is essential in today\'s economy. Business leaders insist on rapid return on investment (ROI). That is why VAS developed CRMx to set an industry standard in CRM (Customer Relationship Management).
\r\n
\r\nWhile typical CRM solutions require substantial upfront investment, CRMx provides a full-blown CRM solution, ready to install at a reasonable cost. The highest possible ROI is delivered almost immediately right out of the box.
\r\n
\r\nOpen Standards CRM Application
\r\n
\r\n•  Vendor and Platform Independent
\r\n
\r\n•  Flexible and Scalable
\r\n
\r\n•  Interoperable and Extensible
\r\n
\r\n•  State of the Art Technology
\r\n
\r\nFlexibility & Scalability
\r\n
\r\nCRMx is a platform and vendor independent CRM solution based on open standards like J2EE, MDA (Model Driven Architecture) and openMDX. This means that you can deploy it on any platform, such as Windows, Unix or Linux, and expect identical behaviour and performance from the application. It also means that you can leverage the open structure or the application to extend and customize CRMx as your needs and requirements evolve.
\r\n
\r\nBeing browser-based means that you can take full advantage of centralized, one-time only and client-platform neutral deployments to keep the Total Cost of Ownership down.
\r\n
\r\nThe modular architecture of CRMx enables easy integration with your existing applications (e.g. Siebel, SalesForce and individual solutions based on IBM hosts, etc.). With CRMx you maximize your ROI by investing in a business solution based on open standards rather than acquiring vendor specific or proprietary technology.
\r\n
\r\nComponents
\r\n
\r\nCRMx is an online customer relationship management application designed for organizations requiring multifunctional, enterprise-wide coordination of sales processes including lead and opportunity management, quotes, sales orders and invoices, marketing and service activities to customers, partners, suppliers or intermediaries.','pic3_plain.jpg'),(5,4,'Value Proposition','Value Proposition
\r\n
\r\nOur focus is to create value by the strategic and cost-effective application of technology to the client\'s business mechanisms. By basing our solutions on open standards and by building a long lasting relationship with our customers through real-time support, we reduce the total cost of ownership of our solutions and enable our clients to develop a high level of confidence in the use of our technology, thereby ensuring increased productivity and profits.','pic.gif'),(7,5,'About VAS','About VAS
\r\n
\r\nValue Added Solutions [VAS] is a technology company focused on Value Added Solutions Delivery in the Enterprise space and Information Technology Consulting. VAS draws from an experienced base of personnel whilst maintaining a personalized form of business liaison. The ultimate in consultation, skills diversity and adaptability to meet client expectations are the very strengths of VAS. It is based in Lagos , Nigeria and managed by a team of young professionals within and outside Nigeria who have acquired a vast wealth of relevant industry experience. We are positioned as key solution consultants, developing strategic relationships with core technology providers like Microsoft, Siebel and SocketWorks.
\r\n
\r\nAt VAS, our focus is to enable our customers achieve a competitive advantage by the strategic and cost-effective application of technological innovation to their business processes. Our solutions span a range of industry standards and platforms targeted at adding immediate value to the client. For this reason, our software solutions stack is based on J2EE and .NET , two platforms that are championed by industry leaders Microsoft and Sun Micro Systems. These solutions implement open standards such as XML and XML-Web-Services, HTTP, SOAP, JAAS, LDAP, IMAP and SMTP thereby allowing anyone to leverage and extend the underlying standards-based vision and architecture of our solutions. This puts us in the forefront of delivering today\'s best practice business application solutions.
\r\n
\r\nConsummate understandings of clients\' business processes underscored by extensive experience implementing technology solutions have gained us a strong positioning within the Nigerian enterprise market. Through best practices accumulated over many years of technology solutions provision and numerous full life-cycle enterprise implementations, the team at VAS has created an extensive portfolio of technology solutions and amassed a wealth of enterprise experience to address the business needs of our customers.','pic4_plain.jpg'),(9,5,'Contact Info','Contact Address
\r\n
\r\n Office address : Km 18/19 Lekki-Epe Expressway
\r\n                              Lagos, Lagos State, Nigeria.
\r\n
\r\nContact Numbers
\r\n
\r\nMobile:     (234) - 802-561-9867
\r\nD/Line:     (234) -1-436-2897 , (234) -1-762-4963','pic4_plain.jpg'),(10,3,'Fleet Manager','VAS FleetManager
\r\n
\r\nVAS FLEETMANAGER is a revolutionary web based fleet management solution built on VAS SystemX portal framework, because it provides a 360o degree view of your processes, it helps you react proactively in terms of fleet maintenance, minimizing unexpected, costly downtime and repairs. Proper, consistent preventive fleet maintenance helps you extend the useful life of your vehicles and other fleet assets.
\r\n
\r\nBusiness Intelligence
\r\n
\r\n With VAS FLEETMANAGER time spent on paperwork is drastically reduced, so that you can spend more time on your business processes, VAS FLEETMANAGER enables you to establish a proactive approach to fleet maintenance and management. It helps you avoid costly, unexpected break-fix scenarios and downtime due to neglected fleet vehicles and equipment. And it serves as a ready resource for fleet maintenance history, fuel usage, and all expenses associated with operating your fleet of motor vehicles and other assets.
\r\n
\r\nActive Reports
\r\n
\r\n Business reports can be viewed and certainly printed, they can also be exported to PDF file format and e-mailed to associates and business partners.','pic3_plain.jpg'),(11,3,'Vas HR','Vas HR

Vas HR a human resource application built upon the award winning Vas SystemX  Portal framework, is due for release at the end of the first quarter of 2007.','pic3_plain.jpg'); UNLOCK TABLES; /*!40000 ALTER TABLE `sublink` ENABLE KEYS */; -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `username` varchar(25) NOT NULL default '', `password` varchar(16) NOT NULL default '', PRIMARY KEY (`username`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `user` -- /*!40000 ALTER TABLE `user` DISABLE KEYS */; LOCK TABLES `user` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `user` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;