summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPreston Cody <codeman@gentoo.org>2006-07-15 04:52:49 +0000
committerPreston Cody <codeman@gentoo.org>2006-07-15 04:52:49 +0000
commit8342e41e616017ee768cfe818328d09d33b6afd7 (patch)
treec74f087b2a80bbb2536423320dd8e182f89085e8
parentjust adding more sample lines. (diff)
downloadscire-8342e41e616017ee768cfe818328d09d33b6afd7.tar.gz
scire-8342e41e616017ee768cfe818328d09d33b6afd7.tar.bz2
scire-8342e41e616017ee768cfe818328d09d33b6afd7.zip
adding in the permcategory line.
svn path=/; revision=125
-rw-r--r--docs/scire.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/docs/scire.sql b/docs/scire.sql
index a3065fb..9e9fb19 100644
--- a/docs/scire.sql
+++ b/docs/scire.sql
@@ -40,7 +40,9 @@ CREATE TABLE permissions (
permid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(128) NOT NULL UNIQUE,
description VARCHAR(255),
+ permcategory VARCHAR(128) NOT NULL DEFAULT 'Default',
creator INT NOT NULL,
+ created TIMESTAMP NOT NULL DEFAULT NOW(),
FOREIGN KEY (creator) REFERENCES users.userid
) ENGINE = MyISAM;