X-Git-Url: https://defaria.com/gitweb/?a=blobdiff_plain;f=etc%2Fmachines.sql;fp=etc%2Fmachines.sql;h=3691e75bfdff51a05f6d7f1160a94ae7b99145e9;hb=ed7943b5913aae90452e00009a19aaa86605b820;hp=0000000000000000000000000000000000000000;hpb=4c24c2eea11a8cc408126ab1da3bfd08ff2232de;p=clearscm.git

diff --git a/etc/machines.sql b/etc/machines.sql
new file mode 100644
index 0000000..3691e75
--- /dev/null
+++ b/etc/machines.sql
@@ -0,0 +1,62 @@
+-- -----------------------------------------------------------------------------
+--
+-- File:        $RCSfile: Machines.sql,v $
+-- Revision:    $Revision: 1.$
+-- Description: Create the Machines database
+-- Author:      Andrew@DeFaria.com
+-- Created:     Fri, Jul 13, 2018 10:51:18 AM
+-- Modified:    $Date: $
+-- Language:    SQL
+--
+-- Copyright (c) 2010, ClearSCM, Inc., all rights reserved
+--
+-- -----------------------------------------------------------------------------
+-- Warning: The following line will delete the old database!
+-- drop database if exists machines;
+
+-- Create a new database
+create database machines;
+
+-- Now let's focus on this new database
+use machines;
+
+-- system: Define what makes up a system or machine
+create table system (
+  name             varchar (255) not null,
+  model            tinytext,
+  alias            varchar (255),
+  active           enum (
+                     'true',
+                     'false'
+                   ) not null default 'true',
+  admin            tinytext,
+  email            tinytext,
+  os               tinytext,
+  ccver            tinytext,
+  type             enum (
+                     'Linux',
+                     'Unix',
+                     'Windows',
+                     'Mac'
+                   ) not null,
+  lastheardfrom    datetime,
+  description      text,
+
+  primary key (name)
+) engine=innodb; -- system
+
+-- package: A package is any software package that we wish to keep track of
+create table package (
+  system      varchar (255) not null,
+  name        varchar (255) not null,
+  version     tinytext not null,
+  vendor      tinytext,
+  description text,
+
+  key packageIndex (name),
+  key systemIndex (system),
+  foreign key systemLink (system) references system (name)
+    on delete cascade
+    on update cascade,
+  primary key (system, name)
+) engine=innodb; -- package