[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