[問題]如何將 mysql schema轉到 oracle schema?
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
Database 近期熱門文章
PTT數位生活區 即時熱門文章
