- Set DEFAULT NULL for users.last_login
| | |
| | | [mail_host] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
|
| | | [alias] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
|
| | | [created] [datetime] NOT NULL ,
|
| | | [last_login] [datetime] NOT NULL ,
|
| | | [last_login] [datetime] NULL ,
|
| | | [language] [varchar] (5) COLLATE Latin1_General_CI_AI NULL ,
|
| | | [preferences] [text] COLLATE Latin1_General_CI_AI NULL
|
| | | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
| | |
| | | `mail_host` varchar(128) NOT NULL, |
| | | `alias` varchar(128) NOT NULL, |
| | | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `last_login` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| | | `last_login` datetime DEFAULT NULL, |
| | | `language` varchar(5), |
| | | `preferences` text, |
| | | PRIMARY KEY(`user_id`), |
| | |
| | | ) /*!40000 ENGINE=INNODB */; |
| | | |
| | | /*!40014 SET FOREIGN_KEY_CHECKS=1 */; |
| | | |
| | | -- Updates from version 0.4-beta |
| | | |
| | | ALTER TABLE `users` CHANGE `last_login` `last_login` datetime DEFAULT NULL; |
| | | UPDATE `users` SET `last_login` = NULL WHERE `last_login` = '1000-01-01 00:00:00'; |
| | |
| | | mail_host varchar(128) DEFAULT '' NOT NULL, |
| | | alias varchar(128) DEFAULT '' NOT NULL, |
| | | created timestamp with time zone DEFAULT now() NOT NULL, |
| | | last_login timestamp with time zone DEFAULT now() NOT NULL, |
| | | last_login timestamp with time zone DEFAULT NULL, |
| | | "language" varchar(5), |
| | | preferences text DEFAULT ''::text NOT NULL |
| | | ); |
| | |
| | | created timestamp with time zone DEFAULT now() NOT NULL, |
| | | PRIMARY KEY (contactgroup_id, contact_id) |
| | | ); |
| | | |
| | | -- Updates from version 0.4-beta |
| | | |
| | | ALTER TABLE users ALTER last_login DROP NOT NULL; |
| | | ALTER TABLE users ALTER last_login SET DEFAULT NULL; |
| | |
| | | mail_host varchar(128) NOT NULL default '', |
| | | alias varchar(128) NOT NULL default '', |
| | | created datetime NOT NULL default '0000-00-00 00:00:00', |
| | | last_login datetime NOT NULL default '0000-00-00 00:00:00', |
| | | last_login datetime DEFAULT NULL, |
| | | language varchar(5), |
| | | preferences text NOT NULL default '' |
| | | ); |
| | |
| | | PRIMARY KEY (contactgroup_id, contact_id) |
| | | ); |
| | | |
| | | -- Updates from version 0.3.1 |
| | | |
| | | CREATE TABLE tmp_users ( |
| | | user_id integer NOT NULL PRIMARY KEY, |
| | | username varchar(128) NOT NULL default '', |
| | | mail_host varchar(128) NOT NULL default '', |
| | | alias varchar(128) NOT NULL default '', |
| | | created datetime NOT NULL default '0000-00-00 00:00:00', |
| | | last_login datetime NOT NULL default '0000-00-00 00:00:00', |
| | | language varchar(5), |
| | | preferences text NOT NULL default '' |
| | | ); |
| | | |
| | | INSERT INTO tmp_users (user_id, username, mail_host, alias, created, last_login, language, preferences) |
| | | SELECT user_id, username, mail_host, alias, created, last_login, language, preferences FROM users; |
| | | |
| | | DROP INDEX ix_users_username ON users(username); |
| | | DROP INDEX ix_users_alias ON users(alias); |
| | | DROP TABLE users; |
| | | |
| | | CREATE TABLE users ( |
| | | user_id integer NOT NULL PRIMARY KEY, |
| | | username varchar(128) NOT NULL default '', |
| | | mail_host varchar(128) NOT NULL default '', |
| | | alias varchar(128) NOT NULL default '', |
| | | created datetime NOT NULL default '0000-00-00 00:00:00', |
| | | last_login datetime DEFAULT NULL, |
| | | language varchar(5), |
| | | preferences text NOT NULL default '' |
| | | ); |
| | | |
| | | INSERT INTO users (user_id, username, mail_host, alias, created, last_login, language, preferences) |
| | | SELECT user_id, username, mail_host, alias, created, last_login, language, preferences FROM tmp_users; |
| | | |
| | | CREATE INDEX ix_users_username ON users(username); |
| | | CREATE INDEX ix_users_alias ON users(alias); |
| | | DROP TABLE tmp_users; |