-
아임포트 API 결제시스템 적용 (개발자용 테스트, 실제 적용 X)
https://www.youtube.com/watch?v=jTGl9vEyzMo&feature=youtu.be
alter session set "_ORACLE_SCRIPT"=true;
CREATE USER monami IDENTIFIED BY bitc5600;
GRANT CREATE SESSION TO monami;
GRANT CREATE TABLESPACE TO monami;
GRANT CREATE TABLE TO monami;
GRANT CREATE SEQUENCE TO monami;
alter user monami default tablespace users quota unlimited on users;
CREATE TABLE users(
id number primary key,
username varchar2(100) not null unique,
password varchar2(100) not null,
phonenumber varchar2(20) not null,
email varchar2(100) not null,
address varchar2(100) not null,
userProfile varchar2(200),
userRole varchar2(20),
createDate timestamp
) ;
CREATE TABLE items(
id number primary key,
imgUrl varchar2(300),
name varchar2(200),
price varchar2(100),
tag VARCHAR2(100),
value VARCHAR2(100),
BODYCOLOR VARCHAR2(4000),
INKCOLOR VARCHAR2(4000),
PRODUCTSPEC VARCHAR2(4000),
CHARAC VARCHAR2(500),
MAINCHARAC VARCHAR2(500),
DETAILIMGURL VARCHAR2(300)
);
CREATE TABLE cart(
id number primary key,
userId number,
itemId number,
amount number
);
CREATE TABLE class(
id number primary key,
imgUrl VARCHAR2(4000),
aLink VARCHAR2(4000)
);
CREATE SEQUENCE USERS_SEQ
START WITH 1
INCREMENT BY 1;
CREATE SEQUENCE ITEMS_SEQ
START WITH 1
INCREMENT BY 1;
CREATE SEQUENCE CART_SEQ
START WITH 1
INCREMENT BY 1;
CREATE SEQUENCE CLASS_SEQ
START WITH 1
INCREMENT BY 1;