[jboss-dev-forums] [Design of JBoss ESB] - Re: JBossESB 4.0 Beta 1 released

[tfennelly]

NOTE:

In order to run the TrailBlazer, you may need to create the following "customer_index" table.  Check your database!

Creation scripts....

Postgres:

CREATE TABLE public.customer_index (
    uid                 int8 NOT NULL,
    stamp               int8 NULL,
    latest_snap_uid     int8 NULL,
    latest_snap_date    text NULL,
    name                text NULL,
    phone               text NULL,
    address             text NULL,
    PRIMARY KEY(uid)
);

MySql:

CREATE TABLE `customer_index` (

  `uid` bigint(20) unsigned NOT NULL default '0',

  `stamp` bigint(20) unsigned default NULL,

  `latest_snap_uid` bigint(20) unsigned default NULL,

  `latest_snap_date` text,

  `name` text,

  `phone` text,

  `address` text,

  PRIMARY KEY  (`uid`),

  UNIQUE KEY `customer_index_pkey` (`uid`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;


HSQL:

CREATE TABLE customer_index (

    uid bigint NOT NULL,

    stamp bigint,

    latest_snap_uid bigint,

    latest_snap_date varchar,

    name varchar,

    phone varchar,

    address varchar,

    CONSTRAINT customer_index_pk PRIMARY KEY (uid)

);



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3965191#3965191

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3965191