From 3694170c2e81e735ea3376108e2ef40d203c4e0f Mon Sep 17 00:00:00 2001
From: Carl N Baldwin <cnb@plane.(none)>
Date: Sat, 15 Oct 2005 22:00:41 -0600
Subject: [PATCH] Adding sql schema file

---
 Makefile.am | 4 +++-
 schema.sql  | 9 +++++++++
 2 files changed, 12 insertions(+), 1 deletion(-)
 create mode 100644 schema.sql

diff --git a/Makefile.am b/Makefile.am
index a9d90e3..30391e1 100644
--- a/Makefile.am
+++ b/Makefile.am
@@ -2,7 +2,9 @@ bin_PROGRAMS = lsbackups
 
 bin_SCRIPTS = find-cmd.sh
 
-EXTRA_DIST = $(bin_SCRIPTS)
+schema_files = schema.sql
+
+EXTRA_DIST = $(bin_SCRIPTS) $(schema_files)
 
 lsbackups_SOURCES = main.cc \
                     filedata.hpp \
diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..d1515d9
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,9 @@
+CREATE TABLE file (
+  CHAR type,
+  VARCHAR permissions,
+  VARCHAR user,
+  VARCHAR group,
+  INTEGER size,
+  INTEGER modified_date,
+  VARCHAR name
+)
-- 
2.34.1