`resource` TEXT,\r
`language_code` varchar(20) default NULL,\r
PRIMARY KEY (`primary_resource_id`)\r
`resource` TEXT,\r
`language_code` varchar(20) default NULL,\r
PRIMARY KEY (`primary_resource_id`)\r
\r
CREATE TABLE `primary_resources_types` (\r
`primary_resource_id` mediumint(8) unsigned NOT NULL,\r
`type_id` mediumint(8) unsigned NOT NULL,\r
PRIMARY KEY (`primary_resource_id`,`type_id`)\r
\r
CREATE TABLE `primary_resources_types` (\r
`primary_resource_id` mediumint(8) unsigned NOT NULL,\r
`type_id` mediumint(8) unsigned NOT NULL,\r
PRIMARY KEY (`primary_resource_id`,`type_id`)\r
\r
CREATE TABLE `resource_types` (\r
`type_id` mediumint(8) unsigned NOT NULL auto_increment,\r
`type` TEXT,\r
PRIMARY KEY (`type_id`)\r
\r
CREATE TABLE `resource_types` (\r
`type_id` mediumint(8) unsigned NOT NULL auto_increment,\r
`type` TEXT,\r
PRIMARY KEY (`type_id`)\r
\r
CREATE TABLE `secondary_resources` (\r
`secondary_resource_id` mediumint(8) unsigned NOT NULL auto_increment,\r
\r
CREATE TABLE `secondary_resources` (\r
`secondary_resource_id` mediumint(8) unsigned NOT NULL auto_increment,\r
`secondary_resource` TEXT,\r
`language_code` varchar(20) default NULL,\r
PRIMARY KEY (`secondary_resource_id`)\r
`secondary_resource` TEXT,\r
`language_code` varchar(20) default NULL,\r
PRIMARY KEY (`secondary_resource_id`)\r
\r
CREATE TABLE `secondary_resources_types` (\r
`secondary_resource_id` mediumint(8) unsigned NOT NULL,\r
`type_id` mediumint(8) unsigned NOT NULL,\r
PRIMARY KEY (`secondary_resource_id`,`type_id`)\r
\r
CREATE TABLE `secondary_resources_types` (\r
`secondary_resource_id` mediumint(8) unsigned NOT NULL,\r
`type_id` mediumint(8) unsigned NOT NULL,\r
PRIMARY KEY (`secondary_resource_id`,`type_id`)\r