Changeset 508

Timestamp:

02/22/06 00:25:04 (7 years ago)

Author:

anarcat

Message:

[project @ alternc: changeset 2005-01-19 06:14:12 by anarcat]
add a default entry and comment for 'hosting_tld' so that it can be
configured through adm_variables.php

Original author: anarcat
Date: 2005-01-19 06:14:16

Location:

install/scripts

Files:

• mysql.sql (modified) (2 diffs)
• upgrades/0.9.3.sql (modified) (1 diff)

install/scripts/mysql.sql

@@ -1 +1 @@
 #
-# $Id: mysql.sql,v 1.30 2005/01/18 22:18:57 anarcat Exp $
+# $Id: mysql.sql,v 1.31 2005/01/19 06:14:16 anarcat Exp $
 # ----------------------------------------------------------------------
 # AlternC - Web Hosting System
@@ -378 +378 @@
 -- Taken from http://cvs.drupal.org/viewcvs/drupal/drupal/database/database.mysql?rev=1.164&view=auto
 --
-
+-- if comment is null, then the variable is internal and will not show
+-- up in the generic configuration panel
 CREATE TABLE variable (
   name varchar(48) NOT NULL default '',
   value longtext NOT NULL,
-  PRIMARY KEY  (name)
-) TYPE=MyISAM;
+  comment mediumtext NULL,
+  PRIMARY KEY  (name),
+  KEY name (name)
+) TYPE=MyISAM;
+
+-- hosting_tld: only used, for now, in bureau/admin/adm_*add.php
+INSERT INTO `variable` (name, value, comment) VALUES ('hosting_tld', 0,
+'This is a FQDN that designates the main hostname of the service.
+
+For example, hosting_tld determines in what TLD the "free" user domain
+is created. If this is set to "example.com", a checkbox will appear in
+the user creation dialog requesting the creator if he wants to create
+the domain "username.example.com".
+
+If this is set to 0 or a "false" string, it will be ignored.');

install/scripts/upgrades/0.9.3.sql

@@ -8 +8 @@
 
 -- add the new variable table
+--
+-- if comment is null, then the variable is internal and will not show
+-- up in the generic configuration panel
 CREATE TABLE variable (
   name varchar(48) NOT NULL default '',
   value longtext NOT NULL,
-  PRIMARY KEY  (name)
+  comment mediumtext NULL,
+  PRIMARY KEY  (name),
+  KEY name (name)
 ) TYPE=MyISAM;
+
+-- hosting_tld: only used, for now, in bureau/admin/adm_*add.php
+INSERT INTO `variable` (name, value, comment) VALUES ('hosting_tld', 0,
+'This is a FQDN that designates the main hostname of the service.
+
+For example, hosting_tld determines in what TLD the "free" user domain
+is created. If this is set to "example.com", a checkbox will appear in
+the user creation dialog requesting the creator if he wants to create
+the domain "username.example.com".
+
+If this is set to 0 or a "false" string, it will be ignored.');
 
 USE mysql;