patch_0_5_0.sql

来自「一个页面界面的邮件程序」· SQL 代码 · 共 17 行

--
-- Add language preferences
--

ALTER TABLE `user` ADD `language` VARCHAR( 4 ) DEFAULT 'FR' NOT NULL AFTER `password` ;


-- 
-- Add table to memorise frame's state
-- 

CREATE TABLE `closed_frame` (
  `iduser` int(10) unsigned NOT NULL default '0',
  `key` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`iduser`,`key`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;