update new xt style

diff --git a/foundation-database/public/tables/location.sql b/foundation-database/public/tables/location.sql
new file mode 100644 (file)
index 0000000..5fc9557
--- /dev/null
+++ b/foundation-database/public/tables/location.sql
@@ -0,0 +1,10 @@
+--ALTER TABLE location ADD COLUMN location_formatname TEXT;
+--CREATE INDEX location_location_formatname_idx on location using btree (location_formatname);
+
+--UPDATE location SET location_formatname=formatLocationName(location_id);
+
+
+select xt.add_column('location','location_formatname', 'TEXT', NULL, 'public');
+select xt.add_index('location', 'location_formatname','location_location_formatname_idx', 'btree', 'public');
+UPDATE location SET location_formatname=formatLocationName(location_id) WHERE location_formatname IS NULL;
+