PHP Classes

File: sql/mysql.sql

Recommend this page to a friend!
  Classes of Goffy G  >  XOOPS Transifex  >  sql/mysql.sql  >  Download  
File: sql/mysql.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: XOOPS Transifex
Manage project text translations with Transifex
Author: By
Last change:
Date: 1 year ago
Size: 10,488 bytes
 

Contents

Class file image Download
# SQL Dump for wgtransifex module
# PhpMyAdmin Version: 4.0.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generated on: Sun Jun 14, 2020 to 12:35:41
# Server version: 5.5.5-10.4.10-MariaDB
# PHP Version: 7.3.12

#
# Structure table for `wgtransifex_projects` 8
#

CREATE TABLE `wgtransifex_projects` (
    `pro_id`                   INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `pro_description`          VARCHAR(255)    NOT NULL DEFAULT '',
    `pro_source_language_code` VARCHAR(255)    NOT NULL DEFAULT '',
    `pro_slug`                 VARCHAR(255)    NOT NULL DEFAULT '',
    `pro_name`                 VARCHAR(255)    NOT NULL DEFAULT '',
    `pro_txresources`          INT(10)         NOT NULL DEFAULT '0',
    `pro_last_updated`         INT(10)         NOT NULL DEFAULT '0',
    `pro_teams`                TEXT            NOT NULL,
    `pro_resources`            INT(10)         NOT NULL DEFAULT '0',
    `pro_translations`         INT(10)         NOT NULL DEFAULT '0',
    `pro_archived`             INT(1)          NOT NULL DEFAULT '0',
    `pro_status`               INT(1)          NOT NULL DEFAULT '0',
    `pro_type`                 INT(1)          NOT NULL DEFAULT '0',
    `pro_date`                 INT(11)         NOT NULL DEFAULT '0',
    `pro_submitter`            INT(10)         NOT NULL DEFAULT '0',
    PRIMARY KEY (`pro_id`)
)
    ENGINE = InnoDB;

#
# Structure table for `wgtransifex_resources` 12
#

CREATE TABLE `wgtransifex_resources` (
    `res_id`                   INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `res_source_language_code` VARCHAR(255)    NOT NULL DEFAULT '',
    `res_name`                 VARCHAR(255)    NOT NULL DEFAULT '',
    `res_i18n_type`            VARCHAR(255)    NOT NULL DEFAULT '',
    `res_priority`             VARCHAR(255)    NOT NULL DEFAULT '',
    `res_slug`                 VARCHAR(255)    NOT NULL DEFAULT '',
    `res_categories`           VARCHAR(255)    NOT NULL DEFAULT '',
    `res_metadata`             TEXT            NOT NULL,
    `res_translations`         INT(11)         NOT NULL DEFAULT '0',
    `res_date`                 INT(11)         NOT NULL DEFAULT '0',
    `res_submitter`            INT(10)         NOT NULL DEFAULT '0',
    `res_status`               INT(1)          NOT NULL DEFAULT '0',
    `res_pro_id`               INT(10)         NOT NULL DEFAULT '0',
    PRIMARY KEY (`res_id`)
)
    ENGINE = InnoDB;

#
# Structure table for `wgtransifex_translations` 8
#

CREATE TABLE `wgtransifex_translations` (
    `tra_id`                    INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `tra_pro_id`                INT(10)         NOT NULL DEFAULT '0',
    `tra_res_id`                INT(10)         NOT NULL DEFAULT '0',
    `tra_lang_id`               INT(10)         NOT NULL DEFAULT '0',
    `tra_content`               TEXT            NOT NULL,
    `tra_mimetype`              VARCHAR(100)    NOT NULL DEFAULT '',
    `tra_proofread`             INT(10)         NOT NULL DEFAULT '0',
    `tra_proofread_percentage`  INT(10)         NOT NULL DEFAULT '0',
    `tra_reviewed_percentage`   INT(10)         NOT NULL DEFAULT '0',
    `tra_completed`             INT(10)         NOT NULL DEFAULT '0',
    `tra_untranslated_words`    INT(10)         NOT NULL DEFAULT '0',
    `tra_last_commiter`         INT(10)         NOT NULL DEFAULT '0',
    `tra_reviewed`              INT(10)         NOT NULL DEFAULT '0',
    `tra_translated_entities`   INT(10)         NOT NULL DEFAULT '0',
    `tra_translated_words`      INT(10)         NOT NULL DEFAULT '0',
    `tra_untranslated_entities` INT(10)         NOT NULL DEFAULT '0',
    `tra_last_update`           INT(10)         NOT NULL DEFAULT '0',
    `tra_local`                 VARCHAR(255)    NOT NULL DEFAULT '',
    `tra_status`                INT(1)          NOT NULL DEFAULT '0',
    `tra_date`                  INT(11)         NOT NULL DEFAULT '0',
    `tra_submitter`             INT(10)         NOT NULL DEFAULT '0',
    PRIMARY KEY (`tra_id`)
)
    ENGINE = InnoDB;

#
# Structure table for `wgtransifex_settings` 7
#

CREATE TABLE `wgtransifex_settings` (
    `set_id`        INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `set_username`  VARCHAR(255)    NOT NULL DEFAULT '',
    `set_password`  VARCHAR(50)     NOT NULL DEFAULT '',
    `set_primary`   INT(1)          NOT NULL DEFAULT '0',
    `set_request`   INT(1)          NOT NULL DEFAULT '0',
    `set_date`      INT(11)         NOT NULL DEFAULT '0',
    `set_submitter` INT(10)         NOT NULL DEFAULT '0',
    PRIMARY KEY (`set_id`)
)
    ENGINE = InnoDB;

#
# Structure table for `wgtransifex_languages` 8
#

CREATE TABLE `wgtransifex_languages` (
    `lang_id`        INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `lang_name`      VARCHAR(255)    NOT NULL DEFAULT '',
    `lang_code`      VARCHAR(10)     NOT NULL DEFAULT '',
    `lang_folder`    VARCHAR(100)    NOT NULL DEFAULT '',
    `lang_iso_639_1` VARCHAR(2)      NOT NULL DEFAULT '',
    `lang_iso_639_2` VARCHAR(3)      NOT NULL DEFAULT '',
    `lang_flag`      VARCHAR(255)    NOT NULL DEFAULT '',
    `lang_primary`   INT(1)         NOT NULL DEFAULT '0',
    `lang_online`    INT(1)         NOT NULL DEFAULT '0',
    `lang_date`      INT(11)         NOT NULL DEFAULT '0',
    `lang_submitter` INT(10)         NOT NULL DEFAULT '0',
    PRIMARY KEY (`lang_id`)
)
    ENGINE = InnoDB;

INSERT INTO `wgtransifex_languages` (`lang_id`, `lang_name`, `lang_code`, `lang_folder`, `lang_iso_639_1`, `lang_iso_639_2`, `lang_flag`, `lang_primary`, `lang_online`, `lang_date`, `lang_submitter`) VALUES
(1, 'English', 'en_GB', 'english', 'en', 'eng', 'gb.png', 1, 1, 1592123375, 1),
(2, 'German', 'de_DE', 'german', 'de', 'deu', 'de.png', 0, 1, 1592123462, 1),
(3, 'French', 'fr_FR', 'french', 'fr', 'fra', 'fr.png', 0, 1, 1592123476, 1),
(4, 'Spanish', 'es_ES', 'spanish', 'es', 'spa', 'es.png', 0, 1, 1593419501, 1),
(5, 'Slovak', 'sk_SK', 'slovak', 'sk', 'slo', 'sk.png', 0, 1, 1593419520, 1),
(6, 'Portuguese (Brasil)', 'pt_BR', 'brasil', 'pt', 'por', 'br.png', 0, 1, 1593419536, 1),
(7, 'Italian', 'it_IT', 'italian', 'it', 'ita', 'it.png', 0, 1, 1593419556, 1),
(8, 'Russian', 'ru_RU', 'russian', 'ru', 'rus', 'ru.png', 0, 1, 1593419569, 1),
(9, 'Dutch', 'nl_NL', 'dutch', 'nl', 'nld', 'nl.png', 0, 1, 1593419586, 1),
(10, 'Danish', 'da_DK', 'danish', 'da', 'dan', 'dk.png', 0, 1, 1593419599, 1),
(11, 'Turkish', 'tr_TR', 'turkish', 'tr', 'tur', 'tr.png', 0, 1, 1593419615, 1),
(12, 'Chinese (Taiwan)', 'zh_TW', '', '', '', 'tw.png', 0, 1, 1593419637, 1),
(13, 'Polish', 'pl_PL', 'Polish', 'pl', 'pol', 'pl.png', 0, 1, 1593419651, 1),
(14, 'Persian (Iran)', 'fa_IR', 'persian', 'fa', 'fas', 'ir.png', 0, 1, 1593419665, 1),
(15, 'Arabic', 'ar', 'persian', 'ar', '', 'blank.png', 0, 1, 1593460998, 1),
(16, 'Japanese', 'ja_JP', 'japanese', 'ja', 'jpn', 'jp.png', 0, 1, 1593421597, 1),
(17, 'Greek', 'el_GR', 'greek', 'el', '', 'gr.png', 0, 1, 1593430124, 1),
(18, 'Bulgarian', 'bg_BG', 'bulgarian', 'bg', 'bul', 'bg.png', 0, 1, 1593421764, 1),
(19, 'Arabic (Saudi Arabia)', 'ar_SA', 'arabic', 'ar', '', 'sa.png', 0, 1, 1593421899, 1),
(20, 'Chinese (China)', 'zh_CN', '', '', '', 'cn.png', 0, 1, 1593421973, 1),
(21, 'Croatian', 'hr_HR', 'croatian', 'hr', '', 'hr.png', 0, 1, 1593422043, 1),
(22, 'Swedish', 'sv_SE', 'swedish', 'sv', '', 'se.png', 0, 1, 1593422107, 1),
(23, 'Czech', 'cs_CZ', 'czech', 'cs', '', 'cz.png', 0, 1, 1593422315, 1),
(24, 'Portuguese', 'pt_PT', 'portuguese', 'pt', '', 'pt.png', 0, 1, 1593423332, 1),
(25, 'Slovenian', 'sl_SI', 'slovenian', 'sl', '', 'si.png', 0, 1, 1593422461, 1),
(26, 'English (Canada)', 'en_CA', '', '', '', 'ca.png', 0, 1, 1593422588, 1),
(27, 'Korean (Korea)', 'ko_KR', 'korean', 'ko', '', 'kr.png', 0, 1, 1593422655, 1),
(28, 'Vietnamese', 'vi_VN', 'vietnamese', 'vi', '', 'vn.png', 0, 1, 1593422731, 1),
(29, 'Malay (Malaysia)', 'ms_MY', 'malay', 'ms', '', 'my.png', 0, 1, 1593422796, 1),
(30, 'Hungarian', 'hu_HU', 'hungarian', 'hu', '', 'hu.png', 0, 1, 1593422861, 1),
(31, 'Thai', 'th_TH', 'thai', 'th', '', 'th.png', 0, 1, 1593422907, 1),
(32, 'Bosnian', 'bs_BA', 'bosnian', 'bs', '', 'ba.png', 0, 1, 1593430107, 1),
(33, 'Hebrew (Israel)', 'he_IL', 'hebrew', 'he', '', 'il.png', 0, 1, 1593423047, 1),
(34, 'Romanian', 'ro_RO', 'romanian', 'ro', '', 'ro.png', 0, 1, 1593430158, 1),
(35, 'Serbian (Serbia)', 'sr_RS', 'serbian', 'sr', '', 'rs.png', 0, 1, 1593423125, 1),
(36, 'Burmese (Myanmar)', 'my_MM', 'burmese', 'my', '', 'mm.png', 0, 1, 1593423182, 1),
(37, 'Catalan (Spain)', 'ca_ES', '', '', '', 'blank.png', 0, 1, 1593423233, 1),
(38, 'English (United States)', 'en_US', '', '', '', 'us.png', 0, 1, 1593423287, 1),
(39, 'French (Canada)', 'fr_CA', '', '', '', 'ca.png', 0, 1, 1593423353, 1),
(40, 'Indonesian', 'id_ID', 'indonesian', 'id', '', 'id.png', 0, 1, 1593430138, 1),
(41, 'Norwegian', 'no_NO', 'norwegian', 'no', '', 'no.png', 0, 1, 1593423465, 1),
(42, 'Tagalog (Philippines)', 'tl_PH', 'tagalog', 'tl', '', 'ph.png', 0, 1, 1593423522, 1),
(43, 'Ukrainian', 'uk_UA', 'ukrainian', 'uk', '', 'ua.png', 0, 1, 1593430174, 1),
(44, 'Urdu (Pakistan)', 'ur_PK', 'urdu', 'ur', '', 'pk.png', 0, 1, 1593423595, 1);

#
# Structure table for `wgtransifex_packages` 6
#

CREATE TABLE `wgtransifex_packages` (
    `pkg_id`        INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
    `pkg_name`      VARCHAR(255)    NOT NULL DEFAULT '',
    `pkg_desc`      TEXT            NULL,
    `pkg_pro_id`    VARCHAR(10)     NOT NULL DEFAULT '',
    `pkg_lang_id`   VARCHAR(10)     NOT NULL DEFAULT '',
    `pkg_status`    INT(11)         NOT NULL DEFAULT '0',
    `pkg_zip`       VARCHAR(255)    NOT NULL DEFAULT '',
    `pkg_logo`      VARCHAR(255)    NOT NULL DEFAULT '',
    `pkg_date`      INT(11)         NOT NULL DEFAULT '0',
    `pkg_submitter` INT(10)         NOT NULL DEFAULT '0',
    PRIMARY KEY (`pkg_id`)
)
    ENGINE = InnoDB;

#
# Structure table for `wgtransifex_requests` 8
#

CREATE TABLE `wgtransifex_requests` (
  `req_id`         INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `req_pro_id`     INT(0)          NOT NULL DEFAULT '0',
  `req_lang_id`    INT(0)          NOT NULL DEFAULT '0',
  `req_info`       VARCHAR(255)    NOT NULL DEFAULT '',
  `req_date`       INT(11)         NOT NULL DEFAULT '0',
  `req_submitter`  INT(10)         NOT NULL DEFAULT '0',
  `req_status`     INT(1)          NOT NULL DEFAULT '0',
  `req_statusdate` INT(11)         NOT NULL DEFAULT '0',
  `req_statusuid`  INT(10)         NOT NULL DEFAULT '0',
  PRIMARY KEY (`req_id`)
) ENGINE=InnoDB;
For more information send a message to info at phpclasses dot org.