![[Warning]](images/admonitions/warning.png) | Work in progress |
|---|---|
This section is a work in progress, it's not complete. It's here basically for me, don't use it until it's complete | |
1) Overwrite all the files in the common directory tree.
2) Add the following tables, changing the prefix if needed.
CREATE TABLE _sequence_sl_module ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; CREATE TABLE _sequence_sl_posts_cat ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; CREATE TABLE _sequence_sl_posts_item ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; CREATE TABLE _sequence_sl_posts_object ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; CREATE TABLE _sequence_sl_translate ( sequence int(11) NOT NULL auto_increment, PRIMARY KEY (sequence) ) TYPE=MyISAM; CREATE TABLE sl_country ( name char(50) NOT NULL default '', code char(2) NOT NULL default '', UNIQUE KEY code (code) ) TYPE=MyISAM; CREATE TABLE sl_language ( abbrev char(5) NOT NULL default '', date_long char(24) NOT NULL default '', date_short char(24) NOT NULL default '', flag char(48) NOT NULL default '', name char(48) NOT NULL default '', ord int(11) NOT NULL default '0', enable char(1) NOT NULL default 'Y', UNIQUE KEY abbrev (abbrev) ) TYPE=MyISAM; CREATE TABLE sl_posts_cat ( id_posts_cat int(11) NOT NULL default '0', lang char(5) NOT NULL default 'en_US', title char(100) default NULL, description char(255) default NULL, restricted char(1) NOT NULL default 'n', autoapprove char(1) NOT NULL default 'y', ordby char(24) NOT NULL default 'mod_date', lastpost datetime default NULL, ord int(11) NOT NULL default '0', UNIQUE KEY id_posts_cat_idx (id_posts_cat,lang) ) TYPE=MyISAM; CREATE TABLE sl_posts_item ( id_posts_item int(11) NOT NULL default '0', id_posts_cat int(11) NOT NULL default '0', lang char(5) NOT NULL default '', title char(100) NOT NULL default '', comments char(255) NOT NULL default '', approved char(1) NOT NULL default 'n', ins_date datetime default NULL, mod_date datetime default NULL, ord int(11) NOT NULL default '0', UNIQUE KEY posts_item_idx (id_posts_item,id_posts_cat) ) TYPE=MyISAM; CREATE TABLE sl_posts_object ( id_posts_object int(11) NOT NULL default '0', id_posts_item int(11) NOT NULL default '0', id_posts_cat int(11) NOT NULL default '0', object_name char(255) NOT NULL default '', object_mime char(32) NOT NULL default '', object_size int(11) NOT NULL default '0', object_type char(1) NOT NULL default 't', location char(1) NOT NULL default 'c', ord int(11) NOT NULL default '0', approved char(1) NOT NULL default 'n', pic_width int(11) NOT NULL default '0', pic_height int(11) NOT NULL default '0', UNIQUE KEY id_posts_object_idx (id_posts_object,id_posts_item) ) TYPE=MyISAM; CREATE TABLE sl_translate ( id_translate int(11) NOT NULL default '0', msgid char(255) NOT NULL default '', locale char(5) NOT NULL default '', msgstr char(255) default NULL, fuzzy char(1) NOT NULL default 'N', UNIQUE KEY id_translate_idx (id_translate) ) TYPE=MyISAM;
3) Alter and drop table instructions
ALTER TABLE sl_page DROP ord; ALTER TABLE sl_page DROP INDEX name_idx , ADD UNIQUE name_idx (name, is_common); ALTER TABLE sl_project CHANGE name name CHAR(128) NOT NULL; DROP TABLE sl_slotdep; ALTER TABLE sl_module ADD is_common CHAR(1) DEFAULT 'Y' NOT NULL AFTER ord;
4) Populate the language table: select Configure site, and then Resets a table to default (FIXME: this message will be changed soon). Then choose the language table and press OK.
5) Click on Configure site and then on Resets a table to default (FIXME:). Then choose the message table and press OK. Be patient. The operation may take a minute.