Skip to content
Browse files

Move soap_methods to main schema, so plugins can install into it easi…

…ly enough, even if it is not going to be used, as it might be added later, and produces errors if it is not there.
  • Loading branch information...
1 parent 903fb4f commit 340f93dbb02a1feaa343a348a891c2cb28b22331 @pudge pudge committed Jun 25, 2003
Showing with 27 additions and 0 deletions.
  1. +17 −0 sql/mysql/slashschema_create.sql
  2. +10 −0 sql/mysql/upgrades
View
17 sql/mysql/slashschema_create.sql
@@ -671,6 +671,23 @@ CREATE TABLE section_topics (
PRIMARY KEY (section,type,tid)
) TYPE=InnoDB;
+
+#
+# Table structure for table 'soap_methods'
+#
+
+DROP TABLE IF EXISTS soap_methods;
+CREATE TABLE soap_methods (
+ id MEDIUMINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
+ class VARCHAR(100) NOT NULL,
+ method VARCHAR(100) NOT NULL,
+ seclev MEDIUMINT DEFAULT 1000 NOT NULL,
+ subscriber_only TINYINT DEFAULT 0 NOT NULL,
+ formkeys VARCHAR(255) DEFAULT '' NOT NULL,
+ PRIMARY KEY (id),
+ UNIQUE soap_method(class, method)
+);
+
#
# Table structure for table 'subsections'
#
View
10 sql/mysql/upgrades
@@ -1564,3 +1564,13 @@ ALTER TABLE story_topics ADD UNIQUE sid_tid (sid,tid);
INSERT INTO story_topics SELECT "", sid, tid, "no" FROM stories;
ALTER TABLE story_topics DROP INDEX sid_tid;
+CREATE TABLE IF NOT EXISTS soap_methods (
+ id MEDIUMINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
+ class VARCHAR(100) NOT NULL,
+ method VARCHAR(100) NOT NULL,
+ seclev MEDIUMINT DEFAULT 1000 NOT NULL,
+ subscriber_only TINYINT DEFAULT 0 NOT NULL,
+ formkeys VARCHAR(255) DEFAULT '' NOT NULL,
+ PRIMARY KEY (id),
+ UNIQUE soap_method(class, method)
+);

0 comments on commit 340f93d

Please sign in to comment.
Something went wrong with that request. Please try again.