svn commit: r738518 - /incubator/vcl/trunk/mysql/vcl.sql

[jf...@apache.org]

Author: jfthomps
Date: Wed Jan 28 15:53:53 2009
New Revision: 738518

URL: http://svn.apache.org/viewvc?rev=738518&view=rev
Log:
VCL-69

added shibname and shibonly to affiliation table

added shibauth table

Modified:
    incubator/vcl/trunk/mysql/vcl.sql

Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=738518&r1=738517&r2=738518&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Wed Jan 28 15:53:53 2009
@@ -52,9 +52,11 @@
 CREATE TABLE IF NOT EXISTS `affiliation` (
   `id` mediumint(8) unsigned NOT NULL auto_increment,
   `name` varchar(40) NOT NULL,
+  `shibname` varchar(60) default NULL,
   `dataUpdateText` text NOT NULL,
   `sitewwwaddress` varchar(56) default NULL,
   `helpaddress` varchar(32) default NULL,
+  `shibonly` tinyint(1) unsigned NOT NULL default '0',
   PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
 
@@ -820,6 +822,21 @@
 -- --------------------------------------------------------
 
 -- 
+-- Table structure for table `shibauth`
+--
+
+CREATE TABLE IF NOT EXISTS `shibauth` (
+  `id` mediumint(8) unsigned NOT NULL auto_increment,
+  `userid` mediumint(8) unsigned NOT NULL,
+  `ts` datetime NOT NULL,
+  `sessid` varchar(80) NOT NULL,
+  `data` text NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `state`
 --