DROP TABLE TABLE_IPU_MEMBER;
CREATE TABLE TABLE_IPU_MEMBER (
  STAFF_ID number(9,0) PRIMARY KEY,
  STAFF_NAME varchar(64) default NULL,
  PASSWORD varchar(10) default NULL
);
INSERT INTO TABLE_IPU_MEMBER VALUES (66009, '黄波', '000000');
INSERT INTO TABLE_IPU_MEMBER VALUES (71335, '阳彪', '123456');
COMMIT;
SELECT * FROM TABLE_IPU_MEMBER;


========================================================================

DROP TABLE TABLE_IPU_TEST;
DROP SEQUENCE SEQ_IPU_TEST;
CREATE SEQUENCE SEQ_IPU_TEST INCREMENT BY 1 START WITH 1 NOMAXvalue NOCYCLE CACHE 10; 
CREATE TABLE TABLE_IPU_TEST (
  UUID number(9,0),
  STAFF_NAME varchar(64) default NULL,
  CREATE_TIME date 
);
INSERT INTO TABLE_IPU_TEST VALUES (SEQ_IPU_TEST.NEXTVAL, '黄波',to_date('2015-01-02 11:20:20','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO TABLE_IPU_TEST VALUES (SEQ_IPU_TEST.NEXTVAL, '阳彪', to_date('2015-02-03 12:22:23','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO TABLE_IPU_TEST VALUES (SEQ_IPU_TEST.NEXTVAL, '李四', to_date('2013-02-03 13:24:23','YYYY-MM-DD HH24:MI:SS'));
COMMIT;
SELECT * FROM TABLE_IPU_TEST;
