Help Center Live Community
April 18, 2014, 09:46:04 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: database.sql dump  (Read 3060 times)
hotdesc
Not too much to say...
*
Offline Offline

Posts: 13


« on: January 05, 2009, 03:49:49 PM »

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;
       
       
Logged
hotdesc
Not too much to say...
*
Offline Offline

Posts: 13


« Reply #1 on: January 09, 2009, 01:33:18 PM »

resolved
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.8 | SMF © 2006-2008, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.16 seconds with 19 queries.

Google visited last this page March 21, 2014, 10:48:05 PM