[wellwell-devel] [wellwell/zoom] Add table definitions for access table to replace GDBM database.
Stefan Hornburg
wellwell-devel at rt.icdevgroup.org
Wed Sep 15 10:46:15 UTC 2010
commit add85d9a48191b8d1e96a72d23c3dba73f5388da
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)
+);
+
+
More information about the wellwell-devel
mailing list