Posted by Zed Pobre on January 16, 2005 at 8:58am
| Project: | Feature |
| Version: | 4.5.x-1.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs review |
Issue Summary
Here's a feature.pgsql file:
CREATE TABLE feature (
fid serial PRIMARY KEY,
name varchar(255) NOT NULL default '',
details varchar(255) NOT NULL default '',
image varchar(255) NOT NULL default '',
description text
);
ALTER TABLE feature ADD category numeric(2,0);
ALTER TABLE feature ALTER category SET NOT NULL;
ALTER TABLE feature ALTER category SET DEFAULT '0';