root/veekun/trunk/script/base_data.sql

Revision 419, 0.8 kB (checked in by eevee, 9 months ago)

Fixed a minor db refactor problem with script/base_data.pl.

Line 
1LOCK TABLES forums WRITE, group_permissions WRITE, groups WRITE, user_groups WRITE, users WRITE;
2
3INSERT INTO forums (id, name, last_post_id, thread_count, post_count, flags, accessibility, description)
4VALUES (1, 'News', NULL, 0, 0, '', 'normal', 'News and updates show up here.');
5
6INSERT INTO group_permissions (group_id, permission, scope, polarity)
7VALUES (1, 'splat', '', 'allow');
8
9INSERT INTO groups (id, icon, name)
10VALUES (1, '', 'Administrators'),
11       (2, '', 'Users');
12
13INSERT INTO user_groups (user_id, group_id, priority)
14VALUES (0, 2, 1),
15       (1, 1, 1);
16
17INSERT INTO users (id, name, password, time_joined, signature, thread_view_cutoff)
18VALUES (1, 'admin', '5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', UNIX_TIMESTAMP(), 'Default signature', UNIX_TIMESTAMP());
19
20UNLOCK TABLES;
Note: See TracBrowser for help on using the browser.