database.sql dump

i need in postgre

Code:

-- phpMyAdmin SQL Dump
-- version 2.6.1-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 02, 2005 at 12:39 PM
-- Server version: 4.0.20
-- PHP Version: 4.3.11
--
-- Database: `hcl`
--

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

--
-- Table structure for table `activity`
--

CREATE TABLE `activity` (
`id` int(255) NOT NULL auto_increment,
`timestamp` int(255) default NULL,
`operatorid` varchar(255) NOT NULL default '',
`status` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `assigns`
--

CREATE TABLE `assigns` (
`id` int(255) NOT NULL auto_increment,
`departmentid` int(255) NOT NULL default '0',
`operatorid` int(255) NOT NULL default '0',
`poll` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `canned`
--

CREATE TABLE `canned` (
`id` int(255) NOT NULL auto_increment,
`departmentid` int(255) NOT NULL default '0',
`operatorid` int(255) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`operatorid` int(255) NOT NULL default '0',
`timestamp` int(255) default NULL,
`message` text NOT NULL,
`x` char(1) NOT NULL default '',
`operator` int(1) NOT NULL default '0',
`guest` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `cobrowse`
--

CREATE TABLE `cobrowse` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`page` text NOT NULL,
`notified` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `coforms`
--

CREATE TABLE `coforms` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`receivedg` tinyint(1) NOT NULL default '0',
`receivedo` tinyint(1) NOT NULL default '0',
`type` text NOT NULL,
`name` text NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `comarker`
--

CREATE TABLE `comarker` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`x` int(255) NOT NULL default '0',
`y` int(255) NOT NULL default '0',
`type` varchar(255) NOT NULL default '',
`clear` tinyint(1) NOT NULL default '0',
`receivedg` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
`id` int(255) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`visible` int(1) NOT NULL default '1',
`order` int(255) NOT NULL default '1',
`email` varchar(255) NOT NULL default '',
`email_host` varchar(255) NOT NULL default '',
`email_port` int(5) NOT NULL default '25',
`email_username` varchar(255) NOT NULL default '',
`email_password` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) default NULL,
`file` blob NOT NULL,
`type` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`size` varchar(255) NOT NULL default '0 kb',
`status` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `footprints`
--

CREATE TABLE `footprints` (
`id` int(255) NOT NULL auto_increment,
`timestamp` int(255) default NULL,
`chatid` int(255) NOT NULL default '0',
`page` text NOT NULL,
`cobrowse` tinyint(1) NOT NULL default '0',
`current` int(1) NOT NULL default '1',
PRIMARY KEY (`id`),
KEY `chatid` (`chatid`)
) TYPE=MyISAM;

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

--
-- Table structure for table `hotpages`
--

CREATE TABLE `hotpages` (
`id` int(255) NOT NULL auto_increment,
`page` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `notes`
--

CREATE TABLE `notes` (
`id` int(255) NOT NULL auto_increment,
`timestamp` int(255) default '0',
`operatorid` int(255) NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `operators`
--

CREATE TABLE `operators` (
`id` int(255) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`firstname` varchar(255) NOT NULL default '',
`lastname` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`level` int(1) NOT NULL default '0',
`timestamp` int(255) default '0',
`autosave` int(1) NOT NULL default '1',
`showpic` int(1) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
`sounds` int(1) NOT NULL default '1',
`picture` blob NOT NULL,
`accepts` int(255) NOT NULL default '0',
`declines` int(255) NOT NULL default '0',
`accepts_transfer` int(255) NOT NULL default '0',
`declines_transfer` int(255) NOT NULL default '0',
`accepts_opchat` int(255) NOT NULL default '0',
`declines_opchat` int(255) NOT NULL default '0',
`initiates` int(255) NOT NULL default '0',
`onlinetime` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `polling`
--

CREATE TABLE `polling` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`assignid` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
`id` int(255) NOT NULL auto_increment,
`operatorid` int(255) NOT NULL default '0',
`chatid` int(255) NOT NULL default '0',
`transcriptid` int(255) NOT NULL default '0',
`timestamp` int(255) NOT NULL default '0',
`rating` int(1) NOT NULL default '0',
`review` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`assignid` int(255) default NULL,
`departmentid` int(255) default NULL,
`operatorid` int(255) default NULL,
`nick` varchar(255) default NULL,
`alert` varchar(20) NOT NULL default '',
`timeo` int(255) NOT NULL default '0',
`timeg` int(255) NOT NULL default '0',
`typeo` int(255) NOT NULL default '0',
`typeg` int(255) NOT NULL default '0',
`transfer` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `stats_referrers`
--

CREATE TABLE `stats_referrers` (
`id` int(255) NOT NULL auto_increment,
`chatid` int(255) NOT NULL default '0',
`timestamp` int(255) NOT NULL default '0',
`url` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `stats_visitors`
--

CREATE TABLE `stats_visitors` (
`id` int(255) NOT NULL auto_increment,
`timestamp` int(255) NOT NULL default '0',
`visits` int(255) NOT NULL default '0',
`hits` int(255) NOT NULL default '0',
`requests` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `system`
--

CREATE TABLE `system` (
`id` int(255) NOT NULL auto_increment,
`timestamp` int(255) default NULL,
`operatorid` int(255) NOT NULL default '0',
`chatid` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `traffic`
--

CREATE TABLE `traffic` (
`id` int(255) NOT NULL auto_increment,
`timestamp` int(255) default NULL,
`ip` varchar(255) NOT NULL default '',
`useragent` text default NULL,
`hostname` varchar(255) NOT NULL default '',
`referrer` text default NULL,
`requests` int(255) NOT NULL default '0',
`visits` int(255) NOT NULL default '1',
`start` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

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

--
-- Table structure for table `transcripts`
--

CREATE TABLE `transcripts` (
`id` int(255) NOT NULL auto_increment,
`timestamp` int(255) default NULL,
`chatid` int(255) NOT NULL default '0',
`operatorid` int(255) NOT NULL default '0',
`departmentid` int(255) NOT NULL default '0',
`guest` varchar(255) NOT NULL default '',
`hostname` varchar(255) NOT NULL default '',
`transcript` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;