|
DROP TABLE IF EXISTS `#__abauthor`; |
|
DROP TABLE IF EXISTS `#__abbook`; |
|
DROP TABLE IF EXISTS `#__abbookauth`; |
|
DROP TABLE IF EXISTS `#__abcategories`; |
|
DROP TABLE IF EXISTS `#__abeditor`; |
|
DROP TABLE IF EXISTS `#__ablibrary`; |
|
DROP TABLE IF EXISTS `#__ablocations`; |
|
|
|
CREATE TABLE `#__abauthor` ( |
|
`id` TINYTEXT NOT NULL, |
|
`lastname` TEXT NOT NULL, |
|
`name` TEXT NOT NULL, |
|
`alias` TEXT NOT NULL, |
|
`image` TEXT NOT NULL, |
|
`description` TEXT NOT NULL, |
|
`checked_out` TEXT NOT NULL, |
|
`checked_out_time` TEXT NOT NULL, |
|
`metakey` TEXT NOT NULL, |
|
`metadesc` TEXT NOT NULL, |
|
`state` TEXT NOT NULL, |
|
`language` TEXT NOT NULL, |
|
INDEX `PK` (`id`(10)) |
|
) |
|
; |
|
|
|
CREATE TABLE `#__abbook` ( |
|
`id` TINYTEXT NOT NULL, |
|
`asset_id` TEXT NOT NULL, |
|
`title` TEXT NOT NULL, |
|
`subtitle` TEXT NOT NULL, |
|
`alias` TEXT NOT NULL, |
|
`ideditor` TEXT NOT NULL, |
|
`price` TEXT NOT NULL, |
|
`pag` TEXT NOT NULL, |
|
`pag_index` TEXT NOT NULL, |
|
`user_id` TEXT NOT NULL, |
|
`created_by_alias` TEXT NOT NULL, |
|
`description` LONGTEXT NOT NULL, |
|
`image` TEXT NOT NULL, |
|
`docsfolder` TEXT NOT NULL, |
|
`file` TEXT NOT NULL, |
|
`year` TEXT NOT NULL, |
|
`idlocation` TEXT NOT NULL, |
|
`idlibrary` TEXT NOT NULL, |
|
`vote` TEXT NOT NULL, |
|
`numvote` TEXT NOT NULL, |
|
`hits` TEXT NOT NULL, |
|
`state` TEXT NOT NULL, |
|
`catid` TEXT NOT NULL, |
|
`qty` TEXT NOT NULL, |
|
`isbn` TEXT NOT NULL, |
|
`issn` TEXT NOT NULL, |
|
`doi` TEXT NOT NULL, |
|
`numpublication` TEXT NOT NULL, |
|
`approved` TEXT NOT NULL, |
|
`userid` TEXT NOT NULL, |
|
`url` TEXT NOT NULL, |
|
`url_label` TEXT NOT NULL, |
|
`dateinsert` TEXT NOT NULL, |
|
`catalogo` TEXT NOT NULL, |
|
`checked_out` TEXT NOT NULL, |
|
`checked_out_time` TEXT NOT NULL, |
|
`access` TEXT NOT NULL, |
|
`metakey` TEXT NOT NULL, |
|
`metadesc` TEXT NOT NULL, |
|
`metadata` TEXT NOT NULL, |
|
`language` TEXT NOT NULL, |
|
`ordering` TEXT NOT NULL, |
|
`params` TEXT NOT NULL, |
|
`note` TEXT NOT NULL, |
|
`editedby` TEXT NOT NULL, |
|
INDEX `PK` (`id`(10)) |
|
) |
|
COLLATE='utf8_general_ci' |
|
ENGINE=InnoDB |
|
; |
|
|
|
CREATE TABLE `#__abbookauth` ( |
|
`id` TINYTEXT NULL, |
|
`ordering` TINYTEXT NULL, |
|
`idbook` TINYTEXT NULL, |
|
`idauth` TINYTEXT NULL |
|
) |
|
COLLATE='utf8_general_ci' |
|
ENGINE=InnoDB |
|
; |
|
|
|
CREATE TABLE `#__abcategories` ( |
|
`id` TINYTEXT NULL, |
|
`asset_id` TINYTEXT NULL, |
|
`parent_id` TINYTEXT NULL, |
|
`lft` TEXT NULL, |
|
`rgt` TEXT NULL, |
|
`level` TEXT NULL, |
|
`path` TEXT NULL, |
|
`extension` TEXT NULL, |
|
`title` TEXT NULL, |
|
`alias` TEXT NULL, |
|
`note` TEXT NULL, |
|
`description` TEXT NULL, |
|
`published` TEXT NULL, |
|
`checked_out` TEXT NULL, |
|
`checked_out_time` TEXT NULL, |
|
`access` TEXT NULL, |
|
`params` TEXT NULL, |
|
`metadesc` TEXT NULL, |
|
`metakey` TEXT NULL, |
|
`metadata` TEXT NULL, |
|
`created_user_id` TEXT NULL, |
|
`created_time` TEXT NULL, |
|
`modified_user_id` TEXT NULL, |
|
`modified_time` TEXT NULL, |
|
`hits` TEXT NULL, |
|
`language` TEXT NULL, |
|
`version` TEXT NULL, |
|
INDEX `PK` (`id`(10)) |
|
) |
|
COLLATE='utf8_general_ci' |
|
ENGINE=InnoDB |
|
; |
|
|
|
CREATE TABLE `#__abeditor` ( |
|
`id` TINYTEXT NOT NULL, |
|
`name` TEXT NULL, |
|
`alias` TEXT NULL, |
|
`description` TEXT NULL, |
|
`checked_out` TEXT NULL, |
|
`checked_out_time` TEXT NULL, |
|
`metakey` TEXT NULL, |
|
`metadesc` TEXT NULL, |
|
`state` TEXT NULL, |
|
`language` TEXT NULL |
|
) |
|
COLLATE='utf8_general_ci' |
|
ENGINE=InnoDB |
|
; |
|
|
|
CREATE TABLE `#__ablibrary` ( |
|
`id` TINYTEXT NOT NULL, |
|
`name` TEXT NULL, |
|
`alias` TEXT NULL, |
|
`description` TEXT NULL, |
|
`email` TEXT NULL, |
|
`checked_out` TEXT NULL, |
|
`checked_out_time` TEXT NULL, |
|
`state` TEXT NULL, |
|
`language` TEXT NULL, |
|
INDEX `PK` (`id`(10)) |
|
) |
|
COLLATE='utf8_general_ci' |
|
ENGINE=InnoDB |
|
; |
|
|
|
CREATE TABLE `#__ablocations` ( |
|
`id` TINYTEXT NOT NULL, |
|
`name` TEXT NULL, |
|
`alias` TEXT NULL, |
|
`checked_out` TEXT NULL, |
|
`checked_out_time` TEXT NULL, |
|
`state` TEXT NULL, |
|
`language` TEXT NULL, |
|
INDEX `PK` (`id`(10)) |
|
) |
|
COLLATE='utf8_general_ci' |
|
ENGINE=InnoDB |
|
; |