Skip to content

Instantly share code, notes, and snippets.

@dgershman

dgershman/bmlt_expand_data.sql

Last active February 1, 2016 03:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dgershman/7fa10f524c5360ecc32c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dgershman/7fa10f524c5360ecc32c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bmlt_expand_data.sql
INSERT INTO `na_comdef_meetings_data` (`meetingid_bigint`, `key`, `field_prompt`, `lang_enum`, `visibility`, `data_string`)
SELECT `Id`,'meeting_name','Meeting Name','en',0,`Name` FROM `imported`;
INSERT INTO `na_comdef_meetings_data` (`meetingid_bigint`, `key`, `field_prompt`, `lang_enum`, `visibility`, `data_string`)
SELECT `Id`,'location_text','Location Name','en',0,`Location` FROM `imported`;
INSERT INTO `na_comdef_meetings_data` (`meetingid_bigint`, `key`, `field_prompt`, `lang_enum`, `visibility`, `data_string`)
SELECT `Id`,'location_street','Street Address','en',0,`Address` FROM `imported`;
INSERT INTO `na_comdef_meetings_data` (`meetingid_bigint`, `key`, `field_prompt`, `lang_enum`, `visibility`, `data_string`)
SELECT `Id`,'location_municipality','Town','en',0,`City` FROM `imported`;
INSERT INTO `na_comdef_meetings_data` (`meetingid_bigint`, `key`, `field_prompt`, `lang_enum`, `visibility`, `data_string`)
SELECT `Id`,'location_province','Town','en',0,`State` FROM `imported`;
INSERT INTO `na_comdef_meetings_data` (`meetingid_bigint`, `key`, `field_prompt`, `lang_enum`, `visibility`, `data_string`)
SELECT `Id`,'location_postal_code_1','Zip Code','en',0,`Zip` FROM `imported`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment