From ac68dd9a44704da15e74ac98ad08022bf8899a44 Mon Sep 17 00:00:00 2001
From: konrad <konrad@6e3c4bff-ac9f-4ac1-96c5-d2ea494d3e33>
Date: Sun, 16 May 2010 16:56:54 +0000
Subject: [PATCH] prep: tags in event related tables

git-svn-id: https://silmor.de/svn/softmagic/smoke/trunk@462 6e3c4bff-ac9f-4ac1-96c5-d2ea494d3e33
---
 wob/event.wolf |   15 ++++++++++++++-
 1 files changed, 14 insertions(+), 1 deletions(-)

diff --git a/wob/event.wolf b/wob/event.wolf
index ff8203d..af83cff 100644
--- a/wob/event.wolf
+++ b/wob/event.wolf
@@ -30,6 +30,7 @@
 		<Column name="abbreviation" type="string:10" notnull="yes"/>
 		<Column name="formula" type="string"/>
 		<Column name="flags" type="string">filter flags: defines who can use the category to define a new event (ignored once it is attached to an event)</Column>
+		<Column name="tags" type="string">internal tags: can be used by ticket printing templates or macros to execute certain actions</Column>
 		
 		<Preset>
 			<V col="pricecategoryid" val="1"/>
@@ -37,6 +38,7 @@
 			<V col="abbreviation" val="norm"/>
 			<V col="formula" val=""/>
 			<V col="flags" val=""/>
+			<V col="tags" val=""/>
 		</Preset>
 	</Table>
 	
@@ -46,6 +48,7 @@
 		<Column name="description" type="text"/>
 		<Column name="comment" type="text"/>
 		<Column name="flags" type="string">filter flags: defines who can create events with this artist (ignored once it is attached to an event)</Column>
+		<Column name="tags" type="string">internal tags: can be used by macros and printer routines to change behavior or output</Column>
 	</Table>
 	
 	<Table name="event" backup="yes">
@@ -65,7 +68,8 @@
 		<!-- flags -->
 		<Column name="iscancelled" type="bool" default="0"/>
 		<Column name="flags" type="string">filter: who can sell tickets for this event</Column>
-		<Column name="tax" type="int32"/>
+		<Column name="tax" type="int32">taxes on this event in hundredth of a percent, this value is actually never used internall, but may be used by printing routines for calculations</Column>
+		<Column name="tags" type="string">internal tags: can be used by macros and printer routines to change behavior or output</Column>
 		<!-- reason the event has been cancelled-->
 		<Column name="cancelreason" type="string"/>
 	</Table>
@@ -76,6 +80,7 @@
 		<Column name="maxavailable" type="int32" notnull="yes"/>
 		<Column name="price" type="int32" notnull="yes"/>
 		<Column name="flags" type="string">filter: who can sell tickets in this category for this event</Column>
+		<Column name="tags" type="string">internal tags: can be used by macros and printer routines to change behavior or output</Column>
 	</Table>
 	
 	<Class name="Artist">
@@ -86,6 +91,7 @@
 		<Property name="comment" type="string"/>
 		<Property name="flags" type="astring"/>
 		<Property name="canuse" type="bool"/>
+		<Property name="tags" type="astring"/>
 		
 		<Mapping table="artist">
 			<Map column="artistid" property="id"/>
@@ -93,6 +99,7 @@
 			<Map column="description"/>
 			<Map column="comment"/>
 			<Map column="flags"/>
+			<Map column="tags"/>
 			<Map property="canuse">
 				<Call lang="php" method="$GLOBALS['session']->checkFlags($data->getflags())"/>
 			</Map>
@@ -124,6 +131,7 @@
 		<Property name="abbreviation" type="astring"/>
 		<Property name="formula" type="string"/>
 		<Property name="flags" type="string"/>
+		<Property name="tags" type="string"/>
 		<Property name="canuse" type="bool"/>
 		<Mapping table="pricecategory">
 			<Map column="pricecategoryid"/>
@@ -131,6 +139,7 @@
 			<Map column="abbreviation"/>
 			<Map column="formula"/>
 			<Map column="flags"/>
+			<Map column="tags"/>
 			<Map property="canuse">
 				<Call lang="php" method="$GLOBALS['session']->checkFlags($data->getflags())"/>
 			</Map>
@@ -171,6 +180,7 @@
 		<Property name="maxavailable" type="int32"/>
 		<Property name="price" type="int32"/>
 		<Property name="flags" type="string"/>
+		<Property name="tags" type="string"/>
 		<Property name="canuse" type="bool"/>
 		
 		<Property name="amounttickets" type="int">calculated property: contains the amount of tickets currently contained in this price, ignored if sent from client</Property>
@@ -182,6 +192,7 @@
 			<Map column="maxavailable"/>
 			<Map column="price"/>
 			<Map column="flags"/>
+			<Map column="tags"/>
 			<Map property="pricecategory">
 				<Call lang="php" method="WOPriceCategory::fromTablepricecategory(WTpricecategory::getFromDB($table->pricecategoryid))"/>
 			</Map>
@@ -218,6 +229,7 @@
 		<Property name="comment" type="string"/>
 		<Property name="tax" type="int"/>
 		<Property name="flags" type="string"/>
+		<Property name="tags" type="string"/>
 		<Property name="canuse" type="bool"/>
 		
 		<Mapping table="event">
@@ -236,6 +248,7 @@
 			<Map column="capacity"/>
 			<Map column="iscancelled"/>
 			<Map column="flags"/>
+			<Map column="tags"/>
 			<Map column="tax"/>
 			<Map column="cancelreason"/>
 			<Map property="price">
-- 
1.7.2.5