Revision 12441
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1091 | 1091 |
); |
| 1092 | 1092 |
|
| 1093 | 1093 |
|
| 1094 |
-- |
|
| 1095 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1096 |
-- |
|
| 1097 | 1094 |
|
| 1098 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 1099 |
projects varchar(255) |
|
| 1100 |
); |
|
| 1101 | 1095 |
|
| 1102 |
|
|
| 1103 | 1096 |
-- |
| 1104 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 1105 |
-- |
|
| 1106 |
|
|
| 1107 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 1108 |
project_name varchar(255) |
|
| 1109 |
); |
|
| 1110 |
|
|
| 1111 |
|
|
| 1112 |
|
|
| 1113 |
|
|
| 1114 |
-- |
|
| 1115 | 1097 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 1116 | 1098 |
-- |
| 1117 | 1099 |
|
| ... | ... | |
| 3923 | 3905 |
|
| 3924 | 3906 |
|
| 3925 | 3907 |
-- |
| 3908 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3909 |
-- |
|
| 3910 |
|
|
| 3911 |
CREATE TABLE `~type._plots_01_count_of_projects` ( |
|
| 3912 |
projects varchar(255) |
|
| 3913 |
); |
|
| 3914 |
|
|
| 3915 |
|
|
| 3916 |
-- |
|
| 3917 |
-- Name: ~type._plots_02_list_of_project_names; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
|
| 3918 |
-- |
|
| 3919 |
|
|
| 3920 |
CREATE TABLE `~type._plots_02_list_of_project_names` ( |
|
| 3921 |
project_name varchar(255) |
|
| 3922 |
); |
|
| 3923 |
|
|
| 3924 |
|
|
| 3925 |
-- |
|
| 3926 | 3926 |
-- Name: ~type._plots_03_count_of_all_plots_in_this_source; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 3927 | 3927 |
-- |
| 3928 | 3928 |
|
Also available in: Unified diff
schemas/util.sql, vegbien.sql: do not declare IMMUTABLE SQL-language functions as STRICT, because this prevents them from being inlined (as documented in the util schema comment)