mariovaldez.net :: View topic - Creating DB-Tables during installation

# phpMyAdmin SQL Dump
# version 2.5.7
# http://www.phpmyadmin.net
#
# Servidor: wintermute
# Tiempo de generación: 14-11-2004 a las 03:11:59
# Versión del servidor: 4.0.15
# Versión de PHP: 4.3.8
#
# Base de datos : `phprojekt_old_test`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmapplog3`
#

DROP TABLE IF EXISTS `cmapplog3`;
CREATE TABLE `cmapplog3` (
`ID` int(8) NOT NULL auto_increment,
`cmdb_date` varchar(20) default NULL,
`cmdb_operation` int(11) default NULL,
`cmdb_user` varchar(20) default NULL,
`cmdb_directory` varchar(255) default NULL,
`cmdb_description` varchar(255) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# Volcar la base de datos para la tabla `cmapplog3`
#

INSERT INTO `cmapplog3` VALUES (1, '2004-11-14 03:11:22', 11, '', '', 'Cannot load incomplete restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (2, '2004-11-14 03:11:22', 11, '', '', 'Loaded default restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (3, '2004-11-14 03:11:22', 11, '', '', 'Cannot load incomplete restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (4, '2004-11-14 03:11:22', 11, '', '', 'Loaded default restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (5, '2004-11-14 03:11:26', 11, '', '', 'Cannot load incomplete restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (6, '2004-11-14 03:11:26', 11, '', '', 'Loaded default restriction/permission matrix.');
INSERT INTO `cmapplog3` VALUES (7, '2004-11-14 03:11:26', 10, '', '', 'Saved restriction/permission matrix.');

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmcomments3`
#

DROP TABLE IF EXISTS `cmcomments3`;
CREATE TABLE `cmcomments3` (
`ID` int(8) NOT NULL auto_increment,
`cmdb_type` varchar(10) default NULL,
`cmdb_directory` varchar(255) default NULL,
`cmdb_title` varchar(255) default NULL,
`cmdb_author_user` varchar(20) default NULL,
`cmdb_date_creation` varchar(20) default NULL,
`cmdb_comment` text,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmcomments3`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmhits3`
#

DROP TABLE IF EXISTS `cmhits3`;
CREATE TABLE `cmhits3` (
`ID` int(8) NOT NULL auto_increment,
`cmdb_type` varchar(10) default NULL,
`cmdb_directory` varchar(255) default NULL,
`cmdb_totalhits` int(11) default NULL,
`cmdb_updatehits` int(11) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmhits3`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmrating3`
#

DROP TABLE IF EXISTS `cmrating3`;
CREATE TABLE `cmrating3` (
`ID` int(8) NOT NULL auto_increment,
`cmdb_directory` varchar(255) default NULL,
`cmdb_rate` int(11) default NULL,
`cmdb_author_user` varchar(20) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmrating3`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmrestrict3`
#

DROP TABLE IF EXISTS `cmrestrict3`;
CREATE TABLE `cmrestrict3` (
`ID` int(8) NOT NULL auto_increment,
`cmdb_object` int(11) default NULL,
`cmdb_operation` int(11) default NULL,
`cmdb_role` int(11) default NULL,
`cmdb_permission` int(11) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=61 ;

#
# Volcar la base de datos para la tabla `cmrestrict3`
#

INSERT INTO `cmrestrict3` VALUES (1, 1, 1, 1, 1);
INSERT INTO `cmrestrict3` VALUES (2, 1, 1, 2, 0);
INSERT INTO `cmrestrict3` VALUES (3, 1, 1, 3, 0);
INSERT INTO `cmrestrict3` VALUES (4, 1, 1, 4, 0);
INSERT INTO `cmrestrict3` VALUES (5, 1, 1, 5, 0);
INSERT INTO `cmrestrict3` VALUES (6, 2, 1, 1, 1);
INSERT INTO `cmrestrict3` VALUES (7, 2, 1, 2, 0);
INSERT INTO `cmrestrict3` VALUES (8, 2, 1, 3, 0);
INSERT INTO `cmrestrict3` VALUES (9, 2, 1, 4, 0);
INSERT INTO `cmrestrict3` VALUES (10, 2, 1, 5, 1);
INSERT INTO `cmrestrict3` VALUES (11, 1, 2, 1, 0);
INSERT INTO `cmrestrict3` VALUES (12, 1, 2, 2, 0);
INSERT INTO `cmrestrict3` VALUES (13, 1, 2, 3, 0);
INSERT INTO `cmrestrict3` VALUES (14, 1, 2, 4, 0);
INSERT INTO `cmrestrict3` VALUES (15, 1, 2, 5, 0);
INSERT INTO `cmrestrict3` VALUES (16, 2, 2, 1, 1);
INSERT INTO `cmrestrict3` VALUES (17, 2, 2, 2, 0);
INSERT INTO `cmrestrict3` VALUES (18, 2, 2, 3, 1);
INSERT INTO `cmrestrict3` VALUES (19, 2, 2, 4, 0);
INSERT INTO `cmrestrict3` VALUES (20, 2, 2, 5, 1);
INSERT INTO `cmrestrict3` VALUES (21, 1, 3, 1, 0);
INSERT INTO `cmrestrict3` VALUES (22, 1, 3, 2, 0);
INSERT INTO `cmrestrict3` VALUES (23, 1, 3, 3, 0);
INSERT INTO `cmrestrict3` VALUES (24, 1, 3, 4, 0);
INSERT INTO `cmrestrict3` VALUES (25, 1, 3, 5, 0);
INSERT INTO `cmrestrict3` VALUES (26, 2, 3, 1, 1);
INSERT INTO `cmrestrict3` VALUES (27, 2, 3, 2, 0);
INSERT INTO `cmrestrict3` VALUES (28, 2, 3, 3, 1);
INSERT INTO `cmrestrict3` VALUES (29, 2, 3, 4, 0);
INSERT INTO `cmrestrict3` VALUES (30, 2, 3, 5, 1);
INSERT INTO `cmrestrict3` VALUES (31, 1, 4, 1, 1);
INSERT INTO `cmrestrict3` VALUES (32, 1, 4, 2, 1);
INSERT INTO `cmrestrict3` VALUES (33, 1, 4, 3, 1);
INSERT INTO `cmrestrict3` VALUES (34, 1, 4, 4, 1);
INSERT INTO `cmrestrict3` VALUES (35, 1, 4, 5, 1);
INSERT INTO `cmrestrict3` VALUES (36, 2, 4, 1, 1);
INSERT INTO `cmrestrict3` VALUES (37, 2, 4, 2, 0);
INSERT INTO `cmrestrict3` VALUES (38, 2, 4, 3, 1);
INSERT INTO `cmrestrict3` VALUES (39, 2, 4, 4, 1);
INSERT INTO `cmrestrict3` VALUES (40, 2, 4, 5, 1);
INSERT INTO `cmrestrict3` VALUES (41, 1, 5, 1, 0);
INSERT INTO `cmrestrict3` VALUES (42, 1, 5, 2, 0);
INSERT INTO `cmrestrict3` VALUES (43, 1, 5, 3, 0);
INSERT INTO `cmrestrict3` VALUES (44, 1, 5, 4, 0);
INSERT INTO `cmrestrict3` VALUES (45, 1, 5, 5, 0);
INSERT INTO `cmrestrict3` VALUES (46, 2, 5, 1, 0);
INSERT INTO `cmrestrict3` VALUES (47, 2, 5, 2, 0);
INSERT INTO `cmrestrict3` VALUES (48, 2, 5, 3, 1);
INSERT INTO `cmrestrict3` VALUES (49, 2, 5, 4, 1);
INSERT INTO `cmrestrict3` VALUES (50, 2, 5, 5, 1);
INSERT INTO `cmrestrict3` VALUES (51, 1, 1, 6, 0);
INSERT INTO `cmrestrict3` VALUES (52, 2, 1, 6, 0);
INSERT INTO `cmrestrict3` VALUES (53, 1, 2, 6, 0);
INSERT INTO `cmrestrict3` VALUES (54, 2, 2, 6, 0);
INSERT INTO `cmrestrict3` VALUES (55, 1, 3, 6, 0);
INSERT INTO `cmrestrict3` VALUES (56, 2, 3, 6, 0);
INSERT INTO `cmrestrict3` VALUES (57, 1, 4, 6, 1);
INSERT INTO `cmrestrict3` VALUES (58, 2, 4, 6, 0);
INSERT INTO `cmrestrict3` VALUES (59, 1, 5, 6, 0);
INSERT INTO `cmrestrict3` VALUES (60, 2, 5, 6, 0);

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `cmsynd3`
#

DROP TABLE IF EXISTS `cmsynd3`;
CREATE TABLE `cmsynd3` (
`ID` int(8) NOT NULL auto_increment,
`cmdb_type` varchar(10) default NULL,
`cmdb_uri` varchar(255) default NULL,
`cmdb_title` varchar(255) default NULL,
`cmdb_owner_user` varchar(20) default NULL,
`cmdb_date_creation` varchar(20) default NULL,
`cmdb_date_update` varchar(20) default NULL,
`cmdb_ttl` int(11) default NULL,
`cmdb_autodl` int(11) default NULL,
`cmdb_inhome` int(11) default NULL,
`cmdb_visitems` int(11) default NULL,
`cmdb_content` text,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `cmsynd3`
#

# --------------------------------------------------------

#
# Estructura de tabla para la tabla `content3`
#

DROP TABLE IF EXISTS `content3`;
CREATE TABLE `content3` (
`ID` int(8) NOT NULL auto_increment,
`cmdb_type` varchar(10) default NULL,
`cmdb_directory` varchar(255) default NULL,
`cmdb_parentdir` varchar(255) default NULL,
`cmdb_title` varchar(255) default NULL,
`cmdb_author_user` varchar(20) default NULL,
`cmdb_author_group` varchar(20) default NULL,
`cmdb_owner_user` varchar(20) default NULL,
`cmdb_owner_group` varchar(20) default NULL,
`cmdb_viewer_user` varchar(20) default NULL,
`cmdb_viewer_group` varchar(20) default NULL,
`cmdb_date_start` varchar(20) default NULL,
`cmdb_date_finish` varchar(20) default NULL,
`cmdb_date_creation` varchar(20) default NULL,
`cmdb_date_update` varchar(20) default NULL,
`cmdb_keywords` text,
`cmdb_abstract` text,
`cmdb_content` text,
`cmdb_rated` int(11) default NULL,
`cmdb_commented` int(11) default NULL,
`cmdb_short_title` varchar(20) default NULL,
`cmdb_logo` varchar(255) default NULL,
`cmdb_version` int(11) default NULL,
`cmdb_sign` varchar(255) default NULL,
`cmdb_enable_html` int(11) default NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Volcar la base de datos para la tabla `content3`
#

Author:	giovanni [ 08 Nov 2004, 09:36 ]
Post subject:	Creating DB-Tables during installation
Hello, working with PHProjekt 4.2, installed and working well. Installing CMS 0.6 causes errors: 1. creating config: ok 2. creating tables: only error-messages, no new table created in DB Errormessages: error creation CONTENT3 error update CONTENT3 1/7 to 0.5.0 error update CONTENT3 2/7 to 0.5.0 error update CONTENT3 3/7 to 0.5.0 error update CONTENT3 4/7 to 0.5.0 error update CONTENT3 5/7 to 0.5.0 error update CONTENT3 6/7 to 0.5.0 error update CONTENT3 7/7 to 0.5.0 error creation CMHITS3 error creation CMCOMMENTS3 error creation CMRATING3 error creation CMRESTRICT3 error creation CMAPPLOG3 error creation CMSYND3 I have to say, this is not an update, first time installation. What goes wrong ? (sorry, i am not a professional programmer ....) thanks giovanni

Author:	mvaldez [ 10 Nov 2004, 07:03 ]
Post subject:	Database errors...
Giovanni: > Hello, working with PHProjekt 4.2, installed and working well. > Installing CMS 0.6 causes errors: > 1. creating config: ok > 2. creating tables: only error-messages, no new table created in DB > Errormessages: > error creation CONTENT3 > error update CONTENT3 1/7 to 0.5.0... ... > I have to say, this is not an update, > first time installation. What goes wrong ? Hi. What database are you using (mysql, postgres, oracle, mssql)? Please check that you have permissions to CREATE and ALTER the database tables. Check that with your database manager (for example, with phpmyadmin for mysql). Also, you may try to enable full the error reporting: Edit the cm/cm_lib.inc.php file, around line 27, change the line Code: error_reporting(E_ALL & ~E_NOTICE); with Code: error_reporting(E_ALL); This may (or may not) provide more details about the cause of the failure. (You will see additional "error" messages with a "NOTICE" tag, most are harmless). Please let me know what you find, Giovanni. Regards, Mario A. Valdez-Ramirez.

Author:	giovanni [ 10 Nov 2004, 09:00 ]
Post subject:	RE: Creating tables
Hello Mario, thank you for your reply. I am using: PHProjekt 4.2 default configuration, MySQL 3.23.57 on Apache Server, logged in as Superuser PHProjekt root, set to root1 in CM. Step 1: creating config: no problems Step 2: creating tb-tables: a) Notice: Undefined variable: cm_createdb in /../cm/adm_createdb.php on line 40 b) after click on create: error creation CONTENT3 error update CONTENT3 1/7 to 0.5.0 error update CONTENT3 2/7 to 0.5.0 error update CONTENT3 3/7 to 0.5.0 error update CONTENT3 4/7 to 0.5.0 error update CONTENT3 5/7 to 0.5.0 error update CONTENT3 6/7 to 0.5.0 error update CONTENT3 7/7 to 0.5.0 OK creation CMHITS3 OK creation CMCOMMENTS3 OK creation CMRATING3 OK creation CMRESTRICT3 OK creation CMAPPLOG3 OK creation CMSYND3 Step3: creating master-directory in CM: Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 157 Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 159 Notice: Undefined variable: cm_createdir in /.../cm/adm_mkroot.php on line 41 Step 4: working in permission-table: Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 157 Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 159 Notice: Undefined variable: cm_restore_sec in /.../cm/adm_editsec.php on line 52 Notice: Undefined variable: cm_save_sec in /.../cm/adm_editsec.php on line 56 Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 157 Notice: Undefined variable: user_kurz in /.../cm/cm_constraints.inc.php on line 159 After storing changes: Notice: Undefined variable: cm_restore_sec in /.../cm/adm_editsec.php on line 52 Notice: Undefined variable: cm_sec_1_1_2 eval()'d code on line 1 same in: Notice: Undefined variable: cm_sec_1_1_3 Notice: Undefined variable: cm_sec_1_1_4 Notice: Undefined variable: cm_sec_1_1_5 Notice: Undefined variable: cm_sec_1_1_6 Notice: Undefined variable: cm_sec_2_1_2 Notice: Undefined variable: cm_sec_2_1_3 Notice: Undefined variable: cm_sec_2_1_4 Notice: Undefined variable: cm_sec_2_1_6 Notice: Undefined variable: cm_sec_1_2_1 Notice: Undefined variable: cm_sec_1_2_2 Notice: Undefined variable: cm_sec_1_2_3 Notice: Undefined variable: cm_sec_1_2_4 Notice: Undefined variable: cm_sec_1_2_5 Notice: Undefined variable: cm_sec_1_2_6 Notice: Undefined variable: cm_sec_2_2_2 Notice: Undefined variable: cm_sec_2_2_4 Notice: Undefined variable: cm_sec_2_2_6 Notice: Undefined variable: cm_sec_1_3_1 Notice: Undefined variable: cm_sec_1_3_2 Notice: Undefined variable: cm_sec_1_3_3 Notice: Undefined variable: cm_sec_1_3_4 Notice: Undefined variable: cm_sec_1_3_5 Notice: Undefined variable: cm_sec_1_3_6 Notice: Undefined variable: cm_sec_2_3_2 Notice: Undefined variable: cm_sec_2_3_4 Notice: Undefined variable: cm_sec_2_3_6 Notice: Undefined variable: cm_sec_2_4_2 Notice: Undefined variable: cm_sec_2_4_6 Notice: Undefined variable: cm_sec_1_5_1 Notice: Undefined variable: cm_sec_1_5_2 Notice: Undefined variable: cm_sec_1_5_3 Notice: Undefined variable: cm_sec_1_5_4 Notice: Undefined variable: cm_sec_1_5_5 Notice: Undefined variable: cm_sec_1_5_6 Notice: Undefined variable: cm_sec_2_5_1 Notice: Undefined variable: cm_sec_2_5_2 Notice: Undefined variable: cm_sec_2_5_6 Notice: Undefined variable: user_kurz There were 6 tables created in the DB. Greetings giovanni

Author:	mvaldez [ 10 Nov 2004, 09:41 ]
Post subject:	Partial database errors...
> I am using: PHProjekt 4.2 default configuration, > MySQL 3.23.57 on Apache Server, logged in as > Superuser PHProjekt root, set to root1 in CM. > Step 1: creating config: no problems > Step 2: creating tb-tables: ... > error creation CONTENT3 > error update CONTENT3 1/7 to 0.5.0 > error update CONTENT3 2/7 to 0.5.0 > error update CONTENT3 3/7 to 0.5.0 > error update CONTENT3 4/7 to 0.5.0 > error update CONTENT3 5/7 to 0.5.0 > error update CONTENT3 6/7 to 0.5.0 > error update CONTENT3 7/7 to 0.5.0 > OK creation CMHITS3 > OK creation CMCOMMENTS3 > OK creation CMRATING3 > OK creation CMRESTRICT3 > OK creation CMAPPLOG3 > OK creation CMSYND3... > There were 6 tables created in the DB. Hi again. This is different than the first time. This time only the first table failed (the UPDATE queries failed because the CONTENT3 table was not there, was already updated or there is no permissions to alter). Are you sure the CONTENT3 table is not already there? Please check it out. If the table is not there, then this is very weird, because the other tables were created without problems. I can post an SQL dump for MySQL, but the point is that we should try to find out what is the problem with your setup, Giovanni. So, I'm running out of ideas. Delete the CMxxxxx tables and the CONTENT3 table, then try to create them again. If you still have problems, I'll post the MySQL dump so you can create them directly with your database manager. Regards, Mario A. Valdez-Ramirez.

Author:	giovanni [ 10 Nov 2004, 10:50 ]
Post subject:	Create DB
Hello Mario, I delete all tables in db, delete the config-file of CM. Create manual the table CONTENT3, no problems. Delete all again, start setup.php again. Nearly same result. Alle tables created without CONTENT3, errors by update of CONTENT3, error by creating CONTENT3. I make a copy of your installation-script and create with this script tables in DB (only creating tables, not filling them with values). look there - it works ! Strange ..... maybe you sent me an sql-dump, then I try with this to create the tables/fields. thanks giovanni

mariovaldez.net http://www.mariovaldez.net/webapps/forums/

Creating DB-Tables during installation http://www.mariovaldez.net/webapps/forums/viewtopic.php?f=1&t=154	Page 1 of 1

Author:	giovanni [ 12 Nov 2004, 19:05 ]
Post subject:
Hello, you want to post the sql-dump. actual installation is not working. thanks giovanni

Author:	mvaldez [ 14 Nov 2004, 02:18 ]
Post subject:	MySQL dump for an empty CMS setup...
Code: # phpMyAdmin SQL Dump # version 2.5.7 # http://www.phpmyadmin.net # # Servidor: wintermute # Tiempo de generación: 14-11-2004 a las 03:11:59 # Versión del servidor: 4.0.15 # Versión de PHP: 4.3.8 # # Base de datos : `phprojekt_old_test` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `cmapplog3` # DROP TABLE IF EXISTS `cmapplog3`; CREATE TABLE `cmapplog3` ( `ID` int(8) NOT NULL auto_increment, `cmdb_date` varchar(20) default NULL, `cmdb_operation` int(11) default NULL, `cmdb_user` varchar(20) default NULL, `cmdb_directory` varchar(255) default NULL, `cmdb_description` varchar(255) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=8 ; # # Volcar la base de datos para la tabla `cmapplog3` # INSERT INTO `cmapplog3` VALUES (1, '2004-11-14 03:11:22', 11, '', '', 'Cannot load incomplete restriction/permission matrix.'); INSERT INTO `cmapplog3` VALUES (2, '2004-11-14 03:11:22', 11, '', '', 'Loaded default restriction/permission matrix.'); INSERT INTO `cmapplog3` VALUES (3, '2004-11-14 03:11:22', 11, '', '', 'Cannot load incomplete restriction/permission matrix.'); INSERT INTO `cmapplog3` VALUES (4, '2004-11-14 03:11:22', 11, '', '', 'Loaded default restriction/permission matrix.'); INSERT INTO `cmapplog3` VALUES (5, '2004-11-14 03:11:26', 11, '', '', 'Cannot load incomplete restriction/permission matrix.'); INSERT INTO `cmapplog3` VALUES (6, '2004-11-14 03:11:26', 11, '', '', 'Loaded default restriction/permission matrix.'); INSERT INTO `cmapplog3` VALUES (7, '2004-11-14 03:11:26', 10, '', '', 'Saved restriction/permission matrix.'); # -------------------------------------------------------- # # Estructura de tabla para la tabla `cmcomments3` # DROP TABLE IF EXISTS `cmcomments3`; CREATE TABLE `cmcomments3` ( `ID` int(8) NOT NULL auto_increment, `cmdb_type` varchar(10) default NULL, `cmdb_directory` varchar(255) default NULL, `cmdb_title` varchar(255) default NULL, `cmdb_author_user` varchar(20) default NULL, `cmdb_date_creation` varchar(20) default NULL, `cmdb_comment` text, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Volcar la base de datos para la tabla `cmcomments3` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `cmhits3` # DROP TABLE IF EXISTS `cmhits3`; CREATE TABLE `cmhits3` ( `ID` int(8) NOT NULL auto_increment, `cmdb_type` varchar(10) default NULL, `cmdb_directory` varchar(255) default NULL, `cmdb_totalhits` int(11) default NULL, `cmdb_updatehits` int(11) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Volcar la base de datos para la tabla `cmhits3` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `cmrating3` # DROP TABLE IF EXISTS `cmrating3`; CREATE TABLE `cmrating3` ( `ID` int(8) NOT NULL auto_increment, `cmdb_directory` varchar(255) default NULL, `cmdb_rate` int(11) default NULL, `cmdb_author_user` varchar(20) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Volcar la base de datos para la tabla `cmrating3` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `cmrestrict3` # DROP TABLE IF EXISTS `cmrestrict3`; CREATE TABLE `cmrestrict3` ( `ID` int(8) NOT NULL auto_increment, `cmdb_object` int(11) default NULL, `cmdb_operation` int(11) default NULL, `cmdb_role` int(11) default NULL, `cmdb_permission` int(11) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=61 ; # # Volcar la base de datos para la tabla `cmrestrict3` # INSERT INTO `cmrestrict3` VALUES (1, 1, 1, 1, 1); INSERT INTO `cmrestrict3` VALUES (2, 1, 1, 2, 0); INSERT INTO `cmrestrict3` VALUES (3, 1, 1, 3, 0); INSERT INTO `cmrestrict3` VALUES (4, 1, 1, 4, 0); INSERT INTO `cmrestrict3` VALUES (5, 1, 1, 5, 0); INSERT INTO `cmrestrict3` VALUES (6, 2, 1, 1, 1); INSERT INTO `cmrestrict3` VALUES (7, 2, 1, 2, 0); INSERT INTO `cmrestrict3` VALUES (8, 2, 1, 3, 0); INSERT INTO `cmrestrict3` VALUES (9, 2, 1, 4, 0); INSERT INTO `cmrestrict3` VALUES (10, 2, 1, 5, 1); INSERT INTO `cmrestrict3` VALUES (11, 1, 2, 1, 0); INSERT INTO `cmrestrict3` VALUES (12, 1, 2, 2, 0); INSERT INTO `cmrestrict3` VALUES (13, 1, 2, 3, 0); INSERT INTO `cmrestrict3` VALUES (14, 1, 2, 4, 0); INSERT INTO `cmrestrict3` VALUES (15, 1, 2, 5, 0); INSERT INTO `cmrestrict3` VALUES (16, 2, 2, 1, 1); INSERT INTO `cmrestrict3` VALUES (17, 2, 2, 2, 0); INSERT INTO `cmrestrict3` VALUES (18, 2, 2, 3, 1); INSERT INTO `cmrestrict3` VALUES (19, 2, 2, 4, 0); INSERT INTO `cmrestrict3` VALUES (20, 2, 2, 5, 1); INSERT INTO `cmrestrict3` VALUES (21, 1, 3, 1, 0); INSERT INTO `cmrestrict3` VALUES (22, 1, 3, 2, 0); INSERT INTO `cmrestrict3` VALUES (23, 1, 3, 3, 0); INSERT INTO `cmrestrict3` VALUES (24, 1, 3, 4, 0); INSERT INTO `cmrestrict3` VALUES (25, 1, 3, 5, 0); INSERT INTO `cmrestrict3` VALUES (26, 2, 3, 1, 1); INSERT INTO `cmrestrict3` VALUES (27, 2, 3, 2, 0); INSERT INTO `cmrestrict3` VALUES (28, 2, 3, 3, 1); INSERT INTO `cmrestrict3` VALUES (29, 2, 3, 4, 0); INSERT INTO `cmrestrict3` VALUES (30, 2, 3, 5, 1); INSERT INTO `cmrestrict3` VALUES (31, 1, 4, 1, 1); INSERT INTO `cmrestrict3` VALUES (32, 1, 4, 2, 1); INSERT INTO `cmrestrict3` VALUES (33, 1, 4, 3, 1); INSERT INTO `cmrestrict3` VALUES (34, 1, 4, 4, 1); INSERT INTO `cmrestrict3` VALUES (35, 1, 4, 5, 1); INSERT INTO `cmrestrict3` VALUES (36, 2, 4, 1, 1); INSERT INTO `cmrestrict3` VALUES (37, 2, 4, 2, 0); INSERT INTO `cmrestrict3` VALUES (38, 2, 4, 3, 1); INSERT INTO `cmrestrict3` VALUES (39, 2, 4, 4, 1); INSERT INTO `cmrestrict3` VALUES (40, 2, 4, 5, 1); INSERT INTO `cmrestrict3` VALUES (41, 1, 5, 1, 0); INSERT INTO `cmrestrict3` VALUES (42, 1, 5, 2, 0); INSERT INTO `cmrestrict3` VALUES (43, 1, 5, 3, 0); INSERT INTO `cmrestrict3` VALUES (44, 1, 5, 4, 0); INSERT INTO `cmrestrict3` VALUES (45, 1, 5, 5, 0); INSERT INTO `cmrestrict3` VALUES (46, 2, 5, 1, 0); INSERT INTO `cmrestrict3` VALUES (47, 2, 5, 2, 0); INSERT INTO `cmrestrict3` VALUES (48, 2, 5, 3, 1); INSERT INTO `cmrestrict3` VALUES (49, 2, 5, 4, 1); INSERT INTO `cmrestrict3` VALUES (50, 2, 5, 5, 1); INSERT INTO `cmrestrict3` VALUES (51, 1, 1, 6, 0); INSERT INTO `cmrestrict3` VALUES (52, 2, 1, 6, 0); INSERT INTO `cmrestrict3` VALUES (53, 1, 2, 6, 0); INSERT INTO `cmrestrict3` VALUES (54, 2, 2, 6, 0); INSERT INTO `cmrestrict3` VALUES (55, 1, 3, 6, 0); INSERT INTO `cmrestrict3` VALUES (56, 2, 3, 6, 0); INSERT INTO `cmrestrict3` VALUES (57, 1, 4, 6, 1); INSERT INTO `cmrestrict3` VALUES (58, 2, 4, 6, 0); INSERT INTO `cmrestrict3` VALUES (59, 1, 5, 6, 0); INSERT INTO `cmrestrict3` VALUES (60, 2, 5, 6, 0); # -------------------------------------------------------- # # Estructura de tabla para la tabla `cmsynd3` # DROP TABLE IF EXISTS `cmsynd3`; CREATE TABLE `cmsynd3` ( `ID` int(8) NOT NULL auto_increment, `cmdb_type` varchar(10) default NULL, `cmdb_uri` varchar(255) default NULL, `cmdb_title` varchar(255) default NULL, `cmdb_owner_user` varchar(20) default NULL, `cmdb_date_creation` varchar(20) default NULL, `cmdb_date_update` varchar(20) default NULL, `cmdb_ttl` int(11) default NULL, `cmdb_autodl` int(11) default NULL, `cmdb_inhome` int(11) default NULL, `cmdb_visitems` int(11) default NULL, `cmdb_content` text, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Volcar la base de datos para la tabla `cmsynd3` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `content3` # DROP TABLE IF EXISTS `content3`; CREATE TABLE `content3` ( `ID` int(8) NOT NULL auto_increment, `cmdb_type` varchar(10) default NULL, `cmdb_directory` varchar(255) default NULL, `cmdb_parentdir` varchar(255) default NULL, `cmdb_title` varchar(255) default NULL, `cmdb_author_user` varchar(20) default NULL, `cmdb_author_group` varchar(20) default NULL, `cmdb_owner_user` varchar(20) default NULL, `cmdb_owner_group` varchar(20) default NULL, `cmdb_viewer_user` varchar(20) default NULL, `cmdb_viewer_group` varchar(20) default NULL, `cmdb_date_start` varchar(20) default NULL, `cmdb_date_finish` varchar(20) default NULL, `cmdb_date_creation` varchar(20) default NULL, `cmdb_date_update` varchar(20) default NULL, `cmdb_keywords` text, `cmdb_abstract` text, `cmdb_content` text, `cmdb_rated` int(11) default NULL, `cmdb_commented` int(11) default NULL, `cmdb_short_title` varchar(20) default NULL, `cmdb_logo` varchar(255) default NULL, `cmdb_version` int(11) default NULL, `cmdb_sign` varchar(255) default NULL, `cmdb_enable_html` int(11) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Volcar la base de datos para la tabla `content3` #

Page 1 of 1	All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/