Fossil SCM
When ALTER'ing mlink table, create "isaux" column as boolean.
Commit
ef3562a1169b4fda107ba2fbb16cdd0d4f012441
Parent
89c17a86e1025b8…
1 file changed
+1
-1
M
src/db.c
+1
-1
| --- src/db.c | ||
| +++ src/db.c | ||
| @@ -1197,11 +1197,11 @@ | ||
| 1197 | 1197 | */ |
| 1198 | 1198 | if( !db_table_has_column("repository","mlink","isaux") ){ |
| 1199 | 1199 | db_begin_transaction(); |
| 1200 | 1200 | db_multi_exec( |
| 1201 | 1201 | "ALTER TABLE %s.mlink ADD COLUMN pmid INTEGER DEFAULT 0;" |
| 1202 | - "ALTER TABLE %s.mlink ADD COLUMN isaux INTEGER DEFAULT 0;", | |
| 1202 | + "ALTER TABLE %s.mlink ADD COLUMN isaux BOOLEAN DEFAULT 0;", | |
| 1203 | 1203 | db_name("repository"), db_name("repository") |
| 1204 | 1204 | ); |
| 1205 | 1205 | db_end_transaction(0); |
| 1206 | 1206 | } |
| 1207 | 1207 | } |
| 1208 | 1208 |
| --- src/db.c | |
| +++ src/db.c | |
| @@ -1197,11 +1197,11 @@ | |
| 1197 | */ |
| 1198 | if( !db_table_has_column("repository","mlink","isaux") ){ |
| 1199 | db_begin_transaction(); |
| 1200 | db_multi_exec( |
| 1201 | "ALTER TABLE %s.mlink ADD COLUMN pmid INTEGER DEFAULT 0;" |
| 1202 | "ALTER TABLE %s.mlink ADD COLUMN isaux INTEGER DEFAULT 0;", |
| 1203 | db_name("repository"), db_name("repository") |
| 1204 | ); |
| 1205 | db_end_transaction(0); |
| 1206 | } |
| 1207 | } |
| 1208 |
| --- src/db.c | |
| +++ src/db.c | |
| @@ -1197,11 +1197,11 @@ | |
| 1197 | */ |
| 1198 | if( !db_table_has_column("repository","mlink","isaux") ){ |
| 1199 | db_begin_transaction(); |
| 1200 | db_multi_exec( |
| 1201 | "ALTER TABLE %s.mlink ADD COLUMN pmid INTEGER DEFAULT 0;" |
| 1202 | "ALTER TABLE %s.mlink ADD COLUMN isaux BOOLEAN DEFAULT 0;", |
| 1203 | db_name("repository"), db_name("repository") |
| 1204 | ); |
| 1205 | db_end_transaction(0); |
| 1206 | } |
| 1207 | } |
| 1208 |