Changeset debdda0 in github

Timestamp:

Nov 25, 2008 5:17:57 AM (4 years ago)

Author:

alecpl <alec@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

0cb9677

Parents:

938e96a

Message:

#1485420: remove default (and not null) for users.language column in DDL

Location:

SQL

Files:

• mssql.initial.sql (modified) (2 diffs)
• mysql.initial.sql (modified) (1 diff)
• mysql.update.sql (modified) (1 diff)
• mysql5.initial.sql (modified) (1 diff)
• postgres.initial.sql (modified) (1 diff)
• postgres.update.sql (modified) (1 diff)
• sqlite.initial.sql (modified) (1 diff)

SQL/mssql.initial.sql

@@ -70 +70 @@
         [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]
@@ -203 +203 @@
         CONSTRAINT [DF_users_alias] DEFAULT ('') FOR [alias],
         CONSTRAINT [DF_users_created] DEFAULT (getdate()) FOR [created],
-        CONSTRAINT [DF_users_language] DEFAULT ('en') FOR [language]
 GO
 

SQL/mysql.initial.sql

@@ -91 +91 @@
   `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`),

SQL/mysql.update.sql

@@ -42 +42 @@
 ALTER TABLE `cache`
     ADD INDEX `created_index` (`created`);
+
+ALTER TABLE `users`
+    CHANGE `language` `language` varchar(5);

SQL/mysql5.initial.sql

@@ -29 +29 @@
  `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`),

SQL/postgres.initial.sql

@@ -22 +22 @@
     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
 );

SQL/postgres.update.sql

@@ -29 +29 @@
 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;

SQL/sqlite.initial.sql

@@ -77 +77 @@
   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 ''
 );