All pastes #966199 Raw Edit

||cw

public text v1 · immutable
·published 2008-04-01 15:54 UTC
rendered paste body
-- phpMyAdmin SQL Dump
-- version 2.6.2-Debian-3sarge6
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 01, 2008 at 10:53 AM
-- Server version: 5.0.51
-- PHP Version: 4.4.8-0.dotdeb.0
-- 
-- Database: `todolist_epconline_net_db1`
-- 

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

-- 
-- Table structure for table `phpgw_contact_comm_descr`
-- 

CREATE TABLE `phpgw_contact_comm_descr` (
  `comm_descr_id` int(11) NOT NULL auto_increment,
  `comm_type_id` int(11) NOT NULL default '0',
  `descr` varchar(50) default NULL,
  PRIMARY KEY  (`comm_descr_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- 
-- Dumping data for table `phpgw_contact_comm_descr`
-- 

INSERT INTO `phpgw_contact_comm_descr` VALUES (1, 1, 'home email');
INSERT INTO `phpgw_contact_comm_descr` VALUES (2, 1, 'work email');
INSERT INTO `phpgw_contact_comm_descr` VALUES (3, 2, 'home phone');
INSERT INTO `phpgw_contact_comm_descr` VALUES (4, 2, 'work phone');
INSERT INTO `phpgw_contact_comm_descr` VALUES (5, 2, 'voice phone');
INSERT INTO `phpgw_contact_comm_descr` VALUES (6, 2, 'msg phone');
INSERT INTO `phpgw_contact_comm_descr` VALUES (7, 2, 'pager');
INSERT INTO `phpgw_contact_comm_descr` VALUES (8, 2, 'bbs');
INSERT INTO `phpgw_contact_comm_descr` VALUES (9, 2, 'modem');
INSERT INTO `phpgw_contact_comm_descr` VALUES (10, 2, 'isdn');
INSERT INTO `phpgw_contact_comm_descr` VALUES (11, 2, 'video');
INSERT INTO `phpgw_contact_comm_descr` VALUES (12, 4, 'home fax');
INSERT INTO `phpgw_contact_comm_descr` VALUES (13, 4, 'work fax');
INSERT INTO `phpgw_contact_comm_descr` VALUES (14, 3, 'mobile (cell) phone');
INSERT INTO `phpgw_contact_comm_descr` VALUES (15, 3, 'car phone');
INSERT INTO `phpgw_contact_comm_descr` VALUES (16, 5, 'msn');
INSERT INTO `phpgw_contact_comm_descr` VALUES (17, 5, 'aim');
INSERT INTO `phpgw_contact_comm_descr` VALUES (18, 5, 'yahoo');
INSERT INTO `phpgw_contact_comm_descr` VALUES (19, 5, 'icq');
INSERT INTO `phpgw_contact_comm_descr` VALUES (20, 5, 'jabber');
INSERT INTO `phpgw_contact_comm_descr` VALUES (21, 6, 'website');