Assembla home | Assembla project page
 

Changeset 7

Show
Ignore:
Timestamp:
04/29/07 14:28:19 (2 years ago)
Author:
digitalspaghetti
Message:

Update SQL

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/controllers/images_controller.php

    r2 r7  
    126126        } 
    127127         
    128          
    129          
    130         function getExt($type) 
    131         { 
    132                 switch ($type) { 
    133                         case 'image/jpeg': 
    134                                 $ext = ".jpg"; 
    135                                 break; 
    136                         case 'image/png': 
    137                                 $ext = ".png"; 
    138                                 break; 
    139                         case 'image/gif': 
    140                                 $ext = ".gif"; 
    141                                 break; 
    142                         default: 
    143                                 $ext = ".jpg"; 
    144                 } 
    145                 return $ext; 
    146                  
    147         } 
    148          
    149128        function createthumb($name,$filename,$new_w,$new_h) 
    150129        { 

  • trunk/webrocket.sql

    r2 r7  
    44--  
    55-- Host: localhost 
    6 -- Generation Time: Apr 25, 2007 at 05:45 PM 
     6-- Generation Time: Apr 29, 2007 at 03:25 PM 
    77-- Server version: 5.0.38 
    88-- PHP Version: 5.2.1 
    …… 
    2525) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
    2626 
    27 --  
    28 -- Dumping data for table `cake_sessions` 
    29 --  
    30  
    31 INSERT INTO `cake_sessions` (`id`, `data`, `expires`) VALUES  
    32 ('a55cd04df5e5fdf780054824c30a28b4', 'Config|a:3:{s:9:"userAgent";s:32:"d31b3ddf4673bdef01e784b1085a6883";s:4:"time";i:1177520713;s:4:"rand";i:1875027292;}othAuth|a:1:{s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";a:2:{s:4:"User";a:13:{s:2:"id";s:1:"1";s:8:"username";s:14:"WebrocketAdmin";s:6:"passwd";s:32:"fdfedc01c66e9ea2817508ca1097df2f";s:4:"name";s:15:"Webrocket Admin";s:5:"email";s:23:"tane@nohalfmeasures.com";s:10:"last_visit";s:19:"2007-04-25 16:34:59";s:8:"group_id";s:1:"1";s:10:"profile_id";s:1:"1";s:6:"active";s:1:"1";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"login_hash";s:32:"9959667d54c2bb525ab6b832bdd90c14";s:7:"hashkey";s:41:"ADYhG93b0qyJfIxfs2guVoUubWwvniR2G0FgaC9mi";}s:5:"Group";a:8:{s:2:"id";s:1:"1";s:4:"name";s:11:"Site Admins";s:5:"level";s:3:"999";s:8:"redirect";s:0:"";s:9:"perm_type";s:5:"allow";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";s:10:"Permission";a:1:{i:0;a:4:{s:2:"id";s:1:"1";s:4:"name";s:1:"*";s:7:"created";s:19:"2007-03-26 00:00:00";s:8:"modified";s:19:"0000-00-00 00:00:00";}}}}}', 1177520713); 
    33  
    3427-- -------------------------------------------------------- 
    3528 
    …… 
    4942  `modified` datetime NOT NULL, 
    5043  PRIMARY KEY  (`id`) 
    51 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    52  
    53 --  
    54 -- Dumping data for table `comments` 
    55 --  
    56  
     44) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
    5745 
    5846-- -------------------------------------------------------- 
    …… 
    6957  `desc` varchar(255) NOT NULL, 
    7058  PRIMARY KEY  (`id`) 
    71 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    72  
    73 --  
    74 -- Dumping data for table `config_categories` 
    75 --  
    76  
    77 INSERT INTO `config_categories` (`id`, `name`, `descname`, `desc`) VALUES  
    78 (1, 'general', 'Site Options', 'These are the main options that control the site'); 
     59) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; 
    7960 
    8061-- -------------------------------------------------------- 
    …… 
    9172  `value` varchar(50) NOT NULL, 
    9273  PRIMARY KEY  (`id`) 
    93 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
     74) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 
     75 
     76-- -------------------------------------------------------- 
     77 
     78--  
     79-- Table structure for table `copyrights` 
     80--  
     81 
     82DROP TABLE IF EXISTS `copyrights`; 
     83CREATE TABLE `copyrights` ( 
     84  `id` int(8) unsigned NOT NULL, 
     85  `name` varchar(255) NOT NULL, 
     86  `licence` text NOT NULL, 
     87  PRIMARY KEY  (`id`) 
     88) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     89 
     90-- -------------------------------------------------------- 
     91 
     92--  
     93-- Table structure for table `countries` 
     94--  
     95 
     96DROP TABLE IF EXISTS `countries`; 
     97CREATE TABLE `countries` ( 
     98  `id` smallint(6) NOT NULL auto_increment, 
     99  `twoAbrev` char(2) collate utf8_unicode_ci NOT NULL, 
     100  `threeAbrev` char(3) collate utf8_unicode_ci NOT NULL, 
     101  `code` int(11) NOT NULL default '0', 
     102  `name` varchar(50) collate utf8_unicode_ci NOT NULL, 
     103  PRIMARY KEY  (`id`) 
     104) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=240 ; 
     105 
     106-- -------------------------------------------------------- 
     107 
     108--  
     109-- Table structure for table `event_types` 
     110--  
     111 
     112DROP TABLE IF EXISTS `event_types`; 
     113CREATE TABLE `event_types` ( 
     114  `id` int(8) unsigned NOT NULL, 
     115  `name` varchar(50) NOT NULL, 
     116  PRIMARY KEY  (`id`) 
     117) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     118 
     119-- -------------------------------------------------------- 
     120 
     121--  
     122-- Table structure for table `events` 
     123--  
     124 
     125DROP TABLE IF EXISTS `events`; 
     126CREATE TABLE `events` ( 
     127  `id` int(8) unsigned NOT NULL auto_increment, 
     128  `venue` varchar(50) NOT NULL, 
     129  `address` varchar(255) default NULL, 
     130  `city` varchar(50) NOT NULL, 
     131  `country_id` int(3) NOT NULL, 
     132  `postcode` varchar(10) NOT NULL, 
     133  `lat` varchar(50) NOT NULL, 
     134  `long` varchar(50) NOT NULL, 
     135  `event_type_id` int(8) unsigned NOT NULL, 
     136  `event_date` date NOT NULL, 
     137  `event_time` time default NULL, 
     138  `event_url` varchar(255) default NULL, 
     139  `notes` text, 
     140  `user_id` int(8) unsigned NOT NULL, 
     141  `published` tinyint(1) NOT NULL, 
     142  `created` datetime NOT NULL, 
     143  `modified` datetime NOT NULL, 
     144  PRIMARY KEY  (`id`) 
     145) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 
     146 
     147-- -------------------------------------------------------- 
     148 
     149--  
     150-- Table structure for table `feeds` 
     151--  
     152 
     153DROP TABLE IF EXISTS `feeds`; 
     154CREATE TABLE `feeds` ( 
     155  `id` int(8) unsigned NOT NULL auto_increment, 
     156  `feed_name` varchar(255) NOT NULL, 
     157  `feed_url` varchar(255) NOT NULL, 
     158  `published` tinyint(1) NOT NULL default '0', 
     159  `created` datetime NOT NULL, 
     160  `modified` datetime NOT NULL, 
     161  PRIMARY KEY  (`id`) 
     162) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; 
     163 
     164-- -------------------------------------------------------- 
     165 
     166--  
     167-- Table structure for table `galleries` 
     168--  
     169 
     170DROP TABLE IF EXISTS `galleries`; 
     171CREATE TABLE `galleries` ( 
     172  `id` int(8) unsigned NOT NULL auto_increment, 
     173  `name` varchar(255) NOT NULL, 
     174  `url` varchar(255) NOT NULL, 
     175  `primary_image` int(8) unsigned NOT NULL, 
     176  `published` tinyint(1) NOT NULL, 
     177  `created` datetime NOT NULL, 
     178  `modified` datetime NOT NULL, 
     179  PRIMARY KEY  (`id`) 
     180) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 
     181 
     182-- -------------------------------------------------------- 
     183 
     184--  
     185-- Table structure for table `galleries_images` 
     186--  
     187 
     188DROP TABLE IF EXISTS `galleries_images`; 
     189CREATE TABLE `galleries_images` ( 
     190  `gallery_id` int(8) unsigned NOT NULL, 
     191  `image_id` int(8) unsigned NOT NULL 
     192) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     193 
     194-- -------------------------------------------------------- 
     195 
     196--  
     197-- Table structure for table `groups` 
     198--  
     199 
     200DROP TABLE IF EXISTS `groups`; 
     201CREATE TABLE `groups` ( 
     202  `id` int(10) unsigned NOT NULL auto_increment, 
     203  `name` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL, 
     204  `level` int(11) NOT NULL, 
     205  `redirect` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL, 
     206  `perm_type` enum('allow','deny') NOT NULL default 'allow', 
     207  `created` datetime NOT NULL default '0000-00-00 00:00:00', 
     208  `modified` datetime NOT NULL default '0000-00-00 00:00:00', 
     209  PRIMARY KEY  (`id`) 
     210) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; 
     211 
     212-- -------------------------------------------------------- 
     213 
     214--  
     215-- Table structure for table `groups_permissions` 
     216--  
     217 
     218DROP TABLE IF EXISTS `groups_permissions`; 
     219CREATE TABLE `groups_permissions` ( 
     220  `group_id` int(10) unsigned NOT NULL default '0', 
     221  `permission_id` int(10) unsigned NOT NULL default '0', 
     222  KEY `group_id` (`group_id`,`permission_id`) 
     223) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     224 
     225-- -------------------------------------------------------- 
     226 
     227--  
     228-- Table structure for table `images` 
     229--  
     230 
     231DROP TABLE IF EXISTS `images`; 
     232CREATE TABLE `images` ( 
     233  `id` int(8) unsigned NOT NULL auto_increment, 
     234  `filename` varchar(150) NOT NULL, 
     235  `filesize` int(11) NOT NULL, 
     236  `alt` varchar(255) NOT NULL, 
     237  `type` varchar(15) NOT NULL, 
     238  `copyright_owner` varchar(255) default NULL, 
     239  `copyright_id` int(8) unsigned NOT NULL default '1', 
     240  `lat` decimal(10,0) default NULL, 
     241  `long` decimal(10,0) default NULL, 
     242  `created` datetime NOT NULL, 
     243  `modified` datetime NOT NULL, 
     244  PRIMARY KEY  (`id`), 
     245  UNIQUE KEY `filename` (`filename`) 
     246) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=36 ; 
     247 
     248-- -------------------------------------------------------- 
     249 
     250--  
     251-- Table structure for table `login_attempts` 
     252--  
     253 
     254DROP TABLE IF EXISTS `login_attempts`; 
     255CREATE TABLE `login_attempts` ( 
     256  `ip` varchar(15) character set utf8 collate utf8_unicode_ci NOT NULL, 
     257  `num` int(11) NOT NULL default '1', 
     258  `expire` datetime NOT NULL, 
     259  `created` datetime NOT NULL, 
     260  PRIMARY KEY  (`ip`) 
     261) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     262 
     263-- -------------------------------------------------------- 
     264 
     265--  
     266-- Table structure for table `menus` 
     267--  
     268 
     269DROP TABLE IF EXISTS `menus`; 
     270CREATE TABLE `menus` ( 
     271  `id` int(11) unsigned NOT NULL auto_increment, 
     272  `name` varchar(50) NOT NULL, 
     273  `url` varchar(150) NOT NULL, 
     274  `position` int(5) NOT NULL, 
     275  `icon` varchar(255) default NULL, 
     276  `parent_id` int(11) unsigned NOT NULL, 
     277  `section_id` int(11) unsigned NOT NULL, 
     278  `access_level` int(3) NOT NULL, 
     279  PRIMARY KEY  (`id`) 
     280) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=28 ; 
     281 
     282-- -------------------------------------------------------- 
     283 
     284--  
     285-- Table structure for table `pages` 
     286--  
     287 
     288DROP TABLE IF EXISTS `pages`; 
     289CREATE TABLE `pages` ( 
     290  `id` int(8) unsigned NOT NULL auto_increment, 
     291  `url` varchar(150) NOT NULL, 
     292  `title` varchar(50) NOT NULL, 
     293  `body` text NOT NULL, 
     294  `published` tinyint(1) NOT NULL default '0', 
     295  `user_id` int(8) unsigned NOT NULL, 
     296  `subject_id` int(8) unsigned NOT NULL, 
     297  `copyright_id` int(8) unsigned NOT NULL default '1', 
     298  `created` datetime NOT NULL, 
     299  `modified` datetime NOT NULL, 
     300  PRIMARY KEY  (`id`) 
     301) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 
     302 
     303-- -------------------------------------------------------- 
     304 
     305--  
     306-- Table structure for table `permissions` 
     307--  
     308 
     309DROP TABLE IF EXISTS `permissions`; 
     310CREATE TABLE `permissions` ( 
     311  `id` int(10) unsigned NOT NULL auto_increment, 
     312  `name` varchar(50) NOT NULL default '', 
     313  `created` datetime NOT NULL default '0000-00-00 00:00:00', 
     314  `modified` datetime NOT NULL default '0000-00-00 00:00:00', 
     315  PRIMARY KEY  (`id`), 
     316  UNIQUE KEY `name` (`name`) 
     317) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; 
     318 
     319-- -------------------------------------------------------- 
     320 
     321--  
     322-- Table structure for table `posts` 
     323--  
     324 
     325DROP TABLE IF EXISTS `posts`; 
     326CREATE TABLE `posts` ( 
     327  `id` int(8) unsigned NOT NULL auto_increment, 
     328  `title` varchar(150) NOT NULL, 
     329  `byline` varchar(255) NOT NULL, 
     330  `body` text NOT NULL, 
     331  `user_id` int(8) unsigned NOT NULL, 
     332  `subject_id` int(8) unsigned NOT NULL, 
     333  `copyright_id` int(8) unsigned NOT NULL default '1', 
     334  `url` varchar(200) NOT NULL, 
     335  `published` tinyint(1) NOT NULL default '0', 
     336  `created` datetime NOT NULL, 
     337  `modified` datetime NOT NULL, 
     338  PRIMARY KEY  (`id`) 
     339) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 
     340 
     341-- -------------------------------------------------------- 
     342 
     343--  
     344-- Table structure for table `profiles` 
     345--  
     346 
     347DROP TABLE IF EXISTS `profiles`; 
     348CREATE TABLE `profiles` ( 
     349  `id` int(8) unsigned NOT NULL auto_increment, 
     350  `user_id` int(8) unsigned NOT NULL, 
     351  `country` varchar(2) NOT NULL, 
     352  `dob` date NOT NULL, 
     353  `homepage` varchar(150) NOT NULL, 
     354  `image` varchar(150) NOT NULL, 
     355  `created` datetime NOT NULL, 
     356  `modified` datetime NOT NULL, 
     357  PRIMARY KEY  (`id`) 
     358) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
     359 
     360-- -------------------------------------------------------- 
     361 
     362--  
     363-- Table structure for table `sections` 
     364--  
     365 
     366DROP TABLE IF EXISTS `sections`; 
     367CREATE TABLE `sections` ( 
     368  `id` int(8) unsigned NOT NULL auto_increment, 
     369  `name` varchar(50) NOT NULL, 
     370  PRIMARY KEY  (`id`) 
     371) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; 
     372 
     373-- -------------------------------------------------------- 
     374 
     375--  
     376-- Table structure for table `states` 
     377--  
     378 
     379DROP TABLE IF EXISTS `states`; 
     380CREATE TABLE `states` ( 
     381  `id` tinyint(4) NOT NULL auto_increment, 
     382  `ab` char(2) collate utf8_unicode_ci NOT NULL, 
     383  `name` varchar(20) collate utf8_unicode_ci NOT NULL, 
     384  `cntry` varchar(13) collate utf8_unicode_ci NOT NULL, 
     385  PRIMARY KEY  (`id`) 
     386) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=67 ; 
     387 
     388-- -------------------------------------------------------- 
     389 
     390--  
     391-- Table structure for table `subjects` 
     392--  
     393 
     394DROP TABLE IF EXISTS `subjects`; 
     395CREATE TABLE `subjects` ( 
     396  `id` int(8) unsigned NOT NULL auto_increment, 
     397  `name` varchar(50) NOT NULL, 
     398  `created` datetime NOT NULL, 
     399  `modified` datetime NOT NULL, 
     400  PRIMARY KEY  (`id`) 
     401) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; 
     402 
     403-- -------------------------------------------------------- 
     404 
     405--  
     406-- Table structure for table `user_histories` 
     407--  
     408 
     409DROP TABLE IF EXISTS `user_histories`; 
     410CREATE TABLE `user_histories` ( 
     411  `id` int(10) unsigned NOT NULL auto_increment, 
     412  `username` varchar(32) NOT NULL, 
     413  `fullname` varchar(64) NOT NULL, 
     414  `groupname` varchar(32) NOT NULL, 
     415  `visitdate` datetime NOT NULL, 
     416  PRIMARY KEY  (`id`) 
     417) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 
     418 
     419-- -------------------------------------------------------- 
     420 
     421--  
     422-- Table structure for table `users` 
     423--  
     424 
     425DROP TABLE IF EXISTS `users`; 
     426CREATE TABLE `users` ( 
     427  `id` int(10) unsigned NOT NULL auto_increment, 
     428  `username` varchar(50) NOT NULL default '', 
     429  `passwd` varchar(32) NOT NULL default '', 
     430  `name` varchar(50) NOT NULL default '', 
     431  `email` varchar(100) NOT NULL default '', 
     432  `last_visit` datetime NOT NULL default '0000-00-00 00:00:00', 
     433  `group_id` int(10) unsigned NOT NULL default '0', 
     434  `profile_id` int(8) unsigned NOT NULL default '0', 
     435  `active` tinyint(1) unsigned NOT NULL default '0', 
     436  `created` datetime NOT NULL default '0000-00-00 00:00:00', 
     437  `modified` datetime NOT NULL default '0000-00-00 00:00:00', 
     438  PRIMARY KEY  (`id`), 
     439  UNIQUE KEY `username` (`username`), 
     440  UNIQUE KEY `email` (`email`,`username`), 
     441  KEY `group_id` (`group_id`) 
     442) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; 
     443 
     444-- -------------------------------------------------------- 
     445 
     446--  
     447-- Table structure for table `videos` 
     448--  
     449 
     450DROP TABLE IF EXISTS `videos`; 
     451CREATE TABLE `videos` ( 
     452  `id` int(8) unsigned NOT NULL auto_increment, 
     453  `filename` varchar(255) NOT NULL, 
     454  `mimetype` varchar(255) NOT NULL, 
     455  `filesize` int(15) NOT NULL, 
     456  `video_location` varchar(255) NOT NULL, 
     457  `video_date` date NOT NULL, 
     458  `video_notes` text NOT NULL, 
     459  `copyright_owner` varchar(255) NOT NULL, 
     460  `copyright_id` int(8) unsigned NOT NULL, 
     461  `published` tinyint(1) NOT NULL, 
     462  `created` datetime NOT NULL, 
     463  `modified` datetime NOT NULL, 
     464  PRIMARY KEY  (`id`) 
     465) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ; 
     466 
     467 
     468-- phpMyAdmin SQL Dump 
     469-- version 2.9.1.1-Debian-2ubuntu1 
     470-- http://www.phpmyadmin.net 
     471--  
     472-- Host: localhost 
     473-- Generation Time: Apr 29, 2007 at 03:27 PM 
     474-- Server version: 5.0.38 
     475-- PHP Version: 5.2.1 
     476--  
     477-- Database: `webrocket` 
     478--  
     479 
     480--  
     481-- Dumping data for table `config_categories` 
     482--  
     483 
     484INSERT INTO `config_categories` (`id`, `name`, `descname`, `desc`) VALUES  
     485(1, 'general', 'Site Options', 'These are the main options that control the site'), 
     486(2, 'video', '', ''); 
    94487 
    95488--  
    …… 
    102495(3, 1, 'enable_captcha', '0'), 
    103496(4, 1, 'sitedesc', 'Built with CakePHP'), 
    104 (5, 1, 'sitename', 'Web Rocket'); 
    105  
    106 -- -------------------------------------------------------- 
    107  
    108 --  
    109 -- Table structure for table `copyrights` 
    110 --  
    111  
    112 DROP TABLE IF EXISTS `copyrights`; 
    113 CREATE TABLE `copyrights` ( 
    114   `id` int(8) unsigned NOT NULL, 
    115   `name` varchar(255) NOT NULL, 
    116   `licence` text NOT NULL, 
    117   PRIMARY KEY  (`id`) 
    118 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
     497(5, 1, 'sitename', 'Web Rocket'), 
     498(6, 2, 'width', '320'), 
     499(7, 2, 'height', '240'), 
     500(8, 2, 'samplerate', '22050'), 
     501(9, 2, 'bitrate', '32'); 
    119502 
    120503--  
    …… 
    130513(5, 'Creative Commons Attribution-Noncommercial-Share Alike 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by-nc-sa/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-nc-sa/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by-nc-sa/3.0/">Creative Commons Attribution-Noncommercial-Share Alike 3.0 License</a>.'), 
    131514(6, 'Creative Commons Attribution-Noncommercial-No Derivative Works 3.0', '<a rel="license" href="http://creativecommons.org/licenses/by-nc-nd/3.0/">\r\n<img alt="Creative Commons License" style="border-width:0" src="http://i.creativecommons.org/l/by-nc-nd/3.0/88x31.png" />\r\n</a>\r\n<br />This \r\n<span xmlns:dc="http://purl.org/dc/elements/1.1/" href="http://purl.org/dc/dcmitype/StillImage" rel="dc:type">work</span> is licensed under a \r\n<a rel="license" href="http://creativecommons.org/licenses/by-nc-nd/3.0/">Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 License</a>.'); 
    132  
    133 -- -------------------------------------------------------- 
    134  
    135 --  
    136 -- Table structure for table `countries` 
    137 --  
    138  
    139 DROP TABLE IF EXISTS `countries`; 
    140 CREATE TABLE `countries` ( 
    141   `id` smallint(6) NOT NULL auto_increment, 
    142   `twoAbrev` char(2) collate utf8_unicode_ci NOT NULL, 
    143   `threeAbrev` char(3) collate utf8_unicode_ci NOT NULL, 
    144   `code` int(11) NOT NULL default '0', 
    145   `name` varchar(50) collate utf8_unicode_ci NOT NULL, 
    146   PRIMARY KEY  (`id`) 
    147 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
    148515 
    149516--  
    …… 
    392759(239, 'ZW', 'ZWE', 716, 'Zimbabwe'); 
    393760 
    394 -- -------------------------------------------------------- 
    395  
    396 --  
    397 -- Table structure for table `event_types` 
    398 --  
    399  
    400 DROP TABLE IF EXISTS `event_types`; 
    401 CREATE TABLE `event_types` ( 
    402   `id` int(8) unsigned NOT NULL, 
    403   `name` varchar(50) NOT NULL, 
    404   PRIMARY KEY  (`id`) 
    405 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    406  
    407 --  
    408 -- Dumping data for table `event_types` 
    409 --  
    410  
    411 INSERT INTO `event_types` (`id`, `name`) VALUES  
    412 (0, 'Gig'), 
    413 (1, 'Release'); 
    414  
    415 -- -------------------------------------------------------- 
    416  
    417 --  
    418 -- Table structure for table `events` 
    419 --  
    420  
    421 DROP TABLE IF EXISTS `events`; 
    422 CREATE TABLE `events` ( 
    423   `id` int(8) unsigned NOT NULL auto_increment, 
    424   `venue` varchar(50) NOT NULL, 
    425   `address` varchar(255) default NULL, 
    426   `city` varchar(50) NOT NULL, 
    427   `country_id` int(3) NOT NULL, 
    428   `postcode` varchar(10) NOT NULL, 
    429   `lat` varchar(50) NOT NULL, 
    430   `long` varchar(50) NOT NULL, 
    431   `event_type_id` int(8) unsigned NOT NULL, 
    432   `event_date` date NOT NULL, 
    433   `event_time` time default NULL, 
    434   `event_url` varchar(255) default NULL, 
    435   `notes` text, 
    436   `user_id` int(8) unsigned NOT NULL, 
    437   `published` tinyint(1) NOT NULL, 
    438   `created` datetime NOT NULL, 
    439   `modified` datetime NOT NULL, 
    440   PRIMARY KEY  (`id`) 
    441 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    442  
    443 --  
    444 -- Dumping data for table `events` 
    445 --  
    446  
    447 INSERT INTO `events` (`id`, `venue`, `address`, `city`, `country_id`, `postcode`, `lat`, `long`, `event_type_id`, `event_date`, `event_time`, `event_url`, `notes`, `user_id`, `published`, `created`, `modified`) VALUES  
    448 (1, 'Test Event', '20 Dalgety Avenue', 'Edinburgh', 1, 'EH7 5UG', '', '', 0, '2007-06-30', '20:00:04', NULL, '<p style="background-color: #ff6600"><font color="#000000"><strong>This is a test event.</strong></font></p><p>This looks cool in the customised TinyMCE.&nbsp;</p>', 0, 1, '2007-04-21 20:07:36', '2007-04-21 20:30:04'); 
    449  
    450 -- -------------------------------------------------------- 
    451  
    452 --  
    453 -- Table structure for table `feeds` 
    454 --  
    455  
    456 DROP TABLE IF EXISTS `feeds`; 
    457 CREATE TABLE `feeds` ( 
    458   `id` int(8) unsigned NOT NULL auto_increment, 
    459   `feed_name` varchar(255) NOT NULL, 
    460   `feed_url` varchar(255) NOT NULL, 
    461   `published` tinyint(1) NOT NULL default '0', 
    462   `created` datetime NOT NULL, 
    463   `modified` datetime NOT NULL, 
    464   PRIMARY KEY  (`id`) 
    465 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    466  
    467 --  
    468 -- Dumping data for table `feeds` 
    469 --  
    470  
    471 INSERT INTO `feeds` (`id`, `feed_name`, `feed_url`, `published`, `created`, `modified`) VALUES  
    472 (4, 'SIte News', 'http://webrocket/posts/feed', 1, '2007-04-21 13:01:01', '2007-04-21 20:26:58'), 
    473 (2, 'John Resig', 'http://jquery.com/blog/feed/', 1, '2007-04-20 23:25:17', '2007-04-21 20:27:07'), 
    474 (3, 'Cakebaker', 'http://cakebaker.42dh.com/feed/', 1, '2007-04-20 23:25:35', '2007-04-21 20:27:14'); 
    475  
    476 -- -------------------------------------------------------- 
    477  
    478 --  
    479 -- Table structure for table `galleries` 
    480 --  
    481  
    482 DROP TABLE IF EXISTS `galleries`; 
    483 CREATE TABLE `galleries` ( 
    484   `id` int(8) unsigned NOT NULL auto_increment, 
    485   `name` varchar(255) NOT NULL, 
    486   `url` varchar(255) NOT NULL, 
    487   `primary_image` int(8) unsigned NOT NULL, 
    488   `published` tinyint(1) NOT NULL, 
    489   `created` datetime NOT NULL, 
    490   `modified` datetime NOT NULL, 
    491   PRIMARY KEY  (`id`) 
    492 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    493  
    494 --  
    495 -- Dumping data for table `galleries` 
    496 --  
    497  
    498  
    499 -- -------------------------------------------------------- 
    500  
    501 --  
    502 -- Table structure for table `galleries_images` 
    503 --  
    504  
    505 DROP TABLE IF EXISTS `galleries_images`; 
    506 CREATE TABLE `galleries_images` ( 
    507   `gallery_id` int(8) unsigned NOT NULL, 
    508   `image_id` int(8) unsigned NOT NULL 
    509 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    510  
    511 --  
    512 -- Dumping data for table `galleries_images` 
    513 --  
    514  
    515  
    516 -- -------------------------------------------------------- 
    517  
    518 --  
    519 -- Table structure for table `groups` 
    520 --  
    521  
    522 DROP TABLE IF EXISTS `groups`; 
    523 CREATE TABLE `groups` ( 
    524   `id` int(10) unsigned NOT NULL auto_increment, 
    525   `name` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL, 
    526   `level` int(11) NOT NULL, 
    527   `redirect` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL, 
    528   `perm_type` enum('allow','deny') NOT NULL default 'allow', 
    529   `created` datetime NOT NULL default '0000-00-00 00:00:00', 
    530   `modified` datetime NOT NULL default '0000-00-00 00:00:00', 
    531   PRIMARY KEY  (`id`) 
    532 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    533  
    534761--  
    535762-- Dumping data for table `groups` 
    …… 
    541768(3, 'Registered Members', 100, '', 'allow', '2007-03-26 00:00:00', '0000-00-00 00:00:00'); 
    542769 
    543 -- -------------------------------------------------------- 
    544  
    545 --  
    546 -- Table structure for table `groups_permissions` 
    547 --  
    548  
    549 DROP TABLE IF EXISTS `groups_permissions`; 
    550 CREATE TABLE `groups_permissions` ( 
    551   `group_id` int(10) unsigned NOT NULL default '0', 
    552   `permission_id` int(10) unsigned NOT NULL default '0', 
    553   KEY `group_id` (`group_id`,`permission_id`) 
    554 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    555  
    556770--  
    557771-- Dumping data for table `groups_permissions` 
    …… 
    559773 
    560774INSERT INTO `groups_permissions` (`group_id`, `permission_id`) VALUES  
    561 (1, 1); 
    562  
    563 -- -------------------------------------------------------- 
    564  
    565 --  
    566 -- Table structure for table `images` 
    567 --  
    568  
    569 DROP TABLE IF EXISTS `images`; 
    570 CREATE TABLE `images` ( 
    571   `id` int(8) unsigned NOT NULL auto_increment, 
    572   `filename` varchar(150) NOT NULL, 
    573   `filesize` int(11) NOT NULL, 
    574   `alt` varchar(255) NOT NULL, 
    575   `type` varchar(15) NOT NULL, 
    576   `copyright_owner` varchar(255) default NULL, 
    577   `copyright_id` int(8) unsigned NOT NULL default '1', 
    578   `lat` decimal(10,0) default NULL, 
    579   `long` decimal(10,0) default NULL, 
    580   `created` datetime NOT NULL, 
    581   `modified` datetime NOT NULL, 
    582   PRIMARY KEY  (`id`), 
    583   UNIQUE KEY `filename` (`filename`) 
    584 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1; 
    585  
    586 --  
    587 -- Dumping data for table `images` 
    588 --  
    589  
    590 INSERT INTO `images` (`id`, `filename`, `filesize`, `alt`, `type`, `copyright_owner`, `copyright_id`, `lat`, `long`, `created`, `modified`) VALUES  
    591 (32, 'Group3w600', 54621, 'The Hedrons High Res 1', 'image/jpeg', 'The Hedrons', 6, NULL, NULL, '2007-04-25 16:35:25', '2007-04-25 16:35:25'); 
    592  
    593 -- -------------------------------------------------------- 
    594  
    595 --  
    596 -- Table structure for table `login_attempts` 
    597 --  
    598  
    599 DROP TABLE IF EXISTS `login_attempts`; 
    600 CREATE TABLE `login_attempts` ( 
    601   `ip` varchar(15) character set utf8 collate utf8_unicode_ci NOT NULL, 
    602   `num` int(11) NOT NULL default '1', 
    603   `expire` datetime NOT NULL, 
    604   `created` datetime NOT NULL, 
    605   PRIMARY KEY  (`ip`) 
    606 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    607  
    608 --  
    609 -- Dumping data for table `login_attempts` 
    610 --  
    611  
    612  
    613 -- -------------------------------------------------------- 
    614  
    615 --  
    616 -- Table structure for table `menus` 
    617 --  
    618  
    619 DROP TABLE IF EXISTS `menus`; 
    620 CREATE TABLE `menus` ( 
    621   `id` int(11) unsigned NOT NULL auto_increment, 
    622   `name` varchar(50) NOT NULL, 
    623   `url` varchar(150) NOT NULL, 
    624   `position` int(5) NOT NULL, 
    625   `icon` varchar(255) default NULL, 
    626   `parent_id` int(11) unsigned NOT NULL, 
    627   `section_id` int(11) unsigned NOT NULL, 
    628   `access_level` int(3) NOT NULL, 
    629   PRIMARY KEY  (`id`) 
    630 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
     775(1, 1), 
     776(2, 2), 
     777(2, 3), 
     778(2, 4), 
     779(2, 5), 
     780(2, 6); 
    631781 
    632782--  
    …… 
    638788(2, 'News', '/posts/index', 1, NULL, 0, 1, 0), 
    639789(3, 'Tour Dates', '/events/index', 2, NULL, 0, 1, 0), 
    640 (4, 'Manage Posts', '/admin/posts/', 0, 'admin-posts', 0, 3, 100), 
    641 (5, 'Manage Pages', '/admin/pages/', 1, 'admin-pages', 0, 3, 100), 
    642 (6, 'Manage Events', '/admin/events/', 2, 'admin-events', 0, 3, 100), 
    643 (7, 'Manage Feeds', '/admin/feeds/', 3, 'admin-feeds', 0, 3, 100), 
    644 (8, 'Manage Users', '/admin/users/', 4, 'admin-users', 0, 3, 100), 
    645 (9, 'Manage Images', '/admin/images/', 5, 'admin-images', 0, 3, 100), 
    646 (10, 'Manage Configurations', '/admin/configs/edit', 8, 'admin-options', 0, 3, 100), 
    647 (11, 'Manage Galleries', '/admin/galleries', 7, 'admin-galleries', 0, 3, 100), 
    648 (12, 'Admin', '/admin/home', 3, NULL, 0, 1, 200), 
     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), 
    649799(13, 'Galleries', '/galleries/', 3, NULL, 0, 1, 0), 
    650 (14, 'Manage Videos', '/admin/videos', 6, 'admin-videos', 0, 3, 100); 
    651  
    652 -- -------------------------------------------------------- 
    653  
    654 --  
    655 -- Table structure for table `pages` 
    656 --  
    657  
    658 DROP TABLE IF EXISTS `pages`; 
    659 CREATE TABLE `pages` ( 
    660   `id` int(8) unsigned NOT NULL auto_increment, 
    661   `url` varchar(150) NOT NULL, 
    662   `title` varchar(50) NOT NULL, 
    663   `body` text NOT NULL, 
    664   `published` tinyint(1) NOT NULL default '0', 
    665   `user_id` int(8) unsigned NOT NULL, 
    666   `subject_id` int(8) unsigned NOT NULL, 
    667   `copyright_id` int(8) unsigned NOT NULL default '1', 
    668   `created` datetime NOT NULL, 
    669   `modified` datetime NOT NULL, 
    670   PRIMARY KEY  (`id`) 
    671 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    672  
    673 --  
    674 -- Dumping data for table `pages` 
    675 --  
    676  
    677  
    678 -- -------------------------------------------------------- 
    679  
    680 --  
    681 -- Table structure for table `permissions` 
    682 --  
    683  
    684 DROP TABLE IF EXISTS `permissions`; 
    685 CREATE TABLE `permissions` ( 
    686   `id` int(10) unsigned NOT NULL auto_increment, 
    687   `name` varchar(50) NOT NULL default '', 
    688   `created` datetime NOT NULL default '0000-00-00 00:00:00', 
    689   `modified` datetime NOT NULL default '0000-00-00 00:00:00', 
    690   PRIMARY KEY  (`id`), 
    691   UNIQUE KEY `name` (`name`) 
    692 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
     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); 
    693814 
    694815--  
    …… 
    697818 
    698819INSERT INTO `permissions` (`id`, `name`, `created`, `modified`) VALUES  
    699 (1, '*', '2007-03-26 00:00:00', '0000-00-00 00:00:00'); 
    700  
    701 -- -------------------------------------------------------- 
    702  
    703 --  
    704 -- Table structure for table `posts` 
    705 --  
    706  
    707 DROP TABLE IF EXISTS `posts`; 
    708 CREATE TABLE `posts` ( 
    709   `id` int(8) unsigned NOT NULL auto_increment, 
    710   `title` varchar(150) NOT NULL, 
    711   `byline` varchar(255) NOT NULL, 
    712   `body` text NOT NULL, 
    713   `user_id` int(8) unsigned NOT NULL, 
    714   `subject_id` int(8) unsigned NOT NULL, 
    715   `copyright_id` int(8) unsigned NOT NULL default '1', 
    716   `url` varchar(200) NOT NULL, 
    717   `published` tinyint(1) NOT NULL default '0', 
    718   `created` datetime NOT NULL, 
    719   `modified` datetime NOT NULL, 
    720   PRIMARY KEY  (`id`) 
    721 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    722  
    723 --  
    724 -- Dumping data for table `posts` 
    725 --  
    726  
    727 INSERT INTO `posts` (`id`, `title`, `byline`, `body`, `user_id`, `subject_id`, `copyright_id`, `url`, `published`, `created`, `modified`) VALUES  
    728 (1, 'Welcome to Webrocket', 'A new CMS built on CakePHP & jQuery', '<p><img src="../../../files/Image/Group3w600.medium.jpg" border="0" alt="Rocket" align="left" />Welcome to Webrocket!  Webrocket is a new Content Management System (CMS) built upon the framework of <a href="http://cakephp.org">CakePHP</a> , and AJAX-powered with <a href="http://jquery.com">jQuery</a> .</p><p>CakePHP aims to be a powerful CMS that provides:</p><ul><li>A fully featured Custom Content System, allows you to define how your content types are stored and displayed.</li><li>Output available in many API&#39;s - HTML + hAtom, RSS, JSON, REST, XML + XSL .</li><li>AJAX powered by jQuery, provides work-flow improvements, as well as &quot;fancy&quot; effects.</li><li>Template system that uses widgets to define where content sits (Easy Drag &amp; Drop interface)</li><li>Admin system that is available on any page for rapid creation and editing of documents.</li><li>Asset Management for Images, Media and Documents.  Allow upload, viewing and download of files.</li><li>Plugins to provide E-Commerce, Forums, Maps, Site Tracking.<br /></li><li>WYSIWYG editing interface with a customised TinyMCE. </li><li>100% Open Source<br /></li></ul>', 1, 1, 1, 'welcome_to_webrocket', 1, '2007-04-20 23:14:31', '2007-04-24 16:18:51'); 
    729  
    730 -- -------------------------------------------------------- 
    731  
    732 --  
    733 -- Table structure for table `profiles` 
    734 --  
    735  
    736 DROP TABLE IF EXISTS `profiles`; 
    737 CREATE TABLE `profiles` ( 
    738   `id` int(8) unsigned NOT NULL auto_increment, 
    739   `user_id` int(8) unsigned NOT NULL, 
    740   `country` varchar(2) NOT NULL, 
    741   `dob` date NOT NULL, 
    742   `homepage` varchar(150) NOT NULL, 
    743   `image` varchar(150) NOT NULL, 
    744   `created` datetime NOT NULL, 
    745   `modified` datetime NOT NULL, 
    746   PRIMARY KEY  (`id`) 
    747 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    748  
    749 --  
    750 -- Dumping data for table `profiles` 
    751 --  
    752  
    753  
    754 -- -------------------------------------------------------- 
    755  
    756 --  
    757 -- Table structure for table `sections` 
    758 --  
    759  
    760 DROP TABLE IF EXISTS `sections`; 
    761 CREATE TABLE `sections` ( 
    762   `id` int(8) unsigned NOT NULL auto_increment, 
    763   `name` varchar(50) NOT NULL, 
    764   PRIMARY KEY  (`id`) 
    765 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
     820(1, '*', '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
     821(2, 'posts', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     822(3, 'pages', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     823(4, 'videos', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     824(5, 'images', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     825(6, 'menus', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     826(7, 'events', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     827(8, 'users', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     828(9, 'feeds', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     829(10, 'galleries', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); 
    766830 
    767831--  
    …… 
    773837(2, 'User Menu'), 
    774838(3, 'admin_home'); 
    775  
    776 -- -------------------------------------------------------- 
    777  
    778 --  
    779 -- Table structure for table `states` 
    780 --  
    781  
    782 DROP TABLE IF EXISTS `states`; 
    783 CREATE TABLE `states` ( 
    784   `id` tinyint(4) NOT NULL auto_increment, 
    785   `ab` char(2) collate utf8_unicode_ci NOT NULL, 
    786   `name` varchar(20) collate utf8_unicode_ci NOT NULL, 
    787   `cntry` varchar(13) collate utf8_unicode_ci NOT NULL, 
    788   PRIMARY KEY  (`id`) 
    789 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
    790839 
    791840--  
    …… 
    861910(66, 'WY', 'Wyoming', 'United States'); 
    862911 
    863 -- -------------------------------------------------------- 
    864  
    865 --  
    866 -- Table structure for table `subjects` 
    867 --  
    868  
    869 DROP TABLE IF EXISTS `subjects`; 
    870 CREATE TABLE `subjects` ( 
    871   `id` int(8) unsigned NOT NULL auto_increment, 
    872   `name` varchar(50) NOT NULL, 
    873   `created` datetime NOT NULL, 
    874   `modified` datetime NOT NULL, 
    875   PRIMARY KEY  (`id`) 
    876 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    877  
    878 --  
    879 -- Dumping data for table `subjects` 
    880 --  
    881  
    882 INSERT INTO `subjects` (`id`, `name`, `created`, `modified`) VALUES  
    883 (1, 'Webrocket', '2007-04-20 22:58:49', '2007-04-20 22:58:49'), 
    884 (2, 'Blog', '2007-04-20 22:58:57', '2007-04-20 22:58:57'); 
    885  
    886 -- -------------------------------------------------------- 
    887  
    888 --  
    889 -- Table structure for table `user_histories` 
    890 --  
    891  
    892 DROP TABLE IF EXISTS `user_histories`; 
    893 CREATE TABLE `user_histories` ( 
    894   `id` int(10) unsigned NOT NULL auto_increment, 
    895   `username` varchar(32) NOT NULL, 
    896   `fullname` varchar(64) NOT NULL, 
    897   `groupname` varchar(32) NOT NULL, 
    898   `visitdate` datetime NOT NULL, 
    899   PRIMARY KEY  (`id`) 
    900 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    901  
    902 --  
    903 -- Dumping data for table `user_histories` 
    904 --  
    905  
    906  
    907 -- -------------------------------------------------------- 
    908  
    909 --  
    910 -- Table structure for table `users` 
    911 --  
    912  
    913 DROP TABLE IF EXISTS `users`; 
    914 CREATE TABLE `users` ( 
    915   `id` int(10) unsigned NOT NULL auto_increment, 
    916   `username` varchar(50) NOT NULL default '', 
    917   `passwd` varchar(32) NOT NULL default '', 
    918   `name` varchar(50) NOT NULL default '', 
    919   `email` varchar(100) NOT NULL default '', 
    920   `last_visit` datetime NOT NULL default '0000-00-00 00:00:00', 
    921   `group_id` int(10) unsigned NOT NULL default '0', 
    922   `profile_id` int(8) unsigned NOT NULL default '0', 
    923   `active` tinyint(1) unsigned NOT NULL default '0', 
    924   `created` datetime NOT NULL default '0000-00-00 00:00:00', 
    925   `modified` datetime NOT NULL default '0000-00-00 00:00:00', 
    926   PRIMARY KEY  (`id`), 
    927   UNIQUE KEY `username` (`username`), 
    928   UNIQUE KEY `email` (`email`,`username`), 
    929   KEY `group_id` (`group_id`) 
    930 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8; 
    931  
    932912--  
    933913-- Dumping data for table `users` 
    …… 
    935915 
    936916INSERT INTO `users` (`id`, `username`, `passwd`, `name`, `email`, `last_visit`, `group_id`, `profile_id`, `active`, `created`, `modified`) VALUES  
    937 (1, 'WebrocketAdmin', 'fdfedc01c66e9ea2817508ca1097df2f', 'Webrocket Admin', 'tane@nohalfmeasures.com', '2007-04-25 17:41:35', 1, 1, 1, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
    938 (2, 'Member', 'aa08769cdcb26674c6706093503ff0a3', 'Member', 'member@member.com', '2007-04-21 21:02:36', 3, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); 
    939  
    940 -- -------------------------------------------------------- 
    941  
    942 --  
    943 -- Table structure for table `videos` 
    944 --  
    945  
    946 DROP TABLE IF EXISTS `videos`; 
    947 CREATE TABLE `videos` ( 
    948   `id` int(8) unsigned NOT NULL auto_increment, 
    949   `filename` varchar(255) NOT NULL, 
    950   `mimetype` varchar(255) NOT NULL, 
    951   `filesize` int(15) NOT NULL, 
    952   `copyright_owner` varchar(255) NOT NULL, 
    953   `copyright_id` int(8) unsigned NOT NULL, 
    954   `created` datetime NOT NULL, 
    955   `modified` datetime NOT NULL, 
    956   PRIMARY KEY  (`id`) 
    957 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1; 
    958  
    959 --  
    960 -- Dumping data for table `videos` 
    961 --  
    962  
    963 INSERT INTO `videos` (`id`, `filename`, `mimetype`, `filesize`, `copyright_owner`, `copyright_id`, `created`, `modified`) VALUES  
    964 (9, 'ineedyou', 'video/mpeg', 118468608, 'The Hedrons', 6, '2007-04-25 15:41:03', '2007-04-25 15:41:03'); 
    965  
     917(1, 'WebrocketAdmin', 'fdfedc01c66e9ea2817508ca1097df2f', 'Webrocket Admin', 'tane@nohalfmeasures.com', '2007-04-29 15:15:23', 1, 1, 1, '2007-03-26 00:00:00', '0000-00-00 00:00:00'), 
     918(2, 'Member', 'aa08769cdcb26674c6706093503ff0a3', 'Member', 'member@member.com', '2007-04-26 13:43:34', 3, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), 
     919(3, 'Editor', '5aee9dbd2a188839105073571bee1b1f', 'Site', 'Editor', '2007-04-27 10:02:45', 2, 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');