-- MySQL dump 10.11 -- -- Host: localhost Database: sourceforge_20100222_sample -- ------------------------------------------------------ -- Server version 5.0.38-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `DatabaseEnvironment` -- DROP TABLE IF EXISTS `DatabaseEnvironment`; CREATE TABLE `DatabaseEnvironment` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `DatabaseEnvironment` -- LOCK TABLES `DatabaseEnvironment` WRITE; /*!40000 ALTER TABLE `DatabaseEnvironment` DISABLE KEYS */; INSERT INTO `DatabaseEnvironment` VALUES ('emuleplus','Berkeley/Sleepycat/Gdbm (DBM)'),('shareaza','Flat-file'); /*!40000 ALTER TABLE `DatabaseEnvironment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `DevelopmentStatus` -- DROP TABLE IF EXISTS `DevelopmentStatus`; CREATE TABLE `DevelopmentStatus` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `DevelopmentStatus` -- LOCK TABLES `DevelopmentStatus` WRITE; /*!40000 ALTER TABLE `DevelopmentStatus` DISABLE KEYS */; INSERT INTO `DevelopmentStatus` VALUES ('amsn','5 - Production/Stable'),('aresgalaxy','4 - Beta'),('audacity','5 - Production/Stable'),('azureus','5 - Production/Stable'),('bittorrent','5 - Production/Stable'),('cdexos','6 - Mature'),('cdexos','1 - Planning'),('cdexos','5 - Production/Stable'),('corefonts','4 - Beta'),('dcplusplus','4 - Beta'),('emule','5 - Production/Stable'),('emuleplus','5 - Production/Stable'),('filezilla','5 - Production/Stable'),('gimp-win','5 - Production/Stable'),('guliverkli','4 - Beta'),('pdfcreator','5 - Production/Stable'),('pidgin','5 - Production/Stable'),('portableapps','5 - Production/Stable'),('portableapps','6 - Mature'),('sevenzip','5 - Production/Stable'),('shareaza','5 - Production/Stable'),('virtualdub','5 - Production/Stable'),('virtualdub','4 - Beta'),('winscp','5 - Production/Stable'); /*!40000 ALTER TABLE `DevelopmentStatus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `IntendedAudience` -- DROP TABLE IF EXISTS `IntendedAudience`; CREATE TABLE `IntendedAudience` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `IntendedAudience` -- LOCK TABLES `IntendedAudience` WRITE; /*!40000 ALTER TABLE `IntendedAudience` DISABLE KEYS */; INSERT INTO `IntendedAudience` VALUES ('amsn','End Users/Desktop'),('amsn','Developers'),('aresgalaxy','End Users/Desktop'),('audacity','End Users/Desktop'),('azureus','System Administrators'),('azureus','Science/Research'),('azureus','End Users/Desktop'),('azureus','Information Technology'),('azureus','Developers'),('azureus','Education'),('bittorrent','System Administrators'),('bittorrent','End Users/Desktop'),('cdexos','Developers'),('cdexos','End Users/Desktop'),('corefonts','End Users/Desktop'),('corefonts','System Administrators'),('dcplusplus','End Users/Desktop'),('emule','End Users/Desktop'),('emuleplus','End Users/Desktop'),('filezilla','Developers'),('filezilla','End Users/Desktop'),('gimp-win','End Users/Desktop'),('guliverkli','End Users/Desktop'),('pdfcreator','End Users/Desktop'),('pdfcreator','System Administrators'),('pidgin','End Users/Desktop'),('pidgin','Advanced End Users'),('pidgin','Developers'),('portableapps','End Users/Desktop'),('portableapps','Developers'),('portableapps','Advanced End Users'),('portableapps','System Administrators'),('portableapps','Education'),('portableapps','Information Technology'),('sevenzip','System Administrators'),('sevenzip','End Users/Desktop'),('sevenzip','Developers'),('shareaza','End Users/Desktop'),('shareaza','Advanced End Users'),('virtualdub','Developers'),('virtualdub','End Users/Desktop'),('virtualdub','Advanced End Users'),('winscp','End Users/Desktop'),('winscp','Developers'),('winscp','System Administrators'); /*!40000 ALTER TABLE `IntendedAudience` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `License` -- DROP TABLE IF EXISTS `License`; CREATE TABLE `License` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `License` -- LOCK TABLES `License` WRITE; /*!40000 ALTER TABLE `License` DISABLE KEYS */; INSERT INTO `License` VALUES ('amsn','GNU General Public License (GPL)'),('aresgalaxy','GNU General Public License (GPL)'),('audacity','GNU General Public License (GPL)'),('azureus','GNU General Public License (GPL)'),('bittorrent','Other License'),('cdexos','GNU General Public License (GPL)'),('corefonts','GNU General Public License (GPL)'),('dcplusplus','GNU General Public License (GPL)'),('emule','GNU General Public License (GPL)'),('emuleplus','GNU General Public License (GPL)'),('filezilla','GNU General Public License (GPL)'),('gimp-win','zlib/libpng License'),('gimp-win','GNU General Public License (GPL)'),('gimp-win','GNU Library or Lesser General Public License (LGPL)'),('guliverkli','GNU General Public License (GPL)'),('pdfcreator','GNU General Public License (GPL)'),('pidgin','GNU General Public License (GPL)'),('portableapps','GNU General Public License (GPL)'),('portableapps','GNU Library or Lesser General Public License (LGPL)'),('portableapps','Mozilla Public License 1.1 (MPL 1.1)'),('portableapps','wxWindows Library Licence'),('portableapps','MIT License'),('sevenzip','GNU Library or Lesser General Public License (LGPL)'),('shareaza','GNU General Public License (GPL)'),('virtualdub','GNU General Public License (GPL)'),('winscp','GNU General Public License (GPL)'); /*!40000 ALTER TABLE `License` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `OperatingSystem` -- DROP TABLE IF EXISTS `OperatingSystem`; CREATE TABLE `OperatingSystem` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `OperatingSystem` -- LOCK TABLES `OperatingSystem` WRITE; /*!40000 ALTER TABLE `OperatingSystem` DISABLE KEYS */; INSERT INTO `OperatingSystem` VALUES ('amsn','Other'),('amsn','Linux'),('amsn','OS X'),('amsn','All 32-bit MS Windows (95/98/NT/2000/XP)'),('amsn','All POSIX (Linux/BSD/UNIX-like OSes)'),('amsn','OS Portable (Source code to work with many OS platforms)'),('aresgalaxy','32-bit MS Windows (NT/2000/XP)'),('audacity','Apple Mac OS Classic'),('audacity','OS X'),('audacity','Linux'),('audacity','All 32-bit MS Windows (95/98/NT/2000/XP)'),('audacity','All POSIX (Linux/BSD/UNIX-like OSes)'),('azureus','OS X'),('azureus','All POSIX (Linux/BSD/UNIX-like OSes)'),('azureus','All 32-bit MS Windows (95/98/NT/2000/XP)'),('azureus','Linux'),('bittorrent','All POSIX (Linux/BSD/UNIX-like OSes)'),('bittorrent','All 32-bit MS Windows (95/98/NT/2000/XP)'),('cdexos','All 32-bit MS Windows (95/98/NT/2000/XP)'),('corefonts','All POSIX (Linux/BSD/UNIX-like OSes)'),('dcplusplus','WINE'),('dcplusplus','32-bit MS Windows (NT/2000/XP)'),('emule','32-bit MS Windows (NT/2000/XP)'),('emule','32-bit MS Windows (95/98)'),('emule','All 32-bit MS Windows (95/98/NT/2000/XP)'),('emule','WinXP'),('emule','Win2K'),('emule','Vista'),('emuleplus','All 32-bit MS Windows (95/98/NT/2000/XP)'),('emuleplus','Vista'),('emuleplus','Microsoft Windows Server 2003'),('emuleplus','WINE'),('filezilla','32-bit MS Windows (NT/2000/XP)'),('filezilla','WinXP'),('filezilla','Vista'),('filezilla','Microsoft Windows Server 2003'),('filezilla','Linux'),('filezilla','FreeBSD'),('filezilla','OS X'),('gimp-win','32-bit MS Windows (95/98)'),('gimp-win','32-bit MS Windows (NT/2000/XP)'),('gimp-win','All 32-bit MS Windows (95/98/NT/2000/XP)'),('gimp-win','WinXP'),('gimp-win','Win2K'),('guliverkli','32-bit MS Windows (95/98)'),('guliverkli','32-bit MS Windows (NT/2000/XP)'),('guliverkli','All 32-bit MS Windows (95/98/NT/2000/XP)'),('guliverkli','WinXP'),('guliverkli','Win2K'),('pdfcreator','All 32-bit MS Windows (95/98/NT/2000/XP)'),('pdfcreator','Windows 7'),('pdfcreator','Microsoft Windows Server 2003'),('pidgin','Linux'),('pidgin','All BSD Platforms (FreeBSD/NetBSD/OpenBSD/Apple Mac OS X)'),('pidgin','Other'),('pidgin','All 32-bit MS Windows (95/98/NT/2000/XP)'),('pidgin','All POSIX (Linux/BSD/UNIX-like OSes)'),('pidgin','OS Portable (Source code to work with many OS platforms)'),('portableapps','All 32-bit MS Windows (95/98/NT/2000/XP)'),('portableapps','WINE'),('portableapps','Vista'),('portableapps','WinXP'),('portableapps','Win2K'),('sevenzip','32-bit MS Windows (95/98)'),('sevenzip','32-bit MS Windows (NT/2000/XP)'),('sevenzip','All 32-bit MS Windows (95/98/NT/2000/XP)'),('sevenzip','WinXP'),('sevenzip','Win2K'),('shareaza','Vista'),('shareaza','Microsoft Windows Server 2003'),('shareaza','32-bit MS Windows (NT/2000/XP)'),('shareaza','WinXP'),('shareaza','64-bit MS Windows'),('shareaza','Win2K'),('virtualdub','32-bit MS Windows (95/98)'),('virtualdub','All 32-bit MS Windows (95/98/NT/2000/XP)'),('virtualdub','64-bit MS Windows'),('winscp','32-bit MS Windows (95/98)'),('winscp','32-bit MS Windows (NT/2000/XP)'),('winscp','All 32-bit MS Windows (95/98/NT/2000/XP)'),('winscp','WinXP'),('winscp','Win2K'),('winscp','WINE'),('winscp','Vista'),('winscp','Microsoft Windows Server 2003'),('winscp','Win95'),('winscp','Win98 OSR2'),('winscp','WinME'),('winscp','WinNT'),('winscp','Windows 7'); /*!40000 ALTER TABLE `OperatingSystem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ProgrammingLanguage` -- DROP TABLE IF EXISTS `ProgrammingLanguage`; CREATE TABLE `ProgrammingLanguage` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ProgrammingLanguage` -- LOCK TABLES `ProgrammingLanguage` WRITE; /*!40000 ALTER TABLE `ProgrammingLanguage` DISABLE KEYS */; INSERT INTO `ProgrammingLanguage` VALUES ('amsn','Tcl'),('amsn','C'),('amsn','C++'),('aresgalaxy','Delphi/Kylix'),('audacity','C++'),('azureus','Java'),('bittorrent','Python'),('bittorrent','C'),('cdexos','C++'),('cdexos','C'),('cdexos','Python'),('cdexos','Unix Shell'),('dcplusplus','C++'),('emule','C++'),('emuleplus','C++'),('filezilla','C++'),('guliverkli','C++'),('pdfcreator','Visual Basic'),('pidgin','C'),('pidgin','C#'),('pidgin','Perl'),('pidgin','Tcl'),('pidgin','Python'),('portableapps','Delphi/Kylix'),('portableapps','C++'),('sevenzip','C++'),('shareaza','C++'),('shareaza','Assembly'),('shareaza','IDL'),('virtualdub','Assembly'),('virtualdub','C++'),('winscp','C++'); /*!40000 ALTER TABLE `ProgrammingLanguage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Project` -- DROP TABLE IF EXISTS `Project`; CREATE TABLE `Project` ( `project` varchar(255) default NULL, `title` varchar(255) default NULL, `image` varchar(255) default NULL, `activity` decimal(19,2) default NULL, `rank` int(11) default NULL, `registered` date default NULL, `latestFile` date default NULL, `downloads` int(11) default NULL, `description` varchar(255) default NULL, `runsInWin` int(11) default NULL, `runsInMac` int(11) default NULL, `runsInUnix` int(11) default NULL, `runsInPda` int(11) default NULL, `gui` int(11) default NULL, `terminal` int(11) default NULL, `nonInteractive` int(11) default NULL, KEY `project` (`project`), KEY `title` (`title`), KEY `image` (`image`), KEY `activity` (`activity`), KEY `rank` (`rank`), KEY `registered` (`registered`), KEY `latestFile` (`latestFile`), KEY `downloads` (`downloads`), KEY `description` (`description`), KEY `runsInWin` (`runsInWin`), KEY `runsInMac` (`runsInMac`), KEY `runsInUnix` (`runsInUnix`), KEY `runsInPda` (`runsInPda`), KEY `gui` (`gui`), KEY `terminal` (`terminal`), KEY `nonInteractive` (`nonInteractive`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `Project` -- LOCK TABLES `Project` WRITE; /*!40000 ALTER TABLE `Project` DISABLE KEYS */; INSERT INTO `Project` VALUES ('amsn','aMSN',NULL,'99.88',352,'2002-05-22','2009-04-13',33853360,'A very nice MSN compatible messenger application, aMSN Messenger is a multiplatform MSN messenger clone. Works pretty much like its Windows based counterpart. Perfect for keeping in touch with those friends who have not yet seen the light. Works on linux',1,1,1,0,1,0,0),('aresgalaxy','Ares Galaxy','113772','99.99',38,'2004-06-18','2009-02-03',216541803,'Filesharing-Bittorrent p2p client connected to TCP supernode/leaf network and UDP DHT network. Ares features a built-in directshow media player, a powerful library manager, shoutcast radio support and can be used to host p2p Chatrooms.',1,0,0,0,1,0,0),('audacity','Audacity','73178','99.96',121,'2000-05-28','2009-07-21',66821292,'A fast multi-track audio editor and recorder for Linux, BSD, Mac OS, and Windows. Supports WAV, AIFF, Ogg, and MP3 formats. Features include envelope editing, mixing, built-in effects and plug-ins, all with unlimited undo.',1,1,1,0,1,0,0),('azureus','Azureus / Vuze','236939','100.00',14,'2003-06-24','2009-07-09',486057191,'Vuze (formerly Azureus) is a P2P file sharing client using the bittorrent protocol. Search and download torrent files. Play, convert and transcode videos and music for playing on many devices such as PSP, TiVo, XBox, PS3, iTunes (iPhone, iPod, Apple TV).',1,1,1,0,1,0,0),('bittorrent','BitTorrent',NULL,'91.52',24529,'2001-08-07','2005-11-22',52040882,'BitTorrent is a tool for distributed download. Go to http://www.bittorrent.com/ for the latest version, or http://www.bittorrent.com/dl/?C=M;O=D for source and older versions.',1,0,1,0,1,0,1),('cdexos','CDex','57529','99.60',1158,'1999-12-05','2006-06-26',40424713,'CDex is a CD-Ripper, extracting digital audio data from an Audio CD. The application supports many Audio encoders, like MPEG (MP2,MP3), VQF, AAC encoders.',1,0,0,0,1,0,0),('corefonts','Smart package of Microsoft\'s core fonts',NULL,'99.71',829,'2001-08-22','2006-05-07',51717730,'So far this project consists of a source rpm that can be used to easily create a binary rpm package that, when installed, gives access to Microsoft\'s TrueType core fonts for the Web.',0,0,1,0,1,0,0),('dcplusplus','DC++',NULL,'99.73',787,'2001-11-17','2009-03-07',57102316,'This is a project aimed at producing a file sharing client using the ADC protocol. It also supports connecting to the Direct Connect network.',1,1,1,0,1,0,0),('emule','eMule','34351','99.89',328,'2002-05-13','2009-02-22',519813624,'eMule is a filesharing client which is based on the eDonkey2000 network but offers more features than the standard client',1,0,0,0,1,0,0),('emuleplus','eMule Plus','219143','97.05',8537,'2003-01-19','2009-04-18',29763911,'eMule Plus is an evolution of the original eMule project, created to improve its abilities and features, in both work efficiency and user interface.',1,1,1,0,1,0,0),('filezilla','FileZilla',NULL,'99.94',185,'2001-02-27','2009-07-02',76985457,'FileZilla is a cross-platform graphical FTP, FTPS and SFTP client a lot of features, supporting Windows, Linux, Mac OS X and more. FileZilla Server is a reliable FTP server for Windows.',1,1,1,0,1,0,0),('gimp-win','GTK+ and GIMP installers for Windows','51748','99.91',255,'2004-10-07','2009-05-07',68507096,'GIMP and GTK+ installers for Windows',1,0,0,0,1,0,0),('guliverkli','guliverkli','22759','99.02',2835,'2003-05-29','2007-08-18',30592536,'Home of VobSub, Media Player Classic (MPC) and other misc utils.',1,0,0,0,1,0,0),('pdfcreator','PDFCreator','246123','99.92',221,'2002-07-13','2009-04-08',31610811,'PDFCreator easily creates PDFs from any Windows program.\r\nUse it like a printer in Word, StarCalc or any other Windows application.',1,0,0,0,1,0,0),('pidgin','Pidgin',NULL,'99.97',80,'1999-11-13','2009-06-29',34041633,'Pidgin is a GTK+ instant messaging application for Windows and Unix. It supports AIM, ICQ, Jabber/XMPP, MSN, Yahoo!, Bonjour, Gadu-Gadu, IRC, QQ, SILC, SIMPLE and more. See http://pidgin.im/about for more information.',1,1,1,0,1,0,0),('portableapps','PortableApps.com: Portable Software/USB','235918','99.92',221,'2005-10-21','2009-07-22',62417404,'PortableApps.com allows you to carry your favorite computer programs and all of your bookmarks, settings, email and more with you on a portable device (USB flash drive, iPod, portable hard drive, CD, etc) and use them on any Windows computer.',1,1,1,0,1,0,0),('sevenzip','7-Zip','12650','100.00',13,'2000-11-10','2009-05-30',85107740,'7-Zip is a file archiver with the high compression ratio. The program supports 7z, ZIP, CAB, RAR, ARJ, LZH, CHM, GZIP, BZIP2, Z, TAR, CPIO, ISO, MSI, WIM, NSIS, RPM and DEB formats.',1,0,0,0,1,0,0),('shareaza','Shareaza','232486','99.97',81,'2004-05-28','2008-10-01',51060508,'Shareaza is a multi-network peer-to-peer ( P2P ) file-sharing client supporting Gnutella2, Gnutella, eDonkey2000 ( eMule ), HTTP, FTP and BitTorrent protocols. Using C++, MFC and ATL, for Windows.',1,0,0,0,1,0,0),('virtualdub','VirtualDub',NULL,'99.73',793,'2000-08-12','2009-07-05',49365276,'Desktop video processing and capture application (Win32).',1,0,0,0,1,0,0),('winscp','WinSCP','6425','99.99',22,'2003-07-13','2009-06-28',31787902,'WinSCP is a SFTP client and FTP client for Windows. Its main function is the secure file transfer between a local and a remote computer. It uses Secure Shell (SSH) and supports, in addition to Secure FTP, also legacy SCP protocol.',1,1,1,0,1,0,0); /*!40000 ALTER TABLE `Project` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Topic` -- DROP TABLE IF EXISTS `Topic`; CREATE TABLE `Topic` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `Topic` -- LOCK TABLES `Topic` WRITE; /*!40000 ALTER TABLE `Topic` DISABLE KEYS */; INSERT INTO `Topic` VALUES ('amsn','Networking'),('amsn','Internet'),('amsn','MSN Messenger'),('aresgalaxy','File Sharing'),('aresgalaxy','Chat'),('audacity','Editors'),('audacity','Capture/Recording'),('audacity','Analysis'),('audacity','Mixers'),('azureus','Internet'),('azureus','File Sharing'),('bittorrent','File Sharing'),('bittorrent','File Transfer Protocol (FTP)'),('bittorrent','WWW/HTTP'),('cdexos','CD Ripping'),('cdexos','Conversion'),('corefonts','Desktop Environment'),('dcplusplus','File Sharing'),('dcplusplus','Chat'),('emule','File Sharing'),('emuleplus','File Sharing'),('filezilla','File Transfer Protocol (FTP)'),('filezilla','File Sharing'),('filezilla','Networking'),('gimp-win','Raster-Based'),('guliverkli','Capture'),('guliverkli','Sound/Audio'),('guliverkli','Video'),('pdfcreator','Office Suites'),('pdfcreator','Printing'),('pidgin','AOL Instant Messenger'),('pidgin','MSN Messenger'),('portableapps','File Transfer Protocol (FTP)'),('portableapps','Chat'),('portableapps','Browsers'),('portableapps','Email'),('portableapps','Office Suites'),('portableapps','Calendar'),('sevenzip','Compression'),('sevenzip','Backup'),('sevenzip','Packaging'),('shareaza','File Sharing'),('shareaza','File Transfer Protocol (FTP)'),('shareaza','WWW/HTTP'),('virtualdub','Video Capture'),('virtualdub','Conversion'),('winscp','File Transfer Protocol (FTP)'),('winscp','Cryptography'),('winscp','Communications'); /*!40000 ALTER TABLE `Topic` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `Translation` -- DROP TABLE IF EXISTS `Translation`; CREATE TABLE `Translation` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `Translation` -- LOCK TABLES `Translation` WRITE; /*!40000 ALTER TABLE `Translation` DISABLE KEYS */; INSERT INTO `Translation` VALUES ('aresgalaxy','English'),('aresgalaxy','Dutch'),('aresgalaxy','French'),('aresgalaxy','Italian'),('aresgalaxy','Japanese'),('aresgalaxy','Spanish'),('aresgalaxy','Czech'),('aresgalaxy','German'),('aresgalaxy','Swedish'),('aresgalaxy','Turkish'),('aresgalaxy','Chinese (Simplified)'),('aresgalaxy','Kirghiz'),('aresgalaxy','Arabic'),('aresgalaxy','Danish'),('aresgalaxy','Finnish'),('aresgalaxy','Polish'),('aresgalaxy','Portuguese'),('aresgalaxy','Slovak'),('aresgalaxy','Russian'),('audacity','English'),('audacity','Bulgarian'),('audacity','Brazilian Portuguese'),('audacity','Czech'),('audacity','Catalan'),('audacity','French'),('audacity','German'),('audacity','Macedonian'),('audacity','Norwegian'),('audacity','Danish'),('audacity','Russian'),('audacity','Swedish'),('audacity','Portuguese'),('audacity','Hungarian'),('audacity','Polish'),('audacity','Chinese (Simplified)'),('audacity','Chinese (Traditional)'),('audacity','Finnish'),('audacity','Dutch'),('audacity','Ukrainian'),('audacity','Spanish'),('audacity','Japanese'),('azureus','English'),('azureus','French'),('azureus','Finnish'),('azureus','Dutch'),('azureus','Spanish'),('azureus','Hebrew'),('azureus','Italian'),('azureus','Japanese'),('azureus','Portuguese'),('azureus','Czech'),('azureus','German'),('azureus','Thai'),('azureus','Arabic'),('azureus','Swedish'),('azureus','Chinese (Traditional)'),('azureus','Chinese (Simplified)'),('azureus','Polish'),('azureus','Danish'),('azureus','Russian'),('azureus','Norwegian'),('azureus','Brazilian Portuguese'),('azureus','Bulgarian'),('azureus','Lithuanian'),('azureus','Catalan'),('azureus','Turkish'),('azureus','Galician'),('azureus','Greek'),('azureus','Malay'),('azureus','Hungarian'),('azureus','Romanian'),('azureus','Korean'),('bittorrent','English'),('dcplusplus','English'),('emule','English'),('emule','German'),('emule','Arabic'),('emule','Bulgarian'),('emule','Chinese (Simplified)'),('emule','Chinese (Traditional)'),('emule','Danish'),('emule','Estonian'),('emule','Finnish'),('emule','French'),('emule','Galician'),('emule','Greek'),('emule','Hebrew'),('emule','Italian'),('emule','Korean'),('emule','Lithuanian'),('emule','Norwegian'),('emule','Polish'),('emule','Russian'),('emule','Romanian'),('emule','Swedish'),('emule','Slovene'),('emule','Spanish'),('emule','Turkish'),('emule','Czech'),('emule','Portuguese'),('emule','Hungarian'),('emule','Dutch'),('emule','Catalan'),('emule','Ukrainian'),('emule','Albanian'),('emule','Japanese'),('emule','Maltese'),('emule','Brazilian Portuguese'),('emule','Vietnamese'),('emuleplus','English'),('emuleplus','Russian'),('emuleplus','Belarusian'),('emuleplus','Catalan'),('emuleplus','Chinese (Simplified)'),('emuleplus','Chinese (Traditional)'),('emuleplus','Danish'),('emuleplus','Dutch'),('emuleplus','Finnish'),('emuleplus','French'),('emuleplus','German'),('emuleplus','Greek'),('emuleplus','Hebrew'),('emuleplus','Italian'),('emuleplus','Korean'),('emuleplus','Lithuanian'),('emuleplus','Norwegian'),('emuleplus','Polish'),('emuleplus','Portuguese'),('emuleplus','Romanian'),('emuleplus','Spanish'),('emuleplus','Turkish'),('emuleplus','Croatian'),('emuleplus','Czech'),('emuleplus','Brazilian Portuguese'),('emuleplus','Malay'),('emuleplus','Ukrainian'),('emuleplus','Slovene'),('emuleplus','Serbian'),('emuleplus','Hungarian'),('filezilla','English'),('filezilla','German'),('filezilla','French'),('filezilla','Polish'),('filezilla','Hungarian'),('filezilla','Spanish'),('filezilla','Chinese (Simplified)'),('filezilla','Chinese (Traditional)'),('filezilla','Arabic'),('filezilla','Japanese'),('guliverkli','English'),('guliverkli','Hungarian'),('pdfcreator','English'),('pdfcreator','German'),('pdfcreator','French'),('pidgin','Brazilian Portuguese'),('pidgin','Bulgarian'),('pidgin','Catalan'),('pidgin','Bosnian'),('pidgin','Czech'),('pidgin','Danish'),('pidgin','Dutch'),('pidgin','English'),('pidgin','Finnish'),('pidgin','German'),('pidgin','Greek'),('pidgin','Spanish'),('pidgin','French'),('pidgin','Hebrew'),('pidgin','Hindi'),('pidgin','Hungarian'),('pidgin','Italian'),('pidgin','Japanese'),('pidgin','Korean'),('pidgin','Lithuanian'),('pidgin','Macedonian'),('pidgin','Norwegian'),('pidgin','Polish'),('pidgin','Portuguese'),('pidgin','Romanian'),('pidgin','Russian'),('pidgin','Serbian'),('pidgin','Swedish'),('pidgin','Telugu'),('pidgin','Vietnamese'),('pidgin','Chinese (Simplified)'),('pidgin','Chinese (Traditional)'),('pidgin','Persian'),('portableapps','English'),('portableapps','French'),('portableapps','Italian'),('portableapps','German'),('portableapps','Chinese (Simplified)'),('portableapps','Japanese'),('portableapps','Dutch'),('portableapps','Hungarian'),('portableapps','Portuguese'),('portableapps','Spanish'),('portableapps','Russian'),('portableapps','Chinese (Traditional)'),('portableapps','Brazilian Portuguese'),('sevenzip','English'),('shareaza','English'),('shareaza','Afrikaans'),('shareaza','Chinese (Simplified)'),('shareaza','German'),('shareaza','Spanish'),('shareaza','Finnish'),('shareaza','French'),('shareaza','Greek'),('shareaza','Hebrew'),('shareaza','Croatian'),('shareaza','Hungarian'),('shareaza','Italian'),('shareaza','Lithuanian'),('shareaza','Norwegian'),('shareaza','Polish'),('shareaza','Brazilian Portuguese'),('shareaza','Russian'),('shareaza','Dutch'),('shareaza','Turkish'),('shareaza','Chinese (Traditional)'),('shareaza','Serbian'),('shareaza','Japanese'),('shareaza','Catalan'),('shareaza','Czech'),('shareaza','Estonian'),('shareaza','Slovene'),('shareaza','Albanian'),('shareaza','Arabic'),('winscp','English'),('winscp','Czech'),('winscp','German'),('winscp','French'),('winscp','Italian'),('winscp','Japanese'),('winscp','Russian'),('winscp','Spanish'),('winscp','Swedish'),('winscp','Indonesian'),('winscp','Finnish'),('winscp','Hungarian'),('winscp','Malay'),('winscp','Polish'),('winscp','Portuguese'),('winscp','Catalan'),('winscp','Dutch'),('winscp','Brazilian Portuguese'),('winscp','Croatian'),('winscp','Korean'),('winscp','Serbian'),('winscp','Chinese (Simplified)'),('winscp','Chinese (Traditional)'),('winscp','Turkish'),('winscp','Ukrainian'); /*!40000 ALTER TABLE `Translation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `UserInterface` -- DROP TABLE IF EXISTS `UserInterface`; CREATE TABLE `UserInterface` ( `project` varchar(255) default NULL, `content` varchar(255) default NULL, KEY `project` (`project`), KEY `content` (`content`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `UserInterface` -- LOCK TABLES `UserInterface` WRITE; /*!40000 ALTER TABLE `UserInterface` DISABLE KEYS */; INSERT INTO `UserInterface` VALUES ('amsn','X Window System (X11)'),('amsn','Tk'),('aresgalaxy','Win32 (MS Windows)'),('audacity','Win32 (MS Windows)'),('audacity','X Window System (X11)'),('audacity','Carbon (Mac OS X)'),('audacity','wxWidgets'),('audacity','GTK+'),('azureus','Win32 (MS Windows)'),('azureus','Cocoa (MacOS X)'),('azureus','X Window System (X11)'),('azureus','Carbon (Mac OS X)'),('azureus','Java SWT'),('bittorrent','Non-interactive (Daemon)'),('bittorrent','Web-based'),('cdexos','Win32 (MS Windows)'),('corefonts','X Window System (X11)'),('dcplusplus','Win32 (MS Windows)'),('emule','Win32 (MS Windows)'),('emuleplus','Web-based'),('emuleplus','Win32 (MS Windows)'),('emuleplus','Handheld/Mobile/PDA'),('filezilla','wxWidgets'),('gimp-win','Win32 (MS Windows)'),('guliverkli','Win32 (MS Windows)'),('pdfcreator','Win32 (MS Windows)'),('pidgin','Gnome'),('pidgin','Win32 (MS Windows)'),('pidgin','GTK+'),('portableapps','Win32 (MS Windows)'),('sevenzip','Win32 (MS Windows)'),('shareaza','Win32 (MS Windows)'),('shareaza','Web-based'),('virtualdub','Win32 (MS Windows)'),('winscp','Win32 (MS Windows)'),('winscp','Plugins'); /*!40000 ALTER TABLE `UserInterface` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2010-02-25 17:13:30