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

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

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

Log Message:
-----------
Updated to have the proper syntax & to avoid duplication of key & table creation.

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:34:54 UTC (rev 134)
+++ trunk/0.3/setup/schema.mysql.sql	2009-08-24 15:53:15 UTC (rev 135)
@@ -111,28 +111,12 @@
 
 -- --------------------------------------------------------
 
--- 
--- Table structure for table `cswal_log_table`
--- 
 
-CREATE TABLE `cswal_log_table` (
-  `log_id` int(11) NOT NULL auto_increment,
-  `creation` timestamp NOT NULL default CURRENT_TIMESTAMP,
-  `event_id` int(11) NOT NULL,
-  `uid` int(11) NOT NULL,
-  `affected_uid` int(11) NOT NULL,
-  `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 ;
 
-
-
 -- 
 -- Constraints for table `cswal_log_attribute_table`
 -- 
 ALTER TABLE `cswal_log_attribute_table`
-  ADD CONSTRAINT `cswal_log_attribute_table_attribute_id_fkey` FOREIGN KEY (`attribute_id`) REFERENCES `cswal_attribute_table` (`attribute_id`),
   ADD CONSTRAINT `cswal_log_attribute_table_log_id_fkey` FOREIGN KEY (`log_id`) REFERENCES `cswal_log_table` (`log_id`);
 
 


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