1 <!-- CREATE VIEW options -->
2 <div id="div_view_options">
3 <form method="post" action="{{ url('/view/create') }}">
4 {{ get_hidden_inputs(url_params) }}
10 {% if view['operation'] == 'create' %}
11 {% trans 'Create view' %}
13 {% trans 'Edit view' %}
17 <table class="pma-table rte_table">
18 {% if view['operation'] == 'create' %}
20 <td class="nowrap"><label for="or_replace">OR REPLACE</label></td>
22 <input type="checkbox" name="view[or_replace]" id="or_replace"
23 {% if (view['or_replace']) %} checked="checked" {% endif %}
30 <td class="nowrap"><label for="algorithm">ALGORITHM</label></td>
32 <select name="view[algorithm]" id="algorithm">
33 {% for option in view_algorithm_options %}
34 <option value="{{ option }}"
35 {% if view['algorithm'] == option %}
38 >{{ option }}</option>
45 <td class="nowrap">{% trans 'Definer' %}</td>
46 <td><input type="text" maxlength="100" size="50" name="view[definer]" value="{{ view['definer'] }}"></td>
50 <td class="nowrap">SQL SECURITY</td>
52 <select name="view[sql_security]">
53 <option value=""></option>
54 {% for option in view_security_options %}
55 <option value="{{ option }}"
56 {% if option == view['sql_security'] %} selected="selected" {% endif %}
57 >{{ option }}</option>
63 {% if view['operation'] == 'create' %}
65 <td class="nowrap">{% trans 'VIEW name' %}</td>
67 <input type="text" size="20" name="view[name]" onfocus="this.select()" maxlength="64" value="{{ view['name'] }}">
73 <input type="hidden" name="view[name]" value="{{ view['name'] }}">
79 <td class="nowrap">{% trans 'Column names' %}</td>
81 <input type="text" maxlength="100" size="50" name="view[column_names]" onfocus="this.select()" value="{{ view['column_names'] }}">
86 <td class="nowrap">AS</td>
88 <textarea name="view[as]" rows="15" cols="40" dir="{{ text_dir }}" onclick="Functions.selectContent(this, sqlBoxLocked, true)">{{ view['as'] }}</textarea><br>
89 <input type="button" value="Format" id="format" class="btn btn-secondary button sqlbutton">
90 <span id="querymessage"></span>
95 <td class="nowrap">WITH CHECK OPTION</td>
97 <select name="view[with]">
98 <option value=""></option>
99 {% for option in view_with_options %}
100 <option value="{{ option }}"
101 {% if option == view['with'] %} selected="selected" {% endif %}
102 >{{ option }}</option>
111 <input type="hidden" name="ajax_request" value="1" />
112 <input type="hidden" name="{{ (view['operation'] == 'create') ? 'createview' : 'alterview' }}" value="1" />
114 {% if ajax_dialog == false %}
115 <input type="hidden" name="ajax_dialog" value="1" />
116 <input type="submit" class="btn btn-primary" name="" value="{% trans 'Go' %}" />