Changeset 260 for veekun/trunk/script/base.sql

Timestamp:

07/18/07 19:47:24 (3 years ago)

Author:

latiass

Message:

Was told to commit what I have so far. This is the beginning of forum flags and user permissions. (#37) Hopefully I didn't forget anything.

Files:

• veekun/trunk/script/base.sql (modified) (1 diff)

veekun/trunk/script/base.sql

@@ -180 +180 @@
   KEY groupid (groupid)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
+--
+-- Table structure for table `userpermissions`
+--
+
+DROP TABLE IF EXISTS userpermissions;
+CREATE TABLE userpermissions (
+  userid int(10) NOT NULL,
+  permission varchar(64) NOT NULL default '',
+  scope varchar(64) NOT NULL default '',
+  polarity enum('allow','deny') default NULL,
+  PRIMARY KEY  (userid,permission,scope)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 --