mirror of
https://github.com/claunia/osrepodbmgr.git
synced 2025-12-16 11:04:26 +00:00
85 lines
7.5 KiB
C#
85 lines
7.5 KiB
C#
//
|
|
// Author:
|
|
// Natalia Portillo claunia@claunia.com
|
|
//
|
|
// Copyright (c) 2017, © Claunia.com
|
|
//
|
|
// All rights reserved.
|
|
//
|
|
// Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
|
|
//
|
|
// * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
|
|
// * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in
|
|
// the documentation and/or other materials provided with the distribution.
|
|
// * Neither the name of the [ORGANIZATION] nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
|
|
//
|
|
// THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
|
|
// "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
|
|
// LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
|
|
// A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
|
|
// CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
|
|
// EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
|
|
// PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
|
|
// PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF
|
|
// LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
|
|
// NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
|
|
// SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
|
|
//
|
|
|
|
namespace osrepodbmgr.Core
|
|
{
|
|
public static class Schema
|
|
{
|
|
public const string FilesTableSql = "-- -----------------------------------------------------\n" +
|
|
"-- Table `files`\n" +
|
|
"-- -----------------------------------------------------\n" +
|
|
"DROP TABLE IF EXISTS `files` ;\n\n" +
|
|
"CREATE TABLE IF NOT EXISTS `files` (\n" +
|
|
" `id` INTEGER PRIMARY KEY AUTOINCREMENT,\n" +
|
|
" `sha256` VARCHAR(64) NOT NULL,\n" +
|
|
" `crack` BOOLEAN NOT NULL,\n" +
|
|
" `hasvirus` BOOLEAN NULL,\n" +
|
|
" `clamtime` DATETIME NULL,\n" +
|
|
" `vtotaltime` DATETIME NULL,\n" +
|
|
" `virus` VARCHAR(128) NULL,\n" +
|
|
" `length` BIGINT NOT NULL);\n\n" +
|
|
"CREATE UNIQUE INDEX `files_id_UNIQUE` ON `files` (`id` ASC);\n\n" +
|
|
"CREATE UNIQUE INDEX `files_sha256_UNIQUE` ON `files` (`sha256` ASC);\n\n" +
|
|
"CREATE INDEX `files_hasvirus_idx` ON `files` (`hasvirus` ASC);\n\n" +
|
|
"CREATE INDEX `files_virus_idx` ON `files` (`virus` ASC);\n\n" +
|
|
"CREATE INDEX `files_length_idx` ON `files` (`length` ASC);";
|
|
|
|
public const string OSesTableSql = "-- -----------------------------------------------------\n" +
|
|
"-- Table `oses`\n" +
|
|
"-- -----------------------------------------------------\n" +
|
|
"DROP TABLE IF EXISTS `oses` ;\n\n" +
|
|
"CREATE TABLE IF NOT EXISTS `oses` (\n" +
|
|
" `id` INTEGER PRIMARY KEY AUTOINCREMENT,\n" +
|
|
" `mdid` CHAR(40) NOT NULL,\n" +
|
|
" `developer` VARCHAR(45) NOT NULL,\n" +
|
|
" `product` VARCHAR(45) NOT NULL,\n" +
|
|
" `version` VARCHAR(45) NULL,\n" +
|
|
" `languages` VARCHAR(45) NULL,\n" +
|
|
" `architecture` VARCHAR(45) NULL,\n" +
|
|
" `machine` VARCHAR(45) NULL,\n" +
|
|
" `format` VARCHAR(45) NULL,\n" +
|
|
" `description` VARCHAR(45) NULL,\n" +
|
|
" `oem` BOOLEAN NOT NULL,\n" +
|
|
" `upgrade` BOOLEAN NOT NULL,\n" +
|
|
" `update` BOOLEAN NOT NULL,\n" +
|
|
" `source` BOOLEAN NOT NULL,\n" +
|
|
" `files` BOOLEAN NOT NULL,\n" +
|
|
" `netinstall` BOOLEAN NOT NULL,\n" +
|
|
" `xml` BLOB NULL,\n" +
|
|
" `json` BLOB NULL);\n\n" +
|
|
"CREATE UNIQUE INDEX `oses_id_UNIQUE` ON `oses` (`id` ASC);\n\n" +
|
|
"CREATE UNIQUE INDEX `oses_mdid_UNIQUE` ON `oses` (`mdid` ASC);\n\n" +
|
|
"CREATE INDEX `oses_developer_idx` ON `oses` (`developer` ASC);\n\n" +
|
|
"CREATE INDEX `oses_product_idx` ON `oses` (`product` ASC);\n\n" +
|
|
"CREATE INDEX `oses_version_idx` ON `oses` (`version` ASC);\n\n" +
|
|
"CREATE INDEX `oses_architecture_idx` ON `oses` (`architecture` ASC);\n\n" +
|
|
"CREATE INDEX `oses_format_idx` ON `oses` (`format` ASC);\n\n" +
|
|
"CREATE INDEX `oses_machine_idx` ON `oses` (`machine` ASC);\n\n" +
|
|
"CREATE INDEX `oses_description_idx` ON `oses` (`description` ASC);";
|
|
}
|
|
} |