Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Branch: master
Fetching contributors…

Cannot retrieve contributors at this time

executable file 15 lines (10 sloc) 1.166 kB
DROP VIEW IF EXISTS forms;
CREATE VIEW forms (id, name, version, build, published, description, encounter_type, schema_namespace, template, infopath_solution_version, uri, xslt, creator, date_created, changed_by, date_changed, retired, retired_by, date_retired, retired_reason) AS SELECT * FROM form;
DROP VIEW IF EXISTS locations;
CREATE VIEW locations (id, name, description, address1, address2, city_village, state_province, postal_code, country, latitude, longitude, parent_location_id, creator, date_created) AS SELECT * FROM location;
DROP VIEW IF EXISTS fields;
CREATE VIEW fields (id, name, description, field_type, concept_id, table_name, attribute_name, default_value, select_multiple, creator, date_created, changed_by, date_changed ) AS SELECT * from field;
DROP VIEW IF EXISTS form_fields;
CREATE VIEW form_fields (id, form_id, field_id, field_number, field_part, page_number, parent_form_field, min_occurs, max_occurs, required, changed_by, date_changed, creator, date_created) AS SELECT * from form_field;
DROP VIEW IF EXISTS field_types;
CREATE VIEW field_types (id, name, description, is_set, creator, date_created) AS SELECT * from field_type;
Jump to Line
Something went wrong with that request. Please try again.