How I can create a db_schema.dba file?

Previous topic

Extensions

Next topic

Author	Message
Israel Martín	Friday 14 January 2011 3:49:52 am Hi! I need create some tables and i would like make the db_schema.dba file but i don't know how to specify the table engine, charset and comment. ¿Have anybody an example of a db_schema.dba file with all the posibilities?. Thanks!. My personal site: http://israel-martin.es eZ Publish Developer Basics Certification (4.4): http://ez.no/certification/verify/388211
Gaetano Giunta	Friday 14 January 2011 5:05:36 am The ezsqldumpschema.php script in bin/php can create the dba file for you. Unfortunately it is not yet capable of dumping only a couple of tables instead of the whole db (but there is a feature request for that) Principal Consultant International Business Member of the Community Project Board
Israel Martín	Friday 14 January 2011 12:26:32 pm I have been testing the ezsqldumpschema.php script and it works fine but the table engine, charset and comment, are not specified in the generated file... Maybe it isn't possible :( . Thank you for help! My personal site: http://israel-martin.es eZ Publish Developer Basics Certification (4.4): http://ez.no/certification/verify/388211

Author

Message

Israel Martín

Friday 14 January 2011 3:49:52 am

Hi!

I need create some tables and i would like make the db_schema.dba file but i don't know how to specify the table engine, charset and comment.

¿Have anybody an example of a db_schema.dba file with all the posibilities?.

Thanks!.

My personal site: http://israel-martin.es
eZ Publish Developer Basics Certification (4.4): http://ez.no/certification/verify/388211

Gaetano Giunta

Friday 14 January 2011 5:05:36 am

The ezsqldumpschema.php script in bin/php can create the dba file for you. Unfortunately it is not yet capable of dumping only a couple of tables instead of the whole db (but there is a feature request for that)

Principal Consultant International Business
Member of the Community Project Board

Israel Martín

Friday 14 January 2011 12:26:32 pm

I have been testing the ezsqldumpschema.php script and it works fine but the table engine, charset and comment, are not specified in the generated file... Maybe it isn't possible :( .

Thank you for help!

My personal site: http://israel-martin.es
eZ Publish Developer Basics Certification (4.4): http://ez.no/certification/verify/388211

eZ debug

Timing:	Jan 30 2025 00:50:18
Script start
Timing:	Jan 30 2025 00:50:18
Module start 'layout'
Timing:	Jan 30 2025 00:50:18
Module start 'content'
Timing:	Jan 30 2025 00:50:18
Module end 'content'
Timing:	Jan 30 2025 00:50:18
Script end

Main resources:

Total runtime	0.0126 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0041	588.2500	151.2266
Module start 'layout'	0.0041	0.0022	739.4766	36.6719
Module start 'content'	0.0064	0.0049	776.1484	90.0625
Module end 'content'	0.0112	0.0013	866.2109	33.9766
Script end	0.0125		900.1875

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0022	17.1526	14	0.0002
Check MTime	0.0010	8.1271	14	0.0001
Mysql Total
Database connection	0.0005	3.7207	1	0.0005
Mysqli_queries	0.0023	18.4574	3	0.0008
Looping result	0.0000	0.0798	1	0.0000
Template Total	0.0010	7.8	1	0.0010
Template load	0.0008	6.0075	1	0.0008
Template processing	0.0002	1.7929	1	0.0002
Override
Cache load	0.0005	4.1595	1	0.0005
General
dbfile	0.0011	9.0749	8	0.0001
String conversion	0.0000	0.0494	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs