[Cs-webapplibs-commits] SF.net SVN: cs-webapplibs:[138] trunk/0.3/setup/schema.mysql.sql

[<cra...@us...>]

Revision: 138
          http://cs-webapplibs.svn.sourceforge.net/cs-webapplibs/?rev=138&view=rev
Author:   crazedsanity
Date:     2009-08-24 16:25:59 +0000 (Mon, 24 Aug 2009)

Log Message:
-----------
Added cswal_attribute_table definition.

Modified Paths:
--------------
    trunk/0.3/setup/schema.mysql.sql

Modified: trunk/0.3/setup/schema.mysql.sql
===================================================================
--- trunk/0.3/setup/schema.mysql.sql	2009-08-24 16:05:54 UTC (rev 137)
+++ trunk/0.3/setup/schema.mysql.sql	2009-08-24 16:25:59 UTC (rev 138)
@@ -1,18 +1,8 @@
---
--- SVN INFORMATION:::
--- ---------------
---	SVN Signature::::::: $Id$
---	Last Author::::::::: $Author$
---	Current Revision:::: $Revision$
---	Repository Location: $HeadURL$
---	Last Updated:::::::: $Date$
---
-
 -- phpMyAdmin SQL Dump
 -- version 2.10.3
 -- http://www.phpmyadmin.net
 -- 
--- Generation Time: Aug 24, 2009 at 10:55 AM
+-- Generation Time: Aug 24, 2009 at 11:31 AM
 -- Server version: 5.0.22
 -- PHP Version: 5.1.6
 
@@ -22,6 +12,18 @@
 -- --------------------------------------------------------
 
 -- 
+-- Table structure for table `cswal_attribute_table`
+-- 
+
+CREATE TABLE `cswal_attribute_table` (
+  `attribute_id` int(11) NOT NULL auto_increment,
+  `attribute_name` text NOT NULL,
+  PRIMARY KEY  (`attribute_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+-- 
 -- Table structure for table `cswal_auth_token_table`
 -- 
 
@@ -37,7 +39,7 @@
   `expiration` timestamp NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`auth_token_id`),
   UNIQUE KEY `auth_token_id` (`auth_token_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
@@ -49,7 +51,7 @@
   `category_id` int(11) NOT NULL auto_increment,
   `category_name` text NOT NULL,
   PRIMARY KEY  (`category_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
@@ -61,7 +63,7 @@
   `class_id` int(11) NOT NULL auto_increment,
   `class_name` text NOT NULL,
   PRIMARY KEY  (`class_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
@@ -77,7 +79,7 @@
   PRIMARY KEY  (`event_id`),
   KEY `cswal_event_table_class_id_fkey` (`class_id`),
   KEY `cswal_event_table_category_id_fkey` (`category_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
@@ -93,7 +95,7 @@
   PRIMARY KEY  (`log_attribute_id`),
   KEY `cswal_log_attribute_table_log_id_fkey` (`log_id`),
   KEY `cswal_log_attribute_table_attribute_id_fkey` (`attribute_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
@@ -110,7 +112,7 @@
   `details` text NOT NULL,
   PRIMARY KEY  (`log_id`),
   KEY `cswal_log_table_event_id_fkey` (`event_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
@@ -126,7 +128,7 @@
   `last_updated` datetime NOT NULL,
   `session_data` longtext NOT NULL,
   PRIMARY KEY  (`session_store_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
 
@@ -140,7 +142,7 @@
   `version_string` varchar(50) NOT NULL,
   PRIMARY KEY  (`version_id`),
   UNIQUE KEY `project_name` (`project_name`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- 
 -- Constraints for dumped tables


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.