[wellwell-devel] [SCM] Interchange wellwell catalog branch, master, updated. 564780fbfb0fbb09749039a6ee59d2e5e4afccaa
Stefan Hornburg
racke at rt.icdevgroup.org
Wed Jun 2 20:17:49 UTC 2010
via 564780fbfb0fbb09749039a6ee59d2e5e4afccaa (commit)
via f23382b528f760a05184438bba53266f9db42d40 (commit)
from 4febf49d940832a1224d70c4d67f8af11fdc83ee (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 564780fbfb0fbb09749039a6ee59d2e5e4afccaa
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date: Wed Jun 2 22:17:19 2010 +0200
Drop character set setting from MySQL scripts.
commit f23382b528f760a05184438bba53266f9db42d40
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date: Wed Jun 2 22:13:36 2010 +0200
Add description column to menus table.
-----------------------------------------------------------------------
Summary of changes and diff:
database/mysql/categories.sql | 2 +-
database/mysql/image_sizes.sql | 2 +-
database/mysql/menus.sql | 3 ++-
database/mysql/mv_metadata.sql | 2 +-
database/mysql/product_categories.sql | 2 +-
database/mysql/products.sql | 2 +-
database/pgsql/menus.sql | 1 +
7 files changed, 8 insertions(+), 6 deletions(-)
diff --git a/database/mysql/categories.sql b/database/mysql/categories.sql
index 6e9cf28..3f79097 100644
--- a/database/mysql/categories.sql
+++ b/database/mysql/categories.sql
@@ -10,4 +10,4 @@ CREATE TABLE `categories` (
PRIMARY KEY (`code`),
KEY `parent` (`parent`, `type`),
KEY `uri` (`uri`)
-) CHARACTER SET utf8;
+);
diff --git a/database/mysql/image_sizes.sql b/database/mysql/image_sizes.sql
index 3f77151..59c6581 100644
--- a/database/mysql/image_sizes.sql
+++ b/database/mysql/image_sizes.sql
@@ -4,4 +4,4 @@ CREATE TABLE `image_sizes`
`width` int unsigned,
`height` int unsigned,
PRIMARY KEY (`name`)
-) CHARACTER SET utf8;
+);
diff --git a/database/mysql/menus.sql b/database/mysql/menus.sql
index 7c84673..435cc54 100644
--- a/database/mysql/menus.sql
+++ b/database/mysql/menus.sql
@@ -6,7 +6,8 @@ CREATE TABLE `menus`
`url` varchar(255) NOT NULL DEFAULT '',
`permission` varchar(64) NOT NULL DEFAULT '',
`menu_name` varchar(64) NOT NULL DEFAULT '',
+ `description` text NOT NULL DEFAULT '',
`weight` int unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`code`),
KEY (`menu_name`)
-) CHARACTER SET utf8;
+);
diff --git a/database/mysql/mv_metadata.sql b/database/mysql/mv_metadata.sql
index 45d048d..b7e9a2e 100644
--- a/database/mysql/mv_metadata.sql
+++ b/database/mysql/mv_metadata.sql
@@ -22,4 +22,4 @@ CREATE TABLE mv_metadata
`display_filter` varchar(255),
`extended` text,
PRIMARY KEY (`code`)
-) CHARACTER SET utf8;
+);
diff --git a/database/mysql/product_categories.sql b/database/mysql/product_categories.sql
index 01fe8ca..10ee779 100644
--- a/database/mysql/product_categories.sql
+++ b/database/mysql/product_categories.sql
@@ -4,4 +4,4 @@ CREATE TABLE `product_categories` (
`type` varchar(16) NOT NULL,
KEY (`sku`),
KEY (`category`)
-) CHARACTER SET utf8;
+);
diff --git a/database/mysql/products.sql b/database/mysql/products.sql
index 410b9ee..6b2b0fb 100644
--- a/database/mysql/products.sql
+++ b/database/mysql/products.sql
@@ -9,5 +9,5 @@ CREATE TABLE `products`
`taxrate` decimal(4,2) NOT NULL DEFAULT 0,
`inactive` boolean DEFAULT FALSE,
PRIMARY KEY (`sku`)
- ) CHARACTER SET utf8;
+ );
diff --git a/database/pgsql/menus.sql b/database/pgsql/menus.sql
index b7508ad..416ca45 100644
--- a/database/pgsql/menus.sql
+++ b/database/pgsql/menus.sql
@@ -6,6 +6,7 @@ CREATE TABLE menus
"url" varchar(255) NOT NULL DEFAULT '',
"permission" varchar(64) NOT NULL DEFAULT '',
"menu_name" varchar(64) NOT NULL DEFAULT '',
+ "description" text NOT NULL DEFAULT '',
"weight" int4 NOT NULL DEFAULT 0,
CONSTRAINT menu_pkey PRIMARY KEY (code)
);
hooks/post-receive
--
Interchange wellwell catalog
More information about the wellwell-devel
mailing list