Changeset 2438 for branches/schema06/system/schema/pgsql/schema.sql
- Timestamp:
- 09/04/08 03:47:39 (4 months ago)
- Files:
-
- 1 modified
-
branches/schema06/system/schema/pgsql/schema.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
branches/schema06/system/schema/pgsql/schema.sql
r2409 r2438 279 279 CREATE TABLE {$prefix}permissions ( 280 280 id INTEGER NOT NULL DEFAULT nextval('{$prefix}permissions_pkey_seq'), 281 descriptionVARCHAR(255) NOT NULL,281 name VARCHAR(255) NOT NULL, 282 282 PRIMARY KEY (id) 283 283 ); 284 284 ALTER SEQUENCE {$prefix}permissions_pkey_seq OWNED BY {$prefix}permissions.id; 285 285 286 INSERT INTO {$prefix}permissions ( description) VALUES286 INSERT INTO {$prefix}permissions (name) VALUES 287 287 ('denied'), 288 288 ('read'), 289 289 ('write'), 290 290 ('full'); 291
