Changeset 406 for veekun/trunk/script/base_data.sql

Timestamp:

02/08/08 02:44:39 (2 years ago)

Author:

eevee

Message:

Database refactoring. Renamed columns and tables to be more consistent and more readable. (#58)

Files:

• veekun/trunk/script/base_data.sql (modified) (2 diffs)

veekun/trunk/script/base_data.sql

@@ -1 @@
-LOCK TABLES forums WRITE, grouppermissions WRITE, groups WRITE, usergroups WRITE, users WRITE;
+LOCK TABLES forums WRITE, group_permissions WRITE, groups WRITE, user_groups WRITE, users WRITE;
 
-INSERT INTO forums (id, name, lastpostid, threadct, postct, flags, accessibility, blurb)
+INSERT INTO forums (id, name, last_post_id, thread_count, post_count, flags, accessibility, blurb)
 VALUES (1, 'News', NULL, 0, 0, '', 'normal', 'News and updates show up here.');
 
-INSERT INTO grouppermissions (groupid, permission, scope, polarity)
+INSERT INTO group_permissions (group_id, permission, scope, polarity)
 VALUES (1, 'splat', '', 'allow');
 
@@ -11 +11 @@
        (2, '', 'Users');
 
-INSERT INTO usergroups (userid, groupid, priority)
+INSERT INTO user_groups (user_id, group_id, priority)
 VALUES (0, 2, 1),
        (1, 1, 1);
 
-INSERT INTO users (id, name, password, joindate, signature, thread_view_cutoff)
+INSERT INTO users (id, name, password, time_joined, signature, thread_view_cutoff)
 VALUES (1, 'admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', UNIX_TIMESTAMP(), 'Default signature', UNIX_TIMESTAMP());