Revision | 13 (tree) |
---|---|
Time | 2019-11-26 23:33:11 |
Author | derekwildstar |
Incluída a tabela de parâmetros com um parâmetro que identifica a versão do banco de dados
@@ -1,3 +1,5 @@ | ||
1 | +-- AO ALTERAR ESTE SCRIPT, NÃO ESQUEÇA DE ALTERAR TAMBÉM A INSERÇÃO DO PARÂMETRO "VERSION" | |
2 | +-- NA TABELA PARAMETERS | |
1 | 3 | CREATE SCHEMA IF NOT EXISTS instalikes CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI; |
2 | 4 | |
3 | 5 | USE instalikes; |
@@ -38,4 +40,14 @@ | ||
38 | 40 | ,publishedat DATETIME NOT NULL |
39 | 41 | ,userid VARCHAR(20) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI NOT NULL |
40 | 42 | ,PRIMARY KEY (id) |
41 | - ,CONSTRAINT user_media_fk FOREIGN KEY (userid) REFERENCES user (id) ON UPDATE CASCADE ON DELETE CASCADE) ENGINE=INNODB CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI; | |
\ No newline at end of file | ||
43 | + ,CONSTRAINT user_media_fk FOREIGN KEY (userid) REFERENCES user (id) ON UPDATE CASCADE ON DELETE CASCADE) ENGINE=INNODB CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI; | |
44 | + | |
45 | +DROP TABLE IF EXISTS parameters; | |
46 | + | |
47 | +CREATE TABLE parameters (id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT | |
48 | + ,name VARCHAR(40) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI NOT NULL | |
49 | + ,value TEXT CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI NULL | |
50 | + ,PRIMARY KEY (id) | |
51 | + ,UNIQUE INDEX name_uc (name)) ENGINE=INNODB CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI; | |
52 | + | |
53 | +INSERT INTO parameters (name, value) values ('version','1'); | |
\ No newline at end of file |
@@ -7,7 +7,7 @@ | ||
7 | 7 | <Base>True</Base> |
8 | 8 | <Config Condition="'$(Config)'==''">Debug</Config> |
9 | 9 | <Platform Condition="'$(Platform)'==''">Win32</Platform> |
10 | - <TargetedPlatforms>1</TargetedPlatforms> | |
10 | + <TargetedPlatforms>3</TargetedPlatforms> | |
11 | 11 | <AppType>Application</AppType> |
12 | 12 | </PropertyGroup> |
13 | 13 | <PropertyGroup Condition="'$(Config)'=='Base' or '$(Base)'!=''"> |
@@ -34,6 +34,12 @@ | ||
34 | 34 | <Cfg_1>true</Cfg_1> |
35 | 35 | <Base>true</Base> |
36 | 36 | </PropertyGroup> |
37 | + <PropertyGroup Condition="('$(Platform)'=='Win64' and '$(Cfg_1)'=='true') or '$(Cfg_1_Win64)'!=''"> | |
38 | + <Cfg_1_Win64>true</Cfg_1_Win64> | |
39 | + <CfgParent>Cfg_1</CfgParent> | |
40 | + <Cfg_1>true</Cfg_1> | |
41 | + <Base>true</Base> | |
42 | + </PropertyGroup> | |
37 | 43 | <PropertyGroup Condition="'$(Config)'=='Release' or '$(Cfg_2)'!=''"> |
38 | 44 | <Cfg_2>true</Cfg_2> |
39 | 45 | <CfgParent>Base</CfgParent> |
@@ -45,6 +51,12 @@ | ||
45 | 51 | <Cfg_2>true</Cfg_2> |
46 | 52 | <Base>true</Base> |
47 | 53 | </PropertyGroup> |
54 | + <PropertyGroup Condition="('$(Platform)'=='Win64' and '$(Cfg_2)'=='true') or '$(Cfg_2_Win64)'!=''"> | |
55 | + <Cfg_2_Win64>true</Cfg_2_Win64> | |
56 | + <CfgParent>Cfg_2</CfgParent> | |
57 | + <Cfg_2>true</Cfg_2> | |
58 | + <Base>true</Base> | |
59 | + </PropertyGroup> | |
48 | 60 | <PropertyGroup Condition="'$(Base)'!=''"> |
49 | 61 | <DCC_DcuOutput>..\bin\dcu</DCC_DcuOutput> |
50 | 62 | <DCC_ExeOutput>..\bin\</DCC_ExeOutput> |
@@ -75,6 +87,11 @@ | ||
75 | 87 | </PropertyGroup> |
76 | 88 | <PropertyGroup Condition="'$(Base_Win64)'!=''"> |
77 | 89 | <DCC_UsePackage>DBXSqliteDriver;DBXInterBaseDriver;vclactnband;vclFireDAC;tethering;FireDACADSDriver;vcltouch;vcldb;bindcompfmx;inetdb;FmxTeeUI;fmx;fmxdae;dbexpress;IndyCore;vclx;dsnap;VCLRESTComponents;vclie;bindengine;DBXMySQLDriver;FireDACMySQLDriver;FireDACCommonODBC;UIRibbonPackageDR;IndyIPCommon;bindcompdbx;vcl;IndyIPServer;IndySystem;dsnapcon;FireDACMSAccDriver;fmxFireDAC;vclimg;TeeDB;FireDACPgDriver;FMXTee;DbxCommonDriver;Tee;xmlrtl;fmxobj;vclwinx;rtl;DbxClientDriver;CustomIPTransport;vcldsnap;bindcomp;appanalytics;IndyIPClient;bindcompvcl;TeeUI;dbxcds;VclSmp;adortl;dsnapxml;dbrtl;IndyProtocols;inetdbxpress;fmxase;$(DCC_UsePackage)</DCC_UsePackage> |
90 | + <DCC_Namespace>Winapi;System.Win;Data.Win;Datasnap.Win;Web.Win;Soap.Win;Xml.Win;$(DCC_Namespace)</DCC_Namespace> | |
91 | + <BT_BuildType>Debug</BT_BuildType> | |
92 | + <VerInfo_Keys>CompanyName=;FileDescription=$(MSBuildProjectName);FileVersion=1.0.0.0;InternalName=;LegalCopyright=;LegalTrademarks=;OriginalFilename=;ProgramID=com.embarcadero.$(MSBuildProjectName);ProductName=$(MSBuildProjectName);ProductVersion=1.0.0.0;Comments=</VerInfo_Keys> | |
93 | + <VerInfo_Locale>1033</VerInfo_Locale> | |
94 | + <Manifest_File>$(BDS)\bin\default_app.manifest</Manifest_File> | |
78 | 95 | </PropertyGroup> |
79 | 96 | <PropertyGroup Condition="'$(Cfg_1)'!=''"> |
80 | 97 | <DCC_Define>DEBUG;$(DCC_Define)</DCC_Define> |
@@ -89,6 +106,10 @@ | ||
89 | 106 | <AppEnableRuntimeThemes>true</AppEnableRuntimeThemes> |
90 | 107 | <AppDPIAwarenessMode>PerMonitor</AppDPIAwarenessMode> |
91 | 108 | </PropertyGroup> |
109 | + <PropertyGroup Condition="'$(Cfg_1_Win64)'!=''"> | |
110 | + <AppEnableRuntimeThemes>true</AppEnableRuntimeThemes> | |
111 | + <AppDPIAwarenessMode>PerMonitorV2</AppDPIAwarenessMode> | |
112 | + </PropertyGroup> | |
92 | 113 | <PropertyGroup Condition="'$(Cfg_2)'!=''"> |
93 | 114 | <DCC_LocalDebugSymbols>false</DCC_LocalDebugSymbols> |
94 | 115 | <DCC_Define>RELEASE;$(DCC_Define)</DCC_Define> |
@@ -101,6 +122,10 @@ | ||
101 | 122 | <AppDPIAwarenessMode>PerMonitor</AppDPIAwarenessMode> |
102 | 123 | <Icon_MainIcon>..\res\InstaLikes.ico</Icon_MainIcon> |
103 | 124 | </PropertyGroup> |
125 | + <PropertyGroup Condition="'$(Cfg_2_Win64)'!=''"> | |
126 | + <AppEnableRuntimeThemes>true</AppEnableRuntimeThemes> | |
127 | + <AppDPIAwarenessMode>PerMonitorV2</AppDPIAwarenessMode> | |
128 | + </PropertyGroup> | |
104 | 129 | <ItemGroup> |
105 | 130 | <DelphiCompile Include="$(MainSource)"> |
106 | 131 | <MainSource>MainSource</MainSource> |
@@ -909,7 +934,7 @@ | ||
909 | 934 | </Deployment> |
910 | 935 | <Platforms> |
911 | 936 | <Platform value="Win32">True</Platform> |
912 | - <Platform value="Win64">False</Platform> | |
937 | + <Platform value="Win64">True</Platform> | |
913 | 938 | </Platforms> |
914 | 939 | </BorlandProject> |
915 | 940 | <ProjectFileVersion>12</ProjectFileVersion> |