incubator-olio-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ak...@apache.org
Subject svn commit: r805251 - /incubator/olio/webapp/php/trunk/etc/schema.sql
Date Tue, 18 Aug 2009 02:05:52 GMT
Author: akara
Date: Tue Aug 18 02:05:51 2009
New Revision: 805251

URL: http://svn.apache.org/viewvc?rev=805251&view=rev
Log:
Issue OLIO-40: Added userid field to schema. All user images are now referenced by userid
instead of username.

Modified:
    incubator/olio/webapp/php/trunk/etc/schema.sql

Modified: incubator/olio/webapp/php/trunk/etc/schema.sql
URL: http://svn.apache.org/viewvc/incubator/olio/webapp/php/trunk/etc/schema.sql?rev=805251&r1=805250&r2=805251&view=diff
==============================================================================
--- incubator/olio/webapp/php/trunk/etc/schema.sql (original)
+++ incubator/olio/webapp/php/trunk/etc/schema.sql Tue Aug 18 02:05:51 2009
@@ -17,6 +17,7 @@
  * 
  */
 create table PERSON(
+   userid INTEGER NOT NULL AUTO_INCREMENT,
    username VARCHAR(25) NOT NULL,
    password VARCHAR(25) NOT NULL,
    firstname VARCHAR(25) NOT NULL,
@@ -28,9 +29,11 @@
    summary VARCHAR(2500) NOT NULL,
    timezone VARCHAR(25) NOT NULL,
    ADDRESS_addressid INTEGER NOT NULL,
-   primary key (username)
+   primary key (userid)
 ) ENGINE=InnoDB;
 
+CREATE UNIQUE INDEX PERSON_USER_IDX on PERSON (username);
+
 CREATE TABLE PERSON_PERSON (
 Person_username VARCHAR(25) NOT NULL,
 friends_username VARCHAR(25) NOT NULL,



Mime
View raw message