[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: mediadb/doc/examples/sql all_in_one.mysql,NONE,1
|
From: |
Luca - De Whiskey's - De Vitis <address@hidden> |
|
Subject: |
[Phpgroupware-cvs] CVS: mediadb/doc/examples/sql all_in_one.mysql,NONE,1.1 cat.sql,NONE,1.1 create_tables.mysql,NONE,1.1 destroy_tables.mysql,NONE,1.1 lang.sql,NONE,1.1 main_lang.sql,NONE,1.1 media_lookup.sql,NONE,1.1 register_app.mysql,NONE,1.1 |
|
Date: |
Mon, 10 Jun 2002 09:01:48 -0400 |
Update of /cvsroot/phpgroupware/mediadb/doc/examples/sql
In directory subversions:/tmp/cvs-serv15597/mediadb/doc/examples/sql
Added Files:
all_in_one.mysql cat.sql create_tables.mysql
destroy_tables.mysql lang.sql main_lang.sql media_lookup.sql
register_app.mysql
Log Message:
Minor changes to directory structure:
- Moved old sql files to a more suitable place.
- Moved chora/docs to chora/doc
--- NEW FILE ---
# mediadb MySQL dump
#
# Table structure for table 'phpgw_mediadb'
#
DROP TABLE IF EXISTS phpgw_mediadb;
CREATE TABLE phpgw_mediadb (
media_id int(11) DEFAULT '0' NOT NULL auto_increment,
media_owner varchar(25),
media_access varchar(10),
media_score int(4) DEFAULT '0' NOT NULL,
media_hscore int(20) DEFAULT '0' NOT NULL,
media_idate datetime NOT NULL,
media_avail tinyint(4) DEFAULT '1' NOT NULL,
data_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (media_id)
);
#
# Table structure for table 'phpgw_mediadb_request'
#
DROP TABLE IF EXISTS phpgw_mediadb_request;
CREATE TABLE phpgw_mediadb_request (
request_id int(11) DEFAULT '0' NOT NULL auto_increment,
request_owner varchar(25) DEFAULT '' NOT NULL,
request_status enum('new','pend','honor','deny') DEFAULT 'new' NOT NULL,
request_date date DEFAULT '0000-00-00' NOT NULL,
request_date_r date DEFAULT '0000-00-00' NOT NULL,
media_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (request_id)
);
#
# Table structure for table 'phpgw_mediadb_loan'
#
DROP TABLE IF EXISTS phpgw_mediadb_loan;
CREATE TABLE phpgw_mediadb_loan (
loan_id int(11) DEFAULT '0' NOT NULL auto_increment,
loan_owner varchar(25) DEFAULT 'Library' NOT NULL,
loan_borrower varchar(25) DEFAULT '' NOT NULL,
loan_date date DEFAULT '0000-00-00' NOT NULL,
loan_date_due date DEFAULT '0000-00-00' NOT NULL,
loan_date_ret date DEFAULT '0000-00-00' NOT NULL,
loan_returned tinyint(4) DEFAULT '0' NOT NULL,
media_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (loan_id),
KEY media_id (media_id),
KEY loan_borrower (loan_borrower),
KEY loan_owner (loan_owner)
);
#
# Table structure for table 'phpgw_mediadb_data'
#
DROP TABLE IF EXISTS phpgw_mediadb_data;
CREATE TABLE phpgw_mediadb_data (
data_id int(11) DEFAULT '0' NOT NULL auto_increment,
data_genre varchar(255),
data_feature varchar(255),
data_artist varchar(255),
data_publisher varchar(255),
data_code varchar(10) DEFAULT '0' NOT NULL,
data_title varchar(255) DEFAULT '' NOT NULL,
data_date year(4),
data_comments varchar(255),
data_score int(4) DEFAULT '0' NOT NULL,
data_image varchar(255) DEFAULT 'default.jpg' NOT NULL,
data_efile varchar(255),
data_pages smallint(6),
data_hscore int(20) DEFAULT '0' NOT NULL,
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
rating_id smallint(5) unsigned DEFAULT '0' NOT NULL,
format_id smallint(5) unsigned DEFAULT '0' NOT NULL,
region_id smallint(5) unsigned,
PRIMARY KEY (data_id),
KEY data_code (data_code)
);
#
# Table structure for table 'phpgw_mediadb_type'
#
DROP TABLE IF EXISTS phpgw_mediadb_cat;
CREATE TABLE phpgw_mediadb_cat(
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
cat_name varchar(50),
cat_enabled smallint(5) unsigned DEFAULT '1' NOT NULL,
cat_fname varchar(255),
cat_fenabled varchar(255),
cat_fwidth varchar(255),
cat_fsort varchar(255),
PRIMARY KEY (cat_id)
);
LOCK TABLES phpgw_mediadb_cat WRITE;
INSERT INTO phpgw_mediadb_cat VALUES (1,'default',2,
"phpgw_mediadb_data.data_title,phpgw_mediadb_artist.artist_name,phpgw_mediadb_format.format_desc,phpgw_mediadb_data.data_date,phpgw_mediadb.media_idate,phpgw_mediadb_genre.genre_desc,phpgw_mediadb_rating.rating_desc,phpgw_mediadb_data.data_score,phpgw_mediadb.media_owner,phpgw_mediadb_data.data_comments,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (2,'archives',1,
"title,admin,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,0,1,0,0,0,1,1,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (3,'books',1,
"title,author,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (4,'games',1,
"title,developer,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (5,'movies',1,
"title,actor,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,1,1,1",
"20,15,5,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (6,'music',1,
"title,artist,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_feature'
#
DROP TABLE IF EXISTS phpgw_mediadb_feature;
CREATE TABLE phpgw_mediadb_feature(
feature_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
feature_type varchar(50),
feature_desc varchar(255),
PRIMARY KEY (feature_id)
);
# DVD - region, length, screen format, languages, subtitles, sound, sides, etc.
# - plot, audio/video, extras, comments (screenit.com)
#
# Table structure for table 'phpgw_mediadb_rating'
#
DROP TABLE IF EXISTS phpgw_mediadb_rating;
CREATE TABLE phpgw_mediadb_rating (
rating_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
rating_desc varchar(64),
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (rating_id)
);
LOCK TABLES phpgw_mediadb_rating WRITE;
# default
INSERT INTO phpgw_mediadb_rating VALUES (1,'G',1);
INSERT INTO phpgw_mediadb_rating VALUES (2,'PG',1);
INSERT INTO phpgw_mediadb_rating VALUES (3,'PG-13',1);
INSERT INTO phpgw_mediadb_rating VALUES (4,'R',1);
INSERT INTO phpgw_mediadb_rating VALUES (5,'NC-17',1);
INSERT INTO phpgw_mediadb_rating VALUES (6,'Unrated',1);
# book
INSERT INTO phpgw_mediadb_rating VALUES (7,'G',3);
INSERT INTO phpgw_mediadb_rating VALUES (8,'PG',3);
INSERT INTO phpgw_mediadb_rating VALUES (9,'PG-13',3);
INSERT INTO phpgw_mediadb_rating VALUES (10,'R',3);
INSERT INTO phpgw_mediadb_rating VALUES (11,'NC-17',3);
INSERT INTO phpgw_mediadb_rating VALUES (12,'Unrated',3);
# game
INSERT INTO phpgw_mediadb_rating VALUES (13,'EC - Early Childhood',4);
INSERT INTO phpgw_mediadb_rating VALUES (14,'E - Everyone',4);
INSERT INTO phpgw_mediadb_rating VALUES (15,'T - Teen',4);
INSERT INTO phpgw_mediadb_rating VALUES (16,'M - Mature',4);
INSERT INTO phpgw_mediadb_rating VALUES (17,'AO - Adults Only',4);
INSERT INTO phpgw_mediadb_rating VALUES (18,'RP - Rating Pending',4);
# movie
INSERT INTO phpgw_mediadb_rating VALUES (19,'G',5);
INSERT INTO phpgw_mediadb_rating VALUES (20,'PG',5);
INSERT INTO phpgw_mediadb_rating VALUES (21,'PG-13',5);
INSERT INTO phpgw_mediadb_rating VALUES (22,'R',5);
INSERT INTO phpgw_mediadb_rating VALUES (23,'NC-17',5);
INSERT INTO phpgw_mediadb_rating VALUES (24,'Unrated',5);
# music
INSERT INTO phpgw_mediadb_rating VALUES (25,'G',6);
INSERT INTO phpgw_mediadb_rating VALUES (26,'PG',6);
INSERT INTO phpgw_mediadb_rating VALUES (27,'PG-13',6);
INSERT INTO phpgw_mediadb_rating VALUES (28,'R',6);
INSERT INTO phpgw_mediadb_rating VALUES (29,'NC-17',6);
INSERT INTO phpgw_mediadb_rating VALUES (30,'Unrated',6);
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_format'
#
DROP TABLE IF EXISTS phpgw_mediadb_format;
CREATE TABLE phpgw_mediadb_format (
format_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
format_desc varchar(64),
format_efiles smallint(5) unsigned DEFAULT '0' NOT NULL,
format_pages smallint(5) unsigned DEFAULT '0' NOT NULL,
format_regions smallint(5) unsigned DEFAULT '0' NOT NULL,
format_hscores smallint(5) unsigned DEFAULT '0' NOT NULL,
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (format_id)
);
#
# Dumping data for table 'phpgw_mediadb_format'
#
LOCK TABLES phpgw_mediadb_format WRITE;
# book
INSERT INTO phpgw_mediadb_format VALUES (1,'Cassette',0,0,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (2,'CD',0,0,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (3,'Paperback',0,1,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (4,'Hardcover',0,1,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (5,'Ebook',1,1,0,0,3);
# game
INSERT INTO phpgw_mediadb_format VALUES (6,'Atari',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (7,'PC CD',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (8,'PC DVD',0,0,1,1,4);
INSERT INTO phpgw_mediadb_format VALUES (9,'PC 3.5',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (10,'PC 5.0',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (11,'Sega Genesis',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (12,'Sega Dreamcast',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (13,'Sega Gamegear',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (14,'Sony Playstation',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (15,'Nintendo',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (16,'Nintendo SNES',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (17,'Nintendo 64',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (18,'Nintendo Gameboy',0,0,0,1,4);
# movie
INSERT INTO phpgw_mediadb_format VALUES (19,'DVD',0,0,1,0,5);
INSERT INTO phpgw_mediadb_format VALUES (20,'VHS',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (21,'BETA',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (22,'LD',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (23,'HI8',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (24,'Digital 8',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (25,'8MM',0,0,0,0,5);
# music
INSERT INTO phpgw_mediadb_format VALUES (26,'CD',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (27,'Cassette',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (28,'LP',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (29,'45',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (30,'8-track',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (31,'MCD',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (32,'MP3',1,0,0,0,6);
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_genre'
#
DROP TABLE IF EXISTS phpgw_mediadb_genre;
CREATE TABLE phpgw_mediadb_genre (
genre_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
genre_desc varchar(64),
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (genre_id)
);
#
# Dumping data for table 'phpgw_mediadb_genre'
#
LOCK TABLES phpgw_mediadb_genre WRITE;
# book
INSERT INTO phpgw_mediadb_genre VALUES (1,'Science Fiction',3);
INSERT INTO phpgw_mediadb_genre VALUES (2,'Drama',3);
INSERT INTO phpgw_mediadb_genre VALUES (3,'Horror',3);
INSERT INTO phpgw_mediadb_genre VALUES (4,'Action',3);
INSERT INTO phpgw_mediadb_genre VALUES (5,'Comedy',3);
INSERT INTO phpgw_mediadb_genre VALUES (6,'Non Fiction',3);
INSERT INTO phpgw_mediadb_genre VALUES (7,'Western',3);
INSERT INTO phpgw_mediadb_genre VALUES (8,'Thriller',3);
INSERT INTO phpgw_mediadb_genre VALUES (9,'Adventure',3);
INSERT INTO phpgw_mediadb_genre VALUES (10,'Comic',3);
INSERT INTO phpgw_mediadb_genre VALUES (11,'Fantasy',3);
INSERT INTO phpgw_mediadb_genre VALUES (12,'Mystery',3);
INSERT INTO phpgw_mediadb_genre VALUES (13,'Romance',3);
INSERT INTO phpgw_mediadb_genre VALUES (14,'War',3);
INSERT INTO phpgw_mediadb_genre VALUES (15,'Cult',3);
# game
INSERT INTO phpgw_mediadb_genre VALUES (16,'Science Fiction',4);
INSERT INTO phpgw_mediadb_genre VALUES (17,'Drama',4);
INSERT INTO phpgw_mediadb_genre VALUES (18,'Horror',4);
INSERT INTO phpgw_mediadb_genre VALUES (19,'Action',4);
INSERT INTO phpgw_mediadb_genre VALUES (20,'Comedy',4);
INSERT INTO phpgw_mediadb_genre VALUES (21,'Non Fiction',4);
INSERT INTO phpgw_mediadb_genre VALUES (22,'Western',4);
INSERT INTO phpgw_mediadb_genre VALUES (23,'Thriller',4);
INSERT INTO phpgw_mediadb_genre VALUES (24,'Adventure',4);
INSERT INTO phpgw_mediadb_genre VALUES (25,'Fantasy',4);
INSERT INTO phpgw_mediadb_genre VALUES (26,'Mystery',4);
INSERT INTO phpgw_mediadb_genre VALUES (27,'Romance',4);
INSERT INTO phpgw_mediadb_genre VALUES (28,'War',4);
INSERT INTO phpgw_mediadb_genre VALUES (29,'Cult',4);
# movie
INSERT INTO phpgw_mediadb_genre VALUES (30,'Science Fiction',5);
INSERT INTO phpgw_mediadb_genre VALUES (31,'Drama',5);
INSERT INTO phpgw_mediadb_genre VALUES (32,'Horror',5);
INSERT INTO phpgw_mediadb_genre VALUES (33,'Action',5);
INSERT INTO phpgw_mediadb_genre VALUES (34,'Comedy',5);
INSERT INTO phpgw_mediadb_genre VALUES (35,'Non Fiction',5);
INSERT INTO phpgw_mediadb_genre VALUES (36,'Western',5);
INSERT INTO phpgw_mediadb_genre VALUES (37,'Film Noir',5);
INSERT INTO phpgw_mediadb_genre VALUES (38,'Musical',5);
INSERT INTO phpgw_mediadb_genre VALUES (39,'Thriller',5);
INSERT INTO phpgw_mediadb_genre VALUES (40,'Adventure',5);
INSERT INTO phpgw_mediadb_genre VALUES (41,'Animation',5);
INSERT INTO phpgw_mediadb_genre VALUES (42,'Anime',5);
INSERT INTO phpgw_mediadb_genre VALUES (43,'Fantasy',5);
INSERT INTO phpgw_mediadb_genre VALUES (44,'Mystery',5);
INSERT INTO phpgw_mediadb_genre VALUES (45,'Romance',5);
INSERT INTO phpgw_mediadb_genre VALUES (46,'War',5);
INSERT INTO phpgw_mediadb_genre VALUES (47,'Cult',5);
INSERT INTO phpgw_mediadb_genre VALUES (48,'Music Video',5);
# music
INSERT INTO phpgw_mediadb_genre VALUES (49,'Acapella',6);
INSERT INTO phpgw_mediadb_genre VALUES (50,'Acid',6);
INSERT INTO phpgw_mediadb_genre VALUES (51,'Acoustic',6);
INSERT INTO phpgw_mediadb_genre VALUES (52,'Alternative',6);
INSERT INTO phpgw_mediadb_genre VALUES (53,'Ambient',6);
INSERT INTO phpgw_mediadb_genre VALUES (54,'Anime',6);
INSERT INTO phpgw_mediadb_genre VALUES (55,'Avantgarde',6);
INSERT INTO phpgw_mediadb_genre VALUES (56,'Ballad',6);
INSERT INTO phpgw_mediadb_genre VALUES (57,'Bass',6);
INSERT INTO phpgw_mediadb_genre VALUES (58,'Beat',6);
INSERT INTO phpgw_mediadb_genre VALUES (59,'Bebob',6);
INSERT INTO phpgw_mediadb_genre VALUES (60,'Big Band',6);
INSERT INTO phpgw_mediadb_genre VALUES (61,'Black',6);
INSERT INTO phpgw_mediadb_genre VALUES (62,'Bluegrass',6);
INSERT INTO phpgw_mediadb_genre VALUES (63,'Blues',6);
INSERT INTO phpgw_mediadb_genre VALUES (64,'Booty',6);
INSERT INTO phpgw_mediadb_genre VALUES (65,'BritPop',6);
INSERT INTO phpgw_mediadb_genre VALUES (66,'Cabaret',6);
INSERT INTO phpgw_mediadb_genre VALUES (67,'Celtic',6);
INSERT INTO phpgw_mediadb_genre VALUES (68,'Chamber Music',6);
INSERT INTO phpgw_mediadb_genre VALUES (69,'Chanson',6);
INSERT INTO phpgw_mediadb_genre VALUES (70,'Chorus',6);
INSERT INTO phpgw_mediadb_genre VALUES (71,'Christian',6);
INSERT INTO phpgw_mediadb_genre VALUES (72,'Classic',6);
INSERT INTO phpgw_mediadb_genre VALUES (73,'Classical',6);
INSERT INTO phpgw_mediadb_genre VALUES (74,'Club',6);
INSERT INTO phpgw_mediadb_genre VALUES (75,'Comedy',6);
INSERT INTO phpgw_mediadb_genre VALUES (76,'Contemporary',6);
INSERT INTO phpgw_mediadb_genre VALUES (77,'Country',6);
INSERT INTO phpgw_mediadb_genre VALUES (78,'Crossover',6);
INSERT INTO phpgw_mediadb_genre VALUES (79,'Cult',6);
INSERT INTO phpgw_mediadb_genre VALUES (80,'Dance',6);
INSERT INTO phpgw_mediadb_genre VALUES (81,'Dance Hall',6);
INSERT INTO phpgw_mediadb_genre VALUES (82,'Darkwave',6);
INSERT INTO phpgw_mediadb_genre VALUES (83,'Death',6);
INSERT INTO phpgw_mediadb_genre VALUES (84,'Disco',6);
INSERT INTO phpgw_mediadb_genre VALUES (85,'Dream',6);
INSERT INTO phpgw_mediadb_genre VALUES (86,'Drum',6);
INSERT INTO phpgw_mediadb_genre VALUES (87,'Duet',6);
INSERT INTO phpgw_mediadb_genre VALUES (88,'Easy Listening',6);
INSERT INTO phpgw_mediadb_genre VALUES (89,'Electronic',6);
INSERT INTO phpgw_mediadb_genre VALUES (90,'Ethnic',6);
INSERT INTO phpgw_mediadb_genre VALUES (91,'Euro',6);
INSERT INTO phpgw_mediadb_genre VALUES (92,'Fast Fusion',6);
INSERT INTO phpgw_mediadb_genre VALUES (93,'Folk',6);
INSERT INTO phpgw_mediadb_genre VALUES (94,'Folklore',6);
INSERT INTO phpgw_mediadb_genre VALUES (95,'Freestyle',6);
INSERT INTO phpgw_mediadb_genre VALUES (96,'Funk',6);
INSERT INTO phpgw_mediadb_genre VALUES (97,'Fusion',6);
INSERT INTO phpgw_mediadb_genre VALUES (98,'Game',6);
INSERT INTO phpgw_mediadb_genre VALUES (99,'Gangsta',6);
INSERT INTO phpgw_mediadb_genre VALUES (100,'Gospel',6);
INSERT INTO phpgw_mediadb_genre VALUES (101,'Gothic',6);
INSERT INTO phpgw_mediadb_genre VALUES (102,'Grunge',6);
INSERT INTO phpgw_mediadb_genre VALUES (103,'Guitar',6);
INSERT INTO phpgw_mediadb_genre VALUES (104,'Hard',6);
INSERT INTO phpgw_mediadb_genre VALUES (105,'Hardcore',6);
INSERT INTO phpgw_mediadb_genre VALUES (106,'Heavy',6);
INSERT INTO phpgw_mediadb_genre VALUES (107,'Hip Hop',6);
INSERT INTO phpgw_mediadb_genre VALUES (108,'House',6);
INSERT INTO phpgw_mediadb_genre VALUES (109,'Humour',6);
INSERT INTO phpgw_mediadb_genre VALUES (110,'Hymn',6);
INSERT INTO phpgw_mediadb_genre VALUES (111,'Indie',6);
INSERT INTO phpgw_mediadb_genre VALUES (112,'Industrial',6);
INSERT INTO phpgw_mediadb_genre VALUES (113,'Inspirational',6);
INSERT INTO phpgw_mediadb_genre VALUES (114,'Instrumental',6);
INSERT INTO phpgw_mediadb_genre VALUES (115,'JPop',6);
INSERT INTO phpgw_mediadb_genre VALUES (116,'Jam',6);
INSERT INTO phpgw_mediadb_genre VALUES (117,'Jazz',6);
INSERT INTO phpgw_mediadb_genre VALUES (118,'Jungle',6);
INSERT INTO phpgw_mediadb_genre VALUES (119,'Latin',6);
INSERT INTO phpgw_mediadb_genre VALUES (120,'Lo-Fi',6);
INSERT INTO phpgw_mediadb_genre VALUES (121,'Meditative',6);
INSERT INTO phpgw_mediadb_genre VALUES (122,'Merengue',6);
INSERT INTO phpgw_mediadb_genre VALUES (123,'Metal',6);
INSERT INTO phpgw_mediadb_genre VALUES (124,'Musical',6);
INSERT INTO phpgw_mediadb_genre VALUES (125,'National',6);
INSERT INTO phpgw_mediadb_genre VALUES (126,'Native US',6);
INSERT INTO phpgw_mediadb_genre VALUES (127,'Negerpunk',6);
INSERT INTO phpgw_mediadb_genre VALUES (128,'New Age',6);
INSERT INTO phpgw_mediadb_genre VALUES (129,'New Wave',6);
INSERT INTO phpgw_mediadb_genre VALUES (130,'Noise',6);
INSERT INTO phpgw_mediadb_genre VALUES (131,'Oldies',6);
INSERT INTO phpgw_mediadb_genre VALUES (132,'Opera',6);
INSERT INTO phpgw_mediadb_genre VALUES (133,'Other',6);
INSERT INTO phpgw_mediadb_genre VALUES (134,'Polka',6);
INSERT INTO phpgw_mediadb_genre VALUES (135,'Pop',6);
INSERT INTO phpgw_mediadb_genre VALUES (136,'Power',6);
INSERT INTO phpgw_mediadb_genre VALUES (137,'Pranks',6);
INSERT INTO phpgw_mediadb_genre VALUES (138,'Primus',6);
INSERT INTO phpgw_mediadb_genre VALUES (139,'Progressive',6);
INSERT INTO phpgw_mediadb_genre VALUES (140,'Psychadelic',6);
INSERT INTO phpgw_mediadb_genre VALUES (141,'Punk',6);
INSERT INTO phpgw_mediadb_genre VALUES (142,'Rap',6);
INSERT INTO phpgw_mediadb_genre VALUES (143,'Rave',6);
INSERT INTO phpgw_mediadb_genre VALUES (144,'Reggae',6);
INSERT INTO phpgw_mediadb_genre VALUES (145,'Retro',6);
INSERT INTO phpgw_mediadb_genre VALUES (146,'Revival',6);
INSERT INTO phpgw_mediadb_genre VALUES (147,'Rhythmic',6);
INSERT INTO phpgw_mediadb_genre VALUES (148,'Rock',6);
INSERT INTO phpgw_mediadb_genre VALUES (149,'Rock & Roll',6);
INSERT INTO phpgw_mediadb_genre VALUES (150,'Salsa',6);
INSERT INTO phpgw_mediadb_genre VALUES (151,'Samba',6);
INSERT INTO phpgw_mediadb_genre VALUES (152,'Satire',6);
INSERT INTO phpgw_mediadb_genre VALUES (153,'Showtunes',6);
INSERT INTO phpgw_mediadb_genre VALUES (154,'Slow',6);
INSERT INTO phpgw_mediadb_genre VALUES (155,'Solo',6);
INSERT INTO phpgw_mediadb_genre VALUES (156,'Sonata',6);
INSERT INTO phpgw_mediadb_genre VALUES (157,'Soul',6);
INSERT INTO phpgw_mediadb_genre VALUES (158,'Sound Clip',6);
INSERT INTO phpgw_mediadb_genre VALUES (159,'Soundtrack',6);
INSERT INTO phpgw_mediadb_genre VALUES (160,'Southern',6);
INSERT INTO phpgw_mediadb_genre VALUES (161,'Space',6);
INSERT INTO phpgw_mediadb_genre VALUES (162,'Speech',6);
INSERT INTO phpgw_mediadb_genre VALUES (163,'Swing',6);
INSERT INTO phpgw_mediadb_genre VALUES (164,'Symphonic',6);
INSERT INTO phpgw_mediadb_genre VALUES (165,'Symphony',6);
INSERT INTO phpgw_mediadb_genre VALUES (166,'Synth',6);
INSERT INTO phpgw_mediadb_genre VALUES (167,'Tango',6);
INSERT INTO phpgw_mediadb_genre VALUES (168,'Techno',6);
INSERT INTO phpgw_mediadb_genre VALUES (169,'Terror',6);
INSERT INTO phpgw_mediadb_genre VALUES (170,'Top 40',6);
INSERT INTO phpgw_mediadb_genre VALUES (171,'Trailer',6);
INSERT INTO phpgw_mediadb_genre VALUES (172,'Trance',6);
INSERT INTO phpgw_mediadb_genre VALUES (173,'Trash',6);
INSERT INTO phpgw_mediadb_genre VALUES (174,'Tribal',6);
INSERT INTO phpgw_mediadb_genre VALUES (175,'Trip-Hop',6);
INSERT INTO phpgw_mediadb_genre VALUES (176,'Vocal',6);
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_region'
#
DROP TABLE IF EXISTS phpgw_mediadb_region;
CREATE TABLE phpgw_mediadb_region (
region_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
region_code smallint(5) unsigned DEFAULT '0' NOT NULL,
region_desc varchar(25) DEFAULT '' NOT NULL,
PRIMARY KEY (region_id),
KEY region_code (region_code)
);
#
# Dumping data for table 'phpgw_mediadb_region'
#
LOCK TABLES phpgw_mediadb_region WRITE;
INSERT INTO phpgw_mediadb_region VALUES (1,1,'USA');
INSERT INTO phpgw_mediadb_region VALUES (2,1,'Canada');
INSERT INTO phpgw_mediadb_region VALUES (3,2,'Europe');
INSERT INTO phpgw_mediadb_region VALUES (4,2,'Japan');
INSERT INTO phpgw_mediadb_region VALUES (5,3,'Orient');
INSERT INTO phpgw_mediadb_region VALUES (6,4,'Australia');
INSERT INTO phpgw_mediadb_region VALUES (7,4,'New Zealand');
INSERT INTO phpgw_mediadb_region VALUES (8,5,'Asia');
INSERT INTO phpgw_mediadb_region VALUES (9,5,'Africa');
INSERT INTO phpgw_mediadb_region VALUES (10,6,'China');
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_artist'
#
# - author, artist, actor, programmer
DROP TABLE IF EXISTS phpgw_mediadb_artist;
CREATE TABLE phpgw_mediadb_artist (
artist_id smallint(5) unsigned NOT NULL auto_increment,
artist_fname varchar(50),
artist_lname varchar(50),
PRIMARY KEY (artist_id)
);
#
# Table structure for table 'phpgw_mediadb_publisher'
#
# - distributor, publisher
DROP TABLE IF EXISTS phpgw_mediadb_publisher;
CREATE TABLE phpgw_mediadb_publisher (
publisher_id smallint(5) unsigned NOT NULL auto_increment,
publisher_name varchar(50),
PRIMARY KEY (publisher_id)
);
--- NEW FILE ---
#
# Table structure for table 'phpgw_mediadb_type'
#
DROP TABLE IF EXISTS phpgw_mediadb_cat;
CREATE TABLE phpgw_mediadb_cat(
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
cat_name varchar(50),
cat_enabled smallint(5) unsigned DEFAULT '1' NOT NULL,
cat_fname varchar(255),
cat_fenabled varchar(255),
cat_fwidth varchar(255),
cat_fsort varchar(255),
PRIMARY KEY (cat_id)
);
LOCK TABLES phpgw_mediadb_cat WRITE;
INSERT INTO phpgw_mediadb_cat VALUES (1,'default',2,
"phpgw_mediadb_data.data_title,phpgw_mediadb_artist.artist_name,phpgw_mediadb_format.format_desc,phpgw_mediadb_data.data_date,phpgw_mediadb.media_idate,phpgw_mediadb_genre.genre_desc,phpgw_mediadb_rating.rating_desc,phpgw_mediadb_data.data_score,phpgw_mediadb.media_owner,phpgw_mediadb_data.data_comments,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (2,'archives',1,
"title,admin,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,0,1,0,0,0,1,1,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (3,'books',1,
"title,author,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (4,'games',1,
"title,developer,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (5,'movies',1,
"title,actor,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,1,1,1",
"20,15,5,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (6,'music',1,
"title,artist,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
UNLOCK TABLES;
--- NEW FILE ---
# mediadb MySQL dump
#
# Table structure for table 'phpgw_mediadb'
#
CREATE TABLE phpgw_mediadb (
media_id int(11) DEFAULT '0' NOT NULL auto_increment,
media_owner varchar(25),
media_access varchar(10),
media_score int(4) DEFAULT '0' NOT NULL,
media_hscore int(20) DEFAULT '0' NOT NULL,
media_idate datetime NOT NULL,
media_avail tinyint(4) DEFAULT '1' NOT NULL,
data_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (media_id)
);
#
# Table structure for table 'phpgw_mediadb_request'
#
CREATE TABLE phpgw_mediadb_request (
request_id int(11) DEFAULT '0' NOT NULL auto_increment,
request_owner varchar(25) DEFAULT '' NOT NULL,
request_status enum('new','pend','honor','deny') DEFAULT 'new' NOT NULL,
request_date date DEFAULT '0000-00-00' NOT NULL,
request_date_r date DEFAULT '0000-00-00' NOT NULL,
media_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (request_id)
);
#
# Table structure for table 'phpgw_mediadb_loan'
#
CREATE TABLE phpgw_mediadb_loan (
loan_id int(11) DEFAULT '0' NOT NULL auto_increment,
loan_owner varchar(25) DEFAULT 'Library' NOT NULL,
loan_borrower varchar(25) DEFAULT '' NOT NULL,
loan_date date DEFAULT '0000-00-00' NOT NULL,
loan_date_due date DEFAULT '0000-00-00' NOT NULL,
loan_date_ret date DEFAULT '0000-00-00' NOT NULL,
loan_returned tinyint(4) DEFAULT '0' NOT NULL,
media_id int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (loan_id),
KEY media_id (media_id),
KEY loan_borrower (loan_borrower),
KEY loan_owner (loan_owner)
);
#
# Table structure for table 'phpgw_mediadb_data'
#
CREATE TABLE phpgw_mediadb_data (
data_id int(11) DEFAULT '0' NOT NULL auto_increment,
data_genre varchar(255),
data_feature varchar(255),
data_artist varchar(255),
data_publisher varchar(255),
data_code varchar(10) DEFAULT '0' NOT NULL,
data_title varchar(255) DEFAULT '' NOT NULL,
data_date year(4),
data_comments varchar(255),
data_score int(4) DEFAULT '0' NOT NULL,
data_image varchar(255) DEFAULT 'default.jpg' NOT NULL,
data_efile varchar(255),
data_pages smallint(6),
data_hscore int(20) DEFAULT '0' NOT NULL,
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
rating_id smallint(5) unsigned DEFAULT '0' NOT NULL,
format_id smallint(5) unsigned DEFAULT '0' NOT NULL,
region_id smallint(5) unsigned,
PRIMARY KEY (data_id),
KEY data_code (data_code)
);
#
# Table structure for table 'phpgw_mediadb_type'
#
CREATE TABLE phpgw_mediadb_cat(
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
cat_name varchar(50),
cat_enabled smallint(5) unsigned DEFAULT '1' NOT NULL,
cat_fname varchar(255),
cat_fenabled varchar(255),
cat_fwidth varchar(255),
cat_fsort varchar(255),
PRIMARY KEY (cat_id)
);
LOCK TABLES phpgw_mediadb_cat WRITE;
INSERT INTO phpgw_mediadb_cat VALUES (1,'default',2,
"phpgw_mediadb_data.data_title,phpgw_mediadb_artist.artist_name,phpgw_mediadb_format.format_desc,phpgw_mediadb_data.data_date,phpgw_mediadb.media_idate,phpgw_mediadb_genre.genre_desc,phpgw_mediadb_rating.rating_desc,phpgw_mediadb_data.data_score,phpgw_mediadb.media_owner,phpgw_mediadb_data.data_comments,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (2,'archives',1,
"title,admin,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,0,1,0,0,0,1,1,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (3,'books',1,
"title,author,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (4,'games',1,
"title,developer,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (5,'movies',1,
"title,actor,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,1,1,1",
"20,15,5,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
INSERT INTO phpgw_mediadb_cat VALUES (6,'music',1,
"title,artist,media,year,date,genre,rated,scoring,owner,comment,imdb,edit,avail",
"1,1,1,1,0,1,1,1,1,0,2,1,1",
"20,15,10,5,10,10,5,5,10,16,4,4,1",
"1,0,0,0,0,0,0,0,0,0,0,0,0");
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_feature'
#
CREATE TABLE phpgw_mediadb_feature(
feature_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
feature_type varchar(50),
feature_desc varchar(255),
PRIMARY KEY (feature_id)
);
# DVD - region, length, screen format, languages, subtitles, sound, sides, etc.
# - plot, audio/video, extras, comments (screenit.com)
#
# Table structure for table 'phpgw_mediadb_rating'
#
CREATE TABLE phpgw_mediadb_rating (
rating_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
rating_desc varchar(64),
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (rating_id)
);
LOCK TABLES phpgw_mediadb_rating WRITE;
# default
INSERT INTO phpgw_mediadb_rating VALUES (1,'G',1);
INSERT INTO phpgw_mediadb_rating VALUES (2,'PG',1);
INSERT INTO phpgw_mediadb_rating VALUES (3,'PG-13',1);
INSERT INTO phpgw_mediadb_rating VALUES (4,'R',1);
INSERT INTO phpgw_mediadb_rating VALUES (5,'NC-17',1);
INSERT INTO phpgw_mediadb_rating VALUES (6,'Unrated',1);
# book
INSERT INTO phpgw_mediadb_rating VALUES (7,'G',3);
INSERT INTO phpgw_mediadb_rating VALUES (8,'PG',3);
INSERT INTO phpgw_mediadb_rating VALUES (9,'PG-13',3);
INSERT INTO phpgw_mediadb_rating VALUES (10,'R',3);
INSERT INTO phpgw_mediadb_rating VALUES (11,'NC-17',3);
INSERT INTO phpgw_mediadb_rating VALUES (12,'Unrated',3);
# game
INSERT INTO phpgw_mediadb_rating VALUES (13,'EC - Early Childhood',4);
INSERT INTO phpgw_mediadb_rating VALUES (14,'E - Everyone',4);
INSERT INTO phpgw_mediadb_rating VALUES (15,'T - Teen',4);
INSERT INTO phpgw_mediadb_rating VALUES (16,'M - Mature',4);
INSERT INTO phpgw_mediadb_rating VALUES (17,'AO - Adults Only',4);
INSERT INTO phpgw_mediadb_rating VALUES (18,'RP - Rating Pending',4);
# movie
INSERT INTO phpgw_mediadb_rating VALUES (19,'G',5);
INSERT INTO phpgw_mediadb_rating VALUES (20,'PG',5);
INSERT INTO phpgw_mediadb_rating VALUES (21,'PG-13',5);
INSERT INTO phpgw_mediadb_rating VALUES (22,'R',5);
INSERT INTO phpgw_mediadb_rating VALUES (23,'NC-17',5);
INSERT INTO phpgw_mediadb_rating VALUES (24,'Unrated',5);
# music
INSERT INTO phpgw_mediadb_rating VALUES (25,'G',6);
INSERT INTO phpgw_mediadb_rating VALUES (26,'PG',6);
INSERT INTO phpgw_mediadb_rating VALUES (27,'PG-13',6);
INSERT INTO phpgw_mediadb_rating VALUES (28,'R',6);
INSERT INTO phpgw_mediadb_rating VALUES (29,'NC-17',6);
INSERT INTO phpgw_mediadb_rating VALUES (30,'Unrated',6);
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_format'
#
CREATE TABLE phpgw_mediadb_format (
format_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
format_desc varchar(64),
format_efiles smallint(5) unsigned DEFAULT '0' NOT NULL,
format_pages smallint(5) unsigned DEFAULT '0' NOT NULL,
format_regions smallint(5) unsigned DEFAULT '0' NOT NULL,
format_hscores smallint(5) unsigned DEFAULT '0' NOT NULL,
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (format_id)
);
#
# Dumping data for table 'phpgw_mediadb_format'
#
LOCK TABLES phpgw_mediadb_format WRITE;
# book
INSERT INTO phpgw_mediadb_format VALUES (1,'Cassette',0,0,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (2,'CD',0,0,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (3,'Paperback',0,1,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (4,'Hardcover',0,1,0,0,3);
INSERT INTO phpgw_mediadb_format VALUES (5,'Ebook',1,1,0,0,3);
# game
INSERT INTO phpgw_mediadb_format VALUES (6,'Atari',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (7,'PC CD',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (8,'PC DVD',0,0,1,1,4);
INSERT INTO phpgw_mediadb_format VALUES (9,'PC 3.5',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (10,'PC 5.0',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (11,'Sega Genesis',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (12,'Sega Dreamcast',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (13,'Sega Gamegear',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (14,'Sony Playstation',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (15,'Nintendo',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (16,'Nintendo SNES',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (17,'Nintendo 64',0,0,0,1,4);
INSERT INTO phpgw_mediadb_format VALUES (18,'Nintendo Gameboy',0,0,0,1,4);
# movie
INSERT INTO phpgw_mediadb_format VALUES (19,'DVD',0,0,1,0,5);
INSERT INTO phpgw_mediadb_format VALUES (20,'VHS',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (21,'BETA',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (22,'LD',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (23,'HI8',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (24,'Digital 8',0,0,0,0,5);
INSERT INTO phpgw_mediadb_format VALUES (25,'8MM',0,0,0,0,5);
# music
INSERT INTO phpgw_mediadb_format VALUES (26,'CD',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (27,'Cassette',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (28,'LP',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (29,'45',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (30,'8-track',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (31,'MCD',0,0,0,0,6);
INSERT INTO phpgw_mediadb_format VALUES (32,'MP3',1,0,0,0,6);
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_genre'
#
CREATE TABLE phpgw_mediadb_genre (
genre_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
genre_desc varchar(64),
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (genre_id)
);
#
# Dumping data for table 'phpgw_mediadb_genre'
#
LOCK TABLES phpgw_mediadb_genre WRITE;
# book
INSERT INTO phpgw_mediadb_genre VALUES (1,'Science Fiction',3);
INSERT INTO phpgw_mediadb_genre VALUES (2,'Drama',3);
INSERT INTO phpgw_mediadb_genre VALUES (3,'Horror',3);
INSERT INTO phpgw_mediadb_genre VALUES (4,'Action',3);
INSERT INTO phpgw_mediadb_genre VALUES (5,'Comedy',3);
INSERT INTO phpgw_mediadb_genre VALUES (6,'Non Fiction',3);
INSERT INTO phpgw_mediadb_genre VALUES (7,'Western',3);
INSERT INTO phpgw_mediadb_genre VALUES (8,'Thriller',3);
INSERT INTO phpgw_mediadb_genre VALUES (9,'Adventure',3);
INSERT INTO phpgw_mediadb_genre VALUES (10,'Comic',3);
INSERT INTO phpgw_mediadb_genre VALUES (11,'Fantasy',3);
INSERT INTO phpgw_mediadb_genre VALUES (12,'Mystery',3);
INSERT INTO phpgw_mediadb_genre VALUES (13,'Romance',3);
INSERT INTO phpgw_mediadb_genre VALUES (14,'War',3);
INSERT INTO phpgw_mediadb_genre VALUES (15,'Cult',3);
# game
INSERT INTO phpgw_mediadb_genre VALUES (16,'Science Fiction',4);
INSERT INTO phpgw_mediadb_genre VALUES (17,'Drama',4);
INSERT INTO phpgw_mediadb_genre VALUES (18,'Horror',4);
INSERT INTO phpgw_mediadb_genre VALUES (19,'Action',4);
INSERT INTO phpgw_mediadb_genre VALUES (20,'Comedy',4);
INSERT INTO phpgw_mediadb_genre VALUES (21,'Non Fiction',4);
INSERT INTO phpgw_mediadb_genre VALUES (22,'Western',4);
INSERT INTO phpgw_mediadb_genre VALUES (23,'Thriller',4);
INSERT INTO phpgw_mediadb_genre VALUES (24,'Adventure',4);
INSERT INTO phpgw_mediadb_genre VALUES (25,'Fantasy',4);
INSERT INTO phpgw_mediadb_genre VALUES (26,'Mystery',4);
INSERT INTO phpgw_mediadb_genre VALUES (27,'Romance',4);
INSERT INTO phpgw_mediadb_genre VALUES (28,'War',4);
INSERT INTO phpgw_mediadb_genre VALUES (29,'Cult',4);
# movie
INSERT INTO phpgw_mediadb_genre VALUES (30,'Science Fiction',5);
INSERT INTO phpgw_mediadb_genre VALUES (31,'Drama',5);
INSERT INTO phpgw_mediadb_genre VALUES (32,'Horror',5);
INSERT INTO phpgw_mediadb_genre VALUES (33,'Action',5);
INSERT INTO phpgw_mediadb_genre VALUES (34,'Comedy',5);
INSERT INTO phpgw_mediadb_genre VALUES (35,'Non Fiction',5);
INSERT INTO phpgw_mediadb_genre VALUES (36,'Western',5);
INSERT INTO phpgw_mediadb_genre VALUES (37,'Film Noir',5);
INSERT INTO phpgw_mediadb_genre VALUES (38,'Musical',5);
INSERT INTO phpgw_mediadb_genre VALUES (39,'Thriller',5);
INSERT INTO phpgw_mediadb_genre VALUES (40,'Adventure',5);
INSERT INTO phpgw_mediadb_genre VALUES (41,'Animation',5);
INSERT INTO phpgw_mediadb_genre VALUES (42,'Anime',5);
INSERT INTO phpgw_mediadb_genre VALUES (43,'Fantasy',5);
INSERT INTO phpgw_mediadb_genre VALUES (44,'Mystery',5);
INSERT INTO phpgw_mediadb_genre VALUES (45,'Romance',5);
INSERT INTO phpgw_mediadb_genre VALUES (46,'War',5);
INSERT INTO phpgw_mediadb_genre VALUES (47,'Cult',5);
INSERT INTO phpgw_mediadb_genre VALUES (48,'Music Video',5);
# music
INSERT INTO phpgw_mediadb_genre VALUES (49,'Acapella',6);
INSERT INTO phpgw_mediadb_genre VALUES (50,'Acid',6);
INSERT INTO phpgw_mediadb_genre VALUES (51,'Acoustic',6);
INSERT INTO phpgw_mediadb_genre VALUES (52,'Alternative',6);
INSERT INTO phpgw_mediadb_genre VALUES (53,'Ambient',6);
INSERT INTO phpgw_mediadb_genre VALUES (54,'Anime',6);
INSERT INTO phpgw_mediadb_genre VALUES (55,'Avantgarde',6);
INSERT INTO phpgw_mediadb_genre VALUES (56,'Ballad',6);
INSERT INTO phpgw_mediadb_genre VALUES (57,'Bass',6);
INSERT INTO phpgw_mediadb_genre VALUES (58,'Beat',6);
INSERT INTO phpgw_mediadb_genre VALUES (59,'Bebob',6);
INSERT INTO phpgw_mediadb_genre VALUES (60,'Big Band',6);
INSERT INTO phpgw_mediadb_genre VALUES (61,'Black',6);
INSERT INTO phpgw_mediadb_genre VALUES (62,'Bluegrass',6);
INSERT INTO phpgw_mediadb_genre VALUES (63,'Blues',6);
INSERT INTO phpgw_mediadb_genre VALUES (64,'Booty',6);
INSERT INTO phpgw_mediadb_genre VALUES (65,'BritPop',6);
INSERT INTO phpgw_mediadb_genre VALUES (66,'Cabaret',6);
INSERT INTO phpgw_mediadb_genre VALUES (67,'Celtic',6);
INSERT INTO phpgw_mediadb_genre VALUES (68,'Chamber Music',6);
INSERT INTO phpgw_mediadb_genre VALUES (69,'Chanson',6);
INSERT INTO phpgw_mediadb_genre VALUES (70,'Chorus',6);
INSERT INTO phpgw_mediadb_genre VALUES (71,'Christian',6);
INSERT INTO phpgw_mediadb_genre VALUES (72,'Classic',6);
INSERT INTO phpgw_mediadb_genre VALUES (73,'Classical',6);
INSERT INTO phpgw_mediadb_genre VALUES (74,'Club',6);
INSERT INTO phpgw_mediadb_genre VALUES (75,'Comedy',6);
INSERT INTO phpgw_mediadb_genre VALUES (76,'Contemporary',6);
INSERT INTO phpgw_mediadb_genre VALUES (77,'Country',6);
INSERT INTO phpgw_mediadb_genre VALUES (78,'Crossover',6);
INSERT INTO phpgw_mediadb_genre VALUES (79,'Cult',6);
INSERT INTO phpgw_mediadb_genre VALUES (80,'Dance',6);
INSERT INTO phpgw_mediadb_genre VALUES (81,'Dance Hall',6);
INSERT INTO phpgw_mediadb_genre VALUES (82,'Darkwave',6);
INSERT INTO phpgw_mediadb_genre VALUES (83,'Death',6);
INSERT INTO phpgw_mediadb_genre VALUES (84,'Disco',6);
INSERT INTO phpgw_mediadb_genre VALUES (85,'Dream',6);
INSERT INTO phpgw_mediadb_genre VALUES (86,'Drum',6);
INSERT INTO phpgw_mediadb_genre VALUES (87,'Duet',6);
INSERT INTO phpgw_mediadb_genre VALUES (88,'Easy Listening',6);
INSERT INTO phpgw_mediadb_genre VALUES (89,'Electronic',6);
INSERT INTO phpgw_mediadb_genre VALUES (90,'Ethnic',6);
INSERT INTO phpgw_mediadb_genre VALUES (91,'Euro',6);
INSERT INTO phpgw_mediadb_genre VALUES (92,'Fast Fusion',6);
INSERT INTO phpgw_mediadb_genre VALUES (93,'Folk',6);
INSERT INTO phpgw_mediadb_genre VALUES (94,'Folklore',6);
INSERT INTO phpgw_mediadb_genre VALUES (95,'Freestyle',6);
INSERT INTO phpgw_mediadb_genre VALUES (96,'Funk',6);
INSERT INTO phpgw_mediadb_genre VALUES (97,'Fusion',6);
INSERT INTO phpgw_mediadb_genre VALUES (98,'Game',6);
INSERT INTO phpgw_mediadb_genre VALUES (99,'Gangsta',6);
INSERT INTO phpgw_mediadb_genre VALUES (100,'Gospel',6);
INSERT INTO phpgw_mediadb_genre VALUES (101,'Gothic',6);
INSERT INTO phpgw_mediadb_genre VALUES (102,'Grunge',6);
INSERT INTO phpgw_mediadb_genre VALUES (103,'Guitar',6);
INSERT INTO phpgw_mediadb_genre VALUES (104,'Hard',6);
INSERT INTO phpgw_mediadb_genre VALUES (105,'Hardcore',6);
INSERT INTO phpgw_mediadb_genre VALUES (106,'Heavy',6);
INSERT INTO phpgw_mediadb_genre VALUES (107,'Hip Hop',6);
INSERT INTO phpgw_mediadb_genre VALUES (108,'House',6);
INSERT INTO phpgw_mediadb_genre VALUES (109,'Humour',6);
INSERT INTO phpgw_mediadb_genre VALUES (110,'Hymn',6);
INSERT INTO phpgw_mediadb_genre VALUES (111,'Indie',6);
INSERT INTO phpgw_mediadb_genre VALUES (112,'Industrial',6);
INSERT INTO phpgw_mediadb_genre VALUES (113,'Inspirational',6);
INSERT INTO phpgw_mediadb_genre VALUES (114,'Instrumental',6);
INSERT INTO phpgw_mediadb_genre VALUES (115,'JPop',6);
INSERT INTO phpgw_mediadb_genre VALUES (116,'Jam',6);
INSERT INTO phpgw_mediadb_genre VALUES (117,'Jazz',6);
INSERT INTO phpgw_mediadb_genre VALUES (118,'Jungle',6);
INSERT INTO phpgw_mediadb_genre VALUES (119,'Latin',6);
INSERT INTO phpgw_mediadb_genre VALUES (120,'Lo-Fi',6);
INSERT INTO phpgw_mediadb_genre VALUES (121,'Meditative',6);
INSERT INTO phpgw_mediadb_genre VALUES (122,'Merengue',6);
INSERT INTO phpgw_mediadb_genre VALUES (123,'Metal',6);
INSERT INTO phpgw_mediadb_genre VALUES (124,'Musical',6);
INSERT INTO phpgw_mediadb_genre VALUES (125,'National',6);
INSERT INTO phpgw_mediadb_genre VALUES (126,'Native US',6);
INSERT INTO phpgw_mediadb_genre VALUES (127,'Negerpunk',6);
INSERT INTO phpgw_mediadb_genre VALUES (128,'New Age',6);
INSERT INTO phpgw_mediadb_genre VALUES (129,'New Wave',6);
INSERT INTO phpgw_mediadb_genre VALUES (130,'Noise',6);
INSERT INTO phpgw_mediadb_genre VALUES (131,'Oldies',6);
INSERT INTO phpgw_mediadb_genre VALUES (132,'Opera',6);
INSERT INTO phpgw_mediadb_genre VALUES (133,'Other',6);
INSERT INTO phpgw_mediadb_genre VALUES (134,'Polka',6);
INSERT INTO phpgw_mediadb_genre VALUES (135,'Pop',6);
INSERT INTO phpgw_mediadb_genre VALUES (136,'Power',6);
INSERT INTO phpgw_mediadb_genre VALUES (137,'Pranks',6);
INSERT INTO phpgw_mediadb_genre VALUES (138,'Primus',6);
INSERT INTO phpgw_mediadb_genre VALUES (139,'Progressive',6);
INSERT INTO phpgw_mediadb_genre VALUES (140,'Psychadelic',6);
INSERT INTO phpgw_mediadb_genre VALUES (141,'Punk',6);
INSERT INTO phpgw_mediadb_genre VALUES (142,'Rap',6);
INSERT INTO phpgw_mediadb_genre VALUES (143,'Rave',6);
INSERT INTO phpgw_mediadb_genre VALUES (144,'Reggae',6);
INSERT INTO phpgw_mediadb_genre VALUES (145,'Retro',6);
INSERT INTO phpgw_mediadb_genre VALUES (146,'Revival',6);
INSERT INTO phpgw_mediadb_genre VALUES (147,'Rhythmic',6);
INSERT INTO phpgw_mediadb_genre VALUES (148,'Rock',6);
INSERT INTO phpgw_mediadb_genre VALUES (149,'Rock & Roll',6);
INSERT INTO phpgw_mediadb_genre VALUES (150,'Salsa',6);
INSERT INTO phpgw_mediadb_genre VALUES (151,'Samba',6);
INSERT INTO phpgw_mediadb_genre VALUES (152,'Satire',6);
INSERT INTO phpgw_mediadb_genre VALUES (153,'Showtunes',6);
INSERT INTO phpgw_mediadb_genre VALUES (154,'Slow',6);
INSERT INTO phpgw_mediadb_genre VALUES (155,'Solo',6);
INSERT INTO phpgw_mediadb_genre VALUES (156,'Sonata',6);
INSERT INTO phpgw_mediadb_genre VALUES (157,'Soul',6);
INSERT INTO phpgw_mediadb_genre VALUES (158,'Sound Clip',6);
INSERT INTO phpgw_mediadb_genre VALUES (159,'Soundtrack',6);
INSERT INTO phpgw_mediadb_genre VALUES (160,'Southern',6);
INSERT INTO phpgw_mediadb_genre VALUES (161,'Space',6);
INSERT INTO phpgw_mediadb_genre VALUES (162,'Speech',6);
INSERT INTO phpgw_mediadb_genre VALUES (163,'Swing',6);
INSERT INTO phpgw_mediadb_genre VALUES (164,'Symphonic',6);
INSERT INTO phpgw_mediadb_genre VALUES (165,'Symphony',6);
INSERT INTO phpgw_mediadb_genre VALUES (166,'Synth',6);
INSERT INTO phpgw_mediadb_genre VALUES (167,'Tango',6);
INSERT INTO phpgw_mediadb_genre VALUES (168,'Techno',6);
INSERT INTO phpgw_mediadb_genre VALUES (169,'Terror',6);
INSERT INTO phpgw_mediadb_genre VALUES (170,'Top 40',6);
INSERT INTO phpgw_mediadb_genre VALUES (171,'Trailer',6);
INSERT INTO phpgw_mediadb_genre VALUES (172,'Trance',6);
INSERT INTO phpgw_mediadb_genre VALUES (173,'Trash',6);
INSERT INTO phpgw_mediadb_genre VALUES (174,'Tribal',6);
INSERT INTO phpgw_mediadb_genre VALUES (175,'Trip-Hop',6);
INSERT INTO phpgw_mediadb_genre VALUES (176,'Vocal',6);
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_region'
#
CREATE TABLE phpgw_mediadb_region (
region_id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
region_code smallint(5) unsigned DEFAULT '0' NOT NULL,
region_desc varchar(25) DEFAULT '' NOT NULL,
PRIMARY KEY (region_id),
KEY region_code (region_code)
);
#
# Dumping data for table 'phpgw_mediadb_region'
#
LOCK TABLES phpgw_mediadb_region WRITE;
INSERT INTO phpgw_mediadb_region VALUES (1,1,'USA');
INSERT INTO phpgw_mediadb_region VALUES (2,1,'Canada');
INSERT INTO phpgw_mediadb_region VALUES (3,2,'Europe');
INSERT INTO phpgw_mediadb_region VALUES (4,2,'Japan');
INSERT INTO phpgw_mediadb_region VALUES (5,3,'Orient');
INSERT INTO phpgw_mediadb_region VALUES (6,4,'Australia');
INSERT INTO phpgw_mediadb_region VALUES (7,4,'New Zealand');
INSERT INTO phpgw_mediadb_region VALUES (8,5,'Asia');
INSERT INTO phpgw_mediadb_region VALUES (9,5,'Africa');
INSERT INTO phpgw_mediadb_region VALUES (10,6,'China');
UNLOCK TABLES;
#
# Table structure for table 'phpgw_mediadb_artist'
#
# - author, artist, actor, programmer
CREATE TABLE phpgw_mediadb_artist (
artist_id smallint(5) unsigned NOT NULL auto_increment,
artist_fname varchar(50),
artist_lname varchar(50),
PRIMARY KEY (artist_id)
);
#
# Table structure for table 'phpgw_mediadb_publisher'
#
# - distributor, publisher
CREATE TABLE phpgw_mediadb_publisher (
publisher_id smallint(5) unsigned NOT NULL auto_increment,
publisher_name varchar(50),
PRIMARY KEY (publisher_id)
);
--- NEW FILE ---
DROP TABLE IF EXISTS phpgw_mediadb;
DROP TABLE IF EXISTS phpgw_mediadb_request;
DROP TABLE IF EXISTS phpgw_mediadb_loan;
DROP TABLE IF EXISTS phpgw_mediadb_data;
DROP TABLE IF EXISTS phpgw_mediadb_cat;
DROP TABLE IF EXISTS phpgw_mediadb_feature;
DROP TABLE IF EXISTS phpgw_mediadb_rating;
DROP TABLE IF EXISTS phpgw_mediadb_format;
DROP TABLE IF EXISTS phpgw_mediadb_genre;
DROP TABLE IF EXISTS phpgw_mediadb_region;
DROP TABLE IF EXISTS phpgw_mediadb_artist;
DROP TABLE IF EXISTS phpgw_mediadb_publisher;
--- NEW FILE ---
LOCK TABLES lang WRITE;
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('media
database','mediadb','en','Media Database');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('archives','mediadb','en','Archives');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('books','mediadb','en','Books');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('games','mediadb','en','Games');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('movies','mediadb','en','Movies');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('music','mediadb','en','Music');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('list','mediadb','en','List');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('stats','mediadb','en','Stats');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('title','mediadb','en','Title');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('author','mediadb','en','Author');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('artist','mediadb','en','Artist');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('developer','mediadb','en','Developer');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('actor','mediadb','en','Actor');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('media','mediadb','en','Media');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('year','mediadb','en','Year');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('genre','mediadb','en','Genre');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('rated','mediadb','en','Rated');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('scoring','mediadb','en','Scoring');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('owner','mediadb','en','Owner');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('avail','mediadb','en','Avail');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('imdb','mediadb','en','IMDB');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('y','mediadb','en','Y');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('n','mediadb','en','N');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('new','mediadb','en','New');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('all','mediadb','en','All');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('own','mediadb','en','Own');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('others','mediadb','en','Others');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('borrowed','mediadb','en','Borrowed');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('loaned','mediadb','en','Loaned');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('requests','mediadb','en','Requests');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES('due
date','mediadb','en','Due Date');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('comment','mediadb','en','Comment');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('id','mediadb','en','Id');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('borrower','mediadb','en','Borrower');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('pend','mediadb','en','Pend');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('honor','mediadb','en','Honor');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('deny','mediadb','en','Deny');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('status','mediadb','en','Status');
REPLACE INTO lang (message_id, app_name, lang, content)
VALUES('withdraw','mediadb','en','Withdraw');
UNLOCK TABLES;
--- NEW FILE ---
DROP TABLE IF EXISTS lang;
CREATE TABLE lang (
message_id varchar(150) DEFAULT '' NOT NULL,
app_name varchar(100) DEFAULT 'common' NOT NULL,
lang varchar(5) DEFAULT '' NOT NULL,
content text NOT NULL,
PRIMARY KEY (message_id,app_name,lang)
);
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'low','common','en','Low');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'forum','common','en','Forum');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'normal','common','en','Normal');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'medium','common','en','Medium');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'high','common','en','High');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'add','common','en','Add');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'create','common','en','Create');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'edit','common','en','Edit');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'copy','common','en','Copy');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'rename','common','en','Rename');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'delete','common','en','Delete');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'done','common','en','Done');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'change','common','en','Change');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'clear
form','common','en','Clear Form');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'total','common','en','Total');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'view','common','en','View');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'save','common','en','Save');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'submit','common','en','Submit');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'search','common','en','Search');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'cancel','common','en','Cancel');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'exit','common','en','Exit');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'yes','common','en','Yes');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'no','common','en','No');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'ok','common','en','OK');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'clear','common','en','Clear');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'january','common','en','January');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'february','common','en','February');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'march','common','en','March');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'april','common','en','April');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'may','common','en','May');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'june','common','en','June');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'july','common','en','July');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'august','common','en','August');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'september','common','en','September');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'october','common','en','October');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'november','common','en','November');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'december','common','en','December');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'monday','common','en','Monday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'tuesday','common','en','Tuesday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'wednesday','common','en','Wednesday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'thursday','common','en','Thursday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'friday','common','en','Friday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'saturday','common','en','Saturday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'sunday','common','en','Sunday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'access','common','en','Access');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'private','common','en','Private');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'access
type','common','en','Access type');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'group
access','common','en','Group Access');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'global
public','common','en','Global Public');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'group
public','common','en','Group Public');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'which
groups','common','en','which groups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'created
by','common','en','Created By');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'administration','common','en','Administration');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'inventory','common','en','Inventory');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'todo
list','common','en','Todo List');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'calendar','common','en','calendar');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'bookmarks','common','en','Bookmarks');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'addressbook','common','en','Addressbook');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'e-mail','common','en','E-Mail');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'chat','common','en','Chat');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'preferences','common','en','Preferences');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'login','common','en','Login');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'logout','common','en','Logout');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'first
name','common','en','First name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'last
name','common','en','Last name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'admin','common','en','Admin');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'email','common','en','E-Mail');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'headlines','common','en','Headlines');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'nntp','common','en','NNTP');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'groups','common','en','Groups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'book
marks','common','en','Book marks');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'name','common','en','Name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'file
manager','common','en','File manager');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'ftp','common','en','FTP');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'password','common','en','Password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'date','common','en','Date');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'time','common','en','Time');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'priority','common','en','Priority');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'help','common','en','Help');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'error','common','en','Error');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'updated','common','en','Updated');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'home','common','en','Home');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'users','common','en','users');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'news
headlines','common','en','News headlines');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'news
reader','common','en','News Reader');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'human
resources','common','en','Human Resources');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'address
book','common','en','Address Book');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'current
users','common','en','Current users');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'first
page','common','en','first page');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'next
page','common','en','next page');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'last
page','common','en','last page');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'previous
page','common','en','Previous page');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'filter','common','en','Filter');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show
all','common','en','show all');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'only
yours','common','en','only yours');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'print','common','en','Print');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'trouble ticket
system','common','en','Trouble Ticket System');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you are
required to change your password durring your first login','common','en','You
are required to change your password durring your first login');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'powered by
phpgroupware version x','common','en','Powered by <a
href=http://www.phpgroupware.org>phpGroupWare</a> version %1');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'sorry, there
was a problem processing your request.','common','en','Sorry, there was a
problem processing your request.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your message
has been sent','common','en','Your message has been sent');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'new entry
added sucessfully','common','en','New entry added sucessfully');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'entry updated
sucessfully','common','en','Entry updated sucessfully');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'entry has been
deleted sucessfully','common','en','Entry has been deleted sucessfully');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'password has
been updated','common','en','Password has been updated');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'session has
been killed','common','en','Session has been killed');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'account has
been updated','common','en','Account has been updated');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'account has
been created','common','en','Account has been created');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'account has
been deleted','common','en','Account has been deleted');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'error creating
x x directory','common','en','Error creating %1%2 directory');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'error deleting
x x directory','common','en','Error deleting %1%2 directory');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'error renaming
x x directory','common','en','Error renaming %1%2 directory');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'please x by
hand','common','en','Please %1 by hand');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'to correct
this error for the future you will need to properly set the','common','en','To
correct this error for the future you will need to properly set the');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'permissions to
the files/users directory','common','en','permissions to the files/users
directory');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'On *nix
systems please type: x','common','en','On *nix systems please type: %1');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your settings
have been updated','common','en','Your settings have been Updated');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'group has been
added','common','en','Group has been added');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'group has been
deleted','common','en','Group has been deleted');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'group has been
updated','common','en','Group has been updated');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'showing x - x
of x','common','en','showing %1 - %2 of %3');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'showing
x','common','en','showing %1');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your search
returned 1 match','common','en','your search returned 1 match');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your search
returned x matchs','common','en','your search returned %1 matchs');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have 1 new
message!','common','en','You have 1 new message!');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have x new
messages!','common','en','You have %1 new messages!');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'today is x\'s
birthday!','common','en','Today is %1\'s birthday!');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'tommorow is
x\'s birthday.','common','en','Tommorow is %1\'s birthday.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have 1
high priority event on your calendar today.','common','en','You have 1 high
priority event on your calendar today.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have x
high priority events on your calendar today.','common','en','You have %1 high
priority events on your calendar today.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'it has been
more then x days since you changed your password','common','en','It has been
more then %1 days since you changed your password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this entry ?','common','en','Are you sure you want to delete
this entry ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this entry ?','common','en','Are you sure you want to delete
this entry ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'username','login','en','Username');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'password','login','en','Password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'login','login','en','Login');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'use
cookies','login','en','use cookies');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have been
successfully logged out','login','en','You have been successfully logged out');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'sorry, your
login has expired','login','en','Sorry, your login has expired');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'bad login or
password','login','en','Bad login or password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your session
could not be verified.','login','en','Your session could not be verified.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your session
could not be verified.','login','en','Your session could not be verified.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'address
book','addressbook','en','Address Book');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'last
name','addressbook','en','Last Name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'first
name','addressbook','en','First Name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'e-mail','addressbook','en','E-Mail');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'home
phone','addressbook','en','Home Phone');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'fax','addressbook','en','Fax');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'work
phone','addressbook','en','Work Phone');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'pager','addressbook','en','Pager');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'mobile','addressbook','en','Mobile');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'other
number','addressbook','en','Other Number');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'street','addressbook','en','Street');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'birthday','addressbook','en','Birthday');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'city','addressbook','en','City');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'state','addressbook','en','State');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'zip
code','addressbook','en','ZIP Code');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'notes','addressbook','en','Notes');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'company
name','addressbook','en','company name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'company
name','addressbook','en','company name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'last x
logins','admin','en','Last %1 logins');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'loginid','admin','en','LoginID');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'ip','admin','en','IP');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'total
records','admin','en','Total records');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'user
accounts','admin','en','User accounts');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'new group
name','admin','en','New group name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'create
group','admin','en','Create Group');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'kill','admin','en','Kill');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'idle','admin','en','idle');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'login
time','admin','en','Login Time');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'anonymous
user','admin','en','Anonymous user');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'manager','admin','en','Manager');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'account
active','admin','en','Account active');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 're-enter
password','admin','en','Re-enter password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'group
name','admin','en','Group Name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'display','admin','en','Display');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'base
url','admin','en','Base URL');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'news
file','admin','en','News File');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'minutes
between reloads','admin','en','Minutes between Reloads');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'listings
displayed','admin','en','Listings Displayed');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'news
type','admin','en','News Type');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'user
groups','admin','en','User groups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'headline
sites','admin','en','Headline Sites');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'network
news','admin','en','Network News');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'site','admin','en','Site');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'view
sessions','admin','en','View sessions');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'view access
log','admin','en','View Access Log');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'active','admin','en','Active');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'disabled','admin','en','Disabled');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'last time
read','admin','en','Last Time Read');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'permissions','admin','en','Permissions');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'title','admin','en','Title');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'enabled','admin','en','Enabled');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'applications','admin','en','Applications');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'edit
group','admin','en','Edit Group');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'submit
changes','admin','en','Submit Changes');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must add
at least 1 permission to this account','admin','en','You must add at least 1
permission to this account');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'installed
applications','admin','en','Installed applications');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'remove all
users from this group','admin','en','Remove all users from this group');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'permissions
this group has','admin','en','Permissions this group has');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'select
permissions this group will have','admin','en','Select permissions this group
will have');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'sorry, that
group name has already been taking.','admin','en','Sorry, that group name has
already been taking.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'add new
application','admin','en','Add new application');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'application
name','admin','en','Application name');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'application
title','admin','en','Application title');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'edit
application','admin','en','Edit application');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
an application name and title.','admin','en','You must enter an application
name and title.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this application ?','admin','en','Are you sure you want to
delete this application ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this group ?','admin','en','Are you sure you want to delete
this group ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to kill this session ?','admin','en','Are you sure you want to kill
this session ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'all records
and account information will be lost!','admin','en','All records and account
information will be lost!');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this account ?','admin','en','Are you sure you want to
delete this account ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this news site ?','admin','en','Are you sure you want to
delete this news site ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'percent of
users that logged out','admin','en','Percent of users that logged out');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'list of
current users','admin','en','list of current users');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'new password [
leave blank for no change ]','admin','en','New password [ Leave blank for no
change ]');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'the two
passwords are not the same','admin','en','The two passwords are not the same');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'the login and
password can not be the same','admin','en','The login and password can not be
the same');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
a password','admin','en','You must enter a password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'that loginid
has already been taken','admin','en','That loginid has already been taken');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
a display','admin','en','You must enter a display');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
a base url','admin','en','You must enter a base url');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
a news url','admin','en','You must enter a news url');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
the number of minutes between reload','admin','en','You must enter the number
of minutes between reload');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
the number of listings display','admin','en','You must enter the number of
listings display');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must
select a file type','admin','en','You must select a file type');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'that site has
already been entered','admin','en','That site has already been entered');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'select users
for inclusion','admin','en','Select users for inclusion');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'sorry, the
follow users are still a member of the group x','admin','en','Sorry, the follow
users are still a member of the group %1');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'they must be
removed before you can continue','admin','en','They must be removed before you
can continue');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'they must be
removed before you can continue','admin','en','They must be removed before you
can continue');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'today','calendar','en','Today');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'this
week','calendar','en','This week');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'this
month','calendar','en','This month');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'generate
printer-friendly version','calendar','en','Generate printer-friendly version');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'printer
friendly','calendar','en','Printer Friendly');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have not
entered a\\nbrief description','calendar','en','You have not entered a\\nBrief
Description');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have not
entered a\\nvalid time of day.','calendar','en','You have not entered a\\nvalid
time of day.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you
sure\\nyou want to\\ndelete this entry ?','calendar','en','Are you sure\\nyou
want to\\ndelete this entry ?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'participants','calendar','en','Participants');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'calendar -
edit','calendar','en','Calendar - Edit');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'calendar -
add','calendar','en','Calendar - Add');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'brief
description','calendar','en','Brief Description');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'full
description','calendar','en','Full Description');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'duration','calendar','en','Duration');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'minutes','calendar','en','minutes');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'repeat
type','calendar','en','Repeat type');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'none','calendar','en','None');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'daily','calendar','en','Daily');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'weekly','calendar','en','weekly');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'monthly (by
day)','calendar','en','Monthly (by day)');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'monthly (by
date)','calendar','en','Monthly (by date)');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'yearly','calendar','en','Yearly');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'repeat end
date','calendar','en','Repeat End date');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'use end
date','calendar','en','Use End date');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'repeat
day','calendar','en','Repeat day');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( '(for
weekly)','calendar','en','(for Weekly)');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'frequency','calendar','en','Frequency');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'sun','calendar','en','Sun');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'mon','calendar','en','Mon');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'tue','calendar','en','Tue');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'wed','calendar','en','Wed');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'thu','calendar','en','Thu');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'fri','calendar','en','Fri');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'sat','calendar','en','Sat');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'su','calendar','en','Su');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'mo','calendar','en','M');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'tu','calendar','en','T');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'we','calendar','en','W');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'th','calendar','en','T');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'fr','calendar','en','F');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'sa','calendar','en','Sa');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'search
results','calendar','en','Search Results');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'no matches
found.','calendar','en','No matches found.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( '1 match
found','calendar','en','1 match found');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'x matches
found','calendar','en','%1 matches found');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'description','calendar','en','Description');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'repetition','calendar','en','Repetition');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'days
repeated','calendar','en','days repeated');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'go!','calendar','en','Go!');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'year','calendar','en','Year');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'month','calendar','en','Month');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'week','calendar','en','Week');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'new
entry','calendar','en','New Entry');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'view this
entry','calendar','en','View this entry');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'the following
conflicts with the suggested time:<ul>x</ul>','calendar','en','The following
conflicts with the suggested time:<ul>%1</ul>');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your suggested
time of <B> x - x </B> conflicts with the following existing calendar
entries:','calendar','en','Your suggested time of <B> %1 - %2 </B> conflicts
with the following existing calendar entries:');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
one or more search keywords','calendar','en','You must enter one or more search
keywords');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you
sure\\nyou want to\\ndelete this entry ?\\n\\nthis will delete\\nthis entry for
all users.','calendar','en','Are you sure\\nyou want to\\ndelete this entry
?\\n\\nThis will delete\\nthis entry for all users.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'a','calendar','en','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'a','calendar','en','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'a','calendar','en','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'a','calendar','en','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'a','calendar','en','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'a','calendar','en','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'a','calendar','en','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'reply','email','en','Reply');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'reply
all','email','en','Reply All');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'forward','email','en','Forward');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'delete','email','en','Delete');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'previous','email','en','Previous');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'next','email','en','Next');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'from','email','en','From');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'to','email','en','To');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'cc','email','en','CC');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'files','email','en','Files');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'date','email','en','Date');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'send','email','en','Send');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'subject','email','en','Subject');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'folder','email','en','Folder');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'size','email','en','Size');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'section','email','en','Section');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'image','email','en','Image');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'no
subject','email','en','No Subject');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'compose','email','en','Compose');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'message','email','en','Message');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'messages','email','en','Messages');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'new
message','email','en','New message');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'undisclosed
sender','email','en','Undisclosed Sender');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'undisclosed
recipients','email','en','Undisclosed Recipients');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'please select
a message first','email','en','Please select a message first');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'this folder is
empty','email','en','This folder is empty');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'switch current
folder to','email','en','Switch Current Folder To');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'move selected
messages into','email','en','Move Selected Messages into');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'add to
addressbook','email','en','Add to addressbook');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( '1 message has
been deleted','email','en','1 message has been deleted');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'x messages
have been deleted','email','en','%1 messages have been deleted');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'monitor','email','en','Monitor');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'monitor','email','en','Monitor');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'usersfile_perm_error','filemanager','en','To correct this error you will need
to properly set the permissions to the files/users directory.<BR> On *nix
systems please type: chmod 707');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'groupsfile_perm_error','filemanager','en','To correct this error you will need
to properly set the permissions to the files/groups directory.<BR> On *nix
systems please type: chmod 707');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'private_files','filemanager','en','Private files');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'group_files','filemanager','en','group files');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'files','filemanager','en','Files');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'new_file','filemanager','en','New File');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'rename_to','filemanager','en','Rename to');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'file_upload','filemanager','en','File Upload');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'current_file','filemanager','en','Current File');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'clipboard_contents','filemanager','en','Clipboard Contents');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'copy_as','filemanager','en','Copy as');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'create','filemanager','en','Create');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'edit','filemanager','en','Edit');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'copy','filemanager','en','Copy');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'delete','filemanager','en','Delete');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'do_delete','filemanager','en','Delete');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'rename','filemanager','en','Rename');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'rename_to','filemanager','en','Rename');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'download','filemanager','en','Download');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'upload','filemanager','en','Upload');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'save','filemanager','en','Save');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'exit','filemanager','en','Exit');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'cancel','filemanager','en','Cancel');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'specify_file_name','filemanager','en','You must specify a name for the file
you wish to create');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'no_file_name','filemanager','en','No filename was specified');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'err_saving_file','filemanager','en','Error saving file to disk');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'yes','filemanager','en','Yes');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'no','filemanager','en','No');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'no','filemanager','en','No');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'newsgroups','nntp','en','Newsgroups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'update','nntp','en','Update');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show all
groups','nntp','en','Show All Groups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'available
groups','nntp','en','Available Groups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show groups
containing','nntp','en','Show Groups Containing');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'next','nntp','en','Next');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'threads','nntp','en','Threads');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'message
x','nntp','en','Message %1');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'author','nntp','en','Author');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'subject','nntp','en','Subject');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'date','nntp','en','Date');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'monitor','nntp','en','Monitor');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'monitor','nntp','en','Monitor');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'max matchs per
page','preferences','en','Max matches per page');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'time zone
offset','preferences','en','Time zone offset');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'this server is
located in the x timezone','preferences','en',' timezone');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'date
format','preferences','en','Date format');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'time
format','preferences','en','Time format');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'language','preferences','en','Language');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'default
sorting order','preferences','en','Default sorting order');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'default
application','preferences','en','Default application');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show text on
navigation icons','preferences','en','Show text on navigation icons');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show current
users on navigation bar','preferences','en','Show current users on navigation
bar');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show new
messages on main screen','preferences','en','Show new messages on main screen');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'email
signature','preferences','en','E-Mail signature');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show birthday
reminders on main screen','preferences','en','Show birthday reminiders on main
screen');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'show high
priority events on main screen','preferences','en','Show high priority events
on main screen');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'weekday starts
on','preferences','en','Weekday starts on');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'work day
starts on','preferences','en','Work day starts on');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'work day ends
on','preferences','en','Work day ends on');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'select
headline news sites','preferences','en','Select Headline News sites');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'change your
password','preferences','en','Change your Password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'select
different theme','preferences','en','Select different Theme');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'change your
settings','preferences','en','Change your Settings');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'change your
profile','preferences','en','Change your profile');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'enter your new
password','preferences','en','Enter your new password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 're-enter your
password','preferences','en','Re-Enter your password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'the two
passwords are not the same','preferences','en','The two passwords are not the
same');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you must enter
a password','preferences','en','You must enter a password');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'your current
theme is: x','preferences','en','</b>');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'please, select
a new theme','preferences','en','Please, select a new theme');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'note: this
feature does *not* change your email password. this will need to be done
manually.','preferences','en','Note: This feature does *not* change your email
password. This will need to be done manually.');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'monitor
newsgroups','preferences','en','Monitor Newsgroups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'monitor
newsgroups','preferences','en','Monitor Newsgroups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'todo list -
add','todo','en','todo list - add');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'todo list -
edit','todo','en','Todo list - edit');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'todo
list','todo','en','Todo list');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'todo','todo','en','todo');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'status','todo','en','Status');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'urgency','todo','en','Urgency');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES(
'completed','todo','en','completed');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'last
updated','todo','en','Last Updated');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'access
type','todo','en','Access type');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'which
groups','todo','en','Which groups');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'clear
form','todo','en','Clear form');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'date
due','todo','en','Date Due');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'created
by','todo','en','Created By');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'you have
entered an invailed date','todo','en','you have entered an invailed date');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this entry','todo','en','Are you sure you want to delete
this entry?');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'are you sure
you want to delete this entry','todo','en','Are you sure you want to delete
this entry?');
--- NEW FILE ---
#
# Table structure for table 'phpgw_mediadb_lookup'
#
DROP TABLE IF EXISTS phpgw_mediadb_lookup;
CREATE TABLE phpgw_mediadb_lookup (
lookup_id int(11) DEFAULT '0' NOT NULL auto_increment,
lookup_url varchar(255),
lookup_block varchar(255),
lookup_component varchar(255),
lookup_field varchar(25),
cat_id smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (lookup_id)
);
# "[a-zA-Z0-9:/ \.]*" ALT="cover" (media image)
--- NEW FILE ---
insert into applications (app_name, app_title, app_enabled) values ('mediadb',
'Multimedia Database', 1);
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: mediadb/doc/examples/sql all_in_one.mysql,NONE,1.1 cat.sql,NONE,1.1 create_tables.mysql,NONE,1.1 destroy_tables.mysql,NONE,1.1 lang.sql,NONE,1.1 main_lang.sql,NONE,1.1 media_lookup.sql,NONE,1.1 register_app.mysql,NONE,1.1,
Luca - De Whiskey's - De Vitis <address@hidden> <=