Some cosmetic edits

[clearscm.git] / etc / machines.sql

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