• R/O
  • SSH
  • HTTPS

instalikes: Commit


Commit MetaInfo

Revision13 (tree)
Zeit2019-11-26 23:33:11
Autorderekwildstar

Log Message

Incluída a tabela de parâmetros com um parâmetro que identifica a versão do banco de dados

Ändern Zusammenfassung

Diff

--- trunk/dev/dba/InstaLikes.sql (revision 12)
+++ trunk/dev/dba/InstaLikes.sql (revision 13)
@@ -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
13 CREATE SCHEMA IF NOT EXISTS instalikes CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI;
24
35 USE instalikes;
@@ -38,4 +40,14 @@
3840 ,publishedat DATETIME NOT NULL
3941 ,userid VARCHAR(20) CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_CI NOT NULL
4042 ,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
--- trunk/prj/InstaLikes.dproj (revision 12)
+++ trunk/prj/InstaLikes.dproj (revision 13)
@@ -7,7 +7,7 @@
77 <Base>True</Base>
88 <Config Condition="'$(Config)'==''">Debug</Config>
99 <Platform Condition="'$(Platform)'==''">Win32</Platform>
10- <TargetedPlatforms>1</TargetedPlatforms>
10+ <TargetedPlatforms>3</TargetedPlatforms>
1111 <AppType>Application</AppType>
1212 </PropertyGroup>
1313 <PropertyGroup Condition="'$(Config)'=='Base' or '$(Base)'!=''">
@@ -34,6 +34,12 @@
3434 <Cfg_1>true</Cfg_1>
3535 <Base>true</Base>
3636 </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>
3743 <PropertyGroup Condition="'$(Config)'=='Release' or '$(Cfg_2)'!=''">
3844 <Cfg_2>true</Cfg_2>
3945 <CfgParent>Base</CfgParent>
@@ -45,6 +51,12 @@
4551 <Cfg_2>true</Cfg_2>
4652 <Base>true</Base>
4753 </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>
4860 <PropertyGroup Condition="'$(Base)'!=''">
4961 <DCC_DcuOutput>..\bin\dcu</DCC_DcuOutput>
5062 <DCC_ExeOutput>..\bin\</DCC_ExeOutput>
@@ -75,6 +87,11 @@
7587 </PropertyGroup>
7688 <PropertyGroup Condition="'$(Base_Win64)'!=''">
7789 <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>
7895 </PropertyGroup>
7996 <PropertyGroup Condition="'$(Cfg_1)'!=''">
8097 <DCC_Define>DEBUG;$(DCC_Define)</DCC_Define>
@@ -89,6 +106,10 @@
89106 <AppEnableRuntimeThemes>true</AppEnableRuntimeThemes>
90107 <AppDPIAwarenessMode>PerMonitor</AppDPIAwarenessMode>
91108 </PropertyGroup>
109+ <PropertyGroup Condition="'$(Cfg_1_Win64)'!=''">
110+ <AppEnableRuntimeThemes>true</AppEnableRuntimeThemes>
111+ <AppDPIAwarenessMode>PerMonitorV2</AppDPIAwarenessMode>
112+ </PropertyGroup>
92113 <PropertyGroup Condition="'$(Cfg_2)'!=''">
93114 <DCC_LocalDebugSymbols>false</DCC_LocalDebugSymbols>
94115 <DCC_Define>RELEASE;$(DCC_Define)</DCC_Define>
@@ -101,6 +122,10 @@
101122 <AppDPIAwarenessMode>PerMonitor</AppDPIAwarenessMode>
102123 <Icon_MainIcon>..\res\InstaLikes.ico</Icon_MainIcon>
103124 </PropertyGroup>
125+ <PropertyGroup Condition="'$(Cfg_2_Win64)'!=''">
126+ <AppEnableRuntimeThemes>true</AppEnableRuntimeThemes>
127+ <AppDPIAwarenessMode>PerMonitorV2</AppDPIAwarenessMode>
128+ </PropertyGroup>
104129 <ItemGroup>
105130 <DelphiCompile Include="$(MainSource)">
106131 <MainSource>MainSource</MainSource>
@@ -909,7 +934,7 @@
909934 </Deployment>
910935 <Platforms>
911936 <Platform value="Win32">True</Platform>
912- <Platform value="Win64">False</Platform>
937+ <Platform value="Win64">True</Platform>
913938 </Platforms>
914939 </BorlandProject>
915940 <ProjectFileVersion>12</ProjectFileVersion>
Show on old repository browser