schema.sql
author Dan
Sat, 02 Feb 2008 22:32:09 -0500
changeset 396 3289e4dcb4b8
parent 333 32429702305e
permissions -rw-r--r--
Fixed some stray undefined-variable problems revealed as a result of testing on Windows Server '03, IIS6, PHP/FastCGI, and PostgreSQL 8.2.5.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     1
-- Enano - an open-source CMS capable of wiki functions, Drupal-like sidebar blocks, and everything in between
149
42c6c83b8a00 Rebrand for 1.0.2 (again, lol)
Dan
parents: 123
diff changeset
     2
-- Version 1.0.2 (Coblynau)
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     3
-- Copyright (C) 2006-2007 Dan Fuhry
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     4
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     5
-- This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     6
-- as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     7
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     8
-- This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
     9
-- warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    10
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    11
-- schema.sql - MySQL installation schema. Firebird version in development.
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    12
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    13
CREATE TABLE {{TABLE_PREFIX}}categories(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    14
  page_id varchar(64),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    15
  namespace varchar(64),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    16
  category_id varchar(64)
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
    17
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    18
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    19
CREATE TABLE {{TABLE_PREFIX}}comments(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    20
  comment_id int(12) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    21
  page_id text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    22
  namespace text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    23
  subject text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    24
  comment_data text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    25
  name text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    26
  approved tinyint(1) default 1,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    27
  user_id mediumint(8) NOT NULL DEFAULT -1,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    28
  time int(12) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    29
  PRIMARY KEY ( comment_id )
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
    30
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    31
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    32
CREATE TABLE {{TABLE_PREFIX}}config(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    33
  config_name varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    34
  config_value text
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
    35
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    36
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    37
CREATE TABLE {{TABLE_PREFIX}}logs(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    38
  log_type varchar(16),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    39
  action varchar(16),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    40
  time_id int(12) NOT NULL default '0',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    41
  date_string varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    42
  page_id text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    43
  namespace text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    44
  page_text text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    45
  char_tag varchar(40),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    46
  author varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    47
  edit_summary text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    48
  minor_edit tinyint(1)
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
    49
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    50
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    51
CREATE TABLE {{TABLE_PREFIX}}page_text(
285
7846d45bd250 Changed all urlname/page_id columns to varchar(255) because 63 characters just isn't long enough
Dan
parents: 275
diff changeset
    52
  page_id varchar(255),
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    53
  namespace varchar(16) NOT NULL default 'Article',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    54
  page_text text,
264
0fe1f610698d Well I'm an idiot - the fulltext index on page_text was missing from a default installation. It didn't break searches but probably slowed them down tremendously. Also set engine to MyISAM on page_text to avoid cryptic error messages from MySQL.
Dan
parents: 261
diff changeset
    55
  char_tag varchar(63),
0fe1f610698d Well I'm an idiot - the fulltext index on page_text was missing from a default installation. It didn't break searches but probably slowed them down tremendously. Also set engine to MyISAM on page_text to avoid cryptic error messages from MySQL.
Dan
parents: 261
diff changeset
    56
  FULLTEXT KEY {{TABLE_PREFIX}}page_search_idx (page_id, namespace, page_text)
0fe1f610698d Well I'm an idiot - the fulltext index on page_text was missing from a default installation. It didn't break searches but probably slowed them down tremendously. Also set engine to MyISAM on page_text to avoid cryptic error messages from MySQL.
Dan
parents: 261
diff changeset
    57
) ENGINE = MYISAM CHARACTER SET `utf8`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    58
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    59
CREATE TABLE {{TABLE_PREFIX}}pages(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    60
  page_order int(8),
285
7846d45bd250 Changed all urlname/page_id columns to varchar(255) because 63 characters just isn't long enough
Dan
parents: 275
diff changeset
    61
  name varchar(255),
7846d45bd250 Changed all urlname/page_id columns to varchar(255) because 63 characters just isn't long enough
Dan
parents: 275
diff changeset
    62
  urlname varchar(255),
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    63
  namespace varchar(16) NOT NULL default 'Article',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    64
  special tinyint(1) default '0',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    65
  visible tinyint(1) default '1',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    66
  comments_on tinyint(1) default '1',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    67
  protected tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    68
  wiki_mode tinyint(1) NOT NULL DEFAULT 2,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    69
  delvotes int(10) NOT NULL default 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    70
  password varchar(40) NOT NULL DEFAULT '',
107
4042c4dd5ba4 Synched installation schema to upgrade schema for delvote_ips
Dan
parents: 94
diff changeset
    71
  delvote_ips text DEFAULT NULL
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
    72
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    73
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    74
CREATE TABLE {{TABLE_PREFIX}}session_keys(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    75
  session_key varchar(32),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    76
  salt varchar(32),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    77
  user_id mediumint(8),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    78
  auth_level tinyint(1) NOT NULL default '0',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    79
  source_ip varchar(10) default '0x7f000001',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    80
  time bigint(15) default '0'
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
    81
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    82
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    83
CREATE TABLE {{TABLE_PREFIX}}themes(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    84
  theme_id varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    85
  theme_name text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    86
  theme_order smallint(5) NOT NULL default '1',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    87
  default_style varchar(63) NOT NULL DEFAULT '',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    88
  enabled tinyint(1) NOT NULL default '1'
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
    89
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    90
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    91
CREATE TABLE {{TABLE_PREFIX}}users(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    92
  user_id mediumint(8) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    93
  username text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    94
  password varchar(255),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    95
  email text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    96
  real_name text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    97
  user_level tinyint(1) NOT NULL default 2,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    98
  theme varchar(64) NOT NULL default 'bleu.css',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
    99
  style varchar(64) NOT NULL default 'default',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   100
  signature text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   101
  reg_time int(11) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   102
  account_active tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   103
  activation_key varchar(40) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   104
  old_encryption tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   105
  temp_password text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   106
  temp_password_time int(12) NOT NULL DEFAULT 0,
30
7e8fd44b36b0 COPPA support added
Dan
parents: 27
diff changeset
   107
  user_coppa tinyint(1) NOT NULL DEFAULT 0,
209
8a00247d1dee Login page mostly localized
Dan
parents: 205
diff changeset
   108
  user_lang smallint(5) NOT NULL,
333
32429702305e Fix missing avatar-related columns in users table
Dan
parents: 304
diff changeset
   109
  user_has_avatar tinyint(1) NOT NULL,
32429702305e Fix missing avatar-related columns in users table
Dan
parents: 304
diff changeset
   110
  avatar_type ENUM('jpg', 'png', 'gif') NOT NULL,
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   111
  PRIMARY KEY  (user_id)
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   112
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   113
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   114
CREATE TABLE {{TABLE_PREFIX}}users_extra(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   115
  user_id mediumint(8) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   116
  user_aim varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   117
  user_yahoo varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   118
  user_msn varchar(255),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   119
  user_xmpp varchar(255),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   120
  user_homepage text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   121
  user_location text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   122
  user_job text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   123
  user_hobbies text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   124
  email_public tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   125
  PRIMARY KEY ( user_id ) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   126
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   127
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   128
CREATE TABLE {{TABLE_PREFIX}}banlist(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   129
  ban_id mediumint(8) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   130
  ban_type tinyint(1),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   131
  ban_value varchar(64),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   132
  is_regex tinyint(1) DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   133
  reason text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   134
  PRIMARY KEY ( ban_id ) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   135
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   136
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   137
CREATE TABLE {{TABLE_PREFIX}}files(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   138
  file_id int(12) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   139
  time_id int(12) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   140
  page_id varchar(63) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   141
  filename varchar(127) default NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   142
  size bigint(15) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   143
  mimetype varchar(63) default NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   144
  file_extension varchar(8) default NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   145
  file_key varchar(32) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   146
  PRIMARY KEY (file_id) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   147
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   148
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   149
CREATE TABLE {{TABLE_PREFIX}}buddies(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   150
  buddy_id int(15) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   151
  user_id mediumint(8),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   152
  buddy_user_id mediumint(8),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   153
  is_friend tinyint(1) NOT NULL default '1',
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   154
  PRIMARY KEY  (buddy_id) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   155
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   156
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   157
CREATE TABLE {{TABLE_PREFIX}}privmsgs(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   158
  message_id int(15) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   159
  message_from varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   160
  message_to varchar(255),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   161
  date int(12),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   162
  subject varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   163
  message_text text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   164
  folder_name varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   165
  message_read tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   166
  PRIMARY KEY  (message_id) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   167
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   168
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   169
CREATE TABLE {{TABLE_PREFIX}}sidebar(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   170
  item_id smallint(3) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   171
  item_order smallint(3) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   172
  item_enabled tinyint(1) NOT NULL DEFAULT 1,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   173
  sidebar_id smallint(3) NOT NULL DEFAULT 1,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   174
  block_name varchar(63) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   175
  block_type tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   176
  block_content text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   177
  PRIMARY KEY ( item_id )
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   178
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   179
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   180
CREATE TABLE {{TABLE_PREFIX}}hits(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   181
  hit_id bigint(20) NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   182
  username varchar(63) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   183
  time int(12) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   184
  page_id varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   185
  namespace varchar(63),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   186
  PRIMARY KEY ( hit_id ) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   187
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   188
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   189
CREATE TABLE {{TABLE_PREFIX}}search_index(
275
956263992d48 Re-add search_results hook and changed column type of search_index.word to varchar(64) in installer schema
Dan
parents: 272
diff changeset
   190
  word varchar(64) NOT NULL,
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   191
  page_names text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   192
  PRIMARY KEY ( word ) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   193
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   194
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   195
CREATE TABLE {{TABLE_PREFIX}}groups(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   196
  group_id mediumint(5) UNSIGNED NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   197
  group_name varchar(64),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   198
  group_type tinyint(1) NOT NULL DEFAULT 1,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   199
  PRIMARY KEY ( group_id ),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   200
  system_group tinyint(1) NOT NULL DEFAULT 0 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   201
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   202
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   203
CREATE TABLE {{TABLE_PREFIX}}group_members(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   204
  member_id int(12) UNSIGNED NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   205
  group_id mediumint(5) UNSIGNED NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   206
  user_id int(12) NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   207
  is_mod tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   208
  pending tinyint(1) NOT NULL DEFAULT 0,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   209
  PRIMARY KEY ( member_id ) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   210
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   211
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   212
CREATE TABLE {{TABLE_PREFIX}}acl(
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   213
  rule_id int(12) UNSIGNED NOT NULL auto_increment,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   214
  target_type tinyint(1) UNSIGNED NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   215
  target_id int(12) UNSIGNED NOT NULL,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   216
  page_id varchar(255),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   217
  namespace varchar(24),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   218
  rules text,
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   219
  PRIMARY KEY ( rule_id ) 
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   220
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   221
73
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   222
-- Added in 1.0.1
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   223
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   224
CREATE TABLE {{TABLE_PREFIX}}page_groups(
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   225
  pg_id mediumint(8) NOT NULL auto_increment,
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   226
  pg_type tinyint(2) NOT NULL DEFAULT 1,
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   227
  pg_name varchar(255) NOT NULL DEFAULT '',
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   228
  pg_target varchar(255) DEFAULT NULL,
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   229
  PRIMARY KEY ( pg_id )
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   230
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
73
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   231
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   232
-- Added in 1.0.1
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   233
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   234
CREATE TABLE {{TABLE_PREFIX}}page_group_members(
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   235
  pg_member_id int(12) NOT NULL auto_increment,
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   236
  pg_id mediumint(8) NOT NULL,
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   237
  page_id varchar(63) NOT NULL,
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   238
  namespace varchar(63) NOT NULL DEFAULT 'Article',
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   239
  PRIMARY KEY ( pg_member_id )
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   240
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
73
0a74676a2f2f Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
parents: 69
diff changeset
   241
76
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   242
-- Added in 1.0.1
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   243
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   244
CREATE TABLE {{TABLE_PREFIX}}tags(
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   245
  tag_id int(12) NOT NULL auto_increment,
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   246
  tag_name varchar(63) NOT NULL DEFAULT 'bla',
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   247
  page_id varchar(255) NOT NULL,
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   248
  namespace varchar(255) NOT NULL,
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   249
  user mediumint(8) NOT NULL DEFAULT 1,
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   250
  PRIMARY KEY ( tag_id )
272
e0ec986c0af3 Searching sucks, and Enano's search algorithm was complete bullcrap. So I rewrote it. No, it does not use Google search technology. Like they have a patent for using the Arial font on search result pages anyway.
Dan
parents: 264
diff changeset
   251
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
76
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   252
179
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   253
-- Added in 1.1.1
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   254
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   255
CREATE TABLE {{TABLE_PREFIX}}lockout(
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   256
  id int(12) NOT NULL auto_increment,
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   257
  ipaddr varchar(40) NOT NULL,
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   258
  action ENUM('credential', 'level') NOT NULL DEFAULT 'credential',
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   259
  timestamp int(12) NOT NULL DEFAULT 0,
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   260
  PRIMARY KEY ( id )
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   261
) CHARACTER SET `utf8`;
36b287f1d85c [F] Added support for account lockouts. User is locked out or required to complete a CAPTCHA after specified threshold for specified period.
Dan
parents: 153
diff changeset
   262
205
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   263
-- Added in 1.1.1
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   264
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   265
CREATE TABLE {{TABLE_PREFIX}}language(
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   266
  lang_id smallint(5) NOT NULL auto_increment,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   267
  lang_code varchar(16) NOT NULL,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   268
  lang_name_default varchar(64) NOT NULL,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   269
  lang_name_native varchar(64) NOT NULL,
210
2b283402e4e4 Added language export to JSON page and localization for Javascript using $lang.get(). Localized AJAX login interface.
Dan
parents: 209
diff changeset
   270
  last_changed int(12) NOT NULL DEFAULT 0,
205
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   271
  PRIMARY KEY ( lang_id )
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   272
) CHARACTER SET `utf8`;
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   273
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   274
-- Added in 1.1.1
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   275
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   276
CREATE TABLE {{TABLE_PREFIX}}language_strings(
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   277
  string_id bigint(15) NOT NULL auto_increment,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   278
  lang_id smallint(5) NOT NULL,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   279
  string_category varchar(32) NOT NULL,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   280
  string_name varchar(64) NOT NULL,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   281
  string_content longtext NOT NULL,
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   282
  PRIMARY KEY ( string_id )
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   283
);
c4542792db2b Localization low-level framework added
Dan
parents: 180
diff changeset
   284
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   285
INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   286
  ('site_name', '{{SITE_NAME}}'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   287
  ('main_page', 'Main_Page'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   288
  ('site_desc', '{{SITE_DESC}}'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   289
  ('wiki_mode', '{{WIKI_MODE}}'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   290
  ('wiki_edit_notice', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   291
  ('sflogo_enabled', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   292
  ('sflogo_groupid', ''),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   293
  ('sflogo_type', '1'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   294
  ('w3c_vh32', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   295
  ('w3c_vh40', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   296
  ('w3c_vh401', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   297
  ('w3c_vxhtml10', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   298
  ('w3c_vxhtml11', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   299
  ('w3c_vcss', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   300
  ('approve_comments', '0'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   301
  ('enable_comments', '1'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   302
  ('plugin_SpecialAdmin.php', '1'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   303
  ('plugin_SpecialPageFuncs.php', '1'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   304
  ('plugin_SpecialUserFuncs.php', '1'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   305
  ('plugin_SpecialCSS.php', '1'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   306
  ('copyright_notice', '{{COPYRIGHT}}'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   307
  ('wiki_edit_notice_text', '== Why can I edit this page? ==\n\nEveryone can edit almost any page in this website. This concept is called a wiki. It gives everyone the opportunity to make a change for the best. While some spam and vandalism may occur, it is believed that most contributions will be legitimate and helpful.\n\nFor security purposes, a history of all page edits is kept, and administrators are able to restore vandalized or spammed pages with just a few clicks.'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   308
  ('cache_thumbs', '{{ENABLE_CACHE}}'),
297
ee1fc84f12a8 SECURITY: Tighten default allowed file types; make sure search index rebuild is performed on upgrade
Dan
parents: 285
diff changeset
   309
  ('max_file_size', '256000'),('enano_version', '{{VERSION}}'),( 'allowed_mime_types', 'cbf:len=185;crc=55fb6f14;data=0[1],1[4],0[3],1[1],0[22],1[1],0[16],1[3],0[16],1[1],0[1],1[2],0[6],1[1],0[1],1[1],0[4],1[2],0[3],1[1],0[48],1[2],0[2],1[1],0[4],1[1],0[37]|end' ),
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   310
  ('contact_email', '{{ADMIN_EMAIL}}'),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   311
  ('powered_btn', '1');
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   312
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   313
INSERT INTO {{TABLE_PREFIX}}page_text(page_id, namespace, page_text, char_tag) VALUES
266
917dcc6c4ceb Merging in fixes from stable
Dan
parents: 253 264
diff changeset
   314
  ('Main_Page', 'Article', '=== Enano has been successfully installed and is working. ===\n\nIf you can see this message, it means that you\'ve finished the Enano setup process and are ready to start building your website. Congratulations!\n\nTo edit this front page, click the Log In button to the left, enter the credentials you provided during the installation, and click the Edit This Page button that appears on the blue toolbar just above this text. You can also [http://docs.enanocms.org/Help:2.4 learn more] about editing pages.\n\nTo create more pages, use the Create a Page button to the left. If you enabled wiki mode, you don\'t have to log in first, however your IP address will be shown in the page history.\n\nVisit the [http://docs.enanocms.org/Help:Contents Enano documentation project website] to learn more about administering your site effectively and keeping things secure.\n\n\'\'\'NOTE:\'\'\' You\'ve just installed an unstable version of Enano. This release is completely unsupported and may contain security issues or serious usability bugs. You should not use this release on a production website. The Enano team will not provide any type of support at all for this experimental release.', '');
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   315
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   316
INSERT INTO {{TABLE_PREFIX}}pages(page_order, name, urlname, namespace, special, visible, comments_on, protected, delvotes, delvote_ips) VALUES
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   317
  (NULL, 'Main Page', 'Main_Page', 'Article', 0, 1, 1, 1, 0, '');
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   318
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   319
INSERT INTO {{TABLE_PREFIX}}themes(theme_id, theme_name, theme_order, default_style, enabled) VALUES
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   320
  ('oxygen', 'Oxygen', 1, 'bleu.css', 1),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   321
  ('stpatty', 'St. Patty', 2, 'shamrock.css', 1);
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   322
32
4d87aad3c4c0 Finished everything on the TODO list (yay!); several CSS cleanups; tons more changes in this commit - see the patch for details
Dan
parents: 30
diff changeset
   323
INSERT INTO {{TABLE_PREFIX}}users(user_id, username, password, email, real_name, user_level, theme, style, signature, reg_time, account_active) VALUES
4d87aad3c4c0 Finished everything on the TODO list (yay!); several CSS cleanups; tons more changes in this commit - see the patch for details
Dan
parents: 30
diff changeset
   324
  (1, 'Anonymous', 'invalid-pass-hash', 'anonspam@enanocms.org', 'None', 1, 'oxygen', 'bleu', '', 0, 0),
40
723bb7acf914 Fixed a lot of bugs with Safari and Konqueror; improved Opera compatibility
Dan
parents: 33
diff changeset
   325
  (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', UNIX_TIMESTAMP(), 1);
723bb7acf914 Fixed a lot of bugs with Safari and Konqueror; improved Opera compatibility
Dan
parents: 33
diff changeset
   326
  
32
4d87aad3c4c0 Finished everything on the TODO list (yay!); several CSS cleanups; tons more changes in this commit - see the patch for details
Dan
parents: 30
diff changeset
   327
INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
4d87aad3c4c0 Finished everything on the TODO list (yay!); several CSS cleanups; tons more changes in this commit - see the patch for details
Dan
parents: 30
diff changeset
   328
  (2);
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   329
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   330
INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   331
  (2,'Administrators',3,1),
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   332
  (3,'Moderators',3,1);
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   333
0
902822492a68 Initial population
dan@scribus.fuhry.local.fuhry.local
parents:
diff changeset
   334
INSERT INTO {{TABLE_PREFIX}}group_members(group_id,user_id,is_mod) VALUES(2, 2, 1);
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   335
240
f0149a27df5f Localized default sidebar; installer should work now including the lang import; l10n in installer to follow
Dan
parents: 228
diff changeset
   336
INSERT INTO {{TABLE_PREFIX}}acl(target_type,target_id,page_id,namespace,rules) VALUES
f0149a27df5f Localized default sidebar; installer should work now including the lang import; l10n in installer to follow
Dan
parents: 228
diff changeset
   337
  (1,2,NULL,NULL,'read=4;post_comments=4;edit_comments=4;edit_page=4;view_source=4;mod_comments=4;history_view=4;history_rollback=4;history_rollback_extra=4;protect=4;rename=4;clear_logs=4;vote_delete=4;vote_reset=4;delete_page=4;tag_create=4;tag_delete_own=4;tag_delete_other=4;set_wiki_mode=4;password_set=4;password_reset=4;mod_misc=4;edit_cat=4;even_when_protected=4;upload_files=4;upload_new_version=4;create_page=4;php_in_pages={{ADMIN_EMBED_PHP}};edit_acl=4;'),
27
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   338
  (1,3,NULL,NULL,'read=4;post_comments=4;edit_comments=4;edit_page=4;view_source=4;mod_comments=4;history_view=4;history_rollback=4;history_rollback_extra=4;protect=4;rename=3;clear_logs=2;vote_delete=4;vote_reset=4;delete_page=4;set_wiki_mode=2;password_set=2;password_reset=2;mod_misc=2;edit_cat=4;even_when_protected=4;upload_files=2;upload_new_version=3;create_page=3;php_in_pages=2;edit_acl=2;');
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   339
dd659f6ba891 Converting all tables on new installations to UTF-8; this may break MySQL 4.0 compatibility; several minor cosmetic fixes; set Powered button under Links to "on" by default
Dan
parents: 21
diff changeset
   340
INSERT INTO {{TABLE_PREFIX}}sidebar(item_id, item_order, sidebar_id, block_name, block_type, block_content) VALUES
253
da982928e56a Fix schema bug: main page link isn't a link
Dan
parents: 240
diff changeset
   341
  (1, 1, 1, '{lang:sidebar_title_navigation}', 1, '[[Main_Page|{lang:sidebar_btn_home}]]'),
240
f0149a27df5f Localized default sidebar; installer should work now including the lang import; l10n in installer to follow
Dan
parents: 228
diff changeset
   342
  (2, 2, 1, '{lang:sidebar_title_tools}', 1, '[[$NS_SPECIAL$CreatePage|{lang:sidebar_btn_createpage}]]\n[[$NS_SPECIAL$UploadFile|{lang:sidebar_btn_uploadfile}]]\n[[$NS_SPECIAL$SpecialPages|{lang:sidebar_btn_specialpages}]]\n{if auth_admin}\n$ADMIN_LINK$\n[[$NS_SPECIAL$EditSidebar|{lang:sidebar_btn_editsidebar}]]\n{/if}'),
f0149a27df5f Localized default sidebar; installer should work now including the lang import; l10n in installer to follow
Dan
parents: 228
diff changeset
   343
  (3, 3, 1, '$USERNAME$', 1, '[[$NS_USER$$USERNAME$|{lang:sidebar_btn_userpage}]]\n[[$NS_SPECIAL$Contributions/$USERNAME$|{lang:sidebar_btn_mycontribs}]]\n{if user_logged_in}\n[[$NS_SPECIAL$Preferences|{lang:sidebar_btn_preferences}]]\n[[$NS_SPECIAL$PrivateMessages|{lang:sidebar_btn_privatemessages}]]\n[[$NS_SPECIAL$Usergroups|{lang:sidebar_btn_groupcp}]]\n$THEME_LINK$\n{/if}\n{if user_logged_in}\n$LOGOUT_LINK$\n{else}\n[[$NS_SPECIAL$Register|{lang:sidebar_btn_register}]]\n$LOGIN_LINK$\n[[$NS_SPECIAL$Login/$NS_SPECIAL$PrivateMessages|{lang:sidebar_btn_privatemessages}]]\n{/if}'),
f0149a27df5f Localized default sidebar; installer should work now including the lang import; l10n in installer to follow
Dan
parents: 228
diff changeset
   344
  (4, 4, 1, '{lang:sidebar_title_search}', 1, '<div class="slideblock2" style="padding: 0px;"><form action="$CONTENTPATH$$NS_SPECIAL$Search" method="get" style="padding: 0; margin: 0;"><p><input type="hidden" name="title" value="$NS_SPECIAL$Search" />$INPUT_AUTH$<input name="q" alt="Search box" type="text" size="10" style="width: 70%" /> <input type="submit" value="{lang:sidebar_btn_search_go}" style="width: 20%" /></p></form></div>'),
f0149a27df5f Localized default sidebar; installer should work now including the lang import; l10n in installer to follow
Dan
parents: 228
diff changeset
   345
  (5, 2, 2, '{lang:sidebar_title_links}', 4, 'Links');
42
45ebe475ff75 I dunno how many times I'm gonna have to fix the "problem seems to be the hex conversion" bug, but this is at least the fourth try.
Dan
parents: 40
diff changeset
   346