# # ChangeLog for /sql # # Generated by Trac 0.10.3 # 05/23/13 07:52:28 # 10/21/09 15:25:05 Robert Treat <robert@omniti.com> [27d71aae523d1e2c256d396c8a0582f8a0052874] * sql/sprocs/stratcon.window_robust_derive.sql (modified) need to return a return type of a type that exists 10/21/09 14:22:06 Theo Schlossnagle <jesus@omniti.com> [e5e4b416e07adf6285bb5140316e5624a8f44224] * sql/scaffolding.sql (modified) * sql/sprocs/stratcon.fetch_varset.sql (modified) fix varset fetching 10/20/09 21:27:53 Robert Treat <robert@omniti.com> [f0400f824c10ceac576427c5023429506384cd8a] * sql/sprocs/noit.update_mns_via_check_currently.sql (added) * sql/sprocs/noit.update_mns_via_check_tag.sql (modified) * sql/sprocs/noit.update_mns_via_metric_tag.sql (modified) * sql/sprocs/noit.update_mns_via_self.sql (modified) trigger function updates for metric name summary management 10/20/09 21:21:11 Robert Treat <robert@omniti.com> [b4c0bb19ecdfe7283237a73c2e71a43d343e4210] * sql/tables/noit.check_currently.sql (modified) * sql/tables/noit.check_tag.sql (modified) * sql/tables/noit.metric_name_summary.sql (modified) * sql/tables/noit.metric_tag.sql (modified) trigger updates for metric name summary management, also some perms cleaning 10/20/09 19:54:47 Robert Treat <robert@omniti.com> [7b411d3b64a0cefe7a6ad99c78edfe85c96f3835] * sql/tables/noit.check_currently.sql (modified) update for mns trigger bits 10/20/09 19:48:56 Robert Treat <robert@omniti.com> [4a0968d07bb3e70d2212cb2ef9d79b6b1bc02b49] * sql/sprocs/stratcon.metric_name_summary_compile_fts_data.sql (added) * sql/sprocs/stratcon.metric_name_summary_tsvector.sql (deleted) and yes, renaming this 10/20/09 19:47:29 Robert Treat <robert@omniti.com> [30c18bf73568b5619b4c17cbccb9c390f971095c] * sql/sprocs/stratcon.metric_name_summary_tsvector.sql (modified) code cleanup, avoid explicit noit paths 10/20/09 18:59:55 Robert Treat <robert@omniti.com> [635ff12b1629be1d08ee18e49f204c9921a0a939] * sql/sprocs/noit.update_check_currently.sql (added) * sql/tables/noit.check_archive.sql (modified) fix up check_archive trigger function 10/20/09 18:25:34 Robert Treat <robert@omniti.com> [ead2d4e20f8d06ebf7b813d12c1b0fd5cad0d619] * sql/sprocs/stratcon.rollup_matrix_numeric_5m.sql (deleted) * sql/sprocs/stratcon.rollup_metric_numeric_5m.sql (added) might as well name the file properly 10/20/09 18:23:58 Robert Treat <robert@omniti.com> [53bfa4e020cadb0eacbdec5a795ca408011ec3c1] * sql/sprocs/stratcon.rollup_matrix_numeric_5m.sql (added) 5 minute rollup with array based storage 10/20/09 15:34:46 Theo Schlossnagle <jesus@omniti.com> [dfd06d8bc70524168b54bb26477b5f0a3f3a38fe] * sql/scaffolding.sql (modified) * sql/sprocs/stratcon.choose_window.sql (modified) * sql/sprocs/stratcon.fetch_dataset.sql (modified) * sql/sprocs/stratcon.fetch_varset.sql (modified) * sql/sprocs/stratcon.window_robust_derive.sql (modified) fix up things to work 10/20/09 14:36:25 Depesz Lubaczewski <depesz@omniti.com> [bcfd3007c0f115d339be6889e5a1fc27333d0b43] * sql/split.prism.dump.to.sprocs.pl (deleted) oops, wrong place to commit it 10/20/09 14:30:05 Depesz Lubaczewski <depesz@omniti.com> [a27cd9b462a686609eff744d1e6553da5605090b] * sql/split.prism.dump.to.sprocs.pl (added) * sql/sprocs/prism.add_graph_tags.sql (added) * sql/sprocs/prism.add_tags.sql (added) * sql/sprocs/prism.check_name_saved_graphs.sql (added) * sql/sprocs/prism.remove_graph_tags.sql (added) * sql/sprocs/prism.remove_tags.sql (added) * sql/sprocs/prism.saved_graphs_tsvector.sql (added) * sql/sprocs/prism.trig_update_tsvector_saved_graphs.sql (added) prism procedures, and simple tool to split pg_dump -n prism -s output into many files 10/20/09 14:13:56 Theo Schlossnagle <jesus@omniti.com> [fe61445ceeeb2974d31db88909d8abbbaeaeb578] * sql/Makefile.in (modified) * sql/README (modified) * sql/build_ddl.pl (added) * sql/dump.sh (deleted) * sql/reconnoiter_ddl_dump.sql (deleted) * sql/scaffolding.sql (modified) a new way of doing this, refs #150 10/20/09 13:45:53 Theo Schlossnagle <jesus@omniti.com> [66c92038a4140676e18fc96716d36bb945eba924] * sql/tables/prism.graph_templates.sql (added) * sql/tables/prism.saved_graphs.sql (added) * sql/tables/prism.saved_graphs_dep.sql (added) * sql/tables/prism.saved_worksheets.sql (added) * sql/tables/prism.saved_worksheets_dep.sql (added) prism tables 10/20/09 13:29:27 Depesz Lubaczewski <depesz@omniti.com> [37c50c67253c32e0517ecd111d22631e0750dcda] * sql/README (modified) test commit 10/19/09 01:14:06 Theo Schlossnagle <jesus@omniti.com> [08e498f88b47f53edf390c85d08577fa1d7686ab] * sql/sprocs/stratcon.map_uuid_to_sid.sql (modified) add storage_node_id in the return set 10/18/09 02:15:30 Theo Schlossnagle <jesus@omniti.com> [b2014c0dfb34073e61a3e9f96a38d772a8f31a1c] * sql/scaffolding.sql (modified) * sql/sprocs/stratcon.get_storage_node_for_sid.sql (modified) * sql/sprocs/stratcon.map_uuid_to_sid.sql (modified) fix these up to take th noit through 10/17/09 20:31:17 Theo Schlossnagle <jesus@omniti.com> [4bd41daf5972011000e2f08b921a9809998bd036] * sql/scaffolding.sql (modified) * sql/sprocs/stratcon.update_config.sql (added) * sql/tables/stratcon.current_node_config_changelog.sql (added) some more missing tables 10/17/09 17:51:07 Theo Schlossnagle <jesus@omniti.com> [4bd7d843175692be84818c389d9938e7590cd487] * sql/scaffolding.sql (added) * sql/sprocs/noit.date_hour.sql (added) * sql/tables/noit.metric_numeric_rollup_5m.sql (modified) * sql/tables/noit.metric_tag.sql (modified) make it load 10/09/09 19:09:46 Robert Treat <robert@omniti.com> [0136c0f3f48fe6e4addf4d56caccce5608118f37] * sql/sprocs/stratcon.init_metric_numeric_rollup_5m.sql (added) * sql/sprocs/stratcon.init_rollup_matrix_numeric_5m.sql (deleted) we should probably name this appropriatly, round duex 10/09/09 19:08:57 Robert Treat <robert@omniti.com> [5670e468848cf3cd4817132422126141c540863a] * sql/sprocs/stratcon.init_rollup_matrix_numeric_5m.sql (modified) we should probably name this appropriatly 10/09/09 19:06:57 Robert Treat <robert@omniti.com> [c24c74b1cb20b7f00adc69391d316f16c8da4d31] * sql/sprocs/stratcon.init_rollup_matrix_numeric_5m.sql (added) initialize emtpy arrays for storage 10/02/09 20:18:13 Denish Patel <denish@omniti.com> [b9af7580cb21afd3490880bfc2830a14ed242b38] * sql/sprocs/stratcon.fetch_varset.sql (modified) stratcon.loading_dock_metric_text_s_change_log should be noit.metric_text_changelog 10/02/09 20:15:24 Denish Patel <denish@omniti.com> [2a0ae7f26e6d4261f0b0afb4e271488a2455a4e2] * sql/sprocs/noit.metric_text_archive_log_changes.sql (modified) Trigger Function noit.metric_text_archive_log_changes 10/02/09 20:10:13 Denish Patel <denish@omniti.com> [1d598ad3c8038009189e67c3da0eaa05953a1edc] * sql/sprocs/noit.metric_text_archive_log_changes.sql (added) place for noit.metric_text_archive_log_changes 10/02/09 20:07:59 Denish Patel <denish@omniti.com> [544a1ea5a8955bbe0932db12162b6fb260cd89e9] * sql/sprocs/stratcon.metric_name_summary_tsvector.sql (modified) Changed variable name to match with column name to avoid further conusion for ts_search_all vs fts_data 10/02/09 20:05:41 Denish Patel <denish@omniti.com> [ae19db0fd28c28eccecf646249d15a8ad3bd6851] * sql/sprocs/noit.update_metric_summary_fulltext.sql (modified) * sql/sprocs/noit.update_mns_via_check_tag.sql (modified) * sql/sprocs/noit.update_mns_via_metric_tag.sql (modified) * sql/sprocs/noit.update_mns_via_self.sql (modified) Updated trigger functions related to metric_name_summary as we changed column name from ts_search_all to fts_data 10/02/09 19:58:40 Denish Patel <denish@omniti.com> [2407bbfb4b4102e4faceeca0dd9510862b01c344] * sql/sprocs/noit.update_mns_via_metric_tag.sql (modified) Trigger function noit.update_mns_via_metric_tag 10/02/09 19:56:50 Denish Patel <denish@omniti.com> [3b2f82c766ae4877378154731023a27447192e2b] * sql/sprocs/noit.update_mns_via_metric_tag.sql (added) stub for noit.update_mns_via_metric_tag 10/02/09 19:52:45 Denish Patel <denish@omniti.com> [f2f2353e4dd7ecf5cd5016d921a77166c57a235b] * sql/sprocs/noit.check_status_archive_log_changes.sql (modified) Trigger function noit.check_status_archive_log_changes 10/02/09 19:19:21 Denish Patel <denish@omniti.com> [ec157f4aeccb329d265b86c5af1a8e103ce85c4f] * sql/sprocs/noit.check_status_archive_log_changes.sql (added) place for noit.check_status_archive_log_changes 10/02/09 19:14:29 Denish Patel <denish@omniti.com> [978cc49fa9053924e4eabdf90e77664a8a8da630] * sql/sprocs/noit.update_metric_summary_fulltext.sql (modified) updated noit.update_metric_summary_fulltext 10/02/09 19:10:36 Denish Patel <denish@omniti.com> [89da11dfe1603e9e3dd239922a65372058f925fe] * sql/sprocs/noit.update_metric_summary_fulltext.sql (added) stub place for noit.update_metric_summary_fulltext 10/02/09 19:03:47 Denish Patel <denish@omniti.com> [4ff346a7dcd198c02bb08809ffc8fe5cf6f613d9] * sql/sprocs/noit.update_mns_via_self.sql (modified) Added noit.update_mns_via_self 10/02/09 18:53:59 Denish Patel <denish@omniti.com> [426d0fd8097a20882bfc6c83f302d4f034b35e15] * sql/sprocs/noit.update_mns_via_self.sql (added) place for noit.update_mns_via_self 10/02/09 18:50:32 Robert Treat <robert@omniti.com> [aa30d3163c60516fad188cf6c9e0341a9895a6dd] * sql/sprocs/noit.check_archive_log_changes.sql (modified) trigger function for check_archive_changelog 10/02/09 18:45:01 Denish Patel <denish@omniti.com> [1cb12d1bd5a9021a4249d44f0a80de3a36e848c9] * sql/sprocs/noit.mark_metric_numeric_rollup_buffer.sql (added) updated noit.mark_metric_numeric_rollup_buffer 10/02/09 18:27:51 Denish Patel <denish@omniti.com> [7bdcc136d61994452c7859ab1437d1b6a3af6402] * sql/sprocs/noit.update_mns_via_check_tag.sql (modified) updated noit.update_mns_via_check_tag 10/02/09 18:24:04 Denish Patel <denish@omniti.com> [747802282ccab1d4eb70c32d900e96abd5af005d] * sql/sprocs/noit.update_mns_via_check_tag.sql (added) stub for noit.update_mns_via_check_tag 10/02/09 18:17:28 Robert Treat <robert@omniti.com> [d0f32e941f25b35bb1b266c88cd201603e687759] * sql/sprocs/noit.check_archive_log_changes.sql (added) stub for check_archive trigger func 10/02/09 16:26:44 Robert Treat <robert@omniti.com> [2b8f8c20cf8db128b58a867bceb25006514a662e] * sql/tables/noit.check_tag.sql (modified) * sql/tables/noit.metric_name_summary.sql (modified) * sql/tables/noit.metric_numeric_rollup_queue.sql (modified) * sql/tables/noit.metric_tag.sql (modified) * sql/tables/noit.tasklock.sql (modified) fix up bugs now that it's tested 10/01/09 19:55:31 Denish Patel <denish@omniti.com> [6bf36f96f69a29ee3b0fe2ce43262b4898eabc65] * sql/sprocs/stratcon.metric_name_summary_tsvector.sql (added) stratcon.metric_name_summary_tsvector function 10/01/09 19:12:52 Denish Patel <denish@omniti.com> [efff2d97f875ae97b5b8083173c63b45af7e29df] * sql/sprocs/stratcon.fetch_varset.sql (modified) * sql/sprocs/stratcon.window_robust_derive.sql (added) added stratcon.window_robust_derive 10/01/09 18:52:07 Denish Patel <denish@omniti.com> [176662823c617f275f16583569d617151ef34731] * sql/sprocs/stratcon.fetch_varset.sql (added) fetch varset functions 10/01/09 18:24:01 Denish Patel <denish@omniti.com> [161a5c5dbc37986a5d1c5ce66869d4504f97f0eb] * sql/sprocs/noit.choose_window.sql (deleted) * sql/sprocs/noit.fetch_dataset.sql (deleted) * sql/sprocs/stratcon.choose_window.sql (added) * sql/sprocs/stratcon.fetch_dataset.sql (added) Change schema to stratcon and modified functions to be secturity definer 10/01/09 18:10:47 Denish Patel <denish@omniti.com> [b57ec8315f866c742be1da0a080ee0c836ff02a1] * sql/sprocs/noit.choose_window.sql (added) * sql/sprocs/noit.fetch_dataset.sql (added) noit functions related to fetch data 10/01/09 18:08:18 Robert Treat <robert@omniti.com> [003566b519017539659f61ab68d038cb3218e43b] * sql/sprocs/stratcon.get_storage_node_for_sid.sql (added) * sql/sprocs/stratcon.map_uuid_to_sid.sql (added) give me a uuid and it's noit, i'll give you a sid and which node to put it on 09/30/09 17:14:36 Robert Treat <robert@omniti.com> [3b8a086327fecf81c67436b95e046185bd2dad97] * sql/dblayout.txt (added) what are we up to? 09/30/09 17:08:09 Robert Treat <robert@omniti.com> [30ba483a94e1eaee4fc0b743d7126f60ffb8a908] * sql/tables/stratcon.tasklock.sql (deleted) straggling file rename 09/30/09 17:07:46 Robert Treat <robert@omniti.com> [420b34c7d61262546669125ae17b29becad77298] * sql/tables/noit.tasklock_sequence.sql (added) actually, this should be in noit schema, though we do want to leave it decoupled 09/30/09 17:04:25 Robert Treat <robert@omniti.com> [81f7001e39e1c3484d225b7a609fc803c86ba5ef] * sql/tables/noit.tasklock.sql (added) * sql/tables/stratcon.tasklock.sql (modified) new task locking infrastructure 09/30/09 16:52:30 Robert Treat <robert@omniti.com> [64c35d610d430e39870bc67c35bdf49298ba29f8] * sql/tables/noit.check_changelog.sql (deleted) * sql/tables/noit.metric_numeric_rollup_buffer.sql (deleted) file renames 09/30/09 16:52:12 Robert Treat <robert@omniti.com> [e0b4c4bf93b3aea304cd8cf9e9f7a02f9cc79a88] * sql/tables/noit.metric_numeric_rollup_queue.sql (added) queue for tracking which numeric intervals need to be rolled up 09/30/09 16:44:33 Robert Treat <robert@omniti.com> [392462ca87d64f403a0ac61c95102e6611b362f3] * sql/tables/noit.check_status_archive.sql (modified) status type check table 09/30/09 16:41:15 Robert Treat <robert@omniti.com> [5745519bbdae8e0191e208603505894084660654] * sql/tables/noit.metric_numeric_archive.sql (modified) numeric metrics 09/30/09 16:14:10 Robert Treat <robert@omniti.com> [77e875df87c94f8cd2b8fbc32fbe360623e759b8] * sql/tables/noit.metric_numeric_rollup_12hours.sql (modified) * sql/tables/noit.metric_numeric_rollup_20m.sql (modified) * sql/tables/noit.metric_numeric_rollup_60m.sql (modified) * sql/tables/noit.metric_numeric_rollup_6hours.sql (modified) adding schema for rollup tables, with array based storage 09/29/09 22:22:18 Robert Treat <robert@omniti.com> [88d5aaab122fefd6471e1d4604f54cd1a6df433b] * sql/tables/noit.metric_text_archive.sql (modified) * sql/tables/noit.metric_text_changelog.sql (modified) * sql/tables/noit.metric_text_currently.sql (modified) text metric tables 09/29/09 21:53:51 Robert Treat <robert@omniti.com> [3e3863d0f5b6548f78558042bd6c87f71145a732] * sql/tables/noit.metric_name_summary.sql (modified) metric name summary 09/29/09 21:43:28 Robert Treat <robert@omniti.com> [3278b4e18773a14f0cf214226356adbc065fa9be] * sql/tables/noit.check_tag.sql (modified) * sql/tables/noit.metric_tag.sql (modified) tag tables 09/29/09 20:59:27 Robert Treat <robert@omniti.com> [378ef447b1015a081fe182f16097392fa036a9ce] * sql/tables/noit.check_status_changelog.sql (modified) check status tables 09/29/09 20:53:19 Robert Treat <robert@omniti.com> [ff905e92ad93d8c9a71dcfc0d1825f3667a22c01] * sql/tables/noit.check_archive.sql (modified) fix whoopsies 09/29/09 20:48:20 Robert Treat <robert@omniti.com> [35417f1d20ade67bfbf99b03c861fe1756ee11cd] * sql/tables/noit.check_archive.sql (modified) * sql/tables/noit.check_currently.sql (added) layout of primary check tables 09/29/09 20:22:36 Robert Treat <robert@omniti.com> [4e7af0052829e39e8da8375b559e9be499b247c2] * sql/tables/noit.metric_numeric_rollup_5m.sql (modified) store data in chunks as array values to save storage space 09/29/09 20:12:34 Robert Treat <robert@omniti.com> [a34bc1266a0a4f7fa69f17c5957f160162a4398d] * sql/tables/noit.check_archive.sql (added) * sql/tables/noit.check_changelog.sql (added) * sql/tables/noit.check_status_archive.sql (added) * sql/tables/noit.check_status_changelog.sql (added) * sql/tables/noit.check_tag.sql (added) * sql/tables/noit.metric_name_summary.sql (added) * sql/tables/noit.metric_numeric_archive.sql (added) * sql/tables/noit.metric_numeric_rollup_12hours.sql (added) * sql/tables/noit.metric_numeric_rollup_20m.sql (added) * sql/tables/noit.metric_numeric_rollup_5m.sql (added) * sql/tables/noit.metric_numeric_rollup_60m.sql (added) * sql/tables/noit.metric_numeric_rollup_6hours.sql (added) * sql/tables/noit.metric_numeric_rollup_buffer.sql (added) * sql/tables/noit.metric_tag.sql (added) * sql/tables/noit.metric_text_archive.sql (added) * sql/tables/noit.metric_text_changelog.sql (added) * sql/tables/noit.metric_text_currently.sql (added) * sql/tables/stratcon.current_node_config.sql (added) * sql/tables/stratcon.map_uuid_to_sid.sql (added) * sql/tables/stratcon.storage_node.sql (added) * sql/tables/stratcon.tasklock.sql (added) map table plus placeholders for upcoming schema 07/10/09 00:26:52 Theo Schlossnagle <jesus@omniti.com> [06519e0d896bfca30746212670c342a1b84a74a5] * sql/reconnoiter_ddl_dump.sql (modified) Patch from Dan. fixes #153 06/15/09 23:07:39 Theo Schlossnagle <jesus@omniti.com> [f6540baac0ed25babb2a91d9b715988abb653bcb] * sql/crontab (modified) * sql/dump.sh (added) * sql/reconnoiter_ddl_dump.sql (modified) * src/stratcon.conf.in (modified) * src/stratcon_datastore.c (modified) flag-day(stratcond,database) partition the loading docks, refs #140 06/10/09 17:39:06 Denish Patel <denish@omniti.com> [9d38c6543b77583aaef091ecd0e2903e89067d0b] * sql/reconnoiter_ddl_dump.sql (modified) updated schema ddl 05/20/09 23:49:08 Theo Schlossnagle <jesus@omniti.com> [6adb5a7837cf0e5945ed038897c9b08c7259701c] * sql/README (added) * sql/reconnoiter_ddl_dump.sql (modified) update the schema, remove unnecessary crap 04/09/09 20:55:04 Denish Patel <denish@omniti.com> [a647406d9e447fa4cb7212f74bc63a1fcf52dfea] * sql/reconnoiter_ddl_dump.sql (modified) updated pgdump ddl 03/28/09 02:14:16 Theo Schlossnagle <jesus@omniti.com> [17a8e8e4556d3b18451fd9531ef964be402a98d0] * sql/reconnoiter_ddl_dump.sql (modified) make the counter_dev stuff much more intelligent and accommodating of rolling counters if data is collected 'fast enough'. Fixes #110 03/26/09 21:58:11 Denish Patel <denish@omniti.com> [c3a1f2e12de43c398369bb5a3f902eebde93f9bb] * sql/reconnoiter_ddl_dump.sql (modified) checking in postgres ddl dump 03/21/09 02:07:35 Robert Treat <robert@omniti.com> [e3e35fcfbb73d6001f7b6dca7ff7311e1148ccfb] * sql/reconnoiter_ddl_dump.sql (modified) use gin index for tsvectors 12/03/08 21:32:30 Denish Patel <denish@omniti.com> [9295ab0de02cda482cfd2a5762f8a76727b480d1] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl update 12/03/08 17:37:57 Denish Patel <denish@omniti.com> [ea0809f5e7f454f5e874bca7d79be8e2d6a10789] * sql/crontab (modified) Added job to cleanup prism.saved_graphs table with saved_graphs=false. 11/20/08 23:03:02 Denish Patel <denish@omniti.com> [f67c8f851568c1e75293edbe51cd405f940bab8b] * sql/reconnoiter_ddl_dump.sql (modified) updated saved_graphs before i/u trigger function 11/04/08 20:23:11 Denish Patel <denish@omniti.com> [d4547fc2ca717194bd02bda7276a0efa26d120d0] * sql/reconnoiter_ddl_dump.sql (modified) prism.saved_graphs triggers adjustments 10/16/08 16:17:38 Denish Patel <denish@omniti.com> [be06d4c772959d7f67b61729ed0fcfa446eb59a4] * sql/reconnoiter_ddl_dump.sql (modified) fixed ownership of tables 10/14/08 19:00:42 Denish Patel <denish@omniti.com> [c256764571a55858b9a8db0f8905c297ec481926] * sql/reconnoiter_ddl_dump.sql (modified) updated remove_metric function 10/13/08 21:12:29 Denish Patel <denish@omniti.com> [9e9c974e402a479ebbc927ca69c82166708b2d80] * sql/reconnoiter_ddl_dump.sql (modified) another fix for saved graph serach 10/13/08 18:13:40 Denish Patel <denish@omniti.com> [04c2ba0f9a1814ea044e5060104e73817640055d] * sql/reconnoiter_ddl_dump.sql (modified) Fixed sved graphs trigger 10/07/08 14:29:57 Denish Patel <denish@omniti.com> [848c999201996fa821ee897f8bc9e3c0979a575f] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl export 09/26/08 21:14:54 Denish Patel <denish@omniti.com> [fb7be7b187d801c131a11404d2c489a6fc8350a6] * sql/reconnoiter_ddl_dump.sql (modified) Modified function and trigger for saved_graphs as it was messing up with search results 09/25/08 19:24:59 Denish Patel <denish@omniti.com> [c73b2b53bb74c7e8135888bc652903c9327f7dbd] * sql/reconnoiter_ddl_dump.sql (modified) granted more privs to stratcon user 09/25/08 16:07:48 Denish Patel <denish@omniti.com> [15df64bd213a7a14a521d3d2d4418ee9379272aa] * sql/reconnoiter_ddl_dump.sql (modified) implemented add/remove tags functionality for graphs and created function to update ts_search_all vector based on title and graph_tags, applied trigger to call the function on saved_graphs 09/25/08 01:18:36 Denish Patel <denish@omniti.com> [43ec19ac079e004379a4c8d8117756c8d622eff8] * sql/reconnoiter_ddl_dump.sql (modified) added index 09/24/08 20:45:15 Denish Patel <denish@omniti.com> [75075e2a62f4974e24117f519581ad75b2a083c4] * sql/reconnoiter_ddl_dump.sql (modified) Moved metric_tags from prism schema to stratcon and grant all table to prism, modified all functions,triggers to reflect the changes 09/24/08 19:50:24 Denish Patel <denish@omniti.com> [f3544432ddf95a1f7eabd18d8fa0f355191362eb] * sql/reconnoiter_ddl_dump.sql (modified) Added search and tags functionalities 09/22/08 18:09:27 Denish Patel <denish@omniti.com> [146a7f3bfbf2f113f1cbdba31a2ba3e575d3e2f8] * sql/reconnoiter_ddl_dump.sql (modified) Full database dump 09/22/08 18:00:45 Denish Patel <denish@omniti.com> [9f9d948f5f91f25c6ec5d43a5ddcd1143e30fd45] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl update-- alter schema statrcon owner to reconnoiter 09/22/08 17:57:16 Denish Patel <denish@omniti.com> [70d8a8f096162b8f5ef06f5668066b9e7e942814] * sql/reconnoiter_ddl_dump.sql (modified) pg ddl update 08/26/08 01:25:15 Theo Schlossnagle <jesus@omniti.com> [0a06b2cbef3380c0fa794480d2fae8b4b1431f92] * Makefile.in (modified) * buildtools/install-sh (added) * buildtools/mkinstalldirs (added) * configure.in (modified) * sql/Makefile.in (added) * src/Makefile.in (modified) * src/modules-lua/Makefile.in (added) * src/modules/Makefile.in (modified) refs #50 08/26/08 00:24:40 Theo Schlossnagle <jesus@omniti.com> [60d776d5d65d4ceec7b23dbddb1d8e3893c97571] * sql/schema.sql (deleted) just use reconnoiter_ddl_dump.sql as the master 08/11/08 20:58:43 Denish Patel <denish@omniti.com> [8c44e3b0e275f77a5f98f49c8b0ae180976694e9] * sql/reconnoiter_ddl_dump.sql (modified) dump stratcon schema 08/03/08 19:23:21 Theo Schlossnagle <jesus@omniti.com> [3be398539c4bcd0e77acf4390c6dda1635329b58] * sql/crontab (added) people are gonna need this crontab to see rollups 07/12/08 15:13:51 Theo Schlossnagle <jesus@omniti.com> [356779758e509ee0f1a2f419e9fab1d48fdc3c33] * sql/schema.sql (modified) implement a materialized view on the most recent metric_text change (need speed!) 07/11/08 19:40:02 Denish Patel <denish@omniti.com> [4aae95d137f38b64f49d27c9611b1fba6242666a] * sql/reconnoiter_ddl_dump.sql (modified) updated Reconniter DDL dump 07/11/08 19:35:19 Denish Patel <denish@omniti.com> [47b88b010a032a620acac2e7dff46570fe80d64a] * sql/schema.sql (modified) corrected error warning for stratcon.mv_loading_dock_check_s() 07/10/08 18:34:28 Theo Schlossnagle <jesus@omniti.com> [e94863c5d22e2229730530ce3039661489cbbd73] * sql/schema.sql (modified) make the fetch_ procedures also accept sids 07/10/08 16:49:20 Denish Patel <denish@omniti.com> [adba02c5fdb37a1095d0d170a8cf31937dbedbb0] * sql/schema.sql (modified) added mv_loading_dock_check_s() trigger function and related table/indexes.