Changeset c2dc38225cd07f2a35ccc35dd0a2a5d5e1b0929e
- Timestamp:
- 11/08/09 19:34:30
(4 years ago)
- Author:
- Theo Schlossnagle <jesus@omniti.com>
- git-committer:
- Theo Schlossnagle <jesus@omniti.com> 1257708870 +0000
- git-parent:
[5bb306cd48a5523c1719766ad6cd61624f997929]
- git-author:
- Theo Schlossnagle <jesus@omniti.com> 1257708870 +0000
- Message:
add a sequence for the peeps
-
Files:
-
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
| r16e27d8 |
rc2dc382 |
|
| 18 | 18 | -- Name: event_criteria; Type: TABLE; Schema: stratcon; Owner: reconnoiter; |
|---|
| 19 | 19 | -- |
|---|
| | 20 | |
|---|
| | 21 | CREATE SEQUENCE event_criteria_id_seq |
|---|
| | 22 | INCREMENT BY 1 |
|---|
| | 23 | NO MAXVALUE |
|---|
| | 24 | NO MINVALUE |
|---|
| | 25 | CACHE 1; |
|---|
| | 26 | |
|---|
| | 27 | ALTER TABLE event_criteria_id_seq OWNER TO reconnoiter; |
|---|
| | 28 | REVOKE ALL ON SEQUENCE event_criteria_id_seq FROM PUBLIC; |
|---|
| | 29 | REVOKE ALL ON SEQUENCE event_criteria_id_seq FROM reconnoiter; |
|---|
| | 30 | GRANT ALL ON SEQUENCE event_criteria_id_seq TO reconnoiter; |
|---|
| | 31 | GRANT SELECT,UPDATE ON SEQUENCE event_criteria_id_seq TO stratcon; |
|---|
| 20 | 32 | |
|---|
| 21 | 33 | CREATE TABLE event_criteria_numeric ( |
|---|
