[Sciret-svn] SF.net SVN: sciret: [607] branches/release-candidates/sciret-1.2/setup

[<al...@us...>]

Revision: 607
          http://sciret.svn.sourceforge.net/sciret/?rev=607&view=rev
Author:   alpeb
Date:     2008-07-09 14:43:26 -0700 (Wed, 09 Jul 2008)

Log Message:
-----------
changed table primary key to 'id'

Modified Paths:
--------------
    branches/release-candidates/sciret-1.2/setup/final.sql

Added Paths:
-----------
    branches/release-candidates/sciret-1.2/setup/upgrade_1.3.0.sql

Modified: branches/release-candidates/sciret-1.2/setup/final.sql
===================================================================
--- branches/release-candidates/sciret-1.2/setup/final.sql	2008-07-08 03:37:30 UTC (rev 606)
+++ branches/release-candidates/sciret-1.2/setup/final.sql	2008-07-09 21:43:26 UTC (rev 607)
@@ -148,7 +148,7 @@
 ) ENGINE = MYISAM ;
 
 CREATE TABLE `users` (
-  `user_id` int(11) NOT NULL auto_increment,
+  `id` int(11) NOT NULL auto_increment,
   `firstname` varchar(50) NOT NULL default '',
   `lastname` varchar(50) NOT NULL default '',
   `username` varchar(50) NOT NULL default '',
@@ -157,10 +157,10 @@
   `password_changed` date NOT NULL,
   `admin` tinyint(4) NOT NULL default '0',
   `preferences` text NOT NULL,
-  PRIMARY KEY  (`user_id`)
+  PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
-INSERT INTO `users` (`user_id`, `firstname`, `lastname`, `username`, `email`, `password`, `password_changed`, `admin`, `preferences`) VALUES (1, 'Admin', 'User', 'admin', '', '21232f297a57a5a743894a0e4a801fc3', NOW(), 1, 'a:4:{s:15:"articlesPerPage";s:2:"10";s:10:"dateFormat";s:15:"Month Day, Year";s:8:"language";s:7:"English";s:14:"navigationType";s:13:"catAndSubCats";}');
+INSERT INTO `users` (`id`, `firstname`, `lastname`, `username`, `email`, `password`, `password_changed`, `admin`, `preferences`) VALUES (1, 'Admin', 'User', 'admin', '', '21232f297a57a5a743894a0e4a801fc3', NOW(), 1, 'a:4:{s:15:"articlesPerPage";s:2:"10";s:10:"dateFormat";s:15:"Month Day, Year";s:8:"language";s:7:"English";s:14:"navigationType";s:13:"catAndSubCats";}');
 
 CREATE TABLE `language_cache` (
     `language` VARCHAR( 50 ) NOT NULL ,

Added: branches/release-candidates/sciret-1.2/setup/upgrade_1.3.0.sql
===================================================================
--- branches/release-candidates/sciret-1.2/setup/upgrade_1.3.0.sql	                        (rev 0)
+++ branches/release-candidates/sciret-1.2/setup/upgrade_1.3.0.sql	2008-07-09 21:43:26 UTC (rev 607)
@@ -0,0 +1 @@
+ALTER TABLE `users` CHANGE `user_id` `id` INT( 11 ) NOT NULL AUTO_INCREMENT;


Property changes on: branches/release-candidates/sciret-1.2/setup/upgrade_1.3.0.sql
___________________________________________________________________
Name: svn:executable
   + *


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