Changeset 498

Timestamp:

02/22/06 00:24:13 (7 years ago)

Author:

anarcat

Message:

[project @ alternc: changeset 2005-01-18 22:18:57 by anarcat]
add persistent variables storage db structure

Original author: anarcat
Date: 2005-01-18 22:18:57

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.29 2005/01/13 18:17:00 anarcat Exp $
+# $Id: mysql.sql,v 1.30 2005/01/18 22:18:57 anarcat Exp $
 # ----------------------------------------------------------------------
 # AlternC - Web Hosting System
@@ -373 +373 @@
 INSERT IGNORE INTO tld VALUES ('asso.fr', 4);
 
+--
+-- Table structure for table 'variable'
+--
+-- Taken from http://cvs.drupal.org/viewcvs/drupal/drupal/database/database.mysql?rev=1.164&view=auto
+--
+
+CREATE TABLE variable (
+  name varchar(48) NOT NULL default '',
+  value longtext NOT NULL,
+  PRIMARY KEY  (name)
+) TYPE=MyISAM;

install/scripts/upgrades/0.9.3.sql

@@ -2 +2 @@
 INSERT IGNORE INTO tld VALUES ('it', 1);
 INSERT IGNORE INTO tld VALUES ('ws', 1);
+
+-- add the new variable table
+CREATE TABLE variable (
+  name varchar(48) NOT NULL default '',
+  value longtext NOT NULL,
+  PRIMARY KEY  (name)
+) TYPE=MyISAM;
 
 USE mysql;