Skip to content

Commit 513f3bd

Browse files
author
hussienalrubaye
committed
android twitter app
1 parent fee5bdc commit 513f3bd

118 files changed

Lines changed: 4093 additions & 0 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎TwitterApp/DBScript.sql‎

Lines changed: 39 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,39 @@
1+
drop database twitter;
2+
create database twitter;
3+
use twitter;
4+
5+
create table login(
6+
user_id int AUTO_INCREMENT PRIMARY KEY,
7+
first_name varchar(50),
8+
email varchar(50),
9+
password varchar(50),
10+
picture_path varchar(350)
11+
);
12+
describe login;
13+
14+
create table following(
15+
user_id int ,
16+
following_user_id int,
17+
FOREIGN KEY (user_id) REFERENCES login(user_id),
18+
FOREIGN KEY (following_user_id) REFERENCES login(user_id)
19+
);
20+
describe following;
21+
22+
create table tweets(
23+
tweet_id int AUTO_INCREMENT PRIMARY KEY,
24+
user_id int ,
25+
tweet_text varchar(50),
26+
tweet_picture varchar(350),
27+
tweet_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
28+
FOREIGN KEY (user_id) REFERENCES login(user_id)
29+
);
30+
describe tweets;
31+
32+
CREATE VIEW user_tweets AS
33+
SELECT tweets.tweet_id ,tweets.tweet_text,tweets.tweet_picture,
34+
tweets.tweet_date,tweets.user_id,login.first_name,login.picture_path
35+
FROM tweets
36+
inner join login
37+
on tweets.user_id =login.user_id;
38+
describe user_tweets;
39+

‎TwitterApp/TwitterDem/.gitignore‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
*.iml
2+
.gradle
3+
/local.properties
4+
/.idea/workspace.xml
5+
/.idea/libraries
6+
.DS_Store
7+
/build
8+
/captures
9+
.externalNativeBuild

‎TwitterApp/TwitterDem/.idea/compiler.xml‎

Lines changed: 22 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎TwitterApp/TwitterDem/.idea/copyright/profiles_settings.xml‎

Lines changed: 3 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎TwitterApp/TwitterDem/.idea/encodings.xml‎

Lines changed: 6 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎TwitterApp/TwitterDem/.idea/gradle.xml‎

Lines changed: 19 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎TwitterApp/TwitterDem/.idea/misc.xml‎

Lines changed: 49 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎TwitterApp/TwitterDem/.idea/modules.xml‎

Lines changed: 9 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎TwitterApp/TwitterDem/.idea/runConfigurations.xml‎

Lines changed: 12 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

‎TwitterApp/TwitterDem/app/.gitignore‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
/build

0 commit comments

Comments
 (0)