dev note: update text fields as nullable and no default

Prepare schema:

  1. Check target fields (http://edin.no-ip.com/node/166).
    a. No default + NOT NULL => can't accept NULL so valid value only (1 status only)
    b. Default with '' => remove
  2. Update schema with "NOT NULL => FALSE, (remove default)".
  3. Running update.php. Ensure schema is valid.
  4. Run related simpletest.

Once schema ready for expert install:

  1. ORACLE_NULL => NULL
  2. Before insert: check '' => NULL (!?)
  3. Before normal variable binding: '' => NULL
  4. check SQL syntax, change from = '' to IS NULL

Testing procedure:

  1. expert mode -> patch -> update
  2. normal mode -> patch -> update
  3. normal mode + all modules -> patch -> update
  4. patch -> install -> all modules


Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <h1> <h2> <h3> <h4> <h5> <h6> <em> <strong> <code> <del> <blockquote> <q> <sub> <p> <br> <ul> <ol> <li> <dl> <dt> <dd> <a> <b> <u> <i> <sup> <acronym> <pre> <img>
  • Lines and paragraphs break automatically.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • Images can be added to this post.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.