Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
branch: master
Fetching contributors…

Cannot retrieve contributors at this time

37 lines (35 sloc) 1.639 kB
CREATE TABLE IF NOT EXISTS `brw_files` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci NOT NULL,
`record_id` int(10) unsigned NOT NULL,
`model` varchar(255) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci NOT NULL,
`category_code` char(10) collate utf8_unicode_ci NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `category_code` (`category_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `brw_images` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`name` varchar(255) collate utf8_unicode_ci NOT NULL,
`record_id` int(10) unsigned NOT NULL,
`model` varchar(255) collate utf8_unicode_ci NOT NULL,
`description` varchar(255) collate utf8_unicode_ci NOT NULL,
`category_code` char(10) collate utf8_unicode_ci NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `category_code` (`category_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `brw_users` (
`id` int(5) unsigned NOT NULL auto_increment,
`email` varchar(50) collate utf8_unicode_ci NOT NULL,
`password` varchar(255) collate utf8_unicode_ci NOT NULL,
`root` tinyint(1) NOT NULL default '1',
`last_login` datetime NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
Jump to Line
Something went wrong with that request. Please try again.