CREATE DATABASE 'C:\Users\rle\Documents\Test.db' LOG ON 'Test.log' COLLATION '1252LATIN1' NCHAR COLLATION 'UCA' DBA USER 'dba' DBA PASSWORD '***';

/*
The Sybase database wizard outputs the following:

dbinit -z "1252LATIN1" -zn "UCA" -dba "dba","***" -t "Test.log" "C:\Users\rle\Documents\Test.db"

CHAR collation sequence:  1252LATIN1(CaseSensitivity=Ignore)
CHAR character set encoding:  windows-1252
NCHAR collation sequence:  UCA(CaseSensitivity=Ignore;AccentSensitivity=Ignore;PunctuationSensitivity=Primary)
NCHAR character set encoding:  UTF-8
Database is not encrypted
Creating system tables
Creating system views
Setting option values
*/

CREATE TABLE "dba"."PlayingCard" (
    "Suit" VARCHAR(8) NOT NULL,
    "Value" VARCHAR(5) NOT NULL,
    PRIMARY KEY ( "Suit" ASC, "Value" ASC )
) IN "system";

CREATE TABLE "dba"."PlayingCardLog" (
    "Id" INTEGER NOT NULL DEFAULT AUTOINCREMENT,
    "Suit" VARCHAR(8) NOT NULL,
    "Value" VARCHAR(5) NOT NULL,
    "Dealt" "datetime" NOT NULL,
    PRIMARY KEY ( "Id" ASC )
) IN "system";

ALTER TABLE "dba"."PlayingCardLog" ADD CONSTRAINT "PlayingCard" NOT NULL FOREIGN KEY ( "Suit" ASC, "Value" ASC ) REFERENCES "dba"."PlayingCard" ( "Suit", "Value" );