ilyosdev / php-rest-slim4-skleton

MIT License
2 stars 1 forks source link

Database qani #1

Open sarvarbek6066 opened 3 years ago

sarvarbek6066 commented 3 years ago

DB file yo`qmi

sarvarbek6066 commented 3 years ago

-- Table structure for notes


DROP TABLE IF EXISTS notes; CREATE TABLE notes ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL, description text, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


-- Records of notes


INSERT INTO notes (id, name, description) VALUES ('1', 'My Note 1', 'My first online note'); INSERT INTO notes (id, name, description) VALUES ('2', 'Chinese Proverb', 'Those who say it can not be done, should not interrupt those doing it.'); INSERT INTO notes (id, name, description) VALUES ('3', 'Long Note 3', 'This is a very large note, or maybe not...'); INSERT INTO notes (id, name, description) VALUES ('4', 'Napoleon Hill', 'Whatever the mind of man can conceive and believe, it can achieve.'); INSERT INTO notes (id, name, description) VALUES ('5', 'Note 5', 'A Random Note');

INSERT INTO notes (name, description) VALUES ('Brian Tracy', 'Develop an attitude of gratitude, and give thanks for everything that happens to you, knowing that every step forward is a step toward achieving something bigger and better than your current situation.'), ('Zig Ziglar', 'Your attitude, not your aptitude, will determine your altitude.'), ('William James', 'The greatest discovery of my generation is that a human being can alter his life by altering his attitudes.'), ('Og Mandino', 'Take the attitude of a student, never be too big to ask questions, never know too much to learn something new.'), ('Earl Nightingale', 'Our attitude towards others determines their attitude towards us.'), ('Norman Vincent Peale', 'Watch your manner of speech if you wish to develop a peaceful state of mind. Start each day by affirming peaceful, contented and happy attitudes and your days will tend to be pleasant and successful.'), ('W. Clement Stone', 'There is little difference in people, but that little difference makes a big difference. The little difference is attitude. The big difference is whether it is positive or negative.'), ('Dale Carnegie', 'Happiness does not depend on any external conditions, it is governed by our mental attitude.'), ('Walt Disney', 'If you can dream it, you can do it.'), ('William Shakespeare', 'Our doubts are traitors and make us lose the good we oft might win by fearing to attempt.'), ('Albert Einstein', 'A person who never made a mistake never tried anything new.');