[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, (continued)
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [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/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/06
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/07
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/07
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/07
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/07
- [Phpgroupware-cvs] old/cdb/doc/examples/sql cdb.sql, 1.1 cdb_language.sql, 1.1, skwashd, 2005/05/07
- Prev by Date:
[Phpgroupware-cvs] old/anthill CHANGES, 1.1 enterbug.php, 1.1 faq.php, 1.1 editversions.php, 1.1 editusers.php, 1.1 editproducts.php, 1.1 gpgupload.php, 1.1 index.php, 1.1 postbug.php, 1.1 newuser.php, 1.1 logout.php, 1.1 login.php, 1.1 editcomponents.php, 1.1 createattachment.php, 1.1 README.1st, 1.1 README, 1.1 COPYING, 1.1 README.OSX, 1.1 THANKS, 1.1 buglist.php, 1.1 admin.php, 1.1 activity.php, 1.1 TODO, 1.1 pref.php, 1.1 TRANSLATORS, 1.1 query.php, 1.1 textreport.php, 1.1 reports.php, 1.1 showattachment.php, 1.1 setup.php, 1.1
- Next by Date:
[Phpgroupware-cvs] packages/doc changelog, 1.2 copyright.gpl, 1.2 README.sgml, 1.3
- 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):