Home ›

Drupal SQL hacks

in
This is a work in process looking for methods to import data into Drupal.
  • Users
    • uid - isotonic increasing
    • name
    • pass - md5(password)
    • mail - email address
    • mode - 0
    • sort - 0
    • threshold - 0
    • theme - blank
    • signature - blank
    • created - now()
    • access - 0
    • login - 0
    • status - 1 {active}
    • timezone - -18000 {GMT-5}
    • language - blank
      • <
    • picture - blank
    • init - email address
    • data - a:1:{s:7:"contact";i:1;}
  • This data can be scrubbed from "Subscribers".
  • role can be derived from "service" in "subscribers"
  • user_roles is the uid to rid map
  • ec_address holds the address
  • ec_transaction is the target for transaction data
randomness