sql tables created

2 files changed, 35 insertions, 0 deletions

diff --git a/server/sql/init.sql b/server/sql/init.sql
new file mode 100644
index 0000000..4fa490a
--- /dev/null
+++ b/server/sql/init.sql
@@ -0,0 +1,32 @@
+
+-- run as 'vh4x0r'@'localhost' identified by 'vh4x0r'
+use gentoostats;
+
+drop table if exists hosts;
+create table hosts (
+  uuid varchar (40) primary key,
+  passwd varchar (40) not null
+);
+
+drop table if exists env;
+create table env (
+  uuid varchar (40) references hosts.uuid,
+  var varchar (15) not null,
+  value varchar (100),
+  primary key (uuid, var)
+);
+
+drop table if exists packages;
+create table packages (
+  cat varchar (20) not null,
+  pkg varchar (20) not null,
+  ver varchar (20) not null,
+  pkey serial primary key
+);
+
+drop table if exists useflags;
+create table useflags (
+  uuid varchar (40) references host.uuid,
+  useflag varchar (20) not null,
+  pkey serial references packages.pkey
+);
diff --git a/server/sql/setup.sql b/server/sql/setup.sql
new file mode 100644
index 0000000..98126d7
--- /dev/null
+++ b/server/sql/setup.sql
@@ -0,0 +1,3 @@
+-- run as root
+create database gentoostats;
+grant all on gentoostats.* to 'vh4x0r'@'localhost' identified by 'vh4x0r';