1.
CREATE TABLE dealtract_200303 (
dltMainID varchar2(32) NOT NULL ,
dltID varchar2(32) NOT NULL ,
dltDealUser varchar2(16) NOT NULL ,
dltDealTime date NOT NULL default '0000-00-00 00:00:00',
dltDealNottion varchar2(254),
dltDealDoc varchar2(254) default NULL,
dltDealEvent char(2) NOT NULL ,
dltNextOper varchar2(16) default NULL,
dltDelayFlag char(1) default NULL,
dltMemo varchar2(254),
PRIMARY KEY (dltID)
) TABLESPACE user2.
CREATE TABLE purviewcfg (
pvcID number(11) NOT NULL,
pvcMainID char(32) NOT NULL ,
pvcUserID char(16) default NULL,
pvcDeptID char(16) default NULL,
PRIMARY KEY (pvcID)
) TABLESPACE user3.
CREATE TABLE operbuf (
oprID varchar2(32) NOT NULL ,
oprStsid char(1) NOT NULL ,
oprNextOper varchar2(32) NOT NULL ,
oprCuroper varchar2(32) ,
oprWatcher varchar2(32) default NULL,
oprWatchtime date default NULL,
oprFlag char(1) NOT NULL default '0',
PRIMARY KEY (oprID)
) TABLESPACE user自增需要使用序列
CREATE TABLE dealtract_200303 (
dltMainID varchar2(32) NOT NULL ,
dltID varchar2(32) NOT NULL ,
dltDealUser varchar2(16) NOT NULL ,
dltDealTime date NOT NULL default '0000-00-00 00:00:00',
dltDealNottion varchar2(254),
dltDealDoc varchar2(254) default NULL,
dltDealEvent char(2) NOT NULL ,
dltNextOper varchar2(16) default NULL,
dltDelayFlag char(1) default NULL,
dltMemo varchar2(254),
PRIMARY KEY (dltID)
) TABLESPACE user2.
CREATE TABLE purviewcfg (
pvcID number(11) NOT NULL,
pvcMainID char(32) NOT NULL ,
pvcUserID char(16) default NULL,
pvcDeptID char(16) default NULL,
PRIMARY KEY (pvcID)
) TABLESPACE user3.
CREATE TABLE operbuf (
oprID varchar2(32) NOT NULL ,
oprStsid char(1) NOT NULL ,
oprNextOper varchar2(32) NOT NULL ,
oprCuroper varchar2(32) ,
oprWatcher varchar2(32) default NULL,
oprWatchtime date default NULL,
oprFlag char(1) NOT NULL default '0',
PRIMARY KEY (oprID)
) TABLESPACE user自增需要使用序列
2. remove auto_increment (search 自增长字段)
3. remove default