Changeset 1662

Timestamp:

Dec 16, 2006, 10:30:44 AM (17 years ago)

Author:

vdigital

Message:

Table structure for Web service

File:

• trunk/install/phpwebgallery_structure.sql (modified) (1 diff)

trunk/install/phpwebgallery_structure.sql

@@ -396 +396 @@
 ) TYPE=MyISAM;
 
+-- 
+-- Table structure for table `phpwebgallery_ws_access`
+-- 
+
+DROP TABLE IF EXISTS phpwebgallery_ws_access;
+CREATE TABLE phpwebgallery_ws_access (
+  id smallint(5) unsigned NOT NULL auto_increment,
+  name varchar(32) NOT NULL default '',
+  access varchar(255) default NULL,
+  `start` datetime default NULL,
+  `end` datetime default NULL,
+  request varchar(255) default NULL,
+  high enum('true','false') NOT NULL default 'true',
+  normal enum('true','false') NOT NULL default 'true',
+  `limit` smallint(5) unsigned default NULL,
+  `comment` varchar(255) default NULL,
+  PRIMARY KEY  (id),
+  UNIQUE KEY name (name)
+) ENGINE=MyISAM COMMENT='Access for Web Services';
+