| 1 |
DROP TABLE test; |
|---|
| 2 |
|
|---|
| 3 |
CREATE TABLE `test` ( |
|---|
| 4 |
`ID` int(11) NOT NULL auto_increment, |
|---|
| 5 |
`url` blob NOT NULL, |
|---|
| 6 |
`name` blob, |
|---|
| 7 |
`createDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
|---|
| 8 |
`lastMod` timestamp NOT NULL default '0000-00-00 00:00:00', |
|---|
| 9 |
`submitter` varchar(16) NOT NULL default '', |
|---|
| 10 |
`groupid` int(11) default NULL, |
|---|
| 11 |
`isPrivate` tinyint(4) default NULL, |
|---|
| 12 |
PRIMARY KEY (`ID`), |
|---|
| 13 |
KEY `submitter_idx` (`submitter`), |
|---|
| 14 |
KEY `isPrivate_idx` (`isPrivate`), |
|---|
| 15 |
KEY `createDate_idx` (`createDate`) |
|---|
| 16 |
); |
|---|
| 17 |
|
|---|
| 18 |
INSERT INTO test VALUES (2,'http%3A%2F%2Fwww.jm3.net%2F','jm3.net','2002-03-03 18:35:47','2002-03-04 16:27:23','jm3',13,NULL); |
|---|
| 19 |
INSERT INTO test VALUES (74,'https%3A%2F%2Fsecure.centura.openbank.com%2Fcentura%2Fclicgi%2Fcgi-bin%2FaccntSum','bank','2002-03-24 22:52:41','2002-06-07 14:21:10','jm3',12,NULL); |
|---|
| 20 |
INSERT INTO test VALUES (56,'http%3A%2F%2Fsourceforge.net%2Fprojects%2Fcetools%2F','maynard%27s+CETools','2002-03-10 15:05:15','2002-05-02 20:52:53','jm3',22,NULL); |
|---|
| 21 |
INSERT INTO test VALUES (57,'http%3A%2F%2Fwww.simplemachines.net%2Ftsunamilyrics.html','lyrics+for+Tsunami+%3A+Deep+End','2002-03-10 16:51:44','2002-06-21 17:06:50','jm3',102,NULL); |
|---|
| 22 |
INSERT INTO test VALUES (12944,'http%3A%2F%2Fnytimes.com%2F2004%2F02%2F01%2Fnyregion%2F01radio.html%3F8hpib','vintage+radio+WSNJ+turns+off+the+transmitter','2004-02-01 17:12:02','2004-02-01 17:12:02','pheezy',803,NULL); |
|---|
| 23 |
INSERT INTO test VALUES (55,'http%3A%2F%2Fbetapop.com%2F','bruce+marsh+%3A+betapop','2004-09-11 18:35:39','2002-05-09 02:12:08','jm3',23,1); |
|---|
| 24 |
INSERT INTO test VALUES (65,'http%3A%2F%2Fwww.ferryhalim.com%2Forisinal%2F','flash+portfolio+site','2002-03-18 11:43:57','2002-03-18 11:43:57','jm3',NULL,NULL); |
|---|
| 25 |
INSERT INTO test VALUES (12942,'http%3A%2F%2Fwww.dvd250.com%2Findex.shtml','top+250+DVD+websites','2004-02-01 15:42:18','2004-02-01 15:42:18','jm3',184,NULL); |
|---|
| 26 |
INSERT INTO test VALUES (12943,'http%3A%2F%2Fjm3.net%2Ftodo%2Flook-at-these-sites.html','scratch+software','2004-04-23 19:06:49','2004-02-01 18:14:12','jm3',802,1); |
|---|
| 27 |
INSERT INTO test VALUES (45,'http%3A%2F%2Fwww.fictive.org%2F%7Epeter%2Fbits%2F','bits+%26+pieces','2002-03-04 17:43:25','2004-02-01 12:59:45','nickyd',795,NULL); |
|---|
| 28 |
INSERT INTO test VALUES (49,'http%3A%2F%2Fguir.berkeley.edu%2Fprojects%2Fdenim%2F','DENIM+and+SILK','2002-03-10 14:31:52','2002-03-10 14:56:03','jm3',22,NULL); |
|---|
| 29 |
INSERT INTO test VALUES (50,'http%3A%2F%2Fmutt.org%2Fdoc%2Fmanual%2F','mutt+manual','2002-03-10 14:31:52','2002-05-29 11:36:30','jm3',12,NULL); |
|---|
| 30 |
INSERT INTO test VALUES (51,'http%3A%2F%2Fwww.jwz.org%2Fgruntle%2F','jwz+rants','2002-03-11 14:45:21','2002-06-07 14:21:46','jm3',NULL,NULL); |
|---|
| 31 |
INSERT INTO test VALUES (58,'http%3A%2F%2Fcodewhore.com%2F','codewhore','2002-03-12 13:37:37','2002-03-12 13:37:37','jm3',22,NULL); |
|---|
| 32 |
INSERT INTO test VALUES (59,'http%3A%2F%2Fwww.mapmart.com%2Fvec_24main.htm','aerial+photos','2002-03-13 14:22:22','2002-08-23 17:16:41','jm3',150,NULL); |
|---|
| 33 |
INSERT INTO test VALUES (60,'http%3A%2F%2Fwww.mintekdigital.com%2Fproducts%2Fdvd2580.htm','brad%27s+dvd+player','2002-03-13 14:22:22','2002-06-07 13:47:43','jm3',88,NULL); |
|---|
| 34 |
|
|---|
