Changeset 2438 for branches/schema06/system/schema/sqlite/schema.sql

Timestamp:

09/04/08 03:47:39 (4 months ago)

Author:

bjohnson

Message:

schema06: Initial go at re-writing ACL class to work with new permission schema.

Files:

• branches/schema06/system/schema/sqlite/schema.sql (modified) (1 diff)

branches/schema06/system/schema/sqlite/schema.sql

@@ -228 +228 @@
 CREATE TABLE {$prefix}permissions (
   id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
-  description VARCHAR(255) NOT NULL
-);
-
-INSERT INTO {$prefix}permissions (description) VALUES
+  name VARCHAR(255) NOT NULL
+);
+
+INSERT INTO {$prefix}permissions (name) VALUES
   ('denied');
-INSERT INTO {$prefix}permissions (description) VALUES
+INSERT INTO {$prefix}permissions (name) VALUES
   ('read');
-INSERT INTO {$prefix}permissions (description) VALUES
+INSERT INTO {$prefix}permissions (name) VALUES
   ('write');
-INSERT INTO {$prefix}permissions (description) VALUES
+INSERT INTO {$prefix}permissions (name) VALUES
   ('full');