SHARE
TWEET

Untitled

a guest Mar 31st, 2016 11 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE DATABASE 'C:\Users\rle\Documents\Test.db' LOG ON 'Test.log' COLLATION '1252LATIN1' NCHAR COLLATION 'UCA' DBA USER 'dba' DBA PASSWORD '***';
  2.  
  3. /*
  4. The Sybase database wizard outputs the following:
  5.  
  6. dbinit -z "1252LATIN1" -zn "UCA" -dba "dba","***" -t "Test.log" "C:\Users\rle\Documents\Test.db"
  7.  
  8. CHAR collation sequence:  1252LATIN1(CaseSensitivity=Ignore)
  9. CHAR character set encoding:  windows-1252
  10. NCHAR collation sequence:  UCA(CaseSensitivity=Ignore;AccentSensitivity=Ignore;PunctuationSensitivity=Primary)
  11. NCHAR character set encoding:  UTF-8
  12. Database is not encrypted
  13. Creating system tables
  14. Creating system views
  15. Setting option values
  16. */
  17.  
  18. CREATE TABLE "dba"."PlayingCard" (
  19.     "Suit" VARCHAR(8) NOT NULL,
  20.     "Value" VARCHAR(5) NOT NULL,
  21.     PRIMARY KEY ( "Suit" ASC, "Value" ASC )
  22. ) IN "system";
  23.  
  24. CREATE TABLE "dba"."PlayingCardLog" (
  25.     "Id" INTEGER NOT NULL DEFAULT AUTOINCREMENT,
  26.     "Suit" VARCHAR(8) NOT NULL,
  27.     "Value" VARCHAR(5) NOT NULL,
  28.     "Dealt" "datetime" NOT NULL,
  29.     PRIMARY KEY ( "Id" ASC )
  30. ) IN "system";
  31.  
  32. ALTER TABLE "dba"."PlayingCardLog" ADD CONSTRAINT "PlayingCard" NOT NULL FOREIGN KEY ( "Suit" ASC, "Value" ASC ) REFERENCES "dba"."PlayingCard" ( "Suit", "Value" );
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top