root/sql


Mode:

Legend:

Added
Modified
Copied or renamed
Rev Chgset Date Author Log Message
(edit) @9f9d948f5f91f25c6ec5d43a5ddcd1143e30fd45 [9f9d948f5f91f25c6ec5d43a5ddcd1143e30fd45] 09/22/08 18:00:45 Denish Patel <denish@omniti.com> pg ddl update-- alter schema statrcon owner to reconnoiter
(edit) @70d8a8f096162b8f5ef06f5668066b9e7e942814 [70d8a8f096162b8f5ef06f5668066b9e7e942814] 09/22/08 17:57:16 Denish Patel <denish@omniti.com> pg ddl update
(edit) @0a06b2cbef3380c0fa794480d2fae8b4b1431f92 [0a06b2cbef3380c0fa794480d2fae8b4b1431f92] 08/26/08 01:25:15 Theo Schlossnagle <jesus@omniti.com> refs #50
(edit) @60d776d5d65d4ceec7b23dbddb1d8e3893c97571 [60d776d5d65d4ceec7b23dbddb1d8e3893c97571] 08/26/08 00:24:40 Theo Schlossnagle <jesus@omniti.com> just use reconnoiter_ddl_dump.sql as the master
(edit) @8c44e3b0e275f77a5f98f49c8b0ae180976694e9 [8c44e3b0e275f77a5f98f49c8b0ae180976694e9] 08/11/08 20:58:43 Denish Patel <denish@omniti.com> dump stratcon schema
(edit) @3be398539c4bcd0e77acf4390c6dda1635329b58 [3be398539c4bcd0e77acf4390c6dda1635329b58] 08/03/08 19:23:21 Theo Schlossnagle <jesus@omniti.com> people are gonna need this crontab to see rollups
(edit) @356779758e509ee0f1a2f419e9fab1d48fdc3c33 [356779758e509ee0f1a2f419e9fab1d48fdc3c33] 07/12/08 15:13:51 Theo Schlossnagle <jesus@omniti.com> implement a materialized view on the most recent metric_text change (need …
(edit) @4aae95d137f38b64f49d27c9611b1fba6242666a [4aae95d137f38b64f49d27c9611b1fba6242666a] 07/11/08 19:40:02 Denish Patel <denish@omniti.com> updated Reconniter DDL dump
(edit) @47b88b010a032a620acac2e7dff46570fe80d64a [47b88b010a032a620acac2e7dff46570fe80d64a] 07/11/08 19:35:19 Denish Patel <denish@omniti.com> corrected error warning for stratcon.mv_loading_dock_check_s()
(edit) @e94863c5d22e2229730530ce3039661489cbbd73 [e94863c5d22e2229730530ce3039661489cbbd73] 07/10/08 18:34:28 Theo Schlossnagle <jesus@omniti.com> make the fetch_ procedures also accept sids
(edit) @adba02c5fdb37a1095d0d170a8cf31937dbedbb0 [adba02c5fdb37a1095d0d170a8cf31937dbedbb0] 07/10/08 16:49:20 Denish Patel <denish@omniti.com> added mv_loading_dock_check_s() trigger function and related …
(edit) @ee3bbe783b5e3fcbb1febb6a523e12550d04d90d [ee3bbe783b5e3fcbb1febb6a523e12550d04d90d] 07/10/08 02:51:36 Theo Schlossnagle <jesus@omniti.com> fix bug in update config and revert the out-of-order text metric support …
(edit) @5366a70920df98ecf37fed906dfe718d250c4ec1 [5366a70920df98ecf37fed906dfe718d250c4ec1] 07/02/08 18:29:43 Denish Patel <denish@omniti.com> Exported Latest DDL dump
(edit) @e0795d09a594dd276dd59643a85230388401fb06 [e0795d09a594dd276dd59643a85230388401fb06] 07/01/08 14:14:22 Theo Schlossnagle <jesus@omniti.com> fix up insert function for config info, refs #26
(edit) @7710784460d9831062155d3e99f3bf22e4d978b0 [7710784460d9831062155d3e99f3bf22e4d978b0] 06/30/08 19:32:15 Denish Patel <denish@omniti.com> added node configuration tables and trigger.
(edit) @6b9f38ffb400becb8ab312d34abd2981bca9fe87 [6b9f38ffb400becb8ab312d34abd2981bca9fe87] 06/16/08 19:16:10 Denish Patel <denish@omniti.com> remove min/max values from rollup tables/functions.
(edit) @601c99b9ea251da8e30fe85e055c372a540491ee [601c99b9ea251da8e30fe85e055c372a540491ee] 06/06/08 20:42:16 Denish Patel <denish@omniti.com> Exception handling UNIQUE_VIOLATION in log_whence_change_log function.
(edit) @d95460a5334988d9e1dc8c94c3eefbaf222c2d48 [d95460a5334988d9e1dc8c94c3eefbaf222c2d48] 06/06/08 17:57:15 Denish Patel <denish@omniti.com> exception handing on stratcon.loading_dock_metric_numeric_s_whence_log
(edit) @23df8e9f199cb077a586490d9d495708b62bd93e [23df8e9f199cb077a586490d9d495708b62bd93e] 06/01/08 02:38:47 Theo Schlossnagle <jesus@omniti.com> fix PK
(edit) @6390014a64eb9ab5483bc88e66779b6c0ef7a20d [6390014a64eb9ab5483bc88e66779b6c0ef7a20d] 05/30/08 20:42:07 Denish Patel <denish@omniti.com> Added DDL dump for reconnointer database
(edit) @99564b3a9f761d3fb72e07eaa38809b4ff64c558 [99564b3a9f761d3fb72e07eaa38809b4ff64c558] 05/30/08 20:33:26 Denish Patel <denish@omniti.com> Updated Text change log trigger function to log older data changes too.
(edit) @6ea1dad6f00d20ef52591c282ffc9b1e002d5420 [6ea1dad6f00d20ef52591c282ffc9b1e002d5420] 05/24/08 00:33:16 Theo Schlossnagle <jesus@omniti.com> Oops.. This caused every line in loading_dock_status_s to be considered as …
(edit) @197579c398b7365b2eea60f9b2245fdf72ada185 [197579c398b7365b2eea60f9b2245fdf72ada185] 05/22/08 21:11:14 Denish Patel <denish@omniti.com> Grants.
(edit) @809b898d87dcc7153a3360ebb67c91113854f9a7 [809b898d87dcc7153a3360ebb67c91113854f9a7] 05/22/08 21:08:22 Denish Patel <denish@omniti.com> Added Remove_mtric function;
(edit) @3b875de14155ab34c26bdae600fc2827218f85f2 [3b875de14155ab34c26bdae600fc2827218f85f2] 05/21/08 20:41:30 Denish Patel <denish@omniti.com> better handling NOTICE for running job.
(edit) @a2c8a40a569ad8bc6677c21303849d5844ce5436 [a2c8a40a569ad8bc6677c21303849d5844ce5436] 05/21/08 20:25:37 Denish Patel <denish@omniti.com> Updated roll ups functions to process all available records from …
(edit) @b927b3bbf9eeab57dc26e56d2eddfea8cc199a49 [b927b3bbf9eeab57dc26e56d2eddfea8cc199a49] 05/14/08 20:34:00 Denish Patel <denish@omniti.com> updated sequence ddl to start with 1.
(edit) @a7da22e2c7fcc5e15bb1a4e4ab695d6a0c560b43 [a7da22e2c7fcc5e15bb1a4e4ab695d6a0c560b43] 05/14/08 20:10:38 Denish Patel <denish@omniti.com> Added date_trunc('hour',rollup_time) index on 20m rollup tables so we can …
(edit) @be8707fb024addfa6eb855a9d160e6f2b5afec3f [be8707fb024addfa6eb855a9d160e6f2b5afec3f] 05/14/08 18:45:06 Denish Patel <denish@omniti.com> Replace TIMESTAMP with TIMESTAMPTZ.
(edit) @152d473243c4c0e838439fd654a698515e8288fc [152d473243c4c0e838439fd654a698515e8288fc] 05/14/08 15:31:43 Denish Patel <denish@omniti.com> stddev_value removed.
(edit) @5de3ee066898c7932e978dbe8224ca4e280635cb [5de3ee066898c7932e978dbe8224ca4e280635cb] 05/14/08 00:54:13 Theo Schlossnagle <jesus@omniti.com> fix the triggers.. the row itself is called nam, the summary is …
(edit) @143a7f5401614fa0dcc032e7a584d559ac74def5 [143a7f5401614fa0dcc032e7a584d559ac74def5] 05/13/08 21:53:09 Denish Patel <denish@omniti.com> updated 6 hours and 12 hours roll up functions and modify column name for …
(edit) @c1fcb76822fc1aa6b47a9999834cab6c2abeba47 [c1fcb76822fc1aa6b47a9999834cab6c2abeba47] 05/12/08 16:10:25 Denish Patel <denish@omniti.com> Added metric_name_summary table and updated functions to insert rows to …
(edit) @87e2e42dc13b0cfe0cfafcbc70430174c89a04a1 [87e2e42dc13b0cfe0cfafcbc70430174c89a04a1] 05/12/08 15:05:32 Denish Patel <denish@omniti.com> fixed 20m rollup function and table.
(edit) @69db8eb9c49a9d2c4427e7001aa0baa803248de8 [69db8eb9c49a9d2c4427e7001aa0baa803248de8] 05/09/08 21:25:50 Denish Patel <denish@omniti.com> Created trigger on stratcon.loading_dock_status_s to log the entry if …
(edit) @9c824156bbb942b0da737b077c77025f0b56c67d [9c824156bbb942b0da737b077c77025f0b56c67d] 05/09/08 20:53:07 Denish Patel <denish@omniti.com> fix 20 minutes rollup function.
(edit) @3b5d1e9688429ed8e55ebcc0a750dda9a2fe54b4 [3b5d1e9688429ed8e55ebcc0a750dda9a2fe54b4] 05/09/08 20:39:46 Denish Patel <denish@omniti.com> Updated whence column to timestamp instead of timestaptz. updated …
(edit) @7e71217def419c242b081547a970d47a5bf3f20d [7e71217def419c242b081547a970d47a5bf3f20d] 05/09/08 18:03:15 Theo Schlossnagle <jesus@omniti.com> windowed retrieval functions
(edit) @d67a38b6a56900457dc690b2dd62cbd081dca6aa [d67a38b6a56900457dc690b2dd62cbd081dca6aa] 04/16/08 21:05:40 Denish Patel <denish@omniti.com> modified rollup_time6/12 colums to rollup_time and changed functions …
(edit) @8894bdadccd8a4c542f45deafdd40965f568cd81 [8894bdadccd8a4c542f45deafdd40965f568cd81] 04/02/08 19:28:43 Denish Patel <denish@omniti.com> updated functions for rollups
(edit) @ee0d0b765f3a51e1790b26901b54a3c6ac408722 [ee0d0b765f3a51e1790b26901b54a3c6ac408722] 03/28/08 19:38:56 Denish Patel <denish@omniti.com> Final 5 minutes and 1 hour rollup functions
(edit) @5eaa1785247692fe06e4dffe28ec8abdf751865a [5eaa1785247692fe06e4dffe28ec8abdf751865a] 03/28/08 19:12:13 Denish Patel <denish@omniti.com> Final 5 minutes and 1 hour rollup functions
(edit) @3a1a63f5dd675d5b58def4ed6e2727db597f31b5 [3a1a63f5dd675d5b58def4ed6e2727db597f31b5] 03/27/08 20:51:08 Denish Patel <denish@omniti.com> updated functions and removed odd for rollups
(edit) @0dbb5eb9b2c9f102370e5d34d527dde28d3588d4 [0dbb5eb9b2c9f102370e5d34d527dde28d3588d4] 03/27/08 20:05:16 Denish Patel <denish@omniti.com> updated functions for rollups
(edit) @03c905446907610b20f89a64a0d2810d134e52ec [03c905446907610b20f89a64a0d2810d134e52ec] 03/26/08 22:02:44 Denish Patel <denish@omniti.com> updated functions for rollups
(edit) @b9b5a612dc45fbaf19be9da90d69d61dc0491e1e [b9b5a612dc45fbaf19be9da90d69d61dc0491e1e] 03/21/08 19:56:26 Denish Patel <denish@omniti.com> Updated Schema Sql
(edit) @7de429d08625671e3471252391c6ef0bc9c5cf82 [7de429d08625671e3471252391c6ef0bc9c5cf82] 03/06/08 04:55:25 Theo Schlossnagle <jesus@omniti.com> loading schema
Note: See TracRevisionLog for help on using the revision log.