TABLE_(HIVE_ACCESSORY)
    INT_ (ID) PRIMARY_KEY AUTO_INCREMENT
    STRING_ (NAME, 128) NOT_NULL
END_TABLE

TABLE_(HIVE)
    INT_ (ID) PRIMARY_KEY AUTO_INCREMENT
    STRING_ (NAME, 128) NOT NULL
    BLOB_ (DESCRIPTION)
END_TABLE

TABLE_(ABC)
    STRING_ (NAME, 80) NOT_NULL UNIQUE
END_TABLE

TABLE_(DEF)
    STRING (NAME, 80) NOT_NULL UNIQUE
END_TABLE

    STRING_ (NAME, 80) NOT_NULL UNIQUE

CREATE TABLE ABC (
    NAME varchar(80) NOT NULL
);

CREATE TABLE ABC (
    NAME VARCHAR(80) NOT NULL DEFAULT NULL
);

TABLE_(ABC)
  STRING_  (NAME, 80) NOT_NULL
END_TABLE

create table ABCTEST (  NAME text not null )

TABLE_(SUPPLIER)
	INT_    (ID) PRIMARY_KEY AUTO_INCREMENT
	STRING_ (NAME, 80) NOT_NULL UNIQUE
	STRING_ (ADDRESS1, 128)
	STRING_ (ADDRESS2, 128)
	STRING_ (CITY, 128)
	STRING_ (STATE, 80)
	STRING_ (POSTAL_CODE, 24)
	STRING_ (PRIMARY_PHONE, 35)
	STRING_ (SECONDARY_PHONE, 35)
	STRING_ (EMAIL, 128)
	STRING_ (WEB_ADDRESS, 500)
	BLOB_   (DESCRIPTION)
END_TABLE

-- From S_BeekPRO.sql
create table SUPPLIER (
 ID integer primary key autoincrement,
 NAME text not null,
 ADDRESS1 text,
 ADDRESS2 text,
 CITY text,
 STATE text,
 POSTAL_CODE text,
 PRIMARY_PHONE text,
 SECONDARY_PHONE text,
 EMAIL text,
 WEB_ADDRESS text,
 DESCRIPTION blob
);

-- From A_BeekPRO.sql
create unique index IDX_SUPPLIER$NAME on SUPPLIER(NAME);

C:\Develop\Tools\upp\out\MSC9.Debug.Debug_full.Gui>sqlite3 BeekPRO.db3
SQLite version 3.6.7
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema SUPPLIER
CREATE TABLE SUPPLIER (  ID integer primary key autoincrement , 
ADDRESS1 text, ADDRESS2 text, CITY text, STATE text, POSTAL_CODE 
text, PRIMARY_PHONE text, SECONDARY_PHONE text, EMAIL text, 
WEB_ADDRESS text, DESCRIPTION blob);

* C:\develop\tools\upp\out\MSC9.Debug.Debug_full.Gui\BeekPRO.exe 01.06.2009 17:52:23, user: jeremy

ERROR Cannot add a NOT NULL column with default value NULL(0): Preparing: alter table SUPPLIER add  NAME text not null
ERROR table SUPPLIER has no column named NAME(0): Preparing: create unique index IDX_SUPPLIER$NAME on SUPPLIER(NAME)

project/docs
project/src
project/sql
project/sql/0001.sql
project/sql/0001_r.sql
project/sql/0002.sql
project/sql/0002_r.sql