# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : keld

# --------------------------------------------------------
#
# Table structure for table 'explanations'
#

CREATE TABLE explanations (
   owner text NOT NULL,
   name text NOT NULL,
   explanation longtext NOT NULL,
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   PRIMARY KEY (id),
   UNIQUE id (id)
);

#
# Dumping data for table 'explanations'
#

INSERT INTO explanations (owner, name, explanation, id) VALUES ( 'news', 'newposts', 'This is the number of posts which will be in news.txt.  All others will be in archive.txt.', '1');
INSERT INTO explanations (owner, name, explanation, id) VALUES ( 'news', 'newsformat', 'This is the formatting of your news posts.  It uses these identifiers:<br>
%POSTER% - the person who posted the news<br>
%EMAIL% - the e-mail of the poster<br>
%SUBJECT% - the subject of the post<br>
%POST% - the post<br>
%TIME% - the time of the post', '2');
INSERT INTO explanations (owner, name, explanation, id) VALUES ( 'news', 'timeformat', 'This if the format of the %TIME% variable from the news format.  Here are its identifiers:
a - \"am\" or \"pm\" <br>
A - \"AM\" or \"PM\" <br>
B - Swatch Internet time <br>
d - day of the month, 2 digits with leading zeros; i.e. \"01\" to \"31\" <br>
D - day of the week, textual, 3 letters; i.e. \"Fri\" <br>
F - month, textual, long; i.e. \"January\" <br>
g - hour, 12-hour format without leading zeros; i.e. \"1\" to \"12\" <br>
G - hour, 24-hour format without leading zeros; i.e. \"0\" to \"23\" <br>
h - hour, 12-hour format; i.e. \"01\" to \"12\" <br>
H - hour, 24-hour format; i.e. \"00\" to \"23\" <br>
i - minutes; i.e. \"00\" to \"59\" <br>
I (capital i) - \"1\" if Daylight Savings Time, \"0\" otherwise. <br>
j - day of the month without leading zeros; i.e. \"1\" to \"31\" <br>
l (lowercase \'L\') - day of the week, textual, long; i.e. \"Friday\" <br>
L - boolean for whether it is a leap year; i.e. \"0\" or \"1\" <br>
m - month; i.e. \"01\" to \"12\" <br>
M - month, textual, 3 letters; i.e. \"Jan\" <br>
n - month without leading zeros; i.e. \"1\" to \"12\" <br>
r - RFC 822 formatted date; i.e. \"Thu, 21 Dec 2000 16:01:07 +0200\" (added in PHP 4.0.4) <br>
s - seconds; i.e. \"00\" to \"59\" <br>
S - English ordinal suffix, textual, 2 characters; i.e. \"th\", \"nd\" <br>
t - number of days in the given month; i.e. \"28\" to \"31\" <br>
T - Timezone setting of this machine; i.e. \"MDT\" <br>
U - seconds since the epoch <br>
w - day of the week, numeric, i.e. \"0\" (Sunday) to \"6\" (Saturday) <br>
Y - year, 4 digits; i.e. \"1999\" <br>
y - year, 2 digits; i.e. \"99\" <br>
z - day of the year; i.e. \"0\" to \"365\" <br>
Z - timezone offset in seconds (i.e. \"-43200\" to \"43200\"). The offset for timezones west of UTC is always negative, and for those east of UTC is always positive.', '3');
INSERT INTO explanations VALUES ( 'news', 'newslocation', 'This is the location where your built news file will be stored.  The directory in which it will be created MUST BE CHMODed to 777.', '4');
INSERT INTO explanations VALUES ( 'news', 'archivelocation', 'This is the location where your built news file will be stored.  The directory in which it will be created MUST BE CHMODed to 777.', '5');


# --------------------------------------------------------
#
# Table structure for table 'news'
#

CREATE TABLE news (
   post text NOT NULL,
   poster text NOT NULL,
   subject text NOT NULL,
   time timestamp(14),
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   PRIMARY KEY (id),
   UNIQUE id (id)
);


# --------------------------------------------------------
#
# Table structure for table 'options'
#

CREATE TABLE options (
   owner text NOT NULL,
   name text NOT NULL,
   value text NOT NULL,
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   PRIMARY KEY (id),
   UNIQUE id (id)
);

#
# Dumping data for table 'options'
#

INSERT INTO options (owner, name, value, id) VALUES ( 'news', 'newposts', '5', '1');
INSERT INTO options (owner, name, value, id) VALUES ( 'news', 'newsformat', '<p>%TIME% - [<a href=\"mailto:%EMAIL%\">%POSTER%</a>] - %SUBJECT%</p><p>%POST%</p><p>-----</p>', '2');
INSERT INTO options (owner, name, value, id) VALUES ( 'news', 'timeformat', 'd, F Y - h:i A', '3');
INSERT INTO options VALUES ( 'news', 'newslocation', 'news.txt', '4');
INSERT INTO options VALUES ( 'news', 'archivelocation', 'archive.txt', '5');


# --------------------------------------------------------
#
# Table structure for table 'users'
#

CREATE TABLE users (
   name text NOT NULL,
   password text NOT NULL,
   email text NOT NULL,
   status text NOT NULL,
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   PRIMARY KEY (id),
   UNIQUE id (id)
);

#
# Dumping data for table 'users'
#

INSERT INTO users (name, password, email, status, id) VALUES ( 'admin', password('setup'), '', 'admin', '1');