[wellwell-devel] [SCM] Interchange wellwell catalog branch, master, updated. d68c878e714b223b226f3ffd6bcf971e661f034c

Stefan Hornburg racke at rt.icdevgroup.org
Fri May 29 17:46:51 UTC 2009


This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Interchange wellwell catalog".

The branch, master has been updated
       via  d68c878e714b223b226f3ffd6bcf971e661f034c (commit)
       via  54117f9513262cc077fbb26ea496bb23e0278ffa (commit)
       via  39a004febd4e801c795fe760de3d083038a11590 (commit)
      from  508dd367c7bed8d1ee434863c60965917407d2a9 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit d68c878e714b223b226f3ffd6bcf971e661f034c
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri May 29 19:46:32 2009 +0200

    added created and last_login fields to users table

commit 54117f9513262cc077fbb26ea496bb23e0278ffa
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri May 29 19:45:23 2009 +0200

    get rid of unnecessary double quotes

commit 39a004febd4e801c795fe760de3d083038a11590
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri May 29 19:41:21 2009 +0200

    get rid of unnecessary backticks

-----------------------------------------------------------------------

Summary of changes and diff:
 catalog.cfg              |    2 +-
 database/mysql/users.sql |   14 ++++++++------
 database/pgsql/users.sql |   14 ++++++++------
 3 files changed, 17 insertions(+), 13 deletions(-)

diff --git a/catalog.cfg b/catalog.cfg
index 81b09ca..b311a61 100644
--- a/catalog.cfg
+++ b/catalog.cfg
@@ -66,7 +66,7 @@ UserDB default counter           var/run/userdb.counter
 UserDB default user_field		 uid
 UserDB default time_field		 none
 UserDB default pass_field		 password
-UserDB default scratch           "username email"
+UserDB default scratch           "username email last_login created"
 UserDB default crypt			 0
 
 # Routes and Orders
diff --git a/database/mysql/users.sql b/database/mysql/users.sql
index 87323b4..c56f9d2 100644
--- a/database/mysql/users.sql
+++ b/database/mysql/users.sql
@@ -1,7 +1,9 @@
-CREATE TABLE `users` (
-  `uid` int unsigned auto_increment NOT NULL,
-  `username` varchar(32) NOT NULL,
-  `email` varchar(255) NOT NULL,
-  `password` varchar(255) NOT NULL,
-  PRIMARY KEY (`uid`)
+CREATE TABLE users (
+  uid int unsigned auto_increment NOT NULL,
+  username varchar(32) NOT NULL,
+  email varchar(255) NOT NULL,
+  password varchar(255) NOT NULL,
+  last_login integer NOT NULL DEFAULT 0,
+  created integer NOT NULL DEFAULT 0,
+  PRIMARY KEY (uid)
 );
diff --git a/database/pgsql/users.sql b/database/pgsql/users.sql
index 1071b23..cb69200 100644
--- a/database/pgsql/users.sql
+++ b/database/pgsql/users.sql
@@ -1,7 +1,9 @@
-CREATE TABLE "users" (
-  "uid" serial,
-  "username" varchar(32),
-  "email" varchar(255) NOT NULL DEFAULT '',
-  "password" varchar(255) NOT NULL DEFAULT '',
-  CONSTRAINT users_pkey PRIMARY KEY ("uid")
+CREATE TABLE users (
+  uid serial,
+  username varchar(32) NOT NULL,
+  email varchar(255) NOT NULL DEFAULT '',
+  password varchar(255) NOT NULL DEFAULT '',
+  last_login integer NOT NULL DEFAULT 0,
+  created integer NOT NULL DEFAULT 0,
+  CONSTRAINT users_pkey PRIMARY KEY (uid)
 );


hooks/post-receive
-- 
Interchange wellwell catalog



More information about the wellwell-devel mailing list