diff options
| author | Evgeny Khramtsov <xramtsov@gmail.com> | 2015-05-20 13:46:02 +0300 |
|---|---|---|
| committer | Evgeny Khramtsov <xramtsov@gmail.com> | 2015-05-20 13:46:02 +0300 |
| commit | da68b9a572f99cd05208ffbbc7643e9eac922483 (patch) | |
| tree | f9e6ce55e3934f363205904a2574bde503389138 /sql | |
| parent | Fix function specification (diff) | |
| parent | pg - added sm table (diff) | |
Merge pull request #570 from sezuan/fix_added_sm_table_to_pg
added sm table to pg.sql
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/pg.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/pg.sql b/sql/pg.sql index 8412c3c6b..966614f48 100644 --- a/sql/pg.sql +++ b/sql/pg.sql @@ -288,3 +288,18 @@ CREATE TABLE caps_features ( ); CREATE INDEX i_caps_features_node_subnode ON caps_features USING btree (node, subnode); + +CREATE TABLE sm ( + usec bigint NOT NULL, + pid text NOT NULL, + node text NOT NULL, + username text NOT NULL, + resource text NOT NULL, + priority text NOT NULL, + info text NOT NULL +); + +CREATE UNIQUE INDEX i_sid ON sm USING btree (usec, pid); +CREATE INDEX i_node ON sm USING btree (node); +CREATE INDEX i_username ON sm USING btree (username); + |