CREATE TABLE IF NOT EXISTS
`def_package_snapshot` (
`Guid` VARCHAR(64) NOT NULL,
`Package` VARCHAR(100) NOT NULL,
`SnapshotName` VARCHAR(255) NOT NULL,
`ThreeWords` VARCHAR(255) DEFAULT NULL,
`Description` TEXT DEFAULT NULL,
`CreatedAt` DATETIME
DEFAULT CURRENT_TIMESTAMP,
`CreatedBy` VARCHAR(255) DEFAULT NULL,
`TableCount` INT DEFAULT 0,
`TotalRows` BIGINT DEFAULT 0,
`Module` VARCHAR(255)
DEFAULT 'ObjPackage',
PRIMARY KEY (`Package`, `SnapshotName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS
`def_package_tables` (
`TableName` VARCHAR(255) NOT NULL,
`Package` VARCHAR(100) NOT NULL,
`TableType` VARCHAR(10)
DEFAULT 'DATA',
`Description` VARCHAR(255)
DEFAULT NULL,
`Module` VARCHAR(255)
DEFAULT 'ObjPackage',
PRIMARY KEY (`TableName`, `Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS
`def_package_snapshot_tables` (
`SnapshotName` VARCHAR(255) NOT NULL,
`Package` VARCHAR(100) NOT NULL,
`TableName` VARCHAR(255) NOT NULL,
`TableType` VARCHAR(10)
DEFAULT 'DATA',
`RowCount` INT DEFAULT 0,
`SnapshotTable` VARCHAR(255)
DEFAULT NULL,
`Module` VARCHAR(255)
DEFAULT 'ObjPackage',
PRIMARY KEY (
`SnapshotName`, `Package`, `TableName`
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci;