Assembla home | Assembla project page
 

Changeset 92

Show
Ignore:
Timestamp:
07/17/07 16:49:07 (1 year ago)
Author:
digitalspaghetti
Message:

Latest DB Dump

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • branch/db.sql

    r87 r92  
    44--  
    55-- Host: localhost 
    6 -- Generation Time: Jul 13, 2007 at 06:06 PM 
     6-- Generation Time: Jul 17, 2007 at 05:48 PM 
    77-- Server version: 5.0.38 
    88-- PHP Version: 5.2.1 
    …… 
    447447  `modified` datetime NOT NULL, 
    448448  PRIMARY KEY  (`id`) 
    449 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; 
     449) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; 
    450450 
    451451--  
    …… 
    453453--  
    454454 
    455 INSERT INTO `events` (`id`, `venue_id`, `event_type_id`, `event_date`, `event_time`, `event_url`, `event_ticket1`, `event_ticket2`, `event_price`, `body`, `tags`, `user_id`, `subject_id`, `published`, `created`, `modified`) VALUES  
    456 (1, 3, 3, '2007-07-08', '11:55:00', 'http://www.tinthepark.com', NULL, NULL, '', 'The Hedrons will be on the King Tut''s Stage', 'The Hedrons, T In The Park, Summer Festivals, Festival, King Tuts', 0, 2, 1, '2007-07-06 16:21:10', '2007-07-06 16:21:10'), 
    457 (2, 1, 1, '2007-07-20', '20:00:00', 'http://www.kingtuts.com', NULL, NULL, '', 'King Tuts', 'The Hedrons', 0, 2, 1, '2007-07-12 14:05:45', '2007-07-12 14:05:45'), 
    458 (3, 8, 1, '2007-07-31', '20:00:00', 'http://www.metro.com', NULL, NULL, '', NULL, 'The Hedrons, London', 0, 2, 1, '2007-07-12 14:48:18', '2007-07-12 14:48:18'); 
    459455 
    460456-- -------------------------------------------------------- 
    …… 
    476472 
    477473INSERT INTO `events_tags` (`event_id`, `tag_id`) VALUES  
    478 (1, 1), 
    479 (1, 2), 
    480 (1, 3), 
    481 (1, 4), 
    482 (1, 5), 
    483 (2, 1), 
    484 (3, 1), 
    485 (3, 6); 
     474(4, 1), 
     475(4, 8); 
    486476 
    487477-- -------------------------------------------------------- 
    …… 
    646636  `modified` datetime default NULL, 
    647637  PRIMARY KEY  (`id`) 
    648 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
     638) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; 
    649639 
    650640--  
    …… 
    652642--  
    653643 
     644INSERT INTO `images` (`id`, `filename`, `dir`, `mimetype`, `alt`, `subject_id`, `copyright_owner`, `copyright_id`, `image_location`, `image_date`, `image_notes`, `filesize`, `tags`, `user_id`, `created`, `modified`) VALUES  
     645(3, 'Quebec_Music_Fest2.jpg', 'files/images', 'image/jpeg', 'The Hedrons @ Quebec Music Fest', 2, 'The Hedrons', 1, 'Quebec, Canada', '2007-07-17', '<p>Hedrons</p>', 764051, 'The Hedrons', NULL, '2007-07-17 12:15:03', '2007-07-17 12:15:03'), 
     646(4, 'thehedronsjosh.jpg', 'files/images', 'image/jpeg', 'The Hedrons meet QOTSA', 2, 'The Hedrons', 1, 'T In The Park', '2007-07-08', '<p>The Hedrons meet QOTSA</p>', 611260, 'The Hedrons', NULL, '2007-07-17 12:22:49', '2007-07-17 12:22:49'); 
    654647 
    655648-- -------------------------------------------------------- 
    …… 
    670663--  
    671664 
     665INSERT INTO `images_tags` (`image_id`, `tag_id`) VALUES  
     666(3, 1), 
     667(4, 1); 
    672668 
    673669-- -------------------------------------------------------- 
    …… 
    765761 
    766762--  
     763-- Table structure for table `number_trees` 
     764--  
     765 
     766DROP TABLE IF EXISTS `number_trees`; 
     767CREATE TABLE `number_trees` ( 
     768  `id` smallint(10) unsigned NOT NULL auto_increment, 
     769  `parent_id` smallint(10) default NULL, 
     770  `name` varchar(50) collate utf8_unicode_ci default NULL, 
     771  `lft` smallint(10) default NULL, 
     772  `rght` smallint(10) default NULL, 
     773  PRIMARY KEY  (`id`), 
     774  KEY `rght` (`rght`), 
     775  KEY `lft` (`lft`,`rght`) 
     776) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ; 
     777 
     778--  
     779-- Dumping data for table `number_trees` 
     780--  
     781 
     782INSERT INTO `number_trees` (`id`, `parent_id`, `name`, `lft`, `rght`) VALUES  
     783(1, NULL, '1. Root', 1, 22), 
     784(2, 1, '1.1', 2, 7), 
     785(3, 2, '1.1.1', 3, 4), 
     786(4, 2, '1.1.2', 5, 6), 
     787(5, 1, '1.2', 8, 21), 
     788(6, 5, '1.2.1', 9, 10), 
     789(7, 5, '1.2.2', 11, 12), 
     790(8, 5, '1.2.New!', 13, 14), 
     791(9, 5, '1.2.New!', 15, 16), 
     792(10, 5, '1.2.New!', 17, 18), 
     793(11, 5, '1.2.New!', 19, 20); 
     794 
     795-- -------------------------------------------------------- 
     796 
     797--  
    767798-- Table structure for table `pages` 
    768799--  
    …… 
    893924  `user_id` int(8) unsigned NOT NULL, 
    894925  `subject_id` int(8) unsigned NOT NULL, 
     926  `image_id` int(8) unsigned default NULL, 
    895927  `access_level` int(8) unsigned NOT NULL, 
    896928  `stub` varchar(255) NOT NULL, 
    …… 
    901933  `modified` datetime default NULL, 
    902934  PRIMARY KEY  (`id`) 
    903 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
     935) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 
    904936 
    905937--  
    …… 
    907939--  
    908940 
     941INSERT INTO `posts` (`id`, `title`, `byline`, `body`, `post_date`, `comments_count`, `user_id`, `subject_id`, `image_id`, `access_level`, `stub`, `tags`, `frontpage`, `published`, `created`, `modified`) VALUES  
     942(7, 'dfgfdgfdgdfg', 'dfgdfgdfgdfgdfg', '<p>dfgdfgdfgdfgdfgdf</p>', '2007-07-17 12:35:00', NULL, 1, 2, 3, 0, 'dfgfdgfdgdfg', 'Dfgdfgdfgdfg', 1, 1, '2007-07-17 12:35:50', '2007-07-17 12:35:50'), 
     943(6, 'Test Post 2', 'Test Post 2', '<p>The Hedrons meet QOTSA</p>', '2007-07-17 12:23:00', NULL, 1, 2, 4, 0, 'test_post_2', 'The Hedrons', 1, 1, '2007-07-17 12:23:19', '2007-07-17 12:23:19'), 
     944(5, 'Test', 'Test', '<p>Test</p>', '2007-07-17 12:16:00', NULL, 1, 2, 3, 0, 'test', 'Test', 1, 1, '2007-07-17 12:16:43', '2007-07-17 12:16:43'), 
     945(8, 'fgdhrtjrtjryj', 'tyejtyjtyjty', '<p>jtyjtyjtyjtyjty</p>', '2007-07-17 12:37:00', NULL, 1, 2, 4, 0, 'fgdhrtjrtjryj', 'Tyjtyj', 1, 1, '2007-07-17 12:37:44', '2007-07-17 12:37:44'), 
     946(9, 'fgsdfgdfhrthtrhwrth', 'rthrthrthr', '<p>hrthrth</p>', '2007-07-17 12:38:00', NULL, 1, 2, 3, 0, 'fgsdfgdfhrthtrhwrth', 'Ertherttrh', 1, 1, '2007-07-17 12:38:36', '2007-07-17 12:38:36'); 
    909947 
    910948-- -------------------------------------------------------- 
    …… 
    925963--  
    926964 
     965INSERT INTO `posts_tags` (`post_id`, `tag_id`) VALUES  
     966(5, 13), 
     967(6, 1), 
     968(7, 11), 
     969(8, 14), 
     970(9, 15); 
    927971 
    928972-- -------------------------------------------------------- 
    …… 
    10851129INSERT INTO `subjects` (`id`, `title`, `posts_count`, `pages_count`, `events_count`, `feeds_count`, `images_count`, `galleries_count`, `videos_count`, `created`, `modified`) VALUES  
    10861130(1, 'Uncatagorised', 1, 0, 2, 0, 0, 0, 0, '2007-05-01 17:05:55', '2007-05-01 17:05:55'), 
    1087 (2, 'The Hedrons', NULL, NULL, 3, NULL, NULL, NULL, NULL, '2007-07-06 14:33:59', '2007-07-06 14:33:59'), 
    1088 (3, 'Wet Wet Wet', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2007-07-06 14:34:09', '2007-07-06 14:34:09'); 
     1131(2, 'The Hedrons', 5, NULL, 1, NULL, 2, NULL, NULL, '2007-07-06 14:33:59', '2007-07-06 14:33:59'), 
     1132(3, 'Wet Wet Wet', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2007-07-06 14:34:09', '2007-07-06 14:34:09'); 
    10891133 
    10901134-- -------------------------------------------------------- 
    …… 
    10991143  `tag` varchar(255) collate utf8_unicode_ci NOT NULL, 
    11001144  PRIMARY KEY  (`id`) 
    1101 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=7 ; 
     1145) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ; 
    11021146 
    11031147--  
    …… 
    11111155(4, 'Festival'), 
    11121156(5, 'King Tuts'), 
    1113 (6, 'London'); 
     1157(6, 'London'), 
     1158(7, '1'), 
     1159(8, 'Usa Tour'), 
     1160(9, 'Test Post'), 
     1161(10, 'Wet Wet Wet'), 
     1162(11, 'Dfgdfgdfgdfg'), 
     1163(12, 'Quebec'), 
     1164(13, 'Test'), 
     1165(14, 'Tyjtyj'), 
     1166(15, 'Ertherttrh'); 
    11141167 
    11151168-- -------------------------------------------------------- 
    …… 
    12501303 
    12511304INSERT INTO `users` (`id`, `username`, `passwd`, `name`, `email`, `last_visit`, `group_id`, `profile_id`, `posts_count`, `pages_count`, `comments_count`, `videos_count`, `tags`, `active`, `created`, `modified`) VALUES  
    1252 (1, 'WebrocketAdmin', 'fdfedc01c66e9ea2817508ca1097df2f', 'Webrocket Admin', 'admin@webrocket.com', '2007-06-11 17:29:46', 1, 1, 1, 2, 2, 0, '', 1, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
     1305(1, 'WebrocketAdmin', 'fdfedc01c66e9ea2817508ca1097df2f', 'Webrocket Admin', 'admin@webrocket.com', '2007-06-11 17:29:46', 1, 1, 5, 2, 2, 0, '', 1, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
    12531306(2, 'Editor', '5aee9dbd2a188839105073571bee1b1f', 'Site', 'Editor', '2007-04-27 10:02:45', 2, 0, 0, 0, 0, 0, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
    12541307(3, 'Member', 'aa08769cdcb26674c6706093503ff0a3', 'Member', 'member@member.com', '2007-04-26 13:43:34', 3, 0, 0, 0, 0, 0, '', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');