[Sommaire] [Imprimer]

   1  <?php
   2  
   3  echo "<p>Adding module_templates table...";
   4  
   5  $dbdict = NewDataDictionary($db);
   6  $flds = "
   7      module_name C(255),
   8      template_name C(200),
   9      content X,
  10      create_date DT,
  11      modified_date DT
  12  ";
  13  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  14  $sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."module_templates", $flds, $taboptarray);
  15  $dbdict->ExecuteSQLArray($sqlarray);
  16  
  17  echo "[done]</p>";
  18  
  19  echo "<p>Adding fields to content table...";
  20  
  21  $dbdict = NewDataDictionary($db);
  22  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."content", "last_modified_by I");
  23  $dbdict->ExecuteSQLArray($sqlarray);
  24  
  25  echo "[done]</p>";
  26  
  27  echo "<p>Removing field from content_props table...";
  28  
  29  $dbdict = NewDataDictionary($db);
  30  $sqlarray = $dbdict->DropColumnSQL(cms_db_prefix()."content_props", "content_prop_id");
  31  $dbdict->ExecuteSQLArray($sqlarray);
  32  
  33  echo "[done]</p>";
  34  
  35  echo "<p>Setting a last_modified_by to something...";
  36  
  37  $oneuserid = $db->GetOne("SELECT user_id FROM ".cms_db_prefix()."users");
  38  $db->Execute("UPDATE ".cms_db_prefix()."content SET last_modified_by = ".$oneuserid);
  39  
  40  echo "[done]</p>";
  41  
  42  echo "<p>Adding fields to template table...";
  43  
  44  $dbdict = NewDataDictionary($db);
  45  $sqlarray = $dbdict->AddColumnSQL(cms_db_prefix()."templates", "default_template I1");
  46  $dbdict->ExecuteSQLArray($sqlarray);
  47  
  48  echo "[done]</p>";
  49  
  50  echo "<p>Setting a default template...";
  51  
  52  $onetemplateid = $db->GetOne("SELECT template_id FROM ".cms_db_prefix()."templates");
  53  $db->Execute("UPDATE ".cms_db_prefix()."templates SET default_template = 0");
  54  $db->Execute("UPDATE ".cms_db_prefix()."templates SET default_template = 1 WHERE template_id = ".$onetemplateid);
  55  
  56  echo "[done]</p>";
  57  
  58  echo "<p>Updating Permissions...";
  59  
  60  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Add Stylesheets', permission_text='Add Stylesheets' where permission_name='Add CSS'");
  61  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Modify Stylesheets', permission_text='Modify Stylesheets' where permission_name='Modify CSS'");
  62  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Remove Stylesheets', permission_text='Remove Stylesheets' where permission_name='Remove CSS'");
  63  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Add Pages', permission_text='Add Pages' where permission_name='Add Content'");
  64  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Modify Any Page', permission_text='Modify Any Page' where permission_name='Modify Any Content'");
  65  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Remove Pages', permission_text='Remove Pages' where permission_name='Remove Content'");
  66  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Add Groups', permission_text='Add Groups' where permission_name='Add Group'");
  67  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Modify Groups', permission_text='Modify Groups' where permission_name='Modify Group'");
  68  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Remove Groups', permission_text='Remove Groups' where permission_name='Remove Group'");
  69  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Add Templates', permission_text='Add Templates' where permission_name='Add Template'");
  70  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Modify Templates', permission_text='Modify Templates' where permission_name='Modify Template'");
  71  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Remove Templates', permission_text='Remove Templates' where permission_name='Remove Template'");
  72  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Add Users', permission_text='Add Users' where permission_name='Add User'");
  73  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Modify Users', permission_text='Modify Users' where permission_name='Modify User'");
  74  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Remove Users', permission_text='Remove Users' where permission_name='Remove User'");
  75  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Add Stylesheet Assoc', permission_text='Add Stylesheet Associations' where permission_name='Add CSS association'");
  76  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Modify Stylesheet Assoc', permission_text='Modify Stylesheet Associations' where permission_name='Edit CSS association'");
  77  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_name = 'Remove Stylesheet Assoc', permission_text='Remove Stylesheet Associations' where permission_name='Remove CSS association'");
  78  $db->Execute("UPDATE ".cms_db_prefix()."permissions SET permission_text = 'Modify Permissions for Groups' where permission_name='Modify Permissions'");
  79  echo "[done]</p>";
  80  
  81  echo "<p>Adding admin_bookmarks table...";
  82  
  83  $dbdict = NewDataDictionary($db);
  84  $flds = "
  85      bookmark_id I KEY,
  86      user_id I,
  87      title C(255),
  88      url C(255)
  89  ";
  90  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  91  $sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."admin_bookmarks", $flds, $taboptarray);
  92  $dbdict->ExecuteSQLArray($sqlarray);
  93  
  94  $db->CreateSequence(cms_db_prefix()."admin_bookmarks_seq");
  95  
  96  echo '[done]</p>';
  97  
  98  echo "<p>Adding admin_recent_pages table...";
  99  
 100  $dbdict = NewDataDictionary($db);
 101  $flds = "
 102      id I KEY,
 103      user_id I,
 104      title C(255),
 105      url C(255),
 106      access_time DT
 107  ";
 108  $taboptarray = array('mysql' => 'TYPE=MyISAM');
 109  $sqlarray = $dbdict->CreateTableSQL(cms_db_prefix()."admin_recent_pages", $flds, $taboptarray);
 110  $dbdict->ExecuteSQLArray($sqlarray);
 111  
 112  $db->CreateSequence(cms_db_prefix()."admin_recent_pages_seq");
 113  
 114  echo '[done]</p>';
 115  
 116  echo "<p>Adding Primary Keys...";
 117  
 118  $db->Execute("ALTER TABLE ".cms_db_prefix()."content ADD PRIMARY KEY (content_id, prop_name)");
 119  $db->Execute("ALTER TABLE ".cms_db_prefix()."htmlblobs ADD PRIMARY KEY (htmlblob_id)");
 120  $db->Execute("ALTER TABLE ".cms_db_prefix()."css ADD PRIMARY KEY (css_id)");
 121  $db->Execute("ALTER TABLE ".cms_db_prefix()."userplugins ADD PRIMARY KEY (userplugin_id)");
 122  
 123  echo '[done]</p>';
 124  
 125  echo "<p>Adding Indexes...";
 126  
 127  $db->Execute("ALTER TABLE ".cms_db_prefix()."content_props ADD INDEX (content_id, prop_name)");
 128  $db->Execute("ALTER TABLE ".cms_db_prefix()."content ADD INDEX (content_alias, active)");
 129  $db->Execute("ALTER TABLE ".cms_db_prefix()."content ADD INDEX (content_alias)");
 130  $db->Execute("ALTER TABLE ".cms_db_prefix()."module_templates ADD INDEX (module_name, template_name)");
 131  $db->Execute("ALTER TABLE ".cms_db_prefix()."group_perms ADD INDEX (group_id, permission_id)");
 132  $db->Execute("ALTER TABLE ".cms_db_prefix()."admin_bookmarks ADD INDEX (user_id)");
 133  $db->Execute("ALTER TABLE ".cms_db_prefix()."userprefs ADD INDEX (user_id)");
 134  
 135  echo '[done]</p>';
 136  
 137  echo '<p>Updating schema version... ';
 138  
 139  $query = "UPDATE ".cms_db_prefix()."version SET version = 10";
 140  $db->Execute($query);
 141  
 142  echo '[done]</p>';
 143  
 144  # vim:ts=4 sw=4 noet
 145  ?>