Assembla home | Assembla project page
 

Changeset 97

Show
Ignore:
Timestamp:
07/17/07 22:12:59 (1 year ago)
Author:
AD7six
Message:

Modifying table structure, and prepopulating lft/rght fields so the tree is valid (even though the values will now 'move' menu items)

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/webrocket.sql

    r7 r97  
    268268 
    269269DROP TABLE IF EXISTS `menus`; 
     270CREATE TABLE `menus` ( 
     271  `id` int(11) unsigned NOT NULL auto_increment, 
     272  `name` varchar(255) NOT NULL, 
     273  `url` varchar(255) NOT NULL, 
     274  `position` int(5) NOT NULL, 
     275  `icon` varchar(255) default NULL, 
     276  `parent_id` int(11) unsigned NOT NULL, 
     277  `lft` tinyint(4) NOT NULL, 
     278  `rght` tinyint(4) NOT NULL, 
     279  `section_id` int(11) unsigned NOT NULL, 
     280  `access_level` int(3) NOT NULL, 
     281  `published` tinyint(1) NOT NULL default '1', 
     282  `created` datetime NOT NULL, 
     283  `modified` datetime NOT NULL, 
     284  PRIMARY KEY  (`id`) 
     285) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ; 
    270286CREATE TABLE `menus` ( 
    271287  `id` int(11) unsigned NOT NULL auto_increment, 
    …… 
    784800--  
    785801 
    786 INSERT INTO `menus` (`id`, `name`, `url`, `position`, `icon`, `parent_id`, `section_id`, `access_level`) VALUES  
    787 (1, 'Home', '/', 0, 'home', 0, 1, 0), 
    788 (2, 'News', '/posts/index', 1, NULL, 0, 1, 0), 
    789 (3, 'Tour Dates', '/events/index', 2, NULL, 0, 1, 0), 
    790 (4, 'Manage Posts', '/admin/posts/', 0, 'admin-posts', 12, 1, 900), 
    791 (5, 'Manage Pages', '/admin/pages/', 1, 'admin-pages', 12, 1, 900), 
    792 (6, 'Manage Events', '/admin/events/', 2, 'admin-events', 12, 1, 900), 
    793 (7, 'Manage Feeds', '/admin/feeds/', 3, 'admin-feeds', 12, 1, 900), 
    794 (8, 'Manage Users', '/admin/users/', 4, 'admin-users', 12, 1, 900), 
    795 (9, 'Manage Images', '/admin/images/', 5, 'admin-images', 12, 1, 900), 
    796 (10, 'Manage Configurations', '#', 9, 'admin-options', 12, 1, 999), 
    797 (11, 'Manage Galleries', '/admin/galleries', 7, 'admin-galleries', 12, 1, 900), 
    798 (12, 'Admin', '#', 5, '', 0, 1, 900), 
    799 (13, 'Galleries', '/galleries/', 3, NULL, 0, 1, 0), 
    800 (14, 'Manage Videos', '/admin/videos', 6, 'admin-videos', 12, 1, 900), 
    801 (15, 'Videos', '/videos', 4, '', 0, 1, 0), 
    802 (16, 'Manage Menus', '/admin/menus', 8, 'admin-menus', 12, 1, 900), 
    803 (17, 'Add Post', '/admin/posts/add', 11, '', 4, 1, 900), 
    804 (18, 'Add Page', '/admin/pages/add', 12, '', 5, 1, 900), 
    805 (19, 'Add Event', '/admin/events/add', 13, '', 6, 1, 900), 
    806 (20, 'Add Feed', '/admin/feeds/add', 14, '', 7, 1, 900), 
    807 (21, 'Add User', '/admin/users/add', 15, '', 8, 1, 900), 
    808 (22, 'Upload Image', '/admin/images/upload', 16, '', 9, 1, 900), 
    809 (23, 'Add Gallery', '/admin/galleries/add', 17, '', 11, 1, 900), 
    810 (24, 'Upload Video', '/admin/videos/add', 18, '', 14, 1, 900), 
    811 (25, 'Add Menu', '/admin/menus/add', 19, '', 16, 1, 900), 
    812 (26, 'Edit Video Options', '/admin/configs/video', 1, '', 10, 1, 999), 
    813 (27, 'Edit Site Options', '/admin/configs/edit', 0, '', 10, 1, 999); 
     802INSERT INTO `menus` (`id`, `name`, `url`, `position`, `icon`, `parent_id`, `lft`, `rght`, `section_id`, `access_level`, `published`, `created`, `modified`) VALUES  
     803(1, 'Home', '/', 0, 'home', 0, 68, 69, 1, 0, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     804(2, 'News', '/posts/index/post_index_limit:10', 1, '', 0, 3, 6, 1, 0, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     805(3, 'Tour Dates', '/events/index', 2, NULL, 0, 1, 2, 1, 0, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     806(4, 'Manage Posts', '/admin/posts/', 0, 'admin-posts', 29, 63, 63, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     807(5, 'Manage Pages', '/admin/pages/', 1, 'admin-pages', 29, 57, 60, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     808(6, 'Manage Events', '/admin/events/', 2, 'admin-events', 29, 51, 56, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     809(7, 'Manage Feeds', '/admin/feeds/', 3, 'admin-feeds', 29, 47, 50, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     810(8, 'Manage Users', '/admin/users/', 0, 'admin-users', 31, 9, 12, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     811(9, 'Manage Images', '/admin/images/', 0, 'admin-images', 30, 33, 36, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     812(10, 'Manage Configurations', '#', 2, 'admin-options', 31, 13, 18, 1, 999, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     813(11, 'Manage Galleries', '/admin/galleries', 4, 'admin-galleries', 29, 63, 63, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     814(12, 'Admin', '#', 5, '', 0, 7, 63, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     815(13, 'Galleries', '/galleries/', 3, NULL, 0, 66, 67, 1, 0, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     816(14, 'Manage Videos', '/admin/videos', 1, 'admin-videos', 30, 37, 40, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     817(15, 'Videos', '/videos', 4, '', 0, 64, 65, 1, 0, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     818(16, 'Manage Menus', '/admin/menus', 1, 'admin-menus', 31, 19, 22, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     819(17, 'Add Post', '/admin/posts/add', 11, '', 4, 61, 62, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     820(18, 'Add Page', '/admin/pages/add', 12, '', 5, 58, 59, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     821(19, 'Add Event', '/admin/events/add', 13, '', 6, 54, 55, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     822(20, 'Add Feed', '/admin/feeds/add', 14, '', 7, 48, 49, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     823(21, 'Add User', '/admin/users/add', 15, '', 8, 10, 11, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     824(22, 'Upload Image', '/admin/images/add', 16, '', 9, 34, 35, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     825(23, 'Add Gallery', '/admin/galleries/add', 17, '', 11, 63, 63, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     826(24, 'Add Video', '/admin/videos/add', 0, '', 14, 38, 39, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     827(25, 'Add Menu', '/admin/menus/add', 19, '', 16, 20, 21, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     828(26, 'Edit Video Options', '/admin/configs/video', 1, '', 10, 16, 17, 1, 999, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     829(27, 'Edit Site Options', '/admin/configs/edit', 0, '', 10, 14, 15, 1, 999, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     830(28, 'Add Event Type', '/admin/events/addtype', 20, '', 6, 52, 53, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     831(29, 'Content', '#', 21, NULL, 12, 42, 63, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     832(30, 'Assets', '#', 22, NULL, 12, 24, 41, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     833(31, 'System', '#', 23, NULL, 12, 8, 23, 1, 900, 1, '0000-00-00 00:00:00', '2007-07-18 00:07:09'), 
     834(32, 'Manage Subjects', '/admin/subjects', 24, '', 35, 63, 63, 1, 900, 1, '2007-05-21 16:31:22', '2007-07-18 00:07:09'), 
     835(33, 'Add Subject', '/admin/subjects/add', 25, NULL, 32, 63, 63, 1, 900, 1, '2007-05-21 16:32:07', '2007-07-18 00:07:09'), 
     836(34, 'Members News', '/posts/membersnews', 26, NULL, 2, 4, 5, 1, 500, 1, '2007-05-29 16:25:15', '2007-07-18 00:07:09'), 
     837(35, 'Meta Data', '#', 27, NULL, 12, 63, 63, 1, 900, 1, '2007-05-29 16:26:06', '2007-07-18 00:07:09'), 
     838(36, 'Post Settings', '/admin/configs/posts', 28, NULL, 4, 63, 63, 1, 999, 1, '2007-05-30 11:37:45', '2007-07-18 00:07:09'), 
     839(37, 'Manage Tracks', '/admin/tracks/', 29, NULL, 30, 29, 32, 1, 900, 1, '2007-06-04 22:54:01', '2007-07-18 00:07:09'), 
     840(38, 'Add Track', '/admin/tracks/add', 30, NULL, 37, 30, 31, 1, 900, 1, '2007-06-04 22:54:37', '2007-07-18 00:07:09'), 
     841(39, 'Manage Playlists', '/admin/playlists/', 31, NULL, 29, 43, 46, 1, 900, 1, '2007-06-04 22:55:27', '2007-07-18 00:07:09'), 
     842(40, 'Add Playlist', '/admin/playlists/add', 32, NULL, 39, 44, 45, 1, 900, 1, '2007-06-04 22:56:09', '2007-07-18 00:07:09'), 
     843(41, 'Manage Tags', '/admin/tags', 1, NULL, 35, 63, 63, 1, 900, 1, '2007-06-20 16:02:08', '2007-07-18 00:07:09'), 
     844(42, 'Manage Venues', '/admin/venues/', 3, NULL, 30, 25, 28, 1, 900, 1, '2007-07-06 15:48:34', '2007-07-18 00:07:09'), 
     845(43, 'Add Venue', '/admin/venues/add', 0, NULL, 42, 26, 27, 1, 900, 1, '2007-07-06 15:49:05', '2007-07-18 00:07:09'); 
     846 
    814847 
    815848--