[wellwell-devel] [wellwell] Add table definitions for access table to replace GDBM database.

[Stefan Hornburg]

commit 10ca21a0409f4105f39d672a12f154e7c7e537ca
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri Aug 13 10:46:57 2010 +0200

    Add table definitions for access table to replace GDBM database.

 database/mysql/access.sql |   29 +++++++++++++++++++++++++++++
 database/pgsql/access.sql |   25 +++++++++++++++++++++++++
 2 files changed, 54 insertions(+), 0 deletions(-)
---
diff --git a/database/mysql/access.sql b/database/mysql/access.sql
new file mode 100644
index 0000000..489d3ab
--- /dev/null
+++ b/database/mysql/access.sql
@@ -0,0 +1,29 @@
+--
+-- Table structure for table `access`
+--
+
+CREATE TABLE access (
+  username varchar(255) NOT NULL default '',
+  password varchar(255) default NULL,
+  name varchar(255) default NULL,
+  last_login timestamp(14) NOT NULL,
+  super int(1) default NULL,
+  yes_tables text,
+  no_tables text,
+  upload varchar(255) default NULL,
+  acl varchar(255) default NULL,
+  export varchar(255) default NULL,
+  edit varchar(255) default NULL,
+  pages varchar(255) default NULL,
+  files varchar(255) default NULL,
+  config int(1) default NULL,
+  reconfig int(1) default NULL,
+  meta int(1) default NULL,
+  no_functions text,
+  yes_functions text,
+  table_control text,
+  startpage text,
+  PRIMARY KEY  (username)
+) TYPE=MyISAM;
+
+
diff --git a/database/pgsql/access.sql b/database/pgsql/access.sql
new file mode 100644
index 0000000..7db1adc
--- /dev/null
+++ b/database/pgsql/access.sql
@@ -0,0 +1,25 @@
+CREATE TABLE access (
+  username varchar(255) NOT NULL default '',
+  password varchar(255) default NULL,
+  name varchar(255) default NULL,
+  last_login integer NOT NULL DEFAULT 0,
+  super integer default NULL,
+  yes_tables text,
+  no_tables text,
+  upload varchar(255) default NULL,
+  acl varchar(255) default NULL,
+  export varchar(255) default NULL,
+  edit varchar(255) default NULL,
+  pages varchar(255) default NULL,
+  files varchar(255) default NULL,
+  config integer default NULL,
+  reconfig integer default NULL,
+  meta integer default NULL,
+  no_functions text,
+  yes_functions text,
+  table_control text,
+  startpage text,
+  PRIMARY KEY  (username)
+);
+
+