Posted: 18 June 2013 in Uncategorized

$IW_HOME/local/config/lib/content_center/livesite_customer_src/db contains scripts (livesite_schema_ddl.sql, insert_taxonomy_node_types.sql, insert_address_types.sql) to create the tables of the SitePublisher/LiveSite tables

  • data model tables
  • iw_asset,
  • iwcont_author,
  • iwcont_blog_cmnt,
  • iwcont_blog_entry,
  • iwcont_category,
  • iwcont_contact,
  • iwcont_content,
  • iwcont_event,
  • iwcont_image,
  • iwcont_link,
  • iwcont_news,
  • iwcont_rating,
  • iwcont_site,
  • iwcont_vote,

optimost tables

  • iwopt_cnt_vpath,
  • iwopt_counter,
  • iwopt_creative,
  • iwopt_exp_cnt,
  • iwopt_exp_errors,
  • iwopt_experiment,
  • iwopt_module,
  • iwopt_portfolio,
  • iwopt_segment,
  • iwopt_subject,
  • iwopt_wave,

visitor profile tables

  • iwpers_address_type,
  • iwpers_user,
  • iwpers_user_site,

taxonomy tables

  • iwtax_node,
  • iwtax_node_type

The scripts also help populate the default taxonomies (‘Content Types’ and ‘Content Categories’) and also populate the default address types (‘Residential’, ‘Commercial’, ‘Education’, ‘Government’)

Vendor specific

the vendor sub-folder contains vendor (Oracle, Microsoft Sql Server) specific sql scripts (disable_taxonomy_parent_constraint_ddl.sqlserver.sql and disable_taxonomy_parent_constraint_ddl.oracle.sql). If you use mysql and you find something doesn’t quite work right, create a script here.

Vendor specific migration scripts

the migration subfolder contains LiveSite migration scripts for each vendor dialect and specificity (30_301_migration.sqlserver.sql and 30_301_migration.oracle.sql)

All these scripts are executed as part of the sql.execute build target of the livesite customer toolkit.

  1. I think I need a new template. I don’t like the bullet points on this one.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s