author | Dan |
Mon, 16 Jun 2008 12:54:24 -0400 | |
changeset 7 | cd46e29ae699 |
parent 0 | a09fb41e48d5 |
permissions | -rw-r--r-- |
0
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
1 |
-- Nuggie |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
2 |
-- Version 0.1 |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
3 |
-- Copyright (C) 2007 Dan Fuhry |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
4 |
|
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
5 |
-- This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
6 |
-- as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
7 |
|
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
8 |
-- This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
9 |
-- warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details. |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
10 |
|
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
11 |
CREATE TABLE {{TABLE_PREFIX}}blogs( |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
12 |
blog_id int(12) NOT NULL auto_increment, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
13 |
blog_name varchar(255) NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
14 |
blog_subtitle text NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
15 |
user_id int(12) NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
16 |
blog_type ENUM('private', 'public') NOT NULL DEFAULT 'public', |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
17 |
allowed_users text, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
18 |
PRIMARY KEY ( blog_id ) |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
19 |
) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin; |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
20 |
|
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
21 |
CREATE TABLE {{TABLE_PREFIX}}planets( |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
22 |
planet_id smallint(6) NOT NULL auto_increment, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
23 |
planet_name varchar(255) NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
24 |
planet_subtitle text NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
25 |
planet_creator int(12) NOT NULL DEFAULT 1, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
26 |
planet_public tinyint(1) NOT NULL DEFAULT 0, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
27 |
planet_visible tinyint(1) NOT NULL DEFAULT 1, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
28 |
PRIMARY KEY ( planet_id ) |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
29 |
) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin; |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
30 |
|
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
31 |
CREATE TABLE {{TABLE_PREFIX}}blog_posts( |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
32 |
post_id int(15) NOT NULL auto_increment, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
33 |
post_title text NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
34 |
post_title_clean text NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
35 |
post_author int(12) NOT NULL DEFAULT 1, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
36 |
post_text longtext NOT NULL, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
37 |
post_timestamp int(32) NOT NULL DEFAULT 0, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
38 |
post_published tinyint(1) NOT NULL DEFAULT 0, |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
39 |
PRIMARY KEY ( post_id ) |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
40 |
) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin; |
a09fb41e48d5
First commit! Woohoo! Basic status of things is in extended description.
Dan
parents:
diff
changeset
|
41 |
|
7
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
42 |
CREATE TABLE {{TABLE_PREFIX}}planets_mapping( |
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
43 |
mapping_id int(15) NOT NULL auto_increment, |
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
44 |
planet_id smallint(6) NOT NULL, |
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
45 |
mapping_type smallint(3) NOT NULL DEFAULT 1, |
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
46 |
mapping_value text NOT NULL, |
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
47 |
PRIMARY KEY ( mapping_id ) |
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
48 |
) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_bin; |
cd46e29ae699
Started work on planet system. From this point onward, enano-1.1 rev 571 or later required.
Dan
parents:
0
diff
changeset
|
49 |