cloudstore-developers
Changes
.gitignore 1(+1 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/aws/aws_create_ami.py 86(+0 -86)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/aws/aws_create_autoscalability.py 170(+0 -170)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/aws/aws_create_instance.py 98(+0 -98)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/aws/aws_create_keypair.py 36(+0 -36)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/aws/aws_create_loadbalancer.py 51(+0 -51)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/aws/aws_remove_all.py 144(+0 -144)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/openstack/__init__.py 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/openstack/openstack_create_balancer_instance.py 137(+0 -137)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/openstack/openstack_create_mongodb_instances.py 265(+0 -265)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/openstack/openstack_create_mysql_instances.py 318(+0 -318)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/openstack/openstack_create_showcase_instances.py 333(+0 -333)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/openstack/openstack_remove_all.py 117(+0 -117)
deployment-scripts/cloudscale/deployment_scripts/scripts/infrastructure/openstack/openstack-create-instance.py 27(+0 -27)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/aws/configure-dynamodb.py 1(+0 -1)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/AService.java 419(+0 -419)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/BuyConfirmResult.java 42(+0 -42)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/common/ContextHelper.java 22(+0 -22)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/common/DatabaseHelper.java 37(+0 -37)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/common/Soundex.java 92(+0 -92)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/AddressDaoImpl.java 46(+0 -46)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/AuthorDaoImpl.java 64(+0 -64)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/CcXactsDaoImpl.java 67(+0 -67)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/CountryDaoImpl.java 72(+0 -72)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/CustomerDaoImpl.java 75(+0 -75)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/DaoImpl.java 57(+0 -57)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/ItemDaoImpl.java 251(+0 -251)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/OrderLineDaoImpl.java 50(+0 -50)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/OrdersDaoImpl.java 173(+0 -173)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/ShoppingCartDaoImpl.java 83(+0 -83)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/hibernate/impl/ShoppingCartLineDaoImpl.java 95(+0 -95)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IAddressDao.java 14(+0 -14)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IAuthorDao.java 15(+0 -15)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/ICcXactsDao.java 11(+0 -11)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/ICountryDao.java 14(+0 -14)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/ICustomerDao.java 20(+0 -20)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IDao.java 12(+0 -12)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IItemDao.java 21(+0 -21)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IOrderLineDao.java 13(+0 -13)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IOrdersDao.java 11(+0 -11)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IShoppingCartDao.java 16(+0 -16)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/IShoppingCartLineDao.java 18(+0 -18)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/AddressDaoImpl.java 74(+0 -74)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/AuthorDaoImpl.java 82(+0 -82)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/CcXactsDaoImpl.java 78(+0 -78)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/CountryDaoImpl.java 68(+0 -68)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/CustomerDaoImpl.java 80(+0 -80)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/DaoImpl.java 48(+0 -48)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/IDaoExt.java 10(+0 -10)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/ItemDaoImpl.java 232(+0 -232)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/OrderLineDaoImpl.java 63(+0 -63)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/OrdersDaoImpl.java 71(+0 -71)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/ShoppingCartDaoImpl.java 81(+0 -81)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/dao/mongo/impl/ShoppingCartLineDaoImpl.java 87(+0 -87)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/IDao.java 25(+0 -25)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/IDaos.java 37(+0 -37)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/IService.java 37(+0 -37)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/Address.java 183(+0 -183)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/Author.java 156(+0 -156)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/CcXacts.java 187(+0 -187)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/Country.java 132(+0 -132)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/OrderLine.java 116(+0 -116)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/Orders.java 218(+0 -218)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/ShoppingCart.java 87(+0 -87)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/hibernate/ShoppingCartLine.java 95(+0 -95)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/IAddress.java 40(+0 -40)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/IAuthor.java 34(+0 -34)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/ICcXacts.java 50(+0 -50)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/ICountry.java 23(+0 -23)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/ICustomer.java 76(+0 -76)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/IItem.java 100(+0 -100)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/IOrderLine.java 31(+0 -31)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/IOrders.java 56(+0 -56)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/IShoppingCart.java 20(+0 -20)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/IShoppingCartLine.java 24(+0 -24)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/Address.java 157(+0 -157)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/Author.java 135(+0 -135)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/CcXacts.java 183(+0 -183)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/Country.java 93(+0 -93)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/Customer.java 283(+0 -283)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/Item.java 401(+0 -401)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/OrderLine.java 131(+0 -131)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/Orders.java 213(+0 -213)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/ShoppingCart.java 94(+0 -94)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/model/mongo/ShoppingCartLine.java 103(+0 -103)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/services/HibernateService.java 147(+0 -147)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/db/services/MongoService.java 209(+0 -209)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/generate/AGenerate.java 607(+0 -607)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/generate/Generate.java 71(+0 -71)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/generate/GenerateHibernate.java 169(+0 -169)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/generate/GenerateMongo.java 175(+0 -175)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/generate/IGenerate.java 17(+0 -17)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/AController.java 123(+0 -123)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/BestSellersController.java 41(+0 -41)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/BuyConfirmController.java 143(+0 -143)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/BuyController.java 227(+0 -227)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/CustomerRegistrationController.java 53(+0 -53)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/HomeController.java 102(+0 -102)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/LoginController.java 65(+0 -65)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/NewProductsController.java 76(+0 -76)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/OrderDisplayController.java 92(+0 -92)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/OrderInquiryController.java 56(+0 -56)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/ProductDetailServlet.java 67(+0 -67)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/SearchController.java 83(+0 -83)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/java/eu/cloudscale/showcase/servlets/ShoppingCartController.java 114(+0 -114)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/app.properties 3(+0 -3)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/app-context.xml 10(+0 -10)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/cache.xml 20(+0 -20)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/database/database.aws.hibernate.properties 6(+0 -6)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/database/database.aws.mongodb.properties 6(+0 -6)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/ehcache.xml 54(+0 -54)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/generate/database.aws.hibernate.properties 6(+0 -6)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/generate/database.properties 6(+0 -6)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/hibernate.xml 98(+0 -98)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/log4j.properties 7(+0 -7)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/mongodb.xml 38(+0 -38)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/resources/schema.sql 264(+0 -264)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/css/bootstrap.css 6158(+0 -6158)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/css/bootstrap.min.css 9(+0 -9)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/css/bootstrap-responsive.css 1109(+0 -1109)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/css/bootstrap-responsive.min.css 9(+0 -9)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/add_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/best_sellers.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/checkout_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/display_last_order_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/glyphicons-halflings.png 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/glyphicons-halflings-white.png 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/home_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/logo-CloudScale.png 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/logo-CloudScale-aws.png 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/order_status_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/refresh_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/search_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/shopping_cart_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/submit_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/tpclogo.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/update_B.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/img/whats_new.gif 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/js/bootstrap.js 2276(+0 -2276)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/resources/js/bootstrap.min.js 6(+0 -6)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/spring/appServlet/servlet-context.xml 59(+0 -59)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/spring/root-context.xml 8(+0 -8)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/best-sellers.html 56(+0 -56)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/buy.html 188(+0 -188)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/buy-confirm.html 71(+0 -71)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/customer-registration.html 87(+0 -87)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/home.html 67(+0 -67)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/login.html 92(+0 -92)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/new-products.html 55(+0 -55)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/order-display.html 112(+0 -112)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/order-inquiry.html 34(+0 -34)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/product_detail.html 61(+0 -61)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/search.html 74(+0 -74)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/shopping-cart.html 79(+0 -79)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/views/templates/layout.html 80(+0 -80)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/main/webapp/WEB-INF/web.xml 38(+0 -38)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/generator/src/test/resources/log4j.xml 41(+0 -41)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/openstack/configure-mongodb.py 0(+0 -0)
deployment-scripts/cloudscale/deployment_scripts/scripts/platform/openstack/configure-mysql.py 23(+0 -23)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/check-running-showcase_instances.py 78(+0 -78)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/cloudscale-apache-virtualhost.conf 14(+0 -14)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/cloudscale-apache-virtualhost.conf.new 16(+0 -16)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/install-apache-tomcat.sh 36(+0 -36)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/install-load-balancer.sh 42(+0 -42)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/install-mysql-galera.sh 17(+0 -17)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/install-mysql-galera-import-dump.sh 53(+0 -53)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/install-tomcat-apache.py 81(+0 -81)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/master_slave/my.cnf.master 127(+0 -127)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/master_slave/my.cnf.slave 128(+0 -128)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/master_slave/setup_master.sh 8(+0 -8)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/start-mysql-galera-first-node.sh 25(+0 -25)
deployment-scripts/cloudscale/deployment_scripts/scripts/software/start-mysql-galera-other-nodes.sh 50(+0 -50)
distributed-jmeter/cloudscale/distributed_jmeter/scripts/visualization/r_visualization.R 539(+0 -539)
pom.xml 10(+10 -0)
src/main/java/tresholds.java 0(+0 -0)
src/main/resources/app.properties 6(+6 -0)
src/main/resources/app-context.xml 0(+0 -0)
src/main/resources/cache.xml 0(+0 -0)
src/main/resources/ehcache.xml 0(+0 -0)
src/main/resources/hibernate.xml 8(+4 -4)
src/main/resources/log4j.properties 0(+0 -0)
src/main/resources/mongodb.xml 0(+0 -0)
src/main/resources/schema.sql 264(+264 -0)
src/main/webapp/WEB-INF/views/templates/layout.html 158(+79 -79)
src/main/webapp/WEB-INF/web.xml 0(+0 -0)
src/test/resources/log4j.xml 0(+0 -0)
Details
.gitignore 1(+1 -0)
diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..a66dbf6
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1 @@
+application/src/main/resources/schema.sql
diff --git a/src/main/java/eu/cloudscale/showcase/test/Prob.java b/src/main/java/eu/cloudscale/showcase/test/Prob.java
new file mode 100644
index 0000000..b182917
--- /dev/null
+++ b/src/main/java/eu/cloudscale/showcase/test/Prob.java
@@ -0,0 +1,42 @@
+package eu.cloudscale.showcase.test;
+
+import java.util.HashMap;
+import java.util.Random;
+
+public class Prob {
+ public static void main(String[] args) {
+
+ String string = "";
+ Random r = new Random();
+ HashMap<String, Integer> foo = new HashMap<String, Integer>();
+ for (int i = 0; i < 100; i++) {
+ int rand = r.nextInt(100);
+ if (rand < 44) {
+ string = "a";
+ } else if (rand >= 44 & rand < 66) {
+ string = "b";
+ } else if (rand >= 66 && rand < 96) {
+ string = "c";
+ } else if (rand >= 96) {
+ string = "d";
+ }
+
+ int val = 0;
+ if(foo.containsKey(string))
+ {
+ val = foo.get(string);
+ }
+ foo.put(string, val+1);
+ }
+
+ int probSum = 0;
+
+ for(String s : foo.keySet())
+ {
+ probSum+=foo.get(s);
+ System.out.println(s + " -> " + foo.get(s));
+ }
+
+ System.out.println("sum = " + probSum);
+ }
+}
\ No newline at end of file
diff --git a/src/main/java/eu/cloudscale/showcase/test/ProbabilityTest2.java b/src/main/java/eu/cloudscale/showcase/test/ProbabilityTest2.java
new file mode 100644
index 0000000..5f2d80a
--- /dev/null
+++ b/src/main/java/eu/cloudscale/showcase/test/ProbabilityTest2.java
@@ -0,0 +1,111 @@
+package eu.cloudscale.showcase.test;
+
+import java.util.Random;
+import java.util.HashMap;
+
+public class ProbabilityTest2
+{
+ static HashMap<String, Integer> foo = new HashMap<String, Integer>();
+
+ static String[] operations = {
+ "None",
+ "/admin-confirm",
+ "/admin-request",
+ "/best-sellers",
+ "/buy-confirm",
+ "/buy",
+ "/customer-registration",
+ "/home",
+ "/new-products",
+ "/order-display",
+ "/order-inquiry",
+ "/product-detail",
+ "/search-request",
+ "/search-result",
+ "/shopping-cart"
+ };
+
+ public static void main(String[] args) throws Exception
+ {
+ ProbabilityTest2 pt2 = new ProbabilityTest2();
+ int steps = 1000000;
+ for(int i=0; i<steps; i++)
+ {
+ int op = pt2.getOperation();
+ int val = 1;
+
+ if(foo.containsKey(operations[op]))
+ {
+ val = foo.get(operations[op])+1;
+ }
+ foo.put(operations[op], val);
+ }
+
+ double sum = 0;
+ for(String op : foo.keySet())
+ {
+ double prob = ((foo.get(op)*100)/(steps*1.0));
+ sum += prob;
+ System.out.println(op + " = " + prob);
+ }
+ System.out.println("--------------------------");
+ System.out.println("PROB SUM = " + sum);
+ }
+
+ private int getOperation() throws Exception
+ {
+ int[] browsingMix = {
+ 0, // None
+ 9, // admin confirm
+ 10, // admin request
+ 1100, // best-sellers
+ 69, // buy-confirm
+ 75, //buy
+ 82, //customer-registration
+ 2900, //home
+ 1100, // new-products
+ 25, // order-display
+ 30, // order-inquiry
+ 2100, // product-detail
+ 1200, // search-request
+ 1100, // search-result
+ 200 // shopping-cart
+ };
+
+
+ int probSum = 0;
+
+ for( int i=0; i < browsingMix.length; i++)
+ {
+ probSum += browsingMix[i];
+ }
+
+ int[] range = new int[2 * browsingMix.length];
+
+ for( int i=0; i < browsingMix.length; i++)
+ {
+ int sum = 0;
+ for( int j=0; j<i; j++)
+ {
+ sum += browsingMix[j];
+ }
+
+ range[i] = sum;
+ range[i+1] = range[i] + browsingMix[i];
+ //System.out.println(range[i] + " - " + range[i+1]);
+ }
+ Random rand = new Random();
+
+ int randNum = rand.nextInt(probSum);
+// System.out.println("randNum = " + randNum);
+ for(int i=0; i < browsingMix.length; i++)
+ {
+ if( randNum >= range[i] && randNum < range[i+1] )
+ {
+ //System.out.println("operation = " + operations[i]);
+ return i;
+ }
+ }
+ throw new Exception("DREK NA PALCI");
+ }
+}
diff --git a/src/main/java/eu/cloudscale/showcase/test/Tresholds.java b/src/main/java/eu/cloudscale/showcase/test/Tresholds.java
new file mode 100644
index 0000000..154910c
--- /dev/null
+++ b/src/main/java/eu/cloudscale/showcase/test/Tresholds.java
@@ -0,0 +1,93 @@
+package eu.cloudscale.showcase.test;
+
+import java.util.HashMap;
+import java.util.Random;
+
+public class Tresholds
+{
+
+ enum Operation{
+ ADMIN_CONFIRM,
+ ADMIN_REQUEST,
+ BEST_SELLERS,
+ BUY_CONFIRM,
+ BUY_REQUEST,
+ CUSTOMER_REGISTRATION,
+ HOME,
+ NEW_PRODUCTS,
+ ORDER_DISPLAY,
+ ORDER_INQUIRY,
+ PRODUCT_DETAIL,
+ SEARCH_REQUEST,
+ SEARCH_RESULTS,
+ SHOPPING_CART
+ }
+
+ /*
+ * See http://www.tpc.org/tpcw/spec/tpcw_v16.pdf page 94
+ */
+ public static final int[][] tresholdsMatrix = {
+ {0, 0, 0, 0, 0, 0, 9952, 0, 0, 0, 0, 9999, 0, 0},
+ {8999, 0, 0, 0, 0, 0, 9999, 0, 0, 0, 0, 0, 0, 0},
+ {0,0,0,0,0, 0, 167, 0,0,0, 472, 9927,0,9999},
+ {0,0,0,0,0, 0, 84, 0,0,0,0,9999,0,0},
+ {0,0,0,4614,0, 0, 6546, 0,0,0,0,0,0,9999},
+ {0,0,0,0,8666, 0, 8760, 0,0,0,0,9999,0,0},
+ {0,0,3124,0,0, 0, 0, 6249,0, 6718,0,7026,0,9999},
+ {0,0,0,0,0, 0, 156, 0,0,0,9735,9784,0,9999},
+ {0,0,0,0,0, 0, 69, 0,0,0,0,9999,0,0},
+ {0,0,0,0,0, 0, 72, 0,8872,0,0,9999,0,0},
+ {0,58,0,0,0, 0, 832, 0,0,0,1288,8603,0,9999},
+ {0,0,0,0,0, 0, 635, 0,0,0,0,0,9135,9999},
+ {0,0,0,0,0, 0, 2657, 0,0,0,9294,9304,0,9999},
+ {0,0,0,0,0, 2585, 9552, 0,0,0,0,0,0,9999},
+ };
+ public static void main(String[] args)
+ {
+ Tresholds tresholds = new Tresholds();
+ int incomeOperation = Operation.HOME.ordinal();
+
+ HashMap<Integer, Integer> foo = new HashMap<Integer, Integer>();
+ int steps = 100;
+
+ for( int i = 0; i < steps; i++)
+ {
+ int outcomeOperation = tresholds.nextOperation(incomeOperation);
+
+ int val = 0;
+ if(foo.containsKey(outcomeOperation))
+ {
+ val = foo.get(outcomeOperation)+1;
+ }
+
+ foo.put(outcomeOperation, val);
+ incomeOperation = outcomeOperation;
+ }
+
+ double percentageSum = 0;
+ for( int i : foo.keySet())
+ {
+ double percentage = (foo.get(i)*100) / (steps*1.0);
+ System.out.println(Operation.values()[i] + " = " + percentage);
+ percentageSum += percentage;
+ }
+ System.out.println(percentageSum);
+ }
+
+ private int nextOperation(int currentOperation)
+ {
+ int newOperation = -1;
+
+ Random rand = new Random();
+ int r = 1 + rand.nextInt(9999);
+
+ for( int i = 0; i < tresholdsMatrix[currentOperation].length; i++)
+ {
+ int t = tresholdsMatrix[currentOperation][i];
+ if( r <= t)
+ return i;
+ }
+
+ return newOperation;
+ }
+}
\ No newline at end of file
src/main/resources/app.properties 6(+6 -0)
diff --git a/src/main/resources/app.properties b/src/main/resources/app.properties
new file mode 100644
index 0000000..ba8b298
--- /dev/null
+++ b/src/main/resources/app.properties
@@ -0,0 +1,6 @@
+eu.cloudscale.files.url.css=https\://dfkjxk3xu6nvq.cloudfront.net/css
+eu.cloudscale.files.url.img=https\://dfkjxk3xu6nvq.cloudfront.net/img
+eu.cloudscale.files.url.js=https\://dfkjxk3xu6nvq.cloudfront.net/js
+#eu.cloudscale.files.url.css=https://s3-eu-west-1.amazonaws.com/cloudscale-files/css
+#eu.cloudscale.files.url.img=https://s3-eu-west-1.amazonaws.com/cloudscale-files/img
+#eu.cloudscale.files.url.js=https://s3-eu-west-1.amazonaws.com/cloudscale-files/js
src/main/resources/schema.sql 264(+264 -0)
diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
new file mode 100644
index 0000000..ca29ee9
--- /dev/null
+++ b/src/main/resources/schema.sql
@@ -0,0 +1,264 @@
+SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
+SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
+SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
+
+DROP SCHEMA IF EXISTS `tpcw` ;
+CREATE SCHEMA IF NOT EXISTS `tpcw` DEFAULT CHARACTER SET utf8 COLLATE utf8_slovenian_ci ;
+USE `tpcw` ;
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`author`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`author` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`author` (
+ `A_ID` INT NOT NULL AUTO_INCREMENT ,
+ `A_FNAME` VARCHAR(20) NULL ,
+ `A_LNAME` VARCHAR(20) NULL ,
+ `A_MNAME` VARCHAR(20) NULL ,
+ `A_DOB` DATETIME NULL ,
+ `A_BIO` TEXT NULL ,
+ PRIMARY KEY (`A_ID`) )
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`item`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`item` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`item` (
+ `I_ID` INT NOT NULL AUTO_INCREMENT ,
+ `I_TITLE` VARCHAR(60) NULL ,
+ `I_A_ID` INT NOT NULL ,
+ `I_PUB_DATE` DATETIME NULL ,
+ `I_PUBLISHER` VARCHAR(60) NULL ,
+ `I_SUBJECT` VARCHAR(60) NULL ,
+ `I_DESC` TEXT NULL ,
+ `I_RELATED1` INT NULL ,
+ `I_RELATED2` INT NULL ,
+ `I_RELATED3` INT NULL ,
+ `I_RELATED4` INT NULL ,
+ `I_RELATED5` INT NULL ,
+ `I_THUMBNAIL` VARCHAR(60) NULL ,
+ `I_IMAGE` VARCHAR(60) NULL ,
+ `I_SRP` INT NULL ,
+ `I_COST` INT NULL ,
+ `I_AVAIL` DATETIME NULL ,
+ `I_STOCK` INT NULL ,
+ `I_ISBN` VARCHAR(13) NULL ,
+ `I_PAGE` VARCHAR(4) NULL ,
+ `I_BACKING` VARCHAR(15) NULL ,
+ `I_DIMENSION` VARCHAR(25) NULL ,
+ INDEX `fk_ITEM_AUTHOR` (`I_A_ID` ASC) ,
+ PRIMARY KEY (`I_ID`) ,
+ CONSTRAINT `fk_ITEM_AUTHOR`
+ FOREIGN KEY (`I_A_ID` )
+ REFERENCES `tpcw`.`author` (`A_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`country`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`country` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`country` (
+ `CO_ID` INT NOT NULL AUTO_INCREMENT ,
+ `CO_NAME` VARCHAR(50) NULL ,
+ `CO_EXCHANGE` DOUBLE NULL ,
+ `CO_CURRENCY` VARCHAR(18) NULL ,
+ PRIMARY KEY (`CO_ID`) )
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`address`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`address` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`address` (
+ `ADDR_ID` INT NOT NULL AUTO_INCREMENT ,
+ `ADDR_STREET1` VARCHAR(40) NULL ,
+ `ADDR_STREET2` VARCHAR(40) NULL ,
+ `ADDR_CITY` VARCHAR(30) NULL ,
+ `ADDR_STATE` VARCHAR(20) NULL ,
+ `ADDR_ZIP` VARCHAR(10) NULL ,
+ `ADDR_CO_ID` INT NOT NULL ,
+ PRIMARY KEY (`ADDR_ID`) ,
+ INDEX `fk_ADDRESS_COUNTRY1` (`ADDR_CO_ID` ASC) ,
+ CONSTRAINT `fk_ADDRESS_COUNTRY1`
+ FOREIGN KEY (`ADDR_CO_ID` )
+ REFERENCES `tpcw`.`country` (`CO_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`customer`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`customer` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`customer` (
+ `C_ID` INT NOT NULL AUTO_INCREMENT ,
+ `C_UNAME` VARCHAR(20) NULL ,
+ `C_PASSWD` VARCHAR(20) NULL ,
+ `C_FNAME` VARCHAR(15) NULL ,
+ `C_LNAME` VARCHAR(15) NULL ,
+ `C_ADDR_ID` INT NOT NULL ,
+ `C_PHONE` VARCHAR(16) NULL ,
+ `C_EMAIL` VARCHAR(50) NULL ,
+ `C_SINCE` DATE NULL ,
+ `C_LAST_VISIT` DATE NULL ,
+ `C_LOGIN` DATETIME NULL ,
+ `C_EXPIRATION` DATETIME NULL COMMENT ' ' ,
+ `C_DISCOUNT` INT NULL ,
+ `C_BALANCE` INT NULL ,
+ `C_YTD_PMT` INT NULL ,
+ `C_BIRTHDATE` DATE NULL ,
+ `C_DATA` TEXT NULL ,
+ PRIMARY KEY (`C_ID`) ,
+ INDEX `fk_CUSTOMER_ADDRESS1` (`C_ADDR_ID` ASC) ,
+ CONSTRAINT `fk_CUSTOMER_ADDRESS1`
+ FOREIGN KEY (`C_ADDR_ID` )
+ REFERENCES `tpcw`.`address` (`ADDR_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`orders`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`orders` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`orders` (
+ `O_ID` INT NOT NULL AUTO_INCREMENT ,
+ `O_C_ID` INT NOT NULL ,
+ `O_DATE` DATETIME NULL ,
+ `O_SUB_TOTAL` INT NULL ,
+ `O_TAX` INT NULL ,
+ `O_TOTAL` INT NULL ,
+ `O_SHIP_TYPE` VARCHAR(10) NULL ,
+ `O_SHIP_DATE` DATETIME NULL ,
+ `O_BILL_ADDR_ID` INT NOT NULL ,
+ `O_SHIP_ADDR_ID` INT NOT NULL ,
+ `O_STATUS` VARCHAR(15) NULL ,
+ PRIMARY KEY (`O_ID`) ,
+ INDEX `fk_ORDERS_CUSTOMER1` (`O_C_ID` ASC) ,
+ INDEX `fk_ORDERS_ADDRESS1` (`O_BILL_ADDR_ID` ASC) ,
+ INDEX `fk_ORDERS_ADDRESS2` (`O_SHIP_ADDR_ID` ASC) ,
+ CONSTRAINT `fk_ORDERS_CUSTOMER1`
+ FOREIGN KEY (`O_C_ID` )
+ REFERENCES `tpcw`.`customer` (`C_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION,
+ CONSTRAINT `fk_ORDERS_ADDRESS1`
+ FOREIGN KEY (`O_BILL_ADDR_ID` )
+ REFERENCES `tpcw`.`address` (`ADDR_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION,
+ CONSTRAINT `fk_ORDERS_ADDRESS2`
+ FOREIGN KEY (`O_SHIP_ADDR_ID` )
+ REFERENCES `tpcw`.`address` (`ADDR_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`order_line`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`order_line` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`order_line` (
+ `OL_ID` INT NOT NULL ,
+ `OL_O_ID` INT NOT NULL ,
+ `OL_I_ID` INT NOT NULL ,
+ `OL_QTY` INT NULL ,
+ `OL_DISCOUNT` INT NULL ,
+ `OL_COMMENT` VARCHAR(100) NULL ,
+ PRIMARY KEY (`OL_ID`) ,
+ INDEX `fk_ORDER_LINE_ITEM1` (`OL_I_ID` ASC) ,
+ INDEX `fk_ORDER_LINE_ORDERS1` (`OL_O_ID` ASC) ,
+ CONSTRAINT `fk_ORDER_LINE_ITEM1`
+ FOREIGN KEY (`OL_I_ID` )
+ REFERENCES `tpcw`.`item` (`I_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION,
+ CONSTRAINT `fk_ORDER_LINE_ORDERS1`
+ FOREIGN KEY (`OL_O_ID` )
+ REFERENCES `tpcw`.`orders` (`O_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`cc_xacts`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`cc_xacts` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`cc_xacts` (
+ `CX_O_ID` INT NOT NULL AUTO_INCREMENT ,
+ `CX_TYPE` VARCHAR(10) NULL ,
+ `CX_NUM` INT NULL ,
+ `CX_NAME` VARCHAR(31) NULL ,
+ `CX_EXPIRY` DATE NULL ,
+ `CX_AUTH_ID` VARCHAR(15) NULL ,
+ `CX_XACT_AMT` DECIMAL(15,2) NULL ,
+ `CX_XACT_DATE` DATETIME NULL ,
+ `CX_CO_ID` INT NOT NULL ,
+ INDEX `fk_CC_XACTS_ORDERS` (`CX_O_ID` ASC) ,
+ INDEX `fk_CC_XACTS_COUNTRY` (`CX_CO_ID` ASC) ,
+ CONSTRAINT `fk_CC_XACTS_ORDERS`
+ FOREIGN KEY (`CX_O_ID` )
+ REFERENCES `tpcw`.`orders` (`O_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION,
+ CONSTRAINT `fk_CC_XACTS_COUNTRY`
+ FOREIGN KEY (`CX_CO_ID` )
+ REFERENCES `tpcw`.`country` (`CO_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`shopping_cart`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`shopping_cart` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`shopping_cart` (
+ `SC_ID` INT NOT NULL AUTO_INCREMENT ,
+ `SC_TIME` TIMESTAMP NULL ,
+ PRIMARY KEY (`SC_ID`) )
+ENGINE = InnoDB;
+
+
+-- -----------------------------------------------------
+-- Table `tpcw`.`shopping_cart_line`
+-- -----------------------------------------------------
+DROP TABLE IF EXISTS `tpcw`.`shopping_cart_line` ;
+
+CREATE TABLE IF NOT EXISTS `tpcw`.`shopping_cart_line` (
+ `SCL_SC_ID` INT NOT NULL AUTO_INCREMENT ,
+ `SCL_QTY` INT NULL ,
+ `SCL_I_ID` INT NOT NULL ,
+ PRIMARY KEY (`SCL_SC_ID`) ,
+ INDEX `fk_shopping_cart_line_item1` (`SCL_I_ID` ASC) ,
+ CONSTRAINT `fk_shopping_cart_line_item1`
+ FOREIGN KEY (`SCL_I_ID` )
+ REFERENCES `tpcw`.`item` (`I_ID` )
+ ON DELETE NO ACTION
+ ON UPDATE NO ACTION)
+ENGINE = InnoDB;
+
+
+
+SET SQL_MODE=@OLD_SQL_MODE;
+SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
+SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;