CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE MB_FILE(SID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,FILE_NAME VARCHAR(200),DATE_CREATE TIMESTAMP,FLAG_1 VARCHAR(200),FLAG_2 VARCHAR(200),FLAG_3 VARCHAR(200))
CREATE MEMORY TABLE MB_FILE_MAILLIST(SID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,FILE_SID INTEGER,DATE_CREATE TIMESTAMP,MAIL_ADDRESS VARCHAR(200),SH_ID INTEGER,FLAG_1 VARCHAR(200),FLAG_2 VARCHAR(200),FLAG_3 VARCHAR(200))
CREATE MEMORY TABLE MB_SENDER(SID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,PROFILE VARCHAR(200),MAIL_HOST VARCHAR(200),MAIL_USER_NAME VARCHAR(200),MAIL_PWD VARCHAR(200),DISP_NAME VARCHAR(200),MAIL_PORT VARCHAR(200),FLAG_1 VARCHAR(200),FLAG_2 VARCHAR(200),FLAG_3 VARCHAR(200))
CREATE MEMORY TABLE MB_MAIL_TEMPLATE(SID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,PROFILE VARCHAR(200),MAIL_SUBJECT VARCHAR(200),MAIL_CONTENT VARCHAR(200),FLAG_1 VARCHAR(200),FLAG_2 VARCHAR(200),FLAG_3 VARCHAR(200))
ALTER TABLE MB_FILE ALTER COLUMN SID RESTART WITH 0
ALTER TABLE MB_FILE_MAILLIST ALTER COLUMN SID RESTART WITH 0
ALTER TABLE MB_SENDER ALTER COLUMN SID RESTART WITH 0
ALTER TABLE MB_MAIL_TEMPLATE ALTER COLUMN SID RESTART WITH 3
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 10
SET SCHEMA PUBLIC
INSERT INTO MB_MAIL_TEMPLATE VALUES(2,'\u53d8\u91cf\u793a\u4f8b','{id},{date}\u6700\u65b0\u63a8\u51fa\u7684\u7fa4\u53d1\u8f6f\u4ef6''','{id},\u60a8\u597d\uff0c<br/>\u000a\u8fd9\u662f\u6d4b\u8bd5\u90ae\u4ef6\uff0c\u6765\u81ea\u4e16\u754c\u7684\u67d0\u4e2a\u89d2\u843d\uff01''<br/>\u000a<a href="http://www.anzhixin.com">\u5b89\u4e4b\u4fe1\u7f51\u7edc</a><br>\u000a{name}<br/>\u000a{time}',NULL,NULL,NULL)
