Add table definitions for access table to replace GDBM database.

interchange · Aug 13, 2010 · 10ca21a · 10ca21a
1 parent f8df89f
commit 10ca21a
Show file tree

Hide file tree

Showing 2 changed files with 54 additions and 0 deletions.
diff --git a/database/mysql/access.sql 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
@@ -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)
+);
+
+