[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sq
From: |
skwashd |
Subject: |
[Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1 |
Date: |
Thu, 5 May 2005 02:56:00 +0200 |
Update of old/cdb/doc/examples/sql
Added Files:
Branch: MAIN
cdb.sql
cdb_language.sql
Log Message:
cvs clean up
====================================================
Index: cdb.sql
# Database design for Outlook-style contact management
# PLEASE SEE tables_current.inc.php in the setup dir for this app
# Version 1.8
# Written by Patrick Walsh (address@hidden)
# Changelog
# ---------
# v.1.8
# - Added an insert into applications sql statement - commented out
# as it is only meant for development use at this time
#
# v.1.7 - Updated references in all files to to contact.db & organization.db
# to reflect new name contact.meta & organization.meta
# - Added field last_name_prefix to contact.main table to accomodate
# some non-US users. Most notably dutch people at present.
# - Changed some field types from text to varchar(255)
#
# v.1.6 -Added pgw_cdb_ prefix to all tables.
#
# -Added language_code to the language table for two digit
# language codes. Also added INSERTS for many of the languages.
#
# v.1.5 -Added ldap_dn to allow instant referencing of ldap entries by
# distinguished name. This, of course, applies only to records
# with ldap_sync=1.
#
# v.1.4 -Added ldap_sync flag to contact_db table for flagging data to
# be sync'ed with an ldap server and/or exposed via an ldap
# interface.
#
# v.1.3 -Fixed a number of typos in the SQL definitions. The
# definitions work w/o error using MySQL v.3.22.32. Someone with
# access to a Postgres server should test this and let me know
# if anything needs to be changed.
#
# -Made the file_as fields NOT NULL so that they can be indexed.
# This means that the file_as field is absolutely required when
# saving to the database. If left blank by the user, perhaps we
# can assume "last_name, first_name" or "orgranization_name"...
#
# -Changed the contact_id field to entity_id in category_link.
#
# -Removed main_phone from the organization table as it is now
# replaced by the location table.
#
# New table 'organization_location' stores a list of location/
# phone/ address records that allows each organization to have
# multiple locations with distinct phone numbers and addresses.
#
# -In the contact table, main_organization_selector is now called
# main_organization_location_selector.
#
# -Removed contact_organization_link table (what was I thinking
# when I added this?)
#
# -Edited the contact_organization table so that now each record
# has a link to an organization location, a contact, and has
# properties specific to the relationship, like the contact's
# assistant's name. This table establishes the contact/org
# links.
#
# v.1.2: -Added organization_db to store last access, etc. for
# organizations
#
# -contact_main: removed address_selector as the main page should
# only have one address and that should be the mailing address.
#
# v.1.1: -Added organization_client table to provide a mechanism for
# tracking companies as customers/clients.
#
# -Added contact_type field to the category_link table.
# contact_type can be either "individual" or "organization" and
# determines whether contact_id is a contact_id or an
# organization_id.
#
# This allows the categorization of companies as well as
# individual contacts. [Note: the contact_id field should be
# renamed to something more generic.. entity_id?']
# The following insert command is used only by developers at this time
# Have patience, and all will be good.
#
#INSERT INTO applications (app_name, app_title, app_enabled, app_order,
app_tables, app_version) VALUES
('cdb','cdb-devel',1,31,'pgw_cdb_category,pgw_cdb_category_link,pgw_cdb_contact_address,pgw_cdb_contact_address_category,pgw_cdb_contact_client,pgw_cdb_contact_flag,pgw_cdb_contact_flag_link,pgw_cdb_contact_followup,pgw_cdb_contact_internet,pgw_cdb_contact_main,pgw_cdb_contact_meta,pgw_cdb_contact_notes,pgw_cdb_contact_organization,pgw_cdb_contact_personal,pgw_cdb_contact_phone,pgw_cdb_contact_phone_category,pgw_cdb_language,pgw_cdb_organization,pgw_cdb_organization_client,pgw_cdb_organization_location,pgw_cdb_organization_meta,pgw_cdb_organization_notes',1.5);
#
# The following DROP TABLE commands are used by the
# db developers for testing different db schemes.
# Uncomment only if you do not care about the data
# in your contact databases
#
#DROP TABLE IF EXISTS pgw_cdb_contact_main;
#DROP TABLE IF EXISTS pgw_cdb_contact_personal;
#DROP TABLE IF EXISTS pgw_cdb_contact_db;
#DROP TABLE IF EXISTS pgw_cdb_contact_meta;
#DROP TABLE IF EXISTS pgw_cdb_contact_client;
#DROP TABLE IF EXISTS pgw_cdb_contact_notes;
#DROP TABLE IF EXISTS pgw_cdb_contact_internet;
#DROP TABLE IF EXISTS pgw_cdb_contact_phone;
#DROP TABLE IF EXISTS pgw_cdb_contact_phone_category;
#DROP TABLE IF EXISTS pgw_cdb_contact_address;
#DROP TABLE IF EXISTS pgw_cdb_contact_organization;
#DROP TABLE IF EXISTS pgw_cdb_contact_address_category;
#DROP TABLE IF EXISTS pgw_cdb_category;
#DROP TABLE IF EXISTS pgw_cdb_category_link;
#DROP TABLE IF EXISTS pgw_cdb_language;
#DROP TABLE IF EXISTS pgw_cdb_contact_flag;
#DROP TABLE IF EXISTS pgw_cdb_contact_flag_link;
#DROP TABLE IF EXISTS pgw_cdb_contact_followup;
#DROP TABLE IF EXISTS pgw_cdb_organization;
#DROP TABLE IF EXISTS pgw_cdb_organization_notes;
#DROP TABLE IF EXISTS pgw_cdb_organization_client;
#DROP TABLE IF EXISTS pgw_cdb_organization_db;
#DROP TABLE IF EXISTS pgw_cdb_organization_meta;
#DROP TABLE IF EXISTS pgw_cdb_organization_location;
#
# Table structure for table 'contact_main'
#
CREATE TABLE pgw_cdb_contact_main (
contact_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
main_organization_location_selector int(11) unsigned DEFAULT '0' NOT NULL,
first_name varchar(255),
middle_name varchar(255),
last_name varchar(255),
last_name_prefix varchar(10),
initials char(6),
location varchar(255),
nickname varchar(255),
profession varchar(255),
suffix varchar(20),
title varchar(20),
email_selector int(11) DEFAULT '0' NOT NULL,
web_selector int(11) DEFAULT '0' NOT NULL,
mailing_address_selector int(11) DEFAULT '0' NOT NULL,
phone1_selector int(11) DEFAULT '0' NOT NULL,
phone2_selector int(11) DEFAULT '0' NOT NULL,
phone3_selector int(11) DEFAULT '0' NOT NULL,
phone4_selector int(11) DEFAULT '0' NOT NULL,
phone5_selector int(11) DEFAULT '0' NOT NULL,
phone6_selector int(11) DEFAULT '0' NOT NULL,
phone7_selector int(11) DEFAULT '0' NOT NULL,
phone8_selector int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (contact_id)
);
#
# Table structure for table 'contact_phone'
#
CREATE TABLE pgw_cdb_contact_phone (
contact_phone_id int(11) unsigned DEFAULT '0' NOT NULL,
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
phone_category_id int(11) unsigned NOT NULL,
number char(100),
PRIMARY KEY (contact_phone_id),
KEY idx_contact_id (contact_id),
KEY idx_phone_category_id (phone_category_id)
);
#
# Table structure for table 'contact_phone_category'
#
# This table has an entry for each type of telephone
# number. An example of a type that is not used
# below is College Telephone number.
#
CREATE TABLE pgw_cdb_contact_phone_category (
phone_category_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
phone_category_name char(20) NOT NULL,
PRIMARY KEY (phone_category_id)
);
#
# Default data for table 'contact_phone_category'
#
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (1,'Business Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (2,'Business Phone2');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (3,'Business Pager');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (4,'Business Fax');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (5,'Home Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (6,'Home Phone2');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (7,'Home Pager');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (8,'Home Fax');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (9,'Other Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (10,'Other Pager');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (11,'Other Fax');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (12,'Call Back');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (13,'Car Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (14,'ISDN');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (15,'Mobile Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (16,'Primary Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (17,'Radio Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (18,'Telex');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (19,'TTY/TDD Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (20,'Family Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (21,'Vacation Home Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (22,'School Phone');
INSERT INTO pgw_cdb_contact_phone_category (phone_category_id,
phone_category_name) VALUES (23,'Answering Service');
#
# Table structure for table 'organization'
# Companies can be catalogued and referenced as
# individual entities. Assuming that you have
# multiple contacts in any organization, this should
# save input time and errors.
#
# Minor issue: any given organization may have more
# than one main phone for different locations.
# Perhaps there should be tables giving location
# lists for each company with different "main"
# phone numbers for each location. Each contact
# could then choose what location they are at...?
#
CREATE TABLE pgw_cdb_organization (
organization_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
organization_name varchar(100) NOT NULL,
organization_home_page text,
organization_network_name varchar(100),
organization_org_id_num varchar(20),
PRIMARY KEY (organization_id)
);
#
# Table structure for table 'organization_location'
# This table contains location/address/phone info
# for organizations. Any org. can have multiple
# locations.
CREATE TABLE pgw_cdb_organization_location (
location_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
organization_id int(11) unsigned NOT NULL,
location text,
address_city varchar(255),
address_country varchar(255),
postal_code varchar(255),
address_street varchar(255),
number varchar(100),
PRIMARY KEY (location_id),
KEY (organization_id)
);
#
# Table structure for table 'organization_client'
# Organizations/Entities who are clients have their
# own set of info.
#
CREATE TABLE pgw_cdb_organization_client (
organization_id int(11) unsigned DEFAULT '0' NOT NULL,
account text,
billing_info text,
customer_id varchar(20),
referred_by text,
PRIMARY KEY (organization_id)
);
#
# Table structure for table 'organization_db'
#
CREATE TABLE pgw_cdb_organization_meta (
organization_id int(11) unsigned DEFAULT '0' NOT NULL,
status ENUM("active","pending","deleted") DEFAULT 'pending' NOT NULL,
created int(11) DEFAULT '0' NOT NULL,
modified int(11) DEFAULT '0' NOT NULL,
file_as varchar(50) NOT NULL,
followup_status int(11) unsigned DEFAULT '0' NOT NULL,
created_by int(11) DEFAULT '0' NOT NULL,
keywords text,
group_access int(11) DEFAULT '0',
version float(8,2),
PRIMARY KEY (organization_id),
KEY (file_as(4))
);
#
# Table structure for table 'organization_notes'
# Notes are kept in separate tables in order to keep
# the other tables optimized.
#
CREATE TABLE pgw_cdb_organization_notes (
organization_id int(11) unsigned DEFAULT '0' NOT NULL,
note text,
PRIMARY KEY (organization_id)
);
#
# Table structure for table 'contact_organization'
# This table is specific to a contact. This is
# contact-specific organization information like who
# the contact's assistant is and such.
#
# For each link (below) between a contact and org
# there may be additional information such as an
# assistant's name and department and such.
#
CREATE TABLE pgw_cdb_contact_organization (
organization_link_id int(11) unsigned DEFAULT '0' NOT NULL,
organization_location_id int(11) unsigned DEFAULT '0' NOT NULL,
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
assistant_name varchar(255),
assistant_phone varchar(100),
assistant_email varchar(50),
department varchar(255),
job_title varchar(255),
manager_name varchar(255),
PRIMARY KEY (organization_link_id)
);
#
# Table structure for table 'contact_notes'
# Again, different database for notes for
# optimization purposes.
#
CREATE TABLE pgw_cdb_contact_notes (
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
note text,
PRIMARY KEY (contact_id)
);
#
# Table structure for table 'contact_client'
# Contacts who are clients have their own set
# of info.
#
CREATE TABLE pgw_cdb_contact_client (
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
account text,
billing_info text,
customer_id varchar(20),
referred_by text,
PRIMARY KEY (contact_id)
);
#
# Table structure for table 'contact_personal'
# Contact's personal information
#'
CREATE TABLE pgw_cdb_contact_personal (
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
birthday int(11),
children text,
gender ENUM("unspecified","male","female"),
gov_id_num varchar(20),
hobbies text,
language int(11),
spouse text,
anniversary int(11),
PRIMARY KEY (contact_id)
);
#
# Table structure for table 'language'
# List of languages for future international
# compatibility and international contacts.
#
CREATE TABLE pgw_cdb_language (
language_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
language_name char(40) NOT NULL,
language_code char(10) NOT NULL,
PRIMARY KEY (language_id),
KEY (language_code),
UNIQUE (language_name)
);
#
# Populate the pgw_cdb_language table
#
# --- This has been moved to a separate file: cdb_language.sql ---
#
#
# Table structure for table 'category'
#
CREATE TABLE pgw_cdb_category (
category_id int(11) unsigned DEFAULT '0' NOT NULL,
name char(40) NOT NULL,
PRIMARY KEY (category_id),
UNIQUE (name)
);
#
# Table structure for table 'category'
#
CREATE TABLE pgw_cdb_category_link (
category_link_id int(11) unsigned DEFAULT '0' NOT NULL,
category_id int(11) unsigned DEFAULT '0' NOT NULL,
entity_id int(11) unsigned DEFAULT '0' NOT NULL,
contact_type ENUM("individual","organization") DEFAULT 'individual' NOT NULL,
PRIMARY KEY (category_link_id),
KEY (entity_id),
KEY (category_id),
KEY (contact_type)
);
#
# Table structure for table 'contact_db'
#
CREATE TABLE pgw_cdb_contact_meta (
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
status ENUM("active","pending","deleted") DEFAULT 'pending' NOT NULL,
created int(11) DEFAULT '0' NOT NULL,
modified int(11) DEFAULT '0' NOT NULL,
file_as varchar(50) NOT NULL,
followup_status int(11) unsigned DEFAULT '0' NOT NULL,
created_by int(11) DEFAULT '0' NOT NULL,
keywords text,
group_access int(11) DEFAULT '0',
version float(8,2),
ldap_sync int(11) DEFAULT '0',
ldap_dn varchar(100),
PRIMARY KEY (contact_id),
KEY (file_as(4))
);
#
# Table structure for table 'contact_flag'
# List of choices for different status flags.
# Each person can make their own set of status flags
# and these flags will act like Eudora labels.
# When flagged, the contact row will be colored
# with the color of the flag.
#
CREATE TABLE pgw_cdb_contact_flag (
flag_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
user_id int(11) DEFAULT '0' NOT NULL,
flag_name char(40),
flag_color char(6),
PRIMARY KEY (flag_id),
KEY idx_user_id (user_id)
);
CREATE TABLE pgw_cdb_contact_flag_link (
flag_link_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
user_id int(11) DEFAULT '0' NOT NULL,
contact_id int(11) DEFAULT '0' NOT NULL,
flag_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (flag_link_id),
KEY idx_user_id (user_id),
KEY idx_contact_id (contact_id)
);
#
# Table structure for table 'contact_followup'
# Flag contacts for later followup. There will
# be a marker next to their name in the color specified.
#
CREATE TABLE pgw_cdb_contact_followup (
followup_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
followup_name char(20),
followup_color char(6),
PRIMARY KEY (followup_id)
);
#
# Default data for table 'contact_phone_category'
#
INSERT INTO pgw_cdb_contact_followup (followup_id, followup_name,
followup_color) VALUES (1,'Follow Up', 'FF2222'); #red
INSERT INTO pgw_cdb_contact_followup (followup_id, followup_name,
followup_color) VALUES (2,'For Your Information', '6699cc'); #blue
INSERT INTO pgw_cdb_contact_followup (followup_id, followup_name,
followup_color) VALUES (3,'Review', '83d8a4'); #green
INSERT INTO pgw_cdb_contact_followup (followup_id, followup_name,
followup_color) VALUES (4,'Call', 'cccc99'); #gold
INSERT INTO pgw_cdb_contact_followup (followup_id, followup_name,
followup_color) VALUES (5,'Arrange Meeting', 'CC99CC'); #purple
INSERT INTO pgw_cdb_contact_followup (followup_id, followup_name,
followup_color) VALUES (6,'Send E-mail', 'FF9966'); #orange
INSERT INTO pgw_cdb_contact_followup (followup_id, followup_name,
followup_color) VALUES (7,'Send Letter', 'FFFF33'); #yellow
#
# Table structure for table 'contact_internet'
#
CREATE TABLE pgw_cdb_contact_internet (
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
email_home char(50),
email_home_display char(50),
email_business char(50),
email_business_display char(50),
email_other char(50),
email_other_display char(50),
ftp char(100),
free_busy_address char(100),
personal_home_page char(100),
business_home_page char(100),
other_home_page char(100),
send_as_plain_text int(11) DEFAULT '1' NOT NULL,
icq char(20),
PRIMARY KEY (contact_id)
);
#
# Table structure for table 'contact_address_category'
#
# This table has an entry for each type of address.
# For example, Business, Vacation, Family, etc.
#
CREATE TABLE pgw_cdb_contact_address_category (
address_category_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
address_category_name char(20) NOT NULL,
PRIMARY KEY (address_category_id)
);
#
# Default data for table 'contact_address_category'
#
INSERT INTO pgw_cdb_contact_address_category (address_category_id,
address_category_name) VALUES (1,'Business Address');
INSERT INTO pgw_cdb_contact_address_category (address_category_id,
address_category_name) VALUES (2,'Home Address');
INSERT INTO pgw_cdb_contact_address_category (address_category_id,
address_category_name) VALUES (3,'Other Address');
INSERT INTO pgw_cdb_contact_address_category (address_category_id,
address_category_name) VALUES (4,'Family Address');
INSERT INTO pgw_cdb_contact_address_category (address_category_id,
address_category_name) VALUES (5,'Vacation Home Address');
#
# Table structure for table 'contact_address'
#
CREATE TABLE pgw_cdb_contact_address (
contact_address_id int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
contact_id int(11) unsigned DEFAULT '0' NOT NULL,
address_category_id int(11) NOT NULL,
address_city varchar(255),
address_country varchar(255),
postal_code varchar(255),
address_street varchar(255),
PRIMARY KEY (contact_address_id),
KEY (contact_id),
KEY (address_category_id)
);
====================================================
Index: cdb_language.sql
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("aa",
"Afar");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ab",
"Abkhazian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("af",
"Afrikaans");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ar",
"Arabic");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("as",
"Assamese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ay",
"Aymara");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("az",
"Azerbaijani");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ba",
"Bashkir");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("be",
"Byelorussian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("bg",
"Bulgarian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("bh",
"Bihari");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("bi",
"Bislama");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("bn",
"Bengali; Bangla");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("bo",
"Tibetan");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("br",
"Breton");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ca",
"Catalan");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("co",
"Corsican");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("cs",
"Czech");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("cy",
"Welsh");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("da",
"Danish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("de",
"German");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("dz",
"Bhutani");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("el",
"Greek");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("en",
"English");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("eo",
"Esperanto");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("es",
"Spanish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("et",
"Estonian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("eu",
"Basque");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("fa",
"Persian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("fi",
"Finnish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("fj",
"Fiji");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("fo",
"Faroese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("fr",
"French");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("fy",
"Frisian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ga",
"Irish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("gd",
"Scots Gaelic");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("gl",
"Galician");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("gn",
"Guarani");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("gu",
"Gujarati");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ha",
"Hausa");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("he",
"Hebrew");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("hi",
"Hindi");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("hr",
"Croatian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("hu",
"Hungarian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("hy",
"Aremenian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ia",
"Interlingua");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("id",
"Indonesian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ie",
"Interlingue");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ik",
"Inupiak");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("is",
"Icelandic");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("it",
"Italian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("iu",
"Inuktitut");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ja",
"Japanese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("jw",
"Javanese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ka",
"Georgian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("kk",
"Kazakh");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("kl",
"Greenlandic");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("km",
"Cambodian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("kn",
"Kannada");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ko",
"Korean");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ks",
"Kashmiri");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ku",
"Kurdish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ky",
"Kirghiz");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("la",
"Latin");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ln",
"Lingala");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("lo",
"Laothian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("lt",
"Lithuanian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("lv",
"Latvian, Lettish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("mg",
"Malagasy");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("mi",
"Maori");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("mk",
"Macedonian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ml",
"Malayalam");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("mn",
"Mongolian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("mo",
"Moldavian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("mr",
"Marathi");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ms",
"Malay");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("mt",
"Maltese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("my",
"Burmese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("na",
"Nauru");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ne",
"Nepali");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("nl",
"Dutch");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("no",
"Norwegian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("oc",
"Occitan");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("om",
"(Afan) Oromo");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("or",
"Oriya");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("pa",
"Punjabi");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("pl",
"Polish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ps",
"Pashto, Pushto");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("pt",
"Portuguese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("qu",
"Quechua");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("rm",
"Rhaeto-Romance");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("rn",
"Kirundi");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ro",
"Romanian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ru",
"Russian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("rw",
"Kinyarwanda");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sa",
"Sanskrit");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sd",
"Sindhi");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sg",
"Sangho");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sh",
"Serbo-Croatian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("si",
"Sinhalese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sk",
"Slovak");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sl",
"Slovenian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sm",
"Samoan");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sn",
"Shona");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("so",
"Somali");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sq",
"Albanian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sr",
"Serbian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ss",
"Siswati");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("st",
"Sesotho");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("su",
"Sundanese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sv",
"Swedish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("sw",
"Swahili");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ta",
"Tamil");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("te",
"Telugu");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("tg",
"Tajik");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("th",
"Thai");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ti",
"Tigrinya");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("tk",
"Turkmen");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("tl",
"Tagalog");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("tn",
"Setswana");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("to",
"Tonga");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("tr",
"Turkish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ts",
"Tsonga");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("tt",
"Tatar");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("tw",
"Twi");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ug",
"Uighur");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("uk",
"Ukrainian");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("ur",
"Urdu");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("uz",
"Uzbek");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("vi",
"Vietnamese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("vo",
"Volapuk");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("wo",
"Wolof");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("xh",
"Xhosa");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("yi",
"Yiddish");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("yo",
"Yoruba");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("za",
"Zhuang");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("zh",
"Chinese");
INSERT INTO pgw_cdb_language (language_code, language_name) VALUES ("zu",
"Zulu");
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/04
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1,
skwashd <=
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/05
- Prev by Date:
[Phpgroupware-cvs] old/cdb/inc class.cdb_contact_phone.inc.php, 1.1 class.cdb_contact_personal.inc.php, 1.1 class.cdb_contact_internet.inc.php, 1.1 class.cdb_entity.inc.php, 1.1 class.cdb_entity_meta.inc.php, 1.1 class.cdb_organization_client.inc.php, 1.1 class.cdb_organization.inc.php, 1.1 class.cdb_generic.inc.php, 1.1 class.cdb_contact_client.inc.php, 1.1 class.cdb_contact_address.inc.php, 1.1 class.bo.inc.php, 1.1 class.cdb_contact.inc.php, 1.1 class.cdb_address.inc.php, 1.1 class.bo_filter.inc.php, 1.1 class.cdb_organization_location.inc.php, 1.1 class.cdb_phone.inc.php, 1.1 class.ui.inc.php, 1.1 class.so.inc.php, 1.1 class.cdb_template.inc.php, 1.1 class.ui_generic.inc.php, 1.1 class.ui_overview.inc.php, 1.1
- Next by Date:
[Phpgroupware-cvs] chora/debian rules, 1.2 copyright, 1.2 control, 1.2 changelog, 1.2
- Previous by thread:
[Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1
- Next by thread:
[Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1
- Index(es):