36 lines
1.4 KiB
SQL
36 lines
1.4 KiB
SQL
CREATE TABLE IF NOT EXISTS `#__foos_details` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
|
|
`name` varchar(255) NOT NULL DEFAULT '',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
|
|
|
|
INSERT INTO `#__foos_details` (`name`) VALUES
|
|
('Nina'),
|
|
('Astrid'),
|
|
('Elmar');
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `access` int(10) unsigned NOT NULL DEFAULT 0 AFTER `alias`;
|
|
|
|
ALTER TABLE `#__foos_details` ADD KEY `idx_access` (`access`);
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `catid` int(11) NOT NULL DEFAULT 0 AFTER `alias`;
|
|
|
|
ALTER TABLE `#__foos_details` ADD KEY `idx_catid` (`catid`);
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `state` tinyint(3) NOT NULL DEFAULT 0 AFTER `alias`;
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `published` tinyint(1) NOT NULL DEFAULT 0 AFTER `alias`;
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `publish_up` datetime AFTER `alias`;
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `publish_down` datetime AFTER `alias`;
|
|
|
|
ALTER TABLE `#__foos_details` ADD KEY `idx_state` (`published`);
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `language` char(7) NOT NULL DEFAULT '*' AFTER `alias`;
|
|
|
|
ALTER TABLE `#__foos_details` ADD KEY `idx_language` (`language`);
|
|
|
|
ALTER TABLE `#__foos_details` ADD COLUMN `ordering` int(11) NOT NULL DEFAULT 0 AFTER `alias`;
|