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

[Stefan Hornburg]

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  4ee68f65ac4e251b351376170a70c7614994de9b (commit)
      from  83740f62d0e35fcdfecaa072b379c1c5504f3d88 (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 4ee68f65ac4e251b351376170a70c7614994de9b
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Thu Feb 5 23:59:29 2009 +0100

    clean up, add uri column

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

Summary of changes and diff:
 plugins/content/database/mysql/content.sql |   23 ++++++++++++-----------
 plugins/content/database/pgsql/content.sql |   19 ++++++++++---------
 2 files changed, 22 insertions(+), 20 deletions(-)

diff --git a/plugins/content/database/mysql/content.sql b/plugins/content/database/mysql/content.sql
index df51ba5..a1d215f 100644
--- a/plugins/content/database/mysql/content.sql
+++ b/plugins/content/database/mysql/content.sql
@@ -1,11 +1,12 @@
-CREATE TABLE `content` (
-  `code` int unsigned NOT NULL auto_increment,
-  `type` varchar(32) NOT NULL,
-  `uid` int unsigned NOT NULL,
-  `title` varchar(255) NOT NULL,
-  `body` longtext NOT NULL,
-  `locale` varchar(255) NOT NULL default 'en_US',
-  `created` datetime NOT NULL,
-  PRIMARY KEY (`code`),
-  KEY (`type`)
-) CHARACTER SET utf8;
+CREATE TABLE content (
+  code int unsigned NOT NULL auto_increment,
+  type varchar(32) NOT NULL,
+  uid int unsigned NOT NULL,
+  title varchar(255) NOT NULL,
+  body longtext NOT NULL,
+  uri varchar(255) NOT NULL,
+  locale varchar(255) NOT NULL default 'en_US',
+  created datetime NOT NULL,
+  PRIMARY KEY (code),
+  KEY (type)
+);
diff --git a/plugins/content/database/pgsql/content.sql b/plugins/content/database/pgsql/content.sql
index 4b8fda9..0232aba 100644
--- a/plugins/content/database/pgsql/content.sql
+++ b/plugins/content/database/pgsql/content.sql
@@ -1,10 +1,11 @@
-CREATE TABLE "content" (
-  "code" serial NOT NULL,
-  "type" varchar(32) NOT NULL,
-  "uid" int8 NOT NULL,
-  "title" varchar(255) NOT NULL,
-  "body" text NOT NULL,
-  "locale" varchar(255) NOT NULL DEFAULT 'en_US'::character varying,
-  "created" timestamp NOT NULL,
-  PRIMARY KEY ("code")
+CREATE TABLE content (
+  code serial NOT NULL,
+  type varchar(32) NOT NULL,
+  uid int8 NOT NULL,
+  title varchar(255) NOT NULL,
+  body text NOT NULL,
+  uri varchar(255) NOT NULL,
+  locale varchar(255) NOT NULL DEFAULT 'en_US',
+  created timestamp NOT NULL,
+  PRIMARY KEY (code)
 );


hooks/post-receive
-- 
Interchange wellwell catalog