add nice admin_users

[wfpl-cms.git] / admin_users.sql

diff --git a/admin_users.sql b/admin_users.sql
new file mode 100644 (file)
index 0000000..08f0071
--- /dev/null
+++ b/admin_users.sql
@@ -0,0 +1,10 @@
+drop table if exists users;
+create table users (
+       id int unique auto_increment,
+       name varchar(200) binary not null default "",
+       username varchar(200) binary not null default "",
+       password varchar(255) binary not null default "",
+       role varchar(200) binary not null default "",
+       last_active int(11) not null default 0,
+       last_login int(11) not null default 0
+) CHARSET=utf8;