1 -- -----------------------------------------------------------------------------
\r
3 -- File: $RCSfile: Machines.sql,v $
\r
4 -- Revision: $Revision: 1.$
\r
5 -- Description: Create the Machines database
\r
6 -- Author: Andrew@DeFaria.com
\r
7 -- Created: Fri, Jul 13, 2018 10:51:18 AM
\r
8 -- Modified: $Date: $
\r
11 -- Copyright (c) 2010, ClearSCM, Inc., all rights reserved
\r
13 -- -----------------------------------------------------------------------------
\r
14 -- Warning: The following line will delete the old database!
\r
15 -- drop database if exists machines;
\r
17 -- Create a new database
\r
18 create database machines;
\r
20 -- Now let's focus on this new database
\r
23 -- system: Define what makes up a system or machine
\r
24 create table system (
\r
25 name varchar (255) not null,
\r
28 alias varchar (255),
\r
32 ) not null default 'true',
\r
43 lastheardfrom datetime,
\r
47 ) engine=innodb; -- system
\r
49 -- package: A package is any software package that we wish to keep track of
\r
50 create table package (
\r
51 system varchar (255) not null,
\r
52 name varchar (255) not null,
\r
53 version tinytext not null,
\r
57 key packageIndex (name),
\r
58 key systemIndex (system),
\r
59 foreign key systemLink (system) references system (name)
\r
62 primary key (system, name)
\r
63 ) engine=innodb; -- package
\r