schema.sql
author Dan
Sat, 06 Oct 2007 13:01:46 -0400
changeset 163 ad00dc1f8706
parent 153 9b86248e8fee
child 179 36b287f1d85c
child 196 54b3e14bf19d
permissions -rw-r--r--
Improvements and fixes (hacks?) for HTML sanitization
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)
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    17
) 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
    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 )
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    30
) 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
    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
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    35
) 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
    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)
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    49
) 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
    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(
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
    52
  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
    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,
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
    55
  char_tag varchar(63)
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    56
) 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
    57
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
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
    59
  page_order int(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
    60
  name varchar(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
    61
  urlname 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
    62
  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
    63
  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
    64
  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
    65
  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
    66
  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
    67
  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
    68
  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
    69
  password varchar(40) NOT NULL DEFAULT '',
107
4042c4dd5ba4 Synched installation schema to upgrade schema for delvote_ips
Dan
parents: 94
diff changeset
    70
  delvote_ips text DEFAULT NULL
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    71
) 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
    72
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
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
    74
  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
    75
  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
    76
  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
    77
  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
    78
  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
    79
  time bigint(15) default '0'
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    80
) 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
    81
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
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
    83
  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
    84
  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
    85
  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
    86
  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
    87
  enabled tinyint(1) NOT NULL default '1'
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
    88
) 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
    89
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
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
    91
  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
    92
  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
    93
  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
    94
  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
    95
  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
    96
  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
    97
  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
    98
  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
    99
  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
   100
  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
   101
  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
   102
  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
   103
  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
   104
  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
   105
  temp_password_time int(12) NOT NULL DEFAULT 0,
30
7e8fd44b36b0 COPPA support added
Dan
parents: 27
diff changeset
   106
  user_coppa tinyint(1) NOT NULL DEFAULT 0,
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
   107
  PRIMARY KEY  (user_id)
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   108
) 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
   109
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
   110
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
   111
  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
   112
  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
   113
  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
   114
  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
   115
  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
   116
  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
   117
  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
   118
  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
   119
  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
   120
  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
   121
  PRIMARY KEY ( user_id ) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   122
) 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
   123
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
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
   125
  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
   126
  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
   127
  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
   128
  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
   129
  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
   130
  PRIMARY KEY ( ban_id ) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   131
) 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
   132
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
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
   134
  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
   135
  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
   136
  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
   137
  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
   138
  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
   139
  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
   140
  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
   141
  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
   142
  PRIMARY KEY (file_id) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   143
) 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
   144
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
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
   146
  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
   147
  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
   148
  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
   149
  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
   150
  PRIMARY KEY  (buddy_id) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   151
) 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
   152
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
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
   154
  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
   155
  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
   156
  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
   157
  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
   158
  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
   159
  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
   160
  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
   161
  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
   162
  PRIMARY KEY  (message_id) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   163
) 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
   164
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
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
   166
  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
   167
  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
   168
  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
   169
  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
   170
  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
   171
  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
   172
  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
   173
  PRIMARY KEY ( item_id )
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   174
) 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
   175
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
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
   177
  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
   178
  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
   179
  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
   180
  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
   181
  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
   182
  PRIMARY KEY ( hit_id ) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   183
) 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
   184
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
CREATE TABLE {{TABLE_PREFIX}}search_index(
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
  word varbinary(64) 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
   187
  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
   188
  PRIMARY KEY ( word ) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   189
) 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
   190
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
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
   192
  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
   193
  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
   194
  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
   195
  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
   196
  system_group tinyint(1) NOT NULL DEFAULT 0 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   197
) 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
   198
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
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
   200
  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
   201
  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
   202
  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
   203
  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
   204
  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
   205
  PRIMARY KEY ( member_id ) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   206
) 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
   207
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
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
   209
  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
   210
  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
   211
  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
   212
  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
   213
  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
   214
  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
   215
  PRIMARY KEY ( rule_id ) 
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   216
) 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
   217
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
CREATE TABLE {{TABLE_PREFIX}}search_cache(
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
  search_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
   220
  search_time int(11) 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
   221
  query 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
   222
  results longblob,
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
   223
  PRIMARY KEY ( search_id )
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   224
) 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
   225
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
   226
-- 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
   227
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
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
   229
  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
   230
  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
   231
  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
   232
  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
   233
  PRIMARY KEY ( pg_id )
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   234
) CHARACTER SET `utf8`;
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
   235
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
-- 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
   237
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
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
   239
  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
   240
  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
   241
  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
   242
  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
   243
  PRIMARY KEY ( pg_member_id )
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   244
) CHARACTER SET `utf8`;
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
   245
76
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   246
-- Added in 1.0.1
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   247
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   248
CREATE TABLE {{TABLE_PREFIX}}tags(
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   249
  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
   250
  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
   251
  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
   252
  namespace varchar(255) NOT NULL,
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   253
  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
   254
  PRIMARY KEY ( tag_id )
78
4df25dfdde63 Modified Text_Wiki parser to fully support UTF-8 strings; several other UTF-8 fixes, international characters seem to work reasonably well now
Dan
parents: 76
diff changeset
   255
) CHARACTER SET `utf8`;
76
608dee512bf0 Work started on page tags, still aways to go, but syncing to Nighthawk
Dan
parents: 73
diff changeset
   256
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
   257
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
   258
  ('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
   259
  ('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
   260
  ('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
   261
  ('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
   262
  ('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
   263
  ('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
   264
  ('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
   265
  ('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
   266
  ('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
   267
  ('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
   268
  ('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
   269
  ('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
   270
  ('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
   271
  ('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
   272
  ('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
   273
  ('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
   274
  ('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
   275
  ('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
   276
  ('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
   277
  ('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
   278
  ('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
   279
  ('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
   280
  ('cache_thumbs', '{{ENABLE_CACHE}}'),
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
   281
  ('max_file_size', '256000'),('enano_version', '{{VERSION}}'),( 'allowed_mime_types', 'cbf:len=168;crc=c3dcad3f;data=0[1],1[4],0[3],1[1],0[2],1[1],0[11],1[1],0[7],1[1],0[9],1[1],0[6],1[3],0[10],1[1],0[2],1[2],0[1],1[1],0[1],1[2],0[6],1[3],0[1],1[1],0[2],1[4],0[1],1[2],0[3],1[1],0[4],1[2],0[26],1[5],0[6],1[2],0[2],1[1],0[4],1[1],0[10],1[2],0[1],1[1],0[6]|end' ),
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
   282
  ('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
   283
  ('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
   284
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}}page_text(page_id, namespace, page_text, char_tag) 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
  ('Main_Page', 'Article', '=== Enano has been successfully installed! ===\n\nYou have finished installing Enano on this server. Congratulations!', '');
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
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
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
   289
  (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
   290
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
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
   292
  ('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
   293
  ('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
   294
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
   295
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
   296
  (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
   297
  (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
   298
  
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
   299
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
   300
  (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
   301
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
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
   303
  (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
   304
  (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
   305
0
902822492a68 Initial population
dan@scribus.fuhry.local.fuhry.local
parents:
diff changeset
   306
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
   307
80
cb7dde69c301 Improved and enabled HTML optimization algorithm; enabled gzip compression; added but did not test at all the tag cloud class in includes/tagcloud.php, this is still very preliminary and not ready for any type of production use
Dan
parents: 78
diff changeset
   308
INSERT INTO {{TABLE_PREFIX}}acl(target_type,target_id,page_id,namespace,rules) VALUES(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
   309
  (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
   310
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
INSERT INTO {{TABLE_PREFIX}}sidebar(item_id, item_order, sidebar_id, block_name, block_type, block_content) 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
   312
  (1, 1, 1, 'Navigation', 1, '[[Main Page|Home]]'),
60
71b50f8c8f85 Changed administration login request to use the AJAX login form; made high-level authentication more apparent in the AJAX box; recompiled Oxygen Mint
Dan
parents: 42
diff changeset
   313
  (2, 2, 1, 'Tools', 1, '[[$NS_SPECIAL$CreatePage|Create a page]]\n[[$NS_SPECIAL$UploadFile|Upload file]]\n[[$NS_SPECIAL$SpecialPages|Special pages]]\n{if auth_admin}\n[[$NS_SPECIAL$EditSidebar|Edit the sidebar]]\n$ADMIN_LINK$\n{/if}'),
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
   314
  (3, 3, 1, '$USERNAME$', 1, '[[$NS_USER$$USERNAME$|User page]]\n[[$NS_SPECIAL$Contributions/$USERNAME$|My Contributions]]\n{if user_logged_in}\n[[$NS_SPECIAL$Preferences|Preferences]]\n[[$NS_SPECIAL$PrivateMessages|Private messages]]\n[[$NS_SPECIAL$Usergroups|Group control panel]]\n$THEME_LINK$\n{/if}\n{if user_logged_in}\n$LOGOUT_LINK$\n{else}\n[[$NS_SPECIAL$Register|Create an account]]\n$LOGIN_LINK$\n[[$NS_SPECIAL$Login/$NS_SPECIAL$PrivateMessages|Private messages]]\n{/if}'),
123
8df3abef6647 Fixed the two known issues in the release notes; tarballs will be updated accordingly
Dan
parents: 107
diff changeset
   315
  (4, 4, 1, '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="Go" style="width: 20%" /></p></form></div>'),
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
   316
  (5, 2, 2, '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
   317