VbzCart SQL

From HTYP, the free directory anyone can edit

[edit] Navigation

computing: software: web: shopping carts: VbzCart: SQL

[edit] Overview

This page is simply the SQL defined on the other VbzCart-related pages, transcluded into one single page so it can be used to actually create the database.

[edit] SQL

/* TABLES */

/* TABLES: customer data */

/* VIEWS */

<mysql> CREATE OR REPLACE VIEW v_data_flow AS

   SELECT
     df.ID_Srce,
     df.ID_Dest,
     df.ID_Proc,
     dfx.doesClear
   FROM data_flow AS df LEFT JOIN data_procs AS dfx ON df.ID_Proc=dfx.ID
   ORDER BY dfx.doesClear;</mysql>