All times are UTC + 1 hour




Post new topic Reply to topic  [ 5 posts ] 
  Print view

IIS Error
Author Message
PostPosted: Mon Dec 12, 2011 7:35 am 
Offline

Joined: Mon Dec 12, 2011 7:26 am
Posts: 1
Hello guys,

I've been trying to install Achievo 1.4 on a mochahost hosted site, but the installation failed several time. The installation fails right after the the DB initialization process, with error 500 - Internal Server Error. The detailed error information contains shows that the error was caused by the FastCgiModule (notification ExecuteRequestHandler) with error code 0x80070102.
I was wondering, is this Achievo or Hosting provider related issue?
Thanks in front.

Best regards,
Vancho


Top
 Profile  
 

Re: IIS Error
PostPosted: Thu Dec 29, 2011 10:03 pm 
Regular
Offline

Joined: Thu Sep 30, 2010 2:45 pm
Posts: 464
Strange. What happens run a sql code and make the database by your self. And login trying to achievo by adding some info in it.

Here is the Sql the make the database:

Code:
-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 11 Mei 2011 om 19:53
-- Serverversie: 5.0.91
-- PHP-Versie: 5.2.17

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 */;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `accessright`
--

CREATE TABLE IF NOT EXISTS `accessright` (
  `node` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `action` varchar(25) character set utf8 collate utf8_bin NOT NULL,
  `role_id` int(10) NOT NULL,
  PRIMARY KEY  (`node`,`action`,`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `activity`
--

CREATE TABLE IF NOT EXISTS `activity` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `description` varchar(50) character set utf8 collate utf8_bin default NULL,
  `remarkrequired` int(1) default NULL,
  `overtimecompensation` int(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `atk_searchcriteria`
--

CREATE TABLE IF NOT EXISTS `atk_searchcriteria` (
  `nodetype` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `criteria` text NOT NULL,
  `handlertype` varchar(100) default NULL,
  `userid` int(11) default NULL,
  `is_for_all` smallint(1) default NULL,
  PRIMARY KEY  (`nodetype`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `contract`
--

CREATE TABLE IF NOT EXISTS `contract` (
  `id` int(10) NOT NULL,
  `contractnumber` varchar(20) character set utf8 collate utf8_bin default NULL,
  `contractname` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `contracttype` int(10) NOT NULL,
  `customer` int(10) NOT NULL,
  `billing_type` varchar(8) character set utf8 collate utf8_bin default NULL,
  `billing_period` varchar(17) character set utf8 collate utf8_bin NOT NULL,
  `period_price` decimal(15,2) default NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `term_of_notice` date default NULL,
  `aftercalculation` int(1) default NULL,
  `priceperhour` decimal(12,2) default NULL,
  `status` varchar(8) character set utf8 collate utf8_bin NOT NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `contracttype`
--

CREATE TABLE IF NOT EXISTS `contracttype` (
  `id` int(10) NOT NULL,
  `description` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_campaign`
--

CREATE TABLE IF NOT EXISTS `crm_campaign` (
  `id` int(10) NOT NULL,
  `title` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `type` int(10) default NULL,
  `status` int(10) default NULL,
  `start_date` date default NULL,
  `end_date` date default NULL,
  `budget` decimal(12,2) default NULL,
  `actual_cost` decimal(12,2) default NULL,
  `expected_revenue` decimal(12,2) default NULL,
  `expected_cost` decimal(12,2) default NULL,
  `objective` text,
  `description` text,
  `created_by` int(10) default NULL,
  `created_on` datetime default NULL,
  `last_modified_by` int(10) default NULL,
  `last_modified_on` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_campaign_status`
--

CREATE TABLE IF NOT EXISTS `crm_campaign_status` (
  `id` int(10) NOT NULL,
  `status_name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_campaign_type`
--

CREATE TABLE IF NOT EXISTS `crm_campaign_type` (
  `id` int(10) NOT NULL,
  `type_name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_eventlog`
--

CREATE TABLE IF NOT EXISTS `crm_eventlog` (
  `id` int(10) NOT NULL,
  `user_id` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `stamp` datetime NOT NULL,
  `node` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `action` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `primarykey` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `summary` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_former_name`
--

CREATE TABLE IF NOT EXISTS `crm_former_name` (
  `id` int(10) NOT NULL,
  `former_name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `account` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_industry`
--

CREATE TABLE IF NOT EXISTS `crm_industry` (
  `id` int(10) NOT NULL,
  `industry_name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_lead`
--

CREATE TABLE IF NOT EXISTS `crm_lead` (
  `id` int(10) NOT NULL,
  `lead` int(10) default NULL,
  `lead_description` text,
  `campaign` int(10) default NULL,
  `status` varchar(9) character set utf8 collate utf8_bin default NULL,
  `status_description` text,
  `title_id` int(10) default NULL,
  `lastname` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `firstname` varchar(50) character set utf8 collate utf8_bin default NULL,
  `initials` varchar(50) character set utf8 collate utf8_bin default NULL,
  `phone` varchar(20) character set utf8 collate utf8_bin default NULL,
  `cellular` varchar(20) character set utf8 collate utf8_bin default NULL,
  `fax` varchar(20) character set utf8 collate utf8_bin default NULL,
  `email` varchar(50) character set utf8 collate utf8_bin default NULL,
  `company` varchar(100) character set utf8 collate utf8_bin default NULL,
  `address` varchar(100) character set utf8 collate utf8_bin default NULL,
  `address2` varchar(100) character set utf8 collate utf8_bin default NULL,
  `zipcode` varchar(20) character set utf8 collate utf8_bin default NULL,
  `city` varchar(100) character set utf8 collate utf8_bin default NULL,
  `state` varchar(100) character set utf8 collate utf8_bin default NULL,
  `country` varchar(100) character set utf8 collate utf8_bin default NULL,
  `website` varchar(100) character set utf8 collate utf8_bin default NULL,
  `assigned_to` int(10) default NULL,
  `remark` text,
  `created_by` int(10) default NULL,
  `created_on` datetime default NULL,
  `last_modified_by` int(10) default NULL,
  `last_modified_on` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_organization_relation`
--

CREATE TABLE IF NOT EXISTS `crm_organization_relation` (
  `relation_id` int(10) NOT NULL,
  `account` int(10) default NULL,
  `relation_with` int(10) NOT NULL,
  `kind_of` int(10) NOT NULL,
  PRIMARY KEY  (`relation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_organization_status`
--

CREATE TABLE IF NOT EXISTS `crm_organization_status` (
  `id` int(10) NOT NULL,
  `status_name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_rate`
--

CREATE TABLE IF NOT EXISTS `crm_rate` (
  `id` int(10) NOT NULL,
  `rate_name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_relation_type`
--

CREATE TABLE IF NOT EXISTS `crm_relation_type` (
  `id` int(10) NOT NULL,
  `type_name` varchar(100) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `crm_source`
--

CREATE TABLE IF NOT EXISTS `crm_source` (
  `id` int(10) NOT NULL,
  `source_name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `db_sequence`
--

CREATE TABLE IF NOT EXISTS `db_sequence` (
  `seq_name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `nextid` int(10) NOT NULL,
  PRIMARY KEY  (`seq_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `deliverable`
--

CREATE TABLE IF NOT EXISTS `deliverable` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `project_id` int(10) NOT NULL,
  `duedate` date NOT NULL,
  `status` varchar(8) character set utf8 collate utf8_bin NOT NULL,
  `remind_days` int(10) default NULL,
  `userid` int(10) NOT NULL,
  `entrydate` date NOT NULL,
  `emailstatus` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `dependency`
--

CREATE TABLE IF NOT EXISTS `dependency` (
  `phaseid_row` int(10) NOT NULL,
  `phaseid_col` int(10) NOT NULL,
  PRIMARY KEY  (`phaseid_row`,`phaseid_col`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `docmanager_document`
--

CREATE TABLE IF NOT EXISTS `docmanager_document` (
  `id` int(10) NOT NULL,
  `documentcode` varchar(100) character set utf8 collate utf8_bin default NULL,
  `name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `filename` varchar(255) character set utf8 collate utf8_bin default NULL,
  `owner` varchar(100) character set utf8 collate utf8_bin default NULL,
  `master` varchar(100) character set utf8 collate utf8_bin default NULL,
  `master_id` int(10) default NULL,
  `entrydate` date default NULL,
  `version` varchar(100) character set utf8 collate utf8_bin default NULL,
  `status` varchar(8) character set utf8 collate utf8_bin default NULL,
  `confidential` int(1) default NULL,
  `internal` int(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `docmanager_documenttype`
--

CREATE TABLE IF NOT EXISTS `docmanager_documenttype` (
  `id` int(10) NOT NULL,
  `name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `template` varchar(255) character set utf8 collate utf8_bin default NULL,
  `master` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `docmanager_prjtpl_dt`
--

CREATE TABLE IF NOT EXISTS `docmanager_prjtpl_dt` (
  `projecttpl_id` int(10) NOT NULL,
  `documenttype_id` int(10) NOT NULL,
  PRIMARY KEY  (`projecttpl_id`,`documenttype_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `email_template`
--

CREATE TABLE IF NOT EXISTS `email_template` (
  `code` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `module` varchar(100) character set utf8 collate utf8_bin default NULL,
  `title` varchar(100) character set utf8 collate utf8_bin default NULL,
  `subject` varchar(100) character set utf8 collate utf8_bin default NULL,
  `plain_body` text,
  `html_body` text,
  `lastupdatedon` datetime default NULL,
  `lastupdatedby` int(10) default NULL,
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `employeerole`
--

CREATE TABLE IF NOT EXISTS `employeerole` (
  `employee_id` int(10) NOT NULL,
  `role_id` int(10) NOT NULL,
  PRIMARY KEY  (`employee_id`,`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `employee_department`
--

CREATE TABLE IF NOT EXISTS `employee_department` (
  `id` int(10) NOT NULL,
  `name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `functionlevel`
--

CREATE TABLE IF NOT EXISTS `functionlevel` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Stand-in structuur voor view `hours`
--
CREATE TABLE IF NOT EXISTS `hours` (
`id` int(10)
,`virtual_time` int(1)
,`activitydate` date
,`todate` date
,`userid` int(10)
,`phaseid` int(10)
,`activityid` int(10)
,`remark` text
,`time` int(10)
,`workperiod` int(10)
,`entrydate` date
);
-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `hoursbase`
--

CREATE TABLE IF NOT EXISTS `hoursbase` (
  `id` int(10) NOT NULL,
  `virtual_time` int(1) default NULL,
  `activitydate` date NOT NULL,
  `todate` date default NULL,
  `userid` int(10) NOT NULL,
  `phaseid` int(10) NOT NULL,
  `activityid` int(10) NOT NULL,
  `remark` text,
  `time` int(10) NOT NULL,
  `workperiod` int(10) default NULL,
  `entrydate` date NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `activitydate_idx` (`activitydate`),
  KEY `userid_idx` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `hours_lock`
--

CREATE TABLE IF NOT EXISTS `hours_lock` (
  `id` int(10) NOT NULL,
  `period` int(6) NOT NULL,
  `userid` int(10) default NULL,
  `approved` int(1) default NULL,
  `coordinator` varchar(100) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `mastergantt_colorconfig`
--

CREATE TABLE IF NOT EXISTS `mastergantt_colorconfig` (
  `id` int(10) NOT NULL,
  `hours_min` int(10) default NULL,
  `hours_max` int(10) default NULL,
  `color` varchar(10) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `organization`
--

CREATE TABLE IF NOT EXISTS `organization` (
  `id` int(10) NOT NULL,
  `organizationcode` varchar(100) character set utf8 collate utf8_bin default NULL,
  `name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `type` varchar(8) character set utf8 collate utf8_bin default NULL,
  `visit_address` varchar(100) character set utf8 collate utf8_bin default NULL,
  `visit_address2` varchar(100) character set utf8 collate utf8_bin default NULL,
  `visit_zipcode` varchar(20) character set utf8 collate utf8_bin default NULL,
  `visit_city` varchar(100) character set utf8 collate utf8_bin default NULL,
  `visit_state` varchar(100) character set utf8 collate utf8_bin default NULL,
  `visit_country` varchar(100) character set utf8 collate utf8_bin default NULL,
  `mail_address` varchar(100) character set utf8 collate utf8_bin default NULL,
  `mail_address2` varchar(100) character set utf8 collate utf8_bin default NULL,
  `mail_zipcode` varchar(20) character set utf8 collate utf8_bin default NULL,
  `mail_city` varchar(100) character set utf8 collate utf8_bin default NULL,
  `mail_state` varchar(100) character set utf8 collate utf8_bin default NULL,
  `mail_country` varchar(100) character set utf8 collate utf8_bin default NULL,
  `invoice_address` varchar(100) character set utf8 collate utf8_bin default NULL,
  `invoice_address2` varchar(100) character set utf8 collate utf8_bin default NULL,
  `invoice_zipcode` varchar(20) character set utf8 collate utf8_bin default NULL,
  `invoice_city` varchar(100) character set utf8 collate utf8_bin default NULL,
  `invoice_state` varchar(100) character set utf8 collate utf8_bin default NULL,
  `invoice_country` varchar(100) character set utf8 collate utf8_bin default NULL,
  `phone` varchar(20) character set utf8 collate utf8_bin default NULL,
  `fax` varchar(20) character set utf8 collate utf8_bin default NULL,
  `email` varchar(50) character set utf8 collate utf8_bin default NULL,
  `website` varchar(100) character set utf8 collate utf8_bin default NULL,
  `bankaccount` varchar(30) character set utf8 collate utf8_bin default NULL,
  `bankaccount2` varchar(30) character set utf8 collate utf8_bin default NULL,
  `bankaccount3` varchar(30) character set utf8 collate utf8_bin default NULL,
  `bankaccount4` varchar(30) character set utf8 collate utf8_bin default NULL,
  `vatnumber` varchar(25) character set utf8 collate utf8_bin default NULL,
  `debtornumber` varchar(30) character set utf8 collate utf8_bin default NULL,
  `member_of` int(10) default NULL,
  `status` int(10) default NULL,
  `source` int(10) default NULL,
  `industry` int(10) default NULL,
  `employees` int(5) default NULL,
  `revenue` varchar(5) character set utf8 collate utf8_bin default NULL,
  `rate` int(10) default NULL,
  `assigned_to` int(10) default NULL,
  `remark` text,
  `created_by` int(10) default NULL,
  `created_on` datetime default NULL,
  `last_modified_by` int(10) default NULL,
  `last_modified_on` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `overtime_balance`
--

CREATE TABLE IF NOT EXISTS `overtime_balance` (
  `id` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  `day` date NOT NULL,
  `balance` decimal(12,2) NOT NULL,
  `manual` varchar(100) character set utf8 collate utf8_bin default NULL,
  `remark` text,
  PRIMARY KEY  (`id`),
  KEY `userid_idx` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `person`
--

CREATE TABLE IF NOT EXISTS `person` (
  `id` int(10) NOT NULL,
  `title_id` int(10) default NULL,
  `userid` varchar(15) character set utf8 collate utf8_bin default NULL,
  `lastname` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `firstname` varchar(50) character set utf8 collate utf8_bin default NULL,
  `initials` varchar(50) character set utf8 collate utf8_bin default NULL,
  `address` varchar(100) character set utf8 collate utf8_bin default NULL,
  `zipcode` varchar(20) character set utf8 collate utf8_bin default NULL,
  `city` varchar(100) character set utf8 collate utf8_bin default NULL,
  `state` varchar(100) character set utf8 collate utf8_bin default NULL,
  `country` varchar(100) character set utf8 collate utf8_bin default NULL,
  `phone` varchar(20) character set utf8 collate utf8_bin default NULL,
  `cellular` varchar(20) character set utf8 collate utf8_bin default NULL,
  `fax` varchar(20) character set utf8 collate utf8_bin default NULL,
  `email` varchar(50) character set utf8 collate utf8_bin default NULL,
  `function` varchar(50) character set utf8 collate utf8_bin default NULL,
  `remark` text,
  `role` varchar(15) character set utf8 collate utf8_bin NOT NULL,
  `created_by` int(11) default NULL,
  `created_on` datetime default NULL,
  `last_modified_by` int(11) default NULL,
  `last_modified_on` datetime default NULL,
  `birthdate` date default NULL,
  `bankaccount` varchar(100) character set utf8 collate utf8_bin default NULL,
  `socialsecuritynumber` varchar(100) character set utf8 collate utf8_bin default NULL,
  `employer_id` int(10) default NULL,
  `department` int(10) default NULL,
  `supervisor` int(10) default NULL,
  `functionlevel` int(10) default NULL,
  `status` varchar(9) character set utf8 collate utf8_bin default NULL,
  `lng` varchar(2) character set utf8 collate utf8_bin default NULL,
  `password` varchar(40) character set utf8 collate utf8_bin default NULL,
  `theme` varchar(14) character set utf8 collate utf8_bin default NULL,
  `company` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `phase`
--

CREATE TABLE IF NOT EXISTS `phase` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `projectid` int(10) NOT NULL,
  `description` text,
  `status` varchar(9) character set utf8 collate utf8_bin NOT NULL,
  `virtual_time` int(1) default NULL,
  `startdate` date default NULL,
  `enddate` date default NULL,
  `dependsondeliverable` int(10) default NULL,
  `initial_planning` int(10) default NULL,
  `current_planning` int(10) default NULL,
  `spend_hours` varchar(100) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`id`),
  KEY `project_id_idx` (`projectid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `phase_activity`
--

CREATE TABLE IF NOT EXISTS `phase_activity` (
  `phaseid` int(10) NOT NULL,
  `activityid` int(10) NOT NULL,
  PRIMARY KEY  (`phaseid`,`activityid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `profile`
--

CREATE TABLE IF NOT EXISTS `profile` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `project`
--

CREATE TABLE IF NOT EXISTS `project` (
  `id` int(10) NOT NULL,
  `abbreviation` varchar(10) character set utf8 collate utf8_bin default NULL,
  `name` varchar(200) character set utf8 collate utf8_bin NOT NULL,
  `project_category` int(10) default NULL,
  `coordinator` int(10) default NULL,
  `master_project` int(10) default NULL,
  `contract_id` int(10) default NULL,
  `description` text,
  `quotation_number` varchar(100) character set utf8 collate utf8_bin default NULL,
  `fixed_price` decimal(15,2) default NULL,
  `status` varchar(15) character set utf8 collate utf8_bin default NULL,
  `customer` int(10) default NULL,
  `timereg_limit` int(1) default NULL,
  `alwaysvisibleintimereg` int(1) default NULL,
  `startdate` date default NULL,
  `enddate` date default NULL,
  `template` int(10) default NULL,
  PRIMARY KEY  (`id`),
  KEY `name_idx` (`name`(25))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `project_category`
--

CREATE TABLE IF NOT EXISTS `project_category` (
  `id` int(10) NOT NULL,
  `project_category` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `project_notes`
--

CREATE TABLE IF NOT EXISTS `project_notes` (
  `id` int(10) NOT NULL,
  `owner` int(10) NOT NULL,
  `projectid` int(10) NOT NULL,
  `title` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `entrydate` date NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `project_person`
--

CREATE TABLE IF NOT EXISTS `project_person` (
  `projectid` int(10) NOT NULL,
  `personid` int(10) NOT NULL,
  `role` int(10) NOT NULL,
  PRIMARY KEY  (`projectid`,`personid`,`role`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `project_phaseplanning`
--

CREATE TABLE IF NOT EXISTS `project_phaseplanning` (
  `phaseid` int(10) NOT NULL,
  `personid` int(10) NOT NULL,
  `initial_planning` int(10) default NULL,
  `current_planning` int(10) default NULL,
  `spend_hours` varchar(100) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`phaseid`,`personid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `quotation_payment`
--

CREATE TABLE IF NOT EXISTS `quotation_payment` (
  `id` int(10) NOT NULL,
  `type` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `quotation_quotation`
--

CREATE TABLE IF NOT EXISTS `quotation_quotation` (
  `id` int(10) NOT NULL,
  `quotation_nr` varchar(10) character set utf8 collate utf8_bin NOT NULL,
  `organization_id` int(10) NOT NULL,
  `contact` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `method` varchar(5) character set utf8 collate utf8_bin default NULL,
  `title` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `description` text,
  `issue_date` date NOT NULL,
  `expire_date` date default NULL,
  `status` varchar(16) character set utf8 collate utf8_bin default NULL,
  `assigned_to` int(10) NOT NULL,
  `price` decimal(15,2) NOT NULL,
  `payment_id` int(10) default NULL,
  `success_chance` int(3) default NULL,
  `profit_expectance` decimal(12,2) default NULL,
  `campaign` int(10) default NULL,
  `source` int(10) default NULL,
  `created_by` int(10) default NULL,
  `created_on` datetime default NULL,
  `last_modified_by` int(10) default NULL,
  `last_modified_on` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `role`
--

CREATE TABLE IF NOT EXISTS `role` (
  `id` int(10) NOT NULL,
  `name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_alarms`
--

CREATE TABLE IF NOT EXISTS `scheduler_alarms` (
  `scheduler_id` int(10) NOT NULL,
  `startdate` int(10) NOT NULL,
  `duration` int(10) default NULL,
  `senddate` int(10) default NULL,
  `send` int(1) default NULL,
  `type` varchar(100) character set utf8 collate utf8_bin default NULL,
  `userid` int(2) NOT NULL,
  `owner` int(10) default NULL,
  PRIMARY KEY  (`scheduler_id`,`startdate`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_attendees`
--

CREATE TABLE IF NOT EXISTS `scheduler_attendees` (
  `scheduler_id` int(10) NOT NULL,
  `person_id` int(10) NOT NULL,
  `status` varchar(11) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`scheduler_id`,`person_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_category`
--

CREATE TABLE IF NOT EXISTS `scheduler_category` (
  `id` int(10) NOT NULL,
  `description` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `bgcolor` varchar(10) character set utf8 collate utf8_bin NOT NULL,
  `fgcolor` varchar(10) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_cyclus`
--

CREATE TABLE IF NOT EXISTS `scheduler_cyclus` (
  `scheduler_id` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `monthly_day` int(2) default NULL,
  `yearly_day` int(2) default NULL,
  `yearly_month` int(2) default NULL,
  `yearly_month2` int(2) default NULL,
  `daily_every` int(10) default NULL,
  `weekly_every` int(10) default NULL,
  `monthly_every` int(10) default NULL,
  `monthly_every2` int(10) default NULL,
  `monthly_month_time` int(2) default NULL,
  `yearly_month_time` int(2) default NULL,
  `weekly_weekday` int(17) default NULL,
  `monthly_weekday_list` int(1) default NULL,
  `yearly_weekday_list` int(1) default NULL,
  `daily_choice` int(10) default NULL,
  `monthly_choice` int(10) default NULL,
  `yearly_choice` int(10) default NULL,
  `end_choice` int(10) default NULL,
  `cyclus_enddate` date default NULL,
  `cyclus_times` int(10) default NULL,
  PRIMARY KEY  (`scheduler_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_cyclus_not`
--

CREATE TABLE IF NOT EXISTS `scheduler_cyclus_not` (
  `scheduler_id` int(10) NOT NULL,
  `date` int(10) NOT NULL,
  PRIMARY KEY  (`scheduler_id`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_dates`
--

CREATE TABLE IF NOT EXISTS `scheduler_dates` (
  `scheduler_id` int(10) NOT NULL,
  `startdate` int(10) NOT NULL,
  `enddate` int(10) default NULL,
  PRIMARY KEY  (`scheduler_id`,`startdate`),
  KEY `enddate_idx` (`enddate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_group`
--

CREATE TABLE IF NOT EXISTS `scheduler_group` (
  `id` int(10) NOT NULL,
  `userid` varchar(100) character set utf8 collate utf8_bin default NULL,
  `name` varchar(100) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_group_member`
--

CREATE TABLE IF NOT EXISTS `scheduler_group_member` (
  `groupid` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  PRIMARY KEY  (`groupid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_holidays`
--

CREATE TABLE IF NOT EXISTS `scheduler_holidays` (
  `id` int(10) NOT NULL,
  `name` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `type` varchar(7) character set utf8 collate utf8_bin default NULL,
  `day` int(2) default NULL,
  `month` int(2) default NULL,
  `special` varchar(6) character set utf8 collate utf8_bin default NULL,
  `day_offset` int(3) default NULL,
  `length` int(2) default NULL,
  `weekday` int(1) default NULL,
  `moveto` int(1) default NULL,
  `schedulecategory` int(10) NOT NULL,
  `country` varchar(2) character set utf8 collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_notes`
--

CREATE TABLE IF NOT EXISTS `scheduler_notes` (
  `id` int(10) NOT NULL,
  `owner` int(10) NOT NULL,
  `scheduler_id` int(10) NOT NULL,
  `entrydate` date NOT NULL,
  `title` varchar(100) character set utf8 collate utf8_bin NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_scheduler`
--

CREATE TABLE IF NOT EXISTS `scheduler_scheduler` (
  `id` int(10) NOT NULL,
  `title` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `location` varchar(50) character set utf8 collate utf8_bin default NULL,
  `description` text,
  `recur` varchar(7) character set utf8 collate utf8_bin default NULL,
  `startdate` date default NULL,
  `enddate` date default NULL,
  `allday` int(1) default NULL,
  `starttime` time default NULL,
  `endtime` time default NULL,
  `category` int(10) NOT NULL,
  `all_users` int(1) default NULL,
  `priority` int(1) default NULL,
  `private` int(1) default NULL,
  `nonblocking` int(1) default NULL,
  `owner` int(10) NOT NULL,
  `owner_attendee` int(1) default NULL,
  `lastdate` int(10) default NULL,
  `times` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_userassistants`
--

CREATE TABLE IF NOT EXISTS `scheduler_userassistants` (
  `userid` int(10) NOT NULL,
  `employeeid` int(10) NOT NULL,
  PRIMARY KEY  (`userid`,`employeeid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `scheduler_userpreferences`
--

CREATE TABLE IF NOT EXISTS `scheduler_userpreferences` (
  `userid` int(10) NOT NULL,
  `timeschedule` int(2) NOT NULL,
  `showweeknumbers` int(1) default NULL,
  `showtodo` int(1) default NULL,
  `showemployeebirthdays` int(1) default NULL,
  `showlunarphases` int(1) default NULL,
  `autorefresh` int(1) default NULL,
  `refresh_interval` int(10) default NULL,
  `default_view` varchar(5) character set utf8 collate utf8_bin NOT NULL,
  `default_userview` varchar(25) character set utf8 collate utf8_bin NOT NULL,
  `default_eventtime` time default NULL,
  `default_category` int(10) default NULL,
  `scheduler_emptycolor` varchar(10) character set utf8 collate utf8_bin default NULL,
  `scheduler_emptyworkhourscolor` varchar(10) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `title`
--

CREATE TABLE IF NOT EXISTS `title` (
  `id` int(10) NOT NULL,
  `title` varchar(25) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `todo`
--

CREATE TABLE IF NOT EXISTS `todo` (
  `id` int(10) NOT NULL,
  `owner` int(10) NOT NULL,
  `projectid` int(10) default NULL,
  `contactid` int(10) default NULL,
  `title` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `assigned_to` int(10) default NULL,
  `entrydate` date NOT NULL,
  `duedate` date NOT NULL,
  `closedate` date default NULL,
  `updated` datetime default NULL,
  `priority` int(1) NOT NULL,
  `completed` int(3) default NULL,
  `private` int(1) default NULL,
  `description` text,
  `status` int(1) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `owner_idx` (`owner`),
  KEY `assigned_to_idx` (`assigned_to`),
  KEY `status_idx` (`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `todo_history`
--

CREATE TABLE IF NOT EXISTS `todo_history` (
  `id` int(10) NOT NULL,
  `owner` int(10) NOT NULL,
  `projectid` int(10) default NULL,
  `contactid` int(10) default NULL,
  `title` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `assigned_to` int(10) default NULL,
  `entrydate` date NOT NULL,
  `duedate` date NOT NULL,
  `closedate` date default NULL,
  `priority` int(1) NOT NULL,
  `completed` int(3) default NULL,
  `private` int(1) default NULL,
  `description` text,
  `status` int(1) NOT NULL,
  `todoid` int(10) NOT NULL,
  `updated` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `tpl_dependency`
--

CREATE TABLE IF NOT EXISTS `tpl_dependency` (
  `phaseid_row` int(10) NOT NULL,
  `phaseid_col` int(10) NOT NULL,
  `projectid` int(10) NOT NULL,
  PRIMARY KEY  (`phaseid_row`,`phaseid_col`,`projectid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `tpl_phase`
--

CREATE TABLE IF NOT EXISTS `tpl_phase` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `tpl_phase_activity`
--

CREATE TABLE IF NOT EXISTS `tpl_phase_activity` (
  `activityid` int(10) NOT NULL,
  `phaseid` int(10) NOT NULL,
  PRIMARY KEY  (`activityid`,`phaseid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `tpl_project`
--

CREATE TABLE IF NOT EXISTS `tpl_project` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `description` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `tpl_project_phase`
--

CREATE TABLE IF NOT EXISTS `tpl_project_phase` (
  `projectid` int(10) NOT NULL,
  `phaseid` int(10) NOT NULL,
  PRIMARY KEY  (`projectid`,`phaseid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `usercontract`
--

CREATE TABLE IF NOT EXISTS `usercontract` (
  `id` int(10) NOT NULL,
  `userid` int(10) NOT NULL,
  `uc_hours` decimal(6,2) NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date default NULL,
  `description` text,
  `workingdays` text,
  `workstarttime` time NOT NULL,
  `workendtime` time NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `userpimitems`
--

CREATE TABLE IF NOT EXISTS `userpimitems` (
  `id` int(10) NOT NULL,
  `userid` int(10) default NULL,
  `pimitem` varchar(255) character set utf8 collate utf8_bin NOT NULL,
  `orderby` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `versioninfo`
--

CREATE TABLE IF NOT EXISTS `versioninfo` (
  `module` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `version` varchar(15) character set utf8 collate utf8_bin default NULL,
  PRIMARY KEY  (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `workperiod`
--

CREATE TABLE IF NOT EXISTS `workperiod` (
  `id` int(10) NOT NULL,
  `name` varchar(50) character set utf8 collate utf8_bin NOT NULL,
  `starttime` time NOT NULL,
  `endtime` time NOT NULL,
  `percentage` int(10) NOT NULL,
  `defaultrate` int(1) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------


and

Code:
REATE VIEW `hours` AS SELECT `id`, `virtual_time`, `userid`, `activitydate`, `todate`, `phaseid`, `activityid`, `remark`, `time`, `workperiod`, `entrydate` FROM `hoursbase`


I would like to know what it happens know :)

_________________
Need some help?


Top
 Profile  
 

Re: IIS Error
PostPosted: Sat Feb 11, 2012 5:16 pm 
Regular
User avatar
Offline

Joined: Mon Nov 21, 2005 11:53 pm
Posts: 260
Location: Calgary, AB, Canada
Klaaspeter, I'm not sure using a phpMyAdmin export works correctly as you suggested. I tried restoring an older production achievo 1.4.5 system onto a new 1.4.5 install using phpMyAdmin export/import, but afterwards got error messages accessing time registration. I have noticed the phpMyAdmin export creates an "hours" table, while "hours" is actually a View in the database (as shown by phpMyAdmin itself!). The SQL export using mysqldump has a view.

Dale

_________________
Dale Scott
Transparency with Trust
http://www.dalescott.net


Top
 Profile  
 

Re: IIS Error
PostPosted: Tue Feb 14, 2012 11:13 pm 
Regular
Offline

Joined: Thu Sep 30, 2010 2:45 pm
Posts: 464
Yeah you are right about it. I should have made a sql file of 69 tables and made a new sql run for the view of hours. That works for sure thanks :)

_________________
Need some help?


Top
 Profile  
 

Re: IIS Error
PostPosted: Mon Jul 01, 2013 6:30 am 
Offline

Joined: Mon Jul 01, 2013 6:02 am
Posts: 1
I don't understand your topic.Please explaine your topic clearly.

_________________
gloria hotel apartments dubai rent


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group