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

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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

Log Message:
-----------
Updated schema via an SQL dump (via PHPMyAdmin) after successfully loading schema.

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 15:53:15 UTC (rev 135)
+++ trunk/0.3/setup/schema.mysql.sql	2009-08-24 15:55:55 UTC (rev 136)
@@ -12,7 +12,7 @@
 -- version 2.10.3
 -- http://www.phpmyadmin.net
 -- 
--- Generation Time: Aug 10, 2009 at 11:01 AM
+-- Generation Time: Aug 24, 2009 at 10:55 AM
 -- Server version: 5.0.22
 -- PHP Version: 5.1.6
 
@@ -22,6 +22,26 @@
 -- --------------------------------------------------------
 
 -- 
+-- Table structure for table `cswal_auth_token_table`
+-- 
+
+CREATE TABLE `cswal_auth_token_table` (
+  `auth_token_id` bigint(20) unsigned NOT NULL auto_increment,
+  `uid` int(11) NOT NULL default '0',
+  `checksum` text NOT NULL,
+  `token` text NOT NULL,
+  `max_uses` int(11) default NULL,
+  `total_uses` int(11) NOT NULL default '0',
+  `creation` timestamp NOT NULL default CURRENT_TIMESTAMP,
+  `last_updated` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `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;
+
+-- --------------------------------------------------------
+
+-- 
 -- Table structure for table `cswal_category_table`
 -- 
 
@@ -29,7 +49,7 @@
   `category_id` int(11) NOT NULL auto_increment,
   `category_name` text NOT NULL,
   PRIMARY KEY  (`category_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
@@ -41,7 +61,7 @@
   `class_id` int(11) NOT NULL auto_increment,
   `class_name` text NOT NULL,
   PRIMARY KEY  (`class_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
@@ -57,11 +77,27 @@
   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 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
 -- --------------------------------------------------------
 
 -- 
+-- Table structure for table `cswal_log_attribute_table`
+-- 
+
+CREATE TABLE `cswal_log_attribute_table` (
+  `log_attribute_id` int(11) NOT NULL auto_increment,
+  `log_id` int(11) NOT NULL,
+  `attribute_id` int(11) NOT NULL,
+  `value_text` text NOT NULL,
+  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;
+
+-- --------------------------------------------------------
+
+-- 
 -- Table structure for table `cswal_log_table`
 -- 
 
@@ -74,89 +110,57 @@
   `details` text NOT NULL,
   PRIMARY KEY  (`log_id`),
   KEY `cswal_log_table_event_id_fkey` (`event_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
+-- --------------------------------------------------------
+
 -- 
--- Constraints for dumped tables
+-- Table structure for table `cswal_session_store_table`
 -- 
 
+CREATE TABLE `cswal_session_store_table` (
+  `session_store_id` int(11) NOT NULL auto_increment,
+  `session_id` varchar(32) NOT NULL,
+  `user_id` varchar(16) NOT NULL,
+  `date_created` datetime NOT NULL,
+  `last_updated` datetime NOT NULL,
+  `session_data` longtext NOT NULL,
+  PRIMARY KEY  (`session_store_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
 -- 
--- Constraints for table `cswal_event_table`
+-- Table structure for table `cswal_version_table`
 -- 
-ALTER TABLE `cswal_event_table`
-  ADD CONSTRAINT `cswal_event_table_class_id_fkey` FOREIGN KEY (`class_id`) REFERENCES `cswal_class_table` (`class_id`),
-  ADD CONSTRAINT `cswal_event_table_category_id_fkey` FOREIGN KEY (`category_id`) REFERENCES `cswal_category_table` (`category_id`);
 
+CREATE TABLE `cswal_version_table` (
+  `version_id` int(11) NOT NULL,
+  `project_name` varchar(30) NOT NULL,
+  `version_string` varchar(50) NOT NULL,
+  PRIMARY KEY  (`version_id`),
+  UNIQUE KEY `project_name` (`project_name`)
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
 -- 
--- Constraints for table `cswal_log_table`
+-- Constraints for dumped tables
 -- 
-ALTER TABLE `cswal_log_table`
-  ADD CONSTRAINT `cswal_log_table_event_id_fkey` FOREIGN KEY (`event_id`) REFERENCES `cswal_event_table` (`event_id`);
 
-
-
 -- 
--- Table structure for table `cswal_log_attribute_table`
+-- Constraints for table `cswal_event_table`
 -- 
+ALTER TABLE `cswal_event_table`
+  ADD CONSTRAINT `cswal_event_table_class_id_fkey` FOREIGN KEY (`class_id`) REFERENCES `cswal_class_table` (`class_id`),
+  ADD CONSTRAINT `cswal_event_table_category_id_fkey` FOREIGN KEY (`category_id`) REFERENCES `cswal_category_table` (`category_id`);
 
-CREATE TABLE `cswal_log_attribute_table` (
-  `log_attribute_id` int(11) NOT NULL auto_increment,
-  `log_id` int(11) NOT NULL,
-  `attribute_id` int(11) NOT NULL,
-  `value_text` text NOT NULL,
-  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 AUTO_INCREMENT=1 ;
-
--- --------------------------------------------------------
-
-
-
 -- 
 -- Constraints for table `cswal_log_attribute_table`
 -- 
 ALTER TABLE `cswal_log_attribute_table`
   ADD CONSTRAINT `cswal_log_attribute_table_log_id_fkey` FOREIGN KEY (`log_id`) REFERENCES `cswal_log_table` (`log_id`);
 
-
-  
-  
--- This table create statement MUST work in PostgreSQL v8.2.x+ AND MySQL v5.0.x+: 
--- otherwise separate schema files have to be created and the code will have to 
--- do extra checking...
 -- 
-CREATE TABLE cswal_version_table (
-	version_id int NOT NULL PRIMARY KEY,
-	project_name varchar(30) NOT NULL UNIQUE,
-	version_string varchar(50) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-
-CREATE TABLE cswal_auth_token_table (
-	auth_token_id serial NOT NULL PRIMARY KEY,
-	uid integer NOT NULL DEFAULT 0,
-	checksum text NOT NULL,
-	token text NOT NULL,
-	max_uses integer DEFAULT NULL,
-	total_uses integer NOT NULL DEFAULT 0,
-	creation timestamp NOT NULL DEFAULT NOW(),
-	last_updated timestamp,
-	expiration timestamp NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-
-
-
---
--- Store session data in here.
--- Idea originally from: http://www.developertutorials.com/tutorials/php/saving-php-session-data-database-050711
---
-
-CREATE TABLE `cswal_session_store_table` (
-  `session_store_id` int  NOT NULL AUTO_INCREMENT,
-  `session_id` varchar(32)  NOT NULL,
-  `user_id` varchar(16)  NOT NULL,
-  `date_created` datetime  NOT NULL,
-  `last_updated` datetime  NOT NULL,
-  `session_data` LONGTEXT  NOT NULL,
-  PRIMARY KEY (`session_store_id`)
-) ENGINE = InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
\ No newline at end of file
+-- Constraints for table `cswal_log_table`
+-- 
+ALTER TABLE `cswal_log_table`
+  ADD CONSTRAINT `cswal_log_table_event_id_fkey` FOREIGN KEY (`event_id`) REFERENCES `cswal_event_table` (`event_id`);


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


