Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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" );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement