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.
|
