23 lines
755 B
SQL
23 lines
755 B
SQL
Create Database If Not Exists glusterfs Character Set UTF8;
|
|
USE glusterfs;
|
|
CREATE TABLE IF NOT EXISTS operateDataTasks (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`sourcePath` varchar(255) DEFAULT NULL,
|
|
`destPath` varchar(255) DEFAULT NULL,
|
|
`status` int(5) NOT NULL,
|
|
`allSize` bigint(20) DEFAULT NULL,
|
|
`completedSize` bigint(20) DEFAULT NULL,
|
|
`progress` int(11) NOT NULL,
|
|
`removePath` varchar(255) DEFAULT NULL,
|
|
`startTime` datetime NULL ,
|
|
`endTime` datetime NULL ,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
CREATE TABLE IF NOT EXISTS mountRecords (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`volumeName` varchar(255) NULL ,
|
|
`mountPoint` varchar(255) NULL ,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|