From 63b816ab5693733049fb3d45337614a7543e386e Mon Sep 17 00:00:00 2001 From: vyshane Date: Wed, 12 Apr 2006 08:44:59 +0000 Subject: [PATCH] Added default values for not null columns in table creation sql --- backup/db/oci8po.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/backup/db/oci8po.sql b/backup/db/oci8po.sql index c2759b986c..ea90598d25 100755 --- a/backup/db/oci8po.sql +++ b/backup/db/oci8po.sql @@ -47,9 +47,9 @@ rem drop TABLE prefix_backup_config; CREATE TABLE prefix_backup_config ( - id number(10) not null, - name varchar2(255) not null, - value varchar2(255) not null, + id number(10) default '0' not null, + name varchar2(255) default '' not null, + value varchar2(255) default '' not null, constraint pk_baco primary key (id), constraint uk_baco_name unique (name) ); -- 2.39.5