how do I... NOT NULL attribute for TIMESTAMP

[phpwalter]

I define a table...

Code: Select all

CREATE TABLE  user_segment_score_batch (
  user_id INT(10) UNSIGNED NOT NULL,
  segment_id INT(6) UNSIGNED NOT NULL,
  segment_score INT(10) UNSIGNED NOT NULL DEFAULT 0,
  created_by INT(10) UNSIGNED NOT NULL DEFAULT 10 COMMENT 'BATCH process ID',
  created_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (user_id, segment_id)
)
ENGINE = MEMORY
CHARACTER SET utf8
COLLATE utf8_general_ci;

But when I EXPORT or GENERATE SCHEMA SCRIPT I don't get the NOT NULL on the TIMESTAMP...

Code: Select all

CREATE TABLE  user_segment_score_batch (
  user_id INT(10) UNSIGNED NOT NULL,
  segment_id INT(6) UNSIGNED NOT NULL,
  segment_score INT(10) UNSIGNED NOT NULL DEFAULT 0,
  created_by INT(10) UNSIGNED NOT NULL DEFAULT 10 COMMENT 'BATCH process ID',
  created_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (user_id, segment_id)
)
ENGINE = MEMORY
CHARACTER SET utf8
COLLATE utf8_general_ci;

I really need this attribute definition on my EXPORT, GENERATE and SYNC operations. I'm managing DBs in a DEV, QA and PROD environments, I have corporate policies (NOT NULL on TIMESTAMP) to follow, and it's getting tedious to hand fix this each time.

I forget to fix it, I get kicked by corporate.

Any ideas?

Thx

Walter

[alexa]

We are aware of this issue and will fix it in the next product build. We will notify you once it's available for downloading.

[phpwalter]

Thanks!

Looking forward to it!

[phpwalter]

Just pulled down v6.3.337

Still do not have "NOT NULL" in my TIMESTAMP field results from a "Generate Schema Script"

Maybe next release?

Thx

[alexa]

It's still to be fixed.