[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  return array(
   4  
   5  'users' => "CREATE TABLE %s (
   6    ID bigint(20) unsigned NOT NULL auto_increment,
   7    user_login varchar(60) NOT NULL default '',
   8    user_pass varchar(64) NOT NULL default '',
   9    user_nicename varchar(50) NOT NULL default '',
  10    user_email varchar(100) NOT NULL default '',
  11    user_url varchar(100) NOT NULL default '',
  12    user_registered datetime NOT NULL default '0000-00-00 00:00:00',
  13    user_activation_key varchar(60) NOT NULL default '',
  14    user_status int(11) NOT NULL default '0',
  15    display_name varchar(250) NOT NULL default '',
  16    PRIMARY KEY  (ID),
  17    KEY user_login_key (user_login),
  18    KEY user_nicename (user_nicename)
  19  )",
  20  
  21  'usermeta' => "CREATE TABLE %s (
  22    umeta_id bigint(20) NOT NULL auto_increment,
  23    user_id bigint(20) NOT NULL default '0',
  24    meta_key varchar(255) default NULL,
  25    meta_value longtext,
  26    PRIMARY KEY  (umeta_id),
  27    KEY user_id (user_id),
  28    KEY meta_key (meta_key)
  29  )"
  30  
  31  );
  32  
  33  ?>