diff options
| author | ilja <ilja@7b491191-dbf0-0310-aff6-d879d4d69008> | 2005-01-22 12:56:58 +0000 |
|---|---|---|
| committer | ilja <ilja@7b491191-dbf0-0310-aff6-d879d4d69008> | 2005-01-22 12:56:58 +0000 |
| commit | 21ed459a1cea0ab1def24199b0b5d78c3ff87b5f (patch) | |
| tree | 4efc2661eeaed7b8be4ada0c45f7da587781c638 /sql | |
| parent | dcb5a0cdb460f6fb39b59cfd93f11b1674dd34dc (diff) | |
2005-01-22 Ilja Booij <ilja@ic-s.nl>
* applied patch by Christian Haugg to Mysql migration scripts to
make them work under MySQL 4.1
git-svn-id: https://svn.ic-s.nl/svn/dbmail/trunk/dbmail@1584 7b491191-dbf0-0310-aff6-d879d4d69008
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql/migrate_from_1.x_to_2.0.mysql | 6 | ||||
| -rw-r--r-- | sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/sql/mysql/migrate_from_1.x_to_2.0.mysql b/sql/mysql/migrate_from_1.x_to_2.0.mysql index f7ed34d4..85aade2d 100644 --- a/sql/mysql/migrate_from_1.x_to_2.0.mysql +++ b/sql/mysql/migrate_from_1.x_to_2.0.mysql @@ -133,7 +133,7 @@ UPDATE dbmail_messageblks SET is_header = '0'; # as they are. # CREATE TABLE IF NOT EXISTS auto_notifications ( - auto_notify_idnr bigint(21) default '0' not null auto_increment, + auto_notify_idnr bigint(21) not null auto_increment, user_idnr bigint(21) DEFAULT '0' NOT NULL, notify_address VARCHAR(100), PRIMARY KEY (auto_notify_idnr) @@ -141,7 +141,7 @@ CREATE TABLE IF NOT EXISTS auto_notifications ( CREATE TABLE IF NOT EXISTS auto_replies ( - auto_reply_idnr bigint(21) DEFAULT '0' NOT NULL auto_increment, + auto_reply_idnr bigint(21) NOT NULL auto_increment, user_idnr bigint(21) DEFAULT '0' NOT NULL, reply_body mediumtext, PRIMARY KEY (auto_reply_idnr) @@ -164,7 +164,7 @@ ALTER TABLE dbmail_auto_replies DROP TABLE IF EXISTS pbsp; DROP TABLE IF EXISTS dbmail_pbsp; CREATE TABLE dbmail_pbsp ( - idnr bigint(21) DEFAULT '0' NOT NULL auto_increment, + idnr bigint(21) NOT NULL auto_increment, since datetime default '0' not null, ipnumber varchar(40) NOT NULL, PRIMARY KEY (idnr), diff --git a/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql b/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql index a9b8ea55..b92ad4d5 100644 --- a/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql +++ b/sql/mysql/migrate_from_1.x_to_2.0_innodb.mysql @@ -160,7 +160,7 @@ UPDATE dbmail_messageblks SET is_header = '0'; # tables do not have a new structure in dbmail 2.0, so they can be left # as they are. CREATE TABLE IF NOT EXISTS auto_notifications ( - auto_notify_idnr bigint(21) default '0' not null auto_increment, + auto_notify_idnr bigint(21) not null auto_increment, user_idnr bigint(21) DEFAULT '0' NOT NULL, notify_address VARCHAR(100), PRIMARY KEY (auto_notify_idnr), @@ -169,7 +169,7 @@ CREATE TABLE IF NOT EXISTS auto_notifications ( ) TYPE=InnoDB; CREATE TABLE IF NOT EXISTS auto_replies ( - auto_reply_idnr bigint(21) DEFAULT '0' NOT NULL auto_increment, + auto_reply_idnr bigint(21) NOT NULL auto_increment, user_idnr bigint(21) DEFAULT '0' NOT NULL, reply_body mediumtext, PRIMARY KEY (auto_reply_idnr), @@ -194,7 +194,7 @@ ALTER TABLE dbmail_auto_replies DROP TABLE IF EXISTS pbsp; DROP TABLE IF EXISTS dbmail_pbsp; CREATE TABLE dbmail_pbsp ( - idnr bigint(21) DEFAULT '0' NOT NULL auto_increment, + idnr bigint(21) NOT NULL auto_increment, since datetime default '0' not null, ipnumber varchar(40) NOT NULL, PRIMARY KEY (idnr), |