Changeset 15793 for trunk/install

Timestamp:

12/22/11 00:15:32 (5 months ago)

Author:

Alexander Trofimov

Message:

Form objects

File:

• trunk/install/sql/v70.sql (modified) (10 diffs)

trunk/install/sql/v70.sql

@@ -4534 +4534 @@
 
 
+CREATE TABLE IF NOT EXISTS `sys_objects_form` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `object` varchar(32) NOT NULL,
+  `title` varchar(255) NOT NULL,
+  `action` varchar(255) NOT NULL,
+  `form_attrs` text NOT NULL,
+  `submit_name` varchar(255) NOT NULL,
+  `table` varchar(255) NOT NULL,
+  `key` varchar(255) NOT NULL,
+  `uri` varchar(255) NOT NULL,
+  `uri_title` varchar(255) NOT NULL,
+  `params` text NOT NULL,
+  `deleteable` tinyint(4) NOT NULL DEFAULT '1',
+  `active` tinyint(4) NOT NULL DEFAULT '0',
+  `override_class_name` varchar(255) NOT NULL,
+  `override_class_file` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `object` (`object`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
+
+
+CREATE TABLE IF NOT EXISTS `sys_form_displays` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `display_name` varchar(32) NOT NULL,
+  `module` varchar(32) NOT NULL,
+  `object` varchar(32) NOT NULL,
+  `title` varchar(255) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `object_display_name` (`object`,`display_name`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
+
+
+CREATE TABLE IF NOT EXISTS `sys_form_inputs` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `object` varchar(32) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `value` varchar(255) NOT NULL,
+  `values` text NOT NULL,
+  `checked` tinyint(4) NOT NULL DEFAULT '0',
+  `type` varchar(32) NOT NULL,
+  `caption` varchar(255) NOT NULL,
+  `info` varchar(255) NOT NULL,
+  `required` tinyint(4) NOT NULL DEFAULT '0',
+  `collapsed` tinyint(4) NOT NULL DEFAULT '0',
+  `colspan` tinyint(4) NOT NULL DEFAULT '0',
+  `html` tinyint(4) NOT NULL DEFAULT '0',
+  `attrs` text NOT NULL,
+  `attrs_tr` text NOT NULL,
+  `attrs_wrapper` text NOT NULL,
+  `checker_func` varchar(32) NOT NULL,
+  `checker_params` text NOT NULL,
+  `checker_error` varchar(255) NOT NULL,
+  `db_pass` varchar(32) NOT NULL,
+  `db_params` text NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `display_name` (`object`,`name`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
+
+
+CREATE TABLE IF NOT EXISTS `sys_form_display_inputs` (
+  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `display_name` varchar(32) NOT NULL,
+  `input_name` varchar(32) NOT NULL,
+  `hidden_for_levels` int(10) unsigned NOT NULL,
+  `active` tinyint(4) NOT NULL DEFAULT '0',
+  `order` int(11) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `display_input` (`display_name`,`input_name`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
+
+
+-- --------------------------------------------------------
+
+
 CREATE TABLE IF NOT EXISTS `sys_objects_menu` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
@@ -4623 +4700 @@
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_objects_grid`
---
 INSERT INTO `sys_objects_grid` (`object`, `source_type`, `source`, `table`, `field_id`, `field_order`, `field_active`, `paginate_url`, `paginate_per_page`, `paginate_simple`, `paginate_get_start`, `paginate_get_per_page`, `filter_fields`, `filter_mode`, `sorting_fields`, `override_class_name`, `override_class_file`) VALUES
 ('sys_studio_lang_keys', 'Sql', 'SELECT `tlk`.`ID` AS `id`, `tlk`.`Key` AS `key`, `tlc`.`Name` AS `module`, `tls`.`String` AS `string` FROM `sys_localization_keys` AS `tlk` LEFT JOIN `sys_localization_categories` AS `tlc` ON `tlk`.`IDCategory`=`tlc`.`ID` LEFT JOIN `sys_localization_strings` AS `tls` ON `tlk`.`ID`=`tls`.`IDKey` WHERE `tls`.`IDLanguage`=\'%d\'', 'sys_localization_keys', 'id', '', '', '', 20, NULL, 'start', '', 'key,string', 'auto', 'key,module,string', 'BxTemplStudioPolyglotKeys', ''),
@@ -4632 +4706 @@
 ('sys_studio_acl_prices', 'Sql', 'SELECT * FROM `sys_acl_level_prices` WHERE 1 ', 'sys_acl_level_prices', 'id', 'Order', '', '', 100, NULL, 'start', '', 'Days,Price', 'auto', '', 'BxTemplStudioPermissionsPrices', '');
 
- 
--- --------------------------------------------------------
+
 
 CREATE TABLE IF NOT EXISTS `sys_grid_fields` (
@@ -4646 +4719 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_grid_fields`
---
 INSERT INTO `sys_grid_fields` (`object`, `name`, `title`, `width`, `chars_limit`, `params`, `order`) VALUES
 ('sys_studio_lang_keys', 'checkbox', 'Select', '1%', '', '', 1),
@@ -4678 +4748 @@
 
 
--- --------------------------------------------------------
 
 CREATE TABLE IF NOT EXISTS `sys_grid_actions` (
@@ -4691 +4760 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
---
--- Dumping data for table `sys_grid_actions`
---
+
 INSERT INTO `sys_grid_actions` (`object`, `type`, `name`, `title`, `icon`, `confirm`, `order`) VALUES
 ('sys_studio_lang_keys', 'bulk', 'delete', '_adm_pgt_btn_delete', '', 1, 1),
@@ -4707 +4774 @@
 ('sys_studio_acl_prices', 'single', 'delete', '', 'cross.png', 1, 2);
 
--- --------------------------------------------------------
+
+-- --------------------------------------------------------
+
 
 CREATE TABLE IF NOT EXISTS `sys_objects_transcoder_images` (
@@ -4728 +4797 @@
 ('sys_icon_favicon', 'sys_images', 'Storage', 'a:1:{s:6:"object";s:10:"sys_images";}', 'no', '0', '0', '0');
 
+
+
 CREATE TABLE IF NOT EXISTS `sys_transcoder_images_files` (
   `transcoder_object` varchar(32) NOT NULL,
@@ -4738 +4809 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+
+
 CREATE TABLE IF NOT EXISTS `sys_transcoder_images_filters` (
   `transcoder_object` varchar(32) NOT NULL,
@@ -4749 +4822 @@
 ('sys_icon_facebook', 'Resize', 'a:4:{s:1:"w";s:3:"100";s:1:"h";s:3:"100";s:13:"square_resize";s:1:"1";s:10:"force_type";s:3:"png";}', '0'),
 ('sys_icon_favicon', 'Resize', 'a:4:{s:1:"w";s:2:"16";s:1:"h";s:2:"16";s:13:"square_resize";s:1:"1";s:10:"force_type";s:3:"png";}', '0');
+
 
 -- --------------------------------------------------------