From 8342e41e616017ee768cfe818328d09d33b6afd7 Mon Sep 17 00:00:00 2001 From: Preston Cody Date: Sat, 15 Jul 2006 04:52:49 +0000 Subject: adding in the permcategory line. svn path=/; revision=125 --- docs/scire.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'docs') 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; -- cgit v1.2.3-65-gdbad