[問題]如何將 mysql schema轉到 oracle schema?

[Adonisy (DHL真是個懶惰的運輸業~~)]

SET NAMES 'utf8';

DROP TABLE IF EXISTS Users;

CREATE TABLE Users (
    UserId              VARCHAR(50) NOT NULL UNIQUE,
    AuthenticationKey   longblob ,
    AuthorizationKey    longblob ,
    FirstName           VARCHAR(50),
    MiddleName          VARCHAR(50),
    LastName            VARCHAR(50),
    Email               VARCHAR(50),
    CompanyName         VARCHAR(50),
    AddrStreet          VARCHAR(50),
    AddrCity            VARCHAR(50),
    AddrState           VARCHAR(50),
    AddrZip             VARCHAR(50),
    AddrCountry         VARCHAR(50),
    EnablePwdAsKey      INTEGER,
    Pwd                 longblob ,
    Message             VARCHAR(250),
    TotalCash           DOUBLE(20,2),
    RoleId              Integer DEFAULT 0,
    LegalTermAgreed     ENUM('Y', 'N') DEFAULT 'N',
    EmailConfirmed      ENUM('Y', 'N') DEFAULT 'N',

    PRIMARY KEY(UserId)

) TYPE=InnoDB CHARACTER SET utf8;


謝謝~~~ 對這兩套都不熟 ^^

--
http://www.wretch.cc/blog/Adonisy

脆瓜撞球工作室~~~

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 61.219.70.172