Skip to content

Instantly share code, notes, and snippets.

@nitriques

nitriques/add-missing-lang-image.sql

Last active February 19, 2019 15:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nitriques/8cdc6b9d1ec78ba36e6e to your computer and use it in GitHub Desktop.
Save nitriques/8cdc6b9d1ec78ba36e6e to your computer and use it in GitHub Desktop.
Download ZIP
Multilingual Textbox: add missing lang
Raw
add-missing-lang-image.sql
ALTER TABLE `sym_entries_data_X`
ADD `file-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
ADD `size-en` int(11) unsigned DEFAULT NULL,
ADD `mimetype-en` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
ADD `meta-en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
Raw
add-missing-lang-oembed.sql
ALTER TABLE `sym_entries_data_X`
ADD `res_id-en` varchar(128),
ADD `url-en` text,
ADD `url_oembed_xml-en` text,
ADD `title-en` text,
ADD `thumbnail_url-en` text,
ADD `oembed_xml-en` text,
ADD `driver-en` varchar(50)
Raw
add-missing-lang.sql
ALTER TABLE `sym_entries_data_X`
ADD `handle-en` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ,
ADD `value-en` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ,
ADD `word_count-en` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ,
ADD `value_formatted-en` INT( 11 ) UNSIGNED NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment