Changeset ae288a0fcfbad4b7bab821ef0c57050fe496af45
- Timestamp:
- 10/29/09 14:11:43 (10 months ago)
- Author:
- Stephen Bennett <spb@…>
- Parents:
- b3eedd637e3e8d9433aec7a0da31744086708f5c
- Children:
- 305f73ea3d6c267a66cd29805feb85bbb603e739
- git-committer:
- Stephen Bennett <spb@exherbo.org> / 2009-10-29T14:11:43Z+0000
- Message:
-
Change group type field to an enum instead of an integer
- Files:
-
Legend:
- Unmodified
- Added
- Removed
-
|
rb3eedd6
|
rae288a0
|
|
| 10 | 10 | |
| 11 | 11 | DROP TYPE IF EXISTS group_status; |
| | 12 | DROP TYPE IF EXISTS group_type; |
| | 13 | |
| 12 | 14 | CREATE TYPE group_status AS ENUM ('auto_pending', 'auto_verified', 'manual_pending', 'approved'); |
| | 15 | CREATE TYPE group_type AS ENUM ('informal', 'corporation', 'education', 'government', |
| | 16 | 'nfp', 'internal'); |
| | 17 | |
| 13 | 18 | |
| 14 | 19 | CREATE TABLE accounts ( |
| … |
… |
|
| 39 | 44 | id SERIAL PRIMARY KEY, |
| 40 | 45 | groupname VARCHAR(32) NOT NULL, |
| 41 | | grouptype INTEGER NOT NULL, |
| | 46 | grouptype group_type NOT NULL, |
| 42 | 47 | url VARCHAR(64) NOT NULL, |
| 43 | 48 | address INTEGER DEFAULT NULL, |
