#1485420: remove default (and not null) for users.language column in DDL
| | |
| | | [alias] [varchar] (128) COLLATE Latin1_General_CI_AI NOT NULL ,
|
| | | [created] [datetime] NOT NULL ,
|
| | | [last_login] [datetime] NULL ,
|
| | | [language] [varchar] (5) COLLATE Latin1_General_CI_AI NOT NULL ,
|
| | | [language] [varchar] (5) COLLATE Latin1_General_CI_AI NULL ,
|
| | | [preferences] [text] COLLATE Latin1_General_CI_AI NOT NULL
|
| | | ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
|
| | | GO
|
| | |
| | | CONSTRAINT [DF_users_mail_host] DEFAULT ('') FOR [mail_host],
|
| | | CONSTRAINT [DF_users_alias] DEFAULT ('') FOR [alias],
|
| | | CONSTRAINT [DF_users_created] DEFAULT (getdate()) FOR [created],
|
| | | CONSTRAINT [DF_users_language] DEFAULT ('en') FOR [language]
|
| | | GO
|
| | |
|
| | | CREATE INDEX [IX_users_username] ON [dbo].[users]([username]) ON [PRIMARY]
|
| | |
| | | `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) NOT NULL default 'en', |
| | | `language` varchar(5), |
| | | `preferences` text, |
| | | PRIMARY KEY (`user_id`), |
| | | INDEX `username_index` (`username`), |
| | |
| | | |
| | | ALTER TABLE `cache` |
| | | ADD INDEX `created_index` (`created`); |
| | | |
| | | ALTER TABLE `users` |
| | | CHANGE `language` `language` varchar(5); |
| | |
| | | `alias` varchar(128) NOT NULL, |
| | | `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) NOT NULL DEFAULT 'en', |
| | | `language` varchar(5), |
| | | `preferences` text, |
| | | PRIMARY KEY(`user_id`), |
| | | INDEX `username_index` (`username`), |
| | |
| | | alias character varying(128) DEFAULT ''::character varying NOT NULL, |
| | | created timestamp with time zone DEFAULT now() NOT NULL, |
| | | last_login timestamp with time zone DEFAULT now() NOT NULL, |
| | | "language" character varying(5) DEFAULT 'en'::character varying NOT NULL, |
| | | "language" character varying(5), |
| | | preferences text DEFAULT ''::text NOT NULL |
| | | ); |
| | | |
| | |
| | | |
| | | CREATE INDEX session_changed_idx ON session (changed); |
| | | CREATE INDEX cache_created_idx ON "cache" (created); |
| | | |
| | | ALTER TABLE users ALTER "language" DROP NOT NULL; |
| | | ALTER TABLE users ALTER "language" DROP 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) NOT NULL default 'en', |
| | | language varchar(5), |
| | | preferences text NOT NULL default '' |
| | | ); |
| | | |