summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAndreas Baumann <mail@andreasbaumann.cc>2015-04-18 14:32:27 +0200
committerAndreas Baumann <mail@andreasbaumann.cc>2015-04-18 14:32:27 +0200
commit84a3e2f6bcb4da4ab156e39d79f0f8a36c2a0e90 (patch)
treea84f9620a087c3a2d924e5a14b404a88c0186d29 /sql
parentde50c30a936b87d79f816790230856347b0dff7e (diff)
downloadaCms-84a3e2f6bcb4da4ab156e39d79f0f8a36c2a0e90.tar.gz
aCms-84a3e2f6bcb4da4ab156e39d79f0f8a36c2a0e90.tar.bz2
added placeholders for directories
added user app and content (empty for now) added storage and sqlite script
Diffstat (limited to 'sql')
-rw-r--r--sql/sqlite3.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/sqlite3.sql b/sql/sqlite3.sql
new file mode 100644
index 0000000..e524ce6
--- /dev/null
+++ b/sql/sqlite3.sql
@@ -0,0 +1,7 @@
+drop table if exists users;
+
+create table users(
+ id integer primary key autoincrement not null,
+ username varchar(32) unique not null,
+ password varchar(32) not null
+);